> For the complete documentation index, see [llms.txt](https://docs.coherent.global/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coherent.global/the-spark-assistant/build-mode.md).
# Build Mode
Build mode helps users manage named ranges for Spark. Since named ranges are supposed to follow a specific syntax, Build mode facilitates the mapping of inputs and outputs while minimizing mistakes and confusion.
## Build named ranges
To create named ranges that can identify parameters such as inputs and outputs for Spark:
1. Log into Spark Assistant and select Build Mode. Click **Build Name Ranges** on the next screen.
2. In *Parameter type*, select if the parameter is an input or an output.
3. In *Cell location*, select a range of inputs that will allow the Assistant to understand the scope of the new mapping better.
4. In *Search for a subject*, either choose from the suggestion list, or enter your own value.
5. In *Search for a name*, either choose from the suggestion list, or enter your own value.
6. (Optional), enter a description of the named range and what information it contains.
Enter the details of the name range and click Confirm
## Find all named ranges
Once input and output parameters have been mapped out with their names using the name creation wizard on the Spark Assistant, users can also find them all in one place
1. Log into Spark Assistant and choose **Build mode.**
2. Click on **Find all named ranges.**
3. Select a specific range to highlight the cell(s) in the open spreadsheet.
## Calculation blocks
Excelmodels may sometimes use [Solve functions (Xsolve)](/build-spark-services/other-mapping-options/solve-functions.md), which emulate the Excel Goal Seek functionality in Spark. These would normally require an API call to execute. Using the Assistant, users can identify these solve blocks and also run them to see any changes to their output in the open Excel file.
1. Log into Spark Assistant and choose **Build Mode.**
2. Click on Calculation Blocks and choose **Solver.**
3. Select the solver you would like to see function and click on **Confirm.**
## **Recalculate SPARK\_XCALL function**
This option will recalculate all formulas that use C.SPARK\_XCALL functions in the current Excel workbook simultaneously.
Spark Assistant will refresh all Xcall functions in an Excel file automatically every time you log in, but this manual method is helpful for when you've been away from the file for a long time or if you've uploaded a new version of the service you're calling from your Excel file.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.coherent.global/the-spark-assistant/build-mode.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.