Project Detail
Excel Data
Excel Data is project number 455781
posted at Freelancer.com. Click here to post your own project.
Bid Count: 80
Average Bid:
$ 85
06/24/2009 at 13:41 EDT
Project Creator:
dhuff1776
Employer Rating: 
(1 reviews)
Description
Project Description:The 4 web links below contain data on approximately 4,700 different laws that were offered in the US Senate over the last 2 years. For each law, the linked webpage displays information on “Number” “Title”, “Sponsor” “Committees” “Date Introduced” “Latest Major Action” and sometimes also has information under the headings “Cosponsors” and/or “Notes.” [Be aware that the data on “date introduced” appears in the same line as the data on “Sponsor” and so does not enjoy a its own separate bold typeface heading.]
I need these 6-8 fields of data on each of these 4,700 laws entered into excel -- one row for each law.
LINKS
http://thomas.loc.gov/cgi-bin/bdquery/d?d110:0:./list/bss/d110SN.lst:|TOM:/bss/110search.html|
http://thomas.loc.gov/cgi-bin/bdquery/d?d110:0:./list/bss/d110SJ.lst:|TOM:/bss/110search.html|
http://thomas.loc.gov/cgi-bin/bdquery/d?d110:0:./list/bss/d110SE.lst:|TOM:/bss/110search.html|
http://thomas.loc.gov/cgi-bin/bdquery/d?d110:0:./list/bss/d110SC.lst:|TOM:/bss/110search.html|
EACH LINK POINTS TO ONLY THE FIRST PAGE OF MANY PAGES OF DATA SO DO NOT FORGET TO CLICK ON “NEXT PAGE” (top left of the webpage) UNTIL YOU HAVE COVERED THE ENTIRE SET OF DATA UNDER EACH OF THE 4 LINKS.
As an example, I entered the data from the first 3 laws listed in the FIRST link into the excel file named “Sample Output.”
The end product should be 4 different excel files (1 for each of the 4 corresponding weblinks) for a total of approximately 4,700 rows of data. Each row represents a law and consists of from 6 to 8 individual cells with data on the law’s “date”, “sponsor” etc.
Although this seems labor intensive, I believe a good programmer would be able to do it fairly quickly using data import and other formulas and functions.
Bid Requirements:
• Bid price must be visible, not hidden
• Bid must specify the time needed to complete the task after winning the project which should not exceed 4 days.
• Include "hi dan" in your bid to confirm understanding/agreement with these terms.
Additional files submitted:
Sample Output.xls
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results
TheBestLinks
Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.