Problem I. 173. (December 2007)
I. 173. There were 14 questions in a pool, each with a possible answer of ``1'', ``2'' or ``X''. We would like to rank the competitors who played this game. First we assign a certain number to each question: a question is worth m points if there were m people not answering correctly that question. A competitor answering correctly a question gets the number of points of that question. The winner(s) is/are who get(s) the maximal number of points altogether.
Prepare a spreadsheet application to evaluate the pool. Beginning with the first row, each line contains the name of the contestant, then his or her 14 answers in the first 15 columns of the ``Answers'' sheet. There are at most 500 rows. If someone gave no answer to a question, that cell would remain empty. For computations and for the output, you can use the ``Computations'' sheet: cell A1 should contain the maximal number of points achieved, while cell B1 the name(s) of the winner(s).
You should submit the spreadsheet (i173.xls, i173.ods, ...) and a short documentation (i173.txt, i173.pdf, ...) containing a description of your solution, further, the name and version number of your spreadsheet application.
Deadline expired on January 15, 2008.
Sorry, the solution is available only in Hungarian. Google translation
A feladatra sok jó megoldás érkezett. Ezek közül Földes Imre (Szolnok, Verseghy Ferenc Gimn., 11. osztály) munkáját közöljük.
10 students sent a solution. 10 points: Földes Imre, Molnár Gábor, Pap 987 Dávid, Szoldatics András. 9 points: Adrián Patrik, Véges Márton. 8 points: 1 student. 7 points: 1 student. 6 points: 1 student. 4 points: 1 student.