This page describes the ELN for the Synthesis Filtration tests

Summary

Mapping Details

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

Mapping spreadsheet 

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:

  • 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 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


  • No labels