> 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/tutorial-get-started-in-5-minutes.md).

# Tutorial: Get started in 5 minutes

Convert Excel calculations into a Spark service with an integration-ready API!

This tutorial uses a simple calculation but the process is the same for even the most complex workbooks!

## Map inputs and outputs

<figure><img src="https://2714190325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc7fek1ZgAUH5MA3m5pH8%2Fuploads%2FNvh59W1WQlUEBpv9yQ2Z%2Fimage.png?alt=media&amp;token=af99781e-9efb-45a6-b939-94ca88493983" alt="Right circular cone volume is V = π * r^2 * h/3."><figcaption></figcaption></figure>

Spark uses Excel [names](https://support.microsoft.com/en-US/Excel/get-started/define-and-use-names-in-formulas) to identify calculation inputs and outputs.

1. Open Excel and create the cone-volume calculation:
   * Enter the radius in `C3`.
   * Enter the height in `C4`.
   * Enter `=ROUND(PI()*C3^2*C4/3,3)` in `C5`.
2. Use the **Name Box** to name `C3` as `Xinput_r`.

   <figure><img src="https://2714190325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc7fek1ZgAUH5MA3m5pH8%2Fuploads%2FrbJMJsvS0FMjnMiC0C8i%2Fimage.png?alt=media&amp;token=2f993e58-63ee-4d8c-8f12-678fdd00b7a5" alt="Enter Xinput_r in the Name Box."><figcaption></figcaption></figure>
3. Use the **Name Box** to name `C4` as `Xinput_h`.
4. Use the **Name Box** to name `C5` as `Xoutput_V`. Spark recognizes `Xinput_` names as inputs and `Xoutput_` names as outputs.

   <figure><img src="https://2714190325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc7fek1ZgAUH5MA3m5pH8%2Fuploads%2FltzDHqM02gwTZ48lMIDs%2Fimage.png?alt=media&amp;token=4f9dcf78-ed4e-4713-b209-7ee1be1e4e2c" alt="Enter =ROUND(PI()*C3^2*C4/3,3) into C5. Enter Xoutput_V in the Name Box."><figcaption></figcaption></figure>
5. It is useful to note that input and output tables are mapped in the same way. A range of cells that include a header row can be selected and also be denoted as `Xinput` or `Xoutput`, for example `Xinput_dimensions`, or `Xoutput_volumes`.
6. On the **Formulas** tab, select **Name Manager**. Confirm it lists `Xinput_r`, `Xinput_h`, and `Xoutput_V`.

   <figure><img src="https://2714190325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc7fek1ZgAUH5MA3m5pH8%2Fuploads%2FSQycR7Ko01Tt8IktPCuO%2Fimage.png?alt=media&amp;token=db92e2d7-5c53-48ba-a4a5-18a4b6f0e4ae" alt="Name Manager is in the Formula tab of the ribbon."><figcaption></figcaption></figure>

   <figure><img src="https://2714190325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc7fek1ZgAUH5MA3m5pH8%2Fuploads%2FFkOKd1avrFxPvxe8J0eC%2Fimage.png?alt=media&amp;token=c42d4b88-32fa-4fea-bae3-a1dcb846985b" alt="Name Manager lists Xinput_h, Xinput_r, Xoutput_V."><figcaption></figcaption></figure>
7. Save the workbook. Alternatively, download the sample workbook.

{% file src="/files/t92cEY02PdWvbKYL5erm" %}

## Sign in to Spark

1. Open your tenant URL. Tenant URLs use the format `http://spark.{environment}.coherent.global/{tenant}`.
2. Sign in with your credentials.
   1. If you are not using single sign-on, enter your **Email** and **Password** and select **Sign in**.
   2. If you use single sign-on, select the appropriate sign-in option.
3. Spark opens the [Home](/navigation/home.md) screen.

## Create a folder

Spark calls a converted Excel workbook a service. Folders organize services.

1. Select **New folder**.
2. Enter a unique folder **Name**.
3. Select a **Folder category**. Folder categories can be filtered on the **Home** screen.
4. Optionally, upload a cover image.
5. Select **Create**.
6. Spark opens the [Folder overview](/navigation/folder-overview.md).

## Publish a service

A service is published when Spark converts an Excel workbook into code and an API.

1. Select **New service** at the top right.
2. Select **Browse** or drag the workbook into the upload area. Spark supports `.xlsx` and `.xlsm` files.

   <figure><img src="https://2714190325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc7fek1ZgAUH5MA3m5pH8%2Fuploads%2FbGHPajoE86NHvu4kaeLE%2Fimage.png?alt=media&amp;token=edba07ba-543c-47d8-a17c-e95f41d72e91" alt="New service upload accepts Excel files for conversion."><figcaption></figcaption></figure>
3. While Spark converts the workbook, optionally change the **Service name**. The default name is the workbook filename.

   <figure><img src="https://2714190325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc7fek1ZgAUH5MA3m5pH8%2Fuploads%2F0snk4P3MVdfQcCNVtUsJ%2Fimage.png?alt=media&amp;token=9716c158-4541-4f38-9e55-dbb7cb17dfd9" alt="Excel file converting to code."><figcaption></figcaption></figure>
4. When conversion finishes, select **Publish**.

   <figure><img src="https://2714190325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc7fek1ZgAUH5MA3m5pH8%2Fuploads%2FM3f9WpOfLY770xANwz2A%2Fimage.png?alt=media&amp;token=2692601b-62da-4ef2-a02a-301a02288626" alt="Excel file successfully converted and ready to be published."><figcaption></figcaption></figure>
5. Spark opens [API Tester](/navigation/api-tester.md). Your API is ready to test and integrate.

## Call the API

Use the **API Tester** to test the converted calculation and its [Execute API (v3)](/spark-apis/spark-openapi-specification/execute-api-v3.md). The `/execute` endpoint processes calculation requests.

1. In **API request (inputs)**, confirm `r` and `h` appear as inputs.
2. Enter values for the radius and height.
3. Select **Submit**.
4. In **API response (outputs)**, expand **Single values** to view the calculated `Volume`.
5. Use **JSON view** or **Raw view** to inspect the API response.

## Next steps

* Business users: Get a more detailed look through the Excel-to-API process: [How to: Prepare an Excel file for Spark](/build-spark-services/how-to-prepare-an-excel-file-for-spark.md), [Tutorial: Map inputs and outputs](/build-spark-services/tutorial-map-inputs-and-outputs.md), [How to: Create a Spark service](/build-spark-services/how-to-create-a-spark-service.md).
* Administrators: [How to: Set up a Spark tenant](/tenant-administration/how-to-set-up-a-spark-tenant.md).
* Developers: [API Tester](/navigation/api-tester.md), [Execute API (v3)](/spark-apis/spark-openapi-specification/execute-api-v3.md).