--- title: How do I track special inspection discrepancies from daily reports to resolution and the final report with AI? | AEC Agents url: https://aecagents.si/use-cases/special-inspection-nonconformance-log description: Special inspectors write the same discrepancy in a daily report, then again in the next one, and by the end of the job nobody can say which items were corrected, which were accepted by the engineer and which are still open when the final report is due to the building department. Keep one discrepancy log built from the daily reports, and have Claude or ChatGPT pull every noted discrepancy, correction and reinspection out of the reports into it. Copilot in Excel or Gemini in Google Sheets tracks the open items by inspection type and age so the final report is not held up by an item nobody closed. Whether an item is resolved, and what goes in the final report, stays with the inspector and the registered design professional. last_modified: 2026-11-11 source: AEC Agents (free, open workflows; not engineering advice) --- [AI assists](https://aecagents.si/use-cases/special-inspection-nonconformance-log#honesty-labels)Workflow guide · not independently tested # How do I track special inspection discrepancies from daily reports to resolution and the final report with AI? Special inspectors write the same discrepancy in a daily report, then again in the next one, and by the end of the job nobody can say which items were corrected, which were accepted by the engineer and which are still open when the final report is due to the building department. Keep one discrepancy log built from the daily reports, and have Claude or ChatGPT pull every noted discrepancy, correction and reinspection out of the reports into it. Copilot in Excel or Gemini in Google Sheets tracks the open items by inspection type and age so the final report is not held up by an item nobody closed. Whether an item is resolved, and what goes in the final report, stays with the inspector and the registered design professional. [Inspector / Plan Reviewer](https://aecagents.si/roles/inspector-plan-reviewer) · Code & inspection · Claude · ChatGPT · Microsoft Excel · Microsoft Copilot · Google Sheets Content updated 11 November 2026 · 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 pulls every discrepancy, correction, reinspection and acceptance out of daily special inspection reports into one log and proposes which later entries are the same item; Copilot or Gemini tracks open items by inspection type and age and lists items marked closed with no supporting report. Special inspectors write the same discrepancy in a daily report, then again in the next one, and by the end of the job nobody can say which items were corrected, which were accepted by the engineer and which are still open when the final report is due to the building department. Keep one discrepancy log built from the daily reports, and have Claude or ChatGPT pull every noted discrepancy, correction and reinspection out of the reports into it. Copilot in Excel or Gemini in Google Sheets tracks the open items by inspection type and age so the final report is not held up by an item nobody closed. Whether an item is resolved, and what goes in the final report, stays with the inspector and the registered design professional. A person still checks: each proposed match, whether each item is actually resolved, and the final report's contents, with the registered design professional and the building official. ## AI tie-in **Tool:** Claude or ChatGPT, then Copilot in Excel or Gemini in Google Sheets Claude or ChatGPT pulls every discrepancy, correction, reinspection and acceptance out of daily special inspection reports into one log and proposes which later entries are the same item; Copilot or Gemini tracks open items by inspection type and age and lists items marked closed with no supporting report. ### Prompt 1 ``` Here are my daily special inspection reports [upload]. Build a table with one row per discrepancy: date first noted, report number, inspection type, location as written, description copied exactly, reported to, and any later report recording a correction, reinspection or engineer's acceptance with its number and date. Mark it OPEN unless a later report records resolution. Do not judge compliance or supply code requirements. ``` ### Prompt 2 ``` Here are the headers and a few sample rows of my Log tab [paste]. Write Excel formulas (or a step-by-step Copilot plan) for a summary of open discrepancies by inspection type with days open, items never recorded as reported to the contractor, and items marked closed with no report reference. Use only my data. ``` **Human check:** Each proposed match, whether each item is actually resolved, and the final report's contents, with the registered design professional and the building official. ## The problem Track special inspection discrepancies from daily reports to resolution and the final report with AI. This is a common, time-consuming task for a inspector / plan reviewer. ## What this workflow does Special inspectors write the same discrepancy in a daily report, then again in the next one, and by the end of the job nobody can say which items were corrected, which were accepted by the engineer and which are still open when the final report is due to the building department. Keep one discrepancy log built from the daily reports, and have Claude or ChatGPT pull every noted discrepancy, correction and reinspection out of the reports into it. Copilot in Excel or Gemini in Google Sheets tracks the open items by inspection type and age so the final report is not held up by an item nobody closed. Whether an item is resolved, and what goes in the final report, stays with the inspector and the registered design professional. **How it works:** AI drafts or analyzes. A person operates the tools, checks the work, and takes action. **Your checkpoint:** The log only shows what the reports record. It does not decide whether work conforms, whether a correction is adequate or whether an item may be accepted as is. Resolution of each discrepancy, the engineer's acceptance and the final report's contents stay with the special inspector, the registered design professional and the building official. ## 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 - [Claude (Anthropic)](https://www.anthropic.com/claude) - [ChatGPT](https://chatgpt.com/) - [Microsoft Excel](https://www.microsoft.com/microsoft-365/excel) - [Microsoft Copilot](https://www.microsoft.com/microsoft-365/copilot) - [Google Sheets](https://workspace.google.com/products/sheets/) ## Follow the steps 1. Start from the project's statement of special inspections and type the inspection types you are responsible for into a Settings tab (for example structural steel bolting, welding, concrete placement, masonry, anchors, soils). Use your own copy of the statement; the AI doesn't add items. 2. Collect the period's daily special inspection reports. Use an AI account your firm allows for project documents. 3. Have Claude or ChatGPT build a Log tab with one row per discrepancy: date first noted, report number, inspection type, location as written, description copied exactly, who it was reported to, and any later report that notes a correction, reinspection or engineer's acceptance, with that report's number and date. 4. Have it propose when a discrepancy in a later report is the same item as an earlier one, marking each proposed match REVIEW. You confirm the matches. 5. Have Copilot in Excel or Gemini in Google Sheets show open items by inspection type, days open, and items with no record of being reported to the contractor, and list items marked closed with no supporting report reference. 6. Send the open-items list to the contractor and the design team on your usual schedule, and use the log as the discrepancy section draft for the final report, which you write and sign. ## 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 my daily special inspection reports for this period [upload] and the inspection types I am responsible for [paste]. Build a table with one row per discrepancy: date first noted, report number, inspection type, location as written, description copied exactly, reported to, and any later report in this set that records a correction, reinspection or acceptance by the engineer, with that report number and date. Mark a discrepancy OPEN unless a later report records its resolution. Copy text exactly. Do not judge whether work complies, do not supply code or specification requirements and do not mark anything resolved on your own. ``` ### 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 only shows what the reports record. It does not decide whether work conforms, whether a correction is adequate or whether an item may be accepted as is. Resolution of each discrepancy, the engineer's acceptance and the final report's contents stay with the special inspector, the registered design professional and the building official. - 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 pulls every discrepancy, correction, reinspection and acceptance out of daily special inspection reports into one log and proposes which later entries are the same item; Copilot or Gemini tracks open items by inspection type and age and lists items marked closed with no supporting report. A person still checks: Each proposed match, whether each item is actually resolved, and the final report's contents, with the registered design professional and the building official. How do I how do I track special inspection discrepancies from daily reports to resolution and the final report with AI?? Start from the project's statement of special inspections and type the inspection types you are responsible for into a Settings tab (for example structural steel bolting, welding, concrete placement, masonry, anchors, soils). Use your own copy of the statement; the AI doesn't add items. Collect the period's daily special inspection reports. Use an AI account your firm allows for project documents. Have Claude or ChatGPT build a Log tab with one row per discrepancy: date first noted, report number, inspection type, location as written, description copied exactly, who it was reported to, and any later report that notes a correction, reinspection or engineer's acceptance, with that report's number and date. 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. ## Where to go next - [How do I pre-check plans against code with AI before formal review?](https://aecagents.si/use-cases/ai-plan-review) - [How do I run site inspections and punch lists on a tablet?](https://aecagents.si/use-cases/punch-and-inspections) - [How do I track concrete cylinder break reports in a quality log and flag sets for engineer review with AI?](https://aecagents.si/use-cases/concrete-cylinder-break-log) - [All Inspector / Plan Reviewer workflows](https://aecagents.si/roles/inspector-plan-reviewer) - [All Field, quality and safety workflows](https://aecagents.si/tasks/field-safety) ## 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. - [Claude (Anthropic) (vendor site)](https://www.anthropic.com/claude) - [ChatGPT (vendor site)](https://chatgpt.com/) - [Microsoft Excel (vendor site)](https://www.microsoft.com/microsoft-365/excel) - [Microsoft Copilot (vendor site)](https://www.microsoft.com/microsoft-365/copilot) - [Google Sheets (vendor site)](https://workspace.google.com/products/sheets/) ## Put it to work Start with a small sample and keep the original record open while you verify the result. ## Know what does the work. Agent executes : An AI agent calls connected tools to carry out bounded actions. You set permissions and review the result. AI assists : AI drafts or analyzes. A person operates the tools, checks the work, and takes action. Conventional automation : Rules or specialist software perform the task. No AI agent is required.