Nosewheel Roulette Spreadsheet

I have completed the nosewheel roulette flight and computed the results, but just to keep things both geeky and suspenseful around here, I will first present my computations for debugging and critique.

I filled a spreadsheet (Open Office - I told you we were going to be geeky) column (column A) with the numbers 0 to 128. (Yes, the numbers should only go to 127, but someone picked 128. Because a wheel is round, that wraps him back to zero, but I didn't put him in the zero box because it was a test of my algorithm having it there).

In the next column (B) of the spreadsheet I put an x next to all the numbers that were spoken for by someone, based on the posted comments. In the next column I put something else I ended up ignoring and in the final column (D), I calculated the distance each guess was from the actual by taking the lesser of:
- the difference between the guess and the answer
AND
- 128 minus the difference between the guess and the answer.

In other words, I measured the shorter distance around the wheel between your guess and the actual final position. If the difference between your guess and the answer was greater than 64, you're getting closer to the answer round the other way.

In the spreadsheet this formula was:
=IF(B4="x";MIN(ABS(F$3-A4);128-(ABS(F$3-A4))))
(There's probably a neater way to do that with modular arithmetic, but I was watching TV at the time and my brain kept resetting).

In the formula, B is the column that has an x to indicate that the number is spoken for, F$3 is the measured answer, and A4 is the guess in row 4. I copied this formula down the whole column (the spreadshhet automatically increments A4 for each row). And then finally I sorted the spreadsheet row-by-row on value in column D, the result of that formula.

I'll leave this overnight for you to find any glaring errors or controversies, before I present the results, your SunglassesShop.com sunglasses winners, and the booby towel designee.