Home > WordPress > Rampages Numbers

Rampages Numbers

In responding to some data requests, I delved into the WP tables to pull some rampages data.

All users ever . . .

I need to set up something more automated but for this I dumped the MySQL tables as CSVs and then just imported them to Google Sheets. With very minimal functions, I got this data.

My favorite function combos are to pull the unique values from a range =unique and then do a =countif off those values. It’s a really quick way to get graphs like these.

Related posts

01

A Backyard Hodge Podge of Recent Work

It’s been a bit chaotic over the last few weeks and I haven’t been posting much but I have been making fast videos of things. So I’m going to cram a bunch of those things together here with a bit of text to explain what they are and why they might be interesting. Some of the videos were made for faculty, some for some weird audience that exists only in my head. So if the title wasn’t enough of a warning, this is a weird mix of things with little connection other than I did them recently. Virtual Poster Session This started with a proof of concept demo. It evolved into an actual site that’s been well received so far. Research Interest Site This site helps students and faculty find one another around research. WordPress Art Theme This was a minimal WordPress theme we started based on a request from a faculty member looking to use it for art students but then they went another route. As a result, the development is limited. I imagine it’ll get picked back up at some point or another or used as the base for something else. Gravity Forms to Slack to Email Workflow Sometimes you want your form submission to alert you in Slack but then you need to reply in an email […]

01

Super Cleansing Cut/Paste into Tiny MCE in WordPress

Had someone cut/pasting from Google Docs into WordPress and it was ending up littered with internal style elements and super irritating span classes. I found this post which got me 95% of the way there and just added .removeAttr(‘style’) to get rid of the inline styles. Now I can just re-cut/paste and get a clean chunk of text.

20

Recent Work – July-ish Edition

Life is like a box of chaos and Forrest Gump was/is a descendent of Nathan Bedford Forrest and I’ve never read the Forrest Gump book. It’s always been difficult for me to keep track of what I did. I’m good about managing what’s in progress but once it’s done it fades from memory fairly quickly. It’s been worse lately as there’s just a lot going on. That is the purpose of writing these posts and really the main purpose of this blog over the years. I tend to look back at a few places to jog my memory when I write these- my calendar, github commits, codepen, and the YouTube videos I’ve made. Not perfect but it gets me started. It’s always amazing how much I forget until prompted. If anyone has better paths, I’d be interested in hearing about them. WordPress-y Things Lots going on with WordPress. I think I’m making some marked improvement on my overall design skills lately. I’ll credit Matt Roberts for inspiring me to up my game on that end. I’ve always cared what things look like but I think I’m better able to pull the whole thing together in a way that feels more unified now. Motivation in Context This is a lab site that has some custom post types and a nice relationship […]