Scoping

1. Introduction

• No structured data, only placeholders.

2. Monthly View

Manual Input Columns:

• Unnamed Columns (1 to 43): These appear to be placeholders or aggregated data categories.

Calculated Columns:

• No clear calculated columns visible from the raw data.

3. Sample List

Manual Input Columns:

• TAT

• Date of Sampling

• Date Analysed

• Sample Number

• Sample Description

• Batch/Order number

• Certificate number

• Person delivering the sample

• Sample Type

• Weighbridge Description

Calculated Columns:

1. Solids Wt%:
   Formula: = (Weight of Solids / Total Sample Weight) * 100

2. Liquids Wt%:
   Formula: = (Weight of Liquids / Total Sample Weight) * 100
   Other unnamed columns refer to various elemental percentages derived from lab results.

4. Spectron Results

Manual Input Columns:

• Sample ID

• Sample Description

Calculated Columns:

1. SiO2 (Silicon Dioxide):
   Direct lab result, represented as a percentage of the total.

2. Al-Al2O3 (Aluminum Oxide):
   Measured from lab analysis, expressed as a percentage.

3. Fe2O3 (Iron Oxide):
   Lab-derived percentage from sample analysis.

4. Other elemental results (MgO, CaO, K2O, TiO2, Cr2O3, SO3, etc.):
   Direct lab results expressed as percentages of the sample composition.

5. H2O

Manual Input Columns:

• Sample Number: Manually entered sample ID.

• Weight of beaker (m0) [g]: Manually entered weight of the beaker.

• Weight of sample (m1) [g]: Manually entered weight of the sample.

• Weight of Dried sample and beaker (m2) [g]: Manually entered weight of the dried sample and beaker combined.

• Weight of sample dried @ 105°C [g]: Manually entered weight of the dried sample.

Calculated Columns:

1. Weight of Sample And Beaker (m0+m1) [g]:
   Formula: =IF(Sample Number="", "", Weight of beaker (m0) + Weight of sample (m1))

2. Moisture @ 105°C [g]:
   Formula: =IF(Weight of Dried sample and beaker="", "", Weight of Sample And Beaker - Weight of Dried sample and beaker)

3. % Moisture (H2O @ 105°C) [%]:
   Formula: =IF(Weight of Dried sample and beaker="", "", (Moisture @ 105°C / Weight of sample dried @ 105°C) * 100)

6. 150

Manual Input Columns:

• Sample Number

• Date

• Person Responsible

Calculated Columns:

1. Al2O3:
   Measured from lab results as a percentage.

2. SiO2:
   Measured percentage from lab analysis.

3. Other elemental percentages (Fe2O3, MgO, etc.):
   Measured percentages from lab analysis.

7. XRF-PP

Manual Input Columns:

• Sample Number

• Date

• Person Responsible

Calculated Columns:

1. XRF Analysis Results:
   All percentages (e.g., Si, Al, Fe, etc.) are derived from X-ray fluorescence (XRF) lab analysis and expressed as a percentage of the total sample.

8. Titration

Manual Input Columns:

• Sample Number

• Date

• Person Responsible

Calculated Columns:

1. Concentration (%):
   Formula: = (Volume of Titrant * Molarity of Titrant) / Sample Weight * 100 (This calculates the concentration of the substance based on the volume of titrant used).

9. LOI (Loss on Ignition)

Manual Input Columns:

• Sample Number

• Date

• Person Responsible

Calculated Columns:

1. LOI (%):
   Formula: = (Initial Weight - Final Weight) / Initial Weight * 100 (Calculates the percentage of material lost after the sample is heated to a specific temperature).

10. Liquid Samples

Manual Input Columns:

• Sample Number

• Date

• Person Responsible

Calculated Columns:

1. Density (g/mL):
   Formula: = Mass / Volume (Calculates the density of the liquid sample).

2. Elemental Percentages:
   These are derived from lab analysis and calculated as percentages of total composition.

11. XRF-Liquid Samples

Manual Input Columns:

• Sample Number

• Date

• Person Responsible

Calculated Columns:

1. XRF Analysis Results:
   Measured elemental compositions derived from XRF analysis, expressed as percentages of the total liquid sample.

12. Weighbridge

Manual Input Columns:

• Sample Number

• Date

• Weight on Entry

• Weight on Exit

Calculated Columns:

1. Net Weight:
   Formula: = Weight on Entry - Weight on Exit (This calculates the difference between the sample's entry and exit weight).

13. COA (Certificate of Analysis)

Manual Input Columns:

• Sample Number

• Date

• Certificate Number

Calculated Columns:

1. Density (g/mL):
   Formula: = Mass / Volume

2. Purity (%):
   Formula: = (Pure Component Mass / Total Mass) * 100 (Calculates the percentage of the desired compound in the sample).

3. Elemental Composition (%):
   These percentages are derived from lab measurements of elements like SiO2, Fe2O3, etc.

14. Liquids COA

Manual Input Columns:

• Sample Number

• Date

• Certificate Number

Calculated Columns:

1. Density (g/mL):
   Formula: = Mass / Volume

2. Purity (%):
   Formula: = (Pure Component Mass / Total Mass) * 100

3. Elemental Percentages:
   Measured percentages of different elements in the liquid sample.