INDEX & MATCH: A Better Way to Look Up Data

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

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

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

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

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...
Reducing Formula Errors 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

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

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...