{"text_format":"1","workbook":"xlsx","n_sheets":71,"sheets":["Project Data ","Lookup Data","0_0_Grading Qu","0_1_Topsoil Qu","Rdwy. Quantity Block 1","Rdwy. Quantity Block 2","Rdwy. Quantity Block 3","Rdwy. Quantity Block 4","Rdwy. Quantity Block 5","Rdwy. Quantity Block 6","Footnotes","11_0_Footnotes","11_1_Footnotes ","Box Bridge Quantities Block","Utilities","Add Sheets","Storm Drainage Pipe Totals","3_0_Side Drain","3_1_Side Drain","3_2_Side Drain","3_3_Side Drain","2_0_Cross Drai","2_1_Cross Drai","2_2_Cross Drai","2_3_Cross Drai","2_4_Cross-Medi","2_5_Cross-Medi","2_6_Longitudin","2_7_Median Dra","1_0_Box Culver","1_1_Bridge Dra","1_2_CB & Manho","1_3_CB Drop In","1_4_Catch Basi","1_5_Catch Basi","1_6_Catch Basi","1_7_Catch Basi","1_8_Manhole To","1_9_Manholes","1_10_Removal Bu","1_11_Removal St","1_12_Roadway Ap","1_13_Spring Dra","0_2_Project Co","9_0_Bridge Dec","9_1_Guardrail ","9_2_Storm Drai","9_3_Traffic Co","9_4_Utility Ad","8_0_Curb Ramps","8_1_OutFalls","8_2_ROW Marker","8_3_Slope Reha","8_4_Trees","7_0_Rip Rap Ba","7_1_Rip Rap Di","7_2_Sediment D","7_3_Sediment D","7_4_Special Di","7_5_Erosion Co","6_0_Pavement L","6_1_Pavement S","6_2_Traffic Co","6_3_Traffic Co","5_0_Concrete B","5_1_Guardrail ","4_0_Storm Drai","4_1_Storm Drai","4_2_Storm Drai","4_3_Storm Drai","12_0_Blank Work"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":12,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Project Data ","index":0,"n_rows":41,"n_cols":160,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"Project No. 1 Data","Project No. 2 Data","Project No. 3 Data","Project No. 4 Data","Project No. 5 Data"]
["State Construction Project Num."]
["Federal Project Number"]
["Non-Participating",false,false,false,false,false]
["Project Description"]
["PIN"]
["Letting Date"]
[]
["Project Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Safety                             "]
["Units","English 2000","English 2000","English 2000","English 2000","English 2000"]
[]
["County",null,"","",""]
["Route"]
["Road Name"]
[]
[]
["Project Length"]
["Beginning Station"]
["Ending Station"]
["Beginning Log Mile"]
["Ending Log Mile "]
["North Coordinate "]
["East Coordinate"]
["Longitude"]
["Latitude"]
[]
["Roadway Designer"]
["Roadway CE Manager 2"]
["Date Turned In"]
[]
["Bridge Required"]
["Retaining Wall Required?"]
["Signals Required?"]
["Is Chapter 86?"]
["Bridge Designer"]
["Bridge CE Manager "]
[]
["Submitting Division"]
["Estimate Type"]
["Quantities Calculation Date"]
["Quantities Updated Date"]

{"sheet":"Lookup Data","index":1,"n_rows":98,"n_cols":8,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
[]
["Estimate Type - row 35","Project Type - row 9","Bridge Required - row 31","Units - row 10","County - row 12",null,"Region"]
[null,null,"Yes","English 2000",null,null,null,{"$f":"VLOOKUP(#REF!,E4:G98,3,FALSE)","v":{"$error":"#REF!"}}]
["Preliminary Estimate","New Construction            ","No","Metric 2001","Anderson",1,"R1"]
["ROW Estimate","Major Widening                     ",null,null,"Bedford",2,"R3"]
["Construction Field Review","Minor Widening",null,null,"Benton",3,"R4"]
["Construction Estimate","Resurfacing                        ",null,null,"Bledsoe",4,"R2"]
[null,"New Bridge                         ",null,null,"Blount",5,"R1"]
[null,"Bridge Replacement                 ",null,null,"Bradley",6,"R2"]
[null,"Major Bridge Rehabilitation        ",null,null,"Campbell",7,"R1"]
[null,"Minor Bridge Rehabilitation        ",null,null,"Cannon",8,"R2"]
[null,"Safety                             ",null,null,"Carroll",9,"R4"]
[null,"Traffic Operation & Control System ",null,null,"Carter",10,"R1"]
[null,"Environmental & Enhancements",null,null,"Cheatham",11,"R3"]
[null,"Reconstruction-Add Full Lane       ",null,null,"Chester",12,"R4"]
[null,"Reconstruction-No Lane Added       ",null,null,"Claiborne",13,"R1"]
[null,"Maintenance                        ",null,null,"Clay",14,"R2"]
[null,"Project Not Classified             ",null,null,"Cocke",15,"R1"]
[null,null,null,null,"Coffee",16,"R2"]
[null,null,null,null,"Crockett",17,"R4"]
["Submitting Division - Row 38",null,null,null,"Cumberland",18,"R2"]
[null,null,null,null,"Davidson",19,"R3"]
["Roadway",null,null,null,"Decatur",20,"R4"]
["TrafficOpsITS",null,null,null,"DeKalb",21,"R2"]
["TrafficOps",null,null,null,"Dickson",22,"R3"]
["Structures",null,null,null,"Dyer",23,"R4"]
[null,null,null,null,"Fayette",24,"R4"]
[null,null,null,null,"Fentress",25,"R2"]
[null,null,null,null,"Franklin",26,"R2"]
[null,null,null,null,"Gibson",27,"R4"]
[null,null,null,null,"Giles",28,"R3"]
[null,null,null,null,"Grainger",29,"R1"]
[null,null,null,null,"Greene",30,"R1"]
[null,null,null,null,"Grundy",31,"R2"]
[null,null,null,null,"Hamblen",32,"R1"]
[null,null,null,null,"Hamilton",33,"R2"]
[null,null,null,null,"Hancock",34,"R1"]
[null,null,null,null,"Hardeman",35,"R4"]
[null,null,null,null,"Hardin",36,"R4"]
[null,null,null,null,"Hawkins",37,"R1"]
[null,null,null,null,"Haywood",38,"R4"]
[null,null,null,null,"Henderson",39,"R4"]
[null,null,null,null,"Henry",40,"R4"]
[null,null,null,null,"Hickman",41,"R3"]
[null,null,null,null,"Houston",42,"R3"]
[null,null,null,null,"Humphreys",43,"R3"]
[null,null,null,null,"Jackson",44,"R2"]
[null,null,null,null,"Jefferson",45,"R1"]
[null,null,null,null,"Johnson",46,"R1"]
[null,null,null,null,"Knox",47,"R1"]
[null,null,null,null,"Lake",48,"R4"]
[null,null,null,null,"Lauderdale",49,"R4"]
[null,null,null,null,"Lawrence",50,"R3"]
[null,null,null,null,"Lewis",51,"R3"]
[null,null,null,null,"Lincoln",52,"R3"]
[null,null,null,null,"Loudon",53,"R1"]
[null,null,null,null,"McMinn",54,"R2"]
[null,null,null,null,"McNairy",55,"R4"]
[null,null,null,null,"Macon",56,"R3"]
[null,null,null,null,"Madison",57,"R4"]
[null,null,null,null,"Marion",58,"R2"]
[null,null,null,null,"Marshall",59,"R3"]
[null,null,null,null,"Maury",60,"R3"]
[null,null,null,null,"Meigs",61,"R2"]
[null,null,null,null,"Monroe",62,"R1"]
[null,null,null,null,"Montgomery",63,"R3"]
[null,null,null,null,"Moore",64,"R3"]
[null,null,null,null,"Morgan",65,"R1"]
[null,null,null,null,"Obion",66,"R4"]
[null,null,null,null,"Overton",67,"R2"]
[null,null,null,null,"Perry",68,"R3"]
[null,null,null,null,"Pickett",69,"R2"]
[null,null,null,null,"Polk",70,"R2"]
[null,null,null,null,"Putnam",71,"R2"]
[null,null,null,null,"Rhea",72,"R2"]
[null,null,null,null,"Roane",73,"R1"]
[null,null,null,null,"Robertson",74,"R3"]
[null,null,null,null,"Rutherford",75,"R3"]
[null,null,null,null,"Scott",76,"R1"]
[null,null,null,null,"Sequatchie",77,"R2"]
[null,null,null,null,"Sevier",78,"R1"]
[null,null,null,null,"Shelby",79,"R4"]
[null,null,null,null,"Smith",80,"R3"]
[null,null,null,null,"Stewart",81,"R3"]
[null,null,null,null,"Sullivan",82,"R1"]
[null,null,null,null,"Sumner",83,"R3"]
[null,null,null,null,"Tipton",84,"R4"]
[null,null,null,null,"Trousdale",85,"R3"]
[null,null,null,null,"Unicoi",86,"R1"]
[null,null,null,null,"Union",87,"R1"]
[null,null,null,null,"Van Buren",88,"R2"]
[null,null,null,null,"Warren",89,"R2"]
[null,null,null,null,"Washington",90,"R1"]
[null,null,null,null,"Wayne",91,"R3"]
[null,null,null,null,"Weakley",92,"R4"]
[null,null,null,null,"White",93,"R2"]
[null,null,null,null,"Williamson",94,"R3"]
[null,null,null,null,"Wilson",95,"R3"]

{"sheet":"0_0_Grading Qu","index":2,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":true,"merged":[[12,1,12,7],[12,8,12,9],[12,11,12,12],[13,1,13,2],[13,3,13,7],[13,8,13,9],[13,11,13,12],[9,1,9,4],[10,1,10,4],[10,6,11,7],[10,8,10,9],[10,11,10,12],[11,1,11,4],[8,1,8,4],[8,8,8,9],[8,11,8,12],[0,0,0,14],[1,1,1,13],[2,1,3,4],[2,5,2,6],[2,8,2,13],[4,1,4,4],[5,1,5,4],[5,8,6,9],[5,11,6,12],[6,1,6,4],[7,1,7,4]]}
[]
[null,"ESTIMATED GRADING QUANTITIES"]
[null,"DESCRIPTION",null,null,null,"UNADJUSTED VOLUMES (CY)",null,"ADJUSTED VOLUMES (CY)","BALANCE SUMMARY"]
[null,null,null,null,null,"EXC.","EMB.","EXC.","SHRINK = ",null,"%","SWELL =",null,"%"]
[null,"MAINLINE",null,null,null,null,null,{"$f":"IF(F5>0,ROUNDUP(F5*(1- $J$4%),0),\"\")","v":""}]
[null,"SIDE ROADS",null,null,null,null,null,"",{"$f":"IF(E16>H16,\"EMB.\",\"EXC.\")","v":"EXC."},null,null,{"$f":"IF(H16>=E16,\"EMB.\",\"EXC.\")","v":"EMB."}]
[null,"PVT. DRIVES, BUSINESS AND FIELD ENTRANCES",null,null,null,null,null,""]
[null,"INDEPENDENT DITCHES",null,null,null,null,null,""]
[null,"TEMPORARY CONSTRUCTION EXITS",null,null,null,null,null,"",{"$f":"MAX(E16,H16)","v":0},null,"VS.",{"$f":"(-1)*MIN(E16,H16)","v":0}]
[null,"OTHER (BRIDGE EXCAVATION, PAVEMENT, ETC...)",null,null,null,null,null,""]
[null,"TOPSOIL (EMB.)",null,null,null,null,null,null,"AVAILABLE",null,"=",{"$f":"IF(I9+L9=0, \"0\",I9+L9)","v":"0"}]
[null,"TOPSOIL (EXC.)"]
[null,"TOPSOIL TOTALS (SEE TOPSOIL TABLE)",null,null,null,null,null,null,{"$f":"IF(E16>H16,\"BORROW MATERIAL\", \"WASTE MATERIAL\")","v":"WASTE MATERIAL"},null,"=",{"$f":"IF(L11=\"0\", \"0\", ROUNDUP(L11*(1+J4/100),0))","v":"0"}]
[null,"ROCK (C.Y.)",null,"TOTALS (C.Y.)",null,null,null,null,{"$f":"IF(OR(C16=\"UNKNOWN\", C16=0),\" \",\"BORROW ROCK\")","v":" "},null,{"$f":"IF(I14=\" \", \" \",\"=\")","v":" "},{"$f":"IF(I14=\" \",\" \",ROUNDUP(C16*(1+J4/100), 0))","v":" "}]
[null,"EXC.","EMB.","EXC. (UNCL.)","EMB. (UNCL.)","EXC (COMMON)","EXC. (AVAIL.)","EXC. (ADJ.)"]
[null,0,0,{"$f":"ROUNDUP(SUM(F5:F12)+B16,0)","v":0},{"$f":"IF(C16=\"UNKNOWN\", ROUNDUP(SUM(G5:G10),0), ROUNDUP(SUM(G5:G10)-C16,0))","v":0},{"$f":"ROUNDUP((D16-B16),0)","v":0},{"$f":"ROUNDUP(F16-SUM(F11:F12),0)","v":0},{"$f":"IF(B16=\"UNKNOWN\", G16*(1-J4/100), ROUNDUP(G16*(1-J4/100)+(B16*(1+M4/100)),0))","v":0}]

{"sheet":"0_1_Topsoil Qu","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":true,"merged":[[9,1,9,8],[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4],[10,5,12,5],[10,6,12,6],[10,7,12,7],[10,8,12,8],[3,1,3,8],[4,1,4,8],[5,1,7,1],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[5,6,7,6],[5,7,7,7],[5,8,7,8]]}
[]
[]
[]
[null,"TOPSOIL"]
[null,"IF EXISTING TOPSOIL IS SUITABLE FOR REUSE"]
[null,"PROPOSED\nSLOPE\nAREA\nS.F.","EXISTING\nTOPSOIL\n(EXC.)","EXISTING\nTOPSOIL\n(EMB.)","EXISTING\nTOPSOIL\n(TOTAL)\nC.Y.","REQUIRED\nTOPSOIL\nC.Y.","PLACING\nTOPSOIL\n203-04\nC.Y.","FURNISHED\nTOPSOIL\n203-07\nC.Y.","EXCESS\nTOPSOIL\nC.Y.\n"]
[]
[]
[null,0,0,0,{"$f":"C9+D9","v":0},{"$f":"$B$9*0.5/27","v":0},{"$f":"IF(F9>E9,E9,F9)","v":0},{"$f":"IF(E9<F9,F9-G9,0)","v":0},{"$f":"IF(E9>G9,E9-G9,0)","v":0}]
[null,"IF EXISTING TOPSOIL IS NOT SUITABLE FOR REUSE"]
[null,"PROPOSED\nSLOPE\nAREA\nS.F.","EXISTING\nTOPSOIL\n(EXC.)","EXISTING\nTOPSOIL\n(EMB.)","EXISTING\nTOPSOIL\n(TOTAL)\nC.Y.","REQUIRED\nTOPSOIL\nC.Y.","PLACING\nTOPSOIL\n203-04\nC.Y.","FURNISHED\nTOPSOIL\n203-07\nC.Y.","EXCESS\nTOPSOIL\nC.Y.\n"]
[]
[]
[null,0,"N/A","N/A","N/A",{"$f":"$B$14*0.5/27","v":0},"N/A",{"$f":"F14","v":0},"N/A"]

{"sheet":"Rdwy. Quantity Block 1","index":4,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10]]}
[]
[null,"ESTIMATED ROADWAY QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Rdwy. Quantity Block 2","index":5,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10]]}
[]
[null,"ESTIMATED ROADWAY QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:I32)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:I33)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:I34)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E35:I35)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Rdwy. Quantity Block 3","index":6,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10]]}
[]
[null,"ESTIMATED ROADWAY QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Rdwy. Quantity Block 4","index":7,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10]]}
[]
[null,"ESTIMATED ROADWAY QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Rdwy. Quantity Block 5","index":8,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10]]}
[]
[null,"ESTIMATED ROADWAY QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Rdwy. Quantity Block 6","index":9,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10]]}
[]
[null,"ESTIMATED ROADWAY QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Footnotes","index":10,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":true,"merged":[[1,5,1,7],[101,0,101,3],[0,0,0,3],[2,1,2,2],[17,4,19,4],[1,4,2,4],[1,1,1,2],[21,4,29,4],[33,4,43,4]]}
[]
[null,"FOOTNOTES",null,null,"NOTES To Designer             Do Not Adjust Text Size!","Specific Notes & Footnotes Related to Special Items in the Roadway Design Guidelines"]
[]
[null,"(1)","Text",null,"Do Not Adjust Row Height!                               ","Item Related to Note","Note (Click on row to expand note) (if the project has this item number, add this footnote or as describe)","RDG Chapter #"]
[null,null,"Text",null,"Row 1 = height of 10, ","Project Length","For all plan phases, the R.O.W. Length, Roadway Length, Bridge Length, Box Bridge Length, and Project Length shall be shown below the map and shall be noted to the 1000th of a mile and shown as X.XXX. ","1-203.06"]
[null,null,"Text",null,"Row 2 = height of 24,","Road Closed during"]
[null,null,null,null,"Row 3 = height of  8,","Construction","If the road is going to be closed during construction, this should be noted on the Line and Grade, Functional Design, Plan-in-Hand, and PS&E title sheet ","1-203.12"]
[null,"(2)","Text",null,"Row 4 thru 66 = height of 14 and"]
[null,null,null,null,"Row 67 height of 12.","PS&E Index ","The Index of Sheets for PS&E plans is not shown on the title sheet as it is in the Line and Grade and Functional Design plans. Designers shall place a note in the upper left corner of the title sheet which says, “See Sht. 1A for Index”","1-206.01"]
[null,"(3)","Text",null,"The maximum number of Rows to be placed in a DGN file is 67.","Item in question added "]
[null,null,null,null,"to be placed in a DGN file is 67.","to the estimate, but may"]
[null,null,null,null,"Do Not Adjust Column Width!","not be used by the "]
[null,null,null,null,"Column A is 2 wide,","contractor shall be"]
[null,null,null,null,"Column B is 8 wide,","discussed at PIH Field"]
[null,null,null,null,"Column C is 92 wide and","Review","footnoted \"Requested by _______Division\"","1-401.00"]
[null,null,null,null,"Column D is 2 wide.","Item used in multiple"]
[null,null,null,null,"Placing Foot Notes.","locations","When an item is used in multiple locations for various reasons, footnotes shall be used to define what the use and quantity is for each item within the total.","1-403.00"]
[null,null,null,null,"Foot Note Numbers go in column B and the Notes go in column C as shown.","Lump Sum (LS)"]
[null,null,null,null,null,"quantities","The description shall be filled in and a breakdown of the items included in the lump sum shall be footnoted","1-403.00"]
[null,null,null,null,null,"Erosion Control that"]
[null,null,null,null,"Ending the Foot Notes Block.","might have to be "]
[null,null,null,null,"You need to place a solid black line at the bottom of the Foot Notes Block if you are not using all 66 lines. After filling in all Footnotes go to the Row below the last Foot Note and edit cells for column B and C. To Edit the Cells you need to highlight cells with your mouse. Then right click with your mouse and click on Format Cells. Click on the Border Tab and then choose the line style to be placed by clicking on it. Use the line style in the second column, third from the bottom. Then in the white area that has the word TEXT click where you want the line to be placed. Then click OK.","replaced during the "]
[null,null,null,null,null,"life cycle of the project","SEE SUBSECTION 209.07 OF THE STANDARD SPECIFICATIONS FOR MAINTENANCE REPLACEMENT","1-403.00"]
[null,null,null,null,null,"Approved Design",null,"1-203.13 "]
[null,null,null,null,null,"Exception","Approved design exceptions shall be noted, with approval date, in the lower right corner of the title sheet as well as on the cover sheet for the Functional Design.","2-105.00"]
[null,null,null,null,null,"Approved Design"]
[null,null,null,null,null,"Waivers","Approved design waivers shall be noted, with approval date, in the lower right corner of the title sheet as well as on the cover sheet for the Functional Design and Plan-in-Hand checklist.","2-201.00"]
[null,null,null,null,null,"716-12.02","Contractor shall use the extruded or ribbon method for application","2-502.00"]
[null,null,null,null,null,"716-02.08 or 716-02.09","Contractor may elect to substitute Preformed Plastic for Thermoplastic.  Preformed Plastic shall be paid for at the same unit price as bid for Thermoplastic","2-508.00"]
[null,null,null,null,null,"For ALL project with"]
[null,null,null,null,null,"retaining walls","ALL COST OF BUILDING AND INSTALLING THE RETAINING WALL, INCLUDING FOUDATION PREPARATION, BACKFILLING, AND EXCAVATION, SHALL BE INCLUDED IN THE SQUARE FOOTAGE COST OF THE RETAINING WALL. QUANTITIES FOR FOUNDATION PREPARATION, BACKFILL, AND EXCAVATION ARE REFLECTED IN THE END AREA CALCULATIONS ON CROSS SECTIONS AND IN GRADING QUANTITY ROADWAY ITEM 203-01, ROAD AND DRAINAGE EXCAVATION (C.Y.). THE DESIGNER HAS NOTED THE PORTION OF THIS QUANTITY FOR THESE ITEMS ON THE PROFILE SHEET XX AND ON THE GRADING QUANITITY TABULATION SHEET. THE PORTION OF THIS QUANTITY HAS BEEN REMOVED FROM ROADWAY ITEM 203-01, ROAD AND DRAINAGE EXCAVATION (C.Y.). FOR FURTHER INFORMATION ON RETAINING WALLS AND QUANTITIES, SEE SHEET(S) (R, R1, R1A, R1B, R2, R2A, R2B, etc.).","2-900.10"]
[null,null,null,null,"TO PLACE THE FOOT NOTES","If a Concrete Parapet is"]
[null,null,null,null,"IN A DGN FILE.","on one retaining wall","CONCRETE PARAPET IS LOCATED ON RETAINING WALL R# AND IS NOT INCLUDED IN THE COST OF THE RETAINING WALL","2-900.10"]
[null,null,null,null,"You need a DGN 2nd sheet Seed File with the snaps at the top of the sheet to place the Foot Notes in. Highlight the block to be placed by Click with your mouse in Row 1, anywhere and hold down the button then pull down to the last Row of your Foot Notes Block, where you just placed the solid line to end the block then release the button. This will highlight area to be placed in the DGN. Right click with your mouse and select COPY. Now in your DGN file click on Edit at the top and pull down to paste special. When the window opens chose Linked Microsoft Excel worksheet. This opens a placement menu, chose Paste as Link and By Corners. To place use the snaps tabs at the top of the DGN sheet for the left side of the Foot Notes and right side for the Foot Notes Block.","if Concrete Parapet is "]
[null,null,null,null,null,"on multiple retaining"]
[null,null,null,null,null,"walls","CONCRETE PARAPET IS NOT INCLUDED IN THE COST OF THE RETAINING WALL. BREAKDOWN OF CONCRETE PARAPET FOR EACH WALL IS XX L.F. FOR R#, XX L.F. FOR R#, XX L.F. FOR R#, (ETC.)","2-900.10"]
[null,null,null,null,null,"If Concrete Barrier is"]
[null,null,null,null,null,"on one retaining wall","CONCRETE BARRIER IS LOCATED ON RETAINING WALL R# AND IS NOT INCLUDED IN THE COST OF THE RETAINING WALL.","2-900.10"]
[null,null,null,null,null,"If Concrete Barrier is "]
[null,null,null,null,null,"on multiple retaining "]
[null,null,null,null,null,"walls","CONCRETE BARRIER IS NOT INCLUDED IN THE COST OF THE RETAINING WALL. BREAKDOWN OF CONCRETE BARRIER FOR EACH WALL IS XX L.F. FOR R#, XX L.F. FOR R#, XX L.F. FOR R#, (etc.)","2-900.10"]
[null,null,null,null,null,"Earthwork Calculations","A note shall be added to the plans below the earthwork tabulation block detailing any special areas where topsoil will not be required (such as rock fills not to be seeded). Include topsoil and seeding quantities for sodded or paved ditch areas on projects requiring topsoil and seeded slopes.","2-1007.00"]
[null,null,null,null,null,"Box Culvert  and Slab",null,"2-1200.02"]
[null,null,null,null,null,"Bridge Outlets ","Footnote these quantities to show the amount of concrete and steel bar reinforcement included for the paved aprons, when applicable.","8-604..02"]
[null,null,null,null,"PLACED BY SCALE: 18.00","If curve inlets and/or"]
[null,null,null,null,null,"outlet are required","The inlet and outlet ends of the box culvert at Sta.    shall be curved parallel to the centerline of the roadway.","2-1200.03"]
[null,null,null,null,null,"If the top slab is to be "]
[null,null,null,null,null,"used as the riding "]
[null,null,null,null,null,"surface and the design"]
[null,null,null,null,null,"speed is less then"]
[null,null,null,null,null,"40 mph, the following"]
[null,null,null,null,null,"not shalled be added"]
[null,null,null,null,null,"to the plans","Bridge deck finish to be burlap drag in accordance with method “A” as specified in Subsection 604.23 of the Tennessee Department of Transportation Standard Specifications.","2-1200.03"]
[null,null,null,null,null,"203-50","ITEM NUMBER 203-50 SHALL INCLUDE GEOTEXTILE (TYPE IV), BORROW EXCAVATION (GRADED SOLID ROCK) OR MACHINED RIP-RAP (CLASS A-1, CLASS B, OR CLASS C), MINERAL AGGREGATE (SIZE 57), AND TEMPORARY DRAINAGE PIPE (IF APPLICABLE). THE MINERAL AGGREGRATE INCLUDES AN ADDITIONAL TEN (10) PERCENT FOR MAINTENANCE.","2-1201.02"]
[null,null,null,null,null,"Haul Road","If the haul road is constructed in a dry or unsaturated area, Borrow Excavation (graded solid rock) shall be used. If the haul road is constructed in water or in an area within the flood plain, Machined Rip-Rap (Class A-1, Class B, or, Class C) shall be used in place of Borrow Excavation.             An additional ten (10) percent for Mineral Aggregate is included in Item 203-50. The additional ten (10) percent is for the maintenance of the haul road due to inclement weather events outside the contractor’s control.","2-1201.02"]
[null,null,null,null,null,"303-01","Footnote the quantity used for driveway.","2-1501.00"]
[null,null,null,null,null,"712-02.60","This item shall be a portable energy absorbing terminal meeting the requirements of AASHTO MASH for Test Level 3. The pay item will include furnishing and installing all components as shown on the manufacturer’s drawing.","5-205.00"]
[null,null,null,null,null,"712-06.16","Item to be used only when a reduced speed limit is established within the project construction work zone limits. Item includes sign face, supports, and two type “B” flashers per the standard specifications. The contractor shall be responsible for turning on the type “B” flashers when workers are in the construction work zone and turning them off when workers are no longer in the construction work zone.","5-208.00"]
[null,null,null,null,null,"202-01 or 202-01.50","add a footnote to the estimated quantities block detailing exactly what major items are included in the item (this includes, but is not limited to catch basins, manholes, junction boxes, etc.).","8-202.00"]
[null,null,null,null,null,"202-04.50 to 202-04.65","shall be footnoted under the appropriate estimated quantities block as to whether the salvage shall become the property of the contractor, city, county or state.  ","8-202.01"]
[null,null,null,null,null,"202-06.01 to 202-06.41","Bid price includes all salvage value of material. See tabulated quantities sheet No. 2___ for removal of buildings and obstructions description block.","8-202.02"]
[null,null,null,null,null,"All grading quantities ","See Grading Special Notes on sheet 2_.","8-203.01"]
[null,null,null,null,null,"Pipe Culvert and"]
[null,null,null,null,null,"Bedding Material","Designers should include a footnote under the estimated roadway quantities block that the bedding material shall be included in the cost of the proposed pipe culvert.\n\t“See Standard Drawing No. D-PB-1 and D-PB-2 for additional details.”","8-204.01"]
[null,null,null,null,null,"Excavation for Concrete"]
[null,null,null,null,null,"Box and Slab Type "]
[null,null,null,null,null,"Culverts and Bridges","Culvert excavation for concrete box or slab type culverts or bridges will not be measured and paid for directly, but the cost will be included in the cost of other items.","8-204.02"]
[null,null,null,null,null,"Brooming and Degrassing","The Designer shall footnote all applicable brooming and degrassing pay items with the following notes:\n“Includes the cost of removing debris and sweeping shoulders prior to work. See sheet \nno. ____, ___________ note (____) for more information.”","8-208.00"]
[null,null,null,null,null,"All Applicalble EPSC   "]
[null,null,null,null,null,"pay items","See Subsection 209.07 of the Standard Specifications for Maintenance Replacement.  All quantities are to be used as directed by the Engineer.","8-209.00"]
[null,null,null,null,null,"302-02","NOTE: To be used only when specifically recommended                                                                                                           Subsection 302.08 of the Standard Specifications requires slurry application unless otherwise shown on plans. If dry application is specified by the Pavement Design Section, it shall be necessary to footnote pay items.","8-302.00"]
[null,null,null,null,null,"402-01, 402-02, ",null,"8-402.01"]
[null,null,null,null,null,"403-05.01, 405-01.01,",null,"8-403.02"]
[null,null,null,null,null,"405-01.02, ","Designers shall assume the mid-point of the rate ranges when calculating quantities.  If a different value is used, footnote this item on the estimated roadway quantities sheet in the plans to indicate the rate used.  Designers shall show the rate range on the proposed pavement schedule in the plans.","8-405.00"]
[null,null,null,null,null,"402-02","Item to be used as directed by the engineer.","8-402.01"]
[null,null,null,null,null,"403-01","If a specific aggregate size is intended to be used, use the coordinating midpoint of the ranges identified in Table 405.06-1 of Standard and Supplemental Specifications 405.06 and footnote this item on the estimated roadway quantities sheet in the plans to indicate which rate and aggregate size should be used.","8-405.01"]
[null,null,null,null,null,"403-01.01","No payment will be made directly for the water required to dilute the tack coat.                                                                       ","8-414.01"]
[null,null,null,null,null,"414-03.01","Application rate based on 12 percent of the dry weight of the aggregate.","8-414.01"]
[null,null,null,null,null,"414-03.02","Application rate:  1 pass = 22 pounds (approximate depth 0.275”) per square yard \t\t                                                     2 pass = 32 pounds (approximate depth 0.375”) per  square yard","8-414.01"]
[null,null,null,null,null,"610-07.03, 709-01.01","These pay items in the estimated roadway quantities block shall be footnoted as follows:\n\t“Standard Drawing STD-1-7 (or STD-1-11) is to be used for burial of the outlet pipe and for end treatment details.”","8-611.01"]
[null,null,null,null,null,"621-01.01 to 621-01.10","Quantity is based on minimum calculated length. Actual length required will be determined based on field conditions encountered. The bidder is responsible for verifying estimated lengths prior to submitting their bid. Additional length, if any, required by actual field measurements will be installed at no additional cost. All costs shall be included in the bid price for these items.","8-621.00"]
[null,null,null,null,null,"Rip Rap"]
[null,null,null,null,null,"709-05.05 to 709-05.09","Footnote each structure separately identifying all quantities and the structures with which they are used. ","8-709.01"]
[null,null,null,null,null,"Crown Vetch Mixture"]
[null,null,null,null,null,"(with mulch)","Item No. 801-01.02, Crown Vetch Mixture (with mulch) shall be used on slopes 3H:1V or steeper and other areas, as indicated in the plans, that are inaccessible for mowing. ","8-801.02"]
[null,null,null,null,null,"Seeding (without mulch),"]
[null,null,null,null,null,"Temporary Seeding "]
[null,null,null,null,null,"(with mulch)","The cost of fertilizer and lime used in initial seed bed preparation is to be included in the cost of seeding.  See Section 801 of TDOT Standard Specifications for Road and Bridge Construction.","8-801.03"]
[null,null,null,null,null,"801-03","Includes            thousand gallons for erosion prevention and sediment control.","8-801.04"]
[null,null,null,null,null,"For large projects when"]
[null,null,null,null,null,"item nos. 801-01 &",null,"8-801.05"]
[null,null,null,null,null,"801-01.02","For larger projects with significant amount of disturbed area, include Item No. 801-07 and/or Item No. 801-07.01 when using item no. 801-01 and/or 801-01.02. Or for larger projects with significant amount of disturbed area, include Item No. 801-08 and/or when using Item No. 801-01 and/or 801-01.02.","8-801.06"]
[null,null,null,null,null,"Supplemental fertilizer","The cost of any necessary lime to be used in conjunction with supplemental fertilizer is to be included in the cost of the supplemental fertilizer.  See Section 801 of TDOT Standard Specifications for Road and Bridge Construction.","8-801.06"]
[null,null,null,null,null,"806-02.03","Item includes litter and trash removal.  This work will not be measured and paid for directly but will be included in the cost of Item No. 806-02.03 Project Mowing per Cycle","8-806.00"]
[null,null,null,null,null,"First Property Map or"]
[null,null,null,null,null,"Present Layout Sheet,"]
[null,null,null,null,null,"if applicable","IT IS INTENDED THAT ALL BUILDINGS AND/OR PORTIONS OF BUILDINGS THAT ARE WITHIN THE PROPOSED RIGHT-OF-WAY AND/OR EASEMENT LINES FOR THE PROJECT BE REMOVED THERE FROM IN THE PROCESS OF RIGHT-OF-WAY ACQUISITION.  IF ANY SUCH BUILDINGS OR IMPROVEMENTS ARE NOT REMOVED IN THE COURSE OF RIGHT-OF-WAY ACQUISITION, __(A)__ TO BE NOTIFIED IN SUFFICIENT TIME TO PERMIT HAVING SUCH REMOVALS DESIGNATED AS A PART OF THE CONSTRUCTION CONTRACT.   (A) NOTE: FILL IN THE BLANK WITH APPROPRIATE PERSONNEL TITLE(S).\t “THE PROJECT MANAGER, AND REGIONAL PROJECT DEVELOPMENT OFFICE ARE”.","9-300.00"]
[null,null,null,null,null,"First Property Map or"]
[null,null,null,null,null,"Present Layout Sheet,"]
[null,null,null,null,null,"if applicable","ALL RAMPS MUST CONFORM TO THE DEPARTMENT’S “POLICY ON FINANCING CONSTRUCTION OF PUBLIC ROAD INTERSECTIONS AND DRIVEWAYS ON HIGHWAY RESURFACING, RECONSTRUCTION AND CONSTRUCTION PROJECTS ON NEW LOCATIONS”, THE MANUAL ON RULES AND REGULATIONS FOR CONSTRUCTING DRIVEWAYS ON STATE HIGHWAY RIGHT-OF-WAY, STANDARD DRAWING RP-R-1, AND OTHER ACCEPTED DESIGN AND SAFETY STANDARDS.","9-300.00"]

{"sheet":"11_0_Footnotes","index":11,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":true,"merged":[[1,5,1,7],[34,4,44,4],[101,0,101,3],[0,0,0,3],[1,1,1,2],[1,4,2,4],[2,1,2,2],[17,4,19,4],[21,4,30,4]]}
[]
[null,"FOOTNOTES",null,null,"NOTES To Designer             Do Not Adjust Text Size!","Specific Notes & Footnotes Related to Special Items in the Roadway Design Guidelines"]
[]
[null,"(1)","Text",null,"Do Not Adjust Row Height!                               ","Item Related to Note","Note (Click on row to expand note) (if the project has this item number, add this footnote or as describe)","RDG Chapter #"]
[null,null,"Text",null,"Row 1 = height of 10, ","Project Length","For all plan phases, the R.O.W. Length, Roadway Length, Bridge Length, Box Bridge Length, and Project Length shall be shown below the map and shall be noted to the 1000th of a mile and shown as X.XXX. ","1-203.06"]
[null,null,"Text",null,"Row 2 = height of 24,","Road Closed during"]
[null,null,null,null,"Row 3 = height of  8,","Construction","If the road is going to be closed during construction, this should be noted on the Line and Grade, Functional Design, Plan-in-Hand, and PS&E title sheet ","1-203.12"]
[null,"(2)","Text",null,"Row 4 thru 66 = height of 14 and"]
[null,null,null,null,"Row 67 height of 12.","PS&E Index ","The Index of Sheets for PS&E plans is not shown on the title sheet as it is in the Line and Grade and Functional Design plans. Designers shall place a note in the upper left corner of the title sheet which says, “See Sht. 1A for Index”","1-206.01"]
[null,"(3)","Text",null,"The maximum number of Rows to be placed in a DGN file is 67.","Item in question added "]
[null,null,null,null,"to be placed in a DGN file is 67.","to the estimate, but may"]
[null,null,null,null,"Do Not Adjust Column Width!","not be used by the "]
[null,null,null,null,"Column A is 2 wide,","contractor shall be"]
[null,null,null,null,"Column B is 8 wide,","discussed at PIH Field"]
[null,null,null,null,"Column C is 92 wide and","Review","footnoted \"Requested by _______Division\"","1-401.00"]
[null,null,null,null,"Column D is 2 wide.","Item used in multiple"]
[null,null,null,null,"Placing Foot Notes.","locations","When an item is used in multiple locations for various reasons, footnotes shall be used to define what the use and quantity is for each item within the total.","1-403.00"]
[null,null,null,null,"Foot Note Numbers go in column B and the Notes go in column C as shown.","Lump Sum (LS)"]
[null,null,null,null,null,"quantities","The description shall be filled in and a breakdown of the items included in the lump sum shall be footnoted","1-403.00"]
[null,null,null,null,null,"Erosion Control that"]
[null,null,null,null,"Ending the Foot Notes Block.","might have to be "]
[null,null,null,null,"You need to place a solid black line at the bottom of the Foot Notes Block if you are not using all 66 lines. After filling in all Footnotes go to the Row below the last Foot Note and edit cells for column B and C. To Edit the Cells you need to highlight cells with your mouse. Then right click with your mouse and click on Format Cells. Click on the Border Tab and then choose the line style to be placed by clicking on it. Use the line style in the second column, third from the bottom. Then in the white area that has the word TEXT click where you want the line to be placed. Then click OK.","replaced during the "]
[null,null,null,null,null,"life cycle of the project","SEE SUBSECTION 209.07 OF THE STANDARD SPECIFICATIONS FOR MAINTENANCE REPLACEMENT","1-403.00"]
[null,null,null,null,null,"Approved Design",null,"1-203.13 "]
[null,null,null,null,null,"Exception","Approved design exceptions shall be noted, with approval date, in the lower right corner of the title sheet as well as on the cover sheet for the Functional Design.","2-105.00"]
[null,null,null,null,null,"Approved Design"]
[null,null,null,null,null,"Waivers","Approved design waivers shall be noted, with approval date, in the lower right corner of the title sheet as well as on the cover sheet for the Functional Design and Plan-in-Hand checklist.","2-201.00"]
[null,null,null,null,null,"716-12.02","Contractor shall use the extruded or ribbon method for application","2-502.00"]
[null,null,null,null,null,"716-02.08 or 716-02.09","Contractor may elect to substitute Preformed Plastic for Thermoplastic.  Preformed Plastic shall be paid for at the same unit price as bid for Thermoplastic","2-508.00"]
[null,null,null,null,null,"For ALL project with"]
[null,null,null,null,null,"retaining walls","ALL COST OF BUILDING AND INSTALLING THE RETAINING WALL, INCLUDING FOUDATION PREPARATION, BACKFILLING, AND EXCAVATION, SHALL BE INCLUDED IN THE SQUARE FOOTAGE COST OF THE RETAINING WALL. QUANTITIES FOR FOUNDATION PREPARATION, BACKFILL, AND EXCAVATION ARE REFLECTED IN THE END AREA CALCULATIONS ON CROSS SECTIONS AND IN GRADING QUANTITY ROADWAY ITEM 203-01, ROAD AND DRAINAGE EXCAVATION (C.Y.). THE DESIGNER HAS NOTED THE PORTION OF THIS QUANTITY FOR THESE ITEMS ON THE PROFILE SHEET XX AND ON THE GRADING QUANITITY TABULATION SHEET. THE PORTION OF THIS QUANTITY HAS BEEN REMOVED FROM ROADWAY ITEM 203-01, ROAD AND DRAINAGE EXCAVATION (C.Y.). FOR FURTHER INFORMATION ON RETAINING WALLS AND QUANTITIES, SEE SHEET(S) (R, R1, R1A, R1B, R2, R2A, R2B, etc.).","2-900.10"]
[null,null,null,null,null,"If a Concrete Parapet is"]
[null,null,null,null,"TO PLACE THE FOOT NOTES","on one retaining wall","CONCRETE PARAPET IS LOCATED ON RETAINING WALL R# AND IS NOT INCLUDED IN THE COST OF THE RETAINING WALL","2-900.10"]
[null,null,null,null,"IN A DGN FILE.","if Concrete Parapet is "]
[null,null,null,null,"You need a DGN 2nd sheet Seed File with the snaps at the top of the sheet to place the Foot Notes in. Highlight the block to be placed by Click with your mouse in Row 1, anywhere and hold down the button then pull down to the last Row of your Foot Notes Block, where you just placed the solid line to end the block then release the button. This will highlight area to be placed in the DGN. Right click with your mouse and select COPY. Now in your DGN file click on Edit at the top and pull down to paste special. When the window opens chose Linked Microsoft Excel worksheet. This opens a placement menu, chose Paste as Link and By Corners. To place use the snaps tabs at the top of the DGN sheet for the left side of the Foot Notes and right side for the Foot Notes Block.","on multiple retaining"]
[null,null,null,null,null,"walls","CONCRETE PARAPET IS NOT INCLUDED IN THE COST OF THE RETAINING WALL. BREAKDOWN OF CONCRETE PARAPET FOR EACH WALL IS XX L.F. FOR R#, XX L.F. FOR R#, XX L.F. FOR R#, (ETC.)","2-900.10"]
[null,null,null,null,null,"If Concrete Barrier is"]
[null,null,null,null,null,"on one retaining wall","CONCRETE BARRIER IS LOCATED ON RETAINING WALL R# AND IS NOT INCLUDED IN THE COST OF THE RETAINING WALL.","2-900.10"]
[null,null,null,null,null,"If Concrete Barrier is "]
[null,null,null,null,null,"on multiple retaining "]
[null,null,null,null,null,"walls","CONCRETE BARRIER IS NOT INCLUDED IN THE COST OF THE RETAINING WALL. BREAKDOWN OF CONCRETE BARRIER FOR EACH WALL IS XX L.F. FOR R#, XX L.F. FOR R#, XX L.F. FOR R#, (etc.)","2-900.10"]
[null,null,null,null,null,"Earthwork Calculations","A note shall be added to the plans below the earthwork tabulation block detailing any special areas where topsoil will not be required (such as rock fills not to be seeded). Include topsoil and seeding quantities for sodded or paved ditch areas on projects requiring topsoil and seeded slopes.","2-1007.00"]
[null,null,null,null,null,"Box Culvert  and Slab",null,"2-1200.02"]
[null,null,null,null,null,"Bridge Outlets ","Footnote these quantities to show the amount of concrete and steel bar reinforcement included for the paved aprons, when applicable.","8-604..02"]
[null,null,null,null,null,"If curve inlets and/or"]
[null,null,null,null,"PLACED BY SCALE: 18.00","outlet are required","The inlet and outlet ends of the box culvert at Sta.    shall be curved parallel to the centerline of the roadway.","2-1200.03"]
[null,null,null,null,null,"If the top slab is to be "]
[null,null,null,null,null,"used as the riding "]
[null,null,null,null,null,"surface and the design"]
[null,null,null,null,null,"speed is less then"]
[null,null,null,null,null,"40 mph, the following"]
[null,null,null,null,null,"not shalled be added"]
[null,null,null,null,null,"to the plans","Bridge deck finish to be burlap drag in accordance with method “A” as specified in Subsection 604.23 of the Tennessee Department of Transportation Standard Specifications.","2-1200.03"]
[null,null,null,null,null,"203-50","ITEM NUMBER 203-50 SHALL INCLUDE GEOTEXTILE (TYPE IV), BORROW EXCAVATION (GRADED SOLID ROCK) OR MACHINED RIP-RAP (CLASS A-1, CLASS B, OR CLASS C), MINERAL AGGREGATE (SIZE 57), AND TEMPORARY DRAINAGE PIPE (IF APPLICABLE). THE MINERAL AGGREGRATE INCLUDES AN ADDITIONAL TEN (10) PERCENT FOR MAINTENANCE.","2-1201.02"]
[null,null,null,null,null,"Haul Road","If the haul road is constructed in a dry or unsaturated area, Borrow Excavation (graded solid rock) shall be used. If the haul road is constructed in water or in an area within the flood plain, Machined Rip-Rap (Class A-1, Class B, or, Class C) shall be used in place of Borrow Excavation.             An additional ten (10) percent for Mineral Aggregate is included in Item 203-50. The additional ten (10) percent is for the maintenance of the haul road due to inclement weather events outside the contractor’s control.","2-1201.02"]
[null,null,null,null,null,"303-01","Footnote the quantity used for driveway.","2-1501.00"]
[null,null,null,null,null,"712-02.60","This item shall be a portable energy absorbing terminal meeting the requirements of AASHTO MASH for Test Level 3. The pay item will include furnishing and installing all components as shown on the manufacturer’s drawing.","5-205.00"]
[null,null,null,null,null,"712-06.16","Item to be used only when a reduced speed limit is established within the project construction work zone limits. Item includes sign face, supports, and two type “B” flashers per the standard specifications. The contractor shall be responsible for turning on the type “B” flashers when workers are in the construction work zone and turning them off when workers are no longer in the construction work zone.","5-208.00"]
[null,null,null,null,null,"202-01 or 202-01.50","add a footnote to the estimated quantities block detailing exactly what major items are included in the item (this includes, but is not limited to catch basins, manholes, junction boxes, etc.).","8-202.00"]
[null,null,null,null,null,"202-04.50 to 202-04.65","shall be footnoted under the appropriate estimated quantities block as to whether the salvage shall become the property of the contractor, city, county or state.  ","8-202.01"]
[null,null,null,null,null,"202-06.01 to 202-06.41","Bid price includes all salvage value of material. See tabulated quantities sheet No. 2___ for removal of buildings and obstructions description block.","8-202.02"]
[null,null,null,null,null,"All grading quantities ","See Grading Special Notes on sheet 2_.","8-203.01"]
[null,null,null,null,null,"Pipe Culvert and"]
[null,null,null,null,null,"Bedding Material","Designers should include a footnote under the estimated roadway quantities block that the bedding material shall be included in the cost of the proposed pipe culvert.\n\t“See Standard Drawing No. D-PB-1 and D-PB-2 for additional details.”","8-204.01"]
[null,null,null,null,null,"Excavation for Concrete"]
[null,null,null,null,null,"Box and Slab Type "]
[null,null,null,null,null,"Culverts and Bridges","Culvert excavation for concrete box or slab type culverts or bridges will not be measured and paid for directly, but the cost will be included in the cost of other items.","8-204.02"]
[null,null,null,null,null,"Brooming and Degrassing","The Designer shall footnote all applicable brooming and degrassing pay items with the following notes:\n“Includes the cost of removing debris and sweeping shoulders prior to work. See sheet \nno. ____, ___________ note (____) for more information.”","8-208.00"]
[null,null,null,null,null,"All Applicalble EPSC   "]
[null,null,null,null,null,"pay items","See Subsection 209.07 of the Standard Specifications for Maintenance Replacement.  All quantities are to be used as directed by the Engineer.","8-209.00"]
[null,null,null,null,null,"302-02","NOTE: To be used only when specifically recommended                                                                                                           Subsection 302.08 of the Standard Specifications requires slurry application unless otherwise shown on plans. If dry application is specified by the Pavement Design Section, it shall be necessary to footnote pay items.","8-302.00"]
[null,null,null,null,null,"402-01, 402-02, ",null,"8-402.01"]
[null,null,null,null,null,"403-05.01, 405-01.01,",null,"8-403.02"]
[null,null,null,null,null,"405-01.02, ","Designers shall assume the mid-point of the rate ranges when calculating quantities.  If a different value is used, footnote this item on the estimated roadway quantities sheet in the plans to indicate the rate used.  Designers shall show the rate range on the proposed pavement schedule in the plans.","8-405.00"]
[null,null,null,null,null,"402-02","Item to be used as directed by the engineer.","8-402.01"]
[null,null,null,null,null,"403-01","If a specific aggregate size is intended to be used, use the coordinating midpoint of the ranges identified in Table 405.06-1 of Standard and Supplemental Specifications 405.06 and footnote this item on the estimated roadway quantities sheet in the plans to indicate which rate and aggregate size should be used.","8-405.01"]
[null,null,null,null,null,"403-01.01","No payment will be made directly for the water required to dilute the tack coat.                                                                       ","8-414.01"]
[null,null,null,null,null,"414-03.01","Application rate based on 12 percent of the dry weight of the aggregate.","8-414.01"]
[null,null,null,null,null,"414-03.02","Application rate:  1 pass = 22 pounds (approximate depth 0.275”) per square yard \t\t                                                     2 pass = 32 pounds (approximate depth 0.375”) per  square yard","8-414.01"]
[null,null,null,null,null,"610-07.03, 709-01.01","These pay items in the estimated roadway quantities block shall be footnoted as follows:\n\t“Standard Drawing STD-1-7 (or STD-1-11) is to be used for burial of the outlet pipe and for end treatment details.”","8-611.01"]
[null,null,null,null,null,"621-01.01 to 621-01.10","Quantity is based on minimum calculated length. Actual length required will be determined based on field conditions encountered. The bidder is responsible for verifying estimated lengths prior to submitting their bid. Additional length, if any, required by actual field measurements will be installed at no additional cost. All costs shall be included in the bid price for these items.","8-621.00"]
[null,null,null,null,null,"Rip Rap"]
[null,null,null,null,null,"709-05.05 to 709-05.09","Footnote each structure separately identifying all quantities and the structures with which they are used. ","8-709.01"]
[null,null,null,null,null,"Crown Vetch Mixture"]
[null,null,null,null,null,"(with mulch)","Item No. 801-01.02, Crown Vetch Mixture (with mulch) shall be used on slopes 3H:1V or steeper and other areas, as indicated in the plans, that are inaccessible for mowing. ","8-801.02"]
[null,null,null,null,null,"Seeding (without mulch),"]
[null,null,null,null,null,"Temporary Seeding "]
[null,null,null,null,null,"(with mulch)","The cost of fertilizer and lime used in initial seed bed preparation is to be included in the cost of seeding.  See Section 801 of TDOT Standard Specifications for Road and Bridge Construction.","8-801.03"]
[null,null,null,null,null,"801-03","Includes            thousand gallons for erosion prevention and sediment control.","8-801.04"]
[null,null,null,null,null,"For large projects when"]
[null,null,null,null,null,"item nos. 801-01 &",null,"8-801.05"]
[null,null,null,null,null,"801-01.02","For larger projects with significant amount of disturbed area, include Item No. 801-07 and/or Item No. 801-07.01 when using item no. 801-01 and/or 801-01.02. Or for larger projects with significant amount of disturbed area, include Item No. 801-08 and/or when using Item No. 801-01 and/or 801-01.02.","8-801.06"]
[null,null,null,null,null,"Supplemental fertilizer","The cost of any necessary lime to be used in conjunction with supplemental fertilizer is to be included in the cost of the supplemental fertilizer.  See Section 801 of TDOT Standard Specifications for Road and Bridge Construction.","8-801.06"]
[null,null,null,null,null,"806-02.03","Item includes litter and trash removal.  This work will not be measured and paid for directly but will be included in the cost of Item No. 806-02.03 Project Mowing per Cycle","8-806.00"]
[null,null,null,null,null,"First Property Map or"]
[null,null,null,null,null,"Present Layout Sheet,"]
[null,null,null,null,null,"if applicable","IT IS INTENDED THAT ALL BUILDINGS AND/OR PORTIONS OF BUILDINGS THAT ARE WITHIN THE PROPOSED RIGHT-OF-WAY AND/OR EASEMENT LINES FOR THE PROJECT BE REMOVED THERE FROM IN THE PROCESS OF RIGHT-OF-WAY ACQUISITION.  IF ANY SUCH BUILDINGS OR IMPROVEMENTS ARE NOT REMOVED IN THE COURSE OF RIGHT-OF-WAY ACQUISITION, __(A)__ TO BE NOTIFIED IN SUFFICIENT TIME TO PERMIT HAVING SUCH REMOVALS DESIGNATED AS A PART OF THE CONSTRUCTION CONTRACT.   (A) NOTE: FILL IN THE BLANK WITH APPROPRIATE PERSONNEL TITLE(S).\t “THE PROJECT MANAGER, AND REGIONAL PROJECT DEVELOPMENT OFFICE ARE”.","9-300.00"]
[null,null,null,null,null,"First Property Map or"]
[null,null,null,null,null,"Present Layout Sheet,"]
[null,null,null,null,null,"if applicable","ALL RAMPS MUST CONFORM TO THE DEPARTMENT’S “POLICY ON FINANCING CONSTRUCTION OF PUBLIC ROAD INTERSECTIONS AND DRIVEWAYS ON HIGHWAY RESURFACING, RECONSTRUCTION AND CONSTRUCTION PROJECTS ON NEW LOCATIONS”, THE MANUAL ON RULES AND REGULATIONS FOR CONSTRUCTING DRIVEWAYS ON STATE HIGHWAY RIGHT-OF-WAY, STANDARD DRAWING RP-R-1, AND OTHER ACCEPTED DESIGN AND SAFETY STANDARDS.","9-300.00"]

{"sheet":"11_1_Footnotes ","index":12,"n_rows":111,"n_cols":8,"rows_kept":111,"cut":false,"hidden":true,"merged":[[1,5,1,7],[34,4,44,4],[101,0,101,3],[0,0,0,3],[1,1,1,2],[1,4,2,4],[2,1,2,2],[17,4,19,4],[21,4,30,4]]}
[]
[null,"FOOTNOTES",null,null,"NOTES To Designer             Do Not Adjust Text Size!","Specific Notes & Footnotes Related to Special Items in the Roadway Design Guidelines"]
[]
[null,"(1)","Text",null,"Do Not Adjust Row Height!                               ","Item Related to Note","Note (Click on row to expand note) (if the project has this item number, add this footnote or as describe)","RDG Chapter #"]
[null,null,"Text",null,"Row 1 = height of 10, ","Project Length","For all plan phases, the R.O.W. Length, Roadway Length, Bridge Length, Box Bridge Length, and Project Length shall be shown below the map and shall be noted to the 1000th of a mile and shown as X.XXX. ","1-203.06"]
[null,null,"Text",null,"Row 2 = height of 24,","Road Closed during"]
[null,null,null,null,"Row 3 = height of  8,","Construction","If the road is going to be closed during construction, this should be noted on the Line and Grade, Functional Design, Plan-in-Hand, and PS&E title sheet ","1-203.12"]
[null,"(2)","Text",null,"Row 4 thru 66 = height of 14 and"]
[null,null,null,null,"Row 67 height of 12.","PS&E Index ","The Index of Sheets for PS&E plans is not shown on the title sheet as it is in the Line and Grade and Functional Design plans. Designers shall place a note in the upper left corner of the title sheet which says, “See Sht. 1A for Index”","1-206.01"]
[null,"(3)","Text",null,"The maximum number of Rows to be placed in a DGN file is 67.","Item in question added "]
[null,null,null,null,"to be placed in a DGN file is 67.","to the estimate, but may"]
[null,null,null,null,"Do Not Adjust Column Width!","not be used by the "]
[null,null,null,null,"Column A is 2 wide,","contractor shall be"]
[null,null,null,null,"Column B is 8 wide,","discussed at PIH Field"]
[null,null,null,null,"Column C is 92 wide and","Review","footnoted \"Requested by _______Division\"","1-401.00"]
[null,null,null,null,"Column D is 2 wide.","Item used in multiple"]
[null,null,null,null,"Placing Foot Notes.","locations","When an item is used in multiple locations for various reasons, footnotes shall be used to define what the use and quantity is for each item within the total.","1-403.00"]
[null,null,null,null,"Foot Note Numbers go in column B and the Notes go in column C as shown.","Lump Sum (LS)"]
[null,null,null,null,null,"quantities","The description shall be filled in and a breakdown of the items included in the lump sum shall be footnoted","1-403.00"]
[null,null,null,null,null,"Erosion Control that"]
[null,null,null,null,"Ending the Foot Notes Block.","might have to be "]
[null,null,null,null,"You need to place a solid black line at the bottom of the Foot Notes Block if you are not using all 66 lines. After filling in all Footnotes go to the Row below the last Foot Note and edit cells for column B and C. To Edit the Cells you need to highlight cells with your mouse. Then right click with your mouse and click on Format Cells. Click on the Border Tab and then choose the line style to be placed by clicking on it. Use the line style in the second column, third from the bottom. Then in the white area that has the word TEXT click where you want the line to be placed. Then click OK.","replaced during the "]
[null,null,null,null,null,"life cycle of the project","SEE SUBSECTION 209.07 OF THE STANDARD SPECIFICATIONS FOR MAINTENANCE REPLACEMENT","1-403.00"]
[null,null,null,null,null,"Approved Design",null,"1-203.13 "]
[null,null,null,null,null,"Exception","Approved design exceptions shall be noted, with approval date, in the lower right corner of the title sheet as well as on the cover sheet for the Functional Design.","2-105.00"]
[null,null,null,null,null,"Approved Design"]
[null,null,null,null,null,"Waivers","Approved design waivers shall be noted, with approval date, in the lower right corner of the title sheet as well as on the cover sheet for the Functional Design and Plan-in-Hand checklist.","2-201.00"]
[null,null,null,null,null,"716-12.02","Contractor shall use the extruded or ribbon method for application","2-502.00"]
[null,null,null,null,null,"716-02.08 or 716-02.09","Contractor may elect to substitute Preformed Plastic for Thermoplastic.  Preformed Plastic shall be paid for at the same unit price as bid for Thermoplastic","2-508.00"]
[null,null,null,null,null,"For ALL project with"]
[null,null,null,null,null,"retaining walls","ALL COST OF BUILDING AND INSTALLING THE RETAINING WALL, INCLUDING FOUDATION PREPARATION, BACKFILLING, AND EXCAVATION, SHALL BE INCLUDED IN THE SQUARE FOOTAGE COST OF THE RETAINING WALL. QUANTITIES FOR FOUNDATION PREPARATION, BACKFILL, AND EXCAVATION ARE REFLECTED IN THE END AREA CALCULATIONS ON CROSS SECTIONS AND IN GRADING QUANTITY ROADWAY ITEM 203-01, ROAD AND DRAINAGE EXCAVATION (C.Y.). THE DESIGNER HAS NOTED THE PORTION OF THIS QUANTITY FOR THESE ITEMS ON THE PROFILE SHEET XX AND ON THE GRADING QUANITITY TABULATION SHEET. THE PORTION OF THIS QUANTITY HAS BEEN REMOVED FROM ROADWAY ITEM 203-01, ROAD AND DRAINAGE EXCAVATION (C.Y.). FOR FURTHER INFORMATION ON RETAINING WALLS AND QUANTITIES, SEE SHEET(S) (R, R1, R1A, R1B, R2, R2A, R2B, etc.).","2-900.10"]
[null,null,null,null,null,"If a Concrete Parapet is"]
[null,null,null,null,"TO PLACE THE FOOT NOTES","on one retaining wall","CONCRETE PARAPET IS LOCATED ON RETAINING WALL R# AND IS NOT INCLUDED IN THE COST OF THE RETAINING WALL","2-900.10"]
[null,null,null,null,"IN A DGN FILE.","if Concrete Parapet is "]
[null,null,null,null,"You need a DGN 2nd sheet Seed File with the snaps at the top of the sheet to place the Foot Notes in. Highlight the block to be placed by Click with your mouse in Row 1, anywhere and hold down the button then pull down to the last Row of your Foot Notes Block, where you just placed the solid line to end the block then release the button. This will highlight area to be placed in the DGN. Right click with your mouse and select COPY. Now in your DGN file click on Edit at the top and pull down to paste special. When the window opens chose Linked Microsoft Excel worksheet. This opens a placement menu, chose Paste as Link and By Corners. To place use the snaps tabs at the top of the DGN sheet for the left side of the Foot Notes and right side for the Foot Notes Block.","on multiple retaining"]
[null,null,null,null,null,"walls","CONCRETE PARAPET IS NOT INCLUDED IN THE COST OF THE RETAINING WALL. BREAKDOWN OF CONCRETE PARAPET FOR EACH WALL IS XX L.F. FOR R#, XX L.F. FOR R#, XX L.F. FOR R#, (ETC.)","2-900.10"]
[null,null,null,null,null,"If Concrete Barrier is"]
[null,null,null,null,null,"on one retaining wall","CONCRETE BARRIER IS LOCATED ON RETAINING WALL R# AND IS NOT INCLUDED IN THE COST OF THE RETAINING WALL.","2-900.10"]
[null,null,null,null,null,"If Concrete Barrier is "]
[null,null,null,null,null,"on multiple retaining "]
[null,null,null,null,null,"walls","CONCRETE BARRIER IS NOT INCLUDED IN THE COST OF THE RETAINING WALL. BREAKDOWN OF CONCRETE BARRIER FOR EACH WALL IS XX L.F. FOR R#, XX L.F. FOR R#, XX L.F. FOR R#, (etc.)","2-900.10"]
[null,null,null,null,null,"Earthwork Calculations","A note shall be added to the plans below the earthwork tabulation block detailing any special areas where topsoil will not be required (such as rock fills not to be seeded). Include topsoil and seeding quantities for sodded or paved ditch areas on projects requiring topsoil and seeded slopes.","2-1007.00"]
[null,null,null,null,null,"Box Culvert  and Slab",null,"2-1200.02"]
[null,null,null,null,null,"Bridge Outlets ","Footnote these quantities to show the amount of concrete and steel bar reinforcement included for the paved aprons, when applicable.","8-604.02"]
[null,null,null,null,null,"If curve inlets and/or"]
[null,null,null,null,"PLACED BY SCALE: 18.00","outlet are required","The inlet and outlet ends of the box culvert at Sta.    shall be curved parallel to the centerline of the roadway.","2-1200.03"]
[null,null,null,null,null,"If the top slab is to be "]
[null,null,null,null,null,"used as the riding "]
[null,null,null,null,null,"surface and the design"]
[null,null,null,null,null,"speed is less then"]
[null,null,null,null,null,"40 mph, the following"]
[null,null,null,null,null,"not shalled be added"]
[null,null,null,null,null,"to the plans","Bridge deck finish to be burlap drag in accordance with method “A” as specified in Subsection 604.23 of the Tennessee Department of Transportation Standard Specifications.","2-1200.03"]
[null,null,null,null,null,"203-50","ITEM NUMBER 203-50 SHALL INCLUDE GEOTEXTILE (TYPE IV), BORROW EXCAVATION (GRADED SOLID ROCK) OR MACHINED RIP-RAP (CLASS A-1, CLASS B, OR CLASS C), MINERAL AGGREGATE (SIZE 57), AND TEMPORARY DRAINAGE PIPE (IF APPLICABLE). THE MINERAL AGGREGRATE INCLUDES AN ADDITIONAL TEN (10) PERCENT FOR MAINTENANCE.","2-1201.02"]
[null,null,null,null,null,"Haul Road","If the haul road is constructed in a dry or unsaturated area, Borrow Excavation (graded solid rock) shall be used. If the haul road is constructed in water or in an area within the flood plain, Machined Rip-Rap (Class A-1, Class B, or, Class C) shall be used in place of Borrow Excavation.             An additional ten (10) percent for Mineral Aggregate is included in Item 203-50. The additional ten (10) percent is for the maintenance of the haul road due to inclement weather events outside the contractor’s control.","2-1201.02"]
[null,null,null,null,null,"303-01","Footnote the quantity used for driveway.","2-1501.00"]
[null,null,null,null,null,"712-02.60","This item shall be a portable energy absorbing terminal meeting the requirements of AASHTO MASH for Test Level 3. The pay item will include furnishing and installing all components as shown on the manufacturer’s drawing.","5-205.00"]
[null,null,null,null,null,"712-06.16","Item to be used only when a reduced speed limit is established within the project construction work zone limits. Item includes sign face, supports, and two type “B” flashers per the standard specifications. The contractor shall be responsible for turning on the type “B” flashers when workers are in the construction work zone and turning them off when workers are no longer in the construction work zone.","5-208.00"]
[null,null,null,null,null,"202-01 or 202-01.50","add a footnote to the estimated quantities block detailing exactly what major items are included in the item (this includes, but is not limited to catch basins, manholes, junction boxes, etc.).","8-202.00"]
[null,null,null,null,null,"202-04.50 to 202-04.65","shall be footnoted under the appropriate estimated quantities block as to whether the salvage shall become the property of the contractor, city, county or state.  ","8-202.01"]
[null,null,null,null,null,"202-06.01 to 202-06.41","Bid price includes all salvage value of material. See tabulated quantities sheet No. 2___ for removal of buildings and obstructions description block.","8-202.02"]
[null,null,null,null,null,"All grading quantities ","See Grading Special Notes on sheet 2_.","8-203.01"]
[null,null,null,null,null,"Pipe Culvert and"]
[null,null,null,null,null,"Bedding Material","Designers should include a footnote under the estimated roadway quantities block that the bedding material shall be included in the cost of the proposed pipe culvert.\n\t“See Standard Drawing No. D-PB-1 and D-PB-2 for additional details.”","8-204.01"]
[null,null,null,null,null,"Excavation for Concrete"]
[null,null,null,null,null,"Box and Slab Type "]
[null,null,null,null,null,"Culverts and Bridges","Culvert excavation for concrete box or slab type culverts or bridges will not be measured and paid for directly, but the cost will be included in the cost of other items.","8-204.02"]
[null,null,null,null,null,"Brooming and Degrassing","The Designer shall footnote all applicable brooming and degrassing pay items with the following notes:\n“Includes the cost of removing debris and sweeping shoulders prior to work. See sheet \nno. ____, ___________ note (____) for more information.”","8-208.00"]
[null,null,null,null,null,"All Applicalble EPSC   "]
[null,null,null,null,null,"pay items","See Subsection 209.07 of the Standard Specifications for Maintenance Replacement.  All quantities are to be used as directed by the Engineer.","8-209.00"]
[null,null,null,null,null,"302-02","NOTE: To be used only when specifically recommended                                                                                                           Subsection 302.08 of the Standard Specifications requires slurry application unless otherwise shown on plans. If dry application is specified by the Pavement Design Section, it shall be necessary to footnote pay items.","8-302.00"]
[null,null,null,null,null,"402-01, 402-02, ",null,"8-402.01"]
[null,null,null,null,null,"403-05.01, 405-01.01,",null,"8-403.02"]
[null,null,null,null,null,"405-01.02, ","Designers shall assume the mid-point of the rate ranges when calculating quantities.  If a different value is used, footnote this item on the estimated roadway quantities sheet in the plans to indicate the rate used.  Designers shall show the rate range on the proposed pavement schedule in the plans.","8-405.00"]
[null,null,null,null,null,"402-02","Item to be used as directed by the engineer.","8-402.01"]
[null,null,null,null,null,"403-01","If a specific aggregate size is intended to be used, use the coordinating midpoint of the ranges identified in Table 405.06-1 of Standard and Supplemental Specifications 405.06 and footnote this item on the estimated roadway quantities sheet in the plans to indicate which rate and aggregate size should be used.","8-405.01"]
[null,null,null,null,null,"403-01.01","No payment will be made directly for the water required to dilute the tack coat.                                                                       ","8-414.01"]
[null,null,null,null,null,"414-03.01","Application rate based on 12 percent of the dry weight of the aggregate.","8-414.01"]
[null,null,null,null,null,"414-03.02","Application rate:  1 pass = 22 pounds (approximate depth 0.275”) per square yard \t\t                                                     2 pass = 32 pounds (approximate depth 0.375”) per  square yard","8-414.01"]
[null,null,null,null,null,"610-07.03, 709-01.01","These pay items in the estimated roadway quantities block shall be footnoted as follows:\n\t“Standard Drawing STD-1-7 (or STD-1-11) is to be used for burial of the outlet pipe and for end treatment details.”","8-611.01"]
[null,null,null,null,null,"621-01.01 to 621-01.10","Quantity is based on minimum calculated length. Actual length required will be determined based on field conditions encountered. The bidder is responsible for verifying estimated lengths prior to submitting their bid. Additional length, if any, required by actual field measurements will be installed at no additional cost. All costs shall be included in the bid price for these items.","8-621.00"]
[null,null,null,null,null,"Rip Rap"]
[null,null,null,null,null,"709-05.05 to 709-05.09","Footnote each structure separately identifying all quantities and the structures with which they are used. ","8-709.01"]
[null,null,null,null,null,"Crown Vetch Mixture"]
[null,null,null,null,null,"(with mulch)","Item No. 801-01.02, Crown Vetch Mixture (with mulch) shall be used on slopes 3H:1V or steeper and other areas, as indicated in the plans, that are inaccessible for mowing. ","8-801.02"]
[null,null,null,null,null,"Seeding (without mulch),"]
[null,null,null,null,null,"Temporary Seeding "]
[null,null,null,null,null,"(with mulch)","The cost of fertilizer and lime used in initial seed bed preparation is to be included in the cost of seeding.  See Section 801 of TDOT Standard Specifications for Road and Bridge Construction.","8-801.03"]
[null,null,null,null,null,"801-03","Includes            thousand gallons for erosion prevention and sediment control.","8-801.04"]
[null,null,null,null,null,"For large projects when"]
[null,null,null,null,null,"item nos. 801-01 &",null,"8-801.05"]
[null,null,null,null,null,"801-01.02","For larger projects with significant amount of disturbed area, include Item No. 801-07 and/or Item No. 801-07.01 when using item no. 801-01 and/or 801-01.02. Or for larger projects with significant amount of disturbed area, include Item No. 801-08 and/or when using Item No. 801-01 and/or 801-01.02.","8-801.06"]
[null,null,null,null,null,"Supplemental fertilizer","The cost of any necessary lime to be used in conjunction with supplemental fertilizer is to be included in the cost of the supplemental fertilizer.  See Section 801 of TDOT Standard Specifications for Road and Bridge Construction.","8-801.06"]
[null,null,null,null,null,"806-02.03","Item includes litter and trash removal.  This work will not be measured and paid for directly but will be included in the cost of Item No. 806-02.03 Project Mowing per Cycle","8-806.00"]
[null,null,null,null,null,"First Property Map or"]
[null,null,null,null,null,"Present Layout Sheet,"]
[null,null,null,null,null,"if applicable","IT IS INTENDED THAT ALL BUILDINGS AND/OR PORTIONS OF BUILDINGS THAT ARE WITHIN THE PROPOSED RIGHT-OF-WAY AND/OR EASEMENT LINES FOR THE PROJECT BE REMOVED THERE FROM IN THE PROCESS OF RIGHT-OF-WAY ACQUISITION.  IF ANY SUCH BUILDINGS OR IMPROVEMENTS ARE NOT REMOVED IN THE COURSE OF RIGHT-OF-WAY ACQUISITION, __(A)__ TO BE NOTIFIED IN SUFFICIENT TIME TO PERMIT HAVING SUCH REMOVALS DESIGNATED AS A PART OF THE CONSTRUCTION CONTRACT.   (A) NOTE: FILL IN THE BLANK WITH APPROPRIATE PERSONNEL TITLE(S).\t “THE PROJECT MANAGER, AND REGIONAL PROJECT DEVELOPMENT OFFICE ARE”.","9-300.00"]
[null,null,null,null,null,"First Property Map or"]
[null,null,null,null,null,"Present Layout Sheet,"]
[null,null,null,null,null,"if applicable","ALL RAMPS MUST CONFORM TO THE DEPARTMENT’S “POLICY ON FINANCING CONSTRUCTION OF PUBLIC ROAD INTERSECTIONS AND DRIVEWAYS ON HIGHWAY RESURFACING, RECONSTRUCTION AND CONSTRUCTION PROJECTS ON NEW LOCATIONS”, THE MANUAL ON RULES AND REGULATIONS FOR CONSTRUCTING DRIVEWAYS ON STATE HIGHWAY RIGHT-OF-WAY, STANDARD DRAWING RP-R-1, AND OTHER ACCEPTED DESIGN AND SAFETY STANDARDS.","9-300.00"]
[]
[]
[null,null,null,null,null,"All Applicalble EPSC   "]
[null,null,null,null,null,"pay items","See Subsection 209.07 of the Standard Specifications for Maintenance Replacement.  All quantities are to be used as directed by the Engineer.","8-209.00"]
[null,null,null,null,null,"302-02","NOT: To be used only when specifically recommended                                                                                                           Subsection 302.08 of the Standard Specifications requires slurry application unless otherwise shown on plans. If dry application is specified by the Pavement Design Section, it shall be necessary to footnote pay items.","8-302.00"]
[null,null,null,null,null,"402-01, 402-02, ",null,"8-402.01"]
[null,null,null,null,null,"403-05.01, 405-01.01,",null,"8-403.02"]
[null,null,null,null,null,"405-01.02, ","Designers shall assume the mid-point of the rate ranges when calculating quantities.  If a different value is used, footnote this item on the estimated roadway quantities sheet in the plans to indicate the rate used.  Designers shall show the rate range on the proposed pavement schedule in the plans.","8-405.00"]
[null,null,null,null,null,"403-0","If a specific aggregate size is intended to be used, use the coordinating midpoint of the ranges identified in Table 405.06-1 of Standard and Supplemental Specifications 405.06 and footnote this item on the estimated roadway quantities sheet in the plans to indicate which rate and aggregate size should be used.","8-405.01"]
[null,null,null,null,null,"403-01.01","No payment will be made directly for the water required to dilute the tack coat.","8-414.01"]
[null,null,null,null,null,"610-07.03, 709-01.01","These pay items in the estimated roadway quantities block shall be footnoted as follows:\n\t“Standard Drawing STD-1-7 (or STD-1-11) is to be used for burial of the outlet pipe and for end treatment details.”","8-611.01"]

{"sheet":"Box Bridge Quantities Block","index":13,"n_rows":66,"n_cols":18,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10],[8,17,8,28]]}
[]
[null,"ESTIMATED BOX BRIDGE QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Utilities","index":14,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10]]}
[]
[null,"UTILITY QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:I32)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:I33)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:I34)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E35:I35)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Add Sheets","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[[58,1,58,6],[58,7,58,9],[58,13,58,14],[6,12,7,12],[6,13,7,13],[6,14,7,14],[6,9,7,9],[6,10,7,10],[6,11,7,11],[0,0,0,18],[2,1,7,1],[2,2,7,2],[2,3,5,6],[2,7,5,9],[2,10,5,12],[2,13,5,14],[2,15,5,17],[6,3,7,3],[6,4,7,4],[6,15,7,15],[6,16,7,16],[6,17,7,17],[6,5,6,6],[6,7,7,7],[6,8,7,8]]}

{"sheet":"Storm Drainage Pipe Totals","index":16,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[[16,1,16,8],[17,1,17,8],[0,0,0,9],[1,1,1,8],[2,2,2,8],[13,0,13,9],[14,1,14,8],[15,1,15,8]]}
["             "]
[null,"STORM DRAINAGE PIPE TOTALS"]
[null,null,"REINFORCED CONCRETE PIPE - CLASS, ITEM NO., SIZE & LENGTH (FT.)"]
[null,"TABLE",null,"CLASS III","CLASS III","CLASS III","CLASS III","CLASS III"]
[null,"NO.",null,"607-03.02","607-05.02","607-06.02","607-07.02","607-08.02"]
[null,null,null,"18\"","24\"","30\"","36\"","42\""]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"TOTALS",{"$f":"SUM(C7:C12)","v":0},0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]
[null,"To be used with tables named: STORM DRAINAGE PIPES (TABLE NO. 1) Etc."]

{"sheet":"3_0_Side Drain","index":17,"n_rows":62,"n_cols":24,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,7,61,18],[2,19,2,22],[59,1,59,6],[59,19,59,23],[1,1,1,23],[4,7,4,12],[60,0,60,24],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,7,5,12],[5,13,5,18],[0,0,0,24],[2,13,2,18],[2,2,2,3],[2,7,2,12],[3,7,3,12],[3,19,4,20],[3,21,4,22],[3,13,3,18],[4,13,4,18],[4,2,4,3],[3,2,3,3]]}
[]
[null,"SIDE  DRAIN  TABULATION"]
[null,null,null,null,null,null,null,"RCP CLASS III OR CMP 16 GA",null,null,null,null,null,"RCP CLASS III OR CMP 14 GA",null,null,null,null,null,"END TREATMENT"]
[null,null,"LOCATION",null,null,"SURFACE","SKEW","OR PVC OR SRTRP OR HDPE OR PP",null,null,null,null,null,"OR PVC OR SRTRP OR HDPE OR PP",null,null,null,null,null,"INLET",null,"OUTLET"]
[null,"STATION",null,null,"DESCRIPTION","WIDTH",null,"(L.F.)",null,null,null,null,null,"(L.F.)",null,null,null,null,null,null,null,null,null,"REMARKS"]
[null,null,"LT.","RT.",null,"FT.",null,"FILL HEIGHT  ≤ 10 FT.",null,null,null,null,null,"FILL HEIGHT > 10 FT. AND  ≤ 16 FT",null,null,null,null,null,"TYPE","DRAWING NO.","TYPE","DRAWING NO."]
[null,null,null,null,null,null,null,"18\"","24\"","30\"","36\"","42\"","48\"","18\"","24\"","30\"","36\"","42\"","48\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,{"$f":"SUM(H8:H59)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Pipe Tabulation For Private Drives, Business & Field Entrances"]
[]
[null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"3_1_Side Drain","index":18,"n_rows":62,"n_cols":30,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,30],[2,13,2,18],[2,19,2,24],[2,2,2,3],[2,7,2,12],[2,25,2,28],[1,1,1,29],[61,7,61,24],[60,0,60,30],[3,25,4,26],[3,27,4,28],[5,25,6,25],[3,2,3,3],[59,1,59,6],[59,25,59,29],[3,7,3,12],[4,7,4,12],[3,13,3,18],[4,13,4,18],[5,13,5,18],[3,19,3,24],[4,19,4,24],[5,19,5,24],[4,2,4,3],[5,26,6,26],[5,27,6,27],[5,28,6,28],[5,7,5,12]]}
[]
[null,"SIDE  DRAIN  TABULATION"]
[null,null,null,null,null,null,null,"RCP CLASS III OR CMP 16 GA",null,null,null,null,null,"RCP CLASS III OR CMP 14 GA",null,null,null,null,null,"RCP CLASS III OR CMP 14 GA",null,null,null,null,null,"END TREATMENT"]
[null,null,"LOCATION",null,null,"SURFACE","SKEW","OR PVC OR SRTRP OR HDPE OR PP",null,null,null,null,null,"OR PVC OR SRTRP OR HDPE OR PP",null,null,null,null,null,"OR PVC",null,null,null,null,null,"INLET",null,"OUTLET"]
[null,"STATION",null,null,"DESCRIPTION","WIDTH",null,"FILL HEIGHT  ≤ 10 FT.",null,null,null,null,null,"FILL HEIGHT > 10 FT. AND  ≤ 16 FT",null,null,null,null,null,"FILL HEIGHT > 16 FT. AND  ≤ 24 FT",null,null,null,null,null,null,null,null,null,"REMARKS"]
[null,null,"LT.","RT.",null,"FT.",null,"(L.F.)",null,null,null,null,null,"(L.F.)",null,null,null,null,null,"(L.F.)",null,null,null,null,null,"TYPE","DRAWING NO.","TYPE","DRAWING NO."]
[null,null,null,null,null,null,null,"18\"","24\"","30\"","36\"","42\"","48\"","18\"","24\"","30\"","36\"","42\"","48\"","18\"","24\"","30\"","36\"","42\"","48\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,{"$f":"SUM(H8:H59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Pipe Tabulation For Private Drives, Business & Field Entrances"]
[]
[null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"3_2_Side Drain","index":19,"n_rows":62,"n_cols":24,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,5,61,18],[2,19,2,22],[59,1,59,6],[59,19,59,23],[1,1,1,23],[5,7,5,8],[5,9,5,12],[60,0,60,24],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,13,5,18],[0,0,0,24],[2,2,2,3],[2,7,2,12],[3,7,3,12],[4,7,4,12],[2,13,3,18],[3,19,4,20],[3,21,4,22],[4,13,4,18],[4,2,4,3],[3,2,3,3]]}
[" "]
[null,"SIDE  DRAIN  TABULATION"]
[null,null,null,null,null,null,null,"RCP CLASS V OR CMP",null,null,null,null,null,"RCP CLASS V",null,null,null,null,null,"END TREATMENT"]
[null,null,"LOCATION",null,null,"SURFACE","SKEW","FILL HEIGHT > 24 FT. AND  ≤ 38 FT.",null,null,null,null,null,null,null,null,null,null,null,"INLET",null,"OUTLET"]
[null,"STATION",null,null,"DESCRIPTION","WIDTH",null,"(L.F.)",null,null,null,null,null,"FILL HEIGHT > 38 FT.",null,null,null,null,null,null,null,null,null,"REMARKS"]
[null,null,"LT.","RT.",null,"FT.",null,"14 GA ",null,"10 GA",null,null,null,"(L.F.) ",null,null,null,null,null,"TYPE","DRAWING NO.","TYPE","DRAWING NO."]
[null,null,null,null,null,null,null,"42\"","48\"","54\"","60\"","66\"","72\"","42\"","48\"","54\"","60\"","66\"","72\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,{"$f":"SUM(H8:H59)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Pipe Tabulation For Private Drives, Business & Field Entrances"]
[]
[null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"3_3_Side Drain","index":20,"n_rows":62,"n_cols":19,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,7,61,13],[60,0,60,19],[59,1,59,6],[1,1,1,18],[0,0,0,19],[2,10,2,18]]}
[]
[null,"SIDE  DRAIN  ENDWALLS"]
[null,null,null,null,null,null,null,"RIP-RAP","CLASS","STEEL","ENDWALLS"]
[null,null,null,null,null,null,null,"CLASS","A","BAR","15 IN.","18 IN.","24 IN.","30\" IN.","36\" IN.","42\" IN.","48\" IN.","15\" IN.","18\" IN."]
[null,"LOCATION","DRIVE OR","OFFSET","TYPE","STANDARD","SKEW","xx","CONC.","REINF.","6:1","6:1","6:1","6:1","6:1","6:1","6:1","12:1","12:1"]
[null,null,"ENTRANCE","(FT.)",null,"DRAWING",null,"709-05.xx","611-07.01","611-07.02","611-07.30","611-07.31","611-07.32","611-07.33","611-07.34","611-07.35","611-07.36","611-07.72","611-07.73"]
[null,null,"STATION",null,null,"NO.",null,"(TON)","(C.Y.)","(LB.)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)"]
[]
[]
[]
[]
[]
[null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,{"$f":"SUM(H8:H59)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"2_0_Cross Drai","index":21,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":true,"merged":[[2,15,2,18],[59,1,59,2],[59,15,59,19],[1,1,1,19],[0,0,0,20],[2,9,2,14],[2,3,2,8],[3,3,3,8],[4,3,4,8],[61,3,61,14],[60,0,60,20],[3,15,4,16],[3,17,4,18],[5,15,6,15],[5,17,6,17],[5,3,5,8],[3,9,3,14],[4,9,4,14],[5,9,5,14]]}
[]
[null,"CROSS  DRAIN  TABULATION"]
[null,null,null,"RCP CLASS III OR CMP 10 GA",null,null,null,null,null,"RCP CLASS IV",null,null,null,null,null,"END TREATMENT"]
[null,null,null,"OR PVC OR SRTRP OR HDPE OR PP",null,null,null,null,null,"OR PVC",null,null,null,null,null,"INLET",null,"OUTLET"]
[null,"STATION","SKEW","FILL HEIGHT  ≤ 16 FT.",null,null,null,null,null,"FILL HEIGHT > 16 FT. AND  ≤ 24 FT",null,null,null,null,null,null,null,null,null,"REMARKS"]
[null,null,null,"(L.F.)",null,null,null,null,null,"(L.F.)",null,null,null,null,null,"TYPE","DRAWING","TYPE","DRAWING."]
[null,null,null,"18\"","24\"","30\"","36\"","42\"","48\"","18\"","24\"","30\"","36\"","42\"","48\"",null,"NO.",null,"NO."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,{"$f":"SUM(D8:D59)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Pipe Tabulation For Arterial Roadways"]
[]
[null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"2_1_Cross Drai","index":22,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":true,"merged":[[2,15,2,18],[59,1,59,2],[59,15,59,19],[1,1,1,19],[0,0,0,20],[2,9,2,14],[2,3,2,8],[3,3,3,8],[4,3,4,8],[61,3,61,14],[60,0,60,20],[3,15,4,16],[3,17,4,18],[5,15,6,15],[5,17,6,17],[5,3,5,8],[3,9,3,14],[4,9,4,14],[5,9,5,14]]}
[]
[null,"CROSS  DRAIN  TABULATION"]
[null,null,null,"RCP CLASS III OR CMP 12 GA",null,null,null,null,null,"RCP CLASS III OR CMP 12 GA",null,null,null,null,null,"END TREATMENT"]
[null,null,null,"OR PVC OR SRTRP OR HDPE OR PP",null,null,null,null,null,"OR PVC",null,null,null,null,null,"INLET",null,"OUTLET"]
[null,"STATION","SKEW","FILL HEIGHT  ≤ 16 FT.",null,null,null,null,null,"FILL HEIGHT > 16 FT. AND  ≤ 24 FT",null,null,null,null,null,null,null,null,null,"REMARKS"]
[null,null,null,"(L.F.)",null,null,null,null,null,"(L.F.)",null,null,null,null,null,"TYPE","DRAWING","TYPE","DRAWING"]
[null,null,null,"18\"","24\"","30\"","36\"","42\"","48\"","18\"","24\"","30\"","36\"","42\"","48\"",null,"NO.",null,"NO."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,{"$f":"SUM(D8:D59)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Pipe Tabulation For Collector Roadways"]
[]
[null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"2_2_Cross Drai","index":23,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":true,"merged":[[4,9,4,14],[5,9,5,14],[3,3,3,8],[4,3,4,8],[61,3,61,14],[2,15,2,18],[0,0,0,20],[2,9,2,14],[2,3,2,8],[60,0,60,20],[3,15,4,16],[3,17,4,18],[5,15,6,15],[5,17,6,17],[5,3,5,8],[3,9,3,14],[59,1,59,2],[59,15,59,19],[1,1,1,19]]}
[]
[null,"CROSS  DRAIN  TABULATION"]
[null,null,null,"RCP CLASS III",null,null,null,null,null,"RCP CLASS IV",null,null,null,null,null,"END TREATMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INLET",null,"OUTLET"]
[null,"STATION","SKEW","FILL HEIGHT  ≤ 16 FT.",null,null,null,null,null,"FILL HEIGHT > 16 FT. AND  ≤ 24 FT",null,null,null,null,null,null,null,null,null,"REMARKS"]
[null,null,null,"(L.F.)",null,null,null,null,null,"(L.F.)",null,null,null,null,null,"TYPE","DRAWING","TYPE","DRAWING"]
[null,null,null,"18\"","24\"","30\"","36\"","42\"","48\"","18\"","24\"","30\"","36\"","42\"","48\"",null,"NO.",null,"NO."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,{"$f":"SUM(D8:D59)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Pipe Tabulation For Interstate Systems & Arterials With Full Access Control"]
[]
[null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"2_3_Cross Drai","index":24,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,20],[2,9,2,14],[2,3,2,8],[60,0,60,20],[3,15,4,16],[61,3,61,14],[2,15,2,18],[59,1,59,2],[59,15,59,19],[1,1,1,19],[3,17,4,18],[5,15,6,15],[5,17,6,17],[5,3,5,8],[3,9,3,14],[4,9,4,14],[5,9,5,14],[3,3,3,8],[4,3,4,8]]}
[]
[null,"CROSS  DRAIN  TABULATION"]
[null,null,null,"RCP CLASS III OR CMP 14 GA",null,null,null,null,null,"RCP CLASS III OR CMP 14 GA",null,null,null,null,null,"END TREATMENT"]
[null,null,null,"OR PVC OR SRTRP OR HDPE OR PP",null,null,null,null,null,"OR PVC",null,null,null,null,null,"INLET",null,"OUTLET"]
[null,"STATION","SKEW","FILL HEIGHT  ≤ 16 FT.",null,null,null,null,null,"FILL HEIGHT > 16 FT. AND  ≤ 24 FT",null,null,null,null,null,null,null,null,null,"REMARKS"]
[null,null,null,"(L.F.)",null,null,null,null,null,"(L.F.)",null,null,null,null,null,"TYPE","DRAWING","TYPE","DRAWING"]
[null,null,null,"18\"","24\"","30\"","36\"","42\"","48\"","18\"","24\"","30\"","36\"","42\"","48\"",null,"NO.",null,"NO."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,{"$f":"SUM(D8:D59)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Pipe Tabulation For Local Roadways"]
[]
[null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"2_4_Cross-Medi","index":25,"n_rows":62,"n_cols":29,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,1,61,28],[0,0,0,29],[1,1,1,28],[2,9,2,10],[2,11,2,28],[59,1,59,7],[60,0,60,29]]}
["                                      "]
[null,"CROSS  DRAIN \\  MEDIAN  DRAIN  ENDWALLS"]
[null,null,null,null,null,null,null,null,"RIP-RAP","PROTECTED ENDWALLS",null,"SAFETY ENDWALLS  (  ITEM NO. 611-07.54 THRU  611-07.71 SERIES )"]
[null,null,null,null,null,null,null,null,"CLASS","CLASS \"A\"","STEEL BAR","18 IN.","18 IN.","18 IN.","24\" IN.","24\" IN.","24\" IN.","30\" IN.","30\" IN.","30\" IN.","36\" IN.","36\" IN.","36\" IN.","42\" IN.","42\" IN.","42\" IN.","48\" IN.","48\" IN.","48\" IN."]
[null,"LOCATION","STATION","OFFSET","SKEW","CODE","TYPE","STANDARD","\"??\"","CONCRETE","REINFORCING","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1"]
[null,null,null,"(FT.)",null,null,null,"DRAWING","709-05.xx","611-07.01","611-07.02","07.54","07.55","07.56","07.57","07.58","07.59","07.60","07.61","07.62","07.63","07.64","07.65","07.66","07.67","07.68","07.69","07.70","07.71"]
[null,null,null,null,null,null,null,"NO.","(TON)","(C.Y.)","(LB.)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,{"$f":"SUM(I8:I59)","v":0},{"$f":"SUM(J8:J59)","v":0},{"$f":"SUM(K8:K59)","v":0},{"$f":"SUM(L8:L59)","v":0},{"$f":"SUM(M8:M59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"2_5_Cross-Medi","index":26,"n_rows":62,"n_cols":29,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,1,61,28],[0,0,0,29],[1,1,1,28],[2,9,2,10],[2,11,2,28],[59,1,59,7],[60,0,60,29]]}
[]
[null,"CROSS  DRAIN\\  MEDIAN  DRAIN\\ STORM DRAIN ENDWALLS"]
[null,null,null,null,null,null,null,null,"RIP-RAP","PROTECTED ENDWALLS",null,"SAFETY ENDWALLS  (  ITEM NO. 611-07.54 THRU  611-07.71 SERIES )"]
[null,null,null,null,null,null,null,null,"CLASS","CLASS \"A\"","STEEL BAR","18 IN.","18 IN.","18 IN.","24\" IN.","24\" IN.","24\" IN.","30\" IN.","30\" IN.","30\" IN.","36\" IN.","36\" IN.","36\" IN.","42\" IN.","42\" IN.","42\" IN.","48\" IN.","48\" IN.","48\" IN."]
[null,"LOCATION \\ SHEET NO.","STATION","OFFSET","SKEW","CODE","TYPE","STANDARD","\"??\"","CONCRETE","REINFORCING","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1"]
[null,null,null,"(FT.)",null,null,null,"DRAWING","709-05.xx","611-07.01","611-07.02","07.54","07.55","07.56","07.57","07.58","07.59","07.60","07.61","07.62","07.63","07.64","07.65","07.66","07.67","07.68","07.69","07.70","07.71"]
[null,null,null,null,null,null,null,"NO.","(TON)","(C.Y.)","(LB.)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,{"$f":"SUM(I8:I59)","v":0},{"$f":"SUM(J8:J59)","v":0},{"$f":"SUM(K8:K59)","v":0},{"$f":"SUM(L8:L59)","v":0},{"$f":"SUM(M8:M59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"2_6_Longitudin","index":27,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,3,61,10],[60,0,60,12],[5,3,5,4],[3,5,3,6],[4,5,4,6],[5,5,5,6],[3,3,3,4],[4,3,4,4],[3,7,3,10],[58,7,58,8],[59,1,59,2],[6,7,6,8],[6,9,6,10],[7,7,7,8],[7,9,7,10],[58,9,58,10],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[17,7,17,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[1,1,1,11],[0,0,0,12],[2,5,2,6],[2,3,2,4],[4,7,4,10],[5,7,5,8],[5,9,5,10],[32,7,32,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[2,7,2,10],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[27,7,27,8],[8,7,8,8],[8,9,8,10],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[49,7,49,8],[26,7,26,8],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[23,9,23,10],[22,7,22,8],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[13,9,13,10],[24,9,24,10],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[48,7,48,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[43,9,43,10],[44,9,44,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[54,7,54,8],[54,9,54,10],[53,7,53,8],[53,9,53,10],[48,9,48,10],[49,9,49,10],[45,7,45,8],[46,7,46,8],[47,7,47,8],[50,7,50,8],[51,7,51,8],[55,7,55,8],[55,9,55,10],[56,7,56,8],[56,9,56,10],[57,9,57,10],[59,7,59,8],[59,9,59,10],[50,9,50,10],[51,9,51,10],[57,7,57,8],[52,7,52,8],[52,9,52,10]]}
[]
[null,"LONGITUDINAL  MEDIAN  DRAINS"]
[null,null,null,"RCP CLASS III OR CMP 16 GA",null,"RCP CLASS III OR",null,"MEDIAN DRAIN"]
[null,null,null,"OR PVC OR SRTRP OR HDPE OR PP",null,"OR PVC OR SRTRP OR HDPE OR PP",null,"END TREATMENT"]
[null,"STATION","SKEW","FILL HEIGHT  ≤ 10 FT.",null,"FILL HEIGHT > 10 FT. AND  ≤ 16 FT",null,"DRAWING NO. D-SEW-12D",null,null,null,"REMARKS"]
[null,null,null,"(L.F.)",null,"(L.F.)",null,"611-07.72",null,"611-07.73"]
[null,null,null,"15\"","18\"","15\"","18\"","15\"",null,"18\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,{"$f":"SUM(D8:D59)","v":0},{"$f":"SUM(E8:E59)","v":0},{"$f":"SUM(F8:F59)","v":0},{"$f":"SUM(G8:G59)","v":0},{"$f":"SUM(H8:I59)","v":0},null,{"$f":"SUM(J8:K59)","v":0}]
[]
[null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"2_7_Median Dra","index":28,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":true,"merged":[[59,1,59,2],[59,15,59,19],[1,1,1,19],[61,3,61,14],[60,0,60,20],[3,15,4,16],[3,17,4,18],[5,15,6,15],[5,17,6,17],[5,3,5,8],[3,9,3,14],[4,9,4,14],[5,9,5,14],[0,0,0,20],[2,9,2,14],[2,3,2,8],[3,3,3,8],[4,3,4,8],[2,15,2,18]]}
[]
[null,"MEDIAN  DRAIN  TABULATION"]
[null,null,null,"RCP CLASS III",null,null,null,null,null,"RCP CLASS IV",null,null,null,null,null,"END TREATMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INLET",null,"OUTLET"]
[null,"STATION","SKEW","FILL HEIGHT  ≤ 16 FT.",null,null,null,null,null,"FILL HEIGHT > 16 FT. AND  ≤ 24 FT",null,null,null,null,null,null,null,null,null,"REMARKS"]
[null,null,null,"(L.F.)",null,null,null,null,null,"(L.F.)",null,null,null,null,null,"TYPE","DRAWING","TYPE","DRAWING"]
[null,null,null,"18\"","24\"","30\"","36\"","42\"","48\"","18\"","24\"","30\"","36\"","42\"","48\"",null,"NO.",null,"NO."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,{"$f":"SUM(D8:D59)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Pipe Tabulation For Interstate Systems & Arterials With Full Access Control"]
[]
[null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"1_0_Box Culver","index":29,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":true,"merged":[[15,2,15,11],[14,0,14,21],[1,1,1,20],[0,0,0,21],[2,3,2,4],[2,12,2,13],[2,14,2,15],[2,16,2,17],[13,1,13,11]]}
[]
[null,"BOX CULVERT \\ BRIDGE TABULATION"]
[null,null,null,"TYPE",null,null,null,null,null,null,null,null,"CULVERT ≤ 20 FT.",null,"BRIDGE > 20 FT.",null,"STD. DWG. STD-17-17 & 18",null,"RIP-RAP"]
[null,null,null,null,null,null,"NO.",null,null,null,"DRAINAGE","STANDARD","CLASS \"A\"","STEEL BAR","CLASS \"A\"","STEEL BAR","FOUNDATION","GRANULAR","CLASS","CHANNEL","CULVERT"]
[null,"STATION","LOCATION","BOX","SLAB","SKEW","BARRELS","WIDTH","HEIGHT","LENGTH","AREA","DRAWING","CONCRETE","REINF.","CONCRETE","REINF.","FILL MATERIAL","BACKFILL","_ _","EXC.","EXC."]
[null,null,null,null,null,null,null,null,null,null,"ACRES","NO.","604-01.01","604-01.02","604-02.01","604-02.02","204-08","303-01.01","709-05.xx","203-08"," ▲ 204-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CU. YD.","LB.","CU. YD.","LB.","CU. YD.","TONS","TON","CU. YD.","CU. YD."]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M13)","v":0},0,0,0,0,0,0,0,0]
["          ▲  ALL COST OF CULVERT EXCAVATION WILL BE INCLUDED IN THE COST OF OTHER ITEMS."]
[null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"1_1_Bridge Dra","index":30,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[[21,1,21,7],[0,0,0,8],[20,0,20,8],[19,1,19,5],[1,1,1,7],[2,3,4,4],[5,3,6,3],[5,4,6,4]]}
[]
[null,"BRIDGE  DRAINS"]
[null,null,null,"SIDE",null,null,"18\" PIPE DRAIN","RUBBLE-STONE"]
[null,null,null,null,null,"SPILLWAY","(BRIDGE DRAIN)","RIP-RAP"]
[null,"STATION","LOCATION",null,null,"WIDTH","ITEM NO.","ITEM NO."]
[null,null,null,"LT.","RT.","(FEET)","610-07.03","709-01.01"]
[null,null,null,null,null,null,"(L.F.)","(CU. YD.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,{"$f":"SUM(G8:G19)","v":0},{"$f":"SUM(H8:H19)","v":0}]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"1_2_CB & Manho","index":31,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[15,1,15,10],[1,1,1,10],[14,2,14,9],[0,0,0,11],[2,2,2,10],[13,0,13,11]]}
["     "]
[null,"CATCH BASIN AND MANHOLE TOTALS"]
[null,null,"PAY  ITEMS"]
[null,"TABLE","TYPE 3","TYPE 12","TYPE 12","TYPE 12","TYPE 14","TYPE 14","TYPE 38","TYPE 38","TYPE 38"]
[null,"NO.","611-01.03","611-12.01","611-12.02","611-12.03","611-14.01","611-14.02","611-38.01","611-38.02","611-38.03"]
[null,null,"8'-12'","0'-4'","4'-8'","8'-12'","0'-4'","4'-8'","0'-4'","4'-8'","8'-12'"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"TOTALS",{"$f":"SUM(C7:C12)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"PLACED BY SCALE: 18.00"]
[null,"To be used with tables named: CATCH BASINS AND MANHOLES (TABLE NO. 1) Etc."]

{"sheet":"1_3_CB Drop In","index":32,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[15,1,15,10],[16,1,16,10],[1,1,1,10],[14,1,14,10],[0,0,0,11],[2,2,2,10],[13,0,13,11]]}
["     "]
[null,"DROP  INLET  CATCH  BASIN TOTALS"]
[null,null,"PAY  ITEMS"]
[null,"SHEET","TYPE 38","TYPE 39","TYPE 40","TYPE 42","TYPE 42","TYPE 43","TYPE 43","TYPE 44","TYPE 44"]
[null,"NO.","611-38.01","611-39.02","611-40.03","611-42.01","611-42.02","611-43.01","611-43.02","611-44.01","611-44.02"]
[null,null,"0' - 4'","0' - 4'","0' - 4''","0' - 4'","4' - 8'","0' - 4''","4' - 8'","0' - 4''","4' - 8'"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"TOTALS",{"$f":"SUM(C7:C12)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]
[null,"To be used with tables named: DROP INLET CATCH BASINS (TABLE NO. 1) Etc."]

{"sheet":"1_4_Catch Basi","index":33,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[17,1,17,10],[14,1,14,10],[1,1,1,10],[0,0,0,11],[2,2,2,10],[13,0,13,11],[15,1,15,10],[16,1,16,10]]}
["     "]
[null,"CATCH BASIN TOTALS"]
[null,null,"PAY  ITEMS"]
[null,"SHEET","TYPE 12","TYPE 12","TYPE 12","TYPE 14","TYPE 14","TYPE 14","TYPE 38","TYPE 38","TYPE 38"]
[null,"NO.","611-12.01","611-12.02","611-12.03","611-14.01","611-14.02","611-14.03","611-38.01","611-38.02","611-38.03"]
[null,null,"0'-4'","4'-8'","8'-12'","0'-4'","4'-8'","8'-12'","0'-4'","4'-8'","8'-12'"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"TOTALS",{"$f":"SUM(C7:C12)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]
[null,"To be used with tables named: CATCH BASINS (TABLE NO. 1) Etc."]

{"sheet":"1_5_Catch Basi","index":34,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":true,"merged":[[64,2,64,19],[63,2,63,19],[62,2,62,19],[61,2,61,10],[0,0,0,20],[1,1,1,19],[2,11,2,19],[59,1,59,10],[60,0,60,20],[3,2,4,2],[3,3,4,3]]}
["     "]
[null,"CATCH BASINS AND MANHOLES"]
[null,null,null,null,null,null,null,null,null,null,null,"PAY  ITEMS"]
[null,"SHEET","LOCATION","STATION","OFFSET","DRAINAGE","GRATE/","INVERT","DEPTH","INSIDE","STANDARD","TYPE 3","TYPE 12","TYPE 12","TYPE 12","TYPE 14","TYPE 14","TYPE 38","TYPE 38","TYPE 38"]
[null,"NO.",null,null,"(FT.)","CODE","TOP","ELEV.","(FT.)","DIM.","DRAWING","611-01.03","611-12.01","611-12.02","611-12.03","611-14.01","611-14.02","611-38.01","611-38.02","611-38.03"]
[null,null,null,null,null,null,"ELEV.",null,null,null,"NO.","8'-12'","0'-4'","4'-8'","8'-12'","0'-4'","4'-8'","0'-4'","4'-8'","8'-12'"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L59)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"PLACED BY SCALE: 18.00"]
[null,null,"If more than one table of CATCH BASINS AND MANHOLES is needed, then make a copy of this table and edit the headers on row 2 as follows:"]
[null,null,"CATCH BASINS AND MANHOLES (TABLE NO. 1)"]
[null,null,"CATCH BASINS AND MANHOLES (TABLE NO. 2) etc."]

{"sheet":"1_6_Catch Basi","index":35,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":true,"merged":[[62,2,62,19],[63,2,63,19],[64,2,64,19],[61,2,61,10],[0,0,0,20],[1,1,1,19],[2,11,2,19],[59,1,59,10],[60,0,60,20],[3,2,4,2],[3,3,4,3]]}
["     "]
[null,"DROP  INLET  CATCH  BASINS"]
[null,null,null,null,null,null,null,null,null,null,null,"PAY  ITEMS"]
[null,"SHEET","LOCATION","STATION","OFFSET","DRAINAGE","GRATE","INVERT","DEPTH","INSIDE","STANDARD","TYPE 38","TYPE 39","TYPE 40","TYPE 42","TYPE 42","TYPE 43","TYPE 43","TYPE 44","TYPE 44"]
[null,"NO.",null,null,"(FT.)","CODE","ELEV.","ELEV.","(FT.)","DIM.","DRAWING","611-38.01","611-39.02","611-40.03","611-42.01","611-42.02","611-43.01","611-43.02","611-44.01","611-44.02"]
[null,null,null,null,null,null,null,null,null,null,"NO.","0' - 4'","0' - 4'","0' - 4''","0' - 4'","4' - 8'","0' - 4''","4' - 8'","0' - 4''","4' - 8'"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L59)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"PLACED BY SCALE: 18.00"]
[null,null,"If more than one table of DROP INLET CATCH BASINS is needed, then make a copy of this table and edit the headers on row 2 as follows:"]
[null,null,"DROP INLET CATCH BASINS (TABLE NO. 1)"]
[null,null,"DROP INLET CATCH BASINS (TABLE NO. 2) etc."]

{"sheet":"1_7_Catch Basi","index":36,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":true,"merged":[[62,1,62,19],[63,1,63,19],[64,1,64,19],[0,0,0,20],[1,1,1,19],[2,11,2,19],[59,1,59,10],[60,0,60,20],[3,2,4,2],[3,3,4,3]]}
["     "]
[null,"CATCH BASINS"]
[null,null,null,null,null,null,null,null,null,null,null,"PAY  ITEMS"]
[null,"SHEET","LOCATION","STATION","OFFSET","DRAINAGE","GRATE","INVERT","DEPTH","INSIDE","STANDARD","TYPE 12","TYPE 12","TYPE 12","TYPE 14","TYPE 14","TYPE 14","TYPE 38","TYPE 38","TYPE 38"]
[null,"NO.",null,null,"(FT.)","CODE","ELEV.","ELEV.","(FT.)","DIM.","DRAWING","611-12.01","611-12.02","611-12.03","611-14.01","611-14.02","611-14.03","611-38.01","611-38.02","611-38.03"]
[null,null,null,null,null,null,null,null,null,null,"NO.","0'-4'","4'-8'","8'-12'","0'-4'","4'-8'","8'-12'","0'-4'","4'-8'","8'-12'"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L59)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"TABLE IS A FULL SHEET WIDE, PLACED BY SCALE: 17.85"]
[null,"If more than one table of CATCH BASINS is needed, then make a copy of this table and edit the headers on row 2 as follows:"]
[null,"CATCH BASINS (TABLE NO. 1)"]
[null,"CATCH BASINS (TABLE NO. 2) etc."]

{"sheet":"1_8_Manhole To","index":37,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[15,1,15,10],[16,1,16,10],[17,1,17,10],[14,1,14,10],[0,0,0,11],[2,2,2,10],[13,0,13,11],[1,1,1,10]]}
["     "]
[null,"MANHOLE TOTALS"]
[null,null,"PAY  ITEMS"]
[null,"STANDARD","TYPE 3","TYPE 3","TYPE 3","TYPE 3","TYPE 3","TYPE 3","TYPE 3","TYPE 38","TYPE 38"]
[null,"DRAWING","611-01-01","611-01-02","611-01-03","611-01-04","611-01-05","611-01-06","611-01-07","611-38.02","611-38.03"]
[null,"NO.","0' - 4'","4' - 8'","8' - 12'","12' - 16'","16' - 20'","20' - 24'","24' - 28'","4'-8'","8'-12'"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"TOTALS",{"$f":"SUM(C7:C12)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]
[null,"To be used with tables named: MANHOLES (TABLE NO. 1) Etc."]

{"sheet":"1_9_Manholes","index":38,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":true,"merged":[[62,1,62,19],[63,1,63,19],[64,1,64,19],[0,0,0,20],[1,1,1,19],[2,11,2,19],[59,1,59,10],[60,0,60,20],[3,2,4,2],[3,3,4,3]]}
["     "]
[null,"MANHOLES"]
[null,null,null,null,null,null,null,null,null,null,null,"PAY  ITEMS"]
[null,"SHEET","LOCATION","STATION","OFFSET","DRAINAGE","GRATE/","INVERT","DEPTH","INSIDE","STANDARD","TYPE 3","TYPE 3","TYPE 3","TYPE 3","TYPE 3","TYPE 3","TYPE 3","TYPE 38","TYPE 38"]
[null,"NO.",null,null,"(FT.)","CODE","TOP","ELEV.","(FT.)","DIM.","DRAWING","611-01-01","611-01-02","611-01-03","611-01-04","611-01-05","611-01-06","611-01-07","611-38.02","611-38.03"]
[null,null,null,null,null,null,"ELEV.",null,null,null,"NO.","0' - 4'","4' - 8'","8' - 12'","12' - 16'","16' - 20'","20' - 24'","24' - 28'","4'-8'","8'-12'"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L59)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"PLACED BY SCALE: 18.00"]
[null,"If more than one table of MANHOLES is needed, then make a copy of this table and edit the headers on row 2 as follows:"]
[null,"MANHOLES (TABLE NO. 1)"]
[null,"MANHOLES (TABLE NO. 2) etc."]

{"sheet":"1_10_Removal Bu","index":39,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,0,0,4],[61,0,61,4],[1,1,1,3],[62,1,62,3],[60,1,60,3]]}
[]
[null,"REMOVAL OF BUILDINGS AND OBSTRUCTIONS DESCRIPTION BLOCK"]
[null,"PAY ITEM","TRACT  NO.","DESCRIPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NO ADDITIONAL COMPENSATION WILL BE MADE FOR THESE REMOVALS."]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"1_11_Removal St","index":40,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,6],[60,0,60,6],[1,1,1,5],[61,1,61,5]]}
[]
[null,"REMOVAL OF STRUCTURES"]
[null,"SHEET NO.","STATION","LOCATION","DESCRIPTION ","REMARKS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["`"]
[]
[]
[]
[]
[]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"1_12_Roadway Ap","index":41,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[11,1,11,8],[0,0,0,9],[8,0,8,9],[1,1,1,8],[2,1,2,8],[9,1,9,8]]}
[]
[null,"ALL COSTS OF THESE ESTIMATED QUANTITIES TO BE INCLUDED"]
[null,"IN PRICE BID FOR ROADWAY APPROACHES ITEM NO. 203-30.01"]
[null,"ROAD & DRAIN.","BORROW",null,"PLACING &","CHANNEL","SEEDING","WATER","SODDING"]
[null,"EXCAVATION","EXCAVATION","WATER","SPREADING","EXCAVATION","W/ MULCH","SEEDING &","(NEW SOD)"]
[null,"(UNCL.)","(UNCL.)",null,"TOPSOIL",null,null,"SODDING"]
[null,"C.Y.","C.Y.","M.G.","C.Y.","C.Y.","UNIT","M.G.","S.Y."]
[]
[]
[null,"NO CHANGE IN COMPENSATION WILL BE MADE FOR NORMAL VARIATIONS IN ESTIMATED QUANTITIES."]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"1_13_Spring Dra","index":42,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,0,15],[18,0,18,15],[1,1,1,14],[2,11,2,14],[17,1,17,4],[3,11,3,14],[19,3,19,10],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10]]}
[]
[null,"SPRING DRAINS"]
[null,null,null,null,null,null,null,"TYPE","TYPE","TYPE","TYPE","REINFORCED CONCRETE PIPE"]
[null,null,null,null,null,null,null,1,"2A","2B","3A","ITEM NO., SIZE & LENGTH (FT.)"]
[null,"STATION","SIDE","LOCATION","STANDARD","OFFSET","DEPTH",null,null,null,null,"CLASS III","CLASS III","CLASS III","CLASS III"]
[null,null,null,null,"DRAWING ","(FT.)","(FT.)","611-02.01","611-02.02","611-02.03","611-02.04","607-03.02","607-05.02","607-06.02","607-07.02"]
[null,null,null,null,"NO.",null,null,"EACH","EACH","EACH","EACH","18\"","24\"","30\"","36\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,{"$f":"SUM(H8:H17)","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"0_2_Project Co","index":43,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,1,1,4],[0,0,0,5],[13,0,13,5],[14,1,14,4]]}
[]
[null,"PROJECT COMMITMENTS"]
[null,"COMMITMENT ID","SOURCE DIVISON","DESCRIPTION","STATION / LOCATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"9_0_Bridge Dec","index":44,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":true,"merged":[[58,0,58,6],[0,0,0,6],[1,1,1,5]]}
[]
[null,"BRIDGE DECK RECOMMENDATIONS (RESURFACING)"]
[null,"BRIDGE","LOCATION","CROSSES","BRIDGE","BRIDGE DECK"]
[null,"NUMBER","LOG MILE","OVER/UNDER","LENGTH","RECOMMENDATIONS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"9_1_Guardrail ","index":45,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,16],[2,11,2,15],[2,5,2,10],[1,1,1,15],[59,1,59,4],[5,1,5,2],[5,3,5,4],[3,11,4,11],[3,12,4,12],[3,13,4,13],[60,0,60,16],[3,14,4,14],[3,15,4,15],[7,3,8,3],[7,4,8,4],[7,1,8,1],[7,2,8,2]]}
[]
["   ","PROPOSED GUARDRAIL (RESURFACING)"]
["   ","      ",null,null,null,"GUARDRAIL",null,null,null,null,null,"TERMINAL ANCHORS"]
["   ",null,null,null,null,"THRIE BEAM","METAL","THRIE BEAM","W BEAM","ROUND","GUARDRAIL","TYPE 12","TYPE 13","IN-LINE","TYPE 38","TYPE 21"]
[null,null,null,null,null,"BRIDGE TRANS.","BEAM","BRIDGE TRANS.","GR","END","REMOVED"]
[null,"SIDE",null,"LOG MILE",null,"MASH TL-3","GUARD","MASH TL-2","(TYPE 2)","ELEMENT",null,null,"MASH TL3","MASH TL3","MASH TL3","MASH TL2"]
["   ",null,null,null,null,"(20.65')","FENCE","(20.65')","MASH TL3",null,null,"(21.875')","(9.375')",null,"(26.896')","(21.875')"]
["   ","LT","RT","FROM","TO","705-01.01","705-01.04","705-06.26","705-06.01","706-10.26","706-01","705-04.02","705-06.10","705-06.11","705-06.20","705-06.30"]
["   ",null,null,null,null,"EACH","(L.F.)","EACH","(L.F.)","(EACH)","(L.F.)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["   ","TOTALS",null,null,null,{"$f":"SUM(F10:F59)","v":0},0,0,0,0,0,0,0,0,0,0]
["                                                                                                                                                                                                                                            "]
[null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"9_2_Storm Drai","index":46,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":true,"merged":[[30,0,30,3],[29,0,29,3],[0,0,0,3],[1,1,1,2],[2,1,2,2],[27,1,27,2],[3,1,3,2]]}
[]
[null,"STORM DRAIN"]
[null,"ADJUSTMENTS"]
[null,"(RESURFACING)"]
[null,"CATCH BASINS","MANHOLES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS"]
[null,{"$f":"SUM(B6:B27)","v":0},{"$f":"SUM(C6:C27)","v":0}]
[]
["PLACED BY SCALE: 18.00"]

{"sheet":"9_3_Traffic Co","index":47,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":true,"merged":[[60,0,60,9],[0,0,0,9],[1,1,1,8]]}
[]
[null,"TRAFFIC CONTROL SIGN TABULATION (RESURFACING)"]
[null,"M.U.T.C.D.",null,null,"SIZE",null,null,"TOTAL","ITEM NO."]
[null,"SIGN","LEGEND \\ DESCRIPTION",null,"IN INCHES",null,"S.F.","NUMBER","712-06"]
[null,"NO.",null,"L","x","W",null,"REQUIRED","S.F."]
[null,null,null,null,null,null,{"$f":"(D6*F6)/144","v":0},0,{"$f":"(G6*H6)","v":0}]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,{"$f":"(D38*F38)/144","v":0},null,{"$f":"(G38*H38)","v":0}]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(I6:I59)","v":0}]
[]
[null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"9_4_Utility Ad","index":48,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":true,"merged":[[30,0,30,4],[0,0,0,4],[1,1,1,3]]}
[]
[null,"UTILITY ADJUSTMENTS (RESURFACING)"]
[null,"TYPE","OWNER","NUMBER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"8_0_Curb Ramps","index":49,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":true,"merged":[[74,1,74,15],[68,0,68,16],[69,4,69,10],[70,1,70,15],[71,1,71,15],[72,1,72,15],[73,1,73,15],[0,0,0,16],[1,1,1,15],[2,1,2,2],[2,3,2,10],[3,1,4,1],[3,2,4,2],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,3,10]]}
[]
[null,"CURB  RAMP  TABULATION"]
[null,"ROADWAY",null,"LOCATION",null,null,null,null,null,null,null,null,"STANDARD","CURB RAMP (RETROFIT)","CURB RAMP (NEW)"]
[null,"MAINLINE","INTERSECTING","STATION  or","LEFT","MEDIAN","RIGHT","QUADRANT",null,null,null,"SIGNALIZED","DRAWING","ITEM NO. 701-02.01","ITEM NO. 701-02.03","REMARKS"]
[null,null,null,"LOG MILE  (L.M.)",null,null,null,"N.","S.","E.","W.","YES / NO","NO.","S.F.","S.F."]
[null,null,null," ",null,null,null," ",null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(N6:N67)","v":0},{"$f":"SUM(O6:O67)","v":0}]
[]
[null,null,null,null,"PLACED BY SCALE: 18.00"]
[null,"SPECIAL NOTES TO DESIGNER:"]
[null,"When adding the curb ramp location, the direction should be read as up station or from beginning to end of the project."]
[null,"The quadrant should be directional.  "]
[null,"Signalized intersections should be noted in the signalized column with an \"X\"."]
[null,"Existing curb ramps that are in compliance should be noted in the remarks column."]

{"sheet":"8_1_OutFalls","index":50,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":true,"merged":[[1,1,1,3],[0,0,0,4],[39,0,39,4],[40,0,45,16383]]}
[]
[null,"OUTFALLS"]
[null,"Outfall No.","Drainage Area","Average Slope"]
[null,1]
[null,{"$f":"B4+1","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[]
["THIS TABLE IS PLACED ON THE LAYOUT SHEETS AND NOT WITH THE TAB BLOCKS. THIS TABLE IS TO BE PLACED BY A SCALE OF 18.00 For a 1:1 Scale Sheet (3\" wide) or PLACED BY A SCALE OF 900 For a 50:1 Scale Sheet (150' wide)."]

{"sheet":"8_2_ROW Marker","index":51,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[[1,1,1,5],[3,2,3,5],[0,0,0,6],[22,0,22,6],[23,1,30,5],[2,2,2,5]]}
[]
[null,"RIGHT  OF  WAY  MARKERS"]
[null,null,"Item #: 708-02.01"]
[null,"SHEET","QUANTITIES"]
[null,"NO.","\"A\"","\"B\"","\"C\"","TOTALS"]
[null,null,null,null,null,{"$f":"SUM(C6:E6)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"TOTALS",{"$f":"SUM(C6:C20)","v":0},null,{"$f":"SUM(E6:E20)","v":0},{"$f":"SUM(F6:F20)","v":0}]
[null,0]
[]
[null,"THIS TABLE IS TO BE PLACED BY A SCALE OF 18.00 for a 1:1 Scale Sheet (6.22\" wide) or PLACED BY A SCALE OF 900 For a 50:1 Scale Sheet (310.92' wide)."]

{"sheet":"8_3_Slope Reha","index":52,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":true,"merged":[[21,7,21,11],[19,1,19,7],[20,0,20,15],[0,0,0,15],[1,1,1,14],[3,1,3,2],[2,5,2,7],[3,5,3,7]]}
[]
["   ","TABULATION OF SLOPE REHABILITATION"]
["   ",null,null,"      ",null,"AREA QUANTITIES",null,null,null,"         ","          ","EROSION"]
["   ","  LOG MILE  ",null,"SIDE",null,"ARE BASED ON",null,null,"RIP-RAP",null,"WATER","CONTROL",null," WATER  ","REMARKS"]
["   ",null,null,null,null,"LENGTH","WIDTH","DEPTH","DITCH","BORROW","(EMB.)","MATTING","SEEDING","(SEEDING)","                      "]
["   "," FROM ","TO  ","LT","RT","(FT.)","(FT.)","(FT.)","(C. Y.)","(C. Y.)","(M. G.)","(SQ. YD.)","(UNIT)","(M. G.)","                      "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["   ","TOTALS",null,null,null,null,null,null,{"$f":"SUM(I7:I19)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"8_4_Trees","index":53,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":true,"merged":[[66,0,66,10],[0,0,0,10],[5,12,5,23]]}
[]
[null,"ESTIMATED TREE QUANTITIES"]
[null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"7_0_Rip Rap Ba","index":54,"n_rows":62,"n_cols":30,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,30],[60,0,60,16383],[59,1,59,26],[1,1,1,29],[61,1,61,4]]}
[]
["   ","RIPRAP BASIN LOCATIONS,  DIMENSIONS  AND QUANTITIES"]
["   ","LOCATION",null,null,null,"CULVERT OUTLET",null,null,"BASIN DIMENSIONS (FT.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIPRAP DEPTHS (FT.)",null,null,null,"GEOTEXTILE","RIP-RAP","RIP-RAP"]
["   ","           ","OFFSET",null,null,"        ","        ","        ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ",null,"      ","      ","      ","FABRIC","CLASS A-1","CLASS A-2"]
["   ","STATION","DISTANCE","DIRECTION",null,"NO. OF","SIZE","LENGTH","W1","W2","W3","W4","W5","W6","W7","W8","H1","H2","L1","L2","L3","L4","L5","D1","D2","D3","D4","(S.Y.)","(TON)","(TON)"]
["   ","           ","(FT.)","LT","RT","BBLS.","        ","(FT.)","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      ","      "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["   "," TOTALS                                                                                                                                                                                   ",null,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":"SUM(AB7:AB59)","v":0},{"$f":"SUM(AC7:AC59)","v":0},{"$f":"SUM(AD7:AD59)","v":0}]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"7_1_Rip Rap Di","index":55,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":true,"merged":[[59,1,59,5],[61,1,61,2],[0,0,0,12],[60,0,60,12],[1,1,1,11],[2,2,3,3],[4,2,5,2],[4,3,5,3],[2,1,5,1],[2,6,2,9],[2,4,5,4]]}
[]
[null,"RIPRAP DITCHES"]
[null,"ROADWAY","STATION",null,"SIDE",null,"MACHINED RIPRAP",null,null,null,"SEEDING","SODDING"]
[null,null,null,null,null,"DETAIL","CLASS A3","CLASS A1","CLASS A2","CLASS B","WITH MULCH","NEW SOD"]
[null,null,"FROM","TO",null,"NO.","709-05.05","709-05.06","709-05.07","709-05.08","801-01","803-01"]
[null,null,null,null,null,null,"(C.Y.)","(C.Y.)","(C.Y.)","(C.Y.)","(S.Y.)","(S.Y.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,{"$f":"SUM(G7:G59)","v":0},0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"7_2_Sediment D","index":56,"n_rows":62,"n_cols":45,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,45],[1,1,1,44],[2,7,2,19],[2,20,2,25],[2,26,2,40],[2,41,2,44],[61,7,61,12],[60,0,60,45],[3,26,3,30],[3,31,3,35],[3,36,3,40],[3,41,3,44],[4,34,4,35],[5,34,5,35]]}
[]
[null,"SUMMARY  OF  SEDIMENT  BASINS,  TRAPS,  AND  DAMS  DIMENSIONS"]
[null,null,null,null,null,null,null,"DIMENSIONS (FT.)",null,null,null,null,null,null,null,null,null,null,null,null,"DAM DIMENSIONS (FT.)",null,null,null,null,null,"PRINCIPAL SPILLWAY DIMENSIONS (FT.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EMERGENCY SPILLWAY"]
[null,null,null,null,null,"INFLOW","MAXIMUM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RISER",null,null,null,null,"OUTLET PIPE",null,null,null,null,"OUTLET DITCH",null,null,null,null,"DIMENSIONS (FT.)"]
[null,"STATION","DIR","DISTANCE","SHAPE","Q 25","SEDIMENT","W","L","Sb","D1","E1","D2","E2","D3","E3","D4","D5","D6","E6","D","Wo","Zp","Zf","Etd","Es",null,null,null,"DEWATERING",null,null,null,null,"INVERT"]
[null,null,null,"(FT.)","NO.","(CFS)","VOL (CY)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2","Dr","Lr","OUTLET",null,"Dp","Lp","Sp","ELEVATION",null,"Xo","Yo","Do","Zo","So","B","Hs","Ls","Z7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(cfs)",null,null,"SIZE","NO.",null,null,null,"IN","OUT",null,null,null,null,null,null," "," "," "]
[]
[null,null,null,null,null," ",null," "]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," ",null," "]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"7_3_Sediment D","index":57,"n_rows":62,"n_cols":21,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,4,61,6],[1,1,1,20],[59,1,59,3],[0,0,0,21],[60,0,60,21],[2,4,2,20]]}
[]
[null,"SUMMARY OF ESTIMATED QUANTITIES FOR SEDIMENT BASINS, TRAPS, AND DAMS"]
[null,null,null,null,"ESTIMATED QUANTITY ITEMS"]
[null,null,null,null,"203-01","209-05","209-03","209-10.20","209-11.0X","209-11.0X","209-11.0X","209-11.20","303-10.01","607-37.0X","607-37.0X","607-37.0X","709-05.06","709-05.07","740-10.03","740-10.04","805-13.03"]
[null,null,null,null,"ROAD AND","SEDIMENT","CHECK","TEMPORARY","SEDIMENT","SEDIMENT","SEDIMENT","SEDIMENT","MINERAL","XX \"","XX \"","XX \"","MACHINED","MACHINED","GEOTEXTILE","GEOTEXTILE","FLEXIBLE"]
[null,"STATION","DIR","DISTANCE","DRAINAGE","REMOVAL","DAMS","SEDIMENT","BASIN","BASIN","BASIN","BASIN","AGGREGATE","C.M. PIPE","C.M. PIPE","C.M. PIPE","RIP-RAP","RIP-RAP","( TYPE III )","( TYPE IV )","CHANNEL"]
[null,null,null,"(FT.)","EXCAVATION",null,null,"TRAP","RISER","RISER","RISER","BAFFLES","(SIZE 57)","CULVERT","CULVERT","CULVERT","(CLASS A-1)","(CLASS A-2)","EROSION","(STABILIZE)","LINER"]
[null,null,null,null,null,null,null,null,"(___\")","(___\")","(___\")",null,null,null,null,null,null,null,"CONTROL",null,"( CLASS III )"]
[null,null,null,null,"(C.Y.)","(C.Y.)","(S.F.)","(C.Y.)","(EACH)","(EACH)","(EACH)","(L.F.)","(TON)","(L.F.)","(L.F.)","(L.F.)","(TON)","(TON)","(S.Y.)","(S.Y.)","(S.Y.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,{"$f":"SUM(E10:E59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"7_4_Special Di","index":58,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,13],[60,0,60,13],[1,1,1,12],[2,2,3,3],[2,6,2,8],[4,2,5,2],[4,3,5,3],[2,1,5,1],[2,4,5,4],[59,1,59,8]]}
[]
[null,"SPECIAL DITCHES"]
[null,"ROADWAY","STATION",null,"SIDE",null,"CONFIGURATION",null,null,"CLASS A","SEEDING","SEEDING","SODDING"]
[null,null,null,null,null,"DETAIL",null,"BOTTOM",null,"CONC.","WITH MULCH","W/O MULCH","NEW SOD"]
[null,null,"FROM","TO",null,"NO.","FORE","WIDTH","BACK","604-01.01","801-01","801-02","803-01"]
[null,null,null,null,null,null,"(H/V)","(FT.)","(H/V)","(C.Y.)","(UNITS)","(UNITS)","(S.Y.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,null,{"$f":"SUM(J7:J59)","v":0},{"$f":"SUM(K7:K59)","v":0},{"$f":"SUM(L7:L59)","v":0},{"$f":"SUM(M7:M59)","v":0}]
[]
[null,"PLACED BY SCALE: 18"]

{"sheet":"7_5_Erosion Co","index":59,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,10],[66,0,66,10],[5,12,5,23]]}
[]
[null,"TABULATED EPSC QUANTITIES"]
[null,null,null,null,null,"STAGE II","STAGE III","STAGE II","STAGE V","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"6_0_Pavement L","index":60,"n_rows":62,"n_cols":37,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,1,61,13],[6,35,7,35],[6,36,7,36],[0,0,0,37],[60,0,60,37],[5,18,5,19],[59,1,59,2],[1,1,1,36],[4,28,4,30],[4,24,4,27],[4,21,4,23],[3,21,3,31],[2,3,2,31],[2,35,2,36],[3,18,4,19],[3,20,4,20],[2,2,7,2],[3,4,3,17],[4,4,4,7],[4,8,4,11],[4,12,4,15],[4,16,4,17],[2,32,2,34],[6,32,7,32],[6,33,7,33],[6,34,7,34],[6,3,7,3],[6,18,7,18],[6,19,7,19],[6,20,7,20]]}
[]
["   ","PAVEMENT QUANTITIES"]
[null,null,"ALTERNATE","TYPE  -  GRADE  -  PAY  ITEM  (TON)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLD PLANING",null,null,"CONCRETE (S.Y.)"]
["   ","       ",null,"MINERAL","BITUMINOUS PLANT MIX BASE (HOT MIX)",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIME",null,"TACK","ASPHALTIC CONCRETE SURFACE (HOT MIX)",null,null,null,null,null,null,null,null,null,null,null,"BITUMINOUS PLANT",null,"TREATED","CONCRETE"]
["   ","LOCATION",null,"AGG.","PG-64-22",null,null,null,"PG-70-22",null,null,null,"PG-76-22",null,null,null,"PG-82-22",null,null,null,null,"PG-64-22",null,null,"PG 70-22",null,null,null,"PG 76-22",null,null,"PG 82-22",null,"MIX",null,"PERMEABLE","PAVEMENT"]
["   ","   (ROADWAY)    ",null,"D","A","A-S","B-M","B-M2","A","A-S","B-M","B-M2","A","A-S","B-M","B-M2","A","B-M2","COAT",null,"COAT","D","E","TL","D","E","OGFC","TL","D","OGFC","TL","D","TON","S.Y.","C.Y.","BASE","xx\""]
["   ",null,null,"303-01","307-","307-","307-","307-","307-","307-","307-","307-","307-","307-","307-","307-","307-","307-","402-01","402-02","403-01","411-","411-","411-","411-","411-","411-","411-","411-","411-","411-"," 411-","415-01.01","415-01.02","415-01.03","313-03","501-01.0x"]
[null,null,null,null,"01.01","01.20","01.07","01.08","02.01","01.21","02.21","02.08","03.01","01.22","03.07","03.08","04.01","04.08",null,null,null,"01.10","01.07","03.07","02.10","02.11","03.22","03.08","03.10","03.23","03.09","04.10"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["   ","TOTALS",null,{"$f":"SUM(D9:D59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"6_1_Pavement S","index":61,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":true,"merged":[[1,1,1,16],[6,2,7,2],[6,7,7,7],[6,8,7,8],[6,9,7,9],[4,3,4,6],[2,2,2,13],[2,14,2,16],[3,14,3,16],[4,14,4,16],[61,1,61,16],[3,3,3,6],[4,7,4,8],[3,7,3,8],[60,0,60,17],[6,14,7,14],[6,15,7,15],[6,16,7,16],[3,10,3,13],[4,10,4,13]]}
[]
["   ","PAVEMENT QUANTITIES"]
[null,null,"TYPE  -  GRADE  -  PAY  ITEM  (TON)",null,null,null,null,null,null,null,null,null,null,null,"COLD PLANING"]
["   ","       ","MINERAL","BITUMINOUS PLANT MIX",null,null,null,"PRIME",null,"TACK","ASPHALTIC CONCRETE",null,null,null,"BITUMINOUS PLANT"]
["   ","LOCATION","AGG.","BASE (HOT MIX)",null,null,null,"COAT",null,"COAT","SURFACE (HOT MIX)",null,null,null,"MIX"]
["   ","   (ROADWAY)    ","D","A","A-S","B-M","B-M2",null,null,null,"D","E",null,null,"TON","S.Y.","C.Y."]
["   ",null,"303-01","307-","307-","307-","307-","402-01","402-02","403-01","411-","411-","411-","411-","415-01.01","415-01.02","415-01.03"]
[null,null,null,"01.01","01.20","01.07","01.08",null,null,null,"01.10","01.07","xx.xx","xx.xx"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["   ","TOTALS",{"$f":"SUM(C9:C59)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,0]
[]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"6_2_Traffic Co","index":62,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":true,"merged":[[66,0,66,10],[0,0,0,10],[5,12,5,23]]}
[]
[null,"TABULATED TRAFFIC CONTROL QUANTITIES"]
[null,null,null,null,null,"PHASE II","PHASE III","PHASE II","PHASE V","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY","QUANTITY"]
[null,null,null,null,{"$f":"'Project Data '!B2","v":0},{"$f":"'Project Data '!C2","v":0},{"$f":"'Project Data '!D2","v":0},{"$f":"'Project Data '!E2","v":0},{"$f":"'Project Data '!F2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"6_3_Traffic Co","index":63,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":true,"merged":[[60,0,60,16],[0,0,0,16],[1,1,1,15],[61,4,61,10]]}
[]
[null,"TRAFFIC  CONTROL  SIGN  TABULATION"]
[null,"M.U.T.C.D.",null,null,"SIZE",null,null,"NO.","NO.","NO.","NO.","NO.","TOTAL","ITEM NO.","STANDARD"]
[null,"SIGN NO.","LEGEND",null,"IN INCHES",null,"S.F.","REQUIRED","REQUIRED","REQUIRED","REQUIRED","REQUIRED","NO.","712-06","DRAWING","REMARKS"]
[null,null,null,"L","X","W",null,"PHASE I","PHASE II","PHASE III","PHASE IV","PHASE V","REQUIRED","S.F.","NO."]
[null,null,null,null,null,null,{"$f":"(D6*F6)/144","v":0},null,null,null,null,null,{"$f":"IF(OR(H6=\"\",H6>\"0\"),\"\",(MAX(H6,I6,J6,K6,L6)))","v":""},{"$f":"IFERROR(IF(OR(G6=\"\",G6>\"0\"),\"\",(G6*M6)),0)","v":0}]
[null,null,null,null,null,null,{"$f":"(D7*F7)/144","v":0},null,null,null,null,null,"",{"$f":"IFERROR(IF(OR(G7=\"\",G7>\"0\"),\"\",(G7*M7)),0)","v":0}]
[null,null,null,null,null,null,{"$f":"(D8*F8)/144","v":0},null,null,null,null,null,"",0]
[null,null,null,null,null,null,{"$f":"(D9*F9)/144","v":0},null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,{"$f":"(D38*F38)/144","v":0},null,null,null,null,null,{"$f":"IF(OR(H38=\"\",H38>\"0\"),\"\",(MAX(H38,I38,J38,K38,L38)))","v":""},0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,0,null,null,null,null,null,"",0]
[null,null,null,null,null,null,{"$f":"(D59*F59)/144","v":0},null,null,null,null,null,"",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(N6:N59)","v":0},"S.F."]
[]
[null,null,null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"5_0_Concrete B","index":64,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":true,"merged":[[6,6,7,6],[31,1,31,6],[30,0,30,15],[0,0,0,15],[5,1,7,1],[2,12,2,13],[29,1,29,6],[1,1,1,14],[6,3,7,3],[6,4,7,4],[6,5,7,5]]}
[]
["   ","PROPOSED  CONCRETE  BARRIER  WALL  AND  MEDIAN  BARRIER  WALL"]
["   ","       ","                  ",null,null,null,null,"32 IN","51 IN","SINGLE SLOPE","FLARED","GRADE","RELATED  ITEMS",null,"                     "]
["   ",null,"                  ",null,null,null,null,"SINGLE SLOPE","SINGLE SLOPE","HALF","SINGLE SLOPE","SEPARATED","CONCRETE","MINERAL"]
["   ","SHEET","LOCATION","SIDE",null,"STATION",null,"CONCRETE","CONCRETE","CONCRETE","CONCRETE MEDIAN","SINGE SLOPE","SIDEWALK","AGGREGATE","REMARKS"]
["   ","NO.","                  ","      ",null,"           ",null,"BARRIER WALL","BARRIER WALL","BARRIER WALL","BARRIER WALL","MEDIAN WALL","(4\" THICK)","SIZE 57"]
["   ",null,"                  ","LT","RT","FROM","TO","711-05.70","711-05.71","711-05.72","711-05.77","711-05.78","701-01.01","303-10.01"]
["   ",null,"                  ",null,null,null,null,"(L.F.)","(L.F.)","(L.F.)","(L.F.)","(L.F.)","(S.F.)","(TON)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["   ","TOTALS",null,null,null,null,null,{"$f":"SUM(H9:H29)","v":0},0,0,0,0,0,0]
["                                                                                                                                                                                                                                            "]
[null,"PLACED BY SCALE: 18.00"]

{"sheet":"5_1_Guardrail ","index":65,"n_rows":62,"n_cols":26,"rows_kept":62,"cut":false,"hidden":true,"merged":[[60,0,60,26],[0,0,0,26],[2,23,2,24],[2,16,2,20],[2,7,2,15],[1,1,1,25],[59,1,59,6],[3,10,3,11],[5,3,5,4],[3,24,4,24],[7,5,8,5],[7,6,8,6],[7,3,8,3],[7,4,8,4],[2,21,2,22],[5,5,5,6],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20]]}
[]
["   ","PROPOSED GUARDRAIL"]
["   ","       ","                  ","      ",null,null,null,"GUARDRAIL",null,null,null,null,null,null,null,null,"TERMINAL ANCHORS",null,null,null,null,"GUARDRAIL FOOTING",null,"CABLE BARRIER"]
["   ",null,"                  ",null,null,null,null,"THRIE BEAM","METAL","THRIE BEAM","MEDIAN DIVIDER",null,"W BEAM","MICHIGAN","ROUND","GUARDRAIL","TYPE 12","TYPE 13","IN-LINE","TYPE 38","TYPE 21","CLASS A","STEEL BAR","LONG-","TERMINAL"]
[null,"SHEET",null,null,null,null,null,"BRIDGE TRAN.","BEAM","BRIDGE TRAN.","WITH","AT CONC.","GR","END","END","REOMOVED",null,null,null,null,null,"CONCRETE","REINF.","ITUDINAL"]
[null,null,"LOCATION","SIDE",null,"STATIONS",null,"MASH TL-3","GUARD","MASH TL-2","RUB-RAIL","BARRIER","(TYPE 2)","SHOE","ELEMENT",null,null,"MASH TL3","MASH TL3","MASH TL3","MASH TL2","(ROADWAY)","(ROADWAY)",null,null,"REMARKS"]
["   ","NO.",null,null,null,null,null,"(20.65')","FENCE","(20.65')","(TYPE 2)","(26.896')","MASH TL3",null,null,null,"VARIES","(9.375')",null,"(46.875')","(21.875')"]
["   ",null,"                  ","LT","RT","FROM","TO","705-06.25","705-01.04","705-06.26"," 705-03.01","705-03.04","705-06.01","706-10.80","706-10.26","706-01","705-04.02","705-06.10","705-06.11","705-06.20","705-06.30","604-01.01","604-01.02","705-80.01","705-80.18","  "]
["   ","       ","                  ",null,null,null,null,"EACH","(L.F.)","EACH","(L.F.)","(L.F.)","(L.F.)","(EACH)","(EACH)","(L.F.)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(C.Y.)","(LB.)","(L.F.)","(EACH)","                     "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["   ","TOTALS",null,null,null,null,null,{"$f":"SUM(H10:H59)","v":0},0,0,0,0,0,{"$f":"SUM(N10:N59)","v":0},null,0,0,0,0,0,0,0,0,0,0]
["                                                                                                                                                                                                                                            "]
[null,null,"PLACED BY SCALE: 18.00"]

{"sheet":"4_0_Storm Drai","index":66,"n_rows":17,"n_cols":23,"rows_kept":17,"cut":false,"hidden":true,"merged":[[16,1,16,22],[15,1,15,5],[14,0,14,23],[0,0,0,23],[2,5,2,22],[2,3,2,4],[1,1,1,22]]}
[]
[null,"STORM DRAIN ENDWALL TOTALS"]
[null,null,"RIP-RAP","PROTECTED ENDWALLS",null,"SAFETY ENDWALLS  (  ITEM NO. 611-07.54 THRU  611-07.71 SERIES )"]
[null,null,"CLASS","CLASS \"A\"","STEEL BAR","18 IN.","18 IN.","18 IN.","24\" IN.","24\" IN.","24\" IN.","30\" IN.","30\" IN.","30\" IN.","36\" IN.","36\" IN.","36\" IN.","42\" IN.","42\" IN.","42\" IN.","48\" IN.","48\" IN.","48\" IN."]
[null,"TABLE","\"??\"","CONCRETE","REINFORCING","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1"]
[null,"NO.","709-05.xx","611-07.01","611-07.02","07.54","07.55","07.56","07.57","07.58","07.59","07.60","07.61","07.62","07.63","07.64","07.65","07.66","07.67","07.68","07.69","07.70","07.71"]
[null,null,"(TON)","(C.Y.)","(LB.)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"TOTALS",{"$f":"SUM(C8:C13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]
[null,"To be used with tables named: STORM DRAIN ENDWALLS (TABLE NO. 1) Etc."]

{"sheet":"4_1_Storm Drai","index":67,"n_rows":65,"n_cols":29,"rows_kept":65,"cut":false,"hidden":true,"merged":[[64,1,64,10],[62,1,62,18],[61,5,61,11],[60,0,60,29],[59,1,59,7],[1,1,1,28],[0,0,0,29],[2,11,2,28],[2,9,2,10],[63,1,63,10]]}
[]
[null,"STORM DRAIN ENDWALLS"]
[null,null,null,null,null,null,null,null,"RIP-RAP","PROTECTED ENDWALLS",null,"SAFETY ENDWALLS  (  ITEM NO. 611-07.54 THRU  611-07.71 SERIES )"]
[null,null,null,null,null,null,null,null,"CLASS","CLASS \"A\"","STEEL BAR","18 IN.","18 IN.","18 IN.","24\" IN.","24\" IN.","24\" IN.","30\" IN.","30\" IN.","30\" IN.","36\" IN.","36\" IN.","36\" IN.","42\" IN.","42\" IN.","42\" IN.","48\" IN.","48\" IN.","48\" IN."]
[null,"LOCATION \\ SHEET NO.","STATION","OFFSET","SKEW","CODE","TYPE","STANDARD","\"??\"","CONCRETE","REINFORCING","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1","3:1","4:1","6:1"]
[null,null,null,"(FT.)",null,null,null,"DRAWING","709-05.xx","611-07.01","611-07.02","07.54","07.55","07.56","07.57","07.58","07.59","07.60","07.61","07.62","07.63","07.64","07.65","07.66","07.67","07.68","07.69","07.70","07.71"]
[null,null,null,null,null,null,null,"NO.","(TON)","(C.Y.)","(LB.)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)","(EACH)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS",null,null,null,null,null,null,{"$f":"SUM(I8:I59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"PLACED BY SCALE: 18.00"]
[null,"If more than one table of STORM DRAIN ENDWALLS is needed, then make a copy of this table and edit the headers on row 2 as follows:"]
[null,"STORM DRAIN ENDWALLS (TABLE NO. 1)"]
[null,"STORM DRAIN ENDWALLS (TABLE NO. 2) etc."]

{"sheet":"4_2_Storm Drai","index":68,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,0,0,9],[13,0,13,9],[2,2,2,8],[1,1,1,8],[17,1,17,8],[16,1,16,8],[14,1,14,8],[15,1,15,8]]}
["             "]
[null,"STORM DRAINAGE PIPE TOTALS"]
[null,null,"REINFORCED CONCRETE PIPE - CLASS, ITEM NO., SIZE & LENGTH (FT.)"]
[null,"TABLE",null,"CLASS III","CLASS III","CLASS III","CLASS III","CLASS III"]
[null,"NO.",null,"607-03.02","607-05.02","607-06.02","607-07.02","607-08.02"]
[null,null,null,"18\"","24\"","30\"","36\"","42\""]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"TOTALS",{"$f":"SUM(C7:C12)","v":0},0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]
[null,"To be used with tables named: STORM DRAINAGE PIPES (TABLE NO. 1) Etc."]

{"sheet":"4_3_Storm Drai","index":69,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":true,"merged":[[0,0,0,14],[60,0,60,14],[2,7,2,13],[59,1,59,6],[2,2,3,3],[2,4,3,5],[63,1,63,13],[64,1,64,13],[62,0,62,14],[61,1,61,13],[1,1,1,13]]}
["             "]
[null,"STORM DRAINAGE PIPES"]
[null,null,"INLET",null,"OUTLET",null,null,"REINFORCED CONCRETE PIPE - CLASS, ITEM NO., SIZE & LENGTH (FT.)"]
[null,"SHEET",null,null,null,null,"%",null,"CLASS III","CLASS III","CLASS III","CLASS III","CLASS III"]
[null,"NO.","CODE","OUTLET","CODE","INLET","GRADE",null,"607-03.02","607-05.02","607-06.02","607-07.02","607-08.02"]
[null,null,"NO.","ELEV.","NO.","ELEV.",null,null,"18\"","24\"","30\"","36\"","42\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[null,"TOTALS",null,null,null,null,null,{"$f":"SUM(H7:H59)","v":0},0,0,0,0,0,0]
[]
[null,"PLACED BY SCALE: 18.00"]
["If more than one table of STORM DRAINAGE PIPES is need, then make a copy of this table and edit the headers on row 2 as follows:"]
[null,"STORM DRAINAGE PIPES (TABLE NO. 1)"]
[null,"STORM DRAINAGE PIPES (TABLE NO. 2) etc."]

{"sheet":"12_0_Blank Work","index":70,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}