it doesn't take out the game between you and your opponent when calculating OWP and same for OOWP.

Gotta be someone smarter than me out there...

My spreadsheet has multiple sheets with a summary sheet and each team has their own sheet. Each team sheet has their games listed and then puts their win percent at the bottom. Then, next to their opponent, it has their opponents WP pulled in from their specific sheet. Obviously this is wrong, because it didn't exclude the two head to head games. The same calculation goes on for OOWP.