StrongTyping for Excel spreadsheets

diliger will help qualify your requirements and introduce you to the vendor

Spotted a missing vendor? Use this form to alert a vendor to the diliger service

Create a vendor selection project & run comparison reports

Register to access this feature

Click to express your interest in this report

Indication of coverage against your requirements

Vendor requires PRO subscription to activate this feature

Requires research subscription, contact diliger for more info

Overview

Strong Typinghas been developed to help highlight errors before they are incorporated into spreadsheet models and help create a reliable baseline for auditing spreadsheets.

Key Features

An add-in which allows formulas to be augmented with type meta-data to help ensure formulas work as intended or to highlight logical issues with formulas in a spreadsheet.

Benefits at a glance:

Use techniques from programming to improve error detection rates in models

Identify changes made by others that introduce errors

Create templates from models to re-use proven formulas

Document your models more thoroughly

Key Benefits

Huge numbers of people use Excel and it’s a testament to Excel’s ease of use that so many people feel able to use it. The problem is, because it is easy to use it only sees a list of numbers. Moreover, it makes assumptions on the user’s behalf which makes it really easy to do stupid things like add apples and oranges.

StrongTyping helps highlight logical inconsistences within and between formulas so you know which need to be fixed. Once the spreadsheet has been Strongly Typed and validated, spreadsheet models can be saved as a template which can be reused and shared with others.