Page 808 - ExtendSim User Guide
P. 808

782
Data Management and Exchange
Data source indexing and organization
column, row, or cell. Each row of the block’ table defines one initialization record for one tar- get. Each initialization record can be set up to initialize the data it refers to at every run, the first run only, or to not initialize. Each cell in a given row of the table contains interface items that allow customization of that particular initialization record.
Other blocks for modelers
Data Specs
The Data Specs block (Value library) reports information about a selected Extend- Sim database or global array. You can assign a name to the specification report, select its components through popup menus, initialize the outputs, and display the specification’s name and/or values on output connectors.
Command
Blocks for developers
The Utilities and ModL Tips libraries contain several blocks to assist block developers, such as the Object Mapper block in the Utilities library.
Data source indexing and organization
Communicating between various types of data sources has been greatly assisted by standard- ized technologies, such as the ability of diverse applications to exchange data through a stan- dard text file format. However, it is important to keep in mind that each standard has its own conventions. This can cause data-confusion when transferring data from one type of source to another.
Transferring data between a data table and a spreadsheet
ExtendSim data tables have zero-based indexes and are organized by row and column –data starts at row 0, column 0. Spreadsheets are also organized by row and column, but they are one-based – data starts at row 1, column 1. When transferring data from an ExtendSim data table to an Excel worksheet, the row and column numbers for Excel must both be increased by 1 compared to their location in the ExtendSim data table.
Transferring data between a spreadsheet and a database
Databases are one-based like spreadsheets, but are organized by fields and records (equivalent to columns and rows) rather than being organized by the spreadsheet convention of rows and columns.
Indexing and organization
The following table lists indexing and organization conventions for different data source types.
When triggered by a value at its “send” input, the Command block (Value library) sends a command, such as an Excel macro or DDE command, to a spreadsheet. You can select a command to send and choose when the command is sent.
Data Source Type Data Tables
Spreadsheets
Indexing How organized 0-based Row/Column 1-based Row/Column
How To


































































































   806   807   808   809   810