dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
586
share rss forum feed

scottp99

join:2010-12-11

[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
join:2002-03-15
Oklahoma City, OK

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


H2OuUp2
Happy to be here
Premium
join:2002-03-15
Oklahoma City, OK
reply 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)
--
He is no fool who gives up what he cannot keep, to gain what he cannot lose. - Jim Elliot


scottp99

join:2010-12-11

4 edits

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
join:2002-03-15
Oklahoma City, OK
reply to scottp99

downloadMPH Formula.xlsx.zip 225,650 bytes
Here it is, but I didn't put any formulas in it because I didn't know the equations.

scottp99

join:2010-12-11

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
join:2002-03-15
Oklahoma City, OK

Would need a lot more information to put formulas in for the heading.


scottp99

join:2010-12-11

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