+ Reply to Thread
Results 1 to 6 of 6

Statistics Report

  1. #1
    Registered User
    Join Date
    01-05-2014
    Location
    Ormeau
    MS-Off Ver
    Excel 2010
    Posts
    4

    Statistics Report

    Hello,

    I am trying to create a spreadsheet where I can get the capability percentages of members based on the courses in Disaster Management they have done. However I need it to take into consideration that they are also trained in other areas which means the probability of that functions capability would be lower.
    For example a member may be trained in both House Repair operations and Chainsaw Operations but they wouldnt be able to do both at the same time and I need to capture this in the statistics

    I hope this makes sense

    Thanks heaps in advance

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,527

    Re: Statistics Report

    Can you upload an example file?

  3. #3
    Registered User
    Join Date
    01-05-2014
    Location
    Ormeau
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Statistics Report

    Here is an example

    Thanks!example.xlsx

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,527

    Re: Statistics Report

    And can you show expected results?

  5. #5
    Registered User
    Join Date
    01-05-2014
    Location
    Ormeau
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Statistics Report

    Hi bebo,

    As you can see below it has 6 members trained in Chainsaw and 2 in house repairs and the corresponding percentage of capabilty but the 2 in House repairs are also 2 of the members trained in chainsaw so the 55% capability in chainsaw is incorrect because both those members would be required to do the house repairs over cutting trees in driveways.

    Does this help?

    Springbrook Chainsaw Operations - Level 1 6 55%
    Work In An Emergency Operations Centre 2 18%
    Traffic Control Operations 0 0%
    Flood Boat Operator 1 9%
    Land Search 1 9%
    Vertical Mobility 1 9%
    Vertical Rescue 1 9%
    House Repairs 2 18%
    House Repairs Ground Crew 0 0%
    Membership 11 100%

  6. #6
    Registered User
    Join Date
    01-05-2014
    Location
    Ormeau
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Statistics Report

    Hi Bebo!

    Have you had any ideas with this one?

    Thanks again for your help with this!

+ 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. How to report real statistics in excel
    By jellynose in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 08-24-2013, 11:23 AM
  2. Replies: 2
    Last Post: 08-08-2013, 12:45 AM
  3. [SOLVED] Filter / Report Top 10 Values with identifier into new spreadsheet / table / report style
    By steverokh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2013, 05:10 AM
  4. Replies: 1
    Last Post: 07-20-2012, 06:55 AM
  5. Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep
    By lukep10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2008, 01:38 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