045-I Wyo. Code R. § 1.4
(1) The Speed Study Worksheet has been developed to simplify and automate the processing of speed study field data. This helps reduce the chances of errors in the processing as well. The worksheet is an Excel spreadsheet with an input sheet and display sheets for each direction of travel as well as the combination of both directions analyzed. All data is entered on the input sheet, and the results are displayed on the display sheets for printing. The spreadsheet will be made available by contacting WYDOT Traffic.
(2) The location-related data is entered at the top of the Input sheet from the data on the Speed Study Data Collection Sheet. An example of the data input sheet for the previous field data collection sheet is shown in Figure 1-3 Example Speed Study Worksheet Data Input.
(3) Enter the lowest speed recorded and the highest speed recorded. This will help adjust the display of output data so that it is relatively centered in the display graph. If the difference between the highest and lowest recorded speeds exceeds 40 mph, an error message will display.
(4) The number of observations at each respective speed is then entered under the appropriate direction column. If no vehicles were observed at a given speed, the respective line can be left blank or a zero (0) can be entered.
(5) The Speed Study worksheet is designed to analyze speed statistics for each direction of travel as well as both directions at once.
(6) If the speed study is checking speeds by vehicle classification, the Speed Study Worksheet can only process one vehicle class at a time. The class of vehicle being studied should be noted in the Comments space of the input sheet.
(7) Once all of the necessary data is entered on the input sheet, the speed study statistics can be viewed by selecting one of the display sheets. #bookmark0 [File Link Not Available] gives an example of the Speed Study Worksheet output for one direction of travel.
(8) For a neat computer-generated sheet that duplicates the hand-written data from the data collection sheet, the cleaned field data sheet uses the same data entered on the input sheet to provide a copy of the Speed Data Collection Sheet with the heading data and tally marks filled in to match the form completed by hand. #bookmark1 [File Link Not Available] gives an example of the cleaned field data collection sheet.
Image Not Available
Image Not Available
Image Not Available
045-I Wyo. Code R. § 1.4