{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Introduction","Flight log FORM","Flight log FORM (REVISED)","Performance FORM","W&B FORM","C152 Performance specs","OO-VCL","OO-BET","OO-VCR","OO-VCM"],"not_rendered":{"charts":5,"images":16,"macros":1,"external_links":0,"defined_names":4,"comments":4,"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":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,4,4,5],[6,1,8,1],[11,0,11,5],[12,0,12,5]]}
[]
[]
[]
[]
["remarks? tony.opsomer@gmail.com",null,null,null,"version 2023-07-15"]
[]
[null,"C152","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":[[29,7,30,7],[27,7,28,7],[35,6,36,6],[51,9,53,12],[43,9,43,12],[39,4,39,5],[40,4,40,5],[38,4,38,5],[38,6,38,7],[43,5,43,7],[44,5,44,7],[45,5,45,7],[49,5,49,8],[50,5,50,8],[16,2,16,3],[16,8,18,8],[1,1,1,3],[12,2,12,3],[16,1,18,1],[14,2,14,3],[3,1,3,3],[16,4,18,4],[16,5,18,5],[9,4,10,4],[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],[21,6,22,6],[35,9,36,9],[31,9,32,9],[21,9,22,9],[35,29,36,31],[28,14,28,16],[14,4,14,5],[3,4,3,7],[2,20,10,23],[3,15,3,19],[4,15,4,19],[5,15,6,19],[23,7,24,7],[25,7,26,7],[19,6,20,6],[21,7,22,7],[9,10,10,10],[31,6,32,6],[29,6,30,6],[27,6,28,6],[33,6,34,6],[16,23,18,23],[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],[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,2,39,3],[39,6,39,7],[37,2,37,3],[42,1,42,3],[52,5,52,6],[53,20,53,23],[53,5,53,6],[23,29,23,33],[16,20,18,20],[16,21,18,21],[16,22,18,22],[14,9,14,10],[6,29,6,30],[12,14,12,18],[25,9,26,9],[27,9,28,9],[5,14,6,14],[0,10,0,12],[0,20,0,23],[14,11,14,12],[33,7,34,7],[29,9,30,9],[31,7,32,7],[35,7,36,7],[19,7,20,7],[12,20,12,23],[23,9,24,9],[19,9,20,9],[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],[23,6,24,6],[25,6,26,6],[16,9,18,9],[16,10,18,10],[16,11,18,12],[8,11,8,12]]}
[]
[null,"VFR FLIGHT LOG | VCG BE.DTO.113",null,null,1,"FLIGHT TYPE","VCG PILOT N°:",null,"TEMP",null,"FUEL TANK",{"$f":"IF(NOT(E2=1),AJ40,\"\")","v":""},{"$f":"IF(L2=\"\",\"\",L2/3.785412)","v":""},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",95,"Consumption",{"$f":"MAX('C152 Performance specs'!F33:F65,'C152 Performance specs'!I33:I65,'C152 Performance specs'!L33:L65)*3.785412","v":23.4695544},{"$f":"L3/3.785412","v":6.2},null,"Date of Flight"]
[null,{"$f":"Introduction!A5&\" | \"&Introduction!E5","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,null,{"$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,1,"SELECT",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,2,"OO-VCL",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,3,"OO-BET",null,null,3,"LOC"]
[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,4,"OO-VCR"]
[null,"From / To","VOR ",null,"W / V","Rv/\nVar","Cm","Cc","DIST / \nCruise ALT","GS","EET / \nTOT EET","Enroute radio / Frequency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"OO-VCM"]
[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":0},{"$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"]
[{"$f":"IF(B22=$B$7,$B$7,\"\")","v":0},null,null,null,{"$f":"IF(J6=\"\",\"\",J6)","v":""},null,null,null,null,null,{"$f":"IF(K20=\"\",\"\",\"TOT: \"&K20)","v":""}]
[0,{"$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":""},{"$f":"IF(OR(B21=\"\",B21=B3),\"\",0)","v":""},{"$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":""}]
[0,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"]
[0,{"$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=B5),\"\",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"]
[0,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"]
[0,{"$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!"}}]
[0,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!"}}]
[0,{"$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}]
[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!"}}]
[0,{"$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":0},{"$f":"VALUE(LEFT(K7,2))","v":{"$error":"#VALUE!"}},null,{"$f":"VALUE(RIGHT(K7,2))","v":{"$error":"#VALUE!"}}]
[0,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!"}}]
[0,{"$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!"}}]
[0,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":""}]
[0,{"$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!"}}]
[0,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":""}]
[0,{"$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'!M16=\"NOT ENOUGH FUEL TO COMPLETE THE TRIP\",\"ADD FUEL\",($L$3/60*$K$39)+('W&B FORM'!H14))","v":3.0283296000000002},{"$f":"IF(C39=\"ADD FUEL\",\"ADD FUEL\",C39/3.785412)","v":0.8},{"$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,{"$f":"IF(ISERROR(VLOOKUP(AS39,$AE$38:$AQ$46,3,FALSE)),\"\",VLOOKUP(AS39,$AE$38:$AQ$46,3,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS39,$AE$38:$AQ$46,2,FALSE)),\"\",VLOOKUP(AS39,$AE$38:$AQ$46,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS39,$AE$38:$AQ$46,4,FALSE)),\"\",VLOOKUP(AS39,$AE$38:$AQ$46,4,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS39,$AE$38:$AQ$46,5,FALSE)),\"\",VLOOKUP(AS39,$AE$38:$AQ$46,5,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AS39,$AE$38:$AQ$46,6,FALSE)),\"\",VLOOKUP(AS39,$AE$38:$AQ$46,6,FALSE))","v":""},"","","","","","","",""]
[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":1},{"$f":"VLOOKUP(AF40,AD13:AE17,2,FALSE)","v":"SELECT"},null,"max fuel",{"$f":"VLOOKUP(AG40,AF41:AG44,2,FALSE)","v":{"$error":"#N/A"}},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":""},{"$f":"IF(C41=\"\",\"\",IF(C41=\"ADD FUEL\",\"ADD FUEL\",C41/3.785412))","v":""},{"$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":""},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,"OO-VCL",{"$f":"'OO-VCL'!E4","v":141.95294999999999},"l",null,null,null,null,null,null,null,null,null,null,null,"","","","","",{"$f":"IF(AX41=\"\",\"\",IF(AX41>180,AX41-180,AX41+180))","v":""},"","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(((L2)/(L3)*60)-('W&B FORM'!H14),0)),\"\",ROUND(((L2)/(L3)*60)-('W&B FORM'!H14),0))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OO-BET",{"$f":"'OO-BET'!E4","v":141.95294999999999},"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,"OO-VCR",{"$f":"'OO-VCR'!E4","v":92.742593999999997},"l",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,"OO-VCM",{"$f":"'OO-VCM'!E4","v":92.742593999999997},"l",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},{"$f":"AF51+30","v":60},90,120,150,180,210,240,270,{"$f":"AN51+30","v":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",{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AE51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AE51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AE51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AE51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AF51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AF51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AF51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AF51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AG51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AG51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AG51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AG51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AH51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AH51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AH51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AH51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AI51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AI51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AI51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AI51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AJ51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AJ51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AJ51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AJ51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AK51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AK51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AK51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AK51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AL51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AL51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AL51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AL51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AM51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AM51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AM51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AM51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AN51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AN51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AN51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AN51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AO51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AO51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AO51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AO51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AP51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AP51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AP51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AP51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AQ51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AQ51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AQ51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AQ51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false}]
[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!A5&\" | \"&Introduction!E5","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":false},{"$f":"HLOOKUP(AI57,$AE$51:$AQ$52,2,FALSE)","v":false},{"$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":false},false,{"$f":"AO57-(AR57+((AO57-AP57)/(AQ57-AP57)*(AS57-AR57)))","v":180},{"$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":""},{"$f":"AE58-AF58","v":{"$error":"#VALUE!"}},{"$f":"TRUNC(AE58/30)*30","v":0},{"$f":"AH58+30","v":30},false,false,{"$error":"#VALUE!"},{"$f":"IF(AE58+180>=360,AE58-180,AE58+180)","v":180},{"$f":"F23","v":""},{"$f":"AM58-AN58","v":{"$error":"#VALUE!"}},{"$f":"TRUNC(AO58/30,0)*30","v":{"$error":"#VALUE!"}},{"$f":"AP58+30","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"AO58-(AR58+((AO58-AP58)/(AQ58-AP58)*(AS58-AR58)))","v":{"$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,false,false,{"$error":"#VALUE!"},180,{"$f":"F25","v":""},{"$error":"#VALUE!"},{"$f":"TRUNC(AO59/30,0)*30","v":{"$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,false,false,{"$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,false,false,{"$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,false,false,{"$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,false,false,{"$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,false,false,{"$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,false,false,{"$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":"Flight log FORM (REVISED)","index":2,"n_rows":68,"n_cols":59,"rows_kept":68,"cut":false,"hidden":true,"merged":[[12,21,12,24],[23,30,23,34],[25,6,26,6],[25,7,26,7],[25,9,26,9],[16,23,18,23],[16,24,18,24],[19,6,20,6],[19,7,20,7],[19,9,20,9],[21,6,22,6],[21,7,22,7],[21,9,22,9],[16,21,18,21],[16,22,18,22],[0,10,0,13],[0,21,0,24],[1,1,1,3],[1,30,3,35],[2,21,10,24],[3,1,3,3],[3,9,3,13],[3,16,3,20],[8,18,10,20],[9,4,10,4],[9,10,10,10],[4,16,4,20],[5,6,5,7],[5,15,6,15],[5,16,6,20],[6,6,6,7],[6,30,6,31],[12,2,12,3],[12,8,12,9],[12,15,12,19],[8,1,10,1],[8,2,8,3],[8,8,8,9],[8,12,8,13],[8,16,10,17],[16,1,18,1],[16,2,16,3],[16,4,18,4],[16,5,18,5],[16,6,18,6],[16,7,18,7],[14,2,14,3],[14,4,14,5],[14,12,14,13],[14,10,14,11],[16,11,18,11],[16,8,18,8],[16,9,18,9],[16,10,18,10],[16,12,18,13],[14,6,14,9],[27,6,28,6],[27,7,28,7],[27,9,28,9],[28,15,28,17],[29,6,30,6],[29,7,30,7],[29,9,30,9],[23,6,24,6],[23,7,24,7],[23,9,24,9],[35,6,36,6],[35,7,36,7],[35,9,36,9],[35,30,36,32],[35,33,35,44],[35,46,35,57],[31,6,32,6],[31,7,32,7],[31,9,32,9],[33,6,34,6],[33,7,34,7],[33,9,34,9],[49,5,49,8],[40,4,40,5],[42,1,42,3],[43,9,43,13],[37,2,37,3],[37,4,37,5],[38,4,38,5],[39,2,39,3],[39,4,39,5],[37,6,37,8],[38,6,38,8],[39,6,39,8],[40,6,40,8],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[43,5,43,6],[54,39,54,46],[55,1,56,13],[55,15,56,24],[55,34,55,35],[55,36,55,37],[55,42,55,43],[55,44,55,45],[50,5,50,8],[52,5,52,6],[53,5,53,6],[53,21,53,24],[54,31,54,38],[51,5,51,8]]}
[]
[null,"VFR FLIGHT LOG | VCG BE.DTO.113",null,null,1,"FLIGHT TYPE","VCG PILOT N°:",null,null,"TEMP",null,"FUEL TANK",{"$f":"IF(E2=1,\"\",AK40)","v":""},{"$f":"IF(M2=\"\",\"\",M2/3.785412)","v":""},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:",null,{"$f":"TODAY()","v":"2023-07-15"},"TAS",95,"Consumption",{"$f":"MAX('C152 Performance specs'!F33:F65,'C152 Performance specs'!I33:I65,'C152 Performance specs'!L33:L65)*3.785412","v":23.4695544},{"$f":"M3/3.785412","v":6.2},null,"Date of Flight"]
[null,{"$f":"Introduction!A5&\" | \"&Introduction!E5","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,null,"Name and signature\nof student pilot"]
[null,"Airfield","Gnd\nfreq","Twr / Rad freq","ATIS\nfreq","Elev","QNH",null,"W","V","RWY",null,"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":""},null,{"$f":"IF(ISERROR(AH29),\"\",AH29)","v":""},{"$f":"IF(B6=\"EBGB\",615,\"\")","v":""},null,"FI number"]
[null,{"$f":"IF(E3=3,\"EBGB\",\"\")","v":""},null,null,{"$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(AG33=0,ISERROR(AG33)),\"\",AG33))","v":0},{"$f":"IF(OR(AI33=0,ISERROR(AI33)),\"\",IF(B7=B6,J6,AI33))","v":0},{"$f":"IF(B7=\"EBGB\",\"01-19\",\"\")","v":""},null,{"$f":"IF(ISERROR(AH34),\"\",IF(B7=B6,M6,AH34))","v":""},{"$f":"IF(E3=3,N6,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,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,null,"Vliegclub Grimbergen"]
[null,null,"LDA",null,null,null,null,null,"LDA",null,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,null,"Distress",7700,null,"Light gun signals",null,null,null,null,null,"Interception signals",null,null,null,null,null,null,null,null,1,"SELECT",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,2,"OO-VCL",null,null,2,"NAV"]
[null,"NEW SQWK","0041-0057 (VFR - Bru info)",null,"NEW QNH",null,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,3,"OO-BET",null,null,3,"LOC"]
[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,4,"OO-VCR"]
[null,"From / To","VOR ",null,"W / V","true CRS \n/\nVar","magn. HDG","Cc","DIST / \nCruise ALT","GS","EET \n/ \nTOT. EET","EST. ETA\n/\nREAL ETA","Enroute radio / Frequency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"OO-VCM"]
[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,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,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/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21),0))>=360,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20))))))-F21,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21),0))<0,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21),0)+360,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$K$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/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21-AM57),0))>=360,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20))))))-F21-AM57,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21-AM57),0))<0,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21-AM57),0)+360,ROUND(((180/PI())*(((PI()/180)*F20)+SIN((E21/$K$3)*(SIN(((PI()/180)*E20)-((PI()/180)*F20)))))-F21-AM57),0))))","v":""},null,{"$f":"IF(OR(F20<0,F20>359,F20=\"\"),\"\",ROUND($K$3*SQRT((1-((($E21/$K$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,null,3,"NIGHT"]
[{"$f":"IF(B22=$B$7,$B$7,\"\")","v":""},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/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23),0))>=360,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22))))))-F23,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23),0))<0,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22))))))-F23,0)+360,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$K$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/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23-AM58),0))>=360,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22))))))-F23-AM58,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23-AM58),0))<0,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22))))))-F23-AM58,0)+360,ROUND(((180/PI())*(((PI()/180)*F22)+SIN((E23/$K$3)*(SIN(((PI()/180)*E22)-((PI()/180)*F22)))))-F23-AM58),0))))","v":""},{"$f":"IF(OR(B21=\"\",B21=B3),\"\",0)","v":""},{"$f":"IF(OR(F22<0,F22>359,F22=\"\"),\"\",ROUND($K$3*SQRT((1-((($E23/$K$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":""},{"$f":"IF(OR(K20=\"\",L20=\"\"),\"\",TIME(HOUR(L20),MINUTE(L20)+ROUND(K20,0),SECOND(L20)))","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,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/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25),0))>=360,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24))))))-F25,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25),0))<0,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24))))))-F25,0)+360,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$K$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/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25-AM59),0))>=360,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24))))))-F25-AM59,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25-AM59),0))<0,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24))))))-F25-AM59,0)+360,ROUND(((180/PI())*(((PI()/180)*F24)+SIN((E25/$K$3)*(SIN(((PI()/180)*E24)-((PI()/180)*F24)))))-F25-AM59),0))))","v":""},{"$f":"IF(OR(B23=\"\",B23=B5),\"\",0)","v":""},{"$f":"IF(OR(F24<0,F24>359,F24=\"\"),\"\",ROUND($K$3*SQRT((1-((($E25/$K$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":""},{"$f":"IF(OR(K22=\"\",L22=\"\"),\"\",TIME(HOUR(L22),MINUTE(L22)+ROUND(K22,0),SECOND(L22)))","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,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/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27),0))>=360,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26))))))-F27,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27),0))<0,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26))))))-F27,0)+360,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$K$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/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27-AM60),0))>=360,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26))))))-F27-AM60,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27-AM60),0))<0,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26))))))-F27-AM60,0)+360,ROUND(((180/PI())*(((PI()/180)*F26)+SIN((E27/$K$3)*(SIN(((PI()/180)*E26)-((PI()/180)*F26)))))-F27-AM60),0))))","v":""},{"$f":"IF(OR(B25=\"\",B25=B7),\"\",0)","v":""},{"$f":"IF(OR(F26<0,F26>359,F26=\"\"),\"\",ROUND($K$3*SQRT((1-((($E27/$K$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":""},{"$f":"IF(OR(K24=\"\",L24=\"\"),\"\",TIME(HOUR(L24),MINUTE(L24)+ROUND(K24,0),SECOND(L24)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI28*COS((ABS((AF25*10)-AG28)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF26<0,\"TW\",IF(AF26>=0,\"HW\",))","v":{"$error":"#VALUE!"}},{"$f":"AI28*COS((ABS((AH25*10)-AG28)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(AH26<0,\"TW\",IF(AH26>=0,\"HW\",))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF26<0,IF(AH26<0,\"DANGER\",IF(AF26<AH26,AH25,AF25)),AF25)","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,null,{"$f":"AI28*SIN((ABS((AF25*10)-AG28)*PI()/180))","v":{"$error":"#VALUE!"}},"CW",{"$f":"AI28*SIN((ABS((AH25*10)-AG28)*PI()/180))","v":{"$error":"#VALUE!"}},"CW",{"$f":"IF(ABS(AF27)<15,IF(ABS(AH27)<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/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29),0))>=360,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28))))))-F29,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29),0))<0,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28))))))-F29,0)+360,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$K$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/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29-AM61),0))>=360,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28))))))-F29-AM61,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29-AM61),0))<0,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28))))))-F29-AM61,0)+360,ROUND(((180/PI())*(((PI()/180)*F28)+SIN((E29/$K$3)*(SIN(((PI()/180)*E28)-((PI()/180)*F28)))))-F29-AM61),0))))","v":""},{"$f":"IF(OR(B27=\"\",B27=B7),\"\",0)","v":""},{"$f":"IF(OR(F28<0,F28>359,F28=\"\"),\"\",ROUND($K$3*SQRT((1-((($E29/$K$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":""},{"$f":"IF(OR(K26=\"\",L26=\"\"),\"\",TIME(HOUR(L26),MINUTE(L26)+ROUND(K26,0),SECOND(L26)))","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,null,"Marshaller hand signals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PREFERRED QFU",null,{"$f":"IF(AJ27=\"OK\",AJ26,\"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/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31),0))>=360,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30))))))-F31,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31),0))<0,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30))))))-F31,0)+360,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$K$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/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31-AM62),0))>=360,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30))))))-F31-AM62,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31-AM62),0))<0,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30))))))-F31-AM62,0)+360,ROUND(((180/PI())*(((PI()/180)*F30)+SIN((E31/$K$3)*(SIN(((PI()/180)*E30)-((PI()/180)*F30)))))-F31-AM62),0))))","v":""},{"$f":"IF(OR(B29=\"\",B29=B7),\"\",0)","v":""},{"$f":"IF(OR(F30<0,F30>359,F30=\"\"),\"\",ROUND($K$3*SQRT((1-((($E31/$K$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":""},{"$f":"IF(OR(K28=\"\",L28=\"\"),\"\",TIME(HOUR(L28),MINUTE(L28)+ROUND(K28,0),SECOND(L28)))","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,null,{"$f":"AI33*COS((ABS((AF30*10)-AG33)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF31<0,\"TW\",IF(AF31>=0,\"HW\",))","v":{"$error":"#VALUE!"}},{"$f":"AI33*COS((ABS((AH30*10)-AG33)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(AH31<0,\"TW\",IF(AH31>=0,\"HW\",))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF31<0,IF(AH31<0,\"DANGER\",IF(AF31<AH31,AH30,AF30)),AF30)","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/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33),0))>=360,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32))))))-F33,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33),0))<0,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32))))))-F33,0)+360,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$K$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/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33-AM63),0))>=360,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32))))))-F33-AM63,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33-AM63),0))<0,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32))))))-F33-AM63,0)+360,ROUND(((180/PI())*(((PI()/180)*F32)+SIN((E33/$K$3)*(SIN(((PI()/180)*E32)-((PI()/180)*F32)))))-F33-AM63),0))))","v":""},{"$f":"IF(OR(B31=\"\",B31=B7),\"\",0)","v":""},{"$f":"IF(OR(F32<0,F32>359,F32=\"\"),\"\",ROUND($K$3*SQRT((1-((($E33/$K$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":""},{"$f":"IF(OR(K30=\"\",L30=\"\"),\"\",TIME(HOUR(L30),MINUTE(L30)+ROUND(K30,0),SECOND(L30)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI33*SIN((ABS((AF30*10)-AG33)*PI()/180))","v":{"$error":"#VALUE!"}},"CW",{"$f":"AI33*SIN((ABS((AH30*10)-AG33)*PI()/180))","v":{"$error":"#VALUE!"}},"CW",{"$f":"IF(ABS(AF32)<15,IF(ABS(AH32)<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,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/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35),0))>=360,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34))))))-F35,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35),0))<0,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34))))))-F35,0)+360,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$K$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/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35-AM64),0))>=360,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34))))))-F35-AM64,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35-AM64),0))<0,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34))))))-F35-AM64,0)+360,ROUND(((180/PI())*(((PI()/180)*F34)+SIN((E35/$K$3)*(SIN(((PI()/180)*E34)-((PI()/180)*F34)))))-F35-AM64),0))))","v":""},{"$f":"IF(OR(B33=\"\",B33=B7),\"\",0)","v":""},{"$f":"IF(OR(F34<0,F34>359,F34=\"\"),\"\",ROUND($K$3*SQRT((1-((($E35/$K$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":""},{"$f":"IF(OR(K32=\"\",L32=\"\"),\"\",TIME(HOUR(L32),MINUTE(L32)+ROUND(K32,0),SECOND(L32)))","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(AJ32=\"OK\",AJ31,\"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/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37),0))>=360,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36))))))-F37,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37),0))<0,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36))))))-F37,0)+360,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$K$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/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37-AM65),0))>=360,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36))))))-F37-AM65,0)-360,IF((ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37-AM65),0))<0,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36))))))-F37-AM65,0)+360,ROUND(((180/PI())*(((PI()/180)*F36)+SIN((E37/$K$3)*(SIN(((PI()/180)*E36)-((PI()/180)*F36)))))-F37-AM65),0))))","v":""},{"$f":"IF(OR(B35=\"\",B35=B7),\"\",0)","v":""},{"$f":"IF(OR(F36<0,F36>359,F36=\"\"),\"\",ROUND($K$3*SQRT((1-((($E37/$K$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":""},{"$f":"IF(OR(K34=\"\",L34=\"\"),\"\",TIME(HOUR(L34),MINUTE(L34)+ROUND(K34,0),SECOND(L34)))","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,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(AT38,$AF$38:$AR$46,3,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,3,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,2,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,4,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,4,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,5,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,5,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,6,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,6,FALSE))","v":""},{"$f":"IF(AY38=\"\",\"\",IF(AY38>180,AY38-180,AY38+180))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,7,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,7,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,8,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,8,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,9,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,9,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,10,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,11,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AF$38:$AR$46,12,FALSE)),\"\",VLOOKUP(AT38,$AF$38:$AR$46,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT38,$AG$38:$AS$46,13,FALSE)),\"\",VLOOKUP(AT38,$AG$38:$AS$46,13,FALSE))","v":""}]
[null,null,{"$f":"IF('W&B FORM'!M16=\"NOT ENOUGH FUEL TO COMPLETE THE TRIP\",\"ADD FUEL\",($M$3/60*$L$39)+('W&B FORM'!H14))","v":3.0283296000000002},{"$f":"IF(C39=\"ADD FUEL\",\"ADD FUEL\",C39/3.785412)","v":0.8},{"$f":"IF(F3=2,IF(M2=\"\",\"SELECT PLANE\",IF(OR(C39=\"ADD FUEL\",C39>M2,(C39+(M3/60*30)>M2)),\"ADD \"&ROUNDUP(C39+(M3/60*30)-M2,0)&\" l FUEL\",(C39+(M3/60*30)))),IF(F3=3,IF(M2=\"\",\"SELECT PLANE\",IF(OR(C39=\"ADD FUEL\",C39>M2,(C39+(M3/60*45)>M2)),\"ADD \"&ROUNDUP(C39+(M3/60*45)-M2,0)&\" l FUEL\",(C39+(M3/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/K3","v":0},null,null,{"$f":"SUM(I20,I22,I24,I26,I28,I30,I32,I34,I36)","v":0},{"$f":"IF(ISERROR((J39/L39)*60),\"\",ROUND((J39/L39)*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,{"$f":"IF(ISERROR(VLOOKUP(AT39,$AF$38:$AR$46,3,FALSE)),\"\",VLOOKUP(AT39,$AF$38:$AR$46,3,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT39,$AF$38:$AR$46,2,FALSE)),\"\",VLOOKUP(AT39,$AF$38:$AR$46,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT39,$AF$38:$AR$46,4,FALSE)),\"\",VLOOKUP(AT39,$AF$38:$AR$46,4,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT39,$AF$38:$AR$46,5,FALSE)),\"\",VLOOKUP(AT39,$AF$38:$AR$46,5,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AT39,$AF$38:$AR$46,6,FALSE)),\"\",VLOOKUP(AT39,$AF$38:$AR$46,6,FALSE))","v":""},"","","","","","","",""]
[null,null,"Remaining",null,"Autonomy",null,"PNR (TIME)",null,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":1},{"$f":"VLOOKUP(AG40,AE13:AF17,2,FALSE)","v":"SELECT"},null,"max fuel",{"$f":"VLOOKUP(AH40,AG41:AH44,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,null,{"$f":"IF(ISERROR((+M2)-C39),\"\",IF((+M2)-C39<0,\"ADD FUEL\",(+M2)-C39))","v":""},{"$f":"IF(C41=\"\",\"\",IF(C41=\"ADD FUEL\",\"ADD FUEL\",C41/3.785412))","v":""},{"$f":"IF(ISERROR(ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0)),\"\",IF(TRUNC(ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0)/60)<10,\"0\"&TRUNC(ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0)/60)&\":\",TRUNC(ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0)/60)&\":\")&IF(MOD(ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0),60)<10,\"0\"&MOD(ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0),60),MOD(ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0),60)))","v":""},null,{"$f":"IF(ISERROR(H42*AV68/(K39+AV68)),\"\",H42*AV68/(K39+AV68))","v":""},null,null,{"$f":"IF(ISERROR((G41/60)*K39),\"\",(G41/60)*K39)","v":""},{"$f":"IF(ISERROR((J39*AV68)/(K39+AV68)),\"\",(J39*AV68)/(K39+AV68))","v":""},{"$f":"IF(ISERROR((K41/K39)*60),\"\",(K41/K39)*60)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OO-VCL",{"$f":"'OO-VCL'!E4","v":141.95294999999999},"l",null,null,null,null,null,null,null,null,null,null,null,"","","","","",{"$f":"IF(AY41=\"\",\"\",IF(AY41>180,AY41-180,AY41+180))","v":""},"","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0)),\"\",ROUND(((M2)/(M3)*60)-('W&B FORM'!H14),0))","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,"OO-BET",{"$f":"'OO-BET'!E4","v":141.95294999999999},"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,"OO-VCR",{"$f":"'OO-VCR'!E4","v":92.742593999999997},"l",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,"OO-VCM",{"$f":"'OO-VCM'!E4","v":92.742593999999997},"l",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,"","","","","","","","","","","","",""]
[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,"","","","","","","","","","","","",""]
[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,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,null,"FOR",0,{"$f":"AF51+30","v":30},{"$f":"AG51+30","v":60},90,120,150,180,210,240,270,{"$f":"AO51+30","v":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,null,"STEER",{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AF51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AF51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AF51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AF51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AG51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AG51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AG51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AG51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AH51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AH51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AH51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AH51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AI51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AI51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AI51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AI51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AJ51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AJ51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AJ51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AJ51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AK51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AK51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AK51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AK51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AL51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AL51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AL51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AL51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AM51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AM51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AM51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AM51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AN51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AN51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AN51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AN51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AO51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AO51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AO51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AO51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AP51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AP51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AP51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AP51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AQ51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AQ51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AQ51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AQ51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false},{"$f":"IF($E$2=\"\",\"\",IF($E$2=3,HLOOKUP(AR51,'OO-BET'!$C$66:$O$67,2,FALSE),IF($E$2=2,HLOOKUP(AR51,'OO-VCL'!$C$66:$O$67,2,FALSE),IF($E$2=5,HLOOKUP(AR51,'OO-VCM'!$C$66:$O$67,2,FALSE),IF($E$2=4,HLOOKUP(AR51,'OO-VCR'!$C$66:$O$67,2,FALSE))))))","v":false}]
[null,"Brussels VOLMET",127.80500000000001,null,null,null,null,null,null,"Belgium","+ 32 2 206 25 40"]
[null,"Emergency",121.5,null,null,null,null,null,null,"France","0810 437 837",null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!A5&\" | \"&Introduction!E5","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,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,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,null,{"$f":"F20","v":0},{"$f":"F21","v":0},{"$f":"AF57-AG57","v":0},{"$f":"TRUNC(AF57/30)*30","v":0},{"$f":"AI57+30","v":30},{"$f":"HLOOKUP(AI57,$AF$51:$AR$52,2,FALSE)","v":false},false,{"$f":"AH57-(AK57+((AH57-AI57)/(AJ57-AI57)*(AL57-AK57)))","v":0},{"$f":"IF(AF57+180>=360,AF57-180,AF57+180)","v":180},{"$f":"F21","v":0},{"$f":"AN57-AO57","v":180},{"$f":"TRUNC(AP57/30,0)*30","v":180},{"$f":"AQ57+30","v":210},{"$f":"HLOOKUP(AQ57,$AE$51:$AQ$52,2,FALSE)","v":false},false,{"$f":"AP57-(AS57+((AP57-AQ57)/(AR57-AQ57)*(AT57-AS57)))","v":180},{"$f":"ROUND($K$3*SQRT((1-((($E21/$K$3)*(SIN(((PI()/180)*$E20)-((PI()/180)*AN57))))^2)))-($E21*COS(((PI()/180)*$E20)-((PI()/180)*AN57))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I20/AV57)*60),1)),\"\",ROUND(((I20/AV57)*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,{"$f":"F22","v":0},{"$f":"F23","v":""},{"$f":"AF58-AG58","v":{"$error":"#VALUE!"}},{"$f":"TRUNC(AF58/30)*30","v":0},{"$f":"AI58+30","v":30},false,false,{"$error":"#VALUE!"},{"$f":"IF(AF58+180>=360,AF58-180,AF58+180)","v":180},{"$f":"F23","v":""},{"$f":"AN58-AO58","v":{"$error":"#VALUE!"}},{"$f":"TRUNC(AP58/30,0)*30","v":{"$error":"#VALUE!"}},{"$f":"AQ58+30","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"AP58-(AS58+((AP58-AQ58)/(AR58-AQ58)*(AT58-AS58)))","v":{"$error":"#VALUE!"}},{"$f":"ROUND($K$3*SQRT((1-((($E23/$K$3)*(SIN(((PI()/180)*$E22)-((PI()/180)*AN58))))^2)))-($E23*COS(((PI()/180)*$E22)-((PI()/180)*AN58))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I22/AV58)*60),1)),\"\",ROUND(((I22/AV58)*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,{"$f":"F24","v":0},{"$f":"F25","v":""},{"$error":"#VALUE!"},0,30,false,false,{"$error":"#VALUE!"},180,{"$f":"F25","v":""},{"$error":"#VALUE!"},{"$f":"TRUNC(AP59/30,0)*30","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($K$3*SQRT((1-((($E25/$K$3)*(SIN(((PI()/180)*$E24)-((PI()/180)*AN59))))^2)))-($E25*COS(((PI()/180)*$E24)-((PI()/180)*AN59))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I24/AV59)*60),1)),\"\",ROUND(((I24/AV59)*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,{"$f":"F26","v":0},{"$f":"F27","v":""},{"$error":"#VALUE!"},0,30,false,false,{"$error":"#VALUE!"},180,{"$f":"F27","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($K$3*SQRT((1-((($E27/$K$3)*(SIN(((PI()/180)*$E26)-((PI()/180)*AN60))))^2)))-($E27*COS(((PI()/180)*$E26)-((PI()/180)*AN60))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I26/AV60)*60),1)),\"\",ROUND(((I26/AV60)*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,{"$f":"F28","v":0},{"$f":"F29","v":""},{"$error":"#VALUE!"},0,30,false,false,{"$error":"#VALUE!"},180,{"$f":"F29","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($K$3*SQRT((1-((($E29/$K$3)*(SIN(((PI()/180)*$E28)-((PI()/180)*AN61))))^2)))-($E29*COS(((PI()/180)*$E28)-((PI()/180)*AN61))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I28/AV61)*60),1)),\"\",ROUND(((I28/AV61)*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,{"$f":"F30","v":0},{"$f":"F31","v":""},{"$error":"#VALUE!"},0,30,false,false,{"$error":"#VALUE!"},180,{"$f":"F31","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($K$3*SQRT((1-((($E31/$K$3)*(SIN(((PI()/180)*$E30)-((PI()/180)*AN62))))^2)))-($E31*COS(((PI()/180)*$E30)-((PI()/180)*AN62))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I30/AV62)*60),1)),\"\",ROUND(((I30/AV62)*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,{"$f":"F32","v":0},{"$f":"F33","v":""},{"$error":"#VALUE!"},0,30,false,false,{"$error":"#VALUE!"},180,{"$f":"F33","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($K$3*SQRT((1-((($E33/$K$3)*(SIN(((PI()/180)*$E31)-((PI()/180)*AN63))))^2)))-($E33*COS(((PI()/180)*$E31)-((PI()/180)*AN63))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I32/AV63)*60),1)),\"\",ROUND(((I32/AV63)*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,{"$f":"F34","v":0},{"$f":"F35","v":""},{"$error":"#VALUE!"},0,30,false,false,{"$error":"#VALUE!"},180,{"$f":"F35","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($K$3*SQRT((1-((($E35/$K$3)*(SIN(((PI()/180)*$E34)-((PI()/180)*AN64))))^2)))-($E35*COS(((PI()/180)*$E34)-((PI()/180)*AN64))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I34/AV64)*60),1)),\"\",ROUND(((I34/AV64)*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,{"$f":"F36","v":0},{"$f":"F37","v":""},{"$error":"#VALUE!"},0,30,false,false,{"$error":"#VALUE!"},180,{"$f":"F37","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND($K$3*SQRT((1-((($E37/$K$3)*(SIN(((PI()/180)*$E36)-((PI()/180)*AN65))))^2)))-($E37*COS(((PI()/180)*$E36)-((PI()/180)*AN65))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(ROUND(((I36/AV65)*60),1)),\"\",ROUND(((I36/AV65)*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,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,null,{"$f":"(J39/AW68)*60","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AW57:AW65)","v":0}]

{"sheet":"Performance FORM","index":3,"n_rows":89,"n_cols":24,"rows_kept":89,"cut":false,"hidden":false,"merged":[[70,17,70,18],[71,17,71,18],[72,17,72,18],[38,6,38,8],[39,6,39,8],[40,6,40,8],[41,6,41,8],[44,8,47,8],[49,6,49,8],[54,6,54,8],[50,6,50,8],[56,1,57,8],[36,1,54,1],[27,6,27,8],[4,1,22,1],[23,1,35,1],[2,14,2,15],[26,15,26,16],[18,6,18,8],[17,6,17,8],[8,6,8,8],[24,6,24,8],[12,8,15,8],[21,6,21,8],[22,6,22,8],[63,19,63,21],[63,16,63,18],[2,6,2,8],[3,6,3,8],[63,13,63,15],[9,6,9,8],[7,6,7,8],[6,6,6,8],[26,6,26,8],[25,6,25,8],[41,13,41,14],[41,15,41,16],[41,17,41,18],[26,13,26,14],[26,17,26,18],[28,6,28,8]]}
[null,null,{"$f":"Introduction!A5","v":"remarks? tony.opsomer@gmail.com"},null,null,null,null,null,{"$f":"Introduction!E5","v":"version 2023-07-15"}]
[null,null,{"$f":"\"Performance form C152\"&IF(OR(E6=0,E38=0),\"\",\" (from \"&E6&\" to \"&E38&\")\")","v":"Performance form C152"},null,null,null,null,null,"BE.DTO.113",null,null,null,"Calculations"]
[null,null,null,null,null,null,"Form validity checker",null,null,null,null,null,null,null,"RPM dropdown list items"]
[null,null,null,null,null,null,"Don't forget: always do a manual check on your data!!",null,null,null,null,null,null,null,1,"SELECT VALUE"]
[null,"TAKE-OFF","Take-off weight [kg]",null,{"$f":"IF(ISERROR(R84),\"SELECT PLANE\",R84)","v":"SELECT PLANE"},null,null,null,null,null,null,null,null,null,2,2550]
[null,null,"ICAO airport name",null,{"$f":"'Flight log FORM'!B6","v":0},null,null,null,null,null,null,null,null,null,3,2500]
[null,null,"MSL Altitude [ft]",null,{"$f":"'Flight log FORM'!F6","v":""},null,{"$f":"IF(E7=\"\",\"COMPLETE THE FORM\",\"AIRPORT ALTITUDE OK\")","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,4,2450]
[null,null,"QNH [hPa or mbar]",null,{"$f":"'Flight log FORM'!G6","v":0},null,{"$f":"IF(E8=\"\",\"COMPLETE THE FORM\",IF(OR(E8<960,E8>1100),\"INVALID QNH\",\"QNH OK\"))","v":"INVALID QNH"},null,null,null,null,null,null,null,5,2400]
[null,null,"Pressure altitude [ft]",null,{"$f":"IF(OR(E7=\"\",E8=\"\"),\"COMPLETE THE FORM\",IF(E8>1013,(E7-(E8-1013)*30),(E7+(1013-E8)*30)))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E9=\"\",E9=\"COMPLETE THE FORM\"),\"COMPLETE THE FORM\",IF(E9>3000,\"LEANING OF MIXTURE IS RECOMMENDED\",\"LEANING OF MIXTURE NOT RECOMMENDED\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,6,2300]
[null,null,"OAT Temperature [°C]",null,{"$f":"'Flight log FORM'!J2","v":0},null,{"$f":"IF(E10=\"\",\"COMPLETE THE FORM\",IF(E10>=40,\"TEMPERATURE TOO HIGH\",\"TEMPERATURE OK\"))","v":"TEMPERATURE OK"},null,null,null,null,null,"Runway type dropdown list items",null,7,2200]
[null,null,"Density altitude [ft]",null,{"$f":"IF(OR(E8=\"\",E7=\"\",E10=\"\"),\"COMPLETE THE FORM\",E9+120*(E10-(15-(1.98/1000*E9))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,"DEFINE TYPE",null,8,2100]
[null,null,"Wind",null,null,null,null,null,null,null,null,null,"PAVED",null,9,2000]
[null,null,null,"Direction [°]",{"$f":"'Flight log FORM'!E20","v":""},null,{"$f":"IF(E13=\"\",\"COMPLETE THE FORM\",IF(OR(E13<0,E13>359),\"INVALID WIND DIRECTION\",\"WIND DIRECTION OK\"))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E13=\"\",E14=\"\",E16=\"\"),\"COMPLETE THE FORM\",IF(E14<0,\"CHECK WIND VELOCITY\",IF(ABS(O17)>=15,\"CROSSWIND TOO STRONG\",IF(R16=\"USE OTHER RUNWAY DIRECTION\",\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",ROUND(ABS(O16),1)&\"kts \"&P16&\" AND \" & ROUND(ABS(O17),1)&\"kts \"&P17))))","v":"COMPLETE THE FORM"},null,null,null,"GRASS"]
[null,null,null,"Velocity [kts]",{"$f":"'Flight log FORM'!E21","v":""},null,{"$f":"IF(E14=\"\",\"COMPLETE THE FORM\",IF(E14<0,\"INVALID WIND VELOCITY\",\"WIND VELOCITY OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Runway",null,null,null,null,null,null,null,null,null,"Takeoff wind calculations",null,null,null,null,"change in takeoff distance"]
[null,null,null,"Runway",{"$f":"'Flight log FORM'!L6","v":""},null,{"$f":"IF(E16=\"\",\"COMPLETE THE FORM\",IF(OR(E16<0,E16>35),\"INVALID QFU\",\"QFU OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"headwind component [kts]",null,{"$f":"E14*COS((ABS((E16*10)-E13)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(O16>=0,\"HEADWIND\",IF(O16<0,\"TAILWIND\",\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(O16>=0,O16/9*-0.1,IF(AND(O16<0,O16>=-10),ABS(O16/2*0.1),\"USE OTHER RUNWAY DIRECTION\"))","v":{"$error":"#VALUE!"}}]
[null,null,null,"type",1,null,{"$f":"IF(E17=\"\",\"\",IF(E17=1,\"DEFINE TYPE\",IF(E17=2,\"PAVED\",IF(E17=3,\"GRASS\"))))","v":"DEFINE TYPE"},null,null,null,null,null,"crosswind component [kts]",null,{"$f":"E14*SIN((ABS((E16*10)-E13)*PI()/180))","v":{"$error":"#VALUE!"}},"CROSSWIND"]
[null,null,null,"TORA [m]",{"$f":"'Flight log FORM'!M6","v":""},null,{"$f":"IF(E18=\"\",\"COMPLETE THE FORM\",IF(E18<0,\"INVALID RUNWAY LENGTH VALUE\",\"RUNWAY LENGTH VALUE OK\"))","v":"COMPLETE THE FORM"}]
[null,null,"Safety margin for takeoff distance",null,0.5]
[null,null,"Short field take-off (flaps 10°, full throttle prior to brake release)",null,null,null,null,null,null,null,null,null,"Short field takeoff calculations"]
[null,null,null,"lift off IAS speed [kts]",50,null,null,null,null,null,null,null,"look between PA [ft]",null,null,"needed value [ft]"]
[null,null,null,"ground roll [m]",{"$f":"IF(E9=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(R16=\"USE OTHER RUNWAY DIRECTION\",\"CHANGE RUNWAY\",IF(E9>=8000,\"P.A. TOO HIGH\",IF(G17=\"PAVED\",((1+R16)*P31*(1+E19))*0.3048,IF(G17=\"GRASS\",(((1+R16)*P31+(0.15*P31))*(1+E19))*0.3048,\"COMPLETE THE FORM\")))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,{"$f":"IF(E9<=0,0,LEFT(E9/1000,1)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(E9<=0,0,LEFT(E9/1000+1,1)*1000)","v":{"$error":"#VALUE!"}},null,{"$f":"E9","v":"COMPLETE THE FORM"}]
[null,null,null,"total to clear 50ft OBS [m]",{"$f":"IF(E9=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(R16=\"USE OTHER RUNWAY DIRECTION\",\"CHANGE RUNWAY\",IF(E9>=8000,\"P.A. TOO HIGH\",IF(G17=\"PAVED\",((1+R16)*Q31*(1+E19))*0.3048,IF(G17=\"GRASS\",(((1+R16)*Q31+(0.15*P31))*(1+E19))*0.3048,\"COMPLETE THE FORM\")))))","v":"COMPLETE THE FORM"},null,{"$f":"IF(E9=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(E9>=8000,\"PRESSURE ALTITUDE TOO HIGH\",IF(G17=\"DEFINE TYPE\",\"DEFINE TYPE OF RUNWAY\",IF(E18=\"\",\"COMPLETE THE FORM\",IF(E23=\"CHANGE RUNWAY\",\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",IF(E23>E18,\"RUNWAY TOO SHORT\",IF(E23<=E18,\"RUNWAY LENGTH SUFFICIENT\")))))))","v":"COMPLETE THE FORM"},null,null,null,null,null,"look between temperatures [°C]",null,null,"needed value [°C]"]
[null,"CRUISE","Cruising weight [kg]",null,{"$f":"E5","v":"SELECT PLANE"}]
[null,null,"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,{"$f":"IF(E10<=0,0,LEFT(E10/10,1)*10)","v":0},{"$f":"IF(E10<=0,0,LEFT(E10/10+1,1)*10)","v":0},null,{"$f":"E10","v":0}]
[null,null,"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,"Found & interpolated takeoff values (distances are in FEET)"]
[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(E27<0,\"INVALID MSL CRUISING ALTITUDE\",IF(E27>3000,\"LEANING OF MIXTURE RECOMMENDED\",IF(OR(E27>12000,E27<2000),\"NO DATA FOUND\",IF(AND(E27>0,E27<=3000),\"LEANING OF MIXTURE NOT RECOMMENDED\",)))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,{"$f":"M25","v":0},null,{"$f":"P25","v":0},null,{"$f":"N25","v":0}]
[null,null,"OAT Temperature at cruising altitude [°C]",null,null,null,{"$f":"IF(OR(E28=\"\",E25=\"\",E26=\"\"),\"COMPLETE THE FORM\",IF(AND(E28<=((15-(1.98/1000*E27))+20),E28>=((15-(1.98/1000*E27))-20)),\"TEMPERATURE WITHIN DATA LIMITS\",\"TEMPERATURE OUT OF DATA LIMITS\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"GRND ROLL","TOTAL TO…","GRND ROLL","TOTAL TO…","GRND ROLL","TOTAL TO…"]
[null,null,"Desired RPM-setting",null,1,null,{"$f":"IF(E29=1,\"COMPLETE THE FORM\",M58)","v":"COMPLETE THE FORM"},null,null,null,null,null,"column index",{"$f":"2+(M25/10*2)","v":2},{"$f":"3+(M25/10*2)","v":3},null,null,{"$f":"2+(N25/10*2)","v":2},{"$f":"3+(N25/10*2)","v":3}]
[null,null,"Cruise performance",null,null,null,null,null,null,null,null,null,{"$f":"M22","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M30,'C152 Performance specs'!$B$7:$L$15,'Performance FORM'!N$29,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M30,'C152 Performance specs'!$B$7:$L$15,'Performance FORM'!O$29,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M30,'C152 Performance specs'!$B$7:$L$15,'Performance FORM'!R$29,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M30,'C152 Performance specs'!$B$7:$L$15,'Performance FORM'!S$29,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,"%BHP",{"$f":"IF(OR(E29=1,E28=\"\",E26=\"\",E25=\"\"),\"COMPLETE THE FORM\",IF(G27=\"NO DATA FOUND\",\"CHECK CRUISING ALT\",IF(OR(M58=\"RPM VALUE NOT FOUND IN DATA\",ISERROR(R72)),\"CHECK RPM VALUE\",IF(ABS(R61-O61)>20,\"CHECK TEMPERATURE\",R71/100))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,{"$f":"P22","v":"COMPLETE THE FORM"},{"$f":"IF(P22<=0,N30,N30+((N32-N30)*(($M$31-$M$30)/($M$32-$M$30))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P22<=0,O30,O30+((O32-O30)*(($M$31-$M$30)/($M$32-$M$30))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P25<=0,N31,N31+((R31-N31)*((($P$27-$N$27)/($R$27-$N$27)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P25<=0,O31,O31+((S31-O31)*((($P$27-$N$27)/($R$27-$N$27)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P22<=0,R30,R30+((R32-R30)*(($M$31-$M$30)/($M$32-$M$30))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P22<=0,S30,S30+((S32-S30)*(($M$31-$M$30)/($M$32-$M$30))))","v":{"$error":"#VALUE!"}}]
[null,null,null,"KIAS [kts]",{"$f":"IF(OR(E29=1,E28=\"\",E26=\"\",E25=\"\"),\"COMPLETE THE FORM\",IF(G27=\"NO DATA FOUND\",\"CHECK CRUISING ALT\",IF(OR(M58=\"RPM VALUE NOT FOUND IN DATA\",ISERROR(R72)),\"CHECK RPM VALUE\",IF(ABS(R61-O61)>20,\"CHECK TEMPERATURE\",P81))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,{"$f":"N22","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M32,'C152 Performance specs'!$B$7:$L$15,'Performance FORM'!N$29,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M32,'C152 Performance specs'!$B$7:$L$15,'Performance FORM'!O$29,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M32,'C152 Performance specs'!$B$7:$L$15,'Performance FORM'!R$29,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M32,'C152 Performance specs'!$B$7:$L$15,'Performance FORM'!S$29,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,"KTAS [kts]",{"$f":"IF(OR(E29=1,E28=\"\",E26=\"\",E25=\"\"),\"COMPLETE THE FORM\",IF(G27=\"NO DATA FOUND\",\"CHECK CRUISING ALT\",IF(OR(M58=\"RPM VALUE NOT FOUND IN DATA\",ISERROR(R72)),\"CHECK RPM VALUE\",IF(ABS(R61-O61)>20,\"CHECK TEMPERATURE\",R72-2))))","v":"COMPLETE THE FORM"}]
[null,null,null,"Fuel consumption [US Gal/hr]",{"$f":"IF(OR(E29=1,E28=\"\",E26=\"\",E25=\"\"),\"COMPLETE THE FORM\",IF(G27=\"NO DATA FOUND\",\"CHECK CRUISING ALT\",IF(OR(M58=\"RPM VALUE NOT FOUND IN DATA\",ISERROR(R72)),\"CHECK RPM VALUE\",IF(ABS(R61-O61)>20,\"CHECK TEMPERATURE\",R73))))","v":"COMPLETE THE FORM"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Short field landing calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"look between PA [ft]",null,null,"needed value [ft]"]
[null,"LANDING","Landing weight [kg]",null,{"$f":"E5","v":"SELECT PLANE"}]
[null,null,"ICAO airport name",null,{"$f":"'Flight log FORM'!B7","v":0},null,null,null,null,null,null,null,{"$f":"IF(E41<=0,0,LEFT(E41/1000,1)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(E41<=0,0,LEFT(E41/1000+1,1)*1000)","v":{"$error":"#VALUE!"}},null,{"$f":"E41","v":"COMPLETE THE FORM"}]
[null,null,"MSL Altitude [ft]",null,{"$f":"'Flight log FORM'!F7","v":""},null,{"$f":"IF(E39=\"\",\"COMPLETE THE FORM\",\"AIRPORT ALTITUDE OK\")","v":"COMPLETE THE FORM"},null,null,null,null,null,"look between temperatures [°C]",null,null,"needed value [°C]"]
[null,null,"QNH [hPa or mbar]",null,{"$f":"'Flight log FORM'!G7","v":""},null,{"$f":"IF(E40=\"\",\"COMPLETE THE FORM\",IF(OR(E40<960,E40>1100),\"INVALID QNH\",\"QNH OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,{"$f":"IF(E42<=0,0,LEFT(E42/10,1)*10)","v":0},{"$f":"IF(E42<=0,0,LEFT(E42/10+1,1)*10)","v":0},null,{"$f":"E42","v":0}]
[null,null,"Pressure altitude [ft]",null,{"$f":"IF(OR(E39=\"\",E40=\"\"),\"COMPLETE THE FORM\",IF(E40>1013,(E39-(E40-1013)*30),(E39+(1013-E40)*30)))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(E41=\"\",E41=\"COMPLETE THE FORM\"),\"COMPLETE THE FORM\",IF(E41>3000,\"LEANING OF MIXTURE IS RECOMMENDED\",\"LEANING OF MIXTURE NOT RECOMMENDED\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"Found & interpolated landing values (distances are in FEET)"]
[null,null,"OAT Temperature [°C]",null,{"$f":"'Flight log FORM'!J2","v":0},null,{"$f":"IF(E42=\"\",\"COMPLETE THE FORM\",IF(E42>=40,\"TEMPERATURE TOO HIGH\",\"TEMPERATURE OK\"))","v":"TEMPERATURE OK"},null,null,null,null,null,null,{"$f":"M40","v":0},null,{"$f":"P40","v":0},null,{"$f":"N40","v":0}]
[null,null,"Density altitude [ft]",null,{"$f":"IF(OR(E40=\"\",E39=\"\",E42=\"\"),\"COMPLETE THE FORM\",E41+120*(E42-(15-(1.98/1000*E41))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,null,"GRND ROLL","TOTAL TO…","GRND ROLL","TOTAL TO…","GRND ROLL","TOTAL TO…"]
[null,null,"Wind",null,null,null,null,null,null,null,null,null,"column index",{"$f":"2+(M40/10*2)","v":2},{"$f":"3+(M40/10*2)","v":3},null,null,{"$f":"2+(N40/10*2)","v":2},{"$f":"3+(N40/10*2)","v":3}]
[null,null,null,"Direction [°]",{"$f":"'Flight log FORM'!I7","v":0},null,{"$f":"IF(E45=\"\",\"COMPLETE THE FORM\",IF(OR(E45<0,E45>359),\"INVALID WIND DIRECTION\",\"WIND DIRECTION OK\"))","v":"WIND DIRECTION OK"},null,{"$f":"IF(OR(E45=\"\",E46=\"\",E48=\"\"),\"COMPLETE THE FORM\",IF(E46<0,\"CHECK WIND VELOCITY\",IF(ABS(O52)>=15,\"CROSSWIND TOO STRONG\",IF(R51=\"USE OTHER RUNWAY DIRECTION\",\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",ROUND(ABS(O51),1)&\"kts \"&P51&\" AND \" & ROUND(ABS(O52),1)&\"kts \"&P52))))","v":"COMPLETE THE FORM"},null,null,null,{"$f":"M38","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M45,'C152 Performance specs'!$B$20:$L$28,'Performance FORM'!N$44,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M45,'C152 Performance specs'!$B$20:$L$28,'Performance FORM'!O$44,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M45,'C152 Performance specs'!$B$20:$L$28,'Performance FORM'!R$44,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M45,'C152 Performance specs'!$B$20:$L$28,'Performance FORM'!S$44,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Velocity [kts]",{"$f":"'Flight log FORM'!J7","v":0},null,{"$f":"IF(E46=\"\",\"COMPLETE THE FORM\",IF(E46<0,\"INVALID WIND VELOCITY\",\"WIND VELOCITY OK\"))","v":"WIND VELOCITY OK"},null,null,null,null,null,{"$f":"P38","v":"COMPLETE THE FORM"},{"$f":"IF($P$38<=0,N45,N45+((N47-N45)*(($M$46-$M$45)/($M$47-$M$45))))","v":{"$error":"#VALUE!"}},{"$f":"IF($P$38<=0,O45,O45+((O47-O45)*(($M$46-$M$45)/($M$47-$M$45))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P40<=0,N46,N46+((R46-N46)*((($P$42-$N$42)/($R$42-$N$42)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(P40<=0,O46,O46+((S46-O46)*((($P$42-$N$42)/($R$42-$N$42)))))","v":{"$error":"#VALUE!"}},{"$f":"IF($P$38<=0,R45,R45+((R47-R45)*(($M$46-$M$45)/($M$47-$M$45))))","v":{"$error":"#VALUE!"}},{"$f":"IF($P$38<=0,S45,S45+((S47-S45)*(($M$46-$M$45)/($M$47-$M$45))))","v":{"$error":"#VALUE!"}}]
[null,null,"Runway",null,null,null,null,null,null,null,null,null,{"$f":"N38","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M47,'C152 Performance specs'!$B$20:$L$28,'Performance FORM'!N$44,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M47,'C152 Performance specs'!$B$20:$L$28,'Performance FORM'!O$44,FALSE)","v":{"$error":"#VALUE!"}},null,null,{"$f":"VLOOKUP($M47,'C152 Performance specs'!$B$20:$L$28,'Performance FORM'!R$44,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($M47,'C152 Performance specs'!$B$20:$L$28,'Performance FORM'!S$44,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Runway ",{"$f":"'Flight log FORM'!L7","v":""},null,{"$f":"IF(E48=\"\",\"COMPLETE THE FORM\",IF(OR(E48<0,E48>35),\"INVALID QFU\",\"QFU OK\"))","v":"COMPLETE THE FORM"}]
[null,null,null,"type",1,null,{"$f":"IF(E49=\"\",\"\",IF(E49=1,\"DEFINE TYPE\",IF(E49=2,\"PAVED\",IF(E49=3,\"GRASS\"))))","v":"DEFINE TYPE"}]
[null,null,null,"LDA [m]",{"$f":"'Flight log FORM'!M7","v":""},null,{"$f":"IF(E50=\"\",\"COMPLETE THE FORM\",IF(E50<0,\"INVALID RUNWAY LENGTH VALUE\",\"RUNWAY LENGTH VALUE OK\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,"Landing wind calculations",null,null,null,null,"change in landing distance"]
[null,null,"Safety margin for landing distance",null,0.5,null,null,null,null,null,null,null,"headwind component [kts]",null,{"$f":"E46*COS((ABS((E48*10)-E45)*PI()/180))","v":{"$error":"#VALUE!"}},{"$f":"IF(O51>=0,\"HEADWIND\",IF(O51<0,\"TAILWIND\",\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(O51>=0,O51/9*-0.1,IF(AND(O51<0,O51>=-10),ABS(O51/2*0.1),\"USE OTHER RUNWAY DIRECTION\"))","v":{"$error":"#VALUE!"}}]
[null,null,"Short field landing (flaps 30°, power off, maximum braking)",null,null,null,null,null,null,null,null,null,"crosswind component [kts]",null,{"$f":"E46*SIN((ABS((E48*10)-E45)*PI()/180))","v":{"$error":"#VALUE!"}},"CROSSWIND"]
[null,null,null,"landing IAS speed [kts]",54]
[null,null,null,"ground roll [m]",{"$f":"IF(E41=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(R51=\"USE OTHER RUNWAY DIRECTION\",\"CHANGE RUNWAY\",IF(E41>=8000,\"P.A. TOO HIGH\",IF(G49=\"PAVED\",((1+R51)*P46*(1+E51))*0.3048,IF(G49=\"GRASS\",(((1+R51)*P46+(0.45*P46))*(1+E51))*0.3048,\"COMPLETE THE FORM\")))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,null,"Looking up cruise data"]
[null,null,null,"total to clear 50ft [m]",{"$f":"IF(E41=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(R51=\"USE OTHER RUNWAY DIRECTION\",\"CHANGE RUNWAY\",IF(E41>=8000,\"P.A. TOO HIGH\",IF(G49=\"PAVED\",((1+R51)*Q46*(1+E51))*0.3048,IF(G49=\"GRASS\",(((1+R51)*Q46+(0.45*P46))*(1+E51))*0.3048,\"COMPLETE THE FORM\")))))","v":"COMPLETE THE FORM"},null,{"$f":"IF(E41=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(E41>=8000,\"PRESSURE ALTITUDE TOO HIGH\",IF(G49=\"DEFINE TYPE\",\"DEFINE TYPE OF RUNWAY\",IF(E50=\"\",\"COMPLETE THE FORM\",IF(E55=\"CHANGE RUNWAY\",\"TOO MUCH TAILWIND, USE OTHER RUNWAY DIRECTION\",IF(E55>E50,\"RUNWAY TOO SHORT\",IF(E55<=E50,\"RUNWAY LENGTH SUFFICIENT\")))))))","v":"COMPLETE THE FORM"},null,null,null,null,null,"look between PA [ft]",null,null,"needed PA-value [ft]",null,"are PA-thousands an even value?"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P56<=2000,2000,IF(P56>=12000,12000,IF(AND(P56>=10000,R56=FALSE),(LEFT(P56/1000,2)-1)*1000,IF(AND(P56>=10000,R56=TRUE),LEFT(P56/1000,2)*1000,IF(AND(P56<10000,R56=FALSE),(LEFT(P56/1000,1)-1)*1000,LEFT(P56/1000,1)*1000)))))","v":12000},{"$f":"IF(P56<=2000,2000,IF(P56>=12000,12000,M56+2000))","v":12000},null,{"$f":"E27","v":"COMPLETE THE FORM"},null,{"$f":"IF(AND(P56<10000,MOD(LEFT(P56/1000,1),2)=0),TRUE,IF(AND(P56>=10000,MOD(LEFT(P56/1000,2),2)=0),TRUE,FALSE))","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,"does RPM-value exist?",null,null,"needed RPM-value"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P56=\"\",P58=\"\",P56=0,P58=0),\"COMPLETE THE FORM\",IF(OR(ISERROR(VLOOKUP(M56&\"_\"&P58,'C152 Performance specs'!$A$33:$L$65,1,FALSE)),ISERROR(VLOOKUP(N56&\"_\"&P58,'C152 Performance specs'!$A$33:$L$65,1,FALSE))),\"RPM VALUE NOT FOUND IN DATA\",IF(AND(ISERROR(LOOKUP(\"NaN\",N66:N68)),ISERROR(LOOKUP(\"NaN\",T66:T68))),\"RPM VALUE FOUND IN DATA\",\"RPM VALUE NOT FOUND IN DATA\")))","v":"RPM VALUE NOT FOUND IN DATA"},null,null,{"$f":"VLOOKUP(E29,O4:P12,2,FALSE)","v":"SELECT VALUE"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Temperature"]
[null,null,null,null,null,null,null,null,null,null,null,null,"standard temperature at PA [°C]",null,{"$f":"15-(1.98/1000*E27)","v":{"$error":"#VALUE!"}},"needed temperature [°C]",null,{"$f":"E28","v":0},null,"is temp above or below standard temp?",null,null,null,{"$f":"IF(OR(ISERROR(O61),E28=\"\"),\"COMPLETE THE FORM\",IF(R61<O61,\"BELOW\",\"ABOVE\"))","v":"COMPLETE THE FORM"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Found & interpolated cruise values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M56&\"_\"&P58","v":"12000_SELECT VALUE"},null,null,{"$f":"P56&\"_\"&P58","v":"COMPLETE THE FORM_SELECT VALUE"},null,null,{"$f":"N56&\"_\"&P58","v":"12000_SELECT VALUE"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"20°C below... ","Standard temp","20° above…","20°C below... ","Standard temp","20° above…","20°C below... ","Standard temp","20° above…"]
[null,null,null,null,null,null,null,null,null,null,null,null,"%BHP",{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,10,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(N56=M56,N66,($P$56-$M$56)/($N$56-$M$56)*(T66-N66)+N66)","v":{"$error":"#N/A"}},{"$f":"IF(M56=N56,O66,($P$56-$M$56)/($N$56-$M$56)*(U66-O66)+O66)","v":{"$error":"#N/A"}},{"$f":"IF(M56=N56,P66,($P$56-$M$56)/($N$56-$M$56)*(V66-P66)+P66)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,10,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"KTAS [kts]",{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,11,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(N56=M56,N67,($P$56-$M$56)/($N$56-$M$56)*(T67-N67)+N67)","v":{"$error":"#N/A"}},{"$f":"IF(M56=N56,O67,($P$56-$M$56)/($N$56-$M$56)*(U67-O67)+O67)","v":{"$error":"#N/A"}},{"$f":"IF(M56=N56,P67,($P$56-$M$56)/($N$56-$M$56)*(V67-P67)+P67)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,11,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"GPH",{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($N$64,'C152 Performance specs'!$A$33:$L$65,12,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(N56=M56,N68,($P$56-$M$56)/($N$56-$M$56)*(T68-N68)+N68)","v":{"$error":"#N/A"}},{"$f":"IF(M56=N56,O68,($P$56-$M$56)/($N$56-$M$56)*(U68-O68)+O68)","v":{"$error":"#N/A"}},{"$f":"IF(M56=N56,P68,($P$56-$M$56)/($N$56-$M$56)*(V68-P68)+P68)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($T$64,'C152 Performance specs'!$A$33:$L$65,12,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"including temperature interpolation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%BHP",{"$f":"IF($X$61=\"ABOVE\",R66+($R$61-$O$61)/(20)*(S66-R66),IF($X$61=\"BELOW\",Q66+($R$61-($O$61-20))/(20)*(R66-Q66)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KTAS",{"$f":"IF($X$61=\"ABOVE\",R67+($R$61-$O$61)/(20)*(S67-R67),IF($X$61=\"BELOW\",Q67+($R$61-($O$61-20))/(20)*(R67-Q67)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GPH",{"$f":"IF($X$61=\"ABOVE\",R68+($R$61-$O$61)/(20)*(S68-R68),IF($X$61=\"BELOW\",Q68+($R$61-($O$61-20))/(20)*(R68-Q68)))","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"KTAS -> KCAS -> KIAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAS [kts]",{"$f":"E33","v":"COMPLETE THE FORM"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"CAS [kts]",{"$f":"E33-(E25/1000*0.02*E33)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Interpolation of IAS [kts]",null,{"$f":"HLOOKUP(O80,'C152 Performance specs'!C69:M71,3,FALSE)","v":{"$error":"#VALUE!"}},null,{"$f":"O79+1","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"KCAS [kts]",{"$f":"LOOKUP(N77,'C152 Performance specs'!C69:M69)","v":{"$error":"#VALUE!"}},{"$f":"N77","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP(Q79,'C152 Performance specs'!C68:M70,2,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"KIAS [kts]",{"$f":"HLOOKUP(O80,'C152 Performance specs'!$C$69:$M$70,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"O81+((P80-O81)/(Q80-O81)*(Q81-O81))","v":{"$error":"#VALUE!"}},{"$f":"HLOOKUP(Q80,'C152 Performance specs'!$C$69:$M$70,2,FALSE)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Selected aircraft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Flight log FORM'!E2","v":1},{"$f":"VLOOKUP(N84,'Flight log FORM'!AD13:AE17,2,FALSE)","v":"SELECT"},"-> associated max weight",null,{"$f":"VLOOKUP(O84,N86:O89,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"max weight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OO-VCL",{"$f":"MAX('OO-VCL'!C16:C20)","v":757}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OO-BET",{"$f":"MAX('OO-BET'!C16:C20)","v":757}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OO-VCR",{"$f":"MAX('OO-VCR'!C16:C20)","v":757}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OO-VCM",{"$f":"MAX('OO-VCM'!C16:C20)","v":757}]

{"sheet":"W&B FORM","index":4,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,4,3,6],[5,12,5,15],[10,12,11,12],[7,14,11,15],[10,5,10,6],[11,5,11,6],[9,5,9,6],[8,5,8,6],[7,5,7,6],[33,26,33,28],[33,29,33,30],[33,31,34,31],[45,1,45,15],[4,12,4,15],[25,19,25,21],[12,12,12,15],[14,12,14,15],[6,19,6,20],[16,12,16,15],[15,12,15,15]]}
[null,{"$f":"Introduction!A5","v":"remarks? tony.opsomer@gmail.com"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!E5","v":"version 2023-07-15"}]
[null,{"$f":"\"Weight and Balance form C152 \" &D5&\" \"&IF(OR('Performance FORM'!E6=0,'Performance FORM'!E38=0),\"\",\" (from \"&'Performance FORM'!E6&\" to \"&'Performance FORM'!E38&\")\")","v":"Weight and Balance form C152  "},null,null,null,null,null,null,null,null,null,null,null,null,null,"BE.DTO.113",null,null,null,"Calculations"]
[]
[null,"Select C152 aircraft:",null,{"$f":"'Flight log FORM'!E2","v":1}]
[null,null,null,{"$f":"IF(D4=1,\"\",IF(D4=2,\"OO-VCL\",IF(D4=3,\"OO-BET\",IF(D4=4,\"OO-VCR\",IF(D4=5,\"OO-VCM\",\"SELECT AIRPLANE\")))))","v":""},null,null,null,"Fuel quantity","Weight ","Arm","Moment",null,"Form validity checker"]
[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 engine oil and unusable fuel)",null,null,null,null,null,null,{"$f":"IF($D$5=\"OO-VCL\",'OO-VCL'!$C7,IF($D$5=\"OO-BET\",'OO-BET'!$C7,IF($D$5=\"OO-VCR\",'OO-VCR'!$C7,IF($D$5=\"OO-VCM\",'OO-VCM'!$C7,\"SELECT AIRPLANE\"))))","v":"SELECT AIRPLANE"},{"$f":"IF($D$5=\"OO-VCL\",'OO-VCL'!$C8,IF($D$5=\"OO-BET\",'OO-BET'!$C8,IF($D$5=\"OO-VCR\",'OO-VCR'!$C8,IF($D$5=\"OO-VCM\",'OO-VCM'!$C8,\"SELECT AIRPLANE\"))))","v":"SELECT AIRPLANE"},{"$f":"IF($D$5=\"OO-VCL\",'OO-VCL'!$C9,IF($D$5=\"OO-BET\",'OO-BET'!$C9,IF($D$5=\"OO-VCR\",'OO-VCR'!$C9,IF($D$5=\"OO-VCM\",'OO-VCM'!$C9,\"SELECT AIRPLANE\"))))","v":"SELECT AIRPLANE"},null,null,null,null,null,null,null,null,"dropdown list"]
[null,"Usable fuel ",null,"mean arm:",{"$f":"IF(OR(D5=\"OO-BET\",D5=\"OO-VCL\"),39,IF(OR(D5=\"OO-VCR\",D5=\"OO-VCM\"),42,\"SELECT AIRPLANE\"))","v":"SELECT AIRPLANE"},"inch",null,{"$f":"IF(D4=1,\"\",VLOOKUP(D5,'Flight log FORM'!AF41:'Flight log FORM'!AG44,2,FALSE))","v":""},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",IF(H8=\"\",0,H8*0.72))","v":"SELECT AIRPLANE"},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",E8*2.54/100)","v":"SELECT AIRPLANE"},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",I8*J8)","v":"SELECT AIRPLANE"},null,{"$f":"IF(OR(AND(D5<>\"OO-VCL\",D5<>\"OO-BET\",D5<>\"OO-VCR\",D5<>\"OO-VCM\"),H8=\"\"),\"COMPLETE THE FORM\",IF(H8>IF(OR(D5=\"OO-VCL\",D5=\"OO-BET\"),141.9,IF(OR(D5=\"OO-VCR\",D5=\"OO-VCM\"),92.7,)),\"FUEL TANK OVERFLOW\",\"FUEL QUANTITY WITHIN LIMIT\"))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(AND(D5<>\"OO-VCL\",D5<>\"OO-BET\",D5<>\"OO-VCR\",D5<>\"OO-VCM\"),H8=\"\",I9=\"\",I10=\"\",I11=\"\",I12=\"\"),\"COMPLETE THE FORM\",IF(SUM(I7:I12)>MAX(U17:U21),\"TOO MUCH USEFUL LOAD\",\"TOTAL USEFUL LOAD WITHIN LIMIT\"))","v":"COMPLETE THE FORM"},null,null,null,null,1,"SELECT AIRPLANE"]
[null,"Pilot",null,"mean arm:",39,"inch",null,null,null,{"$f":"E9*2.54/100","v":0.99060000000000004},{"$f":"I9*J9","v":0},null,null,null,null,null,null,null,null,2,"OO-VCL"]
[null,"Front passenger",null,"mean arm:",39,"inch",null,null,null,{"$f":"E10*2.54/100","v":0.99060000000000004},{"$f":"I10*J10","v":0},null,null,null,null,null,null,null,null,3,"OO-BET"]
[null,"Baggage area 1",null,"mean arm:",64,"inch",null,null,null,{"$f":"E11*2.54/100","v":1.6255999999999999},{"$f":"I11*J11","v":0},null,{"$f":"IF(OR(AND(D5<>\"OO-VCL\",D5<>\"OO-BET\",D5<>\"OO-VCR\",D5<>\"OO-VCM\"),I11=\"\",I12=\"\"),\"COMPLETE THE FORM\",IF(I11>54.4,\"TOO MUCH BAGGAGE IN AREA 1\",IF(I12>18.1,\"TOO MUCH BAGGAGE IN AREA 2\",IF(SUM(I11:I12)>54.4,\"TOO MUCH BAGGAGE IN AREA 1 AND 2\",\"PARTITIONING OF BAGGAGE IN AREAS 1 AND 2 WITHIN LIMITS\"))))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,4,"OO-VCR"]
[null,"Baggage area 2",null,"mean arm:",84,"inch",null,null,null,{"$f":"E12*2.54/100","v":2.1335999999999999},{"$f":"I12*J12","v":0},null,null,null,null,null,null,null,null,5,"OO-VCM"]
[null,"RAMP WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",I12=\"\",I7=\"SELECT AIRPLANE\"),\"COMPLETE THE FORM\",SUM(I7:I12))","v":"COMPLETE THE FORM"},{"$f":"IF(I13=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",K13/I13)","v":"COMPLETE THE FORM"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",I12=\"\",I7=\"SELECT AIRPLANE\"),\"COMPLETE THE FORM\",SUM(K7:K12))","v":"COMPLETE THE FORM"},null,{"$f":"IF(I13=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",\"CHECK RESULTS IN GRAPH BELOW\")","v":"COMPLETE THE FORM"}]
[null,"Fuel allowance for engine start, taxi and runup",null,null,null,null,null,{"$f":"'C152 Performance specs'!C74*3.785412","v":3.0283296000000002},{"$f":"H14*0.72","v":2.1803973120000002},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",E8*2.54/100)","v":"SELECT AIRPLANE"},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",I14*J14)","v":"SELECT AIRPLANE"}]
[null,"TAKE-OFF WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",I12=\"\",H14=\"\",I7=\"SELECT AIRPLANE\"),\"COMPLETE THE FORM\",I13-I14)","v":"COMPLETE THE FORM"},{"$f":"IF(I15=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",K15/I15)","v":"COMPLETE THE FORM"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",I12=\"\",H14=\"\",I7=\"SELECT AIRPLANE\"),\"COMPLETE THE FORM\",K13-K14)","v":"COMPLETE THE FORM"},null,{"$f":"IF(I15=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",\"CHECK RESULTS IN GRAPH BELOW\")","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"graph data"]
[null,"Total trip time",null,null,{"$f":"IF(ISERROR(X30),\"\",X30)","v":"00:00:00"},"hh:mm",null,{"$f":"(HOUR(E16)*60+MINUTE(E16))/60*'Flight log FORM'!L3","v":0},{"$f":"H16*0.72","v":0},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",E8*2.54/100)","v":"SELECT AIRPLANE"},{"$f":"IF(E8=\"SELECT AIRPLANE\",\"SELECT AIRPLANE\",I16*J16)","v":"SELECT AIRPLANE"},null,{"$f":"IF(OR(E16=\"\",H8=\"\",I7=\"SELECT AIRPLANE\"),\"COMPLETE THE FORM\",IF((H16+H14)>H8,\"NOT ENOUGH FUEL TO COMPLETE THE TRIP\",IF((H16+H14)>(H8-'Flight log FORM'!L3/60*45),\"DANGER! DANGER! FUEL RESERVE LESS THAN 45 MIN\",\"TRIP TIME WITHIN LIMIT\")))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"arm [m]","weight [kg]"]
[null,"LANDING WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",I12=\"\",E16=\"\",H14=\"\",I7=\"SELECT AIRPLANE\"),\"COMPLETE THE FORM\",IF(M16=\"TRIP TIME TOO BIG\",\"CHECK TRIP TIME\",I15-I16))","v":"COMPLETE THE FORM"},{"$f":"IF(I17=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(I17=\"CHECK TRIP TIME\",\"CHECK TRIP TIME\",K17/I17))","v":"COMPLETE THE FORM"},{"$f":"IF(OR(H8=\"\",E16=\"\",I9=\"\",I10=\"\",I11=\"\",I12=\"\",H14=\"\",I7=\"SELECT AIRPLANE\"),\"COMPLETE THE FORM\",IF(M16=\"TRIP TIME TOO BIG\",\"CHECK TRIP TIME\",K15-K16))","v":"COMPLETE THE FORM"},null,{"$f":"IF(I17=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(I17=\"CHECK TRIP TIME\",\"\",\"CHECK RESULTS IN GRAPH BELOW\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!B16,IF($D$5=\"OO-BET\",'OO-BET'!B16,IF($D$5=\"OO-VCR\",'OO-VCR'!B16,IF($D$5=\"OO-VCM\",'OO-VCM'!B16,\"\")))))","v":""},{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!C16,IF($D$5=\"OO-BET\",'OO-BET'!C16,IF($D$5=\"OO-VCR\",'OO-VCR'!C16,IF($D$5=\"OO-VCM\",'OO-VCM'!C16,\"\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!B17,IF($D$5=\"OO-BET\",'OO-BET'!B17,IF($D$5=\"OO-VCR\",'OO-VCR'!B17,IF($D$5=\"OO-VCM\",'OO-VCM'!B17,\"\")))))","v":""},{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!C17,IF($D$5=\"OO-BET\",'OO-BET'!C17,IF($D$5=\"OO-VCR\",'OO-VCR'!C17,IF($D$5=\"OO-VCM\",'OO-VCM'!C17,\"\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!B18,IF($D$5=\"OO-BET\",'OO-BET'!B18,IF($D$5=\"OO-VCR\",'OO-VCR'!B18,IF($D$5=\"OO-VCM\",'OO-VCM'!B18,\"\")))))","v":""},{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!C18,IF($D$5=\"OO-BET\",'OO-BET'!C18,IF($D$5=\"OO-VCR\",'OO-VCR'!C18,IF($D$5=\"OO-VCM\",'OO-VCM'!C18,\"\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!B19,IF($D$5=\"OO-BET\",'OO-BET'!B19,IF($D$5=\"OO-VCR\",'OO-VCR'!B19,IF($D$5=\"OO-VCM\",'OO-VCM'!B19,\"\")))))","v":""},{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!C19,IF($D$5=\"OO-BET\",'OO-BET'!C19,IF($D$5=\"OO-VCR\",'OO-VCR'!C19,IF($D$5=\"OO-VCM\",'OO-VCM'!C19,\"\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!B20,IF($D$5=\"OO-BET\",'OO-BET'!B20,IF($D$5=\"OO-VCR\",'OO-VCR'!B20,IF($D$5=\"OO-VCM\",'OO-VCM'!B20,\"\")))))","v":""},{"$f":"(IF($D$5=\"OO-VCL\",'OO-VCL'!C20,IF($D$5=\"OO-BET\",'OO-BET'!C20,IF($D$5=\"OO-VCR\",'OO-VCR'!C20,IF($D$5=\"OO-VCM\",'OO-VCM'!C20,\"\")))))","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conversion minutes  to hh:mm notation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hh","mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total minutes",{"$f":"'Flight log FORM'!K39","v":0},null,{"$f":"TRUNC(U28/60,0)","v":0},{"$f":"ROUND((U28/60-TRUNC(U28/60))*60,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hh:mm",{"$f":"TIME(W28,X28,)","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This document is provided for secondary flightplanning and navigation only. It is the user/pilot's sole responsibility to verify the correctness of all  information provided by this sheet. "]

{"sheet":"C152 Performance specs","index":5,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,1,1,11],[4,1,5,1],[17,10,17,11],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[17,1,18,1],[2,1,2,11],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[30,1,31,1],[30,2,31,2],[30,3,30,5],[30,6,30,8],[30,9,30,11]]}
[]
[null,"DATA C152*"]
[null,"* ALL DATA IS BASED ON THE CESSNA MODEL 152 HANDBOOK, 1 JULY 1978"]
[null,"TAKEOFF DISTANCE","[ft]","(assume takeoff weight of 1670 lbs = 757 kg)",null,null,null,null,null,null,"DATA FOUND ON PAGE 5-11"]
[null,"Pressure altitude [ft]","0°C",null,"10°C",null,"20°C",null,"30°C",null,"40°C"]
[null,null,"GRND ROLL","TOTAL TO CLEAR 50 FT OBS","GRND ROLL","TOTAL TO CLEAR 50 FT OBS","GRND ROLL","TOTAL TO CLEAR 50 FT OBS","GRND ROLL","TOTAL TO CLEAR 50 FT OBS","GRND ROLL","TOTAL TO CLEAR 50 FT OBS"]
[null,0,640,1190,695,1290,755,1390,810,1495,875,1605]
[null,1000,705,1310,765,1420,825,1530,890,1645,960,1770]
[null,2000,775,1445,840,1565,910,1690,980,1820,1055,1960]
[null,3000,855,1600,925,1730,1000,1870,1080,2020,1165,2185]
[null,4000,940,1775,1020,1920,1100,2080,1190,2250,1285,2440]
[null,5000,1040,1970,1125,2140,1215,2320,1315,2525,1420,2750]
[null,6000,1145,2200,1245,2395,1345,2610,1455,2855,1570,3125]
[null,7000,1270,2470,1375,2705,1490,2960,1615,3255,1745,3590]
[null,8000,1405,2800,1525,3080,1655,3395,1795,3765,1940,4195]
[]
[null,"LANDING DISTANCE","[ft]","(assume landing weight of 1670 lbs = 757 kg)",null,null,null,null,null,null,"DATA FOUND ON PAGE 5-19"]
[null,"Pressure altitude [ft]","0°C",null,"10°C",null,"20°C",null,"30°C",null,"40°C"]
[null,null,"GRND ROLL","TOTAL TO CLEAR 50 FT OBS","GRND ROLL","TOTAL TO CLEAR 50 FT OBS","GRND ROLL","TOTAL TO CLEAR 50 FT OBS","GRND ROLL","TOTAL TO CLEAR 50 FT OBS","GRND ROLL","TOTAL TO CLEAR 50 FT OBS"]
[null,0,450,1160,465,1185,485,1215,500,1240,515,1265]
[null,1000,465,1185,485,1215,500,1240,520,1270,535,1295]
[null,2000,485,1215,500,1240,520,1270,535,1300,555,1330]
[null,3000,500,1240,520,1275,540,1305,560,1335,575,1360]
[null,4000,520,1275,540,1305,560,1335,580,1370,600,1400]
[null,5000,540,1305,560,1335,580,1370,600,1400,620,1435]
[null,6000,560,1340,580,1370,605,1410,625,1440,645,1475]
[null,7000,585,1375,605,1410,625,1440,650,1480,670,1515]
[null,8000,605,1410,630,1450,650,1480,675,1520,695,1555]
[]
[null,"CRUISE PERFORMANCE",null,"(assume takeoff weight of 1670 lbs = 757 kg, leaning as recommended in POH)",null,null,null,null,null,null,"DATA FOUND ON PAGE 5-14"]
[null,"Pressure altitude [ft]","RPM","20°C BELOW STANDARD TEMP",null,null,"STANDARD TEMP",null,null,"20°C ABOVE STANDARD TEMP"]
[null,null,null,"% BHP","KTAS","GPH","% BHP","KTAS","GPH","% BHP","KTAS","GPH"]
[{"$f":"B33&\"_\"&C33","v":"2000_2400"},2000,2400,"NaN","NaN","NaN",75,101,6.1,70,101,5.7]
[{"$f":"B34&\"_\"&C34","v":"2000_2300"},2000,2300,71,97,5.7,66,96,5.4,63,95,5.0999999999999996]
["2000_2200",2000,2200,62,92,5.0999999999999996,59,91,4.8,56,90,4.5999999999999996]
["2000_2100",2000,2100,55,87,4.5,53,86,4.3,51,85,4.2]
["2000_2000",2000,2000,49,81,4.0999999999999996,47,80,3.9,46,79,3.8]
["4000_2450",4000,2450,"NaN","NaN","NaN",75,103,6.1,70,102,5.7]
["4000_2400",4000,2400,76,102,6.1,71,101,5.7,67,100,5.4]
["4000_2300",4000,2300,67,96,5.4,63,95,5.0999999999999996,60,95,4.9000000000000004]
["4000_2200",4000,2200,60,91,4.8,56,90,4.5999999999999996,54,89,4.4000000000000004]
["4000_2100",4000,2100,53,86,4.4000000000000004,51,85,4.2,49,84,4]
["4000_2000",4000,2000,48,81,3.9,46,80,3.8,45,78,3.7]
["6000_2500",6000,2500,"NaN","NaN","NaN",75,105,6.1,71,104,5.7]
["6000_2400",6000,2400,72,101,5.8,67,100,5.4,64,99,5.2]
["6000_2300",6000,2300,64,96,5.2,60,95,4.9000000000000004,57,94,4.7]
["6000_2200",6000,2200,57,90,4.5999999999999996,54,89,4.4000000000000004,52,88,4.3]
["6000_2100",6000,2100,51,85,4.2,49,84,4,48,83,3.9]
["6000_2000",6000,2000,46,80,3.8,45,79,3.7,44,77,3.6]
["8000_2550",8000,2550,"NaN","NaN","NaN",75,107,6.1,71,106,5.7]
["8000_2500",8000,2500,76,105,6.2,71,104,5.8,67,103,5.4]
["8000_2400",8000,2400,68,100,5.5,64,99,5.2,61,98,4.9000000000000004]
["8000_2300",8000,2300,61,95,5,58,94,4.7,55,93,4.5]
["8000_2200",8000,2200,55,90,4.5,52,89,4.3,51,87,4.2]
["8000_2100",8000,2100,49,84,4.0999999999999996,48,83,3.9,46,82,3.8]
["10000_2500",10000,2500,72,105,5.8,68,103,5.5,64,103,5.2]
["10000_2400",10000,2400,65,99,5.3,61,98,5,58,97,4.8]
["10000_2300",10000,2300,58,94,4.7,56,93,4.5,53,92,4.4000000000000004]
["10000_2200",10000,2200,53,89,4.3,51,88,4.2,49,86,4]
["10000_2100",10000,2100,48,83,4,46,82,3.9,45,81,3.8]
["12000_2450",12000,2450,65,101,5.3,62,100,5,59,99,4.8]
["12000_2400",12000,2400,62,99,5,59,97,4.8,56,96,4.5999999999999996]
["12000_2300",12000,2300,56,93,4.5999999999999996,54,92,4.4000000000000004,52,91,4.3]
["12000_2200",12000,2200,51,88,4.2,49,87,4.0999999999999996,48,85,4]
["12000_2100",12000,2100,47,82,3.9,45,81,3.8,44,79,3.7]
[]
[null,"AIRSPEED CALIBRATION",null,"(only \"flaps up\"-data are given!)",null,null,null,null,null,null,"DATA FOUND ON PAGE 5-8"]
[null,null,1,2,3,4,5,6,7,8,9,10,11]
[null,"KCAS",46,53,60,69,78,88,97,107,117,127,136]
[null,"KIAS",40,50,60,70,80,90,100,110,120,130,140]
[null,null,1,2,3,4,5,6,7,8,9,10,11]
[]
[null,"FUEL NEEDED FOR ENGINE START, TAXI AND TAKEOFF ALLOWANCE",null,null,null,null,null,null,null,null,"DATA FOUND ON PAGE 5-13"]
[null,null,0.8,"US GALLONS"]

{"sheet":"OO-VCL","index":6,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[null,"DATA OO-VCL"]
[null,"LONG-RANGE FUEL TANKS"]
[null,"Max fuel quantity",37.5,"US Gal",{"$f":"C4*3.785412","v":141.95294999999999},"l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BASED ON"]
[null,"W&B DATA"]
[null,"Empty Weight",{"$f":"L7*0.45359237","v":587.46562208180012},"kg",null,null,null,null,null,null,null,1295.1400000000001,"lbs"]
[null,"Arm",{"$f":"L8*0.0254","v":0.81424780000000008},"m",null,null,null,null,null,null,null,32.057000000000002,"in"]
[null,"Moment ",{"$f":"L9*0.45359237*0.0254","v":478.33471235801181},"m.kg",null,null,null,null,null,null,null,41517.619200000001,"in.lbs"]
[]
[null,"Max Useful load",{"$f":"L11*0.45359237","v":170.03363581820003},"kg",null,null,null,null,null,null,null,374.86,"lbs"]
[null,"(normal category)"]
[]
[null,"W&B Center of Gravity limits graph"]
[null,"arm [m]","weight [kg]"]
[null,0.78700000000000003,0]
[null,0.78700000000000003,612]
[null,0.82899999999999996,757]
[null,0.92700000000000005,757]
[null,0.92700000000000005,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Compass deviation correction table"]
[null,"FOR",0,30,60,90,120,150,180,210,240,270,300,330,360]
[null,"STEER",2,32,62,92,121,150,180,210,240,270,300,331,{"$f":"C67+360","v":362}]

{"sheet":"OO-BET","index":7,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[null,"DATA OO-BET"]
[null,"LONG-RANGE FUEL TANKS"]
[null,"Max fuel quantity",37.5,"US Gal",{"$f":"C4*3.785412","v":141.95294999999999},"l"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BASED ON"]
[null,"W&B DATA"]
[null,"Empty Weight",{"$f":"L7*0.45359237","v":536.47730377009998},"kg",null,null,null,null,null,null,null,1182.73,"lbs"]
[null,"Arm",{"$f":"L8*0.0254","v":0.79286099999999993},"m",null,null,null,null,null,null,null,31.215,"in"]
[null,"Moment ",{"$f":"L9*0.45359237*0.0254","v":425.35441955758165},"m.kg",null,null,null,null,null,null,null,36919.132899999997,"in.lbs"]
[]
[null,"Max Useful load",{"$f":"L11*0.45359237","v":221.0219541299},"kg",null,null,null,null,null,null,null,487.27,"lbs"]
[null,"(normal category)"]
[]
[null,"W&B Center of Gravity limits graph"]
[null,"arm [m]","weight [kg]"]
[null,0.78700000000000003,0]
[null,0.78700000000000003,612]
[null,0.82899999999999996,757]
[null,0.92700000000000005,757]
[null,0.92700000000000005,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Compass deviation correction table"]
[null,"FOR",0,30,60,90,120,150,180,210,240,270,300,330,360]
[null,"STEER",2,30,59,92,120,150,180,210,241,271,300,330,{"$f":"C67+360","v":362}]

{"sheet":"OO-VCR","index":8,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[null,"DATA OO-VCR"]
[null,"STANDARD RANGE FUEL TANKS"]
[null,"Max fuel quantity",24.5,"US Gal",{"$f":"C4*3.785412","v":92.742593999999997},"l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BASED ON"]
[null,"W&B DATA"]
[null,"Empty Weight",{"$f":"L7*0.45359237","v":538.64547529870003},"kg",null,null,null,null,null,null,null,1187.51,"lbs"]
[null,"Arm",{"$f":"L8*0.0254","v":0.7847329999999999},"m",null,null,null,null,null,null,null,30.895,"in"]
[null,"Moment ",{"$f":"L9*0.45359237*0.0254","v":422.69043438306932},"m.kg",null,null,null,null,null,null,null,36687.909200000002,"in.lbs"]
[]
[null,"Max Useful load",{"$f":"L11*0.45359237","v":218.85378260130003},"kg",null,null,null,null,null,null,null,482.49,"lbs"]
[null,"(utility category)"]
[]
[null,"W&B Center of Gravity limits graph"]
[null,"arm [m]","weight [kg]"]
[null,{"$f":"31*0.0254","v":0.78739999999999999},0]
[null,{"$f":"31*0.0254","v":0.78739999999999999},612]
[null,{"$f":"32.65*0.0254","v":0.82930999999999988},757]
[null,{"$f":"36.5*0.0254","v":0.92709999999999992},757]
[null,{"$f":"36.5*0.0254","v":0.92709999999999992},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Compass deviation correction table"]
[null,"FOR",0,30,60,90,120,150,180,210,240,270,300,330,360]
[null,"STEER",3,32,62,88,118,151,183,212,240,273,303,333,{"$f":"C67+360","v":363}]

{"sheet":"OO-VCM","index":9,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[null,"DATA OO-VCM"]
[null,"STANDARD RANGE FUEL TANKS"]
[null,"Max fuel quantity",24.5,"US Gal",{"$f":"C4*3.785412","v":92.742593999999997},"l"]
[]
[null,"W&B DATA",null,null,null,null,null,"BASED ON"]
[null,"Empty Weight",{"$f":"J7*0.45359237","v":537.88797604080003},"kg",null,null,null,null,null,1185.8399999999999,"lbs"]
[null,"Arm",{"$f":"J8*0.0254","v":0.77876400000000001},"m",null,null,null,null,null,30.66,"in"]
[null,"Moment ",{"$f":"J9*0.45359237*0.0254","v":418.85847711461139},"m.kg",null,null,null,null,null,36355.31,"in.lbs"]
[]
[null,"Max Useful load",{"$f":"J11*0.45359237","v":219.61128185920003},"kg",null,null,null,null,null,484.16,"lbs"]
[null,"(normal category)"]
[]
[null,"W&B Center of Gravity limits graph"]
[null,"arm [m]","weight [kg]"]
[null,{"$f":"31*0.0254","v":0.78739999999999999},0]
[null,{"$f":"31*0.0254","v":0.78739999999999999},612]
[null,{"$f":"32.65*0.0254","v":0.82930999999999988},757]
[null,{"$f":"36.5*0.0254","v":0.92709999999999992},757]
[null,{"$f":"36.5*0.0254","v":0.92709999999999992},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Compass deviation correction table"]
[null,"FOR",0,30,60,90,120,150,180,210,240,270,300,330,360]
[null,"STEER",0,30,60,90,120,150,178,210,240,273,300,330,{"$f":"C67+360","v":360}]