{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["FrontScreen","Instructions","1. Trust Info.","2. Reconciliation","3. Data Input","4. Summary","5. Sign-off","Field Definitions","Admin","2. Reconciliation (old style)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":122,"comments":3,"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":"FrontScreen","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["note: PLEASE ENSURE MACRO CONTENT IS ENABLED!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"[click on Monitor logo for sheet admin access]"]

{"sheet":"Instructions","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,1,8,18],[10,1,10,14],[11,1,11,14],[13,1,13,14],[24,1,24,14],[19,1,19,14],[20,1,20,14],[30,1,30,17],[31,1,31,17],[14,1,14,14],[16,1,16,14],[17,1,17,14],[25,1,25,14],[22,1,22,14],[23,1,23,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Stage 1"]
[null,"Complete the required information on the  \"1. Trust Info\"  worksheet."]
[]
[null,"Stage 2"]
[null,"Go to the \"2. Reconciliation\" worksheet and review the intended PLICS quantum ahead of starting PLICS data collection. Reconciliation of the PLICS costs to the final audited accounts and of PLICS activity to SUS data should take place subsequent to data input. Please also complete the overheads cost breakdown for the admitted patient care PLICS data."]
[]
[null,"Stage 3"]
[null,"Go to the \"3. Data Input\" worksheet and input your data. Guidance on the field definitions can be found in the \"Field Definitions\"  worksheet and in Chapter 4 of the Approved Costing Guidance published by Monitor and  available at:  https://www.gov.uk/government/publications"]
[]
[null,"Stage 4"]
[null,"Go to the \"4. Summary\" worksheet to sense-check your data submission. Please ensure both validation checks register a  'Pass' before continuing."]
[]
[null,"Stage 5"]
[null,"After stages 1 to 4 are complete, please complete the \"5. Sign-off\" worksheet.  Finally, save the workbook and submit it to Monitor via its secure portal. Participating organisations will be made aware of the exact details nearer the collection date."]

{"sheet":"1. Trust Info.","index":2,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,1,8,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please complete the following information:"]
[]
[]
[null,"Organisation Code:"]
[null,"(please select)"]
[]
[null,"Organisation Name:",null,{"$f":"IF(NOT(fp_org_code=\"\"),VLOOKUP(fp_org_code,org_code,2,FALSE),\"\")","v":""}]
[]
[null,"Primary Contact Name:"]
[null,"Primary Contact Email:"]
[null,"Primary Contact Telephone:"]
[]
[null,"Alternative Contact Name:"]
[null,"Alternative Contact Email:"]
[null,"Alternative Contact Telephone:"]
[]
[null,"Financial Year:",null,"2015/16"]
[]
[null,"PLICS Supplier:"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SysHeadline &\" v\"&SysVersion","v":"PLICS Data Collection Template 2015-16 v1"}]

{"sheet":"2. Reconciliation","index":3,"n_rows":157,"n_cols":10,"rows_kept":157,"cut":false,"hidden":false,"merged":[[65,3,65,4],[65,5,65,6],[67,5,67,6],[68,5,68,6],[69,5,69,6],[70,5,70,6],[71,5,71,6],[72,5,72,6],[73,5,73,6],[74,5,74,6],[75,5,75,6],[76,5,76,6],[77,5,77,6],[78,5,78,6],[79,5,79,6],[90,5,90,6],[91,5,91,6],[94,1,103,7],[80,5,80,6],[81,5,81,6],[82,5,82,6],[83,5,83,6],[84,5,84,6],[85,5,85,6],[86,5,86,6],[87,5,87,6],[88,5,88,6],[89,5,89,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Section 1 - Cost Reconciliation"]
[]
[null,"Section 1.1: Final Audited Accounts to PLICS Collection Patient Care Cost"]
[]
[null,null,null,"£ COST","Notes: FTs","Notes: NHS Trusts"]
[null,1,"Operating expenses",null,"SOCI sc105","TRU01 sc100 + sc110"]
[null,{"$f":"B21+1","v":2},"[ADD] Finance expenses financial liabilities (FTs) or finance costs (NHS trusts)",null,"SOCI sc120","TRU01 sc170"]
[null,{"$f":"B22+1","v":3},"[ADD] PDC dividends payable",null,"SOCI sc130","TRU01 sc190"]
[null,4,"[ADD] Finance expenses - unwinding of discount",null,"SOCI sc125","Not applicable"]
[null,5,"[ADD] Corporation tax expense",null,"SOCI sc145","Not applicable"]
[null,6,"PLICS Cost Quantum (Whole)",{"$f":"SUM(D21:D25)","v":0}]
[]
[null,{"$f":"B26+1","v":7},"[LESS] Non-Admitted Patient-Care Costs",null,null,null,"(relating to: outpatients, A&E, direct access services, healthcare at home, community services, any other non-admitted)"]
[null,{"$f":"B28+1","v":8},"[LESS] Non-Admitted Non-Patient-Care Costs",null,null,null,"(relating to: outpatients, A&E, direct access services, healthcare at home, community services, any other non-admitted)"]
[null,9,"PLICS Cost Quantum (Admitted)",{"$f":"D26-SUM(D28:D29)","v":0}]
[]
[null,{"$f":"B30+1","v":10},"[LESS] NonEnglishNHS and NonNHS Admitted Patient-Care Costs (if applicable)",null,null,null,"(zero figures expected if NonEnglishNHS and NonNHS patients included in the return as (flagged) FCE rows on Data Input sheet)"]
[null,{"$f":"B32+1","v":11},"[LESS] NonEnglishNHS and NonNHS Admitted Non-Patient-Care Costs (if applicable)",null,null,null,"(zero figures expected if NonEnglishNHS and NonNHS patients included in the return as (flagged) FCE rows on Data Input sheet)"]
[null,12,"PLICS Cost Quantum (Admitted) (Included)",{"$f":"D30-SUM(D32:D33)","v":0},null,null,null,"(by NonEnglishNHS and NonNHS: private patients, overseas (non-reciprocal), armed forces,"]
[null,null,null,null,null,null,null,null,"Scotland Wales & NI, Channel Islands (exc. Isle of Man & Jersey) )"]
[null,{"$f":"B34+1","v":13},"[LESS] (Included) Admitted Non-Patient-Care Costs"]
[null,{"$f":"B36+1","v":14},"PLICS Patient Care Cost Quantum (Admitted) (Included)",{"$f":"D34-SUM(D36)","v":0}]
[]
[null,"Section 1.2: Variances to Data Input"]
[]
[null,null,"FROM DATA INPUT:"]
[null,{"$f":"B37+1","v":15},"Total Cost (Column BH from Data Input)",{"$f":"SUM('3. Data Input'!BH:BH)","v":0},null,null,"(this column total from the data input sheet represents patient care costs)"]
[]
[null,{"$f":"B42+1","v":16},"Difference between 14 and 15",{"$f":"D37-D42","v":0}]
[]
[null,"Section 1.3: Final Audited Accounts to PLICS Collection Patient Care Other Operating Income"]
[]
[null,null,null,"£ Other OP. INCOME","Notes: FTs","Notes: NHS Trusts"]
[null,18,"Other Operating Income/Other Operating Revenue",null,"SOCI sc102","TRU05 sc130","(expecting income entered as negative value)"]
[null,{"$f":"B49+1","v":19},"[ADD] Finance Income/ Investment Revenue",null,"SOCI sc115","TRU01 sc150","(expecting income entered as negative value)"]
[null,{"$f":"B50+1","v":20},"[ADD] Movement in fair value of investment property and other investments",null,"SOCI sc142","Not applicable","(expecting income entered as negative value)"]
[null,21,"[ADD] Share of profit/loss of associates / joint ventures",null,"SOCI sc140","Not applicable","(expecting income entered as negative value)"]
[null,22,"[ADD] Other Gains and Losses",null,"Not applicable","TRU01 sc160","(expecting income entered as negative value)"]
[null,23,"[LESS] Non-Admitted Other Operating Income",null,null,null,"(expecting income entered as negative value)(relating to: outpatients, A&E, direct access services, healthcare at home, community services, any other non-admitted)"]
[null,24,"[LESS] NonEnglishNHS and NonNHS Admitted Other Operating Income (if applicable)",null,null,null,"(expecting income entered as negative value)(zero figures expected if NonEnglishNHS patients included in the return as (flagged) FCE rows on Data Input sheet)"]
[null,{"$f":"B55+1","v":25},"PLICS Patient Care Other Operating Income Quantum (Admitted) (Included)",{"$f":"(D49+D50+D51+D52+D53)-SUM(D54:D55)","v":0}]
[]
[null,null,"FROM DATA INPUT:"]
[null,{"$f":"B56+1","v":26},"Other Income (Column BG from Data Input)",{"$f":"SUM('3. Data Input'!BG:BG)","v":0},null,null,"(this column total from the data input sheet represents other operating income)"]
[]
[null,{"$f":"B59+1","v":27},"Difference between 25 and 26",{"$f":"D56-D59","v":0}]
[]
[null,"Section 1.4: Variances explanation"]
[]
[null,"Please explain any variances identified in lines 16 and 27 above:"]
[null,"Line","Description",null,null,"Comments",null,"£"]
[]
[null,1,"[Insert description of variance factor]"]
[null,2,"[Insert description of variance factor]"]
[null,3,"[Insert description of variance factor]"]
[null,4,"[Insert description of variance factor]"]
[null,5,"[Insert description of variance factor]"]
[null,6,"[Insert description of variance factor]"]
[null,7,"[Insert description of variance factor]"]
[null,8,"[Insert description of variance factor]"]
[null,9,"[Insert description of variance factor]"]
[null,10,"[Insert description of variance factor]"]
[null,11,"[Insert description of variance factor]"]
[null,12,"[Insert description of variance factor]"]
[null,13,"[Insert description of variance factor]"]
[null,14,"[Insert description of variance factor]"]
[null,15,"[Insert description of variance factor]"]
[null,16,"[Insert description of variance factor]"]
[null,17,"[Insert description of variance factor]"]
[null,18,"[Insert description of variance factor]"]
[null,19,"[Insert description of variance factor]"]
[null,20,"[Insert description of variance factor]"]
[null,21,"[Insert description of variance factor]"]
[null,22,"[Insert description of variance factor]"]
[null,23,"[Insert description of variance factor]"]
[null,24,"[Insert description of variance factor]"]
[null,25,"[Insert description of variance factor]"]
[]
[null,"Additional Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Section 2 - Activity Reconciliation"]
[]
[null,null,null,null,"[WIP Level 2 & 3]","[WIP Level 2 & 3]","[WIP Level 3]",null,null,"(please note adjustments only apply to certain WIP levels)"]
[null,"Line","POD Type","Count of Episodes from Data Input","FCEs started AND completed in previous financial years FROM spells completed in financial year","FCEs completed in financial year FROM spells incomplete at FY end","End-of-year WIP 'partial' episodes","(Admitted Patient Care)\n Activity from SUS","Variance","Possible reasons for variance"]
[null,null,null,null,"+","-","-"]
[null,1,"Elective",{"$f":"COUNTIF('3. Data Input'!S:S,\"EL\")","v":0},null,null,null,null,{"$f":"D112+E112-F112-G112-H112","v":0}]
[null,2,"Non Elective",{"$f":"COUNTIF('3. Data Input'!S:S,\"NE\")","v":0},null,null,null,null,{"$f":"D113+E113-F113-G113-H113","v":0}]
[null,3,"Day Cases",{"$f":"COUNTIF('3. Data Input'!S:S,\"DC\")","v":0},null,null,null,null,0]
[null,4,"Regular Day or Night Admissions",{"$f":"COUNTIF('3. Data Input'!S:S,\"RP\")","v":0},null,null,null,null,0]
[]
[null,5,"Total",{"$f":"+SUM(D112:D115)","v":0},{"$f":"+SUM(E112:E115)","v":0},0,0,0,{"$f":"+SUM(I112:I115)","v":0}]
[]
[]
[null,"Section 3 - Breakdown of Overheads for Admitted Patient Care"]
[]
[null,"Line","Description","£"]
[]
[null,1,"Estates overhead costs"]
[null,"1a","Building insurance"]
[null,"1b","Building maintenance"]
[null,"1c","Capital charges - Buildings"]
[null,"1d","Cleaning"]
[null,"1e","Energy/Utilities (unless metered) "]
[]
[null,2,"Other overheads"]
[null,"2a","Board expenses"]
[null,"2b","Computer licences"]
[null,"2c","Finance"]
[null,"2d","General trust administration"]
[null,"2e","HR"]
[null,"2f","Information management"]
[null,"2g","Information technology"]
[null,"2h","Medical staff Management"]
[null,"2i","Organisational development"]
[null,"2j","Payroll"]
[null,"2k","Procurement"]
[null,"2l","Site security"]
[null,"2m","Strategic planning"]
[null,"2n","Training - Organisation Wide"]
[null,"2o","Consultancy Costs - Organisation Wide"]
[null,"2p","PFI Payments"]
[null,"2q","Interest payments"]
[null,"2r","Patient liaison and complaints"]
[null,"2s","Marketing and public relations"]
[null,"2t","Other"]
[]
[null,3,"Total Overheads",{"$f":"SUM(D124:D151)","v":0}]
[]
[null,{"$f":"B153+1","v":4},"Overheads (Column CI from Data Input)",{"$f":"SUM('3. Data Input'!CI:CI)","v":0},"(this column from the data input sheet represents all costs assigned to overheads costpool)"]
[]
[null,{"$f":"B155+1","v":5},"Difference between 3 and 4",{"$f":"D153-D155","v":0}]

{"sheet":"3. Data Input","index":4,"n_rows":11,"n_cols":92,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Commissioner","Anonymised Local Patient ID","Spell ID","Spell-Episode ID","Episode Start Date & Time","Episode End Date & Time","Anonymised Consultant/Care Provider Code","Admission Date & Time","Discharge Date & Time","Admission Method Code","Source of Admission Code","Discharge Method Code","Discharge Destination Code","Patient Gender","Patient Age","Patient Classification","Treatment Function Code","Main Specialty Code","Point of Delivery (POD)","FCE HRG (RC)","Spell HRG (RC)","Dominant Procedure Code","OPCS 1","OPCS 2","OPCS 3","OPCS 4","OPCS 5","OPCS 6","OPCS 7","OPCS 8","OPCS 9","OPCS 10","OPCS 11","OPCS 12","OPCS 13","ICD10 1","ICD10 2","ICD10 3","ICD10 4","ICD10 5","ICD10 6","ICD10 7","ICD10 8","ICD10 9","ICD10 10","ICD10 11","ICD10 12","ICD10 13","Critical Care LoS in Hours","Theatre Time in Minutes","Endoscopy Time in Minutes","Specialist Service Code","Fixed Costs","Semi-fixed Costs","Variable Costs","Education and training costs (non-patient care activity costs)","Research and development costs (non-patient care activity costs)","Other costs including commercial (non-patient care activity costs)","Other Income","Total Cost (Inclusive of Columns BI-CJ only)","Blood and Blood Products","CNST","Critical Care","High Cost Drugs","Chemotherapy Drugs ","All Other Drugs","Emergency Department","Imaging - Medical Staffing","Imaging - All Other Costs","Medical Staffing (excluding Imaging, Pathology & Other Diagnostics)","Operating Theatres","Other Clinical Supplies and Services","Other Diagnostics Tests -  Medical Staffing","Other Diagnostics Tests- All Other Costs","Outpatients","Pathology- Medical Staffing","Pathology- All Other Costs","Pharmacy Services","Prostheses/Implants/Devices","Radiotherapy","Secondary Commissioning Costs","Specialist Procedure Suites excluding Endoscopy Units","Specialist Procedure Suite - Endoscopy Units Only","Specialist Nursing Staff","Therapies","Wards","Overheads","Impairments","Non NHS patient flag","WIP Partial Episode Flag","Contracted Out/In Flag","Contracted Full or Part Cost"]

{"sheet":"4. Summary","index":5,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Validation checks:"]
[null,"Does the sum of the total cost (C15) equal the sum of fixed/variable elements(C26) (within £100)?",null,null,{"$f":"IF(ABS(C26-summary_total_cost_sum)>100,\"Fail\",\"Pass\")","v":"Pass"}]
[null,"Does the sum of the total cost (C15) equal the sum of cost pool elements(C57) (within £100)?",null,null,{"$f":"IF(ABS(C58-summary_total_cost_sum)>100,\"Fail\",\"Pass\")","v":"Pass"}]
[]
[null,"Key summary statistics (considers Data Input column BH)"]
[null,"Total costs of FCEs with costs greater than 0",{"$f":"SUMIF('3. Data Input'!BH:BH,\">0\")","v":0}]
[null,"Count of FCEs with costs greater than 0",{"$f":"COUNTIF('3. Data Input'!BH:BH,\">0\")","v":0}]
[null,"Count of FCEs with costs equal or less than 0",{"$f":"COUNTIF('3. Data Input'!BH:BH,\"<=0\")","v":0},"(there should not be any of these)"]
[null,"Count of FCEs (all)",{"$f":"COUNT('3. Data Input'!BH:BH)","v":0}]
[null,"Average cost per FCE with costs greater than 0",{"$f":"IF(summary_total_cost_sum>0,summary_total_cost_sum/summary_total_FCEs,\"\")","v":""}]
[]
[null,"Costs by Fixed/Variable"]
[null,"Cost Type","Value (£)","% of total"]
[null,"Fixed Costs",{"$f":"SUM('3. Data Input'!BA:BA)","v":0},{"$f":"IF($C$26>0,C23/$C$26,\"-\")","v":"-"}]
[null,"Semi Fixed Costs",{"$f":"SUM('3. Data Input'!BB:BB)","v":0},{"$f":"IF($C$26>0,C24/$C$26,\"-\")","v":"-"}]
[null,"Variable Costs",{"$f":"SUM('3. Data Input'!BC:BC)","v":0},{"$f":"IF($C$26>0,C25/$C$26,\"-\")","v":"-"}]
[null,"Total",{"$f":"SUM(C23:C25)","v":0},{"$f":"IF($C$26>0,C26/$C$26,\"-\")","v":"-"}]
[]
[null,"Costs by Cost Pool Groups"]
[null,"Cost Type ","Value (£)","% of total"]
[null,"Blood and Blood Products",{"$f":"SUM('3. Data Input'!BI:BI)","v":0},{"$f":"IF(NOT($C$58=0),C30/$C$58,\"-\")","v":"-"}]
[null,"CNST",{"$f":"SUM('3. Data Input'!BJ:BJ)","v":0},"-"]
[null,"Critical Care",{"$f":"SUM('3. Data Input'!BK:BK)","v":0},"-"]
[null,"High Cost Drugs",{"$f":"SUM('3. Data Input'!BL:BL)","v":0},"-"]
[null,"Chemotherapy Drugs ",{"$f":"SUM('3. Data Input'!BM:BM)","v":0},"-"]
[null,"All Other Drugs",{"$f":"SUM('3. Data Input'!BN:BN)","v":0},"-"]
[null,"Emergency Department",{"$f":"SUM('3. Data Input'!BO:BO)","v":0},"-"]
[null,"Imaging - Medical Staffing",{"$f":"SUM('3. Data Input'!BP:BP)","v":0},"-"]
[null,"Imaging - All Other Costs",{"$f":"SUM('3. Data Input'!BQ:BQ)","v":0},"-"]
[null,"Medical Staffing (excluding Imaging, Pathology & Other Diagnostics)",{"$f":"SUM('3. Data Input'!BR:BR)","v":0},"-"]
[null,"Operating Theatres",{"$f":"SUM('3. Data Input'!BS:BS)","v":0},"-"]
[null,"Other Clinical Supplies and Services",{"$f":"SUM('3. Data Input'!BT:BT)","v":0},"-"]
[null,"Other Diagnostics Tests -  Medical Staffing",{"$f":"SUM('3. Data Input'!BU:BU)","v":0},"-"]
[null,"Other Diagnostics Tests- All Other Costs",{"$f":"SUM('3. Data Input'!BV:BV)","v":0},"-"]
[null,"Outpatients",{"$f":"SUM('3. Data Input'!BW:BW)","v":0},"-"]
[null,"Pathology- Medical Staffing",{"$f":"SUM('3. Data Input'!BX:BX)","v":0},"-"]
[null,"Pathology- All Other Costs",{"$f":"SUM('3. Data Input'!BY:BY)","v":0},"-"]
[null,"Pharmacy Services",{"$f":"SUM('3. Data Input'!BZ:BZ)","v":0},"-"]
[null,"Prostheses/Implants/Devices",{"$f":"SUM('3. Data Input'!CA:CA)","v":0},"-"]
[null,"Radiotherapy",{"$f":"SUM('3. Data Input'!CB:CB)","v":0},"-"]
[null,"Secondary Commissioning Costs",{"$f":"SUM('3. Data Input'!CC:CC)","v":0},"-"]
[null,"Specialist Procedure Suites excluding Endoscopy Units",{"$f":"SUM('3. Data Input'!CD:CD)","v":0},"-"]
[null,"Specialist Procedure Suite - Endoscopy Units Only",{"$f":"SUM('3. Data Input'!CE:CE)","v":0},"-"]
[null,"Specialist Nursing Staff",{"$f":"SUM('3. Data Input'!CF:CF)","v":0},"-"]
[null,"Therapies",{"$f":"SUM('3. Data Input'!CG:CG)","v":0},"-"]
[null,"Wards",{"$f":"SUM('3. Data Input'!CH:CH)","v":0},"-"]
[null,"Overheads",{"$f":"SUM('3. Data Input'!CI:CI)","v":0},"-"]
[null,"Impairments",{"$f":"SUM('3. Data Input'!CJ:CJ)","v":0},"-"]
[null,"Total of cost elements",{"$f":"SUM(C30:C57)","v":0},{"$f":"SUM(D30:D57)","v":0}]

{"sheet":"5. Sign-off","index":6,"n_rows":41,"n_cols":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[28,2,28,16],[29,2,29,16],[30,2,30,16],[9,1,9,18],[23,1,23,17],[19,13,19,17],[20,1,20,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(sign_off_subready=1,W35,W34)","v":"Template not ready for submission. Please complete the above steps."}]
[]
[null,"Template completion steps"]
[]
[null,null,"'1. Trust Info'  worksheet completed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"V14*1","v":0}]
[null,null,"'2. Reconciliation' worksheet reviewed to clarify correct PLICS quantum ahead of PLICS system running.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"V15*1","v":0}]
[null,null,"'3. Data Input' worksheet populated but contains NO patient identifiable data such as NHS number, DOB, patient name, address or postcode.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,0]
[null,null,"'4. Summary' reviewed for validation errors and sense-check of costs and both validation checks register a 'pass'.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"V17*1","v":0}]
[null,null,"'2. Reconciliation' worksheet completed and reviewed in concert with '3. Data Input'. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,0]
[null,null,"Materiality and Quality Scores (MAQS) template has been completed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,0]
[null,null,"Submission is reviewed and signed off by the Director of Finance",null,null,null,null,null,null,null,null,null,"Please enter Director of Finance Name:",null,null,null,null,null,null,null,null,false,{"$f":"V20*COUNTA(sign_off_DOFname)","v":0}]
[null,"Do you believe this PLICS data submission is in compliance with the requirements set out by Monitor in that the HFMA's Acute Clinical Costing Standards have been followed?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[null,null,"Yes",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"(V22=1)*1","v":0},null,null,null,null,null,"(only one of these rows can be a 1)"]
[null,"Please provide a brief explanation where HFMA's Acute Clinical Costing Standards have NOT been followed when preparing this submission:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(V22=2)*COUNTA(sign_off_comply_comment)","v":0},null,"if 'No' checked then comment demanded",null,null,null,"(only one of these rows can be a 1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,"  How many patient level feeds do you use in your patient level costing?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(B26)","v":0}]
[null,"Method for accounting for work-in-progress - please select a method",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,"Level 1 - All episodes within spells that were completed within the financial year are costed. This may include episodes which actually started in a previous reporting period. This is the approach currently set out in the Department of Health’s reference cost guidance. This is the minimum standard for costing work in progress and should be achievable by all organisations. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"(V29>0)*1","v":0}]
[null,null,"Level 2 - All episodes completed in the financial reporting period are costed, irrespective of when the episode or the spell started. This may include episodes started in the previous financial reporting period."]
[null,null,"Level 3 - The following episodes or partial episodes are costed:\na) the in-year portion of episodes in progress at the start of the financial reporting period\nb) full episodes (that is, started and completed) within the financial reporting period\nc) the in-year portion of episodes incomplete at the end of the financial reporting period."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum:","target:","SubReady:"]
["hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W14:W16,W17:W31)","v":0},10,{"$f":"(W33=X33)*1","v":0}]
["hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Template not ready for submission. Please complete the above steps."]
["hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Template ready for submission!"]
["hide"]
["hide"]
["hide"]
["hide"]
["hide"]
["hide"]

{"sheet":"Field Definitions","index":7,"n_rows":103,"n_cols":4,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Field Name","Description","Format"]
[null,"Commissioner","Three-digit organisation code of the commissioner. For non-NHS patients (see definition below) please use “X98” as the Commissioner code.\n","Text"]
[null,"Anonymised Local Patient ID","Consistently anonymised local patient ID. Participating organisations should not include any patient identifiable data, such as NHS numbers, in this data field. \n","Free Text (excluding !”^&}/])"]
[null,"Spell ID","Local spell ID. Any patient identifiable data should not be included in this data field.  \n","Free Text (excluding !”^&}/])"]
[null,"Spell-Episode ID","Local episode ID. Any patient identifiable data should not be included in this data field. Please note this should be the spell ID and the episode order number concatenated. For example 5000001.1 would mean the is the first episode within the spell 5000001 .\n","Free Text (excluding !”^&}/])"]
[null,"Episode Start Date & Time","The start date and time of the finished consultant episode (FCE). \nIf your costing system or feeds are not able to supply time please provide date here and do not construct a 'dummy' time.\n","Serial DateTime\n[dd/mm/yyyy hh:mm]"]
[null,"Episode End Date & Time","The end date and time of the finished consultant episode (FCE). \nIf your costing system or feeds are not able to supply time please provide date here and do not construct a 'dummy' time.\n","Serial DateTime\n[dd/mm/yyyy hh:mm]"]
[null,"Anonymised Consultant/Care Provider Code","The consultant or care provider code for the finished consultant episode.\n","Text"]
[null,"Admission Date & Time","The admission date and time for the spell. \nIf your costing system or feeds are not able to supply time please provide date here and do not construct a 'dummy' time.\n","Serial DateTime\n[dd/mm/yyyy hh:mm]"]
[null,"Discharge Date & Time","The discharge date and time for the spell. \nIf your costing system or feeds are not able to supply time please provide date here and do not construct a 'dummy' time.\n","Serial DateTime\n[dd/mm/yyyy hh:mm]"]
[null,"Admission Method Code","The method of admission to a hospital spell. There is a set of national codes which are used to describe the method of admission, please see the NHS Data Dictionary.\n","Text"]
[null,"Source of Admission Code","Source of Admission Code.  There is a set of national codes which are used to describe the source of admission, please see the NHS Data Dictionary.\n","Text"]
[null,"Discharge Method Code","The method of discharge from a hospital provider spell. There is a set of national codes which are used to describe the method of discharge, please see the NHS Data Dictionary.\n","Text"]
[null,"Discharge Destination Code","The destination of a patient on completion of a hospital spell, or died or was a still birth. There is a set of national codes used to describe this, see the NHS Data Dictionary.\n","Text"]
[null,"Patient Gender","The Gender of the patient. Providers should use the following codes: “1” indicates male, “2” indicates female, “8” indicates not specified.\n","Text"]
[null,"Patient Age","Age of the patient in whole years at the date of admission.\n","Number"]
[null,"Patient Classification","This is a coded classification of patients who have been admitted to a provider spell. It is one of the mandatory fields used for HRG grouping. There is a set of national codes used to describe this, see the NHS Data Dictionary.\n","Number"]
[null,"Treatment Function Code","Treatment function code (TFC). Further guidance on TFCs can be found in the NHS Data Dictionary. Local treatment function codes or speciality codes will not be accepted.\n","Number"]
[null,"Main Specialty Code","Care Professional Main Specialty Code.  Further guidance on main specialty codes can be found in the NHS Data Dictionary. Local treatment function codes or speciality codes will not be accepted.\n","Text"]
[null,"Point of Delivery (POD)","Point of delivery. There are four points of delivery abbreviations used in this collection: \n• EL: elective inpatient,\n• NE: non elective inpatient (including both long stay and short stay episodes),\n• DC: day case, and\n• RP: regular day or night admissions (this POD is the same as the “RDNA” code used for the annual reference cost collection).\n","Text"]
[null,"FCE HRG (RC)","The FCE HRG based on the reference costs 2015-16 HRG4 grouper.\n","Text"]
[null,"Spell HRG (RC)","The spell HRG based on the reference costs 2015-16 HRG4 grouper.\n","Text"]
[null,"Dominant Procedure Code","Dominant Procedure Code as identified by the reference costs 2015-16 HRG4 grouper. \nThis OPCS code is selected by the grouper from the complement of OPCS codes attached to the episode by clinical coding and should be reported here additonally to the OPCS 1-13.\n","Text"]
[null,"OPCS 1","OPCS code [position #1]\nTo minimise the volume of data being collected, only up to 13 OPCS codes will be collected per episode.\n","Text"]
[null,"OPCS 2","OPCS code [position #2]\n","Text"]
[null,"OPCS 3","OPCS code [position #3]\n","Text"]
[null,"OPCS 4","OPCS code [position #4]\n","Text"]
[null,"OPCS 5","OPCS code [position #5]\n","Text"]
[null,"OPCS 6","OPCS code [position #6]\n","Text"]
[null,"OPCS 7","OPCS code [position #7]\n","Text"]
[null,"OPCS 8","OPCS code [position #8]\n","Text"]
[null,"OPCS 9","OPCS code [position #9]\n","Text"]
[null,"OPCS 10","OPCS code [position #10]\n","Text"]
[null,"OPCS 11","OPCS code [position #11]\n","Text"]
[null,"OPCS 12","OPCS code [position #12]\n","Text"]
[null,"OPCS 13","OPCS code [position #13]\n","Text"]
[null,"ICD10 1","ICD10 code [position #1]. \nTo minimise the volume of data being collected, only up to 13 ICD codes will be collected per episode.\n","Text"]
[null,"ICD10 2","ICD10 code [position #2]\n","Text"]
[null,"ICD10 3","ICD10 code [position #3]\n","Text"]
[null,"ICD10 4","ICD10 code [position #4]\n","Text"]
[null,"ICD10 5","ICD10 code [position #5]\n","Text"]
[null,"ICD10 6","ICD10 code [position #6]\n","Text"]
[null,"ICD10 7","ICD10 code [position #7]\n","Text"]
[null,"ICD10 8","ICD10 code [position #8]\n","Text"]
[null,"ICD10 9","ICD10 code [position #9]\n","Text"]
[null,"ICD10 10","ICD10 code [position #10]\n","Text"]
[null,"ICD10 11","ICD10 code [position #11]\n","Text"]
[null,"ICD10 12","ICD10 code [position #12]\n","Text"]
[null,"ICD10 13","ICD10 code [position #13]\n","Text"]
[null,"Critical Care LoS in hours","Patient’s length of stay in hours at a critical care unit.  For example, three and a half hours stay in a critical care unit should be recorded as 3.5. For patients who have more than one stay on a critical care unit during an episode of care, total hours of these stays should be mitted.\n","Number"]
[null,"Theatre Time in minutes","The total time in minutes in theatre from the patient being anaesthetised to the patient entering the recovery room. For example three and a half hours should be entered as 210.","Number"]
[null,"Endoscopy Time in minutes","The total time the patient is in the special procedure suite from the patient being anaesthetised to the patient entering the recovery room. For example three and a half hours should be entered as 210.","Number"]
[null,"Specialist service code","An indication of whether the spell is considered a specialist service under the local payment grouper. The code used in this field should follow the guidance set out in the Specialised Services National Definitions Set. For example: the specialised service code (SSC) flag for neurosciences is 8 and for orthopaedics is 34.\n","Number"]
[null,"Fixed Costs","Providers should separately identify and report the fixed costs of a FCE in this data field. Fixed costs refer to those costs which do not change as activity changes over a 12-month period (eg annual contract cost for cleaning services).","Number"]
[null,"Semi-fixed Costs","Providers should separately identify and report the semi-fixed costs of a FCE in this data field. Semi-fixed costs refer to those costs which do not move with activity changes on a small scale, but ‘jump’ or ‘step up’ when a certain threshold is reached.","Number"]
[null,"Variable Costs","Providers should separately identify and report the variables costs of a FCE in this data field. Variable costs refer to those costs which are directly affected by the number of patients treated or seen. They are an incremental or marginal costs (eg. Drug costs).\n","Number"]
[null,"Education and training costs\n(non-patient care activity costs)","Costs from education and training non patient care activities.\n","Number"]
[null,"Research and development costs\n(non-patient care activity costs)","Costs from research and development non patient care activities.","Number"]
[null,"Other costs including commercial\n(non-patient care activity costs)","Costs from commercial and other non patient care activities that don't relate to education and training or research and development.\n","Number"]
[null,"Other Income","Other income includes income from private or overseas patients, service provision to other providers, provision of goods and services to non-nhs entities, research and development income and education and training income.","Number"]
[null,"Total Cost","The unit costs should be reported on a full absorption basis, which should equal the sum of the costs reported under the different cost pool groups and cost pools. Non patient care activity costs and other income should be excluded from the episode cost.\n","Number"]
[null,"Blood and Blood Products","The blood cost pool contains blood products used and in stock across all service areas. \n","Number"]
[null,"CNST","The CNST cost pool contains the costs associated with Clinical Negligence Scheme for Trusts which handles all clinical negligence claims. \n","Number"]
[null,"Critical care","The critical care cost pool group covers: Adult intensive care (ITU), Adult high-dependency care (HDU), Paediatric intensive care (PICU), Neo-natal intensive care (NICU) and PACE teams.\n","Number"]
[null,"High Cost Drugs","The high cost drugs  cost pool covers costs associated with high cost drugs that are generally excluded from the PbR tariff. These high cost drugs are identified by the procedure codes used by the clinical coding team.\n","Number"]
[null,"Chemotherapy Drugs ","The drugs  cost pool covers the cost of chemotherapy drugs. Chemotherapy drugs are identified by procedure codes used by the clincial coding team.\n","Number"]
[null,"All Other Drugs","The drugs  cost pool covers the cost of all other drugs. This includes all drugs, stock drugs, drugs dispensed directly to patients.  Please note the cost of home delivery drugs should not be reported in this cost pool but reported in the Reconciliation worksheet.\n","Number"]
[null,"Emergency Department","The emergency cost pool group covers the costs associated with running the emergency department, including minor injury units and walk in centres. Please note for the admitted patient care collection we would not expect to see any costs in this cost pool. Please report any costs related to emergency department costs consumed in delivering admitted patient care in the 'Wards' cost pool.\n\n","Number"]
[null,"Imaging - Medical Staffing","The medical staffing cost for radiology which includes: X-Ray, Mammography, Fluoroscopy, CT, MRI, Nuclear medicine, PET, Ultrasound whether diagnostic or interventional.\n","Number"]
[null,"Imaging - All Other Costs","The imaging cost pool group covers area of radiology which includes: X-Ray, Mammography, Fluoroscopy, CT, MRI, Nuclear medicine, PET, Ultrasound whether diagnostic or interventional excluding medical staffing costs.\n","Number"]
[null,"Medical Staffing (excluding Imaging, Pathology & Other Diagnostics)","The medical staffing cost pool group consists of medical staffing salaries associated with the treatment of patients. It covers the costs of consultants, anaesthetists, registrars and junior doctors. However, medical staff working in radiology, other diagnostics tests and pathology departments should be excluded from this cost pool.\n","Number"]
[null,"Operating Theatres","The operating theatres cost pool group covers the area of a hospital where significant surgical procedures are carried out under surgical conditions under the supervision of qualified surgeons. The operating theatre must be equipped to deliver general anaesthesia.\n","Number"]
[null,"Other Clinical Supplies and Services","The other clinical supply and services cost pool group contains costs of clinical supply and services that are not covered by other cost pool groups such as Audiology and Clinical Photography.\n","Number"]
[null,"Other Diagnostics Tests -  Medical Staffing","The medical staffing costs for other diagnostic tests cost pool group which covers all other diagnostic tests, with the exception of imaging and pathology. Such tests may include: Echocardiogram, Stress tests, EEG, ECG, Neurophysiology, Lung function tests.\n","Number"]
[null,"Other Diagnostics Tests- All Other Costs","The other diagnostic tests cost pool group covers all other diagnostic tests, with the exception of imaging and pathology. Such tests may include: Echocardiogram, Stress tests, EEG, ECG, Neurophysiology, Lung function tests excluding medical staffing costs.\n","Number"]
[null,"Outpatients","The outpatients cost pool group covers the costs associated with running outpatient clinics:  Please note for the admitted patient care collection we would not expect to see any costs in this cost pool. Please report any costs related to outpatient costs consumed in delivering admitted patient care in the 'Wards' cost pool.\n","Number"]
[null,"Pathology- Medical Staffing","The medical staffing costs for  pathology includes costs of diagnostic clinical laboratory testing for the diagnosis and treatment of patients  includng Histopathology, Clinical Chemistry, Microbiology, Haematology and Biochemical Sciences and Genetics.\n","Number"]
[null,"Pathology- All Other Costs","The pathology cost pool group includes costs of diagnostic clinical laboratory testing for the diagnosis and treatment of patients includng Histopathology, Clinical Chemistry, Microbiology, Haematology and Biochemical Sciences and Genetics excluding medical staffing.\n","Number"]
[null,"Pharmacy Services","The pharmacy services cost pool group covers the area of the provision of drugs. This includes the production, distribution, supply and storage of drugs and clinical pharmacy services.\n","Number"]
[null,"Prostheses/Implants/Devices","The prostheses cost pool group includes the costs of all prosthetics, implants and medical devices. A prosthesis is defined not only as an artificial part of the body but also any item –  e.g. surgical screws, wires – attached to or implanted into the body with the purpose of remaining permanently or until removed during another procedure.\n","Number"]
[null,"Radiotherapy","The Radiotherapy cost pool group covers the costs associated with radiotherapy services.\n","Number"]
[null,"Secondary Commissioning Costs","The secondary commissioning cost pool group contains costs related to secondary commissioning of activity undertaken by, for example, an independent treatment centre.\n","Number"]
[null,"Specialist Procedure Suites excluding Endoscopy suites","The special procedure suites  cost pool covers costs for suites specifically equipped to enable diagnostic and therapeutic procedures to be performed under the direction of qualified medical practitioners. It would also include costs for special treatment rooms such as plaster rooms or hyperbaric chambers. Costs for Catheterisation Laboratory and Renal Dialysis Unit should also be included here.  Excluding endoscopy suites costs.\n","Number"]
[null,"Specialist Procedure Suite-  Endoscopy Units Only","This is a cost pool established specifically for the PLICS cost collection. This cost pool covers all Endoscopy ssuites\n","Number"]
[null,"Specialist Nursing Staff","The other specialist nurse cost pool group consists of nursing staff that cannot be included in other specific cost pool groups including specialist and consultant nurses.\n","Number"]
[null,"Therapies","The therapies cost pool group includes clinical services delivered by qualified therapy professionals who have direct patient contact including physiotherapy, occupational therapy and speech and language therapy.\n","Number"]
[null,"Wards","The ward cost pool group includes nursing staff salaries, as well as costs of medical and surgical supplies and other goods and services used and delivered on wards. \n","Number"]
[null,"Overheads","Overheads include costs of support services such as Board, HR, Finance, information management and information technology, and other costs that are not directly related to patient care. Overheads are technically not a cost pool group, but for this collection, we request participating organisations to report the costs separately.\n","Number"]
[null,"Impairments","Impairments are an accounting adjustment resulting from the change in a fixed asset or the economic environment in which it is used, and is not directly related to patient care. \nTechnically, impairments costs are overheads that should be captured in the overhead column. However, for this collection we ask organisations to identify and report impairments separately.\n","Number"]
[null,"Non NHS patient flag","Providers that choose to include costs of non NHS patients as part of this mission should complete this data field to provide an indication if a patient is a  NHS or non NHS patient: “0” indicates an NHS patient and “1” indicates a non NHS patient. By non NHS patients, we mean private patients, reciprocal patients, overseas patients and patients being referred from other parts of the UK (e.g. Wales, Scotland).\n","Boolean (1 or 0)"]
[null,"WIP Partial Episode Flag","‘0’ is not a WIP partial episode\n‘1’ is a WIP partial episode (for organisations reporting WIP level 3 only)\n\nOrganisations reporting at WIP level 3 only should selectively use this flag to indicate a partial episode that is either the in-year portion of an episode in progress at the start of the financial year or the in-year portion of an episode in progress at the end of the financial year, and therefore probably does not represent a ‘full’ episode cost. Organisations reporting at WIP level 1 or 2 should enter 0 for all episodes (having no WIP partial episodes).","Boolean (1 or 0)"]
[null,"Contracted Out/In Flag","Please use this field to indicate whether the episode has an element of care contracted out or in (ie patient care has been provided for or provided to another provider).\n0- Entire episode of care provided solely by the trust making PLICS submission\n1- Contracted out episode: all or some of this episode of care was provided by another provider to the patient belonging to the provider making the PLICS submission\n2- Contracted in episode: all or some of this episode of care was provided for a patient of another provider by the provider making the PLICS submission\n","Number {0,1,2}"]
[null,"Contracted Full or Part Cost","This column should be used to designate whether an FCE line (of those designated 1 or 2 in the previous field) contains a full episode cost or whether (as a consequence of provider to provider contracting interactions) it contains partial costs only (and therefore should be excluded from benchmarking efforts.\nF - Full Episode Cost\nP- Part Episode Cost\n","P or F"]

{"sheet":"Admin","index":8,"n_rows":245,"n_cols":241,"rows_kept":245,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"POD Code",null,"Org.Code","Organisation Name",null,null,"File","TI_Org_Code","TI_Org_Name","TI_Pri_Con_Name","TI_Pri_Con_Email","TI_Pri_Con_Tel","TI_Alt_Con_Name","TI_Alt_Con_Email","TI_Alt_Con_Tel","TI_Fin_Year","TI_PLICS_Supplier","Sum_TCvFVe","Sum_TCvCPe","Sum_KSS_TC_pos","Sum_KSS_Cnt_pos","Sum_KSS_Cnt_low","Sum_KSS_Cnt_all","Sum_KSS_AC_pos","Sum_Fve_Fixed","Sum_Fve_SemiFix","Sum_Fve_Variable","Sum_Fve_All","Sum_CPG1_BBP","Sum_CPG2_CNST","Sum_CPG3_CC","Sum_CPG4_DrugsHC","Sum_CPG5_DrugsChemo","Sum_CPG6_DrugsOther","Sum_CPG7_ED","Sum_CPG8_ImgStaff","Sum_CPG9_ImgOther","Sum_CPG10_MedStaffexc","Sum_CPG11_OpT","Sum_CPG12_SnS","Sum_CPG13_OtherDxStaff","Sum_CPG14_OtherDxOther","Sum_CPG15_Outpatients","Sum_CPG16_PathStaff","Sum_CPG17_PathOther","Sum_CPG18_Pharmacy","Sum_CPG19_PID","Sum_CPG20_Radio","Sum_CPG21_SCC","Sum_CPG22_SPSexcE","Sum_CPG23_SPS_E","Sum_CPG24_SNStaff","Sum_CPG25_Therapies","Sum_CPG26_Wards","Sum_CPG27_Overheads","Sum_CPG_TC","Rec_1_1A_1_V","Rec_1_1A_2_V","Rec_1_1A_3_V","Rec_1_1A_4_V","Rec_1_1A_5_V","Rec_1_1A_6_V","Rec_1_1A_7_V","Rec_1_1A_8a_V","Rec_1_1A_8b_V","Rec_1_1A_8c_V","Rec_1_1A_9_V","Rec_1_1B_10a_V","Rec_1_1B_10b_V","Rec_1_1B_10c_V","Rec_1_1B_10d_V","Rec_1_1B_10e_V","Rec_1_1B_10f_V","Rec_1_1B_10g_V","Rec_1_1B_10h_V","Rec_1_1B_10i_V","Rec_1_1B_10j_V","Rec_1_1B_10k_V","Rec_1_1B_10l_V","Rec_1_1B_10m_V","Rec_1_1B_11_V","Rec_1_1B_10f_D","Rec_1_1B_10g_D","Rec_1_1B_10h_D","Rec_1_1B_10i_D","Rec_1_1B_10j_D","Rec_1_1B_10k_D","Rec_1_1B_10l_D","Rec_1_1B_10m_D","Rec_1_2_1_V","Rec_1_2_2_V","Rec_1_2_3_V","Rec_1_2_4_V","Rec_1_2_5_V","Rec_1_2_6_V","Rec_1_2_Var1_V","Rec_1_2_Var2_V","Rec_1_2_Var3_V","Rec_1_2_Var4_V","Rec_1_2_Var5_V","Rec_1_2_Var6_V","Rec_1_2_Var7_V","Rec_1_2_Var8_V","Rec_1_2_Var9_V","Rec_1_2_Var10_V","Rec_1_2_Var11_V","Rec_1_2_Var12_V","Rec_1_2_Var13_V","Rec_1_2_Var14_V","Rec_1_2_Var15_V","Rec_1_2_Var16_V","Rec_1_2_Var17_V","Rec_1_2_Var18_V","Rec_1_2_Var19_V","Rec_1_2_Var20_V","Rec_1_2_Var21_V","Rec_1_2_Var22_V","Rec_1_2_Var23_V","Rec_1_2_Var24_V","Rec_1_2_Var25_V","Rec_1_2_Var1_C","Rec_1_2_Var2_C","Rec_1_2_Var3_C","Rec_1_2_Var4_C","Rec_1_2_Var5_C","Rec_1_2_Var6_C","Rec_1_2_Var7_C","Rec_1_2_Var8_C","Rec_1_2_Var9_C","Rec_1_2_Var10_C","Rec_1_2_Var11_C","Rec_1_2_Var12_C","Rec_1_2_Var13_C","Rec_1_2_Var14_C","Rec_1_2_Var15_C","Rec_1_2_Var16_C","Rec_1_2_Var17_C","Rec_1_2_Var18_C","Rec_1_2_Var19_C","Rec_1_2_Var20_C","Rec_1_2_Var21_C","Rec_1_2_Var22_C","Rec_1_2_Var23_C","Rec_1_2_Var24_C","Rec_1_2_Var25_C","Rec_1_2_Var1_D","Rec_1_2_Var2_D","Rec_1_2_Var3_D","Rec_1_2_Var4_D","Rec_1_2_Var5_D","Rec_1_2_Var6_D","Rec_1_2_Var7_D","Rec_1_2_Var8_D","Rec_1_2_Var9_D","Rec_1_2_Var10_D","Rec_1_2_Var11_D","Rec_1_2_Var12_D","Rec_1_2_Var13_D","Rec_1_2_Var14_D","Rec_1_2_Var15_D","Rec_1_2_Var16_D","Rec_1_2_Var17_D","Rec_1_2_Var18_D","Rec_1_2_Var19_D","Rec_1_2_Var20_D","Rec_1_2_Var21_D","Rec_1_2_Var22_D","Rec_1_2_Var23_D","Rec_1_2_Var24_D","Rec_1_2_Var25_D","Rec_2_Act_CoE1","Rec_2_Act_CoE2","Rec_2_Act_CoE3","Rec_2_Act_CoE4","Rec_2_Act_CoE5","Rec_2_Act_EIS1","Rec_2_Act_EIS2","Rec_2_Act_EIS3","Rec_2_Act_EIS4","Rec_2_Act_EIS5","Rec_2_Act_pyFCE1","Rec_2_Act_pyFCE2","Rec_2_Act_pyFCE3","Rec_2_Act_pyFCE4","Rec_2_Act_pyFCE5","Rec_2_Act_SUS1","Rec_2_Act_SUS2","Rec_2_Act_SUS3","Rec_2_Act_SUS4","Rec_2_Act_SUS5","Rec_2_Act_Var1","Rec_2_Act_Var2","Rec_2_Act_Var3","Rec_2_Act_Var4","Rec_2_Act_Var5","Rec_2_Act_VarComment1","Rec_2_Act_VarComment2","Rec_2_Act_VarComment3","Rec_2_Act_VarComment4","Rec_3_OH_1a","Rec_3_OH_1b","Rec_3_OH_1c","Rec_3_OH_1d","Rec_3_OH_1e","Rec_3_OH_2a","Rec_3_OH_2b","Rec_3_OH_2c","Rec_3_OH_2d","Rec_3_OH_2e","Rec_3_OH_2f","Rec_3_OH_2g","Rec_3_OH_2h","Rec_3_OH_2i","Rec_3_OH_2j","Rec_3_OH_2k","Rec_3_OH_2l","Rec_3_OH_2m","Rec_3_OH_2n","Rec_3_OH_2o","Rec_3_OH_2p","Rec_3_OH_2q","Rec_3_OH_2r","Rec_3_OH_2s","Rec_3_OH_2t","Rec_3_OH_3","SO_1done","SO_2done","SO_3done","SO_4done","SO_MAQSdone","SO_DOFSign","SO_DOFName","SO_HFMAnullyesno","SO_NoComments","SO_WIP","SO_Verdict"]
[null,null,null,null,null,"EL",null,"R1A","Worcestershire Health and Care NHS Trust",null,null,{"$f":"CELL(\"filename\")","v":"W:\\PLICS\\Template work\\Received from AR (finals)\\[PLICS_Collection_Template_201516_rv7.xlsm]FrontScreen"},{"$f":"fp_org_code","v":0},{"$f":"fp_org_name","v":""},{"$f":"fp_prim_contact_name","v":0},{"$f":"fp_prim_contact_email","v":0},{"$f":"fp_prim_contact_phone","v":0},{"$f":"fp_alt_contact_name","v":0},{"$f":"fp_alt_contact_email","v":0},{"$f":"fp_alt_contact_phone","v":0},{"$f":"fp_finyear","v":"2015/16"},{"$f":"fp_PLICS_supplier","v":0},{"$f":"'4. Summary'!E11","v":"Pass"},{"$f":"'4. Summary'!E12","v":"Pass"},{"$f":"summary_total_cost_sum","v":0},{"$f":"summary_total_FCEs","v":0},{"$f":"'4. Summary'!C17","v":0},{"$f":"'4. Summary'!C18","v":0},{"$f":"summary_avg_cost_fce","v":""},{"$f":"'4. Summary'!C23","v":0},{"$f":"'4. Summary'!C24","v":0},{"$f":"'4. Summary'!C25","v":0},{"$f":"'4. Summary'!C26","v":0},{"$f":"'4. Summary'!C30","v":0},{"$f":"'4. Summary'!C31","v":0},{"$f":"'4. Summary'!C32","v":0},{"$f":"'4. Summary'!C33","v":0},{"$f":"'4. Summary'!C34","v":0},{"$f":"'4. Summary'!C35","v":0},{"$f":"'4. Summary'!C36","v":0},{"$f":"'4. Summary'!C37","v":0},{"$f":"'4. Summary'!C38","v":0},{"$f":"'4. Summary'!C39","v":0},{"$f":"'4. Summary'!C40","v":0},{"$f":"'4. Summary'!C41","v":0},{"$f":"'4. Summary'!C42","v":0},{"$f":"'4. Summary'!C43","v":0},{"$f":"'4. Summary'!C44","v":0},{"$f":"'4. Summary'!C45","v":0},{"$f":"'4. Summary'!C46","v":0},{"$f":"'4. Summary'!C47","v":0},{"$f":"'4. Summary'!C48","v":0},{"$f":"'4. Summary'!C49","v":0},{"$f":"'4. Summary'!C50","v":0},{"$f":"'4. Summary'!C51","v":0},{"$f":"'4. Summary'!C52","v":0},{"$f":"'4. Summary'!C53","v":0},{"$f":"'4. Summary'!C54","v":0},{"$f":"'4. Summary'!C55","v":0},{"$f":"'4. Summary'!C56","v":0},{"$f":"'4. Summary'!C58","v":0},{"$f":"'2. Reconciliation'!H18","v":0},{"$f":"'2. Reconciliation'!H19","v":0},{"$f":"'2. Reconciliation'!H20","v":0},{"$f":"'2. Reconciliation'!H21","v":0},{"$f":"'2. Reconciliation'!H22","v":0},{"$f":"'2. Reconciliation'!H23","v":0},{"$f":"'2. Reconciliation'!H24","v":0},{"$f":"'2. Reconciliation'!H27","v":0},{"$f":"'2. Reconciliation'!H28","v":0},{"$f":"'2. Reconciliation'!H29","v":0},{"$f":"'2. Reconciliation'!H30","v":0},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!H34","v":"(by NonEnglishNHS and NonNHS: private patients, overseas (non-reciprocal), armed forces,"},{"$f":"'2. Reconciliation'!H35","v":0},{"$f":"'2. Reconciliation'!H36","v":0},{"$f":"'2. Reconciliation'!H60","v":0},{"$f":"'2. Reconciliation'!H61","v":0},{"$f":"'2. Reconciliation'!H62","v":0},{"$f":"'2. Reconciliation'!H63","v":0},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!H64","v":0},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2. Reconciliation'!#REF!","v":{"$error":"#REF!"}},{"$f":"TRANSPOSE('2. Reconciliation'!H68:H92)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"TRANSPOSE('2. Reconciliation'!F68:G92)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"TRANSPOSE('2. Reconciliation'!C68:C92)","v":"[Insert description of variance factor]"},"[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]","[Insert description of variance factor]",{"$f":"'2. Reconciliation'!D112","v":0},{"$f":"'2. Reconciliation'!D113","v":0},{"$f":"'2. Reconciliation'!D114","v":0},{"$f":"'2. Reconciliation'!D115","v":0},{"$f":"'2. Reconciliation'!D117","v":0},{"$f":"'2. Reconciliation'!E112","v":0},{"$f":"'2. Reconciliation'!E113","v":0},{"$f":"'2. Reconciliation'!E114","v":0},{"$f":"'2. Reconciliation'!E115","v":0},{"$f":"'2. Reconciliation'!E117","v":0},{"$f":"'2. Reconciliation'!F112","v":0},{"$f":"'2. Reconciliation'!F113","v":0},{"$f":"'2. Reconciliation'!F114","v":0},{"$f":"'2. Reconciliation'!F115","v":0},{"$f":"'2. Reconciliation'!F117","v":0},{"$f":"'2. Reconciliation'!H112","v":0},{"$f":"'2. Reconciliation'!H113","v":0},{"$f":"'2. Reconciliation'!H114","v":0},{"$f":"'2. Reconciliation'!H115","v":0},{"$f":"'2. Reconciliation'!G117","v":0},{"$f":"'2. Reconciliation'!I112","v":0},{"$f":"'2. Reconciliation'!I113","v":0},{"$f":"'2. Reconciliation'!I114","v":0},{"$f":"'2. Reconciliation'!I115","v":0},{"$f":"'2. Reconciliation'!H117","v":0},{"$f":"'2. Reconciliation'!J112","v":0},{"$f":"'2. Reconciliation'!J113","v":0},{"$f":"'2. Reconciliation'!J114","v":0},{"$f":"'2. Reconciliation'!J115","v":0},{"$f":"'2. Reconciliation'!D125","v":0},{"$f":"'2. Reconciliation'!D126","v":0},{"$f":"'2. Reconciliation'!D127","v":0},{"$f":"'2. Reconciliation'!D128","v":0},{"$f":"'2. Reconciliation'!D129","v":0},{"$f":"'2. Reconciliation'!D132","v":0},{"$f":"'2. Reconciliation'!D133","v":0},{"$f":"'2. Reconciliation'!D134","v":0},{"$f":"'2. Reconciliation'!D135","v":0},{"$f":"'2. Reconciliation'!D136","v":0},{"$f":"'2. Reconciliation'!D137","v":0},{"$f":"'2. Reconciliation'!D138","v":0},{"$f":"'2. Reconciliation'!D139","v":0},{"$f":"'2. Reconciliation'!D140","v":0},{"$f":"'2. Reconciliation'!D141","v":0},{"$f":"'2. Reconciliation'!D142","v":0},{"$f":"'2. Reconciliation'!D143","v":0},{"$f":"'2. Reconciliation'!D144","v":0},{"$f":"'2. Reconciliation'!D145","v":0},{"$f":"'2. Reconciliation'!D146","v":0},{"$f":"'2. Reconciliation'!D147","v":0},{"$f":"'2. Reconciliation'!D148","v":0},{"$f":"'2. Reconciliation'!D149","v":0},{"$f":"'2. Reconciliation'!D150","v":0},{"$f":"'2. Reconciliation'!D151","v":0},{"$f":"'2. Reconciliation'!D153","v":0},{"$f":"'5. Sign-off'!W14","v":0},{"$f":"'5. Sign-off'!W16","v":0},{"$f":"'5. Sign-off'!W17","v":0},{"$f":"'5. Sign-off'!W18","v":0},{"$f":"'5. Sign-off'!W19","v":0},{"$f":"'5. Sign-off'!V20*1","v":0},{"$f":"'5. Sign-off'!N20","v":0},{"$f":"'5. Sign-off'!V22","v":0},{"$f":"'5. Sign-off'!B24","v":0},{"$f":"'5. Sign-off'!V29","v":0},{"$f":"'5. Sign-off'!B10","v":"Template not ready for submission. Please complete the above steps."}]
[null,null,null,null,null,"NE",null,"R1C","Solent NHS Trust"]
[null,null,null,null,null,"DC",null,"R1D","Shropshire Community Health NHS Trust"]
[null,null,null,null,null,"RP",null,"R1E","Staffordshire and Stoke On Trent Partnership NHS Trust"]
[null,null,null,null,null,null,null,"R1F","Isle of Wight NHS Trust"]
[null,null,null,null,null,null,null,"R1G","Torbay and Southern Devon Health and Care NHS Trust"]
[null,null,null,null,null,null,null,"R1H","Barts Health NHS Trust"]
[null,null,null,null,null,null,null,"RA2","Royal Surrey County Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RA3","Weston Area Health NHS Trust"]
[null,null,null,null,null,null,null,"RA4","Yeovil District Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RA7","University Hospitals Bristol NHS Foundation Trust"]
[null,"sysHeadline","PLICS Data Collection Template 2015-16",null,null,null,null,"RA9","South Devon Healthcare NHS Foundation Trust"]
[null,"SysYear",201516,null,null,null,null,"RAE","Bradford Teaching Hospitals NHS Foundation Trust"]
[null,"SysType","PLA",null,null,null,null,"RAJ","Southend University Hospital NHS Foundation Trust"]
[null,"SysVersion",1,null,null,null,null,"RAL","Royal Free London NHS Foundation Trust"]
[null,"SysNACSCode",null,null,null,null,null,"RAN","Royal National Orthopaedic Hospital NHS Trust"]
[null,"sysSavedDate",null,null,null,null,null,"RAP","North Middlesex University Hospital NHS Trust"]
[null,"sysSavedByUser",null,null,null,null,null,"RAS","The Hillingdon Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RAT","North East London NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RAX","Kingston Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBA","Taunton and Somerset NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBB","Royal National Hospital For Rheumatic Diseases NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBD","Dorset County Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBK","Walsall Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RBL","Wirral University Teaching Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBN","St Helens and Knowsley Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RBQ","Liverpool Heart and Chest NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBS","Alder Hey Childrens NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBT","Mid Cheshire Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBV","The Christie NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RBZ","Northern Devon Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RC1","Bedford Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RC3","Ealing Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RC9","Luton and Dunstable Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RCB","York Teaching Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RCD","Harrogate and District NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RCF","Airedale NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RCU","Sheffield Childrens NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RCX","The Queen Elizabeth Hospital Kings Lynn NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RD1","Royal United Hospitals Bath NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RD3","Poole Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RD7","Heatherwood and Wexham Park Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RD8","Milton Keynes Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RDD","Basildon and Thurrock University Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RDE","Colchester Hospital University NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RDR","Sussex Community NHS Trust"]
[null,null,null,null,null,null,null,"RDU","Frimley Park Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RDY","Dorset Healthcare University NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RDZ","The Royal Bournemouth and Christchurch Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RE9","South Tyneside NHS Foundation Trust"]
[null,null,null,null,null,null,null,"REF","Royal Cornwall Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"REM","Aintree University Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"REN","The Clatterbridge Cancer Centre NHS Foundation Trust"]
[null,null,null,null,null,null,null,"REP","Liverpool Womens NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RET","The Walton Centre NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RF4","Barking Havering and Redbridge University Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RFF","Barnsley Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RFR","The Rotherham NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RFS","Chesterfield Royal Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RFW","West Middlesex University Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RGD","Leeds and York Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RGM","Papworth Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RGN","Peterborough and Stamford Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RGP","James Paget University Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RGQ","Ipswich Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RGR","West Suffolk NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RGT","Cambridge University Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RH5","Somerset Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RH8","Royal Devon and Exeter NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RHA","Nottinghamshire Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RHM","University Hospital Southampton NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RHQ","Sheffield Teaching Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RHU","Portsmouth Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RHW","Royal Berkshire NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJ1","Guy's and St Thomas NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJ2","Lewisham And Greenwich NHS Trust"]
[null,null,null,null,null,null,null,"RJ6","Croydon Health Services NHS Trust"]
[null,null,null,null,null,null,null,"RJ7","St Georges University Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJ8","Cornwall Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJC","South Warwickshire NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJD","Mid Staffordshire NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJE","University Hospitals of North Midlands NHS Trust"]
[null,null,null,null,null,null,null,"RJF","Burton Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJL","Northern Lincolnshire and Goole Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJN","East Cheshire NHS Trust"]
[null,null,null,null,null,null,null,"RJR","Countess of Chester Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RJZ","Kings College Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RK5","Sherwood Forest Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RK9","Plymouth Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RKB","University Hospitals Coventry and Warwickshire NHS Trust"]
[null,null,null,null,null,null,null,"RKE","The Whittington Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RKL","West London Mental Health NHS Trust"]
[null,null,null,null,null,null,null,"RL1","The Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RL4","The Royal Wolverhampton NHS Trust"]
[null,null,null,null,null,null,null,"RLN","City Hospitals Sunderland NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RLQ","Wye Valley NHS Trust"]
[null,null,null,null,null,null,null,"RLT","George Eliot Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RLU","Birmingham Womens NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RLY","North Staffordshire Combined Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RM1","Norfolk and Norwich University Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RM2","University Hospital of South Manchester NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RM3","Salford Royal NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RMC","Bolton NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RMP","Tameside Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RMY","Norfolk and Suffolk NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RN3","Great Western Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RN5","Hampshire Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RN7","Dartford and Gravesham NHS Trust"]
[null,null,null,null,null,null,null,"RNA","The Dudley Group NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RNK","Tavistock and Portman NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RNL","North Cumbria University Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RNN","Cumbria Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RNQ","Kettering General Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RNS","Northampton General Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RNU","Oxford Health NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RNZ","Salisbury NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RP1","Northamptonshire Healthcare NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RP4","Great Ormond Street Hospital For Children NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RP5","Doncaster and Bassetlaw Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RP6","Moorfields Eye Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RP7","Lincolnshire Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RPA","Medway NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RPC","Queen Victoria Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RPG","Oxleas NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RPY","The Royal Marsden NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RQ3","Birmingham Childrens Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RQ6","Royal Liverpool and Broadgreen University Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RQ8","Mid Essex Hospital Services NHS Trust"]
[null,null,null,null,null,null,null,"RQM","Chelsea and Westminster Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RQQ","Hinchingbrooke Health Care NHS Trust"]
[null,null,null,null,null,null,null,"RQW","The Princess Alexandra Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RQX","Homerton University Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RQY","South West London and St Georges Mental Health NHS Trust"]
[null,null,null,null,null,null,null,"RR1","Heart of England NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RR7","Gateshead Health NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RR8","Leeds Teaching Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RRD","North Essex Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RRE","South Staffordshire and Shropshire Healthcare NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RRF","Wrightington Wigan and Leigh NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RRJ","The Royal Orthopaedic Hospital NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RRK","University Hospitals Birmingham NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RRP","Barnet Enfield and Haringey Mental Health NHS Trust"]
[null,null,null,null,null,null,null,"RRU","London Ambulance Service NHS Trust"]
[null,null,null,null,null,null,null,"RRV","University College London Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RT1","Cambridgeshire and Peterborough NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RT2","Pennine Care NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RT3","Royal Brompton and Harefield NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RT5","Leicestershire Partnership NHS Trust"]
[null,null,null,null,null,null,null,"RTD","The Newcastle Upon Tyne Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RTE","Gloucestershire Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RTF","Northumbria Healthcare NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RTG","Derby Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RTH","Oxford University Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RTK","Ashford and St Peters Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RTP","Surrey and Sussex Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RTQ","2gether NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RTR","South Tees Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RTV","5 Boroughs Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RTX","University Hospitals of Morecambe Bay NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RV3","Central and North West London NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RV5","South London and Maudsley NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RV8","North West London Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RV9","Humber NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RVJ","North Bristol NHS Trust"]
[null,null,null,null,null,null,null,"RVL","Barnet and Chase Farm Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RVN","Avon and Wiltshire Mental Health Partnership NHS Trust"]
[null,null,null,null,null,null,null,"RVR","Epsom and St Helier University Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RVV","East Kent Hospitals University NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RVW","North Tees and Hartlepool NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RVY","Southport and Ormskirk Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RW1","Southern Health NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RW3","Central Manchester University Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RW4","Mersey Care NHS Trust"]
[null,null,null,null,null,null,null,"RW5","Lancashire Care NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RW6","Pennine Acute Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RWA","Hull and East Yorkshire Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RWD","United Lincolnshire Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RWE","University Hospitals of Leicester NHS Trust"]
[null,null,null,null,null,null,null,"RWF","Maidstone and Tunbridge Wells NHS Trust"]
[null,null,null,null,null,null,null,"RWG","West Hertfordshire Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RWH","East and North Hertfordshire NHS Trust"]
[null,null,null,null,null,null,null,"RWJ","Stockport NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RWK","East London NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RWN","South Essex Partnership University NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RWP","Worcestershire Acute Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RWR","Hertfordshire Partnership University NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RWV","Devon Partnership NHS Trust"]
[null,null,null,null,null,null,null,"RWW","Warrington and Halton Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RWX","Berkshire Healthcare NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RWY","Calderdale and Huddersfield NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RX1","Nottingham University Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RX2","Sussex Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RX3","Tees Esk and Wear Valleys NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RX4","Northumberland Tyne and Wear NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RX6","North East Ambulance Service NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RX7","North West Ambulance Service NHS Trust"]
[null,null,null,null,null,null,null,"RX8","Yorkshire Ambulance Service NHS Trust"]
[null,null,null,null,null,null,null,"RX9","East Midlands Ambulance Service NHS Trust"]
[null,null,null,null,null,null,null,"RXA","Cheshire and Wirral Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXC","East Sussex Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RXE","Rotherham Doncaster and South Humber NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXF","Mid Yorkshire Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RXG","South West Yorkshire Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXH","Brighton and Sussex University Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RXK","Sandwell and West Birmingham Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RXL","Blackpool Teaching Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXM","Derbyshire Healthcare NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXN","Lancashire Teaching Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXP","County Durham and Darlington NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXQ","Buckinghamshire Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RXR","East Lancashire Hospitals NHS Trust"]
[null,null,null,null,null,null,null,"RXT","Birmingham and Solihull Mental Health NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXV","Greater Manchester West Mental Health NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXW","Shrewsbury and Telford Hospital NHS Trust"]
[null,null,null,null,null,null,null,"RXX","Surrey and Borders Partnership NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RXY","Kent and Medway NHS and Social Care Partnership Trust"]
[null,null,null,null,null,null,null,"RY1","Liverpool Community Health NHS Trust"]
[null,null,null,null,null,null,null,"RY2","Bridgewater Community Healthcare NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RY3","Norfolk Community Health and Care NHS Trust"]
[null,null,null,null,null,null,null,"RY4","Hertfordshire Community NHS Trust"]
[null,null,null,null,null,null,null,"RY5","Lincolnshire Community Health Services NHS Trust"]
[null,null,null,null,null,null,null,"RY6","Leeds Community Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RY7","Wirral Community NHS Trust"]
[null,null,null,null,null,null,null,"RY8","Derbyshire Community Health Services NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RY9","Hounslow and Richmond Community Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RYA","West Midlands Ambulance Service NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RYC","East of England Ambulance Service NHS Trust"]
[null,null,null,null,null,null,null,"RYD","South East Coast Ambulance Service NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RYE","South Central Ambulance Service NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RYF","South Western Ambulance Service NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RYG","Coventry and Warwickshire Partnership NHS Trust"]
[null,null,null,null,null,null,null,"RYJ","Imperial College Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RYK","Dudley and Walsall Mental Health Partnership NHS Trust"]
[null,null,null,null,null,null,null,"RYQ","South London Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RYR","Western Sussex Hospitals NHS Foundation Trust"]
[null,null,null,null,null,null,null,"RYV","Cambridgeshire Community Services NHS Trust"]
[null,null,null,null,null,null,null,"RYW","Birmingham Community Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RYX","Central London Community Healthcare NHS Trust"]
[null,null,null,null,null,null,null,"RYY","Kent Community Health NHS Trust"]
[null,null,null,null,null,null,null,"TAD","Bradford District Care Trust"]
[null,null,null,null,null,null,null,"TAE","Manchester Mental Health and Social Care Trust"]
[null,null,null,null,null,null,null,"TAF","Camden and Islington NHS Foundation Trust"]
[null,null,null,null,null,null,null,"TAH","Sheffield Health and Social Care NHS Foundation Trust"]
[null,null,null,null,null,null,null,"TAJ","Black Country Partnership NHS Foundation Trust"]

{"sheet":"2. Reconciliation (old style)","index":9,"n_rows":152,"n_cols":9,"rows_kept":152,"cut":false,"hidden":false,"merged":[[88,5,88,6],[89,5,89,6],[90,5,90,6],[91,5,91,6],[94,1,103,7],[87,5,87,6],[76,5,76,6],[77,5,77,6],[78,5,78,6],[79,5,79,6],[80,5,80,6],[81,5,81,6],[82,5,82,6],[83,5,83,6],[84,5,84,6],[85,5,85,6],[86,5,86,6],[75,5,75,6],[54,3,54,4],[65,3,65,4],[65,5,65,6],[67,5,67,6],[68,5,68,6],[69,5,69,6],[70,5,70,6],[71,5,71,6],[72,5,72,6],[73,5,73,6],[74,5,74,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Section 1 - Cost Reconciliation"]
[]
[null,"Section 1.1: Final Audited Accounts to Admitted Patient Care Quantum"]
[]
[null,"Line","Description",null,null,"Notes: FTs","Notes: NHS Trusts","£"]
[]
[null,"Section 1.1A - Expected PLICS Quantum"]
[null,1,"Operating expenses",null,null,"SOCI","TRU01 sc100 + sc110"]
[null,2,"Add: Finance expenses financial liabilities (FTs) or finance costs (NHS trusts)",null,null,"SOCI","TRU01 sc170"]
[null,3,"Add: PDC dividends payable",null,null,"SOCI","TRU01 sc190"]
[null,4,"Add: Finance expenses - unwinding of discount",null,null,"SOCI"]
[null,5,"Less: Actual cost of non-NHS private patients (if applicable)"]
[null,6,"Less: Actual cost of non-NHS overseas patients (non-reciprocal) (if applicable)"]
[null,7,"Less: Actual cost of other non-NHS patients (if applicable)"]
[null,8,"Less: Other operating income split into:"]
[null,"8a","Education and training income"]
[null,"8b","Research and Development"]
[null,"8c","Other (all remaining other operating income)"]
[null,9,"Total PLICS Quantum (sums lines 1 to 8)",null,null,null,null,{"$f":"SUM(H23:H33)","v":0}]
[]
[null,"Section 1.1B - Removal of Non Admitted Patient Care Costs (net of other operating income)"]
[null,10,"Less Non Admitted Patient Care services:"]
[null,"10a","Total PLICS costs (net of other operating income) for outpatients"]
[null,"10b","Total PLICS costs (net of other operating income) for A&E attendances"]
[null,"10c","Total PLICS costs (net of other operating income) for direct access services"]
[null,"10d","Total PLICS costs (net of other operating income) for healthcare at home services"]
[null,"10e","Total PLICS costs (net of other operating income) for community Services"]
[null,"10f","[insert full details of additional PLICS costs or costs that are not currently costed at patient level]"]
[null,"10g","[insert full details of additional PLICS costs or costs that are not currently costed at patient level]"]
[null,"10h","[insert full details of additional PLICS costs or costs that are not currently costed at patient level]"]
[null,"10i","[insert full details of additional PLICS costs or costs that are not currently costed at patient level]"]
[null,"10j","[insert full details of additional PLICS costs or costs that are not currently costed at patient level]"]
[null,"10k","[insert full details of additional PLICS costs or costs that are not currently costed at patient level]"]
[null,"10l","[insert full details of additional PLICS costs or costs that are not currently costed at patient level]"]
[null,"10m","[insert full details of additional PLICS costs or costs that are not currently costed at patient level]"]
[null,11,"Total PLICS costs net of other operating income for Admitted Patient Care (sum of lines 9-10)",null,null,null,null,{"$f":"SUM(H34:H50)","v":0}]
[]
[null,"Section 1.2: Variances to Data Input"]
[]
[null,"Line","Description",null,null,null,null,"£"]
[]
[null,1,"Section 1.1 Total (line 11)",null,null,null,null,{"$f":"H51","v":0}]
[]
[null,2,"Total from '2.Data Input': Non Patient Care Activity Costs (Column BC)",null,null,null,null,{"$f":"SUM('3. Data Input'!BF:BF)","v":0}]
[null,3,"Total from '2.Data Input': Other Income (Column BD)",null,null,null,null,{"$f":"SUM('3. Data Input'!BG:BG)","v":0}]
[null,4,"Total from '2.Data Input': Total Cost (BE)",null,null,null,null,{"$f":"SUM('3. Data Input'!BH:BH)","v":0}]
[null,5,"Total PLICS costs net of other operating income from '2. Data Input' (sum lines 2-4)",null,null,null,null,{"$f":"SUM(H59:H61)","v":0}]
[null,6,"Variances between Section 1.1 Total (line 1) and '2. Data Input' Total (line 5)",null,null,null,null,{"$f":"H57-H62","v":0}]
[]
[null,"Please explain any variances:"]
[null,"Line","Description",null,null,"Comments",null,"£"]
[]
[null,1,"[Insert description of variance factor]"]
[null,2,"[Insert description of variance factor]"]
[null,3,"[Insert description of variance factor]"]
[null,4,"[Insert description of variance factor]"]
[null,5,"[Insert description of variance factor]"]
[null,6,"[Insert description of variance factor]"]
[null,7,"[Insert description of variance factor]"]
[null,8,"[Insert description of variance factor]"]
[null,9,"[Insert description of variance factor]"]
[null,10,"[Insert description of variance factor]"]
[null,11,"[Insert description of variance factor]"]
[null,12,"[Insert description of variance factor]"]
[null,13,"[Insert description of variance factor]"]
[null,14,"[Insert description of variance factor]"]
[null,15,"[Insert description of variance factor]"]
[null,16,"[Insert description of variance factor]"]
[null,17,"[Insert description of variance factor]"]
[null,18,"[Insert description of variance factor]"]
[null,19,"[Insert description of variance factor]"]
[null,20,"[Insert description of variance factor]"]
[null,21,"[Insert description of variance factor]"]
[null,22,"[Insert description of variance factor]"]
[null,23,"[Insert description of variance factor]"]
[null,24,"[Insert description of variance factor]"]
[null,25,"[Insert description of variance factor]"]
[]
[null,"Additional Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Section 2 - Activity Reconciliation"]
[]
[null,"Line","POD Type","Count of Episodes","Episodes from incomplete spells","FCEs from previous financial years, relating to spells completed in the current year","Activity from SUS","Variance","Possible reasons for variance"]
[]
[null,1,"Elective",{"$f":"COUNTIF('3. Data Input'!S:S,\"EL\")","v":0},{"$f":"COUNTIFS('3. Data Input'!S:S,\"EL\",'3. Data Input'!CL:CL,1)","v":0},null,null,{"$f":"D111-E111+F111-G111","v":0}]
[null,2,"Non Elective",{"$f":"COUNTIF('3. Data Input'!S:S,\"NE\")","v":0},{"$f":"COUNTIFS('3. Data Input'!S:S,\"NE\",'3. Data Input'!CL:CL,1)","v":0},null,null,{"$f":"D112-E112+F112-G112","v":0}]
[null,3,"Day Cases",{"$f":"COUNTIF('3. Data Input'!S:S,\"DC\")","v":0},{"$f":"COUNTIFS('3. Data Input'!S:S,\"DC\",'3. Data Input'!CL:CL,1)","v":0},null,null,0]
[null,4,"Regular Day or Night Admissions",{"$f":"COUNTIF('3. Data Input'!S:S,\"RP\")","v":0},{"$f":"COUNTIFS('3. Data Input'!S:S,\"RP\",'3. Data Input'!CL:CL,1)","v":0},null,null,0]
[]
[null,5,"Total",{"$f":"+SUM(D111:D114)","v":0},{"$f":"+SUM(E111:E114)","v":0},0,0,0]
[]
[]
[null,"Section 3 - Breakdown of Overheads for Admitted Patient Care"]
[]
[null,"Line","Description","£"]
[]
[null,1,"Estates overhead costs"]
[null,"1a","Building insurance"]
[null,"1b","Building maintenance"]
[null,"1c","Capital charges - Buildings"]
[null,"1d","Cleaning"]
[null,"1e","Energy/Utilities (unless metered) "]
[]
[null,2,"Other overheads"]
[null,"2a","Board expenses"]
[null,"2b","Computer licences"]
[null,"2c","Finance"]
[null,"2d","General trust administration"]
[null,"2e","HR"]
[null,"2f","Information management"]
[null,"2g","Information technology"]
[null,"2h","Medical staff Management"]
[null,"2i","Organisational development"]
[null,"2j","Payroll"]
[null,"2k","Procurement"]
[null,"2l","Site security"]
[null,"2m","Strategic planning"]
[null,"2n","Training - Organisation Wide"]
[null,"2o","Consultancy Costs - Organisation Wide"]
[null,"2p","PFI Payments"]
[null,"2q","Interest payments"]
[null,"2r","Patient liaison and complaints"]
[null,"2s","Marketing and public relations"]
[null,"2t","Other"]
[]
[null,3,"Total Overheads",{"$f":"SUM(D123:D150)","v":0}]