We've changed our name from Rent a Coder to vWorker.com (which stands for "virtual worker"). Click here for all the details! If you came from another site, please tell the webmaster to update their link, and it will remove this message.

Click here to close this message.
Skip Navigation

More capable, accountable and affordable. Guaranteed.

Site Wide Message: Posted Sep 8, 2010 10:54:36 AM EDT.Dismiss this message
A big thank you to all site users for helping us win the 2010 Inc 5000 award for fastest growing private company, for the fourth year in a row!
Employers and workers: two universities are interested in how and why you use vWorker. (All information will be kept confidential and only reported in aggregate.)
  1. Employers: Louisiana State University wants to learn about the factors that influence your adoption of online sourcing. Click here to take the survey.
  2. Workers: Erasmus University wants to understand how you use the site. Contributors will receive a final copy of the aggregated data Click here to take the survey.

Visual Basic for App (excel sheets)
Project Id: 1465308
Bookmark in my 'To Do' list
Posted by: jamabdallah (0 ratings)
Non-action Ratio: Very Good - 0.00%
Employer Security Verifications: Unverified
Approved on: Jul 30, 2010
2:18:03 PM EDT
Bidding Closes: Aug 7, 2010
3:20:33 PM EDT
Viewed (by workers): 961 times
Deadline: 10 days.
Phase:
Cancelled
Employer cancelled on 8/15/2010 1:10:04 AM because: "Cancelled by automated program due to time expiration".
Payment Model: Pay-for-Deliverables
Max Accepted Bid: Bidding is closed
Expert Guarantee: 10% minimum REQUIRED
Project Type: Medium Business Project: $500(USD) and above
Bidding Type: Open Auction
Accepted Bidder Economy Type(s): All
Accepted English fluency(ies): All
ExpertRating Requirement: ASP.Net 2.0 using VB Test
MS Excel 2000 Test
More ...
Shortcuts
Communication

Messages summary
Post first reply
Chat log
 During project work

Status reports
Escrow Log
Work acceptance
Assembla Tools
Mediation / Arbitration
 Other

Contact info / receipts
Project phase log
Ratings

(Note:options without links are not enabled for this phase.)

Enter chat room for this project
(0 active users at Sep 10, 2010 9:07:24 PM EDT)

Brief Summary:

I have an excel spreadsheet with 10-11 sheets.
Data is sourced from an outside report and download from SQL DB in the first 2 sheets.  However because of telemetry error reading the data need to be scrubbed 1st.  So will need to write some code to ensure that data is within certain limits (min/max).
Second will need to populate other sheets from these  2 sheets and perform some calculations - again there are thresholds for the data. 
Also will need the auto format abnormalities (font and cell coloring to bring to attention).
Other programming tasks involved are making calculations such as averages for a week, month or a year. Min and max in data range, etc... and other similar simple tasks.
Requirements Interview Answers:
To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers. Untitled Page
Project Type: What kind of work do you need done?
Software related (Includes desktop applications and internet websites)
Project Parts: What do you want the worker to do on this project?
Programming: The worker will take the requirements and translate them into the language of the computer (and test it).
Program Type: What kind of software should the worker create (and/or install)?
  • A desktop or server program: This software runs on a user's own PC/workstation, or on a server.
  • Other:VBA (excel)
Desktop / server program info
Size of application: How many screens/forms need to be created/edited in this application?
Exactly 0.
Programming Language: What programming language(s) do you want your application written in?
I do know the language(s).
Languages(s):
  • Visual Basic
  • Visual Basic for Applications (VBA)
  • Visual Basic .Net
Operating system(s) What operating systems(s) do you want your application to work on?
I do know the operating system(s):
  • Microsoft Windows -- version(s): xp/vista
    		•
    Database: Will this project include a database?
    No, it does not include a database.
    Legal: 1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
    2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
    2a) If there are any server-side deliverables (intended to only exist in one place in the Employer's environment) then they must be installed by the Worker in ready-to-run condition (unless specified elsewhere by the Employer).
    2b) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the Employer).
    3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased.
    3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement.
    Other Requirements:
     Categories:
    (Note: Like everything else on this page, these categories are part of the original contract for this project.)
    Microsoft Windows, Languages, Operating systems / platforms, Visual Basic, Visual Basic .Net, Visual Basic for Applications (VBA), Technology, Software Development, Desktop applications, Scripts and utilities, Other (Software development), Tech details

    Expert Guarantee Required:

         It is crucial to the employer that this entire project be completed (100%) by the deadline of 10 days. They only want expert workers who will commit themselves to this deadline to bid. If you are not an expert or unable to commit completely to the deadline, then DO NOT BID on this project.

         If you are an expert and can commit, the employer would like you to demonstrate this by making an     Expert Guarantee of at least 10% of your bid. (This would not need to be made now...but only if and when you are are selected as the winning bidder). If you complete the job (100% by the deadline), then your deposit would be refunded to you. If you do not, then you would forfeit the deposit and it would go to cover the employer's cancellation charge and the remainder donated to a non-profit charity.

         Please note that depending on how you choose to make the deposit, there may be a small, non-refundable processing fee. This fee can be reduced or eliminated by choosing a less expensive method of payment. Or, you may wish to ask the employer to cover the cost of the fee for you. You can do this in a number of ways such as: increasing the price of your bid, asking the employer to post a 2nd project to cover it (contingent on completion of the project), or by getting the employer to promise to pay the fee to you as a bonus (upon completion of the project). If you choose the bonus route, just remember that due to credit card/PayPal rules, vWorker.com CANNOT force an employer to pay a bonus involuntarily...even when promised on-site. So don't choose this option, unless you trust the employer, or are willing to take a small risk.

         This is just a very brief overview of how the Expert Guarantee works and there are many more details that you need to understand fully before you bid on this project. DO NOT BID on this project until you've read and fully understand everything about the Expert Guarantee (including reading the contract and the FAQs).
     
    Messages summary
    ( Back to shortcuts )
    All monetary amounts on the site are in United States dollars.
    vWorker.com is a closed auction, so workers can only see their own bids and comments. Employers can view every posting made on their projects.

    Bidding Closes At: Aug 7, 2010 3:20:33 PM EDT
      Max accepted bid: Open to fair suggestions
    No bids have been posted yet. Why can't I view bids from other workers who are bidding against me?
    Bidding/comment cannot be viewed until you are logged in.
    No bidding allowed, because this project was cancelled.
    Cancelled Date: 8/15/2010 1:10:04 AM
    Cancelled Reason: Cancelled by automated program due to time expiration
    e
     
     
    Ratings
    ( Back to shortcuts )

    This project has no ratings yet
     
    Search
    'All Workers' Competition.
      What is this list?
      1. cricava
        10 avg. over 379 jobs.
      2. Gravity Jack, Inc.
        9.8 avg. over 61 jobs.
      3. Lisa_G
        9.9 avg. over 1864 jobs.
      4. calciustec h
        9.81 avg. over 1541 jobs.
      5. Pop Mihai Sergiu
        10 avg. over 165 jobs.
      6. PSergei
        9.87 avg. over 481 jobs.
      7. DX Silverligh t Team
        9.79 avg. over 315 jobs.
      8. Dali Studio
        9.83 avg. over 181 jobs.
      9. CodeAndMor e
        9.95 avg. over 522 jobs.
      10. Ing. Gervasio Marchand Cassataro
        10 avg. over 187 jobs.

      ...See ALL workers by ranking
    Newest projects.
    See ALL...

    Click here to put this ticker on your own site and/or get live RSS newsfeeds.

    Copyright © 2001-2010 Exhedra Solutions, Inc. All rights reserved. By using this site you agree to its Terms and Conditions. vWorker.com™, "Expert Guarantee"™ AccuTimeCard™ and "More capable, accountable and affordable. Guaranteed."™ are trademarks of Exhedra Solutions, Inc.. Page generated by IISPROD11 at 9/10/2010 9:07:25 PM