Scribd Logo
Upload

Welcome to Scribd!

  • 153 views

    Cubic Spline v101

    Uploaded by

    Vinh Do Thanh
    Cubic Spline in excel

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Cubic Spline v101

    Uploaded by

    Vinh Do Thanh
    153 views8 pages
    Cubic Spline in excel

    Original Title

    Cubic Spline v101 - Copy

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Cubic Spline in excel

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    153 views8 pages

    Cubic Spline v101

    Uploaded by

    Vinh Do Thanh
    Cubic Spline in excel

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 8

    Sheet1

    Cubic Spline Excel Function: This function was written in VBA and resides in a macro module in this workbook. An exampl
    order to add the cubic_spline function to other workbooks, open the workbook and then click on the "Export Spline function to o
    appears, select the workbook that you want to add the spline function to and then press the button on the form to transfer the f

    Arguments: The cubic_spline function takes three args - column of input data, column of output data, and single point that you

    The author does not make or imply any claims about the functionality of this software and is not in any
    way responsible for any damage, direct or indirect, caused by this product. The user uses it at their own
    risk.

    Example of usage:
    True Data
    In
    1
    1.4
    1.7
    2
    2.5
    2.8

    Spline Estimates
    TrueData
    1.14
    2.35
    69.54
    22.69
    3.17
    1.1

    In
    1
    1.1
    1.2
    1.3
    1.4
    1.5
    1.6
    1.7
    1.8
    1.9
    2
    2.1

    Spline
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!

    2.2
    2.3

    #VALUE!
    #VALUE!

    2.4
    2.5
    2.6
    2.7
    2.8

    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!

    Page 1

    Sheet1

    le in this workbook. An example of how using the cubic_spline function works is shown below. In
    n the "Export Spline function to other open workbook" button on this worksheet. In the form that
    tton on the form to transfer the function code.

    ut data, and single point that you want the spline evaluated for.

    ot in any
    their own

    Spline Example
    100

    Output

    90
    80
    70
    60

    Spline

    50

    T rueData

    40
    30
    20
    10
    0
    -10 0.5

    1.5

    2.5

    Input

    Please visit my website for comments and questions!

    http://www.srs1software.com
    Register you this freeware at:

    http://www.srs1software.com/cs_registration.htm

    Page 2

    Interpolate Excel Function: : Interpolate from XlXtrFun


    http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm
    The author does not make or imply any claims about the functionality of this software and is not in any
    way responsible for any damage, direct or indirect, caused by this product. The user uses it at their own
    risk.

    Example of usage:
    True Data

    100

    Interpolate Estimates

    90

    TrueData
    1.14
    2.35
    69.54
    22.69
    3.17
    1.1

    In
    1
    1.1
    1.2
    1.3
    1.4
    1.5
    1.6
    1.7
    1.8
    1.9
    2
    2.1

    Interpolate
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?

    2.2
    2.3

    #ADDIN?
    #ADDIN?

    2.4
    2.5
    2.6
    2.7
    2.8

    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?

    80
    Output

    In
    1
    1.4
    1.7
    2
    2.5
    2.8

    70
    60
    50
    40
    30
    20
    10
    0
    -10

    0.5

    t in any
    their own

    Interpolate Example

    100
    90

    Output

    80
    70
    60

    Interpolat
    e

    50

    T rueData

    40
    30
    20
    10
    0
    -10

    0.5

    1.5

    Input

    2.5

    Interpolate Excel Function: Interpolate from XlXtrFun


    http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm
    The author does not make or imply any claims about the functionality of this software and is not in any
    way responsible for any damage, direct or indirect, caused by this product. The user uses it at their own
    risk.

    Example of usage:
    In
    1
    1.4
    1.7
    2
    2.24
    2.36
    2.5
    2.8
    3.15

    90

    Interpolate Estimates
    TrueData
    0.8
    1
    1.2
    2
    80
    10
    2
    2
    1

    In
    1
    1.1
    1.2
    1.3
    1.4
    1.5
    1.6
    1.7
    1.8
    1.9
    2
    2.1

    Interpolate
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?

    2.2
    2.3

    #ADDIN?
    #ADDIN?

    2.4
    2.5
    2.6
    2.7
    2.8
    2.9
    3
    3.1

    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?

    Output

    True Data

    100
    80
    70
    60
    50
    40
    30
    20
    10
    0
    -10 0.5

    t in any
    their own

    Spline Example

    100

    Output

    90
    80
    70
    Interpolat
    e

    60
    50

    T rueData

    40
    30
    20
    10
    0
    -10 0.5

    1.5

    2
    Input

    2.5

    3.5

    Spline Excel Function: spline from XlXtrFun

    The author does not make or imply any claims about the functionality of this software and is not in any
    way responsible for any damage, direct or indirect, caused by this product. The user uses it at their own
    risk.

    Example of usage:
    In
    1
    1.4
    1.7
    2
    2.24
    2.36
    2.5
    2.8
    3.15

    90

    Spline Estimates
    TrueData
    0.8
    1
    1.2
    2
    80
    10
    2
    2
    1

    In
    1
    1.1
    1.2
    1.3
    1.4
    1.5
    1.6
    1.7
    1.8
    1.9
    2
    2.1

    Spline
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?

    2.2
    2.3

    #ADDIN?
    #ADDIN?

    2.4
    2.5
    2.6
    2.7
    2.8
    2.9
    3
    3.1

    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?
    #ADDIN?

    Output

    True Data

    100

    80
    70
    60
    50
    40
    30
    20
    10
    0
    -10 0.5

    t in any
    their own

    Spline Example

    100

    Output

    90
    80
    70
    60

    Spline

    50

    T rueData

    40
    30
    20
    10
    0
    -10 0.5

    1.5

    2
    Input

    2.5

    3.5

    You might also like