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

Emmia

B0bbyEwing said:

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.

Are you actually asking for someone on the forum to make you this tracker in Google Sheets?

B0bbyEwing

Emmia said:

B0bbyEwing said:

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.

Are you actually asking for someone on the forum to make you this tracker in Google Sheets?

No. 

If that was the case my post would've gone something like... 

Would one of you be so kind as to make me a tracker in Google sheets. 

But it didn't so I'm not. 

Emmia

B0bbyEwing said:

Emmia said:

B0bbyEwing said:

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.

Are you actually asking for someone on the forum to make you this tracker in Google Sheets?

No. 

If that was the case my post would've gone something like... 

Would one of you be so kind as to make me a tracker in Google sheets. 

But it didn't so I'm not. 

So what are you expecting/seeking?

Paper options aren't suitable and in an earlier post you said your skills aren't up to creating one that's right first time - and  you've drawn a blank on existing templates available via an internet search.

B0bbyEwing

Emmia said:

B0bbyEwing said:

Emmia said:

B0bbyEwing said:

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.

Are you actually asking for someone on the forum to make you this tracker in Google Sheets?

No. 

If that was the case my post would've gone something like... 

Would one of you be so kind as to make me a tracker in Google sheets. 

But it didn't so I'm not. 

So what are you expecting/seeking?

Paper options aren't suitable and in an earlier post you said your skills aren't up to creating one that's right first time - and  you've drawn a blank on existing templates available via an internet search.

I came here to see if anyone reading this thread knew of a template, had seen a template, maybe already had a template (doubtful on that one) that would tick the box.

I'd done a search & found nothing annual, only weekly or monthly. The only annual I found was Excel but that's Excel & not sheets (and it doesn't convert accurately) but just because I hadn't found anything doesn't mean that something doesn't exist - so I was simply asking the question.

The old don't ask don't get or don't ask never know. Whichever way you wish to look at it.

I was prepared for the end result to be a blank but like I just said - don't ask, never know. Many times over the years others have known of things that I've tried to look for but not found.


So it seems to have resulted in a blank, which to use a much overused phrase .... it is what it is.

Emmia

As it happens I've just created in Excel a sheet which automatically adds up the number of days I've been in particular locations, annual leave, etc. and has a bunch of conditional formatting which also colours the cells in automatically - it's not difficult to do this.

B0bbyEwing

Emmia said:

As it happens I've just created in Excel a sheet which automatically adds up the number of days I've been in particular locations, annual leave, etc. and has a bunch of conditional formatting which also colours the cells in automatically - it's not difficult to do this.

I don't need an excel sheet. The template works in excel. 
It's a Google Sheets one I need and saving the excel template & dropping in to Google Drive doesn't work. 

Out of interest, where did you learn excel? Is it part of a job or is it something you taught yourself? 

Emmia

B0bbyEwing said:

Emmia said:

As it happens I've just created in Excel a sheet which automatically adds up the number of days I've been in particular locations, annual leave, etc. and has a bunch of conditional formatting which also colours the cells in automatically - it's not difficult to do this.

I don't need an excel sheet. The template works in excel. 
It's a Google Sheets one I need and saving the excel template & dropping in to Google Drive doesn't work. 

Out of interest, where did you learn excel? Is it part of a job or is it something you taught yourself? 

I'm almost entirely self taught - had a few classes in college, but that was the best part of 30 years ago. Conditional formatting and formulae are stuff I've learnt to do, mostly by trial and error - I keep my skills sharp by using it regularly at work for various purposes.

Edit: have you tried saving it as a .CSV file and seeing if that will work in sheets? (Edit, just tried it, you'll lose the formulae, which is the bit you need)

B0bbyEwing

@Emmia - what's the reason behind the Excel template not working within Google Sheets?

Do they use different code (or even slightly different code - where some may be the same & some not)?

I assuming copying it over (not drag & drop but looking at the code within Excel's cells & writing that in Google Sheets) would result in the same as drag & drop ..... and not work?

The Excel one is ideal. I just need to get it to work within Google Sheets.

Emmia

B0bbyEwing said:

@Emmia - what's the reason behind the Excel template not working within Google Sheets?

Do they use different code (or even slightly different code - where some may be the same & some not)?

I assuming copying it over (not drag & drop but looking at the code within Excel's cells & writing that in Google Sheets) would result in the same as drag & drop ..... and not work?

The Excel one is ideal. I just need to get it to work within Google Sheets.

I rarely use Google sheets, and I wouldn't normally try and convert between Excel and Sheets, as I have mobile access to Excel by virtue of being a subscriber.

I think what you need for do, is look at the formular in Excel, and then work out the equivalent terms in Sheets (presuming they exist), recreating the document in Sheets that way, i.e. manually, not drag and drop or copy/paste.
 
Assuming the formulae is visible (it may not be) I also wouldn't assume the formulae terms would be the same in both programs (you'll need to find a resource that will assist in this).

Additionally,  at a fundamental level it not be possible to do what you want,  as the two programs to have different functionality.

As an example of functionality differences.... in Excel there is quite a difference between what can be done in the browser/web versions of Excel (and Word) and what can be done in the desktop application, and they're both essentially the same program. These differences mean I wouldn't try and create complicated documents (i.e. ones with lots of formulae, like your sheet will have)  in the browser version of Excel, but I might fill them in that way.

Google Sheets (from my fairly limited experience) is more basic than the browser version of Excel - but it's free, so on one level you're getting what you pay for.