Post by TheFinn on Mar 26th, 2014 at 12:33pm
Hi everyone! 8-)
I'm working on a excel-based flight- & fuelplanner, based on the calculations from AlOl I've found in this thread:
http://captainsim.org/yabb2/YaBB.pl?num=1282910111
You just enter;
-zero fuel weight
-estimated time of departure
-planned cruise speed (dropdown-list) and level
-distance to destination
-distance to alternate
-departure and destination airport elevation
-average rate of climb below and above 10'000ft
-average rate of descent below and above 10'000ft
-estimated ground speed while climbing above 10'000ft
-estimated ground speed while descending above 10'000ft
-estimated fuel flow at selected M (cruise speed)
-estimated time and fuel flow for a holding
-estimated taxi-out and taxi-in fuel
and it calculates;
-wake turbulence category
-endurance
-enroute time to destination (taking into account climb and descent)
-calculated fuel needed to destination (incl. taxi out/in fuel)
-calculated time of arrival at destination (taking into account climb and descent)
-calculated enroute time to alternate (taking into account climb and descent, beginning at destination)
-calculated fuel needed to alternate (excl. taxi in/out fuel)
-calculated reserve fuel (45min + holding + 10% additional)
-calculated total fuel
-calculated gross weight
-fuel distribution for each tank in weight and percent
-when the calculated fuel exceeds max. loadable fuel, all calculated fuel and time values will blank out and a big red "out of range" pop's up below the total fuel field
-when the calculated gross weight exceeds max. takeoff weight, a big red "overweight" pop's up below the GW's field and the number turns red
Havn't testet it yet, but I'm confident that the calculations will be very close to the actual values while flying in FSX. Also I'm planning to add a dropdown-list for the additional reserve to be choosen from, and maybe add a field for an average enroute-wind.
What do you think? :D
Greetings TheFinn
I'm working on a excel-based flight- & fuelplanner, based on the calculations from AlOl I've found in this thread:
http://captainsim.org/yabb2/YaBB.pl?num=1282910111
You just enter;
-zero fuel weight
-estimated time of departure
-planned cruise speed (dropdown-list) and level
-distance to destination
-distance to alternate
-departure and destination airport elevation
-average rate of climb below and above 10'000ft
-average rate of descent below and above 10'000ft
-estimated ground speed while climbing above 10'000ft
-estimated ground speed while descending above 10'000ft
-estimated fuel flow at selected M (cruise speed)
-estimated time and fuel flow for a holding
-estimated taxi-out and taxi-in fuel
and it calculates;
-wake turbulence category
-endurance
-enroute time to destination (taking into account climb and descent)
-calculated fuel needed to destination (incl. taxi out/in fuel)
-calculated time of arrival at destination (taking into account climb and descent)
-calculated enroute time to alternate (taking into account climb and descent, beginning at destination)
-calculated fuel needed to alternate (excl. taxi in/out fuel)
-calculated reserve fuel (45min + holding + 10% additional)
-calculated total fuel
-calculated gross weight
-fuel distribution for each tank in weight and percent
-when the calculated fuel exceeds max. loadable fuel, all calculated fuel and time values will blank out and a big red "out of range" pop's up below the total fuel field
-when the calculated gross weight exceeds max. takeoff weight, a big red "overweight" pop's up below the GW's field and the number turns red
Havn't testet it yet, but I'm confident that the calculations will be very close to the actual values while flying in FSX. Also I'm planning to add a dropdown-list for the additional reserve to be choosen from, and maybe add a field for an average enroute-wind.
What do you think? :D
Greetings TheFinn