User:Denkbär

Page i'm working on: List_of countries by suicide rate

local test version: User:Denkbär/List of countries by suicide rate

Update: New WHO 2009 Data (retrieved 2010-06-01)
36 rows have changed, 2 new countries (Maldives and Greneda) added.

All modified and new rows are marked with a comment in the "Country" column.

The figures for Canada seem not to be WHO data, but there was no remark (footnote) about this fact.

See uploaded comparison table (as pdf or OpenOffice.org spread sheet) with an overview of the changes between the old Wikipedia version and the 2009 WHO data.

Here's a short description how i created this table (pages 1-4):


 * Wikipedia and WHO data copied and pasted side by side into one spread sheet.
 * Rows synchronized due to differences in sort sequence
 * Duplicate rows created to fill the gaps
 * Added a new column with a 4 digit year number for WHO data
 * A conditional format is used to compare the dates (year): red means Wikipedia needs update, green indicates Wikipedia data which is already more recent than WHO data
 * Data values that need an update are marked with a yellow background color.

The requred "total" values are looked up in all (38) individual WHO-PDF files. Pages 5-7 show the merged data sorted by the total column. This table was used to update the page markup.

Denkbär (talk) 18:10, 4 June 2010 (UTC)