Spreadsheet: 166503d1341602499-vlookup-issues-2nd-try-weekly-report-date-working
Sheet: Data

Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
2012-05-21 00:00:00 | Pre-Service:  IP not complete | 3 | 4 | 6 | 4 | 45567 | 2 | 5 | 5654674 | 5y | 4rtyu | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | Pre-Service:  OP not complete | 3 | 7 | 3 | 498 | 5 | 6 | 34 | 8 | 9 | 54478 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | Pre-Service:  MH not complete | 3 | 4 | 3 | 6797 | 5 | 6 | 6 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | Post-Service:  IP not complete | 1 | 5 | 3 | 4 | 5 | 5 | 7 | 6 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | Post-Service:  OP not complete | 4 | 357 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | MH not complete | t8 | 2 | 357 | re5 | 5 | 6 | fg5643 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | SC Determination Backlog | 12 | 1 | 3 | 4 | 5 | 6 | 356w | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | Coding Pending:  Inpatient | 4 | 1 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | Coding Pending:  Outpatient | es | 34 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | RUR Delinquetn QUIC Numbers | 4 | 56 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | Facility Revenue Delinquent QUIC | 3 | 4 | 3 | 44 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | ONTRAC:  Days Out | 4 | 5 | 3 | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | "Zero Scheduled Admissions:  Yes or No | 2 | 3 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
2012-05-21 00:00:00 | Comments | asdf | luck | home | gook | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
2012-05-28 00:00:00 | Pre-Service:  IP not complete | 12 | 5 | 3 | 67 | 95 | 0 | 87 | 19 | 20 | r | wwe | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | Pre-Service:  OP not complete | 1 | 13 | 14 | 15 | 346 | 17 | 18 | 19 | 20 | 21 | sdgf | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | Pre-Service:  MH not complete | s | 13 | 2354 | 15 | f | f43 | 18 | 19 | as | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | Post-Service:  IP not complete | 12 | zxc | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | Post-Service:  OP not complete | 12 | t | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | MH not complete | q | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | SC Determination Backlog | 12 | 13 | 3 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | Coding Pending:  Inpatient | 12 | dfas | 14 | 3 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | Coding Pending:  Outpatient | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | RUR Delinquetn QUIC Numbers | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | Facility Revenue Delinquent QUIC | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | ONTRAC:  Days Out | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | "Zero Scheduled Admissions:  Yes or No | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
2012-05-28 00:00:00 | Comments | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | Pre-Service:  OP not complete | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | Pre-Service:  MH not complete | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | Post-Service:  IP not complete | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | Post-Service:  OP not complete | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | MH not complete | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | SC Determination Backlog | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | Coding Pending:  Inpatient | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | Coding Pending:  Outpatient | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | RUR Delinquetn QUIC Numbers | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | Facility Revenue Delinquent QUIC | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | ONTRAC:  Days Out | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | "Zero Scheduled Admissions:  Yes or No | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 | Comments | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete | 352 | 2345 | 4338 | sadf | asdf | 10317 | 12310 | 14303 | 16296 | 18289 | 20282 | 22275 | 24268 | 26261 | 28254 | 30247 | 32240 | 34233 | 36226
 | Pre-Service:  OP not complete | 352 | 2345 | 4338 | sadf | asdf
 | Pre-Service:  MH not complete | 352 | 2345 | 4338 | sadf | asdf
 | Post-Service:  IP not complete | 352 | 2345 | 4338 | sadf | asdf
 | Post-Service:  OP not complete | 352 | 2345 | 4338 | sadf | asdf
 | MH not complete | 352 | 2345 | 4338 | sadf | asdf
 | SC Determination Backlog | 352 | 2345 | 4338 | sadf | asdf
 | Coding Pending:  Inpatient | 352 | 2345 | 4338 | sadf | asdf
 | Coding Pending:  Outpatient | 352 | 2345 | 4338 | sadf | asdf
 | RUR Delinquetn QUIC Numbers | 352 | 2345 | 4338 | sadf | asdf
 | Facility Revenue Delinquent QUIC | 352 | 2345 | 4338 | sadf | asdf
 | ONTRAC:  Days Out | 352 | 2345 | 4338 | sadf | asdf
 | "Zero Scheduled Admissions:  Yes or No | 352 | 2345 | 4338 | sadf | asdf
 | Comments | 352 | 2345 | 4338 | sadf | asdf
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
Date |  | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions:  Yes or No
 | Comments
2012-05-21 00:00:00
2012-05-28 00:00:00
2012-06-04 00:00:00
2012-06-11 00:00:00
2012-06-18 00:00:00
2012-06-25 00:00:00
2012-07-02 00:00:00
2012-07-09 00:00:00
2012-07-16 00:00:00
2012-07-23 00:00:00
2012-07-30 00:00:00
2012-08-06 00:00:00
2012-08-13 00:00:00
2012-08-20 00:00:00
2012-08-27 00:00:00
2012-09-03 00:00:00
2012-09-10 00:00:00
2012-09-17 00:00:00
2012-09-24 00:00:00
2012-10-01 00:00:00
2012-10-08 00:00:00
2012-10-15 00:00:00
2012-10-22 00:00:00
2012-10-29 00:00:00
2012-11-05 00:00:00
2012-11-12 00:00:00
2012-11-19 00:00:00
2012-11-26 00:00:00
2012-12-03 00:00:00