WPS table making contest scoring system

We know that in many competitions the performance of the contestants is the spot rating, and almost the performance of the players at the same time the final score and position also showed that the audience saw a strong sense of the scene and irritation. In fact, we in peacetime units held in all kinds of competitions can achieve this effect, is through the WPS form a simple scoring system, below to a 10 judges, 7 classes to participate in the Guangbocao competition as an example, introduce the scoring system of the production process.

1. Make a sheet, as shown in Figure 1, and name it "XX Middle School broadcast competition scoring system".

Figure 1

2. Calculate the highest and lowest points: in B13 and B14 cells, enter "{=max (B3:B12)}" and "{=min (B3:B12)}" respectively. Automatically populate other cells: Place the mouse over the "ten" word (that is, the fill handle) in the lower-right corner of the B13 and B14 cells, and hold down the left mouse button to the H13 and H14 cells, and the more classes, the more obvious the advantages of this automatic filling method.

3. Calculate the final score: in B15 cell enter "{=sum (B3:B12-B13-B14/8)}", the role of the formula is: according to the general rules of the game, remove a maximum score, remove a minimum, the remaining points of the average score as the final score of the player. To make the results display in a consistent and accurate format, the final score is one to two decimal places more than the score given by each of the judges. For example, you can ask the judges to unify their points into one decimal, and the "final score" retains two decimal places. Then automatically populate the C15 to H15 cells according to the method in 2.

4. Calculate the position: in B16 cell, enter "{=rank (B15, $B $15:h$15)}". The function of the formula is to calculate the order of the B15 cell in B15 to H15, that is, the rank of the class (1). Note: The range of cells entered in the B15 must be an absolute reference or an error will occur. Auto fill of other cells ibid.

5. Set cell data validation: In order for the operator to enter the process without large errors, we can set the data validation of the cell (Data menu-effectiveness), such as the set as shown in Figure 2, if out of range will issue an error warning.

Figure 2

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

The above is the scoring system of the production process, which mainly used the WPS table Max, MIN, SUM, rank and other functions, the production of simple but powerful, the effect is obvious, hope to be helpful to those in need.

Form making