Setting COM port
On the right side of the “Main” worksheet is a box for selecting the serial port to be used for
communications with the Model 3150. Using the supplied cable, connect the Model 3150 to an available serial
port 9 pin connector on your computer. If you know the “COM” number for your computer’s connector, click
this COM number on the spreadsheet. If not, the simplest approach is to find the correct number by trial and
error. Turn on the Model 3150, press the MENU button, then choose the “PC Extract” option and press
ENTER. The Model 3150 screen should read “Waiting for request from PC…”
You are now ready to click on the spreadsheet button that reads “Click here to retrieve data from the
Model 3150”. If you have chosen the wrong COM port, you will get a communications error box on the screen
after about 5 seconds. Try choosing another COM port number in the spreadsheet, and click the “…retrieve..”
button again.
Normal Operation
Once Excel has been properly configured for using this spreadsheet, the operation should be very
intuitive. Pressing the “…Retrieve..” button causes all of the following actions to take place:
•The PC will read all stored data points (as many as 50) from the Model 3150. This action does not
erase these data points from the Model 3150 memory.
•The newly extracted data points will appear on the “Main” worksheet of the Excel file for review.
(Previously extracted data will be erased from the Main worksheet at this time. Only the currently
extracted data appears on the Main Worksheet.) Each log point contains a location name, a time
stamp, and a TSS value.
•All data will be archived by adding it to a worksheet named after the “locale” or location name given to
each data point. If a worksheet for the location does not exist, it will automatically be created. If a
data point has the same time stamp as one that has already been archived, a new entry will not be
created in the worksheet.
Note: The time stamp given to each point uses the month/day/hour/minute that was stored in the Model
3150. However the year is deduced from the PC system clock
Once the data is retrieved into the .xls file, it can be treated as any other spreadsheet data with normal
Excel copy, graphing, and computational functions available.
The .xls file should be saved after every use for continued archiving of data.
