Spreadsheet: 101768d1299807504-countifs-fail-twt-original
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T- 1410
 |  |  |  | Previous Week |  |  |  |  |  |  | 2011-02-27 00:00:00 | (Total Adjacency Calendar: 389.6)
 |  |  |  | Current Week |  |  |  |  |  |  | 2011-03-06 00:00:00 | (Total Adjacency Calendar: 418.9)
Completion Statistics: |  |  |  |  | POG # | [NAME] | Dept | POG Type | Tie | Fill
Planograms: | 54 of 59 |  |  | Assigned Set Date
Revisions: | 69 of 77
Sales Planners: | 9 of 11 |  |  | 2011-03-09 00:00:00 | [NAME] | TEEN 2:03/06/11:DB | 52 | POG | √ | X
 |  |  |  | 2011-03-09 00:00:00 | A052HMV | COTTON 1:03/06/11:HV | 52 | POG | X | X
My Plan Statistics: |  |  |  | 2011-03-08 00:00:00 | A052HHX | RIMMEL:03/06/11:DB | 52 | POG | √ | √
Adjacency Calendar Hours: | 418.9 |  |  | 2011-03-08 00:00:00 | A052HIE | SONIA:03/06/11:DB | 52 | POG | √ | X
Assigned Hours: | 247.5 |  |  | 2011-03-08 00:00:00 | A052HJ6 | L'OREAL:03/06/11:DB:HS | 52 | POG | √ | X
Percent of Hours Used: | 0.59 |  |  | 2011-03-08 00:00:00 | A052HLZ | [NAME]:DB:HS | 52 | POG | √ | √
 |  |  |  | 2011-03-08 00:00:00 | A052H9Z | [NAME]:DB:CA:HV ... | 52 | POG | √ | X
 |  |  |  | 2011-03-07 00:00:00 | A052HCG | PHYSICIANS FORMULA:03/06/11:DB | 52 | POG | √ | X
 |  |  |  | 2011-03-07 00:00:00 | A052HC2 | COVER GIRL:03/06/11:DB:HS:HV | 52 | POG | √ | X
 |  |  |  | 2011-03-07 00:00:00 | A052HJN | REVLON:03/06/11:DB:HS | 52 | POG | √ | √
 |  |  |  | 2011-03-07 00:00:00 | A052HNT | INDIE #1 (JEMMA):03/06/11:DB | 52 | POG | √ | X
 |  |  |  | 2011-03-07 00:00:00 | A052HN9 | INDIE #2 (PIXI):03/06/11:DB | 52 | POG | √ | √
 |  |  |  | 2011-03-07 00:00:00 | A052HPN | INDIE #3 (NAPOLEON):03/06/1... | 52 | POG | √ | √
 |  |  |  | 2011-03-06 00:00:00 | [NAME] | PEST (03/06/11): SOUTHWEST | 3 | POG | √ | √
 |  |  |  | 2011-03-06 00:00:00 | A052HBM | ALMAY:03/06/11:DB | 52 | POG | √ | X
 |  |  |  | 2011-03-06 00:00:00 | A052HCA | NEUTROGENA:03/06/11:DB | 52 | POG | √ | X
 |  |  |  | 2011-03-06 00:00:00 | A052HH1 | TEEN 1:03/06/11:DB | 52 | POG | √ | X
 |  |  |  | 2011-03-06 00:00:00 | A052HMB | [NAME]DB | 52 | POG | √ | X
 |  |  |  | 2011-03-06 00:00:00 | A052HQ3 | MAYBELLINE:03/06/11:DB:HS:HV | 52 | POG | √ | X
 |  |  |  | 2011-03-03 00:00:00 | [NAME] | APPAREL WARM | 83 | POG | X | X
 |  |  |  | 2011-03-03 00:00:00 | A152EQC | 04B-D71 BKD/SNCHP 3/6-3/19 | 152 | MPG | √ | X
 |  |  |  | - | A003PF1 | AIRCARE (03/06/11) MCM | 3 | POG | √ | √
 |  |  |  | - | A012RIQ | LATIN REG MEX (60/72):10/10/10 | 12 | REV | √ | X
 |  |  |  | - | A012RI4 | ROCK & POP BROWSER (60/72) ... | 12 | REV | √ | X
 |  |  |  | - | A012RJ0 | R&B BROWSER (60/72):10/10/10 | 12 | REV | √ | X
 |  |  |  | - | A012RKD | COUNTRY BROWSER (60/72):10/... | 12 | REV | √ | X
 |  |  |  | - | A020ACQ | XHIL MOCCASIN 03/06/11 | 20 | POG | √ | √
 |  |  |  | - | A020ACR | N&N SLIDE 03/06/11 | 20 | POG | √ | √
 |  |  |  | - | A023I0Y | [NAME] PLUNGE MICRO... | 23 | REV | √ | √
 |  |  |  | - | A024GV4 | ENH 2 (MAPLE/ELM) MB MESSEN... | 24 | POG | √ | √
 |  |  |  | - | A040FKQ | VALUE SOCKS A (3+3=6) 3/6/1... | 40 | POG | √ | √
 |  |  |  | - | A040FK3 | VALUE SOCKS B (3+3=6) 3/6/1... | 40 | POG | √ | √
 |  |  |  | - | A040FL3 | EVOLVE 3/6/11 SMHV | 40 | POG | √ | √
 |  |  |  | - | A040FMB | NBUW 3/6/11 SMHV | 40 | POG | √ | √
 |  |  |  | - | A040FM2 | HANES PREMIUM 3/6/11 SMHV | 40 | POG | √ | √
 |  |  |  | - | A040FN5 | MERONA DRESS SOCK A (4+8=12... | 40 | POG | √ | √
 |  |  |  | - | A040FPK | MERONA DRESS SOCK B (4+8=12... | 40 | POG | √ | √
 |  |  |  | - | A040FQS | C9 SOCKS 3/6/10 VO 1-3 | 40 | POG | √ | √
 |  |  |  | - | A040FT5 | NB DRESS SOCK (3/6/11) SMH... | 40 | POG | √ | √
 |  |  |  | - | A040F3L | HANES SOCKS 3/6/11 VO 1-3... | 40 | POG | √ | X
 |  |  |  | - | A043BLS | SCREEN TEES (03.06.11) | 43 | POG | √ | √
 |  |  |  | - | A044DZL | MENS 1 3/6 (SCREEN PRINT VA... | 44 | POG | √ | √
 |  |  |  | - | [NAME] | WALLETS_3/6 | 44 | POG | √ | X
 |  |  |  | - | A044D1Q | PJS/SLIPPERS_3/6 | 44 | POG | √ | √
 |  |  |  | - | A044D4Q | HATS (3/6/11) SMHV | 44 | POG | √ | X
 |  |  |  | - | A044D4Z | EC1 (3/6/11) SMHV | 44 | POG | √ | X
 |  |  |  | - | A044D45 | EC2 (3/6/11) SMHV | 44 | POG | √ | X
 |  |  |  | - | A044D5E | EC3 (3/6/11) SMHV | 44 | POG | √ | X
 |  |  |  | - | A044D5J | EC4 (3/6/11) SMHV | 44 | POG | √ | X
 |  |  |  | - | A057EW5 | IPAD LAUNCH GUIDE 3/10/2011 | 57 | POG | X | X
 |  |  |  | - | A058JNH | BLU RAY COMEDY (60/72):HTS:... | 58 | REV | √ | √
 |  |  |  | - | A058JNR | BLU RAY DRAMA (60/72):HTS:0... | 58 | REV | √ | √
 |  |  |  | - | A058JNW | DVD CATALOG COMEDY:01/09/11 | 58 | REV | √ | √
 |  |  |  | - | A058JN8 | KIDS CATALOG 2:01/09/11 | 58 | REV | √ | √
 |  |  |  | - | A058JPR | KIDS CATALOG 1:01/09/11 | 58 | REV | √ | √
 |  |  |  | - | A058JPZ | BLU RAY KIDS (60/72):HTS:01... | 58 | REV | √ | √
 |  |  |  | - | A058JQC | DVD BOX SET CATALOG:01/09/11 | 58 | REV | √ | √
 |  |  |  | - | A059WNK | MIDDLE READER (60/72):10/10/10 | 59 | REV | √ | √
 |  |  |  | - | A059WQG | RECOMMENDED READING (60/72)... | 59 | REV | √ | √
 |  |  |  | - | A059WYA | TRADE NR:10/10/10 | 59 | REV | √ | √
 |  |  |  | - | A059WYG | SERIES ROMANCE:10/10/10:HS | 59 | REV | √ | √
 |  |  |  | - | A059WYJ | HC TRADE BS (60/72):10/10/10 | 59 | REV | √ | √
 |  |  |  | - | A059WYQ | HC NR:10/10/10 | 59 | REV | √ | √
 |  |  |  | - | A059W4Y | COLORING & ACTIVITY (60/72)... | 59 | POG | √ | √
 |  |  |  | - | A059W42 | KIDS BOOK (60/72):LATIN:02/... | 59 | POG | √ | √
 |  |  |  | - | A059W5M | KIDS BOOKS (60/72):02/27/11... | 59 | POG | √ | √
 |  |  |  | - | A059W5Z | KIDS READING ADVENTURE (60/... | 59 | POG | X | X
 |  |  |  | - | A064E8N | DOMESTIC TREND RUN BEACH 2.... | 64 | POG | X | X
 |  |  |  | - | A065DGF | DEC HOME ACCESSORIES 1 01/0... | 65 | REV | X | X
 |  |  |  | - | A07138Z | JERKY:OBERTO WEST | 71 | REV | X | X
 |  |  |  | - | A084HR6 | GARDEN DECOR 02/20/11 | 84 | REV | X | X
 |  |  |  | - | A086HLC | D86:BARBIE:01/02/11:A AFAM | 86 | REV | √ | √
 |  |  |  | - | A086HMA | D86:DISNEY:01/02/11:AFAM:SMHV | 86 | REV | √ | √
 |  |  |  | - | A086HM2 | D86:SMALL DOLLS 1/2 COMBO:0... | 86 | REV | √ | √
 |  |  |  | - | A086HPJ | D86:NOVELTY PLUSH:01/02/11:... | 86 | REV | √ | √
 |  |  |  | - | A086HRF | D86:LARGE DOLLS/PW:01/02/11... | 86 | REV | √ | √
 |  |  |  | - | A087GMB | D87:NERF:01/02/11:SMHV | 87 | REV | √ | √
 |  |  |  | - | A087GPT | D87:GAMES / PUZZLES:01/02/1... | 87 | REV | √ | √
 |  |  |  | - | A087GQG | D87:VEHICLES 1:01/02/11:SMHV | 87 | REV | √ | √
 |  |  |  | - | A087GTI | D87:TECH TOYS/RC:01/02/11:SMHV | 87 | REV | √ | √
 |  |  |  | - | A094J3A | COUGH/COLD (NDS VAPS/HUMS) ... | 94 | REV | √ | √
 |  |  |  | - | A094J3Q | COUGH/COLD (NDS VAPS/HUMS) ... | 94 | REV | √ | √
 |  |  |  | - | A094J49 | COUGH/COLD PHARMACY 5/17/09 | 94 | REV | X | X
 |  |  |  | - | A094J65 | PAIN 7/11/10 SMHV | 94 | REV | √ | √
 |  |  |  | - | A102B1Q | 54 STD STAT 2 D81 NICKELODE... | 102 | REV | X | X
 |  |  |  | - | A114C1R | 01-D94/245 3/6-4/10 ALLEGRA | 114 | SPL | √ | X
 |  |  |  | - | A119FKG | 07F-D86 3/06-4/10 BARBIE EN... | 119 | SPL | X | X
 |  |  |  | - | A120GVD | BULK 02 3/06-3/13 NESTLE A... | 120 | SPL | √ | X
 |  |  |  | - | A131AXF | 01-D52 3/06-5/15 UNDER $10 ... | 131 | SPL | √ | √
 |  |  |  | - | A131AYC | 02-D52 3/06-5/15 BOOTS DB | 131 | SPL | √ | X
 |  |  |  | - | A148D97 | D148 3/6-4/3 GM WINE | 148 | SPL | √ | X
 |  |  |  | - | A162BNY | T2 03/06/11 MOSS TEE #1 & #2 | 162 | POG | √ | X
 |  |  |  | - | A162BRG | D43 BEACH AND SODA VO1-5 | 162 | POG | √ | √
 |  |  |  | - | A162BRI | D43 NEW MUSIC/[NAME]... | 162 | POG | √ | √
 |  |  |  | - | A162BRL | D43 MOSS JERSEY POLO VO1-3 | 162 | POG | √ | √
 |  |  |  | - | A162BRV | D43 ULT POLO VO1-3 | 162 | POG | √ | √
 |  |  |  | - | A162BR4 | D41 [NAME] TEES VO1-3 | 162 | POG | √ | X
 |  |  |  | - | A162BR5 | D44 BELTS 3.6.11 | 162 | POG | √ | √
 |  |  |  | - | A162BSD | [NAME] WRANGLER (BOOT ... | 162 | REV | √ | X
 |  |  |  | - | A162BSV | T1 02/13/11 ULT FF KHAKI & ... | 162 | REV | √ | X
 |  |  |  | - | A201GKZ | D201 NR:VG:10/03/10 | 201 | REV | √ | √
 |  |  |  | - | A204FRK | D204:INFANT/TODDLER B:01/02... | 204 | REV | √ | √
 |  |  |  | - | A204FR4 | D204:CONSTRUCTION 1:01/02/1... | 204 | REV | √ | √
 |  |  |  | - | A207MME | WII/DS RESERVATION CARD SC | 207 | REV | √ | √
 |  |  |  | - | [NAME] | PS/XBOX RESERVATION CARD SC | 207 | REV | √ | √
 |  |  |  | - | [NAME] | WII NR 1/16/2011 | 207 | REV | √ | √
 |  |  |  | - | A207MN9 | GAMING LP#2 | 207 | REV | √ | √
 |  |  |  | - | A207MPF | DS 1/16/2011 | 207 | REV | √ | √
 |  |  |  | - | A207MPH | DS NR 1/16/2011 | 207 | REV | √ | √
 |  |  |  | - | A207MPQ | WII:A 16+(16)=32 1/16/2011 | 207 | REV | √ | √
 |  |  |  | - | A207MPW | XBOX NR 1/16/2011 | 207 | REV | √ | √
 |  |  |  | - | A207MP1 | XBOX 1/16/2011 | 207 | REV | √ | √
 |  |  |  | - | A207MQH | PLAYSTATION 1/16/2011 | 207 | REV | √ | √
 |  |  |  | - | A207MQR | WII:A2 (16)+16=32 1/16/2011 | 207 | REV | √ | √
 |  |  |  | - | A207MRN | STRATEGY GUIDE EC | 207 | REV | √ | √
 |  |  |  | - | A207MTX | GAMING LP#1:11/26/10 | 207 | REV | √ | X
 |  |  |  | - | A211V6G | PF PRODUCE OPEN CASE:TAZ:CA... | 211 | REV | X | X
 |  |  |  | - | A214A5F | [NAME]... | 214 | POG | √ | √
 |  |  |  | - | A214A5W | 214 C9 INTIMATES INNER BRA ... | 214 | POG | √ | √
 |  |  |  | - | A225RA1 | PF DESSERTS/SEASONAL - TAZ:... | 225 | REV | X | X
 |  |  |  | - | A270MDG | PF SNACKS W/MEAT TAZ 7DR HV... | 270 | REV | X | X
 |  |  |  | - | A411ADX | 10B-D249!_! AD ROTATION 03/... | 411 | SPL | X | X
 |  |  |  | - | A421AFN | 03 D83 03/06-03/13 AD ROT | 421 | SPL | √ | √
 |  |  |  | - | A425AED | 2-D425 AD ROT 3/06-3/12/11 | 425 | SPL | √ | X
 |  |  |  | - | A437AGC | 03-D072 3/6-3/13 AD ROTATION | 437 | SPL | √ | X
 |  |  |  | - | A439AJW | 04-D253 AD ROTATION 03/05-... | 439 | SPL | √ | X
 |  |  |  | - | B108PDY | D012 LATIN NR:RM:10/10/10 | 108 | REV | √ | √
 |  |  |  | - | B108PD1 | D012 CCM (60/72):CHRISTIAN:... | 108 | REV | √ | X
 |  |  |  | - | B108PD2 | D012 GENRE R&B INLINE:10/10/10 | 108 | REV | √ | √
 |  |  |  | - | B108PEB | D012 GENRE ROCK INLINE:10/1... | 108 | REV | √ | √
 |  |  |  | - | B108PED | D012 GENRE POP INLINE:10/10/10 | 108 | REV | √ | √
 |  |  |  | - | B108PEH | D012 MUSIC NR 2:R&B:10/10/10 | 108 | REV | √ | √
 |  |  |  | - | B108PEP | D012 COMPILATION/SOUNDTRACK... | 108 | REV | √ | X
 |  |  |  | - | B108PET | D012 MUSIC NR 1:R&B:10/10/10 | 108 | REV | √ | √
 |  |  |  | - | B108PFT | D058 DVD BS COMEDY (60/72):... | 108 | REV | √ | X
 |  |  |  | - | B108PGA | D058 KIDS DVD BS (60/72):10... | 108 | REV | √ | X
 |  |  |  | - | B108PGD | D058 DVD NR 1B:2'B+(3'A)+(3... | 108 | REV | √ | X
 |  |  |  | - | B108PGK | D058 DVD BS ACTION/SCI FI (... | 108 | REV | √ | X
 |  |  |  | - | B108PGR | D058 DVD NR 1C:3'C+(3'A)+(2... | 108 | REV | √ | X
 |  |  |  | - | B108PGT | D058 BOXED SETS NR (60/72):... | 108 | REV | √ | √
 |  |  |  | - | B108PGX | D058 BLU RAY EC 1:2'1+(2'2)... | 108 | REV | √ | X
 |  |  |  | - | B108PG2 | D058 KIDS DVD NR (60/72):10... | 108 | REV | √ | √
 |  |  |  | - | B108PG8 | D058 DVD NR 1A:3'A+(2'B)+(3... | 108 | REV | √ | √
 |  |  |  | - | B108PHI | D058 DVD NR 2 (60/72):10/10/10 | 108 | REV | √ | √
 |  |  |  | - | B108PHN | D058 BLU RAY BS (60/72):HTS... | 108 | REV | √ | X
 |  |  |  | - | B108PHT | D058 DVD BS DRAMA (60/72):1... | 108 | REV | √ | X
 |  |  |  | - | B108PIN | D012 P 9:WEST:02/27/11 | 108 | REV | √ | √