Put the following expression in column B to save time: =IF(A7=1,2,IF(A7=0,2," "))
The most efficient way to fill out the sheet:
1) Wait for the round of the DE to be over.
3) Open a match to watch the replay. If the player on the top of the screen wins the roll, assign a B in the third column. If the player on the bottom of the screen wins the role assign an A. Repeat for each match
4) Repeat for the other three rounds.
So I'm looking for volunteers to help collect this data, if you're interested (and can commit to doing one whole DE) e-mail me at chrism315 at gmail dot com.
@dieplstks on twitter