HOW TO WORK WITH THE SPREADSHEET
There are some important things you have to keep in mind when using this spreadsheet. If you don't pay attention to the format of the picks you put in you will get wrong differences
. This is also mentioned in the Guide but people don't like to read guides
So here's what you need to know to avoid this situation.
- The order of the picks
must be the same as the order of the matches in the OOP. Normally this is not a problem since people usually send their picks in the order of the OOP. But if you have to change the OOP for some reason then you have to remember also to change all the picks accordingly.
- No spelling mistakes
. There's a red warning in the middle of the picks area (row 111) to help you spot them. If you see this warning appear then you have to fix the mistake before you go on. The last name in the pick must be exactly the same as the last name in the OOP (capital letters are not important). If the OOP says "Garcia-Lopez" and the pick says "Garcia Lopez" without the dash then it's a mistake and you have to fix it.
- Picks can contain only the last name and score
. Nothing else is allowed. No first names, no country names, no tiebreak scores, nothing else. Here are the accepted formats:
Nadal 64 63
Nadal 64, 63
Nadal 6-4 6-3
Nadal 6/0 6/1
(Note: Picks with both SR and PTS scores are also accepted but they are not encouraged. For example, Nadal 2-0 6:4 6:3 would give the correct result but people shouldn't send picks this way because there can be confusion if they send 2-1 64 64. My spreadsheet would give out 2-0 in this case, not 2-1.)
, I want to remind you again - you have to look over the picks before you put them into the spreadsheet to make sure that they are in the correct format. The application won't give you an error message if the pick contains a country name or symbols like & or x or _ so you have to catch them with your eyes. The only thing that will give you the red warning is spelling mistakes.