This is what I know from that drill. If the third target is determined and does not panic or flee when the shooting starts and is semi competent he should have been able to effectively put rounds on target (me) before I put my rounds on him.
That is very likely. You'll note that's one of the caveats that must be kept in mind when interpreting the calculation results. I've stated it multiple times in the thread starting in the third post to try to keep that important caveat from being forgotten.
"For the purpose of calculating the probabilities, let's assume you ALWAYS have enough time to fire all your shots..."
"it must be assumed that the shooter will get a chance to fire all ... rounds before being incapacitated..."
"...and you get a chance to use all your ammo..."
"There's nothing that tries to account for the possibility of ... actually being unable to shoot your remaining rounds..."
In reality getting to a second target before the above becomes true is a problem.
Yes. Dealing with multiple targets is really difficult. For people who don't have your initiative to get out and try some scenarios at the range that mimic multiple attacker scenarios, they can run the probabilities here and get a little bit of a feel for how hard they are even without getting into the time constraints that are felt keenly at the range and even more keenly in a gunfight.
Think about the 8th shot in your own program: to get that far you have likely already had some luck in regards to the inability of your opponents to neutralize you (maybe you moved to cover?).
Right. That's wrapped into the assumption that you get to shoot all your shots. If you get killed/neutralized with rounds in the magazine then they don't do you any good.
That's why the results of the calculations should be viewed as a sort of "best case" outcome. There are lots of reasons why the outcome could be a lot worse than the probability suggests, but, and this is the important part. It's very unlikely that they will be significantly better.
They can't tell us if we will succeed. They can provide insight into scenarios where success is very improbable. They can give us an idea of what kinds of scenarios (based on the three parameters of hit probability, number of shots required and capacity) are "workable" and which ones aren't. They allow us to vary the three parameters to see how they affect the workability of the scenario.
Part of the value of the calculations is that they help us understand that there's a real possibility of emptying the gun and still having a problem that needs solving. That could be very valuable insight if it prompts us to take actions so that by the time the gun is empty, we're in a better position than we started in--that we're not simply back where we started but this time with an empty gun.