{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Motorisation","masses"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":1,"defined_names":152,"comments":1,"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":"Motorisation","index":0,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[11,8,11,9],[6,8,6,9],[5,8,5,9],[8,8,8,9],[9,8,9,9],[15,1,15,2],[0,3,0,15],[0,1,0,2],[29,8,29,11],[2,8,2,11],[2,1,2,2],[2,4,2,5],[14,4,14,5],[17,4,17,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]]}
[null,"YAK 54 Seagull Model",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 10/01/2022"]
[]
[null,"moteur",null,null,"accu",null,null,null,"Vérifications",null,null,null,null,"Boucher ",{"$f":"O4/(12^5*1000^3)","v":4.822530864197531E-15}]
[null,"Type de moteur",4,null,"Type d'accu",3.7,null,null,"KV du moteur chosi",null,430,null,null,"K = ",1.2]
[null,"Rendement",85,null,"Nombre d'éléments",6,null,null,"Masse du moteur choisi (g)",null,378]
[null,"Puissance massique (W/kg)",300,null,"Etat de l'accu","1/3 du vol",null,null,"Intensité max du moteur choisi (A)",null,70,null,null,null,"km/h","m/s"]
[null,"Puissance moteur min (W)",{"$f":"ROUND((Puissance_Massique_Moteur*(Masse_totale_modele/1000)),0)","v":1200},null,"Tension moy calculée (V)",{"$f":"F4*F5","v":22.200000000000003},null,null,"Puissance max du moteur choisi (W)",null,1750,null,null,"Vitesse moy palier",{"$f":"(SQRT((2*9.81)/1.293)*SQRT((Charge_Alaire/10)/Cz_AileChoisi))*3.6","v":69.298811569347222},{"$f":"O7/3.6","v":19.249669880374228}]
[null,"Puissance moteur sécu (W)",{"$f":"ROUND(((((Puissance_Massique_Moteur*(Masse_totale_modele/1000))*1.02)*100)/Rendement_Moteur),0)","v":1440},null,"Ajustement de la tension (V)",22.2,null,null,"Capacité de l'accu choisi (mAh)",null,4000,null,null,"Coefficient de portance max",0.8]
[null,"Masse moteur min (g)",{"$f":"ROUND(Puissance_moteur_secu/Type_Moteur,0)","v":360},null,"Taux de décharge max (C)",40,null,null,"Intensité de décharge constante théorique (A)",null,{"$f":"Capacite_Accu_Choisie*Taux_Decharge_Accu/1000","v":160},"A",null,"Vitesse décrochage",{"$f":"4.56*SQRT(Charge_Alaire/Czprofildecrochage)","v":43.636863134004301},{"$f":"O9/3.6","v":12.12135087055675}]
[null,"Intensité min moteur (A)",{"$f":"ROUNDUP((Intensite_moyenne*1.05),0)","v":69},null,"Intensité moyenne (A)",{"$f":"ROUND(Puissance_moteur_secu/Tension_Moyenne,1)","v":64.900000000000006},null,null,"Intensité de décharge constante conseillée (A)",null,{"$f":"I_Const_Theorique*(2/3)","v":106.66666666666666},"A",null,"Vitesse air brassé",{"$f":"Vitesse_Moyenne_Palier/0.8","v":86.623514461684024},{"$f":"O10/3.6","v":24.062087350467785}]
[null,"Puissance moteur restituée",{"$f":"ROUND(Intensite_moyenne*Tension_Moyenne*0.98*(Rendement_Moteur/100),0)","v":1200},null,"Intensité max (A)",{"$f":"ROUND(Intensite_moyenne*1.5,1)","v":97.4},null,null,"Masse calculée de l'accu nu (g)",null,631.57894736842104,"g"]
[null,"Kv",500,null,"Capacité min (mAh)",{"$f":"ROUNDUP((intensite_max/Taux_Decharge_Accu)*1000,0)","v":2435},null,null,"Masse réelle de l'accu choisi (g)",null,605]
[null,"Régime théorique à vide",{"$f":"Tension_Moyenne*KV","v":11100},null,"Masse accu mini nu (g)",405.83333333333331,null,null,null,"Hélice inférieure","hélice choisie","hélice supérieure",null,"Gestion des Gaz (%)",100]
[null,"Régime standard en charge",{"$f":"C13*0.83","v":9213},null,null,null,null,null,null,null,null,null,null,"Tension moyenne (V)",{"$f":"Tension_Moyenne","v":22.2}]
[null,null,null,null,"ESC",null,null,null,"Diamètre (pouces)",{"$f":"ROUNDDOWN(F19,0)","v":15},15,{"$f":"ROUNDUP(F19,0)","v":16},null,"Intensité correspondante (A)",{"$f":"(O13/100)*K23","v":52.532809804536399}]
[null,"Modèle",null,null,"Intensité constante minimum",{"$f":"intensite_mini_moteur*1.2","v":82.8},null,null,"Pas (pouces)",{"$f":"ROUNDDOWN(F20,0)","v":6},8,{"$f":"ROUNDUP(F20,0)","v":7},null,"Puissance consommée (W)",{"$f":"O14*O15","v":1166.228377660708}]
[null,"Surface alaire (dm²)",54.6,null,null,null,null,null,"Rapport Pas/Diamètre",{"$f":"J16/J15","v":0.4},{"$f":"K16/K15","v":0.53333333333333333},{"$f":"L16/L15","v":0.4375},null,"Traction statique (g)",{"$f":"(28.35*(Pas_Helice_Libre)*(Diametre_Helice_Libre)^3*O19^2*10^-10)*Coeff_Traction","v":3459.7790824015151}]
[null,"Masse totale du modèle (g)",4000,null,"Hélice théorique",null,null,null,"Régime à vide",{"$f":"Tension_Moyenne*K4","v":9546},{"$f":"Tension_Moyenne*Kv_Choisi","v":9546},{"$f":"Tension_Moyenne*K4","v":9546},null,"Puissance à l'arbre",{"$f":"O15*$O$14*0.98*(Rendement_Moteur/100)","v":971.46823859136975}]
[null,"Charge Alaire (g/dm²)",{"$f":"Masse_totale_modele/Surface_alaire","v":73.260073260073256},null,"Diamètre (pouces)",{"$f":"(C11/(O3*F20*C14^3))^(1/4)","v":15.070002132736072},null,null,"Régime standard",{"$f":"J18*0.83","v":7923.1799999999994},{"$f":"K18*0.83","v":7923.1799999999994},{"$f":"L18*0.83","v":7923.1799999999994},null,"Régime (T/mn)",{"$f":"(O18/(Diametre_Helice_Libre^4*O3*Pas_Helice_Libre))^(1/3)","v":7923.1800000000012}]
[null,"Cz aile choisi",0.3,null,"Pas (pouces)",{"$f":"Vitesse_Air_Brasse/((2.54*60/100/1000)*Regime_Standard)","v":6.1694970605044874},null,null,"Puissance à l'arbre (W)",{"$f":"Coefficient_K*(J16/12)*((J15/12)^4)*((J19/1000)^3)","v":728.60117894352732},{"$f":"Coefficient_K*(Pas_Helice_Libre/12)*((Diametre_Helice_Libre/12)^4)*((K19/1000)^3)","v":971.46823859136964},{"$f":"Coefficient_K*(L16/12)*((L15/12)^4)*((K19/1000)^3)","v":1100.40246269202},null,"Vitesse air brassé",{"$f":"0.001524*$O$19*Pas_Helice_Libre","v":96.59941056000001},{"$f":"O20/3.6","v":26.833169600000002}]
[null,null,null,null,"Rapport Pas/Diamètre",{"$f":"F20/F19","v":0.40938926260021496},null,null,"Traction statique (g)",{"$f":"(28.35*(J16)*(J15)^3*J19^2*10^-10)*Coeff_Traction","v":2594.8343118011358},{"$f":"(28.35*(Pas_Helice_Libre)*(Diametre_Helice_Libre)^3*K19^2*10^-10)*Coeff_Traction","v":3459.7790824015128},{"$f":"(28.35*(L16)*(L15)^3*L19^2*10^-10)*Coeff_Traction","v":3674.0291055783773},null,"Vitesse de vol (km/h)(m/s)",{"$f":"O20*0.8","v":77.279528448000008},{"$f":"O21/3.6","v":21.466535680000003}]
[null,null,null,null,"Coeff de traction",0.72,null,null,"Vitesse air brassé (km/h)",{"$f":"0.001524*$J$19*J16","v":72.44955791999999},{"$f":"0.001524*$K$19*Pas_Helice_Libre","v":96.599410559999995},{"$f":"0.001524*$L$19*L16","v":84.524484239999992}]
[null,null,null,null,"Régime à vide",{"$f":"Tension_Moyenne*KV","v":11100},null,null,"Intensité nécessaire (A)",{"$f":"J20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":39.399607353402295},{"$f":"K20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":52.532809804536399},{"$f":"L20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":59.505016206051074}]
[null,null,null,null,"Régime standard",{"$f":"F23*0.83","v":9213},null,null,"Puissance consommée (W)",{"$f":"J23*Tension_Moyenne","v":874.67128324553096},{"$f":"K23*Tension_Moyenne","v":1166.228377660708},{"$f":"L23*Tension_Moyenne","v":1321.0113597743339}]
[null,null,null,null,"Puissance à l'arbre (W)",{"$f":"Coefficient_K*(F20/12)*((F19/12)^4)*((F24/1000)^3)","v":1199.9999999999998},null,null,"Tension moyenne (V)",{"$f":"J24/J23","v":22.2},{"$f":"K24/K23","v":22.2},{"$f":"L24/L23","v":22.2}]
[null,null,null,null,"Traction statique (g)",{"$f":"(28.35*(F20)*(F19)^3*F24^2*10^-10)*Coeff_Traction","v":3658.2838934334891},null,null,"Puissance massique (W/kg)",{"$f":"J20/($C$18/1000)","v":182.15029473588183},{"$f":"K20/($C$18/1000)","v":242.86705964784241},{"$f":"L20/($C$18/1000)","v":275.100615673005}]
[null,null,null,null,"Vitesse air brassé (km/h)",{"$f":"0.001524*F24*F20","v":86.623514461684024},null,null,"Vitesse de vol (km/h)",{"$f":"J22*0.8","v":57.959646335999992},{"$f":"K22*0.8","v":77.279528448000008},{"$f":"L22*0.8","v":67.619587392}]
[null,null,null,null,"Intensité nécessaire (A)",{"$f":"F25/Tension_Moyenne/0.98/Rendement_Moteur*100","v":64.890821193342191},null,null,"Autonomie plein gaz (mn)",{"$f":"Capacite_Accu_Choisie/1000/J23*60*0.95","v":5.7868597002734186},{"$f":"Capacite_Accu_Choisie/1000/K23*60*0.95","v":4.3401447752050641},{"$f":"Capacite_Accu_Choisie/1000/L23*60*0.95","v":3.8316097454791493}]
[]
[null,null,null,null,null,null,null,null,"Turnigy Aerodrive SK3 - 5055-430KV"]
[null,null,null,null,null,null,null,null,"Kv annoncé",430,"mesuré"]
[null,null,null,null,null,null,null,null,"5S à 8S"]
[null,null,null,null,null,null,null,null,"70A",null,"axe 6mm"]
[null,null,null,null,null,null,null,null,"1750W",null,"378g"]

{"sheet":"masses","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Colonne1","Colonne2"]
[null,"capot",178]
[null,"accastillage",260]
[null,"train",213]
[null,"caches roues",130]
[null,"fuselage et pilote",940]
[null,"dérive",57]
[null,"profondeur",82]
[null,"aile G",328]
[null,"aile D",346]
[null,"clé aile",130]
[]
[null,"accus 6S 4000",605]
[null,"moteur",380]
[null,"servos (6)",240]
[null,"récepteur ",20]
[null,"esc",60]
[]
[null,"total:",{"$f":"SUM(C3:C19)","v":3969}]