Using Macros to Assist Plotting USGS Earthquake Data

  The macros that one uses in worksheets can be quite sophisticated. One can use them to record one's actions to simplify doing a complicated repetitive task. For example, one can search the USGS earthquake catalog for the earthquakes that occurred in a specified region in given time span and save the results in a .csv which Excel can open. The macros need to be saved in an otherwise blank worksheet and to which the .csv data can be copied and pasted to. The first macro was designed for eliminating unneeded files and converting the date and time of an earthquake to decimal UTC day of year (doy). The next macro does the data needed for the histogram. The blank worksheet also contains macros to plot earthquake magnitudes vs doy and one to plot the histogram data.