{"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":[[0,2,0,5],[2,2,2,5],[3,2,3,5],[4,2,4,5],[5,2,5,5],[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]]}
[null,"Ditta:"]
[null,"Attività IPPC"]
[null,"Sede Legale"]
[null,"via"]
[null,"Comune"]
[null,"Sede Attività"]
[null,"via"]
[null,"Comune"]
[null,"note"]
[null,"CALCOLO TARIFFA NUOVA ISTANZA/MODIFICA SOSTANZIALE\n IPPC - AIA "]
[null," D.M. 58/2017 allegato I   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,750,IF(F17<=10,1500,IF(F17<=20,3300,IF(F17<=50,4800,IF(F17>50,7500,errore))))))","v":0}]
[null,"CRnP","Costo istruttoria per componente Rifiuti Non Pericolosi","€",{"$f":"IF(F18=0,0,IF(F18<=1,375,IF(F18<=10,750,IF(F18<=20,1800,IF(F18<=50,2700,IF(F18>50,4500,errore))))))","v":0}]
[null,null,"Costo istruttoria per deposito temporaneo","€",{"$f":"IF(F19=\"X\",150,0)","v":0}]
[null,"CCA","Costo istruttoria per componente Clima Acustico","€",{"$f":"IF(F20=\"X\",1250,0)","v":0}]
[null,"CRI","Costo istruttoria per componente tutela quantitativa Risorsa Idrica","€",{"$f":"IF(F21=\"X\",2500,0)","v":0}]
[null,"CEM","Costo istruttoria per componente Campi Elettromagnetici","€",0]
[null,"COd","Costo istruttoria per componente Odori","€",{"$f":"IF(F23=\"X\",500,0)","v":0}]
[null,"CST","Costo istruttoria per componente Sicurezza del Territorio","€",{"$f":"IF(F24=\"X\",1000,0)","v":0}]
[null,"CRA","Costo istruttoria per componente Ripristino Ambientale","€",{"$f":"IF(F25=\"X\",3000,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,250,IF(F27=2,500,0))","v":0}]
[null,null,"Uso della Modulistica Regionale","€",{"$f":"IF(F28=\"X\",500,0)","v":0}]
[null,"CDom","Presentazione di almeno 2 copie digitali","€",{"$f":"IF(F29=\"X\",250,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 = ","€",{"$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",1250]
[null,1250]
[null,500]
[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 ",300,null,null,null,null,null,null,0,null,1,2,3,4,5,6,null,null,1,{"$f":"V13/2","v":300},600]
[null,"da 1 a 4 inquinanti ",1000,1850,2850,4350,6200,17750,null,1,null,7,8,9,10,11,12,null,null,2,{"$f":"V14/2","v":300},600]
[null,"da 5 a 10 inquinanti ",1800,4100,6000,7500,12000,30000,null,2,null,13,14,15,16,17,18,null,null,3,300,600]
[null,"da 11 a 17 inquinanti ",4350,10000,17500,24000,30000,49500,null,3,null,19,20,21,22,23,24,null,null,4,300,600]
[null,"più di 17 inquinanti ",5000,11500,24000,45000,51000,73500,null,4,null,25,26,27,28,29,30,null,null,5,300,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,300,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1000,2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,1850,3700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2850,5700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,4350,8700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,6200,12400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,17750,35500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,1800,3600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,4100,8200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,6000,12000]
[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,12000,24000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,30000,60000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,4350,8700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,10000,20000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,17500,35000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,24000,48000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,30000,60000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,49500,99000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,5000,10000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,11500,23000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,24000,48000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,45000,90000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,51000,102000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,73500,147000]
[]
[]
[]
[]
[]
[]
[]
[]
["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 ",75,150,null,600,null,null,null,0,null,1,2,3,4,null,null,null,null,1,{"$f":"V53/2","v":75},150]
[null,"da 1 a 4 inquinanti ",1425,2250,3000,7500,null,null,null,4,null,5,6,7,8,null,null,null,null,2,{"$f":"V54/2","v":150},300]
[null,"da 5 a 7 inquinanti ",2625,4200,6300,12000,null,null,null,8,null,9,10,11,12,null,null,null,null,3,150,300]
[null,"da 8 a 12 inquinanti ",3450,5700,8700,15000,null,null,null,12,null,13,14,15,16,null,null,null,null,4,600,1200]
[null,"da 13 a 15 inquinanti ",5250,11250,22500,43500,null,null,null,16,null,17,18,19,20,null,null,null,null,5,1425,2850]
[null,"più di 15 inquinanti ",6750,15000,30000,45000,null,null,null,20,null,21,22,23,24,null,null,null,null,6,2250,4500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,3000,6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,7500,15000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2625,5250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,4200,8400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,6300,12600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,12000,24000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,3450,6900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,5700,11400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,8700,17400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,15000,30000]
[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,11250,22500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,22500,45000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,43500,87000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,6750,13500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,15000,30000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,30000,60000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,45000,90000]

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