The 75 and ZT Owners Club Forums - View Single Post

HarryM1BYT · 23rd February 2017, 14:54

I like to keep a close eye on my utilities costs, which I do via an Excell spreadsheet. Its a spreadsheet I found somewhere, modified and adapted to what I wanted - Weekly readings of E&G for the year, including standing charges. To that (with some help) I am now adding provision for water meter readings with consumption / cost graphs for all three and some prediction of the annual costs.

You feed the costings in on page 1, the readings weekly into page 2, then you see the output on page 2 and graphed data on page 3.

Once this version is completed and tested, might anyone want a copy?

23rd February 2017, 14:54	#1
HarryM1BYT This is my second home 75 Contemporary SE Mk II 2004 Man. Sal. CDTi 135ps, FBH on red diesel, WinCE6 DD Join Date: May 2010 Location: Leeds Posts: 17,273 Thanks: 2,160 Thanked 2,061 Times in 1,586 Posts	E + G + W spreadsheet I like to keep a close eye on my utilities costs, which I do via an Excell spreadsheet. Its a spreadsheet I found somewhere, modified and adapted to what I wanted - Weekly readings of E&G for the year, including standing charges. To that (with some help) I am now adding provision for water meter readings with consumption / cost graphs for all three and some prediction of the annual costs. You feed the costings in on page 1, the readings weekly into page 2, then you see the output on page 2 and graphed data on page 3. Once this version is completed and tested, might anyone want a copy? __________________ Harry How To's and items I offer for free, or just to cover the cost of my expenses... http://www.the75andztclub.co.uk/foru...40#post1764540 Fix a poor handbrake; DIY ABS diagnostic unit; Loan of the spanner needed to change the CDT belts; free OBD diagnostics +MAF; Correct Bosch MAF cheap; DVB-T install in an ex-hi-line system; DD install with a HK amp; FBH servicing. I've taken a vow of poverty. To annoy me, send money.