Spreadsheet: 674187d1587707614-calculating-values-depending-on-variable-suppliers-new-daily-costings-sample-beamer-2-
Sheet: WC Jan 5

2019-10-27 00:00:00 |  | Weekend | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
 |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Work Activity
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1 | Supplier 1 | 6 | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | Product 8-11 shouldn’t be multiplied by hours
2 | Supplier 1 | 6 | 1 |  |  |  |  |  |  | 1
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Weekend | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
 |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Work Activity
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Day | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Night | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Day | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Night | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Day | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Night | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Day | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Night | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Day | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Weekend | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Weekend | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total
 |  | Weekend | Personnel |  |  |  |  |  |  | Equipment |  |  |  | Staff
Times |  |  | Resources |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
Crew | Supplier | Hours | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Total Staff | Team Requesting Booking | Cost Code
1
2
3
4
5
6
7
8
9
10
 |  | Total Per Shift |  |  |  |  |  |  |  |  |  |  |  |  | Shift Total
 |  | Sub Total
 |  | Shift Total