Template:NZ population data 2018/doc

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.

This template uses the Statistical Standard for Geographic Areas 2018 (SSGA18), whereas uses the New Zealand Standard Areas Classification 1992 (NZSAC92). The most significant change in SSGA18 is new urban area boundaries.

Changes (October 2021)
Macrons (tohutō) are now included in region and territorial authority names, specifically: Urban areas continue to be spelled without macrons.
 * Manawatū-Whanganui region
 * Whangārei district
 * Kaipātiki local board area
 * Waitākere Ranges local board area
 * Waitematā local board area
 * Puketāpapa local board area
 * Ōrākei local board area
 * Māngere-Ōtāhuhu local board area
 * Ōtara-Papatoetoe local board area
 * Ōtorohanga district
 * Taupō district
 * Ōpōtiki district
 * Manawatū district

Adding to an article
The template has seven parameters: Leaving a show parameter empty results in that value being hidden.
 * 1) area = Statistics NZ name of area for population (e.g. Lower Hutt city). This parameter is mandatory if showpopulation is used.
 * 2) showpopulation = display the population figure
 * 3) showtitle = display the title (e.g. "June 2018")
 * 4) showref = display the reference, can subsequently be reused by adding:
 * 5) titlepre = free text before the title, for example to add parentheses
 * 6) titlepost = free text after the title

The template data uses formatted text numbers, with the comma thousands separator, which is suitable for the majority of uses. For the numerical value, for example to use in Infobox Settlement, use the formula: 0

Automatically updating formulae

 * Population density:
 * Percent of national population:

Annual update
The data on this template needs to be updated once per year. Statistics New Zealand releases the subnational population estimates around 20 October (see Stats NZ's release calendar for exact date).
 * 1) Download the 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&" = "&TEXT(B1,"#,##0") for first entry, copy down entire column. The TEXT function makes sure that commas are kept in the numbers.
 * 4) copy & paste results into template
 * 5) update the name "June XXXX"
 * 6) update the reference
 * 7) verify Statistics NZ names are consistent with "Show changes", affected articles need the new name
 * 8) verify everything is ok by looking at a sample of pages. You may need to purge the cache on some articles by adding ?action=purge to the end of the URL for changes to show.
 * 9) List of cities in New Zealand and List of New Zealand urban areas need checks for rank changes, affected articles may need a minor reword