RYP Presents: In Deep Sheet, Part 3: The Formulas
We're here to help, even if you're obstinately not using our platform.

RYP Presents: In Deep Sheet, Part 3: The Formulas

Learn how spreadsheets and formulas actually operate and make that ugly little college football pick'em sheet of yours actually work.

Nicky G
Nicky G

Making that ugly little pick'em spreadsheet of yours work...

Read Part 2 here >>


Step 3A: Learn how spreadsheets actually operate (or just save yourself and skip this and go to the next step)

We could take several dozen pages to explain the intricacies of spreadsheet building, but we’re not interested in that.

First of all, we’ve got lives and that is dreadfully boring.

Second of all, we’re here to help you limp through the bowl season with something to show for your efforts. That's it. No more, no less.

Still, if you’re curious on how these formulas and mechanisms actually work, you can bone up on formulas here at these resources:

Conditional formatting
Conditional formatting is a type of formatting that applies different styles to cells based on the values within them. It can help make complex data easier to understand at a glance, but you're already bored as can be reading this so why bother learning how to do that?

Data validation (AKA drop down lists)
Data validation verifies the validity of a particular data format and can be carried out with a validation rule, which is synchronized with the input data. Google Sheets has an option for data validation that can be done by using one or more of these validation rules. Are you actually still reading this or have you gone into a coma-like state? Hello? You there?

Macros are pieces of code that allow you to do things in Google Sheets that you couldn't otherwise do with just the spreadsheet's built-in functionality. Again, you're free to teach yourself how to do those or you could literally do anything else with your time.

Countif formulas
Countif formulas in Google spreadsheet work by counting the number of cells with a specific value that meet a certain criterion. They are essential to understand when you have data that spans more than one row or column.

Now if you'll excuse me, I'd like to go to sleep for forever. ZZZZZZZ

Step 3B: Skip all that hogwash altogether

Okay fine.

We’ll just do it ourselves.

If you’re even a teensy bit lazy and want the most rudimentary of all, let’s just give you the  template spreadsheet already.  (If you have more than 5 folks you want to join a bowl pool with, you can add columns on to the end and pull the formulas into those cells. It’s not fantastic, but it’s a place to start.)

NOTE: You’re also free to try to find free NCAA bowl spreadsheets elsewhere on the Internet, though we do warn you about downloading files you aren’t familiar with (viruses) or providing them with your email (which they often sell to third-party vendors).

Remember: It might be free now... But you’ll pay, one way or the other.

Oh, you’ll pay alright.

Step 3C: Yes, you still have more work to do

The thankless labor isn’t over for you, my friend.

Oh no.

You’ll still need to duplicate the spreadsheet you use, collect picks from your members, manually enter those picks, and double-check them for accuracy. Or, again, you could just stop all this madness and join RunYourPool.com! Why are you still reading this!

Just use us already! Gah!

Continue to Part 4 >>


Nicky G

Dad of 3. WVian by birth. ATX for now.