App Icon
Create "data tables", "tornado", and Monte Carlo sensitivities. Also, type "<hide>" in Row 1 or Column A to group rows and columns.
Works with:
5,101
Overview
Supercharge data analytics with sensitivities.

Create sensitivity tables and analysis for any model.  The functionality is similar to that of the "data table" function in Excel.  Build Tornado charts and run Monte Carlo simulations similar to Crystal Ball or @Risk.

Additional functionality to automatically hide rows and columns (similar to "group rows" in Excel) by typing "<hide>" in the first row or column which you would like to hide (Add-ons->Sensitivity Macro->Hide Rows)

Example Directions:
(1) Create a Monte Carlo tab from the pull down menu (Add-ons->Sensitivity Macro->Create Monte Carlo tab)
(2) Create a simple multi-variable model on another tab (for example "ModelSheet")
(3) Write the text names of reference cells of the model inputs in the upper left of the Monte Carlo tab in "A1 notation" (for example: to use cell c5 in ModelSheet as an input, type "ModelSheet!C5" in the Monte Carlo tab cell 'Monte Carlo 1'!C3)
(4) Set your distributions and ranges in the Monte Carlo tab between F3:K7 depending on how many variables you have
(5) Run it from the menu (Add-ons->Sensitivity Macro->Run Monte Carlo)

Tips:
- Try running the sensitivity with the "Example Model" on the tab before linking to a new model
- Useful for valuation models
- Avoid spaces in tab names
- Don't insert rows or columns in sensitivity tabs (else risk breaking the tool)
- Remember to use the text of the reference cell for your model rather than linking
- Keep your model on a separate tab

Coming Next:
- Step-by-step instructions
Additional information
SupportNot available
Privacy policyNot available
Terms of service
Sensitivity Macro will ask for the permissions shown below. Learn more
Sensitivity Macro will need access to your Google account
This will allow Sensitivity Macro to :
See, edit, create, and delete all your Google Sheets spreadsheets
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Sensitivity Macro
January 24, 2018
Works fine. I'm using it to run some Data Tables with good success. Quick questions tho: 1. can we have multiple tables or is it capped to one per file? 2. Is there a way to abort the macro or we need to wait before changing something and rerunning? Thanks
Is this review helpful?
Yes
No
Profile Picture
A User of Sensitivity Macro
December 28, 2017
me too. There's nothing coming out of the Sensitivity Macro menu other than help. Give me my 30 minutes back.
Is this review helpful?
Yes
No
Profile Picture
A User of Sensitivity Macro
July 27, 2018
This add-on used to work great; still does. But recently, it's not possible to install it on any google user account. When trying to authorize it, the following message is displayed: "Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In."
Is this review helpful?
Yes
No
Profile Picture
Devin Byrne
April 9, 2018
Easy to use and straight forward!
Is this review helpful?
Yes
No
Profile Picture
Rick Fowler
March 15, 2021
I've used this add-on for years with my real estate analysis spreadsheets, but now when I try to run my sensitivity tables, Google says the script tried to access sensitive data and blocked the script. Bummer, the script was really useful for me.
Is this review helpful?
Yes
No
Profile Picture
Justin Heermann
March 17, 2021
Very helpful, have saved a ton of time with it. Thanks for creating and sharing on the marketplace!
Is this review helpful?
Yes
No
Profile Picture
A User of Sensitivity Macro
July 7, 2020
Works fine for me, very useful. I just wish I could I could run it a few hundred times instead of just 100.
Is this review helpful?
Yes
No
Profile Picture
Mel A
August 16, 2021
Trying to output sensitivity tables and isn't working. No How-To or Troubleshooting, nor support access.
Is this review helpful?
Yes
No
Profile Picture
Ray Strods
August 19, 2020
Liked it but would be nice to track multiple outputs
Is this review helpful?
Yes
No
1-9 of 9
Search
Clear search
Close search
Google apps
Main menu