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

Voir plus : c function, sixth order spline function, row column components, excel increment row column, table column gridview row, gridview table row column

Concernant l'employeur :
( 0 commentaires ) Qatar

N° du projet : #12649353

21 freelance ont fait une offre moyenne de 234 $ pour ce travail

esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and Plus

778 $ USD en 12 jours
(15 Commentaires)
7.0
252 $ USD en 7 jours
(89 Commentaires)
6.3
XeeChaun

hi. I have 3+ years of experience with ExcelDna. I have done a number of projects using ExcelDna. you can see my posts in ExcelDna google group (with name Zeeshan). I have built UDFs and Ribbon add-ins. following are t Plus

220 $ USD en 5 jours
(48 Commentaires)
6.1
manhpham

My name is Manh from Vietnam. I read your project details and I am sure I can complete your project.Can we can chat/discuss further on your project?

155 $ USD en 3 jours
(62 Commentaires)
5.7
FrozenMem

Hello, I'm an expert C# developer. I have solid experience working with MS Office automation related-works, and have done many similar projects in the past. Your project is interesting and I would like to help you Plus

222 $ USD en 2 jours
(42 Commentaires)
5.6
266 $ USD en 5 jours
(37 Commentaires)
5.2
matlabconsulting

I have a strong academic career. Note: Price and duration depend on the project. I am looking forward to hearing from you. Best Regards

277 $ USD en 15 jours
(3 Commentaires)
5.0
200 $ USD en 15 jours
(16 Commentaires)
4.4
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

200 $ USD en 3 jours
(2 Commentaires)
5.1
mrshahidlatif

I have recently completeed a project on bsplines. visit my profile page for that.. my code was used in excel. we can discuss details. thanks

277 $ USD en 5 jours
(14 Commentaires)
4.1
abhinovpankaj

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with vari Plus

200 $ USD en 5 jours
(9 Commentaires)
3.3
222 $ USD en 3 jours
(2 Commentaires)
2.0
israrsoft

Hello there, Monali this side from India. Thank you for posting the project, I have studied your requirements I Have 8+ years of exp in the same field and I Have a great portfolio as well. Skills: - Asp.ne Plus

155 $ USD en 3 jours
(5 Commentaires)
2.6
rakib5106

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
origami07

Hello, I have been writing programs for 4 years. I have done many projects in AI, machine learning and statisitics. Regards, Steven

155 $ USD en 3 jours
(0 Commentaires)
1.6
mvish88

Dear Employer, Hire me, I can do this project. I am experienced electronics enthusiast working in the field since 8 years. My work area includes Computer Software, Embedded Systems (Hardware & Software), Analog & Plus

233 $ USD en 15 jours
(0 Commentaires)
0.0
277 $ USD en 3 jours
(0 Commentaires)
0.0
Nostrianemos

Υes, I can do well this work with speed in the creation, testing the accuracy of data capture, quality of visualization, acceptance of non-payment if you are not happy from work

155 $ USD en 10 jours
(0 Commentaires)
0.0
KirillZamula

Hi, I'm .Net Developer. Now I work in international company in Ukraine. I have enough experience to do this job. During my career I've worked with T-SQL, .Net, WPF, Entity Framework, DevExpress, ASP.NET, MQL and oth Plus

133 $ USD en 7 jours
(0 Commentaires)
0.0
150 $ USD en 300 jours
(0 Commentaires)
1.0