Data gathering spreadsheet

Hello reader,

I am trying to collect data on my records in a computer game (heartstone).
Background: there are 8 classes, 1 of which you play. Every round you face 1 of 8 classes, and you either win or lose. You will play on until you have lost 3 rounds, after which you get a reward (and can start over as the same or a different class).

I have looked for sheets that give me all the information I need, sadly I haven't found exactly what I'm looking for:

#1: An easy way to enter data. (Dropdown)
#2: Date enter system helps processing (Since it takes 3 losses to have to restart, the spreadsheet can already fill in upcoming games, since there will always be (at least) 3 more games when you have 0 losses, 2 with 1 loss and so on.
#3: A way to record data per class. (General Winrate)
#4: Class vs Class data. (when playing one class, what's the winrate vs every individual class)

I am usually able to fix these myself, but I've stumbled upon a few problems:
#1 I have done myself.
The rest however, leaves me quite clueless.

I'll upload the sheet which shows the layout I'm looking for. If anybody could help out, i'd be grateful.

Kind Regards,

Brent

G'day and welcome,

I've only helped with one of the steps requested. Record a Win and Loss between classes.

If you like help in the other steps please provide a layout of information with a before and after result.

Cheers

G'day Brent,

I'm going to have to call in the Calvary. I believe vba script will suit the help your after. Cos it will take lots of helper columns and days for me to work it out by formula and I don't have to time for that.

double post