{"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",2017]
["COMUNE DI POVIGLIO"]
["COSTI ","PARTE FISSA","PARTE VARIABILE","TOTALE"]
[null,0.3,0.7]
["COSTI  DA PIANO ECONOMICO FINANZIARIO DI SABAR SERVIZI SRL ",251334.6,586447.4,837782]
["CARC -COSTI DI ACCERTAMENTO E RISCOSSIONE con Unione/Sabar",26100,null,26100]
["FONDO RISCHI ED AGEVOLAZIONI",72271,null,72271]
["TOTALE SPESA PREVENTIVATA 2017",349705.6,586447.4,936153]
[null,0.37355603197340603,0.626443968026594,1]
[]
["% COPERTURA 2016",null,null,1]
[]
["PREVISIONE ENTRATA",null,null,936153]
[null,0,null,0]
["ENTRATA TEORICA",349705.6,586447.4,936153]
[]
[]
["UTENZE DOMESTICHE",185343.968,365356.7302,550523.04]
["% su totale di colonna",0.53,0.623,0.5868]
["% su totale utenze domestiche",0.33666886675623964,0.6636538412633919,1.0003227080196315]
[]
["UTENZE NON DOMESTICHE",164361.63199999998,221090.6698,385629.96]
["% su totale di colonna",0.47,0.377,0.41193048572188523]
["% su totale utenze non domestiche",0.42621592990337154,0.5733233740449004,0.999539303948272]
[]
["QUANTITATIVI DA  PRE CONSUNTIVO 2016 dato provvisorio"]
[null,"Kg","%"]
["TOTALE RIFIUTI SMALTITI",5174500]
["DA AREE PUBBLICHE DA DETRARRE",517450,0.1]
["A CARICO UTENZE",4657050]
["UTENZE NON DOMESTICHE ",1743807,0.337]
["UTENZE DOMESTICHE ",2913243,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 ",870,109950,0.29845626072041165,126.38,null,0.8,87960,0.35,30786,0.27999999999999997,"max",1.03,896.1,69,61830.9,71.07000000000001,35.386399999999995,106.4564,92616.9,105.79]
[null,"Famiglie di 2 componenti ",784,116901.04,0.26895368782161233,149.11,null,0.95,111055.98799999998,0.39,43311.83532,0.3705,"max",1.86,1458.24,63,91869.12,117.18,55.24525500000001,172.42525500000002,135180.95532,172.93]
[null,"Famiglie di 3 componenti ",560,84963.63,0.19210977701543738,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.158147512864494,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.04905660377358491,163.68,null,1.23,28789.4784,0.62,17849.476608,0.7626,"min",2.96,423.28,64,27089.92,189.44,124.822368,314.262368,44939.396607999995,312.87]
[null,"Famiglie di =>6 componenti ",97,14874.05,0.033276157804459694,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",2915,417416.32999999996,1,143.19599656946826,null,null,413100.0871,null,186678.436013,null,null,null,5604.839999999999,null,363761.83999999997,null,null,null,550440.2760129999]
[]
[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.13348719493317704,8264.035390858944,0.7341795721324738,null,1.276879572132474,14372.747995858945,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.13348719493317704,0,0.4672051822661196,null,0,0]
[3,"Autorimesse e magazzini senza alcuna vendita diretta",140,47710.24,0.24736092213779937,340.78742857142856,"max",0.58,27671.939199999997,0.86,23797.867711999996,0.49879999999999997,"max",4.9,233780.176,0.13348719493317704,31206.659925224438,0.6540872551725675,null,1.1528872551725675,55004.52763722443,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.13348719493317704,1051.4108763884874,0.9624426754682065,null,1.8424426754682064,2012.7580763884876,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.13348719493317704,1191.852647387927,0.5633159626180071,null,0.9968159626180071,2109.043277387927,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.13348719493317704,782.7956085271368,1.795402771851231,null,3.402602771851231,1483.5348085271366,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.13348719493317704,1834.7334389663426,1.110613461844033,null,2.130613461844033,3519.773438966343,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.13348719493317704,0,1.3642391322170695,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.13348719493317704,0,1.4082899065450178,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",12.45,183745.6905,0.13348719493317704,24527.696805904718,1.661915576918054,null,3.485915576918054,51447.54736590471,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",11.55,108604.3035,0.13348719493317704,14497.283831886421,1.541777101478195,null,2.683877101478195,25236.41586888642,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.13348719493317704,0,1.9462433021257213,null,3.3880433021257215,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.54,9375.1192,0.13348719493317704,1251.4583641721706,1.4069550345956858,null,2.322855034595686,2066.1330961721706,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.48,21860.6768,0.13348719493317704,2918.120425372781,1.1319714130333414,null,1.9662714130333414,5068.8707383727815,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.25,48830.487499999996,0.13348719493317704,6518.2448035945645,1.3682437480650647,null,2.380743748065065,11341.744178594565,2.4039]
[16,"Attività artigianali e industriali con capannoni di produzione",106,87110.35,0.4516367241863896,821.7957547169812,"max",0.92,80141.52200000001,0.81,64914.63282000001,0.7452000000000001,"max",7.53,655940.9355,0.13348719493317704,87559.71552173901,1.005158577846823,null,1.7503585778468231,152474.34834173904,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",45.67,96631.32620000001,0.13348719493317704,12899.044677110818,6.096360192598196,null,7.767360192598196,16434.64673711082,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.13348719493317704,6945.494238257859,4.3303246036322625,null,7.815124603632262,12534.83465425786,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",58.76,58659.520399999994,0.13348719493317704,7830.294834321475,7.843707574273482,null,9.263707574273482,9247.866634321475,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.45,65010.036499999995,0.13348719493317704,8678.007414888454,2.9967875262498245,null,5.276787526249825,15280.363014888455,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.13348719493317704,0,7.579402928305792,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.68,23476.5664,0.14,3286.719296,2.1952000000000003,null,4.5352,6790.237496,4.4204]
[null,"Totale",576,192877.03000000003,1,334.8559548611112,null,44.870000000000005,198890.85109999997,null,165181.82526,null,null,375.03000000000003,1656268.7522999998,null,221243.56810060155,null,null,null,386425.3933606015]
[null,null,"Num oggetti","Superficie totale  ",null,"Sup.media locali"]
[null,"TOTALE GENERALE",3491,610293.36,null,174.8190661701518,null,null,611990.9382,null,351860.26127300004,{"$nulls":5},585005.4081006015]
{"$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"]}