Spreadsheet: 89549d1289332434-using-address-function-to-define-a-range-bwi-template
Sheet: Entry

 |  |  |  |  |  |  |  |  |  |  |  | 3350 | 6 |  | 20 | 635
Date |  |  |  |  | Closing size | 150 |  |  |  |  |  | 2800 | 7 |  | 25 | 500
 |  |  |  |  |  |  |  |  |  |  |  | 2360 | 8 |  | 38 | 400
Project No. |  |  |  |  | Test Feed Wt | 1409 |  |  |  |  |  | 1700 | 10 |  | 45 | 325
 |  |  |  |  |  |  |  |  |  |  |  | 1180 | 14 |  | 53 | 270
Sample |  |  |  |  | Undersize in ball mill feed | 13.77813667104068 |  |  |  |  |  | 850 | 20 |  | 75 | 200
 |  |  |  |  |  |  |  |  |  |  |  | 600 | 28 |  | 106 | 150
Client identified |  |  |  |  | Ideal product Wt | 402.5714285714286 |  |  |  |  |  | 425 | 35 |  | 150 | 100
 |  |  |  |  |  |  |  |  |  |  |  | 300 | 48 |  | 212 | 65
Test operator |  |  |  |  |  |  |  |  |  |  |  | 212 | 65 |  | 300 | 48
 |  |  |  |  |  |  |  |  |  |  |  | 150 | 100 |  | 425 | 35
 |  |  |  |  |  |  |  |  |  |  |  | 106 | 150 |  | 600 | 28
Feed |  | Product |  |  | [NAME] | Number | Weight |  |  |  |  | 75 | 200 |  | 850 | 20
µm | Weight | µm | Weight |  | (inches) | of Balls | (grams) |  |  |  |  | 53 | 270 |  | 1180 | 14
3350 | 0 | 150 |  |  | 1.5 | 43 | 8816 |  |  |  |  | 45 | 325 |  | 1700 | 10
2800 | 117 | 106 |  |  | 1.25 | 67 | 7205 |  |  |  |  | 38 | 400 |  | 2360 | 8
2360 | 117 | 75 |  |  | 1 | 10 | 670 |  |  |  |  | 25 | 500 |  | 2800 | 7
1700 | 173.6 | 53 |  |  | 0.75 | 71 | 1998 |  |  |  |  | 20 | 635 |  | 3350 | 6
1180 | 124.6 | 45 |  |  | 0.5 | 94 | 1435
850 | 99 | 38 |  |  | Total | 285 | 20124 |  |  |  |  | 28 | 35 | 48 | 65 | 100 | 150 | 200
600 | 66.2 | 25 |  |  |  |  |  |  |  |  |  | 600 | 425 | 300 | 212 | 150 | 106 | 75
425 | 52 | -25 |  |  |  |  |  |  |  |  |  | 425 | 300 | 212 | 150 | 106 | 75 | 53
300 | 38.1 | Total | 0 |  |  |  |  |  |  |  |  | 300 | 212 | 150 | 106 | 75 | 53 | 45
212 | 28 |  |  |  |  |  |  |  |  |  |  | 212 | 150 | 106 | 75 | 53 | 45 | 38
150 | 19.8 |  | At least seven cycles |  | YES |  |  |  |  |  |  | 150 | 106 | 75 | 53 | 45 | 38 | 25
-150 | 18.9 |  |  |  |  |  |  |  |  |  |  | 106 | 75 | 53 | 45 | 38 | 25 | 20
 | 13.2 | Reversal in U'size product per rev |  |  | YES |  |  |  |  |  |  | 75 | 53 | 45 | 38 | 25 | 20
 | 123.3
 |  | Less than 3% difference |  |  | YES
Total | 990.7
Stage No. | No. of | O'Size in | U'Size in | [NAME] for | U'Size in | Net | Net Per
 | Revolutions | Product (g) | Product (g) | Next Cycle | Feed | Prodouct | Rev.
1 | 100 | 963 | 446 |  | 194.1339456949632 | 251.8660543050368 | 2.518660543050368
2 | 256 | 943 | 466 | 135.4374411271211 | 61.45048955284145 | 404.5495104471586 | 1.580271525184213
3 | 215 | 982 | 427 | 214.1184640056939 | 64.20611688704959 | 362.7938831129504 | 1.687413409827676
4 | 204 | 998 | 411 | 203.7075105508309 | 58.83264358534372 | 352.1673564146563 | 1.72631057066008
5 | 200 | 1000 | 409 | 200.3945829522291 | 56.62814171797721 | 352.3718582820228 | 1.761859291410114
6 | 197 | 1005 | 404 | 196.5076616928778 | 56.35257898455639 | 347.6474210154436 | 1.764707720890577
7 | 197 | 1010 | 399 | 196.5808571661679 | 55.66367215100436 | 343.3363278489957 | 1.742823999233481
8 |  |  |  | 199.4445012272348 | 54.97476531745232
9
10
11
12
399 | 1.742823999233481
404 | 1.764707720890577
409 | 1.761859291410114
404 | 1.756463670511391