{"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]]}
[" "]
[" "]
[{"$f":"DibaAltres!A3","v":"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 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,26214790.359999999,25765756.989999998,449033.37,null,{"$f":"IF(F11=0,0,G11/F11)","v":0.18685210916840703}]
[2,"Impostos indirectes",null,90354500,0,90354500,20595766.700000003,20595766.700000003,0,null,0.22794400610926963]
[3,"Taxes i altres ingressos",null,4190000,0,4190000,1306180.8700000001,713151.67000000016,593029.19999999995,null,0.31173767780429595]
[4,"Transferències corrents",null,536252750,18257075.059999999,554509825.05999994,133467942.52999999,133217891.81,250050.72,null,0.24069536101647662]
[5,"Ingressos patrimonials",null,2589750,0,2589750,621157.79000000015,276794.45999999996,344363.33,null,0.23985241432570717]
[null,"Ingressos corrents (I1)",null,{"$f":"SUM(D11:D15)","v":773684000},18257075.059999999,791941075.05999994,{"$f":"SUM(G11:G15)","v":182205838.24999997},{"$f":"SUM(H11:H15)","v":180569361.63000003},1636476.62,null,0.23007499419852101]
[6,"Alienació de béns",null,0,0,0,128204.35,95874.55,32329.8,null,0]
[7,"Transferències capital",null,1100000,0,1100000,1198582.01,109608.24,1088973.77,null,1.0896200090909092]
[null,"Ingressos de capital (I2)",null,{"$f":"D17+D18","v":1100000},0,1100000,{"$f":"G17+G18","v":1326786.3600000001},{"$f":"H17+H18","v":205482.79},1121303.57,null,1.2061694181818183]
[8,"Actius financers",null,190450000,254679508.28,445129508.27999997,547592.49,413503.37,134089.12,null,1.230186900248248E-3]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Ingressos financers (I3)",null,{"$f":"D20+D21","v":190450000},254679508.28,445129508.27999997,{"$f":"G20+G21","v":547592.49},{"$f":"H20+H21","v":413503.37},134089.12,null,1.230186900248248E-3]
[]
[]
[null,"Total d'ingressos",null,{"$f":"D16+D19+D22","v":965234000},272936583.33999997,1238170583.3399999,184080217.09999999,181188347.79000002,2891869.3100000005,null,{"$f":"IF(F25=0,0,G25/F25)","v":0.14867112785335154}]
[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.00000012,4442614.5299999993,246787614.53000009,42429626.659999967,42429176.659999967,450,null,{"$f":"IF(F33=0,0,G33/F33)","v":0.17192769880614134}]
[2,"Despeses béns corrents i serveis",null,110078985,19308458.790000003,129387443.78999999,15680196.550000003,14829353.790000005,850842.76000000013,null,0.1211879305340437]
[3,"Despeses financeres",null,1769000,-1465000,304000,33734.880000000005,33734.880000000005,0,null,0.11097000000000001]
[4,"Transferències corrents",null,239310910,123557483.94999999,362868393.94999999,54985225.780000001,52676241.820000008,2308983.9600000009,null,0.15152938833128704]
[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},145843557.26999998,744347452.26999998,113128783.86999997,109968507.14999998,3160276.7200000011,null,0.15198383970415519]
[6,"Inversions reals",null,51007000,32746179.740000006,83753179.73999998,8487067.3800000008,8030698.5200000014,456368.86000000004,null,0.10133427060735978]
[7,"Transferències capital",null,122506115,87322179.569999978,209828294.57000005,22744032.220000006,18395803.169999998,4348229.0500000007,null,0.10839354276128119]
[null,"Despeses de capital (D2)",null,{"$f":"D39+D40","v":173513115},120068359.30999999,293581474.31000006,31231099.600000009,26426501.689999998,4804597.9100000011,null,0.10637966742759219]
[8,"Actius financers",null,193216990,7024666.7599999998,200241656.75999999,171653241.90000001,121653241.90000001,50000000,null,0.85723043185632108]
[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,171653241.90000001,121653241.90000001,50000000,null,0.85723043185632108]
[]
[]
[null,{"$f":"\"Total de \"&A29","v":"Total de despeses"},null,{"$f":"D38+D41+D44","v":965234000.00000012},272936583.33999997,1238170583.3400002,316013125.37,258048250.73999998,57964874.630000003,null,{"$f":"IF(F47=0,0,G47/F47)","v":0.25522583852504854}]
[]
[null,null,null,null,null,null,null,null," "]
[]
["diferències"]
[]
[]
["en operacions corrents            (I1)-(D1)",null,null,{"$f":"D16-D38","v":175180104.99999988},-127586482.20999998,47593622.789999962,69077054.379999995,70600854.480000049,-1523800.100000001]
["en operacions de capital         (I2)-(D2)",null,null,{"$f":"D19-D41","v":-172413115},-120068359.30999999,-292481474.31000006,-29904313.24000001,-26221018.899999999,-3683294.3400000008]
["en operacions financeres        (I3)-(D3)",null,null,{"$f":"D22-D44","v":-2766990},247654841.52000001,244887851.51999998,-171105649.41,-121239738.53,-49865910.880000003]
[]
[]
[null,{"$f":"\"Total \"&A51","v":"Total diferències"},null,{"$f":"D25-D47","v":0},0,0,-131932908.27000001,-76859902.949999958,-55073005.32]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 9/4/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,{"$f":"Diba!K4","v":"31 de març 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.53000009,44903717.889999934,44903717.889999934,42429626.659999967,201883896.64000005,204357987.87000003,null,{"$f":"IF(D11=0,0,F11/D11)","v":0.18195288274704455}]
[2,"Despeses béns corrents i serveis",null,129387443.78999999,82021609.979999989,77121430.049999952,15680196.550000003,43818201.680000037,113707247.23999995,null,{"$f":"IF(D12=0,0,F12/D12)","v":0.59605034144712321}]
[3,"Despeses financeres",null,304000,217934.66,217934.66,33734.880000000005,86065.34,270265.12000000005,null,0.71689032894736848]
[4,"Transferències corrents",null,362868393.94999999,276676028.58000004,236704781.25999996,54985225.780000001,79769528.409999982,307883168.1699999,null,0.65231578502429655]
[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":744347452.26999998},403819291.10999995,358947863.85999984,113128783.86999997,330557692.07000005,631218668.39999986,null,0.48223160133796938]
[6,"Inversions reals",null,83753179.73999998,45388761.980000004,33523840.809999999,8487067.3800000008,35582244.029999979,75266112.359999999,null,0.40026946933919488]
[7,"Transferències capital",null,209828294.57000005,191141028.03000003,170666830.67000002,22744032.220000006,18648367.43,187084262.35000002,null,0.81336423679059389]
[null,"Despeses de capital (D2)",null,{"$f":"D17+D18","v":293581474.31000006},236529790.01000005,204190671.48000002,31231099.600000009,54230611.459999979,262350374.71000004,null,0.69551620026401928]
[8,"Actius financers",null,200241656.75999999,187717792.65000001,178717792.65000001,171653241.90000001,12523864.110000001,28588414.859999999,null,0.89251055720240347]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D20+D21","v":200241656.75999999},187717792.65000001,178717792.65000001,171653241.90000001,12523864.110000001,28588414.859999999,null,0.89251055720240347]
[]
[]
[null,{"$f":"\"Total de \"&A7","v":"Total de despeses"},null,{"$f":"D16+D19+D22","v":1238170583.3400002},828066873.76999998,741856327.98999989,316013125.37,397312167.64000005,922157457.96999991,null,{"$f":"IF(D25=0,0,F25/D25)","v":0.59915518747733565}]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 9/4/2021"]

{"sheet":"GrIngressos","index":2,"n_rows":84,"n_cols":11,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Intervenció General"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 9/4/2021"]

{"sheet":"GrDespeses","index":3,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Intervenció General"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 9/4/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.1705833399999,184.08021709999997,181.18834779000005,2.8918693100000006]
[]
[]
["drets reconeguts nets"]
[]
[null,1,2,3,4,5,6,7,8,9]
["drets reconeguts nets",26214790.359999999,20595766.700000003,1306180.8700000001,133467942.52999999,621157.79000000015,128204.35,1198582.01,547592.49,0]
["previsions definitives",140297000,90354500,4190000,554509825.05999994,2589750,0,1100000,445129508.27999997,0]
["drets milions",26.214790359999999,20.595766700000002,1.3061808700000002,133.46794252999999,0.62115779000000015,0.12820434999999999,1.19858201,0.54759248999999999,0]
["definitives milions",140.297,90.354500000000002,4.1900000000000004,554.50982505999991,2.58975,0,1.1000000000000001,445.12950827999998,0]
[]
[]
["ingressos nets"]
[]
["recaptació neta",{"$f":"E9","v":181.18834779000005}]
["pendent de cobrament",{"$f":"F9","v":2.8918693100000006}]
[]
[]
["despeses"]
[]
[null,"Crèdits inicials","Crèdits definitius","Disposicions","Obligacions reconegudes","Pagaments realitzats","Pendent de pagament"]
[null,965.23400000000015,1238.1705833400001,741.85632798999984,316.01312537000001,258.04825073999996,57.964874630000004]
[]
[]
["obligacions reconegudes"]
[]
[null,1,2,3,4,5,6,7,8,9]
["despeses compromeses",44903717.889999934,77121430.049999952,217934.66,236704781.25999996,0,33523840.809999999,170666830.67000002,178717792.65000001,0]
["crèdits definitius",246787614.53000009,129387443.78999999,304000,362868393.94999999,5000000,83753179.73999998,209828294.57000005,200241656.75999999,0]
["despeses compr. milions",44.903717889999932,77.121430049999958,0.21793466,236.70478125999995,0,33.523840809999996,170.66683067000002,178.71779265000001,0]
["crèdits definitius milions",246.7876145300001,129.38744378999999,0.30399999999999999,362.86839394999998,5,83.753179739999979,209.82829457000005,200.24165675999998,0]
[]
[]
["pagaments"]
[]
["pagaments",{"$f":"F30","v":258.04825073999996}]
["pendent de pagament",{"$f":"G30","v":57.964874630000004}]