{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Feuil1","index":0,"n_rows":42,"n_cols":10,"rows_kept":42,"flags":["formulas_cached_only"]}
[]
[]
[null,"Section ",{"$nulls":4},"Charges linéiques"]
[null,"h",null,22.5,"cm"]
[null,"b",null,5,"cm",null,"Vertical, par ml de longueur de versant"]
[null,"réduction   hum %",null,0.98,null,null,"Toit  PP",null,{"v":30,"d":"30.0"},"daN/ml"]
[null,"h   calcul",null,22.05,"cm",null,"Neige  S",null,{"v":20.05529386062773,"d":"20.1"},"daN/ml"]
[null,"b   calcul",null,4.9,"cm",null,"soit "]
[null,"I  (bh3/12)",null,{"v":4377.645759375001,"d":"4,377.6"},"cm4",null,"Toit  PP",null,{"v":0.3,"d":"0.30"},"daN/cm"]
[null,"I/v (bh²/6)",null,{"v":397.0653750000001,"d":"397.1"},"cm3",null,"Neige  S",null,{"v":0.20055293860627732,"d":"0.20"},"daN/cm"]
[null,"S (b h)",null,{"v":108.04500000000002,"d":"108.0"},"cm²"]
[{"$nulls":6},"ELU"]
[null,"Travée"]
[null,"angle",null,21.8,"°",null,"Flexion perpendiculaire au versant"]
[null,"cos ",null,{"v":0.9284858268809135,"d":"0.9285"}]
[null,"sin",null,{"v":0.37136783555023484,"d":"0.3714"},null,null,"p = (1.35G+1.5S) x cos",null,{"v":0.6553526014396398,"d":"0.66"},"daN/cm"]
[null,"L",null,595,"cm"]
[null,"entraxe e",null,0.6,"m",null,"Mo ELU (pL²/8)",null,{"v":29001.40059058356,"d":"29,001.4"},"daN x cm"]
[]
[null,"Matériau",{"$nulls":4},"sigma m,d  =  (M/I/v)",null,{"v":73.03935930093012,"d":"73.0"},"daN/cm²"]
[{"$nulls":6},"soit, en flexion :",null,{"v":7.303935930093012,"d":"7.3"},"Mpa"]
[null,"F,m,k (flexion)",null,24,"Mpa"]
[null,"F,t,k (traction)",null,14,null,null,"Traction à mi portée, parallèle au versant"]
[null,"gamma",null,1.3]
[null,"kmod (neige)",null,0.9,null,null,"linéique versant"]
[null,"F,m,d (F,m,k x Kmod/gam)",null,{"v":16.615384615384617,"d":"16.6"},"Mpa",null,"p = (1.35G+1.5S) x sin",null,{"v":0.26212233948302366,"d":"0.26"},"daN/cm"]
[null,"F,t,d",null,{"v":9.692307692307692,"d":"9.7"},"Mpa",null,"Effort au milieu (p x L/2)   T =",null,{"v":77.98139599619954,"d":"78.0"},"daN"]
[{"$nulls":6},"sigma t,d (T/S)",null,{"v":0.7217492340802399,"d":"0.7"},"daN/cm²"]
[null,"E ",null,{"v":11000,"d":"11,000"},"Mpa",null,"soit, en traction ",null,{"v":0.07217492340802399,"d":"0.07"},"MPa"]
[null,"Soit E =",null,{"v":110000,"d":"110,000"},"daN/cm²"]
[null,"G",null,{"v":6900,"d":"6,900"},"daN/cm²"]
[null,"coef fluage Kdef",null,0.8,null,null,"ELS       en direction perpendiclaire au versant"]
[]
[null,"Charges",{"$nulls":4},"flèche PP (5gl4/384EI) x cos",null,{"v":0.9439953951025808,"d":"0.94"},"cm"]
[{"$nulls":6},"fluage (du à PP)",null,{"v":0.7551963160820647,"d":"0.76"},"cm"]
[null,"Toit (y c bois)        PP =",null,{"v":50,"d":"50.0"},"daN/m²",null,"neige",null,{"v":0.6310701683953878,"d":"0.63"},"cm"]
[null,"(vertical par m² de versant)",{"$nulls":4},"net final  en flexion",null,{"v":2.3302618795800334,"d":"2.33"},"cm"]
[]
[null,"Neige en proj H         Sk =",null,{"v":45,"d":"45.0"},"daN/m²",null,"flèche PP (gl²/(8GS x 5/6)) x cos",null,{"v":0.019841201121604847,"d":"0.02"},"cm"]
[null,"µ   (Eurcod 1) =",null,0.8,null,null,"fluage (du à G)",null,{"v":0.015872960897283878,"d":"0.02"},"cm"]
[null,"Neige proj H    Sd = mu x S  =",null,{"v":36,"d":"36.0"},"daN/m²",null,"neige",null,{"v":0.013264037301386726,"d":"0.01"},"cm"]
[null,"(vertical par m² de versant)",null,{"v":33.42548976771289,"d":"33.4"},"daN/m²",null,"net final  en cisaillement",null,{"v":0.04897819932027545,"d":"0.05"},"cm"]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}