You are here

Critical illness spreadsheets

The CMI Critical Illness Committee is making available the spreadsheets used to derive the diagnosis rates in papers 43, 50 and 52 so that member offices can experiment with different approaches

In order to obtain the spreadsheets from the CMI for CMI Working Paper 43, CMI Working Paper 50 and CMI Working Paper 52, please complete the Spreadsheets Request Form. We will retain your contact details so that we can keep you updated of developments, if appropriate. The data the spreadsheets contain is highly aggregated and intended for use in rate-fitting.

The spreadsheets are made available on the understanding that you agree to the following conditions:

  • the data contained in the spreadsheets is intended to allow experimentation with alternative sets of diagnosis rates and may not be suitable for any other purpose
  • although the CMI has made reasonable attempts to validate the data its accuracy cannot be guaranteed and the CMI accepts no liability for its use
  • although the CMI has made reasonable attempts to ensure the accuracy of the spreadsheets, their accuracy cannot be guaranteed and the CMI accepts no liability for their use
  • the CMI will not provide any support in relation to the software
  • the data and the spreadsheets will be made available for your company’s use only. The spreadsheets, the data or copies of the data must not be passed to any other organisation
  • in any published comment or analysis you will acknowledge the CMI as the source of the spreadsheets and data.

In using the spreadsheets and data we request that you communicate any issues you discover to the Critical Illness Committee by emailing at the earliest opportunity

The CMI are keen that alternative approaches to the derivation of diagnosis rates and any difference in the results are discussed with the Committee before any public comment is made. We hope you will feel able to abide by this request.

The spreadsheets are provided on CD and function with Office 2003 and Office 2007.

To contact the Critical Illness Committee please email

Contact Details

If you have any questions about the CMI please email

Filter or search events

Start date
E.g., 24/10/2021
End date
E.g., 24/10/2021

Events calendar

  • The Growth Mindset for Actuaries

    13 October 2021 - 8 December 2021

    Fully booked.

    This practical course is aimed at actuaries at any stage of their career who want to develop their own growth mindset and apply it to their work setting and personal or professional lifelong learning. The content of the course builds on the lecture given by Dr Helen Wright on Growth Mindset as part of the President’s 2021 Lecture series, and will be delivered over a period of 2 months, from mid-October to early December.

  • Spaces available

    The importance of biodiversity for finance, business and policy is being increasingly recognised. While many studies highlight the overall economic impact that biodiversity loss could have, it is much more difficult to quantify and understand the particular impact that is may have on individual businesses or communities. The management and measurement of these risks is a field where actuaries are well placed to contribute.

  • Spaces available

    The climate crisis and the degradation of our planet will affect societies everywhere. How we address these threats will require solutions that transcend borders. As a global profession, the actuarial community is well-placed to consider and propose effective risk management solutions to help manage the climate crisis.

  • GIRO 2021 Webinar Series

    8 November 2021 - 19 November 2021
    Spaces available

    Join leading experts to discuss key issues, emerging ideas and new research across the general insurance sector.

  • Spaces available

    This is a free webinar with an expert panel providing their views on the ongoing IFoA consultation for proposals regarding changes to the regulatory framework on climate change and sustainability.

    The regulatory consultation sets out, for feedback some proposed approaches that the IFoA are considering in relation to charter commitments under the UK’s Green Finance Education Charter (GFEC) and the regulatory framework, including the Actuaries’ Code.

  • Life 2021 Webinar Series

    22 November 2021 - 26 November 2021
    Spaces available

    Join leading experts to discuss key issues, emerging ideas, and new research across the Life insurance sector.

  • Spaces available

    Content will be aimed at all actuaries looking to understand the issues surrounding mental health in insurance and in particular those looking to ensure products and processes widen access for, and are most useful to, those experiencing periods of poor mental health.