PLEXOS Basic Online

Training
SESSION 1 | May 2022
Energy Exemplar and
PLEXOS

© 2021 Energy Exemplar | 2

Energy Exemplar

Unified
energy market and portfolio
simulation, forecasting and optimization
software and data services

© 2021 Energy Exemplar | 3

 PLEXOS
PLEXOS is the leading software solution in the industry for
modeling and optimization of integrated energy systems.

 Techno-economic optimization:
 Minimize costs while meeting demands + technical
constraints
 Commodities: Electricity, gas, water
 Model producers, consumers, financial agreements

 Model uncertainties using Stochastics.

 Ability to co-optimize among different commodities.

© 2021 Energy Exemplar | 4

What Makes PLEXOS Unique
Delivering value ahead of the industry transformation curve

UNIFIED ENERGY MODEL CUSTOM CONSTRAINTS UNCERTAINTY MODELING

Deterministic scenarios
Global co-optimization Linear constraints
Monte-Carlo simulations
Horizon integration Non-linear constraints
Stochastic optimization

FLEXIBLE INFRASTRUCTURE PERFORMANCE & SCALABILITY ADVANCED ANALYTICS

On-premise Persona-based analytics

Grid & cloud computing
Cloud workspace Advanced visualization
Burst cloud
SaaS cloud Business intelligence

© 2021 Energy Exemplar | 5

Single Unified Energy System
Global co-optimization across all commodity types and
markets
Water Storage

Carbon Market

Ancillary / Water Treatment Plant Water Pump

Hydro Topology
Capacity Market Fuel

Re-Gas / Liquefication Plant Gas Demand

Water Demand

Power Generation
Gas Generation Hydro Generation
Gas Field Gas Storage Pipeline Network
P2G Hydrogen
PPA / Bilateral Contracts
H-Storage

LNG Import/Exports Take or Pay

Contracts CHP Plant Network Topology / Renewable Generation
Energy Market

Demand Energy Storage

Steam Demand V2G
Response
Power Demand
© 2021 Energy Exemplar | 6
Integration of All Planning Horizons

LT Capacity Expansion Reliability MT Planning ST Operations

• Capital investments • Projected Assessment of • Constraint decomposition • Detailed operational

• Integrated energy model System Adequacy • Emissions allowances optimization
(gas, generation, • Optimal reserve share • Fuel limits • Unit commitment and
transmission, storage, • System maintenance and • Hydro storage levels economic dispatch
• Storage targets
hydrogen, etc.) outage scheduling • SCUC and SCED
• Take of pay contracts
• IRP • FOR Monte-Carlo modeling • Sub-hourly and sub-minute
• Resource allocation
• Optimal expansion build • Reliability metrics: LOLE, intervals
• Budgeting
and retirement plan LOLP, EENS, etc. • Optimal bidding
• Resource adequacy

© 2021 Energy Exemplar | 7

Training Agenda: 6 Sessions
• About PLEXOS • Hydro modeling

1 • Interface, components, workflow

4 • Energy Constrained, Dam storage,
Pumped storage, Cascaded etc.
• Data modeling

• Load Forecasting
• ST Modeling: UC and ED
2 • Fuels, ToP Contracts
5 • MT Modeling
• Pricing

• Variable Class, Stochastics

• LT Modeling
3 • Renewables and Batteries 6 • Generator Capacity Expansion
• Constraints

© 2021 Energy Exemplar | 8

PLEXOS Basic Modeling

© 2021 Energy Exemplar | 9

PLEXOS Help

• Online & Local PLEXOS Help/Guide:

– Getting Started
– User Interface Guides
– Modelling Guide
– Technical References
– Class Reference
– Release Notes

• Context sensitive
– Place cursor at a variable in the input or
output interface then press F1 key to
view class or property description.

© 2021 Energy Exemplar | 10

PLEXOS Input Interface - Structure
Objects: Generators, Fuel, Region, Bus, Data
File...

System Memberships: Generator.Bus, Generator.Fuel…

Properties: Unit, Max Capacity, Heat Rate…

Input Interface

Objects: Model, Horizon, Reports, LT, MT, ST…

Simulatio Memberships: Model.Scenario,
n Model.Horizon…
Properties: Settings of objects

© 2021 Energy Exemplar | 11

Three Layers of Hierarchy
1. Objects
– Entities to be modelled under system/simulation defined classes
2. Memberships
– Relationships between objects
– Uniquely defined by a membership collection type
3. Properties
– Characteristics of objects
– Used to store data associated with objects
– Can be either single-point (static) data or multi-point (dynamic) data

© 2021 Energy Exemplar | 12

Elements of PLEXOS Input Interface – System
Tab
Ribbon menu

Memberships
Static
tree
Properties

Objects Properties
tree tree
Dynamic
Properties

Tree pane Data grid pane © 2021 Energy Exemplar | 13

Elements of PLEXOS Input Interface – Simulation Tab

Ribbon Menu

Memberships
tree

Objects data
grid

Properties
Objects tree
tree

Tree Pane Data Grid Pane © 2021 Energy Exemplar | 14

Objects
• System entities to be modelled:
– Regions
– Nodes and transmission lines
– Generators
– Constraints
– Data files

• Simulation settings are also objects:

– Models
– Horizons
– Report

**System tab Objects are enabled in the config

• Objects are displayed in the Object tree pane
menu
• Objects are organized by Class **Simulation tab Objects are enabled by creating the
object using the wizard dialog (right click button action)
• Objects can be grouped by user-defined Categories

© 2021 Energy Exemplar | 15

Config Menu: Enabling Classes, Objects, and
Properties
• New database is created with predefined
default class and property display Class

• Config menu is used to select classes and

Object
properties to display in the system tab Unit of
measure

• Tick the class, object or property that you will

use
Property

If a property is multi- Default value

band © 2021 Energy Exemplar | 16
Creating Objects
Ways to create new objects:
1) Use New Object command in the wizard dialog of the system collections

2) Enter the name of the new object on the objects grid

17

© 2021 Energy Exemplar | 17

Memberships
• Membership is a method used to define FUNCTIONAL and LOGICAL relationships
between objects:
– A Generator is connected to a Node
– A Node belongs to a Region
– A Transmission line connects two Nodes
– A Model uses Horizons and Reports (Simulation tab)

© 2021 Energy Exemplar | 18

Memberships
• Memberships are displayed in the Membership tree pane
– Red code: Membership is required.
– Black code: The object is parent object in the membership.
– Blue code: The object is child object in the membership.
– Grey code: Membership is inferred or not directly editable.

Region is a required Gen1 is member of Reg A

membership for since its Node 1 is member
Node of Reg A
© 2021 Energy Exemplar | 19
Creating Memberships
1. Drag-and-drop - the objects into membership collections or directly to other object
a) Drag “Node 1” onto Reg1, or
b) Drag Region “Reg A” into Region Membership collection of Node 1
This will instruct PLEXOS that “Node 1” belongs to “Reg A”

b)

a)

© 2021 Energy Exemplar | 20

Creating Memberships
2. Data Grid Membership Tab – Define membership by using the Data Grid Pane

Highlight the
Generator or Select the Node (Child) we want
the whole to add to the Generator.Node
class collection from the drop down
menu

© 2021 Energy Exemplar | 21

Creating Memberships
3. Memberships Tree - Invoke Membership editor by:
a) double-clicking the membership collection, you want to edit
b) right-clicking the membership collection and clicking the Memberships command

Double click collection for editing or

right click on Memberships
command

Select region to be added in

Node’s region membership
collection and click “Add”
© 2021 Energy Exemplar | 22
Database Membership Structure in PLEXOS

SYSTEM TAB:

SIMULATION TAB:

© 2021 Energy Exemplar | 23

Properties
• Characteristics of objects:
o Maximum capacity of a generator
o Fuel price of a fuel
o Load profile of a region

• Properties are displayed in the Property tree pane

o Red code: The property toggles object in or out of simulation runs.
o Value = 0, Object is out; Value > 0, Object is in.
o Black code: Object is parent in membership of defined property.
o Blue code: Object is child in membership of defined property.

1,000+ Input Properties Available! © 2021 Energy Exemplar | 24

Defining Data to Properties
Static Properties
– Property value is fixed and never
changes,
Static properties in upper grid
– Yellow icon in properties tree pane, no change in simulations

– Static properties appear on the upper

half of data grid

Dynamic Properties
– Property value can be changed over the Dynamic properties in lower grid pane,
can be changed by date, timeslice or
planning horizon and/or by scenario scenario
– Blue icon in properties tree
– Dynamic properties appear on the lower
half of data grid pane

© 2021 Energy Exemplar | 25

 Changing Static Properties to Dynamic
1.Click ‘Config’ button of the ribbon menu
2.Tick boxes in ‘Dynamic’ column to make
property Static or Dynamic

Optional: Overriding selections to make all

properties Dynamic
• Tick “All Dynamic” box in lower left corner of
Config window

© 2021 Energy Exemplar | 26

System Tab Structure

Generator Object: Fuel Object:

“CCGT” “Natural Gas”
PROPERTIES: PROPERTIES:
Property Value Unit Property Value Unit
Units 1 - Price 12 $/GJ
Max Capacity 350
CONFIDENTIAL
MW Max Offtake
27
5000 GJ
Heat Rate 7.5 GJ
/MWh

© 2021 Energy Exemplar | 27

Linking External Files

© 2021 Energy Exemplar | 28

Linking Properties to External Files
1.Create a CSV file containing the input data in PLEXOS format.
2.Save it file in the location of the model.
3.Type its filename under Data File column of the corresponding property.

29

© 2021 Energy Exemplar | 29

Time Pattern

© 2021 Energy Exemplar | 30

Time Patterns
• Patterns are string expressions made up of one or more statements separated by commas and semi-colons.
• Pattern symbols are not case sensitive and additional spaces in the patterns will be skipped.
• The PLEXOS interface will sort data according to pattern as well as date, etc.
– When giving a list of simple patterns like monthly values it is best to use two digits for the month number i.e. M01,
M02, M03, etc, this way the values will display in the correct order.

Symbol Range Meaning

H 1-24 Hour of the day (1=midnight to 1.00am, 24=11:00pm to 12 midnight)
W 1-7 Day of week (1=Sunday, 2=Monday, ...)
D 1-31 Day of month
M 1-12 Month of calendar year (1=January, 2=February, ...)
Trading period of day (depends on horizon settings e.g. if running with a 30 minute period then P1 means
P 1 - Num. Trading Periods in Day
midnight to 12:30am, P2 means 12:30am to 1:00am, etc.)
Q 1-4 Quarter of the year (1=Jan to March, 2=April to June, ...)
! - This is the "not operator" e.g. "!H1-6" means the data applies in hours other than 1-6.

Pattern Interpretation
H1-6 The value applies only when the hour of the day is between 1 and 6
H1-6,H18-24 The value applies when the hour of the day is between 1 and 6, and 18-24
The value applies in hours 1 to 6 but only for weekday one or hours 2 to 8 for weekday seven, but not for
W1,H1-6;W7,H2-8
other weekdays.
P30-48 The value applies to periods 30-48 e.g. in a 30-minute interval simulation model © 2021 Energy Exemplar | 31
Exercise: Creating Objects, Memberships, and Properties
• Topology I of Region “Region_A” power system
TASKS:
• Open the Base File
2_River&Market
Region_A • Create Objects
• Create Memberships
1_CoalMine 3_LoadCenter • Map Coal and Gas to Node 1
Coal_Gen L1-2 L2-3 • Load is at Node 3
• Input the following Properties
Gas_Gen1 L1-3
• Create Region, Nodes, Lines, Generator Objects
Gas_Gen2
• Create Memberships between Region- Node,
Nod Load Participation Load Node-Line, Generator-Node
e Factor
1 0 H01-08 H09-17 H18-24 • Input the Properties
2 0
Load [MW] 480 760 630
3 1 • Enter the patterns for the loads

Property Coal_Gen Gas_Gen Gas_ Line Max Resistance Reactanc

1 Gen Flow (p.u.) e (p.u.)
2 (MW)
Units 1 1 1 L1-2 800 0.2 0.1
Max Capacity (MW) 500 250 250 L2-3 800 0.2 0.1
VO&M Charge 2 3 4 L1-3 800 0.2 0.1
($/MWh)
Heat Rate (GJ/MWh) 9 11 11 © 2021 Energy Exemplar | 32
Simulation Settings

© 2021 Energy Exemplar | 33

 Simulation Tab Setup
Object Descriptions Needed

Model Define simulation model required

Horizon Define simulation horizon and granularity required Basis of model

Set output report switches/specify which outputs should be

Report recorded required
Simulation

LT Plan Perform long-term resource planning At least one

Phases

Optimization Time
PASA Schedule maintenance events At least one
Frame
MT Schedule Define mid-term simulation parameters At least one

ST Schedule Define short-term simulation parameters At least one

Transmission Define transmission simulation parameters optional

34
Simulation

Production Define unit commitment parameters optional

Settings

Competition Define power market equilibrium method optional What and how

Stochastic Define stochastic simulation parameters optional

Performance Select and parametrize a solver required

Diagnostic Issue in-depth diagnostic reports optional © 2021 Energy Exemplar | 34

Model Object

© 2021 Energy Exemplar | 35

Model Object
Simulation Tab Set-up

System tab set- Scenario

Model object Report Output file
up
•Solution
•Objects, data
membershi
ps and
properties
•Done in the
system tab
Scenario Horizon Report Simulation Phase Performance

• Associate a • How long to • What data to • Define • Solver engine

set of run, what include in optimization and settings
modified resolution output file steps of the
conditions model
with a model
to compare
against the
base model
• E.g., price in
a region with
solar PV vs
without solar
PV

© 2021 Energy Exemplar | 36

Model Object
Properties Quick Reference
• Enabled – puts model in execution queue
• Random Number Seed – set it to non-zero so samples
remain the same every time the model is executed
• Execution Order - control execution order of models in
execution queue
• Output to folder - each solution in separate sub-folder
• Write Input – create input database with data and
settings specific to that model
• Load custom assemblies - turns customization on and off
if OpenPLEXOS customization is included
Group models into Projects which share:
• Solution files
• Horizon
• Reports
Allows for easy comparison
© 2021 Energy Exemplar | 37
Horizon Object

© 2021 Energy Exemplar | 38

 Horizons
• Each Horizon object holds a number of properties that determine both the length and
resolution of the simulation horizon

• The Horizon object has two length Planning

definitions: Horizon
• Planning Horizon (used in long-term
and medium-term simulations) Resolution

• Chronological Phase (used in short-

term simulation) (ST Phase)

• It is very important to note that Chronological

Phase (ST)
chronological phase must be a subset of
the planning horizon. PLEXOS will report an
error if this setting is violated

control the size of each

optimization©step in ST Phase
2021 Energy Exemplar | 39
Horizon Object: Examples
• Planning Horizon equal to 3 days and Chronological Phase equal to 2 days

Length Chronological Phase (CP)

Correct Setting: CP subset of PH
0 Length Planning Horizon (PH) 2 3 Days

• Planning Horizon equal to 3 days and Chronological Phase equal to 2 days

Length Planning Horizon (PH)

Length Chronological Phase (CP)
Incorrect Setting: CP is
0 2 3 Days not a subset of PH

© 2021 Energy Exemplar | 40

Examples of Horizons Setting
LT, MT and PASA

ST Only

×
Incorrect Setting:

Chronological Phase is not a Correct Setting: Chronological
subset of Planning Horizon Phase subset of Planning Horizon

© 2021 Energy Exemplar | 41

Report Object

© 2021 Energy Exemplar | 42

 Report Object
• Properties Tab Quick Reference
– Solution File Formats
• Access - can query data using ODBC, DAO,
etc.
• Flat Files
• Compressed XML (native format)
– Period Types
• Detail and /or summary data
– Stochastics (optional)
• Compute mean, min, max, stdev, etc. 43

• Save samples
– Filters
• Allows objects to be selectively chosen in
solutionSuggestion:
viewerThe size of solution files can get very large and cause slow execution. Therefore, use model and horizon
specific report objects – Debug, Budget, IRP, Hydro, Financial Contracts, Unit Outages, Units Starts, Stochastics, etc. © 2021 Energy Exemplar | 43
Report Object
Field List Tab

• Report Memberships
• Can report on selected items in class

• Output Selection Matrix

• Separate lists for each Phase
• LT Plan
• PASA
• MT Schedule
• ST Schedule

• Once period type and flat file is selected, you may

report individual properties by
• Period
• Summary
• Statistics
• Samples
• Flat Files

© 2021 Energy Exemplar | 44

Simulation
Phase:
ST Schedule

© 2021 Energy Exemplar | 45

Simulation Phase Object
User may select all simulation
phase and run in sequence or just
one phase and use it Transmission Granularity
during ST Phase
independently. Global Setting for Heat
Rate Detail During ST
Phase
• LT Plan
Stochastic Optimization
Setting in ST Phase
• PASA
• MT Schedule Controls how simulation
steps are linked
• ST Schedule 46

© 2021 Energy Exemplar | 46

Performance Object

© 2021 Energy Exemplar | 47

Performance Object
• Create a Performance object to map out the Solver to be used in the simulation.
• Solvers calculate the values of the decision variables while taking constraints into account.

© 2021 Energy Exemplar | 48

Executing a
Model

© 2021 Energy Exemplar | 49

Create Membership with the Model Object

Drag and Drop to

create membership In the simulation Tab, check if the
membership has been created with you
Model Object
• Horizon Object,
• Report Object,
• Simulation Phase Object, (ST,MT,PASA or
Check if membership is LT )
created with the Model • Performance Object
Object in the
Membership Tree

© 2021 Energy Exemplar | 50

Executing the Model Queue models for
execution

Right click on
a specific
model object

Choose how to execute

the models
e.g. sequential or parallel
runs?

© 2021 Energy Exemplar | 51

 Exercise: Setting Up the Model Object and Model
Execution TASKS:
 Open the Base File
 Create a “Base” Model in the simulation tab
• Topology I of Region “Region_A” power system  create a new Performance object
 Map CPLEX Solver
 Create membership between the Performance object and the
2_River&Market Model object.
Region_A
 Set up a Horizon object, increase the planning horizon to 2
years
1_CoalMine 3_LoadCenter  Create an ST Schedule Phase
 Set up a Report object and set the reporting resolution to
Coal_Gen L1-2 L2-3
Periods and Yearly
Gas_Gen1 L1-3  Execute the model
Generator: Region Line

Gas_Gen2 Generation Cost to Load Export Limit

Generation Cost Dump Energy Flow

Load
Net Revenue Generation Import Limit

Offer Cleared Generator Pool Revenue

Offer Price Load

Offer Quantity Price

Toggle the following in the report object field
list: Pool Revenue Unserved Energy

Price Received

SRMC

Units Generating
© 2021 Energy Exemplar | 52
Solution Viewer and Output
Interface

© 2021 Energy Exemplar | 53

 Opening the Solution
• Creates a folder :
• Model <model name> Solution PLEXOS will create a folder
• Inside the folder will be: to contain model solutions
• Log file (.txt)
• Zip file which will contain the
(.xml) file
• Stored at the same location as the
.xml database
• Can be opened and view in the
PLEXOS GUI
• Drag and drop the ZIP File to 54
PLEXOS

© 2021 Energy Exemplar | 54

 PLEXOS Solution Viewer

Ribbon menu

Simulation
phase

Period type – Data & Chart Tab Data layout tab

(enabled
from Report
Object)

Objects
tree
Date range
(optional)

Report
Properties
(enabled from Result and Log tab
Report Objects)

Tree and query pane Results

© 2021 Energy Exemplar | 55
pane
Solution Query
1. Highlight a Category or Object(s) from the System Tree
2. Define query parameters:
– Simulation phase
– Period type
– Date range (optional)
– Report Properties

3. Optional:
– Select a secondary property to generate a XY-axis chart
– Display results by sample (Monte Carlo or stochastic simulation)

4. Execute the query

© 2021 Energy Exemplar | 56

Solution Charts in Output Interface
• Solution query results are shown in tabs
• Each solution tab contains two tabbed pages
• Solution data tabbed page
• Solution chart tabbed page

• Solution chart display settings (“Chart” tab accessible via the Ribbon)
• Select chart type: line, bar, pie, etc.
• Time series or duration curve
• Secondary Y-axis also available

• Solution charts can be copied to clipboard

© 2021 Energy Exemplar | 57

Export Solution Data
Write to flat
files

Export to Excel

Right Click to Copy and Paste

selection of data

© 2021 Energy Exemplar | 58

Export Solution Data from Output Interface

• Click the Excel ribbon button at the Home tab, all the displayed data will be
automatically copied to a spreadsheet
• If Excel is already open, the ribbon button provides dropdown of extra commands
• New Sheet drops data into new worksheet of active Workbook
• Current Position drops data into active cell of active Workbook

• Highlight rows and columns to export part of the displayed data

• Right-click to display shortcut menu, and choose to copy column headers or not

© 2021 Energy Exemplar | 59

Scenario-Based Analysis

© 2021 Energy Exemplar | 60

Scenario
A Typical representation of scenarios in energy modelling:

CONFIDENTIAL 61

*Illustration is taken from US Department of Energy (http://energy.gov/eere/wind/maps/wind-vision)

© 2021 Energy Exemplar | 61

 Scenarios in PLEXOS
• What is a scenario in PLEXOS? 1
– A set of properties values grouped by a label 1
under the Scenario field

• Specifying a scenario involves:

2
1. Create a Scenario Object
2. Link relevant properties to the Scenario
3. Establish a membership between a Scenario
Object and a Model Object 3

62

© 2021 Energy Exemplar | 62

 A Few Things to Remember
• Adding a Scenario to a Model instructs PLEXOS to use:
• all the properties tagged with that scenario, as well as,
• all the properties that have no tag i.e. base data.
• Data from Scenarios overrides untagged data.
• Deleting a Scenario object – two options:
• Delete all properties associated with respective scenario
• Promote all properties associated with respective scenario to base data

CONFIDENTIAL 63

© 2021 Energy Exemplar | 63

Creating Scenario Object
Use New Scenario command in the wizard dialog of the system collections.

© 2021 Energy Exemplar | 64

Tagging Properties with Scenario
Label the dynamic properties with a Scenario in the dropdown list.

© 2021 Energy Exemplar | 65

Including Scenarios in Simulation
• Establish the membership between Model and
Scenario by double-clicking the Scenarios collection
and selecting the Scenarios.

• Another approach is to drag-and-drop the Scenario

object to the Model object.

© 2021 Energy Exemplar | 66

Viewing Model/ Scenario Grid
• Model/Scenario grid-
overview of membership between simulation
models and scenarios

In object tree either right-click 67

“Models” or highlight Scenario
class, click Scenario Collection
and click on Model/Scenario
Grid button
© 2021 Energy Exemplar | 67
Exercise: Creating a Scenario
• Topology I of Region “Region_A” power system

Hydro TASKS:
2_River&Market  Open the base model.
Region_A
 Add Generator object Hydro at Node 2_River &
Market
1_CoalMine 3_LoadCenter  Go to Config and enable the Scenario Class
Coal_Gen
L1-2 L2-3  Create a Scenario object “RunofRiver”
Gas_Gen1  Tag all the properties of Hydro with “RunofRiver”
L1-3
scenario (Make sure all the properties related to
Gas_Gen2
Hydro Generator are dynamic in order to tag with
the scenario)
Load
 Go to the Simulation tab
Property Hydro  Change the Horizon68 to 1 Week.
Units 1  Create a new Model object “Base+RunofRiver” and
select RunofRiver under scenarios collection
Max Capacity (MW) 250
 Execute the model
VO&M Charge ($/MWh) 1  Examine the results
Fuel Price ($/GJ) 0 Period Type = Interval
Max Capacity Factor Week 40% Date Range = 168 Hours
© 2021 Energy Exemplar | 68
Exercise: Creating a Scenario

The overall generation profile

of the model with Hydro
should now appear as shown.
Check that the Hydro object is
generating with the expected
output

© 2021 Energy Exemplar | 69

 Comparing Two Results
1. Open the two Models
2. Generate an output for each Model
3. Under the Ribbon Menu, select the Models that will be compared by clicking the “+” button
4. Click “Compare” button

© 2021 Energy Exemplar | 70

Comparing Two Results

CONFIDENTIAL 71

• The display when “Compare”  “Diffs Only” is selected.

Closely inspect the “Value” and “value Δ” columns

© 2021 Energy Exemplar | 71

Timeslice Objects

© 2021 Energy Exemplar | 72

Timeslices
• Timeslices enable user-defined time aggregation
• Built-in time aggregation: Interval, Day, Week, Month, and Year

• Timeslices are created using patterns, date from, date to, and even read from a text file,
i.e. Timeslices can use all usual input methods (except other Timeslices).
• [Include] is the only property for Timeslices and is a simple flag where 0 = false (No)
and -1 = true (Yes).
• You can create as many Timeslice objects as needed.

© 2021 Energy Exemplar | 73

Exercise: Defining Timeslices
Topology I of Region “Region_A” power system

TASKS:
2_River&Market
Region_A • Open the base model
• Go to Config and enable the Timeslice Class
1_CoalMine 3_LoadCenter • Create Timeslice objects as shown in the
Coal_Gen
L1-2 L2-3 previous slide
Gas_Gen1
L1-3 • Input [Include] = Yes and patterns of the
Gas_Gen2
Timeslice objects
• Go to the Region.
Load
• Replace the timeslice
74 of [Load] with the new
Timeslice objects using the Dropdown list

H01-08 H09-17 H18-24

Load
[MW] 480 760 630 © 2021 Energy Exemplar | 74
Timeslice Off-peak1 Peak Off-peak2
Data File Objects

© 2021 Energy Exemplar | 75

Data File Object
• Data files are for dynamically-changing data
 EX: Hourly load, generation profiles, monthly shapes
• Time intervals
 Annual, monthly, weekly, daily, hourly, sub-hourly
• Multi-band interval
 For data that spans across different bands (ex: heat rates)
• Several text file layouts
 .xlsx, .csv
• Open/edit files in PLEXOS GUI, or externally

Properties can be read from external data files even without the Data File Object
The advantage of having the Data File Object is that it will enable the user to add more properties
available to manage the external csv file

© 2021 Energy Exemplar | 76

 Data File Object
• Linking object’s property to data file:

– Create a data file object

– Set the [Filename] property to name of the file containing the data e.g. Load.csv
– Filename may be specified as fully qualified or relative
1. Fully qualified - specifies the entire location: “C:\Data\Load\Load.csv”
2. Relative - contains only portion of the full file location: “Load\Load.csv”
Folder “Load” must be in the same location as the database
– Right click the Data file and select “open” to view/edit values
– Set the desired property to use the data file object as its values

© 2021 Energy Exemplar | 77

Data File Properties
• Missing Value Method
 Method to fill missing data values
 Last Value, Zero, Default

• Upscaling Method
 Upscale data to more granular resolution (ex: hourly to 1-minute)
 Step, Interpolate, Boundary Interpolate

• Downscaling Method
 Downscale data to less granular resolution (ex: 5-minute to hourly)
 Average, First, Last

• Locale
 Some layouts are sensitive to regional datetime setting on local
computer
 Datetime format: UK: DD/MM/YYYY or US: MM/DD/YYYY
 Identifies the culture settings that were used when the Data File was
created:

United States 1033

United Kingdom 2057

• For a full list of available properties

 Config -> Data -> Data Files -> Attributes

© 2021 Energy Exemplar | 78

PLEXOS Datafile formats

1 2

Different options for specifying dates Standard types

• Year / Month / Day / Period • Names in Columns

• Datetime • Periods in Columns
• Pattern • Bands in Columns
• Timeslice

© 2021 Energy Exemplar | 79

CSV Data File Formats
Names in columns
• PLEXOS looks for the object name in the column
– Names must correspond to the object they are referring to
• Supports pattern or period column and datetime format
• Does not support up and down scaling

Year Month Day Period Gen1 Gen2 Gen3 … Datetime Wind1 Wind2 Wind3
Year Month Day Period Value
1/1/2018 3 4 6
2003 7 1 1 95 63 43.2 … 2003 7 1 1 95 1/1/2018 1:00 3 6 2
2003 7 1 2 133.5 203.3 72 … 2003 7 1 2 133.5 1/1/2018 2:00 3 1 5
2003 7 1 3 52.6 158 185 … 2003 7 1 3 52.6 1/1/2018 3:00 3 3 1
… … … …
2003 7 1 4 33.4 66.8 294.4 … 2003 7 1 4 33.4
1/1/2018 23:00 3 6 2
… … … … … … … … … … … … …
1/2/2018 3 6 4
2003 7 1 24 87 29.4 84.8 … 2003 7 1 24 87 1/2/2018 1:00 3 6 4
… … … … … … … … … … … … … … … … …

© 2021 Energy Exemplar | 80

CSV Data File Formats
Periods in Columns
• Supports up and down scaling
• Supports a name column
• Does not support band or pattern column
• Does not support datetime date format

Year Month Day 1 2 3 … 24

Year Month Day Name 1 2 3 … 24
2003 7 1 9333 9018 8875 … 7620
2003 7 1 Gen 1 95 133.5 52.6 87
2003 7 2 9493 9163 8977 … 7639
2003 7 1 Gen 2 63 203.3 158 … 29.4
2003 7 3 9593 9272 9067 … 7718
2003 7 1 Gen 3 43.2 72 185 … 84.8
2003 7 4 9528 9261 9080 … 7727
… … … … … … … … …
… … … … … … … …
2003 7 1 Gen n 165 74 58.8 … 176
2003 7 31 8469 8118 7853 … 6811

© 2021 Energy Exemplar | 81

CSV Data File Formats
Bands in Columns
• Supports a name column
• Supports Pattern or period column
• Supports datetime date format
• Does not support up and down scaling

Name Pattern 1 2 3 4 … 10
Year Month Day Period 1 2 3 4 5 6 7 8 9 10
PPCCGT P1-3 380 40 10 10 …
2003 7 1 1 315 145 60 10 10 10 10 10 130
PPCCGT P4-14 335 40 40 10 …
2003 7 1 2 315 125 60 10 10 10 10 10 150 PPCCGT P15-32 320 51 60 10 … 35

2003 7 1 3 315 105 60 10 10 10 10 10 170 PPCCGT P33-48 335 46 50 20 … 35

PLAYB-AG P1-12 90 90 …
2003 7 1 4 340 80 50 50 10 10 10 10 10 130
PLAYB-AG P13-43 160 20 2.7 29.4 …
… … … … … … … … … … … … … …
PLAYB-AG P44-48 90 90 …
2003 7 1 24 340 140 50 50 10 10 10 10 10 70 … … … … … … … …

© 2021 Energy Exemplar | 82

Exercise: Setting up Data Files
TASKS:
 Open the Base model
• Topology I of Region “Region_A” power system  Create a Scenario “Ignore” and
do not assign it to any model
 Tag the Region [Load] values
2_River&Market with the scenario “Ignore”
Region_A
 Create a Data File object
“LoadPatterns”
1_CoalMine 3_LoadCenter
Coal_Gen
 Create a csv file “Load.csv” with
L1-2 L2-3 the data given in the table
 Assign the csv database to the
Gas_Gen1
L1-3
Gas_Gen2
Data File object using
Pattern Value
Load
[Filename] property
H1-8 480
H9-17 760  Execute the model
H18-24 630

© 2021 Energy Exemplar | 83

Thank You!
Kuntal Satpathi
[email protected]