{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","1.Scope","2.Solution","3.Delivery","4.Implementation","5.Funding","6.Summary"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Key:","Score"]
[null,"Option wholly or largely meets objective/CSF",3]
[null,"Partially meets objective/CSF",2]
[null,"Does not meet objective/CSF",1]
[]
[null,"Outcomes:"]
[null,"Carried Forward (Baseline)"]
[null,"Carried Forward"]
[null,"Preferred Way Forward"]
[null,"Discounted"]
[]
[null,"Hierarchy of Needs:"]
[null,"Current Arrangements"]
[null,"Essential"]
[null,"Desirable"]
[null,"Optional"]

{"sheet":"1.Scope","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Dimension","SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.","Business as Usual (BAU)","Do Minimum","Intermediate Option A","Intermediate Option B","Do Maximum"]
["1.Scope","Potential Scope Needs Coverage \nIdentify the potential scope of the project in terms of the operational capabilities required to satisfy the identified business needs. This helps avoid ‘scope creep’.","Current Arrangements","Essential","Desirable","Essential","Optional"]
["1.Scope","Scope Description\nDescribe the level of coverage under each option.","1.1 BAU/ Existing provision (assuming there is a building currently being used)","1.2 Small increase in provision to match projected increase in usage","1.3 A slightly bigger increase in provision to future proof against an increased requirement","1.4 Decrease in provision (i.e. remove a defunct part of the service)","1.5 Notable increase in provision. E.g. facilitating closure of 2 sites and amalgamate to one."]
["1.Scope","SPENDING OBJECTIVES (SO's)\nList the proposals SO's in the rows below and use the drop-down list to score how well each option performs against each SO (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["1.Scope","Objective 1: Full-service provision in the area (quantified in terms of staff/users) in place by 2026",1,2,3,1,3]
["1.Scope","Objective 2: Eliminate major cost inefficiencies (quantified in terms of unnecessary utilities/ maintenance costs etc.) by 2028"]
["1.Scope","Objective 3: Building compliant with all H&S regulations by 2026"]
["1.Scope","Total SO Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Business as Usual (BAU)]),-1,0))","v":1},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Minimum]),-1,0))","v":2},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option A]),-1,0))","v":3},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option B]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option B]),-1,0))","v":1},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Maximum]),-1,0))","v":3}]
["1.Scope","Rationale for SO Scoring\nWhere options do not score 3 (against any indivudal SOs), explain why this is the case.","Continuing with the current level of provision would not address the issue. For all options, scoring performance against objectives 1 and 2 is not applicable at this stage- this will be considered in other tabs later.","Service provision will be improved under Option 2, but this is unlikely to meet future requirements.",null,"Reducing the service provision will make the current situation worse and is not a viable option. "]
["1.Scope","CRITICAL SUCCESS FACTORS (CSFs)\nUse the drop-down list to score how well each option performs against each of the CSFs below (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["1.Scope","CSF 1: Strategic fit and meets business needs",1,2,3,1,3]
["1.Scope","CSF 2: Potential Value for Money",1,2,3,1,3]
["1.Scope","CSF 3: Supplier capacity and capability",3,3,3,3,3]
["1.Scope","CSF 4: Potential affordability",3,2,2,3,1]
["1.Scope","CSF 5: Potential achievability",3,3,3,3,1]
["1.Scope","Total CSF Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Business as Usual (BAU)]),-1,0))","v":11},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Minimum]),-1,0))","v":12},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option A]),-1,0))","v":14},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option B]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option B]),-1,0))","v":11},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10, Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Maximum]),-1,0))","v":11}]
["1.Scope","Rationale for CSF Scoring\nWhere options do not score 3 (against any individual CSF), explain why this is the case.","This option provides an inadequate level of service provision, thus not delivering on CSF 1 or 2.","This option involves a slight improvement on the BAU, thus it partly meets CSFs 1 and 2. Some additional funding will be required so it scores 2 for potential affordability.","This option only partially meets CSF 4 because some additional funding will be required.","This option provides an inadequate level of service provision, thus not delivering on CSF 1 or 2.","This option will require an additional level of funding which is not currently available. It would also take much longer to deliver and would be impossible to implement in the given timescale."]
["1.Scope","TOTAL SCORE - SOs & CSFs \n(This will automatically calculate)",{"$f":"SUM(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Business as Usual (BAU)]) + _xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Business as Usual (BAU)]))","v":12},{"$f":"SUM(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Minimum]) + _xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Minimum]))","v":14},{"$f":"SUM(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option A]) + _xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option A]))","v":17},{"$f":"SUM(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option B]) + _xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Intermediate Option B]))","v":12},{"$f":"SUM(_xlfn.XLOOKUP(Scope[]  SOScore1:SOScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Maximum]) + _xlfn.XLOOKUP(Scope[]  CSFScore1:CSFScore1,  Scope[[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]:[SCOPE OPTIONS \nList all possible options in terms of project scope/ coverage.]], Scope[Do Maximum]))","v":14}]
["1.Scope","Shortlist Decision \n(Based on colours above)","Carried Forward (Baseline)","Carried Forward","Preferred Way Forward","Discounted","Discounted"]
["1.Scope","Rationale \n(Should be justified based on the above)","This option does not meet any of the spending objectives or CSFs 1 & 2. Whilst it meets CSF 3-5, this is simply because no work is involved for this option. However, it will be shortlisted as a baseline as required under BBC NI guidance.","Whilst this option only partly meets the spending objectives and CSFs, it provides an indication of the level of minimum change required to address the issue for current users and has therefore been shortlisted as required under BBC NI guidance.","This option allows service provision to meet existing and future requirements. It has been selected as the preferred way forward because it scores the best regarding meeting the spending objectives and CSFs.","This option does not meet any of the spending objectives or CSFs 1 & 2. Whilst it meets CSF 3-5, this is simply because it offers reduced provision. For this reason, it has been rejected.","This option allows service provision to meet existing and future requirements. It also allows for better knowledge sharing and cost efficiencies. However, it has been rejected because it is deemed to be unachievable in the given timescale."]

{"sheet":"2.Solution","index":2,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Dimension","SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).","Business as Usual (BAU)","Do Minimum","Intermediate Option A","Intermediate Option B","Do Maximum"]
["2.Solution","Service Solutions Needs Coverage \nIdentify the potential scope of the project in terms of the service changes required to satisfy the identified business needs. This helps avoid ‘scope creep’.","Current Arrangements","Essential","Essential","Desirable","Optional"]
["2.Solution","Solution Description\nDescribe the solution under each option.","2.1 Maintain building to current standards","2.2 Extend and refurbish the existing building","2.3 Rent new accommodation","2.4 New building on current site","2.5 New building on different site"]
["2.Solution","SPENDING OBJECTIVES (SO's)\nList the proposals SO's in the rows below and use the drop-down list to score how well each option performs against each SO (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["2.Solution","Objective 1: Full-service provision in the area (quantified in terms of staff/users) in place by 2026",1,2,3,3,3]
["2.Solution","Objective 2: Eliminate major cost inefficiencies (quantified in terms of unnecessary utilities/ maintenance costs etc.) by 2028",1,2,3,3,3]
["2.Solution","Objective 3: Building compliant with all H&S regulations by 2026",1,2,3,3,3]
["2.Solution","Total SO Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2, Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Business as Usual (BAU)]),-1,0))","v":3},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2, Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Minimum]),-1,0))","v":6},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2, Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option A]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option B]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2, Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option B]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$4,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2, Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Maximum]),-1,0))","v":9}]
["2.Solution","Rationale for SO Scoring\nWhere options do not score 3 (against any indivudal SOs), explain why this is the case.","Option 1 would not be suitable for dealing with the increased service provision and would lead to various H&S risks. The maintenance backlog and high utility costs would not be addressed.","There is some improvement under option 2, but this is still likely to be an issue (for example building still not fully compliant with industry standards and some inefficiencies still exist given the layout of the building)."]
["2.Solution","CRITICAL SUCCESS FACTORS (CSFs)\nUse the drop-down list to score how well each option performs against each of the CSFs below (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["2.Solution","CSF 1: Strategic fit and meets business needs",1,2,2,3,3]
["2.Solution","CSF 2: Potential Value for Money",1,2,3,3,3]
["2.Solution","CSF 3: Supplier capacity and capability",3,3,3,3,3]
["2.Solution","CSF 4: Potential affordability",3,2,2,2,2]
["2.Solution","CSF 5: Potential achievability",3,3,1,3,1]
["2.Solution","Total CSF Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[] CSFScore2:CSFScore2,Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Business as Usual (BAU)]),-1,0))","v":11},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[] CSFScore2:CSFScore2,Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Minimum]),-1,0))","v":12},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[] CSFScore2:CSFScore2,Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option A]),-1,0))","v":11},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option B]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[] CSFScore2:CSFScore2,Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option B]),-1,0))","v":14},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$10,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Solution[] CSFScore2:CSFScore2,Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Maximum]),-1,0))","v":12}]
["2.Solution","Rationale for CSF Scoring\nWhere options do not score 3 (against any individual CSF), explain why this is the case.","Doing nothing would not address the current issues in terms of service provision and H&S risks.","As per the SOs above, this option only partially addresses the current issues (CSFS 1-2). It would require additional funding and thus also only partly meets CSF 4.","Under this option Government would enter a new lease which isn't ideal given existing accommodation policy (i.e. exit leases where possible). It would also involve additional funding so scores 2 for CSF 4. LPS has also confirmed that there are currently no sites available for lease, thus it is an unachievable option.","This option would require additional funding and thus only partly meets CSF 4.","This option would require additional funding and thus only partly meets CSF 4. LPS has also confirmed that there are no other suitable sites available, thus it scores 1 for CSF 5."]
["2.Solution","TOTAL SCORE - SOs & CSFs \n(This will automatically calculate)",{"$f":"SUM(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Business as Usual (BAU)]) + _xlfn.XLOOKUP(Solution[]  CSFScore2:CSFScore2,   Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Business as Usual (BAU)]))","v":14},{"$f":"SUM(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Minimum]) + _xlfn.XLOOKUP(Solution[]  CSFScore2:CSFScore2,   Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Minimum]))","v":18},{"$f":"SUM(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option A]) + _xlfn.XLOOKUP(Solution[]  CSFScore2:CSFScore2,   Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option A]))","v":20},{"$f":"SUM(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option B]) + _xlfn.XLOOKUP(Solution[]  CSFScore2:CSFScore2,   Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Intermediate Option B]))","v":23},{"$f":"SUM(_xlfn.XLOOKUP(Solution[]  SOScore2:SOScore2,  Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Maximum]) + _xlfn.XLOOKUP(Solution[]  CSFScore2:CSFScore2,   Solution[ [SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).]:[SOLUTION OPTIONS \nList all possible solutions for delivering part 1(scope).] ], Solution[Do Maximum]))","v":21}]
["2.Solution","Shortlist Decision \n(Based on colours above)","Carried Forward (Baseline)","Carried Forward","Discounted","Preferred Way Forward","Discounted"]
["2.Solution","Rationale \n(Should be justified based on the above)","This option does not meet any of the spending objectives or CSFs 1 & 2. Whilst it meets CSF 3-5, this is simply because no work is involved for this option. However, it will be shortlisted as a baseline as required under BBC NI guidance.","This option only partly meets the spending objectives and some of the CSFs. However, it does provide an indication of the level of minimum change required to address the issue for current users and has therefore been shortlisted as required under BBC NI guidance.","This option scores well, however there are no sites available for lease as confirmed by LPS in the last 6 months.","This option scores the best regarding meeting the spending objectives and CSFs and has therefore been selected as the preferred way forward for service delivery.","This option scores well, however there are no other sites available for a new build as confirmed by LPS in the last 6 months."]

{"sheet":"3.Delivery","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Dimension","DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).","Business as Usual (BAU)","Do Minimum","Intermediate Option A","Do Maximum"]
["3.Delivery","Delivery Description\nDescribe the delivery method under each option.","3.1 Do Nothing (N/A)","3.2 Local construction Market delivers","3.3 Open up to national contractors","3.4 Open up to international contractors"]
["3.Delivery","SPENDING OBJECTIVES (SO's)\nList the proposals SO's in the rows below and use the drop-down list to score how well each option performs against each SO (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["3.Delivery","Objective 1: Full-service provision in the area (quantified in terms of staff/users) in place by 2026",1,3,3,3]
["3.Delivery","Objective 2: Eliminate major cost inefficiencies (quantified in terms of unnecessary utilities/ maintenance costs etc.) by 2028",1,3,3,3]
["3.Delivery","Objective 3: Building compliant with all H&S regulations by 2026",1,3,3,3]
["3.Delivery","Total SO Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Delivery[]  SOScore3:SOScore3, Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Business as Usual (BAU)]),-1,0))","v":3},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Delivery[]  SOScore3:SOScore3, Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Minimum]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Delivery[]  SOScore3:SOScore3, Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Intermediate Option A]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Delivery[]  SOScore3:SOScore3, Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Maximum]),-1,0))","v":9}]
["3.Delivery","Rationale for SO Scoring\nWhere options do not score 3 (against any indivudal SOs), explain why this is the case.","Doing nothing would not meet any SOs and is not a valid option."]
["3.Delivery","CRITICAL SUCCESS FACTORS (CSFs)\nUse the drop-down list to score how well each option performs against each of the CSFs below (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["3.Delivery","CSF 1: Strategic fit and meets business needs",1,3,3,3]
["3.Delivery","CSF 2: Potential Value for Money",1,3,3,3]
["3.Delivery","CSF 3: Supplier capacity and capability",3,3,3,3]
["3.Delivery","CSF 4: Potential affordability",3,2,2,2]
["3.Delivery","CSF 5: Potential achievability",3,3,2,2]
["3.Delivery","Total CSF Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Delivery[]  CSFScore3:CSFScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Business as Usual (BAU)]),-1,0))","v":11},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Delivery[]  CSFScore3:CSFScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Minimum]),-1,0))","v":14},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Delivery[]  CSFScore3:CSFScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Intermediate Option A]),-1,0))","v":13},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Delivery[]  CSFScore3:CSFScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Maximum]),-1,0))","v":13}]
["3.Delivery","Rationale for CSF Scoring\nWhere options do not score 3 (against any individual CSF), explain why this is the case.","Doing nothing would not address the current issues in terms of service provision and H&S risks.","This option scores 2 for CSF 4 because it will require additional funding.","This option scores 2 for CSFs 4 and 5 because it will require additional funding and could result in a longer procurement that will be tight given current timescales.","As per option 3.3."]
["3.Delivery","TOTAL SCORE - SOs & CSFs \n(This will automatically calculate)",{"$f":"SUM(_xlfn.XLOOKUP(Delivery[]  SOScore3:SOScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Business as Usual (BAU)]) + _xlfn.XLOOKUP(Delivery[]  CSFScore3:CSFScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Business as Usual (BAU)]))","v":14},{"$f":"SUM(_xlfn.XLOOKUP(Delivery[]  SOScore3:SOScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Minimum]) + _xlfn.XLOOKUP(Delivery[]  CSFScore3:CSFScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Minimum]))","v":23},{"$f":"SUM(_xlfn.XLOOKUP(Delivery[]  SOScore3:SOScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Intermediate Option A]) + _xlfn.XLOOKUP(Delivery[]  CSFScore3:CSFScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Intermediate Option A]))","v":22},{"$f":"SUM(_xlfn.XLOOKUP(Delivery[]  SOScore3:SOScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Maximum]) + _xlfn.XLOOKUP(Delivery[]  CSFScore3:CSFScore3,  Delivery[[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]:[DELIVERY OPTIONS \nList all possible options in terms of how to deliver parts 1(scope) and 2(solution).]], Delivery[Do Maximum]))","v":22}]
["3.Delivery","Shortlist Decision \n(Based on colours above)","Carried Forward (Baseline)","Preferred Way Forward","Discounted","Discounted"]
["3.Delivery","Rationale \n(Should be justified based on the above)","This option is not a viable option, however it has been carried forward as a baseline as required under BBC NI guidance.","This option either fully or partly meets all of the spending objectives/ CSFs to a better extent than options 3 or 4 and has therefore be selected as the preferred way forward.","Whilst this option either fully or partly meets all of the SOs/ CSFs, it does so to a lesser extent than option 3.2. CPD has also advised that there is enough capability and capacity in the local market so this option is not necessary.","As per option 3.3."]

{"sheet":"4.Implementation","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Dimension","IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).","Business as Usual (BAU)","Do Minimum","Intermediate Option A","Do Maximum"]
["4.Implementation","Implementation Description\nDescribe how each option will be implemented.","4.1 Do Nothing (N/A)","4.2 Phasing without decant","4.3 Phasing with decant","4.4 Big Bang over x weeks."]
["4.Implementation","SPENDING OBJECTIVES (SO's)\nList the proposals SO's in the rows below and use the drop-down list to score how well each option performs against each SO (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["4.Implementation","Objective 1: Full-service provision in the area (quantified in terms of staff/users) in place by 2026",1,3,3,3]
["4.Implementation","Objective 2: Eliminate major cost inefficiencies (quantified in terms of unnecessary utilities/ maintenance costs etc.) by 2028",1,3,3,3]
["4.Implementation","Objective 3: Building compliant with all H&S regulations by 2026",1,3,3,3]
["4.Implementation","Total SO Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Implementation[]  SOScore4:SOScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Business as Usual (BAU)]),-1,0))","v":3},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Implementation[]  SOScore4:SOScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Minimum]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Implementation[]  SOScore4:SOScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Intermediate Option A]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Implementation[]  SOScore4:SOScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Maximum]),-1,0))","v":9}]
["4.Implementation","Rationale for SO Scoring\nWhere options do not score 3 (against any indivudal SOs), explain why this is the case.","Doing nothing would not meet any SOs and is not a valid option."]
["4.Implementation","CRITICAL SUCCESS FACTORS (CSFs)\nUse the drop-down list to score how well each option performs against each of the CSFs below (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["4.Implementation","CSF 1: Strategic fit and meets business needs",1,2,2,3]
["4.Implementation","CSF 2: Potential Value for Money",1,2,2,3]
["4.Implementation","CSF 3: Supplier capacity and capability",3,3,3,3]
["4.Implementation","CSF 4: Potential affordability",3,2,2,2]
["4.Implementation","CSF 5: Potential achievability",3,1,3,3]
["4.Implementation","Total CSF Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Implementation[]  CSFScore4:CSFScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Business as Usual (BAU)]),-1,0))","v":11},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Implementation[]  CSFScore4:CSFScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Minimum]),-1,0))","v":10},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Implementation[]  CSFScore4:CSFScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Intermediate Option A]),-1,0))","v":12},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Implementation[]  CSFScore4:CSFScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Maximum]),-1,0))","v":14}]
["4.Implementation","Rationale for CSF Scoring\nWhere options do not score 3 (against any individual CSF), explain why this is the case.","Doing nothing would not address the current issues in terms of service provision and H&S risks.","This option is likely to disrupt service delivery to a small extent, furthermore it will take longer to complete and therefore be more of a wait before all issues are fully addressed, thus it scores 2 for CSFs 1&2. It also scores 2 for CSF 4 because it will require additional funding. CPD has confirmed that for the works to be completed safely a full decant is required (i.e. 1 for CSF 5).","As per option 4.2. However, the score for CSF 5 is 3 because CPD has confirmed the work is possible with a full decant.","Whilst this option still only partially meets CSF 4, it is expected to be cheaper than phasing with a decant."]
["4.Implementation","TOTAL SCORE - SOs & CSFs \n(This will automatically calculate)",{"$f":"SUM(_xlfn.XLOOKUP(Implementation[]  SOScore4:SOScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Business as Usual (BAU)]) + _xlfn.XLOOKUP(Implementation[]  CSFScore4:CSFScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Business as Usual (BAU)]))","v":14},{"$f":"SUM(_xlfn.XLOOKUP(Implementation[]  SOScore4:SOScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Minimum]) + _xlfn.XLOOKUP(Implementation[]  CSFScore4:CSFScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Minimum]))","v":19},{"$f":"SUM(_xlfn.XLOOKUP(Implementation[]  SOScore4:SOScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Intermediate Option A]) + _xlfn.XLOOKUP(Implementation[]  CSFScore4:CSFScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Intermediate Option A]))","v":21},{"$f":"SUM(_xlfn.XLOOKUP(Implementation[]  SOScore4:SOScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Maximum]) + _xlfn.XLOOKUP(Implementation[]  CSFScore4:CSFScore4,  Implementation[[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]:[IMPLEMENTATION OPTIONS \nList all possible options in terms of how to implement parts 1(scope), 2(solution) and 3(Delivery).]], Implementation[Do Maximum]))","v":23}]
["4.Implementation","Shortlist Decision \n(Based on colours above)","Carried Forward (Baseline)","Discounted","Carried Forward","Preferred Way Forward"]
["4.Implementation","Rationale \n(Should be justified based on the above)","This option is not a viable option, however it has been carried forward as a baseline as required under BBC NI guidance.","This option is not achievable as CPD has confirmed that it is not possible to complete the work without decanting existing staff.","This option has the ability to meet all of the SOs and CSFs. However, the longer time period and the need for decant could impact negatively on service delivery and lead to higher costs if not managed appropriately. It has been carried forward as a potential solution.","This option either fully or partly meets all of the SOs and CSFs and has therefore been selected as the preferred way forward."]

{"sheet":"5.Funding","index":5,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Dimension","FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).","Business as Usual (BAU)","Do Minimum","Intermediate Option A","Do Maximum"]
["5.Funding","Funding Description\nDescribe how each option will be funded.","5.1 Existing Budget","5.2 Capital (public) funding","5.3 Mixed public and private funding","5.4 Private finance"]
["5.Funding","SPENDING OBJECTIVES (SO's)\nList the proposals SO's in the rows below and use the drop-down list to score how well each option performs against each SO (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["5.Funding","Objective 1: Full-service provision in the area (quantified in terms of staff/users) in place by 2026",3,3,3,3]
["5.Funding","Objective 2: Eliminate major cost inefficiencies (quantified in terms of unnecessary utilities/ maintenance costs etc.) by 2028",3,3,3,3]
["5.Funding","Objective 3: Building compliant with all H&S regulations by 2026",3,3,3,3]
["5.Funding","Total SO Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Funding[]  SOScore5:SOScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Business as Usual (BAU)]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Funding[]  SOScore5:SOScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Minimum]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Funding[]  SOScore5:SOScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Intermediate Option A]),-1,0))","v":9},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$3,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Funding[]  SOScore5:SOScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Maximum]),-1,0))","v":9}]
["5.Funding","Rationale for SO Scoring\nWhere options do not score 3 (against any indivudal SOs), explain why this is the case."]
["5.Funding","CRITICAL SUCCESS FACTORS (CSFs)\nUse the drop-down list to score how well each option performs against each of the CSFs below (1 does not meet, 2 partially meets and 3 wholly or largely meets). The cell colour will automatically change to reflect the score."]
["5.Funding","CSF 1: Strategic fit and meets business needs",3,3,3,3]
["5.Funding","CSF 2: Potential Value for Money",3,3,3,3]
["5.Funding","CSF 3: Supplier capacity and capability",3,3,3,3]
["5.Funding","CSF 4: Potential affordability",1,2,2,3]
["5.Funding","CSF 5: Potential achievability",1,3,1,1]
["5.Funding","Total CSF Score (This will automatically calculate)",{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Business as Usual (BAU)]),1,0): OFFSET(_xlfn.XLOOKUP(Funding[]  CSFScore5:CSFScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Business as Usual (BAU)]),-1,0))","v":11},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Minimum]),1,0): OFFSET(_xlfn.XLOOKUP(Funding[]  CSFScore5:CSFScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Minimum]),-1,0))","v":14},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Intermediate Option A]),1,0): OFFSET(_xlfn.XLOOKUP(Funding[]  CSFScore5:CSFScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Intermediate Option A]),-1,0))","v":12},{"$f":"SUM(OFFSET(_xlfn.XLOOKUP($B$9,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Maximum]),1,0): OFFSET(_xlfn.XLOOKUP(Funding[]  CSFScore5:CSFScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Maximum]),-1,0))","v":13}]
["5.Funding","Rationale for CSF Scoring\nWhere options do not score 3 (against any individual CSF), explain why this is the case.","This option is not affordable or achievable because there is no money available in the current budget.","This option scores 2 for CSF 4 because it will require an additional amount of public sector funding.","This option scores 2 for CSF 4 because it will require an additional amount of public sector funding. It is not achievable because the private sector are unwilling to provide any funding.","This option is not thought to be achievable because the private sector are unwilling to provide any funding."]
["5.Funding","TOTAL SCORE - SOs & CSFs \n(This will automatically calculate)",{"$f":"SUM(_xlfn.XLOOKUP(Funding[]  SOScore5:SOScore5,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Business as Usual (BAU)]) + _xlfn.XLOOKUP(Funding[]  CSFScore5:CSFScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Business as Usual (BAU)]))","v":20},{"$f":"SUM(_xlfn.XLOOKUP(Funding[]  SOScore5:SOScore5,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Minimum]) + _xlfn.XLOOKUP(Funding[]  CSFScore5:CSFScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Minimum]))","v":23},{"$f":"SUM(_xlfn.XLOOKUP(Funding[]  SOScore5:SOScore5,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Intermediate Option A]) + _xlfn.XLOOKUP(Funding[]  CSFScore5:CSFScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Intermediate Option A]))","v":21},{"$f":"SUM(_xlfn.XLOOKUP(Funding[]  SOScore5:SOScore5,  Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Maximum]) + _xlfn.XLOOKUP(Funding[]  CSFScore5:CSFScore5,   Funding[[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]:[FUNDING OPTIONS \nList all possible funding options for parts 1(scope), 2(solution), 3(Delivery) and 4(Implementation).]], Funding[Do Maximum]))","v":22}]
["5.Funding","Shortlist Decision \n(Based on colours above)","Carried Forward (Baseline)","Preferred Way Forward","Discounted","Discounted"]
["5.Funding","Rationale \n(Should be justified based on the above)","This option is not a viable option, however it has been carried forward as a baseline as required under BBC NI guidance.","This option either fully or partly meets all of the spending objectives and CSFs and has therefore been selected as the preferred way forward.","This option scores well regarding the SOs and CSFs. However, it has been rejected because there is no funding available from the private sector.","As per option 5.3."]

{"sheet":"6.Summary","index":6,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["Longlist Summary"]
[]
["Dimension","Business as Usual (BAU)","Do Minimum","Intermediate Option A","Intermediate Option B","Do Maximum"]
["1.Scope","1.1 BAU/ Existing provision (assuming there is a building currently being used)","1.2 Small increase in provision to match projected increase in usage","1.3 A slightly bigger increase in provision to future proof against an increased requirement","1.4 Decrease in provision (i.e. remove a defunct part of the service)","1.5 Notable increase in provision. E.g. facilitating closure of 2 sites and amalgamate to one."]
["1.Scope","Carried Forward (Baseline)","Carried Forward","Preferred Way Forward","Discounted","Discounted"]
["2.Solution","2.1 Maintain building to current standards","2.2 Extend and refurbish the existing building","2.3 Rent new accommodation","2.4 New building on current site","2.5 New building on different site"]
["2.Solution","Carried Forward (Baseline)","Carried Forward","Discounted","Preferred Way Forward","Discounted"]
["3.Delivery","3.1 Do Nothing (N/A)","3.2 Local construction Market delivers","3.3 Open up to national contractors",null,"3.4 Open up to international contractors"]
["3.Delivery","Carried Forward (Baseline)","Preferred Way Forward","Discounted",null,"Discounted"]
["4.Implementation","4.1 Do Nothing (N/A)","4.2 Phasing without decant","4.3 Phasing with decant",null,"4.4 Big Bang over x weeks."]
["4.Implementation","Carried Forward (Baseline)","Discounted","Carried Forward",null,"Preferred Way Forward"]
["5.Funding","5.1 Existing Budget","5.2 Capital (public) funding","5.3 Mixed public and private funding",null,"5.4 Private finance"]
["5.Funding","Carried Forward (Baseline)","Preferred Way Forward","Discounted",null,"Discounted"]
[]
[]
["Shortlisted Options"]
["Using the Options Framework, the options considered at the long -list stage can be used to generate the potential short-list for the project."]
[]
["Column1","Business As Usual (BAU)","Do Minimum","Preferred Way Forward (PWF)"]
["1.Scope",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $B6:$F6,$B5:$F5,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$6:$F$6,$B$5:$F$5,,0,1),IF((COUNTIF($B$6:$F$6,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$6:$F$6,$B$5:$F$5,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"1.1 BAU/ Existing provision (assuming there is a building currently being used)"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$6:$F$6,$B$5:$F$5,,0,1),IF((COUNTIF($B$6:$F$6,\"Preferred Way Forward\")<=1),(_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$6:$F$6,$B$5:$F$5,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"1.2 Small increase in provision to match projected increase in usage"},{"$f":"IF((COUNTIF($B$6:$F$6,\"Preferred Way Forward\")<=1),(_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$6:$F$6,$B$5:$F$5,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"1.3 A slightly bigger increase in provision to future proof against an increased requirement"}]
["2.Solution",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $B$8:$F$8,$B$7:$F$7,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$8:$F$8,$B$7:$F$7,,0,1),IF((COUNTIF($B$8:$F$8,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$8:$F$8,$B$7:$F$7,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"2.1 Maintain building to current standards"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$8:$F$8,$B$7:$F$7,,0,1),IF((COUNTIF($B$8:$F$8,\"Preferred Way Forward\")<=1),(_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$8:$F$8,$B$7:$F$7,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"2.2 Extend and refurbish the existing building"},{"$f":"IF((COUNTIF($B$8:$F$8,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$8:$F$8,$B$7:$F$7,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"2.4 New building on current site"}]
["3.Delivery",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $B$10:$F$10,$B$9:$F$9,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$10:$F$10,$B$9:$F$9,,0,1),IF((COUNTIF($B$10:$F$10,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$10:$F$10,$B$9:$F$9,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"3.1 Do Nothing (N/A)"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$10:$F$10,$B$9:$F$9,,0,1),IF((COUNTIF($B$10:$F$10,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$10:$F$10,$B$9:$F$9,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"3.2 Local construction Market delivers"},{"$f":"IF((COUNTIF($B$10:$F$10,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$10:$F$10,$B$9:$F$9,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"3.2 Local construction Market delivers"}]
["4.Implementation",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $B$12:$F$12,$B$11:$F$11,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$12:$F$12,$B$11:$F$11,,0,1),IF((COUNTIF($B$12:$F$12,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$12:$F$12,$B$11:$F$11,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"4.1 Do Nothing (N/A)"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$12:$F$12,$B$11:$F$11,,0,1),IF((COUNTIF($B$12:$F$12,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$12:$F$12,$B$11:$F$11,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"4.3 Phasing with decant"},{"$f":"IF((COUNTIF($B$12:$F$12,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$12:$F$12,$B$11:$F$11,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"4.4 Big Bang over x weeks."}]
["5.Funding",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $B$14:$F$14,$B$13:$F$13,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$14:$F$14,$B$13:$F$13,,0,1),IF((COUNTIF($B$14:$F$14,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$14:$F$14,$B$13:$F$13,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"5.1 Existing Budget"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$B$14:$F$14,$B$13:$F$13,,0,1),IF((COUNTIF($B$14:$F$14,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$14:$F$14,$B$13:$F$13,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"5.2 Capital (public) funding"},{"$f":"IF((COUNTIF($B$14:$F$14,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$B$14:$F$14,$B$13:$F$13,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"5.2 Capital (public) funding"}]