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

http://i221.photobucket.com/albums/dd264/TheFinn88/Flight%20Simulator%20X/flightplan.jpg

http://i221.photobucket.com/albums/dd264/TheFinn88/Flight%20Simulator%20X/Fuelplanner.jpg

http://i221.photobucket.com/albums/dd264/TheFinn88/Flight%20Simulator%20X/fuelflowtable.jpg

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

This looks like a very nice tool to enhance the 707 sim.

I think the only parameters that would alter results are if we use different weather add ons that produce wind variables at climb/cruise/descent. ( and then really only over long distances)

Of course with modern FMC's we can enter these variables and see the resultant fuel calculations (assuming the FMC logic works!) With the 707 its all down to tables and maths!

Anyway, it beats having to use the fuel dump when you realise your going to be overweight on landing! ;D

Will the tool require MS Excel or will it run as a stand alone tool?

Best Regards
David

Is there a link to the file in that Topic, because I couldn't find it. Or. Did you create the Excel file using the instruction in that Topic?

I am not very good at Excel. I bought a book on how and what to do stuff in Excel, but I haven't read it yet. :o :(

highflight wrote on Mar 26^th, 2014 at 3:44pm:

I think the only parameters that would alter results are if we use different weather add ons that produce wind variables at climb/cruise/descent. ( and then really only over long distances)

Thats why I want to include additional field for an average head- or tail-wind component, and maybe in a second stage a calculation that calculates the wind component after typing in the speed and direction. But that would require all the planned tracks of the route.


highflight wrote on Mar 26^th, 2014 at 3:44pm:

Will the tool require MS Excel or will it run as a stand alone tool?

Actual stage it needs Excel. But when I find a way to create a standalone-tool, I would defenetly create such when I've got a final version in Excel.


Markoz wrote on Mar 27^th, 2014 at 3:09am:

Is there a link to the file in that Topic, because I couldn't find it. Or. Did you create the Excel file using the instruction in that Topic? I am not very good at Excel. I bought a book on how and what to do stuff in Excel, but I haven't read it yet.

The Excel is still WIP, and not available yet. But I'm going to share the final version of it. And if it stays as an excel-version, its going to be VERY simple to use. Just enter the values into the fields, and everything else is calculated in realtime.

Was this tool ever released?

Good question..Anyone?? Mark??