*** 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.
8 freelancers estão ofertando em média $177 para esse trabalho
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.