FiT Calculater with Payback Time and ROI

[dansk]

Ive created this in Excell if it will help anyone - follow the link because the forum wont allow me to upload .xls extensions

http://www.mirrordemisters.co.uk/FIT/FiT.xls

It should be locked so you have no danger of accidently changing anything.

enter the Kwp, Enter the SAP calc, and enter your selling price, and it will calulate the yearly FIT, Return on investment and pay back in years (roughley)

also you can edit the FIT rate in case it changes.

Hopefully it may help someone - and you can save a copy to your computor.

It may not be perfect so please let me know.

Also if anyone wants an unlocked version to imbed with other excell sheets just let me know and i will upload unlocked version.

 

[goodwilld]

Thanks dansk

 

[TJLinks]

Hi dansk, what do you put in the Gd cell?

 

[dansk]

Hi,

Input the SAP calc, so basicly do your cost for the system and do the SAP calc as normal then enter that then it will tell you how FiT you could expect.

 

[SRE]

Try this site - I've found the calculator very helpful when comparing to leaving cash in the bank. www.reuk.co.uk

 

[Ramjam]

I'm not trying to be a git but you got me started so I just wrote this...

http://www.silverstonesolar.co.uk/SilverstoneSolarBenefitCalculator.xls

Feel free to use as you wish. If you've got excel 2007 then you can insert a logo into the top centre. Remember hit alt+return to move onto a new line within a cell.

If you have any questions or particularly if you find a bug then let me know.

 

[Noddy67]

Ramjam - the calcs are good enough but the layout is brilliant. I've used Excel for years but all my spreadsheets look sh*t. Well done and thanks.

 

[gr7]

Thanks for sharing this Ramjam.

One observation for you: should H21-H44 have $K$13 in place of '0.5' ?

It is a lovely neat spreadsheet, thanks again.

 

[Kram]

I'm not trying to be a git but you got me started so I just wrote this...

http://www.silverstonesolar.co.uk/SilverstoneSolarBenefitCalculator.xls

Feel free to use as you wish. If you've got excel 2007 then you can insert a logo into the top centre. Remember hit alt+return to move onto a new line within a cell.

If you have any questions or particularly if you find a bug then let me know.

Many thanks ramjam an excellent spread sheet, is it possible to unlock the cells?

 

[Ramjam]

I'm afraid I'm not going to unlock the cells, I've since developed the spreadsheet much further to produce site survey form which when completed provides a full quote with upto 3 options, sales contracts as well as benefit calcs. Tonight I'll add the commissioning test sheets, customer contact log and guarantee forms so that it produces all of the forms and contains all of the information relevant to the customer from first contact through to commissioning.

I was considering then running it into a full database / customer relationship management / design / ordering / quoting / invoicing system.

Serious question, how much would you pay for a computer programme that managed all of your customer paperwork in accordance with MCS and REAL codes?
I'm looking at a system that one person in the office would capture all enquiries on, produce survey forms for completion on site and that would then produce all of the quotes and upon customer acceptance would produce purchase order and then handover pack. It couple however be designed in a web technology so that it runs online. Any interest?

 

[TJLinks]

We would be interested, let us know when you have it developed,

 

[dansk]

that would be a god send, coz the paper trail is too much.

 

[SRE]

Me too - still doing quotes now!

 

[divemaster72]

i'd be very interested, please keep us posted!

 

[d1ssc]

i'd send you a 1 oz krugerrand recorded delivery....... along with an invitation to my wedding!!!

 

[brucelee]

I'm not trying to be a git but you got me started so I just wrote this...

http://www.silverstonesolar.co.uk/SilverstoneSolarBenefitCalculator.xls

Feel free to use as you wish. If you've got excel 2007 then you can insert a logo into the top centre. Remember hit alt+return to move onto a new line within a cell.

If you have any questions or particularly if you find a bug then let me know.

cheers for sharing ramjam

 

[Ramjam]

Give me a week and I'll have a spreadsheet that will make things much much easier which I'll be selling for £150 plus vat with your logo and contact details embedded. If you want to try it before you buy then you can no problem it will just have my logo and address on the quote. I'll start a new thread for that.

Cheers
William

 

[TJLinks]

keep us informed, I think you will be very busy

 

[egfsolar]

Hi i am a new installer and this software would be of great help and i am willing to pay for it
Can you contact me

cheers stevie

 

[yellowvanman]

Ramjam

Nice spreadsheet.

As a comparison to a similar software package (but doesn't deal with renewables at all) look at instantAdmin - The Simple All-in-one Small Business Solution for Accounts, Contacts, Mailings and Ideas..

 

[stubo300]

yeah please keep us posted

 

[Ramjam]

Please take a look at the new thread

Quotation process made easy