Forum Discussion
Fresh insight to an excel problem
Hello aludka,
Though I have some ideas on how to tackle this, it would be much easier to visualize with a sample of the data that you are working with. Could you please share a sample of your workbook? (please remove any sensitive data)
How was the column "Current Location" determined? Couldn't you simply filter this column to determine everything that is being held in a certain location?
Additionally, I do not see anything representing control points (CP). Is this represented by the "Current Location" column?
aludka in addition to question byPReagan I also don't follow this table. There isn't a unique product to track. the "Form Factor" has a general product that has parts all over the place and the program name and lot numbers are unique numbers throughout. Basically there is no specific LOT that is being tracked from station 1 to station 2 to ... Furthermore, most of the 'previous locations' don't ever have a present location so presumably they are all original source locations and most of the present locations are not represented by a previous location so are presumably final destinations. So if you have 50 units go from station SSU1 to SSU6 and 100 units go from SSU6 to customer how do you know how many units are at SSU6 since they can both originate there and get transferred there.
