This is not really a technical discussion, but I find this fact very intriguing. I am reading John Walkenbach's Excel 2007 VBA Programming For Dummies, and it says that Excel has the capacity to go up to the 60th dimension in arrays. Is this even possible? How do I imagine 60 dimensions? Am I hallucinating? Is this logically possible even if it may be practically useless?
In Astronomy, there is length, width, breadth, and time. The first three dimensions govern space. The latter one governs time.
In Computer Programming, what in the world is the 60th dimension?
Has anyone tried to use Excel to test dimensions above 3 so that one can grasp the concept much more easily? Or is this concept just a mathematical curiosity and imagination at work?
Last edited by Hestha; 12-31-2011 at 09:28 PM. Reason: add additional question
It's beyond my ken.
Try this link for starters http://en.wikipedia.org/wiki/Large_Hadron_Collider maybe 60 is small bait?
maybe he means 60X60 grid
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Actually, in string theory there is 11-dimensional M-theory that determine space-time. Answer is: no, you can not have 60.Originally Posted by Hestha
In Astronomy, there is length, width, breadth, and time. The first three dimensions govern space. The latter one governs time.
In Computer Programming, what in the world is the 60th dimension?
In Excel you can use 2D array and not more. So it's talking about some other dimensions there.
"Relax. What is mind? No matter. What is matter? Never mind!"
etceterasSub Example() Dim av1(1 To 1, 1 To 2, 1 To 3) End Sub
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Except with VBA
"Relax. What is mind? No matter. What is matter? Never mind!"
Actually 3D is possible in excel.In Excel you can use 2D array and not more
=SUM(Sheet1:Sheet3!A1:C5)
Guess you are right...
"Relax. What is mind? No matter. What is matter? Never mind!"
I read somewhere that fluid dynamics and weather analysis equations can have dozens of variables. So (I think) the 60th dimension is a set of 60 equations with 60 variables... (maybe?)
---
Ben Van Johnson
I run out of memory after 9 dimensions...
Sub test() Dim v(1, 2, 3, 4, 5, 6, 7, 8, 9) As Variant End Sub
If thats what John W says Jacks not going to argue -- but hang on
If you VBA or SQL vis Excel and so on my guess anything possible subject to processing power, then You get into Cubes and so on (Head hurts now)
Not read the book, intresting
Johns a pretty good guy Jack reliably told, theres nothing on the internet covering this which is a little odd, does happen thou somestuff never gets public
You can write matrix for 60 or 10.000 dimensions. You can calculate with it, in math there is no problem.
But the other thing is number of equations for solving a problem:
a pen is twice longer than a marker.
a pen and marker are 30 cm long.
Those a two equations but only one dimension.
For different dimension they all should be orthogonal comparing one to the other.
"Relax. What is mind? No matter. What is matter? Never mind!"
The help says,
Although I found Excel crashing when using more than about 10 dimensions.subscripts Optional. Dimensions of an array variable; up to 60 multiple dimensions may be declared. The subscripts argument uses the following syntax:
[lower To] upper [, [lower To] upper] . . .
When not explicitly stated in lower, the lower bound of an array is controlled by the Option Base statement. The lower bound is zero if no Option Base statement is present.
Andy
Thus see Jacks post above
Regards
jiuk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks