Image de profil de ccoollavie
@ccoollavie
Drapeau de France Marseille, France
Membre depuis le 3 août 2019
0 Recommendations

ccoollavie

En ligne Hors ligne
Top level engineering degree for mechanical engineering, mathematics, statistics, computer science, AI, Mathematics, and other scientific fields. Passionate about quantum science and astrophysical science, autonomous learner on artificial intelligence models, ... I’m also an Excel freak : ask me anything it’s my preferred topic. Here is examples of what I can do in one cell formula and the time I need : - Make a time difference between 2 datetime values while removing nights and weekends in the count : useful for workhour calculations (15 minutes). - Make a single formula converting a text to a barcode 128 code, it’s useful everywhere, just buy a usb laser scanner. Including the checksum char at the end (1 hour). - Search a list of 300+ data (keywords, value) to find if one keyword is present in the target cell text and, if one is found, give the corresponding value (5 minutes) - Count the minimum of (x-y)^2, for x in column C and y in column D, if the values in column A are either 1 or 2, and the values in column B are equal to “2019”. (5 minutes) - Last formula I made for a laboratory : search a table with duplicate lines, find the line where to search the samples list, find the column where the sample “S2342” is present, then find the lines where “Iron” is listed, look in the intersections of this, look if there is a value that is not null, take it, change the coma with a dot and finally convert it into a number. (3-4 hours)...
$40 USD/hr
6 commentaires
2.8
  • 100%Travaux complétés
  • 100%Selon le budget
  • 100%Dans les temps
  • 50%Taux de Réembauche

Portfolio

Avis récents

  • image de ENFSolar Improving the look of the Excel database, $15 $26.00 USD

    “the work is fine and completed in time”

  • image de James H. Project for ccoollavie $25.00 USD

    “Simply great to work with. Consider him to be a part of my team now.”

  • image de Frank H. Project for ccoollavie $60.00 CAD

    “awesome work and great freelancer”

  • image de James H. Excel Expert $50.00 USD

    “Very responsive, really understood what I was looking for, and found the most clean and simple solution that does exactly what I need. Communicates very well, and takes the time to understand what you need. Great turn around. Saved me $450.00 on this project, and I'll be using a lot more. Thank you!”

  • image de Tainy K. Excel macro $65.00 USD

    “Always a pleasure working with him, very patient and super knowledgeable about how to use excel to solve real life problem. I couldnt recommend him enough again one of the very best on freelancer!!!”

  • image de Tainy K. Excel project $30.00 USD

    “One of the very best freelancers !!!! Very deep knowledge of excel and great problem solving skills”

Vérifications

  • Connecté à Facebook
  • Freelance Préféré
  • Paiement vérifié
  • Téléphone Vérifié
  • Identité Vérifiée
  • E-mail vérifié

Mes meilleures compétences

Voir des freelances similaires