Merlin’s weekly podcast with Dan Benjamin. We talk about creativity, independence, and making things you love.
Merlin’s weekly podcast with Dan Benjamin. We talk about creativity, independence, and making things you love.
”What’s 43 Folders?”
43Folders.com is Merlin Mann’s website about finding the time and attention to do your best creative work.
Open Thread: How are you using Excel?
Merlin Mann | Aug 22 2006
Yesterday, I mentioned I'd been talking with someone who's looking at interesting things people are doing with Microsoft Excel. I talked to her again yesterday, and with her official okey-dokey, I'll virtually introduce Tralee Pearce (*waves*), a reporter from Toronto's Globe & Mail whom you might remember from a very swell article about the Hipster PDA. So, by request -- and to help Tralee with fleshing out her fun-sounding article -- I hope you all will jump in here: What kind of cool, novel, and non-obvious stuff are you doing with Excel? What's the wildest, most obsessive, most nerdy thing you ever saw someone do with our favorite spreadsheet program? 119 Comments
POSTED IN:
![]() We use it for our...Submitted by Derek (not verified) on August 22, 2006 - 7:14am.
We use it for our co-ed slow pitch softball team lineups. There's one sheet that defines the roster, including the sex of the player. It also includes a column that tells us wheather the player will be at the next game. There's then another sheet where you can plug in the inning-by-inning defensive alignment. This sheet is smart enough to know when you've broken rules (fewer than 3 girls playing), if you're playing someone who won't be at the game, and tallies the innings played by each player so we can keep things fair and even amongst the team. A third sheet allows the manager to set the batting lineup. Not a whole lot of intelligence here other than flagging if players are scheduled to appear in a game but aren't in the lineup. The final sheet simply pulls in the lineup and deffensive alignment sheets and creates a pretty printout with all the information on one page. We print out a couple of copies to put on the bench for players to check every inning. » POSTED IN:
|
|
EXPLORE 43Folders | THE GOOD STUFF |