MATHCAD, Geomagic Freeform, Mecsoft VisualCAM & CAD CAM CNC software support discussion forum. Moderated.

Moderators: caddit, evanish, Moderators

Was this helpful?

Yes thanks!
No votes
0%
hmm somewhat helpful
No votes
0%
No, Boring...show me something else
No votes
0%
#728 by Senseineo
Tue Aug 18, 2009 4:59 am
Hello all,

My name is Philip. I work in technical sales at CADDIT. I will be demonstrating some simple but helpful tips and tricks in a series of Webinars for Mathcad in the next several weeks. Here's a glimse of what's to come with the request from everyone for feedback.

Mathcad Webinar Overview:

(1) Why it is important it consider Mathcad?

(2) Working out on how to generate standard curves with higher accuracy and using

Mathcad to do the calculations

(3) Example Case of an Analysis of Dietary Metabolites in urine.


Mathcad is a versatile and powerful mathematical program in which one can be able to do complex calculations and still be able to complete them in a logical fashion. This is extremely useful in providing information that correlated among peers. This introductory will shown how this can be achieved.

Here we start with the data which is given and is processed into Mathcad by using the Table function which is assess accordingly by right clicking in the workspace and selecting insert----> and the table.

Image

You may note that this example here is done in duplicates to generate a more accurate result with the standard curve which is required for this assay method. Also it is good to notice that the workspace can accommodate word or text anywhere within the calculations.

Now we come down to the second table which we have here with the values which are taken out of the UV-Vis spectrometer. Take note to be able to use the figures later on in Mathcad, you will need to specify the columns that are used in the calculations later on. This is done by using the following keys:

[x][:][space][m][desired number according to the column needed]

Image

Now we will specify the data points in which we will be using, so in the next step when doing standard deviation calculations, the information is available. Now for the equation of standard deviation can be shorthanded later by using a SD(x) can be used later on within the worksheet.

Image

Now we can go to the insert function options to give us all the necessary equations or functions that we require to do simple to complex statistics. This is done by going to the insert ---> function and within the new dialogue on the left as shown here. We go to statistics and select the required functions. Note also that every time you select another function within the right hand window there is box underneath which gives u a description on what that function does as well as the shorthand version of the function in Mathcad. This is valuable since you do not have to come back to the the insert function over and over again.

Image

To save time you can see that I am simply cutting and pasting the functions here and editing the values in which the function is to calculate. Simply click within the function where you want to edit and enter in the new values. Now in case the answer do not automatically change with the new values given go to the top of the menus and look for the calculate button as shown here or alternatively by using the F9 key and this will perform the calculate function in Mathcad or Crtl F9 to calculate the complete worksheet itself.

Image

Now after we have completed all the necessary calculations for the standard curve to be used her, we can start using the values here to make our standard curved to do our calculations. Go to the Graph bar and select the x,y plot graph. Now to get the values into the graph we just have to click on the bottom middle box here and enter in x and to the left middle box we add in our functions that we need which is the y function as well as the r(x) which will give us the line of best fit. Now completed, to generate the graph simply click outside into the workspace.

Image

You may notice that the axis of the graph are defined at a undesirable scale. To edit the scale, click the graph once again and you will notice two of additional numbers which are part of the graph on the bottom as well as on the left where the axis are. These numbers are your minimum as well as maximum range values on the corresponding axis. Change these numbers to the desired scale you would like and click outside into the workspace to regenerate the graph with the new changes. To change the Units in which the graph is also spaced out on the axis, right click the graph and select format.

Image

A new dialogue similar to the one show here will open and click on the options in the dialogue under the x and y primary axis and un-tick auto grid and set to a desired amount of scale units you would like. Once completed click apply and okay.

Image
Now that we have the standard curve we can start by working out the amount of urea in urine sample, I am going to demonstrate how to integrate excel into Mathcad and vice versa.

CADDIT will be working directly with PTC in Sydney for Mathcad support and a few other software products. If you would like to download Mathcad, you can try the free 30 day demo version HERE.


CADDIT SMB & Enterprise CAD CAM Support
CAD CAM Software
Mathcad