{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Calcolo DM 140-12 + ORD. 108-20","Tabella-Z1"],"not_rendered":{"images":1,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Calcolo DM 140-12 + ORD. 108-20","index":0,"n_rows":131,"n_cols":45,"rows_kept":131,"merged":[[0,1,0,5],[0,6,0,19],[1,1,1,5],[1,6,1,19],[2,1,2,5],[2,6,2,19],[3,1,3,19],[5,1,5,19],[5,39,10,44],[6,2,6,5],[6,6,6,7],[6,8,6,13],[6,14,6,19],[7,2,7,5],[7,6,7,7],[7,8,7,13],[7,14,7,19],[8,2,8,5],[8,6,8,7],[8,8,8,13],[8,14,8,19],[9,2,9,5],[9,6,9,7],[9,8,9,13],[9,14,9,19],[10,2,10,5],[10,6,10,7],[10,8,10,13],[10,14,10,19],[11,2,11,5],[11,6,11,7],[11,8,11,13],[11,14,11,19],[12,2,12,5],[12,6,12,7],[12,8,12,13],[12,14,12,19],[13,2,13,5],[13,6,13,7],[13,8,13,13],[13,14,13,19],[14,2,14,5],[14,6,14,7],[14,8,14,13],[14,14,14,19],[14,44,17,47],[15,2,15,5],[15,6,15,7],[15,8,15,13],[15,14,15,19],[17,1,17,19],[18,1,18,7],[19,1,19,7],[19,8,19,19],[20,1,20,7],[20,8,20,10],[20,11,20,13],[20,14,20,16],[20,17,20,19],[21,1,21,4],[21,8,21,10],[21,11,21,13],[21,14,21,16],[21,17,21,19],[22,1,22,4],[22,8,22,10],[22,11,22,13],[22,14,22,16],[22,17,22,19],[23,1,23,6],[23,8,23,10],[23,11,23,13],[23,14,23,16],[23,17,23,19],[23,23,26,23],[23,24,26,24],[23,25,26,25],[23,26,26,26],[23,27,26,27],[23,28,26,28],[23,29,26,29],[23,30,26,30],[24,1,25,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,24,10],[24,11,24,13],[24,14,24,16],[24,17,24,19],[25,8,25,10],[25,11,25,13],[25,14,25,16],[25,17,25,19],[27,8,27,19],[28,1,28,19],[28,23,28,30],[29,1,44,1],[29,2,44,2],[29,3,44,3],[29,4,44,4],[45,1,45,4],[45,5,45,6],[46,1,46,4],[46,5,46,6],[46,8,46,10],[46,11,46,13],[46,14,46,16],[46,17,46,19],[46,21,46,22],[47,1,47,6],[47,8,47,19],[49,1,49,19],[49,23,49,30],[50,1,70,1],[50,2,70,2],[50,3,70,3],[50,4,70,4],[60,8,60,10],[60,14,60,16],[60,17,60,19],[61,8,61,10],[61,14,61,16],[61,17,61,19],[62,8,62,10],[62,14,62,16],[62,17,62,19],[71,1,71,4],[71,5,71,6],[72,1,72,4],[72,5,72,6],[72,8,72,10],[72,11,72,13],[72,14,72,16],[72,17,72,19],[72,21,72,22],[73,1,73,6],[73,8,73,19],[75,1,75,19],[75,23,75,30],[76,1,82,1],[76,2,82,2],[76,3,82,3],[76,4,82,4],[83,1,83,4],[83,5,83,6],[84,1,84,4],[84,5,84,6],[84,8,84,10],[84,11,84,13],[84,14,84,16],[84,17,84,19],[84,21,84,22],[85,1,85,6],[85,8,85,19],[87,1,87,19],[87,23,87,30],[88,1,99,1],[88,2,99,2],[88,3,99,3],[88,4,99,4],[100,1,100,4],[100,5,100,6],[101,1,101,4],[101,5,101,6],[101,8,101,10],[101,11,101,13],[101,14,101,16],[101,17,101,19],[101,21,101,22],[102,1,102,6],[102,8,102,19],[104,1,104,19],[104,23,104,30],[105,1,109,1],[105,2,109,2],[105,3,109,3],[105,4,109,4],[105,17,105,19],[106,17,106,19],[107,8,107,10],[107,14,107,16],[107,17,107,19],[108,8,108,10],[108,11,108,13],[108,17,108,19],[109,17,109,19],[110,1,110,4],[110,5,110,6],[111,1,111,4],[111,5,111,6],[111,8,111,10],[111,11,111,13],[111,14,111,16],[111,17,111,19],[111,21,111,22],[112,1,112,6],[112,8,112,19],[114,1,114,6],[114,8,114,19],[115,1,115,6],[115,8,115,19],[116,1,116,6],[116,8,116,19],[117,1,117,6],[117,8,117,19],[118,1,118,6],[118,8,118,19],[119,1,119,6],[119,8,119,19],[121,1,121,6],[121,8,121,19],[123,1,123,6],[123,8,123,19],[124,1,124,4],[124,5,124,6],[124,10,124,19],[125,1,125,6],[125,8,125,19],[127,1,127,7],[127,8,127,19],[128,1,128,7],[128,8,128,19],[129,1,129,19],[130,1,130,19]]}
[null,"COMMITTENTE:"]
[null,"OGGETTO DELL'INCARICO:"]
[null,"DANNO:"]
[null,"CALCOLO DEI COMPENSI \nI compensi sono calcolati sulla base del D.M. GIUSTIZIA 20/07/2012, n. 140 \"Regolamento recante la determinazione dei parametri per la liquidazione da parte di un organo giurisdizionale dei compensi per le professioni regolamentate vigilate dal Ministero della giustizia, ai sensi dell’articolo 9 del decreto-legge 24 gennaio 2012 n. 1 convertito con modificazioni dalla legge 24 marzo 2012 n. 27.\"\nCosì come previsto dall'ordinanza 108/2020 del Commisario per la Ricostruzione post- sisma 2016"]
[]
[null,"RIPARTIZIONE DELL'ONORARIO FRA I SOGGETTI PREVISTI DALL'ORD. 108/2020",{"$nulls":37},"IMPOSTAZIONI STANDARD DELLE PRESTAZIONI.\nAll’utilizzatore rimane l’esclusiva responsabilità e il corretto impiego del programma, \nla consapevole interpretazione ed il necessario controllo dei risultati delle elaborazioni, \npertanto il produttore non potrà per nessun motivo essere ritenuto responsabile per alcun danno, diretto o indiretto, per mancati guadagni od altro in conseguenza dell’utilizzazione delle programma stesso."]
[null,null,"PROFESSIONISTA",{"$nulls":3},"TITOLO NOME E COGNOME",null,"ONORARIO",{"$nulls":5},"SPESE"]
[null,1,"COORDINATORE",{"$nulls":5},{"$f":"X128","v":{"v":0,"d":"0.00 €"}}]
[null,2,"DIRETTORE DEI LAVORI",{"$nulls":5},{"$f":"Y128","v":{"v":0,"d":"0.00 €"}}]
[null,3,"SPECIALISTICA 1",{"$nulls":5},{"$f":"Z128","v":{"v":0,"d":"0.00 €"}}]
[null,4,"SPECIALISTICA 2",{"$nulls":5},{"$f":"AA128","v":{"v":0,"d":"0.00 €"}}]
[null,5,"SICUREZZA PROGETTO",{"$nulls":5},{"$f":"AB128","v":{"v":0,"d":"0.00 €"}}]
[null,6,"SICUREZZA ESECUZIONE",{"$nulls":5},{"$f":"AC128","v":{"v":0,"d":"0.00 €"}}]
[null,7,"COLLAUDATORE",{"$nulls":5},{"$f":"AD128","v":{"v":0,"d":"0.00 €"}}]
[null,8,"GEOLOGO",{"$nulls":5},{"$f":"AE128","v":{"v":0,"d":"0.00 €"}},{"$nulls":35},"NB QUANDO SI VA IN STAMPA IMPOSTARE \"ADATTA TUTTE LE COLONNE SU UNA PAGINA\" "]
[null,null,"TOTALE",{"$nulls":5},{"$f":"SUM(I8:N15)","v":{"v":0,"d":"0.00 €"}},{"$nulls":5},{"$f":"I129","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"in giallo le prestazioni \"standard\", in rosa le \"specialistiche\", in verde \"la sicurezza\" - come previsto da ord. 108/2020"]
[null,"IMPORTI DI RIFERIMENTO A BASE DI CALCOLO:"]
[null,"Editare le celle in azzuro",{"$nulls":6},"Categorie",{"$nulls":14},1,2,3,4,5,6,7,8]
[null,"Modalità di compilazione:\n- Inserire il valore delle opere per ciascuna categoria\n- Scegliere la destinazione funzionale delle opere\n- Inserire il grado di complessità \n- Digitare \"X\" nell'apposita colonna per attivare tutte le prestazioni\n- Inserire il progettista nella casella di fianco alla singola prestazione (numero d'ordine 1,2 ...)",{"$nulls":6},"Edilizia",null,null,"Strutture",null,null,"Impianti  1",null,null,"Impianti  2",{"$nulls":5},"COORDINATORE","DIRETTORE DEI LAVORI","SPECIALISTA 1","SPECIALISTA 2","SICUREZZA PROGETTO","SICUREZZA ESECUZIONE","COLLAUDATORE","GEOLOGO"]
[null,"Valore opera",{"$nulls":3},"V",{"$f":"CONCATENATE(\"Importo complessivo opere: \n€ \",TEXT(SUM(I22:T22),\"### ##0.00\"))","v":"Importo complessivo opere: \n€ 0.00"}]
[null,"Parametro",{"$nulls":3},"P",null,null,{"$f":"IF(I22<>0,0.03+10/POWER(I22,0.4),\"0\")","v":"0"},null,null,{"$f":"IF(L22<>0,0.03+10/POWER(L22,0.4),\"0\")","v":"0"},null,null,{"$f":"IF(O22<>0,0.03+10/POWER(O22,0.4),\"0\")","v":"0"},null,null,{"$f":"IF(R22<>0,0.03+10/POWER(R22,0.4),\"0\")","v":"0"}]
[null,"Destinazione funzionale delle opere",{"$nulls":5},"FLAG X =\nATTIVA TUTTE LE PRESTAZ.",{"$nulls":15},"COORDINATORE","DIRETTORE DEI LAVORI","SPECIALISTA 1","SPECIALISTA 2","SICUREZZA PROGETTO","SICUREZZA ESECUZIONE","COLLAUDATORE","GEOLOGO",{"$nulls":3},"---"]
[null,"Complessità",{"$nulls":3},"G","Grado di complessità (min-medio-max)",null,{"$f":"IF(I24<>\"\",VLOOKUP(I24,'Tabella-Z1'!$B$4:$F$11,5),\"\")","v":""},null,null,{"$f":"IF(L24<>\"\",VLOOKUP(L24,'Tabella-Z1'!$B$12:$F$14,5),\"\")","v":""},null,null,{"$f":"IF(O24<>\"\",VLOOKUP(O24,'Tabella-Z1'!$B$15:$F$20,5),\"\")","v":""},null,null,{"$f":"IF(R24<>\"\",VLOOKUP(R24,'Tabella-Z1'!$B$15:$F$20,5),\"\")","v":""},{"$nulls":16},"1. DEMOLIZIONE E RICOSTRUZIONE"]
[{"$nulls":34},"2. MIGLIORAMENTO/ADEGUAMENTO SISMICO"]
[{"$nulls":34},"3. MIGLIORAMENTO EDIFICIO VINCOLATO"]
[{"$nulls":8},"nella casella azzurra indicare il professionista autore della progettazione",{"$nulls":14},1,2,3,4,5,6,7,8,{"$nulls":3},"4. DANNI LIEVI - L0",{"$nulls":3},5]
[null,"PROGETTAZIONE PRELIMINARE",{"$nulls":21},"PROGETTAZIONE PRELIMINARE",{"$nulls":10},1,2,3,4,1]
[null,"PROGETTAZIONE","b.I)\nPROGETTAZIONE PRELIMINARE","prestazioni affidate","incidenza Q","QbI.01\nQpf.01","Relazioni, planimetrie, elaborati grafici (art.17, comma1, lettere a), b), e), d.P.R. 207/10)  ",null,null,{"$f":"IF($H30=\"x\",IF(AND(I30>0,I30<9),K30,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.09,"d":"0.090"},null,{"$f":"IF($H30=\"x\",IF(AND(L30>0,L30<9),N30,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.09,"d":"0.090"},null,{"$f":"IF($H30=\"x\",IF(AND(O30>0,O30<9),Q30,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.09,"d":"0.090"},null,{"$f":"IF($H30=\"x\",IF(AND(R30>0,R30<9),T30,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.09,"d":"0.090"},{"$nulls":3},{"$f":"IF(H30=\"X\",IF(I30=$X$20,ROUND(I$23*I$22*I$26*K30,2),0)+IF(L30=$X$20,ROUND(L$23*L$22*L$26*N30,2),0)+IF(O30=$X$20,ROUND(O$23*O$22*O$26*Q30,2),0)+IF(R30=$X$20,ROUND(R$23*R$22*R$26*T30,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H30=\"X\",IF(I30=$Y$20,ROUND(I$23*I$22*I$26*K30,2),0)+IF(L30=$Y$20,ROUND(L$23*L$22*L$26*N30,2),0)+IF(O30=$Y$20,ROUND(O$23*O$22*O$26*Q30,2),0)+IF(R30=$Y$20,ROUND(R$23*R$22*R$26*T30,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H30=\"X\",IF(I30=$Z$20,ROUND(I$23*I$22*I$26*K30,2),0)+IF(L30=$Z$20,ROUND(L$23*L$22*L$26*N30,2),0)+IF(O30=$Z$20,ROUND(O$23*O$22*O$26*Q30,2),0)+IF(R30=$Z$20,ROUND(R$23*R$22*R$26*T30,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H30=\"X\",IF(I30=$AA$20,ROUND(I$23*I$22*I$26*K30,2),0)+IF(L30=$AA$20,ROUND(L$23*L$22*L$26*N30,2),0)+IF(O30=$AA$20,ROUND(O$23*O$22*O$26*Q30,2),0)+IF(R30=$AA$20,ROUND(R$23*R$22*R$26*T30,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H30=\"X\",IF(I30=$AB$20,ROUND(I$23*I$22*I$26*K30,2),0)+IF(L30=$AB$20,ROUND(L$23*L$22*L$26*N30,2),0)+IF(O30=$AB$20,ROUND(O$23*O$22*O$26*Q30,2),0)+IF(R30=$AB$20,ROUND(R$23*R$22*R$26*T30,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H30=\"X\",IF(I30=$AC$20,ROUND(I$23*I$22*I$26*K30,2),0)+IF(L30=$AC$20,ROUND(L$23*L$22*L$26*N30,2),0)+IF(O30=$AC$20,ROUND(O$23*O$22*O$26*Q30,2),0)+IF(R30=$AC$20,ROUND(R$23*R$22*R$26*T30,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H30=\"X\",IF(I30=$AD$20,ROUND(I$23*I$22*I$26*K30,2),0)+IF(L30=$AD$20,ROUND(L$23*L$22*L$26*N30,2),0)+IF(O30=$AD$20,ROUND(O$23*O$22*O$26*Q30,2),0)+IF(R30=$AD$20,ROUND(R$23*R$22*R$26*T30,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H30=\"X\",IF(I30=$AE$20,ROUND(I$23*I$22*I$26*K30,2),0)+IF(L30=$AE$20,ROUND(L$23*L$22*L$26*N30,2),0)+IF(O30=$AE$20,ROUND(O$23*O$22*O$26*Q30,2),0)+IF(R30=$AE$20,ROUND(R$23*R$22*R$26*T30,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5}," QbI.02  ","Calcolo sommario spesa, quadro economico di progetto (art.17, comma 1, lettere g), h), d.P.R. 207/10)  ",null,null,{"$f":"IF($H31=\"x\",IF(AND(I31>0,I31<9),K31,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.01,"d":"0.010"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},null,{"$f":"IF($H31=\"x\",IF(AND(R31>0,R31<9),T31,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.01,"d":"0.010"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbI.03  ","Piano economico e finanziario di massima (art.17, comma 4, d.P.R. 207/10 \u0081]art.164 D. lgs. 163/06 \u0081]art.1, comma 3, all.XXI)",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbI.04  ","Capitolato speciale descrittivo e prestazionale, schema di contratto (art.17, comma 3, lettere b), c), d.P.R. 207/10 \u0081]art.164, d.lgs. 163/06 \u0081]art.7, Allegato XXI)",null,null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbI.05\nQps.02.01"," Relazione di indagine geotecnica (art.19, comma 1, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X"]
[{"$nulls":5}," QbI.06  "," Relazione di indagine idrologica (art.19, comma 1, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbI.07\nQps.04.01"," Relazione di indagine idraulica (art.19, comma 1, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbI.08\nQps.05.01"," Relazione di indagine sismica (art.19, comma 1, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X"]
[{"$nulls":5},"QbI.09  \nQps.09"," Relazione di indagine archeologica (art.19, comma 1, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,null,{"v":0,"d":"0.000"},0.015,{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbI.10\nQps.10.01"," Relazione di indagine geologica (art.19, comma 1, d.P.R. 207/10)  ",null,{"$f":"IF(H39=\"X\",8,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$f":"IF(I39=\"\",\"\",I39)","v":""},{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$f":"IF(H39=\"X\",8,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$f":"IF(H39=\"X\",8,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X"]
[{"$nulls":5}," QbI.11  "," Progettazione integrale e coordinata \u0081- Integrazione delle prestazioni specialistiche (art.90, comma 7, d.lgs. 163/06) . Relazione tecno\u0081]alimentare  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbI.12  "," Studio di inserimento urbanistico (art.164, d.lgs. 163/06 \u0081]art.1, comma 2, lettera l), all.XXI6  ",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbI.13\nQps.01","Relazione tecnica sullo stato di consistenza degli   immobili da ristrutturare (art.17, comma 3, lettera a), d.P.R. 207/10) h  ",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbI.14\nQps.11.01"," Prime indicazioni di progettazione antincendio (d.m. 6/02/1982)  ",null,null,{"v":0,"d":"0.000"},0.005,null,{"v":0,"d":"0.000"},0.005,null,{"v":0,"d":"0.000"},0.005,null,{"v":0,"d":"0.000"},0.005,{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbI.15\nQS.01.01"," Prime indicazioni e prescrizioni per la stesura dei Piani di Sicurezza  ",null,{"$f":"IF(H44=\"X\",5,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$f":"IF(H44=\"X\",5,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$f":"IF(H44=\"X\",5,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$f":"IF(H44=\"X\",5,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5}," QbI.16  "," Studi di prefattibilita ambientale/Sicurezza alimentare  ",null,null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"totale incidenze",{"$nulls":3},"∑ Q i",{"$nulls":3},{"$f":"SUM(J30:J45)","v":{"v":0,"d":"0.000"}},{"$f":"J46","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(M30:M45)","v":{"v":0,"d":"0.000"}},{"$f":"M46","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(P30:P45)","v":{"v":0,"d":"0.000"}},{"$f":"P46","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(S30:S45)","v":{"v":0,"d":"0.000"}},{"$f":"S46","v":{"v":0,"d":"0.000"}},{"$nulls":12},{"$f":"I48-SUM(X30:AE45)","v":{"v":0,"d":"0.00 €"}}]
[null,"Compenso al netto di spese ed oneri CNPAIA",{"$nulls":3},"V*P*G*ΣQ",null,null,{"$f":"K46*I26*I23*I22","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"N46*L26*L23*L22","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"Q46*O26*O23*O22","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"T46*R26*R23*R22","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"eventuale aggiustamento\ndx-sx",null,{"$f":"AG46","v":{"v":0,"d":"0.00 €"}}]
[null,"COMPENSO AL NETTO DELLE SPESE",{"$nulls":6},{"$f":"ROUND(SUM(I47:T47),2)","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I48=SUM(X48:AE48),\"OK\",\"CONTROLLA\")","v":"OK"},{"$f":"SUM(X48:AE48)-I48","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(X30:X47)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[null,"PROGETTAZIONE DEFINITIVA",{"$nulls":21},"PROGETTAZIONE DEFINITIVA"]
[null,"PROGETTAZIONE","b.II)\nPROGETTAZIONE DEFINITIVA","prestazioni affidate","incidenza Q"," QbII.01  "," Relazioni generale e tecniche, Elaborati grafici art.24, comma 2, lettere a), b), d), f), d.P.R. 207/10)  ",null,null,{"$f":"IF($H51=\"x\",IF(AND(I51>0,I51<9),K51,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.23,"d":"0.230"},null,{"$f":"IF($H51=\"x\",IF(AND(L51>0,L51<9),N51,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.18,"d":"0.180"},null,{"$f":"IF($H51=\"x\",IF(AND(O51>0,O51<9),Q51,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.2,"d":"0.200"},null,{"$f":"IF($H51=\"x\",IF(AND(R51>0,R51<9),T51,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.2,"d":"0.200"},{"$nulls":3},{"$f":"IF(H51=\"X\",IF(I51=$X$20,ROUND(I$23*I$22*I$26*K51,2),0)+IF(L51=$X$20,ROUND(L$23*L$22*L$26*N51,2),0)+IF(O51=$X$20,ROUND(O$23*O$22*O$26*Q51,2),0)+IF(R51=$X$20,ROUND(R$23*R$22*R$26*T51,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H51=\"X\",IF(I51=$Y$20,ROUND(I$23*I$22*I$26*K51,2),0)+IF(L51=$Y$20,ROUND(L$23*L$22*L$26*N51,2),0)+IF(O51=$Y$20,ROUND(O$23*O$22*O$26*Q51,2),0)+IF(R51=$Y$20,ROUND(R$23*R$22*R$26*T51,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H51=\"X\",IF(I51=$Z$20,ROUND(I$23*I$22*I$26*K51,2),0)+IF(L51=$Z$20,ROUND(L$23*L$22*L$26*N51,2),0)+IF(O51=$Z$20,ROUND(O$23*O$22*O$26*Q51,2),0)+IF(R51=$Z$20,ROUND(R$23*R$22*R$26*T51,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H51=\"X\",IF(I51=$AA$20,ROUND(I$23*I$22*I$26*K51,2),0)+IF(L51=$AA$20,ROUND(L$23*L$22*L$26*N51,2),0)+IF(O51=$AA$20,ROUND(O$23*O$22*O$26*Q51,2),0)+IF(R51=$AA$20,ROUND(R$23*R$22*R$26*T51,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H51=\"X\",IF(I51=$AB$20,ROUND(I$23*I$22*I$26*K51,2),0)+IF(L51=$AB$20,ROUND(L$23*L$22*L$26*N51,2),0)+IF(O51=$AB$20,ROUND(O$23*O$22*O$26*Q51,2),0)+IF(R51=$AB$20,ROUND(R$23*R$22*R$26*T51,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H51=\"X\",IF(I51=$AC$20,ROUND(I$23*I$22*I$26*K51,2),0)+IF(L51=$AC$20,ROUND(L$23*L$22*L$26*N51,2),0)+IF(O51=$AC$20,ROUND(O$23*O$22*O$26*Q51,2),0)+IF(R51=$AC$20,ROUND(R$23*R$22*R$26*T51,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H51=\"X\",IF(I51=$AD$20,ROUND(I$23*I$22*I$26*K51,2),0)+IF(L51=$AD$20,ROUND(L$23*L$22*L$26*N51,2),0)+IF(O51=$AD$20,ROUND(O$23*O$22*O$26*Q51,2),0)+IF(R51=$AD$20,ROUND(R$23*R$22*R$26*T51,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H51=\"X\",IF(I51=$AE$20,ROUND(I$23*I$22*I$26*K51,2),0)+IF(L51=$AE$20,ROUND(L$23*L$22*L$26*N51,2),0)+IF(O51=$AE$20,ROUND(O$23*O$22*O$26*Q51,2),0)+IF(R51=$AE$20,ROUND(R$23*R$22*R$26*T51,2),0),0)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"QbII.02 \nQpe.04.01"," Disciplinare descrittivo e prestazionale (art.24, comma 2, lettera g), d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbII.03\nQpa.02"," Elenco prezzi, Computo metrico estimativo, Quadro economico (art.24, comma 2, lettere l), m), o), d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},null,{"v":0,"d":"0.000"},{"v":0.04,"d":"0.040"},null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbII.04\nQps.12"," Studio di inserimento urbanistico (art.24, comma 2, lettera c), d.P.R. 207/2010)  ",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbII.05  "," Schema di contratto, Capitolato speciale d'appalto h  ",null,null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},null,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},null,{"v":0,"d":"0.000"},{"v":0.08,"d":"0.080"},null,{"v":0,"d":"0.000"},{"v":0.08,"d":"0.080"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbII.06\nQps.02.02"," Relazione di indagine geotecnica (art.26, comma 1, d.P.R. 207/2010)  ",null,null,{"v":0,"d":"0.000"},{"v":0.09,"d":"0.090"},null,{"v":0,"d":"0.000"},{"v":0.09,"d":"0.090"},null,{"v":0,"d":"0.000"},{"v":0.09,"d":"0.090"},null,{"v":0,"d":"0.000"},{"v":0.09,"d":"0.090"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X"]
[{"$nulls":5}," QbII.07  "," Relazione di indagine idrologica (art.26, comma 1, d.P.R. 207/2010)  ",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbII.08\nQps.04.02"," Relazione di indagine idraulica (art.26, comma 1, d.P.R. 207/2010)  ",{"$f":"IF(H36<>\"\",H36,\"\")","v":""},{"$f":"IF(H58=\"X\",IF(I36=\"\",\"\",I36),\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$f":"IF(I58=\"\",\"\",I58)","v":""},{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$f":"IF(I58=\"\",\"\",I58)","v":""},{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$f":"IF(I58=\"\",\"\",I58)","v":""},{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbII.09\nQps.05.02"," Relazione di indagine sismica (art.19, comma 1, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X"]
[{"$nulls":5},"QbII.10\nQps.10.02"," Relazione di indagine geologica (art.26, comma 1, d.P.R. 207/2010)  ",{"$f":"IF(H39<>\"\",H39,\"\")","v":""},{"$f":"IF(H60=\"X\",8,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.15,"d":"0.150"},{"$f":"I60","v":""},{"v":0,"d":"0.000"},{"v":0.15,"d":"0.150"},{"$f":"I60","v":""},{"v":0,"d":"0.000"},{"v":0.15,"d":"0.150"},{"$f":"I60","v":""},{"v":0,"d":"0.000"},{"v":0.15,"d":"0.150"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbII.11\nQps.06"," Analisi storico critica e relazione sulle strutture esistenti (art.26, d.P.R. 207/10 \u0081-cap.8,5, d.m. 14/01/2008)  ",null,"  ",{"$nulls":3},{"v":0,"d":"0.000"},{"v":0.09,"d":"0.090"},"  ",null,null,"  ",{"$nulls":5},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":4},"X","X","X"]
[{"$nulls":5},"QbII.12\nQps.07"," Relazione sulle indagini dei materiali e delle strutture per edifici esistenti (art.26, d.P.R. 207)  ",null,"  ",{"$nulls":3},{"v":0,"d":"0.000"},{"v":0.12,"d":"0.120"},"  ",null,null,"  ",{"$nulls":5},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":4},"X","X","X"]
[{"$nulls":5},"QbII.13\nQps.08"," Verifica sismica delle strutture esistenti e individuazione delle carenza strutturali (art.26, d.P.R. \u0081- cap.8,5, d.m. 14/01/2008)  ",null,"  ",{"$nulls":3},{"v":0,"d":"0.000"},{"v":0.18,"d":"0.180"},"  ",null,null,"  ",{"$nulls":5},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":4},"X","X","X"]
[{"$nulls":5}," QbII.14  "," Progettazione integrale e coordinata \u0081- Integrazione delle prestazioni specialistiche (art.90, comma 7, d.lgs. 163/2006)  ",null,null,{"$f":"IF($H64=\"x\",IF(AND(I64>0,I64<9),K64,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.05,"d":"0.050"},null,{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},null,{"$f":"IF($H64=\"x\",IF(AND(O64>0,O64<9),Q64,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.05,"d":"0.050"},null,{"$f":"IF($H64=\"x\",IF(AND(R64>0,R64<9),T64,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.05,"d":"0.050"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbII.15\nQps.11.02"," Elaborati di progettazione antincendio (d.m. 16/02/1982)  ",null,null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbII.16\nQps.13"," Relazione paesaggistica (d.lgs. 42/2004)  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QbII.17\nQps.14"," Elaborati e relazioni per requisiti acustici (Legge 447/95\u0081]d.p.c.m. 512/97)  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X"]
[{"$nulls":5},"QbII.18\nQps.15"," Relazione di qualificazione energetica (art.8, d.lgs. 311/2006)  ",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X"]
[{"$nulls":5},"QbII.19\nQps.16"," Diagnosi e qualificazione energetica degli edifici esistenti (d.P.R. 59), esclusi i rilievi e le indagini  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":4},"X"]
[{"$nulls":5},"QbII.20\nQS.01.02"," Aggiornamento delle prime indicazioni e prescrizioni per la redazione del PSC  ",{"$f":"IF(H44<>\"\",H44,\"\")","v":""},{"$f":"IF(H70=\"X\",5,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$f":"I70","v":""},{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$f":"I70","v":""},{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$f":"I70","v":""},{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QbII.21  "," Studio di impatto ambientale o di fattibilita ambientale (VIA\u0081]VAS\u0081]AIA) . Indagini alimentari ed analisi predittive di sicurezza alimentare  ",null,null,{"v":0,"d":"0.000"},{"v":0.15,"d":"0.150"},null,{"v":0,"d":"0.000"},{"v":0.12,"d":"0.120"},null,{"$f":"IF($H71=\"x\",IF(AND(O71>0,O71<9),Q71,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.19,"d":"0.190"},null,{"v":0,"d":"0.000"},{"v":0.19,"d":"0.190"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"totale incidenze",{"$nulls":3},"∑ Q i",{"$nulls":3},{"$f":"SUM(J51:J71)","v":{"v":0,"d":"0.000"}},{"$f":"J72","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(M51:M71)","v":{"v":0,"d":"0.000"}},{"$f":"M72","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(P51:P71)","v":{"v":0,"d":"0.000"}},{"$f":"P72","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(S51:S71)","v":{"v":0,"d":"0.000"}},{"$f":"S72","v":{"v":0,"d":"0.000"}},{"$nulls":12},{"$f":"I74-SUM(X51:AE71)","v":{"v":0,"d":"0.00 €"}}]
[null,"Compenso al netto di spese ed oneri CNPAIA ",{"$nulls":3},"V*P*G*ΣQ",null,null,{"$f":"K72*I22*I23*I26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"N72*L22*L23*L26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"Q72*O22*O23*O26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"T72*R22*R23*R26","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"eventuale aggiustamento\ndx-sx",null,{"$f":"AG72","v":{"v":0,"d":"0.00 €"}}]
[null,"COMPENSO AL NETTO DELLE SPESE",{"$nulls":6},{"$f":"ROUND(SUM(I73:T73),2)","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I74=SUM(X74:AE74),\"OK\",\"CONTROLLA\")","v":"OK"},{"$f":"SUM(X74:AE74)-I74","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(X51:X73)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Y51:Y73)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Z51:Z73)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AA51:AA73)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[null,"PROGETTAZIONE ESECUTIVA",{"$nulls":21},"PROGETTAZIONE ESECUTIVA"]
[null,"PROGETTAZIONE"," b.III) PROGETTAZIONE ESECUTIVA  ","prestazioni affidate","incidenza Q","QbIII.01\nQpe.01"," Relazione generale e specialistiche, Elaborati grafici, Calcoli esecutivi (art.33, comma 1, lettere a), b), c), d), d.P.R. 207/10)",null,null,{"$f":"IF($H77=\"x\",IF(AND(I77>0,I77<9),K77,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.1,"d":"0.100"},null,{"$f":"IF($H77=\"x\",IF(AND(L77>0,L77<9),N77,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.12,"d":"0.120"},null,{"$f":"IF($H77=\"x\",IF(AND(O77>0,O77<9),Q77,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.15,"d":"0.150"},null,{"$f":"IF($H77=\"x\",IF(AND(R77>0,R77<9),T77,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.15,"d":"0.150"},{"$nulls":3},{"$f":"IF(H77=\"X\",IF(I77=$X$20,ROUND(I$23*I$22*I$26*K77,2),0)+IF(L77=$X$20,ROUND(L$23*L$22*L$26*N77,2),0)+IF(O77=$X$20,ROUND(O$23*O$22*O$26*Q77,2),0)+IF(R77=$X$20,ROUND(R$23*R$22*R$26*T77,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H77=\"X\",IF(I77=$Y$20,ROUND(I$23*I$22*I$26*K77,2),0)+IF(L77=$Y$20,ROUND(L$23*L$22*L$26*N77,2),0)+IF(O77=$Y$20,ROUND(O$23*O$22*O$26*Q77,2),0)+IF(R77=$Y$20,ROUND(R$23*R$22*R$26*T77,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H77=\"X\",IF(I77=$Z$20,ROUND(I$23*I$22*I$26*K77,2),0)+IF(L77=$Z$20,ROUND(L$23*L$22*L$26*N77,2),0)+IF(O77=$Z$20,ROUND(O$23*O$22*O$26*Q77,2),0)+IF(R77=$Z$20,ROUND(R$23*R$22*R$26*T77,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H77=\"X\",IF(I77=$AA$20,ROUND(I$23*I$22*I$26*K77,2),0)+IF(L77=$AA$20,ROUND(L$23*L$22*L$26*N77,2),0)+IF(O77=$AA$20,ROUND(O$23*O$22*O$26*Q77,2),0)+IF(R77=$AA$20,ROUND(R$23*R$22*R$26*T77,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H77=\"X\",IF(I77=$AB$20,ROUND(I$23*I$22*I$26*K77,2),0)+IF(L77=$AB$20,ROUND(L$23*L$22*L$26*N77,2),0)+IF(O77=$AB$20,ROUND(O$23*O$22*O$26*Q77,2),0)+IF(R77=$AB$20,ROUND(R$23*R$22*R$26*T77,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H77=\"X\",IF(I77=$AC$20,ROUND(I$23*I$22*I$26*K77,2),0)+IF(L77=$AC$20,ROUND(L$23*L$22*L$26*N77,2),0)+IF(O77=$AC$20,ROUND(O$23*O$22*O$26*Q77,2),0)+IF(R77=$AC$20,ROUND(R$23*R$22*R$26*T77,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H77=\"X\",IF(I77=$AD$20,ROUND(I$23*I$22*I$26*K77,2),0)+IF(L77=$AD$20,ROUND(L$23*L$22*L$26*N77,2),0)+IF(O77=$AD$20,ROUND(O$23*O$22*O$26*Q77,2),0)+IF(R77=$AD$20,ROUND(R$23*R$22*R$26*T77,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H77=\"X\",IF(I77=$AE$20,ROUND(I$23*I$22*I$26*K77,2),0)+IF(L77=$AE$20,ROUND(L$23*L$22*L$26*N77,2),0)+IF(O77=$AE$20,ROUND(O$23*O$22*O$26*Q77,2),0)+IF(R77=$AE$20,ROUND(R$23*R$22*R$26*T77,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbIII.02\nQpe.02"," Particolari costruttivi e decorativi (art.36, comma 1, lettera c), d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.13,"d":"0.130"},null,{"v":0,"d":"0.000"},{"v":0.13,"d":"0.130"},null,{"$f":"IF($H78=\"x\",IF(AND(O78>0,O78<9),Q78,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.05,"d":"0.050"},null,{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbIII.03\nQpe.03"," Computo metrico estimativo, Quadro economico, Elenco prezzi e eventuale analisi, Quadro dell'incidenza percentuale della quantita di manodopera (art.33, comma 1, lettere f), g), i), d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.04,"d":"0.040"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},null,{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbIII.04\nQpe.04.02"," Schema di contratto, capitolato speciale d'appalto, cronoprogramma (art.33, comma 1, lettere l), h), d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbIII.05\nQpe.05"," Piano di manutenzione dell'opera (art.33, comma 1, lettera e) d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},0.025,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbIII.06\nQpe.06"," Progettazione integrale e coordinata, Integrazione delle prestazioni specialistiche (art.90, comma 7, d.lgs. 163/2006)  ",null,{"$f":"IF(H82=\"X\",1,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$f":"IF(I82=\"\",\"\",I82)","v":""},{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$f":"IF(I82=\"\",\"\",I82)","v":""},{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$f":"IF(I82=\"\",\"\",I82)","v":""},{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QbIII.07\nQS.01.03"," Piano di Sicurezza e Coordinamento . Piano di sicurezza alimentare  ",{"$f":"IF(H44<>\"\",H44,\"\")","v":""},{"$f":"IF(H83=\"X\",5,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},{"$f":"IF(I83=\"\",\"\",I83)","v":""},{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},{"$f":"IF(I83=\"\",\"\",I83)","v":""},{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},{"$f":"IF(I83=\"\",\"\",I83)","v":""},{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"totale incidenze",{"$nulls":3},"∑ Q i",{"$nulls":3},{"$f":"SUM(J77:J83)","v":{"v":0,"d":"0.000"}},{"$f":"J84","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(M77:M83)","v":{"v":0,"d":"0.000"}},{"$f":"M84","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(P77:P83)","v":{"v":0,"d":"0.000"}},{"$f":"P84","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(S77:S83)","v":{"v":0,"d":"0.000"}},{"$f":"S84","v":{"v":0,"d":"0.000"}},{"$nulls":12},{"$f":"I86-SUM(X77:AE83)","v":{"v":0,"d":"0.00 €"}}]
[null,"Compenso al netto di spese ed oneri CNPAIA",{"$nulls":3},"V*P*G*ΣQ",null,null,{"$f":"K84*I22*I23*I26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"N84*L22*L23*L26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"Q84*O22*O23*O26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"T84*R22*R23*R26","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"eventuale aggiustamento\ndx-sx",null,{"$f":"AG84","v":{"v":0,"d":"0.00 €"}}]
[null,"COMPENSO AL NETTO DELLE SPESE",{"$nulls":6},{"$f":"ROUND(SUM(I85:T85),2)","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I86=SUM(X86:AE86),\"OK\",\"CONTROLLA\")","v":"OK"},{"$f":"SUM(X86:AE86)-I86","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(X77:X85)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[null,"ESECUZIONE DEI LAVORI",{"$nulls":21},"ESECUZIONE DEI LAVORI"]
[null,"DIREZIONE ESECUTIVA"," C.I)ESECUZIONE DEI LAVORI  ","prestazioni affidate","incidenza Q","QcI.01\nQe.01"," Direzione lavori, assistenza al collaudo, prove d'officina (art.148, d.P.R. 207/10)8  ",null,null,{"$f":"IF($H89=\"x\",IF(AND(I89>0,I89<9),K89,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.32,"d":"0.320"},null,{"$f":"IF($H89=\"x\",IF(AND(L89>0,L89<9),N89,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.38,"d":"0.380"},null,{"$f":"IF($H89=\"x\",IF(AND(O89>0,O89<9),Q89,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.32,"d":"0.320"},null,{"$f":"IF($H89=\"x\",IF(AND(R89>0,R89<9),T89,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.32,"d":"0.320"},{"$nulls":3},{"$f":"IF(H89=\"X\",IF(I89=$X$20,ROUND(I$23*I$22*I$26*K89,2),0)+IF(L89=$X$20,ROUND(L$23*L$22*L$26*N89,2),0)+IF(O89=$X$20,ROUND(O$23*O$22*O$26*Q89,2),0)+IF(R89=$X$20,ROUND(R$23*R$22*R$26*T89,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H89=\"X\",IF(I89=$Y$20,ROUND(I$23*I$22*I$26*K89,2),0)+IF(L89=$Y$20,ROUND(L$23*L$22*L$26*N89,2),0)+IF(O89=$Y$20,ROUND(O$23*O$22*O$26*Q89,2),0)+IF(R89=$Y$20,ROUND(R$23*R$22*R$26*T89,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H89=\"X\",IF(I89=$Z$20,ROUND(I$23*I$22*I$26*K89,2),0)+IF(L89=$Z$20,ROUND(L$23*L$22*L$26*N89,2),0)+IF(O89=$Z$20,ROUND(O$23*O$22*O$26*Q89,2),0)+IF(R89=$Z$20,ROUND(R$23*R$22*R$26*T89,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H89=\"X\",IF(I89=$AA$20,ROUND(I$23*I$22*I$26*K89,2),0)+IF(L89=$AA$20,ROUND(L$23*L$22*L$26*N89,2),0)+IF(O89=$AA$20,ROUND(O$23*O$22*O$26*Q89,2),0)+IF(R89=$AA$20,ROUND(R$23*R$22*R$26*T89,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H89=\"X\",IF(I89=$AB$20,ROUND(I$23*I$22*I$26*K89,2),0)+IF(L89=$AB$20,ROUND(L$23*L$22*L$26*N89,2),0)+IF(O89=$AB$20,ROUND(O$23*O$22*O$26*Q89,2),0)+IF(R89=$AB$20,ROUND(R$23*R$22*R$26*T89,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H89=\"X\",IF(I89=$AC$20,ROUND(I$23*I$22*I$26*K89,2),0)+IF(L89=$AC$20,ROUND(L$23*L$22*L$26*N89,2),0)+IF(O89=$AC$20,ROUND(O$23*O$22*O$26*Q89,2),0)+IF(R89=$AC$20,ROUND(R$23*R$22*R$26*T89,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H89=\"X\",IF(I89=$AD$20,ROUND(I$23*I$22*I$26*K89,2),0)+IF(L89=$AD$20,ROUND(L$23*L$22*L$26*N89,2),0)+IF(O89=$AD$20,ROUND(O$23*O$22*O$26*Q89,2),0)+IF(R89=$AD$20,ROUND(R$23*R$22*R$26*T89,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H89=\"X\",IF(I89=$AE$20,ROUND(I$23*I$22*I$26*K89,2),0)+IF(L89=$AE$20,ROUND(L$23*L$22*L$26*N89,2),0)+IF(O89=$AE$20,ROUND(O$23*O$22*O$26*Q89,2),0)+IF(R89=$AE$20,ROUND(R$23*R$22*R$26*T89,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QcI.02\nQe.02"," Liquidazione (art.194, comma 1, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},null,{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5}," QcI.03  "," Controllo aggiornamento elaborati di progetto, aggiornamento dei manuali d'uso e manutenzione (art.148, comma 4, d.P.R. 207/2010)  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QcI.04  "," Coordinamento e supervisione dell'ufficio di direzione lavori (art.148, comma 2, d.lgs. 163/06)  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QcI.05  "," Ufficio della direzione lavori, per ogni addetto con qualifica di direttore operativo (art.149, d.lgs. 163/06)  ",null,null,{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},null,{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},null,{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},null,{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QcI.06  "," Ufficio della direzione lavori, per ogni addetto con qualifica di ispettore di cantiere (art.150, d.lgs. 163/06)  ",null,null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.000"},{"v":0.06,"d":"0.060"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5}," QcI.07  "," Variante delle quantita del progetto in corso d'opera (art.161, d.P.R. 207/2010)",null,null,{"v":0,"d":"0.000"},{"v":0.14,"d":"0.140"},null,{"v":0,"d":"0.000"},{"v":0.09,"d":"0.090"},null,{"v":0,"d":"0.000"},{"v":0.15,"d":"0.150"},null,{"v":0,"d":"0.000"},{"v":0.15,"d":"0.150"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QcI.08\nQe.04"," Variante del progetto in corso d'opera (art.161, d.P.R. 207/2010) 10  ",null,null,{"v":0,"d":"0.000"},{"v":0.41,"d":"0.410"},null,{"v":0,"d":"0.000"},{"v":0.43,"d":"0.430"},null,{"v":0,"d":"0.000"},{"v":0.32,"d":"0.320"},null,{"v":0,"d":"0.000"},{"v":0.32,"d":"0.320"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QcI.09\nQe.05"," Contabilita dei lavori a misura (art.185, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.18,"d":"0.180"},null,{"v":0,"d":"0.000"},{"v":0.18,"d":"0.180"},null,{"v":0,"d":"0.000"},{"v":0.13,"d":"0.130"},null,{"v":0,"d":"0.000"},{"v":0.13,"d":"0.130"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5}," QcI.10  "," Contabilita dei lavori a corpo (art.185, d.P.R. 207/10  ",null,null,{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},null,{"v":0,"d":"0.000"},{"v":0.1,"d":"0.100"},null,{"v":0,"d":"0.000"},{"v":0.08,"d":"0.080"},null,{"v":0,"d":"0.000"},{"v":0.08,"d":"0.080"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"QcI.11\nQe.07"," Certificato di regolare esecuzione (art.237, d.P.R. 207/2010)  ",null,null,{"v":0,"d":"0.000"},{"v":0.04,"d":"0.040"},null,{"v":0,"d":"0.000"},{"v":0.04,"d":"0.040"},null,{"v":0,"d":"0.000"},{"v":0.04,"d":"0.040"},null,{"v":0,"d":"0.000"},{"v":0.04,"d":"0.040"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[{"$nulls":5},"QcI.12\nQS.02"," Coordinamento della sicurezza in esecuzione  ",null,{"$f":"IF(H100=\"X\",6,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.25,"d":"0.250"},{"$f":"IF(I100=\"\",\"\",I100)","v":""},{"v":0,"d":"0.000"},{"v":0.25,"d":"0.250"},{"$f":"IF(I100=\"\",\"\",I100)","v":""},{"v":0,"d":"0.000"},{"v":0.25,"d":"0.250"},{"$f":"IF(I100=\"\",\"\",I100)","v":""},{"v":0,"d":"0.000"},{"v":0.25,"d":"0.250"},{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":3},"X","X","X","X"]
[null,"totale incidenze",{"$nulls":3},"∑ Q i",{"$nulls":3},{"$f":"SUM(J89:J100)","v":{"v":0,"d":"0.000"}},{"$f":"J101","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(M89:M100)","v":{"v":0,"d":"0.000"}},{"$f":"M101","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(P89:P100)","v":{"v":0,"d":"0.000"}},{"$f":"P101","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(S89:S100)","v":{"v":0,"d":"0.000"}},{"$f":"S101","v":{"v":0,"d":"0.000"}},{"$nulls":12},{"$f":"I103-SUM(X89:AE100)","v":{"v":0,"d":"0.00 €"}}]
[null,"Compenso al netto di spese ed oneri CNPAIA ",{"$nulls":3},"V*P*G*ΣQ",null,null,{"$f":"K101*I22*I23*I26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"N101*L22*L23*L26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"Q101*O22*O23*O26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"T101*R22*R23*R26","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"eventuale aggiustamento\ndx-sx",null,{"$f":"AG101","v":{"v":0,"d":"0.00 €"}}]
[null,"COMPENSO AL NETTO DELLE SPESE",{"$nulls":6},{"$f":"ROUND(SUM(I102:T102),2)","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I103=SUM(X103:AE103),\"OK\",\"CONTROLLA\")","v":"OK"},{"$f":"SUM(X103:AE103)-I103","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(X89:X102)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[null,"VERIFICHE E COLLAUDI",{"$nulls":21},"VERIFICHE E COLLAUDI"]
[null," Verifiche e Collaudi "," d.I)VERIFICHE E COLLAUDI  ","prestazioni affidate","incidenza Q"," QdI.01  "," Collaudo tecnico amministrativo (Parte II, Titolo X, d.P.R. 207/10) 11  ",null,null,{"$f":"IF($H106=\"x\",IF(AND(I106>0,I106<9),K106,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.08,"d":"0.080"},null,{"$f":"IF($H106=\"x\",IF(AND(L106>0,L106<9),N106,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.08,"d":"0.080"},null,{"$f":"IF($H106=\"x\",IF(AND(O106>0,O106<9),Q106,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.08,"d":"0.080"},{"$nulls":6},{"$f":"IF(H106=\"X\",IF(I106=$X$20,ROUND(I$23*I$22*I$26*K106,2),0)+IF(L106=$X$20,ROUND(L$23*L$22*L$26*N106,2),0)+IF(O106=$X$20,ROUND(O$23*O$22*O$26*Q106,2),0)+IF(R106=$X$20,ROUND(R$23*R$22*R$26*T106,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H106=\"X\",IF(I106=$Y$20,ROUND(I$23*I$22*I$26*K106,2),0)+IF(L106=$Y$20,ROUND(L$23*L$22*L$26*N106,2),0)+IF(O106=$Y$20,ROUND(O$23*O$22*O$26*Q106,2),0)+IF(R106=$Y$20,ROUND(R$23*R$22*R$26*T106,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H106=\"X\",IF(I106=$Z$20,ROUND(I$23*I$22*I$26*K106,2),0)+IF(L106=$Z$20,ROUND(L$23*L$22*L$26*N106,2),0)+IF(O106=$Z$20,ROUND(O$23*O$22*O$26*Q106,2),0)+IF(R106=$Z$20,ROUND(R$23*R$22*R$26*T106,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H106=\"X\",IF(I106=$AA$20,ROUND(I$23*I$22*I$26*K106,2),0)+IF(L106=$AA$20,ROUND(L$23*L$22*L$26*N106,2),0)+IF(O106=$AA$20,ROUND(O$23*O$22*O$26*Q106,2),0)+IF(R106=$AA$20,ROUND(R$23*R$22*R$26*T106,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H106=\"X\",IF(I106=$AB$20,ROUND(I$23*I$22*I$26*K106,2),0)+IF(L106=$AB$20,ROUND(L$23*L$22*L$26*N106,2),0)+IF(O106=$AB$20,ROUND(O$23*O$22*O$26*Q106,2),0)+IF(R106=$AB$20,ROUND(R$23*R$22*R$26*T106,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H106=\"X\",IF(I106=$AC$20,ROUND(I$23*I$22*I$26*K106,2),0)+IF(L106=$AC$20,ROUND(L$23*L$22*L$26*N106,2),0)+IF(O106=$AC$20,ROUND(O$23*O$22*O$26*Q106,2),0)+IF(R106=$AC$20,ROUND(R$23*R$22*R$26*T106,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H106=\"X\",IF(I106=$AD$20,ROUND(I$23*I$22*I$26*K106,2),0)+IF(L106=$AD$20,ROUND(L$23*L$22*L$26*N106,2),0)+IF(O106=$AD$20,ROUND(O$23*O$22*O$26*Q106,2),0)+IF(R106=$AD$20,ROUND(R$23*R$22*R$26*T106,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H106=\"X\",IF(I106=$AE$20,ROUND(I$23*I$22*I$26*K106,2),0)+IF(L106=$AE$20,ROUND(L$23*L$22*L$26*N106,2),0)+IF(O106=$AE$20,ROUND(O$23*O$22*O$26*Q106,2),0)+IF(R106=$AE$20,ROUND(R$23*R$22*R$26*T106,2),0),0)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5}," QdI.02  "," Revisione tecnico contabile (Parte II, Titolo X, d.P.R. 207/10)  ",null,null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},null,{"v":0,"d":"0.000"},{"v":0.02,"d":"0.020"},{"$nulls":6},{"$f":"IF(H107=\"X\",IF(I107=$X$20,ROUND(I$23*I$22*I$26*K107,2),0)+IF(L107=$X$20,ROUND(L$23*L$22*L$26*N107,2),0)+IF(O107=$X$20,ROUND(O$23*O$22*O$26*Q107,2),0)+IF(R107=$X$20,ROUND(R$23*R$22*R$26*T107,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H107=\"X\",IF(I107=$Y$20,ROUND(I$23*I$22*I$26*K107,2),0)+IF(L107=$Y$20,ROUND(L$23*L$22*L$26*N107,2),0)+IF(O107=$Y$20,ROUND(O$23*O$22*O$26*Q107,2),0)+IF(R107=$Y$20,ROUND(R$23*R$22*R$26*T107,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H107=\"X\",IF(I107=$Z$20,ROUND(I$23*I$22*I$26*K107,2),0)+IF(L107=$Z$20,ROUND(L$23*L$22*L$26*N107,2),0)+IF(O107=$Z$20,ROUND(O$23*O$22*O$26*Q107,2),0)+IF(R107=$Z$20,ROUND(R$23*R$22*R$26*T107,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H107=\"X\",IF(I107=$AA$20,ROUND(I$23*I$22*I$26*K107,2),0)+IF(L107=$AA$20,ROUND(L$23*L$22*L$26*N107,2),0)+IF(O107=$AA$20,ROUND(O$23*O$22*O$26*Q107,2),0)+IF(R107=$AA$20,ROUND(R$23*R$22*R$26*T107,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H107=\"X\",IF(I107=$AB$20,ROUND(I$23*I$22*I$26*K107,2),0)+IF(L107=$AB$20,ROUND(L$23*L$22*L$26*N107,2),0)+IF(O107=$AB$20,ROUND(O$23*O$22*O$26*Q107,2),0)+IF(R107=$AB$20,ROUND(R$23*R$22*R$26*T107,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H107=\"X\",IF(I107=$AC$20,ROUND(I$23*I$22*I$26*K107,2),0)+IF(L107=$AC$20,ROUND(L$23*L$22*L$26*N107,2),0)+IF(O107=$AC$20,ROUND(O$23*O$22*O$26*Q107,2),0)+IF(R107=$AC$20,ROUND(R$23*R$22*R$26*T107,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H107=\"X\",IF(I107=$AD$20,ROUND(I$23*I$22*I$26*K107,2),0)+IF(L107=$AD$20,ROUND(L$23*L$22*L$26*N107,2),0)+IF(O107=$AD$20,ROUND(O$23*O$22*O$26*Q107,2),0)+IF(R107=$AD$20,ROUND(R$23*R$22*R$26*T107,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H107=\"X\",IF(I107=$AE$20,ROUND(I$23*I$22*I$26*K107,2),0)+IF(L107=$AE$20,ROUND(L$23*L$22*L$26*N107,2),0)+IF(O107=$AE$20,ROUND(O$23*O$22*O$26*Q107,2),0)+IF(R107=$AE$20,ROUND(R$23*R$22*R$26*T107,2),0),0)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"QdI.04\nQc.04"," Collaudo statico (Capitolo 9, d.m. 14/01/2008)  ",{"$nulls":4},{"$f":"IF(H108=\"X\",7,\"\")","v":""},{"v":0,"d":"0.000"},{"v":0.22,"d":"0.220"},{"$nulls":9},{"$f":"IF(H108=\"X\",IF(I108=$X$20,ROUND(I$23*I$22*I$26*K108,2),0)+IF(L108=$X$20,ROUND(L$23*L$22*L$26*N108,2),0)+IF(O108=$X$20,ROUND(O$23*O$22*O$26*Q108,2),0)+IF(R108=$X$20,ROUND(R$23*R$22*R$26*T108,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H108=\"X\",IF(I108=$Y$20,ROUND(I$23*I$22*I$26*K108,2),0)+IF(L108=$Y$20,ROUND(L$23*L$22*L$26*N108,2),0)+IF(O108=$Y$20,ROUND(O$23*O$22*O$26*Q108,2),0)+IF(R108=$Y$20,ROUND(R$23*R$22*R$26*T108,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H108=\"X\",IF(I108=$Z$20,ROUND(I$23*I$22*I$26*K108,2),0)+IF(L108=$Z$20,ROUND(L$23*L$22*L$26*N108,2),0)+IF(O108=$Z$20,ROUND(O$23*O$22*O$26*Q108,2),0)+IF(R108=$Z$20,ROUND(R$23*R$22*R$26*T108,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H108=\"X\",IF(I108=$AA$20,ROUND(I$23*I$22*I$26*K108,2),0)+IF(L108=$AA$20,ROUND(L$23*L$22*L$26*N108,2),0)+IF(O108=$AA$20,ROUND(O$23*O$22*O$26*Q108,2),0)+IF(R108=$AA$20,ROUND(R$23*R$22*R$26*T108,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H108=\"X\",IF(I108=$AB$20,ROUND(I$23*I$22*I$26*K108,2),0)+IF(L108=$AB$20,ROUND(L$23*L$22*L$26*N108,2),0)+IF(O108=$AB$20,ROUND(O$23*O$22*O$26*Q108,2),0)+IF(R108=$AB$20,ROUND(R$23*R$22*R$26*T108,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H108=\"X\",IF(I108=$AC$20,ROUND(I$23*I$22*I$26*K108,2),0)+IF(L108=$AC$20,ROUND(L$23*L$22*L$26*N108,2),0)+IF(O108=$AC$20,ROUND(O$23*O$22*O$26*Q108,2),0)+IF(R108=$AC$20,ROUND(R$23*R$22*R$26*T108,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H108=\"X\",IF(I108=$AD$20,ROUND(I$23*I$22*I$26*K108,2),0)+IF(L108=$AD$20,ROUND(L$23*L$22*L$26*N108,2),0)+IF(O108=$AD$20,ROUND(O$23*O$22*O$26*Q108,2),0)+IF(R108=$AD$20,ROUND(R$23*R$22*R$26*T108,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H108=\"X\",IF(I108=$AE$20,ROUND(I$23*I$22*I$26*K108,2),0)+IF(L108=$AE$20,ROUND(L$23*L$22*L$26*N108,2),0)+IF(O108=$AE$20,ROUND(O$23*O$22*O$26*Q108,2),0)+IF(R108=$AE$20,ROUND(R$23*R$22*R$26*T108,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"X","X","X"]
[{"$nulls":5},"QdI.05\nQc.05"," Collaudo tecnico funzionale degli impianti (d.m. 22/01/2008 n°37)  ",{"$nulls":8},{"$f":"IF($H109=\"x\",IF(AND(O109>0,O109<9),Q109,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.18,"d":"0.180"},{"$nulls":6},{"$f":"IF(H109=\"X\",IF(I109=$X$20,ROUND(I$23*I$22*I$26*K109,2),0)+IF(L109=$X$20,ROUND(L$23*L$22*L$26*N109,2),0)+IF(O109=$X$20,ROUND(O$23*O$22*O$26*Q109,2),0)+IF(R109=$X$20,ROUND(R$23*R$22*R$26*T109,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H109=\"X\",IF(I109=$Y$20,ROUND(I$23*I$22*I$26*K109,2),0)+IF(L109=$Y$20,ROUND(L$23*L$22*L$26*N109,2),0)+IF(O109=$Y$20,ROUND(O$23*O$22*O$26*Q109,2),0)+IF(R109=$Y$20,ROUND(R$23*R$22*R$26*T109,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H109=\"X\",IF(I109=$Z$20,ROUND(I$23*I$22*I$26*K109,2),0)+IF(L109=$Z$20,ROUND(L$23*L$22*L$26*N109,2),0)+IF(O109=$Z$20,ROUND(O$23*O$22*O$26*Q109,2),0)+IF(R109=$Z$20,ROUND(R$23*R$22*R$26*T109,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H109=\"X\",IF(I109=$AA$20,ROUND(I$23*I$22*I$26*K109,2),0)+IF(L109=$AA$20,ROUND(L$23*L$22*L$26*N109,2),0)+IF(O109=$AA$20,ROUND(O$23*O$22*O$26*Q109,2),0)+IF(R109=$AA$20,ROUND(R$23*R$22*R$26*T109,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H109=\"X\",IF(I109=$AB$20,ROUND(I$23*I$22*I$26*K109,2),0)+IF(L109=$AB$20,ROUND(L$23*L$22*L$26*N109,2),0)+IF(O109=$AB$20,ROUND(O$23*O$22*O$26*Q109,2),0)+IF(R109=$AB$20,ROUND(R$23*R$22*R$26*T109,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H109=\"X\",IF(I109=$AC$20,ROUND(I$23*I$22*I$26*K109,2),0)+IF(L109=$AC$20,ROUND(L$23*L$22*L$26*N109,2),0)+IF(O109=$AC$20,ROUND(O$23*O$22*O$26*Q109,2),0)+IF(R109=$AC$20,ROUND(R$23*R$22*R$26*T109,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H109=\"X\",IF(I109=$AD$20,ROUND(I$23*I$22*I$26*K109,2),0)+IF(L109=$AD$20,ROUND(L$23*L$22*L$26*N109,2),0)+IF(O109=$AD$20,ROUND(O$23*O$22*O$26*Q109,2),0)+IF(R109=$AD$20,ROUND(R$23*R$22*R$26*T109,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H109=\"X\",IF(I109=$AE$20,ROUND(I$23*I$22*I$26*K109,2),0)+IF(L109=$AE$20,ROUND(L$23*L$22*L$26*N109,2),0)+IF(O109=$AE$20,ROUND(O$23*O$22*O$26*Q109,2),0)+IF(R109=$AE$20,ROUND(R$23*R$22*R$26*T109,2),0),0)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"QdI.06\nQc.06"," Attestato di certificazione energetica (art.6 d.lgs. 311/2006) – Attestato di collaudo e certificazioni di qualità  ",null,null,{"$f":"IF($H110=\"x\",IF(AND(I110>0,I110<9),K110,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.05,"d":"0.050"},null,{"$f":"IF($H110=\"x\",IF(AND(L110>0,L110<9),N110,0),0)","v":{"v":0,"d":"0.000"}},{"v":0.05,"d":"0.050"},null,{"v":0,"d":"0.000"},{"v":0.05,"d":"0.050"},{"$nulls":6},{"$f":"IF(H110=\"X\",IF(I110=$X$20,ROUND(I$23*I$22*I$26*K110,2),0)+IF(L110=$X$20,ROUND(L$23*L$22*L$26*N110,2),0)+IF(O110=$X$20,ROUND(O$23*O$22*O$26*Q110,2),0)+IF(R110=$X$20,ROUND(R$23*R$22*R$26*T110,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H110=\"X\",IF(I110=$Y$20,ROUND(I$23*I$22*I$26*K110,2),0)+IF(L110=$Y$20,ROUND(L$23*L$22*L$26*N110,2),0)+IF(O110=$Y$20,ROUND(O$23*O$22*O$26*Q110,2),0)+IF(R110=$Y$20,ROUND(R$23*R$22*R$26*T110,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H110=\"X\",IF(I110=$Z$20,ROUND(I$23*I$22*I$26*K110,2),0)+IF(L110=$Z$20,ROUND(L$23*L$22*L$26*N110,2),0)+IF(O110=$Z$20,ROUND(O$23*O$22*O$26*Q110,2),0)+IF(R110=$Z$20,ROUND(R$23*R$22*R$26*T110,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H110=\"X\",IF(I110=$AA$20,ROUND(I$23*I$22*I$26*K110,2),0)+IF(L110=$AA$20,ROUND(L$23*L$22*L$26*N110,2),0)+IF(O110=$AA$20,ROUND(O$23*O$22*O$26*Q110,2),0)+IF(R110=$AA$20,ROUND(R$23*R$22*R$26*T110,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H110=\"X\",IF(I110=$AB$20,ROUND(I$23*I$22*I$26*K110,2),0)+IF(L110=$AB$20,ROUND(L$23*L$22*L$26*N110,2),0)+IF(O110=$AB$20,ROUND(O$23*O$22*O$26*Q110,2),0)+IF(R110=$AB$20,ROUND(R$23*R$22*R$26*T110,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H110=\"X\",IF(I110=$AC$20,ROUND(I$23*I$22*I$26*K110,2),0)+IF(L110=$AC$20,ROUND(L$23*L$22*L$26*N110,2),0)+IF(O110=$AC$20,ROUND(O$23*O$22*O$26*Q110,2),0)+IF(R110=$AC$20,ROUND(R$23*R$22*R$26*T110,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H110=\"X\",IF(I110=$AD$20,ROUND(I$23*I$22*I$26*K110,2),0)+IF(L110=$AD$20,ROUND(L$23*L$22*L$26*N110,2),0)+IF(O110=$AD$20,ROUND(O$23*O$22*O$26*Q110,2),0)+IF(R110=$AD$20,ROUND(R$23*R$22*R$26*T110,2),0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H110=\"X\",IF(I110=$AE$20,ROUND(I$23*I$22*I$26*K110,2),0)+IF(L110=$AE$20,ROUND(L$23*L$22*L$26*N110,2),0)+IF(O110=$AE$20,ROUND(O$23*O$22*O$26*Q110,2),0)+IF(R110=$AE$20,ROUND(R$23*R$22*R$26*T110,2),0),0)","v":{"v":0,"d":"0.00 €"}}]
[null,"totale incidenze",{"$nulls":3},"∑ Q i",{"$nulls":3},{"$f":"SUM(J106:J110)","v":{"v":0,"d":"0.000"}},{"$f":"J111","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(M106:M110)","v":{"v":0,"d":"0.000"}},{"$f":"M111","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(P106:P110)","v":{"v":0,"d":"0.000"}},{"$f":"P111","v":{"v":0,"d":"0.000"}},null,{"$f":"SUM(S106:S110)","v":{"v":0,"d":"0.000"}},{"$f":"S111","v":{"v":0,"d":"0.000"}},{"$nulls":12},{"$f":"I113-SUM(X106:AE110)","v":{"v":0,"d":"0.00 €"}}]
[null,"Compenso al netto di spese ed oneri CNPAIA",{"$nulls":3},"V*P*G*ΣQ",null,null,{"$f":"K111*I22*I23*I26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"N111*L22*L23*L26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"Q111*O22*O23*O26","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"T111*R22*R23*R26","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},"eventuale aggiustamento\ndx-sx",null,{"$f":"AG111","v":{"v":0,"d":"0.00 €"}}]
[null,"COMPENSO AL NETTO DELLE SPESE",{"$nulls":6},{"$f":"ROUND(SUM(I112:T112),2)","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I113=SUM(X113:AE113),\"OK\",\"CONTROLLA\")","v":"OK"},{"$f":"SUM(X113:AE113)-I113","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(X106:X112)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Y106:Y112)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[null,"progetto preliminare",{"$nulls":6},{"$f":"I48","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I115=SUM(X115:AE115),\"OK\",\"CONTROLLA\")","v":"OK"},null,{"$f":"X48","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"progetto definitivo",{"$nulls":6},{"$f":"I74","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I116=SUM(X116:AE116),\"OK\",\"CONTROLLA\")","v":"OK"},null,{"$f":"X74","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"progetto esecutivo",{"$nulls":6},{"$f":"I86","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I117=SUM(X117:AE117),\"OK\",\"CONTROLLA\")","v":"OK"},null,{"$f":"X86","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"COMPENSO FASE PROGETTAZIONE",{"$nulls":6},{"$f":"SUM(I115:T117)","v":{"v":0,"d":"0.00 €"}},{"$nulls":14},{"$f":"SUM(X115:X117)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(Y115:Y117)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"COMPENSO FASE ESECUZIONE",{"$nulls":6},{"$f":"I103","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I119=SUM(X119:AE119),\"OK\",\"CONTROLLA\")","v":"OK"},null,{"$f":"X103","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"COMPENSO VERIFICHE E COLLAUDI",{"$nulls":6},{"$f":"I113","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I120=SUM(X120:AE120),\"OK\",\"CONTROLLA\")","v":"OK"},null,{"$f":"X113","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[null,"TOTALE COMPENSO",{"$nulls":6},{"$f":"I118+I119+I120","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I122=SUM(X122:AE122),\"OK\",\"CONTROLLA\")","v":"OK"},null,{"$f":"X120+X119+X118","v":{"v":0,"d":"0.00 €"}},{"$f":"Y120+Y119+Y118","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[null,"Riduzione del compenso \n(min secondo ordinanza 108/2020)",{"$nulls":5},{"v":0.3,"d":"30%"},{"$f":"-H124*(I118+I119+I120)","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"$f":"IF(I124=SUM(X124:AE124),\"OK\",\"CONTROLLA\")","v":"OK"},null,{"$f":"-X122*0.3","v":{"v":0,"d":"0.00 €"}},{"$f":"-Y122*0.3","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"RSL",{"$nulls":3},"Prestazione all’analisi della risposta sismica locale. Comprensiva di tutte le attività inerenti la definizione del modello geologico e sismostratigrafico con indicati i parametri necessari per la definizione dell’azione sismica di progetto e l’eventuale verifica di cui all’ordinanza n. 55. Pari a 0,5% del valore dell'opera.",{"$nulls":3},{"$f":"IF($H125=\"x\",IF(AND(I125>0,I125<9),K125,0),0)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(I22:T22)*0.005","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(H125=\"X\",IF(I125=1,J125,0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H125=\"X\",IF(I125=2,J125,0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H125=\"X\",IF(I125=3,J125,0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H125=\"X\",IF(I125=4,J125,0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H125=\"X\",IF(I125=5,J125,0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H125=\"X\",IF(I125=6,J125,0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H125=\"X\",IF(I125=7,J125,0),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(H125=\"X\",IF(I125=8,J125,0),0)","v":{"v":0,"d":"0.00 €"}}]
[null,"SPESE SU COMPENSO\n(max secondo ordinanza 108)",{"$nulls":5},{"$f":"IF(SUM(I22:T22)<=500000,20%,IF(SUM(I22:T22)<=2500000,15%,IF(SUM(I22:T22)<=5000000,10%,8%)))","v":{"v":0.2,"d":"20%"}},{"$f":"H126*I128","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"TOTALE CORRISPETTIVO  SOGGETO A IVA E CNPAIA",{"$nulls":6},{"$f":"I122+I124+J125","v":{"v":0,"d":"0.00 €"}},{"$nulls":12},{"$f":"IF(I128=SUM(X128:AE128),\"OK\",\"CONTROLLA\")","v":"OK"},null,{"$f":"X122+X124+X125","v":{"v":0,"d":"0.00 €"}},{"$f":"Y122+Y124+Y125","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"MASSIME SPESE RENDICONTABILI IN SEDE DI SAL",{"$nulls":6},{"$f":"I126","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"(1) L'importo del corrispettivo è inteso al netto degli oneri fiscali e previdenziali dovuti, come previsto da regime fiscale di riferimento"]

{"sheet":"Tabella-Z1","index":1,"n_rows":38,"n_cols":18,"rows_kept":38,"hidden":true,"merged":[[0,0,0,3],[1,0,2,0],[1,1,2,1],[1,2,1,3],[3,0,10,0],[11,0,13,0],[14,0,19,0],[20,0,23,0],[24,0,25,0],[26,0,28,0],[29,0,32,0],[33,0,36,0]]}
["TAVOLA Z-1 “CATEGORIE DELLE OPERE E PARAMETRO DEL GRADO DI COMPLESSITA’”"]
["CATEGORIA D'OPERA","DESTINAZIONE FUNZIONALE DELLE OPERE","Grado di complessità G"]
[null,null,"Ridotto ","Elevato","media","Nota",null,null,1,2,3,4,5,6,7,8,9,10]
["EDILIZIA","E1-INSEDIAMENTI PRODUTTIVI PER L'AGRICOLTURA, L'INDUSTRIA, L'ARTIGIANATO-DEPOSITI",0.7,{"v":1,"d":"1.0"},{"$f":"AVERAGE(C4:D4)","v":{"v":0.85,"d":"0.9"}},{"$f":"CONCATENATE(\"(\",C4,\"-\",E4,\"-\",D4,\")\")","v":"(0.7-0.85-1)"},null,"E1",0.7,0.8,0.9,{"v":1,"d":"1.0"}]
[null,"E2-INDUSTRIA ALBERGHIERA, TURISMO E COMMERCIO E SERVIZI PER LA MOBILITA'",{"v":1,"d":"1.0"},1.3,{"$f":"AVERAGE(C5:D5)","v":{"v":1.15,"d":"1.2"}},{"$f":"CONCATENATE(\"(\",C5,\"-\",E5,\"-\",D5,\")\")","v":"(1-1.15-1.3)"},null,"E2",{"v":1,"d":"1.0"},1.1,1.2,1.3]
[null,"E3-RESIDENZA",0.7,1.3,{"v":1,"d":"1.0"},"(0.7-1-1.3)",null,"E3",0.7,0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2,1.3]
[null,"E4-SANITA', ISTRUZIONE, RICERCA",{"v":1,"d":"1.0"},1.3,{"v":1.15,"d":"1.2"},"(1-1.15-1.3)",null,"E4",{"v":1,"d":"1.0"},1.1,1.2,1.3]
[null,"E5-CULTURA, VITA SOCIALE, SPORT, CULTO",{"v":1,"d":"1.0"},1.3,{"v":1.15,"d":"1.2"},"(1-1.15-1.3)",null,"E5",{"v":1,"d":"1.0"},1.1,1.2,1.3]
[null,"E6-SEDI AMMINISTRATIVE, GIUDIZIARIE, DELLE FORZE DELL'ORDINE",0.7,1.3,{"v":1,"d":"1.0"},"(0.7-1-1.3)",null,"E6",0.7,0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2,1.3]
[null,"E7-ARREDI, FORNITURE, AREE ESTERNE PERTINENZIALI ALLESTITE",{"v":1,"d":"1.0"},1.3,{"v":1.15,"d":"1.2"},"(1-1.15-1.3)",null,"E7",{"v":1,"d":"1.0"},1.1,1.2,1.3]
[null,"E8-INTERVENTI SU EDIFICI E MANUFATTI DI RILEVANTE INTERESSE STORICO-ARTISTICO E MONUMENTALE",1.3,1.6,{"v":1.4500000000000002,"d":"1.5"},"(1.3-1.45-1.6)",null,"E8",1.3,1.4,1.5,1.6]
["STRUTTURE","S1-STRUTTURE, OPERE INFRASTRUTTURALI PUNTUALI, VERIFICHE NON SOGGETTE AD AZIONI SISMICHE",0.8,{"v":1,"d":"1.0"},0.9,"(0.8-0.9-1)",null,"S1",0.8,0.9,{"v":1,"d":"1.0"}]
[null,"S2-STRUTTURE, OPERE INFRASTRUTTURALI PUNTUALI, VERIFICHE SOGGETTE AD AZIONI SISMICHE ",{"v":1,"d":"1.0"},1.2,1.1,"(1-1.1-1.2)",null,"S2",{"v":1,"d":"1.0"},1.1,1.2]
[null,"S3-STRUTTURE SPECIALI",1.2,1.3,{"v":1.25,"d":"1.3"},"(1.2-1.25-1.3)",null,"S3",1.2,1.3]
["IMPIANTI","I1-IMPIANTI MECCANICI A FLUIDO A SERVIZIO DELLE COSTRUZIONI",0.8,1.1,{"v":0.9500000000000001,"d":"1.0"},"(0.8-0.95-1.1)",null,"I1",0.8,0.9,{"v":1,"d":"1.0"},1.1]
[null,"I2-IMPIANTI ELETTRICI E SPECIALI A SERVIZIO DELLE COSTRUZIONI – SINGOLE APPARECCHIATURE PER LABORATORI E IMPIANTI PILOTA",1.1,1.3,{"v":1.2000000000000002,"d":"1.2"},"(1.1-1.2-1.3)",null,"I2",1.1,1.2,1.3]
[null,"I3-IMPIANTI INDUSTRIALI - IMPIANTI PILOTA E IMPIANTI DI DEPURAZIONE CON RIDOTTE PROBLEMATICHE TECNICHE-DISCARICHE INERTI",0.6,0.8,0.7,"(0.6-0.7-0.8)",null,"I3",0.6,0.7,0.8]
[null,"I4-IMPIANTI INDUSTRIALI – IMPIANTI PILOTA E IMPIANTI DI DEPURAZIONE COMPLESSI-DISCARICHE CON TRATTAMENTI E TERMOVALORIZZATORI",0.8,1.2,{"v":1,"d":"1.0"},"(0.8-1-1.2)",null,"I4",0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2]
[null,"I5-OPERE ELETTRICHE PER RETI DI TRASMISSIONE E DISTRIBUZIONE ENERGIA E SEGNALI – LABORATORI CON TRATTAMENTI E TERMOVALORIZZATORI",0.6,0.9,{"v":0.75,"d":"0.8"},"(0.6-0.75-0.9)",null,"I5",0.6,0.7,0.8,0.9]
[null,"I6-IMPANTI PER LA PRODUZIONE DI ENERGIA – LABORATORI COMPLESSI",0.9,1.1,{"v":1,"d":"1.0"},"(0.9-1-1.1)",null,"I6",0.9,{"v":1,"d":"1.0"},1.1]
["VIABILITA'","V1-MANUTENZIONE",0.4,0.5,{"v":0.45,"d":"0.5"},"(0.4-0.45-0.5)",null,"V1",0.4,0.5]
[null,"V2-VIABILITA' ORDINARIA",0.5,0.7,0.6,"(0.5-0.6-0.7)",null,"V2",0.5,0.6,0.7]
[null,"V3-NAVIGAZIONE INTERNA",0.7,0.9,0.8,"(0.7-0.8-0.9)",null,"V3",0.7,0.8,0.9]
[null,"V4-VIABILITA' SPECIALE",0.9,{"v":1,"d":"1.0"},{"v":0.95,"d":"1.0"},"(0.9-0.95-1)",null,"V4",0.9,{"v":1,"d":"1.0"}]
["IDRAULICA","D1-OPERE DI BONIFICA E DERIVAZIONI",0.4,0.6,0.5,"(0.4-0.5-0.6)",null,"D1",0.4,0.5,0.6]
[null,"D2-ACQUEDOTTI E FOGNATURE",0.6,0.8,0.7,"(0.6-0.7-0.8)",null,"D2",0.6,0.7,0.8]
["TIC","T1-SISTEMI INFORMATIVI",0.9,1.1,{"v":1,"d":"1.0"},"(0.9-1-1.1)",null,"T1",0.9,{"v":1,"d":"1.0"},1.1]
[null,"T2-SISTEMI E RETI DI TELECOMUNICAZIONE",0.7,0.9,0.8,"(0.7-0.8-0.9)",null,"T2",0.7,0.8,0.9]
[null,"T3-SISTEMI ELETTRONICI ED AUTOMAZIONE",1.1,1.3,{"v":1.2000000000000002,"d":"1.2"},"(1.1-1.2-1.3)",null,"T3",1.1,1.2,1.3]
["PAESAGGIO, AMBIENTE, NATURALIZZAZIONE","P1-INTERVENTI DI SISTEMAZIONE NATURALISTICA O PAESAGGISTICA",0.8,1.2,{"v":1,"d":"1.0"},"(0.8-1-1.2)",null,"P1",0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2]
[null,"P2-INTERVENTI DEL VERDE E OPERE PER ATTIVITÀ RICREATIVA O SPORTIVA",0.7,1.1,0.9,"(0.7-0.9-1.1)",null,"P2",0.7,0.8,0.9,{"v":1,"d":"1.0"},1.1]
[null,"P3-INTERVENTI RECUPERO, RIQUALIFICAZIONE AMBIENTALE",0.9,1.3,1.1,"(0.9-1.1-1.3)",null,"P3",0.9,{"v":1,"d":"1.0"},1.1,1.2,1.3]
[null,"P4-INTERVENTI DI SFRUTTAMENTO DI CAVE E TORBIERE",0.8,1.3,{"v":1.05,"d":"1.1"},"(0.8-1.05-1.3)",null,"P4",0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2,1.3]
["AGRICOLTURA E FORESTE, SICUREZZA ALIMENTARE","A1-INTERVENTI DI MIGLIORAMENTO E QUALIFICAZIONE DELLA FILIERA FORESTALE",0.7,1.2,{"v":0.95,"d":"1.0"},"(0.7-0.95-1.2)",null,"A1",0.7,0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2]
[null,"A2-INTERVENTI DI MIGLIORAMENTO FONDIARIO AGRARIO E RURALE; INTERVENTI DI PIANIFICAZIONE ALIMENTARE",0.9,1.3,1.1,"(0.9-1.1-1.3)",null,"A2",0.9,{"v":1,"d":"1.0"},1.1,1.2,1.3]
[null,"A3-INTERVENTI PER LA VALORIZZAZIONE DELLE FILIERE PRODUTTIVE AGROALIMENTARI E ZOOTECNICHE; INTERVENTI DI CONTROLLO – VIGILANZA ALIMENTARE",0.8,1.2,{"v":1,"d":"1.0"},"(0.8-1-1.2)",null,"A3",0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2]
[null,"A4-INTERVENTI PER LA VALORIZZAZIONE DELLA FILIERA NATURALISTICA E FAUNISTICA",0.7,1.6,{"v":1.15,"d":"1.2"},"(0.7-1.15-1.6)",null,"A4",0.7,0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2,1.3,1.4,1.5,1.6]
["TERRITORIO E URBANISTICA","U1-INTERVENTI DI PIANIFICAZIONE",0.8,1.5,{"v":1.15,"d":"1.2"},"(0.8-1.15-1.5)",null,"U1",0.8,0.9,{"v":1,"d":"1.0"},1.1,1.2,1.3,1.4,1.5]