iiinova — where your digital self keeps evolving

Reposted by Carl Colglazier

Darren Dahly @statsepi.bsky.social · 18/03/2026

Every day is a good day for sharing one of the most useful papers about research data ever written. PLEASE get your people to understand and follow this advice. www.tandfonline.com/doi/full/10....

Data Organization in Spreadsheets
Karl W. Broman
& Kara H. Woo
Pages 2-10 | Received 01 Jun 2017, Accepted author version posted online: 29 Sep 2017, Published online: 24 Apr 2018

1. Introduction
2. Be Consistent
3. Choose Good Names for Things
4. Write Dates as YYYY-MM-DD
5. No Empty Cells
6. Put Just One Thing in a Cell
7. Make it a Rectangle
8. Create a Data Dictionary
9. No Calculations in the Raw Data Files
10. Do Not Use Font Color or Highlighting as Data
11. Make Backups
12. Use Data Validation to Avoid Errors
13. Save the Data in Plain Text Files

ABSTRACT

Spreadsheets are widely used software tools for data entry, storage, analysis, and visualization. Focusing on the data entry and storage aspects, this article offers practical recommendations for organizing spreadsheet data to reduce errors and ease later analyses. The basic principles are: be consistent, write dates like YYYY-MM-DD, do not leave any cells empty, put just one thing in a cell, organize the data as a single rectangle (with subjects as rows and variables as columns, and with a single header row), create a data dictionary, do not include calculations in the raw data files, do not use font color or highlighting as data, choose good names for things, make backups, use data validation to avoid data entry errors, and save the data in plain text files.

311050400

Reposted by Carl Colglazier

maitreyi anantharaman @maitreyiaa.bsky.social · 18/03/2026

shoutout to the getty photographer who prepared for a WNBA lockout with this stock photoshoot. the only downside of labor peace is that we have no use for these beautiful images

a getty images search result with photos of a WNBA basketball wrapped in a big chain and lock

191696199

Reposted by Carl Colglazier

Nick Diakopoulos @ndiakopoulos.bsky.social · 02/12/2025

🚨 Postdoc opening -- Come work with us at Northwestern! 🚨 This position is to work on evaluating LLMs for sociopolitical value expression: postdocs.northwestern.edu/announcement... -- Please share!

postdocs.northwestern.edu

Postdoctoral Research Opportunity – Global LLM Values Benchmarking Working Group: Postdoctoral Affairs - Northwestern University

046

Reposted by Carl Colglazier

Jane Coaston @janecoaston.bsky.social · 23/10/2025

Not quite as funny as the University of Alabama betting scandal getting found out by a guy going into a sports book and being like "no no I have insider information" but I am not surprised that this got revealed because the NBA actually tries to keep an eye on gambling behavior re: players/coaches.

3595

Reposted by Carl Colglazier

Steven Lucy @slucy.bsky.social · 16/10/2025

Saw my first e-ink bus arrival time pilot at Grand & St. Clair! www.transitchicago.com/cta-announce...

1937126

Carl Colglazier @carl.cx · 08/10/2025

Playoff baseball hits different when the weather finally cools off

010

Reposted by Carl Colglazier

Seema Jayachandran @seema.bsky.social · 07/10/2025

We just spent 6 months to add 1 figure to this paper. Some people said, "Couples aren't prioritizing men's careers. Men just have better earnings opportunities when moving." Earnings effects of moves for couples on the left, singles on the right. Negligible gap between single men and women.

Event study coefficients that show that men's earnings rise more than women's among couples following a cross-commuting zone move (left panels). The pattern is muted or reverses among single men and single women (right panels).

328989

Reposted by Carl Colglazier

Alex @acannon.bsky.social · 02/10/2025

Quick look at the Uptown-Edgewater July Red Line station ridership. Lawrence and Berwyn returned to service on 07/20 while Argyle and Bryn Mawr moved into their new stations.

Stacked Bar Graph of July Red Line ridership from Wilson to Granville

Line Graph of July Red Line ridership from Wilson to Granville

1195

Reposted by Carl Colglazier

Block Club Chicago @blockclubchi.bsky.social · 02/10/2025

South Shore residents returned to their ransacked apartments after an ICE raid. "It looks like hell." blockclubchi.co/4gV8ODq

38752

Carl Colglazier @carl.cx · 02/10/2025

Changing the default fonts on your browser is surprisingly a huge value add.

020

Reposted by Carl Colglazier

Senior PowerPoint Engineer @ryxcommar.bsky.social · 29/09/2025

A friendly reminder as Nobel season approaches, the Nobel Prizes are not real Sveriges Riksbank Prizes in Memory of Alfred Nobel.

3699

Reposted by Carl Colglazier

Rafe Meager (they/them) @economeager.bsky.social · 30/09/2025

Bluesky is overall much better than Twitter but I do think we have the worst case of “so you hate waffles?” in the history of websites

1834925

Reposted by Carl Colglazier

Daniel Litt @littmath.bsky.social · 30/09/2025

Oh, you have criticisms of my paper? Surely you noticed the part of the paper where we already rebutted your critique, by writing “Possible criticisms: the methodology of this paper is bad. We are aware of this.”

59314

Reposted by Carl Colglazier

Andrew Heiss @andrew.heiss.phd · 29/09/2025

Just discovered a neat little #QuartoPub trick for formatting a range of dates. Quarto doesn't support start/end dates, but you can modify the date formatting string to fake it quarto.org/docs/referen...

---
title: "Kinda automatic date range"
date: 2025-09-30
date-format: "MMMM [29–]DD, YYYY"
language:
title-block-published: Workshop dates
---

Kinda automatic date range
Workshop dates
September 29–30, 2025

1406

Carl Colglazier @carl.cx · 22/09/2025

Kind of funny that the gap between LCD Soundsystem's breakup and "American Dream" was longer than the gap between "American Dream" and now.

000

Reposted by Carl Colglazier

Beth Popp Berman @epopppp.bsky.social · 18/09/2025

You know things are rough when the AAUP's advice on how to use social media is just "set all your accounts to private."

13775340

Carl Colglazier @carl.cx · 17/09/2025

Turning off auto updates

100

Reposted by Carl Colglazier

Timothy Caulfield @caulfieldtim.bsky.social · 10/09/2025

Denmark close to wiping out leading cancer-causing HPV strains after vaccine roll-out www.gavi.org/vaccineswork... "Before vaccination, the prevalence of HPV was between 15 & 17%, which has decreased in vaccinated women to less than one percent by 2021." #VaccinesWork

gavi.org

Denmark close to wiping out leading cancer-causing HPV strains after vaccine roll-out

A nationwide study suggests infections with human papillomavirus (HPV) types 16 and 18 have been virtually eliminated since vaccination began in 2008 – protecting even unvaccinated women.

418955

Carl Colglazier @carl.cx · 16/09/2025

Setting the work slack to a serif font @dame.is

110

Reposted by Carl Colglazier

Thomas Lin Pedersen @thomasp85.com · 11/09/2025

I am beyond excited to announce that ggplot2 4.0.0 has just landed on CRAN. It's not every day we have a new major #ggplot2 release but it is a fitting 18 year birthday present for the package. Get an overview of the release in this blog post and be on the lookout for more in-depth posts #rstats

tidyverse.org

ggplot2 4.0.0

A new major version of ggplot2 has been released on CRAN. Find out what is new here.

9851281

Reposted by Carl Colglazier

Jeremy Foote @jeremydfoote.com · 11/09/2025

I am recruiting PhD students this year! Our research group is holding an info session in a few weeks - details are at blog.communitydata.science/prospective-... , including a sign-up link.

blog.communitydata.science

Prospective PhD Student Q&A – September 26th

Thinking about applying to graduate school? Wonder what it’s like to pursue a PhD or M.S.? Interested in understanding relationships between technology and society? Curious about how to do research…

113

Reposted by Carl Colglazier

Neil Renic @ncrenic.bsky.social · 09/09/2025

Bleak

21837185

Carl Colglazier @carl.cx · 09/09/2025

Looking like it’s a pop punk fall

000

Reposted by Carl Colglazier

Victor Ray @victorerikray.bsky.social · 09/09/2025

I encourage people to watch this video. The selected footage shows the professor doing nothing even slightly out of line, whereas the student misinterprets the law and hopes to impose her religious beliefs on the material. Administrators caving to this is terrifying.

27804339

Reposted by Carl Colglazier

arthur.pizza @art.mastodon.sdf.org.ap.brid.gy · 02/09/2025

Finally solved the #Degoogling debate. Anyone who finds fault with this list = Skill issue.

The meme humorously suggests using Vim, a text editor, as an alternative to various Google services. Each Google app is paired with the Vim icon, implying that users can replace these services with Vim for a more privacy-focused approach, even for tasks typically handled by apps.

104985

Reposted by Carl Colglazier

Protect Bridgeport Bicyclists @stevevance.net · 01/09/2025

Let’s Get Buses and Trains funded Quickly

218847

Reposted by Carl Colglazier

Matthew Salganik @msalganik.bsky.social · 27/08/2025

Univ of Rhode Island has an open rank faculty position in the Dept of Political Science to lead their new PhD program in Computational Social Science. jobs.uri.edu/postings/15597

076

Reposted by Carl Colglazier

Jordan Nafa @ajordannafa.com · 20/08/2025

Are you interested in Bayesian Optimization? Do you think multi-arm bandits are cool? Do you like donating to good causes? We'll, I'm super excited to say I'll be hosting a charity workshop on Bayesian Optimization with Multi-Arm Bandits on October 23rd. sites.google.com/view/dariia-...

sites.google.com

Dariia Mykhailyshyna - Workshops for Ukraine

Feedback on the past workshops (if you want to learn how to make wordclouds, check out Text Data Analysis workshop below)

2225

Reposted by Carl Colglazier

Wam ✨ @wamwoowam.co.uk · 16/08/2025

Lumia 800 "ME" contact showing a bluesky status update of "hi :3" 28 seconds ago

Lumia 800 showing "what's new" feed showing all my bluesky posts

2125350

Reposted by Carl Colglazier

Oliver Haimson @haimson.bsky.social · 15/08/2025

Just read this incredible paper by @s0hw.bsky.social & @jeremydfoote.com: Why Do People Participate in Small Online Communities? The authors question the assumption that growth is always good, and instead show many benefits of small online communities. Highly recommended! dl.acm.org/doi/10.1145/...

dl.acm.org

Why do People Participate in Small Online Communities? | Proceedings of the ACM on Human-Computer Interaction

Many benefits of online communities---such as obtaining new information, opportunities, and social connections---increase with size. Thus, a "successful'' online community often evokes an image of hun...

2216

Reposted by Carl Colglazier

fox 🦊🏳️‍🌈 @foxes.bsky.social · 13/08/2025

When you look at Bluesky activity stats, things aren't great. But bots have gotten worse here in my experience, and so I can't help but wonder what "actual" activity metrics would look like.

071

Reposted by Carl Colglazier

Cameron @cameron.stream · 13/08/2025

People making apps on ATProto should probably stop adding -sky to the end of product names. It's a separate product! Own it.

1011419

Reposted by Carl Colglazier

Emil Hvitfeldt @emilhvitfeldt.bsky.social · 12/08/2025

some light teasing for an upcoming quarto revealjs plugin I have been working on

7619

Reposted by Carl Colglazier

Lars Marius Garshol @larsga.bsky.social · 12/08/2025

Accidentally created a map with rivers only. Check the Sahara.

Map of the world that only shows the rivers as lines. North and South America, Europe, Asia, and Africa are all easily visible. Apart from the Nile North Africa, however, is just blank. Australia is also mostly missing.

5476

Reposted by Carl Colglazier

Tristan Lee @tristanl.ee · 12/08/2025

This really seems like the beginning of the end of the open web. Devastating for archiving and research.

412439

Carl Colglazier @carl.cx · 08/08/2025

TIL you can have your own personal, secret little list of files for git to ignore if you edit .git/info/exclude

131

Reposted by Carl Colglazier

avi bagla @avibagla.com · 06/08/2025

Can Bluesky say every word in the dictionary? I dunno but I plan to find out! I made a website that tracks every single word said on bluesky (as of yesterday).

64610136

Reposted by Carl Colglazier

Sandra Laurentino @sandralaurentino.bsky.social · 01/08/2025

My mind is blown 🤯

141

Reposted by Carl Colglazier

Fantasy Flight Games @fantasyflightgames.bsky.social · 31/07/2025

As the battle for Mecatol Rex rages, change comes to the Galaxy. Twilight Imperium: Thunder’s Edge is a new expansion to everyone’s favorite galactic conquest and diplomacy board game Twilight Imperium Fourth Edition. Learn more: www.fantasyflightgames.com/en/news/2025...

youtu.be

2133

Carl Colglazier @carl.cx · 31/07/2025

I am being 100% serious when I say a social network being first to break baseball trade stories is a great proxy for its general utility for following the news

010

Reposted by Carl Colglazier

Brockton Coug 🇨🇦🏳️‍🌈 @massasoitcoug.bsky.social · 29/07/2025

One of the greatest baseball players of all time, probably the greatest Chicago Cubs player next to Ernie Banks. His legendary performance against the Cardinals in 1984 will never be forgotten. RIP Ryne Sandberg. youtu.be/34mz7wQKTB0?...

youtu.be

Harry Caray's call of the Sandberg game vs Cards 1984

YouTube video by John Mongani

292

Reposted by Carl Colglazier

dame @dame.is · 29/07/2025

i’m gonna — use more — em dashes — so many em — dashes — that not even — an AI could — be assumed — to be the writer — of my posts — this is — how we assert — our — humanity

2302

Reposted by Carl Colglazier

Renee DiResta @noupside.bsky.social · 29/07/2025

This is the end of a defamation lawsuit that Project Veritas filed against Stanford Internet Observatory, UW, and the NYT back in 2021. It lost its case against SIO in 2022, and was ordered to pay $150k in legal fees. They sue to tie organizations up for years. www.nytimes.com/2025/07/25/b...

nytimes.com

Project Veritas Withdraws Lawsuit Against The New York Times

1233493

Carl Colglazier @carl.cx · 29/07/2025

Working with @lit.dev and finding it a great fit for academic projects. The components are self-contained WebComponents you can drop anywhere. They rely on web standards, so unlikely to break over time and perfect for research code you build once and don't touch for years.

0265

Reposted by Carl Colglazier

Kuba Suder 🇵🇱🇺🇦 @mackuba.eu · 26/07/2025

Adding "All ATProto traffic needs to go through one central node that controls everything" to the list of Mastodon myths that I'll need to mention in a blog post…

5491