You are here: Home / User Manual / 6 Analysis Services / 6.8 Time Series Analyses / Using Time Series Analyses

Using Time Series Analyses

Disclaimer               

Folder structure icon 32   Table of Contents...                

Creating a Time Series Analysis

When creating Samples as per normal, simply select the Analysis on the Sample registration form like any other. When the Sample is created, all Time Series Analyses are listed below the routine results. At this stage only the results table's column headers are displayed

Empty Time Series results table in Bika Open Source LIMS

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

Time Series Import Spreadsheet for Bika Open Source LIMS

Spacer 400

 

 

copyleft 200 x 33

Importing Time series results

If not automated, the user must import the spreadsheet to reflect the latest data in the LIMS. Navigate to Instrument Import from the icon at top right of the screen

Select Import Menu in Bika Open Source LIMS

 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

In this example the third sheet, number 2, will be imported:

Select Time Series Results file to import in Bika Open Source LIMS

 

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 

A successful import's traceback will report like this:

Successful Time Series Import Traceback in Bika Open Source LIMS

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

Time Series results Table and Graph in Bika Open Source LIMS