Skip to main content
Glama

Reconcile a total

reconcile_totals
Read-onlyIdempotent

Sum a selected numeric column and compare it against an expected total within a tolerance to verify CSV/XLSX data; cached formula results are labeled and counted, not recalculated.

Instructions

Sum one selected numeric column and compare it with a supplied control total and tolerance. Formulas are not calculated; usable cached results are labeled and counted.

Input Schema

NameRequiredDescriptionDefault
columnYesExact normalized column name from inspect_workbook.
file_pathYesCSV/XLSX path relative to KINGWORKBOOK_ROOT.
toleranceNoAllowed absolute difference as a decimal string; defaults to zero.0
sheet_nameNoOptional sheet name in an XLSX workbook.
expected_totalYesExpected total as a decimal string, for example 1250.00.

Output Schema

NameRequiredDescriptionDefault
notesYes
columnYes
statusYes
data_rowsYes
file_pathYes
toleranceYes
differenceYes
sheet_nameYes
computed_totalYes
expected_totalYes
within_toleranceYes
blank_values_skippedYes
numeric_values_includedYes
nonnumeric_values_skippedYes
formulas_without_cached_valuesYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A3.8/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnly, idempotent, non-destructive; the description adds substantive behavior beyond them: formulas are not evaluated, and only usable cached results are labeled and counted. That caveat materially affects how an agent interprets a mismatch, which is exactly the value beyond structured fields.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two tight sentences: the core operation first, the caveat second. No filler and nothing important buried.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

An output schema exists, so return-value explanation is not needed, and annotations cover safety. The description supplies the key caveat about cached vs. formula values; only minor items (e.g., behavior when the column is missing or non-numeric) are left implicit.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100% and every parameter is documented in the schema, including the tolerance default and decimal-string format. The description only echoes the concepts of control total and tolerance without adding format or edge-case guidance, so baseline 3 applies.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb chain and resource: sum a selected column and compare against a supplied control total within a tolerance. An agent can distinguish this from compare_workbooks or check_formula_integrity, though it doesn't explicitly name those siblings.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies the use case (verifying a column total against an expected value) but gives no explicit when-to-use/when-not guidance or routing versus the sibling integrity/compare tools. The 'formulas are not calculated' clause hints at a limitation rather than selecting among alternatives.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.