{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["WeightBalance","AircraftData"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":0,"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":"1904"}

{"sheet":"WeightBalance","index":0,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[{"$f":"CONCATENATE(\"Weight and Balance Worksheet v\",AircraftData!B24)","v":"Weight and Balance Worksheet v1.4"},null,{"$f":"AircraftData!B13","v":"DR400-140"},null,{"$f":"AircraftData!C13","v":"2022-08-22"},"English","F-BUHP",null,{"$f":"AircraftData!W20","v":"<== Select aircraft"},{"$f":"MATCH(G1,AircraftData!A3:A5,0)","v":2},{"$f":"MATCH(F1,AircraftData!A16:A17,0)","v":1}]
[{"$f":"AircraftData!X20","v":"Item"},null,{"$f":"AircraftData!P20","v":"Max allowed"},null,{"$f":"AircraftData!Q20","v":"Weight"},{"$f":"AircraftData!R20","v":"Arm"},{"$f":"AircraftData!S20","v":"Moment"}]
[{"$f":"AircraftData!B20","v":"Empty Weight"},{"$f":"AircraftData!O20","v":"Variable data"},null,null,{"$f":"AircraftData!L13","v":603},{"$f":"AircraftData!M13","v":0.315},{"$f":"F3*E3","v":189.94499999999999}]
[{"$f":"AircraftData!C20","v":"Pilot"},null,null,null,{"$f":"B4","v":0},{"$f":"AircraftData!Q13","v":0.41},{"$f":"F4*E4","v":0}]
[{"$f":"AircraftData!D20","v":"Passenger"},null,null,null,{"$f":"B5","v":0},{"$f":"AircraftData!Q13","v":0.41},0]
[{"$f":"IF(F6=0,\"\",AircraftData!E20)","v":"Passenger Left"},null,{"$f":"AircraftData!I13","v":125},null,{"$f":"B6","v":0},{"$f":"AircraftData!R13","v":1.19},0]
[{"$f":"IF(F7=0,\"\",AircraftData!F20)","v":"Passenger Right"},null,{"$f":"AircraftData!J13","v":125},null,{"$f":"B7","v":0},{"$f":"AircraftData!R13","v":1.19},0]
[{"$f":"AircraftData!G20","v":"Baggage Area"},null,{"$f":"AircraftData!K13","v":40},null,{"$f":"B8","v":0},{"$f":"AircraftData!S13","v":1.9},0]
[{"$f":"AircraftData!H20","v":"Fuel main tank"},null,{"$f":"AircraftData!F13","v":110},{"$f":"C9*AVGAStoKG","v":79.2},{"$f":"B9*AVGAStoKG","v":0},{"$f":"AircraftData!N13","v":1.1200000000000001},{"$f":"F9*E9","v":0}]
[{"$f":"IF(F10=0,\"\",AircraftData!I20)","v":"Fuel supplementary tank"},null,{"$f":"AircraftData!G13","v":50},{"$f":"C10*AVGAStoKG","v":36},{"$f":"B10*AVGAStoKG","v":0},{"$f":"AircraftData!O13","v":1.61},{"$f":"F10*E10","v":0}]
[{"$f":"IF(F11=0,\"\",AircraftData!J20)","v":""},null,{"$f":"AircraftData!H13","v":0},{"$f":"C11*AVGAStoKG","v":0},{"$f":"B11*AVGAStoKG","v":0},{"$f":"AircraftData!P13","v":0},{"$f":"F11*E11","v":0}]
[{"$f":"AircraftData!K20","v":"Trip fuel used:"}]
[{"$f":"AircraftData!L20","v":"Trip fuel main tank"},null,null,null,{"$f":"B13*AVGAStoKG","v":0},{"$f":"AircraftData!N13","v":1.1200000000000001},0]
[{"$f":"IF(F10=0,\"\",AircraftData!M20)","v":"Trip fuel supplementary tanks"},null,null,null,{"$f":"B14*AVGAStoKG","v":0},{"$f":"AircraftData!O13","v":1.61},0]
[{"$f":"IF(F11=0,\"\",AircraftData!N20)","v":""},null,null,null,{"$f":"B15*AVGAStoKG","v":0},{"$f":"AircraftData!P13","v":0},0]
[]
[{"$f":"AircraftData!T20","v":"Total "},null,{"$f":"AircraftData!D13","v":1000},null,{"$f":"ROUNDDOWN(SUM(E3:E11),0)","v":603},{"$f":"G17/E17","v":0.315},{"$f":"SUM(G3:G11)","v":189.94499999999999},null,{"$f":"AircraftData!V20","v":"Remaining Payload"}]
[{"$f":"AircraftData!U20","v":"Total after fuel burn"},null,{"$f":"AircraftData!E13","v":1000},null,{"$f":"E17-(E13+E14+E15)","v":603},{"$f":"G18/E18","v":0.315},{"$f":"G17-(G13+G14+G15)","v":189.94499999999999},null,{"$f":"C17-E17","v":397}]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"AircraftData!AE20","v":"Date created"}]
[null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2023-03-10T16:52:08.120"}]
[null,null,null,null,null,null,null,null,{"$f":"AircraftData!AF20","v":"By"}]
[null,null,null,null,null,null,null,null,false]
[]
["Utility",null,"Landing",null,null,"Normal"]
[{"$f":"AircraftData!V13","v":124},{"$f":"AircraftData!W13","v":587},{"$f":"AircraftData!E13","v":1000},null,null,{"$f":"AircraftData!AF13","v":124},{"$f":"AircraftData!AG13","v":606}]
[{"$f":"AircraftData!X13","v":154},{"$f":"AircraftData!Y13","v":750},{"$f":"C28","v":1000},null,null,{"$f":"AircraftData!AH13","v":154},{"$f":"AircraftData!AI13","v":750},null,"This document is not an official document. It is intended to help pilots to prepare the weight and balance of the aircraft. Weight and balance is a compulsory document that must be filled out before each flight. Weight and balance must be done with the proper aircraft document. "]
[{"$f":"AircraftData!Z13","v":390},{"$f":"AircraftData!AA13","v":910},{"$f":"MIN(F28:F33)","v":124},null,null,{"$f":"AircraftData!AJ13","v":428},{"$f":"AircraftData!AK13","v":1000}]
[{"$f":"AircraftData!AB13","v":514},{"$f":"AircraftData!AC13","v":910},{"$f":"MAX(F28:F33)","v":564},null,null,{"$f":"AircraftData!AL13","v":520},{"$f":"AircraftData!AM13","v":1000},null,"Ce document n’est pas un document officiel. Il est destiné à aider les pilotes à préparer la masse et centrage de l’avion qui est un document obligatoire à préparer avant tout vol. La masse et centrage doit être préparé à partir de la fiche de pesée de l’avion"]
[{"$f":"AircraftData!AD13","v":342},{"$f":"AircraftData!AE13","v":606},null,null,null,{"$f":"AircraftData!AN13","v":564},{"$f":"AircraftData!AO13","v":1000}]
[null,null,null,null,null,{"$f":"AircraftData!AP13","v":342},{"$f":"AircraftData!AQ13","v":606}]

{"sheet":"AircraftData","index":1,"n_rows":26,"n_cols":43,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Aircraft data",null,null,"Maximums ",null,null,null,null,null,null,null,"Empty","Arms",null,null,null,null,null,null,"Graph limits",null,"Graph Data Utility Category",null,null,null,null,null,null,null,null,null,"Graph Data Normal Category"]
["Call sign","Type","Weight Report","Weight KG","Landing KG","Main Tank Ltr","Sup Tank Ltr","Wing Tank Ltr","Left Rear Pax KG","Right Rear Pax KG","Bagage KG","Weight","Empty","Main Tank","Sup Tank","Wing Tank","Front Seats","Back Seats","Bagage","Hor Min","Vert Min","UM1","UW1","UM2","UW2","UM3","UW3","UM4","UW4","UM5","UW5","NM1","NW1","NM2","NW2","NM3","NW3","NM4","NW4","NM5","NW5","NM6","NW6"]
["F-HCLY","DR400-180","2013-11-21",1100,1054,110,50,80,125,125,40,666,0.32400000000000001,1.1200000000000001,1.61,0.1,0.41,1.19,1.9,100,650,120,666,150,750,400,950,540,950,380,666,120,666,150,750,420,1100,520,1100,625,1100,380,666]
["F-BUHP","DR400-140","2022-08-22",1000,1000,110,50,0,125,125,40,603,0.315,1.1200000000000001,1.61,0,0.41,1.19,1.9,100,600,124,587,154,750,390,910,514,910,342,606,124,606,154,750,428,1000,520,1000,564,1000,342,606]
["F-HIRJ","DR400-120","2010-08-11",900,850,110,0,0,0,0,40,565,0.33,1.1200000000000001,0,0,0.41,0,1.9,100,550,125,575,150,750,350,900,500,900,320,575,125,575,150,750,350,900,500,900,320,575,320,575]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"CHOOSE(WeightBalance!$J$1,A3,A4,A5,A6,A7,A8,A9,A10,A1,A12)","v":"F-BUHP"},{"$f":"CHOOSE(WeightBalance!$J$1,B3,B4,B5)","v":"DR400-140"},{"$f":"CHOOSE(WeightBalance!$J$1,C3,C4,C5)","v":"2022-08-22"},{"$f":"CHOOSE(WeightBalance!$J$1,D3,D4,D5)","v":1000},{"$f":"CHOOSE(WeightBalance!$J$1,E3,E4,E5)","v":1000},{"$f":"CHOOSE(WeightBalance!$J$1,F3,F4,F5)","v":110},{"$f":"CHOOSE(WeightBalance!$J$1,G3,G4,G5)","v":50},{"$f":"CHOOSE(WeightBalance!$J$1,H3,H4,H5)","v":0},{"$f":"CHOOSE(WeightBalance!$J$1,I3,I4,I5)","v":125},{"$f":"CHOOSE(WeightBalance!$J$1,J3,J4,J5)","v":125},{"$f":"CHOOSE(WeightBalance!$J$1,K3,K4,K5)","v":40},{"$f":"CHOOSE(WeightBalance!$J$1,L3,L4,L5)","v":603},{"$f":"CHOOSE(WeightBalance!$J$1,M3,M4,M5)","v":0.315},{"$f":"CHOOSE(WeightBalance!$J$1,N3,N4,N5)","v":1.1200000000000001},{"$f":"CHOOSE(WeightBalance!$J$1,O3,O4,O5)","v":1.61},{"$f":"CHOOSE(WeightBalance!$J$1,P3,P4,P5)","v":0},{"$f":"CHOOSE(WeightBalance!$J$1,Q3,Q4,Q5)","v":0.41},{"$f":"CHOOSE(WeightBalance!$J$1,R3,R4,R5)","v":1.19},{"$f":"CHOOSE(WeightBalance!$J$1,S3,S4,S5)","v":1.9},{"$f":"CHOOSE(WeightBalance!$J$1,T3,T4,T5)","v":100},{"$f":"CHOOSE(WeightBalance!$J$1,U3,U4,U5)","v":600},{"$f":"CHOOSE(WeightBalance!$J$1,V3,V4,V5)","v":124},{"$f":"CHOOSE(WeightBalance!$J$1,W3,W4,W5)","v":587},{"$f":"CHOOSE(WeightBalance!$J$1,X3,X4,X5)","v":154},{"$f":"CHOOSE(WeightBalance!$J$1,Y3,Y4,Y5)","v":750},{"$f":"CHOOSE(WeightBalance!$J$1,Z3,Z4,Z5)","v":390},{"$f":"CHOOSE(WeightBalance!$J$1,AA3,AA4,AA5)","v":910},{"$f":"CHOOSE(WeightBalance!$J$1,AB3,AB4,AB5)","v":514},{"$f":"CHOOSE(WeightBalance!$J$1,AC3,AC4,AC5)","v":910},{"$f":"CHOOSE(WeightBalance!$J$1,AD3,AD4,AD5)","v":342},{"$f":"CHOOSE(WeightBalance!$J$1,AE3,AE4,AE5)","v":606},{"$f":"CHOOSE(WeightBalance!$J$1,AF3,AF4,AF5)","v":124},{"$f":"CHOOSE(WeightBalance!$J$1,AG3,AG4,AG5)","v":606},{"$f":"CHOOSE(WeightBalance!$J$1,AH3,AH4,AH5)","v":154},{"$f":"CHOOSE(WeightBalance!$J$1,AI3,AI4,AI5)","v":750},{"$f":"CHOOSE(WeightBalance!$J$1,AJ3,AJ4,AJ5)","v":428},{"$f":"CHOOSE(WeightBalance!$J$1,AK3,AK4,AK5)","v":1000},{"$f":"CHOOSE(WeightBalance!$J$1,AL3,AL4,AL5)","v":520},{"$f":"CHOOSE(WeightBalance!$J$1,AM3,AM4,AM5)","v":1000},{"$f":"CHOOSE(WeightBalance!$J$1,AN3,AN4,AN5)","v":564},{"$f":"CHOOSE(WeightBalance!$J$1,AO3,AO4,AO5)","v":1000},{"$f":"CHOOSE(WeightBalance!$J$1,AP3,AP4,AP5)","v":342},{"$f":"CHOOSE(WeightBalance!$J$1,AQ3,AQ4,AQ5)","v":606}]
[]
["Languages"]
["English","Empty Weight","Pilot","Passenger","Passenger Left","Passenger Right","Baggage Area","Fuel main tank","Fuel supplementary tank","Fuel wing tanks","Trip fuel used:","Trip fuel main tank","Trip fuel supplementary tanks","Trip fuel wing tanks","Variable data","Max allowed","Weight","Arm","Moment","Total ","Total after fuel burn","Remaining Payload","<== Select aircraft","Item","Normal Category","Utility Category","Take Off","Landing","Total Moment (kg.m)","Total Weight (kg)","Date created","By","Pls enter your name","Files saved as","Error: Invalid Value","Max landing weight"]
["Francais","Masse a vide","Pilote","Passager Avant","Passager Gauche","Passager Droit","Bagages soute ","Essence Principal","Essence auxiliaire","Essence ailes","Délestage","Délestage principal","Délestage auxiliaire","Délestage ailes ","Données du Jour","Maximum","Masse (kg)","Bras de Levier (m)","Moment (kg.m)","Totale","Totale apres Délestage","Charge utile restante","< == Sélectionnez avion","Objet","Catégorie normale","Catégorie utilitaire","Décollage","Atterissage","Moment Totale (kg.m)","Mass Totale (kg)","Date de création","Par","Veuillez entrer votre nom","Fichiers enregistrés comme","Erreur : Valeur non valide","Max poid a l'atterisage"]
[]
[]
[{"$f":"CHOOSE(WeightBalance!$K$1,A16,A17,A18,A19)","v":"English"},{"$f":"CHOOSE(WeightBalance!$K$1,B16,B17,B18,B19)","v":"Empty Weight"},{"$f":"CHOOSE(WeightBalance!$K$1,C16,C17,C18,C19)","v":"Pilot"},{"$f":"CHOOSE(WeightBalance!$K$1,D16,D17,D18,D19)","v":"Passenger"},{"$f":"CHOOSE(WeightBalance!$K$1,E16,E17,E18,E19)","v":"Passenger Left"},{"$f":"CHOOSE(WeightBalance!$K$1,F16,F17,F18,F19)","v":"Passenger Right"},{"$f":"CHOOSE(WeightBalance!$K$1,G16,G17,G18,G19)","v":"Baggage Area"},{"$f":"CHOOSE(WeightBalance!$K$1,H16,H17,H18,H19)","v":"Fuel main tank"},{"$f":"CHOOSE(WeightBalance!$K$1,I16,I17,I18,I19)","v":"Fuel supplementary tank"},{"$f":"CHOOSE(WeightBalance!$K$1,J16,J17,J18,J19)","v":"Fuel wing tanks"},{"$f":"CHOOSE(WeightBalance!$K$1,K16,K17,K18,K19)","v":"Trip fuel used:"},{"$f":"CHOOSE(WeightBalance!$K$1,L16,L17,L18,L19)","v":"Trip fuel main tank"},{"$f":"CHOOSE(WeightBalance!$K$1,M16,M17,M18,M19)","v":"Trip fuel supplementary tanks"},{"$f":"CHOOSE(WeightBalance!$K$1,N16,N17,N18,N19)","v":"Trip fuel wing tanks"},{"$f":"CHOOSE(WeightBalance!$K$1,O16,O17,O18,O19)","v":"Variable data"},{"$f":"CHOOSE(WeightBalance!$K$1,P16,P17,P18,P19)","v":"Max allowed"},{"$f":"CHOOSE(WeightBalance!$K$1,Q16,Q17,Q18,Q19)","v":"Weight"},{"$f":"CHOOSE(WeightBalance!$K$1,R16,R17,R18,R19)","v":"Arm"},{"$f":"CHOOSE(WeightBalance!$K$1,S16,S17,S18,S19)","v":"Moment"},{"$f":"CHOOSE(WeightBalance!$K$1,T16,T17,T18,T19)","v":"Total "},{"$f":"CHOOSE(WeightBalance!$K$1,U16,U17,U18,U19)","v":"Total after fuel burn"},{"$f":"CHOOSE(WeightBalance!$K$1,V16,V17,V18,V19)","v":"Remaining Payload"},{"$f":"CHOOSE(WeightBalance!$K$1,W16,W17,W18,W19)","v":"<== Select aircraft"},{"$f":"CHOOSE(WeightBalance!$K$1,X16,X17,X18,X19)","v":"Item"},{"$f":"CHOOSE(WeightBalance!$K$1,Y16,Y17,Y18,Y19)","v":"Normal Category"},{"$f":"CHOOSE(WeightBalance!$K$1,Z16,Z17,Z18,Z19)","v":"Utility Category"},{"$f":"CHOOSE(WeightBalance!$K$1,AA16,AA17,AA18,AA19)","v":"Take Off"},{"$f":"CHOOSE(WeightBalance!$K$1,AB16,AB17,AB18,AB19)","v":"Landing"},{"$f":"CHOOSE(WeightBalance!$K$1,AC16,AC17,AC18,AC19)","v":"Total Moment (kg.m)"},{"$f":"CHOOSE(WeightBalance!$K$1,AD16,AD17,AD18,AD19)","v":"Total Weight (kg)"},{"$f":"CHOOSE(WeightBalance!$K$1,AE16,AE17,AE18,AE19)","v":"Date created"},{"$f":"CHOOSE(WeightBalance!$K$1,AF16,AF17,AF18,AF19)","v":"By"},{"$f":"CHOOSE(WeightBalance!$K$1,AG16,AG17,AG18,AG19)","v":"Pls enter your name"},{"$f":"CHOOSE(WeightBalance!$K$1,AH16,AH17,AH18,AH19)","v":"Files saved as"},{"$f":"CHOOSE(WeightBalance!$K$1,AI16,AI17,AI18,AI19)","v":"Error: Invalid Value"},{"$f":"CHOOSE(WeightBalance!$K$1,AJ16,AJ17,AJ18,AJ19)","v":"Max landing weight"}]
[]
["Assorted fields",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q18=0,\"\",\"Fuel wingtanks\")","v":""}]
["AVGAS to KG",0.72]
["version",1.4]
["password","acalbertville"]
["StrictMode","N"]