Sister shop to Motorhome Facts
TomTom GO LIVE Camper & Caravan
The ultimate Sat Nav system for your motorhome, pre-programmed with 20,000+ POI's from the largest European Motorhoming Websites including the Motorhome Facts Campsite Database.
Welcome to Motorhomefacts, we are a thriving motorhome community (Largest in Europe). Why Not JOIN NOW and get instant access to more of the website. It costs nothing to join and only takes a few minutes. We have 200,000 different people visiting our site monthly and this amount of motorhomers in one place guarantees a fast response to any questions you may have. We also have unique facilities not found elsewhere such as our Online Logbook, stopover tracker, Motorhome directory with Ebay type feedback and the largest repository of motorhome campsites reviews found anywhere
I'm working on a spreadsheet in Google Docs (i have Excel 2003/2007 too) to record our fuel usage, stats, KM per litre, mpg, total cost, average price per litre etc.... It's a WIP and I'm basically asking for suggestions for formulae and/or similar example files already in existence. Does anyone have such a system? Attached to this post should be an XLS export, which may have knackered the formatting in the process! Now i think about it I'll probably finish it in Excel...
We are planning to take our 20yr old old 2400cc straight diesel Hymer Camp around most of Europe from June onwards for up to 5months, so this is also a request for as much advice, locations etc. as possible!
My paper calculations from last weeks' drive from Granada to Gatwick equated to about 8KM per litre, which isn't great, but we have some slightly weakened rear springs and some slight play in the front right wheel which didn't help - the latter is now due to be fixed.
That looks OK except for the figure in I24. Here you are taking an average of the average fuel consumption per fill. This gives a figure of
7.58 km/litre. When you take total distance divide by total fuel purchased, this works out as 7.36 km/litre.
This type of spreadsheet works best when you use a 'brim to brim' measurement. Part fills have to be included in the next full tank figure to give an accurate reading.
The fuel consumption figure per fill is then relative to the other fuel consumptions per fill and is useful to track a deterioration (or improvement) in performance.
You can perhaps relate this to the type of running over a particular fill - motorway, minor roads, wind, rain, temperature, average speeds etc which will perhaps give an indication of what's going on mpg wise.
Very similar to one I use. I have attached a blank version for comparison.
At the top is an input section for opening mileage (or more accurately KM) and other info about the MH. I started this from scratch when we got the van. You could of course input opening KM starting from any point. The running averages are then displayed at the top right of the sheet. Only input in the yellow area as the rest contains formulae.
I think you will find L/100 km more useful than km/L as the former is the European standard. You may find this useful if you want to use tools like the French Govt's 'Prix du Carburants' website that contains a calculator for fuel used and shows you potential fuelling stops along a route. You need to input L/100 km for this.
My spreadsheet does not include a column to note whether or not I filled up completely. So far, I think I always have topped up. In any case, the figure I watch most closely is the average consumption since purchasing the MH. I think individual trip consumption can be misleading.
Hope this gives you some ideas.
Philip
p.s. This was created using Excel on a Mac. Normally there are no compatibility issues, but if there are, PM me and I'll send a copy by e-mail where I can select a "Windows-friendly" option.
Thanks for the spreadsheet and advice - I've used yours over mine, with £'s now converter into Euros to make it personal!
No compatibility issues, which is as you'd except seeing as Microsoft makes Office for Mac, they'd be stupid to make a rival OS and office system work radically differently.
Next step is to fit the 12v to 230v inverter to power the Laptop in order for this sheet to be accessible. As you can probably tell, we're new to this MH'ing and doing everything on a shoestring!
Good point Graham - I was being lazy as I don't normally bother to tidy up spreadsheets for personal use. The #DIV/0 message reminds me that there is a formula in the cell so I don't over-write it. Here is a cleaner version if anyone want to use it. (Hope I haven't corrupted any of the calculation logic in doing this!)
I like it - as I use euro all the time, I presume I don't need to make any alterations - just ignore the pound sign?
chris
Well it depends on where you travel to. If you only travel around the euro-zone then you no problem.
For those not happy at opening other people spreadsheets, I've included an old pdf explaining the formulae.
**NB**, for those wondering about the litres per £5 column, that was included to please a work colleague who only ever put £5 a week in the tank
/shakes head.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
All times are GMT + 1 Hour Page 1 of 2Goto page 1, 2Next
UK
