ProUCl Getting Started

The following is how to enter data into ProUCL or Scout.

First get your data in excel and in the right format. ProUCL will not accept dates so you have to convert them to event number, years from a giving start point, or some other simple numerical format. If your data can have non-detects you need to have two columns for each parameter. One column for the parameter and one with the same name but D_ in front of the name. For detected values enter 1 for non-detects enter 0. For missing data enter a very large number like 1E31 or leave it blank and it will be ignored. NOTE: if you have missing data, the graphing tools will not work.

The spreadsheet has to be saved as an excel 97-2003 file (*.xls)

After saving the file, close the file.

Open ProUCL and go to “File” if your spreadsheet has more than one sheet/tab, you will need to select “load Excel Data” if you only have one sheet/tab you can just select “open” and select the file.