Jomangor

Ok, I've completed my own spreadsheet through 1929 inclusive, based on the posts of Gurowake and Sakura. Interesting to note: Onishiki successfully defended the shield on average the most but only held it the once, where as Tochigayama successfully defended it the most often overall. Kiyosegawa and Dewagatake won the shield from others most often (five times each) with Dewagatake slightly better at holding on to it. Rikishi Awarded Won Successfully Defended Ave. Defenses per Possession Akutsugawa 1 4 4.0 Asahibiki 1 2 2.0 Dewagatake 5 7 1.4 Fukuyanahi 1 0 0.0 Hatasegawa 2 8 4.0 Hitachidake 3 2 0.7 Hitachishima 3 5 1.7 Hitachiwa 1 7 7.0 Hoshikabuto 1 0.0 Ichinohama 1 0.0 Imizugawa 1 1 1.0 Kagamiiwa 1 1 1.0 Kiyosegawa 5 5 1.0 Komaizumi 1 3 3.0 Manazuru 2 2 1.0 Misugiiso 2 1 0.5 Miyagiyama 1 7 7.0 Nishikinada 2 2 1.0 Nishinoumi 4 5 1.3 Noshirogata 3 2 0.7 Onishiki 1 14 14.0 Onogawa 2 7 3.5 Onosato 2 5 2.5 Oshio 1 3 3.0 Shinobuyama 1 1 1.0 Sotogahama 1 0.0 Tachihikari 3 11 3.7 Takaragawa 1 0.0 Tamaikari 1 0.0 Tamanishiki 4 2 0.5 Terukaze 1 1 1.0 Tochigayama 1 1 20 10.0 Tsunenohana 2 7 3.5 Tsurugahama 1 0 0.0 Wakabayama 2 2 1.0 Yamanishiki 3 3 1.0 Yoshinoyama 3 1 0.3

Since I brought this up in the crosspost, I thought I'd give a better example of what I mean. I propose the following tracking: Rikishi Awarded Won Successfully Defended Ave. Defenses per Possession Oshio 1 3 3 Onishiki 1 14 14 Misugiiso 1 1 1 Tsurugahama 1 0 0 Tachihikari 1 4 4 Komaizumi 1 3 3 I've added it at this point because it demonstrates the difference between what Gurowake has so kindly started and what I'm suggesting for cleaner recordkeeping. The issue of a shieldholder missing a bout or tournament seems analogous to a shieldholding rugby team playing an away game - that match is not counted in the statistics.

It seems as though we're keeping track of how many times a wrestler has defended the shield, but not how often he has won it from another wrestler. The wikipedia page on the Ranfurly Shield has an 'overall records' table that lists Wins, Successful Defenses, and Average Defenses (per possession). I can't keep up with the pace of the work being done in the other thread, but I thought it worth mentioning before we get too far along to make the tracking too onerous.

This is the kind of post that makes me wish there were a 'wow' option under the like symbol.

For the record, Italian has seven vowel sounds, which is certainly covered by your 'approximately', but the two 'e' and two 'o' sounds can add to some subtle confusion.

What is it that makes you say that? I'm not trying to challenge you; I'm genuinely curious.

This is good advice. Specifically, this is a link to references on the tachiai blog. I'm with you, however. I also wish there were a centralized reference. If you find one, please let us know!

Seems like a good idea! How recent is the importance of Nakabi? There aren't any special rituals reserved for it, are there?

We have him for another three years before retirement at least, don't we? Enjoy the ride.

What's the Moirurara story? I can't seem to find it in the search.

Google sheets doesn't support VBA, but does support JavaScript, so I guess I'll have to learn Javascript. Thanks again to both of you for the help!

The simple style might be just what I'm looking for! I'm using google sheets, but the scraping protocol is similar enough to excel. Up until now, I've used regular expressions to find what I want. How are you doing it so that it also scrapes the Rikishi number?

Python is a few steps beyond my current ability, but I thank you for the offer!

Any programmers on the forums? I'm trying to scrape daily win-loss information for top division bouts, but my two main sources (sumo.or.jp and sumodb) use images to record wins and losses. Is there anywhere I can find the results as ones and zeroes or text (w, l, etc)? Or is there a way for me to scrape image info into google sheets? I'd be glad for any advice!

If it's not against forum rules, please do!