Please login or join to subscribe to this thread
Google it. You will find. Moreover, you can make yours. It is not complicated. Do not forget to check the Template section of the website as well.
Unfortunately you are now in the realm of true CPM-based scheduling so any Excel template which is able to do this would likely have a ton of VB code in the background doing all the calculations based on start dates, dependencies and so on.
There are open source (with limited functionality) CPM scheduling tools out there - would those be a possibility for your company?
You can do it in Excel. While the technique is simple, Excel can drive you crazy when you try to edit or debug lots of linked formulas so just getting someone else's template can be more confusing than creating your own.
To refine your search, you might google how to create a PERT chart and how to calculate critical path in Excel.
ProjectLibre (desktop version) is free. It reminds me of a lite version of MS Project desktop client, if there were such a thing.
I haven't used any of these, but there is a review of a few of the more popular ones here: https://opensource.com/article/21/3/open-s...ject-management
I'll take a look at the open source stuff..thanks for the info.
In the meantime I've been working on one in Excel. I need to get with our Contracting office to get some realistic durations; however, I'd appreciate your thoughts on it. I use the Workday function to account for weekends and holidays. I still need to work on the Actual Start and Actual Finish columns. I want to have similar functions in there and the PM can update the dates and the forumulas below it get automatically updated to reflect the new Award date. Anyhoo...if you're interested, I place it in my Google Drive folder at the link below. I appreciate any comments you have.
Please login or join to reply