{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["couple.puissance","calcul résistance clignotant","calcul dimension carburateur","refroidissement éolien","calcul pastilles","calcul transmission"],"not_rendered":{"images":1,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"couple.puissance","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"flags":["formulas_cached_only"]}
["1 cheval vapeur = 0.736 w"]
["Puissance en chevaux",null,143,"cv"]
["Puissance en Kilowatt",null,105.248,"Kw"]
["Régime de puissance maxi",null,10000,"tr/mn"]
["couple maxi",null,10.6,"daN.m"]
["régime de couple maxi",null,7500,"tr/mn"]
["accélération de la pesanteur"]
["paris 9.809 m/s²",null,9.809,"m/s/s"]
["équateur 9.709 m/s²"]
["Pole 9.833 m/s²"]
[]
[]
[null,"Couple au régime de puissance maximum",{"$nulls":3},{"v":10.246447234491374,"d":"10.25"},"daN.m"]
[]
[null,"puissance au regime de couple maxi",{"$nulls":3},{"v":110.95065186820652,"d":"110.95"},"cv"]

{"sheet":"calcul résistance clignotant","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"flags":["formulas_cached_only"]}
["tension en volt",null,12,"volt"]
["puissance en watt d'origine",null,21,"watt"]
["nouvelle puissance en watt",null,5,"watt"]
[]
["amperage origine",null,1.75,"ampère"]
["resistance origine",null,{"v":6.857142857142857,"d":"6.857"},"ohm"]
[]
["amperage nouveau",null,0.4166666666666667,"ampère"]
["resistance nouveau",null,{"v":28.799999999999997,"d":"28.80"},"ohm"]
[]
["resistance a prevoir",null,{"v":9,"d":"9.00"},"ohm"]

{"sheet":"calcul dimension carburateur","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"flags":["formulas_cached_only"]}
["nombre de cylindres",null,null,4]
["cylindrée totale",null,null,1000]
["cylindrée unitaire en cm3",null,null,250,"V"]
["regime de puissance maximum en tr/mn",null,null,10000,"N"]
["K (entre 0.75 et 0.85)",null,null,0.8,"K"]
["pour un mono entre 0.7 et 0.75"]
[]
["formule :"]
["D=K x racine carrée(V x N/1000)"]
[]
[]
["dimension carburateur",null,40]

{"sheet":"refroidissement éolien","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"flags":["formulas_cached_only"]}
["Calcul de la temopérature resssenti en fonction de la température ambiuance et de la vitesse du vent ou d'avancement"]
[]
["vitesse du vent ou d'avancement",null,80,"km/h"]
["température ambiante",null,-45,"degré celcius"]
[]
["refroidissement éolien",null,-73.74042481246158,"degrés celcius"]

{"sheet":"calcul pastilles","index":4,"n_rows":19,"n_cols":18,"rows_kept":19,"flags":["formulas_cached_only"]}
[]
["valeur mini admission",0.11]
["valeur maxi admission",0.2]
["valeur mini echappement",0.21]
["valeur maxi echappement",0.3]
[]
[null,"admission","echappement",{"$nulls":12},"admission 2"]
["jeu mesuré",0.67,0.255,{"$nulls":14},"ligne à documenter"]
[{"$nulls":15}," +"]
["valeur pastille en place",155,255,{"$nulls":14},"ligne à documenter"]
[{"$nulls":15}," -"]
[null,0.155,0.255,{"$nulls":12},{"$error":"#REF!"}]
[{"$nulls":15}," = "]
["valeur nouvelle pastille",{"v":206.50000000000003,"d":"207"},{"v":254.99999999999997,"d":"255"},null,"jeu mesuré + pastille en place - jeu moyen = valeur nouvelle pastille",{"$nulls":10},{"$error":"#REF!"}]
[]
["SI le chiffre obtenu fini par 1 ou 2 prendre la pastille inférieure en terminaison 0 (exemple 182=180)"]
["Si le chiffre obtenu fini par 3,4,6 ou 7 prendre la pastille en terminaison 5 (exemple 187=185)"]
["si le chiffre obtenu fini par 8 ou 9 prendre la pastille supérieure en terminaison 0 (exemple 188=190)"]
["Si le chiffre obtenu fini par 0 ou 5 prendre la pastille exacte"]

{"sheet":"calcul transmission","index":5,"n_rows":48,"n_cols":38,"rows_kept":48,"merged":[[0,2,2,38],[4,17,4,24],[5,23,5,24],[8,2,8,11],[8,17,8,24],[8,31,8,37],[9,2,9,3],[9,10,9,11],[9,17,9,24],[9,31,9,32],[9,33,9,35],[9,36,9,37],[10,2,10,3],[10,10,10,11],[10,17,10,24],[10,31,10,32],[10,33,10,35],[10,36,10,37],[11,2,11,3],[11,10,11,11],[11,17,11,24],[12,2,12,3],[12,10,12,11],[12,17,12,24],[12,31,12,33],[12,34,12,36],[13,2,13,3],[13,10,13,11],[13,17,13,24],[13,31,13,33],[13,34,13,36],[14,2,14,3],[14,10,14,11],[14,17,14,24],[17,17,17,24],[18,4,18,13],[18,23,18,24],[18,28,18,37],[22,4,22,37],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[23,22,23,23],[23,24,23,25],[23,26,23,27],[23,28,23,29],[23,30,23,31],[23,32,23,33],[23,34,23,35],[23,36,23,37],[24,2,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,19],[24,20,24,21],[24,22,24,23],[24,24,24,25],[24,26,24,27],[24,28,24,29],[24,30,24,31],[24,32,24,33],[24,34,24,35],[24,36,24,37],[25,2,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[25,20,25,21],[25,22,25,23],[25,24,25,25],[25,26,25,27],[25,28,25,29],[25,30,25,31],[25,32,25,33],[25,34,25,35],[25,36,25,37],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[26,20,26,21],[26,22,26,23],[26,24,26,25],[26,26,26,27],[26,28,26,29],[26,30,26,31],[26,32,26,33],[26,34,26,35],[26,36,26,37],[27,2,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[27,22,27,23],[27,24,27,25],[27,26,27,27],[27,28,27,29],[27,30,27,31],[27,32,27,33],[27,34,27,35],[27,36,27,37],[28,2,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17],[28,18,28,19],[28,20,28,21],[28,22,28,23],[28,24,28,25],[28,26,28,27],[28,28,28,29],[28,30,28,31],[28,32,28,33],[28,34,28,35],[28,36,28,37],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[29,20,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[29,28,29,29],[29,30,29,31],[29,32,29,33],[29,34,29,35],[29,36,29,37]],"flags":["formulas_cached_only"]}
[null,null,"Vitesse théorique en fonction des rapports de boite, de la transmission finale et du pneu utilisé"]
[]
[]
[]
[{"$nulls":17},"Réduction primaire (1)"]
[null,null,"nota : Seules les cases grisées peuvent être modifiées.",{"$nulls":14},43,"x",68,"=",1,":",{"v":1.5813953488372092,"d":"1.581"}]
[]
[]
[null,null,"Rapport de boite (2)",{"$nulls":14},"Réduction totale (1)x(2)x(3)",{"$nulls":13},"Circonférence roue (m)"]
[null,null,"1ère",null,14,"x",35,"=",1,":",{"v":2.5,"d":"2.500"},{"$nulls":6},{"v":10.872093023255815,"d":"10.872"},{"$nulls":13},"Larg.",null,"Haut.",null,null,"Ø (\")"]
[null,null,"2ème",null,19,"x",35,"=",1,":",{"v":1.8421052631578947,"d":"1.842"},{"$nulls":6},{"v":8.011015911872704,"d":"8.011"},{"$nulls":13},180,null,55,null,null,17]
[null,null,"3ème",null,20,"x",30,"=",1,":",{"v":1.5,"d":"1.500"},{"$nulls":6},{"v":6.5232558139534875,"d":"6.523"}]
[null,null,"4ème",null,21,"x",28,"=",1,":",{"v":1.3333333333333333,"d":"1.333"},{"$nulls":6},{"v":5.7984496124031,"d":"5.798"},{"$nulls":13},"Théorique :",null,null,{"v":1.9785750532308517,"d":"1.979"},null,null,"m"]
[null,null,"5ème",null,25,"x",30,"=",1,":",{"v":1.2,"d":"1.200"},{"$nulls":6},{"v":5.21860465116279,"d":"5.219"},{"$nulls":13},"Réélle :",null,null,1.9024760127219726,null,null,"m"]
[null,null,"6ème",null,26,"x",29,"=",1,":",{"v":1.1153846153846154,"d":"1.115"},{"$nulls":6},{"v":4.850626118067979,"d":"4.851"}]
[]
[]
[{"$nulls":17},"Rapport final (3)"]
[{"$nulls":17},16,"x",44,"=",1,":",{"v":2.75,"d":"2.750"}]
[]
[]
[]
[{"$nulls":4},"Vitesse théorique / régime moteur (km/h)"]
[{"$nulls":4},1000,null,2000,null,3000,null,4000,null,5000,null,5500,null,6000,null,7000,null,8000,null,9000,null,9500,null,10000,null,10500,null,11000,null,11500,null,12000,null,12500]
[null,null,"1ère",null,{"v":10.499225909781153,"d":"10.50"},null,{"v":20.998451819562305,"d":"21.00"},null,{"v":31.497677729343458,"d":"31.50"},null,{"v":41.99690363912461,"d":"42.00"},null,{"v":52.49612954890576,"d":"52.50"},null,{"v":57.74574250379634,"d":"57.75"},null,{"v":62.995355458686916,"d":"63.00"},null,{"v":73.49458136846806,"d":"73.49"},null,{"v":83.99380727824922,"d":"83.99"},null,{"v":94.49303318803037,"d":"94.49"},null,{"v":99.74264614292096,"d":"99.74"},null,{"v":104.99225909781153,"d":"104.99"},null,{"v":110.2418720527021,"d":"110.24"},null,{"v":115.49148500759269,"d":"115.49"},null,{"v":120.74109796248327,"d":"120.74"},null,{"v":125.99071091737383,"d":"125.99"},null,{"v":131.2403238722644,"d":"131.24"}]
[null,null,"2ème",null,{"v":14.24894944898871,"d":"14.25"},null,{"v":28.49789889797742,"d":"28.50"},null,{"v":42.74684834696613,"d":"42.75"},null,{"v":56.99579779595484,"d":"57.00"},null,{"v":71.24474724494354,"d":"71.24"},null,{"v":78.3692219694379,"d":"78.37"},null,{"v":85.49369669393226,"d":"85.49"},null,{"v":99.74264614292098,"d":"99.74"},null,{"v":113.99159559190969,"d":"113.99"},null,{"v":128.2405450408984,"d":"128.24"},null,{"v":135.36501976539276,"d":"135.37"},null,{"v":142.48949448988708,"d":"142.49"},null,{"v":149.61396921438148,"d":"149.61"},null,{"v":156.7384439388758,"d":"156.74"},null,{"v":163.86291866337015,"d":"163.86"},null,{"v":170.98739338786453,"d":"170.99"},null,{"v":178.1118681123589,"d":"178.11"}]
[null,null,"3ème",null,{"v":17.498709849635258,"d":"17.50"},null,{"v":34.997419699270516,"d":"35.00"},null,{"v":52.49612954890577,"d":"52.50"},null,{"v":69.99483939854103,"d":"69.99"},null,{"v":87.4935492481763,"d":"87.49"},null,{"v":96.24290417299392,"d":"96.24"},null,{"v":104.99225909781154,"d":"104.99"},null,{"v":122.49096894744682,"d":"122.49"},null,{"v":139.98967879708206,"d":"139.99"},null,{"v":157.48838864671737,"d":"157.49"},null,{"v":166.23774357153496,"d":"166.24"},null,{"v":174.9870984963526,"d":"174.99"},null,{"v":183.7364534211702,"d":"183.74"},null,{"v":192.48580834598783,"d":"192.49"},null,{"v":201.2351632708055,"d":"201.24"},null,{"v":209.98451819562308,"d":"209.98"},null,{"v":218.73387312044073,"d":"218.73"}]
[null,null,"4ème",null,{"v":19.686048580839667,"d":"19.69"},null,{"v":39.372097161679335,"d":"39.37"},null,{"v":59.05814574251899,"d":"59.06"},null,{"v":78.74419432335867,"d":"78.74"},null,{"v":98.43024290419832,"d":"98.43"},null,{"v":108.27326719461817,"d":"108.27"},null,{"v":118.11629148503798,"d":"118.12"},null,{"v":137.80234006587764,"d":"137.80"},null,{"v":157.48838864671734,"d":"157.49"},null,{"v":177.17443722755698,"d":"177.17"},null,{"v":187.01746151797684,"d":"187.02"},null,{"v":196.86048580839665,"d":"196.86"},null,{"v":206.70351009881648,"d":"206.70"},null,{"v":216.54653438923634,"d":"216.55"},null,{"v":226.38955867965615,"d":"226.39"},null,{"v":236.23258297007595,"d":"236.23"},null,{"v":246.07560726049584,"d":"246.08"}]
[null,null,"5ème",null,{"v":21.87338731204407,"d":"21.87"},null,{"v":43.74677462408814,"d":"43.75"},null,{"v":65.6201619361322,"d":"65.62"},null,{"v":87.49354924817628,"d":"87.49"},null,{"v":109.36693656022037,"d":"109.37"},null,{"v":120.3036302162424,"d":"120.30"},null,{"v":131.2403238722644,"d":"131.24"},null,{"v":153.11371118430853,"d":"153.11"},null,{"v":174.98709849635256,"d":"174.99"},null,{"v":196.86048580839665,"d":"196.86"},null,{"v":207.79717946441866,"d":"207.80"},null,{"v":218.73387312044073,"d":"218.73"},null,{"v":229.67056677646275,"d":"229.67"},null,{"v":240.6072604324848,"d":"240.61"},null,{"v":251.54395408850684,"d":"251.54"},null,{"v":262.4806477445288,"d":"262.48"},null,{"v":273.4173414005509,"d":"273.42"}]
[null,null,"6ème",null,{"v":23.532747728819825,"d":"23.53"},null,{"v":47.06549545763965,"d":"47.07"},null,{"v":70.59824318645948,"d":"70.60"},null,{"v":94.1309909152793,"d":"94.13"},null,{"v":117.66373864409913,"d":"117.66"},null,{"v":129.43011250850907,"d":"129.43"},null,{"v":141.19648637291897,"d":"141.20"},null,{"v":164.72923410173877,"d":"164.73"},null,{"v":188.2619818305586,"d":"188.26"},null,{"v":211.79472955937842,"d":"211.79"},null,{"v":223.56110342378835,"d":"223.56"},null,{"v":235.32747728819825,"d":"235.33"},null,{"v":247.09385115260815,"d":"247.09"},null,{"v":258.86022501701814,"d":"258.86"},null,{"v":270.62659888142804,"d":"270.63"},null,{"v":282.39297274583794,"d":"282.39"},null,{"v":294.1593466102478,"d":"294.16"}]
[]
[]
[]
[{"$nulls":25},"Calcul d'une circonférence théorique d'une roue."]
[]
[]
[]
[{"$nulls":25},"Pour connaître la circonférence de roulement d'une roue, il faudra calculer le diamètre extérieur qui dépend de la hauteur du flanc et du diamètre intérieur du pneu ou diamètre de la jante."]
[]
[{"$nulls":25},"A titre d'exemple, prenons un pneu de 160 x 60 x 17"]
[]
[{"$nulls":17},"La hauteur en mm du flanc sera égale à                        : 160 x 60 : 100 = 96,00 mm"]
[{"$nulls":17},"Le diamètre de la jante sera égale à                             : 17 x 25,4 = 431,80 mm"]
[{"$nulls":17},"Le diamètre de la roue avec son pneu sera égale à        : 96 + 431,8 + 96= 623,80 mm"]
[]
[{"$nulls":17},"La circonférence de la roue sera égale à                      : 623,80 x 3,14 = 1958,73 mm"]
[]
[{"$nulls":25},"Ce calcul est purement théorique et ne tient pas compte de la charge à la quelle la roue est soumise ni des différences entre les dimensions pratiquées par les constructeurs de pneumatiques."]