Compendium 2007 - spreadsheets

All the excel files are structured in a similar way. The excel files usually contain three sheets: raw data, sorted data and a numbered sheet. The raw data comes straight out of the database and you can use this data for your own analysis. The sorted data has been analyzed by our data analyst (Bertine Lokhorst) and is usually linked to the numbered sheet, where the final output for the Compendium is presented in a table or graph. You can repeat the analysis by copy and pasting the raw data into the sorted data sheet (note: make sure you paste it in the right place) and then follow the instructions in red.

It may take some effort to figure out exactly what is what in the spreadsheets - but if you have any trouble with them, you can always ask for clarification.