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
The LIMS adds a Mix tab to the Batch
|
Mix tabThe 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 spreadsheetIf 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
|
If 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
