{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["répartition","W ou WpKg constant","2 profils","temps de montée","puissance 2E %V","vitesse en fonction du CdA"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"répartition","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,8,0,12],[23,10,24,10]]}
["force gravité",{"$f":"M21*SIN(ATAN(J12))*(J10+J3)","v":0},{"$f":"(B1*$K$9)/(1-$M$20)/$B$4","v":0},null,"vitesse (km/h)",{"$f":"3.6*F2","v":31.121153560293649},{"$f":"((M21*COS(ATAN(J12))*(J10+J3)*J23+M21*SIN(ATAN(J12))*(J10+J3)+0.5*J14*J22*(F2+M16)^2)*F2)/(1-M20)-J6+J5-((J8)*F2^3)/((45/3.6)^3)","v":158.96497188278133},null,"paramètres vélo"]
["force roulement",{"$f":"M21*COS(ATAN(J12))*(J10+J3)*J23","v":3.5718354999999997},{"$f":"(B2*$K$9)/(1-$M$20)/$B$4","v":0.19629768771043934},null,"vitesse (m/s)",8.6447648778593464,null,null,null,"Aeroad CF SLX","Ultimate CF SLX","Rose Six"]
["force aéro",{"$f":"0.5*J14*J22*(K9+M16)^2","v":14.624178633741854},{"$f":"(B3*$K$9)/(1-$M$20)/$B$4","v":0.80370231228956057},null,null,null,null,null,"poids vélo et matériel",9.85,9,9.4]
["puissance nécessaire",{"$f":"((B2+B1+B3)*K9)/(1-M20)","v":156.32314547888194},null,null,null,null,null,null,"aero à 45km/h(W)",204,235,225]
[null,null,null,null,null,null,null,null,"pénalité position(W)",0,3,0]
[null,null,null,null,null,null,null,null,"gain aéro à vitesse demandée (W)",{"$f":"((K4-J4)*K9^3)/((45/3.6)^3)","v":9.1851851851851869},0,{"$f":"((K4-L4)*K9^3)/(45/3.6)^3","v":2.9629629629629637}]
[null,null,null,null,null,null,null,null,"taille de cadre","XS","M","M"]
[null,"Aeroad","Ultimate","Rose Six",null,null,null,null,"gain taille cadre aero (W)",10,0,0]
["puissance (W) selon\nparamètres",{"$f":"((M21*COS(ATAN(J12))*(J10+J3)*J23+M21*SIN(ATAN(J12))*(J10+J3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)-J6+J5-((J8)*K9^3)/((45/3.6)^3)","v":144.17499733073379},{"$f":"((M21*COS(ATAN(J12))*(J10+K3)*J23+M21*SIN(ATAN(J12))*(J10+K3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)+K5-((K8)*K9^3)/((45/3.6)^3)-K6","v":158.96510853730118},{"$f":"((M21*COS(ATAN(J12))*(J11+L3)*J23+M21*SIN(ATAN(J12))*(J11+L3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)-L6+L5-((L8)*K9^3)/((45/3.6)^3)","v":157.80405279083303},null,null,null,null,"vitesse (km/h)",30,{"$f":"J9/3.6","v":8.3333333333333339},"CdA exemple"]
["gain vitesse (km/h)",{"$f":"F1-J9","v":1.1211535602936493},null,null,null,null,null,null,"masse cycliste (kg) - CANYON",63,null,"Barres",0.40799999999999997]
["gain temps (min)",{"$f":"((J15/J9)-(J15/F1))*60","v":7.205089992063094},null,null,null,null,null,null,"masse cycliste 2 (kg) - ROSE",74,null,"Cocottes",0.32400000000000001]
[null,null,null,null,null,null,null,null,"pourcentage pente",0,null,"Ceintre",0.307]
[null,null,null,null,null,null,null,null,"altitude (m)",500,null,"Aerobars",0.29139999999999999]
[null,null,null,null,null,null,null,null,"CdA",0.32]
[null,null,null,null,"watt/kg","cycliste 1","cycliste 2",null,"distance segment (km)",100,null,"vitesse vent (km/h)",2]
[null,null,null,null,"Aeroad",{"$f":"(((M21*COS(ATAN(J12))*(J10+J3)*J23+M21*SIN(ATAN(J12))*(J10+J3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)-J6+J5)/J10","v":2.3355231792650279},{"$f":"(((M21*COS(ATAN(J12))*(J11+J3)*J23+M21*SIN(ATAN(J12))*(J11+J3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)-J6+J5)/J11","v":2.0509645883470671},null,null,null,null,"vitesse vent (m/s)",{"$f":"M15/3.6","v":0.55555555555555558}]
[null,null,null,null,"Rose",{"$f":"(((M21*COS(ATAN(J12))*(J10+L3)*J23+M21*SIN(ATAN(J12))*(J10+L3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)-L6+L5)/J10","v":2.4312798975689964},{"$f":"(((M21*COS(ATAN(J12))*(J11+L3)*J23+M21*SIN(ATAN(J12))*(J11+L3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)-L6+L5)/J11","v":2.1324871998761221}]
[null,null,null,null,"Ultimate",{"$f":"(((M21*COS(ATAN(J12))*(J10+K3)*J23+M21*SIN(ATAN(J12))*(J10+K3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)-K6+K5)/J10","v":2.5232556910682726},{"$f":"(((M21*COS(ATAN(J12))*(J11+K3)*J23+M21*SIN(ATAN(J12))*(J11+K3)+0.5*J14*J22*(K9+M16)^2)*K9)/(1-M20)-K6+K5)/J11","v":2.2107909159633432},null,"densité air niv. mer(kg/m²)",1.2250000000000001]
[null,null,null,null,null,null,null,null,"R constante gaz parfait",8.3144500000000008]
[null,null,null,null,null,null,null,null,"température (C°)",25,{"$f":"J20+273.15","v":298.14999999999998},"perte rendement",0.03]
[null,null,null,null,null,null,null,null,"masse molaire air (kg/mol)",2.8964400000000001E-2,null,"constante g (m/s²)",9.8059999999999992]
[null,null,null,null,null,null,null,null,"rho air",{"$f":"J18*EXP((-M21*J21*J13)/(J19*K20))","v":1.1567953802080957}]
[null,null,null,null,null,null,null,null,"coeff résis roulement",5.0000000000000001E-3]
[null,null,null,null,null,null,null,null,"coeff trainé",0.65,"pas pris \nen compte"]
[null,null,null,null,null,null,null,null,"aire frontale (m²)",0.5]

{"sheet":"W ou WpKg constant","index":1,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[[16,27,17,28],[0,24,0,28],[23,26,24,26],[29,0,29,8],[37,0,37,1],[31,0,31,1],[0,0,0,11],[0,12,0,22]]}
["pente",null,null,null,null,null,null,null,null,null,null,null,"vitesse",null,null,null,null,null,null,null,null,null,null,null,"paramètres vélo"]
["pente","vitesse \n(km/h)","Aeroad","Aeroad W/kg","Rose","Rose W/kg","Ultimate","Ultimate W/kg","différence Ultimate\n","différence Ultimate\nW/kg","différence Rose\n","différence Rose \nW/kg","vitesse\n(km/h)","Aeroad","Aeroad W/kg","Rose","Rose W/kg","Ultimate","Ultimate W/kg","différence Ultimate\n","différence Ultimate\nW/kg","différence Rose\n","différence Rose \nW/kg",null,null,"Aeroad CF SLX","Ultimate CF SLX","Rose Six"]
[0,35.143942876578855,{"$f":"(($AC$21*COS(ATAN(A3))*($Z$9+$Z$3+$Z$6)*$Z$23+$AC$21*SIN(ATAN(A3))*($Z$9+$Z$3+$Z$6)+0.5*$Z$13*$Z$22*((B3/3.6)+$AC$16)^2)*(B3/3.6))/(1-$AC$20)-((($AA$4-$Z$4)*(B3/3.6)^3)/(45/3.6)^3)+$Z$5-(($Z$8)*(B3/3.6)^3)/((45/3.6)^3)","v":200.00004353525418},{"$f":"C3/$Z$9","v":3.174603865638955},{"$f":"(($AC$21*COS(ATAN(A3))*($Z$10+$AB$3+$AB$6)*$Z$23+$AC$21*SIN(ATAN(A3))*($Z$10+$AB$3+$AB$6)+0.5*$Z$13*$Z$22*((B3/3.6)+$AC$16)^2)*(B3/3.6))/(1-$AC$20)-((($AA$4-$AB$4)*(B3/3.6)^3)/(45/3.6)^3)+$AB$5-(($AB$8)*(B3/3.6)^3)/((45/3.6)^3)","v":219.97231418769829},{"$f":"E3/$Z$10","v":2.9725988403743013},{"$f":"(($AC$21*COS(ATAN(A3))*($Z$9+$AA$3+$AA$6)*$Z$23+$AC$21*SIN(ATAN(A3))*($Z$9+$AA$3+$AA$6)+0.5*$Z$13*$Z$22*((B3/3.6)+$AC$16)^2)*(B3/3.6))/(1-$AC$20)-((($AA$4-$AA$4)*(B3/3.6)^3)/(45/3.6)^3)+$AA$5-(($AA$8)*(B3/3.6)^3)/((45/3.6)^3)","v":221.1104146440845},{"$f":"G3/$Z$9","v":3.5096891213346746},{"$f":"G3-C3","v":21.110371108830321},{"$f":"H3-D3","v":0.33508525569571956},{"$f":"E3-C3","v":19.972270652444109},{"$f":"F3-D3","v":-0.20200502526465369},10,{"$f":"(($AC$21*COS(ATAN(Z15))*($Z$9+$Z$3+$Z$6)*$Z$23+$AC$21*SIN(ATAN($Z$15))*($Z$9+$Z$3+$Z$6)+0.5*$Z$13*$Z$22*((M3/3.6)+$AC$16)^2)*(M3/3.6))/(1-$AC$20)-((($AA$4-$Z$4)*(M3/3.6)^3)/(45/3.6)^3)+$Z$5-(($Z$8)*(M3/3.6)^3)/((45/3.6)^3)","v":14.008101225317761},{"$f":"N3/$Z$9","v":0.22235081310028193},{"$f":"(($AC$21*COS(ATAN(Z15))*($Z$10+$AB$3+$AB$6)*$Z$23+$AC$21*SIN(ATAN($Z$15))*($Z$10+$AB$3+$AB$6)+0.5*$Z$13*$Z$22*((M3/3.6)+$AC$16)^2)*(M3/3.6))/(1-$AC$20)-((($AA$4-$AB$4)*(M3/3.6)^3)/(45/3.6)^3)+$AB$5-(($AB$8)*(M3/3.6)^3)/((45/3.6)^3)","v":15.829583360851538},{"$f":"P3/$Z$10","v":0.21391328866015594},{"$f":"(($AC$21*COS(ATAN(Z15))*($Z$9+$AA$3+$AA$6)*$Z$23+$AC$21*SIN(ATAN($Z$15))*($Z$9+$AA$3+$AA$6)+0.5*$Z$13*$Z$22*((M3/3.6)+$AC$16)^2)*(M3/3.6))/(1-$AC$20)-((($AA$4-$AA$4)*(M3/3.6)^3)/(45/3.6)^3)+$AA$5-(($AA$8)*(M3/3.6)^3)/((45/3.6)^3)","v":16.338686991018548},{"$f":"R3/$Z$9","v":0.25934423795267536},{"$f":"R3-N3","v":2.3305857657007873},{"$f":"S3-O3","v":3.6993424852393431E-2},{"$f":"P3-N3","v":1.8214821355337776},{"$f":"Q3-O3","v":-8.437524440125993E-3},null,"poids",7.85,7,7.4]
[8.0000000000000002E-3,31.362883390575373,{"$f":"(($AC$21*COS(ATAN(A4))*($Z$9+$Z$3+$Z$6)*$Z$23+$AC$21*SIN(ATAN(A4))*($Z$9+$Z$3+$Z$6)+0.5*$Z$13*$Z$22*((B4/3.6)+$AC$16)^2)*(B4/3.6))/(1-$AC$20)-((($AA$4-$Z$4)*(B4/3.6)^3)/(45/3.6)^3)+$Z$5-(($Z$8)*(B4/3.6)^3)/((45/3.6)^3)","v":200.00004244778737},3.1746038483775774,{"$f":"(($AC$21*COS(ATAN(A4))*($Z$10+$AB$3+$AB$6)*$Z$23+$AC$21*SIN(ATAN(A4))*($Z$10+$AB$3+$AB$6)+0.5*$Z$13*$Z$22*((B4/3.6)+$AC$16)^2)*(B4/3.6))/(1-$AC$20)-((($AA$4-$AB$4)*(B4/3.6)^3)/(45/3.6)^3)+$AB$5-(($AB$8)*(B4/3.6)^3)/((45/3.6)^3)","v":222.57336344612898},3.0077481546774187,{"$f":"(($AC$21*COS(ATAN(A4))*($Z$9+$AA$3+$AA$6)*$Z$23+$AC$21*SIN(ATAN(A4))*($Z$9+$AA$3+$AA$6)+0.5*$Z$13*$Z$22*((B4/3.6)+$AC$16)^2)*(B4/3.6))/(1-$AC$20)-((($AA$4-$AA$4)*(B4/3.6)^3)/(45/3.6)^3)+$AA$5-(($AA$8)*(B4/3.6)^3)/((45/3.6)^3)","v":214.90704083177712},3.4112228703456688,{"$f":"G4-C4","v":14.906998383989759},{"$f":"H4-D4","v":0.23661902196809148},{"$f":"E4-C4","v":22.573320998341615},{"$f":"F4-D4","v":-0.16685569370015862},11.5,{"$f":"(($AC$21*COS(ATAN(Z16))*($Z$9+$Z$3+$Z$6)*$Z$23+$AC$21*SIN(ATAN($Z$15))*($Z$9+$Z$3+$Z$6)+0.5*$Z$13*$Z$22*((M4/3.6)+$AC$16)^2)*(M4/3.6))/(1-$AC$20)-((($AA$4-$Z$4)*(M4/3.6)^3)/(45/3.6)^3)+$Z$5-(($Z$8)*(M4/3.6)^3)/((45/3.6)^3)","v":17.511030025904798},{"$f":"N4/$Z$9","v":0.27795285755404442},{"$f":"(($AC$21*COS(ATAN(Z16))*($Z$10+$AB$3+$AB$6)*$Z$23+$AC$21*SIN(ATAN($Z$15))*($Z$10+$AB$3+$AB$6)+0.5*$Z$13*$Z$22*((M4/3.6)+$AC$16)^2)*(M4/3.6))/(1-$AC$20)-((($AA$4-$AB$4)*(M4/3.6)^3)/(45/3.6)^3)+$AB$5-(($AB$8)*(M4/3.6)^3)/((45/3.6)^3)","v":19.731903206048482},{"$f":"P4/$Z$10","v":0.2666473406222768},{"$f":"(($AC$21*COS(ATAN(Z16))*($Z$9+$AA$3+$AA$6)*$Z$23+$AC$21*SIN(ATAN($Z$15))*($Z$9+$AA$3+$AA$6)+0.5*$Z$13*$Z$22*((M4/3.6)+$AC$16)^2)*(M4/3.6))/(1-$AC$20)-((($AA$4-$AA$4)*(M4/3.6)^3)/(45/3.6)^3)+$AA$5-(($AA$8)*(M4/3.6)^3)/((45/3.6)^3)","v":20.058071969217913},{"$f":"R4/$Z$9","v":0.3183820947494907},{"$f":"R4-N4","v":2.5470419433131148},{"$f":"S4-O4","v":4.0429237195446277E-2},{"$f":"P4-N4","v":2.2208731801436841},{"$f":"Q4-O4","v":-1.1305516931767623E-2},null,"aero à 45km/h(W)",204,235,225]
[1.6E-2,27.752773009336551,200.00001662745623,3.1746034385310513,224.53579127111107,3.0342674496096089,210.22665458071555,3.3369310250907231,10.226637953259313,0.16232758655967183,24.535774643654833,-0.14033598892144239,13,21.600722666078102,0.34286861374727146,24.273801705646498,0.32802434737360131,24.434072638855383,0.38784242283897435,2.8333499727772811,4.4973809091702899E-2,2.6730790395683961,-1.4844266373670145E-2,null,"pénalité position(W)",0,2,0,"manuel"]
[2.4E-2,24.430145553875555,200.00000217369802,3.1746032091063179,225.9433125205401,3.0532880070343258,206.86973446790387,3.2836465788556168,6.8697322942058463,0.10904336974929896,25.943310346842082,-0.12131520207199209,14.5,20.90130370645878,0.33176672549934572,23.296684567883663,0.31482006172815763,24.163542356978944,0.38354829138061813,3.2622386505201639,5.1781565881272418E-2,2.3953808614248828,-1.6946663771188086E-2,null,"poids matériel",2,2,2]
[3.2000000000000001E-2,21.483174363854861,200.00060367618048,3.1746127567647693,226.91046238923437,3.0663575998545185,204.56536816404548,3.2470693359372298,4.5647644878650055,7.2456579172460511E-2,26.909858713053893,-0.10825515691025078,16,17.435010831591129,0.27674620367604968,19.111451454809888,0.25826285749743094,21.25512782205687,0.33738298130249,3.8201169904657419,6.0636777626440319E-2,1.6764406232187596,-1.8483346178618743E-2,null,"taille de cadre","XS","M","M","à titre indicatif"]
[0.04,18.947806845675903,200.00000163174812,3.1746032005039386,227.55449673694454,3.0750607667154668,203.02714030367733,3.2226530206932908,3.0271386719292082,4.8049820189352221E-2,27.554495105196423,-9.9542433788471829E-2,17.5,21.446332174573268,0.34041797102497251,23.441983324417297,0.3167835584380716,25.843790520421205,0.41021889714954296,4.3974583458479373,6.980092612457045E-2,1.9956511498440292,-2.363441258690091E-2,null,"gain taille cadre aero (W)",10,0,0,"5W/taille cadre"]
[4.8000000000000001E-2,16.809781470180852,200.00000244752252,3.1746032134527384,227.97970594966321,3.0808068371576112,202.01304106032552,3.2065562073067544,2.0130386128030011,3.1952993854015954E-2,27.979703502140694,-9.3796376295127271E-2,19,45.349672918158667,0.71983607806601058,50.496321490789356,0.68238272284850476,50.209090806972071,0.79696969534876305,4.8594178888134039,7.7133617282752476E-2,5.1466485726306885,-3.7453355217505813E-2,null,"masse cycliste (kg) - CANYON",63,null,"CdA exemple"]
[5.6000000000000001E-2,15.023528056877652,200.00000230604607,3.1746032112070806,228.26121810589845,3.0846110554851141,201.34164840515629,3.195899181034227,1.3416460991102213,2.1295969827146433E-2,28.26121579985238,-8.9992155721966505E-2,20.5,46.008967903996627,0.73030107784121634,50.887322279017269,0.68766651728401718,51.728271060501136,0.82108366762700213,5.7193031565045089,9.0782589785785794E-2,4.878354375020642,-4.2634560557199164E-2,null,"masse cycliste 2 (kg) - ROSE",74,null,"Barres",0.40799999999999997]
[6.4000000000000001E-2,13.532855011976313,200.00000179910876,3.1746032031604563,228.45024209996024,3.0871654337832464,200.89083393873415,3.188743395852923,0.89083213962538821,1.4140192692466691E-2,28.450240300851476,-8.7437769377209928E-2,22,62.746565032651546,0.99597722274050071,69.627727382943377,0.94091523490464024,69.274877575268746,1.0996012313534722,6.5283125426172006,0.1036240086129715,6.8811623502918309,-5.5061987835860471E-2,null,null,null,null,"Cocottes",0.32400000000000001]
[7.1999999999999995E-2,12.283733191690651,200.0000012893862,3.1746031950696225,228.5796838800907,3.0889146470282527,200.58212000212549,3.1838431746369125,0.5821187127392875,9.2399795672899465E-3,28.579682590704493,-8.5688548041369828E-2,23.5,69.203475587136239,1.0984678664624801,76.537094228684495,1.0342850571443851,76.80747742159943,1.219166308279356,7.6040018344631903,0.12069844181687595,7.3336186415482558,-6.4182809318094947E-2,null,"altitude (m) - influence densité air",200,null,"Ceintre",0.307]
[0.08,11.22971001659171,200.00000089132558,3.1746031887511998,228.67027933371622,3.0901389099150842,200.36605298741364,3.180413539482756,0.36605209608805467,5.8103507315561131E-3,28.670278442390639,-8.4464278836115625E-2,25,81.926230256549204,1.3004163532785589,90.55399628171979,1.2237026524556729,90.689543603080267,1.4395165651282582,8.7633133465310635,0.13910021184969934,8.6277660251705868,-7.6713700822885977E-2,null,"CdA (coeff trainée x aire frontale)",0.32,null,"Aerobars",0.29139999999999999]
[8.7999999999999995E-2,10.332961554937322,200.00000060933618,3.1746031842751776,228.73509188170985,3.0910147551582412,200.21147731874643,3.1779599574404194,0.21147670941024899,3.3567731652417443E-3,28.735091272373666,-8.3588429116936425E-2,26.5,97.440507495766738,1.5466747221550277,107.6967726034909,1.4553617919390662,107.49729640038824,1.7063062920696546,10.056788904621499,0.1596315699146269,10.256265107724161,-9.131293021596143E-2]
[9.6000000000000002E-2,9.5634596633530133,200.0000004174025,3.1746031812286111,228.78244071337883,3.0916546042348489,200.09855205735181,3.1761674929738382,9.8551639949306491E-2,1.5643117452270872E-3,28.782440295976329,-8.2948576993762124E-2,28,111.60723129405176,1.7715433538738374,123.2227392982377,1.6651721526788879,123.14995785776706,1.9547612358375723,11.542726563715306,0.1832178819637349,11.615508004185941,-0.10637120119494958,null,"pente - seulement Tab vitesse",0,null,"vitesse vent (km/h)",0]
[0.104,8.897592524097897,200.00000028848618,3.1746031791823204,228.817712067386,3.0921312441538649,200.01443119829341,3.1748322412427523,1.4430909807231274E-2,2.2906206043193933E-4,28.81771177889982,-8.2471935028455512E-2,29.5,127.20259748437289,2.0190888489582997,140.30594097761318,1.896026229427205,140.40133578125605,2.2285926314485089,13.198738296883164,0.20950378249020929,13.103343493240288,-0.12306261953109465,null,null,null,null,"vitesse vent (m/s)",{"$f":"AC15/3.6","v":0}]
[0.112,8.3168447914022146,200.00085355768965,3.1746167231379312,228.84543578298801,3.0925058889592973,199.95148457344197,3.1738330884673327,-4.9368984247678327E-2,-7.8363467059849867E-4,28.844582225298353,-8.2110834178633851E-2,31,144.30314048058918,2.2905260393744316,159.02980094436526,2.1490513641130442,159.3370756958254,2.5291599316797684,15.033935215236227,0.23863389230533683,14.726660463776085,-0.14147467526138735,null,null,null,null,"positive vent de face ; négatif vent de dos"]
[0.12,7.8065094828934223,200.00071980124739,3.1746146000197997,228.86590065890294,3.0927824413365261,199.90217949316192,3.1730504681454272,-9.8540308085460993E-2,-1.564131874372432E-3,28.86518085765556,-8.1832158683273537E-2,32.5,162.98539469655969,2.587069757088249,179.47774250124198,2.425374898665432,180.04282312644528,2.8578225893086553,17.05742842988559,0.27075283222040625,16.492347804682282,-0.16169485842281706,null,"densité air niv. mer(kg/m²)",1.2250000000000001]
[0.128,7.3550164668670845,200.00061124116348,3.1746128768438648,228.88190511560859,3.0929987177784946,199.86360598192857,3.1724381901893426,-0.13700525923491114,-2.174686654522251E-3,28.881293874445106,-8.1614159065370284E-2,34,183.32589454614359,2.9099348340657714,201.73318895099135,2.7261241750133967,202.60422359808592,3.215940057112475,19.278329051942336,0.30600522304670363,18.407294404847761,-0.1838106590523747,null,"R constante gaz parfait",8.3144500000000008]
[0.13600000000000001,6.9530748004203575,200.00052267281859,3.1746114709971205,228.89459093202623,3.0931701477300844,199.83302160103574,3.1719527238259642,-0.16750107178285134,-2.6587471711563282E-3,28.894068259207643,-8.1441323267036125E-2,35.5,205.40117444319981,3.2603361022730128,225.87956359636118,3.0524265350859618,227.10692263571741,3.6048717878685301,21.705748192517603,0.34453568559551728,20.478389153161373,-0.207909567187051,null,"température (C°)",15,{"$f":"Z20+273.15","v":288.14999999999998},"perte rendement",0.03]
[0.14399999999999999,6.5931905852191566,200.00044996915381,3.1746103169706954,228.90476987171968,3.0933077009691847,199.80847498865225,3.1715630950579721,-0.19197498050155559,-3.0472219127233302E-3,28.904319902565874,-8.1302616001510675E-2,37,229.2877688015875,3.6394883936759923,252.0002897400995,3.4054093208121556,253.63656576431003,4.0259772343541274,24.348796962722531,0.38648884067813505,22.712520938512,-0.23407907286383667,null,"masse molaire air (kg/mol)",2.8964400000000001E-2,null,"constante g (m/s²)",9.8059999999999992]
[0.152,6.2692688365166553,200.00038989504898,3.174609363413476,228.91302860696459,3.0934193054995216,199.78855493100684,3.1712469036667752,-0.21183496404213997,-3.3624597467007966E-3,28.912638711915605,-8.1190057913954394E-2,38.5,255.0622120351658,4.0486065402407272,280.17879068495444,3.7861998741210057,282.27879850883403,4.480615849346572,27.216586473668229,0.43200930910584479,25.116578649788636,-0.26240666611972152,null,"rho air",{"$f":"Z18*EXP((-AC21*Z21*Z12)/(Z19*AA20))","v":1.1962966927835792}]
[0.16,5.9763117079113321,200.00033992410502,3.1746085702238891,228.91979762825227,3.0935107787601659,199.77222533541087,3.1709877037366803,-0.22811458869415446,-3.6208664872088292E-3,28.919457704147248,-8.1097791463723201E-2,40,282.80103855779373,4.4889053739332336,310.49848973367369,4.1959255369415365,313.1192663942594,4.9701470856231653,30.318227836465667,0.48124171168993168,27.697451175879962,-0.29297983699169716,null,"coeff résis roulement",5.0000000000000001E-3]
[0.16800000000000001,5.7101886495203775,200.00029808217221,3.1746079060662256,228.92539729780376,3.0935864499703212,199.75871481311071,3.1707732510017572,-0.24158326906149341,-3.8346550644683397E-3,28.925099215631548,-8.1021456095904387E-2,41.5,312.58078278333033,4.9615997267195295,343.04281018900537,4.6357136512027752,346.24361494555643,5.4959303959612136,33.662832162226096,0.53433066924168404,30.46202740567503,-0.3258860755167543,null,"coeff trainé",0.65,"pas pris \nen compte"]
[0.17599999999999999,5.4674602308403948,200.00026282174775,3.1746073463769484,228.93006914484184,3.0936495830384034,199.74744157458989,3.1705943107077759,-0.25282124715786836,-4.0130356691725488E-3,28.929806323094084,-8.0957763338544986E-2,43,344.47797912563476,5.467904430565631,377.89517535369748,5.1066915588337496,381.73748968769542,6.0593252331380221,37.259510562060655,0.59142080257239105,33.417196228062721,-0.36121287173188144,null,"aire frontale (m²)",0.5,null,"puissance cible",200]
[0.184,5.2452421198265595,200.00023292412175,3.1746068718114562,228.93399746963044,3.0937026685085196,199.73796154114845,3.1704438339864836,-0.26227138297329589,-4.1630378249726263E-3,28.933764545508694,-8.0904203302936573E-2,44.5,378.56916199856596,6.0090343174375551,415.13900853049785,5.6099866017634845,419.68653614564647,6.6616910499308961,41.117374147080511,0.652656732493341,36.569846531931887,-0.3990477156740706]
[0.192,5.0410992649535293,200.0002074242401,3.1746064670514302,228.93732448004613,3.0937476281087313,199.72993196554336,3.1703163804054499,-0.27027545869674441,-4.2900866459802955E-3,28.937117055806027,-8.0858838942698963E-2,46,414.93086581598317,6.5862042193013197,454.85773302215455,6.1467261219210076,460.17639984437966,7.3043872991171375,45.245534028396492,0.71818307981581775,39.92686720617138,-0.43947809738031207]
[0.2,4.8529629388434286,200.0001855533676,3.1746061198947237,228.94016104529504,3.0937859600715547,199.72308557170632,3.170207707487402,-0.27709998166128003,-4.3984124073217501E-3,28.939975491927441,-8.0820159823169035E-2,47.5,453.63962499174539,7.2006289681229427,497.13477213141556,6.7180374612353457,503.29272630886533,7.9887734334740532,49.653101317119933,0.78814446535111049,43.495147139670166,-0.482591506887597]
[]
["puissance- pente"]
[]
["puissance brute identique",null,"vélo","Aeroad","Rose","Ultimate"]
[null,null,"puissance (W)",{"$f":"(($AC$21*COS(ATAN(H37))*($Z$9+$Z$3+$Z$6)*$Z$23+$AC$21*SIN(ATAN(H37))*($Z$9+$Z$3+$Z$6)+0.5*$Z$13*$Z$22*((D34/3.6)+$AC$16)^2)*(D34/3.6))/(1-$AC$20)-((($AA$4-$Z$4)*(D34/3.6)^3)/(45/3.6)^3)+$Z$5-(($Z$8)*(D34/3.6)^3)/((45/3.6)^3)","v":203.52433813297392},{"$f":"(($AC$21*COS(ATAN(H37))*($Z$10+$AB$3+$AB$6)*$Z$23+$AC$21*SIN(ATAN(H37))*($Z$10+$AB$3+$AB$6)+0.5*$Z$13*$Z$22*((E34/3.6)+$AC$16)^2)*(E34/3.6))/(1-$AC$20)-((($AA$4-$AB$4)*(E34/3.6)^3)/(45/3.6)^3)+$AB$5-(($AB$8)*(E34/3.6)^3)/((45/3.6)^3)","v":199.99999967371375},{"$f":"(($AC$21*COS(ATAN(H37))*($Z$9+$AA$3+$AA$6)*$Z$23+$AC$21*SIN(ATAN(H37))*($Z$9+$AA$3+$AA$6)+0.5*$Z$13*$Z$22*((F34/3.6)+$AC$16)^2)*(F34/3.6))/(1-$AC$20)-((($AA$4-$AA$4)*(F34/3.6)^3)/(45/3.6)^3)+$AA$5-(($AA$8)*(F34/3.6)^3)/((45/3.6)^3)","v":202.50076083168244}]
[null,null,"vitesse (km/h)",11.668192472778786,10.101046503074231,11.590470546735295]
[null,null,"gain vitesse / aeroad",0,{"$f":"(E34-$D$34)/E34","v":-0.15514689188170724},{"$f":"(F34-$D$34)/F34","v":-6.7056747808554844E-3}]
[null,null,"gain temps (min)",0,{"$f":"(($H$38/D34)-($H$38/E34))*60","v":-15.955879258281618},{"$f":"(($H$38/D34)-($H$38/F34))*60","v":-0.68963635591368089},"puissance (W)",200]
[null,null,null,null,null,null,"pente",7.8E-2]
["puissance en W/kg identique",null,"puissance (W)",{"$f":"(($AC$21*COS(ATAN(H37))*($Z$9+$Z$3+$Z$6)*$Z$23+$AC$21*SIN(ATAN(H37))*($Z$9+$Z$3+$Z$6)+0.5*$Z$13*$Z$22*((D40/3.6)+$AC$16)^2)*(D40/3.6))/(1-$AC$20)-((($AA$4-$Z$4)*(D40/3.6)^3)/(45/3.6)^3)+$Z$5-(($Z$8)*(D40/3.6)^3)/((45/3.6)^3)","v":203.52433813297392},{"$f":"(($AC$21*COS(ATAN(H37))*($Z$10+$AB$3+$AB$6)*$Z$23+$AC$21*SIN(ATAN(H37))*($Z$10+$AB$3+$AB$6)+0.5*$Z$13*$Z$22*((E40/3.6)+$AC$16)^2)*(E40/3.6))/(1-$AC$20)-((($AA$4-$AB$4)*(E40/3.6)^3)/(45/3.6)^3)+$AB$5-(($AB$8)*(E40/3.6)^3)/((45/3.6)^3)","v":239.88387410582885},{"$f":"(($AC$21*COS(ATAN(H37))*($Z$9+$AA$3+$AA$6)*$Z$23+$AC$21*SIN(ATAN(H37))*($Z$9+$AA$3+$AA$6)+0.5*$Z$13*$Z$22*((F40/3.6)+$AC$16)^2)*(F40/3.6))/(1-$AC$20)-((($AA$4-$AA$4)*(F40/3.6)^3)/(45/3.6)^3)+$AA$5-(($AA$8)*(F40/3.6)^3)/((45/3.6)^3)","v":202.50036482879366},"distance (km)",20]
[null,null,"puissance (W/kg)",{"$f":"D38/Z9","v":3.230545049729745},{"$f":"E38/Z10","v":3.2416739744030925},{"$f":"F38/Z9","v":3.2142915052189469}]
[null,null,"vitesse (km/h)",11.668192472778786,12.009921991048325,11.590449065822549]
[null,null,"gain vitesse / aeroad",0,{"$f":"(E40-$D$34)/E40","v":2.8453933216572823E-2},{"$f":"(F40-$D$34)/F40","v":-6.7075405374485558E-3}]
[null,null,"gain temps (min)",0,{"$f":"(($H$38/D40)-($H$38/E40))*60","v":2.926307561307806},{"$f":"(($H$38/D40)-($H$38/F40))*60","v":-0.68982823721122521}]

{"sheet":"2 profils","index":2,"n_rows":56,"n_cols":19,"rows_kept":56,"cut":false,"hidden":false,"merged":[[27,13,28,13],[9,11,9,15],[15,11,15,15],[20,11,20,15],[0,17,0,18],[16,16,17,17],[1,17,1,18],[0,0,0,3],[0,11,0,15]]}
["vitesse selon pente",null,null,null,null,null,null,null,null,null,null,"Profil vélo",null,null,null,null,null,"Info"]
["pente","Aeroad","Rose","Ultimate","puissance aeroad","puissance rose","puissance ultimate",null,null,null,null,null,"Aeroad CF SLX","Ultimate CF SLX","Rose Six",null,null,"CdA exemple"]
[0,34.809241118533706,34.368500306781655,33.543682492838286,{"$f":"(($P$25*COS(ATAN(A3))*($M$11+$M$3+$M$8)*$P$22+$P$25*SIN(ATAN(A3))*($M$11+$M$3+$M$8)+0.5*$M$13*$M$25*((B3/3.6)+$P$18)^2)*(B3/3.6))/(1-$P$23)-((($N$4-$M$4)*(B3/3.6)^3)/(45/3.6)^3)+$M$5-(($M$7)*(B3/3.6)^3)/((45/3.6)^3)","v":199.99999312502047},{"$f":"(($P$25*COS(ATAN(A3))*($P$11+$O$3+$O$8)*$P$22+$P$25*SIN(ATAN(A3))*($P$11+$O$3+$O$8)+0.5*$P$13*$M$25*((C3/3.6)+$P$18)^2)*(C3/3.6))/(1-$P$23)-((($N$4-$O$4)*(C3/3.6)^3)/(45/3.6)^3)+$O$5-(($O$7)*(C3/3.6)^3)/((45/3.6)^3)","v":215.00005797970238},{"$f":"(($P$25*COS(ATAN(A3))*($M$11+$N$3+$N$8)*$P$22+$P$25*SIN(ATAN(A3))*($M$11+$N$3+$N$8)+0.5*$M$13*$M$25*((D3/3.6)+$P$18)^2)*(D3/3.6))/(1-$P$23)-((($N$4-$N$4)*(D3/3.6)^3)/(45/3.6)^3)+$N$5-(($N$7)*(D3/3.6)^3)/((45/3.6)^3)","v":200.0000685046891},null,null,null,null,"poids vélo et matériel",7.85,7,7.4,null,null,"Barres",0.40799999999999997]
[8.0000000000000002E-3,31.103668579275894,30.500429364336004,30.122445518816274,{"$f":"(($P$25*COS(ATAN(A4))*($M$11+$M$3+$M$8)*$P$22+$P$25*SIN(ATAN(A4))*($M$11+$M$3+$M$8)+0.5*$M$13*$M$25*((B4/3.6)+$P$18)^2)*(B4/3.6))/(1-$P$23)-((($N$4-$M$4)*(B4/3.6)^3)/(45/3.6)^3)+$M$5-(($M$7)*(B4/3.6)^3)/((45/3.6)^3)","v":199.99998719590937},{"$f":"(($P$25*COS(ATAN(A4))*($P$11+$O$3+$O$8)*$P$22+$P$25*SIN(ATAN(A4))*($P$11+$O$3+$O$8)+0.5*$P$13*$M$25*((C4/3.6)+$P$18)^2)*(C4/3.6))/(1-$P$23)-((($N$4-$O$4)*(C4/3.6)^3)/(45/3.6)^3)+$O$5-(($O$7)*(C4/3.6)^3)/((45/3.6)^3)","v":215.00003838336156},{"$f":"(($P$25*COS(ATAN(A4))*($M$11+$N$3+$N$8)*$P$22+$P$25*SIN(ATAN(A4))*($M$11+$N$3+$N$8)+0.5*$M$13*$M$25*((D4/3.6)+$P$18)^2)*(D4/3.6))/(1-$P$23)-((($N$4-$N$4)*(D4/3.6)^3)/(45/3.6)^3)+$N$5-(($N$7)*(D4/3.6)^3)/((45/3.6)^3)","v":200.00004007322212},null,null,null,null,"aero à 45km/h(W)",204,235,225,null,null,"Cocottes",0.32400000000000001]
[1.6E-2,27.561953626015775,26.8245578092573,26.839506085679812,199.99998589656551,215.00000418855416,200.00002013430063,null,null,null,null,"pénalité position(W)",0,2,0,"manuel",null,"Ceintre",0.307]
[2.4E-2,24.296260003473655,23.469334746454589,23.790982297383579,199.99998892836879,215.00000276576299,200.00000866317887,null,null,null,null,"taille de cadre","XS","M","M","à titre indicatif",null,"Aerobars",0.29139999999999999]
[3.2000000000000001E-2,21.392560581584938,20.525936876645645,21.05429558894582,199.99999318455826,215.00001422538713,200.00000325245108,null,null,null,null,"gain taille cadre aero 45km/h (W)",10,0,0,"5W/taille cadre"]
[0.04,18.887730611213112,18.023485781309972,18.668262519325868,199.99999643286893,215.00001935806097,200.0000011145797,null,null,null,null,"poids matériel",2,2,2]
[4.8000000000000001E-2,16.76997356617775,15.936016510119554,16.630316250391548,199.99906345721524,215.00001735913906,199.99914532209939]
[5.6000000000000001E-2,14.996940470900629,14.207651695701593,14.909130243564089,199.99946252387656,215.00001291760137,199.99951048170701,null,null,null,null,"Profil cycliste"]
[6.4000000000000001E-2,13.514782356291935,12.775365305465392,13.460206412238435,199.9996881777746,215.00000882287281,199.99971573787826,null,null,null,null,"masse cycliste 1 (kg) - CANYON",63,null,"masse cycliste 2 (kg) - ROSE",74]
[7.1999999999999995E-2,12.271185930048759,11.581489987010416,12.237912229782205,199.99981519378824,215.00000581995451,199.99983121606326,null,null,null,null,"puissance (W)",200,null,"puissance (W)",215]
[0.08,11.220804316418389,10.578035729817191,11.20128796362399,199.99988757119496,215.0000038079987,199.99989711844145,null,null,null,null,"CdA (coeff trainée x aire frontale)",0.32500000000000001,null,"CdA (coeff trainée x aire frontale)",0.33]
[8.7999999999999995E-2,10.326502833129519,9.7268044498212198,10.315967786065814,199.99992969057973,215.00000250609892,199.99993613430419,null,null,null,null,"puissance (W/kg)",{"$f":"M12/M11","v":3.1746031746031744},null,"puissance (W/kg)",{"$f":"P12/P11","v":2.9054054054054053}]
[9.6000000000000002E-2,9.558679565435213,8.9979608915362448,9.5540739830326249,199.99995482030522,215.00000167065795,199.9999589196905]
[0.104,8.8939878518436757,8.3683228454964365,8.893335349683932,199.99997020914353,215.00000113185217,199.99997288925093,null,null,null,null,"Paramètres environmentaux"]
[0.112,8.3140447898587233,7.8198386738251342,8.3160461833572885,199.99997987781822,215.0000007802447,199.99998167499487,null,null,null,null,"altitude (m) - influence densité air",100,null,"vitesse vent (km/h)",0,"positive vent de face ; négatif vent de dos"]
[0.12,7.8043271999373687,7.3383664268089195,7.808115622163827,199.99998610324155,215.00000054732908,199.99998733714474,null,null,null,null,"température (C°)",20,null,"vitesse vent (m/s)",{"$f":"P17/3.6","v":0}]
[0.128,7.3532914227012931,6.9127379343921556,7.3582802816995256,199.99999020490179,215.00000039050079,199.99999107041731,null,null,null,null,"température (K°)",{"$f":"M18+273.15","v":293.14999999999998}]
[0.13600000000000001,6.9516935495733012,6.5340549416108979,6.9574808498052061,199.99999296572764,215.00000028314003,199.99999358481173]
[0.14399999999999999,6.5920715802725347,6.1951630029896219,6.5983787916395782,199.99999486117903,215.00000020844018,199.9999953119497,null,null,null,null,"Constantes"]
[0.152,6.268352539347827,5.8902826073825691,6.274984921089759,199.9999961864973,215.00090812835595,199.99999652009166,null,null,null,null,"densité air niv. mer(kg/m^3)",1.2250000000000001,null,"coeff résis roulement",5.0000000000000001E-3]
[0.16,5.9755540165162175,5.6146105514885356,5.9823744634030209,199.99999712892381,215.00079024273225,199.99999737949852,null,null,null,null,"R constante gaz parfait",8.3144500000000008,null,"perte rendement",0.03]
[0.16800000000000001,5.7095564552628,5.3642576443054564,5.7164679981820248,199.99999780958547,215.00069188902754,199.99999800038424,null,null,null,null,"masse molaire air (kg/mol)",2.8964400000000001E-2]
[0.17599999999999999,5.4669283675479461,5.1359649727984626,5.4738622981912233,199.99999830830734,215.00060925162944,199.99999845542237,null,null,null,null,"rho air (kg/m^3)",{"$f":"M22*EXP((-P25*M24*M17)/(M23*M19))","v":1.2108080798932019},null,"constante g (m/s²)",9.8059999999999992]
[0.184,5.2447912369726373,4.9270027223047883,5.2516989419481233,199.99999867861575,215.00053935566532,199.9999987933671]
[0.192,5.0407143239064034,4.7350685033195585,5.0475616003631609,199.99999895698787,215.0004798645447,199.99999904745667]
[0.2,4.8526321354285118,4.5582078776062724,4.8593951891774436,199.9999991686602,215.00042892941187,199.99999924069488]
[]
["pente","écart Rose","écart Ultimate"]
[0,{"$f":"C3-B3","v":-0.44074081175205038},{"$f":"D3-B3","v":-1.2655586256954194}]
[8.0000000000000002E-3,{"$f":"C4-B4","v":-0.60323921493989019},{"$f":"D4-B4","v":-0.98122306045961949}]
[1.6E-2,-0.73739581675847532,-0.72244754033596337]
[2.4E-2,-0.82692525701906661,-0.50527770609007661]
[3.2000000000000001E-2,-0.8666237049392933,-0.33826499263911813]
[0.04,-0.86424482990313933,-0.21946809188724359]
[4.8000000000000001E-2,-0.83395705605819614,-0.13965731578620222]
[5.6000000000000001E-2,-0.78928877519903651,-8.7810227336539981E-2]
[6.4000000000000001E-2,-0.73941705082654252,-5.4575944053500081E-2]
[7.1999999999999995E-2,-0.68969594303834292,-3.3273700266553519E-2]
[0.08,-0.64276858660119807,-1.9516352794399339E-2]
[8.7999999999999995E-2,-0.59969838330829894,-1.0535047063704894E-2]
[9.6000000000000002E-2,-0.56071867389896823,-4.6055824025881265E-3]
[0.104,-0.52566500634723923,-6.5250215974366199E-4]
[0.112,-0.4942061160335891,2.0013934985652071E-3]
[0.12,-0.46596077312844919,3.7884222264583656E-3]
[0.128,-0.44055348830913754,4.9888589982325371E-3]
[0.13600000000000001,-0.41763860796240326,5.7873002319048794E-3]
[0.14399999999999999,-0.39690857728291284,6.307211367043486E-3]
[0.152,-0.37806993196525784,6.6323817419320363E-3]
[0.16,-0.36094346502768193,6.8204468868033885E-3]
[0.16800000000000001,-0.3452988109573436,6.9115429192248001E-3]
[0.17599999999999999,-0.33096339474948344,6.9339306432771863E-3]
[0.184,-0.31778851466784896,6.9077049754859843E-3]
[0.192,-0.30564582058684486,6.8472764567575339E-3]
[0.2,-0.29442425782223935,6.7630537489318243E-3]

{"sheet":"temps de montée","index":3,"n_rows":38,"n_cols":25,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,9],[26,17,26,21],[33,17,33,21],[27,22,28,23],[0,17,0,21],[0,23,0,24],[1,23,1,24],[17,17,17,21]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Profil vélo",null,null,null,null,null,"Info"]
["pente","longueur côte (km)","vitesse \n(km/h)","Aeroad","temps montée Aeroad (h)","vitesse \n(km/h)","Rose","temps montée Rose (h)","vitesse \n(km/h)","Ultimate","temps montée Ultimate (h)","différence Tps Rose - Aeroad","différence Tps Ultimate - Aeroad","différence Vitesse Rose - Aeroad","différence Vitesse Ultimate - Aeroad","différence Vitesse Ultimate - Rose",null,null,"Aeroad CF SLX","Ultimate CF SLX","Rose Six",null,null,"CdA exemple"]
[1E-3,{"$f":"(SQRT($S$31^2+($S$31/($A3))^2))/1000","v":100.0000499999875},34.34093994362329,{"$f":"(($V$38*COS(ATAN($A3))*($S$19+$S$3+$S$8)*$V$35+$V$38*SIN(ATAN($A3))*($S$19+$S$3+$S$8)+0.5*$S$21*$S$38*((C3/3.6)+$V$29)^2)*(C3/3.6))/(1-$V$36)-((($T$4-$S$4)*(C3/3.6)^3)/(45/3.6)^3)+$S$5-(($S$7)*(C3/3.6)^3)/((45/3.6)^3)","v":200.00004685058107},{"$f":"B3/C3","v":2.9119776617691659},33.878991542040175,{"$f":"(($V$38*COS(ATAN($A3))*($V$19+$U$3+$U$8)*$V$35+$V$38*SIN(ATAN($A3))*($V$19+$U$3+$U$8)+0.5*$V$21*$S$38*((F3/3.6)+$V$29)^2)*(F3/3.6))/(1-$V$36)-((($T$4-$U$4)*(F3/3.6)^3)/(45/3.6)^3)+$U$5-(($U$7)*(F3/3.6)^3)/((45/3.6)^3)","v":215.00000112058379},{"$f":"B3/F3","v":2.9516831950531413},33.111717289309304,{"$f":"(($V$38*COS(ATAN($A3))*($S$19+$T$3+$T$8)*$V$35+$V$38*SIN(ATAN($A3))*($S$19+$T$3+$T$8)+0.5*$S$21*$S$38*((I3/3.6)+$V$29)^2)*(I3/3.6))/(1-$V$36)-((($T$4-$T$4)*(I3/3.6)^3)/(45/3.6)^3)+$T$5-(($T$7)*(I3/3.6)^3)/((45/3.6)^3)","v":200.0000645577488},{"$f":"B3/I3","v":3.0200804484482071},{"$f":"H3-E3","v":3.9705533283975303E-2},{"$f":"K3-E3","v":0.10810278667904116},{"$f":"F3-C3","v":-0.46194840158311479},{"$f":"I3-C3","v":-1.2292226543139861},{"$f":"I3-F3","v":-0.76727425273087135},null,"poids vélo et matériel",7.85,7,7.4,null,null,"Barres",0.40799999999999997]
[8.9999999999999993E-3,11.111561101998982,30.649627742733728,200.00003985581776,0.36253494480477855,30.027667484785248,215.00000185103403,0.37004409708576635,29.702509538787272,200.00003708810488,0.37409502680198981,7.5091522809878075E-3,1.1560081997211258E-2,{"$f":"F4-C4","v":-0.62196025794847998},{"$f":"I4-C4","v":-0.94711820394645585},{"$f":"I4-F4","v":-0.32515794599797587},null,"aero à 45km/h(W)",204,235,225,null,null,"Cocottes",0.32400000000000001]
[1.7000000000000001E-2,5.8832028797728428,27.13650350019568,200.00001451639301,0.21680032874281019,26.38523240660032,215.00000213177086,0.22297332042074974,26.443747708361045,200.00001826972243,0.22247992019348597,6.1729916779395544E-3,5.6795914506757861E-3,-0.75127109359535993,-0.6927557918346352,5.8515301760724725E-2,null,"pénalité position(W)",0,2,0,"manuel",null,"Ceintre",0.307]
[2.5000000000000001E-2,4.0012498047485119,23.912226127536165,200.00000163535134,0.1673307112189302,23.077661677661503,215.00000170182065,0.1733819422711099,23.430625656917496,200.00000770964138,0.17077007943947969,6.0512310521796953E-3,3.4393682205494935E-3,-0.83456444987466227,-0.48160047061866962,0.35296397925599265,null,"taille de cadre","XS","M","M","à titre indicatif",null,"Aerobars",0.29139999999999999]
[3.3000000000000002E-2,3.0319525813349597,21.057530410172618,200.00077777826124,0.14398424327433301,20.189106819709888,215.00000098407929,0.15017764819466778,20.736549168580243,200.0000028564574,0.14621297674392883,6.1934049203347663E-3,2.2287334695958172E-3,-0.86842359046272932,-0.32098124159237429,0.54744234887035503,null,"gain taille cadre aero 45km/h (W)",10,0,0,"5W/taille cadre"]
[4.1000000000000002E-2,2.4410735294547439,18.602512603010439,200.00000172236361,0.13122278595095296,17.740825884719797,215.00000044874798,0.13759638617259889,18.394922976248008,200.00000097102571,0.13270365592760133,6.3736002216459309E-3,1.4808699766483691E-3,-0.86168671829064181,-0.20758962676243087,0.65409709152821094,null,"poids matériel (kg)",2,2,2]
[4.9000000000000002E-2,2.0432648576809376,16.53062231667737,200.00000245948036,0.12360483583364759,15.701626788213897,215.00000017744659,0.13013077467964482,16.398696954393834,199.99920185293206,0.12459922049681327,6.5259388459972256E-3,9.9438466316567609E-4,-0.82899552846347291,-0.13192536228353546,0.69707016617993744,null,"cassette max (T)",30,28,28]
[5.7000000000000002E-2,1.7572336537527369,14.796917393882357,200.00000228691704,0.11875673878393403,14.01374051162823,215.00090426149364,0.1253936200898419,14.714083706403461,199.99954249544427,0.11942528592439648,6.6368813059078657E-3,6.6854714046245267E-4,-0.78317688225412674,-8.2833687478895968E-2,0.70034319477523077,null,"cassette min (T)",11,11,11]
[6.5000000000000002E-2,1.541708112881762,13.347312291312141,200.00000177998291,0.11550700839488641,12.614205042914854,215.0005499141769,0.12221999782282821,13.295924426445962,199.99973375126052,0.11595343531099363,6.7129894279417957E-3,4.4642691610721763E-4,-0.73310724839728714,-5.1387864866178745E-2,0.68171938353110839,null,"plateau min (T)",36,34,34]
[7.2999999999999995E-2,1.3735081638998343,12.130171614617032,200.00000127798,0.11323072809990067,11.446534310472691,215.00033727342276,0.11999336451061707,12.098950634300435,199.99984145068964,0.11352291660782125,6.7626364107163939E-3,2.9218850792057938E-4,-0.68363730414434087,-3.1220980316597036E-2,0.65241632382774384,null,"plateau max (T)",52,50,50]
[8.1000000000000003E-2,1.2386112799255162,11.101161316397167,200.00000088646604,0.11157492848032065,10.464001928989843,215.00021047365334,0.11836879315685364,11.082979738306836,199.99990304508464,0.11175796664541596,6.793864676532993E-3,1.830381650953089E-4,-0.63715938740732447,-1.8181578090331385E-2,0.61897780931699309,null,"longueur manivelle (mm)",170,172.5,172.5]
[8.8999999999999996E-2,1.1280367282340229,10.224144826966779,200.00000060840304,0.11033066797516015,9.6295442223220746,215.00013419233306,0.1171433145941779,10.21448751100675,199.9999390625988,0.11043498041565891,6.8126466190177454E-3,1.0431244049875776E-4,-0.59460060464470388,-9.6573159600286118E-3,0.58494328868467527,null,"vitesse limite basse cadence (km/h)",{"$f":"(S11/S9)*PI()*0.7*(S23/60)*3.6","v":12.666901579274045},{"$f":"(T11/T9)*PI()*0.7*(S23/60)*3.6","v":12.817698026646353},{"$f":"(U11/U9)*PI()*0.7*(V23/60)*3.6","v":12.817698026646353}]
[9.7000000000000003E-2,1.0357664799963686,9.4703748357056217,200.0000004184152,0.10936911135674129,8.9142482266252987,215.00008753167225,0.11619224119233246,9.4663525344171919,199.99996066047203,0.10941558284783832,6.8231298355911629E-3,4.6471491097030415E-5,-0.55612660908032296,-4.0223012884297304E-3,0.55210430779189323,null,"vitesse limite haute cadence (km/h)",{"$f":"(S12/S10)*PI()*0.7*(S23/60)*3.6","v":49.899915312291697},{"$f":"(T12/T10)*PI()*0.7*(S23/60)*3.6","v":47.980687800280471},{"$f":"(U12/U10)*PI()*0.7*(V23/60)*3.6","v":47.980687800280471}]
[0.105,0.95761656129060857,8.81719242174748,200.00000029027626,0.10860787827751847,8.2956496480001061,215.00005840481683,0.11543599379482815,8.8169307172281446,199.99997395083915,0.10861110198126439,6.8281155173096769E-3,3.223703745919293E-6,-0.5215427737473739,-2.6170451933538175E-4,0.52128106922803852]
[0.113,0.89058783024123789,8.246787258160003,200.00085766523125,0.1079920946620785,7.7562456544498977,215.0000398271099,0.11482202471633833,8.2490171232396801,199.99998233857178,0.10796290235987201,6.8299300542598307E-3,-2.919230220649327E-5,-0.49054160371010536,2.2298650796770403E-3,0.4927714687897824]
[0.121,0.83247429711977938,7.7449759073295992,200.00072441690415,0.1074857181068765,7.282311668245077,215.00002772042637,0.11431456590217494,7.7489138679375271,199.99998776150434,0.10743109438398663,6.8288477952984372E-3,-5.4623722889876603E-5,-0.46266423908452214,3.9379606079279483E-3,0.46660219969245009,null,"Profil cycliste"]
[0.129,0.78161718581076389,7.3005788812673496,200.00061605278526,0.1070623574544651,6.8629974887829386,215.00001966530115,0.11388860145851129,7.3056640248681957,199.99999134766895,0.10698783617069844,6.8262440040461891E-3,-7.4521283766657009E-5,-0.43758139248441097,5.0851436008461093E-3,0.44266653608525708,null,"masse cycliste 1 (kg) - CANYON",63,null,"masse cycliste 2 (kg) - ROSE",74]
[0.13700000000000001,0.73674516353001507,6.9045999714463351,200.00052748126308,0.10670352613863103,6.4896484292679233,215.00001419933872,0.11352620585844662,6.9104472481965331,199.99999376956751,0.10661323892202325,6.8226797198155942E-3,-9.0287216607781717E-5,-0.41495154217841179,5.8472767501980272E-3,0.42079881892860982,null,"puissance (W)",200,null,"puissance (W)",215]
[0.14499999999999999,0.69686746002170219,6.5497697579697203,200.00045465225057,0.10639571859358232,6.1552980087320188,215.00001042116492,0.11321425202047297,6.5561119851314977,199.99999543732633,0.10629279390012203,6.8185334268906495E-3,-1.0292469346029343E-4,-0.39447174923770145,6.3422271617774584E-3,0.40081397639947891,null,"CdA (coeff trainée x aire frontale)",0.32500000000000001,null,"CdA (coeff trainée x aire frontale)",0.33]
[0.153,0.66120051799333934,6.230166015543718,200.00039438184047,0.10612887623599468,5.8542883136732922,215.0000077642313,0.11294293730785987,6.2368161545047691,199.99999660660498,0.1060157140459821,6.8140610718651906E-3,-1.131621900125751E-4,-0.3758777018704258,6.6501389610511552E-3,0.38252784083147695,null,"puissance (W/kg)",{"$f":"S20/S19","v":3.1746031746031744},null,"puissance (W/kg)",{"$f":"V20/V19","v":2.9054054054054053}]
[0.161,0.62911651174921746,5.9409252331702085,200.00034417711581,0.10589537606644935,5.5819844929094735,215.00000586560023,0.11270481180095608,5.9477514711771953,199.99999744011589,0.10577383987846772,6.8094357345067358E-3,-1.215361879816218E-4,-0.35894074026073497,6.8262380069867845E-3,0.36576697826772175,null,"cadence (tr/min)",80,null,"cadence (tr/min)",80]
[0.16900000000000001,0.60010648775511144,5.678022368176201,200.00030208545473,0.10568934900970944,5.3345585658321557,215.00000448849377,0.11249412305617809,5.6849314126963248,199.9999980434574,0.10556090200400235,6.8047740464686479E-3,-1.2844700570709133E-4,-0.34346380234404528,6.9090445201238637E-3,0.35037284686416914,null,"force sur pédale (N)",{"$f":"(S20*60)/(S13*10^-3*S23*2*PI())","v":140.43083213990764},null,"force sur pédale (N)",{"$f":"(V20*60)/(U13*10^-3*V23*2*PI())","v":148.77527289024999}]
[0.17699999999999999,0.57375350098629285,5.4381016518632324,200.00026657291806,0.10550621112235191,5.1088244258691082,215.00000347574533,0.11230636505749295,5.4450273729714187,199.99999848642571,0.10537201407551207,6.8001539351410373E-3,-1.3419704683984013E-4,-0.32927722599412412,6.9257211081863446E-3,0.33620294710231047]
[0.185,0.54971272130801163,5.2183456963116122,200.00023642909929,0.10534233515739577,4.9021108683214969,215.0000027213153,0.11213796180342929,5.2252413033544771,199.99999881594789,0.10520331777885732,6.7956266460335174E-3,-1.3901737853845575E-4,-0.31623482799011526,6.8956070428649596E-3,0.32313043503298022]
[0.193,0.52769648749539511,5.0163734777825786,200.00021069379795,0.10519481650091499,4.7121630572780591,215.00000215255264,0.1119860414593154,5.0232060647789041,199.99999906408235,0.10505173004855049,6.7912249584004131E-3,-1.4308645236449369E-4,-0.30421042050451952,6.8325869963254959E-3,0.31104300750084501,null,"Paramètres environmentaux"]
[0.20100000000000001,0.50746293044575153,4.8301602253773765,200.00018860088937,0.10506130371816058,4.5370654263891819,215.00000171895874,0.11184827256273783,4.8369069252576216,199.99999925305818,0.10491476025636429,6.7869688445772458E-3,-1.4654346179629463E-4,-0.29309479898819468,6.7466998802450107E-3,0.29984149886843969,null,"altitude (m) - influence densité air",100,null,"vitesse vent (km/h)",0,"positive vent de face ; négatif vent de dos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"température (C°)",20,null,"vitesse vent (m/s)",{"$f":"V28/3.6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"température (K°)",{"$f":"S29+273.15","v":293.14999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"distance vert. à gravir (m)",100]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constantes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"densité air niv. mer(kg/m^3)",1.2250000000000001,null,"coeff résis roulement",5.0000000000000001E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R constante gaz parfait",8.3144500000000008,null,"perte rendement",0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"masse molaire air (kg/mol)",2.8964400000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rho air (kg/m^3)",{"$f":"S35*EXP((-V38*S37*S28)/(S36*S30))","v":1.2108080798932019},null,"constante g (m/s²)",9.8059999999999992]

{"sheet":"puissance 2E %V","index":4,"n_rows":31,"n_cols":31,"rows_kept":31,"cut":false,"hidden":false,"merged":[[15,29,16,30],[22,28,23,28]]}
["pente - \nvitesse (km/h)",10,11.5,13,14.5,16,17.5,19,20.5,22,23.5,25,26.5,28,29.5,31,32.5,34,35.5,37,38.5,40,41.5,43,44.5,null,null,"Vélo"]
[0,{"$f":"_xludf.power($AE$20,$A2,$AB$8,$AB$2,$AB$5,$AB$22,$AB$12,$AB$21,B$1,$AE$19,$AC$3,$AB$3,$AB$4,$AB$7,$AE$15)","v":14.45},18.079999999999998,22.32,27.25,32.96,39.51,47,55.49,65.08,75.84,{"$f":"_xludf.power($AE$20,$A2,$AB$8,$AB$2,$AB$5,$AB$22,$AB$12,$AB$21,L$1,$AE$19,$AC$3,$AB$3,$AB$4,$AB$7,$AE$15)","v":87.84},101.18,115.93,132.16999999999999,149.97,169.43,190.61,213.6,238.48,265.33,294.23,325.26,358.49,394.01,null,"poids",9.85]
[7.0000000000000001E-3,29.16,35,41.45,48.59,56.5,65.260000000000005,74.95,85.65,97.45,110.41,124.63,140.16999999999999,157.12,175.57,195.58,217.24,240.63,265.83,292.92,321.98,353.08,386.31,421.75,459.48,null,"aero à 45km/h(W)",204,235]
[1.4E-2,43.87,51.91,60.57,69.91,80.03,91,102.9,115.81,129.81,144.97999999999999,161.4,179.15,198.31,218.96,241.18,265.05,290.64999999999998,318.05,347.35,378.61,411.92,447.36,485.01,524.94000000000005,null,"pénalité position(W)",0]
[2.1000000000000001E-2,58.58,68.83,79.69,91.24,103.56,116.73,130.84,145.94999999999999,162.16,179.54,198.16,218.12,239.49,262.33999999999997,286.77,312.83999999999997,340.64,370.26,401.76,435.22,470.74,508.39,548.24,590.38,null,"poids matériel",2]
[2.8000000000000001E-2,73.28,85.73,98.79,112.55,127.08,142.46,158.76,176.09,194.5,214.08,234.91,257.07,280.64,305.7,332.33,360.61,390.62,422.43,456.14,491.81,529.53,569.38,611.44000000000005,655.78,null,"taille de cadre","XS"]
[3.5000000000000003E-2,87.96,102.62,117.89,133.85,150.58000000000001,168.16,186.67,206.2,226.81,248.6,271.63,296,321.77,349.03,377.87,408.35,440.56,474.58,510.49,548.36,588.29,630.34,674.6,721.15,null,"gain taille cadre aero (W)",10]
[4.2000000000000003E-2,102.64,119.5,136.97,155.13,174.06,193.85,214.56,236.29,259.10000000000002,283.08999999999997,308.32,334.89,362.87,392.33,423.37,456.05,490.46,526.69000000000005,564.79999999999995,604.87,647,691.25,737.72,786.47,null,"masse cycliste (kg) - CANYON",63,null,"CdA exemple"]
[4.9000000000000002E-2,117.31,136.36000000000001,156.03,176.39,197.53,219.51,242.42,266.35000000000002,291.36,317.55,344.99,373.75,403.93,435.59,468.83,503.71,540.32000000000005,578.74,619.04999999999995,661.33,705.66,752.11,800.77,851.72,null,null,null,null,"Barres",0.40799999999999997]
[5.6000000000000001E-2,131.96,153.21,175.08,197.63,220.96,245.14,270.26,296.38,323.58999999999997,351.97,381.61,412.57,444.94,478.81,514.24,551.32000000000005,590.13,630.75,673.25,717.73,764.25,812.9,863.76,916.91,null,null,null,null,"Cocottes",0.32400000000000001]
[6.3E-2,146.59,170.04,194.1,218.85,244.37,270.75,298.05,326.37,355.78,386.36,418.18,451.34,485.91,521.97,559.59,598.87,639.87,682.69,727.39,774.06,822.78,873.62,926.67,982.02,null,"altitude (m) - influence densité air",100,null,"Ceintre",0.307]
[7.0000000000000007E-2,{"$f":"_xludf.power($AE$20,$A12,$AB$8,$AB$2,$AB$5,$AB$22,$AB$12,$AB$21,B$1,$AE$19,$AC$3,$AB$3,$AB$4,$AB$7,$AE$15)","v":161.19999999999999},186.84,213.09,240.04,267.75,296.32,325.82,356.32,387.92,420.69,{"$f":"_xludf.power($AE$20,$A12,$AB$8,$AB$2,$AB$5,$AB$22,$AB$12,$AB$21,L$1,$AE$19,$AC$3,$AB$3,$AB$4,$AB$7,$AE$15)","v":454.71},490.06,526.82000000000005,565.07000000000005,604.89,646.36,689.55,734.56,781.45,830.31,881.22,934.26,989.5,1047.04,null,"CdA (coeff trainée x aire frontale)",0.32,null,"Aerobars",0.29139999999999999]
[7.6999999999999999E-2,175.79,203.62,232.06,261.19,291.08999999999997,321.85000000000002,353.54,386.23,420.02,454.98,491.19,528.72,567.66999999999996,608.11,650.11,693.77,739.15,786.35,835.43,886.48,939.58,994.8,1052.24,1111.96]
[8.4000000000000005E-2,190.35,220.37,250.99,282.31,314.39999999999998,347.34,381.21,416.09,452.06,489.21,527.6,567.32000000000005,608.45000000000005,651.08000000000004,695.27,741.11,788.68,838.06,889.32,942.56,997.84,1055.25,1114.8699999999999,1176.77,null,null,null,null,"vitesse vent (km/h)",0]
[9.0999999999999998E-2,204.89,237.09,269.89,303.39,337.66,372.78,408.83,445.9,484.05,523.37,563.95000000000005,605.85,649.16,693.97,740.34,788.36,838.11,889.67,943.12,998.53,1056,1115.5899999999999,1177.3900000000001,1241.47,null,null,null,null,"vitesse vent (m/s)",{"$f":"AE14/3.6","v":0}]
[9.8000000000000004E-2,219.4,253.77,288.76,324.43,360.88,398.18,436.41,475.65,515.98,557.48,600.23,644.30999999999995,689.8,736.78,785.32,835.52,887.45,941.19,{"$f":"_xludf.power($AE$20,$A16,$AB$8,$AB$2,$AB$5,$AB$22,$AB$12,$AB$21,T$1,$AE$19,$AC$3,$AB$3,$AB$4,$AB$7,$AE$15)","v":996.81},1054.4000000000001,1114.04,1175.81,1239.79,1306.05,null,null,null,null,"positive vent de face ; négatif vent de dos"]
[0.105,233.88,270.43,307.58,345.43,384.05,423.52,463.92,505.33,547.83000000000004,591.51,636.42999999999995,682.68,730.34,779.5,830.22,882.59,936.69,992.59,1050.3900000000001,1110.1500000000001,1171.97,1235.9100000000001,1302.06,1370.49,null,"densité air niv. mer(kg/m²)",1.2250000000000001]
[0.112,248.33,287.04000000000002,326.37,366.38,407.17,448.81,491.37,534.95000000000005,579.62,625.46,672.55,720.97,770.8,822.12,875.01,929.55,985.81,1043.8900000000001,1103.8499999999999,1165.78,1229.76,1295.8699999999999,1364.19,1434.79,null,"R constante gaz parfait",8.3144500000000008]
[0.11899999999999999,262.75,303.62,345.11,387.28,430.23,474.03,518.76,564.5,611.34,659.34,708.59,759.17,811.16,864.65,919.7,976.4,1034.83,1095.06,1157.19,1221.28,1287.43,1355.7,1426.17,1498.94,null,"température (C°)",20,{"$f":"AB19+273.15","v":293.14999999999998},"perte rendement",0.03]
[0.126,277.13,320.16000000000003,363.8,408.13,453.24,499.2,546.08000000000004,593.98,642.97,693.13,744.54,797.28,851.43,907.06,964.27,1023.13,1083.71,1146.1099999999999,1210.3900000000001,1276.6400000000001,1344.94,1415.37,1488,1562.93,null,"masse molaire air (kg/mol)",2.8964400000000001E-2,null,"constante g (m/s²)",9.8059999999999992]
[0.13300000000000001,291.47000000000003,336.65,382.44,428.93,476.19,524.29,573.33000000000004,623.38,674.52,726.83,780.39,835.28,891.58,949.37,1008.73,1069.74,1132.48,1197.02,1263.45,1331.86,1402.31,1474.89,1549.67,1626.75,null,"rho air",{"$f":"AB17*EXP((-AE20*AB20*AB11)/(AB18*AC19))","v":1.2108080798932019}]
[0.14000000000000001,{"$f":"_xludf.power($AE$20,$A22,$AB$8,$AB$2,$AB$5,$AB$22,$AB$12,$AB$21,B$1,$AE$19,$AC$3,$AB$3,$AB$4,$AB$7,$AE$15)","v":305.77},353.1,401.04,449.67,499.07,549.32000000000005,600.51,652.70000000000005,705.98,760.44,{"$f":"_xludf.power($AE$20,$A22,$AB$8,$AB$2,$AB$5,$AB$22,$AB$12,$AB$21,L$1,$AE$19,$AC$3,$AB$3,$AB$4,$AB$7,$AE$15)","v":816.15},873.18,931.63,991.56,1053.07,1116.22,1181.0999999999999,1247.79,1316.37,1386.92,1459.51,1534.24,1611.17,1690.39,null,"coeff résis roulement",5.0000000000000001E-3]
[0.14699999999999999,320.02999999999997,369.5,419.57,470.34,521.88,574.28,627.6,681.93,737.36,793.95,851.8,910.97,971.55,1033.6300000000001,1097.27,1162.56,1229.58,1298.4100000000001,1369.13,1441.82,1516.55,1593.42,1672.49,1753.84]
[0.154,334.25,385.85,438.06,490.96,544.63,599.15,654.61,711.08,768.63,827.36,887.34,948.64,1011.36,1075.57,1141.3399999999999,1208.77,1277.92,1348.88,1421.73,1496.55,1573.42,1652.41,1733.62,1817.11]
[0.161,348.42,402.14,456.48,511.51,567.29999999999995,623.95000000000005,681.53,740.13,799.81,860.66,922.76,986.2,1051.04,1117.3699999999999,1185.27,1254.82,1326.1,1399.19,1474.17,1551.11,1630.1,1711.22,1794.55,1880.17]
[0.16800000000000001,362.54,418.38,474.84,531.98,589.9,648.66999999999996,708.37,769.08,830.88,893.85,958.07,1023.62,1090.5899999999999,1159.04,1229.06,1300.72,1374.12,1449.33,1526.42,1605.49,1686.6,1769.84,1855.28,1943.02]
[0.17499999999999999,376.62,434.57,493.14,552.39,612.41999999999996,673.3,735.11,797.93,861.85,926.93,993.26,1060.92,1130,1200.56,1272.69,1346.47,1421.98,1499.29,1578.5,1659.68,1742.9,1828.25,1915.81,2005.65]
[0.182,390.64,450.7,511.37,572.73,634.86,697.84,761.76,826.68,892.7,959.89,1028.32,1098.0899999999999,1169.26,1241.93,1316.16,1392.05,1469.66,1549.08,1630.39,1713.67,1799,1886.45,1976.11,2068.06]
[0.189,404.61,466.77,529.53,592.99,657.22,722.3,788.31,855.33,923.44,992.72,1063.25,1135.1099999999999,1208.3900000000001,1283.1500000000001,1359.48,1437.46,1517.17,1598.68,1682.09,1767.46,1854.88,1944.43,2036.19,2130.2399999999998]
[0.19600000000000001,418.53,482.77,547.63,613.16999999999996,679.49,746.65,814.75,883.86,954.06,1025.43,1098.05,1172,1247.3599999999999,1324.21,1402.62,1482.69,1564.49,1648.09,1733.59,1821.05,1910.56,2002.19,2096.04,2192.17]
[0.20300000000000001,432.39,498.71,565.65,633.27,701.67,770.91,841.09,912.28,984.56,1058.01,1132.7,1208.73,1286.17,1365.1,1445.6,1527.75,1611.62,1697.3,1784.88,1874.42,1966.01,2059.7199999999998,2155.65,2253.86]

{"sheet":"vitesse en fonction du CdA","index":5,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[33,8,33,12],[0,8,0,12],[0,14,0,15],[1,14,1,15],[17,8,17,12],[26,8,26,12],[27,13,28,14]]}
["CdA","puissance","vitesse",null,null,null,null,null,"Profil vélo",null,null,null,null,null,"Info"]
[0.28999999999999998,{"$f":"(($M$38*COS(ATAN($G$3))*($J$19+$J$3+$J$8)*$M$35+$M$38*SIN(ATAN($G$3))*($J$19+$J$3+$J$8)+0.5*A2*$J$38*((C2/3.6)+$M$29)^2)*(C2/3.6))/(1-$M$36)-((($K$4-$J$4)*(C2/3.6)^3)/(45/3.6)^3)+$J$5-(($J$7)*(C2/3.6)^3)/((45/3.6)^3)","v":200.00004539190576},36.219689779660897,null,null,null,null,null,null,"Aeroad CF SLX","Ultimate CF SLX","Rose Six",null,null,"CdA exemple"]
[0.29499999999999998,{"$f":"(($M$38*COS(ATAN($G$3))*($J$19+$J$3+$J$8)*$M$35+$M$38*SIN(ATAN($G$3))*($J$19+$J$3+$J$8)+0.5*A3*$J$38*((C3/3.6)+$M$29)^2)*(C3/3.6))/(1-$M$36)-((($K$4-$J$4)*(C3/3.6)^3)/(45/3.6)^3)+$J$5-(($J$7)*(C3/3.6)^3)/((45/3.6)^3)","v":200.00004526170903},36.003507688511604,null,null,"pente",0,null,"poids vélo et matériel",7.85,7,7.4,null,null,"Barres",0.40799999999999997]
[0.3,200.00004513302855,35.792569239163058,null,null,null,null,null,"aero à 45km/h(W)",204,235,225,null,null,"Cocottes",0.32400000000000001]
[0.30499999999999999,200.00004500585047,35.586653707269065,null,null,null,null,null,"pénalité position(W)",0,3,0,"manuel",null,"Ceintre",0.307]
[0.31,200.00004488015844,35.385553469000818,null,null,null,null,null,"taille de cadre","XS","M","M","à titre indicatif",null,"Aerobars",0.29139999999999999]
[0.315,200.00004475593551,35.189073005010371,null,null,null,null,null,"gain taille cadre aero 45km/h (W)",10,0,0,"5W/taille cadre"]
[0.32,200.00004463316347,34.997027996174118,null,null,null,null,null,"poids matériel (kg)",2,2,2]
[0.32500000000000001,200.00004451182343,34.809244501229969,null,null,null,null,null,"cassette max (T)",30,28,28]
[0.33,200.00004439189576,34.625558207635329,null,null,null,null,null,"cassette min (T)",11,11,11]
[0.33500000000000002,200.00004427336029,34.445813748020448,null,null,null,null,null,"plateau min (T)",36,34,34]
[0.34,200.00004415619674,34.269864075517091,null,null,null,null,null,"plateau max (T)",52,50,50]
[0.34499999999999997,200.00004404038407,34.097569892028027,null,null,null,null,null,"longueur manivelle (mm)",170,172.5,172.5]
[0.35,200.00004392590145,33.928799124185232,null,null,null,null,null,"vitesse limite basse cadence (km/h)",{"$f":"(J11/J9)*PI()*0.7*(J23/60)*3.6","v":12.666901579274045},{"$f":"(K11/K9)*PI()*0.7*(J23/60)*3.6","v":12.817698026646353},{"$f":"(L11/L9)*PI()*0.7*(M23/60)*3.6","v":12.817698026646353}]
[0.35499999999999998,200.00004381272825,33.763426442339401,null,null,null,null,null,"vitesse limite haute cadence (km/h)",{"$f":"(J12/J10)*PI()*0.7*(J23/60)*3.6","v":49.899915312291697},{"$f":"(K12/K10)*PI()*0.7*(J23/60)*3.6","v":47.980687800280471},{"$f":"(L12/L10)*PI()*0.7*(M23/60)*3.6","v":47.980687800280471}]
[0.36,200.00004370084301,33.601332818442451]
[0.36499999999999999,200.00004359022506,33.442405119139551]
[0.37,200.00004348085358,33.286535730784934,null,null,null,null,null,"Profil cycliste"]
[0.375,200.00004337270747,33.133622213446685,null,null,null,null,null,"masse cycliste 1 (kg) - CANYON",63,null,"masse cycliste 2 (kg) - ROSE",74]
[0.38,200.00004326576681,32.98356698127354,null,null,null,null,null,"puissance (W)",200,null,"puissance (W)",215]
[0.38500000000000001,200.00004316001073,32.836277006868791,null,null,null,null,null,"CdA (coeff trainée x aire frontale)",0.32500000000000001,null,"CdA (coeff trainée x aire frontale)",0.33]
[0.39,200.0000430554195,32.691663547557191,null,null,null,null,null,"puissance (W/kg)",{"$f":"J20/J19","v":3.1746031746031744},null,"puissance (W/kg)",{"$f":"M20/M19","v":2.9054054054054053}]
[0.39500000000000002,200.00004295197297,32.549641891643027,null,null,null,null,null,"cadence (tr/min)",80,null,"cadence (tr/min)",80]
[0.4,200.00004284965189,32.410131122946957,null,null,null,null,null,"force sur pédale (N)",{"$f":"(J20*60)/(J13*10^-3*J23*2*PI())","v":140.43083213990764},null,"force sur pédale (N)",{"$f":"(M20*60)/(L13*10^-3*M23*2*PI())","v":148.77527289024999}]
[0.40500000000000003,200.00004274843658,32.273053902076597]
[0.41,200.00004264830835,32.138336263035455]
[null,null,null,null,null,null,null,null,"Paramètres environmentaux"]
[null,null,null,null,null,null,null,null,"altitude (m) - influence densité air",100,null,"vitesse vent (km/h)",0,"positive vent de face ; négatif vent de dos"]
[null,null,null,null,null,null,null,null,"température (C°)",20,null,"vitesse vent (m/s)",{"$f":"M28/3.6","v":0}]
[null,null,null,null,null,null,null,null,"température (K°)",{"$f":"J29+273.15","v":293.14999999999998}]
[null,null,null,null,null,null,null,null,"distance vert. à gravir (m)",100]
[]
[]
[null,null,null,null,null,null,null,null,"Constantes"]
[null,null,null,null,null,null,null,null,"densité air niv. mer(kg/m^3)",1.2250000000000001,null,"coeff résis roulement",5.0000000000000001E-3]
[null,null,null,null,null,null,null,null,"R constante gaz parfait",8.3144500000000008,null,"perte rendement",0.03]
[null,null,null,null,null,null,null,null,"masse molaire air (kg/mol)",2.8964400000000001E-2]
[null,null,null,null,null,null,null,null,"rho air (kg/m^3)",{"$f":"J35*EXP((-M38*J37*J28)/(J36*J30))","v":1.2108080798932019},null,"constante g (m/s²)",9.8059999999999992]