{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Definitions","Criteri","Scoring Table","Bar Chart","Matrix","Strategic Priorities","Planning Principles","VBHC Area of focus"],"not_rendered":{"charts":2,"images":15,"macros":1,"external_links":0,"defined_names":5,"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":"Definitions","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,2,1]]}
[null,"Definitions"]
[]
[]
[null,"Weighting","The relative importance assigned to each criteria, to be agreed by group using the tool e.g., IHC, Pan BCU Service, Programme."]
[null,"Value","The financial and quality impact the project will have on stakeholders, and the degree of strategic alignment"]
[null,"Deliverability","Factors that will impact the deliverability of a project including complexity and risk, resources, investment level required"]
[null,"What is a Citizen","People, family, friends, and carers that are accessing or should have access to BCUHB services"]
[null,"Financial Efficiency (impact)","What type of financial savings does the change initiative intend to deliver? i.e. efficiency savings, cashable or non cashable savings\nExample: Cash Releasing Savings could be created by replacing a costly paper method with electronic delivery method (releasing cash not spent on paper, and no longer required in that budget).  Efficiency Saving that is not monetised such as a process change that results in reducing a waiting list or improving service quality"]
[null,"Recurring (investment)","Funding/investment that is required on an annual/regular basis to ensure the ongoing delivery of the change initiative into the business as usual phase. \nExample: Staff recruited on a permanent basis to deliver a new service or service development, service charge to maintain equipment"]
[null,"Non-Recurring (investment)","Funding/investment for a specific purpose and expended in a specified manner that is not expected to be received again following the implementation and move to business as usual phases. \nExample: Equipment that does not require maintenance subscriptions, staff recruited on a fixed-term contract. "]
[null,"Complexity","Factors that will impact the deliverability of a project including: project size and duration, level of collaboration, stakeholder size, is the project going to develop in a stable environment or be impacted by strategic and  political changes. \n "]

{"sheet":"Criteri","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,0,13,0],[14,0,17,0]]}
["Guidance "]
["This section provides you with guidance on how to complete the scoring table"]
["Weighting"]
[null,null,"Descriptor ","Scoring ","Guidance"]
[null,"Value criteria ","See definitions tab","% 'weight' per question ","To be locally agreed and to sum to 100% across all value criteria (NB: the higher the % allocated the more importance 'weight' is given to a criterion) "]
[null,"Deliverability criteria","See definitions tab","% 'weight' per question ","To be locally agreed and to sum to 100% across all deliverability criteria (NB: the higher the % allocated the more importance 'weight' is given to a criterion)"]
[]
["Prioritisation critieria"]
[null,"Assessment ","Descriptor ","Scoring ","Guidance"]
["Value","1. Strategic Priority","The extent to which the initiative is aligned with strategic priorities","1 = no alignment\n5 = moderate alignment\n10 = strong alignment","No alignment\n- No alignment with the 10 Strategic Priorities \n\nModerate alignment\n- Aligns with 1-4 of the 10 Strategic Priorities\n\nStrong alignment\n-Aligns with 5-10 of the 10 Strategic Priorities \n"]
[null,"2. Planning Principles","The extent to which the initiative is aligned with the Planning Principles","1 = no alignment\n5 = moderate alignment\n10 = strong alignment","No alignment\n- No alignment with the 5 Planning Principles\n\nModerate alignment\n- Aligns with 1-2 of the Planning Principles\n\nStrong alignment\n- Aligns with 3-5 of the Planning Principles\n"]
[null,"3. Impact on Citizen Wellbeing","The extent to which the initiative has an impact on citizen wellbeing","1 =  Minimal Impact\n5 = Moderate Impact\n10 =  Life Changing Impact","Minimal Impact\n- No impact on any of the VBHC 5 Areas of Focus\n\nModerate Impact\n- Moderate impact on at least one of the VBHC 5 Areas of Focus\n\nLife Changing Impact\n- Has a significant impact on at least one of the the VBHC 5 Areas of Focus\n"]
[null,"4. Organisational Financial Efficiency ( Financial Output)","Does it recognise a cash or non-cash releasing saving or efficiency? ","1 =  No financial efficiency saving\n5 = Delivers non cash efficiency saving\n10 = Delivers cash releasing saving","No financial efficiency saving\nThe change/initiative does not produce any financial efficiency saving, or release any money\n\nDelivers non cash efficiency saving\nThe change/initiative delivers an efficiency saving but it cannot be quantified as a financial saving i.e. may reduce the time it takes to perform a task which can then be utilised to perform another task, may improve a process which in term reduces a waiting list\n\nDelivers cash releasing saving\nThe change/initiative releases cash from the budget i.e. moving from a paper to an electric method of delivery will no longer require the production of paper copies and release cash from printing budget, reduction in pressure ulcers will reduce spend on dressings"]
[null,"5. Quality & Safety ","Clinical risk mitigation, mandatory requirement, Quality Metrics, Performance Challenge.","1 =  Negative Impact on quality and safety\n5 = No change to quality and safety\n10 =  Improves quality and safety","Negative Impact on quality and safety\nThe change/initiative will have a negative impact on the quality and safety of services provided i.e. to reduce cost or negative financial impact service redesign may focus less on quality and more on cost savings \n\nNo change to quality and safety\nQuality and safety remains the same and is not influenced or impacted by the change/initiative\n\nImproves quality and safety\nThe change/initiative has a direct causal relationship with improvements to baseline quality and safety measures i.e. improvements in a pathway may result in patients being seen quicker, reducing time to treatment, and improving patient experience of service. "]
["Deliverability","6. Recurring / non-recurring funding? (Financial Input)","Does the initiative require  investment, is it cost neutral or does it result in a saving?","1 =  Recurrent funding \n5 = Non-recurring funding required\n10 = No additional funding required","Recurrent funding \n- Recurrent funding is required to sustain the change/initiative\n\nNon-recurring funding required\n - Funding/investment required for a specific purpose and expended in a specified manner that is not expected to be received again following the implementation and move to business as usual phases. \n\nNo additional funding required\n- Affordable and finance has been secured for project delivery and ongoing operational costs\n"]
[null,"7. Is the infrastructure and/or estates resource  secured?  ","Is the  resource available when required to deliver the initiative?  For example digital, estate building, lease...? ","1 = No\n5 = Partially\n10 = Yes","No\n- Low capacity in the services with No resources allocated to the project team\n- No Estates available\n- No Digital Infrastructure set up\n\nPartially\n- Medium capacity in the services with some resources allocated to the project team\n- Some Estates support available\n- Some Digital Infrastructure set up\n\nYes\n- High capacity in the services, with resources allocated to the project team\n- Full Estates support available\n- Some Digital Infrastructure set up\n"]
[null,"8. Is the workforce resource available when required? ","Is the workforce resource available when required? For example recruitment, secondment…?","1 = No\n5 = Partially\n10 = Yes","No\n- Workforce not available\n- Low capability in the services\n- High change management implication\n\nPartially\n- Half of the workforce required is available\n- Medium capability in the services\n- Change management needed\n\nYes\n- Full workforce required is available\n- High capability in the services\n- No change management needed\n"]
[null,"9. Complexity (risk of non deliverability)","What is the degree of complexity associated with the initiative? For example what is the degree of risk and the duration of the project?","1=  high complexity/high risk \n5 = medium complexity/medium risk\n10 = low complexity/low risk","High complexity/High risk\n- Delivery timescale is +18 Months \n- Relies on multiple collaborators to be successful\n- Competitive tender required/undertaken and supplier is unknown \n- Dependant on 3+ other projects and a number of suppliers \n- May be impacted by strategic or political influences\n- Infrastructure would  need to be developed \n\nMedium \n- Delivery timescale is 12 -18 months \n- Relies on small number of collaborators to be successful\n- Dependant on 2 or more other projects \n- Minimal impacted by strategic or political influences\n- Infrastructure is partially developed\n\nLow complexity / Low Risk\n- Delivery timescale is less than 12 months \n- Relies on no collaborators to be successful\n- Done before, previous successful proof of concept. Successful  off the shelf solution. No design or development required\n- Not dependant on other projects\n- Not impacted by strategic or political influences\n- Enhances existing infrastructure\n\n"]

{"sheet":"Scoring Table","index":2,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,16,41,20],[3,3,3,7],[3,9,3,12],[3,14,8,14],[3,8,7,8],[3,13,8,13],[4,6,5,6],[4,7,5,7],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12]]}
[null,null,null,{"$f":"+(10*D10)","v":0},{"$f":"+(10*E10)","v":0},0,0,0,{"$f":"SUM(D1:H1)","v":0},0,0,0,0,{"$f":"SUM(J1:M1)","v":0}]
[null,null,null,{"$f":"D10","v":0},0,0,0,0,{"$f":"SUM(D2:H2)","v":0},{"$f":"J10","v":0},{"$f":"K10","v":0},{"$f":"L10","v":0},{"$f":"M10","v":0},{"$f":"SUM(J2:M2)","v":0}]
[null,"Prioritisation Tool - Scoring Table "]
[null,null,null,"Value",null,null,null,null,"The higher the score the more attractive the initiative.","Deliverability",null,null,null,"The higher the score, the more likely the initiative will be delivered successfully","Total Value & Deliverability score\n"]
[null,null,null,"Strategic Priorities","Planning Principles","Impact on Citizen Wellbeing\n(Outcomes  / Experience)","Organisational Financial Efficiency ( Financial Output)","Quality & Safety \n(Risk)",null,"Recurring / non-recurring funding? (Financial Input)","Is the infrastructure and/or estates resource  secured?  ","Is the workforce resource available when required? ","Complexity \n(risk of non deliverability)"]
[null,null,null,"Strategic Priorities","Planning Principles","VBHC - 6 Areas of Focus",null,"Clinical Risk mitigation, mandatory requirement,Quality Metrics, Performance Challenge."]
[null,null,null,"The extent to which the initiative is aligned with strategic priorities","The extent to which the initiative is aligned with the Planning Principles","The extent to which the initiative has an impact on citizen wellbeing","Does it recognise a cash or non-cash releasing saving or efficiency? ","Clinical risk mitigation, mandatory requirement,Quality Metrics, Performance Challenge.",null,"Does the initiative require  investment, is it cost neutral or does it result in a saving?","Is the  resource available when required to deliver the initiative?  For example digital, estate building, lease...? ","Is the workforce resource available when required? For example recruitment, secondment…?","What is the degree of complexity associated with the initiative? For example what is the degree of risk and the duration of the project?"]
[null,null,null,"1 = no alignment\n5 = moderate alignment\n10 = strong alignment","1 = no alignment\n5 = moderate alignment\n10 = strong alignment","1 =  Minimal Impact\n5 = Moderate Impact\n10 =  Life Changing Impact","1 =  No financial efficiency saving\n5 = Delivers non cash efficiency saving\n10 = Delivers cash releasing saving","1 =  Negative Impact on quality and safety\n5 = No change to quality and safety\n10 =  Improves quality and safety",null,"1 =  Recurrent funding \n5 = Non-recurring funding required\n10 = No additional funding required","1 = No\n5 = Partially\n10 = Yes","1 = No\n5 = Partially\n10 = Yes","1=  high complexity/high risk \n5 = medium complexity/medium risk\n10 = low complexity/low risk"]
[null,null,null,"Weighting","Weighting","Weighting","Weighting","Weighting",null,"Weighting","Weighting","Weighting","Weighting"]
[null,"Short Ref","Initiative Name",0,0,0,0,0,"Value Score",0,0,0,0,"Deliverability Score","Total Score",null,"Steps to use the Tool\n\n1 ) List the initiatives to be scored\nEnter the names of the initiatives to be scored in the 'Initiative Name' column C.  Enter a shorter version of the name of the initiative in the 'Reference' column B.  The Reference rather than the full initiative name will appear on the Matrix and Bar Chart, helping to keep the chart decluttered and easy to read.\n\n2) Score the initiatives \nBegin the scoring process.  Taking each initiative in turn, determine a score in each category refering to the category description and range.   Start with the green 'Value' section and then the blue 'Deliverability' section.\n\nThe Value and Deliverability Total Score cells are automatically calculated using a formula that multiplies each score by the weighting for each category.  \n\n3) Sort the Total Score column 'P' from \nLargest to Smallest. \nOnce column P is sorted from 'Largest to Smallest', the bar chart will display correctly, ranking the scores from highest to lowest.\n \n4) Review the results \nAll scores are automatically plotted on the Bar Chart and the Matrix "]
[null,null,null,null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0},null,null,null,null,{"$f":"SUM(J11:M11)","v":0},{"$f":"+I11+N11","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,null,"TOTAL ",{"$f":"+(D11*D10)+(D12*D10)+(D13*D10)+(D14*D10)+(D15*D10)+(D16*D10)+(D17*D10)+(D18*D10)+(D19*D10)+(D20*D10)+(D21*D10)+(D22*D10)+(D23*D10)+(D24*D10)+(D25*D10)+(D26*D10)+(D27*D10)+(D28*D10)+(D29*D10)+(D30*D10)+(D31*D10)+(D32*D10)+(D33*D10)+(D34*D10)+(D35*D10)+(D36*D10)+(D37*D10)+(D38*D10)+(D39*D10)+(D40*D10)+(D41*D10)+(D42*D10)","v":0},{"$f":"+(E11*E10)+(E12*E10)+(E13*E10)+(E14*E10)+(E15*E10)+(E16*E10)+(E17*E10)+(E18*E10)+(E19*E10)+(E20*E10)+(E21*E10)+(E22*E10)+(E23*E10)+(E24*E10)+(E25*E10)+(E26*E10)+(E27*E10)+(E28*E10)+(E29*E10)+(E30*E10)+(E31*E10)+(E32*E10)+(E33*E10)+(E34*E10)+(E35*E10)+(E36*E10)+(E37*E10)+(E38*E10)+(E39*E10)+(E40*E10)+(E41*E10)+(E42*E10)","v":0},{"$f":"+(F11*F10)+(F12*F10)+(F13*F10)+(F14*F10)+(F15*F10)+(F16*F10)+(F17*F10)+(F18*F10)+(F19*F10)+(F20*F10)+(F21*F10)+(F22*F10)+(F23*F10)+(F24*F10)+(F25*F10)+(F26*F10)+(F27*F10)+(F28*F10)+(F29*F10)+(F30*F10)+(F31*F10)+(F32*F10)+(F33*F10)+(F34*F10)+(F35*F10)+(F36*F10)+(F37*F10)+(F38*F10)+(F39*F10)+(F40*F10)+(F41*F10)+(F42*F10)","v":0},{"$f":"+(G11*G10)+(G12*G10)+(G13*G10)+(G14*G10)+(G15*G10)+(G16*G10)+(G17*G10)+(G18*G10)+(G19*G10)+(G20*G10)+(G21*G10)+(G22*G10)+(G23*G10)+(G24*G10)+(G25*G10)+(G26*G10)+(G27*G10)+(G28*G10)+(G29*G10)+(G30*G10)+(G31*G10)+(G32*G10)+(G33*G10)+(G34*G10)+(G35*G10)+(G36*G10)+(G37*G10)+(G38*G10)+(G39*G10)+(G40*G10)+(G41*G10)+(G42*G10)","v":0},{"$f":"+(H11*H10)+(H12*H10)+(H13*H10)+(H14*H10)+(H15*H10)+(H16*H10)+(H17*H10)+(H18*H10)+(H19*H10)+(H20*H10)+(H21*H10)+(H22*H10)+(H23*H10)+(H24*H10)+(H25*H10)+(H26*H10)+(H27*H10)+(H28*H10)+(H29*H10)+(H30*H10)+(H31*H10)+(H32*H10)+(H33*H10)+(H34*H10)+(H35*H10)+(H36*H10)+(H37*H10)+(H38*H10)+(H39*H10)+(H40*H10)+(H41*H10)+(H42*H10)","v":0},{"$f":"SUM(I11:I42)","v":0},{"$f":"+(J11*J10)+(J12*J10)+(J13*J10)+(J14*J10)+(J15*J10)+(J16*J10)+(J17*J10)+(J18*J10)+(J19*J10)+(J20*J10)+(J21*J10)+(J22*J10)+(J23*J10)+(J24*J10)+(J25*J10)+(J26*J10)+(J27*J10)+(J28*J10)+(J29*J10)+(J30*J10)+(J31*J10)+(J32*J10)+(J33*J10)+(J34*J10)+(J35*J10)+(J36*J10)+(J37*J10)+(J38*J10)+(J39*J10)+(J40*J10)+(J41*J10)+(J42*J10)","v":0},{"$f":"+(K11*K10)+(K12*K10)+(K13*K10)+(K14*K10)+(K15*K10)+(K16*K10)+(K17*K10)+(K18*K10)+(K19*K10)+(K20*K10)+(K21*K10)+(K22*K10)+(K23*K10)+(K24*K10)+(K25*K10)+(K26*K10)+(K27*K10)+(K28*K10)+(K29*K10)+(K30*K10)+(K31*K10)+(K32*K10)+(K33*K10)+(K34*K10)+(K35*K10)+(K36*K10)+(K37*K10)+(K38*K10)+(K39*K10)+(K40*K10)+(K41*K10)+(K42*K10)","v":0},{"$f":"+(L11*L10)+(L12*L10)+(L13*L10)+(L14*L10)+(L15*L10)+(L16*L10)+(L17*L10)+(L18*L10)+(L19*L10)+(L20*L10)+(L21*L10)+(L22*L10)+(L23*L10)+(L24*L10)+(L25*L10)+(L26*L10)+(L27*L10)+(L28*L10)+(L29*L10)+(L30*L10)+(L31*L10)+(L32*L10)+(L33*L10)+(L34*L10)+(L35*L10)+(L36*L10)+(L37*L10)+(L38*L10)+(L39*L10)+(L40*L10)+(L41*L10)+(L42*L10)","v":0},{"$f":"+(M11*M10)+(M12*M10)+(M13*M10)+(M14*M10)+(M15*M10)+(M16*M10)+(M17*M10)+(M18*M10)+(M19*M10)+(M20*M10)+(M21*M10)+(M22*M10)+(M23*M10)+(M24*M10)+(M25*M10)+(M26*M10)+(M27*M10)+(M28*M10)+(M29*M10)+(M30*M10)+(M31*M10)+(M32*M10)+(M33*M10)+(M34*M10)+(M35*M10)+(M36*M10)+(M37*M10)+(M38*M10)+(M39*M10)+(M40*M10)+(M41*M10)+(M42*M10)","v":0},{"$f":"SUM(N11:N42)","v":0},{"$f":"+N43+I43","v":0}]

{"sheet":"Bar Chart","index":3,"n_rows":4,"n_cols":26,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,25,34,29]]}
[null,null,"Bar Chart"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guidance Notes \n\nInitiatives are ranked from left to right, in the order of highest to lowest overall total score.   \n\nThe green section of the bar represents the Value score. \n\nThe blue section of the bar represents the Deliverability score.    \n\nNote: If the chart does not rank the initiatives from highest to lowest, go to the Scoring Table tab and use the filter button in column 'P' to sort the list from 'Largest to Smallest'.\n\n"]

{"sheet":"Matrix","index":4,"n_rows":10,"n_cols":32,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,28,19,32]]}
[]
[null,"Matrix  - Value v Deliverability"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Axis Points","Min","Mid","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizontal",{"$f":"'Scoring Table'!I2","v":0},{"$f":"+(AF7-AD7)/2","v":0},{"$f":"'Scoring Table'!I1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vertical",{"$f":"'Scoring Table'!N2","v":0},{"$f":"+(AF8-AD8)/2","v":0},{"$f":"'Scoring Table'!N1","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guidance Notes \n\nBottom Right Quadrant\nContains high value initiatives and difficult to deliver initiatives.  A strategy for options in this quadrant might be to check if anything can be done to improve the ease of delivery.   For example, by seeking to redeploy staff or by applying for alternative funding. \n\nTop Left Quadrant\nContains low value but easy to deliver initiatives. A strategy for options plotted in this quadrant might be to check if anything can be done to increase the level of value realised.  \n\nTop Right Quadrant\nContains high value and easy to deliver initiatives.  These should be short-listed for further consideration. \n\nBottom Left Quadrant\nContains both low value and difficult to deliver options."]

{"sheet":"Strategic Priorities","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Planning Principles","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"VBHC Area of focus","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}