This page describes the commun particularities for the Synthesis Reaction tests

Summary

Mapping Details

This spreadsheet has the mapping details for all Synthesis ELN data:

ELN Data

The following tables, extracted from the ELN spreadsheets, are used for the enrichment of the raw data.

The CSV files created are available on :

Path
...\DATA\[ENV]\RnI\Silica\XML SILICA\XML Synthesis\PARSED_XML_SYNTHESIS\Useful information

drying_raw_data_link

This table lists the links for the raw data files that need to be extracted from the Lab servers for each sample_id. It is used by the Python scripts download_drying_*.py (* stands for the scale: Telsa, Gunsan, 2500L, etc) and by Talend jobs responsible for getting files from Google Drive. It contains the following fields:

unique_id
study_id
sample_id
drying_file_link
drying_equipment_name
drying_scale_L

drying_eln_data

In the beginning of the Python scripts for computing, we extract the following values from the file drying_eln_data.csv. Each of the following values will be used in later computations as constants:

Constant name	Formula
silica_mass_outlet_kg	The value of the column [drying_total_product_mass_kg] for the sample_id
trial_start	The value of the column [drying_start_hour] for the sample_id
trial_end	The value of the column [drying_end_hour] for the sample_id
dry_extract_percentage_inlet	The value of the column [drying_slurry_dry_content_prct_w] for the sample_id
dry_extract_percentage_outlet	The value of the column [drying_dry_content_prct_w_powder] for the sample_id
sulfate_content_percent	The value of the column [drying_sulfates_powder_prct_w] for the sample_id