You can use SQL, Excel or Visual Basic, if you'd rather.

From	Jeff-Relf.Me <@.>
Newsgroups	comp.os.linux.advocacy, comp.lang.c++, sci.physics
Subject	You can use SQL, Excel or Visual Basic, if you'd rather.
Date	2017-01-19 20:20 -0800
Organization	Glorb Internet Services, http://www.glorb.com
Message-ID	<Jeff-Relf.Me@Jan.19--8.20P.Seattle.2017> (permalink)
References	<Jeff-Relf.Me@Jan.19--0.57A.Seattle.2017> <o5rv5b$vf8$2@dont-email.me>

Cross-posted to 3 groups.

Show all headers | View raw

You ( MrDFS ) replied to me:
> > Given this ( tracking when my monitor was off ):
> >   http://Jeff-Relf.Me/SleepLog.TXT
> > Produce this:
> >   A table showing every HalfHour of the day OffLine, last 15 months:
> >   http://Jeff-Relf.Me/SleepPat.HTM  http://Jeff-Relf.Me/SleepPat.PNG
> 
> I might give it a shot, if you help me understand some things.
> 
> The output is kind of interesting to look at, but I suggest you could
> also put your sleep log entries in a database and much more easily draw
> various plots and diagrams.  You could log the data in SQLite, and
> probably plot it using R.

I can plot it whichever way I want; I'm better with C++ than SQL.
You can use SQL, Excel or Visual Basic, if you'd rather.

> Why do days begin at 3am?

Because that's how it is, _de _facto.
Noon is 3pm, the day ends at 3am; 9am to 9pm are mid_day.
People say, " See you at 2am tonight "; not: " 2am tomorrow ".

Chart it normally, where each day ( each column ) ends at 11:59pm,
then chop 3 hours ( 6 rows ) off the top, 
and slap it on the bottom, shifted left one day ( one column ).

> 44.5 hour Day, 33% offline:
> 
>   8.5        Jan  9 {  9:49 A, 2017 }: 9       VаΓȻ
>          .0  Jan  9 {  1:21 A, 2017 }: 9  157  VаɝΞ
> 
> 44.5 hour day?

Search for the line that ends with "offline:";
then plot the 8.5 ( hours ) from the line below.

_My day begins when I wake up, after sleeping 4 hours or more
( but not more than 16 hours; as my monitor might just be off ).
"X.EXE" updates "SleepLog.TXT" whenever I turn my monitor on or off.

From that, I can tell you how long _my day was.

> What kind of odd date format is:
> Jan  9 {  9:49 A, 2017 }: 9
> Is that 2017-01-09 09:49:09 ?  

Yes.

> If so, why are you capturing seconds if they're never used?

"SleepPat.HTM" doesn't use it, but I do, personally.

> It looks like you're missing most but not all zeroes.  Intentional?

I prefer "9" over "09", because it's more readable.
"Aug 29 {   :   P, 2016 }" ( in SleepLog.TXT ) is 12:00pm.

> Why are the 2 columns at left staggered?

The 8.5, in the far left column, is hours offline.
The .0 that begins the next line, staggered, is hours _on_line.

The offline hours are all in their own column;
same for the on_line hours, in the next column.

> What do the 7 and 157 at right represent?

The 157 on the far right is seconds online;
it's only there when it's a small number; otherwise, it's blank.

> What's with the 4 characters at the end of each line?

VаТω is seconds since 1970, in Base360 ( like Base64 ).

> To each his own, but it's like you go out of your way
> to make everything different and weird.  To what end?

It's custom; I like custom " hot rods ".

Thread

Every OffLine hour of the day, last 15 months. Jeff-Relf.Me <@.> - 2017-01-19 00:57 -0800
  Re: Every OffLine hour of the day, last 15 months. noTthaTguY <abu.kuanysh05@gmail.com> - 2017-01-19 10:19 -0800
  You can use SQL, Excel or Visual Basic, if you'd rather. Jeff-Relf.Me <@.> - 2017-01-19 20:20 -0800
    People woke me up; so I slept 4 hours today, twice, for a total of 8. Jeff-Relf.Me <@.> - 2017-01-21 04:44 -0800
      Re: People woke me up; so I slept 4 hours today, twice, for a total of 8. Mr Flibble <flibbleREMOVETHISBIT@i42.co.uk> - 2017-01-21 17:57 +0000
  When I'm likely to be asleep. Jeff-Relf.Me <@.> - 2017-01-19 20:33 -0800

csiph-web