New stats in Free-DC

[Rodzilla]

http://stats.free-dc.org/new/allproj.php?proj=d2ol

Thanks to Bok From Free-DC! :up:

[dE4]

:YIPPIE:

[Rodzilla]

System wide 3,137,406 results were turned in over the last 28 days...
We did 596,502 of those!

That means that system wide we have contributed 19% of all of the Cands turned in the last 28 days!!!!!

And yesterday we were responsible for completing 21.75% of all of the Cands!!!!!!!!!! Our little rag tag bunch of Overclocking fools is responsible for almost 1/4 of the Daily contribution.

Now if that isn't saying something about what we are doing... nothing will!

[Entity_Razer]

WHo da man?

we're Da man :p:


:banana4:

[Rodzilla]

WHo da man?

we're Da man :p:


:banana4:
And Gals! We have 2 on the team now! :D

[Bok]

Wow,

you guys are quick to notice :)

I've just coded that within the last few hours and really just threw it together, if you'd like to see anything else on it, give me a shout, pie chart showing team contribution over last 28 days perhaps ?

Bok :toast:

[Rodzilla]

Wow,

you guys are quick to notice :)

I've just coded that within the last few hours and really just threw it together, if you'd like to see anything else on it, give me a shout, pie chart showing team contribution over last 28 days perhaps ?

Bok :toast:

:lol: I was just about to PM you over at Free-DC! :lol:

It would be neat to add a column for the team stats and individual stats for 28 day contribution... :D

[Bok]

I'm not sure I totally understand ?

You can see the users 28 day contribution by drilling down on a user, I guess that is missing for teams though.

Is that what you mean?

Bok

[Rodzilla]

I'm not sure I totally understand ?

You can see the users 28 day contribution by drilling down on a user, I guess that is missing for teams though.

Is that what you mean?

Bok

No % contribution over the last 28 days. Like I figured up in the 3rd post of this thread.

[Bok]

Ahhh, right, I see what you mean..

let me think about it, shouldn't be too difficult I think.

Bok

[[XC] moddolicous]

Wow, 1/4 of daily percent with only around 1/2 - 2/3 of our team actually producing daily. Think about what it would be if we had the whole 100% team producing. Probably 30% or more.

[Bok]

Rodzilla,

see what you think of this

http://stats.free-dc.org/new/allteams2.php?proj=d2ol

I started doing percentages of the users within the team but it gets too difficult to track accurately because the team stats for the last 28 days are skewed by new and old users.

Bok

[jjcom]

WHo da man?

we're Da man :p:


:banana4:

lol good post :D

Yeah, We're doing very well :up: things are looking good :D

jjcom

[[XC] serlv]

Wow,

you guys are quick to notice :)

I've just coded that within the last few hours and really just threw it together, if you'd like to see anything else on it, give me a shout, pie chart showing team contribution over last 28 days perhaps ?

Bok :toast:

Very nice, Bok!

What would be cool is automated bar graphs, just like the overall project bar graph, but for each individual, for the last 28 days. Sort of like UD has.

And for each team, too. :)

( jeez, i don't ask too much, eh! :) )

[Bok]

Well, you already have them for users

see here

http://stats.free-dc.org/new/userstats.php?proj=d2ol&name=ser

I plan to do them for the team at some point soon too.

Bok :toast:

[[XC] serlv]

Doh!! I remember seeing the chart, the daily listings, on the left. Missed the bar graphs. How'd that happen? :)

:am: :am: :am:


You do great work, Mr. Bok!
Thanks for all your contributions. :)

[Rodzilla]

Rodzilla,

see what you think of this

http://stats.free-dc.org/new/allteams2.php?proj=d2ol

I started doing percentages of the users within the team but it gets too difficult to track accurately because the team stats for the last 28 days are skewed by new and old users.

Bok

The team stats are GREAT!!! Explain why it would be difficult to do it individually???? Like for me it would be 1.29% last 28 days and 0.27% overall

And for the XS_Community account it would be 0.06% past 28 days and 0.01% overall.

And just for kicks... for DDTUNG it would be 2.1% last 28 days and 0.45% overall.

[Bok]

Well,

percentages for individuals in the allusers.php is simple and I'll do that tomorrow, I meant individuals on the teamstats page where it would be showing the percentages the user has done within their team.

the algorithm would be

(user score in last 28 days * 100) / teamscore for last 28 days

Unfortunately the 'teamscore for last 28 days' is affected by people joining and leaving the team. Whilst I do track movement and the score at the time of the move it could still be error prone due to name changes when people leave and mainly due to the following example.

Say someone left the team 3 days ago, I'd have to recognize that and then work out how much they actually contributed to the team score whilst they were on the team, perhaps they joined 8 days ago and then left 3 days ago, makes it even more complex. Not impossible but a lot of processing seeing as how it's realtime.

Bok

[Rodzilla]

Well,

percentages for individuals in the allusers.php is simple and I'll do that tomorrow, I meant individuals on the teamstats page where it would be showing the percentages the user has done within their team.

the algorithm would be

(user score in last 28 days * 100) / teamscore for last 28 days

Unfortunately the 'teamscore for last 28 days' is affected by people joining and leaving the team. Whilst I do track movement and the score at the time of the move it could still be error prone due to name changes when people leave and mainly due to the following example.

Say someone left the team 3 days ago, I'd have to recognize that and then work out how much they actually contributed to the team score whilst they were on the team, perhaps they joined 8 days ago and then left 3 days ago, makes it even more complex. Not impossible but a lot of processing seeing as how it's realtime.

Bok

I wasn't even thinking of % of contribution tot he teams total... hmmmmm... that would be good to see too. I can see how that would be a problem. I however was thinking globally. I like to know what I have contributed in the bigger picture. 0.27% overall makes me realize I'm a little fish in big ocean... For now ;)

[Bok]

Added to allusers.php :)

same code, different table

Bok

[Rodzilla]

Sweet! :up:

[Rodzilla]

@ Bok... What happened to the "Best Day" in the Top Metrics group?
http://stats.free-dc.org/new/userstats.php?proj=d2ol&name=Rodzilla

[Rinsewand]

they look great - the percentages aren't rankable though?

as in - highest to lowest in terms of percentage.

RwD

[Rodzilla]

Just sort by 28 days and total cands... they will be in perfect order.

[Bok]

Best Day,

Since I changed the whole DB back end for speed, I only keep the last 28 days of stats so Best day is not tracked. However, I could track it seperately I think, let me add it to my todo list.

Yeah, I can't put sorting on the percentages themselves as they can't be done as an 'ORDER BY' in my sql statement as such, but Rodzilla is right, click the heading for last 28 days work and it will be the same anyway :)

Thanks for all the suggestions guys,

belated congrats on 2M in D2OL

Bok :toast:

[lv_dicedealer]

Nice work Bok

[Rinsewand]

heh, didnt think of that ... "DOH!"

love that stats tho Bok, much better than any other ones i can find! :toast:

[lv_dicedealer]

Bok , gotta question---

Why if you go to say a member Y's page and they are approaching member Z, the number of days to overtake is different on the two member pages?
ie- lv_dicedealer will overtake XS_MaZeR in 92.3 days (from lv_dicedealers stats page)
XS_MaZeR will be overtaken by lv_dicedealer in 79.6 days (from XS-MaZeR's stats page)

Basically the roadkill and barbeque stats dont match, Im guessing that you are using two different methods of arriving at the numbers, but they should be the same in the above example (since XS_MaZeR isnt even producing).

Not complaining about anything, just wondered if you were aware of it or if it was from two different approaches to get hopefully to the same data?

[caLume]

nice :YIPPIE:

[Bok]

Bok , gotta question---

Why if you go to say a member Y's page and they are approaching member Z, the number of days to overtake is different on the two member pages?
ie- lv_dicedealer will overtake XS_MaZeR in 92.3 days (from lv_dicedealers stats page)
XS_MaZeR will be overtaken by lv_dicedealer in 79.6 days (from XS-MaZeR's stats page)

Basically the roadkill and barbeque stats dont match, Im guessing that you are using two different methods of arriving at the numbers, but they should be the same in the above example (since XS_MaZeR isnt even producing).

Not complaining about anything, just wondered if you were aware of it or if it was from two different approaches to get hopefully to the same data?

Hmm, you're right! Never noticed before, I'll fix :)

Bok :toast:

[Rodzilla]

@ Bok....

When you look at our team’s stats... http://stats.free-dc.org/new/teamstats.php?proj=d2ol&team=XtremeSystems

We have so many members that we have 2 pages (soon to be 3). The totals at the bottom of the pages are per page only... not a total of the entire team. Also... when you look at the pie charts... they are different on each page. And I just noticed that the "Back" button doesn’t work on the second page.

Oh... and how do you use the filter between the pie chart and the stats breakdown? (All Users - Users Active Today)

Thanks for all your hard work... If I didn't spend so much time on these stats I would have never noticed these minor problems :lol:

[Bok]

Sorry, meant to erply a while ago and totally forgot!

@ Bok....

When you look at our team’s stats... http://stats.free-dc.org/new/teamstats.php?proj=d2ol&team=XtremeSystems

We have so many members that we have 2 pages (soon to be 3). The totals at the bottom of the pages are per page only... not a total of the entire team. Also... when you look at the pie charts... they are different on each page. And I just noticed that the "Back" button doesn’t work on the second page.



I tally the totals in realtime, I guess I could add a seperate line for page totals (current ones) and overall totals?? Same goes for pie charts, I use the data as it's pulled out from the SQL statement, which on a different page is different users. Propbably doesn't make much sense though. I'll change it to always be the real top 10. It's slightly more costly as it will be a seperate SQL statement, but then it will be in the cache anyway. As for the Back button, I dislike those buttons anyway. They are going to change.


Oh... and how do you use the filter between the pie chart and the stats breakdown? (All Users - Users Active Today)


hehe, you don't really. I started putting it in and wanted it to activate on changing the dropdown, but then that needs to be clientside == javascript which I know very little of. I meant to put in a button instead which would be serverside but forgot. You can get it to work by just adding an &a=1 to the url....


Thanks for all your hard work... If I didn't spend so much time on these stats I would have never noticed these minor problems :lol:

:cheers:

just wish I had more time at the moment to implement things I'd like to!! Plus I'm doing stats for the Dimes project and full stats for DHEP ATM as well as a login systems for users to customize their own stats pages/signatures :)

Bok

[Jeff]

Thanks again for all your hard work Bok. :toast:

[Cossey]

i liked the pie charts being just for that page. up untill yesterday i was on page 2 and it was nice to have the charts about you and the ppl around you rather than the top of the team who i could see by going to page 1.

[WindForce]

just wish I had more time at the moment to implement things I'd like to!! Plus I'm doing stats for the Dimes project and full stats for DHEP ATM as well as a login systems for users to customize their own stats pages/signatures :)
Bok

Bok
PMFJI, but who pays you for all your great work? Is there some way i can contribute?

[Bok]

ack, no-one pays. The server which the stats run on as well as the Free-DC forum runs to $130 per month (servermatrix.com), but I'd have the server anyway as I run a few other websites on there for various friends..

I've had a few people buy me a DVD every now and then, I really should get a wishlist up at Amazon, I love Doctor Who btw, which is where 'Bok' comes from!!

If anyone can offer coding (PHP / Perl) I could probably put it to use :)

Bok

[WindForce]

ack, no-one pays. The server which the stats run on as well as the Free-DC forum runs to $130 per month (servermatrix.com), but I'd have the server anyway as I run a few other websites on there for various friends..

I've had a few people buy me a DVD every now and then, I really should get a wishlist up at Amazon, I love Doctor Who btw, which is where 'Bok' comes from!!

If anyone can offer coding (PHP / Perl) I could probably put it to use :)

Bok

Sorry, no PHP / Perl in here, just my good old Visual Foxpro. Should you need any *material* ( as in money ) help, just PM me.

[UCmajewski]

I love how since the merger it messed up the stats we even have DDtung on our BBQ as well as Ronbo ( tops in the world ). :)

Oh well we havent been putting up numbers since two systems windows installs died as well as my Tbred not having a home next week though should be the week we make a run at main pie.

[Bok]

Haven't figured out the difference in the roadkill/barbecue overtakes yet, but I added a few other bits today. I'll wait for you all to find them :) Still tweaking one of them.

Bok

[Rodzilla]

User movement! :up: http://stats.free-dc.org/new/allmovement.php?proj=d2ol
And
New users! :up: http://stats.free-dc.org/new/newusers.php?proj=d2ol

[Bok]

You missed this one

http://stats.free-dc.org/new/teamrank.php?proj=d2ol&team=XtremeSystems

not new, but a change....

Bok :)

[bachus_anonym]

You missed this one

http://stats.free-dc.org/new/teamrank.php?proj=d2ol&team=XtremeSystems

not new, but a change....

Bok :)
That and user-compare is what I was missing :thumbsup:

Thanks a lot Bok... Excellent job :toast:

[jikdoc]

@ bok, just do it daily then average for the month. that way you can keep track of people changing teams.

quick question, how did the dutch power cows get such a huge lead in d2ol? dunno much about d2ol history.

[bachus_anonym]

quick question, how did the dutch power cows get such a huge lead in d2ol? dunno much about d2ol history.
couple of the biggest fish from DPC have been with the project for 3 yrs now... generally, top4 teams have been created over 3 yrs ago ;)
our team is not even 6 months old...

[Bok]

That and user-compare is what I was missing :thumbsup:

Thanks a lot Bok... Excellent job :toast:

I have user compare, but you need to have a user page like this one

http://stats.free-dc.org/users/users.php?name=Bok

It just needs a single entry in an 'aliases' table I have which ties together all of the individual project names for an individual to one single name.

ALthough the compare bit is actually broken at the moment anyway...

Bok

[bachus_anonym]

I have user compare, but you need to have a user page like this one

http://stats.free-dc.org/users/users.php?name=Bok

It just needs a single entry in an 'aliases' table I have which ties together all of the individual project names for an individual to one single name.

ALthough the compare bit is actually broken at the moment anyway...

Bok
oh... that would be nice - http://stats.free-dc.org/users/compare.php?name=Bok&user=bachus_anonym&proj=d2ol

what is the priority of that feature on your long to-do list :) ?

[Bok]

I'll make it high :)

In fact I'll probably have it fixed by end tomorrow. To be honest I just need to change the SQL around to use my new DB format. Not that big a deal.

Bok

[cupra]

thanks for that Rodzilla :toast:

[bachus_anonym]

I'll make it high :)

In fact I'll probably have it fixed by end tomorrow. To be honest I just need to change the SQL around to use my new DB format. Not that big a deal.

Bok
sweet, Bok :thumbsup: And Thanks Rod for bringing Bok over here so we can start bothering him :D

[Rodzilla]

All credit goes to Bok of Free-DC! I just whine till he adds something I like! :up: :lol:

@Bok I see great potential with the changes you made here.
http://stats.free-dc.org/new/teamrank.php?proj=d2ol&team=XtremeSystems
Made me think it would be GREAT to have the daily production of us and the teams we are showing overtake dates for all on that graph!

We had something like that in the DF project that I miss dearly!!!

It would also be neat to have a similar graph in the D2OL project stats page for the top 10 teams in Daily production and overall
http://stats.free-dc.org/new/projpage.php?proj=d2ol

[F|apDro|`]

@ bok, just do it daily then average for the month. that way you can keep track of people changing teams.

quick question, how did the dutch power cows get such a huge lead in d2ol? dunno much about d2ol history.

They do a "stampede"

thats how we dutchies call it ...

They compete in like 20 projects and two or one time a year they say drop your current project were gonna takeover this project !! Then they all move to that project for a month till the stampede is over ...

[[XC] moddolicous]

Thats gonna be hard to compete with if they do that when we start out takeover of Dutch Power cows. How much do they average when they do that, like 60-70K? I think that if we can get up to 40K a day, then we will speed everything up.

[Bok]

All credit goes to Bok of Free-DC! I just whine till he adds something I like! :up: :lol:

@Bok I see great potential with the changes you made here.
http://stats.free-dc.org/new/teamrank.php?proj=d2ol&team=XtremeSystems
Made me think it would be GREAT to have the daily production of us and the teams we are showing overtake dates for all on that graph!

We had something like that in the DF project that I miss dearly!!!

It would also be neat to have a similar graph in the D2OL project stats page for the top 10 teams in Daily production and overall
http://stats.free-dc.org/new/projpage.php?proj=d2ol

First one is easy enough, at least for one more team, once you add too many it gets cluttered, but seeing as it's fairly large it might be ok.. For the second one, I'll just have to think about where it would go. I kinda like to have this page as an overview and don't want it to scroll too much. Myabe it would be better on the allteams page ?

Bok

[Rodzilla]

First one is easy enough, at least for one more team, once you add too many it gets cluttered, but seeing as it's fairly large it might be ok.. For the second one, I'll just have to think about where it would go. I kinda like to have this page as an overview and don't want it to scroll too much. Myabe it would be better on the allteams page ?

Bok

Yea... it would fit better that way! :up:

[Bok]

Also, I'm starting to think a user compare function would be a better fit on the teamstats page too. I'd still have it on my users page as well, but his way anyone could do comparisons of themselves with another member of their team.

It would probably get too unwieldy to have dropdown lists of everyone within the project, but I could see a similar compare function between teams being useful too..

As always thanks for the suggestions :)

Bok

[em99010pepe]

@ bok, just do it daily then average for the month. that way you can keep track of people changing teams.

quick question, how did the dutch power cows get such a huge lead in d2ol? dunno much about d2ol history.

My first post here to tell you that once Dutch Power Cows made a huge 532,310 dump on TSC. You can confirm this by reading the thread (http://www.free-dc.org/forum/showthread.php?s=&threadid=7800) I created a few months ago.
Dutch Power Cows is formed by subteams so do not underestimate them. Probably they would start making more than 100K or even more to defend their first place. It would be interesting......

Sorry for the offtopic. Great stats Bok, The Lord of the Stats!

:toast:

Carlos

[Jeff]

Thanks for the information and :welcome: to the forums. :toast:

[em99010pepe]

Thanks for the information and :welcome: to the forums. :toast:

Thank you.

Carlos

[Rodzilla]

Thank you.

Carlos

The cows haven't been up against XS yet :up: They fail to realize how much Jeff likes beef products... slowly but surely they will be devoured... Well... not slowly but definitely surely! :up:

[em99010pepe]

The cows haven't been up against XS yet :up: They fail to realize how much Jeff likes beef products... slowly but surely they will be devoured... Well... not slowly but definitely surely! :up:

XS haven't been up against DPC yet. :up:

But seriously I am waiting for the D-Day to see a great battle between Free-DC, XS and DPC.

Carlos

[enzoR]

should be at around newyears :D :toast:

[[XC] moddolicous]

yea, and hopefully we'll win.

[Rodzilla]

It will be good! :up: Gotta get another 2 jobs before now and the end of the year :lol:

[lv_dicedealer]

Wow...

I was just messing around in the stats, and if everything stays the same (I know it won't)... Then Team Anandtech will go from 2nd to 4th in about a 2 day window. Sucks to be TA :toast: