KöMaL - Középiskolai Matematikai és Fizikai Lapok
Sign In
Sign Up
 Magyar
Information
Contest
Journal
Articles

 

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.

(10 pont)

Deadline expired on 15 January 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.

foldes.zip


Statistics:

>
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.

Our web pages are supported by:   Ericsson   Cognex   Emberi Erőforrás Támogatáskezelő   Emberi Erőforrások Minisztériuma   Nemzeti Tehetség Program    
MTA Energiatudományi Kutatóközpont   MTA Wigner Fizikai Kutatóközpont     Nemzeti
Kulturális Alap   ELTE   Morgan Stanley