Yahoo Tuning Groups Ultimate Backup tuning Fw: about ratio to cent : RE: [tuning] The 79-tone qanun pitches

Try as I might, I cannot convert fractions such as 81/80 to their real number values in the new column I want to link to the cents column and hide from view. All I could do was to copy-paste what was already in the ratios column. Any suggestions?

Oz.

----- Original Message -----
From: Ozan Yarman
To: tuning@yahoogroups.com
Sent: 25 Nisan 2006 Salı 18:20
Subject: Re: about ratio to cent : RE: [tuning] The 79-tone qanun pitches

But you see, I wish to be able to modify the fractions in the column in question on demand, to evaluate if other ratios are approximated to my liking as well. Why won't Excel divide 81 by 80 when I give the link in the adjacent cell for calculating cent values? I want the program to produce the real numbers for the fraction I type in one column in the other column.

Or maybe I should copy the column containing the ratios to a hidden column that converts them to real numbers first? Maybe that might work...

Cordially,
Oz.
----- Original Message -----
From: Mohajeri Shahin
To: tuning@yahoogroups.com
Sent: 25 Nisan 2006 Salı 13:08
Subject: RE: about ratio to cent : RE: [tuning] The 79-tone qanun pitches

Dear ozan

1- You can do all these calculation in some columns and then hide them.

2- you can right click on desired column , go to format cell , numbering , fraction.

In such a way , excell convert each A/B to for example ( a 1/b ) which now you can calculate to cent.

In these 2 ways you can have your column of A/B and columns of your calculations which are hide.

Shaahin Mohaajeri

🔗Dave Keenan <d.keenan@bigpond.net.au>

--- In tuning@yahoogroups.com, "Ozan Yarman" <ozanyarman@...> wrote:
>
> Try as I might, I cannot convert fractions such as 81/80 to their
> real number values in the new column I want to link to the cents
> column and hide from view. All I could do was to copy-paste what
> was already in the ratios column. Any suggestions?

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

-- Dave Keenan

🔗Dave Keenan <d.keenan@bigpond.net.au>

🔗Ozan Yarman <ozanyarman@ozanyarman.com>

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
>
>

🔗Mohajeri Shahin <shahinm@kayson-ir.com>

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

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/> .

________________________________