Question

ETM-3030 DIVING SCORES EXCEL 10 POINTS In this assignment you will use excel to process the scores of a diving competition. In the next assignment you will solve the same problem using C#. The diving works as follows: A set of judges score each dive from o0 to 10 in stes of 0.5. The total score for a dive is obtained by discarding the lowest and highest of the judges' scores, adding the remaining scores, and multiplying the result by the degree of difficulty for that dive. A diver's overall score is computed by adding together his/her total scores for each dive. The first line of the file contains three integers: the number of divers in the competition, the number of rounds in the competition and the number of judges the competition. For initialization purposes the diver's names are giving one per line. Next in the file are the judges' scores for each round. Each line contains the name of the diver, the degree of difficulty followed by the judges' scores for that dive. The following is an example a data file. rounds and five judges. The competition consists of three divers, three Example Data File Goodwin Kronner Swatzel Goodwin 2.3.7.5 6.0 8.5 7.8 6.5 Kronner 2.0 5.0 7.5 8.0 7.0 8.5 Swatzel 3.2 6.0 8.0 7.8 5.8 9. Kronner 2.8 5.8 7.5 8.8 7.8 8.5 Swatzel 3.2 6.8 8.0 7.8 5.8 9.0 Goodwiri 4.5 7.5 6.0 8.5 7.8 6.5 Goodwin 2.3 7.5 6.8 8.5 7.0 6.5 Kronner 4.7 5.0 7.5 8.0 7.e 8.5 Swatzel 3.2 6.0 8.0 7.0 5.0 9.0 Diver Overall Swatzel 201.6 Kronner 195.75 Goodwin 191.1 Assignment Copy the example data file above into Excel. Using Excel compute the results. Sort the sults from highest to lowest score. Your results are given to the right.

Answer 1

Gaven -nat ComPeon using Systemj sing sysen Cellectons. Genes*c; sttm Thscadass nome space Console ADpli cohon SiIStcm. o seam Reader mfile: SIbica Une

C2) Il Console. ete (tine) Sprt ') daiuev uomes neus Stieg nd) ens to ctsc (count >0 count ndives ctse

tempnefoat judge) ede i (oat , min os3nt 32 -2, i tokens length,it)

Sum < m Som - rin - dex) t : Sum屮diff . Coun t t tノ Il Suspend the Stseen Console Readiae)' Qood doi n 2.37.560 8.5406-S

čo n neb. 2-3 PS 6.0 8-S จ. o 6.5 2-o S-o 7,5 R-o ㅋ.of. S Suoatze Goatwin 44 9 ksonnes 13s Soat2et 20.G