{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["0_Anagrafica Gara","1_Scomposizione TOL","2_DB Indici ISTAT","3_Calcolo Periodo SAL","4_Registro Revisioni","5_dati scaricati da istat"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":6,"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":"0_Anagrafica Gara","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DATI GENERALI DI COMMESSA E PARAMETRI REVISIONE"]
[]
[null,"Opera / Oggetto:",null,"INSERIRE TITOLO "]
[null,"CUP:",null,"INSERISCI CUP"]
[null,"CIG:",null,"INSERISCI CIG"]
[null,"Mese Presentazione Offerta (Gara):",null,"2025-01"]
[null,"Soglia Alea / Franchigia:",null,0.03]
[null,"Quota di Compensazione (90%):",null,0.9]
[null,"INDICE SINTETICO DI PARTENZA Ismo:",null,100]
[]
[]
[]
[null,null,null,"celle da non toccare automatiche"]
[null,null,null,"celle da compilare a cura del Progettista/DL"]
[null,null,null,"5_dati scaricati da istat","foglio da aggiornare ad ogni sal "]

{"sheet":"1_Scomposizione TOL","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["SCOMPOSIZIONE DELL'OPERA IN TIPOLOGIE OMOGENEE (TOL)",null,"mese gara ","2025-01"]
[]
["Codice TOL","Descrizione Tipologia Omogenea","Importo da Computo (€)","Peso % (Wi)","Indice ISTAT Gara","Ismo Convenzionale"]
["TOL-01","Opere edili su edifici e manufatti non soggetti a tutela dei beni \nculturali ",20000,{"$f":"C5/$C$25","v":5.865102639296188E-2},{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A5, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":101.4},100]
["TOL-02","Opere edili su edifici e manufatti soggetti a tutela dei beni culturali  ",25000,7.331378299120235E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A6, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":102},100]
["TOL-03","Scavi archeologici, restauri specialistici di beni del patrimonio culturale e di interesse storico",50000,0.1466275659824047,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A7, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":102.1},100]
["TOL-04","Lavori di movimento terra, demolizioni, opere di protezione ambientale, ingegneria naturalistica e opere a verde",5000,1.466275659824047E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A8, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":99.6},100]
["TOL-05","Pavimentazioni in conglomerato bituminoso",25000,7.331378299120235E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A9, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":100},100]
["TOL-06","Strutture, opere di ingegneria e manufatti in acciaio",12000,3.519061583577713E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A10, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":86.8},100]
["TOL-07","Strutture, opere di ingegneria e manufatti in calcestruzzo armato, anche prefabbricato",5000,1.466275659824047E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A11, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":95},100]
["TOL-08","Strutture, opere di ingegneria e manufatti in legno",5000,1.466275659824047E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A12, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":102.9},100]
["TOL-09","Gallerie e opere d'arte nel sottosuolo realizzate con metodo tradizionale",5000,1.466275659824047E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A13, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":92.7},100]
["TOL-10","Gallerie e opere d'arte nel sottosuolo realizzate con metodo meccanizzato",5000,1.466275659824047E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A14, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":94.1},100]
["TOL-11","Acquedotti, gasdotti, opere di irrigazione e fognature",5000,1.466275659824047E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A15, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":100},100]
["TOL-12","Opere marittime e lavori di dragaggio, opere fluviali e di difesa del suolo",78000,0.22873900293255131,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A16, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":91.6},100]
["TOL-13","Impianti per la produzione, trasformazione e distribuzione di energia elettrica in alta e media tensione per la trazione elettrica e l'illuminazione pubblica",1500,4.3988269794721412E-3,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A17, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":105.7},100]
["TOL-14","Impianti elettrici, tecnologici, radiotelefonici e antintrusione",10000,2.932551319648094E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A18, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":104.4},100]
["TOL-15","Impianti meccanici, termici, di condizionamento, idrico sanitari e trasportatori",15000,4.398826979472141E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A19, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":104.7},100]
["TOL-16","Impianti di potabilizzazione e depurazione",15000,4.398826979472141E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A20, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":103.2},100]
["TOL-17","Impianti di segnalamento, sicurezza del traffico e telecomunicazioni",12000,3.519061583577713E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A21, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":106.7},100]
["TOL-18","Armamento ferroviario",35000,0.10263929618768329,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A22, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":100.4},100]
["TOL-19","Opere di fondazione speciale, indagini geologiche e geotecniche",500,1.4662756598240469E-3,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A23, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":96.6},100]
["TOL-20","Conferimento rifiuti a impianto di smaltimento o recupero",12000,3.519061583577713E-2,{"$f":"VLOOKUP($D$2, '2_DB Indici ISTAT'!$A$5:$U$500, MATCH(A24, '2_DB Indici ISTAT'!$A$4:$U$4, 0), FALSE)","v":106.7},100]
[null,"TOTALE DI CONTRATTO",{"$f":"SUM(C5:C24)","v":341000},{"$f":"SUM(D5:D24)","v":0.99999999999999978}]

{"sheet":"2_DB Indici ISTAT","index":2,"n_rows":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
["MATRICE STORICA INDICI ISTAT (VALORI STORICI REALI)"]
[]
["Mese","TOL-01","TOL-02","TOL-03","TOL-04","TOL-05","TOL-06","TOL-07","TOL-08","TOL-09","TOL-10","TOL-11","TOL-12","TOL-13","TOL-14","TOL-15","TOL-16","TOL-17","TOL-18","TOL-19","TOL-20"]
["2022-01",90.9,93.2,96.2,91.3,88.6,92.9,91,95.2,91,92.1,92,89.1,95.2,96.4,95.8,93.9,97.3,91.9,90.3,99.5]
["2022-02",91.6,93.4,96.1,92.8,89.3,93.8,91.9,95.6,91.5,91.7,93.3,90.7,96.2,97.1,95.9,94.8,97.8,92.8,91.5,99.5]
["2022-03",96.7,98.1,99.5,100,99.3,109.6,100.2,98.9,100.1,99.7,99,103.2,99.4,99,97.9,98,99.5,100.4,98.5,99.5]
["2022-04",98,99.3,99.6,99.8,100.4,115.1,104,99.8,103.5,102,100.2,107.3,99.5,99,98.7,97.9,100,99.7,99.7,99.8]
["2022-05",99.1,99.9,99.7,100.8,100.5,108.5,104,100.2,103.8,101.5,100.8,106.6,99.8,99.3,99.5,98.4,100.5,100.2,102,99.8]
["2022-06",100.2,100.3,100.4,103.3,103,102.5,101.4,100.1,102,100,101.6,105.8,101.4,100.4,100.6,100.1,100.6,104.1,101.9,99.8]
["2022-07",102.5,101.5,101.6,102.9,104.2,100.4,100.9,101.3,102.2,102.3,102.3,102.4,101.8,101.6,101.4,102.4,100.9,103.5,103.5,100.2]
["2022-08",104.6,102.7,102,101.4,104.2,101.1,102.1,101.4,103,105.2,102.9,100,101.6,102.8,102.8,103.7,100.3,101.2,103.8,100.2]
["2022-09",104.7,103.3,101.6,101.6,103.2,99.8,103.2,101.7,103.2,104.8,102.8,100.7,101.7,102.5,102.6,103.7,101.2,101.3,103.2,100.2]
["2022-10",103.2,102.8,101.2,103.3,103.4,93.9,101.2,102.4,100.8,100.1,102.1,100.6,101.4,100,101.3,102.2,100.7,103.1,101.8,100.5]
["2022-11",103.8,102.6,101.2,102.9,102.2,91.3,100.4,102.1,99.9,99.8,102,98.8,101.3,100.5,101.6,102.4,100.4,102.5,102.4,100.5]
["2022-12",104.7,102.9,101.1,100,101.7,91,99.8,101.3,99,100.6,101.2,94.8,100.8,101.5,101.9,102.5,100.8,99.3,101.3,100.5]
["2023-01",103.1,102.6,100.8,100.5,102,91.3,99.6,100.3,97.6,98.4,101,95.9,101.3,101.1,101.3,101.6,101.2,100.3,100.4,102.7]
["2023-02",102.7,102.4,100.8,100.1,101,92.6,98.5,100.2,96.4,97.1,100.6,95.5,101.5,100.6,100.7,101.1,102,99.6,99.6,102.7]
["2023-03",102,102.2,100.7,99.5,100.3,93.1,97.5,100.5,95.5,96,99.8,94.8,101.2,101,100.8,100.7,102.3,98.9,98.5,102.7]
["2023-04",101.8,102,100.5,98.7,99.5,93.9,97.7,100.5,95.4,95.9,99.5,94.6,101.6,101.9,101,100.8,101.8,98.4,98.2,102.5]
["2023-05",100.8,101.4,100.1,97.1,98.1,90.8,96,99.9,93.7,94,98.3,92.9,100.9,100.6,100.8,100.6,101.5,96.7,96.5,102.5]
["2023-06",100.3,101.1,100,97.2,98.1,88.2,95.3,99.8,92.9,93.5,98.4,92.3,102.6,102.2,102.7,102.5,103.4,96.7,96.2,102.5]
["2023-07",100.9,102,101.4,98.1,99.2,88,95.4,100.2,92.9,93.4,98.8,91.9,103.4,102.1,102.9,101.8,103.1,97.7,96.5,102.4]
["2023-08",100.9,102,101.6,100.1,99.2,88,95.5,100.2,93.1,93.6,99.4,93.4,104,101.9,102.7,102.6,103.2,100.2,97.4,102.4]
["2023-09",100.7,102,101.7,101,99.8,87,94.6,100.6,92.4,92.6,99.4,93.7,104.1,102.2,102.2,101.2,103.2,101.1,97.5,102.4]
["2023-10",100.5,101.7,101.8,100.6,100.4,85.5,93.7,100.7,91.8,92.5,99.1,92.8,104,103,103,101.8,102.9,101.1,97,102.6]
["2023-11",100.1,101.4,101.6,99.4,99.6,86.3,93.7,100.1,91.5,92.5,98.7,91.9,103.6,102.4,102.5,101,102.6,99.8,96,102.6]
["2023-12",99.9,101.3,101.5,98.5,98.9,87.1,94.7,99.9,92.1,93.1,98.6,91.5,103.2,103,101.8,99.8,102.6,98.6,95.9,102.6]
["2024-01",99.7,101.2,101.1,98.6,98.4,88.5,94.5,100.3,91.6,91.8,98.6,92.1,103.6,102.5,101.9,99.2,102.4,98.9,95.6,104.2]
["2024-02",99.3,101,101.3,100.1,98.8,88.1,94.4,100.7,91.5,91.7,98.7,92.9,103.7,101.9,101.7,99.3,102.9,100.9,95.9,104.2]
["2024-03",99.4,100.9,101.6,100.3,98.9,86.4,93.7,100.9,91.2,92,98.6,92.7,103.8,102.1,101.4,100,102.7,101.4,95.8,104.2]
["2024-04",99,100.8,101.2,99.8,98.9,85,93.5,101.3,90.7,90.9,98.6,92.3,103.9,101.9,101.7,100.1,103.3,100.5,95.7,104.3]
["2024-05",99.4,100.9,101,98.7,98.3,85.3,93.7,101.1,90.7,91,98.4,91.5,103.8,101.6,102,99.9,103.4,98.6,95.4,104.3]
["2024-06",99.7,101.1,101.1,98.2,98.5,86.7,94.5,101.3,91.1,91.8,98.9,91.5,105.6,103.6,104.3,101.8,106.3,97.9,95.4,104.3]
["2024-07",100.1,101.4,101.3,98.9,99.2,86.8,94.3,101.1,91.4,91.8,99.2,91.8,105.5,103.7,104.5,102,106.4,98.8,96.1,104.4]
["2024-08",100.3,101.2,101.4,98,99,86.8,94.1,101,91.4,92.1,99.1,91.2,105.4,103.8,104.3,101.8,106.1,97.8,95.9,104.4]
["2024-09",99.9,100.9,101.2,97.2,98.6,85.6,93,101.1,90.6,91.1,98.4,90.4,104.8,103.8,104.1,101.1,105.9,96.9,94.7,104.4]
["2024-10",99.7,101,101.1,97,98.1,84.7,92.6,102,90.3,90.6,98.3,89.7,105.1,103.9,103.9,101,106.5,96.8,94.5,104.5]
["2024-11",100.4,101.1,101.6,97.6,98.8,85.3,92.9,102.2,90.8,92,98.5,89.8,105.1,103.7,104.3,101.4,106.4,98,95.1,104.5]
["2024-12",100.6,101.3,101.6,97.9,98.7,86.1,93.6,102.4,91.4,92.7,98.9,90.2,105.4,104,104.3,101.8,106.6,98.4,95.4,104.5]
["2025-01",101.4,102,102.1,99.6,100,86.8,95,102.9,92.7,94.1,100,91.6,105.7,104.4,104.7,103.2,106.7,100.4,96.6,106.7]
["2025-02",103,104.3,105.1,100.8,100.7,88,96.2,104.5,93.8,95.1,101.3,91.9,105.9,104.5,104.7,103.5,106.1,101.3,98,106.7]
["2025-03",102.3,103.9,104.4,99.6,99.8,87.4,95.3,104.3,92.5,92.7,100.3,91,105.3,103.8,104.2,102.8,106,99.5,96.6,106.7]
["2025-04",101.3,103.3,104.2,98.6,98.3,86.8,95.2,104,92.2,92.1,99.9,90.1,105.5,103.8,104,102.3,106.5,98.1,96.2,107.1]
["2025-05",100.9,103,103.9,97.9,98.6,86,93.8,103.9,91.1,90.8,99.2,89.3,104.9,103.3,103.5,102.2,105.8,97.3,95.1,107.1]
["2025-06",101.6,103.4,104.6,98.7,99.5,86,93.2,104.5,91.1,91.6,99.4,89.4,105.6,104.3,104.1,103.4,106.5,98.9,95.6,107.1]
["2025-07",101.7,103.6,104.6,99.2,99.8,84.7,93.4,104.4,91.1,91.5,99.6,89.5,105.6,103.7,104.1,103.1,106.3,99.1,95.5,107.1]
["2025-08",101.6,103.7,104.6,98.9,99.3,84.8,94.4,104.3,91.6,92.2,99.8,89.2,105.3,103.8,103.5,102.5,106.2,98.4,95.4,107.1]
["2025-09",101.7,103.7,104.7,99.1,98.9,85,93.8,104.8,91.2,91.8,99.7,89.1,105.4,103.4,103.4,102.5,105.6,98.8,95.3,107.2]
["2025-10",101.2,103.4,104.6,98.6,98.9,85.8,93.4,105,90.7,91.3,99.5,88.7,105.6,103.7,103.7,102.7,105.8,98.4,94.9,107.2]
["2025-11",101.7,103.8,104.8,100.1,99.2,86.9,95.1,105.4,91.9,92.9,100.5,90.4,106,103.8,103.6,103.2,106.2,99.9,96.3,107.2]
["2025-12",101.4,103.9,104.7,99.4,99.1,87.2,95.1,105.3,91.7,92.7,100.3,90.3,106.1,104.2,104,103,107.6,99.2,95.7,107.2]
["2026-01",102.1,103.9,105.1,99.5,99.1,89,95.3,106.2,92.3,93.7,100.7,91.4,106.1,104.4,104.5,103.5,107.9,99.1,96.8,108]
["2026-02",101.9,104.1,104.8,100.3,99.1,89.4,96.2,106.7,92.9,93.5,101,92.4,106.5,104.1,104.6,103.6,108.4,99.7,97.6,108]
["2026-03",104.7,107.2,107.6,107.8,105.7,92.5,100.7,109.1,97.1,96.8,105.8,98.4,109.2,106,105.5,106.3,109.1,107.6,103.7,108]
["2026-04",105.1,108,108.1,112.3,110,92.5,104,110,99.3,98.6,108.2,102,110.4,106.7,105.5,106.7,108.4,112,106,109.5]
["2026-05",105.3,108.2,108.3,110.4,109.3,92.2,104.2,110.1,99.4,99,108.2,100.2,110.3,107.1,106.7,107.6,109.6,109.7,105.4,109.5]

{"sheet":"3_Calcolo Periodo SAL","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["CALCOLO INDICE DI PERIODO (CASO SAL PLURIMENSILE)"]
[]
["Inizio Periodo SAL:","2026-04"]
["Fine Periodo SAL:","2026-05"]
[]
["Codice TOL","Descrizione Lavorazione","Peso Wi","media indici arco temporale SAL","indice riponderato ","quota ponderata finalizzata"]
["TOL-01","Opere edili su edifici e manufatti non soggetti a tutela dei beni \nculturali ",{"$f":"'1_Scomposizione TOL'!D5","v":5.865102639296188E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A8, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":105.19999999999999},{"$f":"(D8 / '1_Scomposizione TOL'!$E5)*100","v":103.74753451676526},{"$f":"C8*E8","v":6.0848993851475228}]
["TOL-02","Opere edili su edifici e manufatti soggetti a tutela dei beni culturali  ",{"$f":"'1_Scomposizione TOL'!D6","v":7.331378299120235E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A9, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":108.1},{"$f":"(D9 / '1_Scomposizione TOL'!$E6)*100","v":105.98039215686275},7.7698234719107591]
["TOL-03","Scavi archeologici, restauri specialistici di beni del patrimonio culturale e di interesse storico",{"$f":"'1_Scomposizione TOL'!D7","v":0.1466275659824047},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A10, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":108.19999999999999},{"$f":"(D10 / '1_Scomposizione TOL'!$E7)*100","v":105.9745347698335},15.538788089418402]
["TOL-04","Lavori di movimento terra, demolizioni, opere di protezione ambientale, ingegneria naturalistica e opere a verde",{"$f":"'1_Scomposizione TOL'!D8","v":1.466275659824047E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A11, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":111.35},{"$f":"(D11 / '1_Scomposizione TOL'!$E8)*100","v":111.79718875502007},1.6392549670824059]
["TOL-05","Pavimentazioni in conglomerato bituminoso",{"$f":"'1_Scomposizione TOL'!D9","v":7.331378299120235E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A12, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":109.65},{"$f":"(D12 / '1_Scomposizione TOL'!$E9)*100","v":109.65},8.0388563049853374]
["TOL-06","Strutture, opere di ingegneria e manufatti in acciaio",{"$f":"'1_Scomposizione TOL'!D10","v":3.519061583577713E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A13, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":92.35},{"$f":"(D13 / '1_Scomposizione TOL'!$E10)*100","v":106.39400921658986},3.7440707055691451]
["TOL-07","Strutture, opere di ingegneria e manufatti in calcestruzzo armato, anche prefabbricato",{"$f":"'1_Scomposizione TOL'!D11","v":1.466275659824047E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A14, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":104.1},{"$f":"(D14 / '1_Scomposizione TOL'!$E11)*100","v":109.57894736842104},1.6067294335545608]
["TOL-08","Strutture, opere di ingegneria e manufatti in legno",{"$f":"'1_Scomposizione TOL'!D12","v":1.466275659824047E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A15, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":110.05},{"$f":"(D15 / '1_Scomposizione TOL'!$E12)*100","v":106.94849368318755},1.5681597314250375]
["TOL-09","Gallerie e opere d'arte nel sottosuolo realizzate con metodo tradizionale",{"$f":"'1_Scomposizione TOL'!D13","v":1.466275659824047E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A16, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":99.35},{"$f":"(D16 / '1_Scomposizione TOL'!$E13)*100","v":107.17367853290183},1.5714615620660093]
["TOL-10","Gallerie e opere d'arte nel sottosuolo realizzate con metodo meccanizzato",{"$f":"'1_Scomposizione TOL'!D14","v":1.466275659824047E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A17, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":98.8},{"$f":"(D17 / '1_Scomposizione TOL'!$E14)*100","v":104.99468650371946},1.5395115323126023]
["TOL-11","Acquedotti, gasdotti, opere di irrigazione e fognature",{"$f":"'1_Scomposizione TOL'!D15","v":1.466275659824047E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A18, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":108.2},{"$f":"(D18 / '1_Scomposizione TOL'!$E15)*100","v":108.2},1.5865102639296189]
["TOL-12","Opere marittime e lavori di dragaggio, opere fluviali e di difesa del suolo",{"$f":"'1_Scomposizione TOL'!D16","v":0.22873900293255131},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A19, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":101.1},{"$f":"(D19 / '1_Scomposizione TOL'!$E16)*100","v":110.37117903930131},25.246193445939888]
["TOL-13","Impianti per la produzione, trasformazione e distribuzione di energia elettrica in alta e media tensione per la trazione elettrica e l'illuminazione pubblica",{"$f":"'1_Scomposizione TOL'!D17","v":4.3988269794721412E-3},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A20, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":110.35},{"$f":"(D20 / '1_Scomposizione TOL'!$E17)*100","v":104.39924314096498},0.45923420736494863]
["TOL-14","Impianti elettrici, tecnologici, radiotelefonici e antintrusione",{"$f":"'1_Scomposizione TOL'!D18","v":2.932551319648094E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A21, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":106.9},{"$f":"(D21 / '1_Scomposizione TOL'!$E18)*100","v":102.39463601532567},3.0027752497162954]
["TOL-15","Impianti meccanici, termici, di condizionamento, idrico sanitari e trasportatori",{"$f":"'1_Scomposizione TOL'!D19","v":4.398826979472141E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A22, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":106.1},{"$f":"(D22 / '1_Scomposizione TOL'!$E19)*100","v":101.33715377268385},4.4576460603819879]
["TOL-16","Impianti di potabilizzazione e depurazione",{"$f":"'1_Scomposizione TOL'!D20","v":4.398826979472141E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A23, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":107.15},{"$f":"(D23 / '1_Scomposizione TOL'!$E20)*100","v":103.82751937984496},4.5671929345972861]
["TOL-17","Impianti di segnalamento, sicurezza del traffico e telecomunicazioni",{"$f":"'1_Scomposizione TOL'!D21","v":3.519061583577713E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A24, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":109},{"$f":"(D24 / '1_Scomposizione TOL'!$E21)*100","v":102.1555763823805},3.5949176439547395]
["TOL-18","Armamento ferroviario",{"$f":"'1_Scomposizione TOL'!D22","v":0.10263929618768329},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A25, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":110.85},{"$f":"(D25 / '1_Scomposizione TOL'!$E22)*100","v":110.40836653386452},11.332237034267621]
["TOL-19","Opere di fondazione speciale, indagini geologiche e geotecniche",{"$f":"'1_Scomposizione TOL'!D23","v":1.4662756598240469E-3},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A26, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":105.7},{"$f":"(D26 / '1_Scomposizione TOL'!$E23)*100","v":109.42028985507248},0.16044030770538487]
["TOL-20","Conferimento rifiuti a impianto di smaltimento o recupero",{"$f":"'1_Scomposizione TOL'!D24","v":3.519061583577713E-2},{"$f":"AVERAGEIFS(INDEX('2_DB Indici ISTAT'!$B$5:$U$500, 0, MATCH(A27, '2_DB Indici ISTAT'!$B$4:$U$4, 0)), '2_DB Indici ISTAT'!$A$5:$A$500, \">=\"&$B$4, '2_DB Indici ISTAT'!$A$5:$A$500, \"<=\"&$B$5)","v":109.5},{"$f":"(D27 / '1_Scomposizione TOL'!$E24)*100","v":102.62417994376759},3.6114080918627893]
[null,"INDICE REVISIONALE SINTETICO MEDIO DEL PERIODO (Ispx)",null,null,null,{"$f":"SUM(F8:F27)","v":107.12011042319233}]

{"sheet":"4_Registro Revisioni","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["REGISTRO REVISIONI PREZZI - CALCOLO FINALE APPLICATO"]
[]
[null,"Parametro Contabile / Revisionale","Riferimento Formula / Legge","Valore","Note Metodologiche"]
[null,"Importo SAL Contabilità (SAL_cpx):","Valore contabile di base",150000,"Importo del SAL lordo a prezzi contrattuali (Modificabile)"]
[null,"Indice Offerta Gara (Ismo):","Art. 5, c. 4, punto 3",100,"Posto convenzionalmente fisso a 100 ex lege"]
[null,"Indice Medio del Periodo (Ispx):",{"$f":"'3_Calcolo Periodo SAL'!G28","v":0},{"$f":"'3_Calcolo Periodo SAL'!F28","v":107.12011042319233},"Somma pesata importata dal foglio 3"]
[null,"Scostamento Percentuale Variazione:","Delta = (Ispx - Ismo) / Ismo",{"$f":"ROUND((D7-D6)/D6, 4)","v":7.1199999999999999E-2},"Variazione lorda dei prezzi (Arrotondata a 4 decimali)"]
[null,"Verifica Franchigia 3% (Alea):","Soglia limite ± 0,03",{"$f":"IF(ABS(D8)>0.03, \"LIQUIDABILE\", \"NELL'ALEA\")","v":"LIQUIDABILE"},"Controlla se lo scostamento esce dall'alea"]
[null,"Coefficiente Netto Arrotondato (90%):","Coeff = (Delta ± 0,03) * 0,9",{"$f":"IF(ABS(D8)>0.03, ROUND(IF(D8>0.03, (D8-0.03)*0.9, (D8+0.03)*0.9), 4), 0)","v":3.7100000000000001E-2},"Percentuale netta spettante ridotta al 90% ex punto 5"]
[null,"IMPORTO REVISIONE PREZZI FINALE (SAL_rpx):","SAL_rpx = SAL_cpx * Coeff",{"$f":"D5*D10","v":5565},"Valore economico finale in Euro liquidabile o da recuperare"]

{"sheet":"5_dati scaricati da istat","index":5,"n_rows":30,"n_cols":54,"rows_kept":30,"cut":false,"hidden":false,"merged":[[9,1,9,53]]}
["Tipologie omogenee di lavorazioni (TOL) - mensili (base 2022)",null,null,null,null,null,null,"link tol"]
[null,null,null,null,null,null,null,"scaricare excel e incollarlo sotto"]
["Tipologie omogenee di lavorazioni (TOL) - mensili (base 2022)  "]
["Frequenza: Mensile  "]
["Territorio: Italia  "]
["Indicatore: Indice di costo di lavorazione dati mensili (base 2022=100) - dati mensili  "]
["Correzione: Dati grezzi  "]
[]
["Tempo  ","2022-01  ","2022-02  ","2022-03  ","2022-04  ","2022-05  ","2022-06  ","2022-07  ","2022-08  ","2022-09  ","2022-10  ","2022-11  ","2022-12  ","2023-01  ","2023-02  ","2023-03  ","2023-04  ","2023-05  ","2023-06  ","2023-07  ","2023-08  ","2023-09  ","2023-10  ","2023-11  ","2023-12  ","2024-01  ","2024-02  ","2024-03  ","2024-04  ","2024-05  ","2024-06  ","2024-07  ","2024-08  ","2024-09  ","2024-10  ","2024-11  ","2024-12  ","2025-01  ","2025-02  ","2025-03  ","2025-04  ","2025-05  ","2025-06  ","2025-07  ","2025-08  ","2025-09  ","2025-10  ","2025-11  ","2025-12  ","2026-01  ","2026-02  ","2026-03  ","2026-04  ","2026-05  "]
["Tipologie omogenee di lavorazioni  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  ","  "]
["TOL.1  - Opere edili su edifici e manufatti non soggetti a tutela dei beni culturali  ",90.9,91.6,96.7,98,99.1,100.2,102.5,104.6,104.7,103.2,103.8,104.7,103.1,102.7,102,101.8,100.8,100.3,100.9,100.9,100.7,100.5,100.1,99.9,99.7,99.3,99.4,99,99.4,99.7,100.1,100.3,99.9,99.7,100.4,100.6,101.4,103,102.3,101.3,100.9,101.6,101.7,101.6,101.7,101.2,101.7,101.4,102.1,101.9,104.7,105.1,105.3]
["TOL.2  - Opere edili su edifici e manufatti soggetti a tutela dei beni culturali  ",93.2,93.4,98.1,99.3,99.9,100.3,101.5,102.7,103.3,102.8,102.6,102.9,102.6,102.4,102.2,102,101.4,101.1,102,102,102,101.7,101.4,101.3,101.2,101,100.9,100.8,100.9,101.1,101.4,101.2,100.9,101,101.1,101.3,102,104.3,103.9,103.3,103,103.4,103.6,103.7,103.7,103.4,103.8,103.9,103.9,104.1,107.2,108,108.2]
["TOL.3  - Scavi archeologici, restauri specialistici di beni del patrimonio culturale e di interesse storico  ",96.2,96.1,99.5,99.6,99.7,100.4,101.6,102,101.6,101.2,101.2,101.1,100.8,100.8,100.7,100.5,100.1,100,101.4,101.6,101.7,101.8,101.6,101.5,101.1,101.3,101.6,101.2,101,101.1,101.3,101.4,101.2,101.1,101.6,101.6,102.1,105.1,104.4,104.2,103.9,104.6,104.6,104.6,104.7,104.6,104.8,104.7,105.1,104.8,107.6,108.1,108.3]
["TOL.4  - Lavori di movimento terra, demolizioni, opere di protezione ambientale, ingegneria naturalistica e opere a verde  ",91.3,92.8,100,99.8,100.8,103.3,102.9,101.4,101.6,103.3,102.9,100,100.5,100.1,99.5,98.7,97.1,97.2,98.1,100.1,101,100.6,99.4,98.5,98.6,100.1,100.3,99.8,98.7,98.2,98.9,98,97.2,97,97.6,97.9,99.6,100.8,99.6,98.6,97.9,98.7,99.2,98.9,99.1,98.6,100.1,99.4,99.5,100.3,107.8,112.3,110.4]
["TOL.5  - Pavimentazioni in conglomerato bituminoso  ",88.6,89.3,99.3,100.4,100.5,103,104.2,104.2,103.2,103.4,102.2,101.7,102,101,100.3,99.5,98.1,98.1,99.2,99.2,99.8,100.4,99.6,98.9,98.4,98.8,98.9,98.9,98.3,98.5,99.2,99,98.6,98.1,98.8,98.7,100,100.7,99.8,98.3,98.6,99.5,99.8,99.3,98.9,98.9,99.2,99.1,99.1,99.1,105.7,110,109.3]
["TOL.6  - Strutture, opere di ingegneria e manufatti in acciaio  ",92.9,93.8,109.6,115.1,108.5,102.5,100.4,101.1,99.8,93.9,91.3,91,91.3,92.6,93.1,93.9,90.8,88.2,88,88,87,85.5,86.3,87.1,88.5,88.1,86.4,85,85.3,86.7,86.8,86.8,85.6,84.7,85.3,86.1,86.8,88,87.4,86.8,86,86,84.7,84.8,85,85.8,86.9,87.2,89,89.4,92.5,92.5,92.2]
["TOL.7  - Strutture, opere di ingegneria e manufatti in calcestruzzo armato, anche prefabbricato  ",91,91.9,100.2,104,104,101.4,100.9,102.1,103.2,101.2,100.4,99.8,99.6,98.5,97.5,97.7,96,95.3,95.4,95.5,94.6,93.7,93.7,94.7,94.5,94.4,93.7,93.5,93.7,94.5,94.3,94.1,93,92.6,92.9,93.6,95,96.2,95.3,95.2,93.8,93.2,93.4,94.4,93.8,93.4,95.1,95.1,95.3,96.2,100.7,104,104.2]
["TOL.8  - Strutture, opere di ingegneria e manufatti in legno  ",95.2,95.6,98.9,99.8,100.2,100.1,101.3,101.4,101.7,102.4,102.1,101.3,100.3,100.2,100.5,100.5,99.9,99.8,100.2,100.2,100.6,100.7,100.1,99.9,100.3,100.7,100.9,101.3,101.1,101.3,101.1,101,101.1,102,102.2,102.4,102.9,104.5,104.3,104,103.9,104.5,104.4,104.3,104.8,105,105.4,105.3,106.2,106.7,109.1,110,110.1]
["TOL.9  - Gallerie e opere d'arte nel sottosuolo realizzate con metodo tradizionale  ",91,91.5,100.1,103.5,103.8,102,102.2,103,103.2,100.8,99.9,99,97.6,96.4,95.5,95.4,93.7,92.9,92.9,93.1,92.4,91.8,91.5,92.1,91.6,91.5,91.2,90.7,90.7,91.1,91.4,91.4,90.6,90.3,90.8,91.4,92.7,93.8,92.5,92.2,91.1,91.1,91.1,91.6,91.2,90.7,91.9,91.7,92.3,92.9,97.1,99.3,99.4]
["TOL.10 - Gallerie e opere d'arte nel sottosuolo realizzate con metodo meccanizzato  ",92.1,91.7,99.7,102,101.5,100,102.3,105.2,104.8,100.1,99.8,100.6,98.4,97.1,96,95.9,94,93.5,93.4,93.6,92.6,92.5,92.5,93.1,91.8,91.7,92,90.9,91,91.8,91.8,92.1,91.1,90.6,92,92.7,94.1,95.1,92.7,92.1,90.8,91.6,91.5,92.2,91.8,91.3,92.9,92.7,93.7,93.5,96.8,98.6,99]
["TOL.11 - Acquedotti, gasdotti, opere di irrigazione e fognature  ",92,93.3,99,100.2,100.8,101.6,102.3,102.9,102.8,102.1,102,101.2,101,100.6,99.8,99.5,98.3,98.4,98.8,99.4,99.4,99.1,98.7,98.6,98.6,98.7,98.6,98.6,98.4,98.9,99.2,99.1,98.4,98.3,98.5,98.9,100,101.3,100.3,99.9,99.2,99.4,99.6,99.8,99.7,99.5,100.5,100.3,100.7,101,105.8,108.2,108.2]
["TOL.12 - Opere marittime e lavori di dragaggio, opere fluviali e di difesa del suolo  ",89.1,90.7,103.2,107.3,106.6,105.8,102.4,100,100.7,100.6,98.8,94.8,95.9,95.5,94.8,94.6,92.9,92.3,91.9,93.4,93.7,92.8,91.9,91.5,92.1,92.9,92.7,92.3,91.5,91.5,91.8,91.2,90.4,89.7,89.8,90.2,91.6,91.9,91,90.1,89.3,89.4,89.5,89.2,89.1,88.7,90.4,90.3,91.4,92.4,98.4,102,100.2]
["TOL.13 - Impianti per la produzione, trasformazione e distribuzione di energia elettrica in alta e media tensione per la trazione elettrica e l'illuminazione pubblica  ",95.2,96.2,99.4,99.5,99.8,101.4,101.8,101.6,101.7,101.4,101.3,100.8,101.3,101.5,101.2,101.6,100.9,102.6,103.4,104,104.1,104,103.6,103.2,103.6,103.7,103.8,103.9,103.8,105.6,105.5,105.4,104.8,105.1,105.1,105.4,105.7,105.9,105.3,105.5,104.9,105.6,105.6,105.3,105.4,105.6,106,106.1,106.1,106.5,109.2,110.4,110.3]
["TOL.14 - Impianti elettrici, tecnologici, radiotelefonici e antintrusione  ",96.4,97.1,99,99,99.3,100.4,101.6,102.8,102.5,100,100.5,101.5,101.1,100.6,101,101.9,100.6,102.2,102.1,101.9,102.2,103,102.4,103,102.5,101.9,102.1,101.9,101.6,103.6,103.7,103.8,103.8,103.9,103.7,104,104.4,104.5,103.8,103.8,103.3,104.3,103.7,103.8,103.4,103.7,103.8,104.2,104.4,104.1,106,106.7,107.1]
["TOL.15 - Impianti meccanici, termici, di condizionamento, idrico sanitari e trasportatori  ",95.8,95.9,97.9,98.7,99.5,100.6,101.4,102.8,102.6,101.3,101.6,101.9,101.3,100.7,100.8,101,100.8,102.7,102.9,102.7,102.2,103,102.5,101.8,101.9,101.7,101.4,101.7,102,104.3,104.5,104.3,104.1,103.9,104.3,104.3,104.7,104.7,104.2,104,103.5,104.1,104.1,103.5,103.4,103.7,103.6,104,104.5,104.6,105.5,105.5,106.7]
["TOL.16 - Impianti di potabilizzazione e depurazione  ",93.9,94.8,98,97.9,98.4,100.1,102.4,103.7,103.7,102.2,102.4,102.5,101.6,101.1,100.7,100.8,100.6,102.5,101.8,102.6,101.2,101.8,101,99.8,99.2,99.3,100,100.1,99.9,101.8,102,101.8,101.1,101,101.4,101.8,103.2,103.5,102.8,102.3,102.2,103.4,103.1,102.5,102.5,102.7,103.2,103,103.5,103.6,106.3,106.7,107.6]
["TOL.17 - Impianti di segnalamento, sicurezza del traffico e telecomunicazioni  ",97.3,97.8,99.5,100,100.5,100.6,100.9,100.3,101.2,100.7,100.4,100.8,101.2,102,102.3,101.8,101.5,103.4,103.1,103.2,103.2,102.9,102.6,102.6,102.4,102.9,102.7,103.3,103.4,106.3,106.4,106.1,105.9,106.5,106.4,106.6,106.7,106.1,106,106.5,105.8,106.5,106.3,106.2,105.6,105.8,106.2,107.6,107.9,108.4,109.1,108.4,109.6]
["TOL.18 - Armamento ferroviario  ",91.9,92.8,100.4,99.7,100.2,104.1,103.5,101.2,101.3,103.1,102.5,99.3,100.3,99.6,98.9,98.4,96.7,96.7,97.7,100.2,101.1,101.1,99.8,98.6,98.9,100.9,101.4,100.5,98.6,97.9,98.8,97.8,96.9,96.8,98,98.4,100.4,101.3,99.5,98.1,97.3,98.9,99.1,98.4,98.8,98.4,99.9,99.2,99.1,99.7,107.6,112,109.7]
["TOL.19 - Opere di fondazione speciale, indagini geologiche e geotecniche  ",90.3,91.5,98.5,99.7,102,101.9,103.5,103.8,103.2,101.8,102.4,101.3,100.4,99.6,98.5,98.2,96.5,96.2,96.5,97.4,97.5,97,96,95.9,95.6,95.9,95.8,95.7,95.4,95.4,96.1,95.9,94.7,94.5,95.1,95.4,96.6,98,96.6,96.2,95.1,95.6,95.5,95.4,95.3,94.9,96.3,95.7,96.8,97.6,103.7,106,105.4]
["TOL.20 - Conferimento rifiuti a impianto di smaltimento o recupero  ",99.5,99.5,99.5,99.8,99.8,99.8,100.2,100.2,100.2,100.5,100.5,100.5,102.7,102.7,102.7,102.5,102.5,102.5,102.4,102.4,102.4,102.6,102.6,102.6,104.2,104.2,104.2,104.3,104.3,104.3,104.4,104.4,104.4,104.5,104.5,104.5,106.7,106.7,106.7,107.1,107.1,107.1,107.1,107.1,107.2,107.2,107.2,107.2,108,108,108,109.5,109.5]