Spreadsheet: 59710d1260288197-populating-sheet-with-data-from-another-claims-inventory-work
Sheet: Full Claims Count

FULL CLAIMS COUNT PER WEEK
To use enter data in to white cells. Totals will be calculated automatically.
DESKTOP | CST1 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 2410
 | RED (P) | 2365
 | AOC | 1050
 | TOTAL | 5825 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CST2
 | RED | 5879
 | RED (P) | 5187
 | AOC | 1576
 | TOTAL | 12642 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CST3
 | RED | 1968
 | RED (P) | 707
 | AOC | 766
 | TOTAL | 3441 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BCU
 | RED | 0
 | RED (P) | 3697
 | AOC | 0
 | TOTAL | 3697 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Export/Internal
 | RED | 712
 | RED (P) | 0
 | AOC | 2035
 | TOTAL | 2747 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTALS | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 10969 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RED (P) | 11956 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AOC | 5427 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OVERALL | 28352 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Files available in BF | CST1 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 2526
 | RED (P) | 3270
 | AOC | 1730
 | TOTAL | 7526 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CST2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 3550
 | RED (P) | 1866
 | AOC | 2679
 | TOTAL | 8095 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CST3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 1881
 | RED (P) | 1959
 | AOC | 1016
 | TOTAL | 4856 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BCU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 0
 | RED (P) | 263
 | AOC | 0
 | TOTAL | 263 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Export/Internal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 290
 | RED (P) | 1622
 | AOC | 11
 | TOTAL | 1923 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTALS | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 8247 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RED (P) | 8980 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AOC | 5436 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OVERALL | 22663 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
All files Desktop+BF | CST1 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 4936 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RED (P) | 5635 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AOC | 2780 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL | 13351 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CST2
 | RED | 9429 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RED (P) | 7053 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AOC | 4255 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL | 20737 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CST3
 | RED | 3849 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RED (P) | 2666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AOC | 1782 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL | 8297 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BCU
 | RED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RED (P) | 3960 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AOC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL | 3960 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Export/Internal
 | RED | 1002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RED (P) | 1622 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AOC | 2046 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL | 4670 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTALS | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
 | RED | 19216 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RED (P) | 20936 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AOC | 10863 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OVERALL | 51015 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0