Spreadsheet: 92288d1291904151-average-random-cells-no-array-bypassing-cells-with-zeros-example-2010-2011
Sheet: McGill

Detailing / BOM Error Log
[NAME]
Date | Type | Comments | Available Points | Errors | Total Points
2010-09-16 00:00:00 | BOM | 0110076 - MJC Agricultural Pavilion | 25 | 7
 |  | 1. missed 1 @ 21'-10" on wall panel section 10
 |  | 2. left off custom product codes
 |  | 3. short 78 rolls of tape sealant
 |  | 4. had 855 too many is/os closures
 |  | 5. short 17500 sd screws
 |  | 6. 133 too many foam closures
 |  | 7. missing 92 tubes of tube sealant
2010-09-22 00:00:00 | SHOPS | 0910001 - Eric Fisher Roof | 20 | 5
 |  | 1. Wrong project name on shops.
 |  | 2. Incorrrect Slope.  Should be 9:12, not 7:12.  [NAME] figured it wrong.
 |  | 3. Short panel lengths due to incorrect slope - [NAME] should be 16'-0 not 15'-0.
 |  | 4. Wrong fastener called out.  Should be 1/4"-14X1 Xl ABMP
 |  | 5. Wrong angle on flashings due to incorrect slope.
2010-09-28 00:00:00 | BOM | 0910001 - Eric Fisher Roof | 15 | 4
 |  | 1. incorrect color code on flashing part numbers.
 |  | 2. short 750 XL ABMP screws
 |  | 3. left off stile closures.
 |  | 4. short on universal closures.
2010-09-29 00:00:00 | SHOPS | 0910059 - Croda Bldg 80 & Kettle Bldg 4 | 40 | 3
 |  | 1. wrong UL conctruction number.
 |  | 2. incorrect dimension on key plan.
 |  | 3. incorrect eave allowance in charts caused short panel lengths throughout.
2010-09-30 00:00:00 | SHOPS | 0910066 - Farm Credit Services Addition | 10
 |  | NO ERRORS
2010-10-01 00:00:00 | BOM | 0110076 - MJC Agricultural Pavilion | 25 | 6
 |  | 1. incorrect panel lengths per drawings.
 |  | 2. rake qty incorrect.
 |  | 3. short endlap pads.
 |  | 4. short 50 clips and s-5 clamps.
 |  | 5. short 2250 pop rivets.
 |  | 6. short 750 stitch screws.
2010-10-07 00:00:00 | BOM | 0910059 - Kettle Bldg 4 | 20 | 6
 |  | 1. no color code for panel product code.
 |  | 2. short 335 clips.
 |  | 3. short 20 tubes of tube sealant.
 |  | 4. short 8 rolls of double bead tape sealant.
 |  | 5. short 11 flat sheets.
 |  | 6. short 500 1-1/4" sd n/w screws.
2010-10-25 00:00:00 | SHOPS | 1010054 - Loy Complex | 40 | 7
 |  | 1. missing ul conctruction note.
 |  | 2. wrong allowances for slope change
 |  | 3. wrong allowances for valley.
 |  | 4. incorrect panel lengths sue to incorrect allowances.
 |  | 5. did not devide up section lf totals in details.
 |  | 6. missing back-up channel in accessories.
 |  | 7. used 6" instead of 4" ds bracket
2010-10-26 00:00:00 | BOM | 0910066 - Farm Credit Services Addition | 10 | 1
 |  | 1. Extra panels not on shops.
2010-11-18 00:00:00 | SHOPS | 1010054 - Loy Complex - R&R | 10 | 1
 |  | 1. incorrect panel length sec D
2010-11-28 00:00:00 | SHOPS | 0810069 - Custer County Courthouse - AFC | 20 | 11
 |  | 1. 6/d1 wrong callout for counterflashing
 |  | 2. missing screw/cleat on 7/d1, 1/d2
 |  | 3. missing counterflashing
 | BOM | 4. missing color code for panel
 |  | 5. section H panel length 9'-10", should be 9'-0"
 |  | 6. short 47 z-closures
 |  | 7. short 13 rakewalls
 |  | 8. missing counterflashing
 |  | 9. short 25 tube sealants
 |  | 10. short 1250 pop rivets
 |  | 11. missing color code on #9 woodscrews.
2010-12-01 00:00:00 | SHOPS | 1010054 - Loy Complex - AFC | 15 | 7
 |  | NO ERRORS ON SHOPS
 | BOM | 1. section D qty 9, should be 6
 |  | 2. 41 too many offset cleats
 |  | 3. short 85 end dams
 |  | 4. short 57 endlap pads
 |  | 5. short 61 tube sealants
 |  | 6. short 500 pop rivets
 |  | 7. short 750 1" sd n/w