Documentation

Deliverable Checker User Guide

A visual guide to how Deliverable Checker connects structured Excel reference data with PDF checker regions and native DWG attributes, then brings the comparison into one review workflow.

Getting Started

One reference source, two validation pipelines

Deliverable Checker is a Windows desktop QA/QC application for validating information across engineering deliverables. Excel provides the structured expected values; PDF drawings are read through visual checker regions, while DWG layouts are read through block attributes and property mappings.

Reference dataExcel table + constants
Map propertiesExpected ↔ detected
PDF or DWGExtract deliverable values
ValidateReview exceptions

Project Files

Save the validation setup, keep source files authoritative

A .delck file stores the application configuration: Excel source settings, PDF checker geometry, DWG references and mappings, comparison options and interface state. Values that originate in drawings are read again from the external PDF and DWG files whenever the project is loaded or processed.

When a folder moves

Reconnect the Excel, PDF or DWG source at its new location. The saved rules remain in the project and the drawing-derived values are refreshed from the reconnected file.

When a source changes

Reload or update the source before comparison. This prevents previously extracted values from being treated as current drawing data.

Excel Configuration

Define exactly which Excel data the project will use

The Excel workspace is configured by selecting the workbook, worksheet and table range. The lookup property identifies the Excel column used to locate the correct row for each deliverable, while constant properties can provide reusable expected values outside the selected table.

Deliverable Checker Excel workspace with numbered callouts
1

Excel Preview

Displays the selected table and the visual states produced by comparison.

2

Source

Selects the Excel file, worksheet and table range used by the project.

3

Lookup Property

Defines the column used to match each PDF or DWG deliverable with its Excel row.

4

Constant Properties

Creates reusable expected values that can be mapped like Excel properties even when they do not come directly from a table column.

5

Excel Preview Legend

Explains the visual states used in the preview so correct values, errors, constants and other comparison states can be distinguished.

How the Excel settings relate to the workbook

The mapping image below is not explaining the meaning of the spreadsheet data. It shows what each numbered annotation is selecting or identifying between the application and the source workbook.

Excel application view and source workbook with updated numbered callouts
1

Excel Preview

Identifies the table preview loaded inside Deliverable Checker. This is the application-side representation of the selected Excel source.

2

Sheet

Links the application's Sheet setting to the workbook tab. The selected worksheet is INF.

3

Range

Defines the rectangular table area read by Deliverable Checker. The example range is A1:Y194, so the cells inside that interval are included in the source table.

4

File / Workbook

Points to the source workbook itself. The workbook shown is PYV-OZL-FLT-QAQC Table; this represents the Excel file rather than an individual cell or column.

5

Constant Properties

Shows the additional project-level reference values defined directly in the application. These values can be used like Excel properties without being tied to a specific table column.

PDF Workflow

Validate drawing content through visual checker regions

The PDF workspace combines the active PDF preview, checker geometry and direct preview controls. A Master checker provides the lookup value used to find the matching Excel record, while Normal and Sequential checkers capture the properties that need validation.

Deliverable Checker PDF workspace showing the active PDF preview, checker geometry, floating checker controls, Project PDFs, Checkers and Checker Properties
1

PDF Viewer

Shows the active PDF, checker geometry and the floating controls used to create checkers and work with Boundary Boxes directly in the preview.

2

Project PDFs

Adds, replaces, updates, removes and filters the PDFs included in the project.

3

Checkers

Organizes Master, Normal and Sequential checkers and their tags.

4

Checker Properties

Displays and edits the properties of the selected checker. The panel remains visible and empty when no checker is selected.

Working in the PDF Viewer

  • The + button in the upper-left corner of the preview opens the options to create a Normal Checker or a Sequential Checker.
  • The Show Boundary Boxes button in the upper-right corner displays the detected text regions; while they are visible, the control changes to Hide Boundary Boxes.
  • Only one Boundary Box can be selected at a time, and the selected Boundary Box uses a distinct visual state so the active selection is clear.
  • Boundary Box into Checker converts the selected Boundary Box exclusively into a Normal Checker.
  • Slice Boundary Box divides the selected Boundary Box.
  • Snap Points remain available for precise positioning while checker geometry is created or adjusted.
PDF file handling: The reference PDF can be changed from the ribbon. If every PDF is removed, use the central add action to reconnect the project. An unavailable reference can also be removed. For multi-page files, only the first page is processed.

PDF values mapped to Excel

The mapping view shows which value captured from the PDF is connected to which Excel property in the matched row.

PDF checker values mapped to Excel reference values
1

Drawing Number → Deliverable (Title)

The PDF reference checker captures PYV-OZL-FLT-SYD-DWA-SD-0001. That value is matched against the Excel DELIVERABLE (TITLE) column to locate the correct row.

2

Drawing Title → Description

The Drawing Title checker captures STORMWATER DRAINAGE / OVERALL LAYOUT PLAN / SHEET 01 OF 01 and maps it to the Excel DESCRIPTION property. The corresponding row contains Stormwater Drainage - Overall Layout Plan.

3

Scale → Drawing Scale

The PDF scale value 1/1000 is mapped to the Excel DRAWING SCALE property, whose reference value in the highlighted row is 1:1000.

4

Date → Date Required to Issue

The checker over the PDF Date field captures 15/05/26 and maps it to the Excel DATE REQUIRED TO ISSUE property. The highlighted row shows 12/11/2025.

  1. Add the PDF drawings that belong to the project.
  2. Configure the Master checker used to locate the matching reference row.
  3. Use the + button in the preview to create Normal or Sequential checkers for the information that needs validation.
  4. Use the Boundary Box controls when a detected text region can assist with checker creation or needs to be divided.
  5. Map each checker to an Excel or constant property.
  6. Run the batch comparison and review the results.

PDF Checkers

Master, normal and sequential validation regions

Master

Captures the drawing reference used to find the matching Excel row.

Normal

Captures text inside one defined region and compares it with one expected property.

Sequential

Uses multiple internal regions to capture and compare a structured sequence of values.

DWG Workflow

Validate native layouts through block attributes

With AutoCAD installed, the DWG workspace reads paper-space layouts, blocks and attributes. A reference drawing establishes the layout and block pattern reused across the project before property mappings are configured.

Deliverable Checker DWG workspace with numbered callouts
1

DWG Layout Viewer

Displays the selected paper-space layout and title block so the reference drawing, block and attributes can be inspected visually.

2

Property Mapping

Maps expected Excel or constant properties to individual or grouped block attributes and shows the extracted values.

3

Reference Drawing

Lists project DWGs and their layouts, identifies the active reference and provides controls to add or remove files. An unavailable reference may be removed, and a new DWG can be added from the empty central state when no drawings remain.

4

Reference Block

Defines the block and attribute used to identify each drawing, locate its Excel row and extract the mapped comparison values.

Boundary boxes: Dark blue rectangles indicate mapped block attributes; the purple rectangle identifies the Master/reference attribute used to match the drawing with its Excel row.
  1. Open a reference DWG and select a paper-space layout.
  2. Set the reference block and the attribute used as the drawing identifier.
  3. Add project DWGs and choose the layouts that should be processed.
  4. Create the property mappings between block attributes and expected values.
  5. Run DWG table extraction or direct comparison against Excel.

DWG Mapping

Connect native block attributes to expected properties

Property mappings define what is extracted from the configured reference block and which Excel or constant property each value represents. The image below shows the relationship between the DWG title block and the corresponding reference row.

DWG block attributes mapped to Excel reference values
1

Drawing Number → Deliverable (Title)

The reference block provides PYV-OZL-FLT-SYD-DWA-SD-0001. This is matched to the Excel DELIVERABLE (TITLE) value to identify the correct reference row.

2

Drawing Title → Description

The grouped DWG attributes TITLE-1, TITLE-2 and TITLE-3 provide STORMWATER DRAINAGE / OVERALL LAYOUT PLAN / SHEET 01 OF 01 and are mapped to the Excel DESCRIPTION property.

3

Scale → Drawing Scale

The DWG SCALE attribute contains 1/1000 and is mapped to the Excel DRAWING SCALE property, whose highlighted reference value is 1:1000.

Single mapping

Map one block attribute directly to an Excel or constant property.

Group mapping

Combine multiple block attributes into one mapped value using the configured separator and order.

Running Validation

Choose the operation that matches the deliverable

PDF comparison

Confirm PDFs, checker configuration and the Excel lookup property, then run the batch comparison.

PDF table extraction

Use Table Extraction from PDFs to save captured checker values as a structured XLSX table.

DWG table extraction

Extract mapped values from selected layouts and save the resulting rows to an XLSX workbook.

DWG comparison

Compare the extracted layout data directly against the selected Excel reference row.

Progress & cancellation

DWG processing reports progress per layout and supports cancellation while drawings are processed in the background.

Results & Reports

Focus on exceptions instead of rechecking everything

The results workspace consolidates validation output so reviewers can distinguish successful checks from mismatches, constant mismatches, missing references, duplicate references and processing failures. Use All, Errors, Constants or Correct to focus the preview, and hover a highlighted value to compare the expected and detected text.

Deliverable Checker validation results workspace
Results workspace — comparison output organized for focused review.
Validated values
Mismatched values
Not referenced in Excel
Duplicate references
Excel dates shown without an artificial time component
Comparison report kept in the primary worksheet without a redundant Reference sheet

Settings

Reusable comparison, PDF processing and project defaults

The Settings workspace separates the most important reusable behaviors from the document workspaces.

Deliverable Checker settings workspace with numbered callouts
1

Comparison Settings

Controls text normalization before comparison, including case, extra spaces and line breaks, hyphens, punctuation and accent handling.

2

PDF Processing

Controls PDF rendering quality, maximum zoom and caching of extracted PDF data.

3

Snap Points

Configures snapping used when placing and editing checker geometry. Endpoint, Midpoint, Intersection and Perpendicular point are available, with F3 used to toggle snapping.

4

Project Defaults

Defines the initial Excel range and checker dimensions reused when a project is configured.

Installation

Windows x64 installation

Download the latest installer from the project page, run the package and follow the installation prompts. One 64-bit installer is used for current 64-bit Windows systems.

DWG requirement: AutoCAD must be installed on the same computer to use DWG extraction and previews. PDF and Excel workflows remain available without AutoCAD.

Troubleshooting

Common checks before reporting a problem

  • Confirm the PDF, DWG and Excel files still exist at their saved locations.
  • For PDF checks, confirm the master checker and validation checkers are configured correctly.
  • For DWG checks, confirm AutoCAD is installed and the reference drawing, layout and block have been set.
  • Confirm every active DWG mapping has an expected property and at least one block attribute.
  • When comparing against Excel, confirm the worksheet, range and lookup property are correct.
  • If a mapped property is not an Excel table column, confirm it is supplied by a valid constant property.