Math Is Fun Forum
  Discussion about math, puzzles, games and fun.   Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫ • π ƒ -¹ ² ³ °

You are not logged in.

#1 2010-12-26 17:56:37

Wodd
Member
Registered: 2010-12-26
Posts: 11

Calculating an Excel Column

Have you ever wondered what lies behind that mysterious labeling system that Microsoft uses for Excel? It is a system of alphabetical strings that can be converted to numbers using the following polynomial function:
(26[sup]string length - 1[/sup] * letter position) + (26[sup]string length - 2[/sup] * letter position) + (26[sup]string lengh - 3[/sup] * letter position) + … + (26[sup]string length - n[/sup] * letter position)
The function in action:
(26[sup]4[/sup] * 4) + (26[sup]3[/sup] * 1) + (26[sup]2[/sup] * 9) + (26[sup]1[/sup] * 19) + (26[sup]0[/sup] * 25)
As you could probably guess based on the formula and the numbers used that this decodes the word daisy (1,852,083). I have also decoded much more complex things as well such as weird (10,604,884) and Fluffy Puff Marshmallows. I do not recall the number for Fluffy Puff Marshmallows though. What I would like to do though is do this formula in reverse. I would like to figure out the equivalent string for the number 16,777,216. Does someone know how I can accomplish this? By the way, what does the math tag do? I am not familiar with it.


I love Daisy!

Offline

#2 2010-12-26 19:13:10

bobbym
Administrator
From: Bumpkinland
Registered: 2009-04-12
Posts: 83,159

Re: Calculating an Excel Column

Hi Wodd;

The math tag is for creating latex, the universal math typesetting language.

For instance:

In excel speak 16 777 216 is ajrnin. fluffypuffmarshmallows = 3 364 209 625 414 419 611 165 053 917 829.

I did not account for capitals or spaces.


In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

Offline

#3 2010-12-27 09:44:39

Wodd
Member
Registered: 2010-12-26
Posts: 11

Re: Calculating an Excel Column

Lowercase and uppercase is irrellivant. How did you do these? Based on how quickly the response seems to have come, I am guessing that you did not use Excel to find the number for Fluffy Puff Marshmallows and the phrse for 16,777,216 because if you did, then it probably did not come as quickly as I as thinking. As far as I know, Excel does not allow inserting the alphabet and dragging it to test these (though perhaps it does and I am just unaware of it). Based on your description of the math tag, it essentially changes the font face to look more like is often seen for mathematical expressions—like the bold or italic tag.


I love Daisy!

Offline

#4 2010-12-27 17:37:50

bobbym
Administrator
From: Bumpkinland
Registered: 2009-04-12
Posts: 83,159

Re: Calculating an Excel Column

Hi Wodd;

more like is often seen for mathematical expressions—like the bold or italic tag.

Close enough!

I did those 2 using 2 specialized math programs. Attempts to do them by mathematical methods are extremely difficult as far as I know. If you need more I can run them off for you.


In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

Offline

#5 2010-12-28 05:23:06

Wodd
Member
Registered: 2010-12-26
Posts: 11

Re: Calculating an Excel Column

I will have to think here. Two specialized math programs to do the calculations—hmmm:
1. Wolfram
2. Unsure, but perhaps something like another supercalculator


I love Daisy!

Offline

#6 2010-12-28 13:34:25

Wodd
Member
Registered: 2010-12-26
Posts: 11

Re: Calculating an Excel Column

What were those programs. I am going to guess that, based on the fact that there is a topic entitled Coder's Corner, that you programed ≥ 1 of those programs. lol


I love Daisy!

Offline

#7 2010-12-28 13:53:35

bobbym
Administrator
From: Bumpkinland
Registered: 2009-04-12
Posts: 83,159

Re: Calculating an Excel Column

Hi Wodd;

that you programed ≥ 1 of those programs. lol

Nope. Last bit of real programming I did was the creation of my own Computer Algebra system. I was rolling pretty good, producing 2 or 3 hundred lines of C++ code a day.
Then one day I ran across Mupad 1.4. It was amazing and freeware and ahead of mine. I put down my coders pen and never wrote another line of C++, Lisp, Basic or any other.

1. Wolfram
2. Unsure, but perhaps something like another supercalculator

Everyone seems to know Wolfram but less know of its arch enemy Maple which is superior in some ways. Also there are Mupad, Derive, Sage, Maxima...


In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

Offline

#8 2010-12-28 16:07:36

Wodd
Member
Registered: 2010-12-26
Posts: 11

Re: Calculating an Excel Column

I think that I recognize the name Mupad. It seems familiar. I am not exactly sure where from, but it seems somehow familiar. Strange


I love Daisy!

Offline

#9 2010-12-28 19:31:05

bobbym
Administrator
From: Bumpkinland
Registered: 2009-04-12
Posts: 83,159

Re: Calculating an Excel Column

Actually a very good program, shame they got bought up my Matlab.


In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

Offline

Board footer

Powered by FluxBB