Overview and Contents
When working with a Bill of Materials (BOM), Toxnot can automatically calculate values for weight-related columns so you can store your data in multiple ways! The Toxnot Standard Auto-Calculation mode interprets what weight data you've entered to figure out how we should do the calculations. You can even enter unreacted formulation data (aka wet percent by weight data) along with the process information and we will calculate the final amounts of the included chemicals.
Toxnot Standard Auto-Calculations (Recommended)
A majority of Toxnot users will benefit most from the Toxnot Standard
Auto-calculations. This setting works best if you have any kind of weight or percentage data about your products and materials. This mode calculates the Product % by Weight of your products by using the entered data to make a few small assumptions. Keep in mind, this setting should not be used when the weights are only stored at the lowest level of a BOM (usually the chemical level). As long as the weights are listed for all the rows or at the higher levels of the BOM, this mode works flawlessly!
But wait, there's more! This mode can be extremely helpful for combining materials with different types of weight and percentage data entered all within the same product. If some of your materials have substance level weights, some have Material % by Weight, and some have unit weights, you can use Toxnot Standard Auto-calculations to combine them all together. You can also combine products with other products using this mode! See an example of Toxnot Standard Auto-calculations in action below.
Before Toxnot Standard Auto-calculations:
After Toxnot Standard Auto-calculations:
You can choose an auto-calculation mode when creating a new product or material, or at any time from the Options menu within the BOM Editor (pictured below).
For more information about the BOM Editor, see Editing Products and Materials.
Unreacted Formulation Data (a.k.a. Wet % by Weight Function)
In some cases, you may find that documenting weight data for wet-applied substances can be more difficult. You're in luck! We have two new BOM columns to help you navigate this process and make wet percentages easier to document than ever while using Toxnot Standard Auto-Calculations!
These can be activated by either importing data with these columns, or by manually activating the columns in Toxnot. To do this, you will select the column button (pictured below) in your BOM. You can then select the checkbox next to appropriate columns and organize their order by dragging them up or down the list. If you would like to enable these columns for all your products and materials, you can add them to your BOM column template. Read more here: Setting up your BOM Fields.
In order for the auto-calculations to work correctly, you will need to add values into the "Wet Material % by Weight" and "% of Wet Ingredient in Final Product" columns. These two columns generate a Material % by Weight value, and then a Product % by Weight column (see example below).
The auto-calculations in these scenarios work as follows:
The Wet Material % by Weight is the wet-applied weight of the substance in question. Typically, wet-applied products lose weight during the drying process due to chemical reactions. The % of Wet Ingredient in Final Product is the amount of the substance that is left in the product after evaporation.
In reference to the example above, we will look at the 'Diethylene Glycol'. This substance is 15% of the Foam Insulation while wet. During the drying process, only 50% of the substance remains after chemical reactions. These two values yield the Material % by Weight, and ultimately the Product % by Weight. This occurs for each of the wet-applied substances.
If you think one of our other auto-calculation modes might suit your data better, feel free to check out the following article.
Do you have a question about the workflow or issues you've found?
Use the Intercom chat service in the bottom-right of your screen to connect to a Toxnot Customer Success Engineer, or email email@example.com and we'll get back to you with the information or help you need.