{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Diba","DibaAltres","GrDespeses","GrIngressos","CGrafics"],"not_rendered":{"charts":6,"images":3,"macros":0,"external_links":1,"defined_names":46,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Diba","index":0,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[8,0,9,1],[30,0,31,1]]}
[" "]
[" "]
["estat d'execució del pressupost",null,null,null,null,null,null,null,null,null,"exercici corrent"]
["resum per capítols",null,null,null,null,null,null,null,null,null,"31 de març de 2022"]
[null,null,null,null,null,null,null," "]
[]
["ingressos",null,null,null,null,null,null,null,null,null," "]
[]
["capítol pressupostari",null,null,"Pressupost\ninicial","Modificacions","Pressupost\nactual","Drets reconeguts\nnets","Recaptació","Pendent de cobrament",null,"%\n(D)/(C)"]
[null,null,null,"(A)","(B)","(C) = (A)+(B)","(D)","(E)","(F) = (D)+(E)",null,"(G)"]
[1,"Impostos directes",null,152884500,0,152884500,35562853.890000001,35087849.689999998,475004.2,null,{"$f":"IF(F11=0,0,G11/F11)","v":0.23261255320192695}]
[2,"Impostos indirectes",null,112763000,0,112763000,24718871.07,24718871.07,0,null,0.21921083218786305]
[3,"Taxes i altres ingressos",null,4441700,0,4441700,1508504.8599999999,890254.31,618250.54999999981,null,0.33962331089447734]
[4,"Transferències corrents",null,594247950,21132325.109999999,615380275.11000001,152912832.10000005,152773958.25000003,138873.85,null,0.24848510471458757]
[5,"Ingressos patrimonials",null,2499250,0,2499250,835447.33000000007,466860.97,368586.35999999993,null,0.33427921576472946]
[null,"Ingressos corrents (I1)",null,{"$f":"SUM(D11:D15)","v":866836400},21132325.109999999,887968725.11000001,{"$f":"SUM(G11:G15)","v":215538509.25000006},{"$f":"SUM(H11:H15)","v":213937794.29000002},1600714.9599999997,null,0.24273209534862789]
[6,"Alienació de béns",null,0,0,0,54243.6,54243.59,0.01,null,0]
[7,"Transferències capital",null,2993600,0,2993600,451597.56,0,451597.56,null,0.15085434259754141]
[null,"Ingressos de capital (I2)",null,{"$f":"D17+D18","v":2993600},0,2993600,{"$f":"G17+G18","v":505841.16},{"$f":"H17+H18","v":54243.59},451597.57,null,0.16897419828968466]
[8,"Actius financers",null,190290000,200420175.15000001,390710175.14999998,2069640.61,1949640.6099999999,120000,null,5.2971249320687168E-3]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Ingressos financers (I3)",null,{"$f":"D20+D21","v":190290000},200420175.15000001,390710175.14999998,{"$f":"G20+G21","v":2069640.61},{"$f":"H20+H21","v":1949640.6099999999},120000,null,5.2971249320687168E-3]
[]
[]
[null,"Total d'ingressos",null,{"$f":"D16+D19+D22","v":1060120000},221552500.25999999,1281672500.26,218113991.02000007,215941678.49000004,2172312.5299999998,null,{"$f":"IF(F25=0,0,G25/F25)","v":0.17017919240348334}]
[null,null,null,null,null," "]
[]
[]
["despeses"]
[]
["capítol pressupostari",null,null,"Pressupost\ninicial","Modificacions","Pressupost\nactual","Obligacions\nreconegudes","Pagaments","Pendent de pagament",null,"%\n(D)/(C)"]
[null,null,null,"(A)","(B)","(C) = (A)+(B)","(D)","(E)","(F) = (D)+(E)",null,"(G)"]
[1,"Despeses de personal",null,254397000.00000021,185619.15000000002,254582619.15000018,43529886.289999932,43403734.649999931,126151.63999999998,null,{"$f":"IF(F33=0,0,G33/F33)","v":0.17098530306325471}]
[2,"Despeses béns corrents i serveis",null,120173500,20444123.34999999,140617623.35000005,19644673.900000036,17608542.820000011,2036131.0800000005,null,0.13970278711868178]
[3,"Despeses financeres",null,111000,0,111000,33187.339999999997,32968.39,218.95,null,0.29898504504504503]
[4,"Transferències corrents",null,258226400,87513199.899999961,345739599.9000001,40840914.079999998,36224914.400000006,4615999.6799999978,null,0.11812622589894999]
[5,"Fons de contingència i altres impr.",null,3000000,0,3000000,0,0,0,null,{"$f":"IF(F37=0,0,G37/F37)","v":0}]
[null,"Despeses corrents (D1)",null,{"$f":"SUM(D33:D37)","v":635907900.00000024},108142942.39999995,744050842.40000033,104048661.60999997,97270160.259999946,6778501.3499999987,null,0.13984079538755984]
[6,"Inversions reals",null,73410700,20269026.680000003,93679726.680000007,9570935.2599999998,8468110.6700000018,1102824.5899999999,null,0.10216655832796458]
[7,"Transferències capital",null,160666400,80771368.310000032,241437768.30999994,25971946.119999997,19193917.699999999,6778028.4199999999,null,0.10757201038510544]
[null,"Despeses de capital (D2)",null,{"$f":"D39+D40","v":234077100},101040394.99000004,335117494.98999995,35542881.379999995,27662028.370000001,7880853.0099999998,null,0.10606095447526728]
[8,"Actius financers",null,190135000,12369162.869999999,202504162.87,171588786.78999999,121588786.79000001,50000000,null,0.84733461454890435]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D42+D43","v":190135000},12369162.869999999,202504162.87,171588786.78999999,121588786.79000001,50000000,null,0.84733461454890435]
[]
[]
[null,{"$f":"\"Total de \"&A29","v":"Total de despeses"},null,{"$f":"D38+D41+D44","v":1060120000.0000002},221552500.25999999,1281672500.2600002,311180329.77999997,246520975.41999996,64659354.359999999,null,{"$f":"IF(F47=0,0,G47/F47)","v":0.24279239019084353}]
[]
[null,null,null,null,null,null,null,null," "]
[]
["diferències"]
[]
[]
["en operacions corrents            (I1)-(D1)",null,null,{"$f":"D16-D38","v":230928499.99999976},-87010617.289999947,143917882.70999968,111489847.64000009,116667634.03000008,-5177786.3899999987]
["en operacions de capital         (I2)-(D2)",null,null,{"$f":"D19-D41","v":-231083500},-101040394.99000004,-332123894.98999995,-35037040.219999999,-27607784.780000001,-7429255.4399999995]
["en operacions financeres        (I3)-(D3)",null,null,{"$f":"D22-D44","v":155000},188051012.28,188206012.27999997,-169519146.17999998,-119639146.18000001,-49880000]
[]
[]
[null,{"$f":"\"Total \"&A51","v":"Total diferències"},null,{"$f":"D25-D47","v":0},0,0,-93066338.759999901,-30579296.929999918,-62487041.829999998]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 21/4/2022"]

{"sheet":"DibaAltres","index":1,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[8,0,9,1],[31,0,32,1]]}
[" "]
[" "]
["estat d'execució del pressupost",null,null,null,null,null,null,null,null,null,"exercici corrent"]
["resum per capítols",null,null,null,null,null,null,null,null,null,"31 de març de 2022"]
[null,null,null,null,null,null,null," "]
[]
["despeses",null,null,null,null,null,null,null,null,null," "]
[]
["capítol pressupostari",null,null,"Crèdits\ndefinitius","Despeses autoritzades","Despeses compromeses","Obligacions reconegudes","Crèdit\ndisponible","Romanents\nde crèdit",null,"%\n(C)/(A)"]
[null,null,null,"(A)","(B)","(C)","(D)","(E)","(F) = (A)-(D)",null,"(G)"]
[1,"Despeses de personal",null,254582619.15000018,43876303.11999993,43876303.11999993,43529886.289999932,208406316.02999994,211052732.85999992,null,{"$f":"IF(D11=0,0,F11/D11)","v":0.17234602765300328}]
[2,"Despeses béns corrents i serveis",null,140617623.35000005,91563533.620000005,86004825.030000031,19644673.900000036,43746995.889999956,120972949.44999999,null,{"$f":"IF(D12=0,0,F12/D12)","v":0.61162195022975407}]
[3,"Despeses financeres",null,111000,33187.339999999997,33187.339999999997,33187.339999999997,77812.66,77812.66,null,0.29898504504504503]
[4,"Transferències corrents",null,345739599.9000001,294679197.24000001,248367272.31999996,40840914.079999998,50929913.660000011,304898685.82000017,null,0.7183651291082549]
[5,"Fons de contingència i altres impr.",null,3000000,0,0,0,3000000,3000000,null,{"$f":"IF(D15=0,0,F15/D15)","v":0}]
[null,"Despeses corrents (D1)",null,{"$f":"SUM(D11:D15)","v":744050842.40000033},430152221.31999993,378281587.80999994,104048661.60999997,306161038.23999989,640002180.7900002,null,0.50840825149773361]
[6,"Inversions reals",null,93679726.680000007,55453230.050000012,40019303.959999986,9570935.2599999998,35142077.760000005,84108791.420000002,null,0.42719279163464768]
[7,"Transferències capital",null,241437768.30999994,211119164.08999994,193299244.28999996,25971946.119999997,30311795.650000002,215465822.18999997,null,0.80061725902721503]
[null,"Despeses de capital (D2)",null,{"$f":"D17+D18","v":335117494.98999995},266572394.13999996,233318548.24999994,35542881.379999995,65453873.410000011,299574613.60999995,null,0.6962290890153684]
[8,"Actius financers",null,202504162.87,185677231.90000001,176677231.90000001,171588786.78999999,16826930.969999999,30915376.079999998,null,0.87246222199106149]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D20+D21","v":202504162.87},185677231.90000001,176677231.90000001,171588786.78999999,16826930.969999999,30915376.079999998,null,0.87246222199106149]
[]
[]
[null,{"$f":"\"Total de \"&A7","v":"Total de despeses"},null,{"$f":"D16+D19+D22","v":1281672500.2600002},882401847.3599999,788277367.95999992,311180329.77999997,388441842.61999989,970492170.48000014,null,{"$f":"IF(D25=0,0,F25/D25)","v":0.61503805987886129}]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 21/4/2022"]

{"sheet":"GrDespeses","index":2,"n_rows":84,"n_cols":12,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Intervenció General"]
[null,null,null,null,null,null,null,null,null,null,null,"31 de març de 2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"extret el 21/4/2022"]

{"sheet":"GrIngressos","index":3,"n_rows":84,"n_cols":12,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Intervenció General"]
[null,null,null,null,null,null,null,null,null,null,null,"31 de març de 2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"extret el 21/4/2022"]

{"sheet":"CGrafics","index":4,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"31 de març de 2022"]
[]
["calculs per gràfics del pressupost actual"]
[]
[]
["ingressos"]
[]
[null,"Previsions inicials","Previsions definitives","Drets reconeguts nets","Cobraments realitzats","Pendent de cobrament"]
[null,1060.1199999999999,1281.6725002599999,218.11399102000007,215.94167849000004,2.1723125299999997]
[]
[]
["drets reconeguts nets"]
[]
[null,1,2,3,4,5,6,7,8,9]
["drets reconeguts nets",35562853.890000001,24718871.07,1508504.8599999999,152912832.10000005,835447.33000000007,54243.6,451597.56,2069640.61,0]
["previsions definitives",152884500,112763000,4441700,615380275.11000001,2499250,0,2993600,390710175.14999998,0]
["drets milions",35.56285389,24.718871069999999,1.5085048599999999,152.91283210000006,0.83544733000000004,5.4243599999999996E-2,0.45159756000000001,2.06964061,0]
["definitives milions",152.8845,112.76300000000001,4.4417,615.38027511000007,2.49925,0,2.9935999999999998,390.71017515,0]
[]
[]
["ingressos nets"]
[]
["recaptació neta",215.94167849000004]
["pendent de cobrament",2.1723125299999997]
[]
[]
["despeses"]
[]
[null,"Crèdits inicials","Crèdits definitius","Disposicions","Obligacions reconegudes","Pagaments realitzats","Pendent de pagament"]
[null,1060.1200000000003,1281.6725002600003,788.27736795999988,311.18032977999997,246.52097541999996,64.659354359999995]
[]
[]
["obligacions reconegudes"]
[]
[null,1,2,3,4,5,6,7,8,9]
["despeses compromeses",43876303.11999993,86004825.030000031,33187.339999999997,248367272.31999996,0,40019303.959999986,193299244.28999996,176677231.90000001,0]
["crèdits definitius",254582619.15000018,140617623.35000005,111000,345739599.9000001,3000000,93679726.680000007,241437768.30999994,202504162.87,0]
["despeses compr. milions",43.876303119999932,86.004825030000035,3.3187339999999996E-2,248.36727231999996,0,40.019303959999988,193.29924428999996,176.67723190000001,0]
["crèdits definitius milions",254.5826191500002,140.61762335000006,0.111,345.73959990000009,3,93.679726680000002,241.43776830999994,202.50416287000002,0]
[]
[]
["pagaments"]
[]
["pagaments",246.52097541999996]
["pendent de pagament",64.659354359999995]