Spreadsheet: 267299d1380037643-if-formula-to-sort-data-issue_management_template
Sheet: Hours

TEAM NAME | DATE COMPLETED | PHASE | BUILDING | FLOOR | UNIT # | UNIT TYPE | TARGET HOURS | ACTUAL HOURS | PUNCH LIST ADJUSTMENT | TOTAL HOURS TO COMPLETE | COMPARISON
TEAM A | 2013-09-24 00:00:00 | ROUGH-IN |  |  |  |  | 24 | 25 |  | 25 | 1.041666666666667
TEAM B | 2013-09-24 00:00:00 | ROUGH-IN |  |  |  |  | 24 | 23 |  | 23 | 0.9583333333333334
TEAM C | 2013-09-24 00:00:00 | ROUGH-IN |  |  |  |  | 24 | 24 |  | 24 | 1
TEAM D | 2013-09-24 00:00:00 | ROUGH-IN |  |  |  |  | 24 | 26 |  | 26 | 1.083333333333333
TEAM A | 2013-09-26 00:00:00 | FINISH |  |  |  |  | 10 | 8 |  | 8 | 0.8
TEAM B | 2013-09-26 00:00:00 | FINISH |  |  |  |  | 10 | 9 |  | 9 | 0.9
TEAM C | 2013-09-26 00:00:00 | FINISH |  |  |  |  | 10 | 10 |  | 10 | 1
TEAM D | 2013-09-26 00:00:00 | FINISH |  |  |  |  | 10 | 11 |  | 11 | 1.1
TEAM A | 2013-10-02 00:00:00 | ROUGH-IN |  |  |  |  | 24 | 22 |  | 22 | 0.9166666666666666
TEAM B | 2013-10-02 00:00:00 | ROUGH-IN |  |  |  |  | 24 | 24 |  | 24 | 1
TEAM C | 2013-10-02 00:00:00 | ROUGH-IN |  |  |  |  | 24 | 25 |  | 25 | 1.041666666666667
TEAM D | 2013-10-02 00:00:00 | ROUGH-IN |  |  |  |  | 24 | 24 |  | 24 | 1
TEAM A | 2013-10-04 00:00:00 | FINISH |  |  |  |  | 10 | 9 |  | 9 | 0.9
TEAM B | 2013-10-04 00:00:00 | FINISH |  |  |  |  | 10 | 10 |  | 10 | 1
TEAM C | 2013-10-04 00:00:00 | FINISH |  |  |  |  | 10 | 10 |  | 10 | 1
TEAM D | 2013-10-04 00:00:00 | FINISH |  |  |  |  | 10 | 9 |  | 9 | 0.9
TEAM A | 2013-09-25 00:00:00 | ROUGH-IN | 2C-1 | 2 | 3-102 | S1 | 20 | 18 | 3 | 21 | 1.05
 |  |  |  |  |  |  |  |  |  | 0 | #N/A
End of Sheet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM A |  |  |  | TEAM B |  |  |  | TEAM C |  |  |  | TEAM D |  |  |  | TEAM E
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM NAME | PHASE | BUILDING | FLOOR | UNIT TYPE | HOLES | ROUGH HOURS | FINISH HOURS | TESTING |  | ROUGH |  | FINISH |  | ROUGH |  | FINISH |  | ROUGH |  | FINISH |  | ROUGH |  | FINISH |  | ROUGH |  | FINISH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM A | ROUGH-IN | 2C-1 | 1 | S1-JR | 27 | 11.529 | 7.344 |  |  | DATE | RATING | DATE | RATING | DATE | RATING | DATE | RATING | DATE | RATING | DATE | RATING | DATE | RATING | DATE | RATING | DATE | RATING | DATE | RATING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM B | FINISH | 2C-2 | 2 | S1 | 35 | 14.945 | 9.520000000000001 |  |  | 2013-09-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM C | TESTING | 3B-1 | 3 | S1 G2A | 31 | 13.237 | 8.432 |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM D |  | 3B-2 | 4 | A1-A | 43 | 18.361 | 11.696
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM E |  |  |  | A1-A (H.I.) | 45 | 19.215 | 12.24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM F |  |  |  | A1-Am1 | 43 | 18.361 | 11.696
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM G |  |  |  | A1-Am2 | 44 | 18.788 | 11.968
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM H |  |  |  | A1-B | 42 | 17.934 | 11.424
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM I |  |  |  | A1-C | 46 | 19.642 | 12.512
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM J |  |  |  | A1-C (H.I.) | 47 | 20.069 | 12.784
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1-D | 47 | 20.069 | 12.784
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1-Dm | 46 | 19.642 | 12.512
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1-D G2A | 47 | 20.069 | 12.784
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1-E | 46 | 19.642 | 12.512
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1-E (H.I.) | 48 | 20.496 | 13.056
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1-Em | 45 | 19.215 | 12.24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2-A | 46 | 19.642 | 12.512
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2-A (H.I.) | 48 | 20.496 | 13.056
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2-Am1 | 47 | 20.069 | 12.784
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2-D | 45 | 19.215 | 12.24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2-D (H.I.) | 47 | 20.069 | 12.784
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1-A | 61 | 26.047 | 14.091
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1-Am1 | 62 | 26.474 | 14.322
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1-Am2 | 61 | 26.047 | 14.091
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1-A G2A | 63 | 26.901 | 14.553
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1-Am1 G2A | 64 | 27.328 | 14.784
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1-B | 60 | 25.62 | 13.86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1-Bm | 62 | 26.474 | 14.322
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1-C | 57 | 24.339 | 13.167
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-A | 58 | 24.766 | 13.398
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-Am1 | 59 | 25.193 | 13.629
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-Am2 | 59 | 25.193 | 13.629
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-Am3 | 58 | 24.766 | 13.398
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-B | 65 | 27.755 | 15.015
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-C | 65 | 27.755 | 15.015
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-Cm1 | 65 | 27.755 | 15.015
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-D | 56 | 23.912 | 12.936
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-E | 63 | 26.901 | 14.553
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-Em | 63 | 26.901 | 14.553
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2-Em1 | 63 | 26.901 | 14.553
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1-A | 70 | 29.89 | 16.17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1-Am | 71 | 30.317 | 16.401
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1-Am1 | 71 | 30.317 | 16.401
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1-A G2A | 72 | 30.744 | 16.632
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1-Am G2A | 73 | 31.171 | 16.863
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1-Am1 G2A | 73 | 31.171 | 16.863
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1-Am2 G2A | 72 | 30.744 | 16.632
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1-B | 77 | 32.879 | 17.787