1 / 10

PLEXOS Q&A for Missouri Commission

PLEXOS Q&A for Missouri Commission. Input Screen.

quinta
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PLEXOS Q&Afor Missouri Commission

  2. 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

  3. 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

  4. Import/Export Wizards Import Wizard Export Wizard Confidential & Proprietary Information

  5. 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

  6. 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

  7. 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

  8. Changing Individual Unit Data Directly Input or Modify on the cell Confidential & Proprietary Information

  9. 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

  10. Unit Simulation Data Reporting Object Class Filter Numerous Properties can be toggled on/off for each object class for report Confidential & Proprietary Information

More Related