Cost of Illness tool - creating a table of graph

This documents explains how to create a table or a graph in five steps. Click here to go directly to the data-interface.


1. Select dimensions

The data on cost of illness data in the Netherlands for 2003 are available in seven dimensions: diagnosis, age, gender, health care provider, health care function, source of finance and period of data collection (2003 or 2005). By default costs over 2005 are shown. In the first step the main dimensions of the graph or table must be chosen. Select two dimensions in order to create a cross-table or bar chart. Select one dimension to create a one-column table or a pie chart. If one doesn’t select a dimension at all, a very simple table is shown, with only one cell. It is possible to add gender as an additional third dimension to a cross-table. Just tick the box which appears after two other dimensions are chosen.


2. Select an outcome measure

Cost-of-illness data are available for two outcome measures: (a) total costs for the Netherlands, in million of euro, (b) cost per inhabitant, in euro. The costs per inhabitant have been calculated by dividing total costs by number of inhabitants. If no filter has been applied to age and gender (see step 5), the number of inhabitants is equal to the average number of Dutch citizens in 2003. If a filter has been applied for age and/or gender, only the number of citizens within this filter is used to divide by.


3. Select a perspective on health care costs

By default health care costs in our English language interface are defined using the System of Health Accounts of the OECD, which is very useful in international comparisons between countries. However, we have also calculated costs using two local definitions of health care costs. These two perspectives reflect specific national care arrangements for the Netherlands which internationally are not seen as part of the health care sector, for instance a part of the housing costs of the elderly and handicapped. It is possible to show data using these local perspectives. Be warned in advance that these perspectives use a Dutch language interface


4. Choose a type of costs

By default, costs are shown using current prices. But it is possible to show costs using constant prices. In this view costs for all periods have been recomputed using prices of 2005.. For 2005 there is no difference between constant and current prices. For 2003, the difference between constant en current prices represents the price devolopment. This development is based on provider-specific estimates made by Statistics Netherlands, and does not equal consumer price inflation.


5. Limit the costs selected.

A selection filter can be applied to every dimension, using a combo-box. If no filter is applied all costs for the selected perspective are shown. For some dimensions the filtering process is split in two parts. For example, for diagnosis first a main group of diagnosis is selected. After this, a second box appears which can be used to select a specific disease within this main group. Age is a special case. Two combo-boxes are shown. Use the first one to select an age classification (two groups, four groups et cetera). This doesn’t apply a filter but only changes the appearance of the age dimension. For filtering, use the second box, which contains all groups of the selected age classification. The period filter is by default set on 2005, but can be set on 2003. If period has been selected as a dimension (step 1), it is also possible to set this filter on 'all', this will show data for both periods simultaneously.


6. Select output type

Push the button ‘table’ in order to create a table, push ‘graph’ to create a graph. After selecting ‘graph’ new buttons appear with the available graph-types. After creating a graph it is possible to change its appearance, for instance the file type (.png, .jpeg, .svg among others) or the color scheme

How do I save my results?

After creating a table or graph download options will appear. Data can be downloaded as .csv files. These can be handled by most spreadsheet programs. Save a graph by right-clicking on the picture. The data format you selected in the extra graph options will be used. Default type is .png. Be warned that some graphical output types may not be supported on your computer