Jump to content
Did you know?
  • The original Rudolph did not have a red nose. In that day and age, red noses were seen as an indicator of chronic alcoholism and Montgomery Ward didn’t want him to look like a drunkard. To complete the original picture, he was almost named Reginald or Rollo.
  • The Christmas wreath was originally hung as a symbol of Jesus. The holly represents his crown of thorns and the red berries the blood he shed.
  • The three traditional colors of most Christmas decorations are red, green and gold. Red symbolizes the blood of Christ, green symbolized life and rebirth, and gold represents light, royalty and wealth.
  • Tinsel was invented in 1610 in Germany and was once made of real silver.
  • The oldest artificial Christmas trees date back to the late 1800s and were made of green raffia (think grass hula skirts) or dyed goose feathers. Next the Addis Brush Company used their machinery that wove toilet brushes to create pine-like branches for artificial Christmas trees that were less flammable and could hold heavier decorations.
  • ‘Jingle Bells’ – the popular Christmas song was composed by James Pierpont in Massachusetts, America. It was, however, written for thanksgiving and not Christmas.
  • Coca-Cola was the first company that used Santa Claus during the winter season for promotion.
  • Hallmark introduced their first Christmas cards in 1915.
  • The first recorded date of Christmas being celebrated on December 25th was in 336, during the time of the Roman Emperor Constantine. A few years later, Pope Julius I officially declared that the birth of Jesus would be celebrated on that day.
  • Santa Claus's sleigh is led by eight reindeer: Dasher, Dancer, Prancer, Vixen, Comet, Cupid, Dunder (variously spelled Donder and Donner), and Blixem (variously spelled Blixen and Blitzen), with Rudolph being a 20th-century inclusion.
  • Outdoor Christmas lights on homes evolved from decorating the traditional Christmas tree and house with candles during the Christmas season. Lighting the tree with small candles dates back to the 17th century and originated in Germany before spreading to Eastern Europe.
  • That big, jolly man in the red suit with a white beard didn’t always look that way. Prior to 1931, Santa was depicted as everything from a tall gaunt man to a spooky-looking elf. He has donned a bishop's robe and a Norse huntsman's animal skin. When Civil War cartoonist Thomas Nast drew Santa Claus for Harper's Weekly in 1862, Santa was a small elflike figure who supported the Union. Nast continued to draw Santa for 30 years, changing the color of his coat from tan to the red he’s known for today.
  • Christmas 2018 countdown has already begun. Will you be ready???
  • Why do we love Christmas? It's all about the traditions. In this chaotic world we can miss the "good old days." Christmas reminds us of that time.
Sign in to follow this  
hobby1

Inventory Spreadsheet Ideas

Recommended Posts

Ok below is my controller spreadsheet. We will focus on channel one that is highlighted in red. You will notice QTY String says 3 and since they are minis they are 100 per strand. So since I have 3 strands of 100 count minis it shows 300 total lights on the right for that line which is correct. Now your total bulbs on the right towards the bottom below total watts with the red box is the total amount of bulbs for the whole controller. So if you add up all of the "total lights" in column K it will give you total bulbs which is correct. At least it is on mine.

controllervx8.png

Share this post


Link to post
Share on other sites

Yea, it is correct on yours, for some reason when I downloaded it, mine did not add up correctly. It was in a different column then the one it was adding up. Could it be because I am using open office and not MS office?

I can't get mine to print the screen, I'm on my laptop and that button doesn't seem to want to work. lol

Rob

Share this post


Link to post
Share on other sites

Yea, it is correct on yours, for some reason when I downloaded it, mine did not add up correctly. It was in a different column then the one it was adding up. Could it be because I am using open office and not MS office?

I can't get mine to print the screen, I'm on my laptop and that button doesn't seem to want to work. lol

Rob

Share this post


Link to post
Share on other sites

No clue why it isn't adding up right. Have you tried to download it again and use it in Excel?

If you just press the print screen then open MS Paint you can then right click and hit paste and that should paste the screen shot for you to save.

Share this post


Link to post
Share on other sites

No clue why it isn't adding up right. Have you tried to download it again and use it in Excel?

If you just press the print screen then open MS Paint you can then right click and hit paste and that should paste the screen shot for you to save.

Share this post


Link to post
Share on other sites

Ok, this is what my screen shows, as you can tell, it does not add up correctly. Like I said, it might be that I'm using open office and not microsoft office. Maybe it moved the cells over 1? I don't know, just really odd

Rob

Share this post


Link to post
Share on other sites

Ok, this is what my screen shows, as you can tell, it does not add up correctly. Like I said, it might be that I'm using open office and not microsoft office. Maybe it moved the cells over 1? I don't know, just really odd

Rob

Share this post


Link to post
Share on other sites

J Morgan wrote:

Ok below is my controller spreadsheet. We will focus on channel one that is highlighted in red. You will notice QTY String says 3 and since they are minis they are 100 per strand. So since I have 3 strands of 100 count minis it shows 300 total lights on the right for that line which is correct. Now your total bulbs on the right towards the bottom below total watts with the red box is the total amount of bulbs for the whole controller. So if you add up all of the "total lights" in column K it will give you total bulbs which is correct. At least it is on mine.

controllervx8.png

J Morgan, do you use the Light Type tab? For some reason I can't figure it out and I am usually pretty good with this stuff. My problem is I have the amperage info per string and the spread sheet seems to ask what the amperage per bulb is. Does that make sense?

Dan

Share this post


Link to post
Share on other sites

J Morgan wrote:

Ok below is my controller spreadsheet. We will focus on channel one that is highlighted in red. You will notice QTY String says 3 and since they are minis they are 100 per strand. So since I have 3 strands of 100 count minis it shows 300 total lights on the right for that line which is correct. Now your total bulbs on the right towards the bottom below total watts with the red box is the total amount of bulbs for the whole controller. So if you add up all of the "total lights" in column K it will give you total bulbs which is correct. At least it is on mine.

controllervx8.png

J Morgan, do you use the Light Type tab? For some reason I can't figure it out and I am usually pretty good with this stuff. My problem is I have the amperage info per string and the spread sheet seems to ask what the amperage per bulb is. Does that make sense?

Dan

Share this post


Link to post
Share on other sites

J Morgan wrote:

Do a search for Quartzhill Christmas. He has a controller load spreadsheet that allows you to take inventory of your channels and it calculates the load.

Pretty useful XLS file. I have one enhancement to offer once I get time that should allow you to take a LOR (I) .LCC file and import the channels names/units.The file format looks pretty straight-forward andit should be easy enough to write the macro to do it....

Cheers

Chris in VA

Share this post


Link to post
Share on other sites

J Morgan wrote:

Do a search for Quartzhill Christmas. He has a controller load spreadsheet that allows you to take inventory of your channels and it calculates the load.

Pretty useful XLS file. I have one enhancement to offer once I get time that should allow you to take a LOR (I) .LCC file and import the channels names/units.The file format looks pretty straight-forward andit should be easy enough to write the macro to do it....

Cheers

Chris in VA

Share this post


Link to post
Share on other sites

musicman wrote:

Ok, this is what my screen shows, as you can tell, it does not add up correctly. Like I said, it might be that I'm using open office and not microsoft office. Maybe it moved the cells over 1? I don't know, just really odd

Rob

You are using the older verison. I am using the new one, look how different yours looks to mine. Go download the new one that I think addresses this problem.

Hobby1, yes I use the light types tab. Which verison of this spreedsheet are you using. Mine has light per bulb and per string for the row. So when you select a light type on the controller set up it will add up the correct calculations.

Share this post


Link to post
Share on other sites

musicman wrote:

Ok, this is what my screen shows, as you can tell, it does not add up correctly. Like I said, it might be that I'm using open office and not microsoft office. Maybe it moved the cells over 1? I don't know, just really odd

Rob

You are using the older verison. I am using the new one, look how different yours looks to mine. Go download the new one that I think addresses this problem.

Hobby1, yes I use the light types tab. Which verison of this spreedsheet are you using. Mine has light per bulb and per string for the row. So when you select a light type on the controller set up it will add up the correct calculations.

Share this post


Link to post
Share on other sites

I see what it is. I was using the 10 controller one and you are using the 25 controller one. I downloaded the 25 one and that does fix everything.

Rob

Share this post


Link to post
Share on other sites

I see what it is. I was using the 10 controller one and you are using the 25 controller one. I downloaded the 25 one and that does fix everything.

Rob

Share this post


Link to post
Share on other sites

Maybe I am overlooking something but when I change Power Type column to AMPs, it is looking for AMPs per bulb. All I have is AMPs per string. Does that make sense?

Dan

Share this post


Link to post
Share on other sites

Maybe I am overlooking something but when I change Power Type column to AMPs, it is looking for AMPs per bulb. All I have is AMPs per string. Does that make sense?

Dan

post-6861-129571021641_thumb.jpg

Share this post


Link to post
Share on other sites

Power type should be set to watts, that is why it is looking for AMPS.

Then under column C set those numbers to the watts of each bulb. Which for net will be 0.25 for any mini. They the spreadsheet will do the rest.

Share this post


Link to post
Share on other sites

Power type should be set to watts, that is why it is looking for AMPS.

Then under column C set those numbers to the watts of each bulb. Which for net will be 0.25 for any mini. They the spreadsheet will do the rest.

Share this post


Link to post
Share on other sites

J Morgan wrote:

Power type should be set to watts, that is why it is looking for AMPS.

Then under column C set those numbers to the watts of each bulb. Which for net will be 0.25 for any mini. They the spreadsheet will do the rest.

These are LED nets so it will be different, right? How do I determine the watt of each bulb?

Share this post


Link to post
Share on other sites

J Morgan wrote:

Power type should be set to watts, that is why it is looking for AMPS.

Then under column C set those numbers to the watts of each bulb. Which for net will be 0.25 for any mini. They the spreadsheet will do the rest.

These are LED nets so it will be different, right? How do I determine the watt of each bulb?

Share this post


Link to post
Share on other sites

Yes the LED bulbs are going to be less I would think. Even though on the Light Types tab it says LED are 2.4 watts a bulb. I don't think that is right but I also don't know much or use LED.

Share this post


Link to post
Share on other sites

Yes the LED bulbs are going to be less I would think. Even though on the Light Types tab it says LED are 2.4 watts a bulb. I don't think that is right but I also don't know much or use LED.

Share this post


Link to post
Share on other sites

meadmkr wrote:

J Morgan wrote:

Pretty useful XLS file. I have one enhancement to offer once I get time that should allow you to take a LOR (I) .LCC file and import the channels names/units.The file format looks pretty straight-forward andit should be easy enough to write the macro to do it....

Cheers

Chris in VA

Chris, that would be VERY useful ... thanks!

Share this post


Link to post
Share on other sites

meadmkr wrote:

J Morgan wrote:

Pretty useful XLS file. I have one enhancement to offer once I get time that should allow you to take a LOR (I) .LCC file and import the channels names/units.The file format looks pretty straight-forward andit should be easy enough to write the macro to do it....

Cheers

Chris in VA

Chris, that would be VERY useful ... thanks!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...