Nov 25 2021 03:32 AM
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 is set our per employee. On each month you find the employee's line and enter either "S" - Sickness, "P" - personal, "H" - Holiday. However my manager's want some sort of analysis that would put years of data together that would tell them whether someone has a sick day the same time each year. Or if there is a trend that they have 2 sickness days then a personal day, the same time each year. I have only set this spreadsheet up this year (based off a template from the internet) so don't currently have historical data in the same format, however will be using the same format going forward with a new document each year.
Jan 11 2023 08:19 AM
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: