u2-dq

Logistica Map

		Logistica	Note: There was a typo in the book: the latitude should have been negative. Because this only switches hemispheres, no calculations change. For the curious, on Earth, Logistica would sit in Queensland, Australia and stretch out into the ocean.
		Notes on this sheet:	Input cells are labeled and orange. There are just two inputs in this tab.
			In the input cell, you determine where the capital city should be located. In this tab, we have put it at point 0,0 (on Earth, this is somehere just off the coast east coast of Africa).
			The tables show the approximiate distance to the capital for each city, the weighted average distance (per citizen), and the percent of citizens within various distance to the capital.
			The map will plot a square when the capital location falls within the general area of Logisica.
		City #	Latitude	Longitude	Population	Approximate Distance to Capital (Miles)
		1	-16.6	154.8	1,655,000	10742
		2	-16.7	156.8	2,300,000	10880
		3	-16.8	153.2	601,000	10634
		4	-17	154	1,385,000	10691
		5	-17	152	1,230,000	10553
		6	-17.2	144.9	665,000	10068
		7	-17.5	155.7	664,000	10811
		8	-17.4	147.1	885,000	10221
		9	-17.5	141.1	1,116,000	9810
		10	-17.8	155.1	636,000	10772
		11	-17.9	153.8	1,200,000	10684
		12	-18	144.6	148,000	10054
		13	-18.4	142.4	854,000	9907
		14	-18.9	156.8	1,473,000	10898
		15	-19.3	148.3	615,000	10319
		16	-19.4	152.9	1,145,000	10635
		17	-19.4	142.8	627,000	9944
		18	-19.9	143.7	542,000	10010
		19	-20.3	152.5	379,000	10615
		20	-21.2	143.7	964,000	10023
		21	-21.6	155.6	546,000	10839
		22	-22.6	140.1	706,000	9792
		23	-23.4	155.8	727,000	10871
		24	-24	144.4	669,000	10100
		25	-24.9	146.4	931,000	10247
		Capital Location:	0	0		10,476	<<--- Weighted Average Distance
			Input cell is directly above.	Input cell is directly above.
					Percent of Citizens Within Certain Distance to Capital
					% within 100 miles	0%
					% within 200 miles	0%
					% within 300 miles	0%

1

154.80000000000001 -16.600000000000001 COG 0 0 2

156.80000000000001 -16.7 3

153.19999999999999 -16.8 4

154 -17 5

152 -17 6

14 4.9 -17.2 7

155.69999999999999 -17.5 8

147.1 -17.399999999999999 9

141.1 -17.5 10

155.1 -17.8 11

153.80000000000001 -17.899999999999999 12

144.6 -18 13

142.4 -18.399999999999999 14

156.80000000000001 -18.899999999999999 15

148.30000000 000001 -19.3 16

152.9 -19.399999999999999 17

142.80000000000001 -19.399999999999999 18

143.69999999999999 -19.899999999999999 19

152.5 -20.3 20

143.69999999999999 -21.2 21

155.6 -21.6 22

140.1 -22.6 23

155.80000000000001 -23.4 24

144.4 -24 25

146.4 -24.9