{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1","2","3","4","5","6","7","8","9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"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":"1","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 1. PREVISIONES DE ESTABILIDAD PRESUPUESTARIA EN 2023 DE LAS 24 GRANDES CORPORACIONES LOCALES (ACTUALES Y DE INFORME DE LÍNEAS FUNDAMENTALES) Y ESTIMACIONES AIREF"]
["Corporaciones Locales","CNF / INF 2023\nEntidades Locales LF2023","CNF / INF 2023\nEntidades Locales PR2023","CNF / INF 2023\n AIReF PR2023"]
["Ayuntamiento Madrid",2.676045020922059E-2,9.930326587015495E-3,7.3521588202453423E-3]
["Ayuntamiento Barcelona",1.5306715259761112E-4,7.2074982918847114E-6,-3.0367697315532381E-3]
["Ayuntamiento Valencia",2.1154660386062455E-2,3.4253369639389637E-2,5.2316311014336821E-2]
["Ayuntamiento Sevilla",4.1140818932183063E-2,0.1473641132238025,0.11337571586231188]
["Ayuntamiento Zaragoza",1.9753806304780901E-2,4.6897931781648715E-2,8.3922466805292709E-2]
["Ayuntamiento Málaga",0.22455048091130417,0.19402351615460608,0.11009770189184349]
["Ayuntamiento Murcia",5.2305827538647542E-2,0.10092554752553508,2.0270940272975244E-2]
["Ayuntamiento Palma",3.026412721946399E-2,-2.0732260783946953E-3,8.2796558371862075E-2]
["Ayuntamiento Las Palmas Gran Canaria",-3.3759754849477089E-2,-2.21001855280758E-2,5.4474153989173511E-2]
["Ayuntamiento Bilbao",-3.5062418649527818E-2,-7.2814119251493045E-2,2.2008552561389632E-3]
["Ayuntamiento Alicante","Sin datos",2.7587466592611885E-2,8.5743936116847413E-2]
["Ayuntamiento Córdoba",-1.042088191660751E-2,9.2847859048688419E-2,0.10021641318419292]
["Ayuntamiento Valladolid",5.8179002272510327E-2,2.6518589234054198E-3,1.3911663351784771E-2]
["Ayuntamiento Vigo",0,0,3.9524461777769915E-2]
["Ayuntamiento Gijón/Xixón",-5.3750469376322762E-3,0.16042223234820568,3.8939116463911197E-2]
["Ayuntamiento L'Hospitalet",8.08099629444054E-2,8.0355117813103616E-2,9.4003098768973836E-2]
["Diputación Barcelona",1.4680939698614108E-2,5.4381924714741521E-2,7.2872344562036381E-2]
["Diputación Valencia",3.0919403415848999E-2,5.9045400026256203E-2,8.0865530560961782E-2]
["Diputación Sevilla",-6.2664938585225358E-2,-1.4847195725582435E-2,-6.476965372974583E-3]
["Cabildo Insular Tenerife",3.0943927855997568E-2,6.6187127532922968E-2,8.787121926668183E-2]
["Consell Insular Mallorca",5.1673880438393577E-2,7.2311467344260666E-2,6.7586148604064838E-2]
["Diputación Foral de Araba",-4.8876266934371089E-2,-5.9307250950991854E-2,2.3588815442556685E-3]
["Diputación Foral de Gipuzkoa",-9.3103750961088666E-3,-6.5060295759156034E-3,4.71394079763839E-3]
["Diputación Foral de Bizkaia",-1.2802699091083902E-2,-3.6024811628870355E-2,3.0148467650792828E-3]
["Media del grupo",1.5580182047663777E-2,2.0694188357287261E-2,3.0734807449361468E-2]

{"sheet":"2","index":1,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 2. PREVISIONES ESTABILIDAD PRESUPUESTARIA 2023 DE LAS 24 GRANDES CORPORACIONES LOCALES SIN EFECTO LIQUIDACIÓN 2020 SISTEMA FINANCIACIÓN ESTADO"]
["Corporaciones Locales","CNF / INF 2023 Entidades Locales sin liq. SF 2020","CNF / INF 2023 AIReF sin liq. SF 2020"]
["Ayuntamiento Madrid",-1.6110853840267496E-2,-1.8114623502276071E-2]
["Ayuntamiento Barcelona",-2.9936360055003358E-2,-3.1501276781473443E-2]
["Ayuntamiento Valencia",2.0977863140861494E-3,2.1387748575476196E-2]
["Ayuntamiento Sevilla",0.11894584658890048,8.427313163443903E-2]
["Ayuntamiento Zaragoza",1.9163168241251045E-2,5.5999828196096356E-2]
["Ayuntamiento Málaga",0.19402351615460608,8.0353956247514249E-2]
["Ayuntamiento Murcia",0.10092554752553508,-3.8615521229516968E-4]
["Ayuntamiento Palma",-1.8195642888479018E-2,6.7268522522278218E-2]
["Ayuntamiento Las Palmas Gran Canaria",-4.3100980562411954E-2,3.215313319556596E-2]
["Ayuntamiento Bilbao",-7.2814119251493045E-2,2.2008552561389632E-3]
["Ayuntamiento Alicante",2.7587466592611885E-2,6.2884935616334542E-2]
["Ayuntamiento Córdoba",7.2261258329622921E-2,8.028030134437443E-2]
["Ayuntamiento Valladolid",-2.028907299170226E-2,-7.5680486708529027E-3]
["Ayuntamiento Vigo",0,1.6821201219253932E-2]
["Ayuntamiento Gijón/Xixón",0.13543297873476906,1.413582577615031E-2]
["Ayuntamiento L'Hospitalet",8.0355117813103616E-2,6.8645105093510295E-2]
["Diputación Barcelona",3.2584597106011088E-3,2.2032886278347135E-2]
["Diputación Valencia",1.5358381565873243E-2,1.9643975509177729E-2]
["Diputación Sevilla",-6.3808110832821008E-2,-5.2310180335807512E-2]
["Cabildo Insular Tenerife",5.494307639254075E-2,7.634001210790177E-2]
["Consell Insular Mallorca",7.2311467344260666E-2,5.4623101478537252E-2]
["Diputación Foral de Araba",-5.9307250950991854E-2,2.3588815442556685E-3]
["Diputación Foral de Gipuzkoa",-6.5060295759156034E-3,4.71394079763839E-3]
["Diputación Foral de Bizkaia",-3.6024811628870355E-2,3.0148467650792828E-3]
["Media del grupo",1.9044840549860076E-3,9.7050677152453121E-3]

{"sheet":"3","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 3. ESTABILIDAD PRESUPUESTARIA CIERRE 2022 DE LAS 24 GRANDES CORPORACIONES LOCALES (CON Y SIN EFECTO LIQUIDACIÓN 2020 SISTEMA FINANCIACIÓN ESTADO)"]
["Corporaciones Locales","CNF / INF 2022 ","CNF / INF 2022 sin liq. SF"]
["Ayuntamiento Madrid",-4.3992097044019705E-2,-1.5079664270493153E-2]
["Ayuntamiento Barcelona",-5.8225353081927111E-2,-2.334890926775542E-2]
["Ayuntamiento Valencia",2.7287186450786025E-2,6.2182315318883644E-2]
["Ayuntamiento Sevilla",1.930664847694492E-2,5.346491281758186E-2]
["Ayuntamiento Zaragoza",5.4405440326681237E-2,8.5954777526513926E-2]
["Ayuntamiento Málaga",3.9196822490649152E-2,7.2830178218260586E-2]
["Ayuntamiento Murcia",-1.7196236689740962E-2,1.1114614633597499E-3]
["Ayuntamiento Palma",3.9932601508731638E-2,5.7314021382621261E-2]
["Ayuntamiento Las Palmas Gran Canaria",-8.9177467439210088E-3,1.8542847077292965E-2]
["Ayuntamiento Bilbao",5.9127411113215157E-2,5.9127411113215157E-2]
["Ayuntamiento Alicante",4.4655826925476816E-2,6.7143020429014086E-2]
["Ayuntamiento Córdoba",5.2934719474076686E-2,7.6215387626736589E-2]
["Ayuntamiento Valladolid",-0.10053536108445854,-7.7698404788147407E-2]
["Ayuntamiento Vigo",1.9872346614768433E-2,4.5466040613325806E-2]
["Ayuntamiento Gijón/Xixón",-6.8543497350995616E-2,-4.2974496078329857E-2]
["Ayuntamiento L'Hospitalet",1.9863471286625252E-2,4.6995637980860767E-2]
["Diputación Barcelona",7.826773735065333E-2,0.13199615222879918]
["Diputación Valencia",-1.071709778338318E-2,5.6409382780357259E-2]
["Diputación Sevilla",-9.1846810034069207E-2,-4.3144403250964525E-2]
["Cabildo Insular Tenerife",-3.9640430208741438E-2,-2.5610957072958244E-2]
["Consell Insular Mallorca",6.906662126153193E-2,8.4997170147601775E-2]
["Diputación Foral de Araba",2.26609827782829E-2,2.26609827782829E-2]
["Diputación Foral de Gipuzkoa",4.5297967264336096E-2,4.5297967264336096E-2]
["Diputación Foral de Bizkaia",2.1100904874644638E-2,2.1100904874644638E-2]
["Media del grupo",-2.6019538291025763E-3,2.0998823237937714E-2]

{"sheet":"4","index":3,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 4. EVOLUCIÓN DE LA REPRESENTATIVIDAD EN LA CAPACIDAD/NECESIDAD DE FINANCIACIÓN DE LOS DOS GRANDES AYUNTAMIENTOS, DE LAS DIPUTACIONES FORALES Y DEL RESTO DE GRANDES CORPORACIONES LOCALES"]
["Corporaciones Locales",2013,2014,2015,2016,2017,2018,2019,2020,2021,"2022 LF2023","2022 PR2023","2023 LF2023","2023 PR2023"]
["Ayuntamiento Madrid",965.80200000000002,1293.9659999999999,1385.086,1022.31284667,1057.0083958099999,1072.2034079100001,549.48449025000002,86.720941490000001,70.73208837,193.53323412,-236.300393000002,146.44616434000099,56.136660880000001]
["Ayuntamiento Barcelona",139.81700000000001,31.637,93.864000000000004,120.45433603000001,30.327480850000001,4.3862983700000004,47.065619469999994,-62.813579140000002,-80.53789879,-217.77023502999899,-197.48226652000099,0.53369350882300004,2.6190069999999999E-2]
["Diputaciones Forales",73.855511129999655,77.597395229996593,102.88858959000014,125.23852816000149,231.8913728600003,283.95844979000003,246.95937717999999,-229.02566367,229.03857553,200.38536188665501,166.130024650004,-95.751107809152003,-172.31578306]
["Resto Corporaciones Locales grandes",934.02362478000043,762.32408791000364,333.1614104099998,856.9942891399985,598.77275047999979,965.55671655000037,886.63133080000034,474.35221791999993,529.02053151999996,26.21974975347706,232.11302777865791,339.76075547885711,658.10659510924791]

{"sheet":"5","index":4,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 5. VARIACIONES DEL GASTO COMPUTABLE 24 GRANDES CORPORACIONES LOCALES AL CIERRE DE 2020, 2021 Y 2022"]
["Corporaciones Locales","Variación anual 2020","Variación anual 2021","Variación anual 2022"]
["Ayuntamiento Madrid",7.8627994712893834E-2,0.10571198165548523,0.11759846725683933]
["Ayuntamiento Barcelona",1.5098743745262988E-2,8.9906431469761738E-2,8.267829156170127E-2]
["Ayuntamiento Valencia",2.7622062664482083E-2,2.5833892966244276E-2,8.5529651999390457E-2]
["Ayuntamiento Sevilla",-9.7811957522841997E-4,-1.6239930819548221E-3,8.6021348926933042E-2]
["Ayuntamiento Zaragoza",0.13843827078636384,-5.6671666917718744E-2,9.0953201939983006E-2]
["Ayuntamiento Málaga",1.6075540049484971E-3,8.0243085308592269E-2,5.1680435217984266E-2]
["Ayuntamiento Murcia",8.0563235623789531E-3,3.3117928133168606E-2,7.0296612545760917E-2]
["Ayuntamiento Palma",8.0331017498459723E-2,3.9262411055570379E-2,9.5041690347644092E-2]
["Ayuntamiento Las Palmas Gran Canaria",0.12758736260909886,-1.3774810069447474E-2,1.2918448210276434E-2]
["Ayuntamiento Bilbao",-6.3998103947217611E-2,6.0779581467870658E-2,6.8536075600727164E-2]
["Ayuntamiento Alicante",8.5962578433415468E-2,3.4114884903512888E-2,0.13853302157784553]
["Ayuntamiento Córdoba",6.4126213040441415E-2,0.16949473495803002,-1.2894286717545556E-2]
["Ayuntamiento Valladolid",1.3258796321374389E-2,6.420685390895664E-2,0.13099879337467524]
["Ayuntamiento Vigo",-5.1622305364232075E-2,8.1816236130885844E-2,0.13099016769176686]
["Ayuntamiento Gijón/Xixón",2.3533319486420012E-2,6.0901892728260298E-2,6.668074935360746E-2]
["Ayuntamiento L'Hospitalet",5.8632269299104811E-2,-5.0141662684470178E-2,8.7508748816686785E-2]
["Diputación Barcelona",-4.5809002433136674E-2,3.8706596171863561E-2,1.1394762598041952E-2]
["Diputación Valencia",0.15911471433063795,7.5503289322865763E-2,4.9868391725552019E-2]
["Diputación Sevilla",3.0201830212217118E-2,1.3692756069897194,5.2172248078492522E-3]
["Cabildo Insular Tenerife",6.1922014026117633E-2,0.12717680540433096,0.44320023758980009]
["Consell Insular Mallorca",3.4203084772900239E-2,0.19972079096110495,0.115985417821582]
["Diputación Foral de Araba",6.0245794729731905E-3,3.7301787980686285E-2,7.1775862422453374E-2]
["Diputación Foral de Gipuzkoa",0.1952354081946592,-4.294045873596386E-3,6.5139274304012229E-2]
["Diputación Foral de Bizkaia",3.3385017073332746E-2,2.8365976842574803E-3,0.10905617964399106]
["Total",4.6655283648312063E-2,7.1882556431331901E-2,9.4448029554481838E-2]

{"sheet":"6","index":5,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 6. VARIACIONES DE LOS GASTOS PRIMARIOS AJUSTADOS POR EL PRTR DE LAS 24 GRANDES CORPORACIONES LOCALES AL CIERRE DE 2019 A 2022 Y PREVISIONES 2023"]
["Gastos 1, 2, 4, 5, 6 y 7  ajustados por inejecución y PRTR GASTOS PRIMARIOS"]
["Corporaciones Locales",2017,2018,2019,2020,2021,2022,2023]
["Ayuntamiento Madrid",-1.7183193554605326E-3,8.2427397843295086E-2,8.6682845202202527E-2,4.3271472169138327E-2,7.4584495862449821E-2,8.8254330994585142E-2,-4.2321152174985374E-2]
["Ayuntamiento Barcelona",7.065726502286972E-3,2.556265836515138E-2,-1.5847116234539625E-2,2.9034639302805143E-2,8.0470443214356591E-2,4.4373143227541559E-2,8.1830416677095411E-2]
["Ayuntamiento Valencia",2.6059137615829529E-2,4.0541645049317371E-2,5.9482690329494471E-2,4.406896168973793E-2,6.9735590924476246E-2,6.3219698302100058E-2,0.10070987978227251]
["Ayuntamiento Sevilla",2.1447795541118658E-5,3.9468741138833585E-2,1.5949624831748502E-2,7.5658536227795642E-2,-2.8164897666895821E-2,6.9859129234352613E-2,1.5695118153308516E-2]
["Ayuntamiento Zaragoza",5.2192150043388959E-2,6.3996149635351888E-3,-1.366748512714428E-2,0.15251891418310393,-2.0625618195562904E-2,5.377825138850071E-2,6.4102760890110716E-2]
["Ayuntamiento Málaga",2.636447102849274E-2,2.2336959356830711E-2,5.4133376834750106E-2,8.8553955269840921E-3,6.4974155193209329E-2,1.557444023391698E-2,-0.11120373071198601]
["Ayuntamiento Murcia",2.0860090376060804E-3,4.2828152413354054E-2,6.9341368270779413E-2,-1.4238465016159246E-2,1.2658108431165879E-2,6.8800384253166577E-2,-9.5491616290660997E-2]
["Ayuntamiento Palma",8.8757207164635865E-2,-7.663768579734663E-2,3.0048280990637319E-2,5.5605615853383757E-2,0.11613952298972739,3.0731707619544222E-2,7.394488116196217E-2]
["Ayuntamiento Las Palmas Gran Canaria",-4.9648379547383499E-2,0.12419811280598499,7.6416988931626656E-2,2.1405463306921956E-2,-1.9625856046409575E-2,1.4495562169928927E-2,0.32207588783188407]
["Ayuntamiento Bilbao",0.11735020679682295,1.6174606255594756E-4,7.2536999193424628E-2,-2.8913429916267337E-2,5.0253333470961996E-2,7.0236253288316716E-2,6.3941306599464065E-2]
["Ayuntamiento Alicante",-7.1881335593654089E-2,4.4613987161053248E-2,-4.8949842371854482E-3,6.7084904532500295E-2,9.549526068193287E-2,5.0351322872089599E-2,3.7113104731984598E-4]
["Ayuntamiento Córdoba",8.7646253599543394E-2,-3.2160519688137615E-2,-9.3038079485023555E-3,1.7097724357988144E-2,0.1723363298720676,-6.8766451504915588E-2,4.4587475376021042E-2]
["Ayuntamiento Valladolid",3.2821589929201832E-2,4.9297329935173335E-2,5.6552302375009487E-2,-7.738207306841269E-3,0.12436692969998207,7.8963887839965011E-2,-7.1711551799171325E-2]
["Ayuntamiento Vigo",8.5225433103305243E-2,0.16534915747398424,-7.3306662676536238E-2,-9.6889009549510671E-2,0.11313988300738584,6.5095996610041743E-2,7.5197423902714916E-2]
["Ayuntamiento Gijón/Xixón",3.3017087452122271E-2,-1.4704307363535772E-2,-1.2866693932040072E-2,5.9587465975476657E-2,2.7988067112481078E-2,8.825957474260672E-2,-0.18457142721349049]
["Ayuntamiento L'Hospitalet",4.0929007295876778E-2,0.11080959598071674,-1.474072775279042E-4,1.4237562456437832E-2,-4.8683311896444224E-2,6.3600992995425099E-2,-9.0687084503403112E-2]
["Diputación Barcelona",4.4814318011017776E-2,1.6526778721632541E-2,0.11478076824171703,-5.571285420078731E-2,3.6499032584887993E-2,2.0539525742866743E-2,0.17868159168626582]
["Diputación Valencia",-7.5027246268944026E-2,5.6085986831372836E-2,-1.3382735458173717E-2,9.4151943456880924E-2,4.4130118516833086E-2,9.4334784388076104E-2,6.2506925079686276E-2]
["Diputación Sevilla",-4.8896672929412653E-3,9.0062160358470339E-2,1.0207943900608666E-2,-1.5202480283343303E-2,0.66340624359517686,-8.8423410630762117E-2,8.2553414533161201E-2]
["Cabildo Insular Tenerife",0.13562478109568749,6.4642080206782304E-2,8.8636385312615088E-3,-8.1548252210879593E-2,1.1859651428801583E-2,0.11111120245927697,4.227404033256122E-2]
["Consell Insular Mallorca",0.21039965368615818,0.19837052082964135,-1.4083400894555899E-2,5.1488933034651109E-2,0.1114701785091157,1.982766669901749E-2,0.14552431162784074]
["Diputación Foral de Araba",0.15679287454962951,9.6155918093830291E-3,8.4447498337217999E-2,-6.0259357492206123E-2,4.7041516561505653E-2,6.4116672999282309E-2,0.16042169531898609]
["Diputación Foral de Gipuzkoa",2.0145498505883628E-2,4.6873710565679058E-2,7.2286802714528697E-2,3.3486387323996052E-2,8.8291549240202424E-2,5.3547933190087799E-2,0.13404351608736417]
["Diputación Foral de Bizkaia",4.1708534238730437E-2,1.0382956319254214E-2,7.1531212571245062E-2,1.8105271224748887E-3,9.0092846598831128E-2,0.22330153555959137,-8.7566928170063951E-2]
["Total",2.8429495003545687E-2,4.570034682837909E-2,4.1863008755877701E-2,2.2977954267822166E-2,7.1111320464932376E-2,6.9652308669929885E-2,2.6469026618410618E-2]

{"sheet":"7","index":6,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 7. VARIACIÓN INTERANUAL 2018-2023 DE INGRESOS FISCALES 16 GRANDES AYUNTAMIENTOS"]
["RECAUDACIÓN DE CTE Y CERRADOS DE 2017 A 2021. En 2022 y 2023 DR Entidades Locales-ajustes"]
["EVOLUCIÓN INGRESOS 1, 2 Y 3 NO CESIÓN AJUSTADOS"]
["Corporaciones Locales",2017,2018,2019,2020,2021,2022,2023]
["Ayuntamiento Madrid",4.7755527681620419E-2,2.891633642037927E-2,-2.461791089497585E-2,-9.0226690921785854E-2,7.9427232399406619E-2,-9.7021491338194724E-2,0.13533068454939667]
["Ayuntamiento Barcelona",7.8019111351587955E-3,7.03553067034753E-3,2.1340370251903763E-2,-7.7425656043898172E-2,0.15197504893930289,-1.0468208166975296E-2,3.9758722612843085E-2]
["Ayuntamiento Valencia",3.6242141072010771E-2,6.3016277300039725E-2,-5.0752997218364848E-2,-1.6778659504750749E-2,7.8253703690327858E-2,-3.1029424786980608E-3,1.5661609354012181E-2]
["Ayuntamiento Sevilla",2.8288334734141402E-2,3.4461961079168595E-2,1.3299618033247267E-2,-0.16516362687627528,7.8373582152820531E-2,8.5906806307733785E-2,2.228626840704271E-2]
["Ayuntamiento Zaragoza",3.0906115063055073E-2,-2.9706435850912614E-2,4.8151731988437963E-3,-9.8883516487047476E-2,8.9940680243564053E-2,-5.1127600126529699E-2,5.2102775059210633E-2]
["Ayuntamiento Málaga",1.521003031679664E-2,1.9723456950691023E-2,6.952842396209126E-2,-0.12349389653227315,4.8458935329449948E-2,-5.9001395715083692E-2,2.4136422905197161E-2]
["Ayuntamiento Murcia",4.4249163255130107E-3,-1.7219602920345602E-2,3.7934316087068688E-2,-3.3134069466174233E-2,6.1372386541825245E-2,-1.1622752005465692E-2,3.6334927075365994E-2]
["Ayuntamiento Palma",3.9918676848535131E-2,4.0768530044850364E-2,-3.1019749065609326E-2,-6.9748565534030846E-2,7.1616706395599736E-2,7.6035373440354714E-2,-3.1913020293768577E-3]
["Ayuntamiento Las Palmas Gran Canaria",6.3016495712929749E-2,5.4580883836023261E-2,-1.7311793925387745E-2,-0.18998338128907907,9.0304333760238942E-2,-8.8434209190022314E-3,0.22262379756059708]
["Ayuntamiento Bilbao",4.1853615925365947E-2,6.2982916574995398E-2,4.3492523210907436E-2,-5.8593399112894483E-2,9.7569890437981643E-2,6.6177029639386646E-3,-4.1207146889925085E-2]
["Ayuntamiento Alicante",-1.156712102371522E-2,-8.0228336718332453E-3,-1.2566960224706367E-2,-6.6351304576377695E-2,8.1441401351213485E-2,-2.4202203741263605E-2,2.475994230157038E-2]
["Ayuntamiento Córdoba",-1.3927442429683452E-2,-4.217730129135569E-2,-0.11283531311995067,-0.1179830453190482,4.4423961873286968E-2,1.3775017680053262E-2,2.4284240141196484E-2]
["Ayuntamiento Valladolid",3.6127155966438243E-2,1.3210113110796329E-2,-1.25367296320423E-2,-5.8764742741802448E-2,0.106421704950486,9.6022810816816812E-3,-1.2635119413121608E-2]
["Ayuntamiento Vigo",1.7015015843219735E-2,3.1043267923190739E-2,5.5984956491788848E-2,-6.7268757174038768E-2,6.904579960130941E-2,9.5377277305064929E-4,-3.0964757177243556E-2]
["Ayuntamiento Gijón/Xixón",2.1330593842915344E-3,4.1936377588376456E-2,-2.2074367362888196E-2,-7.7354428218579185E-2,-5.5209132494523196E-3,7.8176149330490913E-2,6.5154126142371437E-3]
["Ayuntamiento L'Hospitalet",5.62883553061444E-2,-2.5386652547805932E-2,-2.724578876747951E-2,-5.9303938135837855E-2,5.237440553989943E-2,3.5332218972185719E-2,7.2201934893131202E-3]
["Media",3.1046603941185552E-2,2.0689685121185564E-2,-7.4634821280118143E-3,-8.7415124359023239E-2,8.9118550267003313E-2,8.7326082309953246E-3,5.0453704670906332E-2]

{"sheet":"8","index":7,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,"GRÁFICO 8. EVOLUCIÓN DEL ENDEUDAMIENTO DE LAS 24 GRANDES CORPORACIONES LOCALES 2012 – 2022 Y ESTIMACIÓN 2023 (PORCENTAJE DE DEUDA SOBRE INGRESOS CORRIENTES)"]
[null,null,"Entidad local","Ratio Deuda 2012","Ratio Deuda 2022","Ratio Deuda 2023"]
[null,null,"Ayuntamiento Madrid",1.7746,0.34032499999999999,0.359016]
[null,null,"Ayuntamiento Barcelona",0.50919999999999999,0.35888199999999998,0.42261399999999999]
[null,null,"Ayuntamiento Valencia",1.37,0.24172099999999999,0.23236299999999999]
[null,null,"Ayuntamiento Sevilla",0.66,0.232261,0.24001800000000001]
[null,null,"Ayuntamiento Zaragoza",1.4421999999999999,0.77451899999999996,0.68736299999999995]
[null,null,"Ayuntamiento Málaga",1.3419000000000001,0.39717599999999997,0.34426699999999999]
[null,null,"Ayuntamiento Murcia",0.59899999999999998,0.59360599999999997,0.61754799999999999]
[null,null,"Ayuntamiento Palma",0.96909999999999996,0.40060899999999999,0.35197000000000001]
[null,null,"Ayuntamiento Las Palmas Gran Canaria",0.4254,0,9.8340000000000007E-3]
[null,null,"Ayuntamiento Bilbao",4.3E-3,1.0449E-2,3.3531999999999999E-2]
[null,null,"Ayuntamiento Alicante",0.74750000000000005,0,6.8079000000000001E-2]
[null,null,"Ayuntamiento Córdoba",0.95350000000000001,0.55029300000000003,0.54579699999999998]
[null,null,"Ayuntamiento Valladolid",0.76370000000000005,0.52787399999999995,0.59423199999999998]
[null,null,"Ayuntamiento Vigo",0.25480000000000003,0,0]
[null,null,"Ayuntamiento Gijón/Xixón",0.69989999999999997,0.40849400000000002,0.38966400000000001]
[null,null,"Ayuntamiento L'Hospitalet",0.69850000000000001,0.32301999999999997,0.29120400000000002]
[null,null,"Diputación Barcelona",0.33,0,0]
[null,null,"Diputación Valencia",0.94699999999999995,0.116442,8.4574999999999997E-2]
[null,null,"Diputación Sevilla",0.51280000000000003,1.9231000000000002E-2,1.7868999999999999E-2]
[null,null,"Cabildo Insular Tenerife",0.84279999999999999,0.177615,0.203898]
[null,null,"Consell Insular Mallorca",0.82440000000000002,0.20855599999999999,0.169464]
[null,null,"Diputación Foral de Araba",0.46800000000000003,0.77349900000000005,0.74409199999999998]
[null,null,"Diputación Foral de Gipuzkoa",0.41870000000000002,0.30062299999999997,0.28869800000000001]
[null,null,"Diputación Foral de Bizkaia",0.52929999999999999,0.747143,0.80747000000000002]
[null,null,"Media grupo",0.996,0.37450666220416368,0.38196547602902681]

{"sheet":"9","index":8,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 9. EVOLUCIÓN DEL ENDEUDAMIENTO DE LAS 24 GRANDES CORPORACIONES LOCALES 2012 – 2022 Y ESTIMACIÓN 2023 (PORCENTAJE DE DEUDA SOBRE INGRESOS CORRIENTES)"]
["Deuda viva",2018,2019,2020,2021,2022,2023]
["Ayuntamiento Madrid",2761.6941421900001,2232.5707179999999,1950.4941859400001,1679.5105074999999,1727.9367477799999,1804.57705968]
["Ayuntamiento Barcelona",837.46836666999991,781.73585534000006,801.48020400999997,817.50344583000003,1117.0653256400001,1393.8910000000001]
["Ayuntamiento Valencia",438.96669627,367.43070806000003,290.41098287,268.83176395999999,227.33342099999999,226.25104400000001]
["Ayuntamiento Sevilla",279.28223200000002,305.63964485000002,236.74616309000001,233.44067527000001,218.17776499999999,239.61652699999999]
["Ayuntamiento Zaragoza",855.28397673000006,705.61283667999999,700.98725617999992,665.96223163000002,630.11533844000007,571.70478732000004]
["Ayuntamiento Málaga",408.18047494999996,348.17261387999997,316.88355548000004,283.53985206999999,266.10752624000003,249.44631876]
["Ayuntamiento Murcia",329.84837614999998,305.009276,289.83640800000001,266.62378000000001,244.15973137,253.28337409]
["Ayuntamiento Palma",218.24348875000001,182.48650471000002,178.78847171000001,180.44493421000001,187.36931421,168.91143758000001]
["Ayuntamiento Las Palmas Gran Canaria",5.3999999999999998E-5,1.4811719999999999,1.346209,2.4822229999999998,0,4.2494529999999999]
["Ayuntamiento Bilbao",3.7615910000000001,3.3507560000000001,19.014588,26.782226000000001,7.0363521699999998,21.714924170000003]
["Ayuntamiento Alicante",24.90887309,24.629843999999999,0.57655599999999996,0.20197300000000001,0,19.8523]
["Ayuntamiento Córdoba",163.07530399999999,144.61798400000001,144.881396,176.37633700000001,184.18974399999999,188.089867]
["Ayuntamiento Valladolid",98.166957999999994,99.117673999999994,106.82663100000001,145.11690200000001,158.62231234999999,178.5622219]
["Ayuntamiento Vigo",7.8545000000000004E-2,0.112335,4.7788999999999998E-2,1.021E-3,0,0]
["Ayuntamiento Gijón/Xixón",111.750534,98.218999999999994,97.950693000000001,103.837996,100.45891976999999,99.274177659999992]
["Ayuntamiento L'Hospitalet",79.991208599999993,78.652547999999996,71.055627999999999,57.778970000000001,85.317912950000007,75.635970749999998]
["Diputación Barcelona",113.317004,38.411642999999998,0.14490600000000001,0.22401199999999999,0,0]
["Diputación Valencia",113.0185749,56.875015939999997,34.76032798,31.75657202,62.922103999999997,50.914087000000002]
["Diputación Sevilla",10.297176,9.9029249999999998,9.3450869999999995,8.9086960000000008,6.7030849999999997,5.6051880000000001]
["Cabildo Insular Tenerife",156.9735206,63.244815000000003,58.461834000000003,148.783558,134.12964955000001,186.94536743]
["Consell Insular Mallorca",125.03423119,119.622546,117.36945,113.636629,95.472002209999999,92.545409909999989]
["Diputación Foral de Araba/Álava",539.02034500000002,463.47936199999998,513.82406000000003,563.99769500000002,641.90743758000008,629.06928882839998]
["Diputación Foral de Gipuzkoa",358.83846168999997,321.69008049000001,268.35243816999997,315.991759,484.34603623260898,476.77973586490799]
["Diputación Foral de Bizkaia",2097.1057894,1996.7366734000002,2229.8003114000003,2484.690415,2278.3166940300002,2260.1246657500001]
[]
["Remanente de Tesorería Ajustado",2018,2019,2020,2021,2022]
["Ayuntamiento Madrid",1194.3200155,1069.31986001,763.04699316999995,821.38285889999997,385.998600194993]
["Ayuntamiento Barcelona",186.47004641000001,213.37569581,227.81477766,201.8897135,165.97506419999999]
["Ayuntamiento Valencia",51.707258150000001,54.056528149999998,53.18447338,82.92226165999999,74.215350279999996]
["Ayuntamiento Sevilla",36.675720259999999,32.007588749999996,-29,23.159475440000001,151.13544497999999]
["Ayuntamiento Zaragoza",22.89458441,32.655631710000002,-18,11.984545170000001,26.92399206]
["Ayuntamiento Málaga",113.26078982999999,89.871933080000005,72.447900489999995,103.15089831,134.68596019]
["Ayuntamiento Murcia",-5,-8,-21,-33,-37]
["Ayuntamiento Palma",25.131915960000001,65.082172409999998,47.40683962,56.24049376,47.53577585]
["Ayuntamiento Las Palmas Gran Canaria",193.51449143000002,239.88666840000002,241.75403990999999,246.26328369000001,320.89413000000002]
["Ayuntamiento Bilbao",95.283764579999996,119.94751015,99.648615409999991,86.705055849999994,118.85292263765]
["Ayuntamiento Alicante",41.111727250000001,76.026696770000001,72.235002420000001,109.63183002,135.17369655000002]
["Ayuntamiento Córdoba",56.335981159999996,30.748899269999999,40.876575689999996,41.005368740000002,42.70396246]
["Ayuntamiento Valladolid",58.097298409999993,56.092396270000002,60.002442030000005,57.66007682,57.677925389999999]
["Ayuntamiento Vigo",79.487659480000005,98.966022680000009,125.42992086,142.01099384,151.93357125]
["Ayuntamiento Gijón/Xixón",40.385950840000007,36.826742200000005,38.241939500000001,30.925285969999997,60.35306988]
["Ayuntamiento L'Hospitalet",31.15551482,22.612045139999999,12.91939837,19.563179739999999,26.79647714]
["Diputación Barcelona",481.70205711,428.42658936999999,426.31421916000005,472.32520963999997,609.89340555999991]
["Diputación Valencia",233.01797371000001,157.83325766999999,222.24414986000002,251.56419228000001,297.74531604999999]
["Diputación Sevilla",322.71442779,399.53048583999998,488.85488329000003,417.41318674000001,405.01477569000002]
["Cabildo Insular Tenerife",91.695971310000004,99.115304909999992,101.68981059999999,141.39412562999999,146.33144440000001]
["Consell Insular Mallorca",-29,39.23389383,56.859927929999998,58.375386829999997,90.382250549999995]
["Diputación Foral de Araba/Álava",147.78835819999998,144.77466081999998,107.54252656,226.71030837999999,267.93682393]
["Diputación Foral de Gipuzkoa",196.63346036000002,182.78741411999999,163.02289487000002,331.59940485000004,374.87213327000001]
["Diputación Foral de Bizkaia",92.863304799999995,54.690402929999998,150.79823852999999,426.50193267999998,386.578474940001]