ELN Schemas
| File Name | Data Model File |
|---|---|
| Agro | |
| Battery | |
| Coatings | |
| Seed Care | |
| Actizone | |
| HPC Flocculation | |
ELN Spreadsheets design standards
Design is really important for user experience.
The user feedback about the first version of the ELN templates where more about the design than the content. They didn't really enjoy the "black and yellow" spreadsheets.
So for Coatings' Paint Formulation SS V2, we worked on defining design standards using Solvay's color palette as a base.
These standards are going to evolve according to the future needs.
Here are documentations about developed spreadsheet in PROD:
| Agro | ||
| Battery | Conductivity | |
| Battery | Mechanosynthesis | |
| Coatings | EP | |
| Seed Care | Formulation | |
| Seed Care | Results & Requests | |
Entities and Relationships
ENTITIES
| Entity | Definition | Example(s) |
|---|---|---|
| Experiment | A defined set of lab activities performed on samples of specific products/components | Emulsion Polymerization experiment Solvent screening experiment |
| Formulation | The ingredients (generic) and their proportion (target) composing a formula | Formulation ABC = 1,2- Dibromoethane - 89% + Rhodacal 60 - 5% + Rhodasurf L-20 - 6% |
| Formulation Batch | A use of a formula prepared in the lab with the real ingredients (chemical inventory) and their proportion (actual) | Formulation ABC Batch xxxx = 1,2- Dibromoethane Batch xxxx Sigma Aldrich - 89.1% + Rhodacal 60 Batch xxxx - 5.2% + Rhodasurf L-20 Batch xxxx- 5.7% |
| Ingredient | A product, component, material, sample of formulation batch recorded in chemical inventory | Rhodasurf L-20 Batch SP4D26X01 100% active received 08/06/23 |
| Sample | A piece of the product/component on which the test is perfomed The sample can be taken from:
| Raw material: methanol from Sigma Aldrich Formulation sample: combination of solvent, active ingredient and other additives Synthesized product: latex |
| Activity Group | A group of lab activities performed on the same sample, which share a common characteristic between them | Syrup experiment includes photographing, measuring pH, measuring conductivity, measuring viscosity of one sample |
| Lab Activity | Observation/analysis of the behavior of a sample of a component/product when a procedure is carried out in a set of conditions :
It has an SOP (Standard Operating Procedure) | Formulation Conductivity Paint application |
| Condition | A variable/setting defined by the operator for a lab activity and affecting its outcome | Temperature/pressure at which experiment is carried out Solute concentration |
| Result | The outcome of a lab activity performed on a sample in specified conditions It can be a numerical value, a set of numerical values (i.e. curve) or a non numerical value (i.e. observations) | pH = 8.4 Shear stress vs. Shear rate Pass/Fail |
| Result Serie | A set of results, obtained for a lab activity performed the same conditions, and measured with a time interval between them | Sample aging |
| Measure | A property of the sample In the context of a lab activity it can be a condition and/or a result | Temperature |
RELATIONSHIPS
One Experiment can have;
- One or more Samples;
- One or more Formulations;
A Formulation can have:
- One or more Ingredients;
- One or more Formulation Batches;
A Formulation Batch can have:
- One or more Ingredients;
A Sample can only be part of a Formulation Batch;
A Formulation Batch can be associated to one or more Samples;
A Test Group can:
- Only be part of one Sample
- Have one or more Tests
A Test can:
- Only be part of one Test Group
- Have one or more Conditions
- Have one or more Result Series
A Condition can:
- Only be part of one Test;
- Have one or more Measures;
A Result Serie can:
- Only be part of one Test;
- Have one or more Results;
A Result can:
- Only be part of one Result Serie;
- Have one or more Measures
A Measure can be used both as a Condition as well as a Result;
ENTITY-RELATIONSHIP DIAGRAM
Legend
Entity
Primary key
Foreign key
Attribute
Relationships
- The ring represents "zero"
- The dash represents "one"
- The crow's foot represents "many"
Diagram
BigQuery
New Data Model of ALB Data Mart (Exposition layer): https://app.genmymodel.com/api/projects/_k07o4IBOEe29ie0vpi-P5A/diagrams/_k07o4oBOEe29ie0vpi-P5A/svg
Data Mapping to Data Mart:
The following BigQuery datasets are all staging as per the data convention explained previously.
For more ETL (extraction, transformation, loading) details, please refers to: App Lab Booster (ALB) - Data