Tracking App hours

log in

Advanced search

Message boards : Number crunching : Tracking App hours

1 · 2 · Next
Author Message
Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 1349 - Posted: 13 Jul 2013, 14:39:18 UTC

At the moment we can only see the hours for our own apps, is there any reason this data is private?

Would it be possible to make this data available in XML form so that I could download, parse and put into a database so it could be tracked daily (I would hold last 28 days or so) at http://stats.free-dc.org

I think I could mine some fascinating data across apps. For instance it would be a simple matter to track the top apps by hours across all projects.
____________

Profile [AF>WildWildWest]Sebastien
   
Dictator
Avatar
Send message
Joined: 28 Mar 10
Posts: 1425
Credit: 310,761
RAC: 0
Total hours: 566,580
Message 1359 - Posted: 13 Jul 2013, 18:38:05 UTC - in response to Message 1349.
Last modified: 13 Jul 2013, 18:46:33 UTC

I added an option in WUProp@home Preferences which allows user to publicize their app hours statistics.
For example, my account data page: http://wuprop.boinc-af.org/show_user.php?userid=1

An XML export is available here. It contains data from users which accept to publicize the statistics.
Export will be updated every hours.
____________

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 1360 - Posted: 13 Jul 2013, 19:59:59 UTC

Awesome! Thanks.

I'll begin writing a script to store this data into tables and publish it in the next few days.
____________

Profile Saenger
   
Avatar
Send message
Joined: 28 Mar 10
Posts: 71
Credit: 260,634
RAC: 129
Total hours: 326,337
Message 1361 - Posted: 14 Jul 2013, 12:08:45 UTC

Thanks as well!
Already unhid mine, wonder whether STE\/E will do as well ;)
____________
Grüße vom Sänger

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 1363 - Posted: 14 Jul 2013, 16:14:01 UTC
Last modified: 14 Jul 2013, 16:16:15 UTC

It's a little raw right now, but I wanted to at least get the data out there.

31 users so far have opted in.

I've got some ranking columns to add, which are per-app, not sure how meaningful they would be when not everyone opts in, but might be interesting anyway. Have to link the projects to my internal table with my shortened project names too and fix up the last7 and last28

http://stats.free-dc.org/stats.php?page=user&proj=wup&name=84
____________

Profile Dunuin
 
Send message
Joined: 5 Jun 12
Posts: 5
Credit: 151,128
RAC: 0
Total hours: 159,850
Message 1367 - Posted: 14 Jul 2013, 20:22:48 UTC
Last modified: 14 Jul 2013, 20:23:03 UTC

I'm missing the username, teamid and teamname in the xml :-(

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 1369 - Posted: 14 Jul 2013, 20:54:43 UTC - in response to Message 1367.

I'm missing the username, teamid and teamname in the xml :-(


The id is in there though and you can get the rest from the regular xml via that.

No need to add extra data when it's not needed..

____________

Profile STE\/E
         
Avatar
Send message
Joined: 28 Mar 10
Posts: 399
Credit: 3,293,729
RAC: 271
Total hours: 17,161,458
Message 1371 - Posted: 15 Jul 2013, 7:01:46 UTC - in response to Message 1361.

Thanks as well!
Already unhid mine, wonder whether STE\/E will do as well ;)


I would but then I would have to Kill Everyone ... lol ... ;)

____________

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 1388 - Posted: 20 Jul 2013, 21:39:31 UTC
Last modified: 20 Jul 2013, 22:13:07 UTC

I added some basic sorting if you click on the headers for today, yesterday, last update, project etc
____________

zombie67 [MM]
           
Avatar
Send message
Joined: 30 Mar 10
Posts: 140
Credit: 6,122,468
RAC: 2,261
Total hours: 19,600,529
Message 1389 - Posted: 20 Jul 2013, 21:53:23 UTC - in response to Message 1388.

I added some basic sorting if you lick on the headers for today, yesterday, last update, project etc

Thanks!!

____________
Dublin, California
Team: SETI.USA

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 1536 - Posted: 28 Aug 2013, 17:42:27 UTC
Last modified: 28 Aug 2013, 17:43:53 UTC

If anyone is interested I've been redoing the stats somewhat to bring it a little more up to date. The userpage with Wuprop hours on was one of the first and it's at least closer to completion than the others :)

All columns are sortable now in any table. (client side sort)

I added the same colors as Wuprop based on the the levels, though it makes them a little difficult to read at times IMO. I guessed at the 5000hr color as I don;t have any projects there yet.

http://stats6.free-dc.org/stats.php?page=user&proj=wup&name=84

Personally I find the 'search' feature very useful on the table, try entering 'prim' for instance and it dynamically reduces the resultset
____________

zombie67 [MM]
           
Avatar
Send message
Joined: 30 Mar 10
Posts: 140
Credit: 6,122,468
RAC: 2,261
Total hours: 19,600,529
Message 1537 - Posted: 29 Aug 2013, 1:55:51 UTC

Very very cool! Love the colors.
____________
Dublin, California
Team: SETI.USA

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 2513 - Posted: 18 Dec 2014, 15:42:33 UTC
Last modified: 18 Dec 2014, 15:42:44 UTC

Thought I'd bump this thread given new users might not even know about the option.. There are now 488 distinct id's that have (at least at some point) checked the preferences flag here to allow their wuprop hours to be exported.

Though the data is available in the regular freedc-stats, I've been tweaking the page on my rewrite some more.

Zombie67's hours shown below for reference. Can't seem to find a decent background color which displays each color level distinctly.

http://stats6.free-dc.org/user/wup/797
____________

Profile Conan
       
Avatar
Send message
Joined: 28 Mar 10
Posts: 367
Credit: 726,552
RAC: 268
Total hours: 1,551,834
Message 2515 - Posted: 19 Dec 2014, 7:27:27 UTC - in response to Message 2513.

Thought I'd bump this thread given new users might not even know about the option.. There are now 488 distinct id's that have (at least at some point) checked the preferences flag here to allow their wuprop hours to be exported.

Though the data is available in the regular freedc-stats, I've been tweaking the page on my rewrite some more.

Zombie67's hours shown below for reference. Can't seem to find a decent background color which displays each color level distinctly.

http://stats6.free-dc.org/user/wup/797


Bok, that is now really amazing, all the extra stats for me to look at, it's great.
No wonder your stat site is by far the best and the one I use.

Conan
____________

tullus
 
Send message
Joined: 7 Apr 13
Posts: 5
Credit: 203,521
RAC: 163
Total hours: 177,319
Message 2516 - Posted: 19 Dec 2014, 8:57:10 UTC - in response to Message 2513.
Last modified: 19 Dec 2014, 9:01:31 UTC

Thought I'd bump this thread given new users might not even know about the option.. There are now 488 distinct id's that have (at least at some point) checked the preferences flag here to allow their wuprop hours to be exported.

Though the data is available in the regular freedc-stats, I've been tweaking the page on my rewrite some more.

Zombie67's hours shown below for reference. Can't seem to find a decent background color which displays each color level distinctly.

http://stats6.free-dc.org/user/wup/797


Great! Just a quick note: Before I checked off to allow export I got this message:
"No data available in table" in the "WuProp Hours" table.
Could this be improved with a better explanation? i.e. "have you enabled export, if not, go here, click that...".

Edit: Vops, I spoke too soon, on http://stats.free-dc.org/ I get the more meaningful:
"You must enable the option to allow export of your hourly data at the WuProp website in your preferences to see data"
(although a description of which preference pane to click would make it even better). The original comment was based on http://stats6.free-dc.org

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 2519 - Posted: 19 Dec 2014, 13:27:39 UTC
Last modified: 19 Dec 2014, 13:29:21 UTC

Good catch. I've added some verbiage to stats6 now.

As an aside, note that because I'm now using datatables there are quite a few advantages. Try typing a few letters in the search box for that table. It will restrict the list to just those characters. Case insensitive.
____________

Profile Conan
       
Avatar
Send message
Joined: 28 Mar 10
Posts: 367
Credit: 726,552
RAC: 268
Total hours: 1,551,834
Message 2521 - Posted: 19 Dec 2014, 23:08:41 UTC

In the case of the background colour, as it is near impossible to see black on black and the purple on black is difficult, perhaps a light blue, though grey/silver might be difficult with this.
You could also use white with black edging.

Just a couple of thoughts on the matter.

Conan
____________

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 3080 - Posted: 3 Jul 2015, 15:24:25 UTC
Last modified: 3 Jul 2015, 15:24:59 UTC

Added project ranking within project/app to the wuprop hours data.

With this I can add a link to a page showing each app in project rank order (Work in progress).

I think I will also change this to show the colored stars too rather than the colored text like Sebastian has done here as that's so much better.

See my my page for examples.

Didn't realize I was #1 on a few of these !! Of course they are opt-in here in the preferences so not everyone is displayed..
____________

Profile Conan
       
Avatar
Send message
Joined: 28 Mar 10
Posts: 367
Credit: 726,552
RAC: 268
Total hours: 1,551,834
Message 3083 - Posted: 4 Jul 2015, 6:30:36 UTC

This is looking good, I like the ranking idea as you get surprised by how far up the ladder you are (as you said it is only amongst the ones who have selected the option in their preferences).

Some of the colours are hard to see but I don't see how you can get round this very easily.

Thanks again Bok for your efforts in making stats a bit more fun.

Conan
____________

Bok
         
Send message
Joined: 28 Mar 10
Posts: 80
Credit: 518,707
RAC: 130
Total hours: 1,822,116
Message 3085 - Posted: 4 Jul 2015, 20:25:44 UTC

I added links on the projrank field to a new page for each individual project app.

Now how can we get more users to opt-in ??
____________

1 · 2 · Next
Post to thread

Message boards : Number crunching : Tracking App hours


Home | My Account | Message Boards | Results


Copyright © 2018 Sebastien