johno
Carrollton Tx USA
Full Member
Joined: 08/24/2002
View Profile
 Offline
|
Hi All.
Is there a milage/mpg/$ per gallon spreadsheet available on the fourm.. Im planing a trip & want to plug in some
#s : ie distance in miles/ gallons needed /to equal the mpg obtained at the current price per gallon.... Hope Im making myself clear.
And it gives new values, whenever any figure is changed.. I dont know a thing about Exel.
Thanks
John O
Forest River Sierra 355RLT
03'Ford SD 250 Lariat 4x4
Tekonsha Prodigy.
|
SRT
Head of the Lakes, MN
Senior Member
Joined: 02/18/2001
View Profile
Offline
|
did my own in Excel. 
SRT
2000 32' HR Vacationer with Banks
1998 Subaru Outback Ltd. 5 spd
Brake Buddy & Blue Ox Aventa II tow bar
FMCA #266040 HRRVC #84109
|
downtheroad
Puget Sound
Senior Member
Joined: 02/18/2003
View Profile
|
Here is one you can play with. Hope this helps.
Fuel Cost Calculator
GMC Duramax/Allison (LBZ)
Komfort 277TS Our Rig Pic
Reese Dual Cam HP
|
VernM
Marion County, AR
Senior Member
Joined: 06/21/2006
View Profile
Offline
|
Factor in terrain, traffic and number of turns, too. They'll maybe average out but have an impact on overall mileage. So does altitude on some engines with electronic timing and mixture control.
VernM
GMC Conversion van/Wells Cargo MiniWagon trailer
Sent via HughesNet/SatMex5 Internet Portal
.jpg)
|
goin2themountains
Aztec, NM
Senior Member
Joined: 04/04/2007
View Profile
Offline
|
I just use the one on Mapquest, but should be simple to do a column A x column B type spreadsheet in Excel
Puller: '04 HD2500 4x4 SB,EC Duramax/Allison. Airaid intake, 4in. exhaust turbo back, ORU leveler.
Pullee: '02 Keystone Cougar 276EFS Reese 16k w/ slider.
(map is for current 5er only)
|
|
|
crickeydog
Marietta, Ga.
Senior Member
Joined: 01/29/2004
View Profile
Offline
|
FWIW: Here's how I do it. We take our trip. Then, when we get home, I total up the fuel receipts including gallons used and total miles traveled. Divide the gallons and dollars used by the miles traveled, and I get my total dollars spent per mile and average MPG. I know it's a little after the fact but I like surprises. Besides, wouldn't matter if I got 21 MPG or our usual 11MPG towing or if diesel fuel was $2 a gallon or $5 a gallon; we're still gonna take the trip.
Happy camping!!! See ya'll down the road!!!
AIR FORCE RETIRED "EITHER LEAD,FOLLLOW,OR GET OUT OF MY WAY"!
2006 GMC 3500 SLT CC DRW 4X4 D/A LBZ,PREDATOR & FS2500 OIL FILTER
2004 HR PRESIDENTIAL 30 SCD 5'ER.
CHEROKEE & CHEYENNE, MINI DOXIE'S
LOADED LIKE A FREIGHT TRAIN, FLYIN LIKE A JET PLANE!!
|
rvaddicted
Moore, Oklahoma
New Member
Joined: 12/22/2005
View Profile
Offline
|
When we get ready to take a trip, we use the trip planner on
this site. It gives you good sam parks along the way and
other options. I just print it off and take it with us,
We love it !
2000 Dodge Ram DRW Cummins
2003 33ckt Spinnaker
|
othertonka
Stockton, CA
Senior Member
Joined: 11/15/2003
View Profile
|
Miles traveled divided by Gallons used = MPG
Example, Iwent 500 miles and I used 50 gallon of fuel. 500 divided by 50 = 10MPG
Total fuel cost Divided by Miles traveled = Fuel Cost per mile
Example, 50 gallons at $4.30 @ Gal = $215.00 Divided by 500 miles = $ .43 per mile
Miles you want to travel that day divided by my average MPG = amount of fuel I will need to make the trip.
Example, I want to travel 250 miles today, I get 10 MPG, 250 divided by 10 = 25 gallons needed
This info can also be put in a Database file by making "Fields" for each catagory and then enter the formulas in the "Fields" that need to be calculated and when the knowns are filled in, it will calculate the unknowns.
"Miles Traveled" would be the first Field, "Gallons used" would be the next Field, "Total Cost of fuel" would be another field, MPG would be another Field and you would enter a formula in that field that would say,
=Miles Traveled/Gallons used and it will calculate MPG. And so on. Customize it to fit your needs. You could even add a Field for the name of the trip you are on. If you don't know how to create a spreadsheet or a Database it is kind of hard to explain in a short space.
Othertonka
2004 Southwind 32VS
2002 CRV Toad
U. S. Gear Unified brake system
Retired Fire Captain, SFD
|
george1
Mississippi Gulf Coast
New Member
Joined: 01/14/2003
View Profile
Offline
|
I used the spreadsheet Microsoftworks 4.0 to create a simple fuel cost calculator. I could email it to you if you would like and have the program to open it (probably any spreadsheet would open and convert it).
05 Airstream Safari 28 (Slide)
03 FORD PSD 6.0
|
RodT82721
Pine Haven, Wyoming
Full Member
Joined: 08/23/2005
View Profile
Offline
|
I use the RVers Notebook software. I keep a complete history of all MH expenses and maintenance work with it. Along with the toad and the Gen Set. It then can easily produce reports for MPG and total Costs etc. The hardest part is recording the information before losing the receipts.
2001 Winnebago Minni - 31C
Ford E450 - V10 Triton
Tow - 2005 Jeep Liberty
|
|
|
