{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dati Edificio","Analisi Lineare-Stato di Fatto","Analisi Lineare-Stato Progetto","PushOver - Stato di Fatto","PushOver - Stato di Progetto","All.A DM.65"],"not_rendered":{"charts":2,"images":8,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dati Edificio","index":0,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,5,52,7],[39,5,39,7],[40,5,43,7],[45,5,45,7],[46,5,47,7],[48,5,48,7],[33,15,35,21],[32,15,32,21],[31,15,31,21],[36,5,36,7],[37,5,38,7],[29,2,29,5],[10,7,10,8],[13,3,13,4],[14,3,14,4],[7,3,7,10],[8,3,8,10],[13,6,13,8],[14,6,14,8],[30,6,30,7],[30,8,30,9],[31,2,31,3],[32,2,32,3],[30,2,30,3],[31,4,31,5],[32,4,32,5],[30,4,30,5]]}
[]
[null,null,"ASSEVERAZIONE RISCHIO SISMICO "]
[null,null,"DM. N.58 DEL 28/02/2017 ",null,null,null,null,null,null,null,null,null,null,null,null,"Istruzioni"]
[null,null,"Integr. DM. N.65 DEL 07/03/2017 - DM. N.24 del 09/01/2020 - DM. N.329 del 06/08/2020",null,null,null,null,null,null,null,null,null,null,null,null,"Compilare Celle evidenziate"]
[null,null,"ALLEGATO A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specificare Se:"]
[null,null,"UBICAZIONE IMMOBILE",null,null,null,null,null,null,null,null,null,null,null,null,"- Considerare PGA=ag"]
[null,null,"COMUNE DI"]
[null,null,"INDIRIZZO"]
[null,null,"DATI CATASTALI"]
[null,null,"FOGLIO",12,"P.LLA",12,"SUB",1]
[null,null,"COORDINATE GEOGRAFICHE"]
[null,null,null,"LATITUDINE",null,null,"LONGITUDINE",null,null,null,"FUSO"]
[null,null,"SPIGOLO 1",null,null,null,null,null,null,null,33]
[null,null,"SPIGOLO 2",null,null,null,null,null,null,null,33]
[]
[null,null,"S=Ss*St=",1.2,null,null,null,null,null,null,null,null,null,null,null,"- Considerare PGA = ag·S"]
[]
[null,null,"ACCELERAZIONI AL SUOLO di riferimento"]
[]
[null,null,"STATO LIMITE","TR","ag (g)","PGAD",null,null,null,null,"h"]
[null,null,"SLO",45,3.3000000000000002E-2,{"$f":"IF(G23=1,agSLO,agSLO*SsSt)","v":3.9600000000000003E-2},null,null,null,null,{"$f":"IF(E22>=0.25,1/'All.A DM.65'!$D$41,IF(E22>=0.15,1/'All.A DM.65'!$D$42,IF(E22>=0.05,1/'All.A DM.65'!$D$43,1/'All.A DM.65'!$D$44)))","v":2.9411764705882351}]
[null,null,"SLD",75,4.1000000000000002E-2,{"$f":"IF(G23=1,agSLD,agSLD*SsSt)","v":4.9200000000000001E-2},2,null,null,null,{"$f":"IF(E23>=0.25,1/'All.A DM.65'!$D$41,IF(E23>=0.15,1/'All.A DM.65'!$D$42,IF(E23>=0.05,1/'All.A DM.65'!$D$43,1/'All.A DM.65'!$D$44)))","v":2.9411764705882351}]
[null,null,"SLV",712,9.1999999999999998E-2,{"$f":"IF(G23=1,agSLV,agSLV*SsSt)","v":0.1104},null,null,null,null,{"$f":"IF(E24>=0.25,1/'All.A DM.65'!$D$41,IF(E24>=0.15,1/'All.A DM.65'!$D$42,IF(E24>=0.05,1/'All.A DM.65'!$D$43,1/'All.A DM.65'!$D$44)))","v":2.808988764044944}]
[null,null,"SLC",1462,0.114,{"$f":"IF(G23=1,agSLC,agSLC*SsSt)","v":0.1368},null,null,null,null,{"$f":"IF(E25>=0.25,1/'All.A DM.65'!$D$41,IF(E25>=0.15,1/'All.A DM.65'!$D$42,IF(E25>=0.05,1/'All.A DM.65'!$D$43,1/'All.A DM.65'!$D$44)))","v":2.808988764044944}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specificare il tipo di analisi eseguita e calcolare gli indici di rischio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"compilando i relativi fogli di calcolo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analisi Lineare"]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,"Analisi non Lineare - PushOver"]
[null,null,null,null,"Indice di Rischio Sismico",null,"PAM",null,"IS-V"]
[null,null,"Stato di Fatto",null,{"$f":"IF(C30=1,'Analisi Lineare-Stato di Fatto'!G36,'PushOver - Stato di Fatto'!G36)","v":"A"},null,{"$f":"IF(C30=1,'Analisi Lineare-Stato di Fatto'!I25,'PushOver - Stato di Fatto'!I25)","v":8.7291920923059582E-3},{"$f":"IF(C30=1,'Analisi Lineare-Stato di Fatto'!D28,'PushOver - Stato di Fatto'!D28)","v":"A"},{"$f":"IF(C30=1,'Analisi Lineare-Stato di Fatto'!I26,'PushOver - Stato di Fatto'!I26)","v":1},{"$f":"IF(C30=1,'Analisi Lineare-Stato di Fatto'!H28,'PushOver - Stato di Fatto'!H28)","v":"A+"},null,null,null,null,null,"Nei due Fogli di Calcolo, Specificare Valori Accelerazione al Suolo"]
[null,null,"Stato di Progetto",null,{"$f":"IF(C30=1,'Analisi Lineare-Stato Progetto'!G36,'PushOver - Stato di Progetto'!G36)","v":"A"},null,{"$f":"IF(C30=1,'Analisi Lineare-Stato Progetto'!I25,'PushOver - Stato di Progetto'!I25)","v":7.2399110486891403E-3},{"$f":"IF(C30=1,'Analisi Lineare-Stato Progetto'!D28,'PushOver - Stato di Progetto'!D28)","v":"A"},{"$f":"IF(C30=1,'Analisi Lineare-Stato Progetto'!I26,'PushOver - Stato di Progetto'!I26)","v":1},{"$f":"IF($C$30=1,'Analisi Lineare-Stato Progetto'!H28,'PushOver - Stato di Progetto'!H28)","v":"A+"},null,null,null,null,null,"per cui la struttura raggiunge lo stato limite PGA(SL)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In via semplificata, è possibile effettuare le verifiche limitatamente allo SLV (stato limite per la salvaguardia della vita) ed allo SLD (stato limite di danno)."]
[]
[]
[null,null,null,null,{"$f":"IF($F$41=\"A+\",\"<<\",\"\")","v":""},"Stato di Fatto"]
[null,null,null,null,{"$f":"IF($F$41=\"A\",\"<<\",\"\")","v":"<<"},"CLASSE"]
[null,null,null,null,{"$f":"IF($F$41=\"B\",\"<<\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($F$41=\"C\",\"<<\",\"\")","v":""},"DI RISCHIO SISMICO"]
[null,null,null,null,{"$f":"IF($F$41=\"D\",\"<<\",\"\")","v":""},{"$f":"E32","v":"A"}]
[null,null,null,null,{"$f":"IF($F$41=\"E\",\"<<\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($F$41=\"F\",\"<<\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($F$41=\"G\",\"<<\",\"\")","v":""}]
[]
[null,null,null,null,{"$f":"IF($F$50=\"A+\",\"<<\",\"\")","v":""},"Stato di Progetto"]
[null,null,null,null,{"$f":"IF($F$50=\"A\",\"<<\",\"\")","v":"<<"},"CLASSE"]
[null,null,null,null,{"$f":"IF($F$50=\"B\",\"<<\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($F$50=\"C\",\"<<\",\"\")","v":""},"DI RISCHIO SISMICO"]
[null,null,null,null,{"$f":"IF($F$50=\"D\",\"<<\",\"\")","v":""},{"$f":"E33","v":"A"}]
[null,null,null,null,{"$f":"IF($F$50=\"E\",\"<<\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($F$50=\"F\",\"<<\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($F$50=\"G\",\"<<\",\"\")","v":""}]

{"sheet":"Analisi Lineare-Stato di Fatto","index":1,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,5,16,6],[16,7,16,8],[17,5,17,6],[17,7,17,8],[18,5,18,6],[18,7,18,8],[35,6,38,8],[19,5,19,6],[19,7,19,8],[20,5,20,6],[20,7,20,8],[21,5,21,6],[21,7,21,8],[22,5,22,6],[22,7,22,8],[31,6,31,8],[32,6,33,8],[34,6,34,8]]}
[]
[null,"ANALISI STRUTTURA - STATO DI FATTO"]
[]
[null,"ACCELERAZIONI AL SUOLO DI CAPACITA'"]
[null,"PGAC(SLO)",3.9600000000000003E-2]
[null,"PGAC(SLD)",4.9200000000000001E-2]
[null,"PGAC(SLV)",0.1104]
[null,"PGAC(SLC)",0.1368]
[]
[null,"PERIODI DI RITORNO  TrC=TrD(PGAC/PGAD)h",null,null,null,"FREQUENZA MEDIA ANNUA DI SUPERAMENTO"]
[null,"TrC (SLO)",{"$f":"IF(M11>$M$13,$M$13,M11)","v":45},null,null,null,"l(SLO)",{"$f":"IF(C11<>0,1/C11,IF($H$13<>0,1.67*$H$13,0))","v":2.2222222222222223E-2},null,null,null,null,{"$f":"ROUND('Dati Edificio'!D22*(C5/'Dati Edificio'!F22)^'Dati Edificio'!K22,0)","v":45}]
[null,"TrC (SLD)",{"$f":"IF(M12>$M$13,$M$13,M12)","v":75},null,null,null,"l(SLD)",{"$f":"IF(C12<>0,1/C12,0)","v":1.3333333333333334E-2},null,null,null,null,{"$f":"ROUND('Dati Edificio'!D23*(C6/'Dati Edificio'!F23)^'Dati Edificio'!K23,0)","v":75}]
[null,"TrC (SLV)",{"$f":"M13","v":712},null,null,null,"l(SLV)",{"$f":"IF(C13<>0,1/C13,0)","v":1.4044943820224719E-3},null,null,null,null,{"$f":"ROUND('Dati Edificio'!D24*(C7/'Dati Edificio'!F24)^'Dati Edificio'!K24,0)","v":712}]
[null,"TrC (SLC)",{"$f":"M14","v":1462},null,null,null,"l(SLC)",{"$f":"IF(C14<>0,1/C14,IF($H$13<>0,0.49*$H$13,0))","v":6.8399452804377564E-4},null,null,null,null,{"$f":"ROUND('Dati Edificio'!D25*(C8/'Dati Edificio'!F25)^'Dati Edificio'!K24,0)","v":1462}]
[]
[null,"PERCENTUALE COSTO DI RICOSTRUZIONE"]
[null,"STATO LIMITE","Trc","l","CR %","l(SLi-1)-l(SLi)",null," [CR(SLi-1)+CR(SLi)]/2"]
[null,"SLID",10,0.1,{"$f":"'All.A DM.65'!G34","v":0}]
[null,"SLO",{"$f":"C11","v":45},{"$f":"H11","v":2.2222222222222223E-2},{"$f":"'All.A DM.65'!$G$33","v":7.0000000000000007E-2},{"$f":"D18-D19","v":7.7777777777777779E-2},null,{"$f":"(E18+E19)/2","v":3.5000000000000003E-2}]
[null,"SLD",{"$f":"C12","v":75},{"$f":"H12","v":1.3333333333333334E-2},{"$f":"'All.A DM.65'!$G$32","v":0.15},{"$f":"D19-D20","v":8.8888888888888889E-3},null,{"$f":"(E19+E20)/2","v":0.11}]
[null,"SLV",{"$f":"C13","v":712},{"$f":"H13","v":1.4044943820224719E-3},{"$f":"'All.A DM.65'!$G$31","v":0.5},1.1928838951310862E-2,null,0.32500000000000001]
[null,"SLC",{"$f":"C14","v":1462},{"$f":"H14","v":6.8399452804377564E-4},{"$f":"'All.A DM.65'!$G$30","v":0.8},{"$f":"D21-D22","v":7.2049985397869623E-4},null,0.65]
[null,"SLR",{"$f":"C14","v":1462},0,{"$f":"'All.A DM.65'!$G$29","v":1}]
[]
[null,"PAM =","S5i=2[l(SLi-1)-l(SLi)]*[CR(SLi-1)+CR(SLi)]/2+l(SLC)*CR(SLR) =",null,null,null,null,null,{"$f":"F19*H19+F20*H20+F21*H21+F22*H22+D22*E23","v":8.7291920923059582E-3}]
[null,"IS-V =","PGAC(SLV)/PGAD(SLV) =",null,null,null,null,null,{"$f":"C7/'Dati Edificio'!$F$24","v":1}]
[]
[null,null,"CLASSE PAM ",{"$f":"IF(MID(M28,2,1)=\"+\",MID(M28,1,2),MID(M28,1,1))","v":"A"},"PAM",null,"CLASSE IS-V",{"$f":"IF(MID(M29,2,1)=\"+\",MID(M29,1,2),MID(M29,1,1))","v":"A+"},"IS-V",null,null,null,{"$f":"IF(I25<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(I25<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(I25<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(I25<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(I25<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(I25<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(I25<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"APAM"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I26>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(I26>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(I26>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(I26>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(I26>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(I26>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"A+IS-V"}]
[]
[]
[null,null,null,null,null,{"$f":"IF($G$36=\"A+\",\"<<\",\"\")","v":""},"Stato di Fatto"]
[null,null,null,null,null,{"$f":"IF($G$36=\"A\",\"<<\",\"\")","v":"<<"},"CLASSE"]
[null,null,null,null,null,{"$f":"IF($G$36=\"B\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"C\",\"<<\",\"\")","v":""},"DI RISCHIO SISMICO"]
[null,null,null,null,null,{"$f":"IF($G$36=\"D\",\"<<\",\"\")","v":""},{"$f":"IF(CODE(D28)=CODE(H28),IF(MID(D28,2,1)=\"+\",H28,D28),IF(CODE(D28)<CODE(H28),H28,D28))","v":"A"},null,null,{"$f":"IF(G36<>D28,IF(G36<>H28,\"SPECIFICARE CORRETTAMENTE CLASSE\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"E\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"F\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"G\",\"<<\",\"\")","v":""}]

{"sheet":"Analisi Lineare-Stato Progetto","index":2,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,5,16,6],[16,7,16,8],[17,5,17,6],[17,7,17,8],[18,5,18,6],[18,7,18,8],[35,6,38,8],[19,5,19,6],[19,7,19,8],[20,5,20,6],[20,7,20,8],[21,5,21,6],[21,7,21,8],[22,5,22,6],[22,7,22,8],[31,6,31,8],[32,6,33,8],[34,6,34,8]]}
[]
[null,"ANALISI STRUTTURA - STATO DI PROGETTO"]
[]
[null,"ACCELERAZIONI AL SUOLO DI CAPACITA'"]
[null,"PGAC(SLO)"]
[null,"PGAC(SLD)",4.9200000000000001E-2]
[null,"PGAC(SLV)",0.1104]
[null,"PGAC(SLC)"]
[]
[null,"PERIODI DI RITORNO  TrC=TrD(PGAC/PGAD)h",null,null,null,"FREQUENZA MEDIA ANNUA DI SUPERAMENTO"]
[null,"TrC (SLO)",{"$f":"IF(M11>$M$13,$M$13,M11)","v":0},null,null,null,"l(SLO)",{"$f":"IF(C11<>0,1/C11,IF($H$13<>0,1.67*$H$13,0))","v":2.345505617977528E-3},null,null,null,null,{"$f":"ROUND('Dati Edificio'!D22*(C5/'Dati Edificio'!F22)^'Dati Edificio'!K22,0)","v":0}]
[null,"TrC (SLD)",{"$f":"IF(M12>$M$13,$M$13,M12)","v":75},null,null,null,"l(SLD)",{"$f":"IF(C12<>0,1/C12,0)","v":1.3333333333333334E-2},null,null,null,null,{"$f":"ROUND('Dati Edificio'!D23*(C6/'Dati Edificio'!F23)^'Dati Edificio'!K23,0)","v":75}]
[null,"TrC (SLV)",{"$f":"M13","v":712},null,null,null,"l(SLV)",{"$f":"IF(C13<>0,1/C13,0)","v":1.4044943820224719E-3},null,null,null,null,{"$f":"ROUND('Dati Edificio'!D24*(C7/'Dati Edificio'!F24)^'Dati Edificio'!K24,0)","v":712}]
[null,"TrC (SLC)",{"$f":"M14","v":0},null,null,null,"l(SLC)",{"$f":"IF(C14<>0,1/C14,IF($H$13<>0,0.49*$H$13,0))","v":6.8820224719101121E-4},null,null,null,null,{"$f":"ROUND('Dati Edificio'!D25*(C8/'Dati Edificio'!F25)^'Dati Edificio'!K24,0)","v":0}]
[]
[null,"PERCENTUALE COSTO DI RICOSTRUZIONE"]
[null,"STATO LIMITE","Trc","l","CR %","l(SLi-1)-l(SLi)",null," [CR(SLi-1)+CR(SLi)]/2"]
[null,"SLID",10,0.1,{"$f":"'All.A DM.65'!G34","v":0}]
[null,"SLO",{"$f":"C11","v":0},{"$f":"H11","v":2.345505617977528E-3},{"$f":"'All.A DM.65'!$G$33","v":7.0000000000000007E-2},{"$f":"D18-D19","v":9.7654494382022478E-2},null,{"$f":"(E18+E19)/2","v":3.5000000000000003E-2}]
[null,"SLD",{"$f":"C12","v":75},{"$f":"H12","v":1.3333333333333334E-2},{"$f":"'All.A DM.65'!$G$32","v":0.15},{"$f":"D19-D20","v":-1.0987827715355806E-2},null,{"$f":"(E19+E20)/2","v":0.11}]
[null,"SLV",{"$f":"C13","v":712},{"$f":"H13","v":1.4044943820224719E-3},{"$f":"'All.A DM.65'!$G$31","v":0.5},1.1928838951310862E-2,null,0.32500000000000001]
[null,"SLC",{"$f":"C14","v":0},{"$f":"H14","v":6.8820224719101121E-4},{"$f":"'All.A DM.65'!$G$30","v":0.8},{"$f":"D21-D22","v":7.1629213483146066E-4},null,0.65]
[null,"SLR",{"$f":"C14","v":0},0,{"$f":"'All.A DM.65'!$G$29","v":1}]
[]
[null,"PAM =","S5i=2[l(SLi-1)-l(SLi)]*[CR(SLi-1)+CR(SLi)]/2+l(SLC)*CR(SLR) =",null,null,null,null,null,{"$f":"F19*H19+F20*H20+F21*H21+F22*H22+D22*E23","v":7.2399110486891403E-3}]
[null,"IS-V =","PGAC(SLV)/PGAD(SLV) =",null,null,null,null,null,{"$f":"C7/'Dati Edificio'!$F$24","v":1}]
[]
[null,null,"CLASSE PAM ",{"$f":"IF(MID(M28,2,1)=\"+\",MID(M28,1,2),MID(M28,1,1))","v":"A"},"PAM",null,"CLASSE IS-V",{"$f":"IF(MID(M29,2,1)=\"+\",MID(M29,1,2),MID(M29,1,1))","v":"A+"},"IS-V",null,null,null,{"$f":"IF(I25<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(I25<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(I25<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(I25<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(I25<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(I25<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(I25<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"APAM"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I26>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(I26>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(I26>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(I26>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(I26>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(I26>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"A+IS-V"}]
[]
[]
[null,null,null,null,null,{"$f":"IF($G$36=\"A+\",\"<<\",\"\")","v":""},"Stato di Progetto"]
[null,null,null,null,null,{"$f":"IF($G$36=\"A\",\"<<\",\"\")","v":"<<"},"CLASSE"]
[null,null,null,null,null,{"$f":"IF($G$36=\"B\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"C\",\"<<\",\"\")","v":""},"DI RISCHIO SISMICO"]
[null,null,null,null,null,{"$f":"IF($G$36=\"D\",\"<<\",\"\")","v":""},{"$f":"IF(CODE(D28)=CODE(H28),IF(MID(D28,2,1)=\"+\",H28,D28),IF(CODE(D28)<CODE(H28),H28,D28))","v":"A"},null,null,{"$f":"IF(G36<>D28,IF(G36<>H28,\"SPECIFICARE CORRETTAMENTE CLASSE\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"E\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"F\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"G\",\"<<\",\"\")","v":""}]

{"sheet":"PushOver - Stato di Fatto","index":3,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":true,"merged":[[32,6,33,8],[34,6,34,8],[35,6,38,8],[31,6,31,8],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[17,5,17,6],[18,5,18,6],[17,7,17,8],[16,7,16,8],[16,5,16,6],[18,7,18,8]]}
[]
[null,"ANALISI STRUTTURA - STATO DI FATTO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N. PUSH-OVER ","Angolo Sisma","PGA(SLO)","PGA(SLD)","PGA(SLV)",null,null,"PAM","CLASSE PAM","IS-V","CLASSE IS-V"]
[null,"ACCELERAZIONI AL SUOLO DI CAPACITA'",null,null,null,null,null,null,null,null,null,null,null,"1 - DISTRIB. FORZE SECONDO DEFORMATA MODALE +Ecc5%",0,0.03,0.04,0.13,{"$f":"IF(W4=$W$20,\"X\",\"\")","v":"X"},1,9.822954617114266E-3,{"$f":"IF(U4<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U4<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U4<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U4<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U4<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U4<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U4<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"APAM"},1.1775362318840581,{"$f":"IF(W4>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W4>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W4>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W4>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W4>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W4>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"A+IS-V"},10.869565217391305]
[null,"PGAC(SLO)",3.9600000000000003E-2,null,null,null,null,null,null,null,null,null,null,"2 - DISTRIB. FORZE SECONDO DEFORMATA MODALE +Ecc5%",180,null,null,null,{"$f":"IF(W5=$W$20,\"X\",\"\")","v":""},2,null,{"$f":"IF(U5<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U5<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U5<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U5<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U5<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U5<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U5<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W5>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W5>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W5>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W5>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W5>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W5>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PGAC(SLD)",4.9200000000000001E-2,null,null,null,null,null,null,null,null,null,null,"3 - DISTRIB. FORZE SECONDO DEFORMATA MODALE +Ecc5%",90,null,null,null,{"$f":"IF(W6=$W$20,\"X\",\"\")","v":""},3,null,{"$f":"IF(U6<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U6<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U6<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U6<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U6<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U6<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U6<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W6>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W6>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W6>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W6>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W6>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W6>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PGAC(SLV)",0.1104,null,null,null,null,null,null,null,null,null,null,"4 - DISTRIB. FORZE SECONDO DEFORMATA MODALE +Ecc5%",270,null,null,null,"",4,null,{"$f":"IF(U7<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U7<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U7<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U7<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U7<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U7<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U7<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W7>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W7>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W7>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W7>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W7>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W7>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PGAC(SLC)",0.1368,null,null,null,null,null,null,null,null,null,null,"5 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE +Ecc5%",0,null,null,null,"",5,null,{"$f":"IF(U8<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U8<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U8<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U8<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U8<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U8<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U8<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W8>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W8>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W8>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W8>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W8>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W8>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE +Ecc5%",180,null,null,null,"",6,null,{"$f":"IF(U9<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U9<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U9<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U9<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U9<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U9<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U9<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W9>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W9>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W9>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W9>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W9>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W9>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PERIODI DI RITORNO  TrC=TrD(PGAC/PGAD)h",null,null,null,"FREQUENZA MEDIA ANNUA DI SUPERAMENTO",null,null,null,null,null,null,null,"7 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE +Ecc5%",90,null,null,null,"",7,null,{"$f":"IF(U10<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U10<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U10<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U10<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U10<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U10<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U10<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W10>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W10>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W10>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W10>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W10>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W10>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"TrC (SLO)",{"$f":"IF(L11>$L$13,$L$13,L11)","v":45},null,null,null,"l(SLO)",{"$f":"IF(C11<>0,1/C11,IF($H$13<>0,1.67*$H$13,0))","v":2.2222222222222223E-2},null,null,null,{"$f":"ROUND('Dati Edificio'!D22*(C5/'Dati Edificio'!F22)^'Dati Edificio'!K22,0)","v":45},null,"8 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE +Ecc5%",270,null,null,null,"",8,null,{"$f":"IF(U11<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U11<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U11<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U11<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U11<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U11<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U11<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W11>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W11>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W11>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W11>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W11>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W11>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"TrC (SLD)",{"$f":"IF(L12>$L$13,$L$13,L12)","v":75},null,null,null,"l(SLD)",{"$f":"IF(C12<>0,1/C12,0)","v":1.3333333333333334E-2},null,null,null,{"$f":"ROUND('Dati Edificio'!D23*(C6/'Dati Edificio'!F23)^'Dati Edificio'!K23,0)","v":75},null,"9 - DISTRIB. FORZE SECONDO DEFORMATA MODALE -Ecc5%",0,null,null,null,"",9,null,{"$f":"IF(U12<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U12<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U12<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U12<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U12<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U12<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U12<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W12>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W12>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W12>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W12>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W12>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W12>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"TrC (SLV)",{"$f":"L13","v":712},null,null,null,"l(SLV)",{"$f":"IF(C13<>0,1/C13,0)","v":1.4044943820224719E-3},null,null,null,{"$f":"ROUND('Dati Edificio'!D24*(C7/'Dati Edificio'!F24)^'Dati Edificio'!K24,0)","v":712},null,"10 - DISTRIB. FORZE SECONDO DEFORMATA MODALE -Ecc5%",180,null,null,null,"",10,null,{"$f":"IF(U13<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U13<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U13<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U13<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U13<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U13<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U13<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W13>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W13>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W13>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W13>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W13>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W13>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"TrC (SLC)",{"$f":"L14","v":1462},null,null,null,"l(SLC)",{"$f":"IF(C14<>0,1/C14,IF($H$13<>0,0.49*$H$13,0))","v":6.8399452804377564E-4},null,null,null,{"$f":"ROUND('Dati Edificio'!D25*(C8/'Dati Edificio'!F25)^'Dati Edificio'!K25,0)","v":1462},null,"11 - DISTRIB. FORZE SECONDO DEFORMATA MODALE -Ecc5%",90,null,null,null,"",11,null,{"$f":"IF(U14<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U14<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U14<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U14<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U14<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U14<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U14<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W14>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W14>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W14>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W14>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W14>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W14>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"12 - DISTRIB. FORZE SECONDO DEFORMATA MODALE -Ecc5%",270,null,null,null,"",12,null,{"$f":"IF(U15<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U15<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U15<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U15<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U15<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U15<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U15<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W15>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W15>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W15>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W15>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W15>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W15>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PERCENTUALE COSTO DI RICOSTRUZIONE",null,null,null,null,null,null,null,null,null,null,null,"13 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE -Ecc5%",0,null,null,null,"",13,null,{"$f":"IF(U16<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U16<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U16<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U16<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U16<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U16<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U16<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W16>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W16>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W16>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W16>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W16>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W16>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"STATO LIMITE","Trc","l","CR %","l(SLi-1)-l(SLi)",null," [CR(SLi-1)+CR(SLi)]/2",null,null,null,null,null,"14 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE -Ecc5%",180,null,null,null,"",14,null,{"$f":"IF(U17<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U17<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U17<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U17<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U17<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U17<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U17<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W17>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W17>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W17>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W17>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W17>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W17>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"SLID",10,0.1,{"$f":"'All.A DM.65'!G34","v":0},null,null,null,null,null,null,null,null,"15 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE -Ecc5%",90,null,null,null,"",15,null,{"$f":"IF(U18<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U18<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U18<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U18<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U18<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U18<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U18<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W18>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W18>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W18>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W18>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W18>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W18>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"SLO",{"$f":"C11","v":45},{"$f":"H11","v":2.2222222222222223E-2},{"$f":"'All.A DM.65'!$G$33","v":7.0000000000000007E-2},{"$f":"D18-D19","v":7.7777777777777779E-2},null,{"$f":"(E18+E19)/2","v":3.5000000000000003E-2},null,null,null,null,null,"16 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE -Ecc5%",270,null,null,null,"",16,null,{"$f":"IF(U19<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U19<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U19<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U19<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U19<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U19<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U19<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W19>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W19>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W19>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W19>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W19>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W19>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"SLD",{"$f":"C12","v":75},{"$f":"H12","v":1.3333333333333334E-2},{"$f":"'All.A DM.65'!$G$32","v":0.15},{"$f":"D19-D20","v":8.8888888888888889E-3},null,{"$f":"(E19+E20)/2","v":0.11},null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"_xlfn.XLOOKUP(W20,W4:W19,U4:U19,0)","v":9.822954617114266E-3},{"$f":"IF(U20<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U20<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U20<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U20<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U20<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U20<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U20<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"APAM"},{"$f":"MIN(W4:W19)","v":1.1775362318840581},{"$f":"IF(W20>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W20>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W20>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W20>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W20>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W20>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"A+IS-V"},"MIN IS-V"]
[null,"SLV",{"$f":"C13","v":712},{"$f":"H13","v":1.4044943820224719E-3},{"$f":"'All.A DM.65'!$G$31","v":0.5},1.1928838951310862E-2,null,0.32500000000000001,null,null,null,null,null,null,"MIN.",{"$f":"MIN(P4:P19)","v":0.03},{"$f":"MIN(Q4:Q19)","v":0.04},{"$f":"MIN(R4:R19)","v":0.13}]
[null,"SLC",{"$f":"C14","v":1462},{"$f":"H14","v":6.8399452804377564E-4},{"$f":"'All.A DM.65'!$G$30","v":0.8},{"$f":"D21-D22","v":7.2049985397869623E-4},null,0.65]
[null,"SLR",{"$f":"C14","v":1462},0,{"$f":"'All.A DM.65'!$G$29","v":1}]
[]
[null,"PAM =","S5i=2[l(SLi-1)-l(SLi)]*[CR(SLi-1)+CR(SLi)]/2+l(SLC)*CR(SLR) =",null,null,null,null,null,{"$f":"F19*H19+F20*H20+F21*H21+F22*H22+D22*E23","v":8.7291920923059582E-3}]
[null,"IS-V =","PGAC(SLV)/PGAD(SLV) =",null,null,null,null,null,{"$f":"C7/'Dati Edificio'!$F$24","v":1}]
[]
[null,null,"CLASSE PAM ",{"$f":"IF(MID(L28,2,1)=\"+\",MID(L28,1,2),MID(L28,1,1))","v":"A"},"PAM",null,"CLASSE IS-V",{"$f":"IF(MID(L29,2,1)=\"+\",MID(L29,1,2),MID(L29,1,1))","v":"A+"},"IS-V",null,null,{"$f":"IF(I25<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(I25<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(I25<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(I25<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(I25<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(I25<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(I25<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"APAM"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I26>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(I26>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(I26>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(I26>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(I26>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(I26>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"A+IS-V"}]
[]
[]
[null,null,null,null,null,{"$f":"IF($G$36=\"A+\",\"<<\",\"\")","v":""},"Stato di Fatto"]
[null,null,null,null,null,{"$f":"IF($G$36=\"A\",\"<<\",\"\")","v":"<<"},"CLASSE"]
[null,null,null,null,null,{"$f":"IF($G$36=\"B\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"C\",\"<<\",\"\")","v":""},"DI RISCHIO SISMICO"]
[null,null,null,null,null,{"$f":"IF($G$36=\"D\",\"<<\",\"\")","v":""},{"$f":"IF(CODE(D28)=CODE(H28),IF(MID(D28,2,1)=\"+\",H28,D28),IF(CODE(D28)<CODE(H28),H28,D28))","v":"A"},null,null,{"$f":"IF(G36<>D28,IF(G36<>H28,\"SPECIFICARE CORRETTAMENTE CLASSE\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"E\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"F\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"G\",\"<<\",\"\")","v":""}]

{"sheet":"PushOver - Stato di Progetto","index":4,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":true,"merged":[[18,5,18,6],[18,7,18,8],[16,5,16,6],[16,7,16,8],[17,5,17,6],[17,7,17,8],[35,6,38,8],[19,5,19,6],[19,7,19,8],[20,5,20,6],[20,7,20,8],[21,5,21,6],[21,7,21,8],[22,5,22,6],[22,7,22,8],[31,6,31,8],[32,6,33,8],[34,6,34,8]]}
[]
[null,"ANALISI STRUTTURA - STATO DI PROGETTO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N. PUSH-OVER ","Angolo Sisma","PGA(SLO)","PGA(SLD)","PGA(SLV)",null,null,"PAM","CLASSE PAM","IS-V","CLASSE IS-V"]
[null,"ACCELERAZIONI AL SUOLO DI CAPACITA'",null,null,null,null,null,null,null,null,null,null,null,"1 - DISTRIB. FORZE SECONDO DEFORMATA MODALE +Ecc5%",0,{"$f":"0.047","v":4.7E-2},{"$f":"0.058","v":5.8000000000000003E-2},0.15,{"$f":"IF(W4=$W$20,\"X\",\"\")","v":"X"},1,6.5861497602707547E-3,{"$f":"IF(U4<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U4<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U4<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U4<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U4<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U4<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U4<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"APAM"},1.3586956521739131,{"$f":"IF(W4>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W4>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W4>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W4>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W4>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W4>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"A+IS-V"}]
[null,"PGAC(SLO)",4.7E-2,null,null,null,null,null,null,null,null,null,null,"2 - DISTRIB. FORZE SECONDO DEFORMATA MODALE +Ecc5%",180,null,null,null,{"$f":"IF(W5=$W$20,\"X\",\"\")","v":""},2,null,{"$f":"IF(U5<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U5<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U5<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U5<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U5<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U5<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U5<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W5>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W5>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W5>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W5>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W5>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W5>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PGAC(SLD)",5.8000000000000003E-2,null,null,null,null,null,null,null,null,null,null,"3 - DISTRIB. FORZE SECONDO DEFORMATA MODALE +Ecc5%",90,null,null,null,{"$f":"IF(W6=$W$20,\"X\",\"\")","v":""},3,null,{"$f":"IF(U6<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U6<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U6<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U6<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U6<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U6<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U6<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W6>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W6>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W6>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W6>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W6>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W6>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PGAC(SLV)",0.15,null,null,null,null,null,null,null,null,null,null,"4 - DISTRIB. FORZE SECONDO DEFORMATA MODALE +Ecc5%",270,null,null,null,"",4,null,{"$f":"IF(U7<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U7<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U7<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U7<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U7<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U7<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U7<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W7>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W7>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W7>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W7>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W7>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W7>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PGAC(SLC)",null,null,null,null,null,null,null,null,null,null,null,"5 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE +Ecc5%",0,null,null,null,"",5,null,{"$f":"IF(U8<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U8<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U8<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U8<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U8<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U8<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U8<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W8>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W8>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W8>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W8>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W8>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W8>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE +Ecc5%",180,null,null,null,"",6,null,{"$f":"IF(U9<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U9<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U9<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U9<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U9<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U9<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U9<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W9>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W9>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W9>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W9>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W9>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W9>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PERIODI DI RITORNO  TrC=TrD(PGAC/PGAD)h",null,null,null,"FREQUENZA MEDIA ANNUA DI SUPERAMENTO",null,null,null,null,null,null,null,"7 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE +Ecc5%",90,null,null,null,"",7,null,{"$f":"IF(U10<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U10<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U10<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U10<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U10<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U10<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U10<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W10>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W10>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W10>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W10>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W10>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W10>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"TrC (SLO)",{"$f":"IF(L11>$L$13,$L$13,L11)","v":74},null,null,null,"l(SLO)",{"$f":"IF(C11<>0,1/C11,IF($H$13<>0,1.67*$H$13,0))","v":1.3513513513513514E-2},null,null,null,{"$f":"ROUND('Dati Edificio'!D22*(C5/'Dati Edificio'!F22)^'Dati Edificio'!K22,0)","v":74},null,"8 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE +Ecc5%",270,null,null,null,"",8,null,{"$f":"IF(U11<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U11<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U11<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U11<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U11<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U11<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U11<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W11>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W11>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W11>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W11>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W11>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W11>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"TrC (SLD)",{"$f":"IF(L12>$L$13,$L$13,L12)","v":122},null,null,null,"l(SLD)",{"$f":"IF(C12<>0,1/C12,0)","v":8.1967213114754103E-3},null,null,null,{"$f":"ROUND('Dati Edificio'!D23*(C6/'Dati Edificio'!F23)^'Dati Edificio'!K23,0)","v":122},null,"9 - DISTRIB. FORZE SECONDO DEFORMATA MODALE -Ecc5%",0,null,null,null,"",9,null,{"$f":"IF(U12<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U12<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U12<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U12<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U12<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U12<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U12<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W12>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W12>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W12>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W12>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W12>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W12>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"TrC (SLV)",{"$f":"L13","v":1684},null,null,null,"l(SLV)",{"$f":"IF(C13<>0,1/C13,0)","v":5.9382422802850359E-4},null,null,null,{"$f":"ROUND('Dati Edificio'!D24*(C7/'Dati Edificio'!F24)^'Dati Edificio'!K24,0)","v":1684},null,"10 - DISTRIB. FORZE SECONDO DEFORMATA MODALE -Ecc5%",180,null,null,null,"",10,null,{"$f":"IF(U13<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U13<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U13<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U13<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U13<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U13<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U13<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W13>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W13>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W13>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W13>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W13>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W13>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"TrC (SLC)",{"$f":"L14","v":0},null,null,null,"l(SLC)",{"$f":"IF(C14<>0,1/C14,IF($H$13<>0,0.49*$H$13,0))","v":2.9097387173396673E-4},null,null,null,{"$f":"ROUND('Dati Edificio'!D25*(C8/'Dati Edificio'!F25)^'Dati Edificio'!K25,0)","v":0},null,"11 - DISTRIB. FORZE SECONDO DEFORMATA MODALE -Ecc5%",90,null,null,null,"",11,null,{"$f":"IF(U14<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U14<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U14<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U14<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U14<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U14<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U14<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W14>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W14>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W14>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W14>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W14>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W14>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"12 - DISTRIB. FORZE SECONDO DEFORMATA MODALE -Ecc5%",270,null,null,null,"",12,null,{"$f":"IF(U15<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U15<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U15<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U15<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U15<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U15<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U15<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W15>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W15>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W15>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W15>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W15>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W15>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"PERCENTUALE COSTO DI RICOSTRUZIONE",null,null,null,null,null,null,null,null,null,null,null,"13 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE -Ecc5%",0,null,null,null,"",13,null,{"$f":"IF(U16<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U16<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U16<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U16<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U16<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U16<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U16<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W16>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W16>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W16>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W16>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W16>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W16>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"STATO LIMITE","Trc","l","CR %","l(SLi-1)-l(SLi)",null," [CR(SLi-1)+CR(SLi)]/2",null,null,null,null,null,"14 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE -Ecc5%",180,null,null,null,"",14,null,{"$f":"IF(U17<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U17<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U17<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U17<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U17<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U17<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U17<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W17>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W17>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W17>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W17>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W17>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W17>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"SLID",10,0.1,{"$f":"'All.A DM.65'!G34","v":0},null,null,null,null,null,null,null,null,"15 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE -Ecc5%",90,null,null,null,"",15,null,{"$f":"IF(U18<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U18<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U18<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U18<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U18<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U18<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U18<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W18>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W18>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W18>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W18>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W18>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W18>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"SLO",{"$f":"C11","v":74},{"$f":"H11","v":1.3513513513513514E-2},{"$f":"'All.A DM.65'!$G$33","v":7.0000000000000007E-2},{"$f":"D18-D19","v":8.6486486486486491E-2},null,{"$f":"(E18+E19)/2","v":3.5000000000000003E-2},null,null,null,null,null,"16 - DISTRIB. FORZE PROPORZIONALE ALLE MASSE -Ecc5%",270,null,null,null,"",16,null,{"$f":"IF(U19<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U19<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U19<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U19<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U19<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U19<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U19<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"A+PAM"},null,{"$f":"IF(W19>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W19>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W19>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W19>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W19>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W19>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"FIS-V"}]
[null,"SLD",{"$f":"C12","v":122},{"$f":"H12","v":8.1967213114754103E-3},{"$f":"'All.A DM.65'!$G$32","v":0.15},{"$f":"D19-D20","v":5.316792202038104E-3},null,{"$f":"(E19+E20)/2","v":0.11},null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"_xlfn.XLOOKUP(W20,W4:W19,U4:U19,0)","v":6.5861497602707547E-3},{"$f":"IF(U20<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(U20<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(U20<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(U20<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(U20<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(U20<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(U20<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"APAM"},{"$f":"MIN(W4:W19)","v":1.3586956521739131},{"$f":"IF(W20>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(W20>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(W20>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(W20>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(W20>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(W20>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"A+IS-V"},"MIN IS-V"]
[null,"SLV",{"$f":"C13","v":1684},{"$f":"H13","v":5.9382422802850359E-4},{"$f":"'All.A DM.65'!$G$31","v":0.5},7.6028970834469065E-3,null,0.32500000000000001,null,null,null,null,null,null,"MIN.",{"$f":"MIN(P4:P19)","v":4.7E-2},{"$f":"MIN(Q4:Q19)","v":5.8000000000000003E-2},{"$f":"MIN(R4:R19)","v":0.15}]
[null,"SLC",{"$f":"C14","v":0},{"$f":"H14","v":2.9097387173396673E-4},{"$f":"'All.A DM.65'!$G$30","v":0.8},{"$f":"D21-D22","v":3.0285035629453686E-4},null,0.65]
[null,"SLR",{"$f":"C14","v":0},0,{"$f":"'All.A DM.65'!$G$29","v":1}]
[]
[null,"PAM =","S5i=2[l(SLi-1)-l(SLi)]*[CR(SLi-1)+CR(SLi)]/2+l(SLC)*CR(SLR) =",null,null,null,null,null,{"$f":"F19*H19+F20*H20+F21*H21+F22*H22+D22*E23","v":6.5706423246968803E-3}]
[null,"IS-V =","PGAC(SLV)/PGAD(SLV) =",null,null,null,null,null,{"$f":"C7/'Dati Edificio'!$F$24","v":1.3586956521739131}]
[]
[null,null,"CLASSE PAM ",{"$f":"IF(MID(L28,2,1)=\"+\",MID(L28,1,2),MID(L28,1,1))","v":"A"},"PAM",null,"CLASSE IS-V",{"$f":"IF(MID(L29,2,1)=\"+\",MID(L29,1,2),MID(L29,1,1))","v":"A+"},"IS-V",null,null,{"$f":"IF(I25<='All.A DM.65'!$F$5,'All.A DM.65'!$G$5,IF(I25<='All.A DM.65'!$F$6,'All.A DM.65'!$G$6,IF(I25<='All.A DM.65'!$F$7,'All.A DM.65'!$G$7,IF(I25<='All.A DM.65'!$F$8,'All.A DM.65'!$G$8,IF(I25<='All.A DM.65'!$F$9,'All.A DM.65'!$G$9,IF(I25<='All.A DM.65'!$F$10,'All.A DM.65'!$G$10,IF(I25<='All.A DM.65'!$F$11,'All.A DM.65'!$G$11,'All.A DM.65'!$G$12)))))))","v":"APAM"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I26>='All.A DM.65'!$B$17,'All.A DM.65'!$G$17,IF(I26>='All.A DM.65'!$B$18,'All.A DM.65'!$G$18,IF(I26>='All.A DM.65'!$B$19,'All.A DM.65'!$G$19,IF(I26>='All.A DM.65'!$B$20,'All.A DM.65'!$G$20,IF(I26>='All.A DM.65'!$B$21,'All.A DM.65'!$G$21,IF(I26>='All.A DM.65'!$B$22,'All.A DM.65'!$G$22,'All.A DM.65'!$G$23))))))","v":"A+IS-V"}]
[]
[]
[null,null,null,null,null,{"$f":"IF($G$36=\"A+\",\"<<\",\"\")","v":""},"Stato di Progetto"]
[null,null,null,null,null,{"$f":"IF($G$36=\"A\",\"<<\",\"\")","v":"<<"},"CLASSE"]
[null,null,null,null,null,{"$f":"IF($G$36=\"B\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"C\",\"<<\",\"\")","v":""},"DI RISCHIO SISMICO"]
[null,null,null,null,null,{"$f":"IF($G$36=\"D\",\"<<\",\"\")","v":""},{"$f":"IF(CODE(D28)=CODE(H28),IF(MID(D28,2,1)=\"+\",H28,D28),IF(CODE(D28)<CODE(H28),H28,D28))","v":"A"},null,null,{"$f":"IF(G36<>D28,IF(G36<>H28,\"SPECIFICARE CORRETTAMENTE CLASSE\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"E\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"F\",\"<<\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF($G$36=\"G\",\"<<\",\"\")","v":""}]

{"sheet":"All.A DM.65","index":5,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,1,2,6],[3,1,3,5],[14,1,14,6],[15,1,15,5],[26,5,26,6]]}
[]
[]
[null,"TABELLA 1"]
[null,"PAM",null,null,null,null,"Classe PAM"]
[null,null,null,null,"<=",5.0000000000000001E-3,"A+PAM"]
[null,5.0000000000000001E-3,"<",null,"<=",0.01,"APAM"]
[null,0.01,"<",null,"<=",1.4999999999999999E-2,"BPAM"]
[null,1.4999999999999999E-2,"<",null,"<=",2.5000000000000001E-2,"CPAM"]
[null,2.5000000000000001E-2,"<",null,"<=",3.5000000000000003E-2,"DPAM"]
[null,3.5000000000000003E-2,"<",null,"<=",4.4999999999999998E-2,"EPAM"]
[null,4.4999999999999998E-2,"<",null,"<=",7.4999999999999997E-2,"FPAM"]
[null,7.4999999999999997E-2,"<",null,null,null,"GPAM"]
[]
[]
[null,"TABELLA 2"]
[null,"IS",null,null,null,null,"Classe IS-V"]
[null,1,"<=",null,null,null,"A+IS-V"]
[null,0.8,"<=",null,"<",1,"AIS-V"]
[null,0.6,"<=",null,"<",0.8,"BIS-V"]
[null,0.45,"<=",null,"<",0.6,"CIS-V"]
[null,0.3,"<=",null,"<",0.45,"DIS-V"]
[null,0.15,"<=",null,"<",0.3,"EIS-V"]
[null,null,null,null,"<",0.15,"FIS-V"]
[]
[]
[]
[null,null,null,null,null,"TABELLA 3"]
[null,null,null,null,null,"Stato Limite","CR(%)"]
[null,null,null,null,null,"SLR",1]
[null,null,null,null,null,"SLC",0.8]
[null,null,null,null,null,"SLV",0.5]
[null,null,null,null,null,"SLD",0.15]
[null,null,null,null,null,"SLO",7.0000000000000007E-2]
[null,null,null,null,null,"SLID",0]
[]
[]
[]
[]
[]
[]
[null,"h=","1/",0.49,"per ag ≥ 0,25g",null,null,{"$f":"1/D41","v":2.0408163265306123}]
[null,"h=","1/",0.43,"per 0,25g ≥ ag ≥ 0,15 g",null,null,{"$f":"1/D42","v":2.3255813953488373}]
[null,"h=","1/",0.35599999999999998,"per 0,15g ≥ ag ≥ 0,05 g",null,null,2.808988764044944]
[null,"h=","1/",0.34,"per 0,05 g ≥ ag",null,null,2.9411764705882351]