ecpEnergyTwinCommonTools

Returns degree days using XQuery.

Returns degree days base using XQuery.

Returns history grid using XQuery.

Checks if id of record is in local project.

Returns occupied point using XQuery.

Returns record using XQuery.

Returns weather point using XQuery.

Returns new XQuery.

Executes XQuery with tracing options.

Calculates derivation. Input should be cumulative data.

For example:

10kWh
19kWh
31kWh
38kWh

Calculation:

(row.kWh - lastRow.kWh) / (row.ts - lastRow.ts)

Checks if file exists.

Folds to true if any of value is true.

Fold to count days.

Fold to calculate difference between last and first.

Fold to integrate.

Fold to most occuring value.

Joins grid axis, used when different units need to have same y axis.

Converts column meta to presentation on grid.

Finds rows that have valid values (ettValueIsValid) in columns.

Examples:

ettGridFindValidRows(grid)                 // checks all columns in all rows
ettGridFindValidRows(grid, "v0")           // checks v0 in all rows
ettGridFindValidRows(grid, ["v0", "v2"])   // checks v0 and v2 in all rows

Adds hisStart and hisEnd to grid based on span or on data in grid.

Calculates integral.

Relative difference of measurement and prediction.

Rounds number to specified decimal place.

Unit conversion dictionary.

Converts unit from derivative to integral.

Converts unit from integral to derivative.

Check if value is valid (not null, not NA, not NaN).

Examples:

ettValueIsValid(true)    >>   true
ettValueIsValid(123)     >>   true
ettValueIsValid(null)    >>   false
ettValueIsValid(na())    >>   false
ettValueIsValid(nan())   >>   false