Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Material Proerties (1 viewing) (1) Guest
You can request specific calculations in this area. Hopefully someone in the ExcelCalcs community can help.
Go to bottom Favoured: 0
TOPIC: Material Proerties
#268
DaveC (User)
Froglet (Expert Boarder)
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Material Proerties 11 Years, 5 Months ago Karma: 4  
How about starting a material propety database?...Possibly a big task for a single person to complete but if a number of people upload contributions (complete with references) it could grow into a sinificant resource.
 
Logged Logged  
  The administrator has disabled public write access.
#323
InfoJunkie65 (User)
Industrial, Manufacturing, Mechanical, Structural
Frog Prince (Platinum Boarder)
Posts: 57
graphgraph
User Offline Click here to see the profile of this user
Gender: Male MiScion Location: Adelaide, South Australia Birthdate: 1965-07-29
Re:Material Proerties 11 Years, 3 Months ago Karma: 7  
Good Idea. But what format. I have structural sections database in Access which are then linked into an excel workbook, which is then usde by other workbooks. In QPro I simply used lookup tables directly into a paradaox file. Excel seemed to have problems with that.

Then using lookup functions into the sections properties database became to cumbersome for some tasks, where want multiple sections in the one workbook. So I wrote VBA functions which use DAO to obtain data direct from Access and return the results I want such as phi.Ms, without the need to display all the section properties and intermediate calculations involved in calculating effective widths and effective section properties. Get the value I want more direct.

The reason for using Access/Paradox is that they provide for easier management of the information. And more consistent application of formula. An excel table may have inconsistent formula in it but a calculation applied to each record of a database table is more consistent and easier to do.

Another problem is units of measurement. What units to use as the base? That is one set of units needs to be used as a base any other set can be presented as a conversion. Once again potentially more reliable and easier to do using Access/Excel/VBA combination.

What data structure to use, fields and properties to be collected? How many databases or tables to be used? One for UK sections, one for US, and one for Australian as many of the structural analysis programs do?

And use separate or single database for actual materials and the structural sections? Some structural sections only available in a given grade and type of material in some places. In others can get any material grade want for a given section.

So that in some places there is a clear distinction between sections and materials, in others they blurr together.

As do other ideas with time. My original database and excel workbook are no longer synchronised due, to differing versions of excel and access around the office. Further the excel workbook also now contains materials and section properties, cladding weights and spans, and load capacity tables for cold-formed sections. And have several versions in operation, due to different users needing additional sections. Eventually they get synchronised, then they diverge again.

So yes its a good idea. So what materials and/or sections do you want to start with?
 
Logged Logged  
  The administrator has disabled public write access.
#324
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1773
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Material Properties 11 Years, 3 Months ago Karma: 494  
My take on this is other website are already concentrating on this matweb being the one that sticks in my mind. There are other good material resources too. So by all means let's use the forum to guide users to good resources but let's concentrate on developing and sharing solved problems in Excel and try to keep true to the mission statement "ExcelCalcs will build the web's largest repository of solved problems using the world's most popular mathematical software tool (Excel) and make it available to the world for free."
 
Logged Logged  
 
  The administrator has disabled public write access.
Go to top
We have 5 guests and 38 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Real Time Analytics