Creating a Cleaning & Product Usage Schedule

So depending on the Product you are on and the product you change to, do the hopper numbers change or just the time mins?

As Blind Alley mentioned, maybe if you had a data table you could have a couple of drops downs - 1 for the product you're on and one you're changing two, and when those 2 options were chosen, the user would be presented with the right results?

We need to more as far as how this works.

Thank you

Well, this might be a start. I need more info, but before I go down a rabbit hole, I wanted to know if this is something that you might be able to use.

Basically it lets the user select which Product they are on, and which Product they are going to, and then how much time it will take to clean the hoppers that are the same in both products. I just started with 3 products, and you can select any products going from/to and you will see the data dynamically changing below.

Hi Gregb11,
Thanks for taking the time to try and help, I like what you have done but I have an issue and here it is,

say I change from product 1 to product 2, hopper 2 is used in both products with the same material so no need to clean but the file you attached still gives a cleaning time.
Hopper 9 is used in both products but with a different material so needs cleaned - the file correctly allocates a cleaning time.
Hopper 4 is used in product 1 but not in product 2 so needs cleaned - the file does not allocate a cleaning time.
Also hoppers 1,4,6,8 are used in product 1 but not product 2 so need cleaned but are not allocated any clean time.

I do not know if there is a way around this as the file will always assume the hopper needs cleaned if used in both products but assumes if used in 1st product but not in 2nd that it does not need cleaned but it does.

Please let me know if you come up with anything.

Many thanks

Lewster

In your example, let's say Material "MAT1" is used in Hopper 2 (for Product 1). Will hopper 2 ALWAYS have MAT1 in it when you are making Product 1, or tomorrow when making Product 1 could you have MAT1 in Hopper 6 (or any hopper other than 2)?
Also, is the clean time for the hoppers just based on the hopper themselves or does the clean time change depending on what material is in them? And, would you ever have the scenario where both products use the same material but in a different Hopper? For example, would it ever happen where Product 1 uses MAT1 in Hopper 2, but when making Product 2 you would put MAT1 in Hopper 6?

When making product 1, hopper 2 will always have material 1 in it,
clean times do not vary from materials so hopper 2 will always take 20 mins whatever material is in there,
No if product 1 uses mat 1 in hopper 2 then mat 1 when used will always be in hopper 2 whatever product is made

Hope that clear, thanks

The attached has 3 tables:
1. Product/Hopper/Material table
2. Hopper/Clean Time
3. Product List

User selects their current Product and then what product they're changing to.
Below the selection it will show all the hoppers needed for each product selected and the material.
It then calculates the time it takes to clean those hoppers that are used for both products but use different materials.

You are getting there, thanks for your patience.

I think the only issue now is that the hoppers that were used in product 2 but not in product 3 also need cleaned as they may be used in another product for different materials further down the line.

Thanks

OK, so I added that new requirement now. You'll see I put in a column for cleaning for each product, and then added them together.

Brilliant, let me set it up with actual names of materials etc and I will get back to you but thank you for what you have done thus far.

Lewster

You're welcome. Glad I could help.

Well that looks just dandy, thank you so much Gregb11 you have save me so much work and it looks neater and more functional.

Yet again this group has come through for me.

Respect

Lewster