Dibatalkan

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.

Kemahiran: Excel, Visual Basic, Pemprosesan Data, Pengaturcaraan C, Matlab and Mathematica

Lihat lagi: 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

Tentang Majikan:
( 21 ulasan ) Private, Australia

ID Projek: #22623979

Dianugerahkan kepada:

SShtv

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 Lagi

$200 AUD dalam 5 hari
(87 Ulasan)
6.0

10 pekerja bebas membida secara purata $171 untuk pekerjaan ini

usmanhassan123

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 Lagi

$200 AUD dalam sehari
(88 Ulasan)
6.3
vsprybhanu

"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 Lagi

$180 AUD dalam 3 hari
(88 Ulasan)
5.7
daniyal3214

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 dalam sehari
(54 Ulasan)
5.5
polite90

I skilled in VBA and have rich experience

$150 AUD dalam sehari
(7 Ulasan)
4.4
mowachira77

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 Lagi

$150 AUD dalam sehari
(11 Ulasan)
3.4
Bram1371

Hi Alex. I'm Bram. How are you? Thanks for looking over my bid. I am a professional web developer and I have over 6 years of working experience. I have the ability to complete your project. I can do it absolutely if yo Lagi

$150 AUD dalam 7 hari
(2 Ulasan)
1.5
furkancakir

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 Lagi

$200 AUD dalam 2 hari
(0 Ulasan)
0.0
$166 AUD dalam 10 hari
(0 Ulasan)
0.0
$166 AUD dalam 10 hari
(0 Ulasan)
0.0