Point Comparison & Matching Calculator: As-Built vs. Design Delta Reports

Welcome to the Point Comparison Calculator at sitemath.net. When verifying construction tolerances, checking holding-down bolts, or generating final as-built deliverables, comparing your field-surveyed coordinates against the 3D design model is a daily necessity.

Instead of wrestling with complex VLOOKUP or INDEX/MATCH formulas in spreadsheets, or waiting for heavy CAD software to load, this tool instantly cross-references your bulk raw survey data against your design points to generate a survey-grade Delta Report.

Sample Data

Two Ways to Match Your Data

Surveyors capture data differently depending on the task. Our matching engine offers two distinct algorithms to accommodate your field methods:

• Match by Point ID (Name): Ideal for strict control networks, monitoring points, or targeted set-outs. If your field surveyor named the as-built shot exactly the same as the design point (e.g., HD-01 and HD-01), this method instantly pairs them up, regardless of how far apart they are in space.
• Match by Position (3D Radial Search): The ultimate time-saver for bulk as-builts. In the real world, field points are often coded generically (e.g., CONC or PILE) with sequential numbers. By entering a Search Tolerance, the geometric engine projects a true 3D sphere around every single design point. It scans your entire as-built dataset and automatically locks onto the closest surveyed point within that radius.

Understanding the Delta Report

To ensure consistency across civil and structural engineering workflows, our calculator strictly uses the standard construction convention for its output:

Delta = Design Point – Surveyed Point

When reviewing your 3D Deltas (Delta X, Delta Y, Delta Z), keep these standard rules of thumb in mind:

• Positive Elevation Delta (+): The surveyed point is lower than the design. It requires filling, shimming, or raising to meet the design grade.
• Negative Elevation Delta (-): The surveyed point is higher than the design. It requires cutting, grinding, or lowering to meet the design grade.

The report also provides the true 3D Distance between the paired points, giving you an immediate, single-number metric to check against your project’s maximum spatial tolerance.

How to Use the Point Matching Tool

At sitemath.net, we prioritize frictionless data entry so you can get your reports done and move on.

1. Paste Design Points: Copy your design coordinates directly from your CSV. Format strictly as: Point ID, Easting (X), Northing (Y), Elevation (Z).
2. Paste Surveyed Points: Paste your raw as-built or field shots into the second box.
3. Select Match Mode: Choose whether to link points by their ID name, or by 3D Position. If using Position, enter a realistic search tolerance (e.g., 0.05 for a 50mm search radius).
4. Calculate: Hit the button to run the matching engine. The calculator will provide a summary of successful matches and explicitly flag how many design points were left unmatched.
5. Batch Save and Export: Review the Delta table. Click Save Report, and once you have processed all your zones or files, click Export All to download a clean, horizontal CSV report ready for your QA/QC submission.

Frequently Asked Questions (FAQ)

What happens if multiple surveyed points fall within the 3D search radius?

If you are matching by Position and your surveyor took multiple shots near the same design point, our geometric engine calculates the true 3D vector to every point inside the search sphere. It will automatically discard the outliers and pair the design point with the single closest surveyed point.

Why are some of my design points showing as “Unmatched”?

If a design point is unmatched, it means the calculator could not find a corresponding field shot. If you are matching by ID, double-check for typos or extra spaces in your point names. If you are matching by Position, the surveyed point likely falls outside the Search Tolerance you specified. Try increasing the tolerance radius by a few millimeters.

Can I export my Delta Report to Excel?

Yes. The batch export tool generates a horizontally structured CSV file. It perfectly aligns the Design Point, the Matched Survey Point, and the calculated Deltas on a single row, making it instantly readable and formatted for Excel without any manual copying and pasting.

Technical Specifications & App Details