{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":1,"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":"Worksheet","index":0,"n_rows":106,"n_cols":17,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,1,1,8],[2,0,2,1],[2,3,2,7],[110,0,110,8],[100,6,100,7],[101,6,101,7],[102,6,102,7],[103,6,103,7],[86,0,86,7],[98,6,98,7],[87,6,87,7],[88,6,88,7],[89,6,89,7],[90,6,90,7],[91,6,91,7],[111,0,111,8],[112,0,112,8],[113,0,113,8],[87,0,104,5],[104,6,104,7],[105,0,105,8],[106,0,106,8],[107,0,107,8],[108,0,108,8],[109,0,109,8],[93,6,93,7],[94,6,94,7],[95,6,95,7],[96,6,96,7],[97,6,97,7],[92,6,92,7]]}
["BASE WORKSHEET (FILL OUT ALL YELLOW BOXES)"]
["Pay Item:"]
["Thickness (in):",null,null,"Unit Price:"]
["LOT NUMBER","Lot Tonnage from QCRR","Lot Gmm","CPF","LOT Total (SY)","Actual Spread Rate (lb/SY)","Target Spread Rate (lb/SY)","ADJUSTED UNIT PRICE","LOT CPF Adjustment"]
[null,null,null,null,null,{"$f":"IF(B5=\"\",\"\",B5*2000/E5)","v":""},{"$f":"IF(B5=\"\",\"\",$C$3*C5*43.3)","v":""},{"$f":"IF(B5=\"\",\"\",ROUND((D5-1)*$I$3,2))","v":""},{"$f":"IF(H5=\"\",\"\",H5*E5)","v":""}]
[null,null,null,null,null,"","",{"$f":"IF(B6=\"\",\"\",ROUND((D6-1)*$I$3,2))","v":""},{"$f":"IF(H6=\"\",\"\",H6*E6)","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,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,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,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,{"$f":"IF(B69=\"\",\"\",B69*2000/E69)","v":""},{"$f":"IF(B69=\"\",\"\",$C$3*C69*43.3)","v":""},"",""]
[null,null,null,null,null,"","",{"$f":"IF(B70=\"\",\"\",ROUND((D70-1)*$I$3,2))","v":""},{"$f":"IF(H70=\"\",\"\",H70*E70)","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,"","",{"$f":"IF(B82=\"\",\"\",ROUND((D82-1)*$I$3,2))","v":""},""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,"Total Tonnage (CHECK to match QCRR)","Tonnage-Weighted Average Gmm (CHECK to match QCRR)","Average CPF","Total Square Yards  (CHECK to match QCRR)",null,null,"Total CPF Adj's:",{"$f":"SUM(I5:I84)","v":0},"Tonnage\n(2.54 Gmm)","Tonnage\n(Tonnage-Weighted Average Gmm)"]
["Totals",{"$f":"SUM(B5:B84)","v":0},{"$f":"IF(B5=\"\",\"\",SUMPRODUCT(C5:C84,B5:B84)/SUM(B5:B84))","v":""},{"$f":"IF(C86=\"\",\"\",ROUND(AVERAGE(D5:D84),2))","v":""},{"$f":"SUM(E5:E84)","v":0},null,null,"*Correction CPF Adj:",{"$f":"IF(D86=\"\",\"\",I105)","v":""},"*Made after all Base is Placed"]
["Total Project CPF payments:",null,null,null,null,null,null,null,{"$f":"SUM(I85:I86)","v":0},null,null,"Placed SY",{"$f":"IF(C86=\"\",\"\",B86*2000/($C$3*C86*43.3))","v":""}]
[]
[null,null,null,null,null,null,"Plan Quantity (SY)"]
[null,null,null,null,null,null,"Engineer Changes (SY)",null,null,null,null,null,null,null,"Scenario","Pay","SY Adj"]
[null,null,null,null,null,null,"Total Plan Quantity w/ Changes (SY)",null,{"$f":"IF(I89=\"\",\"\",SUM(I89:I90))","v":""},{"$f":"IF(I91=\"\",\"\",I91*$C$3*2.54*43.3/2000)","v":""},{"$f":"IF(J91=\"\",\"\",I91*$C$3*C86*43.3/2000)","v":""},null,null,null,"Placed > 105%",1.05,{"$f":"IF(J96=\"\",\"\",IF(E86>I96,I96-I98,\"\"))","v":""}]
[null,null,null,null,null,null,"Adjusted PQ (TN)",null,{"$f":"IF(I91=\"\",\"\",ROUND(I91*$C$3*C86*43.3/2000,1))","v":""},null,null,null,null,null,"Placed <105%","Pay Area",{"$f":"IF(I92=\"\",\"\",IF(E86<I95,I95-I98,\"\"))","v":""}]
[]
[]
[null,null,null,null,null,null,"Pay Area (per 234-9) (SY)",null,{"$f":"IF(C86=\"\",\"\",ROUND(I91*(B86/I92),0))","v":""},{"$f":"IF(I95=\"\",\"\",I95*$C$3*2.54*43.3/2000)","v":""},{"$f":"IF(J95=\"\",\"\",I95*$C$3*C86*43.3/2000)","v":""}]
[null,null,null,null,null,null,"105% Max Designed Surface Area (SY)",null,{"$f":"IF(I91=\"\",\"\",I91*1.05)","v":""},{"$f":"IF(I96=\"\",\"\",I96*$C$3*2.54*43.3/2000)","v":""},{"$f":"IF(J96=\"\",\"\",I96*$C$3*C86*43.3/2000)","v":""}]
[]
[null,null,null,null,null,null,"Final Pay Area (SY)",null,{"$f":"IF(I95>I96,I96,I95)","v":""},{"$f":"IF(I98=\"\",\"\",I98*$C$3*2.54*43.3/2000)","v":""},{"$f":"IF(J98=\"\",\"\",ROUND(I98*$C$3*C86*43.3/2000,1))","v":""}]
[null,null,null,null,null,null,"Line Item Adjustment (SY)",null,{"$f":"IF(I91=\"\",\"\",(I98-I91))","v":""}]
[]
[null,null,null,null,null,null,"Bituminous Correction (TN)",null,{"$f":"IF(K98=\"\",\"\",K98-B86)","v":""},{"$f":"IF(I101=\"\",\"\",(I101*2000)/($C$3*2.54*43.3))","v":""},{"$f":"IF(J101=\"\",\"\",(I101*2000)/($C$3*C86*43.3))","v":""},"<< square yards"]
[]
[null,null,null,null,null,null,"CPF Correction (SY)",null,{"$f":"ROUND(I99,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"Average CPF Adjusted Unit Price",null,{"$f":"IF(D86=\"\",\"\",(D86-1)*I3)","v":""}]
[null,null,null,null,null,null,"Correction CPF Adjustment ($)",null,{"$f":"IF(I103=\"\",\"\",I103*I104)","v":{"$error":"#VALUE!"}}]
["Use the box below for Comments or References. For Example, \"See Plan Sheet X\""]