Excel worksheet for calculating cardiovascular risk

This calculator has been published with the hope that it will be useful, but without warranty, implied or explicit, of fitness for a particular purpose. We do not accept responsibility for any injury, damages or other outcomes arising as a result, direct or indirect, of using this calculator. Further advice on the appropriate use of the risk equations can be assessed only after the examination.

NOTES on how to use the worksheet:

  • Simply copy the blue cells in row 2 to allow calculations of risk for more than one individual
  • It is expected that individuals using this worksheet should have sufficient technical know-how to make it work - please do not contact us for technical advice
  • There is NO error checking - blanks will be treated as value 0 and extreme values will be accepted
  • The BNF calculation is simply the sum of CHD and stroke. Values will therefore be influenced by diabetes and LVH which are not taken into account by standard BNF charts
  • Although all calculations take into account smoking, note that ASSIGN uses a different variable (cigarettes) to Framingham/BNF (smoker) - it is important to ensure cigarettes and smoker are consistent with one another

A single row provided as an example:

Risk calculated over 10 years for a 55 year old female diabetic smoker (10 cigarettes daily), with systolic BP 150mmHg, total cholesterol 5mmol/l, HDL 1mmol/l, living in an area with SIMD deprivation score 20

Definition of the MENUs used for calculating risk:
  • TIMEPERIOD- Time in years over which risk is calculated. Usually set to 10, appropriate range is 4 to 12 years. Does not affect ASSIGN calculation (which is always 10 years).
  • AGE- Patient age in years (try to limit to 35 to 75 years).
  • SEX- Patient sex: male=1, female=0
  • CIGARETTES- Number of cigarettes smoked per day. Affects ASSIGN score only.
  • SMOKER- ASmoking status: smoker=1, non-smoker=0. Does not affect ASSIGN score
  • FAMILY-HX- Family history of premature cardiovascular disease: yes=1, no=0. Affects ASSIGN score only.
  • DIABETES- Presence of diabetes: yes=1, no=0
  • LVH- Presence of left ventricular hypertrophy on ECG: yes=1, no=0. Does not affect ASSIGN score.
  • SIMD- Scottish index of multiple deprivation. Usual range is 0.53 to 87.7. 20 is a reasonable default when unknown. Affects ASSIGN score only.
  • SYSTOLIC-BP- Systolic blood pressure in mmHg
  • TOTAL-CHOL- Total cholesterol in mmol/L
  • HDL-CHOL-HDL cholesterol in mmol/L
The following outcomes are calculated:
  • CHD-Coronary heart disease. Calculated using Framingham equation.
  • MI-Myocardial infarction. Calculated using Framingham equation.
  • STROKE-Stroke. Calculated using Framingham equation.
  • CVD-Cardiovascular disease. Calculated using Framingham equation.
  • CHD_DEATH-Death from coronary heart disease. Calculated using Framingham equation.
  • CVD_DEATH-Death from cardiovascular disease. Calculated using Framingham equation.
  • BNF-BNF/JBS2 calculation of cardiovascular disease. Equals the sum of CHD
  • STROKE from Framingham equation.
  • ASSIGN-Cardiovascular disease. Calculated using ASSIGN equation.

Total cholesterol - Total cholesterol is the sum of all the cholesterol in your blood. The higher your total cholesterol, the greater your risk for heart disease. Here are the total values that matter to you: Less than 200 mg/dL 'Desirable' level that puts you at lower risk for heart disease. A cholesterol level of 200 mg/dL or greater increases your risk. 200 to 239 mg/dL 'Borderline-high.' 240 mg/dL and above 'High' blood cholesterol. A person with this level has more than twice the risk of heart disease compared to someone whose cholesterol is below 200 mg/dL.

HDL cholesterol - High density lipoproteins (HDL) is the 'good' cholesterol. HDL carry cholesterol in the blood from other parts of the body back to the liver, which leads to its removal from the body. So HDL help keep cholesterol from building up in the walls of the arteries. Here are the HDL-Cholesterol Levels that matter to you: Less than 40 mg/dL A major risk factor for heart disease 40 to 59 mg/dL The higher your HDL, the better 60 mg/dL and above An HDL of 60 mg/dL and above is considered protective against heart disease. Systolic blood pressure - Systolic blood pressure is the first number of your blood pressure reading. For example, if your reading is 120/80 (120 over 80), your systolic blood pressure is 120.