Craigc3814
Board Regular
- Joined
- Mar 7, 2016
- Messages
- 217
Once a month I download a list of workorders for my company and assign X amount of work orders to each group per day (table below). Another table is the list of each and every work order we have. I want to assign work orders based on the amount per day specified in the table below. So on September 1st I would want 1 Elec GASMON work order assigned to ELEC then the next work order to be assigned on 9/2 then 9/3 and so on until all work orders have been assigned. Then I want it to look at Elec RGUAGE and assign the first six to ELEC on 9/1 then the next 6 assigned to ELEC on 9/2 and so on. Is this possible?
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Responsibility | Activity | Assign To | Assign Per Day |
ELEC | GASMON | ELEC | 1 |
ELEC | RGAUGE | RGAUGE | 6 |
ELEC | GEN3 | ELEC | 6 |
ELEC | GEN1 | ELEC | 1 |
ELEC | ELECPS | ELEC | 2 |
ELEC | TPHV1MO | ELEC | 5 |
GENERAL B1 | PSMNTH | B1 | 2 |
GENERAL B2 | PSMNTH | B2 | 2 |
GENERAL B3 | PSMNTH | B3 | 2 |
GENERAL B4 | PSMNTH | B4 | 2 |
GENERAL C1 | PSMNTH | C1 | 1 |
GENERAL C1 | OCSBIO | C1 | 1 |
GENERAL C2 | PSMNTH | C2 | 1 |
GENERAL C2 | MOS | C2 | 1 |
GENERAL C2 | SWPS1D | C2 | 5 |
MECH | SHOPEQ | Mech | 3 |
MECH | SUMP | Mech | 4 |
MECH | AIRS1M | Mech | 2 |
MECH | PMPDD2 | Mech | 1 |
MECH | SUBPMP | Mech | 2 |
MECH | GRINMA | Mech | 1 |
MECH | PSDRAW | Mech | 1 |
PLAN | GEN2 | Mech | 1 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>