{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["0. PCMAF front page","0.1 Acknowledgements","1. Introduction","2. User instructions","3. Model front page","4. Maturity assessment","5. Dashboard","6. Improvement action plan","7. Acronyms","Data Lookup Sheet","Calculations"],"not_rendered":{"charts":9,"images":3,"macros":1,"external_links":2,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"0. PCMAF front page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"0.1 Acknowledgements","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1. Introduction","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"For assistance using this tool, or to suggest improvements, please contact the APM Planning, Monitoring and Control (PM&C) \nSIG chair or committee member. Contact details of the SIG committees can be found on the APM website below."]
[null,null,"apm.org.uk/community/planning-monitoring-and-control-sig"]
[]
[null,null,"Introduction"]
[null,null,"How do you measure an organisation’s capability in implementing and applying project controls across its projects, programmes and portfolios? \n\nThe Project Control Maturity Assessment Framework (PCMAF) is a tool that enables projects to assess their project control maturity throughout a project's life cycle.  The purpose of conducting the project control maturity self-assessment is to ensure that the project is set up, mobilised and on track to support the delivery of the project, ensuring that it supports early action and objective decision making.\n\nThe step-by-step approach enables projects to understand the 'as is' Project Control (PC) position and reference it against a 'to be' position.  The model uses a common framework and can be used for the assessment of a single project or to benchmark and compare the relative strengths of various projects across an organisation.  It gives project control system reviewers a consistent method of assessing projects.\n\nThis document is intended to be used in conjunction with the APM Earned Value Management Handbook.\n\nNote: This initial release of the tool is not specifically targeted at programme- and portfolio-level assessment.  However, with experienced support it can be tailored and interpreted for application at those levels."]
[]
[null,null,"Fundamental concepts"]
[null,null,"The PCMAF is intended to provide a defined means of establishing and improving project control capability.  It is intended to support projects or organisations by improving their project control and supporting processes. \n\nThe project control process should be well-understood throughout a mature project or organisation, usually through documentation and training. The process should be continually monitored and improved.  As a project or organisation improves in PC process maturity, it formalises its processes via policies, standards and organisational structures.  It also entails building an infrastructure and a corporate culture that support the methods practices, and procedures of the project/organisation so they endure after those who originally defined them have moved on."]
[]
[null,null,"How is PCMAF used?"]
[null,null,"In the context of this framework, the PCMAF is a comprehensive and systematic review of a project's control system maturity.  This can be used to aid process improvement by identifying shortfalls against the target standard.  \n\nThe review is conducted using a maturity questionnaire that outlines performance levels against eight key stages of an effective Project Control System (PCS).  A target standard should be established at the outset for project or projects within an organisation. The maturity at the time of review should be related to this target standard. \n\nIt is for individual projects/organisations to set their target standards. These would usually be based on guidelines set by the organisation, optimised to achieve the project requirements. The target to be achieved for the project will be agreed within the organisation and typically will also be guided by the customer needs/requirements and ultimately customer approval.  \n\nThe assessment process allows the project to clearly discern its strengths and areas in which improvements can be made. It should culminate in planned improvement actions which are then monitored for progress.\n\nThe frequency of reviews is a decision for the project or organisation however it is recommended that, upon significant change of scope, projects may need to reassess their project control maturity assessment.\n"]
[]
[null,null,"Benefits"]
[null,null,"Using the PCMAF will deliver a range of benefits, including:\n§ Providing a highly structured, fact-based approach to identify your organisation’s and projects' strengths and areas for improvement through periodic assessment.\n§ Creating a common language and conceptual framework for the way you manage and improve controls on your project and, if applicable, other projects within the organisation.\n§ Reaffirmation of the learning on the fundamental elements of project controls and suitably qualified and experienced person levels of the human resources employed within your project and organisation, and how they relate to their roles and responsibilities.\n§ Involving people at all levels in process improvement.\n§ Ranking project control maturity across projects within an organisation or across the supply chain.  \n§ Facilitating the sharing of best practice across projects within an organisation.\n§ Using it to assess and present the findings from a variety of project controls reviews in a standard format that is easy to understand.  \n§ Facilitating comparisons with other projects.\n§ Supporting the development of your business plan and strategy."]

{"sheet":"2. User instructions","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"For assistance using this tool, or to suggest improvements, please contact the APM Planning, Monitoring and Control (PM&C) \nSIG chair or committee member. Contact details of the SIG committees can be found on the APM website."]
[]
[null,null,"The assessment process"]
[null,null,"There is no single right way to perform the assessment using the maturity grid; the primary factor that determines the right approach for your organisation is the desired outcome from the assessment exercise.  Different approaches deliver different benefits.  Whichever approach is used, the key point to remember is that assessment is about the continual improvement of your project or organisation.  \n\nThe greatest value will be achieved from an assessment if it involves someone who has a working knowledge of the implementation and operation of a project control system.  This ensures that the assessment can be completed with an understanding of the nuances between the different maturity levels for each of the attributes that are scored.\n\nThe assessment can be performed in a number of different ways:\n§ Self-assessment from within the project.\n§ Independent assessment – by reviewers external to the project.\n\nWhile the assessment is valuable, the most critical phase of the process is the post-assessment action planning and implementation. "]
[]
[null,null,"Model front page"]
[null,null,"This page should be completed at the start of the Project Control Maturity Assessment with the relevant information. \n\nThe individual conducting the assessment should agree with the project manager whether a full assessment is to be undertaken, or if it is to focus on a particular stage of the Project Control System.\n\nOnce this is agreed, either select 'Complete Full Maturity Assessment' or click the buttons to select the 'Stage(s)' that have been agreed to be assessed. Once the stages have been selected, only the questions related to those sections will be presented on the 'Maturity Assessment' tab. Additionally, only the results from those stages to be assessed will be presented on the 'Dashboard'.\n\n*Please note: selecting 'RESET Maturity Assessment' will delete all data from the Maturity Assessment tab*"]
[]
[null,null,"Maturity assessment"]
[null,null,"Once the decision has been made on whether to complete a 'Complete Full Assessment' or specific 'Stage(s)', this page will automatically update to provide the relevant information for assessment.  Please note it is recommended that approximately three hours should be scheduled to complete the full assessment. This will ensure a meaningful discussion and presentation of evidence as required. However, this is only a guideline. The most important factors are engaging the correct and right number of people within the project/organisation and ensuring sight of objectively evidenced mature artefacts.\n\nThis PCMAF uses four levels of scoring:\n§ True.\n§ More true than untrue.\n§ More untrue than true.\n§ Untrue.\n\nEach of the Maturity Levels above has an associated scored rating which upon completion of the assessment will be available in the Dashboard report.\n\nNote: there is no weighting of the scoring based on the typical evidence available. These are examples of the artefacts that may be available, but the scoring of the section is subjective based on what is available by the project. \nThe weighted model applied uses scores of 0, 1, 3, 5 from Untrue to True. Unlike other models, weighting '5', for example, does not mean 'best in class', it means the statement is True."]
[]
[null,null,"Dashboard"]
[null,null,"Once a maturity assessment has been undertaken, the results will be detailed on the Dashboard page.\n\nThe results will graphically depict areas of shortfall in the level of assessed Project Control Maturity against the tool's targeted maturity level.\n\nThese areas of shortfall can then be identified and inputted into the 'Improvement Action Plan', in order to develop a targeted plan focused on improving the project control maturity to the required level."]
[]
[null,null,"Improvement action plan"]
[null,null,"Having completed the assessment and diagnostic review of the Dashboard, you may care to consider the following questions:\n§ What identified strengths must we maintain to maximum effect?\n§ What identified strengths should we develop and exploit even further?\n§ What identified areas for improvement do we acknowledge, but will not pursue because they are not key to our business?\n§ What identified areas for improvement do we acknowledge and see as paramount for us to address?\n§ How are we going to monitor progress against the agreed improvement actions?\n\nThe actions that are identified should be captured in the Improvement Action Plan, with clearly defined responsibility and timescales for their implementation.  \n\nTo input a new action, please select the maturity area that requires improvement from the embedded dropdown list. This will then automatically populate the remaining information that has been prepopulated in the Maturity Assessment sheet. You will then need to input details in the remaining columns. These will contain specific details regarding the action required, ownership, date requirements and current status."]
[]
[null,null,"Acronyms"]
[null,null,"This page provides a list of the acronyms and definitions used throughout the Project Control Maturity Assessment Framework. If you require further definitions, please refer to please refer to the APM Body of Knowledge, 7th edition."]

{"sheet":"3. Model front page","index":4,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,3,38,17],[2,1,3,19],[37,7,37,13],[11,2,11,7],[10,2,10,7],[9,2,9,7],[8,2,8,7],[7,2,7,7],[11,8,11,11],[10,8,10,11],[9,8,9,11],[8,8,8,11],[7,8,7,11]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"PROJECT TITLE:",null,null,null,null,null,"Super-Duper Project"]
[null,null,"PROJECT MANAGER:",null,null,null,null,null,"A. N. Other"]
[null,null,"PROJECT CONTROL PROJECT LEAD:",null,null,null,null,null,"Clever 1"]
[null,null,"INDEPENDENT ASSESSOR LEAD:",null,null,null,null,null,"Clever 2"]
[null,null,"SELF-ASSESSMENT COMPLETION DATE:",null,null,null,null,null,"2018-05-09"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Assessment broken down into modules"]
[null,null,null,"*Please note: selecting \"RESET Maturity Assessment\" will delete all data from the maturity assessment tab*"]

{"sheet":"4. Maturity assessment","index":5,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[26,4,26,5],[51,4,51,5],[45,4,45,5],[37,4,37,5],[63,4,63,5],[57,4,57,5],[58,2,62,2],[64,2,68,2],[26,2,26,3],[37,2,37,3],[38,2,44,2],[45,2,45,3],[46,2,50,2],[51,2,51,3],[57,2,57,3],[63,2,63,3],[6,4,6,5],[2,10,3,10],[15,4,15,5],[2,2,2,7],[15,2,15,3],[16,2,25,2],[27,2,36,2],[52,2,56,2],[5,2,5,3],[6,2,6,3],[7,2,14,2]]}
[]
[]
[null,null,"  Project Control Maturity Assessment Framework ",null,null,null,null,null,"Assessment\ncompleted:",{"$f":"'3. Model front page'!I12","v":"2018-05-09"}]
[null,null,null,null,null,null,null,null,"PROJECT TITLE:",{"$f":"VLOOKUP(I4,'3. Model front page'!C:I,7,0)","v":"Super-Duper Project"}]
[]
[null,null,"Maturity area",null,"Maturity statements","Typical evidence\n (not all listed items needed in every instance. For examples of typical evidence tools and templates, please refer to the APM website)","Current maturity level","Target maturity \nlevel","Date to meet target level","Comments including evidence",null,null,null,null,"Show/Hide"]
[null,null,"Stage 0 - Culture and environment",null,"The organisational culture and environment that projects are delivered within have a significant impact on the ability to establish effective project controls that facilitate successful project delivery.",null,null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,{"$f":"Stage0Show","v":"show"}]
[null,null,"Stage 0 - Culture and environment","PCS sponsorship","The Project Control System (PCS) Sponsor provides strategic and visible support, establishing clear direction across the organisation and its supply chains.","The following are available and can be demonstrated by the project team: \n\n§ Communications strategy and plan for engagement of sponsor on the project.\n§ Evidence of engagement of sponsor with the project's internal and external stakeholders in relation to project controls, including formal communications and attendance at reviews.\n§ Ongoing assessment of the PCS value and benefits, including monitoring improvement actions where required.\n",null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,"show","Data"]
[null,null,null,"Project stakeholder engagement","All stakeholders are engaged in the Project Control processes and their application throughout the project life cycle.","The following are available and can be demonstrated by the project team: \n\n§ Stakeholder Management Plan documented and applied, and stakeholders engaged with project reviews/events as identified in the Plan.\n§ Communication Plan documented, including planned communications, and evidence that planned communications are being delivered.\n§ Project management and all other applicable functions clearly engaged in importance of applying PCS.",null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,"show","Data"]
[null,null,null,"Project control roles","The project controllers are embedded and integrated into the project team with fully defined roles and responsibilities. They are actively involved in influencing project decisions.","The following are available and can be demonstrated by the project team: \n\n§ Documented roles and responsibilities (terms of reference/role descriptions) for project control staff and project staff with project control responsibilities.\n§ Clear evidence that project controllers are included in all appropriate project meetings and reviews, including via formal meeting terms of reference and attendance lists.\n§ Integration and understanding of all stakeholders interfacing with the PCS.\n",null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,"show","Data"]
[null,null,null,"Project control competencies","Required project control competencies are defined.   Coordinated, funded training provides consistency in the PCS approach and all team members have been sufficiently trained to fulfil their role and continual development approaches are in place.","The following are available and can be demonstrated by the Project team: \n\n§ Competency assessments of the project team's knowledge and experience of all areas of project controls have been completed.\n§ Staff development plans established and implemented at individual and team level.\n§ Training and development delivered, covering both generic project control practices and training specific to the system applied by the project.\n§ Continual improvements being identified by project control staff as their knowledge increases. \n§ Alignment of project control competencies to industry recognised standards from organisations such as APM, PMI etc.\n",null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,"show","Data"]
[null,null,null,"Project control system application and assurance","PCS processes, integrated tools/systems and guidance are documented and applied, and their application assured.","The following are available and can be demonstrated by the project team: \n\n§ Project management plan (or where applicable, a specific project control management plan) outlining how controls will be applied on the project and assurance against them achieved.\n§ Project control process overview/system architecture documented and applied.\n§ All processes for the project control system are documented and applied covering the key elements of project control (including organisation, structures, estimating, scheduling, resourcing, budgeting, work authorisation, subcontract management, materials, managerial analysis, performance review, change control, risk/assumption/issue/dependency/opportunity management, action management and earned value management where appropriate) and applied on the project.\n§ Quality assurance policy/quality management plan.\n§ Audit schedule and evidence of outputs.\n",null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,"show","Data"]
[null,null,null,"Project control system reviews","Projects actively undertake a mix of self-assessment, peer and independent PCS reviews, including such as the PCMAF, integrated baseline reviews, demonstration reviews and surveillance reviews.","The following are available and can be demonstrated by the Project team: \n\n§ Plan for system reviews included within the project management plan (or project control management plan where available)\n§ Reviews are included in the schedule\n§ Reports available from completed reviews\n§ Improvement plans established and being implemented\n§ Evidence of closure of corrective actions",null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,"show","Data"]
[null,null,null,"Continuous improvement and learning","Through the delivery of projects and application of processes, tools and guidance, the organisation continuously improves and applies learning to future projects. Root cause analysis is performed and corrective actions are implemented when process issues are identified.","The following are available and can be demonstrated by the Project team: \n\n§ Evidence of lessons learned workshops/events completed and the output recorded.\n§ Evidence of learning and knowledge sharing, including lessons learned briefs and revision to process/ways of working.\n§ Lessons learned applied across projects.\n§ Evidence that learning is seen as an essential part of the organisation (evidenced by such as a statement/policy on organisational learning).\n§ Communities of Practice/Interest are operating for all areas of project control, with representation from the project.",null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,"show","Data"]
[null,null,null,"Project closure","The approach to project closure is defined and applied at pre-defined project phases.","The following are available and can be demonstrated by the project team:\n\n§ Work packages within the WBS define the scope and outputs associated with closing the project.\n§ Schedule that defines the project closure activities and resources required.\n Project closure records aligned with the defined process covering stages 1-7.\n",null,null,null,null,"Stage 0 - Culture & Environment",null,null,null,"show","Data"]
[null,null,"Stage 1 - Organisation",null,"The organisation process is concerned principally with ensuring that each part of the project is properly established with clear scope and accountability for delivery.\n",null,null,null,null,null,"Stage 1 - Organisation",null,null,null,{"$f":"Stage1Show","v":"show"}]
[null,null,"Stage 1 - Organisation","Scope definition ","The project should have a clear vision and scope, based on a definition of requirements that is robust and documented.  This should include user/customer requirements and traceability between them and the project scope.","The following are available and can be demonstrated by the project team: \n\n§ Clear identification of deliverables (see Product Breakdown Structure) and unambiguous acceptance criteria/events for each. \n§ Emphasis on what is required rather than how it will be achieved. \n§ Contract/project statement of work.\n§ Closure acceptance criteria.",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Project level authorisation","The project has received full formal authorisation for the scope, deliverables, budget, assumptions, exclusions, risk and opportunities which are to be managed/delivered by the project manager.","The following are available and can be demonstrated by the project team: \n\n§ Endorsed project mandate.\n§ Internal/corporate authorisation/approval to proceed, clearly reflecting the scope definition.\n§ Commercial Work Authorisation document is available for the project.\n§ Approved business case.",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Product breakdown structure (PBS)","The project PBS is defined and documented and enables traceability to the customer requirements.","The following are available and can be demonstrated by the project team: \n\n§ Full scope of project deliverable(s) articulated and broken down to an appropriate level of granularity permitting planning, monitoring and control of the deliverable(s).\n§ The PBS is documented and is up to date with any accepted changes to project scope.\n\nNote: The PBS is likely to form a key part of the scope definition.\n",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Work breakdown structure (WBS) ","Authorised project scope is defined and decomposed against the WBS, demonstrating traceability to customer requirements and project objectives and is documented in an auditable way.","The following are available and can be demonstrated by the project team: \n\n§ A single WBS is used on the project and is extended to the level necessary for monitoring and control.\n§ The WBS captures all work scope to be performed, including supplier scope and any revisions resulting from authorised changes.\n§ The Work Breakdown Structure and WBS Dictionaries for the project are documented.\n§ A compliance matrix mapping the customer requirements to the WBS, and PBS where appropriate.\n§ WBS is aligned to PBS, where they both exist.\n",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Organisational breakdown structure (OBS) ","The project OBS is defined and documented, including the major suppliers responsible for accomplishing the authorised work.  ","The following are available and can be demonstrated by the project team: \n\n§ Single OBS used on the project is documented.\n§ Major suppliers are understood and included in OBS.",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Responsibility assignment matrix (RAM)","The project RAM is defined and documented, mapping the WBS to the OBS.","The following are available and can be demonstrated by the project team:\n\n§ Each WP is assigned to a single person directly responsible for the work identifiable in a single element of the WBS. \n§ RAM is documented and covers the full scope of the distributed budget of the project.",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Roles and responsibilities","The project can clearly demonstrate roles and responsibilities across the organisation for delivering the scope of work at the appropriate level. ","The following are available and can be demonstrated by the project team: \n\n§ Clear methodology is deployed for defining roles and responsibilities for all stakeholders (including suppliers) within the project, e.g., RACI.\n§ Roles and responsibilities are adhered to.\n§ Roles and responsibilities for the project team are recorded and aligned to the RAM.\n§ Roles and responsibilities are periodically reviewed to ensure that they remain valid.\n",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Resource breakdown structure (RBS)","The project RBS is defined and documented, including the major subcontractors responsible for accomplishing the authorised work and enables identification of critical resources. ","The following are available and can be demonstrated by the project team: \n\n§ Project resources are defined and broken down to an appropriate level of granularity, permitting planning (especially of critical resources) and subsequent monitoring & control.\n§ The RBS is documented and is up to date with any accepted changes.",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Cost breakdown structure (CBS)","The project CBS is defined and documented to an appropriate level of detail to enable budgets to be set, costs to be collected, monitored and controlled.   ","The following are available and can be demonstrated by the project team: \n\n§ Costs are organised into a CBS where different levels disaggregate cost into increasingly detailed categories, e.g., labour, materials, management, overhead, administration, fees.\n§ The CBS should include all project costs, including management reserve/contingency.\n§ The CBS is documented and is up to date with any accepted changes.\n",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,null,"Breakdown structure alignment","Project planning, scheduling, budgeting, work authorisation and cost are aligned with each other via the breakdown structures.   Where used, the PBS, WBS, OBS, RBS, CBS are aligned at work/ planning package level.","The following are available and can be demonstrated by the project team:\n\n§ The totality of the data set is the same no matter how the data is cut (e.g. by WBS, OBS, etc).",null,null,null,null,"Stage 1 - Organisation",null,null,null,"show","Data"]
[null,null,"Stage 2 - Scheduling and resourcing",null,"The scheduling and resourcing process covers the activities necessary to generate a full set of project schedules with network logic. The process encompasses the integrated time phased allocation of project resources to work and provides a means of measuring progress against effort. ",null,null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,{"$f":"Stage2Show","v":"show"}]
[null,null,"Stage 2 - Scheduling and resourcing","Major schedule and resource assumptions","The assumptions underpinning the schedule and resources are captured, documented and controlled.","The following are available and can be demonstrated by the project team:\n\n§ Schedule and resource assumptions captured in a log that is under configuration control.\n§ Regular review of the schedule and resource assumptions as part of the update cycle.\n§ Cohesion between schedule and resource assumptions and overall project assumptions.\n§ Schedule and resource assumptions definition and maintenance process documented and applied.\n",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Schedule hierarchy structure","The project has a documented schedule hierarchy in place, which clearly defines the purpose and ownership of each level.","The following are available and can be demonstrated by the project team:\n\n§ Schedule hierarchy definition and control process documented including supporting rationale.\n§ The density of each schedule in the hierarchy is appropriate for the target audience.\n§ Schedule hierarchy implemented and under baseline control.\n",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Detail of the schedule","The schedule is planned at an appropriate level of detail to provide visibility of key deliverables and can be mapped to the PBS, WBS, OBS, RBS and CBS levels that support informed decision making."," The following are available and can be demonstrated by the project team:\n\n§ Level of detail allows methods for assessing performance (e.g.  EVTs) to be defined such that they support informed decision making.\n§ The schedule provides visibility of key deliverables.\n§ The schedule reflects all work to be accomplished, including supplier effort and critical and/or high-value material. OBS is assigned.\n§ Mapping of all the breakdown structures to the schedule is defined.\n§ Objective measures of performance assessment are used where possible.\n§ Material budgets are separated from the other cost elements for visibility of performance.",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Integrating supplier schedules","The supplier schedules are integrated appropriately."," The following are available and can be demonstrated by the project team:\n\n§ A process is defined for the integration of supplier schedules and progress into the project schedule at a level of detail to enable decision making.\n§ The project schedule is consistent with the supplier schedule(s) in terms of time phasing, logic-linking and dependencies.\n§ There is a clearly defined and implemented process for translating supplier-reported progress into progress reported against the baseline.\n§ The level of detail of supplier work in the schedule supports effective management.",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Defining work/planning packages (WP/PPs)","Work is disaggregated into WPs and/or PPs.  Each WP/PP is fully defined and controlled.","The following are available and can be demonstrated by the project team:\n\n§ Process for work and planning package definition and control is documented.\n§ WP/PPs are scoped, scheduled, resourced and budgeted/valued.\n§ Risks and opportunities relevant to each WP/PP are defined\n§ WP/PPs represent the scope of work at the level where performance is measured or aggregated.     \n§ Each WP/PP is clearly distinguishable from all other WP/PPs.        \n§ Each WP/PP is assigned to a single organisational element.\n\nWPs contain sufficient information to permit appropriate monitoring and control of the work, whereas PPs will be held at a summary level of detail.\n",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Schedule resource allocation ","The schedule is resourced (e.g. people, plant and equipment, facilities, suppliers), differentiating between internal and external resources. It considers resource constraints.","The following are available and can be demonstrated by the project team:\n\n§ Resources are defined at sufficient granularity to allow effective (i) resource planning and levelling,  and (ii) scheduling, monitoring and control of work.\n§ Peak resource requirements are understood.\n§ Specialist resource (e.g. equipment) demands are being managed.",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Integration of milestones","All customer and project milestones are fully integrated into the activity logic of the schedule. All milestones are clearly defined and have unambiguous acceptance criteria.","The following are available and can be demonstrated by the project team:\n\n§ Milestones, contractual events, decision points and interfaces (internal and external) are logically linked within the network schedule to support critical path analysis.\n§ Each milestone is fully defined (e.g. through milestone definition sheets) in terms of milestone description, date, parties involved in achieving the milestone and acceptance (of completion) criteria.",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Float","Float contained within the schedule is understood and justifiable, and used as part of the decision-making processes.","The following are available and can be demonstrated by the project team:\n\n§ Project control process defines how float will be monitored and reported.\n§ Total float between baseline schedule and contract milestones is known and understood.\n§ Float use is monitored and relevance to work criticality understood.",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Schedule integration","The schedules are vertically and horizontally integrated through defined logic links or interface points (inputs and outputs), enabling critical path analysis across customer, project and supplier schedules.","The following are available and can be demonstrated by the project team:\n\n§ The network schedule depicts the sequence of all the work scope (horizontal integration) and clearly identifies the significant interdependencies that are indicative of the actual way the work is planned and is to be accomplished.\n§ There is vertical schedule integration, i.e. there is consistency of data between various levels of schedules, including supplier schedules.",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,null,"Schedule risk analysis","The schedule considers the risks and opportunities that may impact delivery, to establish the level of confidence in the baseline.","The following are available and can be demonstrated by the project team:\n\n§ Key schedule risk mitigations have been identified and included in the baseline schedule where appropriate.\n§ Quantitative Schedule Risk Analysis (QSRA), that considers duration uncertainty and risk, has been performed as part of setting the baseline, taking into account the risk appetite.\n",null,null,null,null,"Stage 2 - Scheduling & Resourcing",null,null,null,"show","Data"]
[null,null,"Stage 3 - Budgeting and work authorisation",null,"The budgeting and work authorisation process ensures that all contract work scope, appropriate budgets and schedules are identified, integrated and incorporated into Work Package Plans so as to provide the basis for cost and schedule performance measurement.  The authorisation process ensures that the entire scope of the project work is allocated to responsible individuals in a controlled manner.   \n",null,null,null,null,null,"Stage 3 - Budgeting & Work Authorisation",null,null,null,{"$f":"Stage3Show","v":"show"}]
[null,null,"Stage 3 - Budgeting and work authorisation","Basis of estimate","A formal structured estimate (covering, e.g. resources; material and consumables; suppliers) has been generated following standard estimating procedures. ","The following are available and can be demonstrated by the project team:\n\n§ The estimation process is documented and configuration controlled.\n§ All estimating dependencies, assumptions, risks, exclusions and opportunities are fully documented. \n§ The estimate has been reviewed and approved.\n§ Any changes to estimates are documented and agreed (change log evidence). \n§ Traceability back to validated norms.\n",null,null,null,null,"Stage 3 - Budgeting & Work Authorisation",null,null,null,"show","Data"]
[null,null,null,"Project budget","The project budget is accounted for and controlled and can be traced back to estimates and supplier contracts.","The following are available and can be demonstrated by the project team:\n\n§ Documented process is in place to manage the budget.\n§ Budget profile is aligned to schedule dates.\n§ Budget baseline is under change control, with evidence that any amendments have associated change documentation.\n§ Value of supplier contracts is consistent with the associated value in the budget baseline.\n§ Total allocated budgets reconcile to the sum of the budgets.\n\nThe project budget can include indirects, Undistributed budget (UB) and Management reserve (MR).\n",null,null,null,null,"Stage 3 - Budgeting & Work Authorisation",null,null,null,"show","Data"]
[null,null,null,"Indirect management (Overheads)","The processes for the management and control of indirect costs are defined and implemented, and are accounted for within the project baselines.","The following are available and can be demonstrated by the project team:\n\n§ Process for overheads documented and configuration controlled.\n§ Organisation chart identifying managers responsible for indirect cost control. \n§ Indirect budgets established and projected, based on published rates for each business which has authority to incur overhead costs.  \n§ Indirect budgets are incorporated into the project baseline(s) and reconcile with cost system.\n§ Internal project reports for indirect budgets and performance.\n",null,null,null,null,"Stage 3 - Budgeting & Work Authorisation",null,null,null,"show","Data"]
[null,null,null,"Undistributed budget (UB)","Undistributed Budget (UB) has been identified and can be substantiated in relation to the baseline.","The following are available and can be demonstrated by the project team:\n\n§ UB has a defined scope that is separately identified.\n§ UB has been included in the baseline budget.",null,null,null,null,"Stage 3 - Budgeting & Work Authorisation",null,null,null,"show","Data"]
[null,null,null,"Management reserve (MR)","Management Reserve (MR) has been identified and can be substantiated. ","The following are available and can be demonstrated by the project team:\n\n§ The MR budget is documented and changes to it managed via change control.\n§ Exposure against MR for the project is understood and identified via Risk and Opportunity Register. \n§ The Risk and Opportunity Register is underpinned by cost/schedule risk assessment/analysis including uncertainty, previous project outturns and industry norms.\n§ MR has no scope defined.\n§ Within an earned value management (EVM) system, MR is separately identified outside of the performance measurement baseline (PMB).\n",null,null,null,null,"Stage 3 - Budgeting & Work Authorisation",null,null,null,"show","Data"]
[null,null,null,"Performance measurement baseline (PMB)","A configuration controlled baseline has been established for the project (covering scope, schedule, cost and risk) for performance measurement and change control.","The following are available and can be demonstrated by the project team:\n\n§ The PMB is time-phased in alignment with the schedule, with budget distributed in accordance with the accounting calendar for the authorised work scope. \n§ The PMB for the project is known and understood in terms of value and overall duration.\n§ The Work Package Planned Value (PV) in the schedule aligns with the Budget at Completion (BAC).\n",null,null,null,null,"Stage 3 - Budgeting & Work Authorisation",null,null,null,"show","Data"]
[null,null,null,"Detail work authorisation and budget assignment","The Budget/Work Schedule is formally authorised prior to work commencing and has been delegated to WP managers.","The following are available and can be demonstrated by the project team:\n\n§ Formal management procedures are documented and applied to delegate, open, close and suspend work, including supplier purchase order authorisation.\n§ Work Package Plans are in place, agreed and budget is distributed for their duration. \n§ A Work Authorisation document has been issued by the relevant authority.\n",null,null,null,null,"Stage 3 - Budgeting & Work Authorisation",null,null,null,"show","Data"]
[null,null,"Stage 4 - Management of purchased materials / services",null,"The management of purchased materials/services process ensures that all aspects associated with the integration and management of the suppliers' contribution are captured and in line with project execution.  ",null,null,null,null,null,"Stage 4 - Management of Purchased Materials / Services",null,null,null,{"$f":"Stage4Show","v":"show"}]
[null,null,"Stage 4 - Management of purchased materials/services","Supplier risk assessment","A comprehensive assessment is undertaken of all suppliers to the project.","The following are available and can be demonstrated by the project team:\n\n§ A risk assessment of suppliers has been completed (where appropriate).\n§ The outcome of the assessments has been reviewed and decisions on supplier selection agreed.\n§ Any risks have been flowed through to the project risk register where necessary.\n§ If an improvement plan is required for the supplier as part of the assessment, this has been documented.\n\n",null,null,null,null,"Stage 4 - Management of Purchased Materials / Services",null,null,null,"show","Data"]
[null,null,null,"Purchase order process","A robust process is in place for purchase orders (POs) to manage and control suppliers throughout the life of the project.","The following are available and can be demonstrated by the project team:\n\n§ The process for the management of POs is documented and configuration controlled.\n§ Delegation of authorities are in place across the project for the approval of POs, invoices, payments.",null,null,null,null,"Stage 4 - Management of Purchased Materials / Services",null,null,null,"show","Data"]
[null,null,null,"Material requirements ","All BoM items are planned, budgeted, managed and aligned with the schedule resource allocation.","The following are available and can be demonstrated by the project team:\n\n§ There is integration between the systems for the management of BoM items and the project schedule.\n§ All BoM items are captured and costed and suppliers understood.",null,null,null,null,"Stage 4 - Management of Purchased Materials / Services",null,null,null,"show","Data"]
[null,null,null,"Subcontractor and baseline relationship","Project control requirements are appropriately flowed down to suppliers.","The following are available and can be demonstrated by the project team:\n\n§ The requirements for project control are available in the T&Cs.\n",null,null,null,null,"Stage 4 - Management of Purchased Materials / Services",null,null,null,"show","Data"]
[null,null,null,"Supplier management and reporting","Regular Supplier Performance Reviews are conducted using their data as the basis of the review, with supporting variance analysis and corrective action planning.  ","The following are available and can be demonstrated by the project team:\n\n§ Regular reviews are established with the supplier. Deliverables for schedule, cost, reporting are received and reviewed in a timely manner to inform project overall delivery performance aligned to the performance reporting cycle.\n§ Actions plans/improvement plans are available where required.",null,null,null,null,"Stage 4 - Management of Purchased Materials / Services",null,null,null,"show","Data"]
[null,null,"Stage 5 - Accounting",null,"The accounting process is concerned with ensuring that there is a timely and accurate transfer of actual cost information from the accounting system into the project control system. It ensures legitimate accounting of project costs and controls applicability of costs and their methods. ",null,null,null,null,null,"Stage 5 - Accounting",null,null,null,{"$f":"Stage5Show","v":"show"}]
[null,null,"Stage 5 - Accounting","Accounting process","The accounting policy for different cost types (e g  overhead, general and administrative, direct, materials) is clearly defined and consistently applied. ","The following are available and can be demonstrated by the project team:\n\n§ Documented, configuration-controlled process in place that defines how direct and indirect costs are to be managed, and project team has been trained on its application.\n§ The system applied allows the accurate allocation of indirect costs against corresponding indirect budgets, and includes how they are updated as necessary.\n§ The system applied allows for the update and management of rate changes, including an assessment of the associated impact and agreement of changes with WP managers and project managers.\n§ The system applied allows cost data to be disaggregated to meets the needs of the business (e.g. split out cost types - labour v material/direct v indirect/recurring v non-recurring).\n",null,null,null,null,"Stage 5 - Accounting",null,null,null,"show","Data"]
[null,null,null,"Enable booking","Systems and processes are established for cost collection against open Work Packages (WPs) only.","The following are available and can be demonstrated by the project team:\n\n§ Documented, configuration-controlled process in place that defines how costs are collected, and at what level, how cost collection codes are opened and how they are closed. Project team has been trained on its application.\n§ The project can demonstrate actual costs by WBS element. \n§ The project can demonstrate which work packages are open and which are closed to cost collection.\n§ Direct cost shall summarise from the lowest defined level through to the top of the WBS hierarchy, without allocation to two or more higher-level WBS elements.  \n",null,null,null,null,"Stage 5 - Accounting",null,null,null,"show","Data"]
[null,null,null,"Subcontract and material costs","Subcontract or material costs are reported within the same accounting period as the associated performance claim. ","The following are available and can be demonstrated by the project team:\n\n§ Documented, configuration-controlled process in place that defines how subcontract and material costs are to be managed, and project team has been trained on its application.\n§ WP schedules demonstrate time-phased material budgets and associated objective measures to claim progress against these.  \n§ Project performance data available in which subcontract and material costs are recorded in the same period that progress is claimed.\n",null,null,null,null,"Stage 5 - Accounting",null,null,null,"show","Data"]
[null,null,null,"Accruals","Where actuals are not available, estimated actuals or accruals are used.","The following are available and can be demonstrated by the project team:\n\n§ Documented, configuration-controlled process in place that defines how estimated actuals or accruals are to be managed, and project team has been trained on its application. \n§ Evidence on application of the process, including where estimates of actual costs have been made and where they have been subsequently reversed out of the project accounts when invoices have been paid and included.\n",null,null,null,null,"Stage 5 - Accounting",null,null,null,"show","Data"]
[null,null,null,"Cost collection","Costs are collected, checked and verified from the financial accounting system and are reconcilable to the WBS. ","The following are available and can be demonstrated by the project team:\n\n§ Documented, configuration-controlled process in place that defines how costs are verified and approved for allocation against the project WBS, and project team has been trained on its application. \n§ Documented, configuration controlled process in place that defines how incorrectly allocated costs are corrected, and project team has been trained on its application.  \n",null,null,null,null,"Stage 5 - Accounting",null,null,null,"show","Data"]
[null,null,"Stage 6 - Managerial analysis",null,"The managerial analysis process covers the evaluation and feedback loop of the PCS. Performance management data is collected; management actions are determined, based on lower level analysis of problems; corrective actions are implemented; and their effect on cost and schedule performance are projected. Forecasts to completion are made for schedule and cost. ",null,null,null,null,null,"Stage 6 - Managerial Analysis",null,null,null,{"$f":"Stage6Show","v":"show"}]
[null,null,"Stage 6 - Managerial analysis","Governance and review structure","A project update, reporting and reviewing cycle is established for the project. The senior team and customer are involved appropriately and demand quality information. ","The following are available and can be demonstrated by the project team:\n\n§ A project governance process (control cycle) is documented and applied consistently.\n§ Roles and responsibilities in the process are recorded and adhered to.\n§ Third-party assurance activities have been undertaken and addressed in line with project/corporate requirements.\n§ The control cycle:\n    - Adds value (to the project) and is not a bureaucratic exercise.\n    - Demands and then utilises project data.\n    - Meets requirements for all organisational levels, e.g. work package, project, corporate, customer.\n    - Covers the full scope of the project to ensure successful delivery, e.g. externally driven risks.\n    - Enables routes for escalation and resolution of issues.\n    - Permits adequate time for analysis.\n",null,null,null,null,"Stage 6 - Managerial Analysis",null,null,null,"show","Data"]
[null,null,null,"Data collection and integrity","Project data is collected in line with the control cycle.  There is full data integrity and errors are rare. The quality and timeliness of the PCS data is measured on a regular basis.","The following are available and can be demonstrated by the project team:\n\n§ Performance data (e.g. schedule, cost, risk, quality) for each period end exists.\n§ Integrity of data regularly assessed using a consistent methodology, e.g. Defence contract management agency 14-point check.\n§ Data errors, when identified, are rigorously pursued and resolved.\n§ Data requirement is regularly assessed and, if data no longer needed, it is no longer produced.\n§ Timeliness of data delivery measured at every governance cycle. Poor performance highlighted and addressed.\n",null,null,null,null,"Stage 6 - Managerial Analysis",null,null,null,"show","Data"]
[null,null,null,"Integrated data analysis","The project team collates, integrates and analyses performance information and conducts forward-looking analysis to inform decision making.","The following are available and can be demonstrated by the project team:\n\n§ Regular variance analysis is performed along with milestones, interdependencies, critical path, float, change and risk analyses to determine programme trends and focus management attention on potential problems.\n§ A full review of project risk and opportunities, including mitigation actions and realisation plans, has been undertaken and informs the data analysis and estimate at completion.\n§ Output from the schedule and cost risk analyses should be used to monitor the ongoing adequacy of the time and cost contingency.\n",null,null,null,null,"Stage 6 - Managerial Analysis",null,null,null,"show","Data"]
[null,null,null,"Forecasting","Forecasting is conducted at an appropriate level on a periodic basis, and substantiated through lower-level performance, risk mitigation and resources required to complete the remaining planned work.\n","The following are available and can be demonstrated by the project team:\n\n§ A properly maintained WP forecast regularly adjusted to reflect project progress, as well as scope, schedule and cost changes.\n§ Records of historic project performance, e.g. schedule progress, and costs and achievements to date.\n§ Integrated project outturn data for time, cost, risk and quality, along with supporting information profiled over time, informed by analysis.",null,null,null,null,"Stage 6 - Managerial Analysis",null,null,null,"show","Data"]
[null,null,null,"Programme reporting and decision making","Project control information forms an integral element of the project reporting pack. There is a good understanding/interpretation of the information by the project team, enabling decision making. \n","The following are available and can be demonstrated by the project team:\n\n§ Performance data, e.g., EVM data, milestones, risk, KPIs, etc, are summarised through the every level of the WBS and OBS.\n§ Reports that provide options and recommendations based upon the analysis and forecasting.\n§ Data is reported consistently across the governance review hierarchy.\n§ Evidence of objectively evidenced performance data being used for analysis and to inform management decision making.\n§ Corrective actions, based on the reported performance, are assigned and tracked to resolution and closure.\n",null,null,null,null,"Stage 6 - Managerial Analysis",null,null,null,"show","Data"]
[null,null,"Stage 7 - Change control",null,"The change control process addresses the controlled process whereby projects incorporate formal change or conduct internal replanning to ensure the baseline remains an accurate representation of all authorised project work. The keys are timeliness and control.\n",null,null,null,null,null,"Stage 7 - Change",null,null,null,{"$f":"Stage7Show","v":"show"}]
[null,null,"Stage 7 - Change control","Initiate change","A clear and consistent process to initiate change is defined and applied.  A change can be initiated by the project team, customer or supplier.  ","The following are available and can be demonstrated by the project team:\n\n§ A clear and consistent process for change, including initiation, is defined and consistently applied.\n§ Each initiated changed is logged.\n§ All defined stakeholders can initiate a change.\n§ The PCS contains a calendar identifying the stages of the change procedure including regular deadlines for raising changes, evaluation and data processing aligned to project performance reporting.\n",null,null,null,null,"Stage 7 - Change Control",null,null,null,"show","Data"]
[null,null,null,"Assess change","An integrated assessment of the change is conducted for cost, schedule, risk and project deliverables.","The following are available and can be demonstrated by the project team:\n\n§ A clear and consistent process for change, including assessment, is defined and consistently applied.\n§ The change log is updated in a timely manner to show assessed changes.\n§ The change process clearly defines who should assess any change, when and how.\n§ The change is assessed in terms of its impact on scope, schedule, budget, risk and quality and the outcome fully recorded.",null,null,null,null,"Stage 7 - Change Control",null,null,null,"show","Data"]
[null,null,null,"Change control review board","The Change control review board assesses and approves (or otherwise) the proposed change, having understood the impacts to cost, schedule, risk, project deliverables and customer.  The responsiveness and timeliness of the process supports the requirements of the project and the project delivery approaches.","The following are available and can be demonstrated by the project team:\n\n§ Terms of reference for the Board(s).\n§ The Board reviews each change, informed by complete information about the impact of the change.\n§ Comprehensive and auditable records of Board decisions.\n§ Appropriate metrics are generated and monitored to confirm effective change process.",null,null,null,null,"Stage 7 - Change Control",null,null,null,"show","Data"]
[null,null,null,"Embody change","Changes are embodied in a timely and controlled manner, ensuring all applicable documentation is updated.","The following are available and can be demonstrated by the project team: \n\n§ A clear and consistent process for change, including embodiment, is defined and consistently applied.\n§ The change log is updated in a timely manner to show embodied changes.\n§ The change process clearly defines who should embody any change, when and how.\n§ The process controls retroactive changes to previously recorded values for budget, progress and cost, including approval and explanation.\n§ Integrated Master Schedule (IMS) baseline incorporates all approved changes.\n§ Project documentation covering scope, schedule, risk and budget are updated in a timely manner as part of embodiment and are all aligned to the approved change.\n§ Changes are traceable through the project controls system and reports.\n§ Justifications and approval for the changes are documented. \n§ Changes are approved prior to the commencement of work.\n§ Authorised work scope/budget changes are incorporated in the PMB and the IMS as soon as practicable.\n§ Management reports showing timely incorporation of approved changes. \n\n",null,null,null,null,"Stage 7 - Change Control",null,null,null,"show","Data"]
[null,null,null,"PMB integrity and assurance","Only approved changes are made. Pre- and post-budget changes are accurately reflected through the PMB documentation and systems.","The following are available and can be demonstrated by the project team:\n\n§ Change control logs.\n§ Changes are controlled in line with the change calendar.\n§ Proactive and timely baseline maintenance activities.\n§ Changes made to open work packages are minimised and effectively controlled.\n§ The PMB is effectively controlled in the freeze period to prevent multiple continuing adjustments.\n§ Currently authorised scope/budget relationship is reconcilable to the prior scope/budget relationship.\n§ Budgets reconcile pre- and post-change through the system and documentation.\n§ Amended Statement of Work (SoW), WBS, OBS and RAM.\n§ Contract modifications.\n§ Contractual budget values are only revised through contractual authorisation and can be demonstrated through contract change logs and approvals.\n§ IMS baseline changes are aligned with approved contract changes.\n§ Updated WP plans.\n§ Updated work authorisation documentation.\n§ Management reports showing traceability of changes.\n§ All risk and opportunity changes are logged in the system.",null,null,null,null,"Stage 7 - Change Control",null,null,null,"show","Data"]

{"sheet":"5. Dashboard","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"6. Improvement action plan","index":7,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[8,3,8,4],[9,3,9,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PROJECT TITLE:",{"$f":"VLOOKUP(C9,'3. Model front page'!C:I,7,I90)","v":"Super-Duper Project"}]
[null,null,"PROJECT MANAGER:",{"$f":"VLOOKUP(C10,'3. Model front page'!C:I,7,0)","v":"A. N. Other"}]
[]
[]
[null,null,"Maturity area","Maturity statement","PCMAF stage","Current maturity level","Target maturity \nlevel","Date to meet target level","Action required","Owner","Date required","Forecast date","Status","Comments"]
[null,null,null,{"$f":"VLOOKUP(C14,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C14,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C14,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C14,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C14,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C15,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C15,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C15,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C15,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C15,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C16,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C16,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C16,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C16,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C16,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C17,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C17,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C17,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C17,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C17,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C18,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C18,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C18,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C18,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C18,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C19,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C19,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C19,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C19,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C19,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C20,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C20,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C20,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C20,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C20,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C21,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C21,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C21,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C21,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C21,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C22,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C22,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C22,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C22,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C22,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C23,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C23,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C23,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C23,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C23,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C24,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C24,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C24,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C24,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C24,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C25,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C25,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C25,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C25,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C25,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C26,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C26,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C26,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C26,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C26,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C27,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C27,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C27,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C27,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C27,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C28,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C28,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C28,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C28,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C28,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C29,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C29,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C29,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C29,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C29,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C30,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C30,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C30,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C30,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C30,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C31,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C31,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C31,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C31,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C31,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C32,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C32,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C32,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C32,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C32,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C33,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C33,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C33,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C33,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C33,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C34,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C34,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C34,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C34,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C34,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C35,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C35,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C35,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C35,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C35,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C36,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C36,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C36,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C36,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C36,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C37,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C37,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C37,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C37,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C37,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C38,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C38,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C38,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C38,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C38,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C39,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C39,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C39,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C39,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C39,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C40,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C40,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C40,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C40,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C40,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C41,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C41,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C41,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C41,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C41,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C42,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C42,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C42,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C42,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C42,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"VLOOKUP(C43,'4. Maturity assessment'!D:I,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C43,'Data Lookup Sheet'!L:M,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C43,'4. Maturity assessment'!$D:$I,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C43,'4. Maturity assessment'!$D:$I,5,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C43,'4. Maturity assessment'!$D:$I,6,0)","v":{"$error":"#N/A"}}]

{"sheet":"7. Acronyms","index":8,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,2,6,3]]}
[]
[]
[]
[]
[]
[]
[null,null,"Acronyms",null,"Definitions"]
[null,null,"AC","Actual cost","The incurred costs that are charged to the project budget and for which payment has been made, or accrued."]
[null,null,"BAC","Budget at completion","The sum total of the time-phased budgets."]
[null,null,"BoM","Bill of materials","The management of purchased materials/ services covers the processes and activities that directly affect the purchase of bill of materials items or services from external suppliers."]
[null,null,"CAM","Control account manager","Has management responsibility for ensuring that the defined scope of work for a control account is achieved to the set budget, timescale and quality standards. The CAM manages the control account as a contract between themselves and the project manager/project director."]
[null,null,"CBS","Cost breakdown structure","A hierarchical structure used to organise the project costs according to category, often aligning them with the organisation’s budgeting system. It facilitates tracking the budget performance of the project."]
[null,null,"EV","Earned value","A measure of progress that expresses costs committed and work achieved in the same units."]
[null,null,"EVM","Earned value management","A project control process based on a structured approach to planning, cost collection and performance measurement. It facilitates the integration of project scope, time and cost objectives and the establishment of a baseline plan of performance measurement."]
[null,null,"EVT","Earned value technique","The technique used to measure achievement (EV). The optimum EVT must be assiged to individual work packages. The vast majority of work packages on a project should be a discrete type as these provide the most objective measures of the value of in progress work."]
[null,null,"IMS","Integrated master schedule","A schedule that is generated from other schedules, usually from different parts of the project contract supply chain.  The result of the vertical and/or horizontal linking of these through key activities or milestones."]
[null,null,"KPI","Key performance indicators","Measures of success that can be used throughout the project to ensure that it is progressing towards a successful conclusion."]
[null,null,"MR","Management reserve","A sum of money that is part of overall cost contingency to cover the cost impact of unidentified risks and potentially some already identified very low- probability, very high-impact risks."]
[null,null,"OBS","Organisational breakdown structure","A hierarchical way in which the organisation may be divided into management levels and groups, for planning and control purposes."]
[null,null,"PBS","Product breakdown structure","A hierarchy of deliverables that are required to be produced on the project. This forms the base document from which the execution strategy and product-based work breakdown structure may be derived. It provides a guide for configuration control documentation."]
[null,null,"PC","Project control","The application of processes to measure project performance against the project plan, to enable variances to be identified and corrected, so that project objectives are agreed."]
[null,null,"PCS","Project control system","A system to provide data which:\n§ provides timely and reliable information about work progress;\n§ properly relates cost, schedule and technical achievement;\n§ supplies managers with information at a practical level of summarisation."]
[null,null,"PMB","Performance measurement baseline","The time-phased budget plan against which contract performance is measured. It is formed by the budgets assigned to scheduled control accounts and applicable indirect budgets. For future effort, not planned to the control account level, the performance measurement baseline also includes budgets assigned to higher level WBS elements and undistricbuted budgets. It equals the total allocated budget less management reserve."]
[null,null,"PP","Planning package","Planning packages represent work that cannot yet be planned as work packages because of a lack of detailed information. Normally this is future work that is not scheduled to be started for at least three full months from the current date. "]
[null,null,"PV","Planned value","The cost profile of a resource-optimised schedule used as the baseline to monitor actual spend and earned value. Alternatively called the budgeted cost of work scheduled (BCWS)."]
[null,null,"QSRA","Quantitative schedule risk analysis","Once the schedule has been created, reviewed and verified, a quantitative schedule risk analysis will apply statistical techniques to test the level of confidence in meeting the completion date. The analysis looks at the whole schedule and not just the critical path."]
[null,null,"RACI","Responsible, accountable, consulted, informed","Responsible, accountable, consulted, informed.  The RACI matrix is a tool used for identifying roles and responsibilities to avoid confusion over those roles and responsibilities during the project."]
[null,null,"RAM","Responsibility assignment matrix","A diagram or chart showing assigned responsibilities for elements of work. It is created by combining the work breakdown structure with the organisational breakdown structure."]
[null,null,"RBS","Resource breakdown structure","The hierarchical breakdown of a project into resource requirement elements."]
[null,null,"T&Cs","Terms and conditions","All the clauses in a contract."]
[null,null,"UB","Undistributed budget","An amount of budget within the PMB which is identified to a defined scope of work but which has not yet been allocated to control accounts."]
[null,null,null,"WBS Dictionary","Covers the various WBS sections and defines all the deliverables relating to the scope or statement of work."]
[null,null,"WBS","Work breakdown structure","Defines the total work to be undertaken and provides a structure for all control systems. It allows a project or programme to be divided by level into discrete groups for programming, cost planning and control purposes."]
[null,null,"WP","Work package","The work package is the lowest level at which performance data is normally analysed.  Each work package must have a clearly defined start condition and finish point with all deliverables defined.  Each work package comprises a number of activities to be performed."]

{"sheet":"Data Lookup Sheet","index":9,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Project Stages",null,"Maturity Assessment","Scores",null,"Dark Green",null,null,"Stage 0","show",null,"PCS Sponsorship","Stage 0 - Culture & Environment"]
["Stage 0 - Culture & Environment",null,"True",5,null,"Light Green",null,null,"Stage 1","show",null,"Project Stakeholder Engagement","Stage 0 - Culture & Environment"]
["Stage 1 - Organisation",null,"More true than untrue",3,null,"Amber",null,null,"Stage 2","show",null,"Project Control Roles","Stage 0 - Culture & Environment"]
["Stage 2 - Scheduling & Resourcing",null,"More untrue than true",1,null,"Red",null,null,"Stage 3","show",null,"Project Control Competencies","Stage 0 - Culture & Environment"]
["Stage 3 - Budgeting & Work Authorisation",null,"Untrue",0,null,"Grey",null,null,"Stage 4","show",null,"Project Control System Application","Stage 0 - Culture & Environment"]
["Stage 4 - Management of Purchased Materials / Services",null,"N/A",null,null,"Blue",null,null,"Stage 5","show",null,"Project Control System Reviews","Stage 0 - Culture & Environment"]
["Stage 5 - Accounting",null,"Not Yet Assessed",null,null,null,null,null,"Stage 6","show",null,"Continuous Improvement & Learning","Stage 0 - Culture & Environment"]
["Stage 6 - Managerial Analysis",null,null,null,null,null,null,null,"Stage 7","show",null,"Project Closure","Stage 0 - Culture & Environment"]
["Stage 7 - Change Control",null,null,null,null,"Ongoing"]
[null,null,"Version for VLOOKUP","Scores",null,"Slipping",null,null,null,null,null,"Scope Definition ","Stage 1 - Organisation"]
[null,null,"More true than untrue",3,null,"Complete",null,null,null,null,null,"Project Level Authorisation","Stage 1 - Organisation"]
[null,null,"More untrue than true",1,null,"Late",null,null,null,null,null,"Product Breakdown Structure (PBS)","Stage 1 - Organisation"]
[null,null,"N/A",0,null,null,null,null,null,null,null,"Work Breakdown Structure (WBS) ","Stage 1 - Organisation"]
[null,null,"Not yet scored",0,null,null,null,null,null,null,null,"Organisational Breakdown Structure (OBS) ","Stage 1 - Organisation"]
[null,null,"True",5,null,null,null,null,null,null,null,"Responsibility Assignment Matrix (RAM)","Stage 1 - Organisation"]
[null,null,"Untrue",0,null,null,null,null,null,null,null,"Roles & Responsibilities","Stage 1 - Organisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Resource Breakdown Structure (RBS)","Stage 1 - Organisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost Breakdown Structure (CBS)","Stage 1 - Organisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Breakdown Structure Alignment","Stage 1 - Organisation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Major Schedule & Resource Assumptions","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule Hierarchy Structure","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Detail of the Schedule","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Integrating Supplier Schedules","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Defining Work/ Planning Packages (WP/ PPs)","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule Resource Allocation ","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Integration of Milestones","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Float","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule Integration","Stage 2 - Scheduling & Resourcing"]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule Risk Analysis","Stage 2 - Scheduling & Resourcing"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Basis of Estimate","Stage 3 - Budgeting & Work Authorisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Project Budget","Stage 3 - Budgeting & Work Authorisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Indirect Management (Overheads)","Stage 3 - Budgeting & Work Authorisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Undistributed Budget (UB)","Stage 3 - Budgeting & Work Authorisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Management Reserve (MR)","Stage 3 - Budgeting & Work Authorisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Performance Measurement Baseline (PMB)","Stage 3 - Budgeting & Work Authorisation"]
[null,null,null,null,null,null,null,null,null,null,null,"Detail Work Authorisation & Budget Assignment","Stage 3 - Budgeting & Work Authorisation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Supplier Risk Assessment","Stage 4 - Management of Purchased Materials / Services"]
[null,null,null,null,null,null,null,null,null,null,null,"Purchase Order Process","Stage 4 - Management of Purchased Materials / Services"]
[null,null,null,null,null,null,null,null,null,null,null,"Material Requirements ","Stage 4 - Management of Purchased Materials / Services"]
[null,null,null,null,null,null,null,null,null,null,null,"Subcontractor and Baseline Relationship","Stage 4 - Management of Purchased Materials / Services"]
[null,null,null,null,null,null,null,null,null,null,null,"Supplier Management & Reporting","Stage 4 - Management of Purchased Materials / Services"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Accounting Process","Stage 5 - Accounting"]
[null,null,null,null,null,null,null,null,null,null,null,"Enable Booking","Stage 5 - Accounting"]
[null,null,null,null,null,null,null,null,null,null,null,"Subcontract & Material Costs","Stage 5 - Accounting"]
[null,null,null,null,null,null,null,null,null,null,null,"Accruals","Stage 5 - Accounting"]
[null,null,null,null,null,null,null,null,null,null,null,"Cost Collection","Stage 5 - Accounting"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Governance and Review Structure","Stage 6 - Managerial Analysis"]
[null,null,null,null,null,null,null,null,null,null,null,"Data Collection and Integrity","Stage 6 - Managerial Analysis"]
[null,null,null,null,null,null,null,null,null,null,null,"Integrated Data Analysis","Stage 6 - Managerial Analysis"]
[null,null,null,null,null,null,null,null,null,null,null,"Forecasting","Stage 6 - Managerial Analysis"]
[null,null,null,null,null,null,null,null,null,null,null,"Programme Reporting and Decision Making","Stage 6 - Managerial Analysis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Initiate Change","Stage 7 - Change Control"]
[null,null,null,null,null,null,null,null,null,null,null,"Assess Change","Stage 7 - Change Control"]
[null,null,null,null,null,null,null,null,null,null,null,"Change Control Review Board","Stage 7 - Change Control"]
[null,null,null,null,null,null,null,null,null,null,null,"Embody Change","Stage 7 - Change Control"]
[null,null,null,null,null,null,null,null,null,null,null,"PMB Integrity & Assurance","Stage 7 - Change Control"]

{"sheet":"Calculations","index":10,"n_rows":77,"n_cols":20,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,7,0,12],[0,13,0,19]]}
["Data Date",{"$f":"'4. Maturity assessment'!J3","v":"2018-05-09"},null,null,null,null,null,"Graph Data",null,null,null,null,null,"Further Analysis"]
[{"$f":"'4. Maturity assessment'!C7","v":"Stage 0 - Culture and environment"},"Model - Current","Model - Target","Target Date","Score - Current","Score - Target",null,"Target Met","On Target","Late","Target","Target Not Applicable","Target Not Yet Assessed","Over Achieved","Achieved","Late","On Target","N/A","Not Assessed","Within 1 Month"]
[{"$f":"'4. Maturity assessment'!D8","v":"PCS sponsorship"},{"$f":"'4. Maturity assessment'!G8","v":0},{"$f":"'4. Maturity assessment'!H8","v":0},{"$f":"'4. Maturity assessment'!I8","v":"00:00:00"},{"$f":"VLOOKUP(B3,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C3,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E3>=F3,E3,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E3<$F3,$D3>$B$1),$E3,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E3<$F3,$D3<=$B$1),$E3,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C3<>'Data Lookup Sheet'!$C$6,C3<>'Data Lookup Sheet'!$C$7),F3,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C3='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C3='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(E3>F3,1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(E3=F3,F3<>0),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(F3>E3,D3<$B$1),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(F3>E3,D3>$B$1),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(C3='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C3='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$f":"IF(AND(Q3<>0,(D3-$B$1)<=30),1,0)","v":{"$error":"#N/A"}}]
[{"$f":"'4. Maturity assessment'!D9","v":"Project stakeholder engagement"},{"$f":"'4. Maturity assessment'!G9","v":0},{"$f":"'4. Maturity assessment'!H9","v":0},{"$f":"'4. Maturity assessment'!I9","v":"00:00:00"},{"$f":"VLOOKUP(B4,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C4,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E4>=F4,E4,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E4<$F4,$D4>$B$1),$E4,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E4<$F4,$D4<=$B$1),$E4,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C4<>'Data Lookup Sheet'!$C$6,C4<>'Data Lookup Sheet'!$C$7),F4,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C4='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C4='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(E4>F4,1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(E4=F4,F4<>0),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(F4>E4,D4<$B$1),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(F4>E4,D4>$B$1),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(C4='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C4='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$f":"IF(AND(Q4<>0,(D4-$B$1)<=30),1,0)","v":{"$error":"#N/A"}}]
[{"$f":"'4. Maturity assessment'!D10","v":"Project control roles"},{"$f":"'4. Maturity assessment'!G10","v":0},{"$f":"'4. Maturity assessment'!H10","v":0},{"$f":"'4. Maturity assessment'!I10","v":"00:00:00"},{"$f":"VLOOKUP(B5,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C5,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C5<>'Data Lookup Sheet'!$C$6,C5<>'Data Lookup Sheet'!$C$7),F5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C5='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C5='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C5='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C5='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D11","v":"Project control competencies"},{"$f":"'4. Maturity assessment'!G11","v":0},{"$f":"'4. Maturity assessment'!H11","v":0},{"$f":"'4. Maturity assessment'!I11","v":"00:00:00"},{"$f":"VLOOKUP(B6,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C6,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C6<>'Data Lookup Sheet'!$C$6,C6<>'Data Lookup Sheet'!$C$7),F6,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C6='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C6='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C6='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C6='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D12","v":"Project control system application and assurance"},{"$f":"'4. Maturity assessment'!G12","v":0},{"$f":"'4. Maturity assessment'!H12","v":0},{"$f":"'4. Maturity assessment'!I12","v":"00:00:00"},{"$f":"VLOOKUP(B7,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C7,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C7<>'Data Lookup Sheet'!$C$6,C7<>'Data Lookup Sheet'!$C$7),F7,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C7='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C7='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C7='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C7='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D13","v":"Project control system reviews"},{"$f":"'4. Maturity assessment'!G13","v":0},{"$f":"'4. Maturity assessment'!H13","v":0},{"$f":"'4. Maturity assessment'!I13","v":"00:00:00"},{"$f":"VLOOKUP(B8,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C8,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C8<>'Data Lookup Sheet'!$C$6,C8<>'Data Lookup Sheet'!$C$7),F8,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C8='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C8='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C8='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C8='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D14","v":"Continuous improvement and learning"},{"$f":"'4. Maturity assessment'!G14","v":0},{"$f":"'4. Maturity assessment'!H14","v":0},{"$f":"'4. Maturity assessment'!I14","v":"00:00:00"},{"$f":"VLOOKUP(B9,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C9,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C9<>'Data Lookup Sheet'!$C$6,C9<>'Data Lookup Sheet'!$C$7),F9,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C9='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C9='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C9='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C9='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D15","v":"Project closure"},{"$f":"'4. Maturity assessment'!G15","v":0},{"$f":"'4. Maturity assessment'!H15","v":0},{"$f":"'4. Maturity assessment'!I15","v":"00:00:00"},{"$f":"VLOOKUP(B10,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C10,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C10<>'Data Lookup Sheet'!$C$6,C10<>'Data Lookup Sheet'!$C$7),F10,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C10='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C10='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C10='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C10='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!C16","v":"Stage 1 - Organisation"},null,{"$f":"COUNTIF(C3:C10,\"N/A\")","v":0},null,{"$f":"SUM(E3:E10)/(COUNTA(E3:E10)-$C11)","v":{"$error":"#N/A"}},{"$f":"SUM(F3:F10)/(COUNTA(F3:F10)-$C11)","v":{"$error":"#N/A"}},null,{"$f":"H2","v":"Target Met"},{"$f":"I2","v":"On Target"},"Late","Target","Target Not Applicable",{"$f":"M2","v":"Target Not Yet Assessed"},"Over Achieved"]
[{"$f":"'4. Maturity assessment'!D17","v":"Scope definition "},{"$f":"'4. Maturity assessment'!G17","v":0},{"$f":"'4. Maturity assessment'!H17","v":0},{"$f":"'4. Maturity assessment'!I17","v":"00:00:00"},{"$f":"VLOOKUP(B12,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C12,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E12>=F12,E12,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E12<$F12,$D12>$B$1),$E12,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E12<$F12,$D12<=$B$1),$E12,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C12<>'Data Lookup Sheet'!$C$6,C12<>'Data Lookup Sheet'!$C$7),F12,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C12='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C12='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(F12>E12,D12<$B$1),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(F12>E12,D12>$B$1),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(C12='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C12='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D18","v":"Project level authorisation"},{"$f":"'4. Maturity assessment'!G18","v":0},{"$f":"'4. Maturity assessment'!H18","v":0},{"$f":"'4. Maturity assessment'!I18","v":"00:00:00"},{"$f":"VLOOKUP(B13,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C13,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C13<>'Data Lookup Sheet'!$C$6,C13<>'Data Lookup Sheet'!$C$7),F13,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C13='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C13='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(F13>E13,D13<$B$1),1,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(C13='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C13='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D19","v":"Product breakdown structure (PBS)"},{"$f":"'4. Maturity assessment'!G19","v":0},{"$f":"'4. Maturity assessment'!H19","v":0},{"$f":"'4. Maturity assessment'!I19","v":"00:00:00"},{"$f":"VLOOKUP(B14,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C14,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C14<>'Data Lookup Sheet'!$C$6,C14<>'Data Lookup Sheet'!$C$7),F14,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C14='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C14='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C14='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C14='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D20","v":"Work breakdown structure (WBS) "},{"$f":"'4. Maturity assessment'!G20","v":0},{"$f":"'4. Maturity assessment'!H20","v":0},{"$f":"'4. Maturity assessment'!I20","v":"00:00:00"},{"$f":"VLOOKUP(B15,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C15,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C15<>'Data Lookup Sheet'!$C$6,C15<>'Data Lookup Sheet'!$C$7),F15,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C15='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C15='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C15='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C15='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D21","v":"Organisational breakdown structure (OBS) "},{"$f":"'4. Maturity assessment'!G21","v":0},{"$f":"'4. Maturity assessment'!H21","v":0},{"$f":"'4. Maturity assessment'!I21","v":"00:00:00"},{"$f":"VLOOKUP(B16,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C16,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C16<>'Data Lookup Sheet'!$C$6,C16<>'Data Lookup Sheet'!$C$7),F16,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C16='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C16='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C16='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C16='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D22","v":"Responsibility assignment matrix (RAM)"},{"$f":"'4. Maturity assessment'!G22","v":0},{"$f":"'4. Maturity assessment'!H22","v":0},{"$f":"'4. Maturity assessment'!I22","v":"00:00:00"},{"$f":"VLOOKUP(B17,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C17,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C17<>'Data Lookup Sheet'!$C$6,C17<>'Data Lookup Sheet'!$C$7),F17,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C17='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C17='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C17='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C17='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D23","v":"Roles and responsibilities"},{"$f":"'4. Maturity assessment'!G23","v":0},{"$f":"'4. Maturity assessment'!H23","v":0},{"$f":"'4. Maturity assessment'!I23","v":"00:00:00"},{"$f":"VLOOKUP(B18,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C18,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C18<>'Data Lookup Sheet'!$C$6,C18<>'Data Lookup Sheet'!$C$7),F18,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C18='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C18='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C18='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C18='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D24","v":"Resource breakdown structure (RBS)"},{"$f":"'4. Maturity assessment'!G24","v":0},{"$f":"'4. Maturity assessment'!H24","v":0},{"$f":"'4. Maturity assessment'!I24","v":"00:00:00"},{"$f":"VLOOKUP(B19,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C19,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C19<>'Data Lookup Sheet'!$C$6,C19<>'Data Lookup Sheet'!$C$7),F19,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C19='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C19='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C19='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C19='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D25","v":"Cost breakdown structure (CBS)"},{"$f":"'4. Maturity assessment'!G25","v":0},{"$f":"'4. Maturity assessment'!H25","v":0},{"$f":"'4. Maturity assessment'!I25","v":"00:00:00"},{"$f":"VLOOKUP(B20,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C20,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C20<>'Data Lookup Sheet'!$C$6,C20<>'Data Lookup Sheet'!$C$7),F20,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C20='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C20='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C20='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C20='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D26","v":"Breakdown structure alignment"},{"$f":"'4. Maturity assessment'!G26","v":0},{"$f":"'4. Maturity assessment'!H26","v":0},{"$f":"'4. Maturity assessment'!I26","v":"00:00:00"},{"$f":"VLOOKUP(B21,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C21,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C21<>'Data Lookup Sheet'!$C$6,C21<>'Data Lookup Sheet'!$C$7),F21,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C21='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C21='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C21='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C21='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!C27","v":"Stage 2 - Scheduling and resourcing"},null,{"$f":"COUNTIF(C12:C21,\"N/A\")","v":0},null,{"$f":"SUM(E12:E21)/(COUNTA(E12:E21)-$C22)","v":{"$error":"#N/A"}},{"$f":"SUM(F12:F21)/(COUNTA(F12:F21)-$C22)","v":{"$error":"#N/A"}},null,{"$f":"H2","v":"Target Met"},{"$f":"I2","v":"On Target"},"Late","Target","Target Not Applicable",{"$f":"M2","v":"Target Not Yet Assessed"},"Over Achieved"]
[{"$f":"'4. Maturity assessment'!D28","v":"Major schedule and resource assumptions"},{"$f":"'4. Maturity assessment'!G28","v":0},{"$f":"'4. Maturity assessment'!H28","v":0},{"$f":"'4. Maturity assessment'!I28","v":"00:00:00"},{"$f":"VLOOKUP(B23,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C23,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E23>=F23,E23,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E23<$F23,$D23>$B$1),$E23,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E23<$F23,$D23<=$B$1),$E23,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C23<>'Data Lookup Sheet'!$C$6,C23<>'Data Lookup Sheet'!$C$7),F23,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C23='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C23='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C23='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C23='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D29","v":"Schedule hierarchy structure"},{"$f":"'4. Maturity assessment'!G29","v":0},{"$f":"'4. Maturity assessment'!H29","v":0},{"$f":"'4. Maturity assessment'!I29","v":"00:00:00"},{"$f":"VLOOKUP(B24,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C24,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C24<>'Data Lookup Sheet'!$C$6,C24<>'Data Lookup Sheet'!$C$7),F24,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C24='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C24='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C24='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C24='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D30","v":"Detail of the schedule"},{"$f":"'4. Maturity assessment'!G30","v":0},{"$f":"'4. Maturity assessment'!H30","v":0},{"$f":"'4. Maturity assessment'!I30","v":"00:00:00"},{"$f":"VLOOKUP(B25,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C25,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C25<>'Data Lookup Sheet'!$C$6,C25<>'Data Lookup Sheet'!$C$7),F25,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C25='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C25='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C25='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C25='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D31","v":"Integrating supplier schedules"},{"$f":"'4. Maturity assessment'!G31","v":0},{"$f":"'4. Maturity assessment'!H31","v":0},{"$f":"'4. Maturity assessment'!I31","v":"00:00:00"},{"$f":"VLOOKUP(B26,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C26,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C26<>'Data Lookup Sheet'!$C$6,C26<>'Data Lookup Sheet'!$C$7),F26,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C26='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C26='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C26='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C26='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D32","v":"Defining work/planning packages (WP/PPs)"},{"$f":"'4. Maturity assessment'!G32","v":0},{"$f":"'4. Maturity assessment'!H32","v":0},{"$f":"'4. Maturity assessment'!I32","v":"00:00:00"},{"$f":"VLOOKUP(B27,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C27,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C27<>'Data Lookup Sheet'!$C$6,C27<>'Data Lookup Sheet'!$C$7),F27,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C27='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C27='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C27='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C27='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D33","v":"Schedule resource allocation "},{"$f":"'4. Maturity assessment'!G33","v":0},{"$f":"'4. Maturity assessment'!H33","v":0},{"$f":"'4. Maturity assessment'!I33","v":"00:00:00"},{"$f":"VLOOKUP(B28,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C28,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C28<>'Data Lookup Sheet'!$C$6,C28<>'Data Lookup Sheet'!$C$7),F28,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C28='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C28='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C28='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C28='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D34","v":"Integration of milestones"},{"$f":"'4. Maturity assessment'!G34","v":0},{"$f":"'4. Maturity assessment'!H34","v":0},{"$f":"'4. Maturity assessment'!I34","v":"00:00:00"},{"$f":"VLOOKUP(B29,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C29,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C29<>'Data Lookup Sheet'!$C$6,C29<>'Data Lookup Sheet'!$C$7),F29,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C29='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C29='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C29='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C29='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D35","v":"Float"},{"$f":"'4. Maturity assessment'!G35","v":0},{"$f":"'4. Maturity assessment'!H35","v":0},{"$f":"'4. Maturity assessment'!I35","v":"00:00:00"},{"$f":"VLOOKUP(B30,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C30,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C30<>'Data Lookup Sheet'!$C$6,C30<>'Data Lookup Sheet'!$C$7),F30,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C30='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C30='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C30='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C30='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D36","v":"Schedule integration"},{"$f":"'4. Maturity assessment'!G36","v":0},{"$f":"'4. Maturity assessment'!H36","v":0},{"$f":"'4. Maturity assessment'!I36","v":"00:00:00"},{"$f":"VLOOKUP(B31,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C31,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C31<>'Data Lookup Sheet'!$C$6,C31<>'Data Lookup Sheet'!$C$7),F31,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C31='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C31='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C31='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C31='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D37","v":"Schedule risk analysis"},{"$f":"'4. Maturity assessment'!G37","v":0},{"$f":"'4. Maturity assessment'!H37","v":0},{"$f":"'4. Maturity assessment'!I37","v":"00:00:00"},{"$f":"VLOOKUP(B32,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C32,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C32<>'Data Lookup Sheet'!$C$6,C32<>'Data Lookup Sheet'!$C$7),F32,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C32='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C32='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C32='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C32='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!C38","v":"Stage 3 - Budgeting and work authorisation"},null,{"$f":"COUNTIF(C23:C32,\"N/A\")","v":0},null,{"$f":"SUM(E23:E32)/(COUNTA(E23:E32)-$C33)","v":{"$error":"#N/A"}},{"$f":"SUM(F23:F32)/(COUNTA(F23:F32)-$C33)","v":{"$error":"#N/A"}},null,{"$f":"H2","v":"Target Met"},{"$f":"I2","v":"On Target"},"Late","Target","Target Not Applicable",{"$f":"M2","v":"Target Not Yet Assessed"},"Over Achieved"]
[{"$f":"'4. Maturity assessment'!D39","v":"Basis of estimate"},{"$f":"'4. Maturity assessment'!G39","v":0},{"$f":"'4. Maturity assessment'!H39","v":0},{"$f":"'4. Maturity assessment'!I39","v":"00:00:00"},{"$f":"VLOOKUP(B34,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C34,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E34>=F34,E34,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E34<$F34,$D34>$B$1),$E34,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E34<$F34,$D34<=$B$1),$E34,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C34<>'Data Lookup Sheet'!$C$6,C34<>'Data Lookup Sheet'!$C$7),F34,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C34='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C34='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C34='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C34='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D40","v":"Project budget"},{"$f":"'4. Maturity assessment'!G40","v":0},{"$f":"'4. Maturity assessment'!H40","v":0},{"$f":"'4. Maturity assessment'!I40","v":"00:00:00"},{"$f":"VLOOKUP(B35,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C35,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C35<>'Data Lookup Sheet'!$C$6,C35<>'Data Lookup Sheet'!$C$7),F35,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C35='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C35='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C35='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C35='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D41","v":"Indirect management (Overheads)"},{"$f":"'4. Maturity assessment'!G41","v":0},{"$f":"'4. Maturity assessment'!H41","v":0},{"$f":"'4. Maturity assessment'!I41","v":"00:00:00"},{"$f":"VLOOKUP(B36,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C36,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C36<>'Data Lookup Sheet'!$C$6,C36<>'Data Lookup Sheet'!$C$7),F36,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C36='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C36='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C36='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C36='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D42","v":"Undistributed budget (UB)"},{"$f":"'4. Maturity assessment'!G42","v":0},{"$f":"'4. Maturity assessment'!H42","v":0},{"$f":"'4. Maturity assessment'!I42","v":"00:00:00"},{"$f":"VLOOKUP(B37,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C37,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C37<>'Data Lookup Sheet'!$C$6,C37<>'Data Lookup Sheet'!$C$7),F37,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C37='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C37='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C37='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C37='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D43","v":"Management reserve (MR)"},{"$f":"'4. Maturity assessment'!G43","v":0},{"$f":"'4. Maturity assessment'!H43","v":0},{"$f":"'4. Maturity assessment'!I43","v":"00:00:00"},{"$f":"VLOOKUP(B38,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C38,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C38<>'Data Lookup Sheet'!$C$6,C38<>'Data Lookup Sheet'!$C$7),F38,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C38='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C38='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C38='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C38='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D44","v":"Performance measurement baseline (PMB)"},{"$f":"'4. Maturity assessment'!G44","v":0},{"$f":"'4. Maturity assessment'!H44","v":0},{"$f":"'4. Maturity assessment'!I44","v":"00:00:00"},{"$f":"VLOOKUP(B39,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C39,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C39<>'Data Lookup Sheet'!$C$6,C39<>'Data Lookup Sheet'!$C$7),F39,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C39='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C39='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C39='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C39='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D45","v":"Detail work authorisation and budget assignment"},{"$f":"'4. Maturity assessment'!G45","v":0},{"$f":"'4. Maturity assessment'!H45","v":0},{"$f":"'4. Maturity assessment'!I45","v":"00:00:00"},{"$f":"VLOOKUP(B40,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C40,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C40<>'Data Lookup Sheet'!$C$6,C40<>'Data Lookup Sheet'!$C$7),F40,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C40='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C40='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C40='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C40='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"COUNTIF(C34:C40,\"N/A\")","v":0},null,{"$f":"SUM(E34:E40)/(COUNTA(E34:E40)-$C41)","v":{"$error":"#N/A"}},{"$f":"SUM(F34:F40)/(COUNTA(F34:F40)-$C41)","v":{"$error":"#N/A"}},null,{"$f":"H2","v":"Target Met"},{"$f":"I2","v":"On Target"},"Late","Target","Target Not Applicable",{"$f":"M2","v":"Target Not Yet Assessed"},"Over Achieved"]
[{"$f":"'4. Maturity assessment'!D47","v":"Supplier risk assessment"},{"$f":"'4. Maturity assessment'!G47","v":0},{"$f":"'4. Maturity assessment'!H47","v":0},{"$f":"'4. Maturity assessment'!I47","v":"00:00:00"},{"$f":"VLOOKUP(B42,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C42,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E42>=F42,E42,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E42<$F42,$D42>$B$1),$E42,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E42<$F42,$D42<=$B$1),$E42,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C42<>'Data Lookup Sheet'!$C$6,C42<>'Data Lookup Sheet'!$C$7),F42,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C42='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C42='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C42='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C42='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D48","v":"Purchase order process"},{"$f":"'4. Maturity assessment'!G48","v":0},{"$f":"'4. Maturity assessment'!H48","v":0},{"$f":"'4. Maturity assessment'!I48","v":"00:00:00"},{"$f":"VLOOKUP(B43,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C43,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C43<>'Data Lookup Sheet'!$C$6,C43<>'Data Lookup Sheet'!$C$7),F43,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C43='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C43='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C43='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C43='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D49","v":"Material requirements "},{"$f":"'4. Maturity assessment'!G49","v":0},{"$f":"'4. Maturity assessment'!H49","v":0},{"$f":"'4. Maturity assessment'!I49","v":"00:00:00"},{"$f":"VLOOKUP(B44,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C44,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C44<>'Data Lookup Sheet'!$C$6,C44<>'Data Lookup Sheet'!$C$7),F44,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C44='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C44='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C44='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C44='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D50","v":"Subcontractor and baseline relationship"},{"$f":"'4. Maturity assessment'!G50","v":0},{"$f":"'4. Maturity assessment'!H50","v":0},{"$f":"'4. Maturity assessment'!I50","v":"00:00:00"},{"$f":"VLOOKUP(B45,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C45,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C45<>'Data Lookup Sheet'!$C$6,C45<>'Data Lookup Sheet'!$C$7),F45,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C45='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C45='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C45='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C45='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D51","v":"Supplier management and reporting"},{"$f":"'4. Maturity assessment'!G51","v":0},{"$f":"'4. Maturity assessment'!H51","v":0},{"$f":"'4. Maturity assessment'!I51","v":"00:00:00"},{"$f":"VLOOKUP(B46,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C46,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C46<>'Data Lookup Sheet'!$C$6,C46<>'Data Lookup Sheet'!$C$7),F46,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C46='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C46='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C46='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C46='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!C52","v":"Stage 5 - Accounting"},null,{"$f":"COUNTIF(C42:C46,\"N/A\")","v":0},null,{"$f":"SUM(E42:E46)/(COUNTA(E42:E46)-$C47)","v":{"$error":"#N/A"}},{"$f":"SUM(F42:F46)/(COUNTA(F42:F46)-$C47)","v":{"$error":"#N/A"}},null,{"$f":"H2","v":"Target Met"},{"$f":"I2","v":"On Target"},"Late","Target","Target Not Applicable",{"$f":"M2","v":"Target Not Yet Assessed"},"Over Achieved"]
[{"$f":"'4. Maturity assessment'!D53","v":"Accounting process"},{"$f":"'4. Maturity assessment'!G53","v":0},{"$f":"'4. Maturity assessment'!H53","v":0},{"$f":"'4. Maturity assessment'!I53","v":"00:00:00"},{"$f":"VLOOKUP(B48,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C48,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E48>=F48,E48,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E48<$F48,$D48>$B$1),$E48,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E48<$F48,$D48<=$B$1),$E48,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C48<>'Data Lookup Sheet'!$C$6,C48<>'Data Lookup Sheet'!$C$7),F48,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C48='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C48='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C48='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C48='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D54","v":"Enable booking"},{"$f":"'4. Maturity assessment'!G54","v":0},{"$f":"'4. Maturity assessment'!H54","v":0},{"$f":"'4. Maturity assessment'!I54","v":"00:00:00"},{"$f":"VLOOKUP(B49,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C49,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C49<>'Data Lookup Sheet'!$C$6,C49<>'Data Lookup Sheet'!$C$7),F49,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C49='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C49='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C49='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C49='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D55","v":"Subcontract and material costs"},{"$f":"'4. Maturity assessment'!G55","v":0},{"$f":"'4. Maturity assessment'!H55","v":0},{"$f":"'4. Maturity assessment'!I55","v":"00:00:00"},{"$f":"VLOOKUP(B50,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C50,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C50<>'Data Lookup Sheet'!$C$6,C50<>'Data Lookup Sheet'!$C$7),F50,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C50='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C50='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C50='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C50='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D56","v":"Accruals"},{"$f":"'4. Maturity assessment'!G56","v":0},{"$f":"'4. Maturity assessment'!H56","v":0},{"$f":"'4. Maturity assessment'!I56","v":"00:00:00"},{"$f":"VLOOKUP(B51,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C51,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C51<>'Data Lookup Sheet'!$C$6,C51<>'Data Lookup Sheet'!$C$7),F51,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C51='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C51='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C51='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C51='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D57","v":"Cost collection"},{"$f":"'4. Maturity assessment'!G57","v":0},{"$f":"'4. Maturity assessment'!H57","v":0},{"$f":"'4. Maturity assessment'!I57","v":"00:00:00"},{"$f":"VLOOKUP(B52,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C52,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C52<>'Data Lookup Sheet'!$C$6,C52<>'Data Lookup Sheet'!$C$7),F52,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C52='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C52='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C52='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C52='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!C58","v":"Stage 6 - Managerial analysis"},null,{"$f":"COUNTIF(C48:C52,\"N/A\")","v":0},null,{"$f":"SUM(E48:E52)/(COUNTA(E48:E52)-$C53)","v":{"$error":"#N/A"}},{"$f":"SUM(F48:F52)/(COUNTA(F48:F52)-$C53)","v":{"$error":"#N/A"}},null,{"$f":"H2","v":"Target Met"},{"$f":"I2","v":"On Target"},"Late","Target","Target Not Applicable",{"$f":"M2","v":"Target Not Yet Assessed"},"Over Achieved"]
[{"$f":"'4. Maturity assessment'!D59","v":"Governance and review structure"},{"$f":"'4. Maturity assessment'!G59","v":0},{"$f":"'4. Maturity assessment'!H59","v":0},{"$f":"'4. Maturity assessment'!I59","v":"00:00:00"},{"$f":"VLOOKUP(B54,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C54,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E54>=F54,E54,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E54<$F54,$D54>$B$1),$E54,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E54<$F54,$D54<=$B$1),$E54,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C54<>'Data Lookup Sheet'!$C$6,C54<>'Data Lookup Sheet'!$C$7),F54,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C54='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C54='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C54='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C54='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D60","v":"Data collection and integrity"},{"$f":"'4. Maturity assessment'!G60","v":0},{"$f":"'4. Maturity assessment'!H60","v":0},{"$f":"'4. Maturity assessment'!I60","v":"00:00:00"},{"$f":"VLOOKUP(B55,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C55,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C55<>'Data Lookup Sheet'!$C$6,C55<>'Data Lookup Sheet'!$C$7),F55,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C55='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C55='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C55='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C55='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D61","v":"Integrated data analysis"},{"$f":"'4. Maturity assessment'!G61","v":0},{"$f":"'4. Maturity assessment'!H61","v":0},{"$f":"'4. Maturity assessment'!I61","v":"00:00:00"},{"$f":"VLOOKUP(B56,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C56,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C56<>'Data Lookup Sheet'!$C$6,C56<>'Data Lookup Sheet'!$C$7),F56,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C56='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C56='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C56='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C56='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D62","v":"Forecasting"},{"$f":"'4. Maturity assessment'!G62","v":0},{"$f":"'4. Maturity assessment'!H62","v":0},{"$f":"'4. Maturity assessment'!I62","v":"00:00:00"},{"$f":"VLOOKUP(B57,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C57,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C57<>'Data Lookup Sheet'!$C$6,C57<>'Data Lookup Sheet'!$C$7),F57,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C57='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C57='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C57='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C57='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D63","v":"Programme reporting and decision making"},{"$f":"'4. Maturity assessment'!G63","v":0},{"$f":"'4. Maturity assessment'!H63","v":0},{"$f":"'4. Maturity assessment'!I63","v":"00:00:00"},{"$f":"VLOOKUP(B58,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C58,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C58<>'Data Lookup Sheet'!$C$6,C58<>'Data Lookup Sheet'!$C$7),F58,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C58='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C58='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C58='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C58='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!C64","v":"Stage 7 - Change control"},null,{"$f":"COUNTIF(C54:C58,\"N/A\")","v":0},null,{"$f":"SUM(E54:E58)/(COUNTA(E54:E58)-$C59)","v":{"$error":"#N/A"}},{"$f":"SUM(F54:F58)/(COUNTA(F54:F58)-$C59)","v":{"$error":"#N/A"}},null,{"$f":"H2","v":"Target Met"},{"$f":"I2","v":"On Target"},"Late","Target","Target Not Applicable",{"$f":"M2","v":"Target Not Yet Assessed"},"Over Achieved"]
[{"$f":"'4. Maturity assessment'!D65","v":"Initiate change"},{"$f":"'4. Maturity assessment'!G65","v":0},{"$f":"'4. Maturity assessment'!H65","v":0},{"$f":"'4. Maturity assessment'!I65","v":"00:00:00"},{"$f":"VLOOKUP(B60,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C60,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$f":"IF(E60>=F60,E60,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E60<$F60,$D60>$B$1),$E60,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($E60<$F60,$D60<=$B$1),$E60,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(C60<>'Data Lookup Sheet'!$C$6,C60<>'Data Lookup Sheet'!$C$7),F60,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C60='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C60='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C60='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C60='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D66","v":"Assess change"},{"$f":"'4. Maturity assessment'!G66","v":0},{"$f":"'4. Maturity assessment'!H66","v":0},{"$f":"'4. Maturity assessment'!I66","v":"00:00:00"},{"$f":"VLOOKUP(B61,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C61,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C61<>'Data Lookup Sheet'!$C$6,C61<>'Data Lookup Sheet'!$C$7),F61,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C61='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C61='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C61='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C61='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D67","v":"Change control review board"},{"$f":"'4. Maturity assessment'!G67","v":0},{"$f":"'4. Maturity assessment'!H67","v":0},{"$f":"'4. Maturity assessment'!I67","v":"00:00:00"},{"$f":"VLOOKUP(B62,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C62,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C62<>'Data Lookup Sheet'!$C$6,C62<>'Data Lookup Sheet'!$C$7),F62,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C62='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C62='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C62='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C62='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D68","v":"Embody change"},{"$f":"'4. Maturity assessment'!G68","v":0},{"$f":"'4. Maturity assessment'!H68","v":0},{"$f":"'4. Maturity assessment'!I68","v":"00:00:00"},{"$f":"VLOOKUP(B63,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C63,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C63<>'Data Lookup Sheet'!$C$6,C63<>'Data Lookup Sheet'!$C$7),F63,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C63='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C63='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C63='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C63='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[{"$f":"'4. Maturity assessment'!D69","v":"PMB integrity and assurance"},{"$f":"'4. Maturity assessment'!G69","v":0},{"$f":"'4. Maturity assessment'!H69","v":0},{"$f":"'4. Maturity assessment'!I69","v":"00:00:00"},{"$f":"VLOOKUP(B64,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C64,'Data Lookup Sheet'!$C$11:$D$16,2)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(C64<>'Data Lookup Sheet'!$C$6,C64<>'Data Lookup Sheet'!$C$7),F64,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C64='Data Lookup Sheet'!$C$6,0,NA())","v":{"$error":"#N/A"}},{"$f":"IF(C64='Data Lookup Sheet'!$C$7,0,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(C64='Data Lookup Sheet'!$C$6,1,0)","v":0},{"$f":"IF(C64='Data Lookup Sheet'!$C$7,1,0)","v":0},{"$error":"#N/A"}]
[null,null,{"$f":"COUNTIF(C60:C64,\"N/A\")","v":0},null,{"$f":"SUM(E60:E64)/(COUNTA(E60:E64)-$C65)","v":{"$error":"#N/A"}},{"$f":"SUM(F60:F64)/(COUNTA(F60:F64)-$C65)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Totals",{"$f":"COUNTIF(N3:N64,\"<>0\")-7","v":55},55,55,55,0,0,55]
["Total Scores"]
["Current v Target Maturity Assessment","Current","Target"]
[{"$f":"A2","v":"Stage 0 - Culture and environment"},{"$f":"E11","v":{"$error":"#N/A"}},{"$f":"F11","v":{"$error":"#N/A"}}]
[{"$f":"A11","v":"Stage 1 - Organisation"},{"$f":"E22","v":{"$error":"#N/A"}},{"$f":"F22","v":{"$error":"#N/A"}}]
[{"$f":"A22","v":"Stage 2 - Scheduling and resourcing"},{"$f":"E33","v":{"$error":"#N/A"}},{"$f":"F33","v":{"$error":"#N/A"}}]
[{"$f":"A33","v":"Stage 3 - Budgeting and work authorisation"},{"$f":"E41","v":{"$error":"#N/A"}},{"$f":"F41","v":{"$error":"#N/A"}}]
[{"$f":"A41","v":{"$error":"#REF!"}},{"$f":"E47","v":{"$error":"#N/A"}},{"$f":"F47","v":{"$error":"#N/A"}}]
[{"$f":"A47","v":"Stage 5 - Accounting"},{"$f":"E53","v":{"$error":"#N/A"}},{"$f":"F53","v":{"$error":"#N/A"}}]
[{"$f":"A53","v":"Stage 6 - Managerial analysis"},{"$f":"E59","v":{"$error":"#N/A"}},{"$f":"F59","v":{"$error":"#N/A"}}]
[{"$f":"A59","v":"Stage 7 - Change control"},{"$f":"E65","v":{"$error":"#N/A"}},{"$f":"F65","v":{"$error":"#N/A"}}]