This page describes the commun particularities ELN for the Synthesis Reaction Filtration tests
Summary
| Table of Contents | ||
|---|---|---|
|
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.
These files are available on :
...
| Path | ||
|---|---|---|
| DEV | D:\ETL...\DATA\ | DEV[ENV]\RnI\Silica\XML SILICA\XML Synthesis\PARSED_XML_SYNTHESIS\Useful information |
filtration_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_filtration_*.py (* stands for the scale: i.e. 170L, 2500, etc.) and by Talend jobs responsible for getting files from Google Drive. It contains the following fields:
- unique_id
- study_id
- sample_id
- filtration_file_link
- filtration_scale_L
- filtration_plate_equipment_name
filtration_eln_data
In the beginning of the Python script scripts for computing , we extract the following values from the file filtration_eln_data . This table contains the fields extracted from ELN that will be used in the computation of new columns and values. It is used by the Python scripts compute_synthesis_*.py (* stands for the scale: 25L, 170L, 2500L). It contains the following fields:
Constant name | Formula |
...
nb_ |
...
chambers | The value of the column [filtration_number_of_chamber] for the sample_id |
filtering_surface | We first search for the filtering_area → The value of the column [filtration_plate_filtering_area_m2] for the sample_id Then: filtering_surface = nb_chambers * filtering_area |
thickness | The value of the column [filtration_cake_tickness_mm] for the sample_id |
cake_mass | The value of the column [filtration_cake_mass_kg] for the sample_id |
dry_sio2_prct | We take this value from the table computed_synthesis_170L. Only if it is not available in the table computed_synthesis_170L, we take it from ELN, as the value of the column [filtration_reactional_slurry_prct_SiO2_prct_w |
...
] for the sample_id. |
cake_ |
...
salts_ |
...
prct | The value of the column [ |
...
filtration_cake_sul_content_5_prct_SiO2_prct_w_wSiO2 |
...
] for the sample_id | |
cake_moisture | The value of the column [filtration_cake_dry_content_prct] for the sample_id |
scale | “170L” |
cake_ph | The value of the column [filtration_cake_pH_prct] for the sample_id |
na2so4_in_slurry | We take this value from the table computed_synthesis_170L. Only if it is not available in the table computed_synthesis_170L, we compute it as 0.85 * dry_sio2_prct. In the future, this value will be included in the ELN and, if the value is not available in the table computed_synthesis_170L, we should take it from ELN. |
filtration_start_hour | The value of the column [filtration_start_hour] for the sample_id |
filtration_end_hour | The value of the column [filtration_end_hour] for the sample_id |