Problem I. 297. (May 2012)
I. 297. In this task you are going to expand the table in Problem I. 281. of the 2011 December issue of our Journal, in such a way that by pressing a button it should be able to create diagrams with the content and format presented there for each class, further, it should fill the column of every student with a color corresponding to their talent levels.
You should use your previous solution or one of the files of the uploaded sample solutions. Delete the diagram created for the first class and make a command button to the right of the talent level part of the table. The macro or program associated with this command button should create the diagrams one below another corresponding to the classes and similar to the original ones in Problem I. 281.
Talent levels should be encoded by colors red, pale orange, yellow, light green, dark green, grey, light blue and dark blue, respectively, ranging from the 0th level to Level 7.
The spreadsheet (i297.xlsm, i297.xls, i297.ods, ...) containing your solution together with a brief description (i297.txt, i297.pdf, ...) should be submitted in a compressed file i297.zip.
Deadline expired on 11 June 2012.
Sorry, the solution is available only in Hungarian. Google translation
Mintamegoldásként Kovács Balázs Marcell 9. osztályos budapesti versenyző Excelben készült megoldását közöljük (i297.xls).