What's New in AquaChem 5.0! Plots & Mapping   Streamlined plot options make editing axes, titles, legends easier Axes tick labels may be angled Map plots - data aggregation for multiple samples at same station: select various aggregation options: oldest sample, newest sample, max/min value, etc.) Import polyline shape files (ESRI .SHP) as your basemaps Import and georeference raster images (air photos or topographic maps) for use as your project base map - and overlay various plots! Map plot may contain multiple basemaps, basemaps are activated and deactivated with a checkbox Export Stiff and Radial thematic plots to .SHP file format for use with GIS tools such as HydroGeo Analyst Color fill options for Box plot Display uncertainty bars (whiskers) on XY scatter plots, such as time series, scatter plots Display lines for max tolerance concentrations or method detection limit (MDL) on time series plots - lines can also be included in the legend! Advanced symbol labeling options: position labels anywhere on the plot and use connecting lines and user-defined text (annotation) to identify samples Use measured Alkalinity in Piper diagrams, instead of HCO3     New Plots: Box and Whisker time series plot (show boxes for samples from the same month, year or season) Meteoric Water Line Quantile plot Detection Summary Time Series - bar charts: displays statistics values for months or years in bar format Reports & Statistics   Statistics report supports multiple units allowing the user to select and calculate several parameter units simultaneously New options for managing non-detects (censored) data: Ignore, Multiply, Constant, Trimmed, Winsorize (based on "US EPA QA Guidance for Data Quality Assessment, Practical Methods for Data Analysis") New Statistical options: Define any Quantile, Confidence interval, T-statistics, Number and % of Non-Detects, number and % of detects below and above standard, Skewness, Kurtosis, Tolerance interval + limits Save statistical report configurations for future recall For statistical calculations, automatically displays a separate statistic for every symbol in the record list Statistical Trend Analysis:   Linear Regression Sens test Mann Kendall test Statistical Outlier test:   Dixon's test (Extreme value test) Discordance test Rosner test Walsh's test Test for Normality:   Studentized range test Geary's test Shapiro Wilk test (W-Test) D'Agostino's test Variance coefficient New QA/QC Report: Compare sample to its duplicate to determine margins of error - quickly find and highlight samples containing outlier values and non detects! Save hardwired reports and table views as Excel format Data Management & Display   User-defined picklists for text parameters (customize a predefined list of values for any text field for sample or station parameters) Enhanced options for sample details window (adjust frame sizes, station tab is now moved, etc.) Import data from Excel (.XLS) format. Export data, reports, and spreadsheet to Excel format Save Advanced Finds (Queries), and recall later on. Export XYZ data Export any station locations, and attribute data (elevation, gw elevation, chemical concentrations, etc.)to ESRI points shape (.SHP) file, to be used with GIS tools, such as HydroGeo Analyst Modify and save the Chemicals database, for future recall. Database - ranges - define a natural occurrence flag, to be used for quality control, to check if concentrations are outside the normal distribution Change parameter types after they are created (ex change from Text to Integer) Sample details: analysis may be marked as outlier, and it can be excluded from all calculations and plots Water Quality Standards & QA/QC   When importing water quality guidelines, automatically match chemical CAS Registry # to parameter name in the database; eliminates the need for manual matching In table view and sample details window, display a color legend symbolizing the color for each exceedence level. Test to see if chemical concentration exceeds solubility Test for concentration outside defined natural occurrence interval Tools & Calculations   New option in Decay calculator: estimate half life from 2 concentration/time pairs. OH-concentration is included in the alkalinity calculations if available     New time functions: "season", which returns a season number for every      sample date. E.g. you may search for season = 2 and all      summer samples will be highlighted. This can be useful if      you have a scatter plot with deep and shallow samples      and you want to see if samples from the same season      will build clusters. "month" to retrieve all samples from the same month "year" function to retrieve all samples from the      same year