Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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/INTERVALCRUCIBLE IDCRUCIBLE WTCRU + FRESH SAMPLE WTCRUCIBLE + IGN SAMPLE WTSAMPLE WEIGHTPOST IGNITION LOSS%LOIComments
QRND12345678999A/1H/4/70-72I14.81319.81319.6905.00000.1232.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 IDAnalysisReplicateInstrumentDisplay FlagComponent NameComponent ValueComponent UnitComponent NameComponent ValueComponent UnitComponent NameComponent ValueComponent UnitComponent Name
QRND12345678LOI1

crucible_number
NONEcrucible_preignition_mass
GRAMS

...

crucible_and_preignition_sample_mass

...


GRAMScrucible_and_postignition_sample_mass

...


Component ValueComponent UnitComponent NameComponent ValueComponent UnitComponent NameComponent ValueComponent UnitComponent NameComponent ValueComponent Unit

GRAMSloi_percent2.46NONEreference_mass
GRAMScomment950°C for 4 hrsNONE

...



Figure 41. LOI Spreadsheet Upload Template.Template 

Open up the program ‘Spreadsheet Uploader’ Pinned Spreadsheet Uploader Pinned to the Taskbar (Figure 42). 

Image Modified
Figure 42. Spreadsheet Uploader Icon.

...