![]() In a PTC Mathcad worksheet, click where you want to insert an Excel component.There are a few ways you can get the data from the spreadsheet to PTC Mathcad, but in this example we’ll go with the Excel Component approach because I want my data displayed in a nice table. Because it is connected to the related values in Excel, it will automatically update the rest. Once set up, I will be able to type a single ID value into the worksheet. ![]() This is where the Mathcad-Excel integration comes in. Why not just leverage the work that’s already done, and save as much time as possible? Using Values Already in Excel But, I already have a database of numbers in Excel format. ![]() ![]() If I were to update this worksheet manually with the dimensions of another cross section, I’d have to type in a few numbers, which takes time. The cross section of the beam can be seen in the image below:Ĭross section of a beam shown in Mathcad software. Say I have a worksheet that performs some basic engineering calculations like the reactions, shear, and moment as well as the deflection of a simply supported beam subjected to a force. Here’s one of my favorite use cases with the math software– and tips for setting it up. There are many ways to use the Excel integration in Mathcad to your advantage.
0 Comments
Leave a Reply. |