Sensitivity Analysis--Help
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Sensitivity Analysis--Help

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Question is: If there are 50 parameters( e.g. from 1 to 50), every paremeter will generate a different output, and I want to see the 50 different outputs in one worksheet. One way to solve the problem is to plug in the 50 paramenters one by one, run the equation one by one, and write down the output one by one. But I feel it is too tedious, Is there another way to do it?
    Thanks a lot!

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes there is. You can use a Data Table. See help for Data Table. Select the topic "Create a one variable data table"

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See the Help Index topic for "Create a one-variable data table".

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wooo! It's a tie

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, Don't understand! Still have no idea how to generate a row or column oriented output. Also, because the output that I want is not only a simply formula, I used 10 worksheets for one output. Right now my question is there are 50 assumptions , one assumptions will generate one output, How can i do it easily? Thanks a lot

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you provide a sample of your data and formula(s)?

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    My input data is from "1% to 50% by 1% increment", also the output is supported by over ten worksheets(e.g, from A -B , then from B-C, .......From Y-Z, the output that I want is Z). Thanks.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com