Creating a payback calculator with rate change
Solved/Closed
jojosabadar
Posts
5
Registration date
Monday July 18, 2016
Status
Member
Last seen
July 22, 2016
-
Jul 18, 2016 at 11:42 AM
jojosabadar Posts 5 Registration date Monday July 18, 2016 Status Member Last seen July 22, 2016 - Jul 22, 2016 at 02:14 PM
jojosabadar Posts 5 Registration date Monday July 18, 2016 Status Member Last seen July 22, 2016 - Jul 22, 2016 at 02:14 PM
Related:
- Creating a payback calculator with rate change
- Mtu calculator - Guide
- At the rate key - Guide
- Create skype account with gmail - Guide
- Change computer name cmd - Guide
- Change lg tv name - Guide
Jul 19, 2016 at 09:26 AM
I was hoping to get a table with 20-25 rows of data as the output.
The first column is just the year values (start year 0, which would be the initial investment and any rebates)
The second column is the savings for that year:
as an example : If I set rate1 as 0.05 $/kWh for 5 years, and rate2 as 0.15$/kWh after that. then the first 5 rows (years 1-5) would have the second column as Rate1*Annual electrical savings, then from years 6 onward this coloumn would be Rate2*AnnualElectricalSavings. What would be displayed would be the same for the first 5 years for this example before changing.
The last column would be the total savings - initial investment; Where the total savings would be the second column + the previous years final column.
As i mentioned above, i was hoping it would be possible to input the year for rate 1 every time as it is not always going to be 5 years.
I hope this explains what i was looking for a little better, if not just let me know and i can try to make it more clear.
Thanks a lot for taking the time to help!
Jul 19, 2016 at 04:52 PM
Jul 19, 2016 at 07:37 PM
So from my example above, if it was 5 years, then i have to manually enter rate1 for the first 6 rows, years 0-5, (or enter it once and drag it down) and then enter rate 2 from that row onward.
Is there a repeat function that i can manually enter the year limit for rate 1 and it populates the table with rate 1 for the first however many rows and then populate the rest with rate 2 until the end of the table?
Thanks again for your help!
Jul 21, 2016 at 10:51 AM
Thanks for everyone who took the time to try and help.
Could a mod let me know if I should close this, or mark it solved?
Thanks!
Jul 21, 2016 at 03:44 PM