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???
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.
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?
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.