Month: March 2019

My 4-day Push Pull Split Workout

Jenny Smith / March 29, 2019

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 it ever since. There aren’t many push/pull splits out there for women that include a glute focus. Here is the current iteration of mine. Monday – Push Back squat – 3×8 Push-up – 3×8 Turkish getup – 1×4 each side (body weight, then cellphone or shoe, progress to 20lb kettlebell) Overhead press – 3×8 Donkey cable kickback – 3×10 Weighted sit up – 3×10 Tuesday…

Continue Reading→

I need Church

Jenny Smith / March 24, 2019

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 size of my thumbnail. He’s a little shy and doesn’t talk much, but It’s clear they’re special to him. Today while the rest of the class was busy with an activity, he slipped across the room to where I was sitting, dropped one of the rocks in my hand, and scurried off — didn’t even look me in the eye or acknowledge me the rest…

Continue Reading→

Easy garden hoops for low tunnel shade

Jenny Smith / March 22, 2019

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

Sacrament Meeting Master Planner

Jenny Smith / March 15, 2019

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 someone last spoke. Lists prayers by first name, alphabetically with the date of their prayers. This makes it easy for you to see when someone last offered a prayer. Calculates the frequency of songs. Your music director can use this to determine which songs are most popular and which are underused. Automatically looks up hymn titles. All you do is type in the hymn number,…

Continue Reading→

How to INDEX multiple columns

Jenny Smith / March 13, 2019

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 P in SpreadsheetA, and columns K and J in SpreadsheetB. This example does not include error checking, as each of the entries in field A59 are already UNIQUE. Don’t ask me how you’d do that — I don’t know :-)

How to SORT multiple columns in Google Sheets

Jenny Smith / March 13, 2019

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 within an array like this one, which shows how to SORT columns from several different spreadsheets. You can even use a function within the array. Just enclose your list in curly braces separated by semicolons: Here’s another example, which has multiple unnamed ranges from within a single spreadsheet:

Flashback

Jenny Smith / March 11, 2019

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 new unit, while about 30 girls stayed with my friend’s ward, where she has been serving as a Beehive adviser. For the time being they are combining both youth programs, for somewhere upwards of 90 active youth. It’s as frenetic as you’d imagine. On Wednesday, before the call had been made public, mutual was held as usual with the young women meeting in classes. If…

Continue Reading→