1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Work allocation

Discussion in 'Ask an Excel Question' started by Vickyrajdhar, Jun 17, 2017.

  1. Vickyrajdhar

    Vickyrajdhar New Member

    Messages:
    2
    Dear Sirs,

    I have 8 operators to whom I need to allocate workload equally depending on their targets. For example workload is 10000 pages for the day & operator BNS is having target of 1200 pages, DDV 600 pages, SSC 1200, HAV 1200, SSC 1200, VKD 400, NHS 400 and DMR is having target of 1200 so, depending on workload they should get it equally. Can you please guide me as to how I can distribute this workload equally (more or less) between 10 operators automatically in excel.

    Thanks,
    Vicky
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,700
    Vicky

    Firstly, Welcome to the Chandoo.org Forums

    In your post you refer to 10 workers but only listed 8
    The 8 have a capacity of 7,400 units and so cannot achieve 10,000
    upload_2017-6-17_17-41-3.png

    If you increase the capacities or add more workers yes, 10,000 is acievable

    The math to evenly distribute the 10,000 is simple

    =10000*1200/7400
  3. Vickyrajdhar

    Vickyrajdhar New Member

    Messages:
    2
    Hello Sir, Thanks & Sorry I missed two operators. I have divided the workload equally for all users. What I want is, say I have 59 files for 10000 pages. Each word file contains different number of pages. I have noted down file name and number of pages. Now I want to check is, if there is any way to get the operators name automatically.PFA

    Attached Files:

  4. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,700
    Can you please post a sample file and highlight the operators name
  5. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,638
    Hi ,

    See if this works on your working file with the full set of 59 files.

    Narayan

    Attached Files:

Share This Page