{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Eingabe","NW nachgiebig verb. Biegeträger","NW ohne nachgiebigen Verbund","Geometrie","Gamma","Klammerverbindung","Grenzwerte "],"not_rendered":{"charts":2,"images":14,"macros":1,"external_links":0,"defined_names":22,"comments":3,"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":"Eingabe","index":0,"n_rows":140,"n_cols":49,"rows_kept":140,"cut":false,"hidden":false,"merged":[[102,16,102,19],[94,2,95,7],[96,2,97,7],[101,16,101,19],[94,28,94,31],[95,28,95,31],[107,20,107,24],[108,20,108,24],[109,20,109,24],[111,20,111,24],[101,28,101,31],[102,28,102,31],[135,3,135,4],[135,6,135,9],[124,20,124,24],[122,20,122,24],[129,25,130,35],[128,20,128,24],[128,27,128,29],[0,19,0,35],[1,19,1,35],[2,23,2,35],[3,23,3,35],[27,16,27,22],[12,16,12,20],[24,16,24,20],[10,16,10,20],[11,16,11,20],[10,22,11,32],[67,38,67,40],[126,20,126,24],[80,29,80,33],[85,26,85,27],[82,20,82,24],[83,29,83,33],[78,29,78,33],[68,16,68,20],[78,20,78,24],[85,29,85,33],[83,20,83,24],[82,29,82,33],[112,20,112,24],[92,26,92,33],[85,20,85,24],[105,20,105,24],[139,6,139,9],[135,19,135,20],[135,22,135,25],[137,22,137,25],[137,6,137,9],[138,6,138,9],[29,16,29,20],[28,16,28,22],[71,16,71,20],[32,16,32,20],[84,20,84,24],[80,20,80,24],[58,19,58,35],[69,16,69,20],[60,23,60,35],[61,23,61,35],[59,19,59,35],[79,20,79,24],[72,16,72,20],[74,16,74,20],[70,15,70,21],[83,2,83,16],[90,2,91,7],[91,28,91,31],[90,28,90,31],[90,15,90,19],[91,15,91,19],[73,14,73,22],[93,28,93,31],[100,28,100,31],[100,16,100,19],[96,15,96,19],[93,15,93,19],[94,15,94,19],[95,16,95,18],[97,16,97,18],[98,16,98,18],[89,15,89,19],[92,14,92,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de pages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 1/\",$AM$2)","v":"Page 1/2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,null,"travaux de rénovation Dupont"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,null,"20.1 Poutre de mur-rideau"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2024"]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"]
[]
[null,null,"Saisie de la géométrie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q11=\"U*psi F\",\"F\",\"Sa\")","v":"Sa"},"U*psi F","U*psi S"]
[null,null,"Type de support :",null,null,null,null,null,null,null,null,null,null,null,null,null,"U*psi S",null,null,null,null,null,{"$f":"IF(Q11=\"U*psi S\",\"U*psi S possible uniquement avec hauteur de construction 240.\",\"\")","v":"U*psi S possible uniquement avec hauteur de construction 240."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160,240]
[null,null,"Hauteur de construction :",null,null,null,null,null,null,null,null,null,null,null,null,null,240,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200]
[null,null,"Longueur du composant",null,null,null,null,null,null,null,null,null,null,null,"l E","=",2940,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Conditions-cadres"]
[null,null,"Flambement sur l’axe faible évité",null,null,null,null,null,null,null,null,null,null,null,null,null,"oui"]
[null,null,"Le flambement est évité si l’entraxe des vis est ≤ 800 mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'NW nachgiebig verb. Biegeträger'!Q26","v":398}]
[null,null,"Fixation exécuté",null,null,null,null,null,null,null,null,null,null,null,null,null,"dans chaque travée"]
[null,null,"Fixation exécuté",null,null,null,null,null,null,null,null,null,null,null,null,null,"entre les échelons"]
[null,null,"Fixation avec entraxe",null,null,null,null,null,null,null,null,null,null,"e","v","=",{"$f":"IF(Q25=\"non\",2940,IF(Q28=\"dans chaque travée\",400,800))","v":400}]
[]
[]
[null,null,"Entraxe des entretoises",null,null,null,null,null,null,null,null,null,null,"e","w","=",625]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 2/\",$AM$2)","v":"Page 2/2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,null,{"$f":"IF($X$3=\"\",\"\",$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,null,{"$f":"IF($X$4=\"\",\"\",$X$4)","v":"20.1 Poutre de mur-rideau"}]
[]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C8","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pression dynamique Allemagne"]
[null,null,"Données relatives à l’action",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kmod","Classe de service",null,null,null,null,null,"Zone",null,10,18,25]
[null,null,"Classe de service (en général CS 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KD",1,2,3,null,null,null,1,"Intérieur du pays",0.5,0.65,0.75]
[null,null,"Coefficient de durée d'application de la charge",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P71=\"Vent\",\"courte/très courte\",IF(P71=\"Poids propre\",\"permanente\",IF(P71=\"Neige<1000mamsl\",\"courte\",\"moyenne\")))","v":"courte"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"permanente",0.6,0.6,0.5,null,null,null,2,"Intérieur du pays",0.65,0.8,9]
[null,null,null,"Charge déterminante (en général : vent)",null,null,null,null,null,null,null,null,null,null,null,"Neige<1000mamsl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"longue",0.7,0.7,0.55000000000000004,null,null,null,2,"Côte et îles de la mer Baltique",0.85,1,1.1000000000000001]
[null,null,"Facteur modificatif (kmod)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q69=1,VLOOKUP(Q70,AL68:AO75,2,FALSE),IF(Q69=2,VLOOKUP(Q70,AL68:AO75,3,FALSE),IF(Q69=3,VLOOKUP(Q70,AL68:AO75,4,FALSE),\"\")))","v":0.9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"moyenne",0.8,0.8,0.65,null,null,null,3,"Intérieur du pays",0.8,0.95,1.1000000000000001]
[null,null,"Coefficient partiel de sécurité (gm)",null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"courte",0.9,0.9,0.7,null,null,null,3,"Côte et îles de la mer Baltique",1.05,1.2,1.3]
[null,null,"Valeurs de saisie",null,null,null,null,null,null,null,null,null,null,null,"caractéristiques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"courte/très courte",1,1,0.8,null,null,null,4,"Intérieur du pays",0.95,1.1499999999999999,1.3]
[null,null,{"$f":"IF(O74=\"Valeurs théoriques\",\"Type de façade\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,"Façade crépie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"très courte",1.1000000000000001,1.1000000000000001,0.9,null,null,null,4,"Côte et îles de la mer Baltique",1.25,1.4,1.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Îles de la Mer du Nord",1.4,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Façade en bois"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Façade crépie"]
[null,null,"Effort normal sur membrure comprimée (par entretoise)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G","k","=",1E-13,null,null,null,null,null,"N","d","=",0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur de l’ouvrage",{"$f":"IF(AC92<11,10,IF(AC92<19,18,25))","v":10}]
[null,null,"(pertinente pour mur à ossature bois)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P","k","=",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Intérieur du pays",{"$f":"_xlfn.XLOOKUP(AU79,AU68:AW68,AU69:AW76)","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S","k","=",0,null,null,null,null,null,"N","d","=",{"$f":"IF(O74=\"Valeurs_de_dimensionement\",AD79,MAX(1.35*U79+1.5*U80+1.5*0.7*U81,1.35*U79+1.5*U81+1.5*0.7*U80))","v":1.3500000000000001E-13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Intérieur du pays",0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avec ψ0 = 0,70",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Côte et îles de la mer Baltique",0.85]
[null,null,"Charge de façade avec isolation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q","G,v,k","=",3.45,null,null,null,null,null,"q","v,d","=",{"$f":"IF(Q75=\"Façade en bois\",0.6*1.5,IF(Q75=\"Façade crépie\",0.7*1.5,\" \"))","v":1.0499999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Intérieur du pays",0.8]
[null,null,"Charge verticale concentrée supplémentaire sur la membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F","G,v,k","=",0,null,null,null,null,null,"F","v,d","=",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Côte et îles de la mer Baltique",1.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F","P,v,k","=",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Intérieur du pays",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F","S,v,k","=",0,null,null,null,null,"F","v,d,tot",null,"=",{"$f":"IF(O74=\"Valeurs_de_dimensionement\",AD84+AD83*Q33/1000*Q13/1000,MAX(1.35*(U84+U83*Q33/1000*Q13/1000)+1.5*U85+1.5*0.7*U86,1.35*(U84+U83*Q33/1000*Q13/1000)+1.5*U86+1.5*0.7*U85))","v":8.5581562500000015},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Côte et îles de la mer Baltique",1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avec ψ0 = 0,70",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Îles de la Mer du Nord",1.4]
[]
[]
[null,null,"Action du vent :",null,null,null,null,null,"Pays",null,null,null,null,null,null,"Allemagne"]
[null,null,"Valeur de référence issue par ex. de www.dlubal.com",null,null,null,null,null,{"$f":"IF(P90=\"Suisse\",\"Pression dynamique qp0\", \" \")","v":" "},null,null,null,null,null,null,0.5,null,null,null,null,{"$f":"IF(P90=\"Suisse\",\" \",\"Zone de vent\")","v":"Zone de vent"},null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn._xlws.FILTER(AS80:AU87,AS80:AS87=AC91)","v":2},"Intérieur du pays",0.65]
[null,null,null,null,null,null,null,null,"Hauteur de l’ouvrage h",null,null,null,null,null,null,20,null,null,null,null,{"$f":"IF(P90=\"Suisse\",\" \",\"Hauteur de l’ouvrage h\")","v":"Hauteur de l’ouvrage h"},null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Côte et îles de la mer Baltique",0.85]
[null,null,null,null,null,null,null,null,"Catégorie de rugosité",null,null,null,null,null,"Vastes zones urbaines",null,null,null,null,null,{"$f":"IF(P90=\"Suisse\",\" \",\"Exposition\")","v":"Exposition"},null,null,null,null,null,"Côte et îles de la mer Baltique"]
[null,null,null,null,null,null,null,null,"Hauteur de gradient zg",null,null,null,null,null,null,{"$f":"IF(O93=\"Lacs\",300,IF(O93=\"Grande plaine\",380,IF(O93=\"Localités, milieu rural\",450,526)))","v":526},null,null,null,null,"Pression dynamique qp",null,null,null,null,null,null,null,{"$f":"IF(P90=\"Suisse\",\" \",_xlfn.XLOOKUP(AA93,AT91:AT93,AU91:AU93))","v":0.85}]
[null,null,"Coefficients de pression pour le pire cas",null,null,null,null,null,"Rugosité du terrain αr",null,null,null,null,null,null,{"$f":"IF(O93=\"Lacs\",0.16,IF(O93=\"Grande plaine\",0.19,IF(O93=\"Localités, milieu rural\",0.23,0.3)))","v":0.3},null,null,null,null,"Coefficient de pression cpe10",null,null,null,null,null,null,null,{"$f":"IF(P90=\"Suisse\",\" \",0.8)","v":0.8}]
[null,null,null,null,null,null,null,null,"Profil de répartition du vent ch",null,null,null,null,null,null,null,{"$f":"1.6*((P92/P94)^P95+0.375)^2","v":0.89996271528945293}]
[null,null,"(DN 30°, h:b:d = 2,5:2:1)",null,null,null,null,null,"Pression dynamique qp",null,null,null,null,null,null,{"$f":"Q96*P91","v":0.44998135764472647}]
[null,null,null,null,null,null,null,null,"Coefficient de pression cpe,A",null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,"Coefficient de pression cpe,B",null,null,null,null,null,null,null,-1.1000000000000001]
[]
[null,null,"Action du vent",null,null,null,null,null,null,null,null,null,null,"qh,k",null,"=",{"$f":"P97*MAX(ABS(Q98),ABS(Q99))","v":0.49497949340919917},null,null,null,null,null,null,null,null,"qh,k",null,{"$f":"IF($P$90=\"Suisse\",\" \",\"=\")","v":"="},{"$f":"IF(P90=\"Suisse\",\" \",AC94*MAX(ABS(AC95),ABS(AC96)))","v":0.68}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"qh,d",null,"=",{"$f":"1.5*Q101","v":0.74246924011379878},null,null,null,null,null,null,null,null,"qh,d",null,{"$f":"IF($P$90=\"Suisse\",\" \",\"=\")","v":"="},{"$f":"IF(P90=\"Suisse\",\" \",1.5*AC101)","v":1.02}]
[null,null,"Action du vent par entretoise",null,null,null,null,null,null,null,null,null,null,"q'h,d",null,"=",{"$f":"Q102*Q33/1000","v":0.46404327507112425},null,null,null,null,null,null,null,null,"q' h,d",null,{"$f":"IF($P$90=\"Suisse\",\" \",\"=\")","v":"="},{"$f":"IF(P90=\"Suisse\",\" \",AC102*Q33/1000)","v":0.63749999999999996}]
[]
[null,null,"Saisie des agrafes pour U*psi S"]
[null,null,"Agrafes par traverse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null,"Dimensions des agrafes :",null,null,null,null,null,null,null,null,null,null,"Longueur de clou ",null,null,null,null,null,"l",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Diamètre de clou",null,null,null,null,null,"d",1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Entraxe des clous",null,null,null,null,null,"c",11]
[]
[null,null,"Angle entre la direction de l'effort et le sens des fibres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,"0°- 90°"]
[null,null,"Angle entre dos d’agrafe et sens des fibres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,">30°"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Q30<3*AM27,\"Les vérifications se basent sur la théorie de l'élasticité linéaire !\",\"Les vérifications sont effectuées selon la théorie des poutres sollicitées en flexion reliées de manière flexible!\")","v":"Les vérifications se basent sur la théorie de l'élasticité linéaire !"}]
[null,null,"Sélectionner la feuille de travail correspondante pour éditer les vérifications détaillées"]
[]
[null,null,"Membrure comprimée",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h","=",{"$f":"IF(Q30<3*AM27,'NW ohne nachgiebigen Verbund'!Y211,'NW nachgiebig verb. Biegeträger'!AA204)","v":0.688070023086502},null,null,null,null,{"$f":"IF(U123>1,\">\",\"<\")","v":"<"},1]
[]
[null,null,"Membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h","=",{"$f":"IF(Q30<3*AM27,'NW ohne nachgiebigen Verbund'!Y230,'NW nachgiebig verb. Biegeträger'!AA227)","v":1.0418341088388483},null,null,null,null,{"$f":"IF(U125>1,\">\",\"<\")","v":">"},1]
[]
[null,null,"Surface de contact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h","=",{"$f":"IF(Q11=\"U*psi S\",'NW nachgiebig verb. Biegeträger'!AE451,IF(Q30<3*AM27,'NW ohne nachgiebigen Verbund'!AH311,'NW nachgiebig verb. Biegeträger'!AG347))","v":6.4317839270620025},null,null,null,null,{"$f":"IF(U127>1,\">\",\"<\")","v":">"},1]
[]
[null,null,"Flèche due au vent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"u","=",{"$f":"'NW nachgiebig verb. Biegeträger'!AC371","v":3.8978705713094749E-3},null,null,null,null,"=","l/",{"$f":"Q30/U129","v":102620.13391214822}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'NW nachgiebig verb. Biegeträger'!Y369","v":"L’hypothèse se rapporte à un système de poutre à une seule travée entre les fixations !"}]
[null,null,{"$f":"IF(MAX(U123,U125,U127,U129)>1,\"Entretoise insuffisant !\",\"Vérification OK.\")","v":"Entretoise insuffisant !"}]
[]
[]
[null,null,"Réaction d'appui verticale par fixation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réaction d'appui horizontale par fixation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hypothèse avec réaction d'appui horizontale sur parement : Poutre à 2 travées avec réaction d'appui de la zone centrale d’appui (1,25 * q * l)"]
[]
[null,null,"V","tot,d",null,"=",{"$f":"(AD81+AD86)/AP136","v":1.2225937500000195},null,null,null,null,null,null,null,null,null,null,null,"H","tot,d",null,"=",{"$f":"IF(Q30<3*'NW nachgiebig verb. Biegeträger'!Q26,1.25*IF(P90=\"Suisse\",Q103,Eingabe!AC103)*'NW ohne nachgiebigen Verbund'!Q36/1000,1.25*IF(P90=\"Suisse\",Q103,AC103)*Q30/1000)","v":0.31715624999999997},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre d’appuis (arrondi) :",null,null,"nappui =",{"$f":"MAX(2,IF(Q30<'NW nachgiebig verb. Biegeträger'!Q26*3,ROUNDDOWN(Q13/'NW ohne nachgiebigen Verbund'!Q36,0),ROUNDDOWN(Q13/Q30,0)))","v":7}]
[]
[null,null,"V","G,k",null,"=",{"$f":"(U79+U84+U83*Q13*Q33/1000000)/AP136","v":0.90562500000001445},null,null,null,null,null,null,null,null,null,null,null,"H","w,k",null,"=",{"$f":"IF(Q30<3*'NW nachgiebig verb. Biegeträger'!Q26,1.25*IF(P90=\"Suisse\",Eingabe!Q101,AC101)*Eingabe!Q33*'NW ohne nachgiebigen Verbund'!Q36/1000000,1.25*IF(P90=\"Suisse\",Q101,AC101)*Q33*Q30/1000000)","v":0.2114375}]
[null,null,"V","P,k",null,"=",{"$f":"(U80+U85)/AP136","v":0}]
[null,null,"V","S,k",null,"=",{"$f":"(U81+U86)/AP136","v":0}]

{"sheet":"NW nachgiebig verb. Biegeträger","index":1,"n_rows":453,"n_cols":39,"rows_kept":453,"cut":false,"hidden":true,"merged":[[320,2,321,10],[333,2,334,11],[346,2,347,11],[159,2,160,14],[165,2,166,13],[267,2,268,10],[281,2,282,8],[288,2,289,7],[291,2,292,11],[307,2,308,12],[310,2,311,11],[194,2,195,14],[207,2,208,15],[333,15,334,16],[162,16,163,17],[337,15,338,16],[337,17,338,17],[313,17,314,17],[341,15,342,16],[341,17,342,17],[218,2,219,12],[257,2,258,14],[264,2,265,9],[218,16,219,17],[450,30,452,34],[450,17,452,17],[447,26,447,28],[445,26,445,28],[446,26,446,28],[450,22,450,26],[451,22,451,26],[450,21,451,21],[450,27,451,27],[450,2,452,10],[450,15,452,15],[450,19,452,20],[452,22,452,26],[437,15,437,17],[438,15,438,17],[427,21,427,23],[427,25,427,27],[428,21,428,23],[428,25,428,27],[437,26,437,28],[438,26,438,28],[442,15,442,17],[439,15,439,17],[440,15,440,17],[441,15,441,17],[437,18,437,25],[450,28,452,28],[439,26,439,28],[440,26,440,28],[441,26,441,28],[442,26,442,28],[441,18,441,25],[442,18,442,25],[438,18,438,25],[439,18,439,25],[440,18,440,25],[426,21,426,23],[430,25,430,27],[431,25,431,27],[432,25,432,27],[380,16,380,20],[381,16,381,20],[409,26,409,29],[410,26,410,29],[399,19,399,22],[400,19,400,22],[402,19,402,22],[403,19,403,22],[406,19,406,22],[407,19,407,22],[409,19,409,22],[410,19,410,22],[424,25,424,27],[426,25,426,27],[424,21,424,23],[422,20,422,22],[412,19,412,22],[370,15,371,15],[370,17,371,17],[288,15,289,16],[354,19,354,35],[342,19,342,20],[370,26,371,26],[371,22,371,24],[346,32,347,35],[346,19,347,20],[346,22,346,29],[346,31,347,31],[370,28,371,32],[368,24,369,35],[366,24,367,35],[355,19,355,35],[357,23,357,35],[356,23,356,35],[370,22,370,24],[368,19,368,22],[326,15,327,16],[313,15,314,16],[289,19,289,20],[288,19,288,20],[333,17,334,17],[420,20,420,22],[383,16,383,20],[384,16,384,20],[385,16,385,20],[386,16,386,20],[387,16,387,20],[339,19,339,23],[341,22,342,23],[414,20,414,22],[376,16,376,20],[392,16,392,20],[378,16,378,20],[379,16,379,20],[382,16,382,20],[375,16,375,20],[411,19,411,22],[393,16,393,20],[394,16,394,20],[388,16,388,20],[366,19,366,22],[371,19,371,20],[370,19,370,20],[370,21,371,21],[264,15,265,16],[264,17,265,17],[212,16,213,17],[307,15,308,15],[276,15,277,16],[276,17,277,17],[267,17,268,17],[257,15,258,16],[221,16,222,17],[270,17,271,17],[257,17,258,17],[260,15,261,16],[260,17,261,17],[281,17,282,17],[270,15,271,16],[267,15,268,16],[291,15,292,16],[284,15,286,15],[284,17,286,17],[303,15,304,16],[303,17,304,17],[215,16,216,17],[310,15,311,16],[324,19,324,26],[326,25,327,25],[326,26,327,30],[313,19,313,22],[288,23,289,27],[288,17,289,17],[297,23,297,35],[288,22,289,22],[326,17,327,17],[291,17,292,17],[291,25,292,29],[291,19,291,22],[292,19,292,22],[296,19,296,35],[303,25,304,29],[291,24,292,24],[310,17,311,17],[307,19,307,25],[308,19,308,25],[307,17,308,17],[327,19,327,20],[316,19,316,20],[310,19,310,22],[245,23,245,27],[237,19,237,35],[218,29,219,29],[251,22,251,26],[326,19,326,20],[285,32,285,35],[281,18,282,19],[281,21,281,27],[279,30,279,32],[276,27,277,27],[285,19,285,25],[313,25,314,29],[310,24,311,24],[274,18,274,20],[265,19,265,20],[277,23,277,25],[252,22,252,26],[271,19,271,26],[255,24,255,28],[284,19,284,23],[286,19,286,23],[326,22,327,23],[307,27,308,27],[286,26,286,28],[198,16,199,17],[198,18,199,18],[198,20,198,21],[198,22,199,22],[215,20,215,25],[216,20,216,25],[194,16,195,17],[194,18,195,18],[194,20,194,23],[212,23,213,24],[198,23,199,24],[199,20,199,21],[207,24,208,24],[203,20,203,22],[201,19,201,23],[207,20,207,22],[215,18,216,18],[207,16,208,17],[212,22,213,22],[212,25,213,25],[195,20,195,23],[189,16,190,17],[189,18,190,18],[189,20,189,21],[189,22,190,22],[190,20,190,21],[168,16,169,17],[168,18,169,18],[180,23,180,35],[177,19,177,35],[178,19,178,35],[168,20,168,26],[169,20,169,26],[179,23,179,35],[168,19,169,19],[168,29,169,33],[187,24,187,28],[168,28,169,28],[189,26,190,30],[187,20,187,21],[87,7,87,14],[86,19,87,20],[90,31,91,35],[102,22,103,26],[102,4,103,4],[98,7,98,14],[99,7,99,14],[86,5,87,5],[86,7,86,14],[90,7,90,14],[98,5,99,5],[90,21,91,21],[102,20,103,20],[86,21,87,21],[98,21,99,21],[86,30,87,30],[86,22,87,26],[94,31,95,35],[94,22,95,26],[94,28,95,29],[102,21,103,21],[91,7,91,14],[102,29,103,29],[82,5,83,5],[80,19,80,25],[61,23,61,35],[62,23,62,35],[82,22,83,26],[72,31,73,35],[82,31,83,35],[70,21,71,21],[72,30,73,30],[74,20,74,24],[82,21,83,21],[74,2,75,10],[76,27,76,30],[77,27,77,30],[80,29,80,35],[82,28,83,29],[82,30,83,30],[9,9,9,11],[10,9,10,11],[23,16,23,20],[13,16,13,20],[14,16,14,20],[17,16,17,20],[46,16,46,20],[70,2,71,9],[72,11,73,11],[72,2,73,9],[72,13,73,13],[70,18,71,18],[42,2,43,11],[33,2,34,11],[35,2,36,11],[86,2,87,3],[26,16,26,20],[98,19,99,20],[35,16,35,20],[82,2,83,3],[82,19,83,20],[90,5,91,5],[70,15,71,15],[72,15,73,15],[70,13,71,13],[70,11,71,11],[82,7,82,14],[83,7,83,14],[72,19,72,28],[73,19,73,28],[70,22,71,26],[72,18,73,18],[90,19,91,20],[94,19,95,20],[98,2,99,3],[90,2,91,3],[86,28,87,29],[72,16,73,16],[70,16,71,16],[0,19,0,35],[1,19,1,35],[16,16,16,20],[18,16,18,20],[19,16,19,20],[24,16,24,20],[59,19,59,35],[60,19,60,35],[38,16,38,20],[39,16,39,20],[45,16,45,20],[22,16,22,20],[27,16,27,20],[25,16,25,20],[28,16,28,20],[30,16,30,20],[31,16,31,20],[32,16,32,20],[33,16,33,20],[42,16,42,20],[44,16,44,20],[2,23,2,35],[3,23,3,35],[48,16,48,20],[86,31,87,35],[90,30,91,30],[90,28,91,29],[98,30,99,30],[98,22,99,26],[90,22,91,26],[98,28,99,29],[98,31,99,35],[94,30,95,30],[102,31,103,35],[102,30,103,30],[107,28,108,29],[107,22,108,26],[107,21,108,21],[107,19,108,20],[132,32,132,33],[131,25,132,25],[139,29,140,31],[129,19,129,23],[110,20,111,20],[107,31,108,35],[107,30,108,30],[140,20,140,27],[139,20,139,27],[194,36,195,40],[257,27,258,27],[284,26,284,28],[264,22,265,22],[257,23,257,25],[267,19,267,26],[268,19,268,26],[258,19,258,21],[215,29,216,31],[221,26,222,30],[198,25,199,25],[207,25,208,29],[212,20,212,21],[203,26,203,29],[196,19,196,23],[215,27,216,27],[258,23,258,25],[226,20,226,22],[257,28,258,32],[270,29,271,33],[267,29,268,33],[218,23,219,23],[245,19,245,20],[218,24,219,28],[133,19,133,23],[135,19,136,20],[139,28,140,28],[120,23,120,35],[121,23,121,35],[131,32,131,33],[311,19,311,22],[303,24,304,24],[326,21,327,21],[149,27,150,27],[150,23,150,25],[159,20,159,23],[162,20,162,23],[163,20,163,23],[147,20,147,24],[152,31,152,33],[162,19,163,19],[149,21,150,21],[221,20,221,21],[221,22,222,22],[238,23,238,35],[239,23,239,35],[221,25,222,25],[221,23,222,24],[131,2,132,14],[110,21,111,21],[131,21,131,24],[110,22,111,24],[131,28,132,28],[131,30,132,30],[132,21,132,24],[131,31,132,31],[131,19,132,20],[118,19,118,35],[94,2,95,3],[102,2,103,3],[110,2,111,2],[110,4,111,4],[110,8,110,13],[111,8,111,13],[110,6,111,6],[110,7,111,7],[102,6,102,17],[103,6,103,17],[94,5,95,5],[207,18,208,18],[152,19,152,29],[154,19,155,20],[154,22,154,28],[159,26,160,30],[160,20,160,23],[154,30,155,30],[155,22,155,28],[149,23,149,25],[149,29,150,31],[208,20,208,22],[165,20,165,26],[165,29,166,33],[165,28,166,28],[162,26,163,30],[189,25,190,25],[194,25,195,30],[189,23,190,24],[166,20,166,26],[162,18,163,18],[192,19,192,23],[347,22,347,29],[210,23,210,27],[346,15,347,15],[341,21,342,21],[346,17,347,17],[320,15,321,16],[323,15,324,16],[320,17,321,17],[323,17,324,17],[310,25,311,29],[281,15,282,15],[282,21,282,27],[279,18,279,28],[261,19,261,21],[257,19,257,21],[257,22,258,22],[218,18,219,18],[218,20,218,22],[249,22,249,26],[337,26,337,31],[313,24,314,24],[212,18,213,18],[212,26,213,30],[255,19,255,21],[107,4,108,4],[94,7,94,14],[95,7,95,14],[264,19,264,20],[108,6,108,10],[107,6,107,10],[149,18,150,18],[215,2,216,5],[165,16,166,17],[165,18,166,18],[236,19,236,35],[107,2,108,3],[94,21,95,21],[149,28,150,28],[143,20,143,26],[145,27,145,29],[145,20,145,24],[142,29,143,31],[142,20,142,26],[139,2,140,13],[135,22,135,34],[142,28,143,28],[154,31,155,33],[159,25,160,25],[136,22,136,34],[137,19,137,20],[110,29,111,29],[154,16,155,16],[154,18,155,18],[159,18,160,18],[159,16,160,17],[154,2,155,9],[135,16,136,16],[135,18,136,18],[142,16,143,17],[149,16,150,17],[142,18,143,18],[145,16,145,17],[139,16,140,17],[135,2,136,13],[142,2,143,12],[139,18,140,18],[147,27,147,29],[131,16,132,16],[110,30,111,30],[119,19,119,35],[110,31,111,33],[131,18,132,18],[198,26,199,30],[194,24,195,24],[162,25,163,25],[341,25,342,25],[341,19,341,20],[344,18,344,22],[276,29,277,31],[270,28,271,28],[341,26,342,30],[260,19,260,21],[260,23,260,25],[254,24,254,28],[277,19,277,20],[261,23,261,25],[254,19,254,21],[264,23,265,27],[298,23,298,35],[281,30,282,32],[295,19,295,35],[338,26,338,31],[281,29,282,29],[333,26,333,31],[334,26,334,31],[337,25,338,25],[224,19,224,23],[213,20,213,21],[247,23,247,27],[247,19,247,20],[218,30,219,34],[219,20,219,22],[333,25,334,25],[316,23,316,27],[320,28,321,28],[329,18,329,22],[226,26,226,30],[276,21,277,21],[267,28,268,28],[260,22,261,22],[270,19,270,26],[260,27,261,27],[260,28,261,32],[323,19,323,26],[320,29,321,33],[320,19,320,26],[260,33,261,34],[257,33,258,34],[221,18,222,18],[222,20,222,21],[276,28,277,28],[276,23,276,25],[276,19,276,20],[323,29,324,33],[323,28,324,28],[314,19,314,22],[337,19,338,24],[335,19,335,23],[321,19,321,26],[333,19,334,24],[303,19,303,22],[307,28,308,31],[304,19,304,22]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de pages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 1/\",$AM$2)","v":"Page 1/7"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
["\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"Eingabe!C8","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Type :",null,null,null,null,null,null,{"$f":"Eingabe!Q11","v":"U*psi S"}]
[null,null,"Hauteur de construction :",null,null,null,null,null,null,{"$f":"Eingabe!Q12","v":240}]
[]
[null,null,"Géométrie"]
[null,null,"Membrure à fixer",null,null,null,null,null,null,null,null,null,null,"t1",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I12,2,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,2,FALSE),\"\"))","v":40}]
[null,null,"Membrure côté façade",null,null,null,null,null,null,null,"t2 ≤ t1!",null,null,"t2",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I12,3,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,3,FALSE),\"\"))","v":40}]
[]
[null,null,"Somme de la largeur des deux membrures",null,null,null,null,null,null,null,null,null,null,"bG",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,4,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,4,FALSE),\"\"))-Q24","v":39}]
[null,null,"Classe de résistance",null,null,null,null,null,null,null,null,null,null,null,null,null,"C24"]
[null,null,"Module d'élasticité",null,null,null,null,null,null,null,null,null,null,"E1",null,"=",11000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"E2",null,"=",{"$f":"Q19","v":11000}]
[]
[null,null,"Échelons"]
[null,null,"Hauteur",null,null,null,null,null,null,null,null,null,null,"hs",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I12,5,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,5,FALSE),\"\"))","v":62}]
[null,null,"Largeur",null,null,null,null,null,null,null,null,null,null,"s",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,6,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,6,FALSE),\"\"))","v":20}]
[null,null,"Longueur",null,null,null,null,null,null,null,null,null,null,"h",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,7,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,7,FALSE),\"\"))","v":240}]
[null,null,"Entraxe des échelons",null,null,null,null,null,null,null,null,null,null,"e",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,8,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,8,FALSE),\"\"))","v":398}]
[null,null,"Classe de résistance",null,null,null,null,null,null,null,null,null,null,null,null,null,"C24"]
[null,null,"Module d'élasticité",null,null,null,null,null,null,null,null,null,null,"EBH",null,"=",11000]
[null,null,"Module de cisaillement",null,null,null,null,null,null,null,null,null,null,"G",null,"=",690]
[]
[null,null,"Longueur de l’élément",null,null,null,null,null,null,null,null,null,null,"lE",null,"=",{"$f":"Eingabe!Q13","v":2940}]
[null,null,"Flambement dans le sens y évité",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!Q25","v":"oui"}]
[null,null,"avec entraxe",null,null,null,null,null,null,null,null,null,null,"ev",null,"=",{"$f":"Eingabe!Q30","v":400},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formule transformée en Sk pour le flambage "]
[null,null,"Longueur de flambement autour de l’axe z",null,null,null,null,null,null,null,null,null,null,"sk,z",null,"=",{"$f":"IF(Q32=\"non\",IF(Q33<Q31/(2.914/(Q43/(Q43+Q49)+1.385)-0.222)^0.5,Q33,Q33/(2.914/(Q43/(Q43+Q49)+1.385)-0.222)^0.5),0)","v":0}]
[]
[null,null,"Longueur de flambement autour de l’axe y",null,null,null,null,null,null,null,null,null,null,"sk,y",null,"=",{"$f":"IF(Q33<(Q31/(2.914/(Q43/(Q43+Q49)+1.385)-0.222)^0.5),Q33,Q33/(2.914/(Q43/(Q43+Q49)+1.385)-0.222)^0.5)","v":400}]
[]
[]
[null,null,"Facteur modificatif",null,null,null,null,null,null,null,null,null,null,"kmod",null,"=",{"$f":"Eingabe!Q72","v":0.9}]
[null,null,"Coefficient partiel de sécurité",null,null,null,null,null,null,null,null,null,null,"gM",null,"=",{"$f":"Eingabe!Q73","v":1.3}]
[]
[null,null,"Actions"]
[null,null,"Effort normal dans la membrure la plus épaisse",null,null,null,null,null,null,null,null,null,null,"Nd",null,"=",{"$f":"Eingabe!AD81","v":1.3500000000000001E-13}]
[]
[null,null,"Charge transversale par entretoise",null,null,null,null,null,null,null,null,null,null,"q'h,d",null,"=",{"$f":"IF(Eingabe!P90=\"Suisse\",Eingabe!Q103,Eingabe!AC103)","v":0.63749999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Md",null,"=",{"$f":"Q45*(Q31/1000)^2/8","v":0.68878687499999991}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Qd",null,"=",{"$f":"Q45*Q31/2/1000","v":0.93712499999999987}]
[]
[null,null,"Charge verticale de façade totale",null,null,null,null,null,null,null,null,null,null,"Fv,d,tot",null,"=",{"$f":"Eingabe!AD86","v":8.5581562500000015}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 2/\",$AM$2)","v":"Page 2/7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
["\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C8","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Détermination des efforts internes via méthode g",null,null,null,null,null,null,null,null,null,null,null,null,null,"EN 1995-1-1 Annexe B"]
[]
[null,null,"Entraxe des membrures (centre de gravité)",null,null,null,null,null,null,null,null,"a",null,"=",null,"h","-","t1","-","t2",null,"=",{"$f":"Gamma!C11","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,2]
[null,null,"Entraxe des centres de gravité (sans g)",null,null,null,null,null,null,null,null,"a1",null,"=",null,"h","-","t1","-","bG · t1 · ( h - t1 / 2 ) + bG · t2 · t2 / 2",null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Gamma!C12","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"bG · t1 + bG · t2"]
[null,null,"Entraxe des centres de gravité (sans g)",null,null,null,null,null,null,null,null,"a2",null,"=",null,"a","-","a1",null,"=",{"$f":"Gamma!C13","v":100}]
[]
[null,null,"Surface de la section transversale de la membrure comprimée",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1",null,"=",null,"t1 · bG",null,null,"=",{"$f":"Gamma!E16","v":1560}]
[null,null,"Surface de la section transversale de la membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2",null,"=",null,"t2 · bG",null,null,"=",{"$f":"Gamma!E18","v":1560}]
[]
[null,null,"Rigidité du joint flexible"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Membrure comprimée",null,null,null,null,null,null,null,null,null,"Membrure de façade"]
[null,null,"1. Déformation de flexion des membrures"]
[null,null,"1 / C1,i ",null,null,"=",null,"ai2 · e",null,null,null,null,null,null,null,null,null,null,null,"1 / C1,1",null,"=",{"$f":"Gamma!B$3","v":1.8844696969696974E-4},null,null,null,null,null,"1 / C1,2",null,"=",{"$f":"Gamma!B$7","v":1.8844696969696974E-4}]
[null,null,null,null,null,null,null,"12 · Ei / gM · (bG · ti3 / 12 )"]
[]
[null,null,"2. Déformation de flexion des échelons"]
[null,null,"1 / C2,i ",null,null,"=",null,"a3 / 24 - ( a / 2 - ai )3 / 3",null,null,null,null,null,null,null,null,null,null,null,"1 / C2,1",null,"=",{"$f":"Gamma!C$3","v":9.9175773037006286E-5},null,null,null,null,null,"1 / C2,2",null,"=",{"$f":"Gamma!C$7","v":9.9175773037006286E-5}]
[null,null,null,null,null,null,null,"Ei / gM · (s · hs3 / 12 )"]
[]
[null,null,"3. Déformation de cisaillement des échelons"]
[null,null,"1 / C3,i ",null,null,"=",null,"ai",null,null,null,null,null,null,null,null,null,null,null,"1 / C3,1",null,"=",{"$f":"Gamma!D$3","v":1.8232819074333803E-4},null,null,null,null,null,"1 / C3,2",null,"=",{"$f":"Gamma!D$7","v":1.8232819074333808E-4}]
[null,null,null,null,null,null,null,"Gi / gM · ( 5 / 6 · s · hs )"]
[]
[null,null,"4. Déformation de cisaillement roulant dans les surfaces de contact entre les échelons et les membrures"]
[null,null,"1 / C4,i ",null,null,"=",null,"s",null,null,null,null,null,null,null,null,null,null,null,"1 / C4,1",null,"=",{"$f":"Gamma!E$3","v":5.2419354838709686E-5},null,null,null,null,null,"1 / C4,2",null,"=",{"$f":"Gamma!E$7","v":5.2419354838709686E-5}]
[null,null,null,null,null,null,null,"4 · GR,i / gM · ( hs · ti )"]
[]
[null,null,"5. Rotation de torsion dans les surfaces de contact"]
[null,null,"1 / C5,i ",null,null,"=",null,"ai2",null,null,null,null,null,null,null,null,null,null,null,"1 / C5,1",null,"=",{"$f":"Gamma!F$3","v":1.92576615865943E-3},null,null,null,null,null,"1 / C5,2",null,"=",{"$f":"Gamma!F$7","v":1.92576615865943E-3}]
[null,null,null,null,null,null,null,"2 · IP,i · K / gM"]
[]
[null,null,"Module de cisaillement total"]
[null,null,"Ci ",null,"=",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"C1","=",{"$f":"Gamma!B4","v":408.47396444566988},null,null,null,null,null,null,"C2","=",{"$f":"Gamma!B8","v":408.47396444566988}]
[null,null,null,null,null,null,"1 / C1,i + 1 / C2,i + 1 / C3,i + 1 / C4,i + 1 / C5,i"]
[]
[null,null,"Rigidités torsionnelles pour déterminer la répartition des moments sur les membrures"]
[]
[null,null,"cφ,i",null,"=",null,"ai2",null,null,null,null,null,null,null,null,null,null,null,null,"cφ,1",null,"=",{"$f":"Gamma!J4","v":4729892.112520393},null,null,null,null,null,"cφ,2",null,"=",{"$f":"Gamma!J8","v":4729892.112520393}]
[null,null,null,null,null,null,"1 / C1,i + 1 / C5,i"]
[]
[null,null,"gi",null,"=",null,1,"+","p2 · Ei / gM · ti · bG · e",null,null,null,null,null,null,-1,null,null,null,null,"g1","=",{"$f":"1/(1+PI()^2*Geometrie!B26*Q14*Q17*Q26/Q31^2/Gamma!B4)","v":6.3751915029834558E-2},null,null,null,null,null,null,"g2","=",{"$f":"1/(1+PI()^2*Geometrie!C26*Q15*Q17*Q26/Q31^2/Gamma!B8)","v":6.3751915029834558E-2}]
[null,null,null,null,null,null,null,null,"lE2 · Ci"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 3/\",$AM$2)","v":"Page 3/7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C67","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Caractéristiques de la section"]
[]
[null,null,"Moment effectif d'inertie de surface du 2e degré",null,null,null,null,null,null,null,null,null,null,null,null,null,"Iy,eff",null,"=",{"$f":"Gamma!B20","v":2405059.748930838},null,null,null,null,"mm4"]
[]
[null,null,"Moment d'inertie de surface du 2e degré autour de l’axe z",null,null,null,null,null,null,null,null,null,null,null,null,null,"Iz",null,"=","2 ·",null,"( bG / 2 )3 · t1",null,null,null,"+",null,"s","+","bG",2,"∙","bG · t1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,2,null,4,null,null,2,null,null,null,"Théorèmes de Steiner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"2*(Q17/2)^3*Q14/12+2*(Q24/2+Q17/4)^2*Q17/2*Q14","v":657930},null,null,null,null,"mm4"]
[]
[null,null,"Coefficient d'élancement autour de l’axe Z",null,null,null,null,null,null,null,null,null,null,null,null,null,"lz",null,"=","max.",null,null,"sk,z / ( Iz / ( t1 · bG ))0,5",null,null,null,null,null,null,null,null,null,null,null,null,null,"Côté sécurité sans tenir compte des bois intermédiaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e / ( t1 · ( bG + s )3 / ( 12 · ( t1 · ( bG + s ))))0,5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(Q32=\"non\",MAX(Q34/SQRT(T134/(Q14*Q17)),Q26/SQRT(Q14*(Q17+Q24)^3/(12*Q14*(Q17+Q24)))),\"-\")","v":"-"}]
[]
[null,null,"Coefficient d'élancement de flambement autour de l’axe y entre les échelons",null,null,null,null,null,null,null,null,null,null,null,null,null,"ly,1",null,"=",null,"e",null,null,null,null,null,null,null,"=",{"$f":"Q26/SQRT(Q17*Q14^3/(12*Q14*Q17))","v":34.467811070620655},null,null,null,null,null,null,"Côté sécurité sans tenir compte des bois intermédiaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( bG · t13 / ( 12 · t1 · bG ))0,5"]
[]
[null,null,"Coefficient d'élancement de flambement autour de l’axe y avec Iy,eff",null,null,null,null,null,null,null,null,null,null,null,null,null,"ly,eff",null,"=",null,"sk,y",null,null,null,null,null,null,null,"=",{"$f":"Q36/SQRT(T130/(Gamma!E16+Gamma!E18))","v":14.407026444196189},null,null,null,null,null,null,"Côté sécurité sans tenir compte des bois intermédiaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( Iy,eff / ( A1 + A2 ))0,5"]
[]
[null,null,"Coefficient d'élancement déterminant autour de l’axe y",null,null,null,null,null,null,null,null,null,null,null,null,null,"ly",null,"=",null,"max. { ly,1 ; ly,eff }",null,null,null,null,null,"=",{"$f":"MAX(AD140,AD143)","v":34.467811070620655}]
[]
[null,null,"Coefficient d'élancement déterminant",null,null,null,null,null,null,null,null,null,null,null,null,null,"l",null,"=",null,"max. { ly ; lz }",null,null,null,null,null,"=",{"$f":"MAX(T138,AB146)","v":34.467811070620655}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lrel,c",null,"=",null,"l","·",null,"fc,0,k,1",null,null,null,0.5,"=",{"$f":"AB148/PI()*SQRT(Geometrie!B22/Geometrie!B25*3/2)","v":0.51247550178809498}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p",null,null,"E0,05"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k",null,"=","0,5 · ( 1 + bc · ( lrel,c - 0,3 ) + lrel,c2 )",null,null,null,null,null,null,null,null,null,null,"=",{"$f":"0.5*(1+0.2*(AD150-0.3)+AD150^2)","v":0.65256312014528939}]
[]
[null,null,"Coefficient de flambement",null,null,null,null,null,null,null,null,null,null,null,null,null,"kc",null,"=","min.",null,null,1,null,null,null,null,null,null,null,"=",{"$f":"MIN(1,1/(AF153+SQRT(AF153^2-AD150^2)))","v":0.94647442672606397}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 / ( k + ( k2 - lrel,c2 )0,5 )"]
[]
[]
[null,null,"Vérifications"]
[null,null,"Contrainte dans le centre de gravité due à l’action du vent",null,null,null,null,null,null,null,null,null,null,null,null,null,"ss,d,1",null,"=",null,"Md · g1 · a1",null,null,null,null,"=",{"$f":"Q46*10^6/T130*'NW nachgiebig verb. Biegeträger'!W111*Gamma!D16","v":1.8257959016688041}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iy,eff"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ss,d,2",null,"=","-","Md · g2 · a2",null,null,null,null,"=",{"$f":"-Q46*10^6/T130*AF111*Gamma!D18","v":-1.8257959016688041}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iy,eff"]
[]
[null,null,"Contrainte de flexion au bord due à l’action du vent",null,null,null,null,null,null,null,null,null,null,null,null,null,"sr,d,1",null,"=",null,"Md · ( g1 · a1 + 0,5 · t1 )",null,null,null,null,null,null,null,"=",{"$f":"Q46*10^6/T130*(W111*Gamma!D16+0.5*Gamma!C16)","v":7.5536109824059698}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iy,eff"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sr,d,2",null,"=","-","Md · ( g2 · a2 + 0,5 · t2 )",null,null,null,null,null,null,null,"=",{"$f":"-Q46*10^6/T130*(AF111*Gamma!D18+0.5*Gamma!C18)","v":-7.5536109824059698}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iy,eff"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 4/\",$AM$2)","v":"Page 4/7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C126","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Membrure comprimée"]
[null,null,"Contrainte de flexion au bord due à l’action du vent",null,null,null,null,null,null,null,null,null,null,null,null,null,"sm,d,1",null,"=",null,"sr,d,1",null,null,"=",{"$f":"AD166","v":7.5536109824059698}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fm,d,1",null,"=",null,"kmod",null,"·","fm,k,1",null,"=",{"$f":"Q39/Q40*Geometrie!B24","v":11.076923076923077}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,null,null,"hm,1",null,"=",{"$f":"ABS(Y188)/AA190","v":0.68192321368942788}]
[]
[null,null,"Contrainte de compression due à Nd et Fsd,tot et ss,d,1",null,null,null,null,null,null,null,null,null,null,null,null,null,"sc,d,1",null,"=",null,"Nd + Fv,d,tot",null,null,null,"+","| min { 0 ; ss,d,1 } |",null,null,null,null,null,null,null,null,null,null,"| min { 0 ; ss,d,1 } | signifie : Ajouter uniquement les contraintes de compression quantitatives dans la membrure comprimée (en cas de succion du vent)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t1 · bG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"(Q43+Q49)*1000/(Q14*Q17)+ABS(MIN(0,AA160))","v":5.4859975961539336}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fc,0,d,1",null,"=",null,"kmod",null,"·","fc,0,k,1",null,"=",{"$f":"Q39/Q40*Geometrie!B22","v":11.076923076923077}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,null,null,"hc,1",null,"=",{"$f":"T197/AA199/AF155","v":0.52327211162816867}]
[]
[null,null,"Membrure comprimée",null,null,null,null,null,null,null,null,null,null,null,null,null,"h1",null,"=",null,"hm,1 + hc,1",null,null,null,"=",null,{"$f":"T193+T202","v":1.2051953253175967}]
[]
[]
[null,null,"Membrure de façade"]
[null,null,"Contrainte de flexion due à l’action du vent entre les échelons",null,null,null,null,null,null,null,null,null,null,null,null,null,"sm,zw,2",null,"=",null,"q'h,d · e2 / 8",null,null,null,"=",{"$f":"Q45*(Q26/1000)^2/8*10^6/(Q17*Q15^2/6)","v":1.2137325721153847}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bG · t22 / 6"]
[]
[null,null,"Contrainte de flexion au bord due à l’action du vent",null,null,null,null,null,null,null,null,null,null,null,null,null,"sm,d,2",null,"=",null,"sr,d,2",null,"=",{"$f":"AD169","v":-7.5536109824059698}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fm,d,2",null,"=",null,"kmod",null,"·","fm,k,2",null,"=",{"$f":"Q39/Q40*Geometrie!C24","v":11.076923076923077}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,null,null,"hm,2",null,"=",null,"| sm,zw,2 | + | sm,d,2 |",null,null,null,null,null,null,"=",null,{"$f":"MAX(ABS(Z208)+ABS(X211))/AA213","v":0.79149629311651115}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fm,d,2"]
[]
[null,null,"Contrainte de traction due à Fsd et ss,d,2",null,null,null,null,null,null,null,null,null,null,null,null,null,"st,d,2",null,"=",null,"Fv,d,tot",null,null,"+","max. { 0 ; ss,d,2 }",null,null,null,null,"=",{"$f":"Q49*1000/Q15/Q17+MAX(AA163,0)","v":5.4859975961538474}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t2 · bG"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ft,0,d,2",null,"=",null,"kmod",null,"·","ft,0,k,2",null,"=",{"$f":"Q39/Q40*Geometrie!C23","v":5.8846153846153841}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,null,null,"ht,2",null,"=",{"$f":"AE219/AA222","v":0.93226102941176503}]
[]
[null,null,"Membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,null,"h2",null,"=",null,"hm,2 + ht,2",null,null,null,"=",null,{"$f":"AD216+T225","v":1.7237573225282761}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 5/\",$AM$2)","v":"Page 5/7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C185","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[null,null,"Échelons"]
[null,null,"Nombre d’échelons",null,null,null,null,null,null,null,null,null,null,null,null,"n",null,"=",null,"lE / e",null,null,"=",{"$f":"ROUNDDOWN(Q31/Q26,0)","v":7},null,null,null,null,"(arrondi)"]
[]
[null,null,"Entraxe effectif des échelons",null,null,null,null,null,null,null,null,null,null,null,null,"e'",null,"=",null,"lE / n",null,null,"=",{"$f":"Q31/X246","v":420}]
[]
[null,null,"Hauteur des surfaces de contact",null,null,null,null,null,null,null,null,null,null,null,null,"hf",null,"=",null,"hs",null,"=",{"$f":"Q23","v":62}]
[]
[null,null,"Largeur des surfaces de contact",null,null,null,null,null,null,null,null,null,null,null,null,"bf,1",null,"=",null,"t1",null,"=",{"$f":"Q14","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bf,2",null,"=",null,"t2",null,"=",{"$f":"Q15","v":40}]
[]
[null,null,"Surface des joints de collage",null,null,null,null,null,null,null,null,null,null,null,null,"Af,1",null,"=",null,"hf · bf,1",null,null,null,"=",{"$f":"W250*W252","v":2480}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Af,2",null,"=",null,"hf · bf,2",null,null,null,"=",{"$f":"W250*W253","v":2480}]
[]
[null,null,"Moment d'inertie polaire des surfaces de contact",null,null,null,null,null,null,null,null,null,null,null,null,"Ip,1",null,"=",null,"hf3 · bf,1",null,null,"+","hf · bf,13",null,null,null,"=",{"$f":"(W250^3*W252+W250*W252^3)/12","v":1125093.3333333333},null,null,null,null,"mm4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,12]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ip,2",null,"=",null,"hf3 · bf,2",null,null,"+","hf · bf,23",null,null,null,"=",{"$f":"(W250^3*W253+W250*W253^3)/12","v":1125093.3333333333},null,null,null,null,"mm4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,12]
[]
[null,null,"Sollicitations dues à la charge de façade"]
[null,null,"Force verticale par échelon",null,null,null,null,null,null,null,null,null,null,null,null,"TFs",null,"=",null,"Fv,d,tot",null,null,"=",{"$f":"Q49*1000/X246","v":1222.5937500000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n"]
[]
[null,null,"Moment sur la surface de collage",null,null,null,null,null,null,null,null,null,null,null,null,"MFs,1",null,"=",null,"TFs · ( h - t1 / 2 ) · cj,1",null,null,null,null,null,null,null,null,"=",{"$f":"X265*(Q25-Q14/2)*Gamma!J4/(Gamma!J4+Gamma!J8)","v":134485.31250000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cj,1 + cj,2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MFs,2",null,"=",null,"TFs · ( h - t1 / 2 ) · cj,2",null,null,null,null,null,null,null,null,"=",{"$f":"X265*(Q25-Q14/2)*Gamma!J8/(Gamma!J4+Gamma!J8)","v":134485.31250000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cj,1 + cj,2"]
[]
[null,null,"Sollicitation due à Nd (barre comprimée)"]
[null,null,"Élancement dans le sens z",null,null,null,null,null,null,null,null,null,null,null,null,"ly,eff",null,"=",{"$f":"AD143","v":14.407026444196189}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lrel,c",null,"=",null,"ly,eff",null,"·",null,"fc,0,k,1",null,null,null,0.5,"=",{"$f":"S275/PI()*SQRT(Geometrie!B22/Geometrie!B25*3/2)","v":0.21420704932890439}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p",null,null,null,"E0,05"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k",null,"=","0,5 · ( 1 + bc · ( lrel,c - 0,3 ) + lrel,c2 )",null,null,null,null,null,null,null,null,null,null,"=",{"$f":"0.5*(1+0.2*(AD277-0.3)+AD277^2)","v":0.51436303492398827}]
[]
[null,null,"Coefficient de flambement",null,null,null,null,null,null,null,null,null,null,null,null,"kc",null,"=","min.",null,null,1,null,null,null,null,null,null,null,"=",{"$f":"MIN(1,1/(AE280+SQRT(AE280^2-AD277^2)))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 / ( k + ( k2 - lrel,c2 )0,5 )"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VN",null,"=",null,"Nd / ( 120 · kc )",null,null,null,null,null,null,"ly,eff ≤ 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nd · ly,eff / ( 3600 · kc )",null,null,null,null,null,null,"30 < ly,eff < 60",null,null,null,null,"=",{"$f":"IF(S275>=60,Q43/(60*AE282),IF(S275<=30,Q43/(120*AE282),Q43*S275/(3600*AE282)))*1000","v":1.1250000000000002E-12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nd / ( 60 · kc )",null,null,null,null,null,null,"ly,eff ≥ 60"]
[]
[null,null,"Effort de cisaillement",null,null,null,null,null,null,null,null,null,null,null,null,"TN",null,"=",null,"VN · e'",null,null,"=",{"$f":"AG286*X248/Gamma!C11","v":2.3625000000000005E-12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a"]
[]
[null,null,"Moment sur la surface de contact",null,null,null,null,null,null,null,null,null,null,null,null,"MN,1",null,"=",null,"TN · a · cj,1",null,null,null,null,"=",{"$f":"X289*Gamma!C11*Gamma!J4/(Gamma!J4+Gamma!J8)","v":2.3625000000000004E-10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cj,1 + cj,2"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 6/\",$AM$2)","v":"Page 6/7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C244","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN,2",null,"=",null,"TN · a · cj,2",null,null,null,null,"=",{"$f":"X289*Gamma!C11*Gamma!J8/(Gamma!J4+Gamma!J8)","v":2.3625000000000004E-10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cj,1 + cj,2"]
[]
[null,null,"Sollicitation due à l’action du vent"]
[null,null,"Effort de cisaillement dans le joint flexible",null,null,null,null,null,null,null,null,null,null,null,null,"TQ",null,"=",null,"Qd · g2 · E2 · A2 · a2 · e",null,null,null,null,null,null,null,"=",{"$f":"Q47*AF111*Q20*Gamma!E18*Gamma!D18*Q26/Gamma!C10/Gamma!B20*1000","v":1542.3131420790844}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iy,eff · E1"]
[]
[null,null,"Moment sur la surface de contact",null,null,null,null,null,null,null,null,null,null,null,null,"MQ,1",null,"=",null,"TQ · a · cφ,1",null,null,null,null,"=",{"$f":"AC308*Gamma!C11*Gamma!J4/(Gamma!J4+Gamma!J8)","v":154231.31420790844}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cj,1 + cj,2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MQ,2",null,"=",null,"TQ · a · cφ,2",null,null,null,null,"=",{"$f":"AC308*Gamma!C11*Gamma!J8/(Gamma!J4+Gamma!J8)","v":154231.31420790844}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cj,1 + cj,2"]
[]
[null,null,"Effort de cisaillement parallèle aux échelons",null,null,null,null,null,null,null,null,null,null,null,null,"TH",null,"=",null,"q'h,d · e",null,null,"=",{"$f":"Q26*Q45","v":253.72499999999999}]
[]
[]
[null,null,"Vérification du cisaillement roulant"]
[null,null,"Contrainte de cisaillement roulant",null,null,null,null,null,null,null,null,null,null,null,null,"tR,V,1",null,"=",null,"( ( TFs + TN + TQ )2 + TH2 )0,5",null,null,null,null,null,null,null,null,"=",{"$f":"SQRT((X265+X289+AC308)^2+X317^2)/Y255/2","v":0.55978309991209985}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 · Af,1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tR,V,2",null,"=",null,"( ( TFs + TN + TQ )2 + TH2 )0,5",null,null,null,null,null,null,null,null,"=",{"$f":"SQRT((X265+X289+AC308)^2+X317^2)/Y256/2","v":0.55978309991209985}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 · Af,2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fR,d",null,"=",null,"kmod",null,"·","fR,k",null,null,"=",{"$f":"Q39/Q40*Geometrie!B31","v":0.76153846153846161}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,null,"hR",null,"=",{"$f":"MAX(AD321,AD324)/AA327","v":0.73506871705629262}]
[]
[]
[null,null,"Vérification de la torsion"]
[null,null,"Contrainte de cisaillement en torsion",null,null,null,null,null,null,null,null,null,null,null,null,"tTor,M,1",null,"=",null,"(MFs,1 + MN,1 + MQ,1)",null,null,null,null,null,"·","max. { hf / 2 ; bf,1 / 2 }"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ip,1 / 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,{"$f":"(AD268+Z292+Z311)*MAX(W250,W252)/2/AC258/2","v":3.9775435347342314}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tTor,M,2",null,"=",null,"(MFs,2 + MN,2 + MQ,2)",null,null,null,null,null,"·","max. { hf / 2 ; bf,2 / 2 }"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ip,2 / 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,{"$f":"(AD271+Z304+Z314)*MAX(W250,W253)/2/AC261/2","v":3.9775435347342314}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fTor,R,d",null,"=",null,"kmod",null,"·","fTor,R,k",null,null,"=",{"$f":"Q39/Q40*Geometrie!B32","v":1.3846153846153846}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,null,"hTor",null,"=",{"$f":"MAX(T336,T340)/AA342","v":2.8726703306413892}]
[]
[null,null,"Vérification de la surface de contact",null,null,null,null,null,null,null,null,null,null,null,null,"h",null,"=",null,"max.",null,null,"tR,V,1 / fR,d + tTor,M,1 / fTor,R,d",null,null,null,null,null,null,null,null,"=",{"$f":"MAX(AD321/AA327+T336/AA342,AD324/AA327+T340/AA342)","v":3.6077390476976818}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tR,V,2 / fR,d + tTor,M,2 / fTor,R,d"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 7/\",$AM$2)","v":"Page 7/7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C303","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[]
[null,null,"Flèche due au vent"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"qk",null,"=",null,{"$f":"IF(Eingabe!O74=\"Valeurs_de_dimensionement\",IF(Eingabe!P90=\"Suisse\",Eingabe!Q103/1.4,Eingabe!AC103/1.4),IF(Eingabe!O74=\"caractéristiques\",Eingabe!Q101*Eingabe!Q33/1000,FALSE()))","v":0.30936218338074944},null,null,null,null,{"$f":"IF(Eingabe!O74=\"Valeurs théoriques\",\"La valeur théorique a été diminuée d'un coefficient partiel de sécurité de 1,40\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"l",null,"=",null,{"$f":"Eingabe!Q30","v":400},null,null,null,null,"L’hypothèse se rapporte à un système de poutre à une seule travée entre les fixations !"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"u",null,"=",null,5,null,"·","qk · l4",null,null,null,"=",null,{"$f":"5/384*T367*T369^4/Q19/T130","v":3.8978705713094749E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,384,null,null,"E · Iy,eff"]
[]
[null,null,"Calcul des agrafes dans la membrure de façade"]
[]
[null,null,"Épaisseur de bois bG /2",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$5","v":19.5}]
[null,null,"Épaisseur de bois s",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$6","v":20}]
[]
[null,null,"Matériau de construction",null,null,null,null,null,null,null,null,null,null,null,null,"=","Bois massif"]
[null,null,"CS",null,null,null,null,null,null,null,null,null,null,null,null,"=",2]
[null,null,"KD",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$11","v":"courte"}]
[null,null,"kmod",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$12","v":0.9}]
[null,null,"Classe de tri de membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,"=","C24"]
[null,null,"rk1",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$14","v":350}]
[null,null,"Classe de tri de bois coupé en croix",null,null,null,null,null,null,null,null,null,null,null,null,"=","C24"]
[null,null,"rk2",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$16","v":350}]
[null,null,"gM",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$17","v":1.3}]
[null,null,"gS",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$18","v":1.1000000000000001}]
[null,null,"b",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$19","v":1}]
[]
[null,null,"Agrafe"]
[]
[null,null,"Longueur de clou",null,null,null,null,null,"l",null,null,null,null,null,null,"=",{"$f":"Eingabe!$U$108","v":55}]
[null,null,"Diamètre de clou",null,null,null,null,null,"d",null,null,null,null,null,null,"=",{"$f":"Eingabe!$U$109","v":1.8}]
[null,null,"Entraxe des clous",null,null,null,null,null,"c",null,null,null,null,null,null,"=",{"$f":"Eingabe!$U$110","v":11}]
[]
[null,null,"Calcul :"]
[]
[null,null,"non amorcé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fh,1,k",null,"=",null,{"$f":"Klammerverbindung!$D$27","v":24.060250532031034}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fh,2,k",null,"=",null,{"$f":"Klammerverbindung!$D$28","v":24.060250532031034}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fh,1,d",null,"=",null,{"$f":"Klammerverbindung!$D$30","v":16.65709652217533}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fh,2,d",null,"=",null,{"$f":"Klammerverbindung!$D$31","v":16.65709652217533}]
[]
[null,null,"Moment plastique caractéristique pour clous ronds :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My,k",null,"=",null,{"$f":"Klammerverbindung!$D$34","v":1005.8357553623963}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My,d",null,"=",null,{"$f":"Klammerverbindung!$D$35","v":1106.419330898636}]
[]
[null,null,"Cas de défaillance :",null,null,null,null,null,null,null,null,null,null,null,null,1,null,"=",null,"fh,1,k * t1*d",null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$38","v":844.51479367428942}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"=",null,"0,5 * fh,2,k * t2 * d",null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$39","v":433.08450957655862}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"="]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$40","v":595.48119033657758}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"="]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$41","v":339.43974949377275}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fv,Rd",null,null,null,"=",{"$f":"Klammerverbindung!$D$44","v":469.99349929906998}]
[]
[null,null,"Réduction :",null,null,null,null,null,null,null,null,null,null,null,null,"c ≥ 6*d",null,null,null,"=",null,{"$f":"Klammerverbindung!$D$48","v":1.0185185185185184},null,null,null,{"$f":"IF(V425>1,\"> 1\",\"< 1\")","v":"> 1"},null,null,{"$f":"IF(V425>1,\"Aucune réduction requise\",IF((V425)<1,\"Réduction requise\",))","v":"Aucune réduction requise"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s ≥ 14*l",null,null,null,"=",null,{"$f":"Klammerverbindung!$D$50","v":0.79365079365079372},null,null,null,{"$f":"IF(V427>1,\"> 1\",\"< 1\")","v":"< 1"},null,null,{"$f":"IF(V427>1,\"Aucune réduction requise\",IF((V427)<1,\"Réduction requise\",))","v":"Réduction requise"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t ≥ 7*d",null,null,null,"=",null,{"$f":"Klammerverbindung!$D$52","v":1.2301587301587302},null,null,null,{"$f":"IF(V429>1,\"> 1\",\"< 1\")","v":"> 1"},null,null,{"$f":"IF(V429>1,\"Aucune réduction requise\",IF((V429)<1,\"Réduction requise\",))","v":"Aucune réduction requise"}]
[]
[null,null,"Capacité de charge de la liaison par agrafe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,null,{"$f":"Klammerverbindung!$D$55","v":657.99089901869797}]
[null,null,"Capacité de charge de la membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,null,{"$f":"Klammerverbindung!$D$56","v":5263.9271921495838}]
[]
[]
[null,null,"Entraxes minimum des agrafes pour angle entre dos d’agrafe et sens des fibres > 30°"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a1",null,null,"parallèle au sens des fibres",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$70","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a2",null,null,"perpendiculaire au sens des fibres",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$71","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a1,t",null,null,"Extrémité sollicitée du bois de bout",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$72","v":27}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a1,c",null,null,"Extrémité non sollicitée du bois de bout",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$73","v":12.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a2,t",null,null,"Bord sollicité",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$74","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a2,c",null,null,"Bord non sollicité",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$75","v":9}]
[]
[]
[null,null,"Force verticale par traverse",null,null,null,null,null,null,null,null,null,null,null,null,"FV,d,traverse",null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AD$86*1000/8","v":1069.7695312500002}]
[null,null,"Force horizontale par traverse (vent)",null,null,null,null,null,null,null,null,null,null,null,null,"FH,d,traverse",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Eingabe!P90=\"Suisse\",Eingabe!Q103,Eingabe!$AC$103)*2.94*1000/8","v":234.28124999999997}]
[null,null,"Force sur l’agrafe due au moment",null,null,null,null,null,null,null,null,null,null,null,null,"FM,d,traverse",null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!Q72/Eingabe!Q73*AD268/Eingabe!U110/Eingabe!U106","v":4232.055288461539}]
[]
[]
[null,null,"Vérification de la liaison par agrafe",null,null,null,null,null,null,null,null,null,null,null,null,"h",null,"=",null,"max.",null,null,"FV,d,traverse / Fagrafe",null,null,null,null,null,"=",null,{"$f":"MAX(AA446/Z431,AA447/Z431,AA448/Z431)","v":6.4317839270620025}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FH,d,traverse / Fagrafe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FM,d,traverse / Fagrafe"]

{"sheet":"NW ohne nachgiebigen Verbund","index":2,"n_rows":394,"n_cols":51,"rows_kept":394,"cut":false,"hidden":false,"merged":[[90,6,91,6],[87,2,88,3],[33,2,34,11],[35,2,36,11],[214,2,215,13],[221,2,222,11],[276,2,277,11],[299,2,300,12],[310,2,311,12],[126,2,127,9],[129,2,130,9],[133,2,134,9],[136,2,137,9],[140,2,141,13],[158,2,159,8],[149,2,150,13],[70,2,71,10],[72,2,73,10],[87,4,88,4],[87,6,87,10],[80,2,81,3],[80,5,81,5],[80,7,80,14],[81,7,81,14],[90,4,91,4],[264,2,265,9],[261,2,262,9],[143,2,144,12],[146,2,147,12],[202,2,203,12],[187,2,188,12],[253,2,254,14],[143,14,144,15],[216,14,217,15],[253,15,254,16],[221,16,222,16],[153,14,154,15],[202,14,203,15],[187,14,188,15],[187,16,188,16],[183,2,184,13],[195,2,196,12],[224,14,225,15],[264,27,265,27],[264,28,265,32],[265,19,265,25],[299,17,300,17],[299,21,300,21],[305,15,306,16],[74,20,74,21],[75,20,75,21],[74,24,74,27],[75,24,75,27],[267,15,268,16],[279,26,280,26],[272,23,272,27],[282,26,283,30],[267,17,268,17],[267,27,268,27],[310,15,311,15],[310,17,311,17],[305,26,306,30],[282,17,283,17],[299,15,300,16],[282,15,283,16],[279,17,280,17],[291,23,291,35],[292,23,292,35],[276,27,277,31],[279,15,280,16],[302,15,303,16],[276,15,277,16],[261,15,262,15],[262,19,262,20],[302,17,303,17],[306,19,306,20],[305,19,305,20],[305,17,306,17],[276,19,276,23],[277,19,277,23],[264,17,265,17],[261,17,262,17],[268,19,268,25],[282,22,283,23],[280,19,280,23],[272,19,272,20],[264,15,265,16],[310,22,310,29],[311,22,311,29],[276,17,277,17],[305,21,306,21],[279,19,279,23],[279,27,280,31],[289,19,289,35],[283,19,283,20],[256,15,257,16],[310,33,311,35],[310,19,311,20],[310,31,311,31],[302,22,302,27],[302,19,303,20],[305,25,306,25],[282,19,282,20],[300,22,300,27],[267,28,268,32],[261,22,262,22],[261,23,262,27],[302,21,303,21],[264,19,264,25],[282,25,283,25],[267,19,267,25],[224,16,225,16],[136,14,137,14],[221,14,222,15],[84,2,85,3],[84,5,85,5],[84,7,84,14],[85,7,85,14],[197,14,198,15],[205,16,206,16],[88,6,88,10],[91,8,91,13],[126,14,127,14],[216,16,217,16],[129,16,130,16],[140,14,141,14],[129,14,130,14],[133,16,134,16],[136,16,137,16],[153,16,154,16],[190,14,191,15],[158,16,159,16],[205,14,206,15],[158,14,159,14],[90,2,91,2],[190,16,191,16],[202,24,203,28],[187,18,187,19],[185,18,185,21],[187,20,188,20],[187,24,188,28],[190,20,191,20],[190,23,191,23],[129,26,130,26],[131,17,131,21],[130,19,130,22],[195,22,195,26],[200,17,200,21],[202,16,203,16],[202,18,202,21],[203,18,203,21],[197,18,197,19],[197,16,198,16],[197,21,198,22],[188,18,188,19],[190,17,191,17],[133,18,133,19],[134,18,134,19],[153,19,154,19],[158,29,159,31],[146,24,147,24],[149,18,149,22],[158,17,159,18],[140,17,141,18],[197,20,198,20],[149,26,149,28],[143,26,144,28],[146,18,146,22],[146,26,147,28],[158,28,159,28],[197,23,198,23],[195,18,195,19],[198,18,198,19],[190,24,191,28],[190,18,190,19],[197,24,198,28],[154,21,154,23],[183,18,183,21],[173,19,173,35],[174,19,174,35],[158,20,158,26],[151,26,151,28],[151,18,151,22],[153,26,154,26],[159,20,159,26],[156,29,156,31],[90,7,91,7],[90,8,90,13],[153,27,154,29],[153,21,153,23],[126,27,127,28],[129,29,130,29],[129,23,130,23],[90,20,91,20],[133,14,134,14],[146,16,147,16],[136,17,137,18],[133,21,134,21],[143,16,144,16],[140,16,141,16],[146,14,147,15],[140,20,140,32],[136,23,137,23],[136,26,137,26],[137,19,137,22],[129,30,129,31],[115,19,115,35],[143,18,143,22],[144,18,144,22],[31,16,31,20],[44,48,44,50],[50,37,50,39],[50,40,50,42],[50,45,50,47],[50,48,50,50],[44,37,44,39],[44,40,44,42],[44,45,44,47],[48,16,48,20],[46,16,46,20],[50,16,50,20],[44,16,44,20],[38,16,38,20],[35,16,35,20],[42,16,42,20],[47,16,47,20],[39,16,39,20],[87,22,88,26],[90,22,91,24],[78,19,78,25],[52,40,52,45],[23,16,23,20],[13,16,13,20],[14,16,14,20],[17,16,17,20],[22,16,22,20],[25,16,25,20],[27,16,27,20],[10,9,10,10],[136,30,136,31],[126,16,127,16],[68,13,69,13],[68,21,69,21],[68,22,69,26],[68,16,69,16],[70,13,71,13],[70,15,71,15],[68,15,69,15],[68,18,69,18],[71,19,71,28],[70,16,71,16],[70,18,71,18],[70,19,70,28],[42,2,43,10],[68,2,69,10],[78,29,78,35],[80,31,81,35],[84,22,85,26],[84,31,85,35],[129,19,129,22],[84,19,85,20],[87,19,88,20],[84,30,85,30],[87,21,88,21],[90,29,91,29],[90,30,91,30],[87,31,88,35],[90,31,91,33],[87,30,88,30],[127,18,127,19],[126,21,127,21],[80,19,81,20],[80,30,81,30],[80,21,81,21],[80,28,81,29],[80,22,81,26],[116,19,116,35],[205,23,206,23],[205,24,206,28],[205,18,205,19],[205,20,206,20],[206,18,206,19],[205,21,206,22],[117,23,117,35],[118,23,118,35],[140,34,141,35],[129,28,130,28],[126,18,126,19],[126,22,127,26],[133,27,134,28],[130,30,130,31],[133,22,134,26],[137,30,137,31],[136,29,137,29],[136,28,137,28],[136,19,136,22],[138,17,138,21],[153,25,154,25],[143,24,144,24],[147,18,147,22],[156,17,156,27],[208,17,208,21],[231,19,231,35],[256,33,257,34],[253,17,254,17],[241,19,241,20],[254,23,254,25],[257,19,257,21],[241,23,241,27],[253,33,254,34],[253,23,253,25],[253,28,254,32],[243,23,243,27],[248,22,248,26],[250,19,250,21],[229,18,229,20],[250,24,250,28],[216,20,217,20],[233,23,233,35],[234,23,234,35],[227,17,227,21],[214,18,214,19],[210,18,210,20],[210,24,210,26],[222,18,222,20],[216,21,217,22],[256,17,257,17],[221,18,221,20],[216,23,217,23],[221,23,222,27],[229,24,229,26],[217,18,217,19],[256,23,256,25],[256,27,257,27],[257,23,257,25],[251,24,251,28],[299,31,300,35],[0,19,0,35],[1,19,1,35],[30,16,30,20],[24,16,24,20],[26,16,26,20],[19,16,19,20],[2,23,2,35],[28,16,28,20],[16,16,16,20],[18,16,18,20],[3,23,3,35],[57,19,57,35],[58,19,58,35],[70,31,71,35],[72,20,72,24],[70,30,71,30],[32,16,32,20],[129,17,130,18],[33,16,33,20],[45,16,45,20],[59,23,59,35],[60,23,60,35],[219,17,219,21],[317,16,317,20],[140,33,141,33],[87,28,88,29],[90,21,91,21],[141,20,141,32],[84,21,85,21],[84,28,85,29],[316,16,316,20],[319,16,319,20],[187,23,188,23],[191,18,191,19],[216,24,217,28],[202,23,203,23],[214,22,214,26],[225,18,225,19],[176,23,176,35],[175,23,175,35],[224,23,225,23],[216,18,216,19],[224,21,225,22],[224,20,225,20],[221,22,222,22],[224,24,225,28],[224,18,224,19],[308,18,308,22],[299,19,300,20],[305,22,306,23],[303,22,303,27],[251,19,251,21],[232,19,232,35],[253,19,253,21],[253,22,254,22],[256,19,256,21],[256,22,257,22],[256,28,257,32],[253,27,254,27],[245,22,245,26],[254,19,254,21],[302,29,303,29],[299,29,300,29],[299,22,299,27],[276,26,277,26],[290,19,290,35],[285,18,285,22],[282,21,283,21],[247,22,247,26],[261,19,261,20],[302,31,303,35],[387,26,387,28],[382,15,382,17],[382,18,382,25],[382,26,382,28],[386,26,386,28],[391,21,392,21],[391,27,392,27],[388,26,388,28],[379,15,379,17],[379,18,379,25],[379,26,379,28],[380,15,380,17],[380,18,380,25],[380,26,380,28],[381,15,381,17],[381,18,381,25],[381,26,381,28],[361,20,361,22],[363,20,363,22],[365,21,365,23],[365,25,365,27],[369,21,369,23],[369,25,369,27],[373,25,373,27],[383,15,383,17],[383,18,383,25],[383,26,383,28],[368,21,368,23],[368,25,368,27],[371,25,371,27],[372,25,372,27],[378,15,378,17],[378,18,378,25],[378,26,378,28],[367,21,367,23],[367,25,367,27],[341,19,341,22],[344,19,344,22],[348,19,348,22],[351,26,351,29],[353,19,353,22],[355,20,355,22],[352,19,352,22],[343,19,343,22],[347,19,347,22],[350,19,350,22],[350,26,350,29],[351,19,351,22],[325,16,325,20],[326,16,326,20],[327,16,327,20],[328,16,328,20],[333,16,333,20],[334,16,334,20],[340,19,340,22],[320,16,320,20],[321,16,321,20],[329,16,329,20],[335,16,335,20],[322,16,322,20],[323,16,323,20],[324,16,324,20],[393,22,393,26],[391,28,393,28],[391,30,393,34],[391,19,393,20],[391,17,393,17],[391,15,393,15],[391,2,393,10],[392,22,392,26],[391,22,391,26]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de pages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 1/\",$AN$2)","v":"Page 1/6"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"Eingabe!C8","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Type :",null,null,null,null,null,null,{"$f":"Eingabe!Q11","v":"U*psi S"}]
[null,null,"Hauteur de construction :",null,null,null,null,null,null,{"$f":"Eingabe!Q12","v":240}]
[]
[null,null,"Géométrie"]
[null,null,"Membrure à fixer",null,null,null,null,null,null,null,null,null,null,"t1",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,2,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,2,FALSE),\"\"))","v":40}]
[null,null,"Membrure côté façade",null,null,null,null,null,null,null,"t2 ≤ t1!",null,null,"t2",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,3,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,3,FALSE),\"\"))","v":40}]
[]
[null,null,"Somme de la largeur des deux membrures",null,null,null,null,null,null,null,null,null,null,"bG",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,4,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,4,FALSE),\"\"))-Q24","v":39}]
[null,null,"Classe de résistance",null,null,null,null,null,null,null,null,null,null,null,null,null,"C24"]
[null,null,"Module d'élasticité",null,null,null,null,null,null,null,null,null,null,"E1",null,"=",11000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"E2",null,"=",{"$f":"Q19","v":11000}]
[]
[null,null,"Échelons"]
[null,null,"Hauteur",null,null,null,null,null,null,null,null,null,null,"hs",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I12,5,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,5,FALSE),\"\"))","v":62}]
[null,null,"Largeur",null,null,null,null,null,null,null,null,null,null,"s",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,6,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,6,FALSE),\"\"))","v":20}]
[null,null,"Longueur",null,null,null,null,null,null,null,null,null,null,"h",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,7,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,7,FALSE),\"\"))","v":240}]
[null,null,"Entraxe des échelons",null,null,null,null,null,null,null,null,null,null,"e",null,"=",{"$f":"IF(J10=\"U*psi F\",VLOOKUP(J11,Geometrie!B4:I10,8,FALSE),IF(J10=\"U*psi S\",VLOOKUP(J11,Geometrie!B12:I12,8,FALSE),\"\"))","v":398}]
[null,null,"Classe de résistance",null,null,null,null,null,null,null,null,null,null,null,null,null,"C24"]
[null,null,"Module d'élasticité",null,null,null,null,null,null,null,null,null,null,"EBH",null,"=",11000]
[null,null,"Module de cisaillement",null,null,null,null,null,null,null,null,null,null,"G",null,"=",690]
[]
[null,null,"Longueur de l’élément",null,null,null,null,null,null,null,null,null,null,"l E",null,"=",{"$f":"Eingabe!Q13","v":2940}]
[null,null,"Flambement dans le sens y évité",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!Q25","v":"oui"}]
[]
[null,null,"Longueur de flambement autour de l’axe z",null,null,null,null,null,null,null,null,null,null,"sk,z",null,"=",{"$f":"IF(Q32=\"non\",IF(Eingabe!Q28=\"dans chaque travée\",l,IF(Eingabe!Q28=\"une travée sur deux\",2*l,FALSE())),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hypothèse : dimensionnement suffisant du raccord au mur porteur"]
[]
[null,null,"Longueur de flambement autour de l’axe y",null,null,null,null,null,null,null,null,null,null,"sk,y",null,"=",{"$f":"IF(Eingabe!Q28=\"dans chaque travée\",l,IF(Eingabe!Q28=\"une travée sur deux\",2*l,FALSE()))","v":398},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteur de traverse","Centre de travée","chaque travée","une travée sur deux"]
[]
[]
[null,null,"Fakteur modificatif",null,null,null,null,null,null,null,null,null,null,"kmod",null,"=",{"$f":"Eingabe!Q72","v":0.9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas 1","x",null,"x"]
[null,null,"Coefficient partiel de sécurité",null,null,null,null,null,null,null,null,null,null,"gM",null,"=",{"$f":"Eingabe!Q73","v":1.3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas 2",null,"x","x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas 3","x",null,null,"x"]
[null,null,"Actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas 4",null,null,"x","x"]
[null,null,"Effort normal dans la membrure la plus épaisse",null,null,null,null,null,null,null,null,null,null,"Nd",null,"=",{"$f":"Eingabe!AD81","v":1.3500000000000001E-13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas actuel :",null,null,{"$f":"IF(AND(Eingabe!Q29=\"à hauteur des échelons\",Eingabe!Q28=\"dans chaque travée\"),\"Cas 1\",IF(AND(Eingabe!Q29=\"entre les échelons\",Eingabe!Q28=\"dans chaque travée\"),\"Cas 2\",IF(AND(Eingabe!Q29=\"à hauteur des échelons\",Eingabe!Q28=\"une travée sur deux\"),\"Cas 3\",IF(AND(Eingabe!Q29=\"entre les échelons\",Eingabe!Q28=\"une travée sur deux\"),\"Cas 4\",FALSE()))))","v":"Cas 2"}]
[]
[null,null,"Charge transversale par entretoise",null,null,null,null,null,null,null,null,null,null,"q'h,d",null,"=",{"$f":"IF(Eingabe!P90=\"Allemagne\",Eingabe!AC103,Eingabe!Q103)","v":0.63749999999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moment M","Membrure comprimée",null,null,"Membrure de façade",null,null,null,"Effort tranchant Q","Membrure comprimée",null,null,"Membrure de façade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Md,1",null,"=",{"$f":"AL51","v":1.8984719399999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U*psi F","U*psi S","U*psi T","U*psi F","U*psi S","U*psi T",null,null,"U*psi F","U*psi S","U*psi T","U*psi F","U*psi S","U*psi T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Md,2",null,"=",{"$f":"AO51","v":1.2622818749999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas 1",{"$f":"0/1*q*l^2/10^6","v":0},{"$f":"0/1*q*l^2/10^6","v":0},{"$f":"0/1*q*l^2/10^6","v":0},{"$f":"0.104*q*l^2/10^6","v":1.05021852E-2},{"$f":"0.104*q*l^2/10^6","v":1.05021852E-2},{"$f":"0.103*q*l^2/10^6","v":1.040120265E-2},null,"Cas 1",{"$f":"0/1*q*l/10^3","v":0},{"$f":"0/1*q*l/10^3","v":0},{"$f":"0*q*l/10^3","v":0},{"$f":"0.602*q*l/10^3","v":0.15274245},{"$f":"0.602*q*l/10^3","v":0.15274245},{"$f":"0.604*q*l/10^3","v":0.15324989999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Qd,1",null,"=",{"$f":"AT51","v":0.16542869999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas 2",{"$f":"0.188*q*l^2/10^6","v":1.8984719399999999E-2},{"$f":"0.188*q*l^2/10^6","v":1.8984719399999999E-2},{"$f":"0.196*q*l^2/10^6","v":1.9792579799999998E-2},{"$f":"0.125*q*l^2/10^6","v":1.2622818749999999E-2},{"$f":"0.125*q*l^2/10^6","v":1.2622818749999999E-2},{"$f":"0.109*q*l^2/10^6","v":1.1007097949999999E-2},null,"Cas 2",{"$f":"0.652*q*l/10^3","v":0.16542869999999998},{"$f":"0.652*q*l/10^3","v":0.16542869999999998},{"$f":"0.65*q*l/10^3","v":0.16492124999999999},{"$f":"0.623*q*l/10^3","v":0.15807067499999999},{"$f":"0.623*q*l/10^3","v":0.15807067499999999},{"$f":"0.609*q*l/10^3","v":0.15451852499999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Qd,2",null,"=",{"$f":"AW51","v":0.16492124999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas 3",{"$f":"0.05*q*(2*l)^2/10^6","v":2.0196510000000001E-2},{"$f":"0.05*q*(2*l)^2/10^6","v":2.0196510000000001E-2},{"$f":"0.09*q*(2*l)^2/10^6","v":3.6353717999999993E-2},{"$f":"0.075*q*(2*l)^2/10^6","v":3.0294764999999994E-2},{"$f":"0.075*q*(2*l)^2/10^6","v":3.0294764999999994E-2},{"$f":"0.028*q*(2*l)^2/10^6","v":1.1310045599999999E-2},null,"Cas 3",{"$f":"0.188*q*(2*l)/10^3","v":9.5400600000000002E-2},{"$f":"0.188*q*(2*l)/10^3","v":9.5400600000000002E-2},{"$f":"0.324*q*(2*l)/10^3","v":0.16441379999999997},{"$f":"0.418*q*(2*l)/10^3","v":0.21211409999999997},{"$f":"0.418*q*(2*l)/10^3","v":0.21211409999999997},{"$f":"0.28*q*(2*l)/10^3","v":0.14208599999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cas 4",{"$f":"0.101*q*(2*l)^2/10^6","v":4.0796950200000001E-2},{"$f":"0.101*q*(2*l)^2/10^6","v":4.0796950200000001E-2},{"$f":"0.272*q*(2*l)^2/10^6","v":0.10986901440000001},{"$f":"0.03*q*(2*l)^2/10^6","v":1.2117905999999999E-2},{"$f":"0.03*q*(2*l)^2/10^6","v":1.2117905999999999E-2},{"$f":"0.043*q*(2*l)^2/10^6","v":1.7368998599999998E-2},null,"Cas 4",{"$f":"0.548*q*(2*l)/10^3","v":0.27808260000000001},{"$f":"0.548*q*(2*l)/10^3","v":0.27808260000000001},{"$f":"0.762*q*(2*l)/10^3","v":0.38667689999999999},{"$f":"0.287*q*(2*l)/10^3","v":0.14563814999999997},{"$f":"0.287*q*(2*l)/10^3","v":0.14563814999999997},{"$f":"0.337*q*(2*l)/10^3","v":0.17101064999999999}]
[null,null,"Charge verticale de façade totale",null,null,null,null,null,null,null,null,null,null,"Fv,d,tot",null,"=",{"$f":"Eingabe!AD86","v":8.5581562500000015},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(typ=AL46,VLOOKUP(AN43,AK47:AN50,2),IF(typ=AM46,VLOOKUP(AN43,AK47:AN50,3),IF(typ=AN46,VLOOKUP(AN43,AK47:AN50,4))))","v":1.8984719399999999E-2},null,null,{"$f":"IF(typ=AO46,VLOOKUP(AN43,AK47:AQ50,5),IF(typ=AP46,VLOOKUP(AN43,AK47:AQ50,6),IF(typ=AQ46,VLOOKUP(AN43,AK47:AQ50,7))))","v":1.2622818749999999E-2},null,null,null,null,{"$f":"IF(typ=AT46,VLOOKUP(AN43,AS47:AV50,2),IF(typ=AU46,VLOOKUP(AN43,AS47:AV50,2),IF(typ=AV46,VLOOKUP(AN43,AS47:AV50,3))))","v":0.16542869999999998},null,null,{"$f":"IF(typ=AW46,VLOOKUP(AN43,AS47:AY50,4),IF(typ=AU46,VLOOKUP(AN43,AS47:AY50,4),IF(typ=AY46,VLOOKUP(AN43,AS47:AY50,5))))","v":0.16492124999999999}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les valeurs sont issues de RSTAB de Rouven"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 2/\",$AN$2)","v":"Page 2/6"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C8","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Détermination des efforts internes pour membrures reliées entre elles de manière flexible au cisaillement"]
[]
[null,null,"Entraxe des membrures (centre de gravité)",null,null,null,null,null,null,null,null,null,null,"a","=","h","-","t1","-","t2",null,"=",{"$f":"Gamma!C11","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,2]
[null,null,"Entraxe des centres de gravité (sans g)",null,null,null,null,null,null,null,null,null,null,"a1","=","h","-","t1","-","bG · t1 · ( h - t1 / 2 ) + bG · t2 · t2 / 2",null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Gamma!C12","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"bG · t1 + bG · t2"]
[null,null,"Entraxe des centres de gravité (sans g)",null,null,null,null,null,null,null,null,null,null,"a2","=","a","-","a1",null,"=",{"$f":"Gamma!C13","v":100}]
[]
[null,null,"Surface de la section transversale de la membrure comprimée",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1","=","t1 · bG",null,null,"=",{"$f":"Gamma!E16","v":1560}]
[null,null,"Surface de la section transversale de la membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2","=","t2 · bG",null,null,"=",{"$f":"Gamma!E18","v":1560}]
[]
[null,null,"Rigidités torsionnelles pour déterminer la répartition des moments sur les membrures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EN 1995-1-1 Annexe B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Membrure comprimée",null,null,null,null,null,null,null,null,null,"Membrure de façade"]
[null,null,"1. Déformation de flexion des membrures"]
[null,null,"1 / C1,i ",null,null,"=",null,"ai2 · e",null,null,null,null,null,null,null,null,null,null,null,"1 / C1,1",null,"=",{"$f":"Gamma!B$3","v":1.8844696969696974E-4},null,null,null,null,null,"1 / C1,2",null,"=",{"$f":"Gamma!B$7","v":1.8844696969696974E-4}]
[null,null,null,null,null,null,null,"12 · Ei / gM · (bG · ti3 / 12 )"]
[]
[null,null,"5. Rotation de torsion dans les surfaces de raccord"]
[null,null,"1 / C5,i ",null,null,"=",null,"ai2",null,null,null,null,null,null,null,null,null,null,null,"1 / C5,1",null,"=",{"$f":"Gamma!F$3","v":1.92576615865943E-3},null,null,null,null,null,"1 / C5,2",null,"=",{"$f":"Gamma!F$7","v":1.92576615865943E-3}]
[null,null,null,null,null,null,null,"2 · IP,i · K / gM"]
[]
[null,null,"cφ,i",null,"=",null,"ai2",null,null,null,null,null,null,null,null,null,null,null,null,"cφ,1",null,"=",{"$f":"Gamma!J4","v":4729892.112520393},null,null,null,null,null,"cφ,2",null,"=",{"$f":"Gamma!J8","v":4729892.112520393}]
[null,null,null,null,null,null,"1 / C1,i + 1 / C5,i"]
[]
[null,null,"gi",null,"=",null,1,"+","p2 · Ei / gM · ti · bG · e",null,null,null,null,null,null,-1,null,null,null,null,"g1","=",{"$f":"1/(1+PI()^2*Geometrie!B26*Q14*Q17*Q26/Q31^2/Gamma!B4)","v":6.3751915029834558E-2},null,null,null,null,null,null,"g2","=",{"$f":"1/(1+PI()^2*Geometrie!C26*Q15*Q17*Q26/Q31^2/Gamma!B8)","v":6.3751915029834558E-2}]
[null,null,null,null,null,null,null,null,"lE2 · Ci"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 3/\",$AN$2)","v":"Page 3/6"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C65","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Caractéristiques de la section"]
[]
[null,null,"Iy membrure comprimée",null,null,null,null,null,null,null,null,null,null,null,"Iy,1",null,"=",null,"bG · t13",null,null,"=",{"$f":"Q17*Q14^3/12","v":208000},null,null,null,null,"mm4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[]
[null,null,"Iz membrure comprimée",null,null,null,null,null,null,null,null,null,null,null,"Iz,1",null,"=","2 ·",null,"(bG / 2)3 · t1",null,null,null,"+",null,"s","+","bG",2,"∙","bG · t1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,2,null,4,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"2*(Q17/2)^3*Q14/12+2*(Q24/2+Q17/4)^2*Q17/2*Q14","v":657930},null,null,null,null,"mm4"]
[]
[null,null,"Iy membrure de façade",null,null,null,null,null,null,null,null,null,null,null,"Iy,2",null,"=",null,"bG · t23",null,null,"=",{"$f":"Q17*Q15^3/12","v":208000},null,null,null,null,"mm4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[]
[null,null,"Iz membrure de façade",null,null,null,null,null,null,null,null,null,null,null,"Iz,2",null,"=","2 ·",null,"(bG / 2)3 · t2",null,null,null,"+",null,"s","+","bG",2,"∙","bG · t2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,2,null,4,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"2*(Q17/2)^3*Q15/12+2*(Q24/2+Q17/4)^2*Q17/2*Q15","v":657930},null,null,null,null,"mm4"]
[]
[null,null,"Coefficient d'élancement autour de l’axe Z",null,null,null,null,null,null,null,null,null,null,null,"lz",null,"=","max.",null,null,"sk,z / (Iz,1 / ( t1 · bG ))0,5",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(Q32=\"non\",MAX(Q34/SQRT(R132/(Q14*Q17)),Q26/SQRT(Q14*(Q17+Q24)^3/(12*Q14*(Q17+Q24)))),\"-\")","v":"-"},null,"Côté sécurité sans tenir compte des bois intermédiaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e / ( t1 · ( bG + s )3 / ( 12 · ( t1 · ( bG + s ))))0,5"]
[]
[null,null,"Coefficient d'élancement autour de l’axe y entre les échelons",null,null,null,null,null,null,null,null,null,null,null,"ly,1",null,"=",null,"e",null,null,null,null,null,"=",null,{"$f":"Q26/SQRT(W127/(Q14*Q17))","v":34.467811070620655},null,null,null,null,null,null,null,null,null,"Côté sécurité sans tenir compte des bois intermédiaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Iy,1 / ( t1 · bG ))0,5"]
[]
[null,null,"Coefficient d'élancement autour de l’axe y entre les fixations",null,null,null,null,null,null,null,null,null,null,null,"ly,2",null,"=",null,"sk,y",null,null,null,null,null,"=",null,{"$f":"Q36/SQRT(W127/(Q14*Q17))","v":34.467811070620655},null,null,null,null,null,null,null,null,null,"Côté sécurité sans tenir compte des bois intermédiaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Iy,1 / ( t1 · bG ))0,5"]
[]
[null,null,"Coefficient d'élancement déterminant autour de l’axe y",null,null,null,null,null,null,null,null,null,null,null,"ly",null,"=",null,"max. { ly,1 ; ly,2 }",null,null,null,null,null,"=",null,{"$f":"MAX(AA144,AA147)","v":34.467811070620655}]
[]
[null,null,"Coefficient d'élancement déterminant",null,null,null,null,null,null,null,null,null,null,null,"l",null,"=",null,"max. { ly ; lz }",null,null,null,null,null,"=",null,{"$f":"MAX(AI141,AA150)","v":34.467811070620655}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lrel,c",null,"=",null,"l","·",null,"fc,0,k,1",null,null,null,0.5,"=",{"$f":"AA152/PI()*SQRT(Geometrie!B22/Geometrie!B25*3/2)","v":0.51247550178809498}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p",null,null,"E0,05"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k",null,"=","0,5 · ( 1 + bc · ( lrel,c - 0,3 ) + lrel,c2 )",null,null,null,null,null,null,null,null,null,null,"=",{"$f":"0.5*(1+0.2*(AB154-0.3)+AB154^2)","v":0.65256312014528939}]
[]
[null,null,"Coefficient de flambement",null,null,null,null,null,null,null,null,null,null,null,"kc",null,"=","min.",null,null,1,null,null,null,null,null,null,null,"=",{"$f":"MIN(1,1/(AD157+SQRT(AD157^2-AB154^2)))","v":0.94647442672606397}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 / ( k + ( k2 - lrel,c2 )0,5 )"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 4/\",$AN$2)","v":"Page 4/6"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C123","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Vérifications"]
[null,null,"Contrainte dans le centre de gravité due à l’action du vent",null,null,null,null,null,null,null,null,null,null,null,"ss,d,1",null,"=",null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ss,d,2",null,"=",null,0]
[]
[null,null,"Contrainte de flexion au bord due à l’action du vent",null,null,null,null,null,null,null,null,null,null,null,"sr,d,1",null,"=",null,"Md,1",null,"·","t1",null,"=",{"$f":"Q46*10^6/W127*Q14/2","v":1.8254537884615383}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iy,1",null,null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sr,d,2",null,"=","-","Md,2",null,"·","t2",null,"=",{"$f":"-Q47*10^6/W134*Q15/2","v":-1.2137325721153844}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iy,2",null,null,2]
[]
[]
[null,null,"Membrure comprimée"]
[null,null,"Contrainte de flexion au bord due à l’action du vent",null,null,null,null,null,null,null,null,null,null,null,"sm,d,1",null,"=",null,"sr,d,1",null,null,"=",{"$f":"Y188","v":1.8254537884615383}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fm,d,1",null,"=",null,"kmod",null,"·","fm,k,1",null,"=",{"$f":"Q39/Q40*Geometrie!B24","v":11.076923076923077}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,"hm,1",null,"=",{"$f":"ABS(W196)/Y198","v":0.16479791145833331}]
[]
[null,null,"Contrainte de compression due à Nd et Fsd,tot",null,null,null,null,null,null,null,null,null,null,null,"sc,d,1",null,"=",null,"Nd + Fv,d,tot",null,null,null,null,"=",{"$f":"(Q43+Q51)*1000/(Q14*Q17)/AD159","v":5.7962449288043301}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kc · t1 · bG"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fc,0,d,1",null,"=",null,"kmod",null,"·","fc,0,k,1",null,"=",{"$f":"Q39/Q40*Geometrie!B22","v":11.076923076923077}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,"hc,1",null,"=",{"$f":"Y203/Y206","v":0.52327211162816867}]
[]
[null,null," Membrure comprimée",null,null,null,null,null,null,null,null,null,null,null,"h1",null,"=",null,"hm,1 + hc,1",null,null,null,"=",null,{"$f":"R201+R209","v":0.688070023086502}]
[]
[]
[null,null,"Membrure de façade"]
[null,null,"Contrainte de flexion au bord due à l’action du vent",null,null,null,null,null,null,null,null,null,null,null,"sm,d,2",null,"=",null,"sr,d,2",null,null,"=",{"$f":"Y191","v":-1.2137325721153844}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fm,d,2",null,"=",null,"kmod",null,"·","fm,k,2",null,"=",{"$f":"Q39/Q40*Geometrie!C24","v":11.076923076923077}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,"hm,2",null,"=",{"$f":"ABS(W215)/Y217","v":0.10957307942708332}]
[]
[null,null,"Contrainte de traction due à Fsd,tot",null,null,null,null,null,null,null,null,null,null,null,"st,d,2",null,"=",null,"Fv,d,tot",null,null,null,"=",{"$f":"Q51*1000/Q15/Q17","v":5.4859975961538474}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t2 · bG"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ft,0,d,2",null,"=",null,"kmod",null,"·","ft,0,k,2",null,"=",{"$f":"Q39/Q40*Geometrie!C23","v":5.8846153846153841}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,"ht,2",null,"=",{"$f":"X222/Y225","v":0.93226102941176503}]
[]
[null,null,"Membrure de façade",null,null,null,null,null,null,null,null,null,null,null,"h2",null,"=",null,"hm,2 + ht,2",null,null,null,"=",null,{"$f":"R220+R228","v":1.0418341088388483}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 5/\",$AN$2)","v":"Page 5/6"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C181","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Échelons"]
[null,null,"Nombre d’échelons",null,null,null,null,null,null,null,null,null,null,null,null,"n",null,"=",null,"lE / e",null,null,"=",{"$f":"ROUNDDOWN(Q31/Q26,0)","v":7},null,null,null,null,"(arrondi)"]
[]
[null,null,"Entraxe effectif des échelons",null,null,null,null,null,null,null,null,null,null,null,null,"e'",null,"=",null,"lE / n",null,null,"=",{"$f":"Q31/X242","v":420}]
[]
[null,null,"Hauteur des surfaces de contact",null,null,null,null,null,null,null,null,null,null,null,null,"hf",null,"=",null,"hs",null,"=",{"$f":"Q23","v":62}]
[]
[null,null,"Largeur des surfaces de contact",null,null,null,null,null,null,null,null,null,null,null,null,"bf,1",null,"=",null,"t1",null,"=",{"$f":"Q14","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bf,2",null,"=",null,"t2",null,"=",{"$f":"Q15","v":40}]
[]
[null,null,"Surface des joints de collage",null,null,null,null,null,null,null,null,null,null,null,null,"Af,1",null,"=",null,"hf · bf,1",null,null,null,"=",{"$f":"W246*W248","v":2480}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Af,2",null,"=",null,"hf · bf,2",null,null,null,"=",{"$f":"W246*W249","v":2480}]
[]
[null,null,"Moment d'inertie polaire des surfaces de contact",null,null,null,null,null,null,null,null,null,null,null,null,"Ip,1",null,"=",null,"hf3 · bf,1",null,null,"+","hf · bf,13",null,null,null,"=",{"$f":"(W246^3*W248+W246*W248^3)/12","v":1125093.3333333333},null,null,null,null,"mm4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,12]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ip,2",null,"=",null,"hf3 · bf,2",null,null,"+","hf · bf,23",null,null,null,"=",{"$f":"(W246^3*W249+W246*W249^3)/12","v":1125093.3333333333},null,null,null,null,"mm4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,12]
[]
[]
[null,null,"Sollicitations dues à la charge de façade"]
[null,null,"Force verticale par échelon",null,null,null,null,null,null,null,null,null,null,null,null,"TFs",null,"=",null,"Fv,d,tot",null,null,"=",{"$f":"Q51*1000/X242","v":1222.5937500000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n"]
[]
[null,null,"Moment sur la surface de contact",null,null,null,null,null,null,null,null,null,null,null,null,"MFs,1",null,"=",null,"TFs · ( h - t1 / 2 ) · cj,1",null,null,null,null,null,null,null,"=",{"$f":"X262*(Q25-Q14/2)*Gamma!J4/(Gamma!J4+Gamma!J8)","v":134485.31250000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cj,1 + cj,2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MFs,2",null,"=",null,"TFs · ( h - t1 / 2 ) · cj,2",null,null,null,null,null,null,null,"=",{"$f":"X262*(Q25-Q14/2)*Gamma!J8/(Gamma!J4+Gamma!J8)","v":134485.31250000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cj,1 + cj,2"]
[]
[]
[null,null,"Sollicitation due à l’action du vent"]
[null,null,"Effort de cisaillement parallèle aux échelons",null,null,null,null,null,null,null,null,null,null,null,null,"TH",null,"=",null,"q'h,d · e",null,null,"=",{"$f":"Q26*Q45","v":253.72499999999999}]
[]
[]
[null,null,"Vérification du cisaillement roulant"]
[null,null,"Contrainte de cisaillement roulant",null,null,null,null,null,null,null,null,null,null,null,null,"tR,V,1",null,"=",null,"( TFs2 + TH2 )0,5",null,null,null,null,null,null,"=",{"$f":"SQRT(X262^2+X273^2)/Y251/2","v":0.25174274310030093}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 · Af,1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tR,V,2",null,"=",null,"( TFs2 + TH2 )0,5",null,null,null,null,null,null,"=",{"$f":"SQRT(X262^2+X273^2)/Y252/2","v":0.25174274310030093}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 · Af,2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fR,d",null,"=",null,"kmod",null,"·","fR,k",null,null,"=",{"$f":"Q39/Q40*Geometrie!B31","v":0.76153846153846161}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,null,"hR",null,"=",{"$f":"MAX(AB277,AB280)/AA283","v":0.33057127881857695}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Page 6/\",$AN$2)","v":"Page 6/6"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet de construction :",null,null,null,null,null,{"$f":"IF(Eingabe!$X$3=\"\",\"\",Eingabe!$X$3)","v":"travaux de rénovation Dupont"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position :          ",null,null,null,null,null,{"$f":"IF(Eingabe!$X$4=\"\",\"\",Eingabe!$X$4)","v":"20.1 Poutre de mur-rideau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AJ$5","v":"© 2024"}]
["Landstraße 25, D - 79809 Weilheim - Bannholz"]
[]
[null,null,{"$f":"C239","v":"Calcul de entretoise U*psi selon DIN EN 1995                        [mars 2020]"}]
[]
[null,null,"Vérification de la torsion"]
[null,null,"Contrainte de cisaillement en torsion",null,null,null,null,null,null,null,null,null,null,null,null,"tTor,M,1",null,"=",null,"MFs,1",null,"·","max. { hf / 2 ; bf,1 / 2 }",null,null,null,null,null,null,"=",null,{"$f":"AC265*MAX(W246,W248)/2/AC254/2","v":1.8527550399522414}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ip,1 / 2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tTor,M,2",null,"=",null,"MFs,2",null,"·","max. { hf / 2 ; bf,2 / 2 }",null,null,null,null,null,null,"=",null,{"$f":"AC268*MAX(W246,W249)/2/AC257/2","v":1.8527550399522414}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ip,2 / 2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fTor,R,d",null,"=",null,"kmod",null,"·","fTor,R,k",null,null,"=",{"$f":"Q39/Q40*Geometrie!B32","v":1.3846153846153846}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gM"]
[]
[null,null,"Vérification",null,null,null,null,null,null,null,null,null,null,null,null,"hTor",null,"=",{"$f":"MAX(AF300,AF303)/AA306","v":1.3381008621877299}]
[]
[null,null,"Vérification de la surface de contact",null,null,null,null,null,null,null,null,null,null,null,null,"h",null,"=",null,"max.",null,null,"tR,V,1 / fR,d + tTor,M,1 / fTor,R,d",null,null,null,null,null,null,null,null,"=",null,{"$f":"MAX(AB277/AA283+AF300/AA306,AB280/AA283+AF303/AA306)","v":1.668672141006307}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tR,V,2 / fR,d + tTor,M,2 / fTor,R,d"]
[]
[]
[null,null,"Calcul des agrafes dans la membrure de façade"]
[]
[null,null,"Épaisseur de bois bG /2",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$5","v":19.5}]
[null,null,"Épaisseur de bois s",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$6","v":20}]
[]
[null,null,"Matériau de construction",null,null,null,null,null,null,null,null,null,null,null,null,"=","Bois massif"]
[null,null,"CS",null,null,null,null,null,null,null,null,null,null,null,null,"=",2]
[null,null,"KD",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$11","v":"courte"}]
[null,null,"kmod",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$12","v":0.9}]
[null,null,"Classe de tri de membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,"=","C24"]
[null,null,"rk1",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$14","v":350}]
[null,null,"Classe de tri de bois coupé en croix",null,null,null,null,null,null,null,null,null,null,null,null,"=","C24"]
[null,null,"rk2",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$16","v":350}]
[null,null,"gM",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$17","v":1.3}]
[null,null,"gS",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$18","v":1.1000000000000001}]
[null,null,"b",null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$19","v":1}]
[]
[null,null,"Agrafe"]
[]
[null,null,"Longueur de clou",null,null,null,null,null,"l",null,null,null,null,null,null,"=",{"$f":"Eingabe!$U$108","v":55}]
[null,null,"Diamètre de clou",null,null,null,null,null,"d",null,null,null,null,null,null,"=",{"$f":"Eingabe!$U$109","v":1.8}]
[null,null,"Entraxe des clous",null,null,null,null,null,"c",null,null,null,null,null,null,"=",{"$f":"Eingabe!$U$110","v":11}]
[]
[null,null,"Calcul :"]
[]
[null,null,"non amorcé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fh,1,k",null,"=",null,{"$f":"Klammerverbindung!$D$27","v":24.060250532031034}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fh,2,k",null,"=",null,{"$f":"Klammerverbindung!$D$28","v":24.060250532031034}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fh,1,d",null,"=",null,{"$f":"Klammerverbindung!$D$30","v":16.65709652217533}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fh,2,d",null,"=",null,{"$f":"Klammerverbindung!$D$31","v":16.65709652217533}]
[]
[null,null,"Moment plastique caractéristique pour clous ronds :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My,k",null,"=",null,{"$f":"Klammerverbindung!$D$34","v":1005.8357553623963}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My,d",null,"=",null,{"$f":"Klammerverbindung!$D$35","v":1106.419330898636}]
[]
[null,null,"Cas de défaillance :",null,null,null,null,null,null,null,null,null,null,null,null,1,null,"=",null,"fh,1,k * t1*d",null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$38","v":844.51479367428942}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"=",null,"0,5 * fh,2,k * t2 * d",null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$39","v":433.08450957655862}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"="]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$40","v":595.48119033657758}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"="]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Klammerverbindung!$D$41","v":339.43974949377275}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fv,Rd",null,null,null,"=",{"$f":"Klammerverbindung!$D$44","v":469.99349929906998}]
[]
[null,null,"Réduction :",null,null,null,null,null,null,null,null,null,null,null,null,"c ≥ 6*d",null,null,null,"=",null,{"$f":"Klammerverbindung!$D$48","v":1.0185185185185184},null,null,null,{"$f":"IF(V366>1,\"> 1\",\"< 1\")","v":"> 1"},null,null,{"$f":"IF(V366>1,\"Aucune réduction requise\",IF((V366)<1,\"Réduction requise\",))","v":"Aucune réduction requise"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s ≥ 14*l",null,null,null,"=",null,{"$f":"Klammerverbindung!$D$50","v":0.79365079365079372},null,null,null,{"$f":"IF(V368>1,\"> 1\",\"< 1\")","v":"< 1"},null,null,{"$f":"IF(V368>1,\"Aucune réduction requise\",IF((V368)<1,\"Réduction requise\",))","v":"Réduction requise"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t ≥ 7*d",null,null,null,"=",null,{"$f":"Klammerverbindung!$D$52","v":1.2301587301587302},null,null,null,{"$f":"IF(V370>1,\"> 1\",\"< 1\")","v":"> 1"},null,null,{"$f":"IF(V370>1,\"Aucune réduction requise\",IF((V370)<1,\"Réduction requise\",))","v":"Aucune réduction requise"}]
[]
[null,null,"Capacité de charge de la liaison par agrafe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,null,{"$f":"Klammerverbindung!$D$55","v":657.99089901869797}]
[null,null,"Capacité de charge de la membrure de façade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,null,{"$f":"Klammerverbindung!$D$56","v":5263.9271921495838}]
[]
[]
[null,null,"Entraxes minimum des agrafes pour angle entre dos d’agrafe et sens des fibres > 30°"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a1",null,null,"parallèle au sens des fibres",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$70","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a2",null,null,"perpendiculaire au sens des fibres",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$71","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a1,t",null,null,"Extrémité sollicitée du bois de bout",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$72","v":27}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a1,c",null,null,"Extrémité non sollicitée du bois de bout",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$73","v":12.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a2,t",null,null,"Bord sollicité",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$74","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a2,c",null,null,"Bord non sollicité",null,null,null,null,null,null,null,{"$f":"Klammerverbindung!$E$75","v":9}]
[]
[]
[null,null,"Force verticale par traverse",null,null,null,null,null,null,null,null,null,null,null,null,"FV,d,traverse",null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!$AD$86*1000/8","v":1069.7695312500002}]
[null,null,"Force horizontale par traverse (vent)",null,null,null,null,null,null,null,null,null,null,null,null,"FH,d,traverse",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Eingabe!P90=\"Suisse\",Eingabe!Q103,Eingabe!$AC$103)*2.94*1000/8","v":234.28124999999997}]
[null,null,"Force sur l’agrafe due au moment",null,null,null,null,null,null,null,null,null,null,null,null,"FM,d,traverse",null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!Q72/Eingabe!Q73*AC268/Eingabe!U110/Eingabe!U106","v":4232.055288461539}]
[]
[]
[null,null,"Vérification de la liaison par agrafe",null,null,null,null,null,null,null,null,null,null,null,null,"h",null,"=",null,"max.",null,null,"FV,d,traverse / Fagrafe",null,null,null,null,null,"=",null,{"$f":"MAX(AA387/Z372,AA388/Z372,AA389/Z372)","v":6.4317839270620025}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FH,d,traverse / Fagrafe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FM,d,traverse / Fagrafe"]

{"sheet":"Geometrie","index":3,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Caractéristiques de la section U*psi"]
[]
["Type","Hauteur de construction","t1","t2","b","hs","s","h","e"]
["F 2940-120/59/40",120,40,40,59,62,20,120,398]
["F 2940-160/59/40",160,40,40,59,62,20,160,398]
["F 2940-200/59/40",200,40,40,59,62,20,200,398]
["F 2940-240/59/40",240,40,40,59,62,20,240,398]
["F 2940-300/59/40",300,40,40,59,62,20,300,398]
["F 2940-360/59/40",360,40,40,59,62,20,360,398]
["F 2940-400/59/40",400,40,40,59,62,20,400,398]
[]
["S 2940-240/59/40",240,40,40,59,62,20,240,398]
[]
[]
[]
[]
[]
[]
["Caractéristiques mécaniques pour",null,{"$f":"Eingabe!Q11","v":"U*psi S"}]
[null,"Membrure comprimée","Membrure de façade"]
["Bride"]
["fc,0,k",16,16]
["ft,0,k",8.5,8.5]
["fm,k",16,16]
["E0,mean",11000,11000]
["E1,2",{"$f":"B25/1.3","v":8461.538461538461},{"$f":"C25/1.3","v":8461.538461538461}]
[]
["Bois intermédiaire",null,"/gM"]
["Gmean",690,{"$f":"B29/1.3","v":530.76923076923072}]
["GR,mean",50,{"$f":"B30/1.3","v":38.46153846153846}]
["fR,k",1.1000000000000001]
["fTor,R,k",2,null,"(selon DIN EN 338 fv,k=4,0;kcr=0,5)"]
["fv,k",2]

{"sheet":"Gamma","index":4,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Détermination de C1",null,null,null,null,null,null,null,null,"Rigidités torsionnelles pour déterminer la répartition des moments"]
["Part","Torsion de barre","Flexion BH","Cisaillement BH","Delta VM","Torsion VM","Somme"]
["1/C1=",{"$f":"C12^2*'NW nachgiebig verb. Biegeträger'!Q26/(12*Geometrie!B26*'NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q14^3/12)","v":1.8844696969696974E-4},{"$f":"(1/24*C11^3-1/3*(C11/2-C12)^3)/(Geometrie!B26*'NW nachgiebig verb. Biegeträger'!Q24*'NW nachgiebig verb. Biegeträger'!Q23^3/12)","v":9.9175773037006286E-5},{"$f":"C12/(Geometrie!C29*5/6*'NW nachgiebig verb. Biegeträger'!Q23*'NW nachgiebig verb. Biegeträger'!Q24)","v":1.8232819074333803E-4},{"$f":"'NW nachgiebig verb. Biegeträger'!Q24/(4*Geometrie!C30*'NW nachgiebig verb. Biegeträger'!Q23*'NW nachgiebig verb. Biegeträger'!Q14)","v":5.2419354838709686E-5},{"$f":"C12^2/(2*3/1.3*'NW nachgiebig verb. Biegeträger'!AC258)","v":1.92576615865943E-3},{"$f":"SUM(B3:F3)","v":2.4481364469754537E-3}]
["C1=",{"$f":"1/G3","v":408.47396444566988},"N/mm",null,null,null,null,null,"cφ,1 =",{"$f":"D16^2/(B3+F3)","v":4729892.112520393},"Nmm"]
["Détermination de C3"]
["Part","Torsion de barre","Flexion BH","Cisaillement BH","Delta VM","Torsion VM","Somme",null,null,null,null,null,null,"un",null,"trois"]
["1/C3=",{"$f":"C13^2*'NW nachgiebig verb. Biegeträger'!Q26/(12*Geometrie!C26*'NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q15^3/12)","v":1.8844696969696974E-4},{"$f":"(1/24*C11^3+1/3*(C11/2-C12)^3)/(Geometrie!B26*'NW nachgiebig verb. Biegeträger'!Q24*'NW nachgiebig verb. Biegeträger'!Q23^3/12)","v":9.9175773037006286E-5},{"$f":"C13/(Geometrie!C29*5/6*'NW nachgiebig verb. Biegeträger'!Q24*'NW nachgiebig verb. Biegeträger'!Q23)","v":1.8232819074333808E-4},{"$f":"'NW nachgiebig verb. Biegeträger'!Q24/(4*Geometrie!C30*'NW nachgiebig verb. Biegeträger'!Q23*'NW nachgiebig verb. Biegeträger'!Q15)","v":5.2419354838709686E-5},{"$f":"C13^2/(2*3/1.3*'NW nachgiebig verb. Biegeträger'!AC261)","v":1.92576615865943E-3},{"$f":"SUM(B7:F7)","v":2.4481364469754537E-3},null,null,null,null,null,"Torsion de barre",2.1264687693259129E-6,{"$f":"N7/$N$12","v":2.1373914508627963E-2},2.076629657544836E-4,{"$f":"P7/$P$12","v":0.19674488748671956}]
["C3=",{"$f":"1/G7","v":408.47396444566988},"N/mm",null,null,null,null,null,"cφ,3 =",{"$f":"D18^2/(B7+F7)","v":4729892.112520393},"Nmm",null,"Flexion BH",3.4342349112112396E-6,{"$f":"N8/$N$12","v":3.4518749794779834E-2},5.3659920487675586E-5,{"$f":"P8/$P$12","v":5.0838699045528346E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cisaillement BH",5.9428571428571447E-5,{"$f":"N9/$N$12","v":0.59733828373451003},1.485714285714286E-4,{"$f":"P9/$P$12","v":0.14076014416834359}]
["Module d'élasticité de référence",null,{"$f":"'NW nachgiebig verb. Biegeträger'!Q19","v":11000},"N/mm²",null,null,null,null,null,null,null,null,"Delta VM",7.5362318840579718E-6,{"$f":"N10/$N$12","v":7.5749420038796547E-2},1.8840579710144928E-5,{"$f":"P10/$P$12","v":1.7850018282217481E-2}]
["Entraxe des membrures a (centre de gravité)",null,{"$f":"C12+C13","v":200},"mm",null,null,null,null,null,null,null,null,"Torsion VM",2.6963464410154314E-5,{"$f":"N11/$N$12","v":0.2710196319232856},6.2675868605787733E-4,{"$f":"P11/$P$12","v":0.59380625101719109}]
["Entraxe des centres de gravité a1 (sans g)",null,{"$f":"'NW nachgiebig verb. Biegeträger'!Q25-0.5*'NW nachgiebig verb. Biegeträger'!Q14-('NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q14*Gamma!H16*('NW nachgiebig verb. Biegeträger'!Q25-0.5*'NW nachgiebig verb. Biegeträger'!Q14)+'NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q15*Gamma!H18*0.5*'NW nachgiebig verb. Biegeträger'!Q15)/('NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q14*Gamma!H16+'NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q15*Gamma!H18)","v":100},"mm","Centre de gravité",{"$f":"('NW nachgiebig verb. Biegeträger'!Q14*('NW nachgiebig verb. Biegeträger'!Q25-'NW nachgiebig verb. Biegeträger'!Q14/2) + 'NW nachgiebig verb. Biegeträger'!Q15^2/2)/('NW nachgiebig verb. Biegeträger'!Q14+'NW nachgiebig verb. Biegeträger'!Q15)","v":120},"mm",null,null,null,null,null,null,{"$f":"SUM(N7:N11)","v":9.948897140332088E-5},null,{"$f":"SUM(P7:P11)","v":1.0554935805816099E-3}]
["Entraxe des centres de gravité a3 (sans g)",null,{"$f":"('NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q14*Gamma!H16*('NW nachgiebig verb. Biegeträger'!Q25-0.5*'NW nachgiebig verb. Biegeträger'!Q14)+'NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q15*Gamma!H18*0.5*'NW nachgiebig verb. Biegeträger'!Q15)/('NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q14*Gamma!H16+'NW nachgiebig verb. Biegeträger'!Q17*'NW nachgiebig verb. Biegeträger'!Q15*Gamma!H18)-0.5*'NW nachgiebig verb. Biegeträger'!Q15","v":100},"mm"]
[]
["Partie","b","h","a ","A","n * g * A * a^2","n * I","n","Données de base et données de suivi"]
[1,{"$f":"'NW nachgiebig verb. Biegeträger'!Q17","v":39},{"$f":"'NW nachgiebig verb. Biegeträger'!Q14","v":40},{"$f":"C12","v":100},{"$f":"B16*C16","v":1560},{"$f":"H16*'NW nachgiebig verb. Biegeträger'!W111*Gamma!E16*Gamma!D16^2","v":994529.8744654191},{"$f":"1/12*H16*B16*C16^3","v":208000},{"$f":"'NW nachgiebig verb. Biegeträger'!Q19/Gamma!C10","v":1},"Système"]
[2,{"$f":"'NW nachgiebig verb. Biegeträger'!Q24","v":20},null,{"$f":"0.5*('NW nachgiebig verb. Biegeträger'!W111*Gamma!H16*Gamma!B16*Gamma!C16*(Gamma!C16+('NW nachgiebig verb. Biegeträger'!Q25-'NW nachgiebig verb. Biegeträger'!Q14-'NW nachgiebig verb. Biegeträger'!Q15))-'NW nachgiebig verb. Biegeträger'!AF111*Gamma!H18*Gamma!B18*Gamma!C18*(Gamma!C18+('NW nachgiebig verb. Biegeträger'!Q25-'NW nachgiebig verb. Biegeträger'!Q14-'NW nachgiebig verb. Biegeträger'!Q15)))/('NW nachgiebig verb. Biegeträger'!W111*Gamma!H16*Gamma!B16*Gamma!C16+Gamma!H17*Gamma!B17*('NW nachgiebig verb. Biegeträger'!Q25-'NW nachgiebig verb. Biegeträger'!Q14-'NW nachgiebig verb. Biegeträger'!Q15)+'NW nachgiebig verb. Biegeträger'!AF111*Gamma!H18*Gamma!B18*Gamma!C18)","v":0},{"$f":"B17*C17","v":0},null,null,{"$f":"'NW nachgiebig verb. Biegeträger'!Q28/Gamma!C10","v":1},"e",{"$f":"'NW nachgiebig verb. Biegeträger'!Q26","v":398}]
[3,{"$f":"'NW nachgiebig verb. Biegeträger'!Q17","v":39},{"$f":"'NW nachgiebig verb. Biegeträger'!Q15","v":40},{"$f":"C13","v":100},{"$f":"B18*C18","v":1560},{"$f":"H18*'NW nachgiebig verb. Biegeträger'!AF111*Gamma!E18*Gamma!D18^2","v":994529.8744654191},{"$f":"1/12*H18*B18*C18^3","v":208000},{"$f":"'NW nachgiebig verb. Biegeträger'!Q20/Gamma!C10","v":1},"l",{"$f":"'NW nachgiebig verb. Biegeträger'!Q31","v":2940}]
[null,null,null,null,{"$f":"SUM(E16:E18)","v":3120},{"$f":"SUM(F16:F18)","v":1989059.7489308382},{"$f":"SUM(G16:G18)","v":416000},null,"b",1]
["eff I",{"$f":"F19+G19","v":2405059.748930838},"mm4",null,null,null,null,null,"ly"]

{"sheet":"Klammerverbindung","index":5,"n_rows":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":true,"merged":[[46,1,46,2],[48,1,48,2],[0,0,0,6],[50,1,50,2]]}
["Calcul des agrafes U*psi S"]
[]
["Nombre d’agrafes par traverse",{"$f":"Eingabe!U106","v":2}]
["Système :"]
[null,"Épaisseur de bois bG /2","=",{"$f":"'NW ohne nachgiebigen Verbund'!Q17/2","v":19.5}]
[null,"Épaisseur de bois s","=",{"$f":"'NW ohne nachgiebigen Verbund'!Q24","v":20}]
[]
["Matériau :"]
[null,"Matériau de construction","=","Bois massif"]
[null,"CS","=",{"$f":"Eingabe!Q69","v":1}]
[null,"KD","=",{"$f":"Eingabe!Q70","v":"courte"}]
[null,"kmod","=",{"$f":"Eingabe!Q72","v":0.9}]
[null,"Classe de tri de membrure de façade","=","C24"]
[null,"rk1","=",350]
[null,"Classe de tri de bois coupé en croix","=","C24"]
[null,"rk2","=",350]
[null,"gM","=",1.3]
[null,"gS","=",1.1000000000000001]
[null,"b","=",1]
[]
[null,"Longueur de clou","L",{"$f":"Eingabe!U108","v":55}]
[null,"Diamètre de clou","d",{"$f":"Eingabe!U109","v":1.8}]
[null,"Entraxe des clous","c",{"$f":"Eingabe!U110","v":11}]
[]
["Calcul :"]
[null,"non amorcé :"]
[null,"fh,1,k",null,{"$f":"0.082*D14*(D22)^(-0.3)","v":24.060250532031034}]
[null,"fh,2,k",null,{"$f":"0.082*D16*(D22)^-(0.3)","v":24.060250532031034}]
[]
[null,"fh,1,d",null,{"$f":"D12/D17*D27","v":16.65709652217533}]
[null,"fh,2,d",null,{"$f":"D12/D17*D28","v":16.65709652217533}]
[]
[null,"Moment plastique caractéristique pour clous ronds :"]
[null,"My,k",null,{"$f":"0.3*800*D22^2.6/D18","v":1005.8357553623963}]
[null,"My,d",null,{"$f":"D18*D34","v":1106.419330898636}]
[]
["Cas de défaillance :"]
[null,1,"RK1",{"$f":"D27*D5*D22","v":844.51479367428942}]
[null,2,"RK2",{"$f":"0.5*D28*D6*D22","v":433.08450957655862}]
[null,3,"RK3",{"$f":"1.05*((D27*D5*D22)/(2+D19))*(SQRT(2*D19*(1+D19)+(4*D19*(2+D19)*D34)/(D30*D22*D5^2)-D19))","v":595.48119033657758}]
[null,4,"RK4",{"$f":"1.15*SQRT((2*D19)/(1+D19))*SQRT(2*D34*D27*D22)","v":339.43974949377275}]
[]
[null,"Fv,Rk","min.",{"$f":"2*MIN(D38:D41)","v":678.8794989875455}]
[null,"Fv,Rd",null,{"$f":"D43*D12/D17","v":469.99349929906998}]
["Réduction :"]
[]
[null,"c ≥ 6*d"]
[null,{"$f":"D23","v":11},{"$f":"6*D22","v":10.8},{"$f":"B48/C48","v":1.0185185185185184},{"$f":"IF(D48>1,\"> 1\",\"< 1\")","v":"> 1"},{"$f":"IF(D48>1,\"Aucune réduction requise\",IF((D48)<1,\"Réduction requise\",))","v":"Aucune réduction requise"},{"$f":"IF(F48=\"Réduction requise\",0.7,1)","v":1}]
[null,"s ≥ 14*d"]
[null,{"$f":"D6","v":20},{"$f":"14*D22","v":25.2},{"$f":"B50/C50","v":0.79365079365079372},{"$f":"IF(D50>1,\"> 1\",\"< 1\")","v":"< 1"},{"$f":"IF(D50>1,\"Aucune réduction requise\",IF((D50)<1,\"Réduction requise\",))","v":"Réduction requise"},{"$f":"IF(F50=\"Réduction requise\",0.7,1)","v":0.7}]
[null,"t ≥ 7*d"]
[null,{"$f":"D21-D5-D6","v":15.5},{"$f":"7*D22","v":12.6},{"$f":"B52/C52","v":1.2301587301587302},{"$f":"IF(D52>1,\"> 1\",\"< 1\")","v":"> 1"},{"$f":"IF(D52>1,\"Aucune réduction requise\",IF((D52)<1,\"Réduction requise\",))","v":"Aucune réduction requise"},{"$f":"IF(F52=\"Réduction requise\",0.7,1)","v":1}]
[]
[]
["Capacité de charge de la liaison par agrafe",null,"Fliaison par agrafe",{"$f":"D44*B3*G56","v":657.99089901869797}]
["Capacité de charge de la membrure de façade",null,null,{"$f":"D55*8","v":5263.9271921495838},null,null,{"$f":"MIN(G50,G52)","v":0.7}]
[]
[]
["Force verticale par traverse",null,"FV,d,traverse",{"$f":"Eingabe!AD86*1000/8","v":1069.7695312500002}]
["Force horizontale par traverse (vent)",null,"FH,d,traverse",{"$f":"IF(Eingabe!P90=\"Suisse\",Eingabe!Q103,Eingabe!AC103)*2.94*1000/8","v":234.28124999999997}]
["Moment par traverse",null,"FM,d,traverse",{"$f":"Eingabe!Q72/Eingabe!Q73*'NW ohne nachgiebigen Verbund'!AC268/Eingabe!U110","v":8464.110576923078}]
[]
[]
[]
["Entraxes minimum des agrafes pour angle entre dos d’agrafe et sens des fibres > 30°"]
[]
["Angle entre la direction de l'effort et le sens des fibres",null,null,"a",{"$f":"Eingabe!U112","v":"0°- 90°"}]
["Angle entre dos d’agrafe et sens des fibres",null,null,"b",{"$f":"Eingabe!U113","v":">30°"}]
[]
[null,"a1","parallèle au sens des fibres",null,{"$f":"5*$D$22","v":9}]
[null,"a2","perpendiculaire au sens des fibres",null,{"$f":"5*$D$22","v":9}]
[null,"a1,t","Extrémité sollicitée du bois de bout",null,{"$f":"15*D22","v":27}]
[null,"a1,c","Extrémité non sollicitée du bois de bout",null,{"$f":"7*$D$22","v":12.6}]
[null,"a2,t","Bord sollicité",null,{"$f":"5*$D$22","v":9}]
[null,"a2,c","Bord non sollicité",null,{"$f":"5*$D$22","v":9}]

{"sheet":"Grenzwerte ","index":6,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":true,"merged":[[1,11,1,14],[28,11,28,14]]}
[null,null,null,null,null,null,null,null,null,null,"CHARGE PAR m²"]
[null,null,null,null,null,null,null,null,null,null,"Charge horizontale\nqR,k,⊥\n[kN/m²]","Charge verticale\nqR,k,II\n[kN/m²]"]
[null,null,null,null,null,null,null,null,null,null,null,"F_g_160","F_g_200","F_g_240","F_g_300"]
[null,null,null,null,null,null,null,null,null,null,0,3.3,2.75,2.35,1.9]
[null,null,null,null,null,null,null,null,null,null,0.5,3.3,2.75,2.2999999999999998,1.9]
[null,null,null,null,null,null,null,null,null,null,1,3.25,2.7,2.2999999999999998,1.85]
[null,null,null,null,null,null,null,null,null,null,1.5,3.2,2.65,2.25,1.85]
[null,null,null,null,null,null,null,null,null,null,2,3.15,2.6,2.2000000000000002,1.75]
[null,null,null,null,null,null,null,null,null,null,2.5,3.05,2.5,2.15,1.7]
[null,null,null,null,null,null,null,null,null,null,3,3,2.4500000000000002,2.0499999999999998,1.65]
[null,null,null,null,null,null,null,null,null,null,3.5,2.9,2.35,1.95,1.55]
[null,null,null,null,null,null,null,null,null,null,4,2.75,2.25,1.85,1.5]
[null,null,null,null,null,null,null,null,null,null,4.5,2.4500000000000002,2.15,1.75,1.4]
[null,null,null,null,null,null,null,null,null,null,5,2.2000000000000002,2,1.65,1.3]
[null,null,null,null,null,null,null,null,null,null,5.5,1.95,1.9,1.6,1.25]
[null,null,null,null,null,null,null,null,null,null,6,1.7,1.65,1.45,1.1499999999999999]
[null,null,null,null,null,null,null,null,null,null,6.5,1.45,1.45,1.35,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,7,1.1499999999999999,1.1499999999999999,1.1499999999999999,1]
[null,null,null,null,null,null,null,null,null,null,7.5,0.9,0.9,0.9,0.9]
[null,null,null,null,null,null,null,null,null,null,8,0.65,0.65,0.65,0.65]
[null,null,null,null,null,null,null,null,null,null,8.5,0.35,0.35,0.35,0.35]
[null,null,null,null,null,null,null,null,null,null,9,0.1,0.1,0.1,0.1]
[null,null,null,null,null,null,null,null,null,null,9.5,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,10,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"CHARGE PAR mc"]
[null,null,null,null,null,null,null,null,null,null,"Charge horizontale\nqR,k,⊥\n[kN/mc]","Charge verticale\nqR,k,II\n[kN/mc]"]
[null,null,null,null,null,null,null,null,null,null,null,"F_g_160","F_g_200","F_g_240","F_g_300"]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"L4/0.625","v":5.2799999999999994},4.4000000000000004,3.7600000000000002,3.04]
[null,null,null,null,null,null,null,null,null,null,0.5,5.2799999999999994,4.4000000000000004,3.6799999999999997,3.04]
[null,null,null,null,null,null,null,null,null,null,1,5.2,4.32,3.6799999999999997,2.96]
[null,null,null,null,null,null,null,null,null,null,1.5,5.12,4.24,3.6,2.96]
[null,null,null,null,null,null,null,null,null,null,2,5.04,4.16,3.5200000000000005,2.8]
[null,null,null,null,null,null,null,null,null,null,2.5,4.88,4,3.44,2.7199999999999998]
[null,null,null,null,null,null,null,null,null,null,3,4.8,3.9200000000000004,3.28,2.6399999999999997]
[null,null,null,null,null,null,null,null,null,null,3.5,4.6399999999999997,3.7600000000000002,3.12,2.48]
[null,null,null,null,null,null,null,null,null,null,4,4.4000000000000004,3.6,2.96,2.4]
[null,null,null,null,null,null,null,null,null,null,4.5,3.9200000000000004,3.44,2.8,2.2399999999999998]
[null,null,null,null,null,null,null,null,null,null,5,3.5200000000000005,3.2,2.6399999999999997,2.08]
[null,null,null,null,null,null,null,null,null,null,5.5,3.12,3.04,2.56,2]
[null,null,null,null,null,null,null,null,null,null,6,2.7199999999999998,2.6399999999999997,2.3199999999999998,1.8399999999999999]
[null,null,null,null,null,null,null,null,null,null,6.5,2.3199999999999998,2.3199999999999998,2.16,1.7600000000000002]
[null,null,null,null,null,null,null,null,null,null,7,1.8399999999999999,1.8399999999999999,1.8399999999999999,1.6]
[null,null,null,null,null,null,null,null,null,null,7.5,1.44,1.44,1.44,1.44]
[null,null,null,null,null,null,null,null,null,null,8,1.04,1.04,1.04,1.04]
[null,null,null,null,null,null,null,null,null,null,8.5,0.55999999999999994,0.55999999999999994,0.55999999999999994,0.55999999999999994]
[null,null,null,null,null,null,null,null,null,null,9,0.16,0.16,0.16,0.16]
[null,null,null,null,null,null,null,null,null,null,9.5,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,10,0,0,0,0]