{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":[" Asphalt Base Tab 1"," Structural Tab 1","Friction Tab 1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":" Asphalt Base Tab 1","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[21,8,23,8],[12,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[20,0,20,4],[21,0,23,4],[0,0,0,6],[0,11,2,11],[1,1,1,6],[2,0,2,1],[2,3,2,5],[25,0,26,4],[11,0,11,4],[7,0,7,5],[8,0,8,4],[8,5,8,6],[9,0,9,4],[10,0,10,4],[19,0,19,4]]}
["SQUARE YARDS",null,null,null,null,null,null,null,"Total SY's"]
["Pay Item:",null,null,null,null,null,null,null,{"$f":"SUM(J2:XFD2)","v":0}]
["Thickness (in):",null,null,"Unit Price:"]
["LOT NUMBER","Lot Tonnage from QCRR","LOT Gmm (from QCRR)","CPF ","LOT Total (SY) ","ADJUSTED UNIT PRICE","CPF Adjustment **Pay as LOTs close**",null,"Verify SY Totals"]
[null,null,null,null,null,{"$f":"IF(E5=\"\",\"\",ROUND((D5-1)*$G$3,2))","v":""},{"$f":"IF(F5=\"\",\"\",F5*E5)","v":""},null,{"$f":"SUM(INDIRECT(\"J5:XFD5\"))","v":{"$error":"#DIV/0!"}},{"$f":"$E5*($J$2/($I$2))","v":{"$error":"#DIV/0!"}}]
[null,"Total Tonnage (CHECK to match QCRR)","Tonnage-Weighted Average Gmm (from QCRR)","Average CPF","Total Square Yards  (CHECK to match QCRR)","Total CPF Adjustments:",{"$f":"IF(ROW()<=5,0,SUM(G5:INDEX(G:G,ROW()-1)))","v":0},null,"Total SY's        (CHECK to match QCRR)"]
["Totals",{"$f":"SUM(INDIRECT(ADDRESS(5,COLUMN()) & \":\" & ADDRESS(ROW()-1,COLUMN())))","v":0},{"$f":"IF(ROW()<=5,\"\",IF(INDIRECT(\"B\"&ROW())=\"\",\"\",ROUND(SUMPRODUCT(C$5:INDEX(C:C,ROW()-1),B$5:INDEX(B:B,ROW()-1))/SUM(B$5:INDEX(B:B,ROW()-1)),10)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C7=\"\",\"\",ROUND(AVERAGE(INDIRECT(\"D5:D\" & ROW()-1)),2))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(INDIRECT(ADDRESS(5,COLUMN()) & \":\" & ADDRESS(ROW()-1,COLUMN())))","v":0},"Corrected CPF Adjustment (G103)",{"$f":"IF(C7=\"\",\"\",G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(J7:XFD7)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(INDIRECT(ADDRESS(5,COLUMN()) & \":\" & ADDRESS(ROW()-1,COLUMN())))","v":{"$error":"#DIV/0!"}}]
["Total Project CPF payments:",null,null,null,null,null,{"$f":"SUM(G6:G7)","v":{"$error":"#DIV/0!"}}]
["Form Instructions:"]
["1) Manually enter data into the yellow boxes.",null,null,null,null,"Plan Quantity (SY)",null,"*Check that QCRR Matches Plans"]
["2) Asphalt Base is a Plan Quantity (PQ) pay item and it receives adjustments limited to 105% or 110% of the Designed Surface Area. See Examples of Adjustments in CPAM 11.4. ",null,null,null,null,"Engineer Changes (SY)",null,"*Check that QCRR Matches Plans"]
["3) This form is a tool for FE Tracking. Use the QCRR to track quantities and adjustments. Limit payment to 105% or 110% of the Designed Surface Area. Paying for tonnage over the maximum Designed Surface Area will result in a negative line item adjustment.",null,null,null,null,"Total Plan Quantity w/ Changes (SY)                Designed Surface Area",{"$f":"G10+G11","v":0},"*Check that QCRR Matches Plans"]
["NOTE: Rounding issues may occur due to the decimal places for the Tonnage-Weighted Average Gmm. Verify the Adjusted PQ and Spec. Limit Amount compare closely to the QCRR. ",null,null,null,null,"Adjusted PQ (TN)",{"$f":"IF(G12=\"\",\"\",ROUND(G12*C3*C7*43.3/2000,2))","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Pay Area (per 234-9) (SY) ",{"$f":"IF(C7=\"\",\"\",ROUND(G12*(B7/G13),0))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Spec Limit per Contract (enter as 0, 1.05, or 1.10)",null,"*Determine by Spec Year"]
[null,null,null,null,null,"105% or 110% Max Designed Surface Area (SY)",{"$f":"IF(G16=\"\",\"\",IF(G12=\"\",\"\",G12*G16))","v":""}]
[]
[null,null,null,null,null,"Final Pay Area (SY)",{"$f":"IF(G15>G17,G17,G15)","v":{"$error":"#DIV/0!"}}]
["4) The Pay Quantity Adjustment is made after all Base is placed and assumes payment has been made for the Plan Quantity.",null,null,null,null,"Pay Quantity Adjustment (SY)",{"$f":"IF(G12=\"\",\"\",ROUND(G19-G12,0))","v":{"$error":"#DIV/0!"}},"*Verify against QCRR"]
["5) Bituminous Correction to account for the difference between the tonnage placed and the final pay quantity. Use the index for the last month in which paving occurred.",null,null,null,null,"Bituminous Correction (TN) ",{"$f":"IF(I26>I27,I27-I26,0)","v":{"$error":"#DIV/0!"}}]
["6) CPF Correction is made after all Base is placed and assumes payment for asphalt base and CPF has been made for the Plan Quantity. The Average CPF is used when a positive or negative adjustment is made per CPAM 11.4.",null,null,null,null,"CPF Correction (SY)",{"$f":"ROUND(G20,0)","v":{"$error":"#DIV/0!"}},null,"Tonnage\n(Tonnage-Weighted Average Gmm)"]
[null,null,null,null,null,"Average CPF Adjusted Unit Price",{"$f":"IF(D7=\"\",\"\",(ROUND(((D7-1)*G3),2)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Correction CPF Adjustment ($)",{"$f":"IF(G22=\"\",\"\",G22*G23)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Adjusted PQ Tonnage",{"$f":"IF(G12=\"\",\"\",G12*$C$3*C7*43.3/2000)","v":{"$error":"#DIV/0!"}}]
["7) Adjustments on Lump Sum/Design-Build (LD/DB) Contracts are paid per CPAM 6.2 and the Contract Special Provisions.",null,null,null,null,"LS/DB Contract Pay Qty. Adjustment",{"$f":"IF(G19=\"\",\"\",ROUND(G19-G12,0))","v":{"$error":"#DIV/0!"}},"(Actual) Pay Area Tonnage",{"$f":"IF(G15=\"\",\"\",G15*$C$3*C7*43.3/2000)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Bituminous Correction (TN)",{"$f":"IF(I26>I27,I27-I26,0)","v":{"$error":"#DIV/0!"}},"Max Design Surface Area Tonnage (Spec 234-9)",{"$f":"IF(G17=\"\",\"\",G17*$C$3*C7*43.3/2000)","v":""}]
[null,null,null,null,null,null,null,"(Final) Pay Area Tonnage",{"$f":"IF(G19=\"\",\"\",G19*$C$3*C7*43.3/2000)","v":{"$error":"#DIV/0!"}}]
["Use the box below for Comments or References. For Example, \"See Plan Sheet X.\"",null,null,null,null,null,null,"(Final) Pay Area SY",{"$f":"IF(I28=\"\",\"\",(I28*2000)/($C$3*C7*43.3))","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,"Tonnage Difference","(Actual) Placed SY"]
[null,null,null,null,null,null,null,{"$f":"I28-I25","v":{"$error":"#DIV/0!"}},{"$f":"IF($C$7=\"\",\"\",ROUND(B7*2000/($C$3*$C$7*43.3),2))","v":{"$error":"#DIV/0!"}}]

{"sheet":" Structural Tab 1","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,5],[2,0,2,4],[7,0,7,4],[8,0,8,3],[8,4,8,5],[11,0,13,3],[14,0,16,3],[29,6,29,7],[29,0,33,3],[9,0,9,3],[10,0,10,3],[23,0,24,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[25,0,25,3],[26,0,28,3]]}
["TONNAGE",null,null,null,null,null,null,"Total PQ Tonnage"]
["Pay Item:",null,null,null,null,null,null,{"$f":"SUM(I2:XFD2)","v":0}]
["Unit Price:"]
["LOT NUMBER","Lot Tonnage from QCRR","LOT Gmm (from QCRR)","CPF","ADJUSTED UNIT PRICE","CPF Adjustment **Pay as LOTs close**",null,"Verify Tonnage Totals"]
[null,null,null,null,{"$f":"IF(B5=\"\",\"\",ROUND((D5-1)*$F$3,2))","v":""},{"$f":"IF(E5=\"\",\"\",E5*B5)","v":""},null,{"$f":"SUM(INDIRECT(\"I5:XFD5\"))","v":{"$error":"#DIV/0!"}},{"$f":"$B5*($I$2/($H$2))","v":{"$error":"#DIV/0!"}}]
[null,"Total Tonnage (CHECK to match QCRR)","Tonnage-Weighted Average Gmm (from QCRR)",".","Total CPF Adj's:",{"$f":"IF(ROW()<=5,0,SUM(F5:INDEX(F:F,ROW()-1)))","v":0},null,"Total Tonnage (CHECK to match QCRR)"]
["Totals",{"$f":"SUM(INDIRECT(ADDRESS(5,COLUMN()) & \":\" & ADDRESS(ROW()-1,COLUMN())))","v":0},{"$f":"IF(ROW()<=5,\"\",IF(INDIRECT(\"B\"&ROW())=\"\",\"\",ROUND(SUMPRODUCT(C$5:INDEX(C:C,ROW()-1),B$5:INDEX(B:B,ROW()-1))/SUM(B$5:INDEX(B:B,ROW()-1)),10)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C7=\"\",\"\",ROUND(AVERAGE(INDIRECT(\"D5:D\" & ROW()-1)),2))","v":{"$error":"#DIV/0!"}},"**CPF Correction Adjustment ($)",{"$f":"F29","v":""},null,{"$f":"SUM(I7:XFD7)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(INDIRECT(ADDRESS(5,COLUMN()) & \":\" & ADDRESS(ROW()-1,COLUMN())))","v":{"$error":"#DIV/0!"}}]
["Total Project CPF payments:",null,null,null,null,{"$f":"SUM(F6:F7)","v":0}]
["Form Instructions:"]
["1) Manually enter data into the yellow boxes.",null,null,null,"Plan Quantity (TN)",null,"*Check that QCRR Matches Plans"]
["2) See Examples of Adjustments in CPAM 11.4.",null,null,null,"Plan Quantity (TN) Overbuild",null,"*Check that QCRR Matches Plans"]
["3) This form is a tool for FE Tracking. Use the QCRR to track quantities and adjustments. Limit payment to 105% or 110% of the adjusted plan quantity. Paying for tonnage over the maximum pay tonnage will result in a negative line item adjustment. ",null,null,null,"Engineer Changes (TN)",0,"*Check that QCRR Matches Plans"]
[null,null,null,null,"Engineer Changes (TN) Overbuild",null,"*Check that QCRR Matches Plans"]
[null,null,null,null,"Total Plan Quantity w/ Changes (TN)/No Overbuild",{"$f":"F10-F11+F12-F13","v":0}]
["NOTE: Rounding issues may occur due to the decimal places for the Tonnage-Weighted Average Gmm. Verify the Adjusted PQ and Spec. Limit Amount compare closely to the QCRR.",null,null,null,"Design Gmm (enter as 2.540)"]
[null,null,null,null,"Adjusted PQ (TN) ",{"$f":"IF(F15=\"\",\"\",ROUND((F14/F15)*C7,2))","v":""}]
[null,null,null,null,null,{"$f":"IF(F16=\"\",\"\",IF(F9=\"\",\"\",F10*F16))","v":""}]
[null,null,null,null,"Total Overbuild Placed (TN)",null,"*Verify against QCRR "]
[null,null,null,null,"Total Tonnage Placed",{"$f":"ROUND(B7,2)","v":0},"*Verify against QCRR"]
[null,null,null,null,"Total Tonnage Placed (TN)/No Overbuild",{"$f":"ROUND(B7-F18,2)","v":0}]
[null,null,null,null,"Spec Limit per Contract \n(enter as 1.05 or 1.10)",null,"*Determine by Spec Year"]
[null,null,null,null,"105% or 110% Limit Amount (TN) ",{"$f":"IF(F21=\"\",\"\",IF(F16=\"\",\"\",F16*F21))","v":""}]
[]
["4) Verify Overbuild quantities and do not inlclude them in the quantities for the Pay Quantity Adjustment per Spec. 334. Overbuild will be paid by the tonnage placed.",null,null,null,"Final Pay Tonnage (TN) without Overbuild",{"$f":"IF(F20>F22,F22,F20)","v":0},"*Verify against QCRR"]
[null,null,null,null,"Pay Quantity Adjustment (TN)",{"$f":"IF(F22=\"\",\"\",(F24-F20))","v":""}]
["5) Bituminous Correction to account for the difference between the tonnage placed and the final pay quantity. Use the index for the last month in which paving occurred.",null,null,null,"Bituminous Correction (TN)",{"$f":"F25","v":""}]
["6) Pay CPF Adjustments as LOTs are closed. Final CPF Adjustment will be based on the Average CPF percentage for the pay item only if the actual tonnage exceeds the Final Pay Tonnage. See CPAM 11.4 for examples.",null,null,null,"CPF Correction (TN)",{"$f":"F25","v":""}]
[null,null,null,null,"Average CPF Adjusted Unit Price",{"$f":"IF(D7=\"\",\"\",(ROUND((ABS(D7-1)*F3),2)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Correction CPF Adjustment ($)",{"$f":"IF(F27=\"\",\"\",F27*F28)","v":""}]
["7) Adjustments on Lump Sum/Design-Build (LD/DB) Contracts are paid up to 110% of the Adjusted Plan Quantity. Reductions in pay will be made if the quantity placed is less than the adjusted quantity per CPAM 6.2 and the Contract Special Provisions. An adjustment to overbuild will be made for quantities higher or lower than the adjusted PQ per CPAM 6.2 and the Contract Special Provisions.",null,null,null,null,null,"DB Overbuild Adjustment"]
[null,null,null,null,"LS/DB Contract Pay Qty. Adjustment",{"$f":"IF(F22=\"\",\"\",(F24-F16+H33))","v":""},"PQ Overbuild (TN)",{"$f":"F11+F13","v":0}]
[null,null,null,null,"Bituminous Correction (TN)",{"$f":"F31","v":""},"Adjusted PQ (TN)",{"$f":"IF(H31=\"\",\"\",(ROUND((H31/F15)*(C7),2)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Pay Qty. Adjustment",{"$f":"F18-H32","v":{"$error":"#DIV/0!"}}]
[]
["Use the box below for Comments or References. For Example, \"See Plan Sheet X\""]

{"sheet":"Friction Tab 1","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,0,29,3],[0,0,0,5],[1,1,1,5],[2,0,2,4],[7,0,7,4],[8,0,8,3],[8,4,8,5],[25,0,25,3],[13,0,15,3],[10,0,10,3],[11,0,12,3],[9,0,9,3],[18,0,18,3],[19,0,19,3],[16,0,16,3],[17,0,17,3],[21,0,21,3],[22,0,24,3],[20,0,20,3]]}
["TONNAGE",null,null,null,null,null,null,"Total PQ Tonnage"]
["Pay Item:",null,null,null,null,null,null,{"$f":"SUM(I2:XFD2)","v":0}]
["Unit Price:"]
["LOT NUMBER","Lot Tonnage from QCRR","LOT Gmm (from QCRR)","CPF","ADJUSTED UNIT PRICE","CPF Adjustment **Pay as LOTs close**",null,"Verify Tonnage Totals"]
[null,null,null,null,{"$f":"IF(B5=\"\",\"\",ROUND((D5-1)*$F$3,2))","v":""},{"$f":"IF(E5=\"\",\"\",E5*B5)","v":""},null,{"$f":"SUM(INDIRECT(\"I5:XFD5\"))","v":{"$error":"#DIV/0!"}},{"$f":"$B5*($I$2/($H$2))","v":{"$error":"#DIV/0!"}}]
[null,"Total Tonnage (CHECK to match QCRR)","Tonnage-Weighted Average Gmm (from QCRR)","Average CPF","Total CPF Adj's:",{"$f":"IF(ROW()<=5,0,SUM(F5:INDEX(F:F,ROW()-1)))","v":0},null,"Total Tonnage (CHECK to match QCRR)"]
["Totals",{"$f":"SUM(INDIRECT(ADDRESS(5,COLUMN()) & \":\" & ADDRESS(ROW()-1,COLUMN())))","v":0},{"$f":"IF(ROW()<=5,\"\",IF(INDIRECT(\"B\"&ROW())=\"\",\"\",ROUND(SUMPRODUCT(C$5:INDEX(C:C,ROW()-1),B$5:INDEX(B:B,ROW()-1))/SUM(B$5:INDEX(B:B,ROW()-1)),10)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C7=\"\",\"\",ROUND(AVERAGE(INDIRECT(\"D5:D\" & ROW()-1)),2))","v":{"$error":"#DIV/0!"}},"**CPF Correction Adjustment ($)",{"$f":"F25","v":""},null,{"$f":"SUM(I7:XFD7)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(INDIRECT(ADDRESS(5,COLUMN()) & \":\" & ADDRESS(ROW()-1,COLUMN())))","v":{"$error":"#DIV/0!"}}]
["Total Project CPF payments:",null,null,null,null,{"$f":"SUM(F6:F7)","v":0}]
["Form Instructions:"]
["1) Manually enter data into the yellow boxes.",null,null,null,"Plan Quantity (TN)",null,"*Check that QCRR Matches Plans"]
["2) See Examples of Adjustments in CPAM 11.4.",null,null,null,"Engineer Changes (TN)",null,"*Check that QCRR Matches Plans"]
["3) This form is a tool for FE Tracking. Use the QCRR to track quantities and adjustments. Limit payment to 105% or 110% of the adjusted plan quantity. Paying for tonnage over the maximum pay tonnage will result in a negative line item adjustment.  ",null,null,null,"Total Plan Quantity w/ Changes (TN)",{"$f":"F10+F11","v":0}]
[null,null,null,null,"Design Gmm (enter as 2.540 or 2.635)"]
["NOTE: Rounding issues may occur due to the decimal places for the Tonnage-Weighted Average Gmm. Verify the Adjusted PQ and Spec. Limit Amount compare closely to the QCRR.",null,null,null,"Adjusted PQ (TN) ",{"$f":"IF(F13=\"\",\"\",ROUND((F12/F13)*C7,2))","v":""}]
[null,null,null,null,null,{"$f":"IF(F14=\"\",\"\",IF(F9=\"\",\"\",F10*F14))","v":""}]
[null,null,null,null,"Total Tonnage Placed",{"$f":"ROUND(B7,2)","v":0},"*Verify against QCRR"]
[null,null,null,null,"Spec Limit per Contract \n(enter as 1.05 or 1.10)",null,"*Determine by Spec Year"]
[null,null,null,null,"105% or 110% Limit Amount (TN) ",{"$f":"IF(F17=\"\",\"\",IF(F14=\"\",\"\",F14*F17))","v":""}]
[]
[null,null,null,null,"Final Pay Tonnage (TN)",{"$f":"IF(F16>F18,F18,F16)","v":0},"*Verify against QCRR"]
[null,null,null,null,"Pay Quantity Adjustment (TN)",{"$f":"IF(F18=\"\",\"\",(F20-F16))","v":""}]
["4) Bituminous Correction to account for the difference between the tonnage placed and the final pay quantity. Use the index for the last month in which paving occurred.",null,null,null,"Bituminous Correction (TN)",{"$f":"F21","v":""}]
["5) Pay CPF Adjustments as LOTs are closed. Final CPF Adjustment will be based on the Average CPF percentage for the pay item only if the actual tonnage exceeds the Final Pay Tonnage. See CPAM 11.4 for examples.",null,null,null,"CPF Correction (TN)",{"$f":"F21","v":""}]
[null,null,null,null,"Average CPF Adjusted Unit Price",{"$f":"IF(D7=\"\",\"\",(ROUND((ABS(D7-1)*F3),2)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Correction CPF Adjustment ($)",{"$f":"IF(F23=\"\",\"\",F23*F24)","v":""}]
[]
["6) Adjustments on Lump Sum/Design-Build (LD/DB) Contracts are paid up to 110% of the Adjusted Plan Quantity. Reductions in pay will be made if the quantity placed is less than the adjusted quantity per CPAM 6.2 and the Contract Special Provisions. ",null,null,null,"LS/DB Contract Pay Qty. Adjustment",{"$f":"IF(F18=\"\",\"\",(F20-F14+H29))","v":""}]
[null,null,null,null,"Bituminous Correction (TN)",{"$f":"F27","v":""}]
[]
[]
["Use the box below for Comments or References. For Example, \"See Plan Sheet X\""]