Home > Products > SRS1 Cubic Spline for Excel
###### Latest News...
SRS1 Cubic Spline for Excel V2.5 Released - Free Software Adds Expanded Spline and Linear Interpolation functions to Microsoft Excel... more...

## SRS1 Cubic Spline for Excel

"Free software that adds cubic and other spline functions as well as linear interpolation to Microsoft Excel..."
Cubic Spline function
Constrained Spline functions
Linear Interpolation function
Simple to use; works like any other Microsoft Excel function
Totally Free

### Product Description

Add multiple FREE spline interpolations functions to Microsoft Excel...

SRS1 Cubic Spline for Excel adds several spline and linear interpolation functions to Microsoft Excel. The cubic spline function smoothly interpolates between given data points. Bessel and OneWay (monotonic) spline functions provide a more constrained smooth fit to data. A linear interpolation function is also included. The functions are accessed just like any other standard Excel function.

The latest version of SRS1 Cubic Spline for Excel supports Excel 2007 or later, including both 32 and 64 bit versions of Excel.

Operating Systems Supported: Windows 10, Windows 8.1, Windows 8, Windows 7, Server 2012, Vista, XP, Server 2008, Server 2003

### Demonstrations / Screen shots

#### Demos

How to Use Cubic Spline Function in Excel (V2.5) - This quick set of screen shots and explanation show you how to access the Cubic Spline functions in Excel. This explanation is valid for the versions 2.5 of SRS1 Cubic Spline for Excel or later.

Sample Excel Workbook Demonstrating Cubic Spline Functions in Excel (V2.5 or later) - This workbook shows examples of how to use the functions in SRS1 Cubic Spline for Excel. This is sample workbook was made using the version 2.5 of the SRS1 Cubic Spline for Excel.

Real World Example: Interpolate monthly economic values from quarterly data - This workbook shows a real world example of how the cubic spline function can be used to interpolate monthly values from a set of economic values that are given on a quarterly basis. Using a cubic spline is a common way to accomplish this, and being able to do this all directly in Microsoft Excel makes the task much easier. (Note: Uses v2.5 or later of SRS1 Cubic Spline for Excel.)

#### Video Demos

Using SRS1 Cubic Spline for Excel - This video tutorial shows how to use SRS1 Cubic Spline for Excel. It demonstrates how to use the cubic spline and linear interpolation functions that are added to Microsoft Excel.

### Version Info

• Fix - Fixed a problem that sometimes could interfere with copy / paste of data
• Enhancements - Several minor cosmetic enhancements
• Supported Platforms - This version requires Microsoft Excel 2007 or later. Both 32 bit and 64 bit versions of Excel are supported.

#### V2.5

• Works with 64 bit Excel - This new version supports 64 bit versions of Excel and as well as the 32 bit versions. The previous version (2.0) only worked with the 32 bit versions of Excel.
• New Spline Functions - This version adds several new spline functions, includes "BesselSpline" and "OneWaySpline". The BesselSpline is similar to a cubic spline, but can be better behaved with fewer unwanted oscillations between data points. The OneWaySpline is a monotonic spline. If your dataset is only increasing or only decreasing, then the OneWaySpline will produce results that also do not change direction.
• Supported Platforms - This version requires Microsoft Excel 2007 or later. Both 32 bit and 64 bit versions of Excel are supported.

#### V2.0

• Improved performance - This new version is a compiled .net add-in. It calculates faster and is more robust than the previous version, which was based on VBA (Version 1.xx).
• Functions Included - This version includes both a cubic spline function, as well as a linear interpolation function.
• Supported Platforms - This version requires Microsoft Excel 2007 or later. (Note - the download also includes a copy of the older version which supports earlier versions of Microsoft Excel in case you do not have Microsoft Excel 2007 or later.)

#### V1.03

• Supported Platforms - This version works with almost any version of Microsoft Excel (Excel 95 or later)
• Configuration - This version is written in the Visual Basic for Applications language, and the source code is accessible by users
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.