WhatIf - Google Workspace Marketplace

Replicates the Excel "What-If Analysis" feature, Data Tables.

By:

Listing updated:May 12, 2024

Works with:

63K+

Overview

This is an open-source add-on!  It aims to replicate the What-If features found in Excel.

This version includes support for creating Data Tables, which generates model outputs for univariate or bivariate models.

If you have any feedback, please leave a review, or visit the project page at 
https://github.com/sajacy/google-sheets-what-if-analysis 

Usage
==========
After installing the add-on, you should have a menu item: "What-If Analysis" > "Create Data Table".

This will try to create a Data Table from the currently-selected cell range.

For example, to create a 2-dimensional (bivariate) Data Table, you need to select a range where the model output (formula) is the top-left cell, and where the two sets of values are provided along the first row and first column. The add-on will fill in the rest of the cells.

To create a univariate Data Table, select 2 columns, with the model output (formula) in the first row, second-column, and the test values in the first column.

Data Refresh
==========
For performance reasons, Data Tables are not recalculated automatically.

Use the "What-If Analysis" > "Refresh Data Tables" menu item to refresh all data tables.

You can also delete data tables by deleting the associated Named Range (Data > Named Ranges), which will be named in the form of DataTable_RxCy. The deleted cell range will no longer be considered a "Data Table" and you may freely edit / clear the cells as normal.

Additional information

PricingFree of charge

Developer

Non-trader

Support

ReportFlag as inappropriate

Reviews

Language:

Sort by:

Google doesn't verify reviews or ratings. Learn more about reviews

Sam Margo

February 28, 2023

Works really well, as expected. But, I tried to redownload it and Google blocked it - hope the developer can work through this issue!

Is this review helpful?

Yes

MaryAlice Peng

December 9, 2021

Took me about 20-30 minutes to understand the instructions (click "Support" at the bottom of the overview page) and mess around with a copy of the example sheet, but once I did, it was smooth sailing! This worked beautifully on an absolute monster of a model. THANKS JEFFREY!!

Is this review helpful?

Yes

Azib Hasan

February 17, 2021

Worked well for 1-V data table.. but got all the wrong answers for 2-V table... thanks for the effort though.. Speed is very slow for execution, but I expected that to be slower considering it is an add-on. Apart from this, the enter key and tab key are not registered while on the add-on. Also, the cell selection has to be done by entering the cell number, it can't be selected..

Is this review helpful?

Yes

Eric Post

November 6, 2020

Does the job but I'm creating a sports simulation with 2500 events and it takes several minutes to run. On Excel it takes about 2 seconds...

Is this review helpful?

Yes

Evan Lynch

March 20, 2021

Worked great!

Is this review helpful?

Yes

A User of WhatIf

October 2, 2019

Can you pls provide a better explanation of how to make a bi-variate table model work. How to prepare the table, precisely which ino to feed in the prompts ? thanks. A simple example sheet would be great too :-)

Is this review helpful?

Yes

A User of WhatIf

May 28, 2020

works great

Is this review helpful?

Yes

A User of WhatIf

October 1, 2019

works fine for both one-variable and two-variable data tables, thanks Jeffrey!

Is this review helpful?

Yes

L L2

November 10, 2021

Monte Carlo like excel!

Is this review helpful?

Yes

A User of WhatIf

July 1, 2018

Works fine for creating a data table. I use it for sensitivity analysis. Enter A1 for a cell not "A1" as they say though.

Is this review helpful?

Yes

1-10 of 19

Clear search

Close search

Google apps

Main menu