Create A Match Macro

Public Clarification Board

• 
  Contest Holder

  • 4 years ago

  Good morning. In the next 8 hours ill be providing an addon that a top entries have already done. This award can only go the really fastest. But seeing very top entries that seperate per milliseconds. Those who participate on the addon will also be declared additional winners that maintain the same consistency. More information later given in private.

  • 4 years ago
• 
  Contest Holder

  • 4 years ago

  Still reviewing entries. Will continue in the next 8 hours and provide direct feedback.

  • 4 years ago
  1. 

     Zatisme

     • 4 years ago

     Hi Mr. Ropert, I would like to know if you checked the private message I sent to you and thanks a lot for your kindness.

     • 4 years ago
• 

  reubengi

  • 4 years ago

  do you have standard template with 10 length string? You have attached only a 3 length string template.

  • 4 years ago
  1. 
     Contest Holder

     • 4 years ago

     You may use the same amount of data currently. Use random data for length of 10 for your own testing. Use data that can easily be matched and share your perfromance. But the matching need to suppot 1-10 string. THe setup was 1000x120 if not mistaken as per rows and columns. Use same amount.

     • 4 years ago
• 

  saif12me

  • 4 years ago

  please check entry #77 (optimized again)

  • 4 years ago
• 

  Farrukh Saeed

  • 4 years ago

  updated #76

  • 4 years ago
• 
  Contest Holder

  • 4 years ago

  Would like to inform that some entries that are considered TOP will likely get a addon to further analyze your performance. You may be given an opportunity to an addon because I see your entry giving strong performance. Not really required but puts your entry into my personal list for projects even if the contest is not won by you for being the fastest.
  
  Your entry star rating will be based on performance.
  1 Star = Slow Screenshot Performance with not accurate results.
  2 Star = Your Screen Shot Performance with not accurate results
  3 Star = Slow Screenshot performance with Accurate Results
  4 Star = Your Screenshot performance with accurate results.
  5 star = Verified Top Performance and completing the addon keeping the consistency.
  
  Award will go to the 5 Star entry that maintains Top performance with the addon shared directly to the entry owner. All 5 Star ratings will be included on my personal list for projects. even if not the fastest to get the award.
  
  Good luck to all.

  • 4 years ago
  1. 
     Contest Holder

     • 4 years ago

     Those who have slow computer may let me test it. Depnding on time your file will be rated from 3-5 depending on speed range.

     • 4 years ago
  2. 

     blui88

     • 4 years ago

     thanks for update, sir.

     • 4 years ago
• 

  Farrukh Saeed

  • 4 years ago

  review #61

  • 4 years ago
• 
  Contest Holder

  • 4 years ago

  Like to inform all entries submitted the contest has been extended due to slight misunderstandings. No more entries at the end of the contest. Review the document to ensure you are upto date.
  
  All Entries before 52 will not be tested. Submit new screenshot with the 3 String and 10 String Test as per requirements in the document. That way everyone is on the same page. Some entries already meet the requirements but I need both screenshots to consider reviewing your entry.

  • 4 years ago
• 
  Contest Holder

  • 4 years ago

  The contest is open again and resume reviewing entries in 6hrs. I will then provide feedback for misunderstandings and give a chance for all entries to make a final release addressing common misunderstandings from the description and will rate all entries within 48-72 hours.
  
  I will provide info later as I review the entries and give everyone the same chance I gave to older entrance to make corrections.

  • 4 years ago
• 

  sourabhg98

  • 4 years ago

  Hey there! Not sure on what basis were top 3 entries selected? I did not even share my code for you to check the execution time? Could you please clarify? Are these top 3 entries for some different contest?

  • 4 years ago
  View 1 more message
  1. 
     Contest Holder

     • 4 years ago

     No match entries were reviewed. Closing up my other contest and then fully reviewing the entries and providing feedback to make a final revisions if were wrong.
     
     The timing of the matching will be the main thing ill be looking at.
     
     Good night for now. Will provide an extra 24 hours before making the final call after everyone is clear as to how the entries will be rated. But basic requirements were on the description.

     • 4 years ago
  2. 

     sourabhg98

     • 4 years ago

     Ohh alright, thank you for the clarification!

     • 4 years ago
• 
  Contest Holder

  • 4 years ago

  Sorry this Contest Award is an Error. Will need to reopen. It was for a different contest.

  • 4 years ago
• 
  Contest Holder

  • 4 years ago

  Top 3 go to the following Freelancers
  1ST PLACE - Ger V. @ 1.77
  2nd Place - Excel E. @ 2.44
  3rd Place - Saif L @ 2.6
  
  Tests performed were consistent on all value changes.
  
  Congrats to the winner and all those that participated. Hope it was maybe a learning experience for you on your skill set.

  • 4 years ago
• 
  Contest Holder

  • 4 years ago

  Contest to be reviewed soon. Closing on another contest that many have contributed.
  
  To make it fair will review all entries. And allow final revisions to make it fair with the newer entries that did not get feedback before the contest end.
  
  I will share common issues as per misunderstanding as to my requirements. Your final revision should address the misunderstanding you may have had and properly match in the quickest way possible. The table although is 3 String and has sufficient amount of data. The larger project will require matching of a longer string but at this time concentrated on 3 String.
  
  The person who can match the data as per required will be awarded this contest.
  
  Will follow up with misunderstandings and clarifications for you to address and release a final revision. Make sure to come back and check my comments. Will review current entries and list common misunderstandings. Final review will occur within 24 hours after posting the clarifications.

  • 4 years ago
  1. 
     Contest Holder

     • 4 years ago

     If you did not submit an entry you will not be able to submit for this contest as am now only reviewing those already entered.

     • 4 years ago
• 

  blui88

  • 4 years ago

  I am sorry little it late.
  Can you have some spare time to view my efforts ?
  Video is available at YouTube at
  https://youtu.be/YwsKeESwPFg
  Also may be viewed from google drive.
  https://drive.google.com/open?id=12ltLM1DGi2185VJFmrtxA3Ga9zkLxn1S
  Please review and share your views to improve it more.
  Thanks & Regards
  Santosh

  • 4 years ago
• 

  abdullachennatt

  • 4 years ago

  Please check entry #39

  • 4 years ago
• 

  Farrukh Saeed

  • 4 years ago

  #42

  • 4 years ago
• 

  sourabhg98

  • 4 years ago

  To be fair I guess we need to run the macro on a single machine otherwise it would be a contest of who has the fastest PC and not who has the fastest code. The time taken by the same code can vary greatly depending upon the specs of the machine. I hope this will be taken into consideration?
  
  Would be submitting my entry soon...

  • 4 years ago
  1. 

     sourabhg98

     • 4 years ago

     Also need clarification about whether all the strings will be of a uniform length or can we have strings of different lengths in the same table?

     • 4 years ago
  2. 
     Contest Holder

     • 4 years ago

     You are right. I will be doing tests to finalize who has the fastest matching entry.
     
     At this time we are matching three string only. As mentioned RED = Exact Order Blue = Any order except exact order
     
     Example Red = 123 = 123
     Blue = 123 = 213 231 321 etc except 123
     
     Looking for the fastest entry to optimize my on of my intense projects.
     
     Use your knowledge and whatever excel has to offer to match the entire table. I should be able to change the source values and the values on the table and perform a match for any of the entries.

     • 4 years ago
• 

  EckoOne

  • 4 years ago

  Can you give me a hint why you only rated with 3 stars? What would be needed to get a 5?

  • 4 years ago
• 
  Contest Holder

  • 4 years ago

  Contest is coming to a conclusion very soon. Just want to make it clear to everyone.
  I'm looking for the person who can match the data in the fastest way possible. Use your knowledge with excel to achieve it.
  
  Some asked about VBA and it can be used. Just make sure to share the time of the operation for the matching.
  
  As a contest winner you will also have an opportunity to help with optimizing one of my spreadsheets.
  
  Good luck to all. I seen great entries.

  • 4 years ago
  1. 

     Peefect

     • 4 years ago

     its taking less than 1 second to complete .

     • 4 years ago
• 
  Contest Holder

  • 4 years ago

  ALL ENTRIES. PLEASE USE THE LARGER TABLE.
  Re upload your entry with the timer it take to do the matching.

  • 4 years ago
  1. 

     ranashahed2000

     • 4 years ago

     Hi CH please see entry #21 of complete solution.

     • 4 years ago
  2. 

     abdullachennatt

     • 4 years ago

     Hi Robert,
     Please have a look at entry #27. I have done it with the understanding of the requirement as stated. Please let me know if i have made any wrong assumptions or understanding. I will amend and post required solution.

     • 4 years ago
• 

  blui88

  • 4 years ago

  Hi,
  Is this a second part of previous contest?
  https://www.freelancer.com/contest/Create-A-Macro-1752841.
  Regards

  • 4 years ago
  1. 
     Contest Holder

     • 4 years ago

     yes.

     • 4 years ago
  2. 

     blui88

     • 4 years ago

     thanks Now am getting bit clear about you needs.
     Working on it.

     • 4 years ago
• 
  Contest Holder

  • 4 years ago

  The top entries will need to match a
  10 string as the source. so be ready if you considered the top entry with the 3 string. Aim to get the fastest matching method. tally your matches on top and share the time it took you to do sheet 3 which is 000-999.
  
  thanks for all the participants.

  • 4 years ago
  1. 

     ranashahed2000

     • 4 years ago

     Hi CH please see entry #12 hopefully it is your complete solution.

     • 4 years ago

Show more comments