Results 1 to 6 of 6

Guidance with employee shift schedule

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2020
    Location
    Lod, Israel
    MS-Off Ver
    365
    Posts
    4

    Guidance with employee shift schedule

    Hello,
    I attached a worksheet from February, it contains 2 sheets:

    1. input
    2. output


    The input sheet:
    - a monthly requests input sheet
    * '1' - block the date
    * '3' - prefer the date
    * ' ' - the date is not blocked, nor preferred [I can schedule the employee on that date]

    *Each employee can choose how many shifts to be scheduled [minimum '1']

    * Each date requires 2 employees

    *The input sheet requires some 'cleaning':
    - The shifts are only on 'Sundays', 'Mondays' and 'Wednesdays'.
    - It would be simpler if it would automatically remove the unnecessary days, or simply auto-create a monthly table with the 3 days only


    Is it possible to create the output automatically or at least some of it?

    Are there any suggestions to adjust the input sheet, to be more "automatable"?

    Thank you!
    Amir Zbede
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Day and Shift wise allocation from Roster / employee shift schedule
    By Ravi_Kadu in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-11-2021, 07:40 PM
  2. Noob here- best approach to extract personal schedule based on an employee schedule sheet,
    By fortnight_skyrim in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2018, 01:02 AM
  3. Employee Shift Schedule
    By ShermyG in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2018, 10:19 AM
  4. Building an Employee Shift Schedule that Automatically Deducts Breaks
    By derdoktor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2016, 04:09 AM
  5. Add employee name to schedule based on Shift and date
    By BARBIEE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-18-2016, 12:44 AM
  6. Replies: 0
    Last Post: 10-27-2014, 11:54 PM
  7. Shift Schedule - 3 Shift Coverage - Auto Populate Roll-up Summary Schedule
    By chips1256 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-31-2012, 09:32 AM

Tags for this Thread

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