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

Hi ,my dear friend , yahya

Have you heard my experiments ?

/tuning/files/shaahin/

and

/tuning/files/
</tuning/files/>

source of these 3 file was made in C-major of 12-edo.

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 Yahya Abdal-Aziz
Sent: Wednesday, April 26, 2006 7:42 AM
To: tuning@yahoogroups.com
Subject: [tuning] RE: about ratio to cent : RE: The 79-tone qanun
pitches

On Tue, 25 Apr 2006 Ozan Yarman grumbled:
>
> 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
[snip]
> 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
[snip]
> 2- you can right click on desired column , go to format cell ,
> numbering , fraction.

Howdy Oz! Thought you were the Excel(lent) Wizard? ;-)

In Excel 2000, this method is limited to at most 3 digits in the
numerator (top number) and denominator (bottom number).

To bypass this limitation, I instead:
select cells, Format, Cell , Number, Custom, Type: # ?????/?????

Use as many ? symbols as you need digits.

(I haven't checked it in the XP version of Excel.)

Despite appearing as vulgar fractions, these numbers are stored
by Excel as decimal fractions, as can be seen in the edit box on
the formula bar. (However, if you type, eg, 123456/987654 into
a cell with the custom number format type # ?????/?????, Excel
recognises that this has too many digits and stores it as a simple
text string.)

Supposing you have enough digits in your custom number format
type, Excel does store the decimal number, as I said, and this is
easy to use in formulae.

For example, I typed in the ratios:
1/3, 2/4, 3/5 ... 9/11
in column C, then formatted them as type # ?????/????? as
above. They appeared exactly as I wished. I then added these
ratios to the bottom of the column:
99/111, ... 999999/1111111, 9999999/11111111.

Interestingly, the last three also appeared as fractions. However,
they were not numbers - I added the numbers:
3, 4, 5, ... 17
in column B to their left; and in column D, to the right, a formula
with the product of the two columns, eg D4 = B4*C4.

The results appear below:
3_____1/3_____1.00000
4_____1/2_____2.00000
5_____3/5_____3.00000
6_____2/3_____4.00000
7_____5/7_____5.00000
8_____3/4_____6.00000
9_____7/9_____7.00000
10_____4/5_____ 8.00000
11_____9/11_____9.00000
12_____33/37_____10.70270
13_____999/1111_____11.68947
14_____9999/11111_____12.59887
15_____99999/111111_____#VALUE!
16_____999999/1111111_____#VALUE!
17_____9999999/11111111_____#VALUE!

Notice the fraction 1/2 appearing for 2/4, etc. Every
fraction is reduced. The last three rows don't work
because the apparent fractions 99999/111111 etc have
more digits than I specified in the format.

HTH,
Yahya

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.6/324 - Release Date: 25/4/06

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.

to yahya , from shaahin : RE: [tuning] RE: about ratio to cent : RE: The 79-tone qanun pitches

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

🔗Ozan Yarman <ozanyarman@ozanyarman.com>