Beta — Data under validation. Values may contain errors.

ED.UNIT

Generation per Spanish production unit — average power (MW) or total energy (MWh).

Generation

Signature

ED.UNIT(up, [date], [hour], [unit])

Description

Actual generation for a single production unit (Unidad de Programación) reporting under ENTSO-E A73. ~300 plants in Spain, mostly conventional + large renewables. Use ED.UPS() to discover available unit codes (e.g. ALZ1 = Almaraz I).

Native cadence is 15-min. For the full Spanish UP registry (8000+ entries including small renewables and retailers, but without MW data) see ED.UP.SEARCH.

**Unit (unit parameter):** by default returns the AVERAGE power in MW over the requested window (hour or day). Pass unit="MWh" to get the total energy delivered instead. Per-day MWh is computed by collapsing the native 15-min samples to a per-hour AVG and SUM-ing across the day; per-hour MWh is the AVG-MW × 1h (mathematically identical when the bucket is exactly one hour). Conversion is exact down to the 15-min sample.

Parameters

NameTypeDefaultDescription
up*stringENTSO-E unit code (e.g. "ALZ1", "VAN2", "BES5"). Case-insensitive.
datedateDate. Omit for the latest hour.
hour0-23Hour of day. Omit for the daily average / daily MWh total.
unit"MW" | "MWh""MW"Output unit. "MW" returns the average power (default, historical behaviour). "MWh" returns total energy delivered in the requested hour or day. Always available for unit_generation — no already-MWh edge case.

* Required.

Returns

Number — generation in MW or MWh depending on unit.

Examples

=ED.UNIT("ALZ1")Latest hour for Almaraz I (MW)
=ED.UNIT("ALZ1", "2025-07-01", 14)Almaraz I at hour 14 (MW)
=ED.UNIT("VAN2", "2025-07-01")Vandellós II daily average power (MW)
=ED.UNIT("VAN2", "2025-07-01", , "MWh")Vandellós II daily energy delivered (MWh)

Related functions