One areas where the new R2 excels (pun intended) is the integration of the cluster with Microsoft Excel 2010. In several areas such as financial services, companies use Excel to calculate massive spreadsheets that can take up to (I kid you not) one month to complete. That is right, a spreadsheet that takes one month to generate results.
In order to alleviate the incredible computing power that these spreadsheets required, Microsoft Excel 2010 in conjunction with HPC Server 2008 R2 Enterprise allows you offload calculations from Excel to the cluster. This includes VBA code that runs within the spreadsheet to XLLs that run on each of the compute nodes. I’ll try to cover these on another post, but in a nutshell, spreadsheets can finish in a matter of hours tasks that could take weeks before.
ScorpioTek consultant Christian Saborío had the chance to deliver the “Accelerating Excel 2010 with Windows HPC Server 2008 R2” training events in Australia during the week of November 21st. The first training was delivered in Melbourne followed by a delivery of the same training on Sydney. Attendees in both events were very inquisitive about the features, best practices, and demos that were presented.
Our most sincere kudos to Boris Manitius, who was an incredible host during our visit to one of the most amazing countries in the whole wide world.