So one of my friends had an idea that since there are 6-8 of us that play Armada, we could start keeping track of friendly games we play and record wins and losses. Ideally, I'd have the player, their head to head win/loss vs the other players, and their overall win/loss. The only problem... is that I'm godawful at Excel.

I know this is almost certainly the wrong forum to ask, but since you guys are (to quote Ben Affleck in Good Will Hunting) "wicked smaaaaaaaaht" I thought I'd ask here to see if

A. Someone has already done this and I can cannibalize their spreadsheet and change the names.

B. Someone can point me in the right direction to do this myself.

I mean, push to shove we can do it manually, but... what's the fun in that?

Thanks!

=countifs(O3:O13,"=player 2",L3:L13,"=player 1",O3:O13,"=1") (Number of times Player 2 has played away from home against player 1 and won)

I have not, but this may be a useful formula to use.

https://support.office.com/en-us/article/COUNTIFS-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842

I'd recommend using a drop down list for the player names as well, if you're using formulas you want to keep everything consistent.

Stick a list of player names somewhere, separate tab, and then use data validation and the list type.

Spread sheets are my life, something went wrong somewhere!

Tagging this for later.

Tagging this for later.

Cool! I'm still working on mine but you'll probably finish it more quickly (and more thoroughly) than I.

So it's done, but I'm not sure how to link a downloadable version from Google Drive. Anyone have a dropbox I can throw this into?

I don'\t have a Dropbox, but I do have a Handy Link:

https://support.google.com/drive/answer/2494822?hl=en&ref_topic=2525251

I don'\t have a Dropbox, but I do have a Handy Link:

https://support.google.com/drive/answer/2494822?hl=en&ref_topic=2525251

The problem there is my inability to let people download it. I guess I could gmail it or something upon request.

Generally if its Shared for Viewing, you give a download/print link on it.

its something you normally have to specifically turn off.

Generally if its Shared for Viewing, you give a download/print link on it.

its something you normally have to specifically turn off.

IN THAT CASE:

https://drive.google.com/open?id=0B-Kv_jCineUKbW1ZdmRSY0xaa1U

I believe it's relatively bug-free. It's a touch redundant (by the time I realized you'd have to enter players' names twice I had already gone past the point of no return on the head to head logic and confused myself). It's not perfect and it's very basic but it's more fun than typing everything in manually and it helped me learn some Excel.

Tested by Downloading, so you're all good