Results 1 to 16 of 16

Data Table for Scenario in Excel

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2011
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    92

    Data Table for Scenario in Excel

    Trying to make a scenario manager in excel for cars and engine and body costs.

    1. select car model in A3.
    2. have a table of results based on base case cost for all models. (linked by data validation to sheet 2).
    3. be able to change the engine and body cost in cells C3 and C5 in sheet 1, and see what effect that would have on the cost of all the car models assuming the same % increase/ decrease was applied.
    4. plot results on graph on same worksheet.

    Example attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. pivot table for scenario testing
    By ammartino44 in forum Excel General
    Replies: 0
    Last Post: 05-26-2015, 02:54 PM
  2. Excel 2003 Scenario Report Recalculation Tricks? or use Table?
    By mot in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2014, 03:50 AM
  3. [SOLVED] scenario testing and stepped table
    By freshfruit in forum Excel General
    Replies: 5
    Last Post: 01-24-2014, 12:03 AM
  4. Scenario Manager displays same result for every scenario
    By terihoff in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 11-10-2012, 07:14 PM
  5. About Data Table & Scenario Manager.
    By JOBY JOHN NEERIYANKAL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-19-2006, 10:35 AM
  6. [SOLVED] Excel 2k Pivot Table refresh scenario
    By GDCross in forum Excel General
    Replies: 1
    Last Post: 06-01-2006, 04:20 PM
  7. Refresh scenario information in a pivot table
    By Fin Analyst in forum Excel General
    Replies: 2
    Last Post: 03-30-2006, 12:20 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1