How does our 'simple approach' work (spreadsheet example)?

a) Student types data collection parameters and/or AtoD device commands into spreadsheet and activates spreadsheet:

c) Visual Basic macro in spreadsheet sends the parameters/commands via TCP/IP to remote computer.

d) TCP2Serial server software on remote computer listens to TCP/IP and passes commands to the serial port.

e) A/D device on serial port does what it is told, returns data.

f) TCP2Serial server sends data back to student computer via TCP/IP.

g) VB macro puts data into spreadsheet cells for further analysis by student.
 
 

No control program at the remote site! (Everything is in the control of the student.)
 
 

Http://Physics.ius.edu