Spreadsheet: 477835d1472536540-yet-another-issue-beyond-my-understanding-drop-down-lists-and-auto-populate-br157master
Sheet: QC Gradation Mix 2 (A)

BR 157 (5/13)
NEW YORK STATE DEPARTMENT OF TRANSPORTATION-MATERIALS BUREAU
DRUM MIX PLANT PRODUCTION TEST - Volumetric
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ignition Oven
Facility No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Producer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location
Formula No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ESAL |  |  |  |  |  | AC %
RAP % |  |  |  |  |  |  |  |  |  |  |  |  |  | QCT or QAT |  |  |  |  |  |  |  | QCT |  |  |  | Technician Name
Lot/Sublot : |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  | [NAME] ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample Date
MOISTURE CONTENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BINDER CONTENT
Calculation |  |  |  |  |  |  |  | Aggregate |  |  |  |  |  |  | Mixture |  |  |  |  |  |  | RAP |  |  |  |  |  |  |  | Calculation |  |  |  |  |  |  |  |  |  |  |  | Mixture |  |  |  |  | RAP
Wet Wt. (A) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]. (A)
[NAME] (B) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aggregate Wt. (B)
Diff. Wt.  (A-B) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Filter Gain Wt.(C)
A-B |  |  |  | x | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME].   A - (B+C)
B
SAMPLE TIME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A-[B+C] |  |  |  |  |  | X |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
Aggregate Moisture |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RAP Moisture
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Binder
Mixture % Binder |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RAP % Binder
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % [NAME]
Mixture Moisture
[NAME] ([NAME]) |  |  |  |  |  |  |  | QC /QA Gradation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Agg. |  |  |  |  | % Min.     Fill |  |  |  |  | Total % Pass |  |  |  |  | Daily Target |  |  |  |  | Upper Daily Production Limit |  |  |  |  | Lower Daily Production Limit
 |  |  |  |  |  |  |  | Weight (g) |  |  |  |  | % Ret. |  |  |  |  | % Pass
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR 9.5mm FRICTION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * |  |  | *
2 in (50) |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENTER 3.2mm IN TAN BOX
1 1/2 in (37.5) |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  | 100 |  |  |  |  | 100
1 in (25) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  | 94 |  |  |  |  |  |  |  |  |  | 3.2mm
3/4 in (19) |  |  |  |  |  |  |  | 186.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 |  |  |  |  | 89
1/2 in (12.5) |  |  |  |  |  |  |  | 153.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  | 80
3/8 in (9.5) |  |  |  |  |  |  |  | 177.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81 |  |  |  |  | 71
1/4 in (6.3)
No. 4 (4.75) |  |  |  |  |  |  |  | 588.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 |  |  |  |  | 45
No. 8 (2.36) |  |  |  |  |  |  |  | 325.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 |  |  |  |  | 31
No. 16 (1.18) |  |  |  |  |  |  |  | 171.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  | 23
No. 30 (0.600) |  |  |  |  |  |  |  | 144.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  | 15
No. 50 (0.300) |  |  |  |  |  |  |  | 156.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  |  |  |  | 7
No. 100 (0.150) |  |  |  |  |  |  |  | 116 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  |  | 3
No.200 (0.075) |  |  |  |  |  |  |  | 63.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
PAN |  |  |  |  |  |  |  | 68.1
TOTAL
 |  |  |  |  | Technician Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date