Re: Form design for staff schedules that vary..

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" <smriti.dev@xxxxxxxxxxx> wrote in message
news:ILosx5.JB1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> 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
>
>
> --
>
>


.

Relevant Pages

  • staff monthly scheduling problem
    ... me to prepare a schedule for a staff of 10, some part time, some full. ... formula I could to develop a monthly calendar with set shifts ... for unchanging employees that would calculate hours for each employee ...
    (microsoft.public.excel.misc)
  • Re: Efficient Formula?
    ... when staff were working. ... NAME Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon ... The problem here is that I am passing the actual schedule value to the ... it occurs to me that 40 days after every holiday ...
    (microsoft.public.excel)
  • Re: Remote Support through Firewalls and Proxy Servers
    ... "Shane Stump" schrieb: ... after schedule and after having spent numerous hours in the Hospital, getting to know most of the staff there). ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Remote Support through Firewalls and Proxy Servers
    ... "edbored" schrieb: ... after schedule and after having spent numerous hours in the Hospital, ... getting to know most of the staff there). ... Danijel ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Combining templates
    ... schedule our jobs based on the General contractors schedule. ... We have an excel template that our ... and template type (meaning what type of elevator are we installing). ...
    (microsoft.public.project)