Feedback by UserVoice

Lyubomir Georgiev

My feedback

  1. 151 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Lyubomir Georgiev supported this idea  · 
  2. 1,234 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again, and please keep sharing your thoughts!
    Auston [MSFT]

    Lyubomir Georgiev supported this idea  · 
  3. 14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this, Lyubomir. How do you do these today? Is deeper integration with R potentially useful for such scenarios, at least for the analysis?

    Lyubomir Georgiev supported this idea  · 
    An error occurred while saving the comment
    Lyubomir Georgiev commented  · 

    Hi Ashvini. Thank you for your comment.
    Currently, to do this type of probabilistic analysis, I use a combination of build in Excel functions (ex. BINOM.INV, NORM. INV, etc.) and VBA. I use VBA to:
    - create inverse cumulative distribution functions not supported in Excel;
    - sample/simulate all inverse cumulative distribution functions by continuously recalculating my spreadsheet and storing outputs for each iteration;
    - run sensitivity analysis on the results;
    - etc.
    There are quite a few third party Excel add-ins which facilitate the above-mentioned tasks. The issue with all of them (a part from being quite expensive) is that once a model is built using some external functionalities, you can no longer use it on computers where the third party add-in is not installed. This severely limits the ability to collaborate on the content and consume the output of the probabilistic analysis. That’s why I believe that having natively supported Excel tools is the optimal solution.

    Lyubomir Georgiev shared this idea  · 
  4. 56 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Lyubomir Georgiev supported this idea  · 

Feedback and Knowledge Base