Fuel Economy Spreadsheets

poldim · 12-01-2005, 10:44 PM

So I was searching through some of the MPG threads and found out I wasnt the only OCD E90 owner.

Here is mine: www.poldim.com/auto/fuel.htm

It will eventually be implemented into the webpage that I will make....eventually.

petesamprs · 12-02-2005, 10:22 AM

Post the excel version and I'll start using it and report back

poldim · 12-02-2005, 11:01 AM

Will do when I get home.

Its not 1000% accurate for each trip, but overall should be pretty accurate since its based on all fuel bought and all miles traveled.

In general, I just fill at the pump until it clicks off to approximately fill to the same point every time.

petesamprs · 12-02-2005, 11:06 AM

What makes this strategy less than 100% accurate? Don't worry about sending it. I just copy/pasted from your website into excel and recreated the formulas real quick.

xrayvision · 12-02-2005, 12:59 PM

have you considered adding a column stating what type of driving (city vs highyway) was done?

poldim · 12-02-2005, 02:06 PM

Quote:

Originally Posted by petesamprs

What makes this strategy less than 100% accurate? Don't worry about sending it. I just copy/pasted from your website into excel and recreated the formulas real quick.

For each trip, there is no way to track exatcly how much gas you used. Its probably plus or minus about a gallon and a half. If you fill at the same gas station, same pump, and the gas vapors/liquid that turns off the pump in the same spot every time you fill, then it'd be accurate, but that doesnt happen. If you are on an incline, a lot more/less gas might go in even though the pump shuts off. Various pumps have slightly different sensitivities and so on.

You can track milage, but amount of fuel burned is a little bit more of an estimate.

poldim · 12-02-2005, 02:11 PM

Quote:

Originally Posted by xrayvision

have you considered adding a column stating what type of driving (city vs highyway) was done?

I thought about it but then realized it a waste of space. You should be able to figure this out from the MPG.

Considering you can go about 400 miles on a tank of gas, I think you will encounter all types of driving.

Mine is 350 mile trips between houses, but then I gun it up and down the mountains and shot the 33 mpg down to 30

Broken1 · 12-04-2005, 07:37 AM

Thought I had to post mine up here too...

It's not 1000% accurate, but it's pretty good. I've filled up at the same station the last few times, and only used two different pumps!

As to my type of driving -> Mostly city driving, with my VERY heavy foot...

LEDZEP · 12-04-2005, 08:53 AM

I've been keeping spreadsheets like this for my last 4 cars...

petesamprs · 12-04-2005, 09:18 AM

Assuming this is for your e90, you must drive like a grandma. Those mpg figures are off the charts.

Edit: I guess the avg speed explains it pretty well. Looks like >90% highway driving.

LEDZEP · 12-04-2005, 09:41 AM

Yep. My daily commute is almost all highway, with the occasional bogging in heavy traffic. We haven't racked up enough miles on the E91 yet to have meaningful numbers, plus it's not past break-in yet. So those numbers are all for the E90.

scottz5 · 12-04-2005, 09:52 AM

You guys have way to much time on your hands.

LEDZEP · 12-04-2005, 09:54 AM

You think us OCD people have a choice?!

scottz5 · 12-04-2005, 10:14 AM

Quote:

Originally Posted by LEDZEP

You think us OCD people have a choice?!

lol i guess not. All I know is I put gas in my car once a week or so.

Atty · 12-04-2005, 10:32 AM

Wow, I knew you guys were anal about your cars, but isn't this going a little overboard.

You should consider keeping more spreadsheets on things like: how much food you eat each day; on how much soap you use in the shower; on how many keystrokes you expend while on this forum; and on how many farts you make per mile.

LOL

BMW0 · 12-04-2005, 10:35 AM

25 miles to the gallon according to the on board computer.

LEDZEP · 12-04-2005, 12:10 PM

Quote:

Originally Posted by Atty

Wow, I knew you guys were anal about your cars, but isn't this going a little overboard.

You should consider keeping more spreadsheets on things like: how much food you eat each day; on how much soap you use in the shower; on how many keystrokes you expend while on this forum; and on how many farts you make per mile.

LOL

Oh, I didn't know you wanted to see those too... I have them!

I even have a spreadsheet that tracks how much time I spend making spreadsheets!

Broken1 · 12-04-2005, 02:49 PM

Quote:

Originally Posted by LEDZEP

Oh, I didn't know you wanted to see those too... I have them!

I even have a spreadsheet that tracks how much time I spend making spreadsheets!

eheh :-) I have a spreadsheet on how much cleaning my car, and cleaning my lemon leather costs

I can't help it...

Ps. No one outside these forums knows of my obsession. They all know I love cars, but no one knows how deeply addicted I am

David328M-Sport · 12-04-2005, 04:04 PM

LEDZEP,

WOW!!! That spreadsheet is MASSIVE. I'm speechless. I don't do anything like that at all. I just check the average L/100km use from time to time and fill up when I need to. I run a business and I write off all car expenses. I just have to keep receipts.

That's mighty impressive. Keep up the great work.

David328M-Sport · 12-04-2005, 04:08 PM

Hey Broken 1,

Neat little spreadsheet. Pales compared to Ledzep but if it keeps you informed, then it does its job and that's all that matters.

And do you scent your lemon coloured seats with lemon fragrance?

Cheers

LEDZEP · 12-04-2005, 04:19 PM

Quote:

Originally Posted by David325Australia

LEDZEP,

WOW!!! That spreadsheet is MASSIVE. I'm speechless. I don't do anything like that at all. I just check the average L/100km use from time to time and fill up when I need to. I run a business and I write off all car expenses. I just have to keep receipts.

That's mighty impressive. Keep up the great work.

A bit of a compulsion I admit. But since I've been doing it for so long it's not really any work at all. I just jot down the stats on my gas receipt (miles driven, avg speed, OBC mileage) and enter that and the fill up info. Thanks for the compliment.

ward · 12-04-2005, 04:56 PM

wow,

I'm very impressed by the amount of tracking you guys do on this

is it just for fun or do some of you log miles for tax reasons?

12-01-2005, 10:44 PM	#1
poldim Vroom Vrrooooom 308 Rep 3,146 Posts Drives: 330i Join Date: Oct 2005 Location: Bay Area, CA iTrader: (2) Garage List 2006 330i Sedan [0.00] 2003 GSX-R 600 [0.00]	Fuel Economy Spreadsheets - POST EM' So I was searching through some of the MPG threads and found out I wasnt the only OCD E90 owner. Here is mine: www.poldim.com/auto/fuel.htm It will eventually be implemented into the webpage that I will make....eventually. __________________ -Dmitriy 06' BMW 330i & 03' Suzuki GSX-R600 SG \| Beige Dakota \| Poplar \|\| iDrive w/MP3 \| PP \| SP \| CWP \| PDC \| Comfort \| Shades \|\| 40% Tint \| Black Line Tail Lights \| Hardwired V1
	Appreciate 0 Tweet Quote

12-02-2005, 10:22 AM	#2
petesamprs Lieutenant 35 Rep 521 Posts Drives: . Join Date: Aug 2005 Location: northeast iTrader: (0)	Post the excel version and I'll start using it and report back __________________ '14 535i (ED) Retired: '08 M5, '08 550i (ED), '06 330i
	Appreciate 0 Quote

12-02-2005, 11:01 AM	#3
poldim Vroom Vrrooooom 308 Rep 3,146 Posts Drives: 330i Join Date: Oct 2005 Location: Bay Area, CA iTrader: (2) Garage List 2006 330i Sedan [0.00] 2003 GSX-R 600 [0.00]	Will do when I get home. Its not 1000% accurate for each trip, but overall should be pretty accurate since its based on all fuel bought and all miles traveled. In general, I just fill at the pump until it clicks off to approximately fill to the same point every time. __________________ -Dmitriy 06' BMW 330i & 03' Suzuki GSX-R600 SG \| Beige Dakota \| Poplar \|\| iDrive w/MP3 \| PP \| SP \| CWP \| PDC \| Comfort \| Shades \|\| 40% Tint \| Black Line Tail Lights \| Hardwired V1
	Appreciate 0 Quote

12-02-2005, 11:06 AM	#4
petesamprs Lieutenant 35 Rep 521 Posts Drives: . Join Date: Aug 2005 Location: northeast iTrader: (0)	What makes this strategy less than 100% accurate? Don't worry about sending it. I just copy/pasted from your website into excel and recreated the formulas real quick. __________________ '14 535i (ED) Retired: '08 M5, '08 550i (ED), '06 330i
	Appreciate 0 Quote

12-02-2005, 12:59 PM	#5
xrayvision Registered 1 Rep 3 Posts Drives: lexus rx300 Join Date: Aug 2005 Location: austin, tx iTrader: (0)	have you considered adding a column stating what type of driving (city vs highyway) was done?
	Appreciate 0 Quote

12-04-2005, 07:37 AM	#8
Broken1 Addict 206 Rep 2,074 Posts Drives: 2024 X5 40i M-Sport Join Date: May 2005 Location: Ontario iTrader: (0)	Thought I had to post mine up here too... It's not 1000% accurate, but it's pretty good. I've filled up at the same station the last few times, and only used two different pumps! As to my type of driving -> Mostly city driving, with my VERY heavy foot... Attached Images
	Appreciate 0 Quote

12-04-2005, 08:53 AM	#9
LEDZEP Lieutenant General 424 Rep 12,276 Posts Drives: 2009 E70 & 2011 F25 Join Date: Jun 2005 Location: Area 51 iTrader: (0) Garage List 2011 X3 35i M Sport [7.62] 2009 X5 M Sport [0.00] 2007 328xi E90 [0.00] 2006 325xiT E91 [0.00]	I've been keeping spreadsheets like this for my last 4 cars... Attached Images __________________ I think it is bad luck to be superstitious
	Appreciate 0 Quote

12-04-2005, 09:18 AM	#10
petesamprs Lieutenant 35 Rep 521 Posts Drives: . Join Date: Aug 2005 Location: northeast iTrader: (0)	Assuming this is for your e90, you must drive like a grandma. Those mpg figures are off the charts. Edit: I guess the avg speed explains it pretty well. Looks like >90% highway driving. __________________ '14 535i (ED) Retired: '08 M5, '08 550i (ED), '06 330i
	Appreciate 0 Quote

12-04-2005, 09:41 AM	#11
LEDZEP Lieutenant General 424 Rep 12,276 Posts Drives: 2009 E70 & 2011 F25 Join Date: Jun 2005 Location: Area 51 iTrader: (0) Garage List 2011 X3 35i M Sport [7.62] 2009 X5 M Sport [0.00] 2007 328xi E90 [0.00] 2006 325xiT E91 [0.00]	Yep. My daily commute is almost all highway, with the occasional bogging in heavy traffic. We haven't racked up enough miles on the E91 yet to have meaningful numbers, plus it's not past break-in yet. So those numbers are all for the E90. __________________ I think it is bad luck to be superstitious
	Appreciate 0 Quote

12-04-2005, 09:52 AM	#12
scottz5 Lieutenant Colonel 96 Rep 1,730 Posts Drives: 13 F10 535xi & 11.75 E93 M3 Join Date: May 2005 Location: Earth iTrader: (0)	You guys have way to much time on your hands. __________________ 13 F10 535xi JB/B working on it 11.75 E93 M3 MR/Black Stock (wifey) 11 F10 535i AW/CB Mods Gone
	Appreciate 0 Quote

12-04-2005, 09:54 AM	#13
LEDZEP Lieutenant General 424 Rep 12,276 Posts Drives: 2009 E70 & 2011 F25 Join Date: Jun 2005 Location: Area 51 iTrader: (0) Garage List 2011 X3 35i M Sport [7.62] 2009 X5 M Sport [0.00] 2007 328xi E90 [0.00] 2006 325xiT E91 [0.00]	You think us OCD people have a choice?! __________________ I think it is bad luck to be superstitious
	Appreciate 0 Quote

12-04-2005, 10:32 AM	#15
Atty Second Lieutenant 18 Rep 239 Posts Drives: 09 X5 48i M-Sport Join Date: Sep 2005 Location: Los Angeles iTrader: (0) Garage List 2006 (September bui ... [0.00]	Wow, I knew you guys were anal about your cars, but isn't this going a little overboard. You should consider keeping more spreadsheets on things like: how much food you eat each day; on how much soap you use in the shower; on how many keystrokes you expend while on this forum; and on how many farts you make per mile. LOL __________________ Attorney E90 330i 6MT \| Black Sapphire \| Terra \| Burl \| ZSP \| ZPP \| ZCW \| Navi \| Sirius
	Appreciate 0 Quote

12-04-2005, 10:35 AM	#16
BMW0 Colonel 251 Rep 2,059 Posts Drives: AW E90 330i Join Date: Nov 2005 Location: Spokane, WA iTrader: (0) Garage List 2006 330i [0.00]	25 miles to the gallon according to the on board computer. __________________ 330i 6MT l 255 HP @ 5900 rpm 214 lb-ft Torque @ 3500 rpm l Alpine White l Beige l Aluminum l ZSP l 494 l PDC "Freude am Fahren" = "Joy to Drive"
	Appreciate 0 Quote

12-04-2005, 04:04 PM	#19
David328M-Sport Brigadier General 102 Rep 3,566 Posts Drives: F30 M-Sport 328i Estoril Blue Join Date: Jun 2005 Location: Melbourne Australia iTrader: (0)	LEDZEP, WOW!!! That spreadsheet is MASSIVE. I'm speechless. I don't do anything like that at all. I just check the average L/100km use from time to time and fill up when I need to. I run a business and I write off all car expenses. I just have to keep receipts. That's mighty impressive. Keep up the great work. __________________ 328i M-Sport, Estoril Blue, Carbon XP 35 Tint, front heated seats, black Dakota, Sports Suspension, Anthracite Headliner, HUD, Pro Nav, Sunroof, hk 600w, Bi-Xenon, 19" 403M wheels, Reversing Camera, DAB+, Xenon, BT Ext Connect, MST turbo intake pipe, MST Cold Air Intake, JB4 on Map 2 with Catless DP produces awesome performance in Sport.
	Appreciate 0 Quote

12-04-2005, 04:08 PM	#20
David328M-Sport Brigadier General 102 Rep 3,566 Posts Drives: F30 M-Sport 328i Estoril Blue Join Date: Jun 2005 Location: Melbourne Australia iTrader: (0)	Hey Broken 1, Neat little spreadsheet. Pales compared to Ledzep but if it keeps you informed, then it does its job and that's all that matters. And do you scent your lemon coloured seats with lemon fragrance? Cheers __________________ 328i M-Sport, Estoril Blue, Carbon XP 35 Tint, front heated seats, black Dakota, Sports Suspension, Anthracite Headliner, HUD, Pro Nav, Sunroof, hk 600w, Bi-Xenon, 19" 403M wheels, Reversing Camera, DAB+, Xenon, BT Ext Connect, MST turbo intake pipe, MST Cold Air Intake, JB4 on Map 2 with Catless DP produces awesome performance in Sport.
	Appreciate 0 Quote

12-04-2005, 04:56 PM	#22
ward Major General 157 Rep 6,158 Posts Drives: F Join Date: May 2005 Location: T iTrader: (0)	wow, I'm very impressed by the amount of tracking you guys do on this is it just for fun or do some of you log miles for tax reasons?
	Appreciate 0 Quote