{"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":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Dimension","Parameter","Business as Usual (BAU)","Do Minimum","Intermediate Option A","Intermediate Option B","Do Maximum"]
["Part 1. Scope Options","Description"]
["Part 1. Scope Options","Potential Scope Needs Coverage"]
["Part 1. Scope Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 1. Scope Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 1. Scope Options","Shortlisted Decision"]
["Part 1. Scope Options","Rationale"]
["Part 2. Solution Options","Description"]
["Part 2. Solution Options","Service Solutions Needs Coverage"]
["Part 2. Solution Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 2. Solution Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 2. Solution Options","Shortlisted Decision"]
["Part 2. Solution Options","Rationale"]
["Part 3. Delivery Options","Description"]
["Part 3. Delivery Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 3. Delivery Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 3. Delivery Options","Shortlisted Decision"]
["Part 3. Delivery Options","Rationale"]
["Part 4. Implementation Options","Description"]
["Part 4. Implementation Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 4. Implementation Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 4. Implementation Options","Shortlisted Decision"]
["Part 4. Implementation Options","Rationale"]
["Part 5. Funding Options","Description"]
["Part 5. Funding Options","Ability to meet all Spending Objectives\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 5. Funding Options","Ability to meet all CSFs\n(1 does not meet, 2 partially meets and 3 wholly or largely meets)"]
["Part 5. Funding Options","Shortlisted Decision"]
["Part 5. Funding Options","Rationale"]

{"sheet":"2. Summary","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Longlist Summary"]
[]
["Parameter","Dimension","Business as Usual (BAU)","Do Minimum","Intermediate Option A","Intermediate Option B","Do Maximum"]
["Description","Part 1. Scope Options"]
["Shortlisted Decision","Part 1. Scope Options"]
["Description","Part 2. Solution Options"]
["Shortlisted Decision","Part 2. Solution Options"]
["Description","Part 3. Delivery Options"]
["Shortlisted Decision","Part 3. Delivery Options"]
["Description","Part 4. Implementation Options"]
["Shortlisted Decision","Part 4. Implementation Options"]
["Description","Part 5. Funding Options"]
["Shortlisted Decision","Part 5. Funding Options"]
[]
[]
[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)","Do Minimum","Preferred Way Forward (PWF)"]
[null,"Part 1. Scope Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C11:$G11,$C10:$G10,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$11:$G$11,$C$10:$G$10,,0,1),IF((COUNTIF($C$11:$G$11,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$11:$G$11,$C$10:$G$10,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"PWF Option Required"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$11:$G$11,$C$10:$G$10,,0,1),IF((COUNTIF($C$11:$G$11,\"Preferred Way Forward\")<=1),(_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$11:$G$11,$C$10:$G$10,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"PWF Option Required"},{"$f":"IF((COUNTIF($C$11:$G$11,\"Preferred Way Forward\")<=1),(_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$11:$G$11,$C$10:$G$10,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"PWF Option Required"}]
[null,"Part 2. Solution Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C$13:$G$13,$C$12:$G$12,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$13:$G$13,$C$12:$G$12,,0,1),IF((COUNTIF($C$13:$G$13,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$13:$G$13,$C$12:$G$12,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"PWF Option Required"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$13:$G$13,$C$12:$G$12,,0,1),IF((COUNTIF($C$13:$G$13,\"Preferred Way Forward\")<=1),(_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$13:$G$13,$C$12:$G$12,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"PWF Option Required"},{"$f":"IF((COUNTIF($C$13:$G$13,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$13:$G$13,$C$12:$G$12,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"PWF Option Required"}]
[null,"Part 3. Delivery Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C$15:$G$15,$C$14:$G$14,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$15:$G$15,$C$14:$G$14,,0,1),IF((COUNTIF($C$15:$G$15,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$15:$G$15,$C$14:$G$14,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"PWF Option Required"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$15:$G$15,$C$14:$G$14,,0,1),IF((COUNTIF($C$15:$G$15,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$15:$G$15,$C$14:$G$14,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"PWF Option Required"},{"$f":"IF((COUNTIF($C$15:$G$15,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$15:$G$15,$C$14:$G$14,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"PWF Option Required"}]
[null,"Part 4. Implementation Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C$17:$G$17,$C$16:$G$16,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$17:$G$17,$C$16:$G$16,,0,1),IF((COUNTIF($C$17:$G$17,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$17:$G$17,$C$16:$G$16,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"PWF Option Required"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$17:$G$17,$C$16:$G$16,,0,1),IF((COUNTIF($C$17:$G$17,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$17:$G$17,$C$16:$G$16,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"PWF Option Required"},{"$f":"IF((COUNTIF($C$17:$G$17,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$17:$G$17,$C$16:$G$16,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"PWF Option Required"}]
[null,"Part 5. Funding Options",{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward (Baseline)\", $C$19:$G$19,$C$18:$G$18,,0,1),IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$19:$G$19,$C$18:$G$18,,0,1),IF((COUNTIF($C$19:$G$19,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$19:$G$19,$C$18:$G$18,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")))","v":"PWF Option Required"},{"$f":"IFERROR(_xlfn.XLOOKUP(\"Carried Forward\",$C$19:$G$19,$C$18:$G$18,,0,1),IF((COUNTIF($C$19:$G$19,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$19:$G$19,$C$18:$G$18,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\"))","v":"PWF Option Required"},{"$f":"IF((COUNTIF($C$19:$G$19,\"Preferred Way Forward\")<=1), (_xlfn.XLOOKUP(\"Preferred Way Forward\",$C$19:$G$19,$C$18:$G$18,\"PWF Option Required\",0,1)),\"There should only be one PWF per dimension\")","v":"PWF Option Required"}]