GLA Population Projections - Custom Age Tables

This Excel based tool enables users to query the raw single year of age 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. Each year the GLA demography team produce sets of population projections. 

The full raw data by single year of age (SYA) and gender are available as Datastore packages at the links below.

**How to use the tool**

Simply select the lower and upper age range for both males and females (starting in cell C3) and the spreadsheet will return the total population for the range.

Find out more about GLA population projections on the [GLA Demographic Projections page](/demography/)

Click here for an [archive of population projections from previous years that have since been superseded.](/gla-population-projections-superseded-custom-age-tables/)

**2019-based projections** (published November 2020)

* Central range (upper bound)
* Central range (lower bound)
* Low population variant
* High population variant

**2016-based projections** (published July 2017)

* Housing-linked projection incorporating data from the 2016 SHLAA 
* Ward-level projections consistent with the borough housing-led model
* Ethnic group projections consistent with the borough housing-led model (50MB file)

本Excel基础工具允许用户查询原始单年度年龄数据，以便能够轻松计算任何年龄范围，无需执行复杂且耗时的公式，这些公式还可能存在人为错误的风险。每年，大伦敦管理局（GLA）的人口统计团队会编制一系列人口预测。详细按单年度年龄（SYA）和性别划分的原始数据，可通过以下链接获取，作为数据存储包提供。

**工具使用方法**

只需简单地选择男女双方的上下年龄范围（从单元格C3开始），电子表格便会返回该年龄范围内的总人口数。

更多关于GLA人口预测的信息，请访问[GLA人口预测页面](/demography/)。

点击此处查看[以往年份已替代的人口预测存档](/gla-population-projections-superseded-custom-age-tables/)。

**基于2019年的预测**（发布于2020年11月）

* 中心范围（上限）
* 中心范围（下限）
* 低人口变体
* 高人口变体

**基于2016年的预测**（发布于2017年7月）

* 与2016年SHLAA数据相结合的住房相关预测
* 与地区住房引导模型一致的地区层级预测
* 与地区住房引导模型一致的族群预测（文件大小为50MB）