offline
Last seen: Jul 12, 2014 2:41 PM EDT
Hire Me!
Rate: $30.00 USD/hour
Follow Invite to Project
 

vbexcel

Prompt, proficient and professional

Username: vbexcel

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

Location: London, Canada

Member since: February 2010

Reputation:

4.9/5

(34 reviews)

5.6
[see more]

No user has recommended this freelancer.

My skills:

My projects:

  • $250.00 USD
    5.0
    Profile image for Seller mercuryproject

    mercuryproject

    Jan 20, 2014

    This was a very complicated project with many layers. VB Excel was very patient with me and my needs and he went above and beyond to deliver. I'm so appreciative

    Project Description:Finish and revise existing financial model. The project is geared toward a multi layered real estate acquisition and development.
    [more]
  • $250.00 AUD
    0.0
    Profile image for Seller Newpunter

    Newpunter [ Incomplete Report ]

    Sep 17, 2013

    The project is not completed according to the dispute

    Project Description:I Need a complete update of my spreadsheet as per Update file below,it needs to be able to import data from a daily file,do calculations and and filter data and provide output as per file below. I am...
    [more]
  • $78.00 USD
    5.0
    Profile image for Seller kevinkvk

    kevinkvk

    May 29, 2013

    good job! complete in time with high quality !

    vbexcel's reply:

    Great vendor, A+ in all categories

    Project Description:Its a very small and easy project, it will include excel vba skill. less thank 8 hours work. only need to create userform and set function such as match, vlookup need to complete in 24 hours,...
    [more]
  • £150.00 GBP
    5.0
    Profile image for Seller davidschindler

    davidschindler

    Apr 22, 2013

    100% recommend - superb / brilliant!! The King of Excel!

    Project Description:I am looking to drop ship from a European company Pixmania Pro - http://www.pixmania-pro.co.uk I have a domain with Godaddy www.printersandinkcartridges.co.uk Pixmania supply the following CSV file link...
    [more]
  • $80.00 USD
    5.0
    Profile image for Seller tylerbook

    tylerbook

    Mar 2, 2013

    Absolutely perfect, helped with everything we asked for. Fantastic worker, would hire again and again.

    Project Description:We have two csv files that we want to import into excel to have formulas applied to ::: . The CSVs we use have static number of columns, and static column names, if that helps. We want formulas applied...
    [more]
  • $179.00 USD
    0.0
    Profile image for Seller zoomonkey

    zoomonkey [ Incomplete Report ]

    Oct 17, 2012

    Poor communication despite being promised my project would be a priority. Failed to complete project, overall a waste of time.

    vbexcel's reply:

    Misleading specification given by employer. Basically, the idea was to debug six web scraping macros, however all of which required major recoding. For the three scrapes that I redid no compensation was offered.

    Project Description:I have 6 macros that scape data from 6 different websites (the codes direct the websites in what data to display and then loop through different dates and inputs - which have been driven by different excel spreadsheets...
    [more]
  • $390.00 USD
    5.0
    Profile image for Seller bradjester

    bradjester

    Sep 25, 2012

    Zenon is excellent. Loved working with him.

    Project Description:Below is a detailed description of what we do on a regular basis - this project is to automate as much as possible of the steps below so that I end up with a bot that I can run whenever needed, on whatever spreadsheet I want to use...
    [more]
  • $50.00 USD
    5.0
    Profile image for Seller fbod383

    fbod383

    Aug 4, 2012

    super fast, exactly what i needed

    Project Description:I saw you had bid on doing a tire size DB for Bratok21 about a month ago. If you still had the DB or Excel spreadsheet I would be willing to buy it. here is the posting. http://www.freelancer.co.uk/projects/Data-Processing-Data-Entry/Tire-Sizes-Vehicle.html...
    [more]
  • $9.80 USD
    0.0
    Profile image for Seller computer13

    computer13 [ Incomplete Report ]

    Jun 20, 2012

    what can i say, this guys never reply to me didn't meet the deadline gave him a chance to reply never did, even have prove of it.

    Project Description:program is done just need report to be done. need to be done 1 and half days. look below for full details
    [more]
  • $130.83 USD
    4.4
    Profile image for Seller BikProfessor

    BikProfessor

    Jun 3, 2012

    Amazing freelancer, highly recommend. He put a lot of effort into the project.

    Project Description:I need a deep analysis of major OMX stocks, including betas for stocks and etc.
    [more]
    vbexcel has not completed any projects.
  • $30 USD In Progress

    Hello there,Pls can you quote for below,I required a one VBA code for below 3 questions.(No hurry for answers; only initially need to say that task accepted only, will wait for answer) TASK:- 1. Disable “Save-as” & "Save-as" any short cut key for a particular file only! 2. Disable “Copy” & Short cut key & Drag for particular column (say A:A) and Particular Range (say B3:F7 & B24:F24)But remaining area should work copy/paste by short cut keys and righclik on mouse further selection manually copy/paste in remain cells. Note: - This can possible by protect sheet; but I do not want to apply any protection. If you are making define range then define range should be disable to modify. 3. Disable Right Click on tab to move or copy as new workbook. (For create a copy) Here, I want particular function (move or copy) only disable, not other function which visible after right click on tab. Note:- Again do not want any workbook protection. Faceid preferable, for pt. 1 and 3 for particular sheet only! Or your any best idea! I am using excel 2010. Note:- Pls do not use the XML codes for Pt. 1 & 3 if XML code then give protection idea also.Payment can be done by Paypal Only or Bank Transfer for Indian Bank!ThanksRahul Kale

    [more]
  • $250 USD In Progress

    I am looking to have an Excel Plug-in made that can pull data from the Instagram API that works in a similar (but smaller scale) way to this Twitter Plug-in: http://www.rssbus.com/excel/twitter/hiw.aspx Note: Full Scope of Work to be provided upon awarding the projectThis Excel Plugin should be able to pull data in two different ways (with details):1.Pull data about any authenticated user logins’ followers and compiled data a. Pulls data about a users own account followers/comments b. Should be able to pull account data in a few different ways Follower: * Every follower, # of their followers, date they began following, # of comments, location of follower, etc (full data in scope) Comment * Every comment made by followers, date comment made, time of day comment is made, # of likes, location of comment, etc (full data in scope) * Every comment made from the user account a. Date of comment, time of comment, # of likes, # of comments, reach of comment2.Pull public Instagram data about any keyword term a. Pulls data based on a keyword search b. Should be able to pull all posts that have a set keyword/tag * Data included: a. Comment, username, location, date, time, # of likes, reach (# of users followers + # of followers from any commenters), etcBasic Functionality Use-Case•I open Microsoft Excel•Go to the Plugin tab•Launch a new data query•Select if I want account data or keyword data - Enter in necessary information based on the path * Account data: Instagram username/password credentials * Keyword data: Instagram keyword to search•Select the data to be pulled - Followers, Day, Time, Reach, # likes, # of comments, location, etc•Click generate/submit/etc•Raw Data is pulled based on the filled out criteria - With top row having headers for each type of dataThis would pull data using the Instagram API: http://instagram.com/developer/# Data output example will be provided with final scope upon awarding the project.

    [more]
  • $50 USD In Progress

    Very similar to one you just bid on. I have a spreadsheet with property addresses on it. I want to link the Zillow Zestimate of Value or Rents to the Cell in the spreadsheet. And I need ot to be easy to add new properties to or to start a new spreadshhet all together.I realy just need a LINK or a code that I can put into a spreadshhet that links it to Zillow?? If possible?

    [more]
  • $60 USD In Progress

    We use an XL spreadsheet for picking college and NFL football games we need somebody to write a formula so alls we have to do is enter scores and it will calculate who won and who lost and keep the weekly percentage total and an annual win percentage total we have the spreadsheet set up we just need the formulas written

    [more]
  • $600 USD In Progress

    Hello again. At the end of the last project, we chatted on coding for a different Zillow API - one that would return results in a single pass with address input versus the 2-pass method.If you are available, I"d like to have you do this for me. The API that will return results with only an addressed passed is: http://www.zillow.com/howto/api/GetDeepSearchResults.htmFor this project, I"d like you to code the VB into the existing Excel version, and then we will follow up with either .NET or Javascript version for integration.Let me know if you are interested and your estimate for VBA/Excel version and Javascript.Thanks,Mike Whitson512-917-4309mwhitson@granite-excell.com

    [more]
  • kr1400 SEK 6 days ago

    What I want to do is to extract odds from Pinnacle Sports to Excel. Below I"ve tried to specify the functionality I need.* all odds for a specific game from when the line opens (when the odds are first presented at Pinnacle Sports) to the line closes shall be extracted and logged in an Excel spreadsheet. In practice, the odds extracted and logged for a odds type can be only one if no odds movement occur up to hundreds if many odds movements occur. The Pinnacle Sports XML-feed (see below) provides a feature where only changed odds can be extracted. * the Excel spreadsheet should build up and contain more and more odds and games, i.e previously logged odds/games should not be overwritten or deleted.* the sports of interest are: soccer, handball, tennis, baseball, american football, hockey, basketball. * the betting forms of interest are: Asian Handicap (AH), Money Line, Over/Under (O/U), 1X2. Note that all games does not have all betting forms available. * only full game betting is of interest, i.e. first half betting, first set winner etc are to be excluded.* only game totals (for O/U odds) are of interest, i.e. home team goals O/U etc are to be excluded. * odds shall be in decimal form e.g. 2.08. * one sheet in Excel for each sport is preferred. * the structure of the Excel sheets should look something like this: Time AH Spread team 1 Odds AH Spread team 2 Odds Time O/U Spread Over Under Game 1 03 Jul, 10:33 0.75 1.874 -0.75 2.010 03 Jul, 14:33 2.50 1.952 1.952Game 1 03 Jul, 12:11 0.75 1.880 -0.75 1.990 03 Jul, 14:43 2.50 1.943 1.975Game 1 03 Jul, 14:57 0.75 1.852 -0.75 2.030 03 Jul, 14:57 2.75 1.870 2.050Game 1 03 Jul, 16:44 0.75 1.934 -0.75 1.952 Game 2 03 Jul, 12:01 -0.50 1.892 0.50 2.040 03 Jul, 13:14 2.25 1.952 1.952Game 2 03 Jul, 12:14 -0.50 2.000 0.50 1.943 03 Jul, 15:23 2.25 1.986 1.922Game 2 03 Jul, 13:40 -0.25 1.794 0.25 2.180 03 Jul, 15:44 2.25 2.060 1.885The table shall be complemented with Money Line and 1X2 odds. Note the blank row in-between games. Format on the time stamp is not very important. Odds from Pinnacle Sports can be extracted through their XML-feed at:xml.pinnaclesports.com/pinnacleFeed.aspxPinnacle Sports allows that the feed is grabbed once every 60 seconds. That is the refresh rate I want. A XML-feed manual can be found here:http://www.pinnaclesports.com/api-xml/manualExperience from betting would be helpful but is not really a requirement. I will be available to answer any questions you might have.

    [more]
  • $250 USD 27 days ago

    We need to transform excel files that arrive in a list form into an SKU Form to then be imported into another softwareI have created an example to illustrate what I get and what I need.

  • $135 USD Feb 12, 2014

    I have a large and complex excel worksheet that relies heavily on ranges, offsets, reference cells, formulas, worksheets, buttons and more. I need an expert with VBA and excel to make some upgrades and fixes to the worksheet project. Currently calculations only work with type "labor adjustment" for the product section of the worksheet. The worksheet calculates consolidated GP%, cost, labor and quite a few other items in a project summary, prints a budget, takes input from stations and enters onto a tab of worksheet. You must be able to work with ranges, modules, dialogs in VBA code. Statements may be similar to ActiveCell.offset(0, 26).Formula = yadayada. Mainly some logic must be corrected, additions and upgrades must be made to the project. You will be adding items to the project summary, adding references to an OID tab from within initial worksheet (station). Also, budget created by worksheet code must output in a specific format, print set up to landscape to output details of project. Budget must be autopopulated correctly. A great deal of the functionality is already in place; however, it must be fixed.

    [more]
  • $30 USD/hr Feb 5, 2014

    I am currently working on an Excel model in order to predict call using the Erlang formula. I have the basics and the formulas but I need incorporate different formulas and spreadsheet into one. I need to have the data update throughout the day based on what happened earlier in the day. I need someone who is familiar with statistics, math and Excel.

    [more]
  • €139 EUR Sep 13, 2013

    I need a plugin or software that fetches the data from the web and organizes teams on excelthe website is http://www.soccerstats.com/ and i want to download the teams information goals, wins etc for an excell with a button to refresh and one page for each league

    [more]
  • $30 USD Sep 13, 2013

    I Have budget template on excel sheet. its need some BBA by developer, most of work is combo list combo box, drop list. examples:- we have 6 divisions and each user can choose up to 6 division, if the user choose 4 division, he should have 4 column budget, one for each division- if the user fill 5 project he should have 4 budgets tables. one for each project. and so on. the file will be ready tomorrow and I need it within 24 hours. paid upon successful completion

    [more]
  • £150 GBP Jun 7, 2013

    Hi I am looking for someone to update my invoice. I think I would like a data base running from an invoice in excel.I would need to be able to analayse customer information eg. prevoious invoices and what stock they bought and what returns they had. I run a small wholesale business.

    [more]
  • $330 USD May 3, 2013

    We are looking for a firm that is familiar with construction blue prints and has a very good knowledge of how to do construction take offs for masonry and concrete construction. You must be able to determine material quantity after reviewing prints of large construction projects. You will then have to deliver those quatities on an a spreadsheet. You are not required to determine any cost only material quantity to complete job. You will be expected to do multiple jobs at any given time as we have multiple job to review. Great monetary potential. It would also be helpful if you could also determine quantity take offs for other areas of construction.

    [more]
  • $66 USD Apr 17, 2013

    My client needs the data from this PDF extracted to a .xls sheet. There are 6 columns to be listed:Name CompanyAddressPhoneFaxCAPS Classification.The .xls sheet needs to be fully editable. Attached is the file.

    [more]
  • $459 USD Feb 26, 2013

    I want an automated code which can visit a Food Recipe website and extract the following information from the Food Recipe URL.-Food Image-Recipe Title-Recipe Directions + Ingredients-Recipe KeywordsThen I want to use this information to generate short YouTube video"s using the "Food Image" to be shown for the YouTube video + adding on Royalty Free music.The video will basically show the image of the recipe and play the royalty free music for about 30 seconds.I want to use the "Recipe Title", as the YouTube Title, the "Recipe Direction" + "Ingredients" as the information about the YouTube video, so when you click "show more" on the video it will display the full Recipe including the ingredients and directions.and lastly, the "Recipe Keywords" to be used as the YouTube Keywords for the video.I want everything to be automated so it can extract the information from the website /and upload the videos to my YouTube channel by the thousands.

    [more]
  • $180 USD Feb 8, 2013

    We need a skilled data mining programmer to mine public library directory sites in the United States, Canada and Australia to develop a database of approximately 20,000 public library administrator email addresses. We hope to pay about 0.5 to1 cent per email address. Some sample sites are listed below but we are most interested in coverage and not necessarily in any one specific site.

    [more]
  • $250 USD Aug 17, 2012

    Hello,I am looking for someone that has the expertise to build an API web tool in order to extract Real Estate data from Zillow.comPlease see the information from the link below.http://www.zillow.com/howto/api/GetZestimate.htmI will provide more information and requirements to the right candidate.

    [more]
  • $50 USD Jul 23, 2012

    Hi - I saw that you did a project downloading the Inc. 5000 list and adding business description and contact info for each company. I need the exact same thing. Can you just send this to me?

  • $50 USD Jul 20, 2012

    Hi - I saw that you did a project downloading the Inc. 5000 list and adding business description and contact info for each company. I need the exact same thing. Can you just send this to me?

  • $30 USD Jan 3, 2012

    HELLO,I like join with data entry job (but not captcha job) or accounting job.

  • $250 USD Jun 6, 2011

    I have a mailing name list in PDF file format and the data from this file needs to be transfered to a spread sheet. The end spreadsheet will have 7 columns - Name, Name 2, Address, City, State, ZIP code and Telephone number and these fields need to be as accurate as possible. I estimate that the spreadsheet will have around 22,000 rows when finished.

    [more]
  • $100 CAD May 10, 2011

    Our accounting department is currently provided GL data in an Excel spreadsheet for multiple locations summarized into daily totals (see sample attached). Each month they need the data in each tab converted to a CSV format to import into their accouting system. Each tab in the Excel spead sheet has specific data extracted and reformated into a CSV file (sample attached)

    [more]
  • $250 USD Mar 22, 2011

    I need to build a database of Timeshare resorts and need as much information as possible scraped from the 2 major exchange companies -1. RCI (Approx 3,700 resorts) - http://www.rci.com/RCI/prelogin/rdMain.do2. Interval International (Approx 2,500 resorts) - http://www.intervalworld.com/web/cs?a=1500I would ideally like the Google maps long & lat data and I would also like the resort imagesThe project will need to be provided to me in excel or .mdb and the data needs to be CLEAN. No stray HTML code, random characters, garbage or anything.In your bid, please provide -1. Cost2. Time to carry out the job3. The information you can collect from each directory (Resort code, resort name, resort address ... etc)I WILL NOT CONSIDER OR RESPOND TO GENERIC "YES I CAN DO THE JOB FOR YOU" REPLIES, THEY WILL GO IN THE TRASH!

    [more]
  • $100 USD Mar 1, 2011

    Looking for individual to assist with writing content for our business/marketing strategy and services content.

  • $750 USD Mar 1, 2011

    Hello im interested someone to scrap all phone numbers and names from an choosen website,who is interested in this job let send me pm or let contact me

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

Portfolio

[see more]

Résumé

Experience

Senior Consultant

Sep 1995 - Present (18 years)

CDN Global Solutions

Education

BASc

University of Toronto

1988-1992