Replicates the Excel "What-If Analysis" feature, Data Tables.
āđ‚āļ”āļĒ
āļ§āļąāļ™āļ—āļĩāđˆāļ­āļąāļ›āđ€āļ”āļ•āļ‚āđ‰āļ­āļĄāļđāļĨ:12 āļžāļĪāļĐāļ āļēāļ„āļĄ 2567
āđƒāļŠāđ‰āļ‡āļēāļ™āđ„āļ”āđ‰āļāļąāļš
67K+
āļ āļēāļžāļĢāļ§āļĄ
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.

āļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
āļĢāļēāļ„āļēāđ„āļĄāđˆāļĄāļĩāļ„āđˆāļēāđƒāļŠāđ‰āļˆāđˆāļēāļĒ
āļ™āļąāļāļžāļąāļ’āļ™āļēāļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ
āđ„āļĄāđˆāđ€āļ›āđ‡āļ™āļœāļđāđ‰āļ„āđ‰āļē
āļ™āđ‚āļĒāļšāļēāļĒāļ„āļ§āļēāļĄāđ€āļ›āđ‡āļ™āļŠāđˆāļ§āļ™āļ•āļąāļ§
āļ‚āđ‰āļ­āļāļģāļŦāļ™āļ”āđƒāļ™āļāļēāļĢāđƒāļŦāđ‰āļšāļĢāļīāļāļēāļĢ
WhatIf āļˆāļ°āļ‚āļ­āļŠāļīāļ—āļ˜āļīāđŒāļ—āļĩāđˆāđāļŠāļ”āļ‡āļ”āđ‰āļēāļ™āļĨāđˆāļēāļ‡ āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
WhatIf āļ•āđ‰āļ­āļ‡āļĄāļĩāļŠāļīāļ—āļ˜āļīāđŒāđ€āļ‚āđ‰āļēāļ–āļķāļ‡āļšāļąāļāļŠāļĩ Google
āļ‹āļķāđˆāļ‡āļˆāļ°āļ­āļ™āļļāļāļēāļ•āđƒāļŦāđ‰ WhatIf āļ”āļģāđ€āļ™āļīāļ™āļāļēāļĢāļ•āđˆāļ­āđ„āļ›āļ™āļĩāđ‰
āļ”āļđāđāļĨāļ°āļˆāļąāļ”āļāļēāļĢāļŠāđ€āļ›āļĢāļ”āļŠāļĩāļ•āļ—āļĩāđˆāļ•āļīāļ”āļ•āļąāđ‰āļ‡āđāļ­āļ›āļžāļĨāļīāđ€āļ„āļŠāļąāļ™āļ™āļĩāđ‰āđ€āļ‚āđ‰āļēāđ„āļ›
āļ”āļđāļ­āļĩāđ€āļĄāļĨāļŦāļĨāļąāļāļ‚āļ­āļ‡āļšāļąāļāļŠāļĩ Google
āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāļŠāđˆāļ§āļ™āļ•āļąāļ§ āļ‹āļķāđˆāļ‡āļĢāļ§āļĄāļ–āļķāļ‡āļ‚āđ‰āļ­āļĄāļđāļĨāļŠāđˆāļ§āļ™āļ•āļąāļ§āđƒāļ”āđ† āļ—āļĩāđˆāļ„āļļāļ“āđ„āļ”āđ‰āđ€āļœāļĒāđāļžāļĢāđˆāļ•āđˆāļ­āļŠāļēāļ˜āļēāļĢāļ“āļ°āļ”āđ‰āļ§āļĒ
āļĢāļĩāļ§āļīāļ§
āļ āļēāļĐāļē:
āļˆāļąāļ”āđ€āļĢāļĩāļĒāļ‡āļ•āļēāļĄ:
Google āđ„āļĄāđˆāđ„āļ”āđ‰āļ•āļĢāļ§āļˆāļŠāļ­āļšāļĢāļĩāļ§āļīāļ§āļŦāļĢāļ·āļ­āļ„āļ°āđāļ™āļ™ āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄāđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāļĢāļĩāļ§āļīāļ§
āđ„āļĄāđˆāļĄāļĩāļ„āļ§āļēāļĄāļ„āļīāļ”āđ€āļŦāđ‡āļ™
āļ„āđ‰āļ™āļŦāļē
āļĨāđ‰āļēāļ‡āļāļēāļĢāļ„āđ‰āļ™āļŦāļē
āļ›āļīāļ”āļāļēāļĢāļ„āđ‰āļ™āļŦāļē
āđāļ­āļ› Google
āđ€āļĄāļ™āļđāļŦāļĨāļąāļ