Home‎ > ‎Help and Info‎ > ‎

Records

We keep a record of our holidays for reference and to help plan future trips. This  gives us  an accurate breakdown of costs, the performance of the car with accurate MPG figures gathered on long and varied routes.The journey times recorded help when travelling the same routes in future.

The information is entered in an Excel spreadsheet and produces the 2 summary's shown below.

To do this the following data needs to be collected:
  • Credit card bills.
  • ATM and travel money records.
  • Campsite receipts.
  • Fuel purchases (preferably brim the tank to get an accurate MPG on that tank full )
  • Tolls.
  • Mileages at each end of the journey and at filling stations.
  • Times at each end of the journey and length of rest breaks.
  • Ferry, Insurance and other costs such as gardening.
The motoring information we record in a small notebook along with notes such as good spots for lunch or filling stations (if they are scarce in the area) etc 

Attached to this page for download  is the spreadsheet that produced these summaries and a blank copy.

Note it only calculates  for Euros and Sterling

This example is our 2010 Autumn  7 week trip to the South of France and the Costa Brava

Motoring
  Notes
Total Mileage 2540Door to door        
Miles Towed     2184     
MPG Towing 24.09 
MPG Overall 24.8 
Total Fuel litres 493.66 
Ave Fuel Price £0.98 
No of Nights  50Includes nights on ferry 
   
Travel Costs   
Fuel£484.24  May include some used at home dependent on final fill
Sites£672.03  
Tolls£49.51  
Ferry£475  
Insurance £208 
   
Spending   
Credit Card £2055.30 
Currency  £1223.57 
Spend Total £3278.87 
   
Imports (e.g presents,wine etc ) £912.19 Spending not forming part of holiday cost
Gardening £30 
   
Non Travel or site spend £1190.90 All spending other than travel or Imports
   
Grand Total (inc imports)          £3991.89 
   
Cost per Night      £61.59 Based on everything except imports






                                Towing Journeys Autumn 2010

 

 

Date

Time hh:mm

     Miles

Notes

Sat


28-Aug

03:13

147

 

Home to Hull

Wed


29-Aug

05:32

224

 

Zeebrugge to Chalons

Mon


30-Aug

06:11

228

 

Chalons to Macon

Wed


1-Sep

03:48

170

 

Macon to Issoire

Thu


2-Sep

02:47

125

 

Issoire to Millau

Mon


6-Sep

03:19

150

 

Millau to Argeles

Tue


21-Sep

01:36

57

 

Argeles to St Pere

Thu


7-Oct

04:06

178

 

St Pere to Millau

Sat


9-Oct

06:34

288

 

Millau to Macon

Tue


12-Oct

01:30

56

 

Macon to Beaune

Wed


13-Oct

04:39

174

 

Beaune to Chalons

Fri


15-Oct

02:28

96

 

Chalons to Serracourt

Sat


16-Oct

04:00

144

 

Serracourt to Zeebrugge (held up in Lille)

Sun


17-Oct

03:10

147

 

Hull to Home


Update November 2012
©Copyright 2012 David Willdigg All rights reserved
Ĉ
David Willdigg,
21 Feb 2011, 12:29
Ĉ
David Willdigg,
16 Nov 2012, 10:06