The Table Page (Main Output)

This is where the output is presented.


Points to note are:

table intro.JPG

The top left shows

  • The date and time the analysis was run

  • Country it applies to

  • The Condition it applies to

  • The nature of the values in the table

This is provided so that if the table has been saved it is clear when it was generated and what it applies to

Table Selection

There are six basic tables to choose from as shown here: (see below for Affordability Analysis Tables)

Table Buttons.JPG

The displayed table (see later section) for each button is as follows:

Base Population in 000s:

This is the number of persons in the selected country by age and gender for each year that the user has selected to be shown in the table. Note that it is in 000s of persons. This is effectively the base to which a condition’s incidence/prevalence rate is applied. This data is from the published population for the country in the case of historic years (pre 2018) and forecast population using the Global Demographics Population Model which takes into account birth rates (by age of mother), death rates (by age an gender) and migration by age and gender. The only uncertainty in these number in the medium term is migration. Birth and death rates tend to follow a steady trend over time.

Incidence Prevalence rate

This is the known historic rates and projected future rates in the incidence (per 100,000 persons) or prevalence (percent per 100 persons) rate. This data may be provided from Global Demographics Healthcare or by yourself if you have proprietary data.

Total Cases

This is total number of persons with the condition. In the case of cancers (incidence rate) it is persons and the incidence rate is per 100,000, In the case of other conditions (with a prevalence rate) the output is persons in 000s. That is, the base population multiplied by the percent that have the condition in the specific age/gender/year of the cell.

The incidence rate is modified by the diagnosed rate if the diagnosed rate is not 100%

Total Market Value

This is the number of cases multiplied by the compliance rate and then market price (first column in the scenario sheet). The diagnosed rate is not applied as persons who have not been diagnosed with the condition are unlikely to be using the treatment.

The table displays the total value in Millions US$ by age and gender for each year.

Note: all financial data is in real 2017 values an uses the US$ exchange for the country in 2017,

Brand Share of Cases

This is simply the Total Cases (see above description for that button) multiplied by the brand share in that year.

Brand Total Revenue

This is the number of total cases multiplied by brand share multiplied by compliance rate multiplied by the brand’s price (last column in the Scenario Sheet) for the year.

It represents the expected earnings of the brand given the number of persons known to have the condition, the compliance rate, and the price of the brand. Again the value in the cell is US$ millions.

Note: all financial data is in real 2017 values an uses the US$ exchange for the country in 2017,

Basic Table Format

This is shown opposite - and in this case is ‘persons 000s in the population’

Columns (Years)

The years shown are the ones selected in the ‘Dashboard’ Tab. You can display just one year or all years between and including 2005 to 2037.

Base Table.JPG

The table has three sectionsThe first is the

  • total for all persons,

  • all males

  • all females

The second is for the Summary age groups and is repeated for

  • All (Total)

  • Males

  • Females

The summary age groups are as defined on the ‘Dashboard’ sheet described earlier.

The third section is the detail by 5 year age segments and gender.

In this example it shows just the total, but the same is repeated for each of males and females but not shown here.

This table is the same in terms of layout irrespective of the table option (button) selected.

Next Manual Section: Charts