EDM Solutions is a software development company focused on streamlining, organizing and presenting data for a variety of geological environments. Our product, “the EDM” is a web-based data management system designed for mineral exploration, development, and mining projects. As such the EDM also supports data management for other industries utilizing similar surface, drilling, and analytical data collection processes.
Being web-based, there is no software installation required. The EDM allows maximum flexibility and utility, enabling surface and drill data to be entered on the fly from anywhere in the world, processed, and then presented in attractive, customizable user reports for all stakeholders.
The EDM has been used to manage active drill programs around the world for nearly a decade and the results are impressive. In one installation alone, the EDM resulted in a 75% reduction in manpower requirements. It is the only web-based solution for the mining industry. The EDM’s web-based nature allows real-time access to geologic and analytical data, which ensures rapid, informed decision making.
Would you like to know more? Please look through our website, contact us at firstname.lastname@example.org or call 1-800-925-7751.
What is EDM?
The EDM SQL database was developed in the early 2000’s to answer the need to manage an active drill program with multiple projects and 30 plus drill rigs. The initial application resulted in a 75% reduction in manpower requirements, while providing real time access to geologic and analytical data. By the late 2000’s, based on multiple client feedback the EDM was migrated to a web based user interface and the functionality was expanded.
In 2010, EDM Solutions was formed and the application was further expanded to support multiple customers utilizing a cloud based secure hosting service. While initially developed to meet the needs of gold centric projects, the application is currently utilized in gold, porphyry copper, and rare element systems. As a result the application is now easily adaptable to any metallogenic system and is currently utilized on projects worldwide by various clients.
The EDM SQL database includes tools that minimize the time between data acquisition and availability to end users. Our product reduces data management cost by simplifying workflows. We help increase data accuracy by maintaining control over data integrity and security.
Companies using the EDM application benefit from streamlined data flow to key experts during 43-101 resource evaluations and feasibility studies.
Management & Directors
Dan has over 30 years of experience in public accounting and financial management knowledge. After graduating from the University of Utah, he joined the firm, Arthur Andersen and Company, in Los Angeles. There, he serviced small businesses while taking additional audit and tax training through the Arthur Anderson college in St. Charles, Illinois. A few years later, Dan obtained a Masters of business administration from the University of Colorado, Denver.This launched him into a prestigious financial management career holding positions in Fortune 500 firms including Glamis Gold, Ltd., AMOCO, and TENNECO. Starting as an accounting supervisor, Dan’s keen accounting knowledge and strategic insights earned him challenging positions as a corporate controller and finally Chief Financial Officer of a New York Stock Exchange listed company. As CEO of EDM Solutions, Dan will be guiding growth and expansion of the company around the world.
Over 40 years experience in the mineral exploration and gold mining industries have led Robin Hendrickson to form EDM Solutions, Inc., to develop commercial web-based database management system for the minerals industry. His career long focus on computer technology has seen Robin consulting on database, development and information system projects as well as providing technical direction and computer software assistance to exploration offices in the US, Canada, Mexico, Brazil, Chile, Kazakhstan and Kyrgyzstan for a variety of clients. Previous clients/employers include Barrick Gold, Placer Dome, Santa Fe Pacific Gold, and Spirit Minerals.
Based in Alaska and Nevada, Dennis Geasan's GIS consulting profession has taken him throughout the USA and Canada working on projects for both public and private groups that utilize the ESRI GIS software technologies. He has over twenty years of work experience with GIS, data management, computer operating systems, and software programming gained from previous employment and for the past 12 years working as a consultant. During this time he has led and assisted with projects that cover a wide diversity of needs gaining experience at many levels directly applicable to the building and maintenance of a GIS. Dennis has also provided project specific ArcGIS Desktop training to various clients and currently through GIS Technologies provides a three day ArcGIS Desktop class designed specifically for Geoscientists.
With more than 20 years of experience in geostatistical processes and analytical methods, Debbie Schneider brings critical expertise to the EDM team. Debbie has successfully owned and operated a Geologic Computer Applications consulting business that provided computer services to the mining and environmental science industries. Expert at 3-dimensional geological modeling, she has developed and implemented computer methods to analyze spatial geological data using GIS, database and graphics software for precious metals exploration through development-level projects. Proficient in ArcView, MapInfo, Discover/Discover 3D, Gemcom, LeapfrogGeo, Access, and Excel, she has organized and implemented software training programs for client employees.
Tim B., V.P. ExplorationJanuary, 2019
We inherited a significant amount of historic data on our gold exploration project from previous operators. Our problem was the large number of spreadsheets that held the historic data for the various drill programs and geochemical surveys. In addition, the logging intervals did not match the assay intervals, which makes analyses with assays difficult. All of these data needed to be consolidated, leveled and updated in a central database that could also receive new data from projects which were in progress.
Several discussions were held with EDM about the challenge of organizing our data and it became clear early in these discussions that EDM understood all of the issues and were ready with a database solution to solve our problems.
EDM’s experience with setting up a database the right way is best shown with an example. Our database was set up to import assay certificates and this allowed us to access data that we never thought we would need. I needed to export the analytical method used for all the assays along with the sample IDs and, as it was already imported, a quick query exported the data.
“The EDM” is a multi-user web based exploration Data Management System designed to meet the real-time dynamic needs of exploration and development projects, significantly reducing data management costs and increasing data accuracy.
The EDM has much more flexibility and utility than frontends to typical mine planning software packages.
Being web-based allows management as well as technical employees immediate access to data utilizing a SQL Server® based security model ensuring data integrity and improving report turnaround time.
No software installation is required. All data is loaded via laboratory certificates or Excel® Spreadsheets utilizing Internet Explorer®, or other browser, and an internet connection.
Audit trails are maintained on all primary tables allowing change tracking when required.
Microsoft SQL Server® database allows third-party software to connect remotely via ODBC.
Client has the ability to generate canned as well as user customizable reports and export files.
Customized export formats can be generated to client specifications minimizing reporting delays.
The home screen from our Training Site is shown below. The basic concept is to provide access to all information concerning a particular drill hole from one screen. Note there is a separate tab for surface or point samples as well.
Typically data is uploaded from customizable Excel® spreadsheets, although direct entry on web forms is supported if internet access is available. Assay and geochemical certificates received from labs are imported and stored in an isolated repository. Data from this repository are posted to the assay, geochem, and QaQc tables based on rule sets managed by client-designated user.
Surface samples or other point sample data can be entered directly or from Excel® spreadsheets. Assay lab files automatically post to the surface sample table following the rule sets mentioned above.
Geologic logs can be entered using basic import template or user-modified import templates. Management of different log versions, including relogs, is quick and easy.
Bulk Data Importing
Historic and other forms of bulk data can be imported from spreadsheets utilizing the geologic log import module.
Drill Hole Header/Collar
Drill Hole Surveys
Geology Drill Log
Surface or Point Samples
There are numerous data validation routines employed in the system. For example, when lab files are imported, lab methods and elements are checked against look up lists. Look up lists are also utilized for all geologic parameters. Each project can have a unique set of look up lists. Referential integrity is enforced on Project, Holename and Depth in primary tables.
A security model is employed with SQL Server® to limit permissions based on assigned roles. For instance, all valid users are able to view most data but are not allowed to make changes. A user assigned to the Geology role can modify geologic records but cannot create assay records. The security model is managed from an administrative form by a client-designated user.
Changes to data in the primary tables are audited in the background so there is a complete list of changes available indicating what, when and who made them.
User customizable reporting is available along with various standard reports. Export files can be created to support virtually any third party application. Significant intercepts can be calculated and stored using a user configured color-coded interactive form.
Compositing (GxT calculator)
Significant Intercept Calculation
RC Sample Generator
Sample Data Digger (Quick Find)
Geology Log Template Mapping
Lab Method Management
Surface Sample Management
DH Data Delete
Remove Header Records
QA QC Charting
Feature Request Submission
Geodata Digger Report *
Drill Hole Table Data Exporting
Drill Hole GeoData Exporting
Drill Hole Assays Complete Report
Drill Hole Recent Changes Report
Drill Hole Assay Report
Results By Method Report
Drill Hole Header Report
Surface Sample Data Report
Certificate Surface Samples Processed Report
Automated Email Reports
ODBC Support For 3rd Party Software
*Geodata Digger Report allows the user to simply select via menu check boxes any custom combination of drill hole analytical and/or geologic variables, (click here to see a report example). Geodata Digger Report format can also be used to export custom data sets.
Our pricing is dependent on the needs of your application. In addition to the EDM application itself we offer a full line of support services to help you get a handle on your data. Please contact us to discuss your organization's requirements in more detail. Contact Us for pricing and customization options.
What help does EDM offer you?
EDM associates are available to provide direct data organization and management support, to help you address the ‘Where do we start?' question. EDM associates can:
Review and consolidate digital and hard copy data
Integrate historic legacy data, including automated assay unit conversion
Load all data and verify it
Configure custom reports to meet client specifications
Configure custom output formats to meet client specifications
Train client staff
EDM associates can also provide ongoing support for new data upload, verification and reporting in the event in-house resources are unavailable. Please Contact Us for pricing and additional information.
Help with your EDM installation
EDM Solutions is committed to providing full support for our loyal customers. Our comprehensive training on the usage and best practices of the EDM will ensure you and your employees get the most out of your EDM installation.
To that end we are providing a series of video tutorials on how to best use the EDM to achieve your goals.
Watch this space. Our video tutorials will be up soon.
Environmental Data Managment Application
EDM Solutions is currently developing an Environmental Data Management application.
Please contact us if you would like more information on this exciting new product.
Watch this space for new developments.
We would be happy to give you a demonstration of the EDM and/or setup a personal account at your request in our training database.