search
About CoherentAPI referenceSupportYouTube

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.

hashtag
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

hashtag
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.

hashtag
Calculation blocks

Excelmodels may sometimes use Solve functions (Xsolve), 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.

hashtag
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.

Last updated