Order KöMaL! Competitions Portal

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.

(10 points)

Google Translation (Sorry, the solution is published in Hungarian only.)

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.

Statistics on problem I. 173.
 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.

• Problems in Information Technology of KöMaL, December 2007

•  Our web pages are supported by: ELTE