Audacity Forum

Hi,

I want to record a noice and after that take the noice data as time and noice level and put it in to excel. I have seen that I can export some data from "ANALYZE" in a text file but can't reach the time data. Is it possible in some way to do that?

Thanks
Bo Vigholm

Exactly what "data" do you want? Sample values and sample times?

e023230 wrote:I have seen that I can export some data from "ANALYZE" in a text file but can't reach the time data.

What's the exact name of the "effect" that you are looking at?

Yes, I want sample values and sample time. I want to put the data into excel and in excel I will do other types of further calculations and presentations. E.g to calculate the speed of a hockey puck. I record the noice when the the stick is hit the puck and when the puck is hit a plate in the goal. If I know the lenght of puck travel and time to travel, I can calculate the average speed of the puck. The thinking is also to simulate/calculate the actual speed during the travel and in the end make a nice presentation on the screen with speeds, highscore etc.

So are you currently using the "sample-printer" plug-in?
I'm currently working on an updated version of this but it's not yet complete.

With the original "sample printer" plug-in you can produce an indexed list of sample values. The "index" is the sample number, counting from the first sample in the selection. To convert a given number of samples into a time value, all you need to do is divide by the track sample rate. For example, if there are 22050 samples between the noise when the the stick is hit the puck and when the puck is hit a plate in the goal and the track sample rate is 44100 Hz, then the time between the two noises is:
22050/44100 = 0.5 seconds.
It should be easy to get your spreadsheet to make these calculations.

Note that for measuring the puck speed you may need to take into account the position of the microphone. If there is a significant difference between the distance from the player and the difference from the goal, then you will introduce an error due to the time taken for the sound to travel to the microphone. The speed of sound is roughly 340 m/s which is about 3 milliseconds per meter. If the player is closer to the microphone than the goal plate by a distance of (say) 10 meters, then the sound will take about 30 milliseconds longer to travel to the microphone from the goal plate than from the player striking the puck.

If you want to comment, or make any suggestions regarding the development of the new "sample data export" plug-in, have a read through this topic and post a reply there: http://forum.audacityteam.org/viewtopic ... 39&t=34365

Ok. It works now

Thank you very much