{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Contract Data","Guardrail","GC_LowTension","GC_Gibraltar","GC_Trinity","GC_Access_Restraint","Pictures"],"not_rendered":{"charts":0,"images":4,"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":30,"n_cols":1,"rows_kept":30,"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."]
["Create a list of the counties included in the contract and a list of the applicabe Maintenance Superintendents."]
[]
["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 Desctiption\" 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."]
[]
["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":246,"n_cols":14,"rows_kept":246,"cut":false,"hidden":false,"merged":[[1,0,1,3],[154,0,154,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"]
["TRAFFIC CONTROL ITEMS",null,null,null,null,null,null,null,null,null,null,null,"Contract ID"]
["WORK BEYOND SHOULDER",250,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor"]
["SHOULDER WORK - UNDIVIDED ROADWAYS",250,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor Phone Number"]
["RIGHT SHOULDER WORK - HIGH SPEED RDWY",350,6169902,"EA",null,"Direction (N, S, E, W)",null,"SELECT"]
["LEFT SHOULDER WORK - HIGH SPEED ROADWAY",500,6169902,"EA",null,null,null,"N"]
["1-LANE 2-WAY OPERATION W/ FLAGGERS",800,6169902,"EA",null,null,null,"S"]
["SINGLE LANE CLOSURE",900,6169902,"EA",null,null,null,"E"]
["PARTIAL RAMP CLOSURE",400,6169902,"EA",null,null,null,"W"]
["COMPLETE RAMP CLOSURE",600,6169902,"EA"]
["ENTRANCE RAMP AREA, MAINLINE WORK",400,6169902,"EA",null,"County:"]
["ENTRANCE RAMP AREA, ACCEL LANE WORK",400,6169902,"EA",null,"SELECT"]
["EXIT RAMP AREA, MAINLINE/DECEL LANE WORK",400,6169902,"EA",null,null,null,null,null,null,null,null,"Maintenance Sup't"]
["ADDITIONAL TRUCK MOUNTED ATTENUATOR",350,6169902,"EA",null,null,null,null,null,null,null,null,"SELECT"]
["ADDITIONAL FLASHING ARROW PANEL",100,6169902,"EA"]
["ADDITIONAL DIRECTIONAL INDICATOR BARRICADE",15,6169902,"EA"]
["ADDITIONAL CHANNELIZER (TRIMLINE)",11,6169902,"EA"]
["ADDITIONAL CMS (CONTRACTOR FURNISHED/RETAINED)",1100,6169902,"EA"]
["SEQUENTIAL FLASHING WARNING LIGHT",50,6169902,"EA"]
["ADDITIONAL CONSTRUCTION SIGNS",4,6169904,"SF"]
["TEMPORARY TRAFFIC CONTROL SINGLE LANE SHIFT",500,6169902,"EA"]
[]
["Guardrail"]
["NEW GUARDRAIL INSTALLATION ITEMS"]
["TYPE A OR B TERMINAL REMOVAL",250,2029902,"EA"]
["REMOVE GUARDRAIL",10,2029903,"LF"]
["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 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"]
["INSTALL POST IN SOLID ROCK OR CONC, 6’ OR 7’ (TYPE A,  E OR MGS)",350,6069902,"EA"]
["FLARED TYPE A CRASHWORTHY END TERMINAL",2365,6069902,"EA"]
["GUARDRAIL REPAIR ITEMS"]
["R&R 12.5’ BEAM, CONC/CONVEX RADIUS, TY A",350,6069902,"EA"]
["R&R 12.5’ BEAM, CONC/CONVEX RADIUS, MGS",350,6069902,"EA"]
["R&R 12.5’ W-BEAM PANEL (TYPE A GR)",162,6069902,"EA"]
["R&R 12.5’ W-BEAM PANEL (MGS)",162,6069902,"EA"]
["R&R 12.5' BEAM 10 GA. (TYPE E GR)",356,6069902,"EA"]
["R&R 18.75’ THRIE BEAM PANEL (MGS)",485,6069902,"EA"]
["R&R 25' THRIE BEAM PANEL (TYPE E GR)",460,6069902,"EA"]
["R&R 25’ THRIE BEAM PANEL (MGS)",460,6069902,"EA"]
["R&R 25' W-BEAM PANEL (TYPE A GR)",281,6069902,"EA"]
["R&R 25’ W-BEAM PANEL (MGS)",281,6069902,"EA"]
["R&R 6.25’ THRIE BEAM PANEL (MGS)",169,6069902,"EA"]
["R&R 6.25' TYPE A TO TYPE E TRANSITION BEAM",159,6069902,"EA"]
["R&R WOOD BLOCK 8X6X17 TRANSITION SECTION",35,6069902,"EA"]
["R&R WOOD BLOCK 12X6X19 TRANSITION SECTION",36,6069902,"EA"]
["R&R MGS HEIGHT AND BLOCK TRANSITION SECTION",772,6069902,"EA"]
["REALIGN & USE EXIST POST TYPE A, E OR MGS GR",25,6069902,"EA"]
["RE-TENSION GUARDRAIL SYSTEM",75,6069902,"EA"]
["R&R 12.5' END ANCHOR PANEL",154,6069902,"EA"]
["R&R 12.5’ MGS END ANCHOR PANEL",154,6069902,"EA"]
["R&R 12.5' THRIE BEAM RAIL TY E GR",234,6069902,"EA"]
["R&R MGS END ANCHOR",1313,6069902,"EA"]
["R&R 72” FOUNDATION TUBE W/O SOIL PLATE (MGS)",374,6069902,"EA"]
["R&R 46” WOOD POST IN FOUNDATION TUBE (MGS)",78,6069902,"EA"]
["R&R CABLE ASSY W/PIPE, PLATE & ANCHOR (MGS)",305,6069902,"EA"]
["R&R END ANCHOR RAIL",164,6069902,"EA"]
["R&R END ANCHOR CABLE ASSEMBLY",143,6069902,"EA"]
["R&R END SEC (SHOE) TY A GR",72,6069902,"EA"]
["R&R PARTS FOR END SECTION",105,6069902,"EA"]
["R&R GR DELINEATOR 1 SIDE OR 2 SIDE",12,6069902,"EA"]
["R&R STEEL POST 6', MGS",79,6069902,"EA"]
["R&R STEEL POST 6', TY A OR MGS GR",79,6069902,"EA"]
["R&R STEEL POST 6', TY E GR",89,6069902,"EA"]
["R&R STEEL POST 7', TY A GR",89,6069902,"EA"]
["R&R STEEL POST 7', TY E GR",90,6069902,"EA"]
["R&R STEEL POST 8', MGS",98,6069902,"EA"]
["R&R WOOD POST 6', TY A GR",74,6069902,"EA"]
["R&R WOOD POST 7', TY A GR",84,6069902,"EA"]
["R&R STEEL TUBE BLOCK 7X4 BR ANCH",107,6069902,"EA"]
["R&R STEEL SPACER BLOCK (TYPE A GR)",40,6069902,"EA"]
["R&R STEEL BLOCKOUT FOR RADIUS RAIL",40,6069902,"EA"]
["R&R TERMINAL CONNECTOR, TY A OR MGS GR",115,6069902,"EA"]
["R&R TERMINAL CONNECTOR, TY E OR MGS GR",150,6069902,"EA"]
["R&R WOOD/PLASTIC BLOCK 8X6X14 MGS",21,6069902,"EA"]
["R&R WOOD/PLASTIC BLOCK 8X6X14 TY A GR",21,6069902,"EA"]
["R&R WOOD/PLASTIC BLOCK 8X6X21 TY E GR",25,6069902,"EA"]
["R&R WOOD/PLASTIC BLOCK 12X6X14 MGS",25,6069902,"EA"]
["BULLNOSE SYSTEM REPAIR ITEMS"]
["R&R PARTS FOR BULLNOSE SYSTEM",1050,6069902,"EA"]
["R&R 72 IN FOUNDATION TUBE BULLNOSE SYSTEM",350,6069902,"EA"]
["R&R 96 1/16 IN FOUNDATION TUBE BULLNOSE SYSTEM",451,6069902,"EA"]
["R&R POSTS #1-2 BULLNOSE SYSTEM",87,6069902,"EA"]
["R&R POSTS #3-8 BULLNOSE SYSTEM",101,6069902,"EA"]
["R&R POSTS #9-12 BULLNOSE SYSTEM",100,6069902,"EA"]
["R&R 8X6X14 3/16 TAPERED WOOD BLOCK BULLNOSE SYSTEM",36,6069902,"EA"]
["R&R RAIL SECTION #1 BULLNOSE SYSTEM",1257,6069902,"EA"]
["R&R RAIL SECTION #2 BULLNOSE SYSTEM",768,6069902,"EA"]
["R&R RAIL SECTION #3 BULLNOSE SYSTEM",426,6069902,"EA"]
["END TERMINAL REPAIR ITEMS"]
["NEW OR R&R RFLCT SHEETING ON END TERM (UNIVERSAL)",45,6069902,"EA"]
["R&R 12.5 FT END SECT 1ST W-BEAM RAIL (MSKT)",203,6069902,"EA"]
["R&R 9.375 FT 2ND SECTION W-BEAM RAIL (MSKT)",135,6069902,"EA"]
["R&R CABLE ASSY W/ PIPE, PLATE & ANCH (MSKT)",113,6069902,"EA"]
["R&R GROUND STRUT (MSKT)",115,6069902,"EA"]
["R&R NEW IMPACT HEAD (MSKT)",1075,6069902,"EA"]
["REM EXT GR & REUSE EXIST IMPACT HD (MSKT)",250,6069902,"EA"]
["R&R POST #1 HBA TOP (MSKT)",110,6069902,"EA"]
["R&R POST #1 HBA BOTTOM (MSKT)",308,6069902,"EA"]
["R&R POST #2 HBA TOP (MSKT)",100,6069902,"EA"]
["R&R POST #2 HBA BOTTOM (MSKT)",165,6069902,"EA"]
["R&R 12’6” GALV GR PANEL 3’1.5” O/C (SOFTSTOP)",166,6069902,"EA"]
["R&R 12/25/3'1.5:3@6'3:3'1.5/S (SOFTSTOP)",274,6069902,"EA"]
["R&R 6'0 SYT POST/8.5/31\" GR HT (SOFTSTOP)",125,6069902,"EA"]
["R&R ANCHOR GUARDRAIL 12'-6\" (SOFTSTOP)",315,6069902,"EA"]
["R&R ANGLE STRUT (SOFTSTOP)",88,6069902,"EA"]
["R&R STYP#1 8.5# 4'9-1/2 (SOFTSTOP)",119,6069902,"EA"]
["R&R ANCHOR POST W6X15#X6' (SOFTSTOP)",411,6069902,"EA"]
["R&R IMPACT HEAD (SOFTSTOP)",1098,6069902,"EA"]
["REM EXT GR & REUSE EXIST IMPACT HD (SOFTSTOP)",253,6069902,"EA"]
["R&R CAN TL3 SS646 (SOFTSTOP)",322,6069902,"EA"]
["R&R ANCHOR ANGLE (SOFTSTOP)",41,6069902,"EA"]
["R&R PLATE WASHER (SOFTSTOP)",35,6069902,"EA"]
["R&R KEEPER PLATE (SOFTSTOP)",30,6069902,"EA"]
["R&R ANCHOR PADDLE (SOFTSTOP)",142,6069902,"EA"]
["R&R SLED WELDMENT (TRACC)",2978,6069902,"EA"]
["R&R SHREDDER (TRACC)",380,6069902,"EA"]
["R&R STAGE 2 RIP PLATE 75 IN (TRACC)",225,6069902,"EA"]
["R&R STAGE 3 RIP PLATE 93 IN (TRACC)",240,6069902,"EA"]
["R&R STAGE 3 RIP PLATE (25965G) 87 IN (TRACC)",230,6069902,"EA"]
["R&R STAGE 3 RIP PLATE (25966G) 87 IN (TRACC)",230,6069902,"EA"]
["R&R 2 BAY FENDER PANEL (TRACC)",280,6069902,"EA"]
["R&R NOSEPIECE YELLOW (TRACC)",355,6069902,"EA"]
[]
["Guard Cable"]
[]
["ONE-STRAND ACCESS RESTRAINT CABLE REPAIR AND REPLACEMENT"]
["REMOVE ACCESS RESTRAINT CABLE 1/S",5,2029903,"LF"]
["ONE-STRAND CABLE - ACCESS RESTRAINT",23,6064000,"LF"]
["ATTACH CABLE TO POST ACC REST CABLE 1/S",12,6069902,"EA"]
["R&R ANCHOR ROD ASSY 1/S",415,6069902,"EA"]
["R&R STEEL LINE OR END POST 1/S",73,6069902,"EA"]
["R&R TURNBUCKLE CABLE END ASSY 1/S",174,6069902,"EA"]
["REALIGN LINE/END POST ACC REST CABLE 1/S",25,6069902,"EA"]
["REPLACE GUARD CABLE DELINEATOR",9,6069902,"EA"]
["RETENSION ACCESS RESTRAINT CABLE 1/S",45,6069902,"EA"]
["SPLICE 1/2 INCH CABLE 1/S",110,6069902,"EA"]
["1/2 INCH CABLE RESTRAINT 1/S",8,6069903,"LF"]
[]
["THREE-STRAND LOW TENSION CABLE REPAIR AND REPLACEMENT"]
["REMOVE GUARD CABLE 3-STRAND",7,2029903,"LF"]
["ANCHOR ASSEMBLY, GUARD CABLE 3-STRAND",3350,6064110,"EA"]
["ANCHOR ASSEMBLY, GCABLE 3-S TO GRAIL TRANS",3013,6064111,"EA"]
["ATTACH CABLES TO POST 3/S LT",19,6069902,"EA"]
["GUARD CABLE LINE POST SET IN ROCK 3/S",199,6069902,"EA"]
["R&R ANCHOR POST 3/S",153,6069902,"EA"]
["R&R LINE POST 3/S",89,6069902,"EA"]
["R&R LINE POST IN ROCK LT",171,6069902,"EA"]
["R&R ANCH BRACKET - MED OR  RDSIDE 3/S",503,6069902,"EA"]
["R&R ANCH BRACKET - GUARD CABLE TO GR 3/S",403,6069902,"EA"]
["R&R CABLE TRANSITION BRACKET 3/S",108,6069902,"EA"]
["R&R CABLE END FITTING 3/S",138,6069902,"EA"]
["R&R COMPENSATING CABLE END ASSY 3/S",358,6069902,"EA"]
["R&R COMPENSATOR SPRING 3/S",275,6069902,"EA"]
["R&R TURNBUCKLE END ASSY W/O COMPE'TOR 3/S",233,6069902,"EA"]
["REALIGN LINE POST 3/S",20,6069902,"EA"]
["REPLACE GUARD CABLE DELINEATOR",9,6069902,"EA"]
["RETENSION LOW TENSION GUARD CABLES 3/S",83,6069902,"EA"]
["RETROFIT SLIP BASE PLATE",275,6069902,"EA"]
["SPLICE 3/4 INCH CABLE 1/S",179,6069902,"EA"]
["3/4 INCH CABLE 1/S - LT",9,6069903,"LF"]
[]
["HIGH TENSION CABLE BARRIER REPAIR AND REPLACEMENT - TRINITY"]
["REMOVE GUARD CABLE 3-STRAND",7,2029903,"LF"]
["ANCHOR ASSEMBLY, GUARD CABLE 3-STRAND",3808,6064110,"EA"]
["ANCHOR ASSEMBLY, GCABLE 3-S TO GRAIL TRANS",3250,6064111,"EA"]
["ATTACH CABLES TO POST 3/S HT - TRINITY",41,6069902,"EA"]
["ATTACH NEW CRP ANCH POST TO BASE HT",364,6069902,"EA"]
["REATTACH EXIST CRP ANCH POST TO BASE - TRINITY",79,6069902,"EA"]
["R&R CRP ANCH POST 1-3 CONC FOOT W/ STUB HT",621,6069902,"EA"]
["FURN/INST TURNBUCKLE CABLE SPLICE ASSY HT",480,6069902,"EA"]
["R&R TURNBUCKLE HT",316,6069902,"EA"]
["R&R CCT TERMINAL POST 4-7 IN EX SLEEVE HT",263,6069902,"EA"]
["R&R CCT TERMINAL POST 8-9 IN EX SLEEVE HT",276,6069902,"EA"]
["R&R CCT TERM POST 4-9 CON FOOT W/ SLEEVE HT",334,6069902,"EA"]
["R&R LINE POST CONC FOOTING W/ SLEEVE HT",252,6069902,"EA"]
["R&R LINE POST IN EXIST SLEEVE HT",163,6069902,"EA"]
["R&R LINE POST IN ROCK HT",210,6069902,"EA"]
["R&R TOP/MID/OR BOTTOM CABLE END ASSY HT",286,6069902,"EA"]
["RETENSION HIGH TENSION CABLES 3/S HT",188,6069902,"EA"]
["REALIGN LINE POST HT",60,6069902,"EA"]
["SPLICE 3/4 INCH CABLE 1/S - HT",271,6069902,"EA"]
["3/4 INCH CABLE 1/S - HT",8,6069903,"LF"]
["HIGH TENSION SAFETY FENCE, TL-3",27,6069903,"LF"]
["HIGH TENSION SAFETY FENCE, TL-4",33,6069903,"LF"]
[]
["HIGH TENSION CABLE BARRIER REPAIR & REPLACEMENT - GIBRALTAR"]
["REMOVE GUARD CABLE 3-STRAND",7,2029903,"LF"]
["ANCHOR ASSEMBLY, GUARD CABLE 3-STRAND",3950,6064110,"EA"]
["ANCHOR ASSEMBLY, GCABLE 3-S TO GRAIL TRANS",3150,6064111,"EA"]
["ATTACH CABLES TO TL-3 POST 3/S HT - GIBRALTAR",56,6069902,"EA"]
["ATTACH CABLES TO TL-4 POST 3/S HT - GIBRALTAR",79,6069902,"EA"]
["ANCHOR POST",868,6069902,"EA"]
["ANCHOR TERMINAL FITTING",188,6069902,"EA"]
["ATTACH NEW CABLE RELEASE POST",560,6069902,"EA"]
["REATTACH EXIST CRP ANCH POST TO BASE-GIBRALTAR",193,6069902,"EA"]
["CABLE SPLICE TURNBUCKLE",314,6069902,"EA"]
["R&R ANCHOR POST 3/S",151,6069902,"EA"]
["R&R LINE POST CONC FTG W/ SLEEVE HT- GIBRALTAR",267,6069902,"EA"]
["R&R LINE POST IN ROCK HT",356,6069902,"EA"]
["R&R LINE POST 3/S",112,6069902,"EA"]
["REALIGN LINE POST HT",18,6069902,"EA"]
["REPLACE GUARD CABLE DELINEATOR",11,6069902,"EA"]
["RETENSION HIGH TENSION CABLES 3/S HT",175,6069902,"EA"]
["SPLICE 3/4 INCH CABLE 1/S - HT",219,6069902,"EA"]
["TERMINAL POST #1/ WEAK",111,6069902,"EA"]
["TERMINAL POST #2/ WEAK",111,6069902,"EA"]
["TL-3 TERMINAL POST #3&4/ WEAK",118,6069902,"EA"]
["TL-4 TERMINAL POST #3&4/ WEAK",118,6069902,"EA"]
["TL-3 LINE POST DRIVEN",130,6069902,"EA"]
["TL-3 LINE POST SOCKETED",95,6069902,"EA"]
["TL-4 LINE POST DRIVEN",142,6069902,"EA"]
["TL-4 LINE POST SOCKETED",113,6069902,"EA"]
["3/4 INCH CABLE 1/S - HT",8,6069903,"LF"]
["HIGH TENSION SAFETY FENCE, TL-3",26,6069903,"LF"]
["HIGH TENSION SAFETY FENCE, TL-4",33,6069903,"LF"]

{"sheet":"Guardrail","index":2,"n_rows":119,"n_cols":14,"rows_kept":119,"cut":false,"hidden":false,"merged":[[66,1,66,2],[59,1,59,2],[90,1,90,2],[91,1,91,2],[92,1,92,2],[88,1,88,2],[88,3,88,4],[78,1,78,2],[78,3,78,4],[72,1,72,2],[72,3,72,4],[68,1,68,2],[68,3,68,4],[59,3,59,4],[88,8,88,9],[80,1,80,2],[80,3,80,4],[80,8,80,9],[81,8,81,9],[84,3,84,4],[85,1,85,2],[85,3,85,4],[85,8,85,9],[86,1,86,2],[86,3,86,4],[86,8,86,9],[87,1,87,2],[87,3,87,4],[87,8,87,9],[105,7,105,8],[106,7,106,8],[105,3,105,5],[106,3,106,5],[118,6,118,9],[112,2,112,4],[112,8,112,9],[113,2,113,4],[113,8,113,9],[114,8,114,9],[107,6,107,8],[109,2,109,4],[109,8,109,9],[110,2,110,4],[110,8,110,9],[111,2,111,4],[111,8,111,9],[100,1,100,2],[100,3,100,4],[100,8,100,9],[101,8,101,9],[103,8,103,9],[98,1,98,2],[98,3,98,4],[98,8,98,9],[99,1,99,2],[99,3,99,4],[99,8,99,9],[102,1,102,11],[96,1,96,2],[96,3,96,4],[96,8,96,9],[97,1,97,2],[97,3,97,4],[97,8,97,9],[95,1,95,2],[95,3,95,4],[95,8,95,9],[93,8,93,9],[94,8,94,9],[93,3,93,4],[94,3,94,4],[93,1,93,2],[94,1,94,2],[89,8,89,9],[90,8,90,9],[91,8,91,9],[92,8,92,9],[89,3,89,4],[90,3,90,4],[91,3,91,4],[92,3,92,4],[89,1,89,2],[78,8,78,9],[79,1,79,2],[79,3,79,4],[79,8,79,9],[76,1,76,2],[76,3,76,4],[76,8,76,9],[77,1,77,2],[77,3,77,4],[77,8,77,9],[72,8,72,9],[73,8,73,9],[74,3,74,4],[75,1,75,2],[75,3,75,4],[75,8,75,9],[70,1,70,2],[70,3,70,4],[70,8,70,9],[71,1,71,2],[71,3,71,4],[71,8,71,9],[68,8,68,9],[69,1,69,2],[69,3,69,4],[69,8,69,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],[63,8,63,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[67,1,67,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[59,8,59,9],[60,1,60,2],[60,3,60,4],[60,8,60,9],[55,1,55,2],[55,3,55,4],[55,8,55,9],[56,8,56,9],[57,3,57,4],[58,1,58,2],[58,3,58,4],[58,8,58,9],[48,1,48,2],[48,3,48,4],[48,8,48,9],[54,1,54,2],[54,3,54,4],[54,8,54,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[46,1,46,2],[46,3,46,4],[46,8,46,9],[47,1,47,2],[47,3,47,4],[47,8,47,9],[44,1,44,2],[44,3,44,4],[44,8,44,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[42,1,42,2],[42,3,42,4],[42,8,42,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[38,1,38,2],[38,3,38,4],[38,8,38,9],[39,8,39,9],[40,3,40,4],[41,1,41,2],[41,3,41,4],[41,8,41,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[37,1,37,2],[37,3,37,4],[37,8,37,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[35,1,35,2],[35,3,35,4],[35,8,35,9],[31,3,31,4],[31,10,31,11],[32,1,32,2],[32,3,32,4],[32,8,32,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[27,10,27,11],[28,1,29,2],[28,3,29,4],[28,5,29,5],[28,8,28,9],[29,8,29,9],[25,1,25,2],[25,3,25,4],[25,5,25,9],[26,1,26,2],[26,3,26,4],[26,5,26,9],[23,1,23,2],[23,3,23,4],[23,5,23,9],[24,1,24,2],[24,3,24,4],[24,5,24,9],[17,2,17,3],[18,2,18,11],[19,2,19,11],[21,2,21,11],[22,2,22,4],[22,5,22,6],[22,7,22,10],[15,2,15,3],[15,5,15,7],[15,8,15,9],[16,2,16,3],[16,5,16,7],[16,8,16,9],[9,2,9,3],[11,2,12,11],[13,2,13,3],[13,5,13,7],[14,2,14,3],[14,5,14,7],[14,8,14,9],[0,1,0,11],[1,1,1,11],[3,7,3,9],[4,7,4,9],[5,1,5,11],[8,2,8,3],[8,5,8,6],[9,5,9,6]]}
[null,"Missouri Department of Transportation"]
[null,"2024 Guardrail Job Order"]
[]
[null,null,null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,"K Number:"]
[null,null,null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,"Date Issued:"]
[]
[]
[]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,"First Priority?",null,null,"Daytime","Nighttime"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,false,false]
[]
[null,"Description of Work:"]
[]
[null,"Date Damaged:",null,null,"Direction (N, S, E, W):","SELECT"]
[null,"Route:",null,null,"County:","SELECT",null,null,"Mile Marker:"]
[null,"PD Incident Number:",null,null,"GPS Longitude:",null,null,null,"GPS Latitude:"]
[null,"Reporting Agency:",null,null,"MoDOT Locate Number:",null,null,null,"Dig Rite Number:"]
[null,"Maintenance Sup't:","SELECT"]
[null,"Restrictions:"]
[null,"Location Description:"]
[]
[null,"Remarks/Comments:"]
[null,null,"TOTAL ESTIMATED PRICE FOR THIS WORK ORDER:",null,null,{"$f":"K119","v":0},null,"TOTAL COMPLETED PRICE THIS WORK ORDER:",null,null,null,{"$f":"L119","v":0}]
[null,"Issued:",null,"Responsible Person",null,null,null,null,null,null,"Time","Date"]
[null,"Notice to Proceed:",null,null,null,"MoDOT"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT"]
[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":"TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},{"$f":"G33*H33","v":0},null,null,{"$f":"K33*H33","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},{"$f":"G34*H34","v":0},null,null,{"$f":"K34*H34","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$4:$D$22,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$4:$D$22,3,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$4:$D$22,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$4:$D$22,4,FALSE))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'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(I33:J39)","v":0},null,null,{"$f":"SUM(L33:L39)","v":0}]
[null,"Guardrail ",null,"NEW GUARDRAIL INSTALLATION ITEMS"]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},{"$f":"G42*H42","v":0},null,null,{"$f":"H42*K42","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},{"$f":"G43*H43","v":0},null,null,{"$f":"H43*K43","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},{"$f":"G50*H50","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D54>0,VLOOKUP(D54,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D55,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D55,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D55,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D55,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D55>0,VLOOKUP(D55,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D56,'Contract Data'!$A$26:$D$61,3,FALSE)),\"\",VLOOKUP(D56,'Contract Data'!$A$26:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D56,'Contract Data'!$A$26:$D$61,4,FALSE)),\"\",VLOOKUP(D56,'Contract Data'!$A$26:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D56>0,VLOOKUP(D56,'Contract Data'!$A$26:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I42:J56)","v":0},null,null,{"$f":"SUM(L42:L56)","v":0}]
[null,"Guardrail ",null,{"$f":"'Contract Data'!A62","v":"GUARDRAIL REPAIR ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D59,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D59,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D59,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D59,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D59>0,VLOOKUP(D59,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},{"$f":"G59*H59","v":0},null,null,{"$f":"H59*K59","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D60,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D60,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D60,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D60,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D60>0,VLOOKUP(D60,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},{"$f":"G60*H60","v":0},null,null,{"$f":"H60*K60","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D61,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D61,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D61,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D61,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D61>0,VLOOKUP(D61,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D62,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D62,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D62,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D62,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D62>0,VLOOKUP(D62,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D63,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D63,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D63,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D63,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D63>0,VLOOKUP(D63,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D64,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D64,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D64,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D64,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D64>0,VLOOKUP(D64,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},{"$f":"G64*H64","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D65,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D65,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D65,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D65,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D65>0,VLOOKUP(D65,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D66,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D66,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D66,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D66,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D66>0,VLOOKUP(D66,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D67,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D67,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D67,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D67,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D67>0,VLOOKUP(D67,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D68,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D68,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D68,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D68,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D68>0,VLOOKUP(D68,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D69,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D69,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D69,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D69,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D69>0,VLOOKUP(D69,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D70,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D70,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D70,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D70,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D70>0,VLOOKUP(D70,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D71,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D71,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D71,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D71,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D71>0,VLOOKUP(D71,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D72,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D72,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D72,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D72,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D72>0,VLOOKUP(D72,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D73,'Contract Data'!$A$63:$D$108,3,FALSE)),\"\",VLOOKUP(D73,'Contract Data'!$A$63:$D$108,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D73,'Contract Data'!$A$63:$D$108,4,FALSE)),\"\",VLOOKUP(D73,'Contract Data'!$A$63:$D$108,4,FALSE))","v":""},null,{"$f":"IF(D73>0,VLOOKUP(D73,'Contract Data'!$A$63:$B$108,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I59:J73)","v":0},null,null,{"$f":"SUM(L59:L73)","v":0}]
[null,"Guardrail ",null,{"$f":"'Contract Data'!A109","v":"BULLNOSE SYSTEM REPAIR ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D76,'Contract Data'!$A$110:$D$119,3,FALSE)),\"\",VLOOKUP(D76,'Contract Data'!$A$110:$D$119,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D76,'Contract Data'!$A$110:$D$119,4,FALSE)),\"\",VLOOKUP(D76,'Contract Data'!$A$110:$D$119,4,FALSE))","v":""},null,{"$f":"IF(D76>0,VLOOKUP(D76,'Contract Data'!$A$110:$B$119,2,FALSE),0)","v":0},{"$f":"G76*H76","v":0},null,null,{"$f":"H76*K76","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D77,'Contract Data'!$A$110:$D$119,3,FALSE)),\"\",VLOOKUP(D77,'Contract Data'!$A$110:$D$119,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D77,'Contract Data'!$A$110:$D$119,4,FALSE)),\"\",VLOOKUP(D77,'Contract Data'!$A$110:$D$119,4,FALSE))","v":""},null,{"$f":"IF(D77>0,VLOOKUP(D77,'Contract Data'!$A$110:$B$119,2,FALSE),0)","v":0},{"$f":"G77*H77","v":0},null,null,{"$f":"H77*K77","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D78,'Contract Data'!$A$110:$D$119,3,FALSE)),\"\",VLOOKUP(D78,'Contract Data'!$A$110:$D$119,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D78,'Contract Data'!$A$110:$D$119,4,FALSE)),\"\",VLOOKUP(D78,'Contract Data'!$A$110:$D$119,4,FALSE))","v":""},null,{"$f":"IF(D78>0,VLOOKUP(D78,'Contract Data'!$A$110:$B$119,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D79,'Contract Data'!$A$110:$D$119,3,FALSE)),\"\",VLOOKUP(D79,'Contract Data'!$A$110:$D$119,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D79,'Contract Data'!$A$110:$D$119,4,FALSE)),\"\",VLOOKUP(D79,'Contract Data'!$A$110:$D$119,4,FALSE))","v":""},null,{"$f":"IF(D79>0,VLOOKUP(D79,'Contract Data'!$A$110:$B$119,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D80,'Contract Data'!$A$110:$D$119,3,FALSE)),\"\",VLOOKUP(D80,'Contract Data'!$A$110:$D$119,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D80,'Contract Data'!$A$110:$D$119,4,FALSE)),\"\",VLOOKUP(D80,'Contract Data'!$A$110:$D$119,4,FALSE))","v":""},null,{"$f":"IF(D80>0,VLOOKUP(D80,'Contract Data'!$A$110:$B$119,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D81,'Contract Data'!$A$110:$D$119,3,FALSE)),\"\",VLOOKUP(D81,'Contract Data'!$A$110:$D$119,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D81,'Contract Data'!$A$110:$D$119,4,FALSE)),\"\",VLOOKUP(D81,'Contract Data'!$A$110:$D$119,4,FALSE))","v":""},null,{"$f":"IF(D81>0,VLOOKUP(D81,'Contract Data'!$A$110:$B$119,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I76:J81)","v":0},null,null,{"$f":"SUM(L76:L81)","v":0}]
[]
[]
[null,"Guardrail ",null,{"$f":"'Contract Data'!A120","v":"END TERMINAL REPAIR ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D86,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D86,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D86,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D86,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D86>0,VLOOKUP(D86,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},{"$f":"G86*H86","v":0},null,null,{"$f":"H86*K86","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D87,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D87,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D87,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D87,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D87>0,VLOOKUP(D87,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},{"$f":"G87*H87","v":0},null,null,{"$f":"H87*K87","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D88,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D88,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D88,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D88,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D88>0,VLOOKUP(D88,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D89,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D89,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D89,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D89,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D89>0,VLOOKUP(D89,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D90,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D90,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D90,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D90,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D90>0,VLOOKUP(D90,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},{"$f":"G90*H90","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D91,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D91,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D91,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D91,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D91>0,VLOOKUP(D91,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D92,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D92,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D92,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D92,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D92>0,VLOOKUP(D92,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D93,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D93,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D93,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D93,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D93>0,VLOOKUP(D93,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D94,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D94,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D94,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D94,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D94>0,VLOOKUP(D94,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D95,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D95,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D95,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D95,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D95>0,VLOOKUP(D95,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D96,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D96,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D96,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D96,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D96>0,VLOOKUP(D96,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D97,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D97,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D97,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D97,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D97>0,VLOOKUP(D97,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D98,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D98,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D98,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D98,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D98>0,VLOOKUP(D98,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D99,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D99,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D99,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D99,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D99>0,VLOOKUP(D99,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D100,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D100,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D100,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D100,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D100>0,VLOOKUP(D100,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D101,'Contract Data'!$A$121:$D$153,3,FALSE)),\"\",VLOOKUP(D101,'Contract Data'!$A$121:$D$153,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D101,'Contract Data'!$A$121:$D$153,4,FALSE)),\"\",VLOOKUP(D101,'Contract Data'!$A$121:$D$153,4,FALSE))","v":""},null,{"$f":"IF(D101>0,VLOOKUP(D101,'Contract Data'!$A$121:$B$153,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I86:J101)","v":0},null,null,{"$f":"SUM(L86:L101)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"SUM(I40+I57+I74+I82+I102)","v":0},null,null,{"$f":"SUM(L40+L57+L74+L82+L102)","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":"I104","v":0},null,{"$f":"G107*H107","v":0},{"$f":"L104","v":0},{"$f":"G107*K107","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J107:J107)","v":0},null,{"$f":"SUM(L107:L107)","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":"G111*H111","v":0},null,null,{"$f":"H111*K111","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G112*H112","v":0},null,null,{"$f":"H112*K112","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(I111:J114)","v":0},null,null,{"$f":"SUM(L111:L114)","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(J108+I115)","v":0},{"$f":"SUM(L108+L115)","v":0}]

{"sheet":"GC_LowTension","index":3,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,6,71,9],[38,3,38,6],[56,8,56,9],[66,2,66,4],[66,8,66,9],[67,8,67,9],[63,2,63,4],[63,8,63,9],[64,2,64,4],[64,8,64,9],[65,2,65,4],[65,8,65,9],[60,6,60,8],[62,2,62,4],[62,8,62,9],[59,7,59,8],[55,1,55,11],[58,7,58,8],[53,1,53,2],[52,8,52,9],[50,1,50,2],[59,3,59,5],[58,3,58,5],[44,1,44,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[47,3,47,4],[48,3,48,4],[49,3,49,4],[47,8,47,9],[48,8,48,9],[49,8,49,9],[53,3,53,4],[53,8,53,9],[54,8,54,9],[46,1,46,2],[46,3,46,4],[46,8,46,9],[52,1,52,2],[52,3,52,4],[42,1,42,2],[42,3,42,4],[42,8,42,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[51,1,51,2],[50,3,50,4],[51,3,51,4],[50,8,50,9],[51,8,51,9],[44,3,44,4],[44,8,44,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[40,1,40,2],[40,3,40,4],[40,8,40,9],[41,1,41,2],[41,3,41,4],[41,8,41,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[37,8,37,9],[39,1,39,2],[39,3,39,4],[39,8,39,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[35,1,35,2],[35,3,35,4],[35,8,35,9],[32,1,32,2],[32,3,32,4],[32,8,32,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[29,3,29,4],[29,10,29,11],[30,1,30,2],[30,3,30,4],[30,8,30,9],[31,1,31,2],[31,3,31,4],[31,8,31,9],[25,10,25,11],[26,1,27,2],[26,3,27,4],[26,5,27,5],[26,8,26,9],[27,8,27,9],[23,1,23,2],[23,3,23,4],[23,5,23,9],[24,1,24,2],[24,3,24,4],[24,5,24,9],[21,5,21,9],[22,1,22,2],[22,3,22,4],[22,5,22,9],[15,2,15,3],[16,2,16,11],[17,2,17,11],[19,2,19,11],[20,2,20,4],[20,5,20,6],[20,7,20,10],[21,1,21,2],[21,3,21,4],[0,1,0,11],[1,1,1,11],[3,7,3,9],[4,7,4,9],[5,1,5,11],[6,2,6,3],[13,2,13,3],[13,5,13,7],[13,8,13,9],[14,2,14,3],[14,5,14,7],[14,8,14,9],[7,2,7,3],[9,2,10,11],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[12,8,12,9]]}
[null,"Missouri Department of Transportation"]
[null,"2024 Guard Cable Job Order"]
[]
[null,null,null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,"K Number:"]
[null,null,null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,"Date Issued:"]
[]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,"Daytime","Nighttime"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,false,false]
[]
[null,"Description of Work:"]
[]
[null,"Date Damaged:",null,null,"Direction (N, S, E, W):","SELECT"]
[null,"Route:",null,null,"County:","SELECT",null,null,"Mile Marker:"]
[null,"PD Incident Number:",null,null,"GPS Longitude:",null,null,null,"GPS Latitude:"]
[null,"Reporting Agency:",null,null,"MoDOT Locate Number:",null,null,null,"Dig Rite Number:"]
[null,"Maintenance Sup't:","SELECT"]
[null,"Restrictions:"]
[null,"Location Description:"]
[]
[null,"Remarks/Comments:"]
[null,null,"TOTAL ESTIMATED PRICE FOR THIS WORK ORDER:",null,null,{"$f":"K72","v":0},null,"TOTAL COMPLETED PRICE THIS WORK ORDER:",null,null,null,{"$f":"L72","v":0}]
[null,"Issued:",null,"Responsible Person",null,null,null,null,null,null,"Time","Date"]
[null,"Notice to Proceed:",null,null,null,"MoDOT"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT"]
[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":"TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D31>0,VLOOKUP(D31,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G31*H31","v":0},null,null,{"$f":"K31*H31","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D32>0,VLOOKUP(D32,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G32*H32","v":0},null,null,{"$f":"K32*H32","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$22,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'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(I31:J37)","v":0},null,null,{"$f":"SUM(L31:L37)","v":0}]
[null,"Guard Cable",null,{"$f":"'Contract Data'!A170","v":"THREE-STRAND LOW TENSION CABLE REPAIR AND REPLACEMENT"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},{"$f":"G40*H40","v":0},null,null,{"$f":"H40*K40","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},{"$f":"G41*H41","v":0},null,null,{"$f":"H41*K41","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},{"$f":"G48*H48","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$171:$D$191,3,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$171:$D$191,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$171:$D$191,4,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$171:$D$191,4,FALSE))","v":""},null,{"$f":"IF(D54>0,VLOOKUP(D54,'Contract Data'!$A$171:$D$191,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I40:J54)","v":0},null,null,{"$f":"SUM(L40:L54)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"SUM(I38+I55)","v":0},null,null,{"$f":"SUM(L38+L55)","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":"I57","v":0},null,{"$f":"G60*H60","v":0},{"$f":"L57","v":0},{"$f":"G60*K60","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J60:J60)","v":0},null,{"$f":"SUM(L60:L60)","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":"G64*H64","v":0},null,null,{"$f":"H64*K64","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G65*H65","v":0},null,null,{"$f":"H65*K65","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(I64:J67)","v":0},null,null,{"$f":"SUM(L64:L67)","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(J61+I68)","v":0},{"$f":"SUM(L61+L68)","v":0}]

{"sheet":"GC_Gibraltar","index":4,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[59,3,59,5],[71,6,71,9],[56,8,56,9],[66,2,66,4],[66,8,66,9],[67,8,67,9],[63,2,63,4],[63,8,63,9],[64,2,64,4],[64,8,64,9],[65,2,65,4],[65,8,65,9],[60,6,60,8],[62,2,62,4],[62,8,62,9],[59,7,59,8],[58,3,58,5],[53,1,53,2],[53,3,53,4],[53,8,53,9],[54,8,54,9],[55,1,55,11],[58,7,58,8],[51,1,51,2],[51,3,51,4],[51,8,51,9],[52,1,52,2],[52,3,52,4],[52,8,52,9],[44,1,44,2],[44,3,44,4],[44,8,44,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[42,1,42,2],[42,3,42,4],[42,8,42,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[40,1,40,2],[40,3,40,4],[40,8,40,9],[41,1,41,2],[41,3,41,4],[41,8,41,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[37,8,37,9],[38,3,38,6],[39,1,39,2],[39,3,39,4],[39,8,39,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[35,1,35,2],[35,3,35,4],[35,8,35,9],[32,1,32,2],[32,3,32,4],[32,8,32,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[29,3,29,4],[29,10,29,11],[30,1,30,2],[30,3,30,4],[30,8,30,9],[31,1,31,2],[31,3,31,4],[31,8,31,9],[25,10,25,11],[26,1,27,2],[26,3,27,4],[26,5,27,5],[26,8,26,9],[27,8,27,9],[23,1,23,2],[23,3,23,4],[23,5,23,9],[24,1,24,2],[24,3,24,4],[24,5,24,9],[21,5,21,9],[22,1,22,2],[22,3,22,4],[22,5,22,9],[15,2,15,3],[16,2,16,11],[17,2,17,11],[19,2,19,11],[20,2,20,4],[20,5,20,6],[20,7,20,10],[21,1,21,2],[21,3,21,4],[0,1,0,11],[1,1,1,11],[3,7,3,9],[4,7,4,9],[5,1,5,11],[6,2,6,3],[13,2,13,3],[13,5,13,7],[13,8,13,9],[14,2,14,3],[14,5,14,7],[14,8,14,9],[7,2,7,3],[9,2,10,11],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[12,8,12,9]]}
[null,"Missouri Department of Transportation"]
[null,"2024 Guard Cable Job Order"]
[]
[null,null,null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,"K Number:"]
[null,null,null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,"Date Issued:"]
[]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,"Daytime","Nighttime"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,false,false]
[]
[null,"Description of Work:"]
[]
[null,"Date Damaged:",null,null,"Direction (N, S, E, W):","SELECT"]
[null,"Route:",null,null,"County:","SELECT",null,null,"Mile Marker:"]
[null,"PD Incident Number:",null,null,"GPS Longitude:",null,null,null,"GPS Latitude:"]
[null,"Reporting Agency:",null,null,"MoDOT Locate Number:",null,null,null,"Dig Rite Number:"]
[null,"Maintenance Sup't:","SELECT"]
[null,"Restrictions:"]
[null,"Location Description:"]
[]
[null,"Remarks/Comments:"]
[null,null,"TOTAL ESTIMATED PRICE FOR THIS WORK ORDER:",null,null,{"$f":"K72","v":0},null,"TOTAL COMPLETED PRICE THIS WORK ORDER:",null,null,null,{"$f":"L72","v":0}]
[null,"Issued:",null,"Responsible Person",null,null,null,null,null,null,"Time","Date"]
[null,"Notice to Proceed:",null,null,null,"MoDOT"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT"]
[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":"TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D31>0,VLOOKUP(D31,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G31*H31","v":0},null,null,{"$f":"K31*H31","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D32>0,VLOOKUP(D32,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G32*H32","v":0},null,null,{"$f":"K32*H32","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'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(I31:J37)","v":0},null,null,{"$f":"SUM(L31:L37)","v":0}]
[null,"Guard Cable",null,{"$f":"'Contract Data'!A217","v":"HIGH TENSION CABLE BARRIER REPAIR & REPLACEMENT - GIBRALTAR"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},{"$f":"G40*H40","v":0},null,null,{"$f":"H40*K40","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},{"$f":"G41*H41","v":0},null,null,{"$f":"H41*K41","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},{"$f":"G47*H47","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$218:$D$246,3,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$218:$D$246,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$218:$D$246,4,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$218:$D$246,4,FALSE))","v":""},null,{"$f":"IF(D54>0,VLOOKUP(D54,'Contract Data'!$A$218:$D$246,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I40:J54)","v":0},null,null,{"$f":"SUM(L40:L54)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"I38+I55","v":0},null,null,{"$f":"SUM(L38+L55)","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":"I57","v":0},null,{"$f":"G60*H60","v":0},{"$f":"L57","v":0},{"$f":"G60*K60","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J60:J60)","v":0},null,{"$f":"SUM(L60:L60)","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":"G64*H64","v":0},null,null,{"$f":"H64*K64","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G65*H65","v":0},null,null,{"$f":"H65*K65","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(I64:J67)","v":0},null,null,{"$f":"SUM(L64:L67)","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(J61+I68)","v":0},{"$f":"SUM(L61+L68)","v":0}]

{"sheet":"GC_Trinity","index":5,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[59,3,59,5],[71,6,71,9],[56,8,56,9],[66,2,66,4],[66,8,66,9],[67,8,67,9],[63,2,63,4],[63,8,63,9],[64,2,64,4],[64,8,64,9],[65,2,65,4],[65,8,65,9],[60,6,60,8],[62,2,62,4],[62,8,62,9],[59,7,59,8],[58,3,58,5],[53,1,53,2],[53,3,53,4],[53,8,53,9],[54,8,54,9],[55,1,55,11],[58,7,58,8],[51,1,51,2],[51,3,51,4],[51,8,51,9],[52,1,52,2],[52,3,52,4],[52,8,52,9],[44,1,44,2],[44,3,44,4],[44,8,44,9],[50,1,50,2],[50,3,50,4],[50,8,50,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[42,1,42,2],[42,3,42,4],[42,8,42,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[40,1,40,2],[40,3,40,4],[40,8,40,9],[41,1,41,2],[41,3,41,4],[41,8,41,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[37,8,37,9],[38,3,38,6],[39,1,39,2],[39,3,39,4],[39,8,39,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[35,1,35,2],[35,3,35,4],[35,8,35,9],[32,1,32,2],[32,3,32,4],[32,8,32,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[29,3,29,4],[29,10,29,11],[30,1,30,2],[30,3,30,4],[30,8,30,9],[31,1,31,2],[31,3,31,4],[31,8,31,9],[25,10,25,11],[26,1,27,2],[26,3,27,4],[26,5,27,5],[26,8,26,9],[27,8,27,9],[23,1,23,2],[23,3,23,4],[23,5,23,9],[24,1,24,2],[24,3,24,4],[24,5,24,9],[21,5,21,9],[22,1,22,2],[22,3,22,4],[22,5,22,9],[15,2,15,3],[16,2,16,11],[17,2,17,11],[19,2,19,11],[20,2,20,4],[20,5,20,6],[20,7,20,10],[21,1,21,2],[21,3,21,4],[0,1,0,11],[1,1,1,11],[3,7,3,9],[4,7,4,9],[5,1,5,11],[6,2,6,3],[13,2,13,3],[13,5,13,7],[13,8,13,9],[14,2,14,3],[14,5,14,7],[14,8,14,9],[7,2,7,3],[9,2,10,11],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[12,8,12,9]]}
[null,"Missouri Department of Transportation"]
[null,"2024 Guard Cable Job Order"]
[]
[null,null,null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,"K Number:"]
[null,null,null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,"Date Issued:"]
[]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,"Daytime","Nighttime"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,false,false]
[]
[null,"Description of Work:"]
[]
[null,"Date Damaged:",null,null,"Direction (N, S, E, W):","SELECT"]
[null,"Route:",null,null,"County:","SELECT",null,null,"Mile Marker:"]
[null,"PD Incident Number:",null,null,"GPS Longitude:",null,null,null,"GPS Latitude:"]
[null,"Reporting Agency:",null,null,"MoDOT Locate Number:",null,null,null,"Dig Rite Number:"]
[null,"Maintenance Sup't:","SELECT"]
[null,"Restrictions:"]
[null,"Location Description:"]
[]
[null,"Remarks/Comments:"]
[null,null,"TOTAL ESTIMATED PRICE FOR THIS WORK ORDER:",null,null,{"$f":"K72","v":0},null,"TOTAL COMPLETED PRICE THIS WORK ORDER:",null,null,null,{"$f":"L72","v":0}]
[null,"Issued:",null,"Responsible Person",null,null,null,null,null,null,"Time","Date"]
[null,"Notice to Proceed:",null,null,null,"MoDOT"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT"]
[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":"TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D31>0,VLOOKUP(D31,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G31*H31","v":0},null,null,{"$f":"K31*H31","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D32>0,VLOOKUP(D32,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G32*H32","v":0},null,null,{"$f":"K32*H32","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'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(I31:J37)","v":0},null,null,{"$f":"SUM(L31:L37)","v":0}]
[null,"Guard Cable",null,{"$f":"'Contract Data'!A193","v":"HIGH TENSION CABLE BARRIER REPAIR AND REPLACEMENT - TRINITY"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},{"$f":"G40*H40","v":0},null,null,{"$f":"H40*K40","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},{"$f":"G41*H41","v":0},null,null,{"$f":"H41*K41","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},{"$f":"G46*H46","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$194:$D$215,3,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$194:$D$215,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$194:$D$215,4,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$194:$D$215,4,FALSE))","v":""},null,{"$f":"IF(D54>0,VLOOKUP(D54,'Contract Data'!$A$194:$D$215,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I40:J54)","v":0},null,null,{"$f":"SUM(L40:L54)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"I38+I55","v":0},null,null,{"$f":"SUM(L38+L55)","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":"I57","v":0},null,{"$f":"G60*H60","v":0},{"$f":"L57","v":0},{"$f":"G60*K60","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J60:J60)","v":0},null,{"$f":"SUM(L60:L60)","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":"G64*H64","v":0},null,null,{"$f":"H64*K64","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G65*H65","v":0},null,null,{"$f":"H65*K65","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(I64:J67)","v":0},null,null,{"$f":"SUM(L64:L67)","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(J61+I68)","v":0},{"$f":"SUM(L61+L68)","v":0}]

{"sheet":"GC_Access_Restraint","index":6,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[59,3,59,5],[71,6,71,9],[56,8,56,9],[66,2,66,4],[66,8,66,9],[67,8,67,9],[63,2,63,4],[63,8,63,9],[64,2,64,4],[64,8,64,9],[65,2,65,4],[65,8,65,9],[60,6,60,8],[62,2,62,4],[62,8,62,9],[59,7,59,8],[58,3,58,5],[53,1,53,2],[53,3,53,4],[53,8,53,9],[54,8,54,9],[55,1,55,11],[58,7,58,8],[51,1,51,2],[51,3,51,4],[51,8,51,9],[52,1,52,2],[52,3,52,4],[52,8,52,9],[44,1,44,2],[44,3,44,4],[44,8,44,9],[50,1,50,2],[50,3,50,4],[50,8,50,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[42,1,42,2],[42,3,42,4],[42,8,42,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[40,1,40,2],[40,3,40,4],[40,8,40,9],[41,1,41,2],[41,3,41,4],[41,8,41,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[37,8,37,9],[38,3,38,6],[39,1,39,2],[39,3,39,4],[39,8,39,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[35,1,35,2],[35,3,35,4],[35,8,35,9],[32,1,32,2],[32,3,32,4],[32,8,32,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[29,3,29,4],[29,10,29,11],[30,1,30,2],[30,3,30,4],[30,8,30,9],[31,1,31,2],[31,3,31,4],[31,8,31,9],[25,10,25,11],[26,1,27,2],[26,3,27,4],[26,5,27,5],[26,8,26,9],[27,8,27,9],[23,1,23,2],[23,3,23,4],[23,5,23,9],[24,1,24,2],[24,3,24,4],[24,5,24,9],[21,5,21,9],[22,1,22,2],[22,3,22,4],[22,5,22,9],[15,2,15,3],[16,2,16,11],[17,2,17,11],[19,2,19,11],[20,2,20,4],[20,5,20,6],[20,7,20,10],[21,1,21,2],[21,3,21,4],[0,1,0,11],[1,1,1,11],[3,7,3,9],[4,7,4,9],[5,1,5,11],[6,2,6,3],[13,2,13,3],[13,5,13,7],[13,8,13,9],[14,2,14,3],[14,5,14,7],[14,8,14,9],[7,2,7,3],[9,2,10,11],[11,2,11,3],[11,5,11,7],[12,2,12,3],[12,5,12,7],[12,8,12,9]]}
[null,"Missouri Department of Transportation"]
[null,"2024 Guard Cable Job Order"]
[]
[null,null,null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,"K Number:"]
[null,null,null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,"Date Issued:"]
[]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,"Daytime","Nighttime"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,false,false]
[]
[null,"Description of Work:"]
[]
[null,"Date Damaged:",null,null,"Direction (N, S, E, W):","SELECT"]
[null,"Route:",null,null,"County:","SELECT",null,null,"Mile Marker:"]
[null,"PD Incident Number:",null,null,"GPS Longitude:",null,null,null,"GPS Latitude:"]
[null,"Reporting Agency:",null,null,"MoDOT Locate Number:",null,null,null,"Dig Rite Number:"]
[null,"Maintenance Sup't:","SELECT"]
[null,"Restrictions:"]
[null,"Location Description:"]
[]
[null,"Remarks/Comments:"]
[null,null,"TOTAL ESTIMATED PRICE FOR THIS WORK ORDER:",null,null,{"$f":"K72","v":0},null,"TOTAL COMPLETED PRICE THIS WORK ORDER:",null,null,null,{"$f":"L72","v":0}]
[null,"Issued:",null,"Responsible Person",null,null,null,null,null,null,"Time","Date"]
[null,"Notice to Proceed:",null,null,null,"MoDOT"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT"]
[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":"TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D31>0,VLOOKUP(D31,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G31*H31","v":0},null,null,{"$f":"K31*H31","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D32>0,VLOOKUP(D32,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},{"$f":"G32*H32","v":0},null,null,{"$f":"K32*H32","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$4:$D$21,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$21,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$21,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$4:$D$21,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$4:$D$21,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'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(I31:J37)","v":0},null,null,{"$f":"SUM(L31:L37)","v":0}]
[null,"Guard Cable",null,{"$f":"'Contract Data'!A157","v":"ONE-STRAND ACCESS RESTRAINT CABLE REPAIR AND REPLACEMENT"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},{"$f":"G40*H40","v":0},null,null,{"$f":"H40*K40","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},{"$f":"G41*H41","v":0},null,null,{"$f":"H41*K41","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},{"$f":"G46*H46","v":0},null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$158:$D$168,3,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$158:$D$168,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$158:$D$168,4,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$158:$D$168,4,FALSE))","v":""},null,{"$f":"IF(D54>0,VLOOKUP(D54,'Contract Data'!$A$158:$D$168,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I40:J54)","v":0},null,null,{"$f":"SUM(L40:L54)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"I38+I55","v":0},null,null,{"$f":"SUM(L38+L55)","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":"I57","v":0},null,{"$f":"G60*H60","v":0},{"$f":"L57","v":0},{"$f":"G60*K60","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J60:J60)","v":0},null,{"$f":"SUM(L60:L60)","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":"G64*H64","v":0},null,null,{"$f":"H64*K64","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G65*H65","v":0},null,null,{"$f":"H65*K65","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(I64:J67)","v":0},null,null,{"$f":"SUM(L64:L67)","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(J61+I68)","v":0},{"$f":"SUM(L61+L68)","v":0}]

{"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."]