KöMaL - Középiskolai Matematikai és Fizikai Lapok
Sign In
Sign Up


Problem I. 155. (March 2007)

I. 155. Zeno decides to make use of a spreadsheet, since he tends to forget about birthdays. The sheet issues a reminder one week before the event. Beginning with the second line, Zeno has already entered the names and birthdays into the first two columns of the sheet. Now he asks for our help to finish the sheet.

He would like to have the actual date in cell A1. The second cell of the same row should contain the number of days to the nearest birthday and the name(s) of the person/people having birthday then, provided that this event occurs within a week. If there are more people, their names should be separated by commas. If there is no birthday in the near future, that cell should be left empty.

The sheet (i155.xls, ...) is to be submitted.

(10 pont)

Deadline expired on 16 April 2007.

Sorry, the solution is available only in Hungarian. Google translation

A feladat mintamegoldása: i155minta.xls


19 students sent a solution.
10 points:Balambér Dávid, Ridinger Tamás.
9 points:Gál Tibor, Gulyás 990 Péter, Nádudvari Péter, Véges Márton, Vincze János.
8 points:3 students.
7 points:3 students.
6 points:2 students.
2 points:2 students.
1 point:1 student.
0 point: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