Käynnissä

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 85 $ tähän työhön

dataworker2009

Hi Dan-Pls take a look to your [url removed, login to view]

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 [url removed, login to view] 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