{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Liste des variables","Paramètres d'entrée","Calculs","Temp. moyennes mensuelles","Module réversible"],"not_rendered":{"charts":5,"images":2,"macros":1,"external_links":0,"defined_names":52,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Temp. moyennes mensuelles","index":3,"reason":"not_a_worksheet"},{"sheet":"Module réversible","index":4,"reason":"not_a_worksheet"}],"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":"Liste des variables","index":0,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[12,1,12,3],[13,1,13,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[14,1,14,3],[15,1,15,3]]}
["Liste des variables"]
[]
["Paramètre","Description",null,null,"Unités"]
["K1 fondation","Paramètre de la loi K-Theta",null,null,"Mpa"]
["K2 fondation","Paramètre de la loi K-Theta",null,null,"-"]
["Mr","Module réversible",null,null,"MPa"]
["ϕ fondation","Angle de friction interne de la fondation vierge",null,null,"°"]
["ρs fondation","Masse volumique des grains solides de la fondation vierge",null,null,"kg/m3"]
["ρd fondation","Masse volumique sèche de la fondation vierge",null,null,"kg/m3"]
["wopt fondation","Teneur en eau optimale de la fondation vierge",null,null,"%"]
["efondation","Indice des vides de la fondation vierge",null,null,"-"]
["Sropt fondation","Degré de saturation à l'optimum de la fondation vierge",null,null,"%"]
["ϕ retraitement","Angle de friction interne de la fondation retraitée",null,null,"°"]
["ρs retraitement","Masse volumique des grains solides de la fondation retraitée",null,null,"kg/m3"]
["ρd retraitement","Masse volumique sèche de la fondation retraitée",null,null,"kg/m3"]
["wopt retraitement","Teneur en eau optimale de la fondation retraitée",null,null,"%"]
["eretraitement","Indice des vides de la fondation retraitée",null,null,"-"]
["Sropt retraitement","Degré de saturation à l'optimum de la fondation retraitée",null,null,"%"]
["GBR","Granulats bitumineux recyclés",null,null,"-"]

{"sheet":"Paramètres d'entrée","index":1,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[13,13,13,14],[13,10,13,11],[8,10,8,14],[11,13,12,13],[11,14,12,14],[24,5,25,14],[2,0,2,3],[2,10,2,14],[8,0,8,3],[8,5,8,8],[9,11,10,11],[9,12,10,12],[20,10,20,11],[20,13,20,14],[2,5,2,8],[21,6,21,8],[21,10,22,11],[21,12,22,12],[21,13,22,14],[16,13,16,14],[16,10,16,11]]}
["i3CRenforcement - Calcul du renforcement de la couche d'enrobé pour un retraitement en place",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode d'emploi"]
[]
["Enrobé bitumineux",null,null,null,null,"Charge",null,null,null,null,"%GBR retraitement"]
["Épaisseur",null,120,"mm",null,"Vitesse",null,100,"km/h",null,"Sensibilité à l'orniérage comparable à :",null,null,0,"%GBR"]
["Classe PG",null,"58-28",null,null,"Poids",null,50,"kN",null,"Teneur en GBR dans fondation retraitée :",null,null,30,"%GBR"]
["Module dynamique",null,{"$f":"Calculs!H3","v":2544.2647106123968},"MPa",null,"Rayon",null,150,"mm"]
["Coefficient Poisson",null,{"$f":"Calculs!J3","v":0.34356411970138345}]
[]
["Fondation vierge - Fondation retraitée",null,null,null,null,"Températures mensuelles",null,null,null,null,"Calcul renforcement - Structure équivalente pour la sensibilité à l'orniérage"]
["Épaisseur",null,250,"mm",null,"Janvier",null,-12,"°C",null,"Renforcement",{"$f":"Calculs!$D$12","v":32.860110813327374},"mm"]
["K1 fondation",null,15,null,null,"Février",null,-10.1,"°C",null,"d'asphalte ="]
["K2 fondation",null,0.7,null,null,"Mars",null,-4.0999999999999996,"°C",null,null,null,null,{"$f":"$C$4+$L$10","v":152.86011081332737},"mm"]
["ϕ fondation",null,45,"°",null,"Avril",null,3.8,"°C",null,{"$f":"$C$4","v":120},"mm"]
["ρs fondation",null,2650,"kg/m3",null,"Mai",null,11.4,"°C",null,"Enrobé bitumineux",null,null,"Enrobé bitumineux"]
["ρd fondation",null,2200,"kg/m3",null,"Juin",null,16.5,"°C"]
["wopt fondation",null,6,"%",null,"Juillet",null,19.600000000000001,"°C",null,{"$f":"$C$10","v":250},"mm",null,{"$f":"$C$10","v":250},"mm"]
["efondation",null,{"$f":"C14/C15-1","v":0.20454545454545459},null,null,"Août ",null,18.2,"°C",null,"Fondation référence",null,null,"Fondation retraitée"]
["Sropt fondation",null,{"$f":"C16*C14/C17/1000","v":77.73333333333332},"%",null,"Septembre",null,12.8,"°C",null,{"$f":"$N$4","v":0},"%GBR",null,{"$f":"$N$5","v":30},"%GBR"]
["ϕ retraitement",null,40,"°",null,"Octobre",null,6.4,"°C",null,"Mr (MPa)=",{"$f":"Calculs!$K$12","v":646.26280514234418},null,"Mr (MPa)=",{"$f":"Calculs!$K$30","v":478.23656482909701}]
["ρs retraitement",null,2500,"kg/m3",null,"Novembre",null,-0.4,"°C"]
["ρd retraitement",null,2080,"kg/m3",null,"Décembre",null,-8.9,"°C",null,"Référence",null,null,"Structure renforcée"]
["wopt retraitement",null,4,"%",null,"Méthode","Moyenne+2xET",null,null,null,"Coûts du renforcement",null,{"$f":"3.6*1*($L$10/1000)*2450*60/1000","v":17.389570642412849},"$ / voie / m linéaire"]
["eretraitement",null,{"$f":"C20/C21-1","v":0.20192307692307687},null,null,"Température de calcul",null,{"$f":"Calculs!AD18","v":27.341741211558997},"°C"]
["Sropt retraitement",null,{"$f":"C22*C20/1000/C23","v":49.52380952380954},"%"]
[null,null,null,null,null,{"$f":"IF(Calculs!L33<Calculs!Q35,Calculs!S35,Calculs!S36)","v":"Convergence des calculs satisfaisante"}]

{"sheet":"Calculs","index":2,"n_rows":54,"n_cols":48,"rows_kept":54,"cut":false,"hidden":true,"merged":[[31,44,31,48]]}
["Température au 1/3 de l'épaisseur de l'enrobé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur de référence pour taux de déformation permanente",null,null,null,null,null,null,null,"A","Moy. annuelle des temp. mensuelles"]
[null,"Ta (celsius)","Ta (farenheit)","Tp (farenheit)","Tp (celsius)","Log at","Log fr","Mod. Dyn. (Mpa)","Mod. Dyn. (psi)","Coef. Poisson","heq EB en F",null,null,null,null,null,null,null,"%GBR",{"$f":"'Paramètres d''entrée'!$N$4","v":0},null,null,null,null,null,null,"B","Moy. des temp. mensuelles > 0°C"]
[null,{"$f":"'Paramètres d''entrée'!$H$23","v":27.341741211558997},{"$f":"9*B3/5+32","v":81.215134180806189},{"$f":"C3*(1+1/(('Paramètres d''entrée'!$C$4/3/25.4)+4))+6-(34/(('Paramètres d''entrée'!$C$4/3/25.4)+4))","v":95.68451559459487},{"$f":"(D3-32)*5/9","v":35.380286441441598},{"$f":"$X$18*(E3-10)+$Y$18*(E3-10)^2","v":-3.3655360046319407},{"$f":"LOG($U$20)+F3","v":-1.3055360046319406},{"$f":"10^($T$18+$U$18/(1+EXP($V$18+$W$18*G3)))","v":2544.2647106123968},{"$f":"H3*145.04","v":369020.153627222},{"$f":"0.15+0.35/(1+EXP(-1.63+0.00000384*I3))","v":0.34356411970138345},{"$f":"$C$40*'Paramètres d''entrée'!$C$4*((Calculs!$H$3/(AVERAGE(K6:K10))*(1-0.35^2)/(1-Calculs!$J$3^2))^0.333333333333333)","v":189.16077986984709},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Moyenne+1xET",null,"A","B",null,null,null,null,"C",null,"D","D5","D6","D7","D8","D9","D5T","D6T","D7T","D8T","D9T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur de %GBR à utiliser",null,null,null,null,null,null,null,"D","Moyenne+2xET",{"$f":"'Paramètres d''entrée'!F10","v":"Janvier"},{"$f":"'Paramètres d''entrée'!H10","v":-12},{"$f":"IF(AD4>0,AD4,\"\")","v":""},null,null,null,null,0.01,{"$f":"AJ4*AD4","v":-0.12},{"$f":"IF(AD4>0,AD4,\"\")","v":""},0.1,7.4999999999999997E-2,0.05,2.5000000000000001E-2,0.01]
["a2+z2","Prof ds F ret.","sig1 stat","sig3 stat","sig1 ch","sig3 ch","theta","sigma d",null,"Mr calc","Mr entrée","Résidus",null,"B_ref","sig d cible","delt sigma d","delta sigma d (%)",null,"%GBR",{"$f":"'Paramètres d''entrée'!$N$5","v":30},null,null,null,null,null,null,null,"Moy. des temp. mensuelles > 0°C + 1xET",{"$f":"'Paramètres d''entrée'!F11","v":"Février"},{"$f":"'Paramètres d''entrée'!H11","v":-10.1},"",null,null,null,null,0.01,-0.10099999999999999,"",0.22500000000000001,0.17499999999999999,0.125,0.1,7.0000000000000007E-2]
[{"$f":"('Paramètres d''entrée'!$H$6^2+(Calculs!$K$3+Calculs!B6)^2)","v":68364.839634461096},{"$f":"'Paramètres d''entrée'!$C$10/5/2","v":25},{"$f":"('Paramètres d''entrée'!$C$4*Calculs!$C$31/1000)+Calculs!$C$32*Calculs!B6/1000","v":3.4560630000000003},{"$f":"$C$33*C6","v":1.0122574164920772},{"$f":"$B$42*(1-((B6+$K$3)^3)/('Paramètres d''entrée'!$H$6^2+(B6+$K$3)^2)^1.5)","v":318.66094761227043},{"$f":"$B$42*(1.7-2.7*(B6+$K$3)/((A6)^0.5)+(($K$3+B6)^3)/(A6)^1.5)","v":26.880819478786638},{"$f":"(C6+E6)+2*(D6+F6)","v":377.90316440282783},{"$f":"(C6+E6)-(D6+F6)","v":294.22393371699167},null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G6^'Paramètres d''entrée'!$C$12","v":955.55926787413364},955.55596326796785,{"$f":"(J6-K6)^2","v":1.0920421910939E-5},null,{"$f":"IF($T$2<50,((0.00002401*H6-0.00100005)*($T$2+56.62312001)+0.05112763),((0.00004345*H6+0.00017833)*($T$2+5.40679463)-0.05625673))","v":0.39450532821320233},{"$f":"IF($T$5<50,((((N6-0.05112763)/($T$5+56.62312001))+0.00100005)/(0.00002401)),(((N6+0.05625673)/($T$5+5.40679463))-0.00017833)/(0.00004345))","v":206.7510263329622},{"$f":"H6-O6","v":87.472907384029469},{"$f":"100*(H6-O6)/H6","v":29.73004482638995},null,null,null,null,null,null,null,null,null,null,"Moy. des temp. mensuelles > 0°C + 2xET",{"$f":"'Paramètres d''entrée'!F12","v":"Mars"},{"$f":"'Paramètres d''entrée'!H12","v":-4.0999999999999996},"",null,null,null,null,0.05,-0.20499999999999999,"",0.35,0.25,0.2,0.16,0.13]
[{"$f":"('Paramètres d''entrée'!$H$6^2+(Calculs!$K$3+Calculs!B7)^2)","v":92280.917621445813},{"$f":"B6+'Paramètres d''entrée'!$C$10/5","v":75},{"$f":"('Paramètres d''entrée'!$C$4*Calculs!$C$31/1000)+Calculs!$C$32*Calculs!B7/1000","v":4.5999090000000002},{"$f":"$C$33*C7","v":1.3472821532589698},{"$f":"$B$42*(1-((B7+$K$3)^3)/('Paramètres d''entrée'!$H$6^2+(B7+$K$3)^2)^1.5)","v":242.22485328953391},{"$f":"$B$42*(1.7-2.7*(B7+$K$3)/((A7)^0.5)+(($K$3+B7)^3)/(A7)^1.5)","v":6.8481258969437828},{"$f":"(C7+E7)+2*(D7+F7)","v":263.21557838993942},{"$f":"(C7+E7)-(D7+F7)","v":238.62935423933115},null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G7^'Paramètres d''entrée'!$C$12","v":741.83850511088997},741.83138724954517,{"$f":"(J7-K7)^2","v":5.0663950123734408E-5},null,{"$f":"IF($T$2<50,((0.00002401*H7-0.00100005)*($T$2+56.62312001)+0.05112763),((0.00004345*H7+0.00017833)*($T$2+5.40679463)-0.05625673))","v":0.3189233237316883},{"$f":"IF($T$5<50,((((N7-0.05112763)/($T$5+56.62312001))+0.00100005)/(0.00002401)),(((N7+0.05625673)/($T$5+5.40679463))-0.00017833)/(0.00004345))","v":170.41039873486079},{"$f":"H7-O7","v":68.218955504470358},{"$f":"100*(H7-O7)/H7","v":28.587830580160215},null,"Enrobé bitumineux",null,null,null,null,null,null,null,null,"Température maximale",{"$f":"'Paramètres d''entrée'!F13","v":"Avril"},{"$f":"'Paramètres d''entrée'!H13","v":3.8},3.8,null,null,null,null,0.08,0.30399999999999999,3.8,0.22500000000000001,0.25,0.25,0.215,0.18]
[{"$f":"('Paramètres d''entrée'!$H$6^2+(Calculs!$K$3+Calculs!B8)^2)","v":121196.99560843052},{"$f":"B7+'Paramètres d''entrée'!$C$10/5","v":125},{"$f":"('Paramètres d''entrée'!$C$4*Calculs!$C$31/1000)+Calculs!$C$32*Calculs!B8/1000","v":5.7437550000000002},{"$f":"$C$33*C8","v":1.6823068900258622},{"$f":"$B$42*(1-((B8+$K$3)^3)/('Paramètres d''entrée'!$H$6^2+(B8+$K$3)^2)^1.5)","v":187.53201520779643},{"$f":"$B$42*(1.7-2.7*(B8+$K$3)/((A8)^0.5)+(($K$3+B8)^3)/(A8)^1.5)","v":-1.1573370784731731},194.32570983090181,192.75080039624373,null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G8^'Paramètres d''entrée'!$C$12","v":599.87732059841915},599.88485667099258,5.6792389832002651E-5,null,{"$f":"IF($T$2<50,((0.00002401*H8-0.00100005)*($T$2+56.62312001)+0.05112763),((0.00004345*H8+0.00017833)*($T$2+5.40679463)-0.05625673))","v":0.25655046121966968},{"$f":"IF($T$5<50,((((N8-0.05112763)/($T$5+56.62312001))+0.00100005)/(0.00002401)),(((N8+0.05625673)/($T$5+5.40679463))-0.00017833)/(0.00004345))","v":140.42086638088315},52.329934015360578,27.149009969237131,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Paramètres d''entrée'!F14","v":"Mai"},{"$f":"'Paramètres d''entrée'!H14","v":11.4},11.4,null,null,null,null,0.11,1.254,11.4,0.1,0.17499999999999999,0.2,0.215,0.22]
[{"$f":"('Paramètres d''entrée'!$H$6^2+(Calculs!$K$3+Calculs!B9)^2)","v":155113.07359541522},{"$f":"B8+'Paramètres d''entrée'!$C$10/5","v":175},{"$f":"('Paramètres d''entrée'!$C$4*Calculs!$C$31/1000)+Calculs!$C$32*Calculs!B9/1000","v":6.887601000000001},{"$f":"$C$33*C9","v":2.017331626792755},{"$f":"$B$42*(1-((B9+$K$3)^3)/('Paramètres d''entrée'!$H$6^2+(B9+$K$3)^2)^1.5)","v":148.18445739490096},{"$f":"$B$42*(1.7-2.7*(B9+$K$3)/((A9)^0.5)+(($K$3+B9)^3)/(A9)^1.5)","v":-4.2423799604866934},150.62196172751308,157.29710672859488,null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G9^'Paramètres d''entrée'!$C$12","v":501.89523071680804},501.90237548064664,5.1047650309311779E-5,null,{"$f":"IF($T$2<50,((0.00002401*H9-0.00100005)*($T$2+56.62312001)+0.05112763),((0.00004345*H9+0.00017833)*($T$2+5.40679463)-0.05625673))","v":0.20835041619997086},{"$f":"IF($T$5<50,((((N9-0.05112763)/($T$5+56.62312001))+0.00100005)/(0.00002401)),(((N9+0.05625673)/($T$5+5.40679463))-0.00017833)/(0.00004345))","v":117.24577466045901},40.051332068135878,25.46221790159284,null,"PG","δ","α","β","γ","a1","a2",null,null,null,{"$f":"'Paramètres d''entrée'!F15","v":"Juin"},{"$f":"'Paramètres d''entrée'!H15","v":16.5},16.5,null,null,null,null,0.15,2.4750000000000001,16.5,null,7.4999999999999997E-2,0.125,0.16,0.18]
[{"$f":"('Paramètres d''entrée'!$H$6^2+(Calculs!$K$3+Calculs!B10)^2)","v":194029.15158239994},{"$f":"B9+'Paramètres d''entrée'!$C$10/5","v":225},{"$f":"('Paramètres d''entrée'!$C$4*Calculs!$C$31/1000)+Calculs!$C$32*Calculs!B10/1000","v":8.031447},{"$f":"$C$33*C10","v":2.3523563635596472},{"$f":"$B$42*(1-((B10+$K$3)^3)/('Paramètres d''entrée'!$H$6^2+(B10+$K$3)^2)^1.5)","v":119.40035975169145},{"$f":"$B$42*(1.7-2.7*(B10+$K$3)/((A10)^0.5)+(($K$3+B10)^3)/(A10)^1.5)","v":-5.2537465495148661},121.62902637978101,130.33319693764668,null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G10^'Paramètres d''entrée'!$C$12","v":432.13288818544908},432.13944304256916,4.2966151864654358E-5,null,{"$f":"IF($T$2<50,((0.00002401*H10-0.00100005)*($T$2+56.62312001)+0.05112763),((0.00004345*H10+0.00017833)*($T$2+5.40679463)-0.05625673))","v":0.17169241159221035},{"$f":"IF($T$5<50,((((N10-0.05112763)/($T$5+56.62312001))+0.00100005)/(0.00002401)),(((N10+0.05625673)/($T$5+5.40679463))-0.00017833)/(0.00004345))","v":99.620218113252903},30.712978824393772,23.564970050636688,null,"58-28",-0.42199999999999999,4.97,-1.76,-0.42199999999999999,-0.14899999999999999,6.4599999999999998E-4,null,null,null,{"$f":"'Paramètres d''entrée'!F16","v":"Juillet"},{"$f":"'Paramètres d''entrée'!H16","v":19.600000000000001},19.600000000000001,null,null,null,null,0.18,3.528,19.600000000000001,null,null,0.05,0.1,0.13]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"((SUM(L6:L10))/COUNT(L6:L10))^0.5","v":6.5175235180341649E-3},null,null,null,null,null,null,"58-34",0.215,4.29,-1.32,-0.39800000000000002,-0.14599999999999999,7.9500000000000003E-4,null,null,null,{"$f":"'Paramètres d''entrée'!F17","v":"Août "},{"$f":"'Paramètres d''entrée'!H17","v":18.2},18.2,null,null,null,null,0.17,3.0940000000000003,18.2,null,null,null,2.5000000000000001E-2,7.0000000000000007E-2]
[null,"Renforcement EB",null,32.860110813327374,null,null,null,null,null,null,{"$f":"AVERAGE(K6:K10)","v":646.26280514234418},null,null,null,null,null,null,null,"64-28",-7.1999999999999995E-2,4.63,-1.68,-0.32400000000000001,-0.151,6.8800000000000003E-4,null,null,null,{"$f":"'Paramètres d''entrée'!F18","v":"Septembre"},{"$f":"'Paramètres d''entrée'!H18","v":12.8},12.8,null,null,null,null,0.12,1.536,12.8,null,null,null,null,0.01]
[null,"Nouveau H_EB",null,{"$f":"$D$12+'Paramètres d''entrée'!$C$4","v":152.86011081332737},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"64-34",0.63600000000000001,3.9,-1.38,-0.36899999999999999,-0.14699999999999999,6.5600000000000001E-4,null,null,null,{"$f":"'Paramètres d''entrée'!F19","v":"Octobre"},{"$f":"'Paramètres d''entrée'!H19","v":6.4},6.4,null,null,null,null,0.06,0.38400000000000001,6.4]
[null,"Nv heq EB en F",null,{"$f":"$B$43*$D$13*((Calculs!$H$20/(AVERAGE(K24:K28))*(1-0.35^2)/(1-Calculs!$J$20^2))^0.333333333333333)","v":268.72258745283034},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70-28",-0.22,4.7699999999999996,-1.76,-0.28299999999999997,-0.158,5.9400000000000002E-4,null,null,null,{"$f":"'Paramètres d''entrée'!F20","v":"Novembre"},{"$f":"'Paramètres d''entrée'!H20","v":-0.4},"",null,null,null,null,0.04,-1.6E-2,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Paramètres d''entrée'!F21","v":"Décembre"},{"$f":"'Paramètres d''entrée'!H21","v":-8.9},"",null,null,null,null,0.02,-0.17800000000000002,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeurs selon classe PG choisie",null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AD4:AD15)","v":4.4333333333333327},{"$f":"AVERAGE(AE4:AE15)","v":12.671428571428573},{"$f":"AVERAGE(AD4:AD15)+STDEV(AD4:AD15)","v":15.887537272446163},{"$f":"AVERAGE(AD4:AD15)+2*(STDEV(AD4:AD15))","v":27.341741211558997},{"$f":"MAX(AD4:AD15)","v":19.600000000000001},null,{"$f":"SUM(AJ4:AJ15)","v":1.0000000000000002},{"$f":"SUM(AK4:AK15)","v":11.954999999999998},{"$f":"COUNT(AL4:AL15)","v":7},{"$f":"SUM(AM4:AM12)","v":1},1,{"$f":"SUM(AO4:AO12)","v":1},{"$f":"SUM(AP4:AP12)","v":1},{"$f":"SUM(AQ4:AQ12)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"δ","α","β","γ","a1","a2",null,null,null,null,null,null,{"$f":"AVERAGE(AE4:AE15)+STDEV(AE4:AE15)","v":18.628137474202063},{"$f":"AVERAGE(AE4:AE15)+2*(STDEV(AE4:AE15))","v":24.584846376975548}]
["Température au 1/3 de l'épaisseur de l'enrobé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Paramètres d''entrée'!C5","v":"58-28"},{"$f":"IF('Paramètres d''entrée'!$C$5=\"58-28\",Calculs!T10,IF('Paramètres d''entrée'!$C$5=\"58-34\",T11,IF('Paramètres d''entrée'!$C$5=\"64-28\",T12,IF('Paramètres d''entrée'!$C$5=\"64-34\",T13,IF('Paramètres d''entrée'!$C$5=\"70-28\",T14,\"\")))))","v":-0.42199999999999999},{"$f":"IF('Paramètres d''entrée'!$C$5=\"58-28\",Calculs!U10,IF('Paramètres d''entrée'!$C$5=\"58-34\",U11,IF('Paramètres d''entrée'!$C$5=\"64-28\",U12,IF('Paramètres d''entrée'!$C$5=\"64-34\",U13,IF('Paramètres d''entrée'!$C$5=\"70-28\",U14,\"\")))))","v":4.97},{"$f":"IF('Paramètres d''entrée'!$C$5=\"58-28\",Calculs!V10,IF('Paramètres d''entrée'!$C$5=\"58-34\",V11,IF('Paramètres d''entrée'!$C$5=\"64-28\",V12,IF('Paramètres d''entrée'!$C$5=\"64-34\",V13,IF('Paramètres d''entrée'!$C$5=\"70-28\",V14,\"\")))))","v":-1.76},{"$f":"IF('Paramètres d''entrée'!$C$5=\"58-28\",Calculs!W10,IF('Paramètres d''entrée'!$C$5=\"58-34\",W11,IF('Paramètres d''entrée'!$C$5=\"64-28\",W12,IF('Paramètres d''entrée'!$C$5=\"64-34\",W13,IF('Paramètres d''entrée'!$C$5=\"70-28\",W14,\"\")))))","v":-0.42199999999999999},{"$f":"IF('Paramètres d''entrée'!$C$5=\"58-28\",Calculs!X10,IF('Paramètres d''entrée'!$C$5=\"58-34\",X11,IF('Paramètres d''entrée'!$C$5=\"64-28\",X12,IF('Paramètres d''entrée'!$C$5=\"64-34\",X13,IF('Paramètres d''entrée'!$C$5=\"70-28\",X14,\"\")))))","v":-0.14899999999999999},{"$f":"IF('Paramètres d''entrée'!$C$5=\"58-28\",Calculs!Y10,IF('Paramètres d''entrée'!$C$5=\"58-34\",Y11,IF('Paramètres d''entrée'!$C$5=\"64-28\",Y12,IF('Paramètres d''entrée'!$C$5=\"64-34\",Y13,IF('Paramètres d''entrée'!$C$5=\"70-28\",Y14,\"\")))))","v":6.4599999999999998E-4},null,null,null,null,{"$f":"IF('Paramètres d''entrée'!G22=\"Moy. annuelle des temp. mensuelles\",$AD$16,IF('Paramètres d''entrée'!G22=\"Moy. des temp. mensuelles > 0°C\",Calculs!$AE$16,IF('Paramètres d''entrée'!G22=\"Moyenne+1xET\",$AF$16,IF('Paramètres d''entrée'!G22=\"Moyenne+2xET\",Calculs!$AG$16,IF('Paramètres d''entrée'!G22=\"Moy. des temp. mensuelles > 0°C + 1xET\",$AF$17,IF('Paramètres d''entrée'!G22=\"Moy. des temp. mensuelles > 0°C + 2xET\",$AG$17,IF('Paramètres d''entrée'!G22=\"Température maximale\",Calculs!$AH$16,)))))))","v":27.341741211558997}]
[null,"Ta (celsius)","Ta (farenheit)","Tp (farenheit)","Tp (celsius)","Log at","Log fr","Mod. Dyn. (Mpa)","Mod. Dyn. (psi)","Coef. Poisson","heq EB en F"]
[null,{"$f":"'Paramètres d''entrée'!$H$23","v":27.341741211558997},{"$f":"9*B20/5+32","v":81.215134180806189},{"$f":"C20*(1+1/(($D$13/3/25.4)+4))+6-(34/(($D$13/3/25.4)+4))","v":95.076411883561718},{"$f":"(D20-32)*5/9","v":35.042451046423174},{"$f":"$X$18*(E20-10)+$Y$18*(E20-10)^2","v":-3.3262028729665771},{"$f":"LOG($V$22)+F20","v":-1.2716795581021314},{"$f":"10^($T$18+$U$18/(1+EXP($V$18+$W$18*G20)))","v":2618.6909263293628},{"$f":"H20*145.04","v":379814.93195481075},{"$f":"0.15+0.35/(1+EXP(-1.63+0.00000384*I20))","v":0.33997050326456441},{"$f":"$C$40*'Paramètres d''entrée'!$C$4*((Calculs!$H$3/(AVERAGE(K23:K27))*(1-0.35^2)/(1-Calculs!$J$3^2))^0.333333333333333)","v":204.81097726952194},null,null,null,null,null,null,null,"Fréquence de l'enrobé",null,{"$f":"1/(10^(0.5*'Paramètres d''entrée'!C4/3/1000-0.2-0.94*LOG('Paramètres d''entrée'!H4)))","v":114.81536214968834}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fréquence de l'enrobé renforcé",null,null,{"$f":"1/(10^(0.5*$D$13/3/1000-0.2-0.94*LOG('Paramètres d''entrée'!$H$4)))","v":113.37657020703799},null,null,null,null,null,null,null,-12,null,null,null,null,{"$f":"AVERAGE(AD$4:AD$15)","v":4.4333333333333327},{"$f":"STDEV(AD$4:AD$15)","v":11.454203939112832},null,{"$f":"AI22+AJ22","v":15.887537272446163},{"$f":"AI22-AJ22","v":-7.020870605779499}]
["a2+z2","Prof ds F ret.","sig1 stat","sig3 stat","sig1 ch","sig3 ch","theta","sigma d",null,"Mr calc","Mr entrée","Résidus",null,"Résidus sigma d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-10.1,null,null,null,null,{"$f":"AVERAGE(AD$4:AD$15)","v":4.4333333333333327},{"$f":"STDEV(AD$4:AD$15)","v":11.454203939112832},null,{"$f":"AI23+AJ23","v":15.887537272446163},{"$f":"AI23-AJ23","v":-7.020870605779499}]
[{"$f":"('Paramètres d''entrée'!$H$6^2+($D$14+Calculs!B24)^2)","v":108772.95837998556},{"$f":"'Paramètres d''entrée'!$C$10/5/2","v":25},{"$f":"($D$13*Calculs!$C$31/1000)+Calculs!$C$36*Calculs!B24/1000","v":4.2044411333429172},{"$f":"$C$37*C24","v":1.5018784671736594},{"$f":"$B$42*(1-((B24+$D$14)^3)/('Paramètres d''entrée'!$H$6^2+(B24+$D$14)^2)^1.5)","v":207.70260245951837},{"$f":"$B$42*(1.7-2.7*(B24+$D$14)/((A24)^0.5)+(($D$14+B24)^3)/(A24)^1.5)","v":1.2587840759322591},{"$f":"(C24+E24)+2*(D24+F24)","v":217.42836867907315},{"$f":"(C24+E24)-(D24+F24)","v":209.14638104975538},null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G24^'Paramètres d''entrée'!$C$12","v":648.95204340599275},648.94747391924921,{"$f":"(J24-K24)^2","v":2.08802090994666E-5},null,{"$f":"(H24-O6)^2","v":5.7377242192633302},null,300,400,null,null,null,null,null,null,null,null,null,null,null,null,-4.0999999999999996,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499]
[{"$f":"('Paramètres d''entrée'!$H$6^2+($D$14+Calculs!B25)^2)","v":140645.21712526859},{"$f":"B24+'Paramètres d''entrée'!$C$10/5","v":75},{"$f":"($D$13*Calculs!$C$31/1000)+Calculs!$C$36*Calculs!B25/1000","v":5.2654907333429168},{"$f":"$C$37*C25","v":1.8808985310308006},{"$f":"$B$42*(1-((B25+$D$14)^3)/('Paramètres d''entrée'!$H$6^2+(B25+$D$14)^2)^1.5)","v":162.75938820943517},{"$f":"$B$42*(1.7-2.7*(B25+$D$14)/((A25)^0.5)+(($D$14+B25)^3)/(A25)^1.5)","v":-3.3390116847895359},{"$f":"(C25+E25)+2*(D25+F25)","v":165.10865263526063},{"$f":"(C25+E25)-(D25+F25)","v":169.48299209653683},null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G25^'Paramètres d''entrée'!$C$12","v":535.21729949077076},535.21897617031561,{"$f":"(J25-K25)^2","v":2.8112542961435758E-6},null,{"$f":"(H25-O7)^2","v":0.86008307280734564},null,300,400,null,null,null,null,null,null,null,null,null,null,null,null,3.8,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499]
[{"$f":"('Paramètres d''entrée'!$H$6^2+($D$14+Calculs!B26)^2)","v":177517.47587055163},{"$f":"B25+'Paramètres d''entrée'!$C$10/5","v":125},{"$f":"($D$13*Calculs!$C$31/1000)+Calculs!$C$36*Calculs!B26/1000","v":6.3265403333429173},2.2599185948879423,{"$f":"$B$42*(1-((B26+$D$14)^3)/('Paramètres d''entrée'!$H$6^2+(B26+$D$14)^2)^1.5)","v":130.12790800645388},{"$f":"$B$42*(1.7-2.7*(B26+$D$14)/((A26)^0.5)+(($D$14+B26)^3)/(A26)^1.5)","v":-4.9929499365418302},130.98838565648902,139.18747968145067,null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G26^'Paramètres d''entrée'!$C$12","v":455.14964874397742},455.15227481471271,6.8962475067411872E-6,null,{"$f":"(H26-O8)^2","v":1.5212427503369628},null,300,400,null,null,"Module réversible moyen - Référence = ",null,null,null,{"$f":"K12","v":646.26280514234418},"MPa",null,null,null,null,11.4,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499,null,null,null,null,null,null,"poisson",0.35]
[{"$f":"('Paramètres d''entrée'!$H$6^2+($D$14+Calculs!B27)^2)","v":219389.73461583466},{"$f":"B26+'Paramètres d''entrée'!$C$10/5","v":175},{"$f":"($D$13*Calculs!$C$31/1000)+Calculs!$C$36*Calculs!B27/1000","v":7.3875899333429178},2.6389386587450838,{"$f":"$B$42*(1-((B27+$D$14)^3)/('Paramètres d''entrée'!$H$6^2+(B27+$D$14)^2)^1.5)","v":105.97697955386231},{"$f":"$B$42*(1.7-2.7*(B27+$D$14)/((A27)^0.5)+(($D$14+B27)^3)/(A27)^1.5)","v":-5.3934156771306956},107.855615450434,116.11904650559084,null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G27^'Paramètres d''entrée'!$C$12","v":397.26581196907193},397.26725972372708,2.0959935414972821E-6,null,{"$f":"(H27-O9)^2","v":1.2695163349726104},null,300,400,null,null,"Module réversible moyen - Retraitée = ",null,null,null,{"$f":"K30","v":478.23656482909701},"MPa",null,null,null,null,16.5,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499,null,null,null,null,null,null,"a",{"$f":"'Paramètres d''entrée'!H6","v":150}]
[{"$f":"('Paramètres d''entrée'!$H$6^2+($D$14+Calculs!B28)^2)","v":266261.99336111767},{"$f":"B27+'Paramètres d''entrée'!$C$10/5","v":225},{"$f":"($D$13*Calculs!$C$31/1000)+Calculs!$C$36*Calculs!B28/1000","v":8.4486395333429165},3.0179587226022249,{"$f":"$B$42*(1-((B28+$D$14)^3)/('Paramètres d''entrée'!$H$6^2+(B28+$D$14)^2)^1.5)","v":87.739002683988659},{"$f":"$B$42*(1.7-2.7*(B28+$D$14)/((A28)^0.5)+(($D$14+B28)^3)/(A28)^1.5)","v":-5.2635444987427},91.696470665050626,98.433227993472045,null,{"$f":"'Paramètres d''entrée'!$C$11*Calculs!G28^'Paramètres d''entrée'!$C$12","v":354.59947907140878},354.59683951748053,6.9672449401270777E-6,null,{"$f":"(H28-O10)^2","v":1.4089455444573775},null,300,400,null,null,null,null,null,null,null,null,null,null,null,null,19.600000000000001,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"((SUM(L24:L28))/COUNT(L24:L28))^0.5","v":2.8160592814774239E-3},null,{"$f":"((SUM(N24:N28))/COUNT(N24:N28))^0.5","v":1.4695245436424413},null,null,null,null,null,"Température annuelle moyenne (TAM) =",null,null,{"$f":"AD16","v":4.4333333333333327},"°C",null,null,null,null,null,18.2,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499]
["Fondation",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(K24:K28)","v":478.23656482909701},null,null,null,null,null,null,null,null,"TAM+1xET =",null,null,{"$f":"AL22","v":15.887537272446163},"°C",null,null,null,null,null,12.8,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499]
["Poids volumique enrobé",null,24.034500000000001,"kN/m3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAM-1xET =",null,null,{"$f":"AM22","v":-7.020870605779499},"°C",null,null,null,null,null,6.4,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499]
["Poids volumique hum MG",null,{"$f":"('Paramètres d''entrée'!$C$15*(1+'Paramètres d''entrée'!$C$16/100))*9.81/1000","v":22.876920000000002},"kN/m3",null,null,null,null,null,null,null,"Somme résidus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.4,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499,null,null,null,null,null,"Contrainte cyclique horizontale"]
["1-sin(phi)",null,{"$f":"1-SIN('Paramètres d''entrée'!$C$13*2*PI()/360)","v":0.29289321881345254},null,null,null,null,null,null,null,null,{"$f":"L11+L29+N29","v":1.4788581264419529},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-8.9,null,null,null,null,4.4333333333333327,11.454203939112832,null,15.887537272446163,-7.020870605779499]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Retraitement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"Convergence des calculs satisfaisante"]
["Poids volumique hum MG",null,{"$f":"('Paramètres d''entrée'!$C$21*(1+'Paramètres d''entrée'!$C$22/100))*9.81/1000","v":21.220992000000003},"kN/m3",null,null,null,null,null,null,null,null,null,null,null,null,6,null,"Vérifier les données et calculs (faible convergence)"]
["1-sin(phi)",null,{"$f":"1-SIN('Paramètres d''entrée'!$C$19*2*PI()/360)","v":0.35721239031346075}]
[]
[]
["f1",null,1]
["heq enrobé en F"]
["sig0",{"$f":"'Paramètres d''entrée'!H5/(PI()*('Paramètres d''entrée'!H6/1000)^2)","v":707.35530263064595}]
["f2",1]
[]
[{"$f":"MIN($L$33)","v":1.4788581264419529}]
[{"$f":"COUNT($K$6:$K$10,$K$24:$K$28,$D$12)","v":11}]
[{"$f":"$D$12>=0","v":true}]
[{"$f":"$D$12<=150","v":true}]
[{"$f":"$K$24:$K$28>=0","v":true}]
[{"$f":"$K$24:$K$28<=1000","v":true}]
[{"$f":"$K$6:$K$10<=1000","v":true}]
[{"$f":"$K$6:$K$10>=0","v":true}]
[{"$f":"{10;30000;0.001;0.01;FALSE;FALSE;TRUE;1;1;1;0.0001;TRUE}","v":10}]
[{"$f":"{10;30000;1;100;0;FALSE;TRUE;0.075;0;0;FALSE;30}","v":10}]