Platonic - I looked at your spreadsheet and to say I am overwhelmed with info is an understatement. So looking at it can you tell me what the best option is for lighting for a 40X60 shop?
Need more info about what you feel is important. Ceiling height would be a good start too.
The spreadsheet is all about providing a means to determine the best bang for the buck ballast and lamp combination depending on your particular needs/desires. At the same time we all needed to know how the new technology LED retrofit lamps and fixtures relate to current fluorescent technology. If you want the exact lamp/ballast combination listed and you purchase a $30 strip light to gut and update, add the $30 strip light cost to the green block and resort by the field of your choice. Or maybe you just want to get more lumens out of your existing fixtures.
If your primary goal is:
Maximum light output per fixture to reduce the number of fixtures you need to install, sort by lumen output.
Energy efficiency, sort by Lumens per Watt.
Lifetime cost, sort by Lumens x yr/$ (higher number is better).
Low maintenance, sort by Life Yrs.
Low temperature starting can’t be sorted, but I think the color code is obvious.
Keep in mind that this is the short list. I started with the 58 page Sylvania quicksystem performance guide linked in the spreadsheet notes. There’s no one single correct answer as every scenario is different in size, temperature, local electricity rates,…
The preface to the spreadsheet is in this thread:
The Best Light Fixture Ever
Do a search here in the electrical section, or just page down a ways and you should be able find other discussions.