Overview
Scope: Every floor plan sheet and the door schedule sheet in the active PDF open in Bluebeam Revu.
Produces:
- Red highlight markups on plan door tags with no schedule entry (Type B)
- Yellow highlight markups on matched plan door tags, authored by Claude,
with full schedule data embedded as custom column values Door_Schedule_Embed_[ProjectName].xlsx — gap register + summary
Background — Two Reconciliation Failure Modes
Type A — In schedule, not on any plan: A door number appears in the schedule but no matching tag was found on any floor plan sheet. The door is specified but never located. The schedule row may be orphaned, or the tag was accidentally deleted from the plans. No markup can be placed — there is no plan location. The register flags these.
Type B — On plan, not in schedule: A door tag appears on a floor plan but no matching row exists in the schedule. The door exists on the drawings but is unspecified. Red highlight markup is placed on the tag on the plan.
Step 1 — Read Document Structure
Step 2a — Extract Schedule Headers
Step 2b — Build the Door Data Dictionary
Step 3 — Extract Door Tags from Floor Plans (Three-Pass Strategy)
Step 4 — Normalize and Filter False Positives
Step 5 — Cross-Reference: Identify Mismatches
Step 6 — Place Red Highlights on Type B Tags
Step 7a — Read Existing Custom Columns
Step 7b — Determine Columns to Create
Step 7c — Create Missing Custom Columns
Step 8 — Place Yellow Data Highlights on Matched Door Tags
Step 9 — Build Excel Workbook
Step 10 — Deliver Output
Step 11 — Chat Summary
Disclaimer: AI-generated results may vary based on individual user context, prior interactions, and stored memory within connected AI systems. Always review outputs for accuracy and suitability before using them in any professional or compliance-related workflow.
