This tutorial demonstrates the assignment of complicated joint patterns using interactive database editing. The process outlined below will follow the development of a model where coordinates are a function of the global Z-axis.

Joint-pattern assignment using interactive database editing proceeds as follows:

  1. Define a new joint pattern through Define > Joint Patterns > Add New Pattern > Name.

  2. Select Edit > Interactive Database Editing, then select the two tables listed below, as shown in Figure 1:

  3. To open the Joint Coordinates table in Excel, select OK, then select the Joint Coordinates table from the scroll-down menu, then select the To Excel option. The tables will be presented as shown in Figure 2:

    Figure 2 - Joint Coordinates

  4. Save the Excel file, then in this saved file, create a new column for the joint-pattern values. Specify the values as a function of the Z coordinate for each joint.

  5. In the Interactive Database Editing menu, select the Cancel Excel option.

  6. Select the Joint Pattern Assignments table in the scroll-down menu, then select To Excel to open the table in Excel. From the previously saved Excel file, copy and paste columns, including joint labels and joint-pattern values, to this new Excel file. Select From Excel > Done to update SAP2000 database tables, as shown in Figure 3:

    Figure 3 - Joint-pattern assignment

  7. Finally, select Display > Show Misc Assigns > Joints to graphically review the joint pattern assignments, as shown in Figure 4:

    Figure 4 - Assignment review

    The area load assigned to each joint may also be displayed by selecting Display > Show Load Assign > Area Surface Pressure Values.