Skyrates
http://skyrates.net/forum/

Tools -- Dailies (inf, combat lvls, profits)[online, stable]
http://skyrates.net/forum/viewtopic.php?f=54&t=8489
Page 1 of 2

Author:  nehp [ Tue Mar 09, 2010 2:17 pm ]
Post subject:  Tools -- Dailies (inf, combat lvls, profits)[online, stable]

The Dailies tools are up at http://skyrates.zosimple.net

Notice: The official dailies do not run at 03:00am us/pacific, they're off by quite a bit, over half an hour at this point, so the final numbers for the day wont always match up. Not much I can do consistently, we'll just have to wait until they fix the clock.

Profits: There is some kind of data issue that causes some people to show remarkably lower profits at times (compared to the official dailies) while all others are just fine. I am not sure if this is related to the timing issue or not, so be aware that profits are still a bit off, primarily for those at the top of the list.


There are influence, combat levels defeated, and profits pages.
In addition, there is a "split" page that shows all three for the current day.
These update once per hour, on the hour (actually 1-3 minutes after due to doing very slow pulls from dynaRank to be nice.)
The dailies have a restart time of 3AM us/pacific (to mirror the existing dailies.)


This currently covers all members of every faction except for flight school (but gets most every active player)
The regular daily shows four days (today tracking + 3 previous days) with the top 50 displayed in pages of up to 20.
The (long) daily shows two days (today tracking + 1 previous day) with the top 200 displayed in pages of up to 100.


---

Both have the same design:
* The top area contains entries for filtering the data, including name (currently case sensitive), faction, plane tier, and plane type.
* All filters affect all the tables simultaneously.
* The individual headers can be clicked to sort, this works even with active filters

* # will also show the original sort order rank (top true influence at this point)
* User names are coded with their faction color
* Plane names are coded with their plane style (combat, trade, performance, stock, upgrade)
* Up to three sets of numbers are available
1) [default] total gained per day (INF, LVL, PROFIT)
For influence, this is true gained influence per day
This number (under the day-of-week) should reflect gained influence, IGNORING decay. Therefore all influence gained will be displayed, but it should calculated to avoid reflecting the decay reduction that occurs at night.
This number does include apprentice reputation, until such time as dynaRank offers a no-apprentice count.
2) Net (INF)
This number is only displayed in long formats (Current day and the Long page).
Net is your effective actual inf after decay is added in. (This unfortunately also has apprentice rep for now.)
This applies decay immediately in the beginning of the day, so you can actually see how far you have to go to 'beat' the decay. Keep in mind that since apprentice rep is stuck in the totals, you'll have to exceed '0' Net to offset your apprentices.
3) Total (INF, LVL, PROFIT)
This number is the current actual total. (For influence, this only reflects decay after skyrates processes it.)

* Faction total counts are sums from all of the processed individuals, it reflects up to three numbers:
Combat Levels:
1) Total combat levels defated

Profit:
1) Total of those who have net profit on the day
2) Total of those who have net loss on the day
3) Total combined profit and loss
*** This is not individual profit + loss, but splits those who are currently at a loss because they're mid-carry of an expensive load or had a bad sale.

Influence:
1) Total true gained influence per day, ignoring decay
2) Total expected decay
3) Total net gain per day
As above, the apprentice rep is still included, so numbers are not totally precise at this point.
Flight school is obviously not a totally complete number.


{{{Notes}}}
* Please do comment, note possible errors, make suggestions, etc.
* If you note an error, I would especially appreciate a screenshot. Many errors are much easier to fix if I can see the problem numbers or formats to fix them.
* I don't expect a traffic issue for my server, but given that they don't update more than once per hour, I do appreciate y'all not trying to reload them all that often.
* They're not very tiny pages, and they rely heavily on javascript. They should load fine without javascript, just lacking functionality and showing the full set of rows.


{{{Todo}}}
* I plan to migrate sorts these to master/all table sorts at some point
* I am hoping to add an optional cookie/preferences so that you can retain customized filter/sort settings
* Possible longer-term tracking, including weekly or monthly for long-haul competition.
* Skyland based integration, as much as is possible, is one of the next goals

Author:  Herley [ Tue Mar 09, 2010 3:48 pm ]
Post subject:  Re: Tools -- Daily influence [online, dev]

Post moved to correct topic. Move along, nothing to see here.

Author:  Burrito Loco [ Wed Mar 10, 2010 7:23 am ]
Post subject:  Re: Tools -- Daily influence [online, dev]

You make me feel so lazy, dude.

Author:  Calvin [ Wed Mar 10, 2010 2:41 pm ]
Post subject:  Re: Tools -- Daily influence [online, dev]

WIN!
This bit was especially helpful:
nehp wrote:
Net is your effective actual inf after decay is added in. (This unfortunately also has apprentice rep for now.)
This applies decay immediately in the beginning of the day, so you can actually see how far you have to go to 'beat' the decay. Keep in mind that since apprentice rep is stuck in the totals, you'll have to exceed '0' Net to offset your apprentices.
..albeit a little depressing.

Author:  Dead Cloud [ Fri Mar 12, 2010 6:19 am ]
Post subject:  Re: Tools -- Daily influence [online, dev]

Thank you, sir, for the awesomeness.

Author:  Calvin [ Fri Mar 12, 2010 11:55 am ]
Post subject:  Re: Tools -- Daily influence [online, dev]

Dead Cloud wrote:
Thank you, sir, for the awesomeness.
Suddenly, this just popped to mind: http://knowyourmeme.com/memes/im-sorry- ... esome-i-am

Author:  Dead Cloud [ Sun Mar 14, 2010 6:12 am ]
Post subject:  Re: Tools -- Daily influence [online, stable]

Awesomeness can be deafening.
:smile:

Calvin, I admire that quirky mind you have.

Author:  Calvin [ Sun Mar 14, 2010 6:12 pm ]
Post subject:  Re: Tools -- Daily influence [online, stable]

Dead Cloud wrote:
Calvin, I admire that quirky mind you have.
/em bows.

Author:  nehp [ Wed Mar 17, 2010 1:17 am ]
Post subject:  Re: Tools -- Daily influence [online, stable]

*** Decay hour changed.
Decay seems to be applying between 00:00 and 1:00 (am) us/pacific now, rather than between 22:00 and 23:00 (pm) us/pacific. This made gross inf calculations from 23:00 to 01:00 off. I have made a couple modification to allow for this new decay change exception, but it could still calc wrong if I didn't get my logic correct.

If you see numbers that appear too large, check for negative net numbers (there should almost always be SOMEBODY with negative, just sort the Net column.) If you see a minimum of '0' (zero) in Net, screen shot for me, or copy/past the first few *gross* leaders, as well as the reported stats run time from the top of the page.

(And don't worry, even if it suddenly became random-decay-change-times, I have ways I can make it deal with that. Hopefully it doesn't happen that way though, hehe.)

Author:  nehp [ Wed Mar 24, 2010 6:16 pm ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, stable]

*** Added combat levels (working fine), and profits (sometimes an individual is pretty notably off, read the note)

As I note above, the actual skyrates dailies do not run at 03:00am, they run over half an hour early. Until this is fixed, the skyrates.zo.com dailies will just be off a bit from the top10 on the skyrates dailies.

Also a nice current day split dailies (all three) has been added, and the skyrates.zo.com page updated with them all.

Author:  Amira Navaras [ Thu Apr 22, 2010 10:35 pm ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, stable]

Profit board suggestion, could we see a three or five day single ranking of profit? We have a lot of big traders who only make the trade boards every other day, a sample from a longer period would be more accurate.

Author:  nehp [ Fri Apr 23, 2010 12:17 am ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, stable]

Amira Navaras wrote:
Profit board suggestion, could we see a three or five day single ranking of profit? We have a lot of big traders who only make the trade boards every other day, a sample from a longer period would be more accurate.


This is the long term plan, but I need to switch the storage method to a database and a few other rebuilds, and I just kind of put things on hold to see what was up with the event. I need to build a slightly more flexible system so we can explore variations to find what actually works nicely. After the event settles in, I'll go back and rebuild the backend so we can have some more fun with that, hehe.

Author:  Zabrak! [ Mon Mar 28, 2011 9:59 am ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta

Hey nehp, can we get a column for manual kills in addition to levels on the dailies? If it helps, the dynarank query for kills is manual only, not AR, so seems like this should be fairly easy.

Author:  Zabrak! [ Mon Mar 28, 2011 1:35 pm ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta

Wow, that was fast: http://skyrates.zo.com/dailies/kills-daily-100.html

One issue, though: it appears to be using the Dynarank query "Total Kills" for the totals, which includes auto-resolved kills. Can it be switched to the query "Kills", which is just manual, or at least, separate the two?

Author:  nehp [ Mon Mar 28, 2011 9:50 pm ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta

Zabrak! wrote:
Wow, that was fast: http://skyrates.zo.com/dailies/kills-daily-100.html

One issue, though: it appears to be using the Dynarank query "Total Kills" for the totals, which includes auto-resolved kills. Can it be switched to the query "Kills", which is just manual, or at least, separate the two?



Adjusted.

http://skyrates.zo.com/dailies/kills-daily.html
http://skyrates.zo.com/dailies/kills-daily-100.html

and added to http://skyrates.zo.com

I'm leaving them out of the footer for now, since I'd like to see more about merging the combat pages rather than just adding extra tables.

Author:  nehp [ Mon Mar 28, 2011 11:21 pm ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta

Further adjustments:

I've added the average level (lvl/K) to the regular combat page (on the wide table, so current on short form, and both on long form.)

I've added the true manual kill / HR to the new kills combat page (also on the wide tables.)

Give these a looksee and tell me how they seem to be working, this is some changes in the modular system that should let me manipulate the tables, but I haven't tested it extensively yet.

Author:  Arikatas [ Sun Apr 03, 2011 12:45 am ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta

Yesterday's kills/hour isn't being divided by 24. Rather, it's being divided by the same number as today's kills/hour.

That is to say, if it's 20 hours in, then both today's and yesterday's kills are divided by 20.

Author:  Martin Andreysin [ Sun Apr 03, 2011 3:18 am ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta

Arikatas wrote:
Yesterday's kills/hour isn't being divided by 24. Rather, it's being divided by the same number as today's kills/hour.

That is to say, if it's 20 hours in, then both today's and yesterday's kills are divided by 20.


So that explains why the numbers kept changing on me while I was trying to figure things out on my thread.

Author:  nehp [ Sun Apr 03, 2011 10:53 am ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta

Arikatas wrote:
Yesterday's kills/hour isn't being divided by 24. Rather, it's being divided by the same number as today's kills/hour.

That is to say, if it's 20 hours in, then both today's and yesterday's kills are divided by 20.


Corrected

Author:  Narkis [ Sun Apr 03, 2011 2:35 pm ]
Post subject:  Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta

The inf dailies may also have a slight problem. They currently show me as having run 91,003 inf so far today, while the only single mission I'm sure I finished after the update is a whale for 108,057.

Page 1 of 2 All times are UTC - 8 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/