Automatically calculate values

brianf00 

I'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.