{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["QTE","CALCOLO spese tecniche interne"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"QTE","index":0,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,0,1,9],[2,0,2,9],[3,0,3,8],[4,1,5,1],[4,8,5,8]],"flags":["formulas_cached_only"]}
[]
["Q.T.E. Opere Complementari/ALLACCI UTENZE ACQUA E GAS - Suddivisione per imputazione contabile secondo esigibilità/Allegato alla Det. n° 407 del 07.05.2018"]
["REALIZZAZIONE DI NUOVO  EDIFICIO PER SERVIZI SOCIOASSISTENZIALI"]
["tranche 2016"]
["voce","valore netto iva","ci","iva","iva","orr","irap","totale","data prestazione","pagamenti"]
[null,null,0.04,0.1,0.22,0.238,0.085]
["opere a base d'asta",398888.21,null,39888.821,null,null,null,438777.031]
["% ribasso",25.889]
["Ribasso",103268.16868690001]
["Importo ribassato",295620.0413131,null,29562.004131310005,null,null,null,325182.04544441]
["oneri sicurezza",19640,null,1964,null,null,null,21604]
[315260.0413131]
["Progetto Preliminare Det. n. 536 del 29,06,2016 €. 2.850,00 + 4% + 22% (€.3.616,08 sul Cap. 10012)"]
["Progetto Def-Esec Det. n. 911 del 24,10,2016 - Cap. 11755",20790,831.6,null,4756.7519999999995,null,null,26378.352,"2016-10-31","2016-12-31"]
["Direzione Lavori, Contabilità, CRE e Sicurezza (€.21.000,00+4%+22%) a carico ARCA",null,0,null,0,null,null,0]
["OPERE 2017",155300,null,15530,null,null,null,170830,"31,12,2017","31,12,2017"]
[]
["OPERE 2018",140320.04131310002,null,14032.004131310003,null,null,null,154352.04544441003,"30,09,2018","31,12,2018"]
["oneri sicurezza 2018",19640,null,1964,null,null,null,21604,"30,09,2018","31,12,2018"]
["Spese tecniche ex art. 113/Dlgs 50",5409.09,null,null,null,1287.3634200000001,459.77265,7156.22607,"30,06,2018","30,06,2018"]
["Versamento S.A. Anac",225,{"$nulls":5},225,"30,04,2018","30,04,2018"]
["Accantonamento innovazione tecnologica  - art. 113/D.lgs 50",1674.11,{"$nulls":5},1674.11,"30,06,2018","30,06,2018"]
[]
[]
["Importo opere perizia (2018)",20499.87,null,2049.9869999999996,null,null,null,22549.857,"30,06,2018","31,12,2018"]
["Sicurezza perizia (2018)",1078,null,107.8,null,null,null,1185.8,"30,06,2018","31,12,2018"]
["Opere complementari P.T. Arca",61238.28,null,6123.828,null,null,null,67362.108,"30,06,2018","30.09.2018"]
["Sicurezza Op. Compl",5274.29,null,527.429,null,null,null,5801.719,"30,06,2018","30.09.2018"]
["Spese tecniche ex art. 113/Dlgs 50",859.613182552504,null,null,null,204.58793744749596,73.06712051696285,1137.2682405169628,"30.06.2018","30.09.2018"]
["Acc. Innovaz.tecn. art. 113/D.lgs 50",266.05027999999993,{"$nulls":5},266.05027999999993,"30.06.2018","30.09.2018"]
["Allacciamento acqua/Uniacque",402.5,null,40.25,null,null,null,442.75,"30.05.2018","30.06.2018"]
["Allacciamento gas/2iRete Gas",561.83,null,null,123.6,null,null,685.4300000000001,"30.05.2018","30.06.2018"]
["Somme a disposizione per altri allacciamenti delle utenze",11075.26,null,null,2436.5572,null,null,13511.817200000001]
["Anac",30,{"$nulls":5},30,"30.03.2018","30.06.2018"]
[]
["Imprevisti comprensivi del ribasso (post perizia e post opere compelmentari)",4370.42,null,437.042,null,null,null,4807.462]
[{"$nulls":7},499999.99523492693]
[{"$nulls":5},"Totale 2016",null,26378.352]
[{"$nulls":5},"Totale 2017",null,170830]
[{"$nulls":5},"Totale 2018",null,297984.1812349269]

{"sheet":"CALCOLO spese tecniche interne","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
["OPERE A BASE D'ASTA",null,"OPERE PRINCIPALI"]
[{"$error":"#REF!"},0.02,{"$error":"#REF!"}]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},"F. DO ACC.TO….."]
[null,null,"80% incl. oorr escl.irap",0.2]
[null,null,"SP. TECNICHE"]
[]
[null,"SP.TEC IMP",{"$error":"#REF!"},"netto oorr"]
[null,"ORR 23,%",{"$error":"#REF!"}]
[null,"IRAP 8,5%",{"$error":"#REF!"}]
[]
[]
[]
[]
[]
["OPERE A BASE D'ASTA",null,"OPERE COMPLEMENTARI"]
[66512.56999999999,0.02,1330.2513999999999]
[null,null,1064.20112,266.05027999999993,"F. DO ACC.TO….."]
[null,null,"80% incl. oorr escl.irap",0.2]
[null,null,"SP. TECNICHE"]
[]
[null,"SP.TEC IMP",859.613182552504,"netto oorr"]
[null,"ORR 23,%",204.58793744749596]
[null,"IRAP 8,5%",73.06712051696285]