Recent content by FC2008

Hi, Quick question: What types of sand do usually go through a oil pipe? Thanks.

Hi, When I import an assembly into Ansys, it automatically creates connections. (I make sure that the setting under: Tools > Options > Connections > Auto Detect Contact on Attach is set to "Yes".) Next I change the names of the connections so that they are renamed based on definition. I now...

Hi, KD-621 in VIII Div.3 states that: - The average primary stress intensity based on the root diameter should not exceed: 1/1,8 * S_y. - The primary-plus-secondary membrane stress intensity: 0,75 * S_y - The primary-plus-secondary membrane plus bending stress intensity: S_y Say that I am...

That worked really well guys, thank you very much. Nice way to start off the week :)

I don't think that's possible when using Validation..

Hi, Here's what I'm working with: http://i163.photobucket.com/albums/t282/Calc_photos/ExcelHelp01.jpg I have made a list of the different temperatures using Data>Validation. Using vlookup I've connected the temp with the yield stress values. I would like to hide the grayed out values. How can...

I think I will just do as you say electricpete, the users should be able to figure that out :) Thanks for the suggestion iken.

Hi, I've made a list using the Data>Validation tool. I was wondering if it was possible to make the drop-down icon (downward facing arrow) visible when the cell is not selected. Thanks.

Both your suggestions are working beautifully! Thank you very much

That stuff works great! Thank you very much

By the way, how did you do it?

Hi Clyde38, that looks great! Is it possible to use a drop down, instead of the thing you use? If not, this is still great. Thanks!

Hi, I have not used AutoFilter before, but a quick look at it tells me that it is not what I'm looking for. I would like to have the small database on a seperate worksheet, and have the drop-down on another sheet. I do not think this can be acheived using AutoFilter. Thanks

Hi, I have made a small database of different material types in excel. First column contains the name of the material, and the other columns are material properties. I would like to make a drop-down list where I can choose a material and have excel automatically give the material properties in...

Hi, I have a bit of a dilemma. Say I have a section of thick-walled pipe with two blind flanges that is to be pressurized to 22,5k psi. I now want to penetrate the pipe wall so that I can add an instrument. The instrument consists of a flange that has a hole in the middle. I want to take a...