Water Resources Applications Software Geochemical || Ground Water || Surface Water || Water Quality || General Summary of LIMS NAME LIMS for Light Stable Isotopes - Laboratory Information Management System for Light Stable Isotopes ABSTRACT LIMS for Light Stable Isotopes is a Microsoft Access database program for managing samples, analyses, reports, and other data in a stable isotope (and tritium, carbon-14, and chlorofluorocarbon) laboratory. The reliability and accuracy of isotopic data can be improved by utilizing database software to (i) store information about samples submitted to a laboratory for isotope-ratio or (and) chlorofluoro- carbon analysis, (ii) store the results of mass spectrometric isotope-ratio analyses of samples, (iii) calculate analytical results using standardized algorithms stored in the database, (iv) normalize stable isotopic data to international scales using isotopic reference materials, and (v) generate multi-sheet paper templates for convenient sample loading of automated mass- spectrometer sample preparation manifolds. Major benefits of this system include (i) an increase in laboratory efficiency, (ii) reduction in the use of paper, (iii) reduction in workload due to the elimination or reduction of the retyping of data by laboratory personnel, and (iv) decreased errors in data reported to sample submitters. Such a database provides a complete record of when and how often laboratory reference materials have been analyzed and it provides a record of the correction factors that have been used through time. It provides an audit trail for stable isotope laboratories. LIMS for Light Stable Isotopes can store information about samples and analytical results for the following isotope ratios, isotopes, and chlorofluorocarbons: 2H/1H 11B/10B 18O/16O 37Cl/35Cl 129Xe/132Xe 3H 13C/12C 21Ne/20Ne 38Ar/36Ar 136Xe/132Xe 3He 14C 22Ne/20Ne 40Ar/36Ar CFC-11 4He 15N/14N 30Si/28Si 83Kr/84Kr CFC-12 7Li/6Li 17O/16O 34S/32S 86Kr/84Kr CFC-113 LIMS for Light Stable Isotopes has proven useful in laboratories that (i) receive samples for isotopic analysis from numerous individuals, and (ii) perform at least a few thousand isotopic analyses per year. Users who do not meet at least one, and likely both these criteria, will probably not find worthwhile the investment in time that it takes to learn and fully apply LIMS for Light Stable Isotopes. Experience has shown that approximately one week is required to become reasonably acquainted with LIMS for Light Stable Isotopes and to set it up for operation in a laboratory. The user should plan one day for the tutorial in the manual and three to four days to set up a new database and begin importing isotopic analyses from mass spectrometers in the laboratory. Although this may seem like a large investment in time, current users report that the rewards in increased productivity and better organization in a laboratory far outweigh this setup cost. METHOD This database software utilizes Microsoft Access to organize samples, projects, isotopes, procedures, media, etc. in data tables. Reports are generated with the Microsoft Access report generator. Calculations are performed by executing queries. Data is presented to the user in user-friendly forms, and can be written to ASCII text files and Microsoft Excel spreadsheet files. HISTORY Two versions of LIMS for Light Stable Isotopes--version 7 for Windows 9x and Windows NT, and version 1 for Windows 3.x--have been developed concurrently. In the descriptions of software updates below, the version number for the Windows 9x/NT version is followed by the version number of the Windows 3.x version enclosed in brackets ([]). The first release of the Windows 9x/NT version (7.01) was made with the release of version 1.41 of the Windows 3.x version. Version 7.12 [1.52] 1998/11/12 - Modified code to check date and time separators in Windows Regional Settings. Microsoft Access cannot recognize as valid a date and time such as 9.9.98 11.15.45 where the separator used in both date and time is a decimal. When this is the case, LIMS will prompt the user to change one of the separators before continuing. Version 7.11 [1.51] 1998/10/26 - Workaround provided for known Microsoft Access bug that corrupts data. Any code that uses the bookmark property of a recordset after records have been deleted is susceptible to the bug. LIMS now requeries recordsets immediately after deletions are made. Version 7.10 [1.50] 1998/09/02 - Enabled storage of dual-inlet and elemental analyzer results on the same sample. Version 7.09 [1.49] 1998/06/13 - Added isotopes, isotope-ratios, and compounds 3H, 3He, 4He, 14C, 21Ne/20Ne, 22Ne/20Ne, 38Ar/36Ar, 40Ar/36Ar, 83Kr/84Kr, 86Kr/84Kr, 129Xe/132Xe, CFC-11, CFC-12, and CFC-113. Version 7.08 [1.48] 1998/05/10 - Fixed problem in storing sample delta when Reston-specific features selected. Version 7.07 [1.47] 1998/04/10 - Added new procedure codes to indicate sample preparation procedures: 166 (Std Dev, Low Procedure), 167, 187 (H Conc), 188 (O Conc). Version 7.06 [1.46] 1998/03/03 - Added new software switches for modifying how LIMS is configured; added switches to allow for storage of Finnigan spectrometer elemental analyzer concentrations (STORE_EA_CONCENTRATIONS), Finnigan ion gauge values (STORE_ION_GAUGES), and unexpected procedure codes (STORE_UNEXPECTED_PROCEDURES). Version 7.05 [1.45] 1998/01/28 - Revised importing of project data from Microsoft Excel files. Revised latitude and longitude fields on Sample form. Version 7.04 [1.44] 1997/12/10 - Revised importing of dates to correctly handle non-U.S. conventions followed in specifying dates. Allowed C and N concentrations from elemental analyzer analyses to be imported and stored. Version 7.03 [1.43] 1997/11/05 - Fixed errors related to non-U.S. country settings in Microsoft Windows. Version 7.02 [1.42] 1997/08/02 - Fixed port number importing for Reston-specific analyses. Version 7.01 [1.41] 1997/07/21 - Added peak numbers to database in order to store continuous flow isotope-ratio mass spectrometer analyses. Version 1.33 1996/12/16 - Fixed Delete button on Edit Samples In Progress form to correctly update sample information. Added media validation when storing delta values. Version 1.32 1996/11/01 - Fixed bug preventing low and high procedure codes from being saved for two or more samples. Added low and high procedure code checking. Fixed problem with date shown in Project form. Fixed problems with display of hourglass. Replaced semicolons with commas as delimiters for importing DuPont data. Made modifications to allow importing of and reporting of fractional seconds. Modified code to not allow storing of data when errors encountered in parsing data to be imported. Version 1.31 1996/08/30 - Made modification to store sample headings and isotopic data separately in database rather than in a single data table. Version 1.1 1996/02/11 - Early version with basic functionality. DATA REQUIREMENTS Sample and project information can be entered by hand or imported from Microsoft Excel spreadsheet files. Isotopic analyses can be entered by hand or imported from files saved to diskette by Analytical Precision, Europa Scientific, Finnigan, and Micromass spectrometers, although Micromass continuous flow analyses files cannot be imported. OUTPUT OPTIONS Sample projects with isotopic data can be exported as ASCII text files or Microsoft Excel spreadsheet files. Numerous reports can be generated from LIMS. SYSTEM REQUIREMENTS For installation of LIMS for Light Stable Isotopes, up to 7.6 megabytes of free disk space is needed. To run LIMS for Light Stable Isotopes, the following are necessary: - Windows 9x or Windows NT 4.0 or higher Microsoft Access 97 with Database Drivers, Microsoft Graph Microsoft Excel 97 OR - Windows 3.x Microsoft Access 2.0 - 486 or greater processor, running at 66 megahertz or faster - 16 megabytes memory - display resolution of 640x480 For optimal performance, the following are recommended: - Pentium processor, running at 200 megahertz or faster - 32 megabytes memory - display resolution of 800x600 DOCUMENTATION Coplen, T. B., 1998, A manual for a laboratory information management system (LIMS) for light stable isotopes--Version 7.0: Open-File Report 98-284, 124 p. CONTACTS Operational: U.S. Geological Survey Tyler Coplen 431 National Center Reston, VA 20192 tbcoplen@usgs.gov Distribution: U.S. Geological Survey Hydrologic Analysis Software Support Program 437 National Center Reston, VA 20192 h2osoft@usgs.gov Official versions of U.S. Geological Survey water-resources analysis software are available for electronic retrieval via the World Wide Web (WWW) at: http://water.usgs.gov/software/ and via anonymous File Transfer Protocol (FTP) from: water.usgs.gov (path: /pub/software). The WWW page and anonymous FTP directory from which LIMS for Light Stable Isotopes software can be retrieved are, respectively: http://water.usgs.gov/software/lims.html --and-- /pub/software/geochemical/lims If you would like to obtain the price of and (or) order paper copies of USGS reports, contact the USGS Branch of Information Services at: USGS Information Services Box 25286 Denver Federal Center Denver, CO 80225 To inquire about Open-File Reports or Water-Resources Investigations Reports: Tel: 303-202-4200; Fax 303-202-4695 To inquire about other USGS reports: Tel: 303-202-4700; Fax 303-202-4693 The URL for this page is http://water.usgs.gov/cgi-bin/man_wrdapp?lims If you have any questions or comments about this page, contact Page created: 04/08/2000