[text] Solar savings calculator

Viewer

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

Editor

You can edit this paste and save as new:


File Description
  • Solar savings calculator
  • Paste Code
  • 28 Mar-2023
  • 1.9 Kb
You can Share it: