Many facilities under the Industrial General Permit (IGP) in California are unfamiliar with the term “Ad Hoc Report“. Though all facilities understand that stormwater results must be uploaded into their SMARTS account. The issue we see all the time is that only an attachment of the lab report gets uploaded and the data is never entered into an Ad Hoc. An Ad Hoc Report is where your sampling results must be manually enter so SMARTS can calculate your averages to decide if you will enter Level 1 or Level 2 the following year.
For those of you who are familiar with Ad Hoc Reports in SMARTS, you most likely cringe every time you hear the name because it can be a long and drawn out process. As if it is not difficult enough to remember the steps to just get into the Ad Hoc Report, you then have to manually input all of your sampling results, the methods used by the lab, the Method Detection Limit (MDL) and Reporting Limit. Goodness forbid that you accidentally make a data entry error. Something as simple as your finger slipping and making that TSS result go from 42 mg/L to 420 mg/L could send your facility spiraling into Level 1 when you didn’t even have an exceedance!
For facilities that want to stay on top of their stormwater results to determine if they are exceeding Numeric Action Levels (NALs), which is wonderful and highly suggested, will generally have a method of recording and tracking their results. A lot of facilities keep it old school and use excel spreadsheets, while others take it back to the stone ages and keep records in word where they manually average everything. Regardless of the method, this means that they will have to enter stormwater data into multiple locations before they even get to the dreaded Ad Hoc.
The team here at Mapistry shared these same frustrations when uploading data for our clients. We kept asking ourselves; why does this have to be so tedious and time consuming? Wouldn’t it be wonderful if there was some way you could simply enter your data one time and have it averaged, recorded and in a format that could easily be uploaded to SMARTS? That is why we customized our software to do just this, by utilizing the PET tool option in SMARTS!
Mapistry’s software allows for you to input your data into one location and have it stored for records, averaged for tracking of NALs and will generate a file that can be uploaded to the PET section in your Ad Hoc Report. This wonderful creation not only saves time but also assists in minimizing human error when uploading data to SMARTS. One may ask (being the devil’s advocate), but what if you input the data wrong into Mapistry’s software? Well, Mapistry’s software will immediately average your results and the “Annual Avg” line below the data entry section will turn red indicating an annual exceedance. If the line turns red then you should double check your data entries to confirm that they were entered correctly. Too bad the Ad Hoc alone won’t do this for you.
This amazing feature is just one of many offered through our software program. What if you do not want to do data uploading at all and would rather someone else take care of it? Sign up for our monitoring program and you will not only get the software with all of its perks but we will upload your data for you!