Ad Hoc Reporting
Posted on 05.15.14

One of the benefits of Intelligent NETworks is the ability to quickly create customized reports. Delcan Technologies recently released a new set of advanced ad hoc reports for Michigan Department of Transportation (MDOT). These report templates allow MDOT system administrators to automatically run custom reports based on their requested data parameters.

Here is a summary of the four custom reports created specifically for MDOT:

Salting Speed Report: This custom report measures how fast the plow vehicle is going during salting. The mobile data collectors (MDCs) on plow vehicles gather information from sensors and the engine diagnostics to determine when the salting process starts and stops, along with the vehicle speed. The custom Salting Speed Report pulls those data parameters into an automatically generated report. MDOT fleet management can then use that information to determine if the plow vehicle was traveling too fast, and therefore salt bounces off the roadway reducing the effectiveness of MDOT’s roadway treatment efforts and wasting material.

Geo Fencing Report: The Geo Fencing Report calculates the amount of salting material applied within a specific geographic area. The Geo Fence module of Intelligent NETworks creates a virtual perimeter around a user-selected area on a map. Whenever an MDOT plow vehicle enters or exits the geo fenced perimeter, the system captures that data. Another on-vehicle sensor collects data on amount of salt material applied. This custom report collates the data and shows exactly how much material was applied in a specific region. This is particularly useful for monitoring environmentally protected areas.

Plow Life Study Report: Although plow blades have a manufacturer lifecycle, it doesn’t always compare to the lifecycle of plow blades used in the field. The Plow Life Study Report measures the time a plow blade is down and compares it to the wear and tear data collected on the plow. This report helps management to understand why some plow blades wear out more quickly. They can easily see if an operator is putting a blade down too heavily or for too long.

Type and Amount of Material Applied Report: Currents reports were available to tell MDOT management how much material was distributed during each run. However, the snow removal material is usually a mix of different substances, including magnesium chloride, brine, and salt. The Type and Amount of Material Applied Report breaks down the total amounts of mixture distributed by each type of material rather than just a grand total. This report can help procurement estimate how fast each material in the mixture will be used.

These reports were customized for MDOT’s specific needs. As MDOT determines more data assessment needs, additional custom reports can be created. DTI can take any two or more data points collected and create a report to display the data. As needs change, the reports can be updated accordingly. Contact DTI today to find out how you can benefit from custom reports.