eXpress

  Help

×
Menu
Index
 

Model topology Import Excel Spreadsheet

 

Feature Description

 

Sample Spreadsheet

 
This is a partial image of an exported Flight Actuator model excel spreadsheet showing a typical row of data and its explanation. This attenuated spreadsheet was made for readabilty. For a full list of possible columns see  List of Supported Columns . For this sample only 20 exported columns were needed as shown below. The full exported spread sheet was 20 columns and 700 rows deep. The imported model looks identical to the export model but has no Test Sets.
 
 
The table below show typical exported data transposed from horizontal to vertical for explanation.
Column Header
Column data
 Description
Object
Object Name -Typical = K1
 
Port
Port Name -Typical = 5-PHA_DRV
 
Port Flow
Port Flow Name -Typical = output
 
Function
Function Name -Typical  = K1-5-PHA_DRV_SW-HOLD
 
Dependencies
Dependencies Name = RELAY_COIL
 
Object States
Object States Name = [F1]:HOLD
 
Net
Net Name -Typical = PHA_DRV_SW
 
I/O Flag
I/O Flag Name -Typical = [blank - not applicable here]
 
Symbol
Library Symbol -Typical = !sym93719
Library symbol to use for import
Color
Color Name -Typical = Pale Blue
 
Location
Location -Typical = {1770,-1130}
Location in a 10,000 by 10,000 grid
Size
Symbol Size  -Typical =[200,400]
Context Panel Size of Object
Port Location
Port Location -Typical =E-{10000,5925}
 
Net Type
Net Type -Typical = #Wire
Wire versus Pipe setting in eXpress
Net Color
Net Color  -Typical = Black
Standard
Font Type
Font Type -Typical = Arial
Standard
Font Size
Font Size  -Typical = 40
 
Text Color
Text Color -Typical = Black
Standard
Justification
Justification -Typical = Left {105,5}
Text Position as shown in context panel
Annotation
Annotation  -Typical = [blank - not applicable here]