When you are entering data in 3E Exchange, sometime you are supplied with incomplete data, or maybe you need to reach out to a supplier to get additional information. In those cases, its helpful to know that things just aren't adding up correctly. To help with that, 3E Exchange can validate your data and give you a warning to alert you.
To turn on validation, use the Validation option from the Data menu:
3E Exchange will validate the following:
All Level 1 rows add up to at least 100% for their Product % by Weight fields. If ranges are used, max percentages are used to calculate the total Product % by Weight.
Rows with Material % by Weight add up to at least 100% within their level. If ranges are used, max percentages are used to calculate the total Material % by Weight.
All lowest level rows in the Level hierarchy have CASRNs assigned to them
Fields under columns with custom-defined values have valid values assigned.
The sum of % Pre-Consumer Recycled Content and % Post-Consumer Recycled Content do not exceed 100% in a row
Any rows with issues are flagged with a red tab in the upper right of the first cell in the row. Any cells with issues are similarly flagged:
Getting Help
If you have questions about using 3E Exchange or the material covered in this help article, reach out in chat in the bottom right-hand corner or email support@3eco.com.