Data handling spreadsheets

D.L. Massart, N. Vanden Driessche, A. Van Dessel, Databases and spreadsheets. Chapter 2 in PCs for chemists ", J. Zupan ed.. Data Handling in Science and Technology - Volume 5, Elsevier, Amsterdam, 1990, p.17-41. 

Harris, D. C. 2003. Quantitative Chemical Analysis, 6th edn. Freeman, New York. (A popular analytical chemistry text with several excellent chapters on errors, data handling, the use of spreadsheets, etc. This latest edition has a new chapter on quality control, and an extensive associated website, for which registration may be needed. The previous edition was accompanied by a CD-ROM.)... 

Spreadsheet Applications. The types of appHcations handled with spreadsheets are a microcosm of the types of problems and situations handled with fuU-blown appHcation programs that are mn on microcomputers, minis, and mainframes and include engineering computations, process simulation, equipment design and rating, process optimization, reactor kinetics—design, cost estimation, feedback control, data analysis, and unsteady-state simulation (eg, batch distillation optimization). 

SGX-CAT maintains a direct T1 network connection from the Advanced Photon Source in Illinois to SGX San Diego. Database inquiries are handled over this link. Interactions with the database occur in three ways. An extensive web-based system is used for data entry and retrieval. For crystals generated by external users of the beamline, upload of an electronic spreadsheet transfers the required crystal data attributes to the SGX LIMS. For automated operations, such as crystal screening and data collection, custom scripts place the computed results directly into the database. 

---