January 7, 201214 yr I have downloaded but not used it, The fact though that you have taken time to do something like this...a big thank you to you! Richie Lumsden
January 7, 201214 yr Author Hi! Please, can you said me the parameters used (in orange fields)?Thanks! "If you see any error/issue please said me!"I'm afraid there are still some :V1 (kts) [of Chart 1] FAUX - Minimum TORA Required for Field Limit Weight (ft) Err :508 Dry Runway Minimum TORA Required for Climb Limit Weight (ft) Err :508 Dry Runway Minimum TORA Required for Field Limit Weight (ft) Err :508 Wet Runway Minimum TORA Required for Climb Limit Weight (ft) Err :508 Wet Runway Takeoff Field & Climb Minimum TORA (ft) Err :508 For weight (1.000 lb): 159,3 TORA Condition Err :508 Landing Distance Required (ft)[from Chart 4.a, 4.b & 4.c] Err :508 Err :508 Err :508 Israel D' Oleo Ochoa
January 7, 201214 yr Author If you can fill this chart, thanks! INFORMATION FOR TAKE OFF & LANDING Description ValueStation Weather Information QNH (inHg) [see Chart 5] 30,05OAT (ºC) 31Wind Direction (º) 120Wind Speed (kts) 30Gust (kts) 0Airport Information Runway Heading (º) 69Airport Elevation (ft) 5.000Runway Slope (%) 2,0TORA (ft) 9.882LDA (ft) 9.500Clearway Distance [CW] (ft) 200Stopway Distance [sW] (ft) 500Aircraft Information Weight (1.000 lb) 170,0Take Off Information Take Off Power FullFlaps Position 5Runway Condition WetEngine Bleed for Packs OffAnti-Ice System Engine &Wing Anti-Ice OffLanding Information Runway Condition DryBraking Configuration Auto 2Landing Flaps 40 "If you see any error/issue please said me!"I'm afraid there are still some :V1 (kts) [of Chart 1] FAUX - Minimum TORA Required for Field Limit Weight (ft) Err :508 Dry Runway Minimum TORA Required for Climb Limit Weight (ft) Err :508 Dry Runway Minimum TORA Required for Field Limit Weight (ft) Err :508 Wet Runway Minimum TORA Required for Climb Limit Weight (ft) Err :508 Wet Runway Takeoff Field & Climb Minimum TORA (ft) Err :508 For weight (1.000 lb): 159,3 TORA Condition Err :508 Landing Distance Required (ft)[from Chart 4.a, 4.b & 4.c] Err :508 Err :508 Err :508 Edited January 7, 201214 yr by idoleo2001 Israel D' Oleo Ochoa
January 7, 201214 yr "Hi! Please, can you said me the parameters used (in orange fields)?"the ones provided with V 1.09 (I did not make any change)To make sure, I just tried the ones you mentionned above and I got the same erros/issuesI'm currently using OpenOffice but that should not be the cause...
January 7, 201214 yr Author Hi! I revised the sheet in alternative reader (LibreOffice, is like OpenOffice) and shows 503 ERR; maybe is not compatible with all options that have MS Office 2010. "Hi! Please, can you said me the parameters used (in orange fields)?"the ones provided with V 1.09 (I did not make any change)To make sure, I just tried the ones you mentionned above and I got the same erros/issuesI'm currently using OpenOffice but that should not be the cause... Edited January 7, 201214 yr by idoleo2001 Israel D' Oleo Ochoa
January 8, 201214 yr "Hi! I revised the sheet in alternative reader (LibreOffice, is like OpenOffice) and shows 503 ERR; maybe is not compatible with all options that have MS Office 2010"do you mean that your tool can run with MS Office 2010 only ? I was not aware that some MS Office apps can't be run with OpenOffice or LibreOffice and it makes me very surprised...Concerning the B33 cell V1 (kts) the formula I can read is :=SI(B32="Dry";SI(B30="Full";SI(B31=F6;F7;SI(B31=G6;G7;SI(B31=H6;H7;SI(B31=I6;I7;SI(B31=J6;J7)))));0))tell me if I'm wrong but this formula cannot give any result for V1 any except for t/o power set to Full + rwy condition set to Dry + flaps setting of any choice. All others settings (Wet + Derate1 or Derate 2) are not taken into consideration. Is that by purpose ? Edited January 8, 201214 yr by ontheair
January 8, 201214 yr Author Hi! The complete formula for cell B33 is:SI(B32="Dry";SI(B30="Full";SI(B31=F6;F7;SI(B31=G6;G7;SI(B31=H6;H7;SI(B31=I6;I7;SI(B31=J6;J7)))));SI(B30="Derate 1";SI(B31=K6;K7;SI(B31=L6;L7;SI(B31=M6;M7;SI(B31=N6;N7;SI(B31=O6;O7)))));SI(B30="Derate 2";SI(B31=P6;P7;SI(B31=Q6;Q7;SI(B31=R6;R7;SI(B31=S6;S7;SI(B31=T6;T7)))));)));SI(B32="Wet";SI(B30="Full";SI(B31=F11;F12;SI(B31=G11;G12;SI(B31=H11;H12;SI(B31=I11;I12;SI(B31=J11;J12)))));SI(B30="Derate 1";SI(B31=K11;K12;SI(B31=L11;L12;SI(B31=M11;M12;SI(B31=N11;N12;SI(B31=O11;O12)))));SI(B30="Derate 2";SI(B31=P11;P12;SI(B31=Q11;Q12;SI(B31=R11;R12;SI(B31=S11;S12;SI(B31=T11;T12)))));)));))You show only the first line (bold); maybe this is the problem with alternative office reader, maybe won't show the complete formula (limited characters for cell). "Hi! I revised the sheet in alternative reader (LibreOffice, is like OpenOffice) and shows 503 ERR; maybe is not compatible with all options that have MS Office 2010"do you mean that your tool can run with MS Office 2010 only ? I was not aware that some MS Office apps can't be run with OpenOffice or LibreOffice and it makes me very surprised...Concerning the B33 cell V1 (kts) the formula I can read is :=SI(B32="Dry";SI(B30="Full";SI(B31=F6;F7;SI(B31=G6;G7;SI(B31=H6;H7;SI(B31=I6;I7;SI(B31=J6;J7)))));0))tell me if I'm wrong but this formula cannot give any result for V1 any except for t/o power set to Full + rwy condition set to Dry + flaps setting of any choice. All others settings (Wet + Derate1 or Derate 2) are not taken into consideration. Is that by purpose ? Israel D' Oleo Ochoa
January 8, 201214 yr ".....maybe this is the problem with alternative office" Must admit it's true and you're right !I just downloaded the MS Office demo version just to check, and your NGX tool works pretty fine. The errors/issues are gone away !I'm going to investigate the reason why it doesn't with openofficeThanks again Israel
January 8, 201214 yr Author You're welcome! If you find any issue please advise me!See ya! ".....maybe this is the problem with alternative office" Must admit it's true and you're right !I just downloaded the MS Office demo version just to check, and your NGX tool works pretty fine. The errors/issues are gone away !I'm going to investigate the reason why it doesn't with openofficeThanks again Israel Israel D' Oleo Ochoa
January 9, 201214 yr Hey, I cant figure out how to use it, is that supposed to open it in a Excel? how can i check the results? thanks for this tool great job!!!BTW how can I change it from 22k to 24k to 26k and opposite? Edited January 9, 201214 yr by Daniel choen Daniel choen
January 9, 201214 yr "is that supposed to open it in a Excel?" yes"how can i check the results?" do you need to do that ? Don't you trust the dev (Israel) ?"BTW how can I change it from 22k to 24k to 26k and opposite" see General Data tab "take off power" cell B30
January 9, 201214 yr Author Hi!1. The file was made in MS Excel 2010, and it is incompatible with OppenOffice; i don't know if the file works fine with MS Excel previous version.2. For check the results you need use all tables in FCOM v1 sections PD.30 and PI.30; you need make linear interpolation between cells.3. For change between take off power you need select "Full" for 26k, "Derate 1" for 24k and "Derate 2" for 22k in cell "Take off power".4. For use the sheet you need fill only orange cells, it's all!Thanks! Hey, I cant figure out how to use it, is that supposed to open it in a Excel? how can i check the results? thanks for this tool great job!!!BTW how can I change it from 22k to 24k to 26k and opposite? Israel D' Oleo Ochoa
January 9, 201214 yr Hi!1. The file was made in MS Excel 2010, and it is incompatible with OppenOffice; i don't know if the file works fine with MS Excel previous version.2. For check the results you need use all tables in FCOM v1 sections PD.30 and PI.30; you need make linear interpolation between cells.3. For change between take off power you need select "Full" for 26k, "Derate 1" for 24k and "Derate 2" for 22k in cell "Take off power".4. For use the sheet you need fill only orange cells, it's all!Thanks! Hey, thanks both for the answer, can you confirm that what i will put is the number in the left upper side of the screen? Daniel choen
January 9, 201214 yr Author Hi!You need fill column "B", specifically:- Row 5, QNH (pressure in airport, see METAR information)- Row 7, OAT (temperature in airport, see METAR information)- Row 8, wind direction (see METAR information)- Row 9, wind speed (see METAR information)- Row 10, gust (see METAR information)- Row 12, runway heading (see airport chart)- Row 13, airport elevation (see airport chart)- Row 17, runway slope (you must calculate with elevation and length runway, see airport chart)- Row 18, Takeoff Runway Available (the length of runway declared available and suitable for the ground run of an airplane taking off, see airport chart)- Row 19, Landing Runway Available (the length of runway which is declared available and suitable for the ground run of an airplane landing, see airport chart)- Row 20, Clearway Distance (additional distance after runway, may be of grass or water, and have less 1,5% slope, and its use for increase distance for initial climb in takeoff; clearway is not represented in airport chart, you need contact to airport administrator for this information)- Row 21, Stopway Distance (additional distance after runway for use in case of emergency; it have surface for support aircraft weight; see airport chart; stopway is not available in all airports)- Row 27, weight aircraft in thousand pounds- Row 30, takeoff power thrust; you can choose Full (26k), Derate 1 (24k) or Derate 2 (22k).- Row 31, takeoff flap position; you can choose 1, 5, 10, 15, or 25 degrees.- Row 32, runway condition; you can choose Dry or Wet.- Row 40, Engine Bleed for Packs; you can choose On or Off.- Row 41, Anti-Ice System; you can choose Engine Anti-Ice On, Engine Anti-Ice Off, Engine & Wing Anti-Ice On or Engine & Wing Anti-Ice Off.- Row 58, same like Row 32- Row 59, braking configuration; you can choose Max Manual, Max Auto, Autobrake 3, Autobrake 2 or AUtobrake 1. - Row 60, langind flaps; you can choose 15, 30 or 40 degrees.It's all! See ya! Hey, thanks both for the answer, can you confirm that what i will put is the number in the left upper side of the screen? Israel D' Oleo Ochoa
January 9, 201214 yr I will revise the error, thanks a lot!!! I have a new version with minimum needed take off length; in few hours i will upload the last version! See ya! Thanks so much for this, it's really good!Kimberly Richmond-Jones
Create an account or sign in to comment