Skip navigation
4465 Views 12 Replies Latest reply: Oct 3, 2007 12:00 AM by ptc-1368288 RSS
delopez1966 Copper 1 posts since
Sep 11, 2007
Currently Being Moderated

Sep 11, 2007 12:00 AM

Plotting Hydrology Daily Discharge Data from Excel

Class: Intro to Physical Hydrology

I am trying to plot daily discharge data (for a tributary river into the Rio Grande River) versus time from a MS Excel 2000 worksheet. I imported the data from a class web page and did the necessary unit conversions in Excel. Now, I need to plot daily discharge versus time for the entire record...from 1932 to present.

As you can imagine there are several thousand data points involved, the cell range is from G3 to G27367, and the corresponding dates for each data point range from cell H3 to H27367. I prefer to plot this data using MathCAD 11 instead of MS Excel 2000, but at this point I am open to suggestions. How can I import the data from MS Excel into MathCAD 11 and do the plot for the entire record period???
  • A.Non Diamond 10,147 posts since
    May 11, 2010
    Currently Being Moderated
    Sep 11, 2007 12:00 AM (in response to delopez1966)
    Plotting Hydrology Daily Discharge Data from Excel
    You can just use a file input component to read the file. How you plot it depends on the format of the dates. Can you post a version of the Excel file with only the first 100 data points.

    Richard
  • superres Silver 7,759 posts since
    Jun 1, 2007
    Currently Being Moderated
    Sep 11, 2007 12:00 AM (in response to delopez1966)
    Plotting Hydrology Daily Discharge Data from Excel
    On 9/11/2007 9:35:42 AM, delopez1966 wrote:
    >Class: Intro to Physical
    >Hydrology
    >
    >I am trying to plot daily
    >discharge data (for a
    >tributary river into the Rio
    >Grande River) versus time from
    >a MS Excel 2000 worksheet. I
    >imported the data from a class
    >web page and did the necessary
    >unit conversions in Excel.
    >Now, I need to plot daily
    >discharge versus time for the
    >entire record...from 1932 to
    >present.
    >
    >As you can imagine there are
    >several thousand data points
    >involved, the cell range is
    >from G3 to G27367, and the
    >corresponding dates for each
    >data point range from cell H3
    >to H27367. I prefer to plot
    >this data using MathCAD 11
    >instead of MS Excel 2000, but
    >at this point I am open to
    >suggestions. How can I import
    >the data from MS Excel into
    >MathCAD 11 and do the plot for
    >the entire record period???

    You have more datapoints than is plottable on any known display. You need to carefully consider how the data needs to be displayed and ensure that your plot corresponds to both actual data and expectation.

    TTFN,
    Eden
  • PhilipOakley Silver 2,084 posts since
    Feb 20, 2007
    Currently Being Moderated
    Sep 11, 2007 12:00 AM (in response to delopez1966)
    Plotting Hydrology Daily Discharge Data from Excel
    I named a 'Range' in excel refering to my data, then used the excel import wizard. The excel named range could be set to the whole columns if needed (which allows for extending data).

    This was in V11.2

    It was then relatively easy to plot/compute/analyse in MathCAD

    Philip Oakley
  • ptc-1368288 Copper 15,155 posts since
    Nov 15, 2007
    Currently Being Moderated
    Sep 11, 2007 12:00 AM (in response to delopez1966)
    Plotting Hydrology Daily Discharge Data from Excel
    >G3 to G27367, and the corresponding dates for each data point range from cell H3 to H27367<<br> _______________________

    But that's only two cols of 27364 rows.
    Just a peanut for mathcad !

    jmG
    • Copper 31 posts since
      May 5, 2003
      Currently Being Moderated
      Oct 2, 2007 12:00 AM (in response to ptc-1368288)
      Plotting Hydrology Daily Discharge Data from Excel
      I have a problem with a similar (but smaller) dataset.

      I can plot against time because in the Excel file I can format the date as a number before Importing into Mathcad 11.
      35600 or some such, incrementing by one for each day.

      In Excel, I can reformat a second column with the date as various other formats "3 March 1996" etc. That is useful for comparing with other narratives or correlating different data sets.
      (As far as I can find MC11 has no similar facility)

      If I want to see what day a data point on a chart corresponds to, then I identify the point with the Trace function and copy/paste the X-value into a special "Date" function (Defined at the start of my MC11 sheet as a Excel component with only two cells, one formatted in each way, the second giving a string output).

      Near to my charts, I have a small region:
      Date(35000) = (The string version appears here).

      There must be an easier way which does not use copy/paste. Preferably one which can be used in Plotting as an axis format option.

      Do you have the same problem?
      Is it addressed in later Mathcad versions?

      TOM RADFORD
  • Copper 31 posts since
    May 5, 2003
    Currently Being Moderated
    Oct 2, 2007 12:00 AM (in response to TomGutman)
    Plotting Hydrology Daily Discharge Data from Excel
    Thanks yet again, Tom

    TOM
  • Copper 31 posts since
    May 5, 2003
    Currently Being Moderated
    Oct 2, 2007 12:00 AM (in response to TomGutman)
    Plotting Hydrology Daily Discharge Data from Excel
    Thanks yet again, Tom

    TOM
  • TomGutman Silver 10,537 posts since
    Oct 22, 2006
    Unless you have registry errors there should be no need to have Excel running for the embedded Excel sheet to function. It will be activated automatically.

    There is no provision for the labels on an axis to be anything other than numbers. No way to get year and month.

    But you can scale the numbers any way you want. For a graph that runs for years I would scale the time to years from year zero. Then the you can read the time in years and decimal fractions of a year. Thus you would immediately see 1947.5 as halfway through the year 1947, but recognizing that as six months into the year remains a mental exercise for the reader.

    � � � � Tom Gutman
  • Copper 31 posts since
    May 5, 2003
    Currently Being Moderated
    Oct 2, 2007 12:00 AM (in response to FredKohlhepp)
    Plotting Hydrology Daily Discharge Data from Excel
    Thanks for those, I will try them.

    Mine is simpler, see the attached.
    But it has the disadvantage that Excel must be running, or the Date(xxx) function is undefined.

    Can these be used as format for the plotting?
    Just the month and year would be useful.

    TOM RADFORD
    Attachments:
  • ptc-1368288 Copper 15,155 posts since
    Nov 15, 2007
    Currently Being Moderated
    Oct 3, 2007 12:00 AM (in response to ptc-1368288)
    Plotting Hydrology Daily Discharge Data from Excel
    Erratum:
    >Check all the possible scripted components you can write in Excel <.

    Read ...Check all the possible scripted components you can write in "Mathcad".

    jmG

More Like This

  • Retrieving data ...

Bookmarked By (0)