Home

User Manual for KINCALC v2_1 Jul 07

1. What if scenarios Set up formats Lab Pilot or Plant data DATA IMPORT FORMAT Single file basis Any number of Data Worksheets AUTOMATIC IMPORT OF DATA Any number of Files Any Number of Data Worksheets Batch of files in a folder Single or multiple data sets per worksheet Client Mine Ore body type or stream in plant Date or time Reagents and additions Reagent addition Straight or Staged Input of anything user wishes to record examples shown for illustration only INPUT amp STORAGE OF TEST CONDITION DATA Goto Input page Conditioning Time Grind Solids Power kW input Clear the current Input Data Manage the List of Analytes Manage the List of Other Parameters Manage Stream Names Add current data to the Summary Sheet Cell rpm Copy current sheet page to a new workbook Air Flowrate Water Type Quality Import Data Wizard Temperature Import data from KinCalc database Geographical position Solve for Kinetics Goto Results page TOOL BAR ICONS f Depth or other position Goto Graphs page Clear all data off the Average sheet Delete the highlighted record on the Go to the Average sheet Average sheet Copy the current average values to the Highlight Differences between Input sheet Kinetics with without Boundary Tests Clear all data off the ScrollCalc page
2. eeeeeeeeeeeeeren rene 31 Figure4 Full Screen of Input Page showing Icons eese 34 Figure5 Flotation Circuit before Optimisation eese nennen 117 Figure6 Flotation Circuit after ODUEPISOU OD e oseteirt iet epi erras rant tees anon ke a aa 118 Eurus Mineral Consultants c IV L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 6 of 118 1 COPYRIGHT AND DISCLAIMER Disclaimer This work was created withdue application of professional and intellectual skills knowledge and expertise EURUS MINERAL CONSULTANTS CC however takes no responsibility for any loss occasioned by the use of the information contained in this work Copyright 2007 Copyright subsists in this work No part of this work may be reproduced or copied in any way without the written consent from EURUS MINERAL CONSULTANTS CC Any unauthorised reproduction of this work will constitute copyright infringement and render the doer liable under criminal and civil law All rights reserved Eurus Mineral Consultants c Wi C O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 7 of 118 2 SYSTEM REQUIREMENTS AND INSTALLING KINCALC Contents 1 Installation Standalone and Network 2 HASP security drivers 3 KinCalc database 4 EMC Excel utilities 5 First Time Use KinCalc spreadsheet
3. 1 2 3 5 T 8 m oe C C 5 m e B 3 Mame 10 1 BCL Mining ECL Cur SARL 35 75p m FFF lt q T 11 2 BCL Mining BCL Curt AARL 40 75pm PRF 12 3 BCL Mining BCL CuiMi AARL 455 75pm PRF 13 4 BECL Mining ECL Cul AARL 502 75pm FRF 14 h BCL Mining ECL Cui AARL BU rhum FRF 1F Cc CCA Adieie CO Ca aJh li herb D TE mim rier Coc 3 5 6 Saha UN n I SK x B x t gt 2 ubah mx x x OO SS SS IEEE Input Rate Flotation Test Data E 2 E m 4 Client EE KinCalc Manage Test Parameters 5 Ore Type j 6 Test Description lable Y Test Date min Test Variation e TFE 285 g t i pH Mickael Comments 1 Copper Comments 2 Cobalt z SIBX g t Iron 2i lefine Mew Dow 200 g t Sulphide Sulphur x t CuSO4 g t p Grind 25 lt 75 um z Flotation Feed Concentrate 23 f d an Clear Check Boos to temporarily emi g 26 Sample min 4 d i TER os Feed han 1tlised RET 28 ale 28 Eumene A es 30 Cone 1 4 cK A Af Eurus Mineral Consultants C IVI 2007 Copyright subsists in this work unus mineral consultants CIVIS EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Indes co lt J co cH F c2 D Page 24 of 118 arm solids arm solids arm Solids 3734 solids ar solids ics better than boundary ics better than boundary ics better tha ics better tha
4. Nickel relative to g Slow Floating Ratio the slow floating flotation rate of SFR Nickel relative to gangue Nickel _ A measure of the floatability of Nickel Floatability INiF kNiS 1000 angue _ A measure of the floatability of the gangue component Floatability IGF kGS 1000 A measure of relative floatability of metal or mineral to gangue Selectivity incorporating all kinetic values For example Nickel selectivity is defined as INiF kNiF kNiS IGF KGF kGS 1000 In all cases I fraction k rate F fast and S slow Ni Nickel and this can substituted as required depending on what is being analysed or assayed A few examples are P or PGM is substituted for Platinum Group Metals Cu for Copper Co for Cobalt Au for Gold S for Sulphur MgO for Magnesium Oxide Cp for Chalcopyrite Pn for Pentlandite Po for Pyrrhotite G for Gangue and M for Mass Met and Min for any metal or mineral 4 3 Brief Overview of the Kinetics Calculator The Kinetics Calculator 1 2 Allows minerals analytes assays and their units of measurement to be managed Allows other test and measurement parameters and their units of measurement to be managed Permits formats to be specified for data collection from other excel files and worksheets Permits all test data and test descriptions to be recorded Allows test stream names and source i e lab pilot plant or plant to be recorded Imports dat
5. 390 787 760 Casey LLL 034 024 058 Grade g t 2Coms __ 1064 31 68 Lo d 1 J 75 15 760 V LLCCLCCCLCCLOm o9 9 cae2 TT L oun 6 5291 LL 705 T 56 T 761 n 2 Concs Original MF Grade g t a 1121 212 631 1378 632 2 Concs PGM Recovery Table 1 Simulated vs Actual Mass Balances PGMs GANGUE revs GANGUE _ Table 2 Flotation Kinetic Changes Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work
6. Fe Ni o5s Mass of gangue 99 254 76 Difference in mass 0 455 High Grade Base Metal Canada Mass gr in 1 000 kg PGMs g t ie 0 0002 Mass of gangue 959 998 0 96 000 ie 0 000576 PGMs gi Chalcopyrite Pentlandite Fe Ni o5s Mass of gangue 898 839 6 89 884 Difference in mass 6 116 Both the mass and kinetics of the gangue fraction can therefore vary depending upon how they are defined Taking the example of the Canadian high grade base metal ore one step further the analytes assayed for this ore were Copper Nickel Cobalt Iron Sulphur and Magnesium Oxide From these data mineral assays can be estimated by combining the first five elements in the required proportions to give Chalcopyrite Cp CuFeS Pentlandite Pn Fe Ni e5s and Pyrrhotite Po Fe11S12 Both Iron and Sulphur are major constituents of these three minerals but they also occur in the floatable host rock component together with oxides of Silica Calcium Aluminium and the like as Talc Pyroxene and Feldspars The table below shows how gangue kinetics varies depending upon how the floatable gangue component is defined in terms of analytes and minerals Note that the kinetics for mass remain constant because concentrate mass recovered is a recorded value and the kinetics for individual analytes and minerals also remain constant because these are fixed by virtue of their respective assays In each case the relative floatability
7. Pa Q gt lt e i a e S Q o Ro Conc Recovery for Cluster 9 Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 89 of 118 17 ACCESS or SOL DATABASE Functions available 1 Importing of data back into the Summary Sheet 2 Queries and searches of the database by customised selection tables gt Diagrams highlighting various points detailed below can be found towards the end of this section 17 1 Posting Data to the Access or SOL Database Single data records can be posted to the Access or SOL Database by highlighting the required data and clicking the icon If all data on the Summary Sheet is to be posted to the Access or SQL EA Database then this is done by clicking the icon 17 2 Importing Data from the Access or SOL Database into the Summary Sheet T This is done by clicking on the icon As per the dialog boxes below this shows an import table with two tabs Test Info and Other Info The import table allows the user to select data from a variety of categories Client Mine Ore Type Plant Analytes Other Parameters and Stream Names The number of matching records for the particular combination of categories chosen is shown at the bottom left of the import table in this case it is 2 matching records On the Test Info tab the Data Source may be chosen i e laborator
8. Sort all data in chosen column in Go to ScrollCalc descending order Copy the active ScrollCalc parameters to the Summary sheet Sort all data in chosen column in ascending order Customise program settings Show the Data sheet Rows to Columns Highlight specific row Delete highlighted row of data Columns to Rows Paste special function maintaing Highlight a Specific Row Probo work heet TOOL BAR ICONS Goto Summary sheet Copy Highlighted Row to Input Sheet Clear Summary Sheet amp Input Page Copy highlighted record to the Average sheet Copy highlighted row to ScrollCalc Summary Roll Up Hide all details Post current record to the KinCalc database Post all summary records to the KinCalc database Create a Correlation Matrix from selected data Create a Frquency plot from selected OPTIONAL TOOLBAR ICONS dat Transform Layout of Kinetic Data Sets Rows to Columns Columns to Rows Paste special function maintaing format of worksheet One Glance Layout of Program Functions in Mind Map Format Eurus Mineral Consultants 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 30 of 118 Solving Kelsall s equation to determine kinetics sometimes gives values which are mathematically correct but not adequately Import Wizard E Choose to RE Input test Input Input input Ele e 20
9. Spreadsheet will be unable to locate the database file In this case the following message will appear This program is not functional if the database file KinCalc 2002 mde is unavailable You wil be asked to locate the database file My Recent Documents My Computer File name WCOMPUTERNAME KinCalcDB My Network Places Files of type Compiled Databases mde You may type in the path to the database in UNC format such as that shown in the file name box at the bottom of the above image where COMPUTERNAME is the network name of the computer where the database was installed You should have made a note of this name during the installation described in section 2 7 1 The KinCalcDB shown in the above image corresponds to the share name that you selected also in section 2 7 1 Entering the appropriate parameters in the form COMPUTERNAME SHARENAME and clicking Open will take you to the relevant shared folder on the network computer where you may then select the mde file called KinCalc2002 mde C IV LW 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 17 of 118 Point to the KinCalc MS Accessi Database File Look in KinCalcDB My Recent Documents Es Desktop My Network Places Files of type Compiled Databases mde Select the file and click Open Wait a few moments as the KinCalc Spreadshee
10. Test Date Qs 01 06 Test Variation Mil Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 21 of 118 Initial Set up as regards the Database and Analyte Mineral and Test Parameter Names The KinCalc spreadsheet is linked to an Access or SOL database All testwork data kinetics manually estimated ScrollCalc Kinetics and kinetic ratios can be loaded into the database when required Once an analyte mineral or assay name has been specified and loaded into the database it cannot be deleted from the Manage the list of Analytes and Minerals form The name can however be changed This also applies any other parameters specified such as reagent additions grind etc as set up by you in the Manage the list of Test Parameters It is therefore very important before using KinCalc to set up your list of analytes minerals and test parameters with the descriptions and nomenclatures that you and or your company are happy to use and are not going to change If the Database is open KinCalc does not function when the database has been opened via Windows Explorer or the root directory If the database is opened when KinCalc is active then all functions cease and an error message appears as per below KinCalc is set up so that the database is accessed only when the Import Data from the KinCalc Database icon is selected When KinCa
11. charing and Security g fa Zip b Scan with McAfee VirusScan Send To Cut Click on the Share this folder option and enter a share name that is easy to remember e g KinCalcDP Eurus Mineral Consultants O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 11 of 118 KinCalc Properties You can share this folder with other users on your network To enable sharing for this folder click Share this folder Do not share this folder Share this folder Share name KinCalc DE User limit 9 Maximum allowed Allow this number of users b To set pemissions for users who access this folder over the network click Permissions To configure settings for offline access click Windows Firewall is configured to allow this folder to be shared with other computers on the network View your Windows Firewall settings Click on Permissions and then give Everyone full control watch IT administrator faint at this point Permissions for KinCalcDB Share Permissions Group Or user Names Permissions for Everyone Eurus Mineral Consultants A A IV C O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 12 of 118 Click OK to complete the sharing If corporate IT policy precludes applying permissions as described above then
12. 0 0624 36394 75376 67892 58 09 0 4768 2 3537 iessssusNsEUE NESS Se Ge ES eS clea mer n DE Ey EK 496 Mir Figure 4 Full Screen of Input Page showing Icons C RAS Eurus Mineral Consultants Ce IVI U 2007 Copyright subsists in this work unus mineral consultants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 35 of 118 6 DEFINING ANALYTES MINERALS AND FLOATABLE GANGUE Functions available 1 Input mineral analyte or assay names and units of measurement Select preferred units of measurement or g t for display Select category of mineral or analyte i e metal metal contaminant or floatable gangue Change symbol representing preferred units of measurement Set up tables of analyte or assay aliases Set up tables of units of measurement aliases pr bus 2 qx gt Diagrams highlighting various points detailed below can be found towards the end of this section 6 1 Managing Analytes and Minerals Click the Manage the List of Analytes icon to access the Manage Analytes and Minerals box New analytes can be added using the button Add New Name abbreviation units 76 or g t and category metal or mineral metal contaminant or floatable gangue can be chosen KinCalc has been set up to use and g t as the two standard assay units These can be changed via the Edit button The Units button calls up a Manage Assay Units box which allows you to enter unit aliases such as ppm o
13. 00379 00500 0 0443 0 0379 error message appears If there are any hidden rows or columns in the selected region this will lead to one of several 0 0060 12112 oona oooga omso omez 06641 osese 00654 Onsa 03781 moos ans 368 0 0067 07468 11992 0 0355 Loo Warning X 0 02765 0 0 0433 04378 0 0691 0631 ae One of the rows you selected does not noses 0 v X contain a multiple of 3 columns 00400 0 00231 0 00343 0 messages suchas You may not select only certain columns in the header range and the corresponding columns in a Warning There are some hidden columns in the range vau selected Please unhide them and try again data row otherwise you will receive an error message such as Eurus Mineral Consultants 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 104 of 118 0 0277 0 2461 0 0084 1 0268 02334 0 0083 07306 0 3433 0 0362 0 6002 0 0060 1212 oons 0 0060 ooo o0122 06641 03832 00654 05782 04886 00190 Coms ora Els 06122 06744 osa Warning Ef 04216 10264 000361 5 04142 05767 00069 You selected 4 regions p 05741 0 3232 0 0087 1 0 6306 0 2366 0 0066 You must select a header row and a
14. 172 i 173 1 32 5 46 40 70 12 45 13 17 1 02 174 i 1 32 5 46 40 70 12 45 13 17 1 02 175 176 177 178 Conc 3 Assays Ir Conc Assay 120 15 10 Assay Units merged with Assay Names is ticked if the assay name and its unit are in the same cell such as PGM Au g t The dialog box below shows PGM Au Cu and Ni are in separate cells to the g t unit The One Data Set per Sheet is ticked in the Data Sets per Sheet box In the dialog box below the Client Name box has been ticked and the cell B3 selected so that the Import Wizard will pick up the client name in this cell for every worksheet that has a dataset with the same layout and format The Import Format allows for assays to be in columns or in rows The dialog box above has the box ticked for In Columns per Assay In the next dialog box below Conc Assays has been chosen and the three assay columns have been highlighted Note that the columns are not next to each other Any combination of assay columns or rows next to each other or with gaps in between can be accommodated Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 53 of 118 Define a New Import Format Em Folder c gt Required Item ni 2 Demonstration of E3nC alc eq it E ERE lt B f Norn Filename IMP Mer2005 Lfield MF1 RoRates xds Choose File A E 1
15. Ga Adrian File Folder 06 04 06 08 57 AM D DB Backups File Folder 07 04 06 03 36 PM Documents and Settings File Folder 01 06 05 04 41 PM Ga KinCalc Development File Folder 19 04 06 09 49 AM Program Files File Folder 19 04 06 10 58 AM y 5WSetup File Folder 17 05 05 04 46 PM O WINDOWS File Folder 07 04 06 11 01 AM 4KinCalc2002 mde Microsoft Access M 19 04 06 02 12 PM FV KinCale be mdb Microsoft Access Ap 07 04 06 03 03 PM Al Metis mdb Microsoft Access Ap 08 12 05 11 48 AM My Metwork Places Files of type Microsoft Access mdb adp mda mde ade eurus mineral consultants Click logo to accept the licence agreement and continue and wait a moment while the back end tables in KinCalc be mdb are automatically linked to the front end file you just opened viz KinCalc2002 mde Once the main menu appears the linking process is complete and you may click on the Exit Database amp Access button to quit the database and MS AccessQ or SQL o a mum Eurus Mineral Consultants c nt 2007 Copyright subsists in this work CIVIS Copyrig EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 15 of 118 a d x 3 t Search amp Export an k eurus mineral consultants m Edit Lookup Tables n Exit Database Access Licenced to Eurus Mineral Consultants Should the network computer not have MS Access or SQL installed the above
16. KU 47 g t KUS g t ID jade degrees E A Lime g t 23 Longitude degrees 5 22 M59 g t 58 pH 2336585838 n zd have been utilised EET ES ESAE ER ES EA EIE 23 Lec 352 1 gt R KinCalc EEES Test Parameters Mote Farameters should be added with care as they cannot be deleted once they Define Mew Delete 7 Parameters selected automatically appear as an Other Test Parameters table E 7 1 TEE Lj EU ES i d cumin reimem cone ira al E 1 nz earn L L Inm ml Ina Grind 75 pm CusO4 g t SIBX gt Senkol 5 g t Sasfroth 169 g t KU 47 g t Eurus Mineral Consultants 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 49 of 118 10 AUTOMATED IMPORTING OF TEST DATA Functions available 1 Import function the Import Wizard to automatically input raw data from files and worksheets within files on an individual or batch basis i e multiple files and worksheets contained in a folder 2 Input of test descriptions and conditions by hand or by import function 3 Input of any test condition sample details or any other parameter that is required to fully describe the test Set up of custom import formats and saving formats for future use 5 Screening of raw data via the Auto Report to identify data import errors before processing gt Diagrams highlighting various points detailed
17. Reset INiF a li IGF gt 4 gt R E kis E KGS F OOO MEL El X FO E E F T 40 Bu cu z 230 D e m 20 m 10 0 0 1 0 2 0 3 0 40 Time mins Gangue Recovery TSX Points Meas d Line Calc d g a Pe Case 2 IGF KGF kGS of 0 0590 0 0356 0 00001 The diagrams below are annotated according to the points below 1 The value of IGF 0 0590 i e 5 90 is off the scale on the Gangue recovery time curve 2 Following the same procedure as above a new set of kinetic values are generated 0 0073 0 2076 0 0010 and SSE is similar to the original value 0 65 vs 0 66 Eurus Mineral Consultants c Wi C 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 81 of 118 Reset Active Data Set Lab SEN ICuF 0 0641 kCuF al E F 7 0 0295 kCuS 4 0 0000 E _ 30 2 20 zo EMEN Soa m i 10 5 i5 20 0 0 0 5 1 0 15 2 0 25 Time mins Gangue Recovery X 1 Points Weas d Line Calc d 7 s Pei Reset Active Data Set Lab Copper IcuF IGF 1 kCuF a E boi kGF kCus a gt kGS s aw o aw _ o 3 NE 30 E EE gt o 3 s n HE 8 L m E 10 5 15 z 0 0 0 5 1 0 1 5 2 0 25 Time mins Gangue Recovers X l Points WMieas d Line Calc d a sf Pei The table below highlights instances where kCuF t
18. 0 00056 0 00250 5 Rougher Rate Test on Secondary Rougher Conc Sample 05 01706 0 00407 0 00433 0 10440 Rougher Rate Test on Primary Fiougher Tail Sample 02701706 i 0 00070 0 00010 0 01434 7 0 00263 0 00260 0 04533 8 00227 0 00224 D 0 3313 31 32 33 34 Kelsall 35 Inde 3B 1 Rieugher Rate Test on Secondary Rowgher Tail Sample MOG j p oos i 0 00 003 gdt 37 2 Rowgher Aate Test on Crusher Circuit Fines Thickener OIF 06 01 06 0 00056 0 00056 0 00250 38 3 Rougher Rate Test on Secondary Rougher Feed Sample aos O 00005 0 00005 0 07600 33 4 Rougher Rate Test on Crusher Circuit Fines Thickener OF 06 01 06 i 0 000056 0 00056 0 00250 4 5 Rougher Rate Test on Secondary Rowgher Conc Sample asinus 0 00407 0 00433 0 10440 41 6 Rougher Rate Test on Primary Rougher Tail Sample D2Z 01706 0 00010 0 00010 s 0 01434 42 T 0 00265 A f 0 00260 h 04635 43 Q 002271 i 000224 0 03313 The sort all data in descending order icon bi has been used The values in the IGF column have been sorted in descending value and the results for all tests have been arranged in the same order in all other tables Note that the numerical order in the Index column remains unchanged whilst that in the Sort Index column has been changed and reflects the original order of the data 9 Misc P 3 Hams vi E clud d Plant 10 1 Rougher Rate Test on Secondary Rou
19. 0 1416 0 1117 0 9356 0 8833 0 2133 0 1862 0 8752 0 3253 pini row and 0 0003 0 0001 0 0325 0 0025 ere Mass Gangue Copper Nickel Fast Floating Fraction 0 1416 0 1117 0 9356 0 8833 Pasted with row and Fast Floating Rate 0 2133 0 1863 0 8752 0 3253 column headers Slow Floating Rate 0 0003 0 0001 0 0325 0 0025 Eurus Mineral Consultants c Wi C O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 101 of 118 Columns to Rows Before using the transpose function from columns to rows the user must select a header row and the three data rows below it Selection of the header row and the data rows must be done together in one action The picture below shows the kinetic data in columns with headers highlighted and the Columns to Rows box with the Include Column Headers box ticked Centre aligning and formatting the data have been ticked Formatting means that the paste special functions are active when the data is pasted to the chosen file or worksheet Next click Copy to Clipboard and go to the file and or worksheet where the data is to be pasted j Below this the data has been pasted into cell C amp using the icon Mass Gangue Fast Floating Fraction 01416 01117 Fast Floating Rate 02133 0 1863 Slow Floating Kate 0 0003 0 0001 Choose your options Columns to Rows Ww Centre Align IV Format Numbers Copy to Clipboard 1 2 Mass Gan gue Copper Nickel
20. 3 Fast Floating Fraction 01416 0 1117 0 9356 0 5833 4 Fast Floating Rate 02133 0 1563 0 5752 0 3253 5 Slow Floating Rate 0 0003 0 0001 0 0325 0 0025 6 7 IMF EMF KMS IGF EGF kGS ICuF kCuF kus INGF ENIF ENIS 5 0 1416 0 2133 0 0003 0 1117 0 1863 0 0001 0 0356 0 8752 0 0325 0 8833 0 3253 0 0025 To Add New Analytes Once you have copied the selected region to the clipboard and pasted it using either of the above methods you may find that in the former case an analyte is reflected as Unlisted or in the latter case the analyte abbreviation may be shown as ZZZ This means that the analyte in question has not been defined within this Add In Analytes may be recognised either by name or their abbreviation as listed on the configuration form of the add in h A 7 Eurus Mineral Consultants IVI U 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 102 of 118 To either add a new analyte name and abbreviation combination or to add an additional name for an existing abbreviation call the add in configuration form by clicking on the Ee icon and choosing the Analytes tab Manage Settings E aa Frequency Plot Defined Analytes Cres E Au Fe Ii MgO TEI m Abbreviation Palladium In the above example chrome metal is listed as Chrome Cr or Chromium Cr The add in will recognise any of Chrome Chromium or Cr When transposing from
21. 33 34 Ke sall Parameters After Boundary Tests a5 mae Dra Mm Gre Plt 2170 Tees 3b 1 Amplats A Mline WG 2 Amandelbult Rougher Rate Test on Primary Rowgher Feed Sample 01 01 06 oF 2 BREPM Bafokeng Merensky BRPM Plant Fougher Rate Test on Primary Rougher Tail Sample neos 38 3 RioMarcea Aqua Blanca Geld RA Plant Rougher Rate Test on Secondary Rougher Peed Sample 035701706 13 3 Kelsall Parameters After Boundary Tests and After ScrollCalcTM These tables summarise the flotation kinetics calculated as is without the boundary tests with boundary tests and manually via ScrollCalc see section 16 13 4 Linear Correlation Coefficients A measure of how close the mass gangue and analyte recovery time curves are to a straight line The measure is via the linear correlation coefficient 12 13 5 Sum of Squared Errors Based on Boundary Test Parameters This table summarises the total error between predicted and actual recovery for mass gangue and analyte The sum of squares of differences of corresponding values in actual and predicted recovery values is described by the equation below Sum of Squared Errors SSE actual predicted 13 6 Slow Floating Ratio The slow floating ratio SFR is the ratio of the slow floating rate of analyte divided by the slow floating rate of gangue For example for Copper it is the ratio of kCuS kGS see section 4 2 Eurus Mineral Consultants k IVI L 20
22. 4 E 4 har 4 Mote After clicking Cancel any changes made will remain in effect for the current session The changes will be lost if KinCale is not saved After clicking Done please be patient while changes are saved T 19 3 File Locations The location of the Access or SQL Database can be altered or and the connection checked by clicking on the appropriate buttons The location of the Toolbar and Menu Images can be altered by clicking on the Browse button 19 4 User Interface There are several choices the user can make in this table e Warn about discarding Import Wizard Report When this box is ticked the user is reminded whether they wish to save an Import Wizard Auto Report e Disable the removal of the Solver reference This attends to one of the known Microsoft glitches with respect to the Solver function When loading the KinCalc program onto a computer for the first time this box should be unchecked This means that the reference to the Solver function is linked to the KinCalc program when the program is used for the first time Once KinCalc has been installed and run for the first time this box can then be checked and the reference to Solver removed m n Af Eurus Mineral Consultants C IVI V O 2007 Copyright subsists in this work nus rnineral consuia EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 95 of 118 Delete VB Code Modules on Import There are ins
23. Click Buttons to BO Fa hi S m 2 40 Ier S 30 bo or 5 20 m 10 0 0 1 0 2 0 3 0 4 0 Time mins Gangue Hecoverg 7 l Points Pleas d Line Calz d a sf l Fei Reset Active Data Set Lab Nickel Reset J n j INiF 4 E IGF 0 0619 E Refresh KNiF al Graphs gt A i 0 0495 kNiS a kGS 0 0003 kal Fecowen ss on us 22m _ _ 2327 4 Bn Fa w a 40 Z P 2 30 Hr 20 m 10 n 1 0 2 0 3 0 4 0 Time mins Ganque Recover X l Points Pleaz d Linz Calc d af l Fe Fieset Active Data Set Lab Mickel 5 INiF 4 E IGF aj Pa KNiF aj n Ed ker kNiS n KGS ssE om 12 1385 14 39 e Buttons to Click Buttons to Bl Fa m hl 40 3 2 sn 2 E 20 m 10 15 z 0 0 1 0 2 0 3 0 40 Time mins Gangue Recoverg SX Points Meas d Line Cale d 3 sf l Fe Eurus Mineral Consultants 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 80 of 118 o T 7 Reset Active Data Set Lab Nickel 47 INiF E ick al axir intl nor uy kNis B kGS 8 SSE op we osz 63 me a 40 2 sn M 5 20 co 10 0 0 1 0 2 0 3 0 4 0 Time mins Points Meas d Line Calc d Gangue Recovery 2 Fe Pa 9 Reset Active Data Set Lab Nickel
24. Coppe Abbreviation Detected Analyte Mi will be imported as Mickel Abbreviation Detected Analyte Mi will be imported as Mickel Note Tails Assay for Copper converted from g to 5 Note Tails Assay for Copper converted from g t to 5 Note Tails Assay for Nickel converted from g t to H Note Tails Assay for Nickel converted from g t to 5 Warming Conc Assay does not seem to be a number or is missin Note Conc Assay for Copper converted from g t to 5 Note Conc Assay for Copper converted from g t to Note Conc Assay for Mickel converted from g t to 5 Note Conc Assay for Nickel converted from g t to HT SUCCESS importing Sheet Mechanised Ro Rate 60 SUCCESS importing Sheet Normal Ro Rate 80 ERROR END Sheet 3 3 Mechanised Ro Rate amp 60 END Sheet 2 2 Normal Ro Rate 805 ERROR we If a large number of worksheets and or files are processed then it will be difficult to identify if there are any errors in data or import format It is therefore essential to click Auto Report When this is done the contents of the Import Notes list box are reported to a workbook which can be looked at on screen or printed out An example is shown below i file processing completed on 20 03 06 at 13 07 19 q file processing completed on 20 03 06at131127 T Error encountered If a large number of worksheets and files have been
25. Points Meas d Line Calc d angue sce evens lt Fe In both cases the problem of correct estimation of kinetics is caused by the rate test being conducted for only 6 minutes 16 6 Guidelines for Kinetic Values A series of graphs are shown below for Gangue defined as excluding and including Fe and S see section 6 7 PGMs Copper Nickel Cobalt Fe 5 and Cr2O3 These provide guidelines for values of fast floating fraction and fast and slow floating rate Eurus Mineral Consultants c Wi C 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 84 of 118 Rougher Rate Test Gangue Kinetics excl Fe S Cluster Cluster2 Cluster3 Cluster4 Cluster5 9 Cluster 6 Cluster 7 IGF 0 0294 0 1217 0 2002 0 3313 0 2946 0 4122 0 5000 T Time at which Fast Floating Fraction is recovered Kas 0 00105 0 00127 0 00141 0 00743 0 00920 0 01035 0 0010 Ro Conc Mass Recovery Rougher Rate Test Gangue Kinetics incl Fe S Cluster1 E Cluster2 Cluster3 Cluster4 Cluster5 Cluster6 4 Time at which Fast Floating Fraction is recovered L Ro Conc Mass Recovery Eurus Mineral Consultants CIVIL 2007 Copyright subsists in this work EURUS MINERAL CONS
26. The various components of the KinCalc suite should be installed in the order in which they are discussed hereunder A screen image of the contents of the installation disc is shown below Folders am Size Type Date Modified E 3 KinCalc Setup Folder 17 04 2006 03 19 PM E HASP Sample Data Folder 11 04 2006 06 16 AM IC Drivers Es EMC Utilities Setup exe 390 KB Application 11 04 2006 12 20 AM 9 Licence Manager T3 Installing KinCalc pdf 269 KB Adobe Acr 17 04 2006 04 04 PM Z utilities E KinCalc Database Setup exe 441KB Application 10 04 2006 10 14 PM 73 Sample Data 4 KinCalc Documentation Setup exe 3 398 KB Application 17 04 2006 03 15 PM T E KinCalc Setup exe 1 480 KB Application 11 04 2006 12 49 AM 2 4 Documentation Insert the installation disc into your CD ROM drive Locate the KinCalc Documentation Setup exe file in the root folder of the installation disc and run it either by double clicking it or highlighting it and pressing ENTER Follow the on screen prompts to install the documentation The default installation folder is c Program Files KinCalc After installation the documentation may be accessed through the Start menu by choosing Start All Programs KinCalc Manuals and selecting the desired document to open 2 5 The HASP Drivers There are two possible scenarios wrt to the HASP drivers If the KinCalc application has been provided with network licenses then the HASP license manager and
27. data conditions description Page Modo Ap ME Kinetics descriptive of the material s practical response hence these tests Choose boundary tests MANUAL AUTOMATIC CALCULATION CALCULATION Manage set up list of Choose Graph OF KINETICS OF KINETICS Analytes Minerals Type and Other Parameters nee 4 Calculate kinetics Configure Customised eas use best fit h isual Graph Settings Page e button if so a go to KinCalc Kinetics kinetics KinCalc ScrollCalc KinCalc Select Existing File Re input of Processed data or Kinetics R esults Page Access Database per test 5 Standard Graphs NEXT Data Sheet Customised Graphs 1 Rec Time amp Grade Time CRISI GER per set of data Summary Sheet per set of data Average Page Dump into Excel Compare sets of analytes minerals 2 Rec Grade Compare lab pilot and plant data 3 Rec Mass Plot combinations of data 4 Mas Time 5 Separability Analyse using standard Excel functions Histogram amp Correlation R functions Figure 2 Flow Diagram of KinCalc s Main Functions Eurus Mineral Consultants C IVI UL O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 31 of 118 Automatic Import Boundary test single multiple file i algorithms A Import Wizard Input Page Calculate Kinetics Results Page Lab Pilot P
28. table to select or deselect boundary tests W Testi s W Test 5 W Test 3 Iw Test 7 W Test 4 Clear All Select All Iw Show Wamines o tee R Al Eurus Mineral Consultants C IV L 2007 Copyright subsists in this work missed can Harte Sumus minerai constans EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 64 of 118 KinCalc V1 2 Client COUNTRY MINING Co Ore Type MERENSKY Mine WESTERN BEAVER Plant Name TREE FELLING No 2 Test Description MECHANISED MINING DEPRESSANT Test Date 08 47 AM 24 March 2006 Test Variation Ave of 4 tests 7 8 9and 10 Mass Gangue PGMs Copper Nickel grams or 9 s t Double click to calculate Measured Feed 100 00 3 99 0 06 Calculated Feed 100 00 99 77 4 08 0 06 kinetics Calculations Diff d Calc 0 0 0 Meas d Calc d 0 08 0 00 0 00 will use the boundary Combined Concentrate 24 69 0 37 0 69 1 Tails 0 20 0 01 0 06 tests as chosen m j Boundary Test Settings Recoveries Combined Concentrate 91 38 66 87 below Tails 8 62 33 13 Solve for Kinetic Parameters Measure of the error for MERENSKY MECHANISED MINING DEPRESSANT Mass Gangue PGMs Copper Nickel mass gangue and each Fast floating fraction I 0 1013 0 1004 0 8862 0 8283 0 5708 0 0000 Fast floating rate kF 0 3884 0 3797 1 9096 2 1188 1 5657 0 0000 analyte The square of Slow floating rate kS 0 0026 0 0026 0 0469 0 0307 0 0112 0 0000 s
29. which is stored in the root folder of the installation disc Follow the on screen prompts to install the utilities They may be either activated or de activated from the Start menu by choosing Start All Programs KinCalc and then choosing the appropriate item from either of BSE Activate EMC Excel Utilities BSF Deactivate EMC Excel Utilities Upon installing and activating the functionality of the EMC Excel Utilities will be available for use with any Excel spreadsheet that is loaded not just with the KinCalc Spreadsheet Refer to the KinCalc user manual for details 2 9 First Time Use 2 9 1 KinCalc Database The database component consists of two files viz KinCalc2002 mde and KinCalc be mdb Note that the 2002 in the KinCalc2002 mde filename refers to the fact that the database is in MS Eurus Mineral Consultants c Wi C O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 13 of 118 Access 2002 format or SOL while the KinCalc be mdb file is in MS Access 2000 file format or SOL If the database was installed to any location other than c Program Files KinCalc the two components of the database will not be linked to each other and opening the KinCalc Spreadsheet and attempting to import data or use many of the menu items within the spreadsheet before performing the following steps will generate errors This will occur because certain
30. 00084 0 01019 20 05 05 0 00091 0 00091 3 0 00603 20 05 05 0 00060 0 00060 2798 0 00610 20 05 05 0 00064 0 00064 i 0 00561 16 5 Method for Determining Kinetic Values Manually Case 1 IGF KGF kGS of 0 0619 0 0495 0 00033 The diagrams below are annotated according to the points below The value of IGF 0 0619 i e 6 19 is off the scale on the Gangue recovery time curve The correct value for IGF usually falls within the 3 5 minute period Start by setting IGF to a value within the 3 5 minute period Sum of the squared errors SSE increases as seen from the disparity between measured and calculated data in the Gangue recovery time and Nickel recovery Gangue recovery curves Change kGF value until The beginning of the calculated curve matches the first measured data point Change kGS to match the end of the curve with the final measured data point This has made calculated values over shoot measured values at the start of the test Finally adjust KGF and IGF as required to match the calculated curve with measured points IM ps O po NM Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 79 of 118 Reset Active Data Set Nick 1 ese ve Data Set Lab Nickel Reset INiF 4 Bl IGF 1 l Refresh KNIF al F Graphs u i kis 4 gt kG gt L sse om ye 036 163 Click Buttons tox
31. 10 0 50 15 9 21 ics better than 3275 solids Lab 10 0 50 15 9 20 ics better than 375 solids Lab eh 3 10 ics better than boundary eb 50 Lab eh 13 3 10 ics better dues 35 Alternatively the a column for the required parameter can be added retrospectively as follows paragraph numbers refer to the annotations of the diagrams below and also see section 8 2 1 NV ITI Ta m Highlight any test in the summary table e g the test with index 1 in row 10 Click the icon to Copy the Highlighted Record to the Input Sheet On the Input Sheet click the icon to Manage the List of Other Test Parameters Select the parameter to be added in this case Grind 76 75um Rerun the kinetics calculation module by clicking the icon Solve for Kelsall Parameters Click the icon Append the Current Results to the Summary Sheet A duplicate of test index 1 is added to the summary sheet as a test with index 29 in row 38 Also a new column labelled Grind 76 75um has been added The test index 29 can then be deleted using the Delete the Highlighted Summary Record s icon The test and its kinetic data are removed but the Grind 76 75um column remains 10 Data may be entered into this column for all or any of the tests in the summary sheet Eurus Mineral Consultants f n A y C IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 23 of 118 E X SF la REC
32. 1179 0 5587 0 9971 EMEN 42 8 0 4332 0 3829 0 7469 0 6602 EMEN 86 5 Slow Rate 0 0184 0 0139 0 0572 0 0560 E 0 0298 0 0241 0 1113 0 0763 EH Y Rec of Rec of Fast Fraction 0 1558 0 1328 0 8060 0 6697 0 7897 0 7851 0 7817 0 8853 0 8639 0 8994 Fast Rate 0 3701 0 5592 0 9971 0 5673 mE 46 6 0 4332 0 4166 0 7304 0 6602 0 7084 ME 87 7 Slow Rate 0 0184 0 0179 0 0625 0 0560 0 0466 E 0 0298 0 0279 0 1128 0 0763 0 0911 Ld Source of data Using Simulation to Understand Metal and Mineral Flotation Performance at one of Falconbridge s Base Metal Operations M P Hay Eurus Mineral Consultants and D Fragomeni amp T DiFeo Falconbridge Technology Centre Sudbury Canada Presented at the Nickel 05 Conference Cape Town November 2005 Eurus Mineral Consultants k IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 42 of 118 7 DEFINING STREAM NAMES Defining specific stream names helps identify the source of the sample and makes queries and searches in the Access or SOL database easier and more precise This helps to prevent confusion caused by naming a particular stream in more than one way e Click on the Manage Stream Names icon to call up the Manage Stream Names box e Typeina new stream name in the New Stream Name box and click Add e You will be prompted to accept or type in your own preferred abbreviation Type in stream name and click Add and ch
33. 1474 i Fast Rate 0 4332 0 4170 Slow Rate 0 0127 0 0106 Slow Rate 0 0298 0 0311 Fast Fraction 0 7851 0 7479 e indicates kinetics remain unchanged indicates kinetics remain unchanged Rougher feed minerals Cleaner feed minerals Rate test 28min giving 48 6 mass Rate test 21min giving 88 3 mass Rec of Rec of Fast Fraction 0 1555 iam Kinetics of all analytes Cu Ni Co Fe S MgO 0757 IN Kinetics of all analytes Cu Ni Co Fe S MgO Fast Rate 0 4333 0 0150 ioc d M 0 4332 0 4044 d bb dc NN 65 7 Slow Rate 0 0184 0 0118 0 0298 0 0129 EZ Chalcopyrite _Pyrrhotite T Rec of Te Rec of Fast Fraction 0 1558 0 0469 0 8285 0 6697 0 7927 0 0507 Gangue 0 7851 0 6092 0 8974 0 8639 0 8490 0 5391 Gangue Fast Rate 0 4333 0 0150 0 5587 0 9971 0 1100 0 0150 29 9 0 4332 0 3610 0 7469 0 6602 0 3959 0 4179 67 5 Slow Rate 0 0184 0 0124 0 0572 0 0560 0 1100 0 0129 E 0 0298 0 0087 0 1113 0 0763 0 0749 0 0174 Ed ea a ee Chalcopyrite Pyrhotite MgO Rec of Gangue Fast Fraction 0 1558 0 0479 0 8285 0 6697 0 7927 0 7851 0 5887 0 8974 0 8639 0 8490 Gangue Fast Rate 0 4333 0 0150 0 5587 0 9971 0 1100 o px 0 4332 0 3755 0 7469 0 6602 0 3959 a 67 6 Slow Rate 0 0184 0 0125 0 0572 0 0560 0 1100 0 0298 0 0114 0 1113 0 0763 0 0749 V Rec of Vo Rec of Fast Fraction 0 1558 0 1681 0 8285 0 6697 0 7851 0 7777 0 8974 0 8639 Fast EJ 0
34. 70 MEM exc ee 60 LZ 40 Recovery 30 20 10 o 0 5 10 15 20 25 30 Time mins Points Meas d Line Calc d A a Eurus Mineral Consultants c IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 65 of 118 13 SUMMARY SHEET Functions available 1 Table summary of all test conditions descriptions and parameters 2 Table summary of test results head grade recovery grade mass pull 3 Table summary of flotation kinetics with and without boundary tests and ScrollCalc kinetics Table summary of kinetic ratios Table summary of linear correlation coefficients and sum of the squared errors Sorting of data on an individual or block basis Editing of Miscellaneous Parameters Dumping data to excel Loading data back into the Input Page or to ScrollCalc 10 Loading data into the Access or SQL Database O OND 01 p gt Diagrams highlighting various points detailed below can be found towards the end of this section The Summary Sheet is the heart of KinCalc It is a summary of all input data results calculated kinetics and kinetic ratios A view of the top 26 rows is shown below If more than 1 version of KinCalc has been opened by you and one of the versions is then closed the KinCalc toolbar will disappear Click here to restore the toolbar A B c L E F G H J K Click here to hidefunh
35. 9 MANUALINFUT OF TEST DAJUAO cscectivessviestockttet qae ieveteeetvo bue eviva sae ebevEvE du E esr dead ou ex vea snae in 47 IL MANEAEINPUT OR TEST LATA cucine ries 342002 OUR ISI QI EE TID SEE 47 9 2 MANUAL INPUT OF OTHER TEST PARAMETERS e eee ee eee eee eee nente eee e eene tette esent eee e ee 47 10 AUTOMATED IMPORTING OF TEST DATA eere ee eee eene no reete eoo reet eae o eee e eae n teet a eoa 49 10 1 SPECIFYING IF ASSAY DATA IS FORMATTED AS A SINGLE REGION 49 SPEED ire EVA dp c M 50 10 3 MAKING A NEW IMPORT FORMAT ONE DATA SET PER SHEET ee 50 10 4 MAKING A NEW IMPORT FORMAT MULTIPLE DATA SETS PER SHEET 53 10 5 MAKING A NEW IMPORT FORMAT FROM A KINCALC DATA SHEET 54 10 6 DEFINING AND SETTING UP OTHER PARAMETERS eee ecce esee eee eee eee eese osse eeoe 55 10 7 IMPORTING DATA SINGLE WIODE icissiccssaccseiestanesessaas seneceusaseesanasehestansvestaaeseneseuevess 55 10 8 IMPORTING DATA BATCH MODE ssccsssssscasccscseesdasvatanccceneesdunsesanesecsensdasseganccceueessusses 58 11 CALCULATING KINE esas sce res ceca ccvectven cance euancasvavenacabeetne seqeuntcssectneoatevasecubiacvecvacvauacen 60 11 1 AUTOMATIC CALCULATION OF KINETICS ssssssccscccccssssssssscscccccccccsssssssscesscsccsessss 60 11 2 MANUAL CALCULATION OF KINETICS VIA THE INP
36. 94 19 3 FILE LOCATIONS eiecitucoseessidienes SEE EENE h 94 19 4 LISER TN PERE GCE aE E E E EET E AT 94 EMGIMEXCBL UTILITI Sonen an R E EE 97 20 1 THE LOODA R ERS 97 20 2 THE TRANSPOSE FUNCTIONS eesesecscscscscscscscscscscseseseseseseseseseseseseseseseseseseseseseseoeoeseoeseo 99 20 3 THE CORRELATION MATRIX FUNCTION cccccsscscceccscccccccsccsceccsccsceccsccscssceccsccscecs 105 20 4 THE FREQUENCY PLOT FUNCTION 2 3552203593335 9 99539 19 Fo YUFUEPEES SES TERRE OS ePERRSE 9 Mer aso 111 20 5 CHANGE DEFAULT SETTINGS FOR EMCTM TOOLS eee e eee e eere e eene eren eo eooe 113 MEANING AND USE OF FLOTATION KINETICS eee eee eee ee eere ee e ccc ecc evens 116 21 1 USES OF THE FLOTATION KINETICS CALCULATOR ccccsscsscscceccscccccccsccscecceccscesees 116 21 2 A CASE STUDY IN WHAT FLOTATION KINETICS MEAN ccccccsccscsscscceccsccsceccecsscesees 116 Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 5 of 118 LIST OF TABLES Table 1 Simulated vs Actual Mass Balances 118 Table2 Flotation Kinetic Changes 118 LIST OF FIGURES Figure1 One Glance Layout of Program Functions in Mind Map Format 29 Figure 2 Flow Diagram of KinCalc s Main Functions eese eene nen ene 30 Figure3 Simplified Outline of KinCalc s Main Functions
37. Format Name Tests for YYZ Mine TextInstead of Include in Graph ME uum 1 Cell Range Headings 3 COMPANY P y _ 1 T 4 MATERIAL Normal lv Client Name Tommal Ro Rate amp 50 15853 H v 5 TEST Nos 2 E GRIND x 75um 50 Mine E iw 7 REAGENTS rougher gt COMPANY us Objective Rougher Rate Test MATERIAL Normal L Merensky TEST Moz Z GRIND 7 Zhum Matural B Sastroth 169 B Rougher Flotation time 25 mins Senkol 5 4 es Sa a 8 m 95 51 9551 y 14505 14505 j 23094 23094 3 a TT lt Rn E Rm 16 ea 630 a O 25 Ce 1m M amp NENNEN 93 A 3 9 NN IE IU A o JUN oo ket CUMMULATIVE CONC 459 we w 20898 J E75 2775247215 NENNEN NEN ee eee ee eee eee Hougher T ail M EE RES re POEM EE eee COMBINED TAIL 3531 aa fo 03 2 57 CALC HEAD saam don J V s J 48 1886 Meazured Head 4 00 660 1700 When all required data has been referenced click Save A box will appear asking you to confirm the number of analytes In the above example because the three analytes highlighted have a gap of one column between them the prompt asks if there are 6 analytes Input the actual number 3 and enter The new import format is now saved and can be used at a later date 10 4 Making a New Import Format Multiple Data Sets per Sheet This
38. MF1 RoRates ERROR5 xls BEGIN Sheet 13 Normal Ho Hate amp 707 Alias Detected Analyte PGIVT Au will be imported as PGMS Abbreviation Detected Analyte Cu will be imported as Copper Abbreviation Detected Analyte Mi will be imported as Mickel Import of data with no errors Mate Tails Assay Far Copper converted from git to 24V Successful import highlighted Mate Tails Assay for Nickel converted From git ro s in bold blue font Mate Conc Assay For Copper converted From git ta 724 Mate Conc Assay for Nickel converted from ait ra 7 SUCCESS importing Sheet Normal Ho Hate amp 70 EMD Sheet 173 Normal Fo Rate i 705 Import of data with errors conc BEGIN Sheet 2 3 Normal Ro Rate 80970 ERROR F tted T Alias Detected Analyte PGMs Au will be imported as Pills doc omitte mport can continue Abbreviation Detected Analyte Cu will be imported as Copper and completion is highlighted in Abbreviation Detected Analyte Mi will be imported as Mickel bold blue font Mate Tails Assay Far Copper converted Fram git to 724 Mate Tails Assay Far Mickel converted from git ro r Warning Conc Assay does not seem to be a nuyfiber or is missing sheet may not match your selected imp Mate Conc Assay Far Copper converted fram git ra a Mate Conc Assay for Mick
39. MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 94 of 118 19 2 Graph Series On this tab 12 lines can be customised with respect to line colour line type line weight marker style marker background colour and marker foreground colour Each choice has a drop down box Choice comprises e 56colours see the colour palette for line colour and marker background and foreground colours e 6 line types e Aline weights and e 11 marker styles KinCalc Application Configuration x Graph Settings Graph Series File Locations User Interface Seres Line sc Line puo Marker Marker Mo Colour Weight Back Colour Fore Colour 1 Caiano Thin d uerum markers d E E d Square markers Triangular markers Circular markers Us 4 Jl oi Continuous Y Continuous 4 jak D 4 Continuous Y Square markers with an X Square markers with an asterisk Diamond shaped markers Square markers 2 3 4 7 Continuous Y 5 6 joi a ij Continuous YT Contnucus Y Continuous YT E E E E E iii Continuous Square markers with an X Continuous Y Square markers with a plus sign Da Dash Thin Thin Square markers with an X Thin h Square markers with a plus sign Line and Marker colours may be viewed on the spreadsheet to the left of this form All available colour codes are listed in the palette below REHWR HM E 4 E
40. SINGLE row f 0 7039 0 8441 0 0089 containing the data vau want to transpose 9 05611 0 8317 0 0067 A EEUU MEME cen nien 00073 ust highliq e header row and then hold down A VEE the control key while highlighting Ehe row NEN v s of data vou wank Not highlighting the rows carefully will also lead to errors suchas Km eme name nono Domo Bo ose R ore EXCHEET 7 oe 0 0399 0 4216 _ m The two regions you selected don t Dos 04 A contain ria apie of columns 11244 0 0379 osen 00401 03 11244 0 0379 osen When transposing from columns to rows don t highlight any text next to the data Mass Gangue PGMs Fast Floatigg Fraction 0 0060 0 0060 0 6641 FasrFlaating Rate 12112 0 0750 0 8832 Slow Flaating Rate 0 0115 0 0122 0 0654 Warning AN IF seems that there is some text in Ehe lower 3 rows of the region you highlighted You must highlight a header row n Af Eurus Mineral Consultants c IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 105 of 118 Pass Gangue PGMs Fast Floating Fractiong 0 0060 0 0060 0 6641 Fast Floating Ratel 1 2112 0 0150 0 8932 Slow Floating Rate 0 0113 0 0122 0 0654 Warning JAN You must select the header row and the 3 data rows below it before clicking the C to R transpose icon Merged cells and hidden rows or columns any
41. as Thus if assays are in g t or ppm in Eurus Mineral Consultants R A c IVI C 2007 Copyright subsists in this work unus mied constans EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 37 of 118 the raw data sheet the values will be imported as Similarly if the units have been defined as g t or ppm then all g t ppm and data associated with that analyte will be imported as g t or ppm which ever one has been chosen 6 6 Changing Assay Units and Decimal Places on the Input Page Units may be changed on an individual data set basis i e locally for each data set when on the Input Page by ticking the change analyte units box This changes g t to and vice versa Also the number of decimal places may be toggled between 2 and 4 by selecting the appropriate box as shown below Note in the examples below that concentrate rows 6 19 have been hidden to reduce the size of the diagram Flotation Feed Concentrate amp Final Tails Times Masses and s Assays Clear Check Bos to temporarily omit analyte from the analysis gt Time Mass 3anque Fasz Copper Mickel gt E grams or 3 bu diff grt X Feed mE _ m GG NEUE EK 253040 J r aom oe Combined Cone 3180 pf Select Check Eos to change analyte units gt Click here to change decimal places from 2 to 4 or uice verza Pass 3anque Pis Copper T Sample grams ar 3 bu
42. drivers need to be installed on a computer on the network that has been earmarked to serve this purpose In all likelihood this computer will also host the KinCalc Database component If the KinCalc application has been provided as a standalone application then the HASP drivers will need to be installed on the local computer along with the rest of the KinCalc suite No HASP license manager software is required in this case A Network HASP Installation The computer chosen to host the HASP licence manager must be visible over the network to all users who will be installing the KinCalc Spreadsheet component The details of a network installation are described in the document entitled Installation of HASP Licence Manager for Network Installations pdf If you are performing a network installation open that document now and continue with the instructions contained therein Once you have completed the HASP installation return to this document and continue with section 2 6 below A Standalone H ASP Installation Do NOT insert the HASP key until the drivers are installed To install the HASP drivers for a standalone application locate and run the file called HASPUserSetup exe which is located in the HASP Drivers folder on the installation disc Follow the on screen prompts to complete the installation Now insert your HASP key and you should notice a Windows pop up notifying you that the new hardware has been successfully
43. ics better tha ics better tha ics better tha ar solids ara solids arm solids arm solids arm solids ics better than boundary ics better than boundary Eurus Mineral Consultants 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 25 of 118 4 INTRODUCTION TO THE FLOTATION KINETICS CALCULATOR 4 1 What are Flotation Kinetics A laboratory batch test or measurements down a bank of pilot and or plant cells generates a recovery grade and mass profile with time These profiles describe the flotation response or performance of the ore Kelsall s unmodified equation can be used to fit these profiles and this generates kinetic parameters of fast and slow floating fractions and rates The flotation kinetics are numerical descriptions of the ore s characteristics and are directly related to its mineralogy Kelsall s Unmodified Equation R 100 0 1 exp krt O 1 exp kst Where 0 slow floating fraction R per cent recovery at time t kr fast floating rate constant min ks slow floating rate constant min t time min Example of how Kinetics varies with Flotation Performance The value of each kinetic parameter is a measure of how well or badly metal mineral or gangue is recovered The two graphs below provide an example of metal and concentrate mass recovery for ores of varying quality and shows how each kinetic parameter varies with flotation
44. is when a worksheet contains a number of test data sets This occurs when the original format has been copied successively below as per the picture below where the original format has been copied 7 cells down and then repeated In this case the Multiple Data Sets per Sheet should be ticked in the Data Sets per Sheet box In the Offset between Data Sets box put the number of rows or columns that is between each data set In the example below it is 7 rows Don t Offset Assay Names and Unit Headings has been ticked because the assay name and unit occurs only once as a heading in rows 1 and 2 and is not repeated with each new data set Eurus Mineral Consultants c Wi C 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 54 of 118 In git Dry Mass SAMPLE AE PGM CONC A 1 CONC E i lt CONC C j 1 Data sets offset MER ROUGHER FEED TEST 2 0ghdepe by 7 rows C 22 MER ROUGHER FEED TEST 1 2 amp git depr 1 1 30 669 419115 A EU Edit an Existing Import Format Folder ALX2 EMC FLOTATION EINCALCY Demonstratior gt Required Item Filename IMP Hot Floats Site Tests per Sheet xls Format Name Impala Multiple sets per Whook Text Instead of Include in Graph Data Sets Per Sheet Cell Range Headings W Client Mame Impala Int w One Data Set per Sheet Mine Multiple Data
45. may be another drive and this new location can be specified via the dialog box below Manage Settings Analytes Correlation Frequency Plot Toolbar Location of Toolbar Images DA MESS Euras Images Eurus Mineral Consultants A A IVI C O 2007 Copyright subsists in this work unus mineral consultants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 116 of 118 21 MEANING AND USE OF FLOTATION KINETICS 21 1 Uses of the Flotation Kinetics Calculator The uses of Kincalc are many and varied and it is perhaps only limited by ones ingenuity Laboratory and Pilot Plant Characterisation of ores benchmarking one ore against another Establishing a base line for feed ore i e a regular float test to generate kinetics which over time can pin point whether the ore has changed Use of the above data to correlate with overall plant performance Characterisation of development samples from underground or open pit to anticipate the effect in a change in ore quality Measuring the effect of an operating parameter o Grind Reagent type and addition Pulp density Air rate and oxygen content Impeller speed pH and Eh Water quality o Oil and other contaminants A means to screen reagents and determine which should be tested on plant Estimating kinetics from down the bank samples from a pilot plant Generation of kinetics for simulation of plant circuits O O O O O O Main Plant The most common
46. of analyte metal or mineral to gangue as the slow floating ratio or selectivity will vary When using these kinetic ratios to benchmark one ore against another make sure that you are comparing systems which have been defined in the same way Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 41 of 118 Rougher feed est 40 mins elements Cleaner feed elements Rate test 40min giving 53 6 mass Rate test 21min giving 88 3 mass G Fast Fraction 0 2502 0 0139 TIME Fast Rate 0 2125 0 9581 Rec of Rec of Gangue Gangue Rec of Rec of Gangue Gangue Fast Rate 0 4332 0 4043 0 4610 Slow Rate 0 0298 0 0218 0 0883 9 0 G G Fast Fraction 0 2502 02624 angue Fast Fraction 0 7851 07817 CBS Fast Rate 0 2125 0 1495 2 Fast Rate 0 4332 0 4166 2 Slow Rate 0 0127 0 0110 Slow Rate 0 0298 0 0279 Vo Rec of Vo Rec of Fast Fraction 0 2502 j Fast Fraction 0 7851 0 7134 Gangue Fast Rate 0 2125 H Fast Rate 0 4332 0 4286 82 1 Slow Rate 0 0127 0 0118 2 Slow Rate 0 0298 0 0228 Vo Rec of Vo Rec of Fast Fraction 0 2502 0 3275 Fast Fraction 0 7851 0 8060 0 5391 Gangue Fast Rate 0 2125 0
47. of the main KinCalc M toolbar Clicking this icon shows the Application Configuration Table as per below The table is positioned so that two colour palettes can be seen to the left of and below the table 19 1 Graph Settings In this tab the user can select font type size bold or not marker size legend position relative to the graph and background colours of the chart area and the plot area The picture shows that the chart area the area surrounding the plot area is set to colour number 2 white and the plot area to colour No 19 Ivory as per the bottom palette When the Choose Graph Title Content button is clicked a box is shown where the user can select the content of the title of the graph from Client Name Mine Name Ore Type Plant Name Test Description and Test Date There are a total of 56 colours to choose from Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 93 of 118 c RI eb T X Bag k Antiqua 9 HB J U E l 3 lt Ed T gt E Se ES e Text Font Settings 117 fe Series Colour Sc TypeFace Book Antiqua Graph SerieslColour Scheme Visualisation Marker lam li w Oh 7 Colour KinCalc Application Configuration Graph Settings Graph Series File Locations User Interface zl Lis Top m 25 Chart and Plot Area colours may be viewed on the spreadsh
48. processed any import errors can be quickly identified by scrolling down the workbook of Import Notes and looking for the colour red The KinCalc Import Wizard Report records e The number of files and worksheets processed e The number of worksheets successfully imported e The time taken in hours minutes and seconds e Aliases and abbreviations are noted and e Assay unit conversions g t to and vice versa are noted Note what causes an import failure e One analyte assay omitted does not cause failure e Ananalyte name that is not recognised causes failure and e Failure occurs if data has been moved by x rows or columns relative to the import format specified Eurus Mineral Consultants 2007 Copyright subsists in this work Hs n n A IVI P ha rus EHUNUS Minaa CONS im EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 The best use of the Data Import Wizard and the Auto Report is for screening a large number of files and or worksheets A lot of time can be wasted in manually looking at a large number of files and data sheets to determine what excel data format they have been set up and whether any of the import formats stored in the Import Wizard are suitable With both the Calculate Kinetics and Copy to Summary Sheet commands off i e not ticked 245 data worksheets can be processed in 1 minute and 22 seconds The resulting workbook list runs to 2 993 lines It takes a few seconds to scr
49. t 20 25 30 35 40 45 gi Gaagwe Recorery X Fointr 1c ar d Linz Calz 4 Fnuinkr Me ar d Line Calz 4 Time min Grade L Recovery L Ca Grade T Ca Recorerg t Ca Recorerg t 3 4 6 4 0 5 0 5 5 5 Ti Grade t int min Fninkr Mear d Line Calz 4 el 1 Pointe Me ar d Linz Gal 4 Reset Active Data Set Lab Copper Em ICuF 4 IGF i kCuF pue kGF p kCuS a E g kGS H l Ends Recovery Conga Toa s om o ea am Gaagee Recorerp t Ca Recorerp t 3 4 5 5 T Gaagee Recorerp t Fninkr Mo ar J Line Calz 4 Pointe Me ar Jd Linz Gals d Time mins Eurus Mineral Consultants IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 83 of 118 ScrollCalc screen for Test 22 Original Kinetic Values Fieset Active Data Set Lab Nickel H Reset INiF 4 l IGF 3 wp ij 4 owe aor 4 I kNiS 4 l kGs RE 052 _ _252_ 094 _ _347__ o HERO d sz Bu Hi Recovery X 50 Gangue Recovery X 3 4 Time mins Points WMeas d Line Caled Reset IGF 4 B r Refresh kCuF kGF 4 F EI H Graphs l i kCus T kos l nu SSE ooo Qvi mes 11 37 Click Buttons to 100 35 nd E an o BEBE Fa E e 70 m a B5 En 3 4 15 20 25 30 35 at Ti i G R x une Leman
50. use of Kincalc at plant level is as a means of characterising different streams and determining the efficiency of individual cells banks or sections of the plant Characterisation of streams Characterisation of samples taken from the tails of each cell in a bank of cells to determine floatability after each cell a detailed kinetic profile and to use these data to compare estimated and actual residence time Reagent and or grind tests on the above samples to determine the effect of stage addition of reagent and at what point regrinding becomes effective or remains ineffective Determining whether streams have similar kinetic properties and should should not be mixed and the result if they are mixed Analysing the efficiency of cells banks or sections of the plant Estimating kinetics from down the bank samples 21 2 A Case Study in what Flotation Kinetics mean This example is taken from Using the SUPASIM flotation model to diagnose and understand flotation behaviour from laboratory through to plant M P Hay Eurus Mineral Consultants Minerals Engineering 18 2005 762 771 and describes how laboratory scale testwork can be used to improve the performance of a flotation circuit The plant in question is a PGM operation treating UG2 ore on the Western Limb of the Bushveld Igneous Complex in South Africa The circuit is shown in Figure 5 and consists of a bank of roughers with three stages of cleaning and two stages of cleaner scaven
51. 07 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 72 of 118 13 7 Selectivity A global measure of how one analyte floats relative to another or to floatable gangue For Copper relative to gangue selectivity is defined by ICuF kCuF kCuS IGF KGF KGS It is the combination of fast floating fraction fast floating rate and slow floating rate of an analyte relative to gangue or another analyte see section 4 2 13 8 Measured Recoveries and Concentrate Grades These tables summarise the actual recoveries and concentrate grades of the tests being analysed 13 9 Calculated Head Grades A summary of the head grades calculated from actual mass and assay from each test 13 10 Floatability A measure of how well or poorly mass gangue or an analyte floats For Copper floatability is described by ICuF kCuS 1000 It is the combination of fast floating fraction and slow floating rate as these two parameters account for the largest influence in flotation performance see section 4 2 14 DATA SHEET Functions available 1 Stores data in a form suitable for transfer to the Access or SQL Database and the other users of KinCalc gt Diagrams highlighting various points detailed below can be found towards the end of this section The Data Sheet is accessed by the icon This sheet is solely for the purpose of storing test and processed data in preparation for loading int
52. 1 Note Cells shaded green are equal to the category minima and cells shaded red are equal to the category maxima predicted less actual values Sum of Square Errors SSE 0 01 0 00 0 79 1 15 1 83 Correlation Coeff R for Measured Data 0 9195 0 9200 0 6463 0 7356 0 7611 pog mec E Measure of linearity both visually and the correlation coefficient Fast floating fraction I 0 1013 0 1004 0 8862 0 8283 0 5708 0 0000 12 Fast floating rate kF 0 3884 0 3797 1 9096 2 1188 1 5657 0 0000 Slow floating rate kS 0 0026 0 0026 0 0469 0 0307 0 0112 0 0000 Note Cells shaded green are equal to the category minima and cells shaded red are equal to the category maxima Double click to select or Sum of Square Errors SSE 0 01 0 00 0 79 1 15 1 83 Test deselect boundary tests Enabled Boundary Test Settings Linear Flag Y FALSE FALSE FALSE FALSE FALSE kF value kS value Y FALSE FALSE FALSE FALSE FALSE _ Low I for Metals Y FALSE FALSE FALSE FALSE FALSE _ High I and Low KS for metals Y FALSE FALSE FALSE FALSE FALSE Linear amp Low I for metals Y FALSE FALSE FALSE FALSE FALSE Low kS amp V High I for Gangue Y FALSE FALSE FALSE FALSE FALSE _ Max kF for Metal Y FALSE FALSE FALSE FALSE FALSE Cumulative Recovery vs Time Mass ll Gangue A PGMs 9 Copper X Nickel 100 90 80
53. 533 38 3 0 0022T 0 00224 0 03313 34 4 Rougher Rate Test on Secondary Rougher Feed Sample 03 01 06 0 000005 E 0 00005 2 0 01600 40 5 Rieugher Pate Test on Crusher Circuit Fines Thickener OFF Q6 01706 0 00056 0 00056 0 00250 4 5 Rougher Rate Test on Crusher Circuit Fines Thickener OFF Q701 06 0 00056 i 00056 0 00250 42 T Rougher Rate Test on Primary Rougher Tail Sample 02401706 0 00010 0 00010 i 0 01434 43 a Rougher Rate Test on Secondary Roug il l rdi iE f 3 0 000005 g l 00005 p 3 O 00T41 all Alternatively a preferred order can be entered into the Sort Index column and the Or functions used to obtain the desired order of data Eurus Mineral Consultants C IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 70 of 118 13 2 Misc Parameters This table has the following headings as standard Heading Input by Index KinCalc Number of row Does not change if test data is sorted into a different order Client Name of client organisation Mine User Name of mine operation Plant User Name of plant and or section of plant Test Description Brief description of test objective purpose Test Date Date of test User Name of stream Compulsory input otherwise data will not be loaded to the Access or SQL database Global ID Reference number assigned by KinCalc Test ID Reference number or cod
54. 7 Page 74 of 118 S Mise Parameters 3 Kame faniseion 10 UG 2 Riougher Rate Test on Secondary Rougher Conc Sample 05101706 11 Ave of A bests T 8 Sand 10 12 i Ave of 4 tests 11 12 T3and 14 13 RioMareea Aqua Blanca Gold RM Plant Rougher Rate Test on Secondary Rougher Feed Sample nnne i SAF Test 3 BREE Tests 14 GFZA Merensky GF Flant Riougher Rate Test on Crusher Circuit Fines Thickener OF Q6 01706 i CED Test H BRPM Tests 15 GFZA Merensky GF Plant Rougher Rate Test on Crusher Circuit Fines Thickener OIF Q6 01706 i COCO Test H BRPM Tests 16 BRP Merensky ERPIM Plant Rougher Rate Test on Primary Rougher Tail Sample 02701706 i PRT Test 2 BRPM Tests 17 i Merensky Min Pro Rougher Fate Test on Secondary Rougher Tail Sample 04 01 06 i SAT Test 4 ERPM Tests 18 Mormal Riougher Rate Test 50 T5um i i Normal Fio 13 Mormal Rougher Rate Test i 60 T5um i i Mormal Ro 20 Mormal Riougher Rate Test TOX T5um i i Mormal Ro z Mormal Rougher Rate Test 80 T5um i i Mermal Ro 22 Mechanised Riougher Rate Test 50 T5um i i Mechanised 23 Mechanized Rougher Rate Test 60 T5um i i Mechanised 24 Mechanised Riougher Rate Test TOX T5um i i Mechanised 25 Mechanized Rougher Rate Test 80 T5um i i Mechanised 2b Blend Riougher Rate Test 60 T5um i i Blend Ro A 27 Mormal Rougher Rate Test i 60 T5um i i Mormal De 28 Mormal Riougher Rate Test 60 T5um i i Normal Dic 24 Mechanized
55. Access or SOL installed then the database must be opened from any other computer with MS Access or SOL that has access to the database folder which must be shared as described below The folder where the database was installed must now be shared so that other network users can connect to it To create the share using Windows Explorer locate the folder where the database was installed In the example below the default install folder was used so the database files Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 10 of 118 reside in c Program Files KinCalc The following screen images and procedures may depend on the operating system installed on the central computer The procedure may differ on a computer with Windows Server 2003 The example below was generated under Windows XP Locate the database install folder and then right click it and choose Sharing and Security Folders File Edit View a con E McAl C Mes E j Mier E 3 Micri E micri E j Mic E C Mic E 3 Micri E Mic E j Mier L 19 objects Disk free spa Gi C Program Files KinCalc Favorites Tools Help Back r d d z Search E Folders Address C Program FilesVanCalc Collapse Explore Open Browse with ACDSee Catalog with cdTree Search Enqueue in Winamp Play in Winamp
56. Conc Mass vs Time Customised Graphing Facility GENERATION OF GRAPHS N EURUS MINERAL CONSULTANTS User Manual for KinCalc Automatic Import Calculation and Generation of Summary Sheet KIN CALC v2 1 July 2007 Page 29 of 118 Kinetics of metal mineral Kinetics of floatable gangue MANUAL IMPORT OF Kinetics of entrained material ACCESS DATABASE T KinCalc Kinetics Calculator Standard Graphs Test information Miscellaneous parameters Analyte names and units Conc times and masses N Data Sheet Analytes selected and category IDs Feed Tails and Conc assays Parameter order indices Test Descriptions Kinetics with without Boundary Tests ScrollCalc Kinetics Linear Flag Mass Time Curve DATA OUTPUT Sum of the squared errors Slow Floating Ratio i Summary Sheet Kinetic Ratios Selectivity Kinetic Measure of Metal Mineral and Gangue Floatability Recoveries Concentrate Grades Test Data Summa Head Grades Calculates average for a set of data Average Vage Test Data Summa Kinetics with without Boundary Single A4 page Tests Results Page Recovery Time Graph Font Type Markers 12 options Y Graphs CUSTOMISATION OF PROGRAM FORMATS Lines 12 options Size and Dimension Ratio Background and foreground colours Font General Program Figure 1 DATA With without boundary tests Single data set
57. Confirm solver reference 6 Uninstall gt Diagrams highlighting various points detailed below can be found towards the end of this section 2 1 Introduction The KinCalc system consists of several components The KinCalc Spreadsheet The KinCalc Database The EMC Excel Utilities The Aladdin HASP Software Protection System Supporting documentation including the user manual This document provides instructions to guide a user through the steps required to install the above components 2 2 Pre Requisites The KinCalc suite was written using the Microsoft Office 2002 programs of MS Excel and MS Access and SQL Although standard MS Office components were used the KinCalc suite is not guaranteed to work with earlier versions of MS Office Before installing and using KinCalc the end user computer should meet the following requirements MS Office 2002 Professional must be installed The Solver component of MS Excel must be installed The user must have administrative privileges on the computer where the KinCalc component is being installed There must be approximately 12 Mb of free space on the destination drive Acrobat Reader version 5 or greater is required to read the installation and user manual documents Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 8 of 118 2 3 Installation
58. ELLOW BEAVER DRIFT Ore Type Merensky Flant OLO JOE 1 Test Description Ra Rate Float Feed Stream Marne P RF Test Date 158703705 Test Variation Sample taken after tropical rainstorm Analyte Mames PGMs Copper Mickel Units e 1 000 000 100 100 Pletal or Plineral Flotation Feed Concentrate amp Final Tails I Masses and Assays Clear Check Bos to temporarily omit analyte from the analysis v L1 Time Pass 3anque Pis Copper i Sample min grams or 5 bu diff git X Fa l amm rr Tals 28 40 067 Q3 00824 combinen gt se y o o S ML Cone 1 1 15 21 353 34 TA5376 6 7292 Conc 2 3 14 03 133 80 1 1323 42220 Conc 3 10 eb 58 55 09 0 4768 2 3537 Conc 4 2h 35 82 16 84 0 2057 0 5157 Conc 5 eges se a 209 254 d E 722 E24 624 7224 OESTE re Pa ES ee ex 22 Flotation Feed Concentrate amp Final Tails po Masses and Assays Clear Check Box to temporarily omit analyte from the analysis be O O O O 25 Mass pon Pes Nickel 26 Sees __ le E 9 L 55 27 EFE 28 i 7 E 30 31 Available 32 A3477 g t 34 Air Rate l min Collector Dosage a t 49 eS i __ CuS04 ojt d Select Check Box to change analyte u Depressant Dosage gj 51 Depth m 52 Click here to change decimal places from 2 to 4 or vice Dow 200 g t a FF300 a t Grind lt 75 um Other Test Parameters KU 20 o t
59. EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 1 of 118 ary 18 7 0 A E ia E UR a t Aon L Net PF 3 Bin ul 1 1 d be St petet NE B rota E ew Paid D E ly VOY WLAN AYE ig f a Fr F is j a ae n j euo ont eurus mineral consultants Flotation Kinetics Calculator Incorporating eKinCalc eScrollCalc e Tabulation of data eGraphing facility e Statistical functions e Access or SOL Database EVI eurus mineral consultants USER MANUAL C VI A 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 2 of 118 CONTENTS COPYRIGHT AND DISCLAIMER 55inteseeseeiseestexes odes euv va ve Tu eo usq ToS Te YEExUR ERU eS So SEXE o E dave s PEG Ee aue Ro 6 2 SYSTEM REQUIREMENTS AND INSTALLING KINCALGQCIM ooo eee eee eee enero 7 24 INTRODUCTION cc 7 22 d ud LOL BITE NU rr r H 7 2 3 INSTALLA TON esmis E iui edd INI ENE 8 24 DOCUMENTATION mc M 8 2 5 THE HASPFDRIV ER S 2codisim niii danas cedeseaasiccecsues see EDD IINE PHENTERMINE i EIE 8 2 6 THE KINCALC SPREADSHEET 52 pretii nieto diario E PFONN ESTIS aai andare nai 9 2 7 THIPIAXINCALCTT3JATADASDBaasesidiie nsri nereiesie rr I EWVEL NEU riSPEU OE EU EHFEX INTO EI TI ETIEE 9 2 7 1 SHARED DATABASE ON A NETWORK ee eee eee eere eene en reete eee reete eese etae
60. IV L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 98 of 118 Loading the Add In Within Excel Once the add in has been installed as described above it is available for loading within the Excel environment For the first time only it is required that from the start menu you choose Activate EMC Excel Utilities we Uninstall EMC Excel Utilities EH Activate EMC Excel Utilities BE Deactivate EMC Excel Utilities Similarly to de activate it select the Deactivate option shown above To uninstall the add in choose the uninstall menu item shown above Be aware that uninstalling will remove the files from your computer so any customised items within the files will be lost Once the add in has been loaded as described above it may be activated and de activated easily from within the Excel environment by choosing Tools Add Ins from the main Excel menu E Microsoft Excel Baok1 File Edit View X Insert Format Data Window Help O G 6 j A HB ay E Protection eee omes uskamize Options Clean Project hal t In the following dialog box select the EMC Excel Utilities Add In item from the available list by turning on the check mark and then click OK CRAC Eurus Mineral Consultants w IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 Ju
61. P m T 72 AVERAGE SHEET iw 73 eO NEAq iBelcm c M 74 16 1 _ LOADING DATAINTO SCROLLC ALC 9 eeseceebesteus o esee EEE E OSEERE 6506065 74 16 2 _ USING TIHESCRODLDGCALC M PAGE 6 sacsccecscsssnesccsesssasnncsncennnstetunsssnncseersscassuncsvessansacaverss 75 16 3 CLEARING AND TRANSFERRING DATA TO THE SUMMARY SHEET e 76 16 4 IDENTIFYING SUSPECT KINETIC VALUES eee eee eee esee e eee o ossa asset eee e eese e eee eee 77 16 5 METHOD FOR DETERMINING KINETIC VALUES MANUALLY cccecccccccccoooooococccoes 78 16 6 GUIDELINES FOR KINETIC VALUT Sisseneri eue eR IR SUE p RERR E PES NN e PE PP PET voe poEER I OU e Ee ERE Pas oePEU 83 ACCESSUR SOL DATABASE aiciuseuseissasin inte ead oU dE vi Ieieivr d Eu rae th II rd n I ME 89 17 1 POSTING DATA TO THE ACCESS OR SOL DATABASE cccssscosssscccesscccsssccccesscccesees 89 17 2 IMPORTING DATA FROM THE ACCESS OR SQL DATABASE INTO THE SUMMARY 5 D 5 MT RR e 89 GRAPHING FACILITY peace csceece ccc nach E 91 18 1 USING THE CUSTOM GRAPHS 6 sess ccdscdescdcevsseccedscssntesvaseacedsesnsdesweseedeisessedesecsvedeswescedesust 91 CUSTOMISING THE GRAPHING FACILITY amp PROGRAM SETTINGS 92 19 1 GRAPH SETEINCG S RR E 92 19 2 GRAPH SERIE n ENNET OE EAEE A ETENE
62. Rougher Rate Test 60 T5um i i Mechanised 30 Mechanised Riougher Rate Test 60 T5um i i Mechanised M i i Aye af 4 bests 13 14 Sand 16 ay 16 SCROLLCALC Functions available 1 Data loaded from the Summary Sheet 2 Manual estimation of flotation kinetics by matching measured and calculated recovery erade and mass Variation of estimated flotation kinetics via a scrollbar facility for each parameter 4 Comparison of three data sets at one time in the categories of Laboratory Pilot Plant and Plant 5 Loading of ScrollCalc kinetics back to the Summary Sheet p gt Diagrams highlighting various points detailed below can be found towards the end of this section ScrollCalc is used to manually estimate flotation kinetics If for example plant measurements produced only three data points for a down the bank survey these data will not be enough to calculate flotation kinetics to the required degree of accuracy using the Import Wizard and or the automated processing mode as per sections 11 1 and 11 2 In cases such as this flotation kinetics are estimated visually by adjusting the value of each Kinetic parameter via a scrollbar and matching the calculated recovery grade and mass profiles with time against the actual data M To go to the ScrollCalc page click the icon 16 1 Loading data into ScrollCalc Data is loaded into ScrollCalc from the Summary Sheet on an individual basis Select the data by
63. S MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 114 of 118 Correlation Here default settings for the title positioned above the Correlation Matrix and the worksheet name can be specified Manage Settings Analytes Correlation Frequency Plot Toolbar Default Matrix Heading Correlation Matrix Default Sheet Name Corr Matix lw Convert Average Calculations to Values Ticking the box Convert Average Calculations to Values includes the side table of Average Between Fractions If the box is not ticked the side table of averages is excluded FIND XV f AVERAGE SISS SLS10 AVERAGE number1 number2 H J K L M N 5 P Correlation Matrix Average Between Fractions 1 2 3 Xr xs F kGF kes ice kcer kces wr KNIF EMIS Mac Macu mami s war 00022 0 8887 0 9804 00033 0 8827 0 3931 00073 ooze 0 6758 00924 0 6276 6 ooo 00094 0 9990 00004 02331 0 9808 00991 02409 00595 0 3933 7 0 3652 ooo 0 9957 0 2601 00219 00046 0 7607 coso 05752 cecu cam oon 0 8546 0 3539 0002 00262 f 0 6196 00977 95639 3 GF oom 02260 0 9769 00999 oz oom 0 4035 n kes 0 2561 onm ome 97571 05722 C cuam 02986 02241 0 4664 00004 00190 ons 0 3626 001469 0 2684 amer unm Mo of Data Points 10 Frequency Plot Default settings for the Freq
64. Sets per Sheet Iv Ore Type Offset between data sets Rows Or If Test Description SAJ C Columns Plant Mame Don t offset Assay Name Test Date m and Unit Headings v Assay Names Assay Units merged with Assay Names Iw Assay Units Feed Mass Feed Assays w Tails Mass Iv Tails Assays I Conc Times Camel Iv Conc Masses In Columns per Assay v Conc Assays E mm Each column is a single region In Rows per Assay ge ME When clicking Save you may receive a host of message boxes indicating errors have been detected in your format definition Some of the latter messages may be as a result of some of the earlier ones Make a note of the first few messages and attend to those errors and the dependant error messages should disappear 10 5 Making a New Import Format from a KinCalc Data Sheet The data layout in a KinCalc datasheet is specific to the purposes of data storage for the KinCalc database Examples of data layout are given above An example of an import format m n Af Eurus Mineral Consultants C IVI L 2007 Copyright subsists in this work r oe unus mied constans EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 55 of 118 for a KinCalc database is shown below Note that Multiple Data Sets per Sheet is checked the Offset between Data Sets is 16 rows and Each Column is a Single Region is unchecked Edit an Existing Impo
65. TNT SIMI I PRIM 33 6 DEFINING ANALYTES MINERALS AND FLOATABLE GANGQGUFE 35 6 1 MANAGING ANALYTES AND MINERALS eeeeeee eese eese esee eese sse t tette eee sesso sete eese eese e ee sa nus 35 6 2 ORDERING ANALYTES AND SAVING ANALYTE SETS ee eee eee eee eee ee eee etes eene onuus 35 6 35 ANALYTE ALIAS ES accaseeedusontscenieesuteo qi erare esi codo eadein e EU ERI THI E ET DIT UN ERI UE 35 6 4 SETTING YOUR OWN SYMBOL OR ACRONYM FOR A STANDARD ASSAY UNIT 36 6 5 CHANGING ASSAY UNITS FOR THE KINCALC PROGRAM eere eterna 36 6 6 CHANGING ASSAY UNITS AND DECIMAL PLACES ON THE INPUT PAGE 37 Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 3 of 118 6 7 DETERMINING THE CATEGORY OF AN ANALYTE ccccccccccooooooccooc00000000000000000000000000000000000 39 7 DEFINING STREAM NAMES testet ies ern va VENE ETARU EVA TEES UR UERU FE CUu EMB CRSUIG NN EHE TE CHA EE EE eec UTE e eH PARET eUE 42 DEFINING OTHER TEST PARAMETERS eere eene eene eren treten nette ee ete e ee eee e ee naoo 43 8 1 MANAGING OTHER TEST PARAMETERS cccccccccococccccccc0oooooooo00000000000000000000000000000000000000000 43 8 2 INSERTING A COLUMN AT A LATER STAGE AFTER FLOTATION KINETICS HAVE BEEN CALCULA FED M reda 45
66. ULTANTS User Manual for KinCalc v2 1 July 2007 Page 85 of 118 Rougher Rate Test PGM Kinetics Ro Conc Recovery Cusen Clust2 Clust3 Clusta Rougher Rate Test Copper Kinetics lusti Clust2 Clust 3 Ro Conc Recovery IVI C 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 86 of 118 Rougher Rate Test Nickel Kinetics Gust Clust2 Clust a o gt e Q Q aZ Q S Q o aZ lt Rougher Rate Test Cobalt Kinetics Ro Conc Recovery ICoF 0 1000 0 5469 0 6500 0 8103 IVI C 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 87 of 118 Rougher Rate Test Fe Kinetics Cluster Clust2 Clust3 Clust4 Chust 0 00102 0 00198 0 02159 0 03108 m iT gt o D D fa Y S Q a lt Rougher Rate Test Sulphur Kinetics Cusen Glust2 Clust3 Clases Ro Conc Recovery c IVI C O 2007 Copyright subsists in this work eurus mineral consultants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 88 of 118 Rate Test Cr2O3 Kinetics Cluster 1 B Cluster 2 A Cluster 3 t Cluster 4 p Cluster 5 Cluster 6 O Cluster 7 Cluster 8 Cluster 9 i T Time at which Fast Floating Fraction is recovered
67. UT PAGE ee eene eene 60 11 3 MANUAL CALCULATION OF KINETICS VIA SCROLLCALCIM LLL eeeeee eee ee eene 61 12 RESDLESSHEBE 22 iode tii m E Hn Tr cU IER I DIE 62 IZIDOUNDARY TEST SETTINCS cascap edito apri issons ressu CNET ES 0x0 E NENE EENE SUA Ee ORDRE 096066 Gide 62 13 SUMMARY SHEET or cence 65 13 1 FUNCTIONS AVAILABLE TO PROCESS AND ARRANGE DATA eee ee eee eene nnn 66 132 MISC PARAMETERS airosa oE E E E 70 13 3 KELSALL PARAMETERS AFTER BOUNDARY TESTS AND AFTER SCROLLCALC 71 13 4 LINEAR CORRELATION COEFFICIENTS eee eeeeeeee eese estes esos oss tete eee e eese ess eee eeoe 71 13 5 SUM OF SQUARED ERRORS BASED ON BOUNDARY TEST PARAMETERS 71 13 0 SLOWFLOATING RATIO ec cusseqnte secte eub vi tanesi nenei N ETEEN endi r ivit ee abi EU EHE N Ore ER ANN PE IE 71 13 72 ENG CTIY 10 ROT T E EE E 72 oR AS Eurus Mineral Consultants CIVIL 2007 Copyright subsists in this work 14 15 16 17 18 19 20 2l EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 4 of 118 13 8 MEASURED RECOVERIES AND CONCENTRATE GRADES e eee ee esee eee seen ee etoe 72 13 9 CALCULATED HEAD GRADES iccers cessiacecesecanssnncoosssannevsuvescenesesecenssenswocsveassensuvesesaeceseeess 72 13 10 TFT OATB Y c c M M 72 DATA E
68. a automatically in single file or multi file batch mode and as single or multiple data sets per worksheet Calculates flotation kinetics automatically KinCalc function as well as manually ScrollCalc function The KinCalc function calculates kinetics with and without boundary test protocols Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 28 of 118 8 Provides a graphing facility to display and compare test and or plant data via five standard graphs which are automatically generated or any desired plot can be generated by use of the customised graphing function 9 Summarises raw data kinetics and other parameters such as kinetic ratios on a results page for individual tests or as a summary worksheet with a capacity of at least 200 tests that can be processed at any one time The theoretical limit is set by the total rows available in excel 65 000 which means that some 4 500 tests could be processed at one go However for practical reasons this limit has not tested but you are welcome to try 10 Generates a data sheet for a set of data that has been processed in a KinCalc M file 11 Loads all data into an Access or SOL database to facilitate querying and analysis of data Any information from Access or SQL can be re imported into either KinCalc or ScrollCalc 12 Allows customisation of the program and graphing fac
69. ade by clicking on Add New which shows Define a New Import Format The button Choose File enables you to select the file and the worksheet which contains the raw test data When the file is chosen it opens behind the Define a New Import Format table Go to the desired worksheet and open it The dialog box below shows that file IMP Mer2005 Lfield MF1 Ro Rates has been chosen and that worksheet Normal Ro rate 50 has been opened Give the new format a name in the Format Name box There are a number of functions which are annotated and explained in the picture below Eurus Mineral Consultants civic 2007 Copyright subsists in this work SHUNUS Mineral cx EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 51 of 118 Tick box to make Tick to input text rather Tick to include text in active than a cell range graph heading Click button to define cell range on open worksheet EJ Microsoft Excel IMP Mr 2005 Lfield MF1 RoRates Ele Edit View Insert format Mi un X NI TATE ane D cp Ed ie 6a d B Book Antiqua 9 mn x XIE v Folder C Demonstration of I MN Filename IMP Mer2005 Lfield MF1 RoR es xls gt Requirgd Item Ei Text Instead of Include in Graph A No Format Name Data Sets Per Sheet A B Cell Range Headings a Client Name 2 iv One Data Set per Sheet 3 COMPANY 2 r at m v as 4 MATERIAL N
70. ael converted From ait ta x SUCCESS importing Sheet Normal Ro Rate 80 ERROR END Sheet 2 3 Normal Ro Rate amp 80 ERROR BEGIN Sheet 3 3 Mechanised Ro Rate 80 ERROR wert ERROR Either the Analyte or Unit in PGF has not been defined If both an analyte name and unit appear to Abbreviation Detected Analyte Cu will be imported as Copper Abbreviation Detected Analyte Mi will be imported as Mickael wert ERROR No Analytes were identified check if the units merged into cells with analyte names have been defir FAILURE importing Sheet Mechanised Ro Rate 50 ERROR END Sheet 3 3 Mechanised Ro Rate t 8095 ERROR j j Import of data with an errors which Single file processing completed on 20 03 06 at 13 37 01 results in import failure analyte name of PGF not recognized Error and import failure is highlighted in bold red font Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 60 of 118 11 CALCULATING KINETICS Functions available 1 Automated calculation as one of the functions of the Import Wizard 2 Manual calculation via the Results Sheet 3 Facility to omit analytes from the kinetics calculation process Once data has been loaded into the Input Page flotation kinetics may be calculated either automatically or manually gt Diagrams highl
71. ally selected which are noted in the Source Data section of the Define the Frequency Plot box In this section the minimum and maximum values are also noted and the number of decimal places can be set In the Output Options section the file where the frequency plot will be placed can be chosen between Last Used File Same File as Source Data and New File J K L M M Define the Frequency Plot Eg Source Data Source Data Min Value Max Value 0 1 4 sh O 00028 0 1371 0 1977 d 00012 0 9356 0 00382 0 0343 1 3452 0 00379 0 9082 0 00028 0 1371 0 1977 0 00012 0 9356 Last Used File k TS Same File as Source Data New File 0 00382 0 00321 0 00028 0 00013 5 z 0 00416 n 00230 Frequency Plot Bin Options 0 00620 0 00554 Defined Increment Ca Defined Mumber of Bins 0 00460 0 00436 iain uu Start Value 0 0001 Finish Value 0 1371 Calculate 0 00382 0 00373 D 0 00028 O 0001 t o 0 00382 Q 00 373 Mo of Bins 50 n ag z28 0 00017 Heading text to use Individual and Cumulative Frequency Data KMS Plots to display v Individual I Cumulative Include Trendline la Histogram Line Chart Click Calculate Increment to proceed she amp iimmanmr Gcrall d In the Frequency Bin Plot Options section the user can define either the increment or define the number of bins In the example below the Defined Number of Bins has been selected and the default number of bins chosen 50 If the De
72. been made or an existing one has been chosen click Next and choose a file which contains test data you wish to process All worksheets in this file are then listed as per the example below Note that all chart sheets graphs that are in the file are not listed Any combination of worksheets can be selected by clicking on the name A worksheet can be deselected by clicking a second time on its name see example below Alternatively all sheets can be selected by clicking on the Select All Sheets button Next takes you to the Run Import table Eurus Mineral Consultants 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 56 of 118 KinCalc Data Import Wizard Step 4 of 4 Single File Mode X v Automated Processing Mode r Auto E 2 Report lt Calculate Kinetics Li Copy To Summary Sheet Status Waiting to process KinCalc Data Import Wizard Step 3 of 4 Single File Mode Import Folder IEINCALC Demonstration of KinCalc KimCalc demo folder Last Used or Selected Filename IMP Mer2005 Lfield MF1 RoRates xls Sheet Names Normal Ro Rate 8 50 Iormal Ro Rate 2 60 Get Sheet Names Normal Ro Rate amp 70 Normal Ro Rate E 80 Mechanised Ro Rate 505 Mechanised Ro Rate amp 60 Mechanised Ro Rate amp 70 Mechanised Eo Rate 80 Blend Ro Rate 60 _ i Normal Depressant 1 Normal D
73. below can be found towards the end of this section 10 1 Specifying if Assay Data is Formatted as a Single Region At the bottom of the Define a New Import Format table is the question Each Column is a Single Region or Each Row is a Single Region This refers to how the assay data are arranged Note that a column is defined as data that relates to assays for a particular analyte A single region is defined as when assays are in adjacent and successive rows columns without a gap in between Some examples below illustrate the difference ASSATS Assays in each column are defined as being in a single region T o C CCT _9_ gt 9551 9551 14505 14505 23094 23094 1594 He 1999 eosa mez man 370 214 vos 3168 2095 658 100 iez 2804 2738 i207 5539 Assays in the 4E PGM column are separated by 7 rows from one test to the next but are still defined as being in a single region This data format is defined as not being a single region The first three assay columns are marked with the analyte name There are twelve test results Those for concentrate number 1 are listed in rows 146 to 157 Assays for concentrates 1 2 and 3 etc are offset by 16 rows These data do not Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 50 of 118 form a single region because t
74. ble box by clicking on Define New Name the parameter and choose the number of decimal places required when the parameter is displayed In the diagram below note that a parameter of Long description is included It is recommended that one or possibly two general parameters are included so that important notes can be recorded such as e Areportor folder name where hard copy notes concerning the test may be found e General conditions of the pilot plant run or plant audit that prevailed at the time e Comments on sample representivity e Notes on froth condition or other notes of a general nature concerning the test Note that once a parameter is loaded and used it cannot be deleted at a later date because it will have been loaded into the Database and will now be an integral part of the data management system It is always wise to add spare columns in this case labelled Comments1 and Comments 2 to accommodate any test details or notes comments that were either not available at the time of data input or which become available as a result of measurements performed later Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 44 of 118 KinCalc Manage Test Parameters Cus04 g t FF300 o t Grind 75 um KU 20 oft a Ag Eurus Mineral Consultants c IVI 2007 Copyright subsists in this work unus minera
75. but will apply to any future imports Define Aliases For g Done A gf Eurus Mineral Consultants U 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 39 of 118 6 7 Determining the Category of an Analyte The categories and codes used to describe an analyte are shown in the table below Floatable material is categorised and assigned a code in order to apply the appropriate protocol when calculating Kinetics Metal Contaminant 1 Non economic metal element or mineral Floatable Gangue 2 Non economic element or mineral Metal or Mineral Economic metal element or mineral Metal contaminants are non valuable material or metals which are recovered as a by product of the flotation process Recovery may be by entrainment solid solution or attachment to floatable gangue or mineral because of poor liberation Examples are Iron and Chromium in the form of Chromitite FeCr2O3 Magnesium and Manganese Floatable gangue is defined as non valuable material recovered to concentrate and is the difference between total concentrate mass and the total mass of assayed elements and or minerals Typically floatable gangue consists of common host rock minerals such as Talc H2Meg3 SiOs a Pyroxene Ca Mg Fe SiO3 2 and any of the Feldspars e g Anorthite CaAbSi Os Sulphur is not usually contained in a typical gangue mineral but if it is it is usually as a sulphate e g Polyhali
76. d Database on a Network below If the licence agreement is for a standalone version then install the database component on the local computer Continue with the instructions in section Standalone Database below 2 7 1 Shared Database on a Network To install the database as a shared database on a network computer you will require administrative privileges on that computer At the central network computer locate and run the file entitled KinCalc Database Setup exe in the root folder of the installation disc Consent to the license agreement and follow the on screen prompts to install the database You may wish to change the default install location from c Program Files KinCalc Whether you choose the default location or specify your own destination folder make a note of where you installed it as this information will be required later It is not strictly necessary that this shared computer have MS Access or SQL installed but if any changes are needed to be made in the database directly through the database interface then MS Access or SQL will be required either on the central computer or another computer that has access to the folder where the database was installed Important Note If the destination folder on this network computer was not c Program Files KinCalc then the procedure described under section KinCalc Database below will need to be done If the computer where the database resides does not have MS
77. d Sets list and click on the Use button e This automatically loads analytes and assays onto the Input Page Areas where text and data may be entered are coloured Tan and anything written or pasted into these areas is formatted in blue Areas which are not coloured are protected and no data or text can be inserted e Go to the Input Page e Either type in or paste test data and descriptions into the respective cells e Inthe Stream Name cell a drop down box appears These are abbreviations to record the name of the stream from which the sample was taken If it is necessary to add a stream name do so as per section 7 e Change assay units and number of decimal places from 2 to 4 and vice versa as desired as per section 6 6 The diagram below shows a typical Input page 9 2 Manual Input of Other Test Parameters e Call up the Manage the List of other Test Parameters form e Select other parameters as described in section 8 1 above e The parameters are automatically loaded into an Other Test Parameters box at the bottom of the Input page The diagram below shows the bottom of a typical Input page with the list of Other Parameters as chosen from the Manage the List of other Test Parameters form Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS Input Kate Flotation Test Data User Manual for KinCalc v2 1 July 2007 Page 48 of 118 Client ALCHEMY SYSTEMS Ltd Mine Y
78. detected Eurus Mineral Consultants c Wi C 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 9 of 118 2 6 The KinCalc Spreadsheet The KinCalc M Spreadsheet component may not be installed as a shared network component Each user that is to use the KinCalc Spreadsheet should install the appropriate files on their own computer on their local hard disk The KinCalc M Spreadsheet application may not simply be copied from one computer to another as it will not function To install the spreadsheet component locate and run the file entitled KinCalc Setup exe which is stored in the root folder of the installation disc Follow the on screen prompts to accept the licence agreement and install the spreadsheet component of KinCalc The default installation folder is c Program FilesVKinCalc The KinCalc Spreadsheet may be accessed either from the newly created desktop shortcut or through the Start menu by choosing Start All Programs KinCalc KinCalc V 2 7 The KinCalc Database Only one instance of the KinCalc Database component should be installed If the KinCalc license agreement is a network based agreement then install the database component on a shared folder on a network computer As already suggested it is likely to be the same computer where the HASP license manager was installed Continue with the instructions in the section Share
79. diff grt a 2 530 10 Combined Conc _ wA a a Cone 1 1 75 275 87 Conc 2 11 388 85 Cone 3 4 767 965 Conc 4 2 057 32 Conc 5 Conc 20 Select Check Bos to change analyte units gt Click here ro change decimal places From 2 to 4 or uice verzazz Copper assay changed from to g t Nickel changed from 2 to 4 decimal places Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 38 of 118 KinCalc Manage Analytes and Minerals Available C a0 Chrome Hi Add New Base Metals Common Data Set Leeuwkop Montcalm Precious Metals Raglan Unki Manage Assay Units The units of all assays are defined to be one of the two listed below Mo other choices are allowed Different yet equivalent units may be defined as aliases for each of these two unit types e g ppm is equivalent to g t and the user may wish for all analytes with units of ppm or g t to be displayed as g t In that case define Unit 6 below as g t and create an alias of ppm Define Aliases For PGMs Mew alias Add Current New Value alue Unit 2 Text BYE Alias Defined Aliases PGM Au Tot POM amp Au 4T Delete 3E Au 6E PGM TotPGM r Au IE Unit 6 Test ut mm jave Note that any changes to unit text will not apply to data already residing in this application
80. e ER A Z r a i eal c Ex rz lt E gt ia La a af EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 103 of 118 used in this add in are not linked to the KinCalc database list of analytes and abbreviations but it is a trivial list to maintain in the manner described above Possible Errors Some possible errors that may be encountered whilst transposing rate parameters are listed below as a guide to the user on how they may and may not select header and data rows or columns If the user selects a header row and multiple rows of data when attempting to transpose from rows to columns then the following error message appears If the user doesn t select a complete set of data e g only highlights the IxxF and kxxF columns of an analyte for a particular test and then tries to transpose the row into columns then the following ooga tene oona nnen ooo amez 06641 03832 00654 0 0352 04536 oooga 00338 04363 oooga 06214 07313 00675 oma 03781 0 0068 01141 osem 0 0067 07468 11992 0 0355 00332 02604 0 0014 00315 02381 0 0014 0 3710 11956 0 0399 nos j 0 0345 00275 Warning Ear 0 0506 0 0433 00357 0 0343 0 0401 0 0231 0 0343 You must select a header row and a SINGLE row 0 0541 containing the data you want bo transpose
81. e The password prompt that appeared on startup and that may have appeared upon closing KinCalc should no longer appear Rem Eurus Mineral Consultants C IVI L 2007 Copyright subsists in this work eral Consultants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 19 of 118 2 10 Uninstallation Uninstall programs have been provided for each component of the KinCalc System From the Start menu choose Start All Programs KinCalc Uninstall and choose the component you wish to uninstall fag KinCalc fag Uninstall amp Uninstall KinCalc KinCalc KinCalc DB we Uninstall KinCalc Database uM Uninstall EMC Excel Utilities BsF Activate EMC Excel Utilities x Uninstall KinCalc Documentation Deactivate EMC Excel Utilities rn Manuals Note that uninstalling a component will permanently delete the associated files from your computer Any data stored in either the KinCalc Spreadsheet or Database will be permanently lost if they are uninstalled Use the uninstall feature with due care CRAC Eurus Mineral Consultants w IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 20 of 118 3 IMPORTANT POINTS REGARDING INITIAL SET UP AND USE OF THE KINCALC KINETICS CALCULATOR It is highly recommended that you first spend some time setting up formats terminology descriptions and n
82. e Average Sheet via the A icon Copy Highlighted record to the Average Sheet The data is moved from the Summary Sheet individually and not en mass Thus if the average of four tests is required then each data set is highlighted and moved separately The concentrate collection times and analytes of all tests must be the same An example of the Average Sheet for four tests index numbers 13 16 is shown below Average of Selected Test Data From the Su Sheet 51 Conc Times 32 Indes 33 13 34 14 3b 15 3b 16 37 Ave 40 Conc Masses as H indes 42 13 43 14 44 15 45 16 46 Aue 2 69 3 28 5 13 1 80 49 Come Assays PGMs 50 Index Al 13 h2 14 53 15 54 16 55 Aue 58 Conc Assays Copper 59 Index B 13 1 69 0 25 0 08 0 04 The icon Copy the Current Average Values to the Input Page loads the averages in rows 37 46 55 etc to the Input Page Once loaded the kinetics can be calculated in the normal way as per section 11 and loaded back onto the Summary Sheet As shown below the average data has been loaded into the Summary Sheet The description of Ave of 4 tests 13 14 15 and 16 has been noted the Test Variation column in row 31 The associated kinetics kinetic variables and test results are summarised in the tables below row 31 out of picture Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 200
83. e address boxes will collapse the form to allow the user to see what they wish to highlight so this Correlation Matrix Source Data Regions Header Region N Rows or Columns to Correlate E Famam 008 6 ommum The Correlation Matrix Output Options section is where the user chooses where the correlation matrix will be generated either in the same file as the data source a new file or the files last used Whatever the choice a new worksheet will be created for the first matrix in whichever file was selected The name of the worksheet created is user configurable Subsequent matrices will be positioned on that sheet in a location dependant on the setting of the Append to Sheet checkbox Selecting this checkbox allows the user to create multiple matrices on a single sheet Several trial matrices may be created on the same sheet then when the user is ready to create their final few matrices they may clear the Append to Sheet checkbox for the first of the final versions to start with a clean sheet and then re select it for the second and subsequent matrices to append them one below the other If the user elects to create their matrix in a new file after the creation of the first matrix the Last Used File option is automatically selected so that new files are not continually created for each subsequent matrix generated The name of the newly created file is inserted in the associated textbox Should the user wish t
84. e of the tests es D ipti f iation A hat i i Test Variation ps Ep O any ve dds to what is written under Test Description Sheet Name Records name of excel file worksheet the kinetics were calculated Enter True or False False means the original Is Parent User test has been modified such as omitting some analytes when recalculating kinetics C Ur Source of sample Lab refers to borecore samples and User PP pilot plant Compulsory input otherwise data will not be loaded to the Access or SOL database cae Number of row Can be changed into any order and Sort Index KinCalc the sort function used to rearrange the data in ascending or descending order Note that data for Stream Name and sample source Lab or PP or Plant must be completed otherwise the data will not be loaded into the Access or SOL database After these standard headings the headings or items chosen in the Manage the List of Other Parameters as described in section 8 1 will appear to the right from column R onwards Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 71 of 118 The blue text in the Miscellaneous Parameters table between columns B and G may be edited Any change made here will be reflected in all other tables below i e a change made to the text in F10 automatically changes the text in F23 F36 and all other tables b
85. eee eun 9 2 7 2 DQIANDALONEDATADA SDLD audusivisescsseticssi e niran a E eani aV 12 Z0 THE EMC M EXCEL UTILITIES oci iiebiesaeosiedsveset esu cepa eed catteassuvietecsssisnsacescahesseasvecuceetssecteaiee 12 2 9 ESLEESRNLUIEUTLSIL IU Er NS 12 9 L KINCALC DATABASE ouieieiaumdiuicicivisra eraot ve PER Iu oo IPIE T Ped aa Ded c uva Uer a Us d eee di amu nE 12 2 9 2 RINCALC SERE AIUSEDIBET cecutscatesandensouasecesesticoncsuedesacevencsutecccscnttvasconseaedcaciavievessconlanaiade 15 2 9 3 LOCATE THE KINCALC DA TA BAS Boeicscsscescesssssscecsesacesscccaseastvaccanscenssscesssavenccosscessese 16 2 10 UNINSTALLA TION 19 3 IMPORTANT POINTS REGARDING INITIAL SET UP AND USE OF THE KINCALC KINETICS CALCULATOR cccccccceccccccccecccccocccccccsooccccoooosoccoooocccosoocccousosocccsescccouessececees 20 4 INTRODUCTION TO THE FLOTATION KINETICS CALCULATOR 25 4 1 WHAT ARE FLOTATION KINETICS ccccccccccooccccccco00oooeooocc00000ooeooo00000000000000000000000000000000 25 4 2 TERMINOLOGY AND ACRONYMS s esessibsdtn venda sob aqu ce mixsco ane dias NONS d DU IDEEN E 27 4 3 BRIEF OVERVIEW OF THE KINETICS CALCULATOR e eee eee esee eeee eoo so teet teet esee oss eee eeoe 27 5 TOOLBAR ICONS 32 DA STANDARI ICONS arr E E E COND OSA 32 5 2 OPTIONAL EXTRA ICONS cies poine Pas i di N I IF IN SRI CHR
86. eet to the left of this form All available colour codes are listed in the palette below Note After clicking Cancel any changes made will remain in effect for the current session The changes will be lost if EinC alc is not saved After clicking Done please be patient while changes are saved Done KinCalc Application Configuration d Graph Settings Graph Series File Locations User Interface 3 I Text Font Settings Markers amp Legend l C a Se n oe a S aa ars See Choose Descriptive Items To Include in the Graph Titles 4 E a na IM Client Name jv Plant Name Choose Graph Title Content v Mine Name v Test Description Iv Ore Type lv Test Date Sample Title The selected item s contain no text with which to construct a sample tite The items checked above will be incorporated in the title of each of the standard graphs If data is imported the above selections will be overridden by the settings applicable to the import format used to import the data If this does not suit you then go and edit the relevant import format definition o t of this All dcus Reset to Defaults the current session The changes will be lost if EimCalc aved CAC 0 0 1 0 _ Eurus Mineral Consultants CIVIL 2007 Copyright subsists in this work unus rninenral constans EURUS
87. elow Information in columns A to G are repeated for all tables below Click here to hideftunhide the row headings MiscParameters J 10 1 Amplats AM Mline UG 2 Amandelbult Rougher Rate Test on Primary Rougher Feed Sample natus 11 2 BREPM Bafokeng Merensky BRPM Plant Rougher Rate Test on Primary Rougher Tail Sample ziii 12 3 RioMarcea Aqua Blanca Gold RM Plant Eougher Rate Test on Secondary Fougher Feed Sample nas 13 4 Impala Imp Min Merensky Min Proc Rougher Rate Test on Secondary Rougher Tail Sample 04 01 06 14 5 Lonrho 4 Shaft WG 2 L UG 2 Rougher Rate Test on Secondary Rougher Conc Sample 05 01 06 15 5 BF Martham Merensky GF Plant Rougher Rate Test on Crusher Circuit Fines Thickener OF neus 16 T 17 8 18 13 20 21 Kelsall Parameters 23 index Chem Mine Ore Phe Teabe Tecos 23 1 Amplats AM Mine WG 2 Amandelbult Fiougher Rate Test on Primary Rougher Feed Sample nius 24 2 BREPM Bafokeng Merensky BRPM Plant Fougher Rate Test on Primary Rougher Tail Sample natos eb 3 RioMarcea aqua Blanca Gold FN Plant Rougher Rate Test on Secondary Rougher Feed Sample 05 01 06 eb 4 Impala Imp Mlin Merensky Min Proc Rougher Rate Test on Secondary Rougher Tail Sample 04 01 06 er 5 Lonrho 4 Shaft WG 2 L UG 2 Rougher Rate Test on Secondary Aougher Conc Sample 05 01 06 z5 5 BF Mortham Merensky GF Plant Rougher Rate Test on Crusher Circuit Fines Thickener OF 06 01 06 e3 T 30 8 31 32
88. epressant 2 Save As Default Mechanised Depressant 1 Next gt There are several options that can be selected in the Run Import table e Automated Processing Mode When ticked the Automated Processing Mode is activated This means that processing is not interrupted when an error is detected or the contents of a worksheet or file have been processed and or completed If the Automated Processing Mode is not selected then processing stops after each error is encountered or when the end of a worksheet or file is reached In this case the following message box is displayed asking whether you want to revert to Auto Processing Mode i Data successfully imported Do you want to revert to Auto Processing Mode Mo e Calculate Kinetics When ticked the flotation kinetics are calculated and the screen reverts to the Results Sheet e Copy to Summary Sheet When ticked the flotation kinetics calculated with and without the 7 boundary tests are moved from the Results Sheet to the Summary Sheet The screen reverts to the Summary Sheet e Auto Report This refers to this icon list box to a workbook Clear the notes Eurus Mineral Consultants n ASC IVI C O 2007 Copyright subsists in this work eunus mied constans which reports the contents of the Import Notes EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 57 of 118 If Run Import is clicked together with Automated Processing Mode but wit
89. ers such as cell size pH and CuSO The comments columns can be used to note anything of interest or value concerning g R Af Eurus Mineral Consultants IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 22 of 118 the sample or test In this case they have been used to record that raw kinetics are better than boundary test kinetics and that the solids were 37 There may be a situation where the solids may only have been known after the data and the kinetics were loaded in which case it can be added after the fact in the Comments 2 column 2 co cn c3 fM KinCalc Manage Test Parameters Available Selected 80 Passing Size Cell size T A3477 g t PNBX a t Air Rate l min TFB 285 g t Cell size I pH a m3 Comments 1 ig Comments 2 SIBX o t Define New Dow 200 g t Cuso4 g t usi n 1 Comments 2 Dep 267 g t Depressant Dosage aj Depth m it 200 gt Delete FF300 a t Frother Grind lt 75 pm KU 20 o t El Delete Mote Parameters should be added with care as they cannot be deleted once they have been utilised a Index ELTE Sort Index Cellsize l PMEX git igh iZ SB grt Ee CuSO4 git an um Lab ics better than 374 solids Lab 7 ics better than 377 solids Lab 10 0 x E Z ics better than 37 solids Lab
90. es Measured Conc Grades Measured Head Grades Floatability IMinF kMinS 1000 see section 4 2 for terminology and acronyms 13 1 Functions Available to Process and Arrange Data Data may be re arranged sorted highlighted moved and stored by a number of functions which are listed below Many of these are self explanatory Those that require some explanation are described in more detail below this list aa 7 ie Er a f r V j i cu mac mirus pecunie tannic Lvl ZUGE EA d Iwan Eurus Mineral Consultants O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 67 of 118 Goto Summary sheet Clear Summary sheet and Input page of all data Delete highlighted row of data applies only to 5ummary sheet Move highlighted record up Move highlighted record down Copy highlighted record to Input sheet Copy highlighted record to the Average sheet ui 44 gt X 3 Copy highlighted record to ScrollCalc TM Bie Enable disable row highlighter d Highlight differences in kinetics caused by applying boundary tests AE Hide all details in Summary sheet _ Sort all data in chosen column in ascending order Sort all data in chosen column in descending order Post current record to the KinCalc Database Post all summary records to the KinCalc Database Icons explained in more detail Deletes highlighted data Applies to single or multiple rows of data whic
91. es are appearing incorrectly on the Summary Sheet try clicking this button to choose an alternate date format If you dont want a coloured background when printing the Scroll Calc results page then turn it off here Note After clicking Cancel any changes made will remain in effect for the current session The changes will be lost if EinC alc is not saved After clicking Dione please be patient while changes are saved Done Af Eurus Mineral Consultants U 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 97 of 118 20 EMC EXCEL UTILITIES Functions available 1 Transpose kinetic data from columns to rows or from rows to columns 2 Generation of any number of Correlation Matrix Matrices 3 Generation of Frequency Plots Histograms 4 Change default settings for EMC Tools gt Diagrams highlighting various points detailed below can be found towards the end of this section 20 1 The Toolbar The EMC Excel Utilities add in provides functionality within Microsoft Excel to perform tasks identified by EMC as repetitive and unnecessarily time consuming These are tasks that are often encountered during the processing and analysis of results of flotation rate tests and may often source data from the EMC KinCalc spreadsheet program The Utilities were written as an MS Excel Add In and when desired may be loaded and remain accessible
92. est 19 and kGF test22 are at their respective maximum values Test 19 Gangue kinetics also has kGF kGS which means that the Gangue recovery time curve is a straight line Screen prints of original and manually derived kinetic values are presented below Test 33 0 00076 0 00162 0 02384 Test 51 0 00037 0 00077 0 01327 Test 21 0 08137 0 05341 0 24778 Test 20 0 00479 0 00234 0 01332 Test 24 0 12137 O 08660 0 31783 Test 13 0 4238 0 2343 0 07142 0 0020 0 0996 0 09957 0 0765 4 5000 0 48210 Test 23 0 00001 0 06528 Trr24 Test 25 0 00001 0 00001 0 38303 Test 53 0 00655 O 00342 0 10547 Test 57 0 00600 0 00453 0 07587 Test 33 0 02431 0 04433 0 35363 Test 34 0 03562 0 05369 0 05848 Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 82 of 118 ScrollCalc screen for Test 19 Original Kinetic Values 1 2 3 4 5 B T 4 0 5 0 5 5 6 0 Time mins Grade X 1 Fointr Mo ar d Line Calz 4 T Fninkr Meard Line Calz 4 m H umi a m m im g m tl Cea Recovery t Ca Recoverg t Rest Active Data Set Lab Copper H EE EN uo ICuF aj IGF 3L Reference Raw r Refresh d b kCuF l lr Graphz El ri Display F Lab F kCuS 4 gt EGS 4 Active Lab EE ITIN TN RNG BR TON E oos tas 1044 mes Click Euttanz bo view Oaka Gaaga Recorerp t Ca Recorerg
93. estimated The tests showed that PGM floatability and kinetic values were increased relative to gangue These kinetics are used to simulate the circuits in Figure 5 and Figure 6 Table 1 runs through a series of simulations using the kinetics in Table 2 The simulations move from the original circuit as per Figure 5 to a two concentrate circuit with successive changes to flotation kinetics This highlights how changes in kinetic value can affect flotation performance Note how the ratio of PGMs gangue changes in respect of the fast floating ratio fast floating fraction of PGMs to gangue and the slow floating ratio slow floating rate of PGMs to gangue Roughers 34 min nom residence Tailings 2 stages Cl Scav 3 stages of cleaning Final Concentrate 0 9 mass 405 g t 78 7 recovery Figure 5 Flotation Circuit before Optimisation Eurus Mineral Consultants c Wi C 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 118 of 118 Roughers 34 min nom residence es Tailings RT feed 2 RT Ro Conc 2 stages of cleaning 3 stages of cleaning Primary Concentrate Secondary Concentrate 0 32 mass 0 3276 mass 1121 g t 212 g t 69 4 recovery 13 576 recovery Combined Concentrate 0 6476 mass 660 g t 82 976 recovery Figure 6 Flotation Circuit after Optimisation Simulated Concentrate 105 39 090 o T wo pu NENNEN
94. ew An example of a Summary Sheet with rolled up tables is shown below Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 1 Only the blue text may be edited Misc Parameters Indes Pline Test Description Impala Lanrha GF54 qa ocn 4 co M AM Iine Amandelbult Fiaugher Rate Test on Primary Rougher Feed Sample Bafakeng Merensky BRET Plant Rougher Fate Test on Primary Fiougher Tail Sample Riohlarcea Aqua Blanca Fiaugher Rate Test on Secondary Rougher Feed Sample Imp Miir Merensky Tin Proc Fiaugher Rate Test on Secondary Rougher T ail Sample 4 Shaft Rougher Hate Test on Secondary Fiougher Conc Sample Maortham Merensky GF Flant Rougher Hate Test an Crusher Circuit Fines Thickener CIF Kelsall Parameters Kelsall Parameters After Scroll Calc Linear Correlation Coefficients The tables in the Summary Sheet are Misc Parameters Kelsall Parameters Kelsall Parameters After Boundary Tests Kelsall Parameters After ScrollCalcTM Linear Correlation Coefficients EM eam Global Test io Mame Ti MOIS Ate 037017406 04701706 OOO Ded 6 Page 66 of 118 Summary of Test Results 1 z TZ Mil 3 T3 Mil 4 T4 Mil 5 T5 Mil T amp Mil Sum of Squared Errors Based on Boundary Test Parameters Slow Floating Ratio kMinS KGS Selectivity IMinF kMinF kMinS IGF kGF kGS st Measured Recoveri
95. fined Increment is chosen then the Number of Bins block is shaded out and the desired increment can be entered into the Increment box In the example below an increment of 0 0040 has been chosen and the Calculate No of Bins button has been clicked The resulting number of bins is 36 n g Eurus Mineral Consultants IVI U 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 112 of 118 Frequency Plot Bin Options Defined Increment Defined Number of Bins Start Value 0 0001 Finish Value 0 1371 Calculate Mo of Binz Frequency Plot Bin Options Defined Increment Defined Number of Bins Start Value 0 0001 Finish Value 0 1571 When the Calculate No of Bins button has been clicked the prompt in red font of Click Calculate Increment to proceed disappears and the Generate button becomes un shaded and is now active In the Miscellaneous Options section the user can define the title heading for the plot graph whether the plot is to be a Histogram or Line Chart and if the plot should include a trend line and individual or cumulative data or both The plots below show examples of the choices that can be made The first is a histogram showing individual bars trend lines and cumulative frequency lines The second is a line chart showing the individual bins as lines without a trend line or cumulative frequency lines Note that the calcula
96. full permissions must be allocated to a new group of users e g KinCalc Users and then the required users must be added to that user group A successful share is denoted in Windows Explorer by a hand appearing underneath the icon of the shared folder as shown in the close up image below Please note that the above steps may need to be done in conjunction with and or with the permission of your IT department Some corporate LAN s have more restrictive policies than others and the steps described above may not be possible to implement without the help and or approval of your IT department Note that the folder name above is not the same as the share name you chose to give the folder Remember both the share name and the network name of the computer where the database has been installed for use in section 2 9 below 2 7 2 Standalone Database At your local computer locate and run the file entitled KinCalc Database Setup exe in the root folder of the installation disc Consent to the license agreement and follow the on screen prompts to install the database It is recommended that you use the default installation folder viz c Program FilesVKinCalc A desktop shortcut will be created as well as a Start menu item This completes the installation of the KinCalc M application components 2 8 The EMC Excel Utilities The EMC Excel Utilities may be installed by locating and running the file entitled EMC Utilities Setup exe
97. gers One final concentrate is produced by the cleaners and cleaner scavenger concentrate is cycled back to the head of the cleaners Circuit configuration was changed so that two final concentrates were produced as shown in Figure 6 This change was also accompanied by Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 117 of 118 a large increase in depressant addition The result of these changes is summarised in bullet point below e Increasing depressant selectively depressed floatable gangue relative to PGM minerals This improved the overall recovery grade curve by improving the floatability of slow floating PGMs relative to slow floating gangue e The provision of two final concentrates allowed fast and slow floating PGMs to be recovered in separate environments which could be modified to suit the particular flotation characteristics of each component The result was a 4 2 increase in PGM recovery and a 63 increase in concentrate grade from 405 to 660 g t No changes were made upstream in other words feed tonnage solids and grind were unchanged Recovery and grade improvement were achieved primarily by the action of the depressant and the circuit change that enabled the effects of the depressant to be fully utilised Laboratory rate tests were done at various increased additions of depressant and flotation kinetics of PGMs and gangue
98. gher Conc Sample 05101706 Filot Plant 5 11 2 Hi of 4 tests T 8 Sand 10 Lab T 12 3 Ave of 4 tests 11 12 Vand 14 Lab 13 4 Rougher Rate Test on Secondary Rougher Feed Sample 03 01 06 Plant 3 14 5 Riougher Rate T est on Crusher Circuit Fines Thickener OFF Q6 01706 i Tes sts Hi Plant 2g 15 B Rieugher Rate Test on Crusher Circuit Fines Thickener OFF Q6 01106 i Tes sks Mi Plant 16 T Rougher Rate Test on Primary Rougher Tail Sample Barras i Pilot Plant 6 17 8 Rougher Rate Test on Secondary Rougher Tail Sample Od MOTO i Lab 1 18 13 20 21 Kelsall 22 des 23 1 Rougher Rate Test on Secondary Rougher Conc Sample pnm o 00407 i 0 004335 0 10440 24 2 0 00265 0 00260 g453 25 3 0 0022T j 0 00224 0 03313 zb 4 Rieugher Rate Test on Secondary Rougher Feed Sample astros 0 00005 0 00005 0 07600 zi 5 Rieugher Fate Test on Crusher Circuit Fines Thickener OFF Q6 01706 0 00056 0 00056 0 00250 28 Rougher Rate Test on Crusher Circuit Fines Thickener OFF Q6 018106 0 00056 0 00056 0 00250 29 Rougher Rate Test on Primary Rougher Tail Sample 02 01 06 0 00010 0 00070 E 0 01434 30 Riougher Rate Test on Secondary Rougher Tail Sample pd nae 0 00005 i o 00008 0 00741 31 ae 323 34 Kelsall 35 hdc 36 1 Rougher Rate Test on Secondary Rougher Conc Sample 05 01 06 0 00407 0 00455 0 10440 27 2 0 00265 0 00260 g4
99. h have been highlighted Moves a data row up one row at a time Moves a data row down one row at a time If it is required to rearrange multiple rows at a time use the Sort All Data icons in conjunction with the Sort Index column Loads a highlighted test back into the Input Page This allows the kinetics to be re calculated and the standard graphs to be re generated This may be necessary if updated assay or mass values have been received It also allows kinetics to be estimated with any analyte omitted see section 11 2 for how to do this hi When a particular row of data is highlighted in any table the row corresponding to that same data set is also highlighted in all other tables see example below rows 11 24 and 37 dA Differences in kinetics calculated as is without any boundary tests and with boundary tests are made clear by red font See the example below the values of IPGMF in rows 23 and 36 Eurus Mineral Consultants c IV L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 68 of 118 Indes Test Description Test Date num Global ID Test ILI Uy Sheet Mame File Mame um anten Ea aad 10 1 Rougher Rate Test on Crusher Circuit Fines Thickener CIF 06 01 06 BRP Tests Ti z RFiougher Rate Test on Primary Fiougher Tail Sample ne i BRP Tests lz 3 Fiougher Rate Test on Secondary Fiougher Feed Sample 03 01 06 i BRET Tests 13 4 Rougher Hate Te
100. he G and Ni gangue and Nickel average is shown at the top of the picture and is highlighted in the table Define a Correlation Matrix Correlation Matix Source Data Regions 1 Header Eegion Summary 3H539 55539 Rows or Columns to Correlate Summary 5 540 5 549 2 Correlation Matrix Cutput Options 3 Same File as Source Data Append to Sheet Booki Conditional Formatting of the Resultant Matrix 4 Value Colour Upper Constraint 075 Blue 7 Bold Middle Constraint 0 5 Eed w Bold Lower Constraint 0 25 Black T lw Bald Miscellaneous Options 5 Heading text to use for matrix Correlation Matrix Highlight every Mth row or column where N 3 IV Add Average Calcs 3 oe Generate Matix Eurus Mineral Consultants 2007 Copyright subsists in this work M iM EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 108 of 118 G H l J K L M M E j Fi 5 1 z 3 38 Kelsall 39 Index 40 1 0 00337 0 00321 0 04423 0 03781 41 2 0 00025 0 003 0 03252 0 00250 42 3 0 00416 0 00390 0 06953 0 02164 43 4 0 00620 0 00534 0 01425 0 02730 44 5 0 00460 0 00436 0 02700 0 02225 45 6 0 00 712 0 00654 0 03121 0 02943 46 T 0 00362 0 00375 0 04423 0 03781 47 8 0 0002 0 002 0 03252 0 00250 48 3 0 00382 0 00379 0 04423 0 03781 43 10 0 00025 0 00 0 03252 0 00250 ra FIND X Y f AVERAGE SISS SLS10 R T 8 a Oe Dret DA S LEN EE EAR s a z Correlati
101. he assays for concentrate 1 2 and 3 are not arranged directly below each other in successive rows such as 146 for conc 1 147 for conc 2 and 148 for conc 3 etc PGMs Cu Ni 144 Conc 1 Assays 145 Conc Assay 146 147 i 148 i 143 1 i 150 151 L 152 153 L 154 155 156 B 344 3 10 33 50 11 58 16 06 0 82 157 3 3 41 3 10 33 50 1158 16 06 0 82 161 Conc 2 Assays 162 Conc Assay 163 164 165 i F 166 L 167 168 L 169 170 i k 171 i 172 173 J L i 1 92 5 46 40 70 12 45 13 17 1 02 174 132 5 46 40 70 12 45 13 17 1 02 175 176 177 178 Conc 3 Assays 179 Conc Assay 180 10 2 Import Wizard Click on the Import Wizard icon and choose either single or batch mode e Single mode imports data from a single file and e Batch mode imports data from a folder containing a number of files KinCalc Data Import Wizard Step 1 of 4 Single File Mode KinCalc Data Import Wizard Step 2 of 4 Single File Mode x Choose an Import Format Afplats UG2 Impala Impala 229 DB Impala 229 DB 2005 data Impala Multiple sets per Wbook Fut IMP Lakefield KinCalc V11 a Test 1 Choose an Import Mode Save As Default Save As Default Next gt gt Close lt lt Back Next gt gt Close 10 3 Making a New Import Format One Data Set per Sheet An import format can be m
102. heet Copy sheet page data to a new workbook data are copied as values stripped of equations Goto Import Data Wizard Import Data from the KinCalc TM Database Solve for kinetics Goto Results sheet Goto Graphs page Goto Summary sheet Clear Summary sheet and Input page of all data Delete highlighted row of data applies only to Summary sheet Move highlighted record up Move highlighted record down Copy highlighted record to Input sheet Copy highlighted record to the Average sheet Copy highlighted record to ScrolICalc TM v2 1 July 2007 Page 32 of 118 Eurus Mineral Consultants 2007 Copyright subsists in this work 4 RI Hi x Lug x ss xt X D i i Eo E EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 33 of 118 Enable disable row highlighter Highlight differences in kinetics caused by applying boundary tests Hide all details in Summary sheet Sort all data in chosen column in ascending order Sort all data in chosen column in descending order Post current record to the KinCalc Database Post all summary records to the KinCalc Database Goto the Average sheet Clear all data off the Average sheet Delete the highlighted record on the Average sheet Copy the current average values to the Input sheet Goto Scroll Calc TM Clear all Data off the ScrolICalc TM Page Copy the active ScrollCalc TM Parameters to the Summary sheet Customise Program Settings Show
103. highlighting the specific data set in any of the tables in the Summary Sheet Click the icon Copy the highlighted record to ScrollCalc and the data will be loaded onto the ScrollCalc page If data already exists on the ScrollCalc page or the analytes of the test you wish to load are not the same as those already loaded you will be prompted to overwrite the data or clear it as per the prompt boxes below Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 75 of 118 Confirm The number of analytes already in use on the Scroll Calc sheet is different from the number about to be copied there P j OK to overwrite existing Lab You may only analyse data sets with the e data on the Scroll Calc sheet same analytes Clear the Scroll Calc sheet and then copy this set again No OK At the top of the ScrollCalc Page above the graphs test information loaded from the Summary Sheet is recorded between rows 4 and 10 To the right of this box are two command buttons one to align the graphs to the top of screen and the other to clear all data from the ScrollCalc page Clear all data by activating Clear All and then go back to the Summary Sheet and reload the chosen data Grade L X Grade P Recover v L X Recover F Hi Recovery X Hi Recovery X Up to three sets of data can be loaded one for a laborator
104. hout Calculate Kinetics and Copy to Summary Sheet then the results are displayed in the Import Notes list box as shown below Note that Status has changed from Waiting to Process to Process Complete Below this the number of processed sheets is noted together with the elapsed time in hours minutes and seconds In the right hand example a sheet has been included with an error In this case the error is a concentrate assay that was deleted prior to processing A Warning message is inserted to alert the user However this is difficult to see because the message is not highlighted in any way and may be hidden from view and need to be accessed by using the scroll bars at the side and bottom of the Import Notes list box Ei KinCalc Data Import Wizard Step 4 of 4 Single File Mode Automated Processing Mode Xt ju E Auto ay Automated Processing Mode ime r Auta i Report Report Calculate Kinetics Copy To Summary Sheet Calculate Kinetics Copy To Summary Sheet Status Processing Complete is Status Processing Complete T Successfully processed 3 sheets out of a total of 5 sheets in 1 file Successfully processed 2 sheets out of a total of 2 sheets in 1 file Import Notes See Ibl Import Notes Elapsed time 0 00 02 Alias Detected Analyte PGM Au7 will be imported as PGMs a Abbreviation Detected Analyte Cu will be imported as Coppe Abbreviation Detected Analyte Cu will be imported as
105. ide the row headings 1 Z 3 4 E Cd 6 Only the blue text may be edited Y 2 Misc Parameters Variation 8 10 1 AM mMine Amandelbult Frougher Rate Test on Primary Rougher Feed Sample D HET 1 11 2 Bafokeng Merensky BRP M Plant Fiaugher Rate Test an Primary Fiougher Tail Sample I D LS Zz 12 3 RioWarcea Aqua Blanca Fiougher Rate Test on Secondary Fiougher Feed Sample 03701706 3 T3 13 4 Impala Imp Min Merensky Min Proc Rougher Rate Test on Secondary Fiougher Tail Sample 04 01 06 4 T4 14 5 Lonrho 4 Shaft UG Rougher Rate Test on Secondary Fiougher Cone Sample 05 01 06 5 TS 15 GFSA Mortham Merensky GF Plant Rougher Rate Test on Crusher Circuit Fines Thickener OF OBOE 6 TE 16 17 13 13 Kelsall f p 20 Index CMM ee M Mr vs 167 _ zl 1 Amandelbult Frougher Rate Test on Primary Fiaugher Feed Sample ez 2 BRP Plant Fiougher Rate Test on Primary Fiougher T ail Sample 23 3 ua RM Plant Rougher Rate Test on Secondary Rougher Feed Sample 24 4 i Min Proc Rougher Rate Test on Secondary Fiougher Tail Sample 25 5 L UG 2 Rougher Rate Test on Secondary Fiougher Conc Sample eB GF Flant Rougher Rate Test on Crusher Circuit Fines Thickener OF Click here on the table name and in column A to roll up the table so that only the heading is visible This saves space if particular tables are not being used The result is shown below Click again on the table name in column A to restore the table to vi
106. ighting various points detailed below can be found towards the end of this section 11 1 Automatic Calculation of Kinetics This is set up during the fourth and final step of the Data Import Wizard in either Single or Batch mode see section 10 2 The Calculate Kinetics box is ticked to activate kinetics calculation When importing and processing more than one data set the Copy to Summary Sheet box should also be ticked so that all data sets are recorded in the Summary Sheet Status Waiting to TO 11 2 Manual Calculation of Kinetics via the Input Page Test data that is currently on the Input Page can be processed manually by clicking on the Solve for Kinetics icon S This opens the Results Sheet see section 12 and calculation then proceeds moving through mass gangue and the analytes as per the example below Kinetics are calculated using the boundary tests that have been chosen at the time Rh Al Eurus Mineral Consultants c IV 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 61 of 118 Calculating the Kelsall Parameters E Initial values Gangtue foe Calculating the Kelsall Parameters Initial values Cobalt Kinetics can be re calculated by double clicking on the Solve for Kinetic Parameters button This may want to be done if a different set of boundary tests have been chosen see section 12 or one or more analytes have been o
107. ility to suit a wide range of desired formats Optional extras include the following 1 Transpose function to convert kinetic parameters in sets of three from rows to columns and vice versa with or without column and row headings 2 Paste special format function in keeping with the font number and alignment format of the worksheet 3 Correlation matrix function which generates a correlation coefficient table for a set of kinetic data 4 Frequency plot function which generates a histogram graph with cumulative frequency line As a first orientation Figure 1 lists all the various functions of the Kinetics Calculator in a one glance Mind Map format and Figure 2 shows a flow diagram summarising how these functions are linked together This flow diagram is further simplified in Figure 3 so that just the main functions are highlighted Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work Import of KinCalc ScrollCalc and Test Description Data Re import data for further analysis Data sorting Correlations Analysis Statistical Generation of Queries Educational facilit Manual calculation of kinetics SCROLL CALC What if scenarios Kinetics estimation with few data points Compare lab pilot and plant profiles Histog Sopran Custom Functions Correlation r2 Separability Curve Recovery and Grade vs Time Recovery vs Grade 5 Standard Graphs Recovery vs Mass
108. in Spanish in French platinum is Platine and platinum group metals m tal pr cieux groupe may be defined as MPG as opposed to PGMs Defining these aliases saves you correcting the original datasheets as there may be quite a lot of them The program is coded for the following e Multiple blank spaces inadvertently included before or after a name are automatically trimmed during data import e Spaces between words are trimmed to a single space Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 36 of 118 e The same words with and without a space in between are not recognised Hence TotPGM amp Au must be specified as well as Tot PGM amp Au as per the example e Upper and lower case are recognised in any combination e g Tot PGM amp Au and Tot PgM amp au Any alias found in a datasheet will be imported as its preferred record as set up in section 6 1 above e g ppm and gpt are imported as g t and copper Cu cu and any other aliases defined are imported as Copper Note that if units of have been chosen as the preferred unit of measure then all data as g t or ppm will be automatically imported as If this needs to be changed then go to section 6 5 6 4 Setting Your Own Symbol or Acronym for a Standard Assay Unit KinCalc has been set up with two standard assay units being and g t If you want to change these and use your own sy
109. information is read from the database but if the two parts of the database are not linked the required data will be unavailable The above condition refers to either a network or a standalone installation In other words whatever type of installation was done if the destination folder was not as described above then the following procedure must be performed To link the two parts of the database simply requires that the database be opened once only using MS or SQL In the network installation case this procedure is made easier if MS Access or SOL as part of MS Office Professional 2002 has been installed on the network computer but note that it is not necessary to install Access or SQL on that computer if it will not be required by other users For the case of a central network computer ensure that the license manager software has been installed and that the HASP key is plugged into that computer Open MS Access or SQL and then either click on the Open icon or choose File Open from the main menu Microsoft Access window Help Ctril h View Tools Insert Browse to the location of KinCalc2002 mde select it and click Open FT Eurus Mineral Consultants i 2007 Copyright subsists in this work B Fes f M Th i EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 14 of 118 s Local Disk C de 7 t Mame Size Type Date Modified
110. l consultants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 45 of 118 8 2 Inserting a Column at a later stage after Flotation Kinetics have been calculated An extra column for a required parameter can be added retrospectively as follows paragraph numbers refer to the annotations of the diagrams below be AR 29 19 irs p Highlight any test in the summary table e g the test with index 1 in row 10 Click the icon to Copy the Highlighted Record to the Input Sheet On the Input Sheet click the icon to Manage the List of Other Test Parameters Select the parameter to be added in this case Grind 76 75um Rerun the kinetics calculation module by clicking the icon Solve for Kelsall Parameters Click the icon Append the Current Results to the Summary Sheet A duplicate of test index 1 is added to the summary sheet as a test with index 29 in row 38 Also a new column labelled Grind 76 75um has been added The test index 29 can then be deleted using the Delete the Highlighted Summary Record s icon The test and its kinetic data are removed but the Grind 76 75um column remains 10 Data may be entered into this column for all or any of the tests in the summary sheet El E DN 3 iie TE M39 Fe n B C Li E F G H 1 e Click here to hidefunhide the row headings 3 5 Summ 6 Only the blue text may be edited T 8 Misc Parameters j A e Stream Index ciem Mine Ore Plan
111. lanca Rougher Rate Test on Secondary Fiougher Feed Sample 03401706 Impala Imp Min Merensky Min Proc Fougher Rate Test on Secondary Rougher T ail Sample 04701706 Lonrho 4 Shaft Rougher Hate Test on Secondary Rougher Conc Sample 05 01 06 GFSA Martham Merensky GF Flant Rougher Rate Test on Crusher Circuit Fines Thickener OIF 06401706 The KinCalc Program and KinCalc Database KinCalc and the KinCalc Database operate together as an integral unit and one does not work without the other If the Database is removed from the PC laptop or network environment which hosts the program then KinCalcTM will not function properly and vice versa Initial set up as regards describing the sample test and test conditions It is very important to decide upon a set of descriptions which will apply to all tests and data handled These descriptions will be used for queries and searches of the database thus they should be specific and unambiguous An example from the Input page is shown below The stream name PRT Primary Rougher Tail is selected from a drop down box Other descriptions can be added via the Manage the list of other Test Parameters form In all cases make the descriptions should be short because this will aid searches and queries of the database Input Rate Flotation Test Data Client RHiohlarcea Pine Rio Marcea Ore Type Gold Plant AR Plant Test Description Fougher Rate Test on Secondary Rougher Feed E Stream Marne F T
112. lant per test ScrollCalc Summary test data Test Details Kinetics Sample description Selected Rec Time graph Test description data Test conditions Summary Sheet Average Page Graphs Page capacity of 4500 tests capacity of 4500 tests Averages selected test 5 standard graphs Test information Test information data sets Rec amp Grade Time Sample description Sample description Rec Grade Raw data Test results Mass Time Analytes specified Kinetics Recovery Mass Mineralogical Misc parameters Kinetic ratios Separability m nas e Dus Access of Sequel Database J gt gt gt amp to Excel Each set of test data results and kinetics has a unique identifying code ie Standard Excel functions Histogram function Corr R function gt FUA INA acili interpretation Figure 3 Simplified Outline of KinCalc s Main Functions Eurus Mineral Consultants C IVI UL O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc 5 TOOLBAR ICONS A full screen picture of the Input Page with all icons is shown in Figure 4 5 1 Standard Icons S P cn x HE C J i F xl ee xX 939 2 a i E ral TEES m P n lt IV N eunus mineral consuttants Goto Input page Clear the current Input data Goto Manage the List of Analytes and Minerals Goto Manage the List of other Test Parameters Manage Stream Names Add current data to the Summary s
113. lc is not open the database can be accessed via Windows Explorer and through C drive or whatever is the main drive set up for your system It seems as if there are 2 current or recent connections ta the KinCalc Database 1 EMCLAPTOP 2 EMCLAPTOP Quit the KinCalc Spreadsheet program now and enquire of the users of the PC s listed above when they will be finished with the database Stream Name and Sample Source have to be specified Bach set of data loaded into the database has a unique identifying code To aid data management and queries made via the database it is necessary to specify the stream name e g new feed rougher feed cleaner tails etc and the sample source e g laboratory pilot plant or plant If these identifiers are not specified then the data cannot be loaded into the Access or SOL Database All other sample and test descriptions can be recorded via the import wizard and the Manage the list of other Test Parameters form Specifying Test Parameters All test parameters for all test data to be entered should be specified right at the start during initial set up This is done via the Manage the list of other Test Parameters icon It is best to include one or more general columns so that notes or comments can be added at a later date The diagram below shows that two parameters have been defined called Comments 1 and Comments 2 which have been selected for inclusion in KinCalc M together with other paramet
114. ly 2007 Page 99 of 118 Add Ins Add Ins available Analysis ToalPak Analysis ToolPak VBA Conditional Sum Wizard eT ails Excel Utilities Add In eankup Wizard Navigator Utilities v2 11 i Power Utility Pak w Query manager iw Solver Add in SQL Tester VE Code Cleaner 4 4 WEY Code Documentor 5 0 i Visual Basic Macro Examples Browse Automation EMC Excel Utilities Add In EMC Excel Utilities Add In 2006 Eurus Mineral Consultants Written by Adrian Jardin 27 83 701 8925 The customised toolbar for the add in will appear either alongside or below the other Excel toolbars If the user hovers the mouse pointer near the left hand edge of the toolbar such that the mouse pointer turns into a cross with four arrows as shown below the toolbar may be dragged to a suitable location amongst the other toolbars The add in may be unloaded at any time by again choosing Tools Add Ins and de selecting the add in The toolbar will be removed from the Excel toolbars collection and the add in functionality will no longer be available 20 2 The Transpose Functions These functions are useful for tabulating kinetic data either in rows or columns Rows to Columns The KinCalc or other spreadsheets used whilst analysing a set of rate flotation data may have rate parameters listed in a tabular format with the three rate parameters for the different analytes of a particular test all being on the same row as sho
115. mbol name or acronym then any one of the two standard units can be changed by clicking the Units button of the Manage Analytes and Minerals box This brings up the Manage Assay Units box Unit 2 Text denotes 10 2 and defines as the default assay unit in the Current Value column Unit 6 Text denotes 10 6 and defines g t as the default assay unit also in the Current Value column Enter the symbol name or acronym you want to use into the appropriate box in the New Value column If the new value also occurs as one of the assay aliases then you will be prompted to delete this from the assay alias box 6 5 Changing Assay Units for the KinCalc Program If you want to change the assay units go to the Edit button on the Manage Analytes and Minerals box For example the default unit for Copper can be changed from to g t as per the steps shown below This means that Copper will now always be described by g t in all tables in KinCalc Edit mineral or analyte The units for Copper are 96 Choose Yes to keep amp and Mo to select g t Yes No Choose a category number Confirm the category that will determine a starting point for calculating Kelsall parameters Choose from Metal Contaminant 1 Floatable Gangue 2 Metal or Mineral 3 f gt Note that if units for say Copper and Nickel have been defined as then any assay data imported using the Import Data Wizard will be imported
116. mitted Omit any analyte by ticking the appropriate box Flotation Feed Concentrate amp Final a ssays Lass and Clear Check Bos to temporarily omit analyte from the analysis gt Time Mass 3anque PGMs SPD x Sample miri grams or X bu diff grt Combined Cone Feed l MEM WE pals f 28310 er QM Se eee ee EI Eee ue ae Cone 1 1 Cone 2 3 Cone 3 10 Conc 4 E Conc b Cone 20 Select Check Bos to change analyte units gt Click here to change decimal places from 2 to 4 or uice verza 11 3 Manual Calculation of Kinetics via ScrollCalc Data sets may be loaded into the ScrollCalc Page by highlighting the relevant data row on the Summary Sheet see section 13 and clicking Copy highlighted record to ScrollCalcTM ScrollCalc is described in section 16 FUR Al Eurus Mineral Consultants C VI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 62 of 118 12 RESULTS SHEET Functions available 1 Manual calculation of kinetics 2 Selection of boundary test settings 3 Print out of one page summary with linear correlation coefficient sum of the squared errors and recovery time graph showing all analytes mass and gangue gt Diagrams highlighting various points detailed below can be found towards the end of this section This is a one page summary of pr
117. mn or by re numbering the values in the Sort Index column An example is given below Eurus Mineral Consultants C IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 69 of 118 The IGF column has been highlighted Note that the numerical order in the Index column far left and the Sort Index column far right are identical Misc P Blame alet Excluded aa ni i 1 Fieugher Rate Test on Secondary Rougher Tail Sample 04701106 1 11 z Rowgher Rate Test on Crusher Circuit Fines Thickener OIF 06 01 06 i i Plant z 12 3 Rieugher Rate Test on Secondary Rougher Feed Sample asque i Plant 3 13 4 Rieugher Rate Test on Crusher Circuit Fines Thickener OIF 06 01 06 i Tes sks Mi Plant 4 14 5 Rieugher Aate Test on Secondary Rougher Conc Sample 05701706 i Pilot Plant 5 15 6 Rowgher Rate Test on Primary Rougher Tail Sample paratas i PRT Test 2 BAPM Tests Pilot Plant B5 1 T Ave of 4 tests T 8 Sand 10 Lab T Tr 8 Ave of A bests 11 12 T3and 14 Lab 8 18 13 20 21 Kelsall 22 Index 23 1 Rowgher Rate Test on Secondary Rowgher Tail Sample 04701706 j 0 000008 OO 0 00741 z Rougher Aate Test on Crusher Circuit Fines Thickener OIF 06 01 06 0 00056 0 00056 0 00250 3 Rieugher Rate Test on Secondary Rougher Feed Sample 03401106 0 00005 0 00005 l 0 01600 4 Rowgher Rate Test on Crusher Circuit Fines Thickener OF 06 01 06 0 00056
118. nd slow floating rate Centre aligning and formatting the data have been ticked Formatting means that the paste special functions are active when the data is Copy to Clipboard pasted to the chosen file or worksheet Next click worksheet where the data is to be pasted and go to the file and or Next go to the Windows application where you would like to paste the transposed data If you are pasting the results into a spreadsheet then select the cell at the top left of where you want to paste the information and then depending on your requirements you may choose from Paste Paste Special with whatever options you want or you may click the icon which will perform a Paste Special with values and number format retained If you are pasting into an MS Word document then choose whatever paste options you would like from the Word menus such j as Paste or Paste Special The picture below also shows the data pasted using the icon with and without column and row headers Index 0 00382 0 0265 1 4126 0 00321 0 9052 2 6139 0 04423 0 7416 1 3010 0 1117 0 1363 0 00013 0 9356 0 8752 0 03252 0 8833 0 3253 D OE 0 0150 MIKELI 0 2809 1 2559 06358 03289 0 100 0 00028 Choose your options Rows to Columns n Kelsall Indes TestDate IMF kMF Iw Centre Align w Format Numbers Copy to Clipboard J T CH fe c DB HN Input Z Calcs Results Z Grapl Nn EECHENE CENE EN
119. o of Data Points 10 0 150 Average all data within correlation table 0 181 TP BMS Ore All Site Hot Floats Ro Feed amp Down The Bank Average across and Average Between Fractions KGS kNiS down 0 340 9 5495 0 488 0 1109 0 1607 0 136 0 4856 0 540 0 3308 0 409 0 421 0 562 0 551 0 443 0 500 No of Data Points 39 0 0834 0 188 Average all data within correlation table 0 410 Tati Phoenix Ore Lab Ro Conc Unmilled amp Site Hot Floats of Ro Conc Average Unmilled across and Average Between Fractions vidi 0 178 0 233 0 204 0 348 0 326 0 213 0 340 0 225 0 254 0 364 No of Data Points 23 0 212 Average all data within correlation table 0 269 Tati Phoenix Ore Lab Ro Conc Milled amp Site Hot Floats of Cl Feed ie Average Ro Conc Milled ac aE ai Average Between Fractions KGF down foeni IGF 0 0001 0 4632 0 5195 0 2642 0 0000 0 7412 0 4618 0 4981 0 4851 0 2894 0 0479 0314 0 1969 0 174 M Niece 0 346 0 2650 0 337 007611 C amp co 0 364 0 2965 0 344 0 200 m Eurus Mineral Consultants C IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 111 of 118 20 4 The Frequency Plot Function Before using the Frequency Plot function the user must select a column or columns of data to be processed The picture below shows two columns K and M IGF and KGS have been individu
120. o start creating matrices in an already open file then select this latter option and type the name of the destination file into the textbox taking care to type in the xls filename extension if required If the file was created by selecting File New from the Excel menus as opposed to a file opened with File Open then it will not have an xls extension until it has been saved for the first time The Conditional Formatting of the Resultant Matrix section allows the user to choose how ranges of coefficient values can be highlighted In this case all r values greater than 0 75 are in bold R a Eurus Mineral Consultants HUTS E IVI L 2007 Copyright subsists in this work mineral cc EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 107 of 118 blue 1r values between 0 50 and 0 7499 are in bold red and r2 values between 0 25 and 0 4999 are in bold black 5 The Miscellaneous Options section allows the user to define a heading for the correlation matrix which sequence of rows to highlight to make the table easier to read and whether to include average calculations A dialog box of a correlation matrix is shown below complete with the r value formatting and row highlighting as chosen in the Define a Correlation Matrix box To the right of the correlation matrix are the Averages between Fractions These are in groups of 3 as chosen in the Define a Correlation Matrix box The equation for t
121. o the Access or SQL Database No editing of data in this workbook is allowed The following warning and comment is posted along rows 1 4 of the worksheet You may not edit anything on this sheet as you could compromise the integrity of data posted to the database Note Data reflected under the test Info and Misc Parameters below is not automatically synchronised with its source data on the Summary Sheet If e g a test description is edited on the Summary Sheet it will only be updated on this sheet if a sort operation is performed on the Summary Sheet Data for these two headings is captured from the Summary Sheet before being posted to the Access or SQL Database If you want to duplicate this sheet to work with the contained data and any of the aforementioned data items has been edited on the Summary Sheet then this sheet may be updated by performing a sort operation on the Summary sheet Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 73 of 118 15 AVERAGE SHEET Functions available 1 Calculates the average of any number of chosen data sets 2 Transfers data to the Input Page for calculation of flotation kinetics gt Diagrams highlighting various points detailed below can be found towards the end of this section The average of any number of test data can be obtained by moving the data from the Summary LL Sheet to th
122. ocessed data which is sized to fit an A4 page when printed out The test currently showing on the Input Page is also shown on the Results Sheet The sheet summarises e Client plant and ore type e Test and sample descriptions e Test results recovery grade mass and head grade e Calculated kinetics before and after application of the boundary tests e Boundary test settings and e Arecovery time graph for all analytes and concentrate mass There are two buttons on the Results Sheet e Solve for Kinetic Parameters This activates the routine for calculating flotation kinetics Calculation can also be initiated sj n2 by clicking on the Solve for Kinetics icon and e Boundary Test Settings 12 1 Boundary Test Settings There are seven boundary tests that can be applied to the calculation of flotation kinetics A list is shown below There are certain conditions and shapes of recovery time and mass time curves that cause problems for correctly estimating kinetics The unmodified Kelsall equation is a two component system see section 4 It is not possible to fit a two component equation to a linear or near linear relationship In cases where recovery time and or mass time curves are almost linear i e the correlation coefficient r is equal to or greater than 0 9875 a solution can be generated where both fast and slow floating rates have equal values This is mathematically correct but does not occur in practice When both rates are e
123. od The third table from the top details correlations for rate tests conducted on rougher concentrate Here the slow floating Gangue rate is on a par with the overall average because floatable Gangue has been defined as including Fe and S as well as silicate minerals In this particular case Nickel and Cobalt occur in Pyrrhotite and Pentlandite which make up the majority of floatable mass and relative to rougher feed these have been concentrated in the rougher concentrate stream The purpose of regrinding is to improve liberation between mineral and Si and MgO bearing Gangue for subsequent smelting requirements The bottom table details correlations for rate tests conducted on reground rougher concentrate The effect of regrinding can be clearly seen from e The average of slow floating Gangue rate kGS dropping from 0 224 to 0 159 e The average of slow floating Nickel rate KNi9 dropping from 0 213 to 0 076 e The average between fractions dropping for Gangue Nickel 0 2610 to 0 1969 Gangue Cobalt 0 2717 to 0 2110 and Nickel Copper 0 3554 to 0 2650 Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 110 of 118 TP BMS Ore Site Hot Floats Rougher Feed Average across and Average Between Fractions down G amp N 0 180 0 2166 0 228 MS Niece 0 187 0 2026 0 232 0154 Cu amp co 0 174 0 2092 0 228 0 123 0 178 N
124. oll down the list and identify import errors highlighted by red font 10 8 Importing Data Batch Mode The procedure is the same as for Single Mode in section 10 7 except that Batch is selected when choosing an Import Mode In this case a folder rather than a file is selected in which there are a number of files The folder can be generated before calling up the Import Wizard KinCalc Data Import Wizard Step 1 of 4 Batch Mode Ed Save A5 Default c IVI V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 59 of 118 KinCalc Import Wizard Report Import Summary Total Mo af files read 1 Total Ma of Sheets ra be imported 3 Total Mo of Sheets imported successfully 2 Mote a successful import does not necessarily imply that valid data has been imported Total processing time 00 00 02 hh mm Some critical errors were encountered while importing data Please check the report below For warnings or Errors highlighted in red text IF you are unable to identify the cause of any errors that may have been encountered please try turning aff the aubo processing mode in the Import wizard and run the import again Single File Import started on 203206 at 13 37 00 Selected Format name IMF Lakefield File Path CAEMIC TECHNICALIZ ERIC F LOT amp TIOBRIIEINC AL OC Demonstration of KinCalckKinCalc demo folders File Name IMP Merz005 Lfield
125. omenclature before using KinCalc The descriptions and categories assigned to a test test conditions reagents and sample source will be carried through to the Access database These words and categories will be the ones that are used when queries and searches are done to retrieve data from the Access Database at some later date Therefore make sure that what is used is simple consistent and unambiguous See section 8 for further guidance Multiple KinCalc Programs open at any one time A single user whether operating a stand alone or multi user network version cannot have two or more versions of KinCalc open at the same time If this does occur the versions of KinCalc conflict and the system will crash If one version is closed the KinCalc toolbar will be lost Either save the open version of KinCalc close it and reopen or as per section 13 go to the Summary Sheet of KinCalc and click on the blue text in the box in row six Only the blue text may be edited this will bring back the KinCalc toolbar The multi user network version allows as many versions of KinCalc to be open and active as there are licensed users provided each user operates from a dedicated station Only the blue text may be edited Test Description Test Date APP line Amandelbult Rougher Fate Test on Primary Rougher Feed Sample OOO Bafakeng Merensky BAPM Plant Rougher Rate Test on Primary Rougher Tail Sample 02701706 RioMarcea Agua B
126. on Matrix 1 2 3 Average Between Fractions xwr kms 1GF kGF kGS iCuF kCuF kCuS INF KMIF kmis M amp G Macu mani 5 IMF 00022 0 8887 0 9804 00033 0 8827 0 3931 00073 00218 0 6758 00924 0 6276 8 kMF oos 00094 0 9990 00004 02331 0 9808 ooss 02409 0595 0 3933 7 kms 0 3652 ooo 0 9957 0 2601 00213 00046 0 7607 00130 0 5752 cecu Gami oom oases 0 3539 00012 00252 f 0 6196 00977 9 6630 ooon 02260 0 9769 00999 02317 00610 0 4035 0 2561 onov oost 0 7571 _ 00190 0 5722 cuani 02986 02241 0 4664 00004 00190 kGF 10 kGS 11 ICuF 2 kCuF oos 0 3626 00463 0 2684 8 kCus MOO INiF 15 kNiF No of Data Points 10 Note that multiple areas may be highlighted For example if IGF to kGS is to be excluded in row 39 see picture above then IMF to KMS can be highlighted from H39 J39 and then again from N39 539 to highlight ICuF to kNiS Highlighting of columns remains as J40 J49 or any other individual column covered by columns H to J and N to S Define a Correlation Matrix Correlation Matix Source Data Regions Summary 5H539 5 539 5ummary 5 539 5583 Header Eegion Rows or Columns to Correlate Summary 5 540 5 845 Correlation Matix Output Options The correlation matrix table would then be different to the one above and would become the one pic
127. onsultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 77 of 118 PGMs Recovery t1 PGR Grade git Time minz 1 Fa n r Mear d Line Gale 4 I Peset Active Data Set PP PGMs Reset Basis Mas Ganzgue Current Current giw PIPGMsF al IMF l 02757 ee uam Boundary Test Refresh P k 35000 kPGMsF 4 E pes o ER 0 0660 EM ish F pate TM 01044 f kPGMsS a n kMS aj 0 0041 on Actve Lab PiletPlant C Plant Gre Recovery Mass Y Tof oo fo 152 033 5498 m Pilot Pon mem T o Mazz Recorerg X PGMs Recovery t1 Time min Fninkr lar 4 Line Gale d Mass Recorery X Fnintr heard Line Calz 4 Copper Cu 3 3585 Nickel Hi 3 Q 45T5 ient Rio Marcea Site rate kest Back to Graphs Aquablanca 11 16 4 Identifying Suspect Kinetic Values Unfortunately there are some shapes of recovery time curve that do not conform well to the Kelsall two component equation and despite the protocols used in the various boundary conditions not all of these can be corrected automatically Eurus Mineral Consultants R A c IVI C 2007 Copyright subsists in this work gumus mineral consultants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 78 of 118 Usually as in the example table below problem recover
128. oose an acronym Hi KinCalc mem Stream Names jat jat jat jat jat jat jal jal iate Test on Secondary Rougher Feed Sample iate Test on Secondary Rougher Tail Sample iate Test on Secondary Rougher Conc Sample Loren n z mM Z Eurus Mineral Consultants E VIC L 2007 Copyright subsists in this work nus rnineral eonsuiants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 43 of 118 8 DEFINING OTHER TEST PARAMETERS Functions available 1 Define any test condition sample details or any other parameter that is required to fully describe the test 2 Select preferred units of measurement 3 Order the parameters as desired gt Diagrams highlighting various points detailed below can be found towards the end of this section Other Test Parameters covers anything of importance other than the specific items on the Input Page Any test and or sample description such as reagent type and addition grind sample depth sample condition or geographic location can be specified or SOL 8 1 Managing Other Test Parameters Click the Manage the List of Other Parameters icon to access the Manage Analytes and Minerals box Any parameter can be chosen and moved to the Selected box by double clicking on it The order in the Selected box may be changed by highlighting any parameter and clicking on the up or down arrow A new parameter may be inserted in the Availa
129. ormal pe a Multiple Data I Sheet 5 TEST Nos 2 6 GRIND 75um Ore Type Z E iv 7 REAGENTS rougher q Hnc Plant Name z R G 9 SIBX 10 Senkol 5 d 5 c 11 KU47 puc Test Description v 12 13 Test Date af Vv 7 Q0 Ce MEGA masso passus 0 oo BH Assay Units merged Assay Units jt with Assay Names J Feed Mass Feed Assays 5 22 CUMMULATIYE CONC 23 24 Rougher Tail M Tails Mass af 25 COMBINED TAIL 26 CALC HEAD 9990 M Tails Assays E _ 28 Measured Head IV Conc Tones x 23 30 j 31 Size Analysis IV Conc Masses g In Columns per Assay M Conc Assays Each column is a single region C In Rows per Assay NB When clicking Save you may receive a host of message boxes indicating errors have bega fected in ENT your format definition Some of the latter messages may be as a result of some of thge flier ones Make a note Save Cancel t rn 34 Sieve Size Range 35 m 36 150 Z A S ey of the first few messages and attend to those errors and the dependant erroyuwet ages should disappear 79 ES Po V 2782 r Z M 4 M ChartPlantMBRecTime 2 Normal Ro Rate 50 _ Normal Ro Rate amp S 77_Non 4 N Ready NUM start OM fli Demons E34Mic Gs Norton 3Mic c User M EN e nat t Of V 10 23AM Each Column is a Single Region e This is ticked
130. procedure must be run from a computer that does have it The only difference is that you will browse to the files in a shared folder on the network computer as opposed to on your local hard disk Again ensure that the HASP license manager has been installed and the HASP key is plugged into that computer As already mentioned this procedure only needs to be done once and only if the destination folder for the KinCalc Database installation was not c Program Files KinCalc irrespective of whether this was a network or a standalone installation 2 9 2 KinCalc Spreadsheet There are a few items that need to be attended to on first time use of the KinCalc Spreadsheet On loading the KinCalc Spreadsheet for the first time the user will be prompted to enter a password cock a sale Doacewrner urus amp int alc Password OK Cancel Ing Click on Cancel and wait for the spreadsheet to complete loading Instructions for preventing the display of this password prompt either upon loading or unloading of the KinCalc Spreadsheet are given in section 2 10 below Eurus Mineral Consultants n AYS IVI C O 2007 Copyright subsists in this work Nem crite EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 16 of 118 2 9 3 Locate the KinCalc Database If this was a network installation and the Database component has been installed in a shared folder on a remote computer the KinCalc
131. qual the fast floating fraction can be assigned any value between 0 0 and 1 0 without making any difference to the resulting mass recovery time profile and these kinetic data are useless for simulation Boundary test 1 therefore checks for high r linear regression Tests 2 to 7 cover the various situations that arise from high r linear regression High r amp low IMF All metals minerals Very high IXF amp very low kXS kMF limit All metals minerals Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 63 of 118 Clicking on Boundary Test Settings allows the user to select or deselect any of the tests Mass Gangue PGMs Coppe Cobalt Fast floating fraction Fast floating rate kF Slow Floating rate kS Mote Cells shaded green are equal to the category minima and cells shaded red are equal bo the category maxima Sum af Square Errors SSE 0 44 0 68 0 0 0 29 0 15 TESI Boundary Test Settings Enabled Linear Flag Y FALSE FALSE FALSE FALSE N FALSE ss FALSE FALSE FALSE ras FALSE KF value kS value Low far Metals High and Low kS far metals Linear amp Low for metals Low kS amp v High for Gangue Play KF Far Metal RE er ee lt Redraw Graph Kelsall Parameter Inspection Settings E Click B d test ICK On DOUN ary es Settings to call up the M Test2 Test
132. r gpt for g t Similarly any alias for such as perc percent pct or pctge can be recorded 6 2 Ordering Analytes and Saving Analyte Sets Analytes are arranged in the Available box in alphabetical order An analyte is chosen and moved into the Selected box by clicking on the name Names in the Selected box stay in the order they have been chosen This is to allow the user to arrange analytes in the same order as they appear in a data sheet be this left to right or up to down Sets of commonly used analytes can be saved by clicking Save and naming the new set in the Saved Sets box Any set of analytes in Saved Sets can be chosen and moved into the Selected box by clicking the Load button Saved Sets can be deleted exported or imported to other KinCalc or non KinCalc files 6 3 Analyte Aliases An analyte element or mineral can be known by any number of names or abbreviations and these can be loaded into the system via the Aliases button This allows the program to recognise any personal preference deviation or error in spelling etc between what is recorded in the Available box and the excel spreadsheet containing the data Data for the analyte will not be imported if a match is not found An example is show for PGMs Platinum Group Metals The Aliases function is particularly useful if data is being imported from a datasheet written in a foreign language For example copper in French is Cuivre hence the abbreviation of Cu and Cobre
133. reak the links bo this file by going to Links on the Edit menu and choosing the Break Links button These two Custom Graphs may also be added to the list of user defined Chart Types in Excel by clicking on the button above Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 92 of 118 and choosing the Break Links button These two Custom Graphs may also be added ta the list of user defined Chart Types in Excel by clicking on the button above Sample Graph Using One Y Axis X Series J Series 4 amp Series 3 Series x Series 5b x Series 6 Single Y Axis Graph _ gt gt Seres LDL Series 8 Series 9 Series 10 x Series 11 Series 12 Plain Title Sample Graph Using Qne Y Axis m Title Time mins Y Title Recovery 72 x 5 a a E gt gt Aa alor 30 Qe populo D o D E X E eK Time mins 19 CUSTOMISING THE GRAPHING FACILITY amp PROGRAM SETTINGS Functions available 1 Customisation of graph formats and settings for the KinCalc program 2 Specifying File Locations and User Interface gt Diagrams highlighting various points detailed below can be found towards the end of this section This function is accessed by the Customise Program Settings icon E located at the end
134. relation Matrix box the functions are numbered and the associated descriptions are listed below Where appropriate refer to further pictures and or diagrams below the dialog box of the Define a Correlation Matrix box 1 Click to define the header region Row H39 S39 has been defined 2 Click to define the rows or columns columns in this case Rows J40 J49 have been defined It is necessary to define only one of the columns from H to S because columns H to S have already been defined as the header region The function will not accept the selection of H40 549 The data being analysed may be in rows or columns If the data is in columns then the user must click in the Header Region box and then highlight a row of text containing the headers for each column Next click in the Rows or Columns to Correlate box and highlight an entire column of data under one of the headers including all the rows to be incorporated in the correlation analysis If the data is in rows the user highlights a column containing the Fa Af Eurus Mineral Consultants IVI V O 2007 Copyright subsists in this work 35 36 37 38 39 40 41 42 43 44 2r EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 106 of 118 header text and then a single row covering all the columns of data to be analysed It is quite likely that the main form will obscure the data to be highlighted but clicking on the right hand end of either of th
135. response TYPICAL RECOVERY TIME CURVES AND ASSOCIATED FLOTATION KINETICS wt Unaltered Silicate altered more than sulphide 0 Altered Unaltered Silicate altered more than sulphide 70 65 60 Altered ES 2 t gt O Q H c Mineral Gangue IPF kPF kPS IGF kGF kGS Unaltered 0 900 1 600 0 115 0 049 0 358 0 0063 Sulphides altered less than silicates Altered 0 510 1 130 0 055 0 249 0 353 0 0043 E lt c E Z E U Z O U c aa a el O z gt 2 O P lt 2 O Fa 4 0 766 0 642 0 097 0 152 0 032 0 0064 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 LABORATORY ROUGHER RATE TIME min Eurus Mineral Consultants k iVi L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 26 of 118 TYPICAL MASS TIME CURVES AND ASSOCIATED FLOTATION KINETICS DF Unaltered gt Silicate altered more than sulphide O Altered Altered Mineral Gangue IPF kPF kPS IGF kGF kGS Unaltered Unaltered 0 900 1 600 0 115 0 049 0 358 0 0063 Sulphides altered Silicate altered more Jis than silicates 0799 0 642 0 097 0 152 0 032 0 0064 than s
136. rious points detailed below can be found towards the end of this section 18 1 Using the Custom Graphs This is accessed by the Hut icon show the Custom Graphs Sheet This sheet has two graphs on it as shown below Each graph has a total of 12 lines which can be customised to suit the user The top graph is a dual Y axis graph and the bottom one is a single Y axis graph The blue text to the left of each graph can be edited to insert the desired title and axis descriptions Edited text may be made active on the custom graphs by clicking the Redraw Graphs button The button entitled Add Graphs to User Defined Types copies the graphs and loads them into the Custom Types User Defined section of the Excel Chart Wizard described by the ol icon The graphs may be right clicked and copied and then pasted into any worksheet of an open excel file Redraw Graphs Sample Graph Using Both Y Axes Add Graphs mm Series me Seres e Series 3 e Seriez 4 x Series x Series 6 Tamel Types Series 7 Oe Series 8 Series 9 Series 10 gt Series 11 Series 12 Dual Y Axis Graph Main Title Sample Graph Using Both Y Ares 5 Title Time min 1 Title Grade git ve Title Recovery X Grade git Recovery X CL Mate These sample graphs may be copied to other workbooks to ensure uniformity of the chosen settings For each series Once pasted in a new workbook b
137. rows to columns if an analyte name has been detected then it will be used as the column heading If an analyte abbreviation is detected then the first analyte name matching that abbreviation will be used from the list shown on the configuration form When transposing from columns to rows the analyte abbreviation will be used between the parameter identifiers in all cases e g for Copper the three parameters will be ICuF kCuF and kCuS Analyte abbreviations may be edited once they have been added to the list Highlight the relevant Edi row in the Defined Analytes list box and click on the button Edit the abbreviation and cave then click on n to complete the editing process It is often simpler to delete the faulty analyte Delete by highlighting it and clicking on the button and then re adding it to the list To add a new analyte and abbreviation simply type them into the correspondingly named textboxes on the form and save them If the textboxes are not empty because the user had earlier clicked on the edit button then click on the F button to clear them Done When the list of analytes and abbreviations is complete click on the _ Dm button There will be a slight delay before returning to the previously active spreadsheet while the changes to the analytes are saved in the add in file A related note is that the analyte names and abbreviations Va Eurus Mineral Consultants IU 2007 Copyright subsists in this work rem
138. rt Format Folder Filename IMP Plant Profile as EK DB Format Je Format Name x Impala 229 DB I Client Name Mine Iv Ore Type Plant Name Test Description Test Date M Assay Names v Assay Units Feed Mass Feed Assays v Tails Mass w Tails Assays lv Conc Times Iv Conc Masses Iv Conc Ass ays Impala Merensky 60S158 5ES138 3 54A557 515587 5A5104 515104 5 KX 5155 5E5155 5C5172 5E5172 m ALY Z EMC FLOTATIONXEINCALCXVBA Versions gt Required Item Choose File Text Instead of Include in Graph Cell Range Headings Data Sets Per Sheet Iw v One Data Set per Sheet E r Multiple D ata Sets per Sheet M v Offset bebween data sets Rows 16 NES m Columns p Dont offset Assay Mame and Unit Headings Assay Units merged with Assay Names Other Parameters Cancel In Columns per Assay Each column is a single region In Rows per Assay ME When clicking Save you may receive a host of message boxes indicating errors have been detected in your format definition Some of the latter messages may be as a result of some of the earlier ones Make a note of the first few messages and attend to those errors and the dependant error messages should disappear 10 6 Defining and Setting Up Other Parameters This is covered under section 8 1 10 7 Importing Data Single Mode Once an import format has
139. s can be chosen which set s of test data to display any combination of laboratory pilot plant and plant and which data set is active for kinetic estimation via the scrollbars 7 The mass gangue box shows whether mass or gangue has been chosen 8 The laboratory pilot plant or plant data may be accessed by clicking on the appropriate button The table for laboratory data obtained by clicking on the Lab button is shown below the picture of the ScrollCalc Page 9 Current kinetic values can be returned to their original values by clicking on the Reset button 10 The Refresh Graphs button changes the scales of each axis to suit the calculated data Thus if kinetic values are chosen which pushes the calculated line data off scale then this button will re scale the axes to suit the data 11 The button Back to Graphs on the Lab data page is positioned so that when the Lab button is clicked as in point 8 above the Lab data page comes into view and the Back to Graphs button is then directly under the cursor 16 3 Clearing and Transferring Data to the Summary Sheet Data can be cleared from the ScrollCalcTM Page via the icon If new kinetic values have been chosen as reflected in the current column of the analyte and mass gangue box see 4 and 7 in the picture below then these can be copied to the Summary Sheet via the icon ScrollCalc data is stored in the table titled Kinetic Parameters After Scroll Calc1M Eurus Mineral C
140. st on Secondary Rougher Tail Sample 04701706 i BRP Tests 14 5 Fiougher Rate Test on Secondary Fiougher Conc Sample 05 01 06 i BRP Tests 15 B Rougher Rate Test on Crusher Circuit Fines Thickener CIF 06 01 06 i BRP Tests 16 Y Awe of 4 tests 7 8 Sand 10 17 8 Ave of 4 tests 11 12 and 14 18 13 20 21 Kelsall 22 Indes 23 1 Fiougher Rate Test on Crusher Circuit Fines Thickener G F 06 01 06 i 0 00056 i 0 00056 _ 24 2 Rougher Rate Test on Primary Fiaugher Tail Sample 02 01 06 1 l 0 00070 0 00010 eh d Rougher Rate Test on Secondary Rougher Feed Sample 03701706 O 00005 i O 00005 zb 4 Fiougher Rate Test on Secondary Fiougher Tail Sample 04701706 O 00008 i i O 00008 er 5 Rowgher Hate Test on Secondary Rougher Cone Sample 05 01 06 O 00407 p 004 33 2c B Fiougher Rate Test on Crusher Circuit Fines Thickener CIF Den 0 00056 ART e3 T 0 00263 i 0 00260 30 8 0 00227 0 00224 31 32 33 34 Kelsall 35 Indes 36 1 Rougher Rate Test on Crusher Circuit Fines Thickener OFF 06 01 06 0 0621 0 0431 00056 0 0621 0 0431 0 00056 0 0032 a z Rougher Rate Test on Primary Fraugher Tail Sample nas 0 0386 0 0213 0 00070 0 0334 0 0213 0 00070 0 2414 38 3 Rougher Rate Test on Secondary Fiougher Feed Sample 03701706 0 0626 0 0172 O 00005 0 0626 0 0170 O 00005 0 3570 z z r Icons and sort highlighted data in ascending and descending order respectively These functions can be used for data in any colu
141. t Test Description Test Date i ame en 10 1 BCL Mining BEL Curli AARL 35 75pm PHF 4 1 11 e BCL Mining ECL CulfMi AARL 40 rhum FRF lz 3 BCL Mining ECL Cult AARL 45 rhum FRF 13 4 BCL Mining ECL Cult AARL 50 rhum FRF 14 h BCL Mining BEL CurlMi AARL 60 Spm PAP iF c Dub Biens dE diosa Bite er DERE RES eee earl coc Eurus Mineral Consultants c Wi C O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc T XI v2 1 July 2007 Page 46 of 118 2 3 4 Client 5 Ore Type B Test Description Y Test Date 8 Test Variation 3 10 Analyte Mames 11 Mickel 12 Copper 13 Cobalt 14 Iran 15 Sulphide Sulphur 16 17 18 13 2n 21 BCL Mining and Smelting uri Su 38pm Prim Mag Co Mi Cu Co Fe SIS 2 Flotation Feed Concentrate Clear Check Boos to temporarily omit apf Z Sample Zt Feed 28 Tails 23 Combined Cone 30 Cone 1 4 iy Ss EM H zu mam mineral cone demie AE 1 n earn L la ilg We Time E Eres BEEN 7 OO L L 768 1 5 91 Indes co lt J co cH F c2 D Input Rate Flotation Test Data KinCalc Manage Test Parameters Available 80 Passing Size A3477 g t Air Rate l min Cell size T Cell Size m3 Collector Dosage g t Comments 1 Comments 2 Cu504 g t Dep 267 g t Depressant Dosage gj Depth m Dow 200 g t FF 300 g t Fro
142. t is saved Note that the above procedure of locating the database file will only be required for network installations If a default standalone installation was done the database file will be located in c Program Files KinCalc and the KinCalc Spreadsheet will locate the database automatically Confirm Solver Reference Whether the procedure in section 2 9 3 needed to be performed or not the following steps need to be followed for all first time uses of the KinCalc Spreadsheet Look for the KinCalc toolbar which should appear near the top of your Excel screen Locate the 3x icon and click it to load the Application Configuration form Choose the User Interface tab and click the second item to select it so that your form appears as shown below a AG Eurus Mineral Consultants C IVI L 2007 Copyright subsists in this work z Ra EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 18 of 118 KinCalc Application Configuration Graph 5ettings Graph Series File Locations User Interface Wam about discarding Import Wizard report By disabling the removal of the reference the user will not be prompted to save the workbook every time they close it unless they have not saved it since they last made changes to the file IV Delete VB Code Modules on Import By selecting this importing o files should be speeded up significantly if they contained event driven code loggle Date If
143. tances when a spreadsheet containing raw test data contains VB code When using the Import Wizard this VB code can interfere with the import and calculation functions Toggle Date Format Clicking on this button changes the date format between mm dd yy and dd mm yy Toggle ScrollCalc Sheet Colour Clicking on this button changes the background to the ScrollCalc Page between white and coloured KinCalc Application Configuration Graph Settings Graph Series File Locations User Interface Database Fath CA Filename EinCale 002 mdb Toolbar and Menu Images C Program Files KinCalc Images Mote After clicking Cancel any changes made will remain in effect for the current session The changes will be lost if EinCalc is not saved After clicking Done please be patient while changes are saved r Eurus Mineral Consultants a 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 96 of 118 KinCalc Application Configuration Graph Settings Graph Series File Locations User Interface a By disabling the removal of the reference the user will not be M Disable the removal of the Solver reference prompted to save the workbook every time they close it unless they Iv Delete VB Code Modules on Import ien dns importing of files should be speeded up ipnificantly if they contained event driven code Toggle Date If your dat
144. te 2CaSO4 MgSO KoSO If water recovery is measured it is categorised as floatable gangue for the purposes of the KinCalc program Metal or Mineral is any economic material What Constitutes Floatable Gangue This can be tricky depending on how the economic metals occur in the ore and whether you choose to follow flotation response in terms of pure metal or mineral All scenarios presented below are correct and depend upon how floatable gangue is defined It does not matter which definition or view is taken as long as the preferred one is consistently used For example the table below compares a Platinum bearing Merensky ore with a high grade base metal ore from Canada For Merensky ore defining floatable gangue in terms of metals or minerals makes only a 0 45576 difference whereas it makes a 6 11676 difference for the Canadian ore Merensky cases A and B produce very similar gangue kinetics but Canadian ore cases C and D produce kinetics which are significantly different In each case both sets of kinetics A and B and C and D are equally correct descriptions of their particular systems Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 40 of 118 Typical Merensky South Africa Mass gr in 1 000 kg PGMs g t ie 0 0005 O Cuw 0 09 Mass of gangue 99 710 PGMs g t ie 0 0005 B Chalcopyrite Pentlandite
145. ted data of bin value number of data in each bin frequency and cumulative frequency are tabulated below each plot Individual and Cumulative Frequency Data Nickel Head Jan 00 Oct 06 14 0 12 0 10 0 9 8 0 Oo 60 sg 4 0 E v v ve ve v v v ve v ve ve O N lt O oo O N lt O oo O N lt O oo O N lt O oo O CY IN LD 10 W O O O O N KR Fr NR NR DBD HD GHB GB HD BA C O O O O O O O O O O O O O O O O O O O O Bin Values Histogram Plot Eurus Mineral Consultants k IVI L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 113 of 118 Individual and Cumulative Frequency Data IGF kas k kCus Frequency Bin Values Line Chart Plot 20 5 Change Default Settings for EMC Tools This function is activated by clicking on the ER icon This shows a Manage Settings dialogue box as per the example below There are four tabs Analytes Correlation Frequency Plot and Toolbar Analvtes This function is described under To Add New Analytes in section 20 1 It is similarly described under Manage the List of Analytes in section 6 1 Manage Settings Analyte Correlation Frequency Plot Toolbar Abbreviation _ 4 Analyte Save Abbreviation Eurus Mineral Consultants 2007 Copyright subsists in this work m Ta EURU
146. the Data sheet Show the Custom Graphs Sheet 5 2 Optional Extra Icons Transpose Kinetic Parameters from rows to columns in sets of three IMF KMF KGS Pastes values in keeping with font number and alignment format of worksheet Transpose Kinetic Parameters from columns to rows in sets of three IMF KMF KGS Creates a Correlation Matrix from selected data Creates a Frequency plot from selected data Change default settings for EMC tools Eurus Mineral Consultants O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 34 of 118 F3 Microsoft Excel EK 496 lt fe i S Eie Edit View Insert Format Tools Data KinCalc Window Help Type a question for help x Ose 6RY BB S o Bx 41i MBs B Book Antiqua 0 B Z U Wh Him GE 3em Y 53 5 saline es A E 2 BUE a Ti Z R E928 3 78 JS sie BiwaxtTet xz La amp iagxe 8t ed TestVariation v fe Sample taken after tropical rainstorm Ja 3 MEE gt 0 E r OG 8 j Input Rate Flotation Test Data dh ALCHE EMY SYSTEMS L Ltd Analyte Names Abbreviation Units Sesle Factor Category ID PGMs s 1 m 2 Copper Nickel Flotation Feed Concentrate amp Final Tails PU uu and uS Clear Check Box to temporarily omit analyte from the analysis O p DE es En n min or 5e 5 3 WW o 0 gt 7l gt A a gj EEO i 067 00113
147. ther Grind lt 75 Lim KU 20 g t Mote Parameters should be added with care as they cannot be deleted once they have been utilised 1 53 0 03 0 08 37 solids af solids arm solids 37 solids 37 solids ics better than boundary ics better than boundary ics better tha ics better tha ics better tha ics better tha ics better tha ar solids ara solids arm solids arm solids arm solids ics better than boundary ics better than boundary Cell size I PMNEX g t TFE 285 g t pH Comments 1 Comments 2 SIBX g t Dow 200 g t Cu504 g t Grind lt 75 um 33 24 26 40 m Eurus Mineral Consultants E oo SS mE O QOO b UUU 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 47 of 118 9 MANUAL INPUT OF TEST DATA Functions available 1 Input of raw data by hand or by copy paste function 2 Input of test descriptions and conditions by hand or by copy paste function 3 Input of other test parameters by hand 4 Screening of raw data via the Auto Report to identify data import errors before processing gt Diagrams highlighting various points detailed below can be found towards the end of this section 9 1 Manual Input of Test Data e Call up the Manage the List of Analytes and Minerals form e Select analytes and or minerals in the required order from the Available box or choose from the Save
148. ther mass or gangue The value of each parameter can be varied by clicking on and moving the central block on the scroll AR ag Eurus Mineral Consultants CIVIL 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 76 of 118 bar to the left or right Alternatively the value can be adjusted by clicking on either arrow at the end of the scrollbar IMF al I Nes kmr a LJ KMS 4 Click here to Click here to increase parameter value fine adjustment reduce parameter value Click here and drag block left to decrease or right to increase i ent lick either side of the drag block for larger adjustments 3 The live analyte is chosen from the drop down box 4 The analyte box shows which analyte has been chosen Kinetics marked original are those which have been calculated automatically via the Import Wizard or the Results Sheet and are recorded in the Summary Sheet Current kinetic values are the new values which have been chosen via the scrollbars 5 The sum of the squared errors SSE for calculated less actual for grade recovery and mass for the live analyte is shown in this box 6 What information is being displayed or is live i e being investigated is shown in this box By clicking on the appropriate button either mass or gangue can be selected as the basis for mass estimation raw ie without boundary tests applied or boundary test kinetic
149. tured below Correlation Matrix Average Between Fractions kMF kMS kCuF kCuS kNiF kNiS 0022 Dn 0 0057 No of Data Points 10 0 0921 g Eurus Mineral Consultants V O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 109 of 118 Example The four tables below show correlation tables for rate tests on a base metal sulphide ore on samples of rougher feed pulp down the rougher bank and rougher concentrate before and after regrinding A column manually calculating the average for each kinetic parameter both across and down has been added These values are tightly clustered around the overall average showing that for fast and slow fraction and rate there are no strong associations on a global basis when all components of floatable gangue and metal mineral are taken into consideration However there are strong correlations on an individual basis such as e Fast floating fractions and Gangue and Nickel IGF vs INiF of r 0 8780 top table e Fast and slow floating rates of Nickel and Cobalt KNiF vs kCoF and KNiS vs kCoS of r 0 8683 and 0 8637 respectively top table In the top two tables the averages for slow floating Gangue rate kGS highlighted at 0 085 and 0 136 are considerably less than the overall average and the spread of values for the rest of the kinetic parameters This shows that mineral gangue liberation in the slow floating component is go
150. uency Plot graph and the data which is tabulated below the graph can be made via the dialog box below The various options and settings are self explanatory Under Bin and Data Table Settings Top row of Data Table refers to the first row that the data table occupies below the Frequency Plot When a Frequency Plot is generated the graph is positioned between rows 1 and 28 As in the dialog box below the data table begins at row 35 and extends below this for as many rows as there are bins that have been specified Eurus Mineral Consultants n A IVI C O 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 115 of 118 Amalytes Correlation Frequency Plot Toolbar Bin and Data Table Settings j M Graph Position Settings Max No of Bins EJ Graph Left Column Top row of Data Table EJ Graph Top Row Column Indent for Data Table 1 gt Graph Width Column Width 10 5 Graph Aspect Ratio H W Graph Formatting Options Text Font Comic 5ans M5 Tide Text Size pts 14 V Bold Legend Position Top Other Text Size pts 10 T Boa Marker Size 5 Toolbar The location of the Toolbar images can be set up by clicking the Browse button The location will have been automatically set up when installation of KinCalc was done If KinCalc is copied to another PC then the location of the images
151. ulphide Bm Altered 0 510 1 130 0 055 0 249 0 353 0 0043 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 LABORATORY ROUGHER RATE TIME min EX un un 4 E B 4 Y HB Z E Z o L jaa D iei E O z gt K O B 4 2 O lt The link between Kinetics Mineralogy and Flotation Performance The flotation PID Performance Influence Diagram illustrates how mineralogy kinetics circuit configuration design and flotation performance are linked Flotation Performance Influence Diagram Flotation PID MINERALOGY D efines CONTROLS FLOTATION KINETICS Determines CIRCUIT DESIGN Affects FLOTATION PERFORMANCE e Reco Eurus Mineral Consultants c Wi C 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 27 of 118 4 2 Terminology and Acronyms Elements whether metal or non metal are referred to as analytes An assay is a measure of concentration of an analyte in percent or grams per tonne Various acronyms and descriptions are used as detailed in the table below Note that the table has been set up with reference to Nickel Acronym Meaning G INiF Fast floating fraction of Nickel kNiF Fast floating rate of Nickel kNiS Slow floating rate of Nickel _ Fast Floating Ratio INiF IGF the fast floating flotation fraction of FFR
152. via a customised toolbar no matter what spreadsheet is currently active This toolbar comprises the Transpose Correlation Matrix and Frequency Histogram Plot functions At the end of the toolbar is the facility to change the default settings for Analytes the Correlation Matrix and the Histogram Plot Transpose Kinetic Parameters from rows to columns in sets of three IMF KMF KGS Pastes values in keeping with font number and alignment format of worksheet EP TT Transpose Kinetic Parameters from columns to rows in sets of three IMF KMF KGS Creates a Correlation Matrix from selected data Creates a Frequency plot from selected data LA Change default settings for EMC tools I i Getting Started With the Add In Prerequisites The add in was written using Microsoft Excel 2002 with Service Pack 3 which is part of the MS Office XP suite of programs It is not guaranteed to work correctly with earlier versions of MS Office however since it references standard MS Office components it will probably work with Excel 2000 and even Excel 97 It is entirely compatible with later versions of Excel e g Excel 2003 Installation A setup program entitled EMC Utilities Setup exe has been provided on your software disc Find the file through Windows Explorer and double click it to run the installation Take note of the instructions and information displayed during the setup process Eurus Mineral Consultants c
153. when the assay values are arranged in successive cells It does not matter if assay sets are separated by a gap of one column or by three rows as per the examples below The fact that all assays are together is the key issue ASSATS PGM hu Cu Ni 3551 9551 14505 14505 23094 23094 1534 64 1959 6033 maz 10931 370 an vos 3168 2095 6168 100 iez 264 2798 i207 5539 ERE EE r ae 42 70 c IV j 2007 Copyright subsists in this work UNS mineral constants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 52 of 118 e This is not ticked when each assay is separated by a number of columns or rows as in the example below This is from a KinCalc Datasheet Assays for test 1 are in rows 146 163 and 180 and those for test 2 are in rows 147 164 and 181 144 Conc 1 Assays 145 Conc Assay 146 147 148 f 143 f 150 l 151 i 152 153 154 155 156 3 41 3 10 33 50 11 58 16 06 0 82 157 s i 3 41 3 10 33 50 11 58 16 06 0 82 158 159 160 161 Conc 2 Assays 152 Conc Assay Conc amp ssay Conc 4ssay Conc Assay Conc amp ssay Conc Aszay Conc amp ssagy Conc 4ssay Conc amp ssay Conc Assay Conc amp ssag Cone Assay 163 164 165 166 167 d b 168 i 1 169 Tr i 171
154. where within the highlighted ranges will always cause errors 20 3 The Correlation Matrix Function Often during analysis of large sets of kinetic parameters the user may wish to examine relationships between the parameters Instead of manually constructing a diagonal matrix of correlation coefficients using the MS Excel CORREL function the add in functionality was designed to automatically create such a correlation matrix for a user selected range In addition conditional formatting may automatically be applied to the resultant matrix to highlight coefficients that fall within three user defined ranges called upper middle and lower ranges The matrices created using this tool reflect the squares of the correlation coefficients of the arrays of numbers being compared hence the R icon Use of this tool is best explained by example To use this function click on the icon this shows the Define a Correlation Matrix box as per the picture below If the matrix being generated is not the first one in any particular Excel session then an attempt is made by the program to first jump to the data before displaying the form This is handy if the user wishes to generate multiple matrices trying various options using data from the same sheet If the program insists on jumping to a sheet to which you don t wish to go then Cancel click on followed by and then manually select the desired sheet To explain the various functions of the Define a Cor
155. wn in the example below First make sure that the document or spreadsheet into which you would like to paste the transposed data is already open in the appropriate application e g MS Word or another spreadsheet document in Excel before attempting to copy and paste using this transpose Add In If you get half way through the procedure and then find your destination document is not open you may have to perform the copy portion again as the clipboard is often emptied upon opening some documents PUR Al Eurus Mineral Consultants CIVIL 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 100 of 118 Next select the region to transpose Before using the transpose function from rows to columns the user must select a header row and data row You must select two rows The order is not important but you must select both the header row and then a single row of corresponding data as shown below To highlight two non contiguous blocks of data on a spreadsheet highlight the first and then hold down the CTRL key while highlighting the second row Selection of the header row must be done as a separate action from the selection of the data row The picture below shows both the header row of IMF to kNiS and data row of 0 1416 to 0 00250 have been highlighted In the Choose Your Options box the kinetic data has been rearranged into columns in sets of three fast floating fraction fast floating rate a
156. y pilot plant or plant data or any combination and the Test Date may be chosen Test date or dates may be entered as shown below When the required categories have been selected then click the Import button to load the data into the Summary Sheet Eurus Mineral Consultants c IV L 2007 Copyright subsists in this work EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 90 of 118 Import From KinCalc Database E BRPM Plant GF Plant L UG 2 Min Proc EN Plant Blend Gold Mechanised Merensky S S I SE BiolJarcea IMormal Two a mur m f AIA ILIA T Z EIEIEIEIHEIEI 1 1 2006 C AllDates Before After Between dd mm yyyy 1 1 2006 matching records Prim Rougher Conc KU 20 g t Prim Rougher Feed EU 47 g t m Prim Rougher Tail Sascol 61 g t Sasfroth 169 g Senkol 5 g t S ES IS ST IST 2 matching records Eurus Mineral Consultants A A IVI C O 2007 Copyright subsists in this work unus mineral consultants EURUS MINERAL CONSULTANTS User Manual for KinCalc v2 1 July 2007 Page 91 of 118 18 GRAPHING FACILITY Functions available 1 Choice of two customised graph formats with single and dual Y axis 2 Loading of these customised formats into the Custom Types User Defined section of the Excel Chart Wizard gt Diagrams highlighting va
157. y test one for pilot plant measurement and one for plant measurement The categories of lab pilot plant and plant are designated on the Summary Sheet in the Miscellaneous Parameters table column heading Lab or PP or Plant in column P If the data set has not been labelled the program assumes that the data originates from a laboratory scale test 16 2 Using the ScrollCalc Page ScrollCalc involves using manually driven scrollbars to change and or estimate the kinetic parameters of any chosen analyte mass or floatable gangue Via the Kelsall equation see section 4 these generate calculated recovery grade and mass which are shown on the graphs as lines Measured actual data are shown as points Three sets of data lab pilot plant and plant have been loaded into ScrollCalc as per the dialog box below The various functions available on the ScrollCalc page have been numbered Descriptions relating to these numbers are given below 1 The ScrollCalc page has 4 graphs Clockwise from top left they are a Recovery Time and Grade Time b Recovery Grade c Mass Recovery Time and d Recovery Mass Each graph shows measured data as points and calculated data as lines The calculated data is derived from the kinetic parameters via the Kelsall equation see section 4 In the legend of each graph laboratory data is designated by L pilot plant by PP and plant by P 2 There are 6 scrollbars 3 for the analyte chosen and 3 for ei
158. y time curves have been identified and already subjected to adjustment by the boundary tests These can be identified when on the Summary Sheet by clicking the icon However this may not always highlight those sets of kinetics which require a further look It is worth running your eye down each column to pick up problem values according to the following guidelines IGF values equal or close to 0 0619 kGF values at the maximum value allowed of 2 5000 kGS values less than 0 00001 or equal to 0 00000 kMetF and kMinF values at the maximum value allowed of 4 5000 and kMetS and kMinS values less than 0 0001 or equal to 0 0000 ois eger Note that it is unusual for gangue and metals minerals to have values at the limit as per points 2 to 5 above The table below marks two such instances 1 where IGF is 0 0619 and 2 where kGS is 0 00001 1 TestDescrption TestDate IMF KMP N KMS IGP kGF kas INE kMiF f kms 20 05 05 0 00236 0 02356 20 05 05 l 0 00146 i 0 01348 20 05 05 DOS 0 00228 i 0 01608 20 05 05 OTE 00166 0 01230 20 05 05 i 0 00174 i 0 01077 20 05 05 0 00168 O 00166 0 02183 20 05 05 0 00051 0 00051 0 01105 20 05 05 0 00030 0 00030 i 0 00970 20 05 05 0 00033 oos moss 0 00033 0 01143 20 05 05 0 00051 0 00051 0 00441 20 05 05 0 00030 0 00027 0 01132 20 05 05 0 00091 0 00031 i 0 00574 20 05 05 0 00001 0 00001 0 00703 20 05 05 0 00067 0 00067 0 00650 200505 0 00083 0
159. your dates are appearing incorrectly on the Summary E dd mm yy Sheet try clicking this button to choose an alternate date format Format If you dont want a coloured background when printing Toggle Scroll Calc Calomzed the Scroll Calc results page then turn it off here Sheet Colour Mote After clicking Cancel any changes made will remain in effect for the current session The changes will be lost if RinCale is not saved After clicking Done please be patient while changes are saved o EE Click Cancel to accept the change made don t choose Done as that saves the spreadsheet immediately and then close the KinCalc Spreadsheet opting to save it by clicking Yes at the following prompt KinCalc D This file has unsaved changes Do you want to save it Yes to save and close Mo to close without saving Cancel to go back to KinCalc MCN The reason for the above procedure is that each installation of Excel provides its own Global Unique Identifier GUID for the Solver library file Provided that Solver is installed on the installation computer the KinCalc application will load a reference to Solver This only needs to be done once per computer on which KinCalc is installed so upon loading the file for the first time and successfully creating a reference to Solver the need to load it again may be disabled This is what is being done by selecting the checkbox shown abov

User Manual for KINCALC v2_1 Jul 07

Contents

Download Pdf Manuals

Related Search

Related Contents