Keeping track of sick leave in Google Sheets. A template?

B0bbyEwing

Trying to think of something that'll help my OH stop getting worked up over sick leave due to the stupid (imo) system they have at their place which penalises you for trying to go back to work. 

I found an Excel template



which looks pretty ideal - but it's Excel & I know that they'll prefer something that isn't tied to the home PC & is easily accessible on their phone - such as Google Sheets (this template didn't transfer over well).

Everything I've found so far hasn't really been suitable - it's either a week-by-week template or you're having to switch between months. The good thing about the one above is the entire year is there on view all at once.

I could print off a yearly calendar, stick it in the kitchen & they could put highlighter splodges on when they take a day off but if possible then Google Sheets would be preferred. 

Emmia

You can have Excel on your phone too, if you subscribe, it all syncs across, much like Google sheets

Doing a form in Excel would be very straightforward, with some conditional formatting and simple formulae, but I've never tried doing it in Google sheets 

B0bbyEwing

Emmia said:

You can have Excel on your phone too, if you subscribe, it all syncs across, much like Google sheets

Doing a form in Excel would be very straightforward, with some conditional formatting and simple formulae, but I've never tried doing it in Google sheets 

Funny you say that. I've literally just replied to someone saying how I'm anti subscription. Not a fan of continuously paying something that can & should be bought as a one off payment. 

After some time (quite some time) I could maybe manufacture something myself but in all honesty I don't really know what I'm doing and it'd take quite a while with plenty of errors which would then bring questions. 

So a template would be ideal. 

Emmia

B0bbyEwing said:

Emmia said:

You can have Excel on your phone too, if you subscribe, it all syncs across, much like Google sheets

Doing a form in Excel would be very straightforward, with some conditional formatting and simple formulae, but I've never tried doing it in Google sheets 

Funny you say that. I've literally just replied to someone saying how I'm anti subscription. Not a fan of continuously paying something that can & should be bought as a one off payment. 

After some time (quite some time) I could maybe manufacture something myself but in all honesty I don't really know what I'm doing and it'd take quite a while with plenty of errors which would then bring questions. 

So a template would be ideal. 

Have you tried a Google search for this?

Whilst I'm very proficient at Excel and can create my own stuff I will usually look to see if a template is available that I can customise, rather than writing one from scratch, as it's often quicker.

I expect there are templates for Google sheets too if you have a look. Something like "leave planner" would probably be where I'd start.

Marcon

Are you sure you aren't over-engineering things here? Mightn't it be simpler to have a simple (paper) year at a glance calendar pinned to the wall, so your OH can use a highlighter pen to record periods of absence, holiday etc (different colours pens!)?

Emmia

Marcon said:

Are you sure you aren't over-engineering things here? Mightn't it be simpler to have a simple (paper) year at a glance calendar pinned to the wall, so your OH can use a highlighter pen to record periods of absence, holiday etc (different colours pens!)?

The advantage of a spreadsheet over a paper calendar is that you can automatically add up the number of days of annual leave/work/sick leave over a given period.

B0bbyEwing

Emmia said:

B0bbyEwing said:

Emmia said:

You can have Excel on your phone too, if you subscribe, it all syncs across, much like Google sheets

Doing a form in Excel would be very straightforward, with some conditional formatting and simple formulae, but I've never tried doing it in Google sheets 

Funny you say that. I've literally just replied to someone saying how I'm anti subscription. Not a fan of continuously paying something that can & should be bought as a one off payment. 

After some time (quite some time) I could maybe manufacture something myself but in all honesty I don't really know what I'm doing and it'd take quite a while with plenty of errors which would then bring questions. 

So a template would be ideal. 

Have you tried a Google search for this?

Whilst I'm very proficient at Excel and can create my own stuff I will usually look to see if a template is available that I can customise, rather than writing one from scratch, as it's often quicker.

I expect there are templates for Google sheets too if you have a look. Something like "leave planner" would probably be where I'd start.

I have. 
And keep coming up against the templates I described which is what I meant when I said "everything I've found so far" - as in I'd done a Google search. 

Marcon said:

Are you sure you aren't over-engineering things here? Mightn't it be simpler to have a simple (paper) year at a glance calendar pinned to the wall, so your OH can use a highlighter pen to record periods of absence, holiday etc (different colours pens!)?

I even mentioned paper in my OP so it has been thought of, yes. 

Rich1976

Personally I would go for the simple option of having a dedicated page in a diary or notebook and make a note everytime sick leave or holiday is taken and then you can see straight away and keep a running total.

alternatively what about the notes section on the phone to do the same thing?

seems like a simple task is being made more complicated than it needs to be .

B0bbyEwing

Rich1976 said:

Personally I would go for the simple option of having a dedicated page in a diary or notebook and make a note everytime sick leave or holiday is taken and then you can see straight away and keep a running total.

alternatively what about the notes section on the phone to do the same thing?

seems like a simple task is being made more complicated than it needs to be .

We have things on a pin board now that need seeing to, be it something crossing off or noting or whatever. 

They don't get done when they should. They get done, just ... at some point.

Since the phone will be in the hand during the day, it's so much easier to just go - oh yeah I forgot to do that, let me open that app now as I sit here. Tick.

Marcon

Emmia said:

Marcon said:

Are you sure you aren't over-engineering things here? Mightn't it be simpler to have a simple (paper) year at a glance calendar pinned to the wall, so your OH can use a highlighter pen to record periods of absence, holiday etc (different colours pens!)?

The advantage of a spreadsheet over a paper calendar is that you can automatically add up the number of days of annual leave/work/sick leave over a given period.

Agree, but not exactly difficult with a paper calendar, especially if you make a note on the calendar of each month's total.

B0bbyEwing

Marcon said:

Emmia said:

Marcon said:

Are you sure you aren't over-engineering things here? Mightn't it be simpler to have a simple (paper) year at a glance calendar pinned to the wall, so your OH can use a highlighter pen to record periods of absence, holiday etc (different colours pens!)?

The advantage of a spreadsheet over a paper calendar is that you can automatically add up the number of days of annual leave/work/sick leave over a given period.

Agree, but not exactly difficult with a paper calendar, especially if you make a note on the calendar of each month's total.

True, not difficult with a paper calendar. 

But I've explained why a paper calendar is not the preferred option for us.