{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Monitor Fixer","FTC Fixer","FixList","ErrorTypes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Monitor Fixer","index":0,"n_rows":121,"n_cols":7,"rows_kept":121,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Monitor use only FTC 1213 to December 2012 9mo fixer "]
[]
[null,"This workbook contains code which will update Monitor's 2012-13 FTC template from version 1.8.1 (or later) to the latest version "]
[null,"We recommend you: "]
[null,"1. Input the source folder below (containing the copy FTC returns that need fixing), then"]
[null,"2. Select the destination folder below (to contain fixed copies of the FTC), then"]
[null,"3. Press the button below and follow the instuctions that appear."]
[]
[]
[]
[]
[null,"Source Folder:","\\\\irnrep\\c$\\FTCData\\ToFix\\2012-13-M9-Return-003\\"]
[null,"Destination Folder:","\\\\irnrep\\c$\\FTCData\\Toload\\"]
[null,null,82]
[]
[null,"MARSID","Date Time","Result","Version From","Version To","File Name"]
[null,"KINGSLYNN","2013-02-25T17:04:47","Success","V1.8.1A","V1.8.1E","KINGSLYNN 2012-13 FTC for 9 months data.xlsm"]
[null,"MOORFIELDS","2013-02-25T17:04:53","Success","V1.8.1D","V1.8.1E","MOORFIELDS 2012-13 FTC for 9 months data (draft 20130123) Current.xlsm"]
[null,"AIREDALE","2013-02-25T17:09:11","Success","V1.8.1A","V1.8.1E","AIREDALE 2012-13 FTC for 9 months data for IandE Submitted 21.02.13.xlsm"]
[null,"ALDERHEY","2013-02-25T17:09:16","Success","V1.8.1D","V1.8.1E","ALDERHEY 2012-13 FTC for 9 months data RESUBMISSION 220213.xlsm"]
[null,"SHEFFIELDCHILD","2013-02-25T17:09:21","Success","V1.8.1D","V1.8.1E","AOB DRAFT v3 SHEFFIELDCHILD 2012-13 FTC for 9 months data.xlsm"]
[null,"ASHFORD","2013-02-25T17:09:26","Success","V1.8.1D","V1.8.1E","ASHFORD 2012-13 FTC for 9 months data(1).xlsm"]
[null,"BARNSLEY","2013-02-25T17:09:32","Success","V1.8.1A","V1.8.1E","BARNSLEY 2012-13 FTC 9 months Final submission 25 Feb 13.xlsm"]
[null,"BASILDON","2013-02-25T17:09:42","Success","V1.8.1B","V1.8.1E","BASILDON 2012-13 FTC for 9 months data for final submission.xlsm"]
[null,"BCH","2013-02-25T17:09:49","Success","V1.8.1A","V1.8.1E","BCH 2012-13 FTC for 9 months data - submitted 13-02-25.xlsm"]
[null,"BERKSHIREHEALTH","2013-02-25T17:09:56","Success","V1.8.1A","V1.8.1E","BERKSHIREHEALTH_2012-13_FTC_for_9_months_data_v5_AoB_refresh 25022013.xlsm"]
[null,"BIRMWOMEN","2013-02-25T17:10:01","Success","V1.8.1D","V1.8.1E","BIRMWOMEN 2012-13 FTC for 9 months data 04_02_13(1).xlsm"]
[null,"BLACKPOOL","2013-02-25T17:10:11","Success","V1.8.1B","V1.8.1E","BLACKPOOL 2012-13 FTC for 9 months data(1).xlsm"]
[null,"BOURNEMOUTH","2013-02-25T17:10:18","Success","V1.8.1A","V1.8.1E","BOURNEMOUTH_2012-13_FTC_for_9_months_data_I_E 250213.xlsm"]
[null,"BURTON","2013-02-25T17:10:26","Success","V1.8.1A","V1.8.1E","BURTON 2012-13 FTC for 9 months data -2nd Feb Submission.xlsm"]
[null,"CAMBRIDGE","2013-02-25T17:10:33","Success","V1.8.1A","V1.8.1E","CAMBRIDGE 2012-13 FTC for 9 months data SUBMITTED 25-02-13.xlsm"]
[null,"CHESTERFIELD","2013-02-25T17:10:41","Success","V1.8.1D","V1.8.1E","CHESTERFIELD 2012-13 FTC for 9 months data(1).xlsm"]
[null,"CHRISTIE","2013-02-25T17:10:48","Success","V1.8.1A","V1.8.1E","CHRISTIE_2012-13_FTC_for_9_months_Resubmission(1).xlsm"]
[null,"COLCHESTER","2013-02-25T17:10:55","Success","V1.8.1D","V1.8.1E","COLCHESTER_2012-13_FTC_for_9_months_data v1.4 AOB.xlsm"]
[null,"SOUTHESSEX","2013-02-25T17:11:02","Success","V1.8.1D","V1.8.1E","SOUTHESSEX 2012-13 FTC month 9 25-02-2013.xlsm"]
[null,"SOUTHSTAFFS","2013-02-25T17:11:09","Success","V1.8.1A","V1.8.1E","SOUTHSTAFFS 2012-13 FTC for 9 months data with fixer 2013-01-14 and Revised Dr-Cr I-E.xlsm"]
[null,"SOUTHTYNESIDE","2013-02-25T17:11:16","Success","V1.8.1A","V1.8.1E","SOUTHTYNESIDE 2012-13 FTC for 9 months data v3(1).xlsm"]
[null,"STOCKPORT","2013-02-25T17:11:23","Success","V1.8.1A","V1.8.1E","STOCKPORT_2012-13_FTC_for_9_months_dataIEReturn22Feb13.xlsm"]
[null,"SUNDERLAND","2013-02-25T17:11:29","Success","V1.8.1D","V1.8.1E","SUNDERLAND 2012-13 FTC for 9 months data v2(1).xlsm"]
[null,"SURREYPART","2013-02-25T17:11:35","Success","V1.8.1D","V1.8.1E","SURREYPART 2012-13 FTC for 9 months data 25.02.13.xlsm"]
[null,"SUSSEXPART","2013-02-25T17:11:40","Success","V1.8.1D","V1.8.1E","SUSSEXPART 2012-13 FTC for 9 months data 25 feb.xlsm"]
[null,"SWARKS","2013-02-25T17:11:46","Success","V1.8.1B","V1.8.1E","SWARKS 2012-13 FTC for 9 months data 25-02-13.xlsm"]
[null,"SWESTAMB","2013-02-25T17:11:52","Success","V1.8.1D","V1.8.1E","SWESTAMB 2012-13 FTC for 9 months data 25Feb13.xlsm"]
[null,"TAMESIDE","2013-02-25T17:11:57","Success","V1.8.1D","V1.8.1E","TAMESIDE 2012-13 FTC for 9 months data(1).xlsm"]
[null,"TAVIPORT","2013-02-25T17:12:03","Success","V1.8.1A","V1.8.1E","TAVIPORT 2012-13 FTC for 9 months Resumbission 2.xlsm"]
[null,"TEWVALLEYS","2013-02-25T17:12:09","Success","V1.8.1D","V1.8.1E","TEWVALLEYS 2012-13 FTC for 9 months data - WGA 25-02-2013.xlsm"]
[null,"UCLH","2013-02-25T17:12:17","Success","V1.8.1A","V1.8.1E","UCLH 2012-13 FTC for 9 months data Template Final u21-02-2013.xlsm"]
[null,"UHB","2013-02-25T17:12:23","Success","V1.8.1D","V1.8.1E","UHB 1213 FTC v1.8.1 for month 9 data 25.02.13(v3).xlsm"]
[null,"UHSM","2013-02-25T17:12:28","Success","V1.8.1D","V1.8.1E","UHSM 2012-13 FTC for 9 months live(1).xlsm"]
[null,"WALTON","2013-02-25T17:12:33","Success","V1.8.1D","V1.8.1E","WALTON_2012-13_FTC_for_9_months_data resubmit 25 Feb.xlsm"]
[null,"WARRINGTON","2013-02-25T17:12:42","Success","V1.8.1D","V1.8.1E","WARRINGTON_2012-13_FTC_for_9_months_data(1)(1).xlsm"]
[null,"WESTSUFFOLK","2013-02-25T17:12:48","Success","V1.8.1D","V1.8.1E","WESTSUFFOLK 2012-13 FTC for 9 months data resubmission(1).xlsm"]
[null,"WIGAN","2013-02-25T17:12:53","Success","V1.8.1D","V1.8.1E","WIGAN 2012-13 FTC for 9 months data(1)(1).xlsm"]
[null,"WIRRAL","2013-02-25T17:12:59","Success","V1.8.1D","V1.8.1E","WIRRAL 2012-13 FTC for 9 months data(1).xlsm"]
[null,"YEOVIL","2013-02-25T17:13:06","Success","V1.8.1A","V1.8.1E","YEOVIL_2012-13_FTC_for_9_months_data(1).xlsm"]
[null,"YORKHOSPITAL","2013-02-25T17:13:11","Success","V1.8.1C","V1.8.1E","YORKHOSPITAL 2012-13 FTC for 9 months - Fixed (2)(1).xlsm"]
[null,"5BOROUGHSPART","2013-02-26T10:16:10","Success","V1.8.1D","V1.8.1E","5BOROUGHSPART 2012-13 FTC for 9 months data Resubmission(1).xlsm"]
[null,"BASINGSTOKE","2013-02-26T10:16:17","Success","V1.8.1A","V1.8.1E","BASINGSTOKE_2012-13_FTC_for_9_months_data RESUBMISSION V3.xlsx"]
[null,"CALDERDALE","2013-02-26T10:16:23","Success","V1.8.1D","V1.8.1E","CALDERDALE 2012-13 FTC for 9 months data fix 2 applied resubmission 22 02 13.xls"]
[null,"CHELSEA","2013-02-26T10:16:33","Success","V1.8.1","V1.8.1E","CHELSEA 2012-13 FTC mnth 9 Mismatch Resubmission 25213.xlsm"]
[null,"CHESTER","2013-02-26T10:16:38","Success","V1.8.1D","V1.8.1E","CHESTER 2012-13 FTC for 9 months data for submission(1).xlsm"]
[null,"GATESHEAD","2013-02-26T10:20:01","Success","V1.8.1D","V1.8.1E","GATESHEAD 2012-13 FTC for 9 months data-AOB resubmission v2.xlsm"]
[null,"GLOSPART","2013-02-26T10:20:08","Success","V1.8.1D","V1.8.1E","GLOSPART 2012-13 FTC for 9 months data(1).xlsm"]
[null,"HOMERTON","2013-02-26T10:20:14","Success","V1.8.1D","V1.8.1E","HOMERTON 2012-13 FTC for 9 months data v3.2.xlsm"]
[null,"KINGS","2013-02-26T10:20:21","Success","V1.8.1A","V1.8.1E","KINGS 2012-13 FTC for 9 months data - Submission 25-02-2013 v1.xlsm"]
[null,"MANCHESTER","2013-02-26T10:20:29","Success","V1.8.1A","V1.8.1E","MANCHESTER 2012-13 FTC for 9 months data(1).xlsm"]
[null,"NORTHANTSCARE","2013-02-26T10:20:37","Success","V1.8.1A","V1.8.1E","NORTHANTSCARE 2012-13 FTC 9 months resubmission.xlsm"]
[null,"NORTHUMBRIA","2013-02-26T10:20:43","Success","V1.8.1B","V1.8.1E","NORTHUMBRIA_2012-13_FTC_for_9_months_data_V3.xlsm"]
[null,"OXLEAS","2013-02-26T10:20:49","Success","V1.8.1A","V1.8.1E","OXLEAS 2012-13 FTC for 9 months data 12(1).xlsm"]
[null,"PAPWORTH","2013-02-26T10:20:57","Success","V1.8.1B","V1.8.1E","PAPWORTH 2012-13 FTC for 9 months data 190213.xlsm"]
[null,"PENNINECARE","2013-02-26T10:21:03","Success","V1.8.1D","V1.8.1E","PENNINECARE_2012-13_FTC FINAL IE AOB RESUMBIT 25-02-13.xlsm"]
[null,"RDASH","2013-02-26T10:21:09","Success","V1.8.1D","V1.8.1E","RDASH_2012-13_FTC_for_9_months_dataV1(1).xlsm"]
[null,"ROTHERHAM","2013-02-26T10:21:15","Success","V1.8.1D","V1.8.1E","ROTHERHAM 2012-13 FTC 9 Months RESUBMISSION.xls"]
[null,"ROYALSURREY","2013-02-26T10:21:23","Success","V1.8.1B","V1.8.1E","ROYALSURREY 2012-13 FTC for 9 months data(1).xlsm"]
[null,"SCENTRALAMB","2013-02-26T10:21:31","Success","V1.8.1A","V1.8.1E","SCENTRALAMB 2012-13 FTC for 9 months data(1).xlsm"]
[null,"SWYORKSPART","2013-02-26T10:21:37","Success","V1.8.1D","V1.8.1E","SWYORKSPART 2012-13 FTC for 9 months data(1).xlsm"]
[null,"CAMDEN","2013-02-26T17:26:05","Success","V1.8.1D","V1.8.1E","CAMDEN 2012-13 FTC for 9 months data-3rd submission.xlsm"]
[null,"CNWL","2013-02-26T17:26:14","Success","V1.8.1B","V1.8.1E","CNWL 2012-13 FTC for 9 months data AOB revised.xlsm"]
[null,"EASTLONDON","2013-02-26T17:26:21","Success","V1.8.1A","V1.8.1E","EASTLONDON 2012-13 FTC for 9 months data v3.xlsm"]
[null,"NORTHTEES","2013-02-26T17:26:28","Success","V1.8.1A","V1.8.1E","NORTHTEES 2012-13 FTC for 9 months data v6 post dr cr IE.xlsm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2013-02-13T13:16:02","Success",null,"V1.8.1E","SALISBURY FY1213 Q3 in year reporting template (to issue).xlsm"]
[null,"SECOASTAMB","2013-02-13T13:16:06","Success","V1.8.1D","V1.8.1E","SECOASTAMB 2012-13 FTC for 9 months data 110213.xlsm"]
[null,"SHEFFIELDHEALTH","2013-02-13T13:16:10","Success","V1.8.1D","V1.8.1E","SHEFFIELDHEALTH 2012-13 FTC for 9 months data 11-02-13 (DrsCrs).xlsm"]
[null,"SHEFFIELDTEACH","2013-02-13T13:16:15","Success","V1.8.1A","V1.8.1E","SHEFFIELDTEACH_2012-13_FTC_for_9_months_data.xlsm"]
[null,"SHERWOOD","2013-02-13T13:16:20","Success","V1.8.1A","V1.8.1E","SHERWOOD 2012-13 FTC for 9 months data12-2-13.xlsm"]
[null,"SOUTHAMPTON","2013-02-13T13:16:25","Success","V1.8.1A","V1.8.1E","SOUTHAMPTON_2012-13_FTC_for_9_months_data.xlsm"]
[null,"SOUTHDEVON","2013-02-13T13:16:29","Success","V1.8.1D","V1.8.1E","SOUTHDEVON 2012-13 v 181A FTC for 9 months data.xlsm"]
[null,"SOUTHEND","2013-02-13T13:16:34","Success","V1.8.1A","V1.8.1E","SOUTHEND 2012-13 FTC for 9 months data AOB Updates.xlsm"]
[null,"SOUTHSTAFFS","2013-02-13T13:16:39","Success","V1.8.1A","V1.8.1E","SOUTHSTAFFS 2012-13 FTC for 9 months data with fixer 2013-01-14.xlsm"]
[null,"SOUTHTEES","2013-02-13T13:16:46","Success","V1.8.1A","V1.8.1E","SOUTHTEES 2012-13 FTC for 9 months data 12 February 2013.xlsm"]
[null,"SOUTHTYNESIDE","2013-02-13T13:16:52","Success","V1.8.1A","V1.8.1E","SOUTHTYNESIDE 2012-13 FTC for 9 months data v3.xlsm"]
[null,"STOCKPORT","2013-02-13T13:16:56","Success","V1.8.1A","V1.8.1E","STOCKPORT_2012-13_FTC_for_9_months_data.xlsm"]
[null,"SUNDERLAND","2013-02-13T13:17:01","Success","V1.8.1D","V1.8.1E","SUNDERLAND 2012-13 FTC for 9 months data v2.xlsm"]
[null,"SURREYPART","2013-02-13T13:17:04","Success","V1.8.1D","V1.8.1E","SURREYPART 2012-13 FTC for 9 months data 12.02.13.xlsm"]
[null,"SUSSEXPART","2013-02-13T13:17:08","Success","V1.8.1D","V1.8.1E","SUSSEXPART 2012-13 FTC for 9 months data 12 feb.xlsm"]
[null,"SWARKS","2013-02-13T13:17:13","Success","V1.8.1B","V1.8.1E","SWARKS 2012-13 FTC for 9 months data.xlsm"]
[null,"SWESTAMB","2013-02-13T13:17:17","Success","V1.8.1D","V1.8.1E","SWESTAMB 2012-13 FTC for 9 months data Amended 12Feb13.xlsm"]
[null,"SWYORKSPART","2013-02-13T13:17:20","Success","V1.8.1D","V1.8.1E","SWYORKSPART 2012-13 FTC for 9 months data.xlsm"]
[null,"TAMESIDE","2013-02-13T13:17:24","Success","V1.8.1D","V1.8.1E","TAMESIDE 2012-13 FTC for 9 months data.xlsm"]
[null,"TEWVALLEYS","2013-02-13T13:17:28","Success","V1.8.1D","V1.8.1E","TEWVALLEYS 2012-13 FTC for 9 months data - WGA 6-02-13.xlsm"]
[null,"UCLH","2013-02-13T13:17:33","Success","V1.8.1A","V1.8.1E","UCLH 2012-13 FTC for 9 months data Template Final u11-02-2013.xlsm"]
[null,"UHB","2013-02-13T13:17:37","Success","V1.8.1D","V1.8.1E","UHB 1213 FTC v1.8.1 for month 9 data 11.02.13(v2).xlsm"]
[null,"WALTON","2013-02-13T13:17:40","Success","V1.8.1D","V1.8.1E","WALTON_2012-13_FTC_for_9_months_data resubmit I E.xlsm"]
[null,"WARRINGTON","2013-02-13T13:17:48","Success","V1.8.1D","V1.8.1E","WARRINGTON_2012-13_FTC_for_9_months_data(1).xlsm"]
[null,"WESTSUFFOLK","2013-02-13T13:17:53","Success","V1.8.1D","V1.8.1E","WESTSUFFOLK 2012-13 FTC for 9 months data resubmission.xlsm"]
[null,"WIGAN","2013-02-13T13:17:57","Success","V1.8.1D","V1.8.1E","WIGAN 2012-13 FTC for 9 months data(1).xlsm"]
[null,"WIRRAL","2013-02-13T13:18:01","Success","V1.8.1D","V1.8.1E","WIRRAL 2012-13 FTC for 9 months data.xlsm"]
[null,"YEOVIL","2013-02-13T13:18:06","Success","V1.8.1A","V1.8.1E","YEOVIL_2012-13_FTC_for_9_months_data.xlsm"]
[null,"YORKHOSPITAL","2013-02-13T13:18:10","Success","V1.8.1C","V1.8.1E","YORKHOSPITAL 2012-13 FTC for 9 months - Fixed (2).xlsm"]

{"sheet":"FTC Fixer","index":1,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FTC return fixing tool","2013-14 (9 months)"]
[]
[]
[null,"This workbook contains code which will update Monitor's 2013-14 FTC (9 month) template from version 1.9.0 (or later) to the latest version."]
[null,"We recommend you: "]
[null,"1. Save this file in the same folder as your working copy FTC return that needs updating, then"]
[null,"2. Make a backup copy of your working copy FTC return that needs updating, then"]
[null,"3. Press the button below and follow the instuctions that appear."]
[]
[null,"Warning: If this fixer does not complete successfully, do not save your workbook.  Please recommence this fixer on the last saved version of your FTC file for all changes to be applied in full."]
[]
[]
[]
[null,"when the verison number changes, there are new rows, columns or even new worksheets (\"tabs\")"]
[null,"when the verison number does not change but the letter after it does then formulas or text are being corrected and there are no new rows or columns or worksheets"]
[null,"Notes for version 1.9.0G:"]
[null,"Corrects issues as listed on Monitor website, full details of all changes are listed on worksheet \"fixlist\". (Letter in each row below indicates in which version of fixer they were fixed)"]
[null,"·         A: The column header on the third column of the SoFP has been corrected to state '1 April 2012'"]
[null,"·         A: Validation check 6 has been corrected to now correctly use F36 instead of D36"]
[null,"·         A: The 'Total' formulae in row 57 of '8.Staff' have now been corrected to include row 55"]
[null,"·         A: The narrative in cells B25 and B26 of tab 16 (investments) has been updated to signal that these rows are for gains/losses to be taken to the I&E and not OCI"]
[null,"·         B: The 'Total' formula in cell D73 of '41. Charity - non-consol' has been corrected to equal D50"]
[null,"·         B: The 'Total' formulae in row 153 of '41X. Charity - consol' have been corrected to sum rows 150 to 152"]
[null,"·         C: The narrative for HMRC, NHS Pension Scheme and the National Insurance Fund on Other WGA Balances tab has been corrected to explain the balances to be included"]
[null,"·         C: The year within the header of the Inventories movement note has been corrected"]
[null,"·         C: The formula for 'in year movement' on the Cash note has been corrected to exclude amounts transfering under normal absorption accounting."]
[null,"·         C: Minor typos have been corrected on the Free Text sheet"]
[null,"·         C: The note for movement aging of financial liabilities on sheet 32 has been re-numbered to be Note 40.5"]
[null,"·         C: Clarifications over the classification of charitable fund expenditure where the FT has applied net accounting for recharges have been included on Sheet 41X"]
[null,"·         C: Total formulae on Note 5.2 on tab 9, column C have been corrected to sum all columns"]
[null,"·         D: Corrected formula in total cell (H16) on 'WGA - 1314 FT trans' tab"]
[null,"·         D: Corrected formulas for local government and other WGA rows to include accruals on 'WGA - 1314 trans rec' and 'WGA - 31Dec13 bal rec' tabs"]
[null,"·         E: Corrected formula in cell H217 on JOCs tab"]
[null,"·         E: Corrected formulas in row 50 on 'WGA - 1314 trans rec' tab"]
[null,"·         F: Corrected cells in investments (tab 16) and AHFS (tab 17) charity columns for 'balances for new FTs' which were wrongly including figures [only affects FTs authorised during 2011/12 who are consolidating charities with either investments or AHFS]"]
[null,"·         F: Corrected JOC 25 (cell H388) formula"]
[null,"·         F: Corrected validations 94 and 95 (for on-SOFP pension schemes)"]
[null,"·         G: Removed in-cell validations from 'Accrued' columns on all WGA sheets to allow negative input for accrued credit notes"]
[null,"·         G: Unlocked cells O42 and O43 on sheet '11. Finance' to allow input into 'external to government' for overdrafts and commercial loans"]
[null,"·         G: Added total formula for column F in 'Reconcile to Q3 Return'"]

{"sheet":"FixList","index":2,"n_rows":95,"n_cols":8,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Reference","worksheet","cell","type","wrong","correct","fixed in version","issue date"]
[1,"Validations","A188","Formula","=CELL(\"address\",'21. CCE'!D36)","=CELL(\"address\",'21. CCE'!F36)","V1.9.0A","2014-01-03"]
[1,"Validations","C188","Hyperlink","'21. CCE'!D36","'21. CCE'!F36","V1.9.0A","2014-01-03"]
[2,"8. Staff","C57","Formula","=C46+C47+C48+C49+C50+C51+C52+C53+C54+C56","=SUM(C46:C56)","V1.9.0A","2014-01-03"]
[2,"8. Staff","D57","Formula","=D46+D47+D48+D49+D50+D51+D52+D53+D54+D56","=SUM(D46:D56)","V1.9.0A","2014-01-03"]
[2,"8. Staff","E57","Formula","=E46+E47+E48+E49+E50+E51+E52+E53+E54+E56","=SUM(E46:E56)","V1.9.0A","2014-01-03"]
[2,"8. Staff","F57","Formula","=F46+F47+F48+F49+F50+F51+F52+F53+F54+F56","=SUM(F46:F56)","V1.9.0A","2014-01-03"]
[2,"8. Staff","G57","Formula","=G46+G47+G48+G49+G50+G51+G52+G53+G54+G56","=SUM(G46:G56)","V1.9.0A","2014-01-03"]
[2,"8. Staff","H57","Formula","=H46+H47+H48+H49+H50+H51+H52+H53+H54+H56","=SUM(H46:H56)","V1.9.0A","2014-01-03"]
[3,"2. SOFP","F12","Formula","=\"1 April \"&ComparativeYear","=TEXT(ComparativeYearStart,\"dd mmm yyyy\")","V1.9.0A","2014-01-03"]
[4,"16. Investments","B25","Text","Fair value gains (revaluations)","Fair value gains [taken to I&E]","V1.9.0A","2014-01-03"]
[4,"16. Investments","B26","Text","Fair value losses (impairment)","Fair value losses (impairment) [taken to I&E]","V1.9.0A","2014-01-03"]
[5,"41. Charity - non-consol","D73","Formula","=D54","=D50","V1.9.0B","2014-01-07"]
[6,"41X. Charity - Consol","D153","Formula","=D150+D151","=SUM(D150:D152)","V1.9.0B","2014-01-07"]
[6,"41X. Charity - Consol","E153","Formula","=E150+E151","=SUM(E150:E152)","V1.9.0B","2014-01-07"]
[6,"41X. Charity - Consol","F153","Formula","=F150+F151","=SUM(F150:F152)","V1.9.0B","2014-01-07"]
[6,"41X. Charity - Consol","G153","Formula","=G150+G151","=SUM(G150:G152)","V1.9.0B","2014-01-07"]
[6,"41X. Charity - Consol","H153","Formula","=H150+H151","=SUM(H150:H152)","V1.9.0B","2014-01-07"]
[7,"WGA - 31Dec13 Other WGA bal","B21","Format",null,"Text","V1.9.0C","2014-01-10"]
[7,"WGA - 31Dec13 Other WGA bal","B21","Text","HM Revenue & Customs - Other taxes and duties (Not PAYE)","HM Revenue & Customs - Other taxes and duties (including o/s PAYE creditor)","V1.9.0C","2014-01-10"]
[7,"WGA - 31Dec13 Other WGA bal","B23","Format",null,"Text","V1.9.0C","2014-01-10"]
[7,"WGA - 31Dec13 Other WGA bal","B23","Text","National Insurance Fund  (Employer contributions only - Revenue Expenditure)","National Insurance Fund  (both Employee and Employer contributions o/s)","V1.9.0C","2014-01-10"]
[7,"WGA - 31Dec13 Other WGA bal","B25","Format",null,"Text","V1.9.0C","2014-01-10"]
[7,"WGA - 31Dec13 Other WGA bal","B25","Text","NHS Pension Scheme (Own staff employers contributions only plus other invoiced charges)","NHS Pension Scheme (both employee and employer contributions o/s plus other invoiced charges)","V1.9.0C","2014-01-10"]
[8,"19. Inventory","D16","Text","2012/13","=CurrentFY","V1.9.0C","2014-01-10"]
[8,"19. Inventory","E16","Text","2012/13","=CurrentFY","V1.9.0C","2014-01-10"]
[8,"19. Inventory","F16","Text","2012/13","=CurrentFY","V1.9.0C","2014-01-10"]
[8,"19. Inventory","G16","Text","2012/13","=CurrentFY","V1.9.0C","2014-01-10"]
[8,"19. Inventory","H16","Text","2012/13","=CurrentFY","V1.9.0C","2014-01-10"]
[8,"19. Inventory","I16","Text","2012/13","=CurrentFY","V1.9.0C","2014-01-10"]
[8,"19. Inventory","J16","Text","2012/13","=CurrentFY","V1.9.0C","2014-01-10"]
[9,"21. CCE","C22","Formula","=C23-C18-C20-C19","=C23-sum(C18:C21)","V1.9.0C","2014-01-10"]
[9,"21. CCE","E22","Formula","=E23-E20-E19-E18","=E23-sum(E18:E21)","V1.9.0C","2014-01-10"]
[10,"40. Free Text","C29","Text","Details of arrangements involving the FT pleding finacnial assets as collateral","Details of arrangements involving the FT pledging financial assets as collateral","V1.9.0C","2014-01-10"]
[10,"40. Free Text","C36","Text","Details of Other NHS clincial income","Details of Other NHS clinical income","V1.9.0C","2014-01-10"]
[11,"32. FI 1","B69","Text","Note 41.5 Maturity of Financial liabilities","Note 40.5 Maturity of Financial liabilities","V1.9.0C","2014-01-10"]
[12,"41X. Charity - Consol","L43","Format",null,"Text","V1.9.0C","2014-01-10"]
[12,"41X. Charity - Consol","L43","Text",null,"Note - where the FT has used net accounting to account for this recharge (thus recognising no income or expenditure in the Trust only accounts), the expenditure within the charity should be disclosed as though made directly to the employee and included in row 46.","V1.9.0C","2014-01-10"]
[12,"41X. Charity - Consol","L48","Format",null,"Text","V1.9.0C","2014-01-10"]
[12,"41X. Charity - Consol","L48","Text",null,"Note - where the FT has used net accounting to account for this recharge (thus recognising no income or expenditure in the Trust only accounts), the expenditure within the charity should be disclosed as though made directly to the employee and included in row 52.","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C27","Formula","=D27+E27+F27+G27","=SUM(D27:O27)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C28","Formula","=D28+E28+F28+G28","=SUM(D28:O28)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C29","Formula","=D29+E29+F29+G29","=SUM(D29:O29)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C33","Formula","=D33+E33+F33+G33","=SUM(D33:O33)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C34","Formula","=D34+E34+F34+G34","=SUM(D34:O34)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C35","Formula","=D35+E35+F35+G35","=SUM(D35:O35)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C39","Formula","=D39+E39+F39+G39","=SUM(D39:O39)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C40","Formula","=D40+E40+F40+G40","=SUM(D40:O40)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C41","Formula","=D41+E41+F41+G41","=SUM(D41:O41)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C45","Formula","=D45+E45+F45+G45","=SUM(D45:O45)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C46","Formula","=D46+E46+F46+G46","=SUM(D46:O46)","V1.9.0C","2014-01-10"]
[13,"9. Op Misc","C47","Formula","=D47+E47+F47+G47","=SUM(D47:O47)","V1.9.0C","2014-01-10"]
[14,"WGA - 1314 FT trans","H16","Formula","=D16+F16+G16","=SUM(D16:G16)","V1.9.0D","2014-01-13"]
[15,"WGA - 1314 trans rec","C51","Formula","='WGA - 1314 Local Gov trans'!D16","='WGA - 1314 Local Gov trans'!D16+'WGA - 1314 Local Gov trans'!E16","V1.9.0D","2014-01-13"]
[15,"WGA - 1314 trans rec","D51","Formula","='WGA - 1314 Local Gov trans'!I16","='WGA - 1314 Local Gov trans'!I16+'WGA - 1314 Local Gov trans'!J16","V1.9.0D","2014-01-13"]
[15,"WGA - 1314 trans rec","C55","Formula","='WGA - 1314 Other WGA trans'!D16","='WGA - 1314 Other WGA trans'!D16+'WGA - 1314 Other WGA trans'!E16","V1.9.0D","2014-01-13"]
[15,"WGA - 1314 trans rec","D55","Formula","='WGA - 1314 Other WGA trans'!I16","='WGA - 1314 Other WGA trans'!I16+'WGA - 1314 Other WGA trans'!J16","V1.9.0D","2014-01-13"]
[15,"WGA - 31Dec13 bal rec","C51","Formula","='WGA - 31Dec13 LocalGov bal'!D16","='WGA - 31Dec13 LocalGov bal'!D16+'WGA - 31Dec13 LocalGov bal'!E16","V1.9.0D","2014-01-13"]
[15,"WGA - 31Dec13 bal rec","D51","Formula","='WGA - 31Dec13 LocalGov bal'!I16","='WGA - 31Dec13 LocalGov bal'!I16+'WGA - 31Dec13 LocalGov bal'!J16","V1.9.0D","2014-01-13"]
[15,"WGA - 31Dec13 bal rec","C55","Formula","='WGA - 31Dec13 Other WGA bal'!D16","='WGA - 31Dec13 Other WGA bal'!D16+'WGA - 31Dec13 Other WGA bal'!E16","V1.9.0D","2014-01-13"]
[15,"WGA - 31Dec13 bal rec","D55","Formula","='WGA - 31Dec13 Other WGA bal'!I16","='WGA - 31Dec13 Other WGA bal'!I16+'WGA - 31Dec13 Other WGA bal'!J16","V1.9.0D","2014-01-13"]
[16,"WGA - 1314 NHS and DH trans","B16","Text","TOTAL English NHS Trust and DoH Receivables and Payables","TOTAL DH Group (excluding FTs) income and expenditure","V1.9.0D","2014-01-13"]
[16,"WGA - 31Dec13 NHS and DH bal","B16","Text","TOTAL English NHS Trust and DoH Receivables and Payables","TOTAL DH Group (excluding FTs) receivables and payables","V1.9.0D","2014-01-13"]
[17,"39. JOCs","H217","Formula","=SUM(H215:H216)","=SUM(H213:H216)","V1.9.0E","2014-01-14"]
[18,"WGA - 1314 trans rec","C50","Formula","=C45+C41+C37+C33+C29+C25+C21+C17","=C49+C45+C41+C37+C33+C29+C25+C21+C17","V1.9.0E","2014-01-14"]
[18,"WGA - 1314 trans rec","D50","Formula","=D45+D41+D37+D33+D29+D25+D21+D17","=D49+D45+D41+D37+D33+D29+D25+D21+D17","V1.9.0E","2014-01-14"]
[19,"16. Investments","G45","Formula","=IF(DoA<Settings!E10,0,'41X. Charity - consol'!K80)","=IF(DoA<Settings!D10,0,'41X. Charity - consol'!K80)","V1.9.0F","2014-01-16"]
[19,"17. AHFS","O36","Formula","=IF(DoA<Settings!E10,0,'41X. Charity - consol'!K88)","=IF(DoA<Settings!D10,0,'41X. Charity - consol'!K88)","V1.9.0F","2014-01-16"]
[20,"39. JOCs","H388","Formula","=H386+H387","=H386-H387","V1.9.0F","2014-01-16"]
[21,"34. Pensions","B63","Text","Net Liability/(asset) recognised in the SoFP at 31 March","Net (liability)/asset recognised in the SoFP at 31 March","V1.9.0F","2014-01-16"]
[21,"Validations","H1075","Formula","=IF(F1075=\"less\",-1,1)*INDIRECT(\"'\"&D1075&\"'!\"&E1075)","=IF(F1075=\"less\",-1,1)*ABS(INDIRECT(\"'\"&D1075&\"'!\"&E1075))","V1.9.0F","2014-01-16"]
[21,"Validations","H1087","Formula","=IF(F1087=\"less\",-1,1)*INDIRECT(\"'\"&D1087&\"'!\"&E1087)","=IF(F1087=\"less\",-1,1)*ABS(INDIRECT(\"'\"&D1087&\"'!\"&E1087))","V1.9.0F","2014-01-16"]
[22,"WGA - 1314 FT trans","E17:E163","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 FT trans","J17:J163","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 NHS and DH trans","F17:F354","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 NHS and DH trans","K17:K354","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 NHS and DH trans","F362:F416","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 NHS and DH trans","K362:K416","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 Local Gov trans","E17:E581","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 Local Gov trans","J17:J581","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 Other WGA trans","E17:E355","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 1314 Other WGA trans","J17:J355","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 FT bal","E17:E163","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 FT bal","J17:J163","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 NHS and DH bal","F17:F354","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 NHS and DH bal","K17:K354","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 NHS and DH bal","F362:F416","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 NHS and DH bal","K362:K416","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 LocalGov bal","E17:E581","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 LocalGov bal","J17:J581","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 Other WGA bal","E17:E355","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[22,"WGA - 31Dec13 Other WGA bal","J17:J355","Clearvalidation",null,null,"V1.9.0G","2014-01-20"]
[23,"11. Finance","O42:O43","Style","_No_Input","_InputCY","V1.9.0G","2014-01-20"]
[24,"Reconcile to Q3 return","F22","Formula",null,"=SUM(F17:F21)","V1.9.0G","2014-01-20"]
[25,"WGA - 31Dec13 Other WGA bal","B14","Text","Updated 8 Nov 2012","Updated 26 Nov 2013","V1.9.0G","2014-01-20"]

{"sheet":"ErrorTypes","index":3,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
["AddRow"]
["ClearContents"]
["CopyNewSheet"]
["CopyNewTable"]
["DeleteRow"]
["Format"]
["Formula"]
["HideColumn"]
["InsertCells"]
["Lock"]
["Message"]
["RowHeight"]
["Text"]
["Unlock"]