Problem I. 260. (February 2011)
I. 260. In this task you should reproduce a nowadays typical Hungarian money transfer form (``Készpénzutalási megbízás'') by using a spreadsheet application.
Data of the payer to be written on the form (``Megbízó (Befizető)'') should have white background, other parts of the cheque should have yellow background. The receipt (``Feladóvevény'' on the left) is separated from the rest by a white column. Auxiliary information and the frames are in red. The payer should be able to write in black.
If one writes data in the white region under the label Megbízó (Befizető) neve, címe (``Name and address of the payer'') on the right, these data should automatically be copied into the corresponding yellow cells of the receipt on the left.
The actual sum to be transferred is entered using digits in the cell Összeg of the receipt. This number should automatically appear under the other label Összeg on the right.
Upon entering a valid number in the left cell Összeg, your sheet should automatically fill in the fields Összeg betűvel kiírva, that is, the sum should be written out in words as well, according to the grammatical spelling. To achieve this, you may use macros and auxiliary cells, but these should be clearly visible outside the cheque's region.
You can obtain at most 5 points for writing out the numbers in words. If this feature is working, another 5 points can be awarded for accurate graphics.
The spreadsheet (i260.xls, i260.ods, ...) together with a short documentation (i260.txt, i260.pdf, ...) also describing the name and version number of the spreadsheet application should be submitted.
Deadline expired on March 10, 2011.
Sorry, the solution is available only in Hungarian. Google translation
Mintamegoldásként Gema Barnabás 10. osztályos (Veszprém, Lovassy László Gimnázium) tanuló munkáját közöljük: i260.xls
5 students sent a solution. 10 points: Gema Barnabás. 9 points: Kalló Kristóf. 8 points: 1 student. 7 points: 2 students.