none
Excel-HPC solutions RRS feed

  • Question

  • I'm confused and have some questions.

    I took a look at the Microsoft Excel-Compute cluster server ADAPTER demo. 
    "The Excel CCS adaptor sample makes its User Defined Function calls through job submission, COM Proxy and file shares"

    It's unclear for me whether I need the Office Sharepoint Excel Services on the compute nodes or not.
    Will it need the Microsoft.Office.Excel.Server.Udf.dll stuff ?  If not what is the difference between the both approaches?


    Is there a solution to use Excel  UDF together with  WCF SOA model in a HPC environment?

    What is the timeframe and meaning for the following statement? (Office 14?)
    "We will be looking at more ways to integrate Excel-HPC solutions in the near future."



    Wednesday, December 17, 2008 9:32 PM

Answers

  • Hi Goldfinger,

    Sorry for the confusion with Excel. There are three ways to use Excel with Windows HPC Server.

    1. Offload UDF Calls
      In this scenario UDF (User Defined Function) calls that would normally execute against local .XLL files are remoted to run against .XLLs hosted on compute nodes. In this scenario the .XLLs must be installed on the cluster nodes but you do not need Excel or Excel Services installed on the compute nodes.
    2. Offload WCF Calls
      In this scenario the Excel workbook calls out to WCF services running on the cluster. Ming Xu, our program manager for WCF integration with HPC Server, has put together a nice video showing how this works. Here is the link for the video: http://resourcekit.windowshpc.net/MORE_INFO/AsianOptions.html
    3. Excel Services with HPC Server
      In this scenario Excel Services can be run on the cluster. What we've found talking with customers is that this isn't particularly interesting in HPC scenarios since customers want to either use the workbook as a front end for calculations against the cluster (first two options above) or they have workbooks with VBA code (not presently supported in Excel Services).

    As for future integration with Excel, that is work we're just getting started on and we don't have anything to announce. We certainly understand that many users want to use a familiar environment like Excel, Matlab, or Mathematica and have the environment automatically offload to the cluster. We'll do more work to make this seamless in the future, not only with Excel, but with other applications like Matlab, Mathematica, and more.

    Hope that helps.


    Ryan Waite - Product Unit Manager - Windows HPC
    • Marked as answer by goldfinger Saturday, January 17, 2009 12:34 PM
    Tuesday, January 6, 2009 6:34 PM

All replies

  • Hi Goldfinger,

    Sorry for the confusion with Excel. There are three ways to use Excel with Windows HPC Server.

    1. Offload UDF Calls
      In this scenario UDF (User Defined Function) calls that would normally execute against local .XLL files are remoted to run against .XLLs hosted on compute nodes. In this scenario the .XLLs must be installed on the cluster nodes but you do not need Excel or Excel Services installed on the compute nodes.
    2. Offload WCF Calls
      In this scenario the Excel workbook calls out to WCF services running on the cluster. Ming Xu, our program manager for WCF integration with HPC Server, has put together a nice video showing how this works. Here is the link for the video: http://resourcekit.windowshpc.net/MORE_INFO/AsianOptions.html
    3. Excel Services with HPC Server
      In this scenario Excel Services can be run on the cluster. What we've found talking with customers is that this isn't particularly interesting in HPC scenarios since customers want to either use the workbook as a front end for calculations against the cluster (first two options above) or they have workbooks with VBA code (not presently supported in Excel Services).

    As for future integration with Excel, that is work we're just getting started on and we don't have anything to announce. We certainly understand that many users want to use a familiar environment like Excel, Matlab, or Mathematica and have the environment automatically offload to the cluster. We'll do more work to make this seamless in the future, not only with Excel, but with other applications like Matlab, Mathematica, and more.

    Hope that helps.


    Ryan Waite - Product Unit Manager - Windows HPC
    • Marked as answer by goldfinger Saturday, January 17, 2009 12:34 PM
    Tuesday, January 6, 2009 6:34 PM
  • Is other technic such as microsoft peer to peer network applied to HPC environment?
    Monday, September 14, 2009 1:50 PM
  • Unlocker tool utility from <a href="www.unlocklertool.com">www.unlocklertool.com</a> works fine
    Tuesday, November 17, 2009 4:35 AM