Forum Discussion
Automatically calculate values
Is there a way to make the "WHAT YOU WILL NEED TO RUN" update to equal 6 based off values put into actual tpph?
10 Replies
- The problem is there or not you need to check, as well as an alternative to the reliability of the communication site, perhaps a duplicate, as a rule, such problems are disagreements of the parties.
Tag Urgent,Disconnection,Technical Issue,Security brianf00 If this is what you need....
The formula in C4 is =IF(B3=0,C2,B2-B3+C2)
Copy it to D4:H4
So I assume this is a manufacturing schedule. Projected is what was planned. Actual was what was made. If we were projected to make 6.25 on Wed, but we only made 6, we will need to make 6.5 on Thu. to catch up.- Is there a way to explain more fully what you mean? I suspect the answer to the question is "Yes," but the question is quite unclear. "Based off values put into .." --what's the relationship between that phrase "based off", the "6" that you desire, and the various "projected" values of TPPH?
- for example...
projected tpph is 6.25 for Friday
Say TPPH for Wednesday is 5.5 and Thursday it's 5.1
then the "WHAT YOU WILL NEED TO.." boxs will update with outcomes needed on the days following to equal 6I'm sure that's clear in your own mind. It's not there yet in mine.
WHAT is the relationship between the top "Projected" set of values and what you're trying to do? I can see no way, for example, that the 6 at the end of the week is the outcome of that string of values.
And your example mentions a projected value of 6.25 for Friday, actuals for Wed and Thu of 5.5 and 5.1, but the week runs Wed-Tue, so there are still five more days, each of them with their own "projected" values (as noted above, their relationship with the whole thing is murky). Is the desired 6 at the end of it all an average....
Can you walk through a manual example of how you calculate this now, in the absence of a nice tight Excel formula. All the way through to the final 6, not just the first two days.
As I said at the start, I suspect that the formula you are seeking will be relatively easy, but you haven't yet explained the underlying relationships here that need to be turned into a formula.
What, by the way, is TPPH in the first place? I realize that it doesn't really matter in the math, but it's part of "the black box" that you've given us.
