Mathcad

Dear, I have a dataset where the first column represents the index of a vector and column 2,3 and 4 the three possibilities. The first row contains the classification for a specific condition. The dataset has been manipulated to align these indices and classifications. My vector, for example, have this format:: However, I'm having trouble getting the vertical-horizontal lookup (VHLOOKUP) to search for each element in my vector and correctly return the value at the intersection based on the classification assigned to each vector element. Anything I tried returned 3x1. I have tried it all from the similar post:https://community.ptc.com/t5/Mathcad/Use-vlookup-over-a-vector/td-p/482509 Prime 9 attached. 

In the attached MathCad worksheet is an embedded excel file that has VBA apps in it.  It takes data input and calculates to values C and C` or is suppose to.  The excel file "CANDCPRIME.XLS" on its own works fine but once it is inserted in to MathCad it is being blocked by Microsoft as "untrusted".  What do I have to do to make it run inside MathCad.  It use to just fine but I haven't used this MathCad worksheet for a few years because my work did not include a lot of steel design.  I am using a subscription to Microsoft Office 365 and have tried to modify all the security and "Trusted" stuff I could find to allow this to run.  And ass I mentioned above by itself runs perfectly. Put all the files attached in the same location.Any help is appreciated.  Thank you,John

Hello,  I am using mathcad prime 10.0 and have created a program to solve for F_rated. I then want reference this program in a for loop, however it says the inputs to the function must be integers. Outside the for loop the equation works fine so I am a bit confused.

Hi, I have a MC15 calculation-sheet of 200 pages that have been converted to Mathcad Prime 9.0 that runs extremely slowly and which im now looking to optimize. Changes in input that in MC15 would have taken 5-10 seconds to recalculate can now take upwards of 5 minutes or more before the sheet is updated. I've been trying to read up on ways to speed up processing in Mathcad Prime and have read that size of matrices, the use of If-statements and possibly the use of "strings" in aforementioned matrices may be culprits. Which optimizations do you believe would bring me the biggest improvements in calculation speed as opposed to how MC15 was working? Does anyone have any recommendations how i should go about rewriting If-statements? (see attached picture of an example) Im going to see if i can break up the sheet in parts and work on a part separately. Then i can also upload said part here for you to partake in. Kind regards,Johan

when i do some multi-objective parameter optimization cases in mathcad,i find that there are only three algorithms that can be used，L-M，Conjugate gradient method and Quasi-Newton method. these methods may can't find the global optimum,or take very long time.nowadays,there are many other algorithms,such as GA(Genetic Algorithm),it may solve these problems easily.but my mathematics is poor，can any body do it,or has anybody done that?i want to have a try,but my methematics is poor,at the same time,i am not proficient in programming.wish for your help.

 

Hi,I am attempting to create a program that will autogenerate several MathCAD file templates based on variables that will be taken from an excel sheet that contains a list of parts.  I am using MathCAD Prime 9.0 Some things I've looked into are using the API or changing the XML data directly.  The API doesn't seem to support a way to add in new inputs and outputs to a blank worksheet. Changing the XML data directly seems like it could be a good option. From other posts I've read it sounds like you can change the file extension to a zip, unzip the file, change some data in one of the files, then rezip and change the extension back. However when I have tried this the process of unzipping and rezipping changes how it is compressed which causes it to be unreadable by mathcad, even if I don't change any of the internal files. Is there a way I can inputs and outputs to a blank worksheet with the API that I am missing? Is there a way to unzip and rezip the m

Hi Guys,   I tried to enhance mathcad Prime's page counter as the counter does not allow starting with a page number other than 1. So I'm using a textbox as a page counter. In this textbox I have an input and an output. The counter shall increase by one on each consecutive page making it possible to combine several files into one. Or so I thought. For some reason I can't hide or collapse the left side of the textbox which makes it appear ungainly. I've tried to hide it and to collapse it. To no avail.   Does anybody have an idea what I'm doing wrong? Raiko P.S. I'd prefer to have this textbox in the footer, but prime does not accept it. Any idea how to change this?

Hi,How can I draw the ASYMPTOTIC bode plot of this function in more automatical way? Is it possible? I mean I know that this asymptotic bode plot can be draw after some manual analysis, but is it possible to make a program that can draw automatically this thing?   I am expecting something like that (red plot):

Dear community friends, I have a problem generating an automatic graph from the data of a matrix as shown in the spreadsheet. Mathcad Prime V.8.0.0   Translated by the Community Moderation using Google Translate   Estimados amigos de la comunidad, tengo una problema al generar un gráfico automático a partir de los datos de una matriz tal como se muestra en la hoja de calculo. Mathcad Prime V.8.0.0  

Since we can't post on the Tips forum, I'll leave this here...   Coolprop version 6.3.0 is released.  Coolprop is an open-source C++ library that implements: Pure and pseudo-pure fluid equations of state and transport properties for 122 components Mixture properties using high-accuracy Helmholtz energy formulations Correlations of properties of incompressible fluids and brines Highest accuracy psychrometric routines (Humid Air properties)  User-friendly interface around the full capabilities of NIST REFPROP (if you own REFPROP already) Fast IAPWS-IF97 (Industrial Formulation) for Water/Steam Fully featured wrappers are available for both Mathcad 15 and Mathcad Prime as Add-in DLLs.  Documentation can be found at http:/www.coolprop.org.  Instructions for downloading the Add-in wrappers from SourceForge for either version of Mathcad can be found here.  A Mathcad worksheet is included with the DLL that demonstrates how to use the add-in.

Hi PTC Community, I'm currently facing an issue while converting files from MathCAD 15 to Prime 9. It appears that a specific checkbox option, which was available in MathCAD 15, is missing or not functioning correctly in Prime 9. I'm trying to manually debug the issue, but I'm struggling to find a solution. Has anyone encountered a similar problem or know of any workarounds to restore this functionality in Prime 9? Any insights or advice would be greatly appreciated! Thanks in advance for your help!

Good morning Community: I have a question about how to operate data from a matrix for a certain identity condition (id), so that a matrix solution can be obtained. Matcad Prime V.8.0 version. Thanks for your attention.   Translated by the Community Moderation using Google Translate     Buen día Comunidad: Tengo una duda de como operar datos de una matriz para una determinada condición de identidad (id), de modo que se pueda obtener una solución en matriz. Versión Matcad Prime V.8.0. Gracias por la atención.  

hello everyone,i am trying to get 'z' as matrix as shown in the attached Mathcad 10 sheet.i do not know where it is going wrongcould someone help me here

As per the original post.    Hi: I have some old mathcad .mcd files. can you help me opening them and convert to mathcad 10. I am using a trial license only?  

Gentlemen, please don't take this as impudence, but could you tell me how to make sure that the paths don't cross?

 

Good morning community, I have a problem generating a matrix for n values ​​through programming, Mathcad Version 8.0   Translated by the Community Moderation using Google Translate     Buen día comunidad, tengo problema para generar una matriz para n valores mediante una programacion, Versión Mathcad 8.0  

I could be doing something wrong here, but it seems that I see an inconsistency in the substitution function in the symbolic math in Mathcad Prime 10. I started with: The result here in incorrect in that the first term (se^2*Vc*t^2) should be divided by 2.If I do the same integral without using the substitute function as follows:Here we arrived at the correct answer.  It seems possible to me that it might have something to do with the limits of integration.  I tried using a top limit that was not the same as the integration variable and it did not make any difference.I will be really grateful for anyone's perspective here especially if you see that I am incorrectly using the function.

Greetings Community, I am trying to generate a matrix to make graphs. What I want is to obtain values ​​that are colored red with the data that is available. Mathcad Prime 8.0 version   ----------------------------------------------------- Translated topic from Spanish to English using Google Translate Subject - Operacion con matrices Body - Saludos Comunidad, estoy tratando de generar una matriz para realizar gráficos. Lo que deseo es obtener valores que están de color rojo con los datos que se tiene. Versión de Mathcad Prime 8.0   By Community Moderation Team -----------------------------------------------------

Hi, attached file (build by Terry Hendicott) creates a 13xYYY matrice from an 13x3 indata matrice. It calculates the inverted product of each column in the 13xYYY matrice and plots it in the diagram. Now I would like to extract those columns with a product between two values (Here it is 15 and 25 millions)  Then I would like to present those columns in a new matrice like   

Hi, Can I get some help how to how to write a function that return all row products in a matrice according example below?  Second question is how I extract data lower, between or higher then a given number.  

Hi,PTC made this good video showing the new features of Mathcad prime 10. But they did not make any guides or tutorials in how to make it work. You can see the feature in action here, where the text box change from "PASS" to "FAIL" and the color change from green to red. I want to make that, but I don't know how:https://youtu.be/RemRyXvRt3k?si=enCDHrHmk5_uJ72P&t=7 Basically I want to make the exact same thing. I have a foundation calculation which have multiple checks. Basically I have a load and a calculation which gives med the max load on the foundation. Here I have made a simple "if" formula which give me "OK" or "Not OK". But they do not have color. I need to change the color manually.  I have this:  When I saw the feature in the above video, I knew that would make the calculation so much better. But I simply don't know how to do it?  I have tried Input/output -> Controls -> Advance -> Text box I have the feeling that this

Hi there,  I have 2 questions:1) Can I choose the location of the excel sheet in Sharepoint of our company ( using link) like I did below? I need the file in company data not personal PC.2) How can I generate the same excel sheet for all the results instead of generating new sheets for each ?The sheet is attached below , page no 4 , using Prime 9 

Hello. I created a range variable "y" with units (see attached file). Then I try to calculate parameter "H". Mathcad says that "This value must be scalar or a vector". I think it is strange that the calculation fails. What do I do wrong here? Sergey