{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","W&B FORM","Performance FORM","C172SP Performance specs","OO-VCK"],"not_rendered":{"charts":2,"images":2,"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,10,1],[16,0,16,5],[17,0,17,7]]}
[]
[]
[]
[]
["remarks? tony.opsomer@gmail.com",null,null,null,"version 2022-03-16"]
[]
[null,"C172SP","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 2022-03-16"}]
[null,"Weight and Balance form C172SP OO-VCK",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]","[m]","[m.kg]",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-VCK'!C10","v":780},{"$f":"'OO-VCK'!C11","v":1.01},{"$f":"'OO-VCK'!C12","v":787.1}]
[null,"Usable fuel ",null,"mean arm:",48,"in",null,0,{"$f":"H8*0.72","v":0},{"$f":"E8*0.0254","v":1.2191999999999998},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",I8*J8)","v":0},null,{"$f":"IF(H8=\"\",\"COMPLETE THE FORM\",IF(H8>'OO-VCK'!E4,\"FUEL TANK OVERFLOW\",\"FUEL QUANTITY WITHIN LIMIT\"))","v":"FUEL QUANTITY WITHIN LIMIT"},null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\"),\"COMPLETE THE FORM\",IF(SUM(I7:I14)>'OO-VCK'!C15,\"TOO MUCH USEFUL LOAD\",IF(SUM(I7:I14)>'OO-VCK'!C16,\"TOTAL USEFUL LOAD WITHIN LIMIT\",\"TOTAL USEFUL LOAD WITHIN LIMIT\")))","v":"TOTAL USEFUL LOAD WITHIN LIMIT"}]
[null,"Pilot",null,"mean arm:",37,"in",null,null,0,{"$f":"E9*0.0254","v":0.93979999999999997},{"$f":"I9*J9","v":0}]
[null,"Front passenger",null,"mean arm:",37,"in",null,null,0,{"$f":"E10*0.0254","v":0.93979999999999997},0]
[null,"Rear passenger 1",null,"mean arm:",73,"in",null,null,0,1.8541999999999998,0]
[null,"Rear passenger 2",null,"mean arm:",73,"in",null,null,0,1.8541999999999998,0]
[null,"Baggage area 1",null,"mean arm:",95,"in",null,null,0,2.4129999999999998,0,null,{"$f":"IF(OR(I13=\"\",I14=\"\"),\"COMPLETE THE FORM\",IF(I13>'OO-VCK'!E19,\"TOO MUCH BAGGAGE IN AREA 1\",IF(I14>'OO-VCK'!E20,\"TOO MUCH BAGGAGE IN AREA 2\",IF(SUM(I13:I14)>'OO-VCK'!E19,\"TOO MUCH BAGGAGE IN AREA 1 AND 2\",\"PARTITIONING OF BAGGAGE IN AREAS 1 AND 2 WITHIN LIMITS\"))))","v":"PARTITIONING OF BAGGAGE IN AREAS 1 AND 2 WITHIN LIMITS"}]
[null,"Baggage area 2",null,"mean arm:",123,"in",null,null,0,3.1242000000000001,0]
[null,"RAMP WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\"),\"COMPLETE THE FORM\",SUM(I7:I14))","v":780},{"$f":"IF(I15=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",K15/I15)","v":1.0091025641025642},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\"),\"COMPLETE THE FORM\",SUM(K7:K14))","v":787.1},null,{"$f":"IF(I15=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",\"CHECK RESULTS IN GRAPH BELOW\")","v":"CHECK RESULTS IN GRAPH BELOW"}]
[null,"Fuel allowance for engine start, taxi and runup",null,null,null,null,null,{"$f":"'C172SP Performance specs'!F60*3.785412","v":5.2995767999999996},{"$f":"H16*0.72","v":3.8156952959999995},{"$f":"E8*0.0254","v":1.2191999999999998},{"$f":"I16*J16","v":4.652095704883199}]
[null,"TAKE-OFF WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\",H16=\"\"),\"COMPLETE THE FORM\",I15-I16)","v":776.18430470400006},{"$f":"IF(I17=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",K17/I17)","v":1.0080697323472747},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",I14=\"\",H16=\"\"),\"COMPLETE THE FORM\",K15-K16)","v":782.44790429511681},null,{"$f":"IF(I17=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",\"CHECK RESULTS IN GRAPH BELOW\")","v":"CHECK RESULTS IN GRAPH BELOW"}]
[null,"Total trip time",null,null,null,"hh:mm",null,{"$f":"(HOUR(E18)*60+MINUTE(E18))/60*'OO-VCK'!E6","v":0},{"$f":"H18*0.72","v":0},{"$f":"E8*0.0254","v":1.2191999999999998},{"$f":"I18*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-VCK'!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,null,{"$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/I19))","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 2022-03-16"}]
[null,null,"Performance form C172 OO-VCK",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":776.18430470400006},null,{"$f":"IF(E5=\"FIRST CALCULATE W&B\",\"FIRST CALCULATE W&B DATA\",\"\")","v":""}]
[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 10°, 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":1711.1937703894469},"lbs","-> taking this (higher) weight from takeoff data:",null,null,null,{"$f":"IF(N20<=2200,2200,IF(N20<=2400,2400,IF(N20<=2550,2550,IF(N20>2550,\"OVERWEIGHT\"))))","v":2200},"lbs",null,"corresponding speeds"]
[null,null,null,"lift off IAS speed [kts]",{"$f":"IF(ISERROR(Y21),\"COMPLETE THE FORM\",Y21)","v":44},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lift off",{"$f":"VLOOKUP($T$20,'C172SP Performance specs'!B7:D33,2,FALSE)","v":44}]
[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,'C172SP 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":776.18430470400006},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,null,null,null,null,{"$f":"M25","v":0},null,{"$f":"N25","v":0}]
[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]",61]
[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":2200},"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=2200,'C172SP Performance specs'!$F$7:$O$15,IF(S84=2400,'C172SP Performance specs'!$E$16:$O$24,IF(S84=2550,'C172SP Performance specs'!$E$25:$O$33))),'Performance FORM'!N$87,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M88,IF(S84=2200,'C172SP Performance specs'!$F$7:$O$15,IF(S84=2400,'C172SP Performance specs'!$E$16:$O$24,IF(S84=2550,'C172SP Performance specs'!$E$25:$O$33))),'Performance FORM'!O$87,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M88,IF(S84=2200,'C172SP Performance specs'!$F$7:$O$15,IF(S84=2400,'C172SP Performance specs'!$E$16:$O$24,IF(S84=2550,'C172SP Performance specs'!$E$25:$O$33))),'Performance FORM'!R$87,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M88,IF(S84=2200,'C172SP Performance specs'!$F$7:$O$15,IF(S84=2400,'C172SP Performance specs'!$E$16:$O$24,IF(S84=2550,'C172SP 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=2200,'C172SP Performance specs'!$F$7:$O$15,IF(S84=2400,'C172SP Performance specs'!$E$16:$O$24,IF(S84=2550,'C172SP Performance specs'!$E$25:$O$33))),'Performance FORM'!N$87,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M90,IF(S84=2200,'C172SP Performance specs'!$F$7:$O$15,IF(S84=2400,'C172SP Performance specs'!$E$16:$O$24,IF(S84=2550,'C172SP Performance specs'!$E$25:$O$33))),'Performance FORM'!O$87,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M90,IF(S84=2200,'C172SP Performance specs'!$F$7:$O$15,IF(S84=2400,'C172SP Performance specs'!$E$16:$O$24,IF(S84=2550,'C172SP Performance specs'!$E$25:$O$33))),'Performance FORM'!R$87,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M90,IF(S84=2200,'C172SP Performance specs'!$F$7:$O$15,IF(S84=2400,'C172SP Performance specs'!$E$16:$O$24,IF(S84=2550,'C172SP 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,'C172SP Performance specs'!$E$44:$O$52,'Performance FORM'!N$100,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M101,'C172SP Performance specs'!$E$44:$O$52,'Performance FORM'!O$100,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M101,'C172SP Performance specs'!$E$44:$O$52,'Performance FORM'!R$100,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M101,'C172SP 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,'C172SP Performance specs'!$E$44:$O$52,'Performance FORM'!N$100,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M103,'C172SP Performance specs'!$E$44:$O$52,'Performance FORM'!O$100,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M103,'C172SP Performance specs'!$E$44:$O$52,'Performance FORM'!R$100,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M103,'C172SP 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":"C172SP Performance specs","index":3,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":false,"merged":[[63,3,63,5],[63,6,63,8],[63,9,63,11],[63,1,64,1],[63,2,64,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 C172SP*"]
[null,"* ALL DATA IS BASED ON THE CESSNA SKYHAWK SP MODEL 172S NAV III"]
[null,"Takeoff distance","(flaps 10°, 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-14, 5-15, 5-16"]
[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,2200,44,50,0,610,1055,655,1130,705,1205,760,1290,815,1380]
[null,null,null,null,1000,665,1145,720,1230,770,1315,830,1410,890,1505]
[null,null,null,null,2000,725,1250,785,1340,845,1435,905,1540,975,1650]
[null,null,null,null,3000,795,1365,860,1465,925,1570,995,1685,1065,1805]
[null,null,null,null,4000,870,1490,940,1605,1010,1725,1090,1855,1165,1975]
[null,null,null,null,5000,955,1635,1030,1765,1110,1900,1195,2035,1275,2175]
[null,null,null,null,6000,1050,1800,1130,1940,1220,2090,1310,2240,1400,2395]
[null,null,null,null,7000,1150,1985,1245,2145,1340,2305,1435,2475,1540,2650]
[null,null,null,null,8000,1270,2195,1370,2375,1475,2555,1580,2745,1695,2950]
[null,2400,48,54,0,745,1275,800,1370,860,1470,925,1570,995,1685]
[null,null,null,null,1000,810,1390,875,1495,940,1605,1010,1720,1085,1845]
[null,null,null,null,2000,885,1520,955,1635,1030,1760,1110,1890,1190,2030]
[null,null,null,null,3000,970,1665,1050,1795,1130,1930,1215,2080,1305,2230]
[null,null,null,null,4000,1065,1830,1150,1975,1240,2130,1335,2295,1430,2455]
[null,null,null,null,5000,1170,2015,1265,2180,1360,2355,1465,2530,1570,2715]
[null,null,null,null,6000,1285,2230,1390,2410,1500,2610,1610,2805,1725,3015]
[null,null,null,null,7000,1415,2470,1530,2685,1650,2900,1770,3125,1900,3370]
[null,null,null,null,8000,1560,2755,1690,3000,1815,3240,1950,3500,2095,3790]
[null,2550,51,56,0,860,1465,925,1575,995,1690,1070,1810,1150,1945]
[null,null,null,null,1000,940,1600,1010,1720,1090,1850,1170,1990,1260,2135]
[null,null,null,null,2000,1025,1755,1110,1890,1195,2035,1285,2190,1380,2355]
[null,null,null,null,3000,1125,1925,1215,2080,1310,2240,1410,2420,1515,2605]
[null,null,null,null,4000,1235,2120,1335,2295,1440,2480,1550,2685,1660,2880]
[null,null,null,null,5000,1355,2345,1465,2545,1585,2755,1705,2975,1825,3205]
[null,null,null,null,6000,1495,2605,1615,2830,1745,3075,1875,3320,2010,3585]
[null,null,null,null,7000,1645,2910,1785,3170,1920,3440,2065,3730,2215,4045]
[null,null,null,null,8000,1820,3265,1970,3575,2120,3880,2280,4225,2450,4615]
[]
[null,"Remarks"]
[null,1,"Short field technique as specified in section 4"]
[null,2,"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,3,"Decrease distances by 10% for each 9kts headwind. For operation with tailwinds up to 10kts, increase distances by 10% for each 2 knots"]
[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-23/5-24"]
[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,2550,61,null,0,545,1290,565,1320,585,1350,605,1380,625,1415]
[null,null,null,null,1000,565,1320,585,1350,605,1385,625,1420,650,1450]
[null,null,null,null,2000,585,1355,610,1385,630,1420,650,1455,670,1490]
[null,null,null,null,3000,610,1385,630,1425,655,1460,675,1495,695,1530]
[null,null,null,null,4000,630,1425,655,1460,675,1495,700,1535,725,1570]
[null,null,null,null,5000,655,1460,680,1500,705,1535,725,1575,750,1615]
[null,null,null,null,6000,680,1500,705,1540,730,1580,755,1620,780,1660]
[null,null,null,null,7000,705,1545,730,1585,760,1625,785,1665,810,1705]
[null,null,null,null,8000,735,1585,760,1630,790,1670,815,1715,840,1755]
[]
[null,"Remarks"]
[null,1,"Short field technique as specified in section 4"]
[null,2,"Decrease distances 10% for each 9kts headwind. For operations  with tailwind up to 10kts, increase distances by 10% for each 2 kts"]
[null,3,"For operation on a dry, grass runway, increase distances by 45% of the \"ground roll\" figure"]
[null,4,"If landing with flaps up, increase the approach speed by 9 KIAS and allow for 35% longer distances"]
[]
[null,"Fuel for engine start, taxi and takeoff allowance",null,null,null,1.4,"US Gal",null,null,null,null,null,null,null,"DATA FOUND ON PAGE 5-18"]

{"sheet":"OO-VCK","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,5],[22,1,22,2],[30,3,30,4],[18,6,19,7]]}
[]
[null,"DATA OO-VCK"]
[null,"LONG-RANGE FUEL TANKS"]
[null,"Max usable fuel quantity",53,"US Gal",{"$f":"C4*3.785412","v":200.626836},"l"]
[null,"Unusable fuel",3,"US Gal",{"$f":"C5*3.785412","v":11.356235999999999},"l"]
[null,"Max. Fuel flow",11.1,"US Gal/hr",{"$f":"C6*3.785412","v":42.018073199999996},"l/u"]
[null,"Max. endurance:",{"$f":"E4/E6","v":4.7747747747747749},"uur",{"$f":"INT(C7)&\":\"&ROUND((C7-INT(C7))*60,0)","v":"4:46"}]
[]
[null,"W&B DATA",null,null,null,null,null,"BASED ON"]
[null,"Empty Weight",780,"kg",{"$f":"C10/0.45359","v":1719.6146299521595},"lbs"]
[null,"Arm",1.01,"m"]
[null,"Moment ",787.1,"m.kg"]
[]
[null,"Max weight"]
[null,"normal category",1156,"kg",{"$f":"C15/0.45359","v":2548.5570669547387},"lbs"]
[null,"utility category",997,"kg",{"$f":"C16/0.45359","v":2198.0202385414141},"lbs"]
[]
[null,"Max weight baggage areas"]
[null,"area1",120,"lbs",{"$f":"C19*0.45359","v":54.430799999999998},"kg","max 120 lbs in area 1 AND area 2"]
[null,"area2",50,"lbs",22.679500000000001,"kg"]
[]
[null,"W&B Center of Gravity limits graph"]
[null,"NORMAL CATEGORY",null,"UTILITY CATEGORY"]
[null,"arm [m]","weight [kg]","arm [m]","weight [kg]"]
[null,0.95,0,0.95,0]
[null,0.95,997,0.95,997]
[null,1.04,1156,1.03,997]
[null,1.2,1156,1.03,997]
[null,1.2,1156,1.03,0]
[null,1.2,0]
[null,null,null,"in  utility category the rear seat must not be occupied and the baggage compartment must be empty"]