{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Etagements","Autres Graphes","Calculs de Vitesses"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Etagements","index":0,"n_rows":437,"n_cols":62,"rows_kept":437,"cut":false,"hidden":false,"merged":[[2,5,2,6],[221,2,222,2],[12,1,12,2],[4,1,4,2],[139,2,140,2],[14,6,15,6]]}
[]
[null,"Copyright Olivier ADLER 2024"]
[null,"MotorSport@StoneRecording.art",null,null,null,"Pneus"]
[null,null,null,null,null,"diamètre (pouces)",null,16]
[null,"Les valeurs en vert sont modifiables",null,null,null,"largeur (mm)",null,275]
[null,"Nombre de vitesses (n)",null,6,null,"hauteur de flancs (% de largeur)",null,70]
[null,"Rapport de 1ère vitesse (R1)",null,4.2,null,"Coefficient d'écrasement",null,0.97]
[null,"Rapport de dernière vitesse (Rn)",null,0.75,null,"Rayon effectif calculéen m",null,{"$f":"H10*H7/2/1000","v":0.38382899999999998}]
[null,"Rapport de pont",null,4.1100000000000003,null,"hauteur de flanc calculée (mm)",null,{"$f":"H5*H6/100","v":192.5}]
[null,"Rapport de transfert long",null,1,null,"diamètre total calculé (mm)",null,{"$f":"H4*25.4+2*H9","v":791.4}]
[null,"Rapport de transfert court",null,2.4900000000000002,null,"circonférence calculée (m)",null,{"$f":"PI()*H10/1000","v":2.4862564260509621}]
[null,"Coefficient logarithmique",null,0.1]
[]
[null,"Coefficient de progression linéaire calculé (r)",null,{"$f":"(D8/D7)^(1/(D6-1))","v":0.70853677231904288}]
[null,null,null,null,null,null,"Couple\nMoteur N.m"]
[null,"Résistance aérodynamique",null,null,null,null,null,"RPM"]
[null,null,null,null,null,null,79,750]
[null,null,null,null,null,null,106,1000]
[null,null,"vitesse du véhicule en m/s",null,null,null,135,1250]
[null,null,"surface frontale en m²",2.2000000000000002,null,null,162,1500]
[null,null,"coefficient de traînée",0.32,null,null,190,1750]
[null,null,"densitée de l'air en kg/m3",1.2,null,null,220,2000]
[null,null,null,null,null,null,250,2250]
[null,"Résistance au roulement ",null,null,null,null,270,2500]
[null,null,null,null,null,null,280,2750]
[null,null,null,null,null,null,275,3000]
[null,null,"masse du véhicule en kg",1600,null,null,260,3250]
[null,null,"coefficient de roulement",0.01,null,null,245,3500]
[null,null,"pesanteur en m/s²",9.81,null,null,222,3750]
[null,"Résistance au roulement calculée en N",null,{"$f":"D28*D27*D29","v":156.96},null,null,198,4000]
[null,null,null,null,null,null,140,4700]
[null,null,null,null,null,null,0,{"$f":"H31+1","v":4701}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Rapports longs progression linéaire",null,null,null,"Rapports longs progression logarithmique",null,null,null,null,"Rapports courts progression linéaire",null,null,null,"Rapports courts progression logarithmique"]
[null,null,null,null,null,null,null,null,null,"Vitesse","Linéaire","Différences",null,"Vitesse","Log","Différences",null,null,"Vitesse","Linéaire","Différences",null,"Vitesse","Log","Différences"]
[]
[null,null,null,null,null,null,null,null,null,1,{"$f":"$D$7*$D$10*$D$14^(J42-1)","v":4.2},null,null,1,{"$f":"$D$10*$D$7*($D$8/$D$7)^(LOG10(($N42-1)*($D$12)+1)/LOG10(($D$6-1)*$D$12+1))","v":4.2},null,null,null,1,{"$f":"$D$7*$D$11*$D$14^(S42-1)","v":10.458000000000002},null,null,1,{"$f":"IF($D$6-W42>=0,$D$11*$D$7*($D$8/$D$7)^(LOG10((W42-1)*($D$12)+1)/LOG10(($D$6-1)*$D$12+1)),0)","v":10.458000000000002},null,null,"Progression Linéaire"]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($D$6-J43>=0,$D$7*$D$10*$D$14^(J43-1),0)","v":2.9758544437399803},{"$f":"IF($D$6-J43>=0,(K43/K42)-1,0)","v":-0.29146322768095712},null,2,{"$f":"IF($D$6-N43>=0,$D$10*$D$7*($D$8/$D$7)^(LOG10(($N43-1)*($D$12)+1)/LOG10(($D$6-1)*$D$12+1)),0)","v":2.8014143558651514},{"$f":"IF($D$6-N43>=0,(O43/O42)-1,0)","v":-0.33299658193686876},null,null,2,{"$f":"IF($D$6-S43>=0,$D$7*$D$11*$D$14^(S43-1),0)","v":7.4098775649125521},{"$f":"IF($D$6-S43>=0,(T43/T42)-1,0)","v":-0.29146322768095712},null,2,6.9755217461042278,{"$f":"IF($D$6-W43>=0,(X43/X42)-1,0)","v":-0.33299658193686876},null,"Calcul du coefficient de progression linéraire"]
[null,null,null,null,null,null,null,null,null,3,2.1085023024588065,-0.29146322768095712,null,3,1.9356144143610456,-0.3090581511768985,null,null,3,5.2501707331224292,-0.29146322768095712,null,3,4.8196798917590042,-0.3090581511768985]
[null,null,null,null,null,null,null,null,null,4,1.4939514158114331,-0.29146322768095712,null,4,1.3775879750538162,-0.28829421560772794,null,null,4,3.7199390253704689,-0.29146322768095712,null,4,3.4301940578840027,-0.28829421560772805]
[null,null,null,null,null,null,null,null,null,5,1.0585195141604973,-0.291463227680957,null,5,1.005474269325666,-0.27011974005770012,null,null,5,2.6357135902596385,-0.291463227680957,null,5,2.5036309306209086,-0.27011974005770001]
[null,null,null,null,null,null,null,null,null,6,0.75,-0.29146322768095723,null,6,0.75,-0.25408334864402149,null,null,6,1.8675000000000004,-0.29146322768095723,null,6,1.8675000000000004,-0.25408334864402149]
[null,null,null,null,null,null,null,null,null,7,0,0,null,7,0,0,null,null,7,0,0,null,7,0,0,null,"Calcul de chaque rapport en progression linéraire"]
[null,null,null,null,null,null,null,null,null,8,0,0,null,8,0,0,null,null,8,0,0,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0,null,9,0,0,null,null,9,0,0,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0,null,10,0,0,null,null,10,0,0,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0,null,11,0,0,null,null,11,0,0,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0,null,12,0,0,null,null,12,0,0,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0,null,13,0,0,null,null,13,0,0,null,13,0,0,null,"Progression Logarithmique"]
[null,null,null,null,null,null,null,null,null,14,0,0,null,14,0,0,null,null,14,0,0,null,14,0,0,null,"Calcul du rapport i en fonction de i, n, k, Rn, R1"]
[null,null,null,null,null,null,null,null,null,15,0,0,null,15,0,0,null,null,15,0,0,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0,null,16,0,0,null,null,16,0,0,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0,null,17,0,0,null,null,17,0,0,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0,null,18,0,0,null,null,18,0,0,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0,null,19,0,0,null,null,19,0,0,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0,null,20,0,0,null,null,20,0,0,null,20,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Forces de frottement en Newtons en fonction de la vitesse de rotation moteur, pour chaque rapport"]
[null,null,null,null,"RPM",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,{"$f":"H17","v":750},{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F114^2)+$D$30,0)","v":173.65559950530411},194.48717732364074,235.56730443319537,312.14934951187718,448.27220243090687,680.53400048633705,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1000,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F115^2)+$D$30,0)","v":186.64106578720734},223.67498190869463,296.70631899234718,432.85217691000378,674.8483598771677,1087.7582230868213,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1250,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F116^2)+$D$30,0)","v":203.33666529251144},261.20215923233536,375.31362342554246,588.04152642188092,966.16056230807453,1611.3322235731584,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1500,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F117^2)+$D$30,0)","v":223.74239802121647},307.06870929456295,471.38921773278139,777.71739804750882,1322.2088097236274,2251.2560019453481,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1750,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F118^2)+$D$30,0)","v":247.85826397332244},361.27463209537723,584.9331019140634,1001.8797917868869,1742.9931021238262,3007.5295582033918,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2000,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F119^2)+$D$30,0)","v":275.6842631488293},423.81992763477854,715.94527596938883,1260.5287076400152,2228.5134395086707,3880.1528923472852,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2250,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F120^2)+$D$30,0)","v":307.2203955477371},494.70459591276654,864.42573989875768,1553.6641456068944,2778.7698218781616,4869.1260043770335,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2500,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F121^2)+$D$30,0)","v":342.46666117004577},573.92863692934134,1030.37449370217,1881.2861056875238,3393.762249232298,5974.4488942926337,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2750,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F122^2)+$D$30,0)","v":381.42306001575537},661.49205068450328,1213.7915373796263,2243.3945878819031,4073.4907215710791,7196.1215620940829,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3000,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F123^2)+$D$30,0)","v":424.0895920848659},757.39483717825181,1414.6768709311257,2639.9895921900352,4817.9552388945094,8534.1440077813913,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3250,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F124^2)+$D$30,0)","v":470.46625737737736},861.63699641058702,1633.0304943566675,3071.0711186119142,5627.1558012025853,9988.5162313545497,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3500,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F125^2)+$D$30,0)","v":520.55305589328964},974.21852838150892,1868.8524076562535,3536.6391671475476,6501.0924084953049,11559.238232813566,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3750,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F126^2)+$D$30,0)","v":574.34998763260307},1095.1394330910182,2122.1426108298833,4036.6937377969289,7439.7650607726719,13246.310012158423,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4000,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F127^2)+$D$30,0)","v":631.85705259531721},1224.399710539114,2392.9011038775552,4571.2348305600608,8443.1737580346817,15049.73156938914,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4700,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F128^2)+$D$30,0)","v":812.61474323940956},1630.6939503630647,3243.9561865409523,6251.4181879419857,11597.113869686635,20718.292747987889,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4701,{"$f":"IF($D$6-F$66>=0,(0.5*$D$22*$D$21*$D$20*F129^2)+$D$30,0)","v":812.89377493887537},1631.3211379079878,3245.2699416857963,6254.0118502971172,11601.982538157838,20727.043182083125,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"RPM","C. final 1","C. final 2","C. final 3","C. final 4","C. final 5","C. final 6","C. final 7","C. final 8","C. final 9","C. final 10","C. final 11","C. final 12","C. final 13","C. final 14","C. final 15","C. final 16","C. final 17","C. final 18","C. final 19","C. final 20"]
[null,null,null,null,{"$f":"H17","v":750},{"$f":"$G17*$D$10*$D$9*$O$42/$H$8","v":3552.8790164370075},{"$f":"$G17*$D$10*$D$9*$O$43/$H$8","v":2369.7824479282599},{"$f":"$G17*$D$10*$D$9*$O$44/$H$8","v":1637.3818658800869},{"$f":"$G17*$D$10*$D$9*$O$45/$H$8","v":1165.3341452058694},{"$f":"$G17*$D$10*$D$9*$O$46/$H$8","v":850.5543888224978},{"$f":"$G17*$D$10*$D$9*$O$47/$H$8","v":634.44268150660844},{"$f":"$G17*$D$10*$D$9*$O$48/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$49/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$50/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$51/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$52/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$53/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$54/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$55/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$56/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$57/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$58/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$59/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$60/$H$8","v":0},{"$f":"$G17*$D$10*$D$9*$O$61/$H$8","v":0}]
[null,null,"Calcul de la traction en Newtons",null,1000,4767.1541233205417,3179.7080946885512,2196.9933896618891,1563.6129036939512,1141.2501925972756,851.27752202152533,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"En fonction de la vitesse de rotation moteur",null,1250,6071.3755344176716,4049.6282338014571,2798.0576189090098,1991.3937924404097,1453.4790188738887,1084.1742025745841,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Pour chaque rapport",null,1500,7285.6506413012057,4859.5538805617489,3357.6691426908114,2389.6725509284915,1744.1748226486663,1301.0090430895009,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1750,8544.8989002915387,5699.476773498347,3938.0070192052735,2802.7023745457623,2045.6371376743621,1525.8748036234888,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2000,9894.0934634954647,6599.3941587875597,4559.7976011850533,3245.2343284214085,2368.6324752018927,1766.8024041956187,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2250,11243.288026699391,7499.3115440767715,5181.5881831648321,3687.7662822970551,2691.6278127294236,2007.7300047677484,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2500,12142.751068835343,8099.2564676029142,5596.1152378180195,3982.7875848808194,2906.9580377477773,2168.3484051491682,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2750,12592.482589903319,8399.2289293659851,5803.3787651446128,4130.2982361727018,3014.6231502569544,2248.6576053398785,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3000,12367.61682936933,8249.2426984844496,5699.7470014813152,4056.5429105267604,2960.7905940023661,2208.5030052445231,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3250,11693.019547767368,7799.2840058398433,5388.8517104914263,3835.2769335889375,2799.2929252386007,2088.0392049584584,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3500,11018.422266165404,7349.325313195236,5077.9564195015364,3614.0109566511142,2637.7952564748348,1967.5754046723935,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3750,9984.0397677090605,6659.3886511401734,4601.2503066503714,3274.7364586797848,2390.1654977037279,1782.8642442337607,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4000,8904.6841171459182,5939.4547429088034,4103.8178410665478,2920.7108955792673,2131.7692276817038,1590.1221637760568,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4700,6296.2412949516593,4199.6144646829925,2901.6893825723064,2065.1491180863509,1507.3115751284772,1124.3288026699393,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4701,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"RPM",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,{"$f":"H17","v":750},{"$f":"IF($D$6-F113>=0,$E114/($D$10*$O$42*$D$9)*$H$11*$H$7*60/1000,0)","v":6.2869362181163524},{"$f":"IF($D$6-G113>=0,$E114/($D$10*$O$43*$D$9)*$H$11*$H$7*60/1000,0)","v":9.4256431794196605},{"$f":"IF($D$6-H113>=0,$E114/($D$10*$O$44*$D$9)*$H$11*$H$7*60/1000,0)","v":13.641731493720629},{"$f":"IF($D$6-$I$113>=0,$E114/($D$10*$O$45*$D$9)*$H$11*$H$7*60/1000,0)","v":19.167655782605937},{"$f":"IF($D$6-$J$113>=0,$E114/($D$10*$O$46*$D$9)*$H$11*$H$7*60/1000,0)","v":26.261370302193431},{"$f":"IF($D$6-$K$113>=0,$E114/($D$10*$O$47*$D$9)*$H$11*$H$7*60/1000,0)","v":35.206842821451573},{"$f":"IF($D$6-$L$113>=0,$E114/($D$10*$O$48*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$M$113>=0,$E114/($D$10*$O$49*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$N$113>=0,$E114/($D$10*$O$50*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$O$113>=0,$E114/($D$10*$O$51*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$P$113>=0,$E114/($D$10*$O$52*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$Q$113>=0,$E114/($D$10*$O$53*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$R$113>=0,$E114/($D$10*$O$54*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$S$113>=0,$E114/($D$10*$O$55*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$T$113>=0,$E114/($D$10*$O$56*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$U$113>=0,$E114/($D$10*$O$57*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$V$113>=0,$E114/($D$10*$O$58*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$W$113>=0,$E114/($D$10*$O$59*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$X$113>=0,$E114/($D$10*$O$60*$D$9)*$H$11*$H$7*60/1000,0)","v":0},{"$f":"IF($D$6-$Y$113>=0,$E114/($D$10*$O$61*$D$9)*$H$11*$H$7*60/1000,0)","v":0}]
[null,null,null,null,1000,{"$f":"$E115/($D$10*$O$42*$D$9)*$H$11*$H$7*60/1000","v":8.3825816241551383},{"$f":"$E115/($D$10*$O$43*$D$9)*$H$11*$H$7*60/1000","v":12.567524239226213},{"$f":"$E115/($D$10*$O$44*$D$9)*$H$11*$H$7*60/1000","v":18.188975324960833},25.556874376807912,35.015160402924572,46.942457095268765,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1250,10.478227030193922,15.709405299032765,22.736219156201042,31.94609297100989,43.768950503655716,58.678071369085956,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1500,12.573872436232705,18.851286358839321,27.283462987441258,38.335311565211875,52.522740604386861,70.413685642903147,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1750,14.669517842271491,21.993167418645868,31.83070681868146,44.724530159413852,61.276530705118006,82.149299916720352,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Calcul des vitesses en km/h",null,2000,16.765163248310277,25.135048478452426,36.377950649921665,51.113748753615823,70.030320805849144,93.884914190537529,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"En fonction de la vitesse de rotation moteur",null,2250,18.860808654349061,28.27692953825898,40.925194481161874,57.502967347817801,78.784110906580295,105.62052846435472,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Pour chaque rapport",null,2500,20.956454060387845,31.41881059806553,45.472438312402083,63.892185942019779,87.537901007311433,117.35614273817191,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,2750,23.052099466426629,34.560691657872091,50.019682143642306,70.281404536221743,96.291691108042556,129.09175701198907,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3000,25.14774487246541,37.702572717678642,54.566925974882516,76.670623130423749,105.04548120877372,140.82737128580629,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3250,27.243390278504197,40.844453777485192,59.11416980612271,83.059841724625699,113.79927130950487,152.56298555962348,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3500,29.339035684542981,43.986334837291736,63.661413637362919,89.449060318827705,122.55306141023601,164.2985998334407,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,3750,31.434681090581769,47.128215897098301,68.208657468603135,95.838278913029669,131.30685151096716,176.03421410725787,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4000,33.530326496620553,50.270096956904851,72.75590129984333,102.22749750723165,140.06064161169829,187.76982838107506,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4700,39.398133633529142,59.067363924363207,85.488184027315953,120.11730957099719,164.57125389374551,220.62954834776323,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4701,39.406516215153303,59.079931448602423,85.506373002640871,120.14286644537401,164.60626905414841,220.67649080485847,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,"Ligne 1",null,null,"Ligne 2",null,null,"Ligne 3",null,null,"Ligne 4",null,null,"Ligne 5",null,null,"Ligne 6",null,null,"Ligne 7",null,null,"Ligne 8",null,null,"Ligne 9",null,null,"Ligne 10",null,null,"Ligne 11",null,null,"Ligne 12",null,null,"Ligne 13",null,null,"Ligne 14",null,null,"Ligne 15",null,null,"Ligne 16",null,null,"Ligne 17",null,null,"Ligne 18",null,null,"Ligne 19",null,null,"Ligne 20"]
[null,null,null,{"$f":"F114","v":6.2869362181163524},{"$f":"F96","v":3552.8790164370075},null,{"$f":"G114","v":9.4256431794196605},{"$f":"G96","v":2369.7824479282599},null,{"$f":"H114","v":13.641731493720629},{"$f":"H96","v":1637.3818658800869},null,{"$f":"I114","v":19.167655782605937},{"$f":"I96","v":1165.3341452058694},null,{"$f":"J114","v":26.261370302193431},{"$f":"J96","v":850.5543888224978},null,{"$f":"K114","v":35.206842821451573},{"$f":"K96","v":634.44268150660844},null,{"$f":"L114","v":0},{"$f":"L96","v":0},null,{"$f":"M114","v":0},{"$f":"M96","v":0},null,{"$f":"N114","v":0},{"$f":"N96","v":0},null,{"$f":"O114","v":0},{"$f":"O96","v":0},null,{"$f":"P114","v":0},{"$f":"P96","v":0},null,{"$f":"Q114","v":0},{"$f":"Q96","v":0},null,{"$f":"R114","v":0},{"$f":"R96","v":0},null,{"$f":"S114","v":0},{"$f":"S96","v":0},null,{"$f":"T114","v":0},{"$f":"T96","v":0},null,{"$f":"U114","v":0},{"$f":"U96","v":0},null,{"$f":"V114","v":0},{"$f":"V96","v":0},null,{"$f":"W114","v":0},{"$f":"W96","v":0},null,{"$f":"X114","v":0},{"$f":"X96","v":0},null,{"$f":"Y114","v":0},{"$f":"Y96","v":0}]
[null,null,null,8.3825816241551383,4767.1541233205417,null,12.567524239226213,3179.7080946885512,null,18.188975324960833,2196.9933896618891,null,25.556874376807912,1563.6129036939512,null,35.015160402924572,1141.2501925972756,null,46.942457095268765,851.27752202152533,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,10.478227030193922,6071.3755344176716,null,15.709405299032765,4049.6282338014571,null,22.736219156201042,2798.0576189090098,null,31.94609297100989,1991.3937924404097,null,43.768950503655716,1453.4790188738887,null,58.678071369085956,1084.1742025745841,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,12.573872436232705,7285.6506413012057,null,18.851286358839321,4859.5538805617489,null,27.283462987441258,3357.6691426908114,null,38.335311565211875,2389.6725509284915,null,52.522740604386861,1744.1748226486663,null,70.413685642903147,1301.0090430895009,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,"Transposition des données",14.669517842271491,8544.8989002915387,null,21.993167418645868,5699.476773498347,null,31.83070681868146,3938.0070192052735,null,44.724530159413852,2802.7023745457623,null,61.276530705118006,2045.6371376743621,null,82.149299916720352,1525.8748036234888,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,"Traction en Newtons en\n fonction de la vitesse en km/h",16.765163248310277,9894.0934634954647,null,25.135048478452426,6599.3941587875597,null,36.377950649921665,4559.7976011850533,null,51.113748753615823,3245.2343284214085,null,70.030320805849144,2368.6324752018927,null,93.884914190537529,1766.8024041956187,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,18.860808654349061,11243.288026699391,null,28.27692953825898,7499.3115440767715,null,40.925194481161874,5181.5881831648321,null,57.502967347817801,3687.7662822970551,null,78.784110906580295,2691.6278127294236,null,105.62052846435472,2007.7300047677484,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,20.956454060387845,12142.751068835343,null,31.41881059806553,8099.2564676029142,null,45.472438312402083,5596.1152378180195,null,63.892185942019779,3982.7875848808194,null,87.537901007311433,2906.9580377477773,null,117.35614273817191,2168.3484051491682,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,23.052099466426629,12592.482589903319,null,34.560691657872091,8399.2289293659851,null,50.019682143642306,5803.3787651446128,null,70.281404536221743,4130.2982361727018,null,96.291691108042556,3014.6231502569544,null,129.09175701198907,2248.6576053398785,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,25.14774487246541,12367.61682936933,null,37.702572717678642,8249.2426984844496,null,54.566925974882516,5699.7470014813152,null,76.670623130423749,4056.5429105267604,null,105.04548120877372,2960.7905940023661,null,140.82737128580629,2208.5030052445231,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,27.243390278504197,11693.019547767368,null,40.844453777485192,7799.2840058398433,null,59.11416980612271,5388.8517104914263,null,83.059841724625699,3835.2769335889375,null,113.79927130950487,2799.2929252386007,null,152.56298555962348,2088.0392049584584,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,29.339035684542981,11018.422266165404,null,43.986334837291736,7349.325313195236,null,63.661413637362919,5077.9564195015364,null,89.449060318827705,3614.0109566511142,null,122.55306141023601,2637.7952564748348,null,164.2985998334407,1967.5754046723935,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,31.434681090581769,9984.0397677090605,null,47.128215897098301,6659.3886511401734,null,68.208657468603135,4601.2503066503714,null,95.838278913029669,3274.7364586797848,null,131.30685151096716,2390.1654977037279,null,176.03421410725787,1782.8642442337607,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,33.530326496620553,8904.6841171459182,null,50.270096956904851,5939.4547429088034,null,72.75590129984333,4103.8178410665478,null,102.22749750723165,2920.7108955792673,null,140.06064161169829,2131.7692276817038,null,187.76982838107506,1590.1221637760568,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,39.398133633529142,6296.2412949516593,null,59.067363924363207,4199.6144646829925,null,85.488184027315953,2901.6893825723064,null,120.11730957099719,2065.1491180863509,null,164.57125389374551,1507.3115751284772,null,220.62954834776323,1124.3288026699393,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,39.406516215153303,0,null,59.079931448602423,0,null,85.506373002640871,0,null,120.14286644537401,0,null,164.60626905414841,0,null,220.67649080485847,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[]
[]
[null,null,null,null,"Intersections 1 - 2",null,null,"Intersections 2-3",null,null,"Intersections 3-4",null,null,"Intersections 4-5",null,null,"Intersections 5-6",null,null,"Intersections 6-7",null,null,"Intersections 7-8",null,null,"Intersections 8-9",null,null,"Intersections 9-10",null,null,"Intersections 10-11",null,null,"Intersections 11-12",null,null,"Intersections 12-13",null,null,"Intersections 13-14",null,null,"Intersections 14-15",null,null,"Intersections 15-16",null,null,"Intersections 16-17",null,null,"Intersections 17-18",null,null,"Intersections 18-19",null,null,"Intersections 19-20"]
[null,null,null,null,{"$f":"Intersectcomplex(D135,E135,D136,E136,LIGNE2,TRUE)","v":{"$error":"#N/A"}},{"$f":"Intersectcomplex(D135,E135,D136,E136,LIGNE2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Intersectcomplex(G135,H135,G136,H136,LIGNE3,TRUE)","v":{"$error":"#N/A"}},{"$f":"Intersectcomplex(G135,H135,G136,H136,LIGNE3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Intersectcomplex(J135,K135,J136,K136,LIGNE4,TRUE)","v":{"$error":"#N/A"}},{"$f":"Intersectcomplex(J135,K135,J136,K136,LIGNE4,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Intersectcomplex(M135,N135,M136,N136,LIGNE5,TRUE)","v":{"$error":"#N/A"}},{"$f":"Intersectcomplex(M135,N135,M136,N136,LIGNE5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Intersectcomplex(P135,Q135,P136,Q136,LIGNE6,TRUE)","v":{"$error":"#N/A"}},{"$f":"Intersectcomplex(P135,Q135,P136,Q136,LIGNE6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Intersectcomplex(S135,T135,S136,T136,LIGNE7,TRUE)","v":{"$error":"#N/A"}},{"$f":"Intersectcomplex(S135,T135,S136,T136,LIGNE7,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Intersectcomplex(V135,W135,V136,W136,LIGNE8,TRUE)","v":0},{"$f":"Intersectcomplex(V135,W135,V136,W136,LIGNE8,FALSE)","v":0},null,{"$f":"Intersectcomplex(Y135,Z135,Y136,Z136,LIGNE9,TRUE)","v":0},{"$f":"Intersectcomplex(Y135,Z135,Y136,Z136,LIGNE9,FALSE)","v":0},null,{"$f":"Intersectcomplex(AB135,AC135,AB136,AC136,LIGNE10,TRUE)","v":0},{"$f":"Intersectcomplex(AB135,AC135,AB136,AC136,LIGNE10,FALSE)","v":0},null,{"$f":"Intersectcomplex(AE135,AF135,AE136,AF136,LIGNE11,TRUE)","v":0},{"$f":"Intersectcomplex(AE135,AF135,AE136,AF136,LIGNE11,FALSE)","v":0},null,{"$f":"Intersectcomplex(AH135,AI135,AH136,AI136,LIGNE12,TRUE)","v":0},{"$f":"Intersectcomplex(AH135,AI135,AH136,AI136,LIGNE12,FALSE)","v":0},null,{"$f":"Intersectcomplex(AK135,AL135,AK136,AL136,LIGNE13,TRUE)","v":0},{"$f":"Intersectcomplex(AK135,AL135,AK136,AL136,LIGNE13,FALSE)","v":0},null,{"$f":"Intersectcomplex(AN135,AO135,AN136,AO136,LIGNE14,TRUE)","v":0},{"$f":"Intersectcomplex(AN135,AO135,AN136,AO136,LIGNE14,FALSE)","v":0},null,{"$f":"Intersectcomplex(AQ135,AR135,AQ136,AR136,LIGNE15,TRUE)","v":0},{"$f":"Intersectcomplex(AQ135,AR135,AQ136,AR136,LIGNE15,FALSE)","v":0},null,{"$f":"Intersectcomplex(AT135,AU135,AT136,AU136,LIGNE16,TRUE)","v":0},{"$f":"Intersectcomplex(AT135,AU135,AT136,AU136,LIGNE16,FALSE)","v":0},null,{"$f":"Intersectcomplex(AW135,AX135,AW136,AX136,LIGNE17,TRUE)","v":0},{"$f":"Intersectcomplex(AW135,AX135,AW136,AX136,LIGNE17,FALSE)","v":0},null,{"$f":"Intersectcomplex(AZ135,BA135,AZ136,BA136,LIGNE18,TRUE)","v":0},{"$f":"Intersectcomplex(AZ135,BA135,AZ136,BA136,LIGNE18,FALSE)","v":0},null,{"$f":"Intersectcomplex(BC135,BD135,BC136,BD136,LIGNE19,TRUE)","v":0},{"$f":"Intersectcomplex(BC135,BD135,BC136,BD136,LIGNE19,FALSE)","v":0},null,{"$f":"Intersectcomplex(BF135,BG135,BF136,BG136,LIGNE20,TRUE)","v":0},{"$f":"Intersectcomplex(BF135,BG135,BF136,BG136,LIGNE20,FALSE)","v":0}]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,101.06206901498749,2985.287098777972,null,137.01974059970061,2221.5312016340799,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,34.68020448272582,8393.523659879138,null,51.080375320536049,5779.2055497406027,null,72.781054443811385,4101.4429872534638,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,"km/h","RPM","Vitesse","Changement","km/h","RPM",null,"Milieux",null,null,"Etiquettes"]
[null,null,null,null,null,null,null,null,null,0,0,1,0,{"$f":"OFFSET(J174,0,0,D6*2)","v":0},{"$f":"OFFSET(K174,0,0,D6*2)","v":0}]
[null,null,null,null,null,null,"Vitesse en km/h intersection 1-2",null,null,{"$f":"IF($D$6-1-L175+1-M175>=0,INDEX($E$155:$E$170, MATCH(TRUE, $E$155:$E$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":34.68020448272582},{"$f":"(1000*J175/60)*($D$10*$O42*$D$9)/($H$11*$H$7)","v":4137.1746840844098},1,1,34.68020448272582,4137.1746840844098,null,{"$f":"(N175-N174)/2+N174","v":17.34010224136291},{"$f":"(O175-O174)/2+O174","v":2068.5873420422049},null,"1st"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L176+1-M176>=0,INDEX($E$155:$E$170, MATCH(TRUE, $E$155:$E$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":34.68020448272582},{"$f":"(1000*J175/60)*($D$10*$O43*$D$9)/($H$11*$H$7)","v":2759.5096554085571},2,0,34.68020448272582,2759.5096554085571]
[null,null,null,null,null,null,"Vitesse en km/h intersection 2-3",null,null,{"$f":"IF($D$6-1-L177+1-M177>=0,INDEX($H$155:$H$170, MATCH(TRUE, $H$155:$H$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":51.080375320536049},{"$f":"(1000*J177/60)*($D$10*$O43*$D$9)/($H$11*$H$7)","v":4064.4739845499657},2,1,51.080375320536049,4064.4739845499657,null,{"$f":"(N177-N176)/2+N176","v":42.880289901630931},{"$f":"(O177-O176)/2+O176","v":3411.9918199792614},null,"2nd"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L178+1-M178>=0,INDEX($H$155:$H$170, MATCH(TRUE, $H$155:$H$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":51.080375320536049},{"$f":"(1000*J177/60)*($D$10*$O44*$D$9)/($H$11*$H$7)","v":2808.3151693783516},3,0,51.080375320536049,2808.3151693783516]
[null,null,null,null,null,null,"Vitesse en km/h intersection 3-4",null,null,{"$f":"IF($D$6-1-L179+1-M179>=0,INDEX($K$155:$K$170, MATCH(TRUE, $K$155:$K$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":72.781054443811385},{"$f":"(1000*J179/60)*($D$10*$O44*$D$9)/($H$11*$H$7)","v":4001.3828785579544},3,1,72.781054443811385,4001.3828785579544,null,{"$f":"(N179-N178)/2+N178","v":61.930714882173717},{"$f":"(O179-O178)/2+O178","v":3404.8490239681532},null,"3rd"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L180+1-M180>=0,INDEX($K$155:$K$170, MATCH(TRUE, $K$155:$K$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":72.781054443811385},{"$f":"(1000*J179/60)*($D$10*$O45*$D$9)/($H$11*$H$7)","v":2847.8073402378964},4,0,72.781054443811385,2847.8073402378964]
[null,null,null,null,null,null,"Vitesse en km/h intersection 4-5",null,null,{"$f":"IF($D$6-1-L181+1-M181>=0,INDEX($N$155:$N$170, MATCH(TRUE, $N$155:$N$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":101.06206901498749},{"$f":"(1000*J181/60)*($D$10*$O45*$D$9)/($H$11*$H$7)","v":3954.3986296969965},4,1,101.06206901498749,3954.3986296969965,null,{"$f":"(N181-N180)/2+N180","v":86.921561729399428},{"$f":"(O181-O180)/2+O180","v":3401.1029849674464},null,"4th"]
[null,null,"Calcul des vitesses de rotation moteur aux passages des rapports",null,null,null,null,null,null,{"$f":"IF($D$6-1-L182+1-M182>=0,INDEX($N$155:$N$170, MATCH(TRUE, $N$155:$N$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":101.06206901498749},{"$f":"(1000*J181/60)*($D$10*$O46*$D$9)/($H$11*$H$7)","v":2886.2374997587181},5,0,101.06206901498749,2886.2374997587181]
[null,null,null,null,null,null,"Vitesse en km/h intersection 5-6",null,null,{"$f":"IF($D$6-1-L183+1-M183>=0,INDEX($Q$155:$Q$170, MATCH(TRUE, $Q$155:$Q$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":137.01974059970061},{"$f":"(1000*J183/60)*($D$10*$O46*$D$9)/($H$11*$H$7)","v":3913.1547313504898},5,1,137.01974059970061,3913.1547313504898,null,{"$f":"(N183-N182)/2+N182","v":119.04090480734405},{"$f":"(O183-O182)/2+O182","v":3399.6961155546041},null,"5th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L184+1-M184>=0,INDEX($Q$155:$Q$170, MATCH(TRUE, $Q$155:$Q$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":137.01974059970061},{"$f":"(1000*J183/60)*($D$10*$O47*$D$9)/($H$11*$H$7)","v":2918.8872734467609},6,0,137.01974059970061,2918.8872734467609]
[null,null,null,null,null,null,"Vitesse en km/h intersection 6-7",null,null,{"$f":"IF($D$6-1-L185+1-M185>=0,INDEX($T$155:$T$170, MATCH(TRUE, $T$155:$T$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J185/60)*($D$10*$O47*$D$9)/($H$11*$H$7)","v":4700},6,1,220.62954834776323,4700,null,{"$f":"(N185-N184)/2+N184","v":178.82464447373192},{"$f":"(O185-O184)/2+O184","v":3809.4436367233802},null,"6th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L186+1-M186>=0,INDEX($T$155:$T$170, MATCH(TRUE, $T$155:$T$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J185/60)*($D$10*$O48*$D$9)/($H$11*$H$7)","v":0},7,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 7-8",null,null,{"$f":"IF($D$6-1-L187+1-M187>=0,INDEX($W$155:$W$170, MATCH(TRUE, $W$155:$W$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J187/60)*($D$10*$O48*$D$9)/($H$11*$H$7)","v":0},7,1,null,null,null,{"$f":"(N187-N186)/2+N186","v":0},{"$f":"(O187-O186)/2+O186","v":0},null,"7th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L188+1-M188>=0,INDEX($W$155:$W$170, MATCH(TRUE, $W$155:$W$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J187/60)*($D$10*$O49*$D$9)/($H$11*$H$7)","v":0},8,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 8-9",null,null,{"$f":"IF($D$6-1-L189+1-M189>=0,INDEX($Z$155:$Z$170, MATCH(TRUE, $Z$155:$Z$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J189/60)*($D$10*$O49*$D$9)/($H$11*$H$7)","v":0},8,1,null,null,null,0,0,null,"8th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L190+1-M190>=0,INDEX($Z$155:$Z$170, MATCH(TRUE, $Z$155:$Z$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J189/60)*($D$10*$O50*$D$9)/($H$11*$H$7)","v":0},9,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 9-10",null,null,{"$f":"IF($D$6-1-L191+1-M191>=0,INDEX($AC$155:$AC$170, MATCH(TRUE, $AC$155:$AC$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J191/60)*($D$10*$O50*$D$9)/($H$11*$H$7)","v":0},9,1,null,null,null,0,0,null,"9th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L192+1-M192>=0,INDEX($AC$155:$AC$170, MATCH(TRUE, $AC$155:$AC$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J191/60)*($D$10*$O51*$D$9)/($H$11*$H$7)","v":0},10,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 10-11",null,null,{"$f":"IF($D$6-1-L193+1-M193>=0,INDEX($AF$155:$AF$170, MATCH(TRUE, $AF$155:$AF$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J193/60)*($D$10*$O51*$D$9)/($H$11*$H$7)","v":0},10,1,null,null,null,0,0,null,"10th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L194+1-M194>=0,INDEX($AF$155:$AF$170, MATCH(TRUE, $AF$155:$AF$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J193/60)*($D$10*$O52*$D$9)/($H$11*$H$7)","v":0},11,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 11-12",null,null,{"$f":"IF($D$6-1-L195+1-M195>=0,INDEX($AI$155:$AI$170, MATCH(TRUE, $AI$155:$AI$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J195/60)*($D$10*$O52*$D$9)/($H$11*$H$7)","v":0},11,1,null,null,null,0,0,null,"11th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L196+1-M196>=0,INDEX($AI$155:$AI$170, MATCH(TRUE, $AI$155:$AI$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J195/60)*($D$10*$O53*$D$9)/($H$11*$H$7)","v":0},12,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 12-13",null,null,{"$f":"IF($D$6-1-L197+1-M197>=0,INDEX($AL$155:$AL$170, MATCH(TRUE, $AL$155:$AL$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J197/60)*($D$10*$O53*$D$9)/($H$11*$H$7)","v":0},12,1,null,null,null,0,0,null,"12th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L198+1-M198>=0,INDEX($AL$155:$AL$170, MATCH(TRUE, $AL$155:$AL$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J197/60)*($D$10*$O54*$D$9)/($H$11*$H$7)","v":0},13,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 13-14",null,null,{"$f":"IF($D$6-1-L199+1-M199>=0,INDEX($AO$155:$AO$170, MATCH(TRUE, $AO$155:$AO$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J199/60)*($D$10*$O54*$D$9)/($H$11*$H$7)","v":0},13,1,null,null,null,0,0,null,"13th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L200+1-M200>=0,INDEX($AO$155:$AO$170, MATCH(TRUE, $AO$155:$AO$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J199/60)*($D$10*$O55*$D$9)/($H$11*$H$7)","v":0},14,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 14-15",null,null,{"$f":"IF($D$6-1-L201+1-M201>=0,INDEX($AR$155:$AR$170, MATCH(TRUE, $AR$155:$AR$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J201/60)*($D$10*$O55*$D$9)/($H$11*$H$7)","v":0},14,1,null,null,null,0,0,null,"14th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L202+1-M202>=0,INDEX($AR$155:$AR$170, MATCH(TRUE, $AR$155:$AR$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J201/60)*($D$10*$O56*$D$9)/($H$11*$H$7)","v":0},15,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 15-16",null,null,{"$f":"IF($D$6-1-L203+1-M203>=0,INDEX($AU$155:$AU$170, MATCH(TRUE, $AU$155:$AU$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J203/60)*($D$10*$O56*$D$9)/($H$11*$H$7)","v":0},15,1,null,null,null,0,0,null,"15th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L204+1-M204>=0,INDEX($AU$155:$AU$170, MATCH(TRUE, $AU$155:$AU$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J203/60)*($D$10*$O57*$D$9)/($H$11*$H$7)","v":0},16,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 16-17",null,null,{"$f":"IF($D$6-1-L205+1-M205>=0,INDEX($AX$155:$AX$170, MATCH(TRUE, $AX$155:$AX$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J205/60)*($D$10*$O57*$D$9)/($H$11*$H$7)","v":0},16,1,null,null,null,0,0,null,"16th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L206+1-M206>=0,INDEX($AX$155:$AX$170, MATCH(TRUE, $AX$155:$AX$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J205/60)*($D$10*$O58*$D$9)/($H$11*$H$7)","v":0},17,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 17-18",null,null,{"$f":"IF($D$6-1-L207+1-M207>=0,INDEX($BA$155:$BA$170, MATCH(TRUE, $BA$155:$BA$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J207/60)*($D$10*$O58*$D$9)/($H$11*$H$7)","v":0},17,1,null,null,null,0,0,null,"17th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L208+1-M208>=0,INDEX($BA$155:$BA$170, MATCH(TRUE, $BA$155:$BA$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J207/60)*($D$10*$O59*$D$9)/($H$11*$H$7)","v":0},18,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 18-19",null,null,{"$f":"IF($D$6-1-L209+1-M209>=0,INDEX($BD$155:$BD$170, MATCH(TRUE, $BD$155:$BD$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J209/60)*($D$10*$O59*$D$9)/($H$11*$H$7)","v":0},18,1,null,null,null,0,0,null,"18th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L210+1-M210>=0,INDEX($BD$155:$BD$170, MATCH(TRUE, $BD$155:$BD$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J209/60)*($D$10*$O60*$D$9)/($H$11*$H$7)","v":0},19,0]
[null,null,null,null,null,null,"Vitesse en km/h intersection 19-20",null,null,{"$f":"IF($D$6-1-L211+1-M211>=0,INDEX($BG$155:$BG$170, MATCH(TRUE, $BG$155:$BG$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J211/60)*($D$10*$O60*$D$9)/($H$11*$H$7)","v":0},19,1,null,null,null,0,0,null,"19th"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L212+1-M212>=0,INDEX($BG$155:$BG$170, MATCH(TRUE, $BG$155:$BG$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"(1000*J211/60)*($D$10*$O61*$D$9)/($H$11*$H$7)","v":0},20,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($D$6-1-L213+1-M213>=0,INDEX($BG$155:$BG$170, MATCH(TRUE, $BG$155:$BG$170<>\"\", 0)),OFFSET($F$128,0,$D$6-1))","v":220.62954834776323},{"$f":"H31","v":4700},20,1,null,null,null,{"$f":"(N213-N212)/2+N212","v":0},0,null,"20th"]
[]
[null,null,null,"Vitesse en km/h","Frottements en Newtons",null,"Intersection dernier rapport / frottements"]
[null,null,null,null,null,null,null,null,null,"Vitesse Maxi","RPM","Traction"]
[null,null,null,0,{"$f":"(0.5*$D$22*$D$21*$D$20*(D217/3.6)^2)+$D$30","v":156.96},null,{"$f":"Intersectcomplex(OFFSET(D135,0,($D$6-1)*3),OFFSET(E135,0,($D$6-1)*3),OFFSET(D136,0,($D$6-1)*3),OFFSET(E136,0,($D$6-1)*3),frottements,TRUE)","v":{"$error":"#N/A"}},{"$f":"Intersectcomplex(OFFSET(D135,0,($D$6-1)*3),OFFSET(E135,0,($D$6-1)*3),OFFSET(D136,0,($D$6-1)*3),OFFSET(E136,0,($D$6-1)*3),frottements,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"$J$218","v":198.37678630391724},0]
[null,null,null,5,157.77481481481482,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"INDEX(G217:G232,MATCH(TRUE,G217:G232<>\"\",0))","v":198.37678630391724},{"$f":"(1000*J218/60)*($D$10*OFFSET($O$42,$D$6-1,0)*$D$9)/($H$11*$H$7)","v":4225.9565983373122},{"$f":"INDEX(H217:H232,MATCH(TRUE,H217:H232<>\"\",0))","v":1439.7663303422828}]
[null,null,null,10,160.21925925925927,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,15,164.29333333333335,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,20,169.99703703703705,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,25,177.33037037037039,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,30,186.29333333333335,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,35,196.88592592592593,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,40,209.10814814814816,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,45,222.96000000000004,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,50,238.4414814814815,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,55,255.55259259259259,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,60,274.29333333333341,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,65,294.66370370370373,null,198.37678630391724,1439.7663303422828]
[null,null,null,70,316.66370370370373,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,75,340.29333333333335,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,80,365.55259259259265]
[null,null,null,85,392.4414814814815]
[null,null,null,90,420.96000000000004]
[null,null,null,95,451.10814814814819]
[null,null,null,100,482.88592592592602]
[null,null,null,105,516.29333333333329]
[null,null,null,110,551.33037037037036]
[null,null,null,115,587.9970370370371]
[null,null,null,120,626.29333333333352]
[null,null,null,125,666.21925925925927]
[null,null,null,130,707.77481481481482]
[null,null,null,135,750.96000000000015]
[null,null,null,140,795.77481481481482]
[null,null,null,145,842.21925925925939]
[null,null,null,150,890.29333333333341]
[null,null,null,155,939.99703703703722]
[null,null,null,160,991.33037037037047]
[null,null,null,165,1044.2933333333335]
[null,null,null,170,1098.8859259259259]
[null,null,null,175,1155.1081481481481]
[null,null,null,180,1212.9600000000003]
[null,null,null,185,1272.4414814814816]
[null,null,null,190,1333.5525925925926]
[null,null,null,195,1396.2933333333333]
[null,null,null,200,1460.663703703704]
[null,null,null,205,1526.6637037037037]
[null,null,null,210,1594.2933333333333]
[null,null,null,215,1663.5525925925929]
[null,null,null,220,1734.4414814814813]
[null,null,null,225,1806.9600000000003]
[null,null,null,230,1881.1081481481483]
[null,null,null,235,1956.8859259259259]
[null,null,null,240,2034.293333333334]
[null,null,null,245,2113.3303703703705]
[null,null,null,250,2193.997037037037]
[null,null,null,255,2276.2933333333335]
[null,null,null,260,2360.2192592592592]
[null,null,null,265,2445.7748148148153]
[null,null,null,270,2532.9600000000005]
[null,null,null,275,2621.7748148148148]
[null,null,null,280,2712.2192592592592]
[null,null,null,285,2804.293333333334]
[null,null,null,290,2897.9970370370374]
[null,null,null,295,2993.3303703703709]
[null,null,null,300,3090.2933333333335]
[null,null,null,305,3188.8859259259257]
[null,null,null,310,3289.1081481481488]
[null,null,null,315,3390.9600000000005]
[null,null,null,320,{"$f":"(0.5*$D$22*$D$21*$D$20*(D281/3.6)^2)+$D$30","v":3494.4414814814818}]
[null,null,null,325,3599.5525925925926]
[null,null,null,330,3706.2933333333344]
[null,null,null,335,3814.663703703704]
[null,null,null,340,3924.663703703704]
[null,null,null,345,4036.2933333333335]
[null,null,null,350,4149.5525925925922]
[null,null,null,351,4172.4000000000005]
[null,null,null,352,4195.3125925925924]
[null,null,null,353,4218.2903703703714]
[null,null,null,354,4241.333333333333]
[null,null,null,355,4264.4414814814827]
[null,null,null,356,4287.614814814815]
[null,null,null,357,4310.8533333333326]
[null,null,null,358,4334.1570370370373]
[null,null,null,359,4357.5259259259265]
[null,null,null,360,4380.9600000000009]
[null,null,null,361,4404.4592592592599]
[null,null,null,362,4428.0237037037041]
[null,null,null,363,4451.6533333333336]
[null,null,null,364,4475.3481481481485]
[null,null,null,365,4499.1081481481488]
[null,null,null,366,4522.9333333333334]
[null,null,null,367,4546.8237037037043]
[null,null,null,368,4570.7792592592596]
[null,null,null,369,4594.8]
[null,null,null,370,4618.8859259259261]
[null,null,null,371,4643.0370370370374]
[null,null,null,372,4667.253333333334]
[null,null,null,373,4691.5348148148159]
[null,null,null,374,4715.8814814814814]
[null,null,null,375,4740.2933333333331]
[null,null,null,376,4764.770370370371]
[null,null,null,377,4789.3125925925924]
[null,null,null,378,4813.920000000001]
[null,null,null,379,4838.5925925925931]
[null,null,null,380,4863.3303703703705]
[null,null,null,381,4888.1333333333332]
[null,null,null,382,4913.0014814814822]
[null,null,null,383,4937.9348148148156]
[null,null,null,384,4962.9333333333334]
[null,null,null,385,4987.9970370370374]
[null,null,null,386,5013.1259259259259]
[null,null,null,387,5038.3200000000006]
[null,null,null,388,5063.5792592592597]
[null,null,null,389,5088.9037037037051]
[null,null,null,390,5114.2933333333331]
[null,null,null,391,5139.7481481481491]
[null,null,null,392,5165.2681481481486]
[null,null,null,393,5190.8533333333335]
[null,null,null,394,5216.5037037037046]
[null,null,null,395,5242.2192592592592]
[null,null,null,396,5268.0000000000009]
[null,null,null,397,5293.8459259259262]
[null,null,null,398,5319.7570370370377]
[null,null,null,399,5345.7333333333336]
[null,null,null,400,5371.7748148148157]
[null,null,null,401,5397.8814814814823]
[null,null,null,402,5424.0533333333333]
[null,null,null,403,5450.2903703703714]
[null,null,null,404,5476.5925925925922]
[null,null,null,405,5502.9600000000009]
[null,null,null,406,5529.3925925925923]
[null,null,null,407,5555.8903703703709]
[null,null,null,408,{"$f":"(0.5*$D$22*$D$21*$D$20*(D345/3.6)^2)+$D$30","v":5582.4533333333338}]
[null,null,null,409,5609.081481481483]
[null,null,null,410,5635.7748148148148]
[null,null,null,411,5662.5333333333328]
[null,null,null,412,5689.3570370370371]
[null,null,null,413,5716.2459259259258]
[null,null,null,414,5743.2000000000007]
[null,null,null,415,5770.2192592592592]
[null,null,null,416,5797.3037037037047]
[null,null,null,417,5824.4533333333338]
[null,null,null,418,5851.6681481481492]
[null,null,null,419,5878.9481481481489]
[null,null,null,420,5906.2933333333331]
[null,null,null,421,5933.7037037037044]
[null,null,null,422,5961.1792592592592]
[null,null,null,423,5988.7200000000012]
[null,null,null,424,6016.3259259259257]
[null,null,null,425,6043.9970370370374]
[null,null,null,426,6071.7333333333336]
[null,null,null,427,6099.5348148148159]
[null,null,null,428,6127.4014814814818]
[null,null,null,429,6155.333333333333]
[null,null,null,430,6183.3303703703714]
[null,null,null,431,6211.3925925925932]
[null,null,null,432,6239.52]
[null,null,null,433,6267.712592592592]
[null,null,null,434,6295.9703703703717]
[null,null,null,435,6324.293333333334]
[null,null,null,436,6352.6814814814825]
[null,null,null,437,6381.1348148148154]
[null,null,null,438,6409.6533333333336]
[null,null,null,439,6438.2370370370381]
[null,null,null,440,6466.8859259259252]
[null,null,null,441,6495.6000000000013]
[null,null,null,442,6524.3792592592599]
[null,null,null,443,6553.2237037037048]
[null,null,null,444,6582.1333333333332]
[null,null,null,445,6611.1081481481488]
[null,null,null,446,6640.1481481481487]
[null,null,null,447,6669.2533333333331]
[null,null,null,448,6698.4237037037037]
[null,null,null,449,6727.6592592592588]
[null,null,null,450,6756.9600000000009]
[null,null,null,451,6786.3259259259266]
[null,null,null,452,6815.7570370370377]
[null,null,null,453,6845.253333333334]
[null,null,null,454,6874.8148148148157]
[null,null,null,455,6904.4414814814818]
[null,null,null,456,6934.1333333333332]
[null,null,null,457,6963.8903703703709]
[null,null,null,458,6993.712592592593]
[null,null,null,459,7023.6000000000013]
[null,null,null,460,7053.5525925925931]
[null,null,null,461,7083.5703703703703]
[null,null,null,462,7113.6533333333346]
[null,null,null,463,7143.8014814814824]
[null,null,null,464,7174.0148148148155]
[null,null,null,465,7204.2933333333322]
[null,null,null,466,7234.637037037036]
[null,null,null,467,7265.0459259259287]
[null,null,null,468,7295.5200000000013]
[null,null,null,469,7326.0592592592593]
[null,null,null,470,7356.6637037037035]
[null,null,null,471,7387.3333333333348]
[null,null,null,472,{"$f":"(0.5*$D$22*$D$21*$D$20*(D409/3.6)^2)+$D$30","v":7418.0681481481488}]
[null,null,null,473,7448.868148148149]
[null,null,null,474,7479.7333333333336]
[null,null,null,475,7510.6637037037035]
[null,null,null,476,7541.6592592592606]
[null,null,null,477,7572.7200000000012]
[null,null,null,478,7603.8459259259262]
[null,null,null,479,7635.0370370370365]
[null,null,null,480,7666.2933333333358]
[null,null,null,481,7697.6148148148168]
[null,null,null,482,7729.0014814814813]
[null,null,null,483,7760.4533333333329]
[null,null,null,484,7791.9703703703699]
[null,null,null,485,7823.552592592594]
[null,null,null,486,7855.2000000000007]
[null,null,null,487,7886.9125925925937]
[null,null,null,488,7918.6903703703701]
[null,null,null,489,7950.5333333333347]
[null,null,null,490,7982.4414814814827]
[null,null,null,491,8014.4148148148151]
[null,null,null,492,8046.4533333333329]
[null,null,null,493,8078.5570370370369]
[null,null,null,494,8110.7259259259281]
[null,null,null,495,8142.9600000000009]
[null,null,null,496,8175.2592592592591]
[null,null,null,497,8207.6237037037026]
[null,null,null,498,8240.0533333333351]
[null,null,null,499,8272.5481481481493]
[null,null,null,500,8305.1081481481488]

{"sheet":"Autres Graphes","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calculs de Vitesses","index":2,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[10,9,11,9],[26,9,27,9]]}
[]
[null,"Vitesse mini rotation moteur tr/min",500]
[null,"Vitesse maxi rotation moteur tr/min",4000]
[null,"Couple moteur",380]
[null,"Nombre de roues",4]
[null,"Rapports de boite de Transfert"]
[null,"Vitesses courtes",2.488]
[null,"Vitesses longues",1]
[null,null,null,null,"Rapports Longs"]
[null,"Rapports de ponts ou réduction finale",3.7269999999999999]
[null,null,null,null,"Rapport sélectionné","Rapports Longs","Vitesse km/h","Vitesse maxi km/h","Couple maxi disponible","Couple par roue,\n répartition uniforme","Vitesse de rotation des roues"]
[null,"Pneus"]
[null,"diamètre (pouces)",16,null,"AR",4.3129999999999997,{"$f":"$C$16*($C$2/$C$10)*$C$20*60/F13/1000","v":4.5009071791854707},{"$f":"$C$16*($C$3/$C$10)*$C$20*60/F13/1000","v":36.007257433483765},{"$f":"$C$4*$C$8*$C$10*F13","v":6108.3293799999992},{"$f":"I13/$C$5","v":1527.0823449999998},{"$f":"$C$2/$C$8/$C$10/F13","v":31.105067880278586}]
[null,"largeur (mm)",275]
[null,"hauteur de flancs (% de largeur)",70,null,1,4.0810000000000004,{"$f":"$C$16*($C$2/$C$10)*$C$20*60/F15/1000","v":4.7567784032901077},{"$f":"$C$16*($C$3/$C$10)*$C$20*60/F15/1000","v":38.054227226320862},{"$f":"$C$4*$C$8*$C$10*F15","v":5779.7570600000008},{"$f":"I15/$C$5","v":1444.9392650000002},{"$f":"$C$2/$C$8/$C$10/F15","v":32.873354022945726}]
[null,"Coefficient d'écrasement",0.97,null,2,2.294,{"$f":"$C$16*($C$2/$C$10)*$C$20*60/F16/1000","v":8.462254866533101},67.698038932264808,{"$f":"$C$4*$C$8*$C$10*F16","v":3248.9004399999999},812.22510999999997,{"$f":"$C$2/$C$8/$C$10/F16","v":58.481324223034669}]
[null,null,null,null,3,1.49,{"$f":"$C$16*($C$2/$C$10)*$C$20*60/F17/1000","v":13.028464875051634},104.22771900041307,{"$f":"$C$4*$C$8*$C$10*F17","v":2110.2273999999998},527.55684999999994,{"$f":"$C$2/$C$8/$C$10/F17","v":90.037689776940624}]
[null,"hauteur de flanc calculée (mm)",{"$f":"C14*C15/100","v":192.5},null,4,1,{"$f":"$C$16*($C$2/$C$10)*$C$20*60/F18/1000","v":19.412412663826935},155.29930131061548,{"$f":"$C$4*$C$8*$C$10*F18","v":1416.26},354.065,{"$f":"$C$2/$C$8/$C$10/F18","v":134.15615776764153}]
[null,"diamètre total calculé (mm)",{"$f":"C13*25.4+2*C18","v":791.4},null,5,0.88100000000000001,{"$f":"$C$16*($C$2/$C$10)*$C$20*60/F19/1000","v":22.034520617283693},176.27616493826955,{"$f":"$C$4*$C$8*$C$10*F19","v":1247.72506},311.931265,{"$f":"$C$2/$C$8/$C$10/F19","v":152.27713708018334}]
[null,"circonférence calculée (m)",{"$f":"PI()*C19/1000","v":2.4862564260509621}]
[]
[null,null,null,null,"Les valeurs de rapports et de couple indiquées ici sont celles du Toyota HDJ80 avec les rapports de ponts version Europe (3.72:1)"]
[null,"Les valeurs en vert sont modifiables"]
[]
[null,null,null,null,"Rapports Courts"]
[]
[null,null,null,null,"Rapport sélectionné","Rapports Courts","Vitesse km/h","Vitesse maxi km/h","Couple maxi disponible*","Couple par roue,\n répartition uniforme","Vitesse de rotation des roues en tr/m","Vitesse de rotation en tr/s"]
[]
[null,null,null,null,"AR",{"$f":"F13*$C$7","v":10.730744},{"$f":"$C$16*($C$2/$C$10)*$C$20*60/$F29/1000","v":1.8090462938848355},{"$f":"$C$16*($C$3/$C$10)*$C$20*60/$F29/1000","v":14.472370351078684},{"$f":"$C$4*$C$8*$C$10*F29","v":15197.523497439999},{"$f":"I29/$C$5","v":3799.3808743599998},{"$f":"$C$2/$C$8/$C$10/F29","v":12.502036929372421},{"$f":"K29/60","v":0.20836728215620701}]
[]
[null,null,null,null,1,{"$f":"F15*$C$7","v":10.153528000000001},{"$f":"$C$16*($C$2/$C$10)*$C$20*60/$F31/1000","v":1.9118884257596898},{"$f":"$C$16*($C$3/$C$10)*$C$20*60/$F31/1000","v":15.295107406077518},{"$f":"$C$4*$C$8*$C$10*F31","v":14380.035565280003},{"$f":"I31/$C$5","v":3595.0088913200007},{"$f":"$C$2/$C$8/$C$10/F31","v":13.212762870958894},{"$f":"K31/60","v":0.22021271451598157}]
[null,null,null,null,2,{"$f":"F16*$C$7","v":5.7074720000000001},3.4012278402464231,27.209822721971385,{"$f":"$C$4*$C$8*$C$10*F32","v":8083.2642947200002},2020.81607368,{"$f":"$C$2/$C$8/$C$10/F32","v":23.505355395110396},0.39175592325183994]
[null,null,null,null,3,{"$f":"F17*$C$7","v":3.7071199999999997},5.236521252030399,41.892170016243192,{"$f":"$C$4*$C$8*$C$10*F33","v":5250.2457711999996},1312.5614427999999,{"$f":"$C$2/$C$8/$C$10/F33","v":36.188782064686748},0.60314636774477914]
[null,null,null,null,4,{"$f":"F18*$C$7","v":2.488},7.8024166655252944,62.419333324202356,{"$f":"$C$4*$C$8*$C$10*F34","v":3523.65488},880.91372000000001,{"$f":"$C$2/$C$8/$C$10/F34","v":53.921285276383252},0.89868808793972088]
[null,null,null,null,5,{"$f":"F19*$C$7","v":2.1919279999999999},8.8563185760786549,70.850548608629239,{"$f":"$C$4*$C$8*$C$10*F35","v":3104.3399492799999},776.08498731999998,{"$f":"$C$2/$C$8/$C$10/F35","v":61.204637090105848},1.0200772848350974]