{"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",2013]
["COMUNE DI POVIGLIO"]
["COSTI ","PARTE FISSA","PARTE VARIABILE","TOTALE"]
[null,0.3,0.7]
["SERVIZIO RACC-SMALT SABAR",234397.58,546927.69,781325.2699999999]
["f.do rischi crediti",30000,null,30000]
["SERVIZI COMUNE",39350,null,39350]
["CARC SABAR",57742,null,57742]
[]
["SOMMANO",361489.57999999996,546927.69,908417.2699999999]
[null,0.3979334078490163,0.6020665921509837,1]
[]
["% COPERTURA 2013",null,null,1]
[]
["PREVISIONE ENTRATA",null,null,908417.2699999999]
["AGEVOLAZIONI PREVISTE DA REGOLAMENTO",0,null,0]
["ENTRATA TEORICA",361489.57999999996,546927.69,908417.2699999999]
[]
[]
["UTENZE DOMESTICHE",193352.41,339414.2707100532,532766.6807100532]
["% su totale di colonna",0.53,0.6205834462505514,0.5864779306871315]
["% su totale utenze domestiche",0.3629213631421292,0.6370786368578709,1]
[]
["UTENZE NON DOMESTICHE",168137.16999999995,207513.41928994667,375650.5892899466]
["% su totale di colonna",0.47,0.3794165537494485,0.41352206931286833]
["% su totale utenze non domestiche",0.447589261919733,0.5524107380802671,1]
[]
["QUANTITATIVI  CONSUNTIVO 2012"]
[null,"Kg","%"]
["TOTALE R.S.U.",4886815]
["DA AREE PUBBLICHE DA DETRARRE",488681.5,0.1]
["A CARICO UTENZE",4398133.5]
["UTENZE NON DOMESTICHE ",1668724.6555,0.3794165537494485]
["UTENZE DOMESTICHE ",2729408.8444999997,0.6205834462505514]
[]
["OCCUPANTI NON RESIDENTI",2]

{"sheet":"Calcolo Tariffe","index":1,"n_rows":91,"n_cols":25,"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",null,null,null,"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 2013","TARIFFA MEDIA 2012","delta annuo","%","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",null,"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 ",757,98294,0.2610344827586207,129.84676354029062,null,0.8,78635.20000000001,0.37,29095.024,0.296,"max",1,757,61.37801238902209,46463.15537848972,61.37801238902209,99.81265439694812,99.76,0.05265439694811391,0.0005278107151976133,75558.17937848972,null,86.04]
[null,"Famiglie di 2 componenti ",837,122476,0.2886206896551724,146.3273596176822,null,0.94,115127.43999999999,0.4,46050.976,0.376,"max",1.8,1506.6000000000001,61.37801238902209,92472.11346530069,110.48042230023977,165.49950951648827,163.56,1.9395095164882719,0.011858091932552408,138523.0894653007,null,144.07]
[null,"Famiglie di 3 componenti ",605,91440,0.20862068965517241,151.1404958677686,null,1.05,96012,0.44,42245.28,0.462,"adhoc",2.2,1331,61.37801238902209,81694.1344897884,135.0316272558486,204.85853634675772,201.94,2.918536346757719,0.01445249255599544,123939.4144897884,null,171.97]
[null,"Famiglie di 4 componenti ",472,70681,0.16275862068965516,149.7478813559322,null,1.14,80576.34,0.57,45928.51379999999,0.6497999999999999,"med",2.6,1227.2,61.37801238902209,75323.09680380792,159.58283221145743,256.88900551654217,253.06,3.8290055165421677,0.01513082081933995,121251.6106038079,null,199.34]
[null,"Famiglie di 5 componenti ",141,23835,0.04862068965517241,169.04255319148936,null,1.23,29317.05,0.63,18469.7415,0.7749,"min",2.9,408.9,61.37801238902209,25097.469265871132,177.99623592816405,308.9873103962492,302.28,6.707310396249227,0.02218906443115399,43567.21076587113,null,219.39]
[null,"Famiglie di =>6 componenti ",88,14346,0.030344827586206897,163.02272727272728,null,1.3,18649.8,0.62,11562.876,0.806,"min",3.4,299.2,61.37801238902209,18364.30130679541,208.6852421226751,340.08156030449334,333.62,6.461560304493332,0.01936802441248526,29927.17730679541,null,247.32]
[null,"Totali",2900,421072,1,145.19724137931036,null,null,418317.82999999996,null,193352.41129999998,null,null,null,5529.9,null,339414.2707100533,{"$nulls":5},532766.6820100532]
[]
[null,"UTENZE NON DOMESTICHE",{"$nulls":5},"CALCOLO TARIFFA PARTE FISSA",{"$nulls":5},"CALCOLO TARIFFA PARTE VARIABILE",{"$nulls":8},"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",null,null,null,"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",null,null,null,"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.8,4030.2644,0.536,"max",5.5,41355.325,0.1243544994711961,5142.7207408436425,0.6839497470915785,1.2199497470915786,1.2193,0.0006497470915785009,0.0005328853371430335,9172.985140843643,null,0.86]
[2,"Cinematografi e teatri",0,0,0,{"$error":"#DIV/0!"},"max",0.43,0,0.8,0,0.34400000000000003,"max",3.5,0,0.1243544994711961,0,0.43524074814918634,0.7792407481491863,0.7792,4.074814918630931e-05,5.2294852651834335e-05,0,null,0.55]
[3,"Autorimesse e magazzini senza alcuna vendita diretta",135,52066.73,0.26947065900246125,385.6794814814815,"max",0.6,31240.038,0.85,26554.0323,0.51,"max",4.9,255126.97700000004,0.1243544994711961,31726.187526434365,0.609337047408861,1.119337047408861,1.089,0.030337047408861118,0.027857711119248042,58280.21982643436,null,0.77]
[4,"Campeggi, distributori carburanti, impianti sportivi",4,1249,0.006464182657410482,312.25,"max",0.88,1099.1200000000001,0.98,1077.1376,0.8623999999999999,"max",7.21,9005.289999999999,0.1243544994711961,1119.8483305429675,0.8965959411873239,1.7589959411873237,1.3843,0.37469594118732363,0.2706753891405935,2196.9859305429673,null,1.13]
[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.1243544994711961,1469.7820910221126,0.5247759877684475,0.9582759877684475,0.9319,0.026375987768447517,0.028303452911736793,2683.920221022113,null,0.66]
[6,"Alberghi con ristorante",1,436,0.0022565121206012573,436,"max",1.64,715.04,1,715.04,1.64,"max",13.45,5864.2,0.1243544994711961,729.2396557989881,1.6725680178875875,3.312568017887587,2.983,0.32956801788758705,0.11048207103170869,1444.2796557989882,null,1.83]
[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.1243544994711961,1709.2078276117809,1.0346294356003516,2.0546294356003516,1.967,0.08762943560035152,0.04454978932402213,3394.247827611781,null,1.39]
[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.1243544994711961,0,1.2709029845956243,2.270902984595624,2.2701,0.0008029845956243342,0.0003537221248510349,0,null,1.61]
[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.1243544994711961,0,1.311939969421119,2.343939969421119,2.3432,0.000739969421119202,0.0003157943927616943,0,null,1.66]
[10,"Uffici, agenzie, studi professionali, banche",135,16285.47,0.08428523037772512,120.6331111111111,"max",1.52,24753.914399999998,1,24753.914399999998,1.52,"max",12.45,202754.1015,0.1243544994711961,25213.38480776459,1.5482135184163914,3.0682135184163917,2.763,0.30521351841639177,0.11046453797191161,49967.29920776459,null,1.96]
[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.8,8721.6396,1.128,"max",11.55,89304.0225,0.1243544994711961,11105.357018751936,1.4362944688923152,2.564294468892315,2.5632,0.0010944688923149037,0.0004269931695985111,19826.99661875194,null,1.82]
[12,"Banchi di mercato beni durevoli",0,0,0,{"$error":"#DIV/0!"},"max",1.78,0,0.8,0,1.4240000000000002,"max",14.58,0,0.1243544994711961,0,1.8130886022900392,3.237088602290039,3.2356,0.0014886022900393314,0.00046006993758169475,0,null,0.32]
[13,"Attività artigianali tipo botteghe: parrucchiere, barbiere, estetista",14,885.53,0.004583048573752365,63.25214285714286,"med",1.29,1142.3337,0.7,799.6335899999999,0.9029999999999999,"med",10.54,9333.4862,0.1243544994711961,1160.661004722316,1.3106964244264068,2.2136964244264066,1.9838,0.22989642442640656,0.11588689607138147,1960.2945947223159,null,1.66]
[14,"Attività artigianali tipo botteghe: falegname, idraulico, fabbro, elettricista",15,2763.02,0.014299972751063499,184.20133333333334,"max",1.03,2845.9106,0.8,2276.72848,0.8240000000000001,"max",8.48,23430.409600000003,0.1243544994711961,2913.6768582131085,1.054526155515743,1.878526155515743,1.4955,0.38302615551574304,0.25611912772700973,5190.405338213109,null,1.33]
[15,"Carrozzeria, autofficina, elettrauto",20,4654.95,0.02409163095365326,232.7475,"med",1.25,5818.6875,0.8,4654.95,1,"med",10.25,47713.237499999996,0.1243544994711961,5933.355767462804,1.27463361957976,2.27463361957976,1.9844,0.2902336195797601,0.14625761921979447,10588.305767462803,null,1.61]
[16,"Attività artigianali e industriali con capannoni di produzione",121,84994.45,0.43988762983678326,702.4334710743801,"max",0.92,78194.894,0.8,62555.9152,0.7360000000000001,"max",7.53,640008.2085,0.1243544994711961,79587.9004254744,0.9363893810181066,1.6723893810181067,1.4899,0.18248938101810674,0.12248431506685466,142143.8156254744,null,1.4]
[17,"Pubblici esercizi classe A (ristoranti,pizzerie,..)",13,2095.38,0.010844610934095097,161.18307692307692,"min",5.57,11671.2666,0.86,10037.289276000001,4.7902000000000005,"min",45.67,95696.00460000001,0.1243544994711961,11900.228753426281,5.6792699908495266,10.469469990849527,8.8222,1.6472699908495265,0.18671873125178826,21937.518029426283,null,6.25]
[18,"Bar, caffè, pasticceria",15,1634.92,0.008461506413333503,108.99466666666667,"min",3.96,6474.2832,0.86,5567.883552,3.4055999999999997,"min",32.44,53036.8048,0.1243544994711961,6595.365314455531,4.0340599628456015,7.439659962845601,7.1988,0.24085996284560096,0.033458349008946064,12163.248866455531,null,5.1]
[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.18,1591.9421939999997,1.2906,"min",58.76,72479.8724,0.1243544994711961,9013.19825403816,7.307070388927483,8.597670388927483,6.7968,1.8008703889274829,0.2649585671091518,10605.140448038159,null,4.81]
[20,"Supermercati e ipermercati per la vendita di generi misti",5,2403.27,0.012438091477241705,480.654,"max",2.74,6584.9598000000005,1,6584.9598000000005,2.74,"max",22.45,53953.411499999995,0.1243544994711961,6709.349481845975,2.7917585131283524,5.531758513128352,4.9814,0.5503585131283524,0.11048269826320962,13294.309281845975,null,3.53]
[21,"Banchi di mercato generi alimentari",0,0,0,{"$error":"#DIV/0!"},"max",6.92,0,0.98,0,6.7816,"max",56.78,0,0.1243544994711961,0,7.060848479974515,13.842448479974514,12.5899,1.2525484799745144,0.09948835812631668,0,null,1.25]
[22,"Discoteche, night club",5,2812.46,0.014555848804372044,562.492,"max",1.91,5371.7986,1,5371.7986,1.91,"max",15.68,44099.3728,0.1243544994711961,5483.95543153768,1.9498785517083548,3.8598785517083547,3.4759,0.3839785517083545,0.11046881432387423,10855.75403153768,null,2.46]
[null,"Totale",598,193218.55,1,323.1079431438127,null,45.760000000000005,203809.68750000003,null,168192.30712200003,null,null,375.03000000000003,1668724.6555,null,207513.41928994664,{"$nulls":5},375705.72641194664]
[null,null,"Num oggetti","Superficie totale  ",null,"Sup.media locali"]
[null,"TOTALE GENERALE",3498,614290.55,null,175.6119353916524,null,null,622127.5175,null,361544.718422,{"$nulls":5},546927.69,{"$nulls":5},908472.4084219998]
{"$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]