{"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]]}
[" "]
[" "]
["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 setembre 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,111124304.81999999,93659964.269999996,17464340.550000001,null,{"$f":"IF(F11=0,0,G11/F11)","v":0.79206472568907382}]
[2,"Impostos indirectes",null,90354500,0,90354500,61407078.139999993,61407078.139999993,0,null,0.6796239051735109]
[3,"Taxes i altres ingressos",null,4190000,0,4190000,4467486.4799999977,3177715.7000000007,1289770.78,null,1.0662258902147965]
[4,"Transferències corrents",null,536252750,19459587.899999999,555712337.89999998,411998573.63999999,411479605.81000012,518967.8299999999,null,0.74138820670585659]
[5,"Ingressos patrimonials",null,2589750,0,2589750,1804143.01,1684618.9399999997,119524.07,null,0.6966475567139685]
[null,"Ingressos corrents (I1)",null,{"$f":"SUM(D11:D15)","v":773684000},19459587.899999999,793143587.89999998,{"$f":"SUM(G11:G15)","v":590801586.08999991},{"$f":"SUM(H11:H15)","v":571408982.86000013},19392603.23,null,0.74488603968199585]
[6,"Alienació de béns",null,0,0,0,151257.12,119908.32,31348.799999999999,null,0]
[7,"Transferències capital",null,1100000,2000,1102000,1034348.48,774652.01,259696.47,null,0.93861023593466419]
[null,"Ingressos de capital (I2)",null,{"$f":"D17+D18","v":1100000},2000,1102000,{"$f":"G17+G18","v":1185605.6000000001},{"$f":"H17+H18","v":894560.33000000007},291045.27,null,1.0758671506352089]
[8,"Actius financers",null,190450000,271309508.28000003,461759508.28000003,186850733.56,185842371.97999999,1008361.5800000001,null,0.40464945541889774]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Ingressos financers (I3)",null,{"$f":"D20+D21","v":190450000},271309508.28000003,461759508.28000003,{"$f":"G20+G21","v":186850733.56},{"$f":"H20+H21","v":185842371.97999999},1008361.5800000001,null,0.40464945541889774]
[]
[]
[null,"Total d'ingressos",null,{"$f":"D16+D19+D22","v":965234000},290771096.18000001,1256005096.1800001,778837925.25,758145915.1700002,20692010.079999998,null,{"$f":"IF(F25=0,0,G25/F25)","v":0.62009137352925481}]
[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.53000003,152723521.36999995,152722508.93999994,1012.43,null,{"$f":"IF(F33=0,0,G33/F33)","v":0.61884597272378328}]
[2,"Despeses béns corrents i serveis",null,110078985,19136605.159999996,129215590.16000001,57450083.310000002,55614206.369999982,1835876.9399999997,null,0.44460643827004903]
[3,"Despeses financeres",null,1769000,-1465000,304000,33736.140000000007,33736.140000000007,0,null,0.11097414473684213]
[4,"Transferències corrents",null,239310910,118219086.23999996,357529996.23999995,236571538.52000013,229552655.48000011,7018883.040000001,null,0.66168305039557085]
[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},140333305.92999995,738837200.93000007,446778879.34000003,437923106.93000001,8855772.4100000001,null,0.60470544631161494]
[6,"Inversions reals",null,51007000,32744669.74000001,83751669.739999995,27843811.690000001,27218143.259999998,625668.43000000005,null,0.33245679490855251]
[7,"Transferències capital",null,122506115,105088453.75000001,227594568.75000003,80194195.570000008,79057206.580000013,1136988.99,null,0.35235548901911129]
[null,"Despeses de capital (D2)",null,{"$f":"D39+D40","v":173513115},137833123.49000001,311346238.49000001,108038007.26000001,106275349.84,1762657.42,null,0.34700277024053411]
[8,"Actius financers",null,193216990,12604666.76,205821656.75999999,181263128.27000001,180913128.27000001,350000,null,0.88068054219077319]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D42+D43","v":193216990},12604666.76,205821656.75999999,181263128.27000001,180913128.27000001,350000,null,0.88068054219077319]
[]
[]
[null,{"$f":"\"Total de \"&A29","v":"Total de despeses"},null,{"$f":"D38+D41+D44","v":965234000.00000012},290771096.17999995,1256005096.1800001,736080014.87,725111585.03999996,10968429.83,null,{"$f":"IF(F47=0,0,G47/F47)","v":0.58604858937969728}]
[]
[null,null,null,null,null,null,null,null," "]
[]
["diferències"]
[]
[]
["en operacions corrents            (I1)-(D1)",null,null,{"$f":"D16-D38","v":175180104.99999988},-120873718.02999994,54306386.969999909,144022706.74999988,133485875.93000013,10536830.82]
["en operacions de capital         (I2)-(D2)",null,null,{"$f":"D19-D41","v":-172413115},-137831123.49000001,-310244238.49000001,-106852401.66000001,-105380789.51000001,-1471612.15]
["en operacions financeres        (I3)-(D3)",null,null,{"$f":"D22-D44","v":-2766990},258704841.52000004,255937851.52000004,5587605.2899999917,4929243.7099999785,658361.58000000007]
[]
[]
[null,{"$f":"\"Total \"&A51","v":"Total diferències"},null,{"$f":"D25-D47","v":0},0,0,42757910.379999995,33034330.130000234,9723580.2499999981]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 14/10/2021"]

{"sheet":"DibaAltres","index":1,"n_rows":67,"n_cols":11,"rows_kept":67,"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 setembre 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,154844017.59999987,154832154.45999986,152723521.36999995,91943596.930000082,94064093.160000056,null,{"$f":"IF(D11=0,0,F11/D11)","v":0.62739029571995852}]
[2,"Despeses béns corrents i serveis",null,129215590.16000001,101516854.72000003,98596189.080000028,57450083.310000002,24562887.020000007,71765506.850000009,null,{"$f":"IF(D12=0,0,F12/D12)","v":0.76303632524461029}]
[3,"Despeses financeres",null,304000,217935.91999999998,217935.91999999998,33736.140000000007,86064.08,270263.86000000004,null,0.71689447368421044]
[4,"Transferències corrents",null,357529996.23999995,337310280.84000009,332951490.79000008,236571538.52000013,19644253.180000003,120958457.72000001,null,0.93125470391720366]
[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":738837200.93000007},593889089.07999992,586597770.25,446778879.34000003,141236801.2100001,292058321.59000009,null,0.79394725862697357]
[6,"Inversions reals",null,83751669.739999995,62003827.680000015,56042116.630000025,27843811.690000001,20104510.56000001,55907858.049999975,null,0.6691462606534061]
[7,"Transferències capital",null,227594568.75000003,216061752.25999996,214240688.63999996,80194195.570000008,11530956.42,147400373.18000004,null,0.9413260158915806]
[null,"Despeses de capital (D2)",null,{"$f":"D17+D18","v":311346238.49000001},278065579.94,270282805.26999998,108038007.26000001,31635466.980000012,203308231.23000002,null,0.86811007122117867]
[8,"Actius financers",null,205821656.75999999,195162847.87,195162847.87,181263128.27000001,10658808.890000001,24558528.489999998,null,0.94821337531827965]
[9,"Passius financers",null,0,0,0,0,0,0,null,0]
[null,"Despeses financeres (D3)",null,{"$f":"D20+D21","v":205821656.75999999},195162847.87,195162847.87,181263128.27000001,10658808.890000001,24558528.489999998,null,0.94821337531827965]
[]
[]
[null,{"$f":"\"Total de \"&A7","v":"Total de despeses"},null,{"$f":"D16+D19+D22","v":1256005096.1800001},1067117516.89,1052043423.39,736080014.87,183531077.0800001,519925081.31000012,null,{"$f":"IF(D25=0,0,F25/D25)","v":0.83761079201802058}]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"extret el 14/10/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 setembre de 2021"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"extret el 14/10/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 setembre de 2021"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"extret el 14/10/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,1256.00509618,778.83792525000001,758.14591517000019,20.692010079999999]
[]
[]
["drets reconeguts nets"]
[]
[null,1,2,3,4,5,6,7,8,9]
["drets reconeguts nets",111124304.81999999,61407078.139999993,4467486.4799999977,411998573.63999999,1804143.01,151257.12,1034348.48,186850733.56,0]
["previsions definitives",140297000,90354500,4190000,555712337.89999998,2589750,0,1102000,461759508.28000003,0]
["drets milions",111.12430481999999,61.407078139999996,4.467486479999998,411.99857363999996,1.80414301,0.15125711999999999,1.03434848,186.85073356000001,0]
["definitives milions",140.297,90.354500000000002,4.1900000000000004,555.71233789999997,2.58975,0,1.1020000000000001,461.75950828000003,0]
[]
[]
["ingressos nets"]
[]
["recaptació neta",{"$f":"E9","v":758.14591517000019}]
["pendent de cobrament",{"$f":"F9","v":20.692010079999999}]
[]
[]
["despeses"]
[]
[null,"Crèdits inicials","Crèdits definitius","Disposicions","Obligacions reconegudes","Pagaments realitzats","Pendent de pagament"]
[null,965.23400000000015,1256.00509618,1052.04342339,736.08001487000001,725.11158503999991,10.96842983]
[]
[]
["obligacions reconegudes"]
[]
[null,1,2,3,4,5,6,7,8,9]
["despeses compromeses",154832154.45999986,98596189.080000028,217935.91999999998,332951490.79000008,0,56042116.630000025,214240688.63999996,195162847.87,0]
["crèdits definitius",246787614.53000003,129215590.16000001,304000,357529996.23999995,5000000,83751669.739999995,227594568.75000003,205821656.75999999,0]
["despeses compr. milions",154.83215445999986,98.59618908000003,0.21793591999999998,332.95149079000009,0,56.042116630000024,214.24068863999995,195.16284787000001,0]
["crèdits definitius milions",246.78761453000004,129.21559016,0.30399999999999999,357.52999623999995,5,83.751669739999997,227.59456875000004,205.82165676,0]
[]
[]
["pagaments"]
[]
["pagaments",{"$f":"F30","v":725.11158503999991}]
["pendent de pagament",{"$f":"G30","v":10.96842983}]