Daughney, C.J. 2007 Spreadsheet for automatic processing of water quality data : 2007 update. Lower Hutt, N.Z.: GNS Science. GNS Science report 2007/17 15 p.
Abstract: This report provides a description of the Excel spreadsheet called “2007 NGMP Calculator”, which is an updated version of an earlier spreadsheet developed for automatic processing of water quality data obtained through the National Groundwater Monitoring Programme. These spreadsheet applications have been developed because, at the time of writing, software with comparable functionality was not commercially available. Excel was selected to ensure portability. There has been some criticism of Excel’s built in higher-level statistical functions, and so these were avoided. This spreadsheet has been designed to automatically process water quality results for many different analytes in each of many different samples collected from many different sites. (auth)