{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","1. Streamlined Template","2. Summary"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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. Streamlined Template","index":1,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Dimension","Parameter","Business as Usual (BAU)","Do Minimum","Do Maximum"]
["Part 1. Scope Options","Description","1.1 Existing provision ","1.2 Expand provision to include an additional business area as per updated core requirement","1.3 Expand provision to include additional business areas to meet core and desirable requirements"]
["Part 1. Scope Options","Potential Scope Needs Coverage","Current Arrangements","Essential","Desirable"]
["Part 1. Scope Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",2,3,3]
["Part 1. Scope Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",2,3,1]
["Part 1. Scope Options","Shortlisted Decision","Carried Forward (Baseline)","Preferred Way Forward","Discounted"]
["Part 1. Scope Options","Rationale","This option only meets some of the spending objectives because it would include provision for existing users, but does not take account of the current increase in demand from new business areas (i.e. core requirements). However, it will be shortlisted as a baseline as required under BBC NI guidance.",null,"This option has been discounted because a wider ongoing strategy for future delivery of this service is in development, thus the future requirements/needs may change. Also, this is currently unaffordable."]
["Part 2. Solution Options","Description","2.1 Extend existing arrangements (contract extension)","2.2 New Contract"]
["Part 2. Solution Options","Service Solutions Needs Coverage","Current Arrangements","Essential"]
["Part 2. Solution Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",2,3]
["Part 2. Solution Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",2,3]
["Part 2. Solution Options","Shortlisted Decision","Carried Forward (Baseline)","Preferred Way Forward"]
["Part 2. Solution Options","Rationale","Extending the current contract would meet the spending objectives and CSFs to some extent because it would allow continued service provision with little to no disruption. However, under this contract, there is no provision for the current increase in demand from new business areas."]
["Part 3. Delivery Options","Description","3.1 Extend existing arrangements (100% Outsourced)",null,"3.3 A % in-house delivery"]
["Part 3. Delivery Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",3,null,3]
["Part 3. Delivery Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",3,null,1]
["Part 3. Delivery Options","Shortlisted Decision","Preferred Way Forward",null,"Discounted"]
["Part 3. Delivery Options","Rationale",null,null,"Moving some of the service inhouse would have many advantages, however, staff resources are limited and inhouse delivery of this service is not a priority at the moment. This will be reconsidered as part of a wider ongoing strategy for the service."]
["Part 4. Implementation Options","Description","4.1 Extend existing contract for as long as is legally possible (2 years)","4.2 3 years with 2 1 year extension periods"]
["Part 4. Implementation Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",2,3]
["Part 4. Implementation Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",1,3]
["Part 4. Implementation Options","Shortlisted Decision","Carried Forward (Baseline)","Preferred Way Forward"]
["Part 4. Implementation Options","Rationale","The current contract would allow delivery of existing services for the next 2 years. However, a new wider strategy for this service is being developed and it is expected to take 3 years before it is fully developed procured and implemented. This options has been carried forward as required under BBC NI Guidance."]
["Part 5. Funding Options","Description","5.1 Existing Budget","5.2 Capital (Public) Funding","5.3 A % private funding"]
["Part 5. Funding Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",3,3,3]
["Part 5. Funding Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)",1,3,1]
["Part 5. Funding Options","Shortlisted Decision","Discounted","Preferred Way Forward","Discounted"]
["Part 5. Funding Options","Rationale","There is no money available from the existing budget, thus this option is unaffordable and unachievable. ",null,"The private sector would not be willing to fund this, thus this option is unachievable."]

{"sheet":"2. Summary","index":2,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Longlist Summary"]
[]
["Parameter","Dimension","Business as Usual (BAU)","Do Minimum","Do Maximum"]
["Description","Part 1. Scope Options","1.1 Existing provision ","1.2 Expand provision to include an additional business area as per updated core requirement","1.3 Expand provision to include additional business areas to meet core and desirable requirements"]
["Shortlisted Decision","Part 1. Scope Options","Carried Forward (Baseline)","Preferred Way Forward","Discounted"]
["Description","Part 2. Solution Options","2.1 Extend existing arrangements (contract extension)","2.2 New Contract"]
["Shortlisted Decision","Part 2. Solution Options","Carried Forward (Baseline)","Preferred Way Forward"]
["Description","Part 3. Delivery Options","3.1 Extend existing arrangements (100% Outsourced)",null,"3.3 A % in-house delivery"]
["Shortlisted Decision","Part 3. Delivery Options","Preferred Way Forward",null,"Discounted"]
["Description","Part 4. Implementation Options","4.1 Extend existing contract for as long as is legally possible (2 years)","4.2 3 years with 2 1 year extension periods"]
["Shortlisted Decision","Part 4. Implementation Options","Carried Forward (Baseline)","Preferred Way Forward"]
["Description","Part 5. Funding Options","5.1 Existing Budget","5.2 Capital (Public) Funding","5.3 A % private funding"]
["Shortlisted Decision","Part 5. Funding Options","Discounted","Preferred Way Forward","Discounted"]
[]
[]
[null,"Shortlisted Options"]
[null,"Using the Options Framework, the options considered at the long -list stage can be used to generate the potential short-list for the project."]
[]
[null,"Column1","Business As Usual (BAU)","Preferred Way Forward (PWF)"]
[null,"Part 1. Scope Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C6:$E6,$C5:$E5,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$6:$E$6,$C$5:$E$5,,0,1),IF((COUNTIF($C$6:$E$6,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$6:$E$6,$C$5:$E$5,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"1.1 Existing provision "},{"$f":"IF((COUNTIF($C$6:$E$6,\"Preferred Way Forward\")<=1),(_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$6:$E$6,$C$5:$E$5,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"1.2 Expand provision to include an additional business area as per updated core requirement"}]
[null,"Part 2. Solution Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C$8:$E$8,$C$7:$E$7,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$8:$E$8,$C$7:$E$7,,0,1),IF((COUNTIF($C$8:$E$8,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$8:$E$8,$C$7:$E$7,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"2.1 Extend existing arrangements (contract extension)"},{"$f":"IF((COUNTIF($C$8:$E$8,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$8:$E$8,$C$7:$E$7,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"2.2 New Contract"}]
[null,"Part 3. Delivery Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C$10:$E$10,$C$9:$E$9,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$10:$E$10,$C$9:$E$9,,0,1),IF((COUNTIF($C$10:$E$10,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$10:$E$10,$C$9:$E$9,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"3.1 Extend existing arrangements (100% Outsourced)"},{"$f":"IF((COUNTIF($C$10:$E$10,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$10:$E$10,$C$9:$E$9,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"3.1 Extend existing arrangements (100% Outsourced)"}]
[null,"Part 4. Implementation Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C$12:$E$12,$C$11:$E$11,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$12:$E$12,$C$11:$E$11,,0,1),IF((COUNTIF($C$12:$E$12,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$12:$E$12,$C$11:$E$11,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"4.1 Extend existing contract for as long as is legally possible (2 years)"},{"$f":"IF((COUNTIF($C$12:$E$12,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$12:$E$12,$C$11:$E$11,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"4.2 3 years with 2 1 year extension periods"}]
[null,"Part 5. Funding Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C$14:$E$14,$C$13:$E$13,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$14:$E$14,$C$13:$E$13,,0,1),IF((COUNTIF($C$14:$E$14,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$14:$E$14,$C$13:$E$13,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"5.2 Capital (Public) Funding"},{"$f":"IF((COUNTIF($C$14:$E$14,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$14:$E$14,$C$13:$E$13,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"5.2 Capital (Public) Funding"}]