Jump to content

Template:NZ population data 1992/doc

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by XLerate (talk | contribs) at 03:48, 4 November 2008 (add example). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Usage

This template is to supply uniform, up-to-date population data to New Zealand articles. It facilitates a mass update of all the population numbers in articles.

Add to article

{{NZ population data|Example city|y|y|y}}

The template has four parameters:

  1. area = Statistics NZ name of area for population (e.g. Auckland City), defaults to pagename
  2. showpopulation = display the population figure
  3. showtitle = display the title (e.g. "June 2008 estimate")
  4. showref = display the reference

Leaving a show parameter empty results in that value being hidden

Annual update

This data on this template needs to be updated once per year, as of 2008 Statistics NZ releases annual population estimates at the end of October.

  1. Download latest spreadsheet from Statistics New Zealand
  2. In a new spreadsheet, collect the data from all tables to get two columns, area name and most recent year data
  3. create a new column with formula =" | "&A1&" = "&B1 for first entry, copy down entire column. May need an adjustment to keep commas in the numbers
  4. copy & paste results into template
  5. update the name "June XXXX estimate"
  6. update the reference