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., 28/07/2021
End date
E.g., 28/07/2021

Events calendar

  • Asia Conference 2021 webinar series

    Online webinar series
    26 July 2021 - 30 July 2021
    Spaces available

    We have made it through 2020 but the COVID-19 crisis continues to have a significant impact on individuals, societies, businesses and the wider economy across the globe. Navigating the world post COVID-19 in an uncertain and highly unstable time brings along many uncertainties, challenges and exciting opportunities. Hence the theme of this year’s IFoA Asia Conference Webinar Series is “Risk. Adapt. Thrive.”

  • CMI Income Protection

    30 July 2021

    Spaces available

    In April 2021, the CMI Income Protection Committee published Working Paper 149, which detailed the changes to analysis methodology for the Income Protection Investigation and the impact of past data issues. This webinar will provide an overview of the changes in the analysis approach and discuss the adjustments to the IP11 claim inceptions graduations.

  • Spaces available

    Louise Pryor, IFoA President, will chair this free-to-view session, in which Alex Darsley, TPR, Actuarial Regulatory Policy, will be discussing the regulator’s Climate Change Guidance Consultation, which is seeking views on new guidance designed to help trustees meet tougher standards of governance in relation to climate change ri

  • Spaces available

    Risk Management Webinar ProgrammeInternal audit is often the Cinderella of the audit world. It’s a regulatory requirement for insurance companies to have an internal audit function, so why not make it as useful as possible?  This session will look at how to link an internal audit plan to the risk register, and how that helps audit committees and boards to spot problems and fix them.

  • Spaces available

    Climate change is one of the greatest risks facing our world today. Addressing it will require multi-faceted solutions. Through this panel session, we will explore the different levers that can be used to meet net-zero targets including climate science and data, government engagement, and mobilising green finance.