I've downloaded my chess games into excel and trying to put them into a pivot table. At the moment I'm trying to analyze the games by opening but am stuck on how to make it meaningful.
This is what I'd want the result to look like. But I don't know how to do so.
Here's the relevant part of the data. Something weird is happening in col X, not sure what that's about. The formula is consistent throughout the column. Let's ignore that for now.
nfq4
This is what I'd want the result to look like. But I don't know how to do so.
Opening | Number of Games Played | Percentage of Games Played | Win Rate |
King's Pawn | 50 | 20% | 45% |
Sicilian | 20 | 7% | 47% |
Here's the relevant part of the data. Something weird is happening in col X, not sure what that's about. The formula is consistent throughout the column. Let's ignore that for now.
nfq4