I gave myself the title of "Chief Problem Solver." It fit like a Croc. A little squishy, a little dorky, but most of all comfortable and with room to evolve. In this post, some behind the scenes process notes about a project to find the perfect call-forwarding system for a small-scale and super-impactful local nonprofit. Oh yeah, and "I'm" trying out writing in the third-person-epic style.
encountering a real, live Excel bug
I think I stumbled upon an Excel "bug" (gasp!!) when I was combining SUMIF formulas plus sorting alphabetically. @___@ This is a new one, grasshoppers and honeybees! Sit down, buckle in, and enjoy the ride - we're gonna get technical with some formulas and explore what to do when you get real confused.
Dear Spreadsheet Whisperer: Quickbooks, MS Access, and Spreadsheets, oh my!
In this installment of Dear Spreadsheet Whisperer, we hear from an old friend who's storing contact information in.... Quickbooks! I offer advice about how to make better use of contact segmentation features and how to begin to explore a better database system.
spreadsheet bliss
Isn't it great when spreadsheets just WORK, making your repetitive tasks faster and more accurate? Here are two examples of spreadsheet tools I've built with a combination of Salesforce exports and spreadsheet prowess. Using them makes me feel proud and blissful!
private eye
In which I explore topics like cybersecurity, GDPR, privacy and accountability ... juxtaposed with how and when to collect demographic data. *Content warning* for discussion of sexual violence, im/migration status, and racism.
pain in the ass
Come for the puns, stay for the spreadsheets! I had surgery to remove a cyst, and now I have to use a spreadsheet to track my drainage. CW for discussion of medicine, surgery, and bodily fluids.
it doesn’t have to be this way
A new motto to help us grow technological resilience. An infographic (kind of). A reflection on why this blog is so important to me. A double dose of imagination. And more!
#GivingTuesday data roundup
A round-up of data and resources on the effectiveness of Giving Tuesday. TLDR? Looks like GT doesn't have a negative impact on end of year fundraising.
Small is beautiful, but so is scale! Or, how to embrace data strategy and reject underdog-ism
We ought to hold our movement organizations accountable from becoming a mirror image of the status quo. We can do all of that while embracing smart tools, systems, and infrastructure that will enable us to grow. Small is beautiful, but we can't stay small forever.
re”form” versus revolution
Government forms are notoriously awful! Good thing The Lab @ DC set out to redesign and re"form"at them! We could all learn from their example. Plus, some meta-analysis about my last post #WeWillNotBeErased. Come for the puns, stay for the learning!