Excel/VBA : Spline (Extrapolation/Interpolation) Function

*** SUMMARY ***

This project will require the creation of a spline function. The function will have 3 parameters:

1) The point coordinates (as X and Y)

2) A switch to turn on/off over/under-shooting

3) The known X value

The function will return the Y value of the requested X in the parameter.

*** DETAILS ***

It is essential that the spline function can create the simplest possible curve to connect through all the points. For example: If the points provided were the edges of an semi-octagon, then the resulting spline should look like a perfect semi-circle (see picture).

The spline will NOT loop back in on itself or close shape.

You will be provided with a template spreadsheet where the input data points can be entered. This spreadsheet will already have a graph included so that you can test your VBA code. Your code will need to generate 2000 rows of interpolated points. Your code should be capable of accurately returning an extrapolated point also. If you don't want to use VBA that's fine, so long as your code can output the Y data so it can be copied into the spreadsheet.

*** EXAMPLES ***

The three images provided show the kind of results expected:

"Curve [login to view URL]" - Shows how perfect and smooth a semi-circle shape the spline must create from the given points.

"No [login to view URL]" - Shows how the spline will not shoot over the 4th and 5th point when 'under/over-shooting parameter' is turned off, and not wobble between the 4th and 5th point.

"Straight [login to view URL]" - Shows how straight the line should be on a diagonal.

*** POLICY ***

Maximum budget for this project is AUD$200 (no negotiations).

Important Note !!! : There will NOT be any partial payments for incomplete work or imperfect results. For security reasons, you will need to supply the source code, not executable, for us to test.

To prove that you have read this project outline and are not using an automated reply tool, please say "Hi Alex" at the top of your bid message.

Habilidades: Excel, Visual Basic, Processamento de dados, Programação C, Matlab and Mathematica

Veja mais: excel vba input function, free examples finance function excel vba cost price, excel vba resize images, cubic spline interpolation excel, interpolation.xlam download, cubic spline extrapolation, linear interpolation excel, monotone convex interpolation excel, exponential interpolation excel, polynomial interpolation excel, excel interpolate missing values, saving embedded images excel vba, excel vba find minimum function min simplex, excel vba call function external application, function erlang traffic formula excel vba, excel vba max function, excel vba rank function write, excel vba function return blank cell, excel vba check blank function, excel vba function return blank null

Acerca do Empregador:
( 21 comentários ) Private, Australia

ID do Projeto: #22623979

Concedido a:


Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience in processing and analyzing data in Excel, including performing tasks simi Mais

$200 AUD em 5 dias
(91 Comentários)

8 freelancers estão ofertando em média $177 para esse trabalho


Hi Alex. I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development. I already done many projects of: • Excel Automation. • Excel Reports sys Mais

$200 AUD em 1 dia
(91 Comentários)

"Hi Alex" Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Mult Mais

$180 AUD in 3 dias
(90 Comentários)

Hi Alex, I can definitely help you with that. I am a professional Data Scientist and hold expertise Statistics and Finance. I will be happy to discuss in detail how I am highly suitable for this project.

$150 AUD em 1 dia
(58 Comentários)

Hi Alex, I have carefully read your project descriptions and am sure to deliver on your results. I have 5 years of experience in excel and VBA. I will deliver quality work in two days only. I am available to start your Mais

$150 AUD em 1 dia
(16 Comentários)

Hi Alex. Hi. I'm Mechanical Design Engineer and Expert in Specialized/Complicated Machine Design, CAD, 2D, 3D, Macros, Product Design, FEA Analyzes, DFM, Technical Drawing with Dimensions, Interior/Exterior Design, Ph Mais

$200 AUD in 2 dias
(0 Comentários)
$166 AUD in 10 dias
(0 Comentários)
$166 AUD in 10 dias
(0 Comentários)