Hi all, Just for your interest (if interested) this is the spreadsheet I did for our current trip over the Nullarbor. Shows all averages and cost per KM
Only if you are interested.. Cheers
Lit per 100KM
14.15869883
Totals
832.22
5877.8
$1,056.87
Average Price per Lit
^^ Litres of Diesel
^^ KMs
^^ $pent
$1.31
Cost per KM
$0.18
Fuel Stop
Litres
KMs from last
Cost
Price per Litre
Lit per 100KM this leg
Port Pirie
33.7
310 from Home
$35.00
$1.05
10.87096774
Kimba
38.5
248
$44.20
$1.14
15.52419355
Ceduna
44.18
311
$49.00
$1.11
14.20578778
Nundroo
24.55
151
$28.21
$1.15
16.25827815
Nullarbor
19.62
144
$30.00
$1.53
13.625
Eucla
31.74
197
$45.39
$1.43
16.11167513
Madura
30
182
$46.20
$1.54
16.48351648
Caiguna
25
156
$38.25
$1.53
16.02564103
Balledonia
29
181
$44.06
$1.52
16.02209945
Noresman
31
193
$38.52
$1.24
16.06217617
Esperance
27
208
$31.29
$1.16
12.98076923
Ravensthorpe
35.3
266
$43.40
$1.23
13.28566052
Kattaning
40
275
$44.10
$1.10
14.54545455
Bullsbrook
52
386
$55.62
$1.07
13.47150259
Gwelup
49.87
489
$54.31
$1.09
10.19836401
Southern Cross
58.69
378.4
$70.36
$1.20
15.52645503
Coolgardie
24.61
185.8
$30.50
$1.24
13.24542519
Norseman
22.65
168
$27.60
$1.22
13.48214286
Balladonia
24.65
190
$38.45
$1.56
12.97368421
Caiguna
28.02
181.2
$43.43
$1.55
15.46357616
Madura
24.53
161
$39.00
$1.59
15.23602484
Eucla
29.5
193.6
$46.61
$1.58
15.20618557
Nullabor Roadhouse
26.3
184.8
$41.00
$1.56
14.21621622
Penong
36.07
223
$38.92
$1.08
16.17488789
Elliston
45.74
315
$53.45
$1.17
14.52063492
-- Edited by Phil C on Tuesday 26th of April 2016 05:08:53 PM
-- Edited by Phil C on Tuesday 26th of April 2016 05:11:03 PM
-- Edited by Phil C on Tuesday 26th of April 2016 05:12:59 PM
__________________
Ex RAAF, now retired. EX Electrician/Teacher.
Homebase is Murray Bridge Tourist Park (in a cabin). New Horse.. 2020 Ford Everest Titanium, Jayco swan for touring.
Obviously not an exciting trip Phil. You had planty of time on your hands by the look if that sheet. I should imagine your typwriter needs a new ribbon after that lot mate
__________________
Live Life On Your Terms
DOUGChief One Feather (Losing feathers with age)
TUG.......2014 Holden LT Colorado Twin Cab Ute with Canopy
DEN....... 2014 "Chief" Arrow CV (with some changes)
Very interesting Phil - surprising that fuel usage can vary 65% for 10 to 16.5 l/100km.
Regards
We had a rather nasty headwind and rain as we headed west, then on the way back it seemed all up hill... perhaps the Nullarbor doesn't like me... lol
The trip from home to Port Pirie was a tail wind or calm, we experienced a calm day or two going west, then headwinds up to 30KM/H thank goodness for ESC.
Its the fuel prices that astounded us, on the way back up by 3 or 4 cents a litre.... go figure Perth prices had hardly changed when we left.
Still a great trip.
-- Edited by Phil C on Thursday 28th of April 2016 10:33:52 AM
__________________
Ex RAAF, now retired. EX Electrician/Teacher.
Homebase is Murray Bridge Tourist Park (in a cabin). New Horse.. 2020 Ford Everest Titanium, Jayco swan for touring.
When I did the Nullarbor in 2013 - diesel was $1.52/litre Penong, and after Nundroo was never under $1.90/litre (except for Eucla @ 1.87/litre) - the highest was at Nullarbor Roadhouse at $2.01/litre. Even Norseman was $1.58/litre.
Different time, different economy, same journey. Unfortunately, one cannot traverse a country like Straya without the regular and constant need for fuel.
If we only travelled when the fuel was at a low price - we would all be tucked up in our lounge rooms watching My Kitchen Rules
cheers - John
__________________
2006 Discovery 3 TDV6 SE Auto - 2008 23ft Golden Eagle Hunter Some people feel the rain - the others just get wet - Bob Dylan
Very interesting figures. I just had similar in touring from Western Vic and around the Eyre Peninsula. Road surface, wind, speed and even unhooking for a 40-60kms side trip effects overall economy on a trip.
I get similar variances on fuel economy. Sometimes after I fill up, the trip computer says I've got > 900kms range (even saw 1000kms once) till I need fuel whereas today when I filled up my range was 590kms. The entire tank was used in towing.
Straya - only habitable continent without international borders.
__________________
GRANDPARENTS & GRANDCHILDREN GET ON SO WELL TOGETHER BECAUSE THEY HAVE A COMMON ENEMY
As an aviation fanatic would love to get into your RAAF history. Did my apprenticeship as a F/T with CAC
Loved your print out so using your wizard mind if we were to swap the tug and the van and insert a Territory (petrol) and a 15ft Coromal at a rough guest how would things stack up anticipate leaving Modbury Heights on the 30th July for close to 16weeks
LLD wrote:Straya - only habitable continent without international borders.
Ahh, but have you heard about Hutt River Province???
PS, good read Phil, got to sleep faster last night. (just kidding).
-- Edited by madaboutled on Thursday 28th of April 2016 08:34:28 PM
-- Edited by madaboutled on Thursday 28th of April 2016 08:34:42 PM
__________________
Steve, Di & Ziggy We named our Motorhome "Roadworx" because on the road works "On The Road Again" Ford Transit with 302 Windsor V8 conversion, C4 Auto, 9 Inch Ford Diff All Lighting L.E.D., 260 Amp/h AGM, 530 Watt Solar + Kipor Backup Gen.
We also keep records of our fuel usage and cost of our tours, it not a big thing but it allows us to know where our money going, the real budget needed for the next tour.
Was wondering if someone would pick up on the Hutt River Province?
Been there.... Done that.... got me passport stamped!. There's actually quite a few micro nations within Australian Borders see: https://en.wikipedia.org/wiki/Category:Micronations_in_Australia
__________________
Steve, Di & Ziggy We named our Motorhome "Roadworx" because on the road works "On The Road Again" Ford Transit with 302 Windsor V8 conversion, C4 Auto, 9 Inch Ford Diff All Lighting L.E.D., 260 Amp/h AGM, 530 Watt Solar + Kipor Backup Gen.
As an aviation fanatic would love to get into your RAAF history. Did my apprenticeship as a F/T with CAC
Loved your print out so using your wizard mind if we were to swap the tug and the van and insert a Territory (petrol) and a 15ft Coromal at a rough guest how would things stack up anticipate leaving Modbury Heights on the 30th July for close to 16weeks
geoffc
Welcome to the gang Geoff, and thanks for your interest in my career
Spent 12 years in the RAAF as an electrical fitter, then avionics tech. Worked on MB36H macchi (fanta cans) A and E model Hercules, HS748, C47 Dakota, CT4 plastic parrots, P3B Orions and a few choppers. The last 2 years I did a few rotations with the roulettes. Had a ball.
Thats about it.
Cheers
-- Edited by Phil C on Saturday 30th of April 2016 03:16:32 PM
__________________
Ex RAAF, now retired. EX Electrician/Teacher.
Homebase is Murray Bridge Tourist Park (in a cabin). New Horse.. 2020 Ford Everest Titanium, Jayco swan for touring.
I also keep a spreadsheet, (not of cost as that will frequently change) but of mileage and fuel used. This helps in the planning of my future trips
For example my next long trip will be approximately less than 12,000 kilometres
Knowing that over the previous 22,000 kilometres, in my current vehicle, I have averaged 8.5 kilometres for each litre of diesel used, I will calculate my fuel use at 8 kilometres per litre to give myself a margin I therefore plan to purchase less than 1,500 litres
At the time I leave, I look at the average (lowest and highest divided by 2) price in my area, and then add 50%, as regardless if I was to travel East, or North, there are some higher than my area fuel prices. This also gives me a margin If I was leaving today the average for South West of Western Australia is approximately $1.20 per litre. 70 outlets below, and 7 outlets above, this price.
Adding 50% to my local average price indicates that I shall in a normal situation, purchase no more than 1,500 litres @ $1.80 per litre I will have this $2,700 set to one side, for fuel use only, prior to leaving.
I have found out over the years, on all my trips with different vehicles that I have always returned to home base, without spending my entire allocated fuel budget, due to my home made built in margins
I do know of others who were not as fortunate as myself They had started their lap, to find that their budget, was not sustainable, and had to return without completing their planned trip
Your spread sheet will be very handy for those who have the same rig as yourself
Correction .. When I said one long haul . On ment on one tank of fuel . We too 6 days traveling . Some of the parking sites are quite interesting ., aha. Toilet out in the open ., Gum trees then Non .,
I also keep a spreadsheet, (not of cost as that will frequently change) but of mileage and fuel used. This helps in the planning of my future trips
For example my next long trip will be approximately less than 12,000 kilometres
Knowing that over the previous 22,000 kilometres, in my current vehicle, I have averaged 8.5 kilometres for each litre of diesel used, I will calculate my fuel use at 8 kilometres per litre to give myself a margin I therefore plan to purchase less than 1,500 litres
At the time I leave, I look at the average (lowest and highest divided by 2) price in my area, and then add 50%, as regardless if I was to travel East, or North, there are some higher than my area fuel prices. This also gives me a margin If I was leaving today the average for South West of Western Australia is approximately $1.20 per litre. 70 outlets below, and 7 outlets above, this price.
Adding 50% to my local average price indicates that I shall in a normal situation, purchase no more than 1,500 litres @ $1.80 per litre I will have this $2,700 set to one side, for fuel use only, prior to leaving.
I have found out over the years, on all my trips with different vehicles that I have always returned to home base, without spending my entire allocated fuel budget, due to my home made built in margins
I do know of others who were not as fortunate as myself They had started their lap, to find that their budget, was not sustainable, and had to return without completing their planned trip
Your spread sheet will be very handy for those who have the same rig as yourself
Cheers folks.
I love your calculations and estimations.
I went the other way with worst case scenarios, allowed $1.60 per litre at 16L per 100K. That calc went into the trip budget. I then saw the average price per KM from the spreadsheet and worked out (or at least the speadsheet did). how much I should be spending.
For budget purposes it works out I have over estimated.
Cheers for that one.
__________________
Ex RAAF, now retired. EX Electrician/Teacher.
Homebase is Murray Bridge Tourist Park (in a cabin). New Horse.. 2020 Ford Everest Titanium, Jayco swan for touring.
BTW folks, the fill up at Bullsbrook and Gwelup were the 4 weeks we spent in Perth with no caravan connected. We did about 500K when we were there. Most travel by public transport. OH and free for pensioners.
Cheers
__________________
Ex RAAF, now retired. EX Electrician/Teacher.
Homebase is Murray Bridge Tourist Park (in a cabin). New Horse.. 2020 Ford Everest Titanium, Jayco swan for touring.
Young Phil I would hazed a quess the the only reason that you stayed out at Bullsbrook was that you had to get your fix of Avtur plus I would bet any money that you had to watch the RAAF and Singaporeien flying their Pilatus a/c
Geoffc
Young Phil I would hazed a quess the the only reason that you stayed out at Bullsbrook was that you had to get your fix of Avtur plus I would bet any money that you had to watch the RAAF and Singaporeien flying their Pilatus a/c Geoffc
They wouldnt let me on the base, so we sat at the end of 23 and watched for a while. Nice bird the pilatus.
Cheers
__________________
Ex RAAF, now retired. EX Electrician/Teacher.
Homebase is Murray Bridge Tourist Park (in a cabin). New Horse.. 2020 Ford Everest Titanium, Jayco swan for touring.
Thanks Phil, cut and pasted into Excel for future use, hope I haven't violated your copy rights?
I used to work at the place where the T series and the CT4's were made. A couple of fellows there who went through their apprenticeship with me did much of the development. These aircraft were originally Australian designed and built by none other than Victor (lawn mowers). The Victer Air Tourer, a little two seater and their big cousin the Victer Air Cruiser. NZ brought the rights for the aircraft, and began to modify and develop them with more powerful engines. The Air tourer became the T3, T4 etc, sold to air forces such as Australia, Thailand etc.
The Air Cruiser came out from the wraps and was developed more as a military trainer. Went from a 4 seater back to a two seater, the cabin door replaced by a ejectable canopy. My job was mainly fixing snags after flight testing or doing mods to earlier aircraft.
Thanks Phil, cut and pasted into Excel for future use, hope I haven't violated your copy rights?
I used to work at the place where the T series and the CT4's were made. A couple of fellows there who went through their apprenticeship with me did much of the development. These aircraft were originally Australian designed and built by none other than Victor (lawn mowers). The Victer Air Tourer, a little two seater and their big cousin the Victer Air Cruiser. NZ brought the rights for the aircraft, and began to modify and develop them with more powerful engines. The Air tourer became the T3, T4 etc, sold to air forces such as Australia, Thailand etc. The Air Cruiser came out from the wraps and was developed more as a military trainer. Went from a 4 seater back to a two seater, the cabin door replaced by a ejectable canopy. My job was mainly fixing snags after flight testing or doing mods to earlier aircraft.
No worries iana. Feel free to copy. I remember going on a test ride in a CT4 with Jeff Trappet at Sale, I had an inner ear infection I didnt know about. When he put it into an inverted spin my gyros went haywire and he had to land to let me out. I was so disorientated I exited at the leading edge and nearly walked through a spinning prop.. Lucky for me the groundy grabbed me and saved my miserable hide.
Nice little aircraft the parrot and the airtourer, did a few flights in those as well, bit hard getting use to the joystick in the centre.
Cheers
__________________
Ex RAAF, now retired. EX Electrician/Teacher.
Homebase is Murray Bridge Tourist Park (in a cabin). New Horse.. 2020 Ford Everest Titanium, Jayco swan for touring.