Suoritettu

Excel Data

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

[url removed, login to view]:0:./list/bss/[url removed, login to view]:|TOM:/bss/[url removed, login to view]|

[url removed, login to view]:0:./list/bss/[url removed, login to view]:|TOM:/bss/[url removed, login to view]|

[url removed, login to view]:0:./list/bss/[url removed, login to view]:|TOM:/bss/[url removed, login to view]|

[url removed, login to view]:0:./list/bss/[url removed, login to view]:|TOM:/bss/[url removed, login to view]|

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.

Taidot: Excel

Näytä lisää: types garments needed fashion design, creating simple program excel, webpage programmer, top data, terms of agreement example, terms agreement sample, set data, sample terms of agreement, need of excel programmer, web promotion, tom thomas, typeface, TOM, thomas, thomas i, sponsor, price excel, lst, loc, import excel, html to excel, excel us, excel to html, excel programmer needed, excel html

Tietoa työnantajasta:
( 9 arvostelua ) Silver Spring, United States

Projektin tunnus: #455781

Myönnetty käyttäjälle:

jasnhelsinki

Hi dan. Please check PM for details

$50 USD 0 päivässä
(7 Arvostelua)
3.0

79 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

dataworker2009

Hi Dan-Pls take a look to your [login to view URL]

$100 USD 3 päivässä
(112 arvostelua)
6.6
schandraram

Hi Dan - Please see PMB for details of my bid. Thank you. Chandra.

$125 USD 5 päivässä
(40 arvostelua)
5.9
diem78

hi dan, please check PM. thanks

$100 USD 4 päivässä
(15 arvostelua)
5.2
ggopi

Lets start.

$100 USD 4 päivässä
(21 arvostelua)
4.8
jmddata

Hi Dan, Please check PMB. Regards Vinod Arora

$30 USD 30 päivässä
(8 arvostelua)
4.4
ExactSystems

"hi dan" Please see detail on PMB. regards

$125 USD 4 päivässä
(2 arvostelua)
4.3
mohanlg

Hi, Ready to start now. Please review PMB. thanks sunny

$145 USD 7 päivässä
(13 arvostelua)
3.8
madiy

Hi Dan, Please check PMB

$60 USD 4 päivässä
(6 arvostelua)
3.7
desklamp

Please check pm. Thanks.

$200 USD 10 päivässä
(2 arvostelua)
2.8
refractocd

Hi Dan. Please refer to PM. I am ready to start immediately.

$70 USD 2 päivässä
(3 arvostelua)
2.5
USCgrad

Hi Dan. This project is perfect for me. I actually keep a data base of many california state bills as part of my full time job. So I totally understand what the projects requires. Please pick me.

$50 USD 3 päivässä
(3 arvostelua)
2.7
silgate

Hi Dan,Please check pmb for more details.

$40 USD 2 päivässä
(3 arvostelua)
2.7
rangamohan

Hi, Ready to start. thanks. Mohan

$100 USD 10 päivässä
(2 arvostelua)
2.0
kfsw

hi dan no problem in scraping data into excel. i'm a vba programmer with 5 year experience.

$30 USD 2 päivässä
(5 arvostelua)
1.8
roonex

hi dan, Please view PMB. Thanks

$50 USD 1 päivässä
(2 arvostelua)
1.6
shwetakagliwal

hi dan, I have experience for such work. i can do it very easliy. Thanks.

$30 USD 1 päivässä
(1 arvostelu)
1.1
umraom

Please read the PM that follows for more details and example. Thanks

$100 USD 4 päivässä
(1 arvostelu)
1.0
HouseOfRanks

Hi DAN, Please see PM for details.

$120 USD 4 päivässä
(3 arvostelua)
1.0
pubudu79

$60 Please note, that the results depend on the regularity of the data. If there is a way for you to reconcile the validity of the output, it would be good, then I can tweak the extraction method.

$60 USD 3 päivässä
(0 arvostelua)
0.0
nshpta

I m doing works on Ms Excell for the last five years and using [login to view URL] more than 10yrs. I have very good speed and accuracy on excell sheets. Regards Aneesh

$100 USD 10 päivässä
(0 arvostelua)
0.0