How-to guides

These how-to guides will walk you through how to solve specific tasks.

The guides will only assume that you have the knowledge from the getting started guide, any additional information will be linked from the specific how-to guide.

Topics

📄️ Choose which result is returned

Some ArupCompute functions return multiple results. By default the first result will be written to the cell, but you can choose which you would like to return instead.

📄️ Chain calculations 🔗

As with built-in excel functions, the results from ArupCompute calls can be chained together.

📄️ Plot a graph 📈

Plotting a graph using results from ArupCompute is 'as easy as pie(chart)' 🥧. Simply create the chart from the result cells as you would normally in Excel.

📄️ Choose where errors, warnings and remarks appear ⚠️⛔

ArupCompute libraries return three levels of messaging - errors, warnings and remarks (EWRs):

📄️ Calling Optional Inputs

To see if an input is optional, you can check to see if it's name has "(Optional)" at the end of it. When filling in the input you will be able to see the default value of the input:

📄️ Print a report 🖨️

Many of the libraries on ArupCompute produce report output. This can be accessed and printed using the ArupCompute Excel client.

📄️ Only print when required 🖨️

As detailed in the report printing guide minimising the amount of report printing is important to maintain performance.

📄️ Combine reports ➕

Building on the example seen in Chaining calculations, we will now combine reports from different calculations.

📄️ Enable a specific library version

By default the latest stable version of all ArupCompute libraries are used.

📄️ Work with JSON 🗄️

Refer to the TODO: add back in json link JSON page in the Explanation section of the documentation to understand what JSON is and why/when it needs to be used with ArupCompute.

📄️ Find an optimal solution ⚙️

Example Problem

📄️ Calculation templates 📄

Calculation templates make it easy to insert a calculation and link the corresponding inputs and outputs to cells. You can find templates under the Arup ribbon Insert Template option.

📄️ Veracity Database 🌍

Introduction