This application is designed
to track information related to the neutralization of a particular
chemical. The chemical needs to be accounted for from beginning
to the end of the process with reports being provided on a daily
During each phase of the neutralization process, data is calculated
and controlled through ControlLogix programming. Process information
is stored in SQLServer database for tracking of batch information.
This is accomplished through the use of RSSQL. Control events
trigger RSSQL transactions to retrieve data from the PLC and execute
the appropriate SQLServer stored procedure for data logging.
Using Microsoft Access, data can be viewed through 7 different
daily reports and 10 different customized search reports. Forms
in Access are also used to allow the manual entry of operation