Folks,
Most of you are missing the forest for the trees. First, there is no final perfect number for percentages, like all things with reefs there are ranges.
Depending on the contexts...
Optimally, remove all the coarse stuff. One way to do that is to put some finer sand on it - about 1/2 inch at a time, until the bed is about 2 inches deep. The coarse stuff will gradually find its way to the top, where it can be removed with careful vacuuming or simply scooping.
I like oolitic sand. It is clean, the grains are rounded and the size distribution is good. But....
It ain't the only way to go. Any sand mix with a predominance of fines and very fines will work. From the descriptions the Home Depot stuff seems to fit pretty well. It has the decided advantage of being cheap. However, really, given the costs of stuff we put in our tanks, ESV's oolitic is a bargain.
Frankly, as far as the critters are concerned the substrate can be made of any material (I once investigated a very diverse community: 800 species and over 50,000 animals in a square meter. The substrate was 4% arsenic, 2% copper, 1% lead and other assorted metals by weight - it was slag from an arsenic smelter). The point being, if the sediment is predominantly reeeeeealllly fine stuff, the critters will thrive.
You want a mix of sand grain sizes with the majority in the very small and even smaller size fractions, but with a bit of smattering of larger sizes for diversity's sake. The absolute percentages are really immaterial, except you probably want less than 30 % to be greater that 0.250 mm in diameter.
The problem with most of the CaribSea mixes is a much too high a proportion of coarser stuff. They apparently are offering a new "oolitic" mix, but I have not seen it. If you use any of their mixes, you should be diluting it with a lot of fine stuff.
Now, in all of the various questions that are asked me, everybody wants to "save the life" in the coarse sand. Well, okay...
Personally, I would simply vacuum it all out and set up a fine sand bed - in one glorious afternoon of muck diving. Not a whole lot that finds a coarse sand/fine gravel bed attractive will even survive in a fine bed. You will have to seriously seed the fine bed, and frankly it is a whole lot less trouble to remove all the coarse stuff first. If you want to save the critters in it, lift the coarse stuff out to a bucket, then agitate it the bucket and pitch the sand, letting the critters collect in the bucket. Add the bucket contents to the newly set up fine sand bed.
If you get a lot of silt in the water, this is not a big deal. Any reef animal can withstand this, and can deal with it just fine. If they couldn't hurricanes would have wiped out reefs long ago.
Folks - everybody in this hobby seems to want a cook book approach. This ain't it. There is no perfect number to aspire to here - rather perfection is an over all mix that if you walked on it on a beach you would call "mud," but not gooey mud...
Cheers, Ron