Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Refer to calculated values at beginning of document 1

Status
Not open for further replies.

ferryscott

Aerospace
Aug 18, 2008
14
It is often required for me to state some of the calculated values on the first page of my reports; at the moment i'm just copying the values into a table.

The other day I nearly sent off a report with an out-dated value on the front page after I changed some of the report content and almost forgot to change the table on the front page. Idiot.

Is there any way of stating the values I later calculate on the front page so they automatically update with changes?

I'm relatively new to mathcad so my apologies if this is a really stupid question!
 
Replies continue below

Recommended for you

Well, you are in for a treat. There is a function of Mathcad that permits you to do what you need, but you really should understand how the program works so you don't get into trouble doing this.

If you assign a value using the global variable declaration, you can use that value before the location in the sheet where you declared it.

In your case, you might have to use the global declaration for most of your work, and then use the standard variable statements at the top of you page to summarize your results.

The reason this works is because Mathcad computes all the global variable statements first. Then it jumps back up to the top and computes all the regular ones when it is done. If all your calcs were done in the first (global calc) pass, the second pass would show your answers at the top of the page. I use a variation of this often because in my structural calculations I have to account for the members self-weight. But I don't know the self-weight before I have sized the member. I declare the member size at the point in the sheet where I check the member capacity by using the global definition to declare the member. The spreadsheet goes thru and picks up the member size, then does all the calcs with that number until it gets back to the same point. In this way, the calcs use the member self-weight, which is always located early in the calcs, to check the final stresses.
 
When I need to do this sort of thing, I create a second worksheet and reference the first sheet into it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor