Skip to content

The Data are Alright

  • Home
  • Blog
    • Spreadsheets
    • Civil Writes
    • Salesforce
    • Conga Composer
  • Dear Spreadsheet Whisperer
  • Consulting services
  • About
    • Testimonials
    • Link tree
    • Contact me

Tag: Public Health

April 24, 2019 Samantha Shain Dear Spreadsheet Whisperer, Uncategorized

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.

December 15, 2018 Samantha Shain Uncategorized

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.

March 26, 2018March 27, 2018 Samantha Shain Uncategorized

Sticks and stones, broken bones, bad data

When I left the Urgent Care facility after I fell, staff members handed me a wad of receipts including my diagnosis, my visit summary and notices about my BMI and blood pressure.  In this blog post: why these data are NOT alright.

Tags

accounting address() array automation Black Lives Matter change management civil rights movement Civil Writes code conditional formatting conferences Conga Composer consulting counta() countif() crafting CRM cumulusci Data database data cleaning data culture data validation Data visualization de-dupe Dear Spreadsheet Whisperer EQAT error messages Excel facilitation feedback feminism filter() forms Formulas fundraising google scripts Google Sheets if() ifna() importrange() Impostor Syndrome indirect() interviews Justice large() LEFT() LEN() life with goldie listicle loops Mailchimp mailing list Mail Merge master's tools match() membership mentorship Metrics mindsets nationbuilder npsp openrefine open source phonebanking Pivot Tables poem PROPER() Public Health puns queer racial equity recruitment relational database reporting reproductive justice REPT() resource roundup RIGHT() rows() Salesforce salesforce flow search() self care SEO Single Source of Truth snowfakery social justice Spreadsheets sprints statistics SUBSTITUTE() sumif() systems testing thought piece TRIM() Tutorial unique() unofficial sf vlookup() xlookup() You Can Do It!
Powered by WordPress.com.
 

Loading Comments...