cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

steel database

nanasei
1-Newbie

steel database

Hi guys, I have been trying to read data from a an excel component I inserted in my MATHCAD document containing the AISC steel sections. I am new to MATHCAD programing and have not had any luck with this although everything I have seen so far seems easy. Can someone take a look at the attached file and correct it for me?

7 REPLIES 7

If you define a function with two arguments, you need to pass it two values when you call it.

Look up the threads "Excel data base extraction" (findable with the keywords "aisc steel shapes"). They may provide a better solution for you.
__________________
� � � � Tom Gutman

Thanks very much Tom. I was able to locate the file you mentioned but When I select a shape from the list boxes it still shows up as "undefined" for all the properties below. I thought the MATHCAD file will already be linked to the excel files in the Zip Folder. Am I suppossed to build upon what you have already started or it should be a fully funtional program? Could it be I need to redifine some path names?

Nanasei.

It should be a fully function program, but you do need to create the proper environment.

AFAIK the zip "folders" in NT are not folders at all, but just files. The Windows explorer has special support for such files and displays them as though they were folders. If you try to pass a file within such a pseudo folder to some program (such as the execute command) that file is extracted into a temporary location and that copy is then passed. Files in such a pseudo folder are not visible to the file system.

So you need to extract the contents of that zip file into a folder (you can do that with the explorer copy function, just drag and drop). You should have the Mathcad file and the subfolder in a folder, and the XLS files in the subfolder. The only path you should have to change is the name of the subfolder with the data files, and that only if you change it from what is in the distribution.
__________________
� � � � Tom Gutman
jobregon
6-Contributor
(To:nanasei)

I use for this choose a WebControl - List box

See please one example (one WebMathcadSheet Thermal conductivity of metals with Mathcad Cloud functions)

http://twt.mpei.ac.ru/MCS/Worksheets/Thermal/T-T-2-Tab-3-04.xmcd

Age.png

jobregon
6-Contributor
(To:ValeryOchkov)

Yes, I used that (or something similar) also, but I prefer MC Sec.

I can use many "extra functions" additionally to just the database, also the peace of mind of getting correct values.

Announcements