Mathcad Queries

[SharmaKona-Adro]

Hello guys, I have few simple short questions regarding MathCAD if you can answer them..

1. Is Conditional Formatting avalible in Mathcad sheet? If yes, how to access it?
2. Is it possible to lock the coding of Advanced Input/Output Commands separately without using the Area Box`s Password Protection?
3. I`ve been using plots from a long time and now I need my graph to display X & Y coordinates exactly at the plotting point. How to do that?
4. I have 50+ worksheets from the Legacy Mathcad (xmcd.) and currently, I`m using Mathcad Prime 10. When I try to convert those files, I`m getting errors in the equations where there was "multiplication" involved. How to solve that?
5. Just as the function of MS Excel`s 'vlookup', I want to use the "if loop" that mathcad has. How to do it? (Example: Consider that, I have an excel sheet data where if I use the data of one column, all the other column data should also get updated. I can`t be able to access it.

If, I could get answers for all these, I`d be very much delighted. Please feel free to shoot your answers/questions.

Ciao,

Sri

[terryhendicott]

Hi Sri

1 See this video https://www.youtube.com/watch?v=SG5UUVC4B2s

It shows how to conditionally format results based on the result.

Cheers

Terry

[LucMeekes]

1. See Terry's response.

2. No clue, I don't use Creo.

3. Use the native plot (from the ribbon 'Plots') and insert horizontal and vertical markers. Move them as you see fit, or enter the expressions:

4. Attach an example, both .xmcd and .mdcx files.

5. Provide an example in a worksheet that demonstrates what you want.

Success!
Luc

[Werner_E]

Guess that Terry and Luc already answered your questions or asked for more information (where I would need more info as well).

According to #3 its not clear to me what you are looking for.

If you really mean to write text (coordinate values) at a specific position in the plot itself, you may give Lucs Toolbox a try -> Toolbox: Text plotting

It may take some time to get used to and to automatically place the text at positions which may change when input values are changed.

For a more elaborate example of doing so you may ave a look at Drawing a vertical line in plot

[ppal]

I think he means they have sampled data

Eg

x      y

1.2   1.5

1.3    1.6

3.7    2.7

Then they want the same labels on the x  axis  numbering 1.2, 1.3, 3.7 and Y axis numbering will be 1.5, 1.6 and 2.7.  Not the normal equidistant numbering. I am only guessing from the comment made.

[Werner_E]

Guess we have to wait for @SharmaKona-Adro  to reply and clarify.

If your assumption is correct, Luc's suggestion with the markers could be an acceptable solution for a small number of data points.
If there are more data points or if the number of data points needs to be kept variable, then an automated solution using Luc's text toolbox could be considered. However, I see a number of problems here, as the font size depends on the axis scaling and overlaps are unavoidable if there are too many data points.