With one click, BHP can import to and export survey data from Excel, delivering faster, more accurate recording, reporting and tracking.
BHP Billiton is the world's largest diversified resources company and an industry leader in the supply of iron ore to the global market. As they expand every facet of their Iron Ore business, BHP’s Heritage Survey Department requires the support of a robust project data recording, reporting and tracking system. Up until now, all heritage survey data had been painstakingly analysed (manually) in Excel to maintain compliance with state and federal heritage and environmental legislation and government administration requirements.
We developed an Access database with the capability to import all project data from Excel spread sheets into pre-defined fields with the touch of one button. Once all data is in the Access system, reports can be run and exported back to Excel. Key features include:
In addition, the reporting module produces such statistics as:
The new Access-based survey tracking tool is far-and-away more powerful, accurate, efficient and scalable than the existing Excel-based process. Delivering increased functionality and survey data storage, BHP now has the capability to make one-button data imports and exports to Excel with ease and accuracy.
"We thank you for your expertise in helping us develop the tool and would not hesitate to contact OneIT in the future should we need further or new development"
Paul Berry, Principal Advisor Heritage, BHP Billiton Heritage
Other similar case studies you may wish to review: