ED.UPS
List ENTSO-E production units (~300) with code, name, tech, owner.
Signature
ED.UPS([tech])Description
List the ~300 Spanish production units that report individual MW under ENTSO-E A73. Each row is one unit, with its code, name, technology, average MW, and the company that owns or represents it.
This is the small set with 15-min per-unit MW data — use the codes returned here as input to ED.UNIT and ED.UNIT.RANGE. For the full Spanish market participant directory (8000+ entries: small renewables, retailers, consumers) use ED.UP.SEARCH.
**"Avg MW" is a long-run duration-weighted mean over the unit’s whole history.** ENTSO-E A73 is run-length encoded (curveType A03): a missing 15-min position repeats the previous value rather than meaning zero, so each published point is weighted by how long it was in force instead of counted as one equal sample. Reading it the naive way inflates the figure by up to +777 % on a CCGT — if this column looks different from a number you saved earlier, that is why.
Because the average spans everything held for the unit, it mixes periods of uneven data quality (see ED.UNIT.RANGE for the detail). Use it to rank and locate units, not as a capacity-factor input; for that, query a specific window with ED.UNIT.RANGE and check the coverage_pct the REST endpoint returns. /api/data/units also returns a coverage_pct per unit — the share of the unit’s publishing span (first observation to last) that is actually backed by data — which the Excel spill does not include.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| tech | string | — | Filter by ENTSO-E technology label: "nuclear", "solar", "fossil_gas", "wind_onshore", "hydro_reservoir", etc. Omit for all. |
Returns
Spill array with header row: Code, Name, Tech, Avg MW, Company, Zone. Rows are ordered by Avg MW descending.
Examples
=ED.UPS()— All 300+ units=ED.UPS("nuclear")— Nuclear units only=ED.UPS("wind_onshore")— Onshore wind unitsNotes
- An unknown
techreturns an error listing the accepted values rather than an empty list — the vocabulary here is ENTSO-E's (solar,fossil_gas,wind_onshore…), not the oneED.GENuses. - "Avg MW" is duration-weighted (ENTSO-E A73 is run-length encoded), so the ranking differs from a plain average of the published points — see the description.
- A plant that publishes one EIC per turbine has those turbines added together, so "Avg MW" is the plant’s output and not one turbine’s. EICs that replace one another over time are stitched into a single timeline instead.