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

Thank you for the excel-lent tips brother! They are sure to come in handy as
the file gets juicier in detail. Could you tell me if I got the
beat-frequencies right on the second sheet?

Cordially,
Oz.

SNIP

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