{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Planning","Notes","Schedule","RACI","BRAG","Risk"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":39,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Planning","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":"Notes","index":1,"n_rows":233,"n_cols":11,"rows_kept":233,"cut":false,"hidden":false,"merged":[[84,10,84,11],[10,5,10,11],[21,5,21,11],[27,5,27,11],[32,5,32,11],[43,5,43,11],[48,5,48,11],[76,5,76,11],[78,10,78,11],[80,10,80,11],[82,10,82,11],[42,5,42,11],[112,5,112,11],[122,5,122,11],[147,5,147,11],[173,5,173,11],[219,5,219,11]]}
[]
[null,null,null,null,"THIS PLANNING 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,null,null,{"$f":"rngMarking","v":"OFFICIAL"}]
[]
[null,null,null,null,{"$f":"rngProjName","v":"SCM Planning Template"}]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,256)&\" Sheet\"","v":"Notes Sheet"}]
[]
[]
[null,null,null,null,"Context"]
[]
[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 and for public works projects or programmes within the Construction Playbook. 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 further guidance on what SCMs are, why contracting authorities should produce them and how to commission them. More detailed guidance on designing, developing, testing and managing SCMs is available in the SCM Development Guidance. These and other publications, such as HM Treasury’s Macpherson report, Aqua Book and Green Book, will inform key considerations for planning the delivery of SCMs."]
[]
[null,null,null,null,null,"References:"]
[null,null,null,null,null,null,"Sourcing Playbook"]
[null,null,null,null,null,null,"Construction Playbook"]
[null,null,null,null,null,null,"SCM Guidance Note"]
[null,null,null,null,null,null,"SCM Development Guidance"]
[null,null,null,null,null,null,"Macpherson report"]
[null,null,null,null,null,null,"Aqua Book"]
[null,null,null,null,null,null,"Green Book"]
[]
[null,null,null,null,null,"You should consult the Cabinet Office Sourcing Programme for support with this SCM Planning Template, for further information on Should Cost Modelling or before planning an SCM for complex services, projects or programmes via:"]
[null,null,null,null,null,"sourcing.programme@cabinetoffice.gov.uk"]
[]
[]
[null,null,null,null,"What is this Planning Template for?"]
[]
[null,null,null,null,null,"Model planning is an important activity and whilst efforts may be front-loaded it should be seen as an ongoing activity and not a one-off exercise. Effective planning can help to ensure that key activities are not overlooked, that stakeholders are aware of their responsibilities, that delivery risks are understood and managed, that key milestones are clarified, and that expectations are communicated and agreed. See Model Development Lifecycle below (at the bottom of this worksheet).\n\nThis SCM Planning Template can be used as the basis for a Delivery Plan to help plan and manage the delivery of an SCM. It includes Schedule, RACI, BRAG and Risk templates (see below for information on how to use these templates)."]
[]
[]
[null,null,null,null,"Using this SCM Planning Template"]
[]
[null,null,null,null,null,"The individual templates within this SCM Planning Template include example dummy data (see Schedule, RACI, BRAG and Risk sheets), which is for illustrative purposes only. Please delete this data prior to using this SCM Planning Template.\n\nThis SCM Planning Template uses GCF branding for illustrative purposes. Please remove GCF branding and update to reflect the branding of your contracting authority prior to populating it (see 'How do I modify the Planning Template?' below)."]
[]
[null,null,null,null,null,"Update the inputs in the following yellow cells ahead of using this SCM Planning Template:"]
[]
[null,null,null,null,null,"Project Name:",null,null,null,null,"SCM Planning Template"]
[]
[null,null,null,null,null,"Template Owner:",null,null,null,null,"Joe Bloggs"]
[]
[null,null,null,null,null,"Protective Marking:",null,null,null,null,"OFFICIAL"]
[]
[null,null,null,null,null,"This SCM Planning Template uses VBA (Macros) for automation purposes, such as adding rows and columns using '+/-' buttons, as described below. To enable macros:\n\nWindows - 1) Click the File tab; 2) Click Options; 3) Click Trust Centre, and then click Trust Centre Settings; 4) In the Trust Centre, click Macro Settings; 5) Check Trust access to the VBA project object model to enable access to Visual Basic Projects; and 6) Click OK.\n\nMacintosh - 1) Click the Excel menu; 2) Click Preferences…; 3) Click Security under Sharing and Privacy; 4) Ensure ‘Disable all macros without notification’ is not selected under Macro Security; 5) Click Trust access to the VBA project object model; and 6) Close the window."]
[null,null,null,null,null,"If Macros are disabled the automation features will not work and will need to be performed manually. The section below, titled \"How do I modify or manually update this SCM Planning Template?\", provides instructions on how to update or modify this SCM Planning Template manually."]
[]
[]
[null,null,null,null,"How do I use the Schedule template?"]
[]
[null,null,null,null,null,"The Schedule template is used to help plan the delivery of an SCM. It is a simple, partially automated, Gantt chart that enables tasks, events and milestones to be added and phased over time. The timeline can be lengthened or shortened via in-built Macros and the periodicity of the timeline can be changed between daily, weekly, two weekly and four weekly, as required. \n\nWhen planning the delivery of an SCM it is important to consider and allocate sufficient time to the required activities and to be aware of any interdependencies. For example, it may not be possible to undertake all required aspects of Quality Assurance (QA) and testing on an SCM until data has been sourced, manipulated, loaded into the SCM and documented in a Book of Assumptions / Data Log. As a broad 'rule of thumb', the time taken to deliver an SCM should be split equally between planning & designing, developing and testing."]
[]
[null,null,null,null,null,"To use the Schedule template:"]
[null,null,null,null,null,null,"1)","Navigate to the 'Schedule' sheet in this SCM Planning Template;"]
[]
[null,null,null,null,null,null,"2)","Identify the tasks needed to deliver the SCM and the key milestones;"]
[null,null,null,null,null,null,null,null,"This will be informed by the model Scope (and SCM guidance - see above)"]
[]
[null,null,null,null,null,null,"3)","Inc/decrease the number of tasks in the task list as required;"]
[null,null,null,null,null,null,null,null,"Click the +/- buttons at the top of the sheet to inc/decrease"]
[]
[null,null,null,null,null,null,"4)","Set up the schedule timeline (start date, period duration and length);"]
[null,null,null,null,null,null,null,null,"Enter the schedule Start Date (DD/MM/YY) in the yellow cell (cell M11)"]
[null,null,null,null,null,null,null,null,"Select the Timeline Periodicity (e.g. Weekly) in the yellow cell (cell O11)"]
[null,null,null,null,null,null,null,null,"Inc/decrease the number of periods in the timeline (+/- buttons)"]
[]
[null,null,null,null,null,null,"5)","Update task information (phase, description, type, start, duration); and"]
[null,null,null,null,null,null,null,null,"Phase: Enter the task phase (e.g. plan, design, develop, test, use)"]
[null,null,null,null,null,null,null,null,"Task Description: Enter a succinct description of the task"]
[null,null,null,null,null,null,null,null,"Task Colour: Select the display colour for the task (1:10 )"]
[null,null,null,null,null,null,null,null,"Task Start: Select the date that the task is due to start on"]
[null,null,null,null,null,null,null,null,"Periods: Enter the number of periods the task will run for"]
[]
[null,null,null,null,null,null,"6)","Add notes if required (see 'What does everything mean' below for details on how to add notes)."]
[]
[]
[null,null,null,null,"How do I use the RACI template?"]
[]
[null,null,null,null,null,"Producing an SCM will require the involvement of a number of stakeholders and it is important to identify roles and responsibilities early on so that required resources and expectations can be agreed. The RACI template is a simple tool to capture roles and responsibilities and helps to avoid confusion over the model development lifecycle. The RACI acronym stands for:"]
[]
[null,null,null,null,null,"Responsible:",null,null,null,null,"The person who is responsible for doing the work or making the decision required to achieve the task. Typically this is a single person, such as a Model Developer or Quality Assurer. Every task needs at least one responsible person."]
[]
[null,null,null,null,null,"Accountable: ",null,null,null,null,"The person who is accountable for the task being completed appropriately. This must be a single person, such as the Model Senior Responsible Owner (Model SRO)."]
[]
[null,null,null,null,null,"Consulted:",null,null,null,null,"The people who are consulted with and provide information to support delivery of the task, such as Subject Matter Experts. This will typically be a number of people."]
[]
[null,null,null,null,null,"Informed:",null,null,null,null,"The people who are updated on task progress and are impacted by the outcome of the task, such as model Customers. This will typically be a number of people."]
[]
[null,null,null,null,null,"To use the RACI template:"]
[null,null,null,null,null,null,"1)","Navigate to the 'RACI' sheet in this SCM Planning Template;"]
[]
[null,null,null,null,null,null,"2)","Identify the tasks and roles required to deliver the SCM;"]
[null,null,null,null,null,null,null,null,"The tasks will be informed by the Schedule (see above)"]
[null,null,null,null,null,null,null,null,"The stakeholders will be informed by the model Scope"]
[]
[null,null,null,null,null,null,"3)","Inc/decrease the number of tasks and stakeholders as required;"]
[null,null,null,null,null,null,null,null,"Click the +/- buttons at the top of the sheet to inc/decrease"]
[]
[null,null,null,null,null,null,"4)","Add the tasks and names of the stakeholders to the template;"]
[]
[null,null,null,null,null,null,"5)","For each task select the appropriate RACI value for stakeholders; and"]
[null,null,null,null,null,null,null,null,"Each task must have Responsible and Accountable stakeholders"]
[]
[null,null,null,null,null,null,"6)","Add notes if required (see 'What does everything mean' below for details on how to add notes)."]
[]
[null,null,null,null,null,"Note: Task names can be linked to those on other sheets (e.g. the Schedule sheet) using a formula:"]
[null,null,null,null,null,null,"Where task names are linked using a formula the colour of the displayed text will be purple."]
[]
[null,null,null,null,null,"Note: For each task there must be at least one Responsible person and only one Accountable person:"]
[null,null,null,null,null,null,"Where these rules are breached the inbuilt Check will change from \"OK\" to \"!ERR!\" "]
[]
[]
[null,null,null,null,"How do I use the BRAG template?"]
[]
[null,null,null,null,null,"The BRAG template is a tool to help communicate project health, via a simple traffic light system, and identify areas in need of focus (which may change over the model development lifecycle). The BRAG acronym stands for:"]
[]
[null,null,null,null,null,"Blue",null,null,null,null,"Task is Completed"]
[]
[null,null,null,null,null,"Red",null,null,null,null,"Task is Not on Track and/or Major Issues"]
[]
[null,null,null,null,null,"Amber",null,null,null,null,"Task is Mainly on Track and/or Minor Issues"]
[]
[null,null,null,null,null,"Green",null,null,null,null,"Task is On Track"]
[]
[null,null,null,null,null,"The BRAG status can be applied to SCM delivery as a whole although will afford greater utility if applied at a lower level. This could be the at the model development lifecycle Phase level and/or at the individual Task level (see Schedule). The reporting level itself will typically evolve over the course of model development as additional visibility is required. Tolerance thresholds for each BRAG status (e.g. within +/- 5% of plan) should be agreed and applied consistently."]
[]
[null,null,null,null,null,"To use the BRAG template:"]
[null,null,null,null,null,null,"1)","Navigate to the 'BRAG' sheet in this SCM Planning Template;"]
[]
[null,null,null,null,null,null,"2)","Identify the SCM lifecycle phase or task to be included;"]
[null,null,null,null,null,null,null,null,"This will be informed by the Schedule (see above)"]
[]
[null,null,null,null,null,null,"3)","Inc/decrease the number of items in the list as required;"]
[null,null,null,null,null,null,null,null,"Click the +/- buttons at the top of the sheet to inc/decrease"]
[]
[null,null,null,null,null,null,"4)","Update the list (description, comments, due date, BRAG); and"]
[null,null,null,null,null,null,null,null,"Description: Enter a description of the phase or task"]
[null,null,null,null,null,null,null,null,"Comments: Provide a succinct narrative of the delivery status"]
[null,null,null,null,null,null,null,null,"Due Date: Enter the due date for the phase or task"]
[null,null,null,null,null,null,null,null,"BRAG: Select the current status (Blue/Red/Amber/Green)"]
[]
[null,null,null,null,null,null,"5)","Add notes if required (see 'What does everything mean' below for details on how to add notes)."]
[]
[null,null,null,null,null,"Note: Task names can be linked to those on other sheets (e.g. the Schedule sheet) using a formula:"]
[null,null,null,null,null,null,"Where task names are linked using a formula the colour of the displayed text will be purple."]
[]
[]
[null,null,null,null,"How do I use the Risk template?"]
[]
[null,null,null,null,null,"There will inevitably be risks to the delivery of an SCM and identifying and managing them is an important aspect of project management. The Risk template is a simple tool to document and communicate key information associated with these risks."]
[]
[null,null,null,null,null,"To use the Risk Template:"]
[null,null,null,null,null,null,"1)","Navigate to the 'Risk' sheet in this SCM Planning Template;"]
[]
[null,null,null,null,null,null,"2)","Identify the individual risks for inclusion and monitoring;"]
[null,null,null,null,null,null,null,null,"This will be informed by the model Scope"]
[]
[null,null,null,null,null,null,"3)","Inc/decrease the number of risks for inclusion as required;"]
[null,null,null,null,null,null,null,null,"Click the +/- buttons at the top of the sheet to inc/decrease"]
[]
[null,null,null,null,null,null,"4)","Update the information capture fields for each of the risks; and"]
[null,null,null,null,null,null,null,null,"Delivery Risk: Enter a succinct description of the delivery risk"]
[null,null,null,null,null,null,null,null,"Risk Cause: Provide a brief overview of the cause of the risk"]
[null,null,null,null,null,null,null,null,"Impact Narrative: Describe the potential impact of the risk"]
[null,null,null,null,null,null,null,null,"Impact: Select the severity of the impact (low, medium or high)"]
[null,null,null,null,null,null,null,null,"Probability: Select the risk likelihood (low, medium or high)"]
[null,null,null,null,null,null,null,null,"Strategy: Select the management approach (treat or tolerate)"]
[null,null,null,null,null,null,null,null,"Mitigation Plan: Summarise the mitigation plan (if applicable)"]
[null,null,null,null,null,null,null,null,"Risk Owner: Enter the name of the individual who owns the risk"]
[]
[null,null,null,null,null,null,"5)","Add notes if required (see 'What does everything mean' below for details on how to add notes)."]
[]
[]
[null,null,null,null,"How do I modify or manually update this SCM Planning Template?"]
[]
[null,null,null,null,null,"This SCM Planning Template is protected to help reduce the risk of inadvertent corruption when in use. In order to modify it (e.g. to change from GCF to contracting authority branding or to update the protective marking), it will need to be unprotected. Following any modification it is recommended that the SCM Planning Template is re-protected. Unprotecting and Protecting can be undertaken via the included macros or manually, as described below:"]
[]
[null,null,null,null,null,"Using in-built macros to Unprotect and Protect this Planning Template:"]
[null,null,null,null,null,null,"1)","Navigate to the 'Planning' sheet in this SCM Planning Template;"]
[]
[null,null,null,null,null,null,"2)","Click the 'Unprotect' button (bottom right corner of the sheet);"]
[null,null,null,null,null,null,null,"Unprotect",null,"The caption will change to 'Protect' thereafter"]
[]
[null,null,null,null,null,null,"3)","Enter the Password in the form that will open up;"]
[null,null,null,null,null,null,null,null,"By default no password has been set (i.e. \"\")"]
[null,null,null,null,null,null,null,null,"Click 'OK' to Unprotect each of the sheets "]
[null,null,null,null,null,null,null,null,null,"The (row and column) Headings will display"]
[]
[null,null,null,null,null,null,"4)","Make the required changes to this SCM Planning Template;"]
[]
[null,null,null,null,null,null,"5)","Click the 'Protect' button (bottom right corner of the sheet); and"]
[null,null,null,null,null,null,null,"Protect",null,"The caption will change to 'Unprotect' thereafter"]
[]
[null,null,null,null,null,null,"6)","Enter a Password in the form that will open up."]
[null,null,null,null,null,null,null,null,"It is recommended that no password is used"]
[null,null,null,null,null,null,null,null,"Click 'OK' to Protect each of the sheets "]
[null,null,null,null,null,null,null,null,null,"The (row and column) Headings will hide"]
[]
[null,null,null,null,null,"Manually Unprotect and Protect this SCM Planning Template:"]
[null,null,null,null,null,null,"1)","Right-click the tab name of the sheet you want to modify;"]
[null,null,null,null,null,null,null,null,"e.g. 'Schedule' tab at the bottom of the this workbook"]
[]
[null,null,null,null,null,null,"2)","Select 'Unprotect Sheet…' from the popup menu;"]
[null,null,null,null,null,null,null,null,"By default no password is set so the sheet will unlock"]
[null,null,null,null,null,null,null,null,"If a password has been set (not recommended):"]
[null,null,null,null,null,null,null,null,null,"Enter the password in the pop-up form"]
[null,null,null,null,null,null,null,null,null,"Click 'OK' to Unprotect the selected sheet "]
[]
[null,null,null,null,null,null,"3)","Display (row and column) Headings (if required);"]
[null,null,null,null,null,null,null,null,"Go to the View menu and click 'Headings'"]
[]
[null,null,null,null,null,null,"4)","Make the required changes to the unprotected sheet;"]
[]
[null,null,null,null,null,null,"5)","Right-click the sheet that you want to re-protect; and"]
[]
[null,null,null,null,null,null,"6)","Enter a Password in the form that will open up."]
[null,null,null,null,null,null,null,null,"It is recommended that no password is used"]
[null,null,null,null,null,null,null,null,"Click 'OK' to Protect the selected sheet "]
[]
[null,null,null,null,null,"Manually Inc/Decreasing list items (as opposed to using +/- buttons):"]
[]
[null,null,null,null,null,"This SCM Planning Template includes automation Macros for increasing and decreasing the number of list items, the length of the timeline, etc. If Macros are not available in the operating environment the ranges can be modified manually. After Unprotecting the relevant sheet (see above), rows and/or columns can be inserted or removed as required. Rows should only be inserted above the grey line marked \">>> Insert new rows Above this line....\" or new columns inserted to the left of the grey line marked \"<<<\". \n\nNote: If manually inserting rows or columns then any associated formatting and/or formulas will also need to be copied across from adjacent rows or columns as appropriate."]
[]
[]
[null,null,null,null,"What does everything mean?"]
[]
[null,null,null,null,null,"This form can be used to store user Notes. Each Notes button in the workbook stores its own unique set of user Notes. To store user Notes:\r\r1) Enter any required Notes on this form (the current text on this form can be deleted or overwritten) \r2) Click 'OK' to save your Notes. This will automatically close this form but your Notes will be saved\r3) Click 'Cancel' to close this form. This will discard any edits you may have made to your Notes\r4) Click the same Notes button in the Workbook to reopen this form and view your saved Notes \r\rIf user Notes are stored the Notes button in the workbook will display a green '!' symbol. If no user Notes are stored the Notes button in the workbook will be blank or display a grey '!' symbol.\r\rThis form can be moved around the screen by clicking in the title area at the top of this form and dragging it to the required position.","or","",null,"Notes: On selection a form will open to enable notes to be added and/or viewed. A green \"!\" shows where notes have been added."]
[]
[null,null,null,null,null,null," Inputs",null,null,"Cells that are coloured in yellow denote areas where inputs are required as you complete this Planning Template."]
[null,null,null,null,null,null,null,null,null,"Text can be split across rows within a cell using the command 'Option+Enter' (MacBook)/'Alt+Enter' (Windows)"]
[]
[null,null,null,null,null,"+","or","-",null,"Select +/- to add/delete items or periods. Items will be added/deleted at the end of the list. Data deletion cannot be undone."]
[]
[]
[null,null,null,null,"SCM Development Lifecycle"]

{"sheet":"Schedule","index":2,"n_rows":45,"n_cols":56,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"THIS PLANNING TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT. THIS PLANNING TEMPLATE CONTAINS DATA THAT IS FOR ILLUSTRATIVE PURPOSES ONLY. PLEASE REMOVE ILLUSTRATIVE DATA PRIOR TO POPULATING IT. "]
[null,null,null,null,{"$f":"rngMarking","v":"OFFICIAL"}]
[]
[null,null,null,null,{"$f":"rngProjName","v":"SCM Planning Template"}]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,256)&\" Sheet\"","v":"Schedule Sheet"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"        Add/Delete Tasks:",null,null,null,"Schedule Start Date and Timeline Periodicity: ","2021-01-04",null,"Periodicity (Days)",null,null,null,null,null,null,null,null,null,null,null,"Add/Delete Periods:     "]
[]
[null,null,null,null,null,null,null,"Phase / Task Description / Task Colour",null,null,null,null,"Task Start",null,"# of Periods",null,null,"Start/End Period",null,null,null,null,"Task Schedule"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WORKDAY($M$11,(W17*$O$17)-$O$17)","v":"2021-01-04"},"2021-01-05","2021-01-06","2021-01-07","2021-01-08","2021-01-11","2021-01-12","2021-01-13","2021-01-14","2021-01-15","2021-01-18","2021-01-19","2021-01-20","2021-01-21","2021-01-22","2021-01-25","2021-01-26","2021-01-27","2021-01-28","2021-01-29","2021-02-01","2021-02-02","2021-02-03","2021-02-04","2021-02-05","2021-02-08","2021-02-09","2021-02-10","2021-02-11","2021-02-12","2021-02-15","2021-02-16","2021-02-17"]
[]
[null,null,null,null,null,null,null,"Ref","Phase","Task Description","Task Colour",null,"Task Start",null,{"$f":"IF(O11=\"Periodicity (4Wks)\",20,IF(O11=\"Periodicity (2Wks)\",10,IF(O11=\"Periodicity (Wks)\",5,1)))","v":1},null,null,"Start",null,"End",null,null,{"$f":"COLUMN()-COLUMN($W$17)+1","v":1},2,3,4,5,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,"<<<"]
[]
[]
[null,null,null,null,null,"This form can be used to store user Notes. Each Notes button in the workbook stores its own unique set of user Notes. To store user Notes:\r\n\r\n1) Enter any required Notes on this form (the current text on this form can be deleted or overwritten) \r\n2) Click 'OK' to save your Notes. This will automatically close this form but your Notes will be saved\r\n3) Click 'Cancel' to close this form. This will discard any edits you may have made to your Notes\r\n4) Click the same Notes button in the Workbook to reopen this form and view your saved Notes \r\n\r\nIf user Notes are stored the Notes button in the workbook will display a green '!' symbol. If no user Notes are stored the Notes button in the workbook will be blank or display a grey '!' symbol.\r\n\r\nThis form can be moved around the screen by clicking in the title area at the top of this form and dragging it to the required position.",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H20)-ROW(H$20)+1,4),\"1\",\"\")","v":"A"},"Plan","Project Kick Off",10,null,"2021-01-04",null,1,null,null,{"$f":"IF($M20=\"\",0,MATCH($M20,rngTimeLine))","v":1},null,{"$f":"IF(R20=0,0,R20+MAX(0,O20-1))","v":1},null,null,{"$f":"IF(AND($R20<=W$17,$T20>=W$17),1,0)","v":1},{"$f":"IF(AND($R20<=X$17,$T20>=X$17),1,0)","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,"<<<"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H21)-ROW(H$20)+1,4),\"1\",\"\")","v":"B"},"Plan","Model Scoping (Inc. Planning & Resourcing)",2,null,"2021-01-04",null,5,null,null,1,null,{"$f":"IF(R21=0,0,R21+MAX(0,O21-1))","v":5},null,null,1,{"$f":"IF(AND($R21<=X$17,$T21>=X$17),1,0)","v":1},1,1,1,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,null,null,null,null,"",null,"C","Plan","Model Scope Sign-Off",10,null,"2021-01-08",null,1,null,null,5,null,5,null,null,0,0,0,0,1,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,null,null,null,null,"",null,"D","Design","Model Specification & Design",2,null,"2021-01-11",null,5,null,null,6,null,10,null,null,0,0,0,0,0,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"E","Design","Model Specification & Design Sign-Off",10,null,"2021-01-15",null,1,null,null,10,null,10,null,null,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"F","Develop","Model Build",2,null,"2021-01-18",null,9,null,null,11,null,19,null,null,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"G","Develop","Developer Testing",2,null,"2021-01-29",null,2,null,null,20,null,21,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"H","Develop","Draft Model Produced",10,null,"2021-02-02",null,1,null,null,22,null,22,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"I","Develop","User Guide Development",2,null,"2021-02-02",null,2,null,null,22,null,23,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,{"$f":"IF(AND($R28<=AU$17,$T28>=AU$17),1,0)","v":0},0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"J","Develop","User Testing & Feedback",2,null,"2021-02-03",null,2,null,null,23,null,24,null,null,{"$f":"IF(AND($R29<=W$17,$T29>=W$17),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"K","Develop","Model Revisions",2,null,"2021-02-04",null,2,null,null,24,null,25,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"L","Develop","Model Approved for Formal QA and Testing",10,null,"2021-02-05",null,1,null,null,25,null,25,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H32)-ROW(H$20)+1,4),\"1\",\"\")","v":"M"},"Develop","Data Collection & Documentation",2,null,"2021-01-06",null,17,null,null,3,null,19,null,null,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"N","Develop","All Data Received & Reviewed",10,null,"2021-01-28",null,1,null,null,19,null,19,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"O","Develop","Model Population",2,null,"2021-01-22",null,6,null,null,15,null,20,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"P","Develop","Finalise Book of Assumptions / Data Log",2,null,"2021-01-29",null,2,null,null,20,null,21,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"Q","Test","Model Verification",9,null,"2021-02-08",null,5,null,null,26,null,30,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($R36<=AU$17,$T36>=AU$17),1,0)","v":0},1,1,1,1,1,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"R","Test","Model Validation",9,null,"2021-02-08",null,5,null,null,26,null,30,null,null,{"$f":"IF(AND($R37<=W$17,$T37>=W$17),1,0)","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,1,1,1,1,1,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"S","Test","Establish Model Governance Procedures",1,null,"2021-02-08",null,1,null,null,26,null,26,null,null,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,1,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"T","Test","Organise Model Documentation & Filing",1,null,"2021-02-09",null,1,null,null,27,null,27,null,null,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,1,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"U","Test","Prepare for Model Operator and User Training & Handover",1,null,"2021-02-10",null,1,null,null,28,null,28,null,null,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,1,0,0,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"V","Test","Model QA & Usage Sign-Off",10,null,"2021-02-12",null,1,null,null,30,null,30,null,null,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,1,0,0,0,"<<<"]
[null,null,null,null,null,"",null,"W","Use","Model Operator and User Training",1,null,"2021-02-15",null,1,null,null,31,null,31,null,null,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,1,0,0,"<<<"]
[null,null,null,null,null,"",null,"X","Use","Model Handover",10,null,"2021-02-15",null,1,null,null,31,null,31,null,null,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,1,0,0,"<<<"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H44)-ROW(H$20)+1,4),\"1\",\"\")","v":"Y"},null,null,null,null,null,null,null,null,null,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($R44<=AU$17,$T44>=AU$17),1,0)","v":0},0,0,0,0,0,0,0,0,"<<<"]
[null,null,null,null,null,">>>> Insert new rows ABOVE this line (if manually increasing the number of tasks)"]

{"sheet":"RACI","index":3,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"THIS PLANNING TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT. THIS PLANNING TEMPLATE CONTAINS DATA THAT IS FOR ILLUSTRATIVE PURPOSES ONLY. PLEASE REMOVE ILLUSTRATIVE DATA PRIOR TO POPULATING IT. "]
[null,null,null,null,{"$f":"rngMarking","v":"OFFICIAL"}]
[]
[null,null,null,null,{"$f":"rngProjName","v":"SCM Planning Template"}]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,256)&\" Sheet\"","v":"RACI Sheet"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"      Add/Delete Tasks:",null,null,null,null,"  Add/Delete People:"]
[null,null,null,null,null,null,null,"Task Description",null,null,"Check",null,"RACI Stakeholder"]
[]
[null,null,null,null,null,null,null,"Ref","Task Description",null,{"$f":"SUM(K17:K27)","v":0},null,"Mrs Customer","Joe SME","A Developer","Ms Finance","Dr Data","Mrs Verifier","Mr Validator","Ms Model SRO","<<<"]
[]
[]
[null,null,null,null,null,"This form can be used to store user Notes. Each Notes button in the workbook stores its own unique set of user Notes. To store user Notes:\r\n\r\n1) Enter any required Notes on this form (the current text on this form can be deleted or overwritten) \r\n2) Click 'OK' to save your Notes. This will automatically close this form but your Notes will be saved\r\n3) Click 'Cancel' to close this form. This will discard any edits you may have made to your Notes\r\n4) Click the same Notes button in the Workbook to reopen this form and view your saved Notes \r\n\r\nIf user Notes are stored the Notes button in the workbook will display a green '!' symbol. If no user Notes are stored the Notes button in the workbook will be blank or display a grey '!' symbol.\r\n\r\nThis form can be moved around the screen by clicking in the title area at the top of this form and dragging it to the required position.",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H17)-ROW(H$17)+1,4),\"1\",\"\")","v":"A"},"Prepare Model Planning Documents",null,{"$f":"IF(I17=\"\",0,IF(AND(COUNTIF(M17:U17,\"A\")+COUNTIF(M17:U17,\"R/A\")=1,COUNTIF(M17:U17,\"R\")+COUNTIF(M17:U17,\"R/A\")>0),0,1))","v":0},null,"C","C","R","C","C","I","I","A","<<<"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H18)-ROW(H$17)+1,4),\"1\",\"\")","v":"B"},"Collect Model Data",null,{"$f":"IF(I18=\"\",0,IF(AND(COUNTIF(M18:U18,\"A\")+COUNTIF(M18:U18,\"R/A\")=1,COUNTIF(M18:U18,\"R\")+COUNTIF(M18:U18,\"R/A\")>0),0,1))","v":0},null,"I",null,"C","C","R/A",null,null,"I","<<<"]
[null,null,null,null,null,"",null,"C","Develop Model & Undertake Developer Testing",null,0,null,"I","C","R","I","C",null,null,"A","<<<"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H20)-ROW(H$17)+1,4),\"1\",\"\")","v":"D"},"Populate the Model with Data",null,0,null,null,null,"A",null,"R",null,null,null,"<<<"]
[null,null,null,null,null,"",null,"E","Produce Model Documentation",null,0,null,"C",null,"R",null,null,null,null,"A","<<<"]
[null,null,null,null,null,"",null,"F","Undertake User Testing",null,0,null,"R",null,"C",null,null,null,null,"A","<<<"]
[null,null,null,null,null,"",null,"G","Undertake Verification & Validation",null,0,null,"I","C","C",null,"C","R","R","A","<<<"]
[null,null,null,null,null,"",null,"H","Prepare Materials & Processes for Handover",null,0,null,"C",null,"R",null,null,null,null,"A","<<<"]
[null,null,null,null,null,"",null,"I",{"$f":"Schedule!J41","v":"Model QA & Usage Sign-Off"},null,0,null,"R","C","I","I","I","R","R","A","<<<"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H26)-ROW(H$17)+1,4),\"1\",\"\")","v":"J"},null,null,0,null,null,null,null,null,null,null,null,null,"<<<"]
[null,null,null,null,null,">>>> Insert new rows ABOVE this line (if manually increasing the number of tasks)"]

{"sheet":"BRAG","index":4,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"THIS PLANNING TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT. THIS PLANNING TEMPLATE CONTAINS DATA THAT IS FOR ILLUSTRATIVE PURPOSES ONLY. PLEASE REMOVE ILLUSTRATIVE DATA PRIOR TO POPULATING IT. "]
[null,null,null,null,{"$f":"rngMarking","v":"OFFICIAL"}]
[]
[null,null,null,null,{"$f":"rngProjName","v":"SCM Planning Template"}]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,256)&\" Sheet\"","v":"BRAG Sheet"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"   Add/Delete BRAG Items:"]
[null,null,null,null,null,null,null,"Phase or Task Description",null,null,"Comments",null,"Due",null,"BRAG"]
[]
[null,null,null,null,null,null,null,"Ref","Enter Description",null,"Enter Comments",null,"Enter Due Date",null,"Select BRAG"]
[]
[]
[null,null,null,null,null,"This form can be used to store user Notes. Each Notes button in the workbook stores its own unique set of user Notes. To store user Notes:\r\n\r\n1) Enter any required Notes on this form (the current text on this form can be deleted or overwritten) \r\n2) Click 'OK' to save your Notes. This will automatically close this form but your Notes will be saved\r\n3) Click 'Cancel' to close this form. This will discard any edits you may have made to your Notes\r\n4) Click the same Notes button in the Workbook to reopen this form and view your saved Notes \r\n\r\nIf user Notes are stored the Notes button in the workbook will display a green '!' symbol. If no user Notes are stored the Notes button in the workbook will be blank or display a grey '!' symbol.\r\n\r\nThis form can be moved around the screen by clicking in the title area at the top of this form and dragging it to the required position.",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H17)-ROW(H$17)+1,4),\"1\",\"\")","v":"A"},{"$f":"Schedule!J22","v":"Model Scope Sign-Off"},null,"Signed off by Ms Model SRO on 03Jan21",null,"2021-01-08",null,"B"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H18)-ROW(H$17)+1,4),\"1\",\"\")","v":"B"},{"$f":"Schedule!J24","v":"Model Specification & Design Sign-Off"},null,"Approved by Mrs Customer and signed-off by Ms Model SRO on 13Jan21",null,"2021-01-15",null,"B"]
[null,null,null,null,null,"",null,"C",{"$f":"Schedule!J27","v":"Draft Model Produced"},null,"Model is 80% complete",null,"2021-02-02",null,"G"]
[null,null,null,null,null,"",null,"D","Collect Finance Data ",null,"Finance confirmed outstanding data will be provided by 28/01/21",null,"2021-01-28",null,"G"]
[null,null,null,null,null,"",null,"E","Collect Commercial Data",null,"On track",null,"2020-01-28",null,"G"]
[null,null,null,null,null,"",null,"F","Collect Supplier Data",null,"Provided data is not in the expected format and requires manipulation",null,"2021-01-28",null,"A"]
[null,null,null,null,null,"",null,"G",{"$f":"Schedule!J41","v":"Model QA & Usage Sign-Off"},null,"Internal QA team have not confirmed a Verifier for W/C 8 February",null,"2021-02-12",null,"R"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H24)-ROW(H$17)+1,4),\"1\",\"\")","v":"H"},{"$f":"Schedule!J43","v":"Model Handover"},null,"On track subject to completion of QA",null,"2021-02-15",null,"G"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H25)-ROW(H$17)+1,4),\"1\",\"\")","v":"I"}]
[null,null,null,null,null,">>>> Insert new rows ABOVE this line (if manually increasing the number of requirements)"]

{"sheet":"Risk","index":5,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"THIS PLANNING TEMPLATE IS FOR GUIDANCE ONLY. PLEASE REMOVE GCF BRANDING AND UPDATE TO REFLECT THE BRANDING OF YOUR CONTRACTING AUTHORITY PRIOR TO POPULATING IT. THIS PLANNING TEMPLATE CONTAINS DATA THAT IS FOR ILLUSTRATIVE PURPOSES ONLY. PLEASE REMOVE ILLUSTRATIVE DATA PRIOR TO POPULATING IT. "]
[null,null,null,null,{"$f":"rngMarking","v":"OFFICIAL"}]
[]
[null,null,null,null,{"$f":"rngProjName","v":"SCM Planning Template"}]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,256)&\" Sheet\"","v":"Risk Sheet"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"       Add/Delete Delivery Risks:"]
[null,null,null,null,null,null,null,"Delivery Risk",null,null,"Risk Cause",null,"Impact Narrative",null,"Impact",null,"Probability",null,"Strategy",null,"Mitigation Plan",null,"Risk Owner"]
[]
[null,null,null,null,null,null,null,"Ref","Risk Description",null,"Enter Cause",null,"Enter Impact",null,"Select Impact",null,"Select Prob.",null,"Select Strategy",null,"Enter Mitigation Plan",null,"Enter Owner"]
[]
[]
[null,null,null,null,null,"This form can be used to store user Notes. Each Notes button in the workbook stores its own unique set of user Notes. To store user Notes:\r\n\r\n1) Enter any required Notes on this form (the current text on this form can be deleted or overwritten) \r\n2) Click 'OK' to save your Notes. This will automatically close this form but your Notes will be saved\r\n3) Click 'Cancel' to close this form. This will discard any edits you may have made to your Notes\r\n4) Click the same Notes button in the Workbook to reopen this form and view your saved Notes \r\n\r\nIf user Notes are stored the Notes button in the workbook will display a green '!' symbol. If no user Notes are stored the Notes button in the workbook will be blank or display a grey '!' symbol.\r\n\r\nThis form can be moved around the screen by clicking in the title area at the top of this form and dragging it to the required position.",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H17)-ROW(H$17)+1,4),\"1\",\"\")","v":"A"},"Model Scoping is delayed",null,"Commercial finalising the service design",null,"Model delivery may be delayed or features reduced",null,"Med",null,"Med",null,"Treat",null,"Communicate potential impact on model delivery",null,"Ms Model SRO"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H18)-ROW(H$17)+1,4),\"1\",\"\")","v":"B"},"Model Build is delayed",null,"Under estimated development time",null,"Model delivery may be delayed or features reduced",null,"Med",null,"Low",null,"Tolerate",null,"Developer agreed to work weekends if necessary",null,"A Developer"]
[null,null,null,null,null,"",null,"C","Model software incompatibility",null,"Model developed on a Mac for Windows use",null,"Model will not operate on Customer's system",null,"High",null,"Low",null,"Treat",null,"Undertake periodic system testing in development",null,"A Developer"]
[null,null,null,null,null,"",null,"D","Receipt of data from Finance is delayed",null,"Workload increased owing to year end",null,"Would delay Validation if slips by >1 week",null,"Med",null,"Med",null,"Treat",null,"Communicate potential impact on model delivery",null,"Ms Model SRO"]
[null,null,null,null,null,"",null,"E","Receipt of data from Supplier is delayed",null,"Delay in Supplier internal sign-off",null,"Model delivery may be delayed or features reduced",null,"Med",null,"Low",null,"Tolerate",null,"Supplier aware of urgency - no action required",null,"Mrs Customer"]
[null,null,null,null,null,"",null,"F","Commercial unable to provide data",null,"Novel analysis required to generate data",null,"Would require a change to model design",null,"High",null,"Low",null,"Treat",null,"Identify and obtain data from an alternative source",null,"Dr Data"]
[null,null,null,null,null,"",null,"G","Model QA is delayed",null,"Internal QA team are capacity constrained",null,"Model delivery may be delayed",null,"High",null,"Med",null,"Treat",null,"Plan for potential 3rd party assurance",null,"Joe SME"]
[null,null,null,null,null,"",null,"H","Customer cannot support UAT",null,"Substantial ongoing workload",null,"Fail to meet all user preferences but no functional impact",null,"Low",null,"High",null,"Treat",null,"Share periodic drafts with Customer for comment",null,"A Developer"]
[null,null,null,null,null,"",null,{"$f":"SUBSTITUTE(ADDRESS(1,ROW(H25)-ROW(H$17)+1,4),\"1\",\"\")","v":"I"}]
[null,null,null,null,null,">>>> Insert new rows ABOVE this line (if manually increasing the number of risks)"]