dslreports logo
 
    All Forums Hot Topics Gallery
spc
Search similar:


uniqs
862
scottp99
join:2010-12-11

scottp99

Member

[Excel] Need Help for creating Aviation related formulas

 
 
 
Hi - I need to create an Excel calculator with the following calculations from the few print screens 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.

Also I would like these to be in one worksheet.

Thanks!!!

H2OuUp2
Happy to be here
Premium Member
join:2002-03-15
Oklahoma City, OK

H2OuUp2

Premium Member

I uploaded a file with the formulas in it. Hope this helps.
H2OuUp2

H2OuUp2 to scottp99

Premium Member

to scottp99
Actually you see that your ground speed was 549.95 with the file I attached.

You can also figure feet per second by in the first box by using this formula. I put it in cell E5.

=SUM(C5*5280)/((C4*24)*3600)
scottp99
join:2010-12-11

4 edits

scottp99

Member

Hi great job, thanks!!!!!
Thats what I needed.

Also, this may be a bit more complicated, but would it be possible to compute the following for the HEADING from the print screen?

This is a bit more complicated. If your able to, please take your time on it and upload it.

I dont care about the FUEL FLOW or the FUEL BURNED.

Thanks.

H2OuUp2
Happy to be here
Premium Member
join:2002-03-15
Oklahoma City, OK

H2OuUp2 to scottp99

Premium Member

to scottp99
Here it is, but I didn't put any formulas in it because I didn't know the equations.
scottp99
join:2010-12-11

scottp99

Member

Well, that was my goal to give the end results. But if you or someone comes up with anything, please upload with formulas included. Thanks

H2OuUp2
Happy to be here
Premium Member
join:2002-03-15
Oklahoma City, OK

H2OuUp2

Premium Member

Would need a lot more information to put formulas in for the heading.
scottp99
join:2010-12-11

scottp99

Member

What if we took out the end result for the heading field entry?