inspect_and_audit_boq_xlsx
Parse Excel Bill of Quantities workbooks and audit visible rows for math mismatches, hardcoded totals, sum gaps, shared formulas, zero quantities, and zero prices while skipping hidden data.
Instructions
[STEP 3C of HITL Workflow] Safely parse and mathematically audit an Excel (.xlsx / .xlsm) Bill of Quantities.
Safety & Auditing Features:
- Strictly skips `hidden` and `veryHidden` worksheets (listing them in `skipped_hidden_sheets`)
- Strictly skips hidden rows (`row_dimensions[r].hidden`)
- Automatically detects Single-Price and Hungarian TERC Split (Material + Labor) column layouts
- Audits 100% of rows on selected visible sheets for `MATH_MISMATCH`, `HARDCODED_TOTAL`,
`SUM_RANGE_GAP`, `SHARED_FORMULA_RISK`, `ZERO_QUANTITY`, and `ZERO_UNIT_PRICE`
(even when `keyword_filter` or `limit` paginates the returned `items` list)
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_path": "<file_path>"
},
"name": "inspect_and_audit_boq_xlsx"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of BoQ line items to return in `items` (protects LLM context window on 1000+ row BoQs). | |
| offset | No | Pagination offset for returned BoQ line items. | |
| file_path | Yes | Path to the .xlsx or .xlsm Bill of Quantities workbook. | |
| sheet_names | No | Optional list of specific visible worksheet names to inspect. | |
| keyword_filter | No | Optional case-insensitive regex/keyword filter on item description, item number, or code to reduce returned rows. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| items | No | ||
| file_path | Yes | ||
| sheet_summaries | No | ||
| formula_anomalies | No | ||
| has_shared_formulas | No | ||
| returned_items_count | No | ||
| total_matching_items | No | ||
| skipped_hidden_sheets | No | Sheets with state 'hidden' or 'veryHidden' that were strictly excluded. | |
| total_items_extracted | No | ||
| visible_sheets_processed | Yes |