{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Couverture","Toit 1 versant","Toit 2 versant","Toit 2x2 N","Toit 2x2 B","Toit C N","Toit C B","Toit +  PaSol","Toit dis","Acc","deb","Daten","Explication"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":11,"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":"Toit 1 versant","index":1,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["Neige"]
[]
["Ce document présente le calcul de la charge de neige agissant sur la toiture, conformément aux prescriptions "]
["de l’Eurocode 1 (EN 1991-1-3). Le toit étudié est un toit plat, sans pente significative. La charge de neige est "]
["déterminée en fonction de la zone climatique, de l’altitude du site, et des coefficients de forme adaptés "]
["à la géométrie du toit."]
[null,null,null,null,null,null,null,null,null,null,null,"Zone","Zone1",null,"peut etre modifier"]
[null,null,null,null,null,null,null,null,null,null,null,"A",10,null,"sk",{"$f":"ROUND(Daten!G10,2)","v":0.65}]
[null,null,null,null,null,null,null,null,null,null,null,"α",11]
[null,null,null,null,null,{"$f":"Daten!H14&\" . \"&Daten!I10&\"kN/m² = \"&Daten!H14*Daten!I10&\"kN/m²\"","v":"0,8 . 0,65kN/m² = 0,52kN/m²"}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"M10","v":11}]

{"sheet":"Toit 2 versant","index":2,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Ce document présente le calcul de la charge de neige agissant sur la toiture, conformément aux prescriptions "]
["de l’Eurocode 1 (EN 1991-1-3). Le toit étudié est un toit à double pente symétrique, également appelé toit à "]
["deux versants, avec des pentes α₁ et α₂.Le schéma ci-dessous montre les cas de charge de neige en"]
["fonction de différentes configurations"]
[]
[null,{"$f":"Daten!H32&\" . \"&Daten!I27&\" = \"&ROUND(Daten!H32*Daten!I27,2)&\"kN/m²\"","v":"0 . 0,65 = 0kN/m²"},null,null,{"$f":"Daten!Q32&\" . \"&Daten!I27&\" = \"&ROUND(Daten!Q32*Daten!I27,2)&\"kN/m²\"","v":"0,67 . 0,65 = 0,44kN/m²"},null,null,null,null,null,null,"Zone","Zone1",null,"peut etre modifier"]
[null,null,null,null,null,null,null,null,null,null,null,"A",10,null,"sk",{"$f":"ROUND(Daten!G27,2)","v":0.65}]
[null,null,null,null,null,null,null,null,null,null,null,"α1",80]
[null,null,null,null,null,null,null,null,null,null,null,"α2",35]
[]
[null,{"$f":"Daten!H32&\" . \"&Daten!I27&\" = \"&ROUND(Daten!H32*Daten!I27,2)&\"kN/m²\"","v":"0 . 0,65 = 0kN/m²"},null,null,{"$f":"\"0,5 . \"&Daten!Q32&\" . \"&Daten!I27&\" = \"&ROUND(0.5*Daten!Q32*Daten!I27,2)&\"kN/m²\"","v":"0,5 . 0,67 . 0,65 = 0,22kN/m²"}]
[]
[]
[]
[null,{"$f":"\"0,5 . \"&Daten!H32&\" . \"&Daten!I27&\" = \"&ROUND(0.5*Daten!H32*Daten!I27,2)&\"kN/m²\"","v":"0,5 . 0 . 0,65 = 0kN/m²"},null,null,{"$f":"Daten!Q32&\" . \"&Daten!I27&\" = \"&ROUND(Daten!Q32*Daten!I27,2)&\"kN/m²\"","v":"0,67 . 0,65 = 0,44kN/m²"}]
[]
[]
[]
[]
[null,{"$f":"M10","v":80}]
[null,null,{"$f":"M11","v":35}]

{"sheet":"Toit 2x2 N","index":3,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Ce document présente le calcul de la charge de neige agissant sur la toiture, conformément aux prescriptions  de l’Eurocode 1"]
["(EN 1991-1-3). Le toit étudié est constitué de deux versants inclinés, définis deux versants, avec des pentes α₁ et α₂."]
["Le schéma ci-dessous montre les cas de charge de neige en par les angles α₁ et α₂, formant une toiture typique à deux pans."]
["Dans cette configuration, les deux versants sont supposés exposés de manière identique, sans effet de balayage du"]
["vent (cas non balayé). Par conséquent, la charge de neige uniforme est appliquée de manière égale sur chaque pan."]
[null,null,null,null,null,null,null,null,null,null,null,"Zone","Zone1a",null,"peut etre modifier"]
[null,null,null,null,null,null,null,null,null,null,null,"A",450,null,"sk",{"$f":"Daten!G43","v":0.92}]
[null,null,null,{"$f":"0.8*P9&\"kN/m²\"","v":"0,736kN/m²"},null,null,null,null,null,null,null,"α1",10]
[null,null,null,null,null,{"$f":"Daten!Q48&\" . \"&'Toit 2x2 N'!P9 &\" = \"&Daten!Q48*'Toit 2x2 N'!P9&\"kN/m²\"","v":"0,8 . 0,92 = 0,736kN/m²"},null,null,null,null,null,"α2",10]
[{"$f":"Daten!H48&\" . \"&'Toit 2x2 N'!P9 &\" = \"&Daten!H48*'Toit 2x2 N'!P9&\"kN/m²\"","v":"0,8 . 0,92 = 0,736kN/m²"}]
[]
[]
[]
[]
[null,{"$f":"M10","v":10},null,null,null,{"$f":"M11","v":10}]

{"sheet":"Toit 2x2 B","index":4,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Ce document présente le calcul de la charge de neige agissant sur la toiture, conformément aux prescriptions  de l’Eurocode 1"]
["(EN 1991-1-3). Le toit étudié est constitué de deux versants inclinés, définis deux versants, avec des pentes α₁ et α₂."]
["Le schéma ci-dessous montre les cas de charge de neige en par les angles α₁ et α₂, formant une toiture typique à deux pans."]
["Dans cette configuration, l’un des versants est supposé balayé par le vent, ce qui réduit ou élimine l'accumulation de neige "]
["sur ce versant. Par conséquent, la charge de neige est concentrée sur le versant opposé, pouvant atteindre une valeur \n"]
["plus élevée en raison de l'accumulation due au vent."]
[null,null,null,null,null,null,null,null,null,null,null,"Zone","Zone2a",null,"peut etre modifier"]
[null,null,null,null,{"$f":"ROUND(Daten!Z66,2)&\" . \"&P9&\" = \"&ROUND(P9*Daten!Q65,2)&\"kN/m²\"","v":"1,47 . 1,06 = 0,85kN/m²"},null,null,null,null,null,null,"A",10,null,"sk",{"$f":"ROUND(Daten!G60,2)","v":1.06}]
[null,null,{"$f":"Daten!Q65&\" . \"&P9&\" = \"&P9*Daten!Q65&\"kN/m²\"","v":"0,8 . 1,06 = 0,848kN/m²"},null,null,{"$f":"C10","v":"0,8 . 1,06 = 0,848kN/m²"},null,null,null,null,null,"α1",40]
[null,null,null,null,{"$f":"A12","v":"0,53 . 1,06 = 0,5618kN/m²"},null,null,null,null,null,null,"α2",10]
[{"$f":"Daten!H65&\" . \"&P9&\" = \"&P9*Daten!H65&\"kN/m²\"","v":"0,53 . 1,06 = 0,5618kN/m²"}]
[]
[]
[]
[]
[null,{"$f":"M10","v":40},null,null,null,{"$f":"M11","v":10}]

{"sheet":"Toit C N","index":5,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Ce document présente le calcul de la charge de neige agissant sur la toiture, conformément aux prescriptions "]
["de l’Eurocode 1 (EN 1991-1-3).  Étant donné la courbure régulière du toit, sans discontinuités abruptes, "]
["une charge de neige uniformément répartie est appliquée sur la totalité de la surface supérieure."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Zone","Zone1a",null,"peut etre modifier"]
[null,null,null,{"$f":"\"0,8 . \" & P9&\" = \"& 0.8*P9&\"kN/m²\"","v":"0,8 . 0,81 = 0,648kN/m²"},null,null,null,null,null,null,null,"A",10,null,"sk",{"$f":"ROUND(Daten!G78,2)","v":0.81}]

{"sheet":"Toit C B","index":6,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Ce document présente le calcul de la charge de neige agissant sur la toiture, conformément aux prescriptions "]
["de l’Eurocode 1 (EN 1991-1-3).  Étant donné la courbure régulière du toit, sans discontinuités abruptes, "]
["une charge de neige uniformément répartie est appliquée sur la totalité de la surface supérieure."]
["Dans ce cas, la neige est supposée partiellement balayée par le vent, ce qui conduit à une "]
["accumulation de neige réduite sur une partie du toit."]
["Ainsi, une charge complète s’applique sur la zone exposée au vent, tandis qu’une charge réduite ",null,null,null,null,null,null,null,null,null,null,"Zone","Zone1",null,"peut etre modifier"]
["est appliquée sur la zone balayée.",null,null,null,null,null,null,null,null,null,null,"A",20,null,"sk",{"$f":"ROUND(Daten!S78,2)","v":0.65}]
[]
[null,null,null,null,{"$f":"P9&\"kN/m²\"","v":"0,65kN/m²"}]
[null,null,{"$f":"\"0,5 . 1 . \"&P9&\" = \"& 0.5*P9&\"kN/m²\"","v":"0,5 . 1 . 0,65 = 0,325kN/m²"}]

{"sheet":"Toit +  PaSol","index":7,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Ce document présente le calcul de la charge de neige agissant sur la toiture, conformément aux prescriptions "]
["de l’Eurocode 1 (EN 1991-1-3). Dans ce cas, la toiture plate est équipée de panneaux solaires inclinés, "]
["ce qui peut entraîner une accumulation localisée de neige à l’arrière des panneaux. Cette configuration"]
["modifie la répartition de la charge de neige sur le toit, avec une surcharge potentielle dans les zones "]
["situées derrière les panneaux, simulée ici par une zone de charge accrue."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Zone","Zone3",null,"peut etre modifier"]
[null,{"$f":"Daten!H100&\" . \"&P11&\"=\"&Daten!H100*P11&\"kN/m²\"","v":"0,8 . 1,1=0,88kN/m²"},null,null,{"$f":"E36&\" . \"&P11&\"=\"&E36*P11&\"kN/m²\"","v":"1 . 1,1=1,1kN/m²"},null,null,null,null,null,null,"A",10,null,"sk",{"$f":"Daten!G96","v":1.1000000000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"l1",12]
[null,null,null,null,null,null,null,null,null,null,null,"h",2]
[]
[]
[null,null,null,null,null,null,{"$f":"M14","v":2}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"M13","v":12}]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"D25&\" + 2 . \"&H17&\" = \"&D25*H17&\"m\"","v":"12 + 2 .  = 0m"}]
[null,null,null,null,{"$f":"\"min(2 . \"&M14&\"/\"&P11&\" ; 1)\"","v":"min(2 . 2/1,1 ; 1)"}]
[]
[null,null,{"$f":"\"(\"&Daten!H100&\" ; \"&Daten!H101&\")\"","v":"(0,8 ; 0,8)"},null,{"$f":"IF(2*M14/P11>=MAX(Daten!H100,Daten!H101), MIN(2*M14/P11, 1), \"\")","v":1}]

{"sheet":"Toit dis","index":8,"n_rows":70,"n_cols":16,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Ce document présente le calcul de la surcharge de neige due à un saut de hauteur de toiture, conformément aux "]
["prescriptions de l’Eurocode 1 (EN 1991-1-3). Le bâtiment étudié comporte une toiture principale et un appentis "]
["de hauteur inférieure. La configuration génère une accumulation locale de neige sur le toit bas."]
["Le calcul de la charge est effectué en fonction de la hauteur de chute, de la largeur de l’appentis, ainsi que"]
[" des limites géométriques imposées par la norme."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Zone","Zone1",null,"peut etre modifier"]
[null,null,{"$f":"M12","v":5},null,null,null,null,null,null,null,null,"A",50,null,"sk",{"$f":"Daten!G114","v":0.65}]
[null,null,null,null,null,null,null,null,null,null,null,"α",5]
[null,null,null,null,null,null,{"$f":"M13","v":4},null,null,null,null,"h",4,null,"peut etre modifier si le toit n est pas plat  (curvee par exemple) + modifier la description G40"]
[null,null,null,null,null,null,null,null,null,null,null,"b1",40,null,"Mu1",0.8]
[null,null,null,null,null,null,null,null,null,null,null,"b2",3]
[]
[]
[null,null,{"$f":"M14","v":40},null,{"$f":"M15","v":3}]
[]
[]
[]
["Dans un premier temps, la longueur d'accumulation de neige sera déterminée. Elle correspond à deux "]
["fois la hauteur du saut de toiture Cette valeur est ensuite vérifiée par rapport aux limites imposées "]
["par l’Eurocode,"]
[null,null,null,null,{"$f":"2&\" . \"&M13 &\" =\"&2*M13&\"m\"","v":"2 . 4 =8m"}]
["Le coefficient de forme µw est ensuite déterminé en fonction de la géométrie du toit,"]
["conformément à l’Eurocode 1 (EN 1991-1-3). Il représente un coefficient majoré associé à "]
["l’accumulation de neige en pied de saut, et dépend notamment de la hauteur du saut et de la "]
["longueur d’accumulation."]
[]
[null,null,null,{"$f":"\"(\"&C18&\" + \"&E18&\") /\"&2*M13 &\" =\"","v":"(40 + 3) /8 ="},{"$f":"ROUND((C18+E18)/(2*M13),2)","v":5.38}]
[]
[null,null,null,{"$f":"\"2  . \"&M13&\" /\"&P11","v":"2  . 4 /0,65"},{"$f":"ROUND(2*M13/P11,2)","v":12.31}]
[]
[null,null,null,{"$f":"MIN(E33,E31)","v":5.38}]
[{"$f":"IF(M12<=15,\n\"Comme l’inclinaison du toit est inférieure ou égale à 15 degrés, le coefficient de forme est égal à :\",\n\"Comme l’inclinaison du toit est supérieure à 15 degrés, le coefficient de forme est égal à la moitié\")","v":"Comme l’inclinaison du toit est inférieure ou égale à 15 degrés, le coefficient de forme est égal à :"}]
[{"$f":"IF(M12<=15,\n\"\",\n\"celui du toit supérieur, soit 0,8, selon l’hypothèse admise par l’Eurocode.\")","v":""}]
[null,null,null,{"$f":"IF(M12<=15,\n\"0\",\n\"0,5 . 0,8 =0,4\")","v":"0"}]
[null,null,0.8,null,2.4]
[null,null,null,{"$f":"MIN(MAX(0.8,D35),2.4)","v":2.4},null,{"$f":"P14","v":0.8},"toit plat"]
[]
[null,null,null,{"$f":"ROUND(D40*P11,2)","v":1.56},null,{"$f":"ROUND(F40*P11,2)","v":0.52}]
[]
[]
[]
[]
[]
[]
[]
[]
["La charge de neige est modélisée par une charge rectangulaire uniforme, complétée "]
["par une charge triangulaire localisée le long de la zone d’accumulation ls."]
[]
[null,null,{"$f":"2*M13","v":8}]
[{"$f":"D42","v":1.56},null,null,null,null,null,null,null,"Choix de cas si ls est sup ou inf a b2 masquer les cellules depuis le boutton - a gauche"]
[null,null,null,null,{"$f":"F42","v":0.52}]
[]
[]
[null,null,null,{"$f":"C70","v":3}]
[]
[]
[]
["Comme la largeur b1 du toit est inférieure à la longueur d'accumulation ls, la charge de neige est"]
["répartie de manière trapézoïdale sur la surface concernée"]
[]
[]
[{"$f":"D42","v":1.56},null,null,{"$f":"A67*C70/C54","v":0.58499999999999996}]
[]
[]
[null,null,{"$f":"E18","v":3}]

{"sheet":"Acc","index":9,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Ce document présente le calcul de la charge de neige agissant sur la toiture, conformément aux prescriptions "]
["de l’Eurocode 1 (EN 1991-1-3). Le toit étudié est un toit plat, sans pente significative soumis à la présence "]
["d’un obstacle. Lorsqu’un mur ou parapet de hauteur h borde la toiture, la neige y forme un bourrelet avant "]
["de se répartir progressivement sur le reste du toit."]
["Conformément à l’Eurocode 1 (EN 1991-1-3), on distingue deux zones :"]
[". Une zone d’accumulation, immédiatement au pied de l’obstacle, où la charge de neige est majorée,",null,null,null,null,null,null,null,null,null,null,"Zone","Zone1a",null,"peut etre modifier"]
[". Une zone de distribution normale, plus éloignée, où la neige repose de façon habituelle.",null,null,null,null,null,null,null,null,null,null,"A",10,null,"sk",{"$f":"ROUND(Daten!S78,2)","v":0.65}]
[null,null,null,null,null,null,null,null,null,null,null,"h",0.5]
[]
[]
[]
[null,null,null,null,null,{"$f":"\" 2 . \"&M10&\"/\"&P9&\"=\"&ROUND(2*M10/P9,2)&\"kN/m²\"","v":" 2 . 0,5/0,65=1,54kN/m²"}]

{"sheet":"deb","index":10,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Ce document illustre le cas de neige en débord de toiture selon l’Eurocode 1 (EN 1991-1-3) . Lorsqu’un toit "]
["dépasse de son support, une couche de neige peut s’y accumuler sans être retenue par une pente."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Zone","Zone1a",null,"peut etre modifier"]
[null,null,null,null,null,null,null,null,null,null,null,"A",10,null,"sk",{"$f":"ROUND(Daten!S78,2)","v":0.65}]
[]
[null,null,null,null,{"$f":"\"0,4 . \"&P9&\"²/ 3 \"&ROUND(0.4*P9/3,2)&\"kN/m²\"","v":"0,4 . 0,65²/ 3 0,09kN/m²"}]

{"sheet":"Daten","index":11,"n_rows":155,"n_cols":27,"rows_kept":155,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F6<=30,\"0≤α≤30\",\nIF(AND(F6>30,F6<60),\"30<α<60\",\nIF(F6>=60,\"60≤α\",\"\")))","v":"0≤α≤30"}]
["Zone1",{"$f":"0.19+0.91*((F5+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"'Toit 1 versant'!M9","v":10},{"$f":"MAX(B5,D5)","v":0.65}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F5+140)/760)^2)","v":0.2818105090027701},">",0.81,"alpha",{"$f":"'Toit 1 versant'!M10","v":11},{"$f":"MAX(B6,D6)","v":0.81}]
["Zone2",{"$f":"0.25+1.91*((F5+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F5+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06]
["Zone3",{"$f":"0.31+2.91*((F5+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001]
[null,null,null,null,null,"sk(calcul2)",{"$f":"VLOOKUP('Toit 1 versant'!M8,Daten!A5:G9,7)","v":0.65},"sk choisis",{"$f":"'Toit 1 versant'!P9","v":0.65}]
[]
[]
[null,null,"0≤α≤30","30<α<60","60≤α"]
["toit 1 versant","µ1(α)",0.8,{"$f":"0.8*(60-F6)/30","v":1.3066666666666669},0,null,"µ1(α)",{"$f":"HLOOKUP(H4,C13:E14,2,FALSE)","v":0.8}]
["s","µ2(α)",0.8,{"$f":"0.8*(60-F6)/30","v":1.3066666666666669},0,null,"µ2(α)",{"$f":"HLOOKUP(H4,C13:E15,3,FALSE)","v":0.8}]
["IN","µ3(α)",{"$f":"0.8+0.8*F6/30","v":1.0933333333333333},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(H4,C13:E16,4,FALSE)","v":1.0933333333333333}]
[]
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F23<=30,\"0≤α≤30\",\nIF(AND(F23>30,F23<60),\"30<α<60\",\nIF(F23>=60,\"60≤α\",\"\")))","v":"60≤α"},null,null,null,null,null,null,null,"sk1",{"$f":"IF(O23<=30,\"0≤α≤30\",\nIF(AND(O23>30,O23<60),\"30<α<60\",\nIF(O23>=60,\"60≤α\",\"\")))","v":"30<α<60"}]
["Zone1",{"$f":"0.19+0.91*((F22+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"'Toit 2 versant'!M9","v":10},{"$f":"MAX(B22,D22)","v":0.65},null,null,"Zone1",{"$f":"0.19+0.91*((O22+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"F22","v":10},{"$f":"MAX(K22,M22)","v":0.65}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F22+140)/760)^2)","v":0.2818105090027701},">",0.81,"alpha1",{"$f":"'Toit 2 versant'!M10","v":80},{"$f":"MAX(B23,D23)","v":0.81},null,null,"Zone1a",{"$f":"1.25*(0.19+0.91*((O22+140)/760)^2)","v":0.2818105090027701},">",0.81,"alpha2",{"$f":"'Toit 2 versant'!M11","v":35},{"$f":"MAX(K23,M23)","v":0.81}]
["Zone2",{"$f":"0.25+1.91*((F22+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85,null,null,"Zone2",{"$f":"0.25+1.91*((O22+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F22+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06,null,null,"Zone2a",{"$f":"1.25*(0.25+1.91*((O22+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06]
["Zone3",{"$f":"0.31+2.91*((F22+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001,null,null,"Zone3",{"$f":"0.31+2.91*((O22+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001]
[null,null,null,null,null,"sk(calcul2)",{"$f":"VLOOKUP('Toit 2 versant'!M8,Daten!A22:G26,7)","v":0.65},"sk choisis",{"$f":"'Toit 1 versant'!P9","v":0.65},null,null,null,null,null,"sk(calcul2)",{"$f":"G27","v":0.65},"sk choisis",{"$f":"I27","v":0.65}]
[]
[]
[null,null,"0≤α≤30","30<α<60","60≤α",null,null,null,null,null,null,"0≤α≤30","30<α<60","60≤α"]
["toit 2 versant","µ1(α)",0.8,{"$f":"0.8*(60-F23)/30","v":-0.53333333333333333},0,null,"µ1(α)",{"$f":"HLOOKUP(H21,C30:E31,2,FALSE)","v":0},null,"toit 2 versant","µ1(α)",0.8,{"$f":"ROUND(0.8*(60-O23)/30,2)","v":0.67},0,null,"µ1(α)",{"$f":"HLOOKUP(Q21,L30:N31,2,FALSE)","v":0.67}]
["s","µ2(α)",0.8,{"$f":"0.8*(60-F23)/30","v":-0.53333333333333333},0,null,"µ2(α)",{"$f":"HLOOKUP(H21,C30:E32,3,FALSE)","v":0},null,"s","µ2(α)",0.8,{"$f":"ROUND(0.8*(60-O23)/30,2)","v":0.67},0,null,"µ2(α)",{"$f":"HLOOKUP(Q21,L30:N32,3,FALSE)","v":0.67}]
["IN","µ3(α)",{"$f":"0.8+0.8*F23/30","v":2.9333333333333336},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(H21,C30:E33,4,FALSE)","v":1.6},null,"IN","µ3(α)",{"$f":"ROUND(0.8+0.8*O23/30,2)","v":1.73},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(Q21,L30:N33,4,FALSE)","v":1.6}]
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F39<=30,\"0≤α≤30\",\nIF(AND(F39>30,F39<60),\"30<α<60\",\nIF(F39>=60,\"60≤α\",\"\")))","v":"0≤α≤30"},null,null,null,null,null,null,null,"sk1",{"$f":"IF(O39<=30,\"0≤α≤30\",\nIF(AND(O39>30,O39<60),\"30<α<60\",\nIF(O39>=60,\"60≤α\",\"\")))","v":"0≤α≤30"}]
["Zone1",{"$f":"0.19+0.91*((F38+140)/760)^2","v":0.73842624653739608},">",0.65,"A=",{"$f":"'Toit 2x2 N'!M9","v":450},{"$f":"MAX(B38,D38)","v":0.73842624653739608},null,null,"Zone1",{"$f":"0.19+0.91*((O38+140)/760)^2","v":0.73842624653739608},">",0.65,"A=",{"$f":"F38","v":450},{"$f":"MAX(K38,M38)","v":0.73842624653739608}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F38+140)/760)^2)","v":0.92303280817174516},">",0.81,"alpha",{"$f":"'Toit 2x2 N'!M10","v":10},{"$f":"MAX(B39,D39)","v":0.92303280817174516},null,null,"Zone1a",{"$f":"1.25*(0.19+0.91*((O38+140)/760)^2)","v":0.92303280817174516},">",0.81,"alpha",{"$f":"'Toit 2x2 N'!M11","v":10},{"$f":"MAX(K39,M39)","v":0.92303280817174516}]
["Zone2",{"$f":"0.25+1.91*((F38+140)/760)^2","v":1.4010924515235457},">",0.85,null,null,1.4010924515235457,null,null,"Zone2",{"$f":"0.25+1.91*((O38+140)/760)^2","v":1.4010924515235457},">",0.85,null,null,1.4010924515235457]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F38+140)/760)^2)","v":1.7513655644044321},">",1.06,null,null,1.7513655644044321,null,null,"Zone2a",{"$f":"1.25*(0.25+1.91*((O38+140)/760)^2)","v":1.7513655644044321},">",1.06,null,null,1.7513655644044321]
["Zone3",{"$f":"0.31+2.91*((F38+140)/760)^2","v":2.063758656509695},">",1.1000000000000001,null,null,2.063758656509695,null,null,"Zone3",{"$f":"0.31+2.91*((O38+140)/760)^2","v":2.063758656509695},">",1.1000000000000001,null,null,2.063758656509695]
[null,null,null,null,null,"sk(calcul2)",{"$f":"ROUND(VLOOKUP('Toit 2x2 N'!M8,Daten!A38:G42,7),2)","v":0.92},"sk choisis",{"$f":"'Toit 2x2 N'!P9","v":0.92},null,null,null,null,null,"sk(calcul2)",{"$f":"G43","v":0.92},"sk choisis",{"$f":"I43","v":0.92}]
[]
[]
[null,null,"0≤α≤30","30<α<60","60≤α",null,null,null,null,null,null,"0≤α≤30","30<α<60","60≤α"]
["2x2N","µ1(α)",0.8,{"$f":"ROUND(0.8*(60-F39)/30,2)","v":1.33},0,null,"µ1(α)",{"$f":"HLOOKUP(H37,C46:E47,2,FALSE)","v":0.8},null,"2x2N","µ1(α)",0.8,{"$f":"ROUND(0.8*(60-O39)/30,2)","v":1.33},0,null,"µ1(α)",{"$f":"HLOOKUP(Q37,L46:N47,2,FALSE)","v":0.8}]
["s","µ2(α)",0.8,{"$f":"ROUND(0.8*(60-F39)/30,2)","v":1.33},0,null,"µ2(α)",{"$f":"HLOOKUP(H37,C46:E48,3,FALSE)","v":0.8},null,"s","µ2(α)",0.8,{"$f":"ROUND(0.8*(60-O39)/30,2)","v":1.33},0,null,"µ2(α)",{"$f":"HLOOKUP(Q37,L46:N48,3,FALSE)","v":0.8}]
["IN","µ3(α)",{"$f":"ROUND(0.8+0.8*F39/30,2)","v":1.07},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(H37,C46:E49,4,FALSE)","v":1.07},null,"IN","µ3(α)",{"$f":"ROUND(0.8+0.8*O39/30,2)","v":1.07},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(Q37,L46:N49,4,FALSE)","v":1.07}]
[]
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F56<=30,\"0≤α≤30\",\nIF(AND(F56>30,F56<60),\"30<α<60\",\nIF(F56>=60,\"60≤α\",\"\")))","v":"30<α<60"},null,null,null,null,null,null,null,"sk1",{"$f":"IF(O56<=30,\"0≤α≤30\",\nIF(AND(O56>30,O56<60),\"30<α<60\",\nIF(O56>=60,\"60≤α\",\"\")))","v":"0≤α≤30"},null,null,null,null,null,null,null,"sk1",{"$f":"IF(X56<=30,\"0≤α≤30\",\nIF(AND(X56>30,X56<60),\"30<α<60\",\nIF(X56>=60,\"60≤α\",\"\")))","v":"0≤α≤30"}]
["Zone1",{"$f":"0.19+0.91*((F55+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"'Toit 2x2 B'!M9","v":10},{"$f":"MAX(B55,D55)","v":0.65},null,null,"Zone1",{"$f":"0.19+0.91*((O55+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"F55","v":10},{"$f":"MAX(K55,M55)","v":0.65},null,null,"Zone1",{"$f":"0.19+0.91*((X55+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"O55","v":10},{"$f":"MAX(T55,V55)","v":0.65}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F55+140)/760)^2)","v":0.2818105090027701},">",0.81,"alpha 1",{"$f":"'Toit 2x2 B'!M10","v":40},{"$f":"MAX(B56,D56)","v":0.81},null,null,"Zone1a",{"$f":"1.25*(0.19+0.91*((O55+140)/760)^2)","v":0.2818105090027701},">",0.81,"alpha 2",{"$f":"'Toit 2x2 B'!M11","v":10},{"$f":"MAX(K56,M56)","v":0.81},null,null,"Zone1a",{"$f":"1.25*(0.19+0.91*((X55+140)/760)^2)","v":0.2818105090027701},">",0.81,"alpha m",{"$f":"(F56+O56)*0.5","v":25},{"$f":"MAX(T56,V56)","v":0.81}]
["Zone2",{"$f":"0.25+1.91*((F55+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85,null,null,"Zone2",{"$f":"0.25+1.91*((O55+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85,null,null,"Zone2",{"$f":"0.25+1.91*((X55+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F55+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06,null,null,"Zone2a",{"$f":"1.25*(0.25+1.91*((O55+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06,null,null,"Zone2a",{"$f":"1.25*(0.25+1.91*((X55+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06]
["Zone3",{"$f":"0.31+2.91*((F55+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001,null,null,"Zone3",{"$f":"0.31+2.91*((O55+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001,null,null,"Zone3",{"$f":"0.31+2.91*((X55+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001]
[null,null,null,null,null,"sk(calcul2)",{"$f":"VLOOKUP('Toit 2x2 B'!M8,Daten!A55:G59,7)","v":1.06},"sk choisis",{"$f":"'Toit 2x2 B'!P9","v":1.06},null,null,null,null,null,"sk(calcul2)",{"$f":"G60","v":1.06},"sk choisis",{"$f":"I60","v":1.06},null,null,null,null,null,"sk(calcul2)",{"$f":"P60","v":1.06},"sk choisis",{"$f":"R60","v":1.06}]
[]
[]
[null,null,"0≤α≤30","30<α<60","60≤α",null,null,null,null,null,null,"0≤α≤30","30<α<60","60≤α",null,null,null,null,null,null,"0≤α≤30","30<α<60","60≤α"]
["2x2B","µ1(α)",0.8,{"$f":"ROUND(0.8*(60-F56)/30,2)","v":0.53},0,null,"µ1(α)",{"$f":"HLOOKUP(H54,C63:E64,2,FALSE)","v":0.53},null,"2x2B","µ1(α)",0.8,{"$f":"ROUND(0.8*(60-O56)/30,2)","v":1.33},0,null,"µ1(α)",{"$f":"HLOOKUP(Q54,L63:N64,2,FALSE)","v":0.8},null,"2x2B","µ1(α)",0.8,{"$f":"0.8*(60-X56)/30","v":0.93333333333333335},0,null,"µ1(α)",{"$f":"HLOOKUP(Z54,U63:W64,2,FALSE)","v":0.8}]
["s","µ2(α)",0.8,{"$f":"ROUND(0.8*(60-F56)/30,2)","v":0.53},0,null,"µ2(α)",{"$f":"HLOOKUP(H54,C63:E65,3,FALSE)","v":0.53},null,"s","µ2(α)",0.8,{"$f":"ROUND(0.8*(60-O56)/30,2)","v":1.33},0,null,"µ2(α)",{"$f":"HLOOKUP(Q54,L63:N65,3,FALSE)","v":0.8},null,"s","µ2(α)",0.8,{"$f":"0.8*(60-X56)/30","v":0.93333333333333335},0,null,"µ2(α)",{"$f":"HLOOKUP(Z54,U63:W65,3,FALSE)","v":0.8}]
["IN","µ3(α)",{"$f":"ROUND(0.8+0.8*F56/30,2)","v":1.87},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(H54,C63:E66,4,FALSE)","v":1.6},null,"IN","µ3(α)",{"$f":"ROUND(0.8+0.8*O56/30,2)","v":1.07},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(Q54,L63:N66,4,FALSE)","v":1.07},null,"IN","µ3(α)",{"$f":"ROUND(0.8+0.8*X56/30,2)","v":1.47},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(Z54,U63:W66,4,FALSE)","v":1.47}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F74<=30,\"0≤α≤30\",\nIF(AND(F74>30,F74<60),\"30<α<60\",\nIF(F74>=60,\"60≤α\",\"\")))","v":"0≤α≤30"},null,null,null,null,null,null,null,null,null,null,"sk1",{"$f":"IF(R74<=30,\"0≤α≤30\",\nIF(AND(R74>30,R74<60),\"30<α<60\",\nIF(R74>=60,\"60≤α\",\"\")))","v":"0≤α≤30"}]
["Zone1",{"$f":"0.19+0.91*((F73+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"'Toit C N'!M9","v":10},{"$f":"MAX(B73,D73)","v":0.65},null,null,null,null,null,"Zone1",{"$f":"0.19+0.91*((R73+140)/760)^2","v":0.23033240997229917},">",0.65,"A=",{"$f":"'Toit C B'!$M$9","v":20},{"$f":"MAX(N73,P73)","v":0.65}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F73+140)/760)^2)","v":0.2818105090027701},">",0.81,null,null,{"$f":"MAX(B74,D74)","v":0.81},null,null,null,null,null,"Zone1a",{"$f":"1.25*(0.19+0.91*((R73+140)/760)^2)","v":0.28791551246537395},">",0.81,null,null,{"$f":"MAX(N74,P74)","v":0.81}]
["Zone2",{"$f":"0.25+1.91*((F73+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85,null,null,null,null,null,"Zone2",{"$f":"0.25+1.91*((R73+140)/760)^2","v":0.33465373961218836},">",0.85,null,null,0.85]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F73+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06,null,null,null,null,null,"Zone2a",{"$f":"1.25*(0.25+1.91*((R73+140)/760)^2)","v":0.41831717451523542},">",1.06,null,null,1.06]
["Zone3",{"$f":"0.31+2.91*((F73+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001,null,null,null,null,null,"Zone3",{"$f":"0.31+2.91*((R73+140)/760)^2","v":0.43897506925207752},">",1.1000000000000001,null,null,1.1000000000000001]
[null,null,null,null,null,"sk(calcul2)",{"$f":"VLOOKUP('Toit C N'!M8,Daten!A73:G77,7)","v":0.81},"sk choisis",{"$f":"'Toit C N'!P9","v":0.81},null,null,null,null,null,null,null,null,"sk(calcul2)",{"$f":"VLOOKUP('Toit C B'!$M$8,Daten!M73:S77,7)","v":0.65},"sk choisis",{"$f":"'Toit C B'!P9","v":0.65}]
[]
[]
[]
["C N"]
["s"]
["IN"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F92<=30,\"0≤α≤30\",\nIF(AND(F92>30,F92<60),\"30<α<60\",\nIF(F92>=60,\"60≤α\",\"\")))","v":"0≤α≤30"}]
["Zone1",{"$f":"0.19+0.91*((F91+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"'Toit +  PaSol'!M11","v":10},{"$f":"MAX(B91,D91)","v":0.65}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F91+140)/760)^2)","v":0.2818105090027701},">",0.81,null,null,{"$f":"MAX(B92,D92)","v":0.81}]
["Zone2",{"$f":"0.25+1.91*((F91+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F91+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06]
["Zone3",{"$f":"0.31+2.91*((F91+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001]
[null,null,null,null,null,"sk(calcul2)",{"$f":"VLOOKUP('Toit +  PaSol'!M10,Daten!A91:G95,7)","v":1.1000000000000001},"sk choisis",{"$f":"'Toit +  PaSol'!P11","v":1.1000000000000001}]
[]
[]
[null,null,"0≤α≤30","30<α<60","60≤α"]
["Paso","µ1(α)",0.8,{"$f":"0.8*(60-F92)/30","v":1.6},0,null,"µ1(α)",{"$f":"HLOOKUP(H90,C99:E100,2,FALSE)","v":0.8}]
["s","µ2(α)",0.8,{"$f":"0.8*(60-F92)/30","v":1.6},0,null,"µ2(α)",{"$f":"HLOOKUP(H90,C99:E101,3,FALSE)","v":0.8}]
["IN","µ3(α)",{"$f":"0.8+0.8*F92/30","v":0.8},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(H90,C99:E102,4,FALSE)","v":0.8}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F110<=30,\"0≤α≤30\",\nIF(AND(F110>30,F110<60),\"30<α<60\",\nIF(F110>=60,\"60≤α\",\"\")))","v":"0≤α≤30"}]
["Zone1",{"$f":"0.19+0.91*((F109+140)/760)^2","v":0.24687500000000001},">",0.65,"A=",{"$f":"'Toit dis'!M11","v":50},{"$f":"MAX(B109,D109)","v":0.65}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F109+140)/760)^2)","v":0.30859375},">",0.81,null,{"$f":"'Toit dis'!M12","v":5},{"$f":"MAX(B110,D110)","v":0.81}]
["Zone2",{"$f":"0.25+1.91*((F109+140)/760)^2","v":0.36937500000000001},">",0.85,null,null,0.85]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F109+140)/760)^2)","v":0.46171875000000001},">",1.06,null,null,1.06]
["Zone3",{"$f":"0.31+2.91*((F109+140)/760)^2","v":0.49187500000000001},">",1.1000000000000001,null,null,1.1000000000000001]
[null,null,null,null,null,"sk(calcul2)",{"$f":"ROUND(VLOOKUP('Toit dis'!M10,Daten!A109:G113,7),2)","v":0.65},"sk choisis",{"$f":"'Toit dis'!P11","v":0.65}]
[]
[]
[null,null,"0≤α≤30","30<α<60","60≤α"]
["Toit dis","µ1(α)",0.8,{"$f":"0.8*(60-F110)/30","v":1.4666666666666666},0,null,"µ1(α)",{"$f":"HLOOKUP(H108,C117:E118,2,FALSE)","v":0.8}]
["s","µ2(α)",0.8,{"$f":"0.8*(60-F110)/30","v":1.4666666666666666},0,null,"µ2(α)",{"$f":"HLOOKUP(H108,C117:E119,3,FALSE)","v":0.8}]
["IN","µ3(α)",{"$f":"0.8+0.8*F110/30","v":0.93333333333333335},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(H108,C117:E120,4,FALSE)","v":0.93333333333333335}]
[]
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F127<=30,\"0≤α≤30\",\nIF(AND(F127>30,F127<60),\"30<α<60\",\nIF(F127>=60,\"60≤α\",\"\")))","v":"0≤α≤30"}]
["Zone1",{"$f":"0.19+0.91*((F126+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"Acc!M9","v":10},{"$f":"MAX(B126,D126)","v":0.65}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F126+140)/760)^2)","v":0.2818105090027701},">",0.81,null,null,{"$f":"MAX(B127,D127)","v":0.81}]
["Zone2",{"$f":"0.25+1.91*((F126+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F126+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06]
["Zone3",{"$f":"0.31+2.91*((F126+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001]
[null,null,null,null,null,"sk(calcul2)",{"$f":"ROUND(VLOOKUP(Acc!M8,Daten!A126:G130,7),2)","v":0.81},"sk choisis",{"$f":"Acc!P9","v":0.65}]
[]
[]
[null,null,"0≤α≤30","30<α<60","60≤α"]
["Toit dis","µ1(α)",0.8,{"$f":"0.8*(60-F127)/30","v":1.6},0,null,"µ1(α)",{"$f":"HLOOKUP(H125,C134:E135,2,FALSE)","v":0.8}]
["s","µ2(α)",0.8,{"$f":"0.8*(60-F127)/30","v":1.6},0,null,"µ2(α)",{"$f":"HLOOKUP(H125,C134:E136,3,FALSE)","v":0.8}]
["IN","µ3(α)",{"$f":"0.8+0.8*F127/30","v":0.8},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(H125,C134:E137,4,FALSE)","v":0.8}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"sk1",{"$f":"IF(F145<=30,\"0≤α≤30\",\nIF(AND(F145>30,F145<60),\"30<α<60\",\nIF(F145>=60,\"60≤α\",\"\")))","v":"0≤α≤30"}]
["Zone1",{"$f":"0.19+0.91*((F144+140)/760)^2","v":0.22544840720221607},">",0.65,"A=",{"$f":"deb!M9","v":10},{"$f":"MAX(B144,D144)","v":0.65}]
["Zone1a",{"$f":"1.25*(0.19+0.91*((F144+140)/760)^2)","v":0.2818105090027701},">",0.81,null,null,{"$f":"MAX(B145,D145)","v":0.81}]
["Zone2",{"$f":"0.25+1.91*((F144+140)/760)^2","v":0.32440270083102496},">",0.85,null,null,0.85]
["Zone2a",{"$f":"1.25*(0.25+1.91*((F144+140)/760)^2)","v":0.40550337603878117},">",1.06,null,null,1.06]
["Zone3",{"$f":"0.31+2.91*((F144+140)/760)^2","v":0.42335699445983382},">",1.1000000000000001,null,null,1.1000000000000001]
[null,null,null,null,null,"sk(calcul2)",{"$f":"ROUND(VLOOKUP(deb!M8,Daten!A144:G148,7),2)","v":0.81},"sk choisis",{"$f":"deb!P9","v":0.65}]
[]
[]
[null,null,"0≤α≤30","30<α<60","60≤α"]
["Toit dis","µ1(α)",0.8,{"$f":"0.8*(60-F145)/30","v":1.6},0,null,"µ1(α)",{"$f":"HLOOKUP(H143,C152:E153,2,FALSE)","v":0.8}]
["s","µ2(α)",0.8,{"$f":"0.8*(60-F145)/30","v":1.6},0,null,"µ2(α)",{"$f":"HLOOKUP(H143,C152:E154,3,FALSE)","v":0.8}]
["IN","µ3(α)",{"$f":"0.8+0.8*F145/30","v":0.8},1.6,1.6,null,"µ3(α)",{"$f":"HLOOKUP(H143,C152:E155,4,FALSE)","v":0.8}]

{"sheet":"Explication","index":12,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Ce fichier a pour objectif de calculer la charge de neige selon l’Eurocode. L’Eurocode EN 1991-1-3 répartit le territoire en plusieurs zones neige ; pour chaque zone, "]
["la charge de neige de base qk  est déterminée en fonction de l’altitude (Plus de details B2B)."]
["Dans ce modèle,  est calculée automatiquement selon la zone et l’altitude renseignées, mais vous pouvez facilement adapter sa valeur en modifiant la variable "]
["dans la figure (par exemple en la multipliant par 0 et en ajoutant +xxxkN/m²)."]
[]
[]
[]
[]
[]
[]
[]
[]
["Le bouton d’export, identique à ceux des autres fichiers Excel d’Oussama Rouchdi, permet d’enregistrer automatiquement au format PDF toutes les feuilles marquées en rouge."]
["il suffit dans ces feuilles de choisir le cas (Toit1 versant 2 ….) et remplir les case jaunes"]
[]
["Dans le cas Toit dis, d apres le cas vous pouvez choisir la figure en bas, si ls>ou < a h. en cliquant sur - le cas sera masqué"]