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

 |  |  |  |  |  |  |  |  |  | Undersize |  | U'Size | [NAME]
 |  |  |  |  |  |  | Stage |  | New | In | To Be | In |  | Per [NAME]
 |  |  |  |  |  |  | No. | [NAME] | Feed | Feed | Ground | Product | Total | Rev
Standard Bond Ball Mill Grindability Test |  |  |  |  |  |  |  |  | (grams) | (grams) | (grams) | (grams) | (grams) | (grams)
 |  |  |  |  |  |  | 1 | 100 | 963 | 446 |  | 194.1339456949632 | 251.8660543050368 | 2.518660543050368 |  |  |  |  | 1
Project No | 0 |  |  |  |  |  | 2 | 256 | 943 | 466 | 135.4374411271211 | 61.45048955284145 | 404.5495104471586 | 1.580271525184213 |  |  |  |  | 2
 |  |  |  |  |  |  | 3 | 215 | 982 | 427 | 214.1184640056939 | 64.20611688704959 | 362.7938831129504 | 1.687413409827676 |  |  |  |  | 2
Sample | 0 |  |  |  |  |  | 4 | 204 | 998 | 411 | 203.7075105508309 | 58.83264358534372 | 352.1673564146563 | 1.72631057066008 |  |  |  |  | 4
 |  |  |  |  |  |  | 5 | 200 | 1000 | 409 | 200.3945829522291 | 56.62814171797721 | 352.3718582820228 | 1.761859291410114 |  |  |  |  | -5 |  | 4
Purpose | To determine the ball mill grindability of the sample in terms |  |  |  |  |  | 6 | 197 | 1005 | 404 | 196.5076616928778 | 56.35257898455639 | 347.6474210154436 | 1.764707720890577
 | of a Bond work index number. |  |  |  |  |  | 7 | 197 | 1010 | 399 | 196.5808571661679 | 55.66367215100436 | 343.3363278489957 | 1.742823999233481
 |  |  |  |  |  |  |  |  |  |  | 199.4445012272348 | 54.97476531745232
Proceedure | The equipment and procedure duplicate the Bond method for
 | determining ball mill work indices.
Test condition | Closing size: |  |  |  |  | 150
 | Test feed weight (700 mL): |  |  |  |  | 1409
 | Equivalent to : |  |  |  |  |  |  | Size |  | Weight | % Retained |  | % Passing
 | Weight % of the undersize material in the ball mill feed: |  |  |  |  | 13.77813667104068 |  | Mesh | µm | grams | Individual | Cumulative | Cumulative
 | Weight of undersize product for 250% circulating load: |  |  |  |  | 402.5714285714286 | 0 | 6 | 3350 | 0 | 0 | 0 | 100 |  |  | 1 | 1 | 0.8819016856767942 | 3.447158031342219 | 0.777750583199571 | 0.6858995503598114 | 0.6048959696672729 | 3.040054478635003 | 2.681029169257496
 |  |  |  |  |  |  | 1 | 7 | 2800 | 117 | 11.80983143232058 | 11.80983143232058 | 88.19016856767942 |  |  | 2 | 1 | 0.7638033713535884 | 3.372912002970107 | 0.5833955900911078 | 0.4455995185444042 | 0.3403504145377518 | 2.576241559147552 | 1.967741988298126
Results |  | Average for last three satges |  |  |  | 404 | 2 | 8 | 2360 | 117 | 11.80983143232058 | 23.61966286464116 | 76.38033713535884 |  |  | 3 | 1 | 0.5885737357424043 | 3.230448921378274 | 0.3464190424057697 | 0.2038931499210702 | 0.1200061529413304 | 1.901357389780632 | 1.119089021884613
 | Circulating load |  |  |  |  | 248.7623762376238 | 3 | 10 | 1700 | 173.6 | 17.5229635611184 | 41.14262642575957 | 58.85737357424043 |  |  | 4 | 1 | 0.4628040779246997 | 3.071882007306125 | 0.2141876145437316 | 0.0991269014518027 | 0.04587633422393413 | 1.421679519884787 | 0.6579590793047088
 |  |  |  |  |  |  | 4 | 14 | 1180 | 124.6 | 12.57696578177046 | 53.71959220753003 | 46.28040779246997 |  |  | 5
CALCULATION OF A BOND WORK INDEX |  |  |  |  |  |  | 5 | 20 | 850 | 99 | 9.992934288886646 | 63.71252649641667 | 36.28747350358333 |  |  | 6 | 4 | 2.697082870697487 | 13.12240096299673 | 1.92175283024018 | 1.434519120277089 | 1.111128871370289 | 8.939332947447975 | 6.425819258744943
 |  |  |  |  |  |  | 6 | 28 | 600 | 66.2 | 6.682143938629252 | 70.39467043504592 | 29.60532956495408 |  |  | 7
 |  |  |  |  |  |  | 7 | 35 | 425 | 52 | 5.248813969920258 | 75.64348440496619 | 24.35651559503381 |  |  | 8 | 2800 | 88.19016856767942 | 4 | 2.697082870697487 | 1.92175283024018 | 13.12240096299673 |  | 2.225613229531676
 |  |  |  |  |  |  | 8 | 48 | 300 | 38.1 | 3.845765620268497 | 79.48925002523468 | 20.51074997476532 |  |  | 9 | 2360 | 76.38033713535884 | 2.697082870697487 | 1.92175283024018 | 1.434519120277089 | 8.939332947447975 |  | 2.331339415134109
 |  |  |  |  |  |  | 9 | 65 | 212 | 28 | 2.826284445341678 | 82.31553447057635 | 17.68446552942365 |  |  | 10 | 1700 | 58.85737357424043 | 1.92175283024018 | 1.434519120277089 | 1.111128871370289 | 6.425819258744943 |  | -1.076032008347107
 |  |  |  |  |  |  | 10 | 100 | 150 | 19.8 | 1.998586857777329 | 84.31412132835368 | 15.68587867164632 |  |  | 11 | 1180 | 46.28040779246997 |  |  |  |  |  | 0.8
 |  |  |  |  |  |  | 11 | -100 | -150 | 18.9 | 1.907742000605632 | 86.22186332895932 | 13.77813667104068 |  |  | 12 |  |  | 8.09124861209246 | 0.1031888273877313 | 0.1387374602382876 | 0.09128223251730638
 |  |  |  |  |  |  | 12 |  |  | 13.2 | 1.332391238518219 | 87.55425456747753 | 12.44574543252247 |  |  | 13
 |  |  |  |  |  |  | 13 |  |  | 123.3 | 12.44574543252246 | 99.99999999999999 | 0 |  |  |  |  |  | 5.76525849072054 | 0.1387374602382876 | 0.1878453862362536 | 0.1213164611985871
 | P1 = 100% passing size of the product |  |  |  |  | 150 |  |  |  | 0 | 0 | 99.99999999999999 | 0
 | Grp = Grams per revolution |  |  |  |  | 1.756463670511391 |  |  |  | 0 | 0 | 99.99999999999999 | 0 |  |  |  |  |  |  | 0 | 0.00131276094489427 | -0.001412572796014228 |  | 2523.62183455483
 | P80 = 80% passing size of product |  |  |  |  |  |  |  |  | 990.7 | 990.7 | - | - |  |  | $K$35 | $A$35 | 0
 | F80 = 80% passing size of the feed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -150
 |  |  |  |  |  |  |  | 80 | 2523.62183455483
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROW(vlookup(max(I20:I35),I20:N35,1))
 |  |  |  |  |  |  |  |  |  |  | 100 | 12
 |  |  |  |  |  | 0 |  |  |  |  |  | 31 |  |  |  |  |  | #N/A |  | #N/A
 |  |  |  |  |  | 11.80983143232058 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  | 23.61966286464116
 |  |  |  |  |  | 41.14262642575957 |  |  |  |  |  |  |  |  |  | -100
 |  |  |  |  |  | 53.71959220753003 |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  | 63.71252649641667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | $M$18 | $M$30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | Product | #N/A
 |  |  |  |  |  |  |  | Size |  | Weight | % Retained |  | % Passing
 |  |  |  |  |  |  |  | Mesh | µm | grams | Individual | Cumulative | Cumulative
 |  |  |  |  |  |  |  | 100 | 150 | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | 150 | 106 | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | 200 | 75 | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | 270 | 53 | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | 325 | 45 | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | 400 | 38 | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | 500 | 25 | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | -25 | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  | 0 | 0