Making a audio file from timing data in spreadsheet

Windows 7
Audacity 2.1.2

Hi All

I run a test and each running get list of random times (timing information in seconds, between 0 to 4000 seconds); e.g. 10, 113, 550, 899, 1500 etc in a spreadsheet. There could be 50, 100…300 times/numbers in the list. The following week when you run the test it could be e.g. 150, 173…3033 seconds)

Is there a simple (automatic) way to demonstrate/illustrate the timing information as beeps (or any kind of noise/tone) in an audio file. I realize I could just press the record button on a sound recorder and looking at my spreadsheet vocally record a noise/beep at 10 seconds….113 seconds etc but this is not practical (once off maybe but not practical if you want to be able to do it repeatedly).

Could you make a silent 1 hour (3600 seconds) audio recording as your template and then have some kind of software application that you could copy the times into (10, 113…etc) and it would automatically paste/overlay a beep/noise at each point along the audio timeline. I am just curious to see if I can convert the numbers (times) in my spreadsheet to an audio timing signal.

Software application - can Audacity do the above?

Thanks, any insights/suggestions welcomed.

You might be able to do something with [u]Nyquist[/u]. (I’ve never used Nyquist and I don’t know how you’d import the data from a spreadsheet.)

If you can convert (export) your spreadsheet as a list of space separated numbers, then running this code in the Nyquist Prompt may do the trick:

;version 4

;control tlist "List of numbers" string "" "1 2.5 3 5"
;control dur "One whole number as" float "seconds" 1 0.1 2

(setf tlist
  (read (make-string-input-stream
    (format nil "(~a)" tlist))))
    
(setf beep
  (abs-env
    (mult (pwlv 0 0.01 0.5 0.09 0.5 0.1 0)
          (hzosc 1000))))

(defun terminate (sig)
"Add one second silence to the end"
  (abs-env
    (sim sig
         (at (car (last tlist))
                 (cue (s-rest 1))))))

(let ((out (s-rest 0)))
  (dolist (time tlist (terminate out))
    (setf out
      (sim out
           (at-abs (* dur time)
                   (cue beep))))))

The first control is where you put your list of numbers, simply copy and paste your list over the top of the example list.
The second control allows you to regulate the speed. For example, if you set “One whole number as: 0.5 seconds”, then each number in the list is represented by half a second.

Hi All,

Thanking you for the suggestions, much appreciated. I did not know about the software application Nyquist Prompt. I will have to look into it.