Plexos q a for missouri commission
This presentation is the property of its rightful owner.
Sponsored Links
1 / 10

PLEXOS Q&A for Missouri Commission PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

PLEXOS Q&A for Missouri Commission. Input Screen.

Download Presentation

PLEXOS Q&A for Missouri Commission

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Plexos q a for missouri commission

PLEXOS Q&Afor Missouri Commission

Input screen

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

Bulk input

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

Import export wizards

Import/Export Wizards

Import Wizard

Export Wizard

Confidential & Proprietary Information

Output processing

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

Output processing gui

Output Processing GUI

Compare two scenarios

Save your Queries

Queried Report

With Data and Chart

Right Click and Save to Excel

Object Filter

Multi Dimension Query

Confidential & Proprietary Information

Changing individual unit data

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

Changing i ndividual u nit d ata

Changing Individual Unit Data

Directly Input or Modify on the cell

Confidential & Proprietary Information

Unit simulation data

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?

Confidential & Proprietary Information

Unit simulation data reporting

Unit Simulation Data Reporting

Object Class Filter

Numerous Properties can be toggled on/off for each object class for report

Confidential & Proprietary Information

  • Login