Skip to main content
Glama
WilliamSmithEdward

xlide-excel-word-powerpoint-access-office-vba-mcp

Evaluate a formula

xlide_evaluate_formula
Read-onlyIdempotent

Evaluate an Excel formula in a live workbook to preview its result without altering the file. Check formulas before writing or query data with Excel functions like SUMIFS.

Instructions

Works out what a formula would give in a cell of a workbook, without writing it there: to check a formula before xlide_write_cells, or to ask the workbook a question, such as =SUMIFS(Sales[Amount],Sales[Region],"West"). Uses pyOfficeEditor's formula engine, 493 of Excel's functions, with the workbook's cells as they stand. A formula written for one cell answers with one value, as Excel would give it there. Changes nothing. .xlsx, .xlsm and .xlam.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
atNoThe cell it is imagined in, which relative references count from.A1
sheetYesWorksheet the formula is evaluated on.
formulaYesThe formula, with or without its '='.
file_pathYesAbsolute path to the Excel file.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv1.1.0

TDQS

A4.4/5.0
Behavior4/5

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

Annotations already declare readOnlyHint, idempotentHint, and destructiveHint. The description adds useful context: 'Changes nothing', 'Uses pyOfficeEditor's formula engine, 493 of Excel's functions', and 'with the workbook's cells as they stand'. It also clarifies that the result matches what Excel would give. This adds value beyond the annotations without contradicting them.

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?

The description is compact and well-structured. It opens with the primary purpose, includes a concrete example, and covers key details (engine, non-destructive, supported file types) without redundancy. Every sentence adds value, and it is not overly long.

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?

Given the output schema exists (not shown but indicated), the description need not detail return values. It covers the tool's purpose, use cases, non-destructive nature, supported formats, and function count. This is sufficient for an agent to decide to invoke it, though it could mention any error handling or edge cases.

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 description coverage is 100%, so the schema already documents all four parameters. The description does not add significant new meaning beyond the schema, though it does hint at the 'at' parameter's role in relative references. Since the schema carries the load, a baseline score of 3 is appropriate.

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

Purpose5/5

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

The description clearly states the tool's purpose: it evaluates a formula in a cell context without writing it, distinguishing it from write operations. It gives a concrete example (SUMIFS) and names the specific action ('works out what a formula would give'). It differentiates from siblings by mentioning 'without writing it there' and references xlide_write_cells.

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

Usage Guidelines5/5

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

The description explicitly states when to use the tool: 'to check a formula before xlide_write_cells, or to ask the workbook a question'. It also implies the tool is non-destructive and works on the current state of the workbook. This provides clear context for an agent to decide when to invoke it versus alternatives.

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