Excel Help

"KMarino" (KMarino) 06/11/2014 at 16:59 • Filed to: None

0

5

I am trying to pull data from this site:

http://www.nrc.gov/reading-rm/doc…

where it pulls the data for each date for the past 7 into excel

I basically need this but for the past few years. The data is there, but I don't know how to automate it. Any one know how to do this with out having to go to each date?

THANKS!

!!! UNKNOWN CONTENT TYPE !!!

RyanFrew > KMarino 06/11/2014 at 17:12

1

Do you know how to write a Macro at all? Trying to assess your skill level with Excel...

RyanFrew > KMarino 06/11/2014 at 17:14

0

You could at least take the Raw Data Text File for each year and separate that out manually, especially using some if/then or replace moves.

crowmolly > KMarino 06/11/2014 at 17:16

1

You will need to write a script to scrape each web page.

Format is:

http://www.nrc.gov/reading-rm/doc-collections/event-status/reactor-status/2014/20140611ps.html

Where the bold is the variable date. If you can download a raw text file en masse that would be easier to parse on your end.

RyanFrew > KMarino 06/11/2014 at 17:23

0

Actually, if this can wait until tomorrow, I kind of want to do it. Challenge accepted.

KMarino > RyanFrew 06/11/2014 at 17:36

0

I think i got it. I didn't see the raw text per year. i can use that into a txt doc and import it based on txt. then i can filter on the plants i want and the dates i want