In 01, updated element query location from static file to direct from the SQL view, updated matrix assignment to be consistent and usable for FW,SW determination, added code to pare down the duplications we were seeing in some standard parameters. In 02, added column to report the projects that method is associated with, resolved issues with pentachlorophenol. In 03, updated to handle matrix so FW/SW could be handled from initial station information. Updated FW/SW designation from Type to Matrix. Updated names and added ammonia criteria calculation.
This file doesn't need to be in this folder.
In 01, made method names consistent for future grouping. In 02, added some checking code to make sure the totals are coming through correctly. In the ammonia fw calculation, it was calculating up to unionized ammonia criteria but we have total ammonia so I added the calculation to get to the correct criteria.
Updated comments and data flow diagrams and seaprated code used to create lasar file with element names into separate code for reference.
Added method to convert for grouping. Just decided to ignore DO when considering method changes. Fixed how the roll up function works depending on whether we have saltwater sites or not in the input dataset.