Welcome to SpreadsheetWEB Blog
Create an Excel Heat Map
What is a Heat Map? A heat map is a two-dimensional graphical representation of data, where values are represented by a color scale in a matrix layout. Color-coded cells allow easily identifying the outliers and see the patterns in your data. Excel’s...
Why Insurance Companies should embrace Spreadsheets-as-a-Backend to transform the way they program business logic
Insurance operations often rely heavily on complex business logic. For example, actuaries analyze large amounts of internal and external data in order to estimate base rates and various factors for their insurance products. They develop rating and quoting...
What’s New in SpreadsheetWeb 6.5
SpreadsheetWEB has been shipping with its own built-in data visualizations tools for years now. Collecting data with your applications, and then creating dashboards using that data effortlessly is a boon for every SpreadsheetWEB user. With version 6.3, we...
Creating a Complex Questionnaire with Calculations
Questionnaires are a great way to collect customer insight or gather key information from others. There are many online tools to build and distribute questionnaires. However, they typically work well if your questionnaire doesn’t have too many questions,...
User Defined Functions in Excel
User Defined Functions (UDFs in short) are, as the name suggests, functions whose properties are custom defined by the user. They can be tailored to specific user needs and greatly improve productivity as they can help you do things built-in Excel features can’t. For...
Excel Database Functions
Database functions are designed to perform simple operations on data that is in a “database-like structure”. Database-like structure means that the data must be in a table structure that has organized records with labels and appropriate separation. In this...
Forecasting in Excel
What is Forecasting? Forecasting is a technique to establish relationships and trends which can be projected into the future, based on historical data and certain assumptions. This method can be utilized to better understand and make an educated guess on...
All You Need to Know for Using Excel Iterative Calculation
Iterative calculations can help find the solution to mathematical problems by running calculations over and over using previous results. This is made possible by computers that can run calculations repeatedly to find the likelihood of possible answers by...
How and Why of Running a Simulation in Excel
A simulation is commonly defined as an imitation of a situation or process. This typically entails creating a mathematical model that represents the characteristics and other features of a system. The model then can be used to simulate how the system will...