DiyLightAnimation

Hardware => Lynx Smart String => Topic started by: mmulvenna on January 15, 2011,

Title: Smart String Calculator
Post by: mmulvenna on January 15, 2011,
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
Title: Re: Smart String Calculator
Post by: tng5737 on January 15, 2011,
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
Title: Re: Smart String Calculator
Post by: vairmoose on January 15, 2011,
You are not allowed to view links. Register or Login
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
     
Title: Re: Smart String Calculator
Post by: mmulvenna on January 16, 2011,
You are not allowed to view links. Register or Login
You are not allowed to view links. Register or Login
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.

Title: Re: Smart String Calculator
Post by: mmulvenna on January 16, 2011,
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.
Title: Re: Smart String Calculator
Post by: mmulvenna on January 16, 2011,
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..

http://diylightanimation.com/index.php?topic=4458.0;topicseen



Again my sincere apologies to Trepidati0n :-[ :-[ :-[ :-[ :-[ :-[

Mike
Title: Re: Smart String Calculator
Post by: Trepidati0n on January 17, 2011,
Bring out the pitchforks I say!  Oh wait....bring out the blinky!  There is always room for different ways to look at a problem.  :D
Title: Re: Smart String Calculator
Post by: TheBanker on January 17, 2011,
Man this could get quite expensive, couldn't it?
Title: Re: Smart String Calculator
Post by: Trepidati0n on January 17, 2011,
You are not allowed to view links. Register or Login
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.   >.d9
Title: Re: Smart String Calculator
Post by: CaptKirk on January 19, 2011,
You are not allowed to view links. Register or Login
You are not allowed to view links. Register or Login
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.   >.d9

Can we add THAT calculation to the spreadsheet??   <yk..
Title: Re: Smart String Calculator
Post by: TheBanker on January 23, 2011,
You are not allowed to view links. Register or Login
You are not allowed to view links. Register or Login
You are not allowed to view links. Register or Login
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.   >.d9

Can we add THAT calculation to the spreadsheet??   <yk..


 <md..