I gang

Interpolation Add-In for Excel (C++)

Interpolation Function - mdInterpolate

I need a fast interpolation function to be used primarily in big Excel sheets. The syntax is described below.

Main focus is performance. It needs to be very fast since inputs will be continiously updating realtime financial data.

Coding language shall be C++. I will not only need a working xll file but also the code files to make adjustments if necessary.

mdInterpolate(x-Inputs,y-Inputs,x-Value,[Interpol_Method],[Interpol_Power],[Extrapol_Method],[Extrapol_Power],[Sort_Inputs],[Missing_Inputs],[Error_Inputs])

Parameters

x-Inputs double obligatory

y-Inputs double obligatory

x-Value double obligatory

Interpol_Method string optional

Interpol_Power real optional

Extrapol_Method boolean optional

Extrapol_Power real optional

Sort_Inputs boolean optional

Missing_Inputs boolean optional

Error_Inputs boolean optional

Requirements

as fast as possible since being used multiple times in huge spread sheet

written in C++

C++ Project Files required for later adjustments

available as C++ function and as Excel function through Add-in (.xll)

x-Inputs

Range of values with no headers

can be vertical or horizontal in Excel Sheet

number of data sets please see Sort_Values

y-Inputs

Range of values with no headers

can be vertical or horizontal in Excel sheet

same length as x-Inputs

x-Value

valid Number to calculate y-Value

Interpol_Method

linear

previous nearest lower value

closest nearest value

next nearest higher value

lagrange see link: [url removed, login to view]

cubic spline see link: [url removed, login to view]

akima see link: [url removed, login to view]

hermite

... more methods are welcome if at hand

Interpol_Power

one number to determine smoothness of curve if method requires it

meaningful default value should be chosen

Extrapol_Method

can differ from Interpol_Method, same Methods shall be available

default is same as Interpol_Method

Extrapol_Power

one number to determine smoothness of curve if method requires it

meaningful default value should be chosen

if not given, value from Interpol_Power should be used if same method

Sort_Values

TRUE x-Inputs don't need to be in order (default setting)

FALSE x-Inputs need to be in order

Input data usually comprises no more than 50 data sets but will also be used with up to 1,000 data set

Maybe different sort methods depending on size of input make sense to increase speed.

Missing_Values

TRUE value can be missing in x-Inputs and/or y-Inputs at any position; data set will be excluded (default) FALSE no missing values are allowed

Error_Values

TRUE value can be any Error in x-Inputs and/or y-Inputs at any position; data set will be excluded

(default)

FALSE no missing values are allowed

Færdigheder: C++ Programmering, Excel, Matematik

Se mere: akima interpolation excel, interpolation excel, linear interpolation, excel interpolation add, double interpolation excel, akima interpolation, excel sheet interpolation, excel double interpolation, interpolation excel add, excel sheet curve spline, akima curve interpolation excel, interpolation excel sheet, syntax programming, string cplusplus, sheets add, programming methods, programming language syntax, programming language speed, programming language performance, make spread sheet, linear programming project, function programming, focus programming language, excel data programming, excel add programming

Om arbejdsgiveren:
( 0 bedømmelser ) Copenhagen, Denmark

Projekt-ID: #954824

12 freelancere byder i gennemsnit $361 for dette job

deadhunt

Please check PM.

$250 USD in 10 dage
(35 bedømmelser)
5.3
Algotrade

I can do it for you!

$500 USD in 7 dage
(13 bedømmelser)
4.3
knix

Pls see pmb, regards.

$200 USD in 7 dage
(3 bedømmelser)
3.9
JohnBHarris

I have stacks of experience programming in C++ and in VBA for Excel automation. I also have a Maths degree and a good deal of experience with both simple and more complex interpolation procedures. I would write a Win32 Mere

$200 USD in 5 dage
(1 bedømmelse)
2.4
cycada

I can do it for you

$100 USD in 3 dage
(1 bedømmelse)
1.0
mathprog

I'll do the job.

$200 USD in 10 dage
(0 bedømmelser)
0.0
georgedegennaro

Please see my personal message. Thank you for considering me and hope to be working with you soon!

$200 USD in 14 dage
(0 bedømmelser)
0.0
hysysadvisor

I already made a simple linear interpolation function using VBA(XLA add in file) it's form is Interpolate(x as double, ran as range) as double.x is the value of x and ran is the range of your function as x values is th Mere

$30 USD in 2 dage
(0 bedømmelser)
0.0
hegazy

I developed intrpolation and extra polation with C several times on several platforms. I also developed many MS Office add-ins. Can offer different levels of accuracy.

$1500 USD in 10 dage
(0 bedømmelser)
0.0
kaizen564

THE REQUIRED INFRASTRUCTURE BOTH EQUIPMENT AND EXPERTIZE IS AT OUR STRENGTH ,CAN DELIVER SUCCESSFULLY THIS PROJECT SKILLED PERSON IN C++ .VISUAL BASIC AND MS EXCEL IS GOING TO DO THE JOB SO NO TROUBLE IN EXECU Mere

$350 USD in 15 dage
(0 bedømmelser)
0.0
fahadee

Hi there, I am extremely interested in this project and believe I could provide you with what you are looking for. I have just done my bachelors in electronics engineering and have a good command in C++. Please hire me Mere

$400 USD in 10 dage
(0 bedømmelser)
0.0
Mulukkano

Dear Sir, I am very strong at C/C++, Algorithm and Mathematics. I have experiences writing dll with Visual C++ 2008. The dll can be invoked from excel spreadsheet. Thank you very much. Best Regards, Sayed Mulkhan Mere

$400 USD in 5 dage
(0 bedømmelser)
0.0