Table 2: Content of survival data in Excel® worksheets.

Categories

Content

Title  (top of page)

Description of data set or subset and years of inclusion

Interval month

(Column A)

Consecutive number by months from date of diagnosis

Alive in month

(Column B)

Number of patients known to be alive at the start of this month

Dead in month

(Column C)

Number of patients known to have died during that month

Last seen in month

(Column D)

Number of patients known to still be alive as of that month, but no subsequent follow up information

Exposed to Risk

(Column E)

Computer calculation based on previous 3 columns for calculation used in actuarial survival figure

Proportion Dying

(Column F)

Column C divided by Column B

Proportion Surviving

(Column G)

Column B minus Column D, divided by Column B

Proportion at end of interval (Column H)

Calculation of the Kaplan-Meir statistic for overall survival (all-cause mortality)

Proportion relative survival (Column I)

 

 

 

Adjusted calculation of Column H to produce the relative survival statistic (adjusted for competing causes of death based on age and gender of those dying in the interval compared to expected rates for year in use.