Problem I. 359. (November 2014)
I. 359. In this task you are going to analyze the data of a tennis match. The match result and its current state are determined as follows.
1. A match is finished if one player wins at least 3 sets.
2. To win a set, the player needs to win at least 6 games such that there is a margin of at least 2 points over the opponent. For example, a set can be won by 6:1, 6:4, 7:5 or 11:9, but it cannot be won by 6:5 or 7:6 -- there are no ``short sets'' in the present exercise.
3. A game is won if the player has won at least 4 points provided that there is a margin of at least 2 points over the opponent.
4. For the purposes of the present exercise, a point is always won by either the server (A) or the receiver (F).
The match starts with the first player being the server. Within the same game, the same player is the server. In the next game, the other player becomes the server irrespective of the current player scores.
The first column of the spreadsheet labdamenetek (= Points) should contain for each point - up to a certain standing of the match - whether it was scored by the server (A) or the receiver (F). There can be at most 1000 points in a match, and a letter A in the \(\displaystyle n\)th row of the sheet indicates that the \(\displaystyle n\)th point was scored by the server. After the match is over, no further points are stored in the sheet, in other words, the cells are empty below the last A or F letter.
The állás (= Standing) sheet should contain the actual standing of the match, according to the last row of the sheet labdamenetek, containing the standing of the won sets, the results of the earlier sets, and the standing of the games within a given set, finally, the standing within the game. The first row of your table should contain a heading according to the description above. To obtain the maximum number of points for this exercise, you should present the standings within a game in the usual format.
The first 4 columns of your sheet teszt (= Test) should contain some values for which the állás sheet gives correct results if a column from the teszt sheet is pasted into the first column of the labdamenetek sheet.
Your solution should not contain any macros or user-defined functions. Beginning with the second column of the labdamenetek sheet, you may use any number of auxiliary cells.
In the example, the állás sheet is shown: ``Első'' is first, ``Második'' is second, ``Játékos'' is player, ``játszma'' is set and ``Nyert játszmák'' is the sets won, finally, ``Aktuális játék'' means the actual game.
Your sheet (i359.xls, i359.xlsx, i359.ods, ...) with content specified above, together with a short documentation (i359.txt, i359.pdf, ...) also describing the name and version number of the spreadsheet application, should be submitted in a compressed file (i359.zip).
Deadline expired on December 10, 2014.
9 students sent a solution. 10 points: Kovács 246 Benedek, Mócsy Miklós. 9 points: Dombai Tamás, Fényes Balázs, Gercsó Márk, Radnai Bálint. 8 points: 1 student. 5 points: 2 students.