A kilogram of delivered liquid adhesive and a kilogram of reported solids are different accounting quantities. Before comparing consumption figures, ask what each figure includes and how the solids percentage is defined. Converting the units can reveal a misleading comparison, but it does not establish that two adhesives perform alike.
Haoxuan’s Water-Based Adhesive page identifies coating, laminating and pressure-sensitive material applications for technical review. It supplies no grade-specific solids percentage on the checked page. Every percentage and quantity in the examples below is invented for explanation, not a Haoxuan specification, production result or coating recommendation.
Define the three quantities on the worksheet
Wet mass means the net mass of the identified liquid material as supplied or as used, whichever basis the record explicitly states. Exclude the shipping container when using net material mass. A delivered-material figure and a diluted-in-process figure should not share the same label.
Mass-solids fraction is the reported solids percentage by mass divided by 100. For example, a hypothetical 50% by mass becomes 0.50 in a calculation. Confirm that the percentage is mass-based. A percentage by volume belongs to a different calculation and cannot simply be entered in the same cell.
Calculated solids mass is wet mass multiplied by that mass-solids fraction. Describe it as calculated on the stated basis. It is not automatically the mass of useful adhesive on saleable product, a measure of bond strength, or a quantity of pure active polymer.
Understand why the reported method matters
The public scope of ISO 3251:2019 covers determination of non-volatile matter by mass for several coating-related materials, including polymer dispersions. It explains that the result depends on the heating conditions and duration used. This is a reason to retain the reported method with the percentage, not a recommendation that every adhesive must be tested by that standard.
Ask the supplier which definition and method apply to the exact grade, whether the figure is nominal, a specification range or a lot result, and whether it describes material as supplied. Keep the document revision and units. Do not turn a catalog adjective such as “high solids” into a numerical input.
Work one equal-wet-mass example
Imagine two fictional materials, A and B. The only known numbers in this example are net delivered wet mass and a hypothetical mass-solids fraction on an agreed comparable basis. Neither material represents an offered Haoxuan grade.
| Accounting field | Material A | Material B |
|---|---|---|
| Net wet mass | 200 kg | 200 kg |
| Hypothetical solids by mass | 50% | 40% |
| Fraction used | 0.50 | 0.40 |
| Calculated solids mass | 200 × 0.50 = 100 kg | 200 × 0.40 = 80 kg |
The equal delivery masses therefore represent different calculated solids masses. If the accounting target were 100 kg of solids on these assumed bases, A would require 100 ÷ 0.50 = 200 kg wet, while B would require 100 ÷ 0.40 = 250 kg wet. This normalizes a quantity. It does not show that 250 kg of B can replace 200 kg of A in an actual process.
That replacement would involve formulation, application and finished-product requirements that the arithmetic does not answer. Keep the calculation labeled “quantity comparison only” so it cannot be copied into a production instruction.
Handle a range without inventing precision
Suppose a fictional supplier document states 48–52% solids by mass rather than one guaranteed value. For 200 kg wet, the corresponding calculated range is 200 × 0.48 = 96 kg to 200 × 0.52 = 104 kg. Reporting exactly 100 kg without explaining the midpoint would conceal the input uncertainty.
If a planning sheet uses a nominal percentage, label it nominal. If a lot-specific result later becomes available, record its source and revise the relevant calculation rather than rewriting the earlier assumption as a measured fact. Ask the technical owner how the input range should be handled for the actual purchasing decision.
Do not confuse material issued with material deposited
A second ambiguity appears when a consumption report says “24 kg used.” Did 24 kg leave the store, enter the application system, remain after returns, or reach accepted product? These are different boundaries. Write the boundary beside the number before applying a solids fraction.
In a hypothetical issue record, 24 kg of unchanged material is issued and 4 kg of that same material is returned, leaving 20 kg net issued. At an assumed 50% mass-solids basis, that corresponds to 10 kg calculated solids in net-issued material. It does not prove that 10 kg was deposited on accepted output: the record has not accounted for process losses, retained material or rejected work.
The subtraction also assumes that the returned material has the same composition basis. If it was mixed, diluted or otherwise changed, do not apply the original fraction without technical confirmation. Preserve separate records rather than hiding the difference in a single consumption figure.
Build a worksheet that catches unit errors
| Field | What to record |
|---|---|
| Material identity | Exact grade, lot where relevant, and document revision |
| Wet quantity | Net mass, unit and boundary: delivered, issued or another defined stage |
| Solids input | Percentage, mass basis, method and nominal/range/lot status |
| Calculation | Wet mass × mass-solids fraction |
| Result label | Calculated solids mass on the identified basis, not measured product deposition |
Check how the spreadsheet stores percentages. A cell containing 50% already represents 0.50 in ordinary percentage formatting; a cell containing the number 50 needs division by 100. Applying that division twice produces a result a hundred times too small. Test the formula with the simple 200 kg and 50% example before using it elsewhere.
If a source quantity is in litres, obtain the applicable density and its stated conditions before converting volume to mass. Do not assume one litre weighs one kilogram. Keep wet-film thickness, dry-film thickness and coat-weight targets out of this quantity worksheet unless the responsible technical team supplies the additional definitions and relationships.
Use the calculation to ask a better question
A useful inquiry identifies the intended application and asks for the exact proposed grade, its solids definition, applicable technical documentation and the quantity basis used in the offer. Send those questions through Haoxuan’s contact page, with the substrate and application context needed for technical review.
Keep suitability and material accounting as separate decisions. Matching calculated solids mass can make two quantity statements easier to understand; it cannot establish equal coating behavior, drying requirements, bond performance or finished-output yield. That boundary is what makes the worksheet useful without turning it into an unsupported substitution rule.