Spreadsheet Templates

SallyUK

Hi Everyone

I wondered if anyone had any useful spreadsheets that they used for annual leave planning for their staff / and or weekly rotas?

Something nice and simple would suffice?

Thanks

Sal
x

Fightsback

https://www.google.co.uk/search?q=useful+spreadsheets+that+they+used+for+annual+leave+planning+for&ie=utf-8&oe=utf-8&gws_rd=cr&ei=5c1iV-3UHMLegAbcx7mwDQ

SallyUK

Errr, thanks for that, but I had a look on Google first before asking on here - just thought someone might have one that they use on a regular basis and found quite useful.

Sal

Fightsback wrote: »

https://www.google.co.uk/search?q=useful+spreadsheets+that+they+used+for+annual+leave+planning+for&ie=utf-8&oe=utf-8&gws_rd=cr&ei=5c1iV-3UHMLegAbcx7mwDQ

bluesnake

the calender function in ms outlook. Staff can book time off, medical
appointments, training etc and send you an invitation.

At a glance you know when someone is not in and when they will be back.

Discodave

SallyUK wrote: »

Hi Everyone

I wondered if anyone had any useful spreadsheets that they used for annual leave planning for their staff / and or weekly rotas?

Something nice and simple would suffice?

Thanks

Sal
x

Depending on staff numbers, and what you want etc, it shouldn't be too hard to set one up? PM me with more info and I'll see what I can do?

bod1467

What version of Excel do you have? In my version at work (Office 365) when I open Excel it presents me with lost of template options, such as Employee Attendance Tracker etc.

Maybe look on the MS site (or within Excel) for a suitable template?

SallyUK

Hi


We're using Excel 2007, thanks,


Sal

bod1467 wrote: »

What version of Excel do you have? In my version at work (Office 365) when I open Excel it presents me with lost of template options, such as Employee Attendance Tracker etc.

Maybe look on the MS site (or within Excel) for a suitable template?

Gers

bod1467 wrote: »

What version of Excel do you have? In my version at work (Office 365) when I open Excel it presents me with lost of template options, such as Employee Attendance Tracker etc.

Maybe look on the MS site (or within Excel) for a suitable template?

I've just found that too - looks very useful. The place I last worked out could use something like that, they still used pieces of paper.

SallyUK

A very big thank you to you for your help with this, you've been brilliant.


Sal
x


QUOTE=Discodave;70846035]Depending on staff numbers, and what you want etc, it shouldn't be too hard to set one up? PM me with more info and I'll see what I can do?[/QUOTE]

Discodave

Your welcome!..

It was nothing... Something we used in my last place / adapted for you - hope it helps!