RobbN

Attila, Thank you for your reply and sorry for the delay in mine. I thought I was notified by email when a post was made here. The first "easier" method doesn't really address the need. We're trying to just easily bring a measurement result into a cell of a spreadsheet. I've looked at the examples that you referenced and they are a bit intimidating to this non-coder. I suppose we will keep doing the manual entry.

I would like to create a macro for a spreadsheet to track quality control measurements. This macro would allow the user to trigger a measurement from the spreadsheet and automatically enter that measurement result, or array of measurements into the cells without the operator needing to import CSV files or key in results. I have not found any references about this here or in searching the web. Can anybody verify whether this is even possible? If so, can you provide reference to an example? If anybody is skilled at this kind of work, I would be happy to pay for help in script design. We have lots of applications for this, but specifically: We use LibreOffice and would like, for example to pull a capacitance measurement from a piezo transducer into our QC sheet from Waveforms without the user having to continually click between programs. Thanks in advance to anyone who might point me in the right direction--or even saving me the time if it is not possible.

Thanks so much, Attila, for your attention to this. Rather than bury readers in text, I'll just answer your questions and use your clever text graphing. But if you or anybody is interested, I could attach a few relevant pages from a US Navy document about taking free-field measurements in a laboratory tank. The generated signal need only be five or ten milliseconds. Averaging will be useful, but we could always average multiple tests if needed. We could keep it simple for now and say one pulse. The pulse should be a sine wave. I'll put realistic example times in milliseconds in parentheses as examples below. We should be able to set those times based on test conditions. |freq1............................................................................................................................................................................................|freq2... |sine pulse 1 (10ms duration) | wait (1ms) | acquisition (3ms) | log RMS voltage (two channels) | wait for sound decay (250ms) |sine pulse 2... Again, we're trying to create a sound (pulsed constant wave), wait for that sound to arrive at the DUT and reference (same spacing), measure that direct sound before reflections arrive, then wait for that sound to decay in amplitude while logging the measurement and then incrementing the the test frequency. The acquisition could be very short, or we could trigger an acquisition on wavegen and only look at the appropriate few milliseconds or wave cycles by gating a portion of that acquisition. phase information would be nice, but not at all essential.

I would like to use the AD2 for measuring high-frequency response of hydrophones and microphones. Lots of tools are available for audio spectrum measurements with computer sound interfaces, but I would like to be able to test from 1KHz up to 200KHz or more. I need a system that will gate the reflected sounds out of the measurement. It seems like the Waveforms software has all it needs to do this, but I don't understand the scripting, or if it would even be necessary. We need to create a pulse, delay the acquisition while the sound travels to the reference and DUT, then make that acquisition in just a few milliseconds before the reflected sound distorts the measurement. Then we need to log that frequency and amplitude, wait some time for sound decay, advance the AWG and repeat. The Network Analyzer is close, but does not offer the timing functions. Can anyone here help with detailed instructions or script? I'll certainly appreciate volunteers, but would even consider paying a consultant who has time to work with me.