True Database Storage and Display for SMT200 & SMT300* & Checkmate* Results
- Save SMT200 Files to an Xbase database
- Retrieve the results you want - by day, week, month etc.
- Display Histograms, scatter plots, cross plots and more
- Easy configuration
- Maintenance module
- Single String Queries (New)
- Time Analysis (New)
- Database Statistics (New)
Contracts often state that a database of Geophone test results must be kept.
Most crews simply create a large Excel spreadsheet, which sort of meets the minimum requirements, but a proper database has distinct advantages :
This is a first release. Improvements will be made over time. Feedback is appreciated - tell me what you want it to do.
****Updated December 2009**** See changes at the bottom of the page
*I do not have enough SMT300 or Checkmate results to guarantee that this works reliably.
If you have problems with SMT300 or Checkmate files, please send me some samples so I can improve the program
Most crews simply create a large Excel spreadsheet, which sort of meets the minimum requirements, but a proper database has distinct advantages :
- You can query it
- It is a standard format that can be archived
- It is harder to tamper with
This is a first release. Improvements will be made over time. Feedback is appreciated - tell me what you want it to do.
****Updated December 2009**** See changes at the bottom of the page
*I do not have enough SMT300 or Checkmate results to guarantee that this works reliably.
If you have problems with SMT300 or Checkmate files, please send me some samples so I can improve the program
Histograms
Scatter Plots
All
Selected Test(s)
Zoom In
Cross Plots
Easy Selection of Criteria and Displays
Statistics
Maintenance Module
Easily Add Records
Easy Configuration
Infinity Checkmate and SHARP
These can be selected under 'Configure'
Note that neither of these have been fully tested as I do not have access to very much data from these.
The Checkmate files are very similar to SMT files and no special actions need to be taken.
The SHARP however is a different story.
As it does not save data files directly - users typically record results to an Excel or similar file - a file of a specific format needs to be created to read the results.
Instructions on this can be found here.
These can be selected under 'Configure'
Note that neither of these have been fully tested as I do not have access to very much data from these.
The Checkmate files are very similar to SMT files and no special actions need to be taken.
The SHARP however is a different story.
As it does not save data files directly - users typically record results to an Excel or similar file - a file of a specific format needs to be created to read the results.
Instructions on this can be found here.
Single String Queries and Time Analysis
It is a good idea to look at Tester performance over a period of time. The easiest way to do this is to set aside a reference string which is tested each day by each tester before routine testing begins. After a month or so, the results from this string can be examined to see if the tester is behaving, and if there are any radical differences in testers.
The Single string display function found under 'Utilities' makes this quite easy:
It is a good idea to look at Tester performance over a period of time. The easiest way to do this is to set aside a reference string which is tested each day by each tester before routine testing begins. After a month or so, the results from this string can be examined to see if the tester is behaving, and if there are any radical differences in testers.
The Single string display function found under 'Utilities' makes this quite easy:
You can select the period to query, and the string number. Each tester can be displayed in a different colour, and brief statistics are provided for each tester.
For reports, it is often useful to display the number of tests per day. This and more is available from 'Time Analysis' under Utilities:
As with the Single String Display, you can specify the period to query, and the type of result.
A statistical analysis of the queried results is also possible. Be aware though that this section may well change, as I have not decided exactly where I am going with it.
Output of Graphics in Different Formats
The output format is specified under 'Configure'
You can now save graphics in the following formats:
The output format is specified under 'Configure'
You can now save graphics in the following formats:
- BMP
- EMF
- GIF
- JPG
- PNG **
- TIF
- WMF
Upgrading to the new version
Upgrading is simple - just replace the old EXE file with the new one. Just be sure to set all the proper options in 'Configure' before trying to use the program features. This is required!!
Upgrading is simple - just replace the old EXE file with the new one. Just be sure to set all the proper options in 'Configure' before trying to use the program features. This is required!!
