Jeffrey Yang
•  8,525
Overview
Replicates the Excel "What-If Analysis" feature, Data Tables.
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.

Reviews
Language:
Sort by:
Profile Picture
A User of WhatIf
May 28, 2020
works great
Is this review helpful?
Yes
No
Profile Picture
A User of WhatIf
May 22, 2020
it's not worked as native excel function
Is this review helpful?
Yes
No
Profile Picture
Vincent Josse
October 11, 2019
Sorry - not nearly as performant as Excel's native function...
Is this review helpful?
Yes
No
Profile Pciture
A user of WhatIf
May 15, 2020
The calculation speed just got upgraded. Give it another shot!
Profile Picture
Marc Thrum
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
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
A User of WhatIf
September 15, 2019
Could you provide a sample file? Having trouble getting this to work.
Is this review helpful?
Yes
No
Profile Picture
Charles Hale
April 9, 2019
Not supporting references in other sheets makes this one tougher to use than NickBritz's Sensitivity Table --- but thank you for making and publishing this
Is this review helpful?
Yes
No
Profile Pciture
A user of WhatIf
May 15, 2020
This limitation has been fixed! The latest version is also faster and fixes some usability issues, such as supporting DataTables after moving the cells.
Profile Picture
Jamie Robinson
April 4, 2019
Is returning #VALUE! error
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
Profile Picture
A User of WhatIf
February 7, 2019
Basic functionality but does it well.
Is this review helpful?
Yes
No
1-10 of 14
Additional information
Jeffrey Yang
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu