to dave keenanRE: Fw: about ratio to cent : RE: [tuning] The 79-tone qanun pitches

Excuse me dave

I must have mentioned you , for your formula. Thanks you

I'm working on a sheet to produce ADO and ...... considering your
solution and other things.

Shaahin Mohaajeri

Tombak Player & Researcher , Composer

www.geocities.com/acousticsoftombak

My tombak musics : www.rhythmweb.com/gdg

My articles in ''Harmonytalk'':

www.harmonytalk.com/archives/000296.html

www.harmonytalk.com/archives/000288.html

My article in DrumDojo:

www.drumdojo.com/world/persia/tonbak_acoustics.htm

________________________________

From: tuning@yahoogroups.com [mailto:tuning@yahoogroups.com] On Behalf
Of Mohajeri Shahin
Sent: Wednesday, April 26, 2006 8:27 AM
To: tuning@yahoogroups.com
Subject: RE: Fw: about ratio to cent : RE: [tuning] The 79-tone qanun
pitches

Hi

Thanks to dear carl for his good help.

Shaahin Mohaajeri

Tombak Player & Researcher , Composer

www.geocities.com/acousticsoftombak

My tombak musics : www.rhythmweb.com/gdg

My articles in ''Harmonytalk'':

www.harmonytalk.com/archives/000296.html
<http://www.harmonytalk.com/archives/000296.html>

www.harmonytalk.com/archives/000288.html
<http://www.harmonytalk.com/archives/000288.html>

My article in DrumDojo:

www.drumdojo.com/world/persia/tonbak_acoustics.htm
<http://www.drumdojo.com/world/persia/tonbak_acoustics.htm>

________________________________

From: tuning@yahoogroups.com [mailto:tuning@yahoogroups.com] On Behalf
Of Ozan Yarman
Sent: Wednesday, April 26, 2006 3:36 AM
To: tuning@yahoogroups.com
Subject: Re: Fw: about ratio to cent : RE: [tuning] The 79-tone qanun
pitches

Allah bless you! Your help is very much appreciated indeed. 8-)

Attached is the Excel file with the completed columns. The rest should
not
be too hard from here.

********

I usually put numerator and denominator in separate colums. Then one
can use a textual formula like =A1&"/"&B1 to generate the fraction
(or =MIN(A1,B1)&":"&MAX(A1,B1) to generate an interval ratio).

In that case the real number is simply
=A1/B1
and the cents are
=LOG(A1/B1,2)*1200.

However, if you already have them in the form "81/80" then use the
following formula which extracts the numerator and denominator
textually before dividing them.

=LEFT(A1,FIND("/",A1)-1) / RIGHT(A1,FIND("/",A1)-1)
and the cents are of course
=LOG(LEFT(A1,FIND("/",A1)-1)/RIGHT(A1,FIND("/",A1)-1),2)*1200

> Oops! I gave wrong formulas in my previous message. The "RIGHT" part
> was wrong. They should have been:
>
> If you already have them in the form "81/80" then use the
> following formula which extracts the numerator and denominator
> textually before dividing them.
> =LEFT(A1,FIND("/",A1)-1) / RIGHT(A1,LEN(A1)-FIND("/",A1))
> and the cents are of course
> =LOG(LEFT(A1,FIND("/",A1)-1)/RIGHT(A1,LEN(A1)-FIND("/",A1)),2)*1200
>
> -- Dave Keenan
>
>

You can configure your subscription by sending an empty email to one
of these addresses (from the address at which you receive the list):
tuning-subscribe@yahoogroups.com - join the tuning group.
tuning-unsubscribe@yahoogroups.com - leave the group.
tuning-nomail@yahoogroups.com - turn off mail from the group.
tuning-digest@yahoogroups.com - set group to send daily digests.
tuning-normal@yahoogroups.com - set group to send individual emails.
tuning-help@yahoogroups.com - receive general help information.

________________________________

YAHOO! GROUPS LINKS

* Visit your group "tuning </tuning>
" on the web.

* To unsubscribe from this group, send an email to:
tuning-unsubscribe@yahoogroups.com
<mailto:tuning-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________