Excel Macro

  • Tila: Closed
  • Palkinto: $50
  • Vastaanotetut työt: 34

Kilpailun tehtävänanto

General Description
In columns A-V you have letters highlighted in Green.
Those letters represent single digits.
Column X-AMI represent a string of letters where the length can be 22.

Your requirements. Fill the inside with the numbers representing those letters as a string.
Please include a timer for your macro to show its run time. Include Mins, Seconds, Miliseconds.

Winner will be the person that can generate the data the fastest.

Suositellut taidot

Julkinen selvennystaulu

  • iworship2006
    Kilpailun järjestäjä
    • 2 viikkoa sitten

    Sorry for the delay in contest. This was a result that had an emergency travel to a foreign country due to family member sick and unfortunately passed away. I will still review the submissions for work on personal projects.

    • 2 viikkoa sitten
  • screenname1
    screenname1
    • 3 kuukautta sitten

    Dear Sir, if I do not consider the random digits column A to V then my processing time is 1999 Mili Seconds but to update the formula in column X6 to AMI100 it takes 1000 Mili Seconds, thats why it took 3000 Mili Seconds to complete the process. This is just for your information.

    • 3 kuukautta sitten
  • danielramirezh
    danielramirezh
    • 3 kuukautta sitten

    Sir, I attach my screenshots and the type of computer I use. Hopefully you could test on a single computer to validate all the answers in the same environment. For me it is very important to have my first job or contest because this way I will be able to generate trust with the rest of the requests from freelancers.

    • 3 kuukautta sitten
  • RuliaDeans
    RuliaDeans
    • 3 kuukautta sitten

    Submitted my entry with screenshots of the code. If people want to learn feel free to message me.

    • 3 kuukautta sitten
  • iworship2006
    Kilpailun järjestäjä
    • 3 kuukautta sitten

    Reminder - Be sure your generated results are able to use 1-22 length.
    I will be looking for speed. To test fairly. I'm going to request some entries to share their via message to properly do the timing. Please insure the timer is included. HH:MM:000

    It may be a close contest but no worries. I will still consider you for being one of the top entries. The objective of the project is to not only see who has the fastest entry but also to help me have some list of great freelancer with whom I will be able to consider for future projects.

    Appreciate all that participate.

    • 3 kuukautta sitten
  • iworship2006
    Kilpailun järjestäjä
    • 3 kuukautta sitten

    For those not understanding. In row A5:V5 we have letters A through V.
    Starting from Row A6 we have values that represent each of those letters.

    From X5:AMI5 we have letter strings that can be 22 in length. Meaning A AB ABC ABCD BCD EBCDEGF.
    The Max length is 22

    You will put the numbers that represent those letters for each row in the fast way possible.
    I'm looking for the entries that generates the table below the fastest.

    The sheet should be set to manual and a timer added to your macro button that times the operation time in Minutes :Seconds:Milliseconds

    • 3 kuukautta sitten
    1. Xpert Solutions
      Xpert Solutions
      • 3 kuukautta sitten

      please review my new entry #2

      • 3 kuukautta sitten
    2. cgullapalli
      cgullapalli
      • 3 kuukautta sitten

      It depends on the RAM Speed also. Some can have 4 GB, Others can have upto 32 GB. So, there must be another weightage to consider for speed.

      • 3 kuukautta sitten
  • AlbertoBarberoIt
    AlbertoBarberoIt
    • 3 kuukautta sitten

    One question sir: After solving your file, will you choose the winner without having the excel file? Or you need first our excel files and only then will you choose the winner? Thanks for your kind answer.

    • 3 kuukautta sitten
  • shahveer121
    shahveer121
    • 3 kuukautta sitten

    Hi, I have submitted newer version of my entry. It at #19 . All the cells have maximum inputs. Code runs in less than 600 msecs.

    • 3 kuukautta sitten
  • Xpert Solutions
    Xpert Solutions
    • 3 kuukautta sitten

    hi please review #8

    • 3 kuukautta sitten
  • shahveer121
    shahveer121
    • 3 kuukautta sitten

    Video Link for my Entry #4 https://www.awesomescreenshot.com/video/3370427?key=f6d25a797d73dddc681760c69bda6355

    • 3 kuukautta sitten
  • shahveer121
    shahveer121
    • 3 kuukautta sitten

    Hello sir, I have added my entry #4 . Its running in 0.3 seconds. I have also attached video link. Please have a look.

    • 3 kuukautta sitten
  • mdsabbirhussain1
    mdsabbirhussain1
    • 3 kuukautta sitten

    If I see an example then I can understand well and I can get you a good feedback.

    • 3 kuukautta sitten
  • mdsabbirhussain1
    mdsabbirhussain1
    • 3 kuukautta sitten

    I didn't get your description well. Can you an example, please.

    • 3 kuukautta sitten
  • elkhalkiayoub76
    elkhalkiayoub76
    • 3 kuukautta sitten

    can you contact me for mor information please :)

    • 3 kuukautta sitten

Näytä lisää kommentteja

Kuinka päästä alkuun kilpailuiden kanssa

  • Ilmoita kilpailusi

    Ilmoita kilpailusi Nopeaa ja helppoa

  • Saat valtavasti töitä

    Vastaanota tonnikaupalla osallistumisia Ympäri maailmaa

  • Myönnä palkinto parhaalle työlle

    Myönnä palkinto parhaalle työlle Lataa tiedostot - Helppoa!

Ilmoita kilpailu nyt tai liity tänään!