+ Reply to Thread
Results 1 to 3 of 3

Tabbed tables - or some other way to compare multiple data sets.

  1. #1
    Forum Contributor
    Join Date
    09-28-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    102

    Tabbed tables - or some other way to compare multiple data sets.

    Hi.

    I am trying to make some comparison tables for a game I am playing. The problem I am running into is the sheer number of items is making the table very long.

    What I would like to do is have some way of shrinking the way the data is presented.

    Example.

    I am trying to compare equipment, for the sake of arguments lets say this particular category is weapons.

    Each Weapon has a class, a grade, a mounting type and then several specifications such as power drawn, damage dealt, rate of fire, etc...

    The classes run from 1 to 8 and each class has a sub-class or grade running from A to H (at least) and there are 3 mounts (fixed, gimballed and turreted)

    I am thinking that in a flat 2 axis table that I would want to have Class along the X axis and Grade along the Y - in this setup I would need to create a minimum of 3 tables based on the criteria I have already listed (power drawn, damage dealt, rate of fire, etc...). With Each X mark being split into fixed, gimballed and turreted.

    For display purposes I would like to be able to condense this down into either some form of tabbed table or a 3 axis chart (the problem with the latter is that each item runs on a different scale and some item values decrease and others increase.

    Thoughts please?
    Last edited by escribblings; 11-30-2014 at 06:45 PM.

  2. #2
    Registered User
    Join Date
    12-15-2011
    Location
    Washington
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Tabbed tables - or some other way to compare multiple data sets.

    I'd use Power Pivot and do it like in I did in this sheet. Big benefits here are how easy it's going to be to redo things if the game changes (which I've run into). They add a new weapon? Just add it to the weapons table, stats changed? Just change them in whatever table. If you have a huge table with a bunch of calculations then you'll have to edit everything whereas with the data normalized you can just plug and chug. Let me know if you have questions.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    09-28-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    102

    Re: Tabbed tables - or some other way to compare multiple data sets.

    Cheers for the reply. I assumed it would require some form of pivot but want sure where to start.

    I can't view your example right now as I'm away from my PC, but I will examine it in detail as soon as I can.

    Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need Help - How to compare two sets of data?
    By adamnyc31 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2014, 11:07 AM
  2. [SOLVED] Compare multiple sets of columns
    By bseo927 in forum Excel General
    Replies: 7
    Last Post: 08-19-2013, 01:16 PM
  3. Replies: 2
    Last Post: 12-05-2012, 01:52 PM
  4. Make a Tabbed Form with Different Tables in each Tab
    By raghavansrinath in forum Access Tables & Databases
    Replies: 1
    Last Post: 08-15-2012, 01:26 PM
  5. Copying all data from multiple tabbed sheets to another worksheet
    By StuntMonkeh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2008, 03:59 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