Spreadsheet: 849056d1699619272-roundup-max-c2-c10-min-c2-c10-14-gives-error-too-few-arguments-allocation-of-points-data-frequency-distribution
Sheet: Sheet1

 | ACCOUNT | SELECTION POINTS | TOP % RANK TOTAL | TOTAL PURSE FOR ACCOUNT | TOP % RANK | ACCOUNTS | INCENTIVE | AVERAGE EARN | % Plus ave | Total Purse | Accountant name | Accountant% | Manager | Manager % | Accountant plus manager total | PREDICT OUT | account name | account points | arrears | AVE EARN RANK | accountant rank | Manager [NAME] | PREDIC STAKE RANK | Last account rank | SELECTION rank | Company % | Company % Overal | Category B | Cat B % | CATEGORY O | % Cat Class | Cat B Plus Cat O Total Percentage | ACCOUNT | Predicted Overall output
1 | Z1 | 255 | 113883.75 | 214875 | 0.53 | 15 | 2 | 14325 | 128208.75 | 235646.25 | A1 | 15 | B1 | 5 | 0.373 | 87896.05125 | C1 | 105 | 6 | 2 | 2 | 3 | 2 | 5 | 2 | X1 | 0.16 | Cat 1 | 38.5 | Cat Class 1 | 21.4 | 59.9 | Z1 | 100
2 | [NAME] | 225 | 102959.14 | 219062 | 0.47 | 15 | 3 | 14604.13333333333 | 117563.2733333333 | 190583.94 | A2 | 3 | B2 | 3 | 0.485 | 92433.2109 | C2 | 251 | 5 | 1 | 7 | 1 | 1 | 10 | 4 | X2 | 0.27 | Cat 2 | 30.8 | Cat Class 2 | 40 | 70.8 | [NAME] | 60
3 | Z3 | 253 | 163867.68 | 455188 | 0.36 | 47 | 6 | 9684.851063829787 | 173552.5310638298 | 249417.1977304965 | A3 | 2.5 | B3 | 58 | 0.232 | 57864.78987347519 | [NAME] | 300 | 2 | 5 | 5 | 7 | 3 | 10 | 3 | X3 | 0.2 | Cat 3 | 28.6 | Cat Class 3 | 0 | 28.6 | Z3 | 42.9
4 | Z4 | 317 | 175725 | 399375 | 0.44 | 34 | 4 | 11746.32352941176 | 187471.3235294118 | 287315.0735294118 | A4 | 11 | B4 | 35 | 0.267 | 76713.12463235296 | C4 | 450 | 1 | 4 | 4 | 4 | 1 | 10 | 1 | X4 | 0.01 | Cat 4 | 31.7 | Cat Class 4 | 9.1 | 40.8 | Z4 | 50
5 | [NAME] | 60 | 86347.5 | 148875 | 0.58 | 12 | 1 | 12406.25 | 98753.75 | 247628.75 | A5 | 6 | B5 | 24 | 0.25 | 61907.1875 | C5 | 335 | 5 | 3 | 3 | 6 | 1 | 6 | 7 | X5 | 0.1 | Cat 5 | 22.2 | Cat Class 5 | 11.1 | 33.3 | [NAME] | 75
6 | Z6 | 55 | 9575 | 95750 | 0.1 | 20 | 1 | 4787.5 | 14362.5 | 110112.5 | A6 | 8 | B6 | 75 | 0.164 | 18058.45 | C6 | 125 | 9 | 8 | 9 | 9 | 4 | 10 | 8 | X6 | 0.09 | Cat 6 | 14.3 | Cat Class 6 | 33.3 | 47.59999999999999 | Z6 | 66.7
7 | Z7 | 100 | 24082.5 | 63375 | 0.38 | 8 | 1 | 7921.875 | 32004.375 | 95379.375 | A7 | 45 | B7 | 54 | 0.451 | 43016.098125 | C7 | 99 | 2 | 7 | 1 | 2 | 1 | 8 | 6 | X7 | 0.04 | Cat 7 | 24.5 | Cat Class 7 | 33.3 | 57.8 | Z7 | 33.3
8 | Z8 | 180 | 32250 | 80625 | 0.4 | 10 | 1 | 8062.5 | 40312.5 | 120937.5 | A8 | 6.5 | B8 | 54 | 0.184 | 22252.5 | C8 | 65 | 1 | 6 | 8 | 8 | 2 | 10 | 5 | X8 | 0.06 | Cat 8 | 20 | Cat Class 8 | 13.8 | 33.8 | Z8 | 40
9 | Z9 | 50 | 14052.5 | 100375 | 0.14 | 28 | 1 | 3584.821428571428 | 17637.32142857143 | 118012.3214285714 | A9 | 5.4 | B9 | 63 | 0.253 | 29857.11732142857 | C9 | 558 | 2 | 9 | 6 | 5 | 1 | 8 | 9 | X9 | 0.07 | Cat 9 | 10 | Cat Class 9 | 0 | 10 | Z9 | 25
 | MAXIMUM
 | MINIMUM
 | RANGE
 |  | CLASS LIMIT | CLASS BOUNDARIES | FREQUENCY | TOP % RANK TOTAL |  | COUNT | TOTAL PURSE FOR ACCOUNT | COUNT | TOP % RANK |  | COUNT | ACCOUNTS |  | COUNT | INCENTIVE |  | COUNT | AVERAGE EARN |  | COUNT | % Plus ave |  | COUNT | Total Purse |  | COUNT |  |  | COUNT | Accountant% |  | COUNT | Manager |  | COUNT | Accountant plus manager total |  | COUNT | PREDICT OUT |  | COUNT | account points |  | COUNT | Manager [NAME] |  | COUNT | AVE EARN RANK |  | COUNT | accountant rank |  | COUNT | PREDICT STAKE RANK |  | COUNT | Last account rank |  | COUNT | SELECTION rank |  | COUNT | Company % Overal |  | COUNT | Cat B % |  | COUNT | % Cat Class |  | COUNT | Cat B Plus Cat O Total Percentage |  | COUNT | Predicted Overall output |  | COUNT
 | CLASS 1 |  | 71
 | CLASS 2 | 70 | 91
 | CLASS 3 | 90 | 111
 | CLASS 4 | 110 | 131
 | CLASS 5 | 130 | 151
 | CLASS 6 | 150 | 171
 | CLASS 7 | 170 | 191
 | CLASS 8 | 190 | 211
 | CLASS 9 | 210 | 231
 | CLASS 10 | 230 | 251
 | CLASS 11 | 250 | 271
 | CLASS 12 | 270 | 291
 | CLASS 13 | 290 | 311
 | CLASS 14 | 310 | 331
 | CLASS 15
 | CLASS 16
 | CLASS 17
 | CLASS 18
 | CLASS 19
 | CLASS 20
 | CLASS [NAME] | =ROUNDUP((MAX(C2:C10)-MIN(C2:C10))/14
 | CUMULATIVE FREQUENCY |  |  |  | CUMULATIVE FREQUENCY
 | RANKING FOR EACH CLASS FACTOR
 | ACCOUNTTANT | SELECTION POINTS | TOP % RANK TOTAL | TOTAL PURSE FOR ACCOUNT | TOP % RANK | ACCOUNTS | INCENTIVE | AVERAGE EARN | % Plus ave | Total Purse | Accountant name | Accoutant% | Manager | Manager % | Accountant plus manager total | PREDICT OUT | account name | account points | arrears | AVE EARN RANK | accountant rank | [NAME] | PREDIC STAKE RANK | Last account rank | SELECTION rank | Company % | Company % Overal | Category B | Cat B % | CATEGORY O | % Cat Class | Cat B Plus Cat O Total Percentage | ACCOUNT | Predicted Overall output | ACCOUNTTANT | SELECTION POINTS | TOP % RANK TOTAL | TOTAL PURSE FOR ACCOUNT | TOP % RANK | ACCOUNTS | INCENTIVE | AVERAGE EARN | % Plus ave | Total Purse | Accountant name | Accoutant% | Manager | Manager % | Accountant plus manager total | PREDICT OUT | account name | account points | arrears | AVE EARN RANK | accountant rank | [NAME] | PREDIC STAKE RANK | Last account rank | SELECTION rank | Company % | Company % Overal | Category B | Cat B % | CATEGORY O | % Cat Class | Cat B Plus Cat O Total Percentage | ACCOUNT | Predicted Overall output | total
 | A1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1
 | A2 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2
 | A3 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A3
 | A4 |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A4
 | A5 |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A5
 | A6 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A6
 | A7 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A7
 | A8 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A8
 | A9 |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A9
 | A10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A10
 | A11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A11
 | A12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A12
 | A13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A13
 | A14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A14
 | A15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A15
 | A16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A16
 | A17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A17
 | A18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A18
 | A19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A19
 | A20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A20
 | A21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A21
 | A22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A22
 | A23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A23
 | A24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A24
 |  | ALLOCATION POINTS FOR FREQUENCY DISTRIBUTION
 | RANKING BY POINTS | SELECTION POINTS | TOP % RANK TOTAL | TOTAL PURSE FOR ACCOUNT | TOP % RANK | ACCOUNTS | INCENTIVE | AVERAGE EARN | % Plus ave | Total Purse | Accountant name | Accoutant% | Manager | Manager % | Accountant plus manager total | PREDICT OUT | account name | account points | arrears | AVE EARN RANK | accountant rank | [NAME] | PREDIC STAKE RANK | Last account rank | SELECTION rank | Company % | Company % Overal | Category B | Cat B % | CATEGORY O | % Cat Class | Cat B Plus Cat O Total Percentage | ACCOUNT | Predicted Overall output
 | 1 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | 2 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96 | 96
 | 3 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92 | 92
 | 4 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88
 | 5 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84 | 84
 | 6 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80
 | 7 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76
 | 8 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72 | 72
 | 9 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 68
 | 10 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
 | 11 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60
 | 12 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56
 | 13 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52
 | 14 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48
 | 15 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44
 | 16 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 | 17 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36
 | 18 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32
 | 19 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28
 | 20 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24
 | 21 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | 22 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
 | 23 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | 24 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8