...
The data for this experiment was analyzed using a serious series of Matcad data processing code written and developed by Ian Tse and Dr. Monroe Weber-Shirk. Three mathcad files were used along with a excel spreadsheet called meta fileMeta File. The Mathcad code has the capability to consolidate and filter data collected in process controller over a period of several days. The Meta file contains all of vital information that must be inputted into the mathcad file by the user, including the dates over which the experiment occurred, the particular process controller state that indicates the beginning of an experiment, the location of the files, and an ID tag which allows the user to easily access processed data. After entering the ID tag, date, and experiment start state into to the Meta file and Data Preprocessor file, indicating the location of the files, and running the preprocessor the user can extract the statelog start row and number of runs from the Data Preprocessor file and input the values into the Meta file. After the Meta file is complete the Meta Data Processor can be used run by entering the metaID and the statID.
The output is a graph of the effluent turbidity vs. time and a graph of average effluent turbidity vs. critical velocity as seen in the results section.
...