{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Contract Data","Fence","Pictures"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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."]
["Enter the contract specific information from the Contract."]
["Create a list of the counties included in the contract."]
[]
["Select the Job Order Tab for the items you're working on"]
[]
["Fill in the shaded cells manually, note that some utilize dropdown menus."]
[]
["Select the correct pay item utilizing the dropdown menus in the \"Pay Item Description\" column. Note this will auto populate other cells."]
[]
["Using the calculated quantities from previous tabs or manual calculations, enter the quantities in the \"Estimated Quantities\" column."]
[]
["Add pictures to the pictures tab only.  No need to store separately in eProjects.  Use the Insert - then pictures to select those you wish to add.  Resize to the box.  Pictures are formatted to print 4 per page if inserted into box correctly."]
[]
[]
[]
["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":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,3],[23,0,23,3]]}
["Do not change these items",null,null,null,null,"Enter Contract Bid Factor Here",null,null,null,null,null,null,"Enter Contract Specific Information Here",""]
["ALL",null,null,null,null,"Adjustment Factor",null,null,null,null,"Each",null,"Job Number"]
["MISC. TRAFFIC CONTROL ITEMS",null,null,null,null,null,null,null,null,null,null,null,"Contract ID"]
["MISC. WORK BEYOND SHOULDER",250,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor"]
["MISC. SHOULDER WORK - UNDIVIDED ROADWAYS",250,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor Phone Number"]
["MISC. RIGHT SHOULDER WORK - HIGH SPEED RDWY",350,6169902,"EA",null,"Direction (N, S, E, W)",null,"SELECT"]
["MISC. LEFT SHOULDER WORK - HIGH SPEED ROADWAY",500,6169902,"EA",null,null,null,"N",null,null,null,null,"Enter the Police Department for the PD Report HERE:"]
["MISC. 1-LANE 2-WAY OPERATION W/ FLAGGERS",800,6169902,"EA",null,null,null,"S",null,null,null,null,"SELECT"]
["MISC. SINGLE LANE CLOSURE",900,6169902,"EA",null,null,null,"E"]
["MISC. PARTIAL RAMP CLOSURE",400,6169902,"EA",null,null,null,"W"]
["MISC. COMPLETE RAMP CLOSURE",600,6169902,"EA"]
["MISC. ENTRANCE RAMP AREA, MAINLINE WORK",400,6169902,"EA",null,"County:"]
["MISC. ENTRANCE RAMP AREA, ACCEL LANE WORK",400,6169902,"EA",null,"SELECT"]
["MISC. EXIT RAMP AREA, MAINLINE/DECEL LANE WORK",400,6169902,"EA"]
["MISC. ADDITIONAL TRUCK MOUNTED ATTENUATOR",350,6169902,"EA"]
["MISC. ADDITIONAL FLASHING ARROW PANEL",100,6169902,"EA"]
["MISC. ADDITIONAL DIRECTIONAL INDICATOR BARRICADE",15,6169902,"EA"]
["MISC. ADDITIONAL CHANNELIZER (TRIMLINE)",11,6169902,"EA"]
["MISC. ADDITIONAL CHANGEABLE MESSAGE SIGN",1100,6169902,"EA"]
["MISC. SEQUENTIAL FLASHING WARNING LIGHT",50,6169902,"EA"]
["MISC. ADDITIONAL CONSTRUCTION SIGNS",4,6169904,"SF"]
[]
[]
["Fence"]
[]
["FENCE ITEMS"]
["MISC. REMOVE EXIST CONCRETE POST FOOTING (CH-L)",75,2029902,"EA"]
["MISC. REMOVE CHAIN-LINK FENCE",5,2029903,"LF"]
["CHAIN-LINK FENCE DRIVEN POSTS (60 IN.)",30,"6071012A","LF"]
["CHAIN-LINK FENCE DRIVEN POSTS (72 IN.)",38,"6071013A","LF"]
["MISC. CHAIN-LINK FENCE - VINYL (60 IN)",32,6079903,"LF"]
["3-STRAND BARBED WIRE EXTENSION FOR CHAIN-LINK FENCE",5.25,"6071043A","LF"]
["(112 IN.) CURVED TOP PEDESTRIAN FENCE (STRUCTURES)",140,6071067,"LF"]
["MISC. 5 FT X 60 IN CHAIN-LINK WALK GATE (GALV)",500,6079902,"EA"]
["MISC. 12-16 FT X 60 IN CHAIN-LINK DRIVE GATE (GALV)",1700,6079902,"EA"]
["MISC. RESTRETCH/REATTACH FAB TO POST (CH-L)",16,6079902,"EA"]
["MISC. REALIGN LINE POST (CH-L)",20,6079902,"EA"]
["MISC. REALIGN END, CORNER, GATE, PULL POST (CH-L)",20,6079902,"EA"]
["MISC. R&R 5' LINE DRIVEN POST (GALV)",75,6079902,"EA"]
["MISC. R&R 5' END, CORNER, GATE, PULL POST (GALV)",350,6079902,"EA"]
["MISC. R&R HORIZONTAL BRACE (GALV)",50,6079902,"EA"]
["MISC. R&R 5' TRUSS ROD (GALV)",20,6079902,"EA"]
["MISC. R&R 6' LINE POST (GALV)",80,6079902,"EA"]
["MISC. R&R 6' END, CORNER, GATE, PULL POST (GALV)",375,6079902,"EA"]
["MISC. R&R 5' STRETCHER BAR (GALV)",20,6079902,"EA"]
["MISC. R&R 6' STRETCHER BAR (GALV)",22,6079902,"EA"]
["MISC. R&R 6' TRUSS ROD (GALV)",22,6079902,"EA"]
["MISC. R&R 5' STRETCHER BAR (VINYL)",28,6079902,"EA"]
["MISC. R&R 5' LINE POST (VINYL)",79,6079902,"EA"]
["MISC. R&R 5' END, CORNER, GATE, PULL POST (VINYL)",388,6079902,"EA"]
["MISC. R&R HORIZONTAL BRACE (VINYL)",52,6079902,"EA"]
["MISC. R&R 5' TRUSS ROD (VINYL)",25,6079902,"EA"]
["MISC. REPL/SPLICE BARBED WIRE (CH-L AND WW)",10,6079903,"LF"]
["MISC. REPL/SPLICE 6' CH-LINK FENCE FAB (GALV)",9,6079903,"LF"]
["MISC. R&R TEN WIRE - R/R RAIL W/ TEN WIRE (GALV)",5.5,6079903,"LF"]
["MISC. REPL/SPLICE 5' CH-LINK FENCE FAB (GALV)",6,6079903,"LF"]
["MISC. REPL/SPLICE 5' CH-LINK FENCE FAB (VINYL)",7,6079903,"LF"]
["MISC. R&R TEN WIRE - R/R RAIL W/ TEN WIRE (VINYL)",5.5,6079903,"LF"]

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

{"sheet":"Pictures","index":3,"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."]