+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Cover reports in Technical; Our head of cover wants a report that will show how many teaching staff were off on any given week ...
  1. #1
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    386
    Thank Post
    161
    Thanked 66 Times in 55 Posts
    Blog Entries
    8
    Rep Power
    22

    Cover reports

    Our head of cover wants a report that will show how many teaching staff were off on any given week last half term. Last time I ran this report, I had to manually change the spreadsheet and it took hours, and if this is going to become a regular occurrence, I would love to have a more automated system. So I guess my questions are:

    1, Is there a way/report in SIMS or Discover that will give me the number of staff absences per week? I've looked, and can see nothing obvious, though I believe that Discover may be improving this aspect in later updates.

    2, Does anyone know of a way to extrapolate from a start date and end date the number of days off in any given week. I've looked at SUMPRODUCT, NETWORKDAYS, COUNTIFS but I can't get my head around allocating days off to specific weeks when the days of spread over a weekend. If it's a single day, then it's very easy. But when we get to multiple days, and then multiple days over multiple weeks, it becomes a real noodle scratcher.

    For example, lets say someone was ill from the 04/09/13 to 11/09/13. I can work out that it is 6 working (network) days that have been lost, and which week the start and end dates fall into. Beyond that, I'm stuck. Ideally I'd like to count the number of network days between the start and end date of the illness period, IF they fall between the date range of Week 1, and then again for week 2, 3 etc... But my excel-fu fails me

    Any help gratefully received!

  2. #2
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,190
    Thank Post
    839
    Thanked 374 Times in 290 Posts
    Blog Entries
    60
    Rep Power
    284
    Code:
    Tools -> Cover -> Statistics -> Absence
    Should note you need permissions to manage cover for that menu route.

  3. Thanks to CAM from:

    simpsonj (14th November 2013)

  4. #3
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    386
    Thank Post
    161
    Thanked 66 Times in 55 Posts
    Blog Entries
    8
    Rep Power
    22
    Seems an odd place to put a report, but thank you so much!

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Also for your broader analysis needs take a look here. He was actively developing a while back but i think has slowed now. There are a few threads on here on the subject so you could check those and contact him if need be.

    Absence & Cover Analysis | Weird & Wonderful IT

SHARE:
+ Post New Thread

Similar Threads

  1. What are your reporting methods?
    By indiegirl in forum How do you do....it?
    Replies: 21
    Last Post: 22nd June 2012, 09:58 AM
  2. [SIMS] Reporting on Cover
    By DeeGee in forum MIS Systems
    Replies: 3
    Last Post: 3rd May 2012, 11:24 AM
  3. [SIMS] Nova T4 - Reporting on Cover
    By CarpeDiem in forum MIS Systems
    Replies: 1
    Last Post: 3rd March 2012, 06:37 AM
  4. Printing Access Reports... or not!
    By Frazer in forum Windows
    Replies: 0
    Last Post: 20th October 2005, 11:03 AM
  5. Getting your server to email you reports.
    By eejit in forum Windows
    Replies: 11
    Last Post: 23rd September 2005, 10:46 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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