Survey Tracker – Access-Based

With one click, BHP can import to and export survey data from Excel, delivering faster, more accurate recording, reporting and tracking.

Issues

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.

Solution

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:

• Swift, one-button survey data imports
• Detailed data error reports and editing functionality
• Data validation ensuring all data entry steps are completed
• Tracking by job number (from scoping to reporting)
• Reporting tool (based on metrics and survey types) exports back to Excel

In addition, the reporting module produces such statistics as:

• Number of km2 covered per day per type of terrain
• Dollar spend per km2 covered per type of terrain

Benefits

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

Similar Clients

Other similar case studies you may wish to review:

• Women's Healthcare Association
• Georgiou Construction
• Jan de Nul
  Rostering, training needs analysis, time sheets, workplace information, reporting