{"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":171,"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,"30 de juny 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,60427950.989999995,59588627.439999998,839323.55,null,{"$f":"IF(F11=0,0,G11/F11)","v":0.43071449132910894}]
[2,"Impostos indirectes",null,90354500,0,90354500,42087892.700000003,42087892.700000003,0,null,0.4658084843588311]
[3,"Taxes i altres ingressos",null,4190000,0,4190000,3329526.4600000004,1948556.9000000001,1380969.5600000003,null,0.79463638663484493]
[4,"Transferències corrents",null,536252750,18264407.559999999,554517157.55999994,266112252.44999993,265540753.16999993,571499.28,null,0.47989904157511304]
[5,"Ingressos patrimonials",null,2589750,0,2589750,1338783.5100000002,1026217.5199999999,312565.99,null,0.51695472922096741]
[null,"Ingressos corrents (I1)",null,{"$f":"SUM(D11:D15)","v":773684000},18264407.559999999,791948407.55999994,{"$f":"SUM(G11:G15)","v":373296406.1099999},{"$f":"SUM(H11:H15)","v":370192047.7299999},3104358.3800000008,null,0.47136455171382874]
[6,"Alienació de béns",null,0,0,0,137069.27000000002,103697.51000000001,33371.760000000002,null,0]
[7,"Transferències capital",null,1100000,0,1100000,824101.66,445233.88,378867.78,null,0.7491833272727273]
[null,"Ingressos de capital (I2)",null,{"$f":"D17+D18","v":1100000},0,1100000,{"$f":"G17+G18","v":961170.93},{"$f":"H17+H18","v":548931.39},412239.54000000004,null,0.87379175454545455]
[8,"Actius financers",null,190450000,255379508.28,445829508.27999997,16062858.629999999,4429449.4600000009,11633409.169999998,null,3.602915090113739E-2]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Ingressos financers (I3)",null,{"$f":"D20+D21","v":190450000},255379508.28,445829508.27999997,{"$f":"G20+G21","v":16062858.629999999},{"$f":"H20+H21","v":4429449.4600000009},11633409.169999998,null,3.602915090113739E-2]
[]
[]
[null,"Total d'ingressos",null,{"$f":"D16+D19+D22","v":965234000},273643915.83999997,1238877915.8399999,390320435.6699999,375170428.57999986,15150007.09,null,{"$f":"IF(F25=0,0,G25/F25)","v":0.31505964444071133}]
[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.00000009,4442614.5299999993,246787614.53000003,105307410.47000015,105278922.47000015,28488,null,{"$f":"IF(F33=0,0,G33/F33)","v":0.42671270464911742}]
[2,"Despeses béns corrents i serveis",null,110078985,18974597.199999996,129053582.19999999,36612006.920000032,35320923.740000062,1291083.1799999997,null,0.28369616941946485]
[3,"Despeses financeres",null,1769000,-1465000,304000,33736.140000000007,33734.880000000005,1.26,null,0.11097414473684213]
[4,"Transferències corrents",null,239310910,117912188.04000001,357223098.03999996,162779363.53999993,151875978.94999996,10903384.589999998,null,0.45567983826670905]
[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.00000012},139864399.77000001,738368294.76999998,304732517.07000005,292509560.0400002,12222957.029999997,null,0.4127107288171461]
[6,"Inversions reals",null,51007000,32682669.740000006,83689669.73999998,18846694.610000007,18460475.650000002,386218.96,null,0.22519738300499131]
[7,"Transferències capital",null,122506115,94072179.569999993,216578294.57000005,55228555.720000014,51243315.649999999,3985240.07,null,0.255005035613805]
[null,"Despeses de capital (D2)",null,{"$f":"D39+D40","v":173513115},126754849.31,300267964.31000006,74075250.330000013,69703791.299999997,4371459.03,null,0.24669714766349127]
[8,"Actius financers",null,193216990,7024666.7599999998,200241656.75999999,178208133.65000001,178153069.18000001,55064.47,null,0.88996533755007678]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D42+D43","v":193216990},7024666.7599999998,200241656.75999999,178208133.65000001,178153069.18000001,55064.47,null,0.88996533755007678]
[]
[]
[null,{"$f":"\"Total de \"&A29","v":"Total de despeses"},null,{"$f":"D38+D41+D44","v":965234000.00000012},273643915.84000003,1238877915.8400002,557015901.05000007,540366420.52000022,16649480.529999999,null,{"$f":"IF(F47=0,0,G47/F47)","v":0.4496132297848936}]
[]
[null,null,null,null,null,null,null,null," "]
[]
["diferències"]
[]
[]
["en operacions corrents            (I1)-(D1)",null,null,{"$f":"D16-D38","v":175180104.99999988},-121599992.21000001,53580112.789999962,68563889.039999843,77682487.6899997,-9118598.6499999966]
["en operacions de capital         (I2)-(D2)",null,null,{"$f":"D19-D41","v":-172413115},-126754849.31,-299167964.31000006,-73114079.400000006,-69154859.909999996,-3959219.49]
["en operacions financeres        (I3)-(D3)",null,null,{"$f":"D22-D44","v":-2766990},248354841.52000001,245587851.51999998,-162145275.02000001,-173723619.72,11578344.699999997]
[]
[]
[null,{"$f":"\"Total \"&A51","v":"Total diferències"},null,{"$f":"D25-D47","v":0},0,0,-166695465.38000017,-165195991.94000036,-1499473.4399999995]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 14/7/2021"]

{"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,"30 de juny 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.53000003,107578802.31000014,107578802.31000014,105307410.47000015,139208812.21999988,141480204.05999982,null,{"$f":"IF(D11=0,0,F11/D11)","v":0.43591653703886596}]
[2,"Despeses béns corrents i serveis",null,129053582.19999999,94602747.420000136,90367908.860000163,36612006.920000032,30781099.269999988,92441575.279999927,null,{"$f":"IF(D12=0,0,F12/D12)","v":0.70023557129900549}]
[3,"Despeses financeres",null,304000,217935.92,217935.92,33736.140000000007,86064.08,270263.86000000004,null,0.71689447368421055]
[4,"Transferències corrents",null,357223098.03999996,320136125.55000007,310465602.86000007,162779363.53999993,35708351.090000011,194443734.5,null,0.86910842149752521]
[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":738368294.76999998},522535611.20000029,508630249.95000041,304732517.07000005,210784326.65999988,433635777.69999975,null,0.68885711040509612]
[6,"Inversions reals",null,83689669.73999998,60890098.520000026,44400923.740000002,18846694.610000007,20633537.919999994,64842975.130000003,null,0.53054246573013197]
[7,"Transferències capital",null,216578294.57000005,196546722.59,186745346.24000001,55228555.720000014,19342878.640000001,161349738.85000005,null,0.86225328632663245]
[null,"Despeses de capital (D2)",null,{"$f":"D17+D18","v":300267964.31000006},257436821.11000001,231146269.98000002,74075250.330000013,39976416.559999995,226192713.98000005,null,0.7697999702071513]
[8,"Actius financers",null,200241656.75999999,192132263.56,192132263.56,178208133.65000001,8109393.1999999993,22033523.109999999,null,0.95950196711706437]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D20+D21","v":200241656.75999999},192132263.56,192132263.56,178208133.65000001,8109393.1999999993,22033523.109999999,null,0.95950196711706437]
[]
[]
[null,{"$f":"\"Total de \"&A7","v":"Total de despeses"},null,{"$f":"D16+D19+D22","v":1238877915.8400002},972104695.87000036,931908783.49000049,557015901.05000007,258870136.41999987,681862014.78999984,null,{"$f":"IF(D25=0,0,F25/D25)","v":0.75222003037977758}]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 14/7/2021"]

{"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,"30 de juny de 2021"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"extret el 14/7/2021"]

{"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,"30 de juny de 2021"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"extret el 14/7/2021"]

{"sheet":"CGrafics","index":4,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
["calculs per gràfics del pressupost actual"]
[]
[]
["ingressos"]
[]
[null,"Previsions inicials","Previsions definitives","Drets reconeguts nets","Cobraments realitzats","Pendent de cobrament"]
[null,965.23400000000004,1238.87791584,390.32043566999988,375.17042857999985,15.150007089999999]
[]
[]
["drets reconeguts nets"]
[]
[null,1,2,3,4,5,6,7,8,9]
["drets reconeguts nets",60427950.989999995,42087892.700000003,3329526.4600000004,266112252.44999993,1338783.5100000002,137069.27000000002,824101.66,16062858.629999999,0]
["previsions definitives",140297000,90354500,4190000,554517157.55999994,2589750,0,1100000,445829508.27999997,0]
["drets milions",60.427950989999992,42.087892700000005,3.3295264600000003,266.11225244999991,1.3387835100000003,0.13706927000000002,0.82410166000000007,16.062858629999997,0]
["definitives milions",140.297,90.354500000000002,4.1900000000000004,554.51715755999999,2.58975,0,1.1000000000000001,445.82950827999997,0]
[]
[]
["ingressos nets"]
[]
["recaptació neta",{"$f":"E9","v":375.17042857999985}]
["pendent de cobrament",{"$f":"F9","v":15.150007089999999}]
[]
[]
["despeses"]
[]
[null,"Crèdits inicials","Crèdits definitius","Disposicions","Obligacions reconegudes","Pagaments realitzats","Pendent de pagament"]
[null,965.23400000000015,1238.8779158400002,931.90878349000047,557.01590105000002,540.36642052000025,16.649480529999998]
[]
[]
["obligacions reconegudes"]
[]
[null,1,2,3,4,5,6,7,8,9]
["despeses compromeses",107578802.31000014,90367908.860000163,217935.92,310465602.86000007,0,44400923.740000002,186745346.24000001,192132263.56,0]
["crèdits definitius",246787614.53000003,129053582.19999999,304000,357223098.03999996,5000000,83689669.73999998,216578294.57000005,200241656.75999999,0]
["despeses compr. milions",107.57880231000014,90.367908860000156,0.21793592000000001,310.46560286000005,0,44.400923740000003,186.74534624,192.13226356000001,0]
["crèdits definitius milions",246.78761453000004,129.05358219999999,0.30399999999999999,357.22309803999997,5,83.689669739999985,216.57829457000005,200.24165675999998,0]
[]
[]
["pagaments"]
[]
["pagaments",{"$f":"F30","v":540.36642052000025}]
["pendent de pagament",{"$f":"G30","v":16.649480529999998}]