{"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":16,"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",2014]
["COMUNE DI POVIGLIO"]
["COSTI ","PARTE FISSA","PARTE VARIABILE","TOTALE"]
[null,0.3,0.7]
["SERVIZIO RACC-SMALT SABAR",243898.38,569096.22,812994.6]
["FONDO RISCHI PER CREDITI ",30000,null,30000]
["SERVIZI COMUNE",30444,null,30444]
["CARC SABAR",57742,null,57742]
[]
["SOMMANO",362084.38,569096.22,931180.6]
[null,0.3888444196539318,0.6111555803460682,1]
[]
["% COPERTURA 2014",null,null,1]
[]
["PREVISIONE ENTRATA",null,null,931180.6]
["AGEVOLAZIONI PREVISTE DA REGOLAMENTO",0,null,0]
["ENTRATA TEORICA",362084.38,569096.22,931180.6]
[]
[]
["UTENZE DOMESTICHE",191904.72,354546.94506,546451.66506]
["% su totale di colonna",0.53,0.623,0.5868]
["% su totale utenze domestiche",0.3511833383816828,0.6488166616183171,0.9999999999999999]
[]
["UTENZE NON DOMESTICHE",170179.66,214549.27494,384728.93494]
["% su totale di colonna",0.47,0.377,0.41316253253128343]
["% su totale utenze non domestiche",0.442336524614506,0.557663475385494,1]
[]
["QUANTITATIVI  CONSUNTIVO 2013"]
[null,"Kg","%"]
["TOTALE R.S.U.",5099804]
["DA AREE PUBBLICHE DA DETRARRE",509980.4,0.1]
["A CARICO UTENZE",4589823.6]
["UTENZE NON DOMESTICHE ",1730363,0.377]
["UTENZE DOMESTICHE ",2859460.5999999996,0.623]
[]
["OCCUPANTI NON RESIDENTI",2]

{"sheet":"Calcolo Tariffe","index":1,"n_rows":91,"n_cols":23,"rows_kept":91,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"POVIGLIO"]
[null,"UTENZE DOMESTICHE",{"$nulls":5},"CALCOLO TARIFFA PARTE FISSA",{"$nulls":5},"CALCOLO TARIFFA PARTE VARIABILE",{"$nulls":4},"TOTALE TARIFFA","TOTALE GETTITO"]
[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 2014","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"]
[{"$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.30987821380243574,107.30786026200873,null,0.8,78635.20000000001,0.37,29095.024,0.296,"max",1,916,72,65952,72,103.76312663755458,95047.024]
[null,"Famiglie di 2 componenti ",777,122476,0.2628552097428958,157.62676962676963,null,0.94,115127.43999999999,0.4,46050.976,0.376,"max",1.8,1398.6000000000001,62,86713.20000000001,111.60000000000001,170.8676653796654,132764.176]
[null,"Famiglie di 3 componenti ",608,91440,0.20568335588633288,150.39473684210526,null,1.05,96012,0.43,41285.159999999996,0.4515,"adhoc",2.2,1337.6000000000001,66,88281.6,145.20000000000002,213.10322368421055,129566.76000000001]
[null,"Famiglie di 4 componenti ",449,70681,0.15189445196211096,157.41870824053453,null,1.14,80576.34,0.57,45928.51379999999,0.6497999999999999,"med",2.6,1167.4,64,74713.6,166.4,268.6906766146993,120642.11379999999]
[null,"Famiglie di 5 componenti ",132,23835,0.044654939106901215,180.5681818181818,null,1.23,29317.05,0.63,18469.7415,0.7749,"min",2.9,382.8,63,24116.4,182.7,322.6222840909091,42586.1415]
[null,"Famiglie di =>6 componenti ",74,14346,0.02503382949932341,193.86486486486487,null,1.3,18649.8,0.6,11189.880000000001,0.78,"min",3.4,251.6,59,14844.4,200.6,351.8145945945946,26034.28]
[null,"Totali",2956,421072,1,142.446549391069,null,null,418317.82999999996,null,192019.2953,null,null,null,5454.000000000001,null,354621.20000000007,null,null,546640.4953000001]
[]
[null,"UTENZE NON DOMESTICHE",{"$nulls":5},"CALCOLO TARIFFA PARTE FISSA",{"$nulls":5},"CALCOLO TARIFFA PARTE VARIABILE",{"$nulls":5},"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","Gettito QF+QV"]
[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"]
[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"]
[1,"Musei, biblioteche, scuole, associazioni, luoghi di culto",19,7519.15,0.03891525943031867,395.7447368421052,"max",0.67,5037.8305,0.81,4080.642705,0.5427000000000001,"max",5.5,41355.325,0.1285708065934428,5317.0874921839695,0.7071394362639354,1.2498394362639353,9397.73019718397]
[2,"Cinematografi e teatri",0,0,0,{"$error":"#DIV/0!"},"max",0.43,0,0.81,0,0.3483,"max",3.5,0,0.1285708065934428,0,0.44999782307704983,0.7982978230770499,0]
[3,"Autorimesse e magazzini senza alcuna vendita diretta",135,52066.73,0.26947065900246125,385.6794814814815,"max",0.6,31240.038,0.86,26866.43268,0.516,"max",4.9,255126.97700000004,0.1285708065934428,32801.881216636735,0.6299969523078698,1.1459969523078697,59668.31389663674]
[4,"Campeggi, distributori carburanti, impianti sportivi",4,1249,0.006464182657410482,312.25,"max",0.88,1099.1200000000001,1,1099.1200000000001,0.88,"max",7.21,9005.289999999999,0.1285708065934428,1157.8173989078643,0.9269955155387226,1.8069955155387225,2256.9373989078645]
[5,"Esposizioni, autosaloni",14,2800.78,0.014495399121875205,200.0557142857143,"max",0.51,1428.3978000000002,0.85,1214.13813,0.4335,"max",4.22,11819.2916,0.1285708065934428,1519.6158543751033,0.5425688038243286,0.9760688038243286,2733.7539843751033]
[6,"Alberghi con ristorante",1,436,0.0022565121206012573,436,"max",1.64,715.04,0.98,700.7392,1.6072,"max",13.45,5864.2,0.1285708065934428,753.9649240252672,1.7292773486818056,3.3364773486818056,1454.7041240252672]
[7,"Alberghi senza ristorante",3,1652,0.008549903723012103,550.6666666666666,"med",1.02,1685.04,1,1685.04,1.02,"med",8.32,13744.640000000001,0.1285708065934428,1767.1594511364979,1.0697091108574441,2.089709110857444,3452.199451136498]
[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.1285708065934428,0,1.3139936433849855,2.3139936433849853,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.1285708065934428,0,1.3564220095608217,2.3884220095608217,0]
[10,"Uffici, agenzie, studi professionali, banche",135,16285.47,0.08428523037772512,120.6331111111111,"max",1.52,24753.914399999998,1.2,29704.697279999997,1.8239999999999998,"max",12.45,202754.1015,0.1285708065934428,26068.25836998377,1.6007065420883628,3.4247065420883627,55772.95564998376]
[11,"Attività commerciali per la vendita di beni non alimentari non altrimenti specificati",62,7731.95,0.04001660296074057,124.70887096774193,"max",1.41,10902.0495,0.81,8830.660095,1.1421000000000001,"max",11.55,89304.0225,0.1285708065934428,11481.890204863965,1.4849928161542645,2.6270928161542644,20312.550299863964]
[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.1285708065934428,0,1.8745623601323962,3.3163623601323966,0]
[13,"Attività artigianali tipo botteghe: parrucchiere, barbiere, estetista",14,885.53,0.004583048573752365,63.25214285714286,"med",1.29,1142.3337,0.71,811.0569269999999,0.9158999999999999,"med",10.54,9333.4862,0.1285708065934428,1200.0138490627673,1.355136301494887,2.271036301494887,2011.0707760627672]
[14,"Attività artigianali tipo botteghe: falegname, idraulico, fabbro, elettricista",15,2763.02,0.014299972751063499,184.20133333333334,"max",1.03,2845.9106,0.81,2305.1875860000005,0.8343,"max",8.48,23430.409600000003,0.1285708065934428,3012.4666610867457,1.090280439912395,1.9245804399123951,5317.654247086746]
[15,"Carrozzeria, autofficina, elettrauto",20,4654.95,0.02409163095365326,232.7475,"med",1.25,5818.6875,0.81,4713.136875,1.0125000000000002,"med",10.25,47713.237499999996,0.1285708065934428,6134.529430559502,1.3178507675827889,2.330350767582789,10847.666305559502]
[16,"Attività artigianali e industriali con capannoni di produzione",121,84994.45,0.43988762983678326,702.4334710743801,"max",0.92,78194.894,0.81,63337.864140000005,0.7452000000000001,"max",7.53,640008.2085,0.1285708065934428,82286.37159326932,0.9681381736486243,1.7133381736486244,145624.2357332693]
[17,"Pubblici esercizi classe A (ristoranti,pizzerie,..)",13,2095.38,0.010844610934095097,161.18307692307692,"min",5.57,11671.2666,0.3,3501.37998,1.671,"min",45.67,95696.00460000001,0.1285708065934428,12303.712499191815,5.8718287371225335,7.542828737122534,15805.092479191815]
[18,"Bar, caffè, pasticceria",15,1634.92,0.008461506413333503,108.99466666666667,"min",3.96,6474.2832,0.88,5697.369216,3.4848,"min",32.44,53036.8048,0.1285708065934428,6818.984772274979,4.170836965891285,7.655636965891285,12516.35398827498]
[19,"Attività commerciali per la vendita di beni alimentari e fiori e piante (ORTOFR/PESCH/FIORI..)",17,1233.49,0.006383910861560653,72.55823529411765,"min",7.17,8844.1233,0.2,1768.82466,1.4340000000000002,"min",58.76,72479.8724,0.1285708065934428,9318.795656257813,7.554820595430699,8.988820595430699,11087.620316257813]
[20,"Supermercati e ipermercati per la vendita di generi misti",5,2403.27,0.012438091477241705,480.654,"max",2.74,6584.9598000000005,1.2,7901.95176,3.2880000000000003,"max",22.45,53953.411499999995,0.1285708065934428,6936.833635022932,2.886414608022791,6.174414608022792,14838.785395022933]
[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.1285708065934428,0,7.300250398375683,14.220250398375683,0]
[22,"Discoteche, night club",5,2812.46,0.014555848804372044,562.492,"max",1.91,5371.7986,1.2,6446.15832,2.292,"max",15.68,44099.3728,0.1285708065934428,5669.891931160932,2.015990247385183,4.307990247385183,12116.05025116093]
[null,"Totale",598,193218.55,1,323.1079431438127,null,45.760000000000005,203809.68750000003,null,170664,null,null,375.03000000000003,1668724.6555,null,214549.27493999994,null,null,384544.59]
[null,null,"Num oggetti","Superficie totale  ",null,"Sup.media locali"]
[null,"TOTALE GENERALE",3554,614290.55,null,172.8448368036016,null,null,622127.5175,null,362683.2953,{"$nulls":5},569170.47494,{"$nulls":5},931185.0853000002]
{"$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]