You can find more information about the author here.
Preliminary Note: On a keyboard instrument like a piano, the thing that you push down with your finger, in order to produce a tone, we call a digital. Each digital is connected to a series of action parts which transfer your finger motion to a swinging "hammer," the last action part in the series, which strikes either one string, two strings tuned in unison, or three strings tuned in unison. The string or strings vibrate and produce a tone having a specific pitch. Most pianos have 88 digitals which produce 88 tones, each with its own distinct pitch. The digitals are numbered from 1 to 88, from left to right, like this
click to enlarge.
Computer: Human, working from pitch number 49, to which you have assigned a value of 440 hz, I have calculated 88 pitches and printed them in the list below. Of those, pitch number 40 is 261.6255653006 hz.
We can extend our piano keyboard beyond the usual 88 pitches. If, in the pitch number box above, you entered a pitch number above 88 or below 1 (you can enter negative numbers, or, for a half-tone below pitch 1, enter 00), you won't see its frequency listed above, but I can calculate and display its frequency for you here. Pitch number 40 is 261.6255653006 hz.
Computer: I work fast, don't I? Most likely I calculated and displayed all 88 frequencies in less than a second. You know how long this would have taken you, human, if you had had to do it with an electronic calculator and a typewriter or pen? Probably a good few hours. You know how long this would have taken you, if you had had to do it without any kind of electronic or mechanical computing device (not even a slide rule) to aid you? Probably several days of working 8 hours per day.
Computer Programmer: The php program I wrote, copyright 2006 by Theodore Zuckerman, calculates all the theoretical frequencies, all the theoretical pitches, not taking inharmonicity into account, on a piano tuned to equal temperament, that is, on a piano tuned so as to have each set of pitches in an octave be a 12-tone equally-tempered octave. Theoretically, each pitch is equal to the previous pitch, multiplied by the 12th root of two. On a real piano, an initial pitch near the center of the keyboard is tuned to a reference pitch, such as a tuning fork, and then the rest of the pitches are tuned to the initial pitch, and each other. For example when tuning an octave, the fundamental of the higher pitched string will be tuned to the second harmonic (first overtone) of the lower pitched string. When tuning a fifth, the second harmonic of the higher pitched string will be tuned to the third harmonic of the lower pitched string, and then narrowed slightly to account for the fact that the interval needs to be a tempered interval as opposed to a just interval. The narrowing is done by listening to the 2 pitches beating against each other, and estimating the rate at which they are beating, estimating the beat rate, and tuning the notes until this perceived beat rate matches their theoretical beat rate.
That's right, aural piano tuners listen to and hear both the fundamental frequency, and the partials, of any string they are tuning. They don't need an electronic instrument to identify the partials and determine their frequency. They don't need better than normal hearing. They learn how to do this using reference tones and their ears. Strings, when struck, exhibit "inharmonicity." That is, the upper partials (overtones) of each string are actually higher than precise harmonics. Therefore real pianos exhibit octave stretching – fundamental pitches turn out to be higher than their theoretical equally tempered pitch, as you move up the keyboard to the right (high) side of the initial pitch, and turn out to be lower than the theoretical equally tempered pitch as you move down the keyboard to the left side of the initial pitch. Each piano has a different amount of inharmonicity, and gets a different amount of octave stretching.
This page contains a server-side php program, so you won't see the programming code in the source document for this page. The calculations are done by the php interpeter on the web server computer (which these days, may well be a "virtual" computer at my web hosting company), then just the results are sent to your computer. If you are interested in seeing a copy of the source code, please contact me. I should add that to start with one pitch, multiply it by the twelfth root of two, note the result, multiply that by the twelfth root of 2, note the result, multiply that by the twelfth root of 2, etcetera, across the entire keyboard, from the lowest note to the highest, would result in the accumulation of imprecision. To minimize that, I calculated each pitch using a formula that related it directly to pitch 49, the standard reference pitch, which is near the middle of the keyboard. This is similar to the way we tune a piano. We don't start with a 27.5 hz tuning fork, tune the lowest A on the piano, A0, pitch 1, to 27.5, and then tune all the other pitches starting from A0. Rather, we typically start by tuning pitch 49, A4, which is near the middle of the keyboard, to 440 hz, and then tune the remainder of the pitches starting from there.
Here is the sketch of a piano keyboard that I made in 1976. I've numbered the digitals from 1 to 88 and also labeled each digital with the note letter-name commonly used for it, and the pitch it produces. Since 1976 was before I owned a personal computer, I calculated the frequencies, one by one, with an electronic calculator, and wrote them in with a pencil. Then, to halt pencil-smearing, I sprayed the sheet with fixative. Rather than provide you with a color-corrected image, showing a crisp ebony-toned and ivory-toned keyboard, I decided to provide an image which allows you to see how the paper with the sketch of the digitals has yellowed with age, yellowed more than the paper that I pasted it to and wrote the frequencies on. I'm not sure whether this is an unnecessarily nasty-looking bit of business, or a charming bit of memorabilia.
Note that the digitals, in addition to being named with numbers from 1 to 88, are named with letter names, followed by an octave number from 0 to 8. We can see for example that synonyms for note 49, are A49, and A4. The 4 in A4 means that this A is the A in octave 4. There are 8 A's on an 88-note piano, A0, A1, A2, A3, A4, A5, A6, and A7.
My Beat Rate Calculator Spreadsheet file for Excel, which you can purchase, not only shows the fundamental frequency of every pitch from 1 to 88 but it also shows the coincident partials and their beat rates, for just about every equally tempered interval that a piano tuner might ever want to listen to, when perfecting their tuning — fifths, fourths, major thirds, minor thirds, major sixths, minor 6ths, and 10ths (major third plus an octave). The beat rates for intervals that consist of an interval plus an octave can be easily determined by consulting the chart for the interval without the added octave. You can see the coincident partials and beat rates for each interval from one end of the piano to the other (covering more than eight 12-tone equally tempered octaves), not just for an octave of intervals in a "temperament octave." (scroll down a bit to see about getting a free sample). For example you will have 84 beat rates for 84 major thirds, progressing from A0-C1 to A7-C8, not just the 9 major thirds progressing from F3-A3 to C#4-F4. The chart will show you whether each interval is expanded or contracted. And if there is some interval that you want a chart of partials and beat rates for, that the spreadsheet file doesn't already have, I will add that on, at no extra charge. Here is how to purchase: scroll down.
The spreadsheet has been confirmed to work with Excel 2003, 2007, and 2016, and in Windows XP, Windows 7, and Windows 10. The instruction sheet opens with Microsoft Word or Open Office. If you area unsure whether it will work with your operating system, download the free sample spreadsheet below. If the free sample works, the full spreadsheet will work.
If you change the value of A49 (A4) from 440 hz to a lower or higher value, you will be able to see how all the fundamental pitches, and consequently all the coincident partials, and all their beat rates, will be changed — all 7 pages of changes (each interval has its own page). Each page has 73 to 85 intervals, 146 to 170 partials, and 73 to 85 beat rates — they are all re-calculated almost instantaneously. This could be useful if you want to tune an instrument to equal temperament, without first raising its pitch to standard pitch, that is, when doing a "pitch raise" on the piano, raising its pitch to standard pitch in steps, or if you want to tune a historic instrument that was designed to sound and work best at a lower pitch, such as A49 = 430 hz, instead of at the contemporary standard of A49 = 440 hz.
Using Excel's Goal Seek feature, you can create a "what if" scenario: what if any pitch of any note, or any beat rate of any interval, anywhere on any page, were changed? Then, (1) what would the value of A4 have had to be, in order to get that pitch, or that beat rate, and (2) what would be all the fundamentals, partials, and beat rates, for every interval, given the new value of A? For example if you were to change C52 from 523.252 to 528, what would A49 have to be, instead of 440 (the answer is roughly 444). And then you could see what every fundamental would be, and what every partial, and every beat rate of every interval, would be, given a reference tone of 444, instead of 440. Or for example if you were to change the beat rate of the Major third, F3 to A3, from a beat rate of 6.929 hz to a beat rate of 7.0 hz, you would see the pitch of A4 change from 440 hz to 444.48 hz, and at the same time, you would see what every fundamental would be, and what every partial, and every beat rate of every interval, would be, given a reference tone of 444.48, instead of 440. Almost instantaneously! Computers never cease to amaze me, doing even these simplest things that they do, like making and displaying hundreds of calculations in less than a second.
Easy to use: The spreadsheet has been carefully planned so that it is easy to read and understand. All the Excel formulas can be made visible so that you can see how the fundamentals, partials, and beat rates are being calculated. Many of the variables are referred to by names, in addition to being referred to by their Excel row and column identifiers. This makes the formulas easier to understand. There are complete instructions, readable and writeable in Microsoft Word or Open Office. This means you can easily add your own notes to the instructions if you want. Scroll down a bit to see how to purchase.
A1 to C88: As you know, in addition to checking octaves, from end to end, you can check any interval, below and above your "temperament octave." From A1 to C88. Or using an alternate nomenclature, from A0 to C8. The more intervals you check the more control you can exert over how far you stretch your octaves, and you can produce a more precisely stretched, better-sounding tuning — a better-sounding piano. This is why I always check progressive 3rds, 10ths, 17ths, etcetera, far beyond the temperament octave. You could check your 10ths by using the chart for Major 3rds; just find the third that ends at the same note; however I included a chart for 10ths to make things just a little easier. You can check 11ths, 12ths, and 17ths with the charts for 4ths, 5ths, and Major 3rds or 10ths. There have been a number of articles published in the Piano Technicians' Journal describing how to listen to and tune intervals below and above the temperament octave to help determine how much to stretch.
How to get the Beat Rate Spreadsheet? Just click the "buy now" button below and I will send you the spreadsheet in the form of an email attachment, to the email address that you use with PayPal, or to any email address you enter in the special instructions box on the PayPal form, or if you want to download the Beat Rate Spreadsheet from a web page, just let me know – I'll send you an email with an address you can click on and a user name, then I'll send a second email with a password. There you can download ths spreadsheet. Just unzip the downloaded zip file, and you'll have the spreadsheet and the instructions (the instructions open in Microsoft Word). Or for an extra $2.00, I'll mail the unzipped spreadsheet to you on a CD. Once I get a paypal or credit card payment I normally respond with the attachment or the download page within 48 hours, but if I am out of town, or have an emergency, occasionally I may take longer. If you are in a hurry, you may want to contact me by email, or phone (number below), to make sure I am paying attention to my email and my paypal account.
Any questions? Questions about the spreadsheet before you buy? You can email me or just send me a note on the form, here. If you use the form be sure to include your email address! This particular form doesn't check to see if you've included your email address or not. It just sends me whatever you have filled in, and sends you a copy. If you don't get a copy, very likely I won't get one either! Or you can also telephone me, at (828) 348-8088, 9 am to 8 pm EST. You can find my mailing address here. Also our email address. And after you buy the Beat Rate Spreadsheet, we will be glad to provide you with technical support for using this spreadsheet. I am a piano tuner, I was a professional tuner-technician, and I love music, musical instruments, mathematics, and pianos.
For the time being we are suspending sales of the spreadsheet.
If you'd like, you can get a free sample here of the beat rate calculator spreadsheet. If you are not sure what to expect from the full spreadsheet, or if you want to confirm that the full spreadsheet will work on your computer, then download the free sample. Save the *.zip file to a directory or to your desktop, then unzip it. Open the *.xls spreadsheet file with Excel. Open the *.doc instructions with Word (write or call if you need help). Note that the free sample is a limited version of the spreadsheet. It shows the partials and beat rates for all the fifths. It shows the partials and beat rates for one octave of fourths. Also, it is missing the feature to change A49 from 440 hz, to any value you choose, and have the spreadsheet instantly recalculate all the pitches, coincident partials, and beat rates. The full spreadsheet shows all the fourths and also all the Major 3rds, minor 3rds, Major 6ths, minor 6ths, and 10ths.
This page created and published with assistance from Leafy Green Web Publishing