{"id":62,"date":"2013-03-07T14:58:13","date_gmt":"2013-03-07T19:58:13","guid":{"rendered":"http:\/\/homepages.uc.edu\/~yaozo\/wordpress\/?p=62"},"modified":"2013-03-07T14:58:13","modified_gmt":"2013-03-07T19:58:13","slug":"sigmaplot-product-uses","status":"publish","type":"post","link":"https:\/\/zhuoyao.net\/index.php\/2013\/03\/07\/sigmaplot-product-uses\/","title":{"rendered":"SigmaPlot Product Uses"},"content":{"rendered":"\n\n\n\n
Macro Concepts<\/a><\/td>\nTransforms<\/a><\/td>\nGraphs<\/a><\/td>\nAnalyses<\/a><\/td>\nData Smoothing<\/a><\/td>\n<\/tr>\n
Controlled Release Analysis<\/a><\/td>\nSigmaPlot & Excel<\/a><\/td>\nSigmaPlot & Matlab<\/a><\/td>\nData Formats<\/a><\/td>\nCurve Fitting<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The following whitepapers highlight these application areas:<\/p>\n

<\/a>A. Macro Concepts<\/strong><\/p>\n

a. Creating a Macro<\/strong><\/p>\n

i.\u00a0Recording a Macro<\/strong><\/a>\u00a0– A tutorial showing how to record a macro that fits a decaying exponential curve to two data sets. The macro is then modified by 1) adding a for-loop, 2) adding a dialog to allow user control and 3) placing the macro name on the main menu.<\/p>\n

ii.\u00a0Creating a New Menu Item and Adding a Macro Name To It<\/strong><\/a><\/p>\n

iii.\u00a0Run a Macro from the Toolbox Menu<\/strong><\/a>\u00a0– Descriptions of the macros in the SigmaPlot Toolbox menu item.<\/p>\n

iv.\u00a0Adding a For-Loop to Your Macro<\/strong><\/a><\/p>\n

v.\u00a0Adding a Dialog to a Macro<\/strong><\/a>\u00a0– Describes how to create a dialog interface to a macro.<\/p>\n

vi.\u00a0Important Issues With Recorded Macros<\/strong><\/a><\/p>\n

1.\u00a0Making the Graph Page the Currently Displayed Window<\/strong><\/a><\/p>\n

2.\u00a0Using Statements from Recorded Macros<\/strong><\/a><\/p><\/blockquote>\n

b.\u00a0Batch Processing using SigmaPlot Automation<\/strong><\/a>\u00a0– Select a group of Excel files to process in a batch. This macro fits a user-selected SigmaPlot curve fit equation to the data, creates a graph and saves the results for all Excel files in a SigmaPlot notebook.<\/p>\n

c.\u00a0SigmaPlot Macro Sample Code<\/strong><\/a>\u00a0– Useful macro sample code is provided for the user to copy. [top<\/a>]<\/p><\/blockquote>\n<\/blockquote>\n

<\/a>B. Transforms<\/strong><\/p>\n

a.\u00a0Rowwise Statistics Transform<\/strong><\/a>\u00a0– This transform computes rowwise statistics. It complements the columnwise statistics available from the main menu. [top<\/a>]<\/p>\n

b.\u00a0Transform Functions Root and Implicit\u00a0<\/strong><\/a>– These two new functions have been added to solve equations. [top<\/a>]<\/p><\/blockquote>\n

<\/a>C. Graphs<\/strong><\/p>\n

a.\u00a02D Histogram<\/strong><\/a>\u00a0– Histogram and cumulative histograms are created from a single column of data. Four graph types and other options are provided.<\/p>\n

b.\u00a03D Histogram<\/strong><\/a>\u00a0– A three-dimensional bar-graph histogram is created from bivariate data.<\/p>\n

c.\u00a0Asymmetric Error Bars<\/strong><\/a>\u00a0– This macro creates one of three types of graphs with asymmetric error bars from relative error bar data.<\/p>\n

d.\u00a0Preparing Your Graphs for Journal or Web Publication<\/strong><\/a>\u00a0– A discussion of the graph file formats used and\/or required for journal and web publication.<\/p>\n

e.\u00a0Quality Control Charts<\/strong><\/a>\u00a0– Xbar and Range charts are created using the SigmaPlot Reference Line feature.<\/p>\n

f.\u00a0Ribbon Graph<\/strong><\/a>\u00a0– This transform uses XZ profiles from XY Many Z data to generate the individual ribbons of a ribbon graph. This transform is located in your SigmaPlot Transforms folder.<\/p>\n

g.\u00a0Shade Between Two Curves<\/strong><\/a>\u00a0– This macro creates a shade between two curves. It complements SigmaPlot\u2019s built-in area plot feature that shades area under the curve to the X-axis. The macro assumes the data for both curves is strictly increasing in x.<\/p>\n

h.\u00a0Formatted SigmaPlot graphs for Submission to the FDA<\/strong><\/a>\u00a0– The procedure is described for pasting SigmaPlot graphs into Microsoft Word that fit within specified margins and have a fixed font size. [top<\/a>]<\/p><\/blockquote>\n

<\/a>D. Analyses<\/strong><\/p>\n

a.\u00a0Analysis of Ligand Binding Data<\/strong><\/a>\u00a0– Competition, saturation and dose-response studies may be analyzed with SigmaPlot Version 7.0 and this macro. Multiple replicate data sets are fit using an equation selected from a list of ten \u2013 and you may add your own. Graphical results, EC50 values and a statistical report are produced.<\/p>\n

b.\u00a0Analyzing Dissolution Test Data with SigmaPlot\u2019s Excel Spreadsheet<\/strong><\/a>\u00a0– An Excel worksheet analyzes up to 12 vessel by 6 sample time dissolution test data. Publication quality graphs of the results are simultaneously created. [top<\/a>]<\/p>\n

c.\u00a0Shelf Life Time Analysis<\/strong><\/p>\n

i.\u00a0Computing Shelf Life Time with SigmaPlot<\/strong><\/a>\u00a0– An exact computation of shelf life time is computed and graph created. Four designs are available \u2013 lower specification only, upper specification only, lower and upper specification and degradant analysis.<\/p>\n

ii.\u00a0Validation of the Shelf Life Macro<\/strong><\/a>\u00a0– Confirms accuracy of the Shelf Life Macro<\/p>\n

iii.\u00a0Simulation<\/strong><\/a><\/p>\n

iv.\u00a0Transform<\/strong><\/a>\u00a0[top<\/a>]<\/p><\/blockquote>\n

<\/a>d.\u00a0Data Smoothing<\/strong><\/a>\u00a0– Three real-world examples with increasing variability show the usefulness of SigmaPlot\u2019s data smoothing algorithms to visualize the information in the data. [top<\/a>]<\/p>\n

<\/a>e.\u00a0Controlled Release Analysis<\/strong><\/p>\n

i.\u00a0Fitting Controlled Release and Dissolution Data<\/strong><\/a>\u00a0– Five controlled release models for analysis of drug dissolution data are implemented as a SigmaPlot fit library. One or all models may be easily fitted to your data.<\/p>\n

ii.\u00a0Explicit Function Approximation<\/strong><\/a><\/p>\n

iii.\u00a0Create These Functions<\/strong><\/a><\/p>\n

iv.\u00a0Modify Equations in the SigmaPlot Fit Library<\/strong><\/a>\u00a0[top<\/a>]<\/p><\/blockquote>\n

f.\u00a0Global Analysis of Concentration Response Curves<\/strong><\/a>\u00a0– Global curve fitting without data concatenation is demonstrated.<\/p>\n

g.\u00a0Global Curve Fit of Enzyme Kinetics Data<\/strong><\/a>\u00a0– A demonstration of simultaneous fitting of multiple functions to multiple data sets with shared parameters.<\/p>\n

h.\u00a0Global Curve Fitting for Ka and Kd from Sedimentation<\/strong><\/a>\u00a0– A global analysis of ultracentrifuge radial macromolecule concentration gradients.<\/p>\n

<\/a>i.\u00a0Global Curve Fitting – Dose Response Parallelism<\/strong><\/a><\/p>\n

j.\u00a0Curve Fitting \/ Regression<\/strong><\/a><\/p>\n

k.\u00a0Piecewise Nonlinear Regression<\/strong><\/a>\u00a0– A four-segment piecewise linear equation is fit to rowwise replicate data.<\/p>\n

l.\u00a0Weight Functions in Nonlinear Regression<\/strong><\/a><\/p>\n

m.\u00a0Parameter Confidence Intervals in Reports<\/strong><\/a><\/p>\n

n.\u00a0Implicit Function Curve Fitting<\/strong><\/a><\/p>\n

o.\u00a0ROC Curves Analysis<\/strong><\/a><\/p>\n

p.\u00a0Standard Curves Analysis<\/strong><\/a>\u00a0[top<\/a>]<\/p><\/blockquote>\n

<\/a>E. SigmaPlot & Excel<\/strong><\/p>\n

a.\u00a0Create a SigmaPlot Graph in Excel<\/strong><\/a>\u00a0– An Excel macro that creates a SigmaPlot graph in Excel.<\/p>\n

b.\u00a0Using macros to place SigmaPlot charts in Microsoft<\/strong><\/a>\u00a0– The macro statements required to insert a SigmaPlot graph into a PowerPoint slide are shown and explained. The similar procedure for placing a graph in Word is then shown. [top<\/a>]<\/p><\/blockquote>\n

<\/a>F. SigmaPlot & MatLab<\/strong><\/p>\n

a.\u00a0MATLAB\u00ae<\/sup>\u00a0SigmaPlot\u2122<\/sup>\u00a0Functions<\/strong><\/a>\u00a0[top<\/a>]<\/p><\/blockquote>\n

<\/a>G. Data Formats<\/strong><\/p>\n

a.\u00a0Replicate Data Format<\/strong><\/a><\/p>\n

b.\u00a0X,Y Many Z to X, Y, Z Format<\/strong><\/a>\u00a0– This transform converts from one format to another. For example, the 3D smoothing algorithms requires data in XYZ format. [top<\/a>]<\/p><\/blockquote>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Macro Concepts Transforms Graphs Analyses Data Smoothing Controlled Release Analysis SigmaPlot & Excel SigmaPlot & Matlab Data Formats Curve Fitting The following whitepapers highlight these… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-inforgraphics"],"_links":{"self":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/comments?post=62"}],"version-history":[{"count":0,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/62\/revisions"}],"wp:attachment":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/categories?post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/tags?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}