Each of the variables in the APACHE II are weighted according to a method which can be found in the text below. In the end, the overall sum of the points awarded to the variables makes the score. The higher the score, the higher the severity of the patient’s status, therefore, the higher the mortality risk. The following table introduces the non-operative and post-operative mortality risks correlated with APACHE II scores: APACHE II non op post op 0 - 4 4% 1% 5 - 9 8% 3% 10 - 14 15% 7% 15 - 19 24% 12% 20 - 24 40% 30% 25 - 29 55% 35% 30 - 34 73% 73% ≥35 85% 88%.

• Pancreatitis Severity Score

The numbers in the parentheses represent the point value assigned to each clinical parameter above. The Apache Score is the sum of these points.

APACHE II scoring method explained The Acute Physiology and Chronic Health Evaluation II (APACHE II) is one of the ICU scoring systems that classify disease outcome in hospitalized patients. The above calculator consists of two different versions of the APACHE II model to answer to specialist preferences. The first tab from the APACHE II score calculator requires the direct input of clinical data whilst the second tab allows the selection of the intervals in which the patient belongs. The second tab has the advantage of showing the number of points each interval is awarded. The variables used in both calculation methods are: ■ Chronic health conditions and/ or severe organ system insufficiency or is immunocompromised and the following conditions: 1) Cirrhosis of the liver – biopsy confirmed or portal hypertension or previous history of hepatic failure/encephalopathy/coma. 2) New York Heart Association Class IV cardiovascular disease.

Pancreatitis Severity Score

3) Severe COPD - Hypercapnia, home O 2 use, or pulmonary hypertension, documented chronic hypoxia or respiratory dependency. 4) Renal dialysis.

5) Immunocompromised – through immunosuppression therapy, chemotherapy, radiation, long term steroid medication or autoimmune disease such as lymphoma, AIDS. Score interpretation The APACHE II is calculated by a medical professional within 24h of admission and provides an integer score that establishes patient prognosis and mortality risk. The score ranges from 0 to 71, the higher the score, the higher the severity of the patient’s condition. A direct connection between increases in score and increases in mortality risk has been found in both surgical and non-surgical patients. The following table assigns the mortality risk percentages to each APACHE II score interval: APACHE II non op post op 0 - 4 4% 1% 5 - 9 8% 3% 10 - 14 15% 7% 15 - 19 24% 12% 20 - 24 40% 30% 25 - 29 55% 35% 30 - 34 73% 73% ≥ 35 85% 88%. About the study APACHE II was created in 1985 by et al.

Following a study on 5815 patients from 13 hospitals. 12 routine physiological measurements have been taken into account, along with patient age, and previous health status. The score has shown good prognostic value in acutely ill patients. Higher scores have been found closely correlated with the subsequent risk of hospital death in many common diseases. The model was subsequently validated in a cohort of 1721 patients with the area under the ROC curve found to be higher than 0.8. Other patient severity score APACHE II belongs to a group of general illness scoring systems which are used to evaluate the severity, organ dysfunction and prognosis of patients in the ICU and other units. The most commonly used outcome score is the Glasgow Coma Scale (GCS).

The Mortality Probability Model (MPM) predicts hospital mortality while the Multiple Organ Dysfunction Score (MODS) allows an individual organ failure prognostic. Similar to APACHE II, the Simplified Acute Physiology Score (SAPS) provides information on morbidity and mortality, however, with slightly more factors taken into account.

README.md Acute Physiology and Chronic Health Evaluation II (APACHEII) This is a VBA function for Microsoft Excel that calculates the APACHEII score for a patient. This score estimates ICU mortality. You should use the worst value for each physiological variable within the past 24 hours.

This macro was written using the formula provided by Knaus WA et al (1985). This function ensures that all values are within a sane range. Upper and lower limits allow for some 'world record' setting conditions and might suggest conditions beyond known survivable ranges.

These are meant to ensure that there are not obvious coding or data entry errors. References:. Used for quality assurance of macro below.

Knaus WA et al. APACHE II: A severity of disease classification system.

Crit Care Med. 1985;13:818-2 How to Use Example File. Download APACHE-II-Example.xlsm. Be sure to 'Enable Macros'. Edit the data or add rows to calculate APACHE II scores. Adding Macro to Existing Excel Workbook.

Open a new or existing Excel file. And select the format 'Excel Macro-Enabled Workbook (.xlsm)'. Go to Tools - Macro - Visual Basic Editor. Copy and paste the contents of the 'APACHE-II.bas' file into the editor that appears. You can alternative 'Import' this file. Save the workbook.

Close the Visual Basic Editor and go back to your workbook. Use the APACHEII function to calculate the APACHEII score for the given arguments. Once you have an APACHE II score, you can use APACHEIIDEATHRATE or APACHEIIDEATHRATEADJUSTED to determine the estimated death rate.

See for adjustment factors. Remember to 'Enable Macros' each time you open the file.