Hopeful test

[Asashosakari 19,682]

Better?

Heisei Hopefuls - current yardstick: Masuraumi (1988/10/15)
Rikishi	Heya	DOB (Rank)	Debut	HiRk	2009.07	2009.09	2009.11	2010.01	2010.03	2010.05
Takayasu	Naruto	1990/02/28 (11)	2005.03	Ms10	Ms44e 4-3	Ms36w 5-2	Ms27e 4-3	Ms22w 4-3	Ms18w 5-2	Ms10w 4-3
Chiyonokuni	Kokonoe	1990/07/10 (8)	2006.05	Ms24	Sd41e 6-1	Ms54e 2-5	Sd18e 4-3	Sd8e 4-3	Ms58e 6-1	Ms24e 4-3
Tamadaiki	Kataonami	1988/11/02 (21)	2007.03	Ms24	Ms30e 3-4	Ms37e 4-3	Ms31w 4-3	Ms25e 3-4	Ms32e 4-3	Ms24w 3-4
Masunoyama	Chiganoura	1990/11/01 (6)	2006.07	Ms25	Ms25e 2-5	Ms39e 4-3	Ms32w 3-4	Ms38e 4-3	Ms32w 4-3	Ms25e 6-1
Takanoiwa	Takanohana	1990/02/26 (12)	2008.11	Ms13	Sd85e 6-1	Sd27w 4-3	Sd14w 7-0 Y	Ms13w 3-4	Ms19e 3-4	Ms26e 2-5
Ryuden	Takadagawa	1990/11/10 (5)	2006.03	Ms9	Ms46w 6-1 D	Ms19w 4-3	Ms15e 5-2	Ms9w 3-4	Ms15e 2-5	Ms29e 4-3
Tokizakura	Nakamura	1989/07/10 (17)	2005.03	Ms35	Sd9e 3-4	Sd27e 4-3	Sd14e 4-3	Sd5e 4-3	Ms56e 5-2	Ms38e 3-4
Kotoyuki	Sadogatake	1991/04/02 (3)	2008.03	Ms26	Sd3e 5-2	Ms43w 3-4	Ms51w 5-2	Ms37w 5-1-1	Ms26w 2-5	Ms40w 3-4
Tochiyashiki	Kasugano	1989/07/07 (18)	2008.03	Ms30	Ms56e 5-2	Ms41e 5-2	Ms30e 0-0-7	Sd10w 4-3	Ms60e 5-2	Ms43e 3-4
Bugendai	Musashigawa	1989/01/21 (20)	2004.05	Ms43	Sd21e 5-2	Ms57e 4-3	Ms47w 2-5	Sd10e 5-2	Ms52w 4-3	Ms43w 3-4
Hishofuji	Nakamura	1989/07/14 (16)	2005.03	Ms29	Ms39w 5-2	Ms29w 1-6	Ms59e 4-3	Ms52w 5-2	Ms39w 3-4	Ms47w 4-3
Kairyu	Tagonoura	1990/03/01 (10)	2005.03	Ms29	Sd46e 4-3	Sd31e 5-2	Sd6e 4-3	Ms59e 6-1	Ms29e 1-6	Ms53w 3-4
Takageppo	Takanohana	1990/04/19 (9)	2009.01	Ms59	Jd50w 6-1	Sd84w 5-2	Sd48w 4-3	Sd34w 4-3	Sd20w 5-2	Ms59e 2-5
Mankajo	Kasugayama	1990/02/10 (13)	2005.03	Ms43	Ms53w 4-3	Ms44w 3-4	Ms52w 3-4	Sd4w 2-5	Sd27e 5-2	Sd2w 4-3
Chiyoarashi	Kokonoe	1991/07/12 (1)	2007.03	Ms50	Ms56w 2-5	Sd20e 5-2	Ms57w 4-3	Ms50w 0-7	Sd25w 4-3	Sd13w 6-1
Kawanari	Oguruma	1991/07/07 (2)	2007.03	Ms38	Ms47w 4-3	Ms38e 2-5	Ms54e 4-3	Ms47w 3-4	Ms54e 2-5	Sd16w 4-3
Kumagai	Isenoumi	1990/08/25 (7)	2006.03	Ms50	Sd16w 3-4	Sd34e 4-3	Sd19e 5-2	Ms58e 4-3	Ms50e 1-6	Sd21e 4-3
Higoarashi	Kise	1989/08/20 (14)	2006.05	Ms53	Ms59e 3-4	Sd15e 2-5	Sd39w 4-3	Sd24w 4-3	Sd11w 3-4	Sd26e 4-3
Dewahayate	Dewanoumi	1989/01/31 (19)	2004.03	Ms50	Sd26e 4-3	Sd13w 3-4	Sd26w 4-3	Sd15w 4-3	Sd5w 2-5	Sd29e 4-3
Asahisho	Oshima	1989/07/21 (15)	2005.03	Ms45	Ms45e 3-4	Ms56w 2-5	Sd22e 4-3	Sd11e 3-4	Sd23e 3-4	Sd39e 6-1
Kotokensei	Sadogatake	1991/01/06 (4)	2006.03	Ms50	Sd14e 4-3	Sd3e 3-4	Sd13w 3-4	Sd26e 3-4	Sd41w 3-4	Sd55w 2-5
Byakko	Nakamura	1989/07/11 ()	2005.03	Sd11	Sd37w 4-3	Sd23w 3-4	Sd36w 4-3	Sd22e 3-4	Sd36w 5-2	Sd13e 5-2
Tochinohama	Kasugano	1989/01/29 ()	2007.03	Sd5	Jd14w 5-2	Sd82e 4-3	Sd62w 2-4-1	Sd91e 5-2	Sd58e 6-1	Sd5w 4-3
Kei	Onomatsu	1990/03/10 ()	2008.01	Sd16	Sd59w 4-3	Sd43w 4-3	Sd27e 4-3	Sd16w 3-4	Sd30e 3-4	Sd46e 6-1

Edited May 26, 2010 by Asashosakari

[Randomitsuki 2,843]

Much better ;-)

The crucial thing now is the question of how to display a KK from a career high...

Edited May 25, 2010 by Randomitsuki

[Asashosakari 19,682]

The crucial thing now is the question of how to display a KK from a career high...

Is that a trick question?

[Randomitsuki 2,843]

The crucial thing now is the question of how to display a KK from a career high...

Is that a trick question?

Not really.

If the solution is obvious and doable (putting a red frame around a purple box), why haven't you done it in this test?

If you have done it, ie. if there already are red frames around some purple boxes, I cannot see them.

If some other trickery is involved in decoding the patterns, I am too stupid.

Edited May 25, 2010 by Randomitsuki

[Asashosakari 19,682]

If the solution is obvious and doable (putting a red frame around a purple box), why haven't you done it in this test?

If you have done it, ie. if there already are red frames around some purple boxes, I cannot see them.

If some other trickery is involved in decoding the patterns, I am too stupid.

The trickery required appears to be "not using Firefox"... How odd, it works fine on my rinky-dink IE6 (image), but in FF the coloured cell background appears to bleed onto the frame. Sorry about my seemingly obtuse post, I had no idea this was happening.

Back to the drawing board...

Edit: Ahh, it chokes on having multiple style attributes in the same tag.

Edited May 25, 2010 by Asashosakari

[Asashosakari 19,682]

Fixed, I think.

[Randomitsuki 2,843]

Fixed, I think.

Yessir. Forsooth, you are a genius.

[Asashosakari 19,682]

As usual the fix itself was easy, automating it within Excel 2003's 1024 character limit was the hard (rather, annoying) part. Revised table to be ported over to the main thread in a moment.

Edit: Err, it would if I had remembered to bring the correct version of the spreadsheet to this computer...

Edited May 26, 2010 by Asashosakari

[Doitsuyama 1,194]

As usual the fix itself was easy, automating it within Excel 2003's 1024 character limit was the hard (rather, annoying) part. Revised table to be ported over to the main thread in a moment.

Edit: Err, it would if I had remembered to bring the correct version of the spreadsheet to this computer...

Don't ever use long formulas in Excel. Make your own functions in VBA: Create a new module in VBA, write a function (not a sub) and use it in Excel just like you would use any built in function. Immensely better than stupid cell formulas.

[Asashosakari 19,682]

Don't ever use long formulas in Excel. Make your own functions in VBA: Create a new module in VBA, write a function (not a sub) and use it in Excel just like you would use any built in function. Immensely better than stupid cell formulas.

Yeah, I probably should, just usually too lazy to port it over (or to finally learn more than rudimentary VBA, really). My table output code doesn't usually end up particularly large or particularly complicated (it's just a bunch of td's and tr's strung together after all), this one just spiralled out of control.