Spreadsheet: 862004d1709812151-creating-a-scoring-system-considering-10-values-above-and-below-book1-3-
Sheet: Sheet1

 |  | Number | Grade |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed??
 |  | 0536 | B0 |  |  |  |  |  |  |  |  |  | Grade | Value
 |  | 0542 | B0 |  |  |  |  |  |  |  |  |  | B0 | 0 |  |  |  | 4.8
 |  | 0553 | B1 |  |  |  |  |  |  |  |  |  | B1 | 0.1 |  |  |  | 5.4
 |  | 0563 | B5 |  |  |  |  |  |  |  |  |  | B2 | 0.1 |  |  |  | 4.5
 |  | 0565 | B5 |  |  |  |  |  |  |  |  |  | B3 | 0.3 |  |  |  | 4.6
 |  | 0569 | B0 |  |  |  |  |  |  |  |  |  | B4 | 0.7 |  |  |  | 5.699999999999999
 |  | 0574 | B5 |  |  |  |  |  |  |  |  |  | B5 | 1 |  |  |  | 4.699999999999999
 |  | 0574 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.699999999999999
 |  | 0576 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.799999999999999
 |  | 0584 | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.799999999999999
 |  | 0585 | B4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.099999999999999
 |  | 0588 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.799999999999999
 |  | 0605 | B4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.199999999999998
 |  | 0606 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.899999999999999
 |  | 0608 | B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.799999999999999
 |  | 0622 | B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.8
 |  | 0641 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.9
 |  | 0644 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.899999999999999
 |  | 0665 | B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.099999999999999
 |  | 0667 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.199999999999999
 |  | 0673 | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.2
 |  | 0678 | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5
 |  | 0678 | B1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.4
 |  | 0687 | B1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.7
 |  | 0688 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.8
 |  | 0709 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.7
 |  | 0710 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.6
 |  | 0711 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.6
 |  | 0724 | B3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.300000000000001
 |  | 0726 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.5
 |  | 0734 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.5
 |  | 0735 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.6
 |  | 0736 | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.3
 |  | 0740 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.2
 |  | 0741 | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.1
 |  | 0759 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.1
 |  | 0760 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.1
 |  | 0763 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.1
 |  | 0769 | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.1
 |  | 0778 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.8
 |  | 0781 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.8
 |  | 0782 | B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.7
 |  | 0782 | B4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.1
 |  | 0783 | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.8
 |  | 0788 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.8
 |  | 0794 | B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.8
 |  | 0802 | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.8