Event Production Schedule Template - Free Download
Please vote for this template if it helps you.
Production Schedule Excel Template
TrainingAble provides Production Based Excel Template sample, you can edit it according to film production or master production. We craete another file, which represent TrainingAble provides Production Based Excel Template sample, you can edit it according to film production or master production. We craete another file, which represent Gantt Chart file.
Row Activity Dur. Secs Dep 1 Dep 2 Push Start
6 wake up 30 0 0 0
7
walk to kitchen
15 6 30 0 30
8 fill kettle 20 7 45 0 45
9 boil water 180 8 65 0 65
10
put bread in toaster
20 8 65 0 65
11 toast bread 150 10 85 0 85
12
walk to bathroom
15 10 85 0 85
13
turn on bath taps
10 12 100 0 100
14 fill bath 180 13 110 0 110
15 brush teeth 60 12 100 0 100
16 shave 80 15 160 0 160
17
remove night clothes
10 16 240 0 240
18
get into bath
5 17 14 250 290 290
19 wash body 90 18 295 0 295
20
shampoo hair
40 19 385 0 385
21 get dried 30 20 425 0 425
22
put on underwear
10 21 455 0 455
23
put on shirt and trousers
30 22 465 0 465
24 put on tie 30 23 495 0 495
25
walk to kitchen
15 23 495 0 495
26 lay table 60 24 25 525 510 525
27 make tea 90 26 9 585 245 585
28
60 27 11 675 235 675
29
eat breakfast
300 27 28 675 735 735
=MATCH(A29,D\$1:D\$40,FALSE)
- find the row on which the activity is first cited as a dependency, by looking down column D
=MATCH(A29,INDIRECT("D"&J29+1&":D40"),FALSE)+J29
- find the second citing by looking down the column below the first
=MATCH(A29,E\$1:E\$40,FALSE)
- find the row on which the activity is first cited as a second dependency, by looking down column E
=IF(ISERROR(J29),\$I\$29,INDIRECT("Q"&J29))
- the start of the first activity which is dependant on this one, if there isn't one, return the end of the project
=MIN(M29:O29)
- the stop is the earliest of the starts
=P29-C29
- the start of the activity is the stop minus the duration
=Q29-H29
- the Float is the difference between the Pull Start and the Push Start
TrainingABle
Dep. Stop
1
Dep. Stop
2
Event Production Schedule Template
Previous

1/114

Next