Search results for query: *

Thanks, Andy. At your suggestion I asked the same question of the titanium information group. I'll post again if I get any information of interest. regards, Chris

I have been asked by a colleague for hardness / tensile correlations for Ti alloys, particularly Ti-6Al-4V. In theory this alloy class could be as amenable to this type of correlation as steels, (see eg. thread330-24069). But I have not been able to find any data. Any suggestions?

I assume that you are already familiar with the Analysis ToolPak Add-in that comes with Excel as standard. What is missing from this that you require? There are quite a few sites for free Statistical add-ins, but they tend to address different needs. The following sites should be of general...

I agree that pivot tables might be your best bet, but you may also find that array functions have more flexibility. There is a general discussion in thread770-6411, and I addressed a similar problem to your own (as far as I can tell) in thread770-62429. The downside to array functions is that...

Seems like my last post killed the discussion - sorry about that! Anyway, anyone interested in this matter might like to know that there is a half-day session at ASM's Materials Solutions 2003: "Developments in Web-based Materials Property Databases V" (Pittsburgh, 15 October 2003)...

The R6 defect assessment method is alive and well, and after the split of the CEGB was maintained by staff at Nuclear Electric, now known as British Energy Generation Ltd. I think the main centre for continued work is at British Energy, Barnwood, Gloucester, UK. Some elements of R6 were...

Some aspects of this request were also addressed in thread330-60518, which you might like to see. ESDU in the UK is usually the best source of data on these steels, but you need a subscription to use it. http://www.esdu.com Probably the best approach would be to do a limited amount of...

LINEST should be fairly robust, perhaps it is worth asking a few basic questions: 1. are you regressing Y upon X in both cases? (the inverse of the slope of X upon Y is not the same as the slope of Y on X) 2. are there any transformations in your plot? (The exponential function trendline may...

Thank for your suggestion Lalbotros. I tried your suggestion "Data / Get External Data > / New database Query" but got stuck looking for the ODBC source. Maybe they are not present in Excel 97, or possibly not installed by our IT department. I will try to follow it up! Your point...

ESDU would be a good source for such data, but you need to be members. http://www.esdu.com

Ken thanks for the helpful reply. I suppose my overall point is that without either the supporting metadata, or your explanation, then such data from this source and potentially elsewhere on the net have to be treated with some caution. What I would hate to happen is that, unwittingly, someone...

kenvlach as you suggest the site, can you help me interpret some of the fatigue data at: http://aluminium.matter.org.uk/aluselect/08_fatigue_browse.asp If you select Alloy: 7075, and Temper: T6 you get a table with a range of Applied Stresses (presumably stress amplitudes) for the same Cycles...

Nothing by that name in Stahlschlussel or Woldman's. (NiCroMo W and similar names exist, though).

According to Stahlschlussel (1995), the minimum RT Charpy V properties for the 1.7147 case hardening steel should be 34J and 34J for 11mm and 30mm section, respectively. These values are identified as "after case hardening, in core". Clearly, the values of your actual material may...

I have been involved in company material databases for gas turbine applications for a few years, and my first comment (born of experience!) is to try to provide what is really required and not what is "nice to have". I think that your list is a great start, and with comments from...

After some further advice from a colleague, it seems that Problem 1 is best solved using Array functions, further details in the thread thread770-6411. It seems that the crux of Problem 2 is the use of LOOKUP functions with the Solver. Has any one else had this problem, and found a solution...

IJR mentioned a web site that described the use of array functions, but said he had forgotten the link. The following link to John Walkenbach's site gives some further examples and a fairly detailed explanation. http://j-walk.com/ss/excel/tips/tip74.htm I have recently found them useful to...

Another method you might consider in future is to use the Advanced Filter (Data > Filter > Advanced Filter). By selecting the options "Copy into a new location" and "Unique records only", you can extract only the unique rows from your original data.

Hi all, I have a recurrent problem in using database functions such as DGET, DMAX and DAVERAGE. These are very useful for processing data from a data logger. For example, I can calculate summary statistics and even fitted equations to subsets of the data. (Some of this I can do with Pivot...

I would tend to agree with plasgears that you introduce a lot of uncertainty into your calculations if you want to use literature values for a calculation on such a safety critical part as a pressure vessel. You would probably want to look at material from your supplier in the condition used in...