ENGR 101 WVU Pollution Control Ranking of Cities Worksheet Please follow the instructions on the document below, if you have any questions please ask. Last

ENGR 101 WVU Pollution Control Ranking of Cities Worksheet Please follow the instructions on the document below, if you have any questions please ask. Last Name
Bogota
Paris
Sofia
Delhi
Nairobi
Denver
Lisbon
Lahore
Marseille
Warsaw
Houston
Brasilia
Lagos
Doha
Kingston
Montreal
Seoul
Melbourne
Vienna
Kinshasa
Madrid
Beijing
Nuremberg
Lima
Boston
Havana
Le Havre
Oslo
Riyadh
Dresden
Baku
Baghdad
Gayaquil
Manchester
Cleveland
Hanoi
Kyoto
Ankarra
Basel
Colombo
Pretoria
Guadalajara
Accra
Strasbourg
Wellington
Dubai
ID#
Q1
8941
7531
2805
6159
1790
9310
3677
9281
9797
5164
4103
8376
6513
2578
4198
7333
4278
1887
1760
9054
4495
3128
4252
8227
1462
5416
7485
3546
6358
4258
8140
6593
9837
4437
2810
5731
7212
4178
4999
4279
6804
8024
8724
8199
4108
7280
Q2
0
1
3
1
0
2
2
1
1
3
2
0
0
0
3
2
3
0
0
3
0
3
0
1
0
3
0
3
2
3
0
1
1
1
1
0
1
2
2
1
3
3
3
3
1
1
Q3
2
2
0
3
2
0
1
2
0
1
3
2
3
1
1
1
3
3
3
1
3
3
2
2
2
3
0
2
1
1
1
0
0
0
2
1
0
0
2
3
2
0
0
1
3
2
Q4
0
0
3
0
0
3
2
2
3
1
0
3
2
2
2
3
2
0
0
3
2
0
2
1
1
0
3
0
3
3
0
3
1
2
3
2
2
3
0
1
0
2
1
2
0
1
Q5
2
1
3
3
3
2
2
3
0
3
1
2
2
1
1
2
2
3
3
0
2
1
2
2
0
3
1
0
1
2
0
0
0
0
0
0
0
3
2
0
3
2
0
2
3
3
Q6
3
1
2
0
1
0
1
0
3
3
0
0
2
0
1
0
1
2
0
3
3
2
1
3
3
2
2
0
3
1
1
1
3
1
0
0
3
0
1
3
2
0
1
2
3
2
Q7
1
2
0
3
2
1
1
1
1
2
3
3
0
1
1
0
1
0
0
2
1
1
0
1
3
1
1
1
3
3
1
1
1
1
0
3
0
0
2
0
2
0
1
2
0
0
3
3
0
3
3
3
3
2
2
1
3
1
3
1
3
1
0
2
2
0
3
3
1
1
3
3
1
2
3
2
0
1
3
0
3
2
2
1
2
1
1
0
1
2
3
1
Dublin
Canberra
Dhaka
Zaria
Washington
Niagara
London
Stockholm
Porto
Nicosia
Denver
Santiago
Alberta
Cincinatti
San Franciso
La Paz
Belfast
Helsinki
Amsterdam
Brussels
Vigo
Hague
Milan
Tunis
Casablanca
Dortmund
Liverpool
Kiev
Rosario
Windhoek
Calgary
Shanghai
Manama
Hamburg
Lisbon
Kribatti
Christchurch
Khartoum
Rotterdam
Instabul
Los Angeles
New York
Buenos Aires
Barcelona
Jerusalem
Cairo
Johannesburg
8666
4644
9343
8309
5471
5475
6962
2576
2038
1651
4059
4305
2827
8375
7281
4006
1011
7384
8552
7410
6507
6854
1268
3613
9799
2903
7967
6564
2769
1449
4818
8714
5941
6155
8609
5513
6454
7247
6117
1578
5476
8173
1872
6038
5744
2343
6206
2
1
2
3
0
1
1
0
3
3
0
3
0
0
2
2
0
1
3
0
2
3
3
3
0
3
3
2
1
3
0
0
1
0
1
2
1
3
1
3
1
1
3
1
2
3
0
0
3
3
2
1
0
0
1
1
0
0
1
2
2
2
1
1
1
0
2
2
3
0
0
0
1
1
2
1
0
0
3
0
1
1
1
3
2
1
2
2
3
0
0
1
3
0
0
1
2
3
0
0
3
0
0
0
1
0
0
2
1
0
1
0
3
3
1
3
1
0
1
2
2
0
1
0
1
1
2
0
1
3
0
1
0
1
0
2
0
0
3
3
2
1
0
2
1
1
2
3
3
2
1
0
0
3
0
2
2
0
1
2
1
1
3
1
3
1
0
0
2
1
2
1
2
0
3
3
2
1
0
0
1
3
1
1
3
1
0
2
3
3
3
2
3
0
1
0
3
1
1
3
2
0
3
3
0
0
0
2
1
0
0
3
3
1
2
0
1
2
2
2
2
0
1
2
2
2
1
3
1
2
3
2
0
2
0
3
0
3
0
1
0
3
0
0
1
3
0
3
1
3
2
2
2
0
1
2
1
0
1
2
3
0
2
0
3
0
2
2
0
3
2
3
0
1
3
3
0
1
2
2
1
1
3
1
0
2
2
3
1
1
2
3
0
0
0
0
1
0
0
3
0
2
0
0
0
2
1
0
2
2
1
1
1
0
0
3
2
3
2
0
0
3
2
2
3
3
0
3
1
Brisbane
Jakarta
Moscow
Tokyo
Zagreb
Lyon
Algiers
4707
3330
2456
6585
7161
7975
9835
3
3
1
1
0
1
3
0
2
3
0
0
0
1
2
1
1
3
3
1
1
1
2
0
2
1
0
2
1
0
2
0
0
3
3
2
3
1
3
1
2
2
0
1
2
3
2
1
2
Q8
Q9
3
1
2
2
0
1
0
0
1
1
0
1
2
0
3
1
0
2
2
1
3
0
3
3
2
2
2
2
2
1
0
3
2
3
3
1
0
0
2
1
3
0
2
2
1
0
Q10
3
2
3
2
0
1
3
0
0
0
3
2
3
2
0
1
1
3
1
3
1
1
1
2
3
2
1
0
0
1
1
1
0
2
3
2
3
3
2
0
2
2
0
0
0
2
Q11
3
3
1
2
3
3
3
1
3
2
0
1
2
1
0
0
2
3
3
0
2
3
3
1
2
1
2
3
2
2
1
2
2
1
2
2
1
1
0
1
0
1
1
2
3
2
Q12
1
0
2
3
1
1
1
1
2
2
2
1
3
0
3
2
2
3
0
2
2
1
1
1
3
2
0
3
3
1
3
1
1
1
3
1
1
2
1
0
0
1
1
3
1
1
Q13
0
2
1
1
0
3
1
2
1
0
0
3
0
3
3
3
1
0
1
1
1
1
3
2
2
1
1
2
2
1
2
0
2
0
0
2
1
1
3
1
0
0
2
3
0
3
Q14
1
3
1
0
2
0
0
2
0
2
1
1
2
3
0
3
2
0
2
2
1
1
1
1
3
2
1
2
1
2
3
1
0
0
1
3
3
2
2
3
0
0
0
1
2
2
Q15
2
2
1
1
0
3
1
0
1
3
3
2
2
0
3
1
0
1
3
0
2
1
1
3
3
0
2
0
2
0
0
0
1
0
3
3
3
3
3
0
1
0
2
1
1
2
Q16
3
1
3
3
1
2
2
2
2
2
0
1
1
3
3
3
0
3
3
3
0
3
0
0
3
3
0
1
1
0
1
0
1
0
2
1
0
3
1
0
0
2
2
2
1
0
3
1
2
1
3
3
2
3
1
2
0
1
2
3
0
0
3
2
3
1
2
3
3
2
2
2
1
1
1
0
2
2
3
2
0
2
0
2
0
1
2
2
1
1
0
2
2
2
2
0
2
1
3
2
1
0
3
3
2
1
2
1
0
3
3
3
1
0
3
0
0
3
1
1
0
0
0
2
3
3
3
0
3
0
3
1
3
3
1
2
1
1
2
1
3
2
1
3
1
2
1
3
2
1
2
0
1
2
2
0
1
0
1
2
3
2
2
3
0
0
1
1
2
0
2
1
2
0
2
2
1
1
2
2
0
0
3
1
1
2
3
2
0
1
0
1
0
2
2
1
1
1
1
0
2
3
2
1
1
2
3
1
1
1
2
3
1
0
1
3
2
3
0
1
0
2
1
2
3
1
2
3
2
2
0
0
2
0
2
1
3
3
2
3
2
3
3
2
1
1
1
2
3
0
2
0
2
1
1
1
0
3
3
1
2
1
0
1
3
1
3
0
2
2
3
0
3
2
2
2
1
0
1
0
2
1
3
1
2
3
1
3
2
0
0
2
2
0
2
3
2
1
3
3
0
1
3
0
3
2
2
1
1
0
1
3
0
2
1
3
3
2
3
1
3
2
2
1
0
3
0
2
2
1
3
3
3
0
1
0
3
0
0
3
2
1
2
2
2
0
1
0
3
2
3
0
2
1
2
0
2
1
2
2
1
1
3
0
2
2
1
1
1
2
2
3
2
3
3
2
0
1
2
1
2
0
2
1
3
1
0
3
3
0
3
3
2
0
3
2
2
1
0
1
2
0
1
2
0
3
3
0
3
2
0
2
1
3
2
3
0
0
3
3
1
2
3
3
3
3
0
1
3
3
1
0
2
2
0
3
0
3
0
2
3
3
3
3
1
2
3
1
1
2
1
0
1
2
1
3
1
1
0
2
1
0
3
1
2
1
0
1
1
2
3
2
1
1
1
1
3
1
3
1
2
0
0
3
2
2
2
3
1
1
1
3
3
3
2
0
3
3
0
3
3
0
2
0
0
3
1
3
2
1
1
0
1
0
2
2
2
0
0
3
1
0
0
2
0
1
3
0
3
0
1
2
3
1
1
2
1
1
3
3
2
0
0
1
3
0
3
2
3
1
2
0
3
0
0
0
3
2
3
3
1
2
1
2
1
2
0
1
1
3
0
2
0
1
2
2
1
2
Q17
Q18
1
2
2
0
1
0
3
1
1
3
0
0
1
1
3
2
2
0
1
3
0
1
3
3
1
1
3
3
1
1
0
0
0
3
3
0
0
2
1
0
3
0
3
0
2
1
Q19
3
3
3
3
0
0
0
3
2
1
1
2
0
1
0
1
1
3
3
1
0
0
1
2
2
1
3
1
0
0
0
3
1
3
1
3
1
3
1
0
0
3
1
3
2
1
Q20
1
3
2
2
0
2
3
3
1
2
3
3
0
2
3
3
3
0
2
1
0
0
0
1
1
3
0
1
0
2
1
1
3
1
3
2
2
1
1
3
3
1
2
2
3
2
Q21
2
2
3
1
1
2
0
3
0
2
2
2
0
2
3
0
3
2
1
3
2
1
0
1
1
1
2
1
1
0
3
0
3
0
3
2
1
0
2
2
3
0
3
1
1
2
Q22
0
3
0
1
1
2
0
2
3
2
3
0
2
2
0
2
3
2
0
3
0
3
3
3
2
2
0
0
3
0
0
0
2
3
1
0
1
0
0
1
2
0
2
0
0
1
Q23
0
3
0
3
3
3
3
0
1
2
2
0
3
2
0
3
1
0
1
0
2
2
3
0
3
3
3
1
0
1
3
1
3
1
1
3
2
3
3
0
2
0
1
1
1
2
Q24
0
3
3
3
3
0
0
3
2
0
0
1
0
0
2
3
1
1
2
2
3
1
1
1
3
1
1
1
0
1
3
1
0
1
2
1
3
0
3
3
0
0
1
0
2
0
Q25
1
0
1
3
0
3
2
1
2
0
2
3
3
3
1
3
2
1
1
0
0
0
2
3
3
0
3
0
2
2
1
1
0
3
1
2
2
2
2
0
3
1
3
3
3
0
2
2
3
0
3
1
0
3
2
1
1
3
0
1
3
3
3
3
0
1
2
0
2
0
0
3
3
1
0
2
0
3
0
2
2
2
2
3
3
1
2
3
0
1
2
1
0
0
1
1
0
2
0
1
2
3
3
2
1
2
1
0
0
3
3
2
0
1
1
3
2
0
1
0
1
1
3
2
2
3
1
3
1
3
3
1
1
3
1
1
3
3
0
0
1
0
3
1
2
3
3
1
2
0
3
1
1
1
1
1
0
0
2
2
2
3
2
3
2
1
0
3
1
0
0
1
1
0
0
3
2
3
0
0
0
3
0
2
3
2
3
0
1
2
0
2
0
1
2
1
1
0
3
2
2
1
3
3
1
2
1
2
0
1
3
3
3
3
0
0
3
1
2
3
2
1
2
0
1
1
2
0
0
2
3
2
3
3
0
2
2
2
1
1
0
0
1
0
0
2
1
1
3
2
1
0
1
0
2
3
1
3
0
1
3
2
2
0
3
3
2
3
0
2
0
1
0
2
0
0
2
2
1
3
2
1
3
1
0
1
1
0
0
2
0
0
0
1
2
2
0
3
1
0
2
1
0
1
2
3
0
0
2
2
0
0
0
0
2
1
3
2
0
3
1
0
3
3
0
1
3
2
2
2
0
2
1
1
1
3
3
0
0
1
1
2
3
0
3
1
3
0
0
3
3
2
3
0
1
2
2
3
0
0
1
1
3
1
0
0
0
2
2
3
2
0
3
2
3
1
0
0
2
2
1
0
2
0
2
3
1
0
0
3
1
2
2
0
1
0
1
0
3
0
0
0
2
3
3
1
1
3
1
0
2
2
1
0
3
2
1
1
0
2
3
3
1
2
3
0
0
0
2
0
1
0
3
0
2
3
1
3
2
2
3
1
2
3
3
2
2
1
1
1
0
3
2
2
0
1
0
3
3
2
3
2
1
2
3
2
3
0
3
1
2
2
2
1
0
1
1
3
2
1
0
3
2
1
0
0
0
2
0
1
2
2
1
2
3
3
0
0
2
1
0
1
3
0
0
2
1
1
1
2
1
1
0
3
1
2
2
3
2
1
0
3
0
3
1
0
3
0
3
1
3
2
1
2
1
0
0
3
3
2
3
0
2
1
2
1
2
2
2
2
3
2
0
0
3
3
1
2
1
0
1
1
2
3
2
3
2
3
0
3
3
1
2
2
2
1
0
0
Q26
Q27
3
2
0
2
2
3
2
3
0
3
3
1
3
0
1
3
2
0
1
1
1
3
3
0
1
2
1
3
3
3
1
2
1
1
2
2
3
1
1
1
1
2
3
0
0
2
Q28
3
0
3
2
2
2
1
1
0
0
3
3
3
2
0
0
0
2
1
1
3
1
1
0
3
0
2
1
2
0
3
3
1
2
1
3
3
3
0
2
1
2
2
3
3
2
Q29
1
3
0
1
3
1
2
3
1
1
3
3
0
1
0
1
2
0
3
0
3
3
1
1
2
2
3
3
3
3
0
2
3
3
2
3
0
2
0
2
0
3
2
0
1
0
Q30
0
0
2
3
3
3
1
0
2
0
1
0
1
1
3
1
0
2
0
0
2
0
2
2
0
2
0
1
0
0
3
2
2
1
1
1
0
0
1
2
3
1
0
1
1
3
3
0
3
1
0
0
0
2
2
1
1
0
0
0
0
1
3
1
1
2
1
0
3
0
3
2
2
2
3
0
1
3
2
3
2
3
0
0
3
1
0
0
0
1
1
2
1
2
3
0
3
2
1
3
3
1
2
1
3
1
0
0
0
1
2
3
2
0
3
0
3
2
3
2
2
1
0
1
1
0
0
1
1
3
3
0
2
0
0
0
0
2
0
1
2
0
2
1
2
0
0
2
1
2
0
2
3
3
2
2
1
2
2
0
3
3
2
2
1
1
2
1
3
2
2
2
2
0
3
2
2
3
0
0
3
2
1
1
2
1
1
3
2
1
0
2
1
0
0
0
0
2
1
1
2
3
0
3
2
0
2
3
2
3
3
0
1
1
0
2
2
3
2
3
3
3
0
3
3
0
1
0
0
0
3
0
2
0
1
2
3
0
0
1
3
0
3
1
1
3
1
3
2
3
1
1
1
2
2
3
1
3
3
2
3
1
0
3
3
3
0
3
1
3
0
1
3
2
2
0
2
0
0
1
0
3
0
1
0
2
1
0
1
1
1
0
2
3
1
3
2
3
2
0
3
2
3
3
0
2
2
2
3
2
0
1
3
3
3
2
1
3
3
3
1
2
2
1
1
2
0
1
3
3
2
3
3
3
2
2
0
3
3
3
3
3
0
1
0
0
1
3
0
1
2
3
2
3
3
0
0
2
1
1
3
0
City Name
Marseille
Solna
Las Vegas
Paris
Ottawa
Quito
Asunscion
Luanda
Doha
Kingston
Montreal
Seoul
Melbourne
Vienna
Kinshasa
London
Stockholm
Porto
Nicosia
Denver
Santiago
Alberta
Cincinatti
San Franciso
La Paz
Belfast
Helsinki
Amsterdam
Brussels
Vigo
Hague
Milan
Tunis
Casablanca
Dortmund
Liverpool
Kiev
Rosario
Windhoek
Calgary
Shanghai
Manama
Hamburg
Lisbon
Kribatti
Christchurch
Khartoum
Tripoli
Salamanca
Tenerife
Naples
Copenhagen
Thessaloniki
Porto
Dortmund
Chaleroi
Arusha
Berlin
Newcastle
Edinburgh
Daegu
Amman
Dammam
Rio De Janeiro
Johannesburg
Brisbane
Jakarta
Moscow
Tokyo
Zagreb
Lyon
Algiers
Lusaka
St Petersburg
Kiev
City Name
Marseille
Solna
Las Vegas
Paris
Ottawa
Quito
Asunscion
Luanda
Doha
Kingston
Montreal
Seoul
Melbourne
Vienna
Kinshasa
London
Stockholm
Porto
Nicosia
Denver
Santiago
Alberta
Cincinatti
San Franciso
La Paz
Belfast
Helsinki
Amsterdam
Brussels
Vigo
Hague
Milan
Tunis
Casablanca
Dortmund
Liverpool
Kiev
Rosario
Windhoek
Calgary
Shanghai
Manama
Hamburg
Lisbon
Kribatti
Christchurch
Khartoum
Tripoli
Salamanca
Tenerife
Naples
Copenhagen
Thessaloniki
Porto
Dortmund
Chaleroi
Arusha
Berlin
Newcastle
Edinburgh
Daegu
Amman
Dammam
Rio De Janeiro
Johannesburg
Brisbane
Jakarta
Moscow
Tokyo
Zagreb
Lyon
Algiers
Lusaka
St Petersburg
Kiev
City Name
Marseille
Solna
Las Vegas
Paris
Ottawa
Quito
Asunscion
Luanda
Doha
Kingston
Montreal
Seoul
Melbourne
Vienna
Kinshasa
London
Stockholm
Porto
Nicosia
Denver
Santiago
Alberta
Cincinatti
San Franciso
La Paz
Belfast
Helsinki
Amsterdam
Brussels
Vigo
Hague
Milan
Tunis
Casablanca
Dortmund
Liverpool
Kiev
Rosario
Windhoek
Calgary
Shanghai
Manama
Hamburg
Lisbon
Kribatti
Christchurch
Khartoum
Tripoli
Salamanca
Tenerife
Naples
Copenhagen
Thessaloniki
Porto
Dortmund
Chaleroi
Arusha
Berlin
Newcastle
Edinburgh
Daegu
Amman
Dammam
Rio De Janeiro
Johannesburg
Brisbane
Jakarta
Moscow
Tokyo
Zagreb
Lyon
Algiers
Lusaka
St Petersburg
Kiev
Homework (20 points)
The attached excel document contains a sheet named REFERENCE showing a hypothetical
pollution control ranking of cities across the world based on a questionnaire of 50 questions ranging
from 0 – 3 marks.
Using the vlookup command and the following arguments:
=VLOOKUP (#, ##, ###, ####)
Arguments
•
# – The value to look for in the first column of a table (e,g A2)
•
## – The table from which to retrieve a value (Select all)
•
### – The column in the table from which to retrieve a value (e.g 2)
•
#### – FALSE
Display in a new sheet named:
(a) FIRST, all elements in Column B (1point)
(b) SECOND, all elements in Columns B, D, Q, I, K, U, W in the order written (7 points)
Hint: For ###, Use {……}
Drag the cursor across the top row until all columns are completed
Double click on the crosshair (or drag all the way down) in each column to pop up all
characters there-in
(c) THIRD, all elements in Columns A – L (12 points)
Hint: For ###, Use Columns( )
Drag the cursor across the top row until all columns are completed
Double click on the crosshair (or drag all the way down) in each column to pop up all
characters there-in
Note: #N/A might come up, its fine. (It simply implies it is not available)

Purchase answer to see full
attachment