This content has been marked as final. Show 12 replies
On 9/11/2007 9:35:42 AM, delopez1966 wrote:
>Class: Intro to Physical
>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
>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.
� � � � Tom Gutman
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.
Date example.mcd 37.1 K
Can you not get rid of Excel ?
Check all the possible scripted components you can write in Excel.
1. input 3 as an input table
2. the graph date locator (slider)
3. Richard calendar
4. the absolute time
5. two work sheets from Mathcad 8 qs.
Date example(1).mcd 96.2 K