{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Diba","DibaAltres","GrIngressos","GrDespeses","CGrafics"],"not_rendered":{"charts":6,"images":3,"macros":1,"external_links":0,"defined_names":173,"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]]}
[" "]
[" "]
["liquidació 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 desembre de 2021"]
[null,null,null,null,null,null,null," "]
[]
["ingressos"]
[]
["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,140297000,0,140297000,151909845.38999999,135522208.31999999,16387637.07,null,{"$f":"IF(F11=0,0,G11/F11)","v":1.082773298003521}]
[2,"Impostos indirectes",null,90354500,0,90354500,82899204.14000003,82899204.14000003,0,null,0.91748838342307282]
[3,"Taxes i altres ingressos",null,4190000,0,4190000,7276998.1099999994,5174133.3299999991,2102864.7799999998,null,1.7367537255369927]
[4,"Transferències corrents",null,536252750,19534985.459999997,555787735.45999992,552632252.78999984,546436214.41999984,6196038.370000001,null,0.99432250395488053]
[5,"Ingressos patrimonials",null,2589750,0,2589750,2559581.5100000007,2401968.9000000008,157612.61000000002,null,0.98835080992373814]
[null,"Ingressos corrents (I1)",null,{"$f":"SUM(D11:D15)","v":773684000},19534985.459999997,793218985.45999992,{"$f":"SUM(G11:G15)","v":797277881.93999982},{"$f":"SUM(H11:H15)","v":772433729.1099999},24844152.830000002,null,1.0051169936100888]
[6,"Alienació de béns",null,0,0,0,1003574.3599999999,916053.73,87520.62999999999,null,0]
[7,"Transferències capital",null,1100000,2000,1102000,3290490.95,1430657.89,1859833.06,null,2.9859264519056263]
[null,"Ingressos de capital (I2)",null,{"$f":"D17+D18","v":1100000},2000,1102000,{"$f":"G17+G18","v":4294065.3100000005},{"$f":"H17+H18","v":2346711.62},1947353.69,null,3.8966109891107084]
[8,"Actius financers",null,190450000,286989508.28000003,477439508.28000003,192021563.65000001,191193569.69,827993.96,null,0.40219035148927534]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Ingressos financers (I3)",null,{"$f":"D20+D21","v":190450000},286989508.28000003,477439508.28000003,{"$f":"G20+G21","v":192021563.65000001},{"$f":"H20+H21","v":191193569.69},827993.96,null,0.40219035148927534]
[]
[]
[null,"Total d'ingressos",null,{"$f":"D16+D19+D22","v":965234000},306526493.74000001,1271760493.74,993593510.89999974,965974010.41999984,27619500.480000004,null,{"$f":"IF(F25=0,0,G25/F25)","v":0.78127408092229278}]
[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,242345000.00000006,4442614.53,246787614.53,212681461.35999981,212680553.85999981,907.5,null,{"$f":"IF(F33=0,0,G33/F33)","v":0.86179957517335548}]
[2,"Despeses béns corrents i serveis",null,110078985,19266493.469999991,129345478.47,89781835.870000005,89591191.590000018,190644.28,null,0.6941242703804581]
[3,"Despeses financeres",null,1769000,-1465000,304000,33998.100000000006,33998.100000000006,0,null,0.11183585526315791]
[4,"Transferències corrents",null,239310910,118362676.76999998,357673586.77000004,282365528.1700002,281654378.33000022,711149.84,null,0.78945032178619812]
[5,"Fons de contingència i altres impr.",null,5000000,0,5000000,0,0,0,null,{"$f":"IF(F37=0,0,G37/F37)","v":0}]
[null,"Despeses corrents (D1)",null,{"$f":"SUM(D33:D37)","v":598503895},140606784.76999998,739110679.76999998,584862823.5,583960121.88000011,902701.62,null,0.79130614603214833]
[6,"Inversions reals",null,51007000,32863445.470000014,83870445.469999999,42147194.030000001,42059957.989999995,87236.040000000008,null,0.50252736579389967]
[7,"Transferències capital",null,122506115,118251596.74000001,240757711.74000001,139447091.21000001,139209087.72,238003.49,null,0.5792009327642732]
[null,"Despeses de capital (D2)",null,{"$f":"D39+D40","v":173513115},151115042.21000004,324628157.21000004,181594285.24000001,181269045.70999998,325239.53000000003,null,0.5593916646069852]
[8,"Actius financers",null,193216990,14804666.76,208021656.75999999,200263832.25999999,200255309.72,8522.5400000000009,null,0.96270664977468956]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D42+D43","v":193216990},14804666.76,208021656.75999999,200263832.25999999,200255309.72,8522.5400000000009,null,0.96270664977468956]
[]
[]
[null,{"$f":"\"Total de \"&A29","v":"Total de despeses"},null,{"$f":"D38+D41+D44","v":965234000},306526493.74000001,1271760493.74,966720941,965484477.31000018,1236463.69,null,{"$f":"IF(F47=0,0,G47/F47)","v":0.76014386809348189}]
[]
[null,null,null,null,null,null,null,null," "]
[]
["diferències"]
[]
[]
["en operacions corrents            (I1)-(D1)",null,null,{"$f":"D16-D38","v":175180105},-121071799.30999999,54108305.689999938,212415058.43999982,188473607.22999978,23941451.210000001]
["en operacions de capital         (I2)-(D2)",null,null,{"$f":"D19-D41","v":-172413115},-151113042.21000004,-323526157.21000004,-177300219.93000001,-178922334.08999997,1622114.16]
["en operacions financeres        (I3)-(D3)",null,null,{"$f":"D22-D44","v":-2766990},272184841.52000004,269417851.52000004,-8242268.6099999845,-9061740.0300000012,819471.41999999993]
[]
[]
[null,{"$f":"\"Total \"&A51","v":"Total diferències"},null,{"$f":"D25-D47","v":0},0,0,26872569.899999738,489533.10999965668,26383036.790000003]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 14/01/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]]}
[" "]
[" "]
["liquidació 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 desembre de 2021"]
[null,null,null,null,null,null,null," "]
[]
["despeses"]
[]
["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,246787614.53,214959179.1199998,214859179.1199998,212681461.35999981,31828435.409999989,34106153.170000002,null,{"$f":"IF(D11=0,0,F11/D11)","v":0.8706238338953638}]
[2,"Despeses béns corrents i serveis",null,129345478.47,109170093.43000002,108251378.48000003,89781835.870000005,18803627.769999988,39563642.599999957,null,{"$f":"IF(D12=0,0,F12/D12)","v":0.83691660319697636}]
[3,"Despeses financeres",null,304000,218197.88,218197.88,33998.100000000006,85802.12,270001.90000000002,null,0.71775618421052634]
[4,"Transferències corrents",null,357673586.77000004,346619471.90999997,344841526.54000002,282365528.1700002,10959116.93,75308058.600000009,null,0.96412354530878008]
[5,"Fons de contingència i altres impr.",null,5000000,0,0,0,5000000,5000000,null,{"$f":"IF(D15=0,0,F15/D15)","v":0}]
[null,"Despeses corrents (D1)",null,{"$f":"SUM(D11:D15)","v":739110679.76999998},670966942.33999979,668170282.01999986,584862823.5,66676982.229999974,154247856.26999998,null,0.90401924949579171]
[6,"Inversions reals",null,83870445.469999999,62734240.809999995,60560059.290000007,42147194.030000001,20377831.240000006,41723251.440000005,null,0.72206674175424534]
[7,"Transferències capital",null,240757711.74000001,226375472.34,219767443.50999996,139447091.21000001,14382239.399999999,101310620.53,null,0.91281580108774274]
[null,"Despeses de capital (D2)",null,{"$f":"D17+D18","v":324628157.21000004},289109713.14999998,280327502.79999995,181594285.24000001,34760070.640000001,143033871.97,null,0.86353415923393773]
[8,"Actius financers",null,208021656.75999999,207219000.37,207219000.37,200263832.25999999,802656.38999999978,7757824.4999999991,null,0.99614147679380305]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D20+D21","v":208021656.75999999},207219000.37,207219000.37,200263832.25999999,802656.38999999978,7757824.4999999991,null,0.99614147679380305]
[]
[]
[null,{"$f":"\"Total de \"&A7","v":"Total de despeses"},null,{"$f":"D16+D19+D22","v":1271760493.74},1167295655.8599997,1155716785.1899998,966720941,102239709.25999998,305039552.74000001,null,{"$f":"IF(D25=0,0,F25/D25)","v":0.90875348847428161}]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 14/01/2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"extraccio","v":{"$error":"#REF!"}}]

{"sheet":"GrIngressos","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 desembre de 2021"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"extret el 14/01/2022"]

{"sheet":"GrDespeses","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 desembre de 2021"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"extret  el 14/01/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 desembre de 2021"]
[]
["calculs per gràfics del pressupost actual"]
[]
[]
["ingressos"]
[]
[null,"Previsions inicials","Previsions definitives","Drets reconeguts nets","Cobraments realitzats","Pendent de cobrament"]
[null,965.23400000000004,1271.7604937399999,993.59351089999984,965.97401041999979,27.619500479999999]
[]
[]
["drets reconeguts nets"]
[]
[null,1,2,3,4,5,6,7,8,9]
["drets reconeguts nets",151909845.38999999,82899204.14000003,7276998.1099999994,552632252.78999984,2559581.5100000007,1003574.3599999999,3290490.95,192021563.65000001,0]
["previsions definitives",140297000,90354500,4190000,555787735.45999992,2589750,0,1102000,477439508.28000003,0]
["drets milions",151.90984538999999,82.899204140000037,7.2769981099999992,552.63225278999982,2.5595815100000006,1.0035743599999998,3.2904909500000001,192.02156365000002,0]
["definitives milions",140.297,90.354500000000002,4.1900000000000004,555.78773545999991,2.58975,0,1.1020000000000001,477.43950828000004,0]
[]
[]
["ingressos nets"]
[]
["recaptació neta",{"$f":"E9","v":965.97401041999979}]
["pendent de cobrament",{"$f":"F9","v":27.619500479999999}]
[]
[]
["despeses"]
[]
[null,"Crèdits inicials","Crèdits definitius","Disposicions","Obligacions reconegudes","Pagaments realitzats","Pendent de pagament"]
[null,965.23400000000004,1271.7604937399999,1155.7167851899999,966.72094100000004,965.48447731000022,1.2364636899999999]
[]
[]
["obligacions reconegudes"]
[]
[null,1,2,3,4,5,6,7,8,9]
["despeses compromeses",214859179.1199998,108251378.48000003,218197.88,344841526.54000002,0,60560059.290000007,219767443.50999996,207219000.37,0]
["crèdits definitius",246787614.53,129345478.47,304000,357673586.77000004,5000000,83870445.469999999,240757711.74000001,208021656.75999999,0]
["despeses compr. milions",214.85917911999979,108.25137848000003,0.21819788000000001,344.84152654000002,0,60.560059290000005,219.76744350999996,207.21900037,0]
["crèdits definitius milions",246.78761453000001,129.34547846999999,0.30399999999999999,357.67358677000004,5,83.870445469999993,240.75771174000002,208.02165675999998,0]
[]
[]
["pagaments"]
[]
["pagaments",{"$f":"F30","v":965.48447731000022}]
["pendent de pagament",{"$f":"G30","v":1.2364636899999999}]