Welcome to SpreadsheetWEB Blog
Crunch Data Even Faster with Excel SUMIFS Function
SUMIF function, as the name suggests, sums up the values in a range of cells, if a certain criteria is met. What if you want to compare multiple checks and add different columns? That’s where its older brother, SUMIFS, come into play. SUMIFS can do the exact same...
Common Formula Errors in Excel
Troubleshooting issues in Excel can be easier than you might think, if you know how to interpret error messages. Error messages almost always start with a hashtag, followed by the error code. We’ve prepared this guide to help you understand the way errors are handled...
Comparing the Performance of SpreadsheetWEB's Calculation Engine with Excel
Recursive simulations of spreadsheet models constitute one of the more advanced uses of Excel across various industries, although perhaps most commonly in the financial services industry. Often, third-party add-ins are utilized to run Monte-Carlo simulations in Excel....
Reducing Formula Errors in Excel
Following certain guidelines when working in Excel can save you the headache of dealing with errors. And if something does go wrong with a formula, there are things you can still do. Let’s take a look at some recommended methods for creating formulas, and how to...
Improvements in Workbook Loading Times in Version 6.0
The first time that a SpreadsheetWEB application is invoked in a user session, the underlying workbook is loaded into memory on the server . This will affect the response time of the first calculation in proportion to the complexity of the workbook. Larger and more...
Performance Improvements in Version 6.0
One of our primary undertakings for the SpreadsheetWEB 6.0 release was a major dedicated effort to improve the performance of our core spreadsheet calculation engine. The calculation engine was written in C++ and is optimized for server-side processing, focusing...
Transforming a Complex Pricing List into a Quoting Tool in Excel – Part 2
In Part 1 of this article, we created a quoting tool from a relatively big pricing list using Excel. In this guide, we’re going to transform this spreadsheet into a full blown web application that can be published and shared with other users. To do this, we’re going...
Transforming a Complex Pricing List into a Quoting Tool in Excel – Part 1
Do you have a rather complicated pricing list with too many product combinations you would like to open to your clients? In this two-part guide, we’re going to show you how you can convert that huge table into an interactive quoting tool using Excel. Let’s take a look...
10 Most Useful Shortcuts in Excel
Although the computer mouse is an essential tool in desktop navigation, Excel power users rarely use it to interact with their workbooks. This gives them an edge to do everything far more rapidly, as there is a shortcut pretty much every action in Excel. You might be...