Calc4Web Product Capabilities

Introductory Pricing Starts at $299. Free Calc4Web trial for Excel 2007 available for download!

Code math in seconds. Work10 times faster

Coding in a high level language like C++ or Java provides programmers with a great deal of power and control over the computer. Unfortunately, as any programmer knows, typically 10% of programming is coming up with the code to solve the problem, and 90% is debugging and testing that code. Calc4Web gives programmers a better way to get their job done: create a small spreadsheet which holds the logic, and push a button to turn that spreadsheet into C++ code that works on the first try, code that can be called from any language: C,C++, C#, Visual Basic, Java, and any other language which can call into DLLs.

With Calc4Web, debugging and testing of the code is no longer necessary as the code is machine generated. Any debugging and testing now means debugging and testing of the math at the Excel spreadsheet level before the calculations are converted to code. Since in an Excel spreadsheet, all values are clearly visible, you’ll find that debugging and testing of calculations at the Excel level is a breeze compare to that of debugging and testing at the code level.

In fact, since Calc4Web completely eliminates debugging and testing at the code level, Calc4Web drastically reduces program development time by as much as 90%.

Calc4Web is great for non-programmers, too. Because with Calc4Web, you don’t need to know C++ to generate C++ code, you merely need to know how to use Excel.

Use Excel calculations in other systems & as Web Services automatically

Excel spreadsheets allow millions of people to perform sophisticated analytics in their spreadsheets. But what if you want to share those Excel analytical tools with someone else over the internet or inside another system? Until now, that required hiring a programmer to convert the spreadsheet to a high-level language such as C++, and building a DLL that performs the same tasks as the spreadsheet.

Now, with Calc4Web, you don’t need that programmer: just push a button and Calc4Web will automatically create the C++ for you. Perfect C++ that works exactly the same as the spreadsheet does, on the first try, right away. Without the time spent getting the program to work; without the time spent debugging and testing. Saving you a great deal of time and money.

With Calc4Web, analytics that work inside Excel can now be used outside of Excel as well, in other applications and as Web Services over the Internet. So everyone you know can reap the benefits of your Excel Calculations.

How does Calc4Web do it?

Calc4Web features a patent-pending technology that automatically turns Excel calculations into .DLLs, .XLLs, and Web Services. Once Excel calculations are turned into callable subroutines (.DLLs), they are ready to be used by other applications even if those applications have been written in a language other than C/C++ such as Visual Basic or Java. The Calc4Web generated .DLL can be instantly called by and instantly integrated into any other system.

Calc4Web generated Web Services can be used by anyone, anywhere, and anytime over the Internet. Web Services are the wave of the future, and for good reason. Web Services allow pieces of executable code, such as a specialized mathematical calculation, to be used by any type of application, from anywhere in the world via the web. A web page can request the average US dollar/Euro exchange rate over the past three months using a Web Service. An investment application can calculate the probability a portfolio will earn 15% next year using a web service. A sales manager in the field can calculate his sales commissions on any given item using a Web Service. And much more.

The promise of Web Services largely relies on the savings that are realized by reusing existing business logic components, and making that logic available to anyone, anywhere, any time. However, that advantage is reduced by the work involved in getting the logic into the form of a Web Service. But thanks to Calc4Web, Web Services can now be created automatically, simply by pushing a button in an Excel spreadsheet. All (or part) of the logic contained in the spreadsheet’s formulas are converted to a compiled Web Service, ready to be called from anywhere by anyone on the web.

This means the enormous supply of mathematical algorithms that are sitting inside your spreadsheets can now be made available right away as Web Services with virtually no extra work required. These Web Services can be used by your IT department to leverage your knowledge base across the organization, or even made available to your customers for more streamlined and efficient interactions with your firm.

Secure spreadsheets. Hide proprietary algorithms from prying eyes

Excel is a powerful tool, but there are plenty of documented cases where multi-million dollar mistakes have been made due to carelessness and improper controls. Whether you’ve created a spreadsheet, inherited one, or are charged with making sure others don’t make these same mistakes, you don’t want to end up with a spreadsheet error that will cost you and your company money and time.

You need Calc4Web to help prevent these common accidents from happening:

  • Copying a formula without the dollar signs in the right place
  • Giving a spreadsheet to a coworker who doesn’t fully understand the logic, who edits it, and breaks it
  • Removing extra rows and columns that don’t seem to matter, and inadvertently getting rid of some that do

Since Calc4Web can convert any arbitrary section of the spreadsheet to a custom function that is callable, but not viewable or changeable, it effectively locks down the spreadsheet, and makes it tamper-proof.

And in this Sarbanes-Oxley world, spreadsheets need to be tamper-proof. It’s not just best practices, it’s the law.

Excel also gives users the ability to hide and password protect sheets and VBA modules. This feature attempts to protect trade secrets and intellectual property. Unfortunately, Excel’s password protection can be cracked almost immediately by any number of packages floating around the Internet for free, rendering it nearly useless.

But since Calc4Web compiles Excel spreadsheet formulas into DLLs and XLLs, no one else can see what’s going on inside the spreadsheet, because the formulas are no longer inside the spreadsheet. They have been moved into the DLL or XLL, and compiled into the 0’s and 1’s the computer understands, but people don’t. It’s not password protected, and crackable: it’s just transformed into something that looks like gibberish to anyone but a computer and is absolutely not crackable.

Run Excel faster. Create Excel custom functions (UDFs). No coding required

Many Excel spreadsheets run much slower than they need to. Often, a Monte Carlo simulation will take hours, or even days, to crunch out results. This is often the result of Excel custom functions, which are a great tool, but have a real cost when they are not written the right way. Calc4Web knows the right way, and can speed up spreadsheets heavy with VBA functions by up to 300 times.

Some companies also use Excel as a COM server, to embed a spreadsheet calculation inside their application. This is also incredibly slow. Calc4Web is the answer to this problem, too. We’ve had companies speed up their applications up to 5,000 times by simply running their spreadsheet through Calc4Web and bypassing Excel.

Calc4Web can’t speed up every Excel spreadsheet. But when it can, the results are nothing short of amazing. To those for whom Excel is a religion, Calc4Web performs miracles.

If you are an Excel Power User, you know about Excel custom functions (UDFs). Sure, Excel provides over 300 built-in functions, but often they don't perform the tasks specific to your needs. That's where custom functions come in. UDFs let you create your own specialized functions. However, UDFs require that you use VBA, Excel's macro language, or C++.

But what if you don't know VBA or C++? Well, with Calc4Web, you don't have to. Calc4Web will take any of your spreadsheet cells, and turn them into custom functions at the push of a button. So now you can have all the benefits of UDFs, without having to do any of the work (and Calc4Web can convert lots of VBA functions to C++, as well).

In fact, working with plain spreadsheet cells is much easier than working with VBA or C++. So much so, that even if you know how to use VBA or C++, you'll want to use Calc4Web. With Calc4Web, you'll be creating UDFs 10 times faster.

 

 
 

GET A FREE TRIAL OF CALC4WEB NOW

Fields with an asterisk are required.
First Name:

Last Name:
Company:
*Email (free trial will be sent here, we NEVER share it):
 

"Once you’ve used Calc4Web, you may find that you simply can’t be without it."

Rick Grehan, InfoWorld

"It's not just cool. It's simple."

Tom Yager, InfoWorld

"With Calc4Web, I'm able to write sophisticated C++ programs in minutes using only an Excel spreadsheet. Doing it directly in C++ would take several days."

Jerome Montpetit, Risk Manager, Canadian Financial Institution

"A highly specialized tool that can bring significant benefits to some development tasks."

Peter Aitken, DevSource

"Calc4Web does just one thing: converts Excel spreadsheets and VBA to C++ DLLs and addins. But the implications of this, and it's myriad uses, are much more far-reaching in terms of latency reduction and productivity enhancement."

Andy Webb, e-FOREX

     
  Copyright 2004-2007, Options Unlimited Research Corp.