{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Albix (2)"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Albix (2)","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"merged":[[14,3,14,4],[14,5,14,6],[31,0,31,1]],"flags":["formulas_cached_only"]}
[]
["Charges Fixe","DaN/m2","Largeur chargée",{"$nulls":3},"daN/ml"]
["Hourdis 16+4",285,3.35,{"$nulls":3},{"v":954.75,"d":"954.8"}]
["chainage 15 x 20",500,0.15,{"$nulls":3},{"v":75,"d":"75.0"}]
["Plancher bois",30,3.5,{"$nulls":3},{"v":105,"d":"105.0"}]
["Enduit platre plafond",20,3.35,{"$nulls":3},{"v":67,"d":"67.0"}]
["Cloisons briques platrières 30mm",50,3.5,{"$nulls":3},{"v":175,"d":"175.0"}]
["Linteau acier",{"$nulls":5},{"v":30,"d":"30.0"}]
["Habillage linteau",{"$nulls":5},{"v":60,"d":"60.0"}]
["Sous-total charges fixes",{"$nulls":4},"G =",{"v":1466.75,"d":"1,466.8"}]
["Charges d'exploitation",150,3.5,null,null,"Q = ",{"v":525,"d":"525.0"}]
[]
[]
["Portée ouverture (m)",3]
[null,null,"Profilés","Moments d'inerties (mm4)",null,"Modules de résistance"]
["Réparti sur la poutre ELU (1.35 G + 1.5 Q) daN/ml",{"v":2767.6125,"d":"2,767.6"},null,"Ix","Iy","Ix/Vx","Iy/Vy"]
["Réparti sur la poutre ELS (G + Q) daN/ml",{"v":1991.75,"d":"1,991.8"},"HEA160",{"v":16730000,"d":"16,730,000"},{"v":6160000,"d":"6,160,000"},{"v":220000,"d":"220,000"},{"v":77000,"d":"77,000"}]
["ElU (N/mm)",{"v":27.676125000000003,"d":"27.7"},"HEA180",{"v":25100000,"d":"25,100,000"},{"v":9250000,"d":"9,250,000"},{"v":294000,"d":"294,000"},{"v":103000,"d":"103,000"}]
["ELS ( N/mm)",{"v":19.9175,"d":"19.9"},"HEB160",{"v":24920000,"d":"24,920,000"},{"v":8890000,"d":"8,890,000"},{"v":311000,"d":"311,000"},{"v":111000,"d":"111,000"}]
["Portée ouverture (mm)",{"v":3000,"d":"3,000"},"HEB180",{"v":38310000,"d":"38,310,000"},{"v":13630000,"d":"13,630,000"},{"v":426000,"d":"426,000"},{"v":151000,"d":"151,000"}]
[]
[null,"HEA160 Ap encast","HEA160 Ap simples","HEB160 Ap encast","HEB160  Ap simples"]
["Réaction aux appuis (N) ELS",{"v":29876.25,"d":"29,876"},{"v":29876.25,"d":"29,876"},{"v":29876.25,"d":"29,876"},{"v":29876.25,"d":"29,876"}]
["Moment de flexion aux appuis(N.mm)",{"v":20757093.750000004,"d":"20,757,094"},0,{"v":20757093.750000004,"d":"20,757,094"},0]
["Moment de flexion en travée (N.mm)",{"v":10378546.875000002,"d":"10,378,547"},{"v":31135640.625000004,"d":"31,135,641"},{"v":10378546.875000002,"d":"10,378,547"},{"v":31135640.625000004,"d":"31,135,641"}]
["Contrainte maximale ELU   N/mm² (Mpa)",{"v":94.35042613636365,"d":"94"},{"v":141.52563920454548,"d":"142"},{"v":66.74306672025725,"d":"67"},{"v":100.11460008038587,"d":"100"}]
["Taux de travail S 235  (gamma 1.1)",{"v":0.4416402925531916,"d":"44%"},{"v":0.6624604388297874,"d":"66%"},{"v":0.3124143548607787,"d":"31%"},{"v":0.46862153229116793,"d":"47%"}]
["Fléche maximale (mm) + 5% cisaillement",{"v":1.255632891885834,"d":"1.26"},{"v":6.27816445942917,"d":"6.28"},{"v":0.8429670257323436,"d":"0.84"},{"v":4.2148351286617185,"d":"4.21"}]
["Ratio Fléche   :  L / ",{"v":2389.2333654100944,"d":"2,389"},{"v":477.84667308201887,"d":"478"},{"v":3558.858067305412,"d":"3,559"},{"v":711.7716134610823,"d":"712"}]
["Ratio Fléche admissible : L /",{"v":1000,"d":"1,000"}]
[]
["Appuis sur parpaings BC40 4Mpa (Limite admissible 2MPa)",null,2]
["Lg appui (mm)",200]
["Larg appui (mm)",150]
["Surf appui (mm²)",{"v":30000,"d":"30,000"}]
["Contrainte appuis (N/mm² ou MPa)",{"v":1.99175,"d":"1.99"},"contrainte maxi, en répartition triangulaire = 2 contrainte moyenne"]