Spreadsheet: the lowest score is the highest, the equal difference score, the formula? For example: the highest score is 50 points, and the equal difference is 0. When the lowest decimal is 3, 50 points will be obtained; when the second decimal is 5, 49 points will be obtained; when the third decimal is 7, 49 points will be obtained, and so on.

B1 = 50 - (rank (A1, a: A, 2) - 1) * 0.5, pull-down filling

RELATED INFORMATIONS

1. How to calculate the rapid interpolation method The cost of 1 million is 78 million, and the cost of 30 million is 78 million. How much is the cost of 2006 million?
2. Fineness model 2.8-3.1 sand rate 34-38 that fineness model 2.9 use interpolation method to calculate sand rate? The formula is also written out!
3. In the rent formula r = RV * I (1 + I) ^ n / (1 + I) ^ (n-1), RV (principal) = 10000, n = 12 months, r = 1200
4. How to calculate by interpolation The depth of K0 + 260 is 0.514, the depth of K0 + 280 is 0.472, and the depth of K0 + 262.276 is calculated by interpolation
5. How to use interpolation method to calculate interest rate Given the coefficient of present value (or final value) of annuity and the number of periods n, it is a little unclear when calculating the interest rate according to the interpolation formula Example: a company borrows 20000 yuan at the beginning of the first year, and repays 4000 yuan at the end of each year, which is paid off for nine consecutive years? （P/A,i,9)=P/A=20000/4000=5 When I = 12%, (P / A, 12%, 9) = 5.3282; I = 14%, (P / A, 14%, 9) = 4.9464 So I = 12% + (5.3282-5) / 5.3282-4.9464) * (14% - 12%) = 13.72% The formula I = I1 + (b-b1) / (b2-b1) * (i2-i1), why not I = 12% + (5-5.3282) / 4.9464-5.3282) * (12% - 14%) How to define I1 and I2 in the formula? Which of the 12% and 14% in the above example is I1 and which is I2?
6. The known number 40 corresponds to 3.0 The number 42.1 corresponds to X The number 45 corresponds to 1.5 How much is x by interpolation, My friend on the first floor, the formula you gave is wrong, 2.25 - (42.5-42.1) × 5 = 2.05.
7. 1 / x + 1-x + 3 / x ^ 2-1 divided by x ^ 2 + 4x + 3 / x ^ 2-2x + 1, where x = - 1 / 2
8. 8 + (- 5) times (- 8) times (- 3 / 4) Multiplication of rational numbers in the first year of junior high school
9. How many centimeters is three fifths of a meter
10. Simple calculation of 72 * 28 + 72 * 72
11. The proof of the arithmetic of logarithm function in the first grade of senior high school
12. Basic formula of logarithmic function It is known that log10 / 2 = A and log10 / 3 = B. try a and B to denote log12 / 5
13. Decimal multiplication and division have the same meaning as integer multiplication and division, right
14. Similarities between integer and decimal multiplication and division
15. Sorting out the knowledge points of scores
16. What practical problems can be explained by the knowledge and scores
17. Knowledge of primary school marks
18. Is the meaning of fractional multiplication and division the same as that of integer multiplication and division? Are they different?
19. The denominator of A-1 - (a + 1) cm is a + 1? And X / X & # 178; - 25-5 / X & # 178; + 10x + 25, (B / A & # 178; - AB + A / B & # 178; - AB) / A-B / ab
20. 1、[x÷（2－x）]－[（4－x²）÷（x²－4x＋4)] 2、[b÷（a²－ab）＋a÷（b²－ab）]÷[（a－b）÷（ab）]