Archive:Tutorial:Updating the yearbook

Procedure and timing (2014 yearbook)

As described in the DM document Doc. 696_1.2 from the Director’s Meeting of 13.4.2010, the yearbook will be updated through Statistics Explained.

Production units within Eurostat have been asked to i) make changes and updates in Statistics Explained directly or ii) indicate to the Yearbook team (email to ESTAT COMPENDIUM PUBLICATIONS) any detailed changes to be implemented by our contractor (INFORMA).

Equally production units were asked to indicate when i) they would be updating articles themselves or ii) data would be available on Eurobase for INFORMA to make the updates. Production units may extend their deadline either by making an appropriate comment in the Talk page of Statistics Explained (using the Discussion button on the page for which you want to extend the deadline) or by directly contacting the Yearbook team (email to ESTAT COMPENDIUM PUBLICATIONS).

Stage 1 of updating: drafting

For production units updating articles themselves, please follow the guidance given below and in the tutorial of Statistics Explained. Make sure that you approve the page when finished (unit approval on the bottom of the page). The article will then be reviewed by INFORMA to ensure a consistent use of standards in the English language employed, the formatting and style of tables and figures, and the presentation in Statistics explained.

For production units producing new articles themselves, please follow the same guidance as indicated above for updating articles. Please pay particular attention to ensure that an Excel file containing the tables, figures (and data for the figures) is complete (containing also titles, subtitles, footnotes and sources) and attached to the new article.

For production units that have indicated that INFORMA should update the articles, please ensure that any changes you want to be implemented in your articles have been communicated to the Yearbook team, along with a date on or after which extractions may be made from Eurobase for use in the articles. Please be as precise as possible with any requested changes as INFORMA will implement these directly in Statistics Explained. As far as possible, all further communication should be done through Statistics Explained only (using the discussion page).

Stage 2 of updating: review by production units

Regardless of whether your article has been reviewed or updated by INFORMA, production units will be contacted when work on an article by INFORMA has been completed. By this stage

the text will have been reviewed/updated
as will the Excel files (containing the English version of the tables and figures as well as German and French translations of labels in so far as they are available from previous editions or other available sources) attached to the articles
but the images of tables and figures in the articles will not have been updated.

This is an opportunity for production units to review the articles (text and Excel file). Changes may be made directly to the text in Statistics Explained. Changes to teh Excel fiels should either be

explained on the discussion page or
made directly in the excel file and clearly identified through the use of coloured text (other than red which is reserved for missing translations), and/or shading of cells, and/or use of comment boxes.

Approval of the articles by the production units may be done by SIGHTING the DRAFT article in Statistics Explained, or by informing the Yearbook team that the review has been completed.

Stage 3 of updating: finalisation of an article

INFORMA will review any feedback from production units. Any remaining issues will be addressed bilaterally between the production units and the yearbook team.

Once the content has been finalised (final text in Statistics Explained and a final Excel file in English only attached to the article) the final images will be uploaded.

Production units will be contacted a second time and asked to SIGHT (again) the DRAFT article.

The Yearbook team will then VALIDATE the article.

Special notes for the 2014 Yearbook

A completely new formatting of tables and figures will be introduced for the 2014 edition of the Yearbook, based solely on the standards for Statistics Explained. Production units that have chosen to update their own articles are encouraged to use the Excel files from the 2013 edition of the Yearbook as a starting point: INFORMA will reformat these to the 2014 standards at the same time as reviewing the content and inserting available translations in German and French.
From the 2014 edition of the Yearbook onwards Excel 2010 will be used. Production units that have chosen to update their own articles may continue to use earlier versions of Excel for their initial draft. However, once the Excel file for an article has been reformatted to teh new standards in Excel 2010 it should be maintained in this format (with the appropriate .xlsx extension).

Support

Yearbook team: Jukka Piirto (tel. 34251)

Statistics Explained: Marc Debusschere (tel. 31985)

Statistics Explained courses can be organised on request. For individual specific questions please contact Marc Debusschere.