Forum
Announcing the First Quarterly LIfetime TAPL Competition
|
skrumgaer wrote
at 10:35 AM, Tuesday May 22, 2007 EDT
As we wrap up the first quarter of kdice competition under the current scoring rules, I want to give recognition to kdice players of superior skill, especially those who are more recent arrivals to the game. At the end of May I will make a listing of TAPL scorers in three catagories:
1. Top TAPL scorers among players who began playing kdice in May. 2. Top TAPL scorers among players who have been playing kdice since April. 3. Top TAPL scorers among players who have been playing kdice since the scoring change and reset of the Elo's in February. The TAPL is explained in the comment at my profile page. The TAPL and this competition have no official endorsement from Ryan. To qualify for the competition, you must have played at least 35 games. To enter the competition, make a post to this thread. I will reply with a computation of your current lifetime TAPL. At the end of the month I will work up the lifetime TAPL's for all the contests and award certificates. I don't have fancy graphics capabilities like Ryan has for the trophies, but I will issue a certificate that looks like this: 5684 ∫ 1st.∫∫∫ A 3-month TAPL in the 5000's is likely to have a good finish, a 2-month TAPL in the 2000's is a good score, and a 1-month TAPL in the 1000's means you have a good shot for the top spot. |
|
Lordscamz wrote
at 8:12 AM, Wednesday May 23, 2007 EDT why not
|
|
kwizatz wrote
at 10:55 AM, Wednesday May 23, 2007 EDT Hit me.
|
|
|
skrumgaer wrote
at 12:30 PM, Wednesday May 23, 2007 EDT truce whore:
here are your games played, lifetime profile, and lifetime TAPL: 276 17% 12% 12% 13% 15% 11% 17% 725 ditto for frankstur: 194 18% 21% 11% 13% 11% 11% 11% 1254 and for Lordscamz: 480 13% 16% 18% 12% 12% 13% 13% 1098 and for the Ummah Regent: 1079 18% 12% 11% 10% 13% 13% 20% 6932 |
|
Rsquared wrote
at 4:59 PM, Wednesday May 23, 2007 EDT Sounds intresting, I'd be down for this.
|
|
|
skrumgaer wrote
at 5:18 PM, Wednesday May 23, 2007 EDT Rsquared:
Your total games, lifetime profile, and lifetime TAPL are: 919 17% 14% 13% 12% 12% 17% 12% 1649 |
|
WayneRooney wrote
at 6:42 PM, Wednesday May 23, 2007 EDT Can you do this name and ChelseaSucks? Thanks
|
|
JDizzle787 wrote
at 6:48 PM, Wednesday May 23, 2007 EDT Yo wassup Skrum!! Prettly please do mine, w/ sugar and strawberries on top?
|
|
|
skrumgaer wrote
at 7:24 PM, Wednesday May 23, 2007 EDT WayneRooney as WayneRooney:
204 11% 21% 15% 16% 9% 12% 12% 1429 WayneRooney as ChelseaSucks in the two-month category: 121 12% 22% 14% 15% 14% 7% 12% 1126 JDizzle787: 679 12% 17% 15% 13% 15% 13% 13% 1029 |
|
|
skrumgaer wrote
at 8:25 PM, Wednesday May 23, 2007 EDT Guys:
I figured out how to load the spreadsheet code into this forum. What you see below is a long column. Follow these steps: 1. Copy the whole column and paste it into a blank spreadsheet. What you have will be a functional TAPL calculator but not very useful because it is in columns instead of rows. 2. Copy what you have just pasted in the spreadsheet and paste it to a blank area of the spreadsheet, but use Paste Special and in the bottom of the dialog box check the little square that says Transpose. You should now have a long row that is the transpose of the original column. 3. Everything up to and including the first xx is the first row of the TAPL calculator. Leave these undisturbed. Everything beyond the first xx and up to and including the second xx is the second row. Move this under the first row using the Cut command and then Paste. 4. Do the same thing with the third row (including the next xx) and cut it and paste under the second row. Continue with the fourth row, etc. You now have your TAPL calculator. To use it, copy your profile from your profile page and paste it into the spreadsheet, using Paste Special....Text. You no longer need the vertical column and you can delete it. Let me know if it works. Month Rank Score Rating Max Rating Games Played 1st 2nd 3rd 4th 5th 6th 7th x May 765th 0.0692778 1618 1770 100 0.14 0.14 0.14 0.14 0.14 0.14 0.14 x April 1428th 0.0482766 1591 1680 100 0.14 0.14 0.14 0.14 0.14 0.14 0.14 x March 541st 0.1852761 1656 1775 100 0.14 0.14 0.14 0.14 0.14 0.14 0.14 x x x x x x =A20+A34+A48 =(A21*A$20+A35*A$34+A49*A$48)/(A$20+A$34+A$48) =(A22*A$20+A36*A$34+A50*A$48)/(A$20+A$34+A$48) =(A23*A$20+A37*A$34+A51*A$48)/(A$20+A$34+A$48) =(A24*A$20+A38*A$34+A52*A$48)/(A$20+A$34+A$48) =(A25*A$20+A39*A$34+A53*A$48)/(A$20+A$34+A$48) =(A26*A$20+A40*A$34+A54*A$48)/(A$20+A$34+A$48) =(A27*A$20+A41*A$34+A55*A$48)/(A$20+A$34+A$48) =SUM(A77:A83)*A62 x x x x x x =100*(A63-0.14)^2/0.14 =100*(A64-0.14)^2/0.14 =100*(A65-0.14)^2/0.14 =100*(A66-0.14)^2/0.14 =100*(A67-0.14)^2/0.14 =100*(A68-0.14)^2/0.14 =100*(A69-0.14)^2/0.14 xx |
|
|
skrumgaer wrote
at 8:33 PM, Wednesday May 23, 2007 EDT A correction to my post on the code. The little xx's didn't come out right. The last (or only) x in a group of x's is the xx.
|
