Function Reference

Complete reference for all 35+ EngiVault Excel functions

All Functions

6 functions

ENGIVAULT_PRESSURE_DROP

Calculate pressure drop using Darcy-Weisbach equation

Hydraulics

Syntax

ENGIVAULT_PRESSURE_DROP(flowRate, pipeDiameter, pipeLength, fluidDensity, fluidViscosity, [pipeRoughness])

Parameters

Double

flowRate

Flow rate in m³/s

Double

pipeDiameter

Pipe diameter in meters

Double

pipeLength

Pipe length in meters

Double

fluidDensity

Fluid density in kg/m³

Double

fluidViscosity

Fluid viscosity in Pa·s

Double

pipeRoughness

Pipe roughness in meters (optional, default: 0.00015)

Returns

Pressure drop in Pa

Example

=ENGIVAULT_PRESSURE_DROP(0.1,0.1,100,1000,0.001)

Result: 762,517 Pa

ENGIVAULT_PUMP_POWER

Calculate pump hydraulic power

Pumps

Syntax

ENGIVAULT_PUMP_POWER(flowRate, head, efficiency, power)

Parameters

Double

flowRate

Flow rate in m³/s

Double

head

Pump head in meters

Double

efficiency

Pump efficiency (0-1)

Double

power

Pump power in watts

Returns

Hydraulic power in kW

Example

=ENGIVAULT_PUMP_POWER(0.05,50,0.8,5000)

Result: 0.025 kW

WATER_DENSITY

Get water density at given temperature

Properties

Syntax

WATER_DENSITY(temperature)

Parameters

Double

temperature

Temperature in Celsius (0-100°C)

Returns

Density in kg/m³

Example

=WATER_DENSITY(20)

Result: 998.2 kg/m³

CONVERT_FLOW_RATE

Convert flow rate between different units

Conversions

Syntax

CONVERT_FLOW_RATE(value, fromUnit, toUnit)

Parameters

Double

value

Flow rate value

String

fromUnit

Source unit (m3/s, m3/h, l/s, l/min, gpm, cfm)

String

toUnit

Target unit (m3/s, m3/h, l/s, l/min, gpm, cfm)

Returns

Converted flow rate

Example

=CONVERT_FLOW_RATE(100,"gpm","m3/s")

Result: 0.006309 m³/s

PIPE_SIZE_RECOMMENDATION

Recommend minimum pipe diameter based on flow rate and maximum velocity

Utilities

Syntax

PIPE_SIZE_RECOMMENDATION(flowRate, maxVelocity, [unit])

Parameters

Double

flowRate

Flow rate in m³/s

Double

maxVelocity

Maximum allowable velocity in m/s

String

unit

Output unit (m, mm, in) - default: m

Returns

Minimum pipe diameter

Example

=PIPE_SIZE_RECOMMENDATION(0.1,3.0,"mm")

Result: 205.7 mm

ENGIVAULT_VERSION

Get EngiVault Excel integration version

System

Syntax

ENGIVAULT_VERSION()

Returns

Version string

Example

=ENGIVAULT_VERSION()

Result: 1.0.0

Error Codes

Code	Description	Solution
#VALUE!	Invalid input parameters	Check parameter types and ranges
#NAME?	Function not recognized	Import VBA modules and enable macros
#N/A	API connection failed	Check authentication and internet connection
1001	Authentication required	Set API key or JWT token

Best Practices

Performance Optimization

• Minimize API calls - Cache results when possible
• Use manual calculation for large datasets
• Batch similar calculations together
• Avoid array formulas with API functions

Error Handling

• Use IFERROR() to handle API failures gracefully
• Validate inputs before calling functions
• Check API status periodically
• Monitor rate limits for heavy usage

Code

Description

Solution

#VALUE!

Invalid input parameters

Check parameter types and ranges

#NAME?

Function not recognized

Import VBA modules and enable macros

#N/A

API connection failed

Check authentication and internet connection

1001

Authentication required

Set API key or JWT token