Beta — Data under validation. Values may contain errors.

ED.UNIT

Generation per Spanish production unit (MW) — single value.

Generation

Signature

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

Description

Actual generation (MW) 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).

Granularity is hourly. For the full Spanish UP registry (8000+ entries including small renewables and retailers, but without MW data) see ED.UP.SEARCH.

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.

* Required.

Returns

Number — generation in MW.

Examples

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

Related functions