A model confuses yuan with ten-thousand-yuan units, or percentages with percentage points: how do you check units?
Unit checks require the original value, unit and conversion rule rather than a bare number. Retain original units, define target units and rounding, then verify results through reproducible calculations.
Start troubleshooting here
Unit checks require the original value, unit and conversion rule rather than a bare number. Retain original units, define target units and rounding, then verify results through reproducible calculations. Yuan and ten-thousand-yuan units differ, as do percentages and percentage points; record those distinctions in fields instead of judging whether a number looks plausible.
Preserve units next to the original numbers
This applies when reports treat ten-thousand-yuan amounts as yuan or describe relative percentage changes as percentage-point increases. Preserve original row and column locations and adjacent units, including units stated only in headings. Different sheets can use different definitions; matching field names do not make all values directly additive.
Check whether cleanup removed important symbols
Check whether extraction deleted unit columns or cleanup removed percent and minus signs. Determine whether the target requires original or converted values. Specify precision and rounding stages for decimals: once intermediate values are rounded, the original exact total cannot necessarily be reconstructed from the output.
Use reproducible calculations for unit conversion
Retain the original value and unit alongside the normalized result, performing calculations separately. Applications needing strict decimal arithmetic can use decimal-capable tools rather than treating binary floating-point display artifacts as changed evidence. Validate rules on small synthetic decimal and mixed-unit samples before processing full material, retaining values that cannot be converted.
Verify statistical scope and missing information too
Cover negative values, decimals and missing units. Reverse the conversion or recalculate independently, check row and column mapping, and leave unknown units unresolved. Uniform formatting does not establish matching definitions: periods and populations must also match before combining data or describing growth. Reopen an export to check that saving did not change field types or displayed units.
This page calculates no real business data and does not confirm business definitions. Some relative changes require a baseline; two percentages alone do not supply their full context. Keep ambiguous units pending confirmation rather than adding an unsupported definite unit merely to make a table tidy.
Checked sources
These sources support the concepts and methods described here. Examples and test scope are labeled separately; check the version of the tools you use.