{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["CRA 1 Failure ","PG Asphalt 1 Failure","PG Asphalt >1 Failure","Emulsified Asphalt Failure","409 Asphalt 1 Failure ","409 Asphalt >1 Failure","Table 1005-1","Table 1009-3"],"not_rendered":{"charts":0,"images":50,"macros":1,"external_links":0,"defined_names":7,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CRA 1 Failure ","index":0,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,1],[3,2,3,3],[3,4,3,5],[3,7,3,8],[5,9,6,9],[7,1,8,1],[7,5,8,5],[7,6,8,6],[7,8,8,8],[7,9,8,9],[5,1,6,1],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[9,1,10,1],[9,5,10,5],[9,6,10,6],[9,8,10,8],[9,9,10,9],[11,1,12,1],[11,5,12,5],[11,6,12,6],[11,8,12,8],[11,9,12,9],[12,2,12,3],[13,1,14,1],[13,5,14,5],[13,6,14,6],[13,8,14,8],[13,9,14,9],[13,2,13,3],[14,2,14,3],[15,1,16,1],[15,5,16,5],[15,6,16,6],[15,8,16,8],[15,9,16,9],[15,2,15,3],[16,2,16,3],[17,1,18,1],[17,5,18,5],[17,6,18,6],[17,8,18,8],[17,9,18,9],[17,2,17,3],[18,2,18,3],[21,9,22,9],[21,2,21,3],[22,2,22,3],[19,1,20,1],[19,5,20,5],[19,6,20,6],[19,8,20,8],[19,9,20,9],[19,2,19,3],[20,2,20,3],[24,2,24,3],[21,1,22,1],[21,5,22,5],[21,6,22,6],[21,8,22,8],[25,0,25,7],[25,8,25,9],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[23,1,24,1],[23,5,24,5],[23,6,24,6],[23,8,24,8],[23,9,24,9],[23,2,23,3]]}
["CRA Failure - One Property Failure "]
["Reference Specs:  413-9, 414-9, and  415-9(F).  Adjustments in payment shall be made in accordance with the requirements of Subsection 1009, for total tonnage on Asphalt Rubber Blend."]
["When the asphalt rubber material fails on one property, the pay adjustment is based on the lowest reduction of Contract Unit Price, so if one test fails at 70% and the other at 85%, the pay adjustment will be based on the 85%.  (When the crumb rubber fails in 413, 414 or 415, the entire Asphalt-Rubber blend tons used is penalized, per shift)Should the asphalt rubber fail on more than one property, the pay adjustment will be the greatest reduction to the contract unit price specified considering individul test results"]
["TRACS No:",null,null,null,"Asphalt Binder Pay Item Number",null,null,"Contract Unit Price"]
["Sample Number & Phase","Sample Date","Test Property and Result",null,"% of Contract Unit Price Allowed","Better Result of the Two Samples Tested","Pay Adjustment Per Ton","AM and PM Samples","Tons of Asphalt Rubber Material Represented in Sample","Penalty Assessed in 1090035"]
[null,null,null,null,{"$f":"IF(A6=\"\",\"\",(VLOOKUP(C6,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B6=\"\",\"\",MAX(E6:E7))","v":""},{"$f":"IF(A6=\"\",\"\",(-(J$4-(J$4*F6%))))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",ROUND(I6*G6,2))","v":""}]
[null,null,null,null,{"$f":"IF(A7=\"\",\"\",(VLOOKUP(C7,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A8=\"\",\"\",(VLOOKUP(C8,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B8=\"\",\"\",MAX(E8:E9))","v":""},{"$f":"IF(A8=\"\",\"\",(-(J$4-(J$4*F8%))))","v":""},null,null,{"$f":"IF(A8=\"\",\"\",ROUND(I8*G8,2))","v":""}]
[null,null,null,null,{"$f":"IF(A9=\"\",\"\",(VLOOKUP(C9,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A10=\"\",\"\",(VLOOKUP(C10,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B10=\"\",\"\",MAX(E10:E11))","v":""},{"$f":"IF(A10=\"\",\"\",(-(J$4-(J$4*F10%))))","v":""},null,null,{"$f":"IF(A10=\"\",\"\",ROUND(I10*G10,2))","v":""}]
[null,null,null,null,{"$f":"IF(A11=\"\",\"\",(VLOOKUP(C11,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A12=\"\",\"\",(VLOOKUP(C12,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B12=\"\",\"\",MAX(E12:E13))","v":""},{"$f":"IF(A12=\"\",\"\",(-(J$4-(J$4*F12%))))","v":""},null,null,{"$f":"IF(A12=\"\",\"\",ROUND(I12*G12,2))","v":""}]
[null,null,null,null,{"$f":"IF(A13=\"\",\"\",(VLOOKUP(C13,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A14=\"\",\"\",(VLOOKUP(C14,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B14=\"\",\"\",MAX(E14:E15))","v":""},{"$f":"IF(A14=\"\",\"\",(-(J$4-(J$4*F14%))))","v":""},null,null,{"$f":"IF(A14=\"\",\"\",ROUND(I14*G14,2))","v":""}]
[null,null,null,null,{"$f":"IF(A15=\"\",\"\",(VLOOKUP(C15,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A16=\"\",\"\",(VLOOKUP(C16,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B16=\"\",\"\",MAX(E16:E17))","v":""},{"$f":"IF(A16=\"\",\"\",(-(J$4-(J$4*F16%))))","v":""},null,null,{"$f":"IF(A16=\"\",\"\",ROUND(I16*G16,2))","v":""}]
[null,null,null,null,{"$f":"IF(A17=\"\",\"\",(VLOOKUP(C17,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A18=\"\",\"\",(VLOOKUP(C18,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B18=\"\",\"\",MAX(E18:E19))","v":""},{"$f":"IF(A18=\"\",\"\",(-(J$4-(J$4*F18%))))","v":""},null,null,{"$f":"IF(A18=\"\",\"\",ROUND(I18*G18,2))","v":""}]
[null,null,null,null,{"$f":"IF(A19=\"\",\"\",(VLOOKUP(C19,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A20=\"\",\"\",(VLOOKUP(C20,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B20=\"\",\"\",MAX(E20:E21))","v":""},{"$f":"IF(A20=\"\",\"\",(-(J$4-(J$4*F20%))))","v":""},null,null,{"$f":"IF(A20=\"\",\"\",ROUND(I20*G20,2))","v":""}]
[null,null,null,null,{"$f":"IF(A21=\"\",\"\",(VLOOKUP(C21,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A22=\"\",\"\",(VLOOKUP(C22,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B22=\"\",\"\",MAX(E22:E23))","v":""},{"$f":"IF(A22=\"\",\"\",(-(J$4-(J$4*F22%))))","v":""},null,null,{"$f":"IF(A22=\"\",\"\",ROUND(I22*G22,2))","v":""}]
[null,null,null,null,{"$f":"IF(A23=\"\",\"\",(VLOOKUP(C23,'Table 1009-3'!B$2:C$22,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A24=\"\",\"\",(VLOOKUP(C24,'Table 1009-3'!B$2:C$22,2)))","v":""},{"$f":"IF(B24=\"\",\"\",MAX(E24:E25))","v":""},{"$f":"IF(A24=\"\",\"\",(-(J$4-(J$4*F24%))))","v":""},null,null,{"$f":"IF(A24=\"\",\"\",ROUND(I24*G24,2))","v":""}]
[null,null,null,null,{"$f":"IF(A25=\"\",\"\",(VLOOKUP(C25,'Table 1009-3'!B$2:C$22,2)))","v":""}]
["Total of Crumb Rubber Penalty on One Property Failure",null,null,null,null,null,null,null,{"$f":"SUM(J6:J25)","v":0}]

{"sheet":"PG Asphalt 1 Failure","index":1,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[17,1,18,1],[19,1,20,1],[21,1,22,1],[23,1,24,1],[7,1,8,1],[9,1,10,1],[11,1,12,1],[13,1,14,1],[15,1,16,1],[0,0,0,8],[7,5,8,5],[7,7,8,7],[7,8,8,8],[5,5,6,5],[5,7,6,7],[5,8,6,8],[2,0,2,8],[5,4,6,4],[7,4,8,4],[1,0,1,8],[5,1,6,1],[3,0,3,1],[3,3,3,4],[9,8,10,8],[9,4,10,4],[11,5,12,5],[11,7,12,7],[11,8,12,8],[11,4,12,4],[9,5,10,5],[9,7,10,7],[23,5,24,5],[23,7,24,7],[23,8,24,8],[23,4,24,4],[13,4,14,4],[15,5,16,5],[15,7,16,7],[15,8,16,8],[15,4,16,4],[13,8,14,8],[13,5,14,5],[13,7,14,7],[25,0,25,6],[25,7,25,8],[5,6,6,6],[3,6,3,7],[21,5,22,5],[21,7,22,7],[17,5,18,5],[17,7,18,7],[17,8,18,8],[17,4,18,4],[19,5,20,5],[19,7,20,7],[19,8,20,8],[19,4,20,4],[21,8,22,8],[21,4,22,4]]}
["PG Asphalt Binder Penalty - One Property Failure "]
["Reference Specs:  407-9, 416-9(F)(2), 417-9(F)(2) Adjustments in payment shall be made in accordance with the requirements of Subsection 1005-3.01, for the virgin binder only.  Also Reference Specs:  413-9, 414-9, 415-9(F) --->1009 ---> 2.01 Asphalt cement shall be a performance grade (PG) asphalt binder conforming to the requirements of Section 1005."]
["When the asphalt fails on one property, the pay adjustment is based on the lowest reduction of Contract Unit Price, so if one test fails at 85% and the other at 95%, the pay adjustment will be based on the 95%.  (If RAP material, only the Virgin Binder is penalized) (When the PG Binder fails in 413, 414 or 415, the entire Asphalt/Rubber blend tons used is penalized, per shift)"]
["TRACS No:",null,"H812701C","Asphalt Binder Pay Item Number",null,4040266,"Contract Unit Price",null,315]
["Sample Number & Phase","Sample Date","Test Property and Result","% of Contract Unit Price Allowed","Better Result of the Two Samples Tested","Pay Adjustment Per Ton","AM and PM Samples","Tons of Virgin Binder Represented in Sample","Penalty Assessed in 1090035"]
[null,null,null,{"$f":"IF(A6=\"\",\"\",(VLOOKUP(C6,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B6=\"\",\"\",MAX(D6:D7))","v":""},{"$f":"IF(A6=\"\",\"\",(-(I$4-(I$4*E6%))))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",ROUND(H6*F6,2))","v":""}]
[null,null,null,{"$f":"IF(A7=\"\",\"\",(VLOOKUP(C7,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A8=\"\",\"\",(VLOOKUP(C8,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B8=\"\",\"\",MAX(D8:D9))","v":""},{"$f":"IF(A8=\"\",\"\",(-(I$4-(I$4*E8%))))","v":""},null,null,{"$f":"IF(A8=\"\",\"\",ROUND(H8*F8,2))","v":""}]
[null,null,null,{"$f":"IF(A9=\"\",\"\",(VLOOKUP(C9,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A10=\"\",\"\",(VLOOKUP(C10,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B10=\"\",\"\",MAX(D10:D11))","v":""},{"$f":"IF(A10=\"\",\"\",(-(I$4-(I$4*E10%))))","v":""},null,null,{"$f":"IF(A10=\"\",\"\",ROUND(H10*F10,2))","v":""}]
[null,null,null,{"$f":"IF(A11=\"\",\"\",(VLOOKUP(C11,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A12=\"\",\"\",(VLOOKUP(C12,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B12=\"\",\"\",MAX(D12:D13))","v":""},{"$f":"IF(A12=\"\",\"\",(-(I$4-(I$4*E12%))))","v":""},null,null,{"$f":"IF(A12=\"\",\"\",ROUND(H12*F12,2))","v":""}]
[null,null,null,{"$f":"IF(A13=\"\",\"\",(VLOOKUP(C13,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A14=\"\",\"\",(VLOOKUP(C14,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B14=\"\",\"\",MAX(D14:D15))","v":""},{"$f":"IF(A14=\"\",\"\",(-(I$4-(I$4*E14%))))","v":""},null,null,{"$f":"IF(A14=\"\",\"\",ROUND(H14*F14,2))","v":""}]
[null,null,null,{"$f":"IF(A15=\"\",\"\",(VLOOKUP(C15,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A16=\"\",\"\",(VLOOKUP(C16,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B16=\"\",\"\",MAX(D16:D17))","v":""},{"$f":"IF(A16=\"\",\"\",(-(I$4-(I$4*E16%))))","v":""},null,null,{"$f":"IF(A16=\"\",\"\",ROUND(H16*F16,2))","v":""}]
[null,null,null,{"$f":"IF(A17=\"\",\"\",(VLOOKUP(C17,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A18=\"\",\"\",(VLOOKUP(C18,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B18=\"\",\"\",MAX(D18:D19))","v":""},{"$f":"IF(A18=\"\",\"\",(-(I$4-(I$4*E18%))))","v":""},null,null,{"$f":"IF(A18=\"\",\"\",ROUND(H18*F18,2))","v":""}]
[null,null,null,{"$f":"IF(A19=\"\",\"\",(VLOOKUP(C19,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A20=\"\",\"\",(VLOOKUP(C20,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B20=\"\",\"\",MAX(D20:D21))","v":""},{"$f":"IF(A20=\"\",\"\",(-(I$4-(I$4*E20%))))","v":""},null,null,{"$f":"IF(A20=\"\",\"\",ROUND(H20*F20,2))","v":""}]
[null,null,null,{"$f":"IF(A21=\"\",\"\",(VLOOKUP(C21,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A22=\"\",\"\",(VLOOKUP(C22,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B22=\"\",\"\",MAX(D22:D23))","v":""},{"$f":"IF(A22=\"\",\"\",(-(I$4-(I$4*E22%))))","v":""},null,null,{"$f":"IF(A22=\"\",\"\",ROUND(H22*F22,2))","v":""}]
[null,null,null,{"$f":"IF(A23=\"\",\"\",(VLOOKUP(C23,'Table 1005-1'!B5:C31,2)))","v":""}]
[null,null,null,{"$f":"IF(A24=\"\",\"\",(VLOOKUP(C24,'Table 1005-1'!B5:C31,2)))","v":""},{"$f":"IF(B24=\"\",\"\",MAX(D24:D25))","v":""},{"$f":"IF(A24=\"\",\"\",(-(I$4-(I$4*E24%))))","v":""},null,null,{"$f":"IF(A24=\"\",\"\",ROUND(H24*F24,2))","v":""}]
[null,null,null,{"$f":"IF(A25=\"\",\"\",(VLOOKUP(C25,'Table 1005-1'!B5:C31,2)))","v":""}]
["Total of PG Asphalt Binder Penalty on One Property Failure",null,null,null,null,null,null,{"$f":"SUM(I6:I25)","v":0}]

{"sheet":"PG Asphalt >1 Failure","index":2,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,9],[5,9,8,9],[5,5,8,5],[1,0,1,9],[2,0,2,9],[7,4,8,4],[3,3,3,5],[5,1,8,1],[3,7,3,8],[3,0,3,1],[5,4,6,4],[5,6,8,6],[5,8,8,8],[5,7,6,7],[7,7,8,7],[13,9,16,9],[17,8,20,8],[19,4,20,4],[15,4,16,4],[9,9,12,9],[13,8,16,8],[9,4,10,4],[11,4,12,4],[9,6,12,6],[9,8,12,8],[9,1,12,1],[13,1,16,1],[17,1,20,1],[13,4,14,4],[17,6,20,6],[13,5,16,5],[17,5,20,5],[17,4,18,4],[9,5,12,5],[13,6,16,6],[25,8,25,9],[25,0,25,7],[21,5,24,5],[21,6,24,6],[21,8,24,8],[21,1,24,1],[21,9,24,9],[21,4,22,4],[23,4,24,4],[17,9,20,9]]}
["PG Asphalt Binder Penalty - More than one Property Failure"]
["Reference Specs:  407-9, 416-9(F)(2), 417-9(F)(2) Adjustments in payment shall be made in accordance with the requirements of Subsection 1005-3.01, for the virgin binder only.  Also                                                 Reference Specs:  413-9, 414-9, 415-9(F) --->1009 ---> 2.01 Asphalt cement shall be a performance grade (PG) asphalt binder conforming to the requirements of Section 1005."]
["When the asphalt fails on more than one property, the pay adjustment is based on the greatest reduction of Contract Unit Price.  This means you take the better result of each property failure.  Then, out of the separate property failures, the pay adjustment is based on the worst penalty.  (If RAP material, only the Virgin Binder is penalized) (When the PG Binder fails in 413, 414 or 415, the entire Asphalt/Rubber blend tons used is penalized, per shift)"]
["TRACS No.",null,"H880001C","Asphalt Binder Pay Item Number",null,null,4040282,"Contract Unit Price",null,500]
["Sample Number & Phase","Date","Failed on Test Properties","% of Contract Unit Price Allowed","Better Result of the Two Samples Tested","Greatest Reduction to the Contract Unit Price","Pay Adjustment Per Ton","AM and PM Samples","Tons of Virgin Binder Represented in Sample","Penalty Assessed in 1090035"]
[null,null,null,{"$f":"IF(A6=\"\",\"\",(VLOOKUP(C6,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B6=\"\",\"\",MAX(D6:D7))","v":""},{"$f":"IF(B6=\"\",\"\",MIN(E6:E9))","v":""},{"$f":"IF(A6=\"\",\"\",-(J$4-(J$4*F6%)))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",ROUND(I6*G6,2))","v":""}]
[null,null,null,{"$f":"IF(A7=\"\",\"\",(VLOOKUP(C7,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A8=\"\",\"\",(VLOOKUP(C8,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B6=\"\",\"\",MAX(D8:D9))","v":""}]
[null,null,null,{"$f":"IF(A9=\"\",\"\",(VLOOKUP(C9,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A10=\"\",\"\",(VLOOKUP(C10,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B10=\"\",\"\",MAX(D10:D11))","v":""},{"$f":"IF(B10=\"\",\"\",MIN(E10:E13))","v":""},{"$f":"IF(A10=\"\",\"\",-(J$4-(J$4*F10%)))","v":""},null,null,{"$f":"IF(A10=\"\",\"\",ROUND(I10*G10,2))","v":""}]
[null,null,null,{"$f":"IF(A11=\"\",\"\",(VLOOKUP(C11,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A12=\"\",\"\",(VLOOKUP(C12,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B10=\"\",\"\",MAX(D12:D13))","v":""}]
[null,null,null,{"$f":"IF(A13=\"\",\"\",(VLOOKUP(C13,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A14=\"\",\"\",(VLOOKUP(C14,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B14=\"\",\"\",MAX(D14:D15))","v":""},{"$f":"IF(B14=\"\",\"\",MIN(E14:E17))","v":""},{"$f":"IF(A14=\"\",\"\",-(J$4-(J$4*F14%)))","v":""},null,null,{"$f":"IF(A14=\"\",\"\",ROUND(I14*G14,2))","v":""}]
[null,null,null,{"$f":"IF(A15=\"\",\"\",(VLOOKUP(C15,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A16=\"\",\"\",(VLOOKUP(C16,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B14=\"\",\"\",MAX(D16:D17))","v":""}]
[null,null,null,{"$f":"IF(A17=\"\",\"\",(VLOOKUP(C17,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A18=\"\",\"\",(VLOOKUP(C18,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B18=\"\",\"\",MAX(D18:D19))","v":""},{"$f":"IF(B18=\"\",\"\",MIN(E18:E21))","v":""},{"$f":"IF(A18=\"\",\"\",-(J$4-(J$4*F18%)))","v":""},null,null,{"$f":"IF(A18=\"\",\"\",ROUND(I18*G18,2))","v":""}]
[null,null,null,{"$f":"IF(A19=\"\",\"\",(VLOOKUP(C19,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A20=\"\",\"\",(VLOOKUP(C20,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B18=\"\",\"\",MAX(D20:D21))","v":""}]
[null,null,null,{"$f":"IF(A21=\"\",\"\",(VLOOKUP(C21,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A22=\"\",\"\",(VLOOKUP(C22,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B22=\"\",\"\",MAX(D22:D23))","v":""},{"$f":"IF(B22=\"\",\"\",MIN(E22:E25))","v":""},{"$f":"IF(A22=\"\",\"\",-(J$4-(J$4*F22%)))","v":""},null,null,{"$f":"IF(A22=\"\",\"\",ROUND(I22*G22,2))","v":""}]
[null,null,null,{"$f":"IF(A23=\"\",\"\",(VLOOKUP(C23,'Table 1005-1'!B$5:C$31,2)))","v":""}]
[null,null,null,{"$f":"IF(A24=\"\",\"\",(VLOOKUP(C24,'Table 1005-1'!B$5:C$31,2)))","v":""},{"$f":"IF(B22=\"\",\"\",MAX(D24:D25))","v":""}]
[null,null,null,{"$f":"IF(A25=\"\",\"\",(VLOOKUP(C25,'Table 1005-1'!B$5:C$31,2)))","v":""}]
["Total of PG Asphalt Binder Penalties on More Than One Property Failure",null,null,null,null,null,null,null,{"$f":"SUM(J6:J25)","v":0}]

{"sheet":"Emulsified Asphalt Failure","index":3,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[4,1,4,2],[5,1,5,2],[6,1,6,2],[4,5,4,6],[4,3,4,4],[5,3,5,4],[6,3,6,4],[6,5,6,6],[5,5,5,6],[2,0,2,2],[2,3,2,4],[2,5,2,10],[15,1,15,2],[16,1,16,2],[17,1,17,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,3,13,4],[12,3,12,4],[13,5,13,6],[13,1,13,2],[14,1,14,2],[14,3,14,4],[14,5,14,6],[15,3,15,4],[16,3,16,4],[17,3,17,4],[17,5,17,6],[16,5,16,6],[15,5,15,6],[7,3,7,4],[7,1,7,2],[12,5,12,6],[11,5,11,6],[10,5,10,6],[9,5,9,6],[7,5,7,6],[8,5,8,6],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4]]}
["Emulsified Asphalt Binder Penalty"]
["Reference Spec: 1005-3.03  Emulsified asphalt must meet the specified minimum percent residue.  If it doesn't, the adjustment is determined by the following:  Use worksheet to figure the penalty which is assessed in pay item 1090035."]
["TRACS No."]
["Date","Percent  Residue From Testing","/","Specified Minimum % Residue","X","Contract Unit Price","=","Asphalt Contract Unit Price","Pay Adjustment Per Ton","Tons of Binder Represented in the Sample","Penalty Assessed in 1090035"]
[null,null,null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",ROUND((B5/D5)*F5,2))","v":""},{"$f":"IF(A5=\"\",\"\",-(F5-H5))","v":""},null,{"$f":"IF(A5=\"\",\"\",I5*J5)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",ROUND((B6/D6)*F6,2))","v":""},{"$f":"IF(A6=\"\",\"\",-(F6-H6))","v":""},null,{"$f":"IF(A6=\"\",\"\",I6*J6)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(A7=\"\",\"\",-(F7-H7))","v":""},null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,"","",null,""]

{"sheet":"409 Asphalt 1 Failure ","index":4,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,5,23,5],[10,5,11,5],[12,5,13,5],[14,5,15,5],[16,5,17,5],[18,5,19,5],[24,7,24,9],[16,1,17,1],[16,9,17,9],[18,1,19,1],[18,9,19,9],[24,0,24,6],[20,1,21,1],[20,4,21,4],[20,9,21,9],[22,9,23,9],[22,1,23,1],[22,4,23,4],[22,8,23,8],[16,8,17,8],[18,8,19,8],[20,8,21,8],[4,1,5,1],[4,4,5,4],[4,9,5,9],[2,0,2,1],[4,5,5,5],[0,0,0,9],[1,0,1,9],[2,3,2,9],[10,9,11,9],[6,8,7,8],[4,8,5,8],[10,1,11,1],[10,4,11,4],[6,9,7,9],[8,1,9,1],[8,4,9,4],[8,8,9,8],[10,8,11,8],[6,5,7,5],[8,5,9,5],[6,1,7,1],[6,4,7,4],[8,9,9,9],[12,9,13,9],[16,4,17,4],[12,8,13,8],[14,4,15,4],[14,8,15,8],[12,1,13,1],[12,4,13,4],[18,4,19,4],[14,9,15,9],[20,5,21,5],[14,1,15,1]]}
["409 Reduction for Noncompliance - One Property Failure"]
["Reference Spec: 409-5.02  A reduction in payment to the contractor for asphaltic concrete will be made for quantities of asphalt cement (bituminous material) that do not meet the requirements of Section 1005 as determined by corresponding test results.  Adjustments in payment will be made in accordance with the requirements of Table 1005-1 and the following formula:  R = (100 - P) X [ (CP X T ) / 100]"]
["TRACS No."]
["Sample Number & Phase","Date","Failed on Test Property and                         Test Result ","% of Contract Unit Price Allowed","Better Result of the Two Samples Tested (P)","Current Price (CP) for Bituminous Material ","Tons of 409 Mix   5% of 409 Mix","AM and PM Samples","Tons (T) of Virgin Binder Represented in Sample","Penalty Assessed in 1090035 (R)"]
[null,null,null,{"$f":"IF(A5=\"\",\"\",(VLOOKUP(C5,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B5=\"\",\"\",MAX(D5:D6))","v":""},null,null,null,null,{"$f":"IF(A5=\"\",\"\",-ROUND((100-E5)*(F5*I5)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A6=\"\",\"\",(VLOOKUP(C6,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G5*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A7=\"\",\"\",(VLOOKUP(C7,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B7=\"\",\"\",MAX(D7:D8))","v":""},null,null,null,null,{"$f":"IF(A7=\"\",\"\",-ROUND((100-E7)*(F7*I7)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A8=\"\",\"\",(VLOOKUP(C8,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G7*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A9=\"\",\"\",(VLOOKUP(C9,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B9=\"\",\"\",MAX(D9:D10))","v":""},null,null,null,null,{"$f":"IF(A9=\"\",\"\",-ROUND((100-E9)*(F9*I9)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A10=\"\",\"\",(VLOOKUP(C10,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G9*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A11=\"\",\"\",(VLOOKUP(C11,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B11=\"\",\"\",MAX(D11:D12))","v":""},null,null,null,null,{"$f":"IF(A11=\"\",\"\",-ROUND((100-E11)*(F11*I11)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A12=\"\",\"\",(VLOOKUP(C12,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G11*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A13=\"\",\"\",(VLOOKUP(C13,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B13=\"\",\"\",MAX(D13:D14))","v":""},null,null,null,null,{"$f":"IF(A13=\"\",\"\",-ROUND((100-E13)*(F13*I13)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A14=\"\",\"\",(VLOOKUP(C14,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G13*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A15=\"\",\"\",(VLOOKUP(C15,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B15=\"\",\"\",MAX(D15:D16))","v":""},null,null,null,null,{"$f":"IF(A15=\"\",\"\",-ROUND((100-E15)*(F15*I15)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A16=\"\",\"\",(VLOOKUP(C16,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G15*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A17=\"\",\"\",(VLOOKUP(C17,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B17=\"\",\"\",MAX(D17:D18))","v":""},null,null,null,null,{"$f":"IF(A17=\"\",\"\",-ROUND((100-E17)*(F17*I17)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A18=\"\",\"\",(VLOOKUP(C18,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G17*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A19=\"\",\"\",(VLOOKUP(C19,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B19=\"\",\"\",MAX(D19:D20))","v":""},null,null,null,null,{"$f":"IF(A19=\"\",\"\",-ROUND((100-E19)*(F19*I19)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A20=\"\",\"\",(VLOOKUP(C20,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G19*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A21=\"\",\"\",(VLOOKUP(C21,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B21=\"\",\"\",MAX(D21:D22))","v":""},null,null,null,null,{"$f":"IF(A21=\"\",\"\",-ROUND((100-E21)*(F21*I21)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A22=\"\",\"\",(VLOOKUP(C22,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G21*0.05,2)","v":0}]
[null,null,null,{"$f":"IF(A23=\"\",\"\",(VLOOKUP(C23,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B23=\"\",\"\",MAX(D23:D24))","v":""},null,null,null,null,{"$f":"IF(A23=\"\",\"\",-ROUND((100-E23)*(F23*I23)/100,2))","v":""}]
[null,null,null,{"$f":"IF(A24=\"\",\"\",(VLOOKUP(C24,'Table 1005-1'!B$5:C$21,2)))","v":""},null,null,{"$f":"ROUND(G23*0.05,2)","v":0}]
["Total of 409 Asphalt Binder Penalty on One Property Failure",null,null,null,null,null,null,{"$f":"SUM(J5:J24)","v":0}]

{"sheet":"409 Asphalt >1 Failure","index":5,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,9,36,11],[32,8,33,8],[34,8,35,8],[0,0,0,11],[1,0,1,11],[2,4,2,11],[2,0,2,1],[2,2,2,3],[36,0,36,8],[32,10,35,10],[12,11,15,11],[4,1,7,1],[12,1,15,1],[12,2,13,2],[4,7,7,7],[8,7,11,7],[28,8,29,8],[8,11,11,11],[10,2,11,2],[6,2,7,2],[6,5,7,5],[4,11,7,11],[4,8,5,8],[6,8,7,8],[8,8,9,8],[10,8,11,8],[4,6,7,6],[4,2,5,2],[4,5,5,5],[10,5,11,5],[8,2,9,2],[12,9,13,9],[20,10,23,10],[16,5,17,5],[16,6,19,6],[14,2,15,2],[12,8,13,8],[14,8,15,8],[16,8,17,8],[18,8,19,8],[20,11,23,11],[22,9,23,9],[24,9,25,9],[4,10,7,10],[8,10,11,10],[4,9,5,9],[6,9,7,9],[8,9,9,9],[10,9,11,9],[14,9,15,9],[32,11,35,11],[34,2,35,2],[34,5,35,5],[16,11,19,11],[12,10,15,10],[12,5,13,5],[28,11,31,11],[30,2,31,2],[16,10,19,10],[28,10,31,10],[18,2,19,2],[18,5,19,5],[16,9,17,9],[18,9,19,9],[28,9,29,9],[30,9,31,9],[24,10,27,10],[20,5,21,5],[20,6,23,6],[20,7,23,7],[20,8,21,8],[20,9,21,9],[20,2,21,2],[24,11,27,11],[8,1,11,1],[14,5,15,5],[12,7,15,7],[16,7,19,7],[8,6,11,6],[12,6,15,6],[8,5,9,5],[30,8,31,8],[28,2,29,2],[28,5,29,5],[28,6,31,6],[24,2,25,2],[24,5,25,5],[24,6,27,6],[26,2,27,2],[26,5,27,5],[26,8,27,8],[22,2,23,2],[22,5,23,5],[22,8,23,8],[24,7,27,7],[24,8,25,8],[16,1,19,1],[16,2,17,2],[20,1,23,1],[24,1,27,1],[32,1,35,1],[32,2,33,2],[32,5,33,5],[32,6,35,6],[32,9,33,9],[34,9,35,9],[32,7,35,7],[28,7,31,7],[30,5,31,5],[28,1,31,1],[26,9,27,9]]}
["409 Reduction for Noncompliance - More than one Property Failure"]
["Reference Spec: 409-5.02  A reduction in payment to the contractor for asphaltic concrete will be made for quantities of asphalt cement (bituminous material) that do not meet the requirements of Section 1005 as determined by corresponding test results.  Adjustments in payment will be made in accordance with the requirements of Table 1005-1 and the following formula:  R = (100 - P) X [ (CP X T ) / 100]"]
["TRACS No."]
["Sample Number & Phase","Date","Failed on Test Property","Test Result Range","% of Contract Unit Price Allowed","Better Result of the Two Samples Tested","Greatest Reduction to the Contract Unit Price  (P)","Current Price (CP) for Bituminous Material ","Tons of 409 Mix   5% of 409 Mix","AM and PM Samples","Tons (T) of Virgin Binder Represented in Sample","Penalty Assessed in 1090035              (R)"]
[null,null,null,null,{"$f":"IF(A5=\"\",\"\",(VLOOKUP(D5,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B5=\"\",\"\",MAX(E5:E6))","v":""},{"$f":"IF(B5=\"\",\"\",MIN(F5:F8))","v":""},null,null,null,null,{"$f":"IF(A5=\"\",\"\",-ROUND((100-G5)*(H5*K5)/100,2))","v":""}]
[null,null,null,null,{"$f":"IF(A6=\"\",\"\",(VLOOKUP(D6,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A7=\"\",\"\",(VLOOKUP(D7,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B5=\"\",\"\",MAX(E7:E8))","v":""},null,null,{"$f":"ROUND(I5*0.05,2)","v":0}]
[null,null,null,null,{"$f":"IF(A8=\"\",\"\",(VLOOKUP(D8,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A9=\"\",\"\",(VLOOKUP(D9,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B9=\"\",\"\",MAX(E9:E10))","v":""},{"$f":"IF(B9=\"\",\"\",MIN(F9:F12))","v":""},null,null,null,null,{"$f":"IF(A9=\"\",\"\",-ROUND((100-G9)*(H9*K9)/100,2))","v":""}]
[null,null,null,null,{"$f":"IF(A10=\"\",\"\",(VLOOKUP(D10,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A11=\"\",\"\",(VLOOKUP(D11,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B9=\"\",\"\",MAX(E11:E12))","v":""},null,null,{"$f":"ROUND(I9*0.05,2)","v":0}]
[null,null,null,null,{"$f":"IF(A12=\"\",\"\",(VLOOKUP(D12,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A13=\"\",\"\",(VLOOKUP(D13,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B13=\"\",\"\",MAX(E13:E14))","v":""},{"$f":"IF(B13=\"\",\"\",MIN(F13:F16))","v":""},null,null,null,null,{"$f":"IF(A13=\"\",\"\",-ROUND((100-G13)*(H13*K13)/100,2))","v":""}]
[null,null,null,null,{"$f":"IF(A14=\"\",\"\",(VLOOKUP(D14,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A15=\"\",\"\",(VLOOKUP(D15,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B13=\"\",\"\",MAX(E15:E16))","v":""},null,null,{"$f":"ROUND(I13*0.05,2)","v":0}]
[null,null,null,null,{"$f":"IF(A16=\"\",\"\",(VLOOKUP(D16,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A17=\"\",\"\",(VLOOKUP(D17,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B17=\"\",\"\",MAX(E17:E18))","v":""},{"$f":"IF(B17=\"\",\"\",MIN(F17:F20))","v":""},null,null,null,null,{"$f":"IF(A17=\"\",\"\",-ROUND((100-G17)*(H17*K17)/100,2))","v":""}]
[null,null,null,null,{"$f":"IF(A18=\"\",\"\",(VLOOKUP(D18,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A19=\"\",\"\",(VLOOKUP(D19,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B17=\"\",\"\",MAX(E19:E20))","v":""},null,null,{"$f":"ROUND(I17*0.05,2)","v":0}]
[null,null,null,null,{"$f":"IF(A20=\"\",\"\",(VLOOKUP(D20,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A21=\"\",\"\",(VLOOKUP(D21,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B21=\"\",\"\",MAX(E21:E22))","v":""},{"$f":"IF(B21=\"\",\"\",MIN(F21:F24))","v":""},null,null,null,null,{"$f":"IF(A21=\"\",\"\",-ROUND((100-G21)*(H21*K21)/100,2))","v":""}]
[null,null,null,null,{"$f":"IF(A22=\"\",\"\",(VLOOKUP(D22,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A23=\"\",\"\",(VLOOKUP(D23,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B21=\"\",\"\",MAX(E23:E24))","v":""},null,null,{"$f":"ROUND(I21*0.05,2)","v":0}]
[null,null,null,null,{"$f":"IF(A24=\"\",\"\",(VLOOKUP(D24,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A25=\"\",\"\",(VLOOKUP(D25,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B25=\"\",\"\",MAX(E25:E26))","v":""},{"$f":"IF(B25=\"\",\"\",MIN(F25:F28))","v":""},null,null,null,null,{"$f":"IF(A25=\"\",\"\",-ROUND((100-G25)*(H25*K25)/100,2))","v":""}]
[null,null,null,null,{"$f":"IF(A26=\"\",\"\",(VLOOKUP(D26,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A27=\"\",\"\",(VLOOKUP(D27,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B25=\"\",\"\",MAX(E27:E28))","v":""},null,null,{"$f":"ROUND(I25*0.05,2)","v":0}]
[null,null,null,null,{"$f":"IF(A28=\"\",\"\",(VLOOKUP(D28,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A29=\"\",\"\",(VLOOKUP(D29,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B29=\"\",\"\",MAX(E29:E30))","v":""},{"$f":"IF(B29=\"\",\"\",MIN(F29:F32))","v":""},null,null,null,null,{"$f":"IF(A29=\"\",\"\",-ROUND((100-G29)*(H29*K29)/100,2))","v":""}]
[null,null,null,null,{"$f":"IF(A30=\"\",\"\",(VLOOKUP(D30,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A31=\"\",\"\",(VLOOKUP(D31,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B29=\"\",\"\",MAX(E31:E32))","v":""},null,null,{"$f":"ROUND(I29*0.05,2)","v":0}]
[null,null,null,null,{"$f":"IF(A32=\"\",\"\",(VLOOKUP(D32,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A33=\"\",\"\",(VLOOKUP(D33,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B33=\"\",\"\",MAX(E33:E34))","v":""},{"$f":"IF(B33=\"\",\"\",MIN(F33:F36))","v":""},null,null,null,null,{"$f":"IF(A33=\"\",\"\",-ROUND((100-G33)*(H33*K33)/100,2))","v":""}]
[null,null,null,null,{"$f":"IF(A34=\"\",\"\",(VLOOKUP(D34,'Table 1005-1'!B$5:C$21,2)))","v":""}]
[null,null,null,null,{"$f":"IF(A35=\"\",\"\",(VLOOKUP(D35,'Table 1005-1'!B$5:C$21,2)))","v":""},{"$f":"IF(B33=\"\",\"\",MAX(E35:E36))","v":""},null,null,{"$f":"ROUND(I33*0.05,2)","v":0}]
[null,null,null,null,{"$f":"IF(A36=\"\",\"\",(VLOOKUP(D36,'Table 1005-1'!B$5:C$21,2)))","v":""}]
["Total of 409 Asphalt Binder Penalties on More Than One Property Failure",null,null,null,null,null,null,null,null,{"$f":"SUM(L5:L36)","v":0}]

{"sheet":"Table 1005-1","index":6,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[22,3,23,3],[0,3,0,5],[1,3,1,5],[4,3,5,3],[8,3,9,3],[13,3,14,3],[18,3,19,3]]}
[null,null,null,"TABLE 1005-1"]
[null,null,null,"ASPHALT BINDER ADJUSTMENT TABLE"]
[null,null,null,"Test Property","Test Result","Percent of Contract Unit Price Allowed"]
["Test Property","Test Property and Result","Percent","Dynamic Shear of ","≥ 1.00",100]
["m-value","Creep Stiffness of PAV Binder > 600",65,"Original Binder:               ","0.90 - 0.99",95]
["Original Binder: G*/Sin , kPa","Creep Stiffness of PAV Binder 301 - 330",95,null,"0.70 - 0.89",85]
["RTFO Binder: G*/Sin, kPa","Creep Stiffness of PAV Binder 331 - 450",85,"G* / Sin Delta, kPa","< 0.70",70]
["Creep Stiffness of PAV Binder","Creep Stiffness of PAV Binder 451 - 600",75,"Dynamic Shear of           ","≥ 2.20",100]
["PAV Binder: G*/Sin, kPa","Elastic Recovery, @ 10∘C, %, minimum < 50",70,"RTFO Binder:              ","2.00 - 2.19",95]
["m-value","Elastic Recovery, @ 10∘C, %, minimum 50 - 54",85,null,"1.60 - 1.99",85]
["m-value","m-value < 0.230",65," G* / Sin Delta, kPa","< 1.60",70]
["Original Binder: G*/Sin , kPa","m-value 0.230 - 0.269",80,null,"≤ 5000",100]
["Original Binder: G*/Sin , kPa","m-value 0.270 - 0.299",95,"Dynamic Shear of","5001 - 5500",95]
["RTFO Binder: G*/Sin, kPa","Original Binder: G*/Sin , kPa < 0.70",70,"PAV Binder:         ","5501 - 7000",85]
["RTFO Binder: G*/Sin, kPa","Original Binder: G*/Sin , kPa 0.70 - 0.89",85,null,"7001 - 8000",75]
["Creep Stiffness of PAV Binder","Original Binder: G*/Sin , kPa 0.90 - 0.99",95,"G* Sin Delta, kPa","> 8000",65]
["Creep Stiffness of PAV Binder","PAV Binder: G*/Sin, kPa > 8000",65,null,"≤ 300",100]
["Creep Stiffness of PAV Binder","PAV Binder: G*/Sin, kPa 5001 - 5500",95,"Creep Stiffness      ","301 - 330",95]
["PAV Binder: G*/Sin, kPa","PAV Binder: G*/Sin, kPa 5501 - 7000",85,"PAV Binder:                 ","331 - 450",85]
["PAV Binder: G*/Sin, kPa","PAV Binder: G*/Sin, kPa 7001 - 8000",75,null,"451 - 600",75]
["PAV Binder: G*/Sin, kPa","Phase Angle (δ) @70 ∘C @ 10 rad/sec degrees max 76 - 83",85,"  S, Mpa","> 600",65]
[null,"Phase Angle (δ) @70 ∘C @ 10 rad/sec degrees, max > 83",65,null,"≥ 0.300",100]
[null,"RTFO Binder: G*/Sin, kPa < 1.60",70,"m-value at 60 sec.","0.270 - 0.299",95]
[null,"RTFO Binder: G*/Sin, kPa 1.60 - 1.99",85,null,"0.230 - 0.269",80]
[null,"RTFO Binder: G*/Sin, kPa 2.00 - 2.19",95,null,"< 0.230",65]
[null,"Softening Point, ∘C, minimum < 47",70]
[null,"Softening Point, ∘C, minimum < 51",70]
[null,"Softening Point, ∘C, minimum < 57",70]
[null,"Softening Point, ∘C, minimum 47 - 49",85]
[null,"Softening Point, ∘C, minimum 51 - 53",85]
[null,"Softening Point, ∘C, minimum 57 - 59",85]

{"sheet":"Table 1009-3","index":7,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,6,17,12],[2,6,4,6],[2,7,2,8],[2,9,2,10],[0,6,0,12],[1,6,1,12],[2,11,2,12],[16,6,16,12]]}
[null,"Test Property and Test Results","Percentage",null,null,null,"TABLE 1009-3"]
[null,"CRA 1 Penetration < 8",70,null,null,null,"ASPHALT - RUBBER PAY ADJUSTMENT TABLE"]
[null,"CRA 1 Penetration 8 - 9",85,null,null,null,"Test Property","CRA Type 1",null,"CRA Type 2",null,"CRA Type 3"]
[null,"CRA 1 Resilience < 18",50,null,null,null,null,null,"Percent of Contract",null,"Percent of Contract",null,"Percent of Contract"]
[null,"CRA 1 Resilience 18 - 23",70,null,null,null,null,"Test Value","Unit Price Allowed","Test Value","Unit Price Allowed","Test Value","Unit Price Allowed"]
[null,"CRA 1 Resilience 24 - 29",85,null,null,null,"Penetration","≥ 10",100,"≥15",100,"≥ 25",100]
[null,"CRA 1 Softening Point < 55",70,null,null,null,null,"8 - 9",85,"13 - 14",85,"23 - 24",85]
[null,"CRA 1 Softening Point 55 - 56",85,null,null,null,null,"< 8","70*","< 13","70*","< 23","70*"]
[null,"CRA 2 Penetration < 13",70,null,null,null,"Softening Point","≥ 57",100,"≥ 54",100,"≥ 52",100]
[null,"CRA 2 Penetration 13 - 14",85,null,null,null,null,"55 - 56",85,"52 - 53",85,"50 - 51",85]
[null,"CRA 2 Resilience < 10",50,null,null,null,null,"< 55","70*"," < 52","70*","< 50","70*"]
[null,"CRA 2 Resilience 10 - 14",70,null,null,null,"Resilience","≥ 25",100,"≥ 20",100,"≥15",100]
[null,"CRA 2 Resilience 15 - 19",85,null,null,null,null,"20 - 24",85,"15 - 19",85,"10 - 14",85]
[null,"CRA 2 Softening Point < 52",70,null,null,null,null,"15 - 19",70,"10 - 14",70,"6 - 9",70]
[null,"CRA 2 Softening Point 52 - 53",85,null,null,null,null,"< 15","50*","< 10","50*","< 6","50*"]
[null,"CRA 3 Penetration < 23",70,null,null,null,"* Reject Status:  The pay adjustment applies If allowed to remain in place."]
[null,"CRA 3 Penetration 23 - 24",85,null,null,null,"Should the asphalt -rubber be deficient on more than one property, the pay adjustment will be the greatest  "]
[null,"CRA 3 Resilience < 6",50,null,null,null,"reduction to the contract unit price specified considering individual test results."]
[null,"CRA 3 Resilience 6 - 9",70]
[null,"CRA 3 Resilience 10 - 14",85]
[null,"CRA 3 Softening Point < 50",70]
[null,"CRA 3 Softening Point 50 - 51",85]