Tasks

Compl ete In Progres s Not Started Overdue (empty) Status Compl ete In P

(empty); 8.33%
Bozo the Clown 3
Overdue; 8.33%

(empty)
Complete; 41.67%

Stacy Wi l l i ams 1

Not Started; 33.33%

Jenny Smi th 1 1

In Progress; 8.33% Everyone 1

310
200
e st ns s to
r s t
m Li i re Li
tT
i t to rH na t
PA
R
n es i ta di es
Ev
e Gu In
v he or Gu
e te te ot Co in
s ea ea i ze nt ck
oo Cr Cr al Ev
e
Lo
Ch Fi
n re
Hi
Workload Task Lengths
Status Compl ete In Progres s Not Started Overdue (empty)

3 1
25

18

1 3 1

11

1 1
7
6
4
1
0
1
0

Cost
Sum - Actual Cost

290 280
t ! ls s 8 y)
Li
s Y i Gi
f
m ns er
s
pt
t RT ta I te to d
es PA D e
t on d i ta in ( em
Gu en
t ta i re In
v
Re
m
in Ev vi qu
In nd nd
a n
se Re Se Se
Pl a e
rch as
Pu rch
Pu
Task Lengths

Create Guest Li st
Create Invi tatons
Fi nal i ze other Hi res
Hi re Event Coordi nator
18 Lock i n Guest Li st
PARTY!
Pl an Event Deta il s
Purcha s e Invi taton Gi f
Purcha s e Requi red Items

7
6

0
0

1088

s y) t
er pt ul
in
d
em es
m ( lR
ta
To
Project Name <in
Not Started
Current Task Statuses
36%

Budget
Planned
$ 1,078.26

Tasks Assigned To Start

Choose Event Time Stacy Williams 2/1

Create Guest List Bozo the Clown 2/2
Create Invitatons Stacy Williams 2/3
Purchase Invitaton Gif Jenny Smith 2/4
Send Invitatons Stacy Williams 2/11
Hire Event Coordinator Bozo the Clown 2/3
Plan Event Details Bozo the Clown 2/3
Purchase Required Items Jenny Smith 2/21
Lock in Guest List Stacy Williams 3/1
Finalize other Hires Bozo the Clown 2/3
Send Reminders Stacy Williams 3/7
PARTY! Everyone
<insert project name here>
In Progress Complete Overdue
#DIV/0! #DIV/0! #DIV/0!

$ (9.74)
Actual
$ 1,088.00

End Days Status Planned Cost Actual Cost

2/1 0 Complete
2/3 1 Complete
2/7 4 Overdue $ 10.00
2/10 6 Complete $ 250.26 $ 290.00
2/14 3 Not Started $ 10.00 $ 8.00
2/14 11 Complete $ 250.00 $ 200.00
2/21 18 In Progress
2/28 7 Not started $ 258.00 $ 280.00
3/1 0 Not started
2/28 25 Complete $ 300.00 $ 310.00
3/10 3 Not started
Notes
How to use this template:
ProjectManager.com has created this Excel template to help you generate easy reports with simple-to-update task li
budget tracker, workload view and progress tracker in one!

Simply click into the cells you'd like to change to update the data, and the formulas take care of the rest.

Be sure to click the "Update Reports" button on the Reportng tab to re-populate the reports with the changes you'v

Finally, you should make sure you have "macros enabled" so that the formulas can work properly.

You can find more templates in our Resources secton online.

And, of course, if you can update this Excel template, you can manage projects online, too!

Click here to start your free trial at ProjectManager.com:

mple-to-update task lists,

of the rest.

with the changes you've made.