Skip to content

Method-specific report workpapers · U.S. inspection teams

Reconcile Tube Inspection Analyst Summaries

A consistent final tube map requires more than merging spreadsheets. Establish a common tube identity, retain each analyst’s actual evaluation and record the responsible decision that resolves every material difference.

NDT Connect Editorial · Published · Editorial policy

Start a free NDT report

Upload a Word or Excel template, edit the report fields and result tables, add company and client logos, and download a draft PDF. Use a free verified account for saved reports, sequential numbers and issued revisions.

No payment or signup required to prepare a draft PDF. Template import and PDF generation run in your browser.

Define the reconciliation unit before comparing results

Start with the specific record being compared: exchanger, inspection event, tube identity, location and examination method where relevant. Two rows with the same tube number may concern different acquisitions, indications or campaigns. Do not treat them as competing evaluations until that relationship is established. A reconciliation table should preserve the original source references and identify the exact question being resolved. This avoids changing a technically correct result merely because another spreadsheet uses a different level of summary.

Separate administrative mismatches from interpretation differences. A transposed row and column, an inconsistent status abbreviation and a different evaluation of the same signal require different actions. The report coordinator can identify and document the mismatch, but the responsible technical process resolves the interpretation. Keep that division visible. Reconciliation is successful when the final result has a supported source relationship, not when every cell in two spreadsheets has been made identical by copying one file over the other.

Establish one physical tubesheet reference

Identify the tubesheet map revision, viewing end and numbering convention used by each source. A mirrored view can make the same row and tube label point to a different physical location. Retain any crosswalk needed to relate the analyst files to the actual exchanger. Do not assume that matching coordinate text proves matching tube identity. Check the convention using the project’s source drawing or other established physical references before comparing the reported conditions.

Eddyfi’s TubePro description identifies tubesheet mapping and support for multiple inspection datasets. Those capabilities illustrate why map identity and dataset identity are separate pieces of a reporting workflow. They do not establish that two particular maps use the same convention. The reconciliation record should identify the actual map and source inspection for each result, including any approved renumbering relationship, rather than relying on the appearance of a familiar tubesheet graphic.

Preserve each analyst’s source record unchanged

Retain the original exported result and its revision or analysis-session reference through the project’s record process. Work from copies or a separate reconciliation table when documenting differences. Do not overwrite an analyst’s original code with the proposed final status before the responsible review occurs. That would remove the evidence of what differed and make it harder to explain how the final result was reached. The source record and the resolved reporting record serve different purposes.

Identify the actual analyst and review role associated with each evaluation where required. Do not infer authorship from a spreadsheet owner field or the person who forwarded the file. A report preparer may have exported data on behalf of an analyst. Preserve the source responsibility accurately so a question can reach the appropriate reviewer. This is particularly useful during shift changes, when the file received most recently may not represent the most recent technical assessment.

Reconcile the meaning of indication codes and legends

Compare code definitions before treating different abbreviations as different conclusions. Two systems may use different labels for a similar state, while the same abbreviation can have different meanings in separate projects. Retain the applicable legend and revision for each source. If the final report translates codes, document the approved mapping and preserve distinctions that matter to interpretation. Do not compress an unresolved, untested or limited record into a favorable category merely because the destination legend offers fewer choices.

INETEC’s EDDYONE ANALYSIS description lists an indication-code editor, landmark records and history management among its features. This is product context, not an assertion that its codes are universal. For reconciliation, preserve the actual code dictionary used in the source and the responsible mapping to the final report. A software-generated color or abbreviation becomes meaningful only when the recipient can identify the definition that applied to the reported dataset.

Distinguish tube status from individual indication records

A tube can contain several evaluated indications, while a summary map may display one controlling category for that tube. Identify how the project derives the summary and retain the underlying records. Do not compare a tube-level maximum or category directly with one local indication and conclude that the analysts disagree. First establish the aggregation rule and the set of records included. The final map should have a retrievable relationship to the detailed evidence supporting its displayed status.

Keep untested, blocked, previously plugged and limited-examination states distinguishable from evaluated condition categories. They describe different facts about the inspection and asset. A tube absent from the analyst’s indication table may still have been examined without a reportable finding, or it may not have usable examination data; the actual source establishes which. Never infer the more favorable state from a missing row. Record the reconciliation question and the evidence required to resolve the missing relationship.

Compare the same event and physical location

Identify the acquisition event and location convention behind each evaluation. Results from an initial pass and a later follow-up may both be valid records of different work. A location measured from one tube end also needs a clear relationship to a location measured from the other end. Preserve the actual datum, units and any segment reference. Do not merge indications solely because their distances are close or separate them solely because the source values differ.

If different methods contribute to the review, retain each method’s actual result and scope. A local confirmatory examination may address a specific question rather than reproduce the entire tube survey. The responsible technical process determines how the records relate and which conclusion is supported. The reconciliation worksheet should document that decision without treating every difference between techniques as an analyst error or assuming that the later numerical value automatically replaces all earlier findings.

Define a discrepancy record that leads to a decision

Give each material discrepancy a stable reference, the two source values or states, the exact question and the responsible review action. Keep the discussion focused on the evidence needed to resolve it. A note saying check tube is too vague if the disagreement concerns map orientation, code meaning or signal interpretation. State which relationship is uncertain. The table should let another reviewer continue the work without reconstructing the entire email conversation or guessing which version of the analysis was being discussed.

Record the actual decision and supporting evidence when the issue is resolved. Do not use closed as the only explanation. Identify whether the outcome corrected an administrative mapping, confirmed one evaluation, retained both records for different events or required additional work. Where the technical question remains open, preserve that state in the final scope and summary as appropriate. A reconciliation process should not hide unresolved issues merely to produce a uniform-looking tubesheet map by the reporting deadline.

Worked example: matching tube labels from opposite views

In a fictional exchanger review, analyst file A and analyst file B both contain row 6, tube 12, but they use opposite tubesheet viewing conventions. The coordinator initially records a technical disagreement because the categories differ. A source-map check shows that the labels refer to different physical tubes. The team establishes the actual crosswalk and repeats the comparison using physical identity. The original evaluations remain intact; the reporting error was the assumed relationship between their coordinate labels.

After remapping, one genuine evaluation difference remains on a confirmed common tube and acquisition event. That question goes through the responsible technical review and receives its own documented resolution. This hypothetical example defines no acceptable evaluation difference or decision hierarchy. It demonstrates why identity reconciliation should precede interpretation reconciliation: otherwise a team can spend time debating two unrelated records and still issue a map that assigns a correct result to the wrong physical tube.

Fictional analyst reconciliation decisions
DifferenceFirst evidence checkResponsible outcomeShortcut to avoid
Same label, opposite map viewsTubesheet end and numbering conventionDocument actual identity crosswalkAssume labels identify the same physical tube
Different abbreviationsSource legends and revisionsPreserve approved code mappingTreat every abbreviation difference as a technical conflict
Tube summary versus local recordAggregation rule and included indicationsCompare at the same record levelReplace the summary with one selected indication
Confirmed same-event evaluation differenceActual data and analysis referencesDocument the responsible technical decisionChoose the newest spreadsheet automatically

Reconcile quantities without hiding excluded records

Count the planned tubes, actual examination records and report categories according to their defined units. Do not expect the total indication count to equal the tube count. One tube may have several indications, while another has no reported indication or a documented examination limitation. Preserve those relationships in the summary. If the source datasets use different inclusion rules, record the difference before comparing totals or presenting a percentage as a project performance measure.

Check that tubes excluded from a final condition chart remain visible in the appropriate examination-status record. A map can look reassuring if blocked or untested tubes simply disappear from its denominator. Use the actual agreed summary basis and explain it to the recipient. This worksheet does not prescribe a statistical assessment or engineering acceptance threshold. It helps the report show which identified tubes the summary represents and where the available evidence does not support a condition category.

Keep historical comparisons separate from current reconciliation

An earlier inspection can provide context, but it is not another analyst’s evaluation of the current event unless the records establish that relationship. Preserve campaign dates, methods, map revisions and location conventions. Do not label a change between years as a current review disagreement. The responsible technical process determines whether the historical and current results are comparable and what a difference means. The report should retain that assessment rather than infer growth or improvement from a changed category alone.

If tubes have been replaced, plugged or renumbered, establish the actual history before carrying earlier results into the current map. A matching coordinate may identify a location occupied by a different tube. Keep component identity and tubesheet position distinguishable where the source records require it. This prevents a historical result from being attached to a replacement component and avoids presenting a sequence of unrelated observations as a continuous condition history.

Check the basis of quantitative fields before resolving a difference

Two numerical entries can differ because they represent different quantities. Confirm whether a percentage describes reported wall loss, remaining wall, a category boundary or another defined result. Preserve the reference thickness and units where they form part of the actual evaluation basis. Do not compare percentages from different definitions as if they were two estimates of the same quantity. Equally, do not convert an analyst’s reported value into another representation without retaining the original and the reviewed conversion relationship. The reconciliation record should identify the field meaning before asking a reviewer to explain a numerical difference.

A changed reference or processing setup may also require technical review before two outputs are considered comparable. Record the actual calibration or analysis reference supplied with each result, rather than assuming that all files from the same instrument used identical settings. The report coordinator should not average competing values to create a compromise result or choose the larger number as an automatic conservative answer. Neither action explains the evidence. Preserve the actual responsible determination of which value, qualified range or unresolved status belongs in the final report, including the reason and affected tube or indication records.

Publish one controlled legend and one resolved result relationship

Once the responsible review is complete, generate the final tables, map and summary from the agreed resolved record. Check that they use the same legend, inclusion rules and dataset reference. A corrected table can coexist with an old map if the package is assembled manually. Verify the actual delivered files instead of assuming that changing the spreadsheet automatically updates every graphic or report section. Preserve the relationship between the final issue and the source reconciliation record.

Keep the original analyst files and the resolution history retrievable through the project’s record process. The client-facing report may contain a concise summary, while the detailed workpaper remains part of the technical package. Describe that arrangement accurately. Do not imply that all disagreement records are attached if they are retained separately, and do not portray the final document’s Issued label as independent technical approval. The actual reviewer decision and its scope remain separate evidence.

Use the reporting workspace for the resolved workpaper

The free digital reporting tool can hold the resolved discrepancy table, summary and explanatory notes. Supported DOCX and XLSX tables can be imported after preview. It does not parse native eddy-current files, merge analyst databases or automatically reconcile tubesheet maps. Keep the source data and specialist analysis in the appropriate external workflow. The report should reference those records accurately rather than suggesting that the application independently checked their technical consistency.

The equipment tracker can support instrument and probe references, and the procedure draft tool can help organize proposed review responsibilities. Neither resolves interpretation differences. The tube-map software buyer guide addresses system-selection questions; this workpaper addresses the actual delivered result. Use the tools to organize evidence and decisions without confusing an administrative import, a software feature or a polished report with a completed technical reconciliation.

Trace one resolved discrepancy through the final package

Select a discrepancy that changed a report result and follow it from the original source records to the documented decision, final table and tubesheet display. Confirm the physical tube identity and the meaning of the final legend. Then inspect an unresolved or excluded record to verify that its status remains visible. This reveals inconsistencies that a simple total-count check can miss, particularly when several people prepared maps, tables and narrative summaries independently.

Use the report buyer-review guide for broader delivery checks and replace the fictional worksheet entry with actual reviewed evidence. A useful reconciliation record makes the final map explainable: the recipient can identify the tube, the source evaluation and the reason a particular status was reported. It preserves professional judgment and source history while preventing naming differences, aggregation rules or spreadsheet order from silently determining a technical result.

Tube analyst discrepancy and resolution register

Download this editable CSV for the task described above. Replace illustrative prompts with your own supported facts. The worksheet is a planning aid; it does not establish inspection acceptance or approval.

Download the free workflow worksheet

Questions about this workflow

Should the latest analyst spreadsheet automatically control the final map?

No. Establish the actual event, revision and responsible review decision. A later export may not represent a later technical evaluation.

Do matching row and tube labels prove the records refer to the same tube?

Not without confirming map orientation, numbering and revision. Opposite viewing conventions can assign the same label to different physical tubes.

Should the indication count equal the tube count?

Not necessarily. A tube can contain several indications or have a separate examination-status record. Define the unit and inclusion rule for each total.

Does NDT Connect automatically merge native tube-analysis datasets?

No. It organizes reviewed text and supported DOCX or XLSX tables. Native analysis, map correlation and technical reconciliation remain in the appropriate external process.

Sources and editorial scope

Primary references support the specific context cited in the guide. Worked examples and suggested workflows are NDT Connect editorial guidance. Confirm the documents and authority applicable to the actual assignment.

More guides: method-specific report workpapers

  • Track Guided-Wave Screening Indications to Follow-Up

    A screening indication and a local examination result answer different questions. Keep both records linked without converting the screening output into a local minimum-thickness value or treating a completed work order as technical closure.

  • Record MT Examination Coverage and Sequence References

    A statement that MT was performed should identify the actual examined surfaces and the arrangement supporting that scope. Preserve executed coverage, sequence references and limitations without prescribing a generic magnetizing technique.

  • Link PAUT Report Views to Scan Coverage Evidence

    A selected PAUT view is a presentation of part of an examination record. Explain which data and coverage it represents, which context was used to interpret it and what remains outside the supported claim.

  • Link PEC Screening Areas to Confirmatory Examinations

    A PEC screening result represents a defined measurement context and averaging area. Keep that meaning separate from local readings obtained during follow-up, and document how the responsible review connects the two.

Free tools for this workflow

Free digital NDT reporting

Import DOCX/XLSX tables, enter specifications and results, add logos and download a PDF. A free verified account saves numbered reports and revisions.

Equipment tracker

Maintain an account equipment register and supporting records. An entry does not establish equipment fitness for a particular examination.