16p, 20 year excel spread sheet anyone?

[Benjjy02]

Does an one have an16p, 20 year excel spread sheet to share or know how to alter the 21p25 year sheet? Thanks

 

[telectrix]

gobbbledey gook to me. does it come with a moulded plug?

 

[ian.settle1]

to lazy to make one?

 

[PengEF]

Excel is easy. If the spreadsheet has been designed correctly there will be a cell where you can change the payment rate and the duration so it really shouldn't be very hard at all. Can't say I have seen the sticky one so it may be particularly convoluted but doubt it.

 

[Benjjy02]

Too lazy? Me and the
258 people who have requested the Solar PV Payback calculator 21p tariff excel

Iv got a 21p excel calculator but im stumped on how to change the the tariff or the
duration

 

[Eco Deal]

change the 21 to 16 easy ??? so I take it you didnt make your 21p excel either !!! lazy

 

[dansk]

assuming the document isnt locked!

 

[JH69]

I set up a spreadsheet in order to calcuate the returns from different systems.

You can set the FIT rate, Panel degredation rate, Inflation Rate, KWh Yield, % of Elec used, and system cost, and it will calcuate total returns and ROI.

I found it invaluable when comparing different systems and working out which offered the best returns.

I'm happy to share it - is there anyway I can attach it to the forum?

 

[mark_]

One of the mods will step in and answer that one JH69. Ive not got the 21p payback spread sheet but if someone sends it to me I'll try to change the cell equations for 16p and 20 years and send it back.

[email protected]