So, the highest Sentiment value post was Sometimes I Love People. Unfortunately, it's probably an outlier, as it only had three words. (Correctly counted.) The lowest value post was The Apocalypse Has Not Been Postponed, 224 words in Table view. (Word Service reports 223, but close enough.)

So, positive values = "positive" sentiment; negative, the opposite. The average for April was -0.401272571, the median was -0.434313734. (Surprisingly, you can't just right-click and copy these summary values at the bottom of a Numbers table. I'm using TextSniper to copy them because that's a lot of digits to remember.)

I also discovered the word count discrepancy is significant in the posts with images, probably because there's html export code included in the $Text, and values inserted into that export code.

To make something like this more useful on a regular basis, I'd probably want to include the permalink as a Displayed Attribute, so I can just click right to the post from Numbers, instead of looking for it in the archive.

Again, all this type of analysis could be rolled up into a live dashboard within the Tinderbox file itself, which could then be exported as a page in the blog. Something I may do.

Originally posted at Nice Marmot 10:23 Wednesday, 8 May 2024