How can I implement this on MathCad?

[FP_14491595]

Hi, it was requested on my company to focus on Mathcad for calculation of new designs.

It is a great tool, but how can I replace Excel in a inductor design like the image attached?

Where I need/can see the different designs all together to evaluate them.

Here we use Mathcad Prime 10.0.1.0.

Thank you for the support.

[terryhendicott]

Hi,

Use an input table to enter inputs,

Use a matrix to show inputs and calculated values.

Like this.  You actually  get the units in Mathcad.  The columns of the input table are variable names for a column vector of values.

To display it identical to the spreadsheet.

Create a matrix by augmenting all the column vectors, Then transpose the matrix

If the spreadsheet is not propriety can you upload it so this can be shown?

Cheers

Terry

[FP_14491595]

Sure, it is just inductor formulas as example. I removed any information not needed from it.

[FP_14491595]

Thank you Terry!

Which version of Mathcad you used to save the file?
Asking because I could not open on 10.

[terryhendicott · Accepted solution]

Here is version 10

[FP_14491595]

Can I add formulas inside the table somehow?

Because for each line I will need to calculate the dc bias, flux, etc..

[Werner_E]

A table in Prime is just meant for manual input of values.

When you use a Prime table you are actually defining just a couple of vectors.

Using

does the very same as

After the values are input you can use the created vectors for calculating other values, like

Note that vectorization (the arrow over the expression) is mandatory here as otherwise Prime would calculate the dot/scalar vector product.

After you have calculated the desired values you may collect them in a matrix. Prime offers no other native way of displaying results in a compact way.

Prime forbids to change the units inside of a matrix, so we cannot change volt to kilovolt.

A way around this is to make the values dimensionless by dividing by the desired units

and it sure is a good idea to add a header line on top

and maybe a row header as well

If you really need a nicer display of your results you would have to embed an Excel component in your sheet.

The drawback is that it blows up and slows down your worksheet as the Excel sheet is embedded in your Prime sheet and Excel has to be loaded to display and edit it.

In the example below I used table3 to create an Excel component, double clicked it (Excel should come up) and formatted it in Excel as a table. You now have all of Excels formatting capabilities at hand to display your results in a nice way, may use conditional formatting, etc. and still can use Primes mathematical competence and its ability to handle units for your calculations.

P.S.: Actually you CAN use formulas in a Prime table, but not as you would expect. Write the formula in the first row of a new column and leave the unit placeholder empty. Sure is not looking the way you would like it to.

Prime 10 sheet attached