Tabular Display

Results Postprocessing > Freebody Plots > 12.6 Tabular Display

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX''">XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX''">

12.6 Tabular Display

The Show Spreadsheet icon on the Freebody plot tool accesses a spreadsheet.


	Pressing this button icon makes the freebody spreadsheet appear.

This spreadsheet will fill itself with result values for each node that has a vector plot summarizing the loads or displacements whether they be internal, reaction, applied or other. It also summarizes the totals for equilibrium checks and other purposes. Only the nodes of the currently displayed freebody plot will be reported in the spreadsheet. Also the spreadsheet will be cleared and redisplayed each time a new plot is created. You may bring up and close down the spreadsheet and the data will remain intact until a new plot is created.

The labels on the spreadsheet above will change to displacements when the Forced Displacement method is displayed.

The totals for each component are reported at the bottom of the spreadsheet. When Freebody Loads are plotted on the graphics screen, these totals should be zero (equilibrium should exist). If not, then other unaccounted load contributions must exist, such as those from rigid element, MPCs and externally coupled stiffness matrices. You may also click the mouse on each cell to get more detailed information in a text box below the spreadsheet. Also if the Method is set to Interface Loads, contributions from all nodes specified as target entities will be displayed even though graphically only the summation point displays the vector plot.

A Report button is also available from this spreadsheet that will write its contents out the a file called <db_name>_freebody_data.dat where <db_name> is the name of the database.

A special utility PCL function can be used in conjunction with the freebody spreadsheet to interact in almost any way imaginable. If you define the function below and compile it into Patran with a!!input <function_name> before the spreadsheet is opened, then anytime you click on a cell in the spreadsheet this call back function is called. Please see The PATRAN Command Language (PCL) Introduction (p. 5) in the PCL and Customization for details on how to program in PCL.


freebody_spreadsheet_cell_cb	(spreadsheet_id, textbox_id, segment_id, from_column, from_row, to_column, to_row)


Description:
This is a call back function that is called anytime a cell or group of cells is selected in the freebody spreadsheet. The arguments to the function are all inputs supplied by the callback function of the spreadsheet. The function must be defined by the user and compiled into Patran before the freebody spreadsheet is opened. The contents of this function are left up to the user’s imagination.
Arguments:
widget	spreadsheet_id	This is the widget ID of the spreadsheet. Knowing the widget ID you have full control over it and can make modification to the spreadsheet such as adding or removing rows or columns.
widget	textbox_id	This is the widget ID of the textbox on the bottom of the form under the spreadsheet. Knowing the widget ID of the textbox you have full control over it such as adding and removing text from the textbox.
INTEGER	segment_id	This is the graphics segment ID. Knowing the segment ID into which the freebody plot has been graphically written (the vectors and labels) you have full control over them such as deleting, modifying or adding to the graphics already in that segment.
INTEGER	from_column	This is the first column in the range of selected cells from the spreadsheet.
INTEGER	from_row	This is the first row in the range of selected cells from the spreadsheet.
INTEGER	to_column	This is the last column in the range of selected cells from the spreadsheet.
INTEGER	to_row	This is the last row in the range of selected cells from the spreadsheet.
Example
	A good example of usage of this PCL utility is the highlighting of nodes when a cell or range of cells is selected. For example, say that you wish to know graphically which node a particular value in the spreadsheet referred to. Although the node ID is indicated in the spreadsheet, with a little programming, a user could create a function that when a cell or cells are selected, the corresponding node(s) is/are highlighted graphically on the screen.