[junits15]

Hey all,

Decided to throw together an ethanol calculator spreadsheet for the forum. It works with any situation and with work with any car you may ever buy.


Its robust and unlike the apps you can download it is totally free, will never go away, and is actually easy to use (I think so anyway...)

Save it to your phone and use the google sheets app (or the MS excel app) to edit all of the orange quantities, the gold cells are the outputs and the blue cells are intermediate calculations and should be left as they are.

You can also save to your PC and use excel (which is nicer)
Ethanol calculator

 

[junits15]

Some notes:


if either of the two results are negative it signifies that there is not enough room in your fuel tank to reach your desired ethanol concentration given the current concentration of e85 available to you. In this situation, run the tank lower before filling up.


The spreadsheet is designed to work with the fuel level input monitor available on the cobb AP, I made it this way to discourage people from using the dashboard fuel gauge as it is extremely inaccurate.


You can use this with other cars by changing the fuel tank size. (focus st is 12.4 gallons)

Enjoy!

 

[xTheMan42]

Some notes:


if either of the two results are negative it signifies that there is not enough room in your fuel tank to reach your desired ethanol concentration given the current concentration of e85 available to you. In this situation, run the tank lower before filling up.


The spreadsheet is designed to work with the fuel level input monitor available on the cobb AP, I made it this way to discourage people from using the dashboard fuel gauge as it is extremely inaccurate.


You can use this with other cars by changing the fuel tank size. (focus st is 12.2 gallons)

Enjoy!

Thought ST was 12.4?

 

[junits15]

Thought ST was 12 4?

You’re right I’ll fix that

 

[Duece McCracken]

Ewww. Excel. Gross

🤢🤮

 

[MtnMan]

Thanks for the effort👍

I use this as a backup if the app seems off:
Use the tool below to calculate an ethanol mix!
Usually it's operator input error 😊😁

I mostly use this app:
E85 Mix Calculator - Apps on Google Play

 

[Duece McCracken]

I just fill it with E85...

 

[MtnMan]

I just fill it with E85...

Getting more miles per tank on E85 in the stang? 🤔😜😁

 

[Duece McCracken]

Getting more miles per tank on E85 in the stang? 🤔😜😁

Ummmmmm

19 mpg highway if i drive like an old person.

10mpg city, about 13 commuting.

 

[MtnMan]

Ummmmmm

19 mpg highway if i drive like an old person.

10mpg city, about 13 commuting.

So worse mpt but more spg. 👍😎

 

[junits15]

Ewww. Excel. Gross

🤢🤮

I’ve become too comfortable with excel, I can’t ever go back

besides everyone got it so it works well, it’s a criminally under utilized tool

 

[MtnMan]

I’ve become too comfortable with excel, I can’t ever go back

besides everyone got it so it works well, it’s a criminally under utilized tool

I refuse to use MS office and most Google stuff on personal devices unless I have to. Libre FTW
Home | LibreOffice - Free Office Suite - Based on OpenOffice - Compatible with Microsoft

 

[Duece McCracken]

I’ve become too comfortable with excel, I can’t ever go back

besides everyone got it so it works well, it’s a criminally under utilized tool

I can barely type, let alone use excel.

Give me an abacus.

 

[ddfred]

Ummmmmm

19 mpg highway if i drive like an old person.

10mpg city, about 13 commuting.

Bet I wouldn't get 19 mpg.

 

[MtnMan]

I can barely type, let alone use excel.

Give me an abacus.

What, no slide rule? 😝

 

[Duece McCracken]

Bet I wouldn't get 19 mpg.

Idk if your bones could survive the G force...

 

[ddfred]

Idk if your bones could survive the G force...

I don't think your Bullitt could survive these old bones.

 

[Duece McCracken]

I don't think your Bullitt could survive these old bones.

Well, when your hip goes out trying to get low enough to enter the vehicle, my rear quarter/door will indeed suffer damage.

 

[ddfred]

Well, when your hip goes out trying to get low enough to enter the vehicle, my rear quarter/door will indeed suffer damage.

I've got the hips of a 50 year old...

 

[Duece McCracken]

I've got the hips of a 50 year old...

Recycling at it's finest!!