Skip to main content
M
MA_101905451-Visitor
1-Visitor
February 7, 2022
Solved

Lookup worksheet errors

  • February 7, 2022
  • 2 replies
  • 4401 views

I have converted numerous MathCAD 15 programs over to Prime. In doing so I am having issues with the 'Include' look-up not reading/working properly. About half the time the source/path works just fine, but on the others I get a warning - "PTC MathCAD is using the CWD, Approximate Equality, Strict Singularity Check of the current worksheet, not the CWD, Approximate Equality, Strict Singularity Check settings from the 'Source Worksheet'" It also tells me there are calculation errors in the Source Worksheet when there are none. Please advise

Best answer by StuartBruff
@MA_10190545 wrote:

Vladimir, Thank you for the help. Stuart did hint at this above, and when I have the Reference worksheet and the Using Calculation in the same folder it still does not solve the issue. See attached photo. And in the Reference Worksheet the error message states there are calculation errors in C///.... When there are not any. 

One thing to beware of is that Mathcad Prime changed how global definitions work.  Once you've defined a name as global, you can't redefine it.  You've defined W normally in the AISC worksheet but globally in your End PI worksheet.  I'm not sure whether a global definition in the main worksheet propagates into the referenced worksheet.  Try changing your global W to something else and see if the problem goes away.

 

Stuart 

2 replies

S
StuartBruff23-Emerald V
23-Emerald V
February 7, 2022

Could you please add the included worksheet (Sectdata AISC 14th Edition.mcdx)?

 

Stuart

M
MA_101905451-VisitorAuthor
1-Visitor
February 7, 2022

See attached

S
StuartBruff23-Emerald V
23-Emerald V
February 7, 2022

Unfortunately, these worksheets require the full Mathcad Prime 7 and have a lot of programs in them.  I only have Mathcad Express which doesn't have programming capability. Hopefully, someone with a subscription will be able to take a look at it.  Sorry.

 

Stuart

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
February 7, 2022

 Hi,

 

1. Read the following article - "How to avoid warning on CWD (Current Working Directory) system variable in Mathcad Prime": https://www.ptc.com/en/support/article/CS319685

2. There was a similar question before - "CWD": https://community.ptc.com/t5/PTC-Mathcad/CWD/td-p/597577

M
MA_101905451-VisitorAuthor
1-Visitor
February 7, 2022

Vladimir, Thank you for the help. Stuart did hint at this above, and when I have the Reference worksheet and the Using Calculation in the same folder it still does not solve the issue. See attached photo. And in the Reference Worksheet the error message states there are calculation errors in C///.... When there are not any. 

 

MA_10190545_0-1644270680509.png

 

S
StuartBruff23-Emerald VAnswer
23-Emerald V
February 8, 2022
@MA_10190545 wrote:

Vladimir, Thank you for the help. Stuart did hint at this above, and when I have the Reference worksheet and the Using Calculation in the same folder it still does not solve the issue. See attached photo. And in the Reference Worksheet the error message states there are calculation errors in C///.... When there are not any. 

One thing to beware of is that Mathcad Prime changed how global definitions work.  Once you've defined a name as global, you can't redefine it.  You've defined W normally in the AISC worksheet but globally in your End PI worksheet.  I'm not sure whether a global definition in the main worksheet propagates into the referenced worksheet.  Try changing your global W to something else and see if the problem goes away.

 

Stuart 

    Terms & ConditionsAccessibility statement