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

You are not logged in. #1 20101227 16:56:37
Calculating an Excel ColumnHave 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: I love Daisy! #2 20101227 18:13:10
Re: Calculating an Excel ColumnHi Wodd; 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. #3 20101228 08:44:39
Re: Calculating an Excel ColumnLowercase 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! #4 20101228 16:37:50
Re: Calculating an Excel ColumnHi Wodd;
Close enough! 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. #7 20101229 12:53:35
Re: Calculating an Excel ColumnHi Wodd;
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.
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. #9 20101229 18:31:05
Re: Calculating an Excel ColumnActually 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. 