June 18th, 2014

Auto-generated summary sheets

Preserve Infrastructure, by Catherine Higgins.
Photo of John Guymon

John Guymon, UDOT Rotational Engineer

For each roadway preservation or rehabilitation project, UDOT designers fill out a summary sheet that provides a tally of measurements and material quantities needed for the project. Collecting data on-site, compiling data and figuring quantities can take a week or more. “You go out into the field with a wheel and tape, and you measure everything,” says UDOT rotational engineer John Guymon. His work to integrate online data with a spreadsheet is helping UDOT designers work more efficiently.

Guymon used coding and Microsoft Excel to create a form that uses asset management data and standard formulas for figuring material quantities to populate the summary sheet. The data sets are housed in the UDOT Data Portal, UDOT’s online data repository.

The Auto Report Generator is simple to use, and works along with the Linear Bench tool, both accessible on the UDOT Data Portal. Step-by-step instructions are available with the form. Once produced, the summary sheet shows:

  • Pavement type, surface area and material amounts for granular borrow and base course. The pavement type generated in the report is specific to the region, since climate differences around the state call for different pavement types.
  • Barrier in the project area, including location, total feet, and post type, all sorted into standard and non-standard types to show any areas in need of full replacement.
  • Signs, including location, sign type, size and any damage present during data collection.
  • Pavement marking type, paint amounts, messages, and rumble strips or grooved-in paint.

Once the summary sheet has been populated, the sheet can be used to verify measurements, barrier type, roadway geometry, pavement messages, etc.

So far, the new form has been downloaded over 600 times since it became available, about two months ago, and users have become instant fans. Kendall Draney says that one advantage is that using the form keeps employees out of harm’s way. Draney used the form as a design rotational engineer in Region Three. Sometimes getting measurements necessitates a dash across a busy roadway. “It’s really nice to have something that you’re using to verify,” says Draney. “It’s much safer to be on the shoulder.”

Engineering Tech IV Lynda Seckletstewa likes the consistency of the quantity amounts generated by the reports and “quantities for the existing features pulled by the report generator are within 2% of field quantities.”

The reports also provide “an instant checklist for field reviews,” says Seckletstewa. “Generated notes for various features point out deficiencies that we may have otherwise overlooked.”

The new summary form is an example of how UDOT is making good use of data collected on everything on a state roadway that can be viewed through a car window. “I didn’t realize how useful the Mandli data would be,” says Guymon. He views the tool as a first effort that can be improved over time.

Find out about other ways to view data, including the Linear Bench and Highway Reference Online, on the UDOT Data Portal.

Read about the Mandli data-gathering effort here.

Back Top

Responses to “Auto-generated summary sheets”

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Back Top