+ Reply to Thread
Results 1 to 8 of 8

Help to make better spreadsheet

  1. #1
    Registered User
    Join Date
    08-21-2008
    Location
    Doha
    Posts
    10

    Help to make better spreadsheet

    Hi I wonder if anyone can help. I have about 9000 rows in an excel spreadsheet that I have inherited and need help as to how to make it better and more manageable. Also how provide reports from this. I dashboard perhaps?

    Hope someone can help me please.

    Thank you.
    Donna
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.67 - (22111300)
    Posts
    7,503

    Re: Help to make better spreadsheet

    i think you need to provide more info , mainly about what you want to measure on the dashboard
    layout of the data can impact the ease with which multiple dashboard items can be created

    We don't know what business you are in, or what KPI's are important to you to see and measure, not any goals/targets or thresholds
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    08-21-2008
    Location
    Doha
    Posts
    10

    Re: Help to make better spreadsheet

    Its hospital staff who need to wear masks. The first 4 masks are the only ones we have in stock. So we need to test everyone to wear one if the first 4 masks. The orhers are kind of refdundant for now. I need to produce reports on how many have been tested snd passed on each mask. How many have still to be tested.

  4. #4
    Registered User
    Join Date
    08-21-2008
    Location
    Doha
    Posts
    10

    Re: Help to make better spreadsheet

    The first 4 masks are in order of size to fit the face. Largest to smallest.

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.67 - (22111300)
    Posts
    7,503

    Re: Help to make better spreadsheet

    not sure where the 1st 4 masks are - quite a lot of data on the sheet , can you
    How do you know if they have passed , can you give details


    Perhaps change the names and use that or row
    I have changed First names to ABC-1 through to ABC-7
    in column BI - I see a PASS also for A7

    I have added a countif() in cell FT
    to count Pass in any of the cells
    And the only person without a pass is ABC-4

    We could introduce named ranges perhaps - or change the range to only include certain masks

    But I really dont understand the spreadsheet, and content

    I thought as you want to see the number of people who have passed , then this summary at the end of the data , may help produce a report
    Attached Files Attached Files
    Last edited by etaf; 03-02-2021 at 05:10 AM.

  6. #6
    Registered User
    Join Date
    08-21-2008
    Location
    Doha
    Posts
    10

    Re: Help to make better spreadsheet

    Thank you etaf

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.67 - (22111300)
    Posts
    7,503

    Re: Help to make better spreadsheet

    you are welcome, Is that enough of an answer, I did ask a few more questions and was expecting an iterative process

  8. #8
    Valued Forum Contributor
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    849

    Re: Help to make better spreadsheet

    Maybe a Summary Tab as attached?
    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. Formulas to make my spreadsheet better
    By Abbylea in forum Excel General
    Replies: 5
    Last Post: 01-18-2018, 03:52 PM
  2. Replies: 7
    Last Post: 12-27-2012, 10:53 PM
  3. [SOLVED] Make search a spreadsheet for a form, done in spreadsheet
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2012, 07:09 PM
  4. HELP! Trying to make complicated spreadsheet
    By luketenley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2012, 10:50 PM
  5. make a spreadsheet
    By leslieguy in forum Excel General
    Replies: 1
    Last Post: 06-16-2005, 04:05 PM
  6. Trying to make a simple looking spreadsheet
    By Nastajus in forum Excel General
    Replies: 7
    Last Post: 05-19-2005, 01:41 PM
  7. [SOLVED] how do I make a spreadsheet fit the right margin.
    By cwood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2005, 10:06 AM

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