This article was created from a community discussion.
Use Case
Reads the door schedule and all floor plan sheets in the active PDF open in Bluebeam Revu. Reconciles every door number in the schedule against every door tag found on the plans and flags mismatches in both directions. Then reads the schedule column headers (dynamically — no hardcoded list), creates matching custom columns in the PDF (skipping any that already exist), places a yellow highlight markup authored by Claude on each matched door tag on the floor plans, and populates every custom column with the corresponding schedule row data for that door. Use this skill whenever the user asks to "reconcile the door schedule", "embed door schedule data on the plans", "check door tags against the schedule", "find missing doors", "verify door numbers", "annotate door tags with schedule data", "audit the door schedule", or any equivalent request combining door schedule verification and data embedding in Bluebeam Revu.
Requirements & Setup
Bluebeam MAX, Claude. Upload door-schedule-data-embed.skill file.
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.