offline
Last seen: Jun 10, 2014 4:23 PM EDT
Hire Me!
Rate: $40.00 USD/hour
Follow Invite to Project
 

pierreho

Excel VBA Expert, Supply Chain

Username: pierreho

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is verified.

Location: Lyon, France

Member since: November 2012

Reputation:

4.9/5

(34 reviews)

5.6
[see more]

1 user has recommended this freelancer.

My skills:

My projects:

  • $150.00 CAD
    5.0
    Profile image for Seller dcmichels

    dcmichels

    Jan 2, 2014

    Absolutely fabulous work- Fast and efficient.

    Project Description:Attached is a spreadsheet with 3 worksheets, 'Macro.xlsx' (described below), as well as your previous work and macro. (How to copy a macro.doc) The first, CSV Export from Excel, shows what the data looks like when I export it from the website...
    [more]
  • [Sealed]
    5.0
    Profile image for Seller wazaata

    wazaata

    Jun 16, 2013

    Nice ,fast and easy.

    Project Description:I'm searching for a way to have Excel look up and return the driving distance for two points using Google Maps. Example: Put 2 cities in excel table and then return me automaticaly the distance between...
    [more]
  • €300.00 EUR
    4.4
    Profile image for Seller RachelNI

    RachelNI

    Jun 12, 2013

    Great job with the assignment- on time and very thorough!

    Project Description:I'd like you to work on the following (if you're still interested): 1) glossary of terms 2) customer reviews of 17 online banks (as if you're a really person who has used the serivices of the listed banks.) The reviews should be short! (60 words or so) Files are once again attached here...
    [more]
  • $80.00 USD
    5.0
    Profile image for Seller iglesias

    iglesias

    Jun 11, 2013

    I and an URGENT request and he provided the solution while the bid as still on. He provided evidence of completion of work to satisfaction ... set a milestone and got the project. Great work,

    Project Description:TEXT TO EXCEL: Vertical Text Records to Horizontal Excel Spreadsheet on Two Columns separated by Pipes Bring Vertical Text Records provided on MS-WORD file to MS-EXCEL and tabulate Horizontally on two text columns...
    [more]
  • $77.00 USD
    5.0
    Profile image for Seller mediawants

    mediawants

    May 23, 2013

    Worked with me wonderfully! Will use again!

    Project Description:I'm assuming this project can be done using Word and Excel. I have a lease agreement that is in Word. The lease has various blank fields like name, start date, end date, phone numbers, etc. These blank fields repeat themselves multiple times...
    [more]
  • €66.00 EUR
    5.0
    Profile image for Seller wcsinc2

    wcsinc2

    May 7, 2013

    Nothing to add. Works quick and to my full satisfaction. Could not imagine a better performance. Thanks.

    Project Description:I need 1 spinnable article -with lots of {word1|word2|word3} elements- with 400 words in french. Topic: aphrodisiaque and our offer. Objective: Press release.
    [more]
  • €220.00 EUR
    5.0
    Profile image for Seller ObiKenobi

    ObiKenobi

    Apr 29, 2013

    excellent and pleasure to work with will hire again !

    Project Description:from a existing database of customers we need a search engine to make a billing form, the searchbar need to auto fill in certain amount of data when the customer is selected (company name, addresse etc.)...
    [more]
  • $30.00 USD
    5.0
    Profile image for Seller JoachimS

    JoachimS

    Apr 19, 2013

    AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

    Project Description:Monthly hour-list in Excel. (for employers to fill in hours day by day). Want to fit all entries for a month on one a4 page. Titles: Employer info Values: Date/start time/end time/hours/location
    [more]
  • $55.00 USD
    5.0
    Profile image for Seller gabrielamo1

    gabrielamo1

    Mar 21, 2013

    Pierre did an outstanding job! He was fast and understood problem right away. He went above and beyond by providing a "how to fix" detailed explanation in case I run into the same problem in the future.

    Project Description:I am a home inspector, and I do not like any of the programs I have tried, so I wrote my own inspection report template. I am not an specialist using Word, but I have learned how to use the basics...
    [more]
  • $250.00 USD
    5.0
    Profile image for Seller dcmichels

    dcmichels

    Mar 15, 2013

    What can I say? pierreho knows what he's doing and is a real professional. Great communication, blazingly fast delivery. We're very satisfied and would use him again, anytime!

    Project Description:Hi Excel Experts! I was wondering if you might help me with an Excel issue I've been having? Perhaps if I describe my issue and attach the files I need help with, you could let me know whether you can...
    [more]
    pierreho has not completed any projects.
  • $30 USD In Progress

    Hi there, I have a current project called Hughesnet Cities. I need it completed in the next 12 hours which means it will require a formula to count the duplicates and put the number in the next column. I know you know how to do this. Are you interested?

    [more]
  • $150 USD Jan 24, 2014

    I m expert in ms excel...i do this nearly about 4 years..i m so tallented...i can do any work which is related whith this...

  • $150 USD Dec 22, 2013

    sent me excel jobs to work i would be able to complete the jobs and satisfy the needer and fully dediated to the work that i have bid

  • ₹9000 INR Nov 11, 2013

    I am Thomas, I am from Kerala. I am looking for a job as herewith attachment on my resume. Once come to realize for me to be looking for a job Non Voice. My skills is MS Office

  • $30 USD/hr Jul 13, 2013

    Hello Pierre,I currently receive about 10 different monthly reports from 3 different countries. These reports relate to employee numbers and different classifications. All reports are prepared by individual site manually then manually combined by each country. One of the countries only has less than 70 employees the other two have about 1000 employees each. I created a master list for those 60+ employees and I am trying to consolidate and have automatically updated reports and hope to then use the same format for remaining two countries. I would like to know whether you would be able to assist with it and what cost do you anticipate to charge based on sample profile of 3 counties with each of about 60 staff so there could be a summary report of 3 countries?Thanks,Bosh

    [more]
  • $40 USD/hr Jun 5, 2013

    BS Business Management

  • $300 USD Apr 16, 2013

    Hello man,I saw your reviews and are pretty good.I know CPA is not your field but since you are from france is there any way for you can help me out in my new project.I need atleast 100 unique download of a famous software called ares from france.I will pay you 3$ in freelancer per download.Ares lets you download movies,music etc and I will pay you after every months end.Are you intrested,since you are from france you can ask your freinds family to download and will get 3$ per download to your account...

    [more]
  • R1750 ZAR Mar 18, 2013

    I require a dental invoice system that uses excel. I have around 100 treatment codes, with each code representing a description and a price. Its simply an invoice with a recording feature that is required. There are around 20 different prices for each code. I would like a drop down box selecting which price list i want and be able to type the codes in column and the desciption and price should show.

    [more]
  • $120 USD Mar 12, 2013

    We are looking for someone to correct or rebuild a Excel file, see attachment; "Green Beans ROI Sample" that must calculate numbers, see "ROI Layout" attachment. This is what i want the end product to resemble after your creative input as a Excel file when completed, But “Important” it needs to be able to export out as a PDF that firmly fits onto a 8 1/2" x 11" sheet of paper with no cell boxes lines showing.Below is explanation for "ROI Layout" with references in "red" pointing to fields needing active.(A) This is where we will type, size/price of our product, or it can be radius buttons that activate a size/price in the box, (A) There are 10 product sizes. 3/4"= $600, 1 inch = $1,500, 1 ½ inch = $2,200, 2 inch = $3,750, 3 inch = $6,200, 4 inch = $8,500, 6 inch = $12,000, 8 inch = $16,000, 10 inch = $22,000, 12 inch = $23,500 the prices are what"s going be calculated like (C) and (D) rows from "A" for example; (A) we put 3/4 = $600, (C) and (D) we will type manually our clients monthly and yearly water bill cost which will calculate across the row at 10% to 40% savings, see attachment; "Green Beans ROI Sample" (E) Sewer yearly/monthly billing row section is to calculate out from 10% to 40% saving, which it not doing NOW "Working" see attachment; "Green Beans ROI Sample" now, of course all will start out as # "0" zero.C, D, E, F is to work from "A" as # dollar numbers across the row.(F) is a add up total of C, D, E rows(G) is to represent how many months it will take the client to pay off the product "Return On Investment" for example, if (A) is, 1" valve costing $1,500 it calculate and divide it up (F) all across the row. Example circled in green "ROI Layout" shows total saving at 10%, is $260 per year for C, D, E, divide that by $1,500 = 5.7 months to pay our product off (G) must represent this calculation across the row. (B) must be centered copy in the 8 1/5 x 11" sheet, which we could edit and add or take out copy , but not much more copy than what you see.(A) "Row field" you may have to invent how it work and effects (G) row after C, D, E, F, which will establish manually.

    [more]
  • $40 USD Feb 12, 2013

    I have an excel file with over 1m records. There are multiple duplicate "Company Names" with different information attached to each. I need to create one file with no duplicates. Basically I need to merge the duplicate rows without losing any information.

    [more]
  • $40 USD Jan 2, 2013

    Hello, I am looking out to automate data entered in the Excel sheet . Also need to prepare a dashboard on Excel as well as powerpointLooking out for people who got expertise in Microsft Excel and Presentation.Details will be shared once the bid is awareded

    [more]
    pierreho does not have any open projects.
    pierreho does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Supply planning Manager

Nov 2008 - Nov 2012 (4 years)

Food industry

Education

Master

Ecole centrale de Lyon

2006-2009

Certifications

BASICS

APICS

Supply Chain certification

Toeffl

English certification

Publications

nothing