{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":false,"merged":[[74,0,74,2],[73,0,73,2],[0,0,0,2],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[1,0,1,2],[72,0,72,2],[11,0,11,1],[12,0,12,1],[6,0,6,1],[51,0,51,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[29,0,29,2],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1]]}
["Estimating Hospital's Share of Hospital Transformation Performance Program (HTPP) Funding"]
["HTPP Calculator"]
["Part I: HTPP Total for All Hospitals"]
["Estimated HTPP total for the year (approx between $130-150 million)",null,133000000]
[]
["Part II: Floor Payment Calculation for All Hospitals"]
["Will your hospital achieve reporting/performance requirement on at least 75% of the measures?",null,"Yes"]
[]
["Number of hospitals (including your own) that will achieve reporting/performance requirement on at least 75% of the measures",null,28]
[]
["Total Floor payment for all hospitals ($500,000*# hospitals receiving floor payment)",null,{"$f":"500000*C9","v":14000000}]
[]
["Part III: Base Distribution Calculation"]
["Remaining fund for base distribution after floor payments",null,{"$f":"C4-C11","v":119000000}]
[]
["A. Value of each measure for all hospitals"]
["Readmission",0.1875,{"$f":"B17*$C$14","v":22312500}]
["Medication safety - Hypoglycemia ",6.25E-2,{"$f":"B18*$C$14","v":7437500}]
["Medication safety - Warfarin",6.25E-2,7437500]
["Medication safety - Opioids",6.25E-2,7437500]
["HCAHPS - explain medicine",{"$f":"B17/2","v":9.375E-2},11156250]
["HCAHPS - discharge instructions",{"$f":"B17/2","v":9.375E-2},11156250]
["Healthcare Acquired Infections - CLABSI in all tracked units",{"$f":"B17/2","v":9.375E-2},11156250]
["Healthcare Acquired Infections - CAUTI in all tracked units",{"$f":"B17/2","v":9.375E-2},11156250]
["Sharing of ED visit info with primary care providers and other hospitals",0.125,14875000]
["Behavioral Health - Follow-up after hospitalization of mental health illness",{"$f":"B25/2","v":6.25E-2},7437500]
["Behavioral Health - SBIRT in the ED",{"$f":"B25/2","v":6.25E-2},7437500]
["Total value of all measures for all hospitals",{"$f":"SUM(B17:B27)","v":1},{"$f":"SUM(C17:C27)","v":119000000}]
[]
["B. Assumptions about your hospital's performance (Yes = successful; No = unsuccessful or not applicable)"]
["Readmission",null,"Yes"]
["Medication safety - Hypoglycemia ",null,"Yes"]
["Medication safety - Warfarin",null,"Yes"]
["Medication safety - Opioids",null,"Yes"]
["HCAHPS - explain medicine",null,"Yes"]
["HCAHPS - discharge instructions",null,"Yes"]
["Healthcare Acquired Infections - CLABSI in all tracked units",null,"Yes"]
["Healthcare Acquired Infections - CAUTI in all tracked units",null,"Yes"]
["Sharing of ED visit info with primary care providers and other hospitals",null,"Yes"]
["Behavioral Health - Follow-up after hospitalization of mental health illness",null,"Yes"]
["Behavioral Health - SBIRT in the ED",null,"Yes"]
[]
["C. Information about your hospital size"]
["Total DRG Hospital Medicaid discharges*",null,60056]
["Total DRG Hospital Medicaid inpatient days* ",null,232945]
["Your hospital's total Medicaid discharges*",null,3817]
["Your hospital's total Medicaid inpatient days*",null,12545,null,null,null,"Adjustment to remove Shriner's from measures where they have no service line"]
["Share of total DRG Medicaid discharges",null,{"$f":"C46/C44","v":6.3557346476621826E-2},null,null,null,{"$f":"C46/(C44-203)","v":6.3772910296894053E-2}]
["Share of  total DRG Medicaid inpatient days",null,{"$f":"C47/C45","v":5.3853914014037649E-2},null,null,null,{"$f":"C47/(C45-810)","v":5.4041829108062121E-2}]
["Adjustment Factor",null,{"$f":"(C48*0.5)+(C49*0.5)","v":5.8705630245329737E-2},null,null,null,{"$f":"(G48*0.5)+(G49*0.5)","v":5.8907369702478091E-2}]
[]
["D. Estimated earning for each measure for your hospital"]
["Readmission",null,{"$f":"IF(C31=\"Yes\",C17*$C$50,0)","v":1309869.3748489197}]
["Medication safety - Hypoglycemia ",null,{"$f":"IF(C32=\"Yes\",C18*$C$50,0)","v":436623.1249496399}]
["Medication safety - Warfarin",null,436623.1249496399]
["Medication safety - Opioids",null,436623.1249496399]
["HCAHPS - explain medicine",null,{"$f":"IF(C35=\"Yes\",C21*$C$50,0)","v":654934.68742445984}]
["HCAHPS - discharge instructions#",null,{"$f":"IF(C36=\"Yes\",C22*$G$50,0)","v":657185.34324327123}]
["Healthcare Acquired Infections - CLABSI in all tracked units",null,654934.68742445984]
["Healthcare Acquired Infections - CAUTI in all tracked units",null,654934.68742445984]
["Sharing of ED visit info with primary care providers and other hospitals#",null,{"$f":"IF(C39=\"Yes\",C25*$G$50,0)","v":876247.12432436156}]
["Behavioral Health - Follow-up after hospitalization of mental health illness",null,436623.1249496399]
["Behavioral Health - SBIRT in the ED#",null,{"$f":"IF(C41=\"Yes\",C27*$G$50,0)","v":438123.56216218078}]
["Total earned for all measures for your hospital (not including floor payment)",null,{"$f":"SUM(C53:C63)","v":6992721.9666506713}]
[]
["Total estimated payment for your hospital"]
["1. Floor Payment Amount",null,{"$f":"IF(C7=\"Yes\",500000,0)","v":500000}]
["2. Base Distribution Amount Earned for All Measures",null,{"$f":"C64","v":6992721.9666506713}]
["Total estimated hospital payment (inlcuding floor payment)",null,{"$f":"SUM(C67:C68)","v":7492721.9666506713}]
[]
[]
["Notes:"]
["This tool should only be used to provide an estimate.  The final payment can vary significantly from this calculation based on the size of the HTPP pool, how successful your hospital is in meeting the floor payment criteria and the performance benchmark/improvement target of the measures, and the performance of other hospitals on each of the measures.  Current template assumes that all other hospitals are successful on each measure; this can be revised once all data for the year has been submitted.  "]
["*Medicaid discharges and Medicaid inpatient days are based on Oct 1, 2011-Sep 30, 2012 hospital inpatient discharge data as reported to COMPDATA.  Includes both fee-for-service and managed care data. Includes newborn.  Excludes non-Oregon hospitals.   "]
["#Since one or more hospitals do not have the relevant service line, their Medicaid discharges and inpatient days are subtracted from the total."]