Debswana Orapa and Letlhakane Mines – Using Wonderware Data Historian to build reporting tools

1. Debswana Orapa and Letlhakane Mines – Using Wonderware Data Historian to build reporting tools Kabo Phetlhu IT Analyst - Systems

2. Introduction Project Solution Agenda Benefits Considerations Summary

3. Debswana Diamond Company Two Geographically Dispersed Operations Product: Diamonds

4. Orapa & Letlhakane Mines Overview Orapa Damtshaa Letlhakane No. 2 Plant No. 1 Plant 3mtpa 0.6mcts/a 9mtpa 7mcts/a 3.7mtpa 1mcts/a 10mtpa 11mcts/a CARP To FISH (Jwaneng Mine) 19.6mcts/a

5. Diamond Production by Value - 2006 (US$12.8bn) Statistics based on 2005 figures: Source DeBeers Report to Stakeholders 2005/6

6. No real history • Error prone reports • Time consuming exercise manually logging data • Requirement for data clerks who were being phased out Quest for information… EXCEL REPORTS DISTRIBUTED OVER NETWORK MANUAL DATA ENTRY AND FORMATTING

7. Introduction Project Solution Agenda Benefits Considerations Summary

8. FUTURE Treatment Information Management System Context

9. Why Wonderware Historian? • Fully configured Microsoft SQL Server database for Production Plants • High speed data acquisition and storage system • Microsoft Office based reporting tools • Graphical trend analysis • Web reporting functionality • High data availability support

10. Data Historian Setup

11. Data Historian Solution in action… • Using Active Factory Trend for Headfeed trend analysis • Using Active Factory Workbook for Headfeed analysis • Using Active Factory Workbook to automate Shift Hourly Log file

12. Introduction Project Solution Agenda Benefits Considerations Summary

13. Benefits • No data clerks required to capture data from the SCADA onto the hourly shift log spreadsheet • Savings of minimum BWP 256 286.00 (ZAR 297 291.00) – from Jan – Nov 2008 • Process Engineers have more time to do qualitative analyse of data rather than compilation • Customisation of reports • Reduction in the number of errors in reports due to manual capturing of data • Improved historical data storage • Provides platform for interfaces with other systems

14. Introduction Project Solution Agenda Benefits Considerations Summary

15. Specialisation Performance Collaboration Technology Focus Business Solutions Project Implementation Project Management Considerations People and Processes

16. Introduction Project Solution Agenda Benefits Considerations Summary

17. Conclusion • Solution delivered successfully • Customer satisfied solution delivered when data clerks phased out • Roll-out solution to other plants • Wonderware Data Historian to serve as the foundation for future MIS solutions across Treatment plants

18. Thank you