{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Modèle","Masses","Motorisation","Centrage_Vlongi_TP","Cotes réelles","Convertisseur"],"not_rendered":{"charts":1,"images":74,"macros":1,"external_links":0,"defined_names":209,"comments":5,"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":"Modèle","index":0,"n_rows":165,"n_cols":48,"rows_kept":165,"cut":false,"hidden":false,"merged":[[44,30,44,31],[44,32,44,33],[1,10,1,11],[1,14,1,15],[1,16,1,22],[3,16,3,17],[5,17,5,19],[66,10,66,12],[63,10,63,12],[21,44,21,45],[3,28,3,33],[26,32,26,33],[64,10,64,12],[65,10,65,12],[3,24,3,26],[35,32,35,33],[62,10,62,12],[37,36,37,37],[56,24,56,26],[8,24,8,26],[12,24,12,26],[17,24,17,26],[50,36,50,37],[22,46,22,47],[61,10,61,12],[3,42,3,47],[60,10,60,12],[13,44,13,45],[47,24,47,26],[41,28,41,29],[22,24,22,26],[27,24,27,26],[32,24,32,26],[37,24,37,26],[42,24,42,26],[49,39,49,40],[13,42,13,43],[3,36,3,40],[40,39,40,40],[38,5,38,7],[65,1,65,3],[63,1,63,3],[44,5,44,7],[62,5,62,7],[55,5,55,7],[57,5,57,7],[56,1,56,3],[23,41,23,42],[5,10,5,15],[1,2,1,5],[48,5,48,7],[3,1,3,3],[3,5,3,7],[37,1,37,3],[18,1,18,3],[32,5,32,7],[16,5,16,7],[23,5,23,7],[27,5,27,7],[23,1,23,3],[14,1,14,3],[13,5,13,7],[35,5,35,7]]}
[]
[null,null,"Corotrainer",null,null,null,null,null,null,null,"Mise en croix",null,"Bulle","Hélice","Repères du fuselage",null,"Train d'atterrissage"]
[]
[null,"Aile",null,null,null,"Stab",null,null,null,null,"Aile","Stab",null,null,null,null,"Bicycle",null,null,"Tricycle",null,"Aucun",null,null,"Fuselage (cotes en mm)",null,null,null,"vue de dessus",null,null,null,null,null,null,null,"vue de profil",null,null,null,null,null,"Vue de face"]
[null,"Surface Alaire (dm²)",23,null,null,"Surface du stab (dm²)",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur aile / ligne ref fus",70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x ligne ref","y ligne ref","x roue d","y roue d","x fus nez","y fus nez"]
[null,"Allongement",{"$f":"((Env_complete*Env_complete)/Surface_Alaire)/10000","v":4.3478260869565215},null,null,"Allongement",{"$f":"((Env_stab*Env_stab)/Surface_Stab)/10000","v":3.2},null,null,null,"Lissages",null,null,null,null,null,null,"Rotation de l'hélice",null,null,null,null,null,null,"Hauteur stab / ligne ref fus",0,null,null,"x aile d","y aile d","x stab d","y stab d","x axe","y axe",null,null,"x ligne ref","y ligne ref",null,"x cone","y cone",null,{"$f":"xg_ligne_ref","v":-445},{"$f":"-Longueur_fuselage/1.1","v":-809.09090909090901},{"$f":"AS13","v":87.199532074984731},{"$f":"AT13+(Diametre_roues/2)","v":-931.09090909090901},{"$f":"Couple1_Largeur/2","v":40},{"$f":"AR6-Couple1_Hauteur_bas","v":-839.09090909090901}]
[null,"Envergure (mm)",1000,"mm",null,"Effilement",1,null,null,null,"Bulle",null,"Fuselage",null,"Aile",null,null,-43,null,null,null,null,null,null,"Longueur cône",40,null,null,{"$f":"0","v":0},{"$f":"(Longueur_fuselage-Couple3_Position)","v":750},{"$f":"0","v":0},{"$f":"Longueur_fuselage-Couple7_Position","v":125},{"$f":"(Longueur_fuselage+Longueur_cone)*1.1","v":1023.0000000000001},0,null,null,{"$f":"-(Longueur_fuselage)/2","v":-445},{"$f":"-(Longueur_fuselage/3)","v":-296.66666666666669},null,{"$f":"xg_ligne_ref","v":-445},{"$f":"y_ligne_ref+(Diametre_cone/2)","v":-286.66666666666669},null,{"$f":"-AQ6","v":445},{"$f":"AR6","v":-809.09090909090901},{"$f":"AS13","v":87.199532074984731},{"$f":"AT13-(Diametre_roues/2)","v":-996.09090909090901},{"$f":"AU6","v":40},{"$f":"AR6+Couple1_Hauteur_haut","v":-769.09090909090901}]
[null,"Effilement",1,null,null,"Env panneau (mm)",{"$f":"Env_stab/2","v":200},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diamètre du cône",20,null,null,{"$f":"Env_panneau_aile+AC7","v":500},{"$f":"AD7-Fleche_aile","v":750},{"$f":"Env_Panneau_Stab+AE7","v":200},{"$f":"(AF7-Fleche_stab)","v":125},{"$f":"-(AG7)","v":-1023.0000000000001},0,null,null,{"$f":"-xg_ligne_ref","v":445},{"$f":"-(Longueur_fuselage/3)","v":-296.66666666666669},null,{"$f":"xg_ligne_ref-Longueur_cone","v":-485},{"$f":"y_ligne_ref","v":-296.66666666666669},null,"x stab d","y stab d","x stab g","y stab g",{"$f":"-AU6","v":-40},{"$f":"AV7","v":-769.09090909090901}]
[null,"Env panneau",{"$f":"Env_complete/2","v":500},"mm",null,"Env totale (mm)",400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Couple 1 nez",null,null,null,{"$f":"AC8","v":500},{"$f":"-Csau_aile+AD8","v":520},{"$f":"AE8","v":200},{"$f":"-Csau_stab+AF8","v":0},{"$f":"(Longueur_fuselage+Longueur_cone)*1.1","v":1023.0000000000001},0,null,null,"x fus profil","y fus profil",null,{"$f":"xg_ligne_ref","v":-445},{"$f":"y_ligne_ref-(Diametre_cone/2)","v":-306.66666666666669},null,{"$f":"Couple7_Largeur/2","v":17.5},{"$f":"AR6+Hauteur_stab","v":-809.09090909090901},{"$f":"-AQ9","v":-17.5},{"$f":"AR9","v":-809.09090909090901},{"$f":"-AU6","v":-40},{"$f":"AV6","v":-839.09090909090901}]
[null,"Flèche (mm)",0,null,null,"Env complète avec fuselage",{"$f":"Env_stab","v":400},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur",80,null,null,{"$f":"0","v":0},{"$f":"-Cemp_aile+AD7","v":520},{"$f":"0","v":0},{"$f":"Longueur_fuselage-Couple8_Position","v":0},{"$f":"-AG9","v":-1023.0000000000001},0,null,1,{"$f":"xg_ligne_ref","v":-445},{"$f":"y_ligne_ref+Couple1_Hauteur_haut","v":-256.66666666666669},null,"x bulle","y bulle",null,{"$f":"AQ9+G8","v":217.5},{"$f":"AR9","v":-809.09090909090901},{"$f":"-AQ10","v":-217.5},{"$f":"AR10","v":-809.09090909090901},{"$f":"AU6","v":40},{"$f":"AV6","v":-839.09090909090901}]
[null,"Dièdre (°)",0,null,null,"Flèche (mm)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bout nez haut",40,null,null,"x aile g","y aile g","x stab g","y stab g",{"$f":"IF(AG7>AG9,ROUND(AG7,0),ROUND(AG9,0))","v":1023},{"$f":"-AG11","v":-1023},null,2,{"$f":"xg_ligne_ref+Couple2_Position","v":-365},{"$f":"y_ligne_ref+Couple2_Hauteur_haut","v":-251.66666666666669},null,{"$f":"xg_ligne_ref+Position_début_bulle","v":-175},{"$f":"y_ligne_ref+Hauteur_début_bulle","v":-243.66666666666669},null,"x derive","y derive","x train d","y train d","x fus aile","y fus aile"]
[null,"En mm de haut au saumon",{"$f":"(SIN(RADIANS(Diedre)))*Env_panneau_aile","v":0},"mm",null,"Corde emplanture",{"$f":"((2*(Env_stab))/A_stab)/(1+Eff_stab)","v":125},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bout nez bas",30,null,null,{"$f":"-AC7","v":0},{"$f":"AD7","v":750},{"$f":"-AE7","v":0},{"$f":"AF7","v":125},"x cone","y cone",null,3,{"$f":"xg_ligne_ref+Couple3_Position","v":-305},{"$f":"y_ligne_ref+Couple3_Hauteur_haut","v":-226.66666666666669},null,{"$f":"xg_ligne_ref+Position_milieu1_bulle","v":-103},{"$f":"y_ligne_ref+Hauteur_milieu1_bulle","v":-216.66666666666669},null,0,{"$f":"AR6+Position_Derive_Verticale","v":-794.09090909090901},0,{"$f":"AR6-Couple3_Hauteur_bas","v":-839.09090909090901},{"$f":"Couple3_Largeur/2","v":40},{"$f":"AR6-Couple3_Hauteur_bas","v":-839.09090909090901}]
[null,"Corde emplanture",{"$f":"((2*(Env_panneau_aile*2))/A_aile)/(1+Eff_aile)","v":230},"mm",null,"Corde saumon",{"$f":"Eff_stab*Cemp_stab","v":125},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Couple 2",null,null,null,{"$f":"-AC8","v":-500},{"$f":"AD8","v":750},{"$f":"-AE8","v":-200},{"$f":"AF8","v":125},{"$f":"Diametre_cone/2","v":10},{"$f":"Longueur_fuselage","v":890},null,4,{"$f":"xg_ligne_ref+Couple4_Position","v":-75},{"$f":"y_ligne_ref+Couple4_Hauteur_haut","v":-226.66666666666669},null,{"$f":"xg_ligne_ref+Position_milieu2_bulle","v":-15},{"$f":"y_ligne_ref+Hauteur_milieu2_bulle","v":-236.66666666666669},null,0,{"$f":"AR12+Hauteur_Derive","v":-656.1598746081504},{"$f":"Voie_du_train","v":87.199532074984731},{"$f":"AT12-Hauteur_train_central","v":-963.59090909090901},{"$f":"AU12","v":40},{"$f":"AR6+Couple3_Hauteur_haut","v":-739.09090909090901}]
[null,"Corde saumon",{"$f":"Eff_aile*Cemp_aile","v":230},"mm",null,"Volet de profondeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position",80,null,null,{"$f":"-AC9","v":-500},{"$f":"AD9","v":520},{"$f":"-AE9","v":-200},{"$f":"AF9","v":0},0,{"$f":"Longueur_fuselage+Longueur_cone","v":930},null,5,{"$f":"xg_ligne_ref+Couple5_Position","v":-25},{"$f":"y_ligne_ref+Couple5_Hauteur_Haut","v":-261.66666666666669},null,{"$f":"xg_ligne_ref+Position_fin_bulle","v":55},{"$f":"y_ligne_ref+Hauteur_fin_bulle","v":-266.66666666666669},null,"Hélice",null,"train avant",null,{"$f":"-AU12","v":-40},{"$f":"AV13","v":-739.09090909090901}]
[null,"Aileron Fullspan",null,null,null,"%Surface du stab (%)",30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur",80,null,null,{"$f":"-AC10","v":0},{"$f":"AD10","v":520},{"$f":"-AE10","v":0},{"$f":"AF10","v":0},{"$f":"-AG13","v":-10},{"$f":"Longueur_fuselage","v":890},null,6,{"$f":"xg_ligne_ref+Couple6_Position","v":225},{"$f":"y_ligne_ref+Couple6_Hauteur_Haut","v":-281.66666666666669},null,"x derive","y derive",null,{"$f":"(SIN(RADIANS(Angle_tourne_helice)))*((Diametre_Helice_Libre/2)*25.4)","v":-86.613791727937311},{"$f":"AR6+(((Diametre_Helice_Libre/2)*25.4)*COS(RADIANS(Angle_tourne_helice)))","v":-716.20898898527435},0,{"$f":"AR6-Couple2_Hauteur_bas","v":-839.09090909090901},{"$f":"AU14","v":-40},{"$f":"AV12","v":-839.09090909090901}]
[null,"Prof en %cam (%)",15,null,null,"Largeur",{"$f":"((Surface_volet_prof)*10000)/Env_stab","v":37.5},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur haut",45,null,null,"x fus","y fus","x foyer m","y foyer m","x roue d","y roue d",null,7,{"$f":"xg_ligne_ref+Couple7_Position","v":320},{"$f":"y_ligne_ref+Couple7_Hauteur_haut","v":-281.66666666666669},null,{"$f":"xd_ligne_ref+Position_Derive_Horizontale","v":520},{"$f":"y_ligne_ref+Position_Derive_Verticale","v":-281.66666666666669},null,{"$f":"-AQ15","v":86.613791727937311},{"$f":"AR6-(((Diametre_Helice_Libre/2)*25.4)*COS(RADIANS(Angle_tourne_helice)))","v":-901.97282919654367},0,{"$f":"AT15-Hauteur_roulette_de_nez","v":-939.09090909090901},{"$f":"AU12","v":40},{"$f":"AV12","v":-839.09090909090901}]
[null,"Longueur",{"$f":"Env_panneau_aile","v":500},"mm",null,"Dérive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bas",30,null,1,{"$f":"Couple1_Largeur/2","v":40},{"$f":"Longueur_fuselage","v":890},{"$f":"Couple3_Largeur/2","v":40},{"$f":"Longueur_fuselage-Couple3_Position-Foyer_modele_emp_TP","v":672.20018810900456},{"$f":"Voie_du_train","v":87.199532074984731},{"$f":"AH23+(Diametre_roues/2)+Inclinaison_train_central_mm","v":763.18368362025274},null,8,{"$f":"xg_ligne_ref+Couple8_Position","v":445},{"$f":"y_ligne_ref+Couple8_Hauteur_haut","v":-281.66666666666669},null,{"$f":"AN16","v":520},{"$f":"AO16+Hauteur_Derive","v":-143.73563218390805},null,"x aile d","y aile d","x aile g","y aile g","x train g","y train g"]
[null,"Largeur (profondeur)",{"$f":"(Aileron_full_pourcent_CAM/100)*Cam_Aile","v":34.5},"mm",null,"%Surface du stab (%)",40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Couple 3 emplanture Aile",null,null,2,{"$f":"Couple2_Largeur/2","v":40},{"$f":"Longueur_fuselage-Couple2_Position","v":810},{"$f":"-AE17","v":-40},{"$f":"AF17","v":672.20018810900456},{"$f":"AG17","v":87.199532074984731},{"$f":"AH23-(Diametre_roues/2)+Inclinaison_train_central_mm","v":698.18368362025274},null,8,{"$f":"xg_ligne_ref+Couple8_Position","v":445},{"$f":"y_ligne_ref-Couple8_Hauteur_bas","v":-326.66666666666669},null,{"$f":"AN17-Largeur_Haute_derive","v":430},{"$f":"AO17","v":-143.73563218390805},null,0,{"$f":"AR6+Hauteur_aile","v":-739.09090909090901},{"$f":"-AQ18","v":0},{"$f":"AR18","v":-739.09090909090901},0,{"$f":"AT12","v":-839.09090909090901}]
[null,"Aileron en bout d'aile",null,null,null,"Largeur Haute (mm)",90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position",{"$f":"Longueur_du_nez-Longueur_cone","v":140},"mm",3,{"$f":"Couple3_Largeur/2","v":40},{"$f":"Longueur_fuselage-Couple3_Position","v":750},"x foyer a","y foyer a","x roue g","y roue g",null,7,{"$f":"xg_ligne_ref+Couple7_Position","v":320},{"$f":"y_ligne_ref-Couple7_Hauteur_bas","v":-326.66666666666669},null,{"$f":"AN16-Largeur_Basse_derive","v":320},{"$f":"AO16","v":-281.66666666666669},null,{"$f":"(AQ18+Env_panneau_aile+Couple3_Largeur/2)*COS(RADIANS(Diedre))","v":540},{"$f":"AR18+Diedre_mm","v":-739.09090909090901},{"$f":"-AQ19","v":-540},{"$f":"AR19","v":-739.09090909090901},{"$f":"-Voie_du_train","v":-87.199532074984731},{"$f":"AT13","v":-963.59090909090901}]
[null,"Prof en %cam (%)",15,null,null,"Largeur Basse (mm)",200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur",80,null,4,{"$f":"Couple4_Largeur/2","v":40},{"$f":"Longueur_fuselage-Couple4_Position","v":520},{"$f":"AC19","v":40},{"$f":"Longueur_fuselage-Couple3_Position-Foyer_aile_à_emp_bord_attaque","v":692.5},{"$f":"-AG17","v":-87.199532074984731},{"$f":"AH17","v":763.18368362025274},null,6,{"$f":"xg_ligne_ref+Couple6_Position","v":225},{"$f":"y_ligne_ref-Couple6_Hauteur_Bas","v":-326.66666666666669},null,{"$f":"AN16","v":520},{"$f":"AO16","v":-281.66666666666669},null,{"$f":"AQ19","v":540},{"$f":"AR19+Epaisseur_max_profil","v":-711.83590909090901},{"$f":"-AQ20","v":-540},{"$f":"AR20","v":-711.83590909090901},"x roue g","y roue g"]
[null,"% env demi-aile (%)",90,null,null,"Position horizontale (mm)",75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur haut",70,null,5,{"$f":"Couple5_Largeur/2","v":40},{"$f":"Longueur_fuselage-Couple5_Position","v":470},{"$f":"-AC19","v":-40},{"$f":"AF20","v":692.5},{"$f":"-AG18","v":-87.199532074984731},{"$f":"AH18","v":698.18368362025274},null,5,{"$f":"xg_ligne_ref+Couple5_Position","v":-25},{"$f":"y_ligne_ref-Couple5_Hauteur_Bas","v":-326.66666666666669},null,"x volet dir","y volet dir",null,{"$f":"AQ18","v":0},{"$f":"AR18+Epaisseur_max_profil","v":-711.83590909090901},{"$f":"-AQ21","v":0},{"$f":"AR21","v":-711.83590909090901},{"$f":"AU19","v":-87.199532074984731},{"$f":"AT6","v":-931.09090909090901}]
[null,"Longueur",{"$f":"(Aileron_bout_pourcent_env_demi_aile/100)*Env_panneau_aile","v":450},"mm",null,"Position verticale (mm)",15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bas",30,null,6,{"$f":"Couple6_Largeur/2","v":23},{"$f":"Longueur_fuselage-Couple6_Position","v":220},"x foyer s","y foyer s","x centrage","y centrage",null,4,{"$f":"xg_ligne_ref+Couple4_Position","v":-75},{"$f":"y_ligne_ref-Couple4_Hauteur_bas","v":-326.66666666666669},null,{"$f":"AN17-Largeur_volet_direction","v":462},{"$f":"AO16","v":-281.66666666666669},null,null,null,"roulette queue",null,{"$f":"AU19","v":-87.199532074984731},{"$f":"AT7","v":-996.09090909090901}]
[null,"Largeur (profondeur)",{"$f":"(Aileron_bout_pourcent_CAM/100)*Cam_Aile","v":34.5},"mm",null,"Hauteur",{"$f":"(20000*G59)/(Largeur_Basse_derive+Largeur_Haute_derive)","v":137.93103448275863},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Couple 4 fuite Aile",null,null,7,{"$f":"Couple7_Largeur/2","v":17.5},{"$f":"Longueur_fuselage-Couple7_Position","v":125},{"$f":"Couple7_Largeur/2","v":17.5},{"$f":"Cam_Stab-Foyer_stab_à_emp_bord_attaque","v":93.75},0,{"$f":"Longueur_fuselage-Couple3_Position-CG","v":683.70018810900456},null,3,{"$f":"xg_ligne_ref+Couple3_Position","v":-305},{"$f":"y_ligne_ref-Couple3_Hauteur_bas","v":-326.66666666666669},null,{"$f":"AN22","v":462},{"$f":"AO16+Hauteur_Volet_Direction","v":-143.73563218390805},null,null,"sin(alpha)",0,{"$f":"AR6-Couple8_Hauteur_bas","v":-839.09090909090901},"roue avant"]
[null,"Modèle",null,null,null,"Volet de direction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position",{"$f":"Couple3_Position+ROUND(Cemp_aile,0)","v":370},"mm",8,{"$f":"Couple8_Largeur/2","v":10},{"$f":"Longueur_fuselage-Couple8_Position","v":0},{"$f":"-AE23","v":-17.5},{"$f":"AF23","v":93.75},"x roue ar","y  roue ar",null,2,{"$f":"xg_ligne_ref+Couple2_Position","v":-365},{"$f":"y_ligne_ref-Couple2_Hauteur_bas","v":-326.66666666666669},null,"x aile","y aile","% de la corde a",null,{"$f":"Epaisseur_max_profil/Position_epaisseur_max_profil","v":0.49374999999999997},0,{"$f":"AT23-Hauteur_roulette_queue","v":-888.04417653175869},0,{"$f":"AT16+(Diametre_roues/2)","v":-906.59090909090901}]
[null,"Vstab",{"$f":"(Bras_Levier*Surface_Stab)/(Cam_Aile*Surface_Alaire)","v":0.52811909262759926},null,null,"% Surface direction (%)",40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur",80,null,8,{"$f":"-Couple8_Largeur/2","v":-10},{"$f":"Longueur_fuselage-Couple8_Position","v":0},"x roue av","y  roue av",0,0,null,1,{"$f":"fus_x1","v":-445},{"$f":"y_ligne_ref-Couple1_Hauteur_bas","v":-326.66666666666669},null,{"$f":"xg_ligne_ref+Longueur_du_nez-Longueur_cone","v":-305},{"$f":"y_ligne_ref+Hauteur_aile+Incidence_aile_mm","v":-220.70295166023038},0,{"$f":"(AP25*Cam_Aile)/100","v":0},{"$f":"$AR$24*AQ25","v":0},null,null,0,{"$f":"AT16-(Diametre_roues/2)","v":-971.59090909090901}]
[null,"Vdir",{"$f":"(BL_derive*Surface_Derive)/(Surface_Alaire*(Env_panneau_aile))","v":9.8345827086456783E-2},null,null,"Hauteur",{"$f":"Hauteur_Derive","v":137.93103448275863},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur haut",70,null,7,{"$f":"-Couple7_Largeur/2","v":-17.5},{"$f":"Longueur_fuselage-Couple7_Position","v":125},0,{"$f":"AH23+(Diametre_roues/2)+Empatement","v":856.20018810900456},0,{"$f":"Diametre_roues","v":65},null,null,"x centrage","y centrage",null,{"$f":"$AN$25+AQ26","v":-293.5},{"$f":"$AO$25+(AR26/2)","v":-217.86388916023037},5,{"$f":"(AP26*Cemp_aile)/100","v":11.5},{"$f":"$AR$24*AQ26","v":5.6781249999999996}]
[null,"Marge statique (%)",5,null,null,"Largeur",{"$f":"(Surface_volet_direction*10000)/Hauteur_Volet_Direction","v":57.999999999999993},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bas",30,null,6,{"$f":"-Couple6_Largeur/2","v":-23},{"$f":"Longueur_fuselage-Couple6_Position","v":220},0,{"$f":"AH23-(Diametre_roues/2)+Empatement","v":791.20018810900456},"centrage sur ailes",null,null,null,{"$f":"xg_ligne_ref+Couple3_Position+CG","v":-238.70018810900459},{"$f":"y_ligne_ref","v":-296.66666666666669},null,{"$f":"$AN$25+AQ27","v":-270.5},{"$f":"$AO$25+(AR27/2)","v":-212.18576416023038},15,34.5,17.034374999999997]
[null,"CG en % de cam aile TP",{"$f":"CG_TP_pourcent_cam","v":28.826005169998005},"%",null,"Calages moteur (°)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Couple 5",null,null,5,{"$f":"-Couple5_Largeur/2","v":-40},{"$f":"Longueur_fuselage-Couple5_Position","v":470},"x cam s d","y cam s d",{"$f":"AC34","v":250},{"$f":"Longueur_fuselage-Couple3_Position-CG","v":683.70018810900456},null,null,"x roue","y roue",null,{"$f":"$AN$25+AQ28","v":-249.8},{"$f":"$AO$25+(AR28/2)","v":-207.07545166023039},{"$f":"Distance_epaisseur_ma","v":24},55.2,27.254999999999999]
[null,"CG à l'emplanture TP",{"$f":"CG_TP","v":66.299811890995414},"mm",null,"Anticouple",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position",420,null,4,{"$f":"-Couple4_Largeur/2","v":-40},{"$f":"Longueur_fuselage-Couple4_Position","v":520},{"$f":"(Distance_Cam_Emp_Stab)","v":100},{"$f":"G12-G50-G53","v":0},{"$f":"-AG28","v":-250},{"$f":"AH28","v":683.70018810900456},null,1,{"$f":"AN45","v":-285.68368362025279},{"$f":"AO45+(Diametre_roues/2)","v":-418.66666666666669},null,{"$f":"$AN$28","v":-249.8},{"$f":"$AO$28","v":-207.07545166023039},50,115,56.781249999999993]
[null,"Cz aile choisi",0.3,null,null,"en mm au bout de l'hélice",{"$f":"(SIN(RADIANS(Anticouple)))*((Diametre_Helice_Libre/2)*25.4)","v":2.2164556175350061},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur",80,null,3,{"$f":"-Couple3_Largeur/2","v":-40},{"$f":"Longueur_fuselage-Couple3_Position","v":750},{"$f":"AE29","v":100},{"$f":"G12-G53","v":125},"x prof d","y prof d",null,2,{"$f":"AK29+SIN(RADIANS(45))*(Diametre_roues/2)","v":-262.70271323168998},{"$f":"AO45+SIN(RADIANS(45))*(Diametre_roues/2)","v":-428.18569627810388},null,{"$f":"$AN$28","v":-249.8},{"$f":"$AO$28","v":-207.07545166023039},75,172.5,85.171875]
[null,"Alpha0 du profil",-2.5,null,null,"Piqueur",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur haut",35,null,2,{"$f":"-Couple2_Largeur/2","v":-40},{"$f":"Longueur_fuselage-Couple2_Position","v":810},"x cam s g","y cam s g",{"$f":"AE8","v":200},{"$f":"AF9+G16","v":37.5},null,3,{"$f":"AN45+(Diametre_roues/2)","v":-253.18368362025279},{"$f":"AO45","v":-451.16666666666669},null,{"$f":"$AN$25+AQ31","v":-75},{"$f":"AO25-Incidence_aile_mm","v":-226.66666666666669},100,230,113.56249999999999]
[null,"cm0 du profil",-0.05,null,null,"en mm au bout de l'hélice",{"$f":"(SIN(RADIANS(Piqueur)))*((Diametre_Helice_Libre/2)*25.4)","v":2.2164556175350061},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bas",30,null,1,{"$f":"-Couple1_Largeur/2","v":-40},{"$f":"Longueur_fuselage","v":890},{"$f":"-AE29","v":-100},{"$f":"G12-G50-G53","v":0},{"$f":"AE10","v":0},{"$f":"AF10+G16","v":37.5},null,4,{"$f":"AK29+COS(RADIANS(45))*(Diametre_roues/2)","v":-262.70271323168998},{"$f":"AL31-SIN(RADIANS(45))*(Diametre_roues/2)","v":-474.1476370552295},null,{"$f":"$AN$28","v":-249.8},{"$f":"$AO$34","v":-234.33045166023038},75,172.5,85.171875]
[null,"Incidence aile (°)",{"$f":"(9.1*((A_aile + 2) / A_aile) * CzaileChoisi)+alpha0","v":1.4857999999999998},null,null,"Fuselage vue de dessus (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Couple 6",null,null,null,"x cam a d","y cam a d",{"$f":"-AE30","v":-100},{"$f":"G12-G53","v":125},"x prof g","y prof g",null,5,{"$f":"AN45","v":-285.68368362025279},{"$f":"AO45-(Diametre_roues/2)","v":-483.66666666666669},null,{"$f":"$AN$28","v":-249.8},{"$f":"$AO$34","v":-234.33045166023038},50,115,56.781249999999993]
[null,"en mm",{"$f":"(SIN(RADIANS(Incidence_aile)))*Cemp_aile","v":5.9637150064362965},null,null,"Longueur du nez",180,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position",670,null,null,{"$f":"(Distance_Cam_Emp_Aile)","v":250},{"$f":"Longueur_fuselage-Couple3_Position-Cam_Aile-Fleche_Cam_Aile","v":520},"x cam s","x cam s",{"$f":"-AG31","v":-200},{"$f":"AH31","v":37.5},null,6,{"$f":"AK29-COS(RADIANS(45))*(Diametre_roues/2)","v":-308.6646540088156},{"$f":"AL31-SIN(RADIANS(45))*(Diametre_roues/2)","v":-474.1476370552295},null,{"$f":"$AN$25+AQ34","v":-249.8},{"$f":"$AO$25-(AR34/2)","v":-234.33045166023038},{"$f":"Distance_epaisseur_ma","v":24},55.2,27.254999999999999]
[null,"V longi (°)",{"$f":"VLongi_TP","v":-0.63663293682450584},null,null,"Longueur fuselage",890,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur",46,null,null,{"$f":"AC34","v":250},{"$f":"Longueur_fuselage-Couple3_Position-Fleche_Cam_Aile","v":750},0,{"$f":"G12-G50-G53","v":0},{"$f":"-AG32","v":0},{"$f":"AH32","v":37.5},null,7,{"$f":"AN45-(Diametre_roues/2)","v":-318.18368362025279},{"$f":"AO45","v":-451.16666666666669},null,{"$f":"$AN$25+AQ35","v":-270.5},{"$f":"$AO$25-(AR35/2)","v":-229.22013916023039},15,34.5,17.034374999999997]
[null,"Incidence stab (°)",{"$f":"Incidence_aile-VLongi","v":2.1224329368245058},null,null,"Mise en croix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur haut",15,null,null,"x cam a g","y cam a g",0,{"$f":"G12-G53","v":125},"Hélice",null,null,8,{"$f":"AK29-COS(RADIANS(45))*(Diametre_roues/2)","v":-308.6646540088156},{"$f":"AO45+SIN(RADIANS(45))*(Diametre_roues/2)","v":-428.18569627810388},null,{"$f":"$AN$25+AQ36","v":-293.5},{"$f":"$AO$25-(AR36/2)","v":-223.54201416023039},5,11.5,5.6781249999999996]
[null,"en mm",{"$f":"(SIN(RADIANS(Incidence_stab)))*Cemp_stab","v":4.6293714429184716},null,null,"mise en croix aile",{"$f":"SQRT(((AH46)^2)+((Env_complete/2)^2))","v":721.38755187485731},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bas",30,null,null,{"$f":"-AC34","v":-250},{"$f":"AD34","v":520},"x A bout d","y A bout d",{"$f":"-((Diametre_Helice_Libre/2)*25.4)","v":-127},{"$f":"AH13+Anticouple_mm","v":892.21645561753496},null,9,{"$f":"AK29","v":-285.68368362025279},{"$f":"AL29","v":-418.66666666666669},null,{"$f":"$AN$25+AQ37","v":-305},{"$f":"$AO$25-(AR37/2)","v":-220.70295166023038},0,0,0]
[null,"Masses",null,null,null,"mise en croix stab",{"$f":"SQRT(((Env_stab/2)^2)+((Longueur_fuselage-AF8)^2))","v":790.71170473188272},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Couple 7 emplanture Stab",null,null,null,{"$f":"-AC35","v":-250},{"$f":"AD35","v":750},{"$f":"AC9","v":500},{"$f":"AD9+Aileron_bout_Largeur_bout_aile","v":554.5},{"$f":"((Diametre_Helice_Libre/2)*25.4)","v":127},{"$f":"AH15-Anticouple_mm","v":887.78354438246504},null,null,"Roue avant",null,null,"x roulette q","y roulette q"]
[null,"Charge Alaire souhaitée (g/dm²)",55,null,null,"Profil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position",{"$f":"Longueur_fuselage-ROUND(Cemp_stab,0)","v":765},"mm",null,"x cam a","y cam a",{"$f":"AE38-((AC9-AC10)*(Aileron_bout_pourcent_env_demi_aile/100))","v":50},{"$f":"AF38+AD47","v":554.5},"x A full d","y A full d",null,1,{"$f":"AN49","v":-401.78700722156088},{"$f":"AO49+(Diametre_roues/2)","v":-394.16666666666669},null,{"$f":"xd_ligne_ref-Largeur_volet_direction","v":387},{"$f":"AL18","v":-326.66666666666669}]
[null,"Masse maxi souhaitée calculée",{"$f":"Surface_Alaire*Charge_Alaire","v":1265},"g",null,"Epaisseur relative du profil (%)",11.85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur",35,null,null,0,{"$f":"Longueur_fuselage-Couple3_Position-Fleche_Cam_Aile","v":750},{"$f":"AE39","v":50},{"$f":"AF39-Aileron_bout_Largeur_bout_aile","v":520},{"$f":"AC10","v":0},{"$f":"AD10+Aileron_full_Largeur","v":554.5},null,2,{"$f":"AK39+SIN(RADIANS(45))*(Diametre_roues/2)","v":-378.80603683299807},{"$f":"AO49+SIN(RADIANS(45))*(Diametre_roues/2)","v":-403.68569627810388},null,{"$f":"xd_ligne_ref","v":445},{"$f":"AO39-Hauteur_roulette_queue","v":-375.61993410751637}]
[null,"Electronique",null,null,null,"Epaisseur maxi du profil",{"$f":"(Epaisseur_profil*Cemp_aile)/100","v":27.254999999999999},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur haut",15,null,null,0,{"$f":"AD40-Cam_Aile","v":520},"x A bout g","y A bout g",{"$f":"AC9","v":500},{"$f":"AD9+Aileron_full_Largeur","v":554.5},null,3,{"$f":"AN49+(Diametre_roues/2)","v":-369.28700722156088},{"$f":"AO49","v":-426.66666666666669},null,"Roulette queue"]
[null,"Masse moteur",{"$f":"Masse_Moteur_Choisie","v":130},"g",null,"Position épaisseur maxi (%)",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bas",30,null,null,"Calculs pour A bout:",null,{"$f":"-AE38","v":-500},{"$f":"AF38","v":554.5},"x A full g","y A full g",null,4,{"$f":"AK39+COS(RADIANS(45))*(Diametre_roues/2)","v":-378.80603683299807},{"$f":"AL41-SIN(RADIANS(45))*(Diametre_roues/2)","v":-449.6476370552295},null,{"$f":"xd_ligne_ref","v":445},{"$f":"AO40","v":-375.61993410751637}]
[null,"Masse Accu",{"$f":"Masse_Reelle_Accu","v":138},"g",null,"Position épaisseur maxi",{"$f":"(Distance_epaisseur_ma*Cemp_aile)/100","v":55.2},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Couple 8 queue",null,null,null,"a",{"$f":"AD10-AD9","v":0},{"$f":"-AE39","v":-50},{"$f":"AF39","v":554.5},{"$f":"-AG40","v":0},{"$f":"-C13+AD7+C18","v":554.5},null,5,{"$f":"AN49","v":-401.78700722156088},{"$f":"AO49-(Diametre_roues/2)","v":-459.16666666666669},null,"x train","y train"]
[null,"Masse des servos",50,"g",null,"Cz profil",{"$f":"CzaileChoisi * ((2 / A_aile) + 1)","v":0.438},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position",{"$f":"Longueur_fuselage","v":890},"mm",null,"b",{"$f":"AE38+AC10","v":500},{"$f":"-AE40","v":-50},{"$f":"AF40","v":520},{"$f":"-AG41","v":-500},{"$f":"AD14+C18","v":554.5},null,6,{"$f":"AK39-COS(RADIANS(45))*(Diametre_roues/2)","v":-424.76797761012369},{"$f":"AL41-SIN(RADIANS(45))*(Diametre_roues/2)","v":-449.6476370552295},null,{"$f":"xg_ligne_ref+Couple3_Position+CG","v":-238.70018810900459},{"$f":"y_ligne_ref-Couple3_Hauteur_bas","v":-326.66666666666669}]
[null,"Masse contrôleur ESC",36,"g",null,"Détail Modèle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur",20,null,null,"tanA",{"$f":"AD43/AD44","v":0},"Mise en croix stab (d & g)",null,"Mise en croix aile  (d & g)",null,null,7,{"$f":"AN49-(Diametre_roues/2)","v":-434.28700722156088},{"$f":"AO49","v":-426.66666666666669},null,{"$f":"xg_ligne_ref+Couple3_Position+CG-AO46","v":-285.68368362025279},{"$f":"AO44-Hauteur_train_central","v":-451.16666666666669}]
[null,"Masse récepteur",10,"g",null,"Bras de levier",{"$f":"Longueur_fuselage-Longueur_du_nez-Foyer_aile_à_emp_bord_attaque-Cemp_stab+Foyer_stab_à_emp_bord_attaque","v":558.75},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur haut",15,null,null,"b'",{"$f":"AD44-AE39","v":450},{"$f":"AE8","v":200},{"$f":"AF8","v":125},{"$f":"AC9","v":500},{"$f":"AD9","v":520},null,8,{"$f":"AK39-COS(RADIANS(45))*(Diametre_roues/2)","v":-424.76797761012369},{"$f":"AO49+SIN(RADIANS(45))*(Diametre_roues/2)","v":-403.68569627810388},null,"inclinaison",{"$f":"Inclinaison_train_central_mm","v":46.983495511248222}]
[null,"Masse cône",22,"g",null,"Levier de stab",{"$f":"Longueur_fuselage-Longueur_du_nez-Cemp_stab","v":585},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur bas",30,null,null,"a'",{"$f":"AD45*AD46","v":0},0,{"$f":"Longueur_fuselage","v":890},0,0,null,9,{"$f":"AK39","v":-401.78700722156088},{"$f":"AL39","v":-394.16666666666669},null,"x train avant","y train avant"]
[null,"Masse hélice",9,"g",null,"Foyer mod / emp TP",{"$f":"Foyer_emp_TP","v":77.7998118909954},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bulle (cotes en mm)",null,null,null,null,null,{"$f":"AE13","v":-200},{"$f":"AF13","v":125},{"$f":"AC14","v":-500},{"$f":"AD14","v":520},null,null,"x stab","y stab",null,{"$f":"AN44-Empatement","v":-378.70018810900456},{"$f":"y_ligne_ref-Couple2_Hauteur_bas","v":-326.66666666666669}]
[null,"Masse chaine électrique",{"$f":"SUM(C42:C48)","v":395},"g",null,"Détail Stab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position début bulle",270,null,null,null,null,0,{"$f":"Longueur_fuselage","v":890},0,0,null,null,{"$f":"xd_ligne_ref","v":445},{"$f":"y_ligne_ref+Hauteur_stab","v":-296.66666666666669},null,{"$f":"AN48-Inclinaison__roulette_de_nez_mm","v":-401.78700722156088},{"$f":"AO48-Hauteur_roulette_de_nez","v":-426.66666666666669}]
[null,"Masse longeron aile",35,"g",null,"Cam stab",{"$f":"(2/3)*(((Cemp_stab*Cemp_stab)+(Cemp_stab*Csau_stab)+(Csau_stab*Csau_stab))/(Cemp_stab+Csau_stab))","v":125},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur début bulle",53,null,null,null,null,null,null,null,null,null,null,{"$f":"xd_ligne_ref-Cemp_stab","v":320},{"$f":"y_ligne_ref+Hauteur_stab+Incidence_stab_mm","v":-292.03729522374823},null,"Contrôle taille Hélice"]
[null,"Accastillage divers",430,"g",null,"Distance Cam / Emplanture",{"$f":"IF(Cemp_stab=Csau_stab,Env_stab/4,(Env_stab/2)*((Cemp_stab-Cam_Stab)/(Cemp_stab-Csau_stab)))","v":100},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position milieu1 bulle",342,null,null,null,null,null,null,null,null,null,null,"Hélice",null,null,"h train total",{"$f":"Couple3_Hauteur_bas+Hauteur_train_central+(Diametre_roues/2)","v":187}]
[null,"Masse des équipements",{"$f":"Masse_Chaine_Electrique+Mass_Longeron_Aile+Accastillage","v":860},"g",null,"Distance Cam / saumon",{"$f":"IF(Cemp_stab=Csau_stab,Env_stab/4,((Env_stab/2)/3)*(((2*Cemp_stab)+(Csau_stab))/(Cemp_stab+Csau_stab)))","v":100},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur milieu1 bulle",80,null,null,null,null,null,null,null,null,null,null,{"$f":"AN7+Piqueur_mm","v":-442.78354438246498},{"$f":"AO8-((Diametre_Helice_Libre/2)*25.4)","v":-423.66666666666669},null,"h helice",{"$f":"((Diametre_Helice_Libre/2)*25.4)","v":127}]
[null,"Masse structure calculée",{"$f":"Masse_structure_estimee","v":390.17344576719569},"g",null,"Flèche Cam",{"$f":"(1/3)*Fleche_stab*((Cemp_stab+(2*Csau_stab))/(Cemp_stab+Csau_stab))","v":0},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position milieu2 bulle ",430,null,null,null,null,null,null,null,null,null,null,{"$f":"AN9-Piqueur_mm","v":-447.21645561753502},{"$f":"AO8+((Diametre_Helice_Libre/2)*25.4)","v":-169.66666666666669},null,"marge",{"$f":"IF(Hauteur_train_central=0,0,AO51-AO52)","v":60}]
[null,"Masse totale calculée",{"$f":"Masse_des_équipements+Masse_Structure_Modele","v":1250.1734457671957},"g",null,"Foyer stab",{"$f":"Cam_Stab/4","v":31.25},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur milieu2 bulle ",60]
[null,"Charge alaire réelle",{"$f":"C54/Surface_Alaire","v":54.355367207269381},"g/dm²",null,"Foyer stab à emp / bord attaque",{"$f":"Foyer_stab+Fleche_Cam_Stab","v":31.25},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position fin bulle",500]
[null,"Marge de masse",{"$f":"Masse_Maxi-Masse_des_équipements-Masse_Structure_Modele","v":14.826554232804313},"g",null,"Volet de profondeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur fin bulle",30]
[null,"Détail Aile",null,null,null,"Surface volet prof",{"$f":"(Prof_pourcent_Surface_stab/100)*Surface_Stab","v":1.5},"dm²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Train"]
[null,"Cam aile",{"$f":"(2/3)*(((Cemp_aile*Cemp_aile)+(Cemp_aile*Csau_aile)+(Csau_aile*Csau_aile))/(Cemp_aile+Csau_aile))","v":230},"mm",null,"Détail Dérive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garde au sol",60,"mm"]
[null,"Distance Cam / Emplanture",{"$f":"IF(Cemp_aile=Csau_aile,Env_panneau_aile/2,Env_panneau_aile*((Cemp_aile-Cam_Aile)/(Cemp_aile-Csau_aile)))","v":250},"mm",null,"Surface dérive",{"$f":"(Derive_pourcent_Surface_stab/100)*Surface_Stab","v":2},"dm²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diamètre des roues (mm)",65]
[null,"Distance Cam / saumon",{"$f":"IF(Cemp_aile=Csau_aile,Env_panneau_aile/2,(Env_panneau_aile/3)*(((2*Cemp_aile)+(Csau_aile))/(Cemp_aile+Csau_aile)))","v":250},"mm",null,"Cam dérive",{"$f":"(2/3)*(((Largeur_Basse_derive*Largeur_Basse_derive)+(Largeur_Basse_derive*Largeur_Haute_derive)+(Largeur_Haute_derive*Largeur_Haute_derive))/(Largeur_Basse_derive+Largeur_Haute_derive))","v":151.95402298850576},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angle train principal / axe vertical",25,"°"]
[null,"Flèche Cam /Emplanture",{"$f":"(1/3)*Fleche_aile*((Cemp_aile+(2*Csau_aile))/(Cemp_aile+Csau_aile))","v":0},"mm",null,"Foyer derive",{"$f":"Cam_derive/4","v":37.988505747126439},"mm",null,null,"CG en % de cam aile moi",null,null,{"$f":"(100*N67)/(Cam_Aile)","v":35.672313508797437},"%",null,null,null,null,null,null,null,null,null,"Inclinaison du train principal (°)",20,null,null,"modifier les commentaires train"]
[null,"Foyer aile",{"$f":"Cam_Aile/4","v":57.5},"mm",null,"Bras de levier dérive",{"$f":"Longueur_fuselage-Longueur_du_nez-Foyer_aile_à_emp_bord_attaque-Largeur_Basse_derive+Foyer_Derive+Position_Derive_Horizontale","v":565.48850574712651},"mm",null,null,"CG à l'emplanture moi",null,null,{"$f":"Foyer_modele_emp-((Marge_statique*Foyer_modele_emp)/100)","v":82.0463210702341},"mm",null,null,null,null,null,null,null,null,null,"Hauteur du train principal (mm)",{"$f":"(Garde_au_sol+Hauteur_demi_helice)-Couple3_Hauteur_bas-(Diametre_roues/2)","v":124.5},"mm",null,"modifier les actions code pour dessin"]
[null,"Foyer aile à emp / bord attaque",{"$f":"Fleche_Cam_Aile+Foyer_aile","v":57.5},"mm",null,"Volet de direction",null,null,null,null,"Influence fus en %",null,null,5,"%",null,null,null,null,null,null,null,null,null,"Longueur de la jambe du train",{"$f":"(Hauteur_train_central/COS(RADIANS(Angle_train_principal)))","v":137.37055091083022},"mm"]
[null,"Aileron Fullspan",null,null,null,"Surface volet direction",{"$f":"(G25/100)*Surface_Derive","v":0.8},"dm²",null,null,"Influence fus",null,null,{"$f":"Influence_fus_en_pourcent*Cam_Aile/100","v":11.5},"mm",null,null,null,null,null,null,null,null,null,"Voie minimum du train / axe",{"$f":"(TAN(RADIANS(25)))*(Hauteur_train_central+(Diametre_roues/2)+Couple3_Hauteur_bas)","v":87.199532074984731},"mm"]
[null,"Surface par demi aile",{"$f":"(Aileron_full_Longueur*Aileron_full_Largeur)/10000","v":1.7250000000000001},"dm²",null,null,null,null,null,null,"Foyer du modèle moi",null,null,{"$f":"(Cam_Aile*(0.25+(Vstab*((A_stab*(A_aile-2))/(A_aile*(A_stab+2)))))-Influence_Fus)","v":86.364548494983268},"mm",null,null,null,null,null,null,null,null,null,"Voie minimum complète",{"$f":"Voie_du_train*2","v":174.39906414996946},"mm",null,"juste pour le dessin?",null,"voir ici l'inclinaison à quoi elle sert, on a deux inclinaisons"]
[null,"Aileron en bout d'aile",null,null,null,null,null,null,null,null,"Foyer mod / emp moi",null,null,{"$f":"Foyer_Modele+Fleche_Cam_Aile","v":86.364548494983268},"mm",null,null,null,null,null,null,null,null,null,"écartement jambe/axe vertical CG",{"$f":"SIN(RADIANS(Inclinaison_train_central))*Longueur_Jambe_Train","v":46.983495511248222},"mm",null,null,null,"25° pour la largeur"]
[null,"Surface par demi aile",{"$f":"((Aileron_bout_Largeur_bout_aile+Aileron_bout_Largeur_bout_aile)*Aileron_bout_Longueur)/20000","v":1.5525},"dm²",null,null,null,null,null,null,"CG mod sur cam aile moi",null,null,{"$f":"Foyer_Modele-((Marge_statique*Foyer_Modele)/100)","v":82.0463210702341},"mm",null,null,null,null,null,null,null,null,null,"Hauteur roulette de nez (mm)",100,null,null,"faux ça",null,"et ici pour l'axe avant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inclinaison  roulette de nez en °",13,null,null,null,null,"comment groper les deux?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Longueur de la jambe du train",{"$f":"(Hauteur_roulette_de_nez/COS(RADIANS(Inclinaison__roulette_de_nez)))","v":102.63041077933916},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"par rapport à l'axe vertical du CG",{"$f":"SIN(RADIANS(Inclinaison__roulette_de_nez))*Z69","v":23.086819112556313},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inclinaison roulette de queue en °",9,{"$f":"TAN(RADIANS(Inclinaison_roulette_queue))*(Longueur_fuselage-Longueur_du_nez-CG+Inclinaison_train_central_mm)+Couple8_Hauteur_bas","v":139.39354867148282}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur max roulette de queue",{"$f":"Couple3_Hauteur_bas+Hauteur_train_central+(Diametre_roues/2)-((SIN(RADIANS(Inclinaison_roulette_queue))*(Longueur_fuselage-Longueur_du_nez-CG+Inclinaison_train_central_mm))+Couple8_Hauteur_bas)","v":48.953267440849686},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empattement (mm)",140]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Nom de la série graphique","numéro"]
[null,"Aile droite",1]
[null,"Stab droit",2]
[null,"CG à l'emplanture",3]
[null,"Foyer aile",4]
[null,"Foyer mod / emp TP",5]
[null,"Foyer stab",6]
[null,"Cam aile droite",7]
[null,"Cam aile gauche",8]
[null,"Cam stab droit",9]
[null,"Cam stab gauche",10]
[null,"Aile gauche",11]
[null,"Cam Aile",12]
[null,"Cam Stab",13]
[null,"Aileron full gauche",14]
[null,"Aileron full droit",15]
[null,"Aileron bout gauche",16]
[null,"Aileron bout droit",17]
[null,"Profondeur gauche",18]
[null,"Profondeur droite",19]
[null,"Ligne de référence fuselage",20]
[null,"Cone_vue_dessus",21]
[null,"Cone vu de profil",22]
[null,"Bulle",23]
[null,"Derive",24]
[null,"Volet de direction",25]
[null,"aile de profil",26]
[null,"Stab de profil",27]
[null,"CG vu de profil",28]
[null,"Train Bicycle",29]
[null,"Roue_bicycle",30]
[null,"Train roulette de queue",31]
[null,"Roulette de queue",32]
[null,"Train avant",33]
[null,"Roue avant",34]
[null,"Stab gauche",35]
[null,"roue droite de dessus",36]
[null,"roue gauche de dessus",37]
[null,"ligne reference fuselage de face",38]
[null,"aile droite de face",39]
[null,"aile gauche de face",40]
[null,"stab droit de face",41]
[null,"stab gauche de face",42]
[null,"Derive de face",43]
[null,"Train droit de face",44]
[null,"Train gauche de face",45]
[null,"Roue principale droite de face",46]
[null,"Roue principale gauche de face",47]
[null,"Train avant de face",48]
[null,"Roue avant de face",49]
[null,"Roulette queue de face",50]
[null,"Helice vue de profil",51]
[null,"Helice vue de dessus",52]
[null,"Helice vue de face",53]
[null,"CG aile droite",54]
[null,"CG aile gauche",55]
[null,"Mise en croix stab droit",56]
[null,"Mise en croix stab gauche",57]
[null,"mise en croix aile droite",58]
[null,"mise en croix aile gauche",59]
[null,"roue avant de dessus",60]
[null,"roue arriere de dessus",61]
[null,"Fuselage vu de profil",62]
[null,"fuselage nez de face",63]
[null,"fuselage aile de face",64]
[null,"fuselage vu de dessus",65]

{"sheet":"Masses","index":1,"n_rows":65,"n_cols":29,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,25,3,25],[1,26,3,26],[1,8,1,13],[1,20,3,20],[1,21,3,21],[1,22,3,22],[1,23,3,23],[1,24,3,24],[30,2,30,3],[1,15,3,16],[1,17,3,17],[1,18,3,18],[1,19,3,19]]}
[]
[null,"Eléments","Type","Matériau","Surface","Volume","Masse",null,"Matériaux",null,null,null,null,null,null,null,null,"Largeur couple gauche (mm)","Largeur couple droit (mm)","Position relative (mm)","Surface horizontale pour mode caisse  (dm²)","Hauteur couple gauche (mm)","Hauteur couple droit (mm)","Surface \nverticale pour mode caisse et planche (dm²)","Surface totale pour mode caisse (dm²)","Volume pour mode bloc (dm3)","Volume pour mode bloc (dm3)",null,"Aile"]
[null,"Aile","Double planche","Coro cirque/panneaux",{"$f":"IF(C3=\"bloc\",\"-\",(IF(C3=\"planche\",Surface_Alaire,Surface_Alaire*2)))","v":46},{"$f":"IF(C3=\"bloc\",(Epaisseur_max_profil/175)*Surface_Alaire,\"-\")","v":"-"},{"$f":"IF($D$3=\"\",0,IF($C$3=\"bloc\",VLOOKUP($D3,$I$4:$N$23,6,FALSE)*F3,VLOOKUP($D3,$I$25:$N$44,6,FALSE)*E3))","v":209.16005291005288},null,"Type bloc","Longueur (mm)","Largeur (mm)","Epaisseur (mm)","Masse (g)","g/dm3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bloc"]
[null,false,"-","Depron 3",{"$f":"IF(B4=TRUE,Surface_Alaire*2,\"-\")","v":"-"},"-",{"$f":"IF(AND($D4<>\"\",B4=TRUE),(VLOOKUP($D4,$I$25:$N$44,6,FALSE))*E4,0)","v":0},null,"Styro bleu",100,100,100,37,{"$f":"IF(AND(I4<>\"\",M4<>\"\"),M4/((L4*K4*J4)/1000000),0)","v":37},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planche"]
[null,false,"-","Papier kraft moyen",{"$f":"IF(B5=TRUE,Surface_Alaire*2,\"-\")","v":"-"},"-",{"$f":"IF(AND($D5<>\"\",B5=TRUE),(VLOOKUP($D5,$I$46:$N$65,6,FALSE))*E5,0)","v":0},null,"Styro jaune",1250,600,100,2450,{"$f":"IF(AND(I5<>\"\",M5<>\"\"),M5/((L5*K5*J5)/1000000),0)","v":32.666666666666664},null,"Tronçon 1",null,{"$f":"Couple1_Largeur","v":80},{"$f":"Couple2_Largeur","v":80},{"$f":"Couple2_Position","v":80},{"$f":"((((R5+S5)*T5)/2)*2)/10000","v":1.28},{"$f":"(Couple1_Hauteur_haut+Couple1_Hauteur_bas)","v":70},{"$f":"(Couple2_Hauteur_haut+Couple2_Hauteur_bas)","v":75},{"$f":"((((V5+W5)*T5)/2)*2)/10000","v":1.1599999999999999},{"$f":"U5+X5","v":2.44},{"$f":"((T5/6)*((W5*((2*R5)+S5))+(V5*((2*S5)+R5))))/1000000","v":0.46400000000000002},{"$f":"((T5/3))*((R5*V5)+(S5*W5)+SQRT((R5*V5)*(S5*W5)))/1000000","v":0.46390801862602066},null,"Double planche"]
[null,"Stab","Planche","Coro cirque/panneaux",{"$f":"Surface_Stab","v":5},"-",{"$f":"IF(D6<>\"\",(VLOOKUP($D6,$I$25:$N$44,6,FALSE))*E6,0)","v":22.734788359788357},null,"Polystyrène extrudé",100,100,100,37.5,37.5,null,"Tronçon 2",null,{"$f":"S5","v":80},{"$f":"Couple3_Largeur","v":80},{"$f":"Couple3_Position-Couple2_Position","v":60},{"$f":"((((R6+S6)*T6)/2)*2)/10000","v":0.96},{"$f":"W5","v":75},{"$f":"(Couple3_Hauteur_haut+Couple3_Hauteur_bas)","v":100},{"$f":"((((V6+W6)*T6)/2)*2)/10000","v":1.05},{"$f":"U6+X6","v":2.0099999999999998},{"$f":"((T6/6)*((W6*((2*R6)+S6))+(V6*((2*S6)+R6))))/1000000","v":0.42},{"$f":"((T6/3))*((R6*V6)+(S6*W6)+SQRT((R6*V6)*(S6*W6)))/1000000","v":0.41856406460551021}]
[null,false,"-","Papier kraft moyen",{"$f":"IF(B7=TRUE,Surface_Stab*2,\"-\")","v":"-"},"-",{"$f":"IF(AND($D7<>\"\",B7=TRUE),(VLOOKUP($D7,$I$46:$N$65,6,FALSE))*E7,0)","v":0},null,"Polystyrène expansé",100,100,100,27.3,27.3,null,"Tronçon 3",null,80,{"$f":"Couple4_Largeur","v":80},{"$f":"Couple4_Position-Couple3_Position","v":230},3.68,100,{"$f":"(Couple4_Hauteur_haut+Couple4_Hauteur_bas)","v":100},4.5999999999999996,8.2799999999999994,1.84,1.84,null,"Fuselage"]
[null,"Dérive","Planche","Coro ASF",{"$f":"Surface_Derive","v":2},"-",{"$f":"IF(D8<>\"\",(VLOOKUP($D8,$I$25:$N$44,6,FALSE))*E8,0)","v":13},null,"Poly blanc dense",100,100,100,27.3,27.3,null,"Tronçon 4",null,80,{"$f":"Couple5_Largeur","v":80},{"$f":"Couple5_Position-Couple4_Position","v":50},0.8,100,{"$f":"(Couple5_Hauteur_Haut+Couple5_Hauteur_Bas)","v":65},0.82499999999999996,1.625,0.33,0.32749676997731397,null,"Bloc"]
[null,false,"-","Papier kraft moyen",{"$f":"IF(B9=TRUE,Surface_Derive*2,\"-\")","v":"-"},"-",{"$f":"IF(AND($D9<>\"\",B9=TRUE),(VLOOKUP($D9,$I$46:$N$65,6,FALSE))*E9,0)","v":0},null,"Poly blanc léger",100,100,100,12.5,12.5,null,"Tronçon 5",null,80,{"$f":"Couple6_Largeur","v":46},{"$f":"Couple6_Position-Couple5_Position","v":250},3.15,65,{"$f":"(Couple6_Hauteur_Haut+Couple6_Hauteur_Bas)","v":45},2.75,5.9,0.8520833333333333,0.87923779562317961,null,"Planche"]
[null,"Fuselage","Caisse","Coro cirque/panneaux",{"$f":"IF($C$10=\"bloc\",\"-\",SUM(E12:E18))","v":23.692},{"$f":"IF($C$10=\"bloc\",SUM(F12:F18),\"-\")","v":"-"},{"$f":"SUM(G12:G18)","v":107.72652116402116},null,"EPP 3",900,600,3,52,32.098765432098766,null,"Tronçon 6",null,46,{"$f":"Couple7_Largeur","v":35},{"$f":"Couple7_Position-Couple6_Position","v":95},0.76949999999999996,45,{"$f":"(Couple7_Hauteur_haut+Couple7_Hauteur_bas)","v":45},0.85499999999999998,1.6244999999999998,0.1731375,0.17260284754605582,null,"Caisse"]
[null,false,"-","Papier kraft moyen",{"$f":"IF($C$10=\"planche\",Surface_Verticale_fuselage_Planche,Surface_Totale_Fuselage_Caisse)","v":23.692},"-",{"$f":"IF(AND($D11<>\"\",B11=TRUE),(VLOOKUP($D11,$I$46:$N$65,6,FALSE))*E11,0)","v":0},null,"EPP 4",900,600,4,64,29.629629629629626,null,"Tronçon 7",null,35,{"$f":"Couple8_Largeur","v":20},{"$f":"Couple8_Position-Couple7_Position","v":125},0.6875,45,{"$f":"(Couple8_Hauteur_haut+Couple8_Hauteur_bas)","v":45},1.125,1.8125,0.15468750000000001,0.15273283708246105]
[null,"Tronçon 1",{"$f":"$C$10","v":"Caisse"},{"$f":"$D$10","v":"Coro cirque/panneaux"},{"$f":"IF($C$10=\"bloc\",\"-\",IF($C$10=\"caisse\",Y5,X5))","v":2.44},{"$f":"IF($C$10=\"bloc\",Z5,\"-\")","v":"-"},{"$f":"IF($D$10=\"\",0,(IF(E12=\"-\",VLOOKUP($D$10,$I$4:$N$23,6,FALSE)*F12,VLOOKUP($D$10,$I$25:$N$44,6,FALSE)*E12)))","v":11.094576719576718},null,"EPP 15g",100,100,100,15,15,null,null,null,null,null,null,null,null,"Totaux",{"$f":"SUM(X5:X11)","v":12.365},{"$f":"SUM(Y5:Y11)","v":23.692},{"$f":"SUM(Z5:Z11)","v":4.2339083333333329},{"$f":"SUM(AA5:AA11)","v":4.2545423334605417}]
[null,"Tronçon 2",{"$f":"$C$10","v":"Caisse"},{"$f":"$D$10","v":"Coro cirque/panneaux"},{"$f":"IF($C$10=\"bloc\",\"-\",IF($C$10=\"caisse\",Y6,X6))","v":2.0099999999999998},"-",9.1393849206349191,null,"EPP 20g",100,100,100,20,20]
[null,"Tronçon 3","Caisse","Coro cirque/panneaux",8.2799999999999994,"-",37.648809523809518,null,"Floormate 200 bleu",100,100,100,33,33,null,null,null,null,null,null,null,null,"pyramide tronquée",null,null,"tas de sable"]
[null,"Tronçon 4","Caisse","Coro cirque/panneaux",1.625,"-",7.3888062169312168,null,"Floormate 200 SL-X",100,100,100,23.8,23.8,null,null,null,null,null,null,null,null,"V= (h/3)x(B+b+Racine(Bxb))",null,null,"V = H/6 ( L(2a+a') + L'(2a'+a) )"]
[null,"Tronçon 5","Caisse","Coro cirque/panneaux",5.9,"-",26.827050264550266,null,"Styrodur C vert 2500 C",100,100,100,29,29,null,null,null,null,null,null,null,null,null,"base1","base2"]
[null,"Tronçon 6","Caisse","Coro cirque/panneaux",1.6244999999999998,"-",7.3865327380952372,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"Longueur mm",40,65]
[null,"Tronçon 7","Caisse","Coro cirque/panneaux",1.8125,"-",8.24136078042328,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"Largeur mm",42,84]
[null,"Couples","Planche","CTP 5mm","-","-",{"$f":"(SUM(G21:G28)-G20)","v":37.552083333333329},null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"Surface mm²",{"$f":"(X17*X18)","v":1680},{"$f":"(Y17*Y18)","v":5460}]
[null,true,"-","-","-","-",{"$f":"IF(B20=TRUE,(SUM(G21:G28)/3),0)","v":18.776041666666668},null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"hauteur mm",70]
[null,true,"Planche",{"$f":"$D$19","v":"CTP 5mm"},{"$f":"IF(B21=TRUE,(Couple1_Largeur*(Couple1_Hauteur_haut+Couple1_Hauteur_bas))/10000,\"-\")","v":0.56000000000000005},"-",{"$f":"IF(AND($D$19<>\"\",B21=TRUE),(VLOOKUP($D$19,$I$25:$N$44,6,FALSE))*E21,0)","v":13.611111111111112},null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"volume mm3",{"$f":"((X20/3))*(X19+Y19+SQRT(X19*Y19))","v":237268.80499909417},null,{"$f":"((X20/6)*((Y18*((2*X17)+Y17))+(X18*((2*Y17)+X17))))","v":225400}]
[null,false,"Planche",{"$f":"$D$19","v":"CTP 5mm"},{"$f":"IF(B22=TRUE,(Couple2_Largeur*(Couple2_Hauteur_haut+Couple2_Hauteur_bas))/10000,\"-\")","v":"-"},"-",0,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"volume dm3",{"$f":"X21/1000000","v":0.23726880499909417},null,{"$f":"Z21/1000000","v":0.22539999999999999}]
[null,true,"Planche","CTP 5mm",{"$f":"IF(B23=TRUE,(Couple3_Largeur*(Couple3_Hauteur_haut+Couple3_Hauteur_bas))/10000,\"-\")","v":0.8},"-",19.444444444444446,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"m3",{"$f":"X22/1000","v":2.3726880499909416E-4},null,{"$f":"Z22/1000","v":2.2539999999999998E-4}]
[null,true,"Planche","CTP 5mm",{"$f":"IF(B24=TRUE,(Couple4_Largeur*(Couple4_Hauteur_haut+Couple4_Hauteur_bas))/10000,\"-\")","v":0.8},"-",19.444444444444446,null,"Type planche et coffrage","Longueur","Largeur","-","Masse","g/dm2",null,null,null,null,null,null,null,null,"masse volumique",37.5,"g/dm3"]
[null,false,"Planche","CTP 5mm",{"$f":"IF(B25=TRUE,(Couple5_Largeur*(Couple5_Hauteur_Haut+Couple5_Hauteur_Bas))/10000,\"-\")","v":"-"},"-",0,null,"Depron 3",100,100,"-",1,{"$f":"IF(AND(I25<>\"\",M25<>\"\",K25<>0,J25<>0),M25/((K25*J25)/10000),0)","v":1},null,null,null,null,null,null,null,null,"masse",{"$f":"X24*X22","v":8.8975801874660316},null,{"$f":"Z22*X24","v":8.4524999999999988}]
[null,false,"Planche","CTP 5mm",{"$f":"IF(B26=TRUE,(Couple6_Largeur*(Couple6_Hauteur_Haut+Couple6_Hauteur_Bas))/10000,\"-\")","v":"-"},"-",0,null,"Depron 6",100,100,"-",2,2]
[null,true,"Planche","CTP 5mm",{"$f":"IF(B27=TRUE,(Couple7_Largeur*(Couple7_Hauteur_haut+Couple7_Hauteur_bas))/10000,\"-\")","v":0.1575},"-",3.8281250000000004,null,"Coro 2 mm",1000,1000,"-",450,4.5]
[null,false,"Planche","CTP 5mm",{"$f":"IF(B28=TRUE,(Couple8_Largeur*(Couple8_Hauteur_haut+Couple8_Hauteur_bas))/10000,\"-\")","v":"-"},"-",0,null,"Coro 3 mm",1000,1000,"-",600,6]
[null,null,null,null,null,null,null,null,"Coro 4 mm",1000,1000,"-",750,7.5]
[null,null,null,null,null,null,null,null,"Coro ASF",300,200,"-",39,6.5]
[null,null,"Etude des masses",null,null,null,null,null,"Coro cirque/panneaux",189,128,"-",11,4.5469576719576716]
[null,null,"Masse maxi modèle (g)",{"$f":"Masse_Maxi","v":1265},null,null,null,null,"CTP 2,5mm",383,280,"-",126,11.74934725848564]
[null,null,"Masse des équipements (g)",{"$f":"Masse_des_équipements","v":860},null,null,null,null,"CTP 0,8",100,100,"-",6.9,6.9]
[null,null,"Masse structure estimée (g)",{"$f":"SUM(G3:G9)+G10+G11+G19","v":390.17344576719569},null,null,null,null,"CTP 5mm",180,32,"-",14,24.305555555555557]
[null,null,"Masse totale (g)",{"$f":"Masse_des_équipements+Masse_structure_estimee","v":1250.1734457671957},null,null,null,null,"Mélaminé carton",490,60,"-",71,24.14965986394558]
[null,null,"Marge de masses (g)",{"$f":"D32-D35","v":14.826554232804256},null,null,null,null,"Balsa moi (pesé réel)",100,100,"-",4.3499999999999996,{"$f":"IF(AND(I36<>\"\",M36<>\"\",K36<>0,J36<>0),M36/((K36*J36)/10000),0)","v":4.3499999999999996}]
[null,null,null,null,null,null,null,null,"Balsa plume (1,5mm)",100,100,"-",1.2,{"$f":"IF(AND(I37<>\"\",M37<>\"\",K37<>0,J37<>0),M37/((K37*J37)/10000),0)","v":1.2}]
[null,null,null,null,null,null,null,null,"Balsa 10/10 (1mm)",100,100,"-",2,2]
[null,null,null,null,null,null,null,null,"Balsa 15/10 (1,5mm)",100,100,"-",3,3]
[null,null,null,null,null,null,null,null,"Balsa 20/10 (2mm)",100,100,"-",4,4]
[null,null,null,null,null,null,null,null,"Balsa 30/10 (3mm)",100,100,"-",6,6]
[null,null,null,null,null,null,null,null,"Samba 10/10 (1mm)",100,100,"-",4.5,4.5]
[null,null,null,null,null,null,null,null,"EPP",100,100,"-",2,2]
[null,null,null,null,null,null,null,null,"Coro Hepar",460,50,null,8,{"$f":"IF(AND(I44<>\"\",M44<>\"\",K44<>0,J44<>0),M44/((K44*J44)/10000),0)","v":3.4782608695652177}]
[null,null,null,null,null,null,null,null,"Type entoilage","Longueur","Largeur","-","Masse","g/dm2"]
[null,null,null,null,null,null,null,null,"Oracover",1000,1000,"-",77,{"$f":"IF(AND(I46<>\"\",M46<>\"\",K46<>0,J46<>0),M46/((K46*J46)/10000),0)","v":0.77}]
[null,null,null,null,null,null,null,null,"Oracover transparent",1000,1000,"-",54,{"$f":"IF(AND(I47<>\"\",M47<>\"\",K47<>0,J47<>0),M47/((K47*J47)/10000),0)","v":0.54}]
[null,null,null,null,null,null,null,null,"Orastick",1000,1000,"-",80,0.8]
[null,null,null,null,null,null,null,null,"Oralight transparent",1000,1000,"-",36,0.36]
[null,null,null,null,null,null,null,null,"Oralight opaque",1000,1000,"-",45,0.45]
[null,null,null,null,null,null,null,null,"Oratex",1000,1000,null,100,1]
[null,null,null,null,null,null,null,null,"Papier kraft armé",1000,1000,"-",130,1.3]
[null,null,null,null,null,null,null,null,"Papier kraft léger",1000,1000,"-",40,0.4]
[null,null,null,null,null,null,null,null,"Papier kraft moyen",1000,1000,"-",60,0.6]
[null,null,null,null,null,null,null,null,"Papier kraft lourd",1000,1000,"-",80,0.8]
[null,null,null,null,null,null,null,null,"Venilia",100,100,"-",1.5,1.5]
[null,null,null,null,null,null,null,null,"Couvre livre",100,100,"-",0.56000000000000005,0.56000000000000005]
[null,null,null,null,null,null,null,null,"Laminate film 1.7 mil",100,100,"-",0.42,0.42]
[null,null,null,null,null,null,null,null,"Laminate film 3.5 mil",100,100,"-",1,1]
[null,null,null,null,null,null,null,null,"Covering Film HK",1000,1000,null,80,0.8]
[null,null,null,null,null,null,null,null,"Solarfilm",100,100,"-",0.6,0.6]
[null,null,null,null,null,null,null,null,"Soie",null,null,"-",null,0]
[null,null,null,null,null,null,null,null,"Tissu coton",null,null,"-",null,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,0]

{"sheet":"Motorisation","index":2,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,15],[29,8,29,11],[2,8,2,11],[2,1,2,2],[2,4,2,5],[14,4,14,5],[18,4,18,5],[7,8,7,9],[10,8,10,9],[3,8,3,9],[4,8,4,9],[12,9,13,9],[12,10,13,10],[12,11,13,11],[18,1,18,2],[5,13,5,14],[11,8,11,9],[6,8,6,9],[5,8,5,9],[8,8,8,9],[9,8,9,9]]}
[null,"La plupart des formules de cet onglet sont tirées du fichier de Franck A. (CalculMotorisationSimplifiée.xsl), formules et calculs vérifiés tous ok le 14/07/2015"]
[]
[null,"moteur",null,null,"accu",null,null,null,"Vérifications",null,null,null,null,"Boucher ",{"$f":"O4/(12^5*1000^3)","v":3.8178369341563782E-15}]
[null,"Type de moteur",3.5,null,"Type d'accu",3.7,null,null,"KV du moteur chosi",null,1000,null,null,"K = ",{"$f":"C31","v":0.95}]
[null,"Rendement",75,null,"Nombre d'éléments",3,null,null,"Masse du moteur choisi (g)",null,130]
[null,"Puissance massique (W/kg)",200,null,"Etat de l'accu","1/3 du vol",null,null,"Intensité max du moteur choisi (A)",null,38,null,null,"Rappels des masses"]
[null,"Masse calculée modèle (g)",{"$f":"Masse_Totale_Calculee","v":1250.1734457671957},null,"Tension moy calculée (V)",{"$f":"F4*F5","v":11.100000000000001},null,null,"Puissance max du moteur choisi (W)",null,665,null,null,"Masse souhaitée du modèle (g)",{"$f":"Masse_Maxi","v":1265}]
[null,"Puissance moteur min (W)",{"$f":"ROUND((Puissance_Massique_Moteur*(Masse_Totale_Calculee/1000)),0)","v":250},null,"Ajustement de la tension (V)",11.1,null,null,"Capacité de l'accu choisi (mAh)",null,1800,null,null,"Masse structure calculée (g)",{"$f":"Masse_structure_estimee","v":390.17344576719569}]
[null,"Puissance moteur sécu (W)",{"$f":"ROUND(((((Puissance_Massique_Moteur*(Masse_Totale_Calculee/1000))*1.02)*100)/Rendement_Moteur),0)","v":340},null,"Taux de décharge max (C)",25,null,null,"Intensité de décharge constante théorique (A)",null,{"$f":"Capacite_Accu_Choisie*Taux_Decharge_Accu/1000","v":45},"A",null,"Masse des équipements (g)",{"$f":"Masse_des_équipements","v":860}]
[null,"Masse moteur min (g)",{"$f":"ROUND(C9/C4,0)","v":97},null,"Intensité moyenne (A)",{"$f":"ROUND(C9/Tension_Moyenne,1)","v":30.6},null,null,"Intensité de décharge constante conseillée (A)",null,{"$f":"I_Const_Theorique*(2/3)","v":30},"A",null,"Masse totale calculée (g)",{"$f":"Masse_Totale_Calculee","v":1250.1734457671957}]
[null,"Intensité min moteur (A)",{"$f":"ROUND((F10*1.02),1)","v":31.2},null,"Intensité max (A)",{"$f":"ROUND(F10*(3/2),1)","v":45.9},null,null,"Masse calculée de l'accu nu (g)",null,158.8235294117647,"g",null,"Marge de masse (g)",{"$f":"Masse_Maxi_Page_Moteur-O10","v":14.826554232804256}]
[null,"Intensité sécur moteur (A)",{"$f":"ROUND(F11*1.02,1)","v":46.8},null,"Capacité min (mAh)",{"$f":"ROUNDUP((F11/F9)*1000,0)","v":1836},null,null,"Masse réelle de l'accu choisi (g)",null,138]
[null,"Puissance moteur restituée",{"$f":"ROUND(F10*Tension_Moyenne*0.98*(Rendement_Moteur/100),0)","v":250},null,"Masse accu mini nu (g)",97.411764705882348,null,null,null,"Hélice inférieure","hélice choisie","hélice supérieure",null,null,"km/h","m/s"]
[null,"Kv",1000,null,null,null,null,null,null,null,null,null,null,"Vitesse moy palier",{"$f":"(SQRT((2*9.81)/1.293)*SQRT((Charge_Alaire_Reelle/10)/CzaileChoisi))*3.6","v":59.691615042167534},{"$f":"O14/3.6","v":16.581004178379871}]
[null,"Régime théorique à vide",{"$f":"Tension_Moyenne*KV","v":11100},null,"ESC",null,null,null,"Diamètre (pouces)",{"$f":"ROUNDDOWN(F20,0)","v":11},10,{"$f":"ROUNDUP(F20,0)","v":12},null,"Coefficient de portance max",0.9]
[null,"Régime standard en charge",{"$f":"C15*0.83","v":9213},null,"Intensité constante théorique",{"$f":"C11*1.2","v":37.44},null,null,"Pas (pouces)",{"$f":"ROUNDDOWN(F21,0)","v":5},6,{"$f":"ROUNDUP(F21,0)","v":6},null,"Vitesse décrochage",{"$f":"4.56*SQRT(Charge_Alaire_Reelle/Czprofildecrochage)","v":35.437641060837436},{"$f":"O16/3.6","v":9.8437891835659546}]
[null,null,null,null,"Intensité constante à choisir",{"$f":"ROUNDUP((K23*1.2),0)","v":27},null,null,"Rapport Pas/Diamètre",{"$f":"J16/J15","v":0.45454545454545453},{"$f":"K16/K15","v":0.6},{"$f":"L16/L15","v":0.5},null,"Vitesse air brassé",{"$f":"O14/0.8","v":74.614518802709412},{"$f":"O17/3.6","v":20.726255222974835}]
[null,"Mes hélices:","K",null,null,null,null,null,"Régime à vide",{"$f":"Tension_Moyenne*K4","v":11100},{"$f":"Tension_Moyenne*Kv_Choisi","v":11100},{"$f":"Tension_Moyenne*K4","v":11100}]
[null,"les hélices vérifiées sont en rouge",null,null,"Hélice théorique",null,null,null,"Régime standard",{"$f":"J18*0.83","v":9213},{"$f":"K18*0.83","v":9213},{"$f":"L18*0.83","v":9213},null,"Gestion des Gaz (%)",100]
[null,null,null,null,"Diamètre (pouces)",{"$f":"(C13/(O3*F21*C16^3))^(1/4)","v":11.203933667798561},null,null,"Puissance à l'arbre (W)",{"$f":"Coefficient_K*(J16/12)*((J15/12)^4)*((J19/1000)^3)","v":218.55529539320375},{"$f":"Coefficient_K*(Pas_Helice_Libre/12)*((Diametre_Helice_Libre/12)^4)*((K19/1000)^3)","v":179.1314489938151},{"$f":"Coefficient_K*(L16/12)*((L15/12)^4)*((K19/1000)^3)","v":371.44697263357489},null,"Tension moyenne (V)",{"$f":"Tension_Moyenne","v":11.1}]
[null,null,null,null,"Pas (pouces)",{"$f":"O17/((2.54*60/100/1000)*C16)","v":5.3141927718470834},null,null,"Traction statique (g)",{"$f":"(28.35*(J16)*(J15)^3*J19^2*10^-10)*Coeff_Traction","v":1153.0171360586339},{"$f":"(28.35*(Pas_Helice_Libre)*(Diametre_Helice_Libre)^3*K19^2*10^-10)*Coeff_Traction","v":1039.5346080168001},{"$f":"(28.35*(L16)*(L15)^3*L19^2*10^-10)*Coeff_Traction","v":1796.3158026530307},null,"Intensité correspondante (A)",{"$f":"(O19/100)*K23","v":21.956419561661473},null,null,"Régime standard",{"$f":"K19*Gaz/100","v":9213}]
[null,null,null,null,"Rapport Pas/Diamètre",{"$f":"F21/F20","v":0.47431490844333596},null,null,"Vitesse air brassé (km/h)",{"$f":"0.001524*$J$19*J16","v":70.203059999999994},{"$f":"0.001524*$K$19*Pas_Helice_Libre","v":84.243672000000004},{"$f":"0.001524*$L$19*L16","v":84.243672000000004},null,"Puissance consommée (W)",{"$f":"O20*O21","v":243.71625713444234},null,null,"Puissance à l'arbre (W)",{"$f":"Coefficient_K*(Pas_Helice_Libre/12)*((Diametre_Helice_Libre/12)^4)*((S21/1000)^3)","v":179.1314489938151}]
[null,"6x4,5 rouge aliexpress",1.28,null,"Coeff de traction",0.72,null,null,"Intensité nécessaire (A)",{"$f":"J20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":26.788661566857108},{"$f":"K20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":21.956419561661473},{"$f":"L20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":45.528831603061214},null,"Traction statique (g)",{"$f":"(28.35*(Pas_Helice_Libre)*(Diametre_Helice_Libre)^3*O25^2*10^-10)*Coeff_Traction","v":1039.5346080167985},null,null,"Traction statique (g)",{"$f":"(28.35*(Pas_Helice_Libre)*(Diametre_Helice_Libre)^3*S21^2*10^-10)*Coeff_Traction","v":1039.5346080168001}]
[null,"7x4",null,null,"Régime à vide",{"$f":"Tension_Moyenne*KV","v":11100},null,null,"Puissance consommée (W)",{"$f":"J23*Tension_Moyenne","v":297.35414339211388},{"$f":"K23*Tension_Moyenne","v":243.71625713444234},{"$f":"L23*Tension_Moyenne","v":505.37003079397948},null,"Puissance à l'arbre",{"$f":"O21*$O$20*0.98*(Rendement_Moteur/100)","v":179.13144899381513},null,null,"Vitesse air brassé (km/h)",{"$f":"0.001524*$S$21*Pas_Helice_Libre","v":84.243672000000004}]
[null,"8x3,8 SF E",1.8,null,"Régime standard",{"$f":"F24*0.83","v":9213},null,null,"Tension moyenne (V)",{"$f":"J24/J23","v":11.1},{"$f":"K24/K23","v":11.1},{"$f":"L24/L23","v":11.1},null,"Régime (T/mn)",{"$f":"(O24/(Diametre_Helice_Libre^4*O3*Pas_Helice_Libre))^(1/3)","v":9212.9999999999927},null,null,"Intensité nécessaire (A)",{"$f":"S22/Tension_Moyenne/0.98/Rendement_Moteur*100","v":21.956419561661473}]
[null,"8x4 GWS EP DD",0.96,null,"Puissance à l'arbre (W)",{"$f":"Coefficient_K*(F21/12)*((F20/12)^4)*((F25/1000)^3)","v":249.9999999999998},null,null,"Puissance massique (W/kg)",{"$f":"J20/($C$7/1000)","v":174.81997888627572},{"$f":"K20/($C$7/1000)","v":143.28527741515677},{"$f":"L20/($C$7/1000)","v":297.11635124806901},null,"Vitesse air brassé",{"$f":"0.001524*$O$25*Pas_Helice_Libre","v":84.243671999999933},{"$f":"O26/3.6","v":23.401019999999981},null,"Puissance consommée (W)",{"$f":"S25*Tension_Moyenne","v":243.71625713444234}]
[null,"8x4E APC",1.3,null,"Traction statique (g)",{"$f":"(28.35*(F21)*(F20)^3*F25^2*10^-10)*Coeff_Traction","v":1294.9010802539035},null,null,"Vitesse de vol (km/h)",{"$f":"J22*0.8","v":56.162447999999998},{"$f":"K22*0.8","v":67.394937600000006},{"$f":"L22*0.8","v":67.394937600000006},null,"Vitesse de vol (km/h)(m/s)",{"$f":"O26*0.8","v":67.394937599999949},{"$f":"O27/3.6","v":18.720815999999985},null,"Tension moyenne (V)",{"$f":"S26/S25","v":11.1}]
[null,"8x4.5 SF Electric Prop",null,null,"Vitesse air brassé (km/h)",{"$f":"0.001524*F25*F21","v":74.614518802709412},null,null,"Autonomie plein gaz (mn)",{"$f":"Capacite_Accu_Choisie/1000/J23*60*0.95","v":3.8299785804504904},{"$f":"Capacite_Accu_Choisie/1000/K23*60*0.95","v":4.672893033031297},{"$f":"Capacite_Accu_Choisie/1000/L23*60*0.95","v":2.2535170876887052},null,null,null,null,null,"Puissance massique (W/kg)",{"$f":"S22/($C$7/1000)","v":143.28527741515677}]
[null,"9x4.7E SF ",1.1000000000000001,null,"Intensité nécessaire (A)",{"$f":"F26/Tension_Moyenne/0.98/Rendement_Moteur*100","v":30.642887785744904},null,null,null,null,null,null,null,null,null,null,null,"Vitesse de vol (km/h)",{"$f":"S24*0.8","v":67.394937600000006}]
[null,"10x4.7 TP SF GWS",1.4,null,null,null,null,null,"Turnigy D3542/6 1000KV Brushless Outrunner Motor",null,null,null,null,null,null,null,null,"Autonomie plein gaz (mn)",{"$f":"Capacite_Accu_Choisie/1000/S25*60*0.95","v":4.672893033031297}]
[null,"10x6 noire",0.95,null,"Coefficient K théorique",1.2,null,null,"Kv annoncé",1000]
[null,"11x5.5 E APC",0.94,null,"Hélices théoriques","K",null,null,"38A","2S"]
[null,"12x5 Beech wood ",0.65,null,null,null,null,null,"665W","3S"]
[null,"12x6 Cherry wood",null,null,"APC 9x5",1.1000000000000001,null,null,"130g","4S"]
[null,"12x6  GWS EP RD"]
[null,"8x6 APC grise",1.37]
[null,"9x5R noire GWS",1.05]

{"sheet":"Centrage_Vlongi_TP","index":3,"n_rows":78,"n_cols":19,"rows_kept":78,"cut":false,"hidden":false,"merged":[[26,2,26,3],[27,2,27,3],[2,10,2,19],[18,2,18,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3]]}
[]
[]
[null,"Aile",null,"panneau1","panneau 2","panneau 3","panneau 4","panneau 5",null,null,"RESULTATS"]
[null,null,"corde  emp.   mm",{"$f":"Cemp_aile","v":230},{"$f":"IF(E5,D5,0)","v":0},{"$f":"IF(F5,E5,0)","v":0},{"$f":"IF(G5,F5,0)","v":0},{"$f":"IF(H5,G5,0)","v":0},"mm"]
[null,null,"corde saum.  mm",{"$f":"Csau_aile","v":230},null,null,null,null,"mm",null,null,null,null,null,null,"Autres résultats"]
[null,null,"longueur        mm",{"$f":"Env_panneau_aile","v":500},null,null,null,null,"mm",null,null,"Position foyer planeur",null,null,null,"Aile","envergure",{"$f":"E8","v":1000},"mm"]
[null,null,"flèche BA      mm",{"$f":"Fleche_aile","v":0},null,null,null,null,"mm",null,null,"Position Foyer /BA emplanture",{"$f":"B77*R9+R10","v":77.7998118909954},"mm",null,null,"Surface standard",{"$f":"H50","v":23},"dm²"]
[null,null,"Envergure totale",null,{"$f":"Env_complete","v":1000},"mm",null,null,null,null,null,"Position Foyer en % CAM",{"$f":"B77*100","v":33.826005169998005},"%",null,null,"Allongement",{"$f":"R6*R6/(10000*R7)","v":4.3478260869565215}]
[null,"profil ","Cm0 profil",null,{"$f":"cm0","v":-0.05},null,null,null,null,null,null,null,null,null,null,null,"Corde aérodynamique",{"$f":"H51","v":230},"mm"]
[null,"NACA0010","alpha0 ",null,{"$f":"alpha0","v":-2.5},"°",null,null,null,null,null,null,null,null,null,null,"Flèche emplanture/Cam",{"$f":"H53","v":0},"mm"]
[null,null,"calage aile",null,{"$f":"Incidence_aile","v":1.4857999999999998},"°",null,null,null,null,null,null,null,null,null,null,"A.aile",{"$f":"E12*R8/(2+R8)","v":7.5342465753424653E-2}]
[null,null,"dCz/dAlpha",null,0.11,null,null,null,null,null,null,"Centrage pour marge statique = ",{"$f":"Marge_statique","v":5},"%",null,"Stab","Surface",{"$f":"H59","v":5},"dm²"]
[null,null,"dCm/dAlpha",null,0,null,null,null,null,null,null,"Position CG/BA emplanture",{"$f":"M14*R9/100+R10","v":66.299811890995414},"mm",null,null,"envergure",{"$f":"H65","v":400},"mm"]
[null,"Stab",null,"panneau1","panneau 2","panneau 3","panneau 4","panneau 5",null,null,null,"Position foyer en % CAM",{"$f":"M8-M12","v":28.826005169998005},"%",null,null,"Allongement",{"$f":"R13*R13/(10000*R12)","v":3.2}]
[null,null,"corde  emp.   mm",{"$f":"Cemp_stab","v":125},{"$f":"IF(E16,D16,0)","v":0},{"$f":"IF(F16,E16,0)","v":0},0,{"$f":"IF(H16,G16,0)","v":0},"mm",null,null,"Vlongitudinal      pour     Cz =       ",{"$f":"CzaileChoisi","v":0.3},null,null,null,"Corde aérodynamique",{"$f":"H61","v":125},"mm"]
[null,null,"corde saum.  mm",{"$f":"Csau_stab","v":125},0,0,null,null,"mm",null,null,"V.longi ",{"$f":"L55","v":-0.63663293682450584},"°",null,null,"Flèche emplanture/Cam",{"$f":"H63","v":0},"mm"]
[null,null,"longueur        mm",{"$f":"Modèle!G8","v":200},0,0,null,null,"mm",null,null,null,null,null,null,null,"volume de stab",{"$f":"H60*R20/(R7*R9)","v":0.52811909262759926}]
[null,null,"flèche BA      mm",{"$f":"Fleche_stab","v":0},0,0,null,null,"mm",null,null,null,null,null,null,null,"Vcg",{"$f":"L50","v":0.51980169008412536}]
[null,null,"Type empennage",null,"C",null,null,null,null,null,null,null,null,null,null,null,"A.stab",{"$f":"E20*R14/(R14+2)","v":6.7692307692307691E-2}]
[null,null,"dCz/dAlpha",null,0.11,null,null,null,null,null,null,null,null,null,null,"Fuselage","bras de levier arrière",{"$f":"E25-R10-0.25*R9+R16+0.25*R15","v":558.75},"mm"]
[null,null,"coefficient sillage",null,{"$f":"IF(E19=\"C\",1.52,IF(E19=\"V\",1.48,IF(E19=\"T\",1.7,\"erreur\")))","v":1.52},null,null,null,null,null,null,null,null,null,null,null,"coefficient k",{"$f":"L52","v":1.0377004453509187}]
[null,"Fuselage","longueur fuselage",null,{"$f":"Longueur_fuselage","v":890},"mm",null,null,null,null,null,null,null,null,null,null,"coefficient k'",{"$f":"L53","v":0}]
[null,null,"Longueur avant",null,null,"mm"]
[]
[null,null,"D aile/ stab",null,{"$f":"Levier_Stab","v":585},"mm"]
[null,null,"Surface fuselage",null,0,"dm²"]
[null,null,"A.fus.",null,{"$f":"0.06","v":0.06}]
[null,null,"X fus.",null,{"$f":"H67","v":0.16500000000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Aile"]
["surface",{"$f":"D6*(D5+D4)/20000","v":11.5},{"$f":"E6*(E5+E4)/20000","v":0},{"$f":"F6*(F5+F4)/20000","v":0},{"$f":"G6*(G5+G4)/20000","v":0},{"$f":"H6*(H5+H4)/20000","v":0},null,{"$f":"2*SUM(B49:F49)","v":23},null,null,"X'f",{"$f":"(E28*E22-E23)/R9","v":0.63847826086956516}]
["Surface standard",null,null,null,null,null,null,{"$f":"H49+D4*E24/10000","v":23},null,null,"Vcg",{"$f":"R17*(1+(0.25-M14/100)*R9/R20)","v":0.51980169008412536}]
["cam",{"$f":"IF(D4+D5=0,0,2*(D4*D4+D4*D5+D5*D5)/(3*(D4+D5)))","v":230},{"$f":"IF(E4+E5=0,0,2*(E4*E4+E4*E5+E5*E5)/(3*(E4+E5)))","v":0},{"$f":"IF(F4+F5=0,0,2*(F4*F4+F4*F5+F5*F5)/(3*(F4+F5)))","v":0},{"$f":"IF(G4+G5=0,0,2*(G4*G4+G4*G5+G5*G5)/(3*(G4+G5)))","v":0},{"$f":"IF(H4+H5=0,0,2*(H4*H4+H4*H5+H5*H5)/(3*(H4+H5)))","v":0},null,{"$f":"2*SUM(B52:F52)/H49","v":230},null,null,"Lf/C",{"$f":"R20/R9+0.25-M8/100","v":2.3410877743869767}]
["S*cam",{"$f":"B49*B51","v":2645},{"$f":"C49*C51","v":0},{"$f":"D49*D51","v":0},{"$f":"E49*E51","v":0},{"$f":"F49*F51","v":0},null,null,null,null,"k",{"$f":"1+(M8/100-0.25)/L51+(1+(M8/100-L49)/L51)*E27*E26/(R11*R7)","v":1.0377004453509187}]
["f emp-cam",{"$f":"IF(D4+D5=0,0,D7*(D4+2*D5)/(3*(D4+D5)))","v":0},{"$f":"IF(E4+E5=0,0,E7*(E4+2*E5)/(3*(E4+E5)))","v":0},{"$f":"IF(F4+F5=0,0,F7*(F4+2*F5)/(3*(F4+F5)))","v":0},{"$f":"IF(G4+G5=0,0,G7*(G4+2*G5)/(3*(G4+G5)))","v":0},{"$f":"IF(H4+H5=0,0,H7*(H4+2*H5)/(3*(H4+H5)))","v":0},null,{"$f":"2*SUM(B54:F54)/H49","v":0},null,null,"k'",{"$f":"(M14/100-L49)*E27*E26/(L50*R19*R7)","v":0}]
[null,{"$f":"B53*B49","v":0},{"$f":"(C53+D7)*C49","v":0},{"$f":"(D53+D7+E7)*D49","v":0},{"$f":"(E53+D7+E7+F7)*E49","v":0},{"$f":"(F53+D7+E7+F7+G7)*F49","v":0},null,null,null,null,"Cz",{"$f":"M15","v":0.3}]
["envergure",null,null,null,null,null,null,{"$f":"2*SUM(D6:H6)","v":1000},null,null,"Vlongi",{"$f":"L52*M12/100*L54/(L50*R19)-E9/(L50*R19)+E10+L53*(E11-E10)","v":-0.63663293682450584}]
[]
[]
["stab"]
["surface",{"$f":"D17*(D16+D15)/20000","v":2.5},{"$f":"E17*(E16+E15)/20000","v":0},{"$f":"F17*(F16+F15)/20000","v":0},{"$f":"G17*(G16+G15)/20000","v":0},{"$f":"H17*(H16+H15)/20000","v":0},null,{"$f":"2*SUM(B59:F59)","v":5}]
["surface horizontale",null,null,null,null,null,null,{"$f":"H59*IF(E19=\"C\",1,IF(E19=\"V\",0.71, IF(E19=\"T\",1,\"erreur\")))","v":5}]
["cam",{"$f":"IF(D15+D16=0,0,2*(D15*D15+D15*D16+D16*D16)/(3*(D15+D16)))","v":125},{"$f":"IF(E15+E16=0,0,2*(E15*E15+E15*E16+E16*E16)/(3*(E15+E16)))","v":0},{"$f":"IF(F15+F16=0,0,2*(F15*F15+F15*F16+F16*F16)/(3*(F15+F16)))","v":0},{"$f":"IF(G15+G16=0,0,2*(G15*G15+G15*G16+G16*G16)/(3*(G15+G16)))","v":0},{"$f":"IF(H15+H16=0,0,2*(H15*H15+H15*H16+H16*H16)/(3*(H15+H16)))","v":0},null,{"$f":"2*SUM(B62:F62)/H59","v":125}]
["S*cam",{"$f":"B59*B61","v":312.5},{"$f":"C59*C61","v":0},{"$f":"D59*D61","v":0},{"$f":"E59*E61","v":0},{"$f":"F59*F61","v":0}]
["f emp-cam",{"$f":"IF(D15+D16=0,0,D18*(D15+2*D16)/(3*(D15+D16)))","v":0},{"$f":"IF(E15+E16=0,0,E18*(E15+2*E16)/(3*(E15+E16)))","v":0},{"$f":"IF(F15+F16=0,0,F18*(F15+2*F16)/(3*(F15+F16)))","v":0},{"$f":"IF(G15+G16=0,0,G18*(G15+2*G16)/(3*(G15+G16)))","v":0},{"$f":"IF(H15+H16=0,0,H18*(H15+2*H16)/(3*(H15+H16)))","v":0},null,{"$f":"2*SUM(B64:F64)/H59","v":0}]
[null,{"$f":"B63*B59","v":0},{"$f":"(C63+D18)*C59","v":0},{"$f":"(D63+D18+E18)*D59","v":0},{"$f":"(E63+D18+E18+F18)*E59","v":0},{"$f":"(F63+D18+E18+F18+G18)*F59","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"R20/R9","v":2.4293478260869565}]
["envergure",null,null,null,null,null,null,{"$f":"2*SUM(D17:H17)","v":400}]
[null,null,null,null,null,null,"Lar",{"$f":"E22-E23","v":890},null,null,null,null,null,null,"X =",{"$f":"2*R20/R6","v":1.1174999999999999}]
[null,null,null,null,null,null,"Xf",{"$f":"(0.399*E23*E23+(E23+0.33*H66)*0.5*H66)/(2*(0.57*E23+0.5*H66)*E22)","v":0.16500000000000001},null,null,null,null,null,null,"H",{"$f":"2*M67/R6","v":0},"Ss/Sa",{"$f":"R12/R7","v":0.21739130434782608}]
["coeff.sillage",{"$f":"E21*360/(PI()*PI()*R8)","v":12.751878888490065},null,null,null,null,"Sf",{"$f":"(0.7*E23*E24+E24*(E22-E23)*1.3/2)/10000","v":0},null,null,null,null,null,null,"L",{"$f":" SQRT(PI()*PI()/16+P66*P66+P67*P67)","v":1.3658903781299891},"Sf/Sa",{"$f":"E26/R7","v":0}]
["epsilon",{"$f":"E69","v":0.80697888424786524},null,{"$f":"R11*B68","v":0.96075799844788157},{"$f":"P77*E21","v":0.80697888424786524},null,null,null,null,null,null,null,null,null,null,null,"L/C",{"$f":"R20/R9","v":2.4293478260869565}]
["dénom.",{"$f":"H49*R11+H60*R19*(1-B69)+E27*E26","v":1.7982069361217972},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+P66/P68)*(PI()/4)/(PI()*PI()/16+P67*P67)","v":2.314937483327812},"allong aile",{"$f":"R8","v":4.3478260869565215}]
["Foyer brut",{"$f":"0.25+R20*R19*H60/(R9*B70)","v":0.7072559398802658},null,null,{"$f":"B71","v":0.7072559398802658},null,null,null,null,null,null,null,null,null,null,{"$f":"(PI()/4)*(P66/P68)/(P66*P66+P67*P67)","v":0.51454872199649304},"allong stab",{"$f":"R14","v":3.2}]
["correction sillage ",{"$f":"B69*R20*R19*H60/(R9*B70)","v":0.36899588818028578},null,null,{"$f":"B71-B72","v":0.33826005169998002},null,null,null,null,null,null,null,null,null,null,{"$f":"(2/PI())/(1+SQRT(1+R8*R8/4))","v":0.18763376887661287}]
["correction Cm",{"$f":"E13/E12*R11*R7/B70","v":0},null,null,{"$f":"E72-B73","v":0.33826005169998002}]
["D avant-Faile",{"$f":"E23+R10+0.25*R9","v":57.5}]
["F fus",{"$f":"E28*E22","v":146.85}]
["correction fus",{"$f":"((B74-B75)/R9)*E27*E26/B70","v":0},{"$f":"1.19*E26*E27/(R7*R11)","v":0},null,{"$f":"E73-B76","v":0.33826005169998002}]
["Foyer complet",{"$f":"B71-B72-B73-B76","v":0.33826005169998002},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P72*(P70+P71)","v":0.53090716068938504}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"4/(R8+2)","v":0.63013698630136994}]

{"sheet":"Cotes réelles","index":4,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[8,2,8,3],[22,0,25,0],[15,0,16,0],[26,0,27,0],[28,0,29,0],[50,10,50,12],[12,9,54,9],[20,10,20,12],[25,10,25,12],[30,10,30,12],[35,10,35,12],[40,10,40,12],[45,10,45,12],[30,0,37,0],[38,0,49,0],[12,0,14,0],[17,0,20,0],[16,10,16,12]]}
[]
["principe","mesurer sur une image l'envergure, la longueur, puis en connaissant l'envergure réelle du modèle, ça calcule l'échelle de la photo et tout le reste"]
[null,"ne reste plus qu'à mesurer les cotes sur la photo pour avoir les cotes réelles"]
[null,"Toutes les cotes sont en mm"]
[]
["Echelle",null,"mesurée","réelle",null,"surface aile réelle",{"$f":"((((D14+D15)*(D7/2))/2)/10000)*2","v":7.8063148806014917},"dm²"]
[{"$f":"C7/D7","v":0.24834983498349836},"envergure",150.5,606,null,"surface aile mesurée",{"$f":"((((C14+C15)*(C7/2))/2)/10000)*2","v":0.48159999999999997},"dm²"]
[{"$f":"C8/D8","v":0.24847870182555781},"longueur totale (vérif échelle)",122.5,493,null,"allongement aile réel",{"$f":"((D7*D7)/G6)/10000","v":4.7043452079107491}]
[{"$f":"(A7+A8)/2","v":0.24841426840452807},null,"échelle moyenne",null,null,"allongement aile mesuré",{"$f":"((C7*C7)/G7)/10000","v":4.703125}]
[null,null,null,null,null,"effilement",{"$f":"D15/D14","v":0.5609756097560975}]
[]
[null,null,"mesure","calcul",null,"surface stab réelle",{"$f":"((((D20+D21)*(D18/2))/2)/10000)*2","v":1.4738375901788781},"dm²",null,null,null,"mesure","calcul"]
["Aile","demi-envergure",{"$f":"C7/2","v":75.25},{"$f":"D7/2","v":303},null,"surface stab mesurée",{"$f":"((((C20+C21)*(C18/2))/2)/10000)*2","v":9.0950000000000003E-2},"dm²",null,"Fuselage \n(cotes en mm)","Hauteur aile / ligne ref fus",0,{"$f":"L13/$A$9","v":0}]
[null,"corde emplanture",41,{"$f":"C14/$A$9","v":165.04688021073696},null,"allongement stab réel",{"$f":"((D18*D18)/G12)/10000","v":3.1470588235294117},null,null,null,"Hauteur stab / ligne ref fus",0,{"$f":"L14/$A$9","v":0}]
[null,"corde saumon",23,92.587274264559753,null,"allongement stab mesuré",{"$f":"((C18*C18)/G13)/10000","v":3.1470588235294117},null,null,null,"Longueur cône",0,{"$f":"L15/$A$9","v":0}]
["Ailerons","Longueur",null,0,null,"effilement",{"$f":"D21/D20","v":0.61904761904761896},null,null,null,"Diamètre du cône",0,{"$f":"L16/$A$9","v":0}]
[null,"Largeur (profondeur)",11,44.28087030044162,null,null,null,null,null,null,"Couple 1 nez"]
["Stab","envergure stab",53.5,{"$f":"C18/$A$9","v":215.36605100669334},null,"longueur totale (vérif calculs)",{"$f":"D30+M15+D25","v":529.35767677346121},null,null,null,"Largeur",20,{"$f":"L18/$A$9","v":80.510673273530216}]
[null,"demi-envergure",{"$f":"C18/2","v":26.75},{"$f":"D18/2","v":107.68302550334667},null,null,null,null,null,null,"Hauteur bout nez haut",3,{"$f":"L19/$A$9","v":12.076600991029533}]
[null,"corde emplanture stab",21,84.536206937206728,null,null,null,null,null,null,"Hauteur bout nez bas",7,{"$f":"L20/$A$9","v":28.178735645735575}]
[null,"corde saumon stab",13,52.331937627794638,null,null,null,null,null,null,"Couple 2"]
["volet de profondeur","largeur",11,44.28087030044162,null,null,null,null,null,null,"Position",14.5,{"$f":"L22/$A$9","v":58.370238123309406}]
["Dérive","Largeur Haute",13,52.331937627794638,null,"centrage depuis le bout du nez",38.5,{"$f":"G23/$A$9","v":154.98304605154567},null,null,"Largeur",18,{"$f":"L23/$A$9","v":72.459605946177192}]
[null,"Largeur Basse",30,120.76600991029532,null,"centrage depuis emplanture",16,{"$f":"G24/$A$9","v":64.408538618824167},null,null,"Hauteur haut",5,{"$f":"L24/$A$9","v":20.127668318382554}]
[null,"Position (décalage)",9,36.229802973088596,null,"vérif",{"$f":"G23-C29","v":15.5},{"$f":"G25/$A$9","v":62.395771786985918},null,null,"Hauteur bas",12.5,{"$f":"L25/$A$9","v":50.319170795956389}]
[null,"Hauteur",20,80.510673273530216,null,null,null,null,null,null,"Couple 3 emplanture Aile"]
["Volet de direction","Hauteur",null,0,null,null,null,null,null,null,"Position",23,{"$f":"L27/$A$9","v":92.587274264559753}]
[null,"Largeur",14,56.35747129147115,null,null,null,null,null,null,"Largeur",16.5,{"$f":"L28/$A$9","v":66.42130545066243}]
["Fuselage vue de dessus","Longueur du nez",23,92.587274264559753,null,null,null,null,null,null,"Hauteur haut",6,{"$f":"L29/$A$9","v":24.153201982059066}]
[null,"Longueur fuselage",122.5,493.12787380037258,null,null,null,null,null,null,"Hauteur bas",14,{"$f":"L30/$A$9","v":56.35747129147115}]
["bulle","Position début bulle",43,173.09794753808995,null,null,null,null,null,null,"Couple 4 fuite Aile"]
[null,"Hauteur début bulle",null,0,null,null,null,null,null,null,"Position",64,{"$f":"L32/$A$9","v":257.63415447529667}]
[null,"Position milieu1 bulle",null,0,null,null,null,null,null,null,"Largeur",11,{"$f":"L33/$A$9","v":44.28087030044162}]
[null,"Hauteur milieu1 bulle",null,0,null,null,null,null,null,null,"Hauteur haut",11.5,{"$f":"L34/$A$9","v":46.293637132279876}]
[null,"Position milieu2 bulle ",null,0,null,null,null,null,null,null,"Hauteur bas",6,{"$f":"L35/$A$9","v":24.153201982059066}]
[null,"Hauteur milieu2 bulle ",null,0,null,null,null,null,null,null,"Couple 5"]
[null,"Position fin bulle",null,0,null,null,null,null,null,null,"Position",67.5,{"$f":"L37/$A$9","v":271.72352229816448}]
[null,"Hauteur fin bulle",null,0,null,null,null,null,null,null,"Largeur",10.5,{"$f":"L38/$A$9","v":42.268103468603364}]
["Train","Hauteur du train principal (mm)",24,96.612807928236265,null,null,null,null,null,null,"Hauteur haut",11,{"$f":"L39/$A$9","v":44.28087030044162}]
[null,"Inclinaison du train principal (°)",0,0,null,null,null,null,null,null,"Hauteur bas",11,{"$f":"L40/$A$9","v":44.28087030044162}]
[null,"en mm / axe vertical CG",null,0,null,null,null,null,null,null,"Couple 6"]
[null,"Garde au sol",null,0,null,null,null,null,null,null,"Position",89,{"$f":"L42/$A$9","v":358.27249606720949}]
[null,"Hauteur roulette de nez (mm)",null,0,null,null,null,null,null,null,"Largeur",7.5,{"$f":"L43/$A$9","v":30.191502477573831}]
[null,"Inclinaison  roulette de nez en °",null,0,null,null,null,null,null,null,"Hauteur haut",7,{"$f":"L44/$A$9","v":28.178735645735575}]
[null,"par rapport à l'axe vertical du CG",null,0,null,null,null,null,null,null,"Hauteur bas",9.5,{"$f":"L45/$A$9","v":38.242569804926852}]
[null,"Inclinaison roulette de queue en °",null,0,null,null,null,null,null,null,"Couple 7 emplanture Stab"]
[null,"Hauteur max roulette de queue",null,0,null,null,null,null,null,null,"Position",102,{"$f":"L47/$A$9","v":410.6044336950041}]
[null,"Empattement (mm)",null,0,null,null,null,null,null,null,"Largeur",6,{"$f":"L48/$A$9","v":24.153201982059066}]
[null,"Diamètre des roues (mm)",5,20.127668318382554,null,null,null,null,null,null,"Hauteur haut",5,{"$f":"L49/$A$9","v":20.127668318382554}]
[null,"Voie minimum du train",null,0,null,null,null,null,null,null,"Hauteur bas",9,{"$f":"L50/$A$9","v":36.229802973088596}]
[null,null,null,null,null,null,null,null,null,null,"Couple 8 queue"]
[null,null,null,null,null,null,null,null,null,null,"Position",122.5,{"$f":"L52/$A$9","v":493.12787380037258}]
[null,null,null,null,null,null,null,null,null,null,"Largeur",2,{"$f":"L53/$A$9","v":8.0510673273530209}]
[null,null,null,null,null,null,null,null,null,null,"Hauteur haut",null,{"$f":"L54/$A$9","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Hauteur bas",null,{"$f":"L55/$A$9","v":0}]

{"sheet":"Convertisseur","index":5,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["pouces","cm"]