Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Create Schedule

Discussion in 'Information Technology' started by Ronbo, Nov 16, 2005.

  1. Ronbo

    Expand Collapse

    Dear Mr. Meyer,

    I am a Det/Sgt for a municipal police department, in a city of 110K, in
    Pennsylvania. I am tasked with scheduling our detectives for 2006. (Newest,
    most junior Sgt)

    We have always done handwritten schedules, and it's very time
    consuming....time that would best be spent doing police work...but it's
    "always been done this way."

    My problem is this....two teams, five men each. Mon-Saturday shifts of
    0700-1500 and 1500-2300....with one detective from the latter pulled to work

    No Sundays (a rotating "on-call" assignment will cover Sundays, and will
    back-up the 1900-0300 person on major cases)

    No major holidays (again, an on-call assignment) and reduced staffing on
    lesser holidays.

    By contract, we need to achieve 260 days of work per year. Anything in
    excess will be compensated for by awarding "schedule adjustment" days (SA
    days), or days guys can schedule off with permission to result in the
    contractual number of days being scheduled.

    Those SA days must be used by year's end. Vacation days will be scheduled
    as operations permit, or
    'carried over" to the next year.

    Can you recommend a template I can try to "plug in" those parameters and
    generate a schdule more quickly and efficiently than has been done in the

    Thanks for whatever advice you can offer.

    Ron Flowers
    flowers @allentowncity.org

    "Arvin Meyer" wrote:

    > The article was published in September 2004.
    > You can do what you want directly in Outlook. Look for books by, Byrne,
    > Slovak, Poremsky, and Moser for good Outlook references. Also ask some
    > questions in one of the Outlook newsgroups. There are plenty of great MVPs
    > there that can help you in your quest.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access Downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    > "slofotomama" <slofotomama@discussions.microsoft.com> wrote in message
    > news:992A3E43-45CB-490E-BC18-CB366C833167@microsoft.com...
    > > I looked at the appointment.zip. Thank you! If you could tell me the month
    > > your article was written, I will look that up online. What I am trying to
    > > create may be more complicated, tho'. I should elaborate. I created a mdb

    > and
    > > data access page called 'photoassignments.mdb' which anyone in our office
    > > can go to our intranet and create/print an appointment report for a
    > > photographer. (The database being generated isn't used for anything, yet).
    > > The person creating the report still has to check an appointment book to

    > see
    > > who is working or is on vacation. My goal is to replace the appointment

    > book
    > > with a scheduling database (eventually a data access page) and tie it
    > > together with the photo assignment database. My goal is when someone

    > creates
    > > an 'appointment', any conflicts and/or availability of the photographer

    > from
    > > the scheduling database would display. I was hoping to find some type of
    > > scheduling template to eliminate a lot of work. Of course I am willing to

    > dig
    > > in and do the work if a template is unavailable. Any tips or good books on
    > > how to accomplish this is appreciated. Thanks again! This site has been a
    > > great resource so far!
    > >
    > >
    > > "Arvin Meyer [MVP]" wrote:
    > >
    > > > "slofotomama" <slofotomama@discussions.microsoft.com> wrote in message
    > > > news:5F8795EF-877E-4976-91AC-F7110AACFC58@microsoft.com...
    > > > > Are there templates for creating a appointment schedule database? Or

    > can
    > > > > anyone recommend a website or book where I can learn to create one?
    > > >
    > > > I use Outlook to manage the appointments but I create them in Access. I
    > > > wrote an article in Access Advisor magazine last year explaing how to do

    > it.
    > > > The sample database for that article is at:
    > > >
    > > > http://www.datastrat.com/Download/OutlookAppointment.zip
    > > > --
    > > > Arvin Meyer, MCP, MVP
    > > > Microsoft Access
    > > > Free Access downloads:
    > > > http://www.datastrat.com
    > > > http://www.mvps.org/access
    > > >
    > > >
    > > >

  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page