Re^5: Querying Saints in our Book (2)

"require having visited the site in the most recent N weeks"

That helps give the recent average, which might be interesting, assuming the average has changed. But that's hard to detect, unless included when people first logged on or started posting.

Hm, I was interested in the recent numbers, frankly, because I felt that the environment had changed so much from the early days of the monastery that it's almost not valid to compare a monk who joined a year ago with one who was active from 2007-2008, say.

"having made a minimum number of posts"

That's a decent idea. The question is, what is the minimum?

Perhaps a function of the overall median reputation per post and the number of their posts? I.e. if your total XP is N and you haven't made at least M posts, your XP is deemed to be overweighted by longevity? Or perhaps better as a function of median rep per post and age as a monk - you should have at least this many posts after this long?

LOL, it's amusing. My goal was to try to evaluate contributions rather than just showing up ...

"deduct 0.5 XP per day in an attempt to get closer to the XP gained from posting rather than longevity."

That's an intriguing idea. On what is the half point based though?

From the Monastery FAQ:

Visiting the site regularly.
You have 25% chance of gaining 2 XP points once a day if you were logg
+ed in within the past 24 hours from when the vote fairy does the roun
+ds.
[download]

Cheers!

The way forward always starts with a minimal test.

Comment on Re^5: Querying Saints in our Book (2) Download Code

Replies are listed 'Best First'.
Re^6: Querying Saints in our Book (2) by chacham (Prior) on May 17, 2016 at 18:35 UTC
the environment had changed so much from the early days of the monastery that it's almost not valid to compare a monk who joined a year ago with one who was active from 2007-2008 That gets tricky though. The higher level monks are most likely to have been here a lot longer, so, if ancient history is deemed not valid, their ancient reputation should suffer the same fate. Perhaps a function of the overall median reputation per post and the number of their posts? I.e. if your total XP is N and you haven't made at least M posts, your XP is deemed to be overweighted by longevity? There are two issues with longevity. One, the login points you mentioned from the FAQ, and two, the rep granted from voting itself. The former can be negated somewhat with your idea of .5 per day, the latter cannot be detected and is would seem really hard to determine, except for the extreme cases (of almost no posts). Further, since everyone has a chance of getting the voting points, and the higher level monks have more points to give (and thus get more back) it would would be inaccurate to deduct them somehow from some monks but not others. So... Or perhaps better as a function of median rep per post and age as a monk - you should have at least this many posts after this long? I would think average, not median. Especially as the average does seem to be near the middle of most levels. With such wide ranges, i am afraid the median would be too far off. Regardless, if we determine the average XP per post for that level (the average changes per level considerably, as can be seen above) we might be able to calculate the deviation or outliers for the individual monks. But how? You have 25% chance of gaining 2 XP points once a day Thanx. I had completely forgotten about that, or perhaps, just thought it only applied to the earlier levels. (That is, mixing it up with the special Initiate_bonus XP mentioned in Levels of Monks.) But, i still wonder, as not everyone logs in everyday. Some people only login during work days, others, only when they need something. Perhaps the regulars login every day, but that might be limited more to the higher levels, which would lower their average even further. And, the SioB "Last Here" column is not very granular with "months" and "years" masking a lot of the detail. Though, at least that much could be addressed by visiting the monk's actual node, which may cause undue stress on the server. So, i'm not sure that's a good idea, in this script, at least.	[reply]
Re^6: Querying Saints in our Book (2) by chacham (Prior) on May 19, 2016 at 18:08 UTC
Just released version 1.2.0 which includes Login_First, and Login_Last. (Unfortunately, the query is now even more Oracle specific, which was until now, iiuc, not so hard to change.) This allows querying age, though without much granularity. (The queries used are in the script. NodeReaper "never" first logged in, but last logged in 110 years ago. So, it gets a NULL.) Years logged in: `YEARS AMOUNT ----- ---------- 0 1 1 4 2 8 3 16 4 29 5 38 6 45 7 40 8 61 9 65 10 42 11 45 12 70 13 57 14 70 15 68 16 34 1` [download] Read more... (5 kB) Anyway, a lot of the monks have been here quite some time. Just more food for though when working out efficiencies.	[reply] [d/l] [select]