You are here

Home » Learn and develop » Continuous Mortality Investigation » CMI investigations

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 ci@cmib.org.uk 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 ci@cmib.org.uk.

You might also like

Contact Details

If you have any questions about the CMI please email

info@cmilimited.co.uk

Filter or search events

Start date
E.g., 13/12/2019
End date
E.g., 13/12/2019

Events calendar

  • IFoA Joint Member Event with the Sunshine Insurance Group, Beijing China

    Room TBC, Kuntai International Plaza, No.12, Chaowai Street, Chaoyang District, Beijing 地址：会议室待定，北京市朝阳区朝外大街乙12号1号楼昆泰国际大厦
    12 December 2019

    Spaces available

    The IFoA’s President-elect Tan Suee Chieh will visit Beijing. We will co-host CPD and Awards Presenting event with the Sunshine Insurance Group on Thursday 12 December 2019. The event is part of Mr Tan’s first presidential trip to China.

  • ARC Sessional Research Event: Drivers of Mortality - Risk Factors and Inequality

    Staple Inn Hall, High Holborn, London, WC1V 7QJ
    6 January 2020

    Spaces available

    The authors will focus on a large dataset obtained from the UK’s Office for National Statistics (ONS) and related sources. Data are available at the level of Lower Super Output Areas (LSOAs) – small geographical areas with, typically, 1000-2000 residents and include death counts, exposures and a significant number of socio-economic variables including the index of multiple deprivation (IMD).

  • SIAS Event: My Journey to Data Science, Big Data and AI

    Staple Inn Hall, High Holborn, London, WC1V 7QJ
    7 January 2020

    Spaces available

    Patrick Lee is an actuary who has made the transition to working in software architecture and artificial intelligence (AI). He holds Microsoft Professional qualifications in Data Science, Big Data and AI and is currently working towards a DevOps (the automation of software testing and deployment) qualification. He is a member of the IFoA Council and is also President of the Wessex Actuarial Society. He is also a member of the IFoA and the RSS's joint Data Science Focus Group and will talk on the ethical use of AI. 

  • NED Event: Actuaries as iNEDs of Investment Fund Boards / Investment Governance Committees and Value

    Staple Inn Hall High Holborn London WC1V 7QJ
    9 January 2020

    Spaces available

    This IFoA event for NEDs explores what skills and experience are required to undertake non-executive roles, e.g. as independent NEDs on fund boards or members of IGCs. The event will be chaired by Brandon Horwitz, an actuary who is a consultant and who has held various investment governance roles and who specialises in investment governance as well as being an iNED.

  • NoCA event - The Matching Adjustment Calculation

    N/A
    10 January 2020

    Spaces available

    This presentation covers the detail for how the matching adjustment is calculated. A small simple example spreadsheet is provided and discussed in detail.

    For actuaries wanting to get more involved with the matching adjustment, this is the opportunity to get a detailed description of the mechanics involved. This includes cashflows derisking, PRA tests as well as hypothecation.

    The presentation is provided by James Sharpe who has worked on a number of matching adjustment calculations with several firms.

  • IFoA Volunteer Recognition Reception

    Staple Inn, 4 High Holborn, Holborn, London WC1V 6DR, UK
    15 January 2020

    Spaces available

    As a thank you to all our Institute and Faculty of Actuaries (IFoA) volunteers, you are invited to join us at Staple Inn Hall, for an evening of drinks, canapes and networking, in London.

    IFoA President, John Taylor, will be attending and will make a speech

    If you support the IFoA as a volunteer (member or non-member), or in any other role, and you are going to be in London on 15 January, please book your place and join us at this reception.

     

  • Sessional Meeting - Operational Risk Dependencies

    Royal College of Physicians of Edinburgh 9 Queen St Edinburgh EH2 1JQ
    20 January 2020

    Spaces available

    The Operational Risk Working Party aims to assist actuaries and others in the modelling and management of operational risk. One of the key challenges in modelling operational risk is the modelling of dependencies between operational risks, and between operational and non-operational risks such as market, credit and insurance risk. Their paper seeks to assist in this regard, and help develop good practice in setting assumptions and modelling operational risk dependencies. 

  • KSS event in Glasgow: Public Sector Pensions

    Hymans Robertson, Glasgow 20 Waterloo St, Glasgow
    30 January 2020

    Spaces available

    – the unappreciated key assumption, the resulting unsustainable promises, the unmanaged risk and the unrecognised debt? 

    Speaker: Allan Martin will present this talk on 30 January in Glasgow, Stirling and Edinburgh. If you wish to register for another location please return to the Events Calendar.

  • KSS event in Stirling: Public Sector Pensions

    M&G Prudential, Stirling Craigforth Campus, Stirling
    30 January 2020

    Spaces available

    – the unappreciated key assumption, the resulting unsustainable promises, the unmanaged risk and the unrecognised debt? 

    Speaker: Allan Martin will present this talk on 30 January in Glasgow, Stirling and Edinburgh. If you wish to register for another location please return to the Events Calendar.

  • KSS event in Edinburgh: Public Sector Pensions

    Hymans Robertson 1, Exchange Place, Semple St, Edinburgh
    30 January 2020

    Spaces available

    – the unappreciated key assumption, the resulting unsustainable promises, the unmanaged risk and the unrecognised debt? 

    Speaker: Allan Martin will present this talk on 30 January in Glasgow, Stirling and Edinburgh. If you wish to register for another location please return to the Events Calendar.

  • The Great Risk Transfer – Breakfast briefing and launch event

    Staple Inn Hall, High Holborn London WC1V 7QJ
    31 January 2020

    Spaces available

    Launch of the IFoA’s 2020 thought leadership campaign The Great Risk Transfer. The campaign will examine the trend of the transfer of risk from institutions to individuals, and how people can be better equipped to manage the financial risks they now face. At this breakfast event the IFoA will launch a call for evidence on this topic.

  • Professional Skills Training - London (11 February 2020)

    Staple Inn, High Holborn, London WC1V 7QJ         
    11 February 2020

    Spaces available

    A Trusted Profession

    A 2 hour CPD event designed to meet the IFoA’s Stage 3 Professional Skills Training under the IFoA’s CPD Scheme 2019/2020.  This session is suitable for actuaries working in any area (i.e. it is not specifically aimed at Pensions, GI or any other technical discipline) and is interactive, so you should come along prepared to take part in the discussions.

  • Sessional: Impact of E-cigarettes Working Party

    Royal College of Physicians, 9 Queen St, Edinburgh EH2 1JQ
    24 February 2020

    Spaces available

    This sessional meeting will be of direct interest to actuaries and others working in the in the Health and Care, Life or Pensions sectors or indeed actuaries with an interest in morbidity or mortality. Note: Registration is from 17.30 in time for the sessional to begin at 18.00.

  • Professional Skills Training - Edinburgh (25 February 2020)

    IFoA (Edinburgh), Level 2, Exchange Crescent 7 Conference Square Edinburgh EH3 8RA
    25 February 2020

    Spaces available

    A Trusted Profession

    A 2 hour CPD event designed to meet the IFoA’s Stage 3 Professional Skills Training under the IFoA’s CPD Scheme 2019/2020.  This session is suitable for actuaries working in any area (i.e. it is not specifically aimed at Pensions, GI or any other technical discipline) and is interactive, so you should come along prepared to take part in the discussions.

  • Spring Lecture 2020, Edinburgh - Vicky Pryce

    Assembly Rooms, 54 George St, Edinburgh EH2 2LR
    25 March 2020

    Spaces available

    What next in Economic Policy?

    Please join us on 25 March 2020 for our annual Spring Lecture presented by Vicky Pryce in Edinburgh. 

  • IFoA Asia Conference 2020, Kuala Lumpur

    CCEC Nexus, 7, Jalan Kerinchi, Bangsar South, 59200 Kuala Lumpur, Wilayah Persekutuan Kuala Lumpur, Malaysia
    24-25 June 2020
    Spaces available

    The sixth annual Asia Conference once again offers a prestigious line-up of home and international speakers discussing the insurance and financial industry’s innovation and change in Asia. This year's conference in Kuala Lumpur will be hosted by Tan Suee Chieh, IFoA’s first Asian President. He will also make his Presidential address at this conference and will expand on the important elements of IFoA’s new strategy. 

    Additionally, this landmark conference will showcase how the IFoA is reinventing itself to support its members to succeed and thrive in a digital age, within traditional businesses and beyond, as a global organisation. 

    Not to be missed by international industry players, opinion formers, academic and industry leaders, actuaries and non-actuaries.