eco2lot smartcalc · Calculate complex relationships freely

Formula

Consumption times price, total minus PV, gas in kWh, weather-adjusted heat consumption, expected value by regression: everything that sits in an Excel formula today, the formula calculates right in eco2lot — continuously and with time series that have to fit together in time.

What is the formula in eco2lot?

The formula is the freely configurable calculation logic in smartcalc. It links any existing values in eco2lot — data points, feed, volume and sum counters, KPIs and other calculated values — and goes far beyond basic arithmetic: complex mathematical relationships, conditions, dependencies, conversions and multi-stage calculations — up to consumption normalization (consumption adjusted for weather or production volume) and regression (an expected value from influencing variables against which the actual value is compared). A special feature: the formula processes time series with different grids together, such as 15-minute, hourly and daily values. eco2lot brings the data together in a time-consistent way. The result is a data point, counter or KPI again.

How it works

The calculation scheme

Calculation scheme formula Several data points with different time grids, linked with logic, conditions and conversions, yield a new data point, for example energy costs in euros. Any values Data point A · every 15 minCounter B · hourlyKPI C · daily + Logic Arithmetic, conditionsConversions, stages = New data point e.g. energy costs €
Several values with different time grids, linked with arithmetic, conditions and conversions: the result is a new data point — here the energy costs in euros.
In detail

What is inside the formula

What the formula is

  • The freely configurable calculation logic in smartcalc
  • Far more than a calculator: conditions, dependencies, conversions, several stages
  • Virtual measuring points: new measured quantities by formula instead of new hardware
  • Analytical models: consumption normalization and regression right in eco2lot

Your benefitWhere standard calculations reach their limit, the formula begins.

Which data it uses

  • Data points, feed, volume and sum counters
  • KPIs and other formula results
  • Constants such as prices, factors, limits
  • Time series with different grids — 15 minutes, hourly, daily

Your benefitEverything eco2lot knows can go into the formula.

What eco2lot calculates

  • Consumption × energy price = energy costs
  • Grid purchase = total consumption − PV generation
  • Gas volume in m³ → energy in kWh (calorific value, volume correction factor)
  • Conditional values: "if status = production, then consumption, else 0"
  • Consumption normalization: heat consumption per degree day, electricity per produced tonne — periods become comparable despite weather and utilization
  • Regression: expected value from influencing variables such as outdoor temperature and production volume; the deviation from the actual value shows savings or excess consumption
  • Calculation cycle: as often as the raw data is recorded — every second, every minute or every 15 minutes

Your benefitTime series with different timestamps are brought together in a time-consistent way — and the result is available in the resolution of the raw data.

What benefit arises

  • Calculations with no external data export
  • New measured quantities with no additional meters
  • Cost allocation and conversions continuously instead of monthly
  • Result as a data point for dashboards, alarms, KPIs

Your benefitCalculations build on each other — the formula is the link.

One level deeper

Typical formulas

Examples — from the simple conversion via conditions to normalization and regression.

Energy costs

Consumption (feed counter, 15-minute values) × energy price (data point, hourly or daily) = energy costs per period. Two grids, one result.

Grid purchase as a virtual measuring point

Total consumption − PV generation = grid purchase. A new data point with history, alarms and dashboard tile — with no further meter installed.

Gas in kWh

Gas volume in m³ × calorific value × volume correction factor = energy in kWh. The conversion runs along continuously; gas and electricity become comparable.

Conditional consumption

"If outdoor temperature below 5 °C, then heat consumption, else 0" — the heating consumption on cold days as a value of its own, measured against the weather time series.

Consumption normalization

Heat consumption ÷ degree days (the sum of the temperature differences between indoor and outdoor temperature) = weather-adjusted consumption. This way a mild January becomes comparable with a cold one — and a production month at half utilization with a full one.

Regression

From outdoor temperature and production volume the formula calculates the expected consumption (expected value, baseline). Actual value minus expected value shows whether a measure works or a consumer runs out of line — the basis for energy performance indicators with baseline according to ISO 50001.

Your outcome

Afterwards you can …

  • You calculate costs, conversions, conditions, consumption normalizations and regressions right in eco2lot, with no export to Excel.

  • You process time series with different grids in one formula — eco2lot brings them together in time.

  • Every formula result is a data point that is reused, monitored and reported.

Frequently asked questions

What you should know about the formula

Can smartcalc process complex formulas?

Yes. The formula goes far beyond basic arithmetic: mathematical relationships, conditions, dependencies, conversions and multi-stage calculations. Inputs are data points, counters, KPIs, constants and other formula results.

What happens when time series have different timestamps?

The formula processes time series with different grids together — 15-minute, hourly and daily values, for example. eco2lot brings the data together in a time-consistent way for the calculation, even when timestamps or intervals differ from each other.

What is a virtual measuring point?

A measured quantity calculated by formula that behaves like a real data point: with history, alarms and dashboard tile. Example: grid purchase = total consumption − PV generation — with no additional meter.

Can the result of a formula be reused?

Yes. The result is a data point, counter or KPI of its own and is available to dashboards, alarms, reports and further formulas. This way calculations build on each other.

How often does the formula calculate?

As often as the raw data is recorded. If a data point delivers second values, the formula calculates every second; with minute values every minute. A 15-minute cycle is the market standard — eco2lot goes down to the resolution of the source.

Can the formula normalize consumption?

Yes. A consumption normalization converts the consumption to a reference quantity — heat per degree day for the weather, electricity per tonne for utilization. This way months, sites and years become comparable although weather and production were different. The result is a data point of its own with alarm and dashboard.

Can the formula calculate a regression?

Yes. From influencing variables such as outdoor temperature, production volume or operating hours the formula determines the expected consumption. The comparison of actual value against expected value shows savings after a measure as well as creeping excess consumption — and delivers the baseline for energy performance indicators according to ISO 50001.

Do I need programming skills?

Formulas are configured in eco2lot, with data points as building blocks and arithmetic and logic operators. Whoever writes Excel formulas finds their way around; with complex relationships we support you during setup.

Can I place an alarm on the formula result?

Yes. The result is a data point; an alarm reports when the energy costs of the day exceed a budget, the virtual grid purchase turns negative or a conditional value leaves the limit range — as often as the formula calculates.

Is the formula the right fit for your task?

Describe your starting point and your goal — we get back to you with a concrete recommendation of matching features and solutions, plus a price indication.

Configure your solution