A supplier reports a Vickers hardness result. Its spreadsheet contains two indentation diagonals, the applied force and a calculated value. The overseas buyer wants to check the arithmetic before forwarding the certificate to engineering.
That review starts with the original measurements and their units. It also needs the calculation rule used for the mean diagonal, the reporting convention and a stable reference to the tested indentation. A rounded hardness column alone leaves the calculation difficult to reproduce.
This guide follows one fictional Vickers calculation from input readings to an exported report. The worked values are invented. The method and acceptance requirements for a real component belong in the approved inspection procedure.
Why the calculation uses both diagonals
ZwickRoell describes Vickers testing as an optical indentation method using a diamond pyramid. The residual indentation's two diagonals are measured, and their mean is used with the applied force to calculate the result. Its explanation identifies the average of those diagonals when calculating the indentation surface area. ZwickRoell Vickers method overview
For a report reviewer, both readings therefore matter. Preserve the pair and identify which indentation they describe. A table with one diagonal column needs an explanation of whether that field holds a raw reading or a calculated mean.
The distinction becomes visible during data transfer. One system may export d1 and d2 separately while another expects a single mean-diagonal field. The mapping should state how that derived field is obtained and where the original pair remains available.
An image can help locate the indentation, while the numerical record allows the calculation to be reproduced. Connect them through the same test or indentation identifier so that a reviewer can inspect the intended pair of readings.
Retain the procedure and force designation
ISO's public description of the 2023 edition of ISO 6507-1 identifies the Vickers test method for metallic materials and distinguishes force ranges within its scope. That public catalogue description helps identify the applicable document. The laboratory uses the complete procedure relevant to its actual work. ISO 6507-1 public scope
In a purchasing record, identify the agreed method and edition, the applied force and the test designation. Preserve the original certificate notation alongside any explanatory English wording.
A reviewer can then distinguish the numerical calculation from conformity with the complete method. Reproducing a hardness value checks a particular relationship between recorded inputs. Assessing specimen preparation, equipment, force application and reporting requires the appropriate procedure and measurement evidence.
When a supplier proposes a different force, have the responsible technical reviewer assess its applicability to the requirement. Record that decision with the inspection plan so that the reported result remains connected to the order's agreed basis.
Reproduce one fictional indentation
Mitutoyo's Quick Guide gives the Vickers relationship, with force F in newtons and mean diagonal d in millimetres, as approximately HV = 0.1891 × F / d². Its explanation identifies d as the mean of the two measured diagonal lengths. Mitutoyo Quick Guide, printed page 62, PDF page 64
Use the following invented readings for a calculation exercise.
| Input | Fictional value |
|---|---|
| Applied force F | 294.2 N |
| First diagonal d1 | 0.39 mm |
| Second diagonal d2 | 0.41 mm |
| Mean diagonal d | 0.40 mm |
First calculate the mean, (0.39 + 0.41) / 2 = 0.40 mm. Then square that mean, giving 0.16 mm². The formula gives 0.1891 × 294.2 / 0.16 = approximately 347.7 HV.
Now deliberately substitute the second diagonal alone. The expression becomes 0.1891 × 294.2 / 0.41², approximately 331.0 HV. Using the first diagonal alone gives approximately 365.8 HV.
These three values arise from changing the calculation input. They show the inverse-square dependence on d and the importance of identifying the field supplied to the formula. The correct treatment of an actual indentation follows the applicable procedure.
Keep sufficient input precision to reproduce the calculation, then apply the required reporting convention. A one-decimal display in this exercise serves the explanation. The actual certificate's rounding and designation should follow the agreed method.
Bind each number to its unit
The coefficient above is written for newtons and millimetres. A transferred force value needs its unit in the data dictionary. A diagonal read in micrometres needs conversion to the unit used by the calculation.
In the fictional example, 0.40 mm equals 400 micrometres. The numerical values differ by a factor of 1,000. Substituting 400 directly into a formula expecting millimetres changes the squared denominator by a factor of 1,000,000.
A reviewer should therefore inspect the field definition and the conversion step, alongside the displayed heading. Keep the received value and unit with the normalized value and unit when both are part of the evidence package. That makes a transfer correction traceable.
Use an explicit field name or separate unit field in an exported dataset. A bare column called “load” can leave the recipient uncertain about the intended force unit. Agree how the file represents units before using it to reproduce certificate values.
Keep raw, derived and displayed values connected
A compact report record can retain an indentation ID, d1, d2, their units, the calculated mean, applied force, the calculated hardness and the displayed result. The report reference connects that record to the tested specimen and procedure.
This is a proposed document-review structure. The laboratory's supported report and contractual evidence package determine what the customer receives.
For the fictional calculation, the reviewer should be able to follow 0.39 and 0.41 into 0.40, then follow that mean and 294.2 into the reported calculation. If the export rounds the mean earlier than the report calculation does, preserve the underlying precision or document the difference.
Also identify what a summary row represents. It might describe one indentation or a statistic calculated from several results. A reviewer needs the contributing observations and the defined aggregation rule to reproduce a summary. A convenient spreadsheet heading should preserve that meaning across translations and exports.
Review a corrected reading as a new calculation version
Suppose a reviewer corrects one fictional diagonal reading after checking the retained image. The correction should identify the affected indentation and the reason for the amendment. Retain the original reading and the corrected value according to the agreed record policy.
Recalculate the mean and hardness using the corrected inputs. Record which report version uses the new result and whether the change affects the purchasing conclusion. That sequence makes the correction understandable to someone who received the earlier certificate.
The calculation version and the test identity answer different questions. An amended interpretation of an existing reading can refer to the same indentation. A new test requires its own measurement record and identity. Keep that relationship clear in the report's amendment history.
This review structure also helps when a spreadsheet formula is repaired. Identify the rows and outputs affected by the formula change and preserve the earlier file. The responsible technical reviewer can then decide what communication and report amendment the actual order requires.
Put the arithmetic inside the wider inspection question
A reproduced calculation supports checking the numerical result from the declared inputs. The buyer still needs to establish which specimen, condition and location the result represents.
For a surface-hardened component, the requested evidence might concern the surface, the core or a hardness profile. The existing guide to those distinctions explains the separate inspection questions. Link the calculation record to the relevant one. Surface hardness, core hardness and case depth
If a document also presents a converted scale, retain the native measured result and its reference. Buehler discusses the empirical basis and limits of hardness conversion relationships, supporting a specific applicability review for the material and intended use. Buehler hardness conversion guidance
For an English product page, summarize the approved capability or result with its method and scope. The supplier's engineering owner approves the technical facts. Xindar can organize the buyer explanation, evidence references and inquiry route around that approved material. Xindar manufacturing export services
Questions buyers ask about the calculation
Why retain two diagonal readings if the report already gives the mean?
The original pair lets a reviewer reproduce the mean and investigate a transfer or calculation discrepancy. Connect the readings and any supporting image to the same indentation identifier.
Can a rounded mean reproduce the displayed hardness exactly?
It depends on the precision used in the original calculation and the report's rounding rule. Request sufficient underlying precision and the applicable calculation convention when exact reproduction is part of acceptance.
Does the sensitivity example provide an uncertainty budget?
It shows the effect of substituting three declared diagonal values. A measurement uncertainty evaluation needs the actual process, equipment, relevant contributions and approved evaluation approach.
What should a supplier send with a disputed value?
Request the report and indentation references, the available original readings and units, the applied force, calculation rule and relevant amendment history. Route the purchasing decision to the technical owner responsible for the agreed requirement.
