Phase 10 Score Tracking Spreadsheet

Want to keep track of scores Phase 10 but don’t want to use paper? There really wasn’t any easy way to do it electronically. I can’t think of an app that would do this well. Here’s what I would want the score keeper to be able to do:

  • enter in numbers and the total score is calculated automatically
  • keep track of who has completed a phase in a round
  • easily calculate which phase each player is on

Well, could a spreadsheet do that? Yes! Yes it can!

Here’s mine:

And here’s the template version: https://docs.google.com/spreadsheets/d/1PzaZWrFHKojBDYrMMDB-5gSQEs9ORg65Jt4MMbVfI2M/copy?copyComments=false

It accomplishes all of the intended tasks. Phases completed are shown by checking a box, and at the bottom is a tally of how many boxes are checked. Pretty straightforward. But it also gives a round amount you can enter, and the running total automatically displays on the right.

How can you use it? You’d probably want to download/copy the file. It’s a google sheet. Enter your own players and scores under the player’s names.

If you use it and like it, please let me know! If you found mistakes or ways to improve, let me know! If you want to distribute it (or modify and distribute), please credit me.

Bible Reading Plan Spreadsheet

I wanted to start doing the Robert M’Cheyne Bible reading plan this year. In it there is about 4 chapters per day, organized to have two from the Old Testament, and two from the New. There is an emphasis on reading the New Testament twice throughout the year.

Here’s a PDF of M’Cheyne’s plan with some pros and cons mentioned at the start:

No big deal – there are a lot of ways to keep track. Well, I’m the kind of guy I don’t want to have paper around, so printing off is something I’d like to avoid. I also don’t want to install an app that doesn’t let me manage things precisely.

You guessed it! It’s time for a spreadsheet.

Unfortunately, the PDF I had above isn’t really conducive to importing into a spreadsheet. So I grabbed a PDF from this site:

Specifically, I grabbed from the Printables:

And I modified from there.

The result? A spreadsheet that has every reading in its own cell, every date in its own cell, and a checkmark box for each reading. Reusable each year, because the dates don’t mention a year. It’s a Google Sheet, so feel free to download, copy, revise. Etc.

If you use it and like it, let me know. If you think there are mistakes or improvements to be made, please let me know. If you want to distribute it, please credit me and Ben Edgington (edginet.org).