{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main","FixList","Customiser","Settings","New Tables","NewHideList","Internal Guidance"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":34,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"SysType&\" \"&SysYear&\" \"&SysPeriod&\" External Updater Tool\"","v":"PFR/TAC FY2023-24 M12 External Updater Tool"}]
[]
[]
[]
[]
[null,"Purpose:"]
[null,{"$f":"\"To fix any further errors/issues identified in the first fixed version of the \"& SysType & \" \" & SysYear & \" files that were sent to Trusts by NHS England. \"","v":"To fix any further errors/issues identified in the first fixed version of the PFR/TAC FY2023-24 files that were sent to Trusts by NHS England. "}]
[null,{"$f":"\"Your current version will be updated to \" & FinalVersion & \".\"","v":"Your current version will be updated to 1.23.12.1B."}]
[null,"Instructions:"]
[null,{"$f":"\"1. Save this file in the same folder as your \" & SysType & \" file that needs updating (ensure that the file is an .xlsm file when saving).\"","v":"1. Save this file in the same folder as your PFR/TAC file that needs updating (ensure that the file is an .xlsm file when saving)."}]
[null,{"$f":"\"2. Take a backup copy of your \" & SysType & \" file that needs updating (ensure that the file is an .xlsm file when saving).\"","v":"2. Take a backup copy of your PFR/TAC file that needs updating (ensure that the file is an .xlsm file when saving)."}]
[null,"3. Press the button above and follow the instructions that appear."]
[null,"4. Use the updated file for your submission."]
[null,"5. Every change made is explicitly listed on the FixList sheet."]
[null,{"$f":"\"6. Ensure that the updated \"& SysType & \" template now shows the version number on the ‘Cover’ worksheet  as \"  & FinalVersion & \".\"","v":"6. Ensure that the updated PFR/TAC template now shows the version number on the ‘Cover’ worksheet  as 1.23.12.1B."}]
[]
[null,"Note:"]
[null,{"$f":"\"The updated return will be named in the format '\"&IF(SysType=\"PFR/TAC\",\"PFR\",SysType) & \"_D_\"& SysYear & \"_\" & SysPeriod & \"_[NHSCode]\"&FileSuffix&\"'.\"","v":"The updated return will be named in the format 'PFR_D_FY2023-24_M12_[NHSCode] - Updated.xlsm'."}]

{"sheet":"FixList","index":1,"n_rows":115,"n_cols":7,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
["Worksheet","Cell Reference","Fix Type","Fix","Version","User","Notes"]
["TAC06 Op Inc 1","P49","Formula","=F36","1.23.12.1","AS"]
["TAC06 Op Inc 1","P49","ChangeCellStyle","_Calc","1.23.12.1","AS"]
["31. Efficiency_Summary","AN76:AN80","ChangeCellStyle","blank","1.23.12.1","AS"]
["31. Efficiency_Summary","AN89:AN95","ChangeCellStyle","blank","1.23.12.1","AS"]
["31. Efficiency_Summary","A70:A96","CopyNewTable","A1:A27","1.23.12.1","AS"]
["31. Efficiency_Summary","A70","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A71","HideRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A72","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A73","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A74","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A75","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A76","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A77","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A78","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A79","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A80","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A81","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A82","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A83","HideRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A84","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A85","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A86","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A87","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A88","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A89","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A90","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A91","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A92","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A93","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A94","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A95","HideShowRow",null,"1.23.12.1","AS"]
["31. Efficiency_Summary","A96","HideShowRow",null,"1.23.12.1","AS"]
["TAC06 Op Inc 1","B49","CopyNewTable","A30","1.23.12.1","AP"]
["TAC Validations","I59","Formula","=HYPERLINK(\"#\"&ADDRESS(MATCH(I58+1,$B:$B,0),2,4,1,\"TAC Validations\"),I58+1)","1.23.12.1","AP"]
["TAC Validations","J59","Formula","=VLOOKUP(I59,$B:$E,4,FALSE)","1.23.12.1","AP"]
["TAC Validations","A2368:A2377","ChangeCellStyle","Normal","1.23.12.1","AP"]
["TAC Validations","A2368","Format",null,"1.23.12.1","AP"]
["TAC Validations","A2369:A2377","Format",null,"1.23.12.1","AP"]
["TAC Validations","A2368","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2369","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2370","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2371","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2372","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2373","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2374","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2375","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2376","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","A2377","HideShowRow",null,"1.23.12.1","AP"]
["TAC Validations","C2372","CopyNewTable","A32","1.23.12.1","AP"]
["99. Key Data","AY29","ClearCell",null,"1.23.12.1","AP"]
["99. Key Data","AY29","Format",null,"1.23.12.1","AP"]
["TAC JoCs","A396","ClearContents",null,"1.23.12.1","AP"]
["TAC JoCs","A397","ClearContents",null,"1.23.12.1","AP"]
["TAC JoCs","A396","HideShowRow",null,"1.23.12.1","AP"]
["TAC JoCs","A397","HideShowRow",null,"1.23.12.1","AP"]
["TAC13 Intangibles","J159:K159","CopyNewTable","A34:B34","1.23.12.1A","AS"]
["TAC Validations","B463","Formula","=@CELL(\"address\",'TAC13 Intangibles'!K158)","1.23.12.1A","AS"]
["42. Data Validation","D678","ClearContents",null,"1.23.12.1A","AS"]
["42. Data Validation","D686","ClearContents",null,"1.23.12.1A","AS"]
["42. Data Validation","D694","ClearContents",null,"1.23.12.1A","AS"]
["42. Data Validation","D702","ClearContents",null,"1.23.12.1A","AS"]
["TAC65 Audit sheet","A26","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A13","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A14","RowHeight",41.25,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A17","RowHeight",53.25,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A18","RowHeight",41.25,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A19","RowHeight",41.25,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A20","RowHeight",27,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A21","RowHeight",15.75,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A22","RowHeight",15.75,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A23","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A24","RowHeight",66,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A25","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A26","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A29","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A30","RowHeight",15.75,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A45","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A46","RowHeight",27,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A47","RowHeight",27,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A48","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A49","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A50","RowHeight",27,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A51","RowHeight",27,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A52","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A6","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A31","CopyNewTable","A37:I50","1.23.12.1A","ES"]
["TAC65 Audit sheet","F32:F38","Formularise",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A31","HideShowRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A32","HideShowRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A33","HideShowRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A34","HideShowRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A35","HideShowRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A36","HideShowRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A37","HideShowRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A38","HideShowRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A31","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A32","RowHeight",42,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A33","RowHeight",51,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A34","RowHeight",15.75,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A35","RowHeight",41.25,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A36","RowHeight",30,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A37","RowHeight",15.75,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A38","RowHeight",15.75,"1.23.12.1A","ES"]
["TAC65 Audit sheet","L316","Text","Partially completed spells accruals should only be recognised for elective income under Aligned payment and incentive contracts. Such accruals should therefore now always be attributable to a commissioner.","1.23.12.1A","ES"]
["TAC65 Audit sheet","A316","RowHeight",76.5,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A53","AddRow",null,"1.23.12.1A","ES"]
["TAC65 Audit sheet","A53","CopyNewTable","A53:J53","1.23.12.1A","ES"]
["TAC65 Audit sheet","B50","CopyNewTable","A56:A61","1.23.12.1A","ES"]
["TAC24 On-SoFP PFI","F173","Formula","=-(F151-G151)-(F148-G148)","1.23.12.1A","ES"]
["TAC24 On-SoFP PFI","B173","CopyNewTable","A64","1.23.12.1A","ES"]
["TAC24 On-SoFP PFI","O151","Formula","=IF(AND('TAC21 Borrowings'!J172<>0,J84>0,'TAC24 On-SoFP PFI'!H151>=0),\"FAIL\",\"Pass\")","1.23.12.1A","ES"]
["TAC24 On-SoFP PFI","I181","CopyNewTable","A66:A67","1.23.12.1A","ES"]
["42. Data Validation","F691","Formula","=IF(ISBLANK(N695),\"n/a\",IF(ABS(ROUND(N697,0))>50,\"FAIL\",\"Pass\"))","1.23.12.1B","AP"]
["Settings",null,"CopyNewHideList",null,"1.23.12.1B","ES"]

{"sheet":"Customiser","index":2,"n_rows":216,"n_cols":120,"rows_kept":216,"cut":false,"hidden":true,"merged":[]}
["NHS Code","MARSID","Trust Name","Validation 81","Absorption tranfer","Trust Limits (16CAP04A-CAP1220)","Trust Limits (16CAP04A-CAP1265)","Trust Limits (16CAP04A-CAP1270)","Trust Limits (16CAP04A-CAP1290)","Trust Limits (16CAP04A-CAP1291)","Trust Limits (16CAP04A-CAP1320)","Trust Limits (16CAP04A-CAP1331)","Trust Limits (16CAP04A-CAP1350)","Trust Limits (16CAP04A-CAP1391)","Trust Limits (16CAP04A-CAP1400)","Trust Limits (16CAP04A-CAP4481)","Trust Limits (16CAP04A-CAP1530)","Trust Limits (16CAP04A-CAP1540)","Trust Limits (16CAP04A-CAP1560)","Trust Limits (16CAP04B-CAP1220)","Trust Limits (16CAP04B-CAP1265)","Trust Limits (16CAP04B-CAP1270)","Trust Limits (16CAP04B-CAP1290)","Trust Limits (16CAP04B-CAP1291)","Trust Limits (16CAP04B-CAP1320)","Trust Limits (16CAP04B-CAP1331)","Trust Limits (16CAP04B-CAP1335)","Trust Limits (16CAP04B-CAP1350)","Trust Limits (16CAP04B-CAP1370)","Trust Limits (16CAP04B-CAP1380)","Trust Limits (16CAP04B-CAP1391)","Trust Limits (16CAP04B-CAP1400)","Trust Limits (16CAP04B-CAP1420)","Trust Limits (16CAP04B-CAP1470)","Trust Limits (16CAP04B-CAP1510)","Trust Limits (16CAP04B-CAP1535)","Trust Limits (16CAP04B-CAP1550)","Trust Limits (16CAP04B-CAP1560)","Trust Limits (16CAP04C-CAP1350)","Trust Limits (16CAP04C-CAP1370)","Trust Limits (16CAP04C-CAP1380)","Trust Limits (16CAP04C-CAP1391)","Trust Limits (16CAP04C-CAP1420)","Trust Limits (16CAP04C-CAP1470)","Trust Limits (16CAP04C-CAP1560)","Trust Limits (16CAP04D-CAP1290)","Trust Limits (16CAP04D-CAP1291)","Trust Limits (16CAP04D-CAP1320)","Trust Limits (16CAP04D-CAP1331)","Trust Limits (16CAP04D-CAP1335)","Trust Limits (16CAP04D-CAP1510)","Trust Limits (16CAP04D-CAP1535)","Trust Limits (16CAP04D-CAP1560)","Total Limits (18FOTCY-CAP3120)","Total Limits (18FOTCY-CAP3120)","Total Limits (18FOTCY-CAP3145)","Total Limits (18FOTCY-CAP3150)","Total Limits (18FOTCY-CAP3155)","Total Limits (18FOTCY-CAP3160)","Total Limits (18FOTCY-CAP3181)","Total Limits (18FOTCY-CAP3180)","Total Limits (18FOTCY-CAP3186)","Total Limits (18FOTCY-CAP3189)","Total Limits (18FOTCY-CAP3205)","Total Limits (18FOTCY-CAP3201)","Total Limits (18FOTCY-CAP3220)","Total Limits (18FOTCY-CAP3225)","Total Limits (18FOTCY-CAP3235)","System Capital Support PDC (Pre-committed) received","System Capital Support PDC (Pre-committed) repaid","DHSC capital programme allocation received","DHSC capital programme allocation repaid","PDC reallocation received","PDC reallocation repaid","System Capital Support PDC received","System Capital Support PDC repaid","PDC - Capital loan refinancing PDC received","PDC - Capital loan refinancing PDC repaid","Provider Revenue Support PDC received","Provider Revenue Support PDC repaid","Provider Revenue Support PDC - Cash Transfer - received","Provider Revenue Support PDC - Cash Transfer - repaid","Normal capital investment loan - Received","Normal capital investment loan - Repaid","Normal course of business loan finance - Approved (national allocation) - Received","Normal course of business loan finance - Approved (national allocation) - Repaid","Normal revenue investment loan - Received","Normal revenue investment loan - Repaid","Capital loans at 31 March 2024 - current","Revenue support / working capital loans at 31 March 2024 - current","Capital loans at 31 March 2024 - non-current","Revenue support / working capital loans at 31 March 2024 - non-current","PDC dividend cash payments @ M12","Interest accrual - capital loans","Interest accrual - Revenue support / working capital loans","Consultancy pay","PFI - interest","PFI - contingent rent","PFI - UP","PFI - service","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","SSP","AFP","NRFRDEL","Charge against Cap","CDEL"]
["Blank","Blank","Blank","TAC Validations","06. SoCF","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","16. Limits","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","18. Capital Funding-GrsCpxCDEL","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC04 SOCIE","TAC05 SoCF","TAC05 SoCF","TAC05 SoCF","TAC05 SoCF","TAC05 SoCF","TAC05 SoCF","TAC21 Borrowings","TAC21 Borrowings","TAC21 Borrowings","TAC21 Borrowings","TAC Validations","TAC21 Borrowings","TAC21 Borrowings","TAC Validations","04. SoCI","04. SoCI","42. Data Validation","42. Data Validation","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","TAC JoCs","42. Data Validation","42. Data Validation","42. Data Validation","42. Data Validation"]
["Blank","Blank","Blank","J938","AF239","F40","F53","F54","F55","F56","F57","F58","F60","F63","F64","F65","F70","F71","F73","G40","G53","G54","G55","G56","G57","G58","G59","G60","G61","G62","G63","G64","G66","G67","G68","G69","G72","G73","H60","H61","H62","H63","H66","H67","H73","I55","I56","I57","I58","I59","I68","I69","I73","AK18","AK19","AK25","AK26","AK27","AK28","AK29","AK30","AK31","AK32","AK35","AK36","AK40","AK41","AK42","$I$107","$I$108","$I$109","$I$110","$I$111","$I$112","$I$113","$I$114","$I$115","$I$116","$I$118","$I$119","$I$120","$I$121","$J$242","$J$243","$J$244","$J$245","$J$247","$J$248","$S$18","$S$19","$S$28","$S$29","$J$2267","$T$18","$T$19","J2374","AV49","AV50","N409","N415","F394","G394","I394","J394","F395","G395","I395","J395","F396","G396","I396","J396","F397","G397","I397","J397","N679","N687","N695","N703"]
[]
["R0A","MANUNI","Manchester University NHS Foundation Trust",594.53107719999969,null,29651,0,0,38181,0,0,27300,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,38181,27300,0,0,0,0,0,-8291,0,-563,0,0,38181,0,0,0,27300,0,0,0,0,0,0,0,0,-8291,0,0,0,-2500,8300,2500,54316,20000,-3379,411,18,1191,null,null,null,null,45134,"Helene Bilton",45148,32500,45062,"Joanna Burrows (Mills & Reeve)",45079,56446,45275,"Linda Glover (Mills & Reeve)",45351,8469.6,null,"None",null,null,223,-30469,57499,93511]
["R0B","TYNESIDE","South Tyneside and Sunderland NHS Foundation Trust",109.03503920000001,null,11209,0,0,1525,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1525,0,0,0,0,0,0,-5219,0,0,0,0,1525,0,0,0,0,0,0,0,0,0,0,0,0,-5219,0,0,0,0,5212,0,30610,0,-5196,291,0,330,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,0,-23367,22463,23988]
["R0D","DORSET","University Hospitals Dorset NHS Foundation Trust",139.48115020000003,null,23808,0,0,80225,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,80225,0,0,0,0,0,0,-2939,0,0,0,0,80225,0,0,0,0,0,0,0,0,0,0,0,0,-2939,0,0,0,0,2925,0,30598,0,-12514,64,0,400,null,null,null,null,45049,"Lisa White",45092,17217.22,45019,"Lisa White",45097,32100,null,"None",null,null,null,"None",null,null,65,-27152,26229,106454]
["R1A","WORCSHEALTH","Herefordshire and Worcestershire Health and Care NHS Trust",102.04218400000002,null,6610,0,0,6564,0,0,0,0,0,0,0,0,0,0,2370,0,0,6564,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6564,0,0,0,0,0,0,0,0,0,0,0,0,6564,0,0,0,0,0,0,0,0,0,0,0,6564,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3784,0,0,53,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,2900,-12822,10030,16594]
["R1C","SOLENT","Solent NHS Trust",50.317296800000008,null,3309,0,0,8222,0,0,3003,0,0,0,0,0,0,0,-9804,0,0,8222,0,0,3003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8222,0,0,3003,0,0,0,0,0,0,0,0,0,8222,3003,0,0,0,0,0,0,0,0,0,0,8222,0,0,0,3003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3791,0,0,46,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,57,-10422,7546,15768]
["R1D","SHROPSHIRECOMM","Shropshire Community Health NHS Trust",6.2133349999999989,null,2500,0,0,25,0,0,0,0,0,0,0,0,0,0,-1088,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-703,0,0,5,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,224,-5071,5810,5834]
["R1F","ISLEOFWIGHT","Isle of Wight NHS Trust",37.488471999999994,null,8339,0,0,33577,0,0,0,0,0,0,0,0,0,0,-3190,0,0,33577,0,0,0,0,0,0,0,0,0,0,0,24807,0,0,0,0,0,0,0,0,0,0,33577,0,0,0,0,24807,0,0,0,0,0,0,0,33577,0,0,0,0,0,0,0,0,0,0,0,33577,0,0,0,0,0,0,0,24807,0,0,0,0,0,0,0,0,0,0,0,0,0,-4717,0,0,80,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-1312,-10173,8796,42373]
["R1H","BARTS","Barts Health NHS Trust",1351.4389040000026,null,28687,0,0,27968,0,0,0,0,0,0,0,0,0,0,-17825,0,0,27968,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,27968,0,0,0,0,0,0,0,0,0,0,0,0,27968,0,0,0,0,0,0,0,0,0,0,0,24764,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-739,0,0,935,-31431,-50286,154826,34536,45006,"Amelia Little ",45134,2500,45259,"Andrew Uttley (Bevan Brittan)",45309,16000,45232,"Amelia Little (Bevan Brittan)",45309,10134,null,"None",null,null,-43855,-8321,56191,94455]
["R1K","NWLONDON","London North West University Healthcare NHS Trust",462.28590559999998,null,25853,0,0,56520,0,0,0,0,0,0,0,0,0,0,-2566,0,0,56520,0,0,0,0,0,0,-136,0,0,0,0,0,0,0,0,0,0,-136,0,0,0,0,56520,0,0,0,0,0,0,0,0,0,0,0,0,56520,0,0,0,0,0,0,-136,0,0,0,0,56520,0,0,0,0,0,0,0,0,0,0,0,0,-136,0,0,0,0,136,0,49,0,-13806,0,0,437,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,36,-19928,34132,91684]
["R1L","ESSEXPART","Essex Partnership University NHS Foundation Trust",78.347964000000047,null,8108,0,0,3509,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3509,0,0,0,0,0,0,-400,0,0,0,0,3311,0,0,0,0,0,0,0,0,0,0,0,0,-400,0,0,0,0,400,0,2004,0,-5709,15,0,89,null,null,null,null,45096,"Declan Nugent (NHSE)",45321,10000,null,"None",null,null,null,"None",null,null,null,"None",null,null,-19707,4791,20567,23995]
["RA2","ROYALSURREY","Royal Surrey NHS Foundation Trust",122.33394079999992,null,13998,0,0,14356,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,14356,0,0,0,0,0,0,-366,0,0,0,0,14267,0,0,0,0,0,0,0,0,0,0,0,0,-366,0,0,0,0,366,0,1484,0,-7153,6,0,243,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,2136,-21253,39251,49453]
["RA7","BRISTOL","University Hospitals Bristol and Weston NHS Foundation Trust",270.61168999999984,null,28074,0,0,7291,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,7291,0,0,0,0,0,0,-5834,0,0,0,0,7291,-431,0,0,0,0,0,0,0,0,0,0,0,-5834,0,0,0,0,5834,0,35420,0,-14932,402,0,531,null,null,null,null,45247,"Lisa Balmforth",45351,15783,null,"None",null,null,null,"None",null,null,null,"None",null,null,41,-40889,60096,68047]
["RA9","SOUTHDEVON","Torbay and South Devon NHS Foundation Trust",48.659178399999988,null,16853,0,0,23827,0,0,5486,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,23827,5486,0,0,0,0,0,-6822,0,0,0,0,23827,0,0,0,0,0,0,0,28548,0,0,0,0,-6822,0,0,0,0,2506,0,15880,0,-6666,127,0,209,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-26973,8878,3506,26777]
["RAE","BRADFORD","Bradford Teaching Hospitals NHS Foundation Trust",226.46949599999994,null,11917,0,0,33675,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,33675,0,0,0,0,0,0,-3052,0,0,0,0,33675,0,0,0,0,0,0,0,0,0,0,0,0,-3052,0,0,0,0,3052,0,10532,0,-4551,34,0,286,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,4634,-22111,21936,55611]
["RAJ","SOUTHEND","Mid and South Essex NHS Foundation Trust",471.82677560000008,null,43369,0,0,64463,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,64463,0,0,0,0,0,0,-1468,0,-2995,0,0,64463,0,0,0,0,0,0,0,0,0,0,0,0,-1468,0,0,0,0,1095,0,9674,0,-21914,38,0,661,null,null,null,null,45114,"Selina Dundas",45163,99000,45015,"Selina Dundas",45055,5000,45015,"Selina Dundas",45139,18569,44972,"Selina Dundas",45106,3346,-29749,-26575,39726,101062]
["RAL","ROYALFREE","Royal Free London NHS Foundation Trust",704.96515360000012,null,38914,0,0,2708,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,2708,0,0,0,0,0,0,-1578,0,0,0,0,2708,0,0,0,0,0,0,0,71323,0,0,0,0,-1578,0,0,0,0,1578,0,14220,0,-22877,17,0,606,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-36952,-30354,51936,53949]
["RAN","RNOH","Royal National Orthopaedic Hospital NHS Trust",0,null,7696,0,0,4696,0,0,0,0,0,0,0,0,0,0,-921,0,0,4696,0,0,0,0,0,0,-69,0,0,0,0,0,0,0,0,0,0,-69,0,0,0,0,4696,0,0,0,0,0,0,0,0,0,0,0,0,4696,0,0,0,0,0,0,-68,0,0,0,0,4696,0,0,0,0,0,0,0,0,0,0,0,0,-68,0,0,0,0,68,0,1020,0,-4204,3,0,104,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-2088,-8265,8806,13502]
["RAP","NMIDDLESEX","North Middlesex University Hospital NHS Trust",357.0724124000003,null,10432,0,0,5135,0,0,0,0,0,0,0,0,0,0,-3702,0,0,5135,0,0,0,0,0,0,-1160,0,0,0,0,0,0,0,0,0,0,-1160,0,0,0,0,5135,0,0,0,0,0,0,0,0,0,0,0,0,5135,0,0,0,0,0,0,-1160,0,0,0,0,5135,0,0,0,0,0,0,0,0,0,0,0,0,-1160,0,0,0,0,1160,0,440,0,-3282,4,0,171,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1555,-13386,11903,19123]
["RAS","HILLINGDON","The Hillingdon Hospitals NHS Foundation Trust",148.27849800000001,null,10694,0,0,10414,0,2787,8313,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,10414,8313,2787,0,0,0,0,-390,0,0,2787,0,10414,0,0,0,8313,0,0,0,0,0,0,0,0,-390,0,0,0,0,390,0,2785,0,-7336,5,0,157,null,null,2930,482,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-2612,-15556,24060,34472]
["RAT","NELONDON","North East London NHS Foundation Trust",90.332690600000035,null,4938,0,0,20807,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,20807,0,0,0,0,0,0,0,0,0,0,0,20807,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3960,0,0,94,null,null,null,null,45078,"Steven Inglesfield",45099,33000,null,"None",null,null,null,"None",null,null,null,"None",null,null,3000,-22304,33353,54160]
["RAX","KINGSTON","Kingston Hospital NHS Foundation Trust",150.39147200000002,null,10631,0,0,4038,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,4038,0,0,0,0,0,0,-540,0,0,0,0,4038,0,0,0,0,0,0,0,0,0,0,0,0,-540,0,0,0,0,540,0,5140,0,-3396,5,0,207,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1106,-2312,22967,27335]
["RBD","DORSETCOUNTY","Dorset County Hospital NHS Foundation Trust",102.35333780000025,null,8572,0,0,16733,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,16733,0,0,0,0,0,0,0,0,0,0,0,16733,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4600,0,-4510,5,0,132,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-47,-10618,9986,26719]
["RBK","WALSALL","Walsall Healthcare NHS Trust",94.95633039999997,null,7955,0,0,3650,0,0,0,0,0,0,0,0,0,0,35199,0,0,3650,0,0,0,0,0,0,0,0,0,0,0,18517,0,0,0,0,0,0,0,0,0,0,3650,0,0,0,0,18517,0,0,0,0,0,0,0,3650,0,0,0,0,0,0,0,0,0,0,0,3650,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2986,0,0,167,null,null,22206,5736,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-8652,-6831,10760,19742]
["RBL","WIRRAL","Wirral University Teaching Hospital NHS Foundation Trust",57.31031999999999,null,12590,0,0,15197,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,15197,0,0,0,0,0,0,-1015,0,0,0,0,15197,0,0,0,0,0,0,0,0,0,0,0,0,-1015,0,0,0,0,640,0,2522,0,-5316,5,0,235,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-23757,9615,15804,30961]
["RBN","STHELENS","Mersey and West Lancashire Teaching Hospitals NHS Trust (formerly St. Helens and Knowsley Hospital Services NHS Trust, acquired RVY on 01/07/23)",193.21506599999984,-171,6342,0,0,10420,0,0,14000,0,0,0,0,0,0,0,-11066,0,0,10420,0,0,14000,0,0,0,0,0,0,0,0,9000,0,-422,0,0,0,0,0,0,0,0,10420,0,0,14000,0,9000,0,0,0,0,0,0,0,10420,14000,0,0,0,0,0,0,0,-422,0,0,10386,0,0,0,14000,0,0,0,9000,0,0,0,0,0,0,0,0,0,0,0,0,0,-1216,0,0,351,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,7598,-22543,30161,43511]
["RBQ","LIVERPOOLHEART","Liverpool Heart and Chest Hospital NHS Foundation Trust",14.10276,null,6840,0,0,1400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1400,0,0,0,0,0,0,0,0,0,0,0,1384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2552,0,0,83,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,11351,-18831,10252,11636]
["RBS","ALDERHEY","Alder Hey Children's NHS Foundation Trust",32.754367999999999,null,11081,0,0,8640,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,8640,0,0,0,0,0,0,-2759,0,0,0,0,8640,0,0,0,0,0,0,0,0,0,0,0,0,-2759,0,0,0,0,2759,0,33048,0,-4796,49,0,228,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,12308,-21063,17204,25892]
["RBT","MIDCHESHIRE","Mid Cheshire Hospitals NHS Foundation Trust",112.56573580000001,null,9420,0,0,55569,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,55569,0,0,0,0,0,0,-345,0,0,0,0,55569,-1500,0,0,0,0,0,0,31001,0,0,0,0,-345,0,0,0,0,346,0,2270,0,-6770,8,0,141,null,null,null,null,45072,"Rosalyn Davies",45111,4139.1000000000004,null,"None",null,null,null,"None",null,null,null,"None",null,null,-22920,8793,45278,70056]
["RBV","CHRISTIE","The Christie NHS Foundation Trust",40.138616000000006,null,16738,0,0,10609,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,10609,0,0,0,0,0,0,-3423,0,0,0,0,10609,0,0,0,0,0,0,0,0,0,0,0,0,-3423,0,0,0,0,3422,0,43622,0,-10348,310,0,150,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,6797,-24521,22243,32852]
["RC9","LUTON","Bedfordshire Hospitals NHS Foundation Trust",198.53331399999968,null,21931,0,0,63315,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,63315,0,0,0,0,0,0,-835,0,0,0,0,63315,0,0,0,0,0,0,0,0,0,0,0,0,-835,0,0,0,0,835,0,12958,0,-10433,33,0,394,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,192,-28299,30566,94082]
["RCB","YORKHOSPITAL","York and Scarborough Teaching Hospitals NHS Foundation Trust",144.42580800000005,null,13368,0,0,31651,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,31651,0,0,0,0,0,0,-2832,0,0,0,0,31651,0,0,0,0,0,0,0,12156,0,0,0,3000,-2832,0,0,0,0,2989,0,18802,0,-9711,111,0,322,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,97,-21699,26754,58405]
["RCD","HARROGATE","Harrogate and District NHS Foundation Trust",74.626996000000005,null,8740,0,0,10794,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,10794,0,0,0,0,0,0,-1180,0,0,0,0,10794,0,0,-936,0,0,0,0,3839,0,0,0,0,-1180,0,0,0,0,1181,0,6693,0,-3974,38,0,137,null,null,null,null,45226,"Rob Eames",45282,6500,45226,"Rob Eames",45282,4500,null,"None",null,null,null,"None",null,null,0,-7377,12027,20856]
["RCF","AIREDALE","Airedale NHS Foundation Trust",27.410096800000005,null,7171,0,0,33460,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,33460,0,0,0,0,0,0,0,0,0,0,0,32512,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1767,0,0,113,null,null,null,null,45180,"Katherine Duke",45252,3000,45028,"Kathleen Duke",45349,49641,null,"None",null,null,null,"None",null,null,-6317,-2141,30546,42929]
["RCU","SHEFFIELDCHILD","Sheffield Children's NHS Foundation Trust",33.016315199999987,null,7062,0,0,3504,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3504,0,0,0,0,0,0,-2127,0,0,0,0,3504,0,0,0,0,0,0,0,0,0,0,0,0,-2127,0,0,0,0,2127,0,29878,0,-381,156,0,159,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-2931,-5191,10594,14098]
["RCX","KINGSLYNN","The Queen Elizabeth Hospital King's Lynn NHS Foundation Trust",82.191612000000077,null,9781,0,0,46078,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,46078,0,0,0,0,0,0,0,0,0,0,0,46076,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3618,0,0,137,null,null,null,null,45013,"Danni Belbin (Mills & Reeve)",45099,32602.2,null,"None",null,null,null,"None",null,null,null,"None",null,null,19,-9973,40767,54802]
["RD1","RUHBATH","Royal United Hospitals Bath NHS Foundation Trust",111.45850799999997,null,18887,0,0,17348,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,17348,0,0,0,0,0,0,-313,0,0,0,0,17348,0,0,0,0,0,0,0,0,0,0,0,0,-313,0,0,0,0,313,0,4850,0,-7531,35,0,252,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,10,-18797,17129,34073]
["RD8","MILTONKEYNES","Milton Keynes University Hospital NHS Foundation Trust",97.408491199999588,null,13136,0,0,11039,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,11039,0,0,0,0,0,0,0,0,0,0,0,11039,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-5725,0,0,175,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,23,-30037,21927,32966]
["RDE","COLCHESTER","East Suffolk and North Essex NHS Foundation Trust",185.13795039999997,null,22542,0,0,77266,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,77266,0,0,0,0,0,0,-1188,0,-141,0,0,77136,0,0,0,0,0,0,0,0,0,0,0,0,-1188,0,0,0,0,1188,0,9526,0,-11123,8,0,399,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1339,-32757,38103,115977]
["RDR","SUSSEXCOMM","Sussex Community NHS Foundation Trust",76.332475199999834,null,6542,0,0,3178,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3178,0,0,0,0,0,0,-720,0,0,0,0,3178,0,0,0,0,0,0,0,0,0,0,0,0,-720,0,0,0,0,420,0,300,0,-940,1,0,24,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,20,-16878,-22815,-19639]
["RDU","FRIMLEY","Frimley Health NHS Foundation Trust",222.9866849999998,null,25071,0,0,33991,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,33991,0,0,0,0,0,0,-6840,0,-982,0,0,32510,0,0,0,0,0,0,0,0,0,0,0,0,-6840,0,0,0,0,4040,0,24180,0,-16455,161,0,416,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-10797,-27592,48997,66837]
["RDY","DORSETHEALTH","Dorset Healthcare University NHS Foundation Trust",89.734100000000069,null,9664,0,0,8782,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,8782,0,0,0,0,0,0,0,0,-84,0,0,8144,-1900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-5100,0,0,63,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,2775,-13642,12691,18966]
["REF","ROYALCORNWALL","Royal Cornwall Hospitals NHS Trust",129.88348000000002,null,17617,0,0,21821,0,0,0,0,0,0,0,0,0,0,5011,0,0,21821,0,0,0,0,0,0,-1347,0,0,0,0,0,0,0,0,0,0,-1347,0,0,0,0,21821,0,0,0,0,0,0,0,0,0,0,0,0,21821,0,0,0,0,0,0,-1347,0,0,0,0,21821,-400,0,0,0,0,0,0,0,0,0,0,0,-1347,0,0,0,0,794,0,0,0,-6519,1,0,283,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,99,-18262,21731,44409]
["REM","AINTREE","Liverpool University Hospitals NHS Foundation Trust",73.061032000000012,null,39166,0,0,32670,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,32670,0,0,0,0,0,0,-2423,0,0,0,0,32300,0,0,0,0,0,0,0,0,0,0,0,0,-2423,0,0,0,0,2423,0,29004,0,-19722,182,0,596,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-1993,-38735,59031,80357]
["REN","CLATTERBRIDGE","The Clatterbridge Cancer Centre NHS Foundation Trust",21.252599999999997,null,10710,0,0,396,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,396,0,0,0,0,0,0,-1730,0,0,0,0,396,0,0,0,0,0,0,0,0,0,0,0,0,-1730,0,0,0,0,1730,0,28630,0,-4258,160,0,70,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,2149,-13104,7325,7721]
["REP","LIVERPOOLWOMEN","Liverpool Women's NHS Foundation Trust",35.523216599999991,null,6121,0,0,299,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,299,0,0,0,0,0,0,-612,0,0,0,0,299,0,0,0,0,0,0,0,20100,0,0,0,0,-612,0,0,0,0,301,0,0,0,-2922,0,0,73,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-22568,15886,4904,5203]
["RET","WALTON","The Walton Centre NHS Foundation Trust",25.611383999999997,null,6202,0,0,229,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,229,0,0,0,0,0,0,-1396,0,0,0,0,229,0,0,0,0,0,0,0,0,0,0,0,0,-1396,0,0,0,0,1396,0,19448,0,-1871,145,0,93,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,7318,-15755,5805,6035]
["RF4","BARKING","Barking, Havering and Redbridge University Hospitals NHS Trust",135.91191220000007,null,6970,0,0,39145,0,0,6446,0,0,0,0,0,0,0,8694,0,0,39145,0,0,6446,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,39145,0,0,6446,0,0,0,0,0,0,0,0,0,39145,6446,0,0,0,0,0,0,0,0,0,0,39145,0,0,0,6446,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3769,0,0,343,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-15776,2555,10248,48932]
["RFF","BARNSLEY","Barnsley Hospital NHS Foundation Trust",68.792240600000028,null,6993,0,0,6835,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,6835,0,0,0,0,0,0,0,0,0,0,0,6835,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1155,0,0,143,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-3794,-2662,7565,14100]
["RFR","ROTHERHAM","The Rotherham NHS Foundation Trust",57.454547999999988,null,9974,0,0,1461,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1461,0,0,0,0,0,0,-1250,0,0,0,0,1461,0,0,0,0,0,0,0,0,0,0,0,0,-1250,0,0,0,0,1250,0,10250,0,-3805,67,0,149,null,null,null,null,45000,"Tyson Taylor (Hempsons)",45021,12000,null,"None",null,null,null,"None",null,null,null,"None",null,null,-4715,-10047,11937,13398]
["RFS","CHESTERFIELD","Chesterfield Royal Hospital NHS Foundation Trust",109.96760040000002,null,6816,0,0,2246,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,2246,0,0,0,0,0,0,-1620,0,0,0,0,2246,0,0,0,0,0,0,0,33036,0,0,0,0,-1620,0,0,0,0,1620,0,4050,0,-5238,35,0,165,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-17526,2428,8486,10526]
["RGD","LEEDS","Leeds and York Partnership NHS Foundation Trust",51.26448000000002,null,3186,0,0,1624,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1624,0,0,0,0,0,0,0,0,0,0,0,1624,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,311,0,0,59,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,2209,-2287,4458,6082]
["RGM","PAPWORTH","Royal Papworth Hospital NHS Foundation Trust",157.53021199999998,null,7392,0,0,87,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,87,0,0,0,0,0,0,-424,0,0,0,0,87,0,0,0,0,0,0,0,0,0,0,0,0,-424,0,0,0,0,424,0,8904,0,-1837,18,0,99,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,482,-6860,2986,3418]
["RGN","PETERBOROUGH","North West Anglia NHS Foundation Trust",236.43279599999991,null,4417,0,0,55125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,55125,0,0,0,0,0,0,-120,0,0,0,0,55125,0,0,0,0,0,0,0,0,0,0,0,0,-120,0,0,0,0,120,0,1660,0,-4812,2,0,295,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,45,-16485,21951,72175]
["RGP","JAMESPAGET","James Paget University Hospitals NHS Foundation Trust",145.65227039999996,null,8978,0,0,42954,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,42954,0,0,0,0,0,0,0,0,0,0,0,42677,0,0,0,0,0,0,0,17471,0,0,0,0,0,0,0,0,0,0,0,0,0,-1936,0,0,121,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,35,-9705,16186,50753]
["RGR","WESTSUFFOLK","West Suffolk NHS Foundation Trust",51.05297800000001,null,11841,0,0,27479,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,27479,0,0,0,0,0,0,-2307,0,-44,0,0,27479,0,0,0,0,0,0,0,20000,0,0,0,0,-2307,0,0,0,0,2307,0,35844,0,-6279,76,0,188,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-6270,-8533,22450,39029]
["RGT","CAMBRIDGE","Cambridge University Hospitals NHS Foundation Trust",574.63149760000135,null,24263,0,0,13519,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,13519,0,0,0,0,0,0,-6398,0,0,0,0,13320,0,0,0,0,0,0,0,0,0,0,0,0,-6398,0,0,0,0,6398,0,33549,0,-3812,529,0,617,null,null,12635,2746,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,73,-30897,52099,68670]
["RH5","SOMERSETPART","Somerset NHS Foundation Trust (acquired RA4 on 01/04/23)",192.96581739999985,null,25865,0,0,41688,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,41688,0,0,0,0,0,0,-848,0,0,0,0,41688,0,0,0,0,0,0,0,0,0,0,0,0,-848,0,0,0,0,748,0,4224,0,-7759,33,0,397,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,23,-37613,43456,85145]
["RH8","RDE","Royal Devon University Healthcare NHS Foundation Trust",263.8176528000003,null,26738,0,0,27671,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,27671,0,0,0,0,0,0,-635,0,-890,0,0,27655,0,0,0,0,0,0,0,15960,0,0,0,0,-635,0,0,0,0,1905,0,3698,0,-12256,136,0,440,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-26845,-14198,48146,75545]
["RHA","NOTTSHEALTH","Nottinghamshire Healthcare NHS Foundation Trust",45.672558799999983,null,14189,0,0,5098,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,5098,0,0,0,0,0,0,0,0,0,0,0,5098,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-16541,0,0,107,null,null,null,null,45082,"Sadie Moss / Becky Hall (Mills & Reeve)",45139,30000,null,"None",null,null,null,"None",null,null,null,"None",null,null,-22000,648,35822,41112]
["RHM","SOUTHAMPTON","University Hospital Southampton NHS Foundation Trust",1256.2703924000054,null,21336,0,0,8996,0,0,9085,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,8996,9085,0,0,0,0,0,-1533,0,0,0,0,8996,0,0,0,9085,0,0,0,0,0,0,0,0,-1533,0,0,0,0,1533,0,3769,0,-12586,26,0,651,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-355,-29685,53939,59934]
["RHQ","SHEFFIELDTEACH","Sheffield Teaching Hospitals NHS Foundation Trust",467.10690759999949,null,22865,0,0,10237,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,10237,0,0,0,0,0,0,-1445,0,0,0,0,10237,0,0,0,0,0,0,0,0,0,0,0,0,-1445,0,0,0,0,1446,0,11729,0,-8198,16,0,635,-1023,-1109,4180,1058,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,154,-27225,40612,51558]
["RHU","PORTSMOUTH","Portsmouth Hospitals University NHS Trust",48.638302400000001,null,11877,0,0,52951,0,0,0,0,0,0,0,0,0,0,-13898,0,0,52951,0,0,0,0,0,0,0,0,0,0,0,46000,0,0,0,0,0,0,0,0,0,0,52951,0,0,0,0,46000,0,0,0,0,0,0,0,52951,0,0,0,0,0,0,0,0,0,0,0,52951,0,0,0,0,0,0,0,46000,0,0,0,0,0,0,0,0,0,0,0,0,0,-7772,0,0,395,null,null,88275,51734,45107,"Becky Hall (Mills & Reeve)",45140,28000,null,"None",null,null,null,"None",null,null,null,"None",null,null,-11948,-10689,18926,76714]
["RHW","ROYALBERKSHIRE","Royal Berkshire NHS Foundation Trust",144.44530599999999,null,29584,0,0,18200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,18200,0,0,0,0,0,0,-1502,0,0,0,0,18200,0,0,0,0,0,0,0,0,0,0,0,0,-1502,0,0,0,0,1502,0,2966,0,-8595,54,0,283,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-7497,-28416,23126,41325]
["RJ1","GUYS","Guy's & St Thomas' NHS Foundation Trust",450.31659999999999,null,61745,0,0,10617,0,0,57500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,10617,57500,0,0,0,0,0,-18134,0,0,0,0,10617,0,0,0,57500,0,0,0,0,0,0,0,0,-18134,0,0,0,0,17008,0,174831,0,-43903,848,0,1147,null,null,null,null,45223,"Tim Gooder (DAC Beachcroft)",45350,3500,null,"None",null,null,null,"None",null,null,null,"None",null,null,10186,-111548,133361,143978]
["RJ2","LEWISHAM","Lewisham and Greenwich NHS Trust",305.25888880000088,null,29579,0,0,20420,0,0,0,0,0,0,0,0,0,0,6788,0,0,20420,0,0,0,0,0,0,-472,0,0,0,0,0,0,-500,0,0,0,-472,0,0,0,0,20420,0,0,0,0,0,0,0,0,0,0,0,0,20420,0,0,0,0,0,0,-472,0,-500,0,0,20420,0,0,0,0,0,0,0,0,0,0,0,0,-472,0,0,0,0,472,0,5107,0,-6192,9,0,296,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-239,-37702,37890,63458]
["RJ6","CROYDON","Croydon Health Services NHS Trust",174.39069500000008,null,10484,0,0,15243,0,0,0,0,0,0,0,0,0,0,24034,0,0,15243,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15243,0,0,0,0,0,0,0,0,0,0,0,0,15243,0,0,0,0,0,0,0,0,0,0,0,15243,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-6441,0,0,175,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-1905,-9351,15941,31184]
["RJ7","STGEORGES","St George's University Hospitals NHS Foundation Trust",176.53496479999993,null,24149,0,0,3333,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3333,0,0,0,0,0,0,-602,0,0,0,0,3333,0,0,0,0,0,0,0,43756,0,0,0,0,-602,0,0,0,0,602,0,9034,0,-11836,77,0,551,-2352,-7536,12536,1159,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-3607,-45903,35965,39298]
["RJ8","CORNWALLPART","Cornwall Partnership NHS Foundation Trust",71.739648800000026,null,3056,0,0,22647,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,22647,0,0,0,0,0,0,0,0,0,0,0,22647,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1891,0,0,45,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,36,-10094,6825,29859]
["RJC","SWARKS","South Warwickshire University NHS Foundation Trust",238.41388079999953,null,6684,0,0,3834,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3834,0,0,0,0,0,0,-1428,0,-23,0,0,3834,0,0,0,0,0,0,0,10836,0,0,0,0,-1428,0,0,0,0,1428,0,18576,0,-4220,23,0,168,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,17,-3924,20703,21734]
["RJE","NORTHMIDLANDS","University Hospitals of North Midlands NHS Trust",450.31618279999964,null,18395,0,0,28862,0,0,0,0,0,0,0,0,0,0,-2021,0,0,28862,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,28862,0,0,0,0,0,0,0,0,0,0,0,0,28862,0,0,0,0,0,0,0,0,0,0,0,28862,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-7745,0,0,452,null,null,null,null,45167,"Andrew Vernon",45331,18750,null,"None",null,null,null,"None",null,null,null,"None",null,null,229,-21001,30361,62091]
["RJL","NLAG","Northern Lincolnshire and Goole NHS Foundation Trust",149.86039040000014,null,16670,0,0,31972,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,31972,0,0,0,0,0,0,-1329,0,0,0,0,31972,0,0,0,0,0,0,0,0,0,0,0,0,-1329,0,0,0,0,1329,0,5554,0,-5970,55,0,168,null,null,null,null,45030,"Lynn Duffy ",45134,6000,null,"None",null,null,null,"None",null,null,null,"None",null,null,125,-17914,18310,49181]
["RJN","EASTCHESHIRE","East Cheshire NHS Trust",32.21851460000002,null,5759,0,0,14084,0,0,0,0,0,0,0,0,0,0,296,0,0,14084,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14084,0,0,0,0,0,0,0,0,0,0,0,0,14084,0,0,0,0,0,0,0,0,0,0,0,14084,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1496,0,0,78,null,null,null,null,44938,"Emma Newton",45107,3775.75,null,"None",null,null,null,"None",null,null,null,"None",null,null,-9741,4109,5120,19204]
["RJR","CHESTER","Countess of Chester Hospital NHS Foundation Trust",71.571029000000024,null,7233,0,0,33631,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,33631,0,0,0,0,0,0,-1801,0,0,0,0,33631,0,0,0,0,0,0,0,31391,0,0,0,0,-1801,0,0,0,0,1801,0,7308,0,-899,7,0,188,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-25194,16197,36049,39359]
["RJZ","KINGS","King’s College Hospital NHS Foundation Trust",547.91505200000165,null,29498,0,0,15390,0,0,17741,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,15390,17741,0,0,0,0,0,-3418,0,0,0,0,15390,0,0,0,17741,0,0,0,63685,0,0,0,0,-3418,0,0,0,0,3418,0,33416,0,-13582,271,0,809,null,null,113089,70789,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-78732,18270,57231,73858]
["RK5","SHERWOOD","Sherwood Forest Hospitals NHS Foundation Trust",132.48475039999997,null,3201,0,0,16192,0,0,6491,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,16192,6491,0,0,0,0,0,0,0,0,0,0,16192,0,0,0,6491,0,0,0,10998,0,0,0,0,0,0,0,0,0,0,0,0,0,-413,0,0,183,null,null,60528,27659,45261,"Deborah Kearsley / Jacqueline Read",45323,20000,null,"None",null,null,null,"None",null,null,null,"None",null,null,-13968,7217,11592,31697]
["RK9","PLYMOUTH","University Hospitals Plymouth NHS Trust ",482.99498280000006,null,15932,0,0,53439,0,0,8000,0,0,0,0,0,0,0,23733,0,0,53439,0,0,8000,0,0,0,0,0,0,0,0,67585,0,-96,0,0,0,0,0,0,0,0,53439,0,0,8000,0,67585,0,0,0,0,0,0,0,53439,8000,0,0,0,0,0,0,0,-96,0,0,53439,0,0,0,8000,0,0,0,51544,0,0,0,0,0,0,0,0,0,0,0,0,0,-9624,0,0,403,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-32791,-4788,76750,130189]
["RKB","COVENTRY","University Hospitals Coventry And Warwickshire NHS Trust",244.03956999999997,null,1835,0,0,6358,0,0,11625,0,0,0,0,0,0,0,2797,0,0,6358,0,0,11625,0,0,0,-890,0,0,0,0,0,0,0,0,0,0,-890,0,0,0,0,6358,0,0,11625,0,0,0,0,0,0,0,0,0,6358,11625,0,0,0,0,0,-890,0,0,0,0,6358,0,0,0,11625,0,0,0,0,0,0,0,0,-890,0,0,0,0,890,0,0,0,369,5,0,435,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,0,-14285,24383,38462]
["RKE","WHITTINGTON","The Whittington Health NHS Trust",180.89356120000005,null,13388,0,0,12241,0,0,5000,0,0,0,0,0,0,0,14644,0,0,12241,0,0,5000,0,0,0,-116,0,0,0,0,0,0,0,0,0,0,-116,0,0,0,0,12241,0,0,5000,0,0,0,0,0,0,0,0,0,12241,5000,0,0,0,0,0,-116,0,0,0,0,12241,0,0,0,5000,0,0,0,0,0,0,0,0,-116,0,0,0,0,116,0,1508,0,-5635,2,0,168,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,606,-11298,31473,43718]
["RKL","WESTLONDON","West London NHS Trust",0,null,12657,0,0,1074,0,0,0,0,0,0,0,0,0,0,-11284,0,0,1074,0,0,0,0,0,0,-3576,0,0,0,0,0,0,0,0,0,0,-3576,0,0,0,0,1074,0,0,0,0,0,0,0,0,0,0,0,0,1074,0,0,0,0,0,0,-3576,0,0,0,0,1074,0,0,0,0,0,0,0,0,0,0,0,0,-3576,0,0,0,0,3577,0,60358,0,-16371,99,0,100,null,null,null,null,45043,"Rosanna Proctor",45197,15000,null,"None",null,null,null,"None",null,null,null,"None",null,null,502,-14803,18778,18778]
["RL1","RJAH","The Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust",58.126359600000029,null,3490,0,0,6761,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,6761,0,0,0,0,0,0,-1176,0,-277,0,0,6761,0,0,0,0,0,0,0,0,0,0,0,0,-1176,0,0,0,0,1180,0,0,0,-2096,3,0,88,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-1880,-2475,5743,12504]
["RL4","WOLVERHAMPTON","The Royal Wolverhampton NHS Trust",130.67082800000006,null,23719,0,0,10526,0,0,0,0,0,0,0,0,0,0,40467,0,0,10526,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10526,0,0,0,0,0,0,0,0,0,0,0,0,10526,0,0,0,0,0,0,0,0,0,0,0,10526,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-13176,0,0,401,null,null,7868,2630,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-26657,-3168,35521,45332]
["RLQ","WYEVALLEY","Wye Valley NHS Trust",111.30993920000006,null,7226,0,0,18229,0,0,0,0,0,0,0,0,0,0,-382,0,0,18229,0,0,0,0,0,0,0,0,0,0,0,20807,0,0,0,0,0,0,0,0,0,0,18229,0,0,0,0,20807,0,0,0,0,0,0,0,18229,0,0,0,0,0,0,0,0,0,0,0,18229,0,0,0,0,0,0,0,17976,0,0,0,0,0,0,0,0,0,0,0,0,0,-3754,0,0,124,-1025,-6740,28470,15814,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-13388,1644,1514,19268]
["RLT","GEORGEELIOT","George Eliot Hospital NHS Trust",68.615753599999962,null,6196,0,0,17695,0,0,0,0,0,0,0,0,0,0,9111,0,0,17695,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,17695,0,0,0,0,0,0,0,0,0,0,0,0,17695,0,0,0,0,0,0,0,0,0,0,0,17695,0,0,0,0,0,0,0,0,-4836,0,0,0,0,0,0,0,0,0,0,0,0,-2196,0,0,94,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,26,-6173,8324,26019]
["RLY","NORTHSTAFFS","North Staffordshire Combined Healthcare NHS Trust",8.1177499999999991,null,1325,0,0,2182,0,0,0,0,0,0,0,0,0,0,3415,0,0,2182,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2182,0,0,0,0,0,0,0,0,0,0,0,0,2182,0,0,0,0,0,0,0,0,0,0,0,2182,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-28,0,0,19,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,320,-4086,1279,3941]
["RM1","NORWICH","Norfolk and Norwich University Hospitals NHS Foundation Trust",196.93047839999983,null,14771,0,0,22000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,22000,0,0,0,0,0,0,0,0,0,0,0,21145,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1289,0,0,446,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,138,-17569,18833,39897]
["RM3","SALFORD","Northern Care Alliance NHS Foundation Trust",388.35289840000013,null,47443,0,0,17939,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,17939,1000,0,0,0,0,0,-2579,0,-735,0,0,16514,0,0,0,1000,0,0,0,0,0,0,0,0,-2579,0,0,0,0,2579,0,25936,0,-6282,37,0,732,null,null,null,null,45076,"Estelle Carmichael",45113,12000,44868,"Liz Warner",45139,5500,null,"None",null,null,null,"None",null,null,-68200,24656,66728,82764]
["RMC","BOLTON","Bolton NHS Foundation Trust",154.15620139999993,null,9361,0,0,9054,0,0,900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,9054,900,0,0,0,0,0,-4147,0,0,0,0,9054,0,0,0,900,0,0,0,0,0,0,0,0,-4147,0,0,0,0,4147,0,29521,0,-4032,295,0,209,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-13369,-5940,21262,29341]
["RMP","TAMESIDE","Tameside and Glossop Integrated Care NHS Foundation Trust",55.768616799999961,null,5566,0,0,8203,0,0,400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,8203,400,0,0,0,0,0,0,0,0,0,0,8203,0,0,0,400,0,0,0,9500,0,0,0,0,0,0,0,0,0,0,0,0,0,-3636,0,0,120,null,null,null,null,45167,"Alex Kirkpatrick (NHSE)",45278,7000,null,"None",null,null,null,"None",null,null,null,"None",null,null,-30742,16568,14629,23558]
["RMY","NORWAVE","Norfolk and Suffolk NHS Foundation Trust",81.406783200000035,null,8055,0,0,35807,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,35807,0,0,0,0,0,0,-1056,0,0,0,0,35807,0,0,0,0,0,0,0,0,0,0,0,0,-1056,0,0,0,0,1057,0,2660,0,-4479,20,0,79,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,4,-13804,12017,47824]
["RN3","GWSWINDON","Great Western Hospitals NHS Foundation Trust",127.42392140000017,null,-1423,0,0,19888,0,0,10041,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,19888,10041,0,0,0,0,0,-110,0,0,0,0,19888,0,0,0,10041,0,0,0,0,0,0,0,0,-110,0,0,0,0,110,0,55,0,-6614,1,0,203,null,null,null,null,45209,"Naomi Compton (Bevan Brittan)",45278,12333.06,null,"None",null,null,null,"None",null,null,null,"None",null,null,150,-8915,19441,43907]
["RN5","BASINGSTOKE","Hampshire Hospitals NHS Foundation Trust",496.61062639999966,null,14654,0,0,14259,0,0,1834,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,14259,1834,0,0,0,0,0,-523,0,-62,0,0,14259,-108,0,0,1834,0,0,0,16600,0,0,0,0,-523,0,0,0,0,204,0,3164,0,-7339,31,0,297,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1277,-17460,13383,27437]
["RN7","DARTFORD","Dartford and Gravesham NHS Trust",273.26245200000005,null,4351,0,0,17253,0,0,0,0,0,0,0,0,0,0,-3950,0,0,17253,0,0,0,0,0,0,0,0,0,0,0,12600,0,0,0,0,0,0,0,0,0,0,17253,0,0,0,0,12600,0,0,0,0,0,0,0,17253,0,0,0,0,0,0,0,0,0,0,0,13382,-79,0,0,0,0,0,0,12600,0,0,0,0,0,0,0,0,0,0,0,0,0,-4107,0,0,165,"=-'TAC24 On-SoFP PFI'!G146","=-'TAC24 On-SoFP PFI'!G151",25606,2488,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,16503,8985,7661,21749]
["RNA","DUDLEY","The Dudley Group NHS Foundation Trust",125.53232480000007,null,4097,0,0,6756,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,6756,0,0,0,0,0,0,0,0,0,0,0,6756,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1103,0,0,222,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,6807,-15408,6335,15353]
["RNK","TAVIPORT","Tavistock and Portman NHS Foundation Trust",0,null,2195,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,20,0,0,0,0,0,0,-445,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,-445,0,0,0,0,445,0,1331,0,-602,2,0,26,null,null,null,null,45063,"Sarah Mountain",45163,9660,null,"None",null,null,null,"None",null,null,null,"None",null,null,-2517,-3533,2225,2225]
["RNN","CUMBRIAPART","North Cumbria Integrated Care NHS Foundation Trust",104.04070459999996,null,9598,0,0,28442,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,28442,0,0,0,0,0,0,0,0,0,0,0,27442,0,0,0,0,0,0,0,28993,0,0,0,0,0,0,0,0,0,0,0,0,0,-6356,0,0,197,-3803,-5639,34762,18689,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-4993,-8388,15396,46919]
["RNQ","KETTERING","Kettering General Hospital NHS Foundation Trust",116.79327600000009,null,10602,0,0,10838,0,0,1114,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,10838,1114,0,0,0,0,0,-1480,0,0,0,0,7165,0,0,0,1114,0,0,0,6905,0,0,0,0,-1480,0,0,0,0,1480,0,760,0,-5517,28,0,169,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-2863,-12399,11078,17303]
["RNS","NORTHAMPTON","Northampton General Hospital NHS Trust",118.19663439999992,null,14345,0,0,7556,0,0,668,0,0,0,0,0,0,0,-371,0,0,7556,0,0,668,0,0,0,0,0,0,0,0,17543,0,-271,0,0,0,0,0,0,0,0,7556,0,0,668,0,17543,0,0,0,0,0,0,0,7556,668,0,0,0,0,0,0,0,-271,0,0,4462,0,0,0,668,0,0,0,17247,0,0,0,0,0,0,0,0,0,0,0,0,0,-6217,0,0,211,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-15539,-2037,15489,19951]
["RNU","OXBUCKS","Oxford Health NHS Foundation Trust",75.551496399999976,null,7051,0,0,3705,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3705,0,0,0,0,0,0,-1338,0,0,0,0,3705,0,0,0,0,0,0,0,0,0,0,0,0,-1338,0,0,0,0,1338,0,12049,0,-2959,23,0,104,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,4634,-18948,17893,21599]
["RNZ","SALISBURY","Salisbury NHS Foundation Trust",168.93680799999976,null,10307,0,0,16485,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,16485,0,0,0,0,0,0,-631,0,0,0,0,16485,0,0,0,0,0,0,0,4297,0,0,0,0,-631,0,0,0,0,631,0,319,0,-5163,6,0,174,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-135,-12650,19909,36625]
["RP1","NORTHANTSCARE","Northamptonshire Healthcare NHS Foundation Trust",25.877654400000004,null,5018,0,0,1562,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1562,0,0,0,0,0,0,0,0,0,0,0,1562,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2114,0,0,46,-1450,-2402,8119,1896,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-4825,-6722,9103,11281]
["RP4","GOSH","Great Ormond Street Hospital for Children NHS Foundation Trust",168.84674560000008,null,41174,0,0,352,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,352,0,0,0,0,0,0,0,0,0,0,0,352,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9199,0,0,303,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-4156,-15489,24098,25566]
["RP5","DONCASTER","Doncaster & Bassetlaw Teaching Hospitals NHS Foundation Trust",110.42296799999994,null,13378,0,0,35927,0,0,7094,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,35927,7094,0,0,0,0,0,-1833,0,0,0,0,35927,0,0,0,7094,0,0,0,33029,0,0,0,0,-1833,0,0,0,0,543,0,8416,0,-8897,24,0,231,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-23678,6270,20970,56897]
["RP6","MOORFIELDS","Moorfields Eye Hospital NHS Foundation Trust",0,null,8836,0,0,38539,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,38539,0,0,0,0,0,0,-1823,0,0,0,0,38539,0,0,0,0,0,0,0,0,0,0,0,0,-1823,0,0,0,0,1823,0,26438,0,-1503,59,0,126,null,null,null,null,45280,"Jamie Henderson",45335,52577.5,null,"None",null,null,null,"None",null,null,null,"None",null,null,11819,-27312,10026,38566]
["RP7","LINCSPART","Lincolnshire Partnership NHS Foundation Trust",10.271074799999999,null,3757,0,0,8150,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,8150,0,0,0,0,0,0,0,0,0,0,0,8150,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2258,0,0,38,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,8822,-13814,5668,13818]
["RPA","MEDWAY","Medway NHS Foundation Trust",196.65655199999998,null,17336,0,0,14638,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,14638,0,0,0,0,0,0,-126,0,0,0,0,14716,-78,0,0,0,0,0,0,0,0,0,0,0,-126,0,0,0,0,126,0,1772,0,-9268,9,0,187,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-19653,1357,13622,29696]
["RPC","QVH","Queen Victoria Hospital NHS Foundation Trust",142.80446600000002,null,3747,0,0,7109,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,7109,0,0,0,0,0,0,-778,0,0,0,0,7109,0,0,0,0,0,0,0,0,0,0,0,0,-778,0,0,0,0,778,0,1156,0,-1622,16,0,67,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1,-4689,5982,12967]
["RPG","OXLEAS","Oxleas NHS Foundation Trust",25.809515400000002,null,7110,0,0,908,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,908,0,0,0,0,0,0,0,0,0,0,0,908,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-998,0,0,78,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,4249,-17386,7862,10087]
["RPY","ROYALMARSDEN","The Royal Marsden NHS Foundation Trust",0,null,20377,0,0,81,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,81,0,0,0,0,0,0,-3248,0,-482,0,0,81,0,0,0,0,0,0,0,0,0,0,0,0,-3248,0,0,0,0,2001,0,5996,0,-5214,8,0,174,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,10535,-34121,17442,18640]
["RQ3","BCH","Birmingham Women's and Children's NHS Foundation Trust",0,null,10421,0,0,25345,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,25345,0,0,0,0,0,0,-1288,0,0,0,0,25345,0,0,0,0,0,0,0,0,0,0,0,0,-1288,0,0,0,0,1288,0,9660,0,-1570,53,0,274,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,4198,-18836,29238,55698]
["RQM","CHELSEA","Chelsea and Westminster Hospital NHS Foundation Trust",491.6965615999996,null,22989,0,0,18471,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,18471,0,0,0,0,0,0,-1991,0,0,0,0,18471,0,0,0,0,0,0,0,0,0,0,0,0,-1991,0,0,0,-1682,1991,1682,7418,26068,-12649,21,56,435,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,2681,-44225,28278,48802]
["RQW","PRINCESSALEX","The Princess Alexandra Hospital NHS Trust",57.297238199999988,null,14725,0,0,15999,0,0,0,0,0,0,0,0,0,0,11455,0,0,15999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15999,0,0,0,0,0,0,0,0,0,0,0,0,15999,0,0,0,0,0,0,0,0,0,0,0,15393,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3601,0,0,157,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-6126,-7909,30304,45697]
["RQX","HOMERTON","Homerton Healthcare NHS Foundation Trust",119.39014800000005,null,13609,0,0,14130,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,14130,0,0,0,0,0,0,-292,0,-52,0,0,14130,0,0,0,0,0,0,0,0,0,0,0,0,-292,0,0,0,0,292,0,3326,0,-5644,29,0,166,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,5,-16286,15956,30056]
["RQY","SWLONDON","South West London and St George's Mental Health NHS Trust",0,null,1126,0,0,2946,0,0,0,0,0,0,0,0,0,0,-17622,0,0,2946,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2946,0,0,0,0,0,0,0,0,0,0,0,0,2946,0,0,0,0,0,0,0,0,0,0,0,2946,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16000,0,83374,0,-1072,16,0,85,null,null,null,null,45114,"Emily Stokes (Capsticks)",45338,40000,null,"None",null,null,null,"None",null,null,null,"None",null,null,1080,-9430,-9302,-6356]
["RR7","GATESHEAD","Gateshead Health NHS Foundation Trust",269.56326000000007,null,7249,0,0,14768,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,14768,0,0,0,0,0,0,-999,0,0,0,0,14768,0,0,0,0,0,0,0,0,0,0,0,0,-999,0,0,0,0,999,0,11013,0,-3879,20,0,159,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-7889,-4762,10027,24795]
["RR8","LEEDSTEACH","Leeds Teaching Hospitals NHS Trust",1409.5518080000022,null,22600,0,0,38539,936,0,0,0,0,0,0,0,0,0,18035,0,0,38539,936,0,0,0,0,0,-2056,0,0,0,0,0,0,0,0,0,0,-2056,0,0,0,0,38539,936,0,0,0,0,0,0,0,0,0,0,0,38539,0,0,0,936,0,0,-2056,0,0,0,0,38539,0,936,0,0,0,0,0,0,0,0,0,0,-2056,0,0,0,0,2056,0,11282,0,-9657,19,0,872,-6264,-14947,44512,9206,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,12304,-27930,59483,99641]
["RRE","SOUTHSTAFFS","Midlands Partnership NHS Foundation Trust",85.197203000000044,null,6325,0,0,11149,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,11149,0,0,0,0,0,0,-1332,0,0,0,0,11149,0,0,0,0,0,0,0,0,0,0,0,0,-1332,0,0,0,0,1332,0,14682,0,0,27,0,91,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,138,-14467,20528,26245]
["RRF","WIGAN","Wrightington, Wigan and Leigh NHS Foundation Trust",193.69285399999981,null,10767,0,0,15756,0,0,2200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,15756,2200,0,0,0,0,0,-769,0,-677,0,0,15756,0,0,0,2200,0,0,0,0,0,0,0,0,-769,0,0,0,0,769,0,9964,0,-5287,69,0,189,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-10395,-5968,18986,34742]
["RRJ","ROH","The Royal Orthopaedic Hospital NHS Foundation Trust",0,null,5310,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1331,0,0,71,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-3696,-2077,3993,3993]
["RRK","UHB","University Hospitals Birmingham NHS Foundation Trust",630.60393619999923,null,30280,0,0,39723,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,39723,0,0,0,0,0,0,0,0,0,0,0,39366,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2379,0,0,958,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-31517,-8478,67733,108874]
["RRP","BARNET","Barnet, Enfield And Haringey Mental Health NHS Trust",0,null,11159,0,0,1694,0,0,0,0,0,0,0,0,0,0,278,0,0,1694,0,0,0,0,0,0,-498,0,0,0,0,0,0,0,0,0,0,-498,0,0,0,0,1694,0,0,0,0,0,0,0,0,0,0,0,0,1694,0,0,0,0,0,0,-498,0,0,0,0,1694,0,0,0,0,0,0,0,0,0,0,0,0,-498,0,0,0,0,498,0,4681,0,-7083,9,0,78,null,null,null,null,45125,"Caroline Sherwood (Bevan Brittan) ",45308,60500,null,"None",null,null,null,"None",null,null,null,"None",null,null,604,-13238,10239,11007]
["RRU","LONDONAMB","London Ambulance Service NHS Trust",156.89879359999995,null,29032,0,0,2207,0,0,0,0,0,0,0,0,0,0,-257,0,0,2207,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2207,0,0,0,0,0,0,0,0,0,0,0,0,2207,0,0,0,0,0,0,0,0,0,0,0,2207,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-4193,0,0,0,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,151,-22161,32666,34872]
["RRV","UCLH","University College London Hospitals NHS Foundation Trust",576.28354399999978,null,25571,0,0,11639,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,11639,0,0,11870,0,0,0,-1305,-11748,0,0,0,11211,0,0,0,0,0,11748,0,0,0,0,0,0,-13053,0,0,0,0,13052,0,264116,0,-7268,452,0,628,null,null,null,null,45056,"James Hilton",45078,1442.88,null,"None",null,null,null,"None",null,null,null,"None",null,null,45243,-105481,49109,61398]
["RT1","CAMBPETER","Cambridgeshire and Peterborough NHS Foundation Trust",32.986421600000007,null,4277,0,0,1401,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1401,0,0,0,0,0,0,0,0,0,0,0,1401,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1648,0,0,80,null,null,6193,2689,45035,"Surbhi Shah (Mills & Reeve)",45078,7920,null,"None",null,null,null,"None",null,null,null,"None",null,null,-157,-8337,11605,13245]
["RT2","PENNINECARE","Pennine Care NHS Foundation Trust",18.361035600000005,null,4852,0,0,3530,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3530,0,0,0,0,0,0,0,0,0,0,0,3530,-1129,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2628,0,0,73,null,null,3372,1211,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,5780,-12322,6059,9894]
["RT5","LEICESTERPART","Leicestershire Partnership NHS Trust",47.612959000000004,null,9790,0,0,47,0,0,0,0,0,0,0,0,0,0,-3715,0,0,47,0,0,0,0,0,0,-163,0,0,0,0,0,0,0,0,0,0,-163,0,0,0,0,47,0,0,0,0,0,0,0,0,0,0,0,0,47,0,0,0,0,0,0,-163,0,0,0,0,47,0,0,0,0,0,0,0,0,0,0,0,0,-163,0,0,0,0,163,0,2694,0,-5837,21,0,89,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,0,-13865,3738,3895]
["RTD","NEWCASTLE","The Newcastle Upon Tyne Hospitals NHS Foundation Trust",298.85354639999997,null,21130,0,0,1217,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1217,0,0,0,0,0,0,0,0,0,0,0,1217,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-4767,0,0,742,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,77,-25491,32182,37546]
["RTE","GLOUCESTER","Gloucestershire Hospitals NHS Foundation Trust",208.73992919999984,null,17910,0,0,13523,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,13523,0,0,0,0,0,0,-1729,0,0,0,0,10385,-24,0,0,0,0,0,0,0,0,0,0,0,-1729,0,0,0,0,1729,0,12175,0,-8534,6,0,345,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-535,-30205,33013,46360]
["RTF","NORTHUMBRIA","Northumbria Healthcare NHS Foundation Trust",3.8220000000000001,null,19176,0,0,8014,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,8014,0,0,0,0,0,0,-2624,0,0,0,0,8014,0,0,0,0,0,0,0,0,0,0,0,0,-2624,0,0,0,0,2624,0,29496,0,0,540,0,264,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,27644,-51439,75391,81905]
["RTG","DERBY","University Hospitals of Derby and Burton NHS Foundation Trust",146.18152799999999,null,20991,0,0,22072,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,22072,0,0,0,0,0,0,0,0,0,0,0,21872,0,0,0,0,0,0,0,18421,0,0,0,0,0,0,0,0,0,0,0,0,0,-1794,0,0,517,null,null,84357,40918,45068,"Helen Badger (Browne Jacobson)",45252,9000,44956,"Jane Thomas",45021,11249.42,45257,"Joanna Burrows (Mills & Reeve)",45334,18500,null,"None",null,null,-34454,5021,19043,45464]
["RTH","OXFORD","Oxford University Hospitals NHS Foundation Trust",168.17980799999992,null,28348,0,0,10587,0,0,7803,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,10587,7803,0,0,0,0,0,-661,0,0,0,0,10587,0,0,0,7803,0,0,0,0,0,0,0,0,-661,0,0,0,0,661,0,13916,0,-9606,70,0,731,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-10748,-19385,40092,51688]
["RTK","ASHFORD","Ashford and St Peter's Hospitals NHS Foundation Trust",121.73286240000006,null,10515,0,0,13277,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,13277,0,0,0,0,0,0,0,0,0,0,0,13277,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-8031,0,0,219,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-9510,-4531,13328,27484]
["RTP","SURREYSUSSEX","Surrey And Sussex Healthcare NHS Trust",334.79593000000023,null,15653,0,0,11078,0,0,0,0,0,0,0,0,0,0,11180,0,0,11078,0,0,0,0,0,0,-880,0,0,0,-216,35149,0,0,0,0,0,-880,0,0,-216,0,11078,0,0,0,0,35149,0,0,0,0,0,0,0,11078,0,0,0,0,0,0,-880,0,0,0,0,8618,0,0,0,0,0,0,0,25437,0,0,0,0,-880,0,0,0,-216,660,216,440,1520,-7324,4,4,233,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-36556,13230,8333,16951]
["RTQ","GLOSPART","Gloucestershire Health and Care NHS Foundation Trust",46.057982999999993,null,6810,0,0,1710,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1710,0,0,0,0,0,0,0,0,0,0,0,1710,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2409,0,0,50,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,984,-10777,12002,13712]
["RTR","SOUTHTEES","South Tees Hospitals NHS Foundation Trust",286.94605919999992,null,6833,0,0,26554,0,0,7101,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,26554,7101,0,0,0,0,0,0,0,0,0,0,26554,0,0,0,7101,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-117,0,0,419,null,null,71809,37979,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-20077,3572,15603,49027]
["RTX","MORECAMBEBAY","University Hospitals of Morecambe Bay NHS Foundation Trust",84.41407420000003,null,20911,0,0,16168,0,1200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,16168,0,1200,0,0,0,0,0,0,-254,1200,0,16168,0,0,0,0,0,0,0,12129,0,0,0,0,0,0,0,0,0,0,0,0,0,-4825,0,0,227,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-13869,-8856,19547,35715]
["RV3","CNWL","Central and North West London NHS Foundation Trust",0,null,11950,0,0,960,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,960,0,0,0,0,0,0,-719,0,0,0,0,960,0,0,0,0,0,0,0,0,0,0,0,0,-719,0,0,0,0,719,0,363,0,-8398,2,0,162,null,null,null,null,45315,"Stephanie Nartey ",45359,29000,null,"None",null,null,null,"None",null,null,null,"None",null,null,41,-25922,22982,23943]
["RV5","SLAM","South London and Maudsley NHS Foundation Trust",41.876811800000006,null,13602,0,0,1639,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1639,0,0,0,0,0,0,0,0,0,0,0,1639,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,63000,0,0,0,-5781,10,0,184,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,752,-16828,28788,30427]
["RV9","HUMBER","Humber Teaching NHS Foundation Trust",16.417090999999996,null,6083,0,0,3811,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3811,0,0,0,0,0,0,0,0,0,0,0,3811,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2081,0,0,30,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,18,-4917,14908,18719]
["RVJ","NORTHBRISTOL","North Bristol NHS Trust",143.34966119999999,null,18558,0,0,16056,0,0,0,0,0,0,0,0,0,0,-7323,0,0,16056,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16056,0,0,0,0,0,0,0,0,0,0,0,0,16056,0,0,0,0,0,0,0,0,0,0,0,16056,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2702,0,0,422,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,19,-20162,37424,63587]
["RVN","AVONHEALTH","Avon and Wiltshire Mental Health Partnership NHS Trust",23.387524000000013,null,3687,0,0,9576,0,0,0,0,0,0,0,0,0,0,3046,0,0,9576,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9576,0,0,0,0,0,0,0,0,0,0,0,0,9576,0,0,0,0,0,0,0,0,0,0,0,9576,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3709,0,0,94,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,6,-7525,5931,16413]
["RVR","EPSOM","Epsom and St Helier University Hospitals NHS Trust",114.40274839999998,null,11681,0,0,18476,0,0,14492,0,0,0,0,0,0,0,891,0,0,18476,0,0,14492,0,0,0,0,0,0,0,0,45482,0,0,0,0,0,0,0,0,0,0,18476,0,0,14492,0,45482,0,0,0,0,0,0,0,18476,14492,0,0,0,0,0,0,0,0,0,0,10976,-247,0,0,13316,0,0,0,45482,0,0,0,0,0,0,0,0,0,0,0,0,0,-7446,0,0,286,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-4452,-17883,34750,45557]
["RVV","EASTKENT","East Kent Hospitals University NHS Foundation Trust",301.99131899999941,null,21765,0,0,8058,0,0,754,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,8058,754,0,0,0,0,0,0,0,0,0,0,8025,0,0,0,754,0,0,0,95771,0,0,0,0,0,0,0,0,0,0,0,0,0,-9569,0,0,434,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-117436,84086,23627,31652]
["RVW","NORTHTEES","North Tees and Hartlepool NHS Foundation Trust",76.366729599999999,null,10021,0,0,17066,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,17066,0,0,0,0,0,0,-1088,0,0,0,0,17266,-200,0,0,0,0,0,0,0,0,0,0,0,-1088,0,0,0,0,1088,0,18002,0,-1966,166,0,173,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1023,-18268,18791,35856]
["RVY","SOUTHPORT","Southport And Ormskirk Hospital NHS Trust",12.752454,171,724,0,0,0,0,0,0,0,0,0,0,0,0,0,-272,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-2015,1231,-25580,-25580]
["RW1","HANTSPART","Southern Health NHS Foundation Trust",42.512542400000051,null,8879,0,0,3123,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3123,0,0,0,0,0,0,0,0,0,0,0,3123,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-6274,0,0,98,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,214,-25405,26275,32654]
["RW4","MERSEYCARE","Mersey Care NHS Foundation Trust",93.757837600000016,null,9700,0,0,18175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,18175,0,0,0,0,0,0,-2596,0,0,0,0,18175,0,0,0,0,0,0,0,0,0,0,0,0,-2596,0,0,0,0,2596,0,41671,0,-4296,272,0,82,null,null,null,null,45253,"Lynn Lowe",45327,50000,null,"None",null,null,null,"None",null,null,null,"None",null,null,11141,-23445,24531,43015]
["RW5","LANCASHIRECARE","Lancashire and South Cumbria NHS Foundation Trust",24.049050799999986,null,10703,0,0,3968,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3968,0,0,0,0,0,0,-2571,0,0,0,0,3968,0,0,0,0,0,0,0,0,0,0,0,0,-2571,0,0,0,0,2571,0,34657,0,-6790,94,0,94,null,null,null,null,45089,"Linda Glover (Mills & Reeve)",45099,5000,null,"None",null,null,null,"None",null,null,null,"None",null,null,48,-22320,11545,15403]
["RWA","HULL","Hull University Teaching Hospitals NHS Trust",111.49092480000014,null,15829,0,0,28961,0,0,0,0,0,0,0,0,0,0,12495,0,0,28961,0,0,0,0,0,0,-1260,0,0,0,0,0,0,0,0,0,0,-1260,0,0,0,0,28961,0,0,0,0,0,0,0,0,0,0,0,0,28961,0,0,0,0,0,0,-1260,0,0,0,0,28961,0,0,0,0,0,0,0,0,0,0,0,0,-1260,0,0,0,0,1260,0,5647,0,-9562,12,0,409,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,20,-19078,29876,59282]
["RWD","UNITEDLINCS","United Lincolnshire Hospitals NHS Trust",166.41706800000006,null,21002,0,0,32718,0,0,0,0,0,0,0,0,0,0,43975,0,0,32718,0,0,0,0,0,0,0,0,0,0,0,0,0,-805,0,0,0,0,0,0,0,0,32718,0,0,0,0,0,0,0,0,0,0,0,0,32718,0,0,0,0,0,0,0,0,-805,0,0,32718,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9328,0,0,328,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-20776,-28,26616,61084]
["RWE","LEICESTER","University Hospitals of Leicester NHS Trust",566.40779180000061,null,33580,0,0,53296,0,0,0,0,0,0,0,0,0,0,-11539,0,0,53296,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,53296,0,0,0,0,0,0,0,0,0,0,0,0,53296,0,0,0,0,0,0,0,0,0,0,0,53162,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-21151,0,0,706,null,null,null,null,44981,"Becky Hall (Mills & Reeve)",45021,2000,45152,"Samantha Sargeant (Browne Jacobson)",45364,15000,null,"None",null,null,null,"None",null,null,-52835,-1406,61781,114943]
["RWF","MAIDSTONE","Maidstone And Tunbridge Wells NHS Trust",190.25965919999999,null,10796,0,0,31851,0,0,6688,0,0,0,0,0,0,0,-11441,0,0,31851,0,0,6688,0,0,0,-974,0,0,0,0,0,0,-376,0,0,0,-974,0,0,0,0,31851,0,0,6688,0,0,0,0,0,0,0,0,0,31851,6688,0,0,0,0,0,-974,0,-376,0,0,31942,-91,0,0,6688,0,0,0,0,0,0,0,0,-974,0,0,0,0,964,0,2520,0,-6204,6,0,284,-8947,-9900,32442,6095,44984,"Liam Coleman",45029,12000,null,"None",null,null,null,"None",null,null,null,"None",null,null,9517,-29881,38531,76176]
["RWG","WESTHERTS","West Hertfordshire Teaching Hospitals NHS Trust",184.73864959999977,null,16301,0,0,50033,0,0,0,0,0,0,0,0,0,0,-1512,0,0,50033,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50033,0,0,0,0,0,0,0,0,0,0,0,0,50033,0,0,0,0,0,0,0,0,0,0,0,50033,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9612,0,0,232,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-13795,-5660,22286,72297]
["RWH","ENHERTS","East And North Hertfordshire NHS Trust",216.23206079999937,null,14684,0,0,8863,0,0,0,0,0,0,0,0,0,0,-1105,0,0,8863,0,0,0,0,0,0,-2588,0,0,0,0,0,0,0,0,0,0,-2588,0,0,0,0,8863,0,0,0,0,0,0,0,0,0,0,0,0,8863,0,0,0,0,0,0,-2588,0,0,0,0,8863,0,0,0,0,0,0,0,0,0,0,0,0,-2588,0,0,0,0,2588,0,30273,0,-4894,42,0,320,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,3202,-30770,30273,39280]
["RWJ","STOCKPORT","Stockport NHS Foundation Trust",56.30516320000001,null,14917,0,0,28608,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,28608,1000,0,0,0,0,0,-1551,0,0,0,0,28608,0,0,0,1000,0,0,0,5041,0,0,0,0,-1551,0,0,0,0,1551,0,13775,0,-5838,124,0,182,null,null,null,null,45042,"Tracey Etchells",45078,6000,null,"None",null,null,null,"None",null,null,null,"None",null,null,-32170,10802,24259,46595]
["RWK","EASTLONDON","East London NHS Foundation Trust",56.396697999999965,null,24901,0,0,6307,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,6307,0,0,0,0,0,0,0,0,0,0,0,6307,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-7509,0,0,156,null,null,null,null,44825,"Tanya Carter",45028,10306,44748,"Tanya Carter",45028,79217,null,"None",null,null,null,"None",null,null,3708,-27222,23269,30069]
["RWP","WORCESTERSHIRE","Worcestershire Acute Hospitals NHS Trust",263.01792079999973,null,11475,0,0,17185,0,0,0,0,0,0,0,0,0,0,6765,0,0,17185,0,0,0,0,0,0,-949,0,0,0,0,21000,0,0,0,0,0,-949,0,0,0,0,17185,0,0,0,0,21000,0,0,0,0,0,0,0,17185,0,0,0,0,0,0,-949,0,0,0,0,17185,0,0,0,0,0,0,0,21000,0,0,0,0,-949,0,0,0,0,668,0,8689,0,-9445,11,0,299,-4544,-13337,56176,30225,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-34761,17157,27003,45596]
["RWR","HERTSPART","Hertfordshire Partnership University NHS Foundation Trust",28.639167999999998,null,6189,0,0,2046,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,2046,0,0,0,0,0,0,-530,0,0,0,0,2046,0,0,0,0,0,0,0,0,0,0,0,0,-530,0,0,0,0,530,0,6879,0,-4143,9,0,86,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1990,-14309,14885,16931]
["RWV","DEVONPART","Devon Partnership NHS Trust",10.986924800000001,null,6699,0,0,5433,0,0,0,0,0,0,0,0,0,0,2585,0,0,5433,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5433,0,0,0,0,0,0,0,0,0,0,0,0,5433,0,0,0,0,0,0,0,0,0,0,0,5433,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2955,0,0,65,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,3300,-14546,7570,13003]
["RWW","WARRINGTON","Warrington and Halton Teaching Hospitals NHS Foundation Trust",72.12395260000001,null,10943,0,0,18118,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,18118,0,0,0,0,0,0,0,0,0,0,0,17701,0,0,0,0,0,0,0,7245,0,0,0,0,0,0,0,0,0,0,0,0,0,-5466,0,0,151,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-27527,11818,11782,29406]
["RWX","BERKSHIREHEALTH","Berkshire Healthcare NHS Foundation Trust",47.788197000000025,null,9021,0,0,265,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,265,0,0,0,0,0,0,0,0,0,0,0,265,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1078,0,0,73,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,3788,-14632,11981,13770]
["RWY","CALDERDALE","Calderdale & Huddersfield NHS Foundation Trust",120.91348800000003,null,12985,0,0,22711,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,22711,0,0,0,0,0,0,-2208,0,0,0,0,22711,0,0,0,0,0,0,0,8300,0,0,0,0,-2208,0,0,0,0,2208,0,11047,0,-2043,113,0,235,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-13240,11,31635,50281]
["RX1","NOTTINGHAM","Nottingham University Hospitals NHS Trust",262.42129939999961,null,42543,0,0,76365,0,0,22462,0,0,0,0,0,0,0,7847,0,0,76365,0,0,22462,0,0,0,-570,0,0,0,0,39373,0,0,0,0,0,-570,0,0,0,0,76365,0,0,22462,0,39373,0,0,0,0,0,0,0,76365,22462,0,0,0,0,0,-570,0,0,0,0,76341,-7484,0,0,22462,0,0,0,39373,0,0,0,0,-570,0,0,0,0,570,0,6248,0,-20997,13,0,739,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-70955,26855,66326,135317]
["RX2","SUSSEXPART","Sussex Partnership NHS Foundation Trust",48.744809599999968,null,6559,0,0,19910,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,19910,0,0,0,0,0,0,0,0,0,0,0,19910,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2844,0,0,111,null,null,null,null,45163,"Corin Ansted",45330,15000,null,"None",null,null,null,"None",null,null,null,"None",null,null,23,-14632,9651,30257]
["RX3","TEWVALLEYS","Tees, Esk and Wear Valleys NHS Foundation Trust",15.900543999999996,null,3601,0,0,2752,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,2752,0,0,0,0,0,0,0,0,0,0,0,2752,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2909,0,0,116,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,4,5459,15779,18860]
["RX4","NORTHUMBERLAND","Cumbria, Northumberland, Tyne and Wear NHS Foundation Trust",8.3481556000000001,null,2432,0,0,5008,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,5008,0,0,0,0,0,0,-2549,0,0,0,0,5008,0,0,0,0,0,0,0,0,0,0,0,0,-2549,0,0,0,0,2549,0,34086,0,-830,165,0,151,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,58,-10337,10790,17660]
["RX6","NORTHEASTAMB","North East Ambulance Service NHS Foundation Trust",16.786467999999996,null,8849,0,0,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,80,0,0,0,0,0,0,0,0,0,0,0,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-736,0,0,0,null,null,null,null,45216,"Karen O'Brian",45273,6500,null,"None",null,null,null,"None",null,null,null,"None",null,null,50,-8634,12248,12328]
["RX7","NWESTAMB","North West Ambulance Service NHS Trust",77.671473600000013,null,19267,0,0,520,0,0,0,0,0,0,0,0,0,0,1826,0,0,520,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,520,0,0,0,0,0,0,0,0,0,0,0,0,520,0,0,0,0,0,0,0,0,0,0,0,520,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-434,0,0,0,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,5847,-27581,27920,28440]
["RX8","YORKSHIREAMB","Yorkshire Ambulance Service NHS Trust",90.542967000000019,null,14704,0,0,1036,0,0,0,0,0,0,0,0,0,0,12000,0,0,1036,0,0,0,0,0,0,-334,0,0,0,0,0,0,0,0,0,0,-334,0,0,0,0,1036,0,0,0,0,0,0,0,0,0,0,0,0,1036,0,0,0,0,0,0,-334,0,0,0,0,1036,0,0,0,0,0,0,0,0,0,0,0,0,-334,0,0,0,0,334,0,2497,0,-2148,2,0,0,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,51,-12329,26888,27924]
["RX9","EASTMIDLANDSAMB","East Midlands Ambulance Service NHS Trust",23.943200000000001,null,8871,0,0,103,0,0,0,0,0,0,0,0,0,0,155,0,0,103,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,103,0,0,0,0,0,0,0,0,0,0,0,0,103,0,0,0,0,0,0,0,0,0,0,0,103,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2235,0,0,0,null,null,null,null,44987,"Samantha Sargeant ",45029,7000,null,"None",null,null,null,"None",null,null,null,"None",null,null,72,-11898,15653,15756]
["RXA","CWPART","Cheshire and Wirral Partnership NHS Foundation Trust",2.4156519999999997,null,2142,0,0,3408,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3408,0,0,0,0,0,0,0,0,0,0,0,3408,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2131,0,0,69,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,261,-3885,5073,8481]
["RXC","EASTSUSSEX","East Sussex Healthcare NHS Trust",636.1100349999997,null,23292,0,0,28019,0,0,0,0,0,0,0,0,0,0,-26389,0,0,28019,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,28019,0,0,0,0,0,0,0,0,0,0,0,0,28019,0,0,0,0,0,0,0,0,0,0,0,27522,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9968,0,0,230,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-5004,-17561,40156,67928]
["RXE","RDASH","Rotherham Doncaster and South Humber NHS Foundation Trust",18.711339200000001,null,5842,0,0,1675,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1675,0,0,0,0,0,0,-363,0,0,0,0,1675,0,0,0,0,0,0,0,0,0,0,0,0,-363,0,0,0,0,363,0,3478,0,-2041,6,0,38,null,null,null,null,45244,"Nicola McIntosh",45278,14083.58,null,"None",null,null,null,"None",null,null,null,"None",null,null,-3549,-2923,6368,8843]
["RXF","MIDYORKS","Mid Yorkshire Hospitals NHS Trust",243.81429919999988,null,12346,0,0,20574,0,0,2822,0,0,0,0,0,0,0,-4114,0,0,20574,0,0,2822,0,0,0,-1000,0,0,0,0,14517,0,-386,0,0,0,-1000,0,0,0,0,20574,0,0,2822,0,14517,0,0,0,0,0,0,0,20574,2822,0,0,0,0,0,-1000,0,-386,0,0,20574,0,0,0,2822,0,0,0,13200,0,0,0,0,-1000,0,0,0,0,1000,0,500,0,-3541,2,0,323,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-5792,-14415,17188,40921]
["RXG","SWYORKSPART","South West Yorkshire Partnership NHS Foundation Trust",16.791872799999997,null,6531,0,0,39,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,39,0,0,0,0,0,0,0,0,0,0,0,39,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1765,0,0,78,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,540,-14096,14767,14806]
["RXK","SANDWELL","Sandwell And West Birmingham Hospitals NHS Trust",160.17759720000006,null,20054,0,0,44209,0,0,0,0,0,0,0,0,0,0,23175,0,0,44209,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,44209,0,0,0,0,0,0,0,0,0,0,0,0,44209,0,0,0,0,0,0,0,0,0,0,0,44209,-1490,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-5016,0,0,266,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-14079,-9814,22036,66888]
["RXL","BLACKPOOL","Blackpool Teaching Hospitals NHS Foundation Trust",160.72628599999976,null,16133,0,0,22240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,22240,0,0,0,0,0,0,-1771,0,0,0,0,22240,0,0,0,0,0,0,0,24278,0,0,0,0,-1771,0,0,0,0,1771,0,18416,0,-4895,58,0,191,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-625,-24265,23681,41934]
["RXM","DERBYSHIREHEALTH","Derbyshire Healthcare NHS Foundation Trust",3.1485999999999992,null,5004,0,0,50263,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,50263,0,0,0,0,0,0,0,0,0,0,0,50263,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-4038,0,0,60,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-4588,-2759,20350,71078]
["RXN","LANCSTEACH","Lancashire Teaching Hospitals NHS Foundation Trust",141.19052099999988,null,20934,0,0,35799,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,35799,0,0,0,0,0,0,-1575,0,0,0,0,35689,-350,0,0,0,0,0,0,72606,-14272,0,0,0,-1575,0,0,0,0,1108,0,1763,0,-10269,8,0,371,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-35567,2145,23893,59582]
["RXP","DARLINGTON","County Durham and Darlington NHS Foundation Trust",123.49410980000003,null,683,0,0,3550,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,3550,0,0,0,0,0,0,0,0,0,0,0,3550,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1923,0,0,285,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,44,-3478,17966,26848]
["RXQ","BUCKSHEALTH","Buckinghamshire Healthcare NHS Trust",217.24304000000001,null,15707,0,0,35014,0,0,5640,0,0,0,0,0,0,0,9709,0,0,35014,0,0,5640,0,0,0,0,0,0,0,0,12750,0,0,0,0,0,0,0,0,0,0,35014,0,0,5640,0,12750,0,0,0,0,0,0,0,35014,5640,0,0,0,0,0,0,0,0,0,0,35014,0,0,0,0,0,0,0,6400,0,0,0,0,0,0,0,0,0,0,0,0,0,-9205,0,0,256,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-5546,-11492,23011,58026]
["RXR","EASTLANCS","East Lancashire Hospitals NHS Trust",123.84050399999998,null,8871,0,0,7949,0,0,5246,0,0,0,0,0,0,0,12423,0,0,7949,0,0,5246,0,0,0,-200,0,0,0,0,39111,0,0,0,0,0,-200,0,0,0,0,7949,0,0,5246,0,39111,0,0,0,0,0,0,0,7949,5246,0,0,0,0,0,-200,0,0,0,0,7949,0,0,0,5246,0,0,0,35631,-17576,0,0,0,-200,0,0,0,0,200,0,0,0,-5464,0,0,290,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-15449,6361,15954,26278]
["RXT","BIRMSOLIHULL","Birmingham and Solihull Mental Health NHS Foundation Trust",63.981836800000004,null,3513,0,0,500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,500,0,0,0,0,0,0,-2183,0,0,0,0,500,0,0,0,0,0,0,0,0,0,0,0,0,-2183,0,0,0,0,2182,0,22959,0,314,417,0,102,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,2670,-9021,8601,9756]
["RXV","GMWEST","Greater Manchester Mental Health NHS Foundation Trust",49.086905199999997,null,14162,0,0,66877,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,66877,0,0,0,0,0,0,-1577,0,0,0,0,66877,0,0,0,0,0,0,0,0,0,0,0,0,-1577,0,0,0,0,1578,0,19796,0,-5012,97,0,104,null,null,null,null,45174,"Katie Robb",45278,9000,null,"None",null,null,null,"None",null,null,null,"None",null,null,410,-23085,31058,97935]
["RXW","SHREWSBURY","Shrewsbury and Telford Hospital NHS Trust",190.21044419999996,null,21713,0,0,58813,0,0,6400,0,0,0,0,0,0,0,-172,0,0,58813,0,0,6400,0,0,0,0,0,0,0,0,119262,0,0,0,0,0,0,0,0,0,0,58813,0,0,6400,0,119262,0,0,0,0,0,0,0,58813,6400,0,0,0,0,0,0,0,0,0,0,58813,0,0,0,6400,0,0,0,103667,0,0,0,0,0,0,0,0,0,0,0,0,0,-10418,0,0,234,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-54582,31655,20055,78668]
["RXX","SURREYPART","Surrey and Borders Partnership NHS Foundation Trust",5.3412383999999982,null,15897,0,0,19288,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,19288,0,0,0,0,0,0,0,0,0,0,0,19288,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-4100,0,0,98,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-4974,-14548,39180,58468]
["RXY","KENTMEDWAY","Kent and Medway NHS and Social Care Partnership Trust",32.984856000000015,null,8349,0,0,3082,0,0,0,0,0,0,0,0,0,0,-503,0,0,3082,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3082,0,0,0,0,0,0,0,0,0,0,0,0,3082,0,0,0,0,0,0,0,0,0,0,0,3082,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3426,0,0,85,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1043,-11555,17059,20414]
["RY2","BRIDGEWATER","Bridgewater Community Healthcare NHS Foundation Trust",104.33178120000011,null,1693,0,0,344,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,344,0,0,0,0,0,0,0,0,0,0,0,344,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-130,0,0,9,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,4,-4778,6323,6667]
["RY3","NORFOLKCOMM","Norfolk Community Health and Care NHS Trust",23.703111999999987,null,7098,0,0,22115,0,0,0,0,0,0,0,0,0,0,1599,0,0,22115,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22115,0,0,0,0,0,0,0,0,0,0,0,0,22115,0,0,0,0,0,0,0,0,0,0,0,22115,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1411,0,0,9,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,167,-4549,7174,26942]
["RY4","HERTSCOMM","Hertfordshire Community NHS Trust",82.764166000000017,null,4273,0,0,39,0,0,0,0,0,0,0,0,0,0,-2779,0,0,39,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,39,0,0,0,0,0,0,0,0,0,0,0,0,39,0,0,0,0,0,0,0,0,0,0,0,39,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-780,0,0,9,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,780,-6287,11442,11442]
["RY5","LINCSCOMM","Lincolnshire Community Health Services NHS Trust",24.9673616,null,1920,0,0,60,0,0,0,0,0,0,0,0,0,0,3199,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1431,-2372,15929,15929]
["RY6","LEEDSCOMM","Leeds Community Healthcare NHS Trust",80.465423999999999,null,2826,0,0,1748,0,0,0,0,0,0,0,0,0,0,-7397,0,0,1748,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1748,0,0,0,0,0,0,0,0,0,0,0,0,1748,0,0,0,0,0,0,0,0,0,0,0,1748,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-255,0,0,22,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,265,-9756,14120,15868]
["RY7","WIRRALCOMM","Wirral Community Health and Care NHS Foundation Trust",7.7616719999999972,null,3612,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1434,0,0,0,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1205,-5892,4270,4270]
["RY8","DERBYSHIRECOMMUNITY","Derbyshire Community Health Services NHS Foundation Trust",38.101175000000019,null,4865,0,0,13128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,13128,0,0,0,0,0,0,0,0,0,0,0,13118,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2048,0,0,3,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-2579,-5370,9020,22138]
["RY9","HOUNSLOWCOMM","Hounslow and Richmond Community Healthcare NHS Trust",0,null,2074,0,0,0,0,0,0,0,0,0,0,0,0,0,-3595,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-691,0,0,4,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,522,-6484,2041,2041]
["RYA","WESTMIDLANDSAMB","West Midlands Ambulance Service University NHS Foundation Trust",33.690220800000013,null,17579,0,0,617,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,617,0,0,0,0,0,0,0,0,0,0,0,617,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1596,0,0,0,null,null,null,null,45138,"Clare Swindells (NHSE)",45148,11000,45079,"Clare Swindells / Emma Bogle (NHSE)",45099,10000,null,"None",null,null,null,"None",null,null,1795,-29129,18038,18655]
["RYC","EASTENGLANDAMB","East of England Ambulance Service NHS Trust",55.373765000000006,null,12822,0,0,1154,0,0,0,0,0,0,0,0,0,0,-12790,0,0,1154,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1154,0,0,0,0,0,0,0,0,0,0,0,0,1154,0,0,0,0,0,0,0,0,0,0,0,1154,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,313,0,0,0,null,null,null,null,45184,"Gemma Lynch (Browne Jacobson)",45278,5000,45082,"Gemma Lynch (Browne Jacobson)",45152,15000,45015,"Amy Warnock ",45021,15000,null,"None",null,null,487,-20905,29019,30173]
["RYD","SECOASTAMB","South East Coast Ambulance Service NHS Foundation Trust",30.295799999999996,null,10697,0,0,333,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,333,0,0,0,0,0,0,0,0,0,0,0,333,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-816,0,0,0,null,null,null,null,45190,"Dawn Chilcott",45278,41000,null,"None",null,null,null,"None",null,null,null,"None",null,null,4,-23521,17727,18059]
["RYE","SCENTRALAMB","South Central Ambulance Service NHS Foundation Trust",112.79854800000001,null,10280,0,0,772,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,772,0,0,0,0,0,0,0,0,0,0,0,571,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1671,0,0,0,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-21755,4626,10974,11545]
["RYF","SWESTAMB","South Western Ambulance Service NHS Foundation Trust",115.54835199999997,null,17876,0,0,1786,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1786,0,0,0,0,0,0,0,0,0,0,0,1786,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2237,0,0,0,null,null,null,null,45327,"Bisi Owolabi (NHSE)",45352,26500,null,"None",null,null,null,"None",null,null,null,"None",null,null,83,-15697,21576,23362]
["RYG","COVENTRYPART","Coventry and Warwickshire Partnership NHS Trust",45.91004920000001,null,5320,0,0,2011,0,0,0,0,0,0,0,0,0,0,-1389,0,0,2011,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2011,0,0,0,0,0,0,0,0,0,0,0,0,2011,0,0,0,0,0,0,0,0,0,0,0,2011,-429,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-3478,0,0,64,null,null,null,null,44981,"Julie Morris",45063,9000,null,"None",null,null,null,"None",null,null,null,"None",null,null,197,-7489,10694,12705]
["RYJ","IMPERIAL","Imperial College Healthcare NHS Trust",688.34219760000019,null,55986,0,0,15620,0,0,0,0,0,0,0,0,0,0,42824,0,0,15620,0,0,0,0,0,0,-1226,0,0,0,0,0,0,-551,0,0,0,-1226,0,0,0,0,15620,0,0,0,0,0,0,0,0,0,0,0,0,15620,0,0,0,0,0,0,-1226,0,-551,0,0,15620,0,0,0,0,0,0,0,0,0,0,0,0,-1226,0,0,0,0,1226,0,7336,0,-11941,15,0,656,null,null,null,null,45134,"Louise Clarke ",45278,20125,null,"None",null,null,null,"None",null,null,null,"None",null,null,30,-80495,67505,83124]
["RYK","DUDLEYHEALTH","Dudley Integrated Health and Care NHS Trust",0,null,310,0,0,0,0,0,0,0,0,0,0,0,0,0,389,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1149,-1704,186,186]
["RYR","WESTERNSUSSEX","University Hospitals Sussex NHS Foundation Trust ",411.56622400000009,null,38666,0,0,34235,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,34235,0,0,0,0,0,0,-3740,0,0,0,0,32502,0,0,0,0,0,0,0,0,0,0,0,0,-3740,0,0,0,-500,3741,0,37030,0,-23316,141,0,684,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-14952,-27091,43778,77294]
["RYV","CAMBCOMM","Cambridgeshire Community Services NHS Trust",10.247339199999999,null,3779,0,0,12748,0,0,0,0,0,0,0,0,0,0,-3101,0,0,12748,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12748,0,0,0,0,0,0,0,0,0,0,0,0,12748,0,0,0,0,0,0,0,0,0,0,0,12748,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2729,0,0,31,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,0,-5523,8536,27535]
["RYW","BIRMCOMM","Birmingham Community Healthcare NHS Foundation Trust",92.086455999999913,null,4180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-549,0,0,60,null,null,null,null,45306,"John Hatton (Capsticks)",45329,39737.5,null,"None",null,null,null,"None",null,null,null,"None",null,null,669,-12013,10709,10709]
["RYX","CLONDONCOMM","Central London Community Healthcare NHS Trust",0,null,9782,0,0,240,0,0,0,0,0,0,0,0,0,0,-11067,0,0,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,240,0,0,0,0,0,0,0,0,0,0,0,0,240,0,0,0,0,0,0,0,0,0,0,0,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,700,0,0,11,null,null,null,null,44970,"Louella Johnson",45064,20000,null,"None",null,null,null,"None",null,null,null,"None",null,null,24,-22556,10247,10487]
["RYY","KENTCOMM","Kent Community Health NHS Foundation Trust",54.546140799999996,null,9089,0,0,1752,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,1752,0,0,0,0,0,0,0,0,0,0,0,1744,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1158,0,0,17,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,12036,-26633,14434,16178]
["TAD","BRADFORDCARE","Bradford District Care NHS Foundation Trust",308.51437279999988,null,2759,0,0,899,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,899,0,0,0,0,0,0,0,0,0,0,0,899,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-680,0,0,43,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,1215,-6476,8881,9791]
["TAF","CAMDEN","Camden and Islington NHS Foundation Trust",0,null,7139,0,0,4259,0,0,0,0,38063,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,4259,0,0,0,0,0,38063,0,0,0,0,0,4259,0,0,0,0,0,0,0,0,0,0,0,0,0,38063,0,0,0,0,0,39967,0,-6455,62,0,60,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,709,-7773,12814,54955]
["TAH","SHEFFIELDHEALTH","Sheffield Health and Social Care NHS Foundation Trust",22.468288000000001,null,2825,0,0,2402,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,2402,0,0,0,0,0,0,0,0,0,0,0,2402,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2634,0,0,31,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,-4928,1693,8790,11192]
["TAJ","SANDWELLCARE","Black Country Healthcare NHS Foundation Trust",111.66720100000002,null,5905,0,0,38113,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,38113,0,0,0,0,0,0,0,0,0,0,0,38113,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2731,0,0,77,null,null,null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,null,"None",null,null,255,-11185,5387,44688]
["X04","OLDSUSSEXCOMM","Sussex Community NHS Trust"]

{"sheet":"Settings","index":3,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":true,"merged":[[3,4,5,4],[36,1,36,5],[47,1,47,5]]}
[null,null,null,null,null,null,null,"FixType",null,null,null,"Versions",null,null,null,"Tool Types"]
[null,"Template Metadata",null,null,null,null,null,"AddColumn",null,"i",null,"1.23.12.0",null,"i",null,"Compiler"]
[null,null,null,null,null,null,null,"AddHyperlink",null,null,null,"1.23.12.1",null,null,null,"Customiser"]
[null,"SysYear:","FY2023-24",null,"i",null,null,"AddRow",null,null,null,"1.23.12.1A",null,null,null,"External Fixer"]
[null,"sysPeriod:","M12",null,null,null,null,"AddValidationList",null,null,null,"1.23.12.1B",null,null,null,"Internal Fixer"]
[null,"SysType:","PFR/TAC",null,null,null,null,"AddValidationText",null,null,null,null,null,null,null,"Validator"]
[null,"File Suffix:"," - Updated.xlsm",null,"i",null,null,"ChangeCellStyle"]
[null,"Final Version:",{"$f":"INDEX(L2:L6,MATCH(COUNTA(L2:L6)-1,INDEX(COUNTIF(L2:L6,\"<\"&L2:L6),0),0))","v":"1.23.12.1B"},null,"i",null,null,"ChangeRangeStyle"]
[null,null,null,null,null,null,null,"ChangeRangeStyleForAllCells"]
[null,null,null,null,null,null,null,"ChangeValidationText"]
[null,"Customiser Settings",null,null,null,null,null,"ClearCell"]
[null,null,null,null,null,null,null,"ClearContents"]
[null,"Run Customiser:","Yes",null,"i",null,null,"CopyBackColour"]
[null,"Ignore Blanks in Customiser:","Yes",null,"i",null,null,"CopyFormat"]
[null,null,null,null,null,null,null,"CopyFormula"]
[null,null,null,null,null,null,null,"CopyNewHideList"]
[null,"Template Version Settings",null,null,null,null,null,"CopyNewTable"]
[null,null,null,null,null,null,null,"CopyWorksheet"]
[null,"Save File with Original Name:","No",null,"i",null,null,"DeleteColumn"]
[null,"Open Template as Read Only;","No",null,"i",null,null,"DeleteRow"]
[null,"Update Version on Template:","Yes",null,"i",null,null,"DeleteWorksheet"]
[null,null,null,null,null,null,null,"Divide1000"]
[null,null,null,null,null,null,null,"Format"]
[null,"Database Settings",null,null,null,null,null,"Formula"]
[null,null,null,null,null,null,null,"Formularise"]
[null,null,null,null,null,null,null,"HideColumnX"]
[null,null,null,null,null,null,null,"HideRow"]
[null,null,4,null,null,null,null,"HideSheet"]
[null,null,null,null,null,null,null,"HideShowRow"]
[null,"SQL Server Name:",{"$f":"CHOOSE(SQLConn,\"apsc2a-ctl01.apspr3.irnhsft.local,17001\",\"apsc2a-ctl01.apspr3.irnhsft.local,17001\",\"apsc2a-ctl01.apspr3.irnhsft.local,17001\",\"apsc1a-ctl01.apspr1.irnhsft.local,17001\")","v":"apsc1a-ctl01.apspr1.irnhsft.local,17001"},null,"i",null,null,"HideShowWS"]
[null,"SQL Database Name:",{"$f":"CHOOSE(SQLConn,\"DEV_SIP_DATASTORE\",\"SIT_SIP_DATASTORE\",\"UAT_SIP_DATASTORE\",\"PROD_SIP_DATASTORE\")","v":"PROD_SIP_DATASTORE"},null,"i",null,null,"InsertCells"]
[null,"Timeout:",0,null,null,null,null,"Lock"]
[null,null,null,null,null,null,null,"Message"]
[null,null,null,null,null,null,null,"NamedRange"]
[null,"Trust List Settings",null,null,null,null,null,"NumberFormat"]
[null,null,null,null,null,null,null,"Protect"]
[null,"Region",null,null,null,null,null,"Remove_Borders"]
[null,null,null,null,null,null,null,"RemoveDataValidation"]
[null,"London","Yes",null,null,null,null,"RenameWorksheet"]
[null,"South West","Yes",null,null,null,null,"RowHeight"]
[null,"South East","Yes",null,null,null,null,"Text"]
[null,"Midlands","Yes",null,null,null,null,"Unlock"]
[null,"East of England","Yes",null,null,null,null,"UnMerge"]
[null,"North West","Yes",null,null,null,null,"ValidationMaxMin"]
[null,"North East and Yorikshire","Yes",null,null,null,null,"WrapText"]
[null,"Adjustment","Yes"]
[null,null,"Yes"]
[null,"Sector"]
[]
[null,"Mental Health","Yes"]
[null,"Acute","Yes"]
[null,"Specialist","Yes"]
[null,"Community","Yes"]
[null,"Ambulance","Yes"]
[]
[null,"Trust Type:","ALL"]
[null,"Order By:","MARSID"]
[null,"Include Inactive Trusts:","No"]

{"sheet":"New Tables","index":4,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":true,"merged":[[52,2,52,4],[52,5,52,6],[55,0,57,0],[36,7,49,7],[36,8,49,8],[37,2,37,4],[37,5,37,6],[38,2,38,4],[38,5,38,6],[39,2,39,4],[42,2,42,4],[42,5,42,6],[36,1,49,1],[36,2,36,4],[36,5,36,6],[39,5,39,6],[40,2,40,4],[40,5,40,6],[41,2,41,4],[41,5,41,6],[48,5,48,6],[49,5,49,6],[43,2,43,4],[43,5,43,6],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6]]}
["HIDE"]
[3]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
[4]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
[]
[]
["NHS England (including central pay award funding)"]
[]
["National estimate values were provided within the guidance emailed to organisations by the Financial Reporting and Development team (sector reporting mailbox) on 25 March 2024."]
[]
[]
[]
[]
[null,"Test 10 - Application of IFRS 16 to PFI schemes","Guidance for NHS providers including the optional DHSC model and the NHS England FAQs are published on NHS England's IFRS 16 webpage.",null,null,"Link to NHS England IFRS 16 webpage",null,"Yes","Yes"]
[null,null,"1 April transition remeasurement (reserve movement) and in-year remeasurement (finance cost) should be separately ntered by providers within Note 29.1 'Reconciliation of movement in liabilities arising from financing activities' on TAC21. These new rows are highlighted purple for ease of reference.",null,null,"~HYPERLINK(\"#\"&@CELL(\"address\",'TAC21 Borrowings'!B159),\"Go to Note 29.1\")"]
[null,null,"Validation 124 will fail where a provider is continuing to recognise contingent rent indicating that remeasurement under IFRS 16 has not been recognised. (Where a provider has verified to NHS England that the impact of IFRS 16 is immaterial this validation will pass).",null,null,"~HYPERLINK(\"#\"&@CELL(\"address\",'TAC Validations'!B1303),\"Validation \"&'TAC Validations'!B1303)"]
[null,null,"JoCs 45 and 46 review the expected direction and split of transition and in-year remeasurements",null,null,"~HYPERLINK(\"#\"&@CELL(\"address\",'TAC JoCs'!C757),\"JoCs \"&'TAC JoCs'!B763&\" to \"&'TAC JoCs'!B772)"]
[null,null,"JoC 49 checks that the year on year movement in the gross and net PFI liability disclosed is consistent. Where previous commitments for the gross imputed lease liability included contingent rent in error the prior year should be restated.",null,null,"~HYPERLINK(\"#\"&@CELL(\"address\",'TAC JoCs'!C798),\"JoC 49\")"]
[null,null,"Notes 33.4 and 33.5 on TAC24 collect information on the impact of applying IFRS 16 to PFI liabilities in 2023/24. These tables are designed to meet the requirements of IAS 8.",null,null,"~HYPERLINK(\"#\"&@CELL(\"address\",'TAC24 On-SoFP PFI'!B138),\"Go to Note 33.4 and 33.5\")"]
[null,null,"Validations 125 to 127 check common errors in completion of Notes 33.4 and 33.5.",null,null,"~HYPERLINK(\"#\"&@CELL(\"address\",'TAC Validations'!B1314),\"Validations 125 to 127\")"]
[null,null,"JoCs 58 and 78 review common errors in completion of Notes 33.4 and 33.5.",null,null,"~HYPERLINK(\"#\"&@CELL(\"address\",'TAC JoCs'!C911),\"JoCs 58 and 78\")"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
["HIDE"]
[]
[]
[null,"Test 13 - Regularity (additional considerations)","N/A",null,null,null,null,"Yes","Yes"]
[]
[]
["Test 12 - Completeness and regularity of special payments"]
[]
[]
["Test 13 - Regularity (additional considerations)"]
["Test 14 - Irregularity due to fraud within the health and social care system"]
["Test 15 - Reporting of findings and errors"]
[]
[]
["Reduction in contingent rent (including amounts recognised in service costs)"]
[]
["22 April fixer update: The formula in row 173 has been updated to include reductions in service costs (misclassified contingent rent). "]
["If you previously compensated for this by including the movement in another editable cell, please remove that manual adjustment."]

{"sheet":"NewHideList","index":5,"n_rows":1191,"n_cols":3,"rows_kept":1191,"cut":false,"hidden":true,"merged":[]}
["Worksheet","Range","Type"]
["Cover","23:24","HIDEROWFormula"]
["Cover","27:27","HIDEROWFormula"]
["Cover","70:96","HIDEROW"]
["Cover","99:104","HIDEROW"]
["Index","8:181","HIDEROWFormula"]
["Index","182:183","HIDEROW"]
["Index","184:201","HIDEROWFormula"]
["Index","202:205","HIDEROW"]
["Index","206:213","HIDEROWFormula"]
["Index","221:339","HIDEROWFormula"]
["Index","340:342","HIDEROW"]
["Index","J:J","HIDECOL"]
["Information","13:18","HIDEROWFormula"]
["Information","21:24","HIDEROWFormula"]
["Information","43:46","HIDEROWFormula"]
["Information","47:47","HIDEROW"]
["Information","48:48","HIDEROW"]
["Information","49:54","HIDEROWFormula"]
["Information","65:65","HIDEROWFormula"]
["Information","67:67","HIDEROWFormula"]
["TACs >>>",null,"SheetFormula"]
["TAC Validations",null,"SheetFormula"]
["TAC Validations","354:354","HIDEROW"]
["TAC Validations","355:355","HIDEROW"]
["TAC Validations","356:356","HIDEROW"]
["TAC Validations","357:361","HIDEROW"]
["TAC Validations","939:939","HIDEROW"]
["TAC Validations","942:945","HIDEROW"]
["TAC Validations","946:948","HIDEROW"]
["TAC Validations","1413:1413","HIDEROW"]
["TAC Validations","1414:1414","HIDEROW"]
["TAC Validations","1449:1449","HIDEROW"]
["TAC Validations","1450:1450","HIDEROW"]
["TAC Validations","1451:1451","HIDEROW"]
["TAC Validations","1452:1452","HIDEROW"]
["TAC Validations","1453:1453","HIDEROW"]
["TAC Validations","1454:1480","HIDEROW"]
["TAC Validations","1602:1602","HIDEROW"]
["TAC Validations","1615:1616","HIDEROW"]
["TAC Validations","1639:1639","HIDEROW"]
["TAC Validations","1652:1653","HIDEROW"]
["TAC Validations","1681:1686","HIDEROW"]
["TAC Validations","1687:1688","HIDEROW"]
["TAC Validations","1995:1995","HIDEROW"]
["TAC Validations","2009:2009","HIDEROW"]
["TAC Validations","2023:2023","HIDEROW"]
["TAC Validations","2037:2037","HIDEROW"]
["TAC Validations","2051:2051","HIDEROW"]
["TAC Validations","2065:2065","HIDEROW"]
["TAC Validations","2079:2079","HIDEROW"]
["TAC Validations","2093:2093","HIDEROW"]
["TAC Validations","2107:2107","HIDEROW"]
["TAC Validations","2122:2122","HIDEROW"]
["TAC Validations","2137:2137","HIDEROW"]
["TAC Validations","2152:2152","HIDEROW"]
["TAC Validations","2167:2167","HIDEROW"]
["TAC Validations","2182:2182","HIDEROW"]
["TAC Validations","2197:2197","HIDEROW"]
["TAC Validations","2212:2212","HIDEROW"]
["TAC Validations","2227:2227","HIDEROW"]
["TAC Validations","2244:2244","HIDEROW"]
["TAC Validations","2261:2261","HIDEROWFormula"]
["TAC Validations","2292:2295","HIDEROW"]
["TAC Validations","2296:2298","HIDEROW"]
["TAC JoCs",null,"SheetFormula"]
["TAC JoCs","51:56","HIDEROW"]
["TAC JoCs","398:411","HIDEROWFormula"]
["TAC JoCs","1184:1184","HIDEROW"]
["TAC JoCs","1185:1185","HIDEROW"]
["TAC00 - IFRS 16 Transition",null,"Sheet"]
["TAC01 Confirmations",null,"SheetFormula"]
["TAC01A Confirmations",null,"Sheet"]
["TAC02 SoCI",null,"SheetFormula"]
["TAC02 SoCI","8:9","HIDEROW"]
["TAC02 SoCI","36:36","HIDEROWFormula"]
["TAC02 SoCI","46:48","HIDEROW"]
["TAC02 SoCI","62:64","HIDEROW"]
["TAC02 SoCI","74:74","HIDEROW"]
["TAC02 SoCI","75:76","HIDEROWFormula"]
["TAC02 SoCI","82:82","HIDEROW"]
["TAC02 SoCI","84:84","HIDEROW"]
["TAC02 SoCI","86:86","HIDEROWFormula"]
["TAC02 SoCI","E:E","HIDECOL"]
["TAC02A MON SoCI",null,"Sheet"]
["TAC03 SoFP",null,"SheetFormula"]
["TAC03 SoFP","8:8","HIDEROW"]
["TAC03 SoFP","10:10","HIDEROW"]
["TAC03 SoFP","C:C","HIDECOL"]
["TAC03 SoFP","E:E","HIDECOL"]
["TAC04 SOCIE",null,"SheetFormula"]
["TAC04 SOCIE","9:10","HIDEROW"]
["TAC04 SOCIE","14:15","HIDEROW"]
["TAC04 SOCIE","17:18","HIDEROW"]
["TAC04 SOCIE","20:20","HIDEROWFormula"]
["TAC04 SOCIE","22:23","HIDEROW"]
["TAC04 SOCIE","40:40","HIDEROW"]
["TAC04 SOCIE","48:48","HIDEROW"]
["TAC04 SOCIE","57:58","HIDEROW"]
["TAC04 SOCIE","64:64","HIDEROW"]
["TAC04 SOCIE","66:66","HIDEROW"]
["TAC04 SOCIE","68:68","HIDEROWFormula"]
["TAC04 SOCIE","70:71","HIDEROW"]
["TAC04 SOCIE","88:88","HIDEROW"]
["TAC04 SOCIE","96:96","HIDEROW"]
["TAC04 SOCIE","102:103","HIDEROW"]
["TAC04 SOCIE","115:116","HIDEROWFormula"]
["TAC04 SOCIE","E:E","HIDECOL"]
["TAC05 SoCF",null,"SheetFormula"]
["TAC05 SoCF","10:12","HIDEROW"]
["TAC05 SoCF","79:79","HIDEROW"]
["TAC05 SoCF","88:90","HIDEROW"]
["TAC05 SoCF","95:95","HIDEROW"]
["TAC05 SoCF","96:96","HIDEROWFormula"]
["TAC05 SoCF","119:119","HIDEROW"]
["TAC05 SoCF","120:120","HIDEROWFormula"]
["TAC05 SoCF","131:131","HIDEROW"]
["TAC05 SoCF","132:132","HIDEROWFormula"]
["TAC05 SoCF","143:143","HIDEROW"]
["TAC05 SoCF","162:164","HIDEROW"]
["TAC05 SoCF","208:210","HIDEROW"]
["TAC05 SoCF","218:218","HIDEROWFormula"]
["TAC05 SoCF","230:230","HIDEROW"]
["TAC05 SoCF","235:237","HIDEROW"]
["TAC05 SoCF","244:245","HIDEROWFormula"]
["TAC05 SoCF","E:E","HIDECOL"]
["TAC05A SoCF MI rec",null,"SheetFormula"]
["TAC05A SoCF MI rec","10:11","HIDEROW"]
["TAC05A SoCF MI rec","35:35","HIDEROW"]
["TAC05A SoCF MI rec","55:55","HIDEROW"]
["TAC05A SoCF MI rec","72:72","HIDEROW"]
["TAC05A SoCF MI rec","76:77","HIDEROW"]
["TAC05A SoCF MI rec","79:79","HIDEROW"]
["TAC05A SoCF MI rec","90:91","HIDEROW"]
["TAC05A SoCF MI rec","E:E","HIDECOL"]
["TAC06 Op Inc 1",null,"SheetFormula"]
["TAC06 Op Inc 1","8:9","HIDEROW"]
["TAC06 Op Inc 1","32:32","HIDEROW"]
["TAC06 Op Inc 1","45:46","HIDEROW"]
["TAC06 Op Inc 1","61:61","HIDEROW"]
["TAC06 Op Inc 1","71:72","HIDEROW"]
["TAC06 Op Inc 1","E:E","HIDECOL"]
["TAC07 Op Inc 2",null,"SheetFormula"]
["TAC07 Op Inc 2","8:9","HIDEROW"]
["TAC07 Op Inc 2","16:16","HIDEROW"]
["TAC07 Op Inc 2","32:32","HIDEROW"]
["TAC07 Op Inc 2","61:62","HIDEROW"]
["TAC07 Op Inc 2","82:100","HIDEROW"]
["TAC07 Op Inc 2","104:106","HIDEROW"]
["TAC07 Op Inc 2","116:117","HIDEROW"]
["TAC07 Op Inc 2","127:127","HIDEROW"]
["TAC07 Op Inc 2","129:129","HIDEROW"]
["TAC07 Op Inc 2","E:E","HIDECOL"]
["TAC08 Op Exp",null,"SheetFormula"]
["TAC08 Op Exp","8:9","HIDEROW"]
["TAC08 Op Exp","23:23","HIDEROW"]
["TAC08 Op Exp","26:26","HIDEROW"]
["TAC08 Op Exp","92:94","HIDEROW"]
["TAC08 Op Exp","110:112","HIDEROW"]
["TAC08 Op Exp","124:124","HIDEROW"]
["TAC08 Op Exp","126:126","HIDEROW"]
["TAC08 Op Exp","E:E","HIDECOL"]
["TAC09 Staff",null,"SheetFormula"]
["TAC09 Staff","10:11","HIDEROW"]
["TAC09 Staff","45:46","HIDEROW"]
["TAC09 Staff","71:72","HIDEROW"]
["TAC09 Staff","91:93","HIDEROW"]
["TAC09 Staff","101:103","HIDEROW"]
["TAC09 Staff","118:119","HIDEROW"]
["TAC09 Staff","138:139","HIDEROW"]
["TAC09 Staff","155:156","HIDEROW"]
["TAC09 Staff","E:E","HIDECOL"]
["TAC11 Finance & other",null,"SheetFormula"]
["TAC11 Finance & other","8:9","HIDEROW"]
["TAC11 Finance & other","23:24","HIDEROW"]
["TAC11 Finance & other","30:30","HIDEROW"]
["TAC11 Finance & other","47:49","HIDEROW"]
["TAC11 Finance & other","59:60","HIDEROW"]
["TAC11 Finance & other","82:82","HIDEROWFormula"]
["TAC11 Finance & other","98:98","HIDEROW"]
["TAC11 Finance & other","103:105","HIDEROW"]
["TAC11 Finance & other","E:E","HIDECOL"]
["TAC11 Finance & other","K:T","HIDECOL"]
["TAC12 Impairment",null,"SheetFormula"]
["TAC12 Impairment","8:9","HIDEROW"]
["TAC12 Impairment","21:21","HIDEROWFormula"]
["TAC12 Impairment","24:24","HIDEROWFormula"]
["TAC12 Impairment","35:36","HIDEROW"]
["TAC12 Impairment","162:163","HIDEROW"]
["TAC12 Impairment","D:E","HIDECOL"]
["TAC13 Intangibles",null,"SheetFormula"]
["TAC13 Intangibles","10:11","HIDEROW"]
["TAC13 Intangibles","15:18","HIDEROW"]
["TAC13 Intangibles","29:29","HIDEROWFormula"]
["TAC13 Intangibles","33:33","HIDEROW"]
["TAC13 Intangibles","37:40","HIDEROW"]
["TAC13 Intangibles","49:49","HIDEROWFormula"]
["TAC13 Intangibles","53:53","HIDEROW"]
["TAC13 Intangibles","60:60","HIDEROW"]
["TAC13 Intangibles","62:65","HIDEROW"]
["TAC13 Intangibles","73:74","HIDEROW"]
["TAC13 Intangibles","81:81","HIDEROW"]
["TAC13 Intangibles","92:92","HIDEROWFormula"]
["TAC13 Intangibles","96:96","HIDEROW"]
["TAC13 Intangibles","103:103","HIDEROW"]
["TAC13 Intangibles","112:112","HIDEROWFormula"]
["TAC13 Intangibles","116:116","HIDEROW"]
["TAC13 Intangibles","124:125","HIDEROW"]
["TAC13 Intangibles","135:136","HIDEROW"]
["TAC13 Intangibles","146:148","HIDEROW"]
["TAC13 Intangibles","E:E","HIDECOL"]
["TAC14 PPE",null,"SheetFormula"]
["TAC14 PPE","9:10","HIDEROW"]
["TAC14 PPE","14:17","HIDEROW"]
["TAC14 PPE","31:31","HIDEROWFormula"]
["TAC14 PPE","37:37","HIDEROW"]
["TAC14 PPE","41:44","HIDEROW"]
["TAC14 PPE","53:53","HIDEROWFormula"]
["TAC14 PPE","59:59","HIDEROW"]
["TAC14 PPE","63:63","HIDEROW"]
["TAC14 PPE","65:68","HIDEROW"]
["TAC14 PPE","77:78","HIDEROW"]
["TAC14 PPE","85:85","HIDEROW"]
["TAC14 PPE","99:99","HIDEROWFormula"]
["TAC14 PPE","104:104","HIDEROWFormula"]
["TAC14 PPE","106:106","HIDEROW"]
["TAC14 PPE","113:113","HIDEROW"]
["TAC14 PPE","122:122","HIDEROWFormula"]
["TAC14 PPE","127:127","HIDEROWFormula"]
["TAC14 PPE","129:129","HIDEROW"]
["TAC14 PPE","135:136","HIDEROW"]
["TAC14 PPE","148:149","HIDEROW"]
["TAC14 PPE","161:162","HIDEROW"]
["TAC14 PPE","170:171","HIDEROW"]
["TAC14 PPE","179:180","HIDEROW"]
["TAC14 PPE","190:191","HIDEROW"]
["TAC14 PPE","201:203","HIDEROW"]
["TAC14 PPE","216:216","HIDEROW"]
["TAC14 PPE","218:218","HIDEROW"]
["TAC14 PPE","229:230","HIDEROW"]
["TAC14 PPE","255:256","HIDEROW"]
["TAC14 PPE","E:E","HIDECOL"]
["TAC14A RoU Assets",null,"SheetFormula"]
["TAC14A RoU Assets","12:13","HIDEROW"]
["TAC14A RoU Assets","16:17","HIDEROWFormula"]
["TAC14A RoU Assets","20:21","HIDEROW"]
["TAC14A RoU Assets","25:28","HIDEROW"]
["TAC14A RoU Assets","46:46","HIDEROWFormula"]
["TAC14A RoU Assets","55:55","HIDEROW"]
["TAC14A RoU Assets","59:62","HIDEROW"]
["TAC14A RoU Assets","71:71","HIDEROWFormula"]
["TAC14A RoU Assets","80:80","HIDEROW"]
["TAC14A RoU Assets","84:86","HIDEROW"]
["TAC14A RoU Assets","88:88","HIDEROW"]
["TAC14A RoU Assets","90:93","HIDEROW"]
["TAC14A RoU Assets","105:106","HIDEROW"]
["TAC14A RoU Assets","110:113","HIDEROW"]
["TAC14A RoU Assets","131:131","HIDEROWFormula"]
["TAC14A RoU Assets","140:140","HIDEROW"]
["TAC14A RoU Assets","144:147","HIDEROW"]
["TAC14A RoU Assets","156:156","HIDEROWFormula"]
["TAC14A RoU Assets","165:165","HIDEROW"]
["TAC14A RoU Assets","173:174","HIDEROW"]
["TAC14A RoU Assets","178:181","HIDEROW"]
["TAC14A RoU Assets","199:199","HIDEROWFormula"]
["TAC14A RoU Assets","208:208","HIDEROW"]
["TAC14A RoU Assets","212:215","HIDEROW"]
["TAC14A RoU Assets","224:224","HIDEROWFormula"]
["TAC14A RoU Assets","233:233","HIDEROW"]
["TAC14A RoU Assets","241:242","HIDEROW"]
["TAC14A RoU Assets","246:249","HIDEROW"]
["TAC14A RoU Assets","267:267","HIDEROWFormula"]
["TAC14A RoU Assets","276:276","HIDEROW"]
["TAC14A RoU Assets","280:283","HIDEROW"]
["TAC14A RoU Assets","292:292","HIDEROWFormula"]
["TAC14A RoU Assets","301:301","HIDEROW"]
["TAC14A RoU Assets","309:310","HIDEROW"]
["TAC14A RoU Assets","314:317","HIDEROW"]
["TAC14A RoU Assets","335:335","HIDEROWFormula"]
["TAC14A RoU Assets","344:344","HIDEROW"]
["TAC14A RoU Assets","348:351","HIDEROW"]
["TAC14A RoU Assets","360:360","HIDEROWFormula"]
["TAC14A RoU Assets","369:369","HIDEROW"]
["TAC14A RoU Assets","375:376","HIDEROWFormula"]
["TAC14A RoU Assets","379:380","HIDEROW"]
["TAC14A RoU Assets","384:387","HIDEROW"]
["TAC14A RoU Assets","405:405","HIDEROWFormula"]
["TAC14A RoU Assets","414:414","HIDEROW"]
["TAC14A RoU Assets","418:421","HIDEROW"]
["TAC14A RoU Assets","430:430","HIDEROWFormula"]
["TAC14A RoU Assets","439:439","HIDEROW"]
["TAC14A RoU Assets","447:448","HIDEROW"]
["TAC14A RoU Assets","464:464","HIDEROWFormula"]
["TAC14A RoU Assets","465:465","HIDEROW"]
["TAC14A RoU Assets","466:466","HIDEROWFormula"]
["TAC14A RoU Assets","467:468","HIDEROW"]
["TAC14A RoU Assets","469:471","HIDEROWFormula"]
["TAC14A RoU Assets","472:473","HIDEROW"]
["TAC14A RoU Assets","474:489","HIDEROWFormula"]
["TAC14A RoU Assets","490:491","HIDEROW"]
["TAC14A RoU Assets","492:506","HIDEROWFormula"]
["TAC14A RoU Assets","E:E","HIDECOL"]
["TAC14A RoU Assets","N:N","HIDECOLFormula"]
["TAC14X RoU Assets PY",null,"SheetFormula"]
["TAC14X RoU Assets PY","12:13","HIDEROW"]
["TAC14X RoU Assets PY","17:18","HIDEROWFormula"]
["TAC14X RoU Assets PY","21:22","HIDEROW"]
["TAC14X RoU Assets PY","26:27","HIDEROW"]
["TAC14X RoU Assets PY","31:31","HIDEROW"]
["TAC14X RoU Assets PY","49:49","HIDEROWFormula"]
["TAC14X RoU Assets PY","58:58","HIDEROW"]
["TAC14X RoU Assets PY","62:63","HIDEROW"]
["TAC14X RoU Assets PY","66:66","HIDEROW"]
["TAC14X RoU Assets PY","75:75","HIDEROWFormula"]
["TAC14X RoU Assets PY","84:84","HIDEROW"]
["TAC14X RoU Assets PY","88:90","HIDEROW"]
["TAC14X RoU Assets PY","94:95","HIDEROW"]
["TAC14X RoU Assets PY","99:100","HIDEROW"]
["TAC14X RoU Assets PY","104:104","HIDEROW"]
["TAC14X RoU Assets PY","122:122","HIDEROWFormula"]
["TAC14X RoU Assets PY","131:131","HIDEROW"]
["TAC14X RoU Assets PY","135:136","HIDEROW"]
["TAC14X RoU Assets PY","139:139","HIDEROW"]
["TAC14X RoU Assets PY","148:148","HIDEROWFormula"]
["TAC14X RoU Assets PY","157:157","HIDEROW"]
["TAC14X RoU Assets PY","165:166","HIDEROW"]
["TAC14X RoU Assets PY","170:171","HIDEROW"]
["TAC14X RoU Assets PY","175:175","HIDEROW"]
["TAC14X RoU Assets PY","193:193","HIDEROWFormula"]
["TAC14X RoU Assets PY","202:202","HIDEROW"]
["TAC14X RoU Assets PY","206:207","HIDEROW"]
["TAC14X RoU Assets PY","210:210","HIDEROW"]
["TAC14X RoU Assets PY","219:219","HIDEROWFormula"]
["TAC14X RoU Assets PY","228:228","HIDEROW"]
["TAC14X RoU Assets PY","236:237","HIDEROW"]
["TAC14X RoU Assets PY","241:242","HIDEROW"]
["TAC14X RoU Assets PY","246:246","HIDEROW"]
["TAC14X RoU Assets PY","264:264","HIDEROWFormula"]
["TAC14X RoU Assets PY","273:273","HIDEROW"]
["TAC14X RoU Assets PY","277:278","HIDEROW"]
["TAC14X RoU Assets PY","281:281","HIDEROW"]
["TAC14X RoU Assets PY","290:290","HIDEROWFormula"]
["TAC14X RoU Assets PY","299:299","HIDEROW"]
["TAC14X RoU Assets PY","307:308","HIDEROW"]
["TAC14X RoU Assets PY","312:313","HIDEROW"]
["TAC14X RoU Assets PY","317:317","HIDEROW"]
["TAC14X RoU Assets PY","335:335","HIDEROWFormula"]
["TAC14X RoU Assets PY","344:344","HIDEROW"]
["TAC14X RoU Assets PY","348:349","HIDEROW"]
["TAC14X RoU Assets PY","352:352","HIDEROW"]
["TAC14X RoU Assets PY","361:361","HIDEROWFormula"]
["TAC14X RoU Assets PY","370:370","HIDEROW"]
["TAC14X RoU Assets PY","376:377","HIDEROWFormula"]
["TAC14X RoU Assets PY","380:381","HIDEROW"]
["TAC14X RoU Assets PY","385:386","HIDEROW"]
["TAC14X RoU Assets PY","390:390","HIDEROW"]
["TAC14X RoU Assets PY","408:408","HIDEROWFormula"]
["TAC14X RoU Assets PY","417:417","HIDEROW"]
["TAC14X RoU Assets PY","421:422","HIDEROW"]
["TAC14X RoU Assets PY","425:425","HIDEROW"]
["TAC14X RoU Assets PY","434:434","HIDEROWFormula"]
["TAC14X RoU Assets PY","443:443","HIDEROW"]
["TAC14X RoU Assets PY","451:452","HIDEROW"]
["TAC14X RoU Assets PY","E:E","HIDECOL"]
["TAC14X RoU Assets PY","N:N","HIDECOLFormula"]
["TAC14B Lessors additional info",null,"SheetFormula"]
["TAC14B Lessors additional info","28:29","HIDEROW"]
["TAC14B Lessors additional info","38:38","HIDEROW"]
["TAC14B Lessors additional info","50:50","HIDEROW"]
["TAC14B Lessors additional info","56:56","HIDEROW"]
["TAC14B Lessors additional info","68:68","HIDEROW"]
["TAC14B Lessors additional info","92:93","HIDEROW"]
["TAC14B Lessors additional info","103:104","HIDEROW"]
["TAC14B Lessors additional info","122:122","HIDEROW"]
["TAC14B Lessors additional info","128:129","HIDEROW"]
["TAC14B Lessors additional info","142:142","HIDEROW"]
["TAC14B Lessors additional info","151:151","HIDEROW"]
["TAC14B Lessors additional info","168:169","HIDEROW"]
["TAC14B Lessors additional info","185:186","HIDEROW"]
["TAC14B Lessors additional info","215:215","HIDEROW"]
["TAC14B Lessors additional info","217:220","HIDEROW"]
["TAC14B Lessors additional info","E:E","HIDECOL"]
["TAC15 Investments & groups",null,"SheetFormula"]
["TAC15 Investments & groups","8:9","HIDEROW"]
["TAC15 Investments & groups","17:17","HIDEROW"]
["TAC15 Investments & groups","28:28","HIDEROW"]
["TAC15 Investments & groups","35:36","HIDEROW"]
["TAC15 Investments & groups","42:42","HIDEROW"]
["TAC15 Investments & groups","53:53","HIDEROW"]
["TAC15 Investments & groups","59:60","HIDEROW"]
["TAC15 Investments & groups","66:67","HIDEROW"]
["TAC15 Investments & groups","69:69","HIDEROW"]
["TAC15 Investments & groups","81:81","HIDEROW"]
["TAC15 Investments & groups","88:88","HIDEROW"]
["TAC15 Investments & groups","90:90","HIDEROW"]
["TAC15 Investments & groups","101:101","HIDEROW"]
["TAC15 Investments & groups","103:103","HIDEROW"]
["TAC15 Investments & groups","117:119","HIDEROW"]
["TAC15 Investments & groups","132:134","HIDEROW"]
["TAC15 Investments & groups","150:152","HIDEROW"]
["TAC15 Investments & groups","167:169","HIDEROW"]
["TAC15 Investments & groups","178:179","HIDEROW"]
["TAC15 Investments & groups","183:186","HIDEROW"]
["TAC15 Investments & groups","206:206","HIDEROW"]
["TAC15 Investments & groups","210:210","HIDEROW"]
["TAC15 Investments & groups","212:215","HIDEROW"]
["TAC15 Investments & groups","228:229","HIDEROW"]
["TAC15 Investments & groups","237:237","HIDEROW"]
["TAC15 Investments & groups","257:257","HIDEROW"]
["TAC15 Investments & groups","E:E","HIDECOL"]
["TAC16 AHFS",null,"SheetFormula"]
["TAC16 AHFS","8:9","HIDEROW"]
["TAC16 AHFS","13:15","HIDEROW"]
["TAC16 AHFS","22:22","HIDEROW"]
["TAC16 AHFS","25:25","HIDEROW"]
["TAC16 AHFS","27:30","HIDEROW"]
["TAC16 AHFS","39:40","HIDEROW"]
["TAC16 AHFS","46:46","HIDEROW"]
["TAC16 AHFS","53:53","HIDEROW"]
["TAC16 AHFS","58:59","HIDEROW"]
["TAC16 AHFS","61:61","HIDEROW"]
["TAC16 AHFS","C:C","HIDECOL"]
["TAC16 AHFS","E:E","HIDECOL"]
["TAC17 Inventories",null,"SheetFormula"]
["TAC17 Inventories","11:12","HIDEROW"]
["TAC17 Inventories","16:18","HIDEROW"]
["TAC17 Inventories","24:25","HIDEROW"]
["TAC17 Inventories","32:32","HIDEROW"]
["TAC17 Inventories","42:43","HIDEROW"]
["TAC17 Inventories","59:60","HIDEROW"]
["TAC17 Inventories","66:66","HIDEROW"]
["TAC17 Inventories","76:76","HIDEROW"]
["TAC17 Inventories","E:E","HIDECOL"]
["TAC17 Inventories","H:H","HIDECOL"]
["TAC18 Receivables",null,"SheetFormula"]
["TAC18 Receivables","8:8","HIDEROW"]
["TAC18 Receivables","10:10","HIDEROW"]
["TAC18 Receivables","77:78","HIDEROW"]
["TAC18 Receivables","84:85","HIDEROW"]
["TAC18 Receivables","87:87","HIDEROW"]
["TAC18 Receivables","94:94","HIDEROW"]
["TAC18 Receivables","107:108","HIDEROW"]
["TAC18 Receivables","110:110","HIDEROW"]
["TAC18 Receivables","125:125","HIDEROW"]
["TAC18 Receivables","127:127","HIDEROW"]
["TAC18 Receivables","145:147","HIDEROW"]
["TAC18 Receivables","155:155","HIDEROW"]
["TAC18 Receivables","157:157","HIDEROW"]
["TAC18 Receivables","175:177","HIDEROW"]
["TAC18 Receivables","184:184","HIDEROW"]
["TAC18 Receivables","186:186","HIDEROW"]
["TAC18 Receivables","189:194","HIDEROW"]
["TAC18 Receivables","205:205","HIDEROW"]
["TAC18 Receivables","213:213","HIDEROW"]
["TAC18 Receivables","215:215","HIDEROW"]
["TAC18 Receivables","221:221","HIDEROW"]
["TAC18 Receivables","232:232","HIDEROW"]
["TAC18 Receivables","240:241","HIDEROW"]
["TAC18 Receivables","260:260","HIDEROW"]
["TAC18 Receivables","262:262","HIDEROW"]
["TAC18 Receivables","E:E","HIDECOL"]
["TAC19 CCE",null,"SheetFormula"]
["TAC19 CCE","8:9","HIDEROW"]
["TAC19 CCE","15:15","HIDEROW"]
["TAC19 CCE","18:18","HIDEROW"]
["TAC19 CCE","25:25","HIDEROW"]
["TAC19 CCE","27:27","HIDEROW"]
["TAC19 CCE","41:42","HIDEROW"]
["TAC19 CCE","44:44","HIDEROW"]
["TAC19 CCE","E:E","HIDECOL"]
["TAC20 Payables",null,"SheetFormula"]
["TAC20 Payables","8:8","HIDEROW"]
["TAC20 Payables","10:10","HIDEROW"]
["TAC20 Payables","57:58","HIDEROW"]
["TAC20 Payables","60:60","HIDEROW"]
["TAC20 Payables","68:68","HIDEROW"]
["TAC20 Payables","70:70","HIDEROW"]
["TAC20 Payables","88:88","HIDEROW"]
["TAC20 Payables","90:90","HIDEROW"]
["TAC20 Payables","114:114","HIDEROW"]
["TAC20 Payables","116:116","HIDEROW"]
["TAC20 Payables","E:E","HIDECOL"]
["TAC21 Borrowings",null,"SheetFormula"]
["TAC21 Borrowings","8:8","HIDEROW"]
["TAC21 Borrowings","10:10","HIDEROW"]
["TAC21 Borrowings","20:20","HIDEROW"]
["TAC21 Borrowings","30:30","HIDEROW"]
["TAC21 Borrowings","38:38","HIDEROWFormula"]
["TAC21 Borrowings","41:41","HIDEROW"]
["TAC21 Borrowings","43:43","HIDEROW"]
["TAC21 Borrowings","56:58","HIDEROW"]
["TAC21 Borrowings","63:63","HIDEROWFormula"]
["TAC21 Borrowings","66:66","HIDEROW"]
["TAC21 Borrowings","68:68","HIDEROW"]
["TAC21 Borrowings","81:83","HIDEROW"]
["TAC21 Borrowings","88:88","HIDEROWFormula"]
["TAC21 Borrowings","91:91","HIDEROW"]
["TAC21 Borrowings","93:93","HIDEROW"]
["TAC21 Borrowings","96:99","HIDEROW"]
["TAC21 Borrowings","104:105","HIDEROW"]
["TAC21 Borrowings","116:116","HIDEROW"]
["TAC21 Borrowings","117:117","HIDEROWFormula"]
["TAC21 Borrowings","118:118","HIDEROW"]
["TAC21 Borrowings","124:124","HIDEROWFormula"]
["TAC21 Borrowings","127:127","HIDEROW"]
["TAC21 Borrowings","129:129","HIDEROW"]
["TAC21 Borrowings","139:139","HIDEROW"]
["TAC21 Borrowings","150:150","HIDEROW"]
["TAC21 Borrowings","151:152","HIDEROWFormula"]
["TAC21 Borrowings","161:162","HIDEROW"]
["TAC21 Borrowings","166:167","HIDEROW"]
["TAC21 Borrowings","173:173","HIDEROW"]
["TAC21 Borrowings","175:175","HIDEROW"]
["TAC21 Borrowings","184:184","HIDEROW"]
["TAC21 Borrowings","194:195","HIDEROW"]
["TAC21 Borrowings","206:206","HIDEROW"]
["TAC21 Borrowings","208:208","HIDEROW"]
["TAC21 Borrowings","211:211","HIDEROW"]
["TAC21 Borrowings","217:217","HIDEROW"]
["TAC21 Borrowings","E:E","HIDECOL"]
["TAC21 Borrowings","Q:Q","HIDECOLFormula"]
["TAC22 Provisions",null,"SheetFormula"]
["TAC22 Provisions","8:8","HIDEROW"]
["TAC22 Provisions","10:10","HIDEROW"]
["TAC22 Provisions","27:27","HIDEROWFormula"]
["TAC22 Provisions","30:31","HIDEROW"]
["TAC22 Provisions","35:39","HIDEROW"]
["TAC22 Provisions","51:51","HIDEROW"]
["TAC22 Provisions","61:62","HIDEROW"]
["TAC22 Provisions","66:70","HIDEROW"]
["TAC22 Provisions","80:80","HIDEROW"]
["TAC22 Provisions","90:91","HIDEROW"]
["TAC22 Provisions","109:109","HIDEROW"]
["TAC22 Provisions","111:112","HIDEROWFormula"]
["TAC22 Provisions","115:115","HIDEROWFormula"]
["TAC22 Provisions","118:119","HIDEROW"]
["TAC22 Provisions","126:126","HIDEROWFormula"]
["TAC22 Provisions","127:127","HIDEROW"]
["TAC22 Provisions","139:139","HIDEROW"]
["TAC22 Provisions","149:150","HIDEROW"]
["TAC22 Provisions","156:156","HIDEROWFormula"]
["TAC22 Provisions","157:157","HIDEROW"]
["TAC22 Provisions","167:167","HIDEROW"]
["TAC22 Provisions","177:178","HIDEROW"]
["TAC22 Provisions","180:180","HIDEROW"]
["TAC22 Provisions","186:187","HIDEROW"]
["TAC22 Provisions","189:189","HIDEROW"]
["TAC22 Provisions","205:206","HIDEROW"]
["TAC22 Provisions","E:E","HIDECOL"]
["TAC22 Provisions","Q:Q","HIDECOLFormula"]
["TAC23 Reval Res",null,"SheetFormula"]
["TAC23 Reval Res","6:6","HIDEROWFormula"]
["TAC23 Reval Res","9:10","HIDEROW"]
["TAC23 Reval Res","14:17","HIDEROW"]
["TAC23 Reval Res","26:27","HIDEROW"]
["TAC23 Reval Res","31:31","HIDEROWFormula"]
["TAC23 Reval Res","34:35","HIDEROW"]
["TAC23 Reval Res","43:43","HIDEROW"]
["TAC23 Reval Res","52:53","HIDEROW"]
["TAC23 Reval Res","E:E","HIDECOL"]
["TAC23 Reval Res","P:P","HIDECOLFormula"]
["TAC24 On-SoFP PFI",null,"SheetFormula"]
["TAC24 On-SoFP PFI","10:10","HIDEROW"]
["TAC24 On-SoFP PFI","12:12","HIDEROW"]
["TAC24 On-SoFP PFI","28:28","HIDEROW"]
["TAC24 On-SoFP PFI","30:30","HIDEROW"]
["TAC24 On-SoFP PFI","41:41","HIDEROW"]
["TAC24 On-SoFP PFI","43:43","HIDEROW"]
["TAC24 On-SoFP PFI","54:54","HIDEROW"]
["TAC24 On-SoFP PFI","56:56","HIDEROW"]
["TAC24 On-SoFP PFI","72:73","HIDEROW"]
["TAC24 On-SoFP PFI","98:100","HIDEROW"]
["TAC24 On-SoFP PFI","120:120","HIDEROWFormula"]
["TAC24 On-SoFP PFI","123:125","HIDEROW"]
["TAC24 On-SoFP PFI","140:141","HIDEROW"]
["TAC24 On-SoFP PFI","160:161","HIDEROW"]
["TAC24 On-SoFP PFI","E:E","HIDECOL"]
["TAC25 Off-SoFP PFI",null,"SheetFormula"]
["TAC25 Off-SoFP PFI","10:10","HIDEROW"]
["TAC25 Off-SoFP PFI","12:12","HIDEROW"]
["TAC25 Off-SoFP PFI","23:23","HIDEROW"]
["TAC25 Off-SoFP PFI","25:25","HIDEROW"]
["TAC25 Off-SoFP PFI","38:38","HIDEROW"]
["TAC25 Off-SoFP PFI","40:40","HIDEROW"]
["TAC25 Off-SoFP PFI","E:E","HIDECOL"]
["TAC26 Pension",null,"SheetFormula"]
["TAC26 Pension","7:9","HIDEROW"]
["TAC26 Pension","15:15","HIDEROW"]
["TAC26 Pension","26:26","HIDEROW"]
["TAC26 Pension","32:32","HIDEROW"]
["TAC26 Pension","44:44","HIDEROW"]
["TAC26 Pension","50:51","HIDEROW"]
["TAC26 Pension","53:53","HIDEROW"]
["TAC26 Pension","63:65","HIDEROW"]
["TAC26 Pension","76:78","HIDEROW"]
["TAC26 Pension","E:E","HIDECOL"]
["TAC27 Fin Inst",null,"SheetFormula"]
["TAC27 Fin Inst","12:12","HIDEROW"]
["TAC27 Fin Inst","14:14","HIDEROW"]
["TAC27 Fin Inst","28:28","HIDEROW"]
["TAC27 Fin Inst","30:30","HIDEROW"]
["TAC27 Fin Inst","44:44","HIDEROW"]
["TAC27 Fin Inst","46:46","HIDEROW"]
["TAC27 Fin Inst","64:64","HIDEROW"]
["TAC27 Fin Inst","66:66","HIDEROW"]
["TAC27 Fin Inst","84:84","HIDEROW"]
["TAC27 Fin Inst","86:86","HIDEROW"]
["TAC27 Fin Inst","101:101","HIDEROW"]
["TAC27 Fin Inst","102:102","HIDEROW"]
["TAC27 Fin Inst","103:126","HIDEROW"]
["TAC27 Fin Inst","E:E","HIDECOL"]
["TAC28 Disclosures",null,"SheetFormula"]
["TAC28 Disclosures","8:9","HIDEROW"]
["TAC28 Disclosures","11:11","HIDEROW"]
["TAC28 Disclosures","20:20","HIDEROW"]
["TAC28 Disclosures","22:22","HIDEROW"]
["TAC28 Disclosures","34:35","HIDEROW"]
["TAC28 Disclosures","37:37","HIDEROW"]
["TAC28 Disclosures","48:49","HIDEROW"]
["TAC28 Disclosures","63:63","HIDEROW"]
["TAC28 Disclosures","65:65","HIDEROW"]
["TAC28 Disclosures","79:80","HIDEROW"]
["TAC28 Disclosures","82:82","HIDEROW"]
["TAC28 Disclosures","87:87","HIDEROWFormula"]
["TAC28 Disclosures","88:88","FTHIDEROW"]
["TAC28 Disclosures","89:91","HIDEROW"]
["TAC28 Disclosures","92:99","HIDEROWFormula"]
["TAC28 Disclosures","100:100","HIDEROW"]
["TAC28 Disclosures","101:101","HIDEROW"]
["TAC28 Disclosures","102:102","HIDEROW"]
["TAC28 Disclosures","103:103","HIDEROW"]
["TAC28 Disclosures","104:107","HIDEROWFormula"]
["TAC28 Disclosures","108:108","FTHIDEROW"]
["TAC28 Disclosures","109:109","HIDEROWFormula"]
["TAC28 Disclosures","110:112","HIDEROW"]
["TAC28 Disclosures","113:121","HIDEROWFormula"]
["TAC28 Disclosures","122:122","FTHIDEROW"]
["TAC28 Disclosures","123:125","HIDEROW"]
["TAC28 Disclosures","126:141","HIDEROWFormula"]
["TAC28 Disclosures","142:142","HIDEROW"]
["TAC28 Disclosures","143:147","HIDEROWFormula"]
["TAC28 Disclosures","E:E","HIDECOL"]
["TAC29 Losses+SP",null,"SheetFormula"]
["TAC29 Losses+SP","8:9","HIDEROW"]
["TAC29 Losses+SP","62:63","HIDEROW"]
["TAC29 Losses+SP","E:E","HIDECOL"]
["TAC30 Transfers",null,"SheetFormula"]
["TAC30 Transfers","11:11","HIDEROWFormula"]
["TAC30 Transfers","12:12","HIDEROW"]
["TAC30 Transfers","18:18","HIDEROWFormula"]
["TAC30 Transfers","25:26","HIDEROW"]
["TAC30 Transfers","29:29","HIDEROW"]
["TAC30 Transfers","129:129","HIDEROW"]
["TAC30 Transfers","236:237","HIDEROW"]
["TAC30 Transfers","251:252","HIDEROW"]
["TAC30 Transfers","G:G","HIDECOLFormula"]
["TAC30 Transfers","H:H","HIDECOL"]
["TAC30 Transfers","N:N","HIDECOLFormula"]
["TAC30 Transfers","O:P","HIDECOL"]
["TAC30A Provider transfer detail",null,"SheetFormula"]
["TAC30A Provider transfer detail","26:27","HIDEROW"]
["TAC30A Provider transfer detail","130:130","HIDEROW"]
["TAC30A Provider transfer detail","237:238","HIDEROW"]
["TAC30A Provider transfer detail","254:255","HIDEROW"]
["TAC31 New FTs",null,"Sheet"]
["TAC32 PY New FTs",null,"Sheet"]
["TAC33 PPAs",null,"SheetFormula"]
["TAC33 PPAs","8:10","HIDEROW"]
["TAC33 PPAs","85:87","HIDEROW"]
["TAC33 PPAs","113:115","HIDEROW"]
["TAC33 PPAs","162:162","HIDEROW"]
["TAC33 PPAs","163:163","HIDEROW"]
["TAC33 PPAs","164:293","HIDEROW"]
["TAC33 PPAs","D:D","HIDECOL"]
["TAC34 Free text",null,"SheetFormula"]
["TAC34 Free text","42:42","HIDEROW"]
["TAC39 IFRS 16 Rev impact",null,"Sheet"]
["TAC40 Charity - consol",null,"SheetFormula"]
["TAC40 Charity - consol","12:12","HIDEROW"]
["TAC40 Charity - consol","13:13","HIDEROW"]
["TAC40 Charity - consol","14:21","HIDEROW"]
["TAC40 Charity - consol","25:26","HIDEROW"]
["TAC40 Charity - consol","60:61","HIDEROW"]
["TAC40 Charity - consol","63:63","HIDEROW"]
["TAC40 Charity - consol","108:109","HIDEROW"]
["TAC40 Charity - consol","113:113","HIDEROW"]
["TAC40 Charity - consol","115:115","HIDEROW"]
["TAC40 Charity - consol","117:117","HIDEROW"]
["TAC40 Charity - consol","122:122","HIDEROW"]
["TAC40 Charity - consol","127:129","HIDEROW"]
["TAC40 Charity - consol","153:155","HIDEROW"]
["TAC40 Charity - consol","181:181","HIDEROW"]
["TAC40 Charity - consol","183:183","HIDEROW"]
["TAC40 Charity - consol","E:E","HIDECOL"]
["TAC41 Charity - non-consol",null,"SheetFormula"]
["TAC41 Charity - non-consol","25:25","HIDEROW"]
["TAC41 Charity - non-consol","26:26","HIDEROW"]
["TAC41 Charity - non-consol","27:34","HIDEROW"]
["TAC41 Charity - non-consol","37:39","HIDEROW"]
["TAC41 Charity - non-consol","59:59","HIDEROW"]
["TAC41 Charity - non-consol","61:61","HIDEROW"]
["TAC41 Charity - non-consol","79:80","HIDEROW"]
["TAC41 Charity - non-consol","88:88","HIDEROW"]
["TAC41 Charity - non-consol","95:96","HIDEROW"]
["TAC41 Charity - non-consol","103:103","HIDEROW"]
["TAC41 Charity - non-consol","110:110","HIDEROW"]
["TAC41 Charity - non-consol","112:112","HIDEROW"]
["TAC41 Charity - non-consol","E:E","HIDECOL"]
["TAC41A DH IFRS10 Charities",null,"Sheet"]
["TAC50 YE Extra",null,"Sheet"]
["TAC51 AGS info",null,"SheetFormula"]
["TAC51 AGS info","E:E","HIDECOL"]
["TAC60 WGA - Main rec",null,"SheetFormula"]
["TAC60 WGA - Main rec","8:9","HIDEROW"]
["TAC60 WGA - Main rec","C:C","HIDECOL"]
["TAC60 WGA - Main rec","E:E","HIDECOL"]
["TAC61 WGA - Providers",null,"SheetFormula"]
["TAC61 WGA - Providers","8:10","HIDEROW"]
["TAC61 WGA - Providers","D:D","HIDECOL"]
["TAC62 WGA - NHS and DH",null,"SheetFormula"]
["TAC62 WGA - NHS and DH","8:10","HIDEROW"]
["TAC62 WGA - NHS and DH","90:92","HIDEROW"]
["TAC62 WGA - NHS and DH","96:96","HIDEROW"]
["TAC62 WGA - NHS and DH","D:D","HIDECOL"]
["TAC62 WGA - NHS and DH","Z:Z","HIDECOL"]
["TAC63 WGA - Other WGA bodies",null,"SheetFormula"]
["TAC63 WGA - Other WGA bodies","8:10","HIDEROW"]
["TAC63 WGA - Other WGA bodies","374:374","HIDEROW"]
["TAC63 WGA - Other WGA bodies","D:D","HIDECOL"]
["TAC64 WGA - Local Authorities",null,"SheetFormula"]
["TAC64 WGA - Local Authorities","8:10","HIDEROW"]
["TAC64 WGA - Local Authorities","D:D","HIDECOL"]
["TAC64 WGA - Local Authorities","Z:Z","HIDECOL"]
["TAC65 Audit sheet",null,"SheetFormula"]
["TAC65 Audit sheet","8:8","HIDEROW"]
["TAC65 Audit sheet","9:9","HIDEROW"]
["TAC65 Audit sheet","39:44","HIDEROW"]
["TAC65 Audit sheet","316:316","HIDEROW"]
["TAC65 Audit sheet","340:340","HIDEROW"]
["TAC Consolidation tables",null,"Sheet"]
["TAC DH outturn",null,"Sheet"]
["TAC Accounts data list",null,"Sheet"]
["00. Self Cert","28:28","HIDEROW"]
["00. Self Cert","30:30","HIDEROW"]
["00. Self Cert","32:37","HIDEROW"]
["00. Self Cert","61:65","HIDEROWFormula"]
["00. Self Cert","68:69","HIDEROW"]
["00. Self Cert","70:70","HIDEROW"]
["00. Self Cert","71:141","HIDEROW"]
["00. Self Cert","G:H","HIDECOL"]
["99. Key Data","70:70","HIDEROW"]
["99. Key Data","86:87","HIDEROW"]
["99. Key Data","94:94","HIDEROWFormula"]
["99. Key Data","AJ:AP","HIDECOLFormula"]
["99. Key Data","BB:BD","HIDECOL"]
["02. Analysis","8:9","HIDEROW"]
["02. Analysis","11:11","HIDEROW"]
["02. Analysis","15:15","HIDEROW"]
["02. Analysis","18:18","HIDEROW"]
["02. Analysis","24:24","HIDEROW"]
["02. Analysis","404:421","HIDEROW"]
["02. Analysis","422:422","HIDEROW"]
["02. Analysis","423:446","HIDEROW"]
["02. Analysis","447:447","HIDEROW"]
["02. Analysis","448:468","HIDEROW"]
["02. Analysis","469:469","HIDEROW"]
["02. Analysis","470:568","HIDEROW"]
["02. Analysis","569:569","HIDEROW"]
["02. Analysis","570:597","HIDEROW"]
["02. Analysis","C:D","HIDECOL"]
["04. SoCI","6:6","HIDEROW"]
["04. SoCI","30:30","HIDEROW"]
["04. SoCI","44:44","HIDEROWFormula"]
["04. SoCI","46:47","HIDEROWFormula"]
["04. SoCI","52:52","HIDEROWFormula"]
["04. SoCI","53:54","HIDEROW"]
["04. SoCI","56:60","HIDEROW"]
["04. SoCI","64:64","HIDEROW"]
["04. SoCI","75:77","HIDEROW"]
["04. SoCI","81:81","HIDEROW"]
["04. SoCI","87:90","HIDEROW"]
["04. SoCI","95:95","HIDEROW"]
["04. SoCI","109:109","HIDEROW"]
["04. SoCI","110:110","HIDEROW"]
["04. SoCI","111:125","HIDEROW"]
["04. SoCI","E:E","HIDECOL"]
["04. SoCI","AU:AW","HIDECOLFormula"]
["04. SoCI","BD:BD","HIDECOLFormula"]
["04. SoCI","BF:BI","HIDECOL"]
["05. SoFP","6:6","HIDEROW"]
["05. SoFP","69:69","HIDEROW"]
["05. SoFP","80:80","HIDEROW"]
["05. SoFP","90:90","HIDEROW"]
["05. SoFP","96:96","HIDEROW"]
["05. SoFP","113:113","HIDEROW"]
["05. SoFP","127:127","HIDEROW"]
["05. SoFP","136:136","HIDEROW"]
["05. SoFP","E:E","HIDECOL"]
["05. SoFP","AJ:AL","HIDECOLFormula"]
["05. SoFP","AS:AS","HIDECOL"]
["05. SoFP","AU:AW","HIDECOLFormula"]
["05. SoFP","AX:AX","HIDECOL"]
["06. SoCF","6:6","HIDEROW"]
["06. SoCF","45:45","HIDEROW"]
["06. SoCF","75:75","HIDEROW"]
["06. SoCF","78:78","HIDEROW"]
["06. SoCF","86:87","HIDEROWFormula"]
["06. SoCF","101:101","HIDEROW"]
["06. SoCF","115:116","HIDEROWFormula"]
["06. SoCF","125:126","HIDEROW"]
["06. SoCF","127:128","HIDEROWFormula"]
["06. SoCF","132:132","HIDEROW"]
["06. SoCF","145:145","HIDEROW"]
["06. SoCF","180:180","HIDEROW"]
["06. SoCF","189:189","HIDEROWFormula"]
["06. SoCF","190:190","HIDEROW"]
["06. SoCF","191:225","HIDEROWFormula"]
["06. SoCF","228:228","HIDEROW"]
["06. SoCF","229:229","HIDEROW"]
["06. SoCF","230:230","HIDEROW"]
["06. SoCF","231:239","HIDEROW"]
["06. SoCF","E:E","HIDECOL"]
["06. SoCF","G:H","HIDECOL"]
["06. SoCF","AJ:AL","HIDECOLFormula"]
["06. SoCF","AS:AS","HIDECOLFormula"]
["06. SoCF","AV:AX","HIDECOL"]
["07. Op Inc (nature)","6:6","HIDEROW"]
["07. Op Inc (nature)","E:E","HIDECOL"]
["07. Op Inc (nature)","AU:AW","HIDECOLFormula"]
["07. Op Inc (nature)","BD:BD","HIDECOLFormula"]
["07. Op Inc (nature)","BF:BI","HIDECOL"]
["08. Op Inc (source)","6:6","HIDEROW"]
["08. Op Inc (source)","13:13","HIDEROW"]
["08. Op Inc (source)","23:23","HIDEROW"]
["08. Op Inc (source)","29:29","HIDEROW"]
["08. Op Inc (source)","53:53","HIDEROW"]
["08. Op Inc (source)","57:57","HIDEROW"]
["08. Op Inc (source)","76:76","HIDEROW"]
["08. Op Inc (source)","109:112","HIDEROWFormula"]
["08. Op Inc (source)","E:E","HIDECOL"]
["08. Op Inc (source)","AU:AW","HIDECOLFormula"]
["08. Op Inc (source)","BD:BD","HIDECOLFormula"]
["08. Op Inc (source)","BF:BH","HIDECOLFormula"]
["08. Op Inc (source)","BI:BI","HIDECOL"]
["10. Op Ex","6:6","HIDEROW"]
["10. Op Ex","46:46","HIDEROW"]
["10. Op Ex","50:50","HIDEROW"]
["10. Op Ex","66:66","HIDEROW"]
["10. Op Ex","80:80","HIDEROW"]
["10. Op Ex","92:92","HIDEROW"]
["10. Op Ex","103:103","HIDEROW"]
["10. Op Ex","119:119","HIDEROWFormula"]
["10. Op Ex","E:E","HIDECOL"]
["10. Op Ex","AU:AW","HIDECOLFormula"]
["10. Op Ex","BD:BH","HIDECOLFormula"]
["10. Op Ex","BI:BI","HIDECOL"]
["11. Staff costs","6:6","HIDEROW"]
["11. Staff costs","33:33","HIDEROW"]
["11. Staff costs","43:43","HIDEROW"]
["11. Staff costs","E:E","HIDECOL"]
["11. Staff costs","AU:AW","HIDECOLFormula"]
["11. Staff costs","BD:BD","HIDECOLFormula"]
["11. Staff costs","BE:BF","HIDECOL"]
["11. Staff costs","BG:BH","HIDECOLFormula"]
["12. Staff costs detail","6:6","HIDEROW"]
["12. Staff costs detail","22:22","HIDEROW"]
["12. Staff costs detail","54:54","HIDEROW"]
["12. Staff costs detail","86:86","HIDEROW"]
["12. Staff costs detail","118:118","HIDEROW"]
["12. Staff costs detail","151:151","HIDEROW"]
["12. Staff costs detail","E:E","HIDECOL"]
["12. Staff costs detail","AU:AW","HIDECOLFormula"]
["12. Staff costs detail","BD:BD","HIDECOLFormula"]
["12. Staff costs detail","BE:BF","HIDECOL"]
["12. Staff costs detail","BG:BH","HIDECOLFormula"]
["13. SOCI Other","6:6","HIDEROW"]
["13. SOCI Other","24:24","HIDEROWFormula"]
["13. SOCI Other","28:28","HIDEROW"]
["13. SOCI Other","30:30","HIDEROW"]
["13. SOCI Other","34:34","HIDEROW"]
["13. SOCI Other","85:85","HIDEROW"]
["13. SOCI Other","90:144","HIDEROW"]
["13. SOCI Other","170:170","HIDEROW"]
["13. SOCI Other","195:195","HIDEROW"]
["13. SOCI Other","202:202","HIDEROWFormula"]
["13. SOCI Other","E:E","HIDECOL"]
["13. SOCI Other","AU:AW","HIDECOLFormula"]
["13. SOCI Other","BD:BD","HIDECOLFormula"]
["13. SOCI Other","BF:BF","HIDECOLFormula"]
["13. SOCI Other","BG:BI","HIDECOL"]
["14. RDEL Calc","30:30","HIDEROW"]
["14. RDEL Calc","52:52","HIDEROW"]
["14. RDEL Calc","55:56","HIDEROW"]
["14. RDEL Calc","60:83","HIDEROWFormula"]
["14. RDEL Calc","84:84","HIDEROW"]
["14. RDEL Calc","85:86","HIDEROWFormula"]
["14. RDEL Calc","88:88","HIDEROWFormula"]
["14. RDEL Calc","90:105","HIDEROWFormula"]
["14. RDEL Calc","106:106","HIDEROW"]
["14. RDEL Calc","107:108","HIDEROWFormula"]
["14. RDEL Calc","109:110","HIDEROW"]
["14. RDEL Calc","112:112","HIDEROW"]
["14. RDEL Calc","113:113","HIDEROW"]
["14. RDEL Calc","114:131","HIDEROWFormula"]
["14. RDEL Calc","133:133","HIDEROW"]
["14. RDEL Calc","134:134","HIDEROW"]
["14. RDEL Calc","135:171","HIDEROW"]
["14. RDEL Calc","E:E","HIDECOL"]
["14. RDEL Calc","M:O","HIDECOL"]
["15. Capital Analysis Schemes","13:86","HIDEROWFormula"]
["15. Capital Analysis Schemes","156:170","HIDEROWFormula"]
["15. Capital Analysis Schemes","190:193","HIDEROWFormula"]
["15. Capital Analysis Schemes","197:199","HIDEROWFormula"]
["15. Capital Analysis Schemes","211:230","HIDEROWFormula"]
["15. Capital Analysis Schemes","257:257","HIDEROW"]
["15. Capital Analysis Schemes","262:262","HIDEROW"]
["15. Capital Analysis Schemes","275:275","HIDEROW"]
["15. Capital Analysis Schemes","308:308","HIDEROWFormula"]
["15. Capital Analysis Schemes","309:309","HIDEROW"]
["15. Capital Analysis Schemes","349:349","HIDEROWFormula"]
["15. Capital Analysis Schemes","393:393","HIDEROWFormula"]
["15. Capital Analysis Schemes","394:394","HIDEROW"]
["15. Capital Analysis Schemes","424:424","HIDEROW"]
["15. Capital Analysis Schemes","454:454","HIDEROW"]
["15. Capital Analysis Schemes","484:484","HIDEROW"]
["15. Capital Analysis Schemes","660:662","HIDEROWFormula"]
["15. Capital Analysis Schemes","693:694","HIDEROW"]
["15. Capital Analysis Schemes","709:709","HIDEROWFormula"]
["15. Capital Analysis Schemes","714:714","HIDEROW"]
["15. Capital Analysis Schemes","715:733","HIDEROWFormula"]
["15. Capital Analysis Schemes","E:E","HIDECOL"]
["15b. Additional Capital","6:6","HIDEROW"]
["15b. Additional Capital","39:39","HIDEROW"]
["15b. Additional Capital","101:101","HIDEROW"]
["15b. Additional Capital","132:132","HIDEROW"]
["15b. Additional Capital","145:145","HIDEROW"]
["15b. Additional Capital","155:155","HIDEROW"]
["15b. Additional Capital","165:165","HIDEROW"]
["15b. Additional Capital","175:175","HIDEROW"]
["15b. Additional Capital","185:185","HIDEROW"]
["15b. Additional Capital","194:194","HIDEROW"]
["15b. Additional Capital","195:195","HIDEROW"]
["15b. Additional Capital","196:219","HIDEROW"]
["15b. Additional Capital","220:220","HIDEROW"]
["15b. Additional Capital","221:235","HIDEROW"]
["15b. Additional Capital","252:252","HIDEROW"]
["15b. Additional Capital","263:263","HIDEROW"]
["15b. Additional Capital","274:274","HIDEROW"]
["15b. Additional Capital","285:285","HIDEROW"]
["15b. Additional Capital","292:292","HIDEROW"]
["15b. Additional Capital","293:293","HIDEROW"]
["15b. Additional Capital","294:339","HIDEROW"]
["15b. Additional Capital","344:365","HIDEROW"]
["15b. Additional Capital","E:E","HIDECOL"]
["15b. Additional Capital","BB:BD","HIDECOL"]
["16. Limits","6:6","HIDEROW"]
["16. Limits","21:32","FTHIDEROW"]
["16. Limits","35:41","HIDEROWFormula"]
["16. Limits","49:52","HIDEROW"]
["16. Limits","59:59","HIDEROW"]
["16. Limits","61:62","FTHIDEROW"]
["16. Limits","63:63","HIDEROWFormula"]
["16. Limits","66:69","FTHIDEROW"]
["16. Limits","72:72","FTHIDEROW"]
["16. Limits","84:87","HIDEROW"]
["16. Limits","94:94","HIDEROW"]
["16. Limits","96:97","FTHIDEROW"]
["16. Limits","98:98","HIDEROW"]
["16. Limits","101:104","FTHIDEROW"]
["16. Limits","107:107","FTHIDEROW"]
["16. Limits","E:E","HIDECOL"]
["16. Limits","G:I","FTHIDECOL"]
["16. Limits","U:U","HIDECOL"]
["16. Limits","W:Y","HIDECOL"]
["17. IFRIC12PFI","6:6","HIDEROW"]
["17. IFRIC12PFI","11:32","HIDEROWFormula"]
["17. IFRIC12PFI","35:35","HIDEROW"]
["17. IFRIC12PFI","53:56","HIDEROW"]
["17. IFRIC12PFI","60:60","HIDEROWFormula"]
["17. IFRIC12PFI","64:64","HIDEROW"]
["17. IFRIC12PFI","65:89","HIDEROWFormula"]
["17. IFRIC12PFI","152:154","HIDEROW"]
["17. IFRIC12PFI","E:E","HIDECOL"]
["17. IFRIC12PFI","G:H","HIDECOL"]
["17. IFRIC12PFI","AX:AX","HIDECOL"]
["17. IFRIC12PFI","BA:BA","HIDECOL"]
["18. Capital Funding-GrsCpxCDEL","6:6","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","31:31","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","36:36","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","41:41","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","46:47","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","48:48","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","65:65","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","69:69","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","72:72","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","81:83","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","86:86","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","104:104","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","133:133","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","141:142","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","153:153","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","173:173","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","174:176","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","197:197","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","199:231","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","232:232","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","233:235","HIDEROWFormula"]
["18. Capital Funding-GrsCpxCDEL","237:237","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","238:238","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","239:252","HIDEROW"]
["18. Capital Funding-GrsCpxCDEL","E:H","HIDECOL"]
["18. Capital Funding-GrsCpxCDEL","AV:AW","HIDECOL"]
["18. Capital Funding-GrsCpxCDEL","$AK$18","NonFTLockFTInput"]
["18. Capital Funding-GrsCpxCDEL","$AK$19","NonFTLockFTInput"]
["18. Capital Funding-GrsCpxCDEL","$AK$25","NonFTLockFTInput"]
["18. Capital Funding-GrsCpxCDEL","$AK$26","NonFTLockFTInput"]
["18. Capital Funding-GrsCpxCDEL","$AK$27","NonFTLockFTInput"]
["18. Capital Funding-GrsCpxCDEL","$AK$35","NonFTLockFTInput"]
["44. Capital CT Analysis","6:6","HIDEROW"]
["44. Capital CT Analysis","13:13","HIDEROW"]
["44. Capital CT Analysis","18:18","HIDEROWFormula"]
["44. Capital CT Analysis","36:36","HIDEROWFormula"]
["44. Capital CT Analysis","39:41","HIDEROW"]
["44. Capital CT Analysis","44:45","HIDEROW"]
["44. Capital CT Analysis","47:47","HIDEROW"]
["44. Capital CT Analysis","57:57","HIDEROW"]
["44. Capital CT Analysis","74:76","HIDEROW"]
["44. Capital CT Analysis","80:80","HIDEROW"]
["44. Capital CT Analysis","E:H","HIDECOL"]
["19. SoFP - other","43:53","HIDEROWFormula"]
["19. SoFP - other","E:E","HIDECOL"]
["19. SoFP - other","V:V","HIDECOL"]
["19. SoFP - other","Y:AA","HIDECOL"]
["31. Efficiency_Summary","6:6","HIDEROW"]
["31. Efficiency_Summary","26:26","HIDEROW"]
["31. Efficiency_Summary","70:70","HIDEROW"]
["31. Efficiency_Summary","71:71","HIDEROW"]
["31. Efficiency_Summary","72:82","HIDEROW"]
["31. Efficiency_Summary","83:83","HIDEROW"]
["31. Efficiency_Summary","84:96","HIDEROW"]
["31. Efficiency_Summary","99:99","HIDEROW"]
["31. Efficiency_Summary","F:H","HIDECOL"]
["31. Efficiency_Summary","AJ:AL","HIDECOLFormula"]
["31. Efficiency_Summary","AS:AS","HIDECOLFormula"]
["31. Efficiency_Summary","AT:AT","HIDECOL"]
["31. Efficiency_Summary","AU:AU","HIDECOLFormula"]
["31. Efficiency_Summary","AV:AV","HIDECOL"]
["31. Efficiency_Summary","AX:AX","HIDECOL"]
["40. Variances","90:116","HIDEROWFormula"]
["40. Variances","118:150","HIDEROWFormula"]
["40. Variances","Z:Z","HIDECOL"]
["40a. Run rate analysis",null,"Sheet"]
["40b. Plan Movements","E:E","HIDECOL"]
["40c. Reconciliations","E:E","HIDECOL"]
["41. Flags","18:21","HIDEROWFormula"]
["41. Flags","26:26","HIDEROWFormula"]
["41. Flags","131:162","HIDEROWFormula"]
["41. Flags","188:251","HIDEROWFormula"]
["41. Flags","N:N","HIDECOL"]
["42. Data Validation","14:41","HIDEROWFormula"]
["42. Data Validation","48:74","HIDEROWFormula"]
["42. Data Validation","75:76","HIDEROW"]
["42. Data Validation","78:706","HIDEROWFormula"]
["42. Data Validation","707:707","HIDEROW"]
["42. Data Validation","708:708","HIDEROW"]
["42. Data Validation","709:709","HIDEROW"]
["42. Data Validation","710:710","HIDEROW"]
["42. Data Validation","711:711","HIDEROW"]
["42. Data Validation","712:712","HIDEROW"]
["42. Data Validation","713:713","HIDEROW"]
["42. Data Validation","714:714","HIDEROW"]
["42. Data Validation","715:715","HIDEROW"]
["42. Data Validation","716:716","HIDEROW"]
["42. Data Validation","717:717","HIDEROW"]
["42. Data Validation","718:718","HIDEROW"]
["42. Data Validation","719:719","HIDEROW"]
["42. Data Validation","720:720","HIDEROW"]
["42. Data Validation","721:721","HIDEROW"]
["42. Data Validation","722:725","HIDEROWFormula"]
["42. Data Validation","726:726","HIDEROW"]
["42. Data Validation","727:727","HIDEROW"]
["42. Data Validation","728:728","HIDEROW"]
["42. Data Validation","729:729","HIDEROW"]
["42. Data Validation","730:730","HIDEROW"]
["42. Data Validation","731:731","HIDEROW"]
["42. Data Validation","732:732","HIDEROW"]
["42. Data Validation","733:733","HIDEROW"]
["42. Data Validation","734:734","HIDEROW"]
["42. Data Validation","735:735","HIDEROW"]
["42. Data Validation","736:736","HIDEROW"]
["42. Data Validation","737:737","HIDEROW"]
["42. Data Validation","738:738","HIDEROW"]
["42. Data Validation","739:739","HIDEROW"]
["42. Data Validation","740:740","HIDEROW"]
["42. Data Validation","741:741","HIDEROW"]
["42. Data Validation","742:742","HIDEROW"]
["42. Data Validation","743:743","HIDEROW"]
["42. Data Validation","744:744","HIDEROW"]
["42. Data Validation","745:745","HIDEROW"]
["42. Data Validation","746:746","HIDEROW"]
["42. Data Validation","747:747","HIDEROW"]
["42. Data Validation","748:748","HIDEROW"]
["42. Data Validation","749:749","HIDEROW"]
["42. Data Validation","750:750","HIDEROW"]
["42. Data Validation","751:751","HIDEROW"]
["42. Data Validation","752:752","HIDEROW"]
["42. Data Validation","753:753","HIDEROW"]
["42. Data Validation","754:754","HIDEROW"]
["42. Data Validation","755:755","HIDEROW"]
["42. Data Validation","756:756","HIDEROW"]
["42. Data Validation","757:757","HIDEROW"]
["42. Data Validation","758:758","HIDEROW"]
["42. Data Validation","759:759","HIDEROW"]
["42. Data Validation","760:760","HIDEROW"]
["42. Data Validation","761:761","HIDEROW"]
["42. Data Validation","762:762","HIDEROW"]
["42. Data Validation","763:763","HIDEROW"]
["42. Data Validation","764:764","HIDEROW"]
["42. Data Validation","765:765","HIDEROW"]
["42. Data Validation","766:766","HIDEROW"]
["42. Data Validation","767:767","HIDEROW"]
["42. Data Validation","768:768","HIDEROW"]
["42. Data Validation","769:769","HIDEROW"]
["42. Data Validation","770:770","HIDEROW"]
["42. Data Validation","771:771","HIDEROW"]
["42. Data Validation","772:772","HIDEROW"]
["42. Data Validation","773:773","HIDEROW"]
["42. Data Validation","774:774","HIDEROW"]
["42. Data Validation","775:775","HIDEROW"]
["42. Data Validation","776:776","HIDEROW"]
["42. Data Validation","777:777","HIDEROW"]
["42. Data Validation","778:778","HIDEROW"]
["42. Data Validation","779:779","HIDEROW"]
["42. Data Validation","780:780","HIDEROW"]
["42. Data Validation","781:781","HIDEROW"]
["42. Data Validation","782:782","HIDEROW"]
["42. Data Validation","783:783","HIDEROW"]
["42. Data Validation","784:784","HIDEROW"]
["42. Data Validation","785:785","HIDEROW"]
["42. Data Validation","786:786","HIDEROW"]
["42. Data Validation","787:787","HIDEROW"]
["42. Data Validation","788:788","HIDEROW"]
["42. Data Validation","789:789","HIDEROW"]
["42. Data Validation","790:790","HIDEROW"]
["42. Data Validation","791:791","HIDEROW"]
["42. Data Validation","792:792","HIDEROW"]
["42. Data Validation","793:793","HIDEROW"]
["42. Data Validation","794:794","HIDEROW"]
["42. Data Validation","795:795","HIDEROW"]
["42. Data Validation","796:796","HIDEROW"]
["42. Data Validation","797:797","HIDEROW"]
["42. Data Validation","798:798","HIDEROW"]
["42. Data Validation","799:799","HIDEROW"]
["42. Data Validation","800:800","HIDEROW"]
["42. Data Validation","801:801","HIDEROW"]
["42. Data Validation","802:802","HIDEROW"]
["42. Data Validation","803:803","HIDEROW"]
["42. Data Validation","804:804","HIDEROW"]
["42. Data Validation","805:805","HIDEROW"]
["42. Data Validation","806:806","HIDEROW"]
["42. Data Validation","807:807","HIDEROW"]
["42. Data Validation","808:808","HIDEROW"]
["42. Data Validation","809:809","HIDEROW"]
["42. Data Validation","810:810","HIDEROW"]
["42. Data Validation","811:811","HIDEROW"]
["42. Data Validation","812:812","HIDEROW"]
["42. Data Validation","813:813","HIDEROW"]
["42. Data Validation","814:814","HIDEROW"]
["42. Data Validation","815:815","HIDEROW"]
["42. Data Validation","816:816","HIDEROW"]
["42. Data Validation","817:817","HIDEROW"]
["42. Data Validation","818:818","HIDEROW"]
["42. Data Validation","819:819","HIDEROW"]
["42. Data Validation","820:820","HIDEROW"]
["42. Data Validation","821:821","HIDEROW"]
["42. Data Validation","822:822","HIDEROW"]
["42. Data Validation","823:823","HIDEROW"]
["42. Data Validation","824:824","HIDEROW"]
["42. Data Validation","825:825","HIDEROW"]
["42. Data Validation","826:826","HIDEROW"]
["42. Data Validation","827:827","HIDEROW"]
["42. Data Validation","828:828","HIDEROW"]
["42. Data Validation","829:829","HIDEROW"]
["42. Data Validation","830:830","HIDEROW"]
["42. Data Validation","831:831","HIDEROW"]
["42. Data Validation","832:832","HIDEROW"]
["42. Data Validation","R:Y","HIDECOL"]
["15a. Capital Analysis Plan","E:E","HIDECOL"]
["Settings",null,"Sheet"]
["Data Lists",null,"Sheet"]
["Capital Data Lists",null,"Sheet"]

{"sheet":"Internal Guidance","index":6,"n_rows":351,"n_cols":3,"rows_kept":351,"cut":false,"hidden":true,"merged":[]}
[null,null,"Guidance"]
[]
[null,null,"Purpose of the tool"]
[]
[null,null,"This tool is designed to amend PFMS templates with updates and fixers. Chosen templates may be updated with fixes listed in the Tax list tab, depending on the version of the template. "]
[]
[null,null,"Initial tool set up"]
[]
[null,null,"1. Ensure that the settings sheet is completed correctly:"]
[null,null,"• The Year, Period and Type must match the Year, Period and Type in the settings sheet of the files being updated. Any files that do not have these settings correct will not be updated."]
[null,null,"• If fixed files require a new name, the file suffix must be used to create the end of each name. The name must always end in .xlsm."]
[null,null,"• To save all the fixed files with their original name (the name saved in the settings sheet of each file), set Save Template with Original Name to Yes. "]
[null,null,"• Setting Save File with Original Name to No allows Templates to save with entirely new names (using the file suffix), or with the name unchanged."]
[null,null,"• To save the fixed templates with their names unchanged, set Save File with Original Name to No, and Open Template as Read Only to No."]
[null,null,"• To save the fixed templates with file suffix, set Save Template with Original Name to No, and Open Template as Read Only to Yes."]
[null,null,"• Update Version on Template has two options:"]
[null,null,"• Yes - updates the template version to the last version in the fixer."]
[null,null,"• No - does not update the template version."]
[null,null,"2. Enter the list of fixes to be made in the Fix List worksheet, ensure that the version number for each fix is correct and is in chronological order. There must be no gaps in the Fix List. \nGuidance on how to fill in the fix list is given below."]
[null,null,"3. Enter the list of files (including the file path) to update, along with their NHS Codes and MARSIDs associated with them, into columns A - C of the File List worksheet. Note: it is important that the NHSCode and MARSID for each file is included in the list - omitting these will cause incorrect results. "]
[null,null,"4. Enter any data to be updated into the Customiser worksheet. Guidance on how to set up the customiser is given below."]
[]
[null,null,"Working with the Fix list"]
[]
[null,null,"The fix list shows all the changes that the tool is capable of performing on the templates. Each fix is composed of five sections:"]
[null,null,"• Worksheet - The name of the worksheet in the template that the fix affects."]
[null,null,"• Cell Reference - the range or cell address in the worksheet that the fix affects."]
[null,null,"• Fix Type - the type of fix to be performed. This is driven by a drop down list showing all the fix types that are currently available."]
[null,null,"• Fix - Details of the Fix. See the list of fixes below for details of what to enter here for each fix type."]
[null,null,"• Version - the version to which the fix applies. See the section on working with Version, below, for details on how to use this."]
[null,null,"• User - used to enter the name or initials of the user who entered the fix into the list."]
[null,null,"• Notes - used to provide further information if necessary - such as the previous value of a cell."]
[]
[null,null,"When filling in the fix list, always complete the Worksheet, Cell Reference, Fix Type , Fix and Version. Sometimes the Worksheet, Cell Reference and Fix cells are not required to run the fix, in which are they should be replaced with \"N/A\". All fixes must be related to a valid version number."]
[null,null,"All the fix versions numbers must be in chronological order (i.e. fixes for version 3 must be entered below fixes for version 2). All the fix versions numbers must match one of the versions in the list of versions in the Settings sheet."]
[]
[null,null,"Best Practice Advice"]
[]
[null,null,"Please follow the advice below to obtain the optimum performance and speed for this tool."]
[]
[null,null,"• Turn off animations to improve the speed of the tool. When developing and testing the tool, ensure that animations are turned off, and when distributing the tool, advise users to do the same."]
[]
[null,null,"To turn off animations:"]
[]
[null,null,"1) Open the computer's Settings.\n2) In the Settings window, select Ease of Access, and then click on Other options in the list on the left of the window.\n3) Under Visual Options, ensure that Play animations in Windows is set to off."]
[]
[null,null,"• When a new formula needs to be repeated across multiple contiguous rows or columns, use the formula fix to place the formula in the first cell of the range, then use the CopyFormula fix to copy that formula to the other cells in the range,"]
[]
[null,null,"E.g. To place a formula summing rows 9 to 14 in row 15 for columns F to Y, do not use  the formula fix twenty times, use the Formula fix to place the formula =sum(F9:F14) in cell F15, and the FormulaCopy fix to copy the new formula from cell F15 to cells G15:Y15"]
[]
[null,null,"• When setting multiple ranges of cells, rows or columns to the same format, refer to the whole range of cells, rows, or columns, rather than one element at a time."]
[]
[null,null,"E.g. to hide rows 15 to 20, do not use the HideRow fix six times for cells A15, A16, A17, A18, A19, and 20, use it once for cells A15:A20"]
[]
[null,null,"Available fixes:"]
[]
[null,null,"AddColumn - Adds a column to the left of the selected cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter a cell address for row 1 of the column before which the new column is to be inserted - for example, enter $C$1 to create a new column C"]
[null,null,"Fix - N/A"]
[]
[null,null,"AddHyperlink - Adds a hyperlink to selected cell"]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to update."]
[null,null,"Fix - Enter the reference of the Hyperlink"]
[]
[null,null,"AddRow - Add a row above the selected cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the cell address for column A of the row before which the new row is to be inserted - for example, enter $A$3 to create a new row 3"]
[null,null,"Fix - N/A"]
[]
[null,null,"AddValidationList - Adds a simple drop down to the selected cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to update."]
[null,null,"Fix - Enter the options of the drop down, separated by commas - for example enter, Yes, No to create a drop down with Yes and No as the options."]
[]
[null,null,"AddValidationText - Adds pop-up text when a cell is clicked (for an InfoBox). Not that the title of the text is always \"Information\""]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to update."]
[null,null,"Fix - Enter the validation text."]
[]
[null,null,"ChangeCellStyle - Change the style of the selected cell to a new named style. "]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to update."]
[null,null,"Fix - Enter the name of the new style. Take care to ensure that the new name is spelled correctly."]
[]
[null,null,"ChangeRangeStyle - Change cells that have a specific style within a range to have a different style."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the range that will be updated For example $F$45:$K$55"]
[null,null,"Fix - Enter the names of the Original Style and the New Style, separated by an exclamation mark. For example InputFY!InputCY. Only cells with the first named style will be updated, and they will be updated to have the second named style. Take care to ensure that the names are spelled correctly."]
[]
[null,null,"ChangeRangeStyleForAllCells - Change all cells within a range to have a different style."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the range that will be updated For example $F$45:$K$55"]
[null,null,"Fix - Enter the name of the new style. Take care to ensure that the new name is spelled correctly."]
[]
[null,null,"ChangeValidationText - Change pop-up text when a cell is clicked (for an InfoBox). "]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to update."]
[null,null,"Fix - Enter the new validation text."]
[]
[null,null,"ClearCell - Completely reset a cell (formatting, contents)"]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to clear."]
[null,null,"Fix - N/A"]
[]
[null,null,"ClearContents - remove the contents of a cell"]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to clear."]
[null,null,"Fix - N/A"]
[]
[null,null,"CopyBackColour - Copy the fill colour from another cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to alter."]
[null,null,"Fix - Enter the reference of the cell from which to copy the back colour."]
[]
[null,null,"CopyFormat - Copy the cell format from another cell in the template."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the address of the cell to update."]
[null,null,"Fix - Enter the reference of the cell from which to copy the format."]
[]
[null,null,"CopyNewHideList - Copy the NewHideList from the NewHideList worksheet in the Fixer to the Settings sheet in the template"]
[]
[null,null,"Worksheet - Settings"]
[null,null,"Cell Reference - N/A"]
[null,null,"Fix - N/A"]
[]
[null,null,"CopyNewTable - copy a whole new table from this tool to the template."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the destination range address (where to copy the table to)."]
[null,null,"Fix - Enter the source range address on the ‘New Tables’ tab (where to copy the table from)."]
[null,null,"(Ensure that the table to be copied has been pasted into the ‘New Tables’ tab and any PFMS styles have been removed."]
[null,null,"For any formulas in the table ensure all = characters in the formula string has been replaced with the tilde ~ character, and an entry made after ‘CopyNewTable’ under the ‘Formularise’ option to re-activate the formulas)"]
[]
[null,null,"CopyWorksheet - copy a whole worksheet from this tool to the template."]
[]
[null,null,"Worksheet - The name of the worksheet in the template before which the new worksheet is to be copied."]
[null,null,"Cell Reference - N/A"]
[null,null,"Fix - Enter the name of the worksheet to be copied from the tool to the Template. Note - Do not copy any of the following worksheets: Main, File List, Fix List, Customiser, Settings, Omit Versions by Trust, Internal Guidance."]
[]
[null,null,"DeleteColumn - Delete the column containing the specified cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter a cell address for row 1 of the column to be deleted - for example, enter $C$1 to delete column C"]
[null,null,"Fix - N/A"]
[]
[null,null,"DeleteRow - Delete the row containing the specified cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter a cell address for column A of the row to be deleted - for example, enter $A$3 to delete row 3"]
[null,null,"Fix - N/A"]
[]
[null,null,"DeleteWorksheet - Delete the specified worksheet."]
[]
[null,null,"Worksheet - The name of the worksheet to be deleted."]
[null,null,"Cell Reference - N/A"]
[null,null,"Fix - N/A"]
[]
[null,null,"Divide1000 - Divide the number in the selected cell by 1000 and update the cell with the new value."]
[]
[null,null,"Worksheet - The name of the worksheet to be deleted."]
[null,null,"Cell Reference - N/A"]
[null,null,"Fix - N/A"]
[]
[null,null,"Formula - Add a formula to a cell"]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - The address of the cell to be updated."]
[null,null,"Fix - The formula to be entered into the cell. Remember to prefix the formula with a single quote ('), and to use an equals sign"]
[]
[null,null,"Formularise – used in conjunction with CopyNewTable where required, used to re-formularises text string formulas."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the cells and/or ranges addresses per the template destination, within a New table, to re-formularise."]
[null,null,"Fix – Leave blank"]
[]
[null,null,"HideColumnX - Hide the column containing the specified cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter a cell address for row 1 of the column to be hidden - for example, enter $C$1 to hide column C"]
[null,null,"Fix - N/A"]
[]
[null,null,"HideSheet - Hide the specified worksheet."]
[]
[null,null,"Worksheet - The name of the worksheet to be hidden."]
[null,null,"Cell Reference - N/A"]
[null,null,"Fix - N/A"]
[]
[null,null,"HideShowRow - If column 1 of the specified row contains \"Hide\" then hide it, otherwise display it."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter the number of the row to be hidden/displayed - for example, enter 3 to hide row 3"]
[null,null,"Fix - N/A"]
[]
[null,null,"HideShowWS - If cell A1 of the specified worksheet contains \"Hide\" then hide the worksheet, otherwise display it."]
[]
[null,null,"Worksheet - The name of the worksheet to be hidden/displayed."]
[null,null,"Cell Reference - N/A"]
[null,null,"Fix - N/A"]
[]
[null,null,"InsertCells - insert a cell to the left of the selected cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - the address of the cell to which a cell will be inserted to the left."]
[null,null,"Fix - N/A"]
[]
[null,null,"Lock - Lock the selected cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - the address of the cell to Lock."]
[null,null,"Fix - N/A"]
[]
[null,null,"Message - Select the cell specified, and then display a message."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - the address of the cell to select."]
[null,null,"Fix - The text of the message to display."]
[]
[null,null,"NamedRange - Give the cells a name"]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - the address of the cell/range to name."]
[null,null,"Fix - The name to give the cells."]
[]
[null,null,"NumberFormat - Update the number format of the selected cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - the address of the cell to update."]
[null,null,"Fix - The new number format to use."]
[]
[null,null,"Protect - Protect the specified worksheet with a password."]
[]
[null,null,"Worksheet - The name of the worksheet to protect"]
[null,null,"Cell Reference - N/A"]
[null,null,"Fix - N/A"]
[]
[null,null,"RemoveDataValidation - remove the data validation from the specified cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - The address of the cell to update."]
[null,null,"Fix - N/A"]
[]
[null,null,"RenameWorksheet - Rename the specified worksheet."]
[]
[null,null,"Worksheet - The name of the worksheet to update."]
[null,null,"Cell Reference - N/A"]
[null,null,"Fix - The new name of the worksheet"]
[]
[null,null,"RowHeight - Set the height of the row containing the specified cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - Enter a cell address for column A of the row to be resized - for example, enter $A$3 to resize row 3"]
[null,null,"Fix - The new height of the row,"]
[]
[null,null,"Text - Amend the contents of the specified cell. Note - This may be either text or a number, but not a formula."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - The address of the cell to update."]
[null,null,"Fix - The new text."]
[]
[null,null,"Unlock - Unlock the selected cell."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - The address of the cell to update."]
[null,null,"Fix - N/A"]
[]
[null,null,"UnMerge - Ensure that the selected cell is not merged with other cells."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - The address of the cell to update."]
[null,null,"Fix - N/A"]
[]
[null,null,"ValidationMaxMin - Set validation to the Maximum/Minimum in the settings sheet."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - The address of the cell to update."]
[null,null,"Fix - Use Positive to only allow figures between 0 and the maximum above 0"]
[null,null,"Use Negative to only allow figures between 0 and the minimum below 0\nUse Positive/Negative to only allow figures between the minimum below 0 and the maximum above 0"]
[]
[null,null,"WrapText - Change the formatting of the selected cell to have wrapping."]
[]
[null,null,"Worksheet - The name of the worksheet."]
[null,null,"Cell Reference - The address of the cell to update."]
[null,null,"Fix - N/A"]
[]
[null,null,"Completing the Version List"]
[]
[null,null,"The version list is located in the Settings sheet. It must contain all the versions of the template, including the initial version and all the versions referred to in the Fix List sheet. All the versions in the version list must be in Chronological order and increase in number down the page. There must be no gaps in the list."]
[]
[null,null,"Working with the Customiser"]
[]
[null,null,"The Customiser worksheet allows the tool to update cells with data on an individual trust basis."]
[]
[null,null,"The Customiser worksheet is made up of three elements:\nA Trust List, alphabetical by NHS Code, down the left hand side.\nDetails of Changes - Description, the Worksheet and the Cell Address it affects in rows 1-3, across the top.\nValues to be used in customisation in the main block outlined by the Trust List and the changes."]
[]
[null,null,"Ensure that the Trust List includes all the trusts for which changes are scheduled. If a trust is omitted, the trust's template will not be updated with any customisation. Do not leave any gaps in Column A of the list."]
[]
[null,null,"The list of trusts does not require the MARSIDs or full names of the trusts, but these can be helpful in identifying trusts."]
[]
[null,null,"The list of cells to customise must start in column D, and must not have any gaps in rows 1- 4."]
[]
[null,null,"• Enter a description in row 1. If no description is required, just enter Fix n."]
[null,null,"• Enter the worksheet to which the change will be made in row 2. Make sure it is spelled correctly, or an error will occur."]
[null,null,"• Enter the cell address to which the change will be made in row 3. Make sure to put in the correct address and that the address uses the correct format (A1) or the update will be made incorrectly."]
[]
[null,null,"Ensure that Run Customiser in the Settings Sheet is set to Yes."]
[]
[null,null,"If Ignore Blanks in Customiser on the settings sheet is set to Yes, and the table contains blank cells, these will be ignored during customisation; if it is set to No, blanks will be written to the template as updates."]
[]
[null,null,"Locking and Unlocking the tool"]
[]
[null,null,"This tool must always be locked before sending to Trusts. "]
[]
[null,null,"Locking the tool hides all the worksheets except the Main and Fix List sheet. All worksheets are protected with a password. The names of all named ranges are hidden.\n\nUnlocking the tool displays and unprotects all the worksheets. The names of all named ranges are displayed."]
[]
[null,null,"• To lock the tool, open the Macros Dialog box (Alt + F8), in the Macro Name field, type LockWorkbook, and then click on the Run button."]
[null,null,"• To unlock the tool, open the Macros Dialog box (Alt + F8), in the Macro Name field, type UnlockWorkbook, and then click on the Run button."]
[]
[null,null,"Working with the Trust List"]
[]
[null,null,"This tool contains a list of Trusts in the Customiser sheet. This can be updated using the Trust List settings in the Settings sheet:\n\n• Ensure that the correct Database Connection is selected in the Database settings.\n• Select the appropriate criteria from the Trust List Settings for the list of trusts you wish to download (see below),\n• Click the Get Trust Data button to connect to the database and download the list of trusts to the Customiser worksheet."]
[]
[null,null,"Trust List Options"]
[]
[null,null,"Regions"]
[]
[null,null,"There are five Region options - \n\n• North\n• South  \n• London \n• Midlands \n• Adjustment. \n\nPlace a Yes beside the regions required. \n\nSelecting North, South, Midlands or London will return trusts from the respective regions.\n\nAdjustment is not a geographical region. When this is selected, trusts used by Sector Reporting for Adjustments are returned."]
[]
[null,null,"Sectors"]
[]
[null,null,"There are five Sector options:\n\n• Mental Health\n• Acute\n• Specialist\n• Community \n• Ambulance\n\nPlace a Yes beside the sectors required."]
[]
[null,null,"Other Options"]
[]
[null,null,"Trust Type - Use the drop-down list to select the types of trust required - FT (Foundation Trusts), Trust (NHS Trusts) or All Trusts."]
[null,null,"Order By - Select to order the results by MARSID or NHS Code, using the drop down list."]
[null,null,"Include Inactive Trusts - You can select whether or not to include inactive trusts or to only select inactive trusts using the drop down list."]