Sign in to follow this  
lassekronborg

Updated tool for 737NG performance planning

Recommended Posts

Hi all

 

I have updated the b737ng dispatch sheet to version 4.9.7. Find it here: http://library.avsim.net/esearch.php?CatID=fsxutil&DLID=188491

 

This is the most comprehensive package for performance calculations for the 737ng. And it is 100 percent free. All you need is Excel 2007 or newer. It calculates what you need to know about your flight. Weight, fuel, balance, time, and a lot more. It can create load sheets and list of frequencies of airports. And it will give you v-speeds, landing and take off distancs as well as derate calculations under all circumstances and configurations.

 

As always comments and feed back is very welcome. Have fun.

 

cheers

Lasse Kronborg

Share this post


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

 

 


As always comments and feed back is very welcome. Have fun.

 

Looks like a cool project and very comprehensive.

 

The mention of "database" together with "Excel" does make the inner database nerd in me cringe, though.  :P

Share this post


Link to post
Share on other sites

Looks like a cool project and very comprehensive.

 

The mention of "database" together with "Excel" does make the inner database nerd in me cringe, though. :P

Yes I know. Couldn't finde a better word for a list of 8000+ airports with all runways, frequencies, coordinates etc.

 

Maybe if you have the time, you could comment on the included word document where I try to cover a wide range of performance planning principles. You seem to be quite informed about aircraft operations :-).

Share this post


Link to post
Share on other sites

 

 


Yes I know. Couldn't finde a better word for a list of 8000+ airports with all runways, frequencies, coordinates etc.

 

It's definitely a database at its most basic definition - no worries. It just makes me uneasy because there are literally thousands upon thousands of companies running off of Excel Databases that aren't up to the task and/or aren't optimized for the task. I've worked with several of them.

 

At least you're using Excel. I once took over a contract where the last guy had been tracking projects in Word.

 

...and don't get me started on Excel Reporting.  :P

 

 

 


Maybe if you have the time, you could comment on the included word document where I try to cover a wide range of performance planning principles. You seem to be quite informed about aircraft operations :-).

 

I'll take a look when I get home and let you know.

Share this post


Link to post
Share on other sites

 

 


I'll take a look when I get home and let you know.

 

That would be awesome. Also there could be a few linguistic mistakes here and there. Don't hesitate to comment on that as well. Så kan jeg støtte dig med det danske, hvis det bliver nødvendigt :P

 

Share this post


Link to post
Share on other sites

Do you have to pay for the software to view it? like excel

I think you can download a free Excel viewer from Microsoft. 

Share this post


Link to post
Share on other sites

Yes you'll need excel. I haven't seen a single excel clone beeing able to cope with the calculations in the sheet. Its some rather complicated functions beeing used. Excel before 2007 won't handle it either.

Ok i downloaded it, but its not letting me change anything?

Using a reader you can only read.

Ok i downloaded it, but its not letting me change anything?

Using a reader you can only read.

Share this post


Link to post
Share on other sites

Hi all

 

I have updated the b737ng dispatch sheet to version 4.9.7. Find it here: http://library.avsim.net/esearch.php?CatID=fsxutil&DLID=188491

 

This is the most comprehensive package for performance calculations for the 737ng. And it is 100 percent free. All you need is Excel 2007 or newer. It calculates what you need to know about your flight. Weight, fuel, balance, time, and a lot more. It can create load sheets and list of frequencies of airports. And it will give you v-speeds, landing and take off distancs as well as derate calculations under all circumstances and configurations.

 

As always comments and feed back is very welcome. Have fun.

 

cheers

Lasse Kronborg

Is there anyway to use this tool just to get Takeoff and Landing info, so like Derate and v speeds, kinda like TOPCAT? I ask because I need a TOPCAT like thing for the -900. Thanks

Share this post


Link to post
Share on other sites

Is there anyway to use this tool just to get Takeoff and Landing info, so like Derate and v speeds, kinda like TOPCAT? I ask because I need a TOPCAT like thing for the -900. Thanks

Yes you can. As long as weathr and weights correct weather and weights are entered it will do just that.

Share this post


Link to post
Share on other sites

Ok have you got a link to one where i can use it? cheers.

Vernon

Buy it from Micosoft at http://www.microsoftstore.com/store/msusa/en_US/pdp/productID.259321300?tid=szTCnHAm8_dc&cid=5250&pcrid=68014196201&pkw=excel&pmt=e&WT.srch=1&WT.mc_id=pointitsem_Microsoft+US_google_Adobe+-+Excel&WT.term=excel&WT.campaign=Adobe+-+Excel&WT.content=zTCnHAm8&WT.source=google&WT.medium=cpc&s_kwcid=AL!4249!3!68014196201!e!!g!!excel&ef_id=VJrZ-wAAABbOB8ws:20150129052847:s for $110.00. Maybe you can find it cheaper at another website.

Share this post


Link to post
Share on other sites

 

That would be awesome. Also there could be a few linguistic mistakes here and there. Don't hesitate to comment on that as well. Så kan jeg støtte dig med det danske, hvis det bliver nødvendigt :P

 

 

 

Looks good to me. The history seems a bit disjointed (jumpy), but that's not a big issue. The only actual issues I found were that you should review the NADPs (both use 800 and 3000, but they aren't inverted - NADP1 uses an accel alt of 3000 while NADP2 uses 800 to FLAPS UP and then climb speed at 3000), and that the trim statement in section 6 was a bit odd (it almost sounded like you were trying to say "you don't trim as much/often" when it should be "not as much trim is required"). Either way, both are relatively minor. Good work.

 

...now let's hope that someone actually reads all that. You know, because so many people read manuals  :P

Share this post


Link to post
Share on other sites

Cheers michael a bit steep just for something thats free!

 

I would love to use this for VAPP speed as TOPCAT is terrible at calculating the 737NG VAPP speed.

Share this post


Link to post
Share on other sites

Would be cool if you could make a calculator just for Takeoff and Landing performance, I know most people use pfpx or simbrief, but it's the lack of TOPCAT profiles for many airplanes that people would love to have, ie T7-300ER/Airbus from Aerosoft, any plans on making such a calculator for Takeoff/Landing?
 

Share this post


Link to post
Share on other sites

I made one for the 777 but its very simple. Search for it in avsim file library. But it takes a lot of time I don't have at the moment to make new performance calculators.

Share this post


Link to post
Share on other sites

Looks good to me. The history seems a bit disjointed (jumpy), but that's not a big issue. The only actual issues I found were that you should review the NADPs (both use 800 and 3000, but they aren't inverted - NADP1 uses an accel alt of 3000 while NADP2 uses 800 to FLAPS UP and then climb speed at 3000), and that the trim statement in section 6 was a bit odd (it almost sounded like you were trying to say "you don't trim as much/often" when it should be "not as much trim is required"). Either way, both are relatively minor. Good work.

 

...now let's hope that someone actually reads all that. You know, because so many people read manuals  :P

Thanks Kyle. Ill have a look on those sections again. Sometimes when you know what you wanted to say, you don't see what you actually wrote. :-)

Share this post


Link to post
Share on other sites

Cheers michael a bit steep just for something thats free!

 

I would love to use this for VAPP speed as TOPCAT is terrible at calculating the 737NG VAPP speed.

 

Just out of curiosity, why do you use a tool to do that?

 

sig.gif

Share this post


Link to post
Share on other sites

 

 


I would love to use this for VAPP speed as TOPCAT is terrible at calculating the 737NG VAPP speed.

 

Probably because it's terrible at calculating fuel requirements/burn (in all honesty because it's not meant for that purpose - the feature is only there to give you a cursory idea). It's really only there to verify that you can, actually, potentially land on the destination runway (the FMC doesn't take that into account). You should defer to the FMC for your Vapp/Vref.

Share this post


Link to post
Share on other sites

Hi all

 

I have updated the b737ng dispatch sheet to version 4.9.7. Find it here: http://library.avsim.net/esearch.php?CatID=fsxutil&DLID=188491

 

This is the most comprehensive package for performance calculations for the 737ng. And it is 100 percent free. All you need is Excel 2007 or newer. It calculates what you need to know about your flight. Weight, fuel, balance, time, and a lot more. It can create load sheets and list of frequencies of airports. And it will give you v-speeds, landing and take off distancs as well as derate calculations under all circumstances and configurations.

 

As always comments and feed back is very welcome. Have fun.

 

cheers

Lasse Kronborg

Lasse,

 

Thanks for this tool.  I started working with it today.  The lavender dropdowns seem to work except the one for selecting atmospheric pressure.  Wen clicking in this field, no dropdown, unable to change "mb" to inches of Hg.  Is this a known problem ?  Am I doing something wrong ?

 

Zachlog

Share this post


Link to post
Share on other sites

Give me today to see if I messed something up with the new revision. It is not supposed to be a drop down but a push button in the sheet.

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
Sign in to follow this