<HTML> <HEAD> <TITLE>Re: Excel beeps</TITLE> </HEAD> <BODY> Thanks for the response, Bill Ballard. "I'm sure you don't have the Ma= c OS"?? Please don't be so sure about such things, it raises hackles. &= lt;g> I have had the Mac OS since February 1984, and currently have four = functioning 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 functiona= lity. 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 Noss= aman, and one from an Excel MVP on the Excel Programming newsgroup, so prett= y soon I will have a nice little Excel sheet that produces a beat rate of yo= ur choice. It's partly for the purpose of learning tuning ... more efficient than maki= ng a 1-second pendulum and saying "from mississippi to New York", = which is how I learned in 1970 ... and partly for experimenting with alterna= te temperaments, such as some of the modified meantones that have recently c= ome our way, that call for setting beat rates such as 4.5 per second ... mor= e efficient than setting a metronome. And yes, I am preparing for the RPT tuning exam in about 6 weeks and will a= ttempt the Sanderson-Baldassin temperament, and as I practice, this will be = 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 || ||| || ||| || ||| || ||| || ||| || ||| || ||| || ||| <BLOCKQUOTE>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 </BLOCKQUOTE> <BLOCKQUOTE><TT>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 prod= uce 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 manual" >>       ...........Reese Witherspoon i= n "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 th= e 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 +/- ¢ with an anchor frequency), the time consumed by the 0.033 second sine wave .wav  would remain constant. <B= R> 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 Thea= ter +++++++++++++++++++++ _______________________________________________ pianotech list info: https://www.moypiano.com/resources/#archives </TT></BLOCKQUOTE><TT> </TT> </BODY> </HTML>