App Icon
nickbritz
•  1,045
Overview
Create "data tables", "tornado", and Monte Carlo sensitivities. Also, type "<hide>" in Row 1 or Column A to group rows and columns.
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
Reviews
Language:
Sort by:
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
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 Pciture
Jon Passman
July 18, 2020
Same issue. Crazy. Are there any other sensitivity tools to use?
Profile Pciture
A user of Sensitivity Macro
July 14, 2020
Same issue
Profile Pciture
Sean McAlister
June 8, 2020
Hi Nicholas Britz, this issue is still occurring. What's the update from your end?
Profile Pciture
A user of Sensitivity Macro
May 11, 2020
Same issue
Profile Pciture
A user of Sensitivity Macro
April 16, 2020
04/16/20 - same issue. Not fixed yet.
Profile Pciture
Michael Hazilias
April 12, 2020
Did anyone solve this? I'm having the same issue.
Profile Pciture
A user of Sensitivity Macro
March 11, 2020
I am having the same issue. what do i do?
Profile Pciture
Nicholas Britz
December 18, 2019
I think it's working now; please give it a shot
Profile Pciture
A user of Sensitivity Macro
August 11, 2018
I am having the same issue
Profile Picture
Mel A
May 8, 2018
Shows potential but is error'ing out on me for basic inputs.
Is this review helpful?
Yes
No
Profile Pciture
A user of Sensitivity Macro
April 12, 2020
I'm getting the same error - did anyone overcome it?
Profile Pciture
A user of Sensitivity Macro
March 11, 2020
Im getting this issue: "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."
Profile Pciture
A user of Sensitivity Macro
July 1, 2019
Same problem as Jack T.
Profile Pciture
A user of Sensitivity Macro
June 18, 2018
Can't submit my own review, since I when I try to download this add-on, I'm prompted with: "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." Anyone know how to get past this?
Profile Picture
Devin Byrne
April 9, 2018
Easy to use and straight forward!
Is this review helpful?
Yes
No
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 Pciture
Nicholas Britz
February 8, 2018
Thanks - 1. You can make as many tabs with a single table as you'd like :) however it doesn't support multiple tables within a tab 2. Not an easy way to abort; will look for a way to add in next version
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 Pciture
A user of Sensitivity Macro
January 2, 2018
try a quick refresh. will work.
Profile Picture
Jeremy Pippin
November 22, 2017
I get nothing in Add-ons > Sensitivity Macro menu except "Help"
Is this review helpful?
Yes
No
Profile Pciture
A user of Sensitivity Macro
January 2, 2018
try a quick refresh. will work.
1-7 of 7
Additional information
nickbritz
Terms of Service
Search
Clear search
Close search
Google apps
Main menu