Overview

Coherent Assistant is an Excel add-in designed to integrate the capabilities of Spark directly into Excel. It enables users to connect to their Spark instance, upload and download Spark services as Excel files, and create testbeds within Excel. Additionally, users can establish live connections to external APIs and Spark services directly from Excel, among many other features.

The add-in can be installed from Microsoft AppSource Marketplace or with a manifest file. Follow the steps in Installation to have the add-in appear in Excel.

Applications

Coherent Assistant offers a suite of applications designed to enhance your daily workflow. Below, you will find a list of these applications accompanied by brief descriptions of their functionalities. We are committed to continuously expanding this suite with new applications and enhancing the features of existing ones.

Connect

Establish a direct connection to Spark to unlock features that seamlessly integrate with Spark.

Mapper

Mapping the inputs and outputs of your model is now easier than ever.

Services

Browse, create, and update Spark services directly from Excel.

Solver

Performs a What-if analysis similar to Goal Seek with each API call.

Shell

Obfuscate the logic of your Excel models to simplify collaboration.