Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Generating reports in Word from MathCad calculations 4

Status
Not open for further replies.

EMorel

Mechanical
Sep 6, 2012
43
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.
 
Replies continue below

Recommended for you

Oh, but there is also an MP4 that supposed to be released next year.

TTFN
faq731-376
7ofakss
 
Thanks for the tip about "c:=a+b=XX". I'm always typing a second c:= so I can follow the results throughout a calculation. But it's not too useful if M14 doesn't reliably update the results when the inputs change. I've tried it in a few files and it seems to be working for me. Is this a real bug? Is it fixed in M15?

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

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.
 
Your second C:= should be just C= to report the calculated value of C. It always works for me in M15. Note: you can also imbed results in text, like "In the end, C=XX when rounded to two places" where C=XX is actually the same as C= somewhere in the document. I actually hate Word for calculations, since Mathcad does such a better job, and I have figured out headers, footers, page border, pagination, etc. Putting CAD drawings or pictures into Mathcad is easy also.
 
I recently introduced a college student to Prime 2 and for a new user, it is pretty nice as compared to M15. For easy simple calculations and presentations, it is actually OK.
 
IFRs, that's my thing too, I hate using the equation editor in Word, especially when I'm already using MathCad to generate all of the results. I figure with a later version of MathCad, I can create a report that looks near identical to the one I have in Word and eliminate the need for me to transpose anything!
 
I installed V15 within days of introduction. I had a lot of problems with some of my old sheets not working anymore. Switched back to V14 where I knew what bugs to avoid. I've heard there were some fixes to V15 that made it very stable, but I never went back. From the comments above maybe I should have.

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.

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor