Hello, I am trying to use the and, or functions together but the results I am getting from my formula are opposite of what I need. Basically if any combination of cells B4-B7 taken 3 at a time is less than 1.5*B3 its true otherwise false. In my case its true but my formula is saying false. Some...
I have attached the excel file in question. Basically I have two input values which are the yellow highlighted cells and would like to use formulas to calculate needed value (ie. ks) The cells highlighted in red are the cells I am trying to enter an equation to look up values in the table. I...
The attached document is an example of how I check wide beam/one-way shear. As shown the column is centered on a square slab on grade so its straight forward check.
I now have a situation where a 30"x30" column is on the corner of the slab. (From the North face of the column to edge of slab is...
I have been looking into using table 4-12 in AISC 13th Ed. Does anyone use this? Seems a bit conservative but I would like to get other opinions. I have a truss modeled up using Risa. The diagonals in the truss are single angles. Taking member forces from my model I looked in table 4-12 to...
In load combinations E = Ev + Eh. All our designs have been Cat. A so per code i've been able to ignore the Ev values. Per the inspector we are required to design as a Category B for this particualr site. Per ASCE 2005 12.4.2.3 the Ev value is accounted for in the factor on DL. My question is...
I am trying to use the Hlookup function in Xcell and I'm haveing trouble. the lookup value is from a cell that used the roundup function and it keeps giving me "NA". I did the same formula using Hlookup with the round down function and it works perfect. Can anyone shed some light? I have...
I am Wondering how others use Risa for doing frequency checks? I compared Risa frequency with hand calc frequency and the two were not comparable. I have tried a few different modeling techniques as listed below.
1. One model I used a sub meshed plate and assigned each node a spring constant...
I am designing anchors embedded into a 2' square pier. The pier has eight vertical bars evenly spaced 3" from the perimeter. I consider the vertical bars as supplemental reinforcement and ignore the concrete breakout check for tension since it doesn't govern. I was wondering about the Ncbg...
I have been told when designing girts with sag-rods that the girts can be considered laterally supported at the location of each sag-rod. I am unable to locate any technical data or examples to reference. If I were to design the girts without assuming lateral support from each sag-rod the girt...
