{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["CoverPage","Instructions","Contents","UserGuideExample","VersionControlLog","BoA-DL","Inputs>>","iInputExample","Calcs>>","cCalcExample","Output>>","oSummaryExample","Templates>>","TimeTemp","BlankTemp","Admin>>","SysConfig","SysTime"],"not_rendered":{"charts":2,"images":12,"macros":1,"external_links":0,"defined_names":40,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"CoverPage","index":0,"reason":"not_a_worksheet"}],"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":1,"n_rows":430,"n_cols":8,"rows_kept":430,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"Instructions Sheet"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"}]
[null,null,{"$f":"HYPERLINK(\"#''Contents''!A1\",sysChkWord)","v":"All Checks OK"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"}]
[]
[{"$f":"SUM(A9:A426)","v":0},{"$f":"SUM(B9:B426)","v":0}]
[null,null,"This Template will need to be customised to produce a Should Cost Model - completing this Template provides no guarantee of model quality (including outputs)."]
[null,null,null,"1 Introduction"]
[]
[null,null,null,null,"1.1 The Outsourcing Playbook, Construction Playbook and SCM Requirements"]
[]
[null,null,null,null,"Overview"]
[null,null,null,null,null,null,"The requirement to produce a Should Cost Model (SCM) when making sourcing decisions and contracting outside suppliers for the delivery of public services is set out within the Sourcing Playbook (see Chapter 3) and for public works projects or programmes within the Construction Playbook (see Chapter 5)."]
[]
[null,null,null,null,null,null,"The Sourcing and Construction Playbooks set out when contracting authorities should produce an SCM, which functions are responsible for them (see Ownership, Knowledge, Understanding and Awareness framework), and how SCMs fit within the procurement lifecycle. The accompanying SCM Guidance Note provides high-level guidance on SCMs. It is part of a set of Cabinet Office guidance relating to SCMs:"]
[]
[null,null,null,null,null,null,"·            SCM Guidance Note - outlines what SCMs are, when and why contracting authorities should produce them, and key considerations around developing and/or procuring them;"]
[null,null,null,null,null,null,"·            SCM Development Guidance  - provides contracting authorities with guidance on using internal resources to design, develop, test and manage SCMs; and"]
[null,null,null,null,null,null,"·            SCM Technical Build Guidance - the guidance in this publication is based on good practice principles for building SCMs. It is technical in nature and aimed at people who will be building SCMs."]
[]
[null,null,null,null,null,null,"A number of practical Tools and Templates have also been produced by Cabinet Office to support the development of SCMs and to help reinforce good practice approaches. "]
[]
[null,null,null,null,null,null,"You should consult the Cabinet Office Sourcing Programme for further information or before planning an SCM for complex services, projects or programmes via sourcing.programme@cabinetoffice.gov.uk."]
[]
[null,null,null,null,"Reference Documents"]
[null,null,null,null,null,null,"- The Sourcing Playbook"]
[null,null,null,null,null,null,"- The Construction Playbook"]
[null,null,null,null,null,null,"- Should Cost Modelling Guidance Note"]
[null,null,null,null,null,null,"- SCM Development Guidance"]
[null,null,null,null,null,null,"- SCM Technical Build Guidance"]
[]
[null,null,null,null,"1.2 The Should Cost Model Build Template"]
[]
[null,null,null,null,null,null,"This Should Cost Model Build Template (\"the Template\" or \"this Template\") forms part of a suite of Templates and Tools produced by the Sourcing Programme to support the development of SCMs and help reinforce good practice."]
[null,null,null,null,null,null,"This Template is designed to speed up model development, drive consistency and reinforce governance & control."]
[null,null,null,null,null,null,"This Template is not a complete or generic SCM and will need to be customised to produce an SCM. "]
[null,null,null,null,null,null,"This Template includes examples of an Input sheet ('iInputExample'), a Calculation sheet ('cCalcExample') and an Output sheet ('oSummaryExample'). These sheets are for illustrative purposes only and show how a model could be laid out."]
[null,null,null,null,null,null,"The illustrative example sheets ('iInputExample', 'cCalcExample' and 'oSummaryExample') should be deleted when the SCM is developed."]
[]
[null,null,null,null,null,null,"It is recommended that the users of this Template familiarise themselves with these instructions (in particular the Section on Errors and Warnings) and the SCM Technical Build Guidance before commencing an SCM build. The SCM Technical Build Guidance sets out good practice principles for the design and technical construction of SCMs. "]
[]
[null,null,null,"2 Template Overview"]
[]
[null,null,null,null,"2.1 What is included in this 'Instructions' Sheet"]
[]
[null,null,null,null,null,null,"This 'Instructions' sheet details how to use this Template and covers the following:"]
[null,null,null,null,null,null,"- Arrangement of Template (Section 2.2)"]
[null,null,null,null,null,null,"- Details on use of VBA (Section 2.3)"]
[null,null,null,null,null,null,"- Steps on how to customise the Template (Section 3)"]
[null,null,null,null,null,null,"- Model Development Principles (Section 4)"]
[null,null,null,null,null,null,"- Errors and Warnings (Section 5)"]
[null,null,null,null,null,null,"- Excel 'How To' Guide (Section 6)"]
[]
[null,null,null,null,"2.2 Arrangement of Template"]
[]
[null,null,null,null,"Sections within the Template"]
[null,null,null,null,null,null,"This Template is split into the following Sections:"]
[null,null,null,null,null,null,"- Administrative sheets - these are coloured Grey."]
[null,null,null,null,null,null,"- Input sheets - these are coloured Pale Yellow and prefaced with an 'i'. They contain only inputs to the model. They are to be devoid of any form of calculations that form part of the model’s overall logic."]
[null,null,null,null,null,null,"- Calculation sheets – these are coloured Green and prefaced with a 'c'. They contain only calculations and no inputs other than formulas that ‘call-up’ the inputs to perform calculations on them."]
[null,null,null,null,null,null,"- Output sheets – these are coloured Dark Blue and prefaced with an 'o'. They contain links or ‘call-ups’ to calculations or inputs in order to display outputs. They may also include graphs or charts. They should not contain inputs or calculations (other than basic summary calculations)."]
[null,null,null,null,null,null,"- Template sheets - these are coloured in Light Blue and are used as a basis for creating other worksheets in this Template."]
[]
[null,null,null,null,null,null,"Section Break sheets (denoted with a \">>\" such as 'Inputs>>' etc.) are used to highlight where different Sections of the model begin."]
[null,null,null,null,null,null,"Please see the Technical Build Guidance for further details on model structure."]
[null,null,null,null,null,null,"Further details on this Template’s sheet naming conventions are included below (Section 3.4)."]
[]
[null,null,null,null,"Illustrative Examples"]
[null,null,null,null,null,null,"Illustrative examples of an Input sheet ('iInputExample'), a Calculation sheet ('cCalcExample') and an Output sheet ('oSummaryExample') are included within this Template."]
[null,null,null,null,null,null,"The illustrative example sheets include call outs sign posting key features of the sheets."]
[null,null,null,null,null,null,"These sheets are to be deleted prior to finalisation of any SCM built using this Template."]
[]
[null,null,null,null,"Cell Styles"]
[null,null,null,null,null,null,"Cell styles are used to help denote the types of cells within the Template (e.g. input cells are yellow in colour and have a border around them). There are styles for inputs, links, calculations and outputs. The full set of styles, including details of how to apply them, can be found in the 'UserGuideExample' sheet within this Template."]
[null,null,null,null,null,null,"Please see the Technical Build Guidance for further details on use of cell styles."]
[]
[null,null,null,null,"Error Check Network"]
[null,null,null,null,null,null,"It is good practice to include error checks within a model and to incorporate them into a network. See Technical Build Guidance for further details."]
[null,null,null,null,null,null,"Each sheet within this template has an Error Check Network (columns A and B). Cells A8 and B8 at the top of each sheet summarise the error checks and warnings for the entire sheet."]
[null,null,null,null,null,null,"The Template has a built-in Master Error Check which summaries the individual worksheet checks. This is located on the ''Contents'' sheet."]
[null,null,null,null,null,null,"When new sheets are added / sheets are deleted from the Template, the Master Error Check on the ''Contents'' sheet will need to be updated manually."]
[null,null,null,null,null,null,"The Master Error Check is displayed at the top of each worksheet in the Template. It will show \"All Checks OK\" if no Errors or Warnings are flagged otherwise it will display how many Errors/Alerts exist in the Template."]
[null,null,null,null,null,null,"Further details on Errors and Warnings can be found in the \"Errors and Warnings\" Section below.","Errors and Warnings"]
[]
[null,null,null,null,null,null,"It is recommended that users of this Template familiarise themselves with it, including it's instructions and its associated styles before proceeding with customisation and SCM development."]
[]
[null,null,null,null,"2.3 Use of VBA"]
[]
[null,null,null,null,null,null,"This Template makes use of VBA (macros) for the following:"]
[null,null,null,null,null,null,"- Version Control Log (see 'VersionControlLog' sheet)"]
[null,null,null,null,null,null,"- Generating a list of Named Ranges (see 'SysConfig' sheet)"]
[]
[null,null,null,null,null,null,"VBA (macros) will need to be enabled for these to work (see Section 6 for details), although users of this Template will not be required to update or modify the VBA in order to use the Template as intended."]
[null,null,null,null,null,null,"If the VBA is compromised or cannot be run the automated aspects of this Template will need to be performed manually by the user."]
[]
[null,null,null,"3 Template Customisation"]
[]
[null,null,null,null,"3.1 Customisation steps"]
[]
[null,null,null,null,null,null,"The following 17 Steps should be taken when customising this Template and developing an SCM. Where relevant, further details of these steps are included in the following Sections of this guidance and hyperlinked on the right hand side. Links to other relevant sheets are also included in the table below:"]
[]
[null,null,null,null,null,"#","Step","Further Details"]
[null,null,null,null,null,1,"Read this 'Instructions' sheet, gain familiarity with the content and structure of this Template, and look through the illustrative example input, calculation and output sheets."]
[null,null,null,null,null,2,"Complete the 'General Details' Section on the 'SysConfig' sheet, including the Project Name, IMA Score, Protective Marking etc.","General Details"]
[null,null,null,null,null,3,"Determine the Model 'Start date' and update the current start date (01-Apr-21) in the 'Setup' Section on the 'SysConfig' sheet with the new start date.","Start Date"]
[null,null,null,null,null,4,"Customise the model Timelines (see below for further details).","Customise Timelines"]
[null,null,null,null,null,5,"Customise the 'TimeTemp' Template worksheet (see below for further details).","Customise TimeTemp"]
[null,null,null,null,null,6,"Setup the input sheets needed (see below for further details on adding new sheets and sheet naming conventions).","Adding New Sheets"]
[null,null,null,null,null,7,"Setup the calculation sheets needed (see below for further details on adding new sheets and sheet naming conventions).","Adding New Sheets"]
[null,null,null,null,null,8,"Setup the output sheets needed (see below for further details on adding new sheets and sheet naming conventions).","Adding New Sheets"]
[null,null,null,null,null,9,"Update the ''Contents'' sheet, including the Master Error Check (see below for further details).","Updating the Contents Sheet"]
[null,null,null,null,null,10,"Update the Model Map on the ''Contents'' sheet to reflect the worksheets and data flows within the SCM (see section 3.5 below).","Updating the Contents Sheet"]
[null,null,null,null,null,11,"Develop the model in-line with good practice (see Technical Build Guidance) and the principles set out in Section 4 below.","Section 4"]
[null,null,null,null,null,12,"Prior to finalising the model, delete the following sheets (see below for further details):","Deleting Worksheets"]
[null,null,null,null,null,null,"- Instructions (this sheet)"]
[null,null,null,null,null,null,"- iInputExample"]
[null,null,null,null,null,null,"- cCalcExample"]
[null,null,null,null,null,null,"- oSummaryExample"]
[null,null,null,null,null,null,"- Templates>>"]
[null,null,null,null,null,null,"- TimeTemp"]
[null,null,null,null,null,null,"- BlankTemp"]
[null,null,null,null,null,13,"Update the ''Contents'' sheet, including the Master Error Check (see below for further details) and Model Map.","Updating the Contents Sheet"]
[null,null,null,null,null,14,"Check that the ''Contents'' sheet includes all relevant sheets.","Contents sheet"]
[null,null,null,null,null,15,"Check that the Master Error Check on the ''Contents'' sheet is correctly linked to the sheet-level error checks on each sheet.","Contents sheet"]
[null,null,null,null,null,16,"Update the Version Control Log to reflect the current version of the SCM - see 'VersionControlLog' sheet for more details.","VersionControlLog Sheet"]
[null,null,null,null,null,17,"Update the 'UserGuideExample' sheet as required (see below for further details).","Updating the User Guide Sheet"]
[]
[null,null,null,null,"3.2 Step 4 - Customising the model Timelines"]
[]
[null,null,null,null,"Guiding principles"]
[null,null,null,null,null,null,"SCMs should use a consistent timeline across all sheets that include a timeline (see Technical Build Guidance for further details). This means that:"]
[null,null,null,null,null,null,"1)      The timeline periods should be in consistent columns on every sheet (e.g. Column AA = 01Apr21:30Apr21)."]
[null,null,null,null,null,null,"2)      The timeline placement should be consistent on every sheet (e.g. Rows 2:7 on every sheet)."]
[null,null,null,null,null,null,"3)      An SCM should have a ‘master’ timeline (e.g. 'SysTime' sheet) that all other timelines in the workbook are linked to. This is so that the timeline is only ever updated in one place (the master) and all other timelines that link to it automatically replicate it."]
[]
[null,null,null,null,"Template Timelines"]
[null,null,null,null,null,null,"This Template has been configured to include a Monthly and an Annual timeline."]
[null,null,null,null,null,null,"Note, if a timeline other than Monthly or Annual (such as a daily, weekly or a 4-4-5 week timeline) is needed, the existing timeline on the 'SysTime' sheet will need to be redeveloped."]
[null,null,null,null,null,null,"The timeline in 'SysTime' is formula based and can be extended by copying existing formulae across the timeline."]
[]
[null,null,null,null,"Current Timeline Set Up - 'SysTime' Sheet"]
[null,null,null,null,null,null,"The Timelines are contained on the 'SysTime' sheet in rows 2 to 7."]
[null,null,null,null,null,null,"The monthly timeline starts in column AA and covers 36 periods (3 years)."]
[null,null,null,null,null,null,"The annual timeline starts in column BL and covers 3 periods (3 years)."]
[null,null,null,null,null,null,"The timeline start date is currently set to 01/04/2021 (It can be changed in Cell F22 on the 'SysConfig' sheet).","Start Date"]
[]
[null,null,null,null,"Customising the master Timeline (on the 'SysTime' sheet)"]
[null,null,null,null,null,null,"The master timeline should be customised on the 'SysTime' sheet."]
[]
[null,null,null,null,null,null,"When customising this Template determine if:"]
[null,null,null,null,null,null,"A) Both an Annual and Monthly timeline are required in the model;"]
[null,null,null,null,null,null,"B) Only an Annual timeline is required in the model;"]
[null,null,null,null,null,null,"C) Only a Monthly timeline is required in the model;"]
[null,null,null,null,null,null,"D) Another combination or granularity of timeline is required."]
[]
[null,null,null,null,null,null,"A) Both an Annual and Monthly timeline is required in the model"]
[null,null,null,null,null,null,"The Template is currently set up to include both a monthly and an annual timeline."]
[null,null,null,null,null,null,"Check the timelines cover the required number of periods (currently set up for 36 monthly periods and 3 annual periods)."]
[null,null,null,null,null,null,"If more/less periods are required, these can be added/deleted by inserting/removing columns in the timeline and copying the formula across to maintain a consistent formula across the full timeline."]
[null,null,null,null,null,null,"Make sure both the monthly and annual timelines are extended to match the same number of periods (e.g. if the annual timeline is 4 years, 48 months are included in the monthly timeline)."]
[null,null,null,null,null,null,"Columns to the right of the timeline can be hidden."]
[]
[null,null,null,null,null,null,"B) Only an Annual timeline is required in the model"]
[null,null,null,null,null,null,"The Template is currently set up to include both a monthly and an annual timeline."]
[null,null,null,null,null,null,"Delete the columns of the monthly timeline so that the Annual Timeline starts in column AA."]
[null,null,null,null,null,null,"If more/less periods are required, these can be added/deleted by inserting/removing columns in the timeline and copying the formula across to maintain a consistent formula across the full timeline."]
[null,null,null,null,null,null,"Columns to the right of the timeline can be hidden."]
[]
[null,null,null,null,null,null,"C) Only a Monthly timeline is required in the model"]
[null,null,null,null,null,null,"The Template is currently set up to include both a monthly and an annual timeline."]
[null,null,null,null,null,null,"Delete the columns of the Annual timeline. The Monthly Timeline should start in column AA."]
[null,null,null,null,null,null,"If more/less periods are required, these can be added/deleted by inserting/removing additional columns in the timeline and copying the formula across to maintain a consistent formula across the full timeline."]
[null,null,null,null,null,null,"Columns to the right of the timeline can be hidden."]
[]
[null,null,null,null,null,null,"D) Another combination or granularity of timeline is required in the model"]
[null,null,null,null,null,null,"In these instances the timeline(s) will need to be configured manually."]
[null,null,null,null,null,null,"The timelines should be set up as required, and entered within rows 2 to 7 of the 'SysTime' Sheet."]
[null,null,null,null,null,null,"Columns to the right of the timeline can be hidden."]
[]
[null,null,null,null,null,null,"It is important to confirm the 'TimeTemp' sheet accurately reflects the timeline(s) required before proceeding further with SCM development as this TimeTemp sheet may be duplicated multiple times (see Section 3.3 and 3.4)."]
[]
[null,null,null,null,"3.3 Step 5 - Customising the 'TimeTemp' sheet"]
[]
[null,null,null,null,null,null,"Once the timeline(s) has been configured on the 'SysTime' sheet (see Step 4 for further details), the timeline(s) should be linked to the 'TimeTemp' sheet."]
[null,null,null,null,null,null,"Rows 2 to 7 from column Z onwards on the 'TimeTemp' sheet should be linked to Rows 2 to 7 from column Z onwards on the 'SysTime' sheet. The number of columns that will need to be linked will depend on the number of periods in the timeline on the 'SysTime' sheet."]
[null,null,null,null,null,null,"An illustration of timeline linking can be seen in the 'TimeTemp' sheet - the timeline on this sheet links to master timeline on the ‘SysTime’ sheet. The master timeline is currently set up in monthly and annual format and covers a three year (36 month) period."]
[]
[null,null,null,null,null,null,"It is important to confirm the 'TimeTemp' sheet accurately reflects the timeline(s) required before proceeding further with SCM development."]
[]
[null,null,null,null,"3.4 Steps 6-8 - Adding New Sheets"]
[]
[null,null,null,null,"Guiding Principles"]
[null,null,null,null,null,null,"All Input, Calculation and Output sheets should be set up by copying one of the Template sheets."]
[null,null,null,null,null,null,"This will help to ensure that the Model is consistent."]
[null,null,null,null,null,null,"All timebound sheets (ones which include the model timeline(s)) should be based on the 'TimeTemp' sheet."]
[null,null,null,null,null,null,"Sheets which are not timebound should be based on the 'BlankTemp' sheet."]
[]
[null,null,null,null,"Sheet Naming Conventions"]
[null,null,null,null,null,null,"Sheet names should be descriptive but kept as short as possible."]
[null,null,null,null,null,null,"Sheet names should not contain spaces in the name (e.g. use 'iStaffInputs' or iStaff_Inputs' rather than 'i Staff Inputs')."]
[null,null,null,null,null,null,"Include a \">>\" in the name of a Section break sheet."]
[null,null,null,null,null,null,"Input sheets should be prefaced with an 'i' e.g. 'iStaff'."]
[null,null,null,null,null,null,"Calculation sheets should be prefaced with an 'c' e.g. 'cStaff'."]
[null,null,null,null,null,null,"Output sheets should be prefaced with an 'o' e.g. 'oDashboard'."]
[]
[null,null,null,null,"How to Add a Sheet"]
[null,null,null,null,null,null,"Right click the mouse on the tab name of either of the Template sheets and select \"Move or Copy…\""]
[null,null,null,null,null,null,"The \"Move or Copy\" dialog box will appear and the user should select the required Template sheet to copy and tick the \"Create a copy\" check box at the bottom of the dialog box."]
[null,null,null,null,null,null,"An illustration of this can be seen to the right of these instructions."]
[null,null,null,null,null,null,"Once the sheet has been copied it should be dragged to the correct location in the model, renamed and the tab colour updated depending on whether it is an Input, Calculation or Output sheet."]
[null,null,null,null,null,null,"To rename a sheet right click on the sheet and click 'Rename'. See above for good practice guidance on Sheet Naming Conventions."]
[null,null,null,null,null,null,"To change the Colour of a sheet, right click on the tab and hover over the 'Tab Color' selection and choose the appropriate colour (e.g. yellow for Input sheets)."]
[null,null,null,null,null,null,"After adding a new sheet the Contents (inc. Master Error Check) will need to be updated (see Section below for further details)."]
[]
[null,null,null,null,"3.5 Step 9 and 13 - Updating the Contents Sheet"]
[]
[null,null,null,null,null,null,"The ''Contents'' sheet should be updated to reflect the sheets contained within this template after customisation/during SCM development."]
[null,null,null,null,null,null,"This should be done whenever a new sheet is created (by copying a Template sheet), a sheet is deleted or renamed and if the order of sheets is changed."]
[null,null,null,null,null,null,"When updating the ''Contents'' sheet, insert/delete rows as required, above the \"INSERT NEW ROWS ABOVE THIS ROW\" banner and link columns H and I to the error/warning checks on the sheet (cells A8 and B8)."]
[null,null,null,null,null,null,"Update the hyperlink in column F with a hyperlink the relevant sheet."]
[null,null,null,null,null,null,"There is a Section to include a Model Map on the ''Contents'' sheet. This shows the flow of the model and how different sheets interact."]
[null,null,null,null,null,null,"To add new sheets to the model map, copy one of the existing sheet objects and rename the shape, change the colour as required and update the shape hyperlink to the correct sheet. The Hyperlink is updated by right clicking on the shape."]
[null,null,null,null,null,null,"Note, in order for the Hyperlinks back to the ''Contents'' sheet to remain functional, the ''Contents'' sheet should not be renamed. If the ''Contents'' sheet is renamed, the hyperlinks back to it in other sheets will need to be updated (see 'Click for Contents' in cell C6 at the top of each sheet)."]
[]
[null,null,null,null,"3.6 Step 17 - Updating the User Guide"]
[]
[null,null,null,null,null,null,"Not all Models require a User Guide. The requirement for a User Guide, including its breadth and depth of coverage, should be agreed as part of model scoping."]
[null,null,null,null,null,null,"If an in-model User Guide is required, this should be developed and included on the 'UserGuideExample' sheet within this Template."]
[null,null,null,null,null,null,"When completing the User Guide consider moving some of the content of this 'Instructions' sheet to the 'UserGuideExample' sheet before this sheet is deleted."]
[]
[null,null,null,"4 Model Development"]
[]
[null,null,null,null,"Guiding Principles"]
[null,null,null,null,null,null,"A consistent approach should be followed when developing models and SCM guidance should be adhered to."]
[null,null,null,null,null,null,"Refer to the Technical Build Guidance for full details."]
[]
[null,null,null,null,null,null,"Below are some 'Key Principles' to consider when developing an SCM:"]
[]
[null,null,null,null,"Use of Cell Styles"]
[null,null,null,null,null,null,"A guide to the Cell Styles that are set up and used within this Template is included on the 'UserGuideExample' sheet."]
[null,null,null,null,null,null,"Appropriate cell styles should be applied and used as the SCM is developed. This will help to reduce the risk of errors during model development and use, and help to ensure consistency."]
[]
[null,null,null,null,"Updating the Contents Page"]
[null,null,null,null,null,null,"The Contents Page should be updated whenever a new sheet is created, a sheet is deleted or renamed, and if the order of sheets is changed (see Section 3.5 for further details)."]
[]
[null,null,null,null,"Named Ranges"]
[null,null,null,null,null,null,"It is encouraged to limit the use of 'Named Ranges' where possible, although it is recognised their use will be required."]
[null,null,null,null,null,null,"When using 'Named Ranges' it is advised to keep a record of these in the 'SysConfig' sheet under the 'Named Ranges List' Section."]
[null,null,null,null,null,null,"This Template includes a VBA Macro that can be used to automatically update the Named Ranges List on the 'SysConfig' sheet."]
[null,null,null,null,null,null,"This VBA Macro can be run by clicking the 'Update Named Range List' button on the 'SysConfig' sheet."]
[null,null,null,null,null,null,"It is recommended to run this macro each time new Named Ranges are added to the model."]
[null,null,null,null,null,null,"It is recommended to include a red dotted line around Named Ranges so that it is clear where they exist - see style guide on the 'UserGuideExample' sheet for more details."]
[null,null,null,null,null,null,"Further details on the use of Named Ranges, including naming conventions, is available in the Technical Build Guidance."]
[]
[null,null,null,null,"Hiding Columns/Rows"]
[null,null,null,null,null,null,"Only Columns/Rows outside the used range of a worksheet should be hidden."]
[null,null,null,null,null,null,"If other Rows/Columns are not required to be viewed they should be grouped and collapsed (see Section 6 for further details)."]
[]
[null,null,null,"5 Errors and Warnings"]
[]
[null,null,null,null,"Overview"]
[null,null,null,null,null,null,"This Template has a built in Error Check Network which is summarised in the ''Contents'' sheet."]
[null,null,null,null,null,null,"At the top of each worksheet in this Template is the Master Error Check - it will show \"All Checks OK\" if no Errors or Warnings are breached, otherwise it will display how many Errors/Warnings exist in the Template."]
[null,null,null,null,null,null,"Each worksheet in the Template contains an Errors column (Column A) and a Warnings column (Column B)."]
[null,null,null,null,null,null,"Errors and Warnings are summarised in each sheet in cell A8 and B8 (by summing the cells in Column A and B respectively to the end of the sheet)."]
[null,null,null,null,null,null,"If Error or Warning Columns sum to zero it means there are no errors/warnings present on that sheet. Where Error or Warning Columns sum to any number other than zero the Template will alert this to the user."]
[null,null,null,null,null,null,"Only formulae returning whole positive numbers should be used in these columns (e.g. returning a 1 to show an error). Allowing negative values could mask errors (e.g. +1 -1 = 0)."]
[null,null,null,null,null,null,"It is important that the sums in cells A8 and B8 on each sheet are always extended to the end of the worksheet (to the \"END OF WORKSHEET - INSERT ROWS ABOVE\" banner)."]
[null,null,null,null,null,null,"No other calculations other than error checks or warning checks should be performed in columns A or B on any sheet."]
[null,null,null,null,null,null,"The ''Contents'' sheet summarises all errors and warnings in the workbook by linking to cell A8 and B8 on each sheet."]
[null,null,null,null,null,null,"The total number of errors and warnings are summarised in the 'Master Error Check' on the ''Contents'' sheet, which sums the number of errors and warnings from each sheet."]
[null,null,null,null,null,null,"It is critical the Error Check network is preserved, and therefore the ''Contents'' sheet is updated for all new sheets added to the Template."]
[null,null,null,null,null,null,"During Model development and Model review it should be checked that the Error Check network is functioning correctly and is linked to all required sheets within the Model."]
[]
[null,null,null,null,"Error Checks"]
[null,null,null,null,null,null,"Error checks can be used in a number of ways including, but not limited to the following:"]
[null,null,null,null,null,null,"- Checking Sum Totals match to other sources of the same data (e.g. the sum of a Total Staff Costs on a calculation sheet equals the same total on an Output sheet)"]
[null,null,null,null,null,null,"- Checking Inputs have been populated as required"]
[null,null,null,null,null,null,"- Checking % input splits total to 100%"]
[]
[null,null,null,null,null,null,"Error checks are formulas designed to return a zero if the error check is 'OK', or a positive number (either 1 or the number of errors) if the check has failed."]
[null,null,null,null,null,null,"In order to include the Error check in the Master Error Check, the results of individual error checks should be summarised in Column A of the worksheet."]
[null,null,null,null,null,null,"An Example of this can be seen below:"]
[]
[]
[]
[null,null,null,null,null,null,"Error checks should be formatted using the in-built 'Check' style within this template for consistency and to make the presence of errors more overt to model users."]
[null,null,null,null,null,null,"To apply the 'Check' style, select the cell, click the Home menu followed by Cell Styles, and click the 'Check' style from the displayed styles."]
[]
[null,null,null,null,null,null,"A small (e.g. 0.001) Error Tolerance can be included in error checks so that errors are not inappropriately flagged."]
[null,null,null,null,null,null,"One way to do this is to use the following error check formulae. In the following example the formulae would be comparing value \"A\" to value \"B\", but in principle \"A\" and \"B\" may themselves also be calculations:"]
[null,null,null,null,null,null,"=IF(ABS(A-B)<eTol,0,1)"]
[null,null,null,null,null,null,"eTol is the error tolerance level set up (as a Named Range) within this Template and can be amended in the \"SysConfig\" sheet."]
[null,null,null,null,null,null,"Using the above formula, provided the difference between the two numbers being compared (A and B) is less than the eTol threshold then no error will be flagged."]
[null,null,null,null,null,null,"An example of this formula in use can be seen on the \"oSummaryExample\" sheet."]
[]
[null,null,null,null,"Warnings"]
[null,null,null,null,null,null,"Warnings are used to notify the user of potential points of interest (e.g. a certain threshold is exceeded). These will require further investigation but may not be actual errors. For example, a Warning could be set up to notify the user if a cost line was above or below a certain threshold."]
[null,null,null,null,null,null,"In contrast to an error check, if a warning is breached, this does not signify there is anything incorrect with the model, rather that certain conditions are met."]
[null,null,null,null,null,null,"Warnings should be set up using the same principles as error checks, although they should use the \"Warning\" cell style."]
[null,null,null,null,null,null,"Warnings should be summed to Column B within the Model."]
[]
[null,null,null,null,"Where Errors/Warnings Exist"]
[null,null,null,null,null,null,"Where error checks are flagged this could signify that something is either not calculating correctly in the Model, not all data has been included in calculations correctly or that inputs have been erroneously entered into the model."]
[null,null,null,null,null,null,"Additionally, the Master Control Check in the ''Contents'' sheet is formatted such that if there are #REF, #VALUE or #N/A errors in column H/I of the ''Contents'' sheet an error/warning will be flagged."]
[null,null,null,null,null,null,"This would signify that a #REF, #VALUE or #N/A error is present in the checks on one or more of the underlying sheets in this Template."]
[null,null,null,null,null,null,"Where errors exist these should be investigated and resolved before continuing with model development."]
[null,null,null,null,null,null,"Where warnings exist these should be investigated to ensure the user is aware of the reasons for the warnings."]
[]
[null,null,null,"6 Excel How to Guide"]
[]
[null,null,null,null,"Adding New Rows to Worksheets"]
[null,null,null,null,null,null,"If new rows are required in any worksheet, these should be added above the \"END OF WORKSHEET - INSERT ROWS ABOVE\" banner and not below. This is important so to preserve the error check network within the Model."]
[null,null,null,null,null,null,"To add new rows:"]
[null,null,null,null,null,null,"a) Select the row where new rows are to be added by left-clicking the corresponding row number on the left-hand side of the sheet. To select more than one row hold down the left mouse button whilst dragging the mouse down or up. Note that the number of new rows that will be inserted corresponds with the number of rows that are selected."]
[null,null,null,null,null,null,"b) After selecting the row (or rows), right-click the row number of the selected row (or one of the rows within the selection) and click 'Insert' from the pop-up menu. Note that the new row or rows will be inserted above the selected row or rows."]
[null,null,null,null,null,null,"See screen shot below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Deleting Rows from Worksheets"]
[null,null,null,null,null,null,"To delete rows:"]
[null,null,null,null,null,null,"a) Select the row to be deleted by left-clicking the corresponding row number on the left-hand side of the sheet. To select more than one row hold down the left mouse button whilst dragging the mouse down or up."]
[null,null,null,null,null,null,"b) After selecting the row (or rows), right-click the row number of the selected row (or one of the rows within the selection) and click 'Delete' from the pop-up menu. "]
[null,null,null,null,null,null,"See Screen shot above."]
[]
[null,null,null,null,"Adding New Columns to Worksheets"]
[null,null,null,null,null,null,"To add new columns, follow the same steps as adding new rows but select the column letter from the top of the window instead of the row number. Note that new columns are inserted to the left of the selection."]
[]
[null,null,null,null,"Deleting Columns from Worksheets"]
[null,null,null,null,null,null,"To delete columns, follow the same steps as deleting rows but select the column letter from the top of the window instead of the row number."]
[]
[null,null,null,null,"Deleting Worksheets"]
[null,null,null,null,null,null,"To delete worksheets from the workbook:"]
[null,null,null,null,null,null,"a) Left-click the tab displaying the name of the sheet at the bottom of the window. Note that multiple sheets can be selected by holding down the Ctrl or Shift keys before left-clicking."]
[null,null,null,null,null,null,"b) Right-click the selected sheet name (or one of the sheet names in the selection) and click 'Delete' from the pop-up menu."]
[null,null,null,null,null,null,"Note, this is irreversible so it is advised to save a new version of the workbook before deleting a sheet."]
[null,null,null,null,null,null,"See screen shot below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Protecting cells"]
[null,null,null,null,null,null,"To protect cells select the cells that require protecting, right-click one of the cells in the selection and select \"Format Cells...' from the pop-up menu. This will open the 'Format Cells' window."]
[null,null,null,null,null,null,"From the Format Cells window select the Protection tab, then check the 'Locked' box and click the 'OK' button to apply the change and close the 'Format Cells' window."]
[null,null,null,null,null,null,"Note: The Cell Styles embedded within this Template (e.g. the 'Check' style) have been set up with cell protection turned on - the exception being Input cell styles that are unprotected (see UserGuideExample). "]
[null,null,null,null,null,null,"Note: Cell protection will only be applied after worksheet protection has been applied. If worksheet protection is not applied cells will not be protected (see below for protecting worksheets)."]
[]
[null,null,null,null,"Protecting worksheets"]
[null,null,null,null,null,null,"To protect worksheets right-click on the tab displaying the name of the sheet at the bottom of the window and click 'Protect Sheet' from the pop-up menu."]
[null,null,null,null,null,null,"A number of different options will appear (as illustrated in the screen shot below) as well as the option to input a password (leave blank to protect the sheet without a password)."]
[null,null,null,null,null,null,"Under the default settings for the styles set up in this Template, if sheets are protected only the input cells will be able to be changed."]
[null,null,null,null,null,null,"See the 'UserGuideExample' sheet for details on cell styles and which cell styles are locked under a protected sheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Grouping Rows/Columns"]
[null,null,null,null,null,null,"To Group Rows/Columns:"]
[null,null,null,null,null,null,"a) Select the rows/columns that require grouping (as described above for deleting rows/columns)"]
[null,null,null,null,null,null,"b) Navigate to and select \"Group\" from the \"Data\" menu in the Ribbon"]
[null,null,null,null,null,null,"c) Click 'Group'"]
[]
[null,null,null,null,"Hiding Rows/Columns"]
[null,null,null,null,null,null,"To hide Rows/Columns:"]
[null,null,null,null,null,null,"a) Select the rows/columns tat require hiding (as described above for deleting rows/columns)"]
[null,null,null,null,null,null,"b) Right Click and click 'Hide'"]
[null,null,null,null,null,null,"Note, only Rows/Columns outside of the used range of the sheet should be hidden."]
[]
[null,null,null,null,"Unhiding Rows/Columns"]
[null,null,null,null,null,null,"To hide Rows/Columns:"]
[null,null,null,null,null,null,"a) Select the rows/columns either side of the rows/columns that require unhiding"]
[null,null,null,null,null,null,"b) Right Click and click 'Unhide'"]
[null,null,null,null,null,null,"Note, if the rows/columns hidden are the at bottom of the sheet / at the right of the sheet, select the last row/column and drag the mouse down/right and then right click and unhide."]
[]
[null,null,null,null,"Expanding/Collapsing Grouped Rows/Columns"]
[null,null,null,null,null,null,"Grouped Rows/Columns can be expanded/collapsed by click the '+/-' sign as illustrated below:"]
[]
[]
[]
[]
[]
[null,null,null,null,"Enabling VBA (macros)"]
[null,null,null,null,null,null,"1. Click the File tab."]
[null,null,null,null,null,null,"2. Click Options."]
[null,null,null,null,null,null,"3. Click Trust Centre, and then click Trust Centre Settings."]
[null,null,null,null,null,null,"4. In the Trust Centre, click Macro Settings."]
[null,null,null,null,null,null,"5. Check Trust access to the VBA project object model to enable access to Visual Basic Projects."]
[null,null,null,null,null,null,"6. Click OK."]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Contents","index":2,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"Contents Sheet"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"}]
[]
[]
[{"$f":"SUM(A9:A61)","v":0},{"$f":"SUM(B9:B61)","v":0}]
[]
[null,null,null,"Contents"]
[]
[null,null,null,null,"Worksheet","Link","Sheet Description","Errors","Warnings"]
[null,null,null,null,"Instructions","Link","This sheet provides instructions on how to use this this Template - to be deleted prior to finalising the model",{"$f":"Instructions!A8","v":0},{"$f":"Instructions!B8","v":0}]
[null,null,null,null,"Contents","Link","Contents sheet listing all worksheets in model, listing error checks and containing model map",{"$f":"A8","v":0},{"$f":"B8","v":0}]
[null,null,null,null,"UserGuideExample","Link","Template User Guide - to be updated as development progresses",{"$f":"UserGuideExample!A8","v":0},{"$f":"UserGuideExample!B8","v":0}]
[null,null,null,null,"VersionControlLog","Link","Template Version Control Log to keep a record of changes",{"$f":"VersionControlLog!A8","v":0},{"$f":"VersionControlLog!B8","v":0}]
[null,null,null,null,"BoA-DL","Link","Example Book of Assumptions / Data Log sheet",{"$f":"'BoA-DL'!A8","v":0},{"$f":"'BoA-DL'!B8","v":0}]
[null,null,null,null,"iInputExample","Link","Illustrative example of an input sheet - to be deleted prior to finalising the model",{"$f":"iInputExample!A8","v":0},{"$f":"iInputExample!B8","v":0}]
[null,null,null,null,"cCalcExample","Link","Illustrative example of an calculation sheet - to be deleted prior to finalising the model",{"$f":"cCalcExample!A8","v":0},{"$f":"cCalcExample!B8","v":0}]
[null,null,null,null,"oSummaryExample","Link","Illustrative example of an output sheet - to be deleted prior to finalising the model",{"$f":"oSummaryExample!A8","v":0},{"$f":"oSummaryExample!B8","v":0}]
[null,null,null,null,"TimeTemp","Link","Template sheet including timeline - to be copied as a basis for setting up new worksheets",{"$f":"TimeTemp!A8","v":0},{"$f":"TimeTemp!B8","v":0}]
[null,null,null,null,"BlankTemp","Link","Template sheet without timeline - to be copied as a basis for setting up new worksheets",{"$f":"BlankTemp!A8","v":0},{"$f":"BlankTemp!B8","v":0}]
[null,null,null,null,"SysConfig","Link","Model setup sheet including lists, named ranges and constants",{"$f":"SysConfig!A8","v":0},{"$f":"SysConfig!B8","v":0}]
[null,null,null,null,"SysTime","Link","The model timeline is generated on this sheet",{"$f":"SysTime!A8","v":0},{"$f":"SysTime!B8","v":0}]
[null,null,null,null,"INSERT NEW ROWS ABOVE THIS ROW"]
[]
[null,null,null,null,"Master Control Check",null,"Update the Contents and Error Check summaries when new sheets are added/existing sheets are deleted",{"$f":"IFERROR(SUM(H12:H25),1)","v":0},{"$f":"IFERROR(SUM(I12:I25),1)","v":0}]
[]
[null,null,null,"Model Map"]
[]
[null,null,null,null,"The map below indicates the flow between worksheets within the Model"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"UserGuideExample","index":3,"n_rows":233,"n_cols":9,"rows_kept":233,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"UserGuideExample Sheet"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"}]
[]
[{"$f":"SUM(A9:A233)","v":0},{"$f":"SUM(B9:B233)","v":0}]
[]
[null,null,null,"1 Overview"]
[]
[null,null,null,null,"This sheet forms the User Guide for this model. It includes details of:"]
[null,null,null,null,"- General Details"]
[null,null,null,null,"- Model Overview"]
[null,null,null,null,"- Model Style Guide"]
[null,null,null,null,"- Use of Columns"]
[null,null,null,null,"- Definitions"]
[null,null,null,null,"This sheet should be updated as required throughout the model development process and may require customisation depending on what is included within the model"]
[null,null,null,null,"An example structure, with illustrative content in [square brackets] is detailed below"]
[]
[null,null,null,"2 General Details"]
[]
[null,null,null,null,"Model Developer:",{"$f":"SysConfig!F15","v":"TBC - update on 'SysConfig' sheet"}]
[null,null,null,null,"Contact Details:",{"$f":"SysConfig!F16","v":"sourcing.programme@cabinetoffice.gov.uk"}]
[null,null,null,null,"Model SRO:",{"$f":"SysConfig!F17","v":"TBC - update on 'SysConfig' sheet"}]
[]
[null,null,null,null,"Model Description:","This section should include a brief description of the model and it's purpose"]
[null,null,null,null,"Model Limitations:","This section should include a description of the model's key limitations"]
[null,null,null,null,"Quality Assurance:","This section should include references to the QA Report/QA undertaken"]
[null,null,null,null,"QA Limitations:","This section should detail any limitations arising from QA and testing"]
[]
[null,null,null,"3 Model Overview"]
[]
[null,null,null,null,"3.1 Navigation"]
[]
[null,null,null,null,"This section should include information on model navigation. For example:"]
[null,null,null,null,"[The model's 'Contents' tab lists and provides a high level summary of each of the worksheets within the model."]
[null,null,null,null,"Each listed worksheet is hyperlinked to aid navigation (click on the 'Link' adjacent to the worksheet's name)."]
[null,null,null,null,"All worksheets within the model are colour coded to aid navigation (see Model Map on the 'Contents' tab):"]
[null,null,null,null,"Input sheets are Yellow"]
[null,null,null,null,"Calculation sheets are Green"]
[null,null,null,null,"Output sheets are Blue"]
[null,null,null,null,"Admin/Control Sheets are Grey"]
[null,null,null,null,"Worksheets are organised into sections and each section has a divider sheet (\">>\" at the end of the tab name)."]
[null,null,null,null,"Within each worksheet within the model the cell styles set out below (see 'Model Style Guide') have been applied."]
[null,null,null,null,"The 'Click for Contents' hyperlink within the header of each worksheet returns the user to the 'Contents' tab."]
[null,null,null,null,"A description of each of the sheets within the model is provided below."]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.2 Error Checks"]
[]
[null,null,null,null,"This section should include information on in-model error and warning checks. For example:"]
[null,null,null,null,"[The model includes an in-built error and warning check network."]
[null,null,null,null,"Each worksheet contains a column for error/warning checks and also displays the results of workbook level checks."]
[null,null,null,null,"Row-level checks are summarised in Columns A and B, for errors and warnings respectively, and summarised at the worksheet level in the header."]
[null,null,null,null,"The model's 'Contents' tab also provides a summary of all of the individual worksheet-level checks."]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.3 Saving and Logging"]
[]
[null,null,null,null,"This section should include information on saving the model and updating the Version Control Log. For example:"]
[null,null,null,null,"[The model includes an in-built Version Control Log to track data and structural changes to the model over its life."]
[null,null,null,null,"Each time the model is updated, a new version should be saved and the Version Control Log updated accordingly."]
[null,null,null,null,"[See 'VersionControlLog' tab for further information on recording model changes and saving new model versions."]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.4 Protection"]
[]
[null,null,null,null,"This section should include information on model protection. For example:"]
[null,null,null,null,"[By default, all cells containing calculations are protected ([with/without] a password) to reduce accidental corruption risk."]
[null,null,null,null,"To make authorised changes to the model's calculations or structure the individual worksheets will need to be unprotected."]
[null,null,null,null,"After making any changes (and applying the agreed QA and testing procedures) all worksheets should be re-protected."]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.5 Model Features"]
[]
[null,null,null,null,"This section should include information on model features not covered elsewhere. For example:"]
[null,null,null,null,"Scenario Selection"]
[null,null,null,null,"Model Automation"]
[null,null,null,null,"Expandable Tables"]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.6 Input Sheets"]
[]
[null,null,null,null,"This section should include information on model input sheets. For example:"]
[null,null,null,null,"[Model inputs are organised across dedicated worksheets that are arranged according to [Data Provider / Area / Scenario]."]
[null,null,null,null,"Each input (e.g. data object) has a reference number that links it to a corresponding Book of Assumptions / Data Log entry ( 'BoA / DL Ref')."]
[null,null,null,null,"Note: Following approval, any changes to the inputs should be reflected within the Book of Assumptions / Data Log."]
[null,null,null,null,"An overview of each of the input worksheets within the model is provided as follows:"]
[null,null,null,null,"iInputExample"]
[null,null,null,null,"This worksheet includes all general inputs that apply to the whole model:"]
[null,null,null,null,"Inflation Rates - This section lists the Wage Inflation rates and shows the user selected rate that is applicable across the model."]
[null,null,null,null,"Note: As wage inflation is applied annually it is expected that inflation will only be entered in the first month of any one year."]
[null,null,null,null,"Staffing - This section lists the number of Full Time Equivalents (FTEs) by Grade over time together with Annual Salaries by Grade."]
[null,null,null,null,"Note: Any changes to the current Annual Salaries should be approved by [Finance] and the BoA-DL updated accordingly."]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.7 Calculation Sheets"]
[]
[null,null,null,null,"This section should include information on model calculation sheets. For example:"]
[null,null,null,null,"[Model calculations have not been designed to require user interaction although are visible to provide transparency over calculations."]
[null,null,null,null,"An overview of each of the calculation worksheets within the model is provided as follows:"]
[null,null,null,null,"cCalcExample"]
[null,null,null,null,"This worksheet includes all staff cost calculations that apply to the in-house option:"]
[null,null,null,null,"Staffing - This section calculates staff costs by grade. It is organised with Call Ups at the top of the section followed by Calculations:"]
[null,null,null,null,"Call Ups - These formulas pull the data that is required to perform the calculations on this sheet from the iInputExample sheet"]
[null,null,null,null,"Calculations: Salary Costs by Grade are initially calculated excluding inflation and then following the application of Wage Inflation"]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.8 Output Sheets"]
[]
[null,null,null,null,"This section should include information on model output sheets. For example:"]
[null,null,null,null,"[An overview of each of the output sheets within the model is provided as follows:"]
[null,null,null,null,"oSummaryExample"]
[null,null,null,null,"This worksheet includes a summary cost table for the in-house option:"]
[null,null,null,null,"Costs Summary - This section summaries monthly costs over time for the in-house option, including inflation:"]
[null,null,null,null,"Staff Costs - These costs call up the total indexed staff costs calculated in the Staffing section on cCalcExample"]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.9 Admin and Control Sheets"]
[]
[null,null,null,null,"This section should include information on model administration and control sheets. For example:"]
[null,null,null,null,"[An overview of each of the administration and control worksheets within the model is provided as follows:"]
[null,null,null,null,"SysConfig"]
[null,null,null,null,"This worksheet is intended for use by the model developer and should not require interaction from model users."]
[null,null,null,null,"This worksheet includes general settings that apply to the whole model:"]
[null,null,null,null,"General Details - This section includes information on the project, IMA score, stakeholders and protective marking."]
[null,null,null,null,"Setup - This section includes the model start date - changes to this date may require updates to model input data."]
[null,null,null,null,"etc.]"]
[]
[null,null,null,null,"3.10 Sign Convention"]
[]
[null,null,null,null,"This section should include information on model sign convention. For Example:"]
[null,null,null,null,"[Costs are entered as positive figures]"]
[]
[null,null,null,"4 Model Style Guide"]
[]
[null,null,null,null,"The following section includes details of how Cell Styles are used within this workbook."]
[]
[null,null,null,"Use of Styles"]
[null,null,null,null,"It is important to use the correct styles on different cell types to increase the readability and usability of the Model, and to help reduce the risk of error."]
[null,null,null,null,"A number of predefined cell styles have been set up in this workbook that can be accessed from the “Cell Styles” menu in the \"Home\" ribbon (see image below)."]
[null,null,null,null,"To apply a style to a cell, select the cell and click on the relevant style from the 'Cell Styles' menu."]
[null,null,null,null,"Styles can also be 'copied' from the cells below and their formats 'pasted' to the required destination."]
[null,null,null,null,"If worksheets are protected, the only cell styles that are not locked are input cell styles."]
[null,null,null,null,"New Cell Styles can be added or old ones deleted or renamed. However, is important NOT to delete or rename any of the styles currently included "]
[null,null,null,null,"in this workbook."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cell Styles"]
[]
[null,null,null,null,"Inputs",null,null,"Cell Protection?","Custom Formatting?"]
[null,null,null,null,"Amount",1234567.8899999999,null,"Unlocked","No"]
[null,null,null,null,"Amount 2.d.p",1234567.8899999999,null,"Unlocked","No"]
[null,null,null,null,"Percentage",1,null,"Unlocked","No"]
[null,null,null,null,"Percentage 2.d.p",1,null,"Unlocked","No"]
[null,null,null,null,"Date","2020-01-01",null,"Unlocked","No"]
[null,null,null,null,"General","Text",null,"Unlocked","No"]
[null,null,null,null,"List","List",null,"Unlocked","No"]
[null,null,null,null,"Databook Reference",1.1000000000000001,null,"Unlocked","No"]
[]
[null,null,null,null,"Links"]
[null,null,null,null,"Amount",1234567.8899999999,null,"Locked","No"]
[null,null,null,null,"Amount 2.d.p",1234567.8899999999,null,"Locked","No"]
[null,null,null,null,"Percentage",1,null,"Locked","No"]
[null,null,null,null,"Percentage 2.d.p",1,null,"Locked","No"]
[null,null,null,null,"Date","2020-01-01",null,"Locked","No"]
[null,null,null,null,"General","Text",null,"Locked","No"]
[]
[null,null,null,null,"Calculations"]
[null,null,null,null,"Amount",1234567.8899999999,null,"Locked","No"]
[null,null,null,null,"Amount 2.d.p",1234567.8899999999,null,"Locked","No"]
[null,null,null,null,"Percentage",1,null,"Locked","No"]
[null,null,null,null,"Percentage 2.d.p",1,null,"Locked","No"]
[null,null,null,null,"Date","2020-01-01",null,"Locked","No"]
[]
[null,null,null,null,"Outputs"]
[null,null,null,null,"Amount",1234567.8899999999,null,"Locked","No"]
[null,null,null,null,"Amount 2.d.p",1234567.8899999999,null,"Locked","No"]
[null,null,null,null,"Percentage",1,null,"Locked","No"]
[null,null,null,null,"Percentage 2.d.p",1,null,"Locked","No"]
[null,null,null,null,"Date","2020-01-01",null,"Locked","No"]
[]
[null,null,null,null,"Other"]
[null,null,null,null,"Label","Label",null,"Locked","No"]
[null,null,null,null,"Unit","Unit",null,"Locked","No"]
[null,null,null,null,"System","System",null,"Locked","No"]
[null,null,null,null,"Error",1,null,"Locked","Yes"]
[null,null,null,null,"Warning",2,null,"Locked","Yes"]
[null,null,null,null,"Warning Text","Warning Text",null,"Locked","No"]
[null,null,null,null,"Named Range*",null,null,"N/a","N/a"]
[null,null,null,null,"*Note, this is not an official Excel style and should be manually applied on top of any Named Ranges - see 'SysConfig' sheet for examples"]
[]
[null,null,null,null,"Headings"]
[null,null,null,null,"Banner",null,null,"Locked","No"]
[null,null,null,null,"Heading 1","Heading 1",null,"Locked","No"]
[null,null,null,null,"Heading 2","Heading 2",null,"Locked","No"]
[null,null,null,null,"Heading 3","Heading 3",null,"Locked","No"]
[null,null,null,null,"Heading 4","Heading 4",null,"Locked","No"]
[]
[null,null,null,"5 Use of Columns"]
[]
[null,null,null,null,"This workbook uses consistent columns across different worksheets. For example, in this workbook, all Error & Warning checks are in columns A & B,"]
[null,null,null,null,"all Labels are in Column F and all Units are in column G (see below for full list). "]
[null,null,null,null,"The alignment of the timeline across worksheets that contain one is also important."]
[null,null,null,null,"This means that the same column should consistently refer to the same time period. "]
[null,null,null,null,"For example, the first period of the timeline in this workbook is in column AA on each and every worksheet that is time-based."]
[null,null,null,null,"The Following key columns are consistent across the workbook:"]
[null,null,null,null,"Column A - Error Check Summary"]
[null,null,null,null,"Column B - Warning Summary"]
[null,null,null,null,"Column D - Heading Label Column"]
[null,null,null,null,"Column E - Sub Heading Label Column"]
[null,null,null,null,"Column F - Sub Heading / Label Column"]
[null,null,null,null,"Column I - Databook Reference Column"]
[null,null,null,null,"Column G - Units Column"]
[null,null,null,null,"Column L to Z Spare Columns to be used as required (e.g. adding comments against specific inputs in input sheet)"]
[null,null,null,null,"Column M (Input sheets) - comments column to add free text comments if required"]
[null,null,null,null,"Column AA onwards - timeline in timebound sheets"]
[]
[null,null,null,null,"If there is a requirement to insert new columns within this workbook this should be done consistently across all worksheets."]
[null,null,null,null,"Notably, columns should not be inserted before the first two columns as these contain the Error and Warning checks."]
[]
[null,null,null,"6 Columns","Definitions"]
[]
[null,null,null,null,"£ 2021/22","GBP Values expressed in 2021/22 economic conditions/price base"]
[null,null,null,null,"£ Nominal","GBP Values including inflation"]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"VersionControlLog","index":4,"n_rows":77,"n_cols":22,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"VersionControlLog Sheet"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"}]
[]
[{"$f":"SUM(A9:A77)","v":0},{"$f":"SUM(B9:B77)","v":0}]
[]
[null,null,null,"Version Control Log"]
[]
[null,null,null,null,"Overview"]
[]
[null,null,null,null,null,"It is important to maintain an audit trail of changes made to an SCM over its life (e.g. to explain what changes were made, when, why, and who approved them). "]
[null,null,null,null,null,"This becomes increasingly important as the model transitions from development to testing and thereafter when outputs begin to be socialised and the model enters the Use phase (see SCM Development Guidance for more information on Version Control)."]
[]
[null,null,null,null,"Instructions"]
[]
[null,null,null,null,"Updating the Version Control Log"]
[null,null,null,null,null,"The Version Control Log can be used to keep a record of changes made to the model between different versions. The following fields, which are included in the Version Control Log, can be populated for each new record:"]
[null,null,null,null,null,"- Description of Change"]
[null,null,null,null,null,"- Key Impact of Change"]
[null,null,null,null,null,"- Type of Change"]
[null,null,null,null,null,"- Worksheet(s) changed"]
[null,null,null,null,null,"- Change Justification"]
[null,null,null,null,null,"- Current QA Status"]
[null,null,null,null,null,"- Model SRO approval obtained? (YN)"]
[null,null,null,null,null,"- Up to 5 KPIS (see below for further details)"]
[]
[null,null,null,null,null,"When updating the Version Control Log using the 'Update Version Control Log' button (see below) the following fields within the Version Control Log will be automatically populated:"]
[null,null,null,null,null,"- Ref # (a unique reference number for the change)"]
[null,null,null,null,null,"- Model Version File Name (the current name of the SCM)"]
[null,null,null,null,null,"- Date & Time of Change (the current time and date)"]
[null,null,null,null,null,"- User who made the change (the SCM user's system ID)"]
[]
[null,null,null,null,null,"To update the Version Control Log, each of the fields in the \"New Change\" section below should be completed. Noting:"]
[null,null,null,null,null,"a) The Description of Change field must be completed. If it is not completed the Version Control Log will not update when using the 'Update Version Control Log' button."]
[null,null,null,null,null,"b) Whilst not enforced, completing each of the other fields is good practice. See below for more details on tracking KPIs."]
[]
[null,null,null,null,null,"On completing the \"New Change\" section, it should be appended to the Version Control Log by clicking the \"Update Version Control Log\" button. This will copy the data from the \"New Change\" section to the \"Version Control Log\"."]
[null,null,null,null,null,"At this point the user will be prompted to save a new version of the model - this is not a requirement but is advisable. It provides an audit trail of changes and enables roll-back to prior versions if required."]
[]
[null,null,null,null,"KPIs"]
[null,null,null,null,null,"Tracking the movement of certain key outputs, such as NPV, as changes are made to the model may be useful. These are referred to as KPIs in this Version Control Log."]
[null,null,null,null,null,"In order to use the KPI tracker, link the cells in the KPI cells in the \"New Change\" section to the required KPI in the model. This will then store the value of the KPI at the time the Version Control Log was updated and provide a record of the KPI value for each of the previous Model versions."]
[null,null,null,null,null,"For example to link \"KPI 1\" to the Output in cell BL18 of the 'oSummaryExample' sheet enter \"=oSummaryExample!BL18\" into the \"KPI 1\" box below (in cell R67)."]
[null,null,null,null,null,"Note KPIs are stored within the Version Control Log as hard-wired values to provide a record of their value at the time the Version Control Log was updated. They should not be updated retrospectively or formula linked to the 'live' KPI value. "]
[]
[null,null,null,null,"Clearing the Log"]
[null,null,null,null,null,"To clear the log, click the \"Clear Version Control Log\" button above."]
[null,null,null,null,null,"This step cannot be undone so this should only be performed if the user is certain they want to delete the contents of the Version Control Log."]
[]
[null,null,null,null,"Use of VBA"]
[null,null,null,null,null,"Note, if VBA is not enabled the Version Control Log will need to be updated manually by adding new rows into the 'Version Control Log' section below and updating it directly."]
[]
[null,null,null,null,null,"In order to enable VBA:"]
[null,null,null,null,null,"1. Click the File tab."]
[null,null,null,null,null,"2. Click Options."]
[null,null,null,null,null,"3. Click Trust Centre, and then click Trust Centre Settings."]
[null,null,null,null,null,"4. In the Trust Centre, click Macro Settings."]
[null,null,null,null,null,"5. Check Trust access to the VBA project object model to enable access to Visual Basic Projects."]
[null,null,null,null,null,"6. Click OK."]
[]
[null,null,null,null,"New Change"]
[]
[null,null,null,null,null,null,"Ref #","Model Version File Name","Date & Time","User","Description of Change","Key Impact of Change","Type of Change","Worksheet(s) changed","Change Justification","Current QA Status","Model SRO approval obtained?","KPI 1","KPI 2","KPI 3","KPI 4","KPI 5"]
[null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1)","v":"SCM_Build_Template_V1_May_2021 (2).xlsm"},null,null,"Example Change","New features","Data","Contents","Development","Pending","No"]
[]
[null,null,null,null,"Version Control Log"]
[]
[null,null,null,null,null,null,"Ref #","Version Name","Date & Time","User","Description of Change","Key Impact of Change","Type of Change","Worksheet(s) changed","Change Justification","Current QA Status","Model SRO approval obtained?","KPI 1","KPI 2","KPI 3","KPI 4","KPI 5"]
[null,null,null,null,null,null,3,"DRAFT - Model Template 087.xlsm","2020-07-13T11:19:57","DummyUser1","Example Change 3","New features","Data","Contents","Development","Pending","No"]
[null,null,null,null,null,null,2,"DRAFT - Model Template 077.xlsm","2020-06-30T17:11:38","DummyUser1","Example Change 2","New features","Data","Contents","Development","Pending","No"]
[null,null,null,null,null,null,1,"DRAFT - Model Template 075.xlsm","2020-06-29T19:03:11","DummyUser1","Example Change 1","New features","Data","Contents","Development","Pending","No"]
[null,null,null,null,null,null,"INSERT NEW ROWS ABOVE THIS ROW"]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"BoA-DL","index":5,"n_rows":144,"n_cols":25,"rows_kept":144,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"BoA-DL Sheet"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"}]
[]
[{"$f":"SUM(A9:A144)","v":0},{"$f":"SUM(B9:B144)","v":0}]
[]
[null,null,null,"BoA / DL User Instructions - This Section Should Be Deleted When The BoA / DL Is Complete / Substantially Complete"]
[]
[null,null,null,null,"Overview of this Sheet"]
[null,null,null,null,null,"This sheet includes the following sections on the Book of Assumptions / Data Log (BoA / DL):"]
[null,null,null,null,null,"- BoA / DL User Instructions, including Book of Assumptions / Data Log Overarching Principles, Instructions for Use and Development Principles"]
[null,null,null,null,null,"- Overview - a narrative section explaining the Book of Assumptions / Data Log (to be tailored by the user when producing the BoA / DL)"]
[null,null,null,null,null,"- A Template Book of Assumptions / Data Log (to be tailored by the user when producing the BoA / DL)"]
[]
[null,null,null,null,"Further Reading"]
[null,null,null,null,null,"This Template BoA / DL should be used with reference to the following publications:"]
[null,null,null,null,null,"- The Sourcing Playbook"]
[null,null,null,null,null,"- The Construction Playbook"]
[null,null,null,null,null,"- SCM Guidance Note"]
[null,null,null,null,null,"- SCM Development Guidance"]
[null,null,null,null,null,"- SCM Technical Build Guidance"]
[]
[null,null,null,null,null,"Additionally, the NAO guidance on 'Improving information to support decision making: standards for better quality data' can be found here."]
[]
[null,null,null,null,null,"For complex sourcing projects, you should consult the Sourcing Programme before planning an SCM via sourcing.programme@cabinetoffice.gov.uk."]
[]
[null,null,null,null,"Overarching Principles"]
[null,null,null,null,null,"A Book of Assumptions / Data Log is a detailed list of the data and assumptions that a model uses and their salient characteristics. It is good practice to prepare a Book of Assumptions / Data Log as a model is developed and input data is brought into the model."]
[null,null,null,null,null,"The Book of Assumptions / Data Log may start off as a data plan, containing a list of all data objects a model will use and then evolve into a final Book of Assumptions / Data Log."]
[null,null,null,null,null,"Given that data can be obtained from different sources, at different levels of detail and with various limitations or constraints, the absence of a Book of Assumptions / Data Log may render it difficult or even impossible to establish data provenance."]
[null,null,null,null,null,"The Book of Assumptions / Data Log has several benefits to the end user, notably:"]
[null,null,null,null,null,"- It provides a readily accessible overview of the data that the model uses as well as its provenance."]
[null,null,null,null,null,"- It allows for review and challenge of the model’s source data and input assumptions and, together with reference to the model Specification, how it is used within the model to derive outputs."]
[null,null,null,null,null,"- It helps to manage the risk that a model and its source data become disconnected and model results cannot be explained. "]
[null,null,null,null,null,"- As well as enhancing the user community’s understanding of the model, the Book of Assumptions / Data Log helps drive auditability of the model and traceability into its dependent data."]
[null,null,null,null,null,"The time demands on model developers and reviewers when undertaking formal QA and testing will increase in the absence of a Book of Assumptions / Data Log. Such demands could substantially delay the model’s delivery and, in-turn, ability to meet its purpose."]
[]
[null,null,null,null,"Instructions for Use"]
[null,null,null,null,null,"The Book of Assumptions / Data Log below contains a number of data fields (e.g. Description, Filename/Path) that should be completed for each data reference. "]
[null,null,null,null,null,"The example data fields in the Book of Assumptions / Data Log can be tailored as required (e.g. by adding new fields or removing/renaming existing fields)."]
[null,null,null,null,null,"The data field headings (e.g. Ref No.) have an embedded description that will be revealed when the heading is clicked on. If required this can be edited via Excel’s Data Validation/Input Message menu."]
[null,null,null,null,null,"The 'Overview' section below should be updated and tailored as required to give as much detail on the Book of Assumptions / Data Log to the user community as required."]
[null,null,null,null,null,"When tailoring the 'Overview', consider using some of the content in the 'Overarching Principles' and 'Development Principles' sections as appropriate."]
[null,null,null,null,null,"This 'BoA / DL User Instructions' Section should be deleted once the Book of Assumptions / Data Log is completed/substantially complete."]
[null,null,null,null,null,"The entries in the Book of Assumptions / Data Log below are illustrative examples and they should be deleted prior to use."]
[]
[null,null,null,null,"Development Principles"]
[null,null,null,null,null,"As the model planning process progresses, prepare a list of all anticipated input data required by the model and review it for completeness."]
[null,null,null,null,null,"This will form the basis of the model Data Plan and will likely evolve over time (e.g. during the model design phase and beyond)."]
[null,null,null,null,null,"This initial list should be documented in the 'Book of Assumptions / Data Log' section below."]
[null,null,null,null,null,"Consider data availability and quality and identify areas where obtaining data may be problematic or data quality may be low. Document this within the table below with the 'Issues' or 'Maturity' fields."]
[null,null,null,null,null,"Where data is not readily available, determine actions to source or generate the data."]
[null,null,null,null,null,"Consider any data processing requirements that may be required to transform the data for SCM population, and document this below (in either 'Issues' or 'Manipulation' fields)."]
[null,null,null,null,null,"If data manipulation is complex, a separate file note on data manipulation steps may be required."]
[null,null,null,null,null,"Once data sets and the Data Plan are agreed, revise the initial Book of Assumptions / Data Log detailed below. Updating the Book of Assumptions / Data Log will likely be an iterative process."]
[null,null,null,null,null,"The Book of Assumptions / Data Log should be updated and maintained as the model develops and throughout its lifecycle. This includes updating the Book of Assumptions / Data Log when the model is being used."]
[]
[null,null,null,null,"Granularity of Data"]
[null,null,null,null,null,"The Book of Assumptions / Data Log should cover all data and assumptions used within the model. However, each entry in the Book of Assumptions / Data Log could cover more than one input and judgement is required."]
[null,null,null,null,null,"For example, both illustrative entries in the Book of Assumptions / Data Log below relate to 'Wage Inflation Rates'."]
[null,null,null,null,null,"The data was provided by the same Source/Provider, on the same Date and in the same File. It also shares the same properties in terms of Review Dates and Validity."]
[null,null,null,null,null,"As such, the two illustrative entries could be represented by a single entry in the Book of Assumptions / Data Log. However, in this instance, they have been split out - this is a subjective judgement call."]
[]
[null,null,null,null,"Data Readiness Levels (DRL)"]
[null,null,null,null,null,"The reliability of model outputs and, in turn, their fitness for purpose will be impacted by the reliability of data used to power the model."]
[null,null,null,null,null,"In practice, the reliability of data will vary across (potentially hundreds of) inputs and will often mature over time as new data is gathered."]
[null,null,null,null,null,"The ability to communicate this to decision makers can be challenging and it is not always done effectively."]
[null,null,null,null,null,"However, understanding the reliability of model outputs is essential to their ability to make informed decisions. "]
[]
[null,null,null,null,null,"By using a structured categorisation framework, the reliability of model inputs and, in-turn outputs, can be communicated in a meaningful and consistent manner."]
[null,null,null,null,null,"This framework is referred to as the Data Readiness Level or DRL."]
[null,null,null,null,null,"Data that is more mature or reliable is more ‘ready’ for use and has a higher DRL than data that is less mature or reliable."]
[null,null,null,null,null,"Data with a low DRL is not necessarily un-useful but it may need to be matured to a higher DRL over the model development lifecycle in order to be reliable enough to inform particular decisions. "]
[]
[null,null,null,null,null,"Through a weighting approach, the overall DRL of a model’s outputs can be calculated with reference to the DRL of its individual inputs."]
[null,null,null,null,null,"The advantages of this are twofold: Firstly it enables the reliability of model outputs to be communicated; and"]
[null,null,null,null,null,"Secondly it enables efforts to mature data to be prioritised towards those inputs that have both the lowest DRL and the greatest impact on model outputs."]
[]
[null,null,null,null,null,"The DRL scale in the example below runs from Level 1 (Genesis Thinking) to Level 9 (Historical Data)."]
[null,null,null,null,null,"It is an illustrative framework and should be adapted to meet the requirements of your contracting authority."]
[null,null,null,null,null,"This includes supplementing it with clear and meaningful descriptions and/or examples to help ensure consistency of application."]
[null,null,null,null,null,"Notably, to enable meaningful comparisons and to provide a consistent measure that can be relied upon by decision makers, it is essential that a uniform framework is adopted across the contracting authority."]
[]
[null,null,null,null,"Illustrative Example of a DRL Scale"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Overview"]
[]
[null,null,null,null,null,"This Book of Assumptions / Data Log contains a list of all the input data and assumptions held within the [Insert Name of Model] model."]
[null,null,null,null,null,"This Book of Assumptions / Data Log should be updated throughout the life of the model, and tie back to the data and assumptions within the model at all times."]
[null,null,null,null,null,"Each entry in the BoA / DL should have a reference number which corresponds to data objects in the model. This facilitates ease of reconciliation between the Book of Assumptions / Data Log and the model."]
[null,null,null,null,null,"A brief description of each field in the BoA / DL can be viewed by clicking on the heading field (e.g. Ref No.)."]
[null,null,null,null,null,"The Book of Assumptions / Data Log table below can be updated to include more rows."]
[null,null,null,null,null,"To add new rows to the BoA / DL, select the number of rows to be added from the drop down list and click the 'Add New Rows to Table' button."]
[null,null,null,null,null,"This will add the required number of rows at the bottom of the table."]
[null,null,null,null,null,"If VBA (Macros) are not enabled then rows will need to be added to the BoA / DL table manually."]
[null,null,null,null,null,"[Insert additional rows as required to update this section]"]
[]
[null,null,null,"Book of Assumptions / Data Log"]
[]
[null,null,null,null,null,5,"<<<No. Rows to Add"]
[]
[null,null,null,null,null,"Ref No.","Area","Input Label","Description","Rationale","Assumptions","Units","Base Year","Filename/Path","Source/Provider","Date Produced","Date Provided","Owner","Review Date","Refresh","Validity","Issues","Manipulation","DRL/Maturity","Maturity Plan"]
[null,null,null,null,null,1.1000000000000001,"Wage Inflation Rates","Inflation Index 1","Example input for inflation - using profile 1","Departmental guidelines","N/a","%","Salaries are input in GBP 2020 prices","InflationInputs.xlsx","Joe Bloggs","2020-06-30","2020-07-07","Pat Bloggs","2020-07-07",{"$f":"EOMONTH(S132,3)","v":"2020-10-31"},"No restrictions","No known issues","N/a",5,"N/a"]
[null,null,null,null,null,1.2,"Wage Inflation Rates","Inflation Index 2","Example input for inflation - using profile 2","Departmental guidelines","N/a","%","Salaries are input in GBP 2020 prices","InflationInputs.xlsx","Joe Bloggs","2020-06-30","2020-07-07","Pat Bloggs","2020-07-07",{"$f":"EOMONTH(S133,3)","v":"2020-10-31"},"No restrictions","No known issues","N/a",9,"N/a"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"INSERT NEW ROWS ABOVE THIS ROW"]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"Inputs>>","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"iInputExample","index":7,"n_rows":39,"n_cols":66,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z2","v":"Period Start"},{"$f":"SysTime!AA2","v":"2021-04-01"},{"$f":"SysTime!AB2","v":"2021-05-01"},{"$f":"SysTime!AC2","v":"2021-06-01"},{"$f":"SysTime!AD2","v":"2021-07-01"},{"$f":"SysTime!AE2","v":"2021-08-01"},{"$f":"SysTime!AF2","v":"2021-09-01"},{"$f":"SysTime!AG2","v":"2021-10-01"},{"$f":"SysTime!AH2","v":"2021-11-01"},{"$f":"SysTime!AI2","v":"2021-12-01"},{"$f":"SysTime!AJ2","v":"2022-01-01"},{"$f":"SysTime!AK2","v":"2022-02-01"},{"$f":"SysTime!AL2","v":"2022-03-01"},{"$f":"SysTime!AM2","v":"2022-04-01"},{"$f":"SysTime!AN2","v":"2022-05-01"},{"$f":"SysTime!AO2","v":"2022-06-01"},{"$f":"SysTime!AP2","v":"2022-07-01"},{"$f":"SysTime!AQ2","v":"2022-08-01"},{"$f":"SysTime!AR2","v":"2022-09-01"},{"$f":"SysTime!AS2","v":"2022-10-01"},{"$f":"SysTime!AT2","v":"2022-11-01"},{"$f":"SysTime!AU2","v":"2022-12-01"},{"$f":"SysTime!AV2","v":"2023-01-01"},{"$f":"SysTime!AW2","v":"2023-02-01"},{"$f":"SysTime!AX2","v":"2023-03-01"},{"$f":"SysTime!AY2","v":"2023-04-01"},{"$f":"SysTime!AZ2","v":"2023-05-01"},{"$f":"SysTime!BA2","v":"2023-06-01"},{"$f":"SysTime!BB2","v":"2023-07-01"},{"$f":"SysTime!BC2","v":"2023-08-01"},{"$f":"SysTime!BD2","v":"2023-09-01"},{"$f":"SysTime!BE2","v":"2023-10-01"},{"$f":"SysTime!BF2","v":"2023-11-01"},{"$f":"SysTime!BG2","v":"2023-12-01"},{"$f":"SysTime!BH2","v":"2024-01-01"},{"$f":"SysTime!BI2","v":"2024-02-01"},{"$f":"SysTime!BJ2","v":"2024-03-01"},null,{"$f":"SysTime!BL2","v":"2021-04-01"},{"$f":"SysTime!BM2","v":"2022-04-01"},{"$f":"SysTime!BN2","v":"2023-04-01"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"iInputExample Sheet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z3","v":"Period End"},{"$f":"SysTime!AA3","v":"2021-04-30"},{"$f":"SysTime!AB3","v":"2021-05-31"},{"$f":"SysTime!AC3","v":"2021-06-30"},{"$f":"SysTime!AD3","v":"2021-07-31"},{"$f":"SysTime!AE3","v":"2021-08-31"},{"$f":"SysTime!AF3","v":"2021-09-30"},{"$f":"SysTime!AG3","v":"2021-10-31"},{"$f":"SysTime!AH3","v":"2021-11-30"},{"$f":"SysTime!AI3","v":"2021-12-31"},{"$f":"SysTime!AJ3","v":"2022-01-31"},{"$f":"SysTime!AK3","v":"2022-02-28"},{"$f":"SysTime!AL3","v":"2022-03-31"},{"$f":"SysTime!AM3","v":"2022-04-30"},{"$f":"SysTime!AN3","v":"2022-05-31"},{"$f":"SysTime!AO3","v":"2022-06-30"},{"$f":"SysTime!AP3","v":"2022-07-31"},{"$f":"SysTime!AQ3","v":"2022-08-31"},{"$f":"SysTime!AR3","v":"2022-09-30"},{"$f":"SysTime!AS3","v":"2022-10-31"},{"$f":"SysTime!AT3","v":"2022-11-30"},{"$f":"SysTime!AU3","v":"2022-12-31"},{"$f":"SysTime!AV3","v":"2023-01-31"},{"$f":"SysTime!AW3","v":"2023-02-28"},{"$f":"SysTime!AX3","v":"2023-03-31"},{"$f":"SysTime!AY3","v":"2023-04-30"},{"$f":"SysTime!AZ3","v":"2023-05-31"},{"$f":"SysTime!BA3","v":"2023-06-30"},{"$f":"SysTime!BB3","v":"2023-07-31"},{"$f":"SysTime!BC3","v":"2023-08-31"},{"$f":"SysTime!BD3","v":"2023-09-30"},{"$f":"SysTime!BE3","v":"2023-10-31"},{"$f":"SysTime!BF3","v":"2023-11-30"},{"$f":"SysTime!BG3","v":"2023-12-31"},{"$f":"SysTime!BH3","v":"2024-01-31"},{"$f":"SysTime!BI3","v":"2024-02-29"},{"$f":"SysTime!BJ3","v":"2024-03-31"},null,{"$f":"SysTime!BL3","v":"2022-03-31"},{"$f":"SysTime!BM3","v":"2023-03-31"},{"$f":"SysTime!BN3","v":"2024-03-31"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z4","v":"Timeline"},{"$f":"SysTime!AA4","v":"Monthly"},{"$f":"SysTime!AB4","v":"Monthly"},{"$f":"SysTime!AC4","v":"Monthly"},{"$f":"SysTime!AD4","v":"Monthly"},{"$f":"SysTime!AE4","v":"Monthly"},{"$f":"SysTime!AF4","v":"Monthly"},{"$f":"SysTime!AG4","v":"Monthly"},{"$f":"SysTime!AH4","v":"Monthly"},{"$f":"SysTime!AI4","v":"Monthly"},{"$f":"SysTime!AJ4","v":"Monthly"},{"$f":"SysTime!AK4","v":"Monthly"},{"$f":"SysTime!AL4","v":"Monthly"},{"$f":"SysTime!AM4","v":"Monthly"},{"$f":"SysTime!AN4","v":"Monthly"},{"$f":"SysTime!AO4","v":"Monthly"},{"$f":"SysTime!AP4","v":"Monthly"},{"$f":"SysTime!AQ4","v":"Monthly"},{"$f":"SysTime!AR4","v":"Monthly"},{"$f":"SysTime!AS4","v":"Monthly"},{"$f":"SysTime!AT4","v":"Monthly"},{"$f":"SysTime!AU4","v":"Monthly"},{"$f":"SysTime!AV4","v":"Monthly"},{"$f":"SysTime!AW4","v":"Monthly"},{"$f":"SysTime!AX4","v":"Monthly"},{"$f":"SysTime!AY4","v":"Monthly"},{"$f":"SysTime!AZ4","v":"Monthly"},{"$f":"SysTime!BA4","v":"Monthly"},{"$f":"SysTime!BB4","v":"Monthly"},{"$f":"SysTime!BC4","v":"Monthly"},{"$f":"SysTime!BD4","v":"Monthly"},{"$f":"SysTime!BE4","v":"Monthly"},{"$f":"SysTime!BF4","v":"Monthly"},{"$f":"SysTime!BG4","v":"Monthly"},{"$f":"SysTime!BH4","v":"Monthly"},{"$f":"SysTime!BI4","v":"Monthly"},{"$f":"SysTime!BJ4","v":"Monthly"},null,{"$f":"SysTime!BL4","v":"Annual"},{"$f":"SysTime!BM4","v":"Annual"},{"$f":"SysTime!BN4","v":"Annual"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z5","v":"Period index"},{"$f":"SysTime!AA5","v":1},{"$f":"SysTime!AB5","v":2},{"$f":"SysTime!AC5","v":3},{"$f":"SysTime!AD5","v":4},{"$f":"SysTime!AE5","v":5},{"$f":"SysTime!AF5","v":6},{"$f":"SysTime!AG5","v":7},{"$f":"SysTime!AH5","v":8},{"$f":"SysTime!AI5","v":9},{"$f":"SysTime!AJ5","v":10},{"$f":"SysTime!AK5","v":11},{"$f":"SysTime!AL5","v":12},{"$f":"SysTime!AM5","v":13},{"$f":"SysTime!AN5","v":14},{"$f":"SysTime!AO5","v":15},{"$f":"SysTime!AP5","v":16},{"$f":"SysTime!AQ5","v":17},{"$f":"SysTime!AR5","v":18},{"$f":"SysTime!AS5","v":19},{"$f":"SysTime!AT5","v":20},{"$f":"SysTime!AU5","v":21},{"$f":"SysTime!AV5","v":22},{"$f":"SysTime!AW5","v":23},{"$f":"SysTime!AX5","v":24},{"$f":"SysTime!AY5","v":25},{"$f":"SysTime!AZ5","v":26},{"$f":"SysTime!BA5","v":27},{"$f":"SysTime!BB5","v":28},{"$f":"SysTime!BC5","v":29},{"$f":"SysTime!BD5","v":30},{"$f":"SysTime!BE5","v":31},{"$f":"SysTime!BF5","v":32},{"$f":"SysTime!BG5","v":33},{"$f":"SysTime!BH5","v":34},{"$f":"SysTime!BI5","v":35},{"$f":"SysTime!BJ5","v":36},null,{"$f":"SysTime!BL5","v":1},{"$f":"SysTime!BM5","v":2},{"$f":"SysTime!BN5","v":3}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z6","v":"Year index"},{"$f":"SysTime!AA6","v":1},{"$f":"SysTime!AB6","v":1},{"$f":"SysTime!AC6","v":1},{"$f":"SysTime!AD6","v":1},{"$f":"SysTime!AE6","v":1},{"$f":"SysTime!AF6","v":1},{"$f":"SysTime!AG6","v":1},{"$f":"SysTime!AH6","v":1},{"$f":"SysTime!AI6","v":1},{"$f":"SysTime!AJ6","v":1},{"$f":"SysTime!AK6","v":1},{"$f":"SysTime!AL6","v":1},{"$f":"SysTime!AM6","v":2},{"$f":"SysTime!AN6","v":2},{"$f":"SysTime!AO6","v":2},{"$f":"SysTime!AP6","v":2},{"$f":"SysTime!AQ6","v":2},{"$f":"SysTime!AR6","v":2},{"$f":"SysTime!AS6","v":2},{"$f":"SysTime!AT6","v":2},{"$f":"SysTime!AU6","v":2},{"$f":"SysTime!AV6","v":2},{"$f":"SysTime!AW6","v":2},{"$f":"SysTime!AX6","v":2},{"$f":"SysTime!AY6","v":3},{"$f":"SysTime!AZ6","v":3},{"$f":"SysTime!BA6","v":3},{"$f":"SysTime!BB6","v":3},{"$f":"SysTime!BC6","v":3},{"$f":"SysTime!BD6","v":3},{"$f":"SysTime!BE6","v":3},{"$f":"SysTime!BF6","v":3},{"$f":"SysTime!BG6","v":3},{"$f":"SysTime!BH6","v":3},{"$f":"SysTime!BI6","v":3},{"$f":"SysTime!BJ6","v":3},null,{"$f":"SysTime!BL6","v":1},{"$f":"SysTime!BM6","v":2},{"$f":"SysTime!BN6","v":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,{"$f":"SysTime!Z7","v":"Relative period"},{"$f":"SysTime!AA7","v":1},{"$f":"SysTime!AB7","v":2},{"$f":"SysTime!AC7","v":3},{"$f":"SysTime!AD7","v":4},{"$f":"SysTime!AE7","v":5},{"$f":"SysTime!AF7","v":6},{"$f":"SysTime!AG7","v":7},{"$f":"SysTime!AH7","v":8},{"$f":"SysTime!AI7","v":9},{"$f":"SysTime!AJ7","v":10},{"$f":"SysTime!AK7","v":11},{"$f":"SysTime!AL7","v":12},{"$f":"SysTime!AM7","v":1},{"$f":"SysTime!AN7","v":2},{"$f":"SysTime!AO7","v":3},{"$f":"SysTime!AP7","v":4},{"$f":"SysTime!AQ7","v":5},{"$f":"SysTime!AR7","v":6},{"$f":"SysTime!AS7","v":7},{"$f":"SysTime!AT7","v":8},{"$f":"SysTime!AU7","v":9},{"$f":"SysTime!AV7","v":10},{"$f":"SysTime!AW7","v":11},{"$f":"SysTime!AX7","v":12},{"$f":"SysTime!AY7","v":1},{"$f":"SysTime!AZ7","v":2},{"$f":"SysTime!BA7","v":3},{"$f":"SysTime!BB7","v":4},{"$f":"SysTime!BC7","v":5},{"$f":"SysTime!BD7","v":6},{"$f":"SysTime!BE7","v":7},{"$f":"SysTime!BF7","v":8},{"$f":"SysTime!BG7","v":9},{"$f":"SysTime!BH7","v":10},{"$f":"SysTime!BI7","v":11},{"$f":"SysTime!BJ7","v":12},null,{"$f":"SysTime!BL7","v":1},{"$f":"SysTime!BM7","v":2},{"$f":"SysTime!BN7","v":3}]
[{"$f":"SUM(A9:A39)","v":0},{"$f":"SUM(B9:B39)","v":0},null,null,null,null,"Units",null,"BoA / DL Ref",null,"Non-time dep",null,"Comments"]
[]
[null,null,null,"1 Inflation Rates"]
[]
[null,null,null,null,"Wage Inflation Rates"]
[]
[null,null,null,null,null,"Inflation Index 1","%",null,1.1000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0.01,0,0,0,0,0,0,0,0,0,0,0,0.01,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Inflation Index 2","%",null,1.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0.02,0,0,0,0,0,0,0,0,0,0,0,0.02,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"Inflation Rate - In Use","Switch",null,null,null,"Inflation Index 1"]
[]
[null,null,null,"2 Staffing"]
[]
[null,null,null,null,"2.1 Details"]
[]
[null,null,null,null,"FTEs by Grade"]
[]
[{"$f":"COUNTBLANK(AA25:BJ25)","v":0},null,null,null,null,"Grade A","#",null,1.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[{"$f":"COUNTBLANK(AA26:BJ26)","v":0},null,null,null,null,"Grade B","#",null,1.4000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[{"$f":"COUNTBLANK(AA27:BJ27)","v":0},null,null,null,null,"Grade C","#",null,1.5000000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[0,null,null,null,null,"Grade D","#",null,1.6000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[0,null,null,null,null,"Grade E","#",null,1.7000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,null,null,"Annual Salaries by Grade (2020 values)"]
[]
[{"$f":"IF(ISBLANK(K33),1,0)","v":0},null,null,null,null,"Grade A","£ 2021/22",null,1.8,null,30000]
[{"$f":"IF(ISBLANK(K34),1,0)","v":0},null,null,null,null,"Grade B","£ 2021/22",null,1.9000000000000001,null,32500]
[0,null,null,null,null,"Grade C","£ 2021/22",null,"2.0",null,35000]
[0,null,null,null,null,"Grade D","£ 2021/22",null,2.1,null,37500]
[0,null,null,null,null,"Grade E","£ 2021/22",null,2.2000000000000002,null,50000]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"Calcs>>","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"cCalcExample","index":9,"n_rows":66,"n_cols":66,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z2","v":"Period Start"},{"$f":"SysTime!AA2","v":"2021-04-01"},{"$f":"SysTime!AB2","v":"2021-05-01"},{"$f":"SysTime!AC2","v":"2021-06-01"},{"$f":"SysTime!AD2","v":"2021-07-01"},{"$f":"SysTime!AE2","v":"2021-08-01"},{"$f":"SysTime!AF2","v":"2021-09-01"},{"$f":"SysTime!AG2","v":"2021-10-01"},{"$f":"SysTime!AH2","v":"2021-11-01"},{"$f":"SysTime!AI2","v":"2021-12-01"},{"$f":"SysTime!AJ2","v":"2022-01-01"},{"$f":"SysTime!AK2","v":"2022-02-01"},{"$f":"SysTime!AL2","v":"2022-03-01"},{"$f":"SysTime!AM2","v":"2022-04-01"},{"$f":"SysTime!AN2","v":"2022-05-01"},{"$f":"SysTime!AO2","v":"2022-06-01"},{"$f":"SysTime!AP2","v":"2022-07-01"},{"$f":"SysTime!AQ2","v":"2022-08-01"},{"$f":"SysTime!AR2","v":"2022-09-01"},{"$f":"SysTime!AS2","v":"2022-10-01"},{"$f":"SysTime!AT2","v":"2022-11-01"},{"$f":"SysTime!AU2","v":"2022-12-01"},{"$f":"SysTime!AV2","v":"2023-01-01"},{"$f":"SysTime!AW2","v":"2023-02-01"},{"$f":"SysTime!AX2","v":"2023-03-01"},{"$f":"SysTime!AY2","v":"2023-04-01"},{"$f":"SysTime!AZ2","v":"2023-05-01"},{"$f":"SysTime!BA2","v":"2023-06-01"},{"$f":"SysTime!BB2","v":"2023-07-01"},{"$f":"SysTime!BC2","v":"2023-08-01"},{"$f":"SysTime!BD2","v":"2023-09-01"},{"$f":"SysTime!BE2","v":"2023-10-01"},{"$f":"SysTime!BF2","v":"2023-11-01"},{"$f":"SysTime!BG2","v":"2023-12-01"},{"$f":"SysTime!BH2","v":"2024-01-01"},{"$f":"SysTime!BI2","v":"2024-02-01"},{"$f":"SysTime!BJ2","v":"2024-03-01"},null,{"$f":"SysTime!BL2","v":"2021-04-01"},{"$f":"SysTime!BM2","v":"2022-04-01"},{"$f":"SysTime!BN2","v":"2023-04-01"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"cCalcExample Sheet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z3","v":"Period End"},{"$f":"SysTime!AA3","v":"2021-04-30"},{"$f":"SysTime!AB3","v":"2021-05-31"},{"$f":"SysTime!AC3","v":"2021-06-30"},{"$f":"SysTime!AD3","v":"2021-07-31"},{"$f":"SysTime!AE3","v":"2021-08-31"},{"$f":"SysTime!AF3","v":"2021-09-30"},{"$f":"SysTime!AG3","v":"2021-10-31"},{"$f":"SysTime!AH3","v":"2021-11-30"},{"$f":"SysTime!AI3","v":"2021-12-31"},{"$f":"SysTime!AJ3","v":"2022-01-31"},{"$f":"SysTime!AK3","v":"2022-02-28"},{"$f":"SysTime!AL3","v":"2022-03-31"},{"$f":"SysTime!AM3","v":"2022-04-30"},{"$f":"SysTime!AN3","v":"2022-05-31"},{"$f":"SysTime!AO3","v":"2022-06-30"},{"$f":"SysTime!AP3","v":"2022-07-31"},{"$f":"SysTime!AQ3","v":"2022-08-31"},{"$f":"SysTime!AR3","v":"2022-09-30"},{"$f":"SysTime!AS3","v":"2022-10-31"},{"$f":"SysTime!AT3","v":"2022-11-30"},{"$f":"SysTime!AU3","v":"2022-12-31"},{"$f":"SysTime!AV3","v":"2023-01-31"},{"$f":"SysTime!AW3","v":"2023-02-28"},{"$f":"SysTime!AX3","v":"2023-03-31"},{"$f":"SysTime!AY3","v":"2023-04-30"},{"$f":"SysTime!AZ3","v":"2023-05-31"},{"$f":"SysTime!BA3","v":"2023-06-30"},{"$f":"SysTime!BB3","v":"2023-07-31"},{"$f":"SysTime!BC3","v":"2023-08-31"},{"$f":"SysTime!BD3","v":"2023-09-30"},{"$f":"SysTime!BE3","v":"2023-10-31"},{"$f":"SysTime!BF3","v":"2023-11-30"},{"$f":"SysTime!BG3","v":"2023-12-31"},{"$f":"SysTime!BH3","v":"2024-01-31"},{"$f":"SysTime!BI3","v":"2024-02-29"},{"$f":"SysTime!BJ3","v":"2024-03-31"},null,{"$f":"SysTime!BL3","v":"2022-03-31"},{"$f":"SysTime!BM3","v":"2023-03-31"},{"$f":"SysTime!BN3","v":"2024-03-31"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z4","v":"Timeline"},{"$f":"SysTime!AA4","v":"Monthly"},{"$f":"SysTime!AB4","v":"Monthly"},{"$f":"SysTime!AC4","v":"Monthly"},{"$f":"SysTime!AD4","v":"Monthly"},{"$f":"SysTime!AE4","v":"Monthly"},{"$f":"SysTime!AF4","v":"Monthly"},{"$f":"SysTime!AG4","v":"Monthly"},{"$f":"SysTime!AH4","v":"Monthly"},{"$f":"SysTime!AI4","v":"Monthly"},{"$f":"SysTime!AJ4","v":"Monthly"},{"$f":"SysTime!AK4","v":"Monthly"},{"$f":"SysTime!AL4","v":"Monthly"},{"$f":"SysTime!AM4","v":"Monthly"},{"$f":"SysTime!AN4","v":"Monthly"},{"$f":"SysTime!AO4","v":"Monthly"},{"$f":"SysTime!AP4","v":"Monthly"},{"$f":"SysTime!AQ4","v":"Monthly"},{"$f":"SysTime!AR4","v":"Monthly"},{"$f":"SysTime!AS4","v":"Monthly"},{"$f":"SysTime!AT4","v":"Monthly"},{"$f":"SysTime!AU4","v":"Monthly"},{"$f":"SysTime!AV4","v":"Monthly"},{"$f":"SysTime!AW4","v":"Monthly"},{"$f":"SysTime!AX4","v":"Monthly"},{"$f":"SysTime!AY4","v":"Monthly"},{"$f":"SysTime!AZ4","v":"Monthly"},{"$f":"SysTime!BA4","v":"Monthly"},{"$f":"SysTime!BB4","v":"Monthly"},{"$f":"SysTime!BC4","v":"Monthly"},{"$f":"SysTime!BD4","v":"Monthly"},{"$f":"SysTime!BE4","v":"Monthly"},{"$f":"SysTime!BF4","v":"Monthly"},{"$f":"SysTime!BG4","v":"Monthly"},{"$f":"SysTime!BH4","v":"Monthly"},{"$f":"SysTime!BI4","v":"Monthly"},{"$f":"SysTime!BJ4","v":"Monthly"},null,{"$f":"SysTime!BL4","v":"Annual"},{"$f":"SysTime!BM4","v":"Annual"},{"$f":"SysTime!BN4","v":"Annual"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z5","v":"Period index"},{"$f":"SysTime!AA5","v":1},{"$f":"SysTime!AB5","v":2},{"$f":"SysTime!AC5","v":3},{"$f":"SysTime!AD5","v":4},{"$f":"SysTime!AE5","v":5},{"$f":"SysTime!AF5","v":6},{"$f":"SysTime!AG5","v":7},{"$f":"SysTime!AH5","v":8},{"$f":"SysTime!AI5","v":9},{"$f":"SysTime!AJ5","v":10},{"$f":"SysTime!AK5","v":11},{"$f":"SysTime!AL5","v":12},{"$f":"SysTime!AM5","v":13},{"$f":"SysTime!AN5","v":14},{"$f":"SysTime!AO5","v":15},{"$f":"SysTime!AP5","v":16},{"$f":"SysTime!AQ5","v":17},{"$f":"SysTime!AR5","v":18},{"$f":"SysTime!AS5","v":19},{"$f":"SysTime!AT5","v":20},{"$f":"SysTime!AU5","v":21},{"$f":"SysTime!AV5","v":22},{"$f":"SysTime!AW5","v":23},{"$f":"SysTime!AX5","v":24},{"$f":"SysTime!AY5","v":25},{"$f":"SysTime!AZ5","v":26},{"$f":"SysTime!BA5","v":27},{"$f":"SysTime!BB5","v":28},{"$f":"SysTime!BC5","v":29},{"$f":"SysTime!BD5","v":30},{"$f":"SysTime!BE5","v":31},{"$f":"SysTime!BF5","v":32},{"$f":"SysTime!BG5","v":33},{"$f":"SysTime!BH5","v":34},{"$f":"SysTime!BI5","v":35},{"$f":"SysTime!BJ5","v":36},null,{"$f":"SysTime!BL5","v":1},{"$f":"SysTime!BM5","v":2},{"$f":"SysTime!BN5","v":3}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z6","v":"Year index"},{"$f":"SysTime!AA6","v":1},{"$f":"SysTime!AB6","v":1},{"$f":"SysTime!AC6","v":1},{"$f":"SysTime!AD6","v":1},{"$f":"SysTime!AE6","v":1},{"$f":"SysTime!AF6","v":1},{"$f":"SysTime!AG6","v":1},{"$f":"SysTime!AH6","v":1},{"$f":"SysTime!AI6","v":1},{"$f":"SysTime!AJ6","v":1},{"$f":"SysTime!AK6","v":1},{"$f":"SysTime!AL6","v":1},{"$f":"SysTime!AM6","v":2},{"$f":"SysTime!AN6","v":2},{"$f":"SysTime!AO6","v":2},{"$f":"SysTime!AP6","v":2},{"$f":"SysTime!AQ6","v":2},{"$f":"SysTime!AR6","v":2},{"$f":"SysTime!AS6","v":2},{"$f":"SysTime!AT6","v":2},{"$f":"SysTime!AU6","v":2},{"$f":"SysTime!AV6","v":2},{"$f":"SysTime!AW6","v":2},{"$f":"SysTime!AX6","v":2},{"$f":"SysTime!AY6","v":3},{"$f":"SysTime!AZ6","v":3},{"$f":"SysTime!BA6","v":3},{"$f":"SysTime!BB6","v":3},{"$f":"SysTime!BC6","v":3},{"$f":"SysTime!BD6","v":3},{"$f":"SysTime!BE6","v":3},{"$f":"SysTime!BF6","v":3},{"$f":"SysTime!BG6","v":3},{"$f":"SysTime!BH6","v":3},{"$f":"SysTime!BI6","v":3},{"$f":"SysTime!BJ6","v":3},null,{"$f":"SysTime!BL6","v":1},{"$f":"SysTime!BM6","v":2},{"$f":"SysTime!BN6","v":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,{"$f":"SysTime!Z7","v":"Relative period"},{"$f":"SysTime!AA7","v":1},{"$f":"SysTime!AB7","v":2},{"$f":"SysTime!AC7","v":3},{"$f":"SysTime!AD7","v":4},{"$f":"SysTime!AE7","v":5},{"$f":"SysTime!AF7","v":6},{"$f":"SysTime!AG7","v":7},{"$f":"SysTime!AH7","v":8},{"$f":"SysTime!AI7","v":9},{"$f":"SysTime!AJ7","v":10},{"$f":"SysTime!AK7","v":11},{"$f":"SysTime!AL7","v":12},{"$f":"SysTime!AM7","v":1},{"$f":"SysTime!AN7","v":2},{"$f":"SysTime!AO7","v":3},{"$f":"SysTime!AP7","v":4},{"$f":"SysTime!AQ7","v":5},{"$f":"SysTime!AR7","v":6},{"$f":"SysTime!AS7","v":7},{"$f":"SysTime!AT7","v":8},{"$f":"SysTime!AU7","v":9},{"$f":"SysTime!AV7","v":10},{"$f":"SysTime!AW7","v":11},{"$f":"SysTime!AX7","v":12},{"$f":"SysTime!AY7","v":1},{"$f":"SysTime!AZ7","v":2},{"$f":"SysTime!BA7","v":3},{"$f":"SysTime!BB7","v":4},{"$f":"SysTime!BC7","v":5},{"$f":"SysTime!BD7","v":6},{"$f":"SysTime!BE7","v":7},{"$f":"SysTime!BF7","v":8},{"$f":"SysTime!BG7","v":9},{"$f":"SysTime!BH7","v":10},{"$f":"SysTime!BI7","v":11},{"$f":"SysTime!BJ7","v":12},null,{"$f":"SysTime!BL7","v":1},{"$f":"SysTime!BM7","v":2},{"$f":"SysTime!BN7","v":3}]
[{"$f":"SUM(A9:A66)","v":0},{"$f":"SUM(B9:B66)","v":0},null,null,null,null,"Units",null,null,null,"Non-time dep"]
[null,null,null,null,null,null,"CALCULATIONS ARE FOR ILLUSTRATIVE PURPOSES ONLY - NOT TO BE USED IN DEVELOPMENT OF AN SCM"]
[null,null,null,"1. Staffing"]
[]
[null,null,null,null,"1.1 Staff Salaries"]
[]
[null,null,null,null,null,"Call Ups"]
[]
[null,null,null,null,null,{"$f":"iInputExample!F14","v":"Inflation Index 1"},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"iInputExample!AA14","v":0},{"$f":"iInputExample!AB14","v":0},{"$f":"iInputExample!AC14","v":0},{"$f":"iInputExample!AD14","v":0},{"$f":"iInputExample!AE14","v":0},{"$f":"iInputExample!AF14","v":0},{"$f":"iInputExample!AG14","v":0},{"$f":"iInputExample!AH14","v":0},{"$f":"iInputExample!AI14","v":0},{"$f":"iInputExample!AJ14","v":0},{"$f":"iInputExample!AK14","v":0},{"$f":"iInputExample!AL14","v":0},{"$f":"iInputExample!AM14","v":0.01},{"$f":"iInputExample!AN14","v":0},{"$f":"iInputExample!AO14","v":0},{"$f":"iInputExample!AP14","v":0},{"$f":"iInputExample!AQ14","v":0},{"$f":"iInputExample!AR14","v":0},{"$f":"iInputExample!AS14","v":0},{"$f":"iInputExample!AT14","v":0},{"$f":"iInputExample!AU14","v":0},{"$f":"iInputExample!AV14","v":0},{"$f":"iInputExample!AW14","v":0},{"$f":"iInputExample!AX14","v":0},{"$f":"iInputExample!AY14","v":0.01},{"$f":"iInputExample!AZ14","v":0},{"$f":"iInputExample!BA14","v":0},{"$f":"iInputExample!BB14","v":0},{"$f":"iInputExample!BC14","v":0},{"$f":"iInputExample!BD14","v":0},{"$f":"iInputExample!BE14","v":0},{"$f":"iInputExample!BF14","v":0},{"$f":"iInputExample!BG14","v":0},{"$f":"iInputExample!BH14","v":0},{"$f":"iInputExample!BI14","v":0},{"$f":"iInputExample!BJ14","v":0}]
[null,null,null,null,null,{"$f":"iInputExample!F15","v":"Inflation Index 2"},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"iInputExample!AA15","v":0},{"$f":"iInputExample!AB15","v":0},{"$f":"iInputExample!AC15","v":0},{"$f":"iInputExample!AD15","v":0},{"$f":"iInputExample!AE15","v":0},{"$f":"iInputExample!AF15","v":0},{"$f":"iInputExample!AG15","v":0},{"$f":"iInputExample!AH15","v":0},{"$f":"iInputExample!AI15","v":0},{"$f":"iInputExample!AJ15","v":0},{"$f":"iInputExample!AK15","v":0},{"$f":"iInputExample!AL15","v":0},{"$f":"iInputExample!AM15","v":0.02},{"$f":"iInputExample!AN15","v":0},{"$f":"iInputExample!AO15","v":0},{"$f":"iInputExample!AP15","v":0},{"$f":"iInputExample!AQ15","v":0},{"$f":"iInputExample!AR15","v":0},{"$f":"iInputExample!AS15","v":0},{"$f":"iInputExample!AT15","v":0},{"$f":"iInputExample!AU15","v":0},{"$f":"iInputExample!AV15","v":0},{"$f":"iInputExample!AW15","v":0},{"$f":"iInputExample!AX15","v":0},{"$f":"iInputExample!AY15","v":0.02},{"$f":"iInputExample!AZ15","v":0},{"$f":"iInputExample!BA15","v":0},{"$f":"iInputExample!BB15","v":0},{"$f":"iInputExample!BC15","v":0},{"$f":"iInputExample!BD15","v":0},{"$f":"iInputExample!BE15","v":0},{"$f":"iInputExample!BF15","v":0},{"$f":"iInputExample!BG15","v":0},{"$f":"iInputExample!BH15","v":0},{"$f":"iInputExample!BI15","v":0},{"$f":"iInputExample!BJ15","v":0}]
[]
[null,null,null,null,null,"Inflation Rate - In Use","Switch",null,null,null,{"$f":"iInputExample!K17","v":"Inflation Index 1"}]
[]
[null,null,null,null,null,"FTEs"]
[null,null,null,null,null,"Grade A","#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"iInputExample!AA25","v":5},{"$f":"iInputExample!AB25","v":5},{"$f":"iInputExample!AC25","v":5},{"$f":"iInputExample!AD25","v":5},{"$f":"iInputExample!AE25","v":5},{"$f":"iInputExample!AF25","v":5},{"$f":"iInputExample!AG25","v":5},{"$f":"iInputExample!AH25","v":5},{"$f":"iInputExample!AI25","v":5},{"$f":"iInputExample!AJ25","v":5},{"$f":"iInputExample!AK25","v":5},{"$f":"iInputExample!AL25","v":5},{"$f":"iInputExample!AM25","v":5},{"$f":"iInputExample!AN25","v":5},{"$f":"iInputExample!AO25","v":5},{"$f":"iInputExample!AP25","v":5},{"$f":"iInputExample!AQ25","v":5},{"$f":"iInputExample!AR25","v":5},{"$f":"iInputExample!AS25","v":5},{"$f":"iInputExample!AT25","v":5},{"$f":"iInputExample!AU25","v":5},{"$f":"iInputExample!AV25","v":5},{"$f":"iInputExample!AW25","v":5},{"$f":"iInputExample!AX25","v":5},{"$f":"iInputExample!AY25","v":5},{"$f":"iInputExample!AZ25","v":5},{"$f":"iInputExample!BA25","v":5},{"$f":"iInputExample!BB25","v":5},{"$f":"iInputExample!BC25","v":5},{"$f":"iInputExample!BD25","v":5},{"$f":"iInputExample!BE25","v":5},{"$f":"iInputExample!BF25","v":5},{"$f":"iInputExample!BG25","v":5},{"$f":"iInputExample!BH25","v":5},{"$f":"iInputExample!BI25","v":5},{"$f":"iInputExample!BJ25","v":5}]
[null,null,null,null,null,"Grade B","#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"iInputExample!AA26","v":3},{"$f":"iInputExample!AB26","v":3},{"$f":"iInputExample!AC26","v":3},{"$f":"iInputExample!AD26","v":3},{"$f":"iInputExample!AE26","v":3},{"$f":"iInputExample!AF26","v":3},{"$f":"iInputExample!AG26","v":3},{"$f":"iInputExample!AH26","v":3},{"$f":"iInputExample!AI26","v":3},{"$f":"iInputExample!AJ26","v":3},{"$f":"iInputExample!AK26","v":3},{"$f":"iInputExample!AL26","v":3},{"$f":"iInputExample!AM26","v":3},{"$f":"iInputExample!AN26","v":3},{"$f":"iInputExample!AO26","v":3},{"$f":"iInputExample!AP26","v":3},{"$f":"iInputExample!AQ26","v":3},{"$f":"iInputExample!AR26","v":3},{"$f":"iInputExample!AS26","v":3},{"$f":"iInputExample!AT26","v":3},{"$f":"iInputExample!AU26","v":3},{"$f":"iInputExample!AV26","v":3},{"$f":"iInputExample!AW26","v":3},{"$f":"iInputExample!AX26","v":3},{"$f":"iInputExample!AY26","v":3},{"$f":"iInputExample!AZ26","v":3},{"$f":"iInputExample!BA26","v":3},{"$f":"iInputExample!BB26","v":3},{"$f":"iInputExample!BC26","v":3},{"$f":"iInputExample!BD26","v":3},{"$f":"iInputExample!BE26","v":3},{"$f":"iInputExample!BF26","v":3},{"$f":"iInputExample!BG26","v":3},{"$f":"iInputExample!BH26","v":3},{"$f":"iInputExample!BI26","v":3},{"$f":"iInputExample!BJ26","v":3}]
[null,null,null,null,null,"Grade C","#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"iInputExample!AA27","v":2},{"$f":"iInputExample!AB27","v":2},{"$f":"iInputExample!AC27","v":2},{"$f":"iInputExample!AD27","v":2},{"$f":"iInputExample!AE27","v":2},{"$f":"iInputExample!AF27","v":2},{"$f":"iInputExample!AG27","v":2},{"$f":"iInputExample!AH27","v":2},{"$f":"iInputExample!AI27","v":2},{"$f":"iInputExample!AJ27","v":2},{"$f":"iInputExample!AK27","v":2},{"$f":"iInputExample!AL27","v":2},{"$f":"iInputExample!AM27","v":2},{"$f":"iInputExample!AN27","v":2},{"$f":"iInputExample!AO27","v":2},{"$f":"iInputExample!AP27","v":2},{"$f":"iInputExample!AQ27","v":2},{"$f":"iInputExample!AR27","v":2},{"$f":"iInputExample!AS27","v":2},{"$f":"iInputExample!AT27","v":2},{"$f":"iInputExample!AU27","v":2},{"$f":"iInputExample!AV27","v":2},{"$f":"iInputExample!AW27","v":2},{"$f":"iInputExample!AX27","v":2},{"$f":"iInputExample!AY27","v":2},{"$f":"iInputExample!AZ27","v":2},{"$f":"iInputExample!BA27","v":2},{"$f":"iInputExample!BB27","v":2},{"$f":"iInputExample!BC27","v":2},{"$f":"iInputExample!BD27","v":2},{"$f":"iInputExample!BE27","v":2},{"$f":"iInputExample!BF27","v":2},{"$f":"iInputExample!BG27","v":2},{"$f":"iInputExample!BH27","v":2},{"$f":"iInputExample!BI27","v":2},{"$f":"iInputExample!BJ27","v":2}]
[null,null,null,null,null,"Grade D","#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"iInputExample!AA28","v":1},{"$f":"iInputExample!AB28","v":1},{"$f":"iInputExample!AC28","v":1},{"$f":"iInputExample!AD28","v":1},{"$f":"iInputExample!AE28","v":1},{"$f":"iInputExample!AF28","v":1},{"$f":"iInputExample!AG28","v":1},{"$f":"iInputExample!AH28","v":1},{"$f":"iInputExample!AI28","v":1},{"$f":"iInputExample!AJ28","v":1},{"$f":"iInputExample!AK28","v":1},{"$f":"iInputExample!AL28","v":1},{"$f":"iInputExample!AM28","v":1},{"$f":"iInputExample!AN28","v":1},{"$f":"iInputExample!AO28","v":1},{"$f":"iInputExample!AP28","v":1},{"$f":"iInputExample!AQ28","v":1},{"$f":"iInputExample!AR28","v":1},{"$f":"iInputExample!AS28","v":1},{"$f":"iInputExample!AT28","v":1},{"$f":"iInputExample!AU28","v":1},{"$f":"iInputExample!AV28","v":1},{"$f":"iInputExample!AW28","v":1},{"$f":"iInputExample!AX28","v":1},{"$f":"iInputExample!AY28","v":1},{"$f":"iInputExample!AZ28","v":1},{"$f":"iInputExample!BA28","v":1},{"$f":"iInputExample!BB28","v":1},{"$f":"iInputExample!BC28","v":1},{"$f":"iInputExample!BD28","v":1},{"$f":"iInputExample!BE28","v":1},{"$f":"iInputExample!BF28","v":1},{"$f":"iInputExample!BG28","v":1},{"$f":"iInputExample!BH28","v":1},{"$f":"iInputExample!BI28","v":1},{"$f":"iInputExample!BJ28","v":1}]
[null,null,null,null,null,"Grade E","#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"iInputExample!AA29","v":1},{"$f":"iInputExample!AB29","v":1},{"$f":"iInputExample!AC29","v":1},{"$f":"iInputExample!AD29","v":1},{"$f":"iInputExample!AE29","v":1},{"$f":"iInputExample!AF29","v":1},{"$f":"iInputExample!AG29","v":1},{"$f":"iInputExample!AH29","v":1},{"$f":"iInputExample!AI29","v":1},{"$f":"iInputExample!AJ29","v":1},{"$f":"iInputExample!AK29","v":1},{"$f":"iInputExample!AL29","v":1},{"$f":"iInputExample!AM29","v":1},{"$f":"iInputExample!AN29","v":1},{"$f":"iInputExample!AO29","v":1},{"$f":"iInputExample!AP29","v":1},{"$f":"iInputExample!AQ29","v":1},{"$f":"iInputExample!AR29","v":1},{"$f":"iInputExample!AS29","v":1},{"$f":"iInputExample!AT29","v":1},{"$f":"iInputExample!AU29","v":1},{"$f":"iInputExample!AV29","v":1},{"$f":"iInputExample!AW29","v":1},{"$f":"iInputExample!AX29","v":1},{"$f":"iInputExample!AY29","v":1},{"$f":"iInputExample!AZ29","v":1},{"$f":"iInputExample!BA29","v":1},{"$f":"iInputExample!BB29","v":1},{"$f":"iInputExample!BC29","v":1},{"$f":"iInputExample!BD29","v":1},{"$f":"iInputExample!BE29","v":1},{"$f":"iInputExample!BF29","v":1},{"$f":"iInputExample!BG29","v":1},{"$f":"iInputExample!BH29","v":1},{"$f":"iInputExample!BI29","v":1},{"$f":"iInputExample!BJ29","v":1}]
[]
[null,null,null,null,null,"Annual Salaries by Grade"]
[null,null,null,null,null,"Grade A","£ 2021/22",null,null,null,{"$f":"iInputExample!K33","v":30000}]
[null,null,null,null,null,"Grade B","£ 2021/22",null,null,null,{"$f":"iInputExample!K34","v":32500}]
[null,null,null,null,null,"Grade C","£ 2021/22",null,null,null,{"$f":"iInputExample!K35","v":35000}]
[null,null,null,null,null,"Grade D","£ 2021/22",null,null,null,{"$f":"iInputExample!K36","v":37500}]
[null,null,null,null,null,"Grade E","£ 2021/22",null,null,null,{"$f":"iInputExample!K37","v":50000}]
[]
[null,null,null,null,null,"Calculations"]
[]
[null,null,null,null,null,"Monthly Salaries - Unindexed"]
[null,null,null,null,null,"Grade A Unindexed Salaries","£ 2021/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K29/cstMonthsInYr","v":2500},2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500]
[null,null,null,null,null,"Grade B Unindexed Salaries","£ 2021/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K30/cstMonthsInYr","v":2708.3333333333335},2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335]
[null,null,null,null,null,"Grade C Unindexed Salaries","£ 2021/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K31/cstMonthsInYr","v":2916.6666666666665},2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665]
[null,null,null,null,null,"Grade D Unindexed Salaries","£ 2021/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K32/cstMonthsInYr","v":3125},3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125]
[null,null,null,null,null,"Grade E Unindexed Salaries","£ 2021/22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K33/cstMonthsInYr","v":4166.666666666667},4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667]
[]
[null,null,null,null,null,"Inflation"]
[null,null,null,null,null,"Inflation Rate - In Use","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(AA16:AA17,MATCH($K$19,$F$16:$F$17,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0.01,0,0,0,0,0,0,0,0,0,0,0,0.01,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Inflation Escalation Factor","Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA5=1,(1+AA45),(1+AA45)*Z46)","v":1},{"$f":"IF(AB5=1,(1+AB45),(1+AB45)*AA46)","v":1},1,1,1,1,1,1,1,1,1,1,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.0201,1.0201,1.0201,1.0201,1.0201,1.0201,1.0201,1.0201,1.0201,1.0201,1.0201,1.0201]
[]
[null,null,null,null,null,"Monthly Salaries - Indexed"]
[null,null,null,null,null,"Grade A Indexed Salaries","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA$46*AA38","v":2500},{"$f":"AB$46*AB38","v":2500},2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2525,2525,2525,2525,2525,2525,2525,2525,2525,2525,2525,2525,2550.25,2550.25,{"$f":"BA$46*BA38","v":2550.25},2550.25,2550.25,2550.25,2550.25,2550.25,2550.25,2550.25,2550.25,2550.25]
[null,null,null,null,null,"Grade B Indexed Salaries","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA$46*AA39","v":2708.3333333333335},2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2708.3333333333335,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2735.416666666667,2762.7708333333335,2762.7708333333335,{"$f":"BA$46*BA39","v":2762.7708333333335},2762.7708333333335,2762.7708333333335,2762.7708333333335,2762.7708333333335,2762.7708333333335,2762.7708333333335,2762.7708333333335,2762.7708333333335,2762.7708333333335]
[null,null,null,null,null,"Grade C Indexed Salaries","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA$46*AA40","v":2916.6666666666665},2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2916.6666666666665,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2945.833333333333,2975.2916666666665,2975.2916666666665,{"$f":"BA$46*BA40","v":2975.2916666666665},2975.2916666666665,2975.2916666666665,2975.2916666666665,2975.2916666666665,2975.2916666666665,2975.2916666666665,2975.2916666666665,2975.2916666666665,2975.2916666666665]
[null,null,null,null,null,"Grade D Indexed Salaries","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA$46*AA41","v":3125},3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3187.8125,3187.8125,{"$f":"BA$46*BA41","v":3187.8125},3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125]
[null,null,null,null,null,"Grade E Indexed Salaries","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA$46*AA42","v":4166.666666666667},4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4250.416666666667,4250.416666666667,{"$f":"BA$46*BA42","v":4250.416666666667},4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667]
[]
[null,null,null,null,null,"Monthly Salaries - Total for all FTEs"]
[null,null,null,null,null,"Grade A Indexed Costs","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA49*AA22","v":12500},{"$f":"AB49*AB22","v":12500},12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12625,12625,12625,12625,12625,12625,12625,12625,12625,12625,12625,12625,12751.25,12751.25,12751.25,12751.25,12751.25,12751.25,12751.25,12751.25,12751.25,12751.25,12751.25,12751.25,null,{"$f":"SUMIFS($AA56:$BK56,$AA$6:$BK$6,BL$6)","v":150000},{"$f":"SUMIFS($AA56:$BK56,$AA$6:$BK$6,BM$6)","v":151500},153015]
[null,null,null,null,null,"Grade B Indexed Costs","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA50*AA23","v":8125},8125,8125,8125,8125,8125,8125,8125,8125,8125,8125,8125,8206.25,8206.25,8206.25,8206.25,8206.25,8206.25,8206.25,8206.25,8206.25,8206.25,8206.25,8206.25,8288.3125,8288.3125,8288.3125,8288.3125,8288.3125,8288.3125,8288.3125,8288.3125,8288.3125,8288.3125,8288.3125,8288.3125,null,{"$f":"SUMIFS($AA57:$BK57,$AA$6:$BK$6,BL$6)","v":97500},98475,99459.75]
[null,null,null,null,null,"Grade C Indexed Costs","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA51*AA24","v":5833.333333333333},5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5833.333333333333,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5891.6666666666661,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,5950.583333333333,null,70000.000000000015,{"$f":"SUMIFS($AA58:$BK58,$AA$6:$BK$6,BM$6)","v":70699.999999999985},71407.000000000015]
[null,null,null,null,null,"Grade D Indexed Costs","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA52*AA25","v":3125},3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3125,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3156.25,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,3187.8125,null,37500,37875,38253.75]
[null,null,null,null,null,"Grade E Indexed Costs","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA53*AA26","v":4166.666666666667},4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4166.666666666667,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4208.3333333333339,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,4250.416666666667,null,49999.999999999993,50500.000000000022,51004.999999999993]
[]
[null,null,null,null,null,"Total Staff Costs - Indexed","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA56:AA61)","v":33750},{"$f":"SUM(AB56:AB61)","v":33750},{"$f":"SUM(AC56:AC61)","v":33750},{"$f":"SUM(AD56:AD61)","v":33750},{"$f":"SUM(AE56:AE61)","v":33750},{"$f":"SUM(AF56:AF61)","v":33750},{"$f":"SUM(AG56:AG61)","v":33750},{"$f":"SUM(AH56:AH61)","v":33750},{"$f":"SUM(AI56:AI61)","v":33750},{"$f":"SUM(AJ56:AJ61)","v":33750},{"$f":"SUM(AK56:AK61)","v":33750},{"$f":"SUM(AL56:AL61)","v":33750},{"$f":"SUM(AM56:AM61)","v":34087.5},{"$f":"SUM(AN56:AN61)","v":34087.5},{"$f":"SUM(AO56:AO61)","v":34087.5},{"$f":"SUM(AP56:AP61)","v":34087.5},{"$f":"SUM(AQ56:AQ61)","v":34087.5},{"$f":"SUM(AR56:AR61)","v":34087.5},{"$f":"SUM(AS56:AS61)","v":34087.5},{"$f":"SUM(AT56:AT61)","v":34087.5},{"$f":"SUM(AU56:AU61)","v":34087.5},{"$f":"SUM(AV56:AV61)","v":34087.5},{"$f":"SUM(AW56:AW61)","v":34087.5},{"$f":"SUM(AX56:AX61)","v":34087.5},{"$f":"SUM(AY56:AY61)","v":34428.375},{"$f":"SUM(AZ56:AZ61)","v":34428.375},34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,null,{"$f":"SUM(BL56:BL61)","v":405000},409050,413140.5]
[]
[{"$f":"SUM(AA64:BN64)","v":0},null,null,null,null,"Error Check",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(SUMPRODUCT(AA49:AA53,AA22:AA26) - AA62)<eTol,0,1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(ABS(SUM(AA62:BJ62) - SUM(BL62:BN62))<eTol,0,1)","v":0}]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"Output>>","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"oSummaryExample","index":11,"n_rows":20,"n_cols":66,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z2","v":"Period Start"},{"$f":"SysTime!AA2","v":"2021-04-01"},{"$f":"SysTime!AB2","v":"2021-05-01"},{"$f":"SysTime!AC2","v":"2021-06-01"},{"$f":"SysTime!AD2","v":"2021-07-01"},{"$f":"SysTime!AE2","v":"2021-08-01"},{"$f":"SysTime!AF2","v":"2021-09-01"},{"$f":"SysTime!AG2","v":"2021-10-01"},{"$f":"SysTime!AH2","v":"2021-11-01"},{"$f":"SysTime!AI2","v":"2021-12-01"},{"$f":"SysTime!AJ2","v":"2022-01-01"},{"$f":"SysTime!AK2","v":"2022-02-01"},{"$f":"SysTime!AL2","v":"2022-03-01"},{"$f":"SysTime!AM2","v":"2022-04-01"},{"$f":"SysTime!AN2","v":"2022-05-01"},{"$f":"SysTime!AO2","v":"2022-06-01"},{"$f":"SysTime!AP2","v":"2022-07-01"},{"$f":"SysTime!AQ2","v":"2022-08-01"},{"$f":"SysTime!AR2","v":"2022-09-01"},{"$f":"SysTime!AS2","v":"2022-10-01"},{"$f":"SysTime!AT2","v":"2022-11-01"},{"$f":"SysTime!AU2","v":"2022-12-01"},{"$f":"SysTime!AV2","v":"2023-01-01"},{"$f":"SysTime!AW2","v":"2023-02-01"},{"$f":"SysTime!AX2","v":"2023-03-01"},{"$f":"SysTime!AY2","v":"2023-04-01"},{"$f":"SysTime!AZ2","v":"2023-05-01"},{"$f":"SysTime!BA2","v":"2023-06-01"},{"$f":"SysTime!BB2","v":"2023-07-01"},{"$f":"SysTime!BC2","v":"2023-08-01"},{"$f":"SysTime!BD2","v":"2023-09-01"},{"$f":"SysTime!BE2","v":"2023-10-01"},{"$f":"SysTime!BF2","v":"2023-11-01"},{"$f":"SysTime!BG2","v":"2023-12-01"},{"$f":"SysTime!BH2","v":"2024-01-01"},{"$f":"SysTime!BI2","v":"2024-02-01"},{"$f":"SysTime!BJ2","v":"2024-03-01"},null,{"$f":"SysTime!BL2","v":"2021-04-01"},{"$f":"SysTime!BM2","v":"2022-04-01"},{"$f":"SysTime!BN2","v":"2023-04-01"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"oSummaryExample Sheet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z3","v":"Period End"},{"$f":"SysTime!AA3","v":"2021-04-30"},{"$f":"SysTime!AB3","v":"2021-05-31"},{"$f":"SysTime!AC3","v":"2021-06-30"},{"$f":"SysTime!AD3","v":"2021-07-31"},{"$f":"SysTime!AE3","v":"2021-08-31"},{"$f":"SysTime!AF3","v":"2021-09-30"},{"$f":"SysTime!AG3","v":"2021-10-31"},{"$f":"SysTime!AH3","v":"2021-11-30"},{"$f":"SysTime!AI3","v":"2021-12-31"},{"$f":"SysTime!AJ3","v":"2022-01-31"},{"$f":"SysTime!AK3","v":"2022-02-28"},{"$f":"SysTime!AL3","v":"2022-03-31"},{"$f":"SysTime!AM3","v":"2022-04-30"},{"$f":"SysTime!AN3","v":"2022-05-31"},{"$f":"SysTime!AO3","v":"2022-06-30"},{"$f":"SysTime!AP3","v":"2022-07-31"},{"$f":"SysTime!AQ3","v":"2022-08-31"},{"$f":"SysTime!AR3","v":"2022-09-30"},{"$f":"SysTime!AS3","v":"2022-10-31"},{"$f":"SysTime!AT3","v":"2022-11-30"},{"$f":"SysTime!AU3","v":"2022-12-31"},{"$f":"SysTime!AV3","v":"2023-01-31"},{"$f":"SysTime!AW3","v":"2023-02-28"},{"$f":"SysTime!AX3","v":"2023-03-31"},{"$f":"SysTime!AY3","v":"2023-04-30"},{"$f":"SysTime!AZ3","v":"2023-05-31"},{"$f":"SysTime!BA3","v":"2023-06-30"},{"$f":"SysTime!BB3","v":"2023-07-31"},{"$f":"SysTime!BC3","v":"2023-08-31"},{"$f":"SysTime!BD3","v":"2023-09-30"},{"$f":"SysTime!BE3","v":"2023-10-31"},{"$f":"SysTime!BF3","v":"2023-11-30"},{"$f":"SysTime!BG3","v":"2023-12-31"},{"$f":"SysTime!BH3","v":"2024-01-31"},{"$f":"SysTime!BI3","v":"2024-02-29"},{"$f":"SysTime!BJ3","v":"2024-03-31"},null,{"$f":"SysTime!BL3","v":"2022-03-31"},{"$f":"SysTime!BM3","v":"2023-03-31"},{"$f":"SysTime!BN3","v":"2024-03-31"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z4","v":"Timeline"},{"$f":"SysTime!AA4","v":"Monthly"},{"$f":"SysTime!AB4","v":"Monthly"},{"$f":"SysTime!AC4","v":"Monthly"},{"$f":"SysTime!AD4","v":"Monthly"},{"$f":"SysTime!AE4","v":"Monthly"},{"$f":"SysTime!AF4","v":"Monthly"},{"$f":"SysTime!AG4","v":"Monthly"},{"$f":"SysTime!AH4","v":"Monthly"},{"$f":"SysTime!AI4","v":"Monthly"},{"$f":"SysTime!AJ4","v":"Monthly"},{"$f":"SysTime!AK4","v":"Monthly"},{"$f":"SysTime!AL4","v":"Monthly"},{"$f":"SysTime!AM4","v":"Monthly"},{"$f":"SysTime!AN4","v":"Monthly"},{"$f":"SysTime!AO4","v":"Monthly"},{"$f":"SysTime!AP4","v":"Monthly"},{"$f":"SysTime!AQ4","v":"Monthly"},{"$f":"SysTime!AR4","v":"Monthly"},{"$f":"SysTime!AS4","v":"Monthly"},{"$f":"SysTime!AT4","v":"Monthly"},{"$f":"SysTime!AU4","v":"Monthly"},{"$f":"SysTime!AV4","v":"Monthly"},{"$f":"SysTime!AW4","v":"Monthly"},{"$f":"SysTime!AX4","v":"Monthly"},{"$f":"SysTime!AY4","v":"Monthly"},{"$f":"SysTime!AZ4","v":"Monthly"},{"$f":"SysTime!BA4","v":"Monthly"},{"$f":"SysTime!BB4","v":"Monthly"},{"$f":"SysTime!BC4","v":"Monthly"},{"$f":"SysTime!BD4","v":"Monthly"},{"$f":"SysTime!BE4","v":"Monthly"},{"$f":"SysTime!BF4","v":"Monthly"},{"$f":"SysTime!BG4","v":"Monthly"},{"$f":"SysTime!BH4","v":"Monthly"},{"$f":"SysTime!BI4","v":"Monthly"},{"$f":"SysTime!BJ4","v":"Monthly"},null,{"$f":"SysTime!BL4","v":"Annual"},{"$f":"SysTime!BM4","v":"Annual"},{"$f":"SysTime!BN4","v":"Annual"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z5","v":"Period index"},{"$f":"SysTime!AA5","v":1},{"$f":"SysTime!AB5","v":2},{"$f":"SysTime!AC5","v":3},{"$f":"SysTime!AD5","v":4},{"$f":"SysTime!AE5","v":5},{"$f":"SysTime!AF5","v":6},{"$f":"SysTime!AG5","v":7},{"$f":"SysTime!AH5","v":8},{"$f":"SysTime!AI5","v":9},{"$f":"SysTime!AJ5","v":10},{"$f":"SysTime!AK5","v":11},{"$f":"SysTime!AL5","v":12},{"$f":"SysTime!AM5","v":13},{"$f":"SysTime!AN5","v":14},{"$f":"SysTime!AO5","v":15},{"$f":"SysTime!AP5","v":16},{"$f":"SysTime!AQ5","v":17},{"$f":"SysTime!AR5","v":18},{"$f":"SysTime!AS5","v":19},{"$f":"SysTime!AT5","v":20},{"$f":"SysTime!AU5","v":21},{"$f":"SysTime!AV5","v":22},{"$f":"SysTime!AW5","v":23},{"$f":"SysTime!AX5","v":24},{"$f":"SysTime!AY5","v":25},{"$f":"SysTime!AZ5","v":26},{"$f":"SysTime!BA5","v":27},{"$f":"SysTime!BB5","v":28},{"$f":"SysTime!BC5","v":29},{"$f":"SysTime!BD5","v":30},{"$f":"SysTime!BE5","v":31},{"$f":"SysTime!BF5","v":32},{"$f":"SysTime!BG5","v":33},{"$f":"SysTime!BH5","v":34},{"$f":"SysTime!BI5","v":35},{"$f":"SysTime!BJ5","v":36},null,{"$f":"SysTime!BL5","v":1},{"$f":"SysTime!BM5","v":2},{"$f":"SysTime!BN5","v":3}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z6","v":"Year index"},{"$f":"SysTime!AA6","v":1},{"$f":"SysTime!AB6","v":1},{"$f":"SysTime!AC6","v":1},{"$f":"SysTime!AD6","v":1},{"$f":"SysTime!AE6","v":1},{"$f":"SysTime!AF6","v":1},{"$f":"SysTime!AG6","v":1},{"$f":"SysTime!AH6","v":1},{"$f":"SysTime!AI6","v":1},{"$f":"SysTime!AJ6","v":1},{"$f":"SysTime!AK6","v":1},{"$f":"SysTime!AL6","v":1},{"$f":"SysTime!AM6","v":2},{"$f":"SysTime!AN6","v":2},{"$f":"SysTime!AO6","v":2},{"$f":"SysTime!AP6","v":2},{"$f":"SysTime!AQ6","v":2},{"$f":"SysTime!AR6","v":2},{"$f":"SysTime!AS6","v":2},{"$f":"SysTime!AT6","v":2},{"$f":"SysTime!AU6","v":2},{"$f":"SysTime!AV6","v":2},{"$f":"SysTime!AW6","v":2},{"$f":"SysTime!AX6","v":2},{"$f":"SysTime!AY6","v":3},{"$f":"SysTime!AZ6","v":3},{"$f":"SysTime!BA6","v":3},{"$f":"SysTime!BB6","v":3},{"$f":"SysTime!BC6","v":3},{"$f":"SysTime!BD6","v":3},{"$f":"SysTime!BE6","v":3},{"$f":"SysTime!BF6","v":3},{"$f":"SysTime!BG6","v":3},{"$f":"SysTime!BH6","v":3},{"$f":"SysTime!BI6","v":3},{"$f":"SysTime!BJ6","v":3},null,{"$f":"SysTime!BL6","v":1},{"$f":"SysTime!BM6","v":2},{"$f":"SysTime!BN6","v":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,{"$f":"SysTime!Z7","v":"Relative period"},{"$f":"SysTime!AA7","v":1},{"$f":"SysTime!AB7","v":2},{"$f":"SysTime!AC7","v":3},{"$f":"SysTime!AD7","v":4},{"$f":"SysTime!AE7","v":5},{"$f":"SysTime!AF7","v":6},{"$f":"SysTime!AG7","v":7},{"$f":"SysTime!AH7","v":8},{"$f":"SysTime!AI7","v":9},{"$f":"SysTime!AJ7","v":10},{"$f":"SysTime!AK7","v":11},{"$f":"SysTime!AL7","v":12},{"$f":"SysTime!AM7","v":1},{"$f":"SysTime!AN7","v":2},{"$f":"SysTime!AO7","v":3},{"$f":"SysTime!AP7","v":4},{"$f":"SysTime!AQ7","v":5},{"$f":"SysTime!AR7","v":6},{"$f":"SysTime!AS7","v":7},{"$f":"SysTime!AT7","v":8},{"$f":"SysTime!AU7","v":9},{"$f":"SysTime!AV7","v":10},{"$f":"SysTime!AW7","v":11},{"$f":"SysTime!AX7","v":12},{"$f":"SysTime!AY7","v":1},{"$f":"SysTime!AZ7","v":2},{"$f":"SysTime!BA7","v":3},{"$f":"SysTime!BB7","v":4},{"$f":"SysTime!BC7","v":5},{"$f":"SysTime!BD7","v":6},{"$f":"SysTime!BE7","v":7},{"$f":"SysTime!BF7","v":8},{"$f":"SysTime!BG7","v":9},{"$f":"SysTime!BH7","v":10},{"$f":"SysTime!BI7","v":11},{"$f":"SysTime!BJ7","v":12},null,{"$f":"SysTime!BL7","v":1},{"$f":"SysTime!BM7","v":2},{"$f":"SysTime!BN7","v":3}]
[{"$f":"SUM(A9:A20)","v":0},{"$f":"SUM(B9:B20)","v":0},null,null,null,null,"Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,"See User Guide for QA Limitations"]
[null,null,null,"1. Costs Summary"]
[]
[{"$f":"COUNTBLANK(AA12:BJ12) + COUNTBLANK(BL12:BN12)","v":0},null,null,null,null,"Staff Costs","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA12:BJ12)","v":1227190.5},{"$f":"cCalcExample!AA62","v":33750},{"$f":"cCalcExample!AB62","v":33750},{"$f":"cCalcExample!AC62","v":33750},{"$f":"cCalcExample!AD62","v":33750},{"$f":"cCalcExample!AE62","v":33750},{"$f":"cCalcExample!AF62","v":33750},{"$f":"cCalcExample!AG62","v":33750},{"$f":"cCalcExample!AH62","v":33750},{"$f":"cCalcExample!AI62","v":33750},{"$f":"cCalcExample!AJ62","v":33750},{"$f":"cCalcExample!AK62","v":33750},{"$f":"cCalcExample!AL62","v":33750},{"$f":"cCalcExample!AM62","v":34087.5},{"$f":"cCalcExample!AN62","v":34087.5},{"$f":"cCalcExample!AO62","v":34087.5},{"$f":"cCalcExample!AP62","v":34087.5},{"$f":"cCalcExample!AQ62","v":34087.5},{"$f":"cCalcExample!AR62","v":34087.5},{"$f":"cCalcExample!AS62","v":34087.5},{"$f":"cCalcExample!AT62","v":34087.5},{"$f":"cCalcExample!AU62","v":34087.5},{"$f":"cCalcExample!AV62","v":34087.5},{"$f":"cCalcExample!AW62","v":34087.5},{"$f":"cCalcExample!AX62","v":34087.5},{"$f":"cCalcExample!AY62","v":34428.375},{"$f":"cCalcExample!AZ62","v":34428.375},{"$f":"cCalcExample!BA62","v":34428.375},{"$f":"cCalcExample!BB62","v":34428.375},{"$f":"cCalcExample!BC62","v":34428.375},{"$f":"cCalcExample!BD62","v":34428.375},{"$f":"cCalcExample!BE62","v":34428.375},{"$f":"cCalcExample!BF62","v":34428.375},{"$f":"cCalcExample!BG62","v":34428.375},{"$f":"cCalcExample!BH62","v":34428.375},{"$f":"cCalcExample!BI62","v":34428.375},{"$f":"cCalcExample!BJ62","v":34428.375},null,{"$f":"cCalcExample!BL62","v":405000},{"$f":"cCalcExample!BM62","v":409050},{"$f":"cCalcExample!BN62","v":413140.5}]
[null,null,null,null,null,"Cost Line Item 2 - To be completed","GBP Nominal"]
[null,null,null,null,null,"Cost Line Item 3 - To be completed","GBP Nominal"]
[null,null,null,null,null,"Cost Line Item 4 - To be completed","GBP Nominal"]
[null,null,null,null,null,"Cost Line Item 5 - To be completed","GBP Nominal"]
[]
[{"$f":"IF(ABS(SUM(AA18:BJ18)-SUM(BL18:BN18))<eTol,0,1)","v":0},null,null,null,null,"Total Costs","GBP Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA18:BJ18)","v":1227190.5},{"$f":"SUM(AA12:AA17)","v":33750},{"$f":"SUM(AB12:AB17)","v":33750},33750,33750,33750,33750,33750,33750,33750,33750,33750,33750,34087.5,34087.5,34087.5,34087.5,34087.5,34087.5,34087.5,34087.5,34087.5,34087.5,34087.5,34087.5,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,34428.375,null,405000,409050,413140.5]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"Templates>>","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TimeTemp","index":13,"n_rows":29,"n_cols":66,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z2","v":"Period Start"},{"$f":"SysTime!AA2","v":"2021-04-01"},{"$f":"SysTime!AB2","v":"2021-05-01"},{"$f":"SysTime!AC2","v":"2021-06-01"},{"$f":"SysTime!AD2","v":"2021-07-01"},{"$f":"SysTime!AE2","v":"2021-08-01"},{"$f":"SysTime!AF2","v":"2021-09-01"},{"$f":"SysTime!AG2","v":"2021-10-01"},{"$f":"SysTime!AH2","v":"2021-11-01"},{"$f":"SysTime!AI2","v":"2021-12-01"},{"$f":"SysTime!AJ2","v":"2022-01-01"},{"$f":"SysTime!AK2","v":"2022-02-01"},{"$f":"SysTime!AL2","v":"2022-03-01"},{"$f":"SysTime!AM2","v":"2022-04-01"},{"$f":"SysTime!AN2","v":"2022-05-01"},{"$f":"SysTime!AO2","v":"2022-06-01"},{"$f":"SysTime!AP2","v":"2022-07-01"},{"$f":"SysTime!AQ2","v":"2022-08-01"},{"$f":"SysTime!AR2","v":"2022-09-01"},{"$f":"SysTime!AS2","v":"2022-10-01"},{"$f":"SysTime!AT2","v":"2022-11-01"},{"$f":"SysTime!AU2","v":"2022-12-01"},{"$f":"SysTime!AV2","v":"2023-01-01"},{"$f":"SysTime!AW2","v":"2023-02-01"},{"$f":"SysTime!AX2","v":"2023-03-01"},{"$f":"SysTime!AY2","v":"2023-04-01"},{"$f":"SysTime!AZ2","v":"2023-05-01"},{"$f":"SysTime!BA2","v":"2023-06-01"},{"$f":"SysTime!BB2","v":"2023-07-01"},{"$f":"SysTime!BC2","v":"2023-08-01"},{"$f":"SysTime!BD2","v":"2023-09-01"},{"$f":"SysTime!BE2","v":"2023-10-01"},{"$f":"SysTime!BF2","v":"2023-11-01"},{"$f":"SysTime!BG2","v":"2023-12-01"},{"$f":"SysTime!BH2","v":"2024-01-01"},{"$f":"SysTime!BI2","v":"2024-02-01"},{"$f":"SysTime!BJ2","v":"2024-03-01"},null,{"$f":"SysTime!BL2","v":"2021-04-01"},{"$f":"SysTime!BM2","v":"2022-04-01"},{"$f":"SysTime!BN2","v":"2023-04-01"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"TimeTemp Sheet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z3","v":"Period End"},{"$f":"SysTime!AA3","v":"2021-04-30"},{"$f":"SysTime!AB3","v":"2021-05-31"},{"$f":"SysTime!AC3","v":"2021-06-30"},{"$f":"SysTime!AD3","v":"2021-07-31"},{"$f":"SysTime!AE3","v":"2021-08-31"},{"$f":"SysTime!AF3","v":"2021-09-30"},{"$f":"SysTime!AG3","v":"2021-10-31"},{"$f":"SysTime!AH3","v":"2021-11-30"},{"$f":"SysTime!AI3","v":"2021-12-31"},{"$f":"SysTime!AJ3","v":"2022-01-31"},{"$f":"SysTime!AK3","v":"2022-02-28"},{"$f":"SysTime!AL3","v":"2022-03-31"},{"$f":"SysTime!AM3","v":"2022-04-30"},{"$f":"SysTime!AN3","v":"2022-05-31"},{"$f":"SysTime!AO3","v":"2022-06-30"},{"$f":"SysTime!AP3","v":"2022-07-31"},{"$f":"SysTime!AQ3","v":"2022-08-31"},{"$f":"SysTime!AR3","v":"2022-09-30"},{"$f":"SysTime!AS3","v":"2022-10-31"},{"$f":"SysTime!AT3","v":"2022-11-30"},{"$f":"SysTime!AU3","v":"2022-12-31"},{"$f":"SysTime!AV3","v":"2023-01-31"},{"$f":"SysTime!AW3","v":"2023-02-28"},{"$f":"SysTime!AX3","v":"2023-03-31"},{"$f":"SysTime!AY3","v":"2023-04-30"},{"$f":"SysTime!AZ3","v":"2023-05-31"},{"$f":"SysTime!BA3","v":"2023-06-30"},{"$f":"SysTime!BB3","v":"2023-07-31"},{"$f":"SysTime!BC3","v":"2023-08-31"},{"$f":"SysTime!BD3","v":"2023-09-30"},{"$f":"SysTime!BE3","v":"2023-10-31"},{"$f":"SysTime!BF3","v":"2023-11-30"},{"$f":"SysTime!BG3","v":"2023-12-31"},{"$f":"SysTime!BH3","v":"2024-01-31"},{"$f":"SysTime!BI3","v":"2024-02-29"},{"$f":"SysTime!BJ3","v":"2024-03-31"},null,{"$f":"SysTime!BL3","v":"2022-03-31"},{"$f":"SysTime!BM3","v":"2023-03-31"},{"$f":"SysTime!BN3","v":"2024-03-31"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z4","v":"Timeline"},{"$f":"SysTime!AA4","v":"Monthly"},{"$f":"SysTime!AB4","v":"Monthly"},{"$f":"SysTime!AC4","v":"Monthly"},{"$f":"SysTime!AD4","v":"Monthly"},{"$f":"SysTime!AE4","v":"Monthly"},{"$f":"SysTime!AF4","v":"Monthly"},{"$f":"SysTime!AG4","v":"Monthly"},{"$f":"SysTime!AH4","v":"Monthly"},{"$f":"SysTime!AI4","v":"Monthly"},{"$f":"SysTime!AJ4","v":"Monthly"},{"$f":"SysTime!AK4","v":"Monthly"},{"$f":"SysTime!AL4","v":"Monthly"},{"$f":"SysTime!AM4","v":"Monthly"},{"$f":"SysTime!AN4","v":"Monthly"},{"$f":"SysTime!AO4","v":"Monthly"},{"$f":"SysTime!AP4","v":"Monthly"},{"$f":"SysTime!AQ4","v":"Monthly"},{"$f":"SysTime!AR4","v":"Monthly"},{"$f":"SysTime!AS4","v":"Monthly"},{"$f":"SysTime!AT4","v":"Monthly"},{"$f":"SysTime!AU4","v":"Monthly"},{"$f":"SysTime!AV4","v":"Monthly"},{"$f":"SysTime!AW4","v":"Monthly"},{"$f":"SysTime!AX4","v":"Monthly"},{"$f":"SysTime!AY4","v":"Monthly"},{"$f":"SysTime!AZ4","v":"Monthly"},{"$f":"SysTime!BA4","v":"Monthly"},{"$f":"SysTime!BB4","v":"Monthly"},{"$f":"SysTime!BC4","v":"Monthly"},{"$f":"SysTime!BD4","v":"Monthly"},{"$f":"SysTime!BE4","v":"Monthly"},{"$f":"SysTime!BF4","v":"Monthly"},{"$f":"SysTime!BG4","v":"Monthly"},{"$f":"SysTime!BH4","v":"Monthly"},{"$f":"SysTime!BI4","v":"Monthly"},{"$f":"SysTime!BJ4","v":"Monthly"},null,{"$f":"SysTime!BL4","v":"Annual"},{"$f":"SysTime!BM4","v":"Annual"},{"$f":"SysTime!BN4","v":"Annual"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z5","v":"Period index"},{"$f":"SysTime!AA5","v":1},{"$f":"SysTime!AB5","v":2},{"$f":"SysTime!AC5","v":3},{"$f":"SysTime!AD5","v":4},{"$f":"SysTime!AE5","v":5},{"$f":"SysTime!AF5","v":6},{"$f":"SysTime!AG5","v":7},{"$f":"SysTime!AH5","v":8},{"$f":"SysTime!AI5","v":9},{"$f":"SysTime!AJ5","v":10},{"$f":"SysTime!AK5","v":11},{"$f":"SysTime!AL5","v":12},{"$f":"SysTime!AM5","v":13},{"$f":"SysTime!AN5","v":14},{"$f":"SysTime!AO5","v":15},{"$f":"SysTime!AP5","v":16},{"$f":"SysTime!AQ5","v":17},{"$f":"SysTime!AR5","v":18},{"$f":"SysTime!AS5","v":19},{"$f":"SysTime!AT5","v":20},{"$f":"SysTime!AU5","v":21},{"$f":"SysTime!AV5","v":22},{"$f":"SysTime!AW5","v":23},{"$f":"SysTime!AX5","v":24},{"$f":"SysTime!AY5","v":25},{"$f":"SysTime!AZ5","v":26},{"$f":"SysTime!BA5","v":27},{"$f":"SysTime!BB5","v":28},{"$f":"SysTime!BC5","v":29},{"$f":"SysTime!BD5","v":30},{"$f":"SysTime!BE5","v":31},{"$f":"SysTime!BF5","v":32},{"$f":"SysTime!BG5","v":33},{"$f":"SysTime!BH5","v":34},{"$f":"SysTime!BI5","v":35},{"$f":"SysTime!BJ5","v":36},null,{"$f":"SysTime!BL5","v":1},{"$f":"SysTime!BM5","v":2},{"$f":"SysTime!BN5","v":3}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SysTime!Z6","v":"Year index"},{"$f":"SysTime!AA6","v":1},{"$f":"SysTime!AB6","v":1},{"$f":"SysTime!AC6","v":1},{"$f":"SysTime!AD6","v":1},{"$f":"SysTime!AE6","v":1},{"$f":"SysTime!AF6","v":1},{"$f":"SysTime!AG6","v":1},{"$f":"SysTime!AH6","v":1},{"$f":"SysTime!AI6","v":1},{"$f":"SysTime!AJ6","v":1},{"$f":"SysTime!AK6","v":1},{"$f":"SysTime!AL6","v":1},{"$f":"SysTime!AM6","v":2},{"$f":"SysTime!AN6","v":2},{"$f":"SysTime!AO6","v":2},{"$f":"SysTime!AP6","v":2},{"$f":"SysTime!AQ6","v":2},{"$f":"SysTime!AR6","v":2},{"$f":"SysTime!AS6","v":2},{"$f":"SysTime!AT6","v":2},{"$f":"SysTime!AU6","v":2},{"$f":"SysTime!AV6","v":2},{"$f":"SysTime!AW6","v":2},{"$f":"SysTime!AX6","v":2},{"$f":"SysTime!AY6","v":3},{"$f":"SysTime!AZ6","v":3},{"$f":"SysTime!BA6","v":3},{"$f":"SysTime!BB6","v":3},{"$f":"SysTime!BC6","v":3},{"$f":"SysTime!BD6","v":3},{"$f":"SysTime!BE6","v":3},{"$f":"SysTime!BF6","v":3},{"$f":"SysTime!BG6","v":3},{"$f":"SysTime!BH6","v":3},{"$f":"SysTime!BI6","v":3},{"$f":"SysTime!BJ6","v":3},null,{"$f":"SysTime!BL6","v":1},{"$f":"SysTime!BM6","v":2},{"$f":"SysTime!BN6","v":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,{"$f":"SysTime!Z7","v":"Relative period"},{"$f":"SysTime!AA7","v":1},{"$f":"SysTime!AB7","v":2},{"$f":"SysTime!AC7","v":3},{"$f":"SysTime!AD7","v":4},{"$f":"SysTime!AE7","v":5},{"$f":"SysTime!AF7","v":6},{"$f":"SysTime!AG7","v":7},{"$f":"SysTime!AH7","v":8},{"$f":"SysTime!AI7","v":9},{"$f":"SysTime!AJ7","v":10},{"$f":"SysTime!AK7","v":11},{"$f":"SysTime!AL7","v":12},{"$f":"SysTime!AM7","v":1},{"$f":"SysTime!AN7","v":2},{"$f":"SysTime!AO7","v":3},{"$f":"SysTime!AP7","v":4},{"$f":"SysTime!AQ7","v":5},{"$f":"SysTime!AR7","v":6},{"$f":"SysTime!AS7","v":7},{"$f":"SysTime!AT7","v":8},{"$f":"SysTime!AU7","v":9},{"$f":"SysTime!AV7","v":10},{"$f":"SysTime!AW7","v":11},{"$f":"SysTime!AX7","v":12},{"$f":"SysTime!AY7","v":1},{"$f":"SysTime!AZ7","v":2},{"$f":"SysTime!BA7","v":3},{"$f":"SysTime!BB7","v":4},{"$f":"SysTime!BC7","v":5},{"$f":"SysTime!BD7","v":6},{"$f":"SysTime!BE7","v":7},{"$f":"SysTime!BF7","v":8},{"$f":"SysTime!BG7","v":9},{"$f":"SysTime!BH7","v":10},{"$f":"SysTime!BI7","v":11},{"$f":"SysTime!BJ7","v":12},null,{"$f":"SysTime!BL7","v":1},{"$f":"SysTime!BM7","v":2},{"$f":"SysTime!BN7","v":3}]
[{"$f":"SUM(A9:A29)","v":0},{"$f":"SUM(B9:B29)","v":0},null,null,null,null,"Units",null,"BoA / DL Ref",null,null,null,"Comments"]
[]
[null,null,null,"Section 1"]
[]
[null,null,null,null,"1.1 Sub Section 1.1"]
[]
[null,null,null,null,null,"Sub Heading"]
[]
[null,null,null,null,null,"Label 1","Unit 1",null,"Ref 1"]
[]
[null,null,null,"Section 2"]
[]
[null,null,null,null,"2.1 Sub Section 2.1"]
[]
[null,null,null,null,null,"Sub Heading"]
[]
[null,null,null,null,null,"Label 1","Unit 1",null,"Ref 2"]
[null,null,null,null,null,"Label 2","Unit 1",null,"Ref 3"]
[null,null,null,null,null,"Label 3","Unit 1",null,"Ref 4"]
[null,null,null,null,null,"Label 4","Unit 1",null,"Ref 5"]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"BlankTemp","index":14,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"BlankTemp Sheet"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"}]
[]
[{"$f":"SUM(A9:A28)","v":0},{"$f":"SUM(B9:B28)","v":0}]
[]
[null,null,null,"Section 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"Admin>>","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SysConfig","index":16,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"SysConfig Sheet"}]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"}]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"}]
[]
[{"$f":"SUM(A9:A65)","v":0},{"$f":"SUM(B9:B65)","v":0}]
[]
[null,null,null,"1 General Details"]
[]
[null,null,null,null,"Project Name","SCM Build Template"]
[null,null,null,null,"Contracting Authority","Cabinet Office - Sourcing Programme"]
[null,null,null,null,"IMA Score"]
[null,null,null,null,"Model Developer","TBC - update on 'SysConfig' sheet"]
[null,null,null,null,"Contact Details","sourcing.programme@cabinetoffice.gov.uk"]
[null,null,null,null,"Model Owner","TBC - update on 'SysConfig' sheet"]
[null,null,null,null,"Protective Marking","OFFICIAL"]
[]
[null,null,null,"2 Setup"]
[]
[null,null,null,null,"Model Start Date (dd/mm/yy)","2021-04-01"]
[]
[null,null,null,"3 Lists"]
[null,null,null,null,null,"This section can be used to enter lists (e.g., for Data Validation) that may be required as the SCM is developed"]
[]
[null,null,null,"4 Named Constants"]
[]
[null,null,null,null,"cstThou",1000]
[null,null,null,null,"cstMil",1000000]
[null,null,null,null,"cstDaysInWk",7]
[null,null,null,null,"cstWeeksInYr",52]
[null,null,null,null,"cstMonthsInQtr",3]
[null,null,null,null,"cstMonthsInYr",12]
[]
[null,null,null,"5 Error Check Settings"]
[]
[null,{"$f":"IF(eTol=\"\",1,0)","v":0},null,null,"Error Tolerance",1E-4]
[]
[null,null,null,null,"Error Check Wording",{"$f":"IF(AND(sysChk=0,sysWarn=0),\"All Checks OK\",IF(sysChk<>0,sysChk&\" Error\"&IF(sysChk=1,\" \",\"s \"),\"\")&IF(sysWarn<>0,sysWarn&\" Warning\"&IF(sysWarn=1,\"\",\"s\"),\"\"))","v":"All Checks OK"}]
[]
[null,null,null,"6 Named Ranges List"]
[]
[null,null,null,null,"Name","Address","Purpose"]
[null,null,null,null,"cstDaysInWk","SysConfig!$F$31","Number of days in week constant"]
[null,null,null,null,"cstMil","SysConfig!$F$30","Million constant"]
[null,null,null,null,"cstMonthsInQtr","SysConfig!$F$33","Number of months in quarter constant"]
[null,null,null,null,"cstMonthsInYr","SysConfig!$F$34","Number of months in year constant"]
[null,null,null,null,"cstProjectName","SysConfig!$F$12","Name of Project"]
[null,null,null,null,"cstProtectiveMarking","SysConfig!$F$18","Protective Marking wording"]
[null,null,null,null,"cstThou","SysConfig!$F$29","Thousand constant"]
[null,null,null,null,"cstWeeksInYr","SysConfig!$F$32","Number of weeks in year constant"]
[null,null,null,null,"eTol","SysConfig!$F$38","Error Tolerance constant"]
[null,null,null,null,"rngBoA","BoA-DL'!$F$131:$Y$142","Book of Assumptions / Data Log range"]
[null,null,null,null,"rngBoARowsToAdd","BoA-DL'!$F$129","Book of Assumptions / Data Log number of rows to add range"]
[null,null,null,null,"rngChangeLog","VersionControlLog!$G$71:$V$75","Change Log range"]
[null,null,null,null,"rngContents","Contents!$E$12:$I$25","Contents Page range"]
[null,null,null,null,"rngNamedRanges","SysConfig!$E$44:$G$59","This table"]
[null,null,null,null,"rngNewChange","VersionControlLog!$G$66:$V$67","Change Log new change entry range"]
[null,null,null,null,"sysChk","Contents!$H$27","Number of Errors in model"]
[null,null,null,null,"sysChkWord","SysConfig!$F$40","Master Error Check wording"]
[null,null,null,null,"sysWarn","Contents!$I$27","Number of Warnings in model"]
[null,null,null,null,"INSERT NEW ROWS ABOVE THIS ROW"]
[]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]

{"sheet":"SysTime","index":17,"n_rows":11,"n_cols":66,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,"THIS SHOULD COST MODEL BUILD TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT."]
[null,null,{"$f":"cstProjectName","v":"SCM Build Template"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period Start",{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,Z3+1)","v":"2021-04-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AA3+1)","v":"2021-05-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AB3+1)","v":"2021-06-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AC3+1)","v":"2021-07-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AD3+1)","v":"2021-08-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AE3+1)","v":"2021-09-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AF3+1)","v":"2021-10-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AG3+1)","v":"2021-11-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AH3+1)","v":"2021-12-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AI3+1)","v":"2022-01-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AJ3+1)","v":"2022-02-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AK3+1)","v":"2022-03-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AL3+1)","v":"2022-04-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AM3+1)","v":"2022-05-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AN3+1)","v":"2022-06-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AO3+1)","v":"2022-07-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AP3+1)","v":"2022-08-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AQ3+1)","v":"2022-09-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AR3+1)","v":"2022-10-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AS3+1)","v":"2022-11-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AT3+1)","v":"2022-12-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AU3+1)","v":"2023-01-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AV3+1)","v":"2023-02-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AW3+1)","v":"2023-03-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AX3+1)","v":"2023-04-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AY3+1)","v":"2023-05-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,AZ3+1)","v":"2023-06-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BA3+1)","v":"2023-07-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BB3+1)","v":"2023-08-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BC3+1)","v":"2023-09-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BD3+1)","v":"2023-10-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BE3+1)","v":"2023-11-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BF3+1)","v":"2023-12-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BG3+1)","v":"2024-01-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BH3+1)","v":"2024-02-01"},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),SysConfig!$F$22,BI3+1)","v":"2024-03-01"},null,{"$f":"IF(COLUMN()=COLUMN($BL:$BL),SysConfig!$F$22,BK3+1)","v":"2021-04-01"},{"$f":"IF(COLUMN()=COLUMN($BL:$BL),SysConfig!$F$22,BL3+1)","v":"2022-04-01"},{"$f":"IF(COLUMN()=COLUMN($BL:$BL),SysConfig!$F$22,BM3+1)","v":"2023-04-01"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)&\" Sheet\"","v":"SysTime Sheet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period End",{"$f":"EDATE(AA2,1)-1","v":"2021-04-30"},{"$f":"EDATE(AB2,1)-1","v":"2021-05-31"},"2021-06-30","2021-07-31","2021-08-31","2021-09-30","2021-10-31","2021-11-30","2021-12-31","2022-01-31","2022-02-28","2022-03-31","2022-04-30","2022-05-31","2022-06-30","2022-07-31","2022-08-31","2022-09-30","2022-10-31","2022-11-30","2022-12-31","2023-01-31","2023-02-28","2023-03-31","2023-04-30","2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31",null,{"$f":"EDATE(BL2,cstMonthsInYr)-1","v":"2022-03-31"},{"$f":"EDATE(BM2,cstMonthsInYr)-1","v":"2023-03-31"},"2024-03-31"]
[null,null,{"$f":"IF(ISBLANK(cstProtectiveMarking),\"\",cstProtectiveMarking)","v":"OFFICIAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Timeline","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly",null,"Annual","Annual","Annual"]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",sysChkWord)","v":"All Checks OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period index",{"$f":"IF(COLUMN()=COLUMN($AA:$AA),1,Z5+1)","v":1},{"$f":"IF(COLUMN()=COLUMN($AA:$AA),1,AA5+1)","v":2},3,4,5,{"$f":"IF(COLUMN()=COLUMN($AA:$AA),1,AE5+1)","v":6},7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,null,{"$f":"IF(COLUMN()=COLUMN($BL:$BL),1,BK5+1)","v":1},2,3]
[null,null,{"$f":"HYPERLINK(\"#'Contents'!A1\",\"Click for Contents\")","v":"Click for Contents"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year index",{"$f":"IF(COLUMN()=COLUMN($AA:$AA),1,IF(Z7=cstMonthsInYr,Z6+1,Z6))","v":1},1,1,1,{"$f":"IF(COLUMN()=COLUMN($AA:$AA),1,IF(AD7=cstMonthsInYr,AD6+1,AD6))","v":1},1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,null,1,2,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,"Relative period",{"$f":"IF(COLUMN()=COLUMN($AA:$AA),1,IF(Z7=cstMonthsInYr,1,Z7+1))","v":1},2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,null,1,2,3]
[{"$f":"SUM(A9:A11)","v":0},{"$f":"SUM(B9:B11)","v":0}]
[]
[null,null,null,"Note - the timeline start date is updated on the SysConfig sheet (see Section 2 Setup / Model Start Date)"]
[null,null,null,"END OF WORKSHEET - INSERT ROWS ABOVE"]