{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Project Records Checklist","Scratch"],"read":"whole","date_system":"1900"}

{"sheet":"Project Records Checklist","index":0,"n_rows":252,"n_cols":4,"rows_kept":252,"merged":[[1,1,1,3]]}
[]
[null,"MATERIAL PROJECT RECORDS CHECKLIST"]
[{"$nulls":3},"July  2019"]
[null,"Section 106: Control of Materials"]
[{"$nulls":3},"source of materials"]
[]
[null,"Section 206: Excavation for Structures"]
[null,null,"206.1000","EXCAVATION FOR STRUCTURES BRIDGES (STRUCTURE)"]
[{"$nulls":3},{"$f":"IF(Scratch!B8=TRUE,Scratch!D9,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B8=TRUE,Scratch!D10,\"\")","v":""}]
[null,null,"206.1050.S","UNDERWATER FOUNDATION INSPECTION"]
[{"$nulls":3},{"$f":"IF(Scratch!B12=TRUE,Scratch!D13,\"\")","v":""}]
[null,null,"206.2000","EXCAVATION FOR STRUCTURES CULVERTS (STRUCTURE)"]
[{"$nulls":3},{"$f":"IF(Scratch!B15=TRUE,Scratch!D16,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B15=TRUE,Scratch!D17,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B15=TRUE,Scratch!D18,\"\")","v":""}]
[null,null,"206.3000","EXCAVATION FOR STRUCTURES RETAINING WALLS (STRUCTURE)"]
[null,null,"206.4000","EXCAVATION FOR STRUCTURES STRUCTURAL PLATE PIPE OR PIPE ARCHES (STATION)"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B20,Scratch!B24)=TRUE,Scratch!D21,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B20,Scratch!B24)=TRUE,Scratch!D22,\"\")","v":""}]
[null,null,"206.5000","COFFERDAMS (STRUCTURE)"]
[{"$nulls":3},{"$f":"IF(Scratch!B28=TRUE,Scratch!D29,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B28=TRUE,Scratch!D30,\"\")","v":""}]
[]
[null,"Section 511: Temporary Shoring"]
[null,null,"511.1100","TEMPORARY SHORING"]
[null,null,"511.1200","TEMPORARY SHORING (STRUCTURE)"]
[null,null,"511.1300","TEMPORARY SHORING (LOCATION)"]
[null,null,"511.2200","TEMPORARY SHORING LEFT IN PLACE (STRUCTURE)"]
[null,null,"511.2300","TEMPORARY SHORING LEFT IN PLACE (LOCATION)"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B33,Scratch!B36,Scratch!B39,Scratch!B42,Scratch!B45)=TRUE,Scratch!D34,\"\")","v":""}]
[]
[null,"Section 526: Temporary Structures"]
[null,null,"526.0100","TEMPORARY STRUCTURE (STATION)"]
[{"$nulls":3},{"$f":"IF(Scratch!B49=TRUE,Scratch!D50,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B49=TRUE,Scratch!D51,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B49=TRUE,Scratch!D52,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B49=TRUE,Scratch!D53,\"\")","v":""}]
[null,null,"526.0200.S","TEMPORARY PEDESTRIAN STRUCTURE (STATION)"]
[{"$nulls":3},{"$f":"IF(Scratch!B55=TRUE,Scratch!D56,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B55=TRUE,Scratch!D57,\"\")","v":""}]
[]
[null,"Section 618: Maintenance and Repair of Haul Roads"]
[null,null,"618.0100","MAINTENANCE AND REPAIR OF HAUL ROADS (PROJECT)"]
[{"$nulls":3},{"$f":"IF(Scratch!B60=TRUE,Scratch!D61,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B60=TRUE,Scratch!D62,\"\")","v":""}]
[]
[null,"Section 623: Dust Control Surface Treatment"]
[null,null,"623.0200","DUST CONTROL SURFACE TREATMENT"]
[{"$nulls":3},{"$f":"IF(Scratch!B65=TRUE,Scratch!D66,\"\")","v":""}]
[]
[null,"Section 624: Water"]
[null,null,"624.0100","WATER"]
[{"$nulls":3},{"$f":"IF(Scratch!B69=TRUE,Scratch!D70,\"\")","v":""}]
[]
[null,"Section 625: Topsoil and Salvaged Topsoil"]
[null,null,"625.0100","TOPSOIL (SY)"]
[null,null,"625.0105","TOPSOIL (CY)"]
[null,null,"625.0500","SALVAGED TOPSOIL"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B73,Scratch!B77,Scratch!B81)=TRUE,Scratch!D74,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B73,Scratch!B77,Scratch!B81)=TRUE,Scratch!D75,\"\")","v":""}]
[]
[null,"Section 626: Peat Humus"]
[null,null,"626.0200","PEAT HUMUS"]
[{"$nulls":3},{"$f":"IF(Scratch!B85=TRUE,Scratch!D86,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B85=TRUE,Scratch!D87,\"\")","v":""}]
[]
[null,"Section 627: Mulching"]
[null,null,"627.0200","MULCHING (SY)"]
[null,null,"627.0205","MULCHING (TON)"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B90,Scratch!B96)=TRUE,Scratch!D91,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B90,Scratch!B96)=TRUE,Scratch!D92,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B90,Scratch!B96)=TRUE,Scratch!D93,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B90,Scratch!B96)=TRUE,Scratch!D94,\"\")","v":""}]
[]
[null,"Section 628: Erosion Control"]
[null,null,"628.1104","EROSION BALES"]
[{"$nulls":3},{"$f":"IF(Scratch!B108=TRUE,Scratch!D109,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B108=TRUE,Scratch!D110,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B108=TRUE,Scratch!D111,\"\")","v":""}]
[null,null,"628.1504","SILT FENCE"]
[{"$nulls":3},{"$f":"IF(Scratch!B113=TRUE,Scratch!D114,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B113=TRUE,Scratch!D115,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B113=TRUE,Scratch!D116,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B113=TRUE,Scratch!D117,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B113=TRUE,Scratch!D118,\"\")","v":""}]
[null,null,"628.1520","SILT FENCE MAINTENANCE"]
[{"$nulls":3},{"$f":"IF(Scratch!B120=TRUE,Scratch!D121,\"\")","v":""}]
[null,null,"628.1550","SILT SCREEN"]
[{"$nulls":3},{"$f":"IF(Scratch!B123=TRUE,Scratch!D124,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B123=TRUE,Scratch!D125,\"\")","v":""}]
[null,null,"628.1905","MOBILIZATIONS EROSION CONTROL"]
[{"$nulls":3},{"$f":"IF(Scratch!B127=TRUE,Scratch!D128,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B127=TRUE,Scratch!D129,\"\")","v":""}]
[null,null,"628.1910","MOBILIZATIONS EMERGENCY EROSION CONTROL"]
[null,null,"628.1920","CLEANING SEDIMENT BASINS"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B131,Scratch!B134)=TRUE,Scratch!D132,\"\")","v":""}]
[null,null,"628.2000 - 2099","EROSION MAT (CLASS) (TYPE)"]
[{"$nulls":3},{"$f":"IF(Scratch!B137=TRUE,Scratch!D138,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B137=TRUE,Scratch!D139,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B137=TRUE,Scratch!D140,\"\")","v":""}]
[null,null,"628.5505","POLYETHYLENE SHEETING"]
[{"$nulls":3},{"$f":"IF(Scratch!B142=TRUE,Scratch!D143,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B142=TRUE,Scratch!D144,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B142=TRUE,Scratch!D145,\"\")","v":""}]
[null,null,"628.6005","TURBIDITY BARRIERS"]
[{"$nulls":3},{"$f":"IF(Scratch!B147=TRUE,Scratch!D148,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B147=TRUE,Scratch!D149,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B147=TRUE,Scratch!D150,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B147=TRUE,Scratch!D145,\"\")","v":""}]
[null,null,"628.6500 - 6599","SOIL STABILIZER (TYPE)"]
[null,null,"628.7000 - 7099","INLET PROTECTION (TYPE)"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B153,Scratch!B156)=TRUE,Scratch!D154,\"\")","v":""}]
[null,null,"628.7504","TEMPORARY DITCH CHECKS"]
[{"$nulls":3},{"$f":"IF(Scratch!B159=TRUE,Scratch!D160,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B159=TRUE,Scratch!D161,\"\")","v":""}]
[null,null,"628.7515.S","STONE OR ROCK DITCH CHECKS"]
[{"$nulls":3},{"$f":"IF(Scratch!B163=TRUE,Scratch!D164,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B163=TRUE,Scratch!D165,\"\")","v":""}]
[null,null,"628.7555","CULVERT PIPE CHECKS"]
[null,null,"628.7560","TRACKING PADS"]
[null,null,"628.7570","ROCK BAGS"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B167,Scratch!B171,Scratch!B178)=TRUE,Scratch!D168,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B167,Scratch!B171,Scratch!B178)=TRUE,Scratch!D169,\"\")","v":""}]
[]
[null,"Section 629: Fertilizer and Agricultural Limestone"]
[null,null,"629.0200 - 0299","FERTILIZER (TYPE)"]
[{"$nulls":3},{"$f":"IF(Scratch!B186=TRUE,Scratch!D187,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B186=TRUE,Scratch!D188,\"\")","v":""}]
[null,null,"629.1100","AGRICULTURAL LIMESTONE TREATMENT"]
[{"$nulls":3},{"$f":"IF(Scratch!B190=TRUE,Scratch!D191,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B190=TRUE,Scratch!D192,\"\")","v":""}]
[]
[null,"Section 630: Seeding"]
[null,null,"630.0100 - 0199","SEEDING (MIXTURE)"]
[null,null,"630.0200","SEEDING TEMPORARY"]
[null,null,"630.0300","SEEDING BORROW PIT"]
[null,null,"630.0400","SEEDING NURSE CROP"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B195,Scratch!B199,Scratch!B203,Scratch!B207)=TRUE,Scratch!D200,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B195,Scratch!B199,Scratch!B203,Scratch!B207)=TRUE,Scratch!D201,\"\")","v":""}]
[]
[null,"Section 631: Sodding"]
[null,null,"631.0300","SOD WATER"]
[null,null,"631.1000","SOD LAWN"]
[null,null,"631.1100","SOD EROSION CONTROL"]
[null,null,"631.1200","SOD EROSION CONTROL SANDY SOIL"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B212,Scratch!B215,Scratch!B218,Scratch!B221)=TRUE,Scratch!D213,\"\")","v":""}]
[]
[null,"Section 632: Furnishing and Planting Plant Materials"]
[null,null,632.0101,"TREES (SPECIES, ROOT, SIZE)"]
[null,null,632.0201,"SHRUBS (SPECIES, ROOT, SIZE)"]
[null,null,632.0301,"VINES (SPECIES, ROOT, SIZE)"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B225,Scratch!B232,Scratch!B245)=TRUE,Scratch!D226,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B225,Scratch!B232,Scratch!B245)=TRUE,Scratch!D227,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B225,Scratch!B232,Scratch!B245)=TRUE,Scratch!D228,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B225,Scratch!B232,Scratch!B245)=TRUE,Scratch!D229,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B225,Scratch!B232,Scratch!B245)=TRUE,Scratch!D230,\"\")","v":""}]
[null,null,632.9101,"LANDSCAPE PLANTING SURVEILLANCE AND CARE CYCLES"]
[{"$nulls":3},{"$f":"IF(Scratch!B258=TRUE,Scratch!D259,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B258=TRUE,Scratch!D260,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B258=TRUE,Scratch!D261,\"\")","v":""}]
[]
[null,"Section 638: State Owned Signs and Supports"]
[null,null,"638.2100 - 2199","MOVING SIGNS (TYPE)"]
[null,null,"638.2600 - 2699","REMOVING SIGNS (TYPE)"]
[null,null,"638.3000","REMOVING SMALL SIGN SUPPORTS"]
[null,null,"638.3100","REMOVING STRUCTURAL STEEL SIGN SUPPORTS"]
[null,null,"638.3150 - 3199","REMOVING OVERHEAD SIGN SUPPORTS (TYPE) (STRUCTURE)"]
[null,null,"638.4000","MOVING SMALL SIGN SUPPORTS"]
[null,null,"638.4100","MOVING STRUCTURAL STEEL SIGN SUPPORTS"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B264,Scratch!B268,Scratch!B272,Scratch!B276,Scratch!B280,Scratch!B294,Scratch!B298)=TRUE,Scratch!D269,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B264,Scratch!B268,Scratch!B272,Scratch!B276,Scratch!B280,Scratch!B294,Scratch!B298)=TRUE,Scratch!D266,\"\")","v":""}]
[null,null,"638.3200 - 3299","REVISING SIGNS (TYPE) (MESSAGE)"]
[{"$nulls":3},{"$f":"IF(Scratch!B284=TRUE,Scratch!D285,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B284=TRUE,Scratch!D286,\"\")","v":""}]
[null,null,"638.3600 - 3699","ERECTING STATE-OWNED SIGNS (TYPE)"]
[{"$nulls":3},{"$f":"IF(Scratch!B288=TRUE,Scratch!D289,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B288=TRUE,Scratch!D290,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B288=TRUE,Scratch!D291,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B288=TRUE,Scratch!D292,\"\")","v":""}]
[]
[null,"Section 643: Traffic Control"]
[null,null,"643.0310.S","TEMPORARY PORTABLE RUMBLE STRIPS"]
[{"$nulls":3},{"$f":"IF(Scratch!B307=TRUE,Scratch!D308,\"\")","v":""}]
[null,null,"643.0650.S","TRAFFIC CHANNELIZING CURB SYSTEM"]
[{"$nulls":3},{"$f":"IF(Scratch!B322=TRUE,Scratch!D323,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B322=TRUE,Scratch!D324,\"\")","v":""}]
[null,null,"643.0300","TRAFFIC CONTROL DRUMS"]
[null,null,"643.0400 - 0449","TRAFFIC CONTROL BARRICADES (TYPE)"]
[null,null,"643.0500","TRAFFIC CONTROL FLEXIBLE TUBULAR MARKER POSTS"]
[null,null,"643.0600","TRAFFIC CONTROL FLEXIBLE TUBULAR MARKER BASES"]
[null,null,"643.0700 - 0799","TRAFFIC CONTROL WARNING LIGHTS (TYPE)"]
[null,null,"643.0800","TRAFFIC CONTROL ARROW BOARDS"]
[null,null,"643.0900","TRAFFIC CONTROL SIGNS"]
[null,null,"643.0910","TRAFFIC CONTROL COVERING SIGNS TYPE I"]
[null,null,"643.0920","TRAFFIC CONTROL COVERING SIGNS TYPE II"]
[null,null,"643.1000","TRAFFIC CONTROL SIGNS FIXED MESSAGE"]
[null,null,"643.1050","TRAFFIC CONTROL PCMS"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B303,Scratch!B310,Scratch!B314,Scratch!B318,Scratch!B326,Scratch!B330,Scratch!B334,Scratch!B338,Scratch!B342,Scratch!B346,Scratch!B350)=TRUE,Scratch!D304,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B303,Scratch!B310,Scratch!B314,Scratch!B318,Scratch!B326,Scratch!B330,Scratch!B334,Scratch!B338,Scratch!B342,Scratch!B346,Scratch!B350)=TRUE,Scratch!D305,\"\")","v":""}]
[null,null,"643.1051","TRAFFIC CONTROL PCMS WITH CELLULAR COMMUNICATIONS"]
[{"$nulls":3},{"$f":"IF(Scratch!B354=TRUE,Scratch!D355,\"\")","v":""}]
[null,null,"643.1055.S","TRUCK OR TRAILER-MOUNTED ATTENUATOR"]
[{"$nulls":3},{"$f":"IF(Scratch!B357=TRUE,Scratch!D358,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B357=TRUE,Scratch!D359,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B357=TRUE,Scratch!D360,\"\")","v":""}]
[null,null,"643.1070 -1079","TRAFFIC CONTROL CONES (HEIGHT)"]
[{"$nulls":3},{"$f":"IF(Scratch!B362=TRUE,Scratch!D363,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B362=TRUE,Scratch!D364,\"\")","v":""}]
[null,null,"643.1100.S","DYNAMIC LATE MERGE SYSTEM"]
[null,null,"643.1200.S","PORTABLE AUTOMATED REAL-TIME TRAFFIC QUEUE WARNING SYSTEM"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B366,Scratch!B371)=TRUE,Scratch!D367,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B366,Scratch!B371)=TRUE,Scratch!D368,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B366,Scratch!B371)=TRUE,Scratch!D369,\"\")","v":""}]
[null,null,"643.4100.S","TRAFFIC CONTROL INTERIM LANE CLOSURE"]
[{"$nulls":3},{"$f":"IF(Scratch!B376=TRUE,Scratch!D377,\"\")","v":""}]
[null,null,"643.5000","TRAFFIC CONTROL"]
[{"$nulls":3},{"$f":"IF(Scratch!B379=TRUE,Scratch!D380,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B379=TRUE,Scratch!D381,\"\")","v":""}]
[]
[null,"Section 648: Locating No-Passing Zones"]
[null,null,"648.0100","LOCATING NO-PASSING ZONES"]
[{"$nulls":3},{"$f":"IF(Scratch!B384=TRUE,Scratch!D385,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B384=TRUE,Scratch!D386,\"\")","v":""}]
[]
[null,"Section 649: Temporary Pavement Marking"]
[null,null,"649.0100 - 0299","TEMPORARY MARKING LINE (MATERIAL/TYPE) (WIDTH)"]
[null,null,"649.0500 - 0599","TEMPORARY MARKING ARROW (MATERIAL)"]
[null,null,"649.0600 - 0699","TEMPORARY MARKING WORD (MATERIAL)"]
[null,null,"649.0700 - 0799","TEMPORARY MARKING RAISED PAVEMENT MARKER (TYPE)"]
[null,null,"649.0800 - 0899","TEMPORARY MARKING STOP LINE (MATERIAL) 18-INCH"]
[null,null,"649.0900 - 0959","TEMPORARY MARKING DIAGONAL (MATERIAL) 12-INCH"]
[null,null,"649.0960 - 0970","TEMPORARY MARKING REMOVABLE MASK OUT TAPE (WIDTH)"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B389,Scratch!B394,Scratch!B399,Scratch!B404,Scratch!B409,Scratch!B414,Scratch!B419)=TRUE,Scratch!D420,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B389,Scratch!B394,Scratch!B399,Scratch!B404,Scratch!B409,Scratch!B414,Scratch!B419)=TRUE,Scratch!D421,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B389,Scratch!B394,Scratch!B399,Scratch!B404,Scratch!B409,Scratch!B414,Scratch!B419)=TRUE,Scratch!D422,\"\")","v":""}]
[]
[null,"Section 661: Temporary Traffic Signals and Temporary Ramp Meters"]
[null,null,"661.0100","TEMPORARY TRAFFIC SIGNALS FOR BRIDGES (STRUCTURE)"]
[null,null,"661.0200","TEMPORARY TRAFFIC SIGNALS FOR INTERSECTIONS (LOCATION)"]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B425,Scratch!B430)=TRUE,Scratch!D426,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B425,Scratch!B430)=TRUE,Scratch!D427,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(OR(Scratch!B425,Scratch!B430)=TRUE,Scratch!D428,\"\")","v":""}]
[null,null,"661.0300","GENERATORS"]
[{"$nulls":3},{"$f":"IF(Scratch!B435=TRUE,Scratch!D436,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B435=TRUE,Scratch!D437,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B435=TRUE,Scratch!D438,\"\")","v":""}]
[null,null,"661.0700","TEMPORARY RAMP METER (LOCATION)"]
[{"$nulls":3},{"$f":"IF(Scratch!B440=TRUE,Scratch!D441,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B440=TRUE,Scratch!D442,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B440=TRUE,Scratch!D443,\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(Scratch!B440=TRUE,Scratch!D444,\"\")","v":""}]

{"sheet":"Scratch","index":1,"n_rows":444,"n_cols":4,"rows_kept":444,"hidden":true}
[]
[]
[]
[null,"Section 106: Control of Materials"]
[null,null,false,"source of materials"]
[]
[null,"Section 206: Excavation for Structures"]
[null,false,"206.1000","Excavation for Structures Bridges (structure)"]
[null,null,false,"visual inspection"]
[null,null,false,"notification prior to excavation"]
[]
[null,false,"206.1050.S","Underwater Foundation Inspection"]
[{"$nulls":3},"no requirements"]
[]
[null,false,"206.2000","Excavation for Structures Culverts (structure)"]
[null,null,false,"visual inspection"]
[{"$nulls":3},"potential verification of approved materials"]
[null,null,false,"notification prior to excavation"]
[]
[null,false,"206.3000","Excavation for Structures Retaining Walls (structure)"]
[null,null,false,"visual inspection"]
[null,null,false,"notification prior to excavation"]
[]
[null,false,"206.4000","Excavation for Structures Structural Plate Pipe or Pipe Arches (station)"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"notification prior to excavation"]
[]
[null,false,"206.5000","Cofferdams (structure)"]
[null,null,false,"visual inspection"]
[null,null,false,"potential construction plans"]
[]
[null,"Section 511: Temporary Shoring"]
[null,false,"511.1100","Temporary Shoring"]
[null,null,false,"potential design verification"]
[]
[null,false,"511.1200","Temporary Shoring (structure)"]
[{"$nulls":3},"potential design verification"]
[]
[null,false,"511.1300","Temporary Shoring (location)"]
[{"$nulls":3},"potential design verification"]
[]
[null,false,"511.2200","Temporary Shoring Left in Place (structure)"]
[{"$nulls":3},"potential design verification"]
[]
[null,false,"511.2300","Temporary Shoring Left in Place (location)"]
[{"$nulls":3},"potential design verification"]
[]
[null,"Section 526: Temporary Structures"]
[null,false,"526.0100","Temporary Structure (station)"]
[null,null,false,"potential design verification"]
[null,null,false,"inspection reports"]
[null,null,false,"conform to BOS standards"]
[null,null,false,"potential Buy America document"]
[]
[null,false,"526.0200.S","Temporary Pedestrian Structure (station)"]
[null,null,false,"visual inspection"]
[null,null,false,"potential Buy America document"]
[]
[null,"Section 618: Maintenance and Repair of Haul Roads"]
[null,false,"618.0100","Maintenance and Repair of Haul Roads (project)"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"potential verification of materials"]
[]
[null,"Section 623: Dust Control Surface Treatment"]
[null,false,"623.0200","Dust Control Surface Treatment"]
[null,null,false,"certified report of test or analysis"]
[]
[null,"Section 624: Water"]
[null,false,"624.0100","Water"]
[{"$nulls":3},"visual inspection"]
[]
[null,"Section 625: Topsoil and Salvaged Topsoil"]
[null,false,"625.0100","Topsoil (SY)"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"potential test documentation"]
[]
[null,false,"625.0105","Topsoil (CY)"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"potential test documentation"]
[]
[null,false,"625.0500","Salvaged Topsoil"]
[{"$nulls":3},"visual inspection"]
[]
[null,"Section 626: Peat Humus"]
[null,false,"626.0200","Peat Humus"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"refer to spec book"]
[]
[null,"Section 627: Mulching"]
[null,false,"627.0200","Mulching (SY)"]
[{"$nulls":3},"Mulch: visual inspection"]
[{"$nulls":3},"Tackifier: verify material is on PAL and document rate of placement with wood chip mulch"]
[null,null,false,"Netting: document how netting was anchored"]
[null,null,false,"Erosion Mat: verify material is on PAL"]
[]
[null,false,"627.0205","Mulching (TON)"]
[{"$nulls":3},"Mulch: "]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Tackifier:"]
[{"$nulls":3},"verify material is on PAL"]
[{"$nulls":3},"document rate of placement with wood chip mulch"]
[{"$nulls":3},"Netting:"]
[{"$nulls":3},"document how netting was anchored"]
[{"$nulls":3},"Erosion Mat:"]
[{"$nulls":3},"verify material is on PAL"]
[]
[null,"Section 628: Erosion Control"]
[null,false,"628.1104","Erosion Bales"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"verify material is on PAL"]
[{"$nulls":3},"installation specifications"]
[]
[null,false,"628.1504","Silt Fence"]
[{"$nulls":3},"Geotextile Fabric:"]
[{"$nulls":3},"certification of compliance"]
[{"$nulls":3},"visual inspection and physical dimenstion conformity"]
[{"$nulls":3},"verify material is on PAL"]
[{"$nulls":3},"installation specifications"]
[]
[null,false,"628.1520","Silt Fence Maintenance"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"628.1550","Silt Screen"]
[{"$nulls":3},"certification of compliance"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"628.1905","Mobilizations Erosion Control"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"ECIP document"]
[]
[null,false,"628.1910","Mobilizations Emergency Erosion Control"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"628.1920","Cleaning Sediment Basins"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"628.2000 - 2099","Erosion Mat (class) (type)"]
[null,null,false,"verify material is on PAL"]
[null,null,false,"installation specifications"]
[null,null,false,"if using jute fabric --> certificate of compliance"]
[]
[null,false,"628.5505","Polyethylene Sheeting"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"verify material is on PAL"]
[{"$nulls":3},"installation specifications"]
[]
[null,false,"628.6005","Turbidity Barriers"]
[{"$nulls":3},"certification of compliance"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"verify material is on PAL"]
[{"$nulls":3},"installation specifications"]
[]
[null,false,"628.6500 - 6599","Soil Stabilizer (type)"]
[{"$nulls":3},"verify material is on PAL"]
[]
[null,false,"628.7000 - 7099","Inlet Protection (type)"]
[{"$nulls":3},"verify material is on PAL"]
[]
[null,false,"628.7504","Temporary Ditch Checks"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"verify alternative materials are on PAL"]
[]
[null,false,"628.7515.S","Stone or Rock Ditch Checks"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"potential test results"]
[]
[null,false,"628.7555","Culvert Pipe Checks"]
[null,null,false,"Fabric: certification of compliance and visual inspection"]
[null,null,false,"Aggregate: visual inspection"]
[]
[null,false,"628.7560","Tracking Pads"]
[{"$nulls":3},"Fabric:"]
[{"$nulls":3},"certification of compliance"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Aggregate:"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"628.7570","Rock Bags"]
[{"$nulls":3},"Fabric:"]
[{"$nulls":3},"certification of compliance"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Aggregate:"]
[{"$nulls":3},"visual inspection"]
[]
[null,"Section 629: Fertilizer and Agricultural Limestone"]
[null,false,"629.0200 - 0299","Fertilizer (type)"]
[{"$nulls":3},"record brand and formula"]
[null,null,false,"refer to spec book"]
[]
[null,false,"629.1100","Agricultural Limestone Treatment"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"delivery statement with index zone of material furnished"]
[]
[null,"Section 630: Seeding"]
[null,false,"630.0100 - 0199","Seeding (mixture)"]
[null,null,false,"record brand, mix number and test data"]
[{"$nulls":3},"file tags in field records"]
[]
[null,false,"630.0200","Seeding Temporary"]
[{"$nulls":3},"record brand, mix number and test data (refer to spec book)"]
[{"$nulls":3},"file tags in field records"]
[]
[null,false,"630.0300","Seeding Borrow Pit"]
[{"$nulls":3},"record brand, mix number and test data"]
[{"$nulls":3},"file tags in field records"]
[]
[null,false,"630.0400","Seeding Nurse Crop"]
[{"$nulls":3},"record brand, mix number and test data (refer to spec book)"]
[{"$nulls":3},"file tags in field records"]
[]
[null,"Section 631: Sodding"]
[null,false,"631.0300","Sod Water"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"631.1000","Sod Lawn"]
[{"$nulls":3},"visual inspection of sod and netting"]
[]
[null,false,"631.1100","Sod Erosion Control"]
[{"$nulls":3},"visual inspection of sod and netting"]
[]
[null,false,"631.1200","Sod Erosion Control Sandy Soil"]
[{"$nulls":3},"visual inspection of sod and netting"]
[]
[null,"Section 632: Furnishing and Planting Plant Materials"]
[null,false,632.0101,"Trees (species, root, size)"]
[null,null,false,"Trees, Shrubs and/or Vines: certification of inspection on nursery tag and visual inspection"]
[{"$nulls":3},"Peat Moss: certification or bale marking with compression ratio"]
[{"$nulls":3},"Anti-Desiccant (when specified): visual inspection"]
[null,null,false,"Fertilizer: visual inspection"]
[{"$nulls":3},"Herbicide (when specified): visual inspection"]
[]
[null,false,632.0201,"Shrubs (species, root, size)"]
[{"$nulls":3},"Trees, Shrubs and/or Vines:"]
[{"$nulls":3},"certification of inspection on nursery tag"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Peat Moss:"]
[{"$nulls":3},"certification or bale marking with compression ratio"]
[{"$nulls":3},"Anti-Desiccant (when specified):"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Fertilizer:"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Herbicide (when specified):"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,632.0301,"Vines (species, root, size)"]
[{"$nulls":3},"Trees, Shrubs and/or Vines:"]
[{"$nulls":3},"certification of inspection on nursery tag"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Peat Moss:"]
[{"$nulls":3},"certification or bale marking with compression ratio"]
[{"$nulls":3},"Anti-Desiccant (when specified):"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Fertilizer:"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"Herbicide (when specified):"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,632.9101,"Landscape Planting Surveillance and Care Cycles"]
[null,null,false,"visual inspection"]
[null,null,false,"contact information of care specialist"]
[null,null,false,"notifications and written reports from care specialist"]
[]
[null,"Section 638: State Owned Signs and Supports"]
[null,false,"638.2100 - 2199","Moving Signs (type)"]
[{"$nulls":3},"verification of approved materials"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"638.2600 - 2699","Removing Signs (type)"]
[{"$nulls":3},"verification of approved materials"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"638.3000","Removing Small Sign Supports"]
[{"$nulls":3},"verification of approved materials"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"638.3100","Removing Structural Steel Sign Supports"]
[{"$nulls":3},"verification of approved materials"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"638.3150 - 3199","Removing Overhead Sign Supports (type) (structure)"]
[{"$nulls":3},"verification of approved materials"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"638.3200 - 3299","Revising Signs (type) (message)"]
[null,null,false,"Face: certification of compliance and visual inspection"]
[null,null,false,"Message: certification of compliance and visual inspection"]
[]
[null,false,"638.3600 - 3699","Erecting State-Owned Signs (type)"]
[{"$nulls":3},"verification of approved materials"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"notification letter"]
[{"$nulls":3},"potential Buy America document"]
[]
[null,false,"638.4000","Moving Small Sign Supports"]
[null,null,false,"verification of approved materials"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"638.4100","Moving Structural Steel Sign Supports"]
[{"$nulls":3},"verification of approved materials"]
[null,null,false,"visual inspection"]
[]
[null,"Section 643: Traffic Control"]
[null,false,"643.0300","Traffic Control Drums"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.0310.S","Temporary Portable Rumble Strips"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"643.0400 - 0449","Traffic Control Barricades (type)"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.0500","Traffic Control Flexible Tubular Marker Posts"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.0600","Traffic Control Flexible Tubular Marker Bases"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.0650.S","Traffic Channelizing Curb System"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"verification of WisDOT approved products"]
[]
[null,false,"643.0700 - 0799","Traffic Control Warning Lights (type)"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.0800","Traffic Control Arrow Boards"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.0900","Traffic Control Signs"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.0910","Traffic Control Covering Signs Type I"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.0920","Traffic Control Covering Signs Type II"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.1000","Traffic Control Signs Fixed Message"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.1050","Traffic Control PCMS"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"letter of certification for crashworthiness criteria"]
[]
[null,false,"643.1051","Traffic Control PCMS with Cellular Communications"]
[{"$nulls":3},"provide IP address, serial port settings and passwords"]
[]
[null,false,"643.1055.S","Truck or Trailer-Mounted Attenuator"]
[{"$nulls":3},"written certification of conformity to crashworthiness criteria"]
[{"$nulls":3},"federal-aid reimbursement eligibility letter"]
[{"$nulls":3},"copy of specifications and installation instructions"]
[]
[null,false,"643.1070 -1079","Traffic Control Cones (height)"]
[{"$nulls":3},"visual inspection of conformance to condition and physical properties"]
[{"$nulls":3},"verification of WisDOT approved product"]
[]
[null,false,"643.1100.S","Dynamic Late Merge System"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"vendor verification of functionality prior to pre-construction meeting"]
[{"$nulls":3},"contact information of designated representative"]
[]
[null,false,"643.1200.S","Portable Automated Real-Time Traffic Queue Warning System"]
[{"$nulls":3},"visual inspection"]
[{"$nulls":3},"vendor verification of functionality prior to pre-construction meeting"]
[{"$nulls":3},"contact information of designated representative"]
[]
[null,false,"643.4100.S","Traffic Control Interim Lane Closure"]
[{"$nulls":3},"no requirements"]
[]
[null,false,"643.5000","Traffic Control"]
[null,null,false,"visual inspection of conformance to condition and physical properties"]
[null,null,false,"verification of WisDOT approved product"]
[]
[null,"Section 648: Locating No-Passing Zones"]
[null,false,"648.0100","Locating No-Passing Zones"]
[null,null,false,"potential verification of conformity to traffic guidelines manual"]
[{"$nulls":3},"potential documentation of special no-passing zones"]
[]
[null,"Section 649: Temporary Pavement Marking"]
[null,false,"649.0100 - 0299","Temporary Marking Line (material/type) (width)"]
[{"$nulls":3},"refer to spec book"]
[null,null,false,"certificate of compliance"]
[null,null,false,"visual inspection"]
[]
[null,false,"649.0500 - 0599","Temporary Marking Arrow (material)"]
[{"$nulls":3},"refer to spec book"]
[{"$nulls":3},"certificate of compliance"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"649.0600 - 0699","Temporary Marking Word (material)"]
[{"$nulls":3},"refer to spec book"]
[{"$nulls":3},"certificate of compliance"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"649.0700 - 0799","Temporary Marking Raised Pavement Marker (type)"]
[{"$nulls":3},"refer to spec book"]
[{"$nulls":3},"certificate of compliance"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"649.0800 - 0899","Temporary Marking Stop Line (material) 18-Inch"]
[{"$nulls":3},"refer to spec book"]
[{"$nulls":3},"certificate of compliance"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"649.0900 - 0959","Temporary Marking Diagonal (material) 12-Inch"]
[{"$nulls":3},"refer to spec book"]
[{"$nulls":3},"certificate of compliance"]
[{"$nulls":3},"visual inspection"]
[]
[null,false,"649.0960 - 0970","Temporary Marking Removable Mask Out Tape (width)"]
[{"$nulls":3},"refer to spec book"]
[{"$nulls":3},"certificate of compliance"]
[{"$nulls":3},"visual inspection"]
[]
[null,"Section 661: Temporary Traffic Signals and Temporary Ramp Meters"]
[null,false,"661.0100","Temporary Traffic Signals for Bridges (structure)"]
[{"$nulls":3},"refer to spec book"]
[null,null,false,"verification of signal operations"]
[null,null,false,"contact information"]
[]
[null,false,"661.0200","Temporary Traffic Signals for Intersections (location)"]
[{"$nulls":3},"refer to spec book"]
[{"$nulls":3},"verification of signal operations"]
[{"$nulls":3},"contact information"]
[]
[null,false,"661.0300","Generators"]
[null,null,false,"refer to spec book"]
[{"$nulls":3},"verification of location"]
[{"$nulls":3},"contact information"]
[]
[null,false,"661.0700","Temporary Ramp Meter (location)"]
[{"$nulls":3},"refer to spec book"]
[null,null,false,"verification of signal operations"]
[{"$nulls":3}," contact information"]
[null,null,false,"10 day notification prior to work"]