Hello,
I have a predicament regarding a table that I'm trying to solve.
There is a table with Weights along the left side, ISA Temperature Deviation along the top, and Anti-Ice correction along the bottom.
For a given weight, ISA Dev, and whether or not the Anti-ice system is on, an airplane can reach a certain max altitude, which this table will show you. Using a combination of VLookup, HLookup, and Match functions, I have already put together a formula to compute the max altitude for a given weight, ISA deviation, and Anti-ice status.
The Anti-ice system takes its power from the engines, so if the Anti-ice system is on, the aircraft cannot fly as high, hence the negative corrections if the system is on.
Now, the problem. There are some situations where a pilot may want to know, for a given ISA dev and Anti-ice status, the highest weight the aircraft can be at in order to reach a specified altitude. If the aircraft is too heavy at a given time, as the fuel is burned, the aircraft may get down to the required weight, at which point the aircraft can climb to the requested altitude.
Essentially, the 4 variables are Weight, ISA Dev, Altitude, and whether or not the Anti-Ice system is on. I need a way to "read" the table when the known values are ISA Dev, Altitude, and Anti-ice status on/off. The flow of the formula should go something like this:
If the Anti-ice system is not on:
1) Based on user input, ISA Dev, go to the column for the current ISA Dev.
2) Based on user input, Desired Altitude, go down that column to find the bottom-most instance of that altitude.
3) Move left to find the weight. This will represent the heaviest the aircraft can be an still reach and maintain that altitude.
I have attached the chart. The cell containing Max Altitude is A1. I have the fields for user input at the top of the chart for simplicity. The formula should be in G2.
For example, if the Anti-ice system is not on:
ISA Dev: -5
Anti-ice on?: No
Desired Altitude: 36000ft
Result should be: 51000Kg
If the Anti-ice system is on, this requires some extra work:
1) Take the given requested altitude and add the correction value at the bottom of the chart. In the example, 36000 + 5000 = 41000Kg
2) Repeat steps 1-3 above, essentially replacing 36000, with 41000 (since you have to subtract the 5000ft correction from 41000ft, in order to maintain the requested 36000ft).
In the above example, if the Anti-ice system is on, the result should be 39000Kg.
The main thing to keep in mind is that the service ceiling is 41000ft, so no matter what, the assumed altitude cannot go past 41000. If a pilot is requesting an altitude that cannot be reached at any weight, the result should produce an "Unable" response.
Thanks in advance for any assistance. I know this one is rather complicated. It's been stumping me for a while.
[TABLE="width: 576"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Max Altitude[/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"]ISA Dev[/TD]
[TD="class: xl66, width: 64"]Req Alt[/TD]
[TD="class: xl66, width: 64"]Anti-ice
on?[/TD]
[TD="class: xl66, width: 64"]Weight[/TD]
[TD="class: xl66, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl67"]WEIGHT[/TD]
[TD="class: xl65"]ISA DEVIATION (C)[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"]5[/TD]
[TD="class: xl66"]38000[/TD]
[TD="class: xl66"]NO[/TD]
[TD="class: xl66"]RESULT
HERE[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl67"][/TD]
[TD="class: xl65, align: right"]-15[/TD]
[TD="class: xl65, align: right"]-10[/TD]
[TD="class: xl65, align: right"]-5[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl65, align: right"]10[/TD]
[TD="class: xl65, align: right"]15[/TD]
[TD="class: xl65, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]30000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]31000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]32000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]33000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]34000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]35000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]36000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]37000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]38000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]39000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]40000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]41000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]42000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]43000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]44000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]45000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]46000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]47000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]48000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]33000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]49000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]33000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]50000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]32000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]51000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]31000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]51800[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]31000[/TD]
[/TR]
[TR]
[TD="class: xl65"]Correction
ENG & WNG
ANTI-ICE ON[/TD]
[TD="class: xl68, align: right"]0[/TD]
[TD="class: xl68, align: right"]-3000[/TD]
[TD="class: xl68, align: right"]-5000[/TD]
[TD="class: xl68, align: right"]-5000[/TD]
[TD="class: xl68, align: right"]-5000[/TD]
[TD="class: xl68, align: right"]-5000[/TD]
[TD="class: xl68, align: right"]-8000[/TD]
[TD="class: xl68, align: right"]-10000[/TD]
[/TR]
</tbody>[/TABLE]
I have a predicament regarding a table that I'm trying to solve.
There is a table with Weights along the left side, ISA Temperature Deviation along the top, and Anti-Ice correction along the bottom.
For a given weight, ISA Dev, and whether or not the Anti-ice system is on, an airplane can reach a certain max altitude, which this table will show you. Using a combination of VLookup, HLookup, and Match functions, I have already put together a formula to compute the max altitude for a given weight, ISA deviation, and Anti-ice status.
The Anti-ice system takes its power from the engines, so if the Anti-ice system is on, the aircraft cannot fly as high, hence the negative corrections if the system is on.
Now, the problem. There are some situations where a pilot may want to know, for a given ISA dev and Anti-ice status, the highest weight the aircraft can be at in order to reach a specified altitude. If the aircraft is too heavy at a given time, as the fuel is burned, the aircraft may get down to the required weight, at which point the aircraft can climb to the requested altitude.
Essentially, the 4 variables are Weight, ISA Dev, Altitude, and whether or not the Anti-Ice system is on. I need a way to "read" the table when the known values are ISA Dev, Altitude, and Anti-ice status on/off. The flow of the formula should go something like this:
If the Anti-ice system is not on:
1) Based on user input, ISA Dev, go to the column for the current ISA Dev.
2) Based on user input, Desired Altitude, go down that column to find the bottom-most instance of that altitude.
3) Move left to find the weight. This will represent the heaviest the aircraft can be an still reach and maintain that altitude.
I have attached the chart. The cell containing Max Altitude is A1. I have the fields for user input at the top of the chart for simplicity. The formula should be in G2.
For example, if the Anti-ice system is not on:
ISA Dev: -5
Anti-ice on?: No
Desired Altitude: 36000ft
Result should be: 51000Kg
If the Anti-ice system is on, this requires some extra work:
1) Take the given requested altitude and add the correction value at the bottom of the chart. In the example, 36000 + 5000 = 41000Kg
2) Repeat steps 1-3 above, essentially replacing 36000, with 41000 (since you have to subtract the 5000ft correction from 41000ft, in order to maintain the requested 36000ft).
In the above example, if the Anti-ice system is on, the result should be 39000Kg.
The main thing to keep in mind is that the service ceiling is 41000ft, so no matter what, the assumed altitude cannot go past 41000. If a pilot is requesting an altitude that cannot be reached at any weight, the result should produce an "Unable" response.
Thanks in advance for any assistance. I know this one is rather complicated. It's been stumping me for a while.
[TABLE="width: 576"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Max Altitude[/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"]ISA Dev[/TD]
[TD="class: xl66, width: 64"]Req Alt[/TD]
[TD="class: xl66, width: 64"]Anti-ice
on?[/TD]
[TD="class: xl66, width: 64"]Weight[/TD]
[TD="class: xl66, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl67"]WEIGHT[/TD]
[TD="class: xl65"]ISA DEVIATION (C)[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"]5[/TD]
[TD="class: xl66"]38000[/TD]
[TD="class: xl66"]NO[/TD]
[TD="class: xl66"]RESULT
HERE[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl67"][/TD]
[TD="class: xl65, align: right"]-15[/TD]
[TD="class: xl65, align: right"]-10[/TD]
[TD="class: xl65, align: right"]-5[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl65, align: right"]10[/TD]
[TD="class: xl65, align: right"]15[/TD]
[TD="class: xl65, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]30000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]31000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]32000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]33000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]34000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]35000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]36000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]37000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]38000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]39000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]41000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]40000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]41000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]40000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]42000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]43000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]39000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]44000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]45000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]38000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]46000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]47000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]48000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]37000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]33000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]49000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]33000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]50000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]32000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]51000[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]36000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]31000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]51800[/TD]
[TD="class: xl68, align: right"]29000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]35000[/TD]
[TD="class: xl68, align: right"]34000[/TD]
[TD="class: xl68, align: right"]31000[/TD]
[/TR]
[TR]
[TD="class: xl65"]Correction
ENG & WNG
ANTI-ICE ON[/TD]
[TD="class: xl68, align: right"]0[/TD]
[TD="class: xl68, align: right"]-3000[/TD]
[TD="class: xl68, align: right"]-5000[/TD]
[TD="class: xl68, align: right"]-5000[/TD]
[TD="class: xl68, align: right"]-5000[/TD]
[TD="class: xl68, align: right"]-5000[/TD]
[TD="class: xl68, align: right"]-8000[/TD]
[TD="class: xl68, align: right"]-10000[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: