CubaPopPyramid.xls

	A	B	C	D	E	F	G	H	I	J	K	Q	Z	AA	AB	AC
1	This sheet downloads US Census data and displays it in a population pyramid chart.						Screencast	http://vimeo.com/econexcel/poppyramid					Cell link	Code	Select a country	Country Selected
2	Year	Age	Male	Female			Select country, set years (use scroll bars or direct enter in cells K3 and K4), and click Get IDB Data button.					Usage Notes:	52	AF	Afghanistan	Cuba

3	2014	0	-56,099	52,963	109,062					Start year:	2014	Data download from census.gov can be slow (depends on connection speed and years requested).		AL	Albania
4	2014	1	-56,246	53,107	109,353	Dependency Ratio				End year:	2030	Data availability varies. 1950 to 2030 is max possible range, but max of 25 years in one download.		AG	Algeria
5	2014	2	-56,425	53,284	109,709	41%						When data are not available, a message displayed.		AQ	American Samoa
6	2014	3	-56,504	53,363	109,867			10						AN	Andorra
7	2014	4	-56,519	53,387	109,906							Longer bar at top of chart is due to grouping 85-89 year olds.		AO	Angola
8	2014	5	-56,632	53,499	110,131	%>60						90-94, 95-99, 100+ also grouped.		AV	Anguilla
9	2014	6	-56,865	53,736	110,601	18%								AC	Antigua and Barbuda
10	2014	7	-56,701	53,585	110,286							Buttons explained:		AR	Argentina
11	2014	8	-58,644	55,431	114,075							Get IDB Data goes to web site (below chart) and downloads data requested into columns A:D.		AM	Armenia
12	2014	9	-62,541	59,121	121,662							Play animates the chart for all years of data in columns A:D.		AA	Aruba
13	2014	10	-66,477	62,855	129,332							Pick A Year sets the chart to a specific year from data in columns A:D.		AS	Australia
14	2014	11	-69,843	66,095	135,938							Show First Year sets the chart to first year of data (cell A3).		AU	Austria
15	2014	12	-70,148	66,415	136,563							Copy Sheet copies this sheet (to make country comparisons).		AJ	Azerbaijan
16	2014	13	-70,546	66,794	137,340							Common X Axis sets the same X axis for all existing PopPyr sheets (to make better comparisons).		BF	Bahamas
17	2014	14	-73,412	69,521	142,933							Take a picture copies the chart as a picture; paste it (ctrl-V) as needed.		BA	Bahrain
18	2014	15	-75,157	71,203	146,360							Reset All wipes everything clear.		BG	Bangladesh
19	2014	16	-75,115	71,224	146,339									BB	Barbados
20	2014	17	-73,994	70,188	144,182							Double-click X axis values (in the chart) to set max and min values.		BO	Belarus
21	2014	18	-72,335	68,682	141,017									BE	Belgium
22	2014	19	-71,657	68,088	139,745							Use Excel's zoom, if needed, to fit the chart on the screen.		BH	Belize
23	2014	20	-72,601	69,019	141,620									BN	Benin
24	2014	21	-74,705	71,071	145,776									BD	Bermuda
25	2014	22	-79,682	75,774	155,456									BT	Bhutan
26	2014	23	-86,484	82,261	168,745									BL	Bolivia
27	2014	24	-88,785	84,546	173,331				Source:	http://www.census.gov/population/international/data/idb				BK	Bosnia and Herzegovina
28	2014	25	-88,710	84,572	173,282									BC	Botswana
29	2014	26	-86,721	82,815	169,536									BR	Brazil
30	2014	27	-80,746	77,278	158,024									BX	Brunei
31	2014	28	-81,064	77,708	158,772									BU	Bulgaria
32	2014	29	-80,832	77,622	158,454									UV	Burkina
33	2014	30	-76,514	73,587	150,101									BM	Burma
34	2014	31	-74,524	71,860	146,384									BY	Burundi
35	2014	32	-67,074	64,785	131,859									CB	Cambodia
36	2014	33	-55,984	54,062	110,046									CM	Cameroon
37	2014	34	-56,051	54,397	110,448									CA	Canada
38	2014	35	-61,563	60,172	121,735									CV	Cape Verde
39	2014	36	-69,751	68,534	138,285									CJ	Cayman Islands
40	2014	37	-78,397	77,317	155,714									CT	Central African Republic
41	2014	38	-86,065	84,956	171,021									CD	Chad
42	2014	39	-92,078	90,852	182,930									CI	Chile
43	2014	40	-96,311	94,827	191,138									CH	China
44	2014	41	-99,248	97,406	196,654									CO	Colombia
45	2014	42	-102,062	99,857	201,919									CN	Comoros
46	2014	43	-104,633	102,159	206,792									CG	Congo (Kinshasa)
47	2014	44	-106,797	104,323	211,120									CF	Congo (Brazzaville)
48	2014	45	-108,530	106,464	214,994									CW	Cook Islands
49	2014	46	-109,667	108,321	217,988									CS	Costa Rica
50	2014	47	-110,758	110,191	220,949									IV	Cote D"Ivoire
51	2014	48	-110,727	110,913	221,640									HR	Croatia
52	2014	49	-107,978	108,955	216,933									CU	Cuba
53	2014	50	-101,986	103,575	205,561									UC	Curacao
54	2014	51	-93,711	95,784	189,495									CY	Cyprus
55	2014	52	-84,514	87,053	171,567									EZ	Czech Republic
56	2014	53	-76,008	79,030	155,038									DA	Denmark
57	2014	54	-69,085	72,520	141,605									DJ	Djibouti
58	2014	55	-64,522	68,350	132,872									DO	Dominica
59	2014	56	-61,727	65,926	127,653									DR	Dominican Republic
60	2014	57	-59,019	63,743	122,762									EC	Ecuador
61	2014	58	-56,149	61,296	117,445									EG	Egypt
62	2014	59	-54,003	59,427	113,430									ES	El Salvador
63	2014	60	-52,579	58,169	110,748									EK	Equatorial Guinea
64	2014	61	-51,694	57,343	109,037									ER	Eritrea
65	2014	62	-51,217	56,798	108,015									EN	Estonia
66	2014	63	-50,768	56,252	107,020									ET	Ethiopia
67	2014	64	-49,959	55,354	105,313									FO	Faroe Islands
68	2014	65	-48,548	53,931	102,479									FJ	Fiji
69	2014	66	-46,763	52,144	98,907									FI	Finland
70	2014	67	-44,843	50,277	95,120									FR	France
71	2014	68	-42,990	48,497	91,487									FP	French Polynesia
72	2014	69	-40,980	46,544	87,524									GB	Gabon
73	2014	70	-38,975	44,523	83,498									GA	Gambia
74	2014	71	-36,987	42,486	79,473									GZ	Gaza Strip
75	2014	72	-35,085	40,358	75,443									GG	Georgia
76	2014	73	-33,097	38,127	71,224									GM	Germany
77	2014	74	-30,895	35,826	66,721									GH	Ghana
78	2014	75	-28,501	33,407	61,908									GI	Gibralter
79	2014	76	-26,053	30,988	57,041									GR	Greece
80	2014	77	-23,598	28,606	52,204									GL	Greenland
81	2014	78	-21,260	26,325	47,585									GJ	Grenada
82	2014	79	-19,083	24,145	43,228									GQ	Guam
83	2014	80	-17,097	22,138	39,235									GT	Guatemala
84	2014	81	-15,210	20,289	35,499									GK	Guernsey
85	2014	82	-13,470	18,546	32,016									GV	Guinea
86	2014	83	-11,743	16,761	28,504									PU	Guinea-Bissau
87	2014	84	-10,055	14,981	25,036									GY	Guyana
88	2014	85-89	-29,479	51,198	80,677									HA	Haiti
89	2014	90-94	-8,927	21,692	30,619									HO	Honduras
90	2014	95-99	-1,561	5,746	7,307									HK	Hong Kong
91	2014	100+	-130	778	908									HU	Hungary
92	2015	0	-55,950	52,820										IC	Iceland
93	2015	1	-56,028	52,902										IN	India
94	2015	2	-56,184	53,054										ID	Indonesia
95	2015	3	-56,370	53,239										IR	Iran
96	2015	4	-56,454	53,321										IZ	Iraq
97	2015	5	-56,454	53,332										EI	Ireland
98	2015	6	-56,552	53,429										IM	Isle of Man
99	2015	7	-56,784	53,669										IS	Israel
100	2015	8	-56,623	53,518										IT	Italy