Excel Project Planning Spreadsheet Updated Version 3

This article builds on a previous post which covers Project Planning leveraging Microsoft Excel

Some users of the Microsoft Excel Project Planning Spreadsheet Template expressed trouble modifying the date ranges when customizing the template. To make this process a bit easier, I’ve updated the project planning template to automatically show the day of the week in cell H3 based on the date value entered in cell H2. So to be clear, the process of customizing this spreadsheet should begin with modifying the date value in cell H2. Once you’ve entered the first date you want to show in the gantt view in cell H2, simply click and drag to expand the dates horizontally in row 2.

Once you’ve edited the date ranges for the gantt view, you can move over to the task list and begin entering the tasks in your work breakdown and the associated dates for each task.

The spreadsheet will automatically block out weekends and display the gantt bars according to the length of the tasks you enter. The gantt bars will automatically change color based on the progress you enter in column F from 0 to 100%. If progress is less than 50% and the current date has passed the projected end date for a task, the gantt bar will change to RED. Once the task is complete, the gantt bar will change to GREEN.

Here’s a link to download the updated project planning template:
Excel Project Plan v3 (7931)

Using this spreadsheet is fairly easy and straight-forward but if you have suggestions that may improve usability, please leave a comment below.

About

Michael solves problems related to technology and business. Also, he types things into computers.

4 Comments

  1. Philipp

    Hi Mike,

    thanks a lot for the great tool, it is a big help for my work.

    I have two questions for which I didn’t find a solution, I hope you have time to answer them.

    a) The weekends are blocked at the moment, is there a way to change that?
    b) I want to use different colors for the gantt bars (don’t use the progress column and the green/red status signal) –> Is there a simple way to change the bar colors according to my needs (e. g. green for project stream xy, black for project stream xyz etc. )?

    Thanks a a lot

    Philipp

  2. Charles

    Great tool. I love, I have 2 questions and I hope you can answer them for me.
    1) I have modify the range to monthly instead of weekly but I have 2 month that are shade as if they are week end. How can I fix that?
    2) Can I customoze the display color to make it specific to my project?

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>