{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Square Yards","Structural","ScrapPaper"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"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":"Square Yards","index":0,"n_rows":108,"n_cols":17,"rows_kept":108,"cut":false,"hidden":false,"merged":[[90,0,92,4],[0,11,2,11],[0,0,0,6],[1,1,1,6],[87,9,89,9],[87,10,89,10],[88,0,88,4],[95,0,95,4],[117,5,117,9],[2,8,2,10],[101,0,101,4],[102,0,102,4],[87,0,87,4],[2,0,2,1],[2,3,2,5],[86,0,86,5],[100,0,100,4],[93,0,94,4],[89,0,89,4],[87,5,87,6],[96,0,96,4],[99,0,99,4],[97,0,98,4]]}
["SQUARE YARDS",null,null,null,null,null,null,null,"Bid Qty. FN 01","Bid Qty. FN 02","Bid Qty. FN 03","Use more FINs if needed"]
["Pay Item:"]
["Thickness (in):",null,null,"Unit Price:",null,null,null,null,"SY"]
["LOT NUMBER","Lot Tonnage from QCRR","LOT Gmm (from QCRR)","CPF ","LOT Total (SY) ","ADJUSTED UNIT PRICE","CPF Adjustment **Pay as LOTs close**",null,"FIN 01   ","FIN 02  ","FIN 03  ","Verify SY"]
[null,null,null,null,null,{"$f":"IF(B5=\"\",\"\",ROUND((D5-1)*$G$3,2))","v":""},{"$f":"IF(F5=\"\",\"\",F5*E5)","v":""},null,{"$f":"$G89*($I$2/($I$2+$J$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"$G89*($J$2/($J$2+$I$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"$G89*($K$2/($J$2+$I$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:K5)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(B6=\"\",\"\",ROUND((D6-1)*$G$3,2))","v":""},{"$f":"IF(F6=\"\",\"\",F6*E6)","v":""},null,{"$f":"$B6*($I$2/($I$2+$J$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"$B6*($J$2/($J$2+$I$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"$B6*($K$2/($J$2+$I$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I6:K6)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"IF(B37=\"\",\"\",ROUND((D37-1)*$G$3,2))","v":""},{"$f":"IF(F37=\"\",\"\",F37*E37)","v":""},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"IF(B69=\"\",\"\",ROUND((D69-1)*$G$3,2))","v":""},{"$f":"IF(F69=\"\",\"\",F69*E69)","v":""},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$f":"$B70*($I$2/($I$2+$J$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"$B70*($J$2/($J$2+$I$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"$B70*($K$2/($J$2+$I$2+$K$2))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I70:K70)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$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":"SUM(G5:G84)","v":0},null,"Total TN FIN 01","Total TN FIN 02","Total TN FIN 03","Total Tonnage (CHECK to match QCRR)"]
["Totals",{"$f":"IF(G91=\"\",\"\",ROUND(SUM(B5:B84),2))","v":0},{"$f":"IF(B5=\"\",\"\",SUMPRODUCT(C5:C84,B5:B84)/SUM((B5:B84)))","v":""},{"$f":"IF(C86=\"\",\"\",ROUND(AVERAGE(D5:D84),2))","v":""},{"$f":"IF(G91=\"\",\"\",ROUND(SUM(E5:E84),2))","v":0},"Corrected CPF Adjustment (G103)",{"$f":"IF(C86=\"\",\"\",G103)","v":""},null,{"$f":"SUM(I5:I84)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J5:J84)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K5:K84)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L5:L84)","v":{"$error":"#DIV/0!"}}]
["Total Project CPF payments:",null,null,null,null,null,{"$f":"SUM(G85:G86)","v":0}]
["Form Instructions:",null,null,null,null,null,null,null,null,"Tonnage\n(2.54 Gmm)","Tonnage\n(Tonnage-Weighted Average Gmm)"]
["1) Manually enter data into the yellow boxes.",null,null,null,null,"Plan Quantity (SY)",null,"*Check that QCRR Matches Plans"]
["2) Base is paid by Plan Quantity (PQ). See Examples of Adjustments in CPAM 11.4. Negative adjustments may be made if there is a Plan Error or Field Change.",null,null,null,null,"Engineer Changes (SY)",0,"*Check that QCRR Matches Plans"]
["3) This form is a tool for FE Tracking. Use the Final QCRR amounts to apply adjustments. **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,"Total Plan Quantity w/ Changes (SY)                  Designed Surface Area",{"$f":"G89+G90","v":0},"*Check that QCRR Matches Plans",null,null,null,"Placed SY"]
[null,null,null,null,null,"Adjusted PQ (TN)",{"$f":"IF(G91=\"\",\"\",ROUND(G91*C3*C86*43.3/2000,2))","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(G91=\"\",\"\",G91*$C$3*2.54*43.3/2000)","v":0},{"$f":"IF(G91=\"\",\"\",G91*$C$3*C86*43.3/2000)","v":{"$error":"#VALUE!"}},{"$f":"IF($C$86=\"\",\"\",ROUND(B86*2000/($C$3*$C$86*43.3),2))","v":""}]
[]
["4) *The PQ Adjustment and CPF Correction is made after all Base is placed and assumes payment has been made for the PQ (nothing over).",null,null,null,null,"Pay Area (per 234-9) (SY)",{"$f":"IF(C86=\"\",\"\",ROUND(G91*(B86/G92),0))","v":""},null,null,{"$f":"IF(G94=\"\",\"\",G94*$C$3*2.54*43.3/2000)","v":""},{"$f":"IF(G94=\"\",\"\",G94*$C$3*C86*43.3/2000)","v":""},null,null,null,"Scenario","Pay","SY Adj"]
[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,null,"Placed > 105%",1.05]
["5) **Bituminous Corrections equal the PQ Adjustment in Tons (K101)",null,null,null,null,"105% or 110% Max Designed Surface Area (SY)",{"$f":"IF(G95=\"\",\"\",IF(G91=\"\",\"\",G91*G95))","v":""},null,null,{"$f":"IF(G96=\"\",\"\",G96*$C$3*2.54*43.3/2000)","v":""},{"$f":"IF(G96=\"\",\"\",G96*$C$3*C86*43.3/2000)","v":""},null,null,null,"Placed <105%","Pay Area",{"$f":"IF(H96=\"\",\"\",IF(F90<H99,H99-H103,\"\"))","v":""}]
["6) The Average CPF is used when a positive or negative adjustment is made per CPAM 11.4"]
["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,"Final Pay Area (SY)",{"$f":"IF(G94>G96,G96,G94)","v":""},null,null,{"$f":"IF(G98=\"\",\"\",G98*$C$3*2.54*43.3/2000)","v":""},{"$f":"IF(G98=\"\",\"\",G98*$C$3*C86*43.3/2000)","v":""}]
[null,null,null,null,null,"*Pay Quantity Adjustment (SY)",{"$f":"IF(G91=\"\",\"\",ROUND(G98-G91,0))","v":{"$error":"#VALUE!"}},"*Verify against QCRR",null,{"$f":"IF(J98=\"\",\"\",(J98*2000)/($C$3*2.54*43.3))","v":""},{"$f":"IF(K98=\"\",\"\",(K98*2000)/($C$3*C86*43.3))","v":""},"<< square yards"]
[null,null,null,null,null,"**Bituminous Correction (TN) ",{"$f":"IF(K98=\"\",\"\",K98-G92)","v":""},null,null,null,{"$f":"K98-K92","v":{"$error":"#VALUE!"}},"Check "]
[null,null,null,null,null,"*CPF Correction (SY)",{"$f":"ROUND(G99,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Average CPF Adjusted Unit Price",{"$f":"IF(D86=\"\",\"\",(ROUND(((D86-1)*G3),2)))","v":""}]
[null,null,null,null,null,"Correction CPF Adjustment ($)",{"$f":"IF(G101=\"\",\"\",G101*G102)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,"***LS/DB Contract Pay Qty. Adjustment",{"$f":"IF(G98=\"\",\"\",ROUND(G98-G94,0))","v":""}]
[null,null,null,null,null,"Bituminous Correction (TN)",{"$f":"IF(G98=\"\",\"\",ROUND(G98-G94,0))","v":""}]
[]
["Use the box below for Comments or References. For Example, \"See Plan Sheet X.\""]

{"sheet":"Structural","index":1,"n_rows":113,"n_cols":11,"rows_kept":113,"cut":false,"hidden":false,"merged":[[99,0,103,3],[104,0,104,3],[109,0,109,3],[110,0,110,3],[111,0,111,5],[104,8,104,12],[112,0,116,5],[105,0,105,3],[106,0,106,3],[107,0,107,3],[109,7,109,8],[94,0,95,3],[96,0,98,3],[86,0,86,4],[0,0,0,5],[0,10,2,10],[1,1,1,5],[2,0,2,4],[2,7,2,9],[87,0,87,3],[87,4,87,5],[88,0,88,3],[89,0,89,3],[90,0,93,3]]}
["TONNAGE",null,null,null,null,null,null,"Bid Qty. FN 01","Bid Qty. FN 02","Bid Qty. FN 03","Use more FINs if needed"]
["Pay Item:"]
["Unit Price:",null,null,null,null,null,null,"TONS"]
["LOT NUMBER","Lot Tonnage from QCRR","LOT Gmm (from QCRR)","CPF","ADJUSTED UNIT PRICE","CPF Adjustment **Pay as LOTs close**",null,"FIN 01   ","FIN 02  ","FIN 03  ","Verify Tons"]
[null,null,null,null,{"$f":"IF(B5=\"\",\"\",ROUND((D5-1)*$F$3,2))","v":""},{"$f":"IF(E5=\"\",\"\",E5*B5)","v":""},null,{"$f":"$B5*($H$2/($H$2+$I$2+$J$2))","v":{"$error":"#DIV/0!"}},{"$f":"$B5*($I$2/($H$2+$I$2+$J$2))","v":{"$error":"#DIV/0!"}},{"$f":"$B5*($J$2/($H$2+$I$2+$J$2))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H5:J5)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"",{"$f":"IF(E6=\"\",\"\",E6*B6)","v":""},null,{"$f":"$B6*($H$2/($H$2+$I$2))","v":{"$error":"#DIV/0!"}},{"$f":"$B6*($I$2/($H$2+$I$2))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H6:I6)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H6:J6)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"IF(B69=\"\",\"\",ROUND((D69-1)*$F$3,2))","v":""},"",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"",{"$f":"IF(E70=\"\",\"\",E70*B70)","v":""},null,{"$f":"$B70*($H$2/($H$2+$I$2))","v":{"$error":"#DIV/0!"}},{"$f":"$B70*($I$2/($H$2+$I$2))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H70:I70)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H70:J70)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Tonnage (CHECK to match QCRR)","Tonnage-Weighted Average Gmm (from QCRR)","Average CPF","Total CPF Adj's:",{"$f":"SUM(F5:F84)","v":0},null,"Total TN FIN 01","Total TN FIN 02","Total TN FIN 03","Total Tonnage (CHECK to match QCRR)"]
["Totals",{"$f":"ROUND(SUM(B5:B84),2)","v":0},{"$f":"IF(B5=\"\",\"\",SUMPRODUCT(C5:C84,B5:B84)/SUM((B5:B84)))","v":""},{"$f":"IF(C86=\"\",\"\",ROUND(AVERAGE(D5:D84),2))","v":""},"**CPF Correction (TN)",{"$f":"IF(D86=\"\",\"\",F108)","v":""},null,{"$f":"SUM(H5:H84)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:I84)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J5:J84)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K5:K84)","v":{"$error":"#DIV/0!"}}]
["Total Project CPF payments:",null,null,null,null,{"$f":"SUM(F85:F86)","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 for Structural in CPAM 11.4.",null,null,null,"Plan Quantity (TN) Overbuild",0,"*Check that QCRR Matches Plans"]
["3) This form is a tool for FE Tracking. Use the Final QCRR amounts to apply adjustments. **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,"Engineer Changes (TN)",0,"*Check that QCRR Matches Plans"]
[null,null,null,null,"Engineer Changes (TN) Overbuild",0,"*Check that QCRR Matches Plans"]
[null,null,null,null,"Total Plan Quantity w/ Changes (TN)/No Overbuild",{"$f":"F89-F90+F91-F92","v":0}]
[null,null,null,null,"Design Gmm (enter as 2.540 or 2.635)"]
["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,"Adjusted PQ (TN) ",{"$f":"IF(F94=\"\",\"\",(ROUND((F93/F94)*(C86),2)))","v":""}]
[null,null,null,null,null,{"$f":"IF(F95=\"\",\"\",IF(F88=\"\",\"\",F89*F95))","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,"Total Overbuild Placed (TN)",0,"*Verify against QCRR "]
[null,null,null,null,"Total Tonnage Placed",{"$f":"ROUND(B86,2)","v":0},"*Verify against QCRR"]
[null,null,null,null,"Total Tonnage Placed (TN)/No Overbuild",{"$f":"ROUND(B86-F97,2)","v":0}]
["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\nthan 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,"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(F100=\"\",\"\",IF(F95=\"\",\"\",F95*F100))","v":""}]
[]
[null,null,null,null,"*Final Pay Tonnage (TN) without Overbuild",{"$f":"IF(F99>F101,F101,F99)","v":0},"*Verify against QCRR"]
[null,null,null,null,"Pay Quantity Adjustment (TN)",{"$f":"IF(F101=\"\",\"\",(F103-F99))","v":""}]
[null,null,null,null,"Bituminous Correction (TN)",{"$f":"F104","v":""}]
[null,null,null,null,"**CPF Correction (TN)",{"$f":"F105","v":""}]
[null,null,null,null,"Average CPF Adjusted Unit Price",{"$f":"IF(D86=\"\",\"\",(ROUND((ABS(D86-1)*F3),2)))","v":""}]
[null,null,null,null,"Correction CPF Adjustment ($)",{"$f":"IF(F106=\"\",\"\",F106*F107)","v":""}]
[]
[null,null,null,null,"***LS/DB Contract Pay Qty. Adjustment",{"$f":"IF(F101=\"\",\"\",(F103-F95+I113))","v":""},null,"DB Overbuild Adjustment"]
[null,null,null,null,"Bituminous Correction (TN)",{"$f":"F110","v":""},null,"PQ Overbuild (TN)",{"$f":"F90+F92","v":0}]
["Use the box below for Comments or References. For Example, \"See Plan Sheet X\"",null,null,null,null,null,null,"Adjusted PQ (TN)",{"$f":"IF(I111=\"\",\"\",(ROUND((I111/F94)*(C86),2)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Pay Qty. Adjustment",{"$f":"F97-I112","v":{"$error":"#DIV/0!"}}]

{"sheet":"ScrapPaper","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}