Vickyrajdhar
New Member
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
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