With the number of
lights constantly changing every day, I was once asked how I keep
track of how many lights we have up. No, I don't go out and
count them every night. I keep a simple spreadsheet that lists
each display and how many lights are on each. Buy changing the
the number in the quantity column it multiplies itself by the number
in the each colum. It then gives a total of how many lights
are there. For example, if I were to add another 6' tree that
had 200 lights on it then I would have 5 in the quantity column and
the total would automatically recalculate to 1,000.
Here is how my spreadsheet looks for 2009.
Item |
Qty |
Each |
Total |
|
|
|
|
2' trees |
7 |
17 |
119 |
3' Trees |
3 |
25 |
75 |
4' Spiral |
1 |
150 |
150 |
5' Wreath |
1 |
300 |
300 |
5' Wreath |
1 |
400 |
400 |
6' tree |
4 |
200 |
800 |
6' Spiral |
9 |
300 |
2700 |
6.5' trees |
10 |
400 |
4000 |
7' Trees |
4 |
500 |
2000 |
Barn Star |
1 |
900 |
900 |
Chain
Link, Barn |
1 |
700 |
700 |
Chimney
Star |
1 |
25 |
25 |
Cleveland
Pears |
3 |
100 |
300 |
Deer,
large |
2 |
300 |
600 |
Deer,
medium |
2 |
200 |
400 |
Dogwoods |
2 |
300 |
600 |
Driveway
Chasers |
6 |
150 |
900 |
Driveway
fence |
8 |
100 |
800 |
Glittery
Snowmen |
2 |
200 |
400 |
Icicles |
12 |
150 |
1800 |
Icicles |
7 |
100 |
700 |
Icicles |
2 |
300 |
600 |
LED Trees |
2 |
100 |
200 |
Lg. Candy
Canes |
106 |
20 |
2120 |
Maple Tree |
1 |
1400 |
1400 |
North
Chain Link |
1 |
200 |
200 |
Oak Tree |
1 |
1400 |
1400 |
Pine tree |
1 |
700 |
700 |
Roof |
1 |
850 |
850 |
Sm. Candy
Canes |
13 |
50 |
650 |
Small Barn
Star |
3 |
500 |
1500 |
Small
Sleigh & Deer |
1 |
1000 |
1000 |
Windows |
7 |
150 |
1050 |
|
|
|
|
Total
Lights |
|
|
30339 |
|