|
hammerhands
* Dog in the Sand *
Canada
1594 Posts |
 Posted - 12/15/2005 : 06:23:35
|
Each semitone from 440 can be found
=440 * 2 ^ (1 / 12)
the "1" inside the bracket is the number of half steps from A.
Frequency to Cents conversion
=LOG(444 / 440, 2) * 1200
415 G#/Ab -1.270624748
423.5 G#/Ab +33.83013497
436 A -15.8104665
444 A +15.66738339
452 A +46.58309867
454 Bb -45.77347148
Build an interesting Frequency to Cents Table
H2 440
G2 =H2*2^(-1/12)
(copy this to F2 through A2)
I2 =H2*2^(1/12)
(copy this to J2 through N2)
A3 302
A4 =A3+1
(copy this to A5 through A342)
(you could do this in half or quarter hz intervals)
B3 =IF(ABS(LOG($A3/B$2,2)*1200)<=50,LOG($A3/B$2,2)*1200,"")
(copy this to B3 through N342)
The column headers are:
hz, Eb, E, F, F#, G, G#/Ab, A, Bb, B, C, C#, D, Eb |
|
Fun with Excel
