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