"Randhir" wrote in message
...
Hey Biff - this is a really cool formula!! Thanks for the thought into
this

Just so I understand what it is doing (referencing your screenshot):
My understanding of the Proj1 number (b10) is that the total would be 2.5
(.5 of Kevin's time, 0.5 of Lisa's time, 0.5 of Sam's time and 1 of Bill's
time). However this formula gets me 1.25.

Similarly Proj 2 in B11 should be 1 (0.5 of John's time, 0.5 of Lisa's
time)
and Proj3 (b12) should be 1.5 (0.5 of Kevin's time, 0.5 of John's time
and
0.5 of Sam's time)

Am I missing something in the formula?

Well, I guess I didn't understand afterall!

Your explanation above makes it clear. Hmmm...... this isn't going to be
complicated, it's going to be extremely complicated!!!

Let's see if I can figure it out. No guarantees!

Biff