{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Economico","Calcolo Tariffe","2012-2013","RID-AGEV"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":15,"comments":2,"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":"Economico","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,0,25,2]],"flags":["formulas_cached_only"]}
["BILANCIO ANNO",2018]
["COMUNE DI POVIGLIO"]
["COSTI ","PARTE FISSA","PARTE VARIABILE","TOTALE"]
[null,0.3,0.7]
["COSTI  DA PIANO ECONOMICO FINANZIARIO DI SABAR SERVIZI SRL ",251176.53,586078.57,837255.1]
["CARC -COSTI DI ACCERTAMENTO E RISCOSSIONE con Unione/Sabar",26100,null,26100]
["FONDO RISCHI ED AGEVOLAZIONI",72271,null,72271]
["TOTALE SPESA PREVENTIVATA 2018",349547.53,586078.57,935626.1]
[null,0.3735974552227648,0.6264025447772352,1]
[]
["% COPERTURA 2018",null,null,1]
[]
["PREVISIONE ENTRATA",null,null,935626.1]
[null,0,null,0]
["ENTRATA TEORICA",349547.53,586078.57,935626.1]
[]
[]
["UTENZE DOMESTICHE",185260.19090000002,365126.94911,550387.14]
["% su totale di colonna",0.53,0.623,0.5868]
["% su totale utenze domestiche",0.3365997812012832,0.6634002188168858,1.000000000018169]
[]
["UTENZE NON DOMESTICHE",164287.3391,220951.62089,385238.96]
["% su totale di colonna",0.47,0.377,0.4117445633464052]
["% su totale utenze non domestiche",0.4264556707867761,0.5735443291872659,0.9999999999740421]
[]
["QUANTITATIVI DA  CONSUNTIVO 2016 "]
[null,"Kg","%"]
["TOTALE RIFIUTI SMALTITI",5165870]
["DA AREE PUBBLICHE DA DETRARRE",516587,0.1]
["A CARICO UTENZE",4649283]
["UTENZE NON DOMESTICHE ",1743807,0.337]
["UTENZE DOMESTICHE ",2905476,0.664]

{"sheet":"Calcolo Tariffe","index":1,"n_rows":91,"n_cols":22,"rows_kept":91,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"COMUNE DI","POVIGLIO"]
[null,"UTENZE DOMESTICHE",{"$nulls":5},"CALCOLO TARIFFA PARTE FISSA",{"$nulls":5},"CALCOLO TARIFFA PARTE VARIABILE",{"$nulls":5},"TOTALE TARIFFA MEDIA AL LORDO DELLE SINGOLE AGEVOLAZIONI","TOTALE GETTITO","TOTALE TARIFFA"]
[null,"Famiglie","Num Nuclei","Superficie totale abitazioni","Quote Famiglia","Sup.media abitazioni",null,"Coeff",null,"Quota unitaria PF Euro/m2","Gettito QF \nUtenze domestiche","QUOTA FISSA",null,"Coeff",null,"Quota unitaria parte variabile","Gettito QV\nutenze domestiche","QUOTA VARIABILE","TARIFFA MEDIA QUOTA FISSA2016","SOMMA QUOTA FISSA E QUOTA VARIABILE 2016","Gettito QF+QV","TARIFFA MEDIA 2015"]
[null,null,"n","m2","%","m2",null,"Ka",null,"Quf","Euro","Euro/m2",null,"Kb",null,"Quv","Euro","Euro/Utenza","Euro/Utenza","Euro/Utenza","Euro","Euro/Utenza"]
[{"$nulls":7},">5000 Abitanti","S.tot*Ka","Ctuf / Somm S(n) * Ka(n)","Quf*S*Ka","Quf*Ka",null,null,"Kb*Nuc","Qtot / Somm N(n) * Kb(n)","Quv*Kb*Nuc","Quv*Kb"]
[null,"Famiglie di 1 componente ",862,108956.8,0.29652562779497765,126.38,null,0.8,87165.44,0.34,29636.249600000006,0.272,"max",1.03,887.86,69,61262.340000000004,71.07000000000001,34.37536,105.44536000000001,90898.5896,105.79]
[null,"Famiglie di 2 componenti ",784,116901.04,0.2696938424492604,149.11,null,0.95,111055.98799999998,0.39,43311.83532,0.3705,"max",1.86,1458.24,64,93327.36,119.04,55.24525500000001,174.285255,136639.19532,172.93]
[null,"Famiglie di 3 componenti ",560,84963.63,0.19263845889232886,151.73,null,1.05,89211.81150000001,0.45,40145.315175,0.47250000000000003,"adhoc",2.25,1260,67,84420,150.75,71.692425,222.44242500000001,124565.315175,222.22]
[null,"Famiglie di 4 componenti ",461,67321.53,0.1585827313381493,146.04,null,1.14,76746.54419999999,0.55,42210.59931,0.627,"med",2.68,1235.48,65,80306.2,174.20000000000002,91.56707999999999,265.76708,122516.79931,266.26]
[null,"Famiglie di 5 componenti ",143,23406.08,0.04919160646714826,163.68,null,1.23,28789.4784,0.62,17849.476608,0.7626,"min",2.96,423.28,65,27513.199999999997,192.4,124.822368,317.222368,45362.676607999994,312.87]
[null,"Famiglie di =>6 componenti ",97,14874.05,0.033367733058135535,153.35,null,1.3,19336.265,0.64,12375.2096,0.8320000000000001,"min",3.42,331.74,55,18245.7,188.1,127.58720000000001,315.6872,30620.9096,317.14]
[null,"Totali",2907,416423.13,1,143.24841073271415,null,null,412305.52710000006,null,185528.685613,null,null,null,5596.599999999999,null,365074.80000000005,null,null,null,550603.485613]
[]
[null,"UTENZE NON DOMESTICHE",{"$nulls":5},"CALCOLO TARIFFA PARTE FISSA",{"$nulls":5},"CALCOLO TARIFFA PARTE VARIABILE",{"$nulls":5},"TOTALE TARIFFA MEDIA AL LORDO DELLE SINGOLE AGEVOLAZIONI","TOTALE GETTITO"]
[{"$nulls":9},"Quota unitaria PF L/m2","Gettito QF \nUtenze non domestiche","QUOTA FISSA",null,null,null,"Quota unitaria parte variabile","Gettito QV\nutenze non domestiche","QUOTA VARIABILE",null,"SOMMA QUOTA FISSA E QUOTA VARIABILE 2016","Gettito QF+QV","TARIFFA TOTALE 2015"]
[null,null,"Num oggetti X categoria","Superficie totale  categoria",null,"Sup.media locali",null,"Kc",null,"Quf","Euro","Euro/m2",null,"Kd","kg/anno stimati","Quv","Euro","Euro/m2",null,"Euro/m2","Euro","Euro/m2"]
[null,null,"n","m2",null,"m2 ",null,">5000 Abitanti","S*Kc","Ctapf / Somm S(ap) * Kc(ap)","Quf*S*Kc","Quf*Kc",null,null,"S*Kd","Qtot / Somm N(n) * Kb(n)","Sap*Kd (ap)*Cu","Quv*Kd",null,"QF+QV",null,"QF+QV"]
[1,"Musei, biblioteche, scuole, associazioni, luoghi di culto",22,11256.15,0.0583592043075321,511.6431818181818,"max",0.67,7541.6205,0.81,6108.712605000001,0.5427000000000001,"max",5.5,61908.825,0.14000992468864687,8667.849925812618,0.7700545857875578,null,1.312754585787558,14776.562530812618,1.2893]
[2,"Cinematografi e teatri",0,0,0,{"$error":"#DIV/0!"},"max",0.43,0,0.81,0,0.3483,"max",3.5,0,0.14000992468864687,0,0.49003473641026407,null,0,0]
[3,"Autorimesse e magazzini senza alcuna vendita diretta",140,47710.24,0.24736092213779937,340.78742857142856,"max",0.58,27671.939199999997,0.85,23521.148319999997,0.49299999999999994,"max",4.5,214696.08,0.14000992468864687,30059.581991747702,0.6300446610989109,null,1.1230446610989109,53580.7303117477,1.1811]
[4,"Campeggi, distributori carburanti, impianti sportivi",4,1092.44,0.005663919648700521,273.11,"max",0.88,961.3472,1,961.3472,0.88,"max",7.21,7876.4924,0.14000992468864687,1102.7871077346995,1.009471557005144,null,1.8894715570051441,2064.1343077346996,1.8587]
[5,"Esposizioni, autosaloni",11,2115.78,0.010969579944278485,192.3436363636364,"max",0.51,1079.0478,0.85,917.19063,0.4335,"max",4.22,8928.5916,0.14000992468864687,1250.091437491685,0.5908418821860898,null,1.0243418821860897,2167.2820674916848,1.0063]
[6,"Alberghi con ristorante",1,436,0.002260507640541748,436,"max",1.64,715.04,0.98,700.7392,1.6072,"max",13.45,5864.2,0.14000992468864687,821.046200359163,1.8831334870623002,null,3.4903334870623004,1521.7854003591628,3.4329]
[7,"Alberghi senza ristorante",3,1652,0.008565042711410476,550.6666666666666,"med",1.02,1685.04,1,1685.04,1.02,"med",8.32,13744.640000000001,0.14000992468864687,1924.3860112725636,1.164882573409542,null,2.184882573409542,3609.4260112725633,2.1494]
[8,"Case riposo, collegi e convitti",0,0,0,{"$error":"#DIV/0!"},"max",1.25,0,0.8,0,1,"max",10.22,0,0.14000992468864687,0,1.430901430317971,null,0,0]
[9,"Ospedali e case di cura",0,0,0,{"$error":"#DIV/0!"},"max",1.29,0,0.8,0,1.032,"max",10.55,0,0.14000992468864687,0,1.4771047054652247,null,0,0]
[10,"Uffici, agenzie, studi professionali, banche",123,14758.69,0.07651865025088782,119.98934959349594,"max",1.52,22433.2088,1.2,26919.85056,1.8239999999999998,"max",10.49,154818.6581,0.14000992468864687,21676.148660978368,1.4687041099839058,null,3.2927041099839056,48595.99922097837,3.514]
[11,"Attività commerciali per la vendita di beni non alimentari non altrimenti specificati",58,9402.97,0.04875111359813036,162.12017241379309,"max",1.41,13258.187699999999,0.81,10739.132037,1.1421000000000001,"max",9.45,88858.06649999999,0.14000992468864687,12441.011198643773,1.3230937883077127,null,2.4651937883077126,23180.143235643773,2.7099]
[12,"Banchi di mercato beni durevoli",0,0,0,{"$error":"#DIV/0!"},"max",1.78,0,0.81,0,1.4418000000000002,"max",14.58,0,0.14000992468864687,0,2.0413447019604716,null,3.4831447019604718,0,3.4209]
[13,"Attività artigianali tipo botteghe: parrucchiere, barbiere, estetista",16,889.48,0.004611642972727234,55.5925,"med",1.29,1147.4292,0.71,814.674732,0.9158999999999999,"med",10.57,9401.803600000001,0.14000992468864687,1316.3458139734491,1.4799049039589975,null,2.3958049039589975,2131.020545973449,2.3466]
[14,"Attività artigianali tipo botteghe: falegname, idraulico, fabbro, elettricista",17,2577.91,0.013365562503736186,151.64176470588234,"max",1.03,2655.2473,0.81,2150.750313,0.8343,"max",8.5,21912.235,0.14000992468864687,3067.9303721099323,1.1900843598534985,null,2.0243843598534985,5218.680685109932,1.9854]
[15,"Carrozzeria, autofficina, elettrauto",17,4763.95,0.024699415995777203,280.2323529411765,"med",1.25,5954.9375,0.81,4823.499375,1.0125000000000002,"med",10.22,48687.569,0.14000992468864687,6816.742868963299,1.430901430317971,null,2.443401430317971,11640.2422439633,2.4039]
[16,"Attività artigianali e industriali con capannoni di produzione",106,87110.35,0.4516367241863896,821.7957547169812,"max",0.92,80141.52200000001,0.8,64113.21760000001,0.7360000000000001,"max",7.5,653327.625,0.14000992468864687,91472.35157326252,1.0500744351648514,null,1.7860744351648514,155585.56917326254,1.7673]
[17,"Pubblici esercizi classe A (ristoranti,pizzerie,..)",13,2115.86,0.010969994716322621,162.75846153846155,"min",5.57,11785.3402,0.3,3535.60206,1.671,"min",44.1,93309.426,0.14000992468864687,13064.24570700087,6.174437678769327,null,7.845437678769327,16599.84776700087,7.8704]
[18,"Bar, caffè, pasticceria",16,1603.92,0.00831576471288468,100.245,"min",3.96,6351.5232000000005,0.88,5589.340416000001,3.4848,"min",32.44,52031.1648,0.14000992468864687,7284.879465110574,4.541921956899704,null,8.026721956899703,12874.219881110574,7.8883]
[19,"Attività commerciali per la vendita di beni alimentari e fiori e piante (ORTOFR/PESCH/FIORI..)",15,998.29,0.0051757847992578475,66.55266666666667,"min",7.1,7087.8589999999995,0.2,1417.5718,1.42,"min",56.1,56004.068999999996,0.14000992468864687,7841.125482947782,7.85455677503309,null,9.27455677503309,9258.697282947782,9.4102]
[20,"Supermercati e ipermercati per la vendita di generi misti",11,2895.77,0.015013555528099949,263.2518181818182,"max",1.9,5501.963,1.2,6602.3556,2.28,"max",22.2,64286.094,0.14000992468864687,9000.691179467272,3.1082203280879606,null,5.388220328087961,15603.046779467273,6.3354]
[21,"Banchi di mercato generi alimentari",0,0,0,{"$error":"#DIV/0!"},"max",6.92,0,1,0,6.92,"max",56.78,0,0.14000992468864687,0,7.949763523821369,null,0,0,0]
[22,"Discoteche, night club",3,1497.23,0.007762614345523673,499.07666666666665,"max",1.95,2919.5985,1.2,3503.5182,2.34,"max",15,22458.45,0.14,3144.1830000000004,2.1,null,4.4399999999999995,6647.7012,4.4204]
[null,"Totale",576,192877.03000000003,1,334.8559548611112,null,44.870000000000005,198890.85109999997,null,164103.69064800002,null,null,365.4,1578113.9899999998,null,220951.39799687624,null,null,null,385055.08864487626]
[null,null,"Num oggetti","Superficie totale  ",null,"Sup.media locali"]
[null,"TOTALE GENERALE",3483,609300.16,null,174.93544645420616,null,null,611196.3782,null,349632.37626100006,{"$nulls":5},586026.1979968763]
{"$rows_empty":48}
[null,null,0]

{"sheet":"2012-2013","index":2,"n_rows":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":15}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]

{"sheet":"RID-AGEV","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}