apply_boq_modifications_and_pricing
Writes unit prices, red-bold quantity changes, supplemental K-tétel items, and '-'/'+' variation pairs into an Excel BoQ, updating SUM ranges, cached XML values, and removing calcChain.
Instructions
[v0.3 Tool 11] Safely write unit prices (with optional markup_factor), red-bold quantity modifications,
supplemental K-tételek, and '-'/'+' kiv. észrevétel pairs into an Excel BoQ workbook while updating
SUM ranges, XML `<v>` cached values, and stripping `xl/calcChain.xml`.
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": {
"source_xlsx_path": "<source_xlsx_path>",
"output_xlsx_path": "<output_xlsx_path>"
},
"name": "apply_boq_modifications_and_pricing"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| round_step | No | Rounding step for unit prices after markup (default 0.01 for EUR/USD/GBP; pass 10.0 for HUF). | |
| row_pricings | No | List of unit prices and optional quantity/note modifications for existing rows. | |
| markup_factor | No | Global multiplier applied to unit prices (e.g., 1.0 for base, 1.20 for +20% markup). | |
| output_xlsx_path | Yes | Absolute path where the modified and priced BoQ Excel file will be written. | |
| source_xlsx_path | Yes | Absolute path to the source BoQ Excel file (.xlsx). | |
| supplemental_items | No | List of new K-tétel items or '-'/'+' kiv. észrevétel observation pairs to insert. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| warnings | No | ||
| grand_total_net | Yes | ||
| output_xlsx_path | Yes | ||
| sheet_net_totals | No | ||
| source_xlsx_path | Yes | ||
| priced_rows_count | Yes | ||
| calc_chain_removed | Yes | ||
| markup_factor_applied | Yes | ||
| inserted_k_items_count | Yes | ||
| post_write_formula_anomalies | Yes | ||
| quantity_modified_rows_count | Yes | ||
| cached_formula_values_updated | Yes | ||
| inserted_observation_pairs_count | Yes |