Open Loops 4/10/2015


On Fridays I pull the best of my blog readings to share with readers. Topics can come from anywhere, and cover anything. This week I highlight articles on

  • Learn what ala carte TV really costs
  • A rant against K Cups (mine) in response to a “reuse” article
  • 5 daily rituals for happiness
  • The anti-bucket list
  • When good enough really isn’t good enough
  • …and more!

Using Excel To Take Apart and Consolidate Text


I deal with a lot of information, for my job, for my classes, and for Girl Scouts. When I get information in a form that is readable, but not quite usable, I have the option to re-type it…or I can put Excel on the task and let it do the work.

Most people assume that Excel, as a spreadsheet, is just for crunching numbers. Truth be told, I use Excel more for text manipulation than I ever do for numbers. Today I am going to show you how to put text together — and take it apart — using Excel.


Creating an Idea Notebook in OneNote


This month on Mondays we are going to be looking at how a suite of tools – namely Microsoft Office – can make you more productive. Our first post in the series comes from one of my readers, who is organizing everything using OneNote, Microsoft’s notebook tool.

David Allen, in his book Getting Things Done, suggests creating a “Someday/Maybe” list for action ideas that you want to remember, but aren’t ready to commit to doing. Unfortunately, ideas tend to multiply like rabbits and mice, and a Someday/Maybe list can rapidly become less than useful.

My solution was OneNote. Here is how I use it.