In Project Management, we essentially manage Time, control Cost without compromising Quality of the work. In today’s blog entry I present a worksheet which I made recently to manage time and cost of a Project.
Below you see the snapshot of Summary of the Report. The first two columns tells you about the number and name of ongoing Projects. Next 5 columns tells you about the financial status of the Project. Like Budget Amount vs Budget Consumed etc. The remaining columns tells you the status the different activities whether they are completed, ongoing or not yet started.
However the activity status columns do not give us the detailed picture, the management may need. For that we need to refer next Project worksheets.
Below you see the snapshot of Project worksheet. For different activities Planned vs Actual dates are given. Based on dates the excel Gantt chart gets mapped, blue for planned and orange for actual. The dates are on weekly basis, can be put on daily basis. Filters are provided to view only planned or actual activities. % Done column is provided for the Manager to fill the % activity completed as on date.
I have used conditional formatting for making the excel Gantt chart. The dates and values assumed are approx. User need to correct it as per his/her need. Hope you find it useful. Link to file:-
Other related entry :-
Recently the contest entries of chandoo.org KPI performance charts & dashboards were published, the winner are yet to be announced. Many of the entries are amazing and great to learn from. I also participated in the contest and will discuss my entry today. The details of contest and other entries can be seen on the website. The contest was about showing variance analysis of KPI data from bank. I made an interactive chart in which the KPI could be selected from the dropdown.
The data in base, corresp, target shows variance only w.r.t to current. Green and pink bars show positive and negative variance respectively.
link to the file: https://drive.google.com/file/d/0B2FLZ9YjqpJTNnNGWWFTemd0RTg/view?usp=sharing
About one and a half month back Chandoo.org opened Excel Datavis Contest – 2014
The results are delayed but going to be out in about 2 weeks time. I present you my entry for the contest
The data given was US states to states migration over a period of three years and we were required to make a dashboard based on data. More details can found on the website.
I used features like data validation, bar chart, roll over macro, formulas like index, match, large etc
the US map is inserted with page layout -> page set up -> background
a screenshot of my dashboard is shown below
move your mouse over the state name and the data gets updated for the year selected
the link to file: