Any chance of sending me a template asap if I send you my email address in a PM, Drew?

As I could do it and finish it by midnight for sure.

It's probably too late for this time, but if anyone wants a template, just click on http://www.xlw93.dial.pipex.com/2007AO.xls - it will start a download (the file has been virus-checked with Norton AV with up to date virus definitions - beyond that it's at your own risk, but that would be good enough for me to consider it safe!) which you need to SAVE (not open), preferably adding your name to the bit before the .XLS when you save it, and remembering where you saved it.

For each match, you then just need to put a 1 in the yellow box just to the right of the player you think will win and it will fill their name into the next round. (you can put 0 in the box for the other player or leave it blank) When you've done them all, just attach it to an email to Bethan.

It's so easy to do, you might like to give it a try anyway, even if you've already sent your picks in. If you do, let me know if you like it - if so, I'll produce the same sheet before the next time we do this, but a lot earlier! And David might like to use it as an easy way of converting any text predictions people have sent to Excel if he hasn't done it already.

Bethan - if you get many people submitting picks in this format, let me know - it would be fairly easy for me to set something up so that all the pick sheets are in one workbook with a blank pick sheet at the front. You would then just have to do the same (1 against the winner) on the blank pick sheet when the results come in and the scores would get calculated automatically.

 

-- Edited by steven at 20:25, 2007-01-14

Spreadsheet updated at 20.47 GMT to correct a minor error in the note about how many picks you have left to make - doesn't affect any of the actual picks though, the processing for that was fine.

Oops, the update didn't upload properly. It should be fine now, and I've done all my own picks on it with no problems.

I have filled one in. Where do I email it to?

mkkreuk wrote:

---

john wrote:

---

I have filled one in. Where do I email it to?

---

ditto.

---

email to Davids email....its on his profile....or email it to me and I can pass on...!