over & under-rated cities

	A	B	C	D
1	Expectation	Reality	City name	Over/under
2	7	4	Austin	3
3	4	2	Cleveland	2
4	5	3	Miami	2
5	6	4	Boulder	2
6	9	7	San Francisco	2
7	3	2	Columbus	1
8	4	3	St. Louis	1
9	5	4	Baltimore	1
10	6	5	Denver	1
11	9	8	New York	1
12	4	3.2	San Diego	0.8
13	5	4.3	Victoria	0.7
14	4	3.4	Milwaukee	0.6
15	5	4.6	Saint Paul	0.4
16	3	2.6	San Jose	0.4
17	4	3.6	Dallas	0.4
18	7	6.7	Quebec	0.3
19	3	2.8	Indianapolis	0.2
20	1	1	Jacksonville	0
21	3	3	Louisville	0
22	4	4	Cincinnati	0
23	5	5	Atlanta	0
24	7	7	Pittsburgh	0
25	8	8	Toronto	0
26	9	9	Montreal	0
27	3	3.2	Charlotte	-0.2
28	4	4.3	Detroit	-0.3
29	7	7.3	Seattle	-0.3
30	3	3.4	Durham	-0.4
31	7	7.6	New Orleans	-0.6
32	0.7	1.3	Las Vegas	-0.6
33	1	1.6	Orlando	-0.6
34	2	2.6	Houston	-0.6
35	3	3.6	Oakland	-0.6
36	2	2.8	Albany	-0.8
37	1	2	Tampa	-1
38	2	3	Greensboro	-1
39	3	4	Norfolk	-1
40	5	6	Calgary	-1
41	6	7	Portland	-1
42	7	8	Boston	-1
43	8	9	Chicago	-1
44	1	2.3	Phoenix	-1.3
45	2	3.3	Raleigh	-1.3
46	3	4.3	Nashville	-1.3
47	5	6.3	Los Angeles	-1.3
48	7	8.3	Washington	-1.3
49	3	4.6	Buffalo	-1.6
50	4	5.6	Richmond	-1.6
51	7	8.6	Vancouver	-1.6
52	5	6.7	Providence	-1.7
53	2	4	Newark	-2
54	4	6	Ottawa	-2
55	5	7	Asheville	-2
56	5	7.3	Minneapolis	-2.3
57	4	7	Madison	-3
58	6	9	Philadelphia	-3
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