Start with games, not the match result
Copy each completed set with your pair’s number first. In the fictional CSV, the three rows are 6–0, 4–6 and 4–6. Reversing the final two rows because they were losses would change the meaning of the data. Keep one viewpoint for the whole file.
Add your column: 6 + 4 + 4 = 14. Add the opponents’ column: 0 + 6 + 6 = 12. The denominator is 14 + 12 = 26. Dividing 14 by 26 gives about 0.53846; expressed as a percentage and rounded to two decimal places, that is 53.85%.

