+ Reply to Thread
Results 1 to 10 of 10

Need Help for creating Aviation related formulas

  1. 11-17-2012, 06:41 AM #1
    darpa999
    darpa999 is offline
    Registered User
    Join Date
    11-17-2012
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    5

    Need Help for creating Aviation related formulas

    Hi - I need to create an Excel calculator with the following attached print screens calculations that I uploaded.

    Is there anyway to create these formulas so I can do these calculations like the ones from the print screens?

    If so, please provide these formulas or any detailed explainations on the steps on how to create these formulas.
    Examples would be great for me if someone has the time to compile one using the examples from the attached files.

    Also I would like these to be in one worksheet.

    Thanks!!!
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 11-17-2012, 06:55 AM #2
    BB1972
    BB1972 is offline
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Need Help for creating Aviation related formulas

    darpa, welcome to the forum.

    It's unclear what "calculations" are being performed in your screen-shots, so a good place to start would be to give an explanation of these calculations.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
    Reply With QuoteRegister To Reply
  3. 11-17-2012, 07:55 AM #3
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Need Help for creating Aviation related formulas

    H darpa999

    Something along these lines!

    (Distance/Ground_speed)/24
    Reply With QuoteRegister To Reply
  4. 11-17-2012, 01:29 PM #4
    Teethless mama
    Teethless mama is offline
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Need Help for creating Aviation related formulas

    See the attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 11-17-2012, 02:19 PM #5
    darpa999
    darpa999 is offline
    Registered User
    Join Date
    11-17-2012
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need Help for creating Aviation related formulas

    Ok, now... Sorry, but this a bit more complicated.
    See attached.

    How about this one?

    Can we make an Excel formula to give the end results from the following attached?

    I do NOT care about the Fuel Burn and Fuel Flow info, so I want to leave that out.

    No rush please. It can wait.

    Thanks
    Attached Images Attached Images
    Last edited by darpa999; 11-17-2012 at 02:29 PM.
    Reply With QuoteRegister To Reply
  6. 11-17-2012, 03:25 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need Help for creating Aviation related formulas 

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  7. 11-17-2012, 04:47 PM #7
    darpa999
    darpa999 is offline
    Registered User
    Join Date
    11-17-2012
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need Help for creating Aviation related formulas

    The rest of the end results come up fine except for the ETE which comes as #DIV/0!
    Can you please compile all this into a readily available Excel sheet?

    I would appreciate it.

    Thanks
    Reply With QuoteRegister To Reply
  8. 11-17-2012, 04:55 PM #8
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need Help for creating Aviation related formulas

    Attached .
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 11-17-2012, 05:15 PM #9
    darpa999
    darpa999 is offline
    Registered User
    Join Date
    11-17-2012
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need Help for creating Aviation related formulas

    WOW great!!!

    Thanks!!!! a million
    Reply With QuoteRegister To Reply
  10. 11-18-2012, 03:43 AM #10
    darpa999
    darpa999 is offline
    Registered User
    Join Date
    11-17-2012
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need Help for creating Aviation related formulas

    Hi -

    For some odd reason your calculations for the Ground Speed are not matching up with the tool that I am using now.
    Please view the attached print image. And also the time is off.

    ThanksNoMatch.JPG
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1