Profile image of ccoollavie
@ccoollavie
Flag of France Marseille, France
Member since August 2, 2019
0 Recommendations

ccoollavie

Online Offline
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 reviews
2.8
  • 100%Jobs Completed
  • 100%On Budget
  • 100%On Time
  • 50%Repeat Hire Rate

Portfolios

Recent Reviews

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

    “the work is fine and completed in time”

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

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

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

    “awesome work and great freelancer”

  • image of 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 of 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 of Tainy K. Excel project $30.00 USD

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

Verifications

  • Facebook Connected
  • Preferred Freelancer
  • Payment Verified
  • Phone Verified
  • Identity Verified
  • Email Verified

My Top Skills

Browse Similar Freelancers