Excel Spreadsheet for TMC data.xlsm

XLSM spreadsheet 234 KB Posted Jun 1, 2026

Attached to: TRAFFIC COUNT COLLECTION SERVICES
Solicitation number: 5400029736
Issued by: Richland County, South Carolina

About this file

Written by GovTribe AI · Jun 1, 2026

This Excel spreadsheet is a traffic data collection template developed by the South Carolina Department of Transportation for District 1. The tool is designed for analyzing traffic counts at intersections to evaluate signal warrant requirements, including vehicular volume, peak hour analysis, pedestrian activity, and crash experience data. The spreadsheet accommodates various data input methods, including manual entry, Jamar TDC-12 counter data, and TurnCount app outputs, with separate worksheets for cars, trucks, buses, and pedestrian counts. Users input intersection details such as location, date, road classification, speed limits, number of lanes, weather conditions, and directional traffic movements in 15-minute intervals. The template automatically calculates hourly volumes, peak hour identification (AM, PM, and mid-day periods), and peak hour factors. The system supports up to 12 hours of continuous count data and includes functionality to hide unused rows and generate formatted reports.

The spreadsheet includes four analysis pages that assess compliance with traffic signal warrants established for evaluating whether signalization is warranted at an intersection. Page 1 contains raw data entry and summary calculations; Page 2 displays total and peak hour volume diagrams; Page 3 analyzes signal warrant compliance across seven warrant criteria, including minimum vehicular volume, continuous traffic interruption, peak hour conditions, pedestrian volume, and crash experience; Page 4 provides multi-way stop warrant analysis for intersections without signals. The template references standardized threshold values for major and minor street volumes across different lane configurations and includes warrant charts calculating minimum volumes based on parabolic equations. Version 2015.11 represents the current production version, with previous iterations dating to 2010 and incorporating fixes for warrant calculations, data entry functionality, and PDF export capabilities. The spreadsheet is configured for District 1 operations with data storage on the R: drive organized by county subdirectories.

View the file

Other files

File	Type	Posted
Amendment 1.pdf	PDF	Jul 27, 2026
Amendment 2.pdf	PDF	Jul 27, 2026
Solicitation.pdf	PDF	Jun 8, 2026
Pricing Proposal.xlsx	XLSX spreadsheet	Jun 1, 2026
Traffic Count Survey Worksheet.doc	DOC document	Jun 1, 2026
ARTIFICAL INTELLIGENCE USE.docx	DOCX document	Jun 1, 2026

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Setup_Data

Signal Warrants 2015.xlsm Version 2015.11
	USE ALL CAPS!
Department:	DISTRICT 1
Drive letter that data will be stored:	R:
Directory that data will be stored:	R:\COUNTS\DISTRICT 1
Use County name as Subdirectory? (Y/N):	Y
Show Volume Summary as:	From the South	From the South
	R:\COUNTS\DISTRICT 1\Enter Here	Northbound

If you receive an error message after opening this file,
or if you move the location of your saved counts, follow these
steps to create a new Setup ("ini") file
1. Enter the Department name (e.g., "District 1") in cell C3
2. Enter the Directory that you store your counts to (e.g., "F:\Traffic\Warrant") in cell C5
3. If you store counts in subdirectories by County (most of you do), enter a "Y" in C6, otherwise enter a "N"
4. Choose the way your direction description will be displayed. The choices are "From the South" or "Northbound"
5. Click to store this information to a new file
Summary of version changes
V 2010.04	Fixed bug which would not previouly show OTHER HOUR VOLUME of 16:00-17:00 on page 2. This was due to the way Excel rounds repeating decimal values
	Fixed page 3 and 5 so that the text "met" or "not met" uses the same rounded values as the houlry warrants use. Previously there was a slight change the warrant would say "not met" while the hourly warrants would all indicate 100% or greater.
V 2010.13	Changed the following to accommodate future uploading of counts to ITMS:
	1. County, Type of Control, and Name are dropdown lists.
	2. Major and Minor Routes will add a message indicating a non-state maintained route unless the value starts with "I-", "US", "SC", or "S-".
	Fixed Average Minor Street % of Warrant (cell B29) on page 5
V 2010.15	Fixed Major and Minor routes to allow for 1 digit secondary routes
	Changed the "Save to County Directory" button. It now also saved a 2-page PDF file
V 2010.15.2	Added room for additional offices
V 2010.20	Fixed manual entry macro by allowing users to enter ped volumns in columns E, J, O, and T on Page 1
V 2010.21	Added list of consultants from Teresa mozingo. Moved "Cars", "Trucks", … worksheets to the end since they are likely no longer being used.
V 2010.22	Require a valid date in the primary date field on page 1, but allow optional date fields in the two rows below
V 2010.25	Added date of count to the default file name
V 2010.26	Fixed misspelling of Berkeley
V 2010.27	Fixed Hide Rows button on page 1. Error was caused by a Microsoft update
V 2015.05	Added ability to enter 12 hours of count data
	8 (and 4) hour warrants are “met” if

1. If less than 8 hours of data exists, then every hour must meet the warrant in order to “is met” to display.

2. If more than 8 hours of data exists, then any 8 hours of the data can satisfy the warranty analysis

The pedestrian warrant is no longer hidden if the user selects manual input.

Page 1 will automatically enter a 0 start time if all 15 minutes of data is 0. This should mean you do not have to enter a 0 start time for the time period beyond your count.

V 2015.06	Fixed Higher Volume Side Street Peek hour portion of warrant 3. Involved cells AD67:AD69 on page 1
V 2015.10	First production version. Modifed the print procedure to print portriat when <=8 hours of data. Fixed problem with hours 9-12 displaying improperly on page 4
V 2015.11	Modified import pages to accept TurnCount data.

here

Instructions

	This file is setup to receive data electronically. To allow Manual
	input, press this button:
1	Highlight data in Petra Lite.
2	Goto Edit -> Copy
3a	If you have only one group for cars, busses, and trucks, then goto C11 in Worksheet "Cars"
3b	If you have separate groups, then goto C11 in the appropriate Worksheet
3c	If you are using a TDC-12 counter, use the 4 sheets named "Cars_From_TDC12", etc….
3d	If you are using the TURNCOUNT app, copy the data from the HTML file. Copy this data into the TDC12 worksheets
4	Goto Edit -> Paste
5	If you are using separate groups, repeat steps 1-4 for your remaining groups.
6	If you have another time period to enter, repeat steps 1 through 5, expect paste the data in the first row beyond your previous count. You will also need to change the time on Page 1 using MILITARY TIME (e.g., 14:00)

7 Goto Worksheet "Page1" and check to be sure a 0 has been entered for the times beyond your count data. For example, if you count is from 08:00 - 16:00, then the first row beyond 16:00 should have a 0 start time. If this is not the case, then enter a 0 (zero) for the first start time beyone your count ending time.

8	Press the Hide Rows button to hide any unneeded rows
9	Enter remaining data shown in blue on Page 1, 2 and 3. Note that you can edit the Title and starting hour for the bottom right count diagram on page 2.

10	Use the Save to Count Directory button on page 1 to save the file.
11	Use the Print Sheets 1-3 button on page 1 to print. Sheet 3 will be printed in landscape mode if more than 8 hours of data exists.
12	Use the Print Sheet 4 button on page 4 to print multi-way stop warrant analysis. Sheet will be printed in landscape mode if more than 8 hours of data exists.
	Note: When using separate groups for cars, trucks and busses, Rows 72 and 73 on Page1 will show you a summary of the total busses and trucks for each turning maneuver. These numbers are already included in the 15 minute count data above and are shown for information purposes only.

1 Go to Worksheet "Page1" and enter all data in blue. Change the first start time if needed. The remaining start times will automatically popuplate as you enter traffic and/or pedestrian data.

2 After entering all data on "Page1", check to be sure a 0 has been entered for the times beyond your count data. For example, if your count is from 08:00 - 16:00, then the first row beyond 16:00 should have a 0 start time. If this is not the case, then enter a 0 (zero) for the first start time beyond your count ending time.

3	Press the Hide Rows button to hide any unneeded rows
4	Enter remaining data shown in blue on Page 2 and 3. Note that you can edit the Title and starting hour for the bottom right count diagram on page 2.
	and starting hour for the bottom right count diagram on page 2.
5	Note that if you counted Pedestrians, you'll need to unhide columns E, J, O, & T on Page 1 to be able to enter the PED volumns. You should then rehide these columns before printing

6	Use the Save to Count Directory button on page 1 to save the file.
7	Use the Print Sheets 1-3 button on page 1 to print. Sheet 3 will be printed in landscape mode if more than 8 hours of data exists.
8	Use the Print Sheet 4 button on page 4 to print multi-way stop warrant analysis. Sheet will be printed in landscape mode if more than 8 hours of data exists.
	Note: Rows 72 and 73 on Page1 can be used to show a percent summary of the total busses and trucks for each turning maneuver. However, the volume of busses and trucks must be entered in the appropriate 15 minute count data above. Rows 72 and 73 are for information purposes only, and will not be used in any warrant analysis.

Manual Input

15Min Key # 4 3 2 1 8 7 6 5 12 11 10 9 16 15 14 13

0:30

	Start Time
	for Info. only
0
1	7:00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
2		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
3		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
4		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
5		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
6		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
7		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
8		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
9		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
10		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
11		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
12		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
13		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
14		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
15		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
16		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
17		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
18		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
19		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
20		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
21		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
22		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
24		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
25		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
26		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
27		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
28		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
29		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
30		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
31		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
32		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
33		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
34		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
35		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
36		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
37		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
38		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
39		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
40		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
41		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
42		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
43		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
44		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
45		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
46		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
47		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
48		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Cars_From_TDC12 Key # 4 3 2 8 7 6 12 11 10 16 15 14

0:30

	Start Time
	for Info. only	From the North			From the East			From the South			From the West
0		L	S	R	L	S	R	L	S	R	L	S	R
0	7:00	0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0	0	0

Start your paste in cell C11 when using Jamar TDC12 or newer count boards.

Start your paste in cell B11 when using the TurnCount app.

Trucks_From_TDC12 Key # 4 3 2 8 7 6 12 11 10 16 15 14

0:30

	Start Time
	for Info. only	From the North			From the East			From the South			From the West
0		L	S	R	L	S	R	L	S	R	L	S	R
0	7:00	0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0	0	0

Busses_From_TDC12 Key # 4 3 2 8 7 6 12 11 10 16 15 14

0:30

	Start Time
	for Info. only	From the North			From the East			From the South			From the West
0		L	S	R	L	S	R	L	S	R	L	S	R
0	7:00	0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0	0	0

Peds_From_TDC12 Key # 4 3 2 8 7 6 12 11 10 16 15 14

0:30

	Start Time
	for Info. only	From the North			From the East			From the South			From the West
0		L	S	R	L	S	R	L	S	R	L	S	R
0	7:00	0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
0		0	0	0	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0	0	0

This does Not work with the Turncount app at this time. Please send Todd a sample file if you need this ability.

Page1

SOUTH CAROLINA DEPARTMENT OF TRANSPORTATION

DISTRICT 1

TRAFFIC ENGINEERING

Direction of Minor Street

County:

Enter Here

City:

Enter Here

Date:

1/1/08

E-W

File Name Formatted Date:

2008-01-01

N-S

Major Rt:

Enter Here

Minor Rt:

Enter Here

999

* Not on State System

Day of Week:

Enter Here

Weather:

Enter Here

Office:

Enter Here

Initials

Type of Control: Stop Sign Speed Limit (major st) 35

			Direction of Minor Street:							E-W								Intersection ADT -					0		(Calc)	0:00
																										1:00
			Number of Lanes (major st)*							1								Number of Lanes (minor st)*						1		0:15
																										12:00
																									* Each Direction	am
	INTERSECTION VOLUME SUMMARY																									Enter Here @ Enter Here 2008-01-01.xlsm
					From N	Enter Here				From S					From E	Enter Here				From W
					From N Enter Here					From S Enter Here					From E Enter Here					From W Enter Here				Total	Total	Major St.	Minor St.	Minor St	Major St.	Minor St.	used to determine peak hours						Major St. Volumes	Warrant 9 Max. Major St. Volumes				Cooresponding Min. S.S. Volumes
				PEDS	LT	STR	RT	TOT	PEDS	LT	STR	RT	TOT	PEDS	LT	STR	RT	TOT	PEDS	LT	STR	RT	TOT	Vol	Peds	Hourly Volumes	Hourly Volumes	Higher Volume Approach	Ped. Volumes	Ped. Volumes	Overall	AM	PM	Mid	User		Used in Warrants 9		11	21	22	11	21	22
1	7:00	-	7:15	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	22	0	100%	1150	1350	1300	80	80	115
2	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	23		70%	800	950	900	60	60	80
3	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	24
4	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	25			Max. Volume to Use			Min. S.S. Volume to Use for Warr 9
5	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	26	0		for Warr. #11:		1150			80
6	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	27		Warrant 11 Max. Major St. Volumes				Cooresponding Min. S.S. Volumes
7	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	28			11	21	22	11	21	22
8	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	29		100%	1500	1750	1700	100	100	150
9	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	30	0	70%	1050	1250	1200	75	75	100
10	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	31
11	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	32			Max. Volume to Use			Min. S.S. Volume to Use for Warr 11
12	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	33			for Warr. #11:		1500			100
13	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	34	0
14	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	35		PEAK HOUR VOLUMES
15	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	36			from n			from s			from e			from w
16	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	37		LT	STR	RT	LT	STR	RT	LT	STR	RT	LT	STR	RT
17	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	38	0
18	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	39
19	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	40
20	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	41
21	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	42	0
22	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	43
23	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	44
24	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	45
25	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	46	0
26	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	47
27	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	48
28	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	49
29	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	50	0
30	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	51
31	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	52
32	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	53
33	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	54	0
34	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	55
35	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	56
36	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	57
37	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	58	0
38	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	59
39	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	60
40	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	61
41	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	62	0
42	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	63
43	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	64
44	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0			0	0	0	0	0	65
45	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	66	0
46	0:00	-		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas

																					0
47	0:00	-	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas 0 Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas																						0
	48	0:00	-	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas 0 Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas		Overall	AM	PM	Mid	User	69															0
	TOTAL			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	22	0	0	0	0	0	22

andersonrt: andersonrt:

OVERALL B22 D25 0

andersonrt: anderson The next 12 columns of row 70 contain the turning movement values of the overall peak hour 0 0 0 0 0 0 0 0 0 0 0 0.25

Trucks 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 82 andersonrt: andersonrt:

AM	AI79	AI79
		School Buses	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0%	Higher Volume Approach Side Street Peak Hour:	7:00 -	82

andersonrt: andersonrt:

PM	AI79	AI79	0	0	0	0
							Higher Volume Approach Side Street Peak Hour Volume:	0	AM Cutoff Times

andersonrt: andersonrt:

These Times are the cutoff times used to determine the AM, PM, Mid-Day and User Selected Peak Hours for the diagrams andersonrt: andersonrt:

OVERALL

andersonrt: andersonrt:

andersonrt: anderson The next 12 columns of row 70 contain the turning movement values of the overall peak hour andersonrt: andersonrt:

PM 0:00 10:45 82

andersonrt: andersonrt:

MID-DAY	AI79	AI79	Overall Mainline Peak Hour Volume:	0
					Corresponding Total Mainline Volume:	0	PM Cutoff Times:	14:15	23:45	82

andersonrt: andersonrt:

USER SELECTED PEAK HOUR	AI79	AI79	Overall Higher Side Street Volume:	0
					Mid-Day Cutoff Times:	11:00	14:00
					User Selected Hour:	7:00	8:00	Overall Peak Hour:	FROM 7:00 TO	0

andersonrt: andersonrt:

Amount to reduce the right turns.

andersonrt: andersonrt:

Amount to reduce the right turns.

andersonrt: andersonrt:

Amount to reduce the right turns.

andersonrt: andersonrt:

Amount to reduce the right turns.

AM Peak Hour:

FROM 0:00 TO 0:00

No Peak Hour Found:

0:00

PM Peak Hour:

FROM 0:00 TO 0:00

Mid-Day Peak Hour:

FROM 0:00 TO 0:00

andersonrt: anderson

The next 12 columns of row 70 contain the turning movement values of the AM peak hour	0	0	0	0	0	0	0	0	0	0	0
												0

andersonrt: anderson

The next 12 columns of row 70 contain the turning movement values of the PM peak hour	0	0	0	0	0	0	0	0	0	0	0
												Peak Hour	PEAK HOUR 15 MIN. INTERVALS	PHF	0

andersonrt: anderson The next 12 columns of row 70 contain the turning movement values of the Mid-Day peak hour andersonrt: andersonrt:

Amount to reduce the right turns.

0	0	0	0	0	0	0	0	0	0	0
											Overall	0	0	0	0	ERROR:#DIV/0!	0

andersonrt: anderson The next 12 columns of row 70 contain the turning movement values of the User Selected peak hour Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas

Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas

Anderson, Todd: Anderson, Todd:

These formulas are different than the previous forumulas andersonrt: andersonrt:

Amount to reduce the right turns.

0	0	0	0	0	0	0	0	0	0	0
											AM	0	0	0	0	ERROR:#DIV/0!
											PM	0	0	0	0	ERROR:#DIV/0!
											MID	0	0	0	0	ERROR:#DIV/0!
											USER	0	0	0	0	ERROR:#DIV/0!

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Print Sheets 1-3 Save to Count Directory Hide Rows

Page2

TOTAL AND PEAK HOUR VOLUME DIAGRAMS
Enter Here AT Enter Here	Date:	1/1/08

0.3 HOUR TOTAL VOLUME				OVERALL PEAK HOUR VOLUME
FROM 7:00 TO 7:15				FROM 7:00 TO
	0	0	0		0	0	0

0 0 0 0

0 0 0 0 0 0

0 0 0 0

0 0 0 0 0 0 PHF:

AM PEAK HOUR VOLUME (0:00-10:45)

PM PEAK HOUR VOLUME (14:15-23:45)

AM PEAK HOUR VOLUME (0:00-10:45)

FROM 0:00 TO 0:00

0 0 0 0

0 0 0 0 0 0

0 0 0 0

0 0 0 PHF: 0 0 0 PHF:

MID-DAY PEAK HOUR VOLUME (11:00-14:00)				OTHER HOUR VOLUME
FROM 0:00 TO 0:00					FROM	7:00	TO	8:00	1:00
	0	0	0			0	0	0

0 0 0 0

0 0 0 0 0 0

0 0 0 0

0 0 0 PHF: 0 0 0 PHF:

Page3

SIGNAL WARRANT ANALYSIS					Minor Street		Major Street	Major St. Peds	Minor St. Peds
Enter Here AT Enter Here			Date:	1/1/08	LT	TOT	TOT
	Minor Street Volume, percent of total =	ERROR:#DIV/0!			0	0	0	0	0
	Percent of Left Turns from Minor Street =	0.0%			RT
	Percent of Right Turns from Minor Street =	0.0%			0
	Percent of Minor Street Right Turns to Remove from Warrant Analysis =			0%
	WARRANT BASIS =	100%

Warrant No. 1 - Vehicular Volume is not met								is not met
	Condition A - Minimum Vehicular Volume is not met
	Average Major Street % of Warrant			Average Minor Street % of Warrant
	0.0	500	0%	0.0	150	0%
	0						0	is not met
	Hourly percent of warrant
	7:00 -						1
Major St.	0%
Minor St.	0%
	Condition B - Interruption to Continuous Traffic is not met
	Average Major Street % of Warrant			Average Minor Street % of Warrant
	0.0	750	0%	0.0	75	0%
	0						0	is not met
	Hourly percent of warrant
	7:00 -						1
Major St.	0%
Minor St.	0%
									This chart is used to determine the 80 % warrant for Condition A & B for Warrant 1
	80% Combination of Conditions A & B is not met								0	1	1	1	1	1	1	1	1	1	1	1	11
									0	1	1	1	1	1	1	1	1	1	1	1	11
Warrant No. 2 - Four Hour Vehicular Volume Is not applicable																					22	is not met
	0						0	Is not applicable
	Hourly percent of warrant																					=IF(AB30>0,"is met",IF(AB30>-100,"is not met","is not applicable"))
	7:00 -						1
Minor St.	0%

Warrant No. 3 - Peak Hour is not met					is not met
		Percent of warrant		Percent of warrant
	Overall Peak Hour:	7:00 -	Higher Volume Side Street Peak Hour:	7:00 -
	Minor St.	0%	Minor St.	0%

Warrant No. 4 - Pedestrian Volume. Pedestrian volume shown are minumum volumes assuming heavy major street traffic. If these volumes are met, warrant 4 requires further engineering analysis							is not met				12
											12
Minimum 4 hour ped. volume crossing major street					Minimum peak hour ped. volume crossing major street			80% WARRANT CHART			12
	107					133		0	NONE
	-100						-100	1	1
	Number of pedestrians crossing major street							3	2
	7:00 -							4	1 & 2
Major St.	0							5	3		# lanes on mainline	# lanes on side street
								6	1 & 3		1	1
								8	2 & 3
Warrant No. 7 - Crash Experience (Requires 3 criteria analysis by engineering)								9	1, 2, & 3
	Total Number:	0	From:	1/1/05	to	1/1/08		4 hour warrant chart		Y = AX^2 - BX + C
		Accident Rate:	ERROR:#DIV/0!	per million entering vehicles				Where Y = Higher Volume Minor Street volume
	Types of Accidents	No.	Avg.	3.0	No.	Avg.
	Right Angle	0	0.0	Rear End	0	0.0		X = Major Street Volume (Both Approaches)
	Lost Control	0	0.0	Side Swipe	0	0.0		# lanes:	11
	Left Turn	0	0.0	Other	0	0.0			# Lanes (Major) / # Lanes (Minor)
								Constants (100%)	11	21	22
								A	0.000240418	0.000267045	0.000307299
								B	0.684401	0.785614	0.976751
								C	542.699	661.8	863.402

Constants to use (from above)
A	0.000240418
B	0.684401
C	542.699
Peak Hour Warrant Chart		Y = AX^2 - BX + C
Where Y = Higher Volume Minor Street volume

X = Major Street Volume (Both Approaches)
# lanes:	11
	# Lanes (Major) / # Lanes (Minor)
Constants	11	21	22
A	0.000235227	0.000181061	0.000211364
B	0.797674	0.74474	0.905106
C	766.114	847.764	1070.21

Constants to use (from above)
A	0.000235227
B	0.797674
C	766.114

Page4

MULTIWAY STOP WARRANT ANALYSIS					Minor Street		Major Street	Major St. Peds	Minor St. Peds
Enter Here AT Enter Here			Date:	1/1/08	LT	TOT	TOT
	Minor Street Volume, percent of total =	ERROR:#DIV/0!			0	0	0	0	0
	Percent of Left Turns from Minor Street =	ERROR:#DIV/0!			RT
	Percent of Right Turns from Minor Street =	ERROR:#DIV/0!			0
	WARRANT BASIS =	100%

Warrant B - Crash Experience (Requires engineering analysis)

	Total Number:	0	From:	1/1/05	to	1/1/08
		Accident Rate:	ERROR:#DIV/0!	per million entering vehicles
	Types of Accidents	No.	Avg.	3.0	No.	Avg.
	Right Angle	0	0.0	Rear End	0	0.0
	Lost Control	0	0.0	Side Swipe	0	0.0
	Left Turn	0	0.0	Other	0	0.0
Warrant C - Vehicular Volume is not met								is not met
	Condition C.1 - Major Street Minimum Vehicular Volume is not met
	Average Major Street % of Warrant
	0.0	300	0%
	0						0	is not met
	Hourly percent of warrant
	7:00 -						1
Major St.	0%

	Condition C.2 - Minor Street Minimum Total Volume is not met
	Average Minor Street % of Warrant
	0.0	200	0%
	0			0	is not met
	Hourly percent of warrant
	7:00 -			1
Minor St.	0%

			This chart is used to determine the 80 % warrant for Condition A & B for Warrant 1
80% Combination of Conditions C.1 & C.2 is not met			0	1	1	1	1	1	1	1	1	1	1	1	11
			0	1	1	1	1	1	1	1	1	1	1	1	11
															22	is not met
	0	is not met
																=IF(AB38>0,"is met",IF(AB38>-100,"is not met","is not applicable"))

is not met

is not met				12
				12
	80% WARRANT CHART			12
	0	NONE
0	1	1
	3	2
	4	1 & 2
	5	3		# lanes on mainline	# lanes on side street
	6	1 & 3		1	1
	8	2 & 3
	9	1, 2, & 3
	4 hour warrant chart		Y = AX^2 - BX + C
	Where Y = Higher Volume Minor Street volume

X = Major Street Volume (Both Approaches)
# lanes:	11
	# Lanes (Major) / # Lanes (Minor)
Constants (100%)	11	21	22
A	0.000240418	0.000267045	0.000307299
B	0.684401	0.785614	0.976751
C	542.699	661.8	863.402

Constants to use (from above)
A	0.000240418
B	0.684401
C	542.699

Peak Hour Warrant Chart	Y = AX^2 - BX + C
Where Y = Higher Volume Minor Street volume

X = Major Street Volume (Both Approaches)
# lanes:	11
	# Lanes (Major) / # Lanes (Minor)
Constants	11	21	22
A	0.000235227	0.000181061	0.000211364
B	0.797674	0.74474	0.905106
C	766.114	847.764	1070.21

Constants to use (from above)
A	0.000235227
B	0.797674
C	766.114

Print Sheet 4

Cars Key # 4 3 2 1 8 7 6 5 12 11 10 9 16 15 14 13

0:30

	Start Time
	for Info. only
0
0	7:00	0

Anderson, Todd: Anderson, Todd:

Start paste here	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
			0	0

Trucks Key # 4 3 2 1 8 7 6 5 12 11 10 9 16 15 14 13

0:30

	Start Time
	for Info. only
0
0	7:00	0

Anderson, Todd: Anderson, Todd:

Start paste here	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
			0	0

Busses Key # 4 3 2 1 8 7 6 5 12 11 10 9 16 15 14 13

0:30

	Start Time
	for Info. only
0
0	7:00	0

Anderson, Todd: Anderson, Todd:

Start paste here	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
			0	0

Heavy_Trucks Key # 4 3 2 1 8 7 6 5 12 11 10 9 16 15 14 13

0:30

	Start Time
	for Info. only
0
0	7:00	0

Anderson, Todd: Anderson, Todd:

Start paste here	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
	0		0	0	0
			0	0

Codes

Type of Control	COUNTY		ROUTE TYPE		ROUTE AUXILLARY		NAMES
Stop Sign	Abbeville	01	I-	01	Alternate	02	District 1
Signal	Aiken	02	L-	09	Business	07	District 2
Flasher	Allendale	03	R-	05	Business 1	48	District 3
Yield Sign	Anderson	04	RS	06	Bypass	08	District 4
Other	Bamberg	05	S-	07	Connection	06	District 5
	Barnwell	06	SC	04	Mainline	00	District 6
	Beaufort	07	US	02	Spur	05	District 7
	Berkeley	08					All Traffic Data Services
	Calhoun	09					Construction Group
	Charleston	10					Consulting Transportation
	Cherokee	11					Dennis Corporation
	Chester	12					Feemster, P.C.
	Chesterfield	13					Geo-Systems Design
	Clarendon	14					J. Davenport Engineering
	Colleton	15					Palmetto Traffic Data
	Darlington	16					Quality Counts
	Dillon	17					Quality Traffic Data
	Dorchester	18					Short Counts
	Edgefield	19					Southern Construction
	Fairfield	20					W. Roebuck
	Florence	21					Greenville County
	Georgetown	22
	Greenville	23
	Greenwood	24
	Hampton	25
	Horry	26
	Jasper	27
	Kershaw	28
	Lancaster	29
	Laurens	30
	Lee	31
	Lexington	32
	McCormick	33
	Marion	34
	Marlboro	35
	Newberry	36
	Oconee	37
	Orangeburg	38
	Pickens	39
	Richland	40
	Saluda	41
	Spartanburg	42
	Sumter	43
	Union	44
	Williamsburg	45
	York	46

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Jun 1, 2026.