Compliance & ContractsFree worksheetPDF, Excel, Word export

Article Substance Mass Roll-Up Worksheet: Check a Substance Against 0.1% w/w

When a supplier reports that a part contains a Candidate List substance, the next question is how much of the finished product it represents. This worksheet rolls component data up to a total so you can see mass, ppm and percent by weight.

Download:

Component	Qty per article	Mass each (g)	Substance in component (ppm)	Total mass (g)	Substance mass (mg)
				85	102
				240	0
				13	58.5
				130	45.5
				21.6	0
				36	28.8

Article mass (g)

525.6

Substance total (mg)

234.8

Substance in article (ppm)

446.73

mg of substance per g of article, times 1000

Substance in article (% w/w)

0.0447

Compare with 0.1% w/w

Margin to 0.1% (% points)

0.0553

Enter ppm of the tracked substance in each component, not in the homogeneous material, and use the same substance in every row. Under the REACH Article 33 duty the 0.1% threshold applies to each article as supplied, including each component article of a complex product, so also check the individual component rows, not only the total. This worksheet is a screening aid, not a legal opinion.

Automated substance roll-up

Optional: we can discuss producing roll-ups straight from your BOM and declaration data.

Optional. The tool and every export work without this. No spam.

How to use the worksheet

Pick one substance, for example a phthalate or a lead alloy, and list every component that may contain it. Enter quantity, mass of one piece and concentration in ppm from the supplier declaration or test. The worksheet multiplies out total mass and substance mass per row and shows the article ppm and percent by weight. Replace the example rows, add lines and export the sheet to Excel for your file.

The calculation

Substance mass in milligrams equals quantity times piece mass in grams times ppm divided by 1000, because one ppm in one gram is one microgram. Article ppm is total substance milligrams divided by total grams, times 1000. Percent by weight is ppm divided by 10000. In the example, the total sits well below 0.1%, but several parts concentrate the substance, which matters for the next point.

Which level counts

For REACH, the Court of Justice ruled in 2015 that the 0.1% threshold applies to each article incorporated into a complex product, not to the whole product mass. This means a gasket at 0.45% of its own mass triggers supplier communication duties even if the finished machine contains only 0.02% overall. Use the roll up as a view of total exposure, but judge compliance at the component article level.

Common mistakes

Frequent errors are mixing units (percent entered as ppm), mixing substances in one sheet, using the homogeneous material concentration with the part mass, and ignoring small parts such as seals and cable ties. Also check the reference mass: a weighed part is better than a CAD estimate, and the supplier data must refer to the same revision as the part you ship.

Frequently Asked Questions

Is the 0.1% threshold on the whole product?

Not under the 2015 Court of Justice interpretation. The threshold applies to each article that is a component of a complex product, so both the component rows and the total should be checked. Authorities and lawyers may advise on your case.

How do I convert percent to ppm?

Multiply the percentage by 10000. So 0.1% equals 1000 ppm and 0.01% equals 100 ppm. The worksheet works in ppm for the component concentration and shows the percent result for the article.

Can I use it for RoHS?

RoHS limits apply per homogeneous material, not per component or article, so this roll up is not the right test. Use the RoHS limit margin calculator for that and keep the worksheet for article level REACH style questions.

What if I only know a range?

Use the upper bound of the range for screening. If the result is near the threshold, request an exact figure or test the part, because a conservative estimate may trigger needless communication duties.

Netray can help automate substance roll-ups from ERP BOM and supplier declaration data, with the query shown and human review before any statement is issued.

Talk to an Expert Explore More Free Tools

Related Tools

Compliance & Contracts

More Compliance & Contracts tools

See all

Back to All Tools