How did TDAA do at meeting its goals? How did TDAA compare to statistics from prior years? Lots of juicy metrics and reflection in this end of year round up!
how to combine three contact lists
How to use simple spreadsheet formulas to merge three or more contact lists into one. Useful for data cleanup, data migration, surveys, event management, and email blasts!
exposition on building a civil rights outcomes tracking database
Reading about the SCLC's impact in their voter registration efforts leads to a fantasy about how to build a database for civil rights metrics. Hats off to my personal hero, Jack O'Dell.
Dear Spreadsheet Whisperer: Date Me?
What do my partner, date field formulas, and the Chicks have in common? Read this post to find out! Especially if you create time sheet systems to manage your workload!
introducing: xlookup
Puppies are organizing to convince the zoning board to protect their dog park! They need help from VLOOKUP and XLOOKUP to get the job done. Follow along as we learn the ins and outs of these powerful functions in Excel and Google Sheets!
5 Google Sheets tips every teacher can use
Teachers, I am so humbled by your brilliance and I will keep fighting for a world that treats you with the dignity you deserve. Here's a tiny contribution toward making your day slightly more magical.
5 Google Sheets tips every organizer can use
For the month of March, I'm challenging myself to write a weekly "Listicle" style article for the different communities and audiences that make up the TDAA readership. No matter how technical this blog veers, it is and always has been my way of writing love letters to social movement organizers. This is my core motivation for learning data/tech and for writing at all! So my first post is dedicated to you <3
Dear Spreadsheet Whisperer: Tzedakah Tsuris
What to do when you outgrow your grassroots spreadsheet systems? Try Airtable! It's flexible, freemium, and fun to use. Oh, and this is #NotAnAd!
hay in a needlestack
What to do when you find data discrepancies?! I kinda felt like I did 6 loads of laundry, came out with socks I didn't even know I had, and then figured out how to match them up. Also, Spongebob, Rubix Cubes, and pivot tables.
filter down spreadsheet formulas
Like a coffee filter, the filter functions that I'm writing about today help us get to the very essence of our data. Read on for examples of filtering and summarizing a complex dataset, informed by a recent consulting project for an emergency homeless shelter.