Kapalı

Speed up Excel Macro or convert Excel Macro to another language

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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Java, Visual Basic

Daha fazlasını görün: improve excel 2016 performance, calculating 4 processors excel 2016, excel speed test spreadsheet, improve excel performance with large files, creating vba macros to manipulate worksheets in excel 2013, how to speed up excel processing, excel performance test, how to speed up excel 2013, convert number excel macro, convert txt excel macro, convert pdf excel macro, excel macro copy data excel paste internet explorerer, excel macro convert xls txt, excel macro parse html excel, sample excel macro code filling excel sheets

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #16293572

23 freelancers are bidding on average $167 for this job

katilinas

Dear Employer, I'm ready to work on "excel macro speed up" project. Relevant Skills Leads, Excel, VBA, Data Scraping Milestones 146 USD - code writing 36 USD - userfriendly interface I have samples of work very si Daha fazlası

in 3 gün içinde182$ USD
(103 Değerlendirme)
6.2
suyashdhoot

Hi I am a very experienced statistician and programmer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done p Daha fazlası

in 3 gün içinde250$ USD
(44 Değerlendirme)
6.1
tumakha

Dear Customer, My name is Yuriy Tumakha. I can implemented the best possible solution as Scala web app. Java 8 should be installed. I am Senior Scala/Java Developer with 14 years of experience. You can see my code Daha fazlası

in 7 gün içinde550$ USD
(16 Değerlendirme)
5.4
satishtl

- Went through the excel file Loop Data [url removed, login to view] and getting to the combinations in H3-N3. Clicked on the "Get Combinations: on the organized tab I think it flashes for every race data and the R2 being calculated Daha fazlası

in 10 gün içinde350$ USD
(41 Değerlendirme)
5.3
rumarahman

Hi, I saw the xlsm file with a lots of coding. I would have to understand the codes and then modify it. So far I saw, I can speed it up 30-35 times than now it is. I have 10 years experience with Data Processing Daha fazlası

1 gün içinde 100$ USD
(31 Değerlendirme)
4.9
whitehorsetechn

Greeting, I have understood your Speed up Excel Macro or convert Excel Macro to another language task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of e Daha fazlası

in 3 gün içinde200$ USD
(11 Değerlendirme)
4.5
rinabuoy13

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

in 3 gün içinde222$ USD
(22 Değerlendirme)
4.3
FerriSoft1

Hi Excel is extremely slow at doing individual cell reading/writing value. I've done bulk cell operations in the past tha can accelerate up to 1000x, don't know if this is a case in which bulk operations can be done Daha fazlası

in 3 gün içinde155$ USD
(7 Değerlendirme)
3.7
vmadhavan15

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..

in 3 gün içinde200$ USD
(10 Değerlendirme)
3.8
in 2 gün içinde150$ USD
(10 Değerlendirme)
3.3
fastcoder007

Hi, I am a Java/J2EE developer since last 4 years working in one of the world's biggest MNC IT conpany. I have experience working on Web Design/Development in AngularJs/jQuery/JSp/Servlet/Spring-Hibernate and Java. Daha fazlası

in 5 gün içinde111$ USD
(8 Değerlendirme)
2.7
yyer

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.

in 7 gün içinde111$ USD
(1 Değerlendirme)
0.9
dungforever

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!

in 2 gün içinde100$ USD
(1 Değerlendirme)
0.4
in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
nswebdeveloper

Hey, I am a professional Web Developer with having an more than 8+ years of experience as a web development. I have developed many projects in Codeigniter, Laravel, YII2 and different kinds of open source technologi Daha fazlası

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
1 gün içinde 55$ USD
(0 Değerlendirme)
0.0
xpertsols6

Hi, i am a full stack mobile & web dev having similar technical skills & experience & have already worked on a similar project before so can do this Ref : [url removed, login to view] Great exp Daha fazlası

in 3 gün içinde194$ USD
(0 Değerlendirme)
0.0
premsingh488

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.

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
BeyoutiF00L

We can deliver this project fast as I have a well trained team at my disposal. And you can rely on us for complete satisfaction

in 2 gün içinde30$ USD
(1 Değerlendirme)
0.0