How do i create a graph for a time scale with active points 1

[edelwater]

Hello,

I ordered the sleeptracker (see google) watch on the internet and it delivers me daily an overview of my waking moments like this:

01 0:52:29
02 1:30:38
03 3:31:44
04 3:51:29
05 4:23:56
06 4:45:23
07 5:02:08
08 5:27:41
09 5:41:02
10 5:58:47
11 6:19:08
12 6:43:26

These are the moments in the night when i am slighly more "awake".

I now want to enter these in a spreadsheet and then create a graph which shows on the X-axis a fixed timescale (e.g. 0:00 until 7:00) and then on the Y-axis i want to see a sort of REM sleep graph, so not just a line but really a "top" on the times indicated as above and between the points indicated a sort of graphc which is a sort of "valley" in between.

And... i dont really know how to do this in Excel i played around and made some graphs but somehow i dont succeed in doing this.

Do you guys think i need to first parse the data through a vb script or something?









--

http://leau.net

 

[SkipVought]

Hi,

All you posted was the x-axis data (time)

Where is your y-axis data? aren't there 4 stages?

Skip,
[sub]
[red][/red]
[/sub]

 

[GlennUK]

I think he/she has just given the peaks, with no "trough" information.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[dallen43]

Have you tried to put a 1 in the column next to the times. Then do a scatter graph? Basically, you'll get a line with points that indicate the various times. They will be spaced apart appropriately.

 

[SkipVought]

You'll probably want your source data like this, plotted SCATTER with LINES no MARKERS...
[tt]
Time REM
0:52:29 0
0:52:29 1
1:30:38 1
1:30:38 0
3:31:44 0
3:31:44 1
3:51:29 1
3:51:29 0
4:23:56 0
4:23:56 1
4:45:23 1
4:45:23 0
5:02:08 0
5:02:08 1
5:27:41 1
5:27:41 0
5:41:02 0
5:41:02 1
5:58:47 1
5:58:47 0
6:19:08 0
6:19:08 1
6:43:26 1
6:43:26 0
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[edelwater]

Thankx for the scatterplot tip, SkipVought I think on your proposal it shows that the time between waking moments is uhm awake so i think the points in between should be the average value in between with a 0 value, like this:

0:52:29 1
1:11:33 0
1:30:38 1
2:31:11 0
3:31:44 1
3:41:37 0
3:51:29 1
4:07:43 0
4:23:56 1
4:34:40 0
4:45:23 1
4:53:46 0
5:02:08 1
5:14:55 0
5:27:41 1
5:34:22 0
5:41:02 1
5:49:55 0
5:58:47 1
6:08:58 0
6:19:08 1
6:31:17 0
6:43:26 1

Where the points in between are =(A23-A21)/2+A21 if the point is A20.

Hmm... now i need to automate this. The watch shows the numbers but unfortunately I have to type them in day by day, so for each day i will create a new spreadsheet.





--

http://leau.net

 

[edelwater]

Hmmm...probably i am still wrong, if i read the faq on

http://www.sleeptracker.com/howitworks_stages.aspx

I probably miss something.

1. I should divede the downslope in the REM phase and then 4 more phases
2. I dont know for sure if the periodes between wake stages are uhm... wake or sleep.

Im going to verify this with sleeptracker i think.

--

http://leau.net

 

[edelwater]

hmmm.. this is probably more exactly (the points in between the 5's are interpollated):

0:52:29 5
1:11:33 0
1:30:38 5
2:31:11 0
3:31:44 5
3:41:37 4
3:51:29 5
4:07:43 1
4:23:56 5
4:34:40 4
4:45:23 5
4:53:46 2
5:02:08 5
5:14:55 4
5:27:41 5
5:34:22 3
5:41:02 5
5:49:55 4
5:58:47 5
6:08:58 3
6:19:08 5
6:31:17 4
6:43:26 5


--

http://leau.net

 

[SkipVought]

Copy the Time range only and paste below the time range

in the value column in the first row containing the new time range, enter a reference to the SECOND VALUE, for example =B3 since row 1 is a heading and copy that to the bottom of the time range.

Copy column B

Edit/Paste Special - VALUES

SORT on column a

PLOT...

VOLA!



Skip,
[sub]
[red][/red]
[/sub]