Using Time Series Analyses

Use Case

In Continuation with the example in Setting up the Time Series Analysis Service: Consider a Compressive Strength test on concrete Samples, 3 per test, over a time period, measured regularly. We need to plot the average strength for the 3 tests, the standard deviation as error bar on the Average; the corrected average; and reference sample strength

And table but not plot, Chloride Penetration as text, and Bulk resistivity which is on a different scale

Collect the results in a spreadsheet

At the writing of this page, results can only be imported from spreadsheets to TS Analyses and not captured in the UI. Some labs will use a set of sheets to collect raw data in, from which the data points to be tabled and graphed in the LIMS are extracted to a summary sheet of fixed format, which is then imported, manually in this example, to be automated.

The (MS xlsx) sheet should look like this and carry the Analysis' keyword in its title. Only the cells shaded green are imported. Those shaded yellow are used for referencing the correct Sample and Analysis in the LIMS, the Sample ID and Analysis keyword must go in there, C109COMPRESSIVE in this example

The values on row 4 are for description only, row 5 must corresponde to the column titles used in the AS' configuration

Importing Time series results

If not automated, the user must import the spreadsheet to reflect the latest data in the LIMS manually

Navigate to Instrument Import from the icon at top right of the screen

Select the Instrument Import tab, the Time Series Instrument to use and the xlsx to import

NB Worksheet number

Because some spreadsheet books can include results for more than one Analysis, the user has to indicate which sheet to import, giving the sheet number, starting with 0, i.e. 0, 1, 2, 3, 4 from left to right. Note that the most LH sheet gets the number 0

Press [Submit]The import trace will report any errors found in the file. These can be quite cryptic - if you cannot work out what to fix, log an issue in the Bika tracker including the importer's traceback. Upload the import xlsx to the project's private online folder and share the link in the issue

When you refresh the Sample view, the Time Series table will be populated with the imported data indicating out of range results, and graphed just below it

If the COA template incorporates te plot and table, it will be replicated in the PDF emailed to Clients

Spreadsheet Uploaded as attachment

From release 1.0.2, the imported spreadsheet is also uploaded to the Sample, like for instrumemt imports, and always available as reference