google-sheets-what-if-analysis
google-sheets-what-if-analysis copied to clipboard
Replicates the Excel "What-If Analysis" feature, Data Tables.
Hi,great plugin! I understand that it's problematic to have immediate refresh to the output. But I think totally manual is also very tedious. I suggest to allow automatic refresh once...
This started as a hastily written script, then became a fun experiment with how to publish an extension. There have been recent improvements (contributed by you fine Internet folks!), and...
So I have to manually delete the named ranges before recreating the data tables. I think this is due to [line 142 in WhatIfAnalysis.gs](https://github.com/sajacy/google-sheets-what-if-analysis/blob/452247091a5e359f1a6d39e22cc4a9f56f130b67/WhatIfAnalysis.gs#L142) looking for the index of a...
I have two data tables, each referring to different row and column inputs. The row/column inputs for table 2 change the outputs for table 1 as well, and I think...

This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. This is the message i get
Error attempting to use the app: "This app is blocked This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access."