Source document: https://docs-lawep.s3.us-east-2.amazonaws.com/1697630937694.pdf (Australia)
Senate Committee -­‐ Aviation Accident Investigations (Pel-­‐Air) Submission by Richard James Davies Annex E -­‐ 0904 NWWW.xlsx Copyright Richard James Davies, 2012.
All rights reserved Not to be used without permission of Richard Davies Note: No Performance Correction Factors used from published figures User Entered From Planning Manual Depart Destination Route Distance ZFW Fuel Load TOTAL Ramp Weight Fuel Used INITIAL SEGMENT Distance Flight Fuel Initial Climb Cruise MID SEGMENT 1 Distance Flight Fuel Altitude Change Cruise MID SEGMENT 2 Distance Flight Fuel Altitude Change Page 1 of 2 GNM lbs Litres Fuel SG lbs lbs Start Taxi Takeoff To Position GNM Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Mach EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise To Position GNM Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Mach EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise To Position GNM Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used NSFA NWWW 1596 14606 4164 0.78 7160 21766 0 0 0 KILAN 292 21766 0 39000 +10 -­‐20 36 1200 208 196 96 -­‐20 +10 0.72 20382 1612 417 15 390 APASI 209 20018 39000 39000 +10 -­‐35 0 0 0 0 209 -­‐35 +10 0.72 19600 1462 417 33 800 DOLSI 513 19138 39000 39000 +10 -­‐75 0 0 = US Gallons 1100 To start of next Altitude Change Cruise MZW Check TOPC End Cruise MZW Error 20446 20018 20232 -­‐150 Time Interval Elapsed Time Fuel Remaining at KILAN 51 51 5412 minutes minutes if VFR used To start of next Altitude Change Cruise MZW Check End Alt.
Change End Cruise MZW Error 20018 19138 19578 -­‐22 Time Interval Elapsed Time Fuel Remaining at APASI 33 83 4532 minutes minutes if VFR used To start of next Altitude Change Senate Committee -­‐ Aviation Accident Investigations (Pel-­‐Air) Submission by Richard James Davies Annex E -­‐ 0904 NWWW.xlsx Cruise Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Mach EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise 0 0 513 -­‐75 +10 0.72 17978 1364 417 90 2045 Cruise MZW Check End Alt.
Change End Cruise MZW Error 19138 16888 18013 36 Time Interval Elapsed Time Fuel Remaining at DOLSI 90 173 2282 minutes minutes if VFR used MID SEGMENT 3 Distance Flight Fuel Altitude Change Cruise FINAL SEGMENT Distance Flight Fuel Altitude Change Cruise Descent to Destination Fuel Used ARRIVAL FUEL To Position GNM 0904 UTC 146 To start of next Altitude Change Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Mach EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise 16888 39000 39000 +10 -­‐65 0 0 0 0 146 -­‐65 +10 0.72 16568 1326 417 25 550 To Position GNM NWWW 436 Start Weight Start Alt Finish Alt Temp Variation Wind Component Time Fuel Used Distance (ANM) GNM Distance Wind Component Temp Variation Cruise Type EMZW Fuel Flow TAS Time in Cruise Fuel in Cruise Start Alt Finish Alt Wind Component Time Fuel Used Distance (ANM) GNM Approach Landing 16283 39000 39000 +10 -­‐20 0 0 0 0 356 -­‐20 +10 0.72 15600 1251 417 54 1123 39000 0 -­‐20 16 158 85 80 0 0 269 Cruise MZW Check End Alt.
Change End Cruise MZW Error 16888 16283 16586 17 Time Interval Elapsed Time Fuel Remaining at 0904 UTC 25 198 1677 minutes minutes if VFR used Cruise MZW Check End Alt.

Change End Cruise MZW Error 16283 15049 15666 66 Time Interval Elapsed Time Fuel Remaining at NWWW 70 268 269 minutes minutes if VFR used NOTES EMZW checks use average TAS 380 & 23 lb per minute TAS = 38.975 X Mach Number X Square Root of Absolute Temperature (Where Absolute Temperature °K = SAT °C + 273.15) Page 2 of 2