Search results for query: *

Does anyone know how to display rows (say rows 1,2, and3) at top of page even when I scroll down?? I've seen it on other spreadsheets, but I have no clue how to even search for it. Any help is greatly appreciated Thanks

I'm having real trouble with this! I have a basic combo box with a list of 7 items from a materials table, with a link to cell A7. I also have a vlookup function that pulls from a table coresponding to the value selected in cell A& (combo box). The thing is this: When I select a value from the...

Does anyone know where I can get an excel speadsheet that already has steel section properties typed out. I want to set up a lookup table, but I havent got all year to do it. Does anyone know if the AISC has it??

Often, as the structural engineer of record, we have to check other Engineers calculations. e.g. guardrail and posts. I usually adopt a deflection limit of L/180, for the cantilevered post, but I cannot find a definite deflection limit in any code for posts and guardrails. Deflection limits...

I've heard about lookup tables and people say they are very powerfull. But I haven't a clue how they work or how to write the syntax?? I want to select a beam size from a drop down box on one sheet. When I select that beam size, I want certain cells to return the properties of the beam. I have...

Hi, I was wondering, is there a log, where I can check when my computer was accessed?? Something that would maybe tell me when the comp[uter was logged on, and logged off? I've been coming into work a little later than usual, and I suspect that someones been on my computer while I was not here...

Hi, Im not an experienced excel user. Im trying to set up an equation that will round up the baseplate thickness value in the cell to a value more practical. i.e. when I get a thickness of .083inches, I would like the cell next to it to read "use a 1 inch base plate. Ive got this far, and...

In our office, we usually like to tie the top of foundation walls to the slab on grade. We usually cast the slab over the foundation wall and add rebar dowels. Some Architects don’t like this detail because it conflicts with the energy code. They sometimes ask us if they can float the slab. i.e...

what are its uses??, can the stiffness of a connection be found from this. I remember something from college about this.

I have a reinforced masonry tower (10’-0” x 10-‘0”) within a building space (isolated from the building with expansion joints). How do I calculate the deflection of the tower due to seismic loads?? I want to ensure that when the tower deflects, that I have enough of an expansion joint between...

I use CAD 14). I have a drawing, two adjoined buildings. One of the buildings is orthogonal (in plan), the other building is skewed at 24 degrees to the vertical. TO work on the skewed building I have to go to UCS and pick "object" and click on a line rotated to the building skew, so...

I have an old building to evaluate. Anyone know what was the strength of steel they used in 1957. I usually take an allowable of 20ksi, but I'm fairly close to the limit. Anyone??

I am a structural Engineer from Europe (new Euro code many symbols!!). I now work in the US. Designing in metric and converting to English units is not worth the hassle, because of all the design variables, and symbols. Can anyone reccomend a good masonry/CMU design book. One preferably that...

in the case of a strip footing for a CMU wall (the wall is actually non-structural) What are the pro's and cons of using 5000psi grout instaed of using concrete. Is it possible to use it and reinforce it in the same manner as concrete. Are there bond issues between the bars and grout? Are there...