...
Uploading LOI Data To LIMS
Open the Excel File 'LOI_Spreadsheet Upload Template' in Local Disk > DATA (Figure 41). Put your LOI information into the spreadsheet following the example format. Fill in the following:
...
>LOI > LOI_Spreadsheet.xlsx
The spreadsheet has three sheets:
- The first sheet is as follows:
SAMPLE NAME | SITE HOLE/CORE/SECTION/INTERVAL | CRUCIBLE ID | CRUCIBLE WT | CRU + FRESH SAMPLE WT | CRUCIBLE + IGN SAMPLE WT | SAMPLE WEIGHT | POST IGNITION LOSS | %LOI | Comments |
---|---|---|---|---|---|---|---|---|---|
QRND12345678 | 999A/1H/4/70-72 | I | 14.813 | 19.813 | 19.690 | 5.0000 | 0.123 | 2.46 |
- The second sheet is for repeats
- The third sheet is the format for uploading the data using the spreadsheet uploader (Figure 41)
Put your LOI information into the spreadsheet following the example format. Fill in the following:
- Text ID: e.g., WDGE11258831 (Note: capital letter matters)
- Analysis: LOI
- Replicate: 1 (usually)
- crucible_number: Crucible ID (e.g., A, B, F...)
- crucible_preignition_mass: crucible mass only (small inner crucible) (component unit: grams)
- crucible_and_preignition_sample_mass: inner crucible with fresh sample before ignition (component unit: grams)
- crucible_and_postignition_sample_mass: inner crucible with ignited sample after ignition (component unit: grams)
- loi_percent: LOI in % (component unit: none; the value is already a percentage)
- reference_mass: sample mass (calculated difference) (component unit: grams)
- comment: specify temperature and time used for LOI (e.g., 950 deg C for 4 hours; used during Exp 391)
Text ID | Analysis | Replicate | Instrument | Display Flag | Component Name | Component Value | Component Unit | Component Name | Component Value | Component Unit | Component Name | Component Value | Component Unit | Component Name |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
QRND12345678 | LOI | 1 | crucible_number | NONE | crucible_preignition_mass | GRAMS |
...
crucible_and_preignition_sample_mass |
...
GRAMS | crucible_and_postignition_sample_mass |
...
Component Value | Component Unit | Component Name | Component Value | Component Unit | Component Name | Component Value | Component Unit | Component Name | Component Value | Component Unit | |
---|---|---|---|---|---|---|---|---|---|---|---|
GRAMS | loi_percent | 2.46 | NONE | reference_mass | GRAMS | comment | 950°C for 4 hrs | NONE |
...
Figure 41. LOI Spreadsheet Upload Template.Template
Open up the program ‘Spreadsheet Uploader’ Pinned Spreadsheet Uploader Pinned to the Taskbar (Figure 42).
Figure 42. Spreadsheet Uploader Icon.
...