I. 302. In recent years poker has become a very popular game. Now you are going to use a spreadsheet application to randomly generate a set of cards to be dealt to each player, moreover, your program will be required to name these poker hands as well.
Cards are to be generated in cells A2:A6 and the standard French deck of cards should be used. So, for example, the ace of hearts should be displayed as in the appropriate cell in red. The ranking of this hand (if it has a name) should be written in cell A1. Regarding the terminology, you may find the page http://hu.wikipedia.org/wiki/Kártyakombinációk_(póker) hands useful.
Your solution can use an arbitrary number of auxiliary cells, but your own functions and any macros should not be used.
The spreadsheet containing your solution (i302.xls, i302.ods, ...) together with the name and version number of the application and a short description of your work (i302.txt, i302.pdf, ...) should be submitted in a compressed file i302.zip.
Deadline expired on 12 November 2012.