Data Scientist: Group formation algorithm in VBA

@schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

@zekovicm

Hi there,I am VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

@dinhfreedom

Dear sir. Your project attracted my attention at first glance, because I've extensive experience in VBA Programming. I'm really confident about your project, and very eager to join your project. If we have a chance to cooperate, I'll do my best to provide wonderful result. Looking forward to your response. Best Regards.

@rinabuoy13

Hello, I am independent, experienced math expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

@dstepanenko

Hello, I'm vba developer with 5+ years of experience and mathematician with a number of publications. Also I'm participant and problem writer of many algorithm competitions (Topcoder, ACM ICPC, etc). I have huge expertise in optimizational problems and combinatorics. Feel free to contact me to discuss any details of the project. Looking forward to hearing from you!

@lightingdavid

Hello. I have good skills in "Algorithm, Data Processing, Excel, Mathematics". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you want me. Contact me please. Thank you. Yang L.

@bhupendrayadav

I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. I can do this work in $20 USD per hour You can get your work done here with highest quality at lowest price. Looking forward to work with you

@xinglong717

Algorithm expert. I have many experiences in algorithm and data structure. I can complete your project successfull. Of course i oerfected in Excel vba. You could get fastest grouping algorithm from me. Thanks.

@peng72083

Hello, how are you? I've read your description and it's easy for me. I have rich experience in VB programming and Mathematics. Could you send me sample excel file and source code? I can start work right now and give you optimized algorithm as you want. Let us discuss in detail via chat. Best regards, Peng.

@arash18k

Hi, we can define criteria for groups wellness, and then developing a mathematical model for choosing the best group (I think this mathematical model should be combination of integer and 0,1 ). And then we can solve this model by heuristic algorithms (like Genetic algorithm, branch and bound algorithm or others)

@safiullahhuss

Having used Excel VBA for Data analysis previously, I would advise against it For very large datasets, I would not recommend using VBA to process the data. Instead you can have a large excel file where your entire data resides, and import it into MATLAB, R or Octave, which are designed specifically for such uses. You may want to assign numeric values to category parameters to ease processing instead of keeping them in text format (some entries may make sense to keep as text). This will aid the classification or binning process significantly. Once the processing is complete you can reorder the data into a new file. If your data is very large, you may want to start thinking about using C or C++ as your languages of choice to write leaner code (this is obviously after you have proof tested your algorithm in the language mentioned previously). However, if you absolutely need to use VBA, you may have to do so smartly in order to not freeze or crash your excel. Feel free to contact me in the chat so we can discuss details.

@RentAGuru

There are different possibilities to tackle this - usually when the search space is huge, you can try to prune it early and not follow permutations that lead to no or bad results if you can determine that early or you settle for good enough, because it's good enough to get a solution that is 97% close to the optimum instead of waiting hours. For that you need algorithms that can search a large solution space and optimize on the found solutions, like a genetic algorithm for example. But this also depends on your exact problem. What does it mean for your problem to have a good set of groups? How do you calculate the quality of a set of groups? I bid the max till I know details and can adjust my bid. best regards.

@NoSonforhim

I have 20 years in Database Developing, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Exccel, VBA VB6, Vb.net, and MS SQL server