ED.GRIDACCESS
REE grid-access capacity (GW) — monthly historical, since Aug 2019.
Signature
ED.GRIDACCESS([scope], [region], [tech], [status], [start], [end])Description
Monthly snapshots of grid-access capacity from REE's "Información de gestión de acceso" PDFs, published on the 30th-31st of each month since August 2019.
Covers wind + solar PV + hybridization (since 2023) × four application states (in service / permitted / under review / rejected) × national + 17 regional rows. Capacity is in GW. For a richer technology breakdown (8 techs, transmission/distribution split) but no historical depth, use ED.GRIDACCESS.PORTAL.
The REE source uses Spanish identifiers — nacional, eolica, en_servicio, etc. The add-in accepts both the Spanish canonical form (what the database stores and what the result rows return) and English aliases like national, wind, in_service. Both are equivalent; pick whichever fits your spreadsheet style.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| scope | "national" / "nacional" | "regional" / "ccaa" | — | Whether to return the national aggregate, per-region rows, or both. Omit for both. |
| region | string | — | Spanish autonomous community name (e.g. "Andalucía"). Leave empty for the national rows. |
| tech | string | — | Technology — see table below. |
| status | string | — | Application status — see table below. |
| start | date | — | Start date YYYY-MM-DD. |
| end | date | — | End date YYYY-MM-DD. |
Valid values for scope
| Code | English alias | Description |
|---|---|---|
| nacional | national | National aggregate row(s). |
| ccaa | regional | One row per autonomous community. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Valid values for tech
| Code | English alias | Description |
|---|---|---|
| eolica | wind | Onshore wind. |
| solar_fv | solar_pv | Solar photovoltaic. |
| hibridacion | hybridization | Hybridization (renewable + storage, reported since 2023). |
| total | — | Sum across the technologies above. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Valid values for status
| Code | English alias | Description |
|---|---|---|
| en_servicio | in_service | Projects already in commercial operation. |
| con_permiso | permitted | Projects with grid-access and connection permits granted. |
| en_curso | under_review | Applications currently under review. |
| denegadas | rejected | Applications rejected or expired. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Returns
Spill array with header: Date, Ambito, CCAA, Tecnologia, Estado, GW. Column values are the Spanish canonical forms.
Examples
=ED.GRIDACCESS()— All rows (national + per-region)=ED.GRIDACCESS("national", , "solar_pv", "in_service")— National solar PV in-service trajectory (English aliases)=ED.GRIDACCESS("nacional", , "solar_fv", "en_servicio")— Same query in Spanish — equivalent=ED.GRIDACCESS("regional", "Andalucía", "wind", "permitted")— Wind permits granted in Andalucía=ED.GRIDACCESS(,,, "rejected", "2024-01-01")— Rejected applications since 2024Notes
- Historical depth: Aug 2019 → present, monthly. Updated on the 5th of each month (after REE's late-month publication).
- Three technologies only (PDF source). For 8 technologies use ED.GRIDACCESS.PORTAL but you only get the latest snapshot.