Using Excel's INDEX/MATCH approach on unsorted columns

You can combine Excel's INDEX() and MATCH() functions to search for values in a column, but it relies on your data being sorted to work correctly. I figured out a solution for unsorted data by incorporating MINIFS() and MAXIFS() into the logic.

Targeting database tables in workflows

The targets package is a fantastic tool for reproducible workflows, but requires a some extra logic when working with databases.

Reading spatial data from SQL Server with DBI and wk (not sf)

There are quite a few ways to interact with MS SQL Server from R, but things seem more limited when it comes to spatial data. I figured out a way to have my cake and eat it too.

A Dissertation, Completed

Reflecting on things I wish I'd known when I started graduate school.

Computing in the Cloud with Google and RStudio

I used Google Cloud Platform to do some heavy lifting with R. Here's a quick guide to get started.