# Fuel Ratio Calculator for 2 Stroke engines

This is a discussion on Fuel Ratio Calculator for 2 Stroke engines within the Excel Questions forums, part of the Question Forums category; Hi, my first post. I am looking at ways to create my own fuel/oil mix calculator. I know 50:1 is ...

1. ## Fuel Ratio Calculator for 2 Stroke engines

Hi, my first post.
I am looking at ways to create my own fuel/oil mix calculator.
I know 50:1 is 100 Millilitres Oil to 5 Litres of Fuel.
Or, 20:1 is 250 Millitres Oil to 5 Litres of Fuel
There are various hard copy tables around or lables on oil containers showing the basic rounded figures only.

But I have no clue as to how the fomulae is in Excel so I can enter my own figures for various Fuel Ratio Oil mixes.
For example, I might require a 32:1 mix in 36.7 Litres of Fuel
My calculator would then calculate the exact amount of oil to mix in a 36.7 Litre container. (This is just an example, but the oil mixes MUST be accurate)

Can someone help with the formulae please ?

2. ## Re: Fuel Ratio Calculator for 2 Stroke engines

=B1/A1 where A1 is your number ration to 1 and B is your litres of fuel

Or if you want the oil in ml =(B1/A1)*1000

3. ## Re: Fuel Ratio Calculator for 2 Stroke engines

Welcome.

VERY simple.
cell A1 "Fuel:Oil Ratio"
cell A2 "20" This should be changed to suit the ratio you want.
cell B2 ":1"

cell A4 "Fuel"
cell B4 "Oil"
cell A5 "35" Or however many litres petrol
cell b5 "=A5/A2"

4. ## Re: Fuel Ratio Calculator for 2 Stroke engines

Thankyou,
I need 2 more formulaes please.

The other method percentages are used.
Some technical manuals define ratios in percents
So for example, 2 % oil to 1 Litre of fuel,
So if a cell asks to enter the value 1 (%), and we have 5 Litres of fuel, the answer ought to show 100 Millitres
How do I write that formulae ?

and
also a conversion from the basic calculation, that IF
a ratio of 50:1 is 100 Ml. of oil to 5 Litres of Fuel, then a formulae is required to calculate a sum to show the percent value.
I make it to be 1%
If Cell C2 is where I place your above formulae/s
In cell D2 I have put,
=C2/100 and get the answer 1.00 (%)
My ratio is 1 percent ?

This should complete my calculator.

5. ## Re: Fuel Ratio Calculator for 2 Stroke engines

1)

=(A2*B2)*1000

Where A2 is litres of fuel and B2 is % (Incidentaly, the result is 50ml, not 100 in the example you gave)

2) 50:1 ratio would be 2%

If A3 is your ratio (50)
B3 is your litres of fuel (5)
C3 would be =(B3/A3)*1000 to show ml of oil
D3 would be =C3/(B3*1000) to show the percentage

6. ## Re: Fuel Ratio Calculator for 2 Stroke engines

the result is 50ml, not 100 in the example you gave)
Yep, typo stuff, np

Thanks Blade and Rob, I should ok from here with these basics.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•