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 ...
13th November 2013, 07:02 PM #1
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!
14th November 2013, 11:41 AM #2
Should note you need permissions to manage cover for that menu route.
Tools -> Cover -> Statistics -> Absence
Thanks to CAM from:
simpsonj (14th November 2013)
14th November 2013, 12:43 PM #3
Seems an odd place to put a report, but thank you so much!
14th November 2013, 02:52 PM #4
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
By indiegirl in forum How do you do....it?
Last Post: 22nd June 2012, 10:58 AM
By DeeGee in forum MIS Systems
Last Post: 3rd May 2012, 12:24 PM
By CarpeDiem in forum MIS Systems
Last Post: 3rd March 2012, 07:37 AM
By Frazer in forum Windows
Last Post: 20th October 2005, 12:03 PM
By eejit in forum Windows
Last Post: 23rd September 2005, 11:46 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)