ACE Technology
Ace Technology is a trade marked acronym for the online Analytical Calculation Engine (ACE) which runs in the background to calculate CleveQ performance indicators.
Below is a summary list of the special functions which ACE can perform. Standard math functions to build formulas are in addition to the list below.
Special functions can be applied to any parameter within a formula and can be used with other parameters from multiple sources. Formulas can include multiple parameters in combination with the funtions below. Formulas can be based on mapped parameters or other parameter formulas.
- Sum of values in the date range
- Average value of data in a date range
- Minimum value found in a date range
- Maximum value found in a date range
- Standard deviation of values found in a date range
- Variance of values found in a date range
- Count of Values in a date range
- First Value found in a date range
- Last Value found in a date range
- Change of value from a previous date range
- Moving average of a specified range of data within a date range
- Normalized value or Seasonally adjusted annual rate(SAAR)
- Seasonal Trend value data in a date range
- Forecast monthly data using best fit synopsis with or without adjusting for seasonal trends
- Linear forcast of monthly data with or without adjusting for seasonal trends
- Power curve forecast of monthly data with or without adjusting for seasonal trends
- Exponential forecast of monthly data with or without adjusting for seasonal trends
- Logarithmic forecast of montly data with or without adjusting for seasonal trends
- Previous date range value
- Previous Year value
- Previous date range value based on duration