{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["START","Table 1 - Price Adj - HMA SY","Table 1 - Price Adj - HMA Ton","Table 1 - Price Adj - PCC SY","Table 1 - Price Adj - Combo SY","Table 1 - Price Adj - Combo Ton","Table 2 - Price Adj - HMA SY","Table 2 - Price Adj - HMA Ton","Table 2 - Price Adj - PCC SY","Table 2 - Price Adj - Combo SY","Table 2 - Price Adj - Combo Ton","Table 3 - Price Adj - Perc Impr","Table 4 - Price Adj - Diam Grin"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"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":"START","index":0,"n_rows":9,"n_cols":44,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,30,1,38],[2,31,2,32],[8,31,10,32],[0,20,1,28],[2,21,2,22],[7,21,7,22],[7,11,7,12],[8,1,8,2],[2,1,2,2],[2,11,2,12],[0,10,1,18],[0,0,1,8]]}
["Table 1 shall be used for pavements having a final posted speed greater than 45 mph.",null,null,null,null,null,null,null,null,null,"Table 2 shall be used for pavements having a final posted speed of 45 mph or less and for pavements with no posted speed limits.",null,null,null,null,null,null,null,null,null,"Table 3 - Percent Improvement",null,null,null,null,null,null,null,null,null,"Table 4 - Diamond Grinding Existing Pavement"]
[]
[null,"Table 1",null,null,null,null,null,null,null,null,null,"Table 2",null,null,null,null,null,null,null,null,null,"Table 3",null,null,null,null,null,null,null,null,null,"Table 4"]
[null,"International Roughness Index, Inches per Mile","Percent Contract Price",null,null,null,null,null,null,null,null,"International Roughness Index, Inches per Mile","Percent Contract Price",null,null,null,null,null,null,null,null,"Percent Improvement (Change in IRI/Initial IRI) X 100","Percent of Contract Unit Price for Pavement",null,null,null,null,null,null,null,null,"International Roughness Index Inches/Mile","Increase in Contract Unit Price for Diamond Grinding",null,null,null,null,null,null,null,null,null,null,"Total Project Bonus"]
[null,"40.0 or less",105,null,null,null,null,null,null,null,null,"70.0 or less",103,null,null,null,null,null,null,null,null,"35.0 or greater",103,null,null,null,null,null,null,null,null,"40.0 or less",0.25,null,null,null,null,null,null,null,null,null,null,{"$f":"('Table 1 - Price Adj - HMA SY'!H113+'Table 1 - Price Adj - HMA Ton'!H125+'Table 1 - Price Adj - PCC SY'!H113+'Table 1 - Price Adj - Combo SY'!G117+'Table 1 - Price Adj - Combo Ton'!H113+'Table 2 - Price Adj - HMA SY'!H112+'Table 2 - Price Adj - HMA Ton'!H125+'Table 2 - Price Adj - PCC SY'!H112+'Table 2 - Price Adj - Combo SY'!G116+'Table 2 - Price Adj - Combo Ton'!G118+'Table 3 - Price Adj - Perc Impr'!F119+'Table 4 - Price Adj - Diam Grin'!F116)","v":0}]
[null,"40.1 - 54.0",103,null,null,null,null,null,null,null,null,"70.1 - 125.0",100,null,null,null,null,null,null,null,null,"20.0 to 34.9",100,null,null,null,null,null,null,null,null,"40.1 to 54.0",0.15]
[null,"54.1 - 80.0",100,null,null,null,null,null,null,null,null,"125.1 or greater","100b",null,null,null,null,null,null,null,null,"0.0 to 19.9","97c",null,null,null,null,null,null,null,null,"54.1 - 80.0","None"]
[null,"80.1 or greater","100a",null,null,null,null,null,null,null,null,"bAfter correction to 125.0 inches per mile or less.",null,null,null,null,null,null,null,null,null,"cAfter correction to 0.0 or greater",null,null,null,null,null,null,null,null,null,"80.1 or greater","Noned"]
[null,"aAfter correction to 80.0 inches per mile or less.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d Any segment with final IRI > 80 and percent improvement < 35% must be corrected."]

{"sheet":"Table 1 - Price Adj - HMA SY","index":1,"n_rows":114,"n_cols":18,"rows_kept":114,"cut":false,"hidden":false,"merged":[[2,0,2,7],[1,0,1,7],[0,0,0,7],[6,3,6,4],[7,3,7,4],[3,0,3,7],[113,0,114,3],[14,0,14,7],[14,9,14,12],[15,14,15,17],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Multi-lift construction contained in Secs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>80,\"Needs Correction\",IF(F17>54,\"0\",IF(F17>40,\"3\",IF(F17>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>80,\"Needs Correction\",IF(F18>54,\"0\",IF(F18>40,\"3\",IF(F18>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",AVERAGE(J18:K18))","v":""},{"$f":"IF(ISBLANK(J18),\"\",ABS(F18-L18))","v":""},null,"Second segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",ROUND(AVERAGE(D19,E19),1))","v":""},{"$f":"IF(ISBLANK(D19),\"\",IF(F19>80,\"Needs Correction\",IF(F19>54,\"0\",IF(F19>40,\"3\",IF(F19>1,\"5\",\"-\")))))","v":""},null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",{"$f":"IF(ISBLANK(P17),\"\",(((P17*P19)+(P18*P20))/(P17+P18)))","v":""},{"$f":"IF(ISBLANK(Q17),\"\",(((Q17*Q19)+(Q18*Q20))/(Q17+Q18)))","v":""},""]
[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(ISBLANK(E24),\"\",ROUND(AVERAGE(D24,E24),1))","v":""},{"$f":"IF(ISBLANK(D24),\"\",IF(F24>80,\"Needs Correction\",IF(F24>54,\"0\",IF(F24>40,\"3\",IF(F24>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J24),\"\",AVERAGE(J24:K24))","v":""},{"$f":"IF(ISBLANK(J24),\"\",ABS(F24-L24))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,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(ISBLANK(E88),\"\",ROUND(AVERAGE(D88,E88),1))","v":""},{"$f":"IF(ISBLANK(D88),\"\",IF(F88>80,\"Needs Correction\",IF(F88>54,\"0\",IF(F88>40,\"3\",IF(F88>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J88),\"\",AVERAGE(J88:K88))","v":""},{"$f":"IF(ISBLANK(J88),\"\",ABS(F88-L88))","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,"Adjustments","Total Length of Segments","Bonus"]
[null,null,"Plan Lane Width*",null,"feet",0.05,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,5)","v":0},{"$f":"($D$109*G109/9)*$D$111*F109","v":0}]
[null,null,"HMA Thickness",null,"inches",0.03,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"($D$109*G110/9)*$D$111*F110","v":0}]
[null,null,"HMA Contract Unit Price ($/SY)",null,null,0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"($D$109*G111/9)*$D$111*F111","v":0}]
[null,null,null,null,null,"Needs Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},{"$f":"IF(G112>0,\"Contact RE\",\"\")","v":""}]
[null,null,null,null,null,"Total",{"$f":"SUM(G109:G112)","v":0},{"$f":"SUM(H109:H111)","v":0}]
["*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  "]

{"sheet":"Table 1 - Price Adj - HMA Ton","index":2,"n_rows":125,"n_cols":18,"rows_kept":125,"cut":false,"hidden":false,"merged":[[124,2,124,3],[1,0,1,7],[2,0,2,7],[119,2,119,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[11,3,11,4],[3,0,3,7],[6,3,6,4],[0,0,0,7],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[116,7,117,7],[14,9,14,12],[15,14,15,17],[12,3,12,4],[14,0,14,7]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Multi-lift construction contained in Secs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>80,\"Needs Correction\",IF(F17>54,\"0\",IF(F17>40,\"3\",IF(F17>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>80,\"Needs Correction\",IF(F18>54,\"0\",IF(F18>40,\"3\",IF(F18>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",AVERAGE(J18:K18))","v":""},"",null,"Second segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",ROUND(AVERAGE(D19,E19),1))","v":""},{"$f":"IF(ISBLANK(D19),\"\",IF(F19>80,\"Needs Correction\",IF(F19>54,\"0\",IF(F19>40,\"3\",IF(F19>1,\"5\",\"-\")))))","v":""},null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",{"$f":"IF(ISBLANK(P17),\"\",(((P17*P19)+(P18*P20))/(P17+P18)))","v":""},{"$f":"IF(ISBLANK(Q17),\"\",(((Q17*Q19)+(Q18*Q20))/(Q17+Q18)))","v":""},""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E23),\"\",ROUND(AVERAGE(D23,E23),1))","v":""},{"$f":"IF(ISBLANK(D23),\"\",IF(F23>80,\"Needs Correction\",IF(F23>54,\"0\",IF(F23>40,\"3\",IF(F23>1,\"5\",\"-\")))))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,{"$f":"IF(ISBLANK(J25),\"\",AVERAGE(J25:K25))","v":""},{"$f":"IF(ISBLANK(J25),\"\",ABS(F25-L25))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,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(ISBLANK(E87),\"\",ROUND(AVERAGE(D87,E87),1))","v":""},{"$f":"IF(ISBLANK(D87),\"\",IF(F87>80,\"Needs Correction\",IF(F87>54,\"0\",IF(F87>40,\"3\",IF(F87>1,\"5\",\"-\")))))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,{"$f":"IF(ISBLANK(J89),\"\",AVERAGE(J89:K89))","v":""},{"$f":"IF(ISBLANK(J89),\"\",ABS(F89-L89))","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,"",{"$f":"IF(ISBLANK(J104),\"\",ABS(F104-L104))","v":""}]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,{"$f":"IF(ISBLANK(J106),\"\",AVERAGE(J106:K106))","v":""},""]
[]
[null,null,null,null,null,"Plan Lane Width*",null,"feet"]
[null,null,null,null,null,"Plan Surface Thickness",null,"inches"]
[null,null,null,null,null,"Plan Base Thickness",null,"inches"]
[null,null,null,null,null,"Plan Surface Density",null,"(tons/cy)"]
[null,null,null,null,null,"Plan Base Density",null,"(tons/cy)"]
[null,null,null,null,null,"Surface Mix Type"]
[null,null,null,null,null,"Base Mix Type"]
[null,null,null,null,null,"Contract Unit Price Surface ($/ton)"]
[null,null,null,null,null,"Contract Unit Price Base ($/ton)"]
[null,null,null,null,null,null,null,"*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  "]
[]
[]
[null,null,"Adjustments",null,"Combined Length of Segments","Surface Asphalt Bonus","Base Asphalt Bonus","Bonus"]
[null,null,0.05,null,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,5)","v":0},{"$f":"((($G$108*E121*($G$109/12))/27)*$G$111*$G$115*C121)","v":0},{"$f":"((($G$108*E121*($G$110/12))/27)*$G$112*$G$116*C121)","v":0},{"$f":"F121+G121","v":0}]
[null,null,0.03,null,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"((($G$108*E122*($G$109/12))/27)*$G$111*$G$115*C122)","v":0},{"$f":"((($G$108*E122*($G$110/12))/27)*$G$112*$G$116*C122)","v":0},{"$f":"F122+G122","v":0}]
[null,null,0,null,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"((($G$108*E123*($G$109/12))/27)*$G$111*$G$115*C123)","v":0},{"$f":"((($G$108*E123*($G$110/12))/27)*$G$112*$G$116*C123)","v":0},0]
[null,null,"Needs Correction",null,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},null,null,{"$f":"IF(E124>0,\"Contact RE\",\"\")","v":""}]
[null,null,"Total",null,{"$f":"SUM(E121:E123)","v":0},{"$f":"SUM(F121:F123)","v":0},0,0]

{"sheet":"Table 1 - Price Adj - PCC SY","index":3,"n_rows":113,"n_cols":18,"rows_kept":113,"cut":false,"hidden":false,"merged":[[7,3,7,4],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[6,3,6,4],[112,0,113,3],[14,0,14,7],[14,9,14,12],[15,14,15,17],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Concrete pavement construction contained in Secs 502 and 506."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>80,\"Needs Correction\",IF(F17>54,\"0\",IF(F17>40,\"3\",IF(F17>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>80,\"Needs Correction\",IF(F18>54,\"0\",IF(F18>40,\"3\",IF(F18>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",AVERAGE(J18:K18))","v":""},{"$f":"IF(ISBLANK(J18),\"\",ABS(F18-L18))","v":""},null,"Second segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",ROUND(AVERAGE(D19,E19),1))","v":""},{"$f":"IF(ISBLANK(D19),\"\",IF(F19>80,\"Needs Correction\",IF(F19>54,\"0\",IF(F19>40,\"3\",IF(F19>1,\"5\",\"-\")))))","v":""},null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",{"$f":"IF(ISBLANK(P17),\"\",(((P17*P19)+(P18*P20))/(P17+P18)))","v":""},{"$f":"IF(ISBLANK(Q17),\"\",(((Q17*Q19)+(Q18*Q20))/(Q17+Q18)))","v":""},""]
[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(ISBLANK(E24),\"\",ROUND(AVERAGE(D24,E24),1))","v":""},{"$f":"IF(ISBLANK(D24),\"\",IF(F24>80,\"Needs Correction\",IF(F24>54,\"0\",IF(F24>40,\"3\",IF(F24>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J24),\"\",AVERAGE(J24:K24))","v":""},{"$f":"IF(ISBLANK(J24),\"\",ABS(F24-L24))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,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(ISBLANK(E88),\"\",ROUND(AVERAGE(D88,E88),1))","v":""},{"$f":"IF(ISBLANK(D88),\"\",IF(F88>80,\"Needs Correction\",IF(F88>54,\"0\",IF(F88>40,\"3\",IF(F88>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J88),\"\",AVERAGE(J88:K88))","v":""},{"$f":"IF(ISBLANK(J88),\"\",ABS(F88-L88))","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,"Adjustments","Total Length of Segments","Bonus"]
[null,null,"Plan Lane Width*",null,"feet",0.05,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,5)","v":0},{"$f":"(($D$109*G109)/9)*$D$111*F109","v":0}]
[null,null,"PCC Thickness",null,"inches",0.03,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"(($D$109*G110)/9)*$D$111*F110","v":0}]
[null,null,"PCC Contract Unit Price ($/SY)",null,null,0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},0]
[null,null,null,null,null,"Needs Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},{"$f":"IF(G112>0,\"Contact RE\",\"\")","v":""}]
["*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  ",null,null,null,null,"Total",{"$f":"SUM(G109:G112)","v":0},{"$f":"SUM(H109:H111)","v":0}]

{"sheet":"Table 1 - Price Adj - Combo SY","index":4,"n_rows":117,"n_cols":18,"rows_kept":117,"cut":false,"hidden":false,"merged":[[2,0,2,7],[1,0,1,7],[0,0,0,7],[14,0,14,7],[20,14,20,16],[12,3,12,4],[6,3,6,4],[14,9,14,12],[15,14,15,17],[3,0,3,7],[7,3,7,4],[113,0,114,2],[108,5,108,6],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Combination of surface planning, such as diamond grinding or milling, and single lift asphalt construction contained in Secs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>80,\"Needs Correction\",IF(F17>54,\"0\",IF(F17>40,\"3\",IF(F17>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>80,\"Needs Correction\",IF(F18>54,\"0\",IF(F18>40,\"3\",IF(F18>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",AVERAGE(J18:K18))","v":""},{"$f":"IF(ISBLANK(J18),\"\",ABS(F18-L18))","v":""},null,"Second segment length (feet)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",null,null,{"$f":"IF(ISBLANK(R17),\"\",(((R17*R19)+(R18*R20))/(R17+R18)))","v":""}]
[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(ISBLANK(E24),\"\",ROUND(AVERAGE(D24,E24),1))","v":""},{"$f":"IF(ISBLANK(D24),\"\",IF(F24>80,\"Needs Correction\",IF(F24>54,\"0\",IF(F24>40,\"3\",IF(F24>1,\"5\",\"-\")))))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,{"$f":"IF(ISBLANK(J25),\"\",AVERAGE(J25:K25))","v":""},{"$f":"IF(ISBLANK(J25),\"\",ABS(F25-L25))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,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(ISBLANK(E88),\"\",ROUND(AVERAGE(D88,E88),1))","v":""},{"$f":"IF(ISBLANK(D88),\"\",IF(F88>80,\"Needs Correction\",IF(F88>54,\"0\",IF(F88>40,\"3\",IF(F88>1,\"5\",\"-\")))))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,{"$f":"IF(ISBLANK(J89),\"\",AVERAGE(J89:K89))","v":""},{"$f":"IF(ISBLANK(J89),\"\",ABS(F89-L89))","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,{"$f":"IF(ISBLANK(E106),\"\",ROUND(AVERAGE(D106,E106),1))","v":""},{"$f":"IF(ISBLANK(D106),\"\",IF(F106>80,\"Needs Correction\",IF(F106>54,\"0\",IF(F106>40,\"3\",IF(F106>1,\"5\",\"-\")))))","v":""},null,null,null,null,"",""]
[]
[null,null,null,null,"Plan Lane Width*",null,"feet"]
[null,null,null,null,"Mix Type"]
[null,null,null,null,"Asphalt Contract Unit Price ($/SY)"]
[]
[null,null,null,null,"Adjustments","Total Segment Lengths","Asphalt Bonus"]
[null,null,null,null,0.05,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,5)","v":0},{"$f":"$F$110*E113*F113*$F$108/9","v":0}]
["*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  ",null,null,null,0.03,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"$F$110*E114*F114*$F$108/9","v":0}]
[null,null,null,null,0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"$F$110*E115*F115*$F$108/9","v":0}]
[null,null,null,null,"Needs Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},{"$f":"IF(F116>0,\"Contact RE\",\"\")","v":""}]
[null,null,null,null,"Total",{"$f":"SUM(F113:F116)","v":0},{"$f":"SUM(G113:G115)","v":0}]

{"sheet":"Table 1 - Price Adj - Combo Ton","index":5,"n_rows":115,"n_cols":18,"rows_kept":115,"cut":false,"hidden":false,"merged":[[20,14,20,16],[111,3,111,4],[6,3,6,4],[14,9,14,12],[15,14,15,17],[114,0,115,2],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[14,0,14,7],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Combination of surface planning, such as diamond grinding or milling, and single lift asphalt construction contained in Secs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>80,\"Needs Correction\",IF(F17>54,\"0\",IF(F17>40,\"3\",IF(F17>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>80,\"Needs Correction\",IF(F18>54,\"0\",IF(F18>40,\"3\",IF(F18>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",AVERAGE(J18:K18))","v":""},{"$f":"IF(ISBLANK(J18),\"\",ABS(F18-L18))","v":""},null,"Second segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",ROUND(AVERAGE(D19,E19),1))","v":""},{"$f":"IF(ISBLANK(D19),\"\",IF(F19>80,\"Needs Correction\",IF(F19>54,\"0\",IF(F19>40,\"3\",IF(F19>1,\"5\",\"-\")))))","v":""},null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",null,null,{"$f":"IF(ISBLANK(R17),\"\",(((R17*R19)+(R18*R20))/(R17+R18)))","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,{"$f":"IF(ISBLANK(E27),\"\",ROUND(AVERAGE(D27,E27),1))","v":""},{"$f":"IF(ISBLANK(D27),\"\",IF(F27>80,\"Needs Correction\",IF(F27>54,\"0\",IF(F27>40,\"3\",IF(F27>1,\"5\",\"-\")))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J27),\"\",AVERAGE(J27:K27))","v":""},{"$f":"IF(ISBLANK(J27),\"\",ABS(F27-L27))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,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(ISBLANK(E91),\"\",ROUND(AVERAGE(D91,E91),1))","v":""},{"$f":"IF(ISBLANK(D91),\"\",IF(F91>80,\"Needs Correction\",IF(F91>54,\"0\",IF(F91>40,\"3\",IF(F91>1,\"5\",\"-\")))))","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,"Adjustments","Total Segment Lengths","Asphalt Bonus"]
[null,null,"Plan Lane Width*",null,"feet",0.05,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,5)","v":0},{"$f":"(G109*$D$109*($D$110/12)/27)*$D$113*$D$111*F109","v":0}]
[null,null,"Plan Overlay Thickness",null,"inches",0.03,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"(G110*$D$109*($D$110/12)/27)*$D$113*$D$111*F110","v":0}]
[null,null,"Plan Overlay Density",null,"(tons/cy)",0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"(G111*$D$109*($D$110/12)/27)*$D$113*$D$111*F111","v":0}]
[null,null,"Mix Type",null,null,"Needs Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},{"$f":"IF(G112>0,\"Contact RE\",\"\")","v":""}]
[null,null,"Asphalt Contract Unit Price ($/ton)",null,null,"Total",{"$f":"SUM(G109:G112)","v":0},{"$f":"SUM(H109:H111)","v":0}]
[]
["*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  "]

{"sheet":"Table 2 - Price Adj - HMA SY","index":6,"n_rows":113,"n_cols":18,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[6,3,6,4],[112,0,113,2],[14,0,14,7],[14,9,14,12],[15,14,15,17],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Multi-lift construction contained in Secs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>125,\"Needs Correction\",IF(F17>70,\"0\",IF(F17>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>125,\"Needs Correction\",IF(F18>70,\"0\",IF(F18>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",AVERAGE(J18:K18))","v":""},{"$f":"IF(ISBLANK(J18),\"\",ABS(F18-L18))","v":""},null,"Second segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",ROUND(AVERAGE(D19,E19),1))","v":""},{"$f":"IF(ISBLANK(D19),\"\",IF(F19>125,\"Needs Correction\",IF(F19>70,\"0\",IF(F19>1,\"3\",\"-\"))))","v":""},null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",{"$f":"IF(ISBLANK(P17),\"\",(((P17*P19)+(P18*P20))/(P17+P18)))","v":""},{"$f":"IF(ISBLANK(Q17),\"\",(((Q17*Q19)+(Q18*Q20))/(Q17+Q18)))","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,{"$f":"IF(ISBLANK(E26),\"\",ROUND(AVERAGE(D26,E26),1))","v":""},{"$f":"IF(ISBLANK(D26),\"\",IF(F26>125,\"Needs Correction\",IF(F26>70,\"0\",IF(F26>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J26),\"\",AVERAGE(J26:K26))","v":""},{"$f":"IF(ISBLANK(J26),\"\",ABS(F26-L26))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,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(ISBLANK(J90),\"\",AVERAGE(J90:K90))","v":""},{"$f":"IF(ISBLANK(J90),\"\",ABS(F90-L90))","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,"Adjustments","Total Length of Segments","Bonus"]
[null,null,"Plan Lane Width*",null,"feet",0.03,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"($D$109*G109/9)*$D$111*F109","v":0}]
[null,null,"HMA Thickness",null,"inches",0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"($D$109*G110/9)*$D$111*F110","v":0}]
[null,null,"HMA Contract Unit Price ($/SY)",null,null,"Needs Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},{"$f":"IF(G111>0,\"Contact RE\",\"\")","v":""}]
[null,null,null,null,null,"Total",{"$f":"SUM(G109:G111)","v":0},{"$f":"SUM(H109:H110)","v":0}]
["*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  "]

{"sheet":"Table 2 - Price Adj - HMA Ton","index":7,"n_rows":125,"n_cols":18,"rows_kept":125,"cut":false,"hidden":false,"merged":[[124,2,124,3],[14,0,14,7],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[117,7,118,7],[14,9,14,12],[15,14,15,17],[7,3,7,4],[0,0,0,7],[1,1,1,7],[2,1,2,7],[3,0,3,7],[6,3,6,4],[114,5,114,6],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[113,5,113,6]]}
[]
[null,"MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
[null,"INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Multi-lift construction contained in Secs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>125,\"Needs Correction\",IF(F17>70,\"0\",IF(F17>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>125,\"Needs Correction\",IF(F18>70,\"0\",IF(F18>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",AVERAGE(J18:K18))","v":""},"",null,"Second segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",ROUND(AVERAGE(D19,E19),1))","v":""},{"$f":"IF(ISBLANK(D19),\"\",IF(F19>125,\"Needs Correction\",IF(F19>70,\"0\",IF(F19>1,\"3\",\"-\"))))","v":""},null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",{"$f":"IF(ISBLANK(P17),\"\",(((P17*P19)+(P18*P20))/(P17+P18)))","v":""},{"$f":"IF(ISBLANK(Q17),\"\",(((Q17*Q19)+(Q18*Q20))/(Q17+Q18)))","v":""},""]
[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(ISBLANK(E24),\"\",ROUND(AVERAGE(D24,E24),1))","v":""},{"$f":"IF(ISBLANK(D24),\"\",IF(F24>125,\"Needs Correction\",IF(F24>70,\"0\",IF(F24>1,\"3\",\"-\"))))","v":""},null,null,null,null,"",{"$f":"IF(ISBLANK(J24),\"\",ABS(F24-L24))","v":""}]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E26),\"\",ROUND(AVERAGE(D26,E26),1))","v":""},{"$f":"IF(ISBLANK(D26),\"\",IF(F26>125,\"Needs Correction\",IF(F26>70,\"0\",IF(F26>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J26),\"\",AVERAGE(J26:K26))","v":""},{"$f":"IF(ISBLANK(J26),\"\",ABS(F26-L26))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,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(ISBLANK(J79),\"\",ABS(F79-L79))","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,{"$f":"IF(ISBLANK(E90),\"\",ROUND(AVERAGE(D90,E90),1))","v":""},{"$f":"IF(ISBLANK(D90),\"\",IF(F90>125,\"Needs Correction\",IF(F90>70,\"0\",IF(F90>1,\"3\",\"-\"))))","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,"",{"$f":"IF(ISBLANK(J99),\"\",ABS(F99-L99))","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,"Plan Lane Width*",null,"feet"]
[null,null,null,null,"Plan Surface Thickness",null,"inches"]
[null,null,null,null,"Plan Base Thickness",null,"inches"]
[null,null,null,null,"Plan Surface Density",null,"(tons/cy)"]
[null,null,null,null,"Plan Base Density",null,"(tons/cy)"]
[null,null,null,null,"Surface Mix Type"]
[null,null,null,null,"Base Mix Type"]
[null,null,null,null,"Contract Unit Price Surface ($/ton)"]
[null,null,null,null,"Contract Unit Price Base ($/ton)"]
[null,null,null,null,null,null,null,"*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  "]
[]
[]
[null,null,"Adjustments",null,"Combined Length of Segments","Surface Asphalt Bonus","Base Asphalt Bonus","Bonus"]
[null,null,0.03,null,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"((($F$109*E122*($F$110/12))/27)*$F$112*$F$116*C122)","v":0},{"$f":"((($F$109*E122*($F$111/12))/27)*$F$113*$F$117*C122)","v":0},{"$f":"F122+G122","v":0}]
[null,null,0,null,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"((($F$109*E123*($F$110/12))/27)*$F$112*$F$116*C123)","v":0},{"$f":"((($F$109*E123*($F$111/12))/27)*$F$113*$F$117*C123)","v":0},{"$f":"F123+G123","v":0}]
[null,null,"Needs Correction",null,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},null,null,{"$f":"IF(E124>0,\"Contact RE\",\"\")","v":""}]
[null,null,"Total",null,{"$f":"SUM(E122:E123)","v":0},{"$f":"SUM(F122:F123)","v":0},{"$f":"SUM(G122:G123)","v":0},{"$f":"SUM(H122:H123)","v":0}]

{"sheet":"Table 2 - Price Adj - PCC SY","index":8,"n_rows":113,"n_cols":18,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[6,3,6,4],[112,0,113,2],[14,0,14,7],[14,9,14,12],[15,14,15,17],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Concrete pavement construction contained in Secs 502 and 506."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>125,\"Needs Correction\",IF(F17>70,\"0\",IF(F17>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>125,\"Needs Correction\",IF(F18>70,\"0\",IF(F18>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",AVERAGE(J18:K18))","v":""},{"$f":"IF(ISBLANK(J18),\"\",ABS(F18-L18))","v":""},null,"Second segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",ROUND(AVERAGE(D19,E19),1))","v":""},{"$f":"IF(ISBLANK(D19),\"\",IF(F19>125,\"Needs Correction\",IF(F19>70,\"0\",IF(F19>1,\"3\",\"-\"))))","v":""},null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",{"$f":"IF(ISBLANK(P17),\"\",(((P17*P19)+(P18*P20))/(P17+P18)))","v":""},{"$f":"IF(ISBLANK(Q17),\"\",(((Q17*Q19)+(Q18*Q20))/(Q17+Q18)))","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,{"$f":"IF(ISBLANK(E26),\"\",ROUND(AVERAGE(D26,E26),1))","v":""},{"$f":"IF(ISBLANK(D26),\"\",IF(F26>125,\"Needs Correction\",IF(F26>70,\"0\",IF(F26>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J26),\"\",AVERAGE(J26:K26))","v":""},{"$f":"IF(ISBLANK(J26),\"\",ABS(F26-L26))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,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(ISBLANK(E90),\"\",ROUND(AVERAGE(D90,E90),1))","v":""},{"$f":"IF(ISBLANK(D90),\"\",IF(F90>125,\"Needs Correction\",IF(F90>70,\"0\",IF(F90>1,\"3\",\"-\"))))","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,"Adjustments","Total Length of Segments","Bonus"]
[null,null,"Plan Lane Width*",null,"feet",0.03,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"(($D$109*G109)/9)*$D$111*F109","v":0}]
[null,null,"PCC Thickness",null,"inches",0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"(($D$109*G110)/9)*$D$111*F110","v":0}]
[null,null,"PCC Contract Unit Price ($/SY)",null,null,"Needs Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},{"$f":"IF(G111>0,\"Contact RE\",\"\")","v":""}]
[null,null,null,null,null,"Total",{"$f":"SUM(G109:G111)","v":0},{"$f":"SUM(H109:H110)","v":0}]
["*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  "]

{"sheet":"Table 2 - Price Adj - Combo SY","index":9,"n_rows":116,"n_cols":18,"rows_kept":116,"cut":false,"hidden":false,"merged":[[0,0,0,7],[14,0,14,7],[11,3,11,4],[12,3,12,4],[3,0,3,7],[2,0,2,7],[1,0,1,7],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[113,0,114,2],[15,14,15,17],[20,14,20,16],[108,5,108,6],[14,9,14,12]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Combination of surface planning, such as diamond grinding or milling, and single lift asphalt construction contained in Secs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>125,\"Needs Correction\",IF(F17>70,\"0\",IF(F17>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>125,\"Needs Correction\",IF(F18>70,\"0\",IF(F18>1,\"3\",\"-\"))))","v":""},null,null,null,null,"","",null,"Second segment length (feet)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",null,null,{"$f":"IF(ISBLANK(R17),\"\",(((R17*R19)+(R18*R20))/(R17+R18)))","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,{"$f":"IF(ISBLANK(E26),\"\",ROUND(AVERAGE(D26,E26),1))","v":""},{"$f":"IF(ISBLANK(D26),\"\",IF(F26>125,\"Needs Correction\",IF(F26>70,\"0\",IF(F26>1,\"3\",\"-\"))))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,{"$f":"IF(ISBLANK(J27),\"\",AVERAGE(J27:K27))","v":""},{"$f":"IF(ISBLANK(J27),\"\",ABS(F27-L27))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,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(ISBLANK(J91),\"\",AVERAGE(J91:K91))","v":""},{"$f":"IF(ISBLANK(J91),\"\",ABS(F91-L91))","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,"Plan Lane Width*",null,"feet"]
[null,null,null,null,"Mix Type"]
[null,null,null,null,"Asphalt Contract Unit Price ($/SY)"]
[]
[null,null,null,null,"Adjustments","Total Segment Lengths","Asphalt Bonus"]
[null,null,null,null,0.03,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"$F$110*E113*F113*$F$108/9","v":0}]
["*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  ",null,null,null,0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"$F$110*E114*F114*$F$108/9","v":0}]
[null,null,null,null,"Needs Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},{"$f":"IF(F115>0,\"Contact RE\",\"\")","v":""}]
[null,null,null,null,"Total",{"$f":"SUM(F113:F115)","v":0},{"$f":"SUM(G113:G114)","v":0}]

{"sheet":"Table 2 - Price Adj - Combo Ton","index":10,"n_rows":118,"n_cols":18,"rows_kept":118,"cut":false,"hidden":false,"merged":[[15,14,15,17],[115,0,116,2],[0,0,0,7],[20,14,20,16],[110,5,110,6],[14,9,14,12],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[1,0,1,7],[2,0,2,7],[3,0,3,7],[14,0,14,7]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Combination of surface planning, such as diamond grinding or milling, and single lift asphalt construction contained in Secs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Paved:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Left Wheel Path IRI (in/mi)","Right Wheel Path IRI (in/mi)","Average IRI (in/mile)","Smoothness Bonus %","Comments",null,"QA Left Wheel Path IRI (in/mi)","QA Right Wheel Path IRI (in/mi)","QA Average IRI (in/mile)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",ROUND(AVERAGE(D17,E17),1))","v":""},{"$f":"IF(ISBLANK(D17),\"\",IF(F17>125,\"Needs Correction\",IF(F17>70,\"0\",IF(F17>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",AVERAGE(J17:K17))","v":""},{"$f":"IF(ISBLANK(J17),\"\",ABS(F17-L17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",ROUND(AVERAGE(D18,E18),1))","v":""},{"$f":"IF(ISBLANK(D18),\"\",IF(F18>125,\"Needs Correction\",IF(F18>70,\"0\",IF(F18>1,\"3\",\"-\"))))","v":""},null,null,null,null,"","",null,"Second segment length (feet)"]
[null,null,null,null,null,"",{"$f":"IF(ISBLANK(D19),\"\",IF(F19>125,\"Needs Correction\",IF(F19>70,\"0\",IF(F19>1,\"3\",\"-\"))))","v":""},null,null,null,null,"","",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"","",null,null,null,null,"","",null,"Weighted IRI",null,null,{"$f":"IF(ISBLANK(R17),\"\",(((R17*R19)+(R18*R20))/(R17+R18)))","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,{"$f":"IF(ISBLANK(E27),\"\",ROUND(AVERAGE(D27,E27),1))","v":""},{"$f":"IF(ISBLANK(D27),\"\",IF(F27>125,\"Needs Correction\",IF(F27>70,\"0\",IF(F27>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J27),\"\",AVERAGE(J27:K27))","v":""},{"$f":"IF(ISBLANK(J27),\"\",ABS(F27-L27))","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,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,null,"",""]
[null,null,null,null,null,"","",null,null,null,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(ISBLANK(E91),\"\",ROUND(AVERAGE(D91,E91),1))","v":""},{"$f":"IF(ISBLANK(D91),\"\",IF(F91>125,\"Needs Correction\",IF(F91>70,\"0\",IF(F91>1,\"3\",\"-\"))))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(J91),\"\",AVERAGE(J91:K91))","v":""},{"$f":"IF(ISBLANK(J91),\"\",ABS(F91-L91))","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,"Plan Lane Width*",null,"feet"]
[null,null,null,null,"Plan Overlay Thickness",null,"inches"]
[null,null,null,null,"Plan Overlay Density",null,"(tons/cy)"]
[null,null,null,null,"Mix Type"]
[null,null,null,null,"Asphalt Contract Unit Price ($/ton)"]
[]
[null,null,null,null,"Adjustments","Total Segment Lengths","Asphalt Bonus"]
[null,null,null,null,0.03,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,3)","v":0},{"$f":"(F115*$F$108*($F$109/12)/27)*$F$112*$F$110*E115","v":0}]
["*Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  ",null,null,null,0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0)","v":0},{"$f":"(F116*$F$108*($F$109/12)/27)*$F$112*$F$110*E116","v":0}]
[null,null,null,null,"Needs Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"Needs Correction\")","v":0},{"$f":"IF(F117>0,\"Contact RE\",\"\")","v":""}]
[null,null,null,null,"Total",{"$f":"SUM(F115:F117)","v":0},{"$f":"SUM(G115:G116)","v":0}]

{"sheet":"Table 3 - Price Adj - Perc Impr","index":11,"n_rows":121,"n_cols":15,"rows_kept":121,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[110,4,110,5],[14,0,14,6],[6,3,6,4],[7,3,7,4],[8,3,8,4],[14,8,14,9],[15,11,15,14],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Single lift asphalt construction contained in Specs 401 and 403."]
[]
[]
[null,null,"Contract ID:",null,null,"Date Paved:"]
[null,null,"Job No.",null,null,"Date Profiled:"]
[null,null,"County:",null,null,"Tested by:"]
[null,null,"Route:",null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,"Lane Number/Type:"]
[null,null,"Paving Subcontractor:",null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Initial Right Wheel Path IRI (in/mi)","Final Right Wheel Path IRI (in/mi)","Smoothness Bonus %","Comments",null,"QA Final Right Wheel Path IRI (in/mi)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D17),\"\",IF(AND(D17<=60,E17<=60),\"0\",IF((((D17-E17)/D17)*100)>34.9,\"3\",IF((((D17-E17)/D17)*100)>19.9,\"0\",IF((((D17-E17)/D17)*100)>0,\"-3\",\"Might Need Correction\")))))","v":""},null,null,null,{"$f":"IF(ISBLANK(I17),\"\",ABS(E17-I17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,"",null,null,null,{"$f":"IF(ISBLANK(I18),\"\",ABS(E18-I18))","v":""},null,"Second segment length (feet)"]
[null,null,null,null,null,"",null,null,null,"",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,"",null,null,null,"",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,"",null,null,null,"",null,"Weighted IRI",{"$f":"IF(ISBLANK(M17),\"\",(((M17*M19)+(M18*M20))/(M17+M18)))","v":""},{"$f":"IF(ISBLANK(N17),\"\",(((N17*N19)+(N18*N20))/(N17+N18)))","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,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,""]
[]
[null,null,null,"Plan Lane Width**",null,"feet"]
[null,null,null,"Plan Overlay Thickness",null,"inches"]
[null,null,null,"Plan Overlay Density",null,"(tons/cy)"]
[null,null,null,"Overlay Mix Type"]
[null,null,null,"Asphalt Contract Unit Price ($/ton)"]
[]
[null,null,null,"Adjustments","Total Length of Segments","Bonus"]
[null,null,null,0.03,{"$f":"SUMIFS($C$17:$C$106,$F$17:$F$106,3)","v":0},{"$f":"D115*$E$112*(($E$108*($E$109/12)*E115)/27)*$E$110","v":0}]
[null,null,null,0,{"$f":"SUMIFS($C$17:$C$106,$F$17:$F$106,0)","v":0},{"$f":"D116*$E$112*(($E$108*($E$109/12)*E116)/27)*$E$110","v":0}]
[null,null,null,-0.03,{"$f":"SUMIFS($C$17:$C$106,$F$17:$F$106,-3)","v":0},{"$f":"D117*$E$112*(($E$108*($E$109/12)*E117)/27)*$E$110","v":0}]
[null,null,null,"Might Need Correction",{"$f":"SUMIFS($C$17:$C$106,$F$17:$F$106,\"Might Need Correction\")","v":0},{"$f":"IF(D118>0,\"Contact RE\",\"\")","v":"Contact RE"}]
[null,null,null,"Total",{"$f":"SUM(E115:E118)","v":0},{"$f":"SUM(F115:F117)","v":0}]
[null,null,"* Any segment with an improvement less than 0% and an initial IRI greater than 60 inches/mile must be corrected."]
[null,null,"**Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  "]

{"sheet":"Table 4 - Price Adj - Diam Grin","index":12,"n_rows":118,"n_cols":16,"rows_kept":118,"cut":false,"hidden":false,"merged":[[14,0,14,7],[14,9,14,10],[15,12,15,15],[7,3,7,4],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[6,3,6,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4]]}
[]
["MISSOURI HIGHWAY AND TRANSPORTATION DEPARTMENT"]
["INTERNATIONAL ROUGHNESS INDEX SUMMARY WORKSHEET"]
["Diamond grinding construction contained in Spec 622.30."]
[]
[]
[null,null,"Contract ID:",null,null,null,"Date Diamond Ground:"]
[null,null,"Job No.",null,null,null,"Date Profiled:"]
[null,null,"County:",null,null,null,"Tested by:"]
[null,null,"Route:",null,null,null,"Direction:"]
[null,null,"Prime Contractor:",null,null,null,"Lane Number/Type:"]
[null,null,"Diamond Grinding Subcontractor:",null,null,null,"Begin Station/LM:"]
[null,null,"Testing Type/Stage:",null,null,null,"End Station/LM:"]
[]
["QC Report",null,null,null,null,null,null,null,null,"QA Report"]
["From Station/ Log Mile","To Station/ Log Mile","Segment Length (feet)","Initial Right Wheel Path IRI (in/mi)","Final Right Wheel Path IRI (in/mi)","Ratio of Final IRI to Initial IRI","Smoothness Bonus ($)","Comments",null,"QA Final Right Wheel Path IRI (in/mi)","QC/QA Difference",null,"Weighted Combined Segment (> 528') IRI Calculation"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D17),\"\",(E17/D17)*100)","v":""},{"$f":"IF(ISBLANK(E17),\"\",IF(AND(E17>80,F17>65),\"May Need Correction\",IF(E17>54,\"0\",IF(E17>40,\"0.15\",\"0.25\"))))","v":""},null,null,null,{"$f":"IF(ISBLANK(J17),\"\",ABS(E17-J17))","v":""},null,"First segment length (feet)"]
[null,null,null,null,null,"",{"$f":"IF(ISBLANK(E18),\"\",IF(AND(E18>80,F18>65),\"May Need Correction\",IF(E18>54,\"0\",IF(E18>40,\"0.15\",\"0.25\"))))","v":""},null,null,null,{"$f":"IF(ISBLANK(J18),\"\",ABS(E18-J18))","v":""},null,"Second segment length (feet)"]
[null,null,null,null,null,"",{"$f":"IF(ISBLANK(E19),\"\",IF(AND(E19>80,F19>65),\"May Need Correction\",IF(E19>54,\"0\",IF(E19>40,\"0.15\",\"0.25\"))))","v":""},null,null,null,"",null,"First segment IRI (inches/mile)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D20),\"\",(E20/D20)*100)","v":""},"",null,null,null,"",null,"Second segment IRI (inches/mile)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D21),\"\",(E21/D21)*100)","v":""},"",null,null,null,"",null,"Weighted IRI",{"$f":"IF(ISBLANK(N17),\"\",(((N17*N19)+(N18*N20))/(N17+N18)))","v":""},{"$f":"IF(ISBLANK(O17),\"\",(((O17*O19)+(O18*O20))/(O17+O18)))","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,{"$f":"IF(ISBLANK(D26),\"\",(E26/D26)*100)","v":""},{"$f":"IF(ISBLANK(E26),\"\",IF(AND(E26>80,F26>65),\"May Need Correction\",IF(E26>54,\"0\",IF(E26>40,\"0.15\",\"0.25\"))))","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,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",null,null,null,""]
[null,null,null,null,null,"","",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(ISBLANK(D84),\"\",(E84/D84)*100)","v":""},{"$f":"IF(ISBLANK(E84),\"\",IF(AND(E84>80,F84>65),\"May Need Correction\",IF(E84>54,\"0\",IF(E84>40,\"0.15\",\"0.25\"))))","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,"Plan Lane Width**",null,"feet"]
[null,null,null,"Diamond Grinding Contract Unit Price ($/SY)"]
[]
[null,null,null,"Adjustments","Total Length of Segments","Bonus"]
[null,null,null,0.25,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0.25)","v":0},{"$f":"($E$108*E112/9)*D112","v":0}]
[null,null,null,0.15,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0.15)","v":0},{"$f":"($E$108*E113/9)*D113","v":0}]
[null,null,null,0,{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,0.15)","v":0},{"$f":"($E$108*E114/9)*D114","v":0}]
[null,null,null,"May Need Correction",{"$f":"SUMIFS($C$17:$C$106,$G$17:$G$106,\"May Need Correction\")","v":0},{"$f":"IF(E115>0,\"Contact RE\",\"\")","v":""}]
[null,null,null,"Total",{"$f":"SUM(E112:E115)","v":0},{"$f":"SUM(F112:F114)","v":0}]
[null,null,null,"* Any segment with final IRI > 80 and percent improvement < 35% must be corrected."]
[null,null,null,"**Use Lane Width in typicals.  Do not include\nshoulder in Lane Width.  "]