Why Excel?
- Widely available.
- Inexpensive.
- Short learning curve for students.
- Short learning curve for faculty.
What can Excel do?
- Create a wave form and play it as a sound.
- Record sounds from the sound card on the
local computer (8s at 8kHz or 1.5s at 44kHz).
- Record sounds from the sound card on a remote
computer.
- Analyze a sound sample with an FFT.
- Export a sound file in .WAV format.
What do
you need to do this?
Hardware:
- One
(or more) computer with sound card.
Note:
Data from a second computer can be collected from the first computer if
both are on a TCP/IP network and have the software.
Software:
- TCP/IP
to Sound software (free!).
- Our Excel
macro.
Note: Any software that
has TCP/IP commands (Perl, JAVA, MatLab, etc.) can take data off the
sound card through the TCP/IP to Sound software.
Download a zip file with the
following software:
- Tcp2Sound: a program that acts as a TCP/IP server for
communicating with a sound card.
- Excel spreadsheet with a macro for controlling the sound card via
TCP/IP.
- Brief instructions.
- Supplementary files that you may or may not need for your system
(but we don't guarantee this will fix every problem with every system!).
Return to the IUS Physics
Top
Page.
Contact Kyle Forinash, kforinas@ius.edu,
for comments/suggestions/corrections.