Fuel Ratio Calculator for 2 Stroke engines

abbmota

New Member
Joined
Dec 2, 2008
Messages
3
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 ?
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
=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
 
Upvote 0
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"
 
Upvote 0
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.

Thanks in advance.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top