offline
Last seen: Jul 29, 2014 3:44 PM EDT
Hire Me!
Rate: $15.00 USD/hour
Follow Invite to Project
 

JayLancer43

VBA/Macro Expert (Excel/Word/PPT/Outlook/Access), PHP, MySql

Username: jaylancer43

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

Location: Paris, India

Member since: October 2012

Reputation:

5.0/5

(78 reviews)

5.7
[see more]

9 users have recommended this freelancer.

My projects:

  • $75.00 USD
    5.0
    Profile image for Seller jimmysous

    jimmysous

    8 days ago

    Thanks again for your always great job! I will absolutely hire again!

    Project Description:I need a excel userform to input data into excel sheet. Validations involved. More details will be provided to jaylancer.
    [more]
  • €222.00 EUR
    5.0
    Profile image for Seller jamesoliver69

    jamesoliver69

    21 days ago

    Jay, Is a committed professional with a great work ethic. Excellent knowledge of Excel and very good English Very pleased with the result and would definitely hire again. I recommend him highly.

    Project Description:The project requirements are. I am a freelance sports journalist specializing in horse racing and providing pointers advice to my readers. I require the following project please. Overview. Download UK and Ireland historical racing results from www.horseracebase.com...
    [more]
  • $15.00 USD
    5.0
    Profile image for Seller IMAID

    IMAID

    21 days ago

    Great work! Timely completion!

    Project Description:Please take the form and place it on the IMA letter head; maintaining the current format. Make sure the form is properly centered and oriented in the letterhead. NEED ASAP.
    [more]
  • $150.00 USD
    5.0
    Profile image for Seller coolpapa29

    coolpapa29

    25 days ago

    Excellent skills. Great communication. Fast delivery. Will use again.

    Project Description:I am looking for a one page Powerpoint slide that has a few scripts built into it that can generate 4 random 10 digit numbers, 4 random 4 letter sequences, 4 random alpha numeric numbers, and 4 random two digit numbers...
    [more]
  • $75.00 USD
    5.0
    Profile image for Seller jimmysous

    jimmysous

    Jun 29, 2014

    Thanks a lot for your help and kindness! Will back again for sure!

    Project Description:I need a excel userform to input data into excel sheet. Validations involved. More details will be provided to selected freelancer. Thanks.
    [more]
  • $150.00 USD
    4.0
    Profile image for Seller IIMiningSupply

    IIMiningSupply

    Jun 17, 2014

    Thank you!

    Project Description:Further enhancements and modifications to an existing project. Do not bid. Private project for Jaylancer43, do not bid
    [more]
  • $150.00 USD
    5.0
    Profile image for Seller jimmysous

    jimmysous

    Jun 11, 2014

    Exceeded my expectations!Great to work with! Very very nice and very very patience!

    Project Description:We are looking for someone to complete the functionalities of an Excel file with VB script for inventory bookkeeping. In the Excel file there are 3 tabs: #1. Input tab: VINinput & Record #2. Lookup table table:Data for Lookup #3...
    [more]
  • $120.00 USD
    5.0
    Profile image for Seller netclimber

    netclimber

    Jun 3, 2014

    It was a pleasure working with you. Appreciate the quality of work and the forethought to help make it better.<br/>

    Project Description:i am working on a spreadsheet and having problems with functionality i&#039;m trying to implement - would you be interested in working on it? i want to create a process that will grab the info from the initial...
    [more]
  • $77.00 AUD
    5.0
    Profile image for Seller jackbhiggins

    jackbhiggins

    May 29, 2014

    A+ service!

    Project Description:Transfer the data from one excel spreadsheet to another. - Some have already been done as examples
    [more]
  • $30.00 USD
    5.0
    Profile image for Seller rabbioffice

    rabbioffice

    May 22, 2014

    Great to work with!Thank you.

    Project Description:Would like to create a horizontal timeline for company project which says where each project starts and ends. And have vertical milestones that will go on specific times of the year. The timeline and milestone have to cross with each other...
    [more]
    JayLancer43 has not completed any projects.
  • $15 USD/hr In Progress

    HiWe have a simple spreadsheet which was written for our billing system.The worker can&quot;t be contacted and we need someone to pick up the job. It is an ongoing job with changes are required each month.If you have good Excel feedback, please reply with an hourly figure so you can be short-listed.Please start message with &quot;howdy&quot;

    [more]
  • $250 AUD In Progress

    We need someone to put finishing touches to excel workbook that we regularity use. Most of work is basic formatting however we have an index sheet that needs some hyperlinking to relevant sheets. Also, on index page we want list of sheets in workbook but only want various sheets to appear once they have been ticked. Specific editing details will be provided.

    [more]
  • $15 USD/hr In Progress

    Need changes to be made to a MS Access template to be better utilized in my office setting. I have drafted a list of changes to be made on a word document for you to review and go through. Every stage we get to I will pay you for your time and request other changes or additions down the road as we go. Any questions you have always feel free to message me at any time!

    [more]
  • $150 USD Today

    I want to create a basic excel spreadsheet that has basic information, and have the option to expand each entry to show detailed information on that entry.

  • $50 AUD Yesterday

    I need a spreadsheet that adds up a series of rows, puts the result at the end of the row, in a cell.If the result is a negative number then it is to be red font.If the result is a positive number then it is to be blue font.2 separate cells are to add the total of these 2 coloured results, 1 cell for the total of red results, and 1 cell for the total of blue results. I know enough to be able to expand this ounce it is done, just can&quot;t make the colour bit work.

    [more]
  • $49 USD 4 days ago

    Hi, i need a software or code for 2 excel files. both the same excel files but one of them don&quot;t hade id sections. it is blank. i want that software or code will find names in second excel file which is first excel. and then take it is id to first excel file.

    [more]
  • $40 USD 10 days ago

    i have a website you need to extract data from it and save it to files and folders as explained in detail belowi need script and data bothso that i will use it for future executionyou are bidding to create script and data both given to me.i have 4 more scripts - bid for 1 script at a time

    [more]
  • $30 USD 11 days ago

    Hello,I have a project. I have 2 excel files. One has a column that says pictures the other one does not. I want to move or copy the data that&quot;s in the picture field to the one with out by matching the product number field. If you can do this let me know.

    [more]
  • $30 USD 11 days ago

    Hi,I want to create an excel sheet that has project management features (I have the template) but also want dashboard and also few other sorting feature including Vlookup formula to extract data.This is not that complex work and anyone with intermediate excel skills along with the VBA skills should be able to do this task.Please do not send bids without attaching your sample work from the past projects.

    [more]
  • $100 USD 12 days ago

    I have been collecting certain data that my project development team has been logging into excel: 1. task done (brief description) 2. person responsible for task3. planned task ... or ...4. UN-planned task5. promise completion date 6. actual completion dateI am tracking and inputing all of this data, but I would like someone to help me make a graph (or graphs) that tracks (visually) what is getting done, how fast, the difference between planned and unplanned tasks, and the difference between promise dates and actual dates. I would also like to track who is working on how many tasks, and how their promise dates measure actual dates.

    [more]
  • $30 USD 12 days ago

    I&quot;m looking for an excel sheet that I can use for calculating a price quote. Attached is a spreadsheet of what I am looking for but is coded incorrectly.

  • [Sealed] 12 days ago

    [This is a Private Project. You must be logged in to view the Project Description]

  • $30 USD 13 days ago

    editing list in Exel making inventory.list allmost finish. just Need to find from other files I send of every single eyeglass the Price from supplyer and enter this one.. Only bit if you did something simular like this.

    [more]
  • $777 USD 15 days ago

    Need Expert PHP Developer for my ongoing Project.

  • $250 USD 15 days ago

    Hello, I have lots of images that need to be converted to excel. I will provide you a sample, and you must ready to start soon, new freelancers are welcomed

  • €555 EUR 19 days ago

    ricerco un programmatore VBA Excel per sviluppare un applicativo. Il programmatore potrà svolgere il lavoro al proprio domicilio - su specifiche tecniche del committente - con incontri di persona per lo stato d&quot;avanzamento lavori.

    [more]
  • £150 GBP 19 days ago

    Hi I have a simple application that I would like built. The idea is it would take a excel file and substitute the text in order to make the content more unique. I have written a spec and attached. I imagine this needs to be a windows programme since it might be resource intensive (well reasonable). Please give me examples of previous project done. I don&quot;t have a big budget for this, it&quot;s a luxury rather than a necessity. thanks Ed

    [more]
  • $250 AUD 19 days ago

    We are collating a database that has been automated to load CSV files. We need some adjustments made.In photo HQ to Form we need column HQ moved across to go next to column L without effecting the automation side of loading the CSV files.In photo Delete column E we need to get rid of this column altogether. These calculations adjust %s if we delete an entry, we need to get rid of column E and use column D to make these changes.In photo &quot;extra column&quot; we need a column inserted between column U and V with all the same formulas that are written for column L.In photo sheet am pm, we need to adjust the times for AM and PM. When we load the races the times do not load in the correct order. If there is a race before midday (say 11.30) instead of being recognised as the first race of the day and be loaded first it is loaded last (as a 11.30 pm)Might be easier to link on teamviewer to explain.Please only people with exceptional excel skills and fluent English respond.There will be ongoing work for the right person

    [more]
  • $750 USD 27 days ago

    This is easy work.We need Only excel experts for our project.We will provide you excel sheets and you will import to software.Our Budget $750usd

  • $155 USD 27 days ago

    I currently have a program that can upload .rtf and excel documents and generate emails and/or letters.I need to use this technology to upload excel reports into the new module. The new module will allow me to manually enter data into preset columns that will generate pre-formed emails and letters that show the fields that were selected in the excel report.These emails and letters can be emailed and/or printed when all entries have been made.This is confusing, so please see the attached conceptualized files that illustrate my objective.I am attaching a mock-up of the existing excel program and the proposed one. THIS IS VERY MUCH A WORK IN PROGRESS AND WILL REQUIRE REVISION AND CUSTOMIZATION. Please carefully review the attached documents, understand the objectives of the project. While there are &quot;moving parts,&quot; I believe that this is a fairly straight forward project.Thank you.

    [more]
  • $80 USD Jun 28, 2014

    Hello all! I am looking for Excel Wizard who can build a 4 sheet spreadsheet (idea drafted on attached board with post it notes)1) Input sheetWe receive sales order email with orders for a few days ahead; (sample email: Today we require 3 pallets of Oinkers) Please refer to Product and Coversion chart attached. Products we pack are marked on there. Numbers in Quantity column represent the amount of boxes (unit each) per pallet. I need to input received order in first sheet and get automatic calculation on how many pallets are requested based on each unit; for example in this case 3 pallets would mean 432 units. So, first sheet would be where I input info from email. I&quot;d like to have option of input of either pallets or boxes. In either way spreadsheet would need to tell me if I input boxes how many pallets that equate to and vice versa.2) Work Order with Delivery DocketOnce information from the email is placed into Input sheet, it is copied onto second sheet &quot;Work Order with Delivery Docket&quot;. A work order or job order (sometimes job ticket or work ticket) spreadsheet will create &quot;Work Order&quot; for me for the day (green post it notes) which I can print out and give to leading hand so he / she can start packing for the dayWork Order needs to have info on what needs to be done for the day and delivery docket or something similar so foreman can confirm that job was finished and sign off on delivery to dispatch of what was actually ordered.In Work Order sheet, information that should automatically come from Input sheet:For exampleOrder is 3 pallets of Oinkers3 pallets of Oinkers is 144 x 3=432o on Work Order I will have date and order of 432 Oinkers And delivery docket where foreman can confirm with signature that packing line actually delivered 432 boxes on 3 palettes3) VariablesAs you can see n the Products and Conversion chart, we are packing 7 different products. Each product have a different cost per unit and that can change at any give time. So I need to have sheet where I am able to input cost per unit (box).Second variance is labour cost. We pay fix cost per hour, but amount of people on the job changes. We can have 10 people one day and 4 next day. So I need to be able to input (this is me guessing)1) Cost per unit that we are packing as per work order2) Amount units ordered3) Amount of people packing that job and their cost per hour4) Measure the time from start to finish for the current work order**Explanation: Order is for 3 pallets of Oinkers which is 432 cartons. We start packing at 7:30 in the morning and packing supervisors inform me at 11:30 that order is done. I can record that timing so a) I can get report on average times per productb) know when my labour is sitting idle and I&quot;m paying them to do pretty much nothing (they are very good at looking busy) 4) Dashboard Report SheetLast sheet in Spreadsheet that would give me instant view of order and did we break even, made profit or have loss. (In dashboard we have fixed costs as well to understand break even or profit/loss)My fixed cost is labour. I know how much I&quot;m paying them per hour. What varies is how much time they spend on the job, product they are packing and prices we are getting paid to pack the product (price per each unit)For example, I get $ 100 dollars for a product and I pay $10 per hour. I should complete job in 10 hrs to break even. So dashboard should tell usme upfront if we are at loss/profit etcand help me decide if job is worth doing or ask the labour to speed up packing process.Complete spreadsheet needs to be on a weekly level, Monday to Friday. Please feel free to ask any questions if you don’t understand any of the above. Budget is $80Looking forward hearing from you!

    [more]
  • $15 USD Jun 11, 2014

    Create database of National Oil Companies in excel Make the list of all the NOC existing todayProvide information about themFinancial strength and weaknessThe way of workingConflicts in the regionKey people Information on their upstream midstream and downstream Imports vs export of crude oil and petroleum productsTrading activities in volumes, if any

    [more]
  • $15 USD/hr May 29, 2014

    I have ongoing work related to our previous project &quot;Fill in a Spreadsheet with Data&quot;

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

Portfolio

[see more]

Résumé

Experience

Business/Data/Reporting Analyst

Mar 2008 - Present (6 years)

Capgemini

Education

Bachelor of Engineering

Nagpur University

2000-2004

MBA

University of Wales, Cardiff

2006-2008

Certifications

Business Analyst

Capgemini

Completed Business Analyst certification successfully.

Publications

Impact of Portable ICTs on Learning and Productivity.

MBA Dissertation

Impact of Portable ICTs on Learning and Productivity.