Form design for staff schedules that vary..

[Smriti Dev]

Hi,

I am creating a form that allows users' to enter dates and times staff are
available for work.
They are 2-3 different types of staff. For example, permanent staff that
work M-F 9-5 pm generally
and then contract and volunteer staff that work on particular days and
timings
I am not sure how to design the form so that users' are able to easily put
the availability of permanent staff
without typing each date and also contract staff which has highly variable
dates and timings timings.

For the permanent I want to be able to put a general time like M-F 9-5 pm
and it should take effect for all the timings in the calendar year.

I would really appreciate your help with this.

Thanks so much.
smriti
--

[Mondrogan]

Well, this is not so easy, IMO, but here are some thoughts that might get
you started:

Assume the employee's schedule will be determined weekly. Then for each
employee, you need (to begin with) two tables: the first provides a template
schedule table from which to construct the employee's actual next week's
work schedule. And the second table, of course, is the employee's actual
work schedule for the next week.

To fill in the template schedule table, you might have a form with
checkboxes and fields such as:

Start1 Lunch Start2 Finish
[X] M-F 8:00 12:00 1:00 5:00
[ ] Monday
[ ] Tuesday
[ ] Wednesday
[ ] Thursday
[ ] Friday
[ ] Saturday
[ ] Sunday

For each row, fill in the corresponding record in the Template Schedule
table.

At the beginning of each work week, you need to run code to construct the
actual work schedule for each employee, which will (mostly) be the template
schedule minus holidays, vacation days, or other planned downtimes. This is
where the complications arise.

You should include code to automatically adjust for holidays, vacations, and
such. You need a table listing general company holidays. You need another
table listing requested vacation days specific to each employee. Use the
info in these tables when constructing the actual work week from the
template work week.

You won't be able to automatically generate a perfect actual work week, in
all cases. For instance, the user might decide to work overtime on Thursday
night. So you will need to allow the user to edit the actual table, as
necessary.

Hope this helps.

"Smriti Dev" <sm********@utoronto.ca> wrote in message
news:IL********@campus-news-reading.utoronto.ca...

Hi,

I am creating a form that allows users' to enter dates and times staff are
available for work.
They are 2-3 different types of staff. For example, permanent staff that
work M-F 9-5 pm generally
and then contract and volunteer staff that work on particular days and
timings
I am not sure how to design the form so that users' are able to easily put
the availability of permanent staff
without typing each date and also contract staff which has highly variable
dates and timings timings.

For the permanent I want to be able to put a general time like M-F 9-5 pm
and it should take effect for all the timings in the calendar year.

I would really appreciate your help with this.

Thanks so much.
smriti
--

[PC Datasheet]

Hi Smiriti,

I have a scheduling calendar module that I sell that could do this. There's
a calendar form for entering data into any calendar day and a calendar
report to printout. Like the names of the form and report imply, the form
and the report look like a page taken from a calendar. The times your staff
are available to work could be entered into any day in the calendar form.
Holidays and general organization vacation days could be programmed into the
calendar. You would be limited by the number of staff you could see each day
on the screen because as you can imagine a page from a calendar on the
screen has limited display space for each day. You would need to scroll any
day to see all who are available for work that day. To overcome this
limitation, there are two options. My calendar form allows your staff to be
broken down into groups where each group has its own calendar. If you break
your staff into small enough groups, each group would have its own calendat
and all members of the group could be displayed on the screen. The other
option is that my monthly calendar module could be adapted to be a weekly
calendar module where there would be more display room for each day. The
days in the calendar report obviously can not be scrolled so its limitations
is more pronounced. You could however print multiple calendars with
different staff on each calendar. If you are interested in my calendar
module, send me an email to my email address in my signature line below and
I will send you a screen shot of my calendar form and calendar report.

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Smriti Dev" <sm********@utoronto.ca> wrote in message
news:IL********@campus-news-reading.utoronto.ca...

Hi,

I am creating a form that allows users' to enter dates and times staff are
available for work.
They are 2-3 different types of staff. For example, permanent staff that
work M-F 9-5 pm generally
and then contract and volunteer staff that work on particular days and
timings
I am not sure how to design the form so that users' are able to easily put
the availability of permanent staff
without typing each date and also contract staff which has highly variable
dates and timings timings.

For the permanent I want to be able to put a general time like M-F 9-5 pm
and it should take effect for all the timings in the calendar year.

I would really appreciate your help with this.

Thanks so much.
smriti
--