Fermé

Cubic spline function in C#

Hello,

I need a smoothing spline function for use in Excel.

1) it is to be written in C# using Exceldna (independent project to integrate .NET into Excel)

2) you are expected to deliver the function as both the code so I can see the method as well as create the xll file in Visual Studio myself, and also the xll file itself and an excel file with a working example.

3) the inputs to the function should contain at least the following:

a) PeriodRange

b) PricesRange

c) Period

d) Smoothing parameter is between 0 and 1.

The PeriodRange will take in a column or row range that has the following inputs:

a) a date in normal excel date format, the date must be the first of a month, if not, the function needs to give an error message.

b) a calendar quarter reference in the following format "Q1 2017". If not in this format then the function needs to give an error message.

c) a calendar year reference in the following format "2017". If not in this format then the function needs to give an error message.

d) Smoothing parameter is between 0 and 1. If outside this range then the function should return an error message.

The PricesRange are all decimal e.g. 100.35 and could be positive or negative.

The Period is the date that the cubic spline function returns the value for. The date must be the first of a month, if not, the function needs to give an error message

The spline curve needs to maintain the averages of the calendar quarters and years.

The PeriodRange will typically be the first few months including the current month, the next few calendar quarters and the next few calendar years. The exact selection will often vary so the function should be able to adapt to that.

The code needs to be very fast as it will be ran about 2000 times per second.

Thank you

Compétences : .NET, Algorithme, Programmation C#, Mathématiques, Statistiques

en voir plus : c# function, c++ function, c function, cubic smoothing spline, spline function, spline cubic, cubic spline, cubic spline interpolation algorithm java, cubic spline java, cubic spline game, cubic spline interpolation java, netbeans library cubic spline, cubic spline matlab, 1406 data column products_name row, sixth order spline function, row column components, php can display database table row column, excel column entry proper function vba macro samples, excel increment row column, customize gridview merge column row, table column gridview row, extjs grid column click function, row column increment vba macro, gridview table row column

Concernant l'employeur :
( 0 commentaires ) Sydney, Australia

Nº du projet : #12632565

15 freelance font une offre moyenne de $201 pour ce travail

samitXI

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(163 Commentaires)
7.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(143 Commentaires)
6.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(90 Commentaires)
6.3
szymszteinsl

Hi! I am professional C/C++/C#/Java/Python programmer. I can do this project with highest quality! Best Regards, Szymszteinsl

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(40 Commentaires)
6.2
qprotex

Dear Client, My name is Miguel Febres and you can find my CV and certifications in the following links: [login to view URL] [login to view URL] I have many years of exper Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
5.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(51 Commentaires)
5.4
WeazenSoft

Hello Respected Sir/Madam, We have a team of Microsoft Certified Solution Developer (MCSD) and Design & Development and I have more than 7 years experience in software development and web development using Microsof Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(10 Commentaires)
5.0
nittilegupta

Hello, I have rad and understood your requirement. I can surely complete this job with high confident, I have huge experience and expertise in C# & .NET programming. I have worked on more than 300 projects and I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)
5.9
hawkscodeaus

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
5.1
abhishekmodgi

I have 5 years of experaince as a web application developer developing web application using C# asp.net Sql.I have worked on html5 css3,javascript related libraries,angular js and jquery for past 2 years and have a goo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
2.9
preciousinfoway9

Hello There, Vaishali here from Precious Infoway. I had gone through your RFP very carefully and thanks for giving a detailed description of your project. One thing i had lik Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
cracken

Hi, Delivering the task with quality is my goal. My skills fit perfectly to the kind of task you are looking for. In fact, I had delivered tasks to my satisfied clients that is related to this job. You can con Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
2.2
engmalaa

Hello Sir I have the required experience and team to do that project in time and budget. Please check my profile.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
HygorLBM

Hi, I'm offering in this project since I'm used to Math programs (used a lot in university and personal projects) and know how to build splines from data. I'm asking for 5 days since you don't only need a code that de Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0