Student enters data collection parameters and/or AtoD device commands into spreadsheet and activates spreadsheet.
Visual Basic macro in spreadsheet sends the parameters/commands via TCP/IP to remote computer.
TCP2Serial server software on remote computer listens to TCP/IP and passes commands to the serial port.
A/D device on serial port collects and returns data.
TCP2Serial server sends data back to spreadsheet via TCP/IP for student analysis.
No control program at the remote
site!
(Everything is in the control of the student through the spreadsheet.)