{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["REMOVALS","MILLING","EXCAVATION","AGGREGATE","ASPHALT","PIPES","RIPRAP","EROSION","STAKING","TC","SIGNING","MARKINGS","SAWCUTS"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"REMOVALS","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,5,6,5],[4,6,6,6],[4,7,6,7],[1,1,1,6],[2,1,2,6]]}
[]
[null,"REMOVALS"]
[null,"PROJECT ID: 6210-01-60"]
[null,null,null,null,null,203.01,"204.9060.S"]
[null,null,null,null,null,"REMOVING SMALL PIPE CULVERTS","REMOVING               01. ENDWALL"]
[]
[]
[null,"ROADWAY","STATION","TO","STATION","EACH","EACH"]
[null,"STH 49","65+55",null,"65+55","-",2]
[null,"STH 49","94+09",null,"94+09",1,"-"]
[null,"STH 49","155+01",null,"155+01","-",2]
[null,"STH 49","161+35",null,"161+66","-",2]
[null,"STH 49","235+33",null,"235+33","-",2]
[null,"STH 49","278+31",null,"278+90",1,"-"]
[null,"TOTAL",null,null,null,{"$f":"SUM(F9:F14)","v":2},{"$f":"SUM(G9:G14)","v":8}]
[]
[null,"CALC'D BY:  JG"]
[null,"CHECKED BY:  JLW","TJO"]

{"sheet":"MILLING","index":1,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,6,7,6],[4,5,7,5],[1,1,1,6],[2,1,2,6]]}
[]
[null,"ASPHALTIC SURFACE MILLING"]
[null,"PROJECT ID: 6210-00-73"]
[null,null,null,null,null,204.01150000000001,204.012]
[null,null,null,null,null,"REMOVING ASPHALTIC SURFACE BUTT JOINTS","REMOVING ASPHALTIC SURFACE MILLING"]
[]
[]
[]
[null,"ROADWAY","STA ","TO","STA ","SY","SY",null,"Length (ft)","Width (ft)",null,"Autocad flood of HMA area = 735,051.79 SF"]
[null,"STH 49",5535.25,null,5537.25,{"$f":"(I10*J10)/9","v":6.666666666666667},"-",null,{"$f":"E10-C10","v":2},30,null,"See J:\\Active\\NC\\6210-00-03 STH 49\\C3D\\62100003\\Design\\Quantities\\90% Quantities\\GRB_MQs_90_pavt-STH 49.dwg"]
[null,"CTH X",10815,null,"-",6.666666666666667,"-",null,2,30]
[null,"CYPRESS AVE",16211,null,"-",14,"-",null,4,30]
[null,"CUMBERLAND AVE",21790,null,"-",6.666666666666667,"-",null,2,30]
[null,"CREE AVE",28575,null,"-",6.666666666666667,"-",null,2,30]
[null,"STH 49",28918,null,28919.73,6.666666666666667,"-",null,2,30]
[null,"STH 49",5535.25,null,28919.73,"-",{"$f":"CEILING(((735051.79)/9),100)","v":81700},null,{"$f":"+E16-C16","v":23384.48},30]
[null,"TOTAL",null,null,null,49,{"$f":"SUM(G16:G16)","v":81700}]
[]
[]
[]
[]
[null,"CALC'D BY:  JG"]
[null,"CHECKED BY: TJO"]
[null,"UPDATED BY: GRB 10/26/2018"]
[null,"UPDATED BY: JAG 1/16/19"]

{"sheet":"EXCAVATION","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,7,7,10],[7,11,7,14],[4,5,7,5],[4,6,7,6],[1,1,1,5],[2,1,2,5]]}
[]
[null,"EXCAVATION COMMON"]
[null,"PROJECT ID: 6210-01-60"]
[null,null,null,null,null,205.01]
[null,null,null,null,null,"EXCAVATION  COMMON"]
[]
[]
[null,null,null,null,null,null,null,"RECTANGLE AREA",null,null,null,"TRIANGLE AREA"]
[null,"ROADWAY","STA ","TO","STA ","CY",null,"LENGTH","WIDTH","HEIGHT","AREA","BASE","HEIGHT","WIDTH","AREA"]
[null,"STH 49",9359,null,"94+59",{"$f":"K10+O10","v":679.78395061728395},null,100,50,{"$f":"18.25/12","v":1.5208333333333333},{"$f":"(H10*I10*J10)/27","v":281.6358024691358},50,4.3,50,{"$f":"0.5*L10*M10*N10*2/27","v":398.14814814814815}]
[null,"STH 49",27781,null,27940,{"$f":"K11+O11","v":744.59876543209884},null,100,50,{"$f":"18.25/12","v":1.5208333333333333},{"$f":"H11*I11*J11/27","v":281.6358024691358},50,5,50,{"$f":"0.5*L11*M11*N11*2/27","v":462.96296296296299}]
[null,"TOTAL",null,null,null,1490]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CALC'D BY:  JAG 1/16/2019"]

{"sheet":"AGGREGATE","index":3,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,8,7,8],[2,7,2,8],[1,1,1,8],[4,6,7,6],[4,5,7,5],[2,5,2,6],[4,7,7,7]]}
[]
[null,"AGGREGATE ITEMS"]
[null,null,null,null,null,"PROJECT ID: 6210-00-73",null,"PROJECT ID: 6210-01-60"]
[null,null,null,null,null,305.01100000000002,624.01,305.012,624.01]
[null,null,null,null,null,"BASE AGGREGATE DENSE 3/4-INCH","WATER","BASE AGGREGATE DENSE 1 1/4-INCH","WATER"]
[]
[]
[]
[null,"ROADWAY","STA ","TO","STA ","TON","MGAL","TON","MGAL",null,null,"Length (ft)","Width (ft)","Depth (ft)"]
[null,"STH 49",5535.25,null,28919.73,{"$f":"CEILING((((23385*14*0.17)/27)*2.1),50)","v":4350},{"$f":"CEILING(F10/100,1)","v":44},"-","-",null,null,23385,14,0.17]
[null,"STH 49",9359,null,9459,"-","-",{"$f":"CEILING((((100*50*1)/27)*2),10)","v":380},"-",null,null,100,50,1]
[null,"STH 49",27797,null,27911,"-","-",{"$f":"CEILING((((114*50*1)/27)*2),10)","v":430},"-",null,null,114,50,1]
[null,"UNDISTRIBUTED",null,null,null,"-","-","-",9]
[null,"TOTAL",null,null,null,{"$f":"SUM(F10)","v":4350},{"$f":"SUM(G10)","v":44},{"$f":"SUM(H11:H12)","v":810},{"$f":"CEILING(SUM(I10:I13),1)","v":9}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"FDM 14-15-10.2.2 Table 10.1 "]
[null,"CALC'D BY:  JG",null,null,null,null,null,null,null,null,null,"3/4-Inch = 2.1 TON/CY"]
[null,"CHECKED BY:  TJO",null,null,null,null,null,null,null,null,null,"1 1/4-Inch = 2.0 TON/CY"]
[null,"UPDATED BY: GRB 10/26/2018"]
[null,"UPDATED BY: JAG 12/4/2108"]

{"sheet":"ASPHALT","index":4,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,18,9,21],[5,7,8,7],[1,1,1,9],[5,6,8,6],[5,5,8,5],[3,5,3,7],[5,8,8,8],[5,9,8,9],[3,8,3,9]]}
[]
[null,"ASPHALT ITEMS"]
[]
[null,null,null,null,null,"PROJECT ID: 6210-00-73",null,null,"PROJECT ID: 6210-01-60"]
[null,null,null,null,null,460.5224,455.06049999999999,465.04750000000001,460.5224,455.06049999999999]
[null,null,null,null,null,"HMA PAVEMENT 4 LT 58-28 S","TACK COAT","ASPHALTIC CENTERLINE RUMBLE STRIPS 2-LANE RURAL","HMA PAVEMENT 4 LT 58-28 S","TACK COAT"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comment"]
[null,"ROADWAY","STA ","TO","STA ","TON","GAL","LF","TON","GAL",null,null,null,null,null,null,null,null,"Driveway Gaps=6500 (rumble strips)"]
[null,"STH 49",5535.25,null,28919.73,{"$f":"CEILING(((735051.79/9)*110*1.75)/2000,100)","v":7900},{"$f":"CEILING(((735051.79/9)*0.07),100)","v":5800},{"$f":"CEILING((E11-C11)-6500,5)","v":16885},"-","-"]
[null,"STH 49",9359,null,9459,"-","-","-",{"$f":"CEILING((((30*100)/9)*110*4.5)/2000,5)","v":85},{"$f":"CEILING(((2*(100*30)/9)*0.07),5)","v":50},null,"Pipe = 100' open cut HMA width",null,null,null,null,null,null,"Autocad flood of HMA area = 735,051.79 SF"]
[null,"STH 49",27797,null,27911,"-","-","-",{"$f":"CEILING((((30*114)/9)*110*4.5)/2000,5)","v":95},{"$f":"CEILING(((2*(114*30)/9)*0.07),5)","v":55},null,"Scew pipe = 114' open cut HMA width",null,null,null,null,null,null,"See J:\\Active\\NC\\6210-00-03 STH 49\\C3D\\62100003\\Design\\Quantities\\90% Quantities\\GRB_MQs_90_pavt-STH 49.dwg"]
[null,"TOTAL",null,null,null,{"$f":"SUM(F11:F13)","v":7900},{"$f":"SUM(G11:G13)","v":5800},{"$f":"SUM(H11:H13)","v":16885},{"$f":"SUM(I11:I13)","v":180},{"$f":"SUM(J11:J13)","v":105}]
[]
[]
[null,"CALC'D BY: JG"]
[null,"CHECKED BY:  TJO"]
[null,"UPDATED BY: GRB 10/26/2018"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"440.4410 and 460.2000 Based on FDM 19-21-2 2.2.1 and 2.2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rumble Strips LF reduced by 400 for Project Intersections"]

{"sheet":"PIPES","index":5,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,7,16,8],[2,1,2,8],[1,0,1,9],[4,9,7,9],[4,14,7,14],[4,15,7,15],[4,16,7,16],[4,5,7,5],[4,6,7,6],[4,7,7,7],[4,8,7,8]]}
[]
["CULVERT PIPES"]
[null,"PROJECT ID: 6210-01-60"]
[null,null,null,null,null,521.10239999999999,521.10360000000003,"522.1048*","522.0148*","SPV.0060.01",null,null,null,null,"SPV.0060.01","SPV.0060.01","SPV.0060.01"]
[null,null,null,null,null,"APRON ENDWALLS FOR CULVERT PIPE STEEL 24-INCH","APRON ENDWALLS FOR CULVERT PIPE STEEL 36-INCH","APRON ENDWALLS FOR CULVERT PIPE REINFORCED CONCRETE 48-INCH","CULVERT PIPE REINFORCED CONCRETE CLASS III 48-INCH","LANE SHIFT",null,null,null,null,"LANE SHIFT","LANE SHIFT COMMON EX","LANE SHIFT BASE AGGREGATE"]
[]
[]
[]
["CULVERT #","ROADWAY","STATION","TO","STATION","EACH","EACH","EACH","LF","EACH",null,null,null,null,"EACH","CY","TON"]
[690490010,"STH 49","65+55",null,"65+55","-",2,"-","-","-",null,null,null,null,"-","-","-"]
[690490020,"STH 49","94+09",null,"94+09","-","-",2,{"$f":"100.33-(98/12*2)","v":83.99666666666667},2,null,null,null,null,2,192,{"$f":"(814.5*(0.5/3))*2","v":271.5}]
[690490040,"STH 49","155+01",null,"155+01",2,"-","-","-","-",null,null,null,null,"-","-","-"]
[690490050,"STH 49","161+35",null,"161+66",2,"-","-","-","-",null,null,null,null,"-","-","-"]
[690490060,"STH 49","235+33",null,"235+33",2,"-","-","-","-",null,null,null,null,"-","-","-"]
[690490080,"STH 49","278+31",null,"278+90","-","-",2,{"$f":"136.33-(98/12*2)","v":119.99666666666668},2,null,null,null,null,2,208,{"$f":"(912.2*(0.5/3))*2","v":304.06666666666666}]
[null,"TOTAL",null,null,null,{"$f":"SUM(F10:F15)","v":6},{"$f":"SUM(G10:G15)","v":2},{"$f":"SUM(H10:H15)","v":4},{"$f":"SUM(I10:I15)","v":203.99333333333334},{"$f":"SUM(J10:J15)","v":4},null,null,null,null,{"$f":"SUM(O10:O15)","v":4},{"$f":"SUM(P10:P15)","v":400},{"$f":"SUM(Q10:Q15)","v":575.56666666666661}]
[null,null,null,null,null,null,null,"*TIE ALL JOINTS",null,null,null,null,null,null,null,"@$20.00/CY","@$20.00/TON"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P16*20","v":8000},{"$f":"Q16*20","v":11511.333333333332}]
[null,"CALC'D BY:  JG"]
[null,"CHECKED BY: TJO"]
[null,"UPDATED BY: GRB 10/26/2018"]

{"sheet":"RIPRAP","index":6,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,6],[4,5,5,5],[4,6,5,6],[2,1,2,6]]}
[]
[null,"RIPRAP"]
[null,"PROJECT ID: 6210-01-60"]
[null,null,null,null,null,606.01,645.01300000000003]
[null,null,null,null,null,"RIPRAP        LIGHT","GEOTEXTILE     TYPE R"]
[]
[null,"ROADWAY","STATION","TO","STATION","CY","SY"]
[null,"STH 49","65+55",null,"65+55",2.6666666666666665,14]
[null,"STH 49","94+09",null,"94+09",2,12]
[null,"STH 49","155+01",null,"155+01",2,12]
[null,"STH 49","161+35",null,"161+66",2,12]
[null,"STH 49","235+33",null,"235+33",2,12]
[null,"STH 49","278+31",null,"278+90",2,12]
[null,"TOTAL",null,null,null,{"$f":"SUM(F8:F13)","v":12.666666666666666},{"$f":"SUM(G8:G13)","v":74}]
[]
[]
[]
[null,"CALC'D BY:  JG","GRB"]
[null,"CHECKED BY: TJO"]
[null,"UPDATED BY: JAG 1/22/19"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"RIPRAP","GEOTEXTILE"]
[null,null,null,null,null,null,null,null,null,"W (FT)","L (FT)","CY","SY"]
[null,null,null,null,null,null,null,null,"24\" STEEL AEW",6,4,{"$f":"(J26*K26*1)/27","v":0.88888888888888884},{"$f":"((J26+2)*(K26+2))/9","v":5.333333333333333}]
[null,null,null,null,null,null,null,null,"36\" STEEL AEW",8,4,{"$f":"(J27*K27*1)/27","v":1.1851851851851851},{"$f":"((J27+2)*(K27+2))/9","v":6.666666666666667}]
[null,null,null,null,null,null,null,null,"48\" CPRC AEW",7,4,1.037037037037037,{"$f":"((J28+2)*(K28+2))/9","v":6}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Following Construction detail in Plans"]

{"sheet":"EROSION","index":7,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,5,7,5],[1,1,1,13],[2,1,2,13],[5,12,7,12],[5,15,7,15],[5,6,7,6],[5,7,7,7],[5,8,7,8],[5,9,7,9],[5,10,7,10],[5,11,7,11],[5,13,7,13]]}
[]
[null,"EROSION CONTROL"]
[null,"PROJECT ID: 6210-01-60"]
[]
[null,null,null,null,null,625.04999999999995,628.15039999999999,628.15200000000004,628.20079999999996,628.75549999999998,629.02099999999996,630.01300000000003,630.02,633.52]
[null,null,null,null,null,"SALVAGED TOPSOIL","SILT FENCE","SILT FENCE MAINTENANCE","EROSION MAT URBAN CLASS 1 TYPE B","CULVERT PIPE CHECKS","FERTILIZER TYPE B","SEEDING MIXTURE NO. 30","SEEDING TEMPORARY","MARKERS CULVERT END"]
[]
[]
[null,"ROADWAY","STATION","TO","STATION","SY","LF","LF","SY","EACH","CWT","LB","LB","EACH"]
[null,"STH 49","65+55",null,"65+55",{"$f":"I10","v":40},100,100,40,4,{"$f":"CEILING(((I10*9)/1000)*7/100,0.1)","v":0.1},{"$f":"((I10*9)/1000)*2","v":0.72},{"$f":"((I10*9)/1000)*3","v":1.08},2]
[null,"STH 49","94+09",null,"94+09",{"$f":"I11","v":815},550,550,815,6,0.60000000000000009,{"$f":"((I11*9)/1000)*2","v":14.67},{"$f":"((I11*9)/1000)*3","v":22.004999999999999},2]
[null,"STH 49","155+01",null,"155+01",40,100,100,40,2,0.1,{"$f":"((I12*9)/1000)*2","v":0.72},1.08,2]
[null,"STH 49","161+35",null,"161+66",40,100,100,40,2,0.1,{"$f":"((I13*9)/1000)*2","v":0.72},1.08,2]
[null,"STH 49","235+33",null,"235+33",40,100,100,40,2,0.1,{"$f":"((I14*9)/1000)*2","v":0.72},1.08,2]
[null,"STH 49","278+31",null,"278+90",915,600,600,915,6,0.60000000000000009,{"$f":"CEILING(((I15*9)/1000)*2,1)","v":17},{"$f":"((I15*9)/1000)*3","v":24.704999999999998},2]
[null,"TOTAL",null,null,null,{"$f":"SUM(F10:F15)","v":1890},1550,1550,1890,22,1.6,{"$f":"CEILING(SUM(L10:L15),1)+1","v":36},{"$f":"SUM(M10:M15)","v":51.029999999999994},{"$f":"SUM(N10:N15)","v":12}]
[]
[]
[]
[]
[]
[null,"CALC'D BY:  JG"]
[null,"CHECKED BY: TJO"]
[null,"UPDATED BY: JAG 1/16/2019"]

{"sheet":"STAKING","index":8,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,6,7,6],[4,7,7,7],[4,5,7,5],[2,6,2,7],[1,1,1,7]]}
[]
[null,"CONSTRUCTION STAKING"]
[null,null,null,null,null,"PROJECT ID: 6210-01-60","PROJECT ID: 6210-00-73"]
[null,null,null,null,null,650.6,650.79999999999995,650.99099999999999]
[null,null,null,null,null,"CONSTRUCTION STAKING PIPE CULVERTS","CONSTRUCTION STAKING RESURFACING REFRENCE","CONSTRUCTION STAKING SUPPLEMENTAL CONTROL"]
[]
[]
[]
[null,"ROADWAY","STATION","TO","STATION","EACH","LF","LS"]
[null,"STH 49",5535.25,null,28919.73,"-",23390,1]
[null,"STH 49","94+09",null,"94+09",1,"-","-"]
[null,"STH 49","278+31",null,"278+90",1,"-","-"]
[null,"TOTAL",null,null,null,{"$f":"SUM(F10:F12)","v":2},23390,1]
[]
[]
[]
[]
[null,"CALC'D BY:  JG"]
[null,"CHECKED BY: TJO"]

{"sheet":"TC","index":9,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,3,13,4],[14,3,14,4],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[11,3,11,4],[12,3,12,4],[10,7,10,8],[11,7,11,8],[12,7,12,8],[9,1,9,8],[3,7,3,8],[4,7,4,8],[6,7,6,8],[7,7,7,8],[10,3,10,4],[13,7,13,8],[14,7,14,8],[17,1,17,8],[2,1,2,8],[1,1,1,8],[5,3,5,4],[6,3,6,4],[7,3,7,4],[5,5,5,6],[6,5,6,6],[7,5,7,6],[5,7,5,8],[3,3,3,4],[4,3,4,4],[3,5,3,6],[4,5,4,6]]}
[]
[null,"TRAFFIC CONTROL"]
[null,"PROJECT ID: 6210-01-60"]
[null,null,null,643.09,null,"643.0310.S",null,643.03]
[null,null,"DURATION","TRAFFIC CONTROL SIGNS",null,"TEMPORARY PORTABLE RUMBLE STRIPS (project) 02. 6210-01-60",null,"TRAFFIC CONTROL DRUMS"]
[null,"LOCATION","DAYS","DAY",null,"LS",null,"DAY",null,null,null,null,null,"CALC'D BY: JG"]
[null,"PROJECT",12,120,null,1,null,{"$f":"34*C7","v":408},null,null,null,null,null,"CHECKED BY:  TJO"]
[null,"TOTAL",null,{"$f":"SUM(D7:D7)","v":120},null,1,null,{"$f":"SUM(H7)","v":408},null,null,null,null,null,"UPDATED BY: GRB 10/26/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"UPDATED BY: JAG 12/4/2018"]
[null,"PROJECT ID: 6210-00-73"]
[null,null,null,643.09,null,"643.0310.S",null,643.1]
[null,null,"DURATION","TRAFFIC CONTROL SIGNS",null,"TEMPORARY PORTABLE RUMBLE STRIPS (project) 01. 6210-00-73",null,"TRAFFIC CONTROL SIGNS FIXED MESSAGE"]
[null,"LOCATION","DAYS","DAY",null,"LS",null,"SF"]
[null,"PROJECT",30,{"$f":"18*C14","v":540},null,1,null,64]
[null,"TOTAL",null,{"$f":"D14","v":540},null,1,null,{"$f":"SUM(H14)","v":64}]

{"sheet":"SIGNING","index":10,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,6],[1,1,1,6],[9,3,9,4],[9,5,9,6],[9,7,9,8],[6,5,6,6],[7,5,7,6],[8,5,8,6],[17,1,17,8],[4,7,4,8],[4,5,4,6],[4,3,4,4],[3,7,3,8],[3,5,3,6],[3,3,3,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[10,3,10,4],[10,5,10,6],[10,7,10,8],[5,3,5,4],[5,5,5,6],[5,7,5,8]]}
[]
[null,"SIGNS"]
[null,"PROJECT ID: 6210-01-60"]
[null,null,null,638.21019999999999,null,638.4]
[null,null,null,"MOVING SIGNS TYPE II",null,"MOVING SMALL SIGN SUPPORTS"]
[null,"STATION","SIDE","EACH",null,"EACH",null,null,null,null,null,null,null,"CALC'D BY: JG"]
[null,9419,"LT",2,null,1]
[null,9525,"RT",2,null,1]
[null,27924,"LT",1,null,1]
[null,27926,"RT",1,null,1]
[null,"TOTAL",null,{"$f":"SUM(D7:E10)","v":6},null,{"$f":"SUM(F7:G10)","v":4}]

{"sheet":"MARKINGS","index":11,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,10,3,11],[29,10,29,11],[1,0,1,11],[2,0,2,11],[4,5,4,8],[6,5,7,5],[5,6,7,6],[5,7,7,7],[5,8,7,8],[4,9,7,9],[4,10,6,11]]}
[]
["PAVEMENT MARKING ITEMS"]
["PROJECT ID: 6210-00-73"]
[null,null,null,null,null,646.10199999999998,646.10400000000004,646.452,646.30399999999997,648.01,649.01049999999998]
[null,null,null,null,null,"MARKING LINE",null,null,null,"LOCATING NO-PASSING ZONES","TEMPORARY MARKING LINE      PAINT 4-INCH "]
[null,null,null,null,null,null,"GROOVED WET REF EPOXY 4-INCH WHITE","SAME DAY EPOXY 4-INCH YELLOW","GROOVED WET REF EPOXY 8-INCH WHITE"]
[null,null,null,null,null,"EPOXY 4-INCH YELLOW"]
[null,null,null,null,null,null,null,null,null,null,"YELLOW","WHITE"]
["ROADWAY","STATION","TO","STATION","DESCRIPTION","LF","LF","LF","LF","MI","LF","LF"]
["STH 49",5535.25,null,10250,"SKIPS",{"$f":"N10+1","v":1179.6875},"-",{"$f":"N10+1","v":1179.6875},"-","-","-","-",null,1178.6875]
["STH 49",10400,null,10750,"-",{"$f":"N11","v":"-"},"-",{"$f":"N11","v":"-"},300,"-","-","-",null,"-"]
["STH 49",10800,null,10950,"-","-","-","-","-","-","-","-",null,"-"]
["STH 49",10250,null,11750,"NB SKIPS/SB SOLID",1875,"-",1875,"-","-","-","-",null,1875]
["STH 49",11750,null,12876,"SKIPS",281.5,"-",281.5,"-","-","-","-",null,281.5]
["STH 49",12876,null,13850,"SB SKIPS/NB SOLID",1217.5,"-",1217.5,"-","-","-","-",null,1217.5]
["STH 49",13850,null,14100,"SOLID",500,"-",500,"-","-","-","-",null,500]
["STH 49",14100,null,15160,"NB SKIPS/SB SOLID",1325,"-",1325,"-","-","-","-",null,1325]
["STH 49",15160,null,16663,"SKIPS",375.75,"-",375.75,"-","-","-","-",null,375.75]
["STH 49",16663,null,17675,"SB SKIPS/NB SOLID",1265,"-",1265,"-","-","-","-",null,1265]
["STH 49",17675,null,17879,"SOLID",408,"-",408,"-","-","-","-",null,408]
["STH 49",17879,null,18923,"NB SKIPS/SB SOLID",1305,"-",1305,"-","-","-","-",null,1305]
["STH 49",18923,null,24680,"SKIPS",1439.25,"-",1439.25,"-","-","-","-",null,1439.25]
["STH 49",24680,null,25720,"SB SKIPS/NB SOLID",1300,"-",1300,"-","-","-","-",null,1300]
["STH 49",25720,null,26093,"SKIPS",93.25,"-",93.25,"-","-","-","-",null,93.25]
["STH 49",26093,null,27250,"NB SKIPS/SB SOLID",1446.25,"-",1446.25,"-","-","-","-",null,1446.25]
["STH 49",27250,null,28500,"SKIPS",312.5,"-",312.5,"-","-","-","-",null,312.5]
["STH 49",28500,null,28919.73,"SB SKIPS/NB SOLID",524.66249999999945,"-",524.66249999999945,"-","-","-","-",null,524.66249999999945]
["STH 49",5535,null,28920,"-","-",46800,"-","-",4.43,{"$f":"G28","v":46800},46800]
["TOTAL",null,null,null,null,{"$f":"CEILING(SUM(F10:F27),50)","v":14850},{"$f":"CEILING(SUM(G10:G28),100)","v":46800},{"$f":"CEILING(SUM(H10:H27),50)","v":14850},300,4.4288787878787872,46800,46800]
[null,null,null,null,null,null,null,null,null,null,93600]
[]
[]
[]
[]
[null,"CALC'D BY: JG"]
[null,"CHECKED BY:  TJO"]
[null,"UPDATED BY: GRB 10/26/2018"]
[null,"UPDATED BY: JAG 1/16/2019"]

{"sheet":"SAWCUTS","index":12,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[20,11,20,14],[4,4,7,4],[1,1,1,4],[2,1,2,4]]}
[]
[null,"SAWING ASPHALT"]
[null,"PROJECT ID: 6210-01-60"]
[null,null,null,null,690.01499999999999]
[null,null,null,null,"SAWING ASPHALT"]
[]
[]
[null,null,null,null,null,null,null,null,null,"CALC'D BY: JG"]
[null,"ROADWAY","STATION",null,"LF",null,null,null,null,"CHECKED BY:  TJO"]
[null,"STH 49",9359,null,30,null,null,null,null,"UPDATED BY: GRB 10/26/2018"]
[null,"STH 49","94+59",null,30,null,null,null,null,"UPDATED BY: JAG 1/16/2019"]
[null,"STH 49",27781,null,30]
[null,"STH 49",27940,null,30]
[null,"TOTAL",null,null,{"$f":"SUM(E10:E13)","v":120}]