EdLB
asked on
Using MS ACCESS to create routings in process flow
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I can see the need for the reverse:
For a given scenario, ... Check to see if the "path" is valid, ...for example:
IsValidPath(PC1, PC3, PC4, PC5, PC3, PC4, PC3, PC5)=True
IsValidPath(PC1, PC3, PC4, PC5, PC3, PC4, PC3, PC5, PC6)=False
IsValidPath(PC1, PC3, PC4, PC5, PC3, PC4, PC3, PC5, PC3)=False
...But I cannot understand the need to generate *All* valid paths...
What would a master list be used for?
Would someone be validating this "Manually"?!?
as always, ...explaining the ultimate need is always helpful to guide experts to an efficient solution.
JeffCoachman
For a given scenario, ... Check to see if the "path" is valid, ...for example:
IsValidPath(PC1, PC3, PC4, PC5, PC3, PC4, PC3, PC5)=True
IsValidPath(PC1, PC3, PC4, PC5, PC3, PC4, PC3, PC5, PC6)=False
IsValidPath(PC1, PC3, PC4, PC5, PC3, PC4, PC3, PC5, PC3)=False
...But I cannot understand the need to generate *All* valid paths...
What would a master list be used for?
Would someone be validating this "Manually"?!?
as always, ...explaining the ultimate need is always helpful to guide experts to an efficient solution.
JeffCoachman
It is also not clear how each segment is being generated or how it will be stored.
I think I've found a more practical approachSo do you still need help with this?
Oh, and I forgot that you would also want to rule out any instance of two consecutive visits to the same process (probably).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the comments. The idea of generating all possible solutions is impractical. And besides, in production facilities there is someone who knows something about routings and can specify.
there is someone who knows something about routings and can specify.I would most fervently hope so, otherwise they'd have a very difficult time producing anything :)
ASKER
Roger that.
ASKER