{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["FrontScreen","Guidance","TrustInfo","MAQS","CostPool","Reconciliation","Settings","Ref","newAllo"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":43,"comments":2,"pivot_tables":1},"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":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[14,1,14,15]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"note: PLEASE ENSURE MACRO CONTENT IS ENABLED!"]
[]
[]
[null,"[click on HFMA logo for sheet admin access]"]

{"sheet":"Guidance","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Guidance notes (Mental Health)"]
[]
[]
[null,null,null,"Structure of the MAQs template"]
[null,null,1,null,"The MAQS worksheet is the main data input sheet. Column D classifies costs as direct, indirect and overhead. Resource categories are listed in column E with suggestions costs for inclusion in column G.  The cells where input is required are coloured in yellow."]
[null,null,2,null," Please first select allocation method(s) in column J. Standard 2 provides information on costing allocation methodologies. A spreadsheet is available on the HFMA website that shows each of the allocation methodologies for each resource category."]
[null,null,3,null,"It is possible to duplicate a resource category row where there are multiple allocation methods, allowing better reflection of the costing approach adopted. To achieve this use the [+] button which then duplicates the row below. If an organisation uses several different allocation methodologies for one resource category (e.g. different community teams) then the costs associated with each allocation option can be entered accordingly. "]
[null,null,4,null," An additional costing allocation methodology option (‘other’) has been included, for use where trusts are unable to meet the baseline.  Any costs allocated to this line will be included in the quantum but will be zero-scored when contributing to the overall MAQ score."]
[null,null,5,null,"The total costs for each resource category should be input in column L. These should be exact amounts, rounded to the nearest £ only."]
[null,null,6,null,"The MAQS will be automatically calculated, and shown in column O and Q with the former based on allocation methodology  and latter as a feed into the total score. The resource MAQS worksheet will also be automatically populated, which shows the MAQS broken down by resource category. Please see section below for further guidance on this worksheet."]
[null,null,7,null,"Column N can be checked to identify services that are contracted out.  This will not alter your MAQS score but will enable trusts to identify areas where improvements in allocation methods are not entirely within the trust control.  This should also help with benchmarking of MAQs scores"]
[null,null,null,"Resource MAQS worksheet"]
[null,null,8,null,"The resource category worksheet breaks down the overall MAQS by resource category. The colour coding of column E is intended to help identify which resource categories have a good MAQS score, and which have a lower score and may therefore require further work. "]
[null,null,9,null,"We are aware that a resource category may be flagged as being red for example, but it may be immaterial to the organisation. Therefore in order to help focus attention on material resource categories, there is the ability to input a materiality threshold level in cell D14."]
[null,null,10,null,"There is also the ability to input a target MAQS for any of the resource categories in column H. This feature allows you to calculate the improvement in the overall MAQS score if the MAQS for a given resource category is improved by a chosen percentage rate. This allows you to identify where resources could be best targeted to ensure improvements in costing data have the greatest impact on the overall quality of the cost information produced."]
[null,null,11,null,"The costing allocation methodologies have been significantly revised for 2016/17 by the MH costing practitioner group. If you have any feedback on the allocation methodologies please email: costing@hfma.org.uk."]
[null,null,null,"Reconciliation worksheet"]
[null,null,12,null,"The reconciliation statement allows organisations to reconcile the financial values input in the MAQS worksheet to the output from the costing system. There is the ability to provide explanations and reasons for any differences at the end of the statement."]
[]
[]
[null,null,null,null,"February 2016"]

{"sheet":"TrustInfo","index":2,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,3,6,4],[10,3,10,4]]}
[]
[]
[]
[]
[]
[null,null,null,"Please select:"]
[null,null,"Organisation Code:"]
[null,null,"Organisation Name:",{"$f":"IFERROR(VLOOKUP(TI_org_code,REF_Org,2,FALSE),\"...\")","v":"..."}]
[]
[]
[null,null,"Date completed by"]
[null,null,null,"dd/mm/yyyy"]
[]
[]
[null,null,"Contact details","Name"]
[null,null,null,"Job Title"]
[null,null,null,"Email"]
[null,null,null,"Contact number"]
[]
[null,null,null,null,{"$f":"SysYear&\" MH MAQS Template v\"&SysVersion","v":"201617 MH MAQS Template v1"}]
[]
[]
[null,null,"Please contact HFMA if your trust is not selectable above at costing@hfma.org.uk"]

{"sheet":"MAQS","index":3,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[5,5,5,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,"Organisation Name:",{"$f":"IF(TI_org_name=\"...\",\"Organisation Name <Not yet specified via Trust Info.>\",TI_org_name)","v":"Organisation Name <Not yet specified via Trust Info.>"}]
[]
[null,null,null,null,"Final MAQS:",{"$f":"MAQS_FinalMAQS_Total","v":0},null,null,null,null,"Total Costs",{"$f":"SUM(MAQS_TC)","v":0},null,null,null,"Total Score",{"$f":"SUM(MAQS_FinalMAQS)","v":0}]
[]
["Cost Pool Group ID","Unique ID","Sub Row?","Cost Cat. ","Resource Category","Resource Type","SUGGESTED COSTS FOR INCLUSION IN THIS CATEORY ","ADD LINE","REMOVE LINE","Allocation Method Adopted \n(Use the green [+] ADD LINE button to enter multiple allocation methods for a resource category)","Score for Allocation Method","Total Costs\n(Please insert the costs. If no cost is reported for the resource category, please leave the cell in its current default format.)","% Dataset Matching\n(Please insert the % of dataset which matches the Total Costs being reported for each line)","Contracted Out Services Flag\n(enter 1 to flag as contracted out element)","Process Matching Score based on allocation method","MAQS based on resource category total","Final MAQS based on total costs","Narrative\n(Free text for use as required. Please provide further explanation of costs included and excluded as necessary.)"]
[{"$f":"LEFT(B11,3)","v":"E01"},"E01F01",1,"DIRECT","Wards - nursing pay","Pay costs","Nursing costs","+","-","<Please Select>",{"$f":"IFERROR(OFFSET(UniqueID_Start,MATCH(B11,UniqueID,0)+MATCH(TRUE,INDEX(OFFSET(UniqueID_Start,MATCH(B11,UniqueID,0),5,COUNTIF(UniqueID,B11),1)=J11,0),0)-1,6,1,1),\"NA\")","v":"NA"},0,100,null,{"$f":"IF(OR(L11=0,M11=0),\"\",IFERROR(K11*M11/100,\"ERR\"))","v":""},{"$f":"IF(OR(K11=\"MIX\",L11=0,O11=0),\"\",IFERROR(L11/SUMIF(MAQS_CPGCODE,A11,MAQS_TC)*O11,0))","v":""},{"$f":"IF(OR(L11=0,O11=\"\"),\"\",IFERROR(L11*O11/MAQS_TC_Total,0))","v":""}]
[{"$f":"LEFT(B12,3)","v":"E12"},"E12F02",1,"DIRECT","Other clinical staff - inpatients","Pay & non pay costs","E.g. Psychology,psychotherapy, physiotherapy, occupational therapy pay and associated non pay costs. Do not include nursing or medical staff.","+","-","<Please Select>",{"$f":"IFERROR(OFFSET(UniqueID_Start,MATCH(B12,UniqueID,0)+MATCH(TRUE,INDEX(OFFSET(UniqueID_Start,MATCH(B12,UniqueID,0),5,COUNTIF(UniqueID,B12),1)=J12,0),0)-1,6,1,1),\"NA\")","v":"NA"},0,100,null,{"$f":"IF(OR(L12=0,M12=0),\"\",IFERROR(K12*M12/100,\"ERR\"))","v":""},{"$f":"IF(OR(K12=\"MIX\",L12=0,O12=0),\"\",IFERROR(L12/SUMIF(MAQS_CPGCODE,A12,MAQS_TC)*O12,0))","v":""},""]
[{"$f":"LEFT(B13,3)","v":"E02"},"E02F02",1,"DIRECT","Wards - Other pay and non nursing pay","Pay & non pay costs","e.g.  Other pay: admin & clerical.  Non pay:  staff uniform, towels, furniture & fittings, computer software, cleaning materials.","+","-","<Please Select>","NA",0,100,null,"",{"$f":"IF(OR(K13=\"MIX\",L13=0,O13=0),\"\",IFERROR(L13/SUMIF(MAQS_CPGCODE,A13,MAQS_TC)*O13,0))","v":""},""]
["E03","E03F02",1,"DIRECT","Medical staff (Consultants) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","+","-","<Please Select>","NA",0,100,null,"","",""]
[{"$f":"LEFT(B15,3)","v":"E04"},"E04F02",1,"DIRECT","Medical staff (Consultants) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","+","-","<Please Select>","NA",0,100,null,"","",""]
["E05","E05F02",1,"DIRECT","Medical staff (career grade Junior Doctors) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload","+","-","<Please Select>","NA",0,100,null,"","",""]
["E06","E06F02",1,"DIRECT","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants","+","-","<Please Select>","NA",0,100,null,"","",""]
["E07","E07F02",1,"DIRECT","Medical staff ( Junior Doctors - Doctors in training) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars ","+","-","<Please Select>","NA",0,100,null,"","",""]
["E08","E08F02",1,"DIRECT","Medical staff ( Junior Doctors - Doctors in training) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars ","+","-","<Please Select>","NA",0,100,null,"","",""]
["E09","E09F02",1,"DIRECT","Community teams - non clinical staff & non pay","Pay & non pay costs","Non- clinical  staff pay and office costs.","+","-","<Please Select>","NA",0,100,null,"","",""]
["E10","E10F02",1,"DIRECT","All community clinical staff","Pay & non pay costs","Staff pay and staff travel costs - community staff","+","-","<Please Select>","NA",0,100,null,"","",""]
["E11","E11F02",1,"DIRECT","Day care","Pay & non pay costs","Day care services","+","-","<Please Select>","NA",0,100,null,"","",""]
["E13","E13F03",1,"DIRECT","Special procedure suites (e.g. ECT, Section 136 suites)","Pay & non pay costs","ECT, Section 136 suites","+","-","<Please Select>","NA",0,100,null,"","",""]
["E14","E14F02",1,"DIRECT","Clinical Support Functions - Blood","Pay & non pay costs","Blood & blood products","+","-","<Please Select>","NA",0,100,null,"","",""]
["E15","E15F02",1,"DIRECT","Clinical Support Functions - Imaging","Pay & non pay costs","X-Ray, CT MRI, Other Radiology","+","-","<Please Select>","NA",0,100,null,"","",""]
["E16","E16F02",1,"DIRECT","Clinical Support Functions - Other diagnostics","Pay & non pay costs","ECGs, EEGs etc","+","-","<Please Select>","NA",0,100,null,"","",""]
["E17","E17F02",1,"DIRECT","Clinical Support Functions - Pathology","Pay & non pay costs","Pathology","+","-","<Please Select>","NA",0,100,null,"","",""]
["E18","E18F04",1,"DIRECT","Drugs and drug dispensing - inpatients","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for inpatients","+","-","<Please Select>","NA",0,100,null,"","",""]
["E19","E19F04",1,"DIRECT","Drugs and drug dispensing - community","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for community services","+","-","<Please Select>","NA",0,100,null,"","",""]
["E20","E20F05",1,"DIRECT","Drugs and drug dispensing - stock drugs","inpatient stock drugs on wards","Stock drugs on a ward","+","-","<Please Select>","NA",0,100,null,"","",""]
["E21","E21F06",1,"DIRECT","Drugs and drug dispensing - FP10s","prescribed drugs","prescribed drugs","+","-","<Please Select>","NA",0,100,null,"","",""]
["E22","E22F02",1,"DIRECT","Other clinical costs","Pay & non pay costs","Include social workers and other scientific and technical staff. ","+","-","<Please Select>","NA",0,100,null,"","",""]
["E23","E23F02",1,"DIRECT","Secondary commissioning costs","Pay & non pay costs","Clinical  services that are subcontracted out, e.g. out of area placements","+","-","<Please Select>","NA",0,100,null,"","",""]
["E24","E24F03",1,"INDIRECT","Capital charges - equipment costs that can be allocated to clinical departments","Non pay costs","Capital charges - Equipment depreciation, maintenance and interest","+","-","<Please Select>","NA",0,100,null,"","",""]
["E25","E25F02",1,"INDIRECT","Clinical safety, quality, audit, CNST","Pay & non pay costs","Clinical audit, governance and clinical risk ","+","-","<Please Select>","NA",0,100,null,"","",""]
["E26","E26F02",1,"INDIRECT","Consultancy costs for a specific department or service","Pay & non pay costs","Consultancy costs for a specific department or service","+","-","<Please Select>","NA",0,100,null,"","",""]
["E27","E27F02",1,"INDIRECT","Divisional & operational management and admin","Pay & non pay costs","Operational and departmental managers. Also includes admin teams.","+","-","<Please Select>","NA",0,100,null,"","",""]
["E28","E28F02",1,"INDIRECT","Linen","Pay & non pay costs","General Linen Stores","+","-","<Please Select>",{"$f":"IFERROR(OFFSET(UniqueID_Start,MATCH(B38,UniqueID,0)+MATCH(TRUE,INDEX(OFFSET(UniqueID_Start,MATCH(B38,UniqueID,0),5,COUNTIF(UniqueID,B38),1)=J38,0),0)-1,6,1,1),\"NA\")","v":"NA"},0,100,null,"","",""]
["E29","E29F02",1,"INDIRECT","Medical records","Pay & non pay costs","Medical records department and library costs","+","-","<Please Select>","NA",0,100,null,"","",""]
["E30","E30F02",1,"INDIRECT","Service user transport","Pay & non pay costs","Ambulance costs, taxis, voluntary cars","+","-","<Please Select>","NA",0,100,null,"","",""]
["E31","E31F02",1,"INDIRECT","Pharmacy services ","Pay & non pay costs","Clinical Pharmacy departmental costs pay and non pay","+","-","<Please Select>","NA",0,100,null,"","",""]
["E32","E32F02",1,"INDIRECT","Service user catering","Pay & non pay costs","Catering on wards, not commercial canteens","+","-","<Please Select>","NA",0,100,null,"","",""]
["E33","E33F02",1,"OVERHEADS","Corporate overheads - allocated on gross spend","Pay & non pay costs","Board of directors expenditure, financial management, financial accounts, information management, costing teams, Legal costs, marketing, communications,  OD department including  central library, Business planning, strategic business cases, FT application, Interest payments, Marketing and public relations","+","-","<Please Select>","NA",0,100,null,"","",""]
["E34","E34F02",1,"OVERHEADS","Corporate Overheads - allocated on floor space ","Pay & non pay costs","Insurance premiums, maintenance staff, property strategy costs,  dividend , interest depreciation on buildings, PFI unitary payments, gas, electricity, water, telecoms , switchboard equipment, rent and rates, hire of halls or rooms,  grounds and gardens, security, alarms , portering, logistics, distribution , general hotel services , fire safety , security","+","-","<Please Select>","NA",0,100,null,"","",""]
["E35","E35F02",1,"OVERHEADS","Capital Charges (equipment that cannot be allocated to a specific clinical department)","Non pay costs","Capital charges (equipment that cannot be allocated to a specific clinical department)","+","-","<Please Select>","NA",0,100,null,"","",""]
["E36","E36F03",1,"OVERHEADS","PDC dividend","Non pay costs","PDC dividend costs","+","-","<Please Select>","NA",0,100,null,"","",""]
["E37","E37F02",1,"OVERHEADS","PFI payments","Pay & non pay costs","PFI payments","+","-","<Please Select>","NA",0,100,null,"","",""]
["E38","E38F02",1,"OVERHEADS","Cleaning","Pay & non pay costs","Domestics staff and cleaning costs","+","-","<Please Select>","NA",0,100,null,"","",""]
["E39","E39F02",1,"OVERHEADS","Information Technology","Pay & non pay costs","Hardware / software, IT support and delivery, IMT contracts, PAS help desk, computer licences","+","-","<Please Select>","NA",0,100,null,"","",""]
["E40","E40F02",1,"OVERHEADS","Payroll","Pay & non pay costs","payroll costs / SLA","+","-","<Please Select>","NA",0,100,null,"","",""]
["E41","E41F02",1,"OVERHEADS","Procurement","Pay & non pay costs","costs of procurement department or outsourced costs","+","-","<Please Select>","NA",0,100,null,"","",""]
["E42","E42F02",1,"OVERHEADS","Consultancy costs for trust wide projects","Pay & non pay costs","Consultancy costs for trust wide projects","+","-","<Please Select>","NA",0,100,null,"","",""]
["E43","E43F02",1,"OVERHEADS","HR","Pay & non pay costs","Occupational health, HR management ","+","-","<Please Select>","NA",0,100,null,"","",""]
["E44","E44F02",1,"OVERHEADS","Medical Director and Medical Staff Management","Pay & non pay costs","Medical staff management and medical secretaries","+","-","<Please Select>","NA",0,100,null,"","",""]

{"sheet":"CostPool","index":4,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[15,1,16,7],[26,3,26,4]]}
[]
[]
[]
[]
[]
[null,"MAQS for resource categories"]
[]
[null,{"$f":"IF(TI_org_name=\"...\",\"Organisation Name <Not yet specified via Trust Info.>\",TI_org_name)","v":"Organisation Name <Not yet specified via Trust Info.>"}]
[]
[null,"This table shows the breakdown of the overall MAQS by resource categories, allowing organisations to identify where improvements in costing data "]
[null,"could increase the overall MAQS. "]
[null,"Trusts should set their own materiality level for resource categories, choosing a percentage of total costs (e.g. 2%)."]
[]
[null,null,"Enter the trust defined materiality level",null,null,null,"For info: Materiality by value",{"$f":"D14*$C$73","v":0}]
[]
[null,"Trusts can also see how the total MAQS would change if the MAQS for a resource category could be improved by entering a new value in the final column (H) for each resource category."]
[]
[]
[]
[]
[null,null,"Total MAQS:",{"$f":"MAQS_FinalMAQS_Total","v":0},{"$f":"IF(D21=0,\"\",IF(D21<0.45,\"Baseline\",IF(D21>=0.75,\"Gold\",IF(AND(D21<0.75,D21>=0.6),\"Silver\",\"Bronze\"))))","v":""}]
[]
[null,null,"Expected MAQS if improvement achieved:",{"$f":"SUM($J$28:$J$74)","v":0},{"$f":"IF(D23=0,\"\",IF(D23<0.45,\"Baseline\",IF(D23>=0.75,\"Gold\",IF(AND(D23<0.75,D23>=0.6),\"Silver\",\"Bronze\"))))","v":""}]
[]
[]
[]
[null,"Resource Category","Total costs","MAQS for resource categories",null,null,"Resource categories above materiality level but below baseline","Enter the intended MAQS for the resource activities after improvement work to see effect on total MAQS","New cost group pool MAQS","New final MAQS"]
["E01","Wards - nursing pay",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A28,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A28,MAQS_CPGMAQS))","v":0},{"$f":"IF(D28=0,\"\",IF(D28<0.45,\"Baseline\",IF(D28>=0.75,\"Gold\",IF(AND(D28<0.75,D28>=0.6),\"Silver\",\"Bronze\"))))","v":""},null,{"$f":"IF(AND(C28>D$14*C$73,E28=\"Baseline\"),\"Area for improvement\",\"\")","v":""},null,{"$f":"IF(OR(H28=\"\",H28=0),D28,H28)","v":0},{"$f":"IFERROR(I28*C28/MAQS_TC_Total,0)","v":0}]
["E12","Other clinical staff - inpatients",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A29,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A29,MAQS_CPGMAQS))","v":0},{"$f":"IF(D29=0,\"\",IF(D29<0.45,\"Baseline\",IF(D29>=0.75,\"Gold\",IF(AND(D29<0.75,D29>=0.6),\"Silver\",\"Bronze\"))))","v":""},null,"",null,{"$f":"IF(OR(H29=\"\",H29=0),D29,H29)","v":0},{"$f":"IFERROR(I29*C29/MAQS_TC_Total,0)","v":0}]
["E02","Wards - Other pay and non nursing pay",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A30,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A30,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E03","Medical staff (Consultants) - inpatients incl Special Procedure Suites",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A31,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A31,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E04","Medical staff (Consultants) - community incl Special Procedure Suites",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A32,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A32,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E05","Medical staff (career grade Junior Doctors) - inpatients incl Special Procedure Suites",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A33,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A33,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E06","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A34,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A34,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E07","Medical staff ( Junior Doctors - Doctors in training) - inpatients incl Special Procedure Suites",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A35,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A35,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E08","Medical staff ( Junior Doctors - Doctors in training) - community incl Special Procedure Suites",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A36,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A36,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E09","Community teams - non clinical staff & non pay",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A37,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A37,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E10","All community clinical staff",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A38,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A38,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E11","Day care",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A39,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A39,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E13","Special procedure suites (e.g. ECT, Section 136 suites)",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A40,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A40,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E14","Clinical Support Functions - Blood",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A41,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A41,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E15","Clinical Support Functions - Imaging",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A42,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A42,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E16","Clinical Support Functions - Other diagnostics",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A43,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A43,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E17","Clinical Support Functions - Pathology",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A44,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A44,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E18","Drugs and drug dispensing - inpatients",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A45,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A45,MAQS_CPGMAQS))","v":0},"",null,"",null,0,{"$f":"IFERROR(I45*C45/MAQS_TC_Total,0)","v":0}]
["E19","Drugs and drug dispensing - community",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A46,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A46,MAQS_CPGMAQS))","v":0},{"$f":"IF(D46=0,\"\",IF(D46<0.45,\"Baseline\",IF(D46>=0.75,\"Gold\",IF(AND(D46<0.75,D46>=0.6),\"Silver\",\"Bronze\"))))","v":""},null,"",null,{"$f":"IF(OR(H46=\"\",H46=0),D46,H46)","v":0},0]
["E20","Drugs and drug dispensing - stock drugs",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A47,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A47,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E21","Drugs and drug dispensing - FP10s",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A48,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A48,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E22","Other clinical costs",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A49,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A49,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E23","Secondary commissioning costs",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A50,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A50,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E24","Capital charges - equipment costs that can be allocated to clinical departments",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A51,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A51,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E25","Clinical safety, quality, audit, CNST",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A52,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A52,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E26","Consultancy costs for a specific department or service",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A53,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A53,MAQS_CPGMAQS))","v":0},{"$f":"IF(D53=0,\"\",IF(D53<0.45,\"Baseline\",IF(D53>=0.75,\"Gold\",IF(AND(D53<0.75,D53>=0.6),\"Silver\",\"Bronze\"))))","v":""},null,"",null,{"$f":"IF(OR(H53=\"\",H53=0),D53,H53)","v":0},{"$f":"IFERROR(I53*C53/MAQS_TC_Total,0)","v":0}]
["E27","Divisional & operational management and admin",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A54,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A54,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E28","Linen",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A55,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A55,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E29","Medical records",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A56,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A56,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E30","Service user transport",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A57,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A57,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E31","Pharmacy services ",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A58,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A58,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E32","Service user catering",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A59,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A59,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E33","Corporate overheads - allocated on gross spend",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A60,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A60,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E34","Corporate Overheads - allocated on floor space ",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A61,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A61,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E35","Capital Charges (equipment that cannot be allocated to a specific clinical department)",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A62,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A62,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E36","PDC dividend",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A63,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A63,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E37","PFI payments",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A64,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A64,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E38","Cleaning",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A65,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A65,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E39","Information Technology",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A66,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A66,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E40","Payroll",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A67,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A67,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E41","Procurement",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A68,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A68,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E42","Consultancy costs for trust wide projects",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A69,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A69,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E43","HR",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A70,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A70,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
["E44","Medical Director and Medical Staff Management",{"$f":"SUMIF(MAQS_CPGCODE,CostPool!$A71,MAQS_TC)","v":0},{"$f":"(SUMIF(MAQS_CPGCODE,CostPool!A71,MAQS_CPGMAQS))","v":0},"",null,"",null,0,0]
[]
[null,"Total of Resource Categories",{"$f":"SUM(C28:C71)","v":0}]

{"sheet":"Reconciliation","index":5,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[54,2,63,6]]}
[]
[]
[]
[]
[]
[null,null,"Reconciliation"]
[]
[null,null,{"$f":"IF(TI_org_name=\"...\",\"Organisation Name <Not yet specified via Trust Info.>\",TI_org_name)","v":"Organisation Name <Not yet specified via Trust Info.>"}]
[]
[null,null,"Section 1.1: Final Audited Accounts to MAQS Quantum"]
[]
[null,null,"Line","Description","Notes: FTs","Notes: NHS Trusts","£"]
[]
[null,null,"Section 1.1A - Expected MAQS Quantum"]
[null,null,1,"Operating expenses","SOCI sc105","TRU01 sc100 + sc110"]
[null,null,{"$f":"C15+1","v":2},"[ADD] Finance expenses financial liabilities (FTs) or finance costs (NHS trusts)","SOCI sc120","TRU01 sc170"]
[null,null,{"$f":"C16+1","v":3},"[ADD] PDC dividends payable","SOCI sc130","TRU01 sc190"]
[null,null,4,"[ADD] Finance expenses - unwinding of discount","SOCI sc125","Not applicable"]
[null,null,5,"[ADD] Corporation tax expense","SOCI sc145","Not applicable"]
[null,null,6,"PLICS Cost Quantum",null,null,{"$f":"SUM(G15:G19)","v":0}]
[]
[]
[null,null,"Section 1.1B - Recorded MAQS Quantum"]
[null,null,7,"Total Cost from 'MAQS' sheet in this template",null,null,{"$f":"MAQS_TC_Total","v":0}]
[]
[null,null,8,"Difference between lines 6 and 7",null,null,{"$f":"G20-G24","v":0}]
[]
[null,null,"Section 1.2: Adjustments"]
[]
[null,null,"Please list any adjustments explaining line 8 above:"]
[null,null,"Line","Description","Comments",null,"£"]
[]
[null,null,1,"[Insert description of variance factor]"]
[null,null,2,"[Insert description of variance factor]"]
[null,null,3,"[Insert description of variance factor]"]
[null,null,4,"[Insert description of variance factor]"]
[null,null,5,"[Insert description of variance factor]"]
[null,null,6,"[Insert description of variance factor]"]
[null,null,7,"[Insert description of variance factor]"]
[null,null,8,"[Insert description of variance factor]"]
[null,null,9,"[Insert description of variance factor]"]
[null,null,10,"[Insert description of variance factor]"]
[null,null,11,"[Insert description of variance factor]"]
[null,null,12,"[Insert description of variance factor]"]
[null,null,13,"[Insert description of variance factor]"]
[null,null,14,"[Insert description of variance factor]"]
[null,null,15,"[Insert description of variance factor]"]
[null,null,16,"[Insert description of variance factor]"]
[null,null,17,"[Insert description of variance factor]"]
[null,null,18,"[Insert description of variance factor]"]
[null,null,19,"[Insert description of variance factor]"]
[null,null,20,"[Insert description of variance factor]"]
[]
[null,null,"Additional Comments"]

{"sheet":"Settings","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,"HFMA Orange"]
["SysYear",201617,null,null,null,null,"R",255]
["SysType","PLB","< no idea what this is (cr)",null,null,null,"G",101]
["SysVersion",1,null,null,null,null,"B",0]
["SysNACSCode"]
["sysSavedDate"]
["sysSavedByUser"]
[]
["SysHeadline","HFMA Materiality and Quality Score (Mental Health) 2016/17"]

{"sheet":"Ref","index":7,"n_rows":247,"n_cols":19,"rows_kept":247,"cut":false,"hidden":true,"merged":[]}
["Reference Table"]
[]
["Org code","Org Name",null,"Cost Pool Groups","CostPoolID",null,"Service ","ServiceID",null,"Resource Type","ResourceID",null,"MAQS","Score","Resource Category",null,null,"Resource Type","ResourceID"]
["R1A","WORCESTERSHIRE HEALTH AND CARE NHS TRUST",null,"Blood and blood products","A01",null,"Admission and discharge facilities  (e.g. wards / lounges)","B01",null,"Consumables","C01",null,null,null,"Wards - nursing pay","E01",null,"Pay costs","F01"]
["R1C","SOLENT NHS TRUST",null,"CNST","A02",null,"Blood and blood products","B02",null,"Dispensary","C02",null,null,null,"Wards - Other pay and non nursing pay","E02",null,"Pay & non pay costs","F02"]
["R1D","SHROPSHIRE COMMUNITY HEALTH NHS TRUST",null,"Critical Care","A03",null,"Board expenses","B03",null,"Drugs","C03",null,null,null,"Medical staff (Consultants) - inpatients incl Special Procedure Suites","E03",null,"Non pay costs","F03"]
["R1E","STAFFORDSHIRE AND STOKE ON TRENT PARTNERSHIP NHS TRUST",null,"Drugs","A04",null,"Brachytherapy","B04",null,"Drugs - inpatient","C04",null,null,null,"Medical staff (Consultants) - community incl Special Procedure Suites","E04",null,"Drugs and drug dispensing costs ","F04"]
["R1F","ISLE OF WIGHT NHS TRUST",null,"Drugs - chemotherapy","A05",null,"Building Insurance","B05",null,"Drugs - non-inpatient","C05",null,null,null,"Medical staff (career grade Junior Doctors) - inpatients incl Special Procedure Suites","E05",null,"inpatient stock drugs on wards","F05"]
["R1G","TORBAY AND SOUTHERN DEVON HEALTH AND CARE NHS TRUST",null,"Drugs - high cost drugs","A06",null,"Building Maintenance","B06",null,"Drugs and drug dispensing costs","C06",null,null,null,"Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","E06",null,"prescribed drugs","F06"]
["R1H","BARTS HEALTH NHS TRUST",null,"Emergency department","A07",null,"Capital Charges - Buildings","B07",null,"High cost drugs","C07",null,null,null,"Medical staff ( Junior Doctors - Doctors in training) - inpatients incl Special Procedure Suites","E07"]
["RA2","ROYAL SURREY COUNTY HOSPITAL NHS FOUNDATION TRUST",null,"Imaging","A08",null,"Capital Charges - Equipment that can be allocated to clinical departments","B08",null,"Items","C08",null,null,null,"Medical staff ( Junior Doctors - Doctors in training) - community incl Special Procedure Suites","E08"]
["RA3","WESTON AREA HEALTH NHS TRUST",null,"Medical staffing","A09",null,"Catering ","B09",null,"Medical Physics","C09",null,null,null,"Community teams - non clinical staff & non pay","E09"]
["RA4","YEOVIL DISTRICT HOSPITAL NHS FOUNDATION TRUST",null,"Non patient care activities","A10",null,"Chemotherapy Delivery","B10",null,"Medical Physics - Engineering /QA Staff","C10",null,null,null,"All community clinical staff","E10"]
["RA7","UNIVERSITY HOSPITALS BRISTOL NHS FOUNDATION TRUST",null,"Operating theatres","A11",null,"Chemotherapy Procurement","B11",null,"Medical Salaries & associated non pay","C11",null,null,null,"Day care","E11"]
["RA9","SOUTH DEVON HEALTHCARE NHS FOUNDATION TRUST",null,"Other clinical services","A12",null,"Cleaning","B12",null,"Medical Salaries & non pay -  Anaesthetist","C12",null,null,null,"Other clinical staff - inpatients","E12"]
["RAE","BRADFORD TEACHING HOSPITALS NHS FOUNDATION TRUST",null,"Other diagnostics","A13",null,"Clinical coding","B13",null,"Medical Salaries & non pay Surgical","C13",null,null,null,"Special procedure suites (e.g. ECT, Section 136 suites)","E13"]
["RAJ","SOUTHEND UNIVERSITY HOSPITAL NHS FOUNDATION TRUST",null,"Outpatients","A14",null,"Clinical Negligence Scheme for Trusts(CNST)","B14",null,"Medical secretaries pay & non pay costs","C14",null,null,null,"Clinical Support Functions - Blood","E14"]
["RAL","ROYAL FREE LONDON NHS FOUNDATION TRUST",null,"Pathology","A15",null,"Clinical safety, quality, audit ","B15",null,"Mould Room","C15",null,null,null,"Clinical Support Functions - Imaging","E15"]
["RAN","ROYAL NATIONAL ORTHOPAEDIC HOSPITAL NHS TRUST",null,"Pharmacy costs","A16",null,"Community","B16",null,"Non Pay","C16",null,null,null,"Clinical Support Functions - Other diagnostics","E16"]
["RAP","NORTH MIDDLESEX UNIVERSITY HOSPITAL NHS TRUST",null,"Prostheses/implants/devices","A17",null,"Computer Licences","B17",null,"Non Pay - all other specialities","C17",null,null,null,"Clinical Support Functions - Pathology","E17"]
["RAS","THE HILLINGDON HOSPITALS NHS FOUNDATION TRUST",null,"Radiotherapy","A18",null,"CPD","B18",null,"Non Pay - Maternity","C18",null,null,null,"Drugs and drug dispensing - inpatients","E18"]
["RAT","NORTH EAST LONDON NHS FOUNDATION TRUST",null,"Secondary commissioning costs","A19",null,"Critical Care","B19",null,"Nursing Salaries","C19",null,null,null,"Drugs and drug dispensing - community","E19"]
["RAX","KINGSTON HOSPITAL NHS TRUST",null,"Special Procedure Suites","A20",null,"Day Care","B20",null,"Nursing Salaries & other clinicians (ODPs/ODAs)","C20",null,null,null,"Drugs and drug dispensing - stock drugs","E20"]
["RBA","TAUNTON AND SOMERSET NHS FOUNDATION TRUST",null,"Specialist nursing","A21",null,"Day surgery","B21",null,"Other pay costs","C21",null,null,null,"Drugs and drug dispensing - FP10s","E21"]
["RBB","ROYAL NATIONAL HOSPITAL FOR RHEUMATIC DISEASES NHS FOUNDATION TRUST",null,"Therapies","A22",null,"Directorate Management Costs","B22",null,"Other pay costs & non pay costs","C22",null,null,null,"Other clinical costs","E22"]
["RBD","DORSET COUNTY HOSPITAL NHS FOUNDATION TRUST",null,"Wards","A23",null,"Discharge facilities (e.g. wards / lounges)","B23",null,"Outsourced Service","C23",null,null,null,"Secondary commissioning costs","E23"]
["RBK","WALSALL HEALTHCARE NHS TRUST",null,"Part of relevant cost pool above","A24",null,"Education and Training - Direct costs","B24",null,"Patient Advice","C24",null,null,null,"Capital charges - equipment costs that can be allocated to clinical departments","E24"]
["RBL","WIRRAL UNIVERSITY TEACHING HOSPITAL NHS FOUNDATION TRUST",null,"Overhead reporting category","A25",null,"Education and Training - Support costs and overheads","B25",null,"Pay Costs","C25",null,null,null,"Clinical safety, quality, audit, CNST","E25"]
["RBN","ST HELENS AND KNOWSLEY HOSPITALS NHS TRUST",null,null,null,null,"Emergency Department","B26",null,"Paycosts & non paycosts (where cannot be split)","C26",null,null,null,"Consultancy costs for a specific department or service","E26"]
["RBQ","LIVERPOOL HEART AND CHEST NHS FOUNDATION TRUST",null,null,null,null,"Energy/Utilities (unless metered) ","B27",null,"Procurement Costs","C27",null,null,null,"Divisional & operational management and admin","E27"]
["RBS","ALDER HEY CHILDREN'S NHS FOUNDATION TRUST",null,null,null,null,"Equipment maintenance & medical physics department","B28",null,"Radiographer Salaries","C28",null,null,null,"Linen","E28"]
["RBT","MID CHESHIRE HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Finance","B29",null,"Specimen Collection","C29",null,null,null,"Medical records","E29"]
["RBV","THE CHRISTIE NHS FOUNDATION TRUST",null,null,null,null,"General Trust Administration","B30",null,"Medical Staffing","C30",null,null,null,"Service user transport","E30"]
["RBZ","NORTHERN DEVON HEALTHCARE NHS TRUST",null,null,null,null,"HR","B31",null,"Paycosts & non paycosts (where cannot be split) excluding Medical Staffing Costs","C31",null,null,null,"Pharmacy services ","E31"]
["RC1","BEDFORD HOSPITAL NHS TRUST",null,null,null,null,"Information Management","B32",null,"Non Pay excluding Medical Staffing Non Pay","C32",null,null,null,"Service user catering","E32"]
["RC3","EALING HOSPITAL NHS TRUST",null,null,null,null,"Information Technology","B33",null,"Pay Costs excluding Medical Staffing Pay Costs","C33",null,null,null,"Corporate overheads - allocated on gross spend","E33"]
["RC9","LUTON AND DUNSTABLE HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Linen ","B34",null,null,null,null,null,null,"Corporate Overheads - allocated on floor space ","E34"]
["RCB","YORK TEACHING HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Medical records library","B35",null,null,null,null,null,null,"Capital Charges (equipment that cannot be allocated to a specific clinical department)","E35"]
["RCD","HARROGATE AND DISTRICT NHS FOUNDATION TRUST",null,null,null,null,"Medical staff","B36",null,null,null,null,null,null,"PDC dividend","E36"]
["RCF","AIREDALE NHS FOUNDATION TRUST",null,null,null,null,"Medical Staff Management","B37",null,null,null,null,null,null,"PFI payments","E37"]
["RCU","SHEFFIELD CHILDREN'S NHS FOUNDATION TRUST",null,null,null,null,"Multi-Disciplinary Team Meetings","B38",null,null,null,null,null,null,"Cleaning","E38"]
["RCX","THE QUEEN ELIZABETH HOSPITAL, KING'S LYNN, NHS FOUNDATION TRUST",null,null,null,null,"Operating theatres excluding recovery","B39",null,null,null,null,null,null,"Information Technology","E39"]
["RD1","ROYAL UNITED HOSPITAL BATH NHS TRUST",null,null,null,null,"Operating Theatres: Recovery Rooms","B40",null,null,null,null,null,null,"Payroll","E40"]
["RD3","POOLE HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Operational Managers","B41",null,null,null,null,null,null,"Procurement","E41"]
["RD7","HEATHERWOOD AND WEXHAM PARK HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Organisational Development","B42",null,null,null,null,null,null,"Consultancy costs for trust wide projects","E42"]
["RD8","MILTON KEYNES HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Other e.g. Clinical lead time, admin","B43",null,null,null,null,null,null,"HR","E43"]
["RDD","BASILDON AND THURROCK UNIVERSITY HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Other Clinical Services","B44",null,null,null,null,null,null,"Medical Director and Medical Staff Management","E44"]
["RDE","COLCHESTER HOSPITAL UNIVERSITY NHS FOUNDATION TRUST",null,null,null,null,"Other diagnostic testing","B45"]
["RDR","SUSSEX COMMUNITY NHS TRUST",null,null,null,null,"Outpatients Clinic Costs (Including Procedures)","B46"]
["RDU","FRIMLEY PARK HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Pathology / Diagnostic","B47"]
["RDY","DORSET HEALTHCARE UNIVERSITY NHS FOUNDATION TRUST",null,null,null,null,"Patient Transport","B48"]
["RDZ","THE ROYAL BOURNEMOUTH AND CHRISTCHURCH HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Payroll","B49"]
["RE9","SOUTH TYNESIDE NHS FOUNDATION TRUST",null,null,null,null,"Pharmacy","B50"]
["REF","ROYAL CORNWALL HOSPITALS NHS TRUST",null,null,null,null,"Pharmacy non production","B51"]
["REM","AINTREE UNIVERSITY HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Pharmacy production","B52"]
["REN","THE CLATTERBRIDGE CANCER CENTRE NHS FOUNDATION TRUST",null,null,null,null,"Portering","B53"]
["REP","LIVERPOOL WOMEN'S NHS FOUNDATION TRUST",null,null,null,null,"Procurement","B54"]
["RET","THE WALTON CENTRE NHS FOUNDATION TRUST",null,null,null,null,"Prosthetics / Devices / High cost consumables","B55"]
["RF4","BARKING, HAVERING AND REDBRIDGE UNIVERSITY HOSPITALS NHS TRUST",null,null,null,null,"R&D","B56"]
["RFF","BARNSLEY HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Radiology (Diagnostic)","B57"]
["RFR","THE ROTHERHAM NHS FOUNDATION TRUST",null,null,null,null,"Radiology (Therapeutic and Interventional Radiology)","B58"]
["RFS","CHESTERFIELD ROYAL HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Radiotherapy","B59"]
["RFW","WEST MIDDLESEX UNIVERSITY HOSPITAL NHS TRUST",null,null,null,null,"Radiotherapy Delivery","B60"]
["RGD","LEEDS AND YORK PARTNERSHIP NHS FOUNDATION TRUST",null,null,null,null,"Radiotherapy Planning","B61"]
["RGM","PAPWORTH HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Research and Development - Support Costs & Overheads","B62"]
["RGN","PETERBOROUGH AND STAMFORD HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Secondary Commissioning","B63"]
["RGP","JAMES PAGET UNIVERSITY HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Site security","B64"]
["RGQ","IPSWICH HOSPITAL NHS TRUST",null,null,null,null,"Specialist Nursing - Acute Sector","B65"]
["RGR","WEST SUFFOLK NHS FOUNDATION TRUST",null,null,null,null,"Specialist Nursing - Community Sector (not to be used for acute nursing that do home visits)","B66"]
["RGT","CAMBRIDGE UNIVERSITY HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Specialist Procedure Suites ","B67"]
["RH5","SOMERSET PARTNERSHIP NHS FOUNDATION TRUST",null,null,null,null,"Specialist Procedure Suites excluding Recovery","B68"]
["RH8","ROYAL DEVON AND EXETER NHS FOUNDATION TRUST",null,null,null,null,"Specialist Procedure Suites: Recovery Rooms","B69"]
["RHA","NOTTINGHAMSHIRE HEALTHCARE NHS TRUST",null,null,null,null,"Sterile services ","B70"]
["RHM","UNIVERSITY HOSPITAL SOUTHAMPTON NHS FOUNDATION TRUST",null,null,null,null,"Strategic Planning","B71"]
["RHQ","SHEFFIELD TEACHING HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Support for other services e.g. MRI","B72"]
["RHU","PORTSMOUTH HOSPITALS NHS TRUST",null,null,null,null,"Therapies","B73"]
["RHW","ROYAL BERKSHIRE NHS FOUNDATION TRUST",null,null,null,null,"Training ","B74"]
["RJ1","GUY'S AND ST THOMAS' NHS FOUNDATION TRUST",null,null,null,null,"Wards","B75"]
["RJ2","LEWISHAM HEALTHCARE NHS TRUST",null,null,null,null,"Ward rounds","B76"]
["RJ6","CROYDON HEALTH SERVICES NHS TRUST",null,null,null,null,"Drugs","B77"]
["RJ7","ST GEORGE'S HEALTHCARE NHS TRUST",null,null,null,null,"Training - Departmental","B78"]
["RJ8","CORNWALL PARTNERSHIP NHS FOUNDATION TRUST",null,null,null,null,"Training - Organisation Wide","B79"]
["RJC","SOUTH WARWICKSHIRE NHS FOUNDATION TRUST",null,null,null,null,"Consultancy Costs - Departmental","B80"]
["RJD","MID STAFFORDSHIRE NHS FOUNDATION TRUST",null,null,null,null,"Consultancy Costs - Organisation Wide","B81"]
["RJE","UNIVERSITY HOSPITAL OF NORTH STAFFORDSHIRE NHS TRUST",null,null,null,null,"PFI Payments","B82"]
["RJF","BURTON HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Interest Payments","B83"]
["RJL","NORTHERN LINCOLNSHIRE AND GOOLE HOSPITALS NHS FOUNDATION TRUST",null,null,null,null,"Patient liaison and complaints","B84"]
["RJN","EAST CHESHIRE NHS TRUST",null,null,null,null,"Marketing and Public Relations","B85"]
["RJR","COUNTESS OF CHESTER HOSPITAL NHS FOUNDATION TRUST",null,null,null,null,"Capital Charges - Equipment that cannot be allocated to a specific clinical department)","B86"]
["RJZ","KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST"]
["RK5","SHERWOOD FOREST HOSPITALS NHS FOUNDATION TRUST"]
["RK9","PLYMOUTH HOSPITALS NHS TRUST"]
["RKB","UNIVERSITY HOSPITALS COVENTRY AND WARWICKSHIRE NHS TRUST"]
["RKE","THE WHITTINGTON HOSPITAL NHS TRUST"]
["RKL","WEST LONDON MENTAL HEALTH NHS TRUST"]
["RL1","THE ROBERT JONES AND AGNES HUNT ORTHOPAEDIC HOSPITAL NHS FOUNDATION TRUST"]
["RL4","THE ROYAL WOLVERHAMPTON NHS TRUST"]
["RLN","CITY HOSPITALS SUNDERLAND NHS FOUNDATION TRUST"]
["RLQ","WYE VALLEY NHS TRUST"]
["RLT","GEORGE ELIOT HOSPITAL NHS TRUST"]
["RLU","BIRMINGHAM WOMEN'S NHS FOUNDATION TRUST"]
["RLY","NORTH STAFFORDSHIRE COMBINED HEALTHCARE NHS TRUST"]
["RM1","NORFOLK AND NORWICH UNIVERSITY HOSPITALS NHS FOUNDATION TRUST"]
["RM2","UNIVERSITY HOSPITAL OF SOUTH MANCHESTER NHS FOUNDATION TRUST"]
["RM3","SALFORD ROYAL NHS FOUNDATION TRUST"]
["RMC","BOLTON NHS FOUNDATION TRUST"]
["RMP","TAMESIDE HOSPITAL NHS FOUNDATION TRUST"]
["RMY","NORFOLK AND SUFFOLK NHS FOUNDATION TRUST"]
["RN3","GREAT WESTERN HOSPITALS NHS FOUNDATION TRUST"]
["RN5","HAMPSHIRE HOSPITALS NHS FOUNDATION TRUST"]
["RN7","DARTFORD AND GRAVESHAM NHS TRUST"]
["RNA","THE DUDLEY GROUP NHS FOUNDATION TRUST"]
["RNK","TAVISTOCK AND PORTMAN NHS FOUNDATION TRUST"]
["RNL","NORTH CUMBRIA UNIVERSITY HOSPITALS NHS TRUST"]
["RNN","CUMBRIA PARTNERSHIP NHS FOUNDATION TRUST"]
["RNQ","KETTERING GENERAL HOSPITAL NHS FOUNDATION TRUST"]
["RNS","NORTHAMPTON GENERAL HOSPITAL NHS TRUST"]
["RNU","OXFORD HEALTH NHS FOUNDATION TRUST"]
["RNZ","SALISBURY NHS FOUNDATION TRUST"]
["RP1","NORTHAMPTONSHIRE HEALTHCARE NHS FOUNDATION TRUST"]
["RP4","GREAT ORMOND STREET HOSPITAL FOR CHILDREN NHS FOUNDATION TRUST"]
["RP5","DONCASTER AND BASSETLAW HOSPITALS NHS FOUNDATION TRUST"]
["RP6","MOORFIELDS EYE HOSPITAL NHS FOUNDATION TRUST"]
["RP7","LINCOLNSHIRE PARTNERSHIP NHS FOUNDATION TRUST"]
["RPA","MEDWAY NHS FOUNDATION TRUST"]
["RPC","QUEEN VICTORIA HOSPITAL NHS FOUNDATION TRUST"]
["RPG","OXLEAS NHS FOUNDATION TRUST"]
["RPY","THE ROYAL MARSDEN NHS FOUNDATION TRUST"]
["RQ3","BIRMINGHAM CHILDREN'S HOSPITAL NHS FOUNDATION TRUST"]
["RQ6","ROYAL LIVERPOOL AND BROADGREEN UNIVERSITY HOSPITALS NHS TRUST"]
["RQ8","MID ESSEX HOSPITAL SERVICES NHS TRUST"]
["RQM","CHELSEA AND WESTMINSTER HOSPITAL NHS FOUNDATION TRUST"]
["RQQ","HINCHINGBROOKE HEALTH CARE NHS TRUST"]
["RQW","THE PRINCESS ALEXANDRA HOSPITAL NHS TRUST"]
["RQX","HOMERTON UNIVERSITY HOSPITAL NHS FOUNDATION TRUST"]
["RQY","SOUTH WEST LONDON AND ST GEORGE'S MENTAL HEALTH NHS TRUST"]
["RR1","HEART OF ENGLAND NHS FOUNDATION TRUST"]
["RR7","GATESHEAD HEALTH NHS FOUNDATION TRUST"]
["RR8","LEEDS TEACHING HOSPITALS NHS TRUST"]
["RRD","NORTH ESSEX PARTNERSHIP NHS FOUNDATION TRUST"]
["RRE","SOUTH STAFFORDSHIRE AND SHROPSHIRE HEALTHCARE NHS FOUNDATION TRUST"]
["RRF","WRIGHTINGTON, WIGAN AND LEIGH NHS FOUNDATION TRUST"]
["RRJ","THE ROYAL ORTHOPAEDIC HOSPITAL NHS FOUNDATION TRUST"]
["RRK","UNIVERSITY HOSPITALS BIRMINGHAM NHS FOUNDATION TRUST"]
["RRP","BARNET, ENFIELD AND HARINGEY MENTAL HEALTH NHS TRUST"]
["RRU","LONDON AMBULANCE SERVICE NHS TRUST"]
["RRV","UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST"]
["RT1","CAMBRIDGESHIRE AND PETERBOROUGH NHS FOUNDATION TRUST"]
["RT2","PENNINE CARE NHS FOUNDATION TRUST"]
["RT3","ROYAL BROMPTON AND HAREFIELD NHS FOUNDATION TRUST"]
["RT5","LEICESTERSHIRE PARTNERSHIP NHS TRUST"]
["RTD","THE NEWCASTLE UPON TYNE HOSPITALS NHS FOUNDATION TRUST"]
["RTE","GLOUCESTERSHIRE HOSPITALS NHS FOUNDATION TRUST"]
["RTF","NORTHUMBRIA HEALTHCARE NHS FOUNDATION TRUST"]
["RTG","DERBY HOSPITALS NHS FOUNDATION TRUST"]
["RTH","OXFORD UNIVERSITY HOSPITALS NHS TRUST"]
["RTK","ASHFORD AND ST PETER'S HOSPITALS NHS FOUNDATION TRUST"]
["RTP","SURREY AND SUSSEX HEALTHCARE NHS TRUST"]
["RTQ","2GETHER NHS FOUNDATION TRUST"]
["RTR","SOUTH TEES HOSPITALS NHS FOUNDATION TRUST"]
["RTV","5 BOROUGHS PARTNERSHIP NHS FOUNDATION TRUST"]
["RTX","UNIVERSITY HOSPITALS OF MORECAMBE BAY NHS FOUNDATION TRUST"]
["RV3","CENTRAL AND NORTH WEST LONDON NHS FOUNDATION TRUST"]
["RV5","SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST"]
["RV8","NORTH WEST LONDON HOSPITALS NHS TRUST"]
["RV9","HUMBER NHS FOUNDATION TRUST"]
["RVJ","NORTH BRISTOL NHS TRUST"]
["RVL","BARNET AND CHASE FARM HOSPITALS NHS TRUST"]
["RVN","AVON AND WILTSHIRE MENTAL HEALTH PARTNERSHIP NHS TRUST"]
["RVR","EPSOM AND ST HELIER UNIVERSITY HOSPITALS NHS TRUST"]
["RVV","EAST KENT HOSPITALS UNIVERSITY NHS FOUNDATION TRUST"]
["RVW","NORTH TEES AND HARTLEPOOL NHS FOUNDATION TRUST"]
["RVY","SOUTHPORT AND ORMSKIRK HOSPITAL NHS TRUST"]
["RW1","SOUTHERN HEALTH NHS FOUNDATION TRUST"]
["RW3","CENTRAL MANCHESTER UNIVERSITY HOSPITALS NHS FOUNDATION TRUST"]
["RW4","MERSEY CARE NHS TRUST"]
["RW5","LANCASHIRE CARE NHS FOUNDATION TRUST"]
["RW6","PENNINE ACUTE HOSPITALS NHS TRUST"]
["RWA","HULL AND EAST YORKSHIRE HOSPITALS NHS TRUST"]
["RWD","UNITED LINCOLNSHIRE HOSPITALS NHS TRUST"]
["RWE","UNIVERSITY HOSPITALS OF LEICESTER NHS TRUST"]
["RWF","MAIDSTONE AND TUNBRIDGE WELLS NHS TRUST"]
["RWG","WEST HERTFORDSHIRE HOSPITALS NHS TRUST"]
["RWH","EAST AND NORTH HERTFORDSHIRE NHS TRUST"]
["RWJ","STOCKPORT NHS FOUNDATION TRUST"]
["RWK","EAST LONDON NHS FOUNDATION TRUST"]
["RWN","SOUTH ESSEX PARTNERSHIP UNIVERSITY NHS FOUNDATION TRUST"]
["RWP","WORCESTERSHIRE ACUTE HOSPITALS NHS TRUST"]
["RWR","HERTFORDSHIRE PARTNERSHIP NHS FOUNDATION TRUST"]
["RWV","DEVON PARTNERSHIP NHS TRUST"]
["RWW","WARRINGTON AND HALTON HOSPITALS NHS FOUNDATION TRUST"]
["RWX","BERKSHIRE HEALTHCARE NHS FOUNDATION TRUST"]
["RWY","CALDERDALE AND HUDDERSFIELD NHS FOUNDATION TRUST"]
["RX1","NOTTINGHAM UNIVERSITY HOSPITALS NHS TRUST"]
["RX2","SUSSEX PARTNERSHIP NHS FOUNDATION TRUST"]
["RX3","TEES, ESK AND WEAR VALLEYS NHS FOUNDATION TRUST"]
["RX4","NORTHUMBERLAND, TYNE AND WEAR NHS FOUNDATION TRUST"]
["RX6","NORTH EAST AMBULANCE SERVICE NHS FOUNDATION TRUST"]
["RX7","NORTH WEST AMBULANCE SERVICE NHS TRUST"]
["RX8","YORKSHIRE AMBULANCE SERVICE NHS TRUST"]
["RX9","EAST MIDLANDS AMBULANCE SERVICE NHS TRUST"]
["RXA","CHESHIRE AND WIRRAL PARTNERSHIP NHS FOUNDATION TRUST"]
["RXC","EAST SUSSEX HEALTHCARE NHS TRUST"]
["RXE","ROTHERHAM, DONCASTER AND SOUTH HUMBER NHS FOUNDATION TRUST"]
["RXF","MID YORKSHIRE HOSPITALS NHS TRUST"]
["RXG","SOUTH WEST YORKSHIRE PARTNERSHIP NHS FOUNDATION TRUST"]
["RXH","BRIGHTON AND SUSSEX UNIVERSITY HOSPITALS NHS TRUST"]
["RXK","SANDWELL AND WEST BIRMINGHAM HOSPITALS NHS TRUST"]
["RXL","BLACKPOOL TEACHING HOSPITALS NHS FOUNDATION TRUST"]
["RXM","DERBYSHIRE HEALTHCARE NHS FOUNDATION TRUST"]
["RXN","LANCASHIRE TEACHING HOSPITALS NHS FOUNDATION TRUST"]
["RXP","COUNTY DURHAM AND DARLINGTON NHS FOUNDATION TRUST"]
["RXQ","BUCKINGHAMSHIRE HEALTHCARE NHS TRUST"]
["RXR","EAST LANCASHIRE HOSPITALS NHS TRUST"]
["RXT","BIRMINGHAM AND SOLIHULL MENTAL HEALTH NHS FOUNDATION TRUST"]
["RXV","GREATER MANCHESTER WEST MENTAL HEALTH NHS FOUNDATION TRUST"]
["RXW","SHREWSBURY AND TELFORD HOSPITAL NHS TRUST"]
["RXX","SURREY AND BORDERS PARTNERSHIP NHS FOUNDATION TRUST"]
["RXY","KENT AND MEDWAY NHS AND SOCIAL CARE PARTNERSHIP TRUST"]
["RY1","LIVERPOOL COMMUNITY HEALTH NHS TRUST"]
["RY2","BRIDGEWATER COMMUNITY HEALTHCARE NHS TRUST"]
["RY3","NORFOLK COMMUNITY HEALTH AND CARE NHS TRUST"]
["RY4","HERTFORDSHIRE COMMUNITY NHS TRUST"]
["RY5","LINCOLNSHIRE COMMUNITY HEALTH SERVICES NHS TRUST"]
["RY6","LEEDS COMMUNITY HEALTHCARE NHS TRUST"]
["RY7","WIRRAL COMMUNITY NHS TRUST"]
["RY8","DERBYSHIRE COMMUNITY HEALTH SERVICES NHS TRUST"]
["RY9","HOUNSLOW AND RICHMOND COMMUNITY HEALTHCARE NHS TRUST"]
["RYA","WEST MIDLANDS AMBULANCE SERVICE NHS FOUNDATION TRUST"]
["RYC","EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST"]
["RYD","SOUTH EAST COAST AMBULANCE SERVICE NHS FOUNDATION TRUST"]
["RYE","SOUTH CENTRAL AMBULANCE SERVICE NHS FOUNDATION TRUST"]
["RYF","SOUTH WESTERN AMBULANCE SERVICE NHS FOUNDATION TRUST"]
["RYG","COVENTRY AND WARWICKSHIRE PARTNERSHIP NHS TRUST"]
["RYJ","IMPERIAL COLLEGE HEALTHCARE NHS TRUST"]
["RYK","DUDLEY AND WALSALL MENTAL HEALTH PARTNERSHIP NHS TRUST"]
["RYQ","SOUTH LONDON HEALTHCARE NHS TRUST"]
["RYR","WESTERN SUSSEX HOSPITALS NHS TRUST"]
["RYV","CAMBRIDGESHIRE COMMUNITY SERVICES NHS TRUST"]
["RYW","BIRMINGHAM COMMUNITY HEALTHCARE NHS TRUST"]
["RYX","CENTRAL LONDON COMMUNITY HEALTHCARE NHS TRUST"]
["RYY","KENT COMMUNITY HEALTH NHS TRUST"]
["TAD","BRADFORD DISTRICT CARE TRUST"]
["TAE","MANCHESTER MENTAL HEALTH AND SOCIAL CARE TRUST"]
["TAF","CAMDEN AND ISLINGTON NHS FOUNDATION TRUST"]
["TAH","SHEFFIELD HEALTH AND SOCIAL CARE NHS FOUNDATION TRUST"]
["TAJ","BLACK COUNTRY PARTNERSHIP NHS FOUNDATION TRUST"]

{"sheet":"newAllo","index":8,"n_rows":140,"n_cols":43,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["Unique ID","Cost Cat. ","Resource Category","Resource Type","SUGGESTED COSTS FOR INCLUSION IN THIS CATEORY ","Allocation Method","weight","Score",null,0,null,null,null,null,"<Please Select>"]
["E01F01","DIRECT","Wards - nursing pay","Pay costs","Nursing costs","Nursing costs of individual ward allocated to service users based on the actual length of stay ( days) weighted by actual interventions received",1,"Gold standard",null,1,null,null,null,null,">>Multiple Allocation Methods (will reveal expanded section) ENTER COSTS AGAINST THE BELOW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resource Category"]
["E01F01","DIRECT","Wards - nursing pay","Pay costs","Nursing costs","Nursing costs of individual ward allocated to service users based on the actual length of stay ( days) weighted by actual observation level",0.5,"2nd level",null,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,null,null,null,null,"Wards - nursing pay","E01",null,"Pay costs","F01"]
["E01F01","DIRECT","Wards - nursing pay","Pay costs","Nursing costs","Nursing costs of individual ward allocated to service users based on the actual length of stay ( days) ",0.25,"Baseline",null,1,null,null,null,null,null,null,"Unique ID","Sub Row?","Cost Cat. ","Cost Pool Groups","Service","Resource Type",null,"Allocation Method Adopted \n(Please select methods BEFORE entering the respective costs)\n(Note: Can select \"Multiple Allocation Methods\" to reveal accommodating subsection)","Score for Allocation Method",null,null,null,null,null,null,null,null,null,null,null,null,null,"Wards - non pay and non nursing pay","E02",null,"Pay & non pay costs","F02"]
["E01F01","DIRECT","Wards - nursing pay","Pay costs","Nursing costs","Other (will be zero scored)",0,"Below baseline",null,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,null,null,null,null,"Medical staff (Consultants) - inpatients","E03",null,"Non pay costs","F03"]
["E12F02","DIRECT","Other clinical staff - inpatients","Pay & non pay costs","E.g. Psychology,psychotherapy, physiotherapy, occupational therapy pay and associated non pay costs. Do not include nursing or medical staff.","Cost of individual staff member allocated to service user based on actual time spent with that service user",1,"Gold standard",null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Procurement","E41"]
["E12F02","DIRECT","Other clinical staff - inpatients","Pay & non pay costs","E.g. Psychology,psychotherapy, physiotherapy, occupational therapy pay and associated non pay costs. Do not include nursing or medical staff.","Cost of psychology/psychotherapy team allocated to  service user based on actual length of stay (days)",0.25,"Baseline",null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consultancy costs for trust wide projects","E42"]
["E12F02","DIRECT","Other clinical staff - inpatients","Pay & non pay costs","E.g. Psychology,psychotherapy, physiotherapy, occupational therapy pay and associated non pay costs. Do not include nursing or medical staff.","Other (will be zero scored)",0,"Below baseline",null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HR","E43"]
["E02F02","DIRECT","Wards - Other pay and non nursing pay","Pay & non pay costs","e.g.  Other pay: admin & clerical.  Non pay:  staff uniform, towels, furniture & fittings, computer software, cleaning materials.","Actual length of stay (days) ",1,"Gold standard",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical staff (Consultants) - community","E04",null,"Drugs and drug dispensing costs ","F04"]
["E02F02","DIRECT","Wards - Other pay and non nursing pay","Pay & non pay costs","e.g.  Other pay: admin & clerical.  Non pay:  staff uniform, towels, furniture & fittings, computer software, cleaning materials.","Other (will be zero scored)",0,"Below baseline",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical staff (career grade Junior Doctors) - inpatients","E05",null,"inpatient stock drugs on wards","F05"]
["E03F02","DIRECT","Medical staff (Consultants) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Cost of individual consultant allocated to the service user based on actual time spent with that service user",1,"Gold standard",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical staff (career grade Junior Doctors) - community","E06",null,"prescribed drugs","F06"]
["E03F02","DIRECT","Medical staff (Consultants) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Cost of consultant team allocated to the service user based on actual length of stay (days)",0.25,"Baseline",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical staff ( Junior Doctors - Doctors in training) - inpatients","E07"]
["E03F02","DIRECT","Medical staff (Consultants) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Other (will be zero scored)",0,"Below baseline",null,3,{"$f":"LEN(F13)","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical staff ( Junior Doctors - Doctors in training) - community","E08"]
["E04F02","DIRECT","Medical staff (Consultants) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Cost of individual consultant allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin",1,"Gold standard",null,4,{"$f":"LEN(F14)","v":232},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Community teams - non clinical staff & non pay","E09"]
["E04F02","DIRECT","Medical staff (Consultants) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Cost of individual consultant allocated to actual care delivered to a service user based on duration of face to face contacts",0.9,"2nd level",null,4,125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All community clinical staff","E10"]
["E04F02","DIRECT","Medical staff (Consultants) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Costs per band of staff allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin  ",0.6,"3rd level",null,4,228,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day care","E11"]
["E04F02","DIRECT","Medical staff (Consultants) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Costs per band of staff allocated to actual care delivered to a service user based on duration of face to face contacts",0.5,"4th level",null,4,119,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Psychology & psychotherapy - inpatients","E12"]
["E04F02","DIRECT","Medical staff (Consultants) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Costs of all consultants in the multi disciplinary team allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin  ",0.35,"5th level",null,4,260,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special procedure suites (e.g. ECT, Section 136 suites)","E13"]
["E04F02","DIRECT","Medical staff (Consultants) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Costs of all consultants  in the multi disciplinary team allocated to actual care delivered to a service user based on duration of face to face contacts",0.25,"Baseline",null,4,152,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinical Support Functions - Blood","E14"]
["E04F02","DIRECT","Medical staff (Consultants) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - Consultants","Other (will be zero scored)",0,"Below baseline",null,4,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinical Support Functions - Imaging","E15"]
["E05F02","DIRECT","Medical staff (career grade Junior Doctors) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload","Cost of career grade junior doctor team allocated to the service user based on actual length of stay (days)",1,"Gold standard",null,5,107,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinical Support Functions - Other diagnostics","E16"]
["E05F02","DIRECT","Medical staff (career grade Junior Doctors) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload","Other (will be zero scored)",0,"Below baseline",null,5,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinical Support Functions - Pathology","E17"]
["E06F02","DIRECT","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants","Cost of individual career grade junior doctor allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin\n",1,"Gold standard",null,6,249,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drugs and drug dispensing - inpatients","E18"]
["E06F02","DIRECT","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants","Cost of individual career grade junior doctor allocated to actual care delivered to a service user based on duration of face to face contacts",0.9,"2nd level",null,6,141,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drugs and drug dispensing - community","E19"]
["E06F02","DIRECT","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants","Costs per band of staff allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin  ",0.6,"3rd level",null,6,228,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drugs and drug dispensing - stock drugs","E20"]
["E06F02","DIRECT","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants","Costs per band of staff allocated to actual care delivered to a service user based on duration of face to face contacts",0.5,"4th level",null,6,119,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drugs and drug dispensing - FP10s","E21"]
["E06F02","DIRECT","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants","Costs of all career grade junior doctors in multi disciplinary team allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin  ",0.35,"5th level",null,6,272,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other clinical costs","E22"]
["E06F02","DIRECT","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants","Costs of all career grade junior doctors in multi disciplinary team allocated to actual care delivered to a service user based on duration of face to face contacts",0.25,"Baseline",null,6,163,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secondary commissioning costs","E23"]
["E06F02","DIRECT","Medical staff (career grade Junior Doctors) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants","Other (will be zero scored)",0,"Below baseline",null,6,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital charges - equipment costs that can be allocated to clinical departments","E24"]
["E07F02","DIRECT","Medical staff ( Junior Doctors - Doctors in training) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars ","Total costs of doctors in training on individual ward allocated across all service users based on actual length of stay (days)",1,"Gold standard",null,7,126,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinical safety, quality, audit, CNST","E25"]
["E07F02","DIRECT","Medical staff ( Junior Doctors - Doctors in training) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars ","Total costs of doctors in training in team allocated across all service users based on actual length of stay (days)",0.25,"Baseline",null,7,{"$f":"LEN(F31)","v":115},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consultancy costs for a specific department or service","E26"]
["E07F02","DIRECT","Medical staff ( Junior Doctors - Doctors in training) - inpatients incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars ","Other (will be zero scored)",0,"Below baseline",null,7,{"$f":"LEN(F28)","v":163},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Divisional & operational management and admin","E27"]
["E08F02","DIRECT","Medical staff ( Junior Doctors - Doctors in training) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars ","Total costs of doctors in training in team allocated across all consultants in the team",1,"Gold standard",null,8,{"$f":"LEN(F29)","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linen","E28"]
["E08F02","DIRECT","Medical staff ( Junior Doctors - Doctors in training) - community incl Special Procedure Suites","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars ","Other (will be zero scored)",0,"Below baseline",null,8,126,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical records","E29"]
["E09F02","DIRECT","Community teams - non clinical staff & non pay","Pay & non pay costs","Non- clinical  staff pay and office costs.","All costs allocated to service users based on duration of face to face contacts",1,"Gold standard",null,9,115,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service user transport","E30"]
["E09F02","DIRECT","Community teams - non clinical staff & non pay","Pay & non pay costs","Non- clinical  staff pay and office costs.","Other (will be zero scored)",0,"Below baseline",null,9,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pharmacy services ","E31"]
["E10F02","DIRECT","All community clinical staff","Pay & non pay costs","Staff pay and staff travel costs - community staff","Cost of individual member of staff allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin\n",1,"Gold standard",null,10,87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service user catering","E32"]
["E10F02","DIRECT","All community clinical staff","Pay & non pay costs","Staff pay and staff travel costs - community staff","Cost of individual member of staff allocated to actual care delivered to a service user based on duration of face to face contacts",0.9,"2nd level",null,10,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corporate overheads - allocated on gross spend","E33"]
["E10F02","DIRECT","All community clinical staff","Pay & non pay costs","Staff pay and staff travel costs - community staff","Costs per band of staff type allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin  ",0.6,"3rd level",null,10,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corporate Overheads - allocated on floor space ","E34"]
["E10F02","DIRECT","All community clinical staff","Pay & non pay costs","Staff pay and staff travel costs - community staff","Costs per band of staff type allocated to actual care delivered to a service user based on duration of face to face contacts",0.5,"4th level",null,10,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Charges (equipment that cannot be allocated to a specific clinical department)","E35"]
["E10F02","DIRECT","All community clinical staff","Pay & non pay costs","Staff pay and staff travel costs - community staff","Costs of team allocated to actual care delivered to a service user based on duration of all activities undertaken to support a service user e.g. face to face contacts, travel, telephone calls, liaison, clinical admin  ",0.35,"5th level",null,10,238,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDC dividend","E36"]
["E10F02","DIRECT","All community clinical staff","Pay & non pay costs","Staff pay and staff travel costs - community staff","Costs of  team allocated to actual care delivered to a service user based on duration of face to face contacts",0.25,"Baseline",null,10,130,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PFI payments","E37"]
["E10F02","DIRECT","All community clinical staff","Pay & non pay costs","Staff pay and staff travel costs - community staff","Other (will be zero scored)",0,"Below baseline",null,10,233,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cleaning","E38"]
["E11F02","DIRECT","Day care","Pay & non pay costs","Day care services","Cost of day care service allocated to  service user based on actual time spent in the service",1,"Gold standard",null,11,124,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information Technology","E39"]
["E11F02","DIRECT","Day care","Pay & non pay costs","Day care services","Other (will be zero scored)",0,"Below baseline",null,11,218,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payroll","E40"]
["E13F03","DIRECT","Special procedure suites (e.g. ECT, Section 136 suites)","Pay & non pay costs","ECT, Section 136 suites","Costs allocated to service user receiving treatment in the SPS based on time spent by the service user in the SPS",1,"Gold standard",null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical Director and Medical Staff Management","E44"]
["E13F03","DIRECT","Special procedure suites (e.g. ECT, Section 136 suites)","Pay & non pay costs","ECT, Section 136 suites","Cost for SPS allocated across all service users being treated in each SPS",0.25,"Baseline",null,13]
["E13F03","DIRECT","Special procedure suites (e.g. ECT, Section 136 suites)","Pay & non pay costs","ECT, Section 136 suites","Other (will be zero scored)",0,"Below baseline",null,13]
["E14F02","DIRECT","Clinical Support Functions - Blood","Pay & non pay costs","Blood & blood products","Allocated to service user by individual weighted test (based on internal costing exercise of each test)",1,"Gold standard",null,14]
["E14F02","DIRECT","Clinical Support Functions - Blood","Pay & non pay costs","Blood & blood products","Individual tests allocated to service users with no weighting",0.25,"Baseline",null,14]
["E14F02","DIRECT","Clinical Support Functions - Blood","Pay & non pay costs","Blood & blood products","Other (will be zero scored)",0,"Below baseline",null,14]
["E15F02","DIRECT","Clinical Support Functions - Imaging","Pay & non pay costs","X-Ray, CT MRI, Other Radiology","Allocated to service user by individual weighted test (based on internal costing exercise of each test)",1,"Gold standard",null,15]
["E15F02","DIRECT","Clinical Support Functions - Imaging","Pay & non pay costs","X-Ray, CT MRI, Other Radiology","Individual tests allocated to service users with no weighting",0.25,"Baseline",null,15]
["E15F02","DIRECT","Clinical Support Functions - Imaging","Pay & non pay costs","X-Ray, CT MRI, Other Radiology","Other (will be zero scored)",0,"Below baseline",null,15]
["E16F02","DIRECT","Clinical Support Functions - Other diagnostics","Pay & non pay costs","ECGs, EEGs etc","Allocated to service user by individual weighted test (based on internal costing exercise of each test)",1,"Gold standard",null,16]
["E16F02","DIRECT","Clinical Support Functions - Other diagnostics","Pay & non pay costs","ECGs, EEGs etc","Individual tests allocated to service users with no weighting",0.25,"Baseline",null,16]
["E16F02","DIRECT","Clinical Support Functions - Other diagnostics","Pay & non pay costs","ECGs, EEGs etc","Other (will be zero scored)",0,"Below baseline",null,16]
["E17F02","DIRECT","Clinical Support Functions - Pathology","Pay & non pay costs","Pathology","Allocated to service user by individual weighted test (based on internal costing exercise of each test)",1,"Gold standard",null,17]
["E17F02","DIRECT","Clinical Support Functions - Pathology","Pay & non pay costs","Pathology","Individual tests allocated to service users with no weighting",0.25,"Baseline",null,17]
["E17F02","DIRECT","Clinical Support Functions - Pathology","Pay & non pay costs","Pathology","Other (will be zero scored)",0,"Below baseline",null,17]
["E18F04","DIRECT","Drugs and drug dispensing - inpatients","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for inpatients","Cost per individual script allocated to individual service user. Excluding ward drugs",1,"Gold standard",null,18]
["E18F04","DIRECT","Drugs and drug dispensing - inpatients","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for inpatients","Cost per ward apportioned to service users based on actual length of stay",0.25,"Baseline",null,18]
["E18F04","DIRECT","Drugs and drug dispensing - inpatients","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for inpatients","Other (will be zero scored)",0,"Below baseline",null,18]
["E19F04","DIRECT","Drugs and drug dispensing - community","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for community services","Cost per individual script allocated to individual service user",1,"Gold standard",null,19]
["E19F04","DIRECT","Drugs and drug dispensing - community","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for community services","Cost per team  apportioned to service users based on number of contacts",0.25,"Baseline",null,19]
["E19F04","DIRECT","Drugs and drug dispensing - community","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for community services","Other (will be zero scored)",0,"Below baseline",null,19]
["E20F05","DIRECT","Drugs and drug dispensing - stock drugs","inpatient stock drugs on wards","Stock drugs on a ward","Costs allocated to service user based on a standard cost by service user type",1,"Gold standard",null,20]
["E20F05","DIRECT","Drugs and drug dispensing - stock drugs","inpatient stock drugs on wards","Stock drugs on a ward","Costs allocated to service user based on actual length of stay (days)",0.25,"Baseline",null,20]
["E20F05","DIRECT","Drugs and drug dispensing - stock drugs","inpatient stock drugs on wards","Stock drugs on a ward","Other (will be zero scored)",0,"Below baseline",null,20]
["E21F06","DIRECT","Drugs and drug dispensing - FP10s","prescribed drugs","prescribed drugs","Costs allocated to individual service user",1,"Gold standard",null,21]
["E21F06","DIRECT","Drugs and drug dispensing - FP10s","prescribed drugs","prescribed drugs","Costs allocated to service user based on a standard cost by service user type",0.25,"Baseline",null,21]
["E21F06","DIRECT","Drugs and drug dispensing - FP10s","prescribed drugs","prescribed drugs","Other (will be zero scored)",0,"Below baseline",null,21]
["E22F02","DIRECT","Other clinical costs","Pay & non pay costs","Include social workers and other scientific and technical staff. ","Cost of member of staff allocated to the service user based on actual time spent with that service user",1,"Gold standard",null,22]
["E22F02","DIRECT","Other clinical costs","Pay & non pay costs","Include social workers and other scientific and technical staff. ","Costs of  team allocated to actual care delivered to a service user based on duration of face to face contacts",0.25,"Baseline",null,22]
["E22F02","DIRECT","Other clinical costs","Pay & non pay costs","Include social workers and other scientific and technical staff. ","Other (will be zero scored)",0,"Below baseline",null,22]
["E23F02","DIRECT","Secondary commissioning costs","Pay & non pay costs","Clinical  services that are subcontracted out, e.g. out of area placements","Costs of service allocated to service user in receipt of service",1,"Gold standard",null,23]
["E23F02","DIRECT","Secondary commissioning costs","Pay & non pay costs","Clinical  services that are subcontracted out, e.g. out of area placements","Other (will be zero scored)",0,"Below baseline",null,23]
["E24F03","INDIRECT","Capital charges - equipment costs that can be allocated to clinical departments","Non pay costs","Capital charges - Equipment depreciation, maintenance and interest","Costs allocated to service users based on actual usage",1,"Gold standard",null,24]
["E24F03","INDIRECT","Capital charges - equipment costs that can be allocated to clinical departments","Non pay costs","Capital charges - Equipment depreciation, maintenance and interest","Costs allocated to all services users  within specific service that use relevant equipment, based on actual length of stay (days) or duration of face to face contacts",0.25,"Baseline",null,24]
["E24F03","INDIRECT","Capital charges - equipment costs that can be allocated to clinical departments","Non pay costs","Capital charges - Equipment depreciation, maintenance and interest","Other (will be zero scored)",0,"Below baseline",null,24]
["E25F02","INDIRECT","Clinical safety, quality, audit, CNST","Pay & non pay costs","Clinical audit, governance and clinical risk ","Number of service users weighted by type of activities and likelihood of risk",1,"Gold standard",null,25]
["E25F02","INDIRECT","Clinical safety, quality, audit, CNST","Pay & non pay costs","Clinical audit, governance and clinical risk ","Costs allocated to all service users in specific services , based on clinical WTEs",0.25,"Baseline",null,25]
["E25F02","INDIRECT","Clinical safety, quality, audit, CNST","Pay & non pay costs","Clinical audit, governance and clinical risk ","Other (will be zero scored)",0,"Below baseline",null,25]
["E26F02","INDIRECT","Consultancy costs for a specific department or service","Pay & non pay costs","Consultancy costs for a specific department or service","Costs allocated to specific services to which they relate",1,"Gold standard",null,26]
["E26F02","INDIRECT","Consultancy costs for a specific department or service","Pay & non pay costs","Consultancy costs for a specific department or service","Other (will be zero scored)",0,"Below baseline",null,26]
["E27F02","INDIRECT","Divisional & operational management and admin","Pay & non pay costs","Operational and departmental managers. Also includes admin teams.","Allocated to services or specialties managed based on WTE / service user numbers or direct budget",1,"Gold standard",null,27]
["E27F02","INDIRECT","Divisional & operational management and admin","Pay & non pay costs","Operational and departmental managers. Also includes admin teams.","Actual cost allocated to services or specialties managed",0.25,"Baseline",null,27]
["E27F02","INDIRECT","Divisional & operational management and admin","Pay & non pay costs","Operational and departmental managers. Also includes admin teams.","Other (will be zero scored)",0,"Below baseline",null,27]
["E28F02","INDIRECT","Linen","Pay & non pay costs","General Linen Stores","Cost allocated based on actual length of stay (days)",1,"Gold standard",null,28]
["E28F02","INDIRECT","Linen","Pay & non pay costs","General Linen Stores","Other (will be zero scored)",0,"Below baseline",null,28]
["E29F02","INDIRECT","Medical records","Pay & non pay costs","Medical records department and library costs","Costs allocated based on number of service users",1,"Gold standard",null,29]
["E29F02","INDIRECT","Medical records","Pay & non pay costs","Medical records department and library costs","Other (will be zero scored)",0,"Below baseline",null,29]
["E30F02","INDIRECT","Service user transport","Pay & non pay costs","Ambulance costs, taxis, voluntary cars","Actual cost per  journey allocated to individual service users  or groups of service users",1,"Gold standard",null,30,null,null,null,null,null,null,null,null,"Unique ID","Cost Cat. ","Resource Type","SUGGESTED COSTS FOR INCLUSION IN THIS CATEORY "]
["E30F02","INDIRECT","Service user transport","Pay & non pay costs","Ambulance costs, taxis, voluntary cars","Standard cost per journey allocated to service users based team",0.75,"2nd level",null,30,null,null,null,null,null,null,null,null,"E01F01","DIRECT","Pay costs","Nursing costs"]
["E30F02","INDIRECT","Service user transport","Pay & non pay costs","Ambulance costs, taxis, voluntary cars","Costs allocated across service users using service user transport weighted by type of use",0.25,"Baseline",null,30,null,null,null,null,null,null,null,null,"E02F02","DIRECT","Pay & non pay costs","e.g. Non pay:  staff uniform, towels, furniture & fittings, computer software, cleaning materials. Other pay: admin & clerical. Exclude medical staffing."]
["E30F02","INDIRECT","Service user transport","Pay & non pay costs","Ambulance costs, taxis, voluntary cars","Other (will be zero scored)",0,"Below baseline",null,30,null,null,null,null,null,null,null,null,"E03F02","DIRECT","Pay & non pay costs","Staff pay and staff travel costs - Consultants"]
["E31F02","INDIRECT","Pharmacy services ","Pay & non pay costs","Clinical Pharmacy departmental costs pay and non pay","Number of drug issues by cost centre weighted based on advice from pharmacy department",1,"Gold standard",null,31,null,null,null,null,null,null,null,null,"E04F02","DIRECT","Pay & non pay costs","Staff pay and staff travel costs - Consultants"]
["E31F02","INDIRECT","Pharmacy services ","Pay & non pay costs","Clinical Pharmacy departmental costs pay and non pay","Number of drug issues by cost centre",0.25,"Baseline",null,31,null,null,null,null,null,null,null,null,"E06F02","DIRECT","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload e.g. Staff Grades, Specialty Doctors / Associate Specialists, Clinical Assistants"]
["E31F02","INDIRECT","Pharmacy services ","Pay & non pay costs","Clinical Pharmacy departmental costs pay and non pay","Other (will be zero scored)",0,"Below baseline",null,31,null,null,null,null,null,null,null,null,"E07F02","DIRECT","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars "]
["E32F02","INDIRECT","Service user catering","Pay & non pay costs","Catering on wards, not commercial canteens","Number of meals per service user",1,"Gold standard",null,32,null,null,null,null,null,null,null,null,"E08F02","DIRECT","Pay & non pay costs","Staff pay and staff travel costs - junior doctors without own clinical caseload e.g. F1, F2, Specialty Registrars "]
["E32F02","INDIRECT","Service user catering","Pay & non pay costs","Catering on wards, not commercial canteens","Number of meals supplied to each ward/service",0.75,"2nd level",null,32,null,null,null,null,null,null,null,null,"E09F02","DIRECT","Pay & non pay costs","Non- clinical  staff pay and office costs."]
["E32F02","INDIRECT","Service user catering","Pay & non pay costs","Catering on wards, not commercial canteens","Cost allocated based on actual length of stay (days)",0.25,"Baseline",null,32,null,null,null,null,null,null,null,null,"E11F02","DIRECT","Pay & non pay costs","Day care services"]
["E32F02","INDIRECT","Service user catering","Pay & non pay costs","Catering on wards, not commercial canteens","Other (will be zero scored)",0,"Below baseline",null,32,null,null,null,null,null,null,null,null,"E12F02","DIRECT","Pay & non pay costs","Psychologist and psychotherapist pay and associated non pay costs"]
["E33F02","OVERHEADS","Corporate overheads - allocated on gross spend","Pay & non pay costs","Board of directors expenditure, financial management, financial accounts, information management, costing teams, Legal costs, marketing, communications,  OD department including  central library, Business planning, strategic business cases, FT application, Interest payments, Marketing and public relations","Allocated across all cost centres based on gross expenditure",1,"Gold standard",null,33,null,null,null,null,null,null,null,null,"E14F02","DIRECT","Pay & non pay costs","Blood & blood products"]
["E33F02","OVERHEADS","Corporate overheads - allocated on gross spend","Pay & non pay costs","Board of directors expenditure, financial management, financial accounts, information management, costing teams, Legal costs, marketing, communications,  OD department including  central library, Business planning, strategic business cases, FT application, Interest payments, Marketing and public relations","Other (will be zero scored)",0,"Below baseline",null,33,null,null,null,null,null,null,null,null,"E17F02","DIRECT","Pay & non pay costs","Pathology"]
["E34F02","OVERHEADS","Corporate Overheads - allocated on floor space ","Pay & non pay costs","Insurance premiums, maintenance staff, property strategy costs,  dividend , interest depreciation on buildings, PFI unitary payments, gas, electricity, water, telecoms , switchboard equipment, rent and rates, hire of halls or rooms,  grounds and gardens, security, alarms , portering, logistics, distribution , general hotel services , fire safety , security","Floor area, weighted by additional factors where level of resource consumption varies e.g. Estates usually have a detailed list of rooms that are categorised into clinical, non clinical, corridors, plant room etc.  This could be used to weight costs appropriately",1,"Gold standard",null,34,null,null,null,null,null,null,null,null,"E25F02","INDIRECT","Pay & non pay costs","Clinical audit, governance and clinical risk "]
["E34F02","OVERHEADS","Corporate Overheads - allocated on floor space ","Pay & non pay costs","Insurance premiums, maintenance staff, property strategy costs,  dividend , interest depreciation on buildings, PFI unitary payments, gas, electricity, water, telecoms , switchboard equipment, rent and rates, hire of halls or rooms,  grounds and gardens, security, alarms , portering, logistics, distribution , general hotel services , fire safety , security","Floor area",0.25,"Baseline",null,34,null,null,null,null,null,null,null,null,"E26F02","INDIRECT","Pay & non pay costs","Consultancy costs for a specific department or service"]
["E34F02","OVERHEADS","Corporate Overheads - allocated on floor space ","Pay & non pay costs","Insurance premiums, maintenance staff, property strategy costs,  dividend , interest depreciation on buildings, PFI unitary payments, gas, electricity, water, telecoms , switchboard equipment, rent and rates, hire of halls or rooms,  grounds and gardens, security, alarms , portering, logistics, distribution , general hotel services , fire safety , security","Other (will be zero scored)",0,"Below baseline",null,34,null,null,null,null,null,null,null,null,"E29F02","INDIRECT","Pay & non pay costs","Medical records department and library costs"]
["E35F02","OVERHEADS","Capital Charges (equipment that cannot be allocated to a specific clinical department)","Non pay costs","Capital charges (equipment that cannot be allocated to a specific clinical department)","Allocated across all  relevant cost centres based on asset register",1,"Gold standard",null,35,null,null,null,null,null,null,null,null,"E30F02","INDIRECT","Pay & non pay costs","Ambulance costs, taxis, voluntary cars"]
["E35F02","OVERHEADS","Capital Charges (equipment that cannot be allocated to a specific clinical department)","Non pay costs","Capital charges (equipment that cannot be allocated to a specific clinical department)","Other (will be zero scored)",0,"Below baseline",null,35,null,null,null,null,null,null,null,null,"E31F02","INDIRECT","Pay & non pay costs","Clinical Pharmacy departmental costs pay and non pay"]
["E36F03","OVERHEADS","PDC dividend","Non pay costs","PDC dividend costs","Net Book value, split between equipment and buildings by cost centre reflecting additions / refurbishments in the year",1,"Gold standard",null,36,null,null,null,null,null,null,null,null,"E32F02","INDIRECT","Pay & non pay costs","Catering on wards, not commercial canteens"]
["E36F03","OVERHEADS","PDC dividend","Non pay costs","PDC dividend costs","Net Book value by cost centre",0.75,"2nd level",null,36,null,null,null,null,null,null,null,null,"E33F02","OVERHEADS","Pay & non pay costs","Board of directors expenditure, financial management, financial accounts, information management, costing teams, Legal costs, marketing, communications,  OD department including  central library, Business planning, strategic business cases, FT application, Interest payments, Marketing and public relations"]
["E36F03","OVERHEADS","PDC dividend","Non pay costs","PDC dividend costs","Depreciation by cost centre",0.25,"Baseline",null,36,null,null,null,null,null,null,null,null,"E34F02","OVERHEADS","Pay & non pay costs","Insurance premiums, maintenance staff, property strategy costs,  dividend , interest depreciation on buildings, PFI unitary payments, gas, electricity, water, telecoms , switchboard equipment, rent and rates, hire of halls or rooms,  grounds and gardens, security, alarms , portering, logistics, distribution , general hotel services , fire safety , security"]
["E36F03","OVERHEADS","PDC dividend","Non pay costs","PDC dividend costs","Other (will be zero scored)",0,"Below baseline",null,36,null,null,null,null,null,null,null,null,"E35F02","OVERHEADS","Pay & non pay costs","Capital charges (equipment that cannot be allocated to a specific clinical department)"]
["E37F02","OVERHEADS","PFI payments","Pay & non pay costs","PFI payments","Specific PFI building and or unit linked to relevant service user activity",1,"Gold standard",null,37,null,null,null,null,null,null,null,null,"E37F02","OVERHEADS","Pay & non pay costs","PFI payments"]
["E37F02","OVERHEADS","PFI payments","Pay & non pay costs","PFI payments","Floor area by cost centre or service  weighted by additional factors where level of resource consumption varies e.g. Estates usually have a detailed list of rooms that are categorised into clinical, non clinical, corridors, plant room etc.  This could be used to weight costs appropriately",0.25,"Baseline",null,37,null,null,null,null,null,null,null,null,"E38F02","OVERHEADS","Pay & non pay costs","Domestics staff and cleaning costs"]
["E37F02","OVERHEADS","PFI payments","Pay & non pay costs","PFI payments","Other (will be zero scored)",0,"Below baseline",null,37,null,null,null,null,null,null,null,null,"E39F02","OVERHEADS","Pay & non pay costs","Hardware / software, IT support and delivery, IMT contracts, PAS help desk, computer licences"]
["E38F02","OVERHEADS","Cleaning","Pay & non pay costs","Domestics staff and cleaning costs","Costs allocated based on requests for cleaning or cleaning rotas",1,"Gold standard",null,38,null,null,null,null,null,null,null,null,"E40F02","OVERHEADS","Pay & non pay costs","payroll costs / SLA"]
["E38F02","OVERHEADS","Cleaning","Pay & non pay costs","Domestics staff and cleaning costs","Floor area, weighted by additional factors where level of resource consumption varies e.g. more cleaning resources used in clinical areas than non clinical areas",0.75,"2nd level",null,38,null,"these are to cope with just one option",null,null,null,null,null,null,"E41F02","OVERHEADS","Pay & non pay costs","costs of procurement department or outsourced costs"]
["E38F02","OVERHEADS","Cleaning","Pay & non pay costs","Domestics staff and cleaning costs","Floor area by cost centre or service",0.25,"Baseline",null,38,null,null,null,null,null,null,null,null,"E43F02","OVERHEADS","Pay & non pay costs","Occupational health, HR management "]
["E38F02","OVERHEADS","Cleaning","Pay & non pay costs","Domestics staff and cleaning costs","Other (will be zero scored)",0,"Below baseline",null,38,null,null,null,null,null,null,null,null,"E44F02","OVERHEADS","Pay & non pay costs","Medical staff management and medical secretaries"]
["E39F02","OVERHEADS","Information Technology","Pay & non pay costs","Hardware / software, IT support and delivery, IMT contracts, PAS help desk, computer licences","Number of computer users or live ports recorded by ICT",1,"Gold standard",null,39,null,null,null,null,null,null,null,null,"E05F02","DIRECT","Pay & non pay costs","Staff pay and staff travel costs - junior doctors with clinical caseload"]
["E39F02","OVERHEADS","Information Technology","Pay & non pay costs","Hardware / software, IT support and delivery, IMT contracts, PAS help desk, computer licences","WTE by cost centres (service/team)",0.25,"Baseline",null,39,null,null,null,null,null,null,null,null,"E10F02","DIRECT","Pay & non pay costs","Staff pay and staff travel costs - community staff"]
["E39F02","OVERHEADS","Information Technology","Pay & non pay costs","Hardware / software, IT support and delivery, IMT contracts, PAS help desk, computer licences","Other (will be zero scored)",0,"Below baseline",null,39,null,null,null,null,null,null,null,null,"E13F03","DIRECT","Pay & non pay costs","ECT, Section 136 suites"]
["E40F02","OVERHEADS","Payroll","Pay & non pay costs","payroll costs / SLA","Headcount by cost centres",1,"Gold standard",null,40,null,null,null,null,null,null,null,null,"E15F02","DIRECT","Pay & non pay costs","X-Ray, CT MRI, Other Radiology"]
["E40F02","OVERHEADS","Payroll","Pay & non pay costs","payroll costs / SLA","Staff cost by cost centre",0.25,"Baseline",null,40,null,null,null,null,null,null,null,null,"E16F02","DIRECT","Pay & non pay costs","ECGs, EEGs etc"]
["E40F02","OVERHEADS","Payroll","Pay & non pay costs","payroll costs / SLA","Other (will be zero scored)",0,"Below baseline",null,40,null,null,null,null,null,null,null,null,"E18F04","DIRECT","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for inpatients"]
["E41F02","OVERHEADS","Procurement","Pay & non pay costs","costs of procurement department or outsourced costs","Number of orders by cost centre",1,"Gold standard",null,41,null,null,null,null,null,null,null,null,"E19F04","DIRECT","Drugs and drug dispensing costs ","Drugs and drug dispensing costs for community services"]
["E41F02","OVERHEADS","Procurement","Pay & non pay costs","costs of procurement department or outsourced costs","Value of orders by cost centre",0.25,"Baseline",null,41,null,null,null,null,null,null,null,null,"E20F05","DIRECT","inpatient stock drugs on wards","Stock drugs on a ward"]
["E41F02","OVERHEADS","Procurement","Pay & non pay costs","costs of procurement department or outsourced costs","Other (will be zero scored)",0,"Below baseline",null,41,null,null,null,null,null,null,null,null,"E21F06","DIRECT","prescribed drugs","prescribed drugs"]
["E42F02","OVERHEADS","Consultancy costs for trust wide projects","Pay & non pay costs","Consultancy costs for trust wide projects","Actual consultancy costs allocated to cost centres based on usage",1,"Gold standard",null,42,null,null,null,null,null,null,null,null,"E22F02","DIRECT","Pay & non pay costs","Include social workers and other scientific and technical staff. "]
["E42F02","OVERHEADS","Consultancy costs for trust wide projects","Pay & non pay costs","Consultancy costs for trust wide projects","Overhead based on trust expenditure",0.25,"Baseline",null,42,null,null,null,null,null,null,null,null,"E23F02","DIRECT","Pay & non pay costs","Clinical  services that are subcontracted out, e.g. out of area placements"]
["E42F02","OVERHEADS","Consultancy costs for trust wide projects","Pay & non pay costs","Consultancy costs for trust wide projects","Other (will be zero scored)",0,"Below baseline",null,42,null,null,null,null,null,null,null,null,"E24F03","INDIRECT","Non pay costs","Capital charges - Equipment depreciation, maintenance and interest"]
["E43F02","OVERHEADS","HR","Pay & non pay costs","Occupational health, HR management ","Headcount by cost centres",1,"Gold standard",null,43,null,null,null,null,null,null,null,null,"E27F02","INDIRECT","Pay & non pay costs","Operational and departmental managers. Group to suggest non pay items"]
["E43F02","OVERHEADS","HR","Pay & non pay costs","Occupational health, HR management ","Staff cost by cost centre",0.25,"Baseline",null,43,null,null,null,null,null,null,null,null,"E28F02","INDIRECT","Pay & non pay costs","General Linen Stores"]
["E43F02","OVERHEADS","HR","Pay & non pay costs","Occupational health, HR management ","Other (will be zero scored)",0,"Below baseline",null,43,null,null,null,null,null,null,null,null,"E36F03","OVERHEADS","Non pay costs","PDC dividend costs"]
["E44F02","OVERHEADS","Medical Director and Medical Staff Management","Pay & non pay costs","Medical staff management and medical secretaries","Actual support to medical staff",1,"Gold standard",null,44,null,null,null,null,null,null,null,null,"E42F02","OVERHEADS","Pay & non pay costs","Consultancy costs for trust wide projects"]
["E44F02","OVERHEADS","Medical Director and Medical Staff Management","Pay & non pay costs","Medical staff management and medical secretaries","Medical staff WTE/headcount by cost centre",0.75,"2nd level",null,44,null,null,null,null,null,null,null,null,"Grand Total"]
["E44F02","OVERHEADS","Medical Director and Medical Staff Management","Pay & non pay costs","Medical staff management and medical secretaries","Medical staff cost by cost centre",0.25,"Baseline",null,44]
["E44F02","OVERHEADS","Medical Director and Medical Staff Management","Pay & non pay costs","Medical staff management and medical secretaries","Other (will be zero scored)",0,"Below baseline",null,44]