underconstruction#
The underconstruction function retrieves information about data centers that are currently under construction with filtering and aggregation.
This is a function without parameters that sends a GET request to the Vulcan V2 underconstruction endpoint.
In the Formula Builder, select Vulcan 2.0, then choose the underconstruction function from the Enter Function dropdown. Once selected, click Insert to automatically add the formula to Excel.
Syntax#
=SMXV2.underconstructuction()
Output Parameters#
When executed, this function returns under-construction datacenter data directly into the active Excel worksheet, displaying the output dataset with all relevant fields and records.
The returned Excel sheet includes the following data columns:
Field |
Description |
Example |
|---|---|---|
plant_id |
EIA plant id |
67501 |
plant_name |
EIA plant name |
Green River Energy Center - Hybrid - Battery |
generator_id |
EIA ID given to each generator for a given plant |
GRBS |
entity_name |
EIA plant operating entity |
Green River Energy Center, LLC |
state_code |
2 letter plant state code - provided by EIA |
UT |
balancing_authority |
EIA balancing authority responisble for grid reliability in plant’s service area |
PACE |
technology |
EIA primary generation technology |
Batteries |
nameplate_capacity |
EIA plant generator capacity |
400 |
nameplate_capacity_unit |
mw |
|
plant_status |
EIA plants operational status, or its stage of construction |
(V) Under construction, more than 50 percent complete |
latitude |
EIA plant latitude |
38.9987 |
longitude |
EIA plant longitude |
-111.1172 |
date_vulcan_status_change |
Date of which a plants status was changed to under construction |
1/22/2025 |
date_image |
Date of the latest available satellite image |
4/27/2025 |
vulcan_status |
Indicates if a plant has been observed to be under construction |
Confirmed |
observation |
Observations or relevant plant comments after reviewing satellite images |
land cleared |
date_construction_start |
Start date of construction for a given plant |
6/16/2024 |
date_land_cleared |
Date of first land cleared for a given plant |
6/16/2024 |
date_first_structures |
Date where the first permanent structures are identified for a given plant |
|
date_construction_50_percent_complete |
Date where a plant has been deemed to appear 50% complete |
TBD |
date_construction_completed |
Date where plant has been deemed complete based on satellite observations |
TBD |
vulcan_tech |
The generalized technology assigned by Vulcan. Used to estimate construction times |
Solar Battery |
date_planned_operation |
The EIA online month and year with each date assigned to the 15th of the given month to normalize data. |
5/15/2026 |
date_vulcan_earliest_plus_7 |
The earliest possible date a plant could be operational if construction were to start 1 week after the last update. |
6/3/2026 |
date_vulcan_earliest_online |
The earliest possible date a plant is projected to be operational |
6/3/2026 |
date_vulcan_latest_online |
The latest possible date a plant is projected to be operational |
11/17/2029 |
days_eia_minus_vulcan_earliest_online |
The difference in days between the EIA online date and the Vulcan earliest date |
-19 |
days_eia_minus_vulcan_latest_online |
The difference in days between the EIA online date and the Vulcan latest date |
-1282 |
project_rank |
Indicates the likelihood of a plant’s construction. Values range from 0-7, a higher-ranking number indicates a higher likelihood of plant construction. |
4.2959 |
total_generators |
Count of generators for a given plant id |
1 |
synmax_id |
Unique key of plant id and generator id |
67501-GRBS |
permission |
1 |
|
source |
The source of the plant data |
|
created_at |
ISO date on which the record was created |
TBD |
modified_at |
ISO date on which the record was last modified |
TBD |
Example Output#
plant_id |
plant_name |
generator_id |
entity_name |
state_code |
balancing_authority |
technology |
nameplate_capacity |
nameplate_capacity_unit |
plant_status |
latitude |
longitude |
date_vulcan_status_change |
date_image |
vulcan_status |
observation |
date_construction_start |
date_land_cleared |
date_first_structures |
date_construction_50_percent_complete |
date_construction_completed |
vulcan_tech |
date_planned_operation |
date_vulcan_earliest_plus_7 |
date_vulcan_earliest_online |
date_vulcan_latest_online |
days_eia_minus_vulcan_earliest_online |
days_eia_minus_vulcan_latest_online |
project_rank |
total_generators |
synmax_id |
permission |
source |
created_at |
modified_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69197 |
Halifax County Solar |
HALIF |
AES Clean Energy |
NC |
PJM |
Solar Photovoltaic |
80 |
mw |
(U) Under construction, less than or equal to 50 percent complete |
36.2537 |
-77.6884 |
11/4/2025 |
11/1/2025 |
Confirmed |
panels visible |
8/4/2025 |
1/2/2025 |
8/4/2025 |
TBD |
TBD |
Solar |
3/15/2026 |
3/2/2026 |
3/2/2026 |
8/16/2029 |
13 |
-1250 |
4.5379 |
1 |
69197-HALIF |
1 |
TBD |
TBD |
|
64239 |
7V Solar Ranch |
7V1 |
7V Solar Ranch, LLC |
TX |
ERCO |
Solar Photovoltaic |
240 |
mw |
(OP) Operating |
29.807 |
-97.0741 |
10/24/2024 |
4/14/2025 |
Completed |
panels visible |
7/12/2023 |
5/7/2022 |
7/12/2023 |
TBD |
TBD |
Solar |
2/7/2024 |
2/7/2024 |
7/24/2027 |
1 |
64239-7V1 |
1 |
TBD |
TBD |
|||||
66908 |
Bonanza Solar and Storage Project - Battery |
BZPV |
EDF Renewables Development, Inc. |
NV |
CISO |
Solar Photovoltaic |
300 |
mw |
(L) Regulatory approvals pending. Not under construction |
36.558 |
-115.799 |
7/1/2025 |
5/15/2025 |
Identified |
land cleared |
6/11/2025 |
6/11/2025 |
TBD |
TBD |
Solar Battery |
12/15/2027 |
6/3/2026 |
6/3/2026 |
11/17/2029 |
560 |
-703 |
3.9616 |
1 |
66908-BZPV |
1 |
TBD |
TBD |
||
66915 |
Cottonwood Bayou Solar |
CTW |
Cottonwood Bayou Solar, LLC |
TX |
ERCO |
Solar Photovoltaic |
350 |
mw |
(TS) Construction complete, but not yet in commercial operation |
29.2631 |
-95.258 |
1/15/2025 |
4/12/2025 |
Completed |
panels visible |
10/17/2023 |
7/31/2023 |
10/17/2023 |
TBD |
TBD |
Solar |
11/15/2025 |
5/14/2024 |
5/14/2024 |
10/29/2027 |
550 |
-713 |
2.9403 |
2 |
66915-CTW |
1 |
TBD |
TBD |
Errors#
Functions may return the following error messages:
Error |
Description |
|---|---|
#VALUE! |
Input parameters are invalid or cannot be parsed. |
#REF! |
The function cannot retrieve data from the SynMaxax API due to a network or connectivity issue. |
!!! EXCEPTION |
Invalid input parameters. Make sure dates are enclosed in quotes. Check if the API key is valid. To know more about how to use an API key, please check the section on authentication. |
#No Data |
Input data is invalid or does not exist. |
Note
You can also check the logs for more information on errors. You can access the logs by clicking on SynMax Commodities on the Excel ribbon and then clicking on Logs.