Adams Basic Package > Adams View > View Command Language > file > file spread_sheet write

file spread_sheet write

Allows you to write out a tab delimited file from an existing Adams View result set.

Format:

file spread_sheet write
file_name =	string
result_set_name =	an existing result set

Example:

file spread_sheet write &
file_name =	"c:\mydir\desktop\shell"

Description:

Parameter	Value Type	Description
file_name	String	Specifies the name of the file that is to be read, written, or executed.
result_set_name	An Existing Result Set	This parameter allows you to identify a result set name.

Extended Definition:

1. Any result set in Adams View that was created by reading in a REQUEST, or RESULTS file can be output into tab delimited spread sheet format.

You will be required to specify a file name and the result set name you wish to be written out.

Example:

FILE SPREAD_SHEET WRITE FILE_NAME=REQ5.sps RESULT_SET_NAME=REQ5

2. The proper extension is the default but can be overridden by simply supplying a different extension.You do not need to enclose the file name in quotes if it only contains alpha-numeric characters and starts with a letter. If you want to include other characters, such as a '.' for an extension or '/' or '[]' for directory paths, you must enclose the name in quotes.

3. A result set is a storage place for any kind of numeric tabular data. A result set can contain "n" components. A component is most usually set up to contain vector components of values like displacement, velocity, acceleration, force, etc. However, in this case, a result set is completely general and can store any numeric value in a component with only a few exceptions. These exceptions are those cases when the user asks the system to mix incompatible value types like complex in the same component as real values.

This is a required parameter and the result set name given must be within a particular analysis. A result set name may be arbitrarily long and a combination of letters of the alphabet and numbers may be used. The leading character must be a letter.

Result Sets are associated with an analysis run and can be identified as such. A result set associated with request 101 from an analysis named "test" is referred to as .test.req101.

Several predefined result set types are created when Adams request and result files are read into Adams View. For example, assume you have read a request file called "SHIFT.REQ", and this request file contains the result information for the Adams statement REQUEST/1. The result set will be named REQ1, and may also be referred to relative to the analysis name .shift.req1. If you wish to refer to a component in the same result set the full name for the X component would be .SHIFT.REQ1.X.

The following table illustrates the default names assigned to result sets and result set components read from request (.REQ) and results (.RES) files.

Result set type:	Result set name:	Component names:	File that result is from:
part	PARxxx...	x y z e1 e2 e3 e4 mag vx vy vz wx wy wz accx accy accz wdx wdy wdz	results file
diff	DIFxxx...	q dq	results file
joint	JOIxxx...	fx fy fz tx ty tz fmag tmag	results file
jprim	JPRxxx...	fx fy fz tx ty tz fmag tmag	results file
motion	MOTxxx...	fx fy fz tx ty tz fmag tmag	results file
gear	GEAxxx...	fx fy fz	results file
coupler	COUxxx...	fx1 fy1 fz1 tx1 ty1 tz1 fmag1 tmag1 fx2 fy2 fz2 tx2 ty2 tz2 fmag2 tmag2 fx3 fy3 fz3 tx3 ty3 tz3 fmag3 tmag3	results file
sforce	SFOxxx...	fx fy fz tx ty tz fmag tmag	results file
spring damp	SPRxxx...	fx fy fz tx ty tz fmag tmag	results file
bushing	BUSxxx...	fx fy fz tx ty tz fmag tmag	results file
beam	BEAxxx...	fx fy fz tx ty tz fmag tmag	results file
field	FIExxx...	fx fy fz tx ty tz fmag tmag	results file
user request	UREQxxx...	u1 u2 u3 u4 u5 u6 u7 u8
request	REQxxx...	x y z r1 r2 r3 mag amag
ucon	(not implemented)