DCP Import & Parameter Calculations

Image of Automated Scala (DCP)

Eliot Sinclair Partners Ltd required a system to import data produced by Canterbury Geotest from their hydraulic scala / mini CPT rig.

Geroc developed a simple conversion tool to extract data from multiple .dat files into a single Excel spreadsheet that could be imported with a simple mapping.  Seperately calculations were developed to generate parameters used for design.

They are now able to import data, calculate design values and generate reports from a days testing in just a few minutes.

Data Synchronization

Data Synchronization

Geocivil Ltd needed, for efficiency reasons, to enter a number of tests directly into field devices, with later synchronization of this data into a central database once devices had internet connectivity.

Geroc developed the SYNC Add-in (based on the Microsoft Sync Framework) to provide bi-directional synchronization of data (including lookup values and templates) between a central HUB database and 5 x SPOKE databases running on Windows tablets.

CPT Parameters

Image of CPT Parameters

McMillan Drilling Services Ltd required a system to generate a number of parameters derived from CPT data collected from their rigs.

Geroc teamed with McMillan Drilling Services Ltd to develop a process that would run efficiently within their database to avoid the need to process data externally in another application.

This process is available for other customers.