DRILBASE and PROSBASE Mining Exploration Databases Programmed to Run Under FoxPro(tm) by David J. Griffith 305 Carson View Markleeville, CA 96120 phone/fax: 916-694-2168 DESCRIPTION Requires FoxPro(tm) Version 1.02 or later. Copyright (c) 1986, through 1991 David J. Griffith Introduction The DRILBASE(c) and PROSBASE(c) program packages were designed because I was frustrated with the inadequate databases that accompany most mining exploration and development software packages. While they have improved greatly over the years, the better packages from an engineering and geologic stand point still are not great databases, they are not versatile and document the data poorly. This package was written to look after the data and feed it to whatever engineering/geological software package one prefers to use, and to let the engineering/geological software do what it does best. It is an economical and efficient package that is intended to supplement, but not replace your preferred engineering/geological software. These programs were originally written in late 1986, and based on the expanding needs of the organization I was working with they have been considerably enhanced since then. The xBASE languages were chosen because of the tremendous flexibility they allowed and the widely accepted DBF format for the data files. The programs were first written in dBASE III+, then ported to FoxBASE for added speed, and finally ported to FoxPro for still more speed and features. For comparison, FoxPro runs at 6 to 10 times the speed of dBASE IV, and well over 10 to 20 times faster than dBASE III+. Due to the use of the xBASE languages, if there was a special need it could usually be handled at the keyboard by a geologist or engineer without a lot of programming experience. All of the data is kept in dBASE DBF files so it can be accessed by any xBASE language if necessary, and most other databases systems have the ability to directly import and export a DBF file. In short, these packages will look after your data and export it to specialized programs for reserve estimation, statistics, geochemical contouring, drafting etc. Capabilities DRILBASE can handle as many drill holes and samples as you have disk space. It allows up to 20 assays per sample and 20 geological characteristics per sample, and can have an unlimited number of down the hole surveys. Entry of the sample intervals is semi-automated with several sample naming schemes supported. Underground workings can be digitized and treated as drill holes. Currently direct importing of assays from Bondar-Clegg, Chemex, GSI and N.A. Degerstrom assay labs are supported, and on registration of the program you are entitled to a free add-on for the lab of your choice or the printer driver of your choice. Check assays can be averaged and given user assigned weights. Drill logs are designed by the user. Length weighted averages can be calculated and output to an included Lotus 123 spreadsheet that will calculate the reserves by cross section. Data can be output to MicroMODEL, or comma delimited, blank delimited or SDF files to be read by other programs. For a modest fee I will write the interface to any program or digitizer you require. Online context sensitive help is available at the touch of a key. Output to an AutoCAD DXF file is in progress and should be complete along with the related Autolisp programs some time next year. PROSBASE can handle as many rock or soil samples as you have disk space for. Samples are input from a digitizer. Assay labs supported for the direct importation of assays are the same as for DRILBASE. On registration you are entitled to either one additional assay lab. Up to 30 assays per sample are allowed. Output is to comma or blank delimited ASCII files, SDF ASCII files. Golden Software's SURFER is supported. AutoCAD is supported and an Autolisp program is included along with a drawing that contains the necessary points. For a modest fees I will write the interface to any program or digitizer you require. Online context sensitive help is available at the touch of a key. Copyright These programs are shareware. You may use them for 60 days at no charge, but if you keep them after that you must buy a license to continue using them. A license is good for one copy of these programs on one machine. All rights are reserved to David J. Griffith, except those specifically granted by this paragraph, and once paid for, the license. You may not incorporate these programs or the procedures therein in any product that is produced for third parties without the permission of the author. A copy of this copyright notice is to remain at all times with these programs and derivatives thereof. Details of the license agreement are found in the help files that accompany the programs. Current prices for a license are US$450.00 for DRILBASE, US$250.00 for PROSBASE, or US$600.00 for both if they are purchased at the same time. Warranty. These programs have been tested on numerous projects and found to give true and accurate results. However the author does not accept responsibility for any errors resulting from your use of these programs, and is giving these programs to you on the condition that you hold him harmless from any adverse circumstances resulting from the use of these programs. Your use of these programs is acceptance of this condition. If you don't agree with this condition, give the programs back and don't use them. Support Registered users are entitled to whatever reasonable telephone support is needed, provided they are willing to pay for the long distance charges. Minor upgrades will be distributed at no charge to registered users. For corporations or individuals worried about what happens if I kick the bucket, the source code is available for a higher price, although the data is kept in the widely accepted DBF format and so will always be accessible to anybody with a dBASE clone. System Requirements. Minimum system requirements are an IBM PC or 100% compatible with 640K ram, a 1.2 megabyte 5 1/4" floppy drive, a hard disk, monitor, IBM Graphics or Epson compatible printer which accepts 15" wide paper, a Calcomp 9100 compatible digitizer (for PROSBASE only), and FoxPro Version 1.02 or later. Recommended system requirements are a 80386DX or better AT or 100% compatible with 4 megabytes of ram or better, a 1.2 megabyte 5 1/4" floppy drive, a 25 ms or faster hard disk with better than 250,000 Kb/sec transfer rates, IBM Graphics or Epson compatible printer which accepts 15" wide paper, a Calcomp 9100 compatible digitizer, a modem, an 80387 math coprocessor, standby or uninteruptible power supply, a memory manager such as 386MAX or QEMM and FoxPro Version 1.02 or later. A disk cache and print spooler such as Power Pak from Multisoft is also highly recommended, and will also dramatically improve the performance of your reserve estimating software. The hard disk requirements depend on the size and number of your projects. A small size drill database with 10,000 samples requires about 10 megabytes of disk space or about 1 kilobyte per sample, a geochem database with 10,000 samples requires about 3 megabytes of disk space, or about 300 bytes per sample. If you plan to work on more than one project at a time, or work on one project using more than one computer, a dual 44 or dual 90 Bernoulli Box or equivalent is also recommended. The programs require 1.5 megabytes of disk storage if you have the source code, 0.75 megabytes if you have the object code. Files. DPBASE.TXT This file. DPBASE01.EXE Self extracting archive that contains the DRILBASE and PROSBASE programs. DPBASE02.EXE Self extracting archive that contains supplemental DRILBASE and PROSBASE programs. The above files should be copied to a new directory where you intend to install the DRILBASE and PROSBASE programs. Then enter the command DPBASE01, and when it is finished DPBASE02. Then read the file INSTALLU.TXT for further instruction. INSTALLU.TXT Contained in DPBASE01.EXE, this file is the installation instructions. ORDER.TXT Contained in DPBASE01.EXE, this is the order form to use if you decide to keep using either DRILBASE or PROSBASE. Questions. If you have any questions or comments you may call during reasonable hours Pacific Time. David Griffith December 14, 1991 Note: IBM PC, IBM AT, FoxBASE, FoxPro, dBASE III+, dBASE IV, Bernoulli, AutoCAD, Autolisp, MicroMODEL, Surfer, 386MAX, QEMM and Power Pak are all registered trademarks belonging to others.