You are here:

Advanced Math/Microsoft Excel Column Name Updates.

Advertisement


Question
Dear Prof Scott

http://en.wikipedia.org/wiki/Microsoft_Excel
http://office.microsoft.com/en-in/excel/
http://www.microsoft.com/en-in/download/details.aspx?id=10
http://spreadsheets.about.com/od/tipsandfaqs/f/excel_use.htm
http://en.wikipedia.org/wiki/IP_address


Do you feel Column Name changes from A, B, C to 1., 2., 3., 4. will have more advantages over the current
column name as A,B,C ... i.e. Similar to IP Address example 115.252.130.182

The Record/s names will remain the same as 1,2,3 ....

Examples :

1.

For example A1 refers to Column 1, Row 1 and has value as 3 so we refer the cell value as A1=3
Now instead of A1=3, we will refer as 1.1=3

2.

For example C4 refers to Column 3, Row 4  and has value as Hello so we refer the cell value as C4=Hello
Now instead of C4=Hello, we will refer as 3.4=Hello

Advantages
----------

Since the column name is changed from character to whole number(integer), the values in the column can go take any limits.

For example :

999.56 refers to column  999 and  row 56
3456.43 refers to column  3456 and  row 43

Note : Column Name should be changed to 1. (i.e. 1 followed by a Dot) and not only 1 because if we keep only 1 then for example 123 creates a ambiguity of which is the column i.e. 1 or 12.

In this example 123 will lead to column 1 , row 23 or column 12, row 3    

Correct :

12.3 refers to column 12, row 3
1.23 refers to column 1, row 23

Awaiting your reply,

Thanks & Regards,
Prashant S Akerkar

Answer
Some people might get confused as to which is a column and which is a row.  Even though the column is 1st all the time, some people may think the row is first and end up in the wrong place.
Using letters as column labels allows the column labels to be narrower when needed.
For example, out in column 100, 100 has 3 letters whereas CV {yes, CV is 3-22,
which is 3*26 + 22 =  78 + 22 = 100 } only has 2.

Out in column 676, 676 is three digits whereas ZZ { 676 is 26*26 } is only 2.
Out in column 17576, 17576 has 5 character whereas ZZZ { 16576 = 26*26*26 } is only 3.
This doesn't seem important, but it might be.  I think the first argument is more realistic.

That was a good point about cell 123 where 1.23 would be different that 12.3.  In the upper left corner of the spreadsheet, most cells are 2 characters whereas putting a decimal in the middle makes them 3 characters.

It might also require a lot more thought when F4 is striked { F4 puts in dollar signs },
for the user would need to remember whether the row or column came first.

Advanced Math

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scott A Wilson

Expertise

I can answer any question in general math, arithetic, discret math, algebra, box problems, geometry, filling a tank with water, trigonometry, pre-calculus, linear algebra, complex mathematics, probability, statistics, and most of anything else that relates to math. I can also say that I broke 5 minutes for a mile, which is over 12 mph, but is that relevant?

Experience

Experience in the area; I have tutored people in the above areas of mathematics for over two years in AllExperts.com. I have tutored people here and there in mathematics since before I received a BS degree back in 1984. In just two more years, I received an MS degree as well, but more on that later. I tutored at OSU in the math center for all six years I was there. Most students offering assistance were juniors, seniors, or graduate students. I was allowed to tutor as a freshman. I tutored at Mathnasium for well over a year. I worked at The Boeing Company for over 5 years. I received an MS degreee in Mathematics from Oregon State Univeristy. The classes I took were over 100 hours of upper division credits in mathematical courses such as calculus, statistics, probabilty, linear algrebra, powers, linear regression, matrices, and more. I graduated with honors in both my BS and MS degrees. Past/Present Clients: College Students at Oregon State University, various math people since college, over 7,500 people on the PC from the US and rest the world.

Publications
My master's paper was published in the OSU journal. The subject of it was Numerical Analysis used in shock waves and rarefaction fans. It dealt with discontinuities that arose over time. They were solved using the Leap Frog method. That method was used and improvements of it were shown. The improvements were by Enquist-Osher, Godunov, and Lax-Wendroff.

Education/Credentials
Master of Science at OSU with high honors in mathematics. Bachelor of Science at OSU with high honors in mathematical sciences. This degree involved mathematics, statistics, and computer science. I also took sophmore level physics and chemistry while I was attending college. On the side I took raquetball, but that's still not relevant.

Awards and Honors
I earned high honors in both my BS degree and MS degree from Oregon State. I was in near the top in most of my classes. In several classes in mathematics, I was first. In a class of over 100 students, I was always one of the first ones to complete the test. I graduated with well over 50 credits in upper division mathematics.

Past/Present Clients
My clients have been students at OSU, people who live nearby, friends with math questions, and several people every day on the PC. I would guess that you are probably going to be one more.

©2016 About.com. All rights reserved.