E + G + W spreadsheet

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?

reworht · 23rd February 2017, 15:33

Quote:

Originally Posted by HarryM1BYT

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?

Would love one thanks Harry
- I've enjoyed playing with (and making sensible use of) spreadsheets from Supercalc, through Lotus 123 and gawd knows how many versions of Excel.

Jim Jamieson · 23rd February 2017, 16:16

It's amazing what you can do with Excell, I've used it for several years with both home, car and business accounts.

flying_pig · 23rd February 2017, 20:37

id love to have one as well

HarryM1BYT · 23rd February 2017, 20:57

I'll get back to everyone, when it is finished and tested.

HarryM1BYT · 24th February 2017, 15:37

I have sent both Rewort and flying pig an email via the forum, in order to get their email address to send the spreadsheet. Hopefully both have used valid email addresses when registering?

Greeners · 26th February 2017, 18:43

put in the social forum for wider coverage

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.

23rd February 2017, 20:57	#5
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	I'll get back to everyone, when it is finished and tested. __________________ 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.

24th February 2017, 15:37	#6
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	I have sent both Rewort and flying pig an email via the forum, in order to get their email address to send the spreadsheet. Hopefully both have used valid email addresses when registering? __________________ 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.

26th February 2017, 18:43	#7
Greeners Moderator MG-ZTT Join Date: Mar 2007 Location: Ware, Herts Posts: 19,798 Thanks: 161 Thanked 1,249 Times in 1,036 Posts	put in the social forum for wider coverage __________________ *David* Impecunity is the mother of ingenuity Useful how to's for common problems Car Of The Month Jan 2014 [SatNav Power Down] [Coolant Level] [SatNav Repair] [Diesel Non Starting] [Paint Codes] [Rear Light Seals] [Reversing Light Switch] [Bleeding Brakes][Sunroof Drain] [Early ZT's][Instrument Pack Diagnostics][ATC Diagnostics]

23rd February 2017, 16:16	#3
Jim Jamieson This is my second home Rover less ! Join Date: Jun 2011 Location: Tarbolton Posts: 3,442 Thanks: 393 Thanked 888 Times in 542 Posts	It's amazing what you can do with Excell, I've used it for several years with both home, car and business accounts.

23rd February 2017, 20:37	#4
flying_pig I believe i can fly MG ZT-T Join Date: Feb 2014 Location: Wolverhampton Posts: 2,004 Thanks: 66 Thanked 280 Times in 251 Posts	id love to have one as well