Welcome to SpreadsheetWEB Blog
INDEX & MATCH: A Better Way to Look Up Data
VLOOKUP and HLOOKUP are the go-to functions for most Excel users to look up data in a table. However, there is an alternative to this function that can do the same job, with added benefits. It’s the INDEX and MATCH combo. Using these two formulas in conjunction can...
Using SUMPRODUCT to Do Your Taxes
It’s that time of the year! Of course there are all kinds of tools out there you can use to calculate and submit your taxes for the last year, but it’s always a good idea to double check everything and if you prefer to do everything by hand, you might find this guide...
Working with Large Data Grids in SpreadsheetWEB Applications
Although used widely in many data models, submitting large data grids with significant amount of data have always been a problem in web application projects. There are many industry specific examples where a web user has to paste a large data table into a web...
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...