Results 1 to 6 of 6

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. #1
    New Member
    Join Date
    Dec 2008
    Posts
    3

    Default 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. #2
    Board Regular Blade Hunter's Avatar
    Join Date
    Mar 2008
    Location
    Sydney, Australia
    Posts
    2,817

    Default 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
    .select, overused and inefficient.

  3. #3
    Board Regular RobMatthews's Avatar
    Join Date
    Nov 2008
    Location
    Brisbane, AU
    Posts
    77

    Default 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. #4
    New Member
    Join Date
    Dec 2008
    Posts
    3

    Default 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.

    Thanks in advance.

  5. #5
    Board Regular Blade Hunter's Avatar
    Join Date
    Mar 2008
    Location
    Sydney, Australia
    Posts
    2,817

    Default 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
    .select, overused and inefficient.

  6. #6
    New Member
    Join Date
    Dec 2008
    Posts
    3

    Default 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.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com