This page describes the ELN for the Synthesis Filtration tests
This spreadsheet has the mapping details for all Synthesis 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 |
|---|
| ...\DATA\[ENV]\RnI\Silica\XML SILICA\XML Synthesis\PARSED_XML_SYNTHESIS\Useful information |
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:
In the beginning of the Python 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 |