mountainpusher
New Member
Hello everyone,
I ran into a problem for a project I'm working on. What I am trying to do is get a projection of units to hit the highlighted step for 12, 24, 36 and 48 hours out based off the cycle time. I'm trying to make it more dynamic though where it could be based off any given step in the process (not necessarily just one of the highlighted steps). What I am attaching is just part of 1000+ steps in the whole process but basically wanted to give different example/test points. Please infer that everything will move to the next step in the given cycle time in the cycle time length as too not over complicate it even more.
How my though process is currently working:
1. Select step
2. Add previous steps Cycle Time together until "x" hours is reached (not including current step)
- Bottom to top
3. Once "x" is reached highlight all cells, RANGE(E)
4. *Optional - Good to test previous steps functionality* Take SUM(RANGE(E)) total and output to adjacent cell
5. From RANGE(E) for "x" take adjacent cells of Processing/waiting/blocked and SUM(B,C,D) for the whole range
6. Output SUM(B,C,D) for the whole range into the given highlighted box for "x" time out
So I need help implementing what I am thinking into making it work. I'm trying to get it to work in google sheets as well but wanted to start with excel and work back from there. Let me know if this doesn't make sense or if you have any questions.
I ran into a problem for a project I'm working on. What I am trying to do is get a projection of units to hit the highlighted step for 12, 24, 36 and 48 hours out based off the cycle time. I'm trying to make it more dynamic though where it could be based off any given step in the process (not necessarily just one of the highlighted steps). What I am attaching is just part of 1000+ steps in the whole process but basically wanted to give different example/test points. Please infer that everything will move to the next step in the given cycle time in the cycle time length as too not over complicate it even more.
How my though process is currently working:
1. Select step
2. Add previous steps Cycle Time together until "x" hours is reached (not including current step)
- Bottom to top
3. Once "x" is reached highlight all cells, RANGE(E)
4. *Optional - Good to test previous steps functionality* Take SUM(RANGE(E)) total and output to adjacent cell
5. From RANGE(E) for "x" take adjacent cells of Processing/waiting/blocked and SUM(B,C,D) for the whole range
6. Output SUM(B,C,D) for the whole range into the given highlighted box for "x" time out
So I need help implementing what I am thinking into making it work. I'm trying to get it to work in google sheets as well but wanted to start with excel and work back from there. Let me know if this doesn't make sense or if you have any questions.
)