Defining Excel outputs for use above the Excel file in the Mathcad worksheet

Question

I'm writing a report in Mathcad Prime 11 and have an Excel file as appendix at the end of the Mathcad worksheet. The Excel file has been generated from within Mathcad and uses inputs defined in the body of the Mathcad worksheet.

What I would like to do is globally define an output from the Excel file so I can use/reference it in the body of my report higher up in the worksheet than the Excel file.

I have no problem defining an output and using it in the worksheet BELOW the Excel file, but I would like to know if there is some way of defining an output and using it ABOVE the Excel file. Is this possible?

Thanks

Werner_E · Answer

For a calculation results to be defined via a global definition, ALL involved variables and intermediate calculation results must use global definitions.

Usually that's quite uncomfortable or even impossible to achieve.

In case of the Excel component an additional hurdle is that this component seems to be implemented in a way not allowing for global definitions - neither inputs nor outputs.

So what you are trying to achieve seems not to be possible to do with Prime.

One way which I could imagine is writing the results to a file at the end of the sheet and read them in at the top. Drawback of this method is that you would have to let the whole sheet recalculate to get the correct current results at the top.

Simple example

I am not sure if using the Prime API with Output assignments and a scripted component at the top would also be an option.

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