+ Reply to Thread
Results 1 to 4 of 4

Chart from Categories with Sub-Categories

  1. #1
    Registered User
    Join Date
    06-05-2017
    Location
    Europe
    MS-Off Ver
    2016
    Posts
    2

    Chart from Categories with Sub-Categories

    Hello,

    I don't quite know how to explain this, so excuse the nondescriptive title.

    In this table there are 7 wound types that each have 3 size variations. There are also 4 types of bandages that have 4 parameters that affect each wound and size of wound differently.
    The goal with this chart is to purvey at a glance the ideal type of bandage for each given type of wound. I do not suppose it's possible without excluding a parameter, but bringing it up here is worth a shot.

    If you have any idea as to how to get a recommended treatment across in as compact a format as possible, you have free reins. I'm only just learning Excel 2016, so I'd also just appreciate any pointers to send me on my way.

    Cheers.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Chart from Categories with Sub-Categories

    Please explain a bit more about how you would like this to work. For example if I have a medium abrasion, what would you like the results to look like? I think an example or two of "this is what I have and this is what I'd like to see" would help us reverse-engineer the solution.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    06-05-2017
    Location
    Europe
    MS-Off Ver
    2016
    Posts
    2

    Re: Chart from Categories with Sub-Categories

    Ideally I would like to see an overview of all bandages and how efficient they are for a given wound.

    Let's say you have a large velocity wound and you want to find out which bandage you should use to patch it up as quickly as possible, you'd look at this chart and be able to point at your options.
    How does a packing bandage compare against an elastic bandage in this case?

    Effect is the effectiveness of a bandage to cover up the wound. Chance is the chance in percent that a wound reopens after it has been bandaged. The Min / Max values are the times in seconds until a bandaged wound reopens, if it does so.
    Generally across wound types, a packing bandage thus has a higher chance to reopen, but it keeps it sealed for much longer. A basic bandage is as effective, has a lower chance to reopen, but if it does, it does so much quicker.

    Should I take the average of the values for all wound sizes and eliminate a factor? Instead of a small abrasion, medium abrasion and large abrasion with different values, I'd only have an abrasion with an average value to display on the chart. That's not as accurate and comprehensive as I'd want it, but if such abstractions help form a digestible chart, I'd do it.

    Should I introduce an efficiency value that is calculated based on these parameters, then eliminate wound size with an average? That would leave me with one dimension for bandage types, one for wound type and one for the efficiency.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Chart from Categories with Sub-Categories

    I can only take this so far. In cells B1 and B2 you can select the wound type and severity. This performs the look-ups in the range A5:F8.

    I came up with a formula for a weighted average =W_Effect*B5-W_Chance*C5*(W_Min*D5-W_Max*E5)

    There is no science behind this formula whatsoever, but it does have the following features: The effect is a positive factor. The chance that the bandage will fall off is a negative factor. Within the chance, the min time is a negative factor and the max time is a positive factor. That is the reason the Max has a negative sign in the formula: a negative negative is a positive. Increasing the weight of the maximum lessens the negative effect of the chance of the bandage falling off.

    You will have to adjust the weights and test the formulas based on your knowledge of the treatments. I imagine that Effect should have most of the weight. I picked numbers that at least come up with a different best - although it never selects elastic of QuickClot. Maybe I'm assigning too much to chance.

    I am not sure that the formula is worth anything, but at least the selections in cells B1:B2 will get the metrics all in one place for you.
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 05-15-2013, 06:55 AM
  2. Replies: 0
    Last Post: 07-22-2011, 03:51 PM
  3. Grouping categories within categories
    By mju4t in forum Excel General
    Replies: 1
    Last Post: 11-03-2010, 02:41 PM
  4. Categories and Sub-Categories in Column Charts
    By theoneness in forum Excel General
    Replies: 2
    Last Post: 11-28-2009, 10:05 PM
  5. Chart Categories
    By flavordave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-25-2009, 09:25 PM
  6. Line Chart with Categories
    By Coolboy55 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-21-2008, 09:38 AM
  7. Chart Categories
    By SJT in forum Excel General
    Replies: 1
    Last Post: 06-19-2006, 03:20 PM
  8. 3D chart categories
    By elementary in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-22-2006, 01: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