Replicates the Excel "What-If Analysis" feature, Data Tables.
Listing updated:⧧⧍ āĻŽā§‡, ⧍ā§Ļ⧍ā§Ē
Works with:
ā§­ā§§Â āĻšāĻž+
āĻāĻ• āύāϜāϰ⧇
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
PricingāĻĢā§āϰāĻŋ
Developer
āύāύ-āĻŸā§āϰ⧇āĻĄāĻžāϰ
āĻ—ā§‹āĻĒāĻ¨ā§€ā§ŸāϤāĻž āύ⧀āϤāĻŋ
āĻĒāϰāĻŋāώ⧇āĻŦāĻžāϰ āĻļāĻ°ā§āϤāĻžāĻĻāĻŋ
āϰāĻŋāĻĒā§‹āĻ°ā§āϟ āĻ•āϰ⧁āύFlag as inappropriate
WhatIf will ask for the permissions shown below. Learn more
WhatIf will need access to your Google account
This will allow WhatIf to :
āϝ⧇ āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļā§€āϟāϗ⧁āϞāĻŋāϰ āĻŽāĻ§ā§āϝ⧇ āĻāχ āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϟāĻŋ āχāύāĻ¸ā§āϟāϞ āĻ•āϰāĻž āĻšā§Ÿā§‡āϛ⧇ āϤāĻžāĻĻ⧇āϰ āĻĻ⧇āϖ⧇ āĻ“ āĻĒāϰāĻŋāϚāĻžāϞāύāĻž āĻ•āϰ⧇
āφāĻĒāύāĻžāϰ āĻĒā§āϰāĻžāĻĨāĻŽāĻŋāĻ• āχāĻŽā§‡āϞ āφāχāĻĄāĻŋ āĻĻ⧇āϖ⧁āύ
āφāĻĒāύāĻŋ āϏāĻ°ā§āĻŦāϜāύ⧀āύāĻ­āĻžāĻŦ⧇ āωāĻĒāϞāĻ­ā§āϝ āĻ•āϰ⧇āϛ⧇āύ āĻāĻŽāύ āϝ⧇āϕ⧋āύāĻ“ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āϏāĻš āφāĻĒāύāĻžāϰ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āĻĻ⧇āϖ⧇
āϰāĻŋāĻ­āĻŋāω
Language:
āĻāχ āĻ…āύ⧁āϝāĻžā§Ÿā§€ āϏāĻžāϜāĻžāύ:
Google āϰāĻŋāĻ­āĻŋāω āĻ“ āϰ⧇āϟāĻŋāĻ‚ āϝāĻžāϚāĻžāχ āĻ•āϰ⧇ āύāĻžāĨ¤ āϰāĻŋāĻ­āĻŋāω āϏāĻŽā§āĻĒāĻ°ā§āϕ⧇ āφāϰāĻ“ āϜāĻžāύ⧁āύ
No comments
āϏāĻžāĻ°ā§āϚ āĻ•āϰ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŽā§āϛ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŦāĻ¨ā§āϧ āĻ•āϰ⧁āύ
Google āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϗ⧁āϞāĻŋ
āĻĒā§āϰāϧāĻžāύ āĻŽā§‡āύ⧁