Flights through the Twilight Zone sounds Crazy, I know. I might be the first Crazy Person to Dream this up.  I think my Excel Addiction got carried away Looping and IFing as I dove into these so called “Flight Plans.  But something else was happening. 

Each Flight produced 6 Sets of Numbers as explained earlier.  I started by looking for Flight that had 5 Hits in 1 of the 6 “Stacks” of Numbers.  Comparing the Numbers in these stacks provided a way of reducing the Net Stack by eliminating numbers that were not found on all of the Stacks that were compared.  The problem here is that the Stacks are Tall.  Often these 5 Hit Stacks contain more than 35 Numbers.  Comparing 4 or 5 Stacks would reduce the Net Stack by a few more Balls.  In a Nutshell I could find the Jackpot (5 Hit) in somewhere around 27 Balls.  To do that I had to Guess (Select) the Stacks that would contain 5 hits and compare around 4 to 6 of them.  Several of the Flights consistently found the Jackpot generally with Inventories of 30 or more Balls.  Comparing these stacks eliminated a few more balls but the Goal of getting the inventory to 10-15 would require another comparison.

Enter the Zero hit comps.  There are several Flights that produced a small Stack of 4 to 10 numbers without a single Hit.  Comparing from 4 to 8 Stacks of these Stacks brought the Inventory down to as low as 7 Balls and produced a 5 Hit.  To do that I had to guess which of the Stacks would be hitless.  If I could guess this Right I reached my Goal. 

Now I am running a Sheet called All or Nothing that quickly does the 5 Hit Comps and the No Hit Comps. 

Have you added up the Guesses yet.  Well you have to Guess which Stacks to Compare and then Guess how many hits each one contains.   

Dizzy yet?  Maybe this will help.  Stare if you Dare.

I think I Need a shower.