This Excel template provides some basic automation tools for Mathcad, and does not require any additional programming or installation from the user.
Example Worksheet.mcdxbundled with the release shows what an alias list might look like.
OutputsTablefor each enabled row in
InputsTablefor each alias and iteration.
OutputsTable. This operation could take a while.
All tables in this template are true structured tables. I highly recommend using right-click operations on tables in order to change their size.
MCOutputsTable- Show the inputs and outputs defined in the Mathcad worksheet after running
Read Mathcad Worksheet. Allows for some granular control.
Alias- Name of variable define in Mathcad.
Value- Existing value of the variable in the worksheet.
Units- Units of the default value.
Units2- Units of the column in the iteration table.
1for enabled. Boolean value to enable the column in the iteration table. Disabled inputs will use the default value and units listed for that input. Rows that are enabled must have a corresponding column of the same alias in
Status- Displays error messages. They appear in the order below, as only one is shown at a time.
Units2. The default units cannot be used if the row is enabled, but they can be manually copied over.
IterationsTable- Where you store information about each iteration. The ID and Description are for your information only. They do not influence calculations, and additional columns may be added to your liking.
InputsTable- Where input data is stored for each iteration. You may include more columns than there are inputs/outputs designated in the Mathcad worksheet, since the
MCOutputsTablecontrol which are enabled.
This tutorial walks you through an example Mathcad worksheet bundled with the release download. Begin by opening the downloaded Excel file.
Example Worksheet.mcdx, which comes bundled with the release. Double click on the worksheet or single click, and then click Open.
OutputsTablewill remain as-is.
MCOutputsTable. This shows all of the designated inputs and outputs of the worksheet, their current value, and units. Note that
InputsTablehas been prepopulated with
20iterations of values for
|v2||2022-07-29||Licensed into public domain.||Download|