Home > Products > Data Curve Fit Creator Add-in
Latest News...
SRS1 Software, LLC Releases Data Curve Fit Creator Add-in v2.80 - Cubic Spline interpolation curve coefficients and slope values calculated in spreadsheets by new Add-in... more...
New Demos...
testOrig Cubic Spline Extras - See how to return Cubic Spline coefficient values, slopes, and more...
testOrig Constrained Splines - See how the Bessel and OneWay (monotonic) splines can interpolate difficult datasets...
testOrig Introduction - See an example of curve fitting with Data Curve Fit Creator Add-in...

Data Curve Fit Creator Add-in

"Curve fitting, forecasting and more... for Microsoft Excel!"
Data Curve Fit Creator Add-in
Digital Camera Poster Creator benefits
Curve fitting and data analysis functions for Excel
Digital Camera Poster Creator benefits
Polynomials, splines, flexible fits, data smoothing, and more...
Digital Camera Poster Creator benefits
Simple to use, but powerful...
Digital Camera Poster Creator benefits
Enables better data analysis in less time...
Digital Camera Poster Creator benefits
Fully functional 30 day trial
Download Data Curve Fit Creator Add-in
Try it for free!
Buy Data Curve Fit Creator Add-in
Only $99.95!
Volume discounts too!

Product Description

The easiest way to do curve fitting, forecasting, and data smoothing in Microsoft Excel...

Data Curve Fit Creator Add-in is an easy-to-use data analysis add-in for Microsoft Excel. It adds curve fitting, interpolation, and data smoothing functions to Excel. These functions work just like standard Excel functions, so they are simple to use. Curve fitting functions include polynomial fits and a versatile local regression (loess) function. Interpolations include linear, cubic spline, Bessel and monotonic splines, as well as a 'flexible spline' that allows you to specify the slope at each data point. Data smoothing functions include moving average, median filter, and a Gaussian smoothing filter. Automatic sorting and data repair functions are also included. The software comes with full help documentation and an example workbook that demonstrates each function.

Microsoft Excel Versions Supported - Excel for Office 365 is supported, as is Excel 2016 and 2013 (both 32 bit and 64 bit versions), Excel 2010, and Excel 2007.

Operating Systems Supported - Windows 10, Windows Server 2016, Windows 8.1, Windows 8, Windows 7, Server 2012, Vista, Server 2008.


Demonstrations / Screen shots

Screen shots

  • Polynomial fit - This screenshot shows an example of a polynimial fit that is being done with Data Curve Fit Creator Add-in.
  • Spline - This screenshot shows an example of spline interpolation being performed by Data Curve Fit Creator Add-in. Several types of splines and interpolation functions are included in the software.
  • Data Smoothing - This screenshot shows an example of data being smoothed by Data Curve Fit Creator Add-in. Several types of data smoothing functions are included in the software.

Video Demos

testOrig Introduction & Curve Fitting Demo - This is an introduction to the Data Curve Fit Creator Add-in. This demo shows how to do a simple polynomial fit, and then shows how to use weight values in your fit.
testOrig Cubic Spline New Features - This video demonstrates the new options added to the Cubic Spline function, including returning slope and function coefficients, as well as expanded options for spline calculation and extrapolation. The video also demonstates updates to the Data Curve Fit Creator interface (new ribbon menu, custom function group).
See how to use array formulas with Data Curve Fit Creator Add-in Using Array Formulas - "Array formulas" are Excel workbook functions that return more than one value, and whose results occupy more than one cell. Some of Excel's built in functions (e.g. matrix functions), and some of the functions that Data Curve Fit Creator Add-in adds to Excel are also "Array Formulas". The three steps to using an "Array Formula" are to: (1) Highlight the cells where the result will go (2) Enter the formula in Excel (3) Instead of just pressing the 'Enter' key, you need to hold down the 'control' and 'shift' keys, and then press the 'Enter' key. This is demonstrated in this video. The video also shows how to use the Data Curve Fit Creator Add-in median_filter function (which is an "Array Formula").
See how to use array formulas with Data Curve Fit Creator Add-in Using the Bessel and OneWay Spline functions - The "Bessel" and "OneWay" (monotonic) spline functions in Data Curve Fit Creator Add-in are similar to a cubic spline, except they can be better behaved (fewer unwanted oscillations) than the cubic spline in some cases. The "Bessel" spline uses a parabolic fit internally instead of the Cubic Spline's third order polynomial fit. The "OneWaySpline" is the most constrained spline. It guarantees a monotonic (only increasing or only descreasing) result if the source data is monotonic, but still works with non-monotonic source data.
See how to use array formulas with Data Curve Fit Creator Add-in Using the FlexSpline Function - The "FlexSpline" function in Data Curve Fit Creator Add-in is similar to a cubic spline, except it gives you more control over the shape of the resulting spline curve. The "FlexSpline" allows you to specify the slope of the spline curve at any data point. This gives you great control over the shape of the resulting curve. The "FlexSpline" function is demonstrated in this video.
See how to use array formulas with Data Curve Fit Creator Add-in Automatic Data Sorting - The 'SortData' function in Data Curve Fit Creator Add-in allows you to keep rows, columns, or tables of data continuously sorted. As you change your input data, your output updates to stay sorted. The 'SortData' function includes several options to let you customize the sort. The 'SortData' function is demonstrated in this video.

Support

For your support, see the demo videos, the Data Curve Fit Creator Add-in help file, the demo workbook that is installed with the software, and the Frequently Asked Questions listed below here. For more help, see our support page or contact us at:
Support Email

Frequently Asked Questions


Version Info

V2.80 (latest version)

  • DCFCA Workbook Repair Utility - Includes new separate utility for updating/repairing Data Curve Fit Creator Add-in (DCFCA) function links in multiple workbooks
  • Other various improvements - Other various minor improvements were included

V2.71

  • Fixes, improvements - Various minor fixes and improvements were impelemented

V2.70

  • Cubic Spline Extra Vals - New function which returns Cubic Spline formula coefficients and slope at any point
  • New Cubic Spline Options - Alternative fit algorithm and extrapolation options added to Cubic Spline function
  • Custom function group - Functions now listed under new 'DataCurveFitCreator' custom function group in Function Wizard
  • Ribbon menu - Custom Data Curve Fit Creator Ribbon Menu group added to Excel Ribbon menu
  • Other various improvements - Other various improvements were impelemented

V2.62

  • Better 64 bit support - Fixes a problem which could cause a crash with 64 bit Excel 2013
  • Other minor improvements - Other various minor improvements were impelemented

V2.61

  • Supports date-time data interpolation - Excel cells containing dates/times can now be used as inputs for interpolation functions
  • Other minor improvements - Other various minor improvements were impelemented

V2.6

  • New spline functions - Two new spline functions 'BesselSpline' and 'OneWaySpline' (monotonic spline)
  • Other minor improvements - Various minor efficiciency improvements

V2.5

  • Data sorting - New 'SortData' function automatically keeps tables or datasets sorted
  • 'DataGaps' functions - Several other new functions were added that repair gaps in tables or datasets
  • Efficiency improvements - Calculation efficiency improvements were made for many functions

V2.4

  • Larger data sets allowed - Now allows the use of any size data (previous limit was 32767 points)
  • Other Minor improvements - Other various minor improvements were impelemented

V2.3

  • 64 Bit Microsoft Excel - Now fully supports 64 bit version of Microsoft Excel
  • Other Minor improvements - Other various minor improvements were impelemented

V2.2

  • Improved precision - Improved precision of some calculations
  • Increased performance - Improved calculation efficiency for the polyfit function
  • Other Minor improvements - Other various minor improvements were impelemented
Home | Sitemap | Privacy Policy
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
© SRS1 Software, LLC, All Rights Reserved