Frequencies?

[John Delacour]

At 10:48 PM -0800 21/2/02, Stephen Airy wrote:
>Here's a method to figure it out, not accounting for
>inharmonicity.  Since A4 is 440 Hz, an octave lower is
>1/2 the frequency, or 220 Hz.  A0 is the lowest note
>on the piano, being 27.5Hz.  Multiply 27.5 by the 12th
>root of 2 (1.0594630943593 on my TI-92 Plus),  and
>multiply each result by 1.0594630943593 88 more times.
>
>For example:
>
>27.5 (A0)
>27.5 * 1.0594630943593 = 29.135235094881 (A#0)...

In a spreadsheet, if a cell named "FORK" is given the value of A_49 
(eg. 440) and the column containing the note numbers is named "NOTE", 
then the following formula filled down through a column will give the 
frequencies.  To change the values, you need only to change the value 
of "FORK".



                      =FORK*(2^((NOTE-49)/12))




FORK	442.00

	NOTE	f

C	-8	16.43
C#	-7	17.40
D	-6	18.44
D#	-5	19.53
E	-4	20.70
F	-3	21.93
F#	-2	23.23
G	-1	24.61
G#	0	26.07
A	1	27.63
A#	2	29.27
B	3	31.01
C	4	32.85