This project is an interactive Excel dashboard that estimates a person’s 10-year risk of developing coronary heart disease (CHD) using the Framingham 2008 general CVD risk model (BMI-based equation).
It was designed as both an educational tool and a portfolio project to demonstrate skills in data cleaning, formulas, PivotTables, conditional formatting, and dashboard design.
- Accepts user inputs (age, sex, smoking status, diabetes, blood pressure, cholesterol, BMI, treatment status).
- Returns a 10-year CHD risk %, a color-coded risk category, and a dynamic plain-English interpretation.
- Supports comparisons to observed outcomes from the Framingham cohort dataset.
- User Input Form: Intuitive input fields with dropdowns and validation.
- Result Card: Risk percentage, risk category (Low/Moderate/High), and number of risk factors.
- Dynamic Interpretation Line: Plain-English explanation that updates automatically.
- Cohort-Based Charts:
- CHD Risk by Age Group
- CHD Risk by Smoking Status
- Insights Box: Key takeaways from Framingham study and risk factor importance.
- Open the Excel file.
- Go to the CALCULATOR sheet.
- Enter your details in the blue User Inputs form.
- The Result Card updates instantly with:
- Final 10-year CHD risk %
- Risk category (color-coded)
- Number of risk factors
- Review the charts and insights to understand your profile in context.
- Low Risk (<10%) → Favorable profile, lifestyle maintenance recommended.
- Moderate Risk (10–20%) → Elevated risk, lifestyle and medical follow-up may be needed.
- High Risk (>20%) → Strongly elevated risk, clinical evaluation recommended.
- Based on D’Agostino et al., Circulation 2008 (Framingham BMI-based risk model).
- Implemented entirely in Microsoft Excel:
- Formulas (logarithmic risk model implementation)
- PivotTables & PivotCharts
- Conditional Formatting
- Dashboard-style layout
- Includes a logistic regression feature importance chart for interpretability.
- Created by: Adi Wiesel
- Date: October 2025