Forum Discussion
Excel - Project Tracking Chart
dbowman2110A week by week tracking would pose problem since all projects may not require the same number of weeks. Standard project days is also a variable which will depend on the complexity of the project you are doing. So, I would suggest a table based progress or amount settled.
Something like the attached document could help. The white cells are for your manual entry, while the greyed ones are calculated values.
If you are using this method, then you need to define what would happen when project timeline is crossed.
- NikolinoDEJan 02, 2022Platinum Contributor
This was just an example that I sent you in the file.
An example to get an approach on how to do it.
Commissioned work, so to do the whole thing I don't do it.
Here you can get help to help yourself, you would have to do the project yourself.
In this link that I sent you before you will find several examples that might fit your project better.
Furthermore, I wish you much success with Excel in your project.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
- dbowman2110Jan 03, 2022Copper Contributor
NikolinoDE NowshadAhmed - Thank you Both! I truly appreciate the help. I will take a look at both of these, as I'm sure they will benefit me in this task!