ABCDEFGHIJKLMNOPQRST
1
I'm using this spreadsheet to size how large a system to install. I want to figure out how much electricity I can use before a particular configuration should be upsized. Ideally,
2
I want to keep usage in the lower 3 tiers.
3
4
How to use the spreadsheet
5
estimate solar generation per month:
6
- pinpoint your location here http://mapserve3.nrel.gov/NREL_FlexViewer/index.html
7
 - click the cube in the upper right, select locate, enter address
8
- click the cube again and select PVWatts tool, then click the approximate location of your house, creating a sun icon (you can drag it around to reposition)
9
- click on the PVWatts Tool overlay near the right top, another overlay will appear near your house
10
- click on send to PVWatts which takes you to the calculator
11
- fill in information about your array and location, click submit
12
- now copy the monthly solar production (AC energy column) to the correct column in the spreadsheet (the dark green text in the solar column)
13
14
next, fill in the red colored text under the rate season column (s=summer, w=winter)
15
fill in the red text in the top right of the spreadsheet specifying the maximum overall usage to get into that tier and the cost per tier for the rate seasons
16
finally, enter your monthly usage (typical usage/month), also in the upper right
17
everything else will be calculated for you
18
19
the spreadsheet has space for 3 different scenarios based on 3 different array sizes. you'll need to estimate solar generation for each scenario.
20
the last table is the data without solar
21
22
PG&E rate info: http://www.pge.com/nots/rates/tariffs/rateinfo.shtml
23
PG&E baseline territory map http://www.pge.com/nots/rates/PGECZ_90Rev.pdf
24
PG&E seasonal baselines mentioned here http://www.pge.com/myhome/customerservice/financialassistance/medicalbaseline/understand/
25
26
(c) 2009 DoghouseLabs.com
27
You have the right to redistribute and modify this document, but you cannot remove the DoghouseLabs copyright.
28
If you find this document useful, please donate any amount. Click the 'donate' button on http://www.doghouselabs.com/system
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100