Re: [Lockjaw] 40 Lines & 180 Seconds Congrats on moving a place on the leaderboard and welcome back from the future! ;P I'll just assume this is from today.
Re: [Lockjaw] 40 Lines & 180 Seconds Thanks for the welcome. I got an idea. I'll create a macro for Excel that automatically will: 1 - Open lj-scores.txt; 2 - Create a database with only "40 Lines & 180 seconds" games that were actually finished; 3 - Generate graphics (PPM improvement over time, Score/Time improved over time, etc.) I'll do tomorrow and post sample here.
Re: [Lockjaw] 40 Lines & 180 Seconds Excellent idea !! I follow you ! but actualy, I only clear 4% of my runs.. I should be interested with something which records the performance of my failed attempts..Number of lines and TPS for failed game would be nice.
Re: [Lockjaw] 40 Lines & 180 Seconds There's no problem if you complete only 4% of your runs... the data will contemplate only finished games. Also, it is a good idea giving a % of games finished. *I'm doing the code now.
Re: [Lockjaw] 40 Lines & 180 Seconds Here's what I've done so far... *To active macros at Excel, you must: 1 - Open Excel; 2 - Go on Tools / Macro / Security; 3 - Set security to Medium or Low; 4 - Open this file. The code is clean Source code: Code: Option Explicit Sub ReadLJ() Dim _ reg(1 To 33) As String, _ n As Byte, _ myRow As Long, _ myColumn As Integer, _ lngGames As Long, _ test As Variant myRow = 1 On Error GoTo errFound Open shtBegin.Range("B4") For Input As #1 On Error GoTo 0 With shtResults .Range(.Cells(2, 1), .Cells(.Rows.Count, .Columns.Count)).ClearContents On Error Resume Next .ShowAllData On Error GoTo 0 Do While Not EOF(1) For n = 1 To 29 Line Input #1, reg(n) Next n If reg(12) = "Made 40 lines" Then myRow = myRow + 1 myColumn = myColumn + 1: .Cells(myRow, myColumn) = myRow - 1 myColumn = myColumn + 1: .Cells(myRow, myColumn) = "40 Lines" 'reg(6) myColumn = myColumn + 1: .Cells(myRow, myColumn) = CDate(Mid(reg(7), 4, 11) & Mid(reg(7), 18)) myColumn = myColumn + 1: .Cells(myRow, myColumn) = Mid(reg(8), 8, 3) myColumn = myColumn + 1: .Cells(myRow, myColumn) = Mid(reg(8), 27, 7) myColumn = myColumn + 1: .Cells(myRow, myColumn) = Val(Mid(reg(8), 36)) myColumn = myColumn + 1: .Cells(myRow, myColumn) = Mid(reg(10), 8, 4) myColumn = myColumn + 1: .Cells(myRow, myColumn) = Val(Mid(reg(10), InStr(1, reg(10), "(") + 1)) myColumn = 0 End If Loop ' .Cells.AutoFilter End With Close #1 shtResults.Activate Exit Sub errFound: MsgBox "Could not find file!", vbCritical, "Error!" End Sub
Re: [Lockjaw] 40 Lines & 180 Seconds LoL, I couldn't upload file because forum doesn't allow... =/ Where can I upload the spreadsheet?
Re: [Lockjaw] 40 Lines & 180 Seconds That is a little problem actually ! There is many players here who are very focused on their consistency improvement. Ignoring the 96% of failed games won't show a real improvement estimation..
Re: [Lockjaw] 40 Lines & 180 Seconds I believe failed games are imensurable for tpm progress purposes, because there are people who suicide dropping pieces fast when resign a game, or quit within the first 10 seconds, or simple stop playing before resign...
Re: [Lockjaw] 40 Lines & 180 Seconds Not really if you accord yourself to accept a several limit, like : considering only scores with a number of line > 24 lines. At this state, the giving up/dropping of the 4 last tetriminos won't disturb so much the TPS average calculation. Sorry if I am boring with that.. Actually, I should be the only one who will insist with that, because we are only 2 or 3 20G players here, and the rest of people play at 0G.. So every 0G players can finish 100% of their runs, which is not my case at 20G..
Re: [Lockjaw] 40 Lines & 180 Seconds Well... I can create an option that will contemplate >=24 lines in the macro. Now, how I'll upload the spreasheet here?
Re: [Lockjaw] 40 Lines & 180 Seconds Major League Baseball does it the same way: a game counts toward the record if at least half a game (4 innings plus the top of the fifth) has been played.
Re: [Lockjaw] 40 Lines & 180 Seconds I put the file on 2shared: http://www.2shared.com/file/4700218/d6e64691/LJanalisys-01.html
Re: [Lockjaw] 40 Lines & 180 Seconds Very cool Benzadeus! I wish I had that a few months ago when I played LJ 40 lines like two months straight. Here is my stat sheet for those games. (With help from muf, I used SED to compile the data.)
Re: [Lockjaw] 40 Lines & 180 Seconds It is important state that this program works for LJ version 0.46a (don't know if previous versions of file lj-scores.txt was different) and, if you use Excel 2003 and finished more than 65536 games, the macro will crash I'll work on those errors on the next version.
Re: [Lockjaw] 40 Lines & 180 Seconds Code: Result: Cleared 40 lines at level 40 on 2009-01-22 at 13:41 Played 105 tetrominoes in 1:17.51 (81.27/min) (active time only: 1:12.85, 86.47/min) Pressed 479 keys (4.56/piece) Made 40 lines (single: 6; double: 2; triple: 2; home run: 6; T single: 0; T double: 0; T triple: 0) Sent 33 garbage (25.54 per minute) Left 16 blocks behind LJ score: 10600 Options Well: 10x20, Enter: Below Speed: Zero, ARE: 0 ms Randomizer: History 6 rolls of Tetrominoes Hold: On, empty, Rotation: Arika+initial Lock: Move reset, Deep: Off Line clear: 0 ms Naive, Gluing: Off Drop score: None, T-spin: Off Garbage: Off, DAS: 166 ms 1G Soft drop: 1G Lock, Hard drop: Slide Shadow: Fainter color, Next: 3
Re: [Lockjaw] 40 Lines & 180 Seconds Thanks for the macro Benzadeus! Will definitely be useful. And keep up the good progress gs68!
Re: [Lockjaw] 40 Lines & 180 Seconds Code: vtrickzv -------- (SRS)Exponen 00:56:13 117.97 3.67 23/01/09 Gamepad I seen some of you guys were playing without hold - at first I admit I thought that was pretty ridiculous, but I tried it and I beat my previous record my first try... lol. Code: Result: Cleared 40 lines at level 100 on 2009-01-23 at 04:44 Played 101 tetrominoes in 0:56.13 (107.95/min) (active time only: 0:51.36, 117.97/min) Pressed 371 keys (3.67/piece) Made 40 lines (single: 12; double: 4; triple: 4; home run: 2; T single: 0; T double: 0; T triple: 0) Sent 21 garbage (22.44 per minute) Left 4 blocks behind LJ score: 8200 Options Well: 10x20, Enter: Above Speed: Exponential, ARE: 0 ms Randomizer: Bag of Tetrominoes Hold: Off, Rotation: SRS+initial Lock: Move reset, Deep: Off Line clear: 0 ms Naive, Gluing: Off Drop score: None, T-spin: 3-corner T Garbage: Off, DAS: 166 ms 1G Soft drop: 1G Slide, Hard drop: Lock Shadow: Fainter color, Next: 3
Re: [Lockjaw] 40 Lines & 180 Seconds Code: Result: Cleared 40 lines at level 40 on 2009-01-23 at 13:47 Played 109 tetrominoes in 1:14.91 (87.29/min) (active time only: 1:09.88, 93.58/min) Pressed 501 keys (4.59/piece) Made 40 lines (single: 12; double: 6; triple: 4; home run: 1; T single: 0; T double: 0; T triple: 0) Sent 18 garbage (14.41 per minute) Left 32 blocks behind LJ score: 7600 Options Well: 10x20, Enter: Below Speed: Zero, ARE: 0 ms Randomizer: History 6 rolls of Tetrominoes Hold: On, empty, Rotation: Arika+initial Lock: Move reset, Deep: Off Line clear: 0 ms Naive, Gluing: Off Drop score: None, T-spin: Off Garbage: Off, DAS: 166 ms 1G Soft drop: 1G Lock, Hard drop: Slide Shadow: Fainter color, Next: 3
