{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Motorisation"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":114,"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":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[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],[18,1,18,2],[11,8,11,9],[6,8,6,9],[5,8,5,9],[8,8,8,9],[9,8,9,9]]}
[null,"Nom du modèle",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":4.0187757201646094E-15}]
[null,"Type de moteur",3.5,null,"Type d'accu",3.7,null,null,"KV du moteur chosi",null,1100,null,null,"K = ",{"$f":"C21","v":1}]
[null,"Rendement",75,null,"Nombre d'éléments",3,null,null,"Masse du moteur choisi (g)",null,73]
[null,"Puissance massique (W/kg)",200,null,"Etat de l'accu","1/3 du vol",null,null,"Intensité max du moteur choisi (A)",null,22]
[null,"Puissance moteur min (W)",{"$f":"ROUND((Puissance_Massique_Moteur*(O7/1000)),0)","v":116},null,"Tension moy calculée (V)",{"$f":"F4*F5","v":11.100000000000001},null,null,"Puissance max du moteur choisi (W)",null,315,null,null,"Masse du modèle (g)",580]
[null,"Puissance moteur sécu (W)",{"$f":"ROUND(((((Puissance_Massique_Moteur*(O7/1000))*1.02)*100)/Rendement_Moteur),0)","v":158},null,"Ajustement de la tension (V)",11.1,null,null,"Capacité de l'accu choisi (mAh)",null,1800,null,null,"Surface alaire (dm²)",15.2]
[null,"Masse moteur min (g)",{"$f":"ROUND(C8/C4,0)","v":45},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 totale du modèle (g)",{"$f":"Masse_modele+Masse_Reelle_Accu","v":740}]
[null,"Intensité min moteur (A)",{"$f":"ROUND((F10*1.02),1)","v":14.5},null,"Intensité moyenne (A)",{"$f":"ROUND(C8/Tension_Moyenne,1)","v":14.2},null,null,"Intensité de décharge constante conseillée (A)",null,{"$f":"I_Const_Theorique*(2/3)","v":30},"A",null,"Charge Alaire (g/dm²)",{"$f":"O9/O8","v":48.684210526315795}]
[null,"Intensité sécur moteur (A)",{"$f":"ROUND(F11*1.02,1)","v":21.7},null,"Intensité max (A)",{"$f":"ROUND(F10*(3/2),1)","v":21.3},null,null,"Masse calculée de l'accu nu (g)",null,158.8235294117647,"g",null,"Cz aile choisi",0.3]
[null,"Puissance moteur restituée",{"$f":"ROUND(F10*Tension_Moyenne*0.98*(Rendement_Moteur/100),0)","v":116},null,"Capacité min (mAh)",{"$f":"ROUNDUP((F11/F9)*1000,0)","v":852},null,null,"Masse réelle de l'accu choisi (g)",null,160]
[null,"Kv",1100,null,"Masse accu mini nu (g)",75.17647058823529,null,null,null,"Hélice inférieure","hélice choisie","hélice supérieure"]
[null,"Régime théorique à vide",{"$f":"Tension_Moyenne*C13","v":12210},null,null,null,null,null,null,null,null,null,null,null,"km/h","m/s"]
[null,"Régime standard en charge",{"$f":"C14*0.83","v":10134.299999999999},null,"ESC",null,null,null,"Diamètre (pouces)",{"$f":"ROUNDDOWN(F19,0)","v":8},9,{"$f":"ROUNDUP(F19,0)","v":9},null,"Vitesse moy palier",{"$f":"(SQRT((2*9.81)/1.293)*SQRT((Charge_Alaire/10)/Cz_AileChoisi))*3.6","v":56.491899572449327},{"$f":"O15/3.6","v":15.692194325680369}]
[null,null,{"$f":"(((C15*F20*2.54)/100)/1000)*60","v":70.614874465561641},null,"Intensité constante minimum",{"$f":"C10*1.2","v":17.399999999999999},null,null,"Pas (pouces)",{"$f":"ROUNDDOWN(F20,0)","v":4},5,{"$f":"ROUNDUP(F20,0)","v":5},null,"Coefficient de portance max",0.8]
[null,null,{"$f":"C16*0.8","v":56.491899572449313},null,null,null,null,null,"Rapport Pas/Diamètre",{"$f":"J16/J15","v":0.5},{"$f":"K16/K15","v":0.55555555555555558},{"$f":"L16/L15","v":0.55555555555555558},null,"Vitesse décrochage",{"$f":"4.56*SQRT(Charge_Alaire/Czprofildecrochage)","v":35.572461258675929},{"$f":"O17/3.6","v":9.8812392385210917}]
[null,"Mes hélices:","K",null,"Hélice théorique",null,null,null,"Régime à vide",{"$f":"Tension_Moyenne*K4","v":12210},{"$f":"Tension_Moyenne*Kv_Choisi","v":12210},{"$f":"Tension_Moyenne*K4","v":12210},null,"Vitesse air brassé",{"$f":"Vitesse_Moyenne_Palier/0.8","v":70.614874465561655},{"$f":"O18/3.6","v":19.615242907100459}]
[null,"les hélices vérifiées sont en rouge",null,null,"Diamètre (pouces)",{"$f":"(C12/(O3*F20*C15^3))^(1/4)","v":8.8250336616636336},null,null,"Régime standard",{"$f":"J18*0.83","v":10134.299999999999},{"$f":"K18*0.83","v":10134.299999999999},{"$f":"L18*0.83","v":10134.299999999999}]
[null,null,null,null,"Pas (pouces)",{"$f":"Vitesse_Air_Brasse/((2.54*60/100/1000)*Regime_Standard)","v":4.572118396494246},null,null,"Puissance à l'arbre (W)",{"$f":"Coefficient_K*(J16/12)*((J15/12)^4)*((J19/1000)^3)","v":68.53224803296176},{"$f":"Coefficient_K*(Pas_Helice_Libre/12)*((Diametre_Helice_Libre/12)^4)*((K19/1000)^3)","v":137.2192624951972},{"$f":"Coefficient_K*(L16/12)*((L15/12)^4)*((K19/1000)^3)","v":137.2192624951972}]
[null,"9x5 Noire HK ",1,null,"Rapport Pas/Diamètre",{"$f":"F20/F19","v":0.51808509426493699},null,null,"Traction statique (g)",{"$f":"(28.35*(J16)*(J15)^3*J19^2*10^-10)*Coeff_Traction","v":596.30785218385915},{"$f":"(28.35*(Pas_Helice_Libre)*(Diametre_Helice_Libre)^3*K19^2*10^-10)*Coeff_Traction","v":1061.2998638721515},{"$f":"(28.35*(L16)*(L15)^3*L19^2*10^-10)*Coeff_Traction","v":1061.2998638721515}]
[null,null,null,null,"Coeff de traction",1,null,null,"Vitesse air brassé (km/h)",{"$f":"0.001524*$J$19*J16","v":61.778692799999995},{"$f":"0.001524*$K$19*Pas_Helice_Libre","v":77.223365999999999},{"$f":"0.001524*$L$19*L16","v":77.223365999999999},null,"Gestion des Gaz (%)",20]
[null,"6x4,5 rouge aliexpress",1.28,null,"Régime à vide",{"$f":"Tension_Moyenne*KV","v":12210},null,null,"Intensité nécessaire (A)",{"$f":"J20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":8.4001039447155446},{"$f":"K20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":16.819177850732022},{"$f":"L20/Tension_Moyenne/0.98/Rendement_Moteur*100","v":16.819177850732022},null,"Tension moyenne (V)",{"$f":"Tension_Moyenne","v":11.1}]
[null,"7x4",null,null,"Régime standard",{"$f":"F23*0.83","v":10134.299999999999},null,null,"Puissance consommée (W)",{"$f":"J23*Tension_Moyenne","v":93.241153786342537},{"$f":"K23*Tension_Moyenne","v":186.69287414312544},{"$f":"L23*Tension_Moyenne","v":186.69287414312544},null,"Intensité correspondante (A)",{"$f":"(O22/100)*K23","v":3.3638355701464047}]
[null,"SF E 8x3.8",1.8,null,"Puissance à l'arbre (W)",{"$f":"Coefficient_K*(F20/12)*((F19/12)^4)*((F24/1000)^3)","v":116.00000000000007},null,null,"Tension moyenne (V)",{"$f":"J24/J23","v":11.1},{"$f":"K24/K23","v":11.1},{"$f":"L24/L23","v":11.1},null,"Puissance consommée (W)",{"$f":"O23*O24","v":37.338574828625092}]
[null,"GWS EP DD 8x4",null,null,"Traction statique (g)",{"$f":"(28.35*(F20)*(F19)^3*F24^2*10^-10)*Coeff_Traction","v":914.97063434447989},null,null,"Puissance massique (W/kg)",{"$f":"J20/($O$7/1000)","v":118.15904833269271},{"$f":"K20/($O$7/1000)","v":236.58493533654692},{"$f":"L20/($O$7/1000)","v":236.58493533654692},null,"Traction statique (g)",{"$f":"(28.35*(Pas_Helice_Libre)*(Diametre_Helice_Libre)^3*O28^2*10^-10)*Coeff_Traction","v":362.95944788652628}]
[null,"APC 8x4 E",1.3,null,"Vitesse air brassé (km/h)",{"$f":"0.001524*F24*F20","v":70.614874465561655},null,null,"Vitesse de vol (km/h)",{"$f":"J22*0.8","v":49.422954239999996},{"$f":"K22*0.8","v":61.778692800000002},{"$f":"L22*0.8","v":61.778692800000002},null,"Puissance à l'arbre",{"$f":"O24*$O$23*0.98*(Rendement_Moteur/100)","v":27.443852499039444}]
[null,"SF Electric Prop 8x4.5",null,null,"Intensité nécessaire (A)",{"$f":"F25/Tension_Moyenne/0.98/Rendement_Moteur*100","v":14.218299932585657},null,null,"Autonomie plein gaz (mn)",{"$f":"Capacite_Accu_Choisie/1000/J23*60*0.95","v":12.21413457205432},{"$f":"Capacite_Accu_Choisie/1000/K23*60*0.95","v":6.1001792662258181},{"$f":"Capacite_Accu_Choisie/1000/L23*60*0.95","v":6.1001792662258181},null,"Régime (T/mn)",{"$f":"(O27/(Diametre_Helice_Libre^4*O3*Pas_Helice_Libre))^(1/3)","v":5926.574592874128}]
[null,"SF E 9x4.7",1.24,null,null,null,null,null,null,null,null,null,null,"Vitesse air brassé",{"$f":"0.001524*$O$28*Pas_Helice_Libre","v":45.160498397700849},{"$f":"O29/3.6","v":12.544582888250236}]
[null,"TP Slow Fly  10x4.7 GWS",1.4,null,null,null,null,null,"Turnigy D3530/14 1100KV Brushless Outrunner Motor",null,null,null,null,"Vitesse de vol (km/h)(m/s)",{"$f":"O29*0.8","v":36.128398718160682},{"$f":"O30/3.6","v":10.03566631060019}]
[null,"GWS EP DD 10x6",0.84,null,null,null,null,null,"Kv annoncé",1100,"mesuré"]
[null,"APC 11x5.5 E",0.94,null,"Hélices théoriques","K",null,null,"22A","2S","11x7"]
[null,"Beech wood 12x5",0.65,null,null,null,null,null,"315W","3S","9x5"]
[null,"Cherry wood 12x6",null,null,"APC 9x5",1.1000000000000001,null,null,"73g","4S","7x3"]
[null," GWS EP RD 12x6"]