KDCalc

What's New in V5.1?

• Support for 16 new Excel functions including CUMIPMT, XIRR, NORMINV, SLOPE, and more
• Several Charting improvements 

What's New in V5.0?

• KDCalc now supports Charting
• KDCalc 5.0 can convert Excel spreadsheets into complete, multi-platform web applications and Dashboards, including active charting
• Faster Compile times
• Smaller file sizes and faster load times
• New support for the ADDRESS function

What's New in V4.2.4?

• Support for one new Excel function

What's New in V4.2.3?

• KDCalc 4.2.3 can convert Excel spreadsheets into complete, multi-platform web applications
• Support for one new Excel function
• Faster Compile times
• Smaller file sizes and faster load times

What's New in V4.2.2?

• Support for two new functions
• New Application Templates

What's New in V4.2

• KDCalc 4.2 can convert Excel spreadsheets into complete, multi-platform web applications
• KDCalc 4.2 adds support for Excel's UI controls (Check Box, Combobox, Command Button, Option Button, Sliders, Spinners, etc.) so if you use them in your Excel file they will be integrated into your web application
• Significant improvements in load time, compile time, execution speed, runtime memory usage, and file size
• Support for several new functions
• New demos and tutorials

The KDCalc Designer installs right into the Excel toolbar - one click compiles your spreadsheets into complete business applications with high-speed calculations and interactive user interfaces. Choose 100% managed .NET or 100% pure Java for your runtime platform.

The KDCalc Engine is thread safe, lightweight, and far more scalable than Excel. If your application has no user interface or if you develop one by hand, you can use the KDCalc Engine to execute the business logic you've developed in Excel. Simply pass input data into the compiled spreadsheet and retrieve recalculated results through the intuitive API. The KDCalc Engine supports large (>20MB) spreadsheets and massively parallel calculations.

KDCalc turns your business users' Microsoft Excel spreadsheets into highly scalable enterprise applications.

Banks, Insurers, Governments, and Academic Institutions around the world use KDCalc to speed development of all kinds of mission-critical systems. If your company has become reliant on Excel workbooks for business decisioning, but needs to migrate the Excel-based business logic into server side applications for scalability, compliance, auditing, and management reasons, KDCalc will help you go directly from Excel to server applications. Your Business logic is still maintained in Excel and you will preserve your investment in your Excel-based intellectual property. End-users will benefit from having the same look and feel that they are familiar with as KDCalc faithfully transforms the formulas, charts, formatting, data, and UI controls into web applications.

Some examples of systems built by KDCalc customers:

• Executive Dashboards
• End User Reporting
• Product Configuration Validation and Price Quoting
• Actuarial Calculation Systems
• Insurance Decisioning for underwriting, broker quoting, and renewals
• Annuity and benefit calculations
• Insurance reserves and pension reserves applications
• Mortgage pricing
• Trading systems algorithms
• Sales commission calculation
• HR tax / deduction / withholding
• Calculation plug-ins for SAP / ABAP / BusinessOne, PeopleSoft, SalesForce.com
• Logistics
• Grid Computing
• Portfolio Planning
• SCORM-compliant eLearning simulations
• Optimization Simulations, Expert Systems, and Artificial Intelligence
• Numerous OEM products

and many other kinds of interactive client applications and scalable server applications.

KDCalc can generate complete web applications from your Excel spreadsheets using pre-defined templates for ASP.NET, JSP, and HTML. With any web editor, you can easily customize the application templates to include your own logos, security, authentication, logging, and live data access.

Or you can create your own user interface using any UI technology, including Flash, Director, VB.NET, C#, or Java. 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 includes tabbed spreadsheet controls (for both Java and .NET) for instantly integrating a tabbed spreadsheet grid into your applications.

Customers have deployed KDCalc-based applications with over 1,000,000 formula cells.

Download the 'Spreadsheet Programming' white paper to learn how KDCalc can help you create a web service to calculate sales tax globally, or try any of the numerous full-source demos to see how KDCalc can work for you.

The KDCalc Engine is lightweight, scalable, and integrates into many environments:

• Excel is not needed on the execution machine
• KDCalc supports over 200 Excel functions
• KDCalc compiled spreadsheet files are usually less than 1/20th 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 )

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

• Accepts an XML document as an argument containing

• Returns an XML document containing recalculated results from the requested cells

The KDCalc Engine for .NET is a 100% managed .NET assembly:

• Great for .NET Web Services, ASP.NET, WebForms, WinForms, DHTML
• Includes a KDCalcDataAdapter class to support simple and complex data binding of 3rd party UI controls to the KDCalc.NET Engine
• KDCalc.NET engine is only about 200K
• Works with .NET framework 1.0 and higher

• Great for Java Web Services, JSP, EJB, DHTML, servlets, applets, applications, Flash and Director
• KDCalc Java engine is only about 118K
• Works with Java JRE 1.1 and higher

The KDCalc Designer plug-In lets you design your business logic and business computations in Excel, and then generate a complete, component oriented web application for execution:

• KDCalc Designer plug-in installs right into the Excel toolbar
• Just click to generate a compiled, compressed, executable .KDC file
• Automatically generate ASP.NET, ASP Classic, JSP, or HTML pages as a user interface.
• Much more efficient than hand-coding complex algorithms in Java, C#, or VB.NET
• Allows non-programmers to be responsible for building and verifying business logic
• Works with Excel 2000 or higher