---

Please note: This page was retired in July 2004.

You can find current information from the links below

Publisher

• Knowledge Dynamics (1)

Categories

• Artificial Intelligence (4)
• Business Rules (16)
• Financial (42)
• Maths and Stats (33)
• Function and Source Libraries (7)
• Spreadsheet (47)

If you need to buy a license for this specific version, please contact us for availability and pricing.

Other information on this page is shown for historical reference only and may have changed considerably since.

---

Compile your Excel spreadsheets into enterprise applications for .NET. The KDCalc Parser installs right into the Excel toolbar - one click compiles your spreadsheets into scalable, thread safe, business logic engines that run without Excel. Use Microsoft Excel as an IDE to Design, Build, and Test your complex business logic up to 50 times faster than hand-coding in C# or VB.NET. The KDCalc Engine is a .NET assembly that provides your business logic at runtime. Simply pass input data into the compiled spreadsheet and retrieve recalculated results through the intuitive API. Supports simple and complex binding of 3rd party controls and grids to the KDCalc Engine in Windows forms and ASP.NET.

KDCalc lets you use Microsoft Excel as a development environment for building enterprise business logic and business computation engines.

Banks, Businesses, and Academic Institutions around the world use KDCalc to rapidly build and deploy all kinds of mission critical systems:

• Price Quoting
• Insurance and Loan Underwriting
• Dynamic Pricing and Intelligent Cross-Selling based on inventory levels
• Sales Tax and Payroll Deduction Calculations for SAP / ABAP
• Simulations, Expert Systems, and Artificial Intelligence

and many other kind of interactive client applications and scalable server applications. Customers have deployed KDCalc-based applications with over 400,000 cells.

An intuitive API allows consistent access to your spreadsheets' business logic and calculations at runtime. Simply call SetCellValue(Row, Col, Value) to put values into data cells, and call GetCellValue(Row, Col) to get results out of formula cells. You can also communicate via named cells with the SetNamedCellValue(Name, Value) and GetNamedCellValue(Name) methods.

KDCalc supports over 200 of Excel's built-in functions. With Excel functions like LOOKUP, OFFSET, IF, SUMPRODUCT, etc, you can create remarkably sophisticated systems in record time. Business users can have seamless visibility into your application's core functionality. KDCalc.NET includes a tabbed spreadsheet control for instantly integrating a tabbed spreadsheet grid into your applications.

Download the 'Spreadsheet Programming' white paper to learn how KDCalc can help you create a web service to calculate sales tax globally.

The KDCalc Engine is a lightweight, scalable .NET assembly that integrates into many environments:

• Great for Web Services, ASP.NET, WebForms, WinForms, DHTML, and even Flash
• Excel is not needed on the execution machine
• Includes a KDCalcDataAdapter class to support simple and complex data binding of 3rd party UI controls to the KDCalc.NET Engine
• KDCalc supports over 200 Excel functions
• KDCalc.NET engine is only about 200K
• KDCalc compiled spreadsheet files are generally less than 1/5 the size of the original Excel file
• Scales way beyond the throughput capacity of Excel for server applications
• Intuitive API: SetCellValue() for inputs and GetCellValue() for recalculated results
• Programmatically access worksheets by Name or by Sheet Index
• Programmatically access cells and ranges by Name or by Row, Col
• Works with .NET framework 1.0 and higher

The KDCalc Engine features a 'ProcessXML()' method suitable for turning Excel Spreadsheets into business logic Web Services. In a single method call, ProcessXML():

• Accepts an XML document as an argument containing
  • input values for multiple cells
  • requests for recalculated results from multiple cells
• Returns an XML document containing recalculated results from multiple cells

The KDCalc Parser Plug-in lets you design your business logic and business computations in Excel, and then compile to a lightweight format for execution:

• KDCalc Parser Plug-in installs right into the Excel toolbar
• Just click to generate a compiled, compressed, executable .KDC file
• Much more efficient than hand-coding complex algorithms in C# or VB.NET
• Allows non-programmers to be responsible for building and verifying business logic
• Works with Excel 2000 or higher

KDCalc includes many sample applications with full source code. The free evaluation version of KDCalc provides all the functionality of KDCalc but is limited to cells A1 - E10 on the first two worksheets.