Race matchups & FTA

[CombatEX]

(12-17-2012 04:18 AM)Szei Wrote:  Looks great but might I suggest you make two extra overall tables for investigating p1 vs p2 on various maps independent of matchup and a table looking at matchups combining p1 and p2 results?


This way we can see the magnitude of FTA (or STA) on each map and see overall matchups independent of p1 vs p2.

So this is what I had in mind (beneath SFI data)

Match-up only and FTA example

This way we can view just the matchup data without P1 P2. I'd also like just a P1 vs P2 for each map. You can pretty much just copy and paste the two tables I made although you'll need to format them to look nice because I didn't fix the boarders on the first one. Also I didn't finish the FTA table. It's basically done but I didn't do the last 4 maps or so (the ones where it says etc instead of having the formula). I don't know much about excel so there's probably a faster way to copy and paste the formula and changing the row number instead of manually changing them all. I know you can do this for integer row increases just by copy and pasting, but I don't know how to skip something like 30 rows.