I currently have an excel spreadsheet where I run a macro to find the best possible combinations, I think the total number is 144 Million different combinations. I need to run through all these combinations(Cells H3-N3) to figure out the best possible combinations(finding which combination leads to the best ranking correlation(Cell R2)) for finding historical data points. If you look at my attached spreadsheet you can see on sheet Organized when you run the Get Combinations button, it slowly starts to calculate the combinations and I get anywhere from 8-12 combinations a second. I need this to be around 300-400 combinations a second. Maybe its possible to ingest the excel document in Java and run it from memory or possibly another method. I am very open to whatever will produce the best results and fastest combinations.
21 freelancers are bidding on average $164 for this job
Hello friend, I am experienced software developer and engineering in field optimisation. I can help you with this task. Looking to hearing from you. Regards
I am not a random bidder. I have 14+ years of exp with various proejct exposure.. Please ping me if you are interested with my proposal and thank you... I would like to do this one..
I can try to migrate your task into Python engine. Success is not garanteed, because of unknown (for me) algorithm. So my bid is only suggestion. We shall try and see.
Hello! I read your requests. I have a full of experiences in Data Processing and Coding. I've finished many projects like this. I can complete your project clearly. Hope your kind contact. Thanks!
Hi There, I have more than six years of experience in MS Excel, MS Access, and VBA. I can help you to speed up the program by using the Array, Dictionary, Class etc.
I have extensive experience working with this type of process. I can look at the calculations and either work on improving them or I can perform them in a language with faster runtimes like C++, Java, or Python.