#### Go to HealthTreks Home

Note: Going home clears all of these panels.

#### Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Get
0SR9019TP- 2007 Exam 2 Hip Replacement Treatment

#### Hip Replacement Outcome Analysis

Introduction
This tool generates a variety of basic statistics for DevTreks standard monitoring and evaluation uris. The analyses include basic progress in achieving actual versus target levels for monitoring and evaluation indicators.

Analysis View Description
Sample health care treatment cost used in a tutorial. v171a

Version: 0.9.8

Compare Using:
Aggregate Using:

#### Step 3 of 3. Save

Method 1. Do you wish to save step 2's calculations? These calculations are viewed by opening this particular calculator addin.

Method 2. Do you wish to save the analysis as comma-separated, column-row, text? This format is amenable to further analysis in standard statistical packages. The text can be downloaded by packaging and downloading this uri.

#### Step 1

• Step 1. Monitoring and Evaluation Stage: Some groups may prefer to store all of their baseline, target, and actual indicators results in one analysis. The advantage is that one operation and one input can be used to store benchmark, target, and actual indicator measurements. Other groups may prefer to break the analysis into stages, such as baseline, midterm, and final. The latter requires adding stage-related indicators to specific operations with specific inputs.
• Step 1. Base Calculations To Analyze: Make sure that the data being analyzed corresponds to outputs.
• Step 1. Analysis Type: A video overview of these options is available. The Progress 1 option supports Percent Complete and Weighted Milestone analyis. The Statistics 1 option supports Total, Mean, Median, Variance, and Standard Deviation statistics. The Change by Year option supports Total Change, and Percent Change, analysis.

#### Step 2 and 3

• Step 2. What If Tag Name: Instructional videos explaining the use of what-if scenario calculations should be viewed before changing or using this parameter.
• Step 2. Base Resource Calculations To Analyze: Make sure that the calculator chosen has been used with the data being analyzed.
• Step 2. Compare Using: The Compare Only option uses a calculator's Alternative Type property to further "subdivide" the indicator data being analyzed to support the comparative analysis of alternatives.
• Step 2. Aggregate Using: Types is the least detailed analysis. Groups is the next most detailed analysis. Labels can be the most detailed, but all of the data being analyzed must have been classified using labels and Work Breakdown Structures.
• Step 3. Save Using: The Save command saves xml data the Save Text command saves csv data.

#### Progress 1 Results

• Partial Target Totals Only: The results show the cumulative totals for each indicator's partial targets. Each indicator is identified by a unique label (preferably a WBS label).
• Type: The indicator's Alternative Type: benchmark, actual, partialtarget, fulltarget.
• Actual Total: The actual quantity of the indicator completed during this partial target period.
• Actual Date: The date of the last 'actual' indicator included in the Actual Total.
• Benchmark Total: The starting quantity of the indicator prior to any project intervention.
• Benchmark Percent: (Actual Total / Benchmark Total) * 100. Zero if the Benchmark Total is zero.
• Partial Target Date: The date of this 'partial target' indicator.
• Partial Target Total: The target quantity of the indicator for this partial period.
• Partial Target Percent: (Actual Total / Partial Target Total) * 100. Zero if the Partial Target Total is zero.
• Full Total: The target quantity of the indicator for the full project period.
• Full Percent: (Actual Total / Full Total) * 100. Zero if the Full Total is zero. Note that the Actual Total is only for this partial period. Derive the percent for the full target period by adding together all of this indicator's Full Percents.

#### Change by Year or Label Results

• Name, Type, Date, Label: Taken from the first indicator with the same label and or year.
• Benchmark Total: The Benchmark Total is the initial amount of the indicator being measured that has an Target Type property of Benchmark (regardless of the year).
• Actual Total: The summation of all of the indicators for the same year except for the Benchmark.
• Benchmark Change: The is measured as Actual Total – Benchmark Total for Year x.
• Benchmark Percent Change: This is measured as Actual Total / Benchmark Total for Year x.
• Total Change: This is measured as Year x+1 Total – Year x Total.
• Total Percent Change: This is measured as Total Change / Year x Total.

#### Statistics 1 Results

• Name, Type, Date, Label: Taken from he first indicator. The analysis ignores the type.
• Observations: The number of observations
• Total, Mean, Median, Variance, Standard Deviation: Standard sample statistics for the indicators that have been aggregated (using their labels).

#### References

• International Federation of Red Cross and Red Crescent Societies Project/programme monitoring and evaluation (MandE) guide. 2011. (www.ifcr.org)
• US Government Accountability Office Applied Research and Methods. GAO Cost Estimating and Assessment Guide. Best Practices for Developing and Managing Capital Program Costs. March, 2009.
• United Nations Development Programme Handbook on Planning, Monitoring and Evaluating for Development Results. 2009

#### Reminder: Analyzers require running the underlying NPV calculator after inserting, deleting, or updating, this linked view (that keeps the NPV calculator's linked views synchronized with these linkedviews).

Current view of document
DevTreks -social budgeting that improves lives and livelihoods
Investment Group
DRG469- Major Joint Replacement or Reattachment of Lower Extremity
Investment
0SR9019- Example 2- Replace Hip Joint with Metal Syn Subs, Cem, Open
Monitoring and Evaluation Type: realtime
Outcomes
Outcome
0SR9019- 2007 Replace Hip Joint with Metal Syn Subs, Cem, Open
Type Actual Total Actual Date Benchmark Total Benchmark Percent Partial Target Date Partial Target Total Partial Target Percent Full Target Total Full Target Percent
Q1 Partial Target Patient Health Status
0SR9019A score
partialtarget 87.000 05/29/2007 0.000 0.000 08/30/2007 90.000 96.667 100.000 87.000
This indicator measures the Q1 partial target of a health status index for a hip replacement treatment.
Monitoring and Evaluation Type: realtime
Q1 Partial Target Patient Health Status
0SR9019A score
partialtarget 87.000 05/29/2007 0.000 0.000 08/30/2007 90.000 96.667 100.000 87.000
This indicator measures the Q1 partial target of a health status index for a hip replacement treatment.
Output
2007 OSR9019P1- Patient-reported quality measures
Type Actual Total Actual Date Benchmark Total Benchmark Percent Partial Target Date Partial Target Total Partial Target Percent Full Target Total Full Target Percent
HCAHPSl Target Satisfaction Rating
OSR9019P1A rating
partialtarget 70.000 05/29/2007 75.000 93.333 05/30/2007 75.000 93.333 10.000 700.000
Since this survey is only taken one time per hospital stay, the benchmark target and the partial target are identical.
Hip replacement Q1 target quality rating
OSR9019P1B rating
partialtarget 85.000 05/29/2007 75.000 113.333 08/29/2007 90.000 94.444 10.000 850.000
This rating reflects the Q1 target score for a quarterly patient survey completed using a health quality rating for hip replacements (i.e. Harris, Oxford, CMS).
Output
2007 OSR9019P2 -Physician-reported quality measures
Type Actual Total Actual Date Benchmark Total Benchmark Percent Partial Target Date Partial Target Total Partial Target Percent Full Target Total Full Target Percent
PQRS Partial Target Hospital Stay Days
OSR9019P2A day
partialtarget 4.000 05/29/2007 0.000 0.000 05/30/2007 3.500 114.286 10.000 40.000
This indicator measures the partial target number of hospital stay days for a hip replacement surgery. Because of the short period, the full and partial targets are the same.
PQRS Q1 Partial Target Severity of Complications
OSR9019P2B score
partialtarget 17.000 05/30/2007 0.000 0.000 08/30/2007 15.000 113.333 10.000 170.000
This indicator measures the partial target severity of complications score for a hip replacement surgery three months after surgery.
Components
Component
0SR9019 2- 2007 Replace Hip Joint with Metal Syn Subs, Cem, Open
Type Actual Total Actual Date Benchmark Total Benchmark Percent Partial Target Date Partial Target Total Partial Target Percent Full Target Total Full Target Percent
Q1 Partial Target Patient Health Status
0SR9019A score
partialtarget 87.000 05/29/2007 0.000 0.000 08/30/2007 90.000 96.667 100.000 87.000
This indicator measures the Q1 partial target of a health status index for a hip replacement treatment.
Example 2 of a sample data set used in a health care analysis tutorial.