- | Yr | Utility | Solar | Savings |
- | -- | ---------------| ---------------| -------------- |
- | 1 | | C2 | |
- | 2 | =B2*1.05 | C2 | =B2-C2 |
- | 3 | =B3*1.05 | C2 | =B3-C3 |
- | 4 | =B4*1.05 | C2 | =B4-C4 |
- | 5 | =B5*1.05 | C2 | =B5-C5 |
- | 6 | =B6*1.05 | C2 | =B6-C6 |
- | 7 | =B7*1.05 | C2 | =B7-C7 |
- | 8 | =B8*1.05 | C2 | =B8-C8 |
- | 9 | =B9*1.05 | C2 | =B9-C9 |
- | 10 | =B10*1.05 | C2 | =B10-C10 |
- | 11 | =B11*1.05 | C2 | =B11-C11 |
- | 12 | =B12*1.05 | C2 | =B12-C12 |
- | 13 | =B13*1.05 | C2 | =B13-C13 |
- | 14 | =B14*1.05 | C2 | =B14-C14 |
- | 15 | =B15*1.05 | C2 | =B15-C15 |
- | 16 | =B16*1.05 | C2 | =B16-C16 |
- | 17 | =B17*1.05 | C2 | =B17-C17 |
- | 18 | =B18*1.05 | C2 | =B18-C18 |
- | 19 | =B19*1.05 | C2 | =B19-C19 |
- | 20 | =B20*1.05 | C2 | =B20-C20 |
- | 21 | =B21*1.05 | C2 | =B21-C21 |
- | 22 | =B22*1.05 | C2 | =B22-C22 |
- | 23 | =B23*1.05 | C2 | =B23-C23 |
- | 24 | =B24*1.05 | C2 | =B24-C24 |
- | 25 | =B25*1.05 | C2 | =B25-C25 |
- | 26 | =B25*1.05 | 0 | =B26-C26 |
- | 27 | =B25*1.05 | 0 | =B27-C27 |
- | 28 | =B25*1.05 | 0 | =B28-C28 |
- | 29 | =B25*1.05 | 0 | =B29-C29 |
- | 30 | =B25*1.05 | 0 | =B30-C30 |
- | Total | =SUM(B2:B31
[text] Solar savings calculator
Viewer
Editor
You can edit this paste and save as new: