By July 30, 2013

Using Google Forms to Keep Track of Ascension Scores

I play a ton of Ascension, a card-based deck building game. I own the first core set and expansion and while I enjoy it, the digital experience is a lot easier to manage. Unfortunately as of this writing the Ascension app is only available for iOS. I backed the Android and Windows Kickstarter project, and hopefully we’ll see an Android version in the fall.

In the meantime, I’ve played over 600 games with Bert on his iPad Mini, and Sedagive? and I played a just a touch over a hundred before I returned my former employer’s iPad to them. I’m back into the world of iOS in my new job, and so I’ve got my own iPad Mini now.

Anyway, at some point we started tracking our games. Bert just takes a screenshot and manually adds the stats up over time. I kept a spreadsheet on Google Drive, but still tapped in the results after every game. It was a little unwieldy.

When I got my own iPad Mini I thought there could be a better way.

Here’s how I use Google Forms to keep track of our Ascension scores.

  1. Create a new Form within Google Drive
  2. Choose your theme. This is the most important step. Also, give your form a name. Also kinda important.

    01

  3. Type in your first question: who won? The question type is choose from a list.

    02

  4. Next up: the first player’s score. Title this question [first player] score, where [first player] is the name of the, uh, first player you entered in the previous step. You want to make sure the question type is text.

    03

  5. Add the second player’s score. Again, the question type should be text.

    04

  6. Your form is finished. The next thing to do is determine where your results will be stored. Click the “choose response destination” button near the top of the screen:

    04b

  7. Google Forms will automatically suggest the name for your results spreadsheet. Unless you want to get fancy, just click Create.

    05b

  8. This is what your form looks like: go ahead and enter some dummy data. I’m going to show you how to add up the total number of victories per player as well as the total number of points scored.

    05

  9. Okay, open your results spreadsheet in Google Drive. Add two rows above the test data you entered.

    In the first row, type “Total Victories” in the first column.

    In the second row, type “Total Points” in the first column.

    08

  10. In cell C2 type in the following:

    =COUNTIF(B:B, “You”)

    Please adjust “You” to Player 1’s name.

  11. In cell D2 type in the following:

    =COUNTIF(B:B, “Them”)

    Please adjust “Them” to Player 1’s name.

  12. In cell C3 type in the following:

    =sum(C4:C357)

    This adds up all the points for Player 1 after the spreadsheet’s header and the rows with the two totals.

  13. In cell D3 type in the following:

    =sum(D4:D357)

    This adds up all the points for Player 2 after the spreadsheet’s header and the rows with the two totals.

At some point you will have to edit the range for the point totals.

You can get the URL for your form by clicking the blue “Send Form” button in Google Forms. There are various sharing options as well as the direct link to the form. I bookmarked ours.

Hopefully this took longer to read than it did to set up your own point tracking system. From here you can derive some nerdy stats, such as the greatest margin of victory, highest and lowest scores, winning streaks, etc.

Have fun, and keep your fingers crossed for an early Android Ascension beta release :D

Related posts:

Tags: , , , , , ,
Posted in: games

Comments are closed.

7ads6x98y