This is the procedure we've come up with for use with honeycomb panels, so insert/modify verbage to correspond with your application.
Unigraphics Point Table Procedures
1) –A model 3D setup
a. Place components of details as required.
2) –AD model 3D setup
a. Place component of –A model into 3D workspace of –AD model. Orient component with WCS in absolute position so axis is at datum point and XY orientation is same as defining drawing view.
3) Insert location point placement
a. Choose ‘assemblies-wave_geometry_linker’ from pull down menus and add points for use in generating table(s) in no particular order in 3D model space of –AD model. Locate points on penetrating side of panel. Layer points as appropriate 154 near side inserts/155 far side inserts/156 thru inserts (point placed on near side). Color points as appropriate for fastener size.
4) Insert location point attribute renaming
a. Choose ‘format-attribute-name-assign_name’ from pull down menus. Pick all the insert location points in order of naming, type ‘PT’ in first dialog box, then type starting number (with new drawing this would be number 1) in second dialog box. NOTE: Choose ‘information-object-type-point’ in pull down menus to verify point naming is correct.
5) (Optional step) Add insert labeling in views
a. Move into appropriate expanded view. Choose ‘file-execute_UG/open-grip’ from pull down menus. Choose program S:\griplib\source\grip\main\khardypointname.grx. Choose point and indicate text location as applicable. NOTE: Text placed in expanded view will need size adjustment to compensate for view scale (i.e. text would be 4X normal size for ¼ scale view). Move out of expanded view.
6) Point filtering
a. Choose ‘format-visible_in_view’ from pull down menus. Choose applicable view. Turn off layers for particular view as appropriate. NOTE: Do NOT ‘blank’ or ‘view-independent-edit’ points. Table program will not work correctly and model could be corrupted.
7) Point table spreadsheet generation
a. Choose ‘tabular_note’ icon from task bar. Choose ‘new table’ icon in dialog box. Excel spreadsheet appears.
8) Table title populating
a. Type ‘table_title’ in a cell row 1 in an unused column. (i.e. AEP1035-3S375 N.S.)
9) Cell text formatting
a. Choose whole field of spreadsheet (upper left corner). Format cells to center horizontally and vertically. Format cells to ‘12 pt’ text size.
10) Title cell text formatting
a. Choose title cell row 1/column D. Format cell to ‘14 pt’ text size.
11) Column title populating
a. Type ‘POINT’ in cell row 2/column A. Type ‘X’ in cell row 2/column B. Type ‘Y’ in cell row 2/column C.
12) Point number column populating
a. Type ‘PT1’ in cell row 3/column A. Type ‘PT2’ in cell row 4/column A. Highlight row 3/column A and row 4/column A. Copy contents of cells to populate as many cells as applicable.
13) 3D model to spreadsheet populating and linking
a. Highlight cells row 3/column B and row 3/column C. Type ‘=POINT(A3)’, then hold down ‘ctrl’ and ‘shift’ keys while pressing ‘enter’ key. NOTE: Populate the two horizontal cells together at same time to make link to 3D model work.
14) Cell decimal formatting
a. Choose all cells containing ‘point numerical values’. Format cells for 3 decimal places. Copy to populate as many cells in cols C and D as applicable.
15) Row height formatting
a. Choose all applicable rows. Format rows to ‘35 pt’ row height. Highlight row 1 and format row to ‘53 pt’ row height.
16) Column width formatting
a. Choose columns A, B and C. Format columns to ‘12 pt’ column width.
17) Title cell definition
a. Highlight title cell row 1/column D. Choose ‘edit-tabular_note_title’ from pull down menus.
18) Tabular note range definition
a. Highlight cells with ‘POINT’, ‘X’, ‘Y’ and ‘point numerical values’ as applicable. Choose ‘edit-tabular_note_range’ from pull down menus.
19) Cell auto-size default setting
a. Choose ‘options-tabular_note_options’. Check to make sure auto-size feature if turned off (no check mark in box).
20) Tabular note filing and generation
a. Choose ‘file-close_&_return_to_tabular_note’. Choose ‘ok’ in dialog box. UG files the spreadsheet and returns to drafting mode. Indicate tabular note location on drawing sheet.
Chris D. Adcock
Mechanical Design Engineer
B/E Aerospace, Flight Structures
![[infinity] [infinity] [infinity]](/data/assets/smilies/infinity.gif)