In Progress

Create code snippet in VB.Net 2008 to calculate variables for a power curve trendline/regression curve..

I need someone with experience to write some code in that will calculate the variables of a power trendline/regression curve.

See the attached spreadsheet.

I need to take the X/Y of the data range in columns A and B and then calculate the values for "m" and "b". I need to do this dynamically.

See the attached txt file.

Currently I create an excel workbook object, populate the cells, then extract the information. This works fine. This is also part of a larger, more detailed function.

HOWEVER, I want to do this without using Excel or Excel interop. I need to do this solely within VB.Net (not vba). I need to do this for two reasons:

1. I want my application to run without the user needing Excel as a prerequisite.

2. When I run a "goal seek" iteration code snippet, the current method of creating/closing a workbook takes a long time (30 seconds) to run 15-25 iterations. This many iterations should take 0-3 seconds.

When I attempt to pass the array or ranges into an equation in, I of course get errors. So what I am trying to accomplish is beyond my expertise in this realm.

When you bid, please bid competitively and responsibly. If you can't provide what I am asking for please don't bid.

If you have any questions about what I am asking for, please ask before you bid to ensure the project can be completed.

Skills: Excel, Mathematics, Statistics, VB.NET

See more: write ascii code symbols vb net, vb net create autoresponder, vb net create active directory distribution list, vb create thumbnail, vb create stand program, vb create csv, vb create access database sql, sample code pos vb net, php code convert vb net, html code website vb net, folder modified details sql server table code project vb net, excel output regression analysis calculate demand sequence, dynamic data report vb create, code vb net create kml, code project vb net, code projects vb net, code preoject vb net, code converter vb net vb6, code complied vb net dll, code calculator vb net

About the Employer:
( 2 reviews ) United States

Project ID: #11230747

Awarded to:


I am an experienced programmer, with more than 10 years of experience. I understand exactly what you need. I promise you will be satisfied with my work. Thank you for your trust.

$100 USD in 5 days
(18 Reviews)

11 freelancers are bidding on average $145 for this job


I can perform the analysis using any kind of Statistical Software like R, SPSS , MINITAB Eviews Statistica etc I Will perform analysis like , Regression ,Time series ,Panel Data Experimental Designs Factor analysi More

$250 USD in 6 days
(81 Reviews)

Hello Sir i'm an engineer in statistics ans Econometric full of skills and expertise and i can do this work perfectly better than any freelancers since its my specialty and this is what i'm doing for living In fact, More

$277 USD in 7 days
(15 Reviews)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Regards

$98 USD in 3 days
(39 Reviews)

There is possibility instead of reading the values from excel to open a flat file with separators could be csv separated or any other common sign. After loading the values in a array than all the calculations can be co More

$155 USD in 3 days
(4 Reviews)

Dear Project poster, I have the same kind of experience of 5 years. looking for the new [login to view URL] give me the chance to complete this project. Assuring you the 100% Quality and timeliness Thanks,

$88 USD in 1 day
(23 Reviews)

What will the dataset (X,Y) be read from the user input (you choose not to use Excel)? I code in and I understand the regression analysis and would like to have this challenge. Regards. (From Rifki)

$90 USD in 3 days
(8 Reviews)

Hello I can write VB.NET or C# program to calculate power regression coefficients. The input data may be imported from csv, mdb (accdb) files etc. Output graphs will be automatically created using ZedGraph fre More

$120 USD in 5 days
(4 Reviews)

Hello sir. This should be doable very fast. I can do this in VB.NET (whatever version from 2008 to 2015). Looks simple. If you are interested we can discuss more about price and time (both are negotiable). Regards

$111 USD in 3 days
(3 Reviews)

Hi I can write you a small windows forms application to perform this analysis for you in VB.NET (or C# Python if you prefer). I can configure it to load the data from where ever you are sourcing it and the process i More

$166 USD in 3 days
(0 Reviews)

Hi,we're all senior software developers,we've just checked your project requirements,we're able to perform your project and you'll be interesting with us,please come in contact with us to discuss for more project detai More

$155 USD in 10 days
(0 Reviews)

Asalam o Alaikum, During my career, I have gained a wide knowledge and understanding of data collection methodologies, sampling methodologies, multivariate statistical analysis, Principles and techniques. I have out More

$155 USD in 3 days
(0 Reviews)

I have 25 years of experience in developing custom software programming using various tools. I have experience in SQL Server / MYSQL / PHP / C+ / ASP.NET / VB.NET / VB6 / Crystal Reports (versions 4.5 and above) / Ja More

$155 USD in 10 days
(0 Reviews)