Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'd like to load some scenarios in a sheet; problem is that some fields will have to be calculated with a goal-seek. Is that possible without programming or would my best choice be to use VBA (which isn't a problem for me but I'm don't want to program something that's already out there)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Can you provide a more detailed description of what you want to accomplish?

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='788603' date='12-Aug-2009 15:20']Can you provide a more detailed description of what you want to accomplish?[/quote]

    We are developing a sheet that has many formulas in there. For some parts, we have to use a goal seek to be able to find the right intermediate results. Basically, the intended sheet would have 4-10 cells where we can input different parameter-values and then we now manually do the goal-seek (in another sheet) to allow us to get an additional input value. This will lead to results which show in several cells.

    We are exploring input sensitivity to parameters and have been "playing" a lot manually, changing input cells to see what the impact would be on the calculated results. It struck me 30 mins ago that (1) using Excel scenarios, we could fix different conditions and see impact of them quicker and in a summary report automatically and (2) that I could also calculate/program the goal seek.

    Before I go that route, I'm simply exploring the (im-)possibilities here. Regretfully, I cannot share any of the sheets but I hope this does clarify a bit.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you want to perform sensitivity analysis, you might want to look into Monte Carlo simulations - search Google (or Bing if you prefer) for excel monte carlo.

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    [quote name='ErikJan' post='788599' date='12-Aug-2009 07:08']I'd like to load some scenarios in a sheet; problem is that some fields will have to be calculated with a goal-seek. Is that possible without programming or would my best choice be to use VBA (which isn't a problem for me but I'm don't want to program something that's already out there)[/quote]
    I think I'd use Solver. You can save Solver scenarios.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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