Smart String Calculator

[mmulvenna]

Late for posting this but might help users in the future. Please feel free to poke holes and make suggestions for improvements.

Note, the string length is your string length not necessarily the order length

Thanks
Mike M

[tng5737]

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

[vairmoose]

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
     

[mmulvenna]

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
    

Thanks for the corrections and additions, that's what so great about this forum. I have updated the rounding error.
I will make the suggested addition later today.

[mmulvenna]

I have uploaded a new zip file with these changes

Added dongle price to be include in totals
Added calcs for AMPS and WATTS
Added cells for number of Power supplies
Locked the  calculated cells....just unprotect the sheet if you want to change anything   no password required


Thanks for the suggestions. As always feel free to post corrections or suggestions for improvements.

[mmulvenna]

My Apologies, I did not see Trepidati0n' s thread until it was updated today.
My old eyes of 63 years did not see it earlier. Although it may not look like it I did build my spreadsheet from scratch and copied nothing from Trepidati0n's.  

It is much more detailed than mine if you are calculating for a tree as mine is more generic for just calculating a generic environment..

You are not allowed to view links. Register or Login



Again my sincere apologies to Trepidati0n

Mike

[Trepidati0n]

Bring out the pitchforks I say!  Oh wait....bring out the blinky!  There is always room for different ways to look at a problem. 

[TheBanker]

Man this could get quite expensive, couldn't it?

[Trepidati0n]

Man this could get quite expensive, couldn't it?

Could get expensive.  I'm just using these calculators to figure out how many nights i'll be on the couch.   

[CaptKirk]

Man this could get quite expensive, couldn't it?

Could get expensive.  I'm just using these calculators to figure out how many nights i'll be on the couch.   

Can we add THAT calculation to the spreadsheet??   

[TheBanker]

Man this could get quite expensive, couldn't it?

Could get expensive.  I'm just using these calculators to figure out how many nights i'll be on the couch.   

Can we add THAT calculation to the spreadsheet??