{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["MENU-Prog","Tableau-Bois","Portée-Raidisseur","Hauteur-Raidisseur","Espace-Contre-Plaque","Epaisseur-Contre-Plaque","Poussée-Béton-frais","Calcul-Vent-Banches","Calcul-Vent-Inverse","Tige-de-Serrage","Lam-Colle-calcul","Tableaux Lamellé-Collé","Feuil1"],"not_rendered":{"charts":4,"images":68,"macros":1,"defined_names":25,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"MENU-Prog","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[0,1,0,3]]}
[null,"MENU PRINCIPAL Coffrage BOIS",{"$nulls":3},"M. Cupani ver. 2022"]
[]
[]
[]
[]
[null,null,"Tableaux des Bois de Coffrage"]
[]
[null,null,"CALCUL Portée Maxi RAIDISSEUR"]
[]
[null,null,"CALCUL Hauteur de RAIDISSEUR"]
[]
[null,null,"CALCUL ESPACEMENT APPUI CONTRE-PLAQUE"]
[]
[null,null,"CALCUL EPAISSEUR CONTRE-PLAQUE"]
[]
[null,null,"Calcul de la pression du béton frais"]
[]
[null,null,"Vérification Stabilité Banches aux Vents"]
[]
[null,null,"Vérification Stabilité Vent INVERSE"]
[]
[null,null,"Calcul Tiges de Serrage"]
[]
[null,null,"RESISTANCE A LA FLEXION Lamellé Collé EC5"]
[]
[null,null," Tableaux Lamellé Collé EC5"]

{"sheet":"Tableau-Bois","index":1,"n_rows":30,"n_cols":58,"rows_kept":30,"merged":[[1,2,1,7],[3,0,3,1],[5,0,5,1],[7,1,7,3],[7,6,8,14],[8,1,8,2],[9,6,10,14],[12,7,12,22],[14,1,16,1],[17,1,19,1],[20,1,24,1]]}
[]
[null,null,"TABLEAUX  BOIS TRADITIONNEL"]
[]
["Module de Young  (Mpa) E =→",null,{"v":10000,"d":"10,000Mpa"}]
[]
["Flèche Limite (mm) →   1 sur",null,{"v":300,"d":"300e"}]
[]
[null,"Coefficient des cas de charges",{"$nulls":4},{"$f":"CONCATENATE(\"Charges uniformément réparties de \",H14,\" kN/m à \",W14,\" kN/m\")","v":"Charges uniformément réparties de 2 kN/m à 32 kN/m"}]
[null,"Multiple cas Chrg=",null,2]
[{"$nulls":6},{"$f":"CONCATENATE(\"Avec une flèche de 1/\",C6,\"e  et Un Module E = \",C4,\" Mpa\")","v":"Avec une flèche de 1/300e  et Un Module E = 10000 Mpa"}]
[]
[{"$nulls":37},"Forces",{"$f":"B15","v":"Madrier"},{"$nulls":3},"Bastings",{"$nulls":3},"Chevrons",{"$nulls":5},"fleche","Mod: E","Contrainte","Base","Hauteur","Multiple"]
[null,null,"Section","I","I/V","b","h","Charges uniformément réparties en kN/m",{"$nulls":30},{"$f":"C15","v":"10,5 x 22,5"},{"$f":"C16","v":"7,5 x 22,5"},{"$f":"C17","v":"7,5 x 20,5"},null,{"$f":"C18","v":"6,5 x 18,5"},{"$f":"C19","v":"6,5 x 16,5"},{"$f":"C20","v":"5,5 x 15,5"},null,{"$f":"C21","v":"7,5 x 10,5"},{"$f":"C22","v":"7,5 x 7,5"},{"$f":"C23","v":"6,5 x 7,5"},{"$f":"C24","v":"5,5 x 7,5"},{"$f":"C25","v":"5,5 x 6,5"},null,200,6000,7,55,65,0.5]
[null,null,"cm2","cm4","cm3","cm","cm",{"$f":"1*$D$9","v":{"v":2,"d":"2.0kN"}},{"$f":"2*$D$9","v":{"v":4,"d":"4.0kN"}},{"$f":"3*$D$9","v":{"v":6,"d":"6.0kN"}},{"$f":"4*$D$9","v":{"v":8,"d":"8.0kN"}},{"$f":"5*$D$9","v":{"v":10,"d":"10.0kN"}},{"$f":"6*$D$9","v":{"v":12,"d":"12.0kN"}},{"$f":"7*$D$9","v":{"v":14,"d":"14.0kN"}},{"$f":"8*$D$9","v":{"v":16,"d":"16.0kN"}},{"$f":"9*$D$9","v":{"v":18,"d":"18.0kN"}},{"$f":"10*$D$9","v":{"v":20,"d":"20.0kN"}},{"$f":"11*$D$9","v":{"v":22,"d":"22.0kN"}},{"$f":"12*$D$9","v":{"v":24,"d":"24.0kN"}},{"$f":"13*$D$9","v":{"v":26,"d":"26.0kN"}},{"$f":"14*$D$9","v":{"v":28,"d":"28.0kN"}},{"$f":"15*$D$9","v":{"v":30,"d":"30.0kN"}},{"$f":"16*$D$9","v":{"v":32,"d":"32.0kN"}},{"$nulls":14},{"v":0,"d":"0.0kN"},0,0,0,null,0,0,0,null,0,0,0,0,0,null,250,7000,8,65,75,1]
[null,"Madrier",{"$f":"CONCATENATE(F15,\" x \",G15)","v":"10,5 x 22,5"},{"$f":"(F15*G15^3)/12","v":{"v":9966.796875,"d":"9,967cm4"}},{"$f":"(F15*G15^2)/6","v":{"v":885.9375,"d":"886cm3"}},{"v":10.5,"d":"10.5cm"},{"v":22.5,"d":"22.5cm"},{"$f":"((384*$C$4*D15*10^(-8))/5/$C$6/$H$14/(10^(-3)))^(1/3)","v":{"v":5.034100239366285,"d":"5.03m"}},{"$f":"((384*$C$4*D15*10^(-8))/5/$C$6/$I$14/(10^(-3)))^(1/3)","v":{"v":3.995568007841703,"d":"4.00m"}},{"$f":"((384*$C$4*$D15*10^(-8))/5/$C$6/J$14/(10^(-3)))^(1/3)","v":{"v":3.490450157175843,"d":"3.49m"}},{"v":3.171284429429201,"d":"3.17m"},{"v":2.9439596791697307,"d":"2.94m"},{"v":2.7703721256717495,"d":"2.77m"},{"v":2.631615964391579,"d":"2.63m"},{"v":2.5170501196831427,"d":"2.52m"},{"v":2.4201429690368155,"d":"2.42m"},{"v":2.3366223458329967,"d":"2.34m"},{"v":2.2635545438168054,"d":"2.26m"},{"v":2.198845813317356,"d":"2.20m"},{"v":2.140954354841777,"d":"2.14m"},{"v":2.0887149751257503,"d":"2.09m"},{"v":2.0412276347860105,"d":"2.04m"},{"v":1.9977840039208514,"d":"2.00m"},{"$nulls":14},{"$f":"1*$D$9","v":{"v":2,"d":"2.0kN"}},{"$f":"((384*$C$4*$D$15*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":5.034100239366285,"d":"5.034m"}},{"$f":"((384*$C$4*$D$16*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":4.499999999999999,"d":"4.500m"}},{"$f":"((384*$C$4*$D$17*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":4.1,"d":"4.100m"}},null,{"$f":"((384*$C$4*$D$18*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":3.527652157379316,"d":"3.528m"}},{"$f":"((384*$C$4*$D$19*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":3.1462843565815524,"d":"3.146m"}},{"$f":"((384*$C$4*$D$20*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":2.7955172032950815,"d":"2.796m"}},null,{"$f":"((384*$C$4*$D$21*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":2.1,"d":"2.100m"}},{"$f":"((384*$C$4*$D$22*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":1.5,"d":"1.500m"}},{"$f":"((384*$C$4*$D$23*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":1.430129252991615,"d":"1.430m"}},{"$f":"((384*$C$4*$D$24*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":1.3526696144976202,"d":"1.353m"}},{"$f":"((384*$C$4*$D$25*10^(-8))/(($C$6)*5*AL15*10^-3))^(1/3)","v":{"v":1.1723136658979374,"d":"1.172m"}},null,300,8000,9,75,105,1.5]
[null,null,{"$f":"CONCATENATE(F16,\" x \",G16)","v":"7,5 x 22,5"},{"$f":"(F16*G16^3)/12","v":{"v":7119.140625,"d":"7,119cm4"}},{"$f":"(F16*G16^2)/6","v":{"v":632.8125,"d":"633cm3"}},{"v":7.5,"d":"7.5cm"},{"v":22.5,"d":"22.5cm"},{"v":4.499999999999999,"d":"4.50m"},{"v":3.5716523669284483,"d":"3.57m"},{"v":3.120125734577856,"d":"3.12m"},{"v":2.8348223622634645,"d":"2.83m"},{"v":2.631615964391579,"d":"2.63m"},{"v":2.4764454366709696,"d":"2.48m"},{"v":2.352410813586196,"d":"2.35m"},{"v":2.25,"d":"2.25m"},{"v":2.1633743554611127,"d":"2.16m"},{"v":2.0887149751257503,"d":"2.09m"},{"v":2.0233994086017413,"d":"2.02m"},{"v":1.965556045656672,"d":"1.97m"},{"v":1.9138066662734556,"d":"1.91m"},{"v":1.8671097000740478,"d":"1.87m"},{"v":1.82466059867202,"d":"1.82m"},{"v":1.7858261834642244,"d":"1.79m"},{"$nulls":14},{"$f":"2*$D$9","v":{"v":4,"d":"4.0kN"}},{"$f":"((384*$C$4*$D$15*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":3.995568007841703,"d":"3.996m"}},{"$f":"((384*$C$4*$D$16*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":3.5716523669284483,"d":"3.572m"}},{"$f":"((384*$C$4*$D$17*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":3.2541721565348087,"d":"3.254m"}},null,{"$f":"((384*$C$4*$D$18*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":2.7998993728009074,"d":"2.800m"}},{"$f":"((384*$C$4*$D$19*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":2.4972075487143233,"d":"2.497m"}},{"$f":"((384*$C$4*$D$20*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":2.2188034746529057,"d":"2.219m"}},null,{"$f":"((384*$C$4*$D$21*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":1.6667711045666096,"d":"1.667m"}},{"$f":"((384*$C$4*$D$22*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":1.1905507889761495,"d":"1.191m"}},{"$f":"((384*$C$4*$D$23*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":1.1350943403246925,"d":"1.135m"}},{"$f":"((384*$C$4*$D$24*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":1.0736145845094707,"d":"1.074m"}},{"$f":"((384*$C$4*$D$25*10^(-8))/(($C$6)*5*AL16*10^-3))^(1/3)","v":{"v":0.9304659732415412,"d":"0.930m"}},null,350,9000,10,105,155,2]
[null,null,"7,5 x 20,5",{"v":5384.453125,"d":"5,384cm4"},{"v":525.3125,"d":"525cm3"},{"v":7.5,"d":"7.5cm"},{"v":20.5,"d":"20.5cm"},{"v":4.1,"d":"4.10m"},{"v":3.2541721565348087,"d":"3.25m"},{"v":2.8427812248376023,"d":"2.84m"},{"v":2.58283815228449,"d":"2.58m"},{"v":2.3976945453345504,"d":"2.40m"},{"v":2.2563169534113285,"d":"2.26m"},{"v":2.143307630156312,"d":"2.14m"},{"v":2.05,"d":"2.05m"},{"v":1.971074412753458,"d":"1.97m"},{"v":1.9030514217812395,"d":"1.90m"},{"v":1.8435416833926976,"d":"1.84m"},{"v":1.7908399527094128,"d":"1.79m"},{"v":1.7436905181602598,"d":"1.74m"},{"v":1.701144393400799,"d":"1.70m"},{"v":1.6624685454567294,"d":"1.66m"},{"v":1.6270860782674044,"d":"1.63m"},{"$nulls":14},{"$f":"3*$D$9","v":{"v":6,"d":"6.0kN"}},{"$f":"((384*$C$4*$D$15*10^(-8))/(($C$6)*5*AL17*10^-3))^(1/3)","v":{"v":3.490450157175843,"d":"3.490m"}},{"$f":"((384*$C$4*$D$16*10^(-8))/(($C$6)*5*AL17*10^-3))^(1/3)","v":{"v":3.120125734577856,"d":"3.120m"}},{"$f":"((384*$C$4*$D$17*10^(-8))/(($C$6)*5*AL17*10^-3))^(1/3)","v":{"v":2.842781224837602,"d":"2.843m"}},null,{"v":2.445937395306289,"d":"2.446m"},{"v":2.181511730948852,"d":"2.182m"},{"v":1.9383033705458002,"d":"1.938m"},null,{"v":1.4560586761363328,"d":"1.456m"},{"v":1.040041911525952,"d":"1.040m"},{"v":0.9915962413403874,"d":"0.992m"},{"v":0.9378887276834518,"d":"0.938m"},{"v":0.8128368973256581,"d":"0.813m"},null,400,10000,11,null,165,2.5]
[null,"Bastings","6,5 x 18,5",{"v":3429.6302083333335,"d":"3,430cm4"},{"v":370.7708333333333,"d":"371cm3"},{"v":6.5,"d":"6.5cm"},{"v":18.5,"d":"18.5cm"},{"v":3.527652157379316,"d":"3.53m"},{"v":2.7998993728009074,"d":"2.80m"},{"v":2.445937395306289,"d":"2.45m"},{"v":2.2222816048946314,"d":"2.22m"},{"v":2.062983496484401,"d":"2.06m"},{"v":1.9413417971787803,"d":"1.94m"},{"v":1.8441082403532838,"d":"1.84m"},{"v":1.7638260786896582,"d":"1.76m"},{"v":1.6959182693914405,"d":"1.70m"},{"v":1.6373910862561867,"d":"1.64m"},{"v":1.586188730887548,"d":"1.59m"},{"v":1.5408440055357153,"d":"1.54m"},{"v":1.5002764922414387,"d":"1.50m"},{"v":1.463669680340014,"d":"1.46m"},{"v":1.4303928660867526,"d":"1.43m"},{"v":1.3999496864004537,"d":"1.40m"},{"$nulls":14},{"$f":"4*$D$9","v":{"v":8,"d":"8.0kN"}},{"v":3.171284429429201,"d":"3.171m"},{"v":2.8348223622634645,"d":"2.835m"},{"v":2.58283815228449,"d":"2.583m"},null,{"v":2.2222816048946314,"d":"2.222m"},{"v":1.9820349449060228,"d":"1.982m"},{"v":1.7610654848873595,"d":"1.761m"},null,{"v":1.322917102389617,"d":"1.323m"},{"v":0.9449407874211548,"d":"0.945m"},{"v":0.9009249749572831,"d":"0.901m"},{"v":0.8521284604293675,"d":"0.852m"},{"v":0.7385113323721185,"d":"0.739m"},null,450,11000,12,null,185,3]
[null,null,"6,5 x 16,5",{"v":2433.234375,"d":"2,433cm4"},{"v":294.9375,"d":"295cm3"},{"v":6.5,"d":"6.5cm"},{"v":16.5,"d":"16.5cm"},{"v":3.1462843565815524,"d":"3.15m"},{"v":2.4972075487143233,"d":"2.50m"},{"v":2.181511730948852,"d":"2.18m"},{"v":1.9820349449060228,"d":"1.98m"},{"v":1.8399582536212227,"d":"1.84m"},{"v":1.7314670082945878,"d":"1.73m"},{"v":1.644745187342118,"d":"1.64m"},{"v":1.5731421782907764,"d":"1.57m"},{"v":1.5125757537815552,"d":"1.51m"},{"v":1.4603758336879502,"d":"1.46m"},{"v":1.4147088680888942,"d":"1.41m"},{"v":1.37426627520753,"d":"1.37m"},{"v":1.338084439026148,"d":"1.34m"},{"v":1.3054351203032557,"d":"1.31m"},{"v":1.2757557994827795,"d":"1.28m"},{"v":1.2486037743571616,"d":"1.25m"},{"$nulls":14},{"$f":"5*$D$9","v":{"v":10,"d":"10.0kN"}},{"v":2.9439596791697307,"d":"2.944m"},{"v":2.6316159643915795,"d":"2.632m"},{"v":2.3976945453345504,"d":"2.398m"},null,{"v":2.062983496484401,"d":"2.063m"},{"v":1.8399582536212227,"d":"1.840m"},{"v":1.6348283779828083,"d":"1.635m"},null,{"v":1.2280874500494037,"d":"1.228m"},{"v":0.8772053214638599,"d":"0.877m"},{"v":0.8363446607369195,"d":"0.836m"},{"v":0.7910459893465202,"d":"0.791m"},{"v":0.6855731907669842,"d":"0.686m"},null,500,12000,13,null,205]
[null,null,"5,5 x 15,5",{"v":1706.7760416666667,"d":"1,707cm4"},{"v":220.22916666666666,"d":"220cm3"},{"v":5.5,"d":"5.5cm"},{"v":15.5,"d":"15.5cm"},{"v":2.7955172032950815,"d":"2.80m"},{"v":2.2188034746529057,"d":"2.22m"},{"v":1.9383033705458002,"d":"1.94m"},{"v":1.7610654848873595,"d":"1.76m"},{"v":1.6348283779828083,"d":"1.63m"},{"v":1.538432404718955,"d":"1.54m"},{"v":1.4613788663550202,"d":"1.46m"},{"v":1.3977586016475407,"d":"1.40m"},{"v":1.3439444950797665,"d":"1.34m"},{"v":1.2975641434986878,"d":"1.30m"},{"v":1.2569884124185027,"d":"1.26m"},{"v":1.221054608816418,"d":"1.22m"},{"v":1.1889065465218345,"d":"1.19m"},{"v":1.159897174888027,"d":"1.16m"},{"v":1.1335266875027412,"d":"1.13m"},{"v":1.1094017373264529,"d":"1.11m"},{"$nulls":14},{"$f":"6*$D$9","v":{"v":12,"d":"12.0kN"}},{"v":2.7703721256717504,"d":"2.770m"},{"v":2.4764454366709696,"d":"2.476m"},{"v":2.256316953411328,"d":"2.256m"},null,{"v":1.9413417971787803,"d":"1.941m"},{"v":1.7314670082945878,"d":"1.731m"},{"v":1.538432404718955,"d":"1.538m"},null,{"v":1.1556745371131194,"d":"1.156m"},{"v":0.8254818122236567,"d":"0.825m"},{"v":0.7870304583157218,"d":"0.787m"},{"v":0.7444027764769138,"d":"0.744m"},{"v":0.6451490729466586,"d":"0.645m"},null,750,13000,14,null,225]
[null,"Chevrons","7,5 x 10,5",{"v":723.515625,"d":"724cm4"},{"v":137.8125,"d":"138cm3"},{"v":7.5,"d":"7.5cm"},{"v":10.5,"d":"10.5cm"},{"v":2.0999999999999996,"d":"2.10m"},{"v":1.6667711045666094,"d":"1.67m"},{"v":1.4560586761363328,"d":"1.46m"},{"v":1.3229171023896167,"d":"1.32m"},{"v":1.2280874500494037,"d":"1.23m"},{"v":1.1556745371131194,"d":"1.16m"},{"v":1.0977917130068915,"d":"1.10m"},{"v":1.05,"d":"1.05m"},{"v":1.009574699215186,"d":"1.01m"},{"v":0.9747336550586836,"d":"0.97m"},{"v":0.9442530573474792,"d":"0.94m"},{"v":0.9172594879731137,"d":"0.92m"},{"v":0.8931097775942793,"d":"0.89m"},{"v":0.8713178600345556,"d":"0.87m"},{"v":0.8515082793802761,"d":"0.85m"},{"v":0.8333855522833047,"d":"0.83m"},{"$nulls":14},{"$f":"7*$D$9","v":{"v":14,"d":"14.0kN"}},{"v":2.6316159643915795,"d":"2.632m"},{"v":2.352410813586196,"d":"2.352m"},{"v":2.143307630156312,"d":"2.143m"},null,{"v":1.8441082403532838,"d":"1.844m"},{"v":1.644745187342118,"d":"1.645m"},{"v":1.4613788663550202,"d":"1.461m"},null,{"v":1.0977917130068915,"d":"1.098m"},{"v":0.7841369378620653,"d":"0.784m"},{"v":0.7476114487918719,"d":"0.748m"},{"v":0.7071188063008161,"d":"0.707m"},{"v":0.6128362987940407,"d":"0.613m"},null,1000,14000,15]
[null,null,"7,5 x 7,5",{"v":263.671875,"d":"264cm4"},{"v":70.3125,"d":"70cm3"},{"v":7.5,"d":"7.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.5,"d":"1.50m"},{"v":1.1905507889761495,"d":"1.19m"},{"v":1.040041911525952,"d":"1.04m"},{"v":0.9449407874211548,"d":"0.94m"},{"v":0.8772053214638599,"d":"0.88m"},{"v":0.8254818122236567,"d":"0.83m"},{"v":0.7841369378620653,"d":"0.78m"},{"v":0.75,"d":"0.75m"},{"v":0.7211247851537042,"d":"0.72m"},{"v":0.6962383250419169,"d":"0.70m"},{"v":0.6744664695339138,"d":"0.67m"},{"v":0.6551853485522241,"d":"0.66m"},{"v":0.6379355554244852,"d":"0.64m"},{"v":0.6223699000246826,"d":"0.62m"},{"v":0.60822019955734,"d":"0.61m"},{"v":0.5952753944880749,"d":"0.60m"},{"$nulls":14},{"$f":"8*$D$9","v":{"v":16,"d":"16.0kN"}},{"v":2.5170501196831427,"d":"2.517m"},{"v":2.25,"d":"2.250m"},{"v":2.05,"d":"2.050m"},null,{"v":1.7638260786896582,"d":"1.764m"},{"v":1.5731421782907764,"d":"1.573m"},{"v":1.3977586016475407,"d":"1.398m"},null,{"v":1.05,"d":"1.050m"},{"v":0.75,"d":"0.750m"},{"v":0.7150646264958075,"d":"0.715m"},{"v":0.6763348072488101,"d":"0.676m"},{"v":0.5861568329489688,"d":"0.586m"}]
[null,null,"6,5 x 7,5",{"v":228.515625,"d":"229cm4"},{"v":60.9375,"d":"61cm3"},{"v":6.5,"d":"6.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.430129252991615,"d":"1.43m"},{"v":1.1350943403246923,"d":"1.14m"},{"v":0.9915962413403874,"d":"0.99m"},{"v":0.9009249749572831,"d":"0.90m"},{"v":0.8363446607369195,"d":"0.84m"},{"v":0.7870304583157218,"d":"0.79m"},{"v":0.7476114487918719,"d":"0.75m"},{"v":0.7150646264958075,"d":"0.72m"},{"v":0.6875344335370704,"d":"0.69m"},{"v":0.6638071971308864,"d":"0.66m"},{"v":0.6430494854949519,"d":"0.64m"},{"v":0.6246664887306955,"d":"0.62m"},{"v":0.60822019955734,"d":"0.61m"},{"v":0.5933796001378436,"d":"0.59m"},{"v":0.5798889997648997,"d":"0.58m"},{"v":0.5675471701623462,"d":"0.57m"},{"$nulls":14},{"$f":"9*$D$9","v":{"v":18,"d":"18.0kN"}},{"v":2.4201429690368155,"d":"2.420m"},{"v":2.1633743554611127,"d":"2.163m"},{"v":1.971074412753458,"d":"1.971m"},null,{"v":1.6959182693914405,"d":"1.696m"},{"v":1.5125757537815552,"d":"1.513m"},{"v":1.3439444950797665,"d":"1.344m"},null,{"v":1.009574699215186,"d":"1.010m"},{"v":0.7211247851537042,"d":"0.721m"},{"v":0.6875344335370706,"d":"0.688m"},{"v":0.6502957234256935,"d":"0.650m"},{"v":0.5635896269689343,"d":"0.564m"}]
[null,null,"5,5 x 7,5",{"v":193.359375,"d":"193cm4"},{"v":51.5625,"d":"52cm3"},{"v":5.5,"d":"5.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.35266961449762,"d":"1.35m"},{"v":1.0736145845094704,"d":"1.07m"},{"v":0.9378887276834517,"d":"0.94m"},{"v":0.8521284604293675,"d":"0.85m"},{"v":0.7910459893465202,"d":"0.79m"},{"v":0.7444027764769137,"d":"0.74m"},{"v":0.7071188063008161,"d":"0.71m"},{"v":0.6763348072488101,"d":"0.68m"},{"v":0.6502957234256935,"d":"0.65m"},{"v":0.6278536178219456,"d":"0.63m"},{"v":0.60822019955734,"d":"0.61m"},{"v":0.5908328752337506,"d":"0.59m"},{"v":0.5752773612202424,"d":"0.58m"},{"v":0.5612405684942066,"d":"0.56m"},{"v":0.5484806552432618,"d":"0.55m"},{"v":0.5368072922547352,"d":"0.54m"},{"$nulls":14},{"$f":"10*$D$9","v":{"v":20,"d":"20.0kN"}},{"v":2.3366223458329967,"d":"2.337m"},{"v":2.0887149751257503,"d":"2.089m"},{"v":1.9030514217812393,"d":"1.903m"},null,{"v":1.6373910862561867,"d":"1.637m"},{"v":1.4603758336879502,"d":"1.460m"},{"v":1.2975641434986878,"d":"1.298m"},null,{"v":0.9747336550586836,"d":"0.975m"},{"v":0.6962383250419169,"d":"0.696m"},{"v":0.6638071971308864,"d":"0.664m"},{"v":0.6278536178219456,"d":"0.628m"},{"v":0.5441398021123529,"d":"0.544m"}]
[null,null,"5,5 x 6,5",{"v":125.86979166666667,"d":"126cm4"},{"v":38.729166666666664,"d":"39cm3"},{"v":5.5,"d":"5.5cm"},{"v":6.5,"d":"6.5cm"},{"v":1.1723136658979374,"d":"1.17m"},{"v":0.9304659732415411,"d":"0.93m"},{"v":0.8128368973256581,"d":"0.81m"},{"v":0.7385113323721185,"d":"0.74m"},{"v":0.6855731907669842,"d":"0.69m"},{"v":0.6451490729466586,"d":"0.65m"},{"v":0.6128362987940407,"d":"0.61m"},{"v":0.5861568329489688,"d":"0.59m"},{"v":0.5635896269689343,"d":"0.56m"},{"v":0.5441398021123529,"d":"0.54m"},{"v":0.5271241729496947,"d":"0.53m"},{"v":0.5120551585359172,"d":"0.51m"},{"v":0.49857371305754344,"d":"0.50m"},{"v":0.486408492694979,"d":"0.49m"},{"v":0.47534990121082693,"d":"0.48m"},{"v":0.4652329866207706,"d":"0.47m"},{"$nulls":14},{"$f":"11*$D$9","v":{"v":22,"d":"22.0kN"}},{"v":2.263554543816806,"d":"2.264m"},{"v":2.023399408601741,"d":"2.023m"},{"v":1.8435416833926976,"d":"1.844m"},null,{"v":1.586188730887548,"d":"1.586m"},{"v":1.4147088680888942,"d":"1.415m"},{"v":1.2569884124185027,"d":"1.257m"},null,{"v":0.9442530573474792,"d":"0.944m"},{"v":0.6744664695339138,"d":"0.674m"},{"v":0.6430494854949519,"d":"0.643m"},{"v":0.60822019955734,"d":"0.608m"},{"v":0.5271241729496947,"d":"0.527m"}]
[{"$nulls":37},{"$f":"12*$D$9","v":{"v":24,"d":"24.0kN"}},{"v":2.1988458133173565,"d":"2.199m"},{"v":1.965556045656672,"d":"1.966m"},{"v":1.7908399527094125,"d":"1.791m"},null,{"v":1.5408440055357153,"d":"1.541m"},{"v":1.37426627520753,"d":"1.374m"},{"v":1.221054608816418,"d":"1.221m"},null,{"v":0.9172594879731139,"d":"0.917m"},{"v":0.6551853485522241,"d":"0.655m"},{"v":0.6246664887306955,"d":"0.625m"},{"v":0.5908328752337506,"d":"0.591m"},{"v":0.5120551585359172,"d":"0.512m"}]
[{"$nulls":37},{"$f":"13*$D$9","v":{"v":26,"d":"26.0kN"}},{"v":2.140954354841777,"d":"2.141m"},{"v":1.9138066662734556,"d":"1.914m"},{"v":1.7436905181602598,"d":"1.744m"},null,{"v":1.5002764922414387,"d":"1.500m"},{"v":1.338084439026148,"d":"1.338m"},{"v":1.1889065465218345,"d":"1.189m"},null,{"v":0.8931097775942793,"d":"0.893m"},{"v":0.6379355554244852,"d":"0.638m"},{"v":0.60822019955734,"d":"0.608m"},{"v":0.5752773612202424,"d":"0.575m"},{"v":0.49857371305754344,"d":"0.499m"}]
[{"$nulls":37},{"$f":"14*$D$9","v":{"v":28,"d":"28.0kN"}},{"v":2.0887149751257503,"d":"2.089m"},{"v":1.8671097000740478,"d":"1.867m"},{"v":1.701144393400799,"d":"1.701m"},null,{"v":1.463669680340014,"d":"1.464m"},{"v":1.3054351203032557,"d":"1.305m"},{"v":1.159897174888027,"d":"1.160m"},null,{"v":0.8713178600345556,"d":"0.871m"},{"v":0.6223699000246826,"d":"0.622m"},{"v":0.5933796001378436,"d":"0.593m"},{"v":0.5612405684942066,"d":"0.561m"},{"v":0.48640849269497904,"d":"0.486m"}]
[{"$nulls":37},{"$f":"15*$D$9","v":{"v":30,"d":"30.0kN"}},{"v":2.0412276347860105,"d":"2.041m"},{"v":1.8246605986720201,"d":"1.825m"},{"v":1.6624685454567292,"d":"1.662m"},null,{"v":1.4303928660867529,"d":"1.430m"},{"v":1.2757557994827795,"d":"1.276m"},{"v":1.1335266875027412,"d":"1.134m"},null,{"v":0.8515082793802761,"d":"0.852m"},{"v":0.60822019955734,"d":"0.608m"},{"v":0.5798889997648998,"d":"0.580m"},{"v":0.548480655243262,"d":"0.548m"},{"v":0.47534990121082693,"d":"0.475m"}]
[{"$nulls":37},{"$f":"16*$D$9","v":{"v":32,"d":"32.0kN"}},{"v":1.9977840039208514,"d":"1.998m"},{"v":1.7858261834642244,"d":"1.786m"},{"v":1.6270860782674044,"d":"1.627m"},null,{"v":1.399949686400454,"d":"1.400m"},{"v":1.2486037743571616,"d":"1.249m"},{"v":1.1094017373264529,"d":"1.109m"},null,{"v":0.8333855522833048,"d":"0.833m"},{"v":0.5952753944880749,"d":"0.595m"},{"v":0.5675471701623462,"d":"0.568m"},{"v":0.5368072922547353,"d":"0.537m"},{"v":0.4652329866207706,"d":"0.465m"}]

{"sheet":"Portée-Raidisseur","index":2,"n_rows":38,"n_cols":44,"rows_kept":38,"merged":[[1,2,1,7],[3,0,3,1],[4,0,4,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[14,0,14,1],[14,5,14,6],[16,0,16,1],[16,5,16,6],[18,0,18,1],[19,5,19,6],[22,1,23,1],[22,2,23,2],[22,11,22,13],[22,16,22,25],[23,11,23,12],[23,16,23,25],[25,15,25,30],[27,9,29,9],[30,9,32,9],[33,9,37,9]]}
[]
[null,null,"CALCUL Portée Maxi RAIDISSEUR"]
[]
["Module de Young  (Mpa) E =→",null,{"v":10000,"d":"10,000Mpa"}]
["Contrainte limite bois (en Mpa )→",null,{"v":10,"d":"10Mpa"}]
[]
[]
["(G) Charges permanentes →",null,{"v":1,"d":"1.00kN/m"},{"$nulls":8},"←Résultats"]
["uniquement  poids propre Coffrage",{"$nulls":10},"←Données"]
["(Q) Charges Exploitations →",null,{"v":15,"d":"15.00kN/m"}]
["Poids du Béton frais + exploitation",{"$nulls":36},"Appuis:","fleche","Mod: E","Contrainte","Base","Hauteur","Multiple"]
["Flèche Limite (mm) →   1 sur",null,{"v":300,"d":"300e"},{"$nulls":34},"2 appuis",200,6000,7,55,65,0.5]
[{"$f":"C22/C12","v":{"v":2.8649494583170356,"d":"flèche Limite =2.86mm"}},{"$nulls":36},"3 appuis",250,7000,8,65,75,1]
[{"$nulls":37},"4 appuis",300,8000,9,75,105,1.5]
["(Ps) Charges ELS (G+Q) ----→",null,{"$f":"C8+C10","v":{"v":16,"d":"16.0kN/m"}},null,null,"Nombre d'appuis →",null,2,{"$nulls":29},"+5 appuis",350,9000,10,105,155,2]
[{"$nulls":38},400,10000,11,null,165,2.5]
["(Pu) Charges ELU (1,35G+1,5Q) →",null,{"$f":"(1.35*C8)+(1.5*C10)","v":{"v":23.85,"d":"23.9kN/m"}},null,null,{"$f":"(($B$20/10)*($B$21/10)^3)/12","v":{"v":1706.7760416666667,"d":"1,706.8cm4"}},{"$nulls":32},450,11000,12,null,185,3]
[{"$nulls":5},"Espacement (min1) =",null,{"$f":"(((C4*F17*10^-8)/G25/C15/C12/10^-3)^(1/3))*1000","v":{"v":1892.0182987717992,"d":"1,892mm"}},{"$nulls":30},500,12000,13,null,205]
["RESULTATS",{"$nulls":37},750,13000,14,null,225]
["Base (mm) →",{"v":55,"d":"55mm"},{"$nulls":3},{"$f":"(($B$20/10)*(B21/10)^2)/6","v":{"v":220.22916666666666,"d":"220.2cm3"}},{"$nulls":32},1000,14000,15]
["Haut (mm) →",{"v":155,"d":"155mm"},{"$nulls":3},"Espacement (min2) =",null,{"$f":"(((C5*F20*10^-6)/(C17*(10^-3)*$G$23))^(0.5))*1000","v":{"v":859.4848374951107,"d":"859mm"}}]
[null,null,{"$f":"MIN(H18,H21)","v":{"v":859.4848374951107,"d":"859mm"}}]
[null,"PORTEE  =",{"$f":"C22/1000","v":{"v":0.8594848374951107,"d":"0.859m"}},null,null,"Coef (Mf)=",{"$f":"IF($H$15=1,0.125,IF($H$15=2,0.125,IF($H$15=3,0.1,0.11)))","v":0.125},{"$nulls":4},"Coefficient des cas de charges",{"$nulls":4},{"$f":"CONCATENATE(\"Charges uniformément réparties de \",P27,\" kN/m à \",AE27,\" kN/m\")","v":"Charges uniformément réparties de 1 kN/m à 16 kN/m"}]
[{"$nulls":11},"Multiple cas Chrg=",null,1,null,null,{"$f":"CONCATENATE(\"Avec une flèche de 1/\",C12,\"e  et Un Module E = \",C4,\" Mpa\")","v":"Avec une flèche de 1/300e  et Un Module E = 10000 Mpa"}]
[{"$nulls":5},"Coef flèche",{"$f":"IF($H$15=1,0.013,IF($H$15=2,0.00525,IF($H$15=3,0.00678,0.00654)))","v":0.00525}]
[{"$nulls":10},"Section","I","I/V","b","h","Charges uniformément réparties en kN/m"]
[{"$nulls":10},"cm2","cm4","cm3","cm","cm",{"$f":"1*$N$24","v":{"v":1,"d":"1.00"}},{"$f":"2*$N$24","v":{"v":2,"d":"2.00"}},{"$f":"3*$N$24","v":{"v":3,"d":"3.00"}},{"$f":"4*$N$24","v":{"v":4,"d":"4.00"}},{"$f":"5*$N$24","v":{"v":5,"d":"5.00"}},{"$f":"6*$N$24","v":{"v":6,"d":"6.00"}},{"$f":"7*$N$24","v":{"v":7,"d":"7.00"}},{"$f":"8*$N$24","v":{"v":8,"d":"8.00"}},{"$f":"9*$N$24","v":{"v":9,"d":"9.00"}},{"$f":"10*$N$24","v":{"v":10,"d":"10.00"}},{"$f":"11*$N$24","v":{"v":11,"d":"11.00"}},{"$f":"12*$N$24","v":{"v":12,"d":"12.00"}},{"$f":"13*$N$24","v":{"v":13,"d":"13.00"}},{"$f":"14*$N$24","v":{"v":14,"d":"14.00"}},{"$f":"15*$N$24","v":{"v":15,"d":"15.00"}},{"$f":"16*$N$24","v":{"v":16,"d":"16.00"}}]
[{"$nulls":9},"Madrier",{"$f":"CONCATENATE(N28,\" x \",O28)","v":"10,5 x 22,5"},{"$f":"(N28*O28^3)/12","v":{"v":9966.796875,"d":"9,967cm4"}},{"$f":"(N28*O28^2)/6","v":{"v":885.9375,"d":"886cm3"}},{"v":10.5,"d":"10.5cm"},{"v":22.5,"d":"22.5cm"},{"$f":"((384*$C$4*L28*10^(-8))/5/$C$12/$P$27/(10^(-3)))^(1/3)","v":{"v":6.342568858858401,"d":"6.34m"}},{"$f":"((384*$C$4*L28*10^(-8))/5/$C$12/$Q$27/(10^(-3)))^(1/3)","v":{"v":5.034100239366285,"d":"5.03m"}},{"$f":"((384*$C$4*$L28*10^(-8))/5/$C$12/R$27/(10^(-3)))^(1/3)","v":{"v":4.397691626634712,"d":"4.40m"}},{"v":3.995568007841703,"d":"4.00m"},{"v":3.709156769827701,"d":"3.71m"},{"v":3.490450157175843,"d":"3.49m"},{"v":3.3156283487763476,"d":"3.32m"},{"v":3.171284429429201,"d":"3.17m"},{"v":3.0491890704445597,"d":"3.05m"},{"v":2.9439596791697307,"d":"2.94m"},{"v":2.8519000173399807,"d":"2.85m"},{"v":2.7703721256717495,"d":"2.77m"},{"v":2.697433458529252,"d":"2.70m"},{"v":2.631615964391579,"d":"2.63m"},{"v":2.5717856646940187,"d":"2.57m"},{"v":2.5170501196831427,"d":"2.52m"}]
[{"$nulls":10},{"$f":"CONCATENATE(N29,\" x \",O29)","v":"7,5 x 22,5"},{"$f":"(N29*O29^3)/12","v":{"v":7119.140625,"d":"7,119cm4"}},{"$f":"(N29*O29^2)/6","v":{"v":632.8125,"d":"633cm3"}},{"v":7.5,"d":"7.5cm"},{"v":22.5,"d":"22.5cm"},{"v":5.669644724526928,"d":"5.67m"},{"v":4.499999999999999,"d":"4.50m"},{"v":3.9311120913133437,"d":"3.93m"},{"v":3.5716523669284483,"d":"3.57m"},{"v":3.3156283487763476,"d":"3.32m"},{"v":3.120125734577856,"d":"3.12m"},{"v":2.9638519020375726,"d":"2.96m"},{"v":2.8348223622634645,"d":"2.83m"},{"v":2.72568088924821,"d":"2.73m"},{"v":2.631615964391579,"d":"2.63m"},{"v":2.5493235072421716,"d":"2.55m"},{"v":2.4764454366709696,"d":"2.48m"},{"v":2.411245304267059,"d":"2.41m"},{"v":2.352410813586196,"d":"2.35m"},{"v":2.2989282971806593,"d":"2.30m"},{"v":2.25,"d":"2.25m"}]
[{"$nulls":10},"7,5 x 20,5",{"v":5384.453125,"d":"5,384cm4"},{"v":525.3125,"d":"525cm3"},{"v":7.5,"d":"7.5cm"},{"v":20.5,"d":"20.5cm"},{"v":5.165676304568979,"d":"5.17m"},{"v":4.1,"d":"4.10m"},{"v":3.5816799054188255,"d":"3.58m"},{"v":3.2541721565348087,"d":"3.25m"},{"v":3.020905828885117,"d":"3.02m"},{"v":2.8427812248376023,"d":"2.84m"},{"v":2.700398399634233,"d":"2.70m"},{"v":2.58283815228449,"d":"2.58m"},{"v":2.4833981435372574,"d":"2.48m"},{"v":2.3976945453345504,"d":"2.40m"},{"v":2.322716973265089,"d":"2.32m"},{"v":2.2563169534113285,"d":"2.26m"},{"v":2.19691238833221,"d":"2.20m"},{"v":2.143307630156312,"d":"2.14m"},{"v":2.0945791152090454,"d":"2.09m"},{"v":2.05,"d":"2.05m"}]
[{"$nulls":9},"Bastings","6,5 x 18,5",{"v":3429.6302083333335,"d":"3,430cm4"},{"v":370.7708333333333,"d":"371cm3"},{"v":6.5,"d":"6.5cm"},{"v":18.5,"d":"18.5cm"},{"v":4.444563209789262,"d":"4.44m"},{"v":3.527652157379316,"d":"3.53m"},{"v":3.0816880110714306,"d":"3.08m"},{"v":2.7998993728009074,"d":"2.80m"},{"v":2.5991963328064234,"d":"2.60m"},{"v":2.445937395306289,"d":"2.45m"},{"v":2.3234307903056965,"d":"2.32m"},{"v":2.2222816048946314,"d":"2.22m"},{"v":2.13672312650756,"d":"2.14m"},{"v":2.062983496484401,"d":"2.06m"},{"v":1.9984725711512557,"d":"2.00m"},{"v":1.9413417971787803,"d":"1.94m"},{"v":1.890229933237431,"d":"1.89m"},{"v":1.8441082403532838,"d":"1.84m"},{"v":1.802182081602158,"d":"1.80m"},{"v":1.7638260786896582,"d":"1.76m"}]
[{"$nulls":10},"6,5 x 16,5",{"v":2433.234375,"d":"2,433cm4"},{"v":294.9375,"d":"295cm3"},{"v":6.5,"d":"6.5cm"},{"v":16.5,"d":"16.5cm"},{"v":3.9640698898120448,"d":"3.96m"},{"v":3.1462843565815524,"d":"3.15m"},{"v":2.7485325504150597,"d":"2.75m"},{"v":2.4972075487143233,"d":"2.50m"},{"v":2.318202134665188,"d":"2.32m"},{"v":2.181511730948852,"d":"2.18m"},{"v":2.0722490832456213,"d":"2.07m"},{"v":1.9820349449060228,"d":"1.98m"},{"v":1.9057260317499858,"d":"1.91m"},{"v":1.8399582536212227,"d":"1.84m"},{"v":1.7824214823781472,"d":"1.78m"},{"v":1.7314670082945878,"d":"1.73m"},{"v":1.6858807512658167,"d":"1.69m"},{"v":1.644745187342118,"d":"1.64m"},{"v":1.6073515862938168,"d":"1.61m"},{"v":1.5731421782907764,"d":"1.57m"}]
[{"$nulls":10},"5,5 x 15,5",{"v":1706.7760416666667,"d":"1,707cm4"},{"v":220.22916666666666,"d":"220cm3"},{"v":5.5,"d":"5.5cm"},{"v":15.5,"d":"15.5cm"},{"v":3.5221309697747185,"d":"3.52m"},{"v":2.7955172032950815,"d":"2.80m"},{"v":2.4421092176328356,"d":"2.44m"},{"v":2.2188034746529057,"d":"2.22m"},{"v":2.0597546863860323,"d":"2.06m"},{"v":1.9383033705458002,"d":"1.94m"},{"v":1.8412219955921965,"d":"1.84m"},{"v":1.7610654848873595,"d":"1.76m"},{"v":1.6932639592413345,"d":"1.69m"},{"v":1.6348283779828083,"d":"1.63m"},{"v":1.5837061602800098,"d":"1.58m"},{"v":1.538432404718955,"d":"1.54m"},{"v":1.4979283843206774,"d":"1.50m"},{"v":1.4613788663550202,"d":"1.46m"},{"v":1.4281541342023114,"d":"1.43m"},{"v":1.3977586016475407,"d":"1.40m"}]
[{"$nulls":9},"Chevrons","7,5 x 10,5",{"v":723.515625,"d":"724cm4"},{"v":137.8125,"d":"138cm3"},{"v":7.5,"d":"7.5cm"},{"v":10.5,"d":"10.5cm"},{"v":2.6458342047792334,"d":"2.65m"},{"v":2.0999999999999996,"d":"2.10m"},{"v":1.8345189759462275,"d":"1.83m"},{"v":1.6667711045666094,"d":"1.67m"},{"v":1.5472932294289623,"d":"1.55m"},{"v":1.4560586761363328,"d":"1.46m"},{"v":1.3831308876175339,"d":"1.38m"},{"v":1.3229171023896167,"d":"1.32m"},{"v":1.2719844149824977,"d":"1.27m"},{"v":1.2280874500494037,"d":"1.23m"},{"v":1.18968430337968,"d":"1.19m"},{"v":1.1556745371131194,"d":"1.16m"},{"v":1.1252478086579611,"d":"1.13m"},{"v":1.0977917130068915,"d":"1.10m"},{"v":1.0728332053509744,"d":"1.07m"},{"v":1.05,"d":"1.05m"}]
[{"$nulls":10},"7,5 x 7,5",{"v":263.671875,"d":"264cm4"},{"v":70.3125,"d":"70cm3"},{"v":7.5,"d":"7.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.8898815748423097,"d":"1.89m"},{"v":1.5,"d":"1.50m"},{"v":1.3103706971044482,"d":"1.31m"},{"v":1.1905507889761495,"d":"1.19m"},{"v":1.105209449592116,"d":"1.11m"},{"v":1.040041911525952,"d":"1.04m"},{"v":0.9879506340125243,"d":"0.99m"},{"v":0.9449407874211548,"d":"0.94m"},{"v":0.9085602964160698,"d":"0.91m"},{"v":0.8772053214638599,"d":"0.88m"},{"v":0.8497745024140572,"d":"0.85m"},{"v":0.8254818122236567,"d":"0.83m"},{"v":0.8037484347556865,"d":"0.80m"},{"v":0.7841369378620653,"d":"0.78m"},{"v":0.7663094323935531,"d":"0.77m"},{"v":0.75,"d":"0.75m"}]
[{"$nulls":10},"6,5 x 7,5",{"v":228.515625,"d":"229cm4"},{"v":60.9375,"d":"61cm3"},{"v":6.5,"d":"6.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.801849949914566,"d":"1.80m"},{"v":1.430129252991615,"d":"1.43m"},{"v":1.2493329774613908,"d":"1.25m"},{"v":1.1350943403246923,"d":"1.14m"},{"v":1.053728243029631,"d":"1.05m"},{"v":0.9915962413403874,"d":"0.99m"},{"v":0.9419314014752824,"d":"0.94m"},{"v":0.9009249749572831,"d":"0.90m"},{"v":0.8662391053409028,"d":"0.87m"},{"v":0.8363446607369195,"d":"0.84m"},{"v":0.8101915828991578,"d":"0.81m"},{"v":0.7870304583157218,"d":"0.79m"},{"v":0.7663094323935531,"d":"0.77m"},{"v":0.7476114487918719,"d":"0.75m"},{"v":0.7306143574062803,"d":"0.73m"},{"v":0.7150646264958075,"d":"0.72m"}]
[{"$nulls":10},"5,5 x 7,5",{"v":193.359375,"d":"193cm4"},{"v":51.5625,"d":"52cm3"},{"v":5.5,"d":"5.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.7042569208587348,"d":"1.70m"},{"v":1.35266961449762,"d":"1.35m"},{"v":1.1816657504675012,"d":"1.18m"},{"v":1.0736145845094704,"d":"1.07m"},{"v":0.9966554934125964,"d":"1.00m"},{"v":0.9378887276834517,"d":"0.94m"},{"v":0.8909138688349337,"d":"0.89m"},{"v":0.8521284604293675,"d":"0.85m"},{"v":0.8193212706006457,"d":"0.82m"},{"v":0.7910459893465202,"d":"0.79m"},{"v":0.7663094323935531,"d":"0.77m"},{"v":0.7444027764769137,"d":"0.74m"},{"v":0.7248040569293601,"d":"0.72m"},{"v":0.7071188063008161,"d":"0.71m"},{"v":0.6910423230011185,"d":"0.69m"},{"v":0.6763348072488101,"d":"0.68m"}]
[{"$nulls":10},"5,5 x 6,5",{"v":125.86979166666667,"d":"126cm4"},{"v":38.729166666666664,"d":"39cm3"},{"v":5.5,"d":"5.5cm"},{"v":6.5,"d":"6.5cm"},{"v":1.4770226647442368,"d":"1.48m"},{"v":1.1723136658979374,"d":"1.17m"},{"v":1.0241103170718344,"d":"1.02m"},{"v":0.9304659732415411,"d":"0.93m"},{"v":0.8637680942909168,"d":"0.86m"},{"v":0.8128368973256581,"d":"0.81m"},{"v":0.772125352990276,"d":"0.77m"},{"v":0.7385113323721185,"d":"0.74m"},{"v":0.7100784345205597,"d":"0.71m"},{"v":0.6855731907669842,"d":"0.69m"},{"v":0.664134841407746,"d":"0.66m"},{"v":0.6451490729466586,"d":"0.65m"},{"v":0.6281635160054454,"d":"0.63m"},{"v":0.6128362987940407,"d":"0.61m"},{"v":0.5989033466009693,"d":"0.60m"},{"v":0.5861568329489688,"d":"0.59m"}]

{"sheet":"Hauteur-Raidisseur","index":3,"n_rows":38,"n_cols":41,"rows_kept":38,"merged":[[1,2,1,7],[3,0,3,1],[4,0,4,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,13,13,14],[14,0,14,1],[14,5,14,6],[16,0,16,1],[16,5,16,6],[18,0,18,1],[19,5,19,6],[21,11,21,13],[21,15,21,24],[22,1,23,1],[22,11,22,12],[22,15,22,24],[25,15,25,30],[27,9,29,9],[30,9,32,9],[33,9,37,9]]}
[]
[null,null,"CALCUL DIMENSION Hauteur RAIDISSEUR"]
[]
["Module de Young  (Mpa) E =→",null,{"v":10000,"d":"10,000Mpa"}]
["Contrainte limite bois (en Mpa )→",null,{"v":10,"d":"10Mpa"}]
[{"$nulls":3},"  "]
[]
["(G) Charges permanentes →",null,{"v":1,"d":"1.00kN/m"},{"$nulls":8},"←Résultats"]
["uniquement poids propre Coffrage",{"$nulls":10},"←Valeurs modifiables"]
["(Q) Charges Exploitations →",null,{"v":15,"d":"15.00kN/m"}]
["Poids du Béton frais + exploitation",{"$nulls":34},"Appuis:","fleche","Mod: E","Contrainte","Base","Multiple"]
["Flèche Limite (mm) →   1 sur",null,{"v":300,"d":"300e"},{"$nulls":32},"2 appuis",200,6000,7,55,0.5]
[{"$f":"(E14/C12)*1000","v":{"v":2.8666666666666667,"d":"flèche Limite =2.87mm"}},{"$nulls":34},"3 appuis",250,7000,8,65,1]
[{"$nulls":4},{"v":0.86,"d":"0.86m"},{"$nulls":30},"4 appuis",300,8000,9,75,1.5]
["(Ps) Charges ELS (G+Q) ----→",null,{"$f":"C8+C10","v":{"v":16,"d":"16.0kN/m"}},null,null,"Nombre d'appuis →",null,1,{"$nulls":27},"+5 appuis",350,9000,10,105,2]
[{"$nulls":36},400,10000,11,155,2.5]
["(Pu) Charges ELU (1,35G+1,5Q) →",null,{"$f":"(1.35*C8)+(1.5*C10)","v":{"v":23.85,"d":"23.9kN/m"}},null,null,{"$f":"(($B$20/10)*($B$21/10)^3)/12","v":{"v":1464.2254331267977,"d":"1,464.2cm4"}},{"$nulls":30},450,11000,12,165,3]
[{"$nulls":5},"Haut (min1) =",{"$f":"(((12/(B20/10))*((((C12*G25*((E14)^3)*C15/1000)/C4)*10^8)))^(1/3))*10","v":{"v":85.95410884934368,"d":"86mm"}},{"$nulls":29},500,12000,13,185]
["RESULTATS",{"$nulls":35},750,13000,14,205]
["Base (mm) →",{"v":75,"d":"75mm"},{"$nulls":3},{"$f":"(($B$20/10)*(B21/10)^2)/6","v":{"v":220.49325000000002,"d":"220.5cm3"}},{"$nulls":30},1000,14000,15,225]
["Haut (mm) →",{"$f":"MAX(G21,G18)","v":{"v":132.81362881873233,"d":"133mm"}},{"$nulls":3},"Haut (min2) =",{"$f":"(((6*G23*C17*((E14)^2)*1000)/($B$20/10)/C5)^0.5)*10","v":{"v":132.81362881873233,"d":"133mm"}}]
[{"$nulls":11},"Coefficient des cas de charges",{"$nulls":3},{"$f":"CONCATENATE(\"Charges uniformément réparties de \",P27,\" kN/m à \",AE27,\" kN/m\")","v":"Charges uniformément réparties de 1 kN/m à 16 kN/m"}]
["Hauteur",{"$f":"B21/1000","v":{"v":0.13281362881873232,"d":"h= 0.133m"}},{"$nulls":3},"Coef (Mf)=",{"$f":"IF($H$15=1,0.125,IF($H$15=2,0.125,IF($H$15=3,0.1,0.11)))","v":0.125},{"$nulls":4},"Multiple cas Chrg=",null,1,null,{"$f":"CONCATENATE(\"Avec une flèche de 1/\",C12,\"e  et Un Module E = \",C4,\" Mpa\")","v":"Avec une flèche de 1/300e  et Un Module E = 10000 Mpa"}]
["Poutre"]
[{"$nulls":5},"Coef flèche",{"$f":"IF($H$15=1,0.013,IF($H$15=2,0.00525,IF($H$15=3,0.00678,0.00654)))","v":{"v":0.013,"d":"0.01300"}}]
[{"$nulls":10},"Section","I","I/V","b","h","Charges uniformément réparties en kN/m"]
[{"$nulls":10},"cm2","cm4","cm3","cm","cm",{"$f":"1*$N$23","v":{"v":1,"d":"1.00"}},{"$f":"2*$N$23","v":{"v":2,"d":"2.00"}},{"$f":"3*$N$23","v":{"v":3,"d":"3.00"}},{"$f":"4*$N$23","v":{"v":4,"d":"4.00"}},{"$f":"5*$N$23","v":{"v":5,"d":"5.00"}},{"$f":"6*$N$23","v":{"v":6,"d":"6.00"}},{"$f":"7*$N$23","v":{"v":7,"d":"7.00"}},{"$f":"8*$N$23","v":{"v":8,"d":"8.00"}},{"$f":"9*$N$23","v":{"v":9,"d":"9.00"}},{"$f":"10*$N$23","v":{"v":10,"d":"10.00"}},{"$f":"11*$N$23","v":{"v":11,"d":"11.00"}},{"$f":"12*$N$23","v":{"v":12,"d":"12.00"}},{"$f":"13*$N$23","v":{"v":13,"d":"13.00"}},{"$f":"14*$N$23","v":{"v":14,"d":"14.00"}},{"$f":"15*$N$23","v":{"v":15,"d":"15.00"}},{"$f":"16*$N$23","v":{"v":16,"d":"16.00"}}]
[{"$nulls":9},"Madrier",{"$f":"CONCATENATE(N28,\" x \",O28)","v":"10,5 x 22,5"},{"$f":"(N28*O28^3)/12","v":{"v":9966.796875,"d":"9,967cm4"}},{"$f":"(N28*O28^2)/6","v":{"v":885.9375,"d":"886cm3"}},{"v":10.5,"d":"10.5cm"},{"v":22.5,"d":"22.5cm"},{"$f":"((384*$C$4*L28*10^(-8))/5/$C$12/$P$27/(10^(-3)))^(1/3)","v":{"v":6.342568858858401,"d":"6.34m"}},{"$f":"((384*$C$4*L28*10^(-8))/5/$C$12/$Q$27/(10^(-3)))^(1/3)","v":{"v":5.034100239366285,"d":"5.03m"}},{"$f":"((384*$C$4*$L28*10^(-8))/5/$C$12/R$27/(10^(-3)))^(1/3)","v":{"v":4.397691626634712,"d":"4.40m"}},{"v":3.995568007841703,"d":"4.00m"},{"v":3.709156769827701,"d":"3.71m"},{"v":3.490450157175843,"d":"3.49m"},{"v":3.3156283487763476,"d":"3.32m"},{"v":3.171284429429201,"d":"3.17m"},{"v":3.0491890704445597,"d":"3.05m"},{"v":2.9439596791697307,"d":"2.94m"},{"v":2.8519000173399807,"d":"2.85m"},{"v":2.7703721256717495,"d":"2.77m"},{"v":2.697433458529252,"d":"2.70m"},{"v":2.631615964391579,"d":"2.63m"},{"v":2.5717856646940187,"d":"2.57m"},{"v":2.5170501196831427,"d":"2.52m"}]
[{"$nulls":10},{"$f":"CONCATENATE(N29,\" x \",O29)","v":"7,5 x 22,5"},{"$f":"(N29*O29^3)/12","v":{"v":7119.140625,"d":"7,119cm4"}},{"$f":"(N29*O29^2)/6","v":{"v":632.8125,"d":"633cm3"}},{"v":7.5,"d":"7.5cm"},{"v":22.5,"d":"22.5cm"},{"v":5.669644724526928,"d":"5.67m"},{"v":4.499999999999999,"d":"4.50m"},{"v":3.9311120913133437,"d":"3.93m"},{"v":3.5716523669284483,"d":"3.57m"},{"v":3.3156283487763476,"d":"3.32m"},{"v":3.120125734577856,"d":"3.12m"},{"v":2.9638519020375726,"d":"2.96m"},{"v":2.8348223622634645,"d":"2.83m"},{"v":2.72568088924821,"d":"2.73m"},{"v":2.631615964391579,"d":"2.63m"},{"v":2.5493235072421716,"d":"2.55m"},{"v":2.4764454366709696,"d":"2.48m"},{"v":2.411245304267059,"d":"2.41m"},{"v":2.352410813586196,"d":"2.35m"},{"v":2.2989282971806593,"d":"2.30m"},{"v":2.25,"d":"2.25m"}]
[{"$nulls":10},"7,5 x 20,5",{"v":5384.453125,"d":"5,384cm4"},{"v":525.3125,"d":"525cm3"},{"v":7.5,"d":"7.5cm"},{"v":20.5,"d":"20.5cm"},{"v":5.165676304568979,"d":"5.17m"},{"v":4.1,"d":"4.10m"},{"v":3.5816799054188255,"d":"3.58m"},{"v":3.2541721565348087,"d":"3.25m"},{"v":3.020905828885117,"d":"3.02m"},{"v":2.8427812248376023,"d":"2.84m"},{"v":2.700398399634233,"d":"2.70m"},{"v":2.58283815228449,"d":"2.58m"},{"v":2.4833981435372574,"d":"2.48m"},{"v":2.3976945453345504,"d":"2.40m"},{"v":2.322716973265089,"d":"2.32m"},{"v":2.2563169534113285,"d":"2.26m"},{"v":2.19691238833221,"d":"2.20m"},{"v":2.143307630156312,"d":"2.14m"},{"v":2.0945791152090454,"d":"2.09m"},{"v":2.05,"d":"2.05m"}]
[{"$nulls":9},"Bastings","6,5 x 18,5",{"v":3429.6302083333335,"d":"3,430cm4"},{"v":370.7708333333333,"d":"371cm3"},{"v":6.5,"d":"6.5cm"},{"v":18.5,"d":"18.5cm"},{"v":4.444563209789262,"d":"4.44m"},{"v":3.527652157379316,"d":"3.53m"},{"v":3.0816880110714306,"d":"3.08m"},{"v":2.7998993728009074,"d":"2.80m"},{"v":2.5991963328064234,"d":"2.60m"},{"v":2.445937395306289,"d":"2.45m"},{"v":2.3234307903056965,"d":"2.32m"},{"v":2.2222816048946314,"d":"2.22m"},{"v":2.13672312650756,"d":"2.14m"},{"v":2.062983496484401,"d":"2.06m"},{"v":1.9984725711512557,"d":"2.00m"},{"v":1.9413417971787803,"d":"1.94m"},{"v":1.890229933237431,"d":"1.89m"},{"v":1.8441082403532838,"d":"1.84m"},{"v":1.802182081602158,"d":"1.80m"},{"v":1.7638260786896582,"d":"1.76m"}]
[{"$nulls":10},"6,5 x 16,5",{"v":2433.234375,"d":"2,433cm4"},{"v":294.9375,"d":"295cm3"},{"v":6.5,"d":"6.5cm"},{"v":16.5,"d":"16.5cm"},{"v":3.9640698898120448,"d":"3.96m"},{"v":3.1462843565815524,"d":"3.15m"},{"v":2.7485325504150597,"d":"2.75m"},{"v":2.4972075487143233,"d":"2.50m"},{"v":2.318202134665188,"d":"2.32m"},{"v":2.181511730948852,"d":"2.18m"},{"v":2.0722490832456213,"d":"2.07m"},{"v":1.9820349449060228,"d":"1.98m"},{"v":1.9057260317499858,"d":"1.91m"},{"v":1.8399582536212227,"d":"1.84m"},{"v":1.7824214823781472,"d":"1.78m"},{"v":1.7314670082945878,"d":"1.73m"},{"v":1.6858807512658167,"d":"1.69m"},{"v":1.644745187342118,"d":"1.64m"},{"v":1.6073515862938168,"d":"1.61m"},{"v":1.5731421782907764,"d":"1.57m"}]
[{"$nulls":10},"5,5 x 15,5",{"v":1706.7760416666667,"d":"1,707cm4"},{"v":220.22916666666666,"d":"220cm3"},{"v":5.5,"d":"5.5cm"},{"v":15.5,"d":"15.5cm"},{"v":3.5221309697747185,"d":"3.52m"},{"v":2.7955172032950815,"d":"2.80m"},{"v":2.4421092176328356,"d":"2.44m"},{"v":2.2188034746529057,"d":"2.22m"},{"v":2.0597546863860323,"d":"2.06m"},{"v":1.9383033705458002,"d":"1.94m"},{"v":1.8412219955921965,"d":"1.84m"},{"v":1.7610654848873595,"d":"1.76m"},{"v":1.6932639592413345,"d":"1.69m"},{"v":1.6348283779828083,"d":"1.63m"},{"v":1.5837061602800098,"d":"1.58m"},{"v":1.538432404718955,"d":"1.54m"},{"v":1.4979283843206774,"d":"1.50m"},{"v":1.4613788663550202,"d":"1.46m"},{"v":1.4281541342023114,"d":"1.43m"},{"v":1.3977586016475407,"d":"1.40m"}]
[{"$nulls":9},"Chevrons","7,5 x 10,5",{"v":723.515625,"d":"724cm4"},{"v":137.8125,"d":"138cm3"},{"v":7.5,"d":"7.5cm"},{"v":10.5,"d":"10.5cm"},{"v":2.6458342047792334,"d":"2.65m"},{"v":2.0999999999999996,"d":"2.10m"},{"v":1.8345189759462275,"d":"1.83m"},{"v":1.6667711045666094,"d":"1.67m"},{"v":1.5472932294289623,"d":"1.55m"},{"v":1.4560586761363328,"d":"1.46m"},{"v":1.3831308876175339,"d":"1.38m"},{"v":1.3229171023896167,"d":"1.32m"},{"v":1.2719844149824977,"d":"1.27m"},{"v":1.2280874500494037,"d":"1.23m"},{"v":1.18968430337968,"d":"1.19m"},{"v":1.1556745371131194,"d":"1.16m"},{"v":1.1252478086579611,"d":"1.13m"},{"v":1.0977917130068915,"d":"1.10m"},{"v":1.0728332053509744,"d":"1.07m"},{"v":1.05,"d":"1.05m"}]
[{"$nulls":10},"7,5 x 7,5",{"v":263.671875,"d":"264cm4"},{"v":70.3125,"d":"70cm3"},{"v":7.5,"d":"7.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.8898815748423097,"d":"1.89m"},{"v":1.5,"d":"1.50m"},{"v":1.3103706971044482,"d":"1.31m"},{"v":1.1905507889761495,"d":"1.19m"},{"v":1.105209449592116,"d":"1.11m"},{"v":1.040041911525952,"d":"1.04m"},{"v":0.9879506340125243,"d":"0.99m"},{"v":0.9449407874211548,"d":"0.94m"},{"v":0.9085602964160698,"d":"0.91m"},{"v":0.8772053214638599,"d":"0.88m"},{"v":0.8497745024140572,"d":"0.85m"},{"v":0.8254818122236567,"d":"0.83m"},{"v":0.8037484347556865,"d":"0.80m"},{"v":0.7841369378620653,"d":"0.78m"},{"v":0.7663094323935531,"d":"0.77m"},{"v":0.75,"d":"0.75m"}]
[{"$nulls":10},"6,5 x 7,5",{"v":228.515625,"d":"229cm4"},{"v":60.9375,"d":"61cm3"},{"v":6.5,"d":"6.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.801849949914566,"d":"1.80m"},{"v":1.430129252991615,"d":"1.43m"},{"v":1.2493329774613908,"d":"1.25m"},{"v":1.1350943403246923,"d":"1.14m"},{"v":1.053728243029631,"d":"1.05m"},{"v":0.9915962413403874,"d":"0.99m"},{"v":0.9419314014752824,"d":"0.94m"},{"v":0.9009249749572831,"d":"0.90m"},{"v":0.8662391053409028,"d":"0.87m"},{"v":0.8363446607369195,"d":"0.84m"},{"v":0.8101915828991578,"d":"0.81m"},{"v":0.7870304583157218,"d":"0.79m"},{"v":0.7663094323935531,"d":"0.77m"},{"v":0.7476114487918719,"d":"0.75m"},{"v":0.7306143574062803,"d":"0.73m"},{"v":0.7150646264958075,"d":"0.72m"}]
[{"$nulls":10},"5,5 x 7,5",{"v":193.359375,"d":"193cm4"},{"v":51.5625,"d":"52cm3"},{"v":5.5,"d":"5.5cm"},{"v":7.5,"d":"7.5cm"},{"v":1.7042569208587348,"d":"1.70m"},{"v":1.35266961449762,"d":"1.35m"},{"v":1.1816657504675012,"d":"1.18m"},{"v":1.0736145845094704,"d":"1.07m"},{"v":0.9966554934125964,"d":"1.00m"},{"v":0.9378887276834517,"d":"0.94m"},{"v":0.8909138688349337,"d":"0.89m"},{"v":0.8521284604293675,"d":"0.85m"},{"v":0.8193212706006457,"d":"0.82m"},{"v":0.7910459893465202,"d":"0.79m"},{"v":0.7663094323935531,"d":"0.77m"},{"v":0.7444027764769137,"d":"0.74m"},{"v":0.7248040569293601,"d":"0.72m"},{"v":0.7071188063008161,"d":"0.71m"},{"v":0.6910423230011185,"d":"0.69m"},{"v":0.6763348072488101,"d":"0.68m"}]
[{"$nulls":10},"5,5 x 6,5",{"v":125.86979166666667,"d":"126cm4"},{"v":38.729166666666664,"d":"39cm3"},{"v":5.5,"d":"5.5cm"},{"v":6.5,"d":"6.5cm"},{"v":1.4770226647442368,"d":"1.48m"},{"v":1.1723136658979374,"d":"1.17m"},{"v":1.0241103170718344,"d":"1.02m"},{"v":0.9304659732415411,"d":"0.93m"},{"v":0.8637680942909168,"d":"0.86m"},{"v":0.8128368973256581,"d":"0.81m"},{"v":0.772125352990276,"d":"0.77m"},{"v":0.7385113323721185,"d":"0.74m"},{"v":0.7100784345205597,"d":"0.71m"},{"v":0.6855731907669842,"d":"0.69m"},{"v":0.664134841407746,"d":"0.66m"},{"v":0.6451490729466586,"d":"0.65m"},{"v":0.6281635160054454,"d":"0.63m"},{"v":0.6128362987940407,"d":"0.61m"},{"v":0.5989033466009693,"d":"0.60m"},{"v":0.5861568329489688,"d":"0.59m"}]

{"sheet":"Espace-Contre-Plaque","index":4,"n_rows":31,"n_cols":28,"rows_kept":31,"merged":[[1,2,1,7],[1,9,1,10],[3,0,3,1],[4,0,4,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[19,0,19,1],[20,6,20,7],[21,0,21,1],[23,1,23,2],[24,1,24,2]]}
[]
[null,null,"CALCUL ESPACEMENT APPUI CONTRE-PLAQUE"]
[]
["Module de Young  (Mpa) E =→",null,{"v":10000,"d":"10,000Mpa"},null,null,"←Résultats"]
["Contrainte limite bois (en Mpa )→",null,{"v":10,"d":"10Mpa"},null,null,"←Valeurs modifiables"]
[]
[]
["(G) Charges permanentes →",null,{"v":0.8,"d":"0.8kN/m"}]
["uniquement Poids propre Coffrage"]
["(Q) Charges Exploitations →",null,{"v":7,"d":"7.0kN/m"}]
["Suracharges Explotations"]
["(Q2) Charges Béton →",null,{"$f":"C14*25","v":{"v":12.5,"d":"12.5kN/m"}}]
["uniquement Poids propre Béton",{"$nulls":22},"NB appuis","fleche","Mod: E","Contrainte","epaisseur"]
["Epaisseur béton (en m )→",null,{"v":0.5,"d":"0.50m"},{"$nulls":20},"2 appuis",200,6000,7,5]
[{"$nulls":23},"3 appuis",250,7000,8,7]
["Flèche Limite (mm) →   1 sur",null,{"v":200,"d":"200e"},{"$nulls":20},"4 appuis",300,8000,9,10]
[{"$f":"G19/C16","v":{"v":1.5725136593060975,"d":"flèche Limite =1.57mm"}},{"$nulls":22},"+5 appuis",350,9000,10,12]
["Epaisseur conte plaqué (mm) →",null,{"v":15,"d":"15mm"},{"$nulls":21},400,10000,11,15]
[{"$nulls":6},{"$f":"MIN(I23,I25)","v":{"v":314.5027318612195,"d":"315mm"}},{"$nulls":17},450,11000,12,18]
["(Ps) Charges ELS (G+Q+Q2) →",null,{"$f":"C8+C10+C12","v":{"v":20.3,"d":"20.3kN/m"}},{"$nulls":21},500,12000,13,20]
[{"$nulls":6},"Nombre d'appuis →",null,2,{"$nulls":15},750,13000,14,21]
["(Pu) Charges ELU (1,35G+1,5(Q+Q2)) →",null,{"$f":"(1.35*C8)+(1.5*(C10+C12))","v":{"v":30.33,"d":"30.3kN/m"}},null,null,{"$f":"(100*(C18/10)^3)/12","v":{"v":28.125,"d":"28.1cm4"}},{"$nulls":18},1000,14000,15]
[{"$nulls":7},"L(min1) =",{"$f":"((C5*F25)/C22/10^-3/K29)^0.5","v":{"v":314.5027318612195,"d":"315mm"}}]
[null,"RESULTATS"]
[null,{"$f":"G19","v":{"v":314.5027318612195,"d":"315mm = Entre-Axe"}},{"$nulls":3},{"$f":"(100*(C18/10)^2)/6","v":{"v":37.5,"d":"37.5cm3"}},null,"L(min2) =",{"$f":"(((C4*F22*10^-8)/K31/C20/C16)^(1/3))*10000","v":{"v":509.0991806101328,"d":"509mm"}}]
[]
[]
[]
[{"$nulls":9},"Coef (Mf)=",{"$f":"IF($I$21=1,0.125,IF($I$21=2,0.125,IF($I$21=3,0.1,0.11)))","v":0.125},{"$nulls":12},2]
[]
[{"$nulls":9},"Coef flèche",{"$f":"IF($I$21=1,0.013,IF($I$21=2,0.00525,IF($I$21=3,0.00678,0.00654)))","v":0.00525}]

{"sheet":"Epaisseur-Contre-Plaque","index":5,"n_rows":32,"n_cols":29,"rows_kept":32,"merged":[[1,2,1,7],[3,0,3,1],[4,0,4,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[14,0,14,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[18,6,18,7],[20,0,20,1],[22,0,22,1],[24,0,24,1]]}
[]
[null,null,"CALCUL EPAISSEUR CONTRE-PLAQUE",{"$nulls":10},"←Résultats"]
[{"$nulls":13},"←Valeurs modifiables"]
["Module de Young  (Mpa) E =→",null,{"v":10000,"d":"10,000Mpa"}]
["Contrainte limite bois (en Mpa )→",null,{"v":9,"d":"9Mpa"}]
[]
[]
["(G) Charges permanentes →",null,{"v":0.8,"d":"0.8kN/m"}]
["uniquement Poids propre Coffrage"]
["(Q) Charges Exploitations →",null,{"v":7,"d":"7kN/m"}]
["Suracharges Explotations"]
["(Q2) Charges Béton →",null,{"$f":"C15*25","v":{"v":17.5,"d":"17.5kN/m"}}]
["uniquement Poids propre Béton"]
[{"$nulls":24},"Appuis:","fleche","Mod: E","Contrainte","epaisseur"]
["Hauteur béton (en m )→",null,{"v":0.7,"d":"0.70m"},{"$nulls":21},"2 appuis",200,6000,7,5]
[{"$nulls":24},"3 appuis",250,7000,8,7]
["Flèche Limite (mm) →   1 sur",null,{"v":300,"d":"300e"},{"$nulls":4},{"v":315,"d":"315mm"},{"$nulls":16},"4 appuis",300,8000,9,10]
[{"$f":"H17/C17","v":{"v":1.05,"d":"flèche Limite =1.05mm"}},{"$nulls":23},"+5 appuis",350,9000,10,12]
["Epaisseur conte plaqué (mm) →",null,{"$f":"MAX(I23,I26)","v":{"v":17.686345368673543,"d":"18mm"}},{"$nulls":3},"Nombre d'appuis →",null,2,{"$nulls":16},400,10000,11,15]
[{"$nulls":25},450,11000,12,18]
["(Ps) Charges ELS (G+Q+Q2) →",null,{"$f":"C8+C10+C12","v":{"v":25.3,"d":"25.3kN/m"}},{"$nulls":22},500,12000,13,20]
[{"$nulls":25},750,13000,14,21]
["Chrg ELU (1,35G+1,5(Q+Q2)) →",null,{"$f":"(1.35*C8)+(1.5*(C10+C12))","v":{"v":37.83,"d":"37.8kN/m"}},null,null,{"$f":"(100*(C19/10)^3)/12","v":{"v":46.1034109962409,"d":"46.1cm4"}},null,"Ep (min1) =",{"$f":"(((6*K30*C23*((H17/1000)^2)*1000)/100/C5)^0.5)*10","v":{"v":17.686345368673543,"d":"18mm"}},{"$nulls":16},1000,14000,15]
[]
["RESULTATS"]
[{"$f":"C19","v":{"v":17.686345368673543,"d":"18mm"}}," = Epaisseur",{"$nulls":3},{"$f":"(100*(C19/10)^2)/6","v":{"v":52.13446875,"d":"52.1cm3"}},null,"Ep (min2) =",{"$f":"((12*C17*K32*C21*((H17/1000)^3))/100/10^-8/C4)^(1/3)","v":{"v":11.433292885344436,"d":"11mm"}},null,"Aide"]
[]
[]
[]
[{"$nulls":9},"Coef (Mf)=",{"$f":"IF($I$19=1,0.125,IF($I$19=2,0.125,IF($I$19=3,0.1,0.11)))","v":0.125}]
[]
[{"$nulls":9},"Coef flèche",{"$f":"IF($I$19=1,0.013,IF($I$19=2,0.00525,IF($I$19=3,0.00678,0.00654)))","v":0.00525}]

{"sheet":"Poussée-Béton-frais","index":6,"n_rows":87,"n_cols":33,"rows_kept":87,"merged":[[0,1,0,7],[12,7,22,8],[17,10,18,10],[17,11,17,23],[26,10,27,10],[26,11,27,13],[26,14,26,23],[27,1,27,3],[27,29,27,30],[28,10,31,10],[28,29,28,30],[32,10,35,10],[36,10,39,10],[43,13,43,19],[44,2,44,3],[45,13,45,16],[47,14,47,17],[48,14,48,15],[48,16,48,17],[49,16,49,17],[50,16,50,17],[51,16,51,17],[55,17,55,18],[57,17,57,18],[65,14,65,15],[69,23,69,24],[70,23,70,24],[71,14,71,17],[72,14,72,15],[72,16,72,17],[73,16,73,17],[74,16,74,17],[75,16,75,17],[77,7,77,8],[83,5,83,6],[83,22,83,23],[86,14,86,15]]}
[null,"Calcul de la pression du béton frais"]
[]
[{"$nulls":3},"hauteur de bétonnage h =",{"v":6,"d":"6.00m"}]
[]
[{"$nulls":3},"Surface de Coffrage m² =",{"v":100,"d":"100.00m²"}]
[]
[{"$nulls":3},"Epaisseur du Mur ep =",{"$f":"AE9","v":400}]
[{"$nulls":29},"ep Mur",null,null,"CIRIA"]
[{"$nulls":3},"Volume béton  =",{"$f":"E5*$AE$9/1000","v":{"v":40,"d":"40.00m3"}},{"$nulls":24},4,{"$f":"INDEX(K20:K24,AD9)","v":400},null,"Pour Murs"]
[{"$nulls":32},"Pour Poteaux"]
[{"$nulls":3},"Temps de bétonnage: =",{"v":3,"d":"3.00h"},{"$nulls":24},"vites: arr","vites: arr"]
[{"$nulls":29},{"$f":"ROUNDUP($E$13*2,0)/2","v":2},{"$f":"(MATCH($AD$12,L19:X19,1))","v":3},null,"béton normal "]
[{"$nulls":3},"Vitesse de montée du béton =",{"$f":"E3/E11","v":{"v":2,"d":"2.00m/h"}},{"$nulls":5},"Effet de la Hauteur du Béton P1",{"$nulls":18},"V de P3",{"$f":"(MATCH($AD$12,O28:X28,1))","v":3},null,"béton avec  retardateur "]
[{"$nulls":10},"H(m)",1,null,2,3,4,5,6]
[{"$nulls":3},"affaissement au cône Aff =",{"v":75,"d":"75mm"},{"$nulls":5},"p1 (kN/m²)",{"$f":"L14*25","v":25},null,50,75,100,125,150]
[{"$nulls":29},"Temp ",{"$f":"MATCH($E$17,L29:L32)","v":3}]
[{"$nulls":3},"Température =",{"v":15,"d":"15°C"},{"$nulls":5},"Effet de Voûte P2"]
[{"$nulls":10},"e(mm)","V(m/h)"]
[{"$nulls":3},"Densité béton = ",{"v":25,"d":"25kN/m3"},{"$nulls":6},1,null,2,3,4,5,6,8,10,15,20,30,40]
[{"$nulls":10},{"v":150,"d":"150mm"},35,null,35,40,45,45,50,55,60,75,90,120,150]
[null,"Pression du béton",{"$nulls":8},{"v":200,"d":"200mm"},40,null,40,45,50,50,55,60,65,80,95,125,150]
[null,"P1 : hauteur de levée de bétonnage",null,null,{"$f":"ROUNDUP((E3*E19),0)","v":{"v":150,"d":"150.0kN/m²"}},{"$nulls":5},{"v":300,"d":"300mm"},50,null,50,55,60,60,65,70,75,90,105,135,150]
[null,"P2 : effet de voute",null,null,{"$f":"INDEX(L20:X24,AD9,AE12)","v":{"v":60,"d":"60.0kN/m²"}},{"$nulls":4},{"$f":"IF(E28=E22,\"Triangle \",E28/E19)","v":{"v":2.4,"d":"2.40m"}},{"v":400,"d":"400mm"},60,null,60,65,70,70,75,80,85,100,115,145,150,{"$nulls":5},{"$f":"INDEX($O$29:$X$32,$AE$16,$AE$13)","v":55}]
[null,"P3 : effet de durcissement du béton",null,null,{"$f":"IF($E$15=50,AD23,IF($E$15=75,AD24,AD25))","v":{"v":65,"d":"65.0kN/m²"}},{"$nulls":5},{"v":500,"d":"500mm"},70,null,70,75,80,80,85,90,95,110,125,150,150,{"$nulls":5},{"$f":"INDEX($O$33:$X$36,$AE$16,$AE$13)","v":65}]
[{"$nulls":29},{"$f":"INDEX($O$37:$X$40,$AE$16,$AE$13)","v":75}]
[{"$nulls":10},"Effet de durcissement P3"]
[{"$nulls":7},"Données",null,null,"Affaissement\n(mm)","Température\ndu béton (°C)",null,null,"V(m/h)"]
[null,"Pression Retenue Mini(P1,P2,P3) =",null,null,{"$f":"MIN(E22:E24)","v":{"v":60,"d":"60.0kN/m²"}},null,null,"Résultats",{"$nulls":6},1,1.5,2,2.5,3,4,5,6,7,">=8",{"$nulls":5},{"$f":"IF($I$82>2,\"NON\",IF(AND($I$82<2,$I$80<6),(2+1.25*$I$82),IF(AND($I$82<2,$I$80=15),(2+1*$I$82),(2+0.85*$I$82))))","v":{"v":3.7,"d":"3.70kN/m²"}}]
[null,"Méthode du Manuel CIB-FIP-CEB",{"$nulls":8},{"v":50,"d":"50mm"},{"v":5,"d":"5°C"},null,null,50,70,95,115,135,150,150,150,150,150,{"$nulls":5},{"$f":"IF($I$82<2,\"NON\",IF(AND($I$82>2,$I$80<15),(4.1+0.2*$I$82),IF(AND($I$82>2,$I$80=15),(3.6+0.2*$I$82),(3.3+0.2*$I$82))))","v":{"v":3.6999999999999997,"d":"3.70tonne/m²"}}]
[{"$nulls":11},{"v":10,"d":"10°C"},null,null,40,55,70,85,100,135,150,150,150,150]
[{"$nulls":3},"Méthode CIRIA-report 108",{"$f":"$I$54","v":{"v":57.01490704238942,"d":"57.0kN/m²"}},{"$nulls":6},{"v":15,"d":"15°C"},null,null,40,45,55,65,75,100,125,150,150,150]
[{"$nulls":11},{"v":20,"d":"20°C"},null,null,35,40,45,50,55,70,90,105,125,150]
[{"$nulls":3},"Méthode DE RODIN",{"$f":"$R$56","v":{"v":49.13692094590005,"d":"49.1kN/m²"}},{"$nulls":5},{"v":75,"d":"75mm"},{"v":5,"d":"5°C"},null,null,60,85,110,140,150,150,150,150,150,150]
[{"$nulls":7},"Comparatif avec 4 Méthodes",{"$nulls":3},{"v":10,"d":"10°C"},null,null,50,65,85,105,125,150,150,150,150,150]
[{"$nulls":3},"Méthode ITPBTP",{"$f":"$E$84","v":{"v":37,"d":"37.0kN/m²"}},{"$nulls":6},{"v":15,"d":"15°C"},null,null,40,50,65,80,95,125,150,150,150,150]
[{"$nulls":11},{"v":20,"d":"20°C"},null,null,35,40,50,60,70,90,115,135,150,150]
[{"$nulls":3},"Méthode DIN 18218",{"$f":"$W$84","v":{"v":42.5,"d":"42.5kN/m²"}},{"$nulls":5},"100 \nà\n150",{"v":5,"d":"5°C"},null,null,70,100,130,150,150,150,150,150,150,150]
[{"$nulls":11},{"v":10,"d":"10°C"},null,null,55,75,100,120,150,150,150,150,150,150]
[{"$nulls":11},{"v":15,"d":"15°C"},null,null,45,60,75,90,110,150,150,150,150,150]
[{"$nulls":11},{"v":20,"d":"20°C"},null,null,35,45,55,70,80,110,130,150,150,150]
[]
[]
[]
[null,"Compartif avec une autre méthode CIRIA-report 108",{"$nulls":11},"Compartif avec une autre méthode  RODIN"]
[null,null,"Données"]
[null,null,"Hauteur =",{"$f":"$E$3","v":{"v":6,"d":"6.00m"}},{"$nulls":9},"Méthode DE RODIN"]
[null,null,"Température =",{"$f":"$E$17","v":{"v":15,"d":"15.0°C"}}]
[null,null,"Densité béton = ",{"$f":"$E$19","v":{"v":25,"d":"25kN/m3"}},{"$nulls":5},"Avec Pmax (imposée) =",{"v":55,"d":"55.0kN/m²"},{"$nulls":3},"Données"]
[null,null,"Vitesse V =",{"$f":"$E$13","v":{"v":2,"d":"2.00m/h"}},{"$nulls":5},"Vitesse V  (proposée) =",{"$f":"(((2*K48/D48)-(I60*I64*((I60^2)*(I64^2)+(4*(D46-(K48/D48))))^0.5)-((I60^2)*(I64^2)))/(2*I56))^2","v":{"v":1.7562986787614756,"d":"1.76m/h"}},{"$nulls":3},"Hauteur =",null,{"$f":"$E$3","v":{"v":6,"d":"6.00m"}}]
[{"$nulls":14},"Température =",null,{"$f":"$E$17","v":{"v":15,"d":"15.0°C"}}]
[{"$nulls":7},"Vous pouvez vérifier votre vitesse de coulage",{"$nulls":6},"Densité béton = ",null,{"$f":"$E$19","v":{"v":25,"d":"25kN/m3"}}]
[{"$nulls":7},"Avec une pression Pmax (imposée)",{"$nulls":6},"Vitesse V =",null,{"$f":"$E$13","v":{"v":2,"d":"2.00m/h"}}]
[{"$nulls":10},"  "]
[{"$nulls":7},"Pmax =",{"$f":"D48*((I56*(D49)^0.5)+(I60*I64*((D46-(I56*(D49)^0.5))^0.5)))","v":{"v":57.01490704238942,"d":"57.0kN/m²"}}]
[]
[{"$nulls":7},"Coeff C1 =",{"$f":"IF(H57=1,1,1.6)","v":{"v":1,"d":"1.0"}},{"$nulls":4},"Pmax = 39 x V^(1/3) =",{"$nulls":3},{"$f":"39*E13^(1/3)","v":{"v":49.13692094590005,"d":"49.1kN/m²"}}]
[{"$nulls":7},1]
[{"$nulls":13},"Hmax = 1,625 x V^(1/3) =",{"$nulls":3},{"$f":"1.625*E13^(1/3)","v":{"v":2.047371706079169,"d":"Hm= 2.05m"}}]
[]
[{"$nulls":7},"Coeff C2 =",{"$f":"IF(H61=1,0.3,0.45)","v":0.3},{"$nulls":4},"Avec V vitesse d’ascension du béton dans le coffrage (en m/h)"]
[{"$nulls":7},1]
[{"$nulls":14},"P max = 3.9 V 1/3"]
[{"$nulls":14},"Hm = 1.625 V 1/3"]
[{"$nulls":7},"K=",{"$f":"(36/(D47+16))^2","v":1.348595213319459}]
[]
[{"$nulls":7},"Exemple:",{"$nulls":6},"Exemple:"]
[]
[]
[]
[null,null,"Méthode ITPBTP",{"$nulls":11},"Méthode DIN 18218",{"$nulls":7},"Avec Pmax (imposée) =",{"v":80,"d":"80.0kN/m²"}]
[{"$nulls":22},"Vitesse V  (proposée) =",{"$f":"((2.08*$X$70)/$Q$75/$U$80/$S$82)-1.54","v":{"v":5.1160000000000005,"d":"5.12m/h"}}]
[null,null,"(Institut Technique Professionnel du Bâtiment et de Travaux Publics)",{"$nulls":11},"Données"]
[{"$nulls":14},"Hauteur =",null,{"$f":"$E$3","v":{"v":6,"d":"6.00m"}}]
[null,null,"V vitesse d’ascension du béton dans le coffrage (en m/h)",{"$nulls":11},"Température =",null,{"$f":"$E$17","v":{"v":15,"d":"15.0°C"}},null,null,"Vous pouvez vérifier la vitesse de coulage"]
[null,null,"A et B coefficients dépendants température q du béton (en °C) et de V.",{"$nulls":11},"Densité béton = ",null,{"$f":"$E$19","v":{"v":25,"d":"25kN/m3"}}]
[null,null,"Pmax = A + (B x V)",{"$nulls":11},"Vitesse V =",null,{"$f":"$E$13","v":{"v":2,"d":"2.00m/h"}}]
[{"$nulls":19},"Coefficient de l'adjuvant"]
[null,null,"Tableau donnant les valeurs de A + B V",{"$nulls":4},"Données",{"$nulls":11},"C2 = 0,065xTv + 1"]
[null,null,"q","V< 2 m/h","V> 2 m/h",null,null,"Hauteur =",{"$f":"$E$3","v":{"v":6,"d":"6.00m"}},{"$nulls":10},"Tv = retard de prise(h) =",{"$nulls":3},{"v":0,"d":"0.0h"}]
[null,null,"q <5 °C","2 + 1.25 V","4.1 + 0.2 V",null,null,"Température =",{"$f":"$E$17","v":{"v":15,"d":"15.0°C"}},{"$nulls":5},"Coefficient de Température :",{"$nulls":4},"C2 = ",{"$f":"(0.065*X79)+1","v":{"v":1,"d":"1.0"}}]
[null,null,"q = 15 °C","2 + 1.00 V","3.6 + 0.2 V",null,null,"Densité béton = ",{"$f":"$E$19","v":{"v":25,"d":"25kN/m3"}}]
[null,null,"15°C > q ","2 + 0.85 V","3.3 + 0.2 V",null,null,"Vitesse V =",{"$f":"$E$13","v":{"v":2,"d":"2.00m/h"}},{"$nulls":9},{"$f":"(145-3*$Q$74)/100","v":{"v":1,"d":"1.0"}}]
[]
[{"$nulls":3},"Pmax =",{"$f":"IF(AD28=\"NON\",(AD29*10),(AD28*10))","v":{"v":37,"d":"37.0kN/m²"}},{"$f":"$E$84/10","v":{"v":3.7,"d":"3.70t/m²"}},{"$nulls":15},"Pmax",{"$f":"Q75*U80*S82*((0.48*Q76)+0.74)","v":{"v":42.5,"d":"42.5kN/m²"}}]
[]
[null,null,"Exemple : q = 15 °C , V = 3 m/ h, H= 6 m"]
[null,null,"Pmax = 3.6 + 0.2 *3 =4.2 T/ m2",{"$nulls":11},"Exemple:"]

{"sheet":"Calcul-Vent-Banches","index":7,"n_rows":45,"n_cols":33,"rows_kept":45,"merged":[[0,0,0,6],[2,7,2,9],[18,1,18,4],[20,1,20,2],[30,1,31,2],[30,3,30,4],[30,5,30,6],[31,3,31,4],[34,6,34,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7]]}
["Calcul Stabilité en Vent",{"$nulls":10},"Données"]
[{"$nulls":11},"Résultats"]
["❶",null,"hauteur Coffrage h =",{"v":3,"d":"H= 3.00m"},null,"❻",{"$f":"D3/2","v":{"v":1.5,"d":"H/2 = 1.50m"}},"Equation d'équilibre"]
[]
["❷",null,"Hauteur Plot Hp =",{"v":0.5,"d":"Hp= 0.50m"},{"$nulls":5},{"$f":"D20*D3","v":{"v":5.2822428750000014,"d":"XC= 5.28kN"}}]
[]
["❸",null,"Haut Tire-Pousse=",{"v":1.5,"d":"Hti= 1.50m"}]
[{"$nulls":28},"Vitesse vent",7,1,"Nature terrain","Angles Terrain"]
["❹",null,"Largeur Tire-Pousse =",{"v":1.5,"d":"Lti= 1.50m"},{"$nulls":24},{"v":20,"d":"20.0m/s"},{"$f":"INDEX(AC9:AC39,AD8)","v":26},null,"Support béton",33]
[{"$nulls":28},{"v":21,"d":"21.0m/s"},null,null,"Remblai Déchets",20]
["❺",null,"Haut Sup Banche=",{"$f":"D3-D5-D7","v":{"v":1,"d":"Hs= 1.00m"}},{"$nulls":24},{"v":22,"d":"22.0m/s"},null,null,"Argiles /Sables",25]
[{"$nulls":6},{"$f":"CONCATENATE(\"Vérif  (\",ROUND(J15,2),\" -\",D13,\") x \",D9,\") - (\",ROUND(D21,2),\") x ((\",D3,\"/2) - \",D5,\") = 0\")","v":"Vérif  (15,52 -12) x 1,5) - (5,28) x ((3/2) - 0,5) = 0"},{"$nulls":21},{"v":23,"d":"23.0m/s"},null,null,"Marnes",30]
["❼",null,"Poids Propre P=",{"v":12,"d":"12.0kN"},{"$nulls":24},{"v":24,"d":"24.0m/s"},null,null,"Grès Calcaires",35]
[{"$nulls":28},{"v":25,"d":"25.0m/s"},null,null,"Remblai calcaire",40]
["❽",null,"Vitesse du Vent : =",{"$f":"$AD$9","v":{"v":26,"d":"26m/s"}},{"$nulls":5},{"$f":"(((D20*D3)*((D3/2)-D5))/D9)+D13","v":{"v":15.521495250000001,"d":"YB=15.5kN"}},{"$nulls":18},{"v":26,"d":"26.0m/s"}]
[null,null,"Vent (en km/h)->",{"$f":"D15*3.6","v":{"v":93.60000000000001,"d":"93.60km/h"}},{"$nulls":24},{"v":27,"d":"27.0m/s"}]
["❾",null,"Long d'influence =",{"v":2.43,"d":"Lg= 2.43m"},{"$nulls":5},{"$f":"J15-D13","v":{"v":3.521495250000001,"d":"YC= 3.5kN"}},{"$nulls":18},{"v":28,"d":"28.0m/s"}]
[null,null,"q = pression ->",{"$f":"((($D$15^2)/1.63)*1.75)","v":{"v":725.7668711656443,"d":"726Pa"}},{"$nulls":24},{"v":29,"d":"29.0m/s"}]
[null,"Pression du au Vent / par (ml )= q x Long",{"$nulls":26},{"v":30,"d":"30.0m/s"}]
[null,null," qW Vent (ml)  =",{"$f":"1.75*(($D$15)^2)/(1/(1.225/2))*D17/1000","v":{"v":1.7607476250000005,"d":"1.76kN/m"}},{"$nulls":24},{"v":31,"d":"31.0m/s"}]
["❿"," W = q Vent x H ",null,{"$f":"D20*D3","v":{"v":5.2822428750000014,"d":"= 5.28kN"}},{"$nulls":24},{"v":32,"d":"32.0m/s"}]
[{"$nulls":28},{"v":33,"d":"33.0m/s"}]
[{"$nulls":28},{"v":34,"d":"34.0m/s"}]
[{"$nulls":28},{"v":35,"d":"35.0m/s"}]
[{"$nulls":28},{"v":36,"d":"36.0m/s"}]
[{"$nulls":28},{"v":37,"d":"37.0m/s"}]
[{"$nulls":28},{"v":38,"d":"38.0m/s"}]
[{"$nulls":28},{"v":39,"d":"39.0m/s"}]
[{"$nulls":28},{"v":40,"d":"40.0m/s"}]
[{"$nulls":28},{"v":41,"d":"41.0m/s"}]
[null,"Poids du Plot =",null,{"$f":"((J5/TAN(H32*PI()/180))+J17)/10","v":{"v":1.1655435983571716,"d":"Lest = 1.17tonnes"}},null,"Choix du Sol",null,"angle ϕ",{"$nulls":20},{"v":42,"d":"42.0m/s"}]
[{"$nulls":3},{"$f":"((J5/TAN(H32*PI()/180))+J17)/1","v":{"v":11.655435983571715,"d":"Lest = 11.66kN"}},{"$nulls":3},{"$f":"INDEX(AG9:AG14,AE8)","v":{"v":33,"d":"33°"}},{"$nulls":20},{"v":43,"d":"43.0m/s"}]
[{"$nulls":6},"Tang ( ϕ )=",{"$f":"TAN(H32*PI()/180)","v":{"v":0.6494075931975106,"d":"0.64941"}},{"$nulls":20},{"v":44,"d":"44.0m/s"}]
[{"$nulls":28},{"v":45,"d":"45.0m/s"}]
[{"$nulls":6},"Nature terrain",null,"Angles Terrain",{"$nulls":19},{"v":46,"d":"46.0m/s"}]
[{"$nulls":6},"Support béton",null,{"v":33,"d":"33°"},{"$nulls":19},{"v":47,"d":"47.0m/s"}]
[{"$nulls":6},"Remblai Déchets",null,{"v":20,"d":"20°"},{"$nulls":19},{"v":48,"d":"48.0m/s"}]
[{"$nulls":6},"Argiles /Sables",null,{"v":25,"d":"25°"},{"$nulls":19},{"v":49,"d":"49.0m/s"}]
[{"$nulls":6},"Marnes",null,{"v":30,"d":"30°"},{"$nulls":19},{"v":50,"d":"50.0m/s"}]
[{"$nulls":6},"Grès Calcaires",null,{"v":35,"d":"35°"}]
[{"$nulls":6},"Remblai calcaire",null,{"v":40,"d":"40°"}]
[]
[{"$f":"(D31*10)-J17","v":{"v":8.133940733571714,"d":"YR = Lest - YC =8.13"}}]
[]
[{"$f":"J5","v":{"v":5.2822428750000014,"d":"XC= 5.28kN"}}]

{"sheet":"Calcul-Vent-Inverse","index":8,"n_rows":39,"n_cols":31,"rows_kept":39,"merged":[[0,0,0,6],[0,8,0,9],[1,15,1,19],[2,7,2,9],[18,1,18,4],[19,7,20,9],[20,1,20,2]]}
["Calcul Stabilité Vent SENS Inverse ",{"$nulls":10},"Données"]
[{"$nulls":11},"Résultats",{"$nulls":3},"VENT SENS INSERSE"]
["❶",null,"hauteur Coffrage h =",{"v":3,"d":"H= 3.00m"},null,"❻",{"$f":"D3/2","v":{"v":1.5,"d":"H/2 = 1.50m"}},"Equation d'équilibre"]
[]
["❷",null,"Hauteur Plot Hp =",{"v":0.5,"d":"Hp= 0.50m"},{"$nulls":5},{"$f":"D20*D3","v":{"v":4.500846000000001,"d":"XC= 4.50kN"}}]
[]
["❸",null,"Haut Tire-Pousse=",{"v":1.5,"d":"Hti= 1.50m"}]
[{"$nulls":28},"Vitesse vent",5,1]
["❹",null,"Largeur Tire-Pousse =",{"v":1.5,"d":"Lti= 1.50m"},{"$nulls":24},{"v":20,"d":"20.0m/s"},{"$f":"INDEX(AC9:AC39,AD8)","v":24}]
[{"$nulls":28},{"v":21,"d":"21.0m/s"}]
["❺",null,"Haut Sup Banche=",{"$f":"D3-D5-D7","v":{"v":1,"d":"Hs= 1.00m"}},{"$nulls":24},{"v":22,"d":"22.0m/s"}]
[{"$nulls":6},{"$f":"CONCATENATE(\"Vérif  (\",ROUND(J15,2),\" -\",D13,\") x \",D9,\") + (\",ROUND(D21,2),\") x ((\",D3,\"/2) - \",D5,\") = 0\")","v":"Vérif  (9 -12) x 1,5) + (4,5) x ((3/2) - 0,5) = 0"},{"$nulls":21},{"v":23,"d":"23.0m/s"}]
["❼",null,"Poids Propre P=",{"v":12,"d":"12.0kN"},{"$nulls":24},{"v":24,"d":"24.0m/s"}]
[{"$nulls":28},{"v":25,"d":"25.0m/s"}]
["❽",null,"Vitesse du Vent : =",{"$f":"$AD$9","v":{"v":24,"d":"24m/s"}},{"$nulls":5},{"$f":"(((-D20*D3)*((D3/2)-D5))/D9)+D13","v":{"v":8.999436,"d":"YB=9.0kN"}},{"$nulls":18},{"v":26,"d":"26.0m/s"}]
[null,null,"Vent (en km/h)->",{"$f":"D15*3.6","v":{"v":86.4,"d":"86.40km/h"}},{"$nulls":24},{"v":27,"d":"27.0m/s"}]
["❾",null,"Long d'influence =",{"v":2.43,"d":"Lg= 2.43m"},{"$nulls":5},{"$f":"D13-J15","v":{"v":3.0005640000000007,"d":"YC= 3.0kN"}},{"$nulls":18},{"v":28,"d":"28.0m/s"}]
[null,null,"q = pression ->",{"$f":"((($D$15^2)/1.63)*1.75)","v":{"v":618.4049079754601,"d":"618Pa"}},{"$nulls":24},{"v":29,"d":"29.0m/s"}]
[null,"Pression du au Vent / par (ml )= q x Long",{"$nulls":26},{"v":30,"d":"30.0m/s"}]
[null,null," qW Vent (ml)  =",{"$f":"1.75*(($D$15)^2)/(1/(1.225/2))*D17/1000","v":{"v":1.5002820000000003,"d":"1.50kN/m"}},{"$nulls":3},{"$f":"IF(J15>I20,\"Stabilité Assurée\",\"Attention RENVERSEMENT\")","v":"Stabilité Assurée"},{"$nulls":20},{"v":31,"d":"31.0m/s"}]
["❿"," W = q Vent x H ",null,{"$f":"D20*D3","v":{"v":4.500846000000001,"d":"= 4.50kN"}},{"$nulls":24},{"v":32,"d":"32.0m/s"}]
[{"$nulls":28},{"v":33,"d":"33.0m/s"}]
[{"$nulls":28},{"v":34,"d":"34.0m/s"}]
[{"$nulls":28},{"v":35,"d":"35.0m/s"}]
[{"$nulls":28},{"v":36,"d":"36.0m/s"}]
[{"$nulls":28},{"v":37,"d":"37.0m/s"}]
[{"$nulls":28},{"v":38,"d":"38.0m/s"}]
[{"$nulls":28},{"v":39,"d":"39.0m/s"}]
[{"$nulls":28},{"v":40,"d":"40.0m/s"}]
[{"$nulls":28},{"v":41,"d":"41.0m/s"}]
[{"$nulls":28},{"v":42,"d":"42.0m/s"}]
[{"$nulls":28},{"v":43,"d":"43.0m/s"}]
[{"$nulls":28},{"v":44,"d":"44.0m/s"}]
[{"$nulls":28},{"v":45,"d":"45.0m/s"}]
[{"$nulls":28},{"v":46,"d":"46.0m/s"}]
[{"$nulls":28},{"v":47,"d":"47.0m/s"}]
[{"$nulls":28},{"v":48,"d":"48.0m/s"}]
[{"$nulls":28},{"v":49,"d":"49.0m/s"}]
[{"$nulls":28},{"v":50,"d":"50.0m/s"}]

{"sheet":"Tige-de-Serrage","index":9,"n_rows":34,"n_cols":35,"rows_kept":34,"merged":[[0,0,0,6],[0,8,0,9],[3,0,3,2],[13,11,13,13],[25,0,25,1]]}
["Calcul Tiges de Serrage"]
[{"$nulls":28},"Mod: E"]
[{"$nulls":26},"Cont Mpa",null,{"v":200000,"d":"200,000Mpa"}]
["Hypothèses :",{"$nulls":25},{"v":500,"d":"500Mpa"},null,{"v":201000,"d":"201,000Mpa"}]
[{"$nulls":26},{"v":600,"d":"600Mpa"},null,{"v":202000,"d":"202,000Mpa"}]
[null,"Pression du Béton=",{"v":75,"d":"75.0Kpa"},{"$nulls":23},{"v":700,"d":"700Mpa"},null,{"v":203000,"d":"203,000Mpa"}]
[{"$nulls":26},{"v":800,"d":"800Mpa"},null,{"v":204000,"d":"204,000Mpa"}]
[null,"Largeur d'influence = ",{"v":1.1,"d":"X = 1.10m"},{"$nulls":23},{"v":900,"d":"900Mpa"},null,{"v":205000,"d":"205,000Mpa"}]
[{"$nulls":26},{"v":1000,"d":"1,000Mpa"},null,{"v":206000,"d":"206,000Mpa"}]
[null,"Hauteur d'influence=",{"v":1.5,"d":"Y = 1.50m"},{"$nulls":23},{"v":1100,"d":"1,100Mpa"},null,{"v":207000,"d":"207,000Mpa"}]
[{"$nulls":28},{"v":208000,"d":"208,000Mpa"}]
[null,"Surface d'influence=",{"$f":"C8*C10","v":{"v":1.6500000000000001,"d":"1.65m²"}},{"$nulls":25},{"v":209000,"d":"209,000Mpa"}]
[{"$nulls":28},{"v":210000,"d":"210,000Mpa"}]
[null,"Effort de traction ( N ) =",{"$f":"C6*C12","v":{"v":123.75000000000001,"d":"123.8kN"}},{"$nulls":8},"Module de Young  (Mpa) E =→",null,null,{"v":200000,"d":"200,000.0Mpa"},{"$nulls":11},"epsi","Force","Diam 15","Diam 20","Diam 26,5",null,{"$f":"B32","v":15},{"$f":"B33","v":20},{"$f":"B34","v":26.5}]
[{"$nulls":26},{"v":0,"d":"0mm/m"},{"v":0,"d":"0kN"},{"$f":"(AG15/$O$14)*1000","v":{"v":0,"d":"0.00mm/m"}},{"v":0,"d":"0.00mm/m"},{"v":0,"d":"0.00mm/m"},null,{"$f":"AB15*1000/$C$32","v":{"v":0,"d":"0Mpa"}},{"$f":"AG15*1000/$C$32","v":{"v":0,"d":"0Mpa"}},{"$f":"AH15*1000/$C$32","v":{"v":0,"d":"0Mpa"}}]
[null,"Contrainte limite  ( fy )=",{"v":900,"d":"900.0Mpa"},{"$nulls":23},{"v":1,"d":"1mm/m"},{"v":50,"d":"50kN"},{"v":1.414710605261292,"d":"1.41mm/m"},{"v":0.7957747154594768,"d":"0.80mm/m"},{"v":0.45327146483985853,"d":"0.45mm/m"},null,{"v":282.9421210522584,"d":"283Mpa"},{"$f":"AB16*1000/$C$33","v":{"v":159.15494309189535,"d":"159Mpa"}},{"$f":"AB16*1000/$C$34","v":{"v":90.65429296797171,"d":"91Mpa"}}]
[{"$nulls":26},{"v":2,"d":"2mm/m"},{"v":100,"d":"100kN"},{"v":2.829421210522584,"d":"2.83mm/m"},{"v":1.5915494309189535,"d":"1.59mm/m"},{"v":0.9065429296797171,"d":"0.91mm/m"},null,{"v":565.8842421045168,"d":"566Mpa"},{"$f":"AB17*1000/$C$33","v":{"v":318.3098861837907,"d":"318Mpa"}},{"$f":"AB17*1000/$C$34","v":{"v":181.30858593594343,"d":"181Mpa"}}]
[{"$nulls":26},{"v":3,"d":"3mm/m"},{"v":150,"d":"150kN"},{"v":4.244131815783876,"d":"4.24mm/m"},{"v":2.38732414637843,"d":"2.39mm/m"},{"v":1.3598143945195755,"d":"1.36mm/m"},null,{"v":848.8263631567752,"d":"849Mpa"},{"$f":"AB18*1000/$C$33","v":{"v":477.464829275686,"d":"477Mpa"}},{"$f":"AB18*1000/$C$34","v":{"v":271.9628789039151,"d":"272Mpa"}}]
[{"$nulls":21},{"$f":"O14*1","v":200000},{"$nulls":4},{"v":4,"d":"4mm/m"},{"v":200,"d":"200kN"},{"v":5.658842421045168,"d":"5.66mm/m"},{"v":3.183098861837907,"d":"3.18mm/m"},{"v":1.8130858593594341,"d":"1.81mm/m"},null,{"v":1131.7684842090337,"d":"1,132Mpa"},{"$f":"AB19*1000/$C$33","v":{"v":636.6197723675814,"d":"637Mpa"}},{"$f":"AB19*1000/$C$34","v":{"v":362.61717187188685,"d":"363Mpa"}}]
[{"$nulls":26},{"v":5,"d":"5mm/m"},{"v":250,"d":"250kN"},{"v":7.07355302630646,"d":"7.07mm/m"},{"v":3.9788735772973833,"d":"3.98mm/m"},{"v":2.2663573241992925,"d":"2.27mm/m"},null,{"v":1414.710605261292,"d":"1,415Mpa"},{"$f":"AB20*1000/$C$33","v":{"v":795.7747154594766,"d":"796Mpa"}},{"$f":"AB20*1000/$C$34","v":{"v":453.27146483985854,"d":"453Mpa"}}]
[]
[null,"Coeff. sécurité (γQ)=",1.5]
[]
[null,"Section (Mini) =",{"$f":"$C$22*($C$14*1000)/$C$16","v":{"v":206.25000000000003,"d":"206mm²"}}]
[null,{"$f":"IF(C24<C32,1,MATCH(C24,C32:C34,1)+1)","v":2},{"$f":"INDEX(A32:A34,B25)","v":{"v":23,"d":"23.0mm"}}]
["Diamètre nominal =",null,{"$f":"IF(B25>3,\"Pas Tige dispo \",CONCATENATE(\"φ \",C25,\" mm\"))","v":"φ 23 mm"}]
[]
["Diamètre des tiges disponibles:"]
["Diamètre","Diamètre","Section"]
["nominal","du noyau"]
["mm","mm","mm²"]
[17,15,{"$f":"B32^(2)*PI()/4","v":{"v":176.71458676442586,"d":"177mm²"}}]
[23,20,{"$f":"B33^(2)*PI()/4","v":{"v":314.1592653589793,"d":"314mm²"}}]
[30,26.5,{"$f":"B34^(2)*PI()/4","v":{"v":551.5458602458581,"d":"552mm²"}}]

{"sheet":"Lam-Colle-calcul","index":10,"n_rows":16,"n_cols":26,"rows_kept":16,"merged":[[0,8,0,9],[12,10,13,10]]}
["RESISTANCE A LA FLEXION LAMELLE COLLE",{"$nulls":7},"Retour Menu"]
[]
["Moment fléchissant (MF)","kN.m",5.53,{"$nulls":5},"Données"]
["Hauteur poutre (h)","mm",205,{"$nulls":5},"Résultats"]
["Largeur poutre (b)","mm",75,{"$nulls":22},{"$f":"(2.38-($C4/250))*(1+($C3/(12*$C4)))","v":{"v":1.5635068292682925,"d":"1.56"}}]
["sm,d","N/mm²",{"$f":"C3*1000000/(C4^2)*6/C5","v":{"v":10.527067221891732,"d":"10.53"}},{"$nulls":22},{"$f":"(2.38-($C4/250))*(1+($C3/(6*$C4)))","v":{"v":1.5670136585365855,"d":"1.57"}}]
[]
[]
[]
["fm,k","N.mm²",{"v":22,"d":"22.0"},{"$nulls":5},{"$f":"I13","v":{"v":10.527067221891732,"d":"10.5"}},{"$f":"IF(I10<K10,\"<\",\">\")","v":"<"},{"$f":"I14","v":{"v":12.509538461538462,"d":"12.5"}},"(N/mm²)"]
["kmod",null,0.8]
["gM",null,1.3]
["fm,d","N/mm²",{"$f":"C10*C11/C12","v":{"v":13.538461538461538,"d":"13.5"}},{"$nulls":5},{"$f":"C6","v":{"v":10.527067221891732,"d":"10.5"}},null,{"$f":"C6/C13/C14/C15/C16","v":{"v":0.8415232307936868,"d":"84%"}}]
["kh (coef de hauteur)",null,{"v":1,"d":"1.00"},{"$nulls":5},{"$f":"C13*C14*C15*C16","v":{"v":12.509538461538462,"d":"12.5"}}]
["kls (effet système)",null,{"v":1.1,"d":"1.10"},{"$nulls":5},"(N/mm²)"]
["kcrit (déversement latéral)",null,0.84]

{"sheet":"Tableaux Lamellé-Collé","index":11,"n_rows":32,"n_cols":16,"rows_kept":32,"merged":[[0,15,8,15]]}
["Caractéristiques","Symbole",null,"C14","C16","C18","C22","C24","C27","C30","C35","C40",{"$nulls":3},"RETOUR MENU"]
["Flexion","fm,k",null,14,16,18,22,24,27,30,35,40,null,"N/mm²"]
["Traction axiale","ft,0,k",null,8,10,11,13,14,16,18,21,24,null,"N/mm²"]
["Traction transversale","ft,90,k",null,0.3,0.3,0.3,0.3,0.4,0.4,0.4,0.4,0.4,null,"N/mm²"]
["Compression axiale","fc,0,k",null,16,17,18,20,21,232,23,25,26,null,"N/mm²"]
["Compression transversale","fc,90,k",null,4.3,4.6,4.8,5.1,5.3,5.6,5.7,6,6.3,null,"N/mm²"]
["Cisaillement","fv,k",null,1.7,1.8,2,2.4,2.5,2.8,3,3.4,3.8,null,"N/mm²"]
["Module moyen d'élasticité axial","E0,moy",null,7,8,9,10,11,12,12,13,14,null,"kN/mm²"]
["Module d'élasticité axial au fractile 5%","E0,0.5",null,4.7,5.4,6,6.7,7.4,8,8,8.7,9.4,null,"kN/mm²"]
["Masse volumique moyenne","rmoy",null,350,370,380,410,420,450,460,480,500,null,"kg/m3"]
[]
["Caractéristiques","Symbole",null,"GL24h","GL28h","GL32h","GL36h",null,"GL24c","GL28c","GL32c","GL36c"]
["Flexion","fm,k",null,24,28,32,36,null,24,28,32,36,null,"N/mm²"]
["Traction axiale","ft,0,k",null,16.5,19.5,22.5,26,null,14,16.5,19.5,22.5,null,"N/mm²"]
["Traction transversale","ft,90,k",null,0.4,0.45,0.5,0.6,null,0.35,0.4,0.45,0.5,null,"N/mm²"]
["Compression axiale","fc,0,k",null,24,26.5,29,31,null,21,24,26.5,29,null,"N/mm²"]
["Compression transversale","fc,90,k",null,2.7,3,3.3,3.6,null,2.4,2.7,3,3.3,null,"N/mm²"]
["Cisaillement","fv,k",null,2.7,3.2,3.8,4.3,null,2.2,2.7,3.2,3.8,null,"N/mm²"]
["Module moyen d'élasticité axial","E0,moy",null,11.6,12.6,13.7,14.7,null,11.6,12.6,13.7,14.7,null,"kN/mm²"]
["Module d'élasticité axial au fractile 5%","E0,0.5",null,9.4,10.2,11.1,11.9,null,9.4,10.2,11.1,11.9,null,"kN/mm²"]
["Masse volumique moyenne","rmoy",null,440,480,520,560,null,420,460,500,540,null,"kg/m3"]
[]
["Caractéristiques","Symbole",null,"D30","D35","D40","D50","D60","D70"]
["Flexion","fm,k",null,30,35,40,50,60,70,{"$nulls":4},"N/mm²"]
["Traction axiale","ft,0,k",null,18,21,24,30,36,42,{"$nulls":4},"N/mm²"]
["Traction transversale","ft,90,k",null,0.6,0.6,0.6,0.6,0.7,0.9,{"$nulls":4},"N/mm²"]
["Compression axiale","fc,0,k",null,23,25,26,29,32,34,{"$nulls":4},"N/mm²"]
["Compression transversale","fc,90,k",null,8,8.4,8.8,9.7,10.5,13.5,{"$nulls":4},"N/mm²"]
["Cisaillement","fv,k",null,3,3.4,3.8,4.6,5.3,6,{"$nulls":4},"N/mm²"]
["Module moyen d'élasticité axial","E0,moy",null,10,10,11,14,17,20,{"$nulls":4},"kN/mm²"]
["Module d'élasticité axial au fractile 5%","E0,0.5",null,8,8.7,9.4,11.8,14.3,16.8,{"$nulls":4},"kN/mm²"]
["Masse volumique moyenne","rmoy",null,650,680,720,790,840,1090,{"$nulls":4},"kg/m3"]

{"sheet":"Feuil1","index":12,"n_rows":0,"n_cols":0,"rows_kept":0}