NSB Pick Em 2022 MASTERTHREAD

[MulaKO]

Especially when you consider that I'm a complete teetotaler

Is that right ?
Good for you , unfortunately I’m not
When you know Jack as well as I do , you begin calling him John

[Tatabanya]

Is that right ?
Good for you , unfortunately I’m not
When you know Jack as well as I do , you begin calling him John

Which is not entirely wrong, as you can see...

[Tatabanya]

Well... what are we going to do on October 15th, then?

SATURDAY, OCT. 15

London (ESPN+, Sky)
Claressa Shields (C , No. 2 P4P) vs. Savannah Marshall (No. 1, No. 9 P4P)
10 rounds – middleweights (for Shields’ Ring/WBA/WBC/IBF and Marshall’s WBO titles)

Mikaela Mayer (C, No. 4 P4P) vs. Alycia Baumgardner (No. 2)
10 rounds – junior lightweights (for Mayer’s Ring/IBF/WBO and Baumgardner’s WBC titles)

Melbourne, Australia (ESPN/ESPN+)
Devin Haney (C) vs. George Kambosos Jr. (No. 1)
12 rounds – lightweights (for Haney’s Ring/IBF/WBA/WBC/WBO titles)

Brooklyn, New York (Fox PPV)
Deontay Wilder (No. 2) vs. Robert Helenius
12 rounds – heavyweights more

Caleb Plant (No. 2) vs. Anthony Dirrell (No. 3)
12 rounds – super middleweights

Gary Antonio Russell (No. 4) vs. Emmanuel Rodriguez (No. 3)
12 rounds – bantamweights

[NC Uppercut]

Well... what are we going to do on October 15th, then?

SATURDAY, OCT. 15

London (ESPN+, Sky)
Claressa Shields (C , No. 2 P4P) vs. Savannah Marshall (No. 1, No. 9 P4P)
10 rounds – middleweights (for Shields’ Ring/WBA/WBC/IBF and Marshall’s WBO titles)

Mikaela Mayer (C, No. 4 P4P) vs. Alycia Baumgardner (No. 2)
10 rounds – junior lightweights (for Mayer’s Ring/IBF/WBO and Baumgardner’s WBC titles)

Melbourne, Australia (ESPN/ESPN+)
Devin Haney (C) vs. George Kambosos Jr. (No. 1)
12 rounds – lightweights (for Haney’s Ring/IBF/WBA/WBC/WBO titles)

Brooklyn, New York (Fox PPV)
Deontay Wilder (No. 2) vs. Robert Helenius
12 rounds – heavyweights more

Caleb Plant (No. 2) vs. Anthony Dirrell (No. 3)
12 rounds – super middleweights

Gary Antonio Russell (No. 4) vs. Emmanuel Rodriguez (No. 3)
12 rounds – bantamweights

We are gonna have a damn boxing festival!!!

[Tatabanya]

We are gonna have a damn boxing festival!!!

If we run all six together, I decline any responsibility for wrong mumbers in the standings on Sunday

[Citizen Koba]

Well... what are we going to do on October 15th, then?

SATURDAY, OCT. 15

London (ESPN+, Sky)
Claressa Shields (C , No. 2 P4P) vs. Savannah Marshall (No. 1, No. 9 P4P)
10 rounds – middleweights (for Shields’ Ring/WBA/WBC/IBF and Marshall’s WBO titles)

Mikaela Mayer (C, No. 4 P4P) vs. Alycia Baumgardner (No. 2)
10 rounds – junior lightweights (for Mayer’s Ring/IBF/WBO and Baumgardner’s WBC titles)

Melbourne, Australia (ESPN/ESPN+)
Devin Haney (C) vs. George Kambosos Jr. (No. 1)
12 rounds – lightweights (for Haney’s Ring/IBF/WBA/WBC/WBO titles)

Brooklyn, New York (Fox PPV)
Deontay Wilder (No. 2) vs. Robert Helenius
12 rounds – heavyweights more

Caleb Plant (No. 2) vs. Anthony Dirrell (No. 3)
12 rounds – super middleweights

Gary Antonio Russell (No. 4) vs. Emmanuel Rodriguez (No. 3)
12 rounds – bantamweights

Yeah... gonna be a big one there. My man siablo14 won't be happy but every one of those fights belong in the Pick Em, that's just the way it falls sometimes. Like buses.

Okay so it'll be 2 threads; the Shields - Marshall card and Haney vs Kambosos on one thread and the Brooklyn card on the other.

[Citizen Koba]

Just for the sake of awareness, how much of the data com*****g in the master thread spreadsheet is automatic, and how much is manual? Perhaps - if it's not too time-consuming - I might give it a try (with the due behind-the-scene explanations...). For example, I can't understand how one keeps the "streak" column updated...

Ha... now I 've been meaning to prepare a step by step guide for about the past 2 or 3 years just in case something happens that puts me out of action for awhile to make sure someone can pick it up without too much trouble - save all the trial and error I had to go through. I'll defo look at getting that done sometime in the next few weeks anyway. But to answer your question aside from the actual data input I just use fairly straightforward tools for the rest, data sorts for ordering alphabetically whilst I'm doing the tally and then a block cut n paste (add for the scores and tally, subtract for the multiplier collumns)onto the alphabetically sorted leaderboard and then another data sort to get it into desceneding points order.

As you obviously already worked out the only bit that doesn't lend itself to automation are the 'streak' columns and honestly I rue the day I decided to include em cos it's fiddly and easy to make mistakes on. If we're gonna streamline it at all the streak count will be the first thing to go. I did look into ways to automate it a little when I first started doing this by spreadsheet about 2019 or so but it seems the only way would be to get into writing a macro for it.... I actually meant to figure out how to do that but somehow put it aside and never came back to it.

Formula for calaculating the percentage was relatively straightforward.. mmm, something like RND 100x(#correct/#picks)...


Now with a bit of work setting up it should be possible to automate it much further, so each individual fight could be input with a single keystroke (assuming no multipliers etc) and I did have some discussion with a asgarth about this a while back but never really followed up. Might be the time to do that too.

Ah, bugger, school run time. OK... I'll have to get back to this later!

[siablo14]

Yeah... gonna be a big one there. My man siablo14 won't be happy but every one of those fights belong in the Pick Em, that's just the way it falls sometimes. Like buses.

Okay so it'll be 2 threads; the Shields - Marshall card and Haney vs Kambosos on one thread and the Brooklyn card on the other.

Those are cool. I am familiar with them.

[NC Uppercut]

Ha... now I 've been meaning to prepare a step by step guide for about the past 2 or 3 years just in case something happens that puts me out of action for awhile to make sure someone can pick it up without too much trouble - save all the trial and error I had to go through. I'll defo look at getting that done sometime in the next few weeks anyway. But to answer your question aside from the actual data input I just use fairly straightforward tools for the rest, data sorts for ordering alphabetically whilst I'm doing the tally and then a block cut n paste (add for the scores and tally, subtract for the multiplier collumns)onto the alphabetically sorted leaderboard and then another data sort to get it into desceneding points order.

As you obviously already worked out the only bit that doesn't lend itself to automation are the 'streak' columns and honestly I rue the day I decided to include em cos it's fiddly and easy to make mistakes on. If we're gonna streamline it at all the streak count will be the first thing to go. I did look into ways to automate it a little when I first started doing this by spreadsheet about 2019 or so but it seems the only way would be to get into writing a macro for it.... I actually meant to figure out how to do that but somehow put it aside and never came back to it.

Formula for calaculating the percentage was relatively straightforward.. mmm, something like RND 100x(#correct/#picks)...


Now with a bit of work setting up it should be possible to automate it much further, so each individual fight could be input with a single keystroke (assuming no multipliers etc) and I did have some discussion with a@asgarth about this a while back but never really followed up. Might be the time to do that too.

Ah, bugger, school run time. OK... I'll have to get back to this later!

Told you guys….he’s quicker than damn computer!!
Koba…is Da’ Man!!

Thank you for all the work brother, it is greatly appreciated!

[SUBZER0ED]

Yeah... gonna be a big one there. My man siablo14 won't be happy but every one of those fights belong in the Pick Em, that's just the way it falls sometimes. Like buses.

Okay so it'll be 2 threads; the Shields - Marshall card and Haney vs Kambosos on one thread and the Brooklyn card on the other.

A killer weekend of boxing, to be sure!