Month: March 2019

My 4-day Push Pull Split Workout

Back in September, my daughter asked to start going to the gym with me. She wanted to go four days a week instead of my usual two or three, so I needed to rewrite my workout plan. I prefer a whole body workout, so I moved to a push/pull split and have been tinkering with

I need Church

It was a rough day today. We all have them. I could barely hold myself together but I went to church anyway looking for some healing.  I’ve been subbing with the 5yos lately, and most weeks one of the boys shows me some rocks he keeps in his pocket. They’re mostly white quartz, about the

Easy garden hoops for low tunnel shade

We came up with this simple way of making a small hoop house for lettuce a couple of years ago. It uses lengths of 3/4 inch PVC and 1 inch PVC to make the hoops. I’ll buy snap clips from Johnny’s to attach some shade cloth as it gets warmer.

Sacrament Meeting Master Planner

This is the Google Sheet my ward uses to coordinate sacrament meeting. This is the third version of this document I’ve worked on, and this one is the best. Here’s what it does: Lists speakers by first name, alphabetically, with the date of their talks. This makes it easy for you to find out when

How to INDEX multiple columns

I needed to check multiple columns in different spreadsheets and output the matching result. I wasn’t sure that VLOOKUP would work for this case and INDEX-MATCH is supposed to be better anyway, so I used the following code. It uses IFERROR to nest MATCH functions: The above checks for matches in colums A, Q, and

How to SORT multiple columns in Google Sheets

Yesterday I was working on a spreadsheet that needed to SORT items from several different columns. SORT only accepts one argument, and I couldn’t find any examples online about how (or if) you could SORT multiple columns. Maybe this is obvious to everyone else, but it wasn’t to me. The answer is to put arguments

Flashback

My best friend and roommate from BYU was called last Sunday to be the Young Women’s president in her ward. Her ward and stake split at the same time, and her ward lost a lot of leadership and not many youth. The ward had about 80 active youth. Many of the boys went to a