You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

This page describes the ELN for the Synthesis Filtration tests

Summary

ELN Data

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

These files are available on :

EnvironmentPath
DEVD:\ETL\DATA\DEV\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 script 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