+ Reply to Thread
Results 1 to 10 of 10

Fuel Burn Formula

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    KSA
    MS-Off Ver
    2011 MAC & Mac 2015
    Posts
    53

    Question Fuel Burn Formula

    Fuel burn.xlsx

    Hi,

    please find the attached file


    im trying to calcultae the fuel burn for one of our Aircraft depending on how much is the block time


    so..
    hours:
    1st 3000lbs
    2nd 2900lbs
    3rd 2100lbs
    4th 2100lbs
    5th 2100lbs
    6th 2100lbs
    7th 2100lbs

    if i fly 1 hour.. .then it will be 3000 lbs fuel burning
    if i fly 1.5 hr it will be 1hr*3000 lbs + .5hr * 2900 = 4450 lbs .
    if i fly 4.7hrs it will be ... 1hr*3000lbs + 1hr*2900lbs + 1hr*2100lbs + 1hr*2100lbs +.7 hr* 2100lbs = 11570lbs of fuel burning.


    now how can i make a formula to under stand that each hour should be multiplied by each cell and sum it up in one cell ?


    thank you


    regards,
    Hani

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    1,869

    Re: Fuel Burn Formula

    Fuel%20burn(1).xlsx


    Doe this do what you want it to do?

  3. #3
    Registered User
    Join Date
    07-01-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Fuel Burn Formula

    hi..

    add alternative solutions

    regards,
    JRD

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,556

    Re: Fuel Burn Formula

    Try this in E3 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Edit: I did convert your data from text to numbers.
    Attached Files Attached Files
    Last edited by Jacc; 06-14-2014 at 04:06 AM.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    25,376

    Re: Fuel Burn Formula

    Beaten to it this time, Hani. But the same sort of solution...
    Attached Files Attached Files
    Glenn



  6. #6
    Registered User
    Join Date
    02-27-2013
    Location
    KSA
    MS-Off Ver
    2011 MAC & Mac 2015
    Posts
    53

    Re: Fuel Burn Formula

    All,

    thx for your help
    JR Dhona...thats exactly what i want . i did not understand anything from that formula . but its working lol. do u have a link on youtube or anywhere else explaining this ?

    Crooza. i like what you have done but its a bit complicated as you added extra coloumn.also , when you multiply 1.5 you multiply first hour with with first hour of fuel burn. for the .5 hr , you need to multiply it by the second hr of fuel burn not the first hour

    JACC...thank you . but the answer gave me 0 //

  7. #7
    Registered User
    Join Date
    02-27-2013
    Location
    KSA
    MS-Off Ver
    2011 MAC & Mac 2015
    Posts
    53

    Re: Fuel Burn Formula

    thx Glenn!!! awesom bro!!

  8. #8
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,556

    Re: Fuel Burn Formula

    Quote Originally Posted by guitarist00 View Post

    JACC...thank you . but the answer gave me 0 //
    Check out the workbook I attached in post #4 instead.

  9. #9
    Registered User
    Join Date
    02-27-2013
    Location
    KSA
    MS-Off Ver
    2011 MAC & Mac 2015
    Posts
    53

    Re: Fuel Burn Formula

    thx Jacc . working perfectly

  10. #10
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,556

    Re: Fuel Burn Formula

    He he... you can tell this was a fun problem to solve, so many different but correct answers in a short time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculating complex Fuel Cost based on Individual Name, Engine CC, Fuel Type and Date.
    By shadypops in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2013, 01:38 PM
  2. [SOLVED] Fuel type fill base on kind of fuel.
    By yukioh in forum Excel General
    Replies: 2
    Last Post: 01-18-2013, 02:12 AM
  3. [SOLVED] How to calculate fuel burn in litres per H:MM
    By nje in forum Excel General
    Replies: 3
    Last Post: 09-17-2012, 07:51 AM
  4. fuel formula
    By bhopkins in forum Excel General
    Replies: 2
    Last Post: 12-30-2011, 06:38 PM
  5. Fuel Formula per day
    By Ancie Saesaria in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2008, 08:22 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1