Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Using MS ACCESS to create routings in process flow

Posted on 2015-01-20
10
Medium Priority
?
518 Views
Last Modified: 2015-01-21
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.
0
Comment
Question by:EdLB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 48

Assisted Solution

by:Dale Fye
Dale Fye earned 750 total points
ID: 40561172
This isn't a homework assignment, is it?

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.
0
 

Author Comment

by:EdLB
ID: 40561185
No but it would make a good one. It is a real world problem for setting up a general model of a production. I think I've found a more practical approach since there is usually lots of knowledge of the process to begin with.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40561348
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
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40561373
It is also not clear how each segment is being generated or how it will be stored.
0
 
LVL 85
ID: 40561543
I think I've found a more practical approach
So do you still need help with this?
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 40561692
Oh, and I forgot that you would also want to rule out any instance of two consecutive visits to the same process (probably).
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 750 total points
ID: 40561720
BTW, I agree with Jeff - I can't see the need to consider all valid paths. The actual number of those would be very large, as Dale pointed out, so I can't see the value in doing something like this.

If your intent is to insure your work processes follow a specific path, then you need to define that path for each process. Otherwise, you run the risk of an invalid process being considered valid - since a valid process for PartA may not be a valid process for PartB.

I deal with some very complex MRP/ERP and Process Flow programs, and all of them allow the user to create "Templates" or "Operations" where a user defines the specific Routings and Operations needed to complete a process - but none of them validate against a full set of all possible combinations. They simply validate against the stored template, based on the "process" the user is executing.

If you have multiple processes that can be performed for the same part ... then I'd suggest you're not really dealing with the SAME part, but rather a subset/component of a part, or an entirely different part which would need it's own set of instructions.
0
 

Author Comment

by:EdLB
ID: 40562045
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.
0
 
LVL 85
ID: 40562330
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 :)
0
 

Author Comment

by:EdLB
ID: 40562362
Roger that.
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question