{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Couverture","Dalle","Data G","Data Q","Explication"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Couverture","index":0,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Projet:","B2B "]
[null,"Numero de projet: 2026"]
[]
[]
[]
[null,"Adresse:"]
[]
[null,"…"]
[null,"…"]
[null,"…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ing: Oussama Rouchdi"]
["www.oussamarouchdi.com",null,null,"Contact","n'hesitez pas a me contacter"]
["2026-12-31"]

{"sheet":"Dalle","index":1,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Niveaux",3]
[null,null,null,null,null,null,null,null,"G",5,3,5]
[null,null,null,null,null,null,null,null,"Q",2,1,3]
[]
[]
["Niveau 1"]
["G"]
["Couches","Matériaux","Poids volumique","Épaisseur","Résultat (kN/m²)"]
[1,"Beton armee",{"$f":"IFERROR(VLOOKUP(B15,'Data G'!A:B,2,FALSE),\"\")","v":25},0.2,{"$f":"IF(AND(C15<>\"\",D15<>\"\"),C15*D15,\"\")","v":5}]
[2,"mortier de chaux et de ciment",{"$f":"IFERROR(VLOOKUP(B16,'Data G'!A:B,2,FALSE),\"\")","v":20},0.1,{"$f":"IF(AND(C16<>\"\",D16<>\"\"),C16*D16,\"\")","v":2}]
[3,"Gravier de pierre ponce",{"$f":"IFERROR(VLOOKUP(B17,'Data G'!A:B,2,FALSE),\"\")","v":7.0000000000000007E-2},1,{"$f":"IF(AND(C17<>\"\",D17<>\"\"),C17*D17,\"\")","v":7.0000000000000007E-2}]
[4,null,{"$f":"IFERROR(VLOOKUP(B18,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C18<>\"\",D18<>\"\"),C18*D18,\"\")","v":""}]
[5,null,{"$f":"IFERROR(VLOOKUP(B19,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C19<>\"\",D19<>\"\"),C19*D19,\"\")","v":""}]
[null,null,null,"Total G",{"$f":"SUM(E15:E19)","v":7.07}]
[]
["Q"]
["Couches","Type (sk / wk / qk)","Catégorie","Valeur (kN/m²)","Résultat (kN/m²)"]
[1,"sk","neige",{"$f":"IF(B24=\"qk\",IFERROR(VLOOKUP(C24,'Data Q'!H:I,2,FALSE),\"\"),\"\")","v":""},0.68]
[2,"wk",null,{"$f":"IF(B25=\"qk\",IFERROR(VLOOKUP(C25,'Data Q'!H:I,2,FALSE),\"\"),\"\")","v":""},0.25]
[null,null,null,"Total Q (qk seulement)",{"$f":"SUMIF(B24:B25,\"qk\",E24:E25)","v":0}]
[]
["Niveau 2"]
["G"]
["Couches","Matériaux","Poids volumique","Épaisseur","Résultat (kN/m²)"]
[1,null,{"$f":"IFERROR(VLOOKUP(B31,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C31<>\"\",D31<>\"\"),C31*D31,\"\")","v":""}]
[2,null,{"$f":"IFERROR(VLOOKUP(B32,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C32<>\"\",D32<>\"\"),C32*D32,\"\")","v":""}]
[3,null,{"$f":"IFERROR(VLOOKUP(B33,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C33<>\"\",D33<>\"\"),C33*D33,\"\")","v":""}]
[null,null,null,"Total G",{"$f":"SUM(E31:E33)","v":0}]
[]
["Q"]
["Couches","Type (sk / wk / qk)","Catégorie","Valeur (kN/m²)","Résultat (kN/m²)"]
[1,"qk","A3",{"$f":"IF(B38=\"qk\",IFERROR(VLOOKUP(C38,'Data Q'!H:I,2,FALSE),\"\"),\"\")","v":2},{"$f":"D38","v":2}]
[null,null,null,"Total Q (qk seulement)",{"$f":"SUMIF(B38:B38,\"qk\",E38:E38)","v":2}]
[]
["Niveau 3"]
["G"]
["Couches","Matériaux","Poids volumique","Épaisseur","Résultat (kN/m²)"]
[1,null,{"$f":"IFERROR(VLOOKUP(B44,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C44<>\"\",D44<>\"\"),C44*D44,\"\")","v":""}]
[2,null,{"$f":"IFERROR(VLOOKUP(B45,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C45<>\"\",D45<>\"\"),C45*D45,\"\")","v":""}]
[3,null,{"$f":"IFERROR(VLOOKUP(B46,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C46<>\"\",D46<>\"\"),C46*D46,\"\")","v":""}]
[4,null,{"$f":"IFERROR(VLOOKUP(B47,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C47<>\"\",D47<>\"\"),C47*D47,\"\")","v":""}]
[5,null,{"$f":"IFERROR(VLOOKUP(B48,'Data G'!A:B,2,FALSE),\"\")","v":""},null,{"$f":"IF(AND(C48<>\"\",D48<>\"\"),C48*D48,\"\")","v":""}]
[null,null,null,"Total G",{"$f":"SUM(E44:E48)","v":0}]
[]
["Q"]
["Couches","Type (sk / wk / qk)","Catégorie","Valeur (kN/m²)","Résultat (kN/m²)"]
[1,"qk","q",{"$f":"IF(B53=\"qk\",IFERROR(VLOOKUP(C53,'Data Q'!H:I,2,FALSE),\"\"),\"\")","v":0},{"$f":"D53","v":0}]
[2,null,null,{"$f":"IF(B54=\"qk\",IFERROR(VLOOKUP(C54,'Data Q'!H:I,2,FALSE),\"\"),\"\")","v":""},{"$f":"D54","v":""}]
[3,null,null,{"$f":"IF(B55=\"qk\",IFERROR(VLOOKUP(C55,'Data Q'!H:I,2,FALSE),\"\"),\"\")","v":""},{"$f":"D55","v":""}]
[null,null,null,"Total Q (qk seulement)",{"$f":"SUMIF(B53:B55,\"qk\",E53:E55)","v":0}]

{"sheet":"Data G","index":2,"n_rows":116,"n_cols":7,"rows_kept":116,"cut":false,"hidden":false,"merged":[[99,2,100,3]]}
[]
[]
[]
[]
[]
[]
[]
["Beton",24]
["Beton armee",25]
["mortier de ciment",23]
["mortier de plâtre",18]
["mortier de chaux et de ciment",20]
["mortier de chaux",18,null,null,null,null," "]
["granite, syénite, porphyre",27]
["basalte, diorite, gabbro",31]
["tachylite",26]
["lave basaltique",24]
["grauwacke, grès",27]
["calcaire dense",29]
["autres calcaires",20]
["tuff volcanique",20]
["gneiss",30]
["ardoise",28]
["éléments en terre cuite",21]
["Parquet en bois massif ",7.5]
["Parquet en bois contrecollé",7]
["Parquet stratifié",6]
["Carrelage en ceramique",26]
["Carrelage pierre natruelle",30]
["Marbre",28]
[]
["Aluminuim",27]
["Bronze",83]
["Gusseisen",71]
["Kupfer",87]
["Stahl ",78.5]
["Zink",72]
[]
[]
["Glas",25]
["Profilbauglas einschalig",27]
["Zweischalig",54]
["Acrylscheiben",12]
["Glasschaum",1.4]
["Polystyrol augeschäumt",0.3]
[]
["bois classe de résistance C14",3.5]
["bois classe de résistance C16",3.7]
["bois classe de résistance C18",3.8]
["boisclasse de résistance C22",4.0999999999999996]
["bois classe de résistance C24",4.2]
["bois classe de résistance C27",4.5]
["bois classe de résistance C30",4.5999999999999996]
["bois classe de résistance C35",4.8]
["bois classe de résistance C40",5]
["bois classe de résistance D30",6.4]
["bois classe de résistance D35",6.7]
["bois classe de résistance D40",7]
["bois classe de résistance D50",7.8]
["bois classe de résistance D60",8.4]
["bois classe de résistance D70",10.8]
["résineux",5]
["bouleau",7]
["panneaux lamellés et panneaux lattés",4.5]
["panneaux de particules",7]
["panneaux de fibragglo",12]
["parallam, panneaux de lamelles minces orientées (OSB), wafer board",7]
["panneaux durs et extra-durs",10]
["panneaux de fibres de moyenne densité (MDF)",8]
["panneaux tendres",4]
["aluminium",27]
["laiton",85]
["bronze",85]
["cuivre",89]
["fonte",72]
["fer forgé",76]
["plomb",114]
["acier",78.5]
["zinc",72]
["verre brisé",22]
["verre en feuilles",25]
["matières plastiques"]
["plaques acryliques",12]
["billes de polystyrène expansé",0.3]
["mousse de verre expansé",1.4]
[" Polystyrène expansé (EPS)",0.4]
["Polystyrène extrudé (XPS)",0.6]
["Polyuréthane (PUR / PIR)",0.6]
["Laine de roche",1.8]
["Laine de verre",1.2]
["Liège expansé",1]
["Film polyéthylène (PE) 0,15 mm - 0,3 mm",0.15]
["Membrane bitumineuse",2.5]
["Feuille d’aluminium avec renfort PE",1]
["Enduit d’étanchéité bitumeux (couche liquide)",2.5]
["Kn/m²","kN/m²"]
["Gravier de pierre ponce",7.0000000000000007E-2]
["Plaque d’asphalte",0.22]
["Plaque de perlite",0.02]
["Toiture végétalisée intensive",10,"il y a autre"]
["Toiture végétalisée extensive",1]
["panneaux solaires",0.25]
["Tuile en béton",0.5]
["Toiture en tôle d’aluminium",0.25]
["Trapezblech\nToiture en tôle d’aluminium profilée trapézoïdale",0.05]
["Toiture à double joint debout en zinc-titane",0.35]
["Toiture en tôle ondulée",0.25]
["Membrane bitumineuse",7.0000000000000007E-2]
["Béton bitumineux",0.24]
["Mastic asphaltique",0.18]
["Asphalte coulé",0.23]
["Chape",0.22]
["Vitres / panneaux de verre",0.25]
["Caoutchouc",0.15]
["Carreaux en céramique",0.22]
["Revêtement de sol en plastique (PVC par ex.)",0.15]

{"sheet":"Data Q","index":3,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,7,2,9]]}
[]
[null,null,null,null,null,null,null,"q"]
[null,null,null,null,null,null,null,"Donnees"]
["A","A1 : Combles / greniers non destinés à l’habitation",null,null,null,null,null,"A1",1,1]
[null,"Combles non aménagés pour l’habitation mais accessibles, avec une hauteur libre ≤ 1,80 m.",null,null,null,null,null,"A2",1.5]
[null,"A2 : Pièces d’habitation et pièces de séjour",null,null,null,null,null,"A3",2,1]
["B","A3 : Couloirs",null,null,null,null,null,"B1",2,2]
[null,"B1 : Couloirs et cuisines dans certains bâtiments",null,null,null,null,null,"B2",3,3]
[null,"B2 : Locaux médicaux et caves",null,null,null,null,null,"B3",5,4]
["C","B3 : Locaux avec équipements lourds",null,null,null,null,null,"C1",3,4]
[null,"C1 : Espaces avec tables",null,null,null,null,null,"C2",4,4]
[null,"C2 : Espaces avec sièges fixes",null,null,null,null,null,"C3",5,4]
[null,"C3 : Espaces accessibles au public",null,null,null,null,null,"C4",5,7]
[null,"C5 : Locaux susceptibles d’être surpeuplés, ex. salles de concert, salles de sport y compris tribunes et aires d'accès.",null,null,null,null,null,"C5",5,4]
[null,"C4 : Espaces sportifs ou d’activités",null,null,null,null,null,"C6",7.5,10]
[null,"C5 : Grandes assemblées de personnes",null,null,null,null,null,"D1",2,2]
[null,"C6 : Grandes foules régulières",null,null,null,null,null,"D2",5,4]
["D","D1 : Petits commerces",null,null,null,null,null,"D3",5,7]
[null,"D2 : Magasins et grands commerces",null,null,null,null,null,"E1.1",5,4]
[null,"D3 : Magasins avec charges ponctuelles élevées",null,null,null,null,null,"E1.2",6,7]
["E","E1 : Surfaces dans des usines et ateliers avec exploitation légère, ainsi que surfaces dans les bâtiments d’élevage.",null,null,null,null,null,"E2.1",7.5,10]
[null,"E2 : Surfaces générales de stockage, y compris bibliothèques.",null,null,null,null,null,"T1",5,2]
[null,"Surfaces dans les usines et ateliers avec exploitation moyenne ou lourde.",null,null,null,null,null,"T2",5,2]
[null,"T1 : Escaliers et paliers dans les bâtiments d’habitation, les immeubles de bureaux et les cabinets médicaux sans équipement lourd.",null,null,null,null,null,"T3",7.5,3]
[null,"T2 : Tous les escaliers et paliers qui ne peuvent pas être classés dans les catégories T1 ou T3.",null,null,null,null,null,"Z",4,2]
[null,"T3 : Accès et escaliers de tribunes sans sièges fixes servant également de voies d’évacuation."]
[null,"F1 : Surfaces de circulation pour véhicules légers <30kN"]
[null,"F2 : Rampes d’accès pour véhicules (rampes de parking)",null,null,null,null,null,"F1",3,20]
[null,"H : Toitures accessibles uniquement pour l’entretien",null,null,null,null,null,"F2",5,20]
[]
[null,null,null,null,null,null,null,"H",null,1]
[null,null,null,null,null,null,null,"vent"]
[null,null,null,null,null,null,null,"neige"]

{"sheet":"Explication","index":4,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Fichier pour le calcul de Charges"]
[]
[null,null,"il suffit de choisir nbre de niveaux, et mettre pour chaque niveau le nbre de couche G et Q "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"J ai mis plusieurs Materiaux dans Data G Attention sous kN/m² ils sont tous en kN/m², donc sur il ne faut pas ajouter l eipaisseur , il faut mettre 1"]
[null,null,"Il faut generalement choisir les Mateiraux et mettre et ajouter l epaisseur (ou 1) par exemple beton armee 0,2 le resultat et le Total se calcul seul"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Pour Q, il y a sk c est la neige vous pouvez l ajouter manuellement, et wk pour le vent aussi, j ai dans mon site des fichiers de calcul de vent et neige que vous pouveaz l utiliser"]
[null,null,"pour qk c est d apres la norme Batimenet-escaliers etc (A1 A2…. T..), il suffit juste de choir A1 ou A2… le resultat sera calculer"]
[null,null,"vous pour aussi mettre Categories q et ajouter ce que vous voulez pour une charge d exploiatqtion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Le total en bas ne prend pas en compte sk et wk"]