Results 1 to 14 of 14

Point of work-wise (POW) Allocation in rotation

Threaded View

  1. #11
    Registered User
    Join Date
    03-15-2017
    Location
    Mumbai
    MS-Off Ver
    2013
    Posts
    96

    Re: Point of work-wise (POW) Allocation in rotation

    Sir,
    Can it be modified said file as follows

    I have inserted
    4 more rows (highlighted in yellow colour) above (in between fix and rotational staff)
    1 more column (highlighted in yellow colour) (Gate (B) & 5th Jun(D))
    Range is modified till XFA instead of CW, so that i will add further roster like-wise

    Requested changes as follows;
    1. In case of Revilers (Reliver_01, Reliver_02, Reliver_03, Reliver_04, Reliver_05), it is considered to be a single POW and then move to next POW
    for On 6th Jun D 1391 Ajit Thakur is a Reliver_04 now on next immediate shift shift he should be moved to next; other than Revilers POW
    (as per this file he is at Reliver_04 on 6th Jun D and then on his next shift he appearing again as Reliver (Reliver_01) on 7th Jun D

    2. In case there is no person at POW Pre-Gate anyone from Relivers is to be appeared at POW Pre-Gate.

    Thanks in advance.

    - Ravi
    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. [SOLVED] need to arrange column wise data to row wise with monthly wise
    By alok.gupta4ever in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-03-2016, 11:11 AM
  3. Work Rotation planner
    By drwats0n in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2015, 12:26 PM
  4. Work Schedule Rotation Gantt Chart Help - Conditional Formatting
    By vshen116 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2015, 09:45 AM
  5. Work Rotation schedule
    By schaubers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2013, 01:14 PM
  6. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  7. Determining the Point and Angle of rotation
    By Ashraf_Robot in forum Excel General
    Replies: 9
    Last Post: 06-12-2012, 02:44 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