Context:
I am writing a script for a factory that tests audio quality. I have software that returns the transfer function values at 2K different frequencies. I’ve setup a VBA script in Excel to run the software and populate an Excel spreadsheet with the data. However, I then use Octave/MatLab to analyze the data and find the low and high frequencies where the transfer function “rolls off”. Rather than calling Octave/MatLab to do this calculation, I’d like to learn how to do this in VBA/Excel; which will eliminate the need for the factory to install another software.