Excel beeps

[Jason Kanter]

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

---------------------- multipart/alternative attachment
Thanks for the response, Bill Ballard. "I'm sure you don't have the Mac
OS"?? Please don't be so sure about such things, it raises hackles. <g> I
have had the Mac OS since February 1984, and currently have four functionin=
g
Macs running systems 8.6, 9.2 and OS X, and four functioning PCs running
Wingows 98, 2000, and XP. I always try for cross-platform functionality.

Now that my hackles are back down, I agree the database approach is not ver=
y
efficient. But I have had a couple of good responses, one from our Mr
Nossaman, and one from an Excel MVP on the Excel Programming newsgroup, so
pretty soon I will have a nice little Excel sheet that produces a beat rate
of your choice.

It's partly for the purpose of learning tuning ... more efficient than
making a 1-second pendulum and saying "from mississippi to New York", which
is how I learned in 1970 ... and partly for experimenting with alternate
temperaments, such as some of the modified meantones that have recently com=
e
our way, that call for setting beat rates such as 4.5 per second ... more
efficient than setting a metronome.

And yes, I am preparing for the RPT tuning exam in about 6 weeks and will
attempt the Sanderson-Baldassin temperament, and as I practice, this will b=
e
very useful to me. But I'm building it so that it will in turn be useful to
others. Right now I have two early prototypes that don't work reliably
cross-platform. Stay tuned, I will publish it when the time comes.


|| ||| || ||| || ||| || ||| || ||| || ||| || ||| || |||
jason kanter * piano tuning * piano teaching
bellevue, wa * 425 562 4127 * cell 425 831 1561
orcas island * 360 376 2799
|| ||| || ||| || ||| || ||| || ||| || ||| || ||| || |||


From: Bill Ballard <yardbird@vermontel.net>
Reply-To: Pianotech <pianotech@ptg.org>
Date: Fri, 3 Jan 2003 01:07:26 -0500
To: Pianotech <pianotech@ptg.org>
Subject: Re: Excel beeps


At 9:04 PM -0800 1/2/03, Jason Kanter wrote:
>Please give it a try...
>...........
>..  jason kanter . jason.kanter@wamu.net . jkanter@rollingball.com
>
>>  At 4:06 PM -0800 1/1/03, Jason Kanter wrote:
>>  >Anyone know how to program Visual Basic in Excel to produce x beeps
>>  >per second?
>>
>>  I could write it as a loop in my database.
>>
>>  Bill Ballard RPT
>>  NH Chapter, P.T.G.
>>
>>  "Trust me, you've got all the equipment, You just need to read the manu=
al"
>>       ...........Reese Witherspoon in "Legally Blonde"
>>  +++++++++++++++++++++
>>

What it would involve is a unit of sound (.wav or .aaif) say 1/30
long. Then set up a "counter" variable to cycle things through the
correct number of loops, and one for the number of bps desired (not
nec . a whole number). One you've set the number of bps you want t
hear, that deterimnes a timed loop, in which the period is the
inverse of the bps. Whatever the period of the beat rate (and that
could even be input as +/- =A2 with an anchor frequency), the time
consumed by the 0.033 second sine wave .wav  would remain constant.
For 2.5 pbs, it would be 8.25% of the 0.4 sec period.

That's how I would do it. I have no idea whether the database app's
connection to the OS would have its own inefficiency. 'Puter
telephone dialing involves a delay of 4 sec between execution and the
internal modem dialing out. It's not just my database, it's the Palm
Desktop's phone dialer behaving that way too.

Whether or not I could do it might or might not be useful to you. I'm
sure you don't have the Mac OS, and even if if polished up the
beat-rate generator real swell, it would still be just a database
file required the app to run it. The cross-platform version of this
database does exist, but the value of such a eat-rate generator would
probably be far less than the price to you of the database to run it.
(Although for $50, I could register a run-time file distributed only
by the database's web site.)

I agree it would be a fun project. Say, you wouldn't need this this
to be learning arual tuning by any chance? <g>

Mr. Bill Ballard RPT
NH Chapter, P.T.G.

"I gotta go ta woik...."
    ...........Ian Shoales, Duck's Breath Mystery Theater
+++++++++++++++++++++
_______________________________________________
pianotech list info: https://www.moypiano.com/resources/#archives



---------------------- multipart/alternative attachment
An HTML attachment was scrubbed...
URL: https://www.moypiano.com/ptg/pianotech.php/attachments/e9/ae/1e/54/attachment.htm

---------------------- multipart/alternative attachment--