Supplementary_Report Requirements Document.xlsx

	A	B	C	E	F	G	H
1	City	State	ZIP Code	SeverityList	WeatherList	RoadList	TimeOfDayList
2	Birmingham	AL	35203	1	Clear	Dry	Morning
3	Anchorage	AK	99501	2	Rain	Wet	Afternoon
4	Phoenix	AZ	85004	3	Snow	Icy	Evening
5	Little Rock	AR	72201	4	Fog	Slushy	Night
6	Los Angeles	CA	90012		Thunderstorm
7	Denver	CO	80202
8	Hartford	CT	06103
9	Wilmington	DE	19801
10	Miami	FL	33130
11	Atlanta	GA	30303
12	Honolulu	HI	96813
13	Boise	ID	83702
14	Chicago	IL	60604
15	Indianapolis	IN	46204
16	Des Moines	IA	50309
17	Wichita	KS	67202
18	Louisville	KY	40202
19	New Orleans	LA	70112
20	Portland	ME	04101
21	Baltimore	MD	21202
22	Boston	MA	02108
23	Detroit	MI	48226
24	Minneapolis	MN	55415
25	Jackson	MS	39201
26	Kansas City	MO	64106
27	Billings	MT	59101
28	Omaha	NE	68102
29	Las Vegas	NV	89101
30	Manchester	NH	03101
31	Newark	NJ	07102
32	Albuquerque	NM	87102
33	New York	NY	10007
34	Charlotte	NC	28202
35	Fargo	ND	58102
36	Columbus	OH	43215
37	Oklahoma City	OK	73102
38	Portland	OR	97204
39	Philadelphia	PA	19107
40	Providence	RI	02903
41	Charleston	SC	29401
42	Sioux Falls	SD	57104
43	Nashville	TN	37219
44	Houston	TX	77002
45	Salt Lake City	UT	84111
46	Burlington	VT	05401
47	Richmond	VA	23219
48	Seattle	WA	98104
49	Charleston	WV	25301
50	Milwaukee	WI	53202
51	Cheyenne	WY	82001
52
53
54
55
56
57
58
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