EPGP - Math/WoW Nerds question

[jyllana]

Have any of you seen any ways of tracking attendance in an EPGP system? 

There's apparently an EPGPAttendance mod, but it has some serious limitations.  Such as if the person running the mod doesn't log in at least between every raid the attendance %'s get off, and there's no syncing of data to account for this.  So someone takes a vacation and the thing goes wonky.

We have things up on EPGPWeb, but they don't do attendance.  They also don't have any easy way to access either the raw data, or the aggregate EPGP totals.

Some people are tracking it by exporting the EPGP mod's data into a spreadsheet and then doing whatever processing on it.  But again, serious limitations.


The problem I'm having with just using current EP as attendance is that EP is a many-to-one function for several reasons. 

First is that if events have differing values...say start/end are 1000 and 15m mid-raid events are 250...someone has a total of 2k, you don't know if they were there for 1 start and 1 end event, or if they were there for 1 start and 4 mid-raid events, etc.  I could probably ignore that facet as an artifact of us weighting parts of attendance as we value them.

The second and more major of the problems is the decay.  Just as a function of how it works it weights recent attendance way more heavily than prior attendance.  Also it retains artifacts that go beyond any period you're tracking which skews things a bit.


You can get around this by checking EP gained in between applications of the decay.  Since we do decay weekly we could take a snapshot once per week...subtract this week's from last week's after decay was applied...and generate the amount of EP gained that week.  That's roughly equal to attendance (disregarding the first "problem" I outlined above).  Then if we wanted to generate some larger period aggregate we could just average people's weekly attendance.  But before I really contemplate writing a custom parser to do this, anyone seen solutions to this in practice?


I guess the last alternative that might be worth contemplating is running Headcount (or some similar mod) and reviving the EQDKP portion of the website.  Obviously that would solve the attendance thing, and if we don't place links to the EQDKP (just pull the attendance data out of the database) it wouldn't confuse people.  However it would be another thing for the loot people to run and upload every night, which is bad.


Any thoughts?

[Ragetrain]

Easy way: have a dummy account that is awarded EP at a rate of 80% of the weekly EP from that group. Allow decay to take effect on the dummy account, bam, theres your 80% attendance EP.

Also, i made a spreadsheet, and my numbers might be off with regard to the weekly EP and starting EP we had.

Starting: 47990
weekly: 16260 @ 5420/day
weekly (80% attendance): 13008
Decay: 10%

Ratio of Maximum possible EP to Lowest possible (with 80% attendance) I found was .70241. (this ratio is after decay for that week)

I.E. week 1~~~~~~~~~~
Full time Raider w/decay: (47990+16260)*.9 = 57825
80% raider w/decay: (47990+13008)*.9 = 54898.2

The ratio turns out to be a constant 0.70241 after subtracting Base EP.

As in (Ratio)(Max-Base)+Base = Min
Or (.70241)(57825-47990)+47990 = 54898.2