Problem I. 166. (October 2007)

I. 166. By using a spreadsheet application, create a random but realistic map in a three-dimensional perspective view similar to the picture on the front/back cover of our Journal. The surface contour is generated from a diagram consisting of integers between 0 and 10 (representing altitudes) in a block of 40×40 cells of a worksheet. A button should appear below the data on this datasheet which, when pressed, regenerates all the data (that is the whole terrain). The actual view of the terrain should be visible on a diagram below the data and the button.

Your worksheet (i166.xls, i166.ods, ...) together with a short documentation of the solution (i166.txt, i166.pdf, ...) should be submitted containing also the name of the spreadsheet application and its version number.

(10 pont)

Deadline expired on November 15, 2007.

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

Megoldás:

Sokféle megoldás és domborzati kép született. Néhány eltérő módszert láthatunk Adrián Patrik debreceni, Fábián András szegedi és Póta Kristóf egri versenyző megoldásaiban: adrianpatrik.xls , fabianandras.xls , potakristof.xls .

Statistics:

12 students sent a solution.
10 points:	Adrián Patrik, Fábián András, Horváth 135 Loránd, Kaposvári Tamás, Pap 987 Dávid, Péter Tamás, Póta Kristóf, Véges Márton.
8 points:	1 student.
7 points:	2 students.
5 points:	1 student.

Problems in Information Technology of KöMaL, October 2007