Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Monthly figure (2003)

    I have created a spreadsheet for recording the results of audits. There are 10 categories to check each week, and a score is given for each audit. If all categories pass, that is 10/10, if only 4 pass, that's 4/10. Over weeks, I want to calculate what the percentage is, ie after 4 weeks I've done 40 categories of which 34 have passed. I have calculated the figure, but as the weeks go on, this will change. I want to be able to get a figure after every month, which can be put in a graph to show whether things have improved. I know I could enter this figure manually, but I won't always be using the spreadsheet.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Monthly figure (2003)

    Could you attach a sample workbook so that we can see what the layout of the data is? Remove or alter sensitive information.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Monthly figure (2003)

    The percentage is worked out using cells S13/14

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Monthly figure (2003)

    Is the attached what you were looking for?

    Edited by Legare Coleman to fix a small problem with the formula in the workbook.
    Legare Coleman

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Monthly figure (2003)

    Sort of. You've improved what I'd got. It's actually the percentage score I want to do something with. On the spreadsheet, you will see that there are figures for all October, and 1 for November. The percentage shows the total, so the percentage for October is lost. This is what I want to show.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Monthly figure (2003)

    Does the highlighted range in the Finishing sheet do what you want? (I didn't do the Wax sheet)

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Monthly figure (2003)

    Yes, that's perfect Hans. Thank you very much.

Posting Permissions

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