Create an Assignment Schedule/Plan

isadoko

Active Member
Joined
Jan 10, 2005
Messages
322
Office Version
  1. 365
Platform
  1. Windows
I would appreciate any help to create a mechanism to distribute assignments to a group of people.

10 People
22 Assignments (same assignments monthly but not repeated by any one person until has done all 22)
10 instances of each (same) assignment to be done by each person
OK that people be assigned portions of some assignments to attempt keep distribution approximately even; that is about the same number of instances per person
12 months of assignments

Let me know if I have not provided enough or clear information. Thank you.
 
Last edited:

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Not enough information, I understand that are 220 intances a year to distribute among 10 workers?
Sergio
 
Upvote 0
Thanks for your interest in my question. How about this...

Every month I must evaluate 22 forms using 8 people--lost two. I need assign, randomly, monthly, at least three forms to each of the 8 people. While the math works out to 2.75 I will just round up to three forms per person. When a person(s) is absent may have to assign more than three per person. At some point in the year they will repeat forms--no problem. So I think of it this way:

Person 1, Jan, forms 1-3
Person 1, Feb, forms 4-6
Person 1, Mar, forms 7-9
Person 1, Apr, forms 10-12
Person 1, May, forms 13-15
Person 1, Jun, forms 16-18
Person 1, Jul, forms 19-21
Person 1, Aug, forms 22-2 (starting over at form 22, 1, 2)
Person 1, Sep, forms 3-5
Person 1, Oct, forms 6-8
Person 1, Nov, forms 9-11
Person 1, Dec, forms 12-14

Person 2, Jan, forms 4-6
Person 2, Feb, forms 7-9
Person 2, Mar, forms 10-12
Person 2, Apr, forms 13-15
Person 2, May, forms 16-18
Person 2, Jun, forms 19-21
Person 2, Jul, forms 22-2 (starting over at form 22, 1, 2)
Person 2, Aug, forms 3-5
Person 2, Sep, forms 6-8
Person 2, Oct, forms 9-11
Person 2, Nov, forms 12-14
Person 2, Dec, forms 15-17

I hope this sheds more light on my challenge. I want to be fair and even-handed while making sure all 22 forms are evaluated monthly throughout the year and all persons eventually evaluate all forms. Thanks again.
 
Upvote 0
So you need a formula to do some thing like this for different amount of Workers?

WrkNum
FormJanFebMarAprMayJunJulAugSepOctNovDec
1187654321876
2187654321876
3187654321876
4218765432187
5218765432187
6218765432187
7321876543218
8321876543218
9321876543218
10432187654321
11432187654321
12432187654321
13543218765432
14543218765432
15543218765432
16654321876543
17654321876543
18654321876543
19765432187654
20765432187654
21876543218765
22876543218765

<tbody>
</tbody>

Cheers
Sergio
 
Upvote 0

Forum statistics

Threads
1,224,558
Messages
6,179,512
Members
452,919
Latest member
krismmmitch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top