{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tariffa Istruttoria AIA","Parametri di calcolo","Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Tariffa Istruttoria AIA","index":0,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,1,13,1],[12,4,13,4],[14,1,15,1],[14,4,15,4],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,1,9,5],[10,1,10,5],[0,2,0,5],[2,2,2,5],[3,2,3,5],[4,2,4,5],[5,2,5,5]]}
[null,"Ditta:"]
[null,"Attività IPPC"]
[null,"Sede Legale"]
[null,"via"]
[null,"Comune"]
[null,"Sede Attività"]
[null,"via"]
[null,"Comune"]
[null,"note"]
[null,"CALCOLO TARIFFA RINNOVO\n IPPC - AIA "]
[null," D.M. 58/2017 allegato II   ISTRUTTORIA"]
[null,"CD","Costo istruttoria per acquisizione e gestione della Domanda","€",{"$f":"IF(F12=1,'Parametri di calcolo'!B4,IF(F12=2,'Parametri di calcolo'!B5,IF(F12=3,'Parametri di calcolo'!B6,IF(F12=4,'Parametri di calcolo'!B7,0))))","v":0}]
[null,"CAria","Costo istruttoria per componente Aria  - Numero di fonti di emissione","€",{"$f":"IF(ISNA(VLOOKUP(G13+G14,'Parametri di calcolo'!T13:U42,2,0)),0,VLOOKUP(G13+G14,'Parametri di calcolo'!T13:U42,2,0))","v":0},null,{"$f":"IF(F13<1,0,IF(F13=1,1,IF(F13<=3,2,IF(F13<=8,3,IF(F13<=20,4,IF(F13<=60,5,IF(F13>60,6,errore)))))))","v":0}]
[null,null,"Costo istruttoria per componente Aria  - Numero di sostanze significative","€",null,null,{"$f":"IF(F14<1,0,IF(F14<=4,6,IF(F14<=10,12,IF(F14<=17,18,IF(F14>17,24,errore)))))","v":0}]
[null,"CH2O","Costo istruttoria per componente Acqua - Numero di Scarichi","€",{"$f":"IF(ISNA(VLOOKUP(G15+G16,'Parametri di calcolo'!T53:U76,2,0)),0,VLOOKUP(G15+G16,'Parametri di calcolo'!T53:U76,2,0))","v":0},null,{"$f":"IF(F15<1,0,IF(F15=1,1,IF(F15<=3,2,IF(F15<=8,3,IF(F15>8,4,errore)))))","v":0}]
[null,null,"Costo istruttoria per componente Acqua - Numero di sostanze significative","€",null,null,{"$f":"IF(F16<1,0,IF(F16<=4,4,IF(F16<=7,8,IF(F16<=12,12,IF(F16<=15,16,IF(F16>15,20,errore))))))","v":0}]
[null,"CRP","Costo istruttoria per componente Rifiuti Pericolosi","€",{"$f":"IF(F17=0,0,IF(F17<=1,375,IF(F17<=10,750,IF(F17<=20,1650,IF(F17<=50,2400,IF(F17>50,3750,errore))))))","v":0}]
[null,"CRnP","Costo istruttoria per componente Rifiuti Non Pericolosi","€",{"$f":"IF(F18=0,0,IF(F18<=1,187.5,IF(F18<=10,375,IF(F18<=20,900,IF(F18<=50,1350,IF(F18>50,2250,errore))))))","v":0}]
[null,null,"Costo istruttoria per deposito temporaneo","€",{"$f":"IF(F19=\"X\",75,0)","v":0}]
[null,"CCA","Costo istruttoria per componente Clima Acustico","€",{"$f":"IF(F20=\"X\",625,0)","v":0}]
[null,"CRI","Costo istruttoria per componente tutela quantitativa Risorsa Idrica","€",{"$f":"IF(F21=\"X\",1250,0)","v":0}]
[null,"CEM","Costo istruttoria per componente Campi Elettromagnetici","€",0]
[null,"COd","Costo istruttoria per componente Odori","€",{"$f":"IF(F23=\"X\",250,0)","v":0}]
[null,"CST","Costo istruttoria per componente Sicurezza del Territorio","€",{"$f":"IF(F24=\"X\",500,0)","v":0}]
[null,"CRA","Costo istruttoria per componente Ripristino Ambientale","€",{"$f":"IF(F25=\"X\",1500,0)","v":0}]
[null,null,"Costo istruttoria","€",{"$f":"SUM(E12:E25)","v":0}]
[null,"CSGA","Riduzione costo per presenza Sistema di Gestione Ambientale","€",{"$f":"IF(F27=1,125,IF(F27=2,250,0))","v":0}]
[null,null,"Uso della Modulistica Regionale","€",{"$f":"IF(F28=\"X\",250,0)","v":0}]
[null,"CDom","Presentazione di almeno 2 copie digitali","€",{"$f":"IF(F29=\"X\",125,0)","v":0}]
[null,null,"Tot. Riduzione","€",{"$f":"SUM(E27:E29)","v":0}]
[null,"Ti","Tariffa istruttoria = a: (Costo - Riduzione)","€",{"$f":"E26-E30","v":0}]
[null,"Tf","Tariffa finale = a: (Ti x 0,50)","€",{"$f":"IF(F12=4,E31*0.8,IF(F12=3,E31*0.9,E31))","v":0}]
[]
[null,null,"Timbro e firma per asseverazione"]

{"sheet":"Parametri di calcolo","index":1,"n_rows":76,"n_cols":22,"rows_kept":76,"cut":false,"hidden":true,"merged":[[10,1,11,1],[10,3,10,6],[12,2,12,7],[50,3,50,4],[52,3,52,4]]}
[]
[]
[]
["Cd",625]
[null,625]
[null,400]
[null,250]
[]
[]
[]
["Caria","Numero di sostanze inquinante tipicamente e significativamente emessa dall’attività ",null,"Numero di fonti di emissione in aria "]
[null,null,1,"da 2 a 3 ","da 4 a 8 ","da 9 a 20 ","da 21 a 60 ","oltre 60 "]
[null,"Nessun inquinante ",150,null,null,null,null,null,null,0,null,1,2,3,4,5,6,null,null,1,{"$f":"V13/2","v":150},300]
[null,"da 1 a 4 inquinanti ",600,937.5,1500,2250,3375,9000,null,1,null,7,8,9,10,11,12,null,null,2,{"$f":"V14/2","v":150},300]
[null,"da 5 a 10 inquinanti ",1125,1875,3000,3750,5250,15000,null,2,null,13,14,15,16,17,18,null,null,3,150,300]
[null,"da 11 a 17 inquinanti ",2250,5625,9000,12375,15000,24750,null,3,null,19,20,21,22,23,24,null,null,4,150,300]
[null,"più di 17 inquinanti ",2625,6000,12000,22500,25500,36750,null,4,null,25,26,27,28,29,30,null,null,5,150,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,150,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,600,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,937.5,1875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,1500,3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2250,4500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,3375,6750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,9000,18000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,1125,2250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,1875,3750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,3000,6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,3750,7500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,5250,10500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,15000,30000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,2250,4500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,5625,11250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,9000,18000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,12375,24750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,15000,30000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,24750,49500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,2625,5250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,6000,12000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,12000,24000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,22500,45000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,25500,51000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,36750,73500]
[]
[]
[]
[]
[]
[]
[]
[]
["CH2O","Numero di sostanze ",null,"Numero di scarichi "]
[null,"inquinanti tipicamente e significativamente emesse dall’attività ",1,"da 2 a 3 ","da 4 a 8 ","oltre 8 "]
[null,"Nessun inquinante ",37.5,75,null,300,null,null,null,0,null,1,2,3,4,null,null,null,null,1,{"$f":"V53/2","v":37.5},75]
[null,"da 1 a 4 inquinanti ",712.5,1125,1500,3750,null,null,null,4,null,5,6,7,8,null,null,null,null,2,{"$f":"V54/2","v":75},150]
[null,"da 5 a 7 inquinanti ",1312.5,2100,3150,6000,null,null,null,8,null,9,10,11,12,null,null,null,null,3,75,150]
[null,"da 8 a 12 inquinanti ",1725,2850,4350,7500,null,null,null,12,null,13,14,15,16,null,null,null,null,4,300,600]
[null,"da 13 a 15 inquinanti ",2625,5625,11250,21750,null,null,null,16,null,17,18,19,20,null,null,null,null,5,712.5,1425]
[null,"più di 15 inquinanti ",3375,7500,15000,22500,null,null,null,20,null,21,22,23,24,null,null,null,null,6,1125,2250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1500,3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,3750,7500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,1312.5,2625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2100,4200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,3150,6300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,6000,12000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,1725,3450]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,2850,5700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,4350,8700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,7500,15000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,2625,5250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,5625,11250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,11250,22500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,21750,43500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,3375,6750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,7500,15000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,15000,30000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,22500,45000]

{"sheet":"Report","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}