{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","W&B FORM","Performance FORM","C172 Performance specs","OO-AWT"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,4,4,5],[6,1,8,1],[16,0,16,5],[17,0,17,5]]}
[]
[]
[]
[]
["remarks? tony.opsomer@gmail.com",null,null,null,"version 2021-12-03"]
[]
[null,"C172","Weight and balance form"]
[]
[null,null,"Performance form"]
[]
[]
[]
[]
[]
[]
[]
["Vliegclub Grimbergen BE.DTO.113"]
["download the latest version from https://goahead.classy.be/weight-balance/ "]

{"sheet":"W&B FORM","index":1,"n_rows":48,"n_cols":24,"rows_kept":48,"cut":false,"hidden":false,"merged":[[3,4,3,6],[5,12,5,15],[12,12,13,12],[7,14,13,15],[12,5,12,6],[13,5,13,6],[9,5,9,6],[8,5,8,6],[7,5,7,6],[10,5,10,6],[35,26,35,28],[35,29,35,30],[35,31,36,31],[47,1,47,15],[4,12,4,15],[27,19,27,21],[14,12,14,15],[16,12,16,15],[6,19,6,20],[18,12,18,15],[17,12,17,15],[11,5,11,6]]}
[null,{"$f":"Introduction!A5","v":"remarks? tony.opsomer@gmail.com"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!E5","v":"version 2021-12-03"}]
[null,"Weight and Balance form C172 OO-AWT",null,null,null,null,null,null,null,null,null,null,null,null,null,"BE.DTO.113",null,null,null,"Calculations"]
[]
[]
[null,null,null,null,null,null,null,"Fuel quantity","Weight ","Arm","Moment",null,"Form validity checker"]
[null,null,null," ",null,null,null,"[l]","[kg]","[in]","[lbs.in]",null,"Don't forget: always do a manual check on your data!!"]
[null,"Basic empty weight (includes engine oil and unusable fuel)",null,null,null,null,null,null,{"$f":"'OO-AWT'!E10","v":677.97190120000005},{"$f":"'OO-AWT'!C11","v":39.287999999999997},{"$f":"'OO-AWT'!C12","v":58722.835400000004}]
[null,"Usable fuel ",null,"mean arm:",47.81,"inch",null,null,{"$f":"H8*0.72","v":0},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",E8)","v":47.81},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",I8*2.204623*J8)","v":0},null,{"$f":"IF(H8=\"\",\"COMPLETE THE FORM\",IF(H8>'OO-AWT'!E4,\"FUEL TANK OVERFLOW\",\"FUEL QUANTITY WITHIN LIMIT\"))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\"),\"COMPLETE THE FORM\",IF(SUM(I8:I14)>'OO-AWT'!E15,\"TOO MUCH USEFUL LOAD\",IF(SUM(I8:I14)>'OO-AWT'!E16,\"TOTAL USEFUL LOAD WITHIN NORMAL CATEGORY LIMIT\",\"TOTAL USEFUL LOAD WITHIN UTILITY CATEGORY\")))","v":"COMPLETE THE FORM"}]
[null,"Pilot",null,"mean arm:",37,"inch",null,null,null,{"$f":"E9","v":37},{"$f":"I9*2.204623*J9","v":0}]
[null,"Front passenger",null,"mean arm:",37,"inch",null,null,null,37,0]
[null,"Rear passenger 1",null,"mean arm:",73,"inch",null,null,null,73,0]
[null,"Rear passenger 2",null,"mean arm:",73,"inch",null,null,null,73,0]
[null,"Baggage area 1",null,"mean arm:",95,"inch",null,null,null,95,0,null,{"$f":"IF(OR(I13=\"\",I14=\"\"),\"COMPLETE THE FORM\",IF(I13>'OO-AWT'!E19,\"TOO MUCH BAGGAGE IN AREA 1\",IF(I14>'OO-AWT'!E20,\"TOO MUCH BAGGAGE IN AREA 2\",IF(SUM(I13:I14)>'OO-AWT'!E19,\"TOO MUCH BAGGAGE IN AREA 1 AND 2\",\"PARTITIONING OF BAGGAGE IN AREAS 1 AND 2 WITHIN LIMITS\"))))","v":"COMPLETE THE FORM"}]
[null,"Baggage area 2",null,"mean arm:",123,"inch",null,null,null,123,0]
[null,"RAMP WEIGHT AND MOMENT",null,null,null,null,null,{"$f":"I15*2.204623","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\"),\"COMPLETE THE FORM\",SUM(I7:I14))","v":"COMPLETE THE FORM"},{"$f":"IF(I15=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",K15/H15)","v":"COMPLETE THE FORM"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\"),\"COMPLETE THE FORM\",SUM(K7:K14))","v":"COMPLETE THE FORM"},null,{"$f":"IF(I15=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",\"CHECK RESULTS IN GRAPH BELOW\")","v":"COMPLETE THE FORM"}]
[null,"Fuel allowance for engine start, taxi and runup",null,null,null,null,null,{"$f":"'C172 Performance specs'!F58*3.785412","v":4.1639531999999999},{"$f":"H16*0.72","v":2.9980463039999998},{"$f":"E8","v":47.81},{"$f":"I16*2.204623*J16","v":316.00315142043877}]
[null,"TAKE-OFF WEIGHT AND MOMENT",null,null,null,null,null,{"$f":"I17*2.204623","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\",H16=\"\"),\"COMPLETE THE FORM\",I15-I16)","v":"COMPLETE THE FORM"},{"$f":"IF(I17=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",K17/H17)","v":"COMPLETE THE FORM"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\",H16=\"\"),\"COMPLETE THE FORM\",K15-K16)","v":"COMPLETE THE FORM"},null,{"$f":"IF(I17=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",\"CHECK RESULTS IN GRAPH BELOW\")","v":"COMPLETE THE FORM"}]
[null,"Total trip time",null,null,null,"hh:mm",null,{"$f":"(HOUR(E18)*60+MINUTE(E18))/60*'OO-AWT'!E6","v":0},{"$f":"H18*0.72","v":0},{"$f":"E8","v":47.81},{"$f":"I18*2.204623*J18","v":0},null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\",H16=\"\",E18=\"\"),\"COMPLETE THE FORM\",IF((H18+H16)>H8,\"NOT ENOUGH FUEL TO COMPLETE THE TRIP\",IF((H18+H16)>(H8-'OO-AWT'!E6/60*45),\"DANGER! DANGER! FUEL RESERVE LESS THAN 45 MIN\",\"TRIP TIME WITHIN LIMIT\")))","v":"COMPLETE THE FORM"}]
[null,"LANDING WEIGHT AND MOMENT",null,null,null,null,null,{"$f":"I19*2.204623","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\",H16=\"\",E18=\"\"),\"COMPLETE THE FORM\",IF(M18=\"TRIP TIME TOO BIG\",\"CHECK TRIP TIME\",I17-I18))","v":"COMPLETE THE FORM"},{"$f":"IF(I19=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(I19=\"CHECK TRIP TIME\",\"CHECK TRIP TIME\",K19/H19))","v":"COMPLETE THE FORM"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\",H16=\"\",E18=\"\"),\"COMPLETE THE FORM\",IF(M18=\"TRIP TIME TOO BIG\",\"CHECK TRIP TIME\",K17-K18))","v":"COMPLETE THE FORM"},null,{"$f":"IF(I19=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(I19=\"CHECK TRIP TIME\",\"\",\"CHECK RESULTS IN GRAPH BELOW\"))","v":"COMPLETE THE FORM"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conversion minutes  to hh:mm notation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hh","mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total minutes",null,null,{"$f":"TRUNC(U30/60,0)","v":0},{"$f":"ROUND((U30/60-TRUNC(U30/60))*60,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hh:mm",{"$f":"TIME(W30,X30,)","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This document is provided for secondary flightplanning and navigation only. It is the user/pilot's sole responsibility to verify the correctness of all  information provided by this sheet. "]

{"sheet":"Performance FORM","index":2,"n_rows":107,"n_cols":25,"rows_kept":107,"cut":false,"hidden":false,"merged":[[68,17,68,18],[69,17,69,18],[70,17,70,18],[36,6,36,8],[37,6,37,8],[38,6,38,8],[39,6,39,8],[42,8,45,8],[47,6,47,8],[52,6,52,8],[48,6,48,8],[54,1,55,8],[34,1,52,1],[34,6,34,8],[28,6,28,8],[4,1,23,1],[24,1,33,1],[2,14,2,15],[84,15,84,16],[18,6,18,8],[17,6,17,8],[8,6,8,8],[25,6,25,8],[12,8,15,8],[22,6,22,8],[23,6,23,8],[4,6,4,8],[118,19,118,21],[118,16,118,18],[2,6,2,8],[3,6,3,8],[118,13,118,15],[9,6,9,8],[7,6,7,8],[6,6,6,8],[27,6,27,8],[26,6,26,8],[97,13,97,14],[97,15,97,16],[97,17,97,18],[84,13,84,14],[84,17,84,18],[29,6,29,8]]}
[null,null,{"$f":"Introduction!A5","v":"remarks? tony.opsomer@gmail.com"},null,null,null,null,null,{"$f":"Introduction!E5","v":"version 2021-12-03"}]
[null,null,"Performance form C172 OO-AWT",null,null,null,null,null,"BE.DTO.113",null,null,null,"Calculations"]
[null,null,null,null,null,null,"Form validity checker"]
[null,null,null,null,null,null,"Don't forget: always do a manual check on your data!!"]
[null,"TAKE-OFF","Take-off weight [kg]",null,{"$f":"IF(ISERROR('W&B FORM'!I17*2.204623),\"FIRST CALCULATE W&B\",'W&B FORM'!I17)","v":"FIRST CALCULATE W&B"},null,{"$f":"IF(E5=\"FIRST CALCULATE W&B\",\"FIRST CALCULATE W&B DATA\",\"\")","v":"FIRST CALCULATE W&B DATA"}]
[null,null,"ICAO airport name"]
[null,null,"MSL Altitude [ft]",null,null,null,{"$f":"IF(E7=\"\",\"COMPLETE THE FORM\",\"AIRPORT ALTITUDE OK\")","v":"COMPLETE THE FORM"}]
[null,null,"QNH [hPa or mbar]",null,null,null,{"$f":"IF(E8=\"\",\"COMPLETE THE FORM\",IF(OR(E8<960,E8>1100),\"INVALID QNH\",\"QNH OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Pressure altitude [ft]",null,{"$f":"IF(OR(E7=\"\",E8=\"\"),\"COMPLETE THE FORM\",IF(E8>1013,(E7-(E8-1013)*30),(E7+(1013-E8)*30)))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E9=\"\",E9=\"COMPLETE THE FORM\"),\"COMPLETE THE FORM\",IF(E9>3000,\"LEANING OF MIXTURE IS RECOMMENDED\",\"LEANING OF MIXTURE NOT RECOMMENDED\"))","v":"COMPLETE THE FORM"}]
[null,null,"OAT Temperature [°C]",null,null,null,{"$f":"IF(E10=\"\",\"COMPLETE THE FORM\",IF(E10>=40,\"TEMPERATURE TOO HIGH\",\"TEMPERATURE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"Runway type dropdown list items"]
[null,null,"Density altitude [ft]",null,{"$f":"IF(OR(E8=\"\",E7=\"\",E10=\"\"),\"COMPLETE THE FORM\",E9+120*(E10-(15-(1.98/1000*E9))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,"DEFINE TYPE"]
[null,null,"Wind",null,null,null,null,null,null,null,null,null,"PAVED"]
[null,null,null,"Direction [°]",null,null,{"$f":"IF(E13=\"\",\"COMPLETE THE FORM\",IF(OR(E13<0,E13>359),\"INVALID WIND DIRECTION\",\"WIND DIRECTION OK\"))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E13=\"\",E14=\"\",E16=\"\"),\"COMPLETE THE FORM\",IF(E14<0,\"CHECK WIND VELOCITY\",IF(ABS(O17)>=15,\"CROSSWIND TOO STRONG\",IF(R16=\"USE OTHER RUNWAY DIRECTION\",\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",ROUND(ABS(O16),1)&\"kts \"&P16&\" AND \" & ROUND(ABS(O17),1)&\"kts \"&P17))))","v":"COMPLETE THE FORM"},null,null,null,"GRASS"]
[null,null,null,"Velocity [kts]",null,null,{"$f":"IF(E14=\"\",\"COMPLETE THE FORM\",IF(E14<0,\"INVALID WIND VELOCITY\",\"WIND VELOCITY OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Runway",null,null,null,null,null,null,null,null,null,"Takeoff wind calculations",null,null,null,null,"change in takeoff distance"]
[null,null,null,"Runway",null,null,{"$f":"IF(E16=\"\",\"COMPLETE THE FORM\",IF(OR(E16<0,E16>35),\"INVALID QFU\",\"QFU OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"headwind component [kts]",null,{"$f":"E14*COS((ABS((E16*10)-E13)*PI()/180))","v":0},{"$f":"IF(O16>=0,\"HEADWIND\",IF(O16<0,\"TAILWIND\",\"\"))","v":"HEADWIND"},null,{"$f":"IF(O16>=0,O16/9*-0.1,IF(AND(O16<0,O16>=-10),ABS(O16/2*0.1),\"USE OTHER RUNWAY DIRECTION\"))","v":0}]
[null,null,null,"type",1,null,{"$f":"IF(E17=\"\",\"\",IF(E17=1,\"DEFINE TYPE\",IF(E17=2,\"PAVED\",IF(E17=3,\"GRASS\"))))","v":"DEFINE TYPE"},null,null,null,null,null,"crosswind component [kts]",null,{"$f":"E14*SIN((ABS((E16*10)-E13)*PI()/180))","v":0},"CROSSWIND"]
[null,null,null,"TORA [m]",null,null,{"$f":"IF(E18=\"\",\"COMPLETE THE FORM\",IF(E18<0,\"INVALID RUNWAY LENGTH VALUE\",\"RUNWAY LENGTH VALUE OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Safety margin for takeoff distance",null,0.5,null,null,null,null,null,null,null,"Takeoff calculations"]
[null,null,"Take-off (flaps 0°, full throttle prior to brake release)",null,null,null,null,null,null,null,null,null,"Weight:",{"$f":"IF(OR(E5=\"\",E5=0,E5=\"FIRST CALCULATE W&B\"),\"\",E5*2.204623)","v":""},"lbs","-> taking this (higher) weight from takeoff data:",null,null,null,{"$f":"IF(N20<=1900,1900,IF(N20<=2100,2100,IF(N20<=2300,2300,IF(N20>2300,\"OVERWEIGHT\"))))","v":"OVERWEIGHT"},"lbs",null,"corresponding speeds"]
[null,null,null,"lift off IAS speed [kts]",{"$f":"IF(ISERROR(Y21),\"COMPLETE THE FORM\",Y21)","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lift off",{"$f":"VLOOKUP($T$20,'C172 Performance specs'!B7:D33,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"IAS speed at 50 ft [kts]",{"$f":"IF(ISERROR(Y22),\"COMPLETE THE FORM\",Y22)","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,"look between PA [ft]",null,null,"needed value [ft]",null,null,null,null,null,null,null,"at 50 ft",{"$f":"VLOOKUP($T$20,'C172 Performance specs'!B8:D34,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"ground roll [m]",{"$f":"IF(E9=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(R16=\"USE OTHER RUNWAY DIRECTION\",\"CHANGE RUNWAY\",IF(OR(E9>=8000,E10>=40),\"NO DATA AVAILABLE\",IF(G17=\"PAVED\",((1+R16)*P89*(1+E19))*0.3048,IF(G17=\"GRASS\",(((1+R16)*P89+(0.15*P89))*(1+E19))*0.3048,\"COMPLETE THE FORM\")))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,{"$f":"IF(E9<=0,0,LEFT(E9/1000,1)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(E9<=0,0,LEFT(E9/1000+1,1)*1000)","v":{"$error":"#VALUE!"}},null,{"$f":"E9","v":"COMPLETE THE FORM"}]
[null,null,null,"total to clear 50ft OBS [m]",{"$f":"IF(E9=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(R16=\"USE OTHER RUNWAY DIRECTION\",\"CHANGE RUNWAY\",IF(OR(E9>=8000,E10>=40),\"NO DATA AVAILABLE\",IF(G17=\"PAVED\",((1+R16)*Q89*(1+E19))*0.3048,IF(G17=\"GRASS\",(((1+R16)*Q89+(0.15*P89))*(1+E19))*0.3048,\"COMPLETE THE FORM\")))))","v":"COMPLETE THE FORM"},null,{"$f":"IF(E9=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(OR(E9>=8000,E10>=40),\"NO DATA AVAILABLE, CHECK P.A. / TEMP\",IF(G17=\"DEFINE TYPE\",\"DEFINE TYPE OF RUNWAY\",IF(E18=\"\",\"COMPLETE THE FORM\",IF(E24=\"CHANGE RUNWAY\",\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",IF(E24>E18,\"RUNWAY TOO SHORT\",IF(E24<=E18,\"RUNWAY LENGTH SUFFICIENT\")))))))","v":"COMPLETE THE FORM"},null,null,null,null,null,"look between temperatures [°C]",null,null,"needed value [°C]"]
[null,"CRUISE","Cruising weight [kg]",null,{"$f":"E5","v":"FIRST CALCULATE W&B"},null,null,null,null,null,null,null,{"$f":"IF(E10<=0,0,LEFT(E10/10,1)*10)","v":0},{"$f":"IF(E10<=0,0,LEFT(E10/10+1,1)*10)","v":0},null,{"$f":"E10","v":0}]
[null,null,"MSL Cruising altitude [ft]",null,2400,null,{"$f":"IF(E26=\"\",\"COMPLETE THE FORM\",IF(E26<=0,\"CRUISING ALTITUDE MUST GREATER THAN 0 FT\",\"CRUISING ALTITUDE OK\"))","v":"CRUISING ALTITUDE OK"}]
[null,null,"QNH [hPa or mbar]",null,1000,null,{"$f":"IF(E27=\"\",\"COMPLETE THE FORM\",IF(OR(E27<960,E27>1100),\"INVALID QNH\",\"QNH OK\"))","v":"QNH OK"}]
[null,null,"Pressure altitude [ft]",null,{"$f":"IF(OR(E26=\"\",E27=\"\"),\"COMPLETE THE FORM\",IF(E27>1013,(E26-(E27-1013)*30),(E26+(1013-E27)*30)))","v":2790},null,{"$f":"IF(OR(E28=\"\",E28=\"COMPLETE THE FORM\"),\"COMPLETE THE FORM\",IF(E28<0,\"INVALID MSL CRUISING ALTITUDE\",IF(E28>3000,\"LEANING OF MIXTURE RECOMMENDED\",IF(OR(E28>12000,E28<2000),\"NO DATA FOUND\",IF(AND(E28>0,E28<=3000),\"LEANING OF MIXTURE NOT RECOMMENDED\",)))))","v":"LEANING OF MIXTURE NOT RECOMMENDED"}]
[null,null,"OAT Temperature at cruising altitude [°C]",null,10,null,{"$f":"IF(OR(E29=\"\",E26=\"\",E27=\"\"),\"COMPLETE THE FORM\",IF(AND(E29<=((15-(1.98/1000*E28))+20),E29>=((15-(1.98/1000*E28))-20)),\"TEMPERATURE WITHIN DATA LIMITS\",\"TEMPERATURE OUT OF DATA LIMITS\"))","v":"TEMPERATURE WITHIN DATA LIMITS"}]
[null,null,"Desired %BHP-setting",null,1,null,{"$f":"IF(E30=1,\"COMPLETE THE FORM\",M113)","v":"COMPLETE THE FORM"}]
[null,null,"Cruise performance"]
[null,null,null,"RPM",{"$f":"IF(OR(E30=1,E29=\"\",E27=\"\",E26=\"\"),\"COMPLETE THE FORM\",IF(G28=\"NO DATA FOUND\",\"CHECK CRUISING ALT\",IF(OR(M113=\"%BHP VALUE NOT FOUND IN DATA\",ISERROR(R70)),\"CHECK %BHP VALUE\",IF(ABS(R116-O116)>20,\"CHECK TEMPERATURE\",R69/100))))","v":"COMPLETE THE FORM"}]
[null,null,null,"KTAS [kts]",{"$f":"IF(OR(E30=1,E29=\"\",E27=\"\",E26=\"\"),\"COMPLETE THE FORM\",IF(G28=\"NO DATA FOUND\",\"CHECK CRUISING ALT\",IF(OR(M113=\"%BHP VALUE NOT FOUND IN DATA\",ISERROR(R70)),\"CHECK %BHP VALUE\",IF(ABS(R116-O116)>20,\"CHECK TEMPERATURE\",R70-2))))","v":"COMPLETE THE FORM"}]
[null,null,null,"Fuel consumption [l/hr]",{"$f":"IF(OR(E30=1,E29=\"\",E27=\"\",E26=\"\"),\"COMPLETE THE FORM\",IF(G28=\"NO DATA FOUND\",\"CHECK CRUISING ALT\",IF(OR(M113=\"%BHP VALUE NOT FOUND IN DATA\",ISERROR(R70)),\"CHECK %BHP VALUE\",IF(ABS(R116-O116)>20,\"CHECK TEMPERATURE\",R71))))","v":"COMPLETE THE FORM"}]
[null,"LANDING","Landing weight [kg]",null,{"$f":"IF(ISERROR('W&B FORM'!I19*2.204623),\"FIRST CALCULATE W&B\",'W&B FORM'!I19)","v":"FIRST CALCULATE W&B"},null,{"$f":"IF(E35=\"FIRST CALCULATE W&B\",\"FIRST CALCULATE W&B DATA\",\"\")","v":"FIRST CALCULATE W&B DATA"}]
[null,null,"ICAO airport name"]
[null,null,"MSL Altitude [ft]",null,null,null,{"$f":"IF(E37=\"\",\"COMPLETE THE FORM\",\"AIRPORT ALTITUDE OK\")","v":"COMPLETE THE FORM"}]
[null,null,"QNH [hPa or mbar]",null,null,null,{"$f":"IF(E38=\"\",\"COMPLETE THE FORM\",IF(OR(E38<960,E38>1100),\"INVALID QNH\",\"QNH OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Pressure altitude [ft]",null,{"$f":"IF(OR(E37=\"\",E38=\"\"),\"COMPLETE THE FORM\",IF(E38>1013,(E37-(E38-1013)*30),(E37+(1013-E38)*30)))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E39=\"\",E39=\"COMPLETE THE FORM\"),\"COMPLETE THE FORM\",IF(E39>3000,\"LEANING OF MIXTURE IS RECOMMENDED\",\"LEANING OF MIXTURE NOT RECOMMENDED\"))","v":"COMPLETE THE FORM"}]
[null,null,"OAT Temperature [°C]",null,null,null,{"$f":"IF(E40=\"\",\"COMPLETE THE FORM\",IF(E40>=40,\"TEMPERATURE TOO HIGH\",\"TEMPERATURE OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Density altitude [ft]",null,{"$f":"IF(OR(E38=\"\",E37=\"\",E40=\"\"),\"COMPLETE THE FORM\",E39+120*(E40-(15-(1.98/1000*E39))))","v":"COMPLETE THE FORM"}]
[null,null,"Wind"]
[null,null,null,"Direction [°]",null,null,{"$f":"IF(E43=\"\",\"COMPLETE THE FORM\",IF(OR(E43<0,E43>359),\"INVALID WIND DIRECTION\",\"WIND DIRECTION OK\"))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E43=\"\",E44=\"\",E46=\"\"),\"COMPLETE THE FORM\",IF(E44<0,\"CHECK WIND VELOCITY\",IF(ABS(O107)>=15,\"CROSSWIND TOO STRONG\",IF(R106=\"USE OTHER RUNWAY DIRECTION\",\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",ROUND(ABS(O106),1)&\"kts \"&P106&\" AND \" & ROUND(ABS(O107),1)&\"kts \"&P107))))","v":"COMPLETE THE FORM"}]
[null,null,null,"Velocity [kts]",null,null,{"$f":"IF(E44=\"\",\"COMPLETE THE FORM\",IF(E44<0,\"INVALID WIND VELOCITY\",\"WIND VELOCITY OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Runway"]
[null,null,null,"Runway ",null,null,{"$f":"IF(E46=\"\",\"COMPLETE THE FORM\",IF(OR(E46<0,E46>35),\"INVALID QFU\",\"QFU OK\"))","v":"COMPLETE THE FORM"}]
[null,null,null,"type",1,null,{"$f":"IF(E47=\"\",\"\",IF(E47=1,\"DEFINE TYPE\",IF(E47=2,\"PAVED\",IF(E47=3,\"GRASS\"))))","v":"DEFINE TYPE"}]
[null,null,null,"LDA [m]",null,null,{"$f":"IF(E48=\"\",\"COMPLETE THE FORM\",IF(E48<0,\"INVALID RUNWAY LENGTH VALUE\",\"RUNWAY LENGTH VALUE OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Safety margin for landing distance",null,0.5]
[null,null,"Landing (flaps 40°, power off, maximum braking)"]
[null,null,null,"landing IAS speed [kts]",60]
[null,null,null,"ground roll [m]",{"$f":"IF(E39=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(R106=\"USE OTHER RUNWAY DIRECTION\",\"CHANGE RUNWAY\",IF(OR(E39>=8000,E40>=40),\"NO DATA AVAILABLE\",IF(G47=\"PAVED\",((1+R106)*P102*(1+E49))*0.3048,IF(G47=\"GRASS\",(((1+R106)*P102+(0.45*P102))*(1+E49))*0.3048,\"COMPLETE THE FORM\")))))","v":"COMPLETE THE FORM"}]
[null,null,null,"total to clear 50ft [m]",{"$f":"IF(E39=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(R106=\"USE OTHER RUNWAY DIRECTION\",\"CHANGE RUNWAY\",IF(OR(E39>=8000,E40>=40),\"NO DATA AVAILABLE\",IF(G47=\"PAVED\",((1+R106)*Q102*(1+E49))*0.3048,IF(G47=\"GRASS\",(((1+R106)*Q102+(0.45*P102))*(1+E49))*0.3048,\"COMPLETE THE FORM\")))))","v":"COMPLETE THE FORM"},null,{"$f":"IF(E39=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(OR(E39>=8000,E40>=40),\"NO DATA AVAILABLE, CHECK P.A. / TEMP\",IF(G47=\"DEFINE TYPE\",\"DEFINE TYPE OF RUNWAY\",IF(E48=\"\",\"COMPLETE THE FORM\",IF(E53=\"CHANGE RUNWAY\",\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",IF(E53>E48,\"RUNWAY TOO SHORT\",IF(E53<=E48,\"RUNWAY LENGTH SUFFICIENT\")))))))","v":"COMPLETE THE FORM"}]
[]
[null,"This document is provided for secondary flightplanning and navigation only. It is the user/pilot's sole responsibility to verify the correctness of all  information provided by this sheet. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Found & interpolated takeoff values (distances are in FEET) for safety weight of:",null,null,null,null,null,{"$f":"T20","v":"OVERWEIGHT"},"lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M25","v":0},null,{"$f":"P25","v":0},null,{"$f":"N25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GRND ROLL","TOTAL TO…","GRND ROLL","TOTAL TO…","GRND ROLL","TOTAL TO…"]
[null,null,null,null,null,null,null,null,null,null,null,null,"column index",{"$f":"2+(M25/10*2)","v":2},{"$f":"3+(M25/10*2)","v":3},null,null,{"$f":"2+(N25/10*2)","v":2},{"$f":"3+(N25/10*2)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M23","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M88,IF(S84=1900,'C172 Performance specs'!$F$7:$O$15,IF(S84=2100,'C172 Performance specs'!$E$16:$O$24,IF(S84=2300,'C172 Performance specs'!$E$25:$O$33))),'Performance FORM'!N$87,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M88,IF(S84=1900,'C172 Performance specs'!$F$7:$O$15,IF(S84=2100,'C172 Performance specs'!$E$16:$O$24,IF(S84=2300,'C172 Performance specs'!$E$25:$O$33))),'Performance FORM'!O$87,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M88,IF(S84=1900,'C172 Performance specs'!$F$7:$O$15,IF(S84=2100,'C172 Performance specs'!$E$16:$O$24,IF(S84=2300,'C172 Performance specs'!$E$25:$O$33))),'Performance FORM'!R$87,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M88,IF(S84=1900,'C172 Performance specs'!$F$7:$O$15,IF(S84=2100,'C172 Performance specs'!$E$16:$O$24,IF(S84=2300,'C172 Performance specs'!$E$25:$O$33))),'Performance FORM'!S$87,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P23","v":"COMPLETE THE FORM"},{"$f":"IF(P23<=0,N88,N88+((N90-N88)*(($M$89-$M$88)/($M$90-$M$88))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P23<=0,O88,O88+((O90-O88)*(($M$89-$M$88)/($M$90-$M$88))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P25<=0,N89,N89+((R89-N89)*((($P$85-$N$85)/($R$85-$N$85)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P25<=0,O89,O89+((S89-O89)*((($P$85-$N$85)/($R$85-$N$85)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P23<=0,R88,R88+((R90-R88)*(($M$89-$M$88)/($M$90-$M$88))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P23<=0,S88,S88+((S90-S88)*(($M$89-$M$88)/($M$90-$M$88))))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N23","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M90,IF(S84=1900,'C172 Performance specs'!$F$7:$O$15,IF(S84=2100,'C172 Performance specs'!$E$16:$O$24,IF(S84=2300,'C172 Performance specs'!$E$25:$O$33))),'Performance FORM'!N$87,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M90,IF(S84=1900,'C172 Performance specs'!$F$7:$O$15,IF(S84=2100,'C172 Performance specs'!$E$16:$O$24,IF(S84=2300,'C172 Performance specs'!$E$25:$O$33))),'Performance FORM'!O$87,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M90,IF(S84=1900,'C172 Performance specs'!$F$7:$O$15,IF(S84=2100,'C172 Performance specs'!$E$16:$O$24,IF(S84=2300,'C172 Performance specs'!$E$25:$O$33))),'Performance FORM'!R$87,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M90,IF(S84=1900,'C172 Performance specs'!$F$7:$O$15,IF(S84=2100,'C172 Performance specs'!$E$16:$O$24,IF(S84=2300,'C172 Performance specs'!$E$25:$O$33))),'Performance FORM'!S$87,FALSE)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Landing calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"look between PA [ft]",null,null,"needed value [ft]"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E39<=0,0,LEFT(E39/1000,1)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(E39<=0,0,LEFT(E39/1000+1,1)*1000)","v":{"$error":"#VALUE!"}},null,{"$f":"E39","v":"COMPLETE THE FORM"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"look between temperatures [°C]",null,null,"needed value [°C]"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E40<=0,0,LEFT(E40/10,1)*10)","v":0},{"$f":"IF(E40<=0,0,LEFT(E40/10+1,1)*10)","v":0},null,{"$f":"E40","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Found & interpolated landing values (distances are in FEET)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M96","v":0},null,{"$f":"P96","v":0},null,{"$f":"N96","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GRND ROLL","TOTAL TO…","GRND ROLL","TOTAL TO…","GRND ROLL","TOTAL TO…"]
[null,null,null,null,null,null,null,null,null,null,null,null,"column index",{"$f":"2+(M96/10*2)","v":2},{"$f":"3+(M96/10*2)","v":3},null,null,{"$f":"2+(N96/10*2)","v":2},{"$f":"3+(N96/10*2)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M94","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M101,'C172 Performance specs'!$E$44:$O$52,'Performance FORM'!N$100,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M101,'C172 Performance specs'!$E$44:$O$52,'Performance FORM'!O$100,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M101,'C172 Performance specs'!$E$44:$O$52,'Performance FORM'!R$100,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M101,'C172 Performance specs'!$E$44:$O$52,'Performance FORM'!S$100,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P94","v":"COMPLETE THE FORM"},{"$f":"IF($P$94<=0,N101,N101+((N103-N101)*(($M$102-$M$101)/($M$103-$M$101))))","v":{"$error":"#VALUE!"}},{"$f":"IF($P$94<=0,O101,O101+((O103-O101)*(($M$102-$M$101)/($M$103-$M$101))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P96<=0,N102,N102+((R102-N102)*((($P$98-$N$98)/($R$98-$N$98)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P96<=0,O102,O102+((S102-O102)*((($P$98-$N$98)/($R$98-$N$98)))))","v":{"$error":"#VALUE!"}},{"$f":"IF($P$94<=0,R101,R101+((R103-R101)*(($M$102-$M$101)/($M$103-$M$101))))","v":{"$error":"#VALUE!"}},{"$f":"IF($P$94<=0,S101,S101+((S103-S101)*(($M$102-$M$101)/($M$103-$M$101))))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N94","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M103,'C172 Performance specs'!$E$44:$O$52,'Performance FORM'!N$100,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M103,'C172 Performance specs'!$E$44:$O$52,'Performance FORM'!O$100,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M103,'C172 Performance specs'!$E$44:$O$52,'Performance FORM'!R$100,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M103,'C172 Performance specs'!$E$44:$O$52,'Performance FORM'!S$100,FALSE)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Landing wind calculations",null,null,null,null,"change in landing distance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"headwind component [kts]",null,{"$f":"E44*COS((ABS((E46*10)-E43)*PI()/180))","v":0},{"$f":"IF(O106>=0,\"HEADWIND\",IF(O106<0,\"TAILWIND\",\"\"))","v":"HEADWIND"},null,{"$f":"IF(O106>=0,O106/9*-0.1,IF(AND(O106<0,O106>=-10),ABS(O106/2*0.1),\"USE OTHER RUNWAY DIRECTION\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"crosswind component [kts]",null,{"$f":"E44*SIN((ABS((E46*10)-E43)*PI()/180))","v":0},"CROSSWIND"]

{"sheet":"C172 Performance specs","index":3,"n_rows":97,"n_cols":15,"rows_kept":97,"cut":false,"hidden":false,"merged":[[61,3,61,5],[61,6,61,8],[61,9,61,11],[61,1,62,1],[61,2,62,2],[1,1,1,11],[4,1,5,1],[4,2,4,3],[2,1,2,11],[4,4,5,4],[4,7,4,8],[4,9,4,10],[4,11,4,12],[41,1,42,1],[41,4,42,4],[41,2,42,3],[41,5,41,6],[4,5,4,6],[43,2,43,3],[4,13,4,14],[41,7,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,14]]}
[]
[null,"DATA C172*"]
[null,"* ALL DATA IS BASED ON THE CESSNA SKYHAWK 1976 MODEL 172M"]
[null,"Takeoff distance","(flaps up, full throttle prior to brake release, paved, level, dry runway, zero wind)",null,null,null,null,null,null,null,null,null,null,null,"DATA FOUND ON PAGE 5-12, 5-13"]
[null,"Weight (lbs)","Takeoff speed (KIAS)",null,"Pressure altitude (ft)","0°C",null,"10°C",null,"20°C",null,"30°C",null,"40°C"]
[null,null,"Lift off","at 50ft",null,"Grnd roll","tot to clear 50ft obs","Grnd roll","tot to clear 50ft obs","Grnd roll","tot to clear 50ft obs","Grnd roll","tot to clear 50ft obs","Grnd roll","tot to clear 50ft obs"]
[null,1900,47,54,0,505,915,540,975,580,1035,620,1105,665,1175]
[null,null,null,null,1000,550,995,590,1060,635,1130,680,1205,725,1280]
[null,null,null,null,2000,600,1085,645,1155,695,1230,745,1315,795,1400]
[null,null,null,null,3000,660,1180,710,1260,760,1345,815,1435,870,1530]
[null,null,null,null,4000,725,1290,775,1380,835,1475,895,1575,955,1680]
[null,null,null,null,5000,795,1415,855,1515,915,1620,985,1735,1055,1850]
[null,null,null,null,6000,870,1555,940,1670,1010,1785,1080,1910,1160,2045]
[null,null,null,null,7000,960,1715,1035,1840,1110,1975,1195,2115,1280,2265]
[null,null,null,null,8000,1060,1900,1140,2040,1225,2190,1320,2350,1415,2520]
[null,2100,50,56,0,630,1130,680,1210,725,1290,780,1375,835,1465]
[null,null,null,null,1000,690,1235,740,1320,795,1405,855,1500,915,1600]
[null,null,null,null,2000,755,1350,810,1440,870,1540,935,1645,1000,1755]
[null,null,null,null,3000,830,1475,890,1580,955,1690,1025,1805,1100,1930]
[null,null,null,null,4000,910,1620,980,1735,1050,1860,1125,1990,1210,2130]
[null,null,null,null,5000,1000,1780,1075,1910,1155,2050,1240,2195,1330,2355]
[null,null,null,null,6000,1100,1965,1185,2115,1275,2270,1370,2435,1465,2615]
[null,null,null,null,7000,1215,2180,1305,2345,1405,2520,1510,2715,1620,2920]
[null,null,null,null,8000,1340,2425,1445,2615,1555,2815,1675,3040,1795,3280]
[null,2300,52,59,0,775,1380,835,1475,895,1575,960,1685,1030,1795]
[null,null,null,null,1000,850,1510,915,1615,980,1725,1050,1845,1125,1970]
[null,null,null,null,2000,930,1650,1000,1770,1075,1895,1155,2030,1235,2170]
[null,null,null,null,3000,1020,1815,1100,1945,1180,2085,1270,2235,1360,2395]
[null,null,null,null,4000,1125,2000,1210,2145,1300,2305,1395,2475,1495,2655]
[null,null,null,null,5000,1235,2210,1330,2375,1430,2555,1540,2750,1650,2960]
[null,null,null,null,6000,1365,2450,1470,2640,1580,2850,1700,3070,"N/A","N/A"]
[null,null,null,null,7000,1505,2730,1625,2955,1750,3190,"N/A","N/A","N/A","N/A"]
[null,null,null,null,8000,1665,3065,1800,3320,"N/A","N/A","N/A","N/A","N/A","N/A"]
[]
[null,"Remarks"]
[null,1,"Prior to takeoff from fields above 3000 ft elevation, the mixture should be leaned to give maximum RPM in a full throttle static runup"]
[null,2,"Decrease distances by 10% for each 9kts headwind. For operation with tailwinds up to 10kts, increase distances by 10% for each 2 knots"]
[null,3,"Where distance value has been deleted, climb performance after lift-off is less than 150fpm at takeoff speed"]
[null,4,"For operation on a dry, grass runway, increase distances by 15% of the \"ground roll\" figure"]
[]
[null,"Landing distance","(flaps 40°, power off, maximum braking, paved, level, dry runway, zero wind)",null,null,null,null,null,null,null,null,null,null,null,"DATA FOUND ON PAGE 5-21"]
[null,"Weight (lbs)","speed at 50 ft (KIAS)",null,"Pressure altitude (ft)","0°C",null,"10°C",null,"20°C",null,"30°C",null,"40°C"]
[null,null,null,null,null,"Grnd roll","tot to clear 50ft obs","Grnd roll","tot to clear 50ft obs","Grnd roll","tot to clear 50ft obs","Grnd roll","tot to clear 50ft obs","Grnd roll","tot to clear 50ft obs"]
[null,2300,60,null,0,495,1205,510,1235,530,1265,545,1295,565,1330]
[null,null,null,null,1000,510,1235,530,1265,550,1300,565,1330,585,1365]
[null,null,null,null,2000,530,1265,550,1300,570,1335,590,1370,610,1405]
[null,null,null,null,3000,550,1300,570,1335,590,1370,610,1405,630,1440]
[null,null,null,null,4000,570,1335,590,1370,615,1410,635,1445,655,1480]
[null,null,null,null,5000,590,1370,615,1415,635,1450,655,1485,680,1525]
[null,null,null,null,6000,615,1415,640,1455,660,1490,685,1535,705,1570]
[null,null,null,null,7000,640,1455,660,1495,685,1535,710,1575,730,1615]
[null,null,null,null,8000,665,1500,690,1540,710,1580,735,1620,760,1665]
[]
[null,"Remarks"]
[null,1,"Decrease distances 10% for each 9kts headwind. For operations  with tailwind up to 10kts, increase distances by 10% for each 2 kts"]
[null,2,"For operation on a dry, grass runway, increase distances by 45% of the \"ground roll\" figure"]
[]
[null,"Fuel for engine start, taxi and takeoff allowance",null,null,null,1.1000000000000001,"US Gal",null,null,null,null,null,null,null,"DATA FOUND ON PAGE 5-15"]
[]
[null,"Cruise performance ","(recommended  lean mixture, 2300 lbs)",null,null,null,null,null,null,null,null,null,null,null,"DATA FOUND ON PAGE 5-16"]
[]
[null,"pressure altitude (ft)","RPM","20°C below standard temp",null,null,"standard temperature",null,null,"20°C above standard temp"]
[null,null,null,"%BHP","KTAS","GPH","%BHP","KTAS","GPH","%BHP","KTAS","GPH"]
[null,2000,2550,80,114,8.8000000000000007,75,113,8.1999999999999993,71,113,7.8]
[null,null,2500,76,111,8.3000000000000007,71,111,7.8,67,111,7.5]
[null,null,2400,68,107,7.5,64,107,7.2,61,106,6.9]
[null,null,2300,61,102,6.9,58,101,6.7,55,99,6.5]
[null,null,2200,55,96,6.4,52,95,6.2,49,93,6.1]
[null,4000,2600,80,116,8.8000000000000007,75,116,8.3000000000000007,71,116,7.8]
[null,null,2500,72,111,7.9,68,111,7.5,64,110,7.2]
[null,null,2400,65,107,7.3,61,106,6.9,58,104,6.7]
[null,null,2300,58,101,6.7,55,100,6.5,53,98,6.3]
[null,null,2200,52,95,6.3,49,93,6.1,47,92,5.9]
[null,6000,2650,80,118,8.8000000000000007,75,118,8.1999999999999993,71,118,7.8]
[null,null,2600,76,116,8.3000000000000007,71,116,7.9,68,115,7.5]
[null,null,2500,69,111,7.6,65,110,7.2,62,109,7]
[null,null,2400,62,106,7,59,104,6.7,56,103,6.5]
[null,null,2300,56,100,6.5,53,98,6.3,50,97,6.1]
[null,null,2200,50,94,6.1,47,92,5.9,45,91,5.8]
[null,8000,2700,80,120,8.8000000000000007,75,120,8.3000000000000007,71,120,7.8]
[null,null,2600,72,116,8,68,115,7.5,65,114,7.3]
[null,null,2500,65,111,7.3,62,109,7,59,108,6.8]
[null,null,2400,59,105,6.8,56,103,6.6,53,101,6.3]
[null,null,2300,54,99,6.4,51,97,6.2,48,96,6]
[null,null,2200,48,93,6,45,91,5.8,43,90,5.7]
[null,10000,2700,76,120,8.4,72,120,7.9,68,119,7.8]
[null,null,2600,69,115,7.6,65,114,7.3,62,112,7]
[null,null,2500,63,110,7.1,59,108,6.8,56,106,6.6]
[null,null,2400,57,104,6.6,54,102,6.4,51,100,6.2]
[null,null,2300,51,97,6.2,48,96,6,46,95,5.8]
[null,null,2200,46,92,5.8,43,90,5.7,41,89,5.5]
[null,12000,2650,69,117,7.6,65,116,7.3,62,114,7]
[null,null,2600,66,114,7.4,62,113,7,59,111,6.8]
[null,null,2500,60,108,6.8,57,106,6.6,54,105,6.4]
[null,null,2400,54,102,6.4,51,100,6.2,49,99,6]
[null,null,2300,49,96,6,46,95,5.9,43,94,5.7]
[null,null,2200,44,91,5.7,41,89,5.5,38,88,5.3]

{"sheet":"OO-AWT","index":4,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,1,2,5],[22,1,22,2]]}
[]
[null,"DATA OO-AWT"]
[null,"LONG-RANGE FUEL TANKS"]
[null,"Max usable fuel quantity",48,"US Gal",{"$f":"C4*3.785412","v":181.69977599999999},"l"]
[null,"Unusable fuel",24,"lbs"]
[null,"Max. Fuel flow",{"$f":"MAX('C172 Performance specs'!F64:F97,'C172 Performance specs'!I64:I97,'C172 Performance specs'!L64:L96,'C172 Performance specs'!L96,'C172 Performance specs'!L96:L97)","v":8.8000000000000007},"US Gal/hr",{"$f":"C6*3.785412","v":33.311625599999999},"l/u"]
[null,"Max. endurance:",{"$f":"E4/E6","v":5.4545454545454541},"uur",{"$f":"INT(C7)&\":\"&ROUND((C7-INT(C7))*60,0)","v":"5:27"}]
[]
[null,"W&B DATA",null,null,null,null,null,"BASED ON"]
[null,"Empty Weight",1494.68,"lbs",{"$f":"C10*0.45359","v":677.97190120000005},"kg"]
[null,"Arm",39.287999999999997,"inches"]
[null,"Moment ",58722.835400000004,"inch.lbs"]
[]
[null,"Max Useful load"]
[null,"normal category",805.32,"lbs",{"$f":"C15*0.45359","v":365.28509880000001},"kg"]
[null,"utility category",505.32,"lbs",{"$f":"C16*0.45359","v":229.20809879999999},"kg"]
[]
[null,"Max weight baggage areas"]
[null,"area1",120,"lbs",{"$f":"C19*0.45359","v":54.430799999999998},"kg"]
[null,"area2",50,"lbs",22.679500000000001,"kg"]
[]
[null,"W&B Center of Gravity limits graph"]
[null,"NORMAL CATEGORY",null,"UTILITY CATEGORY"]
[null,"arm [inches]","weight [lbs]","arm [inches]","weight [lbs]"]
[null,35,0,35,0]
[null,35,1950,35,1950]
[null,35.5,2000,35.5,2000]
[null,38.5,2300,40.5,2000]
[null,47.3,2300,40.5,0]
[null,47.3,0]