Problem I. 141. (October 2006)
I. 141. Create an Excel sheet to help compare different tariffs of a mobile phone provider. The user should be able to set some parameter values on the first worksheet about the type of calls:
- most frequent hours of calls (from -- to)
- percentage of total calls within this time interval
- percentage of total calls within the given network
- duration of calls: at least and at most how many seconds.
Three tariffs should be compared with the following parameters:
- billing unit: one minute, half minute or seconds
- peak hours (from which hour to which hour)
- unit fee for calling within the network in peak hours and in off peak hours
- unit fee for calling outside the network in peak hours and in off peak hours.
To perform computations, you should generate a second worksheet with 1000 random calls using the parameters on the first worksheet. Determine the total cost of calls in each of the three tariffs and print the cheapest one on the first worksheet.
An example of a tariff: billing unit is half minute, peak hours are from 10 to 16, fees within the network in peak hours is 20 HUF, 30 HUF outside the network for half minute. 11 HUF in off peak hours within and 19 HUF outside the network.
An example of types of calls: most frequent hours from 11 to 18 and 80% of the calls take place in this interval. Duration of calls is between 18 and 175 second. 45% of the calls are within the given network.
The Excel sheet should be submitted with arbitrary parameters. We will also evaluate the user-friendliness of your sheet: the way one can enter parameters, and how cells are formatted and protected.
Deadline expired on November 15, 2006.
Sorry, the solution is available only in Hungarian. Google translation
Fehér András 11. évf.(Szekszárd, Garay János Gimnázium)
26 students sent a solution. 10 points: Balambér Dávid, Biró János, Csima Géza, Danka Miklós András, Fehér András, Gombos Gergely, Györök Péter, Hunyady Márton, Kiss Dániel Miklós, Pétercsák Richárd, Polgárfi Bálint, Vincze János. 9 points: Czigler András, Gilián Zoltán, Kovács 129 Péter, Nádudvari Péter, Ócsvári Ádám, Slemmer András, Szoldatics András, Véges Márton. 8 points: 1 student. 7 points: 1 student. 5 points: 1 student. 2 points: 1 student. 1 point: 2 students.