Jump to content
Light-O-Rama Forums
Sign in to follow this  
Guest guest

Controller Load Calculator

Recommended Posts

Guest guest

I have worked on the spreadsheet today and noticed a slight difference of numbers with maybe amps, lights or what ever. I adjusted my actual light strand numbers to what he initially entered and all worked out great. There will be some slight difference to strands of lights, rope lights/amps & such (there are too many different kinds to choose from) so if you change your numbers of lights/amps per strand, per channel to meet your actual set-up, then all that matters is that the spread sheet will add it all up for you. That's a big help right there.

Thanks a bunch Rick.

Tom

Share this post


Link to post
Share on other sites
Guest guest

Rick,

Nice spreadsheet, Excellent work

I was playing with it tonight, in the totals total Bulbs, r3 and q3 should sum row J not I

Great work on it still the same.

I found one error in my light counts so far which your sheet showed red, after I looked at it again it was definately red, so it likely saved me a fuse *SMILE*

Share this post


Link to post
Share on other sites
Guest guest

DownTown wrote:

Hey Rick - Great spread sheet. I just started fooling with it and I'm curious where you're getting your numbers from. I enter a light type of "Mini 100", qty strings = 3, lights per string = 100, and power applied = 100%. By my calculations I should come up with somewhere between .99 and 1.02 amps. I think we typically assume that 100 minis consume 1/3 of an amp at 100% power. The spreadsheet shows only .63 amps, or .21 amps per string of 100 minis. Can you shed some light (pun intended :laughing:) ?

Thanks for the work on the spreadsheet.

D.T.


I Checked the calculations, and I can't find what you are pointing out?

my calculations are: WATTSXQTY/VOLTAGE=AMPS (I=P/V)

In the case of the minis, I am using .25 watts .25x100=25(P)/120(V)=.2083 (I)(.21 Amps)

The light inventory page is intended for the USER to add their own inventory (Light Name, Watts, Qty) what is listed is my own inventory and can be assumed to be different from everyone else, like the Channel 1 data I included.

Sorry, it's late and maybe I don't see the error.......

-Rick-

Share this post


Link to post
Share on other sites
Guest guest

Rick, on the "Light Types" worksheet, row 4, you have a rope light defined. Is that an incandescent rope light or an LED rope light?

There is a big difference between the two, and we might want to have both listed, as those of us who are multi billionares are starting to acquire LED rope lights.

I just today received an awesome 30 foot rool of red LED rope light that I won on eBay for $39.95, a HUGE bargain in this day of 150' reels going for $500!

The red LED rope light that I got appears to be far superior to other "colored plastic" LED rope lights. This rope is actually clear and the LEDs come on BRIGHT red, much brighter than my lamp Ropes. Some of the expert sellers I see online frown down on the colored plastic LED rope lights, claiming they are not as good.

My LED rope light has some confusing specs on the box, but translated from Chinese, it says 6.5 V, 70 mA. It's hard to say if they are trying to tell us the max current the rope can handle, or if it is the steaady state current of the LED light rope.

If I can ge tmore of these, I'll ditch my rope lights in a heartbeat, they are the single worst draw of power there is.

Some of my 2' x 3' rope light displays draw up to an amp. That's just way too much, and overloads my circuits quickly.

BTW, anyone know if there is some kind of small meter box we can buy that you just plug in a strand of lights and it tells you the current draw?

Share this post


Link to post
Share on other sites
Guest guest

jeffostroff wrote:

BTW, anyone know if there is some kind of small meter box we can buy that you just plug in a strand of lights and it tells you the current draw?

Yep. Using an A/C line splitter and a Clamp Meter I was able to get pretty darn exact numbers on my strands.

I like the chart, but it's why I'm having a hard time using it. I have some deer and trees (6ft white, like RichardH) in my display which I have no idea the wattage per bulb. It's much easier for me to simply input the amps per strand and move on.

Share this post


Link to post
Share on other sites
Guest guest

jeffostroff wrote:

BTW, anyone know if there is some kind of small meter box we can buy that you just plug in a strand of lights and it tells you the current draw?



Jeff

What you and everyone else who does any large Christmas display needs is an Clamp on AC current Multimeter current of 3.18 amps to .6. The only way I could have easily taken this measurement is with a clamp on meter.


I will post a pic of the extension cord a little bit later

Bill

Share this post


Link to post
Share on other sites
Guest guest

blearning wrote:

Rick,

Nice spreadsheet, Excellent work

I was playing with it tonight, in the totals total Bulbs, r3 and q3 should sum row J not I

Great work on it still the same.

I found one error in my light counts so far which your sheet showed red, after I looked at it again it was definately red, so it likely saved me a fuse *SMILE*




Your right!, nice catch.....
This will not effect any calculations, I checked the LINE Calc and that's looking in the correct place, I will place this on the new update.

-Rick-

Share this post


Link to post
Share on other sites
Guest guest

A new version of the Controller Calculator for 25 controllers is complete and is being beta tested now.



I have added options for 120/240 volts, ability to enter the inventory by amps or watts, a new controller overview that should help tremendously by displaying ALL controllers and channels on one page and the amperage drawn if any, all cells that require input have been relocated to the left of the worksheets, Help comments have been added.

Thanks for all the input from everyone, I have incorporated almost all requests that have been posted, I hope to have the new version up this week.

Thanks again everyone.

Share this post


Link to post
Share on other sites
Guest guest

ok, Bill Gates, now if you really want ot make this spreadsheet useful, make it so that every time I open it, it downloads the latest verion and upgrades itself automatically!

wouldn't that be choice dudes!

Share this post


Link to post
Share on other sites
Guest guest

jeffostroff wrote:

Rick, on the "Light Types" worksheet, row 4, you have a rope light defined. Is that an incandescent rope light or an LED rope light?





Remember, you can specify any kind of light and power consumption on the "light types" tab. So for the rope light, just change the power rating to be what you need, and the magic of excel updates all your calculations. You can also add new entries to the table, and they will show up as choices on the controller tabs.


The new beta has better oganization and is easier to use! Rick already told you what's on it, so I won't bother listing the changes. But, it's very exciting! You guys will love it. (Of course, I haven't had a chance to actually test it yet to see if it works....lol.)

Share this post


Link to post
Share on other sites
Guest guest

Thanks for taking the time to make this. It is very helpful

Share this post


Link to post
Share on other sites
Guest guest

Can anyone tell me what the data is for 300 light icycle lights?

Amps, watts, etc.

It's for this wonderful calculator.

Thanks!

Luke

Share this post


Link to post
Share on other sites
Guest guest

sHOULD BE THE SAME AS 300 REGULAR LIGHTS. i'LL TAKE A READING AND GET BACK TO YOU.

Share this post


Link to post
Share on other sites
Guest guest

RickWilliams wrote:

A new version of the Controller Calculator for 25 controllers is complete and is being beta tested now.


Rick,

Did you finish the sheet?

jeff

Share this post


Link to post
Share on other sites
Guest guest

That would be great. In the meantime, what is the amperage for 300?

Thanks again.

Share this post


Link to post
Share on other sites
Guest guest

I measured one of my reels of clear lights with 3 strigs of 100 tied end to end.

It measured at .56 amp.

The power was 79 Watts

Share this post


Link to post
Share on other sites
Guest guest

Each string of lights come with a tag on the male plug that should state the amps of the string. I just checked on of my 100 string mini's and it is .34 Amp/40.8 Watts or 1.02 Amp/91 watts. verify if this tag is available.

Share this post


Link to post
Share on other sites
Guest guest

jeffmill wrote:

RickWilliams wrote:
A new version of the Controller Calculator for 25 controllers is complete and is being beta tested now.


Rick,

Did you finish the sheet?

jeff


The current version released is C2.2 (on the web site: controllers/display tools), I have an updated version that I am working on, Michael from LORsequences.com has been giving a tremendous amount of great feedback and suggestions, like what about eight channel controllers or variables for single power (20 Amp) for a 16 channel controller plus many others.

The new version is pretty cool, quite a few changes, but I'm still working on the single power source, this changes the dynamics of the calculator considerably and will take some time to resolve a way that is easy for a novice user to input basic information effortlessly, Plus I am now full gear into my display and sequencing for this season which is taking most of my time.

Share this post


Link to post
Share on other sites
Guest guest

I am new to this and a little confused right now.

Here is what I think I have read and understand about the two LOR1602W controllers.

1.) Each side of the controller can handle a maximum of 20 amps.

2.) You should never string more than three strands of lights together on one channel.

Now a question about the Load Calculator, I have Icicle lights with 300 bulbs per strand and the tag says LW-2 120V-0.51A 60HZ, How do I enter this into the light inventory?

Same question my strand lights (100 bulbs) tag says, 120v, 0.4a, 60hz

Thank you in advance for your help!

Share this post


Link to post
Share on other sites
Guest guest

1.) Each side of the controller can handle a maximum of 20 amps.
- CORRECT


2.) You should never string more than three strands of lights together on one channel.
- Let me rephrase this - Never connect more than three strand together, you can have multiple strands connected to one channel as long as it does not exceed 8 AMPS per channel


3) Icicle lights with 300 bulbs per strand and the tag says LW-2 120V-0.51A 60HZ

You would enter on Light Types Tab, Name of your string, .0017 (.51/300=.0017 each) in the amps and select AMPS from the drop down menu of POWER TYPE. For the 100 you would enter .004 for the amps.

Do the same for each Type of light you have.





Attached files 85300=5164-Calc Sample.bmp

Share this post


Link to post
Share on other sites
Guest guest

Thank you for the information! It is a great help. I really don't want to damage the controllers.

Share this post


Link to post
Share on other sites
Guest guest

Rick,

Thanks again for a great spreadsheet. It has really come in handy. Not only for load calc., but I printed each of the sheets and hung them by my controller and show PC. When I'm sequencing I just glance up at the sheets if I need a reminder about anything. It has been a really big help getting my display ready.

Happy Decorating,

jeff

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  

×
×
  • Create New...