{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Contract Data","Guardrail","GC_LowTension","GC_Gibraltar","GC_Valtir","GC_Access_Restraint","Pictures"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["(If using spreadshseet tab for the first time, Click on the \"Contract Data\" Tab to fill out specific contract data)"]
["Remove and/or fill out any of the highlighted areas in order to set this up for YOUR contract.  "]
[]
["Select Contract Data Tab."]
[]
["Enter the work adjustment factor from the Contract."]
["Enter the contract specific information from the Contract."]
["Create a list of the counties included in the contract."]
[]
["Select the Job Order Tab for the items you're working on"]
["If a job includes both guardrail and guard cable items, create a separate Job Order for each."]
[]
["Fill in the shaded cells manually, note that some utilize dropdown menus."]
[]
["Select the correct pay item utilizing the dropdown menus in the \"Pay Item Description\" column. Note this will auto populate other cells."]
[]
["Using the calculated quantities from previous tabs or manual calculations, enter the quantities in the \"Estimated Quantities\" column."]
[]
["Add pictures to the pictures tab only.  No need to store separately in eProjects.  Use the Insert - then pictures to select those you wish to add.  Resize to the box.  Pictures are formatted to print 4 per page if inserted into box correctly."]
[]
["For final quantities, enter the amounts used in the field in the \"Final Quantity\" column.  MoDOT Signature is only REQUIRED on the final PDF version of the job order."]
[]
["Holding control key allows you to select multiple worksheets to print at one time, rather than printing out individual worksheets that have to be combined. "]
["Use CTRL and select multiple tabs.  In this example the Guardrail and Pictures tab was selected"]
[]
[]
[]
[]
[]
[]
["Go to the File Print option and change to Adobe PDF for the printer.  If you have only one page of pictures, then set the Pages to start at Page 1 and end at Page 3 - this will eliminate the blank page of pictures"]

{"sheet":"Contract Data","index":1,"n_rows":247,"n_cols":14,"rows_kept":247,"cut":false,"hidden":false,"merged":[[1,0,1,3],[155,0,155,3],[23,0,23,3]]}
["Do not change these items",null,null,null,null,"Enter Contract Bid Factor Here",null,null,null,null,null,null,"Enter Contract Specific Information Here",""]
["ALL",null,null,null,null,"Adjustment Factor",null,null,null,null,"Each",null,"Job Number"]
["MISC. TRAFFIC CONTROL ITEMS",null,null,null,null,null,null,null,null,null,null,null,"Contract ID"]
["MISC. WORK BEYOND SHOULDER",250,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor"]
["MISC. SHOULDER WORK - UNDIVIDED ROADWAYS",250,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor Phone Number"]
["MISC. RIGHT SHOULDER WORK - HIGH SPEED RDWY",350,6169902,"EA",null,"Direction (N, S, E, W)",null,"SELECT"]
["MISC. LEFT SHOULDER WORK - HIGH SPEED ROADWAY",500,6169902,"EA",null,null,null,"N",null,null,null,null,"Enter the Police Department for the PD Report HERE:"]
["MISC. 1-LANE 2-WAY OPERATION W/ FLAGGERS",800,6169902,"EA",null,null,null,"S",null,null,null,null,"SELECT"]
["MISC. SINGLE LANE CLOSURE",900,6169902,"EA",null,null,null,"E"]
["MISC. PARTIAL RAMP CLOSURE",400,6169902,"EA",null,null,null,"W"]
["MISC. COMPLETE RAMP CLOSURE",600,6169902,"EA"]
["MISC. ENTRANCE RAMP AREA, MAINLINE WORK",400,6169902,"EA",null,"County:"]
["MISC. ENTRANCE RAMP AREA, ACCEL LANE WORK",400,6169902,"EA",null,"SELECT"]
["MISC. EXIT RAMP AREA, MAINLINE/DECEL LANE WORK",400,6169902,"EA"]
["MISC. ADDITIONAL TRUCK MOUNTED ATTENUATOR",350,6169902,"EA"]
["MISC. ADDITIONAL FLASHING ARROW PANEL",100,6169902,"EA"]
["MISC. ADDITIONAL DIRECTIONAL INDICATOR BARRICADE",15,6169902,"EA"]
["MISC. ADDITIONAL CHANNELIZER (TRIMLINE)",11,6169902,"EA"]
["MISC. ADDITIONAL CMS (CONTRACTOR FURNISHED/RETAINED)",1100,6169902,"EA"]
["MISC. SEQUENTIAL FLASHING WARNING LIGHT",50,6169902,"EA"]
["MISC. ADDITIONAL CONSTRUCTION SIGNS",4,6169904,"SF"]
["MISC. TEMPORARY TRAFFIC CONTROL SINGLE LANE SHIFT",500,6169902,"EA"]
[]
["Guardrail"]
["NEW GUARDRAIL INSTALLATION ITEMS"]
["MISC. TYPE A OR B TERMINAL REMOVAL",250,2029902,"EA"]
["MISC. REMOVE GUARDRAIL",10,2029903,"LF"]
["MISC. GRADING FOR CRASHWORTHY END TERMINAL",3500,2149910,"LS"]
["BULLNOSE GUARDRAIL SYSTEM",8843,6060110,"EA"]
["GUARDRAIL TYPE A",28,6061010,"LF"]
["GUARDRAIL TYPE A, 7 FT. POST, 3 FT. - 1.5 IN. SPACING",44,"6061011A","LF"]
["GUARDRAIL TYPE E, 6 FT. POST, 3 FT. - 1.5 IN. SPACING",50,6061050,"LF"]
["GUARDRAIL TYPE E, 7 FT. POST",55,6061051,"LF"]
["GUARDRAIL TYPE E, 6 FT. POST, 6 FT. - 3 IN. SPACING",37,6061054,"LF"]
["MGS GUARDRAIL",28,6061060,"LF"]
["MGS GUARDRAIL, 8 FT., 6 FT. – 3 IN. SPACING",32,6061061,"LF"]
["MGS GUARDRAIL, 6 FT. POSTS, 3 FT. – 1.5 IN. SPACING",41,6061063,"LF"]
["MGS GUARDRAIL, 6 FT. POSTS, 1 FT. – 6.75 IN. SPACING",64,6061065,"LF"]
["MGS DOUBLE FACED GUARDRAIL",46,6061067,"LF"]
["MGS BRIDGE APPR TRANS SECT (MAJOR ROUTE)",3502,6061068,"EA"]
["MGS BRIDGE APPR TRANS SECT (MINOR ROUTE)",3375,6061069,"EA"]
["MGS VERTICAL CONCRETE BARRIER TRANSITION",3375,6061070,"EA"]
["MGS HEIGHT AND BLOCK TRANSITION SECTION",647,6061074,"EA"]
["MGS LONG SPAN GUARDRAIL SECTION",3198,6061075,"EA"]
["MGS END ANCHOR",1390,6061080,"EA"]
["MGS BRIDGE ANCHOR SECTION (THRIE-BEAM)",2728,6061081,"EA"]
["BRDG ANCH SECT, 6.5 FT. POSTS (SFTY BAR CURB)(RDWY/REHAB ONLY)",2787,"6062200A","EA"]
["BRDG ANCH SECT, 7.5 FT. POSTS (SFTY BAR CURB)(RDWY/REHAB ONLY)",2887,"6062202A","EA"]
["TRANSITION SECTION, 6.5 FT. POSTS",592,"6062300A","EA"]
["TRANSITION SECTION, 7.5 FT. POSTS",614,"6062301A","EA"]
["ASYMMETRICAL TRANSITION SECT, 6.5 FT. POSTS",620,6062303,"EA"]
["ASYMMETRICAL TRANSITION SECT, 7.5 FT. POSTS",649,6062304,"EA"]
["BRIDGE ANCHOR SECTION (THRIE BEAM)",2728,6062400,"EA"]
["TERMINAL SECTION – GUARDRAIL",1484,6063000,"EA"]
["TYPE B CRASHWORTHY END TERMINAL (MASH)",9750,6063013,"EA"]
["TYPE A CRASHWORTHY END TERMINAL (MASH)",2958,6063014,"EA"]
["TYPE B CRASHWORTHY END TERMINAL",5158,6063016,"EA"]
["END ANCHOR",1262,6066610,"EA"]
["GUARDRAIL ANCHOR, EMBEDDED",2217,6066620,"EA"]
["GUARDRAIL ANCHOR, ROCK FACE",1650,6066630,"EA"]
["MISC. INSTALL POST IN SOLID ROCK OR CONC, 6’ OR 7’ (TYPE A,  E OR MGS)",350,6069902,"EA"]
["MISC. FLARED TYPE A CRASHWORTHY END TERMINAL",2365,6069902,"EA"]
["GUARDRAIL REPAIR ITEMS"]
["MISC. R&R 12.5’ BEAM, CONC/CONVEX RADIUS, TY A",350,6069902,"EA"]
["MISC. R&R 12.5’ BEAM, CONC/CONVEX RADIUS, MGS",350,6069902,"EA"]
["MISC. R&R 12.5’ W-BEAM PANEL (TYPE A GR)",162,6069902,"EA"]
["MISC. R&R 12.5’ W-BEAM PANEL (MGS)",162,6069902,"EA"]
["MISC. R&R 12.5' BEAM 10 GA. (TYPE E GR)",356,6069902,"EA"]
["MISC. R&R 18.75’ THRIE BEAM PANEL (MGS)",485,6069902,"EA"]
["MISC. R&R 25' THRIE BEAM PANEL (TYPE E GR)",460,6069902,"EA"]
["MISC. R&R 25’ THRIE BEAM PANEL (MGS)",460,6069902,"EA"]
["MISC. R&R 25' W-BEAM PANEL (TYPE A GR)",281,6069902,"EA"]
["MISC. R&R 25’ W-BEAM PANEL (MGS)",281,6069902,"EA"]
["MISC. R&R 6.25’ THRIE BEAM PANEL (MGS)",169,6069902,"EA"]
["MISC. R&R 6.25' TYPE A TO TYPE E TRANSITION BEAM",159,6069902,"EA"]
["MISC. R&R WOOD BLOCK 8X6X17 TRANSITION SECTION",35,6069902,"EA"]
["MISC. R&R WOOD BLOCK 12X6X19 TRANSITION SECTION",36,6069902,"EA"]
["MISC. R&R MGS HEIGHT AND BLOCK TRANSITION SECTION",772,6069902,"EA"]
["MISC. REALIGN & USE EXIST POST TYPE A, E OR MGS GR",25,6069902,"EA"]
["MISC. RE-TENSION GUARDRAIL SYSTEM",75,6069902,"EA"]
["MISC. R&R 12.5' END ANCHOR PANEL",154,6069902,"EA"]
["MISC. R&R 12.5’ MGS END ANCHOR PANEL",154,6069902,"EA"]
["MISC. R&R 12.5' THRIE BEAM RAIL TY E GR",234,6069902,"EA"]
["MISC. R&R MGS END ANCHOR",1313,6069902,"EA"]
["MISC. R&R 72” FOUNDATION TUBE W/O SOIL PLATE (MGS)",374,6069902,"EA"]
["MISC. R&R 46” WOOD POST IN FOUNDATION TUBE (MGS)",78,6069902,"EA"]
["MISC. R&R CABLE ASSY W/PIPE, PLATE & ANCHOR (MGS)",305,6069902,"EA"]
["MISC. R&R END ANCHOR RAIL",164,6069902,"EA"]
["MISC. R&R END ANCHOR CABLE ASSEMBLY",143,6069902,"EA"]
["MISC. R&R END SEC (SHOE) TY A GR",72,6069902,"EA"]
["MISC. R&R PARTS FOR END SECTION",105,6069902,"EA"]
["MISC. R&R GR DELINEATOR 1 SIDE OR 2 SIDE",12,6069902,"EA"]
["MISC. R&R STEEL POST 6', MGS",79,6069902,"EA"]
["MISC. R&R STEEL POST 6', TY A OR MGS GR",79,6069902,"EA"]
["MISC. R&R STEEL POST 6', TY E GR",89,6069902,"EA"]
["MISC. R&R STEEL POST 7', TY A GR",89,6069902,"EA"]
["MISC. R&R STEEL POST 7', TY E GR",90,6069902,"EA"]
["MISC. R&R STEEL POST 8', MGS",98,6069902,"EA"]
["MISC. R&R WOOD POST 6', TY A GR",74,6069902,"EA"]
["MISC. R&R WOOD POST 7', TY A GR",84,6069902,"EA"]
["MISC. R&R STEEL TUBE BLOCK 7X4 BR ANCH",107,6069902,"EA"]
["MISC. R&R STEEL SPACER BLOCK (TYPE A GR)",40,6069902,"EA"]
["MISC. R&R STEEL BLOCKOUT FOR RADIUS RAIL",40,6069902,"EA"]
["MISC. R&R TERMINAL CONNECTOR, TY A OR MGS GR",115,6069902,"EA"]
["MISC. R&R TERMINAL CONNECTOR, TY E OR MGS GR",150,6069902,"EA"]
["MISC. R&R WOOD/PLASTIC BLOCK 8X6X14 MGS",21,6069902,"EA"]
["MISC. R&R WOOD/PLASTIC BLOCK 8X6X14 TY A GR",21,6069902,"EA"]
["MISC. R&R WOOD/PLASTIC BLOCK 8X6X21 TY E GR",25,6069902,"EA"]
["MISC. R&R WOOD/PLASTIC BLOCK 12X6X14 MGS",25,6069902,"EA"]
["BULLNOSE SYSTEM REPAIR ITEMS"]
["MISC. R&R PARTS FOR BULLNOSE SYSTEM",1050,6069902,"EA"]
["MISC. R&R 72 IN FOUNDATION TUBE BULLNOSE SYSTEM",350,6069902,"EA"]
["MISC. R&R 96 1/16 IN FOUNDATION TUBE BULLNOSE SYSTEM",451,6069902,"EA"]
["MISC. R&R POSTS #1-2 BULLNOSE SYSTEM",87,6069902,"EA"]
["MISC. R&R POSTS #3-8 BULLNOSE SYSTEM",101,6069902,"EA"]
["MISC. R&R POSTS #9-12 BULLNOSE SYSTEM",100,6069902,"EA"]
["MISC. R&R 8X6X14 3/16 TAPERED WOOD BLOCK BULLNOSE SYSTEM",36,6069902,"EA"]
["MISC. R&R RAIL SECTION #1 BULLNOSE SYSTEM",1257,6069902,"EA"]
["MISC. R&R RAIL SECTION #2 BULLNOSE SYSTEM",768,6069902,"EA"]
["MISC. R&R RAIL SECTION #3 BULLNOSE SYSTEM",426,6069902,"EA"]
["END TERMINAL REPAIR ITEMS"]
["MISC. NEW OR R&R RFLCT SHEETING ON END TERM (UNIVERSAL)",45,6069902,"EA"]
["MISC. R&R 12.5 FT END SECT 1ST W-BEAM RAIL (MSKT)",203,6069902,"EA"]
["MISC. R&R 9.375 FT 2ND SECTION W-BEAM RAIL (MSKT)",135,6069902,"EA"]
["MISC. R&R CABLE ASSY W/ PIPE, PLATE & ANCH (MSKT)",113,6069902,"EA"]
["MISC. R&R GROUND STRUT (MSKT)",115,6069902,"EA"]
["MISC. R&R NEW IMPACT HEAD (MSKT)",1075,6069902,"EA"]
["MISC. REM EXT GR & REUSE EXIST IMPACT HD (MSKT)",250,6069902,"EA"]
["MISC. R&R POST #1 HBA TOP (MSKT)",110,6069902,"EA"]
["MISC. R&R POST #1 HBA BOTTOM (MSKT)",308,6069902,"EA"]
["MISC. R&R POST #2 HBA TOP (MSKT)",100,6069902,"EA"]
["MISC. R&R POST #2 HBA BOTTOM (MSKT)",165,6069902,"EA"]
["MISC. R&R 12’6” GALV GR PANEL 3’1.5” O/C (SOFTSTOP)",166,6069902,"EA"]
["MISC. R&R 12/25/3'1.5:3@6'3:3'1.5/S (SOFTSTOP)",274,6069902,"EA"]
["MISC. R&R 6'0 SYT POST/8.5/31\" GR HT (SOFTSTOP)",125,6069902,"EA"]
["MISC. R&R ANCHOR GUARDRAIL 12'-6\" (SOFTSTOP)",315,6069902,"EA"]
["MISC. R&R ANGLE STRUT (SOFTSTOP)",88,6069902,"EA"]
["MISC. R&R STYP#1 8.5# 4'9-1/2 (SOFTSTOP)",119,6069902,"EA"]
["MISC. R&R ANCHOR POST W6X15#X6' (SOFTSTOP)",411,6069902,"EA"]
["MISC. R&R IMPACT HEAD (SOFTSTOP)",1098,6069902,"EA"]
["MISC. REM EXT GR & REUSE EXIST IMPACT HD (SOFTSTOP)",253,6069902,"EA"]
["MISC. R&R CAN TL3 SS646 (SOFTSTOP)",322,6069902,"EA"]
["MISC. R&R ANCHOR ANGLE (SOFTSTOP)",41,6069902,"EA"]
["MISC. R&R PLATE WASHER (SOFTSTOP)",35,6069902,"EA"]
["MISC. R&R KEEPER PLATE (SOFTSTOP)",30,6069902,"EA"]
["MISC. R&R ANCHOR PADDLE (SOFTSTOP)",142,6069902,"EA"]
["MISC. R&R SLED WELDMENT (TRACC)",2978,6069902,"EA"]
["MISC. R&R SHREDDER (TRACC)",380,6069902,"EA"]
["MISC. R&R STAGE 2 RIP PLATE 75 IN (TRACC)",225,6069902,"EA"]
["MISC. R&R STAGE 3 RIP PLATE 93 IN (TRACC)",240,6069902,"EA"]
["MISC. R&R STAGE 3 RIP PLATE (25965G) 87 IN (TRACC)",230,6069902,"EA"]
["MISC. R&R STAGE 3 RIP PLATE (25966G) 87 IN (TRACC)",230,6069902,"EA"]
["MISC. R&R 2 BAY FENDER PANEL (TRACC)",280,6069902,"EA"]
["MISC. R&R NOSEPIECE YELLOW (TRACC)",355,6069902,"EA"]
[]
["Guard Cable"]
[]
["ONE-STRAND ACCESS RESTRAINT CABLE REPAIR AND REPLACEMENT"]
["MISC. REMOVE ACCESS RESTRAINT CABLE 1/S",5,2029903,"LF"]
["ONE-STRAND CABLE - ACCESS RESTRAINT",23,6064000,"LF"]
["MISC. ATTACH CABLE TO POST ACC REST CABLE 1/S",12,6069902,"EA"]
["MISC. R&R ANCHOR ROD ASSY 1/S",415,6069902,"EA"]
["MISC. R&R STEEL LINE OR END POST 1/S",73,6069902,"EA"]
["MISC. R&R TURNBUCKLE CABLE END ASSY 1/S",174,6069902,"EA"]
["MISC. REALIGN LINE/END POST ACC REST CABLE 1/S",25,6069902,"EA"]
["MISC. REPLACE GUARD CABLE DELINEATOR",9,6069902,"EA"]
["MISC. RETENSION ACCESS RESTRAINT CABLE 1/S",45,6069902,"EA"]
["MISC. SPLICE 1/2 INCH CABLE 1/S",110,6069902,"EA"]
["MISC. 1/2 INCH CABLE RESTRAINT 1/S",8,6069903,"LF"]
[]
["LOW TENSION GUARD CABLE REPAIR AND REPLACEMENT"]
["MISC. REMOVE GUARD CABLE ",7,2029903,"LF"]
["ANCHOR ASSEMBLY, GUARD CABLE ",3350,6064110,"EA"]
["ANCHOR ASSEMBLY, GCABLE 3-S TO GRAIL TRANS",3013,6064111,"EA"]
["MISC. ATTACH CABLES TO POST  LT",19,6069902,"EA"]
["MISC. GUARD CABLE LINE POST SET IN ROCK ",199,6069902,"EA"]
["MISC. R&R ANCHOR POST ",153,6069902,"EA"]
["MISC. R&R LINE POST ",89,6069902,"EA"]
["MISC. R&R LINE POST IN ROCK LT",171,6069902,"EA"]
["MISC. R&R ANCH BRACKET - MED OR  RDSIDE ",503,6069902,"EA"]
["MISC. R&R ANCH BRACKET - GUARD CABLE TO GR ",403,6069902,"EA"]
["MISC. R&R CABLE TRANSITION BRACKET ",108,6069902,"EA"]
["MISC. R&R CABLE END FITTING ",138,6069902,"EA"]
["MISC. R&R COMPENSATING CABLE END ASSY ",358,6069902,"EA"]
["MISC. R&R COMPENSATOR SPRING ",275,6069902,"EA"]
["MISC. R&R TURNBUCKLE END ASSY W/O COMPE'TOR ",233,6069902,"EA"]
["MISC. REALIGN LINE POST ",20,6069902,"EA"]
["MISC. REPLACE GUARD CABLE DELINEATOR",9,6069902,"EA"]
["MISC. RETENSION LOW TENSION GUARD CABLES ",83,6069902,"EA"]
["MISC. RETROFIT SLIP BASE PLATE",275,6069902,"EA"]
["MISC. SPLICE 3/4 INCH CABLE 1/S",179,6069902,"EA"]
["MISC. 3/4 INCH CABLE 1/S - LT",9,6069903,"LF"]
[]
["HIGH TENSION GUARD CABLE BARRIER REPAIR AND REPLACEMENT - VALTIR"]
["MISC. REMOVE GUARD CABLE ",7,2029903,"LF"]
["ANCHOR ASSEMBLY, GUARD CABLE ",3808,6064110,"EA"]
["ANCHOR ASSEMBLY, GCABLE 3-S TO GRAIL TRANS",3250,6064111,"EA"]
["MISC. ATTACH CABLES TO POST  HT - VALTIR",41,6069902,"EA"]
["MISC. ATTACH NEW CRP ANCH POST TO BASE HT",364,6069902,"EA"]
["MISC. REATTACH EXIST CRP ANCH POST TO BASE - VALTIR",79,6069902,"EA"]
["MISC. R&R CRP ANCH POST 1-3 CONC FOOT W/ STUB HT",621,6069902,"EA"]
["MISC. FURN/INST TURNBUCKLE CABLE SPLICE ASSY HT",480,6069902,"EA"]
["MISC. R&R TURNBUCKLE HT",316,6069902,"EA"]
["MISC. R&R CCT TERMINAL POST 4-7 IN EX SLEEVE HT",263,6069902,"EA"]
["MISC. R&R CCT TERMINAL POST 8-9 IN EX SLEEVE HT",276,6069902,"EA"]
["MISC. R&R CCT TERM POST 4-9 CON FOOT W/ SLEEVE HT",334,6069902,"EA"]
["MISC. R&R LINE POST CONC FOOTING W/ SLEEVE HT",252,6069902,"EA"]
["MISC. R&R LINE POST IN EXIST SLEEVE HT",163,6069902,"EA"]
["MISC. R&R LINE POST IN ROCK HT",210,6069902,"EA"]
["MISC. R&R TOP/MID/OR BOTTOM CABLE END ASSY HT",286,6069902,"EA"]
["MISC. RETENSION HIGH TENSION CABLES  HT",188,6069902,"EA"]
["MISC. REALIGN LINE POST HT",60,6069902,"EA"]
["MISC. SPLICE 3/4 INCH CABLE 1/S - HT",271,6069902,"EA"]
["MISC. 3/4 INCH CABLE 1/S - HT",8,6069903,"LF"]
["MISC. HIGH TENSION SAFETY FENCE, TL-3",27,6069903,"LF"]
["MISC. HIGH TENSION SAFETY FENCE, TL-4",33,6069903,"LF"]
[]
["HIGH TENSION GUARD CABLE BARRIER REPAIR & REPLACEMENT - GIBRALTAR"]
["MISC. REMOVE GUARD CABLE ",7,2029903,"LF"]
["ANCHOR ASSEMBLY, GUARD CABLE ",3950,6064110,"EA"]
["ANCHOR ASSEMBLY, GCABLE TO GRAIL TRANS",3150,6064111,"EA"]
["MISC. ATTACH CABLES TO TL-3 POST  HT - GIBRALTAR",56,6069902,"EA"]
["MISC. ATTACH CABLES TO TL-4 POST  HT - GIBRALTAR",79,6069902,"EA"]
["MISC. ANCHOR POST",868,6069902,"EA"]
["MISC. ANCHOR TERMINAL FITTING",188,6069902,"EA"]
["MISC. ATTACH NEW CABLE RELEASE POST",560,6069902,"EA"]
["MISC. REATTACH EXIST CRP ANCH POST TO BASE-GIBRALTAR",193,6069902,"EA"]
["MISC. CABLE SPLICE TURNBUCKLE",314,6069902,"EA"]
["MISC. R&R ANCHOR POST ",151,6069902,"EA"]
["MISC. R&R LINE POST CONC FTG W/ SLEEVE HT- GIBRALTAR",267,6069902,"EA"]
["MISC. R&R LINE POST IN ROCK HT",356,6069902,"EA"]
["MISC. R&R LINE POST ",112,6069902,"EA"]
["MISC. REALIGN LINE POST HT",18,6069902,"EA"]
["MISC. REPLACE GUARD CABLE DELINEATOR",11,6069902,"EA"]
["MISC. RETENSION HIGH TENSION CABLES  HT",175,6069902,"EA"]
["MISC. SPLICE 3/4 INCH CABLE 1/S - HT",219,6069902,"EA"]
["MISC. TERMINAL POST #1/ WEAK",111,6069902,"EA"]
["MISC. TERMINAL POST #2/ WEAK",111,6069902,"EA"]
["MISC. TL-3 TERMINAL POST #3&4/ WEAK",118,6069902,"EA"]
["MISC. TL-4 TERMINAL POST #3&4/ WEAK",118,6069902,"EA"]
["MISC. TL-3 LINE POST DRIVEN",130,6069902,"EA"]
["MISC. TL-3 LINE POST SOCKETED",95,6069902,"EA"]
["MISC. TL-4 LINE POST DRIVEN",142,6069902,"EA"]
["MISC. TL-4 LINE POST SOCKETED",113,6069902,"EA"]
["MISC. 3/4 INCH CABLE 1/S - HT",8,6069903,"LF"]
["MISC. HIGH TENSION SAFETY FENCE, TL-3",26,6069903,"LF"]
["MISC. HIGH TENSION SAFETY FENCE, TL-4",33,6069903,"LF"]

{"sheet":"Guardrail","index":2,"n_rows":118,"n_cols":14,"rows_kept":118,"cut":false,"hidden":false,"merged":[[9,2,9,3],[6,10,6,11],[11,5,13,8],[11,4,13,4],[57,1,57,2],[50,1,50,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[83,1,83,2],[83,3,83,4],[73,1,73,2],[73,3,73,4],[63,1,63,2],[63,3,63,4],[59,1,59,2],[59,3,59,4],[50,3,50,4],[83,8,83,9],[75,1,75,2],[75,3,75,4],[75,8,75,9],[76,8,76,9],[79,3,79,4],[80,1,80,2],[80,3,80,4],[80,8,80,9],[81,1,81,2],[81,3,81,4],[81,8,81,9],[82,1,82,2],[82,3,82,4],[82,8,82,9],[95,3,95,4],[95,8,95,9],[96,8,96,9],[98,8,98,9],[93,1,93,2],[93,3,93,4],[93,8,93,9],[94,1,94,2],[94,3,94,4],[94,8,94,9],[97,1,97,11],[91,1,91,2],[91,3,91,4],[91,8,91,9],[101,7,101,8],[100,3,100,5],[101,3,101,5],[111,6,111,9],[107,2,107,4],[107,8,107,9],[108,2,108,4],[108,8,108,9],[109,8,109,9],[102,6,102,8],[104,2,104,4],[104,8,104,9],[105,2,105,4],[105,8,105,9],[106,2,106,4],[106,8,106,9],[92,1,92,2],[92,3,92,4],[92,8,92,9],[100,7,100,8],[95,1,95,2],[90,1,90,2],[90,3,90,4],[90,8,90,9],[88,8,88,9],[89,8,89,9],[88,3,88,4],[89,3,89,4],[88,1,88,2],[89,1,89,2],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[84,1,84,2],[73,8,73,9],[74,1,74,2],[74,3,74,4],[74,8,74,9],[67,1,67,2],[67,3,67,4],[67,8,67,9],[72,1,72,2],[72,3,72,4],[72,8,72,9],[68,1,68,2],[69,1,69,2],[70,1,70,2],[71,1,71,2],[68,3,68,4],[69,3,69,4],[71,3,71,4],[70,3,70,4],[68,8,68,9],[69,8,69,9],[70,8,70,9],[71,8,71,9],[63,8,63,9],[64,8,64,9],[65,3,65,4],[66,1,66,2],[66,3,66,4],[66,8,66,9],[61,1,61,2],[61,3,61,4],[61,8,61,9],[62,1,62,2],[62,3,62,4],[62,8,62,9],[59,8,59,9],[60,1,60,2],[60,3,60,4],[60,8,60,9],[52,1,52,2],[52,3,52,4],[52,8,52,9],[53,1,53,2],[53,3,53,4],[53,8,53,9],[54,8,54,9],[55,8,55,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[58,1,58,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[50,8,50,9],[51,1,51,2],[51,3,51,4],[51,8,51,9],[46,1,46,2],[46,3,46,4],[46,8,46,9],[47,8,47,9],[48,3,48,4],[49,1,49,2],[49,3,49,4],[49,8,49,9],[39,1,39,2],[39,3,39,4],[39,8,39,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[44,8,44,9],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[38,1,38,2],[38,3,38,4],[38,8,38,9],[35,1,35,2],[35,3,35,4],[35,8,35,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[22,10,22,11],[23,1,23,2],[23,3,23,4],[23,8,23,9],[24,1,24,2],[24,3,24,4],[24,8,24,9],[37,1,37,2],[37,3,37,4],[37,8,37,9],[27,3,27,4],[27,8,27,9],[25,1,25,2],[25,3,25,4],[25,8,25,9],[26,1,26,2],[26,3,26,4],[26,8,26,9],[22,3,22,4],[8,2,8,3],[9,5,9,6],[14,1,15,1],[11,2,11,3],[13,2,13,3],[11,9,11,10],[33,1,33,2],[33,3,33,4],[33,8,33,9],[29,1,29,2],[29,3,29,4],[29,8,29,9],[30,8,30,9],[31,3,31,4],[32,1,32,2],[32,3,32,4],[32,8,32,9],[18,10,18,11],[19,1,20,2],[19,3,20,4],[19,5,20,5],[19,8,19,9],[20,8,20,9],[27,1,27,2],[5,10,5,11],[4,8,4,9],[0,1,0,11],[1,1,1,11],[5,2,5,3],[7,5,7,6],[3,2,3,3],[4,2,4,3],[3,10,3,11],[4,10,4,11],[6,2,6,3],[7,2,7,3],[114,10,114,11],[115,10,115,11],[116,10,116,11],[16,2,16,11],[17,2,17,11],[12,9,12,10],[13,9,13,10],[14,2,15,11],[12,2,12,3],[115,1,115,2],[115,3,115,4],[115,5,115,9],[116,1,116,2],[116,3,116,4],[116,5,116,9],[114,1,114,2],[114,3,114,4],[114,5,114,9],[28,1,28,2],[28,3,28,4],[28,8,28,9],[34,1,34,2],[34,3,34,4],[34,8,34,9]]}
[null,"Missouri Department of Transportation"]
[null,"2026 Guardrail Job Order"]
[]
[null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,null,null,null,null,null,"K Number (MoDOT Property Damage Number):"]
[null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,null,null,null,null,"Date of Issuance"]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,null,"Proposed Notice to Proceed:"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,null,"Completion Date:"]
[null,"Police Department:","SELECT",null,null,"First Priority?",null,null,null,null,"Daytime","Nighttime"]
[null,"PD Report #",null,null,null,null,null,null,null,null,false,false]
[null,"Call Report Number",null,null,null,"Yes, if checked"]
[]
[null,"County:","SELECT",null,"Location Description:",null,null,null,null,"Mile Marker:"]
[null,"Route:",null,null,null,null,null,null,null,"GPS Latitude:"]
[null,"Direction (N,S,E,W)","SELECT",null,null,null,null,null,null,"GPS Longitude:"]
[null,"Description of Work:"]
[]
[null,"Restrictions:"]
[null,"Remarks/Comments (to include any speed limit reductions and or working hour restrictions):"]
[null,null,null,null,null,null,null,null,null,null,"Contractor Info"]
[null,"Item Code",null,"Pay Item Description",null,"Unit ","Estimated ","Contract","Estimated ",null,"Final","Final"]
[null,null,null,null,null,null,"Quantity","Unit Price","Price",null,"Quantity","Price"]
[]
[null,null,null,{"$f":"'Contract Data'!A3","v":"MISC. TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D24>0,VLOOKUP(D24,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},{"$f":"G24*H24","v":0},null,null,{"$f":"K24*H24","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D25>0,VLOOKUP(D25,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},{"$f":"G25*H25","v":0},null,null,{"$f":"K25*H25","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D26>0,VLOOKUP(D26,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D27>0,VLOOKUP(D27,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D28>0,VLOOKUP(D28,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D29>0,VLOOKUP(D29,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D30>0,VLOOKUP(D30,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I24:J30)","v":0},null,null,{"$f":"SUM(L24:L30)","v":0}]
[null,"Guardrail ",null,"NEW GUARDRAIL INSTALLATION ITEMS"]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},{"$f":"G33*H33","v":0},null,null,{"$f":"H33*K33","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},{"$f":"G34*H34","v":0},null,null,{"$f":"H34*K34","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},{"$f":"G41*H41","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$26:$D$62,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$26:$D$62,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$26:$D$62,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$26:$D$62,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$26:$D$62,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I33:J47)","v":0},null,null,{"$f":"SUM(L33:L47)","v":0}]
[null,"Guardrail ",null,{"$f":"'Contract Data'!A63","v":"GUARDRAIL REPAIR ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},{"$f":"G50*H50","v":0},null,null,{"$f":"H50*K50","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},{"$f":"G51*H51","v":0},null,null,{"$f":"H51*K51","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D54>0,VLOOKUP(D54,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D55,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D55,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D55,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D55,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D55>0,VLOOKUP(D55,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},{"$f":"G55*H55","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D56,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D56,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D56,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D56,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D56>0,VLOOKUP(D56,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D57,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D57,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D57,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D57,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D57>0,VLOOKUP(D57,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D58,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D58,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D58,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D58,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D58>0,VLOOKUP(D58,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D59,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D59,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D59,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D59,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D59>0,VLOOKUP(D59,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D60,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D60,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D60,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D60,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D60>0,VLOOKUP(D60,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D61,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D61,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D61,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D61,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D61>0,VLOOKUP(D61,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D62,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D62,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D62,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D62,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D62>0,VLOOKUP(D62,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D63,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D63,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D63,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D63,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D63>0,VLOOKUP(D63,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D64,'Contract Data'!$A$64:$D$109,3,FALSE)),\"\",VLOOKUP(D64,'Contract Data'!$A$64:$D$109,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D64,'Contract Data'!$A$64:$D$109,4,FALSE)),\"\",VLOOKUP(D64,'Contract Data'!$A$64:$D$109,4,FALSE))","v":""},null,{"$f":"IF(D64>0,VLOOKUP(D64,'Contract Data'!$A$64:$B$109,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I50:J64)","v":0},null,null,{"$f":"SUM(L50:L64)","v":0}]
[null,"Guardrail ",null,{"$f":"'Contract Data'!A110","v":"BULLNOSE SYSTEM REPAIR ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D67,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D67,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D67,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D67,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D67>0,VLOOKUP(D67,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},{"$f":"G67*H67","v":0},null,null,{"$f":"H67*K67","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D68,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D68,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D68,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D68,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D68>0,VLOOKUP(D68,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},{"$f":"G68*H68","v":0},null,null,{"$f":"H68*K68","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D69,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D69,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D69,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D69,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D69>0,VLOOKUP(D69,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},{"$f":"G69*H69","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D70,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D70,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D70,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D70,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D70>0,VLOOKUP(D70,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},{"$f":"G70*H70","v":0},null,null,{"$f":"H70*K70","v":0}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(D71,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D71,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D71>0,VLOOKUP(D71,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D72,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D72,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D72,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D72,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D72>0,VLOOKUP(D72,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D73,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D73,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D73,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D73,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D73>0,VLOOKUP(D73,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D74,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D74,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D74,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D74,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D74>0,VLOOKUP(D74,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D75,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D75,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D75,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D75,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D75>0,VLOOKUP(D75,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D76,'Contract Data'!$A$111:$D$120,3,FALSE)),\"\",VLOOKUP(D76,'Contract Data'!$A$111:$D$120,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D76,'Contract Data'!$A$111:$D$120,4,FALSE)),\"\",VLOOKUP(D76,'Contract Data'!$A$111:$D$120,4,FALSE))","v":""},null,{"$f":"IF(D76>0,VLOOKUP(D76,'Contract Data'!$A$111:$B$120,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I67:J76)","v":0},null,null,{"$f":"SUM(L67:L76)","v":0}]
[]
[]
[null,"Guardrail ",null,{"$f":"'Contract Data'!A121","v":"END TERMINAL REPAIR ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D81,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D81,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D81,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D81,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D81>0,VLOOKUP(D81,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},{"$f":"G81*H81","v":0},null,null,{"$f":"H81*K81","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D82,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D82,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D82,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D82,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D82>0,VLOOKUP(D82,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},{"$f":"G82*H82","v":0},null,null,{"$f":"H82*K82","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D83,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D83,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D83,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D83,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D83>0,VLOOKUP(D83,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D84,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D84,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D84,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D84,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D84>0,VLOOKUP(D84,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D85,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D85,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D85,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D85,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D85>0,VLOOKUP(D85,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},{"$f":"G85*H85","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D86,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D86,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D86,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D86,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D86>0,VLOOKUP(D86,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D87,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D87,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D87,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D87,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D87>0,VLOOKUP(D87,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D88,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D88,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D88,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D88,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D88>0,VLOOKUP(D88,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D89,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D89,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D89,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D89,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D89>0,VLOOKUP(D89,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D90,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D90,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D90,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D90,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D90>0,VLOOKUP(D90,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D91,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D91,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D91,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D91,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D91>0,VLOOKUP(D91,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D92,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D92,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D92,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D92,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D92>0,VLOOKUP(D92,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D93,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D93,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D93,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D93,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D93>0,VLOOKUP(D93,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D94,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D94,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D94,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D94,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D94>0,VLOOKUP(D94,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D95,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D95,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D95,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D95,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D95>0,VLOOKUP(D95,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D96,'Contract Data'!$A$122:$D$154,3,FALSE)),\"\",VLOOKUP(D96,'Contract Data'!$A$122:$D$154,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D96,'Contract Data'!$A$122:$D$154,4,FALSE)),\"\",VLOOKUP(D96,'Contract Data'!$A$122:$D$154,4,FALSE))","v":""},null,{"$f":"IF(D96>0,VLOOKUP(D96,'Contract Data'!$A$122:$B$154,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I81:J96)","v":0},null,null,{"$f":"SUM(L81:L96)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"SUM(I31+I48+I65+I77+I97)","v":0},null,null,{"$f":"SUM(L31+L48+L65+L77+L97)","v":0},null,"Enter into AWP in the Quantity Field for the Correct Line "]
[]
[null,null,null,"Adjustment Factors",null,null,"Factor","Estimated Subtotal",null,"Est. Adj.\nSubtotal","Final Subtotal","Final Adj.\nSubtotal"]
[null,null,null,"Adjustment Factor",null,null,{"$f":"'Contract Data'!J2","v":0},{"$f":"I99","v":0},null,{"$f":"G102*H102","v":0},{"$f":"L99","v":0},{"$f":"G102*K102","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J102:J102)","v":0},null,{"$f":"SUM(L102:L102)","v":0}]
[null,"Contingent Items"]
[null,"Item","Pay Item Description",null,null,"Unit","Estimated\nQuantity","Unit Price","Estimated Price",null,"Final\nQuantity","Final Price"]
[null,null,null,null,null,null,null,null,{"$f":"G106*H106","v":0},null,null,{"$f":"H106*K106","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G107*H107","v":0},null,null,{"$f":"H107*K107","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,"Contingent Items Subtotal",{"$f":"SUM(I106:J109)","v":0},null,null,{"$f":"SUM(L106:L109)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Estimated","Final"]
[null,null,null,null,null,null,"  Total Job Price",null,null,null,{"$f":"SUM(J103+I110)","v":0},{"$f":"SUM(L103+L110)","v":0}]
[]
[]
[null,null,null,"Responsible Person",null,null,null,null,null,null,"Date"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor (type in)"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT (PDF Signature when complete)"]
[null,"NOTE:  Italicized entries are \"ONLY IF APPLICABLE\" and may remain blank if not needed."]

{"sheet":"GC_LowTension","index":3,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,1,68,2],[68,3,68,4],[68,5,68,9],[68,10,68,11],[66,1,66,2],[66,3,66,4],[66,5,66,9],[66,10,66,11],[67,1,67,2],[67,3,67,4],[67,5,67,9],[67,10,67,11],[64,6,64,9],[31,3,31,6],[49,8,49,9],[59,2,59,4],[59,8,59,9],[60,8,60,9],[56,2,56,4],[56,8,56,9],[57,2,57,4],[57,8,57,9],[58,2,58,4],[58,8,58,9],[53,6,53,8],[55,2,55,4],[55,8,55,9],[52,7,52,8],[48,1,48,11],[51,7,51,8],[46,1,46,2],[45,8,45,9],[43,1,43,2],[52,3,52,5],[51,3,51,5],[37,1,37,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[40,3,40,4],[41,3,41,4],[42,3,42,4],[40,8,40,9],[41,8,41,9],[42,8,42,9],[46,3,46,4],[46,8,46,9],[47,8,47,9],[39,1,39,2],[39,3,39,4],[39,8,39,9],[45,1,45,2],[45,3,45,4],[35,1,35,2],[35,3,35,4],[35,8,35,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[44,1,44,2],[43,3,43,4],[44,3,44,4],[43,8,43,9],[44,8,44,9],[37,3,37,4],[37,8,37,9],[38,1,38,2],[38,3,38,4],[38,8,38,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[29,1,29,2],[29,3,29,4],[29,8,29,9],[30,8,30,9],[32,1,32,2],[32,3,32,4],[32,8,32,9],[27,3,27,4],[27,8,27,9],[28,1,28,2],[28,3,28,4],[28,8,28,9],[25,1,25,2],[25,3,25,4],[25,8,25,9],[26,1,26,2],[26,3,26,4],[26,8,26,9],[0,1,0,11],[1,1,1,11],[6,2,6,3],[12,2,12,3],[3,2,3,3],[3,10,3,11],[4,2,4,3],[4,8,4,9],[4,10,4,11],[5,2,5,3],[5,10,5,11],[11,9,11,10],[12,9,12,10],[11,2,11,3],[6,10,6,11],[9,2,9,3],[7,2,7,3],[8,2,8,3],[9,5,9,6],[70,1,70,11],[11,4,13,4],[11,5,13,8],[16,2,16,11],[14,1,15,1],[14,2,15,11],[17,2,17,11],[13,2,13,3],[13,9,13,10],[22,3,22,4],[22,10,22,11],[23,1,23,2],[23,3,23,4],[23,8,23,9],[24,1,24,2],[24,3,24,4],[24,8,24,9],[18,10,18,11],[19,1,20,2],[19,3,20,4],[19,5,20,5],[19,8,19,9],[20,8,20,9],[27,1,27,2]]}
[null,"Missouri Department of Transportation"]
[null,"2026 Guard Cable Job Order"]
[]
[null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,null,null,null,null,null,"K Number (MoDOT Property Damage Number):"]
[null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,null,null,null,null,"Date of Issuance"]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,null,"Proposed Notice to Proceed:"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,null,"Completion Date:"]
[null,"Police Department:","SELECT",null,null,null,null,null,null,null,"Daytime","Nighttime"]
[null,"PD Report #",null,null,null,null,null,null,null,null,false,false]
[null,"Call Report Number"]
[]
[null,"County:","SELECT",null,"Location Description:",null,null,null,null,"Mile Marker:"]
[null,"Route:",null,null,null,null,null,null,null,"GPS Latitude:"]
[null,"Direction (N,S,E,W)","SELECT",null,null,null,null,null,null,"GPS Longitude:"]
[null,"Description of Work:"]
[]
[null,"Restrictions:"]
[null,"Remarks/Comments (to include any speed limit reductions and or working hour restrictions):"]
[null,null,null,null,null,null,null,null,null,null,"Contractor Info"]
[null,"Item Code",null,"Pay Item Description",null,"Unit ","Estimated ","Contract","Estimated ",null,"Final","Final"]
[null,null,null,null,null,null,"Quantity","Unit Price","Price",null,"Quantity","Price"]
[]
[null,null,null,{"$f":"'Contract Data'!A3","v":"MISC. TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D24>0,VLOOKUP(D24,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G24*H24","v":0},null,null,{"$f":"K24*H24","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D25>0,VLOOKUP(D25,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G25*H25","v":0},null,null,{"$f":"K25*H25","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D26>0,VLOOKUP(D26,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D27>0,VLOOKUP(D27,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D28>0,VLOOKUP(D28,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D29>0,VLOOKUP(D29,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D30>0,VLOOKUP(D30,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I24:J30)","v":0},null,null,{"$f":"SUM(L24:L30)","v":0}]
[null,"Guard Cable",null,{"$f":"'Contract Data'!A171","v":"LOW TENSION GUARD CABLE REPAIR AND REPLACEMENT"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},{"$f":"G33*H33","v":0},null,null,{"$f":"H33*K33","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},{"$f":"G34*H34","v":0},null,null,{"$f":"H34*K34","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},{"$f":"G41*H41","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$172:$D$192,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$172:$D$192,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$172:$D$192,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$172:$D$192,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$172:$D$192,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I33:J47)","v":0},null,null,{"$f":"SUM(L33:L47)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"SUM(I31+I48)","v":0},null,null,{"$f":"SUM(L31+L48)","v":0},null,"Enter into AWP in the Quantity Field for the Correct Line"]
[]
[null,null,null,"Adjustment Factors",null,null,"Factor","Estimated Subtotal",null,"Est. Adj.\nSubtotal","Final Subtotal","Final Adj.\nSubtotal"]
[null,null,null," Adjustment Factor",null,null,{"$f":"'Contract Data'!J2","v":0},{"$f":"I50","v":0},null,{"$f":"G53*H53","v":0},{"$f":"L50","v":0},{"$f":"G53*K53","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J53:J53)","v":0},null,{"$f":"SUM(L53:L53)","v":0}]
[null,"Contingent Items"]
[null,"Item","Pay Item Description",null,null,"Unit","Estimated\nQuantity","Unit Price","Estimated Price",null,"Final\nQuantity","Final Price"]
[null,null,null,null,null,null,null,null,{"$f":"G57*H57","v":0},null,null,{"$f":"H57*K57","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G58*H58","v":0},null,null,{"$f":"H58*K58","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,"Contingent Items Subtotal",{"$f":"SUM(I57:J60)","v":0},null,null,{"$f":"SUM(L57:L60)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Estimated","Final"]
[null,null,null,null,null,null,"  Total Job Price",null,null,null,{"$f":"SUM(J54+I61)","v":0},{"$f":"SUM(L54+L61)","v":0}]
[]
[null,null,null,"Responsible Person",null,null,null,null,null,null,"Date"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor (type in)"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT (PDF Signature when complete)"]
[null,"NOTE:  Italicized entries are \"ONLY IF APPLICABLE\" and may remain blank if not needed."]

{"sheet":"GC_Gibraltar","index":4,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[52,3,52,5],[64,6,64,9],[49,8,49,9],[59,2,59,4],[59,8,59,9],[60,8,60,9],[56,2,56,4],[56,8,56,9],[57,2,57,4],[57,8,57,9],[58,2,58,4],[58,8,58,9],[53,6,53,8],[55,2,55,4],[55,8,55,9],[52,7,52,8],[51,3,51,5],[46,1,46,2],[46,3,46,4],[46,8,46,9],[47,8,47,9],[48,1,48,11],[51,7,51,8],[44,1,44,2],[44,3,44,4],[44,8,44,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[37,1,37,2],[37,3,37,4],[37,8,37,9],[38,1,38,2],[38,3,38,4],[38,8,38,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[35,1,35,2],[35,3,35,4],[35,8,35,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[29,1,29,2],[29,3,29,4],[29,8,29,9],[30,8,30,9],[31,3,31,6],[32,1,32,2],[32,3,32,4],[32,8,32,9],[27,1,27,2],[27,3,27,4],[27,8,27,9],[28,1,28,2],[28,3,28,4],[28,8,28,9],[25,1,25,2],[25,3,25,4],[25,8,25,9],[26,1,26,2],[26,3,26,4],[26,8,26,9],[22,3,22,4],[22,10,22,11],[23,1,23,2],[23,3,23,4],[23,8,23,9],[24,1,24,2],[24,3,24,4],[24,8,24,9],[16,2,16,11],[14,1,15,1],[14,2,15,11],[17,2,17,11],[18,10,18,11],[19,1,20,2],[19,3,20,4],[19,5,20,5],[19,8,19,9],[20,8,20,9],[13,2,13,3],[11,2,11,3],[11,4,13,4],[11,5,13,8],[11,9,11,10],[12,9,12,10],[13,9,13,10],[0,1,0,11],[1,1,1,11],[6,2,6,3],[12,2,12,3],[3,2,3,3],[3,10,3,11],[4,2,4,3],[4,8,4,9],[4,10,4,11],[5,2,5,3],[5,10,5,11],[6,10,6,11],[9,2,9,3],[7,2,7,3],[8,2,8,3],[9,5,9,6],[70,1,70,11],[66,1,66,2],[66,3,66,4],[66,5,66,9],[66,10,66,11],[67,1,67,2],[67,3,67,4],[67,5,67,9],[67,10,67,11],[68,1,68,2],[68,3,68,4],[68,5,68,9],[68,10,68,11]]}
[null,"Missouri Department of Transportation"]
[null,"2026 Guard Cable Job Order"]
[]
[null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,null,null,null,null,null,"K Number (MoDOT Property Damage Number):"]
[null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,null,null,null,null,"Date of Issuance"]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,null,"Proposed Notice to Proceed:"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,null,"Completion Date:"]
[null,"Police Department:","SELECT",null,null,null,null,null,null,null,"Daytime","Nighttime"]
[null,"PD Report #",null,null,null,null,null,null,null,null,false,false]
[null,"Call Report Number"]
[]
[null,"County:","SELECT",null,"Location Description:",null,null,null,null,"Mile Marker:"]
[null,"Route:",null,null,null,null,null,null,null,"GPS Latitude:"]
[null,"Direction (N,S,E,W)","SELECT",null,null,null,null,null,null,"GPS Longitude:"]
[null,"Description of Work:"]
[]
[null,"Restrictions:"]
[null,"Remarks/Comments (to include any speed limit reductions and or working hour restrictions):"]
[null,null,null,null,null,null,null,null,null,null,"Contractor Info"]
[null,"Item Code",null,"Pay Item Description",null,"Unit ","Estimated ","Contract","Estimated ",null,"Final","Final"]
[null,null,null,null,null,null,"Quantity","Unit Price","Price",null,"Quantity","Price"]
[]
[null,null,null,{"$f":"'Contract Data'!A3","v":"MISC. TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D24>0,VLOOKUP(D24,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G24*H24","v":0},null,null,{"$f":"K24*H24","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D25>0,VLOOKUP(D25,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G25*H25","v":0},null,null,{"$f":"K25*H25","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D26>0,VLOOKUP(D26,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D27>0,VLOOKUP(D27,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D28>0,VLOOKUP(D28,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D29>0,VLOOKUP(D29,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D30>0,VLOOKUP(D30,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I24:J30)","v":0},null,null,{"$f":"SUM(L24:L30)","v":0}]
[null,"Guard Cable",null,{"$f":"'Contract Data'!A218","v":"HIGH TENSION GUARD CABLE BARRIER REPAIR & REPLACEMENT - GIBRALTAR"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},{"$f":"G33*H33","v":0},null,null,{"$f":"H33*K33","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},{"$f":"G34*H34","v":0},null,null,{"$f":"H34*K34","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},{"$f":"G40*H40","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$219:$D$247,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$219:$D$247,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$219:$D$247,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$219:$D$247,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$219:$D$247,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I33:J47)","v":0},null,null,{"$f":"SUM(L33:L47)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"I31+I48","v":0},null,null,{"$f":"SUM(L31+L48)","v":0},null,"Enter into AWP in the Quantity Field for the Correct Line "]
[]
[null,null,null,"Adjustment Factors",null,null,"Factor","Estimated Subtotal",null,"Est. Adj.\nSubtotal","Final Subtotal","Final Adj.\nSubtotal"]
[null,null,null," Adjustment Factor",null,null,{"$f":"'Contract Data'!J2","v":0},{"$f":"I50","v":0},null,{"$f":"G53*H53","v":0},{"$f":"L50","v":0},{"$f":"G53*K53","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J53:J53)","v":0},null,{"$f":"SUM(L53:L53)","v":0}]
[null,"Contingent Items"]
[null,"Item","Pay Item Description",null,null,"Unit","Estimated\nQuantity","Unit Price","Estimated Price",null,"Final\nQuantity","Final Price"]
[null,null,null,null,null,null,null,null,{"$f":"G57*H57","v":0},null,null,{"$f":"H57*K57","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G58*H58","v":0},null,null,{"$f":"H58*K58","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,"Contingent Items Subtotal",{"$f":"SUM(I57:J60)","v":0},null,null,{"$f":"SUM(L57:L60)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Estimated","Final"]
[null,null,null,null,null,null,"  Total Job Price",null,null,null,{"$f":"SUM(J54+I61)","v":0},{"$f":"SUM(L54+L61)","v":0}]
[]
[null,null,null,"Responsible Person",null,null,null,null,null,null,"Date"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor (type in)"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT (PDF Signature when complete)"]
[null,"NOTE:  Italicized entries are \"ONLY IF APPLICABLE\" and may remain blank if not needed."]

{"sheet":"GC_Valtir","index":5,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[52,3,52,5],[64,6,64,9],[49,8,49,9],[59,2,59,4],[59,8,59,9],[60,8,60,9],[56,2,56,4],[56,8,56,9],[57,2,57,4],[57,8,57,9],[58,2,58,4],[58,8,58,9],[53,6,53,8],[55,2,55,4],[55,8,55,9],[52,7,52,8],[51,3,51,5],[46,1,46,2],[46,3,46,4],[46,8,46,9],[47,8,47,9],[48,1,48,11],[51,7,51,8],[44,1,44,2],[44,3,44,4],[44,8,44,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[37,1,37,2],[37,3,37,4],[37,8,37,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[35,1,35,2],[35,3,35,4],[35,8,35,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[29,1,29,2],[29,3,29,4],[29,8,29,9],[30,8,30,9],[31,3,31,6],[32,1,32,2],[32,3,32,4],[32,8,32,9],[27,1,27,2],[27,3,27,4],[27,8,27,9],[28,1,28,2],[28,3,28,4],[28,8,28,9],[25,1,25,2],[25,3,25,4],[25,8,25,9],[26,1,26,2],[26,3,26,4],[26,8,26,9],[22,3,22,4],[22,10,22,11],[23,1,23,2],[23,3,23,4],[23,8,23,9],[24,1,24,2],[24,3,24,4],[24,8,24,9],[16,2,16,11],[14,1,15,1],[14,2,15,11],[17,2,17,11],[18,10,18,11],[19,1,20,2],[19,3,20,4],[19,5,20,5],[19,8,19,9],[20,8,20,9],[13,2,13,3],[11,2,11,3],[11,4,13,4],[11,5,13,8],[11,9,11,10],[12,9,12,10],[13,9,13,10],[0,1,0,11],[1,1,1,11],[6,2,6,3],[12,2,12,3],[3,2,3,3],[3,10,3,11],[4,2,4,3],[4,8,4,9],[4,10,4,11],[5,2,5,3],[5,10,5,11],[6,10,6,11],[9,2,9,3],[7,2,7,3],[8,2,8,3],[9,5,9,6],[70,1,70,11],[66,1,66,2],[66,3,66,4],[66,5,66,9],[66,10,66,11],[67,1,67,2],[67,3,67,4],[67,5,67,9],[67,10,67,11],[68,1,68,2],[68,3,68,4],[68,5,68,9],[68,10,68,11]]}
[null,"Missouri Department of Transportation"]
[null,"2026 Guard Cable Job Order"]
[]
[null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,null,null,null,null,null,"K Number (MoDOT Property Damage Number):"]
[null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,null,null,null,null,"Date of Issuance"]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,null,"Proposed Notice to Proceed:"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,null,"Completion Date:"]
[null,"Police Department:","SELECT",null,null,null,null,null,null,null,"Daytime","Nighttime"]
[null,"PD Report #",null,null,null,null,null,null,null,null,false,false]
[null,"Call Report Number"]
[]
[null,"County:","SELECT",null,"Location Description:",null,null,null,null,"Mile Marker:"]
[null,"Route:",null,null,null,null,null,null,null,"GPS Latitude:"]
[null,"Direction (N,S,E,W)","SELECT",null,null,null,null,null,null,"GPS Longitude:"]
[null,"Description of Work:"]
[]
[null,"Restrictions:"]
[null,"Remarks/Comments (to include any speed limit reductions and or working hour restrictions):"]
[null,null,null,null,null,null,null,null,null,null,"Contractor Info"]
[null,"Item Code",null,"Pay Item Description",null,"Unit ","Estimated ","Contract","Estimated ",null,"Final","Final"]
[null,null,null,null,null,null,"Quantity","Unit Price","Price",null,"Quantity","Price"]
[]
[null,null,null,{"$f":"'Contract Data'!A3","v":"MISC. TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D24>0,VLOOKUP(D24,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G24*H24","v":0},null,null,{"$f":"K24*H24","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D25>0,VLOOKUP(D25,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G25*H25","v":0},null,null,{"$f":"K25*H25","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D26>0,VLOOKUP(D26,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D27>0,VLOOKUP(D27,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D28>0,VLOOKUP(D28,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D29>0,VLOOKUP(D29,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D30>0,VLOOKUP(D30,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I24:J30)","v":0},null,null,{"$f":"SUM(L24:L30)","v":0}]
[null,"Guard Cable",null,{"$f":"'Contract Data'!A194","v":"HIGH TENSION GUARD CABLE BARRIER REPAIR AND REPLACEMENT - VALTIR"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},{"$f":"G33*H33","v":0},null,null,{"$f":"H33*K33","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},{"$f":"G34*H34","v":0},null,null,{"$f":"H34*K34","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},{"$f":"G39*H39","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$195:$D$216,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$195:$D$216,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$195:$D$216,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$195:$D$216,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$195:$D$216,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I33:J47)","v":0},null,null,{"$f":"SUM(L33:L47)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"I31+I48","v":0},null,null,{"$f":"SUM(L31+L48)","v":0},null,"Enter into AWP in the Quantity Field for the Correct Line"]
[]
[null,null,null,"Adjustment Factors",null,null,"Factor","Estimated Subtotal",null,"Est. Adj.\nSubtotal","Final Subtotal","Final Adj.\nSubtotal"]
[null,null,null," Adjustment Factor",null,null,{"$f":"'Contract Data'!J2","v":0},{"$f":"I50","v":0},null,{"$f":"G53*H53","v":0},{"$f":"L50","v":0},{"$f":"G53*K53","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J53:J53)","v":0},null,{"$f":"SUM(L53:L53)","v":0}]
[null,"Contingent Items"]
[null,"Item","Pay Item Description",null,null,"Unit","Estimated\nQuantity","Unit Price","Estimated Price",null,"Final\nQuantity","Final Price"]
[null,null,null,null,null,null,null,null,{"$f":"G57*H57","v":0},null,null,{"$f":"H57*K57","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G58*H58","v":0},null,null,{"$f":"H58*K58","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,"Contingent Items Subtotal",{"$f":"SUM(I57:J60)","v":0},null,null,{"$f":"SUM(L57:L60)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Estimated","Final"]
[null,null,null,null,null,null,"  Total Job Price",null,null,null,{"$f":"SUM(J54+I61)","v":0},{"$f":"SUM(L54+L61)","v":0}]
[]
[null,null,null,"Responsible Person",null,null,null,null,null,null,"Date"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor (type in)"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT (PDF Signature when complete)"]
[null,"NOTE:  Italicized entries are \"ONLY IF APPLICABLE\" and may remain blank if not needed."]

{"sheet":"GC_Access_Restraint","index":6,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[52,3,52,5],[64,6,64,9],[49,8,49,9],[59,2,59,4],[59,8,59,9],[60,8,60,9],[56,2,56,4],[56,8,56,9],[57,2,57,4],[57,8,57,9],[58,2,58,4],[58,8,58,9],[53,6,53,8],[55,2,55,4],[55,8,55,9],[52,7,52,8],[51,3,51,5],[46,1,46,2],[46,3,46,4],[46,8,46,9],[47,8,47,9],[48,1,48,11],[51,7,51,8],[44,1,44,2],[44,3,44,4],[44,8,44,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[37,1,37,2],[37,3,37,4],[37,8,37,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[35,1,35,2],[35,3,35,4],[35,8,35,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[29,1,29,2],[29,3,29,4],[29,8,29,9],[30,8,30,9],[31,3,31,6],[32,1,32,2],[32,3,32,4],[32,8,32,9],[27,1,27,2],[27,3,27,4],[27,8,27,9],[28,1,28,2],[28,3,28,4],[28,8,28,9],[25,1,25,2],[25,3,25,4],[25,8,25,9],[26,1,26,2],[26,3,26,4],[26,8,26,9],[22,3,22,4],[22,10,22,11],[23,1,23,2],[23,3,23,4],[23,8,23,9],[24,1,24,2],[24,3,24,4],[24,8,24,9],[16,2,16,11],[14,1,15,1],[14,2,15,11],[17,2,17,11],[18,10,18,11],[19,1,20,2],[19,3,20,4],[19,5,20,5],[19,8,19,9],[20,8,20,9],[13,2,13,3],[11,2,11,3],[11,4,13,4],[11,5,13,8],[11,9,11,10],[12,9,12,10],[13,9,13,10],[0,1,0,11],[1,1,1,11],[6,2,6,3],[12,2,12,3],[3,2,3,3],[3,10,3,11],[4,2,4,3],[4,8,4,9],[4,10,4,11],[5,2,5,3],[5,10,5,11],[6,10,6,11],[9,2,9,3],[7,2,7,3],[8,2,8,3],[9,5,9,6],[66,1,66,2],[66,3,66,4],[66,5,66,9],[66,10,66,11],[67,1,67,2],[67,3,67,4],[67,5,67,9],[67,10,67,11],[68,1,68,2],[68,3,68,4],[68,5,68,9],[68,10,68,11]]}
[null,"Missouri Department of Transportation"]
[null,"2026 Guard Cable Job Order"]
[]
[null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,null,null,null,null,null,"K Number (MoDOT Property Damage Number):"]
[null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,null,null,null,null,"Date of Issuance"]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,null,"Proposed Notice to Proceed:"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,null,"Completion Date:"]
[null,"Police Department:","SELECT",null,null,null,null,null,null,null,"Daytime","Nighttime"]
[null,"PD Report #",null,null,null,null,null,null,null,null,false,false]
[null,"Call Report Number"]
[]
[null,"County:","SELECT",null,"Location Description:",null,null,null,null,"Mile Marker:"]
[null,"Route:",null,null,null,null,null,null,null,"GPS Latitude:"]
[null,"Direction (N,S,E,W)","SELECT",null,null,null,null,null,null,"GPS Longitude:"]
[null,"Description of Work:"]
[]
[null,"Restrictions:"]
[null,"Remarks/Comments (to include any speed limit reductions and or working hour restrictions):"]
[null,null,null,null,null,null,null,null,null,null,"Contractor Info"]
[null,"Item Code",null,"Pay Item Description",null,"Unit ","Estimated ","Contract","Estimated ",null,"Final","Final"]
[null,null,null,null,null,null,"Quantity","Unit Price","Price",null,"Quantity","Price"]
[]
[null,null,null,{"$f":"'Contract Data'!A3","v":"MISC. TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D24>0,VLOOKUP(D24,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G24*H24","v":0},null,null,{"$f":"K24*H24","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D25>0,VLOOKUP(D25,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G25*H25","v":0},null,null,{"$f":"K25*H25","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D26>0,VLOOKUP(D26,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D27>0,VLOOKUP(D27,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D28>0,VLOOKUP(D28,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D29>0,VLOOKUP(D29,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D30>0,VLOOKUP(D30,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I24:J30)","v":0},null,null,{"$f":"SUM(L24:L30)","v":0}]
[null,"Guard Cable",null,{"$f":"'Contract Data'!A158","v":"ONE-STRAND ACCESS RESTRAINT CABLE REPAIR AND REPLACEMENT"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},{"$f":"G33*H33","v":0},null,null,{"$f":"H33*K33","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},{"$f":"G34*H34","v":0},null,null,{"$f":"H34*K34","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},{"$f":"G39*H39","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$159:$D$169,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$159:$D$169,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$159:$D$169,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$159:$D$169,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$159:$D$169,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I33:J47)","v":0},null,null,{"$f":"SUM(L33:L47)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"I31+I48","v":0},null,null,{"$f":"SUM(L31+L48)","v":0},null,"Enter into AWP in the Quantity Field for the Correct Line"]
[]
[null,null,null,"Adjustment Factors",null,null,"Factor","Estimated Subtotal",null,"Est. Adj.\nSubtotal","Final Subtotal","Final Adj.\nSubtotal"]
[null,null,null," Adjustment Factor",null,null,{"$f":"'Contract Data'!J2","v":0},{"$f":"I50","v":0},null,{"$f":"G53*H53","v":0},{"$f":"L50","v":0},{"$f":"G53*K53","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J53:J53)","v":0},null,{"$f":"SUM(L53:L53)","v":0}]
[null,"Contingent Items"]
[null,"Item","Pay Item Description",null,null,"Unit","Estimated\nQuantity","Unit Price","Estimated Price",null,"Final\nQuantity","Final Price"]
[null,null,null,null,null,null,null,null,{"$f":"G57*H57","v":0},null,null,{"$f":"H57*K57","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G58*H58","v":0},null,null,{"$f":"H58*K58","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,"Contingent Items Subtotal",{"$f":"SUM(I57:J60)","v":0},null,null,{"$f":"SUM(L57:L60)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Estimated","Final"]
[null,null,null,null,null,null,"  Total Job Price",null,null,null,{"$f":"SUM(J54+I61)","v":0},{"$f":"SUM(L54+L61)","v":0}]
[]
[null,null,null,"Responsible Person",null,null,null,null,null,null,"Date"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor (type in)"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT (PDF Signature when complete)"]
[null,"NOTE:  Italicized entries are \"ONLY IF APPLICABLE\" and may remain blank if not needed."]

{"sheet":"Pictures","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Helpful tip for inserting pictures:  \nHolding the alt key while moving or resizing a picture snaps to the cell corners."]