I have a production process with 5 processing centers, for instance:
PC1 is forming
PC2 is welding
PC3 is final assy
PC4 is testing
PC5 is Crating
I would like to create a routine in MS ACCESS that generates all possible paths (routings) for a part or set of parts subject to the following conditions:
Parts can go to any sequence of process centers, minimum number of steps is 1, maximum is 8. I would like to be able to specify the min and max limits.
There are a couple of configurations:
1) Parts can visit the same process center more than once but I'd like to be able to specify the limit of visits to any one process center to 3. So, for instance, I would allow a PC1, PC3, PC4, PC5, PC3, PC4, PC3, PC5 routing.
Well, if you leave out the restriction of no specific process may be visited more than 3 times, it would be the sum of 5^1 + 5^2 + ... + 5^8 = 488,280 combinations. But the limitation on no single process being "visited" more than 3 times will lower that number of possible combinations significantly.
But to actually generate the set of values, you would have to create an outer loop to determine the # of steps, and then a recursive function that would generate N numbers, and then a series of steps to assess whether the sequence meets your 3 "visits" criteria.