Results 1 to 14 of 14

Point of work-wise (POW) Allocation in rotation

Threaded View

  1. #5
    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,
    Thanks for your prompt response and valuable information,
    I have updated formula as per your instruction (file is attached for ref.), however, result is not appearing as desired..

    requirement
    - We have to allocate all the staff in following manner in rotation (whenever staff deployed in D and N);
    ODC Gate
    Lane_01
    Lane_02
    Lane_03
    Lane_04
    Lane_05
    Lane_06
    Lane_07
    Lane_09
    Lane_10
    Lane_11
    Lane_12
    South Gate
    Yard Gate_01
    Yard Gate_02
    Reliver_01
    Reliver_02
    Reliver_03
    Reliver_04
    Reliver_05

    and

    Pre-Gate (fixed POW for 1201 Pramod Rohidas Patil & 1212 Mangesh Govardhan Gharat )

    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