{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Phase 1 - Scoring","Phase 2 - Scoring","Results"],"not_rendered":{"charts":5,"images":2,"macros":0,"external_links":0,"defined_names":0,"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":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["For support, contact your Home Clinic Liaison"]
["Instructions for scoring Home Clinic Client Summary mockups"]
["1. Generate Client Summary mockups for 10 enrolled patients per participating provider ( your Home Clinic Liaison can provide support)"]
["2. Number each mockup from 1 through 10"]
["3. Complete evaluation of the mockups using 3 data quality characteristics from the EMR Data Quality Evaluation Guide as shown below (Bowen, 2012)"]
["4. Score your evaluation using the 5-point scale provided (1/2 points are permitted)"]
[null,"a. Use the Phase 1  - Scoring tab to record baseline data quality scores after your first evaluation of the mockups "]
[null,"b. Add comments where applicable to provide additional context to the scoring"]
[null,"d. Scores will be visually displayed in the Results tab"]
["5. Analyze results; perform practice reflection to consider reasons and rationale for the findings"]
["6. Use frameworks such as SMART Goals and PDSA cycles to prepare, plan and implement a data quality improvement activity (recommended timeframe 4-6 weeks)"]
["7. Once the improvement activity is completed, generate the same 10 Client Summary mockups; number them the same way as the first evaluation"]
["8. Repeat the evaluation process"]
[null,"a. Use the Phase 2 - Scoring tab to record post improvement activity data quality scores; add comments as applicable"]
[null,"b. Review the Results tab to access tables and charts that display your evaluation results along with comparison data and score distributions"]
["Note: This Worksheet is built to automatically calculate results and charts"]
["* If using a peer review process, each evaluator should use their own version of this scoring tool; compare Results after completing Phase 1 and Phase 2 evaluation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CLICK HERE"]

{"sheet":"Phase 1 - Scoring","index":1,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,4,28,8],[15,3,15,4],[15,5,15,6],[15,7,15,8],[16,3,16,4],[16,5,16,6],[16,7,16,8],[29,4,29,8],[30,4,30,8],[19,1,19,3],[19,4,19,8],[9,3,14,4],[9,5,14,6],[9,7,14,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[17,3,17,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[3,0,8,1],[3,3,4,4],[3,5,4,6],[3,7,4,8],[5,3,8,4],[5,5,8,6],[5,7,8,8]]}
["Home Clinic Client Summary Mockup approach"]
["EMR Data Quality Evaluation Tool"]
[]
["Evaluate each mockup using the data quality metrics and scale provided",null,null,"Completeness",null,"Currency",null,"Consistency                   \n(Form and Capture)   "]
[]
[null,null,null,"Is the data free from significant gaps and reliable?",null,"Does the data represent the most recent activities and reflect the most current information available?",null,"Are the data elements captured in the same way and consistently recorded in the same place?"]
[]
[]
[]
["Scoring Scale*",null,null,"e.g. Prescription for diabetes but no diabetes diagnosis recorded",null,"e.g. Absence of recent blood pressure recording for patient with recorded hypertension diagnosis",null,"Form: e.g. Same diagnosis recorded in multiple formats   (e.g. Diab2, Type2 Diabetes, DM2)\n \nCapture: e.g. Blood pressure recorded in discrete data field vs free text in chart note"]
[5,"Very frequently"]
[4,"Frequently"]
[3,"Occasionally"]
[2,"Rarely",null,null,null,null,null,null,null,null,"Phase 1"]
[1,"Never",null,null,null,null,null,null,null,null,"Overall"]
[null,null,null,"Average Score",null,"Average Score",null,"Average Score",null,null,"Average Score"]
[null,null,null,{"$f":"SUM(B22:B31)/10","v":0},null,{"$f":"SUM(C22:C31)/10","v":0},null,{"$f":"SUM(D22:D31)/10","v":0},null,null,{"$f":"SUM(D17,F17,H17)/3","v":0}]
[null,null,null,"Average scores will auto-populate"]
["Phase 1 - Baseline Evaluation"]
[null,"If shown, Click the \"Edit Workbook\" button above to begin. \nEnter scores below using scale provided \n1/2 points are permitted from 0.5 to 4.5 (maximum score = 5)",null,null,"Type any comments to support your score (optional)"]
[null,"Completeness","Currency","Consistency","Comments"]
["Mockup 1"]
["Mockup 2"]
["Mockup 3"]
["Mockup 4"]
["Mockup 5"]
["Mockup 6"]
["Mockup 7"]
["Mockup 8"]
["Mockup 9"]
["Mockup 10"]

{"sheet":"Phase 2 - Scoring","index":2,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[25,4,25,8],[16,3,16,4],[16,5,16,6],[16,7,16,8],[17,3,17,8],[19,1,19,3],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[9,3,14,4],[9,5,14,6],[9,7,14,8],[15,3,15,4],[15,5,15,6],[15,7,15,8],[3,0,8,1],[3,3,4,4],[3,5,4,6],[3,7,4,8],[5,3,8,4],[5,5,8,6],[5,7,8,8]]}
["Home Clinic Client Summary Mockup approach"]
["EMR Data Quality Evaluation Tool"]
[]
["Evaluate each mockup using the data quality metrics and scale provided",null,null,"Completeness",null,"Currency",null,"Consistency                   \n(Form and Capture)   "]
[]
[null,null,null,"Is the data free from significant gaps and reliable?",null,"Does the data represent the most recent activities and reflect the most current information available?",null,"Are the data elements captured in the same way and consistently recorded in the same place?"]
[]
[]
[]
["Scoring Scale*",null,null,"e.g. Prescription for diabetes but no diabetes diagnosis recorded",null,"e.g. Absence of recent blood pressure recording for patient with recorded hypertension diagnosis",null,"Form: e.g. Same diagnosis recorded in multiple formats   (e.g. Diab2, Type2 Diabetes, DM2)\n \nCapture: e.g. Blood pressure recorded in discrete data field vs free text in chart note"]
[5,"Very frequently"]
[4,"Frequently"]
[3,"Occasionally"]
[2,"Rarely",null,null,null,null,null,null,null,null,"Phase 2"]
[1,"Never",null,null,null,null,null,null,null,null,"Overall"]
[null,null,null,"Average Score",null,"Average Score",null,"Average Score",null,null,"Average Score"]
[null,null,null,{"$f":"SUM(B22:B31)/10","v":0},null,{"$f":"SUM(C22:C31)/10","v":0},null,{"$f":"SUM(D22:D31)/10","v":0},null,null,{"$f":"SUM(D17,F17,H17)/3","v":0}]
[null,null,null,"Average scores will auto-populate"]
["Phase 2 - Post-improvement Evaluation"]
[null,"If shown, Click the \"Edit Workbook\" button above to begin. \nEnter scores below using scale provided \n1/2 points are permitted from 0.5 to 4.5 (maximum score = 5)",null,null,"Type any comments to support your score (optional)"]
[null,"Completeness","Currency","Consistency","Comments"]
["Mockup 1"]
["Mockup 2"]
["Mockup 3"]
["Mockup 4"]
["Mockup 5"]
["Mockup 6"]
["Mockup 7"]
["Mockup 8"]
["Mockup 9"]
["Mockup 10"]

{"sheet":"Results","index":3,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Results will calculate automatically based on data entry in Phase 1 and Phase 2 Scoring tabs"]
[null,null,null,"For support contact your Home Clinic Liaison"]
[]
[null,null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10"]
["COMP","Phase 1",{"$f":"'Phase 1 - Scoring'!B22","v":0},{"$f":"'Phase 1 - Scoring'!B23","v":0},{"$f":"'Phase 1 - Scoring'!B24","v":0},{"$f":"'Phase 1 - Scoring'!B25","v":0},{"$f":"'Phase 1 - Scoring'!B26","v":0},{"$f":"'Phase 1 - Scoring'!B27","v":0},{"$f":"'Phase 1 - Scoring'!B28","v":0},{"$f":"'Phase 1 - Scoring'!B29","v":0},{"$f":"'Phase 1 - Scoring'!B30","v":0},{"$f":"'Phase 1 - Scoring'!B31","v":0}]
[null,"Phase 2",{"$f":"'Phase 2 - Scoring'!B22","v":0},{"$f":"'Phase 2 - Scoring'!B23","v":0},{"$f":"'Phase 2 - Scoring'!B24","v":0},{"$f":"'Phase 2 - Scoring'!B25","v":0},{"$f":"'Phase 2 - Scoring'!B26","v":0},{"$f":"'Phase 2 - Scoring'!B27","v":0},{"$f":"'Phase 2 - Scoring'!B28","v":0},{"$f":"'Phase 2 - Scoring'!B29","v":0},{"$f":"'Phase 2 - Scoring'!B30","v":0},{"$f":"'Phase 2 - Scoring'!B31","v":0}]
["CURR","Phase 1",{"$f":"'Phase 1 - Scoring'!C22","v":0},{"$f":"'Phase 1 - Scoring'!C23","v":0},{"$f":"'Phase 1 - Scoring'!C24","v":0},{"$f":"'Phase 1 - Scoring'!C25","v":0},{"$f":"'Phase 1 - Scoring'!C26","v":0},{"$f":"'Phase 1 - Scoring'!C27","v":0},{"$f":"'Phase 1 - Scoring'!C28","v":0},{"$f":"'Phase 1 - Scoring'!C29","v":0},{"$f":"'Phase 1 - Scoring'!C30","v":0},{"$f":"'Phase 1 - Scoring'!C31","v":0}]
[null,"Phase 2",{"$f":"'Phase 2 - Scoring'!C22","v":0},{"$f":"'Phase 2 - Scoring'!C23","v":0},{"$f":"'Phase 2 - Scoring'!C24","v":0},{"$f":"'Phase 2 - Scoring'!C25","v":0},{"$f":"'Phase 2 - Scoring'!C26","v":0},{"$f":"'Phase 2 - Scoring'!C27","v":0},{"$f":"'Phase 2 - Scoring'!C28","v":0},{"$f":"'Phase 2 - Scoring'!C29","v":0},{"$f":"'Phase 2 - Scoring'!C30","v":0},{"$f":"'Phase 2 - Scoring'!C31","v":0}]
["CONS","Phase 1",{"$f":"'Phase 1 - Scoring'!D22","v":0},{"$f":"'Phase 1 - Scoring'!D23","v":0},{"$f":"'Phase 1 - Scoring'!D24","v":0},{"$f":"'Phase 1 - Scoring'!D25","v":0},{"$f":"'Phase 1 - Scoring'!D26","v":0},{"$f":"'Phase 1 - Scoring'!D27","v":0},{"$f":"'Phase 1 - Scoring'!D28","v":0},{"$f":"'Phase 1 - Scoring'!D29","v":0},{"$f":"'Phase 1 - Scoring'!D30","v":0},{"$f":"'Phase 1 - Scoring'!D31","v":0}]
[null,"Phase 2",{"$f":"'Phase 2 - Scoring'!D22","v":0},{"$f":"'Phase 2 - Scoring'!D23","v":0},{"$f":"'Phase 2 - Scoring'!D24","v":0},{"$f":"'Phase 2 - Scoring'!D25","v":0},{"$f":"'Phase 2 - Scoring'!D26","v":0},{"$f":"'Phase 2 - Scoring'!D27","v":0},{"$f":"'Phase 2 - Scoring'!D28","v":0},{"$f":"'Phase 2 - Scoring'!D29","v":0},{"$f":"'Phase 2 - Scoring'!D30","v":0},{"$f":"'Phase 2 - Scoring'!D31","v":0}]
[]
[null,null,null,null,null,null,null,null,"(0.5-2.4)","(2.5-4.4)","(4.5-5.0)"]
[null,null,"Average","% change",null,null,null,null,"Low","Med","High"]
["COMP","Phase 1",{"$f":"SUM(C5:L5)/10","v":0},null,null,null,"COMP","Phase 1",{"$f":"SUM(COUNTIFS($C$5,\">= 0.5\",$C$5,\"<= 2.4\")+COUNTIFS($D$5,\">= 0.5\",$D$5,\"<= 2.4\")+COUNTIFS($E$5,\">= 0.5\",$E$5,\"<=2.4\")+COUNTIFS($F$5,\">= 0.5\",$F$5,\"<=2.4\")+COUNTIFS($G$5,\">= 0.5\",$G$5,\"<=2.4\")+COUNTIFS($H$5,\">= 0.5\",$H$5,\"<=2.4\")+COUNTIFS($I$5,\">= 0.5\",$I$5,\"<=2.4\")+COUNTIFS($J$5,\">= 0.5\",$J$5,\"<=2.4\")+COUNTIFS($K$5,\">= 0.5\",$K$5,\"<=2.4\")+COUNTIFS($L$5,\">= 0.5\",$L$5,\"<=2.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$5,\">= 2.5\",$C$5,\"<= 4.4\")+COUNTIFS($D$5,\">= 2.5\",$D$5,\"<= 4.4\")+COUNTIFS($E$5,\">= 2.5\",$E$5,\"<= 4.4\")+COUNTIFS($F$5,\">= 2.5\",$F$5,\"<= 4.4\")+COUNTIFS($G$5,\">= 2.5\",$G$5,\"<= 4.4\")+COUNTIFS($H$5,\">= 2.5\",$H$5,\"<= 4.4\")+COUNTIFS($I$5,\">= 2.5\",$I$5,\"<= 4.4\")+COUNTIFS($J$5,\">= 2.5\",$J$5,\"<= 4.4\")+COUNTIFS($K$5,\">= 2.5\",$K$5,\"<= 4.4\")+COUNTIFS($L$5,\">= 2.5\",$L$5,\"<= 4.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$5,\">= 4.5\",$C$5,\"<= 5.0\")+COUNTIFS($D$5,\">= 4.5\",$D$5,\"<= 5.0\")+COUNTIFS($E$5,\">= 4.5\",$E$5,\"<= 5.0\")+COUNTIFS($F$5,\">= 4.5\",$F$5,\"<= 5.0\")+COUNTIFS($G$5,\">= 4.5\",$G$5,\"<= 5.0\")+COUNTIFS($H$5,\">= 4.5\",$H$5,\"<= 5.0\")+COUNTIFS($I$5,\">= 4.5\",$I$5,\"<= 5.0\")+COUNTIFS($J$5,\">= 4.5\",$J$5,\"<= 5.0\")+COUNTIFS($K$5,\">= 4.5\",$K$5,\"<= 5.0\")+COUNTIFS($L$5,\">= 4.5\",$L5,\"<= 5.0\"))/10","v":0}]
[null,"Phase 2",{"$f":"SUM(C6:L6)/10","v":0},{"$f":"(C15/C14)-1","v":{"$error":"#DIV/0!"}},null,null,null,"Phase 2",{"$f":"SUM(COUNTIFS($C$6,\">= 0.5\",$C$6,\"<= 2.4\")+COUNTIFS($D$6,\">= 0.5\",$D$6,\"<= 2.4\")+COUNTIFS($E$6,\">= 0.5\",$E$6,\"<=2.4\")+COUNTIFS($F$6,\">= 0.5\",$F$6,\"<=2.4\")+COUNTIFS($G$6,\">= 0.5\",$G$6,\"<=2.4\")+COUNTIFS($H$6,\">= 0.5\",$H$6,\"<=2.4\")+COUNTIFS($I$6,\">= 0.5\",$I$6,\"<=2.4\")+COUNTIFS($J$6,\">= 0.5\",$J$6,\"<=2.4\")+COUNTIFS($K$6,\">= 0.5\",$K$6,\"<=2.4\")+COUNTIFS($L$6,\">= 0.5\",$L$6,\"<=2.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$6,\">= 2.5\",$C$6,\"<= 4.4\")+COUNTIFS($D$6,\">= 2.5\",$D$6,\"<= 4.4\")+COUNTIFS($E$6,\">= 2.5\",$E$6,\"<= 4.4\")+COUNTIFS($F$6,\">= 2.5\",$F$6,\"<= 4.4\")+COUNTIFS($G$6,\">= 2.5\",$G$6,\"<= 4.4\")+COUNTIFS($H$6,\">= 2.5\",$H$6,\"<= 4.4\")+COUNTIFS($I$6,\">= 2.5\",$I$6,\"<= 4.4\")+COUNTIFS($J$6,\">= 2.5\",$J$6,\"<= 4.4\")+COUNTIFS($K$6,\">= 2.5\",$K$6,\"<= 4.4\")+COUNTIFS($L$6,\">= 2.5\",$L$6,\"<= 4.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$6,\">= 4.5\",$C$6,\"<= 5.0\")+COUNTIFS($D$6,\">= 4.5\",$D$6,\"<= 5.0\")+COUNTIFS($E$6,\">= 4.5\",$E$6,\"<= 5.0\")+COUNTIFS($F$6,\">= 4.5\",$F$6,\"<= 5.0\")+COUNTIFS($G$6,\">= 4.5\",$G$6,\"<= 5.0\")+COUNTIFS($H$6,\">= 4.5\",$H$6,\"<= 5.0\")+COUNTIFS($I$6,\">= 4.5\",$I$6,\"<= 5.0\")+COUNTIFS($J$6,\">= 4.5\",$J$6,\"<= 5.0\")+COUNTIFS($K$6,\">= 4.5\",$K$6,\"<= 5.0\")+COUNTIFS($L$6,\">= 4.5\",$L6,\"<= 5.0\"))/10","v":0}]
["CURR","Phase 1",0,null,null,null,"CURR","Phase 1",{"$f":"SUM(COUNTIFS($C$7,\">= 0.5\",$C$7,\"<= 2.4\")+COUNTIFS($D$7,\">= 0.5\",$D$7,\"<= 2.4\")+COUNTIFS($E$7,\">= 0.5\",$E$7,\"<=2.4\")+COUNTIFS($F$7,\">= 0.5\",$F$7,\"<=2.4\")+COUNTIFS($G$7,\">= 0.5\",$G$7,\"<=2.4\")+COUNTIFS($H$7,\">= 0.5\",$H$7,\"<=2.4\")+COUNTIFS($I$7,\">= 0.5\",$I$7,\"<=2.4\")+COUNTIFS($J$7,\">= 0.5\",$J$7,\"<=2.4\")+COUNTIFS($K$7,\">= 0.5\",$K$7,\"<=2.4\")+COUNTIFS($L$7,\">= 0.5\",$L$7,\"<=2.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$7,\">= 2.5\",$C$7,\"<= 4.4\")+COUNTIFS($D$7,\">= 2.5\",$D$7,\"<= 4.4\")+COUNTIFS($E$7,\">= 2.5\",$E$7,\"<= 4.4\")+COUNTIFS($F$7,\">= 2.5\",$F$7,\"<= 4.4\")+COUNTIFS($G$7,\">= 2.5\",$G$7,\"<= 4.4\")+COUNTIFS($H$7,\">= 2.5\",$H$7,\"<= 4.4\")+COUNTIFS($I$7,\">= 2.5\",$I$7,\"<= 4.4\")+COUNTIFS($J$7,\">= 2.5\",$J$7,\"<= 4.4\")+COUNTIFS($K$7,\">= 2.5\",$K$7,\"<= 4.4\")+COUNTIFS($L$7,\">= 2.5\",$L$7,\"<= 4.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$7,\">= 4.5\",$C$7,\"<= 5.0\")+COUNTIFS($D$7,\">= 4.5\",$D$7,\"<= 5.0\")+COUNTIFS($E$7,\">= 4.5\",$E$7,\"<= 5.0\")+COUNTIFS($F$7,\">= 4.5\",$F$7,\"<= 5.0\")+COUNTIFS($G$7,\">= 4.5\",$G$7,\"<= 5.0\")+COUNTIFS($H$7,\">= 4.5\",$H$7,\"<= 5.0\")+COUNTIFS($I$7,\">= 4.5\",$I$7,\"<= 5.0\")+COUNTIFS($J$7,\">= 4.5\",$J$7,\"<= 5.0\")+COUNTIFS($K$7,\">= 4.5\",$K$7,\"<= 5.0\")+COUNTIFS($L$7,\">= 4.5\",$L7,\"<= 5.0\"))/10","v":0}]
[null,"Phase 2",0,{"$f":"(C17/C16)-1","v":{"$error":"#DIV/0!"}},null,null,null,"Phase 2",{"$f":"SUM(COUNTIFS($C$8,\">= 0.5\",$C$8,\"<= 2.4\")+COUNTIFS($D$8,\">= 0.5\",$D$8,\"<= 2.4\")+COUNTIFS($E$8,\">= 0.5\",$E$8,\"<=2.4\")+COUNTIFS($F$8,\">= 0.5\",$F$8,\"<=2.4\")+COUNTIFS($G$8,\">= 0.5\",$G$8,\"<=2.4\")+COUNTIFS($H$8,\">= 0.5\",$H$8,\"<=2.4\")+COUNTIFS($I$8,\">= 0.5\",$I$8,\"<=2.4\")+COUNTIFS($J$8,\">= 0.5\",$J$8,\"<=2.4\")+COUNTIFS($K$8,\">= 0.5\",$K$8,\"<=2.4\")+COUNTIFS($L$8,\">= 0.5\",$L$8,\"<=2.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$8,\">= 2.5\",$C$8,\"<= 4.4\")+COUNTIFS($D$8,\">= 2.5\",$D$8,\"<= 4.4\")+COUNTIFS($E$8,\">= 2.5\",$E$8,\"<= 4.4\")+COUNTIFS($F$8,\">= 2.5\",$F$8,\"<= 4.4\")+COUNTIFS($G$8,\">= 2.5\",$G$8,\"<= 4.4\")+COUNTIFS($H$8,\">= 2.5\",$H$8,\"<= 4.4\")+COUNTIFS($I$8,\">= 2.5\",$I$8,\"<= 4.4\")+COUNTIFS($J$8,\">= 2.5\",$J$8,\"<= 4.4\")+COUNTIFS($K$8,\">= 2.5\",$K$8,\"<= 4.4\")+COUNTIFS($L$8,\">= 2.5\",$L$8,\"<= 4.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$8,\">= 4.5\",$C$8,\"<= 5.0\")+COUNTIFS($D$8,\">= 4.5\",$D$8,\"<= 5.0\")+COUNTIFS($E$8,\">= 4.5\",$E$8,\"<= 5.0\")+COUNTIFS($F$8,\">= 4.5\",$F$8,\"<= 5.0\")+COUNTIFS($G$8,\">= 4.5\",$G$8,\"<= 5.0\")+COUNTIFS($H$8,\">= 4.5\",$H$8,\"<= 5.0\")+COUNTIFS($I$8,\">= 4.5\",$I$8,\"<= 5.0\")+COUNTIFS($J$8,\">= 4.5\",$J$8,\"<= 5.0\")+COUNTIFS($K$8,\">= 4.5\",$K$8,\"<= 5.0\")+COUNTIFS($L$8,\">= 4.5\",$L8,\"<= 5.0\"))/10","v":0}]
["CONS","Phase 1",{"$f":"SUM(C9:L9)/10","v":0},null,null,null,"CONS","Phase 1",{"$f":"SUM(COUNTIFS($C$9,\">= 0.5\",$C$9,\"<= 2.4\")+COUNTIFS($D$9,\">= 0.5\",$D$9,\"<= 2.4\")+COUNTIFS($E$9,\">= 0.5\",$E$9,\"<=2.4\")+COUNTIFS($F$9,\">= 0.5\",$F$9,\"<=2.4\")+COUNTIFS($G$9,\">= 0.5\",$G$9,\"<=2.4\")+COUNTIFS($H$9,\">= 0.5\",$H$9,\"<=2.4\")+COUNTIFS($I$9,\">= 0.5\",$I$9,\"<=2.4\")+COUNTIFS($J$9,\">= 0.5\",$J$9,\"<=2.4\")+COUNTIFS($K$9,\">= 0.5\",$K$9,\"<=2.4\")+COUNTIFS($L$9,\">= 0.5\",$L$9,\"<=2.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$9,\">= 2.5\",$C$9,\"<= 4.4\")+COUNTIFS($D$9,\">= 2.5\",$D$9,\"<= 4.4\")+COUNTIFS($E$9,\">= 2.5\",$E$9,\"<= 4.4\")+COUNTIFS($F$9,\">= 2.5\",$F$9,\"<= 4.4\")+COUNTIFS($G$9,\">= 2.5\",$G$9,\"<= 4.4\")+COUNTIFS($H$9,\">= 2.5\",$H$9,\"<= 4.4\")+COUNTIFS($I$9,\">= 2.5\",$I$9,\"<= 4.4\")+COUNTIFS($J$9,\">= 2.5\",$J$9,\"<= 4.4\")+COUNTIFS($K$9,\">= 2.5\",$K$9,\"<= 4.4\")+COUNTIFS($L$9,\">= 2.5\",$L$9,\"<= 4.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$9,\">= 4.5\",$C$9,\"<= 5.0\")+COUNTIFS($D$9,\">= 4.5\",$D$9,\"<= 5.0\")+COUNTIFS($E$9,\">= 4.5\",$E$9,\"<= 5.0\")+COUNTIFS($F$9,\">= 4.5\",$F$9,\"<= 5.0\")+COUNTIFS($G$9,\">= 4.5\",$G$9,\"<= 5.0\")+COUNTIFS($H$9,\">= 4.5\",$H$9,\"<= 5.0\")+COUNTIFS($I$9,\">= 4.5\",$I$9,\"<= 5.0\")+COUNTIFS($J$9,\">= 4.5\",$J$9,\"<= 5.0\")+COUNTIFS($K$9,\">= 4.5\",$K$9,\"<= 5.0\")+COUNTIFS($L$9,\">= 4.5\",$L9,\"<= 5.0\"))/10","v":0}]
[null,"Phase 2",{"$f":"SUM(C10:L10)/10","v":0},{"$f":"(C19/C18)-1","v":{"$error":"#DIV/0!"}},null,null,null,"Phase 2",{"$f":"SUM(COUNTIFS($C$10,\">= 0.5\",$C$10,\"<= 2.4\")+COUNTIFS($D$10,\">= 0.5\",$D$10,\"<= 2.4\")+COUNTIFS($E$10,\">= 0.5\",$E$10,\"<=2.4\")+COUNTIFS($F$10,\">= 0.5\",$F$10,\"<=2.4\")+COUNTIFS($G$10,\">= 0.5\",$G$10,\"<=2.4\")+COUNTIFS($H$10,\">= 0.5\",$H$10,\"<=2.4\")+COUNTIFS($I$10,\">= 0.5\",$I$10,\"<=2.4\")+COUNTIFS($J$10,\">= 0.5\",$J$10,\"<=2.4\")+COUNTIFS($K$10,\">= 0.5\",$K$10,\"<=2.4\")+COUNTIFS($L$10,\">= 0.5\",$L$10,\"<=2.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$10,\">= 2.5\",$C$10,\"<= 4.4\")+COUNTIFS($D$10,\">= 2.5\",$D$10,\"<= 4.4\")+COUNTIFS($E$10,\">= 2.5\",$E$10,\"<= 4.4\")+COUNTIFS($F$10,\">= 2.5\",$F$10,\"<= 4.4\")+COUNTIFS($G$10,\">= 2.5\",$G$10,\"<= 4.4\")+COUNTIFS($H$10,\">= 2.5\",$H$10,\"<= 4.4\")+COUNTIFS($I$10,\">= 2.5\",$I$10,\"<= 4.4\")+COUNTIFS($J$10,\">= 2.5\",$J$10,\"<= 4.4\")+COUNTIFS($K$10,\">= 2.5\",$K$10,\"<= 4.4\")+COUNTIFS($L$10,\">= 2.5\",$L$10,\"<= 4.4\"))/10","v":0},{"$f":"SUM(COUNTIFS($C$10,\">= 4.5\",$C$10,\"<= 5.0\")+COUNTIFS($D$10,\">= 4.5\",$D$10,\"<= 5.0\")+COUNTIFS($E$10,\">= 4.5\",$E$10,\"<= 5.0\")+COUNTIFS($F$10,\">= 4.5\",$F$10,\"<= 5.0\")+COUNTIFS($G$10,\">= 4.5\",$G$10,\"<= 5.0\")+COUNTIFS($H$10,\">= 4.5\",$H$10,\"<= 5.0\")+COUNTIFS($I$10,\">= 4.5\",$I$10,\"<= 5.0\")+COUNTIFS($J$10,\">= 4.5\",$J$10,\"<= 5.0\")+COUNTIFS($K$10,\">= 4.5\",$K$10,\"<= 5.0\")+COUNTIFS($L$10,\">= 4.5\",$L10,\"<= 5.0\"))/10","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Low score (0.5-2.4)  Medium score (2.5-4.4)  High score (4.5-5.0)"]