{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Flight log FORM","Performance FORM","W&B FORM","Aquila performance specs"],"not_rendered":{"charts":11,"images":8,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,0,3,7],[5,1,7,1],[10,0,10,7],[11,0,11,7]]}
[]
["remarks? tony.opsomer@gmail.com",null,null,null,null,null,null,"version 2023-07-15"]
[]
["D-EVIE | Aquila A210"]
[]
[null,"A210","Flight log form"]
[null,null,"Performance form"]
[null,null,"Weight and balance form"]
[]
[]
["Vliegclub Grimbergen BE.DTO.113"]
["download the latest version from https://goahead.classy.be/weight-balance/ "]

{"sheet":"Flight log FORM","index":1,"n_rows":68,"n_cols":58,"rows_kept":68,"cut":false,"hidden":false,"merged":[[52,5,52,6],[43,9,43,12],[39,4,39,5],[40,4,40,5],[38,4,38,5],[38,6,38,7],[43,5,43,7],[50,5,50,8],[16,2,16,3],[16,8,18,8],[16,5,18,5],[21,6,22,6],[33,6,34,6],[39,2,39,3],[29,7,30,7],[27,7,28,7],[35,6,36,6],[1,1,1,3],[12,2,12,3],[16,1,18,1],[14,2,14,3],[3,1,3,3],[16,4,18,4],[9,4,10,4],[3,4,3,7],[44,5,44,7],[1,29,3,34],[33,9,34,9],[55,43,55,44],[55,41,55,42],[55,33,55,34],[54,38,54,45],[55,14,56,23],[55,35,55,36],[54,30,54,37],[55,1,56,12],[2,20,10,23],[3,15,3,19],[4,15,4,19],[5,15,6,19],[23,7,24,7],[25,7,26,7],[21,7,22,7],[9,10,10,10],[16,23,18,23],[16,20,18,20],[35,9,36,9],[31,9,32,9],[21,9,22,9],[35,29,36,31],[53,20,53,23],[53,5,53,6],[23,29,23,33],[27,9,28,9],[35,7,36,7],[23,6,24,6],[25,6,26,6],[35,45,35,56],[35,32,35,43],[46,5,46,7],[47,5,47,7],[48,5,48,7],[40,6,40,7],[42,5,42,12],[37,4,37,5],[37,6,37,7],[39,6,39,7],[28,14,28,16],[31,6,32,6],[29,6,30,6],[27,6,28,6],[45,5,45,7],[49,5,49,8],[51,9,53,12],[6,29,6,30],[12,14,12,18],[25,9,26,9],[5,14,6,14],[16,9,18,9],[16,10,18,10],[16,11,18,12],[37,2,37,3],[42,1,42,3],[14,4,14,5],[19,6,20,6],[8,5,8,6],[8,8,8,9],[8,2,8,3],[8,1,10,1],[12,8,12,9],[16,6,18,6],[16,7,18,7],[0,20,0,23],[14,11,14,12],[33,7,34,7],[29,9,30,9],[31,7,32,7],[19,7,20,7],[12,20,12,23],[23,9,24,9],[19,9,20,9],[16,21,18,21],[16,22,18,22],[14,9,14,10],[3,9,3,12],[8,15,10,16],[8,17,10,19],[4,6,4,7],[5,6,5,7],[14,6,14,8],[6,6,6,7],[8,11,8,12],[0,10,0,12]]}
[]
[null,"VFR FLIGHT LOG | VCG BE.DTO.113",null,null,"D-EVIE","FLIGHT TYPE","VCG PILOT N°:",null,"TEMP",null,"FUEL TANK",{"$f":"IF(E2=1,\"\",AJ40)","v":109.6},{"$f":"IF(L2=\"\",\"\",ROUND(L2/3.785412,2))","v":28.95},null,"To be completed by a VCG flight instructor (FI) in case of student flight",null,null,null,null,null,"Notes",null,null,null,null,null,null,null,null,"Calculations"]
[null,null,null,null,1,1,"DATE:",{"$f":"TODAY()","v":"2023-07-15"},"TAS",107,"Consumption",{"$f":"MAX('Aquila performance specs'!I6:I12)","v":22},{"$f":"ROUND(L3/3.785412,2)","v":5.81},null,"Date of Flight"]
[null,{"$f":"Introduction!A2&\" | \"&Introduction!H2","v":"remarks? tony.opsomer@gmail.com | version 2023-07-15"},null,null,{"$f":"IF(AND(E3=2,LEFT(B6,2)<>LEFT(B7,2),B7<>\"\"),\"DON'T FORGET TO FILE A FLIGHTPLAN AND REGISTER THE FLIGHT BEFORE TAKEOFF!\",IF(AND(OR(E3=3,E3=2),LEFT(B6,2)=LEFT(B7,2)),\"DON'T FORGET TO REGISTER THE FLIGHT BEFORE TAKEOFF!\",\"\"))","v":""},null,null,null,"Pilot Name",null,null,null,null,null,"Name and signature\nof student pilot"]
[null,"Airfield","Gnd\nfreq","Twr / Rad freq","ATIS\nfreq","Elev","QNH",null,"W","V","RWY","Preferred RWY","RWY length",null,"Name of FI"]
[null,null,null,{"$f":"IF(B6=\"EBGB\",119.505,\"\")","v":""},null,{"$f":"IF(B6=\"EBGB\",70,\"\")","v":""},null,null,null,null,{"$f":"IF(B6=\"EBGB\",\"01-19\",\"\")","v":""},{"$f":"IF(ISERROR(AG29),\"\",AG29)","v":""},{"$f":"IF(B6=\"EBGB\",615,\"\")","v":""},null,"FI number"]
[null,{"$f":"IF(E3=3,B6,\"\")","v":""},{"$f":"IF(E3=3,C6,\"\")","v":""},{"$f":"IF(E3=3,D6,\"\")","v":""},{"$f":"IF(E3=3,E6,\"\")","v":""},{"$f":"IF(E3=3,F6,IF(B7=\"EBGB\",70,\"\"))","v":""},{"$f":"IF(E3=3,G6,IF(G6=\"\",\"\",G6))","v":""},null,{"$f":"IF(B7=B6,I6,IF(OR(AF33=0,ISERROR(AF33)),\"\",AF33))","v":0},{"$f":"IF(OR(AH33=0,ISERROR(AH33)),\"\",IF(B7=B6,J6,AH33))","v":0},{"$f":"IF(B7=\"EBGB\",\"01-19\",\"\")","v":""},{"$f":"IF(ISERROR(AG34),\"\",IF(B7=B6,L6,AG34))","v":""},{"$f":"IF(E3=3,M6,IF(B7=\"EBGB\",615,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dropdown list"]
[]
[null,"ALTERNATES",null,null,"Elev",null,null,null,null,null,"Elev",null,null,null,"FI signature",null,null,"A student pilot is NOT allowed to continue his/her flight when anomalies occurred or after landing at another aerodrome than originally intended  (EASA FCL.020 FCL.045)"]
[null,null,"RWY",null,"Radio\nfreq",null,null,null,"RWY",null,"Radio freq",null,null,null,"Vliegclub Grimbergen"]
[null,null,"LDA",null,null,null,null,null,"LDA",null,null,null,null,null,"BE.DTO.113"]
[]
[null,"SQWK-codes ","Standard VFR",null,"2000 if ATS\n7000 if no ATS","Hijack",7500,null,"Radio failure",null,7600,"Distress",7700,null,"Light gun signals",null,null,null,null,null,"Interception signals",null,null,null,null,null,null,null,null,null,null,null,null,1,"SELECT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"NAV"]
[null,"NEW SQWK","0041-0057 (VFR - Bru info)",null,"NEW QNH",null,null,null,null,"TAKE-OFF TIME",null,":",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"LOC"]
[]
[null,"From / To","VOR ",null,"W / V","Rv/\nVar","Cm","Cc","DIST / \nCruise ALT","GS","EET / \nTOT EET","Enroute radio / Frequency"]
[null,null,"Name","Bearing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"SELECT"]
[null,null,"Freq","TO/FROM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"DAY"]
[{"$f":"IF(B21=$B$7,$B$7,\"\")","v":""},{"$f":"IF(B6=\"\",\"\",B6)","v":""},null,null,{"$f":"IF(I6=\"\",\"\",I6)","v":""},null,{"$f":"IF(OR(F20<0,F20>359,F20=\"\",F21=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21),0))>=360,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20))))))-F21,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21),0))<0,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21),0)+360,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21),0))))","v":""},{"$f":"IF(OR(F20<0,F20>359,F20=\"\",F21=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21-AL57),0))>=360,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20))))))-F21-AL57,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21-AL57),0))<0,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21-AL57),0)+360,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$J$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21-AL57),0))))","v":""},null,{"$f":"IF(OR(F20<0,F20>359,F20=\"\"),\"\",ROUND($J$3*SQRT((1-((($E21/$J$3)*(SIN(((PI()/180)*$E20)-((PI()/180)*F20))))^2)))-($E21*COS(((PI()/180)*$E20)-((PI()/180)*F20))),0))","v":""},{"$f":"IF(OR(I20=0,I20=\"\",F20=\"\"),\"\",ROUND(((I20/J20)*60),1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"NIGHT"]
["",null,null,null,{"$f":"IF(J6=\"\",\"\",J6)","v":""},null,null,null,null,null,{"$f":"IF(K20=\"\",\"\",\"TOT: \"&K20)","v":""}]
["",{"$f":"IF(OR(B21=\"\",B21=B7),\"\",B21)","v":""},null,null,{"$f":"IF(OR(B21=\"\",B21=B7),\"\",I$6)","v":""},null,{"$f":"IF(OR(F22<0,F22>359,F22=\"\",F23=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23),0))>=360,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22))))))-F23,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23),0))<0,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22))))))-F23,0)+360,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23),0))))","v":""},{"$f":"IF(OR(F22<0,F22>359,F22=\"\",F23=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23-AL58),0))>=360,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22))))))-F23-AL58,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23-AL58),0))<0,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22))))))-F23-AL58,0)+360,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$J$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23-AL58),0))))","v":""},null,{"$f":"IF(OR(F22<0,F22>359,F22=\"\"),\"\",ROUND($J$3*SQRT((1-((($E23/$J$3)*(SIN(((PI()/180)*$E22)-((PI()/180)*F22))))^2)))-($E23*COS(((PI()/180)*$E22)-((PI()/180)*F22))),0))","v":""},{"$f":"IF(OR(I22=0,I22=\"\",F22=\"\"),\"\",ROUND(((I22/J22)*60),1))","v":""}]
["",null,null,null,{"$f":"IF(OR(B21=\"\",B21=B7),\"\",J$6)","v":""},{"$f":"IF(OR(B21=\"\",B21=B7,F21=\"\"),\"\",F21)","v":""},null,null,{"$f":"IF(OR(B21=\"\",B21=B7),\"\",IF(OR(B21=\"\",I21=\"\"),\"\",I21))","v":""},null,{"$f":"IF(K22=\"\",\"\",\"TOT: \"&K20+K22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preferred QFU"]
["",{"$f":"IF(OR(B23=\"\",B23=B7),\"\",B23)","v":""},null,null,{"$f":"IF(OR(B23=\"\",B23=B7),\"\",I$6)","v":""},null,{"$f":"IF(OR(F24<0,F24>359,F24=\"\",F25=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25),0))>=360,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24))))))-F25,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25),0))<0,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24))))))-F25,0)+360,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25),0))))","v":""},{"$f":"IF(OR(F24<0,F24>359,F24=\"\",F25=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25-AL59),0))>=360,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24))))))-F25-AL59,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25-AL59),0))<0,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24))))))-F25-AL59,0)+360,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$J$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25-AL59),0))))","v":""},{"$f":"IF(OR(B23=\"\",B23=B6),\"\",0)","v":""},{"$f":"IF(OR(F24<0,F24>359,F24=\"\"),\"\",ROUND($J$3*SQRT((1-((($E25/$J$3)*(SIN(((PI()/180)*$E24)-((PI()/180)*F24))))^2)))-($E25*COS(((PI()/180)*$E24)-((PI()/180)*F24))),0))","v":""},{"$f":"IF(OR(I24=0,I24=\"\",F24=\"\"),\"\",ROUND(((I24/J24)*60),1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"journey"]
["",null,null,null,{"$f":"IF(OR(B23=\"\",B23=B7),\"\",J$6)","v":""},{"$f":"IF(OR(B23=\"\",B23=B7,F23=\"\"),\"\",F23)","v":""},null,null,{"$f":"IF(OR(B23=\"\",B23=B7),\"\",IF(OR(B23=\"\",I23=\"\"),\"\",I23))","v":""},null,{"$f":"IF(K24=\"\",\"\",\"TOT: \"&K20+K22+K24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B6","v":0},{"$f":"VALUE(LEFT(K6,2))","v":{"$error":"#VALUE!"}},null,{"$f":"VALUE(RIGHT(K6,2))","v":{"$error":"#VALUE!"}},null,"CHECK"]
["",{"$f":"IF(OR(B25=\"\",B25=B7),\"\",B25)","v":""},null,null,{"$f":"IF(OR(B25=\"\",B25=B7),\"\",I$6)","v":""},null,{"$f":"IF(OR(F26<0,F26>359,F26=\"\",F27=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27),0))>=360,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26))))))-F27,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27),0))<0,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26))))))-F27,0)+360,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27),0))))","v":""},{"$f":"IF(OR(F26<0,F26>359,F26=\"\",F27=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27-AL60),0))>=360,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26))))))-F27-AL60,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27-AL60),0))<0,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26))))))-F27-AL60,0)+360,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$J$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27-AL60),0))))","v":""},{"$f":"IF(OR(B25=\"\",B25=B7),\"\",0)","v":""},{"$f":"IF(OR(F26<0,F26>359,F26=\"\"),\"\",ROUND($J$3*SQRT((1-((($E27/$J$3)*(SIN(((PI()/180)*$E26)-((PI()/180)*F26))))^2)))-($E27*COS(((PI()/180)*$E26)-((PI()/180)*F26))),0))","v":""},{"$f":"IF(OR(I26=0,I26=\"\",F26=\"\"),\"\",ROUND(((I26/J26)*60),1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH28*COS((ABS((AE25*10)-AF28)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(AE26<0,\"TW\",IF(AE26>=0,\"HW\",))","v":{"$error":"#VALUE!"}},{"$f":"AH28*COS((ABS((AG25*10)-AF28)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(AG26<0,\"TW\",IF(AG26>=0,\"HW\",))","v":{"$error":"#VALUE!"}},{"$f":"IF(AE26<0,IF(AG26<0,\"DANGER\",IF(AE26<AG26,AG25,AE25)),AE25)","v":{"$error":"#VALUE!"}}]
["",null,null,null,{"$f":"IF(OR(B25=\"\",B25=B7),\"\",J$6)","v":""},{"$f":"IF(OR(B25=\"\",B25=B7,F25=\"\"),\"\",F25)","v":""},null,null,{"$f":"IF(OR(B25=\"\",B25=B7),\"\",IF(OR(B25=\"\",I25=\"\"),\"\",I25))","v":""},null,{"$f":"IF(K26=\"\",\"\",\"TOT: \"&K20+K22+K24+K26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH28*SIN((ABS((AE25*10)-AF28)*PI()/180))","v":{"$error":"#VALUE!"}},"CW",{"$f":"AH28*SIN((ABS((AG25*10)-AF28)*PI()/180))","v":{"$error":"#VALUE!"}},"CW",{"$f":"IF(ABS(AE27)<15,IF(ABS(AG27)<15,\"OK\",\"DANGER\"))","v":{"$error":"#VALUE!"}}]
["",{"$f":"IF(OR(B27=\"\",B27=B7),\"\",B27)","v":""},null,null,{"$f":"IF(OR(B27=\"\",B27=B7),\"\",I$6)","v":""},null,{"$f":"IF(OR(F28<0,F28>359,F28=\"\",F29=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29),0))>=360,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28))))))-F29,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29),0))<0,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28))))))-F29,0)+360,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29),0))))","v":""},{"$f":"IF(OR(F28<0,F28>359,F28=\"\",F29=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29-AL61),0))>=360,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28))))))-F29-AL61,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29-AL61),0))<0,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28))))))-F29-AL61,0)+360,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$J$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29-AL61),0))))","v":""},{"$f":"IF(OR(B27=\"\",B27=B7),\"\",0)","v":""},{"$f":"IF(OR(F28<0,F28>359,F28=\"\"),\"\",ROUND($J$3*SQRT((1-((($E29/$J$3)*(SIN(((PI()/180)*$E28)-((PI()/180)*F28))))^2)))-($E29*COS(((PI()/180)*$E28)-((PI()/180)*F28))),0))","v":""},{"$f":"IF(OR(I28=0,I28=\"\",F28=\"\"),\"\",ROUND(((I28/J28)*60),1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W",{"$f":"I6","v":0},"V",{"$f":"J6","v":0}]
["",null,null,null,{"$f":"IF(OR(B27=\"\",B27=B7),\"\",J$6)","v":""},{"$f":"IF(OR(B27=\"\",B27=B7,F27=\"\"),\"\",F27)","v":""},null,null,{"$f":"IF(OR(B27=\"\",B27=B7),\"\",IF(OR(B27=\"\",I27=\"\"),\"\",I27))","v":""},null,{"$f":"IF(K28=\"\",\"\",\"TOT: \"&K20+K22+K24+K26+K28)","v":""},null,null,null,"Marshaller hand signals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PREFERRED QFU",null,{"$f":"IF(AI27=\"OK\",AI26,\"DANGER\")","v":{"$error":"#VALUE!"}}]
["",{"$f":"IF(OR(B29=\"\",B29=B7),\"\",B29)","v":""},null,null,{"$f":"IF(OR(B29=\"\",B29=B7),\"\",I$6)","v":""},null,{"$f":"IF(OR(F30<0,F30>359,F30=\"\",F31=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31),0))>=360,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30))))))-F31,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31),0))<0,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30))))))-F31,0)+360,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31),0))))","v":""},{"$f":"IF(OR(F30<0,F30>359,F30=\"\",F31=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31-AL62),0))>=360,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30))))))-F31-AL62,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31-AL62),0))<0,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30))))))-F31-AL62,0)+360,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$J$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31-AL62),0))))","v":""},{"$f":"IF(OR(B29=\"\",B29=B7),\"\",0)","v":""},{"$f":"IF(OR(F30<0,F30>359,F30=\"\"),\"\",ROUND($J$3*SQRT((1-((($E31/$J$3)*(SIN(((PI()/180)*$E30)-((PI()/180)*F30))))^2)))-($E31*COS(((PI()/180)*$E30)-((PI()/180)*F30))),0))","v":""},{"$f":"IF(OR(I30=0,I30=\"\",F30=\"\"),\"\",ROUND(((I30/J30)*60),1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B7","v":""},{"$f":"VALUE(LEFT(K7,2))","v":{"$error":"#VALUE!"}},null,{"$f":"VALUE(RIGHT(K7,2))","v":{"$error":"#VALUE!"}}]
["",null,null,null,{"$f":"IF(OR(B29=\"\",B29=B7),\"\",J$6)","v":""},{"$f":"IF(OR(B29=\"\",B29=B7,F29=\"\"),\"\",F29)","v":""},null,null,{"$f":"IF(OR(B29=\"\",B29=B7),\"\",IF(OR(B29=\"\",I29=\"\"),\"\",I29))","v":""},null,{"$f":"IF(K30=\"\",\"\",\"TOT: \"&K20+K22+K24+K26+K28+K30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH33*COS((ABS((AE30*10)-AF33)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(AE31<0,\"TW\",IF(AE31>=0,\"HW\",))","v":{"$error":"#VALUE!"}},{"$f":"AH33*COS((ABS((AG30*10)-AF33)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(AG31<0,\"TW\",IF(AG31>=0,\"HW\",))","v":{"$error":"#VALUE!"}},{"$f":"IF(AE31<0,IF(AG31<0,\"DANGER\",IF(AE31<AG31,AG30,AE30)),AE30)","v":{"$error":"#VALUE!"}}]
["",{"$f":"IF(OR(B31=\"\",B31=B7),\"\",B31)","v":""},null,null,{"$f":"IF(OR(B31=\"\",B31=B7),\"\",I$6)","v":""},null,{"$f":"IF(OR(F32<0,F32>359,F32=\"\",F33=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33),0))>=360,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32))))))-F33,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33),0))<0,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32))))))-F33,0)+360,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33),0))))","v":""},{"$f":"IF(OR(F32<0,F32>359,F32=\"\",F33=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33-AL63),0))>=360,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32))))))-F33-AL63,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33-AL63),0))<0,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32))))))-F33-AL63,0)+360,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$J$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33-AL63),0))))","v":""},{"$f":"IF(OR(B31=\"\",B31=B7),\"\",0)","v":""},{"$f":"IF(OR(F32<0,F32>359,F32=\"\"),\"\",ROUND($J$3*SQRT((1-((($E33/$J$3)*(SIN(((PI()/180)*$E32)-((PI()/180)*F32))))^2)))-($E33*COS(((PI()/180)*$E32)-((PI()/180)*F32))),0))","v":""},{"$f":"IF(OR(I32=0,I32=\"\",F32=\"\"),\"\",ROUND(((I32/J32)*60),1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH33*SIN((ABS((AE30*10)-AF33)*PI()/180))","v":{"$error":"#VALUE!"}},"CW",{"$f":"AH33*SIN((ABS((AG30*10)-AF33)*PI()/180))","v":{"$error":"#VALUE!"}},"CW",{"$f":"IF(ABS(AE32)<15,IF(ABS(AG32)<15,\"OK\",\"DANGER\"))","v":{"$error":"#VALUE!"}}]
["",null,null,null,{"$f":"IF(OR(B31=\"\",B31=B7),\"\",J$6)","v":""},{"$f":"IF(OR(B31=\"\",B31=B7,F31=\"\"),\"\",F31)","v":""},null,null,{"$f":"IF(OR(B31=\"\",B31=B7),\"\",IF(OR(B31=\"\",I31=\"\"),\"\",I31))","v":""},null,{"$f":"IF(K32=\"\",\"\",\"TOT: \"&K20+K22+K24+K26+K28+K30+K32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W",{"$f":"IF(OR(B7=\"\",B7=0),\"\",VLOOKUP(B7,A20:E36,5,FALSE))","v":""},"V",{"$f":"IF(OR(B7=\"\",B7=0),\"\",VLOOKUP(B7,B20:E37,4,FALSE))","v":""}]
["",{"$f":"IF(OR(B33=\"\",B33=B7),\"\",B33)","v":""},null,null,{"$f":"IF(OR(B33=\"\",B33=B7),\"\",I$6)","v":""},null,{"$f":"IF(OR(F34<0,F34>359,F34=\"\",F35=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35),0))>=360,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34))))))-F35,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35),0))<0,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34))))))-F35,0)+360,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35),0))))","v":""},{"$f":"IF(OR(F34<0,F34>359,F34=\"\",F35=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35-AL64),0))>=360,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34))))))-F35-AL64,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35-AL64),0))<0,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34))))))-F35-AL64,0)+360,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$J$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35-AL64),0))))","v":""},{"$f":"IF(OR(B33=\"\",B33=B7),\"\",0)","v":""},{"$f":"IF(OR(F34<0,F34>359,F34=\"\"),\"\",ROUND($J$3*SQRT((1-((($E35/$J$3)*(SIN(((PI()/180)*$E34)-((PI()/180)*F34))))^2)))-($E35*COS(((PI()/180)*$E34)-((PI()/180)*F34))),0))","v":""},{"$f":"IF(OR(I34=0,I34=\"\",F34=\"\"),\"\",ROUND(((I34/J34)*60),1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PREFERRED QFU",null,{"$f":"IF(AI32=\"OK\",AI31,\"DANGER\")","v":{"$error":"#VALUE!"}}]
["",null,null,null,{"$f":"IF(OR(B33=\"\",B33=B7),\"\",J$6)","v":""},{"$f":"IF(OR(B33=\"\",B33=B7,F33=\"\"),\"\",F33)","v":""},null,null,{"$f":"IF(OR(B33=\"\",B33=B7),\"\",IF(OR(B33=\"\",I33=\"\"),\"\",I33))","v":""},null,{"$f":"IF(K34=\"\",\"\",\"TOT: \"&K20+K22+K24+K26+K28+K30+K32+K34)","v":""}]
["",{"$f":"IF(OR(B35=\"\",B35=B7),\"\",B35)","v":""},null,null,{"$f":"IF(OR(B35=\"\",B35=B7),\"\",I$6)","v":""},null,{"$f":"IF(OR(F36<0,F36>359,F36=\"\",F37=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37),0))>=360,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36))))))-F37,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37),0))<0,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36))))))-F37,0)+360,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37),0))))","v":""},{"$f":"IF(OR(F36<0,F36>359,F36=\"\",F37=\"\"),\"\",IF((ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37-AL65),0))>=360,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36))))))-F37-AL65,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37-AL65),0))<0,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36))))))-F37-AL65,0)+360,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$J$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37-AL65),0))))","v":""},{"$f":"IF(OR(B35=\"\",B35=B7),\"\",0)","v":""},{"$f":"IF(OR(F36<0,F36>359,F36=\"\"),\"\",ROUND($J$3*SQRT((1-((($E37/$J$3)*(SIN(((PI()/180)*$E36)-((PI()/180)*F36))))^2)))-($E37*COS(((PI()/180)*$E36)-((PI()/180)*F36))),0))","v":""},{"$f":"IF(OR(I36=0,I36=\"\",F36=\"\"),\"\",ROUND(((I36/J36)*60),1))","v":""}]
[null,null,null,null,{"$f":"IF(OR(B35=\"\",B35=B7),\"\",J$6)","v":""},{"$f":"IF(OR(B35=\"\",B35=B7,F35=\"\"),\"\",F35)","v":""},null,null,{"$f":"IF(OR(B35=\"\",B35=B7),\"\",IF(OR(B35=\"\",I35=\"\"),\"\",I35))","v":""},null,{"$f":"IF(K36=\"\",\"\",\"TOT: \"&K20+K22+K24+K26+K28+K30+K32+K34+K36)","v":""}]
[null,null,"Fuel trip",null,{"$f":"IF(OR(F3=\"\",F3=1),\"SELECT DAY OR NIGHT in F3\",IF(F3=2,\"DAY: +30 min spare\",IF(F3=3,\"NIGHT: + 45 min spare\",\"UNKOWN ERROR\")))","v":"SELECT DAY OR NIGHT in F3"},null,"Max drift correction",null,"TOTAL","Avg GS","TOTAL TIME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,3,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,3,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,2,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,4,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,4,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,5,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,5,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,6,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,6,FALSE))","v":""},{"$f":"IF(AX38=\"\",\"\",IF(AX38>180,AX38-180,AX38+180))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,7,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,7,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,8,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,8,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,9,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,9,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,10,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,11,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AE$38:$AQ$46,12,FALSE)),\"\",VLOOKUP(AS38,$AE$38:$AQ$46,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS38,$AF$38:$AR$46,13,FALSE)),\"\",VLOOKUP(AS38,$AF$38:$AR$46,13,FALSE))","v":""}]
[null,null,{"$f":"IF('W&B FORM'!M15=\"NOT ENOUGH FUEL TO COMPLETE THE TRIP\",\"ADD FUEL\",($L$3/60*$K$39)+('W&B FORM'!H13))","v":3},{"$f":"IF(C39=\"ADD FUEL\",\"ADD FUEL\",C39/3.785412)","v":0.79251611185255399},{"$f":"IF(F3=2,IF(L2=\"\",\"SELECT PLANE\",IF(OR(C39=\"ADD FUEL\",C39>L2,(C39+(L3/60*30)>L2)),\"ADD \"&ROUNDUP(C39+(L3/60*30)-L2,0)&\" l FUEL\",(C39+(L3/60*30)))),IF(F3=3,IF(L2=\"\",\"SELECT PLANE\",IF(OR(C39=\"ADD FUEL\",C39>L2,(C39+(L3/60*45)>L2)),\"ADD \"&ROUNDUP(C39+(L3/60*45)-L2,0)&\" l FUEL\",(C39+(L3/60*45)))),IF(F3=1,\"SELECT DAY OR NIGHT in F3\")))","v":"SELECT DAY OR NIGHT in F3"},null,{"$f":"MAX(E21,E23,E25,E27,E29,E31,E33,E35,E37)*60/J3","v":0},null,{"$f":"SUM(I20,I22,I24,I26,I28,I30,I32,I34,I36)","v":0},{"$f":"IF(ISERROR((I39/K39)*60),\"\",ROUND((I39/K39)*60,0))","v":""},{"$f":"ROUND(SUM(K20:K37),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,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,null,"Remaining",null,"Autonomy (incl. spare fuel)",null,"PNR (TIME)",null,"PNR (DIST)","PET (DIST)","PET (TIME)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selected plane",null,{"$f":"E2","v":"D-EVIE"},{"$f":"VLOOKUP(AF40,AD13:AE17,2,FALSE)","v":{"$error":"#N/A"}},null,"max fuel",{"$f":"60*2-(5.2*2)","v":109.6},null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,null,{"$f":"IF(ISERROR((+L2)-C39),\"\",IF((+L2)-C39<0,\"ADD FUEL\",(+L2)-C39))","v":106.6},{"$f":"IF(C41=\"\",\"\",IF(C41=\"ADD FUEL\",\"ADD FUEL\",C41/3.785412))","v":28.160739174494083},{"$f":"IF(ISERROR(ROUND(((L2)/(L3)*60),0)),\"\",IF(TRUNC(ROUND(((L2)/(L3)*60),0)/60)<10,\"0\"&TRUNC(ROUND(((L2)/(L3)*60),0)/60)&\":\",TRUNC(ROUND(((L2)/(L3)*60),0)/60)&\":\")&IF(MOD(ROUND(((L2)/(L3)*60),0),60)<10,\"0\"&MOD(ROUND(((L2)/(L3)*60),0),60),MOD(ROUND(((L2)/(L3)*60),0),60)))","v":"04:59"},null,{"$f":"IF(ISERROR(H42*AU68/(J39+AU68)),\"\",H42*AU68/(J39+AU68))","v":""},null,{"$f":"IF(ISERROR((G41/60)*J39),\"\",(G41/60)*J39)","v":""},{"$f":"IF(ISERROR((I39*AU68)/(J39+AU68)),\"\",(I39*AU68)/(J39+AU68))","v":""},{"$f":"IF(ISERROR((J41/J39)*60),\"\",(J41/J39)*60)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(((L2)/(L3)*60)-('W&B FORM'!H13),0)),\"\",ROUND(((L2)/(L3)*60)-('W&B FORM'!H13),0))","v":296},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"l",null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,"FREQUENCIES",null,null,null,"EN ROUTE & ARRIVAL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,"BUB",114.6,null,null,"REPORTING POINTS",null,null,"ALT","NOTES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,"AFI",114.9,null,null,{"$f":"IF(B7=\"EBGB\",\"LONDI\",\"\")","v":""},null,null,{"$f":"IF(B7=\"EBGB\",\"900 ft\",\"\")","v":""},{"$f":"IF(F45=\"LONDI\",\"BUB 114,60 TO 121°\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,"BUN",110.6,null,null,{"$f":"IF(F45=\"LONDI\",\"EBGB-FIELD\",\"\")","v":""},null,null,{"$f":"IF(F45=\"LONDI\",\"900 ft\",\"\")","v":""},{"$f":"IF(F45=\"LONDI\",\"FOLLOW TR 126° MAG\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,"NIK",117.4]
[null,"Brussels Info (civ)",126.9,null,null,null,null,null,null,"Preflight checks:"]
[null,"Belgo Info (mil)",129.32499999999999,null,null,null,null,null,null,null,"\u0080 AIP-info/charts"]
[null,"Dutch mil info",132.35,null,null,"CIRCUIT ALT (MSL)",null,null,null,null,"\u0080\u0080 NOTAMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compass deviation table and calculation of d for specific Rm=Rw-V"]
[null,"Lille info",126.47499999999999,null,null,{"$f":"IF(B7=\"\",\"\",IF(B7=\"EBGB\",\"800 ft\",SUM(F7,1000)))","v":""},null,null,null,null,"\u0080 METEO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOR",0,{"$f":"AE51+30","v":30},60,90,120,150,180,210,240,270,300,330,360]
[null,"Amsterdam Info",124.3,null,null,"Filing & closing flight plans ",null,null,null,{"$f":"IF(AND(E3=2,LEFT(B6,2)<>LEFT(B7,2),B7<>\"\"),\"CLOSE YOUR FLIGHTPLAN AND REGISTER YOUR NAVIGATION FLIGHT ON ARRIVAL IN \"&B7,IF(E3=2,\"REGISTER YOUR NAVIGATION FLIGHT ON ARRIVAL IN \"&B7,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEER",0,30,60,90,120,150,180,210,240,270,300,330,360]
[null,"Brussels VOLMET",127.80500000000001,null,null,"Belgium",null,"+ 32 2 206 25 40"]
[null,"Emergency",121.5,null,null,"France",null,"0810 437 837",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!A2&\" | \"&Introduction!H2","v":"remarks? tony.opsomer@gmail.com | version 2023-07-15"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"journey",null,null,null,null,null,null,null,"journey Back"]
[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. \nThanks to Luc Verhoeven and Michaël Debusscher for their valuable contribute to this flight log",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B56","v":"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. \nThanks to Luc Verhoeven and Michaël Debusscher for their valuable contribute to this flight log"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rw","V","Rm=Rw-V","LOOK UP BETWEEN (FOR)",null,"LOOK UP BETWEEN (STEER)",null,"d","Rw","V","Rm=Rw-V","LOOK UP BETWEEN (FOR)",null,"LOOK UP BETWEEN (STEER)",null,"d","GS back","EET back"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F20","v":0},{"$f":"F21","v":0},{"$f":"AE57-AF57","v":0},{"$f":"TRUNC(AE57/30)*30","v":0},{"$f":"AH57+30","v":30},{"$f":"HLOOKUP(AH57,$AE$51:$AQ$52,2,FALSE)","v":0},{"$f":"HLOOKUP(AI57,$AE$51:$AQ$52,2,FALSE)","v":30},{"$f":"AG57-(AJ57+((AG57-AH57)/(AI57-AH57)*(AK57-AJ57)))","v":0},{"$f":"IF(AE57+180>=360,AE57-180,AE57+180)","v":180},{"$f":"F21","v":0},{"$f":"AM57-AN57","v":180},{"$f":"TRUNC(AO57/30,0)*30","v":180},{"$f":"AP57+30","v":210},{"$f":"HLOOKUP(AP57,$AD$51:$AP$52,2,FALSE)","v":180},{"$f":"HLOOKUP(AQ57,$AD$51:$AP$52,2,FALSE)","v":210},{"$f":"AO57-(AR57+((AO57-AP57)/(AQ57-AP57)*(AS57-AR57)))","v":0},{"$f":"ROUND($J$3*SQRT((1-((($E21/$J$3)*(SIN(((PI()/180)*$E20)-((PI()/180)*AM57))))^2)))-($E21*COS(((PI()/180)*$E20)-((PI()/180)*AM57))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I20/AU57)*60),1)),\"\",ROUND(((I20/AU57)*60),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F22","v":0},{"$f":"F23","v":""},{"$error":"#VALUE!"},0,30,0,30,{"$error":"#VALUE!"},180,{"$f":"F23","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($J$3*SQRT((1-((($E23/$J$3)*(SIN(((PI()/180)*$E22)-((PI()/180)*AM58))))^2)))-($E23*COS(((PI()/180)*$E22)-((PI()/180)*AM58))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I22/AU58)*60),1)),\"\",ROUND(((I22/AU58)*60),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F24","v":0},{"$f":"F25","v":""},{"$error":"#VALUE!"},0,30,0,30,{"$error":"#VALUE!"},180,{"$f":"F25","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($J$3*SQRT((1-((($E25/$J$3)*(SIN(((PI()/180)*$E24)-((PI()/180)*AM59))))^2)))-($E25*COS(((PI()/180)*$E24)-((PI()/180)*AM59))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I24/AU59)*60),1)),\"\",ROUND(((I24/AU59)*60),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F26","v":0},{"$f":"F27","v":""},{"$error":"#VALUE!"},0,30,0,30,{"$error":"#VALUE!"},180,{"$f":"F27","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($J$3*SQRT((1-((($E27/$J$3)*(SIN(((PI()/180)*$E26)-((PI()/180)*AM60))))^2)))-($E27*COS(((PI()/180)*$E26)-((PI()/180)*AM60))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I26/AU60)*60),1)),\"\",ROUND(((I26/AU60)*60),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F28","v":0},{"$f":"F29","v":""},{"$error":"#VALUE!"},0,30,0,30,{"$error":"#VALUE!"},180,{"$f":"F29","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($J$3*SQRT((1-((($E29/$J$3)*(SIN(((PI()/180)*$E28)-((PI()/180)*AM61))))^2)))-($E29*COS(((PI()/180)*$E28)-((PI()/180)*AM61))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I28/AU61)*60),1)),\"\",ROUND(((I28/AU61)*60),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F30","v":0},{"$f":"F31","v":""},{"$error":"#VALUE!"},0,30,0,30,{"$error":"#VALUE!"},180,{"$f":"F31","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($J$3*SQRT((1-((($E31/$J$3)*(SIN(((PI()/180)*$E30)-((PI()/180)*AM62))))^2)))-($E31*COS(((PI()/180)*$E30)-((PI()/180)*AM62))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I30/AU62)*60),1)),\"\",ROUND(((I30/AU62)*60),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F32","v":0},{"$f":"F33","v":""},{"$error":"#VALUE!"},0,30,0,30,{"$error":"#VALUE!"},180,{"$f":"F33","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($J$3*SQRT((1-((($E33/$J$3)*(SIN(((PI()/180)*$E31)-((PI()/180)*AM63))))^2)))-($E33*COS(((PI()/180)*$E31)-((PI()/180)*AM63))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I32/AU63)*60),1)),\"\",ROUND(((I32/AU63)*60),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F34","v":0},{"$f":"F35","v":""},{"$error":"#VALUE!"},0,30,0,30,{"$error":"#VALUE!"},180,{"$f":"F35","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($J$3*SQRT((1-((($E35/$J$3)*(SIN(((PI()/180)*$E34)-((PI()/180)*AM64))))^2)))-($E35*COS(((PI()/180)*$E34)-((PI()/180)*AM64))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I34/AU64)*60),1)),\"\",ROUND(((I34/AU64)*60),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F36","v":0},{"$f":"F37","v":""},{"$error":"#VALUE!"},0,30,0,30,{"$error":"#VALUE!"},180,{"$f":"F37","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($J$3*SQRT((1-((($E37/$J$3)*(SIN(((PI()/180)*$E36)-((PI()/180)*AM65))))^2)))-($E37*COS(((PI()/180)*$E36)-((PI()/180)*AM65))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I36/AU65)*60),1)),\"\",ROUND(((I36/AU65)*60),1))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mean GS back","TOTAL EET back"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(I39/AV68)*60","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AV57:AV65)","v":0}]

{"sheet":"Performance FORM","index":2,"n_rows":186,"n_cols":28,"rows_kept":186,"cut":false,"hidden":false,"merged":[[0,1,0,3],[25,6,25,8],[6,6,6,8],[14,8,17,8],[170,18,171,18],[4,12,5,14],[4,6,4,8],[5,6,5,8],[10,6,10,8],[8,6,8,8],[20,6,21,8],[7,6,7,8],[24,1,34,1],[6,1,23,1],[19,6,19,8],[9,6,9,8],[170,19,171,21],[170,22,171,22],[174,19,174,23],[22,6,23,8],[22,13,22,14],[53,1,54,8],[26,6,26,8],[24,15,24,17],[24,13,25,13],[24,14,25,14],[29,6,29,8],[27,6,27,8],[28,6,28,8],[31,6,34,8],[49,6,49,8],[36,6,36,8],[24,6,24,8],[35,1,51,1],[35,6,35,8],[38,6,38,8],[37,6,37,8],[42,8,45,8],[50,6,51,8],[47,6,47,8],[48,6,48,8],[39,6,39,8]]}
[null,{"$f":"Introduction!A2","v":"remarks? tony.opsomer@gmail.com"},null,null,null,null,null,null,{"$f":"Introduction!H2","v":"version 2023-07-15"}]
[null,"Performance form D-EVIE",null,null,null,null,null,null,"BE.DTO.113"]
[]
[]
[null,null,null,null,null,null,"Form validity checker",null,null,null,null,null,"Calculations"]
[null,null,null,null,null,null,"Don't forget: always do a manual check on your data!!"]
[null,"TAKE-OFF","Take-off mass [kg]",null,null,null,{"$f":"IF(E7=\"\",\"COMPLETE THE FORM\",IF(OR(E7<550,E7>'Aquila performance specs'!C134),\"WEIGHT OUT OF LIMITS\",\"WEIGHT VALUE OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Airport MSL altitude [ft]",null,null,null,{"$f":"IF(E8=\"\",\"COMPLETE THE FORM\",\"AIRPORT ALTITUDE OK\")","v":"COMPLETE THE FORM"},null,null,null,null,null,"Runway type dropdown list items",null,null,"Humidity dropdown list"]
[null,null,"Airport QNH [hPa or mbar]",null,null,null,{"$f":"IF(E9=\"\",\"COMPLETE THE FORM\",IF(OR(E9<960,E9>1100),\"INVALID QNH\",\"QNH OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"DEFINE TYPE",null,null,"SELECT VALUE"]
[null,null,"Airport pressure altitude [ft]",null,{"$f":"IF(OR(E8=\"\",E9=\"\"),\"COMPLETE THE FORM\",IF(E9>1013,(E8-(E9-1013)*30),(E8+(1013-E9)*30)))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E10=\"\",E10=\"COMPLETE THE FORM\"),\"COMPLETE THE FORM\",IF(E10>8000,\"NO DATA AVAILABLE\",\"PRESSURE ALTITUDE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"PAVED",null,null,"LOW"]
[null,null,"OAT Temperature at airport [°C]",null,null,null,{"$f":"IF(E11=\"\",\"COMPLETE THE FORM\",IF(OR(E11>40,E11<-30),\"TEMPERATURE OUT OF DATA RANGE\",\"TEMPERATURE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"DRY GRASS",null,null,"HIGH"]
[null,null,"Air humidity at airport",null,1,null,null,null,null,null,null,null,"SOFT GRASS"]
[null,null,"Airport density altitude [ft]",null,{"$f":"IF(OR(E9=\"\",E8=\"\",E11=\"\"),\"COMPLETE THE FORM\",E10+120*(E11-(15-(1.98/1000*E10))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,"MCP dropdown list items"]
[null,null,"Wind at airport",null,null,null,null,null,null,null,null,1,"SELECT VALUE"]
[null,null,null,"Direction [°]",null,null,{"$f":"IF(E15=\"\",\"COMPLETE THE FORM\",IF(OR(E15<0,E15>359),\"INVALID WIND DIRECTION\",\"WIND DIRECTION OK\"))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E15=\"\",E16=\"\",E18=\"\"),\"COMPLETE THE FORM\",IF(E16<0,\"CHECK WIND VELOCITY\",IF(ABS(Q45)>15,\"CROSSWIND TOO STRONG\",IF(Q44<-10,\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",IF(Q44>20,\"TOO MUCH HEADWIND\",ROUND(ABS(Q44),1)&\"kts \"&R44&\" AND \"&ROUND(ABS(Q45),1)&\"kts crosswind\")))))","v":"COMPLETE THE FORM"},null,null,2,0.55000000000000004]
[null,null,null,"Velocity [kts]",null,null,{"$f":"IF(E16=\"\",\"COMPLETE THE FORM\",IF(E16<0,\"INVALID WIND VELOCITY\",\"WIND VELOCITY OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,3,0.65]
[null,null,"Runway in use",null,null,null,null,null,null,null,null,4,0.75]
[null,null,null,"QFU",null,null,{"$f":"IF(E18=\"\",\"COMPLETE THE FORM\",IF(OR(E18<0,E18>35),\"INVALID QFU\",\"QFU OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,5,0.85]
[null,null,null,"type",1,null,{"$f":"IF(E19=\"\",\"\",IF(E19=1,\"DEFINE TYPE\",IF(E19=2,\"PAVED\",IF(E19=3,\"DRY GRASS\",IF(E19=4,\"SOFT GRASS\")))))","v":"DEFINE TYPE"},null,null,null,null,6,"MCP"]
[null,null,null,"length [m]",null,null,{"$f":"IF(E20=\"\",\"COMPLETE THE FORM\",IF(E20<0,\"INVALID RUNWAY LENGTH VALUE\",\"RUNWAY LENGTH VALUE OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Additional safety margin for take-off distance",null,0.5,null,null,null,null,null,null,null,"Cruise power section (part 1)"]
[null,null,"Take-off (flaps 17°, full power, 2260 RPM, dry & level runway)",null,null,null,null,null,null,null,null,null,"calculated press alt",{"$f":"E27","v":"COMPLETE THE FORM"},"desired %MCP",{"$f":"IF(E30=2, \"55%\",IF(E30=3,\"65%\",IF(E30=4,\"75%\",IF(E30=5,\"85%\",IF(E30=6,\"MCP\",\"\")))))","v":""},"real temp",{"$f":"O33","v":0},"temp correction factor for MAP",null,{"$f":"(R22-O28)/10*0.03","v":{"$error":"#VALUE!"}}]
[null,null,null,"ground roll [m]",{"$f":"IF(OR(E10=\"COMPLETE THE FORM\",E7=\"\",E20=\"\",E11=\"\",E21=\"\",E18=\"\",E16=\"\",E15=\"\",E12=1,E19=1,G19=\"DEFINE TYPE\"),\"COMPLETE THE FORM\",IF(OR(ISERROR(T100),G7=\"WEIGHT OUT OF LIMITS\",G10=\"NO DATA AVAILABLE\",G11=\"TEMPERATURE OUT OF DATA RANGE\",G9=\"INVALID QNH\"),\"NO DATA AVAILABLE\",R99))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E10=\"COMPLETE THE FORM\",E7=\"\",E20=\"\",E11=\"\",E21=\"\",E18=\"\",E16=\"\",E15=\"\",E12=1,G19=\"DEFINE TYPE\"),\"COMPLETE THE FORM\",IF(OR(ISERROR(T100),G7=\"WEIGHT OUT OF LIMITS\",G10=\"NO DATA AVAILABLE\",G11=\"TEMPERATURE OUT OF DATA RANGE\",G9=\"INVALID QNH\"),\"NO DATA AVAILABLE\",IF(OR(Q44<-10,Q44>20),\"TOO MUCH TAIL/HEAD-WIND\",IF(Q45>15,\"CROSSWIND TOO STRONG\",IF(E24<=E20,\"RUNWAY LENGTH SUFFICIENT\",\"RUNWAY TOO SHORT\")))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"table column index:",null,{"$f":"IF(P22=\"55%\",3,IF(P22=\"65%\",6,IF(P22=\"75%\",9,IF(P22=\"85%\",12,IF(P22=\"MCP\",15,\"\")))))","v":""},{"$f":"P23+1","v":{"$error":"#VALUE!"}},{"$f":"P23+2","v":{"$error":"#VALUE!"}},"temp correction factor for F/F",null,{"$f":"(R22-O28)/10*0.05","v":{"$error":"#VALUE!"}}]
[null,null,null,"total to clear 50ft OBS [m]",{"$f":"IF(OR(E10=\"COMPLETE THE FORM\",E7=\"\",E20=\"\",E11=\"\",E21=\"\",E18=\"\",E16=\"\",E15=\"\",E19=1,E12=1,G19=\"DEFINE TYPE\"),\"COMPLETE THE FORM\",IF(OR(ISERROR(T100),G7=\"WEIGHT OUT OF LIMITS\",G10=\"NO DATA AVAILABLE\",G11=\"TEMPERATURE OUT OF DATA RANGE\",G9=\"INVALID QNH\"),\"NO DATA AVAILABLE\",T100))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,"from data in table"]
[null,"CRUISE","MSL Cruising altitude [ft]",null,null,null,{"$f":"IF(E25=\"\",\"COMPLETE THE FORM\",IF(E25<0,\"CRUISING ALTITUDE MUST GREATER THAN 0 FT\",\"CRUISING ALTITUDE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"press alt","ISA temp",{"$f":"P22","v":""}]
[null,null,"Regional QNH [hPa or mbar]",null,null,null,{"$f":"IF(E26=\"\",\"COMPLETE THE FORM\",IF(OR(E26<960,E26>1100),\"INVALID QNH\",\"QNH OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,null,"RPM","MAP","F/F"]
[null,null,"Pressure altitude [ft]",null,{"$f":"IF(OR(E25=\"\",E26=\"\"),\"COMPLETE THE FORM\",IF(E26>1013,(E25-(E26-1013)*30),(E25+(1013-E26)*30)))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E27=\"\",E27=\"COMPLETE THE FORM\"),\"COMPLETE THE FORM\",IF(OR(E27<0,E27>12000),\"NO DATA FOUND\",\"PRESSURE ALTITUDE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,{"$f":"IF(MOD(TRUNC(N22/1000),2)=0,TRUNC(N22/1000)*1000, (TRUNC(N22/1000)-1)*1000)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N27,'Aquila performance specs'!$B$6:$C$12,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N27,'Aquila performance specs'!$B$6:$R$12,'Performance FORM'!P23,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N27,'Aquila performance specs'!$B$6:$R$12,'Performance FORM'!Q23,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N27,'Aquila performance specs'!$B$6:$R$12,'Performance FORM'!R23,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,"OAT Temperature at cruising altitude [°C]",null,null,null,{"$f":"IF(OR(E28=\"\",E25=\"\",E26=\"\"),\"COMPLETE THE FORM\",\"TEMPERATURE OK\")","v":"COMPLETE THE FORM"},null,null,null,null,null,null,{"$f":"IF(N22<0,#VALUE!,N22)","v":"COMPLETE THE FORM"},{"$f":"IF(N28=N27,O27,O27+($N$28-$N$27)/($N$29-$N$27)*(O29-O27))","v":{"$error":"#VALUE!"}},{"$f":"IF(N28=N27,P27,P27+($N$28-$N$27)/($N$29-$N$27)*(P29-P27))","v":{"$error":"#VALUE!"}},{"$f":"IF(N28=N27,Q27,Q27+($N$28-$N$27)/($N$29-$N$27)*(Q29-Q27))","v":{"$error":"#VALUE!"}},{"$f":"IF(N28=N27,R27,R27+($N$28-$N$27)/($N$29-$N$27)*(R29-R27))","v":{"$error":"#VALUE!"}}]
[null,null,"Density altitude [ft]",null,{"$f":"IF(OR(E25=\"\",E26=\"\",E28=\"\"),\"COMPLETE THE FORM\",E27+120*(E28-(15-(1.98/1000*E27))))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E29=\"\",E26=\"\",E27=\"\"),\"COMPLETE THE FORM\",IF(OR(E29<-2000,E29>12000),\"DENSITY ALTITUDE OUT OF DATA RANGE\",\"DENSITY ALTITUDE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,{"$f":"N27+2000","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N29,'Aquila performance specs'!$B$6:$C$12,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N29,'Aquila performance specs'!$B$6:$R$12,'Performance FORM'!P23,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N29,'Aquila performance specs'!$B$6:$R$12,'Performance FORM'!Q23,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N29,'Aquila performance specs'!$B$6:$R$12,'Performance FORM'!R23,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,"Desired % MCP",null,1,null,{"$f":"IF(E30=1, \"SELECT VALUE\", \"% MCP OK\")","v":"SELECT VALUE"}]
[null,null,"Cruise power settings (airplane mass 750 kg, 0° flaps, wheel fairings installed)"]
[null,null,null,"RPM",{"$f":"IF(OR(E26=\"\",E25=\"\",E28=\"\",E30=1),\"COMPLETE THE FORM\",IF(OR(G26=\"INVALID QNH\",G27=\"NO DATA FOUND\"),\"NO DATA AVAILABLE\",IF(ISERROR(P33),\"NO DATA AVAILABLE\",P33)))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E25=\"\",E26=\"\",E28=\"\",E30=1),\"COMPLETE THE FORM\",IF(OR(G26=\"INVALID QNH\",G27=\"NO DATA FOUND\"),\"NO DATA AVAILABLE\",IF(OR(ISERROR(P33),ISERROR(Q33),ISERROR(R33)),\"CHOOSE A LOWER DESIRED %MCP AND/OR CHECK DENSITY ALTITUDE\",\"POWER SETTINGS OK\")))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"pres alt","real temp","RPM","MAP","F/F"]
[null,null,null,"MAP",{"$f":"IF(OR(E26=\"\",E25=\"\",E28=\"\",E30=1),\"COMPLETE THE FORM\",IF(OR(G26=\"INVALID QNH\",G27=\"NO DATA FOUND\"),\"NO DATA AVAILABLE\",IF(ISERROR(Q33),\"NO DATA AVAILABLE\",Q33)))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,null,{"$f":"N28","v":"COMPLETE THE FORM"},{"$f":"E28","v":0},{"$f":"IF(P28=\"N/B\",#VALUE!,P28)","v":{"$error":"#VALUE!"}},{"$f":"Q28+(Q28*U22)","v":{"$error":"#VALUE!"}},{"$f":"R28+(R28*U23)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Fuel consumption [l/h]",{"$f":"IF(OR(E26=\"\",E25=\"\",E28=\"\",E30=1),\"COMPLETE THE FORM\",IF(OR(G26=\"INVALID QNH\",G27=\"NO DATA FOUND\"),\"NO DATA AVAILABLE\",IF(ISERROR(R33),\"NO DATA AVAILABLE\",R33)))","v":"COMPLETE THE FORM"}]
[null,null,null,"KTAS [kts]",{"$f":"IF(OR(E26=\"\",E25=\"\",E28=\"\",E30=1),\"COMPLETE THE FORM\",IF(T186=\"\",\"NO DATA AVAILABLE\",IF(OR(ISERROR(P33),ISERROR(Q33),ISERROR(R33)),\"NO DATA AVAILABLE\",T186)))","v":"COMPLETE THE FORM"}]
[null,"LANDING","Landing mass [kg]",null,null,null,{"$f":"IF(E36=\"\",\"COMPLETE THE FORM\",IF(OR(E36<550,E36>'Aquila performance specs'!C134),\"WEIGHT OUT OF LIMITS\",\"WEIGHT VALUE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"Takeoff section"]
[null,null,"Airport MSL altitude [ft]",null,null,null,{"$f":"IF(E37=\"\",\"COMPLETE THE FORM\",\"AIRPORT ALTITUDE OK\")","v":"COMPLETE THE FORM"}]
[null,null,"Airport 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,null,null,null,"calculation of head/tail/crosswind"]
[null,null,"Airport 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>8000,\"NO DATA AVAILABLE\",\"PRESSURE ALTITUDE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"QFU",{"$f":"E18","v":0},"-> runway heading",null,{"$f":"O39*10","v":0}]
[null,null,"OAT Temperature at airport [°C]",null,null,null,{"$f":"IF(E40=\"\",\"COMPLETE THE FORM\",IF(OR(E40>40,E40<-30),\"TEMPERATURE OUT OF DATA RANGE\",\"TEMPERATURE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"wind dir",{"$f":"E15","v":0}]
[null,null,"Airport 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,null,null,null,null,null,null,"wind velocity",{"$f":"E16","v":0}]
[null,null,"Wind at airport"]
[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(Q113)>15,\"CROSSWIND TOO STRONG\",IF(Q112<-10,\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",IF(Q112>20,\"TOO MUCH HEADWIND\",ROUND(ABS(Q112),1)&\"kts \"&R112&\" AND \"&ROUND(ABS(Q113),1)&\"kts crosswind\")))))","v":"COMPLETE THE FORM"},null,null,null,null,"angle between runway & wind dir",null,null,{"$f":"ABS(R39-O40)","v":0}]
[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,null,null,null,null,null,null,"head/tailwind",{"$f":"COS(Q43*PI()/180)*O41","v":0},{"$f":"IF(Q44>=0,\"headwind\",\"tailwind\")","v":"headwind"}]
[null,null,"Runway in use",null,null,null,null,null,null,null,null,null,null,null,null,"crosswind",{"$f":"SIN(Q43*PI()/180)*O41","v":0}]
[null,null,null,"QFU",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,null,null,"calculation of performance data"]
[null,null,null,"type",1,null,{"$f":"IF(E47=\"\",\"\",IF(E47=1,\"DEFINE TYPE\",IF(E47=2,\"PAVED\",IF(E47=3,\"DRY GRASS\"))))","v":"DEFINE TYPE"},null,null,null,null,null,null,"calc. Press alt",{"$f":"IF(E10<0,0,E10)","v":"COMPLETE THE FORM"},{"$f":"IF(E10<0,\"PRESS ALTITUDE < 0 -> PRESS ALTITUDE SET TO 0 ft TO CONTINUE CALCULATIONS\",\"\")","v":""}]
[null,null,null,"length [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,null,null,null,null,"OAT",{"$f":"E11","v":0}]
[null,null,"Additional safety margin for landing distance",null,0.5]
[null,null,"Landing (flaps 35°, idle power, low pitch, maximum braking, dry & level runway)",null,null,null,null,null,null,null,null,null,null,"from OAT data in table"]
[null,null,null,"ground roll [m]",{"$f":"IF(OR(E39=\"COMPLETE THE FORM\",E36=\"\",E40=\"\",E43=\"\",E44=\"\",E46=\"\",E49=\"\",E48=\"\",E47=1,G47=\"DEFINE TYPE\"),\"COMPLETE THE FORM\",IF(OR(ISERROR(T167),G39=\"NO DATA AVAILABLE\",G36=\"WEIGHT OUT OF LIMITS\",G40=\"TEMPERATURE OUT OF DATA RANGE\",G38=\"INVALID QNH\"),\"NO DATA AVAILABLE\",R166))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E39=\"COMPLETE THE FORM\",E36=\"\",E40=\"\",E43=\"\",E44=\"\",E46=\"\",E49=\"\",E48=\"\",E47=1,G47=\"DEFINE TYPE\"),\"COMPLETE THE FORM\",IF(OR(ISERROR(T167),G39=\"NO DATA AVAILABLE\",G36=\"WEIGHT OUT OF LIMITS\",G40=\"TEMPERATURE OUT OF DATA RANGE\",G38=\"INVALID QNH\"),\"NO DATA AVAILABLE\",IF(OR(Q112<-10,Q112>20),\"TOO MUCH TAIL/HEAD-WIND\",IF(Q113>15,\"CROSSWIND TOO STRONG\",IF(E52<=E48,\"RUNWAY LENGTH SUFFICIENT\",\"RUNWAY TOO SHORT\")))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,-30,{"$f":"IF(OR(O48<O51,O48>Q51),#VALUE!,O48)","v":0},40,null,"GRAPH 1"]
[null,null,null,"total to clear 50ft [m]",{"$f":"IF(OR(E39=\"COMPLETE THE FORM\",E36=\"\",E40=\"\",E43=\"\",E44=\"\",E46=\"\",E49=\"\",E48=\"\",E47=1,G47=\"DEFINE TYPE\"),\"COMPLETE THE FORM\",IF(OR(ISERROR(T167),G39=\"NO DATA AVAILABLE\",G36=\"WEIGHT OUT OF LIMITS\",G40=\"TEMPERATURE OUT OF DATA RANGE\",G38=\"INVALID QNH\"),\"NO DATA AVAILABLE\",T167))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,null,{"$f":"IF(TRUNC(O47/1000)=0,0,IF(MOD(TRUNC(O47/1000),2)=0,TRUNC(O47/1000)*1000,(TRUNC(O47/1000)-1)*1000))","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N52,'Aquila performance specs'!B19:D23,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"O52+($P$51-$O$51)/($Q$51-$O$51)*(Q52-O52)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N52,'Aquila performance specs'!B19:D23,3,FALSE)","v":{"$error":"#VALUE!"}},null,"OAT",{"$f":"O48","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O47","v":"COMPLETE THE FORM"},{"$f":"IF(N53=N52,O52,O52+($N$53-$N$52)/($N$54-$N$52)*(O54-O52))","v":{"$error":"#VALUE!"}},{"$f":"IF(N53=N52,P52,P52+($N$53-$N$52)/($N$54-$N$52)*(P54-P52))","v":{"$error":"#VALUE!"}},{"$f":"IF(N53=N52,Q52,Q52+($N$53-$N$52)/($N$54-$N$52)*(Q54-Q52))","v":{"$error":"#VALUE!"}},null,"Y-value",{"$f":"P53","v":{"$error":"#VALUE!"}}]
[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,{"$f":"IF(TRUNC(O47/1000)=0,2000,IF(MOD(TRUNC(O47/1000),2)=0,(TRUNC(O47/1000)+2)*1000,(TRUNC(O47/1000)+1)*1000))","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N54,'Aquila performance specs'!B19:D23,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"O54+($P$51-$O$51)/($Q$51-$O$51)*(Q54-O54)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N54,'Aquila performance specs'!B19:D23,3,FALSE)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from mass data in table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"row index",750,{"$f":"IF(OR(E7<Q57,E7>O57),#VALUE!,E7)","v":{"$error":"#VALUE!"}},550,null,"GRAPH 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(O58,'Aquila performance specs'!I19:K26,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(P53<'Aquila performance specs'!I19,'Aquila performance specs'!I19,VLOOKUP(P53,'Aquila performance specs'!I19:I26,1,TRUE))","v":{"$error":"#VALUE!"}},{"$f":"O58+($P$57-$O$57)/($Q$57-$O$57)*(Q58-O58)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N58,'Aquila performance specs'!H19:J26,3,FALSE)","v":{"$error":"#VALUE!"}},null,"mass",{"$f":"P57","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P53","v":{"$error":"#VALUE!"}},{"$f":"IF(O59=O58,P58,P58+($O$59-$O$58)/($O$60-$O$58)*(P60-P58))","v":{"$error":"#VALUE!"}},{"$f":"IF(O59=O58,Q58,Q58+($O$59-$O$58)/($O$60-$O$58)*(Q60-Q58))","v":{"$error":"#VALUE!"}},null,"Y-value",{"$f":"P59","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N58+1","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N60,'Aquila performance specs'!H19:J26,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"O60+($P$57-$O$57)/($Q$57-$O$57)*(Q60-O60)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N60,'Aquila performance specs'!H19:J26,3,FALSE)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from wind data in table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"col ind",{"$f":"HLOOKUP(O64,'Aquila performance specs'!P19:T25,7,FALSE)","v":2},null,{"$f":"O63+1","v":3},null,"GRAPH 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(T64>=0,T64<=20),LOOKUP(T64,'Aquila performance specs'!Q19:T19),IF(AND(T64<0,T64>=-10),'Aquila performance specs'!P19,\"ERROR\"))","v":0},{"$f":"IF(T64=O64,T64,IF(OR(T64<O64,T64>Q64),#VALUE!,T64))","v":0},{"$f":"HLOOKUP(O63+1,'Aquila performance specs'!P18:T24,2,FALSE)","v":10},null,"windcomp",{"$f":"Q44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$63,'Aquila performance specs'!$P$18:$T$24,3,FALSE)","v":120},{"$f":"IF(O64=P64,O65,O65+($P$64-$O$64)/($Q$64-$O$64)*(Q65-O65))","v":120},{"$f":"HLOOKUP($Q$63,'Aquila performance specs'!$P$18:$T$24,3,FALSE)","v":92},null,"Y-value",{"$f":"T76","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$63,'Aquila performance specs'!$P$18:$T$24,4,FALSE)","v":204},{"$f":"IF(O64=P64,O66,O66+($P$64-$O$64)/($Q$64-$O$64)*(Q66-O66))","v":204},{"$f":"HLOOKUP($Q$63,'Aquila performance specs'!$P$18:$T$24,4,FALSE)","v":160}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$63,'Aquila performance specs'!$P$18:$T$24,5,FALSE)","v":290},{"$f":"IF(O65=P65,O67,O67+($P$64-$O$64)/($Q$64-$O$64)*(Q67-O67))","v":290},{"$f":"HLOOKUP($Q$63,'Aquila performance specs'!$P$18:$T$24,5,FALSE)","v":222}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$63,'Aquila performance specs'!$P$18:$T$24,6,FALSE)","v":398},{"$f":"IF(O65=P65,O68,O68+($P$64-$O$64)/($Q$64-$O$64)*(Q68-O68))","v":398},{"$f":"HLOOKUP($Q$63,'Aquila performance specs'!$P$18:$T$24,6,FALSE)","v":300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$63,'Aquila performance specs'!$P$18:$T$24,7,FALSE)","v":517},{"$f":"IF(O64=P64,O69,O69+($P$64-$O$64)/($Q$64-$O$64)*(Q69-O69))","v":517},{"$f":"HLOOKUP($Q$63,'Aquila performance specs'!$P$18:$T$24,7,FALSE)","v":397}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"search for Y-value from GRAPH 2 in wind table",null,null,{"$f":"P59","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"P64","v":0},null,null,null,null,null,"for interpolated graph (yellow)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!Q20","v":120},120,null,"row index",0,{"$f":"P73","v":0},null,{"$f":"R74","v":"row index"},-10,0,10,15,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!Q21","v":204},204,null,{"$f":"VLOOKUP(S75,'Aquila performance specs'!$Q$20:$U$24,5,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(R72,O74:O78)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(S75,$O$74:$P$78,2,FALSE)","v":{"$error":"#VALUE!"}},null,{"$f":"R75","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$75,'Aquila performance specs'!$O$20:$T$24,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$75,'Aquila performance specs'!$O$20:$T$24,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$75,'Aquila performance specs'!$O$20:$T$24,4,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$75,'Aquila performance specs'!$O$20:$T$24,5,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$75,'Aquila performance specs'!$O$20:$T$24,6,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!Q22","v":290},290,"->",null,{"$f":"R72","v":{"$error":"#VALUE!"}},{"$f":"IF(S76=S75,T75,T75+(S76-S75)/(S77-S75)*(T77-T75))","v":{"$error":"#VALUE!"}},null,null,{"$f":"W75+(X76-X75)/(X77-X75)*(W77-W75)","v":{"$error":"#VALUE!"}},{"$f":"S76","v":{"$error":"#VALUE!"}},{"$f":"Y75+(X76-X75)/(X77-X75)*(Y77-Y75)","v":{"$error":"#VALUE!"}},{"$f":"Z75+(X76-X75)/(X77-X75)*(Z77-Z75)","v":{"$error":"#VALUE!"}},{"$f":"AA75+(X76-X75)/(X77-X75)*(AA77-AA75)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!Q23","v":398},398,null,{"$f":"R75+1","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(R77,'Aquila performance specs'!$O$20:$Q$24,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(S77,$O$74:$P$78,2,FALSE)","v":{"$error":"#VALUE!"}},null,{"$f":"R77","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$77,'Aquila performance specs'!$O$20:$T$24,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$77,'Aquila performance specs'!$O$20:$T$24,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$77,'Aquila performance specs'!$O$20:$T$24,4,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$77,'Aquila performance specs'!$O$20:$T$24,5,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$77,'Aquila performance specs'!$O$20:$T$24,6,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!Q24","v":517},517]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from take-off distance in table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"look for Y-value: ",{"$f":"T65","v":{"$error":"#VALUE!"}},null,null,null,0,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W19","v":120},{"$f":"'Aquila performance specs'!X19","v":222}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W20","v":152},{"$f":"'Aquila performance specs'!X20","v":280}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"row index",null,null,null,null,{"$f":"'Aquila performance specs'!W21","v":180},{"$f":"'Aquila performance specs'!X21","v":318}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P85,'Aquila performance specs'!$W$19:$Y$32,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(P81,T82:T95)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(P85,T82:U95,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Aquila performance specs'!W22","v":211},{"$f":"'Aquila performance specs'!X22","v":400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P81","v":{"$error":"#VALUE!"}},"NO INTERMEDIATE DATA MAY BE USED",null,null,{"$f":"'Aquila performance specs'!W23","v":240},{"$f":"'Aquila performance specs'!X23","v":444}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O85+1","v":{"$error":"#VALUE!"}},{"$f":"IF(P81<T82,T82,VLOOKUP(O87,'Aquila performance specs'!V19:W32,2,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(P87,T82:U95,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Aquila performance specs'!W24","v":270},{"$f":"'Aquila performance specs'!X24","v":500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W25","v":300},{"$f":"'Aquila performance specs'!X25","v":560}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W26","v":335},{"$f":"'Aquila performance specs'!X26","v":617}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground roll required:",null,{"$f":"P87&\" m\"","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Aquila performance specs'!W27","v":360},{"$f":"'Aquila performance specs'!X27","v":670}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Take-off distance required (over 50 ft obstacle):",null,null,{"$f":"Q87&\" m\"","v":{"$error":"#VALUE!"}},null,{"$f":"'Aquila performance specs'!W28","v":390},{"$f":"'Aquila performance specs'!X28","v":728}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W29","v":420},{"$f":"'Aquila performance specs'!X29","v":780}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"additional correction factors",null,null,null,null,{"$f":"'Aquila performance specs'!W30","v":450},{"$f":"'Aquila performance specs'!X30","v":840}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"type of runway",{"$f":"IF(E19=2,\"PAVED\",IF(E19=3,\"DRY GRASS\",IF(E19=4,\"SOFT GRASS\",\"ERROR\")))","v":"ERROR"},"->",{"$f":"IF(Q94=\"PAVED\",0%,IF(Q94=\"DRY GRASS\",25%,IF(Q94=\"SOFT GRASS\",40%,)))","v":0},{"$f":"'Aquila performance specs'!W31","v":480},{"$f":"'Aquila performance specs'!X31","v":900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"air humidity",{"$f":"IF(E12=2,\"LOW\",IF(E12=3,\"HIGH\"))","v":false},"->",{"$f":"IF(Q95=\"LOW\",0%,IF(Q95=\"HIGH\",10%))","v":false},{"$f":"'Aquila performance specs'!W32","v":517},{"$f":"'Aquila performance specs'!X32","v":960}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"safety factor",{"$f":"E21","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL additional correction factor",null,null,{"$f":"SUM(Q96,S94,S95)","v":0.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ground roll required (with safety factor)",null,null,{"$f":"P87*(1+S97)","v":{"$error":"#VALUE!"}},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Take-off distance required (over 50 ft obstacle with safety factor)",null,null,null,null,{"$f":"Q87*(1+S97)","v":{"$error":"#VALUE!"}},"m"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Landing section"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"calculation of head/tail/crosswind"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"QFU",{"$f":"E46","v":0},"-> runway heading",null,{"$f":"O107*10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"wind dir",{"$f":"E43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"wind velocity",{"$f":"E44","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"angle between runway & wind dir",null,null,{"$f":"ABS(R107-O108)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"head/tailwind",{"$f":"COS(Q111*PI()/180)*O109","v":0},{"$f":"IF(Q112>=0,\"headwind\",\"tailwind\")","v":"headwind"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"crosswind",{"$f":"SIN(Q111*PI()/180)*O109","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"calculation of performance data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"calc. Press alt",{"$f":"IF(E39<0,0,E39)","v":"COMPLETE THE FORM"},{"$f":"IF(E39<0,\"PRESS ALTITUDE < 0 -> PRESS ALTITUDE SET TO 0 ft TO CONTINUE CALCULATIONS\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OAT",{"$f":"E40","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from OAT data in table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,-30,{"$f":"IF(OR(O116<O119,O116>Q119),#VALUE!,O116)","v":0},40,null,"GRAPH 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(TRUNC(O115/1000),2)=0,TRUNC(O115/1000)*1000,(TRUNC(O115/1000)-1)*1000)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N120,'Aquila performance specs'!$B$77:$D$81,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"O120+(P119-O119)/(Q119-O119)*(Q120-O120)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N120,'Aquila performance specs'!$B$77:$D$81,3,FALSE)","v":{"$error":"#VALUE!"}},null,"OAT",{"$f":"O116","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O115","v":"COMPLETE THE FORM"},{"$f":"IF(N121=N120,O120,O120+(N121-N120)/(N122-N120)*(O122-O120))","v":{"$error":"#VALUE!"}},{"$f":"IF(N121=N120,P120,P120+(N121-N120)/(N122-N120)*(P122-P120))","v":{"$error":"#VALUE!"}},{"$f":"IF(N121=N120,Q120,Q120+(N121-N120)/(N122-N120)*(Q122-Q120))","v":{"$error":"#VALUE!"}},null,"Y-value",{"$f":"P121","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(TRUNC(O115/1000),2)=0,(TRUNC(O115/1000)+2)*1000,(TRUNC(O115/1000)+1)*1000)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N122,'Aquila performance specs'!$B$77:$D$81,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"O122+(P119-O119)/(Q119-O119)*(Q122-O122)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N122,'Aquila performance specs'!$B$77:$D$81,3,FALSE)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from mass data in table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"row index",750,{"$f":"IF(OR(E36<Q125,E36>O125),#VALUE!,E36)","v":{"$error":"#VALUE!"}},550,null,"GRAPH 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(O126,'Aquila performance specs'!I77:K84,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(P121<'Aquila performance specs'!I77,'Aquila performance specs'!I77,VLOOKUP(P121,'Aquila performance specs'!I77:I84,1,TRUE))","v":{"$error":"#VALUE!"}},{"$f":"O126+(P125-O125)/(Q125-O125)*(Q126-O126)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N126,'Aquila performance specs'!H77:J84,3,FALSE)","v":{"$error":"#VALUE!"}},null,"mass",{"$f":"P125","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P121","v":{"$error":"#VALUE!"}},{"$f":"IF(O127=O126,P126,P126+(O127-O126)/(O128-O126)*(P128-P126))","v":{"$error":"#VALUE!"}},{"$f":"IF(O127=O126,Q126,Q126+(O127-O126)/(O128-O126)*(Q128-Q126))","v":{"$error":"#VALUE!"}},null,"Y-value",{"$f":"P127","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N126+1","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N128,'Aquila performance specs'!H77:J84,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"O128+(P125-O125)/(Q125-O125)*(Q128-O128)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(N128,'Aquila performance specs'!H77:J84,3,FALSE)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from wind data in table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"col ind",{"$f":"IF(P132<0,1,HLOOKUP(O132,'Aquila performance specs'!Q77:T83,7,FALSE))","v":3},null,{"$f":"O131+1","v":4},null,"GRAPH 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(T132>=0,T132<=20),LOOKUP(T132,'Aquila performance specs'!Q77:T77),IF(AND(T132<0,T132>=-10),-('Aquila performance specs'!O77),\"ERROR\"))","v":0},{"$f":"T132","v":0},{"$f":"HLOOKUP(Q131,'Aquila performance specs'!O76:T82,2,FALSE)","v":10},null,"windcomp",{"$f":"Q112","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$131,'Aquila performance specs'!O76:T82,3,FALSE)","v":360},{"$f":"IF(O132=P132,O133,O133+(P132-O132)/(Q132-O132)*(Q133-O133))","v":360},{"$f":"HLOOKUP($Q$131,'Aquila performance specs'!O76:T82,3,FALSE)","v":275},null,"Y-value",{"$f":"T144","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$131,'Aquila performance specs'!O76:T82,4,FALSE)","v":525},{"$f":"IF(O132=P132,O134,O134+(P132-O132)/(Q132-O132)*(Q134-O134))","v":525},{"$f":"HLOOKUP($Q$131,'Aquila performance specs'!O76:T82,4,FALSE)","v":400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$131,'Aquila performance specs'!O76:T82,5,FALSE)","v":645},{"$f":"IF(O132=P132,O135,O135+(P132-O132)/(Q132-O132)*(Q135-O135))","v":645},{"$f":"HLOOKUP($Q$131,'Aquila performance specs'!O76:T82,5,FALSE)","v":500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$131,'Aquila performance specs'!O76:T82,6,FALSE)","v":745},{"$f":"IF(O132=P132,O136,O136+(P132-O132)/(Q132-O132)*(Q136-O136))","v":745},{"$f":"HLOOKUP($Q$131,'Aquila performance specs'!O76:T82,6,FALSE)","v":570}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$131,'Aquila performance specs'!O76:T82,7,FALSE)","v":840},{"$f":"IF(O132=P132,O137,O137+(P132-O132)/(Q132-O132)*(Q137-O137))","v":840},{"$f":"HLOOKUP($Q$131,'Aquila performance specs'!O76:T82,7,FALSE)","v":645}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"search for Y-value from GRAPH 2 in wind table",null,null,{"$f":"P127","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"P132","v":0},null,null,null,null,null,"for interpolated graph (yellow)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$132<0,'Aquila performance specs'!P78,'Aquila performance specs'!Q78)","v":360},360,null,"row index",0,{"$f":"P141","v":0},null,{"$f":"R142","v":"row index"},-10,0,0,10,15,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$132<0,'Aquila performance specs'!P79,'Aquila performance specs'!Q79)","v":525},525,null,{"$f":"IF('Performance FORM'!T132<0,VLOOKUP(S143,'Aquila performance specs'!P78:U82,6,FALSE),VLOOKUP(S143,'Aquila performance specs'!Q78:U82,5,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(R140,O142:O146)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(S143,O142:P146,2,FALSE)","v":{"$error":"#VALUE!"}},null,{"$f":"R143","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$143,'Aquila performance specs'!$N$78:$T$82,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$143,'Aquila performance specs'!$N$78:$T$82,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$143,'Aquila performance specs'!$N$78:$T$82,4,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$143,'Aquila performance specs'!$N$78:$T$82,5,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$143,'Aquila performance specs'!$N$78:$T$82,6,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$143,'Aquila performance specs'!$N$78:$T$82,7,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$132<0,'Aquila performance specs'!P80,'Aquila performance specs'!Q80)","v":645},645,"->",null,{"$f":"R140","v":{"$error":"#VALUE!"}},{"$f":"IF(S144=S143,T143,T143+(S144-S143)/(S145-S143)*(T145-T143))","v":{"$error":"#VALUE!"}},null,null,{"$f":"W143+(X144-X143)/(X145-X143)*(W145-W143)","v":{"$error":"#VALUE!"}},{"$f":"IF(T132<0,S144,\"not applicable\")","v":"not applicable"},{"$f":"IF(T132>=0,S144,\"not applicable\")","v":{"$error":"#VALUE!"}},{"$f":"Z143+(Y144-Y143)/(Y145-Y143)*(Z145-Z143)","v":{"$error":"#VALUE!"}},{"$f":"AA143+(Y144-Y143)/(Y145-Y143)*(AA145-AA143)","v":{"$error":"#VALUE!"}},{"$f":"AB143+(Y144-Y143)/(Y145-Y143)*(AB145-AB143)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$132<0,'Aquila performance specs'!P81,'Aquila performance specs'!Q81)","v":745},745,null,{"$f":"R143+1","v":{"$error":"#VALUE!"}},{"$f":"IF(T132<0,VLOOKUP(R145,'Aquila performance specs'!N78:P82,3,FALSE),VLOOKUP(R145,'Aquila performance specs'!N78:Q82,4,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(S145,O142:P146,2,FALSE)","v":{"$error":"#VALUE!"}},null,{"$f":"R145","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$145,'Aquila performance specs'!$N$78:$T$82,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$145,'Aquila performance specs'!$N$78:$T$82,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$145,'Aquila performance specs'!$N$78:$T$82,4,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$145,'Aquila performance specs'!$N$78:$T$82,5,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$145,'Aquila performance specs'!$N$78:$T$82,6,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($V$145,'Aquila performance specs'!$N$78:$T$82,7,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$132<0,'Aquila performance specs'!P82,'Aquila performance specs'!Q82)","v":840},840]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from landing distance in table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"look for Y-value: ",{"$f":"T133","v":{"$error":"#VALUE!"}},null,null,null,50,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W77","v":220},{"$f":"'Aquila performance specs'!X77","v":85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W78","v":290},{"$f":"'Aquila performance specs'!X78","v":125}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"row index",null,null,null,null,{"$f":"'Aquila performance specs'!W79","v":375},{"$f":"'Aquila performance specs'!X79","v":160}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P153,'Aquila performance specs'!W77:Y89,3,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(P149,T150:T162)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(P153,T150:U162,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Aquila performance specs'!W80","v":435},{"$f":"'Aquila performance specs'!X80","v":175}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P149","v":{"$error":"#VALUE!"}},"NO INTERMEDIATE DATA MAY BE USED",null,null,{"$f":"'Aquila performance specs'!W81","v":500},{"$f":"'Aquila performance specs'!X81","v":210}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O153+1","v":{"$error":"#VALUE!"}},{"$f":"IF(P149<T150,T150,VLOOKUP(O155,'Aquila performance specs'!V77:X89,2,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(P155,T150:U162,2,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Aquila performance specs'!W82","v":580},{"$f":"'Aquila performance specs'!X82","v":240}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W83","v":650},{"$f":"'Aquila performance specs'!X83","v":275}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W84","v":720},{"$f":"'Aquila performance specs'!X84","v":300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground roll required:",null,{"$f":"Q155&\" m\"","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Aquila performance specs'!W85","v":790},{"$f":"'Aquila performance specs'!X85","v":330}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Landing distance required (over 50 ft obstacle):",null,null,{"$f":"P155&\" m\"","v":{"$error":"#VALUE!"}},null,{"$f":"'Aquila performance specs'!W86","v":865},{"$f":"'Aquila performance specs'!X86","v":355}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!W87","v":935},{"$f":"'Aquila performance specs'!X87","v":390}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"additional correction factors",null,null,null,null,{"$f":"'Aquila performance specs'!W88","v":1000},{"$f":"'Aquila performance specs'!X88","v":425}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"type of runway",{"$f":"IF(E47=2,\"PAVED\",IF(E47=3,\"DRY GRASS\",\"ERROR\"))","v":"ERROR"},"->",{"$f":"IF(Q162=\"PAVED\",0%,IF(Q162=\"DRY GRASS\",15%,))","v":0},{"$f":"'Aquila performance specs'!W89","v":1065},{"$f":"'Aquila performance specs'!X89","v":450}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"safety factor",{"$f":"E49","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL additional correction factor",null,null,{"$f":"SUM(Q163,S162)","v":0.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ground roll required (with safety factor)",null,null,{"$f":"Q155*(1+S164)","v":{"$error":"#VALUE!"}},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Landing distance required (over 50 ft obstacle with safety factor)",null,null,null,null,{"$f":"P155*(1+S164)","v":{"$error":"#VALUE!"}},"m"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cruise power section (part 2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"calculated density altitude",null,{"$f":"E29","v":"COMPLETE THE FORM"},null,null,"->","is there any data available for these values? ",null,null,{"$f":"IF(R172=\"MCP\",IF(AND(P171>=0,P171<='Aquila performance specs'!C184),\"YES\",\"NO\"),IF(AND(P171>=-2000,P171<=12000),\"YES\",\"NO\"))","v":"NO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"selected cruise power setting",null,{"$f":"E30","v":1},"-> ",{"$f":"VLOOKUP(P172,L14:M19,2,FALSE)","v":"SELECT VALUE"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2000,{"$f":"IF(AND(W171=\"YES\",R172<>\"MCP\"),HLOOKUP($R$172,'Aquila performance specs'!$C$179:$F$181,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P171","v":"COMPLETE THE FORM"},{"$f":"IF(AND(W171=\"YES\",R172<>\"MCP\"),IF(O175>O176,P176,P174+(O175-O174)/(O176-O174)*(P176-P174)),\"\")","v":""},null,"OR",null,"MCP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"max. RPM 2260 =",{"$f":"HLOOKUP(R172,'Aquila performance specs'!C179:F185,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(AND(W171=\"YES\",R172<>\"MCP\"),HLOOKUP(R172,'Aquila performance specs'!C179:F185,7,FALSE),\"\")","v":""},null,null,null,1,2,3,4,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!$G$184","v":0},{"$f":"'Aquila performance specs'!$F$184","v":3714},{"$f":"'Aquila performance specs'!$E$184","v":6286},{"$f":"'Aquila performance specs'!$D$184","v":9000},{"$f":"'Aquila performance specs'!$C$184","v":10286}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aquila performance specs'!$G$185","v":129.11000000000001},{"$f":"'Aquila performance specs'!$F$185","v":125.81178571428572},{"$f":"'Aquila performance specs'!$E$185","v":121.37785714285714},{"$f":"'Aquila performance specs'!$D$185","v":115.71571428571428},{"$f":"'Aquila performance specs'!$C$185","v":107.89171999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(U181,T177:X179,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"LOOKUP(U182,T177:X177)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(U181,T177:X178,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P171","v":"COMPLETE THE FORM"},{"$f":"IF(AND(R172=\"MCP\",W171=\"YES\"),V181+(U182-U181)/(U183-U181)*(V183-V181),IF(AND(R172=\"MCP\",W171=\"NO\",P171<0),'Aquila performance specs'!G185,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T181+1","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(T183,T176:X178,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(U183,T177:X178,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"KTAS at density altitude of \"&P171&\" ft and a power setting of \"&IF(R172<>\"MCP\",R172*100&\"%\",R172)&\" is:\"","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF(P175=\"\",V182,IF(V182=\"\",P175))","v":""},"kts"]

{"sheet":"W&B FORM","index":3,"n_rows":46,"n_cols":29,"rows_kept":46,"cut":false,"hidden":false,"merged":[[27,25,28,25],[7,5,7,6],[4,19,5,21],[8,5,8,6],[1,4,1,6],[4,12,4,15],[5,12,5,15],[6,19,6,20],[27,23,27,24],[9,5,9,6],[10,5,10,6],[7,14,10,15],[45,1,45,15],[11,12,11,15],[13,12,13,15],[14,12,14,15],[15,12,15,15],[17,1,42,1],[43,1,43,15]]}
[null,{"$f":"Introduction!A2","v":"remarks? tony.opsomer@gmail.com"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!H2","v":"version 2023-07-15"}]
[]
[null,"Weight & balance form  D-EVIE",null,null,null,null,null,null,null,null,null,null,null,null,null,"BE.DTO.113"]
[]
[null,null,null,null,null,null,null,"Fuel quantity","Weight ","Arm","Moment",null,"Form validity checker",null,null,null,null,null,null,"Calculations"]
[null,null,null,null,null,null,null,"[l]","[kg]","[m]","[kg.m]",null,"Don't forget: always do a manual check on your data!!"]
[null,"Basic empty weight (includes brake fluid, eng. oil & coolant and 10,4 l unusable fuel)",null,null,null,null,null,null,{"$f":"'Aquila performance specs'!C135","v":505},{"$f":"K7/I7","v":0.43354455445544554},{"$f":"'Aquila performance specs'!H135","v":218.94}]
[null,"Usable fuel (max. 109,60 l) ",null,null,null,null,null,null,{"$f":"H8*0.72","v":0},0.32500000000000001,{"$f":"I8*J8","v":0},null,{"$f":"IF(H8=\"\",\"COMPLETE THE FORM\",IF(H8>109.6,\"FUEL TANK OVERFLOW\",\"FUEL QUANTITY WITHIN LIMIT\"))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\"),\"COMPLETE THE FORM\",IF(SUM(I7:I11)>'Aquila performance specs'!C134,\"TOO MUCH USEFUL LOAD\",\"TOTAL USEFUL LOAD WITHIN LIMIT\"))","v":"COMPLETE THE FORM"}]
[null,"Pilot","forward position",5145,null,"rearward position",null,null,null,{"$f":"D9/10000","v":0.51449999999999996},{"$f":"I9*J9","v":0},null,null,null,null,null,null,null,null,"Aquila approved centre of gravity range and mass moment limits",null,null,null,null,null,"xS1=",0.42699999999999999,"xS2=",0.52300000000000002]
[null,"Passenger","forward position",5149,null,"rearward position",null,null,null,{"$f":"D10/10000","v":0.51490000000000002},{"$f":"I10*J10","v":0}]
[null,"Baggage area",null,null,null,null,null,null,null,1.3,{"$f":"I11*J11","v":0},null,{"$f":"IF(I11=\"\",\"COMPLETE THE FORM\",IF(I11>40,\"TOO MUCH BAGGAGE\",\"BAGGAGE VALUE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"X",{"$f":"U12*AA9","v":215.63499999999999},{"$f":"U12*AC9","v":264.11500000000001},{"$f":"W12*AA9","v":320.25},{"$f":"X12*AC9","v":392.25},{"$f":"U11","v":215.63499999999999},{"$f":"W11","v":320.25},{"$f":"V11","v":264.11500000000001},{"$f":"X11","v":392.25}]
[null,"RAMP WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\"),\"NO DATA\",SUM(I7:I11))","v":"NO DATA"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\"),\"NO DATA\",K12/I12)","v":"NO DATA"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\"),\"NO DATA\",SUM(K7:K11))","v":"NO DATA"},null,{"$f":"IF(I12=\"NO DATA\",\"COMPLETE THE FORM\",IF(AND(I12<='Aquila performance specs'!C134,Z30=\"YES\"),\"RAMP WEIGHT AND MOMENT WITHIN LIMITS\",IF(I12>'Aquila performance specs'!C134,\"DANGER: RAMP WEIGHT OUT OF LIMIT\",IF(AND('W&B FORM'!I12<='Aquila performance specs'!C134,Z30=\"NO\"),\"DANGER: RAMP MOMENT OUT OF LIMIT\"))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"Y",{"$f":"'Aquila performance specs'!C135","v":505},{"$f":"U12","v":505},{"$f":"'Aquila performance specs'!C134","v":750},{"$f":"W12","v":750},{"$f":"U12","v":505},{"$f":"W12","v":750},{"$f":"V12","v":505},{"$f":"X12","v":750}]
[null,"Fuel allowance for engine start, taxi and runup",null,null,null,null,null,3,{"$f":"H13*0.72","v":2.16},{"$f":"J8","v":0.32500000000000001},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",I13*J13)","v":0.70200000000000007}]
[null,"TAKE-OFF WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",H13=\"\"),\"NO DATA\",I12-I13)","v":"NO DATA"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",H13=\"\"),\"NO DATA\",K14/I14)","v":"NO DATA"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",H13=\"\"),\"NO DATA\",K12-K13)","v":"NO DATA"},null,{"$f":"IF(I14=\"NO DATA\",\"COMPLETE THE FORM\",IF(AND(I14<='Aquila performance specs'!C134,Z31=\"YES\"),\"TAKE-OFF WEIGHT AND MOMENT WITHIN LIMITS\",IF(I14>'Aquila performance specs'!C134,\"DANGER: TAKE-OFF WEIGHT OUT OF LIMIT\",IF(AND('W&B FORM'!I14<='Aquila performance specs'!C134,Z31=\"NO\"),\"DANGER: TAKE-OFF MOMENT OUT OF LIMIT\"))))","v":"COMPLETE THE FORM"}]
[null,"Total trip time",null,null,null,"hh:mm",null,{"$f":"(HOUR(E15)*60+MINUTE(E15))/60*MAX('Aquila performance specs'!F6:F12,'Aquila performance specs'!I6:I12,'Aquila performance specs'!L6:L12,'Aquila performance specs'!O6:O12,'Aquila performance specs'!R6:R12)","v":0},{"$f":"H15*0.72","v":0},{"$f":"J8","v":0.32500000000000001},{"$f":"I15*J15","v":0},null,{"$f":"IF(I14=\"NO DATA\",\"COMPLETE THE FORM\",IF(H15<(H8-(26*45/60)),\"TRIP TIME WITHIN LIMIT\",IF(H15<H8,\"DANGER! DANGER! FUEL RESERVE LESS THAN 45 MIN\",\"TRIP TIME TOO BIG\")))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"dotted lines to calculated points"]
[null,"LANDING WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",E15=\"\",H13=\"\"),\"NO DATA\",IF(M15=\"TRIP TIME TOO BIG\",\"CHECK\",I14-I15))","v":"NO DATA"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",E15=\"\",H13=\"\"),\"NO DATA\",IF(M15=\"TRIP TIME TOO BIG\",\"TRIP\",K16/I16))","v":"NO DATA"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",E15=\"\",H13=\"\"),\"NO DATA\",IF(M15=\"TRIP TIME TOO BIG\",\"TIME\",K14-K15))","v":"NO DATA"},null,{"$f":"IF(I16=\"NO DATA\",\"COMPLETE THE FORM\",IF(AND(I16<='Aquila performance specs'!C134,Z32=\"YES\"),\"RAMP WEIGHT AND MOMENT WITHIN LIMITS\",IF(I16>'Aquila performance specs'!C134,\"DANGER: LANDING WEIGHT OUT OF LIMIT\",IF(AND('W&B FORM'!I16<='Aquila performance specs'!C134,Z32=\"NO\"),\"DANGER: LANDING MOMENT OUT OF LIMIT\"))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,"X",210,{"$f":"K12","v":"NO DATA"},{"$f":"W16","v":"NO DATA"},{"$f":"X16","v":"NO DATA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",{"$f":"I12","v":"NO DATA"},{"$f":"I12","v":"NO DATA"},{"$f":"W17","v":"NO DATA"},0]
[null,"Mass [kg]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",{"$f":"V16","v":210},{"$f":"K14","v":"NO DATA"},{"$f":"W19","v":"NO DATA"},{"$f":"W19","v":"NO DATA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",{"$f":"I14","v":"NO DATA"},{"$f":"V20","v":"NO DATA"},{"$f":"W20","v":"NO DATA"},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",210,{"$f":"K16","v":"NO DATA"},{"$f":"W22","v":"NO DATA"},{"$f":"W22","v":"NO DATA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",{"$f":"I16","v":"NO DATA"},{"$f":"I16","v":"NO DATA"},{"$f":"W23","v":"NO DATA"},0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ramp, Take-off and landing moments within limits?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"limits",null,"SAFE?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN","MAX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ramp moment:",null,{"$f":"K12","v":"NO DATA"},{"$f":"I12*AA9","v":{"$error":"#VALUE!"}},{"$f":"I12*AC9","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(W30>=X30,W30<=Y30),\"YES\",\"NO\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Take-off moment:",null,{"$f":"K14","v":"NO DATA"},{"$f":"AA9*I14","v":{"$error":"#VALUE!"}},{"$f":"I14*AC9","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(W31>=X31,W31<=Y31),\"YES\",\"NO\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Landing moment:",null,{"$f":"K16","v":"NO DATA"},{"$f":"AA9*I16","v":{"$error":"#VALUE!"}},{"$f":"I16*AC9","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(W32>=X32,W32<=Y32),\"YES\",\"NO\")","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mass moment [kg.m]"]
[]
[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":"Aquila performance specs","index":4,"n_rows":218,"n_cols":25,"rows_kept":218,"cut":false,"hidden":false,"merged":[[91,1,92,28],[196,1,216,1],[217,2,217,15],[145,1,146,22],[193,1,194,18],[182,1,182,6],[148,18,148,21],[151,1,172,1],[148,10,148,11],[148,12,148,13],[148,14,148,17],[139,6,140,7],[173,2,173,21],[148,2,148,5],[148,6,148,9],[139,10,140,11],[55,7,55,13],[74,1,74,3],[74,8,74,9],[33,1,34,28],[16,22,16,23],[16,1,16,3],[16,8,16,9],[74,22,74,23],[70,1,70,6],[70,21,70,27],[55,14,55,20],[74,16,74,19],[113,1,113,6],[113,7,113,13],[113,14,113,20],[128,13,128,20],[2,1,4,1],[2,3,2,17],[3,3,3,5],[70,13,70,20],[70,7,70,12],[3,6,3,8],[2,2,4,2],[3,9,3,11],[3,12,3,14],[3,15,3,17],[16,16,16,19],[55,1,55,6],[139,2,140,3],[128,1,128,6],[128,7,128,12],[139,14,140,15],[128,21,128,27]]}
["Based on the original Aquila information dated 2008/09/17, document FM-AT01-1010-100E, issue A.12"]
[null,"Cruise power settings"]
[null,"Press alt [ft]","Temp ISA [°C]","Cruise power - % of the maximum countinous power MCP"]
[null,null,null,0.55000000000000004,null,null,0.65,null,null,0.75,null,null,0.85,null,null,"MCP"]
[null,null,null,"RPM","MAP [in Hg]","F/F [l/h]","RPM","MAP [in Hg]","F/F [l/h]","RPM","MAP [in Hg]","F/F [l/h]","RPM","MAP [in Hg]","F/F [l/h]","RPM","MAP [in Hg]","F/F [l/h]"]
[null,0,15,1900,24.6,14,2000,25.7,15.6,2100,27,21,2260,27.7,24,2260,28,26]
[null,2000,11,1900,24,15,2000,24.7,16,2200,25.7,21.3,2260,26.7,22,2260,27,26]
[null,4000,7,1900,23.3,16,2100,23.3,16.8,2260,24.3,21.5,2260,25.2,22,"N/B","N/B","N/B"]
[null,6000,3,2000,22,17,2200,22.7,19.3,2260,23.3,22.3,"N/B","N/B","N/B","N/B","N/B","N/B"]
[null,8000,-1,2100,21,18,2200,21.5,21.5,2260,21.5,23,"N/B","N/B","N/B","N/B","N/B","N/B"]
[null,10000,-5,2200,19.7,19,2260,20.100000000000001,22,"N/B","N/B","N/B","N/B","N/B","N/B","N/B","N/B","N/B"]
[null,12000,-9,2260,18.5,19,"N/B","N/B","N/B","N/B","N/B","N/B","N/B","N/B","N/B","N/B","N/B","N/B"]
[null,null,null,null,null,null,null,null,null,null,null,"For each 10°C above ISA temp: increase MAP by 3%, increase F/F by 5%"]
[null,null,null,null,null,null,null,null,null,null,null,"For each 10°C below ISA temp: decrease MAP by 3%, decrease F/F by 5%"]
[]
[null,"Take-off distance"]
[null,"OAT",null,null,null,null,null,null,"mass",null,null,null,null,null,null,"tailwind","headwind",null,null,null,null,null,"ground roll/TOD req"]
[null,null,-30,40,null,null,null,null,750,550,null,null,null,null,null,1,2,3,4,5,null,null,0,50]
[null,0,192,296,null,null,null,1,200,122,1,null,null,null,null,-10,0,10,15,20,null,1,120,222,1]
[null,2000,218,337,null,null,null,2,222,139,2,null,null,null,1,163,120,92,80,76,1,2,152,280,2]
[null,4000,253,385,null,null,null,3,258,160,3,null,null,null,2,270,204,160,140,123,2,3,180,318,3]
[null,6000,290,442,null,null,null,4,295,181,4,null,null,null,3,403,290,222,200,178,3,4,211,400,4]
[null,8000,337,517,null,null,null,5,337,210,5,null,null,null,4,538,398,300,270,242,4,5,240,444,5]
[null,null,null,null,null,null,null,6,383,240,6,null,null,null,5,698,517,397,350,315,5,6,270,500,6]
[null,null,null,null,null,null,null,7,423,277,7,null,null,null,null,1,2,3,4,5,null,7,300,560,7]
[null,null,null,null,null,null,null,8,517,320,8,null,null,null,null,null,null,null,null,null,null,8,335,617,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,360,670,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,390,728,10]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,420,780,11]
[null,"For operation on dry grass runway, increase the required take-off distances by 25%, on soft grass runway by up to 40%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,450,840,12]
[null,"Add appropriate values for wet grass/ground, ice, snow and slush",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,480,900,13]
[null,"In high humidity conditions the take-off distances may increase up to 10%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,517,960,14]
[null,"A not properly maintained aircraft, deviations from defined procedures, bad meteorological, ambient and runway conditions (rain, crosswind, wind shear, etc.) may considerably increase the required take-off distances"]
[null,"This data was obtained from the original take-off distance graph (manual, page 5-7). Since the graph did not include exact numbers, this data is likely to be inaccurate! "]
[]
[]
[null,"interpolated graphs"]
[null,-30,40,null,null,null,null,750,550,null,null,null,null,null,-10,0,null,0,10,15,20]
[null,{"$f":"'Performance FORM'!O53","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Q53","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Performance FORM'!O59","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Q59","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"'Performance FORM'!W76","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!S76","v":{"$error":"#VALUE!"}},null,{"$f":"P39","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Y76","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Z76","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!AA76","v":{"$error":"#VALUE!"}}]
[null,"calculated values to determine take-off distance required"]
[null,{"$f":"D41","v":0},{"$f":"D41","v":0},{"$f":"'Performance FORM'!T52","v":0},40,null,null,{"$f":"'Performance FORM'!T58","v":{"$error":"#VALUE!"}},750,{"$f":"H41","v":{"$error":"#VALUE!"}},{"$f":"J41","v":{"$error":"#VALUE!"}},{"$f":"K41","v":{"$error":"#VALUE!"}},550,-10,0,{"$f":"'Performance FORM'!T64","v":0},{"$f":"P41","v":0},{"$f":"Q41","v":0},20,0,{"$f":"R41","v":0},null,0,50]
[null,0,{"$f":"D42","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!T53","v":{"$error":"#VALUE!"}},{"$f":"D42","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Performance FORM'!T59","v":{"$error":"#VALUE!"}},{"$f":"E42","v":{"$error":"#VALUE!"}},0,{"$f":"H42","v":{"$error":"#VALUE!"}},{"$f":"K42","v":{"$error":"#VALUE!"}},{"$f":"K42","v":{"$error":"#VALUE!"}},{"$f":"M42","v":{"$error":"#VALUE!"}},{"$f":"N42","v":{"$error":"#VALUE!"}},0,{"$f":"'Performance FORM'!T65","v":{"$error":"#VALUE!"}},{"$f":"Q42","v":{"$error":"#VALUE!"}},{"$f":"R42","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!T59","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!T65","v":{"$error":"#VALUE!"}},null,{"$f":"'Performance FORM'!P87","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Q87","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Outside air temperature [°C]",null,null,null,null,null,"Take-off mass [kg]",null,null,null,null,null,null,"Wind component [kts]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Outside air temperature [°C]",null,null,null,null,null,"Take-off mass [kg]",null,null,null,null,null,"Wind component [kts]",null,null,null,null,null,null,null,"Obstacle height [ft]"]
[]
[]
[null,"Landing distance"]
[null,"OAT",null,null,null,null,null,null,"mass",null,null,null,null,null,null,"tailwind","headwind",null,null,null,null,null,"ground roll/LAD req"]
[null,null,-30,40,null,null,null,null,750,550,null,null,null,null,1,2,3,4,5,6,null,null,50,0]
[null,0,410,550,null,null,null,1,410,365,1,null,null,null,10,0,0,10,15,20,null,1,220,85,1]
[null,2000,451,610,null,null,null,2,450,400,2,null,null,1,485,360,360,275,240,220,1,2,290,125,2]
[null,4000,500,680,null,null,null,3,500,440,3,null,null,2,575,430,525,400,360,325,2,3,375,160,3]
[null,6000,560,750,null,null,null,4,550,480,4,null,null,3,690,515,645,500,435,395,3,4,435,175,4]
[null,8000,625,840,null,null,null,5,610,540,5,null,null,4,810,600,745,570,505,455,4,5,500,210,5]
[null,null,null,null,null,null,null,6,680,595,6,null,null,5,950,700,840,645,575,515,5,6,580,240,6]
[null,null,null,null,null,null,null,7,750,660,7,null,null,null,1,2,3,4,5,6,null,7,650,275,7]
[null,null,null,null,null,null,null,8,840,740,8,null,null,null,null,null,null,null,null,null,null,8,720,300,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,790,330,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,865,355,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,935,390,11]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,1000,425,12]
[null,"For operation on dry grass runway, increase the requiredlanding distances by 15%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,1065,450,13]
[null,"Add appropriate values for wet grass/ground, ice, snow and slush"]
[null,"A not properly maintained aircraft, deviations from defined procedures, bad meteorological and runway conditions (rain, crosswind, wind shear, etc.) may considerably increase the landing distances"]
[null,"This data was obtained from the original landing distance graph (manual, page 5-16). Since the graph did not include exact numbers, this data is likely to be inaccurate! "]
[]
[]
[null,"interpolated graphs"]
[null,-30,40,null,null,null,null,750,550,null,null,null,null,null,10,0,null,0,10,15,20]
[null,{"$f":"'Performance FORM'!O121","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Q121","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Performance FORM'!O127","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Q127","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"'Performance FORM'!W144","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!X144","v":"not applicable"},null,{"$f":"'Performance FORM'!Y144","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Z144","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!AA144","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!AB144","v":{"$error":"#VALUE!"}}]
[null,"calculated values to determine landing distance required"]
[null,{"$f":"D99","v":0},{"$f":"D99","v":0},{"$f":"'Performance FORM'!T120","v":0},40,null,null,{"$f":"'Performance FORM'!T126","v":{"$error":"#VALUE!"}},750,{"$f":"H99","v":{"$error":"#VALUE!"}},{"$f":"J99","v":{"$error":"#VALUE!"}},{"$f":"K99","v":{"$error":"#VALUE!"}},550,null,null,0,{"$f":"ABS('Performance FORM'!T142)","v":0},{"$f":"ABS('Performance FORM'!T142)","v":0},20,{"$f":"ABS('Performance FORM'!T142)","v":0},{"$f":"R99","v":0},null,50,0]
[null,0,{"$f":"D100","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!T121","v":{"$error":"#VALUE!"}},{"$f":"D100","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Performance FORM'!T127","v":{"$error":"#VALUE!"}},{"$f":"E100","v":{"$error":"#VALUE!"}},0,{"$f":"H100","v":{"$error":"#VALUE!"}},{"$f":"K100","v":{"$error":"#VALUE!"}},{"$f":"K100","v":{"$error":"#VALUE!"}},null,null,{"$f":"'Performance FORM'!S144","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!T144","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!T144","v":{"$error":"#VALUE!"}},{"$f":"R100","v":{"$error":"#VALUE!"}},0,{"$f":"R100","v":{"$error":"#VALUE!"}},null,{"$f":"'Performance FORM'!P155","v":{"$error":"#VALUE!"}},{"$f":"'Performance FORM'!Q155","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Outside air temperature [°C]",null,null,null,null,null,"Take-off mass [kg]",null,null,null,null,null,null,"Wind component [kts]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Outside air temperature [°C]",null,null,null,null,null,"Landing mass [kg]",null,null,null,null,null,"Wind component [kts]",null,null,null,null,null,null,null,"Obstacle height [ft]"]
[]
[]
[null,"Weight and balance data Aquila"]
[]
[null,"MTOW [kg]",750]
[null,"Empty Weight [kg]",505,null,"Empty weight moment [kg.m]",null,null,218.94]
[null,"Max. useful load [kg]",{"$f":"C134-C135","v":245}]
[]
[]
[null,"Loading graph"]
[null,null,"Fuel",null,null,null,"Baggage",null,null,null,"Seat in most forward position",null,null,null,"Seat in most rearward position"]
[]
[null,null,"Load mass[kg]","Moment [kg.m]",null,null,"Load mass[kg]","Moment [kg.m]",null,null,"Load mass[kg]","Moment [kg.m]",null,null,"Load mass[kg]","Moment [kg.m]"]
[null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,86.4,{"$f":"C144*0.325","v":28.080000000000002},null,null,40,{"$f":"40*1.3","v":52},null,null,220,100,null,null,220,131.54]
[]
[null,"This data was obtained from the original loading graph (manual, page 6-8). Since the graph did not include exact numbers, this data is likely to be inaccurate!"]
[]
[]
[null,"interpolated graphs","fuel",null,null,null,"baggage",null,null,null,"pilot seat graph",null,"passenger seat graph",null,"pilot",null,null,null,"passenger"]
[null,null,0,{"$f":"'W&B FORM'!K8","v":0},{"$f":"D150","v":0},{"$f":"E150","v":0},0,{"$f":"'W&B FORM'!K11","v":0},{"$f":"H150","v":0},{"$f":"H150","v":0},0,{"$f":"L151*'W&B FORM'!J9","v":113.19},0,{"$f":"N151*'W&B FORM'!J10","v":113.27800000000001},0,{"$f":"'W&B FORM'!K9","v":0},{"$f":"P150","v":0},{"$f":"P150","v":0},0,{"$f":"'W&B FORM'!K10","v":0},{"$f":"T150","v":0},{"$f":"U150","v":0}]
[null,null,{"$f":"D151","v":0},{"$f":"'W&B FORM'!I8","v":0},{"$f":"D151","v":0},0,{"$f":"'W&B FORM'!I11","v":0},{"$f":"G151","v":0},{"$f":"H151","v":0},0,0,220,0,220,{"$f":"'W&B FORM'!I9","v":0},{"$f":"O151","v":0},{"$f":"P151","v":0},0,{"$f":"'W&B FORM'!I10","v":0},{"$f":"S151","v":0},{"$f":"T151","v":0},0]
[null,"Load mass [kg]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Moment [kg.m]"]
[]
[]
[null,"Cruise performance data (TAS - True airspeed)"]
[]
[null,"density altitude",0.55000000000000004,0.65,0.75,0.85,null,null,null,null,"interpolated power setting values:"]
[null,-2000,95.36,103.93,112.5,120.71,null,null,null,null,null,"X",95,{"$f":"IF(ISERROR('Performance FORM'!O176),'Performance FORM'!T186,IF('Performance FORM'!O175>'Performance FORM'!O176,R180,'Performance FORM'!T186))","v":""},{"$f":"'Performance FORM'!T186","v":""},{"$f":"O180","v":""},{"$f":"P180","v":""},{"$f":"IF(ISERROR('Performance FORM'!O176),\"\",IF('Performance FORM'!O175>'Performance FORM'!O176,'Performance FORM'!P174+('Performance FORM'!O175-'Performance FORM'!O174)/('Performance FORM'!O176-'Performance FORM'!O174)*('Performance FORM'!P176-'Performance FORM'!P174),\"\"))","v":""}]
[null,12000,109.64,118.93,{"$f":"130-2.5","v":127.5},133.21,null,null,null,null,null,"Y",{"$f":"'Performance FORM'!O175","v":"COMPLETE THE FORM"},{"$f":"M181","v":"COMPLETE THE FORM"},0,{"$f":"IF(ISERROR('Performance FORM'!O176),N181,IF('Performance FORM'!O175>'Performance FORM'!O176,'Performance FORM'!O176,N181))","v":"COMPLETE THE FORM"},{"$f":"IF(ISERROR('Performance FORM'!O176),\"\",IF('Performance FORM'!O175>'Performance FORM'!O176,'Performance FORM'!O176,\"\"))","v":""},{"$f":"N181","v":"COMPLETE THE FORM"}]
[]
[null,"max. RPM 2260"]
[null,"density altitude",10286,9000,6286,3714,0]
[null,"TAS",{"$f":"C180+(C184-$B$180)/($B$181-$B$180)*(C181-C180)","v":107.89171999999999},{"$f":"D180+(D184-$B$180)/($B$181-$B$180)*(D181-D180)","v":115.71571428571428},{"$f":"E180+(E184-$B$180)/($B$181-$B$180)*(E181-E180)","v":121.37785714285714},{"$f":"F180+(F184-$B$180)/($B$181-$B$180)*(F181-F180)","v":125.81178571428572},{"$f":"130-0.89","v":129.11000000000001}]
[]
[]
[null,"Conditions:"]
[null,"Power settings: refer to table 5.2.8 on page 5-10 (or \"cruise power settings\" section on this sheet)"]
[null,"Airplane mass: 750 kg"]
[null,"Flaps: cruise-position (0°)"]
[null,"Wheel fairings installed!"]
[]
[null,"This data was obtained from the original cruise performance (TAS) graph (manual, page 5-12). Since the graph did not include exact numbers, this data is likely to be inaccurate!"]
[]
[]
[null,"Density altitude [ft]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"True airspeed [KTAS]"]