Calculation Server


Calculation Server is another product provided by PrimeThought  is a component which allows Excel Workbook logic to be deployed and executed in a SQL Server database, or a .NET application

Thus you get re-usability of Excel workbooks outside of Microsoft Excel.

This is particularly useful if you want to do the following:

1.)  Migrate Excel workbook logic to another system

2.)  Use Excel as a design tool for building logic, to test and then to re-use elsewhere

3.)  Move Excel workbooks into a SQL Server database



By using named ranges in Excel, you can with ease transfer usability through CalculationServer, since the same named ranges name inputs and outputs.


 
 
Calculation Server and CalculationXL White Paper  

 
Calculation Server, CalculationXL and Excel Case Study
 
  
Block model processing using Calculation Server and Powershell