Update to Weekly Gantt Excel Spreadsheet

Update to Weekly Gantt Excel Spreadsheet

I was putting together a development plan and bid for a new project, and found myself using my Gantt Chart Spreadsheet, weekly version to visualize how the project might take. That’s when I discovered that I hadn’t set it up for an arbitrary starting date.

So I fixed it.

Gantt Weekly Update The new weekly version is available to download as version 5, over on the Gantt Excel page. This is merely useful for generating a kind of “gantt graph paper”; it’s not a full-blown project management tool with auto-allocation and calculation of time. It’s good for outlining and quick estimating, though.

As a bonus, the new weekly version can be cut and paste into other spreadsheets (which I needed to do) and it still works. Select the range A1:F17 in your cell copy, and paste into your own worksheet. To extend the range of days, select the last two columns and stretch ’em to use ordinary Excel range extrapolation. If this doesn’t make sense, watch the video on the Excel Gantt page and this may help.

4 Comments

  1. Boyd 8 years ago

    Hey David, on the Gantt Excel page, I’m getting a 404 -Not Found when clicking on the version 5 .zip download link.

  2. Author
    Dave Seah 8 years ago

    Doh! Fixed. Sorry for the inconvenience!

  3. Debbie Karnes 3 years ago

    Dave

    Found your sample sheet, thanks. However, I want to show the calendar crossing over 2 years. Specifically, there’s a process that starts in April 2016 and ends April 2017. It’s not displaying the ‘year’, although the date formula indicates a mo/day/year. So, I inserted a column at the end of the 2016 year to indicate the beginning of 2017–inserting the column after December and before January), but this threw off the week titles and now I get an error message that I cannot fix. Did inserting the 2016 and 2017 columns cause that? How to fix?

    • Author
      Dave Seah 3 years ago

      Hi Debbie!

      I’m not exactly sure what you did, but you might have inserted a column rather than extending the range. Have you seen this video on using the spreadsheet? Here’s the link: https://www.youtube.com/watch?v=ZsOctyy-g6I

      If you jump to about 2:30 in, it shows how I extend the range using Excel’s features.