Calc4Web converts spreadsheet calculations to callable subroutines, Excel custom functions, and cloud calculations automatically without coding

Organizations often want to make their spreadsheet calculations available to others, and perhaps not just inside an Excel spreadsheet, but outside of an Excel spreadsheet, inside other types of systems and applications or over the Internet.

That’s where Calc4Web comes in. Calc4Web will convert the spreadsheet model to C++ code, and compile that into:

• Callable subroutines (DLLs) which can be called by programs written in any high level language, such as C/C++, Visual Basic, or Java. This makes your Excel calculations portable to any platform, even Linux
• Excel custom functions (XLLs/UDFs) which can be called from inside other Excel spreadsheets as add-ins. Converting a large block of spreadsheet cells into a single call function makes the spreadsheet easier to understand and manage, as well as more secure
• Web Services, a powerful cloud-based paradigm that allows functions to be called over the Internet by anyone, anywhere, at any time. Web Services can be used not only on Web pages, but also by any application, including Excel, which has Internet access. With Calc4Web, Excel calculations and models can now go global as they can be used by anyone, anywhere, at any time

Calc4Web makes spreadsheet calculations work in other systems and as cloud calculations

Calc4Web's powerful conversion and code generation technology allows you to make your spreadsheet calculations work in front-, middle,- and back-office systems and over the internet automatically in record time: Weeks of work can now be done in minutes resulting in integrations of spreadsheet calculations that are as much as 500 times faster.

How is this possible? Since Calc4Web automatically reprograms parts or all of the Excel spreadsheet in C++, a huge part of the work that's normally involved in Excel migrations is already done for you. Because the programmer no longer has to reprogram the spreadsheet, he doesn't have to go through the process of learning and understanding the logic behind it, saving both his time and, perhaps more importantly, the Excel user's time. And, because the spreadsheet has now been reprogrammed by a machine, not by a person, it doesn't need to undergo the extensive testing and bug fixing that's normally involved in any code development effort. In fact, all the bug fixing and testing can now be done in Excel before the conversion to C++. All of these steps save a great deal of valuable time and result in migrations of Excel calculations that take minutes, not weeks or months. And, as powerful as it is, Calc4Web is also one of the simplest programs you'll ever use. Simply load up your spreadsheet, and push a button to make the magic happen.

And Calc4Web will work with any Excel spreadsheet calculation, even if you use Excel's built-in functions, the Analysis Toolpak, VBA or even add-in functions from third-party vendors.

The Calc4Web Paradigm

Calc4Web works on calculations: numbers go in, and valuations come out. It's what you use Excel for: to figure out the fair value of an investment, or the expected profits for a firm, or the amount of money you need to put away to retire, or the cash flows on a portfolio, or any of a million other things. In every case, there's a set of inputs that drive the calculation, and an output that you're interested in arriving at.

Calc4Web takes a spreadsheet you've built, and after being told which cells hold the inputs and outputs, it takes all the calculations in between the inputs and the outputs and turns them into a new program. It doesn't throw away your spreadsheet, it just makes a new copy of the model in C++, and then compiles it into binary code. This code can work inside Excel, as an AddIn function, or outside Excel, to be called from C, C++, Visual Basic or any other high level programming language. Or even as a Web Service.

How fast is the binary code? Lightning fast. As fast as if someone had manually rewritten the spreadsheet formulas in C++. Because that's exactly what Calc4Web has done.

Since the binary code can be used as an Excel add-in function, you're now free to use it in your spreadsheet, replacing the output cells with a single formula using the newly created function, and getting rid of all the other cells.

The binary code created by Calc4Web is a file that the computer knows how to read, but not people. This means that modelers can distribute the binary code, instead of the spreadsheet, to other users, without worrying about the recipients inadvertently breaking the spreadsheet by accidentally adding rows or columns without fully understanding the implications. In addition, proprietary algorithms can now be kept from prying eyes, allowing for safer and wider distribution of intellectual property.