In some sampling scenarios, subsamples will be a part of the real structure of the data collected. For these scenarios, we’ve released the Splashback Profiler add-in so you can visualise your data across subsamples for a given set of sites, times or parameters. View the video on our Sample data structure here.
In the following video we use the Parameter Profile add-in to plot the change in chemistry with depth for the Pit Lake at the Splash Valley Mine (demonstration dataset). It is just as simple to plot different profiles for different times or multiple sites using the Site Profiler add-in.
The add-ins are versatile, and the user can modify the chart that is generated by the app using Chart Presets. For example, the chart generated in the video has the variance, which is the independent variable (depth) on the Y-axis. The order of the depth data is reversed to produce the chart that makes sense when monitoring a depth related profile in water or soil.
In other sampling scenarios, say an assay of crushed rock or tailings, you may separate different particle size distributions and analyse them. In this case you may plot the variance (particle size) on the X-axis and the parameters being measured on the Y-axis.
Other chart parameters such as font sizes, axes minimum and maximum values and chart size can also be saved between sessions. The chart generated is a standard Excel chart, so there is a wide variety of modifications that can also be made with the Excel tools.
Charts are placed in the sheet where the data is located. The chart sheet can simply be renamed, and the workbook saved, to store the chart and data in an Excel spreadsheet.