Excel Client

The Excel client lets you run Equation calculations directly from your spreadsheet. It is ideal for engineers who prefer working in Excel but want to benefit from centralized, standardized, and version-controlled calculation logic exposed through the platform.

✅ When to Use the Excel Client

Use the Excel client if you:

• Prefer Excel over web or code-based tools
• Want to run one or more calculation APIs with familiar tabular inputs
• Need to quickly test or compare different input scenarios

🚀 How It Works

The Excel client interacts with Equation APIs under the hood. It:

• Sends your spreadsheet input as a request to the API
• Retrieves and displays results directly in Excel
• Uses your Haskoning login (Azure Entra ID) for authentication

🔧 Setup Instructions

Equation Excel Add-in

• Available through request in WeConnect (Link to software), will be automatically deployed to your machine
• Automatically connects to the Equation API Management gateway

🧪 Running a Calculation

1. Open the plugin
2. Select which APIs you would like to load as custom Excel Functions
3. Use the native Excel Functions in your Excel spreadsheet to get results

🛠️ Troubleshooting

Issue	Suggested Action
Results don’t appear	Check input validity and retry
Auth error / login prompt	Make sure you're signed into Haskoning SSO
API timeout	Try again later or reduce input size
API gives unexpected results	Contact the API owner responsible for this calculation

For advanced integration, or if you need more flexibility (e.g. loops, logic, scripting), consider using the Equation Python Package.