Do XL12's MINVERSE and MDETERM handle arrays larger than 51 rows by 51
columns? Also, does the array formula
=MMULT(TRANSPOSE(ROW(1:100000)),ROW(1:100000)) return 3.3333833335E+14
[from the formula for the sum of squares from 1 to N = N (N+1) (2N+1) /
6]? Increase 100000 to 1000000, and does it return 3.333338333335E+17 ?
Or do the NDAs prevent you from saying?

You haven't dl'd beta 2 ?

I haven't either! If I could get just Excel and not the whole Office suite
I'd love to play with it.

Biff

"Harlan Grove" wrote in message
ups.com...
Do XL12's MINVERSE and MDETERM handle arrays larger than 51 rows by 51
columns? Also, does the array formula
=MMULT(TRANSPOSE(ROW(1:100000)),ROW(1:100000)) return 3.3333833335E+14
[from the formula for the sum of squares from 1 to N = N (N+1) (2N+1) /
6]? Increase 100000 to 1000000, and does it return 3.333338333335E+17 ?
Or do the NDAs prevent you from saying?

Biff wrote...
You haven't dl'd beta 2 ?
....

No Passport ID, no d/l or by mail, and there's no way I'll voluntarily
ever get a Passport ID. If Password IDs are required for activation of
the final shipping product, guess I'll be sticking with Excel 97 and 2K
at home. At work I don't have to activate.

hi Harlan,

MINVERSE and MMULT work , have not tried MDETERM but expect that will work
as well.


regards
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Harlan Grove" wrote in message
ups.com...
Do XL12's MINVERSE and MDETERM handle arrays larger than 51 rows by 51
columns? Also, does the array formula
=MMULT(TRANSPOSE(ROW(1:100000)),ROW(1:100000)) return 3.3333833335E+14
[from the formula for the sum of squares from 1 to N = N (N+1) (2N+1) /
6]? Increase 100000 to 1000000, and does it return 3.333338333335E+17 ?
Or do the NDAs prevent you from saying?

NDA only permits discussion of what has already been publically disclosed.

http://blogs.msdn.com/excel/

Is a good place to start for new features and extensions of old features.

http://blogs.msdn.com/excel/archive/...26/474258.aspx

refers to a complete elimination of limits on size of array formulas.

FYI Excel 2003 handles larger arrays with MDETERM.

Jerry

"Harlan Grove" wrote:

Do XL12's MINVERSE and MDETERM handle arrays larger than 51 rows by 51
columns? Also, does the array formula
=MMULT(TRANSPOSE(ROW(1:100000)),ROW(1:100000)) return 3.3333833335E+14
[from the formula for the sum of squares from 1 to N = N (N+1) (2N+1) /
6]? Increase 100000 to 1000000, and does it return 3.333338333335E+17 ?
Or do the NDAs prevent you from saying?

Hi Jerry,

Any NDA does not apply to any results one gets from testing the publicly
available Beta2.
MSoft expects that the public forums will be a support point for the public
beta.

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Jerry W. Lewis" wrote in message
...
NDA only permits discussion of what has already been publically disclosed.

http://blogs.msdn.com/excel/

Is a good place to start for new features and extensions of old features.

http://blogs.msdn.com/excel/archive/...26/474258.aspx

refers to a complete elimination of limits on size of array formulas.

FYI Excel 2003 handles larger arrays with MDETERM.

Jerry

"Harlan Grove" wrote:

Do XL12's MINVERSE and MDETERM handle arrays larger than 51 rows by 51
columns? Also, does the array formula
=MMULT(TRANSPOSE(ROW(1:100000)),ROW(1:100000)) return 3.3333833335E+14
[from the formula for the sum of squares from 1 to N = N (N+1) (2N+1) /
6]? Increase 100000 to 1000000, and does it return 3.333338333335E+17 ?
Or do the NDAs prevent you from saying?

Harlan Grove wrote...
....
Or do the NDAs prevent you from saying?

Since the NDAs don't prevent discussing how the public beta actually
works, another question. When the UI gets in the way, it's nice to get
rid of it COMPLETELY. Does XL12 support the equivalent of the following
(**WARNING** USE IN A **SECOND** EXCEL INSTANCE) in older versions?


Sub ugh()
Dim x As CommandBar
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = False
For Each x In Application.CommandBars
x.Enabled = False
Next x
End Sub


This leaves only the row/column frame and the worksheet tabs, if they
were already visible. I've read in the blog that the ribbon can be
colapsed to just its tabs, but can it be COMPLETELY HIDDEN/DISABLED?

FWIW, Excel history buffs will recall that XL5 had a brand new menu
compared to XL4, *and* Microsoft provided an option in XL5 that
REPLACED the new XL5 menu with the XL4 menu. [Microsoft failed to
provide an option in the XL4 menu that switched back to the XL5 menu,
making for much joy using the product.] Is there an equivalent feature
for XL12? Or is this New Coke before Coca Cola Co realized the revenue
potential of also [also?! - do they still make New Coke?] selling
Classic Coke?

Hi Harlan,

I know there has been some discussion of this amongst Access people, but I
dont know the outcome.
You certainly cannot do it using the commandbars model, you would have to
use the XML stuff, and I have not looked at that in enough detail to know
the answer.

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Harlan Grove" wrote in message
oups.com...
Harlan Grove wrote...
...
Or do the NDAs prevent you from saying?

Since the NDAs don't prevent discussing how the public beta actually
works, another question. When the UI gets in the way, it's nice to get
rid of it COMPLETELY. Does XL12 support the equivalent of the following
(**WARNING** USE IN A **SECOND** EXCEL INSTANCE) in older versions?


Sub ugh()
Dim x As CommandBar
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = False
For Each x In Application.CommandBars
x.Enabled = False
Next x
End Sub


This leaves only the row/column frame and the worksheet tabs, if they
were already visible. I've read in the blog that the ribbon can be
colapsed to just its tabs, but can it be COMPLETELY HIDDEN/DISABLED?

FWIW, Excel history buffs will recall that XL5 had a brand new menu
compared to XL4, *and* Microsoft provided an option in XL5 that
REPLACED the new XL5 menu with the XL4 menu. [Microsoft failed to
provide an option in the XL4 menu that switched back to the XL5 menu,
making for much joy using the product.] Is there an equivalent feature
for XL12? Or is this New Coke before Coca Cola Co realized the revenue
potential of also [also?! - do they still make New Coke?] selling
Classic Coke?