Spreadsheet: 63699d1264583638-sumif-with-multiple-criteria-production2009
Sheet: Site Machine Listing

 | NOTE if you have a new machine to enter "insert" a row between the yellow cells do not just add it to the start or end
 | BLANK |  |  |  | BLANK
 | CR004 | 146414 |  |  | LOCAL MALAYSIA
 | CR014 | 196080 |  |  | OMAGH
 | J50-D1712 | 787284 |  |  | MPS AUS
 | TC1300 | 420356 |  |  | [NAME]
 | WJ42-AS808 | 272084
 | STATIC TC1000(EMEA) | 328727
 | STATIC TC1000(AMERICA) | 341791
 | TC1000 | 281300
 | LAB JAW J12 | 52782
 | 2820 | 391075
 | 3616 | 90603
 | 3820 | 286532
 | LAB [NAME] | 30841
 | WJ42-AS807 | 286532
 | G30 | 399890
 | [NAME] | 331990
 | IPF 100X400X300
 | WJ40-AS810 | 207516
 | NOTE if you have a new machine to enter "insert" a row between the yellow cells do not just add it to the start or end
 |  |  |  |  |  |  |  |  |  |  |  |  |  | OK [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WIP
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PROBLEM
 | Last Updated
 | 2010-01-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production Status
 | Brand | Line | Site |  | scheduled week | Customer Promise Date | INVOICE MONTH CBE | STD SPP PRICE(RM) |  | Orgional scheduled week as per S&OP | Orgional invoice month as per S&OP |  | Model | [NAME] | Customer | Serial # | Country | TMS Star  Number Item | Works Order | Slotted Flag | Production  Line | Work Order  Status | Cut | Fab. | Sub. | F/A | Completion / QC Sign-out  Date | On Time ?  Yes / No
 | JAN FIXED BUILD SCHEDULE
1 | T | Crusher | MAL |  | 2010/1 |  | JAN | 196080 |  |  |  |  | CR014 |  | OMAGH |  |  |  | 647349 |  |  |  |  |  |  | 2010/2 | 2010/2 | NO
2 | T | Crusher | MAL |  | 2010/1 |  | JAN | 787284 |  |  |  |  | J50-D1712 |  | MPS AUS |  |  |  | 647352 |  |  |  |  |  |  | 2010/1 | 2010/1 | YES
3 | T | Crusher | MAL |  | 2010/1 |  | JAN | 420356 |  |  |  |  | TC1300 |  | OMAGH |  |  |  | 647370 |  |  |  |  |  |  | 2010/4 | 2010/4 | NO
4 | T | Crusher | MAL |  | 2010/1 | 2009-12-04 23:59:00 | JAN | 272084 |  |  |  |  | WJ42-AS808 |  | OMAGH |  |  | C-10001 | 647345 | NULL | NULL |  | #N/A | #N/A | #N/A | 2010 / 2 | 2010 / 2 | NO
5 | T | Crusher | MAL |  | 2010/2 |  | JAN | 196080 |  |  |  |  | CR014 |  | OMAGH |  |  |  | 647350 |  |  |  |  |  |  | 2010/3 | 2010/3 | NO
6 | T | Crusher | MAL |  | MOVE TO FEB |  | FEB | 196080 |  | 2010/2 | JAN |  | CR014 |  | OMAGH |  |  |  | 647351
7 | T | Crusher | MAL |  | 2010/2 |  | JAN | 787284 |  |  |  |  | J50-D1712 |  | MPS AUS |  |  |  | 647353 |  |  |  |  |  |  | 2010/2 | 2010/2 | YES
8 | T | Crusher | MAL |  | 2010/2 |  | JAN | 341791 |  | 2009/52 | DEC |  | STATIC TC1000(AMERICA) |  | [NAME] |  |  |  | 647372 |  |  |  |  |  |  | 2010/2 | 2010/2 | NO
9 | T | Crusher | MAL |  | 2010/2 |  | JAN | 341791 |  | 2009/52 | DEC |  | STATIC TC1000(AMERICA) |  | [NAME] |  |  |  | 647373 |  |  |  |  |  |  | 2010/2 | 2010/2 | NO
10 | T | Crusher | MAL |  | 2010/2 |  | JAN | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647364 |  |  |  |  |  |  | 2010/2 | 2010/2 | YES
11 | T | Crusher | MAL |  | 2010/2 |  | JAN | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647365 |  |  |  |  |  |  | 2010/2 | 2010/2 | YES
12 | T | Crusher | MAL |  | 2010/2 |  | JAN | 272084 |  |  |  |  | WJ42-AS808 |  | OMAGH |  |  |  | 647346 |  |  |  |  |  |  | 2010 / 2 | 2010 / 2 | YES
13 | T | Crusher | MAL |  | 2010/3 |  | JAN | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647366 |  |  |  |  |  |  | 2010/3 | 2010/3 | YES
14 | T | Crusher | MAL |  | 2010/3 |  | JAN | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647367 |  |  |  |  |  |  | 2010/3 | 2010/3 | YES
15 | T | Crusher | MAL |  | 2010/3 |  | JAN | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647374 |  |  |  |  |  |  | 2010/3 | 2010/3 | YES
16 | T | Crusher | MAL |  | 2010/3 |  | JAN | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647375 |  |  |  |  |  |  | 2010/3 | 2010/3 | YES
17 | T | Crusher | MAL |  | 2010/3 |  | JAN | 420356 |  |  |  |  | TC1300 |  | OMAGH |  |  |  | 647371 |  |  |  |  |  |  | 2010/4 | 2010/4 | NO
18 | T | Crusher | MAL |  | 2010/3 |  | JAN | 272084 |  |  |  |  | WJ42-AS808 |  | OMAGH |  |  |  | 647347 |  |  |  |  |  |  | 2010 / 3 | 2010 / 3 | YES
19 | T | Crusher | MAL |  | 2010/4 |  | JAN | 52782 |  |  |  |  | LAB JAW J12 |  | LOCAL MALAYSIA |  |  |  | 647389 |  |  |  |  |  |  | 2010 /4 | 2010 /4 | YES
20 | T | Crusher | MAL |  | 2010/4 |  | JAN | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647368 |  |  |  |  |  |  | 2010 / 4 | 2010 / 4 | YES
21 | T | Crusher | MAL |  | 2010/4 |  | JAN | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647369 |  |  |  |  |  |  | 2010 /4 | 2010 /4 | YES
22 | T | Crusher | MAL |  | 2010/4 |  | FEB | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647376 |  |  |  |  |  |  | 2010 / 4 | 2010 / 4 | YES
23 | T | Screen | MAL |  | 2010/5 |  | FEB | 391075 |  |  |  |  | 2820 |  | LOCAL MALAYSIA |  |  |  | 647285
24 | T | Crusher | MAL |  | 2010/5 |  | FEB | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647377
25 | T | Crusher | MAL |  | 2010/5 |  | FEB | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647378
26 | T | Crusher | MAL |  | 2010/5 |  | FEB | 281300 |  |  |  |  | TC1000 |  | OMAGH |  |  |  | 647442
27 | T | Crusher | MAL |  | 2010/5 |  | JAN | 272084 |  |  |  |  | WJ42-AS808 |  | OMAGH |  |  |  | 647354 |  |  |  |  |  |  | 2010 / 5 | 2010 / 5 | YES