Feedback by UserVoice

Anonymous

My feedback

  1. 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?

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

    Are people aware that you can do a basic simulation using the Data Table functionality?
    Simply set up your model with Rand() driving the variables and then set up a data table with sim# in a column and the key values you want at the top of the columns alongside.
    Then insert a data table with a dummy cell as the column variable to force a recalc for each row of the table.

    An error occurred while saving the comment
    Anonymous commented  · 

    I'd second point 1 to add more inverse distribution functions. You can write them as a VBA function but if you're calculating lots of simulations (for example) being a VBA function rather than a built-in function can really slow the recalc down.

  2. 1,589 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 great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Anonymous supported this idea  · 

Feedback and Knowledge Base