Curve fitting and data analysis functions for Excel
Polynomials, splines, flexible fits, data smoothing, and more...
Simple to use, but powerful...
Enables better data analysis in less time...
Fully functional 30 day trial
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 the standard built-in 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, and 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. The software comes with full help documentation and an example workbook that demonstrates each function.
Microsoft Excel Versions Supported - Excel 2010 is fully supported (both 32 bit and 64 bit versions), as are Excel 2007, Excel 2003, Excel XP and Excel 2000.
Operating Systems Supported - Windows 7, Vista, XP, Server 2008, Server 2003, 2000.
Frequently Asked Questions
(1) How do I install Data Curve Fit Creator Add-in?
Download and run (double click) the 'setup_dcfca.exe' file to install Data Curve Fit Creator Add-in. This will copy the add-in file ('data_curve_fit_creator.xla') and related support files (help file, demo workbook, etc.) to a new 'Data Curve Fit Creator Add-in' folder in your program files folder on your hard drive. It should also automatically register the add-in with Excel, so you should be all set to start using all Data Curve Fit Creator Add-in's functions the next time you start Excel.
If the add-in registration doesn't happen during the install, there there are a few ways that you can register the add-in with Excel yourself. Registration can be done manually by starting up Excel and using the Excel menu system to enable the add-in, or it can be done automatically by opening the 'Enable_dcfc_add-in.xls' file that is delivered with Data Curve Fit Creator Add-in. This file is an Excel workbook that contains macros that will automatically add Data Curve Fit Creator to Excel's list of add-ins to load at startup. The 'Enable_dcfc_add-in.xls' file is installed in the Data Curve Fit Creator Add-in folder in Program Files. By default, this file runs as the last step of the install process.
To allow 'Enable_dcfc_add-in.xls' and the rest of the files that come with Data Curve Fit Creator Add-in to run, you must have your security settings set to trust documents from SRS1 Software, LLC. All Excel files in Data Curve Fit Creator Add-in are digitally signed by SRS1 Software, LLC. When opening any of the workbooks, if you receive a security warning from Excel, then you need to select the option to always trust documents from this publisher (SRS1 Software, LLC).
(2) How do I uninstall Data Curve Fit Creator Add-in?
There are two types of uninstalls that you can do for Data Curve Fit Creator Add-in. For a temporary uninstall, you can simply remove 'Data Curve Fit Creator' from the list of add-ins that Excel loads on startup. This type of uninstall doesn't remove any files and allows you to re-enable the add-in any time. You can do this manually through Excel's menu, or you can do it automatically by opening the 'disable_dcfc_add-in' file via the Data Curve Fit Creator Add-in program files group.
For a full uninstall, go to your PC's Add/Remove Programs from Control Panels. From there you can select to uninstall Data Curve Fit Creator Add-in. This will remove the Data Curve Fit Creator Add-in files from your hard drive, as well as unregister the add-in.
(3) How do I set my Excel security settings to allow Data Curve Fit Creator Add-in to run?
Security is an important issue. Later versions of Microsoft Excel contain more thorough security checks. The Data Curve Fit Creator Add-in and supporting workbooks are digitally signed by SRS1 Software, LLC. This identifies SRS1 Software, LLC as the source of the documents and checks that the documents have not been altered.
Normally, when Excel encounters a workbook or add-in that contains macros (automation) then it doesn't allow the macros to run unless the user specifically allows it. For an add-in, it would be very inconvenient for Excel to prompt you every time it opens. In order for Excel to allow the Data Curve Fit Creator add-in and demo files to work without prompting you, you must have your security setting setup so that SRS1 Software, LLC documents are allowed to run. The first time that you open any of the Data Curve Fit Creator workbooks, you probably will be prompted with a security options dialog which gives you the following options:
- Allow all documents from this publisher to run
- Allow only this document to run
- Do not allow this document to run
You should select the first option, to allow all SRS1 Software, LLC documents to run. Excel identifies SRS1 Software, LLC documents by the digital signature that is attached to the documents. Once you have selected this option, then all Data Curve Fit Creator documents should run fine.
Do NOT turn off or lower your overall Excel security settings in order for Data Curve Fit Creator to run. All our documents are digitally signed so that Excel can identify them and let them run WITHOUT you having to turn down your Excel security settings.
(4) Where can I see a list of all the Data Curve Fit Creator functions in Excel?
All the new functions that Data Curve Fit Creator Add-in adds to Excel are listed under the 'User Defined' category in the Excel 'Insert Function' dialog. If you have any other add-ins that are defining custom functions then there could be other unrelated functions in that category as well. The Data Curve Fit Creator functions are also listed under the 'All' category, where all available Excel function are shown.
(5) If I use Data Curve Fit Creator Add-in functions on my workbook, then save the workbook and send it to someone else, will the functions still work when they open the workbook?
The Data Curve Fit Creator Add-in functions are stored in the file named 'Data_Curve_Fit_Creator.xla', which is in on your computer. The functions are not attached to the workbook where they are used. This was primarily due to the difficulty caused by tighter security settings in Excel. Moving code from one workbook to another is often blocked by anti-virus software, and so it can be very unreliable. A digitally signed add-in is much more reliable.
Purchasing a license for Data Curve Fit Creator gives you the right to only use it on one machine. If you are sending a workbook to someone that contains Data Curve Fit Creator functions then they need to buy a license to run it on their machine.
(6) In my workbook, I am seeing errors (#Name!) in cells where my Data Curve Fit Creator functions were. How can I fix this?
This usually means that either the Data Curve Fit Creator Add-in is not installed/enabled, or that the location of the add-in has changed since the last time that the workbook was saved. If the add-in is installed and enabled, then try selecting the 'Repair/refresh function' menu item from the Data Curve Fit Creator menu. This should refresh functions links so that they point to the new add-in location, and the functions should then work.