October 26, 2010


How to Use Spreadsheets More Effectively in RISA


RISA includes various advanced spreadsheet operations that make reviewing input and results easy.

The features that we will focus on are available in the "Spreadsheet" tab located in the ribbon toolbar whenever a spreadsheet is open as well as by right-clicking in the table.

Spreadsheet 1a

P-Delta analysis is required in the AISC code, and it is something that you must specify on a per-load-combination basis. This is done by typing the letter Y in the P-Delta column of the Load Combinations spreadsheet. For those who aren’t familiar with the spreadsheet tools this can be a tedious task of typing the letter into every load combination.

Instead, try doing this: click on the header of the P-Delta column to highlight the entire column in pink, click on the Block Fill button (the one on the right highlighted above) and have the program fill the block (group of currently selected cells) with the letter Y.

Spreadsheet 1 Spreadsheet 2

Now let’s say that you’ve got a solution and you want to review your results, however you may have quite a few members to sort through. You want to quickly see which one has the worst case unity check.

If you open up your Design Results spreadsheet you will be confronted with a large amount of data. Click on the header of the UC Max column to highlight the entire column in pink, then click on the Sort button (the one on the left highlighted above) and have the program sort that column Max to Min. You will quickly see which member controls your design, and by how much.

Spreadsheet 3 Spreadsheet 4

Tags: RISA-2D RISA-3D RISAFloor RISAFoundation Spreadsheets Data Entry

You may also be interested in

Nov 8, 2018 | Tips & Tricks
Mat Slab Overturning and Sliding Safety Factors

RISAFoundation v11.0 includes two new tabs in the Safety Factors resul...
Read More

Aug 21, 2019 | Tips & Tricks
RISA-3D v18 Sneak Peek Videos

The new release of RISA-3D is right around the corner! Check out our t...
Read More

Jul 12, 2019 | Tips & Tricks
Implementing Realistic Behavior for T/C Members in RISA-3D

Tension or Compression (T/C) Only members are commonly used in steel b...
Read More

Jun 20, 2019 | Tips & Tricks
Understanding Wall Panel Forces with Rigid Diaphragms

Rigid diaphragms represent a plane of very high rigidity and distribut...
Read More