The Supermega™ Spreadsheet (SMS) was developed in 2013 to compare damage information by county using a variety of variables, including positive response codes, first time caller survey data and percentages, “failure to call” root cause and a wide range of education activities. The purpose of the sheet is to identify counties in which “incidents per thousand” tickets and transmissions have increased or decreased from year to year.


Tracking reported incident data by county, work type, “failure to call” root cause, membership impact and education efforts. This report uses the Supermega Spreadsheet to identify counties that have improved using damages per 1000 transmissions as a benchmark

Louis Panzer, NC 811

Detailed County by County Data Analysis Through Use of NC 811 Ticket Data and DIRT Reported Incidents