Search results for query: *

Aviat,.. . THANKS A MILLION!!. I cant believe it was that simple!! nice one!!

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...

Rich2001,.. thanks for the link. I suppose I better join the AISC!! I've been putting it off too long!! P

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??

Alohabob said "check deflections". My question is: What is the criteria for the deflection of a post or guardrail??. I know we all have our "comfort" levels. But when it comes down to rejecting the rail design (we don’t design it, but as the SER we check it), I can't, in good faith reject it on...

I always draw the moment diagram on the tension side so I can instantly identify the tension side, and see which way the members will bend toward. It’s really helpful for identifying the deflected shape. I feel this method intuitively goes hand-in-hand with concrete design, where you don’t...

I would think of it a different way. Imagine that the brick runs the full length of the wall. (lets take your 30ft wall). When your 30ft wall is deflected to L/720, your maximum allowable deflection is at the midspan, and is 0.5". This 0.5" is at 15ft. Now, while the stud is deflected...

OSHA !,.. I didn't think of them!,.. thanks

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...

Thanks all, As usual, you have been a great help. ..Paulaup

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...

People whose boss’s send them on such a course should worry!! It says your boss thinks they lack the essential skills to work there and had better learn them fast!!. Scary stuff!! I agree that while Dale Carnegie made some good points throughout his life, he has cast a serious doubt on his...

IRstuff, ...thanks!!

Thanks all, foir your help. I've really learned a lot

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...

Thanks to all. That vlookup is cool!! I think for my particular application the "ceiling" comand is the perfect. I never heard of it!! thanks again.

thanks Cowski, That worked for two conditions. How would I do it for more than two conditions, i.e. C82<1.5, C82<1.75, C82<2 I looked up the AND and OR, but it seems that they only give for thwo conditions?? Anyone have any thoughts!!!

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 &quot;use a 1 inch base plate. Ive got this far, and...

jheidt2543, Thanks for your response. All those reasons make sense, but if I floated the slab, what would brace the top of the wall? Maybe it's something abvious, but I'm not seeing it? In some cases the dead weight alone would probably be enough, but in a one story building with only roof...