Published: July 2010
By: Duncan Werner, Managing Member, Structured Data LLC
HPC Services for Excel supports a variety of new programming models that allow you to run Excel calculations on an HPC cluster. In this article we’ll discuss how to useExcel VBA macros to build workbooks that utilize an HPC cluster to run calculations in parallel. To support HPC Services for Excel, your workbook needs to include a set of macros that implement the asynchronous functions. This article describes the macro framework and how to define calculations within the framework. This article includes an example of how to build a workbook from scratch, and anexample of converting an existing workbook to run on a cluster.
This is a preliminary document and may be changed substantially prior to final commercial release of the software described herein.
The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing marketconditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.
This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is theresponsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.
Microsoft may have patents, patentapplications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.
Unless otherwise noted, the example companies, organizations,products, domain names, e-mail addresses, logos, people, places and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, email address, logo, person, place or event is intended or should be inferred.
© 2010 Microsoft Corporation. All rights reserved.
Microsoft, Excel, SQL Server, Visual Basic, Visual Studio, Windows, and Windows Vista areregistered trademarks of Microsoft Corporation in the United States and/or other countries.
The names of actual companies and products mentioned herein may be the trademarks of their respective owners.
Intended Audience 4
Download Files 5
Structure and Formatting 5
Asynchronous Calculation 6
Iterative Calculation and Parallel Calculation 7
The MacroFramework 8
Building Cluster-Enabled Workbooks with Excel 2010 and HPC Services for Excel 10
Before You Start: Prerequisites and Requirements 10
On the cluster 10
On the desktop 12
Part I: Building a workbook from scratch 13
Starting a new workbook 14
Preparing the workbook 14
Defining the calculations in the macro framework 17
Running the workbook locally and exploring themacros 19
Adding a button that runs the workbook locally 19
Modifying the HPC_Excecute and the HPC_Merge macros 20
Modifying the HPC_Initialize macro 22
Running the workbook on the cluster 22
What happens when a workbook runs on the cluster 25
Communicating calculation progress 26
Part 2: Converting a “desktop” workbook to run on the HPC cluster 30
Analyzing the workbook 30