{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Economico","Calcolo Tariffe","2012-2013"],"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":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[27,0,27,2]],"flags":["formulas_cached_only"]}
["BILANCIO ANNO",2015]
["COMUNE DI POVIGLIO"]
["COSTI ","PARTE FISSA","PARTE VARIABILE","TOTALE"]
[null,0.3,0.7]
["SERVIZIO RACC-SMALT SABAR",250515.87,584537.13,835053]
["FONDO RISCHI PER CREDITI ",30000,null,30000]
["FONDO COMUNE PER SERVIZI",39349,null,39349]
["CARC -Unione/Sabar",31836,null,31836]
[]
["TOTALE SPESA PRESUNTA 2015",351700.87,584537.13,936238]
[null,0.3756532740606555,0.6243467259393445,1]
[]
["% COPERTURA 2015",null,null,1]
[]
["PREVISIONE ENTRATA",null,null,936238]
[null,0,null,0]
["ENTRATA TEORICA",351700.87,584537.13,936238]
[]
[]
["UTENZE DOMESTICHE",186700.87,364166.63199,550867.5]
["% su totale di colonna",0.53,0.623,0.5868]
["% su totale utenze domestiche",0.33892155554647896,0.661078448066005,1.000000003612484]
[]
["UTENZE NON DOMESTICHE",165000,220370.49801,385370.5]
["% su totale di colonna",0.47,0.377,0.41161595662641337]
["% su totale utenze non domestiche",0.4281593946604631,0.5718406001756752,0.9999999948361382]
[]
["QUANTITATIVI  CONSUNTIVO 2014"]
[null,"Kg","%"]
["TOTALE R.S.U.",5481000]
["DA AREE PUBBLICHE DA DETRARRE",548100,0.1]
["A CARICO UTENZE",4932900]
["UTENZE NON DOMESTICHE ",1859703.3,0.377]
["UTENZE DOMESTICHE ",3073196.7,0.623]
[]
["OCCUPANTI NON RESIDENTI",2]

{"sheet":"Calcolo Tariffe","index":1,"n_rows":91,"n_cols":24,"rows_kept":91,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"COMUNE DI","POVIGLIO",{"$nulls":14},"CONFRONTO "," TARIFFE 2013 / 2015",null,null,"AUMENTO "]
[null,"UTENZE DOMESTICHE",{"$nulls":5},"CALCOLO TARIFFA PARTE FISSA",{"$nulls":5},"CALCOLO TARIFFA PARTE VARIABILE",{"$nulls":4},"TOTALE TARIFFA","TOTALE TARIFFA","TOTALE TARIFFA","TOTALE GETTITO","annuo"]
[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 2013","TARIFFA MEDIA 2014","TARIFFA MEDIA 2015","Gettito QF+QV"]
[null,null,"n","m2","%","m2",null,"Ka",null,"Quf","Euro","Euro/m2",null,"Kb",null,"Quv","Euro","Euro/Utenza","Euro/Utenza","Euro/Utenza","Euro/Utenza","Euro","Differenza","PERCENTUALE SCOSTAMENTO 2014/2015"]
[{"$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 ",916,98294,0.31040325313453065,107.30786026200873,null,0.8,78635.20000000001,0.35,27522.319999999996,0.27999999999999997,"max",1.03,943.48,72,67930.56,74.16,99.81,103.76,104.20620087336243,95452.87999999999,0.45]
[null,"Famiglie di 2 componenti ",775,123200,0.2626228397153507,158.96774193548387,null,0.94,115808,0.39,45165.119999999995,0.3666,"max",1.86,1441.5,62,89373,115.32000000000001,165.5,170.87,173.59757419354838,134538.12,2.73]
[null,"Famiglie di 3 componenti ",597,91440,0.20230430362588953,153.16582914572865,null,1.05,96012,0.43,41285.159999999996,0.4515,"adhoc",2.25,1343.25,66,88654.5,148.5,204.86,213.1,217.65437185929648,129939.66,4.5]
[null,"Famiglie di 4 componenti ",458,70950,0.15520162656726533,154.9126637554585,null,1.14,80883,0.54,43676.82,0.6156,"med",2.68,1227.44,64,78556.16,171.52,256.89,268.69,266.88423580786025,122232.98000000001,"meno 1,81"]
[null,"Famiglie di 5 componenti ",131,23700,0.04439173161640122,180.91603053435114,null,1.23,29151,0.62,18073.62,0.7626,"min",2.96,387.76,63,24428.88,186.48,308.99,322.62,324.4465648854962,42502.5,1.83]
[null,"Famiglie di =>6 componenti ",74,14346,0.02507624534056252,193.86486486486487,null,1.3,18649.8,0.6,11189.880000000001,0.78,"min",3.42,253.07999999999998,59,14931.72,201.78,340.08,351.81,352.9945945945946,26121.6,1.18]
[null,"Totali",2951,421930,1,142.97865130464248,null,null,419139,null,186912.91999999998,null,null,null,5596.51,null,363874.81999999995,{"$nulls":4},550787.74]
[]
[null,"UTENZE NON DOMESTICHE",{"$nulls":5},"CALCOLO TARIFFA PARTE FISSA",{"$nulls":5},"CALCOLO TARIFFA PARTE VARIABILE",{"$nulls":5},"NON DOMESTICO",null,"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","TARIFFA TOTALE 2013","TARIFFA TOTALE 2014","TARIFFA TOTALE 2015","Gettito QF+QV","AUMENTO"]
[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","Euro/m2","Euro/m2","Euro/m2","Euro","euro/ mq"]
[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","QF+QV","QF+QV","QF+QV"]
[1,"Musei, biblioteche, scuole, associazioni, luoghi di culto",19,7519.15,0.03990688331972791,395.7447368421052,"max",0.67,5037.8305,0.81,4080.642705,0.5427000000000001,"max",5.5,41355.325,0.13574248235092531,5613.67447392928,0.7465836529300892,1.2199,1.2498,1.2892836529300893,9694.31717892928,0.04]
[2,"Cinematografi e teatri",0,0,0,{"$error":"#DIV/0!"},"max",0.43,0,0.81,0,0.3483,"max",3.5,0,0.13574248235092531,0,0.4750986882282386,0.7792,0.7983,0.8233986882282386,0,0.03]
[3,"Autorimesse e magazzini senza alcuna vendita diretta",130,51975,0.2758503634776348,399.8076923076923,"max",0.6,31185,0.86,26819.1,0.516,"max",4.9,254677.50000000003,0.13574248235092531,34570.556048927785,0.6651381635195341,1.1193,1.146,1.1811381635195342,61389.65604892778,0.04]
[4,"Campeggi, distributori carburanti, impianti sportivi",4,1249,0.006628900509544317,312.25,"max",0.88,1099.1200000000001,1,1099.1200000000001,0.88,"max",7.21,9005.289999999999,0.13574248235092531,1222.4004188899642,0.9787032977501715,1.759,1.807,1.8587032977501714,2321.5204188899643,0.05]
[5,"Esposizioni, autosaloni",14,2800.78,0.014864765387607315,200.0557142857143,"max",0.51,1428.3978000000002,0.85,1214.13813,0.4335,"max",4.22,11819.2916,0.13574248235092531,1604.37998141344,0.5728332755209048,0.9583,0.9761,1.006333275520905,2818.5181114134402,0.03]
[6,"Alberghi con ristorante",1,436,0.002314011707094734,436,"max",1.64,715.04,0.98,700.7392,1.6072,"max",13.45,5864.2,0.13574248235092531,796.0210650022962,1.8257363876199453,3.3126,3.3365,3.4329363876199452,1496.7602650022961,0.1]
[7,"Alberghi senza ristorante",3,1652,0.008767769128716744,550.6666666666666,"med",1.02,1685.04,1,1685.04,1.02,"med",8.32,13744.640000000001,0.13574248235092531,1865.7315526198222,1.1293774531596987,2.0546,2.0897,2.1493774531596985,3550.771552619822,0.06]
[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.13574248235092531,0,1.3872881696264567,2.2709,2.314,2.3872881696264567,0,0.07]
[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.13574248235092531,0,1.4320831888022623,2.3439,2.3884,2.4640831888022623,0,0.08]
[10,"Uffici, agenzie, studi professionali, banche",125,14320,0.07600148542568025,114.56,"max",1.52,21766.4,1.2,26119.68,1.8239999999999998,"max",12.45,178284,0.13574248235092531,24200.71272345237,1.68999390526902,3.0682,3.4247,3.51399390526902,50320.39272345237,0.09]
[11,"Attività commerciali per la vendita di beni non alimentari non altrimenti specificati",62,7731.95,0.04103629086851176,124.70887096774193,"max",1.41,10902.0495,0.81,8830.660095,1.1421000000000001,"max",11.55,89304.0225,0.13574248235092531,12122.349698072889,1.5678256711531875,2.5643,2.6271,2.7099256711531874,20953.009793072888,0.08]
[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.13574248235092531,0,1.9791253926764911,3.2371,3.3164,3.4209253926764913,0,0.1]
[13,"Attività artigianali tipo botteghe: parrucchiere, barbiere, estetista",16,986,0.005233063172466531,61.625,"med",1.29,1271.94,0.71,903.0774,0.9158999999999999,"med",10.54,10392.439999999999,0.13574248235092531,1410.69560328305,1.4307257639787527,2.2137,2.271,2.3466257639787527,2313.77300328305,0.08]
[14,"Attività artigianali tipo botteghe: falegname, idraulico, fabbro, elettricista",15,2763.02,0.014664359236093787,184.20133333333334,"max",1.03,2845.9106,0.81,2305.1875860000005,0.8343,"max",8.48,23430.409600000003,0.13574248235092531,3180.5019616029513,1.1510962503358466,1.8785,1.9246,1.9853962503358467,5485.689547602951,0.1]
[15,"Carrozzeria, autofficina, elettrauto",20,4654.95,0.024705524761331723,232.7475,"med",1.25,5818.6875,0.81,4713.136875,1.0125000000000002,"med",10.25,47713.237499999996,0.13574248235092531,6476.713299249257,1.3913604440969845,2.2746,2.3304,2.403860444096985,11189.850174249257,0.08]
[16,"Attività artigianali e industriali con capannoni di produzione",113,82150,0.43600014160053296,726.9911504424779,"max",0.92,75578,0.81,61218.18000000001,0.7452000000000001,"max",7.53,618589.5,0.13574248235092531,83968.87428621772,1.0221408921024677,1.6724,1.7133,1.7673408921024678,145187.05428621772,0.05]
[17,"Pubblici esercizi classe A (ristoranti,pizzerie,..)",13,2095.38,0.011120949199110467,161.18307692307692,"min",5.57,11671.2666,0.3,3501.37998,1.671,"min",45.67,95696.00460000001,0.13574248235092531,12990.01321546957,6.199359168966759,10.4695,7.5428,7.870359168966759,16491.39319546957,0.33]
[18,"Bar, caffè, pasticceria",15,1634.92,0.008677119312301198,108.99466666666667,"min",3.96,6474.2832,0.88,5697.369216,3.4848,"min",32.44,53036.8048,0.13574248235092531,7199.347539513471,4.403486127464017,7.4397,7.6556,7.888286127464017,12896.716755513471,0.23]
[19,"Attività commerciali per la vendita di beni alimentari e fiori e piante (ORTOFR/PESCH/FIORI..)",17,1233.49,0.006546583258220833,72.55823529411765,"min",7.17,8844.1233,0.2,1768.82466,1.4340000000000002,"min",58.76,72479.8724,0.13574248235092531,9838.597800054318,7.976228262940372,8.5977,8.9888,9.410228262940372,11607.422460054318,0.42]
[20,"Supermercati e ipermercati per la vendita di generi misti",5,2403.27,0.012755034209425599,480.654,"max",2.74,6584.9598000000005,1.2,7901.95176,3.2880000000000003,"max",22.45,53953.411499999995,0.13574248235092531,7323.77000831096,3.0474187287782732,5.5318,6.1744,6.335418728778274,15225.72176831096,0.16]
[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.13574248235092531,0,7.707458147885539,13.8424,14.2203,14.62745814788554,0]
[22,"Discoteche, night club",5,2812.46,0.014926755425999208,562.492,"max",1.91,5371.7986,1.2,6446.15832,2.292,"max",15.68,44099.3728,0.13574248235092531,5986.158333990876,2.128442123262509,3.8599,4.308,4.420442123262509,12432.316653990874,0.11]
[null,"Totale",577,188417.36999999997,1,326.5465684575389,null,45.760000000000005,198279.84740000006,null,165004.38592699997,null,null,375.03000000000003,1623445.3223,null,220370.49800999998,{"$nulls":4},385374.883937]
[null,null,"Num oggetti","Superficie totale  ",null,"Sup.media locali"]
[null,"TOTALE GENERALE",3528,610347.37,null,173.0009552154195,null,null,617418.8474000001,null,351917.30592699995,{"$nulls":5},584245.3180099999]
{"$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]