MyCurveFit Excel Add-In

Welcome to our collection of video training materials for the MyCurveFit Excel Add-In.

Getting Started (17 mins)

This section covers Getting Started with the MyCurveFit Excel Add-In. Topics include:

• Downloading and Installing
• Licensing
• Basics of working with the MyCurveFit Excel Add-In

Videos:

• Getting Started with MyCurveFit Excel Add-In (1 min)

• MyCurveFit Excel Add-In Basics (2 mins)

• MyCurveFit Excel Add-In Dynamic Array (4 mins)

• Charting a 4PL Curve with MyCurveFit Excel Add-In (5 mins)

• Interpolating Results Using MyCurveFit Excel Add-In (2 mins)

ELISA Analysis (34 mins)

This section covers how to perform ELISA analysis with the MyCurveFit Excel Add-In. Topics include:

• Creating/downloading ELISA spreadsheet template
• Entering raw data
• Calculating concentration results
• Plotting curve chart
• Creating a sample table
• Choosing the right fit method for ELISA
• Why interpolation fails above or below the asymptotes
• Analysis with different plate layouts

Videos:

• ELISA Analysis in Excel with 4PL (now even easier with dynamic arrays) (8 mins)

• ELISA Data Analysis Using MyCurveFit Excel Add-In (7 mins)

• Why Interpolation Above or Below Asymptotes Fails (4PL ELISA in Excel) (4 mins)

• Choosing the Right Fit Method for ELISA (8 mins)

• ELISA Analysis in Excel with Different Plate Layouts (6 mins)

Creating Curve Charts (23 mins)

This section covers how to create curve charts the MyCurveFit Excel Add-In. Topics include:

• Fitting and charting a curve in Excel
• Creating a plot data table
• Creating an automatically updating plot data table
• Logarithmic plot data table for semi-log axes
• Fitting to a dynamic x and y calibrator range

Videos:

• Charting a 4PL Curve with MyCurveFit Excel Add-In (5 mins)

• Adding Observations to Curve Chart with MyCurveFit Excel Add-In (3 mins)

• Creating an Automatically Updating Plot Data Table in the MyCurveFit Excel Add-In (6 mins)

• Logarithmic Plot Data Table for Semi-Log Axes in MyCurveFit Excel Add-In (5 mins)

• Dynamic Range Curve Fitting in the MyCurveFit Excel Add-In (3 mins)

Helpful Tips (50 mins)

This section provides helpful tips and analysis pointers for using the MyCurveFit Excel Add-In. Topics include:

• Choosing the right fit method for your ELISA
• Why interpolation above or below the asymptotes fails
• Validating curve fitting
• Excluding data points
• Configuring custom messages

Videos:

• Why Interpolation Above or Below Asymptotes Fails (4PL ELISA in Excel) (4 mins)

• Choosing the Right Fit Method for ELISA (8 mins)

• Comparing Curve Fit Results Between MyAssays and Other Providers (8 mins)

• Exploring User Defined Curve Fit Parameters (6 mins)

• Data Point Exclusion in the MyCurveFit Excel Add-In (4 mins)

• Automatic Data Exclusion with the MyCurveFit Excel Add-In (7 mins)

• Configuring Custom Messages in the MyCurveFit Excel Add-In (2 mins)

• Validating Curve-Fitting Functionality Against National Institute of Standards and Technology Reference Data (6 mins)

• Validating Curve-Fitting Functionality Without a Reference Data Set (3 mins)

Other Analysis Examples (19 mins)

This section provides examples of other analyses performed using the MyCurveFit Excel Add-In. Topics include:

• Michaelis-Menten curve fitting
• Multiplex data analysis
• Calculating mortality rate

Videos:

• Michealis-Menten Curve Fitting with MyCurveFit Excel Add-In (4 mins)

• Multiplex Data Analysis with the MyCurveFit Excel Add-In (9 mins)

• Calculating Mortality Rate using MyCurveFit.com and the MyCurveFit Excel Add-In (4 mins)

Advanced Topics (42 mins)

This section covers more advanced topics in the MyCurveFit Excel Add-In. Topics include:

• Weighted curve fitting
• User defined curve fit equations
• Adding starting point estimates
• Data point exclusion
• Adding custom messages
• Log transforming data

Videos:

• Weighted Curve Fits with MyCurveFit Excel Add-In (2 mins)

• Calculating User Defined Fit Parameters with MyCurveFit Excel Add-In (2 mins)

• MyCurveFit Excel Add-In User Defined Advanced (6 mins)

• User Defined Parameter Estimation in MyCurveFit Excel Add-In (4 mins)

• Exploring User Defined Curve Fit Parameters (6 mins)

• Data Point Exclusion in the MyCurveFit Excel Add-In (4 mins)

• Automatic Data Exclusion with the MyCurveFit Excel Add-In (7 mins)

• Configuring Custom Messages in the MyCurveFit Excel Add-In (2 mins)

• Log Transforming Data in MyCurveFit.com and the MyCurveFit Excel Add-In (5 mins)