Forum Discussion
Trend Data Analysis
Good Afternoon, I am hoping to find a solution to my problem, however I may be asking excel to do to much. I have an absence excel spreadsheet, that has 12 sheets (one for each month) and i...
Did you ever work out how to track trends? as I would be interested in this, I'm only just looking into something like this myself but I just noticed your post and your image looks similar to how I want to have ours.
Here is my list to do:
- One document for all the business
- Create Departments; Accounts, Sales, CAD, Laser, Press, Goods In/Out
- Create rules that possibly change cell colours when we have 6 planned absences on any given date
- Create rules that prohibit too many staff off in any are at one time; Accounts =1, Sales =2, CAD =1, Laser =2, Press =1, Goods In/Out =1
- Show the three absences differently; holiday, planned absence, sick
- Calculate the Bradford Score for sick (B = S * S * D) B = Bradford score, S = Total number of spells absent and D = Total number of days absent