{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Aperçu","Sol","Plafond","Mur","Console murale","Sol-Mur","Plafond-Mur","Hilfstabelle"],"not_rendered":{"charts":0,"images":13,"macros":0,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Aperçu","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,3,0,4],[2,0,2,5],[12,0,13,5],[14,0,14,5],[15,0,15,5],[4,0,5,5],[6,0,7,5],[8,0,9,5],[10,0,11,5]]}
[null,null,null,"Département fédéral de la défense, de la protection \nde la population et des sports DDPS\n\nOffice fédéral de la protection de la population OFPP\nLaboratoire Spiez"]
[]
["Calcul justificatif simplifié des fixations antichocs"]
[]
["Pour le calcul justificatif des fixations antichocs, il convient de définir les forces qui s'exercent en cas de charge de choc sur les fixations (ancrages, tampons) des éléments montés dans les constructions (forces de fixation)."]
[]
["Les forces s'exerçant sur l'élément dues aux charges de choc sont considérées comme des charges statiques de remplacement, qui agissent au centre d'inertie de l'élément."]
[]
["Les forces de fixation S doivent en principe être calculées pour toutes les directions spatiales x, y et z, des effets du choc, et ce, dans la direction positive et négative. Pour la vérification de la résistance aux chocs, les forces de fixation maximales Smax sont déterminantes."]
[]
["Pour le calcul justificatif simplifié, il est nécessaire que l'élément soit rigide et que la charge s'exerce uniformément (équilibrage de charge) sur les fixations (ancrages, tampons).  "]
[]
["Pour les six situations représentées (points de fixation), les forces de fixation S nécessaires pour la vérification de la résistance aux chocs peuvent être calculées à l'aide des feuilles de travail à disposition pour le niveau de protection \"base\" et \"3 bars\":"]
[]
["            Données (masse de l'élément, position du centre d'inertie, nombre de fixations, dimensions), dans les champs jaunes"]
["            Résultats (forces de fixation), dans les champs verts"]
[]
["Fixation au sol","Fixation au plafond","Fixation au mur","Fixation sur une console murale","Fixation au sol \net au mur","Fixation au plafond \net au mur"]
[]
[]
[{"$nulls":5},"dash@bbs 2018"]

{"sheet":"Sol","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,5,0,7],[24,0,24,5],[1,0,1,7],[17,5,18,7]]}
[{"$nulls":5},"Département fédéral de la défense, de la protection \nde la population et des sports DDPS\n\nOffice fédéral de la protection de la population OFPP\nLaboratoire Spiez"]
["Fixation de l'élément au sol"]
[]
["Niveau de protection",null,null,"Base"]
[]
[]
["Élément"]
["Masse","m","[kg]",125]
["Nombre de fixations (ancrages, tampons)","n","[-]",6]
["Dimensions","bx","[mm]",800]
[null,"ex","[mm]",100]
[null,"by","[mm]",1200]
[null,"ey","[mm]",150]
[null,"hz","[mm]",600]
[]
[]
["Force de fixation",{"$nulls":4},"Calcul justificatif de la charge admissible"]
["En cas de charge de choc dans la direction x","Sx","[kN]",{"$f":"(D$8*Hilfstabelle!D6/D$9*(1+4*(D$14/D10)^2)^0.5)/1000","v":5.8684102790755031},null,"Opter pour des tampons/ancrages homologués par l'OFPP pour les fixations antichocs d'éléments dans les constructions.\nCharge admissiblet Radm selon la base de données pour composants \nde la protection civile (ZKDB): "]
["En cas de charge de choc dans la direction y","Sy","[kN]",{"$f":"(D$8*Hilfstabelle!D6/D$9*(1+4*(D$14/D12)^2)^0.5)/1000","v":4.6035597733499189}]
["En cas de charge de choc dans la direction z","Sz+","[kN]",{"$f":"(D8*(Hilfstabelle!D6-9.81)/D9*(1+2*D11/D10)*(1+2*D13/D12))/1000","v":4.7669270833333339},null,"https://www.zkdb.vbs.admin.ch"]
["Force de fixation maximale","Smax","[kN]",{"$f":"MAX(D18:D20)","v":5.8684102790755031},null,"Radm  ≥ Smax"]
[]
[]
["Calcul justificatif simplifié des fixations antichocs",{"$nulls":5},"Date:","2018-10-03"]
["Apparail, Équipement, Produit de manufacturé, Type, Série",{"$nulls":5},"Visa:","dash"]

{"sheet":"Plafond","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,5,0,7],[24,0,24,5],[1,0,1,7],[17,5,18,7]]}
[{"$nulls":5},"Département fédéral de la défense, de la protection \nde la population et des sports DDPS\n\nOffice fédéral de la protection de la population OFPP\nLaboratoire Spiez"]
["Fixation de l'élément au plafond"]
[]
["Niveau de protection",null,null,"Base"]
[]
[]
["Élément"]
["Masse","m","[kg]",100]
["Nombre de fixations (ancrages, tampons)","n","[-]",6]
["Dimensions","bx","[mm]",800]
[null,"ex","[mm]",100]
[null,"by","[mm]",1200]
[null,"ey","[mm]",150]
[null,"hz","[mm]",400]
[]
[]
["Force de fixation",{"$nulls":4},"Calcul justificatif de la charge admissible"]
["En cas de charge de choc dans la direction x","Sx","[kN]",{"$f":"$D$8/$D$9*((Hilfstabelle!D7)^2+(2*Hilfstabelle!D7*$D$14/D10+9.81)^2)^0.5/1000","v":3.8002187839064687},null,"Opter pour des tampons/ancrages homologués par l'OFPP pour les fixations antichocs d'éléments dans les constructions.\nCharge admissiblet Radm selon la base de données pour composants \nde la protection civile (ZKDB): "]
["En cas de charge de choc dans la direction y","Sy","[kN]",{"$f":"$D$8/$D$9*((Hilfstabelle!D7)^2+(2*Hilfstabelle!D7*$D$14/D12+9.81)^2)^0.5/1000","v":3.2233843086474452}]
["En cas de charge de choc dans la direction z","Sz-","[kN]",{"$f":"D8*(Hilfstabelle!D7+9.81)/D9*(1+2*D11/D10)*(1+2*D13/D12)/1000","v":4.3244791666666664},null,"https://www.zkdb.vbs.admin.ch"]
["Force de fixation maximale","Smax","[kN]",{"$f":"MAX(D18:D20)","v":4.3244791666666664},null,"Radm  ≥ Smax"]
[]
[]
["Calcul justificatif simplifié des fixations antichocs",{"$nulls":5},"Date:","2018-10-03"]
["Apparail, Équipement, Produit de manufacturé, Type, Série",{"$nulls":5},"Visa:","dash"]

{"sheet":"Mur","index":3,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,5,0,7],[24,0,24,5],[1,0,1,7],[17,5,18,7]]}
[{"$nulls":5},"Département fédéral de la défense, de la protection \nde la population et des sports DDPS\n\nOffice fédéral de la protection de la population OFPP\nLaboratoire Spiez"]
["Fixation de l'élément au mur"]
[]
["Niveau de protection",null,null,"Base"]
[]
[]
["Élément"]
["Masse","m","[kg]",100]
["Nombre de fixations (ancrages, tampons)","n","[-]",6]
["Dimensions","bx","[mm]",800]
[null,"ex","[mm]",100]
[null,"bz","[mm]",1200]
[null,"ez","[mm]",150]
[null,"hy","[mm]",500]
[]
[]
["Force de fixation",{"$nulls":4},"Calcul justificatif de la charge admissible"]
["En cas de charge de choc dans la direction x","Sx","[kN]",{"$f":"(D8/D9*((Hilfstabelle!D8)^2+(9.81^2)+(4*(D14^2))*(Hilfstabelle!D8/D10+9.81/D12)^2)^0.5)/1000","v":4.2790660084314993},null,"Opter pour des tampons/ancrages homologués par l'OFPP pour les fixations antichocs d'éléments dans les constructions.\nCharge admissiblet Radm selon la base de données pour composants \nde la protection civile (ZKDB): "]
["En cas de charge de choc dans la direction y","Sy","[kN]",{"$f":"(D8/D9*((9.81^2)+((Hilfstabelle!D8*(1+(2*D11/D10))*(1+(2*D13/D12))+(2*9.81*D14/D12)))^2)^0.5)/1000","v":4.2084376462035777}]
["En cas de charge de choc dans la direction z","Sz-","[kN]",{"$f":"(D8*(Hilfstabelle!D8+9.81)/D9*(1+(4*(D14/D12)^2))^0.5)/1000","v":3.6026946143918308},null,"https://www.zkdb.vbs.admin.ch"]
["Force de fixation maximale","Smax","[kN]",{"$f":"MAX(D18:D20)","v":4.2790660084314993},null,"Radm  ≥ Smax"]
[]
[]
["Calcul justificatif simplifié des fixations antichocs",{"$nulls":5},"Date:","2018-10-03"]
["Apparail, Équipement, Produit de manufacturé, Type, Série",{"$nulls":5},"Visa:","dash"]

{"sheet":"Console murale","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,5,0,7],[30,0,30,5],[1,0,1,7],[21,5,23,7]]}
[{"$nulls":5},"Département fédéral de la défense, de la protection \nde la population et des sports DDPS\n\nOffice fédéral de la protection de la population OFPP\nLaboratoire Spiez"]
["Fixation de l'élément sur une console murale"]
[]
["Niveau de protection",null,null,"Base"]
[]
[]
["Élément"]
["Masse","m","[kg]",65]
["Nombre de consoles","k","[-]",2]
["Nombre de fixations par console","nK","[-]",3]
["Dimensions","bx","[mm]",600]
[null,"hy","[mm]",300]
[null,"hz","[mm]",250]
[null,"bz","[mm]",500]
[null,"z1","[mm]",50]
[null,"z2","[mm]",350]
[null,"z3","[mm]",450]
[null,"z4","[mm]"]
[]
[]
["Force de fixation",{"$nulls":4},"Calcul justificatif de la charge admissible"]
["En cas de charge de choc dans la direction x","Sx","[kN]",{"$f":"(D8/D9*(1/(D10^2)*((Hilfstabelle!D9)^2+(9.81^2))+D12^2*(2*Hilfstabelle!D9/(D10*D11)+9.81/SUM('Console murale'!D15:D18))^2)^0.5)/1000","v":2.476979728348792},null,"Opter pour des tampons/ancrages homologués par l'OFPP pour les fixations antichocs d'éléments dans les constructions.\nCharge admissiblet Radm selon la base de données pour composants \nde la protection civile (ZKDB): "]
["En cas de charge de choc dans la direction y+","Sy+","[kN]",{"$f":"($D$8/$D$9*((9.81/$D$10)^2+((Hilfstabelle!D9*($D$13+$D$14)+9.81*$D$12)/SUM($D$15:$D$18))^2)^0.5)/1000","v":4.5944542958059786}]
["En cas de charge de choc dans la direction y-","Sy-","[kN]",{"$f":"(D8/D9*((9.81/D10)^2+((Hilfstabelle!D9*(D13+D14)-(9.81*D12))/(D10*(D14-((D15+D16+D17+D18)/D10))))^2)^0.5)/1000","v":5.713213528851341}]
["En cas de charge de choc dans la direction z+","Sz+","[kN]",{"$f":"(D8/D9*((9.81/D10)^2+((Hilfstabelle!D9-9.81)*D12/(D10*(D14-((D15+D16+D17+D18)/D10))))^2)^0.5)/1000","v":2.1991693740194274},null,"https://www.zkdb.vbs.admin.ch"]
["En cas de charge de choc dans la direction z-","Sz-","[kN]",{"$f":"($D$8/$D$9*((9.81/$D$10)^2+((Hilfstabelle!D9+9.81)*$D$12/SUM($D$15:$D$18))^2)^0.5)/1000","v":1.9077682839043546}]
["Force de fixation maximale","Smax","[kN]",{"$f":"MAX(D22:D26)","v":5.713213528851341},null,"Radm  ≥ Smax"]
[]
[]
["Calcul justificatif simplifié des fixations antichocs",{"$nulls":5},"Date:","2018-10-03"]
["Apparail, Équipement, Produit de manufacturé, Type, Série",{"$nulls":5},"Visa:","dash"]

{"sheet":"Sol-Mur","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,5,0,7],[28,0,28,5],[1,0,1,7],[18,5,20,7]]}
[{"$nulls":5},"Département fédéral de la défense, de la protection \nde la population et des sports DDPS\n\nOffice fédéral de la protection de la population OFPP\nLaboratoire Spiez"]
["Fixation de l'élément au sol et au mur"]
[]
["Niveau de protection",null,null,"Base"]
[]
[]
["Élément"]
["Masse","m","[kg]",200]
["Nombre de fixations au sol","nB","[-]",4]
["Nombre de fixations au mur","nW","[-]",2]
["Dimensions   ","bx","[mm]",800]
[null,"by","[mm]",600]
[null,"bz","[mm]",2000]
[null,"hy","[mm]",300]
[null,"hz","[mm]",1000]
[]
[]
["Force de fixation",{"$nulls":4},"Calcul justificatif de la charge admissible"]
["En cas de charge de choc dans la direction x","Sx, B","[kN]",{"$f":"$D$8*Hilfstabelle!D10*((1/($D$10+$D$9))+(2*$D$14/($D$10*$D$11+$D$9*$D$12)))/1000","v":9.8958333333333321},null,"Opter pour des tampons/ancrages homologués par l'OFPP pour les fixations antichocs d'éléments dans les constructions.\nCharge admissiblet Radm selon la base de données pour composants \nde la protection civile (ZKDB): "]
["En cas de charge de choc dans la direction x","Sx,W","[kN]",{"$f":"$D$8*Hilfstabelle!D10*((1/($D$10+$D$9))^2+(2*$D$14/($D$10*$D$11+$D$9*$D$12))^2)^0.5/1000","v":7.0070958578508904}]
["En cas de charge de choc dans la direction y+","Sy+,B","[kN]",{"$f":"($D$8*Hilfstabelle!$D$10/$D$9)*(1-($D$15/$D$13))/1000","v":3.90625}]
["En cas de charge de choc dans la direction y+","Sy+,W","[kN]",{"$f":"$D$8*Hilfstabelle!$D$10/$D$10*($D$15/$D$13)/1000","v":7.8125},null,"https://www.zkdb.vbs.admin.ch"]
["En cas de charge de choc dans la direction z+","Sz+,B","[kN]",{"$f":"($D$8*(Hilfstabelle!$D$10-9.81)/$D$9)*($D$14/$D$12)/1000","v":3.661}]
["En cas de charge de choc dans la direction z+","Sz+,W","[kN]",{"$f":"($D$8*(Hilfstabelle!$D$10-9.81)/$D$10)*(1-($D$14/$D$12))/1000","v":7.3220000000000001}]
["Force de fixation maximale","Smax","[kN]",{"$f":"MAX(D19:D24)","v":9.8958333333333321},null,"Rzul  ≥ Smax"]
[]
[]
["Calcul justificatif simplifié des fixations antichocs",{"$nulls":5},"Date:","2018-10-03"]
["Apparail, Équipement, Produit de manufacturé, Type, Série",{"$nulls":5},"Visa:","dash"]

{"sheet":"Plafond-Mur","index":6,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,5,0,7],[27,0,27,5],[1,0,1,7],[17,5,19,7]]}
[{"$nulls":5},"Département fédéral de la défense, de la protection \nde la population et des sports DDPS\n\nOffice fédéral de la protection de la population OFPP\nLaboratoire Spiez"]
["Fixation de l'élément au plafond et au mur"]
[]
["Niveau de protection",null,null,"Base"]
[]
[]
["Élément"]
["Masse","m","[kg]",150]
["Nombre de fixations (ancrages, tampons)","n","[-]",8]
["Dimensions","bx","[mm]",1200]
[null,"by","[mm]",900]
[null,"bz","[mm]",750]
[null,"hy","[mm]",450]
[null,"hz","[mm]",350]
[]
[]
["Force de fixation",{"$nulls":4},"Calcul justificatif de la charge admissible"]
["En cas de charge de choc dans la direction x","Sx,D","[kN]",{"$f":"$D$8/$D$9*((Hilfstabelle!$D$11)^2+4*((Hilfstabelle!$D$11*$D$13/$D$10)+9.81)^2)^0.5/1000","v":3.8939716580480708},null,"Opter pour des tampons/ancrages homologués par l'OFPP pour les fixations antichocs d'éléments dans les constructions.\nCharge admissiblet Radm selon la base de données pour composants \nde la protection civile (ZKDB): "]
["En cas de charge de choc dans la direction x","Sx,W","[kN]",{"$f":"$D$8/$D$9*((Hilfstabelle!$D$11)^2+(9.81)^2+4*(Hilfstabelle!$D$11*$D$13/$D$10)^2)^0.5/1000","v":3.6667257980886898}]
["En cas de charge de choc dans la direction y+","Sy+,D","[kN]",{"$f":"2*D8/D9*((Hilfstabelle!D11)^2+(9.81*D13/D11)^2)^0.5/1000","v":5.8622613720757331}]
["En cas de charge de choc dans la direction y+","Sy+,W","[kN]",{"$f":"2*D8/D9*((Hilfstabelle!D11*D14/D12)^2+(9.81)^2)^0.5/1000","v":2.759010448738823},null,"https://www.zkdb.vbs.admin.ch"]
["En cas de charge de choc dans la direction z-","Sz-,D","[kN]",{"$f":"2*$D$8/$D$9*(Hilfstabelle!$D$11+9.81)*D13/D11/1000","v":3.1136249999999999}]
["En cas de charge de choc dans la direction z-","Sz-,W","[kN]",{"$f":"2*$D$8/$D$9*(Hilfstabelle!$D$11+9.81)/1000","v":6.2272499999999997}]
["Force de fixation maximale","Smax","[kN]",{"$f":"MAX(D18:D23)","v":6.2272499999999997},null,"Rzul  ≥ Smax"]
[]
[]
["Calcul justificatif simplifié des fixations antichocs",{"$nulls":5},"Date:","2018-10-03"]
["Apparail, Équipement, Produit de manufacturé, Type, Série",{"$nulls":5},"Visa:","dash"]

{"sheet":"Hilfstabelle","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Schutzgrade"]
["Base"]
["3 bar"]
[]
["Eingesetzter a x DLF Wert"]
["a x  DLF","Boden","[m/s2]",{"$f":"IF(Sol!D4=\"Base\",156.25,IF(Sol!D4=\"3 bar\",256))","v":156.25}]
["a x  DLF","Decke","[m/s2]",{"$f":"IF(Plafond!D4=\"Base\",156.25,IF(Plafond!D4=\"3 bar\",256))","v":156.25}]
["a x  DLF","Wand","[m/s2]",{"$f":"IF(Mur!D4=\"Base\",156.25,IF(Mur!D4=\"3 bar\",256))","v":156.25}]
["a x  DLF","Wandkonsole","[m/s2]",{"$f":"IF('Console murale'!D4=\"Base\",156.25,IF('Console murale'!D4=\"3 bar\",256))","v":156.25}]
["a x  DLF","Boden-Wand","[m/s2]",{"$f":"IF('Sol-Mur'!D4=\"Base\",156.25,IF('Sol-Mur'!D4=\"3 bar\",256))","v":156.25}]
["a x  DLF","Decke-Wand","[m/s2]",{"$f":"IF('Plafond-Mur'!D4=\"Base\",156.25,IF('Plafond-Mur'!D4=\"3 bar\",256))","v":156.25}]