Left Turn Analysis Signalized Intersections Spreadsheet Tool (AASHTOWare Safety Updates).xlsx

	B	C	E	F	G	H
1	User Applied Filters		Guidance
2	User Applied Filters		Guidance
3	Years (5)	2019-2023	If the crash frequency, rate, and ePDO of the the intersection in question lies	Below the 75 percentile	Of all like intersections based on the applied filters that the selected intersection aligns, then	No further analysis on protection of the left turn movement is needed
4	Signal (Y/N)	Y
5	Intersection / Signal ID	101091 (5350)
6	City
7	County	Gwinnett	If the crash frequency, rate, or ePDO of the the intersection in question lies	Between median and 95 percentile		Further analysis should be conducted to consider a protected left turn
8	GDOT District	7		Between median and 95 percentile
9	MPO			Above 95 percentile		A protect left turn should be considered on at least one approach
10	Rural Urban	Urban		Above 95 percentile
11	Direction Of Movement		To complete this spreadsheet, fill out every table that has a yellow header/outline. This data can be collected from the Left Turn Analysis: Signalized Intersections dashboard.
12	Intersection Name	SR 124 @ SR 324
13
14
15
16	Table 1: All Left Turn Manner of Collision Combined		Recommendation Table 1: All Left Turn Manner of Collision Combined
17	K (Fatal)	0	No further analysis on protection of the left turn movement is needed
18	A (Severe Injury)	0
19	B (Minor Injury)	0
20	C (Complaint Injury)	0
21	O (Propert Damage Only)	2
22	Crash frequency	0.4
23	Crash Rate	0.034
24	ePDO rating	2
25	AADT	32,086
26	Crash Cost	$56,000	$56,000
27
28	Table 2: Driver Side Perpendicular Left Turn		Recommendation Table 2: Driver Side Perpendicular Left Turn
29	K (Fatal)	0	No further analysis on protection of the left turn movement is needed
30	A (Severe Injury)	0
31	B (Minor Injury)	0
32	C (Complaint Injury)	0
33	O (Propert Damage Only)	1
34	Crash frequency	0.2
35	Crash Rate	0.017
36	ePDO rating	1
37	AADT	32,086
38	Crash Cost	$28,000
39
40	Table 3: Left Left Opposing Turn		Recommendation Table 3: Left Left Opposing Turn
41	K (Fatal)	0	No further analysis on protection of the left turn movement is needed
42	A (Severe Injury)	0
43	B (Minor Injury)	0
44	C (Complaint Injury)	0
45	O (Propert Damage Only)	0
46	Crash frequency	0
47	Crash Rate	0
48	ePDO rating	0
49	AADT	32,086
50	Crash Cost	$0
51
52	Table 4: Passenger Side Perpendicular Left Turn		Recommendation Table 4: Passenger Side Perpendicular Left Turn
53	K (Fatal)	0	No further analysis on protection of the left turn movement is needed
54	A (Severe Injury)	0
55	B (Minor Injury)	0
56	C (Complaint Injury)	0
57	O (Propert Damage Only)	1
58	Crash frequency	0.2
59	Crash Rate	0.017
60	ePDO rating	1
61	AADT	32,086
62	Crash Cost	$28,000
63
64	Table 5: Left Right Turn		Recommendation Table 5: Left Right Turn
65	K (Fatal)	0	No further analysis on protection of the left turn movement is needed
66	A (Severe Injury)	0
67	B (Minor Injury)	0
68	C (Complaint Injury)	0
69	O (Propert Damage Only)	0
70	Crash frequency	0
71	Crash Rate	0
72	ePDO rating	0
73	AADT	32,086
74	Crash Cost	$0
75
76	Table 6: Opposing Left Turn		Recommendation Table 6: Opposing Left Turn
77	K (Fatal)	0	No further analysis on protection of the left turn movement is needed
78	A (Severe Injury)	0
79	B (Minor Injury)	0
80	C (Complaint Injury)	0
81	O (Propert Damage Only)	0
82	Crash frequency	0
83	Crash Rate	0
84	ePDO rating	0
85	AADT	32,086
86	Crash Cost	$0
87
88
89
90
91
92
93
94
95
96
97
98
99
100