-= Frank Black Forum =-
-= Frank Black Forum =-
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Tabs and Trading
 Tabs & Musician Stuff
 Fun with Excel

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
hammerhands 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
2   L A T E S T    R E P L I E S    (Newest First)
Kirk Posted - 12/16/2005 : 08:44:54
This stuff should be illegal. It's hurting our children!
Suicide_Samurai Posted - 12/15/2005 : 09:32:55
I smell an oxymoron.

-= Frank Black Forum =- © 2002-2020 Frank Black Fans, Inc. Go To Top Of Page
Snitz Forums 2000