Skip to main content

Guide with free Excel template

How to do a traffic count: format, peak hour factor and Excel template

What to count, how to lay out the data, how to find the peak hour and its factor, and which counting methods exist.

Highway seen from above with every vehicle detected and numbered by YOAO

A traffic count records the vehicles that pass a location during a period, split by class and by movement. At an intersection it is called a turning movement count, and it is the starting point of almost every traffic study: without those numbers you cannot time a signal, assess the impact of a new development or justify changing a street.

At the end of this guide you can download an Excel template that does the math for you.

What a traffic count records

Three things define a count: vehicle classes, movements and periods.

The format: 15-minute intervals

Counts are recorded in 15-minute intervals, by movement and by vehicle class. That level of detail lets you find the peak hour and see how traffic changes within it. An example for one movement:

FromToCarsBuses2-axle trucks3+ axle trucksMotorcyclesBikesTotal
7:007:159843195120
7:157:3011254185135
7:307:4512465294150
7:458:0011654285140

Sample values, not from a real study.

Peak hour and peak hour factor

The peak hour is the hour with the most vehicles. You find it by adding four consecutive 15-minute intervals and keeping the highest sum. In the example, from 7:00 to 8:00 there are 120 + 135 + 150 + 140 = 545 vehicles.

The peak hour factor (PHF), as defined in the Highway Capacity Manual, measures how even that hour is. Divide the hourly volume by four times the busiest 15-minute interval:

PHF = 545 / (4 × 150) = 0.91

A PHF close to 1 means traffic was steady through the hour. A lower value means a peak packed into a few minutes, typical of school drop-off or a factory shift change.

Many studies also ask for volumes in passenger car equivalents (PCE), which weight each class by how much of the road it takes up: a bus counts for more than a car. The factors depend on the manual your study follows, so check which one applies.

How to do a turning movement count, step by step

  1. Define the scope. Locations, days, periods, vehicle classes and whether you need pedestrians and bikes. If an agency requested the study, its requirements come first.
  2. Choose the method. Counters in the field, tubes or video. Tubes alone cannot give you turning movements.
  3. Set up. For a manual count, assign movements to each counter and prepare one sheet per movement. For video, place the camera high enough to see every approach without vehicles hiding each other.
  4. Count in 15-minute intervals. Record each class separately and note anything unusual, such as a crash, roadwork or a signal outage.
  5. Find the peak hour and its PHF. For each movement and for the intersection as a whole.
  6. Check and report. Compare entering and exiting totals, look for intervals that do not make sense, and deliver the tables with the peak hour, PHF and volumes by movement.

Counting methods compared

MethodHow it worksProsCons
Manual in the fieldCounters with tally sheets, hand counters or an electronic count boardRecords turns and vehicle classes with no equipment to installEvery counted hour costs the same; fatigue and data entry errors
Pneumatic tubesHoses across the road that record axles passing over themCovers many days in a row, with volume, speed and axle classNo turning movements; damaged by heavy traffic
VideoA fixed camera or drone, counted later in the office or by softwareCan be reviewed and recounted; fast with softwareNeeds a shot that sees the whole intersection

Free traffic count template in Excel

The template uses 15-minute intervals from 7:00 to 20:00. It calculates the total per interval, the PCE volume, the rolling hourly volume, the peak hour and its PHF. Use one copy of the count sheet per movement.

Download the traffic count template (Excel)

How to automate traffic counts with video

Manual counting has a built-in limit: every counted hour costs the same, so studies count as little as they can. With video you record once and count afterwards. When software does the counting, the office work goes away too.

  1. Record the location with a high camera or a drone, covering every approach.
  2. Upload the video to YOAO and draw the approaches and movements on a frame.
  3. YOAO detects, classifies and tracks each vehicle, and returns the count by movement and class in 15-minute intervals, with the peak hour and an annotated video to audit.
  4. Validate the first location with a short manual count. If the difference is acceptable, the method is ready for the rest.

Analysis costs USD 7 per hour of video. To compare that with what a manual count costs you, try the traffic count cost calculator.

Count from video instead of tally sheets

Upload a video and get counts by movement and vehicle class. No monthly fee and no minimum spend.

Create your account

Frequently asked questions

What is a turning movement count?

+

It is a count of the vehicles that enter an intersection, split by approach and by movement (left, through or right), usually by vehicle class and in 15-minute intervals. It is the basis of traffic impact studies, signal timing and intersection design.

How many hours should a traffic count cover?

+

It depends on the study. A common scope is a 2-hour AM peak and a 2-hour PM peak on a typical weekday, often Tuesday to Thursday. If the count answers to an agency or a permit, check the periods and duration they require before going to the field.

How many people does a manual count need?

+

As a rule of thumb, one person can follow one or two movements when volumes are moderate. A four-leg intersection with turns in every direction needs two or more counters per period, plus someone to coordinate and to enter the data afterwards.

Can I use video from a phone?

+

Yes, if the shot is steady, high and shows every movement you need to count. A tripod on a second floor or a drone works better than a shot at street level, where a truck hides the cars behind it.

How accurate is counting from video with software?

+

In a pilot with a municipality, the difference against a manual count on fixed cameras was about 3%. Large roundabouts seen from a drone need more tuning. That is why it pays to validate each new location against a short manual count before using the data.

What does a peak hour factor tell me?

+

How evenly traffic is spread within the peak hour. A value close to 1 means traffic was steady for the whole hour. A lower value means part of the hour carried much more traffic than the rest, as happens around school drop-off or a shift change, and the design has to handle that short peak.

Keep going