The Use Of Computer Spreadsheets In The Mineral Industry

We will bet you that, without prior programming within 10 minutes, we can design and simulate a 10,000 unit operation separation circuit. We will even do it at your place. We do it all the time. [ ] There are no tricks; we do it in a spreadsheet. We do it in those user friendly spreadsheet such as Quattro Pro. Spreadsheets must be user friendly. Accountants use them as do managers, business men, lawyers, doctors and salesmen. What these users seldom realize, is how powerful a mathematical tool a spreadsheet is. Among their other capabilities, spreadsheets can do a finite element analysis. That is why they are useful for accounting. That is also why they are more useful to engineers in the mineral industry. Spreadsheets are ideally suited for the engineering problems in the mineral industry. We have used then for solving problems in: a) mine ventilation; b) circuit design and optimization of dense media, flotation and sizing; c) comminution circuit design; d) shaking tables; e) Humphrey spirals; f) sluice ways and channel flow; g) lock particle and liberation problems; h) tunnel and shaft stress problems; i) cascadograph simulation; j) complex heat transfer problems; k) flow in porous media; and sheet flotation (Figure 1). Mineral industry problems presented on or with a spreadsheet are an excellent teaching instrument, problem statement and solution tools and sales devices. Spreadsheets answer easily, quickly and reliably many mineral industry engineering problems. What makes spreadsheets so useful to the mineral industry. The short answer is: they are easy to use; mineral industry problems fit the spreadsheet format. Those reasons are part of the answer. The real answer lies with the structure of the spreadsheet itself. Essentially, a spreadsheet is a "finite element analysis" form of computer software. Many mineral industry problems are readily solved by finite element analysis techniques. While some in the mineral industry may think they have never heard of finite element analysis, most use it weekly if not daily. Any profit and loss statement is essentially a finite element instrument. In fact, any array of numbers where one number is related to another may be construed as a finite element analysis product. Finite element analysis is a common daily activity. To get an appreciation of a finite element analysis, think of a monthly sales forecast for the next year. For each product and for each month, there exists a dollar figure for the forecasted amount of sales. In the forecast statement, for a given product in a given month, there is a "box" where the forecasted figure is presented. The forecast figure in that box was arrived at through some type of formula. The formula probably required some information from other neighboring boxes in the master forecast statement. Voila, one has a finite element analysis. Today the analysis would be done in a spreadsheet. A typical mineral industry problem is ventilation in an underground mine. Think of a rectangular room and pillar mining operation. Each room has air entering at a given pressure and velocity and air leaving at another pressure and velocity. During steady state, the air entering and leaving the room is determined by conditions in the adjacent rooms. One can readily model the room and pillar mine layout in a spreadsheet, and then find the flow in and out of each room at steady state. Change the flow by moving a brattice cloth or blocking off a path way and one gets a new air flow profile. Change the numbers on the spreadsheet that reflect