H
Hank Roberts
I have a list of measurements taken that are identified by
month/day/hour/minute, and I need to drop those into Excel
so I can later graph them.
To see trends I need to have them spread out in proportion
to the time between measurements.
(Making sense so far?
For a very gross example, if I measured snowfall by month
and skipped the zero months, a chart wouldn't work:
5 x x x
4 x x
3 x
2
1
0
Jan Feb Mar Oct Nov Dec
So I need to graph it as though I have blank rows when I
do NOT have any data. And since it's by minute, that gets
into a gazillion blanks, thirty days hath September,
April, June ... February ... etcetera.
So ignoring Leap Year -- is there any straightforward way
I can take the information, lay it out so there are
appropriate gaps between entries and see how it spreads
across a period of years?
IF this makes no sense, I won't be too surprised.
month/day/hour/minute, and I need to drop those into Excel
so I can later graph them.
To see trends I need to have them spread out in proportion
to the time between measurements.
(Making sense so far?
For a very gross example, if I measured snowfall by month
and skipped the zero months, a chart wouldn't work:
5 x x x
4 x x
3 x
2
1
0
Jan Feb Mar Oct Nov Dec
So I need to graph it as though I have blank rows when I
do NOT have any data. And since it's by minute, that gets
into a gazillion blanks, thirty days hath September,
April, June ... February ... etcetera.
So ignoring Leap Year -- is there any straightforward way
I can take the information, lay it out so there are
appropriate gaps between entries and see how it spreads
across a period of years?
IF this makes no sense, I won't be too surprised.