{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Dati","Ud","TFnd","TVnd"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"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":"Dati","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[55,1,55,5],[51,1,51,5],[57,1,57,5],[56,1,56,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[67,1,67,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[61,1,61,5],[62,1,62,5],[63,1,63,5],[64,1,64,5],[65,1,65,5],[66,1,66,5],[2,0,2,3],[14,0,15,0],[14,1,14,2],[14,3,14,6],[13,0,13,6],[44,1,44,5],[45,1,45,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[22,0,22,6],[41,1,41,5],[42,1,42,5],[43,1,43,5],[24,5,24,6],[34,0,34,10],[36,9,36,10],[37,1,37,5],[0,14,0,20],[1,14,2,14],[1,15,1,16],[1,17,1,20]],"flags":["formulas_cached_only"]}
["PROSPETTO DI CALCOLO DELLE TARIFFE"]
[]
["Comuni inferiori a 5.000 abitanti NORD"]
[]
["DATI GENERALI","inserire","%"]
["Costi fissi no K n-1",123439.01999999999,0.023,126278.11745999998,"Costi fissi no K "]
["CKn",71.84,null,71.84,"CKn"]
["Costi variab n-1",292164.33,0.023,298884.10959,"Costi variabili"]
["Riduz. Rd Ud       €",13445.68,null,13445.68,"Riduz. Rd Ud"]
["Totale RSU        kg",1087763,null,438679.74704999995]
["Tasso inflaz. Ip",0.025]
["Recup. Prod. Xn",0.002]
[]
["DISTRIBUZIONE DATI"]
["Utenze","RIFIUTI",null,"COSTI "]
[null,"kg","%","Costi fissi","Costi var.","Riduz. Rd Ud","Costi var. corr."]
["Ud",654639.21,88,111187.96256479998,263018.01643920003,13445.68,249572.33643920004]
["Und",433123.79000000004,12,15161.994895199998,35866.0931508,-13445.68,49311.7731508]
["Totale",1087763,100,126349.95745999998,298884.10959,0,298884.10959]
[]
[]
[]
["DATI DELLE UTENZE DOMESTICHE"]
[]
[{"$nulls":5},"TARIFFE"]
["n","Stot(n)","N(n)","Ps",null,"Fisso €/mq","Variabile €"]
[1,77712.8,644,0.3,null,0.2859859615391409,48.716052398828815]
[2,104481.6,711,0.4,null,0.33603350480849054,105.55144686412912]
[3,69876.82,455,0.5,null,0.37535657452012244,138.7054269688876]
[4,46705,298,0.6,null,0.40752999519327576,181.33197281786283]
[5,14695.4,81,0.9,null,0.43970341586642914,238.84397912203576]
["6 o più",4583,24,1,null,0.464727187501104,277.4108539377752]
["Totale",318054.62000000005,2213]
[]
["DATI DELLE UTENZE NON DOMESTICHE"]
[]
["Inserire % aumento ut. giornaliere (≤ 100%):",null,null,1,{"$nulls":5},"Tariffe"]
["n.","Attività",{"$nulls":4},"Stot(ap)","Ps",null,"Fisso €/mq","Variab. €/mq"]
[1,"Musei, biblioteche, scuole, associazioni, luoghi di culto",{"$nulls":4},0,1,null,0.14855949803640267,0.478176105804209]
[2,"Autorimesse e magazzini senza alcuna vendita diretta",{"$nulls":4},1077,1,null,0.17477588004282668,0.5578721234382439]
[3,"Campeggi, distributori carburanti",{"$nulls":4},9,1,null,0.2330345067237689,0.7457270221470401]
[4,"Stabilimenti balneari",{"$nulls":4},0,1,null,0.18351467404496802,0.5920275595671158]
[5,"Esposizioni, autosaloni",{"$nulls":4},141,1,null,0.14855949803640267,0.40417266085831943]
[6,"Alberghi con ristorante",{"$nulls":4},1559,1,null,0.38741986742826584,1.2443963896285724]
[7,"Alberghi senza ristorante",{"$nulls":4},0,1,null,0.2650767513982871,0.8527473886841727]
[8,"Case di cura e riposo",{"$nulls":4},10213,1,null,0.29129313340471114,0.9324434063182074]
[9,"Uffici, agenzie, studi professionali",{"$nulls":4},1166,1,null,0.32916124074732356,1.0588185199950342]
[10,"Banche ed istituti di eredito",{"$nulls":4},2836,1,null,0.16895001737473245,0.544209948986695]
[11,"Negozi abbigliamento, calzature, libreria, cartoleria, ferramenta, e altri beni durevoli",{"$nulls":4},1474,1,null,0.3233353780792294,1.0383252583177107]
[12,"edicola, farmacia, tabaccaio, plurilicenze",{"$nulls":4},268,1,null,0.44276556277516094,1.4174505993481907]
[13,"Negozi particolari quali filatelia, tende e tessuti, tappeti, cappelli e ombrelli, antiquariato",{"$nulls":4},48,1,null,0.24177330072591022,0.775328400125396]
[14,"Banchi di mercato beni durevoli ",{"$nulls":4},0,1,null,0.5185017774603858,1.6599541958631825]
[null," - idem utenze giornaliere",{"$nulls":4},0,1,null,1.0370035549207717,3.319908391726365]
[15,"Attività artigianali tipo botteghe: Parrucchiere, barbiere, estetista",{"$nulls":4},460,1,null,0.3029448587408996,0.9677373569847086]
[16,"Attività artigianali tipo botteghe: falegname, idraulico, fabbro, elettricista",{"$nulls":4},203,1,null,0.30003192740685247,0.9677373569847086]
[17,"Carrozzeria, autofficina, elettrauto",{"$nulls":4},172,1,null,0.3379000347494649,1.0793117816723574]
[18,"Attività industriali con capannoni di produzione",{"$nulls":4},955,1,null,0.02650767513982872,0.8538859032218017]
[19,"Attività artigianali di produzione beni specifici",{"$nulls":4},1012,1,null,0.31750951541113515,1.0155549675651294]
[20,"Ristoranti, trattorie, osterie, pizzerie",{"$nulls":4},5020,0.1,null,1.4850123940972173,4.757966104205643]
[null," - idem utenze giornaliere",{"$nulls":4},0,1,null,4.322790099725913,13.862553010171544]
[21,"Bar, caffè, pasticceria",{"$nulls":4},822,0.1,null,1.1372083928119923,3.641538748606577]
[null," - idem utenze giornaliere",{"$nulls":4},0,1,null,3.658641755563172,11.719868650353636]
[22,"Supermercato, pane e pasta, macelleria, salumi e formaggi, generi alimentari",{"$nulls":4},210,1,null,0.6932776575032125,2.22579592106483]
[23,"Plurilicenze alimentari e/o miste ",{"$nulls":4},1002,1,null,0.760275078186296,2.4375596250638365]
[24,"Ortofrutta, pescherie, fiori e piante",{"$nulls":4},0,0.1,null,1.8928227808638127,6.069193297193041]
[25,"Banchi di mercato genere alimentari",{"$nulls":4},0,1,null,2.015748483160601,6.464485544657854]
[null," - idem utenze giornaliere",{"$nulls":4},0,1,null,4.031496966321202,12.928971089315707]
[26,"Discoteche, night-club",{"$nulls":4},0,1,null,0.47772073878372623,1.5313020531110977]
[{"$nulls":6},28647]

{"sheet":"Ud","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,1,3]],"flags":["formulas_cached_only"]}
["TARIFFE UTENZE DOMESTICHE - PARTE FISSA"]
["Comuni inferiori a 5.000 abitanti NORD"]
["Ctuf:",111187.96256479998]
[{"$nulls":5},"TFd"]
["n","Ka","Sot(n)","Ka.Stot(n)","Quf","Quf.Ka(n)",null,"Gettito"]
[1,0.8,77712.8,62170.240000000005,0.35748245192392614,0.2859859615391409,null,22224.76983189895]
[2,0.94,104481.6,98212.704,0.35748245192392614,0.33603350480849054,null,35109.318235998784]
[3,1.05,69876.82,73370.66100000001,0.35748245192392614,0.37535657452012244,null,26228.723793559184]
[4,1.14,46705,53243.7,0.35748245192392614,0.40752999519327576,null,19033.688425501943]
[5,1.23,14695.4,18075.342,0.35748245192392614,0.43970341586642914,null,6461.617577523522]
["6 o più",1.3,4583,5957.900000000001,0.35748245192392614,0.464727187501104,null,2129.8447003175597]
[null,null,"Totale",311030.5470000001,null,null,null,111187.96256479993]
[{"$nulls":7},"Verificato"]
[]
["TARIFFE UTENZE DOMESTICHE - PARTE VARIABILE"]
["CVd (€)",null,249572.33643920004]
["Qtot (kg)",null,654639.21]
["Cu (€/kg)",null,0.3812364622021343]
["Quv",null,177.47825980870581]
[{"$nulls":8},"TVd"]
["n","Kb min","Kb max","Ps","Kb(n)","N(n)","Kb(n).N(n)","Quv","Gettito"]
[null,0.6,1,0.3,0.72,644,463.68,48.716052398828815,31373.137744845757]
[2,1.4,1.8,0.4,1.56,711,1109.16,105.55144686412912,75047.0787203958]
[3,1.8,2.3,0.5,2.05,455,932.7499999999999,138.7054269688876,63110.96927084385]
[4,2.2,3,0.6,2.68,298,798.6400000000001,181.33197281786283,54036.92789972312]
[5,2.9,3.6,0.9,3.5300000000000002,81,285.93,238.84397912203576,19346.362308884898]
["6 o più",3.4,4.1,1,4.1,24,98.39999999999999,277.4108539377752,6657.8604945066045]
[{"$nulls":5},"Totale",3688.5600000000004,null,249572.33643920004]
[{"$nulls":8},"Verificato"]

{"sheet":"TFnd","index":2,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,0,2,3]],"flags":["formulas_cached_only"]}
["TARIFFE UTENZE NON DOMESTICHE - PARTE FISSA"]
[]
["Comuni inferiori a 5.000 abitanti NORD"]
[null,"Ctapf",15161.994895199998]
[null,"QTnd",52050.64300000001]
[null,"Qapf",0.29129313340471114]
[null,"Inserire % di aumento per utenze giornaliere (fino a 100%)",1]
[{"$nulls":8},"TARIFFE"]
[null,"Attività","Kc min.","Kc max.","Ps","Kc","Stot(ap)","Stot(ap).Kc","TF(ap)",null,"Gettito"]
[1,"Musei, biblioteche, scuole, associazioni, luoghi di culto",0.32,0.51,1,0.51,0,0,0.14855949803640267,null,0]
[2,"Autorimesse e magazzini senza alcuna vendita diretta",0.51,0.6,1,0.6,1077,646.1999999999999,0.17477588004282668,null,188.23362280612434]
[3,"Campeggi, distributori carburanti",0.67,0.8,1,0.8,9,7.2,0.2330345067237689,null,2.09731056051392]
[4,"Stabilimenti balneari",0.38,0.63,1,0.63,0,0,0.18351467404496802,null,0]
[5,"Esposizioni, autosaloni",0.34,0.51,1,0.51,141,71.91,0.14855949803640267,null,20.946889223132775]
[6,"Alberghi con ristorante",1.07,1.33,1,1.33,1559,2073.4700000000003,0.38741986742826584,null,603.9875733206665]
[7,"Alberghi senza ristorante",0.8,0.91,1,0.91,0,0,0.2650767513982871,null,0]
[8,"Case di cura e riposo",0.95,1,1,1,10213,10213,0.29129313340471114,null,2974.976771462315]
[9,"Uffici, agenzie, studi professionali",1,1.13,1,1.13,1166,1317.58,0.32916124074732356,null,383.80200671137925]
[10,"Banche ed istituti di eredito",0.55,0.58,1,0.58,2836,1644.8799999999999,0.16895001737473245,null,479.14224927474123]
[11,"Negozi abbigliamento, calzature, libreria, cartoleria, ferramenta, e altri beni durevoli",0.87,1.11,1,1.11,1474,1636.14,0.3233353780792294,null,476.59634728878416]
[12,"edicola, farmacia, tabaccaio, plurilicenze",1.07,1.52,1,1.52,268,407.36,0.44276556277516094,null,118.66117082374313]
[13,"Negozi particolari quali filatelia, tende e tessuti, tappeti, cappelli e ombrelli, antiquariato",0.6,0.83,1,0.83,48,39.839999999999996,0.24177330072591022,null,11.60511843484369]
[14,"Banchi di mercato beni durevoli ",1.09,1.78,1,1.78,0,0,0.5185017774603858,null,0]
[null," - idem utenze giornaliere",2.18,3.56,1,3.56,0,0,1.0370035549207717,null,0]
[15,"Attività artigianali tipo botteghe: Parrucchiere, barbiere, estetista",0.72,1.04,1,1.04,460,478.40000000000003,0.3029448587408996,null,139.35463502081382]
[16,"Attività artigianali tipo botteghe: falegname, idraulico, fabbro, elettricista",0.82,1.03,1,1.03,203,209.09,0.30003192740685247,null,60.906481263591054]
[17,"Carrozzeria, autofficina, elettrauto",0.92,1.16,1,1.16,172,199.51999999999998,0.3379000347494649,null,58.118805976907964]
[18,"Attività industriali con capannoni di produzione",0.43,0.091,1,0.09100000000000003,955,86.90500000000003,0.02650767513982872,null,25.314829758536426]
[19,"Attività artigianali di produzione beni specifici",0.55,1.09,1,1.09,1012,1103.0800000000002,0.31750951541113515,null,321.31962959606875]
[20,"Ristoranti, trattorie, osterie, pizzerie",4.84,7.42,0.1,5.098,5020,25591.96,1.4850123940972173,null,7454.7622183680305]
[null," - idem utenze giornaliere",9.68,14.84,1,14.84,0,0,4.322790099725913,null,0]
[21,"Bar, caffè, pasticceria",3.64,6.28,0.1,3.904,822,3209.0879999999997,1.1372083928119923,null,934.7852988914576]
[null," - idem utenze giornaliere",7.28,12.56,1,12.56,0,0,3.658641755563172,null,0]
[22,"Supermercato, pane e pasta, macelleria, salumi e formaggi, generi alimentari",1.76,2.38,1,2.38,210,499.79999999999995,0.6932776575032125,null,145.5883080756746]
[23,"Plurilicenze alimentari e/o miste ",1.54,2.61,1,2.61,1002,2615.22,0.760275078186296,null,761.7956283426686]
[24,"Ortofrutta, pescherie, fiori e piante",6.06,10.44,0.1,6.497999999999999,0,0,1.8928227808638127,null,0]
[25,"Banchi di mercato genere alimentari",3.5,6.92,1,6.92,0,0,2.015748483160601,null,0]
[null," - idem utenze giornaliere",7,13.84,1,13.84,0,0,4.031496966321202,null,0]
[26,"Discoteche, night-club",1.04,1.64,1,1.64,0,0,0.47772073878372623,null,0]
[{"$nulls":6},28647,52050.64300000001,null,null,15161.994895199994]
[{"$nulls":10},"Verificato"]

{"sheet":"TVnd","index":3,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,0,2,3]],"flags":["formulas_cached_only"]}
["TARIFFE UTENZE NON DOMESTICHE - PARTE VARIABILE"]
[]
["Comuni inferiori a 5.000 abitanti NORD"]
[null,"CVnd",49311.7731508]
[null,"QTnd",433123.79000000004]
[null,"Cu",0.1138514537629069]
[null,"%  aumento utenze giornaliere ",1]
[]
[null,"Attività","Kd min.","Kd max.","Ps","Kd","Stot(ap)","Qnd","TARIFFE",null,"Gettito"]
[1,"Musei, biblioteche, scuole, associazioni, luoghi di culto",2.6,4.2,1,4.2,0,0,0.478176105804209,null,0]
[2,"Autorimesse e magazzini senza alcuna vendita diretta",4.2,4.9,1,4.9,1077,5277.3,0.5578721234382439,null,600.8282769429886]
[3,"Campeggi, distributori carburanti",5.51,6.55,1,6.55,9,58.949999999999996,0.7457270221470401,null,6.711543199323361]
[4,"Stabilimenti balneari",3.11,5.2,1,5.2,0,0,0.5920275595671158,null,0]
[5,"Esposizioni, autosaloni",2.5,3.55,1,3.55,141,500.54999999999995,0.40417266085831943,null,56.98834518102304]
[6,"Alberghi con ristorante",8.79,10.93,1,10.93,1559,17039.87,1.2443963896285724,null,1940.0139714309444]
[7,"Alberghi senza ristorante",6.55,7.49,1,7.49,0,0,0.8527473886841727,null,0]
[8,"Case di cura e riposo",7.82,8.19,1,8.19,10213,83644.47,0.9324434063182074,null,9523.044508727853]
[9,"Uffici, agenzie, studi professionali",8.21,9.3,1,9.3,1166,10843.800000000001,1.0588185199950342,null,1234.5823943142098]
[10,"Banche ed istituti di eredito",4.5,4.78,1,4.78,2836,13556.08,0.544209948986695,null,1543.3794153262668]
[11,"Negozi abbigliamento, calzature, libreria, cartoleria, ferramenta, e altri beni durevoli",7.11,9.12,1,9.12,1474,13442.88,1.0383252583177107,null,1530.4914307603055]
[12,"edicola, farmacia, tabaccaio, plurilicenze",8.8,12.45,1,12.45,268,3336.6,1.4174505993481907,null,379.8767606253151]
[13,"Negozi particolari quali filatelia, tende e tessuti, tappeti, cappelli e ombrelli, antiquariato",4.92,6.81,1,6.81,48,326.88,0.775328400125396,null,37.215763206019005]
[14,"Banchi di mercato beni durevoli ",8.9,14.58,1,14.58,0,0,1.6599541958631825,null,0]
[null," - idem utenze giornaliere",17.8,29.16,1,29.16,0,0,3.319908391726365,null,0]
[15,"Attività artigianali tipo botteghe: Parrucchiere, barbiere, estetista",5.9,8.5,1,8.5,460,3910,0.9677373569847086,null,445.15918421296595]
[16,"Attività artigianali tipo botteghe: falegname, idraulico, fabbro, elettricista",5.9,8.5,1,8.5,203,1725.5,0.9677373569847086,null,196.45068346789586]
[17,"Carrozzeria, autofficina, elettrauto",7.55,9.48,1,9.48,172,1630.5600000000002,1.0793117816723574,null,185.64162644764548]
[18,"Attività industriali con capannoni di produzione",3.5,7.5,1,7.5,955,7162.5,0.8538859032218017,null,815.4610375768206]
[19,"Attività artigianali di produzione beni specifici",4.5,8.92,1,8.92,1012,9027.039999999999,1.0155549675651294,null,1027.741627175911]
[20,"Ristoranti, trattorie, osterie, pizzerie",39.67,60.88,0.1,41.791000000000004,5020,209790.82,4.757966104205643,null,23884.98984311233]
[null," - idem utenze giornaliere",79.34,121.76,1,121.76,0,0,13.862553010171544,null,0]
[21,"Bar, caffè, pasticceria",29.82,51.47,0.1,31.985,822,26291.67,3.641538748606577,null,2993.3448513546064]
[null," - idem utenze giornaliere",59.64,102.94,1,102.94,0,0,11.719868650353636,null,0]
[22,"Supermercato, pane e pasta, macelleria, salumi e formaggi, generi alimentari",14.43,19.55,1,19.55,210,4105.5,2.22579592106483,null,467.4171434236143]
[23,"Plurilicenze alimentari e/o miste ",12.59,21.41,1,21.41,1002,21452.82,2.4375596250638365,null,2442.434744313964]
[24,"Ortofrutta, pescherie, fiori e piante",49.72,85.6,0.1,53.308,0,0,6.069193297193041,null,0]
[25,"Banchi di mercato genere alimentari",28.7,56.78,1,56.78,0,0,6.464485544657854,null,0]
[null," - idem utenze giornaliere",57.4,113.56,1,113.56,0,0,12.928971089315707,null,0]
[26,"Discoteche, night-club",8.56,13.45,1,13.45,0,0,1.5313020531110977,null,0]
[{"$nulls":6},28647,433123.79000000004,null,null,49311.7731508]
[{"$nulls":10},"Verificato"]