Results 1 to 2 of 2

Help needed: automatic shift scheduler based on conditions.

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2020
    Location
    Belgium
    MS-Off Ver
    2019
    Posts
    2

    Question Help needed: automatic shift scheduler based on conditions.

    Hey everybody,

    I am trying to create an automatic shift scheduler which automatically assigns employees (operators) to work stations.
    Background
    I supervise this team but I don't have the time to make a schedule on a daily basis, so I need a quick command which auto-populates the schedule. However the station assignment needs to be based on specific conditions
    There are three shifts:
    1. Early shift works from (6am -14pm) and breaks 8am-8.30am, 12pm-12.35pm
    2. Day shift works from (8am-16.30pm) and breaks 10am-10.30am, 12pm-12.35pm
    3. Late shift works from (2pm-10pm) and breaks 18pm-18.35pm

    Conditions
    - Max 1 operator per station
    - Operators are required to take their breaks
    - however if production demands it may be planned earlier/later but never cancelled!
    - Operators can be assigned to station after time (example new station after break)
    - Depending on production requirements not all machines should be operational. E.g before auto-generation an option to select wheter all machines or a specific one needs to be manned
    - if possible the generation could be based on operator proficiency. So E.g in normal production conditions a random generation is allowed. But in critical situation I would like to auto-assign the employees to the station they are most experienced in. I could create a employee-station table in which their experience can be ranked by score going from 1 (less experienced) to 3 (most experienced).

    Question
    I want to ask if something like this is possible and if so which would be the best method to approach this probem. Like which formulas or what kind or VBA-method would I have to use. I have little experience with VBA but I have a friend who has plenty of experience.
    Thanks in advance
    Kind regards.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Automatic shift scheduler
    By carblo in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-29-2021, 01:12 AM
  2. Automatic shift scheduler
    By carblo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-18-2019, 02:01 PM
  3. FORMULA NEEDED: Shift Differential based on Day of week and hours...
    By mark.k.conroy in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 08-16-2017, 10:26 PM
  4. [SOLVED] How to make automatic 'parallel shift' based on specific start date?
    By wintheranders in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2016, 07:16 AM
  5. Shift Scheduler problem
    By vagg3lis in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-10-2015, 05:36 PM
  6. Automatic Scheduler
    By Nuggetross in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2013, 12:23 PM
  7. Want to make automatic scheduler
    By dragonlor20 in forum Excel General
    Replies: 0
    Last Post: 05-20-2012, 10:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1