Affordability Model - Manual

There are 7 sections of the manual - as listed on the left.
We recommend you read through them in the order shown


When the Excel model is first opened it displays this page.

On this page you select

  1. The country and condition to be analysed

  2. Years to be displayed in Tables and charts

  3. The summary age groups

  4. set up and save the parameters for the market/condition selected

Note: Default values are as shown and if happy with them simply select the button to go to ‘scenarios’

Each of the ‘Steps’ is described in greater detail below


Country and Condition

If you have purchased multiple countries and conditions for each country then these two drop down menu work as follows:

First select the country you are interested in and this will then adjust the selection in the second drop down menu to that available for the selected country. You then Click on the condition you want to use. If the condition is not shown then it is not included in the database.

If you add your own epidemiological data for a specific country/condition and save it then it will be added to the list of conditions available for that country in this menu.

Years to display

This determines the number of columns in the output table (and years displayed in the charts). The program generates the table for all years, this option simply affects what is displayed. As such you can return to this ‘Dashboard’ page at any time and change the selection with immediate effect.

To save time at the top you can clear all selections by clicking the ‘clear all’ button. You can also select all years by clicking the ‘All’ option.

Summary Age groups

In the output you see detail by individual 5 year age groups by gender. However, it is often useful to summarize the data into major age breaks . The model allows you to have 4 summary groups and you define them by entering a group number beside them. So in the above example ages 0-4 through to 15-19 years are in group 1., etc.

All age groups must be allocated to a summary group and the groups must be contiguous - that is you cannot have a group 2 in the middle of group ‘1’s.

Creating Epidemiological Data (Step 4)

This is explained in detail in the section titled ‘Adding Your Own Epidemiological Data’ and is a facility to add your own proprietary data to the model. You can skip this step if using Global Demographics Healthcare data.

Setting Up Detailed Scenarios (Step 5)

This is explained in the Section titled ‘Setting Scenarios’ and should be completed before running any Tables. Otherwise a generic scenario is used which may not be appropriate. Note that you can change the scenarios as often as you like.

Affordability Analysis (Step 6)

This is where the model determines what proportion of persons with a condition can afford a treatment at a particular price, subject to how they fund that cost. It demonstrates the trade off between total revenue and number of customers. Having identified a preferred solution it is then possible to apply this to the overall solutions and see detail year by year for all age gender segments.

Next Manual Section: Setting Parameters