{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Fuel Price Adjustment","Asphalt Price Adjustment"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Fuel Price Adjustment","index":0,"n_rows":221,"n_cols":20,"rows_kept":221,"cut":false,"hidden":false,"merged":[[208,1,208,11],[200,1,200,11],[201,1,201,11],[202,1,202,11],[203,1,203,11],[204,1,204,11],[205,1,205,11],[206,1,206,11],[207,1,207,11],[194,1,194,11],[195,1,195,11],[196,1,196,11],[197,1,197,11],[198,1,198,11],[189,1,189,11],[190,1,190,11],[191,1,191,11],[192,1,192,11],[193,1,193,11],[184,1,184,11],[185,1,185,11],[186,1,186,11],[187,1,187,11],[188,1,188,11],[179,1,179,11],[180,1,180,11],[181,1,181,11],[182,1,182,11],[183,1,183,11],[174,1,174,11],[175,1,175,11],[176,1,176,11],[177,1,177,11],[178,1,178,11],[169,1,169,11],[170,1,170,11],[171,1,171,11],[172,1,172,11],[173,1,173,11],[164,1,164,11],[165,1,165,11],[166,1,166,11],[167,1,167,11],[168,1,168,11],[159,1,159,11],[160,1,160,11],[161,1,161,11],[162,1,162,11],[163,1,163,11],[154,1,154,11],[155,1,155,11],[156,1,156,11],[157,1,157,11],[158,1,158,11],[149,1,149,11],[150,1,150,11],[151,1,151,11],[152,1,152,11],[153,1,153,11],[144,1,144,11],[145,1,145,11],[146,1,146,11],[147,1,147,11],[148,1,148,11],[139,1,139,11],[140,1,140,11],[141,1,141,11],[142,1,142,11],[143,1,143,11],[134,1,134,11],[135,1,135,11],[136,1,136,11],[137,1,137,11],[138,1,138,11],[129,1,129,11],[130,1,130,11],[131,1,131,11],[132,1,132,11],[133,1,133,11],[124,1,124,11],[125,1,125,11],[126,1,126,11],[127,1,127,11],[128,1,128,11],[119,1,119,11],[120,1,120,11],[121,1,121,11],[122,1,122,11],[123,1,123,11],[114,1,114,11],[115,1,115,11],[116,1,116,11],[117,1,117,11],[118,1,118,11],[109,1,109,11],[110,1,110,11],[111,1,111,11],[112,1,112,11],[113,1,113,11],[104,1,104,11],[105,1,105,11],[106,1,106,11],[107,1,107,11],[108,1,108,11],[99,1,99,11],[100,1,100,11],[101,1,101,11],[102,1,102,11],[103,1,103,11],[94,1,94,11],[95,1,95,11],[96,1,96,11],[97,1,97,11],[98,1,98,11],[74,1,74,11],[75,1,75,11],[76,1,76,11],[89,1,89,11],[90,1,90,11],[91,1,91,11],[92,1,92,11],[93,1,93,11],[84,1,84,11],[85,1,85,11],[86,1,86,11],[87,1,87,11],[88,1,88,11],[79,1,79,11],[80,1,80,11],[81,1,81,11],[82,1,82,11],[50,1,50,11],[51,1,51,11],[44,1,44,11],[45,1,45,11],[46,1,46,11],[57,1,57,11],[58,1,58,11],[59,1,59,11],[48,1,48,11],[49,1,49,11],[22,1,22,11],[23,1,23,11],[24,1,24,11],[25,1,25,11],[26,1,26,11],[4,14,4,16],[3,18,3,19],[2,0,2,16],[18,0,18,11],[16,0,16,11],[11,14,11,16],[19,1,19,11],[20,1,20,11],[21,1,21,11],[11,0,11,12],[7,0,7,16],[9,0,9,16],[13,0,14,16],[17,15,17,16],[16,13,16,16],[209,1,209,11],[62,1,62,11],[52,1,52,11],[53,1,53,11],[54,1,54,11],[55,1,55,11],[199,1,199,11],[56,1,56,11],[63,1,63,11],[64,1,64,11],[65,1,65,11],[66,1,66,11],[67,1,67,11],[68,1,68,11],[69,1,69,11],[70,1,70,11],[71,1,71,11],[72,1,72,11],[77,1,77,11],[83,1,83,11],[78,1,78,11],[60,1,60,11],[73,1,73,11],[61,1,61,11],[27,1,27,11],[28,1,28,11],[29,1,29,11],[30,1,30,11],[31,1,31,11],[37,1,37,11],[38,1,38,11],[39,1,39,11],[40,1,40,11],[41,1,41,11],[42,1,42,11],[32,1,32,11],[33,1,33,11],[34,1,34,11],[35,1,35,11],[36,1,36,11],[43,1,43,11],[47,1,47,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GREEN SPACES ARE FOR YOUR INPUT"]
["Fuel Price Adjustment - English"]
["Calculation Sheet for Engineer's Estimate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"PROJECT CODES\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:",{"$f":"TODAY()","v":"2024-11-04"},null,null,null,"CODE","DESCRIPTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"New Construction"]
["PROJECT NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Reconstruction, Widening and Dualization"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Widening and Resurfacing"]
["FEDERAL PROJECT NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Resurfacing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Bridge Repair"]
["UPC NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,null,"PROJECT CODE:",null,null,null,6,"Intersection Improvements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Safety and Traffic Control"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Miscellaneous"]
["IF THE COMBINED FUEL REQUIREMENT FOR THE ELIGIBLE ITEMS IS EQUAL TO OR GREATER THAN 500 GALLONS, THEN CALCULATE THE FOLLOWING ACCORDINGLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Unique Project"]
[]
[]
["FUEL PRICE ADJUSTMENT - Item # 160004M",null,null,null,null,null,null,null,null,null,null,null,null,"ENTER QTY IN CONTRACT PAY ITEM UNITS EXCEPT FOR ITEMS WITH *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOR ITEMS WITH *, ENTER QTY IN TONS"]
["ELIGIBLE ITEMS",null,null,null,null,null,null,null,null,null,null,null,"THICKNESS","USAGE FACTOR","UNIT","ADD QTY","GALLONS FOR FUEL PRICE ADJUSTMENT"]
["202009M","EXCAVATION, UNCLASSIFIED",null,null,null,null,null,null,null,null,null,null,null,0.5," G / CY  x ",null,{"$f":"(N20*P20)","v":0}]
["202015P","EXCAVATION, REGULATED MATERIAL",null,null,null,null,null,null,null,null,null,null,null,0.5," G / CY  x ",null,{"$f":"(N21*P21)","v":0}]
["202018P","EXCAVATION, ACID PRODUCING SOIL",null,null,null,null,null,null,null,null,null,null,null,0.5," G / CY  x ",null,0]
["202021P","REMOVAL OF PAVEMENT",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["401017P","MICRO-MILLING",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["401009P","HMA MILLING, 3\" OR LESS",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["401012P","HMA MILLING, MORE THAN 3\" TO 6\"",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["401015P","CONCRETE MILLING,",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["401018P","HMA PROFILE MILLING",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["203003P","BREAKING PAVEMENT",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["305003P","RUBBLIZATION",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["301006P","SUBBASE",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["203009P","I-9 SOIL AGGREGATE",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["203012P","I-10 SOIL AGGREGATE",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["203015P","I-11 SOIL AGGREGATE",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["203018P","I-13 SOIL AGGREGATE",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["203021P","I-14 SOIL AGGREGATE",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["302003P","SOIL AGGREGATE BASE COURSE, 2\" THICK",null,null,null,null,null,null,null,null,null,null,2,1," G / CY  x ",null,{"$f":"(N37*2/36*P37)","v":0}]
["302006P","SOIL AGGREGATE BASE COURSE, 4\" THICK",null,null,null,null,null,null,null,null,null,null,4,1," G / CY  x ",null,{"$f":"(N38*4/36*P38)","v":0}]
["302009P","SOIL AGGREGATE BASE COURSE, 5\" THICK",null,null,null,null,null,null,null,null,null,null,5,1," G / CY  x ",null,{"$f":"(N39*5/36*P39)","v":0}]
["302012P","SOIL AGGREGATE BASE COURSE, 6\" THICK",null,null,null,null,null,null,null,null,null,null,6,1," G / CY  x ",null,{"$f":"(N40*6/36*P40)","v":0}]
["302015P","SOIL AGGREGATE BASE COURSE, 7\" THICK",null,null,null,null,null,null,null,null,null,null,7,1," G / CY  x ",null,{"$f":"(N41*7/36*P41)","v":0}]
["302018P","SOIL AGGREGATE BASE COURSE, 8\" THICK",null,null,null,null,null,null,null,null,null,null,8,1," G / CY  x ",null,{"$f":"(N42*8/36*P42)","v":0}]
["302021P","SOIL AGGREGATE BASE COURSE, 9\" THICK",null,null,null,null,null,null,null,null,null,null,9,1," G / CY  x ",null,{"$f":"(N43*9/36*P43)","v":0}]
["302024P","SOIL AGGREGATE BASE COURSE, 10\" THICK",null,null,null,null,null,null,null,null,null,null,10,1," G / CY  x ",null,{"$f":"(N44*10/36*P44)","v":0}]
["302027P","SOIL AGGREGATE BASE COURSE, 12\" THICK",null,null,null,null,null,null,null,null,null,null,12,1," G / CY  x ",null,{"$f":"(N45*12/36*P45)","v":0}]
["302030P","SOIL AGGREGATE BASE COURSE, VARIABLE THICKNESS",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,{"$f":"(N46*M46/36*P46)","v":0}]
["302033P","DENSE-GRADED AGGREGATE BASE COURSE, 4\" THICK",null,null,null,null,null,null,null,null,null,null,4,1," G / CY  x ",null,{"$f":"(N47*4/36*P47)","v":0}]
["302036P","DENSE-GRADED AGGREGATE BASE COURSE, 6\" THICK",null,null,null,null,null,null,null,null,null,null,6,1," G / CY  x ",null,{"$f":"(N48*6/36*P48)","v":0}]
["302039P","DENSE-GRADED AGGREGATE BASE COURSE, 7\" THICK",null,null,null,null,null,null,null,null,null,null,7,1," G / CY  x ",null,{"$f":"(N49*7/36*P49)","v":0}]
["302042P","DENSE-GRADED AGGREGATE BASE COURSE, 8\" THICK",null,null,null,null,null,null,null,null,null,null,8,1," G / CY  x ",null,{"$f":"(N50*8/36*P50)","v":0}]
["302045P","DENSE-GRADED AGGREGATE BASE COURSE, 10\" THICK",null,null,null,null,null,null,null,null,null,null,10,1," G / CY  x ",null,{"$f":"(N51*10/36*P51)","v":0}]
["302048P","DENSE-GRADED AGGREGATE BASE COURSE, 12\" THICK",null,null,null,null,null,null,null,null,null,null,12,1," G / CY  x ",null,{"$f":"(N52*12/36*P52)","v":0}]
["302050P","DENSE-GRADED AGGREGATE BASE COURSE, 15\" THICK",null,null,null,null,null,null,null,null,null,null,15,1," G / CY  x ",null,{"$f":"(N53*15/36*P53)","v":0}]
["302051P","DENSE-GRADED AGGREGATE BASE COURSE, VARIABLE THICKNESS",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,{"$f":"(N54*M54/36*P54)","v":0}]
["304001P","CONCRETE BASE COURSE, 5\" THICK",null,null,null,null,null,null,null,null,null,null,5,0.25,"G / SY  x",null,{"$f":"(N55*P55)","v":0}]
["304002P","CONCRETE BASE COURSE, 6\" THICK",null,null,null,null,null,null,null,null,null,null,6,0.25,"G / SY  x",null,0]
["304003P","CONCRETE BASE COURSE, 8\" THICK",null,null,null,null,null,null,null,null,null,null,8,0.25,"G / SY  x",null,0]
["304006P","CONCRETE BASE COURSE, 9\" THICK",null,null,null,null,null,null,null,null,null,null,9,0.25,"G / SY  x",null,0]
["304008P","CONCRETE BASE COURSE, 10.5\" THICK",null,null,null,null,null,null,null,null,null,null,10.5,0.25,"G / SY  x",null,0]
["304009P","CONCRETE BASE COURSE, 10\" THICK",null,null,null,null,null,null,null,null,null,null,10,0.25,"G / SY  x",null,0]
["304010P","CONCRETE BASE COURSE, 11\" THICK",null,null,null,null,null,null,null,null,null,null,11,0.25,"G / SY  x",null,0]
["304012P","CONCRETE BASE COURSE, 12\" THICK",null,null,null,null,null,null,null,null,null,null,12,0.25,"G / SY  x",null,0]
["304014P","CONCRETE BASE COURSE, 14\" THICK",null,null,null,null,null,null,null,null,null,null,14,0.25,"G / SY  x",null,0]
["304015P","CONCRETE BASE COURSE, REINFORCED 8\" THICK",null,null,null,null,null,null,null,null,null,null,8,0.25,"G / SY  x",null,0]
["304018P","CONCRETE BASE COURSE, REINFORCED 9\" THICK",null,null,null,null,null,null,null,null,null,null,9,0.25,"G / SY  x",null,0]
["304021P","CONCRETE BASE COURSE, REINFORCED 10\" THICK",null,null,null,null,null,null,null,null,null,null,10,0.25,"G / SY  x",null,0]
["304024P","CONCRETE BASE COURSE, REINFORCED 12\" THICK",null,null,null,null,null,null,null,null,null,null,12,0.25,"G / SY  x",null,0]
["303003M","ASPHALT STABILIZED DRAINAGE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["402003M","OPEN-GRADED 9.5MM FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["402006M","MODIFIED OPEN-GRADED 9.5 MM FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["402009M","MODIFIED OPEN-GRADED 12.5 MM FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["403003M","ULTRA-THIN FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401039M","HOT MIX ASPHALT 9.5L 64 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401042M","HOT MIX ASPHALT 9.5 M 64 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401045M","HOT MIX ASPHALT 9.5 H 64 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401048M","HOT MIX ASPHALT 9.5 M 76 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401049M","HOT MIX ASPHALT 9.5 M E SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401051M","HOT MIX ASPHALT 9.5 H 76 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401054M","HOT MIX ASPHALT 12.5 M 64 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401057M","HOT MIX ASPHALT 12.5 H 64 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401060M","HOT MIX ASPHALT 12.5 M 76 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401061M","HOT MIX ASPHALT 12.5 M E SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401063M","HOT MIX ASPHALT 12.5 H 76 SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401066M","HOT MIX ASPHALT 9.5 M 64 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401069M","HOT MIX ASPHALT 9.5 H 64 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,{"$f":"(N85*P85)","v":0}]
["401072M","HOT MIX ASPHALT 12.5 M 64 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,{"$f":"(N86*P86)","v":0}]
["401073M","HOT MIX ASPHALT 9.5 M E INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401075M","HOT MIX ASPHALT 12.5 H 64 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401078M","HOT MIX ASPHALT 12.5 M 76 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401079M","HOT MIX ASPHALT 12.5 M E INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401081M","HOT MIX ASPHALT 12.5 H 76 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401084M","HOT MIX ASPHALT 19 M 64 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401087M","HOT MIX ASPHALT 19 H 64 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401090M","HOT MIX ASPHALT 19 M 76 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401091M","HOT MIX ASPHALT 19 M E INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401093M","HOT MIX ASPHALT 19 H 76 INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401096M ","HOT MIX ASPHALT 19 M 64 BASE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401099M","HOT MIX ASPHALT 25 M 64 BASE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401102M","HOT MIX ASPHALT 37.5 M 64 BASE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401103M","HOT MIX ASPHALT 25 M 76 BASE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401104M","HOT MIX ASPHALT 19 M 76 BASE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401106M","HOT MIX ASPHALT 25 M E BASE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["401107M","HOT MIX ASPHALT 19 M E BASE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["402006M","MODIFIED OPEN-GRADED 9.5 MM FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["402009M","MODIFIED OPEN-GRADED 12.5 MM FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,{"$f":"(N105*P105)","v":0}]
["403003M","ULTRA-THIN FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["404003M","STONE MATRIX ASPHALT 9.5 MM SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["404006M","STONE MATRIX ASPHALT 12.5 MM SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,{"$f":"(N108*P108)","v":0}]
["406005M","HIGH PERFORMANCE THIN OVERLAY",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["407010M","BINDER RICH INTERMEDIATE COURSE, 4.75MM",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["555006M","BRIDGE DECK WATERPROOF SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["608003P","NONVEGETATIVE SURFACE, HOT MIX ASPHALT *",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["404003M","STONE MATRIX ASPHALT 9.5 MM SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["404006M","STONE MATRIX ASPHALT 12.5 MM SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["405006P","CONCRETE SURFACE COURSE, 8 \" THICK",null,null,null,null,null,null,null,null,null,null,8,0.25,"G / SY  x",null,0]
["405009P","CONCRETE SURFACE COURSE, 9\" THICK",null,null,null,null,null,null,null,null,null,null,9,0.25,"G / SY  x",null,0]
["405012P","CONCRETE SURFACE COURSE, 10\" THICK",null,null,null,null,null,null,null,null,null,null,10,0.25,"G / SY  x",null,0]
["405015P","CONCRETE SURFACE COURSE, 12\" THICK",null,null,null,null,null,null,null,null,null,null,12,0.25,"G / SY  x",null,0]
["405019P","CONCRETE SURFACE COURSE, 18\" THICK",null,null,null,null,null,null,null,null,null,null,18,0.25,"G / SY  x",null,0]
["606012P","CONCRETE SIDEWALK, 4\" THICK",null,null,null,null,null,null,null,null,null,null,4,0.25,"G / SY  x",null,0]
["606015P","CONCRETE SIDEWALK, 5\" THICK",null,null,null,null,null,null,null,null,null,null,5,0.25,"G / SY  x",null,0]
["606018P","CONCRETE SIDEWALK, 6\" THICK",null,null,null,null,null,null,null,null,null,null,6,0.25,"G / SY  x",null,0]
["606021P","CONCRETE SIDEWALK, 8\" THICK",null,null,null,null,null,null,null,null,null,null,8,0.25,"G / SY  x",null,0]
["606024P","CONCRETE SIDEWALK, REINFORCED, 6\" THICK",null,null,null,null,null,null,null,null,null,null,6,0.25,"G / SY  x",null,0]
["606027P","CONCRETE SIDEWALK, REINFORCED, 8\" THICK",null,null,null,null,null,null,null,null,null,null,8,0.25,"G / SY  x",null,0]
["405027P","DIAMOND GRINDING OF CONCRETE SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["455003P","DIAMOND GRINDING EXISTING CONCRETE PAVEMENT",null,null,null,null,null,null,null,null,null,null,null,0.25,"G / SY  x",null,0]
["421010M","SLURRY SEAL AGGREGATE, TYP II",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,0]
["421011M","SLURRY SEAL EMULSION",null,null,null,null,null,null,null,null,null,null,null,0.1,"G / G x",null,0]
["507023P","CONCRETE BRIDGE APPROACH",null,null,null,null,null,null,null,null,null,null,null,0.5," G / CY  x ",null,0]
["602003P","CONCRETE CULVERT",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["504015P","CONCRETE FOOTING",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["504018P","CONCRETE WING WALL",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["504021P","CONCRETE PIER COLUMN Protection, HPC",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["504022P","CONCRETE PIER COLUMN AND CAP",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["504024P","CONCRETE ABUTMENT WALL",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["504030P","CONCRETE PIER SHAFT",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["504033P","CONCRETE PEDESTRIAN BRIDGE",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["507021P","CONCRETE BRIDGE DECK",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["507024P","CONCRETE BRIDGE DECK, HPC",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["507030P","CONCRETE BRIDGE SIDEWALK",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["507033P","CONCRETE BRIDGE SIDEWALK HPC",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["507036P","CONCRETE BRIDGE PARAPET",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["507039P","CONCRETE BRIDGE PARAPET HPC",null,null,null,null,null,null,null,null,null,null,null,1," G / CY  x ",null,0]
["507045M","15\" BY 32\" CONCRETE BARRIER CURB, BRIDGE",null,null,null,null,null,null,null,null,null,null,null,0.12,"G / LF x",null,0]
["507048M","24\" BY 32\" CONCRETE BARRIER CURB, BRIDGE",null,null,null,null,null,null,null,null,null,null,null,0.17,"G / LF x",null,0]
["507190P","21\" BY 34\" CONCRETE BARRIER CURB, BRIDGE",null,null,null,null,null,null,null,null,null,null,null,0.15,"G / LF x",null,0]
["507195P","CONCRETE BARRIER CURB, BRIDGE 24\" x 42\"",null,null,null,null,null,null,null,null,null,null,null,0.21,"G / LF x",null,0]
["502045M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 12 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,12,1," G / CY  x ",null,{"$f":"(PI()*((M149/2)^2)/1296*N149*P149/3)","v":0}]
["502021M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 12 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,12,1," G / CY  x ",null,{"$f":"(PI()*((M150/2)^2)/1296*N150*P150/3)","v":0}]
["502024M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 14 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,14,1," G / CY  x ",null,0]
["502027M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 16 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,16,1," G / CY  x ",null,0]
["502030M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 18 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,18,1," G / CY  x ",null,0]
["502033M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 20 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,20,1," G / CY  x ",null,0]
["502036M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 24 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,24,1," G / CY  x ",null,0]
["502039M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 30 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,30,1," G / CY  x ",null,0]
["502042M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 36 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,36,1," G / CY  x ",null,0]
["502048M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 14 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,14,1," G / CY  x ",null,0]
["502051M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 16 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,16,1," G / CY  x ",null,0]
["502054M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 18 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,18,1," G / CY  x ",null,0]
["502057M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 20 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,20,1," G / CY  x ",null,0]
["502060M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 24 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,24,1," G / CY  x ",null,0]
["502063M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 30 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,30,1," G / CY  x ",null,0]
["502066M","CAST-IN-PLACE CONCRETE PILES, DRIVEN 36 \" DIAMETER ",null,null,null,null,null,null,null,null,null,null,36,1," G / CY  x ",null,0]
["513003P","RETAINING WALL, LOCATION NO.___ ___",null,null,null,null,null,null,null,null,null,null,null,0.1,"G / SF  x",null,{"$f":"(N165*P165)","v":0}]
["608004P","NON-VEGETATIVE SURFACE, POROUS HOT MIX ASPHALT *",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,{"$f":"(N166*P166)","v":0}]
["608006P","COLOR-COATED NON-VEGETATIVE SURFACE, HOT MIX ASPHALT *",null,null,null,null,null,null,null,null,null,null,null,2.5,"G / TON x",null,{"$f":"(N167*P167)","v":0}]
["507059P","CONCRETE MEDIAN BARRIER, HPC",null,null,null,null,null,null,null,null,null,null,null,0.16,"G / LF x",null,{"$f":"(N168*P168)","v":0}]
["607003P","15\" X 41\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003,"G / LF x",null,0]
["607006P","24\" X 32\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.17,"G / LF x",null,0]
["607007P","15\"X54\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.15,"G / LF x",null,0]
["607008P","38\" X 79\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.4,"G / LF x",null,0]
["607009P","24\" X 39\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.18,"G / LF x",null,0]
["607010P","18 5/8\" X 65\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.2,"G / LF x",null,0]
["607011P","32\" X 41\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.24,"G / LF x",null,0]
["607012P","24\" X 41\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.19,"G / LF x",null,0]
["607015P","24\" X 45\" CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.19,"G / LF x",null,0]
["607033P","15\" X 35\" CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.09,"G / LF x",null,0]
["607057P","15\" X VARIABLE HEIGHT CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003,"G / LF x",null,0]
["607060P","24\" X VARIABLE HEIGHT CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.15,"G / LF x",null,0]
["607063P","15\" X VARIABLE HEIGHT CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.24,"G / LF x",null,0]
["607066P","24\" X VARIABLE HEIGHT CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.15,"G / LF x",null,0]
["607035P","19\" X 32\" CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.1,"G / LF x",null,0]
["607036P","24\" X 32\" CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.13,"G / LF x",null,0]
["607037P","24 1/2\" X 53\" CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.18,"G / LF x",null,0]
["607038P","24 1/2\" X VARIABLE HEIGHT CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.15,"G / LF x",null,0]
["607039P","24\" X 35\" CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.13,"G / LF x",null,0]
["607095P","GROUND MOUNTED BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.15,"G / LF x",null,0]
["607110P","15\" X 51\" F SHAPE CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.34,"G / LF x",null,0]
["607111P","24 1/2\" X 51\" F SHAPE CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.23,"G / LF x",null,0]
["607112P","24 1/2\" X __\" F SHAPE CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.23,"G / LF x",null,0]
["607113P","15\" X VARIABLE HEIGHT F SHAPE CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.34,"G / LF x",null,0]
["607114P","15\" X __\" HEIGHT F SHAPE CONCRETE BARRIER CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.34,"G / LF x",null,0]
["607115P","VARIABLE WIDTH X VARIABLE HEIGHT F SHAPE CONCRETE BARRIER CURB",null,null,null,null,null,null,null,null,null,null,null,0.34,"G / LF x",null,0]
["607018P","9\" X 16\" CONCRETE VERTICAL CURB",null,null,null,null,null,null,null,null,null,null,null,0.04,"G / LF x",null,0]
["607021P","9\" X 18\" CONCRETE VERTICAL CURB",null,null,null,null,null,null,null,null,null,null,null,0.04,"G / LF x",null,0]
["607024P","9\" X 20\" CONCRETE VERTICAL CURB",null,null,null,null,null,null,null,null,null,null,null,0.04,"G / LF x",null,0]
["607027P","9\" X 22\" CONCRETE VERTICAL CURB",null,null,null,null,null,null,null,null,null,null,null,0.05,"G / LF x",null,0]
["607034P","9\" X 14\" CONCRETE VERTICAL CURB",null,null,null,null,null,null,null,null,null,null,null,0.03,"G / LF x",null,0]
["607042P","9\" X 4\" CONCRETE VERTICAL CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.01,"G / LF x",null,0]
["607045P","9\" X 6\" CONCRETE VERTICAL CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.01,"G / LF x",null,0]
["607048P","9\" X 8\" CONCRETE VERTICAL CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.02,"G / LF x",null,0]
["607051P","9\" X 10\" CONCRETE VERTICAL CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.02,"G / LF x",null,0]
["607030P","12\" X 13\" CONCRETE SLOPING CURB",null,null,null,null,null,null,null,null,null,null,null,0.04,"G / LF x",null,0]
["607054P","12\" X 3\" CONCRETE SLOPING CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.01,"G / LF x",null,0]
["607055P","_\"X_\" CONCRETE SLOPING CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.01,"G / LF x",null,0]
["607069P","9\" X VARIABLE HEIGHT CONCRETE VERTICAL CURB",null,null,null,null,null,null,null,null,null,null,null,0.04,"G / LF x",null,0]
["607072P","9\" X VARIABLE HEIGHT CONCRETE VERTICAL CURB, DOWELLED",null,null,null,null,null,null,null,null,null,null,null,0.02,"G / LF x",null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(Q20:Q210)","v":0}]
[" NOTE: Add all items from Table160.03.01-1 of the Special Provisions."]
[]
[]
[null,null,null,null,null,null,null,null,"NO. OF GALLONS FOR FUEL PRICE ADJUSTMENT",null,null,null,null,null,{"$f":"Q211","v":0}]
[null,null,null,null,null,null,null,null,"CURRENT PRICE PER \"GALLON\" LATEST MONTH"]
[null,null,null,null,null,null,null,null,"PERIOD OF CONSTRUCTION MONTHS:",null,null,null,null,null,{"$f":"N217/12","v":0}]
[null,null,null,null,null,null,null,null,"INFLATION RATE",null,null,null,null,null,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"O215*O216*O217*O218","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUND UP TO THE NEAREST $100.00",{"$f":"ROUNDUP(O219,-2)","v":0}]

{"sheet":"Asphalt Price Adjustment","index":1,"n_rows":73,"n_cols":20,"rows_kept":73,"cut":false,"hidden":false,"merged":[[39,0,39,11],[38,0,38,11],[37,0,37,11],[71,0,71,10],[71,11,71,12],[64,0,64,11],[66,0,66,10],[66,11,66,12],[67,0,67,10],[67,11,67,12],[68,0,68,10],[68,11,68,12],[69,0,69,10],[69,11,69,12],[70,0,70,10],[70,11,70,12],[57,11,57,12],[55,0,55,10],[56,0,56,10],[57,0,57,10],[54,0,54,10],[48,10,48,11],[52,0,52,11],[54,11,54,12],[55,11,55,12],[56,11,56,12],[48,0,48,9],[2,0,2,16],[17,0,17,11],[19,0,19,11],[25,0,25,11],[20,0,20,11],[21,0,21,11],[22,0,22,11],[23,0,23,11],[24,0,24,11],[11,14,11,16],[6,0,6,16],[8,0,8,16],[10,0,10,12],[10,14,10,16],[18,0,18,11],[3,18,3,19],[7,0,7,16],[9,0,9,16],[11,0,11,12],[16,0,16,9],[4,14,4,16],[13,0,14,16],[36,0,36,11],[26,0,26,11],[27,0,27,11],[35,0,35,11],[30,0,30,11],[31,0,31,11],[32,0,32,11],[33,0,33,11],[34,0,34,11],[28,0,28,11],[29,0,29,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GREEN SPACES ARE FOR YOUR INPUT"]
["Asphalt Price Adjustment - English"]
["Calculation Sheet for Engineer's Estimate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"PROJECT CODES\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:",{"$f":"TODAY()","v":"2024-11-04"},null,null,null,"CODE","DESCRIPTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"New Construction"]
["PROJECT NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Reconstruction, Widening and Dualization"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Widening and Resurfacing"]
["FEDERAL PROJECT NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Resurfacing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Bridge Repair"]
["UPC NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,null,"PROJECT CODE:",null,null,null,6,"Intersection Improvements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Safety and Traffic Control"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Miscellaneous"]
["IF THE COMBINED WEIGHT OF THE BITUMINOUS MATERIAL IS EQUAL TO OR GREATER THAN 1,000 TONS, THEN CALCULATE THE FOLLOWING ACCORDINGLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Unique Project"]
[]
[]
["ASPHALT PRICE ADJUSTMENT-Item#160007M"]
["ELIGIBLE ITEMS",null,null,null,null,null,null,null,null,null,null,null,"UNIT","USAGE FACTOR","QUANTITY IN THE ITEMS UNIT","QUANTITY CONVERTED TO TONS","TONS FOR ASPHALT PRICE ADJUSTMENT"]
["HMA PATCH",null,null,null,null,null,null,null,null,null,null,null,"T",0.05,null,{"$f":"O19","v":0},{"$f":"IF(P$41>=1000,N19*P19,0)","v":0}]
["HOT MIX ASPHALT PAVEMENT REPAIR",null,null,null,null,null,null,null,null,null,null,null,"SY",1.4999999999999999E-2,null,{"$f":"12*O20*0.06","v":0},0]
["HOT MIX ASPHALT SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,"T",0.05,null,{"$f":"O21","v":0},0]
["HOT MIX ASPHALT INTERMEDIATE COURSE",null,null,null,null,null,null,null,null,null,null,null,"T",0.05,null,0,0]
["HOT MIX ASPHALT BASE COURSE",null,null,null,null,null,null,null,null,null,null,null,"T",4.4999999999999998E-2,null,0,0]
["OPEN-GRADED FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,"T",0.05,null,0,0]
["MODIFIED OPEN-GRADED FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,"T",0.06,null,0,0]
["ASPHALT-RUBBER OPEN GRADED FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,"T",0.08,null,0,0]
["ULTRA-THIN FRICTION COURSE",null,null,null,null,null,null,null,null,null,null,null,"T",0.06,null,0,0]
["STONE MATRIX ASPHALT SURFACE COURSE",null,null,null,null,null,null,null,null,null,null,null,"T",6.5000000000000002E-2,null,0,0]
["HIGH PERFORMANCE THIN OVERLAY",null,null,null,null,null,null,null,null,null,null,null,"T",0.06,null,0,0]
["FULL DEPTH CONCRETE PAVEMENT REPAIR,HMA",null,null,null,null,null,null,null,null,null,null,null,"SY",1.6500000000000001E-2,null,{"$f":"12*O30*0.06","v":0},0]
["HOT MIX ASPHALT SIDEWALK,THICK",null,null,null,null,null,null,null,null,null,null,null,"SY",5.5999999999999999E-3,null,{"$f":"4*O31*0.06","v":0},0]
["HOT MIX ASPHALT DRIVEWAY,THICK",null,null,null,null,null,null,null,null,null,null,null,"SY",5.5999999999999999E-3,null,{"$f":"4*O32*0.06","v":0},0]
["HOT MIX ASPHALT ISLAND,THICK",null,null,null,null,null,null,null,null,null,null,null,"SY",5.5999999999999999E-3,null,{"$f":"4*O33*0.06","v":0},0]
["NON-VEGETATIVE SURFACE, HOT MIX ASPHALT",null,null,null,null,null,null,null,null,null,null,null,"SY",8.3999999999999995E-3,null,{"$f":"6*O34*0.06","v":0},0]
["NON-VEGETATIVE SURFACE,POROUS HOT MIX ASPHALT",null,null,null,null,null,null,null,null,null,null,null,"SY",8.3999999999999995E-3,null,{"$f":"6*O35*0.06","v":0},0]
["COLOR-COATED NON-VEGETATIVE SURFACE, HOT MIX ASPHALT",null,null,null,null,null,null,null,null,null,null,null,"SY",8.3999999999999995E-3,null,{"$f":"6*O36*0.06","v":0},0]
["SLURRY SEAL",null,null,null,null,null,null,null,null,null,null,null,"T",null,null,{"$f":"P59","v":0},{"$f":"IF(P$41>=1000,P37,0)","v":0}]
["TACK COAT",null,null,null,null,null,null,null,null,null,null,null,"GAL",null,null,{"$f":"P73","v":0},{"$f":"IF(P$41>=1000,P38,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P19:P40)","v":0},{"$f":"SUM(Q19:Q40)","v":0}]
[]
["NUMBER OF TONS FOR ASPHALT PRICE ADJUSTMENT",null,null,null,null,null,null,null,null,null,null,{"$f":"Q41","v":0}]
["CURRENT PRICE PER \"TON\" FOR LATEST MONTH"]
["PERIOD OF CONSTRUCTION MONTHS",null,null,null,null,null,null,null,null,null,null,{"$f":"(K45/12)","v":0}]
["INFLATION RATE",null,null,null,null,null,null,null,null,null,null,0.05]
[null,null,null,null,null,null,null,null,null,null,"Total ",{"$f":"L43*L44*L45*L46","v":0}]
[]
["ROUND UP TO NEAREST $100",null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(L47,-2)","v":0}]
[]
[]
[]
["SLURRY SEAL"]
[]
["ELIGIBLE SLURRY SEAL ITEMS",null,null,null,null,null,null,null,null,null,null,"UNIT",null,"PETROLEUM  CONTENT % BY VOLUME","GALLONS FURNISHED","TONS"]
["MICRO-SURFACING EMULSION",null,null,null,null,null,null,null,null,null,null,"EMULSION-GAL",null,60,null,{"$f":"(N56/100*O56*(8.25/2000))","v":0}]
["SLURRY SEAL EMULSION",null,null,null,null,null,null,null,null,null,null,"EMULSION-GAL",null,60,null,{"$f":"(N57/100*O57*(8.25/2000))","v":0}]
["MICROPAVING JOINTS",null,null,null,null,null,null,null,null,null,null,"EMULSION-GAL",null,60,null,{"$f":"(N58/100*O58*(8.25/2000))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(P56:P58)","v":0}]
[]
["Note:"]
["60% for RS or Similar type emulsions"]
[]
[]
["TACK COAT/PRIME COAT"]
[]
["ELIGIBLE ITEMS",null,null,null,null,null,null,null,null,null,null,"UNIT",null,"PETROLEUM  CONTENT % BY VOLUME","GALLONS FURNISHED","TONS"]
["TACK COAT",null,null,null,null,null,null,null,null,null,null,"GAL",null,60,null,{"$f":"(N68/100*O68*(8.25/2000))","v":0}]
["TACK COAT 64-22",null,null,null,null,null,null,null,null,null,null,"GAL",null,60,null,{"$f":"(N69/100*O69*(8.25/2000))","v":0}]
["TACK COAT 76-22",null,null,null,null,null,null,null,null,null,null,"GAL",null,60,null,{"$f":"(N70/100*O70*(8.25/2000))","v":0}]
["POLYMER MODIFIED TACK COAT",null,null,null,null,null,null,null,null,null,null,"GAL",null,60,null,{"$f":"(N71/100*O71*(8.25/2000))","v":0}]
["PRIME COAT",null,null,null,null,null,null,null,null,null,null,"GAL",null,60,null,{"$f":"(N72/100*O72*(8.25/2000))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(P68:P72)","v":0}]