{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["iaith - language","Text","queryformround1","2026-27 Settlement data"],"not_rendered":{"defined_names":12,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"iaith - language","index":0,"n_rows":6,"n_cols":12,"rows_kept":6,"hidden":true}
[1,{"$nulls":9},1,"Cymraeg/Welsh"]
[{"$nulls":11},"Saesneg/English"]
[{"$nulls":11},"Dewiswch os gwelwch yn dda / Please select"]
[{"$f":"IF('iaith - language'!$K$1=3,\"\", IF('iaith - language'!$K$1=2,VLOOKUP(A1,Text!$A$2:$C$366,2,0),VLOOKUP(A1,Text!$A$2:$C$366,3,0)))","v":"Proses wirio data Cylch 1 - data i'w defnyddio ar gyfer Setliad 2026-27"}]
[]
["Dewiswch iaith / Choose your preferred language:"]

{"sheet":"Text","index":1,"n_rows":242,"n_cols":6,"rows_kept":242,"hidden":true,"merged":[[0,9,0,10]]}
[null,"English","Welsh"]
[1,"Round 1 Data verification process - data for use in the 2026-27 Settlement","Proses wirio data Cylch 1 - data i'w defnyddio ar gyfer Setliad 2026-27"]
[2,"Round 1 data verification process","Proses gwiriad data cylch 1"]
[3,"Please select your authority name:","Dewiswch enw eich awdurdod:"]
[4,"Pupils at Independent schools ","Disgyblion mewn ysgolion annibynnol"]
[5,"You are requested to notify us of any pupils educated in independent schools for pupils without statements of special educational need (excluding special schools) ","Gofynnir ichi roi gwybod inni am unrhyw ddisgyblion sy'n cael eu haddysgu mewn ysgolion annibynnol ar gyfer disgyblion nad ydynt ar ddatganiad anghenion addysgol arbennig (ac eithrio ysgolion arbennig)"]
[6,"for whom your authority pays full tuition fees as recorded on line 1.3.5 on the Section 52 outturn return. This information should be provided in respect of the position at April 2024.","y mae eich awdurdod yn talu ffïoedd dysgu llawn ar eu cyfer, fel sydd wedi'i gofnodi ar llinell 1.3.5 o adroddiad alldro Adran 52. Dylid darparu'r wybodaeth hon ar gyfer y sefyllfa fel yr oedd ym mis Ebrill 2024."]
[7,"These pupils are directly credited in the SSAs and it is therefore very important that this information is provided to ensure the accuracy of the calculations. ","Rhoddir credyd yn uniongyrchol ar gyfer y disgyblion hyn yn yr Asesiadau o Wariant Safonol, felly mae'n bwysig iawn fod yr wybodaeth hon yn cael ei darparu er mwyn sicrhau bod y cyfrifiadau'n gywir. "]
[8,"Please provide the figures to us in the table below. Note that it will be assumed that there are no such pupils unless otherwise indicated. ","Darparwch y ffigurau inni yn y tabl isod. Sylwch y cymerir yn ganiataol nad oes disgyblion o'r fath os na ddywedir yn wahanol. "]
[9,"Data set","Set ddata"]
[10,"Pupils in N2 or reception year groups in nursery or primary schools","Disgyblion mewn grwpiau blwyddyn meithrin 2 neu flwyddyn derbyn mewn ysgolion meithrin neu gynradd"]
[11,"Primary school pupils in year groups 1 and above","Disgyblion ysgol gynradd yng ngrwpiau blwyddyn 1 ac uwch"]
[12,"Secondary school pupils in year groups 10 and 11","Disgyblion ysgol uwchradd yng ngrwpiau blwyddyn 10 ac 11"]
[13,"Secondary school pupils in year groups 7-11","Disgyblion ysgol uwchradd yng ngrwpiau blwyddyn 7-11"]
[14,"Secondary school pupils in year groups 12-14","Disgyblion ysgol uwchradd yng ngrwpiau blwyddyn 12-14"]
[15,"The non-financial data originally sourced by Local Authorities is used to calculate Standard Spending Assessments within the Local Government Settlement. ","Defnyddir y data heb fod yn ariannol, a gasglwyd yn wreiddiol gan Awdurdodau Lleol, i gyfrifo Asesiadau o Wariant Safonol (SSAs) yn y Setliad Llywodraeth Leol. "]
[16,"This data has already been through various quality assurance and validation processes prior to its publication.","Mae'r data hyn eisoes wedi bod drwy amryw o brosesau sicrhau ansawdd a gwirio cyn iddynt gael eu cyhoeddi."]
[17,"The purpose of the data verification exercise is not to re-visit published estimates where the changes are minor. This process is to ensure that any significant errors or revisions to the non-financial data are identified prior to the publication of the Local Government Settlement.","Ni ddylid defnyddio’r broses wirio hon i roi sylw i amcangyfrifon sydd wedi eu cyhoeddi os yw’r newidiadau dan sylw yn rhai mân. Yn hytrach, nod y broses yw sicrhau bod unrhyw gamgymeriadau sylweddol yn y data heb fod yn ariannol, neu newidiadau o bwys iddynt, yn cael eu nodi cyn cyhoeddi'r Setliad Llywodraeth Leol. "]
[18,"Query form for comments on data","Ffurflen ymholiadau ar gyfer sylwadau ar y data"]
[19,"Topic area","Pwnc"]
[20,"Data point","Pwynt data"]
[21,"Verification figure","Ffigur gwiriad"]
[22,"Data Repository","Ystorfa Ddata"]
[23,"Updated Figure","Ffigur diwygiedig"]
[24,"Only if agreed by data repository","Dim ond os cytunwyd gan yr ystorfa ddata"]
[25,"Comments/Queries","Sylwadau/Ymholiadau"]
[26,"If you have agreed an update to your published data with the relevant data repository, please provide details here","Os ydych chi wedi cael cytundeb yr ystorfa ddata berthnasol i ddiwygio eich data cyhoeddedig, rhowch fanylion "]
[27," Local Government Finance Policy and Sustainability Division, Welsh Government","Yr Is-adran Polisi Cyllid Llywodraeth Leol a Chynaliadwyedd, Llywodraeth Cymru"]
[28,"Please return by email to:","I'w ddychwelyd drwy e-bost i:"]
[29,"Welsh Government ","Llywodraeth Cymru"]
[30,"For queries please contact: ","Os oes gennych ymholiadau, cysylltwch â:"]
[31,"For detailed descriptions on the data in this spreadsheet please see the data note document for round 1 verification on the website:","Mae disgrifiadau manwl o'r data yn y daenlen hon i'w cael yn y ddogfen nodiadau ar y data ar gyfer gwiriad cylch 1, sydd ar gael ar y wefan. "]
[32,"https://gov.wales/topics/localgovernment/finandfunding/settlement/local-gov-verification-settlement-2022-23/?lang=en","https://llyw.cymru/topics/localgovernment/finandfunding/settlement/local-gov-verification-settlement-2022-23/?skip=1&lang=cy"]
[33,"Notes:","Nodiadau:"]
[34,"1 This data set is taken as a 3 year average in the settlement.","1 Caiff y set ddata hon ei chymryd fel cyfartaledd 3 blynedd yn y setliad."]
[35,"2 The dataset 'Private Sector Dwelling Stock' was removed from the Revenue Support Grant settlement calculations, although is included within the General Capital Funding (GCF) formulae","2 Cafodd y set ddata 'Stoc Anheddau'r Sector Preifat' ei hepgor o'r cyfrifiadau ar gyfer y setliad Grant Cynnal Refeniw, ond mae wedi ei chynnwys yn y fformiwlâu ar gyfer Cyllid Cyfalaf Cyffredinol"]
[36,"3 This data was not used in 2012-13","3 Ni ddefnyddiwyd y data hyn yn 2012-13"]
[null,"Data - English","Data - Welsh"]
[38,"PLANNING APPLICATIONS","CEISIADAU CYNLLUNIO"]
[39,"TAX CREDIT CLAIMANTS","HAWLWYR CREDYD TRETH"]
[40,"ROADS DATA","DATA FFYRDD "]
[41,"TRAFFIC FLOW","LLIF TRAFFIG"]
[42,"PRIVATE SECTOR DWELLING STOCK","STOC ANHEDDAU'R SECTOR PREIFAT"]
[43,"LAND AREA","ARWYNEBEDD TIR"]
[44,"POPULATION DATA","DATA POBLOGAETH"]
[45,"POPULATION ESTIMATES DATA","DATA AMCANGYFRIFON POBLOGAETH"]
[46,"HOUSING DATA - GCF","DATA TAI - CYLLID CYFALAF CYFFREDINOL"]
[47,"LAND DRAINAGE PRECEPTS","PRAESEPTAU DRAENIO TIR"]
[48,"LENGTH OF PROTECTED COASTLINE","HYD YR ARFORDIR A WARCHODIR"]
[49,"FARMS","FFERMYDD"]
[50,"HOMELESSNESS DATA","DATA DIGARTREFEDD"]
[51,"Planning Applications Received","Ceisiadau Cynllunio a Gafwyd"]
[52,"Dependent children in out of work families ","Plant dibynnol mewn teuluoedd di-waith"]
[53,"A County road length (km)","Hyd ffyrdd A y sir (km)"]
[54,"Built-up A County road length (km)","Hyd ffyrdd A y sir, adeiledig (km)"]
[55,"B and C road length (km)","Hyd ffyrdd B ac C (km)"]
[56,"Built-up B and C road length (km)","Hyd ffyrdd B ac C, adeiledig (km)"]
[57,"Minor surfaced road length (km)","Hyd is-ffyrdd â wyneb caled (km)"]
[58,"Built-up minor surfaced road length (km)","Hyd is-ffyrdd â wyneb caled, adeiledig (km)"]
[59,"Traffic flow (vehicles)","Llif traffig (cerbydau)"]
[60,"Total Homelessness Decisions","Cyfanswm Penderfyniadau Digartrefedd"]
[61,"Private sector dwelling stock","Stoc anheddau'r sector preifat"]
[62,"Land area (hectares)","Arwynebedd tir (hectarau)"]
[63,"Motor vehicle traffic on all principal roads","Traffig cerbydau modur ar yr holl prf ffyrdd"]
[64,"Owner-occupied, privately rented, intermediate and other tenures","Yn eiddo i berchen-feddianwyr, wedi'u rhentu'n breifat, deiliadaeth ganolradd a deiliadaethau eraill"]
[65,"Area in hectares","Arwynebedd mewn hectarau"]
[66,"Total population","Cyfanswm y boblogaeth"]
[67,"Total population","Cyfanswm y boblogaeth"]
[68,"Population aged 3","Poblogaeth 3 oed "]
[69,"Population aged 3 to 11 ","Poblogaeth 3 i 11 oed"]
[70,"Population aged 3 to 16 ","Poblogaeth 3 i 16 oed "]
[71,"Population aged 11 to 15 ","Poblogaeth 11 i 15 oed "]
[72,"Population aged 11 to 20 ","Poblogaeth 11 i 20 oed "]
[73,"Population aged 16 and over","Poblogaeth 16 oed a throsodd "]
[74,"Population aged 16 to 18","Poblogaeth 16 i 18 oed "]
[75,"Population aged 0 to 17","Poblogaeth 0 i 17 oed "]
[76,"Population aged 18 to 64 ","Poblogaeth 18 i 64 oed "]
[77,"Population aged 18 and over","Poblogaeth 18 oed a throsodd "]
[78,"Population aged under 60","Poblogaeth o dan 60 oed "]
[79,"Population aged 60 and over ","Poblogaeth 60 oed a throsodd"]
[80,"Population aged 85 and over","Poblogaeth 85 oed a throsodd "]
[81,"Working age population    (16-65M/F) ","Poblogaeth oedran gweithio (16-65G/B) "]
[82,"Mid-Year Population Estimates all ages","Amcangyfrifon Poblogaeth Ganol Blwyddyn, pob oed"]
[83,"Mid-Year Population Estimates aged 18 and over","Amcangyfrifon Poblogaeth Ganol Blwyddyn, 18 oed a throsodd"]
[84,"Mid-Year Population Estimates aged 65 and over","Amcangyfrifon Poblogaeth Ganol Blwyddyn, 65 oed a throsodd"]
[85,"Amount spent on mandatory Disabled Facilities Grants completed by area (£s)","Swm a wariwyd ar grantiau cyfleusterau i'r anabl wedi'u cwblhau (£s)"]
[86,"Amount spent on DFGs completed (£s)","Swm a wariwyd ar grantiau cyfleusterau i'r anabl wedi'u cwblhau (£s)"]
[87,"Special levies by Internal Drainage Boards","Ardollau arbennig gan Fyrddau Draenio Mewnol"]
[88,"Length (km)","Hyd (km)"]
[89,"Number of economically active farms","Nifer y ffermydd economaidd weithgar"]
[90,"Land Drainage Precepts","Praeseptau Draenio Tir"]
[91,"Length of protected coastline","Hyd yr arfordir a warchodir"]
[92,"Number of Farms","Nifer y Ffermydd"]
[93,"HM Revenue & Customs","Cyllid a Thollau EM"]
[143,"Total street lighting units","Cyfanswm yr unedau goleuadau stryd"]
[144,"TRADING PREMISES","EIDDO MASNACHU"]
[145,"Number of Trading Premises","Nifer yr Eiddo Masnachu"]
[146,"FOOD PREMISES","EIDDO BWYD"]
[147,"Number of Food Premises","Nifer yr Eiddo Bwyd"]
[148,"MORTALITY DATA","DATA MARWOLAETHAU"]
[149,"Registered number of deaths","Nifer y marwolaethau wedi'u cofrestru"]
[150,"COUNCIL TAX REDUCTION SCHEMES (CTRS) DATA","DATA CYNLLUNIAU GOSTYNGIADAU'R DRETH GYNGOR "]
[151,"CTRS Caseload ","Llwyth achosion Cynlluniau Gostyngiadau'r Dreth Gyngor "]
[152,"CTRS Expenditure","Gwariant Cynlluniau Gostyngiadau'r Dreth Gyngor"]
[152.5,"Covid-19 CTRS support","Cefnogaeth CTRS Covid-19 "]
[153,"Valuation Office Agency (VOA)","Asiantaeth y Swyddfa Brisio"]
[154,"STREET LIGHTING UNITS","UNEDAU GOLEUADAU STRYD"]
[158,"Office for National Statistics (ONS)","Y Swyddfa Ystadegau Gwladol"]
[159,"SHIPS ARRIVING AT PORTS","LLONGAU SY'N CYRRAEDD PORTHLADDOEDD"]
[160,"Number of ships arriving at ports","Nifer y llongau sy'n cyrraedd porthladdoedd"]
[161,"TOURISM DATA","DATA TWRISTIAETH"]
[162,"Tourist nights (thousands) inc AirBnb","Nosweithiau twristiaid (miloedd) gan gynnwys AirBnb"]
[163,"Tourist days (thousands)","Diwrnodau twristiaid (miloedd)"]
[164,"Scarborough Tourism Economic Activity Monitor (STEAM) ","Scarborough Tourism Economic Activity Monitor (STEAM) "]
[165,"UNEMPLOYMENT BENEFIT CLAIMANT COUNT DATA","DATA AR GANRAN YR HAWLWYR BUDD-DAL DIWEITHDRA"]
[166,"Numbers of claimants","Nifer yr hawlwyr"]
[178,"HOUSING BENEFIT CLAIMANTS","NIFER YR HAWLWYR BUDD-DAL TAI"]
[179,"BENEFITS CLAIMANTS DATA","DATA AR HAWLWYR BUDD-DALIADAU"]
[192,"Claimant Count Data","Data Hawlwyr Budd-dal "]
[193,"Housing Benefit Claimants","Nifer Yr Hawlwyr Budd-dal Tai"]
[194,"Number of Income Support Claimants, aged 18-64","Nifer yr Hawlwyr Cymhorthdal Incwm, 18-64 oed"]
[195,"Number of Income Based Jobseeker’s Allowance Recipients, aged 18-64","Nifer y Derbynwyr Lwfans Ceisio Swydd ar Sail Incwm, 18-64 oed"]
[196,"Number of Pension Credit Claimants, aged 18-64","Nifer yr hawlwyr Credyd Pensiwn, 18-64 oed"]
[197,"Number of people on Universal Credit (not in employment) aged 18-64","Nifer y rhai sydd yn derbyn Credyd Cynhwysol (ddim mewn cyflogaeth) 18-64 oed"]
[198,"Total number of Income Support Claimants","Cyfanswm yr Hawlwyr Cymhorthdal Incwm"]
[199,"Total number of Income Based Jobseeker’s Allowance Recipients","Cyfanswm y Derbynwyr Lwfans Ceisio Swydd ar Sail Incwm"]
[200,"Total number of Pension Credit Claimants","Cyfanswm Hawlwyr Credyd Pensiwn"]
[201,"Total number of people on Universal Credit (not in employment)","Cyfanswm y rhai sy’n derbyn Credyd Cynhwysol (ddim mewn cyflogaeth)"]
[202,"Number of Severe Disablement Allowance Claimants aged 18-64","Nifer yr Hawlwyr Lwfans Anabledd Difrifol, 18-64 oed"]
[203,"Number of Disability Living Allowance Claimants aged 18-64","Nifer yr Hawlwyr Lwfans Byw i'r Anabl, 18-64 oed",null,"To use",1]
[204,"Number of Personal Independence Payment Claimants aged 18-64","Nifer yr Hawlwyr Taliad Annibyniaeth Bersonol sydd yn 18-64 oed",2,{"$f":"IF('iaith - language'!$K$1=2,Text!B142,Text!C142)","v":"Dewiswch / Select"}]
[205,"Pension Credit (PC) claimants aged 65+","Hawlwyr Credyd Pensiwn, 65 oed a hŷn ",3,{"$f":"IF('iaith - language'!$K$1=2,Text!B143,Text!C143)","v":"Sir Ynys Môn"}]
[206,"Total Income Support (IS), Job Seekers Allowance (JSA) and Pension Credit (PC) claimants","Cyfanswn yr hawlwyr Cymhorthdal Incwm, Lwfans Ceisio Gwaith, a Chredyd Pensiwn",4,{"$f":"IF('iaith - language'!$K$1=2,Text!B144,Text!C144)","v":"Gwynedd"}]
[207,"Severe Disablement Allowence (SDA) and Disability Living Allowence (DLA) claimants aged 18-64","Pobl (18-64) sy'n hawlio Lwfans Anabledd Difrifol a Lwfans Byw i'r Anabl",5,{"$f":"IF('iaith - language'!$K$1=2,Text!B145,Text!C145)","v":"Conwy"}]
[208,"Department for Work and Pensions (DWP) ","Yr Adran Gwaith a Phensiynau (DWP)",6,{"$f":"IF('iaith - language'!$K$1=2,Text!B146,Text!C146)","v":"Sir Ddinbych"}]
[209,"NOMIS official labour market statistics","NOMIS ystadegau swyddogol y farchnad lafur",7,{"$f":"IF('iaith - language'!$K$1=2,Text!B147,Text!C147)","v":"Sir y Fflint"}]
[210,"NOMIS official labour market statistics and Department for Work and Pensions (DWP)","NOMIS ystadegau swyddogol y farchnad lafur a Yr Adran Gwaith a Phensiynau (DWP)",8,{"$f":"IF('iaith - language'!$K$1=2,Text!B148,Text!C148)","v":"Wrecsam"}]
[271,"LGFPSettlement@Gov.Wales","LGFPSettlement@Llyw.Cymru",9,{"$f":"IF('iaith - language'!$K$1=2,Text!B149,Text!C149)","v":"Powys"}]
[272,"Maritime and shipping statistics, Department for Transport","Ystadegau morol a llongau, Yr Adran Drafnidiaeth",10,{"$f":"IF('iaith - language'!$K$1=2,Text!B150,Text!C150)","v":"Sir Ceredigion"}]
[273,"*Data not submitted","*Data heb ei gyflwyno",11,{"$f":"IF('iaith - language'!$K$1=2,Text!B151,Text!C151)","v":"Sir Benfro"}]
[null,"LA name English","LA name Welsh",12,{"$f":"IF('iaith - language'!$K$1=2,Text!B152,Text!C152)","v":"Sir Gaerfyrddin"}]
[116,"Please select","Dewiswch / Select",13,{"$f":"IF('iaith - language'!$K$1=2,Text!B153,Text!C153)","v":"Abertawe"}]
[117,"Isle of Anglesey","Sir Ynys Môn",14,{"$f":"IF('iaith - language'!$K$1=2,Text!B154,Text!C154)","v":"Castell-nedd Port Talbot"}]
[118,"Gwynedd","Gwynedd",15,{"$f":"IF('iaith - language'!$K$1=2,Text!B155,Text!C155)","v":"Pen-y-bont ar Ogwr"}]
[119,"Conwy","Conwy",16,{"$f":"IF('iaith - language'!$K$1=2,Text!B156,Text!C156)","v":"Bro Morgannwg"}]
[120,"Denbighshire","Sir Ddinbych",17,{"$f":"IF('iaith - language'!$K$1=2,Text!B157,Text!C157)","v":"Rhondda Cynon Taf"}]
[121,"Flintshire","Sir y Fflint",18,{"$f":"IF('iaith - language'!$K$1=2,Text!B158,Text!C158)","v":"Merthyr Tudful"}]
[122,"Wrexham","Wrecsam",19,{"$f":"IF('iaith - language'!$K$1=2,Text!B159,Text!C159)","v":"Caerffili"}]
[123,"Powys","Powys",20,{"$f":"IF('iaith - language'!$K$1=2,Text!B160,Text!C160)","v":"Blaenau Gwent"}]
[124,"Ceredigion","Sir Ceredigion",21,{"$f":"IF('iaith - language'!$K$1=2,Text!B161,Text!C161)","v":"Torfaen"}]
[125,"Pembrokeshire","Sir Benfro",22,{"$f":"IF('iaith - language'!$K$1=2,Text!B162,Text!C162)","v":"Sir Fynwy"}]
[126,"Carmarthenshire","Sir Gaerfyrddin",23,{"$f":"IF('iaith - language'!$K$1=2,Text!B163,Text!C163)","v":"Casnewydd"}]
[127,"Swansea","Abertawe",24,{"$f":"IF('iaith - language'!$K$1=2,Text!B164,Text!C164)","v":"Caerdydd"}]
[128,"Neath Port Talbot","Castell-nedd Port Talbot",null,{"$f":"IF('iaith - language'!$K$1=2,Text!B165,Text!C165)","v":"Cyfanswm AU "}]
[129,"Bridgend","Pen-y-bont ar Ogwr"]
[130,"The Vale of Glamorgan","Bro Morgannwg"]
[131,"Rhondda Cynon Taf","Rhondda Cynon Taf"]
[132,"Merthyr Tydfil","Merthyr Tudful"]
[133,"Caerphilly","Caerffili"]
[134,"Blaenau Gwent","Blaenau Gwent"]
[135,"Torfaen","Torfaen"]
[136,"Monmouthshire","Sir Fynwy"]
[137,"Newport","Casnewydd"]
[138,"Cardiff","Caerdydd"]
[139,"UA Total","Cyfanswm AU "]
[140,"1 The dataset 'Private Sector Dwelling Stock' was removed from the Revenue Support Grant settlement calculations, although is included within the General Capital Funding (GCF) formulae","1 Cafodd y set ddata 'Stoc Anheddau'r Sector Preifat' ei hepgor o'r cyfrifiadau ar gyfer y setliad Grant Cynnal Refeniw, ond mae wedi ei chynnwys yn y fformiwlâu ar gyfer Cyllid Cyfalaf Cyffredinol"]
[141,".. The data item is not available",".. Nid yw'r eitem ddata yma ar gael"]
[142,"Please note the published mid-year population have been dif"]
[271.5,"Council tax stock of properties","Stoc eiddo treth cyngor"]
[274,"Valuation Office Agency (VOA)","Asiantaeth y Swyddfa Brisio"]
[600,"Round 1 Data verification process - data for use in the 2026-27 Settlement","Proses wirio data Cylch 1 - data i'w defnyddio ar gyfer Setliad 2026-27"]
[601,"June 2021","Mehefin 2021"]
[602,"September 2021","Medi 2021"]
[603,"December 2021","Rhagfyr 2021"]
[604,"March 2022","Mawrth 2022"]
[605,"May 2022","Mai 2022"]
[606,"April 2022","Ebrill 2022"]
[607,"October 2021","Hydref 2021"]
[608,"November 2021","Tachwedd 2021"]
[609,"December 2021","Rhagfyr 2021"]
[610,"January 2022","Ionawr 2022"]
[611,"February 2022","Chwefror 2022"]
[612,"June 2022","Mehefin 2022"]
[613,"July 2022","Gorffennaf 2022"]
[614,"August 2022","Awst 2022"]
[615,"May 2021","Mai 2021"]
[616,"August 2021","Awst 2021"]
[300,"Data used in the 2022-23 Settlement - for information purposes only","Data a ddefnyddiwyd yn Setliad 2022-23 – er gwybodaeth yn unig"]
[301,"June 2020","Mehefin 2020"]
[302,"September 2020","Medi 2020"]
[303,"December 2020","Rhagfyr 2020"]
[304,"March 2021","Mawrth 2021"]
[305,"May 2021","Mai 2021"]
[306,"April 2021","Ebrill 2021"]
[307,"October 2020","Hydref 2020"]
[308,"November 2020","Tachwedd 2020"]
[309,"December 2020","Rhagfyr 2020"]
[310,"January 2021","Ionawr 2021"]
[311,"February 2021","Chwefror 2021"]
[312,"June 2021","Mehefin 2021"]
[313,"July 2021","Gorffennaf 2021"]
[314,"August 2021","Awst 2021"]
[315,"May 2020","Mai 2020"]
[316,"August 2020","Awst 2020"]
[400,"Data used in the 2021-22 Settlement - for information purposes only","Data a ddefnyddiwyd yn Setliad 2021-22 – er gwybodaeth yn unig"]
[401,"June 2019","Mehefin 2019"]
[{"$f":"A206+1","v":402},"September 2019","Medi 2019"]
[{"$f":"A207+1","v":403},"December 2019","Rhagfyr 2019"]
[404,"March 2020","Mawrth 2020"]
[405,"May 2020","Mai 2020"]
[406,"April 2020","Ebrill 2020"]
[407,"October 2019","Hydref 2019"]
[408,"November 2019","Tachwedd 2019"]
[409,"December 2019","Rhagfyr 2019"]
[410,"January 2020","Ionawr 2020"]
[411,"February 2020","Chwefror 2020"]
[412,"June 2020","Mehefin 2020"]
[413,"July 2020","Gorffennaf 2020"]
[414,"August 2020","Awst 2020"]
[415,"May 2019","Mai 2019"]
[416,"August 2019","Awst 2019"]
[500,"Data used in the 2020-21 Settlement - for information purposes only","Data a ddefnyddiwyd yn Setliad 2020-21 – er gwybodaeth yn unig"]
[{"$f":"A222+1","v":501},"June 2018","Mehefin 2018"]
[{"$f":"A223+1","v":502},"September 2018","Medi 2018"]
[{"$f":"A224+1","v":503},"December 2018","Rhagfyr 2018"]
[504,"March 2019","Mawrth 2019"]
[505,"May 2019","Mai 2019"]
[506,"April 2019","Ebrill 2019"]
[507,"October 2018","Hydref 2018"]
[508,"November 2018","Tachwedd 2018"]
[509,"December 2018","Rhagfyr 2018"]
[510,"January 2019","Ionawr 2019"]
[511,"February 2019","Chwefror 2019"]
[512,"June 2019","Mehefin 2019"]
[513,"July 2019","Gorffennaf 2019"]
[514,"August 2019","Awst 2019"]
[515,"May 2018","Mai 2018"]
[516,"August 2018","Awst 2018"]
[700,"Prevention of Homelessness by Area and Measure (Section 66)","Prevention of Homelessness by Area and Measure (Section 66)"]
[701,"Number of outcomes - Eligible, homeless, subject to duty to help to secure (Section 73)","Number of outcomes - Eligible, homeless, subject to duty to help to secure (Section 73)"]
[702,"Total number of households on Universal Credit (with housing entitlement and receiving payment) ","Cyfanswm nifer yr aelwydydd ar Gredyd Cynhwysol (gyda hawl i dai a derbyn taliad) "]
[703," Total number of households receiving housing benefit","Cyfanswm nifer yr aelwydydd sy'n derbyn budd-dal tai"]

{"sheet":"queryformround1","index":2,"n_rows":179,"n_cols":11,"rows_kept":179,"merged":[[5,2,5,8],[6,2,6,8],[7,2,7,8],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[35,8,37,8],[91,3,92,3],[116,8,121,8],[122,2,123,2],[124,2,173,2],[124,3,148,3],[149,3,173,3]]}
[2,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A1,Text!A3:C316,2),VLOOKUP(A1,Text!A3:C318,3))","v":"Proses gwiriad data cylch 1"}]
[]
[3,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A3,Text!A3:C316,2),VLOOKUP(A3,Text!A3:C318,3))","v":"Dewiswch enw eich awdurdod:"}]
[]
[]
[15,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A6,Text!A3:C316,2),VLOOKUP(A6,Text!A3:C318,3))","v":"Defnyddir y data heb fod yn ariannol, a gasglwyd yn wreiddiol gan Awdurdodau Lleol, i gyfrifo Asesiadau o Wariant Safonol (SSAs) yn y Setliad Llywodraeth Leol. "}]
[16,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A7,Text!A3:C316,2),VLOOKUP(A7,Text!A3:C318,3))","v":"Mae'r data hyn eisoes wedi bod drwy amryw o brosesau sicrhau ansawdd a gwirio cyn iddynt gael eu cyhoeddi."}]
[17,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A8,Text!A3:C316,2),VLOOKUP(A8,Text!A3:C318,3))","v":"Ni ddylid defnyddio’r broses wirio hon i roi sylw i amcangyfrifon sydd wedi eu cyhoeddi os yw’r newidiadau dan sylw yn rhai mân. Yn hytrach, nod y broses yw sicrhau bod unrhyw gamgymeriadau sylweddol yn y data heb fod yn ariannol, neu newidiadau o bwys iddynt, yn cael eu nodi cyn cyhoeddi'r Setliad Llywodraeth Leol. "}]
[]
[18,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A10,Text!$A$3:$C$402,2,0),VLOOKUP(A10,Text!$A$3:$C$402,3,0))","v":"Ffurflen ymholiadau ar gyfer sylwadau ar y data"}]
[]
[{"$nulls":4},20,21,22,23,25]
[19,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A13,Text!$A$3:$C$402,2,0),VLOOKUP(A13,Text!$A$3:$C$402,3,0))","v":"Pwnc"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A14,Text!$A$3:$C$402,2,0),VLOOKUP(#REF!,Text!$A$3:$C$402,3,0))","v":{"$error":"#REF!"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(E12,Text!$A$3:$C$402,2,0),VLOOKUP(E12,Text!$A$3:$C$402,3,0))","v":"Pwynt data"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(F12,Text!$A$3:$C$402,2,0),VLOOKUP(F12,Text!$A$3:$C$402,3,0))","v":"Ffigur gwiriad"},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(G12,Text!A3:C316,2),VLOOKUP(G12,Text!A3:C318,3))","v":"Ystorfa Ddata"},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(H12,Text!A3:C316,2),VLOOKUP(H12,Text!A3:C318,3))","v":"Ffigur diwygiedig"},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(I12,Text!A3:C316,2),VLOOKUP(I12,Text!A3:C318,3))","v":"Sylwadau/Ymholiadau"},24]
[9,{"$nulls":6},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(J13,Text!A3:C316,2),VLOOKUP(J13,Text!A3:C318,3))","v":"Dim ond os cytunwyd gan yr ystorfa ddata"},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(J14,Text!A3:C316,2),VLOOKUP(J14,Text!A3:C318,3))","v":"Os ydych chi wedi cael cytundeb yr ystorfa ddata berthnasol i ddiwygio eich data cyhoeddedig, rhowch fanylion "},26]
[38,51,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A15,Text!$A$3:$C$402,2,0),VLOOKUP(A15,Text!$A$3:$C$402,3,0))","v":"CEISIADAU CYNLLUNIO"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B15,Text!$A$3:$C$402,2,0),VLOOKUP(B15,Text!$A$3:$C$402,3,0))","v":"Ceisiadau Cynllunio a Gafwyd"},{"$f":"'2026-27 Settlement data'!D7","v":"2024-06-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K15,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A17,Text!A3:C316,2),VLOOKUP(A17,Text!A3:C318,3))","v":"Llywodraeth Cymru"},null,null,109,3]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!E7","v":"2024-09-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K16,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},110,4]
[29,{"$nulls":3},{"$f":"'2026-27 Settlement data'!F7","v":"2024-12-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K17,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},111,5]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!G7","v":"2025-03-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K18,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},112,6]
[42,64,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A19,Text!$A$3:$C$402,2,0),VLOOKUP(A19,Text!$A$3:$C$402,3,0))","v":"STOC ANHEDDAU'R SECTOR PREIFAT"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B19,Text!$A$3:$C$402,2,0),VLOOKUP(B19,Text!$A$3:$C$402,3,0))","v":"Yn eiddo i berchen-feddianwyr, wedi'u rhentu'n breifat, deiliadaeth ganolradd a deiliadaethau eraill"},{"$f":"VLOOKUP(0,#REF!,K19,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(Text!$F$130,#REF!,$K19,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A17,Text!A3:C316,2),VLOOKUP(A17,Text!A3:C318,3))","v":"Llywodraeth Cymru"},null,"Do not verify ",null,{"$f":"K18+1","v":7}]
[43,65,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A20,Text!$A$3:$C$402,2,0),VLOOKUP(A20,Text!$A$3:$C$402,3,0))","v":"ARWYNEBEDD TIR"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B20,Text!$A$3:$C$402,2,0),VLOOKUP(B20,Text!$A$3:$C$402,3,0))","v":"Arwynebedd mewn hectarau"},{"$f":"'2026-27 Settlement data'!I7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K20,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A17,Text!A3:C316,2),VLOOKUP(A17,Text!A3:C318,3))","v":"Llywodraeth Cymru"},null,null,113,{"$f":"K19+1","v":8}]
[44,66,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A21,Text!$A$3:$C$402,2,0),VLOOKUP(A21,Text!$A$3:$C$402,3,0))","v":"DATA POBLOGAETH"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B21,Text!$A$3:$C$402,2,0),VLOOKUP(B21,Text!$A$3:$C$402,3,0))","v":"Cyfanswm y boblogaeth"},{"$f":"'2026-27 Settlement data'!J7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K21,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A17,Text!A3:C316,2),VLOOKUP(A17,Text!A3:C318,3))","v":"Llywodraeth Cymru"},null,null,99,{"$f":"K20+1","v":9}]
[null,68,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B22,Text!$A$3:$C$402,2,0),VLOOKUP(B22,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 3 oed "},{"$f":"'2026-27 Settlement data'!K7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K22,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},10]
[null,69,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B23,Text!$A$3:$C$402,2,0),VLOOKUP(B23,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 3 i 11 oed"},{"$f":"'2026-27 Settlement data'!L7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K23,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},11]
[null,70,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B24,Text!$A$3:$C$402,2,0),VLOOKUP(B24,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 3 i 16 oed "},{"$f":"'2026-27 Settlement data'!M7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K24,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},12]
[null,71,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B25,Text!$A$3:$C$402,2,0),VLOOKUP(B25,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 11 i 15 oed "},{"$f":"'2026-27 Settlement data'!N7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K25,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},13]
[null,72,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B26,Text!$A$3:$C$402,2,0),VLOOKUP(B26,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 11 i 20 oed "},{"$f":"'2026-27 Settlement data'!O7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K26,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},14]
[null,73,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B27,Text!$A$3:$C$402,2,0),VLOOKUP(B27,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 16 oed a throsodd "},{"$f":"'2026-27 Settlement data'!P7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K27,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},15]
[null,74,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B28,Text!$A$3:$C$402,2,0),VLOOKUP(B28,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 16 i 18 oed "},{"$f":"'2026-27 Settlement data'!Q7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K28,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},16]
[null,75,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B29,Text!$A$3:$C$402,2,0),VLOOKUP(B29,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 0 i 17 oed "},{"$f":"'2026-27 Settlement data'!R7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K29,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},17]
[null,76,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B30,Text!$A$3:$C$402,2,0),VLOOKUP(B30,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 18 i 64 oed "},{"$f":"'2026-27 Settlement data'!S7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K30,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},18]
[null,77,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B31,Text!$A$3:$C$402,2,0),VLOOKUP(B31,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 18 oed a throsodd "},{"$f":"'2026-27 Settlement data'!T7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K31,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},19]
[null,78,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B32,Text!$A$3:$C$402,2,0),VLOOKUP(B32,Text!$A$3:$C$402,3,0))","v":"Poblogaeth o dan 60 oed "},{"$f":"'2026-27 Settlement data'!U7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K32,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},20]
[null,79,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B33,Text!$A$3:$C$402,2,0),VLOOKUP(B33,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 60 oed a throsodd"},{"$f":"'2026-27 Settlement data'!V7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K33,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},21]
[null,80,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B34,Text!$A$3:$C$402,2,0),VLOOKUP(B34,Text!$A$3:$C$402,3,0))","v":"Poblogaeth 85 oed a throsodd "},{"$f":"'2026-27 Settlement data'!W7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K34,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},22]
[null,81,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B35,Text!$A$3:$C$402,2,0),VLOOKUP(B35,Text!$A$3:$C$402,3,0))","v":"Poblogaeth oedran gweithio (16-65G/B) "},{"$f":"'2026-27 Settlement data'!X7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K35,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},23]
[45,82,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A36,Text!$A$3:$C$402,2,0),VLOOKUP(A36,Text!$A$3:$C$402,3,0))","v":"DATA AMCANGYFRIFON POBLOGAETH"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B36,Text!$A$3:$C$402,2,0),VLOOKUP(B36,Text!$A$3:$C$402,3,0))","v":"Amcangyfrifon Poblogaeth Ganol Blwyddyn, pob oed"},{"$f":"'2026-27 Settlement data'!N18","v":"1930-10-13"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K36,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!K1=2,VLOOKUP(A17,Text!A3:C316,2),VLOOKUP(A17,Text!A3:C318,3))","v":"Llywodraeth Cymru"},{"$nulls":3},24]
[null,83,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B37,Text!$A$3:$C$402,2,0),VLOOKUP(B37,Text!$A$3:$C$402,3,0))","v":"Amcangyfrifon Poblogaeth Ganol Blwyddyn, 18 oed a throsodd"},{"$f":"'2026-27 Settlement data'!N19","v":"1939-06-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K37,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},25]
[null,84,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B38,Text!$A$3:$C$402,2,0),VLOOKUP(B38,Text!$A$3:$C$402,3,0))","v":"Amcangyfrifon Poblogaeth Ganol Blwyddyn, 65 oed a throsodd"},{"$f":"'2026-27 Settlement data'!N20","v":"1923-04-29"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K38,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},26]
[46,85,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A39,Text!$A$3:$C$402,2,0),VLOOKUP(A39,Text!$A$3:$C$402,3,0))","v":"DATA TAI - CYLLID CYFALAF CYFFREDINOL"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B39,Text!$A$3:$C$402,2,0),VLOOKUP(B39,Text!$A$3:$C$402,3,0))","v":"Swm a wariwyd ar grantiau cyfleusterau i'r anabl wedi'u cwblhau (£s)"},{"$f":"'2026-27 Settlement data'!N21","v":"1924-03-19"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K39,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J39,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J39,Text!$A$4:$C$198,3,FALSE))","v":"Llywodraeth Cymru"},null,"Do not verify ",29,27]
[47,87,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A40,Text!$A$3:$C$402,2,0),VLOOKUP(A40,Text!$A$3:$C$402,3,0))","v":"PRAESEPTAU DRAENIO TIR"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B40,Text!$A$3:$C$402,2,0),VLOOKUP(B40,Text!$A$3:$C$402,3,0))","v":"Ardollau arbennig gan Fyrddau Draenio Mewnol"},{"$f":"'2026-27 Settlement data'!N22","v":"1923-09-16"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K40,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J40,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J40,Text!$A$4:$C$198,3,FALSE))","v":"Llywodraeth Cymru"},null,null,29,28]
[48,88,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A41,Text!$A$3:$C$402,2,0),VLOOKUP(A41,Text!$A$3:$C$402,3,0))","v":"HYD YR ARFORDIR A WARCHODIR"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B41,Text!$A$3:$C$402,2,0),VLOOKUP(B41,Text!$A$3:$C$402,3,0))","v":"Hyd (km)"},{"$f":"'2026-27 Settlement data'!N23","v":"1940-09-18"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K41,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J41,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J41,Text!$A$4:$C$198,3,FALSE))","v":"Llywodraeth Cymru"},null,null,29,29]
[49,89,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A42,Text!$A$3:$C$402,2,0),VLOOKUP(A42,Text!$A$3:$C$402,3,0))","v":"FFERMYDD"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B42,Text!$A$3:$C$402,2,0),VLOOKUP(B42,Text!$A$3:$C$402,3,0))","v":"Nifer y ffermydd economaidd weithgar"},{"$f":"'2026-27 Settlement data'!N24","v":"1910-01-04"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K42,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J42,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J42,Text!$A$4:$C$198,3,FALSE))","v":"Llywodraeth Cymru"},null,null,29,30]
[144,145,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A43,Text!$A$3:$C$402,2,0),VLOOKUP(A43,Text!$A$3:$C$402,3,0))","v":"EIDDO MASNACHU"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B43,Text!$A$3:$C$402,2,0),VLOOKUP(B43,Text!$A$3:$C$402,3,0))","v":"Nifer yr Eiddo Masnachu"},{"$f":"'2026-27 Settlement data'!N25","v":"1929-12-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K43,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J44,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J44,Text!$A$4:$C$198,3,FALSE))","v":"Asiantaeth y Swyddfa Brisio"},null,null,115,31]
[146,147,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A44,Text!$A$3:$C$402,2,0),VLOOKUP(A44,Text!$A$3:$C$402,3,0))","v":"EIDDO BWYD"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B44,Text!$A$3:$C$402,2,0),VLOOKUP(B44,Text!$A$3:$C$402,3,0))","v":"Nifer yr Eiddo Bwyd"},{"$f":"'2026-27 Settlement data'!N26","v":"1910-11-24"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K44,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J44,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J44,Text!$A$4:$C$198,3,FALSE))","v":"Asiantaeth y Swyddfa Brisio"},null,null,153,32]
[154,143,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A45,Text!$A$3:$C$402,2,0),VLOOKUP(A45,Text!$A$3:$C$402,3,0))","v":"UNEDAU GOLEUADAU STRYD"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B45,Text!$A$3:$C$402,2,0),VLOOKUP(B45,Text!$A$3:$C$402,3,0))","v":"Cyfanswm yr unedau goleuadau stryd"},{"$f":"'2026-27 Settlement data'!AH7","v":"2025-04-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K45,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J45,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J45,Text!$A$4:$C$198,3,FALSE))","v":"Llywodraeth Cymru"},null,null,29,33]
[148,149,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A46,Text!$A$3:$C$402,2,0),VLOOKUP(A46,Text!$A$3:$C$402,3,0))","v":"DATA MARWOLAETHAU"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B46,Text!$A$3:$C$402,2,0),VLOOKUP(B46,Text!$A$3:$C$402,3,0))","v":"Nifer y marwolaethau wedi'u cofrestru"},{"$f":"'2026-27 Settlement data'!AI7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K46,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J46,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J46,Text!$A$4:$C$198,3,FALSE))","v":"Y Swyddfa Ystadegau Gwladol"},null,null,158,34]
[150,151,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A47,Text!$A$3:$C$402,2,0),VLOOKUP(A47,Text!$A$3:$C$402,3,0))","v":"DATA CYNLLUNIAU GOSTYNGIADAU'R DRETH GYNGOR "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B47,Text!$A$3:$C$402,2,0),VLOOKUP(B47,Text!$A$3:$C$402,3,0))","v":"Llwyth achosion Cynlluniau Gostyngiadau'r Dreth Gyngor "},{"$f":"'2026-27 Settlement data'!AJ7","v":"2023-24"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K47,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J47,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J47,Text!$A$4:$C$198,3,FALSE))","v":"Llywodraeth Cymru"},null,null,29,35]
[null,152,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B48,Text!$A$3:$C$402,2,0),VLOOKUP(B48,Text!$A$3:$C$402,3,0))","v":"Gwariant Cynlluniau Gostyngiadau'r Dreth Gyngor"},{"$f":"'2026-27 Settlement data'!AK7","v":"2023-24"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K48,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},36]
[null,152.5,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B49,Text!$A$3:$C$402,2,0),VLOOKUP(B49,Text!$A$3:$C$402,3,0))","v":"Cefnogaeth CTRS Covid-19 "},{"$f":"VLOOKUP(0,#REF!,K49,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(Text!$F$130,#REF!,$K49,FALSE)","v":{"$error":"#REF!"}},{"$nulls":4},37]
[159,160,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A50,Text!$A$3:$C$402,2,0),VLOOKUP(A50,Text!$A$3:$C$402,3,0))","v":"LLONGAU SY'N CYRRAEDD PORTHLADDOEDD"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B50,Text!$A$3:$C$402,2,0),VLOOKUP(B50,Text!$A$3:$C$402,3,0))","v":"Nifer y llongau sy'n cyrraedd porthladdoedd"},{"$f":"'2026-27 Settlement data'!AM7","v":"2024"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K50,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J50,Text!$A$4:$C$558,2,FALSE),VLOOKUP(J50,Text!$A$4:$C$558,3,FALSE))","v":"Ystadegau morol a llongau, Yr Adran Drafnidiaeth"},null,null,272,38]
[161,162,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A51,Text!$A$3:$C$402,2,0),VLOOKUP(A51,Text!$A$3:$C$402,3,0))","v":"DATA TWRISTIAETH"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B51,Text!$A$3:$C$402,2,0),VLOOKUP(B51,Text!$A$3:$C$402,3,0))","v":"Nosweithiau twristiaid (miloedd) gan gynnwys AirBnb"},{"$f":"VLOOKUP(0,#REF!,K51,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K51,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J51,Text!$A$4:$C$198,2,FALSE),VLOOKUP(J51,Text!$A$4:$C$198,3,FALSE))","v":"Scarborough Tourism Economic Activity Monitor (STEAM) "},null,null,164,39]
[null,163,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B52,Text!$A$3:$C$402,2,0),VLOOKUP(B52,Text!$A$3:$C$402,3,0))","v":"Diwrnodau twristiaid (miloedd)"},{"$f":"VLOOKUP(0,#REF!,K52,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K52,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},40]
[165,166,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A53,Text!$A$3:$C$402,2,0),VLOOKUP(A53,Text!$A$3:$C$402,3,0))","v":"DATA AR GANRAN YR HAWLWYR BUDD-DAL DIWEITHDRA"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B53,Text!$A$3:$C$402,2,0),VLOOKUP(B53,Text!$A$3:$C$402,3,0))","v":"Nifer yr hawlwyr"},{"$f":"'2026-27 Settlement data'!AP7","v":"2024-10-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K53,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B54,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B54,Text!$A$4:$C$198,3,FALSE))","v":"NOMIS ystadegau swyddogol y farchnad lafur"},null,null,167,41]
[null,209,null,null,{"$f":"'2026-27 Settlement data'!AQ7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K54,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"J53+1","v":168},42]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AR7","v":"2024-12-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K55,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},169,43]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AS7","v":"2025-01-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K56,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},170,44]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AT7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K57,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},171,45]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AU7","v":"2025-03-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K58,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},172,46]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AV7","v":"2025-04-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K59,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},173,47]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AW7","v":"2025-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K60,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},174,48]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AX7","v":"2025-06-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K61,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},175,49]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AY7","v":"2025-07-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K62,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},176,50]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!AZ7","v":"2025-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K63,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},177,51]
[179,194,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A64,Text!$A$3:$C$402,2,0),VLOOKUP(A64,Text!$A$3:$C$402,3,0))","v":"DATA AR HAWLWYR BUDD-DALIADAU"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B64,Text!$A$3:$C$402,2,0),VLOOKUP(B64,Text!$A$3:$C$402,3,0))","v":"Nifer yr Hawlwyr Cymhorthdal Incwm, 18-64 oed"},{"$f":"'2026-27 Settlement data'!BA7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K64,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B65,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B65,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,52]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!BB7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K65,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,53]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BC7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K66,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,54]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BD7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K67,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,55]
[null,195,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B68,Text!$A$3:$C$402,2,0),VLOOKUP(B68,Text!$A$3:$C$402,3,0))","v":"Nifer y Derbynwyr Lwfans Ceisio Swydd ar Sail Incwm, 18-64 oed"},{"$f":"'2026-27 Settlement data'!BE7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K68,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B69,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B69,Text!$A$4:$C$198,3,FALSE))","v":"NOMIS ystadegau swyddogol y farchnad lafur"},null,null,114,56]
[null,209,null,null,{"$f":"'2026-27 Settlement data'!BF7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K69,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,57]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BG7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K70,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,58]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BH7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K71,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,59]
[null,196,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B72,Text!$A$3:$C$402,2,0),VLOOKUP(B72,Text!$A$3:$C$402,3,0))","v":"Nifer yr hawlwyr Credyd Pensiwn, 18-64 oed"},{"$f":"'2026-27 Settlement data'!BI7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K72,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B73,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B73,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,60]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!BJ7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K73,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,61]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BK7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K74,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,62]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BL7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K75,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,63]
[null,197,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B76,Text!$A$3:$C$402,2,0),VLOOKUP(B76,Text!$A$3:$C$402,3,0))","v":"Nifer y rhai sydd yn derbyn Credyd Cynhwysol (ddim mewn cyflogaeth) 18-64 oed"},{"$f":"'2026-27 Settlement data'!BM7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K76,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B77,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B77,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,64]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!BN7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K77,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,65]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BO7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K78,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,66]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BP7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K79,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,67]
[null,198,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B80,Text!$A$3:$C$402,2,0),VLOOKUP(B80,Text!$A$3:$C$402,3,0))","v":"Cyfanswm yr Hawlwyr Cymhorthdal Incwm"},{"$f":"'2026-27 Settlement data'!BQ7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K80,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B81,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B81,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,68]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!BR7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K81,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,69]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BS7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K82,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,70]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BT7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K83,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,71]
[null,199,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B84,Text!$A$3:$C$402,2,0),VLOOKUP(B84,Text!$A$3:$C$402,3,0))","v":"Cyfanswm y Derbynwyr Lwfans Ceisio Swydd ar Sail Incwm"},{"$f":"'2026-27 Settlement data'!BU7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K84,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B85,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B85,Text!$A$4:$C$198,3,FALSE))","v":"NOMIS ystadegau swyddogol y farchnad lafur"},null,null,114,{"$f":"K83+1","v":72}]
[null,209,null,null,{"$f":"'2026-27 Settlement data'!BV7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K85,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,73]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BW7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K86,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,74]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!BX7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K87,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,75]
[null,200,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B88,Text!$A$3:$C$402,2,0),VLOOKUP(B88,Text!$A$3:$C$402,3,0))","v":"Cyfanswm Hawlwyr Credyd Pensiwn"},{"$f":"'2026-27 Settlement data'!BY7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K88,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B89,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B89,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,76]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!BZ7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K89,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,77]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CA7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K90,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,78]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CB7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K91,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,79]
[null,201,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B92,Text!$A$3:$C$402,2,0),VLOOKUP(B92,Text!$A$3:$C$402,3,0))","v":"Cyfanswm y rhai sy’n derbyn Credyd Cynhwysol (ddim mewn cyflogaeth)"},{"$f":"'2026-27 Settlement data'!CC7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K92,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B93,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B93,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,80]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!CD7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K93,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,81]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CE7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K94,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,82]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CF7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K95,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,83]
[null,202,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B96,Text!$A$3:$C$402,2,0),VLOOKUP(B96,Text!$A$3:$C$402,3,0))","v":"Nifer yr Hawlwyr Lwfans Anabledd Difrifol, 18-64 oed"},{"$f":"'2026-27 Settlement data'!CG7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K96,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B97,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B97,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,84]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!CH7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K97,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,85]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CI7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K98,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,86]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CJ7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K99,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,87]
[null,203,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B100,Text!$A$3:$C$402,2,0),VLOOKUP(B100,Text!$A$3:$C$402,3,0))","v":"Nifer yr Hawlwyr Lwfans Byw i'r Anabl, 18-64 oed"},{"$f":"'2026-27 Settlement data'!CK7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K100,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B101,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B101,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,88]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!CL7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K101,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,89]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CM7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K102,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,90]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CN7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K103,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,91]
[null,204,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B104,Text!$A$3:$C$402,2,0),VLOOKUP(B104,Text!$A$3:$C$402,3,0))","v":"Nifer yr Hawlwyr Taliad Annibyniaeth Bersonol sydd yn 18-64 oed"},{"$f":"'2026-27 Settlement data'!CO7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K104,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B105,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B105,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,92]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!CP7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K105,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,93]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CQ7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K106,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,94]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CR7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K107,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,95]
[null,205,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B108,Text!$A$3:$C$402,2,0),VLOOKUP(B108,Text!$A$3:$C$402,3,0))","v":"Hawlwyr Credyd Pensiwn, 65 oed a hŷn "},{"$f":"'2026-27 Settlement data'!CS7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K108,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B109,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B109,Text!$A$4:$C$198,3,FALSE))","v":"Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,96]
[null,208,null,null,{"$f":"'2026-27 Settlement data'!CT7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K109,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,97]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CU7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K110,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,98]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CV7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K111,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,99]
[null,206,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B112,Text!$A$3:$C$402,2,0),VLOOKUP(B112,Text!$A$3:$C$402,3,0))","v":"Cyfanswn yr hawlwyr Cymhorthdal Incwm, Lwfans Ceisio Gwaith, a Chredyd Pensiwn"},{"$f":"'2026-27 Settlement data'!CW7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K112,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B113,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B113,Text!$A$4:$C$198,3,FALSE))","v":"NOMIS ystadegau swyddogol y farchnad lafur a Yr Adran Gwaith a Phensiynau (DWP)"},null,null,114,100]
[null,210,null,null,{"$f":"'2026-27 Settlement data'!CX7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K113,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},182,101]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CY7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K114,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},185,102]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!CZ7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K115,FALSE)","v":{"$error":"#N/A"}},{"$nulls":3},188,103]
[271.5,274,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A116,Text!$A$3:$C$402,2,0),VLOOKUP(A116,Text!$A$3:$C$402,3,0))","v":"Stoc eiddo treth cyngor"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A116,Text!$A$3:$C$402, 2, 0),VLOOKUP(A116,Text!$A$3:$C$402, 3,0))","v":"Stoc eiddo treth cyngor"},{"$f":"'2026-27 Settlement data'!DA7","v":"2025-03-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K116,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B116,Text!$A$4:$C$198,2,FALSE),VLOOKUP(B116,Text!$A$4:$C$198,3,FALSE))","v":"Asiantaeth y Swyddfa Brisio"},null,null,115,104]
[40,53,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A117,Text!$A$3:$C$402,2,0),VLOOKUP(A117,Text!$A$3:$C$402,3,0))","v":"DATA FFYRDD "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A117,Text!$A$3:$C$402, 2, 0),VLOOKUP(A117,Text!$A$3:$C$402, 3,0))","v":"DATA FFYRDD "},"April 2024",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K117,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A118,Text!$A$4:$C$198,2,FALSE),VLOOKUP(A118,Text!$A$4:$C$198,3,FALSE))","v":"Llywodraeth Cymru"},{"$nulls":3},105]
[29,55,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A118,Text!$A$3:$C$402, 2, 0),VLOOKUP(A118,Text!$A$3:$C$402, 3,0))","v":"Llywodraeth Cymru"},null,{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K118,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},106]
[null,57,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A119,Text!$A$3:$C$402, 2, 0),VLOOKUP(A119,Text!$A$3:$C$402, 3,0))","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K119,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},107]
[null,54,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A120,Text!$A$3:$C$402, 2, 0),VLOOKUP(A120,Text!$A$3:$C$402, 3,0))","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K120,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},108]
[null,56,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A121,Text!$A$3:$C$402, 2, 0),VLOOKUP(A121,Text!$A$3:$C$402, 3,0))","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K121,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},109]
[null,58,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A122,Text!$A$3:$C$402, 2, 0),VLOOKUP(A122,Text!$A$3:$C$402, 3,0))","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$DG$30,$K122,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},110]
[700,null,"Homelessness decisions",{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A123,Text!$A$3:$C$402, 2, 0),VLOOKUP(A123,Text!$A$3:$C$402, 3,0))","v":"Prevention of Homelessness by Area and Measure (Section 66)"},{"$f":"'2026-27 Settlement data'!DH7","v":"2024-25"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K123,FALSE)","v":{"$error":"#N/A"}},"Welsh Government ",{"$nulls":3},111]
[701,null,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A124,Text!$A$3:$C$402, 2, 0),VLOOKUP(A124,Text!$A$3:$C$402, 3,0))","v":"Number of outcomes - Eligible, homeless, subject to duty to help to secure (Section 73)"},{"$f":"'2026-27 Settlement data'!DI7","v":"2024-25"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K124,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},112]
[702,null,"Housing Benefit Data",{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A125,Text!$A$3:$C$402, 2, 0),VLOOKUP(A125,Text!$A$3:$C$402, 3,0))","v":"Cyfanswm nifer yr aelwydydd ar Gredyd Cynhwysol (gyda hawl i dai a derbyn taliad) "},{"$f":"'2026-27 Settlement data'!DJ7","v":"2023-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K125,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},113]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DK7","v":"2023-06-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K126,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},114]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DL7","v":"2023-07-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K127,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},115]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DM7","v":"2023-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K128,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},116]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DN7","v":"2023-09-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K129,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},117]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DO7","v":"2023-10-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K130,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},118]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DP7","v":"2023-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K131,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},119]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DQ7","v":"2023-12-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K132,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},120]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DR7","v":"2024-01-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K133,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},121]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DS7","v":"2024-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K134,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},122]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DT7","v":"2024-03-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K135,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},123]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DU7","v":"2024-04-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K136,FALSE)","v":{"$error":"#N/A"}},"Welsh Government ",{"$nulls":3},124]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DV7","v":"2024-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K137,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},125]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DW7","v":"2024-06-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K138,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},126]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DX7","v":"2024-07-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K139,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},127]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DY7","v":"2024-08-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K140,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},128]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!DZ7","v":"2024-09-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K141,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},129]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!EA7","v":"2024-10-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K142,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},130]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!EB7","v":"2024-11-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K143,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},131]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!EC7","v":"2024-12-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K144,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},132]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!ED7","v":"2025-01-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K145,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},133]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!EE7","v":"2025-02-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K146,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},134]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!EF7","v":"2025-03-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K147,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},135]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!EG7","v":"2025-04-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K148,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},{"$f":"K147+1","v":136}]
[{"$nulls":4},{"$f":"'2026-27 Settlement data'!EH7","v":"2025-05-01"},{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K149,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},137]
[703,null,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A150,Text!$A$3:$C$402, 2, 0),VLOOKUP(A150,Text!$A$3:$C$402, 3,0))","v":"Cyfanswm nifer yr aelwydydd sy'n derbyn budd-dal tai"},"2023-05-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K150,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},138]
[{"$nulls":4},"2023-06-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K151,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},139]
[{"$nulls":4},"2023-07-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K152,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},140]
[{"$nulls":4},"2023-08-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K153,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},141]
[{"$nulls":4},"2023-09-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K154,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},142]
[{"$nulls":4},"2023-10-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K155,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},143]
[{"$nulls":4},"2023-11-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K156,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},144]
[{"$nulls":4},"2023-12-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K157,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},145]
[{"$nulls":4},"2024-01-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K158,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},146]
[{"$nulls":4},"2024-02-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K159,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},147]
[{"$nulls":4},"2024-03-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K160,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},148]
[{"$nulls":4},"2024-04-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K161,FALSE)","v":{"$error":"#N/A"}},"Welsh Government ",{"$nulls":3},149]
[{"$nulls":4},"2024-05-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K162,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},150]
[{"$nulls":4},"2024-06-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K163,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},151]
[{"$nulls":4},"2024-07-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K164,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},152]
[{"$nulls":4},"2024-08-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K165,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},153]
[{"$nulls":4},"2024-09-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K166,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},154]
[{"$nulls":4},"2024-10-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K167,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},155]
[{"$nulls":4},"2024-11-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K168,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},156]
[{"$nulls":4},"2024-12-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K169,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},157]
[{"$nulls":4},"2025-01-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K170,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},158]
[{"$nulls":4},"2025-02-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K171,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},159]
[{"$nulls":4},"2025-03-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K172,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},160]
[{"$nulls":4},"2025-04-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K173,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},161]
[{"$nulls":4},"2025-05-01",{"$f":"VLOOKUP(Text!$F$130,'2026-27 Settlement data'!$B$9:$FG$30,$K174,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},162]
[]
[]
[27,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A177,Text!$A$3:$C$339,2,0),VLOOKUP(A177,Text!$A$3:$C$339,3,0))","v":"Yr Is-adran Polisi Cyllid Llywodraeth Leol a Chynaliadwyedd, Llywodraeth Cymru"}]
[]
[28,271,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A179,Text!$A$3:$C$339,2,0),VLOOKUP(A179,Text!$A$3:$C$339,3,0))","v":"I'w ddychwelyd drwy e-bost i:"},"LGFPSettlement@gov.wales"]

{"sheet":"2026-27 Settlement data","index":3,"n_rows":41,"n_cols":163,"rows_kept":41,"hidden":true,"merged":[[5,3,5,6],[5,41,5,51],[5,52,5,55],[5,56,5,59],[5,60,5,63],[5,64,5,67],[5,68,5,71],[5,72,5,75],[5,76,5,79],[5,80,5,83],[5,84,5,87],[5,88,5,91],[5,92,5,95],[5,96,5,99],[5,100,5,103],[5,113,5,137],[5,138,5,162]]}
[null,600,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(B1,Text!$A$1:$C$353,2,FALSE),VLOOKUP(B1,Text!$A$1:$C$353,3,FALSE))","v":"Proses wirio data Cylch 1 - data i'w defnyddio ar gyfer Setliad 2026-27"}]
[]
[{"$nulls":3},51,{"$nulls":3},61,62,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,86,90,91,92,145,147,143,149,151,152,152.5,160,162,163,192,{"$nulls":10},194,{"$nulls":3},195,{"$nulls":3},196,{"$nulls":3},197,{"$nulls":3},198,{"$nulls":3},199,{"$nulls":3},200,{"$nulls":3},201,{"$nulls":3},202,{"$nulls":3},203,{"$nulls":3},204,{"$nulls":3},205,{"$nulls":3},206,{"$nulls":3},271.5,53,55,57,54,56,58]
[{"$nulls":3},601,{"$f":"D4+1","v":602},{"$f":"E4+1","v":603},{"$f":"F4+1","v":604},{"$f":"G4+1","v":605},605,{"$nulls":20},605,null,604,604,606,{"$nulls":7},607,{"$f":"AP4+1","v":608},{"$f":"AQ4+1","v":609},{"$f":"AR4+1","v":610},{"$f":"AS4+1","v":611},604,606,605,612,{"$f":"AX4+1","v":613},{"$f":"AY4+1","v":614},615,616,608,611,{"$f":"BA4","v":615},616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,615,616,608,611,{"$f":"G4","v":604},604,604,604,604,604,604]
[]
[{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(D3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(D3,Text!$A$3:$C$353,3,FALSE))","v":"Ceisiadau Cynllunio a Gafwyd"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(H3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(H3,Text!$A$3:$C$353,3,FALSE))","v":"Stoc anheddau'r sector preifat"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(I3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(I3,Text!$A$3:$C$353,3,FALSE))","v":"Arwynebedd tir (hectarau)"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(J3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(J3,Text!$A$3:$C$353,3,FALSE))","v":"Cyfanswm y boblogaeth"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(K3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(K3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 3 oed "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(L3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(L3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 3 i 11 oed"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(M3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(M3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 3 i 16 oed "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(N3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(N3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 11 i 15 oed "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(O3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(O3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 11 i 20 oed "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(P3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(P3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 16 oed a throsodd "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(Q3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(Q3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 16 i 18 oed "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(R3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(R3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 0 i 17 oed "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(S3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(S3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 18 i 64 oed "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(T3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(T3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 18 oed a throsodd "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(U3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(U3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth o dan 60 oed "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(V3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(V3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 60 oed a throsodd"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(W3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(W3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth 85 oed a throsodd "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(X3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(X3,Text!$A$3:$C$353,3,FALSE))","v":"Poblogaeth oedran gweithio (16-65G/B) "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(Y3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(Y3,Text!$A$3:$C$353,3,FALSE))","v":"Amcangyfrifon Poblogaeth Ganol Blwyddyn, pob oed"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(Z3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(Z3,Text!$A$3:$C$353,3,FALSE))","v":"Amcangyfrifon Poblogaeth Ganol Blwyddyn, 18 oed a throsodd"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AA3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AA3,Text!$A$3:$C$353,3,FALSE))","v":"Amcangyfrifon Poblogaeth Ganol Blwyddyn, 65 oed a throsodd"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AB3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AB3,Text!$A$3:$C$353,3,FALSE))","v":"Swm a wariwyd ar grantiau cyfleusterau i'r anabl wedi'u cwblhau (£s)"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AC3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AC3,Text!$A$3:$C$353,3,FALSE))","v":"Praeseptau Draenio Tir"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AD3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AD3,Text!$A$3:$C$353,3,FALSE))","v":"Hyd yr arfordir a warchodir"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AE3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AE3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer y Ffermydd"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AF3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AF3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer yr Eiddo Masnachu"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AG3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AG3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer yr Eiddo Bwyd"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AH3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AH3,Text!$A$3:$C$353,3,FALSE))","v":"Cyfanswm yr unedau goleuadau stryd"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AI3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AI3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer y marwolaethau wedi'u cofrestru"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AJ3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AJ3,Text!$A$3:$C$353,3,FALSE))","v":"Llwyth achosion Cynlluniau Gostyngiadau'r Dreth Gyngor "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AK3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AK3,Text!$A$3:$C$353,3,FALSE))","v":"Gwariant Cynlluniau Gostyngiadau'r Dreth Gyngor"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AL3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AL3,Text!$A$3:$C$353,3,FALSE))","v":"Cefnogaeth CTRS Covid-19 "},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AM3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AM3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer y llongau sy'n cyrraedd porthladdoedd"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AN3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AN3,Text!$A$3:$C$353,3,FALSE))","v":"Nosweithiau twristiaid (miloedd) gan gynnwys AirBnb"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AO3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AO3,Text!$A$3:$C$353,3,FALSE))","v":"Diwrnodau twristiaid (miloedd)"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AP3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(AP3,Text!$A$3:$C$353,3,FALSE))","v":"Data Hawlwyr Budd-dal "},{"$nulls":10},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(BA3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(BA3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer yr Hawlwyr Cymhorthdal Incwm, 18-64 oed"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(BE3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(BE3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer y Derbynwyr Lwfans Ceisio Swydd ar Sail Incwm, 18-64 oed"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(BI3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(BI3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer yr hawlwyr Credyd Pensiwn, 18-64 oed"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(BM3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(BM3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer y rhai sydd yn derbyn Credyd Cynhwysol (ddim mewn cyflogaeth) 18-64 oed"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(BQ3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(BQ3,Text!$A$3:$C$353,3,FALSE))","v":"Cyfanswm yr Hawlwyr Cymhorthdal Incwm"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(BU3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(BU3,Text!$A$3:$C$353,3,FALSE))","v":"Cyfanswm y Derbynwyr Lwfans Ceisio Swydd ar Sail Incwm"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(BY3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(BY3,Text!$A$3:$C$353,3,FALSE))","v":"Cyfanswm Hawlwyr Credyd Pensiwn"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(CC3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(CC3,Text!$A$3:$C$353,3,FALSE))","v":"Cyfanswm y rhai sy’n derbyn Credyd Cynhwysol (ddim mewn cyflogaeth)"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(CG3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(CG3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer yr Hawlwyr Lwfans Anabledd Difrifol, 18-64 oed"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(CK3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(CK3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer yr Hawlwyr Lwfans Byw i'r Anabl, 18-64 oed"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(CO3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(CO3,Text!$A$3:$C$353,3,FALSE))","v":"Nifer yr Hawlwyr Taliad Annibyniaeth Bersonol sydd yn 18-64 oed"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(CS3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(CS3,Text!$A$3:$C$353,3,FALSE))","v":"Hawlwyr Credyd Pensiwn, 65 oed a hŷn "},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(CW3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(CW3,Text!$A$3:$C$353,3,FALSE))","v":"Cyfanswn yr hawlwyr Cymhorthdal Incwm, Lwfans Ceisio Gwaith, a Chredyd Pensiwn"},{"$nulls":3},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(DA3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(DA3,Text!$A$3:$C$353,3,FALSE))","v":"Stoc eiddo treth cyngor"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(DB3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(DB3,Text!$A$3:$C$353,3,FALSE))","v":"Hyd ffyrdd A y sir (km)"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(DC3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(DC3,Text!$A$3:$C$353,3,FALSE))","v":"Hyd ffyrdd B ac C (km)"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(DD3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(DD3,Text!$A$3:$C$353,3,FALSE))","v":"Hyd is-ffyrdd â wyneb caled (km)"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(DE3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(DE3,Text!$A$3:$C$353,3,FALSE))","v":"Hyd ffyrdd A y sir, adeiledig (km)"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(DF3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(DF3,Text!$A$3:$C$353,3,FALSE))","v":"Hyd ffyrdd B ac C, adeiledig (km)"},{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(DG3,Text!$A$3:$C$353,2,FALSE),VLOOKUP(DG3,Text!$A$3:$C$353,3,FALSE))","v":"Hyd is-ffyrdd â wyneb caled, adeiledig (km)"},"Prevention of Homelessness by Area and Measure (Section 66)","Number of outcomes - Eligible, homeless, subject to duty to help to secure (Section 73)","Total number of households on Universal Credit (with housing entitlement and receiving payment) ",{"$nulls":24}," Total number of households receiving housing benefit"]
[null,0,null,45444,45536,45627,45717,44986,45413,"2024","2024","2024","2024","2024","2024","2024","2024","2024","2024","2024","2024","2024","2024","2024","2020","2020","2020","2018-19","2024-25",{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(AD$4,Text!$A$1:$C$458,2,FALSE),VLOOKUP(AD$4,Text!$A$1:$C$458,3,FALSE))","v":"Mai 2022"},"2021",45352,45352,45748,"2024","2023-24","2023-24","2021-22","2024","2019","2019",45566,45597,45627,45658,45689,45717,45748,45778,45809,45839,45870,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45413,45505,45597,45689,45717,45383,45383,45383,45383,45383,45383,"2024-25","2024-25",45047,45078,45108,45139,45170,45200,45231,45261,45292,45323,45352,45383,45413,45444,45474,45505,45536,45566,45597,45627,45658,45689,45717,45748,45778,45047,45078,45108,45139,45170,45200,45231,45261,45292,45323,45352,45383,45413,45444,45474,45505,45536,45566,45597,45627,45658,45689,45717,45748,45778]
[]
[117,2,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A9,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A9,Text!$A$3:$C$353,3,FALSE))","v":"Sir Ynys Môn"},181,187,171,205,"N/A",71519.94099999999,69097,595,6423,10553,4174,7408,57709,2236,12927,37221,56170,44624,24473,2455,39817,70440,57101,18639,null,4280.9,7.9,935,3510,1020,9984,934,5554,6029938,"N/A",2661,5514.022396125236,707.4918435630126,1450,1455,1475,1480,1500,1455,1410,1360,1340,1330,1335,132,52,19,8,88,100,78,55,0,0,0,0,3968,4102,4398,4715,131,55,19,13,92,100,77,61,2002,2008,2035,2036,4033,4175,4475,4801,0,0,0,0,63,65,61,60,3639,3730,3819,3861,2002,2008,2035,2036,2225,2163,2131,2110,36210,145.6,484.5,559.1,28.1,59.599999999999994,181.5,84,240,2805,2812,2843,2883,2920,2957,2982,2988,3002,3070,3120,3139,3208,3221,3289,3342,3402,3438,3494,3586,3640,3707,3717,3787,3831,2696,2653,2629,2605,2594,2579,2540,2552,2566,2545,2509,2504,2495,2455,2425,2391,2352,2303,2251,2225,2208,2150,2116,2103,2076]
[118,3,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A10,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A10,Text!$A$3:$C$353,3,FALSE))","v":"Gwynedd"},238,231,287,225,"N/A",254857.43099999998,120813,1026,10534,17218,6697,14648,101819,4093,21618,70968,99195,83867,36946,3840,75130,125171,101957,28562,null,124710.76000000001,20.14,1822,8480,2500,13256,1420,8105,9552887,"N/A",1,20095.71004285075,3836.383671608743,2005,2045,2055,2145,2335,2230,2115,1980,1905,1850,1930,182,70,16,7,105,100,98,93,0,0,0,0,5703,6003,6292,6945,193,77,18,13,105,100,100,93,3318,3310,3384,3373,5771,6068,6377,7075,0,0,0,0,85,84,83,84,5298,5446,5611,5699,3318,3310,3384,3373,3616,3487,3502,3479,62730,341.6,1064.9,1323.3,74.6,104.30000000000001,346.9,51,339,4394,4392,4413,4381,4418,4438,4455,4524,4576,4629,4631,4686,4830,4911,4935,4995,5070,5145,5235,5343,5457,5603,5656,5707,5782,4272,4267,4223,4209,4175,4155,4141,4119,4102,4100,4025,4018,4027,4004,3960,3861,3781,3669,3581,3520,3496,3442,3390,3265,3212]
[119,4,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A11,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A11,Text!$A$3:$C$353,3,FALSE))","v":"Conwy"},207,167,187,178,"N/A",113017.935,114891,974,9937,16353,6407,11707,97038,3645,20348,61992,94543,73024,41867,4428,66362,118184,97000,32938,null,44565.61,23.59,931,5470,2210,16754,1597,9607,11719670,"N/A",31,11135.436688486161,7219.659429750646,2500,2480,2460,2515,2585,2565,2440,2380,2345,2260,2275,229,86,28,13,144,124,114,119,0,0,0,0,6745,6992,7453,8191,229,82,29,13,151,130,118,120,3613,3610,3682,3717,6820,7059,7533,8288,0,0,0,0,110,99,98,93,6567,6712,6823,6914,3613,3610,3682,3717,3993,3822,3829,3850,58460,117.5,666.9,897.3,51.6,102.89999999999999,419.6,294,537,4655,4672,4706,4722,4785,4812,4850,4880,4911,4987,5024,5044,5175,5180,5274,5400,5485,5589,5685,5763,5815,5961,6021,6035,6166,4827,4786,4748,4724,4711,4709,4653,4606,4594,4585,4560,4553,4566,4502,4412,4339,4234,4145,4056,4000,3986,3887,3820,3714,3651]
[120,5,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A12,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A12,Text!$A$3:$C$353,3,FALSE))","v":"Sir Ddinbych"},"-","-","-","-","N/A",83871.492,98202,954,9615,15647,5930,11006,81174,3478,19403,54156,78799,66057,32145,3162,57848,96664,77165,23517,null,null,9.4,761,4010,1630,11759,1313,8830,10841284,"N/A",0,7466.735467847676,4400.806284565748,2085,2105,2075,2110,2205,2170,2105,2035,1975,1980,1935,242,89,31,14,107,113,108,87,0,0,0,0,6491,6760,7206,7834,241,94,29,16,118,117,113,93,3013,3030,3073,3071,6583,6862,7297,7929,0,0,0,0,117,113,104,105,6692,6844,6987,7047,3013,3030,3073,3071,3372,3241,3215,3180,46760,139.8,655.3,623.4,29.7,49.9,222.2,84,354,4450,4432,4472,4515,4529,4559,4550,4618,4638,4693,4698,4715,4822,4916,4966,5042,5117,5203,5291,5389,5483,5617,5685,5742,5836,4299,4297,4262,4262,4245,4240,4224,4174,4162,4157,4145,4125,4120,4073,4025,3960,3773,3702,3636,3572,3521,3428,3343,3227,3164]
[121,6,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A13,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A13,Text!$A$3:$C$353,3,FALSE))","v":"Sir y Fflint"},209,211,206,211,"N/A",43983.083999999995,155867,1555,14981,24557,9409,17657,129034,5648,30746,90669,125121,110348,45519,4151,96615,156847,124648,33294,null,null,2.76,519,5190,1680,21364,1650,10215,12297950,"N/A",1,3924.1983287717267,2929.6085719648577,2705,2690,2545,2640,2720,2750,2730,2645,2680,2700,2765,193,73,19,7,164,160,163,176,0,0,0,0,8633,8990,9245,9798,203,81,22,11,167,168,170,182,3424,3406,3491,3484,8675,9035,9305,9844,0,0,0,0,100,92,89,94,8142,8393,8587,8702,3424,3406,3491,3484,3794,3655,3683,3677,71710,157.4,340.5,690.6,64.1,111.2,435.9,456,633,6302,6303,6303,6325,6359,6423,6444,6478,6543,6607,6640,6694,6828,6874,6919,7009,7094,7170,7238,7330,7434,7567,7653,7690,7800,4622,4588,4573,4563,4442,4505,4402,4437,4448,4452,4423,4412,4400,4377,4301,4199,4104,4027,3901,3832,3869,3782,3791,3730,3649]
[122,7,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A14,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A14,Text!$A$3:$C$353,3,FALSE))","v":"Wrecsam"},203,230,193,259,"N/A",50377.064,138245,1335,13860,22487,8651,16235,113592,4936,28008,81507,110237,100471,37774,3576,86402,136055,107142,27749,null,null,0,459,4040,1430,13194,1501,11064,12365432,"N/A",0,1197.97669333984,1544.2190134067457,2725,2650,2495,2540,2595,2535,2515,2450,2475,2490,2495,268,81,30,14,124,118,106,126,0,0,0,0,8775,9152,9579,10149,269,87,31,16,124,121,106,132,3294,3288,3357,3347,8796,9178,9575,10182,0,0,0,0,123,122,118,116,8249,8505,8755,8909,3294,3288,3357,3347,3687,3496,3494,3495,62070,115.4,513,520.1,30.7,126.4,298.4,180,333,7100,7064,7153,7154,7196,7244,7247,7346,7341,7437,7466,7578,7743,7796,7902,8060,8139,8236,8339,8423,8525,8692,8795,8881,8986,5231,5261,5198,5194,5126,5157,5149,5118,5080,5070,5049,5028,5015,4969,4890,4761,4634,4513,4398,4335,4340,4214,4154,4043,3987]
[123,8,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A15,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A15,Text!$A$3:$C$353,3,FALSE))","v":"Powys"},309,345,321,328,"N/A",519531.00399999996,135059,1112,11611,18824,7109,13359,114718,4301,23306,72782,111753,84912,50147,5039,77936,133030,109186,36801,null,53365.62,0,3913,6820,2510,15563,1648,9083,11106773,"N/A",0,9102.60955724062,3010.7827405707812,2035,2040,2025,2030,2100,2100,2045,1990,1895,1885,1915,163,52,22,10,103,104,96,121,0,0,0,0,5962,6361,6721,7138,169,55,21,11,106,106,100,125,3304,3329,3411,3428,6011,6427,6796,7238,0,0,0,0,88,85,85,78,6109,6273,6412,6455,3304,3329,3411,3428,3579,3490,3532,3564,67070,242.6,2708.2000000000003,2129.1,34.4,114.3,220.6,426,399,4216,4199,4218,4259,4259,4302,4347,4390,4420,4500,4565,4618,4746,4825,4897,4960,5046,5099,5156,5221,5320,5464,5523,5592,5696,4353,4336,4312,4288,4257,4240,4220,4189,4183,4175,4175,4190,4158,4116,4062,4005,3929,3861,3785,3745,3722,3619,3552,3463,3396]
[124,9,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A16,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A16,Text!$A$3:$C$353,3,FALSE))","v":"Sir Ceredigion"},245,195,227,202,"N/A",178836.622,72599,538,5644,9168,3530,9610,62546,2232,11396,42044,61203,47791,24808,2331,44470,72895,60661,18668,null,12037.39,12.92,1961,3900,1390,6843,881,5163,6476459,"N/A",0,7196.841815141547,1576.273821438412,1230,1260,1235,1225,1205,1215,1135,1115,1100,1065,1035,84,25,6,6,51,48,63,63,0,0,0,0,3594,3681,3920,4241,84,25,9,6,55,47,63,62,1801,1808,1856,1873,3655,3743,3981,4319,0,0,0,0,31,31,28,26,3313,3369,3436,3449,1801,1808,1856,1873,1940,1880,1928,1941,36360,158.3,1166.6,828.3,34.4,100.80000000000001,126.7,144,177,2282,2277,2297,2314,2322,2366,2389,2454,2475,2546,2579,2618,2648,2647,2679,2723,2783,2848,2917,2956,3011,3118,3148,3213,3263,2497,2495,2480,2472,2442,2425,2402,2399,2395,2378,2335,2338,2340,2305,2289,2245,2182,2138,2042,1999,1973,1924,1863,1796,1725]
[125,10,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A17,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A17,Text!$A$3:$C$353,3,FALSE))","v":"Sir Benfro"},269,257,214,234,"N/A",161827.986,125761,1081,11464,18844,7290,13636,105310,4255,23329,68476,102432,81779,43982,4279,73265,126751,102744,33169,null,null,12.3,1761,7350,2220,15730,1552,8999,9849864,"N/A",2455,14583.462032534306,2051.6604497195,2365,2415,2400,2490,2495,2440,2335,2285,2310,2255,2265,242,81,23,6,139,152,138,114,0,0,0,0,7221,7348,7862,8592,246,86,23,6,145,155,142,116,3474,3478,3560,3550,7323,7449,7967,8710,0,0,0,0,47,46,40,40,7129,7283,7392,7467,3474,3478,3560,3550,3865,3719,3725,3672,63820,160.5,1220.4,1111.9,56.3,172.9,337.8,189,408,5232,5224,5224,5253,5274,5349,5438,5543,5656,5737,5786,5831,5843,5873,5967,6054,6152,6247,6399,6488,6603,6763,6852,6881,6997,4590,4562,4517,4489,4431,4393,4382,4351,4356,4340,4272,4272,4261,4207,4148,4039,3919,3816,3696,3644,3604,3494,3422,3298,3226]
[126,11,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A18,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A18,Text!$A$3:$C$353,3,FALSE))","v":"Sir Gaerfyrddin"},335,296,305,314,"N/A",237112.06300000002,190800,1708,17919,29300,11244,21254,158946,6696,36437,106472,154363,128500,62300,5927,113751,190073,152810,45693,null,null,9.06,3071,6980,2670,20638,2454,15284,18137721,"N/A",0,4708.469984729656,2314.5232160613473,3565,3515,3395,3405,3380,3260,3230,3150,3170,3155,3165,359,120,37,16,170,208,167,153,0,0,0,0,11508,11994,12812,13768,365,124,41,19,177,209,171,159,5203,5194,5303,5291,11631,12120,12941,13929,0,0,0,0,104,102,99,103,12533,12910,13158,13312,5203,5194,5303,5291,5745,5527,5515,5469,90510,251.4,1615.6,1671.7,93.3,197.5,411.5,243,1041,7431,7392,7458,7518,7579,7680,7725,7862,7998,8175,8291,8341,8418,8500,8635,8782,8924,9103,9212,9379,9522,9803,9979,10123,10312,6983,6955,6910,6929,6867,6808,6752,6703,6694,6684,6611,6584,6528,6470,6394,6258,6055,5941,5734,5625,5532,5330,5207,4993,4832]
[127,12,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A19,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A19,Text!$A$3:$C$353,3,FALSE))","v":"Abertawe"},424,421,413,464,"N/A",37764.363,251304,2284,23858,38474,14397,31508,209302,8724,47839,152498,203465,185101,66203,6948,161170,246563,199723,48958,null,null,7.9,381,7780,2920,29386,2669,21102,24153460,"N/A",120,5424.424152535633,3124.81842892492,5380,5320,5260,5125,5285,5240,5260,5215,5180,5075,5155,527,168,61,27,309,325,270,257,0,0,0,0,17596,18188,19040,20442,541,179,66,27,317,327,276,258,6549,6588,6706,6690,17620,18211,19022,20452,0,0,0,0,108,111,103,105,16714,17096,17417,17533,6549,6588,6706,6690,7407,7094,7048,6975,115920,120.2,231.2,782,70.7,138.9,653.5,1119,990,12920,12929,12979,13046,13150,13254,13301,13458,13622,13842,14043,14086,14222,14360,14545,14755,14913,15110,15317,15468,15769,16180,16390,16670,16994,10694,10633,10596,10561,10483,10438,10405,10371,10326,10299,10222,10205,10151,10013,9847,9639,9405,9248,8995,8832,8732,8399,8149,7877,7660]
[128,13,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A20,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A20,Text!$A$3:$C$353,3,FALSE))","v":"Castell-nedd Port Talbot"},146,121,140,140,"N/A",44227.401,143249,1302,13637,22304,8520,18155,118819,5206,27823,84190,115426,101930,41319,3784,89470,144386,116296,30254,null,null,2.9,224,4090,1810,19668,1624,15461,18973967,"N/A",85,921.7262739174663,1145.5310161670388,2840,2895,2840,2885,2935,2915,2805,2805,2810,2760,2745,454,156,53,33,144,151,194,233,0,0,0,0,11092,11633,12440,13376,459,164,57,34,153,157,202,238,4241,4221,4293,4307,11142,11670,12467,13420,0,0,0,0,89,89,85,82,11953,12234,12475,12607,4241,4221,4293,4307,4853,4542,4552,4579,67300,118,116.1,599.4,66.3,68.8,479.5,168,582,7442,7461,7470,7535,7621,7618,7634,7727,7839,7942,7976,7988,8104,8166,8314,8524,8640,8770,8957,9055,9214,9484,9639,9799,9987,6914,6925,6880,6833,6805,6789,6759,6684,6698,6683,6663,6623,6605,6510,6369,6201,6029,5902,5739,5628,5583,5367,5200,4993,4837]
[129,14,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A21,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A21,Text!$A$3:$C$353,3,FALSE))","v":"Pen-y-bont ar Ogwr"},162,200,181,164,"N/A",25078.531,147530,1420,14245,23104,8845,16431,122161,4972,28785,86998,118745,105525,42005,4055,92253,147539,118204,30168,null,null,2.35,197,5110,1780,19666,1716,12437,15566192,"N/A",0,2664.300692537582,3061.249452487455,2670,2615,2610,2570,2655,2665,2540,2495,2490,2510,2570,388,126,44,25,136,143,160,182,0,0,0,0,9520,9959,10573,11279,391,131,50,28,138,144,164,187,3523,3512,3627,3637,9607,10024,10623,11338,0,0,0,0,103,98,97,93,10061,10370,10547,10635,3523,3512,3627,3637,4052,3787,3841,3852,66300,104,139,548.3,52.3,83.3,445.9,288,813,6674,6722,6766,6759,6808,6848,6811,6900,7042,7093,7126,7160,7260,7323,7440,7524,7681,7803,7905,8004,8089,8329,8448,8579,8778,5557,5539,5593,5582,5512,5476,5469,5432,5438,5403,5363,5335,5322,5240,5170,5004,4857,4758,4564,4513,4490,4299,4177,4037,3878]
[130,15,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A22,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A22,Text!$A$3:$C$353,3,FALSE))","v":"Bro Morgannwg"},291,281,317,299,"N/A",33126.14,135743,1346,13978,22797,8660,15729,111152,5022,28172,76717,107571,95544,40199,3943,82043,135295,107403,28838,null,null,4,289,3630,1560,16088,1379,8990,11535215,"N/A",32,2239.696563194744,3669.029081886837,2590,2565,2485,2535,2590,2525,2470,2445,2480,2460,2500,239,67,16,9,141,156,140,168,0,0,0,0,7153,7461,7857,8474,241,70,17,7,144,159,147,172,2740,2748,2793,2782,7186,7485,7893,8501,0,0,0,0,59,58,53,54,6861,7081,7221,7340,2740,2748,2793,2782,3125,2977,2957,2961,62490,75.3,371.1,595.9,21.4,53.5,377.5,234,405,5145,5154,5186,5212,5242,5271,5310,5331,5451,5579,5604,5619,5735,5835,5955,6092,6189,6286,6359,6475,6567,6763,6871,6944,7049,4682,4663,4651,4629,4611,4600,4581,4547,4506,4490,4473,4457,4428,4372,4303,4146,3996,3923,3832,3737,3713,3583,3478,3369,3260]
[131,16,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A23,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A23,Text!$A$3:$C$353,3,FALSE))","v":"Rhondda Cynon Taf"},361,244,254,292,"N/A",42415.235,242844,2338,24256,39141,14872,28456,199852,8425,48698,145584,194146,178698,64146,5657,154163,241873,191775,46755,null,null,0,265,7430,3000,30018,2811,23453,25655786,"N/A",0,1282.9150998168502,1575.144551455473,4860,4790,4700,4705,4780,4720,4620,4640,4615,4615,4650,701,272,73,39,285,283,246,258,0,0,0,0,17140,17865,19237,20769,720,291,79,46,296,286,249,264,6550,6556,6694,6636,17227,17933,19283,20834,0,0,0,0,147,139,140,134,18340,18844,19199,19364,6550,6556,6694,6636,7566,7133,7022,6946,111950,171,199.7,933.1,76.1,127.80000000000001,797.3,426,675,11089,11122,11217,11276,11320,11470,11557,11641,11838,12036,12154,12205,12322,12459,12685,12903,13177,13440,13774,13915,14244,14640,14942,15231,15610,10007,9918,9868,9832,9726,9665,9618,9492,9458,9438,9319,9250,9269,9178,8940,8735,8486,8254,7912,7757,7667,7253,6996,6653,6405]
[132,17,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A24,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A24,Text!$A$3:$C$353,3,FALSE))","v":"Merthyr Tudful"},81,74,66,91,"N/A",11195.628,58972,636,6379,10052,3657,6826,47880,2091,12551,34859,46421,43361,15611,1321,37061,60424,47544,11394,null,null,0,51,1800,770,9963,718,5792,6801574,"N/A",0,552.4434859338008,1159.6662096807067,1200,1220,1175,1175,1200,1195,1145,1160,1200,1145,1150,199,63,26,12,84,77,61,60,0,0,0,0,4835,4978,5302,5715,203,71,29,14,87,75,65,61,1749,1740,1761,1766,4847,4993,5309,5697,0,0,0,0,53,53,53,48,5141,5241,5333,5376,1749,1740,1761,1766,2039,1886,1855,1841,27610,29.4,52.800000000000004,223.5,22.2,40.7,193,147,312,3412,3401,3425,3428,3460,3510,3518,3570,3605,3694,3731,3758,3792,3824,3868,3950,4004,4093,4168,4224,4289,4413,4474,4542,4651,2640,2713,2713,2677,2655,2647,2630,2622,2626,2624,2590,2585,2563,2543,2496,2437,2364,2320,2215,2172,2146,2061,2027,1943,1900]
[133,18,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A25,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A25,Text!$A$3:$C$353,3,FALSE))","v":"Caerffili"},222,194,178,172,"N/A",27738.629,176865,1652,17856,28854,10928,20620,145375,6331,35817,104394,141048,128328,48537,4070,110822,181731,144061,35672,null,null,0,238,5060,2000,27426,1948,16048,16632359,"N/A",0,932.6935815035438,1421.469792530034,3745,3720,3685,3695,3765,3710,3620,3625,3655,3600,3590,475,149,46,22,245,248,237,213,0,0,0,0,13157,13740,14721,15847,491,162,55,25,252,253,241,219,5096,5129,5242,5259,13188,13757,14738,15863,0,0,0,0,87,85,81,83,14286,14652,14985,15141,5096,5129,5242,5259,5839,5544,5538,5503,81310,98.9,217.3,861,30.4,130,699.3,291,705,8251,8244,8342,8372,8435,8501,8547,8590,8734,8841,8952,8993,9085,9178,9324,9486,9660,9880,10089,10212,10354,10625,10840,11041,11277,8261,8241,8220,8184,8143,8132,8100,7984,7971,7967,7898,7884,7890,7788,7684,7519,7341,7153,6925,6796,6736,6486,6294,6090,5896]
[134,19,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A26,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A26,Text!$A$3:$C$353,3,FALSE))","v":"Blaenau Gwent"},70,78,54,88,"N/A",10872.805,67873,667,6692,10674,3981,7382,55946,2242,13446,40367,54427,49056,18817,1557,42754,70020,56401,14177,null,null,0,72,2130,1050,12838,860,8282,9703463,"N/A",0,418.19730596633957,574.3173997772794,1670,1670,1695,1750,1735,1715,1645,1600,1630,1620,1635,208,70,18,8,119,97,96,93,0,0,0,0,6180,6386,6807,7326,211,72,19,5,125,100,99,98,2228,2234,2279,2285,6233,6439,6853,7345,0,0,0,0,39,37,41,40,6215,6400,6490,6545,2228,2234,2279,2285,2564,2406,2397,2388,33250,51,67.7,389.7,20.2,47,387.8,222,159,4054,4078,4077,4086,4119,4144,4175,4215,4292,4350,4375,4409,4464,4490,4582,4646,4707,4782,4891,4960,5060,5176,5292,5405,5529,3928,3933,3877,3867,3828,3821,3818,3791,3783,3761,3731,3726,3714,3688,3656,3562,3486,3434,3309,3258,3227,3127,3045,2933,2844]
[135,20,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A27,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A27,Text!$A$3:$C$353,3,FALSE))","v":"Torfaen"},133,110,90,147,"N/A",12624.098,94119,943,9591,15445,5860,10969,76919,3344,19409,54782,74710,67797,26322,2527,58127,94832,75369,19543,null,null,0,117,2920,1190,13688,1052,9506,10256444,"N/A",0,495.0979782324445,864.3695556335008,2170,2175,2130,2120,2165,2125,2100,2065,2065,2030,2080,217,80,31,20,113,112,110,135,0,0,0,0,7369,7657,8031,8603,217,81,33,21,114,114,111,138,2562,2560,2610,2632,7385,7693,8057,8635,0,0,0,0,35,39,39,39,7088,7277,7439,7515,2562,2560,2610,2632,2893,2755,2754,2791,43400,30.5,101.6,326.2,16.2,70.8,292.9,354,429,5330,5350,5367,5405,5422,5454,5517,5528,5598,5655,5696,5736,5762,5827,5943,6037,6154,6248,6326,6337,6464,6613,6731,6857,6956,4393,4372,4327,4303,4272,4242,4225,4213,4244,4212,4171,4161,4151,4116,4054,3945,3858,3758,3656,3597,3584,3438,3324,3191,3131]
[136,21,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A28,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A28,Text!$A$3:$C$353,3,FALSE))","v":"Sir Fynwy"},252,208,185,234,"N/A",85031.291,94930,857,8275,13677,5289,9642,80089,3185,17083,52624,77847,62179,32751,3483,56159,95164,77843,24340,null,108559.39,0,1017,3230,1210,11492,1089,5500,7403264,"N/A",0,1540.2404293141194,1724.7169712777525,1355,1350,1300,1330,1370,1345,1320,1305,1270,1250,1250,98,29,8,0,138,146,143,146,0,0,0,0,3869,3937,4192,4452,104,35,11,0,142,152,152,155,1818,1828,1869,1869,3923,3991,4242,4521,0,0,0,0,48,52,48,45,4032,4130,4189,4238,1818,1828,1869,1869,2064,2015,2032,2024,44430,58.7,617.1,839.6,14.9,71.30000000000001,190.5,129,282,2692,2704,2741,2750,2760,2807,2824,2860,2907,2977,3004,3042,3094,3083,3142,3238,3282,3336,3396,3418,3505,3604,3622,3697,3783,2806,2781,2774,2780,2721,2711,2710,2692,2699,2671,2656,2691,2686,2614,2589,2558,2467,2408,2355,2315,2310,2253,2195,2149,2097]
[137,22,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A29,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A29,Text!$A$3:$C$353,3,FALSE))","v":"Casnewydd"},219,200,200,209,"N/A",19043.8,167899,2012,19419,30239,10785,19921,133921,6037,38126,101525,129773,129888,38011,3589,107510,156447,120851,26654,null,903106.06,0,149,4640,1790,20708,1502,12151,13299708,"N/A",409,1698.038146400505,3879.9599378079147,4915,4805,4660,4715,4840,4800,4755,4655,4600,4515,4465,333,112,29,18,281,277,214,195,0,0,0,0,12949,13191,13728,14618,341,119,33,22,287,284,212,203,3728,3726,3838,3829,12907,13150,13673,14577,0,0,0,0,61,59,54,54,10296,10569,10806,10929,3728,3726,3838,3829,4356,4129,4083,4054,72180,50.6,196,462.8,21.4,77.9,462.5,819,1284,8782,8727,8771,8798,8805,8907,8960,9002,9108,9243,9310,9357,9466,9523,9703,9873,10042,10188,10343,10466,10600,10814,10984,11150,11325,6592,6598,6559,6539,6479,6454,6400,6364,6382,6378,6312,6290,6292,6194,6065,5959,5784,5601,5458,5369,5299,5173,5033,4882,4753]
[138,23,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A30,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A30,Text!$A$3:$C$353,3,FALSE))","v":"Caerdydd"},582,534,530,596,"N/A",14230.399000000001,383919,3755,37872,60398,22509,55723,316918,13845,75752,252233,308167,309073,74846,7471,264500,369202,293830,52807,null,166742.54,2.4,62,12860,4090,43031,3086,28554,34516047,"N/A",241,4804.700708592607,19296.17765924512,10295,10195,10115,10110,10315,10265,10180,10145,10000,9670,9715,789,255,76,34,447,458,352,366,0,0,0,0,26490,27290,28979,30843,795,263,79,34,461,480,366,371,7311,7324,7475,7486,26462,27254,28925,30759,0,0,0,0,147,141,139,130,20296,20747,21101,21359,7311,7324,7475,7486,8567,8067,7920,7891,167360,106.9,138.3,890.9,58.5,97.89999999999999,880,1569,2196,18688,18682,18697,18820,18861,19048,19103,19079,19366,19598,19844,19996,20267,20479,20884,21327,21737,22095,22437,22745,23132,23597,23998,24387,24861,15410,15357,15197,15137,14995,14960,14850,14755,14780,14807,14652,14591,14513,14338,13926,13480,13105,12786,12331,12155,12026,11585,11349,10966,10692]
[]
[139,null,{"$f":"IF('iaith - language'!$K$1=2,VLOOKUP(A32,Text!$A$3:$C$353,2,FALSE),VLOOKUP(A32,Text!$A$3:$C$353,3,FALSE))","v":"Cyfanswm AU "},{"$f":"SUM(D9:D31)","v":5139},{"$f":"SUM(E9:E31)","v":4784},{"$f":"SUM(F9:F31)","v":4719},{"$f":"SUM(G9:G31)","v":5052},{"$f":"SUM(H9:H30)","v":0},{"$f":"SUM(I9:I31)","v":2078282.9419999998},{"$f":"SUM(J9:J30)","v":3186581},30090,308046,498110,188744,377882,2640220,110944,621019,1873058,2565562,2277853,908728,87593,1987628,3169586,2539714,668590,0,1417368.27,117.62,{"$f":"SUM(AE9:AE30)","v":19195},{"$f":"SUM(AF9:AF30)","v":116430},{"$f":"SUM(AG9:AG30)","v":42430},{"$f":"SUM(AH9:AH30)","v":399057},35404,259180,302875457,{"$f":"SUM(AL9:AL30)","v":0},6036,107899.93742501315,71087.85909952383,66355,65975,64815,65295,66755,65940,64520,63545,63190,{"$f":"SUM(AY9:AY30)","v":62220},{"$f":"SUM(AZ9:AZ30)","v":62620},6722,2276,712,348,3637,3700,3354,3413,0,0,0,0,205950,213668,226395,243115,6844,2404,770,387,3756,3784,3444,3507,80541,80627,82339,82348,207025,214716,227332,244257,0,0,0,0,1844,1800,1738,1706,198954,204106,208182,{"$f":"SUM(CR9:CR30)","v":210397},80541,80627,{"$f":"SUM(CU9:CU30)","v":82339},82348,91141,86815,86553,86242,{"$f":"SUM(DA9:DA30)","v":1489200},2844.6000000000004,12883.800000000003,17807.2,967.8,2147.7,8860.8,{"$f":"SUM(DH9:DH30)","v":7917},{"$f":"SUM(DI9:DI30)","v":13293},{"$f":"SUM(DJ9:DJ30)","v":143346},143341,144125,144811,145644,146962,147684,148984,150962,153231,154615,155613,157834,159290,161848,164722,167398,170109,172928,175157,178097,182533,185260,187953,191469,126254,125873,125107,124659,123520,123146,122430,121595,121491,121219,120154,119822,119494,118072,116005,113243,110141,107660,104371,102626,101764,98294,95925,92715,90271]
[]
[]
[null,27,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(B35,Text!$A$3:$C$353,2),VLOOKUP(B35,Text!$A$3:$C$353,3))","v":"Yr Is-adran Polisi Cyllid Llywodraeth Leol a Chynaliadwyedd, Llywodraeth Cymru"}]
[null,30,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(B36,Text!$A$3:$C$353,2),VLOOKUP(B36,Text!$A$3:$C$353,3))","v":"Os oes gennych ymholiadau, cysylltwch â:"}]
[null,29,null,"LGFPSettlement@Gov.Wales"]
[]
[null,33,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(B39,Text!$A$3:$C$353,2),VLOOKUP(B39,Text!$A$3:$C$353,3))","v":"Nodiadau:"}]
[null,34,null,{"$f":"IF('iaith - language'!K1=2,VLOOKUP(B40,Text!$A$3:$C$353,2),VLOOKUP(B40,Text!$A$3:$C$353,3))","v":"1 Caiff y set ddata hon ei chymryd fel cyfartaledd 3 blynedd yn y setliad."}]
[null,273]