I put in 126 nodes and 4 strings - it gave number of hubs as 0 If I understand it correctly you always need at least 1 hub
Easy to fix. In the cell that calculates the # of hubs... put in "=ROUNDUP(F6/16,0)" . That will fix that miscalculation.
One additional calculation that might be useful "=ROUNDUP(((J9*B8)/12 +(B9*J8))*12,0)" where B8 is the wattage per node, J9 is the number of nodes, B9 is the amperage per controller, and J8 is the number of controllers (one controlle3r per string). This will give you the total required wattage... This is total wattage needed, not the wattage needed per each hub as that will depend on how you have the strings spread over all (assuming more than one) hubs.
Based on what smart people have written in this forum, I'd suggest PSUs that are capable of 2x that requirement.
Larry