Shapes Spreadsheet

• The Shapes spreadsheet is (above or left of) the blue splitter bar.

• Each row of the Shapes spreadsheet contains a parameter for each shape in the Shape A Shape consists of two or more measured or calculated values at Poitn & directions on a structure or acoustic surface. Specific types of shapes are an Operating Deflection Shape (ODS), mode shape, acoustic shape, and Engineering Data Shape (EDS). Shape components can be Translational, Rotational, or Scalar. For correct shape animation, all shape components must have correct magnitude & phase values relative to one another. Table.

The Shapes spreadsheet contains the following columns;

• Select Shape button

• Frequency (or Time)

• Damping

• Units of frequency & damping (or time)

• Damping (%)

• Label

• Date/Time

• Color

• Shape color (used during animation if Animate Using the Shape Color is checked on the File | Shape Table Options Animation tab)

• MPC MPC is an Acronym for Modal Phase Colinearity. The MPC has values between 0 & 1. If MPC = 1, all of the components of a shape lie on a straight line in the complex plane. If MPC < 1, the components do not lie on a strraight line. Lightly damped structures normally have mode shapes with MPC's close to 1. (Modal Phase Colinearity)

Spreadsheet columns can be re-ordered by dragging and dropping them into a new position.
Selected spreadsheet rows can be moved by executing Move Selected Shapes Up/Down

Showing & Hiding Spreadsheet Columns

• Right click on the spreadsheet and execute Show/Hide Columns from the menu.

The File | Shape Table Options box will open displaying the Show/Hide tab, as shown below

• Check columns to show them, and Un-check columns to hide them, and click on OK.

Reset Spreadsheet Column Widths

• Right click on the spreadsheet and execute Reset Column Widths from the menu

Re-Ordering Spreadsheet Columns

• Click & drag the column header to move a column to a new position

Spreadsheet Vertical Scrolling

If a vertical scroll bar is displayed on the right side of a spreadsheet,

• Click on the spreadsheet and spin the mouse wheel to scroll the spreadsheet vertically

Spreadsheet Text Size

• To change the text size in a spreadsheet, click on the spreadsheet, hold down the Ctrl key, and spin the mouse wheel

Cut, Copy & Paste Text

• Select one or more spreadsheet text cells

• Hold down the Ctrl key and,

• • Press the X key to cut the selected text to the Clipboard

  • Press the C key to copy the selected text to the Clipboard

  • Press the V key to paste text from the Clipboard into the selected cells