Preventive Health Readiness Index (PHRI)Calculator: Master Spreadsheet for Tracking Preventive Health Metrics

A practical scoring tool from healthwardbound.org for organizing preventive health checklist results, comparing health metric categories, and estimating a 100-point Preventive Health Readiness Index (PHRI).

This master Excel spreadsheet is designed to help individuals and health advocates organize preventive care information into a structured, transparent scoring system. After each item in the preventive health checklist is scored, the results are regrouped into 20 major components divided into 2 IOM core health domains¹: Healthy People and Care Quality. The two domains are equally weighted for 50 points each creating a total potential score of 100 for comparison and tracking over time. The components within each domain are also equally weighted.

What the Preventive Health Readiness Index (PHRI) Spreadsheet Does

The spreadsheet converts a broad preventive health checklist into a concise set of scores. It can be used to review vital statistics, lifestyle factors, personal and family medical history, physical examination findings, laboratory results, common preventive screenings, and vaccination status. The goal is not to diagnose disease, but to make preventive health gaps easier to identify, discuss, and follow up with a qualified health professional. Preventive Health Readiness Checklist Components and Weights IOM Healthy People Domain Components (50 points)	Weight
Life expectancy2	50/5
Biological age	50/5
Lifestyle factors	50/5
Social factors	50/5
Environmental factors	50/5
IOM Care Quality Domain Components (50 points)
Vital statistics
Personal medical history	50/15
Family medical history	50/15
Genome & microbiome profiling status	50/15
PE: General appearance	50/15
PE: Eyes Ear Nose Face	50/15
PE: Mouth Pharynx Neck	50/15
PE: Upper Limbs	50/15
PE: Thorax	50/15
PE: Abdomen	50/15
PE: Lower Limbs	50/15
Blood Test	50/15
Urinalysis	50/15
Common Preventive Screens	50/15
Vaccination Status	50/15
Total weight	100

 

How the Preventive Health Readiness Index (PHRI) Is Calculated

For each component, the observed liability score is divided by the maximum possible liability score. The maximum possible liability score is the score that would occur if every subcomponent in that category were assigned a value of 1. The resulting ratio is multiplied by the component weight shown above to produce a fractional liability score.

 

For the Healthy People domain with 5 metrics components:

F_hp = (observed/maximum) × (50/5)

The Healthy People Liability L_hp is obtained by summing up F of all 5 components, so:

L_hp = F_hp1+…+F_hp5

 

For the Care Quality domain with 15 metrics components:

F_cq = (observed/maximum) × (50/15)

Likewise, the Care Quality Liability index L_cq is obtained by summing up F of all 15 components, so:

L_cq = F_cq1+…+F_cq15

 

The overall Preventive Health Liability Index is defined as: L = L_hp + L_cq

 

The Preventive Health Readiness Index (PHRI) is defined as the complement of L on a 100-point scale:

PHRI = 100 − L.

 

How to Interpret the PHRI Score

·         The PHRI and Preventive Health Liability Index (L) are reference tools, not diagnostic measures of overall health.

·         The Preventive Health Liability Index highlights the relative burden of preventive health items that may require attention, documentation, or follow-up.

·         The Preventive Health Readiness Index summarizes the proportion of assessed items that appear to be within range, completed, or otherwise addressed.

·         Scores should be reviewed in context with age, sex, risk factors, medical history, family history, and guidance from a qualified clinician.

 

Current weighting approach: Equal weighting based on the two-level hierarchy is a temporary, transparent method. Future versions may use statistically derived weights if a sufficiently large dataset becomes available to compare index performance against meaningful health outcomes and support formal validation.

References

¹ Institute of Medicine. 2015. Vital Signs: Core Metrics for Health and Health Care Progress. Washington, DC: The National Academies Press. https://doi.org/10.17226/19402.

² Based on Live to 100-Life Expectancy Calculator

 

Abbreviations: IOM, National Academies, Institute of Medicine; PE: Physical Examination; PHRI: Preventive Health Readiness Index.

Preventive Health Scoring & Index Calculation Download

​​Important Medical Disclaimer
This spreadsheet and scoring method are provided for educational and health advocacy purposes only. They are not a substitute for professional medical advice, diagnosis, or treatment. Always consult a qualified health care professional about screening decisions, vaccination status, laboratory results, symptoms, risk factors, and personal medical concerns.