Custom Age Tool for GLA Population Projections, Ward

April 2013

Excel Custom Age-Range Tool for GLA Projections Data

This Excel based tool enables users to query the single year of age raw data so that any age range can easily be calculated without having to carry out often complex, and time consuming formulas that could also be open to human error.

This dataset by age band and gender is available as a Datastore package at the link below.

How to use the tool: Simply select the lower and upper age range for both males and females and the spreadsheet will return the total population for the range.

Tip: You can copy and paste the wards you are interested in to another worksheet by clicking: Edit then Go To, then Special, and Visible cells only. Then simply copy and paste the cells to a new location.

These spreadsheets will automatically ensure that figures are rounded to the nearest 50 and that age groups are aggregated to a minimum of five years.

Data at any smaller disaggregation would not be robust enough for public consumption.

Warning: The following files are around 35MB, and may take some time to download depending on your bandwidth.

GLA 2008 round (High) Ward Projections (March 2009) (SUPERSEDED)

GLA 2009 round (revised) London Plan Ward Projections (August 2010) (SUPERCEDED)

GLA 2010 round SHLAA Ward Projections (February 2011) (SUPERCEDED)

GLA 2011 round SHLAA Standard Ward Projections (January 2012) (SUPERCEDED)

GLA 2011 round SHLAA High Ward Projections (January 2012) (SUPERCEDED)

GLA 2012 round SHLAA based Ward Projections (March 2013) (XLS)

GLA 2012 round SHLAA Trend based Ward Projections (March 2013) (XLS)

Packages: