Extracting data from Excel Table

Question

Hello All,

I'm trying to convert excel sheet formula into Mathcad.

Example, I want to extract P/N No. from the excel table.

Stud dia and Load is the input variables.

Nominal Size is the stud dia.
Once stud dia is entered remaining rows with different nominal size is ruled out.
Then compare input load value against excel sheet min and max load.

Load value should be more than the Min load value and near to maximum load in case of multiple variables.

If load value is not available in the Column 2 and 3 then same steps will be carried for parallel min and max load (column 4 & 5).

Same concept was followed in excel sheet calculation. Now I need help in making calculation in Mathcad file.

Can you please help me on this problem.

terryhendicott · Answer

Hi,Have changed the excel file to a later version necessary to read the data from the Excel file rather than use the Excel component.Each stud diameter seems to have a L, M, and H versions.  I would expect the load capable of being carried increases from L to M to H.The data in the Excel file seems to be inconsistent with this so needs to be checked. Sorted the data on the max load per stud column to get them in increasing order. I assume max load varies depending on how many studs in a group. In the excel column for parallel max load is twice stud load?  Should this actually vary with number of studs? Enclosed is sheet that chooses studs based on load to show you how to do it. CheersTerry

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded