Sunac salary grade table

Tips for using Sunac salary grade table template​​​How to prepare Sunac salary grade table?
​​ 1. Decide whether positions are divided into series and salary levels
Regardless of series: It is necessary to connect the job evaluation results of different series; find one position in each of the two series, find the job evaluation results of the two positions are the same or similar, and then unify the positions in different series sort
​​Series: Sorted by job evaluation results
​ ​ 2. Divide salary levels
Plot the job evaluation results of each position on a number axis, and divide positions with similar job evaluation points into a salary grade.

General tips for Sunac salary grade table form

​ ​ 1:SUM function (mathematics)
In daily work and study, SUM is an extremely widely used function and can be learned as an entry-level function. Therefore, overall, the SUM function is not difficult but has a wide range of applications. But don’t underestimate SUM just because it is simple. It also has some little-known tricks! 1. Cumulative sum as shown below, which is the sales performance of a certain company every day and requires the calculation of the daily cumulative amount.
For example, enter the formula in cell D2: =SUM(C$2:C2), press the Enter key to complete and fill downwards.
Note: At this time, C$2 must lock the row mark, so that a reference area from the second row to the downward row will be generated during the pull-down process.
​ ​ 2:Sum with qualified cells
The sum of merged cells has always been a troublesome problem for novices.
Select the cell range D2:D13, then enter the formula in the formula editing bar: =SUM(C2:C13)-SUM(D3:D14), and then press Finish. Note: Be sure to pay attention to the range of the second SUM function. Misplaced, otherwise an error will be reported.