Excel Offloading

The execution of compute-intensive Microsoft Excel workbooks with independent calculations can sometimes be scaled using a cluster. The integration of Windows HPC Server 2008 R2 SP2 with Windows Azure supports User Defined Function (UDF)-offloading. Excel workbook calculations that are based on UDFs defined in an XLL file can be installed on the cluster’s nodes (on-premises and/or Windows Azure). With the XLL installed on the cluster, the user can perform the UDF calls remotely on the cluster instead of locally on the machine on which the Excel workbook is open.

Hands-On Labs

  • Asian Options UDF

    This sample demonstrates how to accelerate the execution of a compute-intensive Microsoft Excel workbook by offloading the UDF to a Windows HPC cluster.