In the end it turned out the HPS bulb had 12,318 lumens worth of useful photosynthetic penetration. This beat the CMH bulb with 9,903 lumens worth of useful photosynthetic penetration; The HPS beating the CMH bulb by roughly 124% overall.
Do you mean 24%?
Predictably though, the CMH had a higher percentage of it's light used for photosynthesis, 28% of it's light used versus only 22% from the HPS.
Doesn't this contradict what you said above?
Looking at a narrower scope, just veg/flower colors, the HPS is 141% better at flowering then the CMH, producing 4935 useful lumens within the 600-700nm "butter zone" compared to the CMH's 3478 lumens.
This comes to 42%, not 141%.
The CMH had the HPS beat though for vegetative stage, 850% better at the 400-450 blue spectrum. The HPS only mustered 416 useful blue spectrum lumens, compared to the CMH 3514 lumens. Keep in mind though, this is a horticultural bulb with an enhanced spectrum, standard security light HPS would lose hands down to CMH.
The conclusion? It's still not clear. If you had to use a single bulb throughout the whole grow, the CMH may have the advantage because it handles the veg. stage so much better, while only trailing HPS during flowering. On the other hand, if you have the option of swapping out bulbs, you'll want to use the CMH for veg. and HPS for flowering. If your looking for the best possible light conditions, I would suggest one of each. What's interesting is the normal metal halides can easily push 110 lumens/watt. If they are to improve CMH technology in the future to make it more efficient while keeping the same spectrum, at that level it will beat out the HPS in all circumstances.
My personal opinion about CMH bulbs; I think they're the best artificial light source for growing yet, beating out HPS. The balanced spectrum plus UV light emitted from CMH bulbs has additional, unmeasured benefit for flowering cannabis. I'm convinced, but until someone compares the two in laboratory conditions a lot of people won't be. Your welcome to make your own conclusions.
If anyone wants to see my spreadsheet with all the numbers let me know i'll post it.