{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[" Ne remplir que les cases jaunes, le reste est automatique !"]
[]
[" MASSE et CENTRAGE pour ROBIN DR 400-120 F-GNNS"]
[]
[" Parcours:"]
[]
[" Carburant 100 LL   Charge total max. 900 kg",null,null,null,null,null,null,"Total diff. ASFC to Alt/FL",4500,"ft"]
[null,null,null,null,"Distance totale (Nm)",78,null,"Nombre total de TKOF",1]
[]
[" Roulage"," 5'/roul => 3 l/roul. (forfait)",null,null,null,"Avions","Masses","Moments"]
[" Montée"," 0,5 l/min &  2,7Nm/1000 ft &  2'/1000 ft",null,null,null,"F-GNNS","5559Kg","165 kg.m"]
[" Croisière"," Vp = 100 kt/h  => 0,4 l/min",null,null,null," ",null," "]
[" Approche"," 10'/app => 4 l/app (forfait)",null,null,null," "," "," "]
[" Réserve finale"," Jour: 20' => 8 l  Nuit: 45' => 18 l",null,null,null," "," "," "]
[null,null,null,null,null," "," "," "]
[" Plein Carburant"," 110 l x 0,72 kg/l = 79 kg",null,null,null," "," "," "]
[]
[" Limitations opérationnelles: TKOF…….....….kg        En route:……..…… kg          LND: …………………..kg"]
[]
[" Prévisions carburant.",null,null,null,null," RA: délestage + 10% + 20 min."]
[null,null,null,null,null," max. réservoire: 110 l = 79 kg"]
[]
[null,"Distance (Nm)","Temps (min)","Carburant (l)",null," Délestage/consom.",null,{"$f":"D29","v":27.282400000000003}," litres"]
[" Roulage(s)","forfait",{"$f":"I8*5","v":5},{"$f":"C24*3/5","v":3},null," + 10 % Réserve",null,{"$f":"0.1*H23","v":2.7282400000000004}," litres"]
[" + Montée(s)",{"$f":"500*C25*2.72/1000","v":12.24},{"$f":"(I7*2/1000)*I8","v":9},{"$f":"0.5*C25","v":4.5},null," + Dégagement(s)",null,20," litres"]
[" + Croisière(s)",{"$f":"F8-B25","v":65.760000000000005},{"$f":"B26*60/100","v":39.456000000000003},{"$f":"0.4*C26","v":15.782400000000003},null," + 20' Réserve jour",null,8," litres"]
[" + Approche(s)","forfait",{"$f":"10*I8","v":10},{"$f":"4*I8","v":4},null," + Fond réservoire",null,10," litres"]
[null,null,null,null,null," = Min carbur. RA (l)",null,{"$f":"H23+H24+H25+H26+H27","v":68.010639999999995},{"$f":"0.72*H28","v":48.967660799999997},"kg"]
[" = Total ",{"$f":"B26+B25","v":78},{"$f":"C24+C25+C26+C27","v":63.456000000000003},{"$f":"D24+D25+D26+D27","v":27.282400000000003}]
[]
[null,null,null,null,null," Carburant utile",null,{"$f":"H28+H29","v":68.010639999999995},{"$f":"I28+I29","v":48.967660799999997},"kg"]
["Chargement",null,null,null,null,{"$f":"IF(H31<110,\"\",\"ATTENTION, RESERVOIR INSUFFISANT !\")","v":""}]
[]
[" Limitation utile (selon perf.et/ou piste)",null,900," kg",null," Carbur embarqué (l)",null,90,{"$f":"0.72*H34","v":64.8},"kg"]
[" - Masse avion à vide (selon manuel)",null,559," kg",null," - Min carbur RA (l)",null,{"$f":"H31","v":68.010639999999995},{"$f":"I31","v":48.967660799999997},"kg"]
[" = Charge offerte",null,{"$f":"C34-C35","v":341}," kg",null," = Réserve supp. (l)",null,{"$f":"H34-H35","v":21.989360000000005},{"$f":"I34-I35","v":15.8323392},"kg"]
[" - carburant embarqué",null,{"$f":"I34","v":64.8}," kg",null,{"$f":"IF(H36>0,\"\",\"QUANTITE FUEL INSUFFISANT !\")","v":""}]
[" = Charge autorisée Pax+soute",null,{"$f":"C36-C37","v":276.2}," kg",null," => Autonomie supplément.",null,null,{"$f":"H36/0.4","v":54.973400000000012}]
[" - Charge réelle Pax + soute",null,{"$f":"B49+B50+B51","v":245}," kg",null,"       disponible pour vol palier",null,null," minutes"]
[]
[" = Charge offerte restante",null,{"$f":"C38-C39","v":31.199999999999989}," kg",null,{"$f":"IF(H34<110.1,\"\",\"CAPACITE RESERVOIR = MAX 110 l  !!!\")","v":""}]
[{"$f":"IF(C34<900.1,\"\",\"LIMITE UTILE > CHARGE MAX AVION !\")","v":""},null,{"$f":"IF(C41<0,\"SURCHARGE !\",\"\")","v":""}]
[]
[" CALCUL  CENTRAGE",null,null,null,null,null,"CENTROGRAMME"]
[]
[null,"Masses","bras levier","Moments"]
[null," (kg)"," (m)"," (kg.m)"]
[" Masse à vide",559,"x 0,334 =",{"$f":"0.334*B48","v":186.70600000000002}]
[" + Pax avant",165," x 0,41 =",{"$f":"0.41*B49","v":67.649999999999991}]
[" + Pax arrière",50," x 1,19 =",{"$f":"1.19*B50","v":59.5}]
[" + Soute (40 kg)",30," x 1,90 =",{"$f":"1.9*B51","v":57}]
[]
[" = Tot. hors fuel",{"$f":"B48+B49+B50+B51","v":804},{"$f":"D53/B53","v":0.46126368159203979},{"$f":"D48+D49+D50+D51","v":370.85599999999999}]
[]
[" + Fuel emb. (Kg)",{"$f":"I34","v":64.8}," x 1,12 =",{"$f":"1.12*B55","v":72.576000000000008}]
[]
[" = Masse TKOF",{"$f":"B53+B55","v":868.8},{"$f":"D57/B57","v":0.51039594843462255},{"$f":"D53+D55","v":443.43200000000002}]
[]
[{"$f":"IF(B57<=900,\"\",\"DANGER, masse TKOF > masse tolérences avion !!!\")","v":""}]
[{"$f":"IF(B57<=C34,\"\",\"DANGER, masse TKOF > Limitation utile !\")","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["leviers","Masses",null,"leviers calculés","Masse calculée",null,null,null,null,null,null,null,"Masse"]
[0.20499999999999999,600,null,{"$f":"Feuil1!C53","v":0.46126368159203979},{"$f":"Feuil1!B53","v":804},null,null,null,null,null,null,"2005-02-01",550]
[0.20499999999999999,750,null,{"$f":"Feuil1!C57","v":0.51039594843462255},{"$f":"Feuil1!B57","v":868.8},null,null,null,null,null,null,"2005-02-01",700]
[0.42799999999999999,900,null,null,null,null,null,null,null,null,null,"2005-02-03",900]
[0.56399999999999995,900,null,null,null,null,null,null,null,null,null,"2005-02-05",900]
[0.56399999999999995,600,null,null,null,null,null,null,null,null,null,"2005-02-05",550]
[]
["DR 400-120"]