Welcome to SpreadsheetWEB Blog
Use Excel for Regression Analysis to Make Better Predictions
What is Regression Analysis? The regression analysis is a statistical method that can estimate the relationship between two or more variables. This method can provide a better understanding of how the value of the dependent variable changes, when one of...
Developing a Life Insurance Quoting Software with SpreadsheetWeb
Life Insurance Quoting Software development is challenging because of two main reasons. First, most life insurance quoting calculations are difficult and depend on many factors. Incorporating many factors and tying them to various databases can be a...
How to Use Excel Sparklines for Better Looking Tables
What is a Sparkline?A sparkline, also known as an ‘inline chart’, is a very small chart that can fit inside a single cell. Sparklines are drawn without axes or coordinates to give an immediate visual representation of trends in data. The idea behind this...
Root Cause Identifier: Excel Pareto Chart
What is a Pareto Chart?A Pareto Chart is a combination of a bar and a line charts, essentially using both in a single visualization. This chart type is especially useful for comparing the importance of items against other factors. Ideally suited for...
Actuarial Models in Excel
Most actuaries are experts in Excel and love the tool. Actuarial model one of the most common usages of the software, since it makes it a breeze to build complex mathematical models and test them under various conditions. In this article, I will walk you...
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,...