T43 Facilities and Public Space Projections.xlsx

	A	B	C	D	E	F	G
1		T43 Facilities and Public space Projections (Step 1)
2		T43 Facilities and Public space Projections (Step 1)
3
4
5	Instructions:	Copy the data from H24. Urban Expansion Projections into this table.
6		Use this template to calculate urban expansion projections.
7		Use a comma (,) for thousands and a period (.) for decimals.
8		The percentages are already configured, insert numbers only (e.g. for 2%, insert 2).
9		1. TIME FRAME OF THE DEVELOPMENT PLAN
10		Indicate in cell (E10) with the year for which the Plan is being developed.
11		The development plan is for the year:			2030
12
13		2. POPULATION DENSITY
14		Indicate in cells (B16, C16 and D16) the data of the current year or of the last census of your city (or territory for which you wish to calculate the urban expansion) and the territorial extension of the same.
15		Current situation (or data from the last census):
16		Year	Total population (inhab)	Surface area (km²)	Average Density (inhab/km²)
17		2007	8,445,211	228.00	37,040
18
19		3. POPULATION GROWTH
20		Indicate in cell (E20) the average annual population growth rate of your city (or territory for which you wish to calculate urban expansion). If you do not have this data, go to numeral 3.1 POPULATION GROWTH CALCULATION and place the result in cell E20.
21		Average annual population growth rate (%):			5.00%
22		Note: This information can usually be found through literature review. If it is not available, calculate it by filling in the orange cells in the table below. Add the final result (D25) to the yellow cell above (E17).
23
24
25		3.1 POPULATION GROWTH CALCULATION
26		If you do not have the annual population growth rate, calculate it using the table below. First, fill in the orange cells. Once you have the final result (D25), include it in cell (E20).
27		Rellena las celdas naranjas de abajo con la población de 2 años diferentes.
28		Population Growth Calculation
29		Year	Total population (inhab)	Average annual population growth rate (%):
30	Year 1	2007	8,445,211
31	Year 2	2017	9,485,405
32		Difference in years	Population Growth	1.23%
33		10	1,040,194	1.23%
34		Note1: For this analysis, the difference in years between year 1 and year 2 should not exceed 10 years.
35		Example: Comparing data between 2020 and 2009 (11 years difference) could mislead the analysis.
36		Note2: Prioritize data from recent years. Data should not be older than 15 years.
37		Example: For a 2020 Development Plan, data from 2000 and 2008 will not be adequate (20 years of comparison). For a 2020 Development Plan, 2019 and 2018 data will be ideal.
38
39		Summary: Urban Expansion Projections
40		Projections for the year:	2030
41
42		Demographic Growth			Urban Expansion (km²)
43		Ratio (%)	Total population (inhab)	Population growth (inhab)	Low density	Average density	High density
44		Ratio (%)	Total population (inhab)	Population growth (inhab)	6,500	10,000	15,000
45		5.00%	25,939,666	17,494,455	2,691.45	1,749.45	1,166.30
46		Note1: Another index (%) can be used if necessary, taking into account the context.
47		Note2: High-density urban sprawl planning is normally recommended. However, the local context and culture must be taken into account.
48		Como referencia, consulte los principios de planificación de ONU-Hábitat:			A new strategy of Sustainable Neighbourhood Planning: Five Principles
49
50
51		CONTINUE TO THE TAB "PUBLIC SPACE CALCULATION".
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100