{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Couverture","Dalle","Data ","Explication"],"not_rendered":{"charts":0,"images":0,"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":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Projet:","B2B "]
[null,"Numero de projet: 2026"]
[]
[]
[]
[null,"Adresse:"]
[]
[null,"…"]
[null,"…"]
[null,"…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ing: Oussama Rouchdi"]
["www.oussamarouchdi.com"]
["2026-07-11"]

{"sheet":"Dalle","index":1,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[64,0,64,5],[65,1,65,4],[58,1,58,4],[59,1,59,4],[60,1,60,4],[61,1,61,4],[62,1,62,4],[52,1,52,4],[53,1,53,4],[54,1,54,4],[55,1,55,4],[57,0,57,5],[39,1,39,4],[28,1,28,4],[29,0,29,5],[30,1,30,4],[33,1,33,4],[35,1,35,4],[31,1,31,4],[32,1,32,4],[38,1,38,4],[36,1,36,4],[37,1,37,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[3,0,4,5],[34,1,34,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[51,1,51,4],[40,1,40,4],[41,1,41,4],[47,1,47,4],[48,1,48,4],[46,1,46,4],[43,0,43,5],[44,1,44,4],[45,1,45,4],[49,1,49,4],[50,1,50,4]]}
[]
["Combinaisons de charges"]
[null,null,null,null,null,null,null,"G","Q","W","S","A"]
["Les combinaisons de charges selon EN 1990 (Eurocode 0) associent les actions permanentes (G), d'exploitation (Q), de vent (W), de neige (S) et accidentelles (A) avec leurs coefficients partiels (γ) et facteurs de combinaison (ψ), afin de déterminer les situations de dimensionnement déterminantes aux états limites ultimes (ELU) et de service (ELS).",null,null,null,null,null,null,"Oui","Oui","Oui","Oui","Non"]
[null,null,null,null,null,null,null,1,2,2,1,1]
["Charges appliquées (définies par l'utilisateur)"]
["Charge","Description",null,null,null,"q [kN/m²]",null,null,{"$f":"IF($H$4=\"Oui\",\"G1\",\"\")","v":"G1"},{"$f":"IF(AND($H$4=\"Oui\",$H$5=2),\"G2\",\"\")","v":""}]
[{"$f":"$I$7","v":"G1"},{"$f":"IF($I$7<>\"\",\"Charge permanente (poids propre, superstructures)\",\"\")","v":"Charge permanente (poids propre, superstructures)"},null,null,null,{"$f":"IF(OR($I$7=\"\",$I$8=\"\"),\"\",$I$8)","v":10},null,null,10]
[{"$f":"$J$7","v":""},{"$f":"IF($J$7<>\"\",\"Charge permanente (poids propre, superstructures)\",\"\")","v":""},null,null,null,{"$f":"IF(OR($J$7=\"\",$J$8=\"\"),\"\",$J$8)","v":""}]
[{"$f":"$I$10","v":"Q1"},{"$f":"IF($I$10<>\"\",\"Charge d'exploitation — \"&$I$12,\"\")","v":"Charge d'exploitation — Charge de circulation F (véhicules ≤ 30 kN, parkings légers)"},null,null,null,{"$f":"IF(OR($I$10=\"\",$I$11=\"\"),\"\",$I$11)","v":10},null,null,{"$f":"IF($I$4=\"Oui\",\"Q1\",\"\")","v":"Q1"},{"$f":"IF(AND($I$4=\"Oui\",$I$5=2),\"Q2\",\"\")","v":"Q2"}]
[{"$f":"$J$10","v":"Q2"},{"$f":"IF($J$10<>\"\",\"Charge d'exploitation — \"&$J$12,\"\")","v":"Charge d'exploitation — Charge de circulation G (véhicules 30–160 kN)"},null,null,null,{"$f":"IF(OR($J$10=\"\",$J$11=\"\"),\"\",$J$11)","v":15},null,null,10,15]
[{"$f":"$I$14","v":"Wx+"},{"$f":"IF($I$14<>\"\",\"Vent (\"&$I$14&\")\",\"\")","v":"Vent (Wx+)"},null,null,null,{"$f":"IF(OR($I$14=\"\",$I$15=\"\"),\"\",$I$15)","v":0.78},null,"Cat. ψ →","Charge de circulation F (véhicules ≤ 30 kN, parkings légers)","Charge de circulation G (véhicules 30–160 kN)"]
[{"$f":"$J$14","v":"Wx-"},{"$f":"IF($J$14<>\"\",\"Vent (\"&$J$14&\")\",\"\")","v":"Vent (Wx-)"},null,null,null,{"$f":"IF(OR($J$14=\"\",$J$15=\"\"),\"\",$J$15)","v":0.6}]
[{"$f":"$K$14","v":""},{"$f":"IF($K$14<>\"\",\"Vent (\"&$K$14&\")\",\"\")","v":""},null,null,null,{"$f":"IF(OR($K$14=\"\",$K$15=\"\"),\"\",$K$15)","v":""},null,null,{"$f":"IF($J$4=\"Oui\",\"Wx+\",\"\")","v":"Wx+"},{"$f":"IF(AND($J$4=\"Oui\",$J$5>=2),\"Wx-\",\"\")","v":"Wx-"},{"$f":"IF(AND($J$4=\"Oui\",$J$5>=3),\"Wy+\",\"\")","v":""},{"$f":"IF(AND($J$4=\"Oui\",$J$5>=4),\"W-\",\"\")","v":""}]
[{"$f":"$L$14","v":""},{"$f":"IF($L$14<>\"\",\"Vent (\"&$L$14&\")\",\"\")","v":""},null,null,null,{"$f":"IF(OR($L$14=\"\",$L$15=\"\"),\"\",$L$15)","v":""},null,null,0.78,0.6]
[{"$f":"$I$17","v":"Wa"},{"$f":"IF($I$17<>\"\",\"Vent (\"&$I$17&\")\",\"\")","v":"Vent (Wa)"},null,null,null,{"$f":"IF(OR($I$17=\"\",$I$18=\"\"),\"\",$I$18)","v":""}]
[{"$f":"$J$17","v":"Wd"},{"$f":"IF($J$17<>\"\",\"Vent (\"&$J$17&\")\",\"\")","v":"Vent (Wd)"},null,null,null,{"$f":"IF(OR($J$17=\"\",$J$18=\"\"),\"\",$J$18)","v":""},null,null,{"$f":"IF($J$4=\"Oui\",\"Wa\",\"\")","v":"Wa"},{"$f":"IF($J$4=\"Oui\",\"Wd\",\"\")","v":"Wd"}]
[{"$f":"$I$20","v":"s"},{"$f":"IF($I$20<>\"\",\"Neige — \"&$I$22,\"\")","v":"Neige — Charge de neige jusqu'à 1000 m NN (altitude ≤ 1000 m)"},null,null,null,{"$f":"IF(OR($I$20=\"\",$I$21=\"\"),\"\",$I$21)","v":0.85}]
[{"$f":"$I$23","v":""},{"$f":"IF($I$23<>\"\",\"Charge accidentelle\",\"\")","v":""},null,null,null,{"$f":"IF(OR($I$23=\"\",$I$24=\"\"),\"\",$I$24)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF($K$4=\"Oui\",\"s\",\"\")","v":"s"}]
[null,null,null,null,null,null,null,null,0.85]
[null,null,null,null,null,null,null,"Alt. →","Charge de neige jusqu'à 1000 m NN (altitude ≤ 1000 m)"]
[null,null,null,null,null,null,null,null,{"$f":"IF($L$4=\"Oui\",\"A\",\"\")","v":""},"P"]
[]
[]
["Combinaisons de charges"]
["Selon EN 1990 (Eurocode 0) — généré le 11.07.2026 à 21:03"]
[]
["N°","Combinaison (description avec coefficients)",null,null,null,"q [kN/m²]"]
["ÉTAT LIMITE ULTIME (ELU) — combinaison fondamentale 6.10"]
[1,"1,35·G1   (sans action variable)",null,null,null,13.5]
[2,"1,35·G1 + 1,50·Q1 + 1,50·0,70·Q2 + 1,50·0,50·s   (dominante : Q1)",null,null,null,44.887500000000003]
[3,"1,35·G1 + 1,50·Q2 + 1,50·0,70·Q1 + 1,50·0,50·s   (dominante : Q2)",null,null,null,47.137500000000003]
[4,"1,35·G1 + 1,50·s + 1,50·0,70·Q1 + 1,50·0,70·Q2   (dominante : s)",null,null,null,41.024999999999999]
[5,"1,35·G1 + 1,50·Q1 + 1,50·0,70·Q2 + 1,50·0,50·s + 1,50·0,60·Wx+   (dominante : Q1)",null,null,null,45.589500000000001]
[6,"1,35·G1 + 1,50·Q2 + 1,50·0,70·Q1 + 1,50·0,50·s + 1,50·0,60·Wx+   (dominante : Q2)",null,null,null,47.839500000000001]
[7,"1,35·G1 + 1,50·s + 1,50·0,70·Q1 + 1,50·0,70·Q2 + 1,50·0,60·Wx+   (dominante : s)",null,null,null,41.726999999999997]
[8,"1,35·G1 + 1,50·Wx+ + 1,50·0,70·Q1 + 1,50·0,70·Q2 + 1,50·0,50·s   (dominante : Wx+)",null,null,null,41.557499999999997]
[9,"1,35·G1 + 1,50·Q1 + 1,50·0,70·Q2 + 1,50·0,50·s + 1,50·0,60·Wx-   (dominante : Q1)",null,null,null,45.427500000000002]
[10,"1,35·G1 + 1,50·Q2 + 1,50·0,70·Q1 + 1,50·0,50·s + 1,50·0,60·Wx-   (dominante : Q2)",null,null,null,47.677500000000002]
[11,"1,35·G1 + 1,50·s + 1,50·0,70·Q1 + 1,50·0,70·Q2 + 1,50·0,60·Wx-   (dominante : s)",null,null,null,41.564999999999998]
[12,"1,35·G1 + 1,50·Wx- + 1,50·0,70·Q1 + 1,50·0,70·Q2 + 1,50·0,50·s   (dominante : Wx-)",null,null,null,41.287500000000001]
[]
["ELS — combinaison caractéristique"]
[13,"1,00·G1   (sans action variable)",null,null,null,10]
[14,"1,00·G1 + 1,00·Q1 + 1,00·0,70·Q2 + 1,00·0,50·s   (dominante : Q1)",null,null,null,30.925000000000001]
[15,"1,00·G1 + 1,00·Q2 + 1,00·0,70·Q1 + 1,00·0,50·s   (dominante : Q2)",null,null,null,32.424999999999997]
[16,"1,00·G1 + 1,00·s + 1,00·0,70·Q1 + 1,00·0,70·Q2   (dominante : s)",null,null,null,28.349999999999998]
[17,"1,00·G1 + 1,00·Q1 + 1,00·0,70·Q2 + 1,00·0,50·s + 1,00·0,60·Wx+   (dominante : Q1)",null,null,null,31.393000000000001]
[18,"1,00·G1 + 1,00·Q2 + 1,00·0,70·Q1 + 1,00·0,50·s + 1,00·0,60·Wx+   (dominante : Q2)",null,null,null,32.893000000000001]
[19,"1,00·G1 + 1,00·s + 1,00·0,70·Q1 + 1,00·0,70·Q2 + 1,00·0,60·Wx+   (dominante : s)",null,null,null,28.817999999999998]
[20,"1,00·G1 + 1,00·Wx+ + 1,00·0,70·Q1 + 1,00·0,70·Q2 + 1,00·0,50·s   (dominante : Wx+)",null,null,null,28.704999999999998]
[21,"1,00·G1 + 1,00·Q1 + 1,00·0,70·Q2 + 1,00·0,50·s + 1,00·0,60·Wx-   (dominante : Q1)",null,null,null,31.285]
[22,"1,00·G1 + 1,00·Q2 + 1,00·0,70·Q1 + 1,00·0,50·s + 1,00·0,60·Wx-   (dominante : Q2)",null,null,null,32.784999999999997]
[23,"1,00·G1 + 1,00·s + 1,00·0,70·Q1 + 1,00·0,70·Q2 + 1,00·0,60·Wx-   (dominante : s)",null,null,null,28.709999999999997]
[24,"1,00·G1 + 1,00·Wx- + 1,00·0,70·Q1 + 1,00·0,70·Q2 + 1,00·0,50·s   (dominante : Wx-)",null,null,null,28.524999999999999]
[]
["ELS — combinaison fréquente"]
[25,"1,00·G1 + 1,00·0,70·Q1 + 1,00·0,30·Q2   (dominante : Q1)",null,null,null,21.5]
[26,"1,00·G1 + 1,00·0,50·Q2 + 1,00·0,60·Q1   (dominante : Q2)",null,null,null,23.5]
[27,"1,00·G1 + 1,00·0,20·Wx+ + 1,00·0,60·Q1 + 1,00·0,30·Q2   (dominante : Wx+)",null,null,null,20.655999999999999]
[28,"1,00·G1 + 1,00·0,20·Wx- + 1,00·0,60·Q1 + 1,00·0,30·Q2   (dominante : Wx-)",null,null,null,20.619999999999997]
[29,"1,00·G1 + 1,00·0,20·s + 1,00·0,60·Q1 + 1,00·0,30·Q2   (dominante : s)",null,null,null,20.669999999999998]
[]
["ELS — combinaison quasi-permanente"]
[30,"1,00·G1 + 1,00·0,60·Q1 + 1,00·0,30·Q2",null,null,null,20.5]

{"sheet":"Data ","index":2,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["Coefficients partiels"]
["γG (charges permanentes)",1.35]
["γQ (charges variables)",1.5]
["γP (précontrainte)",1]
[]
[]
[]
["Action variable",null,"ψ0","ψ1","ψ2"]
["Charge d'exploitation cat. A, B (habitations, bureaux)",null,0.7,0.5,0.3]
["Charge d'exploitation cat. C, D (lieux de réunion, commerces)",null,0.7,0.7,0.6]
["Charge d'exploitation cat. E (stockage, aires industrielles",null,1,0.9,0.8]
["Charge de circulation F (véhicules ≤ 30 kN, parkings légers)",null,0.7,0.7,0.6]
["Charge de circulation G (véhicules 30–160 kN)",null,0.7,0.5,0.3]
["Charge de circulation H (toitures accessibles pour entretien uniquement)",null,0,0,0]
["Charge de vent (action du vent)",null,0.6,0.2,0]
["Charge de neige jusqu'à 1000 m NN (altitude ≤ 1000 m)",null,0.5,0.2,0]
["Charge de neige au-dessus de 1000 m NN (altitude > 1000 m)",null,0.7,0.5,0]
["Actions thermiques (effets de la température)",null,0.6,0.5,0.2]
["Tassements du sol de fondation",null,1,1,0]
["Autres actions variables",null,0.8,0.7,1]
[null,null,null,null,0.5]

{"sheet":"Explication","index":3,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[57,7,79,16]]}
[]
[]
[]
["Ce fichir est concue pour les combinaisons de charges selon l eurocode"]
[]
["J'avais mis auparavant des fichiers de calcul de charges (G et Q), vous les trouvez sur mon site,  ainsi que les charges de neige et de vent. D'autres cas, par exemple les charges accidentelles, on les verra par la suite."]
[]
["Dans ce fichier, il suffit de choisir, par oui ou par non, quels types de charge comporte votre projet (ou un cas simple). Ensuite, vous pouvez choisir le nombre de charges de ce type : par exemple, G peut avoir un seul cas ou deux. W, c'est le vent ; S, c'est la neige."]
[]
["Puis, dans chaque cas, ajoutez les charges dans les cases orange et cliquez sur « combi » : cela génère les combinaisons de charges à utiliser dans votre projet :)"]