## Generating reports in Word from MathCad calculations

## Generating reports in Word from MathCad calculations

(OP)

Good morning Gentlemen,

I don't frequent this forum much, and I did a quick search but did not find much that related to my question. I use MathCad 11 for completing Seismic Analysis in accordance with the ASME BP&V Code. I have created a template that I input a about a dozen variables into and it will run through about 50-60 equations for me.

I then transpose the results of the MathCad calculations into a Word document that serves as my report. I use Word because it provides a clean mixture of text and equations without having to see what MathCad does (the equation definition and then the equation solution side by side)

My question is: Is there a way that I can export only my results into defined points of a Word document? Like with Excel and Word, you can link a spreadsheet to a document and as you change the spreadsheet it will update the Word Doc. I know it might be a long shot, but I figure it was worth asking people that have more MathCad experience than I do, since I am pretty much self-taught from the Mathcad manual.

If this is not possible, do you guys have any suggestions as to what would be a more effective process? Currently, we are running into issues where there is too much room for error in the transposition of results. Myself or someone else trying to accurately read and re-write 50-60 different numbers can easily get a fit of dyslexia and screw something up.

I don't frequent this forum much, and I did a quick search but did not find much that related to my question. I use MathCad 11 for completing Seismic Analysis in accordance with the ASME BP&V Code. I have created a template that I input a about a dozen variables into and it will run through about 50-60 equations for me.

I then transpose the results of the MathCad calculations into a Word document that serves as my report. I use Word because it provides a clean mixture of text and equations without having to see what MathCad does (the equation definition and then the equation solution side by side)

My question is: Is there a way that I can export only my results into defined points of a Word document? Like with Excel and Word, you can link a spreadsheet to a document and as you change the spreadsheet it will update the Word Doc. I know it might be a long shot, but I figure it was worth asking people that have more MathCad experience than I do, since I am pretty much self-taught from the Mathcad manual.

If this is not possible, do you guys have any suggestions as to what would be a more effective process? Currently, we are running into issues where there is too much room for error in the transposition of results. Myself or someone else trying to accurately read and re-write 50-60 different numbers can easily get a fit of dyslexia and screw something up.

## RE: Generating reports in Word from MathCad calculations

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

Use Word's file import mechanism to link to those files.

http://voices.yahoo.com/how-embed-existing-files-i...

I usually use IFRs's suggested method of putting all of my equations in an Area and collapsing it. However, it may require some work to restructure a worksheet retrospectively and the file-read route may be easier.

## RE: Generating reports in Word from MathCad calculations

Is there a way to sequentially show a solution in MathCad? That's not really the term I would use to describe it, but for example, I have many different spots where I currently have something that defines an equation, and then solves the equation for the report. Example (not really in the report, but easy to visualize)=

"sqrt(a

^{2}+ b^{2}) = c .... Pythagorean Theorem. (a and b are previously defined in the report somewhere),c = XX"

Is there a way to go directly from the definition to the answer without requesting c in the program? Like this:

"sqrt(a

^{2}+ b^{2}) = c = XX"I don't think there is, but it would make it much more simple to present in MathCad this way if I can! I've tried just bolding my solutions, but it bolds every constant/variable in every equation, whether it be a definition or a result.

Sorry for the newcomer questions, I have never used MathCad outside of generic problem solving! And thanks for the tips so far!

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

In your version, how do you do it? If I define an equation, it won't let me hit an equal sign in the same equation. If you can tell me how you do it in 14, I'll try it in 11.

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Generating reports in Word from MathCad calculations

useful for both protecting your intellectual property and for stopping the ignorant from messing with things and then complaining it don't work no more!). However, whilst Areas are definitely useful, they won't allow you to show an equation and result side-by-side but they might allow you to hide a lot of "detail".Mathcad 11, as you've probably found out, doesn't have the inline "c:=a+b=" facility ... I think it was introduced in Mathcad 12 (which, version you fortunately can't get anymore unless you're very unlucky).

## RE: Generating reports in Word from MathCad calculations

Thank you for the explanation, I did discover the usefulness of Areas and collapsing them, though for this report instance it wont do me much good.

So, after 12 they removed the feature to have "c:=a+b=" ?? This program is pretty awesome, but that seems odd. lol

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

Sounds like there is enough information above to do what you want within MathCad directly. In any version back to about V0.5 you can type <cntl>= to put anything you want equal to anything else (and as many times as you want) and it is not evaluated outside a program or a solve block. So

c<cntl>=sqrt(a

^{2}+b^{2}<cntl>=5cmIs perfectly acceptable to the parser. You could put a:3 cm, b:4 cm, c:sqrt(a

^{2}+b^{2}) in a collapsed area and type the answer into your <cntl>= expression. This has the risk that you won't update the hard number if conditions change.I did:

a:3cm

b:4cm

c:sqrt(a

^{2}+b^{2}c=5cmin actual documents for 10 years and did't feel like it detracted much from the people who wanted to follow the math. Getting headers, footers, and pagination right in MathCad is always a challenge, but sometimes it is worth it.

David Simpson, PE

MuleShoe Engineering

"Belief" is the acceptance of an hypotheses in the absence of data.

"Prejudice" is having an opinion not supported by the preponderance of the data.

"Knowledge" is only found through the accumulation and analysis of data.

## RE: Generating reports in Word from MathCad calculations

David Simpson, PE

MuleShoe Engineering

"Belief" is the acceptance of an hypotheses in the absence of data.

"Prejudice" is having an opinion not supported by the preponderance of the data.

"Knowledge" is only found through the accumulation and analysis of data.

## RE: Generating reports in Word from MathCad calculations

Looks like I'm going to be pushing the company for a later version, because being able to do the "c:=a+b=XX" would GREATLY clean up this report. Luckily, MathCad isn't the most expensive program out there!

## RE: Generating reports in Word from MathCad calculations

If you get a new version of MathCAD and start using the == stuff you need to be really careful to make sure that everything updates with a change. In V14 that doesn't happen most of the time. I end up having to put the cursor on every equation and hit F9 to make sure that I'm seeing the current stuff. Can be frustrating. Not enough to go to V15.

David Simpson, PE

MuleShoe Engineering

"Belief" is the acceptance of an hypotheses in the absence of data.

"Prejudice" is having an opinion not supported by the preponderance of the data.

"Knowledge" is only found through the accumulation and analysis of data.

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Generating reports in Word from MathCad calculations

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Generating reports in Word from MathCad calculations

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

## RE: Generating reports in Word from MathCad calculations

The second equal sign not updating seems to kick in when the sheet gets to a certain size. The sheet where I first noticed it was 2.1 MB. Under 100kB the second = always updates just fine. When I first saw it a couple of years ago I started a thread here or in Tek-tips.com and it seemed to be a known bug. I can't find the thread now and I can't remember many details.

MuleShoe Engineering

"Belief" is the acceptance of an hypotheses in the absence of data.

"Prejudice" is having an opinion not supported by the preponderance of the data.

"Knowledge" is only found through the accumulation and analysis of data.