Servers

    Accelerating Excel® 2010 with Windows® HPC Server 2008 R2: Converting Cluster-Safe UDFs for Offloading to a Windows® HPC Cluster

    Language:
    English
    This article and accompanying code samples address how to convert convert an existing XLL file to enable offloading to a Windows HPC 2008 R2 cluster. The article also explains how UDF offloading works, performance considerations, and how to determine if a UDF is appropriate for cluster offloading.
    • Details
      Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      August 2010

      File Name:

      BuildingHPCEnabledUDFs.docx

      BuildingHPCEnabledUDFs.zip

      Date Published:

      9/21/2010

      File Size:

      380 KB

      161 KB

        Note: Article and samples were updated for this release of Windows HPC 2008 R2. For more information about updating Excel solutions from Beta 2 , see the Excel Workbook Offloading Beta Transition Guide.

        Microsoft Excel 2010 extends the UDF model to the cluster by enabling Excel 2010 UDFs to run in a Windows HPC 2008 R2 cluster. In the cluster, UDFs work much like traditional UDFs, except that the calculation is performed by one or more servers. The key benefit is parallelization. If a workbook contains calls to long-running UDFs, multiple servers can be used to evaluate functions simultaneously.

        In order to run on the cluster, the UDFs must be evaluated as appropriate for a cluster, marked as cluster-safe, and then the XLL file must be recompiled. This article walks through an example of how to convert an existing XLL file. The article also explains how UDF offloading works, performance considerations, and how to determine if a UDF is appropriate for cluster offloading..

        The associated zip file includes:
        • Solutions for Visual Studio 2008 and Visual Studio 2010 for the sample XLL
        • Two sample securities pricing workbooks that uses the UDF in the sample XLL
        • XLL SDK files to support the sample code


        Note: The workbooks contain macros. When you open the workbook, you may see a security warning indicating that the macros have been disabled. You can enable the macros by clicking "Enable Content".

        Note: Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose.

    • Supported Operating System

      Windows HPC Server 2008 R2

        Microsoft Word of Word Viewer, Microsoft Excel 2010, Windows HPC Server 2008 R2 cluster, Visual Studio 2008 or 2010
        • To start the download, click the Download button, and then do one of the following:
          • To start the download immediately, click Open.
          • To copy the download to your computer for viewing at a later time, click Save.
          • To cancel the download, click Cancel.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial