{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Baseline Instructions","Performance Instructions","VBP Worksheet","Calculations"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"Baseline Instructions","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[13,0,14,0],[18,0,20,0],[21,0,23,0],[26,0,26,1],[11,0,12,0],[15,0,17,0],[9,0,10,0],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,4,1]]}
[]
["VBP FY2018 Worksheet"]
["Baseline Data Instructions"]
["Disclaimer: This worksheet can be used to estimate your hospital's performance in the FY 2018 Hospital Value-Based Purchasing program. However, actual performance will be calculated by CMS. In particular, the performance for MSPB cannot be calculated until the performance period is over and the benchmark and threshold are calculated by CMS. "]
[]
[null,"Baseline Data Instructions"]
["To Edit Report","Click on the \"VBP Worksheet\" tab. Enter in your hospital's data in the light green cells."]
["Name of your hospital","Enter the name of your hospital in this cell."]
["Data Pulled From FY 2018 Hospital Value-Based Purchasing - Baseline Measures Report","In order to enter your hospital's baseline data in the worksheet, you will need to access your hospital's Hospital Value-Based Purchasing - Baseline Measures Report through My QualityNet.\nDirections for accessing these reports can be found in the QualityNet Reports User Guide found on the Help tab on My QualityNet."]
["Clinical Care Measures","Your Baseline ≥ 25: Enter \"Y\" if the \"Number of Eligible Discharges\" from the Baseline Measures Report is greater than or equal to 25. Enter \"N\" if less than 25. Do this for each measure separately.\nThe baseline time period is Oct 2009 - June 2012.    "]
[null,"Survival Rate %: From the \"Baseline Period Rate\" column on the Baseline Measures Report, enter the rate for each measure as it appears.. For example, if your rate is 0.847472, enter 0.847472 or .847472. Do not change the number to a percentage for entry into the worksheet. If \"-\", enter \"N/A\" or leave blank.\nNote: The Mort Rate % will be calculated automatically."]
["Patient Experience of Care (HCAHPS)","Baseline # of Surveys ≥ 100: Enter \"Y\" if the \"HCAHPS Surveys Completed During the Baseline Period\" from the Baseline Measures Report is greater than or equal to 100. Enter \"N\" if less than 100.\nThe baseline time period is Jan 2014 - Dec 2014.    "]
[null,"%: From the \"Baseline Period Rate\" column on the Baseline Measures Report, enter the rate for each measure. Do not enter the actual % sign.\nDo not enter anything for Q8 and Q9.\nFor the Average of Q8 & Q9, enter the Cleanliness and Quietness of Hospital Environment rate."]
["Safety Measures: AHRQ Composite Measures","Your Baseline # of cases on any underlying indicator ≥ 3: Because there is no way to tell this from this report, keep this as \"Y\".\nThe baseline time period is Jul 1, 2010 - June 30 2012. "]
[null,"Ratio: From the \"Index Value\" column on the Baseline Measures Report, enter the rate for the measure. "]
["Safety Measures: Healthcare Associated Infections","Your Baseline: The baseline time period is Jan 2014 - Dec 2014. "]
[null,"# predicted infections: From the \"Number of Predicted Infections (Denominator)\" column on the Baseline Measures Report, enter the number of predicted infections for each measure. If \"N/A\", enter \"N/A\" or leave blank."]
[null,"SIR: From the \"Standardized Infection Ratio (SIR)\" column on the Baseline Measures Report, enter the ratio for each measure.  \nIf \"-\" or N/A, enter \"N/A\" or leave blank."]
["Safety Measures: Process Measures","Your Baseline: ≥ 10: Enter \"Y\" if the \"Number of Eligible Discharges\" from the Baseline Measures Report is greater than or equal to 10. Enter \"N\" if less than 10. Do this for each measure separately. \nThe baseline time period is Jan 2014 - Dec 2014. "]
[null,"# of cases: From the \"Denominator\" column on the Baseline Measures Report, enter the number of patients for each measure. If denominator is N/A, enter \"0\" or leave blank."]
[null,"%: From the \"Baseline Period Rate\" column on the Baseline Measures Report, enter the rate for each measure. Do not enter the leading 0 and move the decimal point 2 places to the right. For example, if your rate is 0.91154, enter 91.154. If \"-\", enter \"N/A\" or leave blank."]
["Efficiency Measure: Medicare Spending Per Beneficiary","Your Baseline: ≥ 25: Enter \"Y\" if the \"Number of Eligible Discharges\" from the Baseline Measures Report is greater than or equal to 25. Enter \"N\" if less than 25. The baseline time period is Jan 2014 - Dec 2014. "]
[null,"# of admissions: From the \"Number of Episodes\" column on the Baseline Measures Report, enter the number of admissions for the measure."]
[null,"Ratio: From the \"MSPB Measure\" column on the Baseline Measures Report, enter the ratio for the measure."]
["To Enter Performance Period Data:","See the \"Performance Instructions\" tab."]
[]
["This material was prepared by the Lake Superior Quality Innovation Network, under contract with the Centers for Medicare & Medicaid Services (CMS), an agency of the U.S. Department of Health and Human Services. The materials do not necessarily reflect CMS policy. 11SOW-MI/MN/WI-D1-15-39  071715"]

{"sheet":"Performance Instructions","index":1,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[[12,0,13,0],[17,0,19,0],[20,0,24,0],[32,0,32,1],[10,0,11,0],[14,0,16,0],[8,0,9,0],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,4,1]]}
[]
["VBP FY2018 Worksheet"]
["Performance Period Instructions"]
["Disclaimer: This worksheet can be used to estimate your hospital's performance in the FY 2018 Hospital Value-Based Purchasing program. However, actual performance will be calculated by CMS. In particular, the performance for MSPB cannot be calculated until the performance period is over and the benchmark and threshold are calculated by CMS. "]
[]
[null,"Performance Period Instructions"]
["To Edit Report","Click on the \"VBP Worksheet\" tab. Enter in  your hospital's data in the light green cells."]
["Data Pulled From Inpatient Hospital Compare Preview Report and Medicare Spending Per Beneficiary Report","In order to enter your hospital's performance period data in the worksheet, you will need to access your hospital's Preview Report and Medicare Spending Per Beneficiary Report through My QualityNet.\nDirections for accessing these reports can be found in the QualityNet Reports User Guide found on the Help tab on My QualityNet. "]
["Clinical Care Measures","Your Performance ≥ 25: Enter \"Y\" if the \"Your Hospital's Number of Eligible Medicare Admissions\" from the Preview Report is greater than or equal to 25. Enter \"N\" if less than 25. Do this for each measure separately.\nThe performance time period is Oct 2013 - June 2016. This worksheet can be used to monitor progress prior to the performance period. If you use data prior to the performance period, then modify this date by entering in the date found in the header of the Preview Report.   "]
[null,"Mort Rate %: From the \"Your Hospital's Risk-Standardized Mortality Rate\" columns on the Preview Report, enter the percentage rate for each measure, excluding the % sign. The rate is the number to the left of the parenthesis, not inside the parenthesis. If N/A, enter \"N/A\" or leave blank.\nNote: The Survival Rate % will be calculated automatically."]
["Patient Experience of Care (HCAHPS)","Performance # of Surveys ≥ 100: Enter \"Y\" if the \"Number of Completed Surveys\" from the Preview Report is greater than or equal to 100. Enter \"N\" if less than 100.\nThe performance time period is Jan 2016 - Dec 2016. This worksheet can be used to monitor progress prior to the performance period. If you use data prior to the performance period, then modify this date by entering in the date found in the header of the Preview Report.   "]
[null,"%: From the \"Your Hospital's Adjusted Score\" columns on the Preview Report, enter the % for each measure.\nComposites 1 through 5, Q8, and Q9, enter the % Always.\nComposite 6, enter the % Yes.\nQ21, enter the % 9 and 10 rating.\nNote: The Average of Q8 & Q9 will be calculated automatically. "]
["Safety Measures: AHRQ Composite Measures","Your Performance # of cases on any underlying indicator ≥ 3: Enter \"Y\" if the \"Your Hospital's Number of Eligible Medicare Discharges\" for ANY of the underlying indicators from the Preview Report is less than or equal to 3. Enter \"N\" if ALL are less than 3. Note: All hospitals will have N/A for \"Your Hospital's Number of Eligible Medicare Discharges\" for PSI-90 so you must look at the underlying indicators, which are: PSI-03, PSI-06, PSI-07, PSI-08, PSI-12, PSI-13, PSI-14, and PSI-15.\nThe performance time period is Jul 1, 2014 - June 30, 2016. This worksheet can be used to monitor progress prior to the performance period. If you use data prior to the performance period, then modify this date by entering in the date found in the header of the Preview Report."]
[null,"Ratio: From the \"Your Hospital's PSI Rate\" column on the Preview Report, enter the rate for the measure. The rate is the number to the left of the parenthesis, not inside the parenthesis. "]
["Safety Measures: Healthcare Associated Infections","Your Performance: The performance time period is Jan 2016 - Dec 2016. This worksheet can be used to monitor progress prior to the performance period. If you use data prior to the performance period, then modify this date by entering in the date found in the header of the Preview Report."]
[null,"# predicted infections: From the \"Your Hospital's Predicted Number of Infections\" column on the Preview Report, enter the number of predicted infections for each measure. If N/A, enter \"N/A\" or leave blank."]
[null,"SIR: From the \"Ratio of Reported to Predicted Infections (SIR)\" column on the Preview Report, enter the ratio for each measure. The ratio is the number to the left of the parenthesis, not inside the parenthesis. \nNote: SIR stands for Standardized Infection Ratio. If N/A, enter \"N/A\" or leave blank."]
["Safety Measures: Process Measures","Your Performance: ≥ 10: Enter \"Y\" if the \"Number of Eligible Discharges\" from the Baseline Measures Report is greater than or equal to 10. Enter \"N\" if less than 10. Do this for each measure separately. \nThe performance time period is Jan 2016 - Dec 2016. This worksheet can be used to monitor progress prior to the performance period. If you use data prior to the performance period, then modify this date by entering in the date found in the header of the Preview Report."]
[null,"# of cases: From the \"Your Hospital Performance Aggregate Rate for All Four Quarters\" column on the Preview Report, enter the number of patients for each measure. If rate is N/A (number of patients is missing), enter \"0\" or leave blank."]
[null,"%: From the \"Your Hospital Performance Aggregate Rate for All Four Quarters\" column on the Preview Report, enter the rate for each measure, excluding the % sign. If N/A, enter \"N/A\" or leave blank. Note: Since the preview reports do not give numerators and do not have any decimal points for the rates, the actual dimension points are only estimates."]
["Efficiency Measure: Medicare Spending Per Beneficiary","Your Performance: ≥ 25: Enter \"Y\" if the \"Number of Eligible Discharges\" from the Baseline Measures Report is greater than or equal to 25. Enter \"N\" if less than 25. The performance time period is Jan 2016 - Dec 2016. This worksheet can be used to monitor progress prior to the performance period. If you use data prior to the performance period, then modify this date by entering in the date found in section 3: Results, in your Medicare Spending Per Beneficiary Report."]
[null,"# of admissions: From the \"Number of Eligible Admissions at Your Hospital\" column in Table 2 in section 3 on the Medicare Spending Per Beneficiary Report, enter the number of admissions for the measure."]
[null,"Ratio: From \"Your Hospital's MSPB Measure\" in Table 1 in section 3 on the Medicare Spending Per Beneficiary Report, enter the ratio for the measure."]
[null,"Benchmark: Currently, this number is a proxy measure based on page 50695 of the IPPS final rule (http://www.gpo.gov/fdsys/pkg/FR-2013-08-19/pdf/2013-18956.pdf). The actual benchmark for MSPB cannot be calculated by CMS until the performance period is over. The benchmark is the mean of the lowest decile of MSPB ratios across all hospitals during the performance period. This cell can be edited once the actual benchmark is available. "]
[null,"Threshold: Currently, this number is a proxy measure based on page 50695 of the IPPS final rule (http://www.gpo.gov/fdsys/pkg/FR-2013-08-19/pdf/2013-18956.pdf). The actual threshold for MSPB cannot be calculated by CMS until the performance period is over. The threshold is the median MSPB ratio across all hospitals during the performance period. This cell can be edited once the actual benchmark is available."]
["Variations in Computing Total Performance Score","Note: In order for a Total Performance Score to be computed, a hospital must have at least 3 domain scores. If a hospital has 3 domain scores then the domain weighting is redistributed compared to the weighting when all 4 domain scores are present. "]
["To Print Report:","To print the report in its entirety click on the \"Print Report\" button at the top right corner of this page."]
[null,"Definitions"]
["Points","Each hospital may earn two scores on each measure—one for achievement and one for improvement. The final score awarded to a hospital for each measure or dimension is the higher of these two scores."]
["Domain Scores","VBP measures roll up to a domain. There are four domains, the Clinical Process of Care domain, the Patient Experience of Care domain, the Outcome domain, and the Efficiency domain."]
["Total Performance Score","A hospital’s performance is assessed on the measures that comprise the domains. The domains are weighted and rolled up to the Total Performance Score. The Total Performance Score is computed by multiplying the Clinical Care domain score by 25% (domain weighting), the Patient Experience of Care domain score by 25% (domain weighting), the Safety domain score by 25% (domain weighting), and the Efficiency domain score by 25% (domain weighting), then adding those totals. The Total Performance Score is then translated into an incentive payment that makes a portion of the base DRG payment contingent on performance."]
[]
["This material was prepared by the Lake Superior Quality Innovation Network, under contract with the Centers for Medicare & Medicaid Services (CMS), an agency of the U.S. Department of Health and Human Services. The materials do not necessarily reflect CMS policy. 11SOW-MI/MN/WI-D1-15-39  071715"]

{"sheet":"VBP Worksheet","index":2,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":false,"merged":[[36,14,38,14],[36,15,38,15],[36,16,38,16],[40,14,41,14],[40,15,41,15],[40,16,41,16],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,14,47,16],[45,8,45,9],[45,14,45,16],[53,2,53,5],[53,6,53,9],[54,2,54,3],[54,4,54,5],[59,0,61,1],[57,0,57,1],[59,16,61,16],[58,13,58,16],[59,10,60,13],[59,14,61,14],[59,15,61,15],[61,10,61,11],[61,12,61,13],[54,6,54,7],[54,8,54,9],[54,14,54,16],[61,6,61,7],[61,8,61,9],[58,0,58,11],[57,6,57,16],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[37,12,37,13],[37,2,38,3],[37,6,38,7],[37,0,38,1],[35,2,35,5],[35,6,35,9],[41,8,41,9],[37,4,37,5],[37,8,37,9],[38,8,38,9],[44,4,44,5],[44,6,44,7],[44,8,44,9],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[4,0,6,1],[28,2,28,4],[9,0,9,1],[7,0,7,1],[26,2,26,4],[26,5,26,6],[20,2,20,4],[20,5,20,6],[21,2,21,4],[21,5,21,6],[22,2,22,4],[22,5,22,6],[17,5,17,6],[18,3,18,4],[28,5,28,6],[9,2,9,3],[9,4,9,5],[9,6,9,7],[17,2,17,4],[17,0,17,1],[11,14,11,16],[49,0,49,1],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,14,49,16],[43,0,43,1],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[39,2,39,3],[39,4,39,5],[39,6,39,7],[39,8,39,9],[43,14,43,16],[44,2,44,3],[34,12,34,16],[29,2,29,4],[29,5,29,6],[36,0,36,1],[36,6,36,9],[38,4,38,5],[4,10,5,13],[6,10,6,11],[62,2,62,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[6,2,6,3],[6,4,6,5],[6,6,6,7],[6,8,6,9],[59,2,59,5],[59,6,59,9],[60,2,60,5],[60,6,60,9],[61,2,61,3],[61,4,61,5],[55,6,55,7],[55,8,55,9],[51,4,51,5],[51,6,51,7],[7,6,7,7],[7,8,7,9],[50,2,50,3],[36,2,36,5],[68,0,68,16],[65,0,65,1],[65,6,65,16],[66,0,66,11],[66,13,66,16],[67,0,67,7],[63,2,63,3],[63,4,63,5],[63,6,63,7],[63,8,63,9],[64,0,64,1],[64,6,64,16],[67,8,67,16],[9,8,9,9],[10,2,10,3],[10,4,10,5],[10,6,10,7],[41,2,41,3],[34,0,34,11],[40,0,40,1],[32,0,32,2],[18,7,19,9],[30,2,30,4],[30,5,30,6],[31,0,31,2],[33,0,33,2],[35,0,35,1],[37,10,37,11],[14,0,14,1],[14,6,14,16],[15,0,15,11],[15,13,15,16],[16,2,16,6],[16,7,17,13],[16,14,19,14],[16,15,19,15],[16,16,19,16],[52,2,52,5],[52,6,52,9],[56,0,56,1],[40,2,40,5],[40,6,40,9],[53,0,53,1],[56,6,56,16],[50,4,50,5],[50,6,50,7],[50,8,50,9],[51,2,51,3],[55,2,55,3],[55,4,55,5],[45,0,45,1],[45,2,45,3],[45,4,45,5],[45,6,45,7],[51,8,51,9],[42,2,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[41,4,41,5],[41,6,41,7],[6,12,6,13],[5,2,5,5],[5,6,5,9],[26,14,26,16],[27,2,27,4],[27,5,27,6],[23,2,23,4],[23,5,23,6],[24,2,24,4],[24,5,24,6],[25,2,25,4],[25,5,25,6],[25,14,25,16],[18,10,19,11],[18,12,19,13],[19,2,19,4],[19,5,19,6],[4,14,7,14],[4,15,7,15],[4,16,7,16],[9,14,9,16],[8,8,8,9],[7,2,7,3],[7,4,7,5],[3,14,3,16],[0,0,0,9],[1,1,2,5],[3,0,3,1],[3,2,3,5],[3,6,3,9],[3,11,3,13],[13,0,13,1],[13,6,13,16],[11,2,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,0,11,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[10,8,10,9],[8,2,8,3],[8,4,8,5],[8,6,8,7],[4,2,4,5],[4,6,4,9]]}
[]
[null,"VBP FY2018 Worksheet "]
[]
["Name of your hospital",null,"Input",null,null,null,"Input",null,null,null,null,null,null,null,"Output"]
["Clinical Care",null,"Your Baseline",null,null,null,"Your Performance",null,null,null,"Outcome Measures Performance Standard",null,null,null,"Achievement","Improvement","Points"]
[null,null,"Oct 2009 - Jun 2012",null,null,null,"Oct 2013 -  Jun 2016"]
[null,null,"Mort Rate     %",null,"Survival Rate %",null,"Mort Rate     %",null,"Survival Rate %",null,"Benchmark",null,"Threshold"]
["30-day Mortality, AMI",null,"≥ 25",null,"Y",null,"≥ 25",null,"Y"]
[null,"MORT-30-AMI",{"$f":"IF(ISNUMBER(E9),1-E9,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISNUMBER(G9),100-G9,\"\")","v":""},null,null,87.305300000000003,null,85.0916,{"$f":"IF(OR(UPPER(I8)=\"N\",I8=\"\",I9=\"\"),\"\",ROUND(Ascore((100*E9),I9,L9,N9),0))","v":""},{"$f":"IF(OR(UPPER(E8)=\"N\", UPPER(I8)=\"N\",I8=\"\",E8=\"\",E9=\"\",I9=\"\"),\"\",MIN(9,ROUND(imt((100*E9),I9,L9,N9),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O9),ISNUMBER(P9)),MAX(O9:P9),\"\")","v":""}]
["30-day Mortality, Heart Failure",null,"≥ 25",null,"Y",null,"≥ 25",null,"Y"]
[null,"MORT-30-HF",{"$f":"IF(ISNUMBER(E11),1-E11,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISNUMBER(G11),100-G11,\"\")","v":""},null,null,90.765600000000006,null,88.342100000000002,{"$f":"IF(OR(UPPER(I10)=\"N\",I10=\"\",I11=\"\"),\"\",ROUND(Ascore((100*E11),I11,L11,N11),0))","v":""},{"$f":"IF(OR(UPPER(E10)=\"N\", UPPER(I10)=\"N\",I10=\"\",E10=\"\",E11=\"\",I11=\"\"),\"\",MIN(9,ROUND(imt((100*E11),I11,L11,N11),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O11),ISNUMBER(P11)),MAX(O11:P11),\"\")","v":""}]
["30-day Mortality, Pneumonia",null,"≥ 25",null,"Y",null,"≥ 25",null,"Y"]
[null,"MORT-30-PN",{"$f":"IF(ISNUMBER(E13),1-E13,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISNUMBER(G13),100-G13,\"\")","v":""},null,null,90.79,null,88.286000000000001,{"$f":"IF(OR(UPPER(I12)=\"N\",I12=\"\",I13=\"\"),\"\",ROUND(Ascore((100*E13),I13,L13,N13),0))","v":""},{"$f":"IF(OR(UPPER(E12)=\"N\", UPPER(I12)=\"N\",I12=\"\",E12=\"\",E13=\"\",I13=\"\"),\"\",MIN(9,ROUND(imt((100*E13),I13,L13,N13),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O13),ISNUMBER(P13)),MAX(O13:P13),\"\")","v":""}]
["Your VBP Clinical Care Earned Points",null,null,null,null,null,{"$f":"IF(COUNT(Q9:Q9,Q11:Q11,Q13:Q13)>=2, SUM(Q9:Q9,Q11:Q11,Q13:Q13),\"     Need at least 2 clinical care measures with # of cases ≥ 25\")","v":"     Need at least 2 clinical care measures with # of cases ≥ 25"}]
["Your VBP Clinical Care Potential Points",null,null,null,null,null,{"$f":"IF(COUNT(Q9:Q9,Q11:Q11,Q13:Q13)>=2,COUNT(Q9:Q9,Q11:Q11,Q13:Q13)*10,\"     Need at least 2 clinical care measures with # of cases ≥ 25\")","v":"     Need at least 2 clinical care measures with # of cases ≥ 25"}]
["Your VBP Clinical Care Domain Score =(100*Your Earned Points/Your Potential Earned Points)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G15<>\"     Need at least 2 clinical care measures with # of cases ≥ 25\",\"(\"&G14&\" / \"&G15&\")*100 = \"&TEXT(((G14/(G15))*100),\"00.00\")&\"\",\"Need Clinical Care data\")","v":"Need Clinical Care data"}]
[null,null,"Your HCAHPS Survey",null,null,null,null,"HCAHPS Performance Standard",null,null,null,null,null,null,"Achievement","Improvement","Points"]
["Patient Experience of Care",null,"Baseline             # of  Surveys",null,null,"Performance      # of  Surveys"]
[null,null,"≥100","Y",null,"≥100","Y","Floor            (Minimum)",null,null,"Benchmark",null,"Threshold"]
["HCAHPS Survey Dimensions",null,"Jan 2014 -       Dec 2014",null,null,"Jan 2016 -       Dec 2016"]
[null,"Composite 1 (Q1 to Q3): Communication with Nurses (% Always)",null,null,null,null,null,{"$f":" ((F21 - J21)/(N21 - J21))","v":-2.3772043010752695},null,55.27,null,86.88,null,78.52,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F21=\"\",ISTEXT(F21)),\"\",ROUND(Ahcahps(C21,F21,L21,N21),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C21=\"\",F21=\"\",ISTEXT(C21),ISTEXT(F21)),\"\",MIN(9,ROUND(Ihcahps(C21,F21,L21,N21),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O21),ISNUMBER(P21)),MAX(O21:P21),\"\")","v":""}]
[null,"Composite 2 (Q5 to Q7): Communication with Doctors (% Always)",null,null,null,null,null,{"$f":" ((F22 - J22)/(N22 - J22))","v":-2.4898047722342738},null,57.39,null,88.51,null,80.44,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F22=\"\",ISTEXT(F22)),\"\",ROUND(Ahcahps(C22,F22,L22,N22),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C22=\"\",F22=\"\",ISTEXT(C22),ISTEXT(F22)),\"\",MIN(9,ROUND(Ihcahps(C22,F22,L22,N22),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O22),ISNUMBER(P22)),MAX(O22:P22),\"\")","v":""}]
[null,"Composite 3 (Q4 & Q11): Responsiveness of Hospital Staff (% Always)",null,null,null,null,null,-1.4392803598200898,null,38.4,null,80.349999999999994,null,65.08,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F23=\"\",ISTEXT(F23)),\"\",ROUND(Ahcahps(C23,F23,L23,N23),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C23=\"\",F23=\"\",ISTEXT(C23),ISTEXT(F23)),\"\",MIN(9,ROUND(Ihcahps(C23,F23,L23,N23),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O23),ISNUMBER(P23)),MAX(O23:P23),\"\")","v":""}]
[null,"Composite 4 (Q13 & Q14): Pain management (% Always)",null,null,null,null,null,-2.8978345363686833,null,52.19,null,78.459999999999994,null,70.2,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F24=\"\",ISTEXT(F24)),\"\",ROUND(Ahcahps(C24,F24,L24,N24),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C24=\"\",F24=\"\",ISTEXT(C24),ISTEXT(F24)),\"\",MIN(9,ROUND(Ihcahps(C24,F24,L24,N24),0)))","v":""},""]
[null,"Composite 5 (Q16 & Q17): Communication about Medicines (% Always)",null,null,null,null,null,-2.178034102306921,null,43.43,null,73.66,null,63.37,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F25=\"\",ISTEXT(F25)),\"\",ROUND(Ahcahps(C25,F25,L25,N25),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C25=\"\",F25=\"\",ISTEXT(C25),ISTEXT(F25)),\"\",MIN(9,ROUND(Ihcahps(C25,F25,L25,N25),0)))","v":""},""]
[null,"Q8: Cleanliness of Hospital Environment (% Always)","N/A",null,null,null,null,null,null,"N/A",null,"N/A",null,"N/A"]
[null,"Q9: Quietness of Hospital Environment (% Always)","N/A",null,null,null,null,null,null,"N/A",null,"N/A",null,"N/A"]
[null,"Average of Q8 & Q9: Cleanliness and Quietness (% Always)",null,null,null,{"$f":"IF(AND(F26>0,F27>0),AVERAGE(F26:H27),\"\")","v":""},null,{"$f":" IF(ISNUMBER(F28),((F28 - J28)/(N28 - J28)),\"\")","v":""},null,40.049999999999997,null,79,null,65.599999999999994,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F28=\"\",ISTEXT(F28)),\"\",ROUND(Ahcahps(C28,F28,L28,N28),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C28=\"\",F28=\"\",ISTEXT(C28),ISTEXT(F28)),\"\",MIN(9,ROUND(Ihcahps(C28,F28,L28,N28),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O28),ISNUMBER(P28)),MAX(O28:P28),\"\")","v":""}]
[null,"Composite 6 (Q19 & Q20): Discharge information (% Yes)",null,null,null,null,null,-2.5564681724846001,null,62.25,null,91.63,null,86.6,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F29=\"\",ISTEXT(F29)),\"\",ROUND(Ahcahps(C29,F29,L29,N29),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C29=\"\",F29=\"\",ISTEXT(C29),ISTEXT(F29)),\"\",MIN(9,ROUND(Ihcahps(C29,F29,L29,N29),0)))","v":""},""]
[null,"CTM-3: 3-Item Care Transition Measure (% Strongly Agree)",null,null,null,null,null,{"$f":" ((F30 - J30)/(N30 - J30))","v":-0.96074695121951215},null,25.21,null,62.44,null,51.45,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F30=\"\",ISTEXT(F30)),\"\",ROUND(Ahcahps(C30,F30,L30,N30),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C30=\"\",F30=\"\",ISTEXT(C30),ISTEXT(F30)),\"\",MIN(9,ROUND(Ihcahps(C30,F30,L30,N30),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O30),ISNUMBER(P30)),MAX(O30:P30),\"\")","v":""}]
[null,"Q21: Overall Rating of Hospital (% 9 and 10 rating)",null,null,null,null,null,-1.1569410319410318,null,37.67,null,84.58,null,70.23,{"$f":"IF(OR(UPPER($G$19)=\"N\",$G$19=\"\",F31=\"\",ISTEXT(F31)),\"\",ROUND(Ahcahps(C31,F31,L31,N31),0))","v":""},{"$f":"IF(OR(UPPER($D$19)=\"N\", UPPER($G$19)=\"N\",$G$19=\"\",$D$19=\"\",C31=\"\",F31=\"\",ISTEXT(C31),ISTEXT(F31)),\"\",MIN(9,ROUND(Ihcahps(C31,F31,L31,N31),0)))","v":""},""]
["Your VBP Patient Experience Unadjusted Base Earned Points (max 90 points)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(Q21),ISNUMBER(Q22),ISNUMBER(Q23),ISNUMBER(Q24),ISNUMBER(Q25),ISNUMBER(Q28),ISNUMBER(Q29),ISNUMBER(Q30),ISNUMBER(Q31)),SUM(Q21:Q25,Q28:Q31),\"\")","v":""}]
["Your VBP Patient Experience Adjusted Base Earned Points (max 80 points)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(Q21),ISNUMBER(Q22),ISNUMBER(Q23),ISNUMBER(Q24),ISNUMBER(Q25),ISNUMBER(Q28),ISNUMBER(Q29),ISNUMBER(Q30),ISNUMBER(Q31)),ROUND(8*Q32/9,0),\"\")","v":""}]
["Your VBP Patient Experience Consistency Points (max 20 points)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H21<0,H22<0,H23<0,H24<0,H25<0,H28<0,H29<0,H30<0,H31<0),\"\",IF(AND(Q32<>\"\",G19=\"Y\",ISNUMBER(H21),ISNUMBER(H22),ISNUMBER(H23),ISNUMBER(H24),ISNUMBER(H25),ISNUMBER(H28),ISNUMBER(H29),ISNUMBER(H30),ISNUMBER(H31)),MIN(20,ROUND((20*MIN(H21:H25,H28:H31))-0.5,0)),\"\"))","v":""}]
["Your VBP Patient Experience Domain Score = (Your Patient Experience Adjusted Earned Points + Your Patient Experience Consistency Score)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(Q33),ISNUMBER(Q34)),\"(\"&TEXT(Q33,\"0\")&\" + \"&TEXT(Q34,\"0\")&\") = \"&TEXT((Q33+Q34),\"00.00\")&\"\",\"Need HCAHPS data\")","v":"Need HCAHPS data"}]
["Safety",null,"Your Baseline",null,null,null,"Your Performance"]
["AHRQ Composite Measures",null,"Jul 1 2010 - Jun 30 2012",null,null,null,"Jul 1 2014 - Sep 30 2015",null,null,null,null,null,null,"PSI Performance:\n","Achievement","Improvement","Points"]
[null,null,"# of cases on any underlying indicator \n≥ 3",null,"Ratio",null,"# of cases on any underlying indicator \n≥ 3",null,"Ratio",null,"Benchmark",null,"Threshold"]
[null,null,null,null,"Y",null,null,null,"Y"]
[null,"PSI-90: AHRQ PSI composite",null,null,null,null,null,null,null,null,null,0.70949799999999996,null,0.96454200000000001,{"$f":"IF(OR(UPPER($I$39)=\"N\",$I$39=\"\",I40=\"\",ISTEXT(I40)),\"\",ROUND(RevAscore(E40,I40,L40,N40),0))","v":""},{"$f":"IF(OR(UPPER($E$39)=\"N\", UPPER($I$39)=\"N\",$I$39=\"\",$E$39=\"\",E40=\"\",I40=\"\",ISTEXT(E40),ISTEXT(I40)),\"\",MIN(9,ROUND(revimt(E40,I40,L40,N40),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O40),ISNUMBER(P40)),MAX(O40:P40),\"\")","v":""}]
["Healthcare Associated Infections",null,"Jan 2014 - Dec 2014",null,null,null,"Jan 2016 - Dec 2016",null,null,null,null,null,null,"CLABSI Performance:\n","Achievement","Improvement","Points"]
[null,null,"# predicted infections",null,"SIR",null,"# predicted infections",null,"SIR"]
[null,"CAUTI Catheter-Associated Urinary Tract Infection",null,null,null,null,null,null,null,null,null,0,null,0.90600000000000003,{"$f":"IF(OR(G43=\"\",ISTEXT(G43),G43<1),\"\",ROUND(RevAscore(E43,I43,L43,N43),0))","v":""},{"$f":"IF(OR(C43=\"\",G43=\"\",C43<1,G43<1,ISTEXT(C43),ISTEXT(G43)),\"\",MIN(9,ROUND(revimt(E43,I43,L43,N43),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O43),ISNUMBER(P43)),MAX(O43:P43),\"\")","v":""}]
[null,null,"# predicted infections",null,"SIR",null,"# predicted infections",null,"SIR",null,null,null,null,"CAUTI Performance:\n"]
[null,"CLABSI Central Line Associated Bloodstream Infection",null,null,null,null,null,null,null,null,null,0,null,0.36899999999999999,{"$f":"IF(OR(G45=\"\",ISTEXT(G45),G45<1),\"\",ROUND(RevAscore(E45,I45,L45,N45),0))","v":""},{"$f":"IF(OR(C45=\"\",G45=\"\",C45<1,G45<1,ISTEXT(C45),ISTEXT(G45)),\"\",MIN(9,ROUND(revimt(E45,I45,L45,N45),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O45),ISNUMBER(P45)),MAX(O45:P45),\"\")","v":""}]
[null,null,"# predicted infections",null,"SIR",null,"# predicted infections",null,"SIR",null,null,null,null,"PN Performance:\n"]
[null,"CDI C. difficile Infection",null,null,null,null,null,null,null,null,null,4.0000000000000001E-3,null,0.80500000000000005,{"$f":"IF(OR(G47=\"\",G47<1,ISTEXT(G47)),\"\",ROUND(RevAscore(E47,I47,L47,N47),0))","v":""},{"$f":"IF(OR(C47=\"\",G47=\"\",C47<1,G47<1,ISTEXT(C47),ISTEXT(G47)),\"\",MIN(9,ROUND(revimt(E47,I47,L47,N47),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O47),ISNUMBER(P47)),MAX(O47:P47),\"\")","v":""}]
[null,null,"# predicted infections",null,"SIR",null,"# predicted infections",null,"SIR",null,null,null,null,"CAUTI Performance:\n"]
[null,"MRSA Methicillin-Resistant Staphylococcus aureus bacteremia",null,null,null,null,null,null,null,null,null,0,null,0.76700000000000002,{"$f":"IF(OR(G49=\"\",G49<1,ISTEXT(G49)),\"\",ROUND(RevAscore(E49,I49,L49,N49),0))","v":""},{"$f":"IF(OR(C49=\"\",G49=\"\",C49<1,G49<1,ISTEXT(C49),ISTEXT(G49)),\"\",MIN(9,ROUND(revimt(E49,I49,L49,N49),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O49),ISNUMBER(P49)),MAX(O49:P49),\"\")","v":""}]
[null,null,"# predicted infections",null,"SIR",null,"# predicted infections",null,"SIR",null,null,null,null,"PN Performance:\n"]
[null,"SSI-Abdominal Hysterectomy",null,null,null,null,null,null,null,null,null,0,null,0.71,{"$f":"IF(OR(G51=\"\",G51<1,ISTEXT(G51)),\"\",ROUND(RevAscore(E51,I51,L51,N51),0))","v":""},{"$f":"IF(OR(C51=\"\",G51=\"\",C51<1,G51<1,ISTEXT(C51),ISTEXT(G51)),\"\",MIN(9,ROUND(revimt(E51,I51,L51,N51),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O51),ISNUMBER(P51)),MAX(O51:P51),\"\")","v":""}]
[null,"SSI-Colon Surgery",null,null,null,null,null,null,null,null,null,0,null,0.82399999999999995,{"$f":"IF(OR(G52=\"\",G52<1,ISTEXT(G52)),\"\",ROUND(RevAscore(E52,I52,L52,N52),0))","v":""},{"$f":"IF(OR(C52=\"\",G52=\"\",C52<1,G52<1,ISTEXT(C52),ISTEXT(G52)),\"\",MIN(9,ROUND(revimt(E52,I52,L52,N52),0)))","v":""},"",null,{"$f":"IF(OR(G52=\"\",G52<1),0,ROUND(9*((I52-N52)/(L52-N52))+0.5,0))","v":0},{"$f":"IF(OR(C52=\"\",G52=\"\",C52<1,G52<1),0,MIN(9,ROUND(10*((I52-E52)/(L52-E52))-0.5,0)))","v":0}]
[null,"Composite SSI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(U53,\"\")","v":""},null,{"$f":"IF(AND(G52<1,G51<1),\"\",IF(G52<1,ROUND((Q51*G51)/(G51),0),ROUND((Q52*G52)/(G52),0)))","v":""},{"$f":"IF(AND(G52<1,G51<1),\"\",IF(G52<1,ROUND((P51*G51)/(G51),0),ROUND((P52*G52)/(G52),0)))","v":""},{"$f":"IF(AND(G51>=1,G52>=1),ROUND(((Q51*G51)+(Q52*G52))/(G51+G52),0),S53)","v":""},{"$f":"IF(AND(G51>=1,G52>=1),ROUND(((P51*G51)+(P52*G52))/(G51+G52),0),T53)","v":""},{"$f":"IF(OR(ISNUMBER(O53),ISNUMBER(P53)),MAX(O53:P53),\"\")","v":""}]
["Process Measures",null,"Jan 2014 - Dec 2014",null,null,null,"Jan 2016 - Dec 2016",null,null,null,null,null,null,"PSI Performance:\n","Achievement","Improvement","Points"]
[null,null,"# Cases \n≥ 10",null,"Y",null,"# Cases \n≥ 10",null,"Y",null,null,null,null,"PC-01 Performance:\n"]
[null,"PC-01: Elective Delivery Prior to 39 Completed Weeks Gestation",null,null,null,null,null,null,null,null,null,0,null,2.0407999999999999E-2,{"$f":"IF(OR(UPPER(I55)=\"N\",I55=\"\",I56=\"\",ISTEXT(I56)),\"\",ROUND(RevAscore(E56,I56,L56,N56),0))","v":""},{"$f":"IF(OR(UPPER(E55)=\"N\", UPPER(I55)=\"N\",I55=\"\",E55=\"\",E56=\"\",I56=\"\",ISTEXT(E56),ISTEXT(I56)),\"\",MIN(9,ROUND(revimt(E56,I56,L56,N56),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O56),ISNUMBER(P56)),MAX(O56:P56),\"\")","v":""}]
["Your VBP Safety Earned Points",null,null,null,null,null,{"$f":"IF(COUNT(Q40,Q43,Q45,Q47,Q49,Q53,Q56)>=3,SUM(Q40,Q43,Q45,Q47,Q49,Q53,Q56),\"     Need at least 3 safety measures\")","v":"     Need at least 3 safety measures"}]
["Your VBP Safety Potential Points",null,null,null,null,null,{"$f":"IF(COUNT(Q40,Q43,Q45,Q47,Q49,Q53,Q56)>=3,COUNT(Q40,Q43,Q45,Q47,Q49,Q53,Q56)*10,\"     Need at least 3 safety measures\")","v":"     Need at least 3 safety measures"}]
["Your VBP Safety Domain Score =(100*Your Earned Points/Your Potential Earned Points)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G58<>\"     Need at least 3 safety measures\",\"(\"&SUM(Q40,Q43,Q45,Q47,Q49,Q53,Q56)&\" / \"&COUNT(Q40,Q43,Q45,Q47,Q49,Q53,Q56)*10&\")*100 = \"&TEXT(((SUM(Q40,Q43,Q45,Q47,Q49,Q53,Q56)/(COUNT(Q40,Q43,Q45,Q47,Q49,Q53,Q56)*10))*100),\"00.00\")&\"\",\"Need Safety data\")","v":"Need Safety data"}]
["Efficiency and Cost Reduction",null,"Your Baseline",null,null,null,"Your Performance",null,null,null,"Efficiency Measures Performance Standard",null,null,null,"Achievement","Improvement","Points"]
[null,null,"Jan 2014 -  Dec 2014",null,null,null,"Jan 2016 -  Dec 2016"]
[null,null,"# of episodes",null,"Ratio",null,"# of episodes",null,"Ratio",null,"Benchmark",null,"Threshold"]
[null,null,"≥ 25",null,"Y",null,"≥ 25",null,"Y"]
[null,"MSPB-1: Medicare spending per beneficiary",null,null,null,null,null,null,null,null,null,0.84,null,0.99,{"$f":"IF(OR(UPPER($I63)=\"N\",$I63=\"\",I64=\"\",ISTEXT(I64)),\"\",ROUND(RevAscore(E64,I64,L64,N64),0))","v":""},{"$f":"IF(OR(UPPER($E63)=\"N\", UPPER($I63)=\"N\",$I63=\"\",$E63=\"\",E64=\"\",I64=\"\",ISTEXT(I64),ISTEXT(E64)),\"\",MIN(9,ROUND(revimt(E64,I64,L64,N64),0)))","v":""},{"$f":"IF(OR(ISNUMBER(O64),ISNUMBER(P64)),MAX(O64:P64),\"\")","v":""}]
["Your VBP Efficiency Earned Points",null,null,null,null,null,{"$f":"IF(COUNT(Q64)>=1,SUM(Q64),\"     Need Efficiency data\")","v":"     Need Efficiency data"}]
["Your VBP Efficiency Potential Points",null,null,null,null,null,{"$f":"IF(COUNT(Q64)>=1,COUNT(Q64)*10,\"     Need Efficiency data\")","v":"     Need Efficiency data"}]
["Your VBP Efficiency Domain Score =(100*Your Earned Points/Your Potential Earned Points)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G66<>\"     Need Efficiency data\",\"(\"&SUM(Q64)&\" / \"&COUNT(Q64)*10&\")*100 = \"&TEXT(((SUM(Q64)/(COUNT(Q64)*10))*100),\"00.00\")&\"\",\"Need Efficiency data\")","v":"Need Efficiency data"}]
["Your VBP Total Performance Score                                                                              =(Clinical Care Domain)(25%)+(Patient Experience Domain)(25%)+(Safety Domain)(25%)+(Efficiency Domain)(25%)",null,null,null,null,null,null,null,{"$f":"IF(AND(Calculations!C3=\"Y\",Calculations!C4=\"Y\",Calculations!C5=\"Y\",Calculations!C6=\"Y\"),Calculations!F11,\n\nIF(AND(Calculations!C4=\"Y\",Calculations!C5=\"Y\",Calculations!C6=\"Y\"),Calculations!F14,\n\nIF(AND(Calculations!C3=\"Y\",Calculations!C5=\"Y\",Calculations!C6=\"Y\"),Calculations!F15,\n\nIF(AND(Calculations!C3=\"Y\",Calculations!C4=\"Y\",Calculations!C6=\"Y\"),Calculations!F16,\n\nIF(AND(Calculations!C3=\"Y\",Calculations!C4=\"Y\",Calculations!C5=\"Y\"),Calculations!F17,\n\n\"Need at least 3 of the 4 major domains for TPS calculation\")))))","v":"Need at least 3 of the 4 major domains for TPS calculation"}]
["This material was prepared by the Lake Superior Quality Innovation Network, under contract with the Centers for Medicare & Medicaid Services (CMS), an agency of the U.S. Department of Health and Human Services. The materials do not necessarily reflect CMS policy. 11SOW-MI/MN/WI-D1-15-39  071715"]

{"sheet":"Calculations","index":3,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Domain",null,"Present",null,"Score","Factor",null,"Clinical Care Process","Clinical Care Outcomes","Experience","Safety","Efficiency"]
[]
["Clinical Care Process",null,{"$f":"IF('VBP Worksheet'!G15=\"     Need at least 2 clinical care measures with # of cases ≥ 25\",\"N\",\"Y\")","v":"N"},null,"SUM(Q9,Q11,Q13)/(COUNT(Q9,Q11,Q13)*10)*100",0.25,{"$f":"(1-F3)","v":0.75}]
["Experience",null,{"$f":"IF('VBP Worksheet'!M35=\"Need HCAHPS data\",\"N\",\"Y\")","v":"N"},null,"SUM(Q21,Q22,Q23,Q24,Q25,Q28,Q29,Q30,Q31)/(COUNT(Q21,Q22,Q23,Q24,Q25,Q28,Q29,Q30,Q31)*10))*100",0.25,{"$f":"(1-F4)","v":0.75}]
["Safety",null,{"$f":"IF('VBP Worksheet'!G58=\"     Need at least 3 safety measures\",\"N\",\"Y\")","v":"N"},null,"SUM(Q39,Q42,Q45,Q47,Q51,Q53,Q55)/(COUNT(Q39,Q42,Q45,Q47,Q51,Q53,Q55)*10))*100",0.25,0.75]
["Efficiency",null,{"$f":"IF('VBP Worksheet'!G66=\"     Need Efficiency data\",\"N\",\"Y\")","v":"N"},null,"SUM(Q63)/(COUNT(Q63)*10))*100",0.25,0.75]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F3:F6)","v":1}]
[null,"# Domains"]
["None Missing",4,null,null,null,{"$f":"(('VBP Worksheet'!G14/('VBP Worksheet'!G15))*100*0.25)+ (('VBP Worksheet'!Q33+'VBP Worksheet'!Q34)*0.25)+ (('VBP Worksheet'!G57/('VBP Worksheet'!G58))*100*0.25)+ (('VBP Worksheet'!G65/('VBP Worksheet'!G66))*100*0.25)","v":{"$error":"#VALUE!"}},"TEXT((((SUM('VBP Worksheet'!Q9,'VBP Worksheet'!Q11,'VBP Worksheet'!Q13)/(COUNT('VBP Worksheet'!Q9,'VBP Worksheet'!Q11,'VBP Worksheet'!Q13)*10))*100)*0.25)+(((SUM('VBP Worksheet'!Q21,'VBP Worksheet'!Q22,'VBP Worksheet'!Q23,'VBP Worksheet'!Q24,'VBP Worksheet'!Q25,'VBP Worksheet'!Q28, 'VBP Worksheet'!Q29,'VBP Worksheet'!Q30, 'VBP Worksheet'!Q31)/(COUNT('VBP Worksheet'!Q21,'VBP Worksheet'!Q22,'VBP Worksheet'!Q23,'VBP Worksheet'!Q24,'VBP Worksheet'!Q25,'VBP Worksheet'!Q28,'VBP Worksheet'!Q29,'VBP Worksheet'!Q30,'VBP Worksheet'!Q31)*10))*100)*0.25)+(((SUM('VBP Worksheet'!Q39,'VBP Worksheet'!Q42,'VBP Worksheet'!Q45,'VBP Worksheet'!Q47,'VBP Worksheet'!Q51,'VBP Worksheet'!Q53, 'VBP Worksheet'!Q55)/(COUNT('VBP Worksheet'!Q39,'VBP Worksheet'!Q42,'VBP Worksheet'!Q45,'VBP Worksheet'!Q47,'VBP Worksheet'!Q51,'VBP Worksheet'!Q53,'VBP Worksheet'!Q55)*10))*100)*0.25)+(((SUM('VBP Worksheet'!Q63)/(COUNT('VBP Worksheet'!Q63)*10))*100)*0.25),\"00.00\")&\"\"",null,null,null,null,null,null,null,null,{"$f":"COUNT(Q5,Q7,Q9)","v":0}]
[]
[]
["Clinical Care Missing",3,null,null,null,{"$f":" (('VBP Worksheet'!Q33+'VBP Worksheet'!Q34)*0.33333333)+ (('VBP Worksheet'!G57/('VBP Worksheet'!G58))*100*0.33333333)+ (('VBP Worksheet'!G65/('VBP Worksheet'!G66))*100*0.33333333)","v":{"$error":"#VALUE!"}},"TEXT((((SUM('VBP Worksheet'!Q21,'VBP Worksheet'!Q22,'VBP Worksheet'!Q23,'VBP Worksheet'!Q24,'VBP Worksheet'!Q25,'VBP Worksheet'!Q28, 'VBP Worksheet'!Q29,'VBP Worksheet'!Q30, 'VBP Worksheet'!Q31)/(COUNT('VBP Worksheet'!Q21,'VBP Worksheet'!Q22,'VBP Worksheet'!Q23,'VBP Worksheet'!Q24,'VBP Worksheet'!Q25,'VBP Worksheet'!Q28,'VBP Worksheet'!Q29,'VBP Worksheet'!Q30,'VBP Worksheet'!Q31)*10))*100)*0.333333)+(((SUM('VBP Worksheet'!Q39,'VBP Worksheet'!Q42,'VBP Worksheet'!Q45,'VBP Worksheet'!Q47,'VBP Worksheet'!Q51,'VBP Worksheet'!Q53, 'VBP Worksheet'!Q55)/(COUNT('VBP Worksheet'!Q39,'VBP Worksheet'!Q42,'VBP Worksheet'!Q45,'VBP Worksheet'!Q47,'VBP Worksheet'!Q51,'VBP Worksheet'!Q53,'VBP Worksheet'!Q55)*10))*100)*0.333333)+(((SUM('VBP Worksheet'!Q63)/(COUNT('VBP Worksheet'!Q63)*10))*100)*0.333333),\"00.00\")&\"\"",6.6666669999999997E-2,0,0.33333332999999998,0.26666666,0.33333332999999998,null,{"$f":"SUM(H14:L14)","v":0.99999998999999995}]
["Experience Missing",3,null,null,null,{"$f":"(('VBP Worksheet'!G14/('VBP Worksheet'!G15))*100*0.33333333)+ (('VBP Worksheet'!G57/('VBP Worksheet'!G58))*100*0.33333333)+ (('VBP Worksheet'!G65/('VBP Worksheet'!G66))*100*0.33333333)","v":{"$error":"#VALUE!"}},"TEXT((((SUM('VBP Worksheet'!Q9,'VBP Worksheet'!Q11,'VBP Worksheet'!Q13)/(COUNT('VBP Worksheet'!Q9,'VBP Worksheet'!Q11,'VBP Worksheet'!Q13)*10))*100)*0.333333)+(((SUM('VBP Worksheet'!Q39,'VBP Worksheet'!Q42,'VBP Worksheet'!Q45,'VBP Worksheet'!Q47,'VBP Worksheet'!Q51,'VBP Worksheet'!Q53, 'VBP Worksheet'!Q55)/(COUNT('VBP Worksheet'!Q39,'VBP Worksheet'!Q42,'VBP Worksheet'!Q45,'VBP Worksheet'!Q47,'VBP Worksheet'!Q51,'VBP Worksheet'!Q53,'VBP Worksheet'!Q55)*10))*100)*0.333333)+(((SUM('VBP Worksheet'!Q63)/(COUNT('VBP Worksheet'!Q63)*10))*100)*0.333333),\"00.00\")&\"\"",6.6666669999999997E-2,0.33333332999999998,0,0.26666666,0.33333332999999998,null,0.99999998999999995]
["Safety Missing",3,null,null,null,{"$f":"(('VBP Worksheet'!G14/('VBP Worksheet'!G15))*100*0.33333333)+ (('VBP Worksheet'!Q33+'VBP Worksheet'!Q34)* 0.33333333)+ (('VBP Worksheet'!G65/('VBP Worksheet'!G66))*100*0.33333333)","v":{"$error":"#VALUE!"}},"TEXT((((SUM('VBP Worksheet'!Q9,'VBP Worksheet'!Q11,'VBP Worksheet'!Q13)/(COUNT('VBP Worksheet'!Q9,'VBP Worksheet'!Q11,'VBP Worksheet'!Q13)*10))*100)*0.333333)+(((SUM('VBP Worksheet'!Q21,'VBP Worksheet'!Q22,'VBP Worksheet'!Q23,'VBP Worksheet'!Q24,'VBP Worksheet'!Q25,'VBP Worksheet'!Q28, 'VBP Worksheet'!Q29,'VBP Worksheet'!Q30,'VBP Worksheet'!Q31)/(COUNT('VBP Worksheet'!Q21,'VBP Worksheet'!Q22,'VBP Worksheet'!Q23,'VBP Worksheet'!Q24,'VBP Worksheet'!Q25,'VBP Worksheet'!Q28,'VBP Worksheet'!Q29,'VBP Worksheet'!Q30,'VBP Worksheet'!Q31)*10))*100)*0.333333)+(((SUM('VBP Worksheet'!Q63)/(COUNT('VBP Worksheet'!Q63)*10))*100)*0.333333),\"00.00\")&\"\"",6.25E-2,0.3125,0.3125,0,0.3125,null,1]
["Efficiency Missing",3,null,null,null,{"$f":"(('VBP Worksheet'!G14/('VBP Worksheet'!G15))*100*0.33333333)+ (('VBP Worksheet'!Q33+'VBP Worksheet'!Q34)* 0.33333333)+ (('VBP Worksheet'!G57/('VBP Worksheet'!G58))*100*0.33333333)","v":{"$error":"#VALUE!"}},"TEXT((((SUM('VBP Worksheet'!Q9,'VBP Worksheet'!Q11,'VBP Worksheet'!Q13)/(COUNT('VBP Worksheet'!Q9,'VBP Worksheet'!Q11,'VBP Worksheet'!Q13)*10))*100)*0.333333)+(((SUM('VBP Worksheet'!Q21,'VBP Worksheet'!Q22,'VBP Worksheet'!Q23,'VBP Worksheet'!Q24,'VBP Worksheet'!Q25,'VBP Worksheet'!Q28, 'VBP Worksheet'!Q29,'VBP Worksheet'!Q30,'VBP Worksheet'!Q31)/(COUNT('VBP Worksheet'!Q21,'VBP Worksheet'!Q22,'VBP Worksheet'!Q23,'VBP Worksheet'!Q24,'VBP Worksheet'!Q25,'VBP Worksheet'!Q28,'VBP Worksheet'!Q29,'VBP Worksheet'!Q30,'VBP Worksheet'!Q31)*10))*100)*0.333333)+(((SUM('VBP Worksheet'!Q39,'VBP Worksheet'!Q42,'VBP Worksheet'!Q45,'VBP Worksheet'!Q47,'VBP Worksheet'!Q51,'VBP Worksheet'!Q53, 'VBP Worksheet'!Q55)/(COUNT('VBP Worksheet'!Q39,'VBP Worksheet'!Q42,'VBP Worksheet'!Q45,'VBP Worksheet'!Q47,'VBP Worksheet'!Q51,'VBP Worksheet'!Q53,'VBP Worksheet'!Q55)*10))*100)*0.333333),\"00.00\")&\"\"",6.6666669999999997E-2,0.33333332999999998,0.33333332999999998,0.26666666,0,null,0.99999999000000006]
[]
["Clinical Care and Experience Missing",2]
["Clinical Care and Safety Missing",2]
["Clinical Care and Efficiency Missing",2]
[]
["Experience and Safety Missing",2]
["Experience and Efficiency Missing",2]
[]
["Safety and Efficiency Missing",2]
[]
["Process, Outcomes and Experience Missing",1]
["Process, Outcomes and Safety Missing",1]
["Process, Outcomes and Efficiency Missing",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(G16<>\"     Need at least 1 process measure with denominator ≥ 10\",AND(ISNUMBER(N40),ISNUMBER(N41)),G23<>\"     Need at least 2 outcome measures with # of cases ≥ 25\", G61<>\"     Need at least 3 safety measures\", G69<>\"     Need Efficiency data\"),TEXT((((Calculations!E3SUM(N8,N10,N14)/(COUNT(N8,N10,N14)*10))*100)*0.05)+(((SUM(#REF!,N19,N21)/(COUNT(#REF!,N19,N21)*10))*100)*0.25)+(N40+N41)*0.25+(((SUM(N46,N49,N51,N55,N57)/(COUNT(N46,N49,N51,N55,N57)*10))*100)*0.2)+(((SUM(N67)/(COUNT(N67)*10))*100)*0.25),\"00.00\")&\"%\",\"Need Process/HCAHPS/Outcome/Efficiency data\")","v":"Need Process/HCAHPS/Outcome/Efficiency data"}]