Attendance Tracking
Dendrek
possible, a detailed breakdown for attendance for each guild member
(which I assume could be calculated based on the EP award Log).
If a detailed attendance breakdown is not possible (most likely
because it would require too much information to be stored) then a
running percentage would be nice. At the very least, I'd like for it
to show: 1) % attendance from the very beginning and 2) % attendance
over the last 30 days. A third value showing % attendance since
joining the guild (for initiates), if possible, would be nice.
dcwarcraft
discussed on this forums previously.
The developers have mentioned technical issues when doing this.
August 1st, 2009:
http://groups.google.com/group/epgp-discuss/browse_thread/thread/50319376fac848d8/bfd2cac9e1404408?lnk=gst&q=attendance#bfd2cac9e1404408
Here is one issue... not all guilds use EP only for attendance checks
during raids (although for most this is how it is handled)
EP = Effort Points and therefore can be used for things like fishing
mats for guild feasts, making pots for guild etc.
Some guilds award EP for outside effort like this.
If you simply took the total # of EP awards for the month and divided
it by the amount of EP awards a player received, it would work ONLY if
you gave EP for attendance during raids.
Note: Since most guilds use EP only to award points during raid
attendance checks your proposed item would work for MANY guilds.
Numbers would not be accurate for guilds who use EP for other types of
awards.
Alkis Evlogimenos ('Αλκης Ευλογημένος)
--
You received this message because you are subscribed to the Google Groups "EPGP Discussion and Support Forum" group.
To post to this group, send email to epgp-d...@googlegroups.com.
To unsubscribe from this group, send email to epgp-discuss...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/epgp-discuss?hl=en.
Josh Bogaty
Sent from my iPhone
Дениз Мурат
I'd be grateful if you did that. Attendance tracking is a cornerstone to our guild too and I'm using some very poorly scraped method currently. Inserting 1 entry per hour in a eqdkp+ to have a rough estimate of attendance.
Thanks in advance.
Regards,
Deniz.
--
Deniz Murat | SAP Labs Bulgaria | TD Production | 00359 2 9157-684 | 0035989 7846-439
Erimikos
are using a spreadsheet, but its extremely basic, listing only the
persons name in each row, and a raid in each column. If they came to
a raid, they get a '1' put in that column. Otherwise, nothing.
On Mar 16, 9:36 am, Josh Bogaty <joshua.bog...@gmail.com> wrote:
> I have a fairly monster spreadsheet that I use in conjunction with
> EPGP. For my guild, attendance is the basis for guild rank. I can
> google doc if interested. I use headcount for attendance lists.
>
> Sent from my iPhone
>
> On Mar 16, 2010, at 9:23 AM, Alkis Evlogimenos ('Αλκης Ευλογημένος) <evlog
>
>
>
> ime...@gmail.com> wrote:
> > I have toyed with this idea. EP is an approximation of attendance.
> > In general, the higher the EP the higher the attendance. What is
> > missing, is the magical EP number for someone who attends 100% of
> > raids so that we can compare that with everyone else.
>
> > - alkis
>
> > On Tue, Mar 16, 2010 at 1:39 PM, dcwarcraft <hobb...@gmail.com> wrote:
> > This is a feature we would like as well, but I think it has been
> > discussed on this forums previously.
> > The developers have mentioned technical issues when doing this.
>
> > August 1st, 2009:
> >http://groups.google.com/group/epgp-discuss/browse_thread/thread/5031...
> > .- Hide quoted text -
>
> - Show quoted text -
Dendrek
that happen to award EP for outside effort, as long as the addon only
bases attendance on EP awards that are given to a minimum number of
people (i.e. only EP awards that are given to a minimum of 20 people
in guild - if it's for a 25 man raiding guild - would be counted for
attendance calculations) then it should be consistent and accurate for
nearly all guilds.
Joshua Bogaty
dcwarcraft
I know many guilds use a spreadsheet system like the one posted here,
but its a pain in the ass plain and simple.
I think a lot of guilds would welcome a EPGP attendance tracker based
on EP awards.
Maybe just add a disclaimer that shows how it is calculated and let's
guild leader know that "Other" EP awards will skew attendance %
numbers.
I personally would love to see it implemented to give me a quick
baseline...
DC
On Mar 18, 7:28 pm, Joshua Bogaty <joshua.bog...@gmail.com> wrote:
> Sorry for the delay. Here is my attendance spreadsheet uploaded to google
> docs -->https://spreadsheets.google.com/ccc?key=0Ai9lxMX5634TdFY2SFJVZGxzWnZm...
>
> Basically, most things are done automatically. There are multiple sheets.
> I use headcount to get the list of names each night.
>
> Sheet 1 = Attendance - this has all the formulas and is the good stuff
> Sheet 2 = roster and logs - this is where all my data goes and each nights
> attendance list.
>
> Things that I do manually:
> 1. Add new members/delete old members
> 2. Change the total raids available number on the roster and logs sheet.
> 3.I repopulate column A when all the edits for the night/week are made.
>
> I would love suggestions - I am a very basic user of excel so this is likely
> rudimentary to most of you.
>
>
>
> On Thu, Mar 18, 2010 at 3:27 AM, Dendrek <dend...@gmail.com> wrote:
> > As far as the difficulty of accurate attendance tracking for guilds
> > that happen to award EP for outside effort, as long as the addon only
> > bases attendance on EP awards that are given to a minimum number of
> > people (i.e. only EP awards that are given to a minimum of 20 people
> > in guild - if it's for a 25 man raiding guild - would be counted for
> > attendance calculations) then it should be consistent and accurate for
> > nearly all guilds.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "EPGP Discussion and Support Forum" group.
> > To post to this group, send email to epgp-d...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > epgp-discuss...@googlegroups.com<epgp-discuss%2Bunsubscribe@googlegroups.com>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/epgp-discuss?hl=en.- Hide quoted text -
Alkis Evlogimenos ('Αλκης Ευλογημένος)
- alkis
To unsubscribe from this group, send email to epgp-discuss...@googlegroups.com.
Josh Bogaty
Sent from my iPhone
Alkis Evlogimenos ('Αλκης Ευλογημένος)
Chip Turner
while back to begin gathering data but haven't checked on the quality
of it. It looks pretty decent, though.
2010/3/19 Alkis Evlogimenos ('Αλκης Ευλογημένος) <evlog...@gmail.com>:
--
Chip Turner - ctu...@pattern.net
Richard
Thanks for the tip - I'm going to install it and see how it goes.
Joshua Bogaty
Erimikos
that sheet.. Honestly, its infinetally better then what I was using
previously..
I would suggest that for the NCNS Status formulas, you do the
following:
=IF((L2<M2),"Safe","NEXT NCNS=GKICK")
This way, anything at, or over the threshold shows the warning.
Did you manually drop the NCNS's as well? Looking at this, I am
thinking that I might drop .5 from it each week, or maybe .25 with
each weekly maintainence run that I do...
Could possible move that NCNS column over to the Roster and Logs page
as well.
Maybe a config page for options such as the rank threshold's, that way
you only have to change one box instead of the whole row.
Looking at this does make me curious about your guild.. What kind of
rules you have, and all that. I am not sure I understand the purpose
of a the columns that are titled Raider, Member, and all that.
Last question, do you adjust the 'Total Raids Availiable by simply
adding one after each raid to everyone in the guild, or is this based
on something else?
Thanks a lot, this is far better then what I had. :)
On Mar 22, 4:59 pm, Joshua Bogaty <joshua.bog...@gmail.com> wrote:
> Does anyone have any suggestions on my attendance spreadsheet? Would anyone
> be interested in editing the document? The better we can make this
> spreadsheet the less of a need there is for an addon.
>
>
>
> On Sun, Mar 21, 2010 at 7:54 PM, Richard <rml...@gmail.com> wrote:
> >http://wow.curse.com/downloads/wow-addons/details/epgp-attendance.aspx
>
> > Thanks for the tip - I'm going to install it and see how it goes.
>
> > On Mar 20, 5:37 am, Chip Turner <ctur...@pattern.net> wrote:
> > > There is already an addon called EPGPAttendance.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "EPGP Discussion and Support Forum" group.> To post to this group, send email toepgp-...@googlegroups.com.
> > To unsubscribe from this group, send email to>epgp-discuss...@googlegroups.com<epgp-discuss%2Bunsubscribe@google groups.com>
dcwarcraft
http://wow.curse.com/downloads/wow-addons/details/epgp-attendance.aspx
Alkis - Were you aware this add on was out there?
Any thoughts on adding the functionality of this into EPGP as a
feature?
I'm not sure the developer of Epgp-attendance is actively upgrading
it. His last updated was 3 months ago.
I posted a note to him on the wowace forums to find out the status of
the add on and ask a few questions about how it works.
Request: Add Attendance Tracking Into Core EPGP
Could be setup as an additional Tab or expand the EPGP standing
window.
Each EP Award would be looked at as an attendance check. Attendance %
should be shown for 7 Days, 14 Days, 30 Days, 60 Days. (Or make it
customizable)
Adam 'Rez'
Nice mod I must say. I edit my 'log.lua' file in the epgp mod and
change "month = -1" to "hour = -12" so it deletes all log entries over
12 hours old. This keeps the memory usage low and less to upload when
I dump my 'epgp.lua' SavedVarables file to my web site.
My question is, Does this mod keep its own data or does it rely on
reading the EPGP log entries to calculate its data each time you view
the attendance?
On Mar 23, 9:56 am, dcwarcraft <hobb...@gmail.com> wrote:
> The servers are down now so I can't do any testing onhttp://wow.curse.com/downloads/wow-addons/details/epgp-attendance.aspx
dcwarcraft
Is your last post related to EPGP itself or epgpATTENDANCE?
Please explain the edits you made in the .lua and why in more detail
for us retards.
Adam 'Rez'
The changes I made to the "addons/epgp/log.lua" file:
After each raid I upload the "World of Warcraft\WTF\Account\<Username>
\SavedVariables\epgp.lua" file to my website which parses the log
entries and puts them all in a MySQL database. I made a change to the
"log.lua" file so when I click the in-game "Trim Log" button in the in-
game EPGP mod it trims everything older then 12 days. Default is trim
anything older then 30 days.
Why do I make this change?
1. I don't need anything older then 12 hours. It can all be see on my
website.
2. When uploading the file to parse its less data to parse though thus
goes faster.
3. Less log entries in the in-game mod means less memory the mod us
using which also means faster logging into and out of a character
also.
I tossed this together this morning using the uploaded log data since
Dec. 1, 2009. I currently have 14,534 log entries in the database.
http://www.deathminionsguild.com/guild/?p=attendance
dcwarcraft
As for your question on EPGP Attendance, this is probably the wrong
forum.
You would need to head to WOWACE and ask the developer of that add on.
On another note, it seems like many users are interested in adding
atendance tracking into the base EPGP add on.
If others are interested reply here so the development teams knows
this is important to you...
This is the only way it will be fast tracked for a new feature add....
Josh Bogaty
posting or telling an officer. I manually add the NCNS after each
raid night. I do like the idea of dropping .25 off each NCNS if they
have some type of consistent attendance. And yes, the NCNS column
could be moved and would make sense.
A config page would be a great idea as well. This would the main page
to be just the results.
Basically, each attendance % correlates to a guild rank. They also
have raid minimums as well. The rank gives gbank access and priority
to raid. Also, the officers meet each week and discuss intangibles
like performance.
Sent from my iPhone
>>> +unsub...@googlegroups.com<epgp-discuss%2Bunsubscribe@google groups.com
>>> >
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/group/epgp-discuss?hl=en.
>
> --
> You received this message because you are subscribed to the Google
> Groups "EPGP Discussion and Support Forum" group.
> To post to this group, send email to epgp-d...@googlegroups.com.
> To unsubscribe from this group, send email to epgp-discuss...@googlegroups.com
Josh Bogaty
we have a holiday, I add 3 raids. It would be great if I could do
this using the date joined.
Sent from my iPhone
>>> +unsub...@googlegroups.com<epgp-discuss%2Bunsubscribe@google groups.com
>>> >
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/group/epgp-discuss?hl=en.
>
> --
> You received this message because you are subscribed to the Google
> Groups "EPGP Discussion and Support Forum" group.
> To post to this group, send email to epgp-d...@googlegroups.com.
> To unsubscribe from this group, send email to epgp-discuss...@googlegroups.com
Erimikos
Say Start date is in Cell B3..
Runs per week is in cell B4..
Excused Runs or Holidays is in B5..
NCNS Occurances is in Cell B7..
NCNS Decay Per Week is in cell B8
You came up with all the magical numbers and such to determine the
number of raids attended, so I wont redo that. We will say that
number is in cell B6..
To calculate the number of days between start date and today, you
would use:
=DAYS360(B3, TODAY())
To calculate the weeks between start date and today, you could use:
=ROUND(DAYS360(B3, TODAY())/7, 2)
To calculate the possible runs since Start date, you could use:
=ROUND((DAYS360(B3, TODAY())/7)*B4, 2)
To calculate the individual players availiable runs, taking excused
and holiday runs into account:
=ROUND((DAYS360(B3, TODAY())/7)*B4, 2)-B5
To calculate how many NCNS instances a player has after removing decay
amount per week
=B7-(ROUND(B8*(B6/B4), 2))
The downside to this last one is that you have to keep in mind that
Negative numbers is a good thing in this case. This may be something
to consider using instead of the idea of the excused NCNS runs being
based on Rank. If for example you run 3 raids a week, and someone
has actually attended 30 raids with you, and you take .25 NCNS
occurances off per week, and they have logged 2 NCNS occurances with
you, this will work out to -0.5, so technically are still in the
green. (remember, negative is good, positive is bad) One more would
put that at 0.5.. A bad thing. They would have to run every raid
for the next 2 weeks to get back to a -1, allowing for one more
instance again.
Anyway, just a couple thoughts and suggestions. :)
On Mar 23, 3:22 pm, Josh Bogaty <joshua.bog...@gmail.com> wrote:
> Unfortunately, I am adjusting each raid by hand. Every week, unless
> we have a holiday, I add 3 raids. It would be great if I could do
> this using the date joined.
>
> Sent from my iPhone
>
Joshua Bogaty
dcwarcraft
Is this topic still being looked at for production EPGP?
I researched this a bunch fo the web and it seems guild ahve two
options to track (estimated) attendance % in conjunction with EPGP.
1. Write a custom website which expands on the reporting.
2. Run a secondary add on like Headcount.
Any reason EPGP web can't do a simplistic % for last 14 days, 30 days,
60 days?
Total # of EP Awards given / Total number received by that player?
Alkis Evlogimenos ('Αλκης Ευλογημένος)
- alkis