David Kirker
New Member
- Joined
- Jun 11, 2018
- Messages
- 1
My goal is to create a schedule using the fewest number of people as possible while maintaining a minimum interval between procedures. I start by adding the letter ‘A’ in the f.name column and continue until I see an interval in the time column that is less than desired (3 to 5 min, depending). I will add subsequent letters (B, C, D, E, etc.) as needed but always default to the first letters where possible. I then resort by f.name and time to create shifts for actual people. I am happy to pay for this code but my first question is. CAN THIS BE DONE? Second, what might this code look like? I have limited experience with VBA but no longer have time to research the code. Any help is greatly appreciated. I'm using excel 2013 on Office 365. I expect the upgrade to 2016 soon.
This is the sheet I use:
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is the product, where I have failed to meet the minimum interval:
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is the sheet I use:
NUM | INT | T.S. | PROCEDURE | T.P. | TIME | F.NAME | L.NAME | |
1 | BC (1 Tube) | 0.25 HR | 06:15 | A | 00:07 | |||
2 | BC (1 Tube) | 0.25 HR | 06:22 | A | 00:07 | |||
3 | BC (1 Tube) | 0.25 HR | 06:29 | A | 00:01 | |||
1 | BC (1 Tube) | 0.5 HR | 06:30 | B | 00:06 | |||
4 | BC (1 Tube) | 0.25 HR | 06:36 | A | 00:01 | |||
2 | BC (1 Tube) | 0.5 HR | 06:37 | B | 00:06 | |||
5 | BC (1 Tube) | 0.25 HR | 06:43 | A | 00:01 | |||
3 | BC (1 Tube) | 0.5 HR | 06:44 | B | 00:01 | |||
1 | BC (1 Tube) | 0.75 HR | 06:45 | C | 00:05 | |||
6 | BC (1 Tube) | 0.25 HR | 06:50 | A | 00:01 | |||
4 | BC (1 Tube) | 0.5 HR | 06:51 | B | 00:01 | |||
2 | BC (1 Tube) | 0.75 HR | 06:52 | C | 00:05 | |||
7 | BC (1 Tube) | 0.25 HR | 06:57 | A | 00:01 | |||
5 | BC (1 Tube) | 0.5 HR | 06:58 | B | 00:01 | |||
3 | BC (1 Tube) | 0.75 HR | 06:59 | C | 00:01 | |||
1 | BC (1 Tube) | 1 HR | 07:00 | A | 00:04 | |||
8 | BC (1 Tube) | 0.25 HR | 07:04 | B | 00:01 | |||
6 | BC (1 Tube) | 0.5 HR | 07:05 | C | 00:01 | |||
4 | BC (1 Tube) | 0.75 HR | 07:06 | A | 00:01 | |||
2 | BC (1 Tube) | 1 HR | 07:07 | B | 00:04 | |||
9 | BC (1 Tube) | 0.25 HR | 07:11 | C | 00:01 | |||
7 | BC (1 Tube) | 0.5 HR | 07:12 | A | 00:01 | |||
5 | BC (1 Tube) | 0.75 HR | 07:13 | B | 00:01 | |||
3 | BC (1 Tube) | 1 HR | 07:14 | C | 00:04 | |||
10 | BC (1 Tube) | 0.25 HR | 07:18 | A | 00:01 | |||
8 | BC (1 Tube) | 0.5 HR | 07:19 | B | 00:01 |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is the product, where I have failed to meet the minimum interval:
NUM | INT | T.S. | PROCEDURE | T.P. | TIME | F.NAME | L.NAME | |
1 | BC (1 Tube) | 0.25 HR | 06:15 | A | 00:07 | |||
2 | BC (1 Tube) | 0.25 HR | 06:22 | A | 00:07 | |||
3 | BC (1 Tube) | 0.25 HR | 06:29 | A | 00:07 | |||
4 | BC (1 Tube) | 0.25 HR | 06:36 | A | 00:07 | |||
5 | BC (1 Tube) | 0.25 HR | 06:43 | A | 00:07 | |||
6 | BC (1 Tube) | 0.25 HR | 06:50 | A | 00:07 | |||
7 | BC (1 Tube) | 0.25 HR | 06:57 | A | 00:03 | |||
1 | BC (1 Tube) | 1 HR | 07:00 | A | 00:06 | |||
4 | BC (1 Tube) | 0.75 HR | 07:06 | A | 00:06 | |||
7 | BC (1 Tube) | 0.5 HR | 07:12 | A | 00:06 | |||
10 | BC (1 Tube) | 0.25 HR | 07:18 | A | 00:03 | |||
4 | BC (1 Tube) | 1 HR | 07:21 | A | 00:06 | |||
7 | BC (1 Tube) | 0.75 HR | 07:27 | A | 00:05 | |||
12 | BC (1 Tube) | 0.25 HR | 07:32 | A | 00:03 | |||
6 | BC (1 Tube) | 1 HR | 07:35 | A | 00:05 | |||
11 | BC (1 Tube) | 0.5 HR | 07:40 | A | 00:04 | |||
3 | BC (1 Tube) | 1.5 HR | 07:44 | A | 00:04 | |||
10 | BC (1 Tube) | 0.75 HR | 07:48 | A | 00:05 | |||
15 | BC (1 Tube) | 0.25 HR | 07:53 | A | 00:03 | |||
9 | BC (1 Tube) | 1 HR | 07:56 | A | 00:04 | |||
1 | BC (1 Tube) | 2 HR | 08:00 | A | 00:03 | |||
10 | BC (1 Tube) | 1 HR | 08:03 | A | 00:04 | |||
2 | BC (1 Tube) | 2 HR | 08:07 | A | 00:03 | |||
11 | BC (1 Tube) | 1 HR | 08:10 | A | 00:04 | |||
3 | BC (1 Tube) | 2 HR | 08:14 | A | 00:03 | |||
12 | BC (1 Tube) | 1 HR | 08:17 | A | 00:04 | |||
19 | BC (1 Tube) | 0.25 HR | 08:21 | A | 00:03 | |||
13 | BC (1 Tube) | 1 HR | 08:24 | A | 00:04 | |||
20 | BC (1 Tube) | 0.25 HR | 08:28 | A | 00:02 |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>