Here it is hope it works!http://files.engineering.com/getfile.aspx?folder=c8763643-15f9-41a6-aa79-e00766725bc7&file=using_or_and_functions_together.xlsx
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...
StucturalEIT,KBVT
Thanks for your replys!
Would either of you have any refferences/examples to a case simialiar to this? I have several sources but each one has examples of columns placed directly in center of slabs. By the sounds of it I have been overly concervative over the years.
Clansman
The attached word file is as follows:
For a 10’ x 10’ x 30” slab on grade with column centered on slab the one-way shear strength is:
Ultimate vertical load from column: Pu=500k
?Vc= ?2??(f'c )*bw*d
Clear Cover = 3”, Rebar = #8’s, ?=0.75, bw=120", ?=1, f'c=4000psi, d = (30”-3.5”) =...
Just to make sure I understand.
1. So if the distance from face of column to edge of concrete is less than d the shear check is neglected on the faces of the columns that fall less than d from the edge?
2. Even if the column is located at the corner of the slab assum the Pu is distrubuted...
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...
Steve1, JoshPlum
How would you model a slab/footing in risa (spring constants,plan restraints, plates vs solids....) The models I've been comparing using a 2' thick square slab just don't seem to compare. What I am trying to do is eliminate doing the check by hand (save time) but first need to...
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...
NS4U-
I do not have access to the ref. you have stated at this time but I will work on that! Have you seen the ASCE publication "Wind Loads and Anchor Bolt Design for Petrochemical Facilities"? If so what is your take? Over the years I have used this publication as a guide to take the pedestal...
