Using the Stats Sheet

Quick Instruction Set for using the stats spreadsheet

First: Add the new columns to the end of the spreadsheet

  1. Select the last three columns.
  2. Right click (PC) or Ctrl-click (Mac) to open a shortcut menu
  3. Select “Insert 3 right”
  4. You should have three empty columns at the end of the spreadsheet.
  5. Label the columns: current date; Change; and % Change

Screenshot 2017-07-23 13.50.03

Second: Reset the data range to include the new columns. In the image below, you can see a thin green outline. That outline defines the data range for our spreadsheet.

Screenshot 2017-07-23 13.54.14

  1. Select the entire row containing the containing column headings (e.g. Change, %Change in the images above). To do this, click on the row number on the far left hand side of the spreadsheet.
  2. Select the Data menu; choose Turn Off Filter
  3. Leaving the same row selected, select the Data menu; choose Filter
  4. Check to make sure that the green box now includes the new columns, as shown below.

Screenshot 2017-07-23 13.59.25

Third: Enter the formulas and test them

  1. The change formula is the current date minus the last date.  Screenshot 2017-07-23 14.03.59
  2. The % Change formula is the Change value divided by the last date.Screenshot 2017-07-23 14.06.56
  3. To test the formulas, enter a value into the current date column. Let’s use 200,000. Screenshot 2017-07-23 14.09.24
  4. Now wait, those figures don’t really look right, do they? That’s because they need to be formatted. Select the cells containing the sample value and the change formula and, using Google’s formatting tools, change the formats to a Number format with no decimal points, as shown below. Ah! Much better.

Screenshot 2017-07-23 14.11.36

Screenshot 2017-07-23 14.13.45

Fourth: Copy the formulas down the column

  1. Highlight the cells with the formulas in them
  2. There is a small blue box in the lower right corner of the selection.
  3. Click and drag the blue box down the column to copy the formulas.Screenshot 2017-07-23 14.15.57

OPTIONAL Fifth: Hide the columns that you’re not using anymore. We’re adding three new columns every week, and after a while, you’ll have an enormous spreadsheet if we don’t take steps!

  1. Select the column(s) that you don’t need to see anymore
  2. Right-click (PC) or ctrl-click (mac) to get the shortcut menu
  3. Select Hide Column

Screenshot 2017-07-23 14.48.51

All done! Great job! Now enter the scores for your team for this week and you’re all set. Make sure you do it on the same day each week!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s