I need someone with VB.net experience to write some code in VB.net 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 VB.net, 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.
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.
11 freelancers are bidding on average $145 for this job
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
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,
What will the dataset (X,Y) be read from the user input (you choose not to use Excel)? I code in vb.net and I understand the regression analysis and would like to have this challenge. Regards. (From Rifki)
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