RockOla

Turbine Duke fuel planning "tool"

Recommended Posts

This is a little thing I have been working on lately.

 

I fly a lot (if not only) the RealAir Turbine Duke.  B)

 

The only thing that I was lacking was a convenient and simple tool for fuel planning.

 

So I decided to create a Google Spreadsheet.

 

It began simple and, as often in my case, turned pretty intricate.

 

There are several limits (see below) : keep in mind this is more a kind of "proof of concept" than an operational fuel calculation. 

 But it does its bit. And with the help of the simmers communauty, it could be much more powerful.

 

 

What you have to do

 

- insert your flightplan in the first sheet

04%20FP%20INSERTION.jpg

 

- fill-in some data in the second sheet (departure altitude, cruise level etc)

05%20FP%20DATA%20COMPLETION.jpg

 

 

What you get

 

A kind of "fuel planning data sheet" which consists of : 

- a planned fuel table 

- a navigation log (with estimated time, altitude and fuel on board)

- an altitude & fuel left chart (which illustrates and allowed me to gain skills with Google Charts)

- icing on the fuel tank : you can print this whole sheet on a good ol' paper sheet which you can write on with your good ol' lead pencil

 

06%20FP%20FUEL%20PLANNING.jpg

 

07%20FP%20PRINT.jpg

 

 

What are the limits at the moment

 

- the format : this is a spreadsheet, not a nifty exe tool

 

- no wind influence at the moment. I plan to add this feature soon, as fuel planning is wrong without this information

 

- fixed flying conditions : 2000 ft VS for climb & descent, climbing @ 160 KIAS, cruising @ 195 KIAS, descending @ 190 KIAS. This is because collecting performance datas for a given flight already takes time, so under various conditions it is a task my 3 children will not let me the time to accomplish

 

- precision of the performance datas : it took me hours flying the T-Duke and collecting fuel flows, distances, altitude, ground speeds, at various altitudes 

 

 

 

The good news is that performance datas can be updated and refined without any other modification (all the other fields are calculated from these datas).

 

I plan to release this spreadsheet soon, hopefully with wind component integration (based on user input in the first sheet).

 

Please tell me what you think, what you would like, what you suggest.

Share this post


Link to post
Share on other sites
Help AVSIM continue to serve you!
Please donate today!

I just finished adding wind integration.

 

- wind direction and speed is entered on the same sheet as the flightplan (I use Routefinder and Simroutes to generate my FP and ASN to get wind information for each point)

 

dukefuel01.jpg

 

 

- I slightly enriched the complementary data sheet, which now displays the total fuel burnt : you can now see on the same sheet how CRZ level affects fuel burn

dukefuel02.jpg

 

- and finally you get your Navigation Log with estimated FOB, timings and altitude (look at the FOB chart shape due to winds shift while cruising !)

dukefuel03.jpg

 

 

I need to :

 

- rework the layout of the sheets, to make it more "user-friendly"

 

- sort out some Google Spreadsheet-related quirks

 

But the main framework and calculations part is ready.

 

I will update this topic when this file will be released to all of you Turbine Duke enthusiasts  :wub:

Share this post


Link to post
Share on other sites

A little teasing about the output state (some fields are not still populated but you get the idea)   B)

 

e1d31226-a34d-482e-aa4b-bea4749c1803.jpg

Share this post


Link to post
Share on other sites

Seems very interesting. I'm flying right now the Duke with my homemade spreadsheet. Yours seems much more elaborated..  looking forward for the release...

Share this post


Link to post
Share on other sites

Okay fellow Royal Dukes
 
I reworked most of my spreadsheet output. I gave up the above Nav log for a "simpler" one.
 
This will be, at least in the first public version, your result :
 
preview.jpg
 
I still have to work on fields names to make the whole spreadsheet clearer and simpler to update.
 
It should be released within the next 24 hours.

Share this post


Link to post
Share on other sites

Al'right gentlemen.
 
If you do not have a Gmail, it's time to create an account.
 
http://goo.gl/XJuZ3F

PLEASE DO NOT MODIFY THIS FILE

Add the whole folder to your account, clicking on "Add to my Drive". This will create a copy in your Drive, which you will be able to use as you want.

1b4bc179-fd25-484d-b552-0c2af395df27.jpg

This spreadsheet has been created and updated with Google Sheets. I cannot guarantee its proper functionning with MS Excel or any other spreadsheet application. But, hey, I do not guarantee it is bug free under Google Sheets soooo  :rolleyes:
 
Do not use it for real operations, I do not want to be responsible for a new Azores Glider  :ph34r:
 
Please give me your feedback and suggestions.
 

How to:

- copy-paste or manually fill in the 1st sheet "1- INSERT FP HERE" (I use Routefinder then Simroutes to generate the FP and export it to FSX format. Then Active Sky Next to load the FP and get wind informations)

- fill in complementary data in the 2nd sheet "2 - FILL IN DATA HERE". You can modify Reg Number, Cruise level and fuel reserves settings (ALTN, TAXI TIME, HOLDING REQUIREMENT)

- all other fields in this sheet are fixed : check DEPARTURE and ARRIVAL AIRPORT informations (ICAO and altitudes). If these fields are not updated, the spreadsheet may be refreshing. Try to hit F5.

- then you should get an updated Navigation Log on the 3rd sheet "3- GET YOUR NAV LOG". Check informations consistency. You can print it (CTRL+P) : this page is formatted to be printed without gridlines, portrait, fit to width.

 

KEEP IN MIND THE UPDATE MAY TAKE A FEW SECONDS, HIT F5 IF IT SEEMS TO BE NOT REFRESHING

Share this post


Link to post
Share on other sites

I am preparing version 1.1 of my spreadsheet. I reworked 95 % of the calculations.

 

I did a test flight to compare planned climb and cruise altitude / fuel. The results are quite spot-on :

 

rwvsplan.jpg

 

- Cruise altitude reached 0.4 nm before calculated TOC distance (40 nm, this is a 1% error)

 

- 51,4 Gallons of fuel on board after 180 miles, versus 51,9 planned (< 1 % error)

 

I also added wind smoothing between fixes, and an immediate fuel consumption chart.

 

The new version should be released in the next 48h. It will be dedicated to the innocents who lost their lives aboard flight #4U9525.

Share this post


Link to post
Share on other sites

Version 1.1 here

 

http://goo.gl/Cz9pe6

 

I chose to change the sharing method. This link will allow you to download the spreadsheet. Please upload it to your Google Drive to use it with Google Sheets. I can not guarantee it will work as it should with MS Excel or any other spreadsheet application.

 

changelog%201.1.gif

Share this post


Link to post
Share on other sites

Fantastic work thanks so much for your time and efforts! I've just been using fuel burn/hour averages for my flights which has left me cleaning my pants a few times......

 

I would be more than willing to volunteer for additional performance info if you want to expand this thing such as various climb/descent rates and speeds.

 

This would be easy as I primarily only fly the turbine duke and I fly almost daily with it in prepar3d.

Share this post


Link to post
Share on other sites

Thanks to both of you.

 

@777200LRF : I am sorry but I really do not have much time these days. So I focus on polishing the TDuke spreadsheet and do not plan creating profiles for a tool (PFPX) I do not know, nor own. But if you look at my spreadsheet maybe could it give you ideas to create a pfpx profile ?

 

@arnobg : adding various climb / descend profiles is the next step. I think I will add 1000 / 1200 / 1500 / 1800 to the current 2000. This should cover 95 % of our flights. And do not prevent from pushing the Royal Turbine to a good 4000 ft/mn for a few minutes  :wub:

Share this post


Link to post
Share on other sites

Thanks to both of you.

 

@777200LRF : I am sorry but I really do not have much time these days. So I focus on polishing the TDuke spreadsheet and do not plan creating profiles for a tool (PFPX) I do not know, nor own. But if you look at my spreadsheet maybe could it give you ideas to create a pfpx profile ?

 

@arnobg : adding various climb / descend profiles is the next step. I think I will add 1000 / 1200 / 1500 / 1800 to the current 2000. This should cover 95 % of our flights. And do not prevent from pushing the Royal Turbine to a good 4000 ft/mn for a few minutes  :wub:

 

 

Awesome, let me know if you need help gathering data like I said, I fly the thing every day IFR and wouldn't mind logging some things during my flights. I have actually been logging fuel burn in my log book every flight already.

 

About to go hop in now and do some flying now actually!

Share this post


Link to post
Share on other sites

That's very kind of you.

 

At this time, it would be very valuable to have your feedback about the Nav Log :

 

- is it close to your real fuel burnt / altitude / ETE ?

 

- which feature would you like added (keeping in mind it is only a spreadsheet)

 

So while flying, you can collect your data (fuel left, altitude, time) every, say, x miles or fix, and give your feedback here.

Share this post


Link to post
Share on other sites

Can you elaborate a little on how to actually insert your flight plan?

 

Do you just have to hand type everything including winds?

Share this post


Link to post
Share on other sites

Yep, I cannot get and parse your flightplan from a source, right to the spreadsheet.

 

Wind information is not mandatory, if you leave the fields blank, your nav log will be computed with winds = 0

 

I know manually typing your FP is a bit tedious but at the moment I have no other solution. And this is a < 1000 nm - range - aircraft. If it can help you, imagine typing your 8000nm-FP for an A380  :lol:

Share this post


Link to post
Share on other sites

Yep, I cannot get and parse your flightplan from a source, right to the spreadsheet.

 

Wind information is not mandatory, if you leave the fields blank, your nav log will be computed with winds = 0

 

I know manually typing your FP is a bit tedious but at the moment I have no other solution. And this is a < 1000 nm - range - aircraft. If it can help you, imagine typing your 8000nm-FP for an A380  :lol:

 

Okay thanks for verifying this. I'll be doing a VA flight some time this evening in the Duke so I'll report my findings.

Share this post


Link to post
Share on other sites

Just great!

I bought the T-Duke today and this is the very best prop aircraft i have ever seen in fsx, love it.

 

Your fuel planning tool is the missing link to this great aircraft.

Thank you very much for your work! Will trie it asap!

Share this post


Link to post
Share on other sites

It's been a while since I last updated this thread. My 3rd child was born mid-April and I have to say it is only 5 Months later that I am getting "free time"  :wink:

 

Long story short, here is the Fuel Planning Spreadsheet 1.2

 

T-Duke Fuel Planning 1.2 (897 ko)

 

fuel1.2.gif

 

How to :

 

- download and upload to your Google Docs

- Sheet "1- FLIGHTPLAN" fill in you FP (you can copy paste from Simroutes, I use the same columns). Wind information is not mandatory, if empty it assumes 0/0

- Sheet "2- FLIGHT DATA" check the informations, choose the CRZ level, the fuel units and the various reserves

- Sheet "3- NAVIGATION LOG" : no comment here, it speaks for itself. You get your flight main informations, arr/dep METAR sparsed realtime from http://weather.noaa.gov, fuel planning, FOB and altitude chart, and a point by point nav log

 

Please keep in mind this is only a spreadsheet. The good news is that you can display it on your mobiles devices : smartphone, tablet, laptop etc

 

Please give your feedback

Share this post


Link to post
Share on other sites

Great creativity in Excel. Kudos. You are learning a great deal about flying and its parameters and calculations, as well as about Excel. Excellent!  I did a similar workbook in Excel in the early '90s and distributed it on the Prodigy network to members of SunAir Airways, the first VA. It was a great learning experience as IAS had to be converted to TAS, and then converted with wind data to GS. And TAS is dependent on both altitude and OAT°. It worked great, but was work intensive as a significant data table had to be manually entered for each flight, and first winds aloft data and temps aloft had to be DL from DUATS, which required a membership. There were really basic flight planning programs, but they were more for MSFS, and didn't really address the ATP type aircraft or typical ATP FLs.

 

That was yesterday. Today there are sophisticated online flight planning services, some of whom are free and reach out and embrace simulator pilots. It may not be as much fun as creating your own, but is not at all so work intensive for each flight. I use Fltplan.com. It has built in performance tables from surface level to max cruise altitude for most aircraft types, including the Turbine Duke. It can closely estimate your fuel burn either by a simple gallons (or lbs) per hour basis, or based on the performance data table. It automatically factors in the winds aloft and temps aloft for your planned route.  The first image below is what a complete flight plan printout looks like. The second image shows the structure of the performance data table. The table for the Turbine Duke goes up to 28,000 at 1,000 ft levels, and you can modify the table based on your own experience.

 

The flight planning allows you to enter compressed routes as it handles SIDs, STARs, and Jet and Victor airways. You just have to define your entry and exit point from each airway along your route.

 

I  made a flight from KIND (Indianapolis) to KFLO (Florence, SC) last Thursday using weather from FS Global Real Weather, had a relatively straight in approach, and my actual fuel burn was within 2% of the flight plan.

 

There is a separate thread I posted about a month ago illustrating more of the capabilities of the site, including an iPad app that connects the site, your flight plan, and FSX to give you a moving map of your route and allows you to see real time weather and wind barbs on the map.

 

fltplanDotCom-XL.jpg

 

 

 

fltplanDotCom%282%29-XL.jpg

 

Data Table continues on up to 28,000 for the Turbine Duke.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now