A brilliant and efficient menu and grocery shopping system built with Google Sheets

A brilliant and efficient menu and grocery shopping system built with Google Sheets

We’ve optimized the heck out of cooking and shopping at my house. The key is a simple spreadsheet that my wife Kimberley built in Google Sheets — and it uses almost no math. We’ve improved it over more than a decade, and I can’t resist showing it off. Why this works for us This system…

Collaborating on research: the value of multiple perspectives
|

Collaborating on research: the value of multiple perspectives

Two or three researchers can do better than one. Here’s how to take advantage of that. For the purposes of this post, I’m talking about Web research that informs writing, whether that’s an article, a book, a white paper, or an internal document. Even if you’re doing actual primary research, such a survey or interviews,…

The unwritten rules of collaborative courtesy
|

The unwritten rules of collaborative courtesy

Collaboration on writing is hard enough. It can work only when there is a shared understanding of process and assumptions. Some rules and conventions regarding writing collaboration seem obvious to me — so obvious that I never mention them, because an experienced writer would find it insulting. Then a perfectly well-meaning collaborator will break such…

Don’t let version confusion destroy your writing process
| |

Don’t let version confusion destroy your writing process

The most fundamental principle in writing is actually . . . version control? It’s an unwritten rule. Like changing your underwear every day. And if you violate it, you are a barbarian. This is the least sexy writing advice ever. But if you and your collaborators don’t share a common understanding of version control, you’re…

Writing a book with Google Docs, Google Sheets, and Google Drive

Writing a book with Google Docs, Google Sheets, and Google Drive

I’ve been working on a collaborative book project with two other authors. On this project, I’m the principal writer; they are my clients. Here are a few things I learned about the superiority of Google Docs and Google Sheets for collaborative authoring. Using Google Drive for shared access to research My collaborators and I work…

Writing for them, us, or me: The challenges of contract, collaborative, and self-directed writers.

Writing for them, us, or me: The challenges of contract, collaborative, and self-directed writers.

Versatile writers can end up writing for clients and bosses, for colleagues and collaborators, or just for themselves. Here’s what I’ve learned from writing in all these different modes: Writing for “them” The nonfiction pieces you write in business settings must satisfy somebody else: a boss, an editor, or a client. When writing for “them”:…

Collaborating on a book is a terrible idea. But if you must, be asymmetrical.
|

Collaborating on a book is a terrible idea. But if you must, be asymmetrical.

Writing a book is hard enough. Adding another person makes it twice as hard. Collaboration only makes sense if it’s asymmetrical — if you have complementary skills and different jobs. I’ve written three books with coauthors, edited a few more, and am currently ghostwriting parts of books with other authors. Coauthoring sounds like it’s going…

7 collaboration tools and tips that make book writing go smoothly
|

7 collaboration tools and tips that make book writing go smoothly

Collaborating on a book is hard. Deadlines make it harder. The key is to develop a disciplined process and stick with it. To help you get to the end without tears, I’ll share some battle-tested collaboration tools and tips that will keep you focused on content excellence, not process glitches. (You’ll see where the bear…