A Walk Through United States 1

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

A Walk Through the United States

Submission Instructions

1.- This is an individual assignment.


You are asked to propose a trip that begins and ends in Olympia (Washingto
and visits the rest of the cities exactly once.
The total distance of the trip, of course, is the sum of distances between citie

2. The next page contains a column that allows you to enter a trip, calculates
and draws a map connecting the cities.
Make sure that in this same page you enter the time you spent on this proble

3. Come to class with a copy of your route, the time you spent working on the

1 0

# Name
1 Abe, Takashi
2 Al-Ajmi, Mosaed
3 Alcalde Kast, Jaime
4 Amin, Nirav
5 Anza Gómez, Sofía
6 Bicaco Urrutia, Selman
7 Blanchard Nerín, Pablo
8 Cantiero Veiga, Danilo
9 Coates Vales, D. Alejandro
10 Dakik, Dina
11 Davydkin, Victor
12 Deswal, Vikram
13 Donada Molins, Juan
14 Dufour, Rafaël
15 Ecay Osaba, Eduardo
16 Echevarría Munilla, José María
17 Escaño García, Víctor
18 Faus Hindersin, Nicolau
19 Fernandes, Joshua Amor
20 Fernández Cavalheiro, Blanca
21 Fraga, Javier Santos
22 Glasgow, Thomas
23 Goncalves, Paulo
24 González-Gallarza Jiménez, Fco Jav
25 Hakim, Vanessa
26 Herrándiz Espuny, Salvador
27 Hopf, Simon
28 Iriarte Ibáñez, Javier
29 Kafie García-Vélez, Ana Maria
30 Konishi, Haruaki
31 Kumar, Ayush
32 Kuoman Jiménez, David José
33 Machado, João Paulo Duarte
34 Manabe, Masayuki
35 Martins Pinheiro, Sofia
36 Marzano, Luca Salvatore
37 Miyabayashi, Ryu
38 Mizogaki, Asuka
39 Mrnjavac Cameron, Lee
40 Mukhija, Paritosh
41 Namiki, Yohei
42 Obukhoff, Dennis
43 Peláez, Susana
44 Pérez Benito, Jon
45 Pfeifer, Luca
46 Picornell Sabaté, Aina
47 Prasad, Neha
48 Puerta Varela, Lola
49 Quijano, Melissa
50 Rekalic, Matija
51 Rodrigo Koch, Laureano
52 Rodríguez Jasso, Sofia Eugenia
53 Santamaría Wiese, Annika
54 Saxena, Abhinav
55 Snyder, Alan
56 Thakur, Alok
57 Thielmann, Andreas
58 Thoraia, Mohamed Saied
59 Tibrewala, Ankit
60 Trairatvorakul, Prayer
61 Urrutia Bilbao, Oier
62 van Andel, Daniel
63 van den Breemer, Robert
64 Van Westenbrugge, Kees
65 Villaburu, Mayte
66 Wang, Elysia
67 Wang, Manuel
68 Winder, James
69 Yang, Fan
70 0
71 0
72 0
73 0
74 0
75 0
ds in Olympia (Washington)

of distances between cities.

u to enter a trip, calculates the total distance,

e you spent on this problem.

e you spent working on the problem and the total distance.

C
Abe, Takashi
Al-Ajmi, Mosaed
Alcalde Kast, Jaime
Amin, Nirav
Anza Gómez, Sofía
Bicaco Urrutia, Selman
Blanchard Nerín, Pablo
Cantiero Veiga, Danilo
Coates Vales, D. Alejandro
Dakik, Dina
Davydkin, Victor
Deswal, Vikram
Donada Molins, Juan
Dufour, Rafaël
Ecay Osaba, Eduardo
Echevarría Munilla, José María
Escaño García, Víctor
Faus Hindersin, Nicolau
Fernandes, Joshua Amor
Fernández Cavalheiro, Blanca
Fraga, Javier Santos
Glasgow, Thomas
Goncalves, Paulo
González-Gallarza Jiménez, Fco Jav
Hakim, Vanessa
Herrándiz Espuny, Salvador
Hopf, Simon
Iriarte Ibáñez, Javier
Kafie García-Vélez, Ana Maria
Konishi, Haruaki
Kumar, Ayush
Kuoman Jiménez, David José
Machado, João Paulo Duarte
Manabe, Masayuki
Martins Pinheiro, Sofia
Marzano, Luca Salvatore
Miyabayashi, Ryu
Mizogaki, Asuka
Mrnjavac Cameron, Lee
Mukhija, Paritosh
Namiki, Yohei
Obukhoff, Dennis
Peláez, Susana
Pérez Benito, Jon
Pfeifer, Luca
Picornell Sabaté, Aina
Prasad, Neha
Puerta Varela, Lola
Quijano, Melissa
Rekalic, Matija
Rodrigo Koch, Laureano
Rodríguez Jasso, Sofia Eugenia
Santamaría Wiese, Annika
Saxena, Abhinav
Snyder, Alan
Thakur, Alok
Thielmann, Andreas
Thoraia, Mohamed Saied
Tibrewala, Ankit
Trairatvorakul, Prayer
Urrutia Bilbao, Oier
van Andel, Daniel
van den Breemer, Robert
Van Westenbrugge, Kees
Villaburu, Mayte
Wang, Elysia
Wang, Manuel
Winder, James
Yang, Fan
A
B
C
Enter your solution in J9:J55 by w
A Walk Through the United States which you visit them. For example
that the second city you visit will b
Time spent working on this problem (minutes): 10 trip begins and ends in the same c
of the remaining cities only once.
Total Distance 460.6 F7, M6, and I4.

Order City
City (State) Label HV ? visited Label HV distance
Montgomery (Alabama) 1 ###
### 1 1 45 5###
Phoenix (Arizona) 2 ###
### 1 2 35 5### 7.6 100
Little Rock (Arkansas) 3 ###
### 1 3 10 ###
### 12.4
Sacramento (California) 4 ###
### 1 4 42 ###
### 12.9
Denver (Colorado) 5 ###
### 1 5 26 ###
### 14.7 90
Hartford (Connecticut) 6 ###
### 1 6 4 8### 3.9
Dover (Delaware) 7 ###
### 1 7 2 ###### 24.9
Tallahassee (Florida) 8 ###
### 1 8 29 ###
### 13.0 45
Atlanta (Georgia) 9 ###
### 1 9 5 ###### 15.6 80
Boise (Idaho) 10 ###
### 1 10 48 ###
### 5.3
Springfield (Illinois) 11 ###
### 1 11 39 ###
### 14.7 35
Indianapolis (Indiana) 12 ###
### 1 12 13 ###
### 15.7 70
Des Moines (Iowa) 13 ###
### 1 13 25 ###
### 6.4 10
Topeka (Kansas) 14 ###
### 1 14 14 ###
### 7.1
Frankfort (Kentucky) 15 ###
### 1 15 34 ###
### 13.7
Baton Rouge (Louisiana) 16 ###
### 1 16 3 ###### 9.1 60
Augusta (Maine) 17 ###
### 1 17 41 ###
### 19.4
Annapolis (Maryland) 18 ###
### 1 18 16 ###
### 11.2
Boston (Massachusetts) 19 ###
### 1 19 8 ###### 11.5 26
50 4
Lansing (Michigan) 20 ###
### 1 20 1 ###### 8.0
St. Paul (Minnesota) 21 ###
### 1 21 22 ###
### 6.6
Jackson (Mississippi) 22 ###
### 1 22 9 ###### 11.0
Jefferson City (Missouri) 23 ###
### 1 23 38 ###
### 5.9 40
Helena (Montana) 24 ###
### 1 24 31 ###
### 7.4
Lincoln (Nebraska) 25 ###
### 1 25 40 ###
### 14.4
Carson City (Nevada) 26 ###
### 1 26 23 ###
### 12.5 30
Concord (New Hampshire) 27 ###
### 1 27 11 ###
### 6.5
Trenton (New Jersey) 28 ###
### 1 28 12 ###
### 5.6
Santa Fe (New Mexico) 29 ###
### 1 29 33 ###
### 5.5
Albany (New York) 30 ###
### 1 30 15 ###
### 7.5 20
Raleigh (North Carolina) 31 ###
### 1 31 46 ###
### 5.6
Bismarck (North Dakota) 32 ###
### 1 32 44 ###
### 7.7
Columbus (Ohio) 33 ###
### 1 33 18 ###
### 5.9 10
Oklahoma City (Oklahoma) 34 ###
### 1 34 7 ###### 1.9
Salem (Oregon) 35 ###
### 1 35 36 ###
### 4.8
Harrisburg (Pennsylvania) 36 ###
### 1 36 28 ###
### 3.7
Providence (Rhode Island) 37 ###
### 1 37 6 ###### 6.3 0
0 10 20
Columbia (South Carolina) 38 ###
### 1 38 37 ###
### 2.2
Pierre (South Dakota) 39 ###
### 1 39 19 ###
### 2.3
Nashville (Tennessee) 40 ###
### 1 40 30 ###
### 4.5
Austin (Texas) 41 ###
### 1 41 27 ###
### 4.2
Salt Lake City (Utah) 42 ###
### 1 42 17 ###
### 5.2
Montpelier (Vermont) 43 ###
### 1 43 43 ###
### 4.7
Richmond (Virginia) 44 ###
### 1 44 20 ###
### 21.0
Olympia (Washington) 45 ###
### 1 45 47 ###
### 8.4
Charleston (West Virginia) 46 ###
### 1 46 21 ###
### 9.8
Madison (Wisconsin) 47 ###
### 1 47 32 ###
### 14.9
Cheyenne (Wyoming) 48 ###
### 1 48 24 ###
### 19.0
45 5### 18.7
er your solution in J9:J55 by writing the label for the cities in the order in
ch you visit them. For example, if you write a 35 in Cell J9, this means
the second city you visit will be city 35 = Salem, Oregon. Note that the
begins and ends in the same city (45 = Olympia). You have to visit each
he remaining cities only once. Be sure to read the comments in cells C7,
M6, and I4.

Total Distance = 461

100
Total Distance = 461

90

45 32
80 24

35 21
39 43 17
70
10
47 27
20 30 19
13 6 37
60 48
42 25
36 28
33
5 11 12
26 14 187
50 4 23
15 46
44

40 40
29 34 31
3
38
2 9
30
22 1

20
41 16 8

10

0
0 10 20 30 40 50 60 70 80 90 100
43 17

27
0 19
6 37

0 100

You might also like