Tags: excel, format, legible, mail, message, microsoft, mime, msdn, rota, software, staff, template

Staff Rota Template?

On Microsoft » Microsoft Excel

4,257 words with 2 Comments; publish: Fri, 23 May 2008 03:00:00 GMT; (30646.88, « »)

> This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.

--B_3230902059_2736668

Content-type: text/plain;

charset="ISO-8859-1"

Content-transfer-encoding: 8bit

Hi

I am trying to design a staff duty rota template for a shop open 7 days per

week. We have between 4 ­ 6 staff (depending on seasonal fluctuations) and

each member of staff has two days off per week.

I have searched the Microsoft database of templates and found nothing that

will allow me to input staff names and then automatically assign staff to

the rota in a fair and even way. Is this beyond the capabilities of Excel?

It¹s certainly beyond the capability of my tiny pea brain to programme it!

If anyone can help I¹d be really grateful. I¹d like to be able to create a

spreadsheet that lets me input shop opening and closing hours (these change

seasonally, too), input names of the staff on the books, and then give me a

rota that stretches 3-months ahead...

Any tips or advice gratefully received!

Cheers

Steve

--B_3230902059_2736668

Content-type: text/html;

charset="ISO-8859-1"

Content-transfer-encoding: quoted-printable

&

Staff Rota Template?

Hi

I am trying to design a staff duty rota template for a shop open 7 days per= week. We have between 4 – 6 staff (depending on seasonal fluctuations= ) and each member of staff has two days off per week.

I have searched the Microsoft database of templates and found nothing that = will allow me to input staff names and then automatically assign staff to th= e rota in a fair and even way. Is this beyond the capabilities of Excel? It&= #8217;s certainly beyond the capability of my tiny pea brain to programme it= !

If anyone can help I’d be really grateful. I’d like to be able = to create a spreadsheet that lets me input shop opening and closing hours (t= hese change seasonally, too), input names of the staff on the books, and the= n give me a rota that stretches 3-months ahead...

Any tips or advice gratefully received!

Cheers

Steve

--B_3230902059_2736668--

All Comments

Leave a comment...

  • 2 Comments
    • There is no built in functionality to support this.

      I would suggest you search Google for Rota or Scheduling shifts.

      http://www.google.com

      I am sure there are some free ware or inexpensive applications that will

      give you much more than you could come up with using Excel.

      --

      Regards,

      Tom Ogilvy

      "Steve Davies" wrote:

      > Hi

      > I am trying to design a staff duty rota template for a shop open 7 days per

      > week. We have between 4 ­ 6 staff (depending on seasonal fluctuations) and

      > each member of staff has two days off per week.

      > I have searched the Microsoft database of templates and found nothing that

      > will allow me to input staff names and then automatically assign staff to

      > the rota in a fair and even way. Is this beyond the capabilities of Excel?

      > It¹s certainly beyond the capability of my tiny pea brain to programme it!

      > If anyone can help I¹d be really grateful. I¹d like to be able to create a

      > spreadsheet that lets me input shop opening and closing hours (these change

      > seasonally, too), input names of the staff on the books, and then give me a

      > rota that stretches 3-months ahead...

      > Any tips or advice gratefully received!

      > Cheers

      > Steve

      >

      #1; Fri, 23 May 2008 03:02:00 GMT
    • OK, thanks Tom.

      On 19/5/06 17:27, in article

      E59D466D-786C-4D2D-B058-D83AD846DD03.excel.questionfor.info.microsoft.com, "Tom Ogilvy"

      <TomOgilvy.excel.questionfor.info.discussions.microsoft.com> wrote:

      > There is no built in functionality to support this.

      > I would suggest you search Google for Rota or Scheduling shifts.

      > http://www.google.com

      > I am sure there are some free ware or inexpensive applications that will

      > give you much more than you could come up with using Excel.

      #2; Fri, 23 May 2008 03:03:00 GMT