offline
Last seen: Jul 08, 2014 9:58 PM EDT
Hire Me!
Rate: $15.00 USD/hour
Follow Invite to Project
 

Pichart

Excel Expert Developer

Username: Pichart

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

Location: Bangkok, Thailand

Member since: July 2011

Reputation:

4.9/5

(28 reviews)

4.9
[see more]

1 user has recommended this freelancer.

My projects:

  • $225.00 USD
    5.0
    Profile image for Seller diness

    diness

    Apr 20, 2014

    He went the extra mile on this project. Awesome.... +++++

    Project Description:Want macro that can read csv file and compare values and move some dato to new sheet.
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller perfumervw

    perfumervw

    Apr 20, 2014

    Excellent - took a few more days than initially expected but Pichart persevered and produced great work

    Project Description:I have a piece of software that I wrote in VB. (see screenshot attached). Full 16-32 bit software: http://www.PerfumersWorld.com/software/Install%20The_Perfumers_Workbook%2010.001.exe 64 bit: http://www.theperfumersworkbook.com/stable/workbook-portable.zip...
    [more]
  • $80.00 USD
    5.0
    Profile image for Seller diness

    diness

    Apr 7, 2014

    Always a pleasure. Can only recommend +++++++

    Project Description:I want to move data from one sheet to another, and do checks and create data based on it. NEED ASAP
    [more]
  • $45.00 USD
    5.0
    Profile image for Seller diness

    diness

    Mar 26, 2014

    ++++++ I can only recommend

    Project Description:Add skip/override list to minimum stock qty spreadsheet. We have now calculations based on sold qty, that works fine. But there will be some products that is different than these standard calculations,...
    [more]
  • $250.00 USD
    5.0
    Profile image for Seller jeanlouis

    jeanlouis

    Mar 24, 2014

    Advanced VBA code ready the same day, and it is elegant, simple to understand VBA code.

    Project Description:In the attached file, 3 sheets: - Compliance Keywords = list of keywords to search (except for row 1 which is column headings). - Source = data to search for, column I Comment. - Compliance Search = where to copy results...
    [more]
  • $40.00 USD
    5.0
    Profile image for Seller diness

    diness

    Mar 22, 2014

    Always a pleasure. 5 stars from me

    Project Description:Little project where i need to compare the two spreadsheets for barcodes (koldlager and lager), if we find match we move the item from spreadsheet (koldlager) to spreadsheet tab (flyt) Okay to match...
    [more]
  • $300.00 USD
    5.0
    Profile image for Seller diness

    diness

    Feb 7, 2014

    Project got a bit bigger than expected but pichart did a very great job.Always a pleasure to work with.

    Project Description:I have a project where i want to calculate my prices similair to module you have made for me before, but I also want to compare these prices to my compettion ( so there will be maybe 5-6 sheets with my compettion prices...
    [more]
  • $27.50 USD
    5.0
    Profile image for Seller diness

    diness

    Jan 21, 2014

    Great work and fast delivery ++++++

    Project Description:Make this priceselling tool work with new nice pricerules - i added new rules but it doesnt work when i run script, also i want cost field to be without tax. so cost field should just be price1 x currency...
    [more]
  • $150.00 USD
    5.0
    Profile image for Seller davidweeksvw

    davidweeksvw

    Jan 9, 2014

    I've worked with Pichart on a number of projects and they've always been delivered on time and to a very high standard. Would highly recommend.

    Project Description:Hi Pritchart, I hope you’re very well and had a good New Year. I have another project I’d like you to look and let me know if you can help. It’s quite similar (but hopefully easier) than the last project you helped me with...
    [more]
  • $55.00 USD
    5.0
    Profile image for Seller diness

    diness

    Dec 20, 2013

    always a pleasure to work with you

    Project Description:Hi again, You made an excel project for me some time ago, i have a few more projects for you. First project will be a macro project. Do you have time to do it?
    [more]
    Pichart has not completed any projects.
  • $150 USD In Progress

    I want to chat with you so i can explain you with examples what I"m looking for.Thank you Ron

  • $15 AUD/hr In Progress

    Sawadee Krap - We have an inventory system Ostendo based on excel and pivot tables. All data can be exported and imported. We need to clean up our product listing, product codes, barcodes, descriptions and finally pricing structures. We need to anaylise product movements and cost of goods etc. We also want to develop a system whereby new products are allocated new barcodes and product codes by sequence. A long project that I was hoping to provide someone with login details that could access our system remotely and clean it up. The is inventory based, and I seen your skills and thought it would suit you.

    [more]
  • $15 USD/hr In Progress

    Hello, I live in lat Phrao , bangkok, I would like to have a simple product database created, connected to a barcode scanner. If the job can be done at our place would be good.

  • $400 SGD 20 days ago

    Dear Applicants, I am hosting a Sports, Fitness and Healthcare Exposition in Singapore. We would like to invite key personnel from certain industries in Thailand to attend my exposition. Like to invite applicants to apply for the following task; 1) To build a set of dbase complete with Malaysia company, address, contact, email address and & contact person detail of certain sports and fitness industry 2) Manager or Directors’ contact in charge of the company 3) To deliver about 1300 companies contacts with corporate email address - corporate or personal. 4) Assignment Timeline is 2.0 - 2.5 months. 5) A weekly progress report must be provided. As the task involved calling to check on Managerial detail within Thailand, we would prefer the applicant based in from Thailand only. Requirement •Own computer•Excel programme•Dedication to complete the required data entry within time line. •Meticulous, neat with spreadsheets•Knowledge of excel is a must•Experience on Online Research is a must In the essence of time, we give priority to applicant who is able to offer full time dedication to complete the task & project. Successful applicants will only be given to those who passed the trial data entry test.

    [more]
  • $150 USD May 26, 2014

    will explain you over the phone

  • $200 USD Sep 10, 2013

    We would like to updgrade an existing Microsoft access system to offer more reporting flexibility.We also would like to develop an Excel quotation system to speed up quotes to clients (semi-automated quote from price list)

    [more]
  • $35 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]
  • $45 USD Nov 7, 2012

    Hi,I want an excel workbook with macros to show sheets depending on password input.The idea is that when someone opens the workbook it would ask for a password. 15 different people are goint to be working with this workbook, but I want them to be able to see and modify only the sheet associated with their password.I have a very basic knowled of macros, but i want to be able to modify it in case i have to add a sheet later on. I also want to be able to modify the passwords.

    [more]
  • £40 GBP Sep 9, 2012

    We have a workbook with two sheets.Sheet #1 contains a table & Sheet #2 picks up a csv from the C:\ drive that is refreshed each time it is opened.The CSV grabs information from a database and is updated each night.The data comes from a restaurant.The restaurant has 8 screens in the kitchen which help automate orders. Each of these screens belong to a particular station in the kitchen ie. Grill, Bar, Pizza etc.The CSV data contains information on what transactions came on which screens, the time it took to cook (in seconds) and the actual time stamp.Time Stamp Kitchen Screen Time Transaction2012-09-04 23:38:42.440Main Bar 12860366592012-09-04 23:01:25.330Cutlery 37450366592012-09-04 23:01:25.330Desserts 271 036659What we need is to basically create a report - in excel.The data needs to be arranged bya. Meal Period (using time stamps) and to actually display that meal period. For example, breakfast would be between 4am to 11:59am, lunch will be 12:00pm to 6:00pm etc.b. The individual kitchen screens.The above will mean we will have 8 rows of kitchen screens for breakfast, followed by another 8 rows of kitchen screens for lunch etc.For each of the above, the average "cook time" will need to be calculated based on the data, along with the amount of transactions.Here are the steps to the report - 1 User enters a date or date range in the top cells (maybe a date picker?)2 The fields below will be populated with data for that specified date.3 IF the user inputs a range, then the fields below will be cloned below the previous set and the data will be put into there for each day.

    [more]
  • [Sealed] Jun 3, 2012

    Hello!Our company is looking for an individual who is highly skilled in Excel VBA Programming. Some features of the programming required will include the Find function, loops, nested loops and other nested function statements. We have already inputted the data into a macros-enabled Spreadsheet. We just need some help programming how that data will interact with itself. Some of the programming is already done for you, we just need someone to help finish the project. This is a highly proprietary project and due to company policy will require you to sign, scan, and email a Non-Disclosure Agreement before being accepted to work on this project. We would request at least 2 reviews/revisions of the project before funds are transferred. This should be an easy project for someone who is experienced in Excel VBA programming. We want to develop a long term professional relationship with an individual for future projects and further adaptations to the current project. We are offering $100 base pay plus a $25 bonus for completion within 3 days of starting project. There is also another special bonus that will only be discussed with the winning freelancer. We will provide all of the detailed information, which includes the xlsm spreadsheet, ranges, instructions, and calculations to complete this project to the winning freelancer.We look forward to working with you!

    [more]
  • $30 AUD Apr 20, 2012

    Hi,I have a few tables and graphs that need to be re-done to look new and like they were re-created in Excel.I don"t mind if you use Indesign or whatever program, just so they look nice and new and like they were created in Excel, if you are familiar with the APA format (Australian Psychological Association) for graphs and tables. If you could please provide me with the best quote.Thank you,Regards

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

Portfolio

[see more]

Résumé

Education

M.Eng.

Mahawithayalai Hor Kanka Thai

2010-2012