Super Computing with Excel

I guess its one of lifes little mysteries how Microsoft can put a childish toytown interface on Excel, yet at the same time re-engineer its deepest scariest innards to work in High Performance Computing Clusters. (Noddy and Big Ears go to a 20 node teraflop cluster?)

Anyway its a very interesting proposition, and note this is different to Excel services. This is the full client operating as part of a cluster. This will allow (certain) VBA to be parallelised. This is a big deal. I understand there are a few restrictions on the features this new approach will support but it still sounds massive. (for restrictions think along the lines of current restrictions for UDFs.)

There are now a somewhat confusing array of Excel/Server products, not all of which are endowed with Magnificent Microsoft Margeting Monikers yet.

There is Excel services that lets you stick a workbook on Sharepoint and let people access and modify their version of it via a browser. This does not support VBA, it is well connected with .net instead. In 2010 ES gets some big updates, one of the most useful being the ability to load a workbook with unsupported features and let ES do what it can. In O2007 ES would only work with .xlsx for example, in O2010 you can use an .xlsm with VBA, it will load and the grid part will work. The VBA and other unsupported features won’t work but they don’t force you to use 2 versions, full fat and ES approved anymore.

There are the web apps, I don’t know anything about them. But I assume they are a limited browser based clunky pale reflection of the real office client.

There are thread safe xlls that can be offloaded to a cluster, this is an extension of the multi threaded calc in E2007.

And there is this new richer cluster feature which isn’t quite putting the full client on a server but it allows you to offload certain calculation and VBA activities to a cluster. I’m not sure the full feature set is settled yet but it sounds just the job for massive simulations where you pump in some numbers, calc some stuff, hold some intermediate results then load some new numbers etc etc.

There is some other good stuff in 2010 that I’ll be talking about as time goes on, in particular the development story.

I’d have more to say but I hosed my TP build to make way for the Beta, only to have major external drive hassles trying to install it. So currently I don’t have a working 2010 (or 2007 actually). Ooops!

cheers

Simon

Advertisements

5 Responses to “Super Computing with Excel”

  1. Harlan Grove Says:

    Nothing beats getting the wrong answer 100 times faster!

  2. Steve Says:

    and add vsto to the mix….

  3. Simon Says:

    VSTO with O2010 and VS2010 looks seriously usable, anything prior is pants.
    (I know some will disagree, but the 2010/2010 story is what VSTO 1.0 should have been way back)

  4. Biggus Dickus Says:

    But what about the deployment story? I still can’t get my head around that to get any interest in VSTO. In fact with Excel ANY deployment beyond distributing an XLS(X) file is more than the clients (read IT) can handle or will allow. How am I going to convince them to accept all the overhead with .NET and what about the inevitable future breakage when someone does something beyond our control?

    Oh I forgot – this NEW Excel will be implemented by IT and managed by IT – how stupid of me :-) – And I have some swampland in Florida for sale too.

    Dick

  5. hoshi Says:

    On the other note, forget Excel and have a look at Palo Suite especially Palo Web(ramp up version 3.1) – http://www.palo.net. It is OpenSource and has everything Excel 2010 will not have any time soon. Needless to say zero footprint – you can do everything from your Web Browser – ‘zero IT’. It features multithreaded spreasheet engine capable of doing all the stuff Excel can do.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: