Computer Serial Port interface

Here is an inexpensive way to get slow-moving analog data directly into a spreadsheet on your computer! A simple circuit connects to a serial port and a short Qbasic program gathers and saves 12 bit data to a file. A spreadsheet automatically retrieves the file and displays the data in real time. Once the data is in the spreadsheet, the full power and flexibility of the office suite is available. A new Qbasic program interfaces to the data taker. It reads the voltage via a serial port and saves the data to a file in the form of an HTML single column table. Run qbasic.exe to start basic then run the data taking program from within qbasic. Ah, the good old days!
Computer Serial Port interface - schematic

Note: In order to run or edit the basic program, qbasic.exe is required but your machine may not have it installed. If not, you will need to copy it from your Windows install disk. Look for qbasic.exe in a directory with a name like "oldmsdos" and drag it

Leave Comment

characters left:

New Circuits