DER VET User Guide/Inputs/Timeseries File

Timeseries Inputs

This section describes the timeseries input file.

Datetime

Column Header

Description

Datetime (he)

This column provides time stamps for the rest of the data. This should be formatted as a yyyy-mm-dd hh:mm:ss string. (e.g. "2021-01-25 15:00:00" would be January 25, 2021 at 3pm Note: sometimes Excel or other editors will change the format of timestamps according to your settings. Please ensure these are formatted as described above to avoid errors. These are timestep-ending timestamps, meaning that the time 02:00:00 represents the time step that ends at 2am. If the time step is 1 hour, then this would represent the interval starting a 1am and ending at 2am. The amount these timestamps increment from row to row should match the time step input parameter. If the time step is 0.25 (15 minutes), then the first few time stamps might look like ("2022-01-01 00:15:00", "2022-01-01 00:30:00", "2022-01-01 00:45:00", "2022-01-01 01:00:00"). The number of time stamps should be equal to the number of hours in a year (8760 for non-leap years and 8784 for leap years) divided by dt for each optimization year. Subsequent opt_years should be appended to the bottom of the file.

PV Generation

Column Header	Description
PV Gen (kW/rated kW)	This column provides solar PV (or wind) generation data in units of kW/ kw_rated. In most cases, this should take a value between 0 and 1. If the (AC) rated power capacity of a solar system is 100 MW and the PV Gen (kW/rated kW) = 1, then it will be generating 100 MW at that time.

System Load

Column Header	Description
System Load (kW)	This column provides the system load in kW, which is used to approximate the timing of Resource Adequacy and Demand Response events.

EV Fleet Charging

Column Header	Description
EV fleet/ID (ID should be replaced by the ID in the model parameters sheet of the corresponding EV inputs. There can be multiple copies of this column EV fleet/1, EV fleet/2, etc.)	This column represents the baseline charging load in kW presented by a charging plaza where many vehicles charge. DERs and controlled EV charging will modify this load. This is used by the electric vehicle 2 (fleet) technology when it is active.

Site Load

Column Header	Description
Site Load (kW)	This column represents the baseline electric demand of the site without any DERs.

Combined Regulation Price

Column Header	Description
FR Price ($/kW)	This column represents the price of regulationin a combined market (regulation up and regulation down are offered together). This will be ignored if the FR Combined parameter is set to 0.

Regulation Up Price

Column Header	Description
Reg Up Price ($/kW)	This column represents the price of regulation up in a separated regulation market (regulation up is offered separately from regulation down). This will be ignored if the FR Combined parameter is set to 1.

Regulation Down Price

Column Header	Description
Reg Down Price ($/kW)	This column represents the price of regulation down in a separated regulation market (regulation up is offered separately from regulation down). This will be ignored if the FR Combined parameter is set to 1.

Day Ahead Market Energy Price

Column Header	Description
DA Price ($/kWh)	This column represents the price of energy in the day ahead energy market. (This can be substituted with real time energy prices in some cases) These prices are used for all energy transfers when the DA service is active.

Load Following Price

Column Header	Description
LF Price ($/kW)	This column represents the value of the load following service when the combined flat is 1.

Load Following Energy Throughput (up)

Column Header	Description
LF Energy Option Up (kWh/kW-hr)	This column represents the amount of energy that will be required over an hour for participating in 1 kW of the load following service in the up direction (either reduce charging power or increase discharging power/generation power).

Load Following Energy Throughput (down)

Column Header	Description
LF Energy Option Down (kWh/kW-hr)	This column represents the amount of energy that will be required over an hour for participating in 1 kW of the load following service in the down direction (either increase charging power or decrease discharging power/generation power).

Deferral Load

Column Header	Description
Deferral Load (kW)	This column represents the load drawn by the rest of the distribution system (exclusive of the site load or any other power flows behind the POI). This is used by the deferral service to constrain the amount of power exported from/imported to the site to maintain power flows in the overloaded asset within bounds.

Non-Spinning Reserves Price

Column Header	Description
NSR Price ($/kW)	This column represents price of non-spinning reserves, used when the service is active.

Spinning Reserves Price

Column Header	Description
SR Price ($/kW)	This column represents price of spinning reserves, used when the service is active.

Resource Adequacy Active Timesteps

Column Header	Description
RA Active (y/n)	This column collects a binary (0 or 1) input indicating whether or not the time step should be considered for the Resource Adequacy service. If the value is 0, this time step will never be part of a RA event, even if the system load peaks there.

Maximum Export Power

Column Header	Description
POI: Export Max (kW)	This column collects the maximum power that can flow from the POI to the rest of the grid. These values should be in the set [0, +inf). These constraints are only applied when the user-defined service is active.

Maximum Stored Energy

Column Header	Description
Aggregate Energy Max (kWh)	This column sets the maximum stored energy in all of the storage systems being modeled. These constraints are only applied when the user-defined service is active.

Minimum Stored Energy

Column Header	Description
Aggregate Energy Min (kWh)	This column sets the minimum stored energy in all of the storage systems being modeled. These constraints are only applied when the user-defined service is active.

Critical Load

Column Header	Description
Critical Load (kW)	The critical load is the component of the site load that is backed up by the reliability service. It can be greater than the site load (in cases like an emergency shelter where load increases during grid outages), but is often much less, representing only those loads which are necessary to back up.

Minimum Battery Charge Power

Column Header	Description
Battery: Charge Min (kW)/ID (ID should be replaced by the ID in the model parameters sheet of the corresponding battery inputs. There can be multiple copies of this column Battery: Charge Min (kW)/1, Battery: Charge Min (kW)/2, etc.)	When the incl_ts_charge_limits input parameter for energy storage systems is 1, this will constrain the storage system to charge at or above this level.

Maximum Battery Charge Power

Column Header	Description
Battery: Charge Max (kW)/ID (ID should be replaced by the ID in the model parameters sheet of the corresponding battery inputs. There can be multiple copies of this column Battery: Charge Max (kW)/1, Battery: Charge Max (kW)/2, etc.)	When the incl_ts_charge_limits input parameter for energy storage systems is 1, this will constrain the storage system to charge at or below this level.

Maximum Battery State of Energy

Column Header	Description
Battery: Energy Max (kWh)/ID (ID should be replaced by the ID in the model parameters sheet of the corresponding battery inputs. There can be multiple copies of this column Battery: Energy Max (kWh)/1, Battery: Energy Max (kWh)/2, etc.)	When the incl_ts_energy_limits input parameter for energy storage systems is 1, this will constrain the storage system to maintain a state of energy at or below this level.

Minimum Battery State of Energy

Column Header	Description
Battery: Energy Min (kWh)/ID (ID should be replaced by the ID in the model parameters sheet of the corresponding battery inputs. There can be multiple copies of this column Battery: Energy Min (kWh)/1, Battery: Energy Min (kWh)/2, etc.)	When the incl_ts_energy_limits input parameter for energy storage systems is 1, this will constrain the storage system to maintain a state of energy at or above this level.

Minimum Battery Discharge Power

Column Header	Description
Battery: Discharge Min (kW)/ID (ID should be replaced by the ID in the model parameters sheet of the corresponding battery inputs. There can be multiple copies of this column Battery: Discharge Min (kW)/1, Battery: Discharge Min (kW)/2, etc.)	When the incl_ts_discharge_limits input parameter for energy storage systems is 1, this will constrain the storage system to discharge at or above this level.

Maximum Battery Discharge Power

Column Header	Description
Battery: Discharge Max(kW)/ID (ID should be replaced by the ID in the model parameters sheet of the corresponding battery inputs. There can be multiple copies of this column Battery: Discharge Max(kW)/1, Battery: Discharge Max(kW)/2, etc.)	When the incl_ts_discharge_limits input parameter for energy storage systems is 1, this will constrain the storage system to discharge at or below this level.

Maximum Regulation Up

Column Header	Description
FR Reg Up Max (kW)	When the u_ts_constraints input parameter for the Frequency Regulation service is 1, this will constrain the DERs to provide at most this quantity of regulation up.

Minimum Regulation Up

Column Header	Description
FR Reg Up Min(kW)	When the u_ts_constraints input parameter for the Frequency Regulation service is 1, this will constrain the DERs to provide at least this quantity of regulation up.

Maximum Regulation Down

Column Header	Description
FR Reg Down Max (kW)	When the d_ts_constraints input parameter for the Frequency Regulation service is 1, this will constrain the DERs to provide at most this quantity of regulation down.

Minimum Regulation Down

Column Header	Description
FR Reg Down Min(kW)	When the d_ts_constraints input parameter for the Frequency Regulation service is 1, this will constrain the DERs to provide at least this quantity of regulation down.

Maximum Spinning Reserves

Column Header	Description
SR Max (kW)	When the ts_constraints input parameter for the spinning reserves service is 1, this will constrain the DERs to provide at most this quantity of spinning reserves.

Minimum Spinning Reserves

Column Header	Description
SR Min (kW)	When the ts_constraints input parameter for the spinning reserves service is 1, this will constrain the DERs to provide at least this quantity of spinning reserves.

Maximum Non-Spinning Reserves

Column Header	Description
NSR Max (kW)	When the ts_constraints input parameter for the non-spinning reserves service is 1, this will constrain the DERs to provide at most this quantity of non-spinning reserves.

Minimum Non-Spinning Reserves

Column Header	Description
NSR Min(kW)	When the ts_constraints input parameter for the non-spinning reserves service is 1, this will constrain the DERs to provide at least this quantity of non-spinning reserves.

Maximum Load Following Up

Column Header	Description
LF Up Max (kW)	When the u_ts_constraints input parameter for the load following service is 1, this will constrain the DERs to provide at most this quantity of load following in the up direction.

Minimum Load Following Up

Column Header	Description
LF Up Min (kW)	When the u_ts_constraints input parameter for the load following service is 1, this will constrain the DERs to provide at least this quantity of load following in the up direction.

Maximum Load Following Down

Column Header	Description
LF Down Max (kW)	When the d_ts_constraints input parameter for the load following service is 1, this will constrain the DERs to provide at most this quantity of load following in the down direction.

Minimum Load Following Down

Column Header	Description
LF Down Min(kW)	When the d_ts_constraints input parameter for the load following service is 1, this will constrain the DERs to provide at least this quantity of load following in the down direction.

Load Following Down Price

Column Header	Description
LF Down Price ($/kW)	This column represnts the value of providing load following in the down direction when not combined with load following up.

Load Following Up Price

Column Header	Description
LF Up Price ($/kW)	This column represnts the value of providing load following in the updirection when not combined with load following down.

Site Steam Thermal Load

Column Header	Description
Site Steam Thermal Load (MMBtu/hr)	This column represents the steam thermal demand of the site. At least one thermal heating technology ( CHP or Boiler) must be active if this column appears in the Input Timeseries File.

Site Hot Water Thermal Load

Column Header	Description
Site Hot Water Thermal Load (MMBtu/hr)	This column represents the steam thermal demand of the site. At least one thermal heating technology ( CHP or Boiler) must be active if this column appears in the Input Timeseries File.

Site Cooling Thermal Load

Column Header	Description
Site Cooling Thermal Load (MMBtu/hr)	This column represents the steam thermal demand of the site. A cooling technology ( Chiller) must be active if this column appears in the Input Timeseries File.