Hi, I checked the code in relational.c and found out that the matchstat.snowie_error_rate_per_move is the Snowie error rate already, it just needs to be multiplied with a factor 1000. So my query could be simplified; it can just start with: select matchstat.snowie_error_rate_per_move * 1000 as error_rate
Perhaps the snowie_error_rate_per_move column should be renamed to snowie_error_rate to avoid confusion. I have checked only cubeless matches so far so I don't know if this also gives the correct result when cube errors were made. Cheers, Misja 2009/8/17 Christian Anthon <[email protected]>: > Please do, and report back, I remember being a bit confused myself > when I implemented the reporting. > > Christian. > > On Mon, Aug 17, 2009 at 11:29 AM, Misja Alma<[email protected]> wrote: >> Hi, >> >> Thanks for looking into the problem. So the snowie_moves number is correct >> then. >> But the product of snowie_moves and snowie_error_rate_per_move is >> still different than what gnubg reports itself. >> >> Maybe I'll have a look into the code myself when I find some time, >> 'cause I would really like to be able to query some average Snowie >> error rates from my database. >> >> Cheers, >> Misja >> >> 2009/8/17 Ian Shaw <[email protected]>: >>> >>> >>>> -----Original Message----- >>>> From: [email protected] >>>> [mailto:[email protected]] >>>> On Behalf Of Misja Alma >>>> Sent: 15 August 2009 15:54 >>>> To: bug-gnubg >>>> Subject: [Bug-gnubg] How to calculate snowie error rate from >>>> logged databasedata >>>> >>>> Hi, >>>> >>>> I've been trying to reconstruct my Snowie error rate from a >>>> match that I've logged in the database with gnubg. >>> [snip] >>>> I then checked what the value for snowie_moves was for my >>>> match, and it was the total number of (forced or unforced) >>>> moves of me and my opponent added up. >>> >>> I can't help with the rest of your query, but I do know that this is >>> correct. Snowie uses the sum of your and your opponent's moves as the >>> divisor. Forced or unplayable moves (such as being closed out) are >>> counted. >>> >>> This is the main reason that gnubg's gradings are so much tougher than >>> Snowie's. # >>> >>> Lot's of people dislike Snowie's method, because it is counter-intuitive >>> to count your opponents' moves as the divisor for your own error rate. >>> However, it is the rate that people are most familiar with (which I >>> suppose is why you are trying to extract it.) Douglas Zare also wrote an >>> interesting article at GammonVillage in which he argued in its favour. >>> >>> -- Ian >>> >>> >>> >> >> >> _______________________________________________ >> Bug-gnubg mailing list >> [email protected] >> http://lists.gnu.org/mailman/listinfo/bug-gnubg >> > _______________________________________________ Bug-gnubg mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bug-gnubg
