How do I log daily control check shots against published coordinates and flag drifting or disturbed points with AI?
On a long site job the crews check into control every day, and those check shots end up in raw files and field books that nobody compares across weeks. A point that was bumped by equipment or is slowly settling shows up as a few hundredths creeping in one direction long before anyone notices a stakeout problem. Export the daily check shots, have Claude or ChatGPT turn the raw or report files into clean rows, and have Copilot in Excel or Gemini in Google Sheets compare each check with the published coordinates and plot the residuals over time per point. Whether a point is disturbed, and whether it must be re-established, stays with the licensed surveyor in charge.
Land Surveyor · Surveying · Claude · ChatGPT · Microsoft Excel · Microsoft Copilot · Google Sheets
Content updated · Tool links listed below; vendor features and pricing change, so confirm with the vendor
Short answer
Use Claude or ChatGPT, then Copilot in Excel or Gemini in Google Sheets: Claude or ChatGPT turns raw or report exports of daily check shots into clean rows; Copilot or Gemini computes residuals against the published control coordinates, flags checks outside your tolerance and points drifting the same direction day after day, and charts each point over time. On a long site job the crews check into control every day, and those check shots end up in raw files and field books that nobody compares across weeks. A point that was bumped by equipment or is slowly settling shows up as a few hundredths creeping in one direction long before anyone notices a stakeout problem. Export the daily check shots, have Claude or ChatGPT turn the raw or report files into clean rows, and have Copilot in Excel or Gemini in Google Sheets compare each check with the published coordinates and plot the residuals over time per point. Whether a point is disturbed, and whether it must be re-established, stays with the licensed surveyor in charge. A person still checks: every flagged point in the field with the party chief, and any re-established control with the licensed surveyor in charge.
AI tie-in
Tool: Claude or ChatGPT, then Copilot in Excel or Gemini in Google Sheets
Claude or ChatGPT turns raw or report exports of daily check shots into clean rows; Copilot or Gemini computes residuals against the published control coordinates, flags checks outside your tolerance and points drifting the same direction day after day, and charts each point over time.
Prompt 1
Here is the first part of my data collector export of check shots [paste]. Write a short Python script or Power Query steps that turn the full file into one row per check: date, crew, setup point, backsight, point checked, measured northing, easting, elevation and note. Explain how to run it on my own file. Don't invent fields that aren't in the export.
Prompt 2
Here are the headers and a few sample rows of my Control and Checks tabs [paste] and my firm's horizontal and vertical tolerances [paste]. Write Excel formulas (or a step-by-step Copilot plan) that compute residuals, flag checks outside tolerance, flag points that moved the same direction on three or more consecutive check days, and chart residuals by date per point. Use only my data.
Human check: Every flagged point in the field with the party chief, and any re-established control with the licensed surveyor in charge.
The problem
Log daily control check shots against published coordinates and flag drifting or disturbed points with AI. This is a common, time-consuming task for a land surveyor.
What this workflow does
On a long site job the crews check into control every day, and those check shots end up in raw files and field books that nobody compares across weeks. A point that was bumped by equipment or is slowly settling shows up as a few hundredths creeping in one direction long before anyone notices a stakeout problem. Export the daily check shots, have Claude or ChatGPT turn the raw or report files into clean rows, and have Copilot in Excel or Gemini in Google Sheets compare each check with the published coordinates and plot the residuals over time per point. Whether a point is disturbed, and whether it must be re-established, stays with the licensed surveyor in charge.
How it works: AI drafts or analyzes. A person operates the tools, checks the work, and takes action.
Your checkpoint: The log shows how check shots compare with published values over time. It does not adjust networks, decide whether a point is disturbed or certify any coordinate. Re-establishing or replacing control and anything that goes on a signed plat stays with the licensed surveyor in charge.
Before you start
- Access to the named tool; confirm license, version and cost with the vendor.
- A small, non-confidential sample to try the workflow on first.
- A qualified person to review the output before it is used.
Tools and access
Follow the steps
- On a Control tab, list each control point with its published northing, easting and elevation from your own control sheet, and type the check tolerances your firm uses for horizontal and vertical. Don't take tolerances from the AI.
- Export each day's check shots from the data collector or office software as CSV or a text report: date, crew, instrument setup, point checked, measured northing, easting and elevation, and any note.
- If the export format is messy, have Claude or ChatGPT write a short script or Power Query steps that turn it into one row per check shot. You run it on your own files and keep the raw files untouched.
- Have Copilot in Excel or Gemini in Google Sheets compute the horizontal and vertical residual for every check against the published values, flag checks outside your tolerance, and chart residuals by date for each point.
- Flag trends, not just failures: a point whose residuals move the same direction for several days, or one that fails from two different setups, goes on a review list before it fails a stakeout.
- Have the party chief look at every flagged point, record the field finding (bumped, settled, bad setup, typo) and log any re-established coordinates with the date, so later checks compare against the right values.
Try a small example
Replace the bracketed fields with your own project details. No tested sample run is published for this workflow yet.
Sample input
Fill in the bracketed [fields] in the text below with your project data.
Starter prompt
Here are the headers and a few sample rows of my Control tab [paste: point, published N, E, elev] and my Checks tab [paste: date, crew, setup, point, measured N, E, elev, note], plus the horizontal and vertical tolerances my firm uses [paste]. Write Excel formulas (or a step-by-step Copilot plan) that compute horizontal and vertical residuals for each check, flag checks outside my tolerances, flag points whose residuals moved the same direction on three or more consecutive check days, and build one residual-over-time chart per point. Use only my data; do not adjust coordinates or say whether a point is disturbed.
Expected output
Not published yet. Treat any output as a draft and check it against the source documents.
Check the result
- Every value, citation or quantity traces back to a source document.
- Missing information is marked as missing, not filled in.
Limits and recovery
- The log shows how check shots compare with published values over time. It does not adjust networks, decide whether a point is disturbed or certify any coordinate. Re-establishing or replacing control and anything that goes on a signed plat stays with the licensed surveyor in charge.
- Check your organization’s data policy before sharing project files with third-party tools.
Stop or switch when: The source cannot be verified, permissions are missing, or the result contains unsupported facts.
Frequently asked questions
How does AI help with this?
Claude or ChatGPT, then Copilot in Excel or Gemini in Google Sheets: Claude or ChatGPT turns raw or report exports of daily check shots into clean rows; Copilot or Gemini computes residuals against the published control coordinates, flags checks outside your tolerance and points drifting the same direction day after day, and charts each point over time. A person still checks: Every flagged point in the field with the party chief, and any re-established control with the licensed surveyor in charge.
How do I how do I log daily control check shots against published coordinates and flag drifting or disturbed points with AI??
On a Control tab, list each control point with its published northing, easting and elevation from your own control sheet, and type the check tolerances your firm uses for horizontal and vertical. Don't take tolerances from the AI. Export each day's check shots from the data collector or office software as CSV or a text report: date, crew, instrument setup, point checked, measured northing, easting and elevation, and any note. If the export format is messy, have Claude or ChatGPT write a short script or Power Query steps that turn it into one row per check shot. You run it on your own files and keep the raw files untouched. The full step list is above.
Does this use an AI agent or regular software?
It is labeled AI assists: AI drafts or analyzes. A person operates the tools, checks the work, and takes action.
What tools do I need?
Claude, ChatGPT, Microsoft Excel, Microsoft Copilot, Google Sheets. Confirm license, version and cost with the vendor, and try it on a small non-confidential sample first.
Has this workflow been tested?
Workflow guide · not independently tested. Written from vendor documentation and practitioner use. Labels apply to the steps described here, not every feature of a product. Links were checked when the page was written.
Evidence and maintenance
Written from vendor documentation and practitioner use. Labels apply to the steps described here, not every feature of a product. Links were checked when the page was written.