login sign up

offline
Last seen: May 18, 2013 11:26 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 not verified their secure phone number.
  • Verified
  • Payment is not verified.

Location: London, Canada Canada

Member since: February 2010

Reputation:

4.9

(30 reviews)

5.4
[see more]

My projects:

  • $80 USD
    5.0
    Profile image for Seller tylerbook

    tylerbook United States

    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 USD
    0.0
    Profile image for Seller zoomonkey

    zoomonkey Australia[ 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 USD
    5.0
    Profile image for Seller bradjester

    bradjester United States

    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 USD
    5.0
    Profile image for Seller fbod383

    fbod383 United States

    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.8 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 United States

    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]
  • $79 USD
    5.0
    Profile image for Seller xtype

    xtype United Kingdom

    Apr 16, 2012

    Delivered on time and as requested, many thanks.

    Project Description: im looking to create an Excel sheet that calculates stock value dilution. you can read what stock dilution is here: http://www.avc.com/a_vc/2010/10/employee-equity-dilution.html and you can see...
    [more]
  • $90 USD
    5.0
    Profile image for Seller birdistheword

    birdistheword Canada

    Apr 4, 2012

    A+. Excellent communication and turnaround time responding to questions and applying software tweaks. vbexcel takes pride in a job well done, and I would not hesitate to do business with him again.

    Project Description: I have seen many people ask for something similar, so I am sure there is something out there that can be recycled. I need someone to develop an Excel Macro/Script for me. I want to take an existing...
    [more]
  • $90 USD
    4.2
    Profile image for Seller nrioux

    nrioux Canada

    Jan 31, 2012

    Was well delivered

    Project Description: Project Description: Improve an excel 2003 invoice system spreadsheet - Print to pdf creator (a macro is actually working for this) - Save to a variable name to a specific directory - Change product...
    [more]
  • £60 GBP
    3.8
    Profile image for Seller Amirah183

    Amirah183 United Kingdom

    Jan 24, 2012

    Thank you, for doing the work, making corrections everytime I needed something changed. Great freelancer :D

    Project Description: N/A
    [more]
    vbexcel has not completed any projects.
  • $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]
  • $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]
  • $350 USD In Progress

    We are needing someone who is proficient in excel and understands real estate development modeling. Freelancer should under capitalization rates, return on investment, and rate of return calculations. We would like to run some scenarios for a cash flowing multi family property that will be torn down and redeveloped in phases. There are several layers and options for the development of the asset and we would like to run each scenario to compare and contrast the best and highest use. We have a couple existing excel spreadsheets for this project that will be a helpful starting point for whomever should take on this project. We would estimate about 60% of the financial modeling project is already complete.

    [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-CaseI open Microsoft ExcelGo to the Plugin tabLaunch a new data querySelect 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 searchSelect the data to be pulled - Followers, Day, Time, Reach, # likes, # of comments, location, etcClick generate/submit/etcRaw 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]
  • $269 USD In Progress

    We would like the Intuit Quickbooks Point of Sale 2013 Inventory Template populated with data from the spreadsheets of several manufactures that we deal with. The spreadsheets will be supplied upon the awarding of the project. Please contact us for more details.

    [more]
  • $35 AUD In Progress

    I have an assignment I would like to be done to check with my answers. It requires Visual Basic knowledge and is to be done in Visual Basic through excel.I will send the entire details of the assignment to those who apply through PM. Please PM if you are an expert in Visual Basic and able to do a simple programming job like this.I may hire 2 employees to check variety of solutions.The assignment requires the following knowledge:..............................................................................................................Implementing a simple dynamic mathematical model for a physical system in VBA;Using drawing objects and animation (though a basic graphics library is provided);Designing a well-presented and functional form; andWorking with a partner (if applicable)Testing and AssessmentThe provisional allocation of marks (out of 40 so every category is integral) is6 Animation of the wheel over at least one cycle10 Accurate display of the bar, spring and weight over multiple cycles6 Accurate calculation and use of amplitude/phase using spring properties (Part B)3 Validation of the amplitude and phase (both must be numbers, both non-negative and phase also not greater than 180)5 Ability to start/stop/resume/reset the animation4 Appearance and usability of the form, including correctly displaying the current angle6 Style mark (as awarded by AssessStyle) 40 Total mark (rescaled to 5% of the overall assessment)3 Bonus features or enhanced informationYou are not assessed on the smoothness of the animation, as the VM used in the labs doesn't always give a full share of the processor to Excel.Up to 3 bonus marks may be awarded if the submission provides additional functionality to the user or useful information about the system. These include (but are not limited to)Remembering the previous parameters when the form is activated.Displaying sinusoidal motion derived from the animation using charts or other methodsDisplaying velocity and/or acceleration components.Fancy graphics or form embellishments (don't get too carried away though, or it will detract from the motion).

    [more]
  • $144 USD 2 days ago

    Export Data from Zillow, Trulia and Chase Home Value Estimator onto Excel spreadsheetUser provides addresses (Street Name, City, State, Zip, URL for Zillow) as inputs.Outputs should be downloaded to the excel spreadsheet as specified.We are requesting a tool to be built to scrap the three websites above, rather than an one-off data entry project.Input / Output are detailed in the attachments (see word document for description and Excel for sample output)P.S. One can assume the user has access to Zillow API.

    [more]
  • $150 USD 2 days ago

    I am looking for someone to gather email data from soundclick.com. I'm looking for a list of 20,000-50,000 emails from recording artists and bands. Pm me your prices and timetable.If all goes well i have a bigger project for you.

    [more]
  • $35 USD 14 days ago

    I need an excel macro written that can group rows in a spreadsheet where certain text shows up in a cell. I can provide a spreadsheet that will show how all the data looks before formatting and what it should look like after running the macro. I am currently formatting the spreadsheet manually.The data I'm working with can have up to 180 rows in a worksheet, with the following sub headings included:---------------------------------------------------------------TOTAL INCOMEEXPENDITURETotal Service PurchaseTotal Client ServicesTotal Corporate ServicesTOTAL EXPENDITURENET INCOME / (DEFICIT)---------------------------------------------------The headings shown above represent the way I need the worksheet to look after running the macro however the original format includes a number of various income and expense items under each sub heading. These all need to be condensed and grouped together.

    [more]
  • $93 USD 16 days ago

    I have about 30 PDFs with line item data that will need to be cut and paste, and formatted into three seperate columns in Excel. Very simple but time consuming. Date is one of the fields and will need to be in the following format: MM/DD/YEAR

    [more]
  • $154 USD 16 days ago

    We are creating a company that is doing georefential ads and we need the clash flow of the next 5 years, with different cases. I need this for these sunday.

  • $330 USD 16 days ago

    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]
  • $99 USD 17 days ago

    I need data from a pdf file transcribed into Excel or a .csv file. Here is the original data:http://www.whitehouse.gov/sites/default/files/omb/assets/legislative_reports/stareport.pdfI need the information from Appendix A (13th page of the PDF through 236th page). Under the “BA Type” column, each unique entry should be given its own column. The amount in “BA Amount” should be entered under the appropriate column. The amount under “Sequester Percentage” should be tracked in the same way, so there should be a column for “Sequestrable BA Percentage,” “Sequestrable BA – special rule percentage” etc.

    [more]
  • $30 USD 16 days ago

    I am needing a excel macro workbook unlocked. Permissions are currently locked. I am needing it completed within 3 days. The sooner the better.

  • €129 EUR 17 days ago

    I have CSV and XML files that need to be used to upload product to EBay and Amazon with Turbo Lister or similar.I already have the files, they do not need to be created.I also need a simple template created (1 template for all the products) for these items (perfumes).Please quote in 1K product blocs + Template.Tengo ficheros CSV y XML que preciso utilizar para publicar en eBay y Amazon con Turbo Lister o similar. Se precisa crear un template para ambos. La cotizacin es por bloques de mil productos.

    [more]
  • $196 USD 16 days ago

    Hi, I would like help with scraping a site that needs to be stored in a Windows application and also saved in a database. It needs to be scraped every 30 second and also be able to adjust update fervency.The program need to get information for 10 users, the information is easily accessed without any loggings needed. The program shall only look if there been any new changes scenes recent update, and not get all information repeatedly.It need to be able to track the users and save them as 'intern users for the program' and also be abel to connect users to other users.The program also need to be able to send fallback mails if there is any problems with scraping a specific user.Here is an example of a user that needs to be tracked: http://www.forexfactory.com/dohung#28-listThe fields Open Trades and Closed Trades needs to scraped.Best regardsMissionMan

    [more]
  • $24 USD/hr 16 days ago

    I would like to transfer the Global 2000 list in forbes 2012 and 2013 into an Excel Spreadsheet. From there I can create tables and graphs

  • $198 USD 24 days ago

    I am seeking a programmer to write macros that will extract use the Sportingbet API to pull data from Australian Races as follows:1. Get all race data for the following 2 hours, once an hour every hour, including odds and put it in excel.2. Then, on selected races (form input by me), get odds every 10 seconds for the hour before it runs until it runs.3. If, (via another bot) a decision is made to make a bet, you also need to provide a routine to place that bet.You need a track record of gaming API usage, plus Excel and VB skills.You need a track record of completing projects (I don't want to waste your time, please don't waste mine).A great outcome means great reference and more work !Please bid if you think you are good for the work.

    [more]
  • £99 GBP Apr 18, 2013

    I need to entry data point by point from tennis matches into spreadsheet.I'll provide which matches I'm interesting - in total it's over 5000 matchesData can be collected from this site :http://www.flashscore.com/match/MmUwvD6L/#point-by-point;1Or from program called: OnCourtI'll give full informations about format later, I'll need to analise Data so person needs to be specialise in Excel

    [more]
  • $275 USD Apr 17, 2013

    I require a spreadsheet containing email addresses for every Soccer club in Australia.This can be presented in any format, however excel is preferable.

  • $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]
  • $110 USD Apr 18, 2013

    A Real Estate site has 1000's of properties listed. Need to review, narrow down and finalize affordable properties. Candidate should be passionate and interested in reviewing properties (Residential or Commercial). Otherwise, the whole activity is just one another bunch of data. USA based Real -Estate knowledge is a plus but not essential. Initial activity is to identify a good neighbourhood from a list provided.

    [more]
  • $290 USD Apr 17, 2013

    We need a web scraper that will scrape data from our parent company e-commerce web site, and uploading/updating data in our wordpress database.There are a few specifications necessary for the scraper:1) It must run and flag any removed products (set as a database field). The site admins will then deal with them.2) It must update any changed products on the wordpress site, that may have been updated on the parent company site.3) It must give a report afterwards that indicates the total number of products scraped, how many were added, updated and deleted.The final web scraper will be used continuously (~twice a month), so should be able to be setup to run as a cron job.

    [more]
  • $60 USD Apr 15, 2013

    I need someone to do some data entry ASAP its just cleaning up the values in 1 column on excel spreadsheet with the correct values that are in the second spreadsheet. You need to have Skype and be able to get this done in the next 4-5 hours. Good English grammer is required for this as well.

    [more]
  • $25 USD/hr Apr 15, 2013

    I'm looking for someone who can write some basic macros that involve Excel using DDE links. I trade options using my brokerage firms API which they have three versions of (Excel, Java and C++). The Excel API is definitely not the most robust but i need to understand that before i can hire someone to write something in Java or C++. Essentially I want to take live data coming into the API using DDE links and at certain time periods (1 minute, 5 minutes etc.) places the price into another separate static cell. Once a certain amount of data (20 minutes of 1 minute price changes) is captured in the static cells I need a macro to run that manipulates that data and places it into another static cell.

    [more]
  • $190 USD Apr 15, 2013

    Need to scrape a hotel booking site for rates and prices...the variable will be dates in the future so that client can competitively price room rates. Please feel free to ask for more details !!Thanks Rupesh

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

Portfolio

[see more]

Resume

Experience

Senior Consultant

Sep 1995 - Present (17 years)

CDN Global Solutions

Education

BASc

University of Toronto

1988-1992