Boat Fuel Burn Rate Sheet

[Dave LeGear]

Finally (that was a brain work over)

I think I have now stuffed enough Auto Calc and Data Validation toys into the New "Boat Fuel Burn sheet" to suit most everybody's needs Now I would have added an "Running Average Cost Per Hour" rate column like I have on the Truck Sheet, but that function (formula) was more than my brain could grind on right now

Maybe some "Real" Excel 2003 Mechanic in the group here could add that in, and then send me a copy to re-post... Now this sheet will track your first 110 tanks of fuel and let me know if you need to track more (which means your fishing a heck of a lot more than me) and I will extend the auto fill fields down even further...

And remember to save on Fuel in the Truck so you can pour more it into the Boat

Dave

 

[Island_Diver]

Problem with the spreadsheet

Dave,

I downloaded that nifty spreadsheet that you made...but none of the data was readable on it. Do you have another copy? It might be something on my end...but it only shows crazy formulas or something. I'm not the site's XCel guru by any means.

Thanks,
Mike

 

[greyoldchief]

Fuel Burn Sheet

Diver:

If you're talking about columns G and I, these will change to data as you enter your information in the other columns.

 

[Dave LeGear]

Chief is correct!
Those are the classic "can't divide by zero" error message that Excel shows when you have missing data. As you fill in the various colums, they will auto fill and also change as you make changes and "update" certain fields. Fill free to enter in some bogus data in a separate renamed copy to see how how it all works

Dave

 

[Dave LeGear]

I just re-posted an the sheet above since I found some different Octane grades at one of the local stations the other day. I also added the E85 fuel as a Octane grade drop down section in the same section.

Enjoy!

 

[Dave LeGear]

Thanks to Tom "Deer Hunter" the sheet has now been updated and looks a lot cleaner, but still has all the same basic tools and functions Now I just need him to clean up the one for your truck

Thanks again Tom!

 

[DeerHunter]

Dave,

Your welcome.

If you repost the truck spreadsheet, I'd be glad to take a look at it.

Thanks,

Tom

 

[Dave LeGear]

Took me a little while to find it again since it was buried in the towing section, but Tom you can find it here

New automotive fuel tracking sheet

With the help of "Deer Hunter" on this new sheet (sorry it took so long Tom) I was able to recover the improved fuel and service tracking Excel sheet he worked on, from the PC I had it stored on when it crashed. Now this one tracks both fuel and service (maintenance) costs at the same time to...

www.performanceoutdoors.net

Thanks!

 

[Dave LeGear]

Maximizing Efficiency: Tracking Fuel Burn and Maintenance Costs​

Now updated with more information on the link below:

https://www.flatsnation.com/post/maximizing-efficiency-tracking-fuel-burn

Latest updates here:

Enjoy!