Lucity's IPT Monitoring Point Test module provides a 4-Day Test function to help agencies or industrial clients determine the largest average value for four consecutive Daily Result readings. This analysis, which performed using one of the 4-Day Test toolkits found in the Monitoring Point Test module, is usually conducted semi-annually or quarterly.
As part of the 4-Day Test process, Lucity Web conducts several checks and calculations:
Does the data fulfill the test requirements?
When users run the 4-Day Test toolkit, they identify the Monitoring Point Test records for which they want results and the month that represents the end of the reporting period. The system then determines whether the records meet the test criteria:
The IPT Facility(ies) related to the Monitoring Point Test records must require sampling during the selected month (see Sampling Fields). If they are not marked for sampling during selected month, the test cannot run, and an error message appears.
The 4-Day Test can only be calculated for Monitoring Points Test data related to activeIPT Facilities. If any of the Monitoring Point Tests on which the 4-Day Test is being run are related to an inactiveIPT Facility, the system will not produce 4-Day Results for Tests related to that Facility.
Lucity performs 4-Day Test calculations using Daily Result data. If users have not run the Daily Test toolkit, the system lacks the data required to perform the 4-Day Test.
The 4-Day Test requires four separate days of Daily Result data. If Lucity does not identify four Daily Results during the selected testing date range, the system cannot perform the 4-Day Test.
What is the largest daily average value for four consecutive days?
When applicable data exists, the system proceeds with calculations.
Lucity cycles through the Daily Results, calculating the average of each set of four consecutive days. In the example below, the system would average the results of readings 1-4, 2-5, 3-6, and 4-7. The largest value among those calculations would be the 4-Day Max Result.
The system would not, however, calculate and compare the average of readings 5-8, because readings 7 and 8 were taken on the same day. Thus, readings 5-8 do not represent four consecutive days of data.
But, if a ninth reading existed, the system could use readings 5-9 to calculate a 4-Day Result. The system would first calculate the average of readings 7 and 8; then it would use that value to calculate the average of readings 5-9.
Create a filter to identify the IPT Facility Monitoring Point Test records for which you would like to generate test results.
For example, you could create a filter to find all Tests:
for a particular Monitoring Point at a specific Facility;
for a certain Parameter; or
with a specific Due Date.
Run the Calculate Daily Test Results on IPT Facility | Current Filter toolkit. (See full instructions.)
2Calculates the Daily Result for all Monitoring Point Test records in the current filter. The toolkit also determines whether each parameter is in compliance with daily thresholds for the associated Monitoring Point.
Create a filter to identify the IPT Facility Monitoring Point Test records for which you would like to generate test results.
For example, you could create a filter to find all Tests:
for a particular Monitoring Point at a specific Facility;
for a certain Parameter; or
with a specific Due Date.
Note: If, for any reason, a user wishes to exclude a particular parameter reading from the analysis, simply check the Ignore Sample checkbox on the related Testing Test List record.
Click the button in the IPT Facility Monitoring Point Test toolbar and select Calculate Daily Test Results on IPT Facility | Current Filter. A pop-up appears, asking the user to confirm the number of records against which the Toolkit will run.
To continue, click Yes. The system performs the Daily Test analysis on all filtered Test List records. If the toolkit runs successfully, a pop-up message appears in the bottom-right of the Lucity screen.
To view the Daily Test results, open the Testing Test List records associated with the Monitoring Point Tests on which you ran the toolkit. In the "Results" section of the form, you'll find the Daily Result value and checkboxes that convey whether the system found the Parameter to be compliant, non-compliant or significantly noncompliant for the day at that Monitoring Point.
Note: You must run the Daily Test toolkit before running the 4-Day Test toolkit because the Daily Results values are required to calculate the 4 Day Max Results. If the user does not run the Daily Test, the toolkit will run; however, the system will flag the 4-Day Not Enough Tests field.
Click the button in the IPT Facility Monitoring Point Test toolbar and select Calculate 4 Day Test Results on IPT Facility | Current Filter. A pop-up appears, asking the user to confirm the number of records against which the Toolkit will run.
Click Yes if the record count is accurate. A pop-up appears, asking the user to select a Month. (The pick-list includes the current month and the two previous months.)
Select the Month that represents the end of the reporting period and click OK. The system identifies the Tests in which the related Facility has the selected month checked as a Sampling Required month.
If no records match that criteria, an error message appears stating that No Active Facilities were found where the selected month had a Sample Required.
If such records do exist:
Lucity identifies each Facility's designated Monitoring Frequency (i.e., None, Quarterly, Semi-Annually or Annually) to determine the date range from which to pull sampling data.
The system then determines whether enough Test records exist to meet the requirements of a 4-Day Test.
If there are not enough Test records, a check appears in the 4 Day Not Enough Tests field.
If there are enough Test records:
The system calculates the 4-Day Max Result for the prescribed date range.
The system concludes whether the Facility is is compliant, noncompliant or significantly noncompliant with established 4-Day Test thresholds.
Open the filtered Tests' Parameter records to view the calculated 4-Day Max Results and to determine whether or not the Facility is compliant/noncompliant.
Select the IPT Facility Monitoring Point Test records for which you would like to generate Test results.
Run the Calculate Daily Test Results on IPT Facility | Current Filter toolkit. (See full instructions.)
Note: You must run the Daily Test toolkit before running the 4-Day Test toolkit because the Daily Results values are required to calculate the 4 Day Max Results. If the user does not run the Daily Test, the toolkit will run; however, the system will flag the 4-Day Not Enough Tests field.
Click the button in the Facility Monitoring Point Test toolbar and run the Calculate 4-Day Test Results on IPT Facility | Selected Record(s) toolkit.
A pop-up appears, asking the user to select a Month. (The pick-list includes the current month and the two previous months.)
Select the Month that represents the end of the reporting period and click OK. The system identifies the Tests in which the related Facility has the selected month checked as a Sampling Required month.
If no records match that criteria, an error message appears stating that No Active Facilities were found where the selected month had a Sample Required.
If such records do exist:
Lucity identifies each Facility's designated Monitoring Frequency (i.e., None, Quarterly, Semi-Annually or Annually) to determine the date range from which to pull sampling data.
The system then determines whether enough Test records exist to meet the requirements of a 4-Day Test.
If there are not enough Test records, a check appears in the 4 Day Not Enough Tests field.
If there are enough Test records:
The system calculates the 4-Day Max Result for the prescribed date range.
The system concludes whether the Facility is is compliant, noncompliant or significantly noncompliant with established 4-Day Test thresholds.
Open the selected Tests' Parameter records to view the calculated 4-Day Max Results and to determine whether or not the Facility is compliant/noncompliant.
How does the 4-Day Max Result compare to established compliance thresholds?
The goal of the 4-Day Test is to determine whether the presence of a certain parameter at a particular monitoring point complies with acceptable thresholds for the test.
Lucity compares the 4-Day Max Result value for each tested substance to the 4-Day Limit and SNC 4-Day thresholds the agency established in the Parameter records associated with a Monitoring Point.
If the 4-Day Max Result is LESS THAN OR EQUAL TO the 4-Day Limit, the substance is considered compliant at that monitoring point. Lucity checks the 4-Day Compliance box on the related Testing Test List record.
If the 4-Day Max Result is GREATER THAN the 4-Day Limit, the substance is considered noncompliant at that monitoring point. Lucity checks the 4-Day Non-Compliance box on the related Testing Test List record.
If the 4-Day Max Result is GREATER THAN the 4-Day Magnitude Level (same as SNC 4 Day value on the Monitoring Point's Parameter record), the substance is considered significantly noncompliant. Lucity checks the 4 Day Magnitude NC box on the related Testing Test List record.
How do I determine the 4-Day Test results?
Lucity displays the quantitative and analytical results of the 4-Day Test in the Testing Test List records associated with each Monitoring Point Test. To view the data, open a Testing Test List record related to one of the Tests against which you ran the 4-Day Test toolkit and scroll to the "Results" section. (See graphic above.)
To view Monitoring Points that are noncompliant or significantly noncompliant, users can filter the data on the 4-Day Non-Compliance or 4-Day Magnitude NC field.
How to calculate 4-Day Test results for records in the current filter
button in the IPT Facility Monitoring Point Test toolbar and select Calculate Daily Test Results on IPT Facility | Current Filter. A pop-up appears, asking the user to confirm the number of records against which the Toolkit will run.