Creating Research Timelines in Excel

Although it certainly can be used otherwise, a progress tracking system like the one Paul Silvia suggests in his book How to Write a Lot seems to work best for writing that can be open ended: by following a regular writing schedule, projects can regularly and reliably come to completion. What happens, however, if one is working under a deadline (be it self-imposed or not) and, therefore, needs to develop a writing schedule backwards from this due date?

This spreadsheet is at least an elementary attempt to provide a tool for performing such a task. Yet, one obvious limitation of this spreadsheet method is that all the writing projects are arranged serially along the completion timeline rather than allowing for working on more than one project at once.

If anyone else should find this tool useful and has refinement suggestions, I would be very interested in seeing them. These formulae appear to work on Google Docs exactly as they do on Excel when that program is operated on a Windows platform, but to my understanding, Excel calculates dates differently on Mac OS than it does on Windows, so Mac users may need to adjust this spreadsheet’s formulae.

Disclaimer: The views expressed on this site are my own and do not necessarily reflect those of any other person(s) or institution(s).

Disclosure of Material Connection: Some of the links in the content above may be “affiliate links.” I only recommend products or services I genuinely believe will add value to you as a reader. But if you click one of these links and purchase the item, I will receive an affiliate commission from the seller at no additional cost to you. Consequently, I am disclosing this affiliate status in accordance with the Federal Trade Commission’s 16 CFR, Part 255: “Guides Concerning the Use of Endorsements and Testimonials in Advertising.”

Join the Conversation

3 Comments

  1. Is this the newfangled equivalent of creating all those detailed revision timetables with colourcoded blocks, that took so long to complete you were already behind schedule by the time the thing was ready?

    1. Hi, Ros. Thanks for stopping by. I’m not sure how newfangled this simplified spreadsheet version is, but yes, this spreadsheet looks like it will provide almost all the information that I personally would want from a more intensive project management system without the disadvantage of having to spend a significant amount of time managing the management system. The formulae took a couple tries to get completely straight, but from here on, the rest should simply be copy-and-paste.

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.