Groups > comp.os.linux.advocacy > #390542

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. DFS <nospam@dfs.com> - 2017-01-19 22:12 -0500
    Re: Every OffLine hour of the day, last 15 months. deplorable owl <owl@rooftop.invalid> - 2017-01-20 03:16 +0000
      When I'm likely to be asleep. Jeff-Relf.Me <@.> - 2017-01-19 20:33 -0800
        Re: When I'm likely to be asleep. DFS <nospam@dfs.com> - 2017-01-21 15:58 -0500
          On SleepPat.HTM's yAxis:  Two rows = one hour. Jeff-Relf.Me <@.> - 2017-01-21 19:30 -0800
            On SleepPat.HTM's yAxis:  Two rows = one hour. Jeff-Relf.Me <@.> - 2017-01-24 13:01 -0800
              Re: On SleepPat.HTM's yAxis:  Two rows = one hour. deplorable owl <owl@rooftop.invalid> - 2017-01-24 21:26 +0000
                A lot of it is just being OffLine, not sleeping. Jeff-Relf.Me <@.> - 2017-01-24 14:12 -0800
                Re: A lot of it is just being OffLine, not sleeping. deplorable owl <owl@rooftop.invalid> - 2017-01-24 23:36 +0000
                "Auto Sleep" is disabled, it can't happen. Jeff-Relf.Me <@.> - 2017-01-24 16:26 -0800
                Re: "Auto Sleep" is disabled, it can't happen. deplorable owl <owl@rooftop.invalid> - 2017-01-27 03:33 +0000
                Re: "Auto Sleep" is disabled, it can't happen. Me Sham <osirus47@yahoo.com> - 2017-01-26 19:51 -0800
                SleepLog.TXT _is a series of time stamps. Jeff-Relf.Me <@.> - 2017-01-26 22:39 -0800
                Re: SleepLog.TXT _is a series of time stamps. deplorable owl <owl@rooftop.invalid> - 2017-01-27 21:15 +0000
                What's right with US-ASCII and Base10 ?  not much. Jeff-Relf.Me <@.> - 2017-01-27 13:48 -0800
                Re: What's right with US-ASCII and Base10 ?  not much. deplorable owl <owl@rooftop.invalid> - 2017-01-28 00:38 +0000
                None of it is for you, all of it is for me. Jeff-Relf.Me <@.> - 2017-01-27 22:52 -0800
                Re: None of it is for you, all of it is for me. Steve Carroll <fretwizzer@gmail.com> - 2017-01-28 08:25 -0800
                Re: If you don't like it, try FaceBook or Reddit. Steve Carroll <fretwizzer@gmail.com> - 2017-01-28 09:36 -0800
                Re: None of it is for you, all of it is for me. Tattoo Vampire <sitting@this.computer> - 2017-01-29 09:24 -0500
                Re: None of it is for you, all of it is for me. Steve Carroll <fretwizzer@gmail.com> - 2017-01-29 08:36 -0800
                Re: I knew _exactly what everyone's response would be, all of it. Steve Carroll <fretwizzer@gmail.com> - 2017-01-29 12:33 -0800
                Re: I'm answering your questions, not begging for your attention. Steve Carroll <fretwizzer@gmail.com> - 2017-01-29 14:12 -0800
                Re: None of it is for you, all of it is for me. deplorable owl <owl@rooftop.invalid> - 2017-01-28 20:13 +0000
                Re: None of it is for you, all of it is for me. Snit <usenet@gallopinginsanity.com> - 2017-01-28 13:22 -0700
                "SleepPat.HTM" is _much cleaner now. Jeff-Relf.Me <@.> - 2017-01-29 04:34 -0800
                Re: "SleepPat.HTM" is _much cleaner now. deplorable owl <owl@rooftop.invalid> - 2017-01-29 19:38 +0000
                Re: "SleepPat.HTM" is _much cleaner now. Snit <usenet@gallopinginsanity.com> - 2017-01-29 13:38 -0700
                When will I wake up, most likely ? Jeff-Relf.Me <@.> - 2017-01-29 12:44 -0800
                Now the text version also shows the percent OffLine. Jeff-Relf.Me <@.> - 2017-01-24 16:09 -0800
                Re: Now the text version also shows the percent OffLine. DFS <nospam@dfs.com> - 2017-01-24 20:57 -0500
                "SleepPat.HTM" is dense, rich and complex, like my source code. Jeff-Relf.Me <@.> - 2017-01-25 00:44 -0800
                Re: "SleepPat.HTM" is dense, rich and complex, like my source code. DFS <nospam@dfs.com> - 2017-01-25 09:40 -0500
                Look at the yAxis, MrDFS.  Two Rows = 1 hour. Jeff-Relf.Me <@.> - 2017-01-25 07:01 -0800
              Re: On SleepPat.HTM's yAxis: Two rows = one hour. DFS <nospam@dfs.com> - 2017-01-24 19:12 -0500
                Now the percent OffLine number follows the date. Jeff-Relf.Me <@.> - 2017-01-24 16:17 -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

csiph-web