Print Page | Close Window

performance calculation worksheet

Printed From: ATR Discussion Forums
Category: ATR Discussion Forums
Forum Name: Pilot to Pilot - Flying the ATR
Forum Description: Discuss proper flying procedures and systems management.
URL: http://atr.flight1.net/forums/forum_posts.asp?TID=2291
Printed Date: March-29-2020 at 2:55am
Software Version: Web Wiz Forums 11.10 - http://www.webwizforums.com


Topic: performance calculation worksheet
Posted By: lilo
Subject: performance calculation worksheet
Date Posted: September-01-2005 at 7:07am

Hi,

since I didn't found a proper tool in the internet I created an Excel worksheet to let the computer calculate the take-off and landing performance for the ATR 72-500.  The data is taken from the Flight1 ATR 72-500 Orientation Manual and the calculations follow the instructions given there.You can download the file via

http://people.freenet.de/thilo.arndt/20050901_F1_ATR72-500_Performance_Calculation.zip - http://people.freenet.de/thilo.arndt/20050901_F1_ATR72-500_P erformance_Calculation.zip

Many calculations are implemented in Excel VB. So if you want to use this sheet you have to enable macros.

The file is not protected. Feel free to use it as needed. You can even implement your own calculations. My intention is to use it the file as a starting point for discussions about how to do all these calculations and whether all this can be automated.

rgds

lilo




Replies:
Posted By: buffi
Date Posted: September-01-2005 at 11:42am

Hi Lilo!

Thank you very much for this impressing calculation sheet. It looks very professional. But (nothing without a but..) when I tried to use it, I noticed that it needs °F and lbs. For me it is very difficult to use Fahrenheit, I have to convert it first. Therefore: could you be so kind and add an °C and kg version???



-------------
best regards,
buffi (EDDH)

...excuse my english - feel free to ask what I would like to say...


Posted By: lilo
Date Posted: September-01-2005 at 4:41pm

buffi,

let me think a bout it. This is probably what most of European flight sim enthusiasts would like to have. Hm, should have been aware of this prior of mixing all the units. Requires some clean up and more  generic functions...

In the mean time and as a work around you can convert directly within the worksheet. You don't have to do this by hand. If you want to convert ° C to ° F just type in:

   =ToFahrenheit(TempC)

where TempC is the temperature in ° C. To convert kg into lb you can type in:

   =WeightKg * KG2LB

where WeightKg is the weight in kg. The constant KG2LB is an alias for a cell in the sheet "Conversion" which is one of the last sheets in this file. If you have the Excel Analytics module installed which is not the default you can also use the special conversion function "CONVERT" ("UMWANDELN" in German Excel).

rgds

lilo



Posted By: buffi
Date Posted: September-02-2005 at 3:50am

Hi Lilo!

You are a master of Excel! Thank you for this recommendations. I`ll try to do that. Hope that I`m able to manage it...

Thanks again!



-------------
best regards,
buffi (EDDH)

...excuse my english - feel free to ask what I would like to say...


Posted By: musicpete
Date Posted: September-02-2005 at 5:15am
Amazing!

In a single-handed blow you made my efforts to create a TALD-Calculator useless. I am impressed! This is 100 times better than what I would have been able to come up with.

Did you have time to implement the complete obstacle computation, yet?

And if you also decide to include the T/O and Landing Torque calculation, this thing will be perfect. I know: You said "When landing I am not interested in the torque at all, since I use the EEC/PEC". But the torque becomes very interesting in case you need to do a takeoff in hot+high conditions or need to do a go around. In that case you will shred your engines quite quickly. Try explaining that to the insurance agent: "Listen up, mate. I am sorry, but torques really don't interest me...".


Great Job! I will use this instead of my paper version from now on...

p.s.: I also would kindly ask you to include a easier converter or clean it up a bit, so that the units are no longer mixed. Lot's of work, I know...

p.p.s.: Maybe I found a little bug? I tried entering values that would make me NOT exceed the MTOW (ZFW=42184lb, Fuel 4000lb, Zp=450ft, LC3=9599ft). Then I selected "Runway Condition = 6 - compact snow". the TOW-Limit immediately jumped to "EXCEEDED", which is good. But when I changed the runway condition, the TOW remained exceeded, which can not be correct. Am I doing something wrong?

p.p.p.s: A little feature request... The spreadsheet prints out the value "Airport pressure altitude", but that is misnamed. I only gives you the value to add/substract from the real altitude. Would it be possible to also print out the actual Zp?

-------------
Greetings!

Peter


Posted By: buffi
Date Posted: September-02-2005 at 5:50am

Hi Lilo!

I didn`t manage it. I have never been working with Excel at such a high level. So I don`t know, where to fill in the =lines...

First I would like to convert the sheet, that it will take °C instead of °F and kg`s instead of lbs. And then the results should be also in kg`s instead of lbs.

Be so kind and explain for dummies...



-------------
best regards,
buffi (EDDH)

...excuse my english - feel free to ask what I would like to say...


Posted By: lilo
Date Posted: September-02-2005 at 7:03am

buffi,

let's do this by example. At the Take-Off Performance sheet there is the input field for OAT which is cell D8. If the field would accept ° C you would simply type in

Outside Air Temperature (OAT): 25

Actually, it doesn't. So you have to apply my workaround and enter

Outside Air Temperature (OAT): =ToFahrenheit(25)

You finish th input of the formula by pressing [ENTER]. You can also select the cell and then enter the formula "=ToFahrenheit(25)" into the formula input field fx right above the sheet.

Now enter the ZFW in cell D3. To convert 21,5 t into lb type in:

Zero Fuel Weight (ZFW): =21500*KG2LB

and finish the input by pressing [ENTER]. Do it in the same way in cell D4 for entering the fuel weight of 1500 kg:

Fuel: =1500*KG2LB

and press [ENTER]. That's it. If you still have problems send me a PM and I will send you a file containing sample values.

Good news: You don't have to wait for long. I already started to implement user defined units of measure. Once I'm finished I will publish a new URL. I can't promise anything but I think I'm finished until end of this week.

rgds

lilo



Posted By: lilo
Date Posted: September-02-2005 at 8:31am

musicpete,

thank's for th flowers. But don't you think that your work is useless now. An executable can still be the better alternative for other sim pilots.

Obstacles: I implemented climb limitation (C) induced by close and remote obstacles. I simplified the data because I didn' saw much difference between the diagrams for normal and icing conditions. Compared with the error when doing it on the paper the max. calculation error can be neglected.

Torque: At the moment there are other things which are more important. But it should not be too difficult. I will keep it in mind. Besides, I remember having read about special versions which are available for operation under hot and high conditions. Is the simulated ATR 72 also prepared for this? Just wondering

TOW Limit:  Let me check this.

ZP: I will do that for you.

rgds

lilo



Posted By: buffi
Date Posted: September-02-2005 at 9:48am

Hi Lilo,

I´m in a hurry now. Only looked for an answer... Will try that later when I´m back.

Thank you for your help. And knowing that you work on it by yourself relieves me...



-------------
best regards,
buffi (EDDH)

...excuse my english - feel free to ask what I would like to say...


Posted By: buffi
Date Posted: September-03-2005 at 10:47am

Hi Lilo,

Thank you again for your explanations. Now I managed to get it working. Nevertheless my hope is that you will make a "european" version for us... Would be very nice!



-------------
best regards,
buffi (EDDH)

...excuse my english - feel free to ask what I would like to say...


Posted By: lilo
Date Posted: September-04-2005 at 2:51pm

Hi,

version 1.1 is available. Donwload the file via

http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performance_Calculation_v1.1.zip - http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performanc e_Calculation_v1.1.zip http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performance_Calculation_v1.1.zip - http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performance_Calculation_v1.1.zip -

New functionality:

  • user defined units of measure: The units of measure can now be changed by clicking on the button "Preset Metric" or "Preset Imperial". You can also change the unit for individual measures by selecting the units from the dropdown listboxes. I recommend to change the units according to your preferences the first time you open the file. After that select the "Take-Off Performance" or "Landing Performance" sheet" and save the file under a new name. Make this new file read only and use it from now on.
  • Check of ZFW: MZFW was already on the "Limitations" sheet. So that was easy.
  • Check of max. obstacle height: A warning "Too high!" will appear right beside the input fields if the obstacle height exceeds the maximum allowed obstacle height for the given distance.


Bug fixes and changes:

  • Pressure altitude: The meaning of the term "pressure altitude" has been clarified and a proper formula was implemented. The change of the altitude and the airport pressure altitude are now displayed in separate fields.
  • Take-off weight according to LC3: The calculation resulted in 0 if snow or ice was selected and the temperature was above 5 ° C. The code now catches this inconsistency by setting the temperature to 5 ° C for further calculation.

rgds

lilo



Posted By: buffi
Date Posted: September-04-2005 at 3:47pm

Hi Lilo!

I just saw that you have been working hard. Thank you very much!



-------------
best regards,
buffi (EDDH)

...excuse my english - feel free to ask what I would like to say...


Posted By: musicpete
Date Posted: September-06-2005 at 6:28am
Amazing.... absolutely A-MA-ZING!! Thile, you are the genius of Excel! I tried it, and this thing is brilliant!

I found some more little bugs:

1) When I select a "Runway Status", which results in limiting conditions, or weather data which results in icing conditions: This won't change back to normal/NL once you select different values. Don't know why.

Could this maybe be solved by creating a "Force calculation now (Use this button if the excel-sheet refuses to accept changes which would lead to different results)"-button?

I also did NOT find this strange "problem" in the landing calculation.

2) Remote Obstacle Distance (using metric units): Doesn't accept the value "0". There is an error message "The entered value is invalid. An other user limited the value that can be entered into this cell." ("Der eingegebene Wert ist ungültig. Ein anderer hat die Werte begrenzt, die in diese Zelle eingegeben werden können"). It only accepts values bigger than "1".

3) Not a bug: You put very handy links on each page, to make navigation really easy. But I miss a button/link on the first page, which will lead you to the units-of-measure-setup or directely to the calculations. Personally I would like to have 3 links:

* Set up units of measure (+Print out the actual setting)
* Go directely to Takeoff calculation without setting up units of measure
* Go directely to Landing calculation without setting up units of measure

Thank you for your hard work! What you achieved, is absolutely amazing!

-------------
Greetings!

Peter


Posted By: lilo
Date Posted: September-06-2005 at 6:54am

musicpete,

thank you for your feedback.

1) When I select...

Hm, this should not occur any longer. Can you try to reproduce it, save the file and send it to me? Thanks in advance. In the mean time I will have a look at the code.

2) Remote Obstacle...

This is a restriction I configured. A admit the message generated by Excel is strange and too generic. I wanted to make sure that the close obstacle fields are used for distances between 0 and 1000 m and the remote obstacle fields for distances between 1 and 10 km. Now I see that this doesn't work for ft/nm. I better remove these restrictions...

3)Not a bug...

Yea, that will be easy

Let me know If you were able to reproduce this or not so that I can work on the first problem.

rgds

lilo



Posted By: lilo
Date Posted: September-06-2005 at 5:15pm

Hi,

the latest version is available and can be downloaded via

http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performance_Calculation_v1.2.zip - http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performanc e_Calculation_v1.2.zip

New functionality:

  • Qick links were placedon the first sheet to make navigation more intuitive.


Bug fixes and changes:

  • The validations at the input fields for obstacle distances were removed. The popup notes describe what should be entered into which field.
  • The calculation of the obstacle decrement has been fixed. The unit-of-measure-redesign caused the calculation to return wrong values. If the distance for a close obstacle is specified greater than 1 km the calculation now internally treats it as remote obstacle (and vice versa).

rgds

lilo



Posted By: buffi
Date Posted: September-07-2005 at 12:05am

Hi Lilo!

I myself made a few Excel calculations and of some of them I am still a little bit proud. But if I compare them with your worksheet this one is really out of another world. I tried to understand how it is made. Where are the formula? Which kind of technique did you use to get them work so perfectly? I think it is necessary to have a look in some bigger Excel books to uncover this secret. I`ll do that.

Again thank you very much for this masterpiece! 



-------------
best regards,
buffi (EDDH)

...excuse my english - feel free to ask what I would like to say...


Posted By: lilo
Date Posted: September-07-2005 at 7:41am

buffi,

that's all no mystery. As you have noticed there are almost no formulas of the type

=D4 + 1,34 * E17

in the cells. And there is a good reason for this: It is by far too complex to express the calculations of all the parameters in ordinary formulas. There are too many conditions to be checked and data tables to be searched for values. So I created Excel Visual Basic (VB) functions which I then call from within a cell by putting statements like

=GetObstacleDec(...

into the cell. The function "GetObstacleDec", like all the other functions I created, can be accessed by starting the Visual Basic Editor (press [Alt] + [F11]) and opening the module modMain. In fact, I strongly encourage everyone to do this. VB is not that difficult that it would be totally impossible for a novice to read the code. As already pointed out my intention was and is to provide a basis for productive discussions about the correct calculation of all these parameters.

My basic idea was to keep everything as simple as possible without loosing flexibility. So I created a new Excel file and typed in all the data tables as published in the F1 ATR 72-500 Orientation Manual. The method of going through all these tables and diagrams step by step is implemented mainly in the VB code. Especially the search for a certain value in a data table has been kept highly generic. The function "GetValFromIsoLine(...)" - which I regard as the heart of the whole thing - allows search for values in any table whatever data it contains. In addition, interpolated values can be calculated for input which doesn't exactly match a value in the data table (for example: find VMCA for pressure altitude = 354 ft, temperature = 27 ° C). The mathematics behind this has something to do with planes and lines in the three dimensional space. When it comes to take-off data (weight, V1, V2) we have to deal with four dimensions which makes it even more complicated because the data is spread over multiple sheets. Well, one could regard the "NORMAL"/"ICING" condition as a fifth dimension . But that's theorizing...

rgds
lilo



Posted By: buffi
Date Posted: September-07-2005 at 3:49pm

Hi Lilo!

That is very kind of you to explain how you made this calculation and I think that I understood the basics of your explanations. Now and during the next weeks I`ll try to go deeper in order to learn this technique. I`ll take your calculation as the ideal example. So, let`s see...

Thanks again for your input!

 



-------------
best regards,
buffi (EDDH)

...excuse my english - feel free to ask what I would like to say...


Posted By: chuckb
Date Posted: September-08-2005 at 10:04pm

lilo,

Thank you for the excellent performance calculation sheet, it works great!



-------------
Chuck Blake


Posted By: musicpete
Date Posted: September-09-2005 at 7:05am
Hi Lilo!

I tried the newest version, and it works perfectely! Was not able to find a single bug, yet.

I will write more, when I will have more time.

-------------
Greetings!

Peter


Posted By: lefreak
Date Posted: September-10-2005 at 6:29am

this is awesome ..

just one minor remark .. when using metric settings, speed should still be expressed in knots .. airport altitude should be expressed in ft ..

basicaly, in europe elevation and altitudes are expressed in feet, speeds in knots and all the rest in standard metric system

 

otherwise:



Posted By: lilo
Date Posted: September-10-2005 at 2:46pm

lefreak,

thank you for that peace of information. I will implement this in version 1.3.

 

Kind regards

lilo



Posted By: musicpete
Date Posted: September-13-2005 at 5:22am
Yes, in Europe we use that mixed units convention.

Length: m
height: ft
Temperature: °C
Pressure: hPa
Speed: knots

But remember: In China and Russia (and surely a whole host of other countries) the use a totally metric system (which of course is the only correct way to go - in therory - since the question always is: Why do we have a SI of units, when hal the world does not use it...)!

-------------
Greetings!

Peter


Posted By: lilo
Date Posted: September-17-2005 at 2:37pm

Dear all,

version 1.3 is available and can be downloaded via

http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performance_Calculation_v1.3.zip - http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performanc e_Calculation_v1.3.zip

New functionality:

  • Torque limits are now provided for take-off, reserve take-off, max. climb, max. cruise and go-around
  • Two new sheets are added to monitor climb and cruise performance in flight. Actually, only torque is provided there.
  • User interface looks better now (at least I think so)


Bug fixes and changes:

  • Validation of input arguments has been improved to avoid overflow error messages
  • Unit for altitude can now be specified independently from units for horizontal distances
  • Obstacle decrement calculation has been completely revised. The method used before calculated wrong weights for input values not being grid points. New data sheets are provided as well.

 

Well, I wanted to implement service ceiling calculation in this version. But I had to learn that more information is required (mostly weather data) in order to calculate this. Since I want to make things easier I leave it out until I have a great idea how to deal with it.

 

rgds

lilo



Posted By: fredo
Date Posted: November-05-2005 at 12:32am

Hi lilo

Could you please explain me what is understand by the following:

  • Near End Elevation
  • Far End Elevation
  • Close Obstacle Height
  • Distance
  • Remote Obstacle Height
  • Distance

Thank you

Fredo



-------------
Frédéric Gentil

http://www.fsenthusiasm.x3fusion.com/F1ATR - All my F1 ATR Repaint



Posted By: Graeme
Date Posted: November-05-2005 at 1:41am

Nice piece or work adn thankyou. It will be well used in this ATR household

Graeme NZ



Posted By: lilo
Date Posted: November-05-2005 at 6:43pm

fredo,

Near end elevation is the elevation of the close end of the runway. This is the end where you will start you take off. The far end elevation is the elevation of the runway's opposite end. Both values are used to calculate the runway slope. If you don't have charts for the airport/runway you can leave both fields empty. The runway slope then defaults to 0 %.

Close obstacle height is the height of a significant object located between 0 and 1000 m behind the runway end. The height is the vertical distance between the elevation of the runway and the elevation of the object's highest point. The input field "Distance" right below the close obstacle height input field is the corresponding distance in m/ft, depending on the unit of measure you defined for short distances. Just enter a height and a distance here. If the height you entered is too low to be significant the sheet will tell you that. On the other hand, if it is too high so that the aircraft cannot overfly the obstacle, the sheet will tell you that too. It's the same for a remote obstacle located between 1 and 10 km behind the runway. Again, if you don't have airport charts where you can read the obstacle information from just leave those fields empty.

rgds

lilo



Posted By: fredo
Date Posted: November-05-2005 at 11:18pm

Hi lilo

Thank you very much

rgds

Fredo



-------------
Frédéric Gentil

http://www.fsenthusiasm.x3fusion.com/F1ATR - All my F1 ATR Repaint



Posted By: Graeme
Date Posted: November-06-2005 at 1:21am

Hi Lilo,

I can only get a V2 reading when the runway is limiting.

My local QNH is 1018 and I have entered that in the format 1,018.00 and I keep getting a TOW Limit EXCEEDED.

Can you assist with these two queries please?

tks

Graeme 

 



Posted By: lilo
Date Posted: November-06-2005 at 4:29pm

Hm, I'm not sure. From the QNH alone I'm not able to reproduce this. Can you be so kind please, enter the values you have problems with, save the file (optionally zip it) and send it to me via email? Then I will have a look at it. My email address is on the info sheet.

kind regards

lilo



Posted By: Graeme
Date Posted: November-06-2005 at 5:51pm

lilo,

Spreadsheet sample on its way to your email address.

tks

Graeme



Posted By: lilo
Date Posted: November-09-2005 at 5:23am

Dear all,

version 1.4 is available for download via

http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performance_Calculation.zip - http://people.freenet.de/thilo.arndt/F1_ATR72-500_Performanc e_Calculation.zip

Bug fixes and changes:

  • calculation of weight from WAT changed to map pressure altitude values less than zero to zero and map temperature values less than zero to zero under normal conditions
  • calculation of V1/V2 changed to map pressure altitude values less than zero to zero
  • weight decrement warning removed for obstacle height and/or distance <= 0

I changed the file name of the package so it doesn't contain the version number any longer. This way users will always download the latest version when using the above URL.

Let me know if something doesn't work the way you think it should.

 

Kind regards

lilo



Posted By: lilo
Date Posted: May-14-2006 at 5:26pm

Dear all,

I changed my ISP. So my homepage moved. The new URL for downloading the worksheet is:

http://thilo-arndt.homepage.t-online.de/F1/F1_ATR72-500_Performance_Calculation.zip - http://thilo-arndt.homepage.t-online.de/F1/F1_ATR72-500_Perf ormance_Calculation.zip

rgds

lilo



Posted By: Flyingkiki
Date Posted: January-19-2007 at 8:01am
I've tried it, but I've some troubles to use it. I put values, and there is some letters in the results box. Is it because I've an old version of Excel ?
And too ( old version too ? ), an error occured every time I open the file ; compilation error Ouch

Whatever, I would like, like the others, thank you for your intuitive and easy-to-use file !
It's a great help to have it !


Posted By: musicpete
Date Posted: July-29-2007 at 9:48am
Try changing your regional settings either in Control panel or Excel: This error happens when the spreadsheet expects a decimal sign of "." or "," but in the settings it is set to something else.

-------------
Greetings!

Peter


Posted By: denisjola
Date Posted: March-15-2008 at 5:18pm

the site is in german...oops... is the file still available

thanking you in anticipation for your comprehension

denis



-------------
Ashley


Posted By: Shazin
Date Posted: July-19-2019 at 1:42am
Dear Lilo,

Very impressed with the comments in this discussion forum. Would like to explore your excel file with all the performance calculation for TO & LND.

I am unable to download the file from all the given links. If it's not a matter of botheration, could you please send me the file via email (shazinchachi7@gmail.com) or WhatsApp(+919633781124).

Thank you,
Mohammed Shazin Shoukath
Flight Operations Engineer



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.10 - http://www.webwizforums.com
Copyright ©2001-2017 Web Wiz Ltd. - https://www.webwiz.net