Transcript PLEXOS Q&A for Missouri Commission Input Screen • Does the software have blank input screens for inputting data? – Yes, we have input screen for entering data.

PLEXOS Q&A
for
Missouri
Commission
Input Screen
•
Does the software have blank input screens for inputting data? – Yes, we have input screen for
entering data. See the screenshot below. If so please provide a sample of an input screen. If
not, pleased explain how data is entered. If data can be entered from excel spreadsheets
please provide a sample of an input excel spreadsheet. – Yes, the data in the input window
can be easily copied from or to Excel for process.
Export to Excel using this button
Input
Screen
Confidential & Proprietary Information
2
Bulk Input
• Does the software accept bulk input data? If so, please explain the
method to do so, and provide a sample of a bulk input sheet. Can an
excel spreadsheet be used for multiple inputs.
–
There are two ways to handle bulk input data. One is very straightforward copy and paste from Excel. Another is
Import from Excel.
–
See the attached Excel Input Sample for the import format. It can be imported from XML file as well.
–
PLEXOS provides an Import/Export Wizard. First, the user can enter several sample objects through the user
interface. Then use the Export Wizard to generate an Excel Spreadsheet, and the next step is to follow the same
format in the Excel Spreadsheet when prepare your bulk data. Finally, use the Import Wizard to import the bulk
data into PLEXOS database. The Excel spreadsheet input can be reused for other databases.
–
The similar workflow can be used for transferring some data from one database to another database.
Confidential & Proprietary Information
3
Import/Export Wizards
Import
Wizard
Export
Wizard
Confidential & Proprietary Information
4
Output Processing
• Does the software allow for transfer of the output/results to an excel
spreadsheet? If so, please explain the method to do so, and provide a
sample of a excel spreadsheet with output data. If software only produces
predesigned reports, please provide a sample of the reports. If software
can produce custom reports, please explain method to do so, and provide
a sample of such report.
–
The simulation output can be queried from the user interface and saved to excel spreadsheet. The
user has the flexibility to query data by different dimension and pivot the data in different way.
The query can be saved as a customized view so it can be reused in the future. See a sample excel
output in the attachment.
–
PLEXOS can generate the output in Excel or compressed XML, MDB and CSV format.
Confidential & Proprietary Information
5
Output Processing GUI
Compare two
scenarios
Save your
Queries
Queried Report
With Data and
Chart
Right Click and
Save to Excel
Multi Dimension
Query
Object
Filter
Confidential & Proprietary Information
6
Changing individual unit data
• Can individual inputs be changed for a generating unit
without re-entering all the data for that generating unit?
– Absolutely. From the user interface, the input can be modified for
each individual object like generator, fuel, emission, etc. and for any
single property. It has some basic excel operation feature embedded
for the user to easily input and modify the data.
Confidential & Proprietary Information
7
Changing Individual Unit Data
Directly Input or
Modify on the cell
Confidential & Proprietary Information
8
Unit Simulation Data
•
Can each of the following items for a 12 month run be produced in a report, both monthly
and annually by PLEXOS?
For each generating unit the total MWH produced.
For each generating unit the total amount of BTUs used for
each fuel, including start up and supplemental fuels.
For each generating unit the total amount (tons/mcf/gal) of
each fuel burned, including start up and supplemental fuels.
For each generating unit the total number of hot starts, and the
total number of cold starts.
Yes
Yes
Unless configured to use Imperial Unit, this has to be
converted from BTU manually.
This needs to be post processed using hourly generator
on/off data.
For each generating unit the total number of hours on line
Yes
For each generating unit the total number of forced outage
hours
We provide Forced Outage MW for each hour, so it can be
counted easily. Force outage pattern could also be printed
out as flat file, so we could know when and how many hours
the forced outage happens.
For each generating unit the total cost to generate
Yes
For each fuel the total cost of fuel burned
Yes
For each purchase contract the total amount purchased and the
Yes
total cost
Confidential & Proprietary Information
9
Unit Simulation Data Reporting
Object Class
Filter
Numerous Properties can be toggled on/off
for each object class for report
Confidential & Proprietary Information
10