Ethanol calculator spreadsheet

4015 Views 36 Replies 11 Participants Last post by SSgtjrobertson, 12 mo ago

junits15

Discussion Starter · 12 mo ago (Edited)

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

Reactions: 5

1 - 20 of 37 Posts

junits15

Discussion Starter · #2 · 12 mo ago (Edited)

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!

See less See more

Reactions: 4

xTheMan42

· #3 · 12 mo ago (Edited)

junits15 said:
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

Discussion Starter · #4 · 12 mo ago

xTheMan42 said:
Thought ST was 12 4?

You’re right I’ll fix that

Reactions: 1

Duece McCracken

· #5 · 12 mo ago

Ewww. Excel. Gross

🤢🤮

Reactions: 2

MtnMan

· #6 · 12 mo ago

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

Reactions: 1

Duece McCracken

· #7 · 12 mo ago

I just fill it with E85...

MtnMan

· #8 · 12 mo ago

Duece McCracken said:
I just fill it with E85...

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

Duece McCracken

· #9 · 12 mo ago

MtnMan said:
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.

Reactions: 1

MtnMan

· #10 · 12 mo ago

Duece McCracken said:
Ummmmmm

19 mpg highway if i drive like an old person.

10mpg city, about 13 commuting.

So worse mpt but more spg. 👍😎

Reactions: 2

junits15

Discussion Starter · #11 · 12 mo ago

Duece McCracken said:
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

Reactions: 1

MtnMan

· #12 · 12 mo ago

junits15 said:
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

Reactions: 1

Duece McCracken

· #13 · 12 mo ago

junits15 said:
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.

Reactions: 2

ddfred

· #14 · 12 mo ago

Duece McCracken said:
Ummmmmm

19 mpg highway if i drive like an old person.

10mpg city, about 13 commuting.

Bet I wouldn't get 19 mpg.

MtnMan

· #15 · 12 mo ago

Duece McCracken said:
I can barely type, let alone use excel.

Give me an abacus.

What, no slide rule? 😝

Reactions: 1

Duece McCracken

· #16 · 12 mo ago

ddfred said:
Bet I wouldn't get 19 mpg.

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

Reactions: 1

ddfred

· #17 · 12 mo ago

Duece McCracken said:
Idk if your bones could survive the G force...

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

Duece McCracken

· #18 · 12 mo ago

ddfred said:
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.

Reactions: 1

ddfred

· #19 · 12 mo ago

Duece McCracken said:
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...

Reactions: 1

Duece McCracken

· #20 · 12 mo ago

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

Recycling at it's finest!!

Reactions: 1

1 - 20 of 37 Posts

This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.