Spreadsheet: 142576d1329918446-linking-filters-from-pivot-table-build-plan-copy
Sheet: Data Entry

Product | Date | Week Number | Month | Year | Capacity | Demand | C Demand | Total C Demand | +/-
UH | 2012-01-02 00:00:00 |  |  |  | 0
CH | 2012-01-02 00:00:00 |  |  |  | 568 | 568
SR | 2012-01-02 00:00:00
SR_ | 2012-01-02 00:00:00
AE | 2012-01-02 00:00:00
CX | 2012-01-02 00:00:00
CR | 2012-01-02 00:00:00
Other | 2012-01-02 00:00:00
UH | 2012-01-03 00:00:00 |  |  |  | 468 | 468
CH | 2012-01-03 00:00:00 |  |  |  | 596 | 596
SR | 2012-01-03 00:00:00
SR_ | 2012-01-03 00:00:00 |  |  |  | 156 | 156
AE | 2012-01-03 00:00:00 |  |  |  | 407 | 407
CX | 2012-01-03 00:00:00
CR | 2012-01-03 00:00:00
Other | 2012-01-03 00:00:00
UH | 2012-01-04 00:00:00 |  |  |  | 467 | 467
CH | 2012-01-04 00:00:00 |  |  |  | 714 | 714
SR | 2012-01-04 00:00:00 |  |  |  | 189 | 1 | 188
SR_ | 2012-01-04 00:00:00 |  |  |  | 180 | 180
AE | 2012-01-04 00:00:00 |  |  |  | 215 | 215
CX | 2012-01-04 00:00:00
CR | 2012-01-04 00:00:00
Other | 2012-01-04 00:00:00
UH | 2012-01-05 00:00:00 |  |  |  | 508 | 508
CH | 2012-01-05 00:00:00
SR | 2012-01-05 00:00:00 |  |  |  | 225 | 2 | 223
SR_ | 2012-01-05 00:00:00 |  |  |  | 231 | 231
AE | 2012-01-05 00:00:00 |  |  |  | 171 | 171
CX | 2012-01-05 00:00:00
CR | 2012-01-05 00:00:00
Other | 2012-01-05 00:00:00
UH |  |  |  |  | 471 | 471
CH |  |  |  |  | 541 | 541
SR |  |  |  |  | 38 |  | 38
SR_ |  |  |  |  | 180 | 180
AE |  |  |  |  | 91 | 91
CX
CR
Other
UH |  |  |  |  | 468 | 468
CH |  |  |  |  | 614 | 614
SR |  |  |  |  | 70 | 70
SR_ |  |  |  |  | 209 | 209
AE |  |  |  |  | 25 | 25
CX
CR
Other
UH |  |  |  |  | 369 | 369
CH |  |  |  |  | 593 | 593
SR |  |  |  |  | 109 | 11 | 98
SR_ |  |  |  |  | 202 | 202
AE |  |  |  |  | 30 | 30
CX
CR
Other
UH |  |  |  |  | 377 | 377
CH |  |  |  |  | 601 | 601
SR |  |  |  |  | 88 | 1 | 87
SR_ |  |  |  |  | 206 | 206
AE |  |  |  |  | 20 | 20
CX
CR
Other
UH |  |  |  |  | 459 | 459
CH |  |  |  |  | 598 | 598
SR |  |  |  |  | 114 | 114
SR_ |  |  |  |  | 213 | 213
AE |  |  |  |  | 9 | 9
CX
CR
Other
UH |  |  |  |  | 443 | 443
CH |  |  |  |  | 672 | 672
SR |  |  |  |  | 81 | 18 | 63
SR_ |  |  |  |  | 209 | 209
AE |  |  |  |  | 33 | 33
CX
CR
Other
UH |  |  |  |  | 397 | 397
CH |  |  |  |  | 585 | 585
SR |  |  |  |  | 149 | 54 | 95
SR_ |  |  |  |  | 199 | 199
AE |  |  |  |  | 78 | 78
CX
CR
Other
UH |  |  |  |  | 388 | 388
CH |  |  |  |  | 689 | 689
SR |  |  |  |  | 152 | 152
SR_ |  |  |  |  | 181 | 181
AE |  |  |  |  | 25 | 25
CX
CR
Other
UH |  |  |  |  | 423 | 423
CH |  |  |  |  | 596 | 596
SR |  |  |  |  | 121 | 118 | 3
SR_ |  |  |  |  | 210 | 210
AE |  |  |  |  | 21 | 21
CX
CR
Other
UH |  |  |  |  | 439 | 439
CH |  |  |  |  | 618 | 618
SR |  |  |  |  | 139 | 139
SR_ |  |  |  |  | 188 | 188
AE |  |  |  |  | 94 | 94
CX
CR
Other
UH |  |  |  |  | 283 | 283
CH |  |  |  |  | 730 | 730
SR |  |  |  |  | 154 | 62 | 92
SR_ |  |  |  |  | 108 | 108
AE |  |  |  |  | 800 | 800
CX
CR
Other
UH |  |  |  |  | 330 | 330
CH |  |  |  |  | 1000 | 1000
SR |  |  |  |  | 115 | 13 | 102
SR_ |  |  |  |  | 111 | 111
AE |  |  |  |  | 36 | 36
CX
CR
Other
UH |  |  |  |  | 443 | 443
CH |  |  |  |  | 686 | 686
SR |  |  |  |  | 206 | 46 | 160
SR_ |  |  |  |  | 121 | 121
AE |  |  |  |  | 72 | 72
CX
CR
Other
UH |  |  |  |  | 284 | 284
CH |  |  |  |  | 679 | 679
SR |  |  |  |  | 144 | 135 | 9
SR_ |  |  |  |  | 148 | 148
AE |  |  |  |  | 400 | 400
CX
CR
Other
UH |  |  |  |  | 169 | 169
CH |  |  |  |  | 795 | 795
SR |  |  |  |  | 93 | 93
SR_ |  |  |  |  | 155 | 155
AE |  |  |  |  | 98 | 98
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 224 | 224
CH |  |  |  |  | 670 | 670
SR |  |  |  |  | 142 | 142
SR_ |  |  |  |  | 148 | 148
AE |  |  |  |  | 72 | 72
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 266 | 266
CH |  |  |  |  | 802 | 802
SR |  |  |  |  | 144 | 82 | 62
SR_ |  |  |  |  | 62 | 62
AE |  |  |  |  | 123 | 123
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 230 | 230
CH |  |  |  |  | 797 | 797
SR |  |  |  |  | 159 | 4 | 155
SR_ |  |  |  |  | 109 | 109
AE |  |  |  |  | 109 | 109
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 122 | 122
CH |  |  |  |  | 712 | 712
SR |  |  |  |  | 149 | 40 | 109
SR_ |  |  |  |  | 26 | 26
AE |  |  |  |  | 132 | 132
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 80 | 80
CH |  |  |  |  | 580 | 580
SR |  |  |  |  | 200 | 160 | 40
SR_ |  |  |  |  | 186 | 186
AE |  |  |  |  | 88 | 88
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 163 | 163
CH |  |  |  |  | 762 | 762
SR |  |  |  |  | 206 | 146 | 60
SR_ |  |  |  |  | 163 | 163
AE |  |  |  |  | 103 | 103
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 138 | 138
CH |  |  |  |  | 679 | 679
SR |  |  |  |  | 200 | 180
SR_ |  |  |  |  | 143 | 143
AE |  |  |  |  | 566 | 566
CX
CR |  |  |  |  | 5 | 6
Other
UH |  |  |  |  | 84 | 84
CH |  |  |  |  | 829 | 829
SR |  |  |  |  | 36 | 10 | 26
SR_ |  |  |  |  | 111 | 111
AE |  |  |  |  | 235 | 235
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 111 | 111
CH |  |  |  |  | 842 | 842
SR |  |  |  |  | 145 | 72 | 73
SR_ |  |  |  |  | 200 | 200
AE |  |  |  |  | 223 | 223
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 171 | 171
CH |  |  |  |  | 750 | 750
SR |  |  |  |  | 222 | 31 | 191
SR_ |  |  |  |  | 263 | 263
AE |  |  |  |  | 174 | 174
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 176 | 176
CH |  |  |  |  | 643 | 643
SR |  |  |  |  | 76 |  | 76
SR_ |  |  |  |  | 135 | 135
AE |  |  |  |  | 167 | 167
CX
CR |  |  |  |  | 5 | 17
Other
UH |  |  |  |  | 400 | 40
CH |  |  |  |  | 800 | 51
SR |  |  |  |  | 200 | 825
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5 | 2
Other
UH |  |  |  |  | 400 | 418
CH |  |  |  |  | 800
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200 | 72
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 210
CH |  |  |  |  | 800 | 330
SR |  |  |  |  | 200 | 133
SR_ |  |  |  |  | 200 | 250
AE |  |  |  |  | 200 | 222
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 111
CH |  |  |  |  | 800 | 3523
SR |  |  |  |  | 200 | 46 | 8
SR_ |  |  |  |  | 200 | 426
AE |  |  |  |  | 200 | 168
CX
CR |  |  |  |  | 5 | 1
Other
UH |  |  |  |  | 400 | 90
CH |  |  |  |  | 800 | 255
SR |  |  |  |  | 200 |  | 50
SR_ |  |  |  |  | 200 | 74
AE |  |  |  |  | 200 | 92
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 67
CH |  |  |  |  | 800 | 266
SR |  |  |  |  | 200 | 36 | 56
SR_ |  |  |  |  | 200 | 32
AE |  |  |  |  | 200 | 78
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 50
CH |  |  |  |  | 800 | 335
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200 | 94
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 20
CH |  |  |  |  | 800 | 975
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200 | 40
AE |  |  |  |  | 200 | 294
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 5
CH |  |  |  |  | 800 | 292
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200 | 1
AE |  |  |  |  | 200 | 265
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800 | 1692
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200 | 480
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 203
CH |  |  |  |  | 800 | 459
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200 | 228
AE |  |  |  |  | 200 | 170
CX
CR |  |  |  |  | 5 | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800 | 256
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200 | 50
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800 | 5
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800 | 348
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200 | 21
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800 | 140
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200 | 93
AE |  |  |  |  | 200 | 93
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 50
CH |  |  |  |  | 800 | 16
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400 | 60
CH |  |  |  |  | 800
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800 | 883
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200 | 31
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH |  |  |  |  | 400
CH |  |  |  |  | 800 | 10
SR |  |  |  |  | 200
SR_ |  |  |  |  | 200
AE |  |  |  |  | 200
CX
CR |  |  |  |  | 5
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH |  |  |  |  | 800
SR
SR_
AE |  |  |  |  | 200
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other
UH
CH
SR
SR_
AE
CX
CR
Other