| Assumption: Flat power usage of 79.8 kWH/day | How to figure out how many KWHs generated during peak vs off-peak hours? | ||||||||||||||||||||||||||||||||
| E-7 | Jan-01 | Surcharge | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | ||||||||||||||||||||||||||
| Jun-01 | Surcharge | 0.05124 | 0.09517 | 0.11505 | |||||||||||||||||||||||||||||
| Total Surcharge | 0.01 | 0.01 | 0.06124 | 0.10517 | 0.12505 | 0.0002 | |||||||||||||||||||||||||||
| 18% | 82% | Summer rate | 0.09515 | 0.09515 | 0.14639 | 0.19032 | 0.2102 | ||||||||||||||||||||||||||
| Current Usage | 168 | 30 | 138 | Winter Rate | 0.18366 | 0.18366 | 0.2349 | 0.27883 | 0.29871 | 0.01732 | |||||||||||||||||||||||
| Month billed | Month used | # days | KWH | PV Prod KWH | Net KWH after PV | Net peak KWH | Net off peak KWH | Monthly Meter charge | peak rate | Off-peak rate | Baseline KWH/day | Baseline KWH | Baseline charge | Sur- charge Base line | 100-130% KWH | 100-130% $ | 131-200% KWH | 131-200% $ | 201-300% KWH | 200-300% $ | 301%+ KWH | 301%+ $ | Base line Credit | Subtotal | Energy commision tax | 5% city tax on subtotal | Total electric bill | ||||||
| 5/1/2003 | 4/1/2003 | 30 | 2394 | 0 | 2394 | 428 | 1967 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | $115.38 | $3.66 | 109.8 | $24.60 | 256.2 | $37.51 | 366.0 | $69.66 | 1296.0 | $272.42 | $6.34 | $517.01 | $0.48 | $25.85 | $543.34 | ||||||
| 6/1/2003 | 5/1/2003 | 31 | 2474 | 0 | 2474 | 442 | 2032 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | $119.22 | $3.78 | 113.5 | $25.42 | 264.7 | $38.76 | 378.2 | $71.98 | 1339.2 | $281.50 | $6.55 | $534.24 | $0.49 | $26.71 | $561.44 | ||||||
| 7/1/2003 | 6/1/2003 | 30 | 2394 | 0 | 2394 | 428 | 1967 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | $115.38 | $3.66 | 109.8 | $24.60 | 256.2 | $37.51 | 366.0 | $69.66 | 1296.0 | $272.42 | $6.34 | $517.01 | $0.48 | $25.85 | $543.34 | ||||||
| 8/1/2003 | 7/1/2003 | 31 | 2474 | 0 | 2474 | 442 | 2032 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | $119.22 | $3.78 | 113.5 | $25.42 | 264.7 | $38.76 | 378.2 | $71.98 | 1339.2 | $281.50 | $6.55 | $534.24 | $0.49 | $26.71 | $561.44 | ||||||
| 9/1/2003 | 8/1/2003 | 31 | 2474 | 0 | 2474 | 442 | 2032 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | $119.22 | $3.78 | 113.5 | $25.42 | 264.7 | $38.76 | 378.2 | $71.98 | 1339.2 | $281.50 | $6.55 | $534.24 | $0.49 | $26.71 | $561.44 | ||||||
| 10/1/2003 | 9/1/2003 | 30 | 2394 | 0 | 2394 | 428 | 1967 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | $115.38 | $3.66 | 109.8 | $24.60 | 256.2 | $37.51 | 366.0 | $69.66 | 1296.0 | $272.42 | $6.34 | $517.01 | $0.48 | $25.85 | $543.34 | ||||||
| 11/1/2003 | 10/1/2003 | 31 | 2474 | 0 | 2474 | 442 | 2032 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $46.89 | $4.03 | 120.9 | $12.99 | 282.1 | $42.24 | 403.0 | $78.05 | 1264.8 | $270.11 | $6.98 | $447.47 | $0.49 | $22.37 | $470.34 | ||||||
| 12/1/2003 | 11/1/2003 | 30 | 2394 | 0 | 2394 | 428 | 1967 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 390.0 | $45.38 | $3.90 | 117.0 | $12.57 | 273.0 | $40.88 | 390.0 | $75.54 | 1224.0 | $261.40 | $6.75 | $433.04 | $0.48 | $21.65 | $455.17 | ||||||
| 1/1/2004 | 12/1/2003 | 31 | 2474 | 0 | 2474 | 442 | 2032 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $46.89 | $4.03 | 120.9 | $12.99 | 282.1 | $42.24 | 403.0 | $78.05 | 1264.8 | $270.11 | $6.98 | $447.47 | $0.49 | $22.37 | $470.34 | ||||||
| 2/1/2004 | 1/1/2004 | 31 | 2474 | 0 | 2474 | 442 | 2032 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $46.89 | $4.03 | 120.9 | $12.99 | 282.1 | $42.24 | 403.0 | $78.05 | 1264.8 | $270.11 | $6.98 | $447.47 | $0.49 | $22.37 | $470.34 | ||||||
| 3/1/2004 | 2/1/2004 | 28 | 2234 | 0 | 2234 | 399 | 1835 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 364.0 | $42.36 | $3.64 | 109.2 | $11.73 | 254.8 | $38.16 | 364.0 | $70.50 | 1142.4 | $243.97 | $6.30 | $404.18 | $0.45 | $20.21 | $424.83 | ||||||
| 4/1/2004 | 3/1/2004 | 31 | 2474 | 0 | 2474 | 442 | 2032 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $46.89 | $4.03 | 120.9 | $12.99 | 282.1 | $42.24 | 403.0 | $78.05 | 1264.8 | $270.11 | $6.98 | $447.47 | $0.49 | $22.37 | $470.34 | Extra cost over E-8 | |||||
| Annual | Total | 365 | 29127 | 0 | 29127 | $1.54 | 151.2 | 4598.6 | $979.11 | $45.99 | 1379.58 | $226.31 | 3219.02 | $476.80 | 4598.6 | $883 | 15331.2 | $3,248 | $80 | $5,781 | $6 | $289 | $6,076 | $130 | |||||||||
| Monthly | Average | 30.42 | 2427 | 0 | 2427 | $0.13 | 13 | 383 | $81.59 | $3.83 | 115 | $18.86 | 268 | $39.73 | 383 | $73.60 | 1278 | $270.63 | $6.64 | $481.73 | $0.49 | $24.09 | $506.31 | ||||||||||
| 9197.2 | $1,728 | 13795.8 | $2,611 | 29127 | $5,859 | ||||||||||||||||||||||||||||
| 766 | $144.02 | 1149.65 | $217.61 | 2427.25 | $488.24 | ||||||||||||||||||||||||||||
| Akeena | 43.6% | 56.4% | |||||||||||||||||||||||||||||||
| Month billed | Month used | # days | KWH | PV Prod KWH | PV peak KWH | PV off peak KWH | Net KWH after PV | Net peak KWH | Net off peak KWH | Monthly Meter charge | peak rate | Off-peak rate | Baseline KWH/day | Baseline KWH | Baseline charge | Sur- charge Base line | 100-130% KWH | 100-130% $ | 131-200% KWH | 131-200% $ | 201-300% KWH | 200-300% $ | 301%+ KWH | 301%+ $ | Base line Credit | Subtotal | Energy commision tax | 5% city tax on subtotal | Total electric bill | Savings over Current E8 | Savings over Akeena E8 | ||
| 5/1/2003 | 4/1/2003 | 30 | 2394 | 1198 | 522 | 676 | 1196 | (94) | 1290 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | $9.42 | $3.66 | 109.8 | $10.45 | 256.2 | $37.51 | 366.0 | $69.66 | 98.0 | $20.60 | $6.34 | $145.08 | $0.24 | $7.25 | $152.58 | ||||
| 6/1/2003 | 5/1/2003 | 31 | 2474 | 1367 | 596 | 771 | 1107 | (154) | 1261 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | ($3.20) | $3.78 | 113.5 | $10.80 | 264.7 | $38.76 | 350.4 | $66.69 | $0.00 | $6.55 | $110.40 | $0.22 | $5.52 | $116.14 | |||||
| 7/1/2003 | 6/1/2003 | 30 | 2394 | 1391 | 606 | 785 | 1003 | (179) | 1182 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | ($9.92) | $3.66 | 109.8 | $10.45 | 256.2 | $37.51 | 271.0 | $51.58 | $0.00 | $6.34 | $87.05 | $0.20 | $4.35 | $91.61 | |||||
| 8/1/2003 | 7/1/2003 | 31 | 2474 | 1463 | 637 | 826 | 1011 | (196) | 1206 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | ($12.82) | $3.78 | 113.5 | $10.80 | 264.7 | $38.76 | 254.4 | $48.42 | $0.00 | $6.55 | $82.50 | $0.20 | $4.13 | $86.83 | |||||
| 9/1/2003 | 8/1/2003 | 31 | 2474 | 1331 | 580 | 751 | 1143 | (138) | 1281 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | $0.41 | $3.78 | 113.5 | $10.80 | 264.7 | $38.76 | 378.2 | $71.98 | 8.2 | $1.72 | $6.55 | $121.02 | $0.23 | $6.05 | $127.30 | ||||
| 10/1/2003 | 9/1/2003 | 30 | 2394 | 1146 | 499 | 647 | 1248 | (72) | 1320 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | $14.64 | $3.66 | 109.8 | $10.45 | 256.2 | $37.51 | 366.0 | $69.66 | 150.0 | $31.53 | $6.34 | $161.23 | $0.25 | $8.06 | $169.54 | ||||
| 11/1/2003 | 10/1/2003 | 31 | 2474 | 942 | 410 | 532 | 1532 | 31 | 1500 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $36.54 | $4.03 | 120.9 | $11.91 | 282.1 | $42.24 | 403.0 | $78.05 | 322.8 | $68.94 | $6.98 | $234.86 | $0.31 | $11.74 | $246.91 | ||||
| 12/1/2003 | 11/1/2003 | 30 | 2394 | 669 | 291 | 378 | 1725 | 136 | 1589 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 390.0 | $38.31 | $3.90 | 117.0 | $11.53 | 273.0 | $40.88 | 390.0 | $75.54 | 555.0 | $118.53 | $6.75 | $282.05 | $0.35 | $14.10 | $296.50 | ||||
| 1/1/2004 | 12/1/2003 | 31 | 2474 | 566 | 247 | 319 | 1908 | 195 | 1713 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $41.10 | $4.03 | 120.9 | $11.91 | 282.1 | $42.24 | 403.0 | $78.05 | 698.8 | $149.24 | $6.98 | $319.73 | $0.38 | $15.99 | $336.09 | ||||
| 2/1/2004 | 1/1/2004 | 31 | 2474 | 593 | 258 | 335 | 1881 | 183 | 1697 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $40.78 | $4.03 | 120.9 | $11.91 | 282.1 | $42.24 | 403.0 | $78.05 | 671.8 | $143.47 | $6.98 | $313.63 | $0.38 | $15.68 | $329.69 | ||||
| 3/1/2004 | 2/1/2004 | 28 | 2234 | 735 | 320 | 415 | 1499 | 79 | 1421 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 364.0 | $34.41 | $3.64 | 109.2 | $10.76 | 254.8 | $38.16 | 364.0 | $70.50 | 407.4 | $87.00 | $6.30 | $238.29 | $0.30 | $11.91 | $250.51 | ||||
| 4/1/2004 | 3/1/2004 | 31 | 2474 | 978 | 426 | 552 | 1496 | 16 | 1480 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $36.10 | $4.03 | 120.9 | $11.91 | 282.1 | $42.24 | 403.0 | $78.05 | 286.8 | $61.25 | $6.98 | $226.74 | $0.30 | $11.34 | $238.38 | ||||
| Annual | Total | 365 | 29127 | 12379 | 5394 | 6985 | 16748 | $1.54 | 151.2 | 4598.6 | $225.77 | $45.99 | 1379.58 | $133.65 | 3219.02 | $476.80 | 4352 | $836 | 3198.8 | $682 | $80 | $2,323 | $3 | $116 | $2,442 | $3,504 | $541 | ||||||
| Monthly | Average | 30.42 | 2427 | 1032 | 449 | 582 | 1396 | $0.13 | 13 | 383 | $18.81 | $3.83 | 115 | $11.14 | 268 | $39.73 | 363 | $69.69 | 355 | $56.86 | $6.64 | $193.55 | $0.28 | $9.68 | $203.51 | ||||||||
| 9197.2 | $882 | 13549.2 | $1,718 | 16748 | $2,401 | ||||||||||||||||||||||||||||
| 766 | $73.52 | 1129.1 | $143.20 | 1395.667 | $200.06 | ||||||||||||||||||||||||||||
| Sun Power & Geothermal | 43.6% | 56.4% | |||||||||||||||||||||||||||||||
| Month billed | Month used | # days | KWH | PV Prod KWH | PV peak KWH | PV off peak KWH | Net KWH after PV | Net peak KWH | Net off peak KWH | Monthly Meter charge | peak rate | Off-peak rate | Baseline KWH/day | Baseline KWH | Baseline charge | Sur- charge Base line | 100-130% KWH | 100-130% $ | 131-200% KWH | 131-200% $ | 201-300% KWH | 200-300% $ | 301%+ KWH | 301%+ $ | Base line Credit | Subtotal | Energy commision tax | 5% city tax on subtotal | Total electric bill | Savings over Current E8 | Savings over SunPower E8 | ||
| 5/1/2003 | 4/1/2003 | 30 | 2394 | 1155 | 503 | 652 | 1239 | (76) | 1315 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | $13.74 | $3.66 | 109.8 | $10.45 | 256.2 | $37.51 | 366.0 | $69.66 | 141.0 | $29.64 | $6.34 | $158.43 | $0.25 | $7.92 | $166.60 | ||||
| 6/1/2003 | 5/1/2003 | 31 | 2474 | 1353 | 590 | 763 | 1121 | (148) | 1269 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | ($1.80) | $3.78 | 113.5 | $10.80 | 264.7 | $38.76 | 364.4 | $69.35 | $0.00 | $6.55 | $114.47 | $0.22 | $5.72 | $120.41 | |||||
| 7/1/2003 | 6/1/2003 | 30 | 2394 | 1407 | 613 | 794 | 987 | (186) | 1173 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | ($11.53) | $3.66 | 109.8 | $10.45 | 256.2 | $37.51 | 255.0 | $48.53 | $0.00 | $6.34 | $82.40 | $0.20 | $4.12 | $86.72 | |||||
| 8/1/2003 | 7/1/2003 | 31 | 2474 | 1469 | 640 | 829 | 1005 | (198) | 1203 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | ($13.43) | $3.78 | 113.5 | $10.80 | 264.7 | $38.76 | 248.4 | $47.28 | $0.00 | $6.55 | $80.76 | $0.20 | $4.04 | $85.00 | |||||
| 9/1/2003 | 8/1/2003 | 31 | 2474 | 1315 | 573 | 742 | 1159 | (131) | 1290 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 378.2 | $2.01 | $3.78 | 113.5 | $10.80 | 264.7 | $38.76 | 378.2 | $71.98 | 24.2 | $5.09 | $6.55 | $125.99 | $0.23 | $6.30 | $132.52 | ||||
| 10/1/2003 | 9/1/2003 | 30 | 2394 | 1097 | 478 | 619 | 1297 | (50) | 1347 | $0.12813 | $0.31524 | $0.08515 | 12.2 | 366.0 | $19.55 | $3.66 | 109.8 | $10.45 | 256.2 | $37.51 | 366.0 | $69.66 | 199.0 | $41.83 | $6.34 | $176.44 | $0.26 | $8.82 | $185.52 | ||||
| 11/1/2003 | 10/1/2003 | 31 | 2474 | 865 | 377 | 488 | 1609 | 65 | 1544 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $37.48 | $4.03 | 120.9 | $11.91 | 282.1 | $42.24 | 403.0 | $78.05 | 399.8 | $85.38 | $6.98 | $252.24 | $0.32 | $12.61 | $265.18 | ||||
| 12/1/2003 | 11/1/2003 | 30 | 2394 | 587 | 256 | 331 | 1807 | 172 | 1635 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 390.0 | $39.30 | $3.90 | 117.0 | $11.53 | 273.0 | $40.88 | 390.0 | $75.54 | 637.0 | $136.04 | $6.75 | $300.56 | $0.36 | $15.03 | $315.94 | ||||
| 1/1/2004 | 12/1/2003 | 31 | 2474 | 494 | 215 | 279 | 1980 | 227 | 1753 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $41.98 | $4.03 | 120.9 | $11.91 | 282.1 | $42.24 | 403.0 | $78.05 | 770.8 | $164.61 | $6.98 | $335.98 | $0.40 | $16.80 | $353.17 | ||||
| 2/1/2004 | 1/1/2004 | 31 | 2474 | 523 | 228 | 295 | 1951 | 214 | 1737 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $41.63 | $4.03 | 120.9 | $11.91 | 282.1 | $42.24 | 403.0 | $78.05 | 741.8 | $158.42 | $6.98 | $329.43 | $0.39 | $16.47 | $346.29 | ||||
| 3/1/2004 | 2/1/2004 | 28 | 2234 | 669 | 291 | 378 | 1565 | 108 | 1458 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 364.0 | $35.21 | $3.64 | 109.2 | $10.76 | 254.8 | $38.16 | 364.0 | $70.50 | 473.4 | $101.10 | $6.30 | $253.19 | $0.31 | $12.66 | $266.16 | ||||
| 4/1/2004 | 3/1/2004 | 31 | 2474 | 927 | 404 | 523 | 1547 | 38 | 1509 | $0.12813 | $0.11636 | $0.08851 | 13.0 | 403.0 | $36.72 | $4.03 | 120.9 | $11.91 | 282.1 | $42.24 | 403.0 | $78.05 | 337.8 | $72.14 | $6.98 | $238.25 | $0.31 | $11.91 | $250.47 | ||||
| Annual | Total | 365 | 29127 | 11861 | 5168 | 6693 | 17266 | 33.25 | 17233 | $1.54 | 151.2 | 4598.6 | $240.86 | $45.99 | 1379.58 | $133.65 | 3219.02 | $476.80 | 4344 | $835 | 3724.8 | $794 | $80 | $2,448 | $3 | $122 | $2,574 | $3,372 | $522 | ||||
| Monthly | Average | 30.42 | 2427 | 988 | 431 | 558 | 1439 | 3 | 1436 | $0.13 | 13 | 383 | $20.07 | $3.83 | 115 | $11.14 | 268 | $39.73 | 362 | $69.56 | 414 | $66.19 | $6.64 | $204.01 | $0.29 | $10.20 | $214.50 | ||||||
| 9197.2 | $897 | 13541.2 | $1,732 | 17266 | $2,526 | ||||||||||||||||||||||||||||
| 766 | $74.77 | 1128.433 | $144.33 | 1438.833 | $210.52 | ||||||||||||||||||||||||||||