Replicates the Excel "What-If Analysis" feature, Data Tables.
Listing updated:May 12, 2024
Works with:
65K+
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
Privacy policy
Terms of service
WhatIf will ask for the permissions shown below. Learn more
WhatIf will need access to your Google account
This will allow WhatIf to :
View and manage spreadsheets that this application has been installed in
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Elham Jahangiri
September 29, 2024
Why Google blocked it? I can not use it!
Is this review helpful?
Yes
No
Profile Picture
Nick
September 19, 2024
Google blocks it so I can't run it.
Is this review helpful?
Yes
No
Profile Picture
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
No
Profile Picture
A User of WhatIf
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
No
Profile Picture
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
No
Profile Picture
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
No
Profile Picture
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
No
Profile Picture
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
No
Profile Picture
Evan Lynch
March 20, 2021
Worked great!
Is this review helpful?
Yes
No
Profile Picture
A User of WhatIf
March 4, 2019
Would love this feature in Google sheet but i cannot get a two way data table to work...
Is this review helpful?
Yes
No
1-10 of 21
Search
Clear search
Close search
Google apps
Main menu