Attendance register for Excel GET

Diddums x · 4 Dec 2015 at 11:49

Morning you lovely sexy people and macca

I have been tasked with turning our rubbish holiday planner / sick record thingy into a fancypants 2016 model. Thing is, I'm completely useless with Excel so I'm wondering if there's a template or something I can use?

Our current one looks like this (I have added a smiley for dramatic effect) and each employee has their own tab.

Does something like this exist or should I hire a man?

Cheers

Gilly · 4 Dec 2015 at 11:55

In later versions of Excel they have templates that will do this for you

Mynight · 4 Dec 2015 at 11:57

http://exceltemplate.net/calendar/attendance-calendar/

But you can still hire a man if you want

.

DaleTheWhale · 4 Dec 2015 at 12:08

We have a spreadsheet, list of names down the left side, days on the top and update it when we need too, so everyone is in 1 sheet which can be filtered on.

KingOfTheDaves · 4 Dec 2015 at 13:07

That spreadsheet is 'triggering' me. :mad:

I'm fidgeting at my desk just looking at varying those column widths. That and the fact the colour in the key for Bank Holidays is different from the actual calendar.

Edit: Oh God I just noticed the bottom left with it's different font for 'Total Holidays Remaining' and the centred 'Holiday Entitlement'.

Just kill it with fire! :eek:

HAVE YOU NO ~~OCD~~ SELF-RESPECT?

Diddums x · 4 Dec 2015 at 14:48

Mynight said:
http://exceltemplate.net/calendar/attendance-calendar/

But you can still hire a man if you want .

Looking at this one, there are a couple of things I'd need to add:

Half days holiday.
Half days sick (yes, I know, this is somehow a thing :confused:

).
Holiday entitlement and days remaining (I think I've got this one sussed though).
Overtime.