{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","01_LastYear_PriorEst","02_LastYear_Actuals","03_ThisYear_Est"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":102,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[[29,6,30,9],[31,6,31,9],[32,6,32,9],[33,6,33,9],[35,6,36,9],[17,6,22,10],[25,6,25,10],[26,6,26,9],[27,6,27,9],[28,6,28,9]]}
[{"$f":"IF(VLOOKUP($B$2,Sheet_Table,Sheet_Visibility_ColX,FALSE),\"S\",\"H\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"H","H","H","H",null,null,"H"]
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),50)","v":"Instructions"}]
[]
[]
[]
[null,null,null,null,{"$f":"SSPR_1_Logo","v":{"$error":"#REF!"}}]
[]
[]
[null,"EC",null,null,null,null,null,null,null,null,null,"Required","Completed","Poss Error","Error Check"]
[null,null,null,null,null,null,"Version 1: DefCARS Copy/Paste template"]
["H"]
["H"]
["H"]
["H"]
[null,null,null,null,null,"Report Overview"]
[]
[]
[null,null,null,null,null,null,"This template is intended to facilitate easier entry of data into the DefCARS system, for cost data required in the Qualifying Business Unit Actual and Estimated Cost Analysis Reports (from here on known as the QBUCAR). \n\nUsers can fill in the cost data in the following tabs, and then copy and paste this into the DefCARS website when prompted. This enables users to construct their cost breakdown externally before importing into the system, and  avoids having to enter data one cell at a time.\n\nThe template allows users to enter data up to six decimal places, which is the maximum number that the database will accept. If a user enters a value to more than six decimal places, the template will round to six, and this will be pasted into DefCARS."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Instructions"]
[]
[null,null,null,null,null,null,"1.   Fill in the required cost breakdown tables in the following three tabs."]
[null,null,null,null,null,null,"2.   In the cost breakdown table, select any white cell within the main data entry section of the sheet, e.g. the Direct Labour and Indirect Prodn Cost column."]
[null,null,null,null,null,null,"3.   Press CTRL + A. This will select the entire set of figures from the sheet."]
[null,null,null,null,null,null,"4.   Press CTRL + C. This will copy the selected data."]
[null,null,null,null,null,null,"5.   Within the DefCARS system, navigate to the page you are trying to import the data into (either the Last Year Prior Estimates, Last Year Actuals, or \n      This Year Estimates pages within the QBUCAR."]
[]
[null,null,null,null,null,null,"6.   Click on the Paste Data from Excel button at the top of this page. A pop-up box will appear, with a data entry box for you to copy and paste your data into."]
[null,null,null,null,null,null,"7.   Click inside the data entry box, and then press CTRL + V to paste the data."]
[null,null,null,null,null,null,"8.   Click OK. The data should then be transferred into the equivalent cells in the DefCARS system."]
[]
[null,null,null,null,null,null,"The system will check the validity of the pasted data before overwriting the entire data entry form on this page. If the pasted data has too many, or too few, rows or columns it will be rejected."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["H"]

{"sheet":"01_LastYear_PriorEst","index":1,"n_rows":65,"n_cols":37,"rows_kept":65,"cut":false,"hidden":false,"merged":[[11,9,11,12],[58,25,58,33],[8,39,10,39],[6,32,6,34],[10,16,10,26],[10,29,10,30],[10,31,10,33],[15,6,15,8],[16,6,16,8],[17,6,17,8],[56,9,56,12],[58,13,58,22],[59,13,59,22],[59,25,59,33],[62,13,62,22],[62,25,62,33],[64,9,64,34],[60,13,60,22],[60,25,60,33],[61,13,61,22],[61,25,61,33]]}
[{"$f":"IF(VLOOKUP($B$2,Sheet_Table,Sheet_Visibility_ColX,FALSE),\"S\",\"H\")","v":{"$error":"#REF!"}}]
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),50)","v":"01_LastYear_PriorEst"}]
[]
[]
[]
[null,null,null,null,{"$f":"SSPR_1_Logo","v":{"$error":"#REF!"}},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,null,null,null,{"$f":"SUP_1_EntityNameAsTitle","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Business Unit Cost Analysis Report - Developer Mode",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,"Input Cells - Yellow"]
[null,null,null,null,null,null,"HOME"]
[null,null,null,null,null,null,"Last Year Prior Estimate"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,"Functional Analysis Of Direct Labour and Indirect Production Cost",null,null,null,null,null,null,null,null,null,null,null,null,"Adjustments",null,"Recovery Method"]
[null,null,null,null,null,null,null,null,null,"£'000s",null,null,null,"Profit before interest and  tax","Adjustments (Revenue, inventory, non labour direct costs)","Direct Labour and Indirect Prodn Cost","Production","Design","Engineering","Site Services","Procurement","Sales","Finance","HR","IT","Legal/ Contractual","BU \"HQ\" / Other","TOTAL\n(per ref \"3\")","Check Diff","Remove disallowed Costs","Adjust for net timing differences","Allowed costs to be recovered this year","Remove costs recovered direct from BU / Contracts","Recovered Through Rates","Cross ref for Expl Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DR & (CR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Negative)","+ve or -ve","Calculated","(Negative)","Calculated"]
[]
[null,null,null,null,null,null,"Revenue & Stock Changes",null,null,"Sales Revenue",null,null,null,null,{"$f":"0-N16","v":0},{"$f":"SUM(N16:O16)","v":0}]
[null,null,null,null,null,null,null,null,null,"Net movement on total inventory (inc. RM, WIP, FG)",null,null,null,null,{"$f":"0-N17","v":0},0]
[null,null,null,null,null,null,null,null,null,"Purchases of direct materials",null,null,null,null,{"$f":"0-N18","v":0},0]
[null,null,null,null,null,null,"01 - People / Payroll",null,null,"Main Payroll",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q19:AA19)","v":0},{"$f":"ROUND(P19-AB19,0)","v":0},null,null,{"$f":"AB19+SUM(AD19:AE19)","v":0},null,{"$f":"AF19+AG19","v":0}]
[null,null,null,null,null,null,"",null,null,"Pensions",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Bonuses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Redundancy Costs",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Contractors / Short term labour hire",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Social Security",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"People & Payroll - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"02 - Plant, Machinery, Equipment and Other Consumables",null,null,"Hire of Plant / Machinery",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Purchase of Minor Tools / Equipment",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Repairs & Maintenance - Equipment",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Consumable Materials",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Production - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"03 - Premises",null,null,"Utilities",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Repairs & Maintenance - Buildings / Premises",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Rent & Rates",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Cleaning & Waste Disposal",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Premises - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"04 - Selling & Marketing",null,null,"Advertising, Promotions, Entertaining & Events",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Transport, carriage and packing - goods out",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Selling and Marketing - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"05 - General & Admin",null,null,"Travel & Subsistence",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Communications",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Insurance",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"IT licences, supplies & consumables",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Professional Fees (Audit, Legal, Consulting, etc.)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Vehicles",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Training Expenses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Admin - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"06 - Other",null,null,"Depreciation & Amortisation",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Financial Income & Expenses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Bad Debts",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Group Charges",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Capitalised Opex (enter as negative)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Inventory Losses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Asset related gains / losses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Outsourced Services",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N16:N54)","v":0},{"$f":"SUM(O16:O54)","v":0},{"$f":"SUM(P16:P54)","v":0},{"$f":"SUM(Q19:Q54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Cross Ref for Explanatory Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Explanatory Notes",1,"Here is my explanation of the row or column I have labelled with a 1",null,null,null,null,null,null,null,null,null,null,6,"Here is my explanation of the row or column I have labelled with a 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"Here is my explanation of the row or column I have labelled with a 2",null,null,null,null,null,null,null,null,null,null,7,"Here is my explanation of the row or column I have labelled with a 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Here is my explanation of the row or column I have labelled with a 3",null,null,null,null,null,null,null,null,null,null,8,"Here is my explanation of the row or column I have labelled with a 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Here is my explanation of the row or column I have labelled with a 4",null,null,null,null,null,null,null,null,null,null,9,"Here is my explanation of the row or column I have labelled with a 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Here is my explanation of the row or column I have labelled with a 5",null,null,null,null,null,null,null,null,null,null,10,"Here is my explanation of the row or column I have labelled with a 10"]
[]
[null,null,null,null,null,null,"Other General Comments"]

{"sheet":"02_LastYear_Actuals","index":2,"n_rows":65,"n_cols":37,"rows_kept":65,"cut":false,"hidden":false,"merged":[[62,13,62,22],[62,25,62,33],[64,9,64,34],[60,13,60,22],[60,25,60,33],[61,13,61,22],[61,25,61,33],[56,9,56,12],[58,13,58,22],[58,25,58,33],[59,13,59,22],[59,25,59,33],[15,6,15,8],[16,6,16,8],[17,6,17,8],[6,32,6,34],[10,16,10,26],[10,29,10,30],[10,31,10,33],[11,9,11,12]]}
[{"$f":"IF(VLOOKUP($B$2,Sheet_Table,Sheet_Visibility_ColX,FALSE),\"S\",\"H\")","v":{"$error":"#REF!"}}]
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),50)","v":"02_LastYear_Actuals"}]
[]
[]
[]
[null,null,null,null,"SINGLE SOURCE PROCUREMENT FRAMEWORK",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,null,null,null,{"$f":"SUP_1_EntityNameAsTitle","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Business Unit Cost Analysis Report - Developer Mode",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,"Input Cells - Yellow"]
[null,null,null,null,null,null,"HOME"]
[null,null,null,null,null,null,"Last Year Actual"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,"Functional Analysis Of Direct Labour and Indirect Production Cost",null,null,null,null,null,null,null,null,null,null,null,null,"Adjustments",null,"Recovery Method"]
[null,null,null,null,null,null,null,null,null,"£'000s",null,null,null,"Profit before interest and  tax","Adjustments (Revenue, inventory, non labour direct costs)","Direct Labour and Indirect Prodn Cost","Production","Design","Engineering","Site Services","Procurement","Sales","Finance","HR","IT","Legal/ Contractual","BU \"HQ\" / Other","TOTAL\n(per ref \"3\")","Check Diff","Remove disallowed Costs","Adjust for net timing differences","Allowed costs to be recovered this year","Remove costs recovered direct from BU / Contracts","Recovered Through Rates","Cross ref for Expl Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DR & (CR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Negative)","+ve or -ve","Calculated","(Negative)","Calculated"]
[]
[null,null,null,null,null,null,"Revenue & Stock Changes",null,null,"Sales Revenue",null,null,null,null,{"$f":"0-N16","v":0},{"$f":"SUM(N16:O16)","v":0}]
[null,null,null,null,null,null,null,null,null,"Net movement on total inventory (inc. RM, WIP, FG)",null,null,null,null,{"$f":"0-N17","v":0},0]
[null,null,null,null,null,null,null,null,null,"Purchases of direct materials",null,null,null,null,{"$f":"0-N18","v":0},0]
[null,null,null,null,null,null,"01 - People / Payroll",null,null,"Main Payroll",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q19:AA19)","v":0},{"$f":"ROUND(P19-AB19,0)","v":0},null,null,{"$f":"AB19+SUM(AD19:AE19)","v":0},null,{"$f":"AF19+AG19","v":0}]
[null,null,null,null,null,null,"",null,null,"Pensions",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Bonuses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Redundancy Costs",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Contractors / Short term labour hire",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Social Security",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"People & Payroll - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"02 - Plant, Machinery, Equipment and Other Consumables",null,null,"Hire of Plant / Machinery",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Purchase of Minor Tools / Equipment",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Repairs & Maintenance - Equipment",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Consumable Materials",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Production - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"03 - Premises",null,null,"Utilities",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Repairs & Maintenance - Buildings / Premises",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Rent & Rates",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Cleaning & Waste Disposal",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Premises - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"04 - Selling & Marketing",null,null,"Advertising, Promotions, Entertaining & Events",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Transport, carriage and packing - goods out",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Selling and Marketing - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"05 - General & Admin",null,null,"Travel & Subsistence",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Communications",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Insurance",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"IT licences, supplies & consumables",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Professional Fees (Audit, Legal, Consulting, etc.)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Vehicles",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Training Expenses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Admin - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"06 - Other",null,null,"Depreciation & Amortisation",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Financial Income & Expenses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Bad Debts",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Group Charges",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Capitalised Opex (enter as negative)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Inventory Losses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Asset related gains / losses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Outsourced Services",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N16:N54)","v":0},{"$f":"SUM(O16:O54)","v":0},{"$f":"SUM(P16:P54)","v":0},{"$f":"SUM(Q19:Q54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Cross Ref for Explanatory Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Explanatory Notes",1,"Here is my explanation of the row or column I have labelled with a 1",null,null,null,null,null,null,null,null,null,null,6,"Here is my explanation of the row or column I have labelled with a 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"Here is my explanation of the row or column I have labelled with a 2",null,null,null,null,null,null,null,null,null,null,7,"Here is my explanation of the row or column I have labelled with a 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Here is my explanation of the row or column I have labelled with a 3",null,null,null,null,null,null,null,null,null,null,8,"Here is my explanation of the row or column I have labelled with a 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Here is my explanation of the row or column I have labelled with a 4",null,null,null,null,null,null,null,null,null,null,9,"Here is my explanation of the row or column I have labelled with a 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Here is my explanation of the row or column I have labelled with a 5",null,null,null,null,null,null,null,null,null,null,10,"Here is my explanation of the row or column I have labelled with a 10"]
[]
[null,null,null,null,null,null,"Other General Comments"]

{"sheet":"03_ThisYear_Est","index":3,"n_rows":65,"n_cols":37,"rows_kept":65,"cut":false,"hidden":false,"merged":[[11,9,11,12],[15,6,15,8],[59,13,59,22],[59,25,59,33],[6,32,6,34],[10,16,10,26],[10,29,10,30],[10,31,10,33],[16,6,16,8],[17,6,17,8],[56,9,56,12],[58,13,58,22],[58,25,58,33],[62,13,62,22],[62,25,62,33],[64,9,64,34],[60,13,60,22],[60,25,60,33],[61,13,61,22],[61,25,61,33]]}
[{"$f":"IF(VLOOKUP($B$2,Sheet_Table,Sheet_Visibility_ColX,FALSE),\"S\",\"H\")","v":{"$error":"#REF!"}}]
[null,{"$f":"MID(CELL(\"filename\",A1),1+FIND(\"]\",CELL(\"filename\",A1)),50)","v":"03_ThisYear_Est"}]
[]
[]
[]
[null,null,null,null,"SINGLE SOURCE PROCUREMENT FRAMEWORK",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,null,null,null,{"$f":"SUP_1_EntityNameAsTitle","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Business Unit Cost Analysis Report - Developer Mode",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,"Input Cells - Yellow"]
[null,null,null,null,null,null,"HOME"]
[null,null,null,null,null,null,"This Year Estimate"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,"Functional Analysis Of Direct Labour and Indirect Production Cost",null,null,null,null,null,null,null,null,null,null,null,null,"Adjustments",null,"Recovery Method"]
[null,null,null,null,null,null,null,null,null,"£'000s",null,null,null,"Profit before interest and  tax","Adjustments (Revenue, inventory, non labour direct costs)","Direct Labour and Indirect Prodn Cost","Production","Design","Engineering","Site Services","Procurement","Sales","Finance","HR","IT","Legal/ Contractual","BU \"HQ\" / Other","TOTAL\n(per ref \"3\")","Check Diff","Remove disallowed Costs","Adjust for net timing differences","Allowed costs to be recovered this year","Remove costs recovered direct from BU / Contracts","Recovered Through Rates","Cross ref for Expl Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DR & (CR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Negative)","+ve or -ve","Calculated","(Negative)","Calculated"]
[]
[null,null,null,null,null,null,"Revenue & Stock Changes",null,null,"Sales Revenue",null,null,null,null,{"$f":"0-N16","v":0},{"$f":"SUM(N16:O16)","v":0}]
[null,null,null,null,null,null,null,null,null,"Net movement on total inventory (inc. RM, WIP, FG)",null,null,null,null,{"$f":"0-N17","v":0},0]
[null,null,null,null,null,null,null,null,null,"Purchases of direct materials",null,null,null,null,{"$f":"0-N18","v":0},0]
[null,null,null,null,null,null,"01 - People / Payroll",null,null,"Main Payroll",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q19:AA19)","v":0},{"$f":"ROUND(P19-AB19,0)","v":0},null,null,{"$f":"AB19+SUM(AD19:AE19)","v":0},null,{"$f":"AF19+AG19","v":0}]
[null,null,null,null,null,null,"",null,null,"Pensions",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Bonuses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Redundancy Costs",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Contractors / Short term labour hire",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Social Security",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"People & Payroll - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"02 - Plant, Machinery, Equipment and Other Consumables",null,null,"Hire of Plant / Machinery",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Purchase of Minor Tools / Equipment",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Repairs & Maintenance - Equipment",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Consumable Materials",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Production - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"03 - Premises",null,null,"Utilities",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Repairs & Maintenance - Buildings / Premises",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Rent & Rates",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Cleaning & Waste Disposal",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Premises - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"04 - Selling & Marketing",null,null,"Advertising, Promotions, Entertaining & Events",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Transport, carriage and packing - goods out",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Selling and Marketing - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"05 - General & Admin",null,null,"Travel & Subsistence",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Communications",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Insurance",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"IT licences, supplies & consumables",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Professional Fees (Audit, Legal, Consulting, etc.)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Vehicles",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Training Expenses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Admin - Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"06 - Other",null,null,"Depreciation & Amortisation",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Financial Income & Expenses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Bad Debts",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Group Charges",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Capitalised Opex (enter as negative)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Inventory Losses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Asset related gains / losses",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,"",null,null,"Outsourced Services",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N16:N54)","v":0},{"$f":"SUM(O16:O54)","v":0},{"$f":"SUM(P16:P54)","v":0},{"$f":"SUM(Q19:Q54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Cross Ref for Explanatory Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Explanatory Notes",1,"Here is my explanation of the row or column I have labelled with a 1",null,null,null,null,null,null,null,null,null,null,6,"Here is my explanation of the row or column I have labelled with a 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"Here is my explanation of the row or column I have labelled with a 2",null,null,null,null,null,null,null,null,null,null,7,"Here is my explanation of the row or column I have labelled with a 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Here is my explanation of the row or column I have labelled with a 3",null,null,null,null,null,null,null,null,null,null,8,"Here is my explanation of the row or column I have labelled with a 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Here is my explanation of the row or column I have labelled with a 4",null,null,null,null,null,null,null,null,null,null,9,"Here is my explanation of the row or column I have labelled with a 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Here is my explanation of the row or column I have labelled with a 5",null,null,null,null,null,null,null,null,null,null,10,"Here is my explanation of the row or column I have labelled with a 10"]
[]
[null,null,null,null,null,null,"Other General Comments"]