Tutorial: How to Submit Games and Events to the Warhammer Underworlds Statistics

The Warhammer Underworlds Statistics Project needs your game data! Ever wonder how your warband truly performs or what the competitive meta looks like? This project aims to answer those questions by collecting and analyzing Nemesis format games.

The project’s success relies entirely on community contributions. You, the players and event organizers, are the source of this valuable data. Submitting your game results is easy, and crucial for the project’s growth and longevity.

Clear, concise instructions on submitting both individual games and event data are available in the navigation menu. For those who prefer a visual guide, I created a short video demonstrating the process (focusing on event data submission). Check it out and let me know what you think!

With around 600 games already recorded, we’re off to a great start. Help us build a comprehensive statistical resource for Warhammer Underworlds. Submit your data today!

Contact Borni (@raumzeit77 on Discord) or e-mail for any questions or if you’re an event organizer looking to contribute.

Video

Transcript

Hello and welcome to my introduction to the Warhammer Underworld statistics project for the second edition.

And here my focus is on tournament organizers, league organizers, event organizers in general, and how they can contribute to the project.

So first, some words on the project itself.

So the idea here is to collect statistics on the game Warhammer Underworlds and make them publicly available in order to understand what is being played, what is successful, what are maybe rising stars.

And this is a community-driven project.

So in order to get those statistics, people need to submit their games.

So it is not really automated in the sense of, I don't know, gathering data from tournament organization sites like Shade Glass or Best Coast Pairings.

But all games have to be submitted by community members like yourself.

And of course, this is both an advantage and a disadvantage.

But what I want to show here is the process of submitting games for your events.

And maybe reduce your fear of doing so by showing that it's actually not that hard.

So the main homepage of the project is on path to glory, podcast.com.

And here we have a menu for our statistics, second edition.

If you click on it, the site pops up.

And here you see all essential links for the project.

So the most simple way of submitting games is to use this game submission form.

And this is also suitable if you, as an individual, want to just submit your casual games, which is also totally fine for the project and very much appreciated.

And if you click on that link, what you get is this form.

And this is designed to submit individual matches, whether these are best of one, best of two, best of three.

You can just fill out all the boxes and hit submit.

And you can also use this form for submitting event data.

But there are some additional steps to take care of.

So if you go back to the homepage, there is a document linked called event information.

And here I lay out the whole process in written form.

But I will go through this now in real time.

So this video won't be updated very regularly.

So it's always good to check the last update and go through it quickly.

So first of all, when should you enter event data?

So I think the most easy setup is to do this while the event takes place.

So for example, before the event starts or in between rounds.

Because that way, you're already organizing.

You're already sorting through the scores.

And it really won't take much time.

If you do it afterwards, that's also fine.

But then you have to sit down again.

So with prerequisites, you should read the general FAQ on the project.

Which is also linked here.

Also, we record Nemesis games only.

And a Nemesis game has basically two data points.

The warband that was played and the deck combination that was being played.

And the goal is to record events where this information is available.

I don't know.

Maybe you don't know the warband deck combinations of one to three players.

And depending on the size of the event, that's fine.

But in general, it is highly appreciated if you just have all the data.

So these are the prerequisites.

How do you enter the data?

And this is basically the same for tournaments and leagues,

which are the two most common event types.

The maybe more easy to understand process is to use this submission form that I showed earlier.

But this is also more time consuming.

So you basically just use this form, game submission form,

and fill out this form for every matchup of your tournament.

So record each matchup individually.

And the only thing that you have to consider here is the tags.

So in the statistics, you see that under events and tags, I list the tournaments that are being recorded in the statistics.

And we basically group the games of the tournament using a tag.

So all game records of the event share this tag.

So what you do when you submit your individual matches using this form,

every time for each match, you add the tag.

And you can make up the tag yourself.

So you can just use yellow banana each time written in the same way.

There are some additional things you need to consider regarding the date.

So for multi-day tournaments, you just use the first date of the tournament.

For leagues, you use the date.

That is the first date of the round.

So if a round takes two weeks, you just use the first Monday of the two weeks as the date.

Then if you look at the deck selection,

for the first deck, you have this entry called unknown.

You use this if you simply don't know what deck was being played.

But again, this has to be the exception.

And if you look to the second deck choice,

you have unknown.

So if you don't know the deck combination, you pick unknown twice.

And if this was a nemesis event,

but the player decided to only play rivals,

you select the rivals deck for the first deck.

For example, Blazing Assault.

And then you pick rivals as the second deck.

Not the same deck again.

Okay.

Yeah.

You should also kind of keep track which matches you already entered

because you submit the form and you don't see the data again.

I mean, you can look at submissions and check what game you just entered.

It will pop up here somewhere.

I think it's better to just, okay, keep a spreadsheet or something or a list.

First match doesn't match.

Fourth match.

Round one done.

I need to know about your event to properly enter it into the statistics.

And for this, there's the event form here.

This is also linked event submission form.

And this is another form that you only use if you enter event data,

not if you enter individual games.

Yeah.

And you just fill it out.

And I have to add, this is only if you submit tournament games.

because leagues are basically just treated like individual games.

Also, I should have pointed this out before.

For leagues, you also don't enter a tag.

You basically treat leagues as individual games.

They're not associated to an event.

Yeah.

So here, if you enter a tournament, you go through this list.

You tell me the tag so I can associate the games.

And one thing to keep in mind, but the rest is pretty self-explanatory, I think, is the placement data.

So we've already been the deck combinations of the first, second, and third place,

which will enable me to distill placement rankings of warbands and decks.

Okay.

So that is the first way of entering event data.

And depending on how quick you are, you can punch out a form in like 20 to 30 seconds.

Also, all drop down support autocomplete.

So you click and type in reg, and it already selects it without having to move the mouse cursor.

Okay.

So the second way of entering event data, this is less time intensive.

It is quicker, but also more complex.

So, of course, you mean the form transforms.

The form is being transformed into a spreadsheet, right?

So it makes sense to just enter the data into a spreadsheet from the beginning.

But you don't have editing privileges here, and of course, I won't give them because people can just go crazy.

So what I've done is I created a pre-formatted sheet that you can use to enter event data.

And this is also linked here, event spreadsheet.

So if you open this up, you get this.

And you also don't have editing privileges.

But what you can do and should do is you click on, this is called file in English, create a copy.

You have to be logged into a Google account for doing this.

If you really don't have any Google accounts, you can use download, download as Excel, and fill it out in Excel.

Some features might not be supported, but it will still work.

Okay.

So we create an online copy.

Now you have the same spreadsheet with editing privileges.

Here are some instructions.

Okay.

And the first thing you need to fill out is the sheet players.

And here you just enter the player name, the warband and decks.

So just to illustrate this, I will use data that I recorded for the world championship using this form.

Okay.

So here are some players and warband and deck combinations.

I just paste them here.

And as you can see, these drop downs are also pre-formatted with all the available warbands and decks.

And you can also use autocomplete.

So you type and the respective characteristic will pop up.

Okay.

So you first enter all players, warbands and deck combinations that you know of.

This, of course, applies mostly to tournaments.

If you're entering a league, you might not be able to use this, as the warband and deck combinations might change per round, depending on how your league is set up.

But this is the workflow for tournaments.

And what you then do is you basically enter each matchup separately.

Again, and this is the same for tournaments and leagues.

You have a way of tracking what data you already entered.

So there's the sheet checklist.

And here you can just use the check marks to track which matches you already input.

The actual data entry happens in the sheet data.

Okay.

And this is basically a replication of the actual statistics spreadsheet that I have a copy of this data into.

So the first thing to do is select the players.

And again, this is more for tournaments.

So you select player one.

And as you can see, this process is automated.

So this dropdown takes the data from this sheet.

And it also supports autocomplete.

So if I type in Daniel, okay, I immediately get the two Daniels here.

If you win, confirm via hitting enter.

The sheet will automatically pull the variable and deck combination of this player from the player's sheet.

And again, for leagues with changing pairings, this will not work.

So in that case, let me just delete this.

You can just use the dropdown.

Ignore this formula.

Just use the dropdown.

It really takes a little bit more time.

And then you move on to player two.

Again, type in something.

And it automatically fills out this information.

And then you basically only have to enter, manually enter, the actual outcomes.

For example, this player, one to games, and Rostowantoskander.

And you repeat this for each and every matchup of your tournament.

Okay.

Then you adjust the date accordingly using the North American format.

And you can also use this drag to copy function to just drag this date down.

Okay.

And here you can write the tag.

And also drag it down for all completed entries.

But in the end, this isn't as important.

Because there's one final step.

Yeah.

So after you record all matchups, you hit file, share, share for others.

And then you create a link.

And this link has to be a link with editing privileges.

And you send me this link.

Okay.

Because otherwise, I won't get the data.

And you can find my contact information linked here.

Yeah.

So this is me, Bonnie.

And you send me this file.

The link to the file.

So I can copy paste all the data.

If you are doing a tournament, you of course still have to fill out the event.

submission form.

Because otherwise, the link to the event form is also linked here.

And then you're done.

And I did this for, I don't know, 550 World Championship Games.

And I think it took me two and a half hours while having no idea about the actual matchups

before and without having been at the actual event.

And I think if you just, at the start of your event, while you check in the players,

fill out the player sheet, and in between rounds, quickly enter the results,

this will be very quick to submit.

And even after the tournament.

I mean, once you've filled out the player sheet, it's really quick.

Like, you can do one round in maybe three minutes, I would say.

Yeah.

So that's it.

If you have any questions, just write me on Discord via mail.