{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Couverture","Mur","Toit plat","Toit monopente","Toit à deux versants","Toit à deux versants V","Toit en pavillon","Auvent","W_daten","Explication"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":10,"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":"Mur","index":1,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
["Vent:"]
[]
["Ce chapitre présente le calcul de l’action du vent sur un mur conformément aux ",null,null,null,null,null,null,null,null,"Pays","Allemagne",null,null,"h",24]
["prescriptions de l’Eurocode 1 (EN 1991-1-4), relatif aux actions du vent sur les structures. ",null,null,null,null,null,null,null,null,"Zone",1,"Binnenland",null,"b",6]
["L’étude porte sur un bâtiment de hauteur inférieure à   25 mètres, ce qui permet l’application des ",null,null,null,null,null,null,null,null,"Terrain","urbain dense",null,null,"l",10]
["méthodes simplifiées. Les coefficients aérodynamiques sont déterminés en fonction  de la "]
["géométrie du bâtiment, de la Les pressions caractéristiques du vent sont ensuite calculées à"]
["l’aide de la pression de base du vent et des coefficients Cpe permettant une évaluation précise "]
["des efforts transmis à la structure. La valeur de base de la vitesse du vent est déterminée"]
["conformément à la zone définie par la réglementation locale."]
["Valeur de base de la vitesse du vent",null,null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP(Mur!K5,W_daten!A4:C7,2,FALSE),\nIF(K4=\"Maroc\",VLOOKUP(Mur!K5,W_daten!I3:L7,2,FALSE),\"\"))","v":22.5},"kN/m²"]
["Pression dynamique de base :",null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP(Mur!K5,W_daten!A4:C7,3,FALSE),\nIF(K4=\"Maroc\",VLOOKUP(Mur!K5,W_daten!I3:L7,3,FALSE),\"\"))","v":0.32},"kN/m²"]
[]
["Les dimensions du bâtiment"]
[]
["Hauteur du bâtiment:",null,{"$f":"O4","v":24}]
["Largeur du bâtiment:",null,{"$f":"O5","v":6}]
["Longuer du bâtiment:   ",null,{"$f":"O6","v":10}]
[]
["Pression dynamique du vent simplifiée pour les bâtiments:",null,null,null,null,{"$f":"W_daten!L15","v":0.75}]
["L’action du vent sera analysée selon deux directions principales perpendiculaires :"]
[]
["Cas1: Direction de vent Ө=0°"]
[null,null,{"$f":"C18","v":6}]
[null,null,{"$f":"C17&\" / \"&C18&\"=\"","v":"24 / 6="},{"$f":"ROUND(C17/C18,2)","v":4}]
[null,null,null,{"$f":"MIN(C19,2*C17)","v":10},{"$f":"IF(D27<C25,\"e < d\",\nIF(D27>=5*C25,\"e ≥ 5 · d\",\nIF(AND(D27>=C25,D27<5*C25),\"d ≤ e < 5 · d\",\n\"\")))","v":"d ≤ e < 5 · d"}]
[]
[null,null,null,null,null,"avec"]
[null,null,null,null,null,{"$f":"IF(D27<C25,\"da= e/5\"&D27&\"/\"&\"5= \"&D27/5&\"m\",\nIF(D27>=5*C25,\"da= d =\"&C25&\"m\",\nIF(AND(D27>=C25,D27<5*C25),\"da= e / 5 = \"&D27&\"/\"&\"5 = \"&D27/5&\"m\",\n\"\")))","v":"da= e / 5 = 10/5 = 2m"}]
["D",{"$f":"IF(D27<C25,\"A\",\nIF(D27>=5*C25,\"\",\nIF(AND(D27>=C25,D27<5*C25),\"A\",\n\"\")))","v":"A"},{"$f":"IF(D27<C25,\"B\",\nIF(D27>=5*C25,\"A\",\nIF(AND(D27>=C25,D27<5*C25),\"B\",\n\"\")))","v":"B"},{"$f":"IF(D27<C25,\"C\",\nIF(D27>=5*C25,\"\",\nIF(AND(D27>=C25,D27<5*C25),\"\",\n\"\")))","v":""},"E",{"$f":"IF(D27<C25,\"db= 4 . e/5= 4 . \"&D27&\"/\"&\"/5= \"&4*D27/5&\"m\",\nIF(D27>=5*C25,\"\",\nIF(AND(D27>=C25,D27<5*C25),\"db= d - e/5 =\"&C25&\" - \"&D27&\"/5 = \"&C25-D27/5&\"m\",\n\"\")))","v":"db= d - e/5 =6 - 10/5 = 4m"}]
[{"$f":"W_daten!E37*F21","v":0.60000000000000009},{"$f":"IF(D27<C25,W_daten!E34*F21,\nIF(D27>=5*C25,\"\",\nIF(AND(D27>=C25,D27<5*C25),W_daten!E34*F21,\n\"\")))","v":-0.89999999999999991},{"$f":"IF(D27<C25,W_daten!E35*F21,\nIF(D27>=5*C25,W_daten!E34*F21,\nIF(AND(D27>=C25,D27<5*C25),W_daten!E35*F21,\n\"\")))","v":-0.60000000000000009},{"$f":"IF(D27<C25,W_daten!E36*F21,\nIF(D27>=5*C25,\"\",\nIF(AND(D27>=C25,D27<5*C25),\"\",\n\"\")))","v":""},{"$f":"W_daten!E38*F21","v":-0.375},{"$f":"IF(D27<C25,\"dc= d - e = \"&D27&\"-\"&D27&\"/5= \"&4*C25/5&\"m\",\nIF(D27>=5*C25,\"\",\nIF(AND(D27>=C25,D27<5*C25),\"\",\n\"\")))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cas1: Direction de vent Ө=90°"]
[null,null,{"$f":"C19","v":10}]
[null,null,{"$f":"C17&\" / \"&C51&\"=\"","v":"24 / 10="},{"$f":"ROUND(C17/C51,2)","v":2.4}]
[null,null,null,{"$f":"MIN(C18,2*C25)","v":6},{"$f":"IF(D53<C51,\"e < d\",\nIF(D53>=5*C51,\"e ≥ 5 · d\",\nIF(AND(D53>=C51,D53<5*C51),\"d ≤ e < 5 · d\",\n\"\")))","v":"e < d"}]
[]
[null,null,null,null,null,"avec"]
[null,null,null,null,null,{"$f":"IF(D53<C51,\"da= e/5\"&D53&\"/\"&\"5= \"&D53/5&\"m\",\nIF(D53>=5*C51,\"da= d =\"&C51&\"m\",\nIF(AND(D53>=C51,D53<5*C51),\"da= e / 5 = \"&D53&\"/\"&\"5 = \"&D53/5&\"m\",\n\"\")))","v":"da= e/56/5= 1,2m"}]
["D",{"$f":"IF(D53<C51,\"A\",\nIF(D53>=5*C51,\"\",\nIF(AND(D53>=C51,D53<5*C51),\"A\",\n\"\")))","v":"A"},{"$f":"IF(D53<C51,\"B\",\nIF(D53>=5*C51,\"A\",\nIF(AND(D53>=C51,D53<5*C51),\"B\",\n\"\")))","v":"B"},{"$f":"IF(D53<C51,\"C\",\nIF(D53>=5*C51,\"\",\nIF(AND(D53>=C51,D53<5*C51),\"\",\n\"\")))","v":"C"},"E",{"$f":"IF(D53<C51,\"db= 4 . e/5= 4 . \"&D53&\"/\"&\"/5= \"&4*D53/5&\"m\",\nIF(D53>=5*C51,\"\",\nIF(AND(D53>=C51,D53<5*C51),\"db= d - e/5 =\"&C51&\" - \"&D53&\"/5 = \"&C51-D53/5&\"m\",\n\"\")))","v":"db= 4 . e/5= 4 . 6//5= 4,8m"}]
[{"$f":"W_daten!K37*F21","v":0.60000000000000009},{"$f":"IF(D53<C51,W_daten!K34*F21,\nIF(D53>=5*C51,\"\",\nIF(AND(D53>=C51,D53<5*C51),W_daten!K34*F21,\n\"\")))","v":-0.89999999999999991},{"$f":"IF(D53<C51,W_daten!K35*F21,\nIF(D53>=5*C51,W_daten!K34*F21,\nIF(AND(D53>=C51,D53<5*C51),W_daten!K35*F21,\n\"\")))","v":-0.60000000000000009},{"$f":"IF(D53<C51,W_daten!K36*F21,\nIF(D53>=5*C51,\"\",\nIF(AND(D53>=C51,D53<5*C51),\"\",\n\"\")))","v":-0.375},{"$f":"W_daten!K38*F21","v":-0.375},{"$f":"IF(D53<C51,\"dc= d - e = \"&D53&\"-\"&D53&\"/5= \"&4*C51/5&\"m\",\nIF(D53>=5*C51,\"\",\nIF(AND(D53>=C51,D53<5*C51),\"\",\n\"\")))","v":"dc= d - e = 6-6/5= 8m"}]

{"sheet":"Toit plat","index":2,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["Vent:"]
[]
["Ce chapitre présente le calcul de l’action du vent sur une toiture plate conformément aux prescriptions de ",null,null,null,null,null,null,null,null,"Pays","Allemagne",null,null,"d",4]
["l’Eurocode 1 (EN 1991-1-4), relatif aux actions du vent sur les structures. L’étude porte sur un bâtiment ",null,null,null,null,null,null,null,null,"Zone",1,"Binnenland",null,"h",12]
["de hauteur inférieure à  25 mètres, ce qui permet l’application des méthodes simplifiées. Les coefficients ",null,null,null,null,null,null,null,null,"Terrain","Semi urbain",null,null,"b",40]
["aérodynamiques sont déterminés en fonction de la géométrie du bâtiment, de la direction du vent, ainsi que "]
["de la répartition des zones de pression sur les parois. Les pressions caractéristiques du vent sont ensuite ",null,null,null,null,null,null,null,null,"Avec ou sans acrotère","avec acrotère",null,null,"NB : J’ai pris en compte dans le calcu juste l la présence ou non d’un acrotère. Vous pouvez développer cela à partir du tableau (qui est déjà prêt)."]
["calculées à l’aide de la pression de base du vent et des coefficients Cpe permettant une évaluation ",null,null,null,null,null,null,null,null,{"$f":"IF(K8=W_daten!Q37,\"rien à ajouter\",\nIF(K8=W_daten!Q38,\"hp en m\",\nIF(K8=W_daten!Q41,\"r\",IF(K8=W_daten!Q44,\"alpha\",\n\"\"))))","v":"hp en m"},2]
["précise des efforts transmis à la structure par la toiture. "]
["La valeur de base de la vitesse du vent est déterminée conformément à la zone définie "]
["Valeur de base de la vitesse du vent",null,null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit plat'!K5,W_daten!A4:C7,2,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit plat'!K5,W_daten!I3:L7,2,FALSE),\"\"))","v":22.5},"kN/m²"]
["Pression dynamique de base :",null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit plat'!K5,W_daten!A4:C7,3,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit plat'!K5,W_daten!I3:L7,3,FALSE),\"\"))","v":0.32},"kN/m²"]
[]
["Les dimensions du bâtiment"]
[]
["Hauteur du bâtiment:",null,{"$f":"O5","v":12}]
["Largeur du bâtiment:",null,{"$f":"O4","v":4}]
["Longuer du bâtiment:   ",null,{"$f":"O6","v":40}]
[]
["Pression dynamique du vent simplifiée pour les bâtiments:",null,null,null,null,{"$f":"W_daten!V5","v":0.65}]
["L’action du vent sera analysée selon deux directions principales perpendiculaires :"]
[]
["Cas1: Direction de vent Ө=0°"]
[null,null,"e/2=",{"$f":"MIN(C18,2*C17)/2","v":2}]
[]
[null,null,"e/10=",{"$f":"MIN(C18,2*C17)/10","v":0.4}]
[]
[null,null,"F"]
[null,null,{"$f":"W_daten!V50*'Toit plat'!F21","v":-0.78}]
[]
[]
[]
[null,null,"G","H","I","b=",{"$f":"C19","v":40}]
[null,null,{"$f":"W_daten!V51*'Toit plat'!F21","v":-0.52},{"$f":"W_daten!V52*'Toit plat'!F21","v":-0.45499999999999996},{"$f":"W_daten!V53*'Toit plat'!F21","v":0.13}]
[null,null,null,null,{"$f":"W_daten!Y50*'Toit plat'!F21","v":-0.39}]
[]
[]
[]
[null,null,"F"]
["e/4=",{"$f":"D25/2","v":1},{"$f":"W_daten!V50*'Toit plat'!F21","v":-0.78}]
[]
[]
[null,null,null,"d=",{"$f":"O4","v":4}]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"Toit monopente","index":3,"n_rows":88,"n_cols":15,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
["Vent:"]
[]
["Ce chapitre présente le calcul de l’action du vent sur une toiture monopente conformément aux prescriptions de ",null,null,null,null,null,null,null,null,"Pays","Allemagne",null,null,"h",18]
["l’Eurocode 1 (EN 1991-1-4), relatif aux actions du vent sur les structures. L’étude porte sur un bâtiment ",null,null,null,null,null,null,null,null,"Zone",3,"Binnenland",null,"d",12]
["de hauteur inférieure à  25 mètres, ce qui permet l’application des méthodes simplifiées. Les coefficients ",null,null,null,null,null,null,null,null,"Terrain","Semi urbain",null,null,"b",40]
["aérodynamiques sont déterminés en fonction de la géométrie du bâtiment, de la direction du vent, ainsi que "]
["de la répartition des zones de pression sur les parois. Les pressions caractéristiques du vent sont ensuite "]
["calculées à l’aide de la pression de base du vent et des coefficients Cpe permettant une évaluation ",null,null,null,null,null,null,null,null,"alpha",15]
["précise des efforts transmis à la structure par la toiture. "]
["La valeur de base de la vitesse du vent est déterminée conformément à la zone définie "]
["Valeur de base de la vitesse du vent",null,null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit monopente'!K5,W_daten!A4:C7,2,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit monopente'!K5,W_daten!I3:L7,2,FALSE),\"\"))","v":27.5},"kN/m²"]
["Pression dynamique de base :",null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit monopente'!K5,W_daten!A4:C7,3,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit monopente'!K5,W_daten!I3:L7,3,FALSE),\"\"))","v":0.47},"kN/m²"]
[]
["Les dimensions du bâtiment"]
[]
["Hauteur du bâtiment:",null,{"$f":"O4","v":18}]
["Largeur du bâtiment:",null,{"$f":"O5","v":12}]
["Longuer du bâtiment:   ",null,{"$f":"O6","v":40}]
[]
["Pression dynamique du vent simplifiée pour les bâtiments:",null,null,null,null,{"$f":"W_daten!V9","v":1.2}]
["L’action du vent sera analysée selon deux directions principales perpendiculaires :"]
[]
["Cas1: Direction de vent Ө=0°"]
[]
[]
[null,null,"e/10=",{"$f":"MIN(O6,2*O4)/10","v":3.6}]
[]
[null,null,"F"]
[null,null,{"$f":"W_daten!U71*'Toit monopente'!F21","v":-1.08}]
[null,null,{"$f":"W_daten!V71*'Toit monopente'!F21","v":0.24}]
[]
[]
[null,null,"G","H"]
[null,null,{"$f":"W_daten!U72*'Toit monopente'!F21","v":-0.96},{"$f":"W_daten!U73*'Toit monopente'!F21","v":-0.36}]
[null,null,{"$f":"W_daten!V72*'Toit monopente'!F21","v":0.24},{"$f":"W_daten!V73*'Toit monopente'!F21","v":0.24}]
[]
[]
[null,null,"F"]
["e/4=",{"$f":"MIN(O6,2*O4)/4","v":9},{"$f":"C30","v":-1.08}]
[null,null,{"$f":"C31","v":0.24}]
[]
[]
[]
[]
["Cas2: Direction de vent Ө=180°"]
[]
[]
[null,{"$f":"C27","v":"e/10="},{"$f":"D27","v":3.6}]
[]
[null,null,"F"]
[null,null,{"$f":"W_daten!U88*'Toit monopente'!F21","v":-3}]
[]
[]
[]
[null,null,"G","H"]
[null,null,{"$f":"W_daten!U89*'Toit monopente'!F21","v":-1.56},{"$f":"W_daten!U90*'Toit monopente'!F21","v":-1.08}]
[]
[]
[]
[{"$f":"A40","v":"e/4="},{"$f":"B40","v":9},"F"]
[null,null,{"$f":"C52","v":-3}]
[]
[]
[]
[]
[]
["Cas3: Direction de vent Ө=90°"]
[]
[]
[null,{"$f":"B49","v":"e/10="},{"$f":"C49","v":3.6}]
[]
[null,null,"F"]
[null,null,{"$f":"W_daten!Y88*'Toit monopente'!F21","v":-2.88}]
[]
[]
[]
[null,null,"G","H",null,"I"]
[null,null,{"$f":"W_daten!Y90*'Toit monopente'!F21","v":-2.2799999999999998},{"$f":"W_daten!Y91*'Toit monopente'!F21","v":-0.96},null,{"$f":"W_daten!Y92*'Toit monopente'!F21","v":-0.84}]
[]
[]
[]
[{"$f":"A61","v":"e/4="},{"$f":"B61","v":9},"F"]
[null,null,{"$f":"W_daten!Y89*'Toit monopente'!F21","v":-1.92}]
[]
[]
[]
[null,null,"e/2=",{"$f":"MIN(O6,2*O4)/2","v":18}]

{"sheet":"Toit à deux versants","index":4,"n_rows":80,"n_cols":15,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
["Vent:"]
[]
["Ce chapitre présente le calcul de l’action du vent sur une toiture à deux versants conformément aux prescriptions de ",null,null,null,null,null,null,null,null,"Pays","Allemagne",null,null,"h",18]
["l’Eurocode 1 (EN 1991-1-4), relatif aux actions du vent sur les structures. L’étude porte sur un bâtiment ",null,null,null,null,null,null,null,null,"Zone",4,"Binnenland",null,"d",12]
["de hauteur inférieure à  25 mètres, ce qui permet l’application des méthodes simplifiées. Les coefficients ",null,null,null,null,null,null,null,null,"Terrain","Semi urbain",null,null,"b",40]
["aérodynamiques sont déterminés en fonction de la géométrie du bâtiment, de la direction du vent, ainsi que "]
["de la répartition des zones de pression sur les parois. Les pressions caractéristiques du vent sont ensuite "]
["calculées à l’aide de la pression de base du vent et des coefficients Cpe permettant une évaluation ",null,null,null,null,null,null,null,null,"alpha",7]
["précise des efforts transmis à la structure par la toiture. "]
["La valeur de base de la vitesse du vent est déterminée conformément à la zone définie "]
["Valeur de base de la vitesse du vent",null,null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit à deux versants'!K5,W_daten!A4:C7,2,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit à deux versants'!K5,W_daten!I3:L7,2,FALSE),\"\"))","v":30},"kN/m²"]
["Pression dynamique de base :",null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit à deux versants'!K5,W_daten!A4:C7,3,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit à deux versants'!K5,W_daten!I3:L7,3,FALSE),\"\"))","v":0.56000000000000005},"kN/m²"]
[]
["Les dimensions du bâtiment"]
[]
["Hauteur du bâtiment:",null,{"$f":"O4","v":18}]
["Largeur du bâtiment:",null,{"$f":"O5","v":12}]
["Longuer du bâtiment:   ",null,{"$f":"O6","v":40}]
[]
["Pression dynamique du vent simplifiée pour les bâtiments:",null,null,null,null,null,{"$f":"W_daten!V14","v":1.1499999999999999}]
["L’action du vent sera analysée selon deux directions principales perpendiculaires :"]
[]
["Cas1: Direction de vent Ө=0°"]
[]
[]
[null,null,"e/10=",{"$f":"MIN(O6,O4*2)/10","v":3.6},{"$f":"\"=e/10\"","v":"=e/10"}]
[]
[null,null,"F"]
[null,null,{"$f":"W_daten!D89*'Toit à deux versants'!G21","v":-1.9549999999999998}]
[null,null,{"$f":"W_daten!E89*'Toit à deux versants'!G21","v":0}]
[]
[]
[null,null,"G","H","J",null,"I"]
[null,null,{"$f":"W_daten!D90*'Toit à deux versants'!G21","v":-1.38},{"$f":"W_daten!D91*'Toit à deux versants'!G21","v":-0.69},{"$f":"W_daten!D92*'Toit à deux versants'!G21","v":-0.69},null,{"$f":"W_daten!D93*'Toit à deux versants'!G21","v":0.22999999999999998}]
[null,null,{"$f":"W_daten!E90*'Toit à deux versants'!G21","v":0},{"$f":"W_daten!E91*'Toit à deux versants'!G21","v":0},{"$f":"W_daten!E92*'Toit à deux versants'!G21","v":-0.69},null,{"$f":"W_daten!E93*'Toit à deux versants'!G21","v":-0.69}]
[]
[]
[null,"e/4=",{"$f":"MIN(O6,O4*2)/4","v":9}]
[null,null,{"$f":"C30","v":-1.9549999999999998}]
[null,null,{"$f":"C31","v":0}]
[]
["Cas1: Direction de vent Ө=180°"]
[]
[null,null,"F"]
[null,null,{"$f":"W_daten!H89*'Toit à deux versants'!G21","v":-1.8399999999999999},"H"]
[null,null,"G",{"$f":"W_daten!H91*'Toit à deux versants'!G21","v":-0.80499999999999994},null,"I"]
[null,null,{"$f":"W_daten!H90*'Toit à deux versants'!G21","v":-1.4949999999999999},null,null,{"$f":"W_daten!H92*'Toit à deux versants'!G21","v":-0.69}]
[null,null,"G",null,null,"I"]
[null,null,{"$f":"C48","v":-1.4949999999999999},null,null,{"$f":"F48","v":-0.69}]
[null,{"$f":"\"e/4 = \"&MIN(O5,O4*2)/4","v":"e/4 = 3"},"F"]
[null,null,{"$f":"C46","v":-1.8399999999999999}]
[]
[null,null,"e/10=",{"$f":"MIN(O5,O4*2)/10","v":1.2}]
[]
[null,null,"e/2=",{"$f":"MIN(O5,O4*2)/2","v":6}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[", "]
[" "]

{"sheet":"Toit à deux versants V","index":5,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
["Vent:"]
[]
["Ce chapitre présente le calcul de l’action du vent sur une toiture  à deux versants conformément aux prescriptions de ",null,null,null,null,null,null,null,null,"Pays","Maroc",null,null,"h",18]
["l’Eurocode 1 (EN 1991-1-4), relatif aux actions du vent sur les structures. L’étude porte sur un bâtiment ",null,null,null,null,null,null,null,null,"Zone",2,"Binnenland",null,"d",12]
["de hauteur inférieure à  25 mètres, ce qui permet l’application des méthodes simplifiées. Les coefficients ",null,null,null,null,null,null,null,null,"Terrain","Semi urbain",null,null,"b",40]
["aérodynamiques sont déterminés en fonction de la géométrie du bâtiment, de la direction du vent, ainsi que "]
["de la répartition des zones de pression sur les parois. Les pressions caractéristiques du vent sont ensuite "]
["calculées à l’aide de la pression de base du vent et des coefficients Cpe permettant une évaluation ",null,null,null,null,null,null,null,null,"alpha",-12]
["précise des efforts transmis à la structure par la toiture. "]
["La valeur de base de la vitesse du vent est déterminée conformément à la zone définie "]
["Valeur de base de la vitesse du vent",null,null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit à deux versants V'!K5,W_daten!A4:C7,2,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit à deux versants V'!K5,W_daten!I3:L7,2,FALSE),\"\"))","v":41.5},"kN/m²"]
["Pression dynamique de base :",null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit à deux versants V'!K5,W_daten!A4:C7,3,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit à deux versants V'!K5,W_daten!I3:L7,3,FALSE),\"\"))","v":1.08},"kN/m²"]
[]
["Les dimensions du bâtiment"]
[]
["Hauteur du bâtiment:",null,{"$f":"O4","v":18}]
["Largeur du bâtiment:",null,{"$f":"O5","v":12}]
["Longuer du bâtiment:   ",null,{"$f":"O6","v":40}]
[]
["Pression dynamique du vent simplifiée pour les bâtiments:",null,null,null,null,null,{"$f":"W_daten!V19","v":1.45}]
["L’action du vent sera analysée selon deux directions principales perpendiculaires :"]
[]
["Cas1: Direction de vent Ө=0°"]
[]
[]
[null,null,"e/10=",{"$f":"MIN(O6,O4*2)/10","v":3.6},{"$f":"\"=e/10\"","v":"=e/10"}]
[]
[null,null,"F"]
[null,null,{"$f":"W_daten!D55*'Toit à deux versants'!G21","v":-2.6449999999999996}]
[]
[]
[]
[null,null,"G","H","J","I"]
[null,null,{"$f":"W_daten!D56*'Toit à deux versants'!G21","v":-1.38},{"$f":"W_daten!D57*'Toit à deux versants'!G21","v":-0.91999999999999993},{"$f":"W_daten!D58*'Toit à deux versants'!G21","v":-0.69},{"$f":"W_daten!D59*'Toit à deux versants'!G21","v":-0.69}]
[]
[]
[]
[null,"e/4=",{"$f":"MIN(O6,O4*2)/4","v":9}]
[null,null,"F"]
[null,null,{"$f":"C30","v":-2.6449999999999996}]
[]
[]
[]
[]
[]
[null,null,"F"]
[null,null,{"$f":"W_daten!J55*'Toit à deux versants'!G21","v":-2.0699999999999998},"H"]
[null,null,"G",{"$f":"W_daten!J57*'Toit à deux versants'!G21","v":-0.80499999999999994},null,"I"]
[null,null,{"$f":"W_daten!J56*'Toit à deux versants'!G21","v":-1.38},null,null,{"$f":"W_daten!J58*'Toit à deux versants'!G21","v":-0.69}]
[null,null,"G",null,null,"I"]
[null,null,{"$f":"C50","v":-1.38},null,null,{"$f":"F50","v":-0.69}]
[null,{"$f":"\"e/4 = \"&MIN(O5,O4*2)/4","v":"e/4 = 3"},"F"]
[null,null,{"$f":"C48","v":-2.0699999999999998}]
[]
[null,null,"e/10=",{"$f":"MIN(O5,O4*2)/10","v":1.2}]
[]
[null,null,"e/2=",{"$f":"MIN(O5,O4*2)/2","v":6}]

{"sheet":"Toit en pavillon","index":6,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
["Vent:"]
[]
["Ce chapitre présente le calcul de l’action du vent sur une toiture en pavillon conformément aux prescriptions de ",null,null,null,null,null,null,null,null,"Pays","Maroc",null,null,"h",18]
["l’Eurocode 1 (EN 1991-1-4), relatif aux actions du vent sur les structures. L’étude porte sur un bâtiment ",null,null,null,null,null,null,null,null,"Zone",2,"Binnenland",null,"d",12]
["de hauteur inférieure à  25 mètres, ce qui permet l’application des méthodes simplifiées. Les coefficients ",null,null,null,null,null,null,null,null,"Terrain","Semi urbain",null,null,"b",40]
["aérodynamiques sont déterminés en fonction de la géométrie du bâtiment, de la direction du vent, ainsi que "]
["de la répartition des zones de pression sur les parois. Les pressions caractéristiques du vent sont ensuite "]
["calculées à l’aide de la pression de base du vent et des coefficients Cpe permettant une évaluation ",null,null,null,null,null,null,null,null,"alpha",12]
["précise des efforts transmis à la structure par la toiture. ",null,null,null,null,null,null,null,null,"alpha",13]
["La valeur de base de la vitesse du vent est déterminée conformément à la zone définie "]
["Valeur de base de la vitesse du vent",null,null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit en pavillon'!K5,W_daten!A4:C7,2,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit en pavillon'!K5,W_daten!I3:L7,2,FALSE),\"\"))","v":41.5},"kN/m²"]
["Pression dynamique de base :",null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP('Toit en pavillon'!K5,W_daten!A4:C7,3,FALSE),\nIF(K4=\"Maroc\",VLOOKUP('Toit en pavillon'!K5,W_daten!I3:L7,3,FALSE),\"\"))","v":1.08},"kN/m²"]
[]
["Les dimensions du bâtiment"]
[]
["Hauteur du bâtiment:",null,{"$f":"O4","v":18}]
["Largeur du bâtiment:",null,{"$f":"O5","v":12}]
["Longuer du bâtiment:   ",null,{"$f":"O6","v":40}]
[]
["Pression dynamique du vent simplifiée pour les bâtiments:",null,null,null,null,{"$f":"W_daten!V24","v":1.45}]
["L’action du vent sera analysée selon deux directions principales perpendiculaires :"]
[]
["Cas1: Direction de vent Ө=0°"]
[]
[]
[null,null,"e/10=",{"$f":"MIN(O6,2*O4)/10","v":3.6}]
[]
["e/4=",{"$f":"MIN(O6,2*O4)/4","v":9},"F","L","M",{"$f":"W_daten!D169*'Toit en pavillon'!F21","v":-0.87},"J",{"$f":"\"e/10 = \"&MIN(O6,2*O4)/10","v":"e/10 = 3,6"}]
[null,null,{"$f":"W_daten!D162*'Toit en pavillon'!F21","v":-1.3049999999999999},null,{"$f":"W_daten!D168*'Toit en pavillon'!F21","v":-2.0299999999999998},null,{"$f":"W_daten!D166*'Toit en pavillon'!F21","v":-1.45}]
[null,null,{"$f":"W_daten!E163*'Toit en pavillon'!F21","v":0.28999999999999998}]
[]
[null,null,"G",null,"H"]
[null,null,"G","H","I"]
[null,null,{"$f":"W_daten!D163*'Toit en pavillon'!F21","v":-1.1599999999999999},{"$f":"W_daten!D164*'Toit en pavillon'!F21","v":-0.435},null,"K","I"]
[null,null,{"$f":"W_daten!E163*'Toit en pavillon'!F21","v":0.28999999999999998},{"$f":"W_daten!E164*'Toit en pavillon'!F21","v":0.28999999999999998},null,{"$f":"W_daten!D167*'Toit en pavillon'!F21","v":-1.74},{"$f":"W_daten!D165*'Toit en pavillon'!F21","v":-0.72499999999999998}]
[]
[]
[]
[]
[]
["e/4=",{"$f":"B29","v":9},"F"]
[null,null,{"$f":"C30","v":-1.3049999999999999},null,null,"J"]
[null,null,{"$f":"C31","v":0.28999999999999998},null,"L","M",{"$f":"G30","v":-1.45}]
[null,null,null,null,{"$f":"E30","v":-2.0299999999999998},{"$f":"F29","v":-0.87},null,{"$f":"H29","v":"e/10 = 3,6"}]
[]
[]
[]
[null,{"$f":"\"e/10 = \"&MIN(O5,2*O4)/10","v":"e/10 = 1,2"}]
[]
[{"$f":"\"e/4 = \"&MIN(O5,2*O4)/4","v":"e/4 = 3"},"F","M",null,"N"]
[null,{"$f":"C30","v":-1.3049999999999999},"L",{"$f":"D59","v":-0.87},{"$f":"W_daten!H170*'Toit en pavillon'!F21","v":-0.435},null,"J",{"$f":"H60","v":"e/10 = 1,2"}]
[null,{"$f":"C31","v":0.28999999999999998},{"$f":"C57","v":-2.0299999999999998},null,null,null,{"$f":"G30","v":-1.45}]
[null,"G","H",null,null,null,"I"]
[null,{"$f":"C35","v":-1.1599999999999999},null,null,null,null,{"$f":"G36","v":-0.72499999999999998}]
[null,{"$f":"C36","v":0.28999999999999998},null,"L","N"]
[null,null,{"$f":"E45","v":-2.0299999999999998},null,{"$f":"E52","v":-0.435},null,"J"]
[null,"F",null,"M",null,null,{"$f":"G44","v":-1.45}]
[{"$f":"A51","v":"e/4 = 3"},{"$f":"C43","v":-1.3049999999999999},null,{"$f":"F29","v":-0.87}]
[null,{"$f":"C44","v":0.28999999999999998},null,null,null,null,null,{"$f":"B49","v":"e/10 = 1,2"}]
[]
[null,{"$f":"\"e/2 = \"&MIN(O5,2*O4)/2","v":"e/2 = 6"}]

{"sheet":"Auvent","index":7,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
["Vent:"]
[]
["Ce chapitre présente le calcul de l’action du vent sur une Auvent  conformément aux prescriptions de ",null,null,null,null,null,null,null,null,"Pays","Maroc",null,null,"h",18]
["l’Eurocode 1 (EN 1991-1-4), relatif aux actions du vent sur les structures. L’étude porte sur un bâtiment ",null,null,null,null,null,null,null,null,"Zone",2,"Binnenland",null,"b1",12]
["de hauteur inférieure à  25 mètres, ce qui permet l’application des méthodes simplifiées. Les coefficients ",null,null,null,null,null,null,null,null,"Terrain","Semi urbain",null,null,"l",40]
["aérodynamiques sont déterminés en fonction de la géométrie du bâtiment, de la direction du vent, ainsi que ",null,null,null,null,null,null,null,null,null,null,null,null,"d1",1.5]
["de la répartition des zones de pression sur les parois. Les pressions caractéristiques du vent sont ensuite ",null,null,null,null,null,null,null,null,null,null,null,null,"h1",4]
["calculées à l’aide de la pression de base du vent et des coefficients Cpe permettant une évaluation ",null,null,null,null,null,null,null,null,"alpha",12]
["précise des efforts transmis à la structure par la toiture. "]
["La valeur de base de la vitesse du vent est déterminée conformément à la zone définie "]
["Valeur de base de la vitesse du vent",null,null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP(Auvent!K5,W_daten!A4:C7,2,FALSE),\nIF(K4=\"Maroc\",VLOOKUP(Auvent!K5,W_daten!I3:L7,2,FALSE),\"\"))","v":41.5},"kN/m²"]
["Pression dynamique de base :",null,{"$f":"IF(K4=\"Allemagne\",VLOOKUP(Auvent!K5,W_daten!A4:C7,3,FALSE),\nIF(K4=\"Maroc\",VLOOKUP(Auvent!K5,W_daten!I3:L7,3,FALSE),\"\"))","v":1.08},"kN/m²"]
[]
["Les dimensions du bâtiment",null,null,null,null,null,null,{"$f":"\"h = \"&O4&\"m\"","v":"h = 18m"}]
[null,null,null,null,null,{"$f":"\"d1 = \"&O7&\"m\"","v":"d1 = 1,5m"},{"$f":"\"h1 = \"&O8&\"m\"","v":"h1 = 4m"}]
["Hauteur du bâtiment:",null,{"$f":"O4","v":18}]
["Largeur Auvent:",null,{"$f":"O5","v":12}]
["Longuer Auvent:   ",null,{"$f":"O6","v":40}]
[]
["Pression dynamique du vent simplifiée pour les bâtiments:",null,null,null,null,{"$f":"W_daten!V29","v":1.45}]
["L’action du vent sera analysée selon deux directions principales perpendiculaires :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"b1"]
[]
[null,null,"A","B","A"]
[null,null,{"$f":"W_daten!F112*Auvent!F21","v":1.1599999999999999},{"$f":"W_daten!F113*Auvent!F21","v":0.72499999999999998},{"$f":"C35","v":1.1599999999999999},"d1"]
[null,null,{"$f":"W_daten!H112*Auvent!F21","v":-1.3049999999999999},{"$f":"W_daten!H113*Auvent!F21","v":-0.28999999999999998},{"$f":"C36","v":-1.3049999999999999}]
[]
[]
[null,"e=",{"$f":"MIN(O7/4,O5/2)","v":0.375},{"$f":"B39","v":"e="},{"$f":"C39","v":0.375}]

{"sheet":"W_daten","index":8,"n_rows":181,"n_cols":29,"rows_kept":181,"cut":false,"hidden":false,"merged":[[62,7,62,8],[35,27,38,28],[62,9,62,10],[34,24,34,25],[34,18,34,19],[34,22,34,23],[34,20,34,21],[39,9,39,10],[57,18,57,19],[57,20,57,21],[57,22,57,23],[37,16,39,16],[40,16,42,16],[43,16,45,16],[135,15,135,16],[135,17,135,18],[135,1,135,2],[135,3,135,4],[135,5,135,6],[135,7,135,8],[1,8,1,10],[1,0,1,2],[135,9,135,10],[135,11,135,12],[135,13,135,14],[39,1,39,2],[39,3,39,4],[39,5,39,6],[39,7,39,8],[45,1,45,2],[45,3,45,4],[45,5,45,6],[45,7,45,8],[62,1,62,2],[62,3,62,4],[62,5,62,6]]}
[]
["Allemagne",null,null,null,null,null,null,null,"Maroc"]
["Windzone","vb0 in m/s","qb0 in KN/m²","qb","Semi urbain",null,"Allemagne",null,"Windzone","vb0 in m/s","qb0 in KN/m²","qb",null,"Hauteur","Semi urbain","urbain dense",null,"höhe",{"$f":"'Toit plat'!O5","v":12},{"$f":"IF(S3<=10,\"A\",IF(S3<=18,\"B\",IF(S3<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit plat'!K5&'Toit plat'!L5","v":"1Binnenland"},{"$f":"INDEX(C11:F18, MATCH(U3, F11:F18, 0), MATCH(T3,C10:F10, 0))","v":0.65},"Toit Plat"]
[1,22.5,0.32,null,"urbain dense",null,"Maroc",null,1,39,{"$f":"ROUND((1/2)*1.25*J4^2*(10^(-3)),2)","v":0.95},null,"A",10,1,0.83,null,null,{"$f":"IF(S3<=10,\"A\",IF(S3<=20,\"B\",IF(S3<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit plat'!K6","v":"Semi urbain"},{"$f":"INDEX(O4:P7, MATCH(S4,M4:M6, 0), MATCH(T4,O3:P3, 0))","v":1.1599999999999999},{"$f":"U4^2*'Toit plat'!C13","v":0.43059199999999997}]
[2,25,0.39,null,null,null,null,null,2,41.5,{"$f":"ROUND((1/2)*1.25*J5^2*(10^(-3)),2)","v":1.08},null,"B",20,1.1599999999999999,0.96,null,null,null,null,null,{"$f":"ROUND(IF('Toit plat'!K4=\"Allemagne\", V3, IF('Toit plat'!K4=\"Maroc\", V4, FALSE)),2)","v":0.65}]
[3,27.5,0.47,null,null,null,null,null,3,42.3,1.1200000000000001,null,"C",30,1.26,1.04]
[4,30,0.56000000000000005,null,null,null,null,null,4,45,1.27,null,null,40,1.34,1.1000000000000001,null,"höhe",{"$f":"'Toit monopente'!O4","v":18},{"$f":"IF(S7<=10,\"A\",IF(S7<=18,\"B\",IF(S7<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit monopente'!K5&'Toit monopente'!L5","v":"3Binnenland"},{"$f":"INDEX(C11:F18, MATCH(U7, F11:F18, 0), MATCH(T7, C10:F10, 0))","v":1.2},"Toit monopente"]
["Vereinfachte Böengeschindigkeitsdrücke für Bauwerke bis 25m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S7<=10,\"A\",IF(S7<=20,\"B\",IF(S7<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit monopente'!K6","v":"Semi urbain"},{"$f":"INDEX(O4:P7, MATCH(S8,M4:M6, 0), MATCH(T8,O3:P3, 0))","v":1.1599999999999999},{"$f":"U8^2*'Toit monopente'!C13","v":0.63243199999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF('Toit monopente'!K4=\"Allemagne\", V7, IF('Toit monopente'!K4=\"Maroc\", V8, FALSE)),2)","v":1.2}]
[null,null,"A","B","C","E"]
[1,"Binnenland",0.5,0.65,0.75,{"$f":"A11&B11","v":"1Binnenland"}]
[2,"Binnenland",0.65,0.8,0.9,{"$f":"A12&B12","v":"2Binnenland"},null,null,null,null,null,null,null,null,null,null,null,"höhe",{"$f":"'Toit à deux versants'!O4","v":18},{"$f":"IF(S12<=10,\"A\",IF(S12<=18,\"B\",IF(S12<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit à deux versants'!K5&'Toit à deux versants'!L5","v":"4Binnenland"},{"$f":"INDEX(C11:F18, MATCH(U12, F11:F18, 0), MATCH(T12, C10:F10, 0))","v":1.1499999999999999},"Toit a deux versant"]
[2,"Ostseeküste und –inseln",0.85,1,1.1000000000000001,"2Ostseeküste und –inseln",null,"höhe",{"$f":"Mur!C17","v":24},{"$f":"IF(I13<=10,\"A\",IF(I13<=18,\"B\",IF(I13<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"C"},{"$f":"Mur!K5&Mur!L5","v":"1Binnenland"},{"$f":"INDEX(C11:F18, MATCH(K13, F11:F18, 0), MATCH(J13, C10:F10, 0))","v":0.75},"Mur",null,null,null,null,null,{"$f":"IF(S12<=10,\"A\",IF(S12<=20,\"B\",IF(S12<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit à deux versants'!K6","v":"Semi urbain"},{"$f":"INDEX(O4:P7, MATCH(S13, M4:M6, 0), MATCH(T13, O3:P3, 0))","v":1.1599999999999999},{"$f":"U13^2*'Toit à deux versants'!C13","v":0.75353599999999998}]
[3,"Ostseeküste und –inseln",0.8,0.95,1.1000000000000001,"3Ostseeküste und –inseln",null,null,{"$f":"IF(I13<=10,\"A\",IF(I13<=20,\"B\",IF(I13<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"C"},{"$f":"Mur!K6","v":"urbain dense"},{"$f":"INDEX(O4:P7, MATCH(I14, M4:M6, 0), MATCH(J14, O3:P3, 0))","v":1.04},{"$f":"K14^2*Mur!C13","v":0.34611200000000003},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF('Toit à deux versants'!K4=\"Allemagne\", V12, IF('Toit à deux versants'!K4=\"Maroc\", V13, FALSE)),2)","v":1.1499999999999999}]
[3,"Binnenland",1.05,1.2,1.3,"3Binnenland",null,null,null,null,null,{"$f":"ROUND(IF(Mur!K4=\"Allemagne\", L13, IF(Mur!K4=\"Maroc\", L14, FALSE)),2)","v":0.75}]
[4,"Binnenland",0.95,1.1499999999999999,1.3,"4Binnenland"]
[4,"Ostseeküste, Nordseeküste",1.25,1.4,1.55,"4Ostseeküste, Nordseeküste",null,null,null,null,null,null,null,null,null,null,null,"höhe",{"$f":"'Toit à deux versants V'!O4","v":18},{"$f":"IF(S17<=10,\"A\",IF(S17<=18,\"B\",IF(S17<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit à deux versants V'!K5&'Toit à deux versants V'!L5","v":"2Binnenland"},{"$f":"INDEX(C11:F18, MATCH(U17, F11:F18, 0), MATCH(T17, C10:F10, 0))","v":0.8},"Toit a deux versant V"]
[4,"Nordseeinseln",1.4,"x","x","4Nordseeinseln",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S17<=10,\"A\",IF(S17<=20,\"B\",IF(S17<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit à deux versants V'!K6","v":"Semi urbain"},{"$f":"INDEX(O4:P7, MATCH(S18, M4:M6, 0), MATCH(T18, O3:P3, 0))","v":1.1599999999999999},{"$f":"U18^2*'Toit à deux versants V'!C13","v":1.4532480000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF('Toit à deux versants V'!K4=\"Allemagne\", V17, IF('Toit à deux versants V'!K4=\"Maroc\", V18, FALSE)),2)","v":1.45}]
["Erklärung A B C"]
[null,"A",0,10]
[null,"B",10,18,null,null,null,null,null,null,null,null,null,null,null,null,null,"höhe",{"$f":"'Toit en pavillon'!O4","v":18},{"$f":"IF(S22<=10,\"A\",IF(S22<=18,\"B\",IF(S22<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit en pavillon'!K5&'Toit en pavillon'!L5","v":"2Binnenland"},{"$f":"INDEX(C11:F18, MATCH(U22, F11:F18, 0), MATCH(T22, C10:F10, 0))","v":0.8},"Pavillon"]
[null,"C",18,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S22<=10,\"A\",IF(S22<=20,\"B\",IF(S22<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"'Toit en pavillon'!K6","v":"Semi urbain"},{"$f":"INDEX(O4:P7, MATCH(S23, M4:M6, 0), MATCH(T23, O3:P3, 0))","v":1.1599999999999999},{"$f":"U23^2*'Toit en pavillon'!$C$13","v":1.4532480000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF('Toit en pavillon'!K4=\"Allemagne\", V22, IF('Toit en pavillon'!K4=\"Maroc\", V23, FALSE)),2)","v":1.45}]
[]
["Mur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"höhe",{"$f":"Auvent!O4","v":18},{"$f":"IF(S27<=10,\"A\",IF(S27<=18,\"B\",IF(S27<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"Auvent!K5&Auvent!L5","v":"2Binnenland"},{"$f":"INDEX(C11:F18, MATCH(U27, F11:F18, 0), MATCH(T27, C10:F10, 0))","v":0.8},"Au vent"]
["Bereich","A","A","B","B","C","C","D","D","E","E",null,null,null,null,null,null,null,{"$f":"IF(S27<=10,\"A\",IF(S27<=20,\"B\",IF(S27<=25,\"C\",\"Außerhalb der Bereiche\")))","v":"B"},{"$f":"Auvent!K6","v":"Semi urbain"},{"$f":"INDEX(O4:P7, MATCH(S28, M4:M6, 0), MATCH(T28, O3:P3, 0))","v":1.1599999999999999},{"$f":"U28^2*Auvent!C13","v":1.4532480000000001}]
["h/d","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(Auvent!K4=\"Allemagne\", V27, IF(Auvent!K4=\"Maroc\", V28, FALSE)),2)","v":1.45}]
[5,-1.4,-1.7,-0.8,-1.1000000000000001,-0.5,-0.7,0.8,1,-0.5,-0.7]
[1,-1.2,-1.4,-0.8,-1.1000000000000001,-0.5,-0.5,0.8,1,-0.5,-0.5]
[0.25,-1.2,-1.4,-0.8,-1.1000000000000001,-0.5,-0.5,0.7,1,-0.3,-0.7]
[]
[null,"h/d",{"$f":"Mur!D26","v":4},"A",{"$f":"VLOOKUP(B35,A30:B32,2,FALSE)","v":-1.2},null,null,"h/d",{"$f":"Mur!D80","v":0},"A",{"$f":"VLOOKUP(B35,A30:B32,2,FALSE)","v":-1.2},null,null,null,null,null,"Toit plat"]
[null,{"$f":"IF(C34>=5,5,IF(C34<5,1,IF(C34<1,0.25,\"Außerhalb der Bereiche\")))","v":1},null,"B",{"$f":"VLOOKUP(B35,A30:D32,4,FALSE)","v":-0.8},null,null,{"$f":"IF(I34>=5,5,IF(I34<5,1,IF(I34<1,0.25,\"Außerhalb der Bereiche\")))","v":1},null,"B",{"$f":"VLOOKUP(B35,A30:D32,4,FALSE)","v":-0.8},null,null,null,null,null,null,null,"F",null,"G",null,"H",null,"I"]
[null,null,null,"C",{"$f":"VLOOKUP(B35,A30:F32,6,FALSE)","v":-0.5},null,null,null,null,"C",{"$f":"VLOOKUP(B35,A30:F32,6,FALSE)","v":-0.5},null,null,null,null,null,null,null,"Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1"]
[null,null,null,"D",{"$f":"VLOOKUP(B35,A30:H32,8,FALSE)","v":0.8},null,null,null,null,"D",{"$f":"VLOOKUP(B35,A30:H32,8,FALSE)","v":0.8},null,null,null,null,null,"Zone de rive à bord tranchant","Zone de rive à bord tranchant",-1.8,-2.5,-1.2,-2,-0.7,-1.2,0.2,-0.6]
[null,null,null,"E",{"$f":"VLOOKUP(B35,A30:J32,10,FALSE)","v":-0.5},null,null,null,null,"E",{"$f":"VLOOKUP(B35,A30:J32,10,FALSE)","v":-0.5},null,null,null,null,null,"avec acrotère","hp/h=0,025",-1.6,-2.2000000000000002,-1.1000000000000001,-1.8,-0.7,-1.2,0.2,-0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hp/h=0,05",-1.4,-2,-0.9,-1.6,-0.7,-1.2,0.2,-0.6]
["2 VV","F",null,"G",null,"H",null,"I",null,"J",null,null,null,null,null,null,null,"hp/h=0,10",-1.2,-1.8,-0.8,-1.4,-0.7,-1.2,0.2,-0.6]
["Trogdach 0°","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1",null,null,null,null,null," Zone de rive arrondie","r/h=0,05",-1,-1.5,-1.2,-1.8,-0.4,-0.4,0.2,-0.2]
[-45,-0.6,-0.6,-0.6,-0.6,-0.8,-0.8,-0.7,-0.7,-1,-1.5,null,null,null,null,null,null,"r/h=0,10",-0.7,-1.2,-0.8,-1.4,-0.3,-0.3,0.2,-0.2]
[-30,-1.1000000000000001,-2,-0.8,-1.5,-0.8,-0.8,-0.6,-0.6,-0.8,-1.4,null,null,null,null,null,null,"r/h=0,20",-0.5,-0.8,-0.5,-0.8,-0.3,-0.3,0.2,-0.02]
[-15,-2.5,-2.8,-1.3,-2,-0.9,-1.2,-0.5,-0.5,-0.7,-1.2,null,null,null,null,null," Zone de rive en pente","alphq=30",-1,-1.5,-1,-1.5,-0.3,-0.3,0.2,-0.2]
[-5,-2.2999999999999998,-2.5,-1.2,-2,-0.8,-1.2,-0.6,-0.6,-0.6,-0.6,null,null,null,null,null,null,"alpha=45",-1.2,-1.8,-1.3,-1.9,-0.4,-0.4,0.2,-0.2]
[null,"F",null,"G",null,"H",null,"I",null,null,null,null,null,null,null,null,null,"alpha=60",-1.3,-1.9,-1.3,-1.9,-0.5,-0.5,0.2,-0.2]
["Trogdach 90°","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1"]
[-45,-1.4,-2,-1.2,-2,-1,-1.3,-0.9,-1.2,null,null,null,null,null,null,null,null,"hp/h=",{"$f":"IF('Toit plat'!K8=W_daten!Q37,\"\",\nIF('Toit plat'!K8=W_daten!Q38,'Toit plat'!K9/'Toit plat'!O4,\nIF('Toit plat'!K8=W_daten!Q41,\"\",IF('Toit plat'!K8=W_daten!Q44,\"\",\n\"\"))))","v":0.5},"alpha/h=",{"$f":"IF('Toit plat'!K8=W_daten!Q37,\"\",\nIF('Toit plat'!K8=W_daten!Q38,\"\",\nIF('Toit plat'!K8=W_daten!Q41,\"\",IF('Toit plat'!K8=W_daten!Q44,'Toit plat'!K9/'Toit plat'!O4,\n\"\"))))","v":""},null,null,null,"hp/h=",{"$f":"IF('Toit plat'!Q8=W_daten!X37,\"\",\nIF('Toit plat'!Q8=W_daten!X38,'Toit plat'!R9/'Toit plat'!V4,\nIF('Toit plat'!Q8=W_daten!X41,\"\",IF('Toit plat'!Q8=W_daten!X44,\"\",\n\"\"))))","v":""},"alpha/h=",{"$f":"IF('Toit plat'!Q8=W_daten!X37,\"\",\nIF('Toit plat'!Q8=W_daten!X38,\"\",\nIF('Toit plat'!Q8=W_daten!X41,\"\",IF('Toit plat'!Q8=W_daten!X44,'Toit plat'!R9/'Toit plat'!V4,\n\"\"))))","v":""}]
[-30,-1.5,-2.1,-1.2,-2,-1,-1.3,-0.9,-1.2,null,null,null,null,null,null,null,null,"Cas1","Cas2","Cas3","Cas 4","Resultat",null,null,"Cas1","Cas2","Cas3","Cas 4","Resultat"]
[-15,-1.9,-2.5,-1.2,-2,-0.8,-1.2,-0.8,-1.2,null,null,null,null,null,null,null,"F",{"$f":"S37","v":-1.8},{"$f":"VLOOKUP(S55,R38:S40,2,FALSE)","v":-1.2},{"$f":"VLOOKUP(T55,R41:T43,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U55,R44:T46,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Toit plat'!K8=W_daten!Q37,R50,\nIF('Toit plat'!K8=W_daten!Q38,S50,\nIF('Toit plat'!K8=W_daten!Q41,T50,IF('Toit plat'!K8=W_daten!Q44,U50,\n\"\"))))","v":-1.2},null,"I",{"$f":"Z37","v":-0.6},null,null,null,{"$f":"Y50","v":-0.6}]
[-5,-1.8,-2.5,-1.2,-2,-0.7,-1.2,-0.6,-1.2,null,null,null,null,null,null,null,"G",{"$f":"U37","v":-1.2},{"$f":"VLOOKUP(S55,R38:V40,4,FALSE)","v":-0.8},{"$f":"VLOOKUP(T55,R41:U43,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U55,R44:U46,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Toit plat'!K8=W_daten!Q37,R51,\nIF('Toit plat'!K8=W_daten!Q38,S51,\nIF('Toit plat'!K8=W_daten!Q41,T51,IF('Toit plat'!K8=W_daten!Q44,U51,\n\"\"))))","v":-0.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",{"$f":"W37","v":-0.7},{"$f":"VLOOKUP(S55,R38:W40,6,FALSE)","v":-0.7},{"$f":"VLOOKUP(T55,R41:W43,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U55,R44:W46,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Toit plat'!K8=W_daten!Q37,R52,\nIF('Toit plat'!K8=W_daten!Q38,S52,\nIF('Toit plat'!K8=W_daten!Q41,T52,IF('Toit plat'!K8=W_daten!Q44,U52,\n\"\"))))","v":-0.7}]
["alpha","cas 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I",{"$f":"Y37","v":0.2},{"$f":"VLOOKUP(S55,R38:Y40,8,FALSE)","v":0.2},{"$f":"VLOOKUP(T55,R41:Y43,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U55,R44:Y46,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Toit plat'!K8=W_daten!Q37,R53,\nIF('Toit plat'!K8=W_daten!Q38,S53,\nIF('Toit plat'!K8=W_daten!Q41,T53,IF('Toit plat'!K8=W_daten!Q44,U53,\n\"\"))))","v":0.2}]
[{"$f":"'Toit à deux versants V'!K9","v":-12},null,null,"cas1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r/h=",{"$f":"IF('Toit plat'!K8=W_daten!Q37,\"\",\nIF('Toit plat'!K8=W_daten!Q38,\"\",\nIF('Toit plat'!K8=W_daten!Q41,'Toit plat'!K9/'Toit plat'!O4,IF('Toit plat'!K8=W_daten!Q44,\"\",\n\"\"))))","v":""}]
[null,{"$f":"IF(A54<=-45,-45,\nIF(A54<=-30,-30,\nIF(A54<=-15,-15,\nIF(A54<=-5,-5,\n\"Außerhalb der Bereiche\"))))","v":-5},"F",{"$f":"VLOOKUP(B55,A41:B45,2,FALSE)","v":-2.2999999999999998},null,null,null,{"$f":"B55","v":-5},"F",{"$f":"VLOOKUP(H55,A47:B51,2,FALSE)","v":-1.8},null,null,null,null,null,null,null,null,{"$f":"IF(S48=\"\", \"\",\nIF(S48<=0.025, R38,\nIF(AND(S48>0.025, S48<=0.05), R39,\nIF(S48>0.05, R40,\nIF(S48=0, \"Autre\", \"\")))))","v":"hp/h=0,10"},{"$f":"IF(T54=\"\", \"\",\nIF(T54<=0.05, R41,\nIF(AND(T54>0.05, T54<=0.1), R42,\nIF(T54>0.01, R43,\nIF(T54=0, \"Autre\", \"\")))))","v":""},{"$f":"IF(U48=\"\", \"\",\nIF(U48<=0.05, R44,\nIF(AND(U48>0.05, U48<=0.1), R45,\nIF(U48>0.01, R46,\nIF(U48=0, \"Autre\", \"\")))))","v":""}]
[null,null,"G",{"$f":"VLOOKUP(B55,A42:D45,4,FALSE)","v":-1.2},null,null,null,null,"G",{"$f":"VLOOKUP(H55,A48:D51,4,FALSE)","v":-1.2}]
[null,null,"H",{"$f":"VLOOKUP(B55,A42:F45,6,FALSE)","v":-0.8},null,null,null,null,"H",{"$f":"VLOOKUP(H55,A48:F51,6,FALSE)","v":-0.7}]
[null,null,"I",{"$f":"VLOOKUP(B55,A42:H45,8,FALSE)","v":-0.6},null,null,null,null,"I",{"$f":"VLOOKUP(H55,A48:H51,8,FALSE)","v":-0.6},null,null,null,null,null,null,"Toit momopente","0deg","F",null,"G",null,"H"]
[null,null,"J",{"$f":"VLOOKUP(B55,A42:J45,10,FALSE)","v":-0.6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,-1.7,-2.5,-1.2,-2,-0.6,-0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5A",0,0,0,0,0,0]
["2V",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,-0.9,-2,-0.8,-1.5,-0.3,-0.3]
[null,"F",null,"G",null,"H",null,"I",null,"J",null,null,null,null,null,null,null,"15A",0.2,0.2,0.2,0.2,0.2,0.2]
["Satteldach 0°","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1",null,null,null,null,null,null,30,-0.5,-1.5,-0.5,-1.5,-0.2,-0.2]
[5,-1.7,-2.5,-1.2,-2,-0.6,-1.2,-0.6,-0.6,0.2,0.2,null,null,null,null,null,null,"30A",0.7,0.7,0.7,0.7,0.4,0.4]
["5A",0,0,0,0,0,0,-0.6,-0.6,-0.6,-0.6,null,null,null,null,null,null,45,0,0,0,0,0,0]
[15,-0.9,-2,-0.8,-1.5,-0.3,-0.3,-0.4,-0.4,-1,-1.5,null,null,null,null,null,null,"45A",0.7,0.7,0.7,0.7,0.6,0.6]
["15A",0.2,0.2,0.2,0.2,0.2,0.2,0,0,0,0,null,null,null,null,null,null,60,0.7,0.7,0.7,0.7,0.7,0.7]
[30,-0.5,-1.5,-0.5,-1.5,-0.2,-0.2,-0.4,-0.4,-0.5,-0.5,null,null,null,null,null,null,75,0.8,0.8,0.8,0.8,0.8,0.8]
["30A",0.7,0.7,0.7,0.7,0.4,0.4,0,0,0,0,null,null,null,null,null,"alpha","cas 0",null,null,"cas1","cas2"]
[45,0,0,0,0,0,0,-0.2,-0.2,-0.3,-0.3,null,null,null,null,null,{"$f":"'Toit monopente'!K9","v":15},null,"Resultat","F",{"$f":"VLOOKUP(R72,R60:S69,2,FALSE)","v":-0.9},{"$f":"VLOOKUP(R73,R60:S69,2,FALSE)","v":0.2}]
["45A",0.7,0.7,0.7,0.7,0.6,0.6,0,0,0,0,null,null,null,null,null,null,{"$f":"IF(Q71<=10,5,\nIF(Q71<=28,15,\nIF(Q71<=42,30,\nIF(Q71<=50,45,\nIF(Q71<=65,60,\nIF(Q71<=75,75,\n\"Außerhalb der Bereiche\"))))))","v":15},null,"G",{"$f":"VLOOKUP(R72,R60:U69,4,FALSE)","v":-0.8},{"$f":"VLOOKUP(R73,R60:U69,4,FALSE)","v":0.2}]
[60,0.7,0.7,0.7,0.7,0.7,0.7,-0.2,-0.2,-0.3,-0.3,null,null,null,null,null,null,{"$f":"IF(Q71<=10,\"5A\",\nIF(Q71<=28,\"15A\",\nIF(Q71<=42,\"30A\",\nIF(Q71<=50,\"45A\",\nIF(Q71<=65,60,\nIF(Q71<=75,75,\n\"Außerhalb der Bereiche\"))))))","v":"15A"},null,"H",{"$f":"VLOOKUP(R72,R60:W69,6,FALSE)","v":-0.3},{"$f":"VLOOKUP(R73,R60:W69,6,FALSE)","v":0.2}]
[75,0.8,0.8,0.8,0.8,0.8,0.8,-0.2,-0.2,-0.3,-0.3]
[]
[]
[null,"F",null,"G",null,"H",null,"I"]
["Satteldach 90°","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1"]
[5,-1.6,-2.2000000000000002,-1.3,-2,-0.7,-1.2,-0.6,-0.6,null,null,null,null,null,null,null,null,"180deg","F",null,"G",null,"H"]
[15,-1.3,-2,-1.3,-2,-0.6,-1.2,-0.5,-0.5,null,null,null,null,null,null,null,null,null,"Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1"]
[30,-1.1000000000000001,-1.5,-1.4,-2,-0.8,-1.2,-0.5,-0.5,null,null,null,null,null,null,null,null,5,-2.2999999999999998,-2.5,-1.3,-2,-0.8,-1.2]
[45,-1.1000000000000001,-1.5,-1.4,-2,-0.9,-1.2,-0.5,-0.5,null,null,null,null,null,null,null,null,15,-2.5,-2.8,-1.3,-2,-0.9,-1.2]
[60,-1.1000000000000001,-1.5,-1.2,-2,-0.8,-1,-0.5,-0.5,null,null,null,null,null,null,null,null,30,-1.1000000000000001,-2.2999999999999998,-0.8,-1.5,-0.88,-0.8]
[75,-1.1000000000000001,-1.5,-1.2,-2,-0.8,-1,-0.5,-0.5,null,null,null,null,null,null,null,null,45,-0.6,-1.3,-0.5,-0.5,-0.7,-0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,-0.5,-1,-0.5,-0.5,-0.5,-0.5]
["2V",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,-0.5,-1,-0.5,-0.5,-0.5,-0.5]
["alpha","cas 0",null,null,null,"CAS 90",null,null,null,null,null,null,null,null,null,null,null,"cas 180",null,null,null,null,"Cas 90"]
[{"$f":"'Toit à deux versants'!K9","v":7},null,null,"cas1","cas2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Resultat","F",{"$f":"VLOOKUP(R89,R79:S86,2,FALSE)","v":-2.5},null,null,"Fh",{"$f":"VLOOKUP(R89,R96:S103,2,FALSE)","v":-2.4}]
[null,{"$f":"IF(A88<=10,5,\nIF(A88<=28,15,\nIF(A88<=42,30,\nIF(A88<=50,45,\nIF(A88<=65,60,\nIF(A88<=75,75,\n\"Außerhalb der Bereiche\"))))))","v":5},"F",{"$f":"VLOOKUP(B89,A65:B74,2,FALSE)","v":-1.7},{"$f":"VLOOKUP(B90,A65:B74,2,FALSE)","v":0},{"$f":"B89","v":5},"F",{"$f":"VLOOKUP(F89,A77:B84,2,FALSE)","v":-1.6},null,null,null,null,null,null,null,null,null,{"$f":"R72","v":15},null,"G",{"$f":"VLOOKUP(R89,R79:U86,4,FALSE)","v":-1.3},null,{"$f":"R89","v":15},"Fbas",{"$f":"VLOOKUP(R89,R97:U103,4,FALSE)","v":-1.6}]
[null,{"$f":"IF(A88<=10,\"5A\",\nIF(A88<=28,\"15A\",\nIF(A88<=42,\"30A\",\nIF(A88<=50,\"45A\",\nIF(A88<=65,60,\nIF(A88<=75,75,\n\"Außerhalb der Bereiche\"))))))","v":"5A"},"G",{"$f":"VLOOKUP(B89,A65:D74,4,FALSE)","v":-1.2},{"$f":"VLOOKUP(B90,A65:D74,4,FALSE)","v":0},{"$f":"B90","v":"5A"},"G",{"$f":"VLOOKUP(F89,A77:D84,4,FALSE)","v":-1.3},null,null,null,null,null,null,null,null,null,null,null,"H",{"$f":"VLOOKUP(R89,R79:W86,6,FALSE)","v":-0.9},null,null,"G",{"$f":"VLOOKUP(R89,R97:W103,6,FALSE)","v":-1.9}]
[null,null,"H",{"$f":"VLOOKUP(B89,A65:F74,6,FALSE)","v":-0.6},{"$f":"VLOOKUP(B90,A65:F74,6,FALSE)","v":0},null,"H",{"$f":"VLOOKUP(F89,A77:F84,6,FALSE)","v":-0.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",{"$f":"VLOOKUP(R89,R97:Y103,8,FALSE)","v":-0.8}]
[null,null,"I",{"$f":"VLOOKUP(B89,A65:H74,8,FALSE)","v":-0.6},{"$f":"VLOOKUP(B90,A65:H74,8,FALSE)","v":-0.6},null,"I",{"$f":"VLOOKUP(F89,A77:H84,8,FALSE)","v":-0.6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I",{"$f":"VLOOKUP(R89,R98:AA103,10,FALSE)","v":-0.7}]
[null,null,"J",{"$f":"VLOOKUP(B89,A65:J74,10,FALSE)","v":0.2},{"$f":"VLOOKUP(B90,A65:J74,10,FALSE)","v":-0.6}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90deg","F h",null,"Fbas",null,"G",null,"H",null,"I"]
[null,"Auvent","A1","A2",null,"B1","B2",null,null,null,null,null,null,null,null,null,null,null,"Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1"]
[null,null,"descendant","ascendant h1/d1<=1","ascendant h1/d1>1","descendant","ascendant h1/d1<=1","ascendant h1/d1>1",null,null,null,null,null,null,null,null,null,5,-2.1,-2.6,-2.1,-2.4,-1.8,-2,-0.6,-1.2,-0.5,-0.5]
[null,0.1,1.1000000000000001,-0.9,-1.4,0.9,-0.2,-0.5,null,null,null,null,null,null,null,null,null,15,-2.4,-2.9,-1.6,-2.4,-1.9,-2.5,-0.8,-1.2,-0.7,-1.2]
[null,0.2,0.8,-0.9,-1.4,0.5,-0.2,-0.5,null,null,null,null,null,null,null,null,null,30,-2.1,-2.9,-1.3,-2,-1.5,-2,-1,-1.3,-0.8,-1.2]
[null,0.3,0.7,-0.9,-1.4,0.4,-0.2,-0.5,null,null,null,null,null,null,null,null,null,45,-1.5,-2.4,-1.3,-2,-1.4,-2,-1,-1.3,-0.9,-1.2]
[null,0.4,0.7,-1,-1.5,0.3,-0.2,-0.5,null,null,null,null,null,null,null,null,null,60,-1.2,-2,-1.2,-2,-1.2,-2,-1,-1.3,-0.7,-1.2]
[null,0.5,0.7,-1,-1.5,0.3,-0.2,-0.5,null,null,null,null,null,null,null,null,null,75,-1.2,-2,-1.2,-2,-1.2,-2,-1,-1.3,-0.5,-0.5]
[null,0.6,0.7,-1.1000000000000001,-1.6,0.3,-0.4,-0.7]
[null,0.7,0.7,-1.2,-1.7,0.3,-0.7,-1]
[null,0.8,0.7,-1.4,-1.9,0.3,-1,-1.3]
[null,0.9,0.7,-1.7,-2.2000000000000002,0.3,-1.3,-1.6]
[null,1,0.7,-2,-2.5,0.3,-1.6,-1.9]
[]
[]
[null,null,null,"Resultat"]
[null,null,"h1/d1",{"$f":"Auvent!O8/Auvent!O7","v":2.6666666666666665},"A",{"$f":"VLOOKUP(B113,B99:C108,2,FALSE)","v":0.8},"A",{"$f":"IF(B113<2,VLOOKUP(B113,B98:E108,3,FALSE),VLOOKUP(B113,B98:E108,4,FALSE))","v":-0.9}]
[null,{"$f":"IF(D113<0.1,0.1,\nIF(D113<0.2,0.1,\nIF(D113<0.3,0.2,\nIF(D113<0.4,0.3,\nIF(D113<0.5,0.4,\nIF(D113<0.6,0.5,\nIF(D113<0.7,0.6,\nIF(D113<0.8,0.7,\nIF(D113<0.9,0.8,\nIF(D113<1,0.9,1))))))))))","v":0.2},"h1/h",{"$f":"Auvent!O8/Auvent!O4","v":0.22222222222222221},"B",{"$f":"VLOOKUP(B113,B99:F108,5,FALSE)","v":0.5},"B",{"$f":"IF(B113<2,VLOOKUP(B113,B98:G108,6,FALSE),VLOOKUP(B113,B98:H108,7,FALSE))","v":-0.2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2V"]
[null,"F",null,"G",null,"H",null,"I",null,"J",null,"K",null,"L",null,"M",null,"N"]
["Toit Pavillon","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1","Cpe,10","Cpe,1"]
[5,-1.7,-2.5,-1.2,-2,-0.6,-1.2,-0.3,-0.3,-0.6,-0.6,-0.6,-0.6,-1.2,-2,-0.6,-1.2,-0.4,-0.4]
["5A",0,0,0,0,0,0,-0.3,-0.3,-0.6,-0.6,-0.6,-0.6,-1.2,-2,-0.6,-1.2,-0.4,-0.4]
[15,-0.9,-2,-0.8,-1.5,-0.3,-0.3,-0.5,-0.5,-1,-1.5,-1.2,-2,-1.4,-2,-0.6,-1.2,-0.3,-0.3]
["15A",0.2,0.2,0.2,0.2,0.2,0.2,-0.5,-0.5,-1,1.5,-1.2,-2,-1.4,-2,-0.6,-1.2,-0.3,-0.3]
[30,-0.5,-1.5,-0.5,-1.5,-0.2,-0.2,-0.4,-0.4,-0.7,-1.2,-0.5,-0.5,-1.4,-2,-0.8,-1.2,-0.2,-0.2]
["30A",0.5,0.5,0.7,0.7,0.4,0.4,-0.4,-0.4,-0.7,-1.2,-0.5,-0.5,-1.4,-2,-0.8,-1.2,-0.2,-0.2]
[45,0,0,0,0,0,0,-0.3,-0.3,-0.6,-0.6,-0.3,-0.3,-1.3,-2,-0.8,-1.2,-0.2,-0.2]
["45A",0.7,0.7,0.7,0.7,0.6,0.6,-0.3,-0.3,-0.6,-0.6,-0.3,-0.3,-1.3,-2,-0.8,-1.2,-0.2,-0.2]
[60,0.7,0.7,0.7,0.7,0.7,0.7,-0.3,-0.3,-0.6,-0.6,-0.3,-0.3,-1.2,-2,-0.4,-0.4,-0.2,-0.2]
[75,0.8,0.8,0.8,0.8,0.8,0.8,-0.3,-0.3,-0.6,-0.6,-0.3,-0.3,-1.2,-2,-0.4,-0.4,-0.2,-0.2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["alpha","cas 0",null,null,null,"CAS 90"]
[{"$f":"'Toit en pavillon'!K9","v":12},null,null,"cas1","cas2",{"$f":"'Toit en pavillon'!K10","v":13}]
[null,{"$f":"IF(A161<=10,5,\nIF(A161<=28,15,\nIF(A161<=42,30,\nIF(A161<=50,45,\nIF(A161<=65,60,\nIF(A161<=75,75,\n\"Außerhalb der Bereiche\"))))))","v":15},"F",{"$f":"VLOOKUP(B162,A138:B147,2,FALSE)","v":-0.9},{"$f":"VLOOKUP(B163,A138:B147,2,FALSE)","v":0.2},{"$f":"IF(F161<=10,5,\nIF(F161<=28,15,\nIF(F161<=42,30,\nIF(F161<=50,45,\nIF(F161<=65,60,\nIF(F161<=75,75,\n\"Außerhalb der Bereiche\"))))))","v":15},"F",{"$f":"VLOOKUP(B162,A138:B147,2,FALSE)","v":-0.9},{"$f":"VLOOKUP(B163,A138:B147,2,FALSE)","v":0.2}]
[null,{"$f":"IF(A161<=10,\"5A\",\nIF(A161<=28,\"15A\",\nIF(A161<=42,\"30A\",\nIF(A161<=50,\"45A\",\nIF(A161<=65,60,\nIF(A161<=75,75,\n\"Außerhalb der Bereiche\"))))))","v":"15A"},"G",{"$f":"VLOOKUP(B162,A138:D147,4,FALSE)","v":-0.8},{"$f":"VLOOKUP(B163,A138:D147,4,FALSE)","v":0.2},{"$f":"IF(F161<=10,\"5A\",\nIF(F161<=28,\"15A\",\nIF(F161<=42,\"30A\",\nIF(F161<=50,\"45A\",\nIF(F161<=65,60,\nIF(F161<=75,75,\n\"Außerhalb der Bereiche\"))))))","v":"15A"},"G",{"$f":"VLOOKUP(B162,A138:D147,4,FALSE)","v":-0.8},{"$f":"VLOOKUP(B163,A138:D147,4,FALSE)","v":0.2}]
[null,null,"H",{"$f":"VLOOKUP(B162,A138:F147,6,FALSE)","v":-0.3},{"$f":"VLOOKUP(B163,A138:F147,6,FALSE)","v":0.2},null,"H",{"$f":"VLOOKUP(B162,A138:F147,6,FALSE)","v":-0.3},{"$f":"VLOOKUP(B163,A138:F147,6,FALSE)","v":0.2}]
[null,null,"I",{"$f":"VLOOKUP(B162,A138:H147,8,FALSE)","v":-0.5},{"$f":"VLOOKUP(B163,A138:H147,8,FALSE)","v":-0.5},null,"I",{"$f":"VLOOKUP(B162,A138:H147,8,FALSE)","v":-0.5},{"$f":"VLOOKUP(B163,A138:H147,8,FALSE)","v":-0.5}]
[null,null,"J",{"$f":"VLOOKUP(B162,A138:J147,10,FALSE)","v":-1},{"$f":"VLOOKUP(B163,A138:J147,10,FALSE)","v":-1},null,"J",{"$f":"VLOOKUP(B162,A138:J147,10,FALSE)","v":-1},{"$f":"VLOOKUP(B163,A138:J147,10,FALSE)","v":-1}]
[null,null,"K",{"$f":"VLOOKUP(B162,A137:L147,12,FALSE)","v":-1.2},{"$f":"VLOOKUP(B163,A137:L147,12,FALSE)","v":-1.2},null,"K",{"$f":"VLOOKUP(B162,A137:L147,12,FALSE)","v":-1.2},{"$f":"VLOOKUP(B163,A137:L147,12,FALSE)","v":-1.2}]
[null,null,"L",{"$f":"VLOOKUP(B162,A138:N147,14,FALSE)","v":-1.4},{"$f":"VLOOKUP(B163,A138:N147,14,FALSE)","v":-1.4},null,"L",{"$f":"VLOOKUP(B162,A138:N147,14,FALSE)","v":-1.4},{"$f":"VLOOKUP(B163,A138:N147,14,FALSE)","v":-1.4}]
[null,null,"M",{"$f":"VLOOKUP(B162,A138:P147,16,FALSE)","v":-0.6},{"$f":"VLOOKUP(B163,A138:P147,16,FALSE)","v":-0.6},null,"M",{"$f":"VLOOKUP(B162,A138:P147,16,FALSE)","v":-0.6},{"$f":"VLOOKUP(B163,A138:P147,16,FALSE)","v":-0.6}]
[null,null,"N",{"$f":"VLOOKUP(B162,A138:R147,18,FALSE)","v":-0.3},{"$f":"VLOOKUP(B163,A138:R147,18,FALSE)","v":-0.3},null,"N",{"$f":"VLOOKUP(B162,A138:R147,18,FALSE)","v":-0.3},{"$f":"VLOOKUP(B163,A138:R147,18,FALSE)","v":-0.3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5zj5h"]

{"sheet":"Explication","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Ce fichier Excel permet le calcul des charges de vent selon l’Eurocode ; il intègre les zones de vent de l’Allemagne comme exemple et a été adapté pour une utilisation au Maroc. "]
[null,"Il s’agit d’un outil simplifié couvrant les cas les plus courants, tandis qu’un autre fichier séparé traitera les situations particulières. "]
[null,"L’utilisateur n’a qu’à remplir les cellules jaunes et choisir entre le Maroc et l’Allemagne, avec la possibilité d’adapter la vitesse du vent et les textes selon ses besoins."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Choix Mroc-Allemagne"]