Spreadsheet: 91094d1290776527-returning-information-from-separate-workbook-based-on-cell-text-advancedfilter
Sheet: T-0

#N/A | TOTAL TASKS = |  | 39 | #N/A | WORK WEEK SCHEDULE COMPLETION = | 0.4358974358974359 | #N/A | WEEK RES LOAD % = |  | #N/A |  |  | #N/A | TOTAL HOURS = |  | 78 |  |  | 17 |  |  |  |  |  | 1.5
#N/A | TOTAL TASKS = |  | 0 | #N/A | WORK WEEK SCHEDULE COMPLETION = |  | #N/A | WEEK RES LOAD % = |  | #N/A |  |  | #N/A | TOTAL HOURS = |  | 0
T- 0 WORK SCHEDULE  WEEK |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  | Yellow is [NAME]
WO # | TASK # | UNIT # | USI # | EQUIP # | WORK ORDER DESC | HOLDS | STATUS | TARGET START | HOURS | PRIORITY | WO TYPE | EARLY DATE | LATE  DATE | ITEM # | CREW | DELAY | SCR # | NOTES |  |  | WO # | TASK # | UNIT # | USI # | EQUIP # | WORK ORDER DESC | HOLDS | STATUS | TARGET START | HOURS | PRIORITY | WO TYPE | EARLY DATE | LATE  DATE | ITEM # | CREW | DELAY | SCR # | NOTES
#N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delayed
 |  |  |  |  |  |  | #N/A | MON TOTAL HOURS = |  | 26 |  | #N/A | MON TOTAL HOURS = |  | 0 |  |  | NOTES
 |  |  |  |  |  |  | #N/A | MON RESOURCE % = |  | #N/A |  | #N/A | MON RESOURCE % = |  | #N/A |  |  |  |  |  | WO # | TASK # | UNIT # | USI # | EQUIP # | WORK ORDER DESC | HOLDS | STATUS | TARGET START | HOURS | PRIORITY | WO TYPE | EARLY DATE | LATE  DATE | ITEM # | CREW | DELAY | SCR # | NOTES
100002 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 | NA | READY | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 |  |  |  |  |  | 100003 | 2 | 2 | 411 | P2 | TEST INFORMATION 2 DELAY 1 | NA | DELAYED | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | CON | 15512 | Test notes
100003 | 2 | 2 | 411 | P2 | TEST INFORMATION 2 DELAY 1 | NA | DELAYED | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | CON | 15512 | Test notes |  |  | 100005 | 2 | 3 | 411 | P4 | TEST INFORMATION 4 DELAY 2 | NA | DELAYED | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | ENG | 15513 | Test notes
100004 | 1 | 2 | 411 | P3 | TEST INFORMATION 3 | NA | READY | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 |  |  |  |  |  | 100014 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 3 | NA | DELAYED | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | KB | 15514 | Test notes
100005 | 2 | 3 | 411 | P4 | TEST INFORMATION 4 DELAY 2 | NA | DELAYED | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | ENG | 15513 | Test notes |  |  | 100025 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 DELAY 4 | NA | DELAYED | 2010-11-16 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | SB | 15515 | Test notes
100006 | 3 | 3 | 411 | P5 | TEST INFORMATION 5 | NA | CXCL/REQ | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 |  |  |  |  |  | 100030 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 DELAY 5 | NA | DELAYED | 2010-11-16 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | ENG | 15516 | Test notes
100007 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 | NA | APPROVED | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 |  |  |  |  |  | 100037 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 7 | NA | DELAYED | 2010-11-16 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | KB | 15517 | Test notes
100008 | 5 | 3 | 411 | P7 | TEST INFORMATION 7 | NA | [NAME] | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 |  |  |  |  |  | 100040 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 DELAY 8 | NA | DELAYED | 2010-11-17 00:00:00 | 2 | N | PA | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | TE | 15518 | Test notes
100009 | 6 | 2 | 411 | P8 | TEST INFORMATION 8 | NA | [NAME] | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 |  |  |  |  |  | 100045 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 DELAY 9 | NA | DELAYED | 2010-11-17 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | CON | 15519 | Test notes
100010 | 7 | 2 | 411 | P9 | TEST INFORMATION 9 | NA | [NAME] | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 |  |  |  |  |  | 100052 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 10 | NA | DELAYED | 2010-11-17 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | KB | 155120 | Test notes
100011 | 8 | 4 | 411 | P10 | TEST INFORMATION 10 | NA | [NAME] | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100012 | 9 | 4 | 411 | P11 | TEST INFORMATION 11 | NA | [NAME] | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100013 | 10 | 4 | 411 | P12 | TEST INFORMATION 12 | NA | [NAME] | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100014 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 3 | NA | DELAYED | 2010-11-15 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | KB | 15514 | Test notes
#N/A
 |  |  |  |  |  |  | #N/A | TUES TOTAL HOURS = |  | 26 |  | #N/A | TUES TOTAL HOURS = |  | 0 |  |  | NOTES
 |  |  |  |  |  |  | #N/A | TUES RESOURCE % = |  | #N/A |  | #N/A | TUES RESOURCE % = |  | #N/A
100025 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 DELAY 4 | NA | DELAYED | 2010-11-16 00:00:00 | 2 | N | PM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | SB | 15515 | Test notes
100026 | 2 | 2 | 411 | P2 | TEST INFORMATION 2 | NA | [NAME] | 2010-11-16 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100027 | 1 | 2 | 411 | P3 | TEST INFORMATION 3 | NA | READY | 2010-11-16 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100028 | 2 | 3 | 411 | P4 | TEST INFORMATION 4 | NA | [NAME] | 2010-11-16 00:00:00 | 2 | N | PA | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100029 | 3 | 3 | 411 | P5 | TEST INFORMATION 5 | NA | APPROVED | 2010-11-16 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100030 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 DELAY 5 | NA | DELAYED | 2010-11-16 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | ENG | 15516 | Test notes
100031 | 5 | 3 | 411 | P7 | TEST INFORMATION 7 | NA | [NAME] | 2010-11-16 00:00:00 | 2 | N | PA | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100032 | 6 | 2 | 411 | P8 | TEST INFORMATION 8 | NA | [NAME] | 2010-11-16 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100033 | 7 | 2 | 411 | P9 | TEST INFORMATION 9 | NA | [NAME] | 2010-11-16 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100034 | 8 | 4 | 411 | P10 | TEST INFORMATION 10 | NA | [NAME] | 2010-11-16 00:00:00 | 2 | N | PA | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100035 | 9 | 4 | 411 | P11 | TEST INFORMATION 11 | NA | [NAME] | 2010-11-16 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100036 | 10 | 4 | 411 | P12 | TEST INFORMATION 12 | NA | [NAME] | 2010-11-16 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100037 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 7 | NA | DELAYED | 2010-11-16 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | KB | 15517 | Test notes
#N/A
 |  |  |  |  |  |  | #N/A | WEDS TOTAL HOURS = |  | 26 |  | #N/A | WEDS TOTAL HOURS = |  | 0 |  |  | NOTES
 |  |  |  |  |  |  | #N/A | WEDS RESOURCE % = |  | #N/A |  | #N/A | WEDS RESOURCE % = |  | #N/A
100040 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 DELAY 8 | NA | DELAYED | 2010-11-17 00:00:00 | 2 | N | PA | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | TE | 15518 | Test notes
100041 | 2 | 2 | 411 | P2 | TEST INFORMATION 2 | NA | [NAME] | 2010-11-17 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100042 | 1 | 2 | 411 | P3 | TEST INFORMATION 3 | NA | READY | 2010-11-17 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100043 | 2 | 3 | 411 | P4 | TEST INFORMATION 4 | NA | [NAME] | 2010-11-17 00:00:00 | 2 | N | PA | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100044 | 3 | 3 | 411 | P5 | TEST INFORMATION 5 | NA | [NAME] | 2010-11-17 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100045 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 DELAY 9 | NA | DELAYED | 2010-11-17 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | CON | 15519 | Test notes
100046 | 5 | 3 | 411 | P7 | TEST INFORMATION 7 | NA | WORKING | 2010-11-17 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100047 | 6 | 2 | 411 | P8 | TEST INFORMATION 8 | NA | WORKING | 2010-11-17 00:00:00 | 2 | N | PA | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100048 | 7 | 2 | 411 | P9 | TEST INFORMATION 9 | NA | WORKING | 2010-11-17 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100049 | 8 | 4 | 411 | P10 | TEST INFORMATION 10 | NA | WORKING | 2010-11-17 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100050 | 9 | 4 | 411 | P11 | TEST INFORMATION 11 | NA | WORKING | 2010-11-17 00:00:00 | 2 | N | OT | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100051 | 10 | 4 | 411 | P12 | TEST INFORMATION 12 | NA | WORKING | 2010-11-17 00:00:00 | 2 | N | PA | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1
100052 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 10 | NA | DELAYED | 2010-11-17 00:00:00 | 2 | N | CM | 2010-11-10 00:00:00 | 2010-11-25 00:00:00 |  | CREW1 | KB | 155120 | Test notes
#N/A
 |  |  |  |  |  |  | #N/A | THURS TOTAL HOURS = |  | 0 |  | #N/A | THURS TOTAL HOURS = |  | 0 |  |  | NOTES
 |  |  |  |  |  |  | #N/A | THURS RESOURCE % = |  | #N/A |  | #N/A | THURS RESOURCE % = |  | #N/A
#N/A
 |  |  |  |  |  |  | #N/A | FRI TOTAL HOURS = |  | 0 |  | #N/A | FRI TOTAL HOURS = |  | 0 |  |  | NOTES
 |  |  |  |  |  |  | #N/A | FRI RESOURCE % = |  | #N/A |  | #N/A | FRI RESOURCE % = |  | #N/A
#N/A
 |  |  |  |  |  |  | #N/A | SAT TOTAL HOURS = |  | 0 |  | #N/A | SAT TOTAL HOURS = |  | 0 |  |  | NOTES
 |  |  |  |  |  |  | #N/A | SAT RESOURCE % = |  | #N/A |  | #N/A | SAT RESOURCE % = |  | #N/A
#N/A
 |  |  |  |  |  |  | #N/A | SUN TOTAL HOURS = |  | 0 |  | #N/A | SUN TOTAL HOURS = |  | 0 |  |  | NOTES
 |  |  |  |  |  |  | #N/A | SUN RESOURCE % = |  | #N/A |  | #N/A | SUN RESOURCE % = |  | #N/A
MON | HOURS | #N/A | #N/A
 | AVAIL | #N/A | #N/A
 | SCHED | 26 | 0
 | % | #N/A | #N/A
TUES | HOURS | #N/A | #N/A
 | AVAIL | #N/A | #N/A
 | SCHED | 26 | 0
 | % | #N/A | #N/A
WED | HOURS | #N/A | #N/A
 | AVAIL | #N/A | #N/A
 | SCHED | 26 | 0
 | % | #N/A | #N/A
THURS | HOURS | #N/A | #N/A
 | AVAIL | #N/A | #N/A
 | SCHED | 0 | 0
 | % | #N/A | #N/A
FRI | HOURS | #N/A | #N/A
 | AVAIL | #N/A | #N/A
 | SCHED | 0 | 0
 | % | #N/A | #N/A
SAT | HOURS | #N/A | #N/A
 | AVAIL | #N/A | #N/A
 | SCHED | 0 | 0
 | % | #N/A | #N/A
SUN | HOURS | #N/A | #N/A
 | AVAIL | #N/A | #N/A
 | SCHED | 0 | 0
 | % | #N/A | #N/A
T-12 RES % LOADING
WEEK # | HOURS | #N/A | #N/A
 | AVAIL | #N/A | #N/A
 | SCHED | 78 | 0
#N/A | % | #N/A | #N/A
1.25
TOTAL NUMBER OF TASKS |  |  |  |  |  | #N/A | DELAY CODE % |  |  |  |  |  | WORK TYPE PERCENTAGES
 | #N/A | #N/A |  |  |  |  | TOTAL% DELAYED | 0.2307692307692308 |  |  |  |  | TYPE | #N/A | #N/A
MON | 13 | 0 |  |  |  |  | ASG = | 0 |  |  |  |  | CM | 0.2051282051282051
TUES | 13 | 0 |  |  |  |  | CON = | 0.05128205128205128 |  |  |  |  | EM | 0
WED | 13 | 0 |  |  |  |  | DOC = | 0 |  |  |  |  | FM | 0
THURS | 0 | 0 |  |  |  |  | EMW = | 0 |  |  |  |  | MD | 0
FRI | 0 | 0 |  |  |  |  | ENG = | 0.05128205128205128 |  |  |  |  | PA | 0.1794871794871795
SAT | 0 | 0 |  |  |  |  | FSC = | 0 |  |  |  |  | PM | 0.358974358974359
SUN | 0 | 0 |  |  |  |  | [NAME] = | 0.07692307692307693 |  |  |  |  | OT | 0.2564102564102564
 |  |  |  |  |  |  | MAT = | 0
COMPLETED AS SCHEDULED |  |  |  |  |  |  | MD = | 0
 | #N/A | #N/A |  |  |  |  | NDLY = | 0
MON | 6 | 0 |  |  |  |  | PO = | 0
TUES | 8 | 0 |  |  |  |  | PTR = | 0
WED | 3 | 0 |  |  |  |  | QM = | 0
THURS | 0 | 0 |  |  |  |  | RB = | 0
FRI | 0 | 0 |  |  |  |  | REC = | 0
SAT | 0 | 0 |  |  |  |  | RWK = | 0
SUN | 0 | 0 |  |  |  |  | SB = | 0.02564102564102564
 |  |  |  |  |  |  | SC = | 0
COMP TASKS FOR WEEK |  |  |  |  |  |  | SI = | 0
 | #N/A | #N/A |  |  |  |  | SWE = | 0
TOTAL = | 17 | 0 |  |  |  |  | TE = | 0.02564102564102564
 |  |  |  |  |  |  | WA = | 0
DAILY SCHED COMPLIANCE |  |  |  |  |  |  | WGC = | 0
 | #N/A | #N/A |  |  |  |  | WKR = | 0
WEEK | 0.4358974358974359
MON | 0.4615384615384616 |  |  |  |  | #N/A | DELAY CODE %
TUES | 0.6153846153846154 |  |  |  |  |  | TOTAL% DELAYED | 0
WED | 0.2307692307692308 |  |  |  |  |  | ASG =
THURS |  |  |  |  |  |  | CON =
FRI |  |  |  |  |  |  | DOC =
SAT |  |  |  |  |  |  | EMW =
SUN |  |  |  |  |  |  | ENG =
 |  |  |  |  |  |  | FSC =
 |  |  |  |  |  |  | [NAME] =
 |  |  |  |  |  |  | MAT =
 |  |  |  |  |  |  | MD =
 |  |  |  |  |  |  | NDLY =
 |  |  |  |  |  |  | PO =
 |  |  |  |  |  |  | PTR =
 |  |  |  |  |  |  | QM =
 |  |  |  |  |  |  | RB =
 |  |  |  |  |  |  | REC =
 |  |  |  |  |  |  | RWK =
 |  |  |  |  |  |  | SB =
 |  |  |  |  |  |  | SC =
 |  |  |  |  |  |  | SI =
 |  |  |  |  |  |  | SWE =
 |  |  |  |  |  |  | TE =
 |  |  |  |  |  |  | WA =
 |  |  |  |  |  |  | WGC =
 |  |  |  |  |  |  | WKR =
 |  |  |  |  | APPROVED
 |  |  |  |  | CXCL/REQ | ASG
 |  |  |  |  | H/APPR | CON
 |  |  |  |  | PLAN | DOC
 |  |  |  |  | READY | EMW
 |  |  |  |  | RETURNED | ENG
 |  |  |  |  | WORKING | FSC
 |  |  |  |  | SUSPEND | KB
 |  |  |  |  | DELAYED | MAT
 |  |  |  |  | [NAME] | MD
 |  |  |  |  | DELAY COMP | NDLY
 |  |  |  |  | NEW WORK | PO
 |  |  |  |  |  | PTR
 |  |  |  |  |  | QM
 |  |  |  |  |  | RB
 |  |  |  |  |  | REC
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | SB
 |  |  |  |  |  | SC
 |  |  |  |  |  | SI
 |  |  |  |  |  | SWE
 |  |  |  |  |  | TE
 |  |  |  |  |  | WA
 |  |  |  |  |  | WGC
 |  |  |  |  |  | WKR