Importing the .XLSM

Prepare the spreadsheet

Please prepare the mix information in a spreadsheet that features the final information in the COA section as described earlier

The rest of the spreadsheet can be used for capturing raw data and performing the necessary volume calculations. Save the file in MS XLSM format

Uploading Mix information

Select Mix file to upload in Bika Cement Open Source LIMS for cement and concrete laboratoriesIf a Batch of concrete, mortar or paste Samples requires its Mix information to be included and reported in their COAs, the user uploads the Mix's spreadsheet on on the Batch's create/edit page

The LIMS adds a Mix tab to the Batch

Mix tab

The Batch's Mix tab displays the Mix's key information and a table of Mix Material ingredients and their proporsions

Editing a Mix

Because the Mix information is sourced from the lab's spreadsheet calculations, the Mix cannot be edited in the LIMS. Users must go back to the source document, do the edits there and reload it on the Batch. Do so on the Batch's edit page

Downloading a Mix spreadsheet

If for some reason users need to check on the calculations used for the Mix, they can download it from a link on the Batch List