{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Contract Data","Fence","Pictures"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":27,"n_cols":1,"rows_kept":27,"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 factors 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"]
[]
["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":68,"n_cols":14,"rows_kept":68,"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 Factors Here",null,null,null,null,null,null,"Enter Contract Specific Information Here",""]
["ALL",null,null,null,null,"Normal Work Adjustment Factor",null,null,null,null,"Each",null,"Job Number"]
["TRAFFIC CONTROL ITEMS",null,null,null,null,"Nighttime Work Adjustment Factor",null,null,null,null,"Each",null,"Contract ID"]
["WORK BEYOND SHOULDER",120,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor"]
["SHOULDER WORK - UNDIVIDED ROADWAYS",190,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor Phone Number"]
["RIGHT SHOULDER WORK - HIGH SPEED RDWY",265,6169902,"EA"]
["LEFT SHOULDER WORK - HIGH SPEED ROADWAY",375,6169902,"EA",null,"Direction (N, S, E, W)",null,"SELECT"]
["1-LANE 2-WAY OPERATION W/ FLAGGERS",650,6169902,"EA",null,null,null,"N"]
["SINGLE LANE CLOSURE",700,6169902,"EA",null,null,null,"S"]
["PARTIAL RAMP CLOSURE",325,6169902,"EA",null,null,null,"E"]
["COMPLETE RAMP CLOSURE",600,6169902,"EA",null,null,null,"W"]
["ENTRANCE RAMP AREA, MAINLINE WORK",325,6169902,"EA"]
["ENTRANCE RAMP AREA, ACCEL LANE WORK",300,6169902,"EA",null,"County:"]
["EXIT RAMP AREA, MAINLINE/DECEL LANE WORK",350,6169902,"EA",null,"SELECT",null,null,null,null,null,null,"Maintenance Sup't"]
["ADDITIONAL TRUCK MOUNTED ATTENUATOR",250,6169902,"EA",null,null,null,null,null,null,null,null,"SELECT"]
["ADDITIONAL FLASHING ARROW PANEL",95,6169902,"EA"]
["ADDITIONAL DIRECTIONAL INDICATOR BARRICADE",11,6169902,"EA"]
["ADDITIONAL CHANNELIZER (TRIMLINE/DRUM)",8,6169902,"EA"]
["ADDITIONAL CHANGEABLE MESSAGE SIGN",500,6169902,"EA"]
["SEQUENTIAL FLASHING WARNING LIGHT",50,6169902,"EA"]
["ADDITIONAL TRAFFIC CONTROL SIGNS",4,6169904,"SQFT"]
[]
[]
["Fence"]
[]
["FENCE ITEMS"]
["REM EXIST CONC POST FOOTING (CH-L AND WW)",50,2029902,"EA"]
["REMOVE CHAIN-LINK OR WOVEN WIRE FENCE",3,2029903,"LF"]
["REMOVE ORNAMENTAL PEDESTRIAN FENCE",5,2029903,"LF"]
["CHAIN-LINK FENCE (60 IN.)",12,"6071012A","LF"]
["CHAIN-LINK FENCE (72 IN.)",16,"6071013A","LF"]
["3-S BARB WIRE EXTENSION FOR CHAIN-LINK FENCE",4,"6071043A","LF"]
["(112 IN.) CURVED TOP PED FENCE (STRUCTURES)",100,6071067,"LF"]
["WOVEN WIRE FENCE",8,6072010,"LF"]
["ORNAMENTAL PED FENCE (72 IN.) (PWD COATED)",95,6079903,"LF"]
["5 FT X 60 IN CHAIN-LINK WALK GATE (GALV)",500,6079902,"EA"]
["5 FT WOVEN WIRE WALK GATE",400,6079902,"EA"]
["RESTRETCH/REATTACH FAB TO POST (CH-L AND WW)",10,6079902,"EA"]
["REALIGN LINE POST (CH-L AND WW)",10,6079902,"EA"]
["REALIGN END, CORNER, GATE, PULL POST (CH-L AND WW)",20,6079902,"EA"]
["R&R 6’ FENCE/LIGHT POST W/FLOOR PLATE (PWD COATED)",130,6079902,"EA"]
["R&R 6’ x 8’ ORNAMENTAL PED. FENCE PANEL (PWD COATED)",318,6079902,"EA"]
["R&R RAIL EXTENSION & EXPANSION STRAP (PWD COATED)",75,6079902,"EA"]
["R&R 5' LINE POST (GALV)",50,6079902,"EA"]
["R&R 5' END, CORNER, GATE, PULL POST (GALV)",200,6079902,"EA"]
["R&R HORIZONTAL BRACE (GALV)",30,6079902,"EA"]
["R&R 5' TRUSS ROD (GALV)",10,6079902,"EA"]
["R&R 6' LINE POST (GALV)",60,6079902,"EA"]
["R&R 6' END, CORNER, GATE, PULL POST (GALV)",210,6079902,"EA"]
["R&R 5' STRETCHER BAR (GALV)",10,6079902,"EA"]
["R&R 6' STRETCHER BAR (GALV)",10,6079902,"EA"]
["R&R 6' TRUSS ROD (GALV)",10,6079902,"EA"]
["R&R 5' STRETCHER BAR (VINYL)",10,6079902,"EA"]
["R&R 5' LINE POST (VINYL)",50,6079902,"EA"]
["R&R 5' END, CORNER, GATE, PULL POST (VINYL)",210,6079902,"EA"]
["R&R HORIZONTAL BRACE (VINYL)",35,6079902,"EA"]
["R&R 5' TRUSS ROD (VINYL)",10,6079902,"EA"]
["R&R STEEL LINE POST (WW)",20,6079902,"EA"]
["R&R STEEL END, CORNER, GATE, PULL POST (WW)",100,6079902,"EA"]
["R&R STEEL ANGLED BRACE (WW)",50,6079902,"EA"]
["CHAIN-LINK FENCE - VINYL (60 IN)",14,6079903,"LF"]
["REPL/SPLICE BARBED WIRE (CH-L AND WW)",4,6079903,"LF"]
["REPL/SPLICE 6' CH-LINK FENCE FAB (GALV)",9,6079903,"LF"]
["R&R TEN WIRE - R/R RAIL W/ TEN WIRE (GALV)",3,6079903,"LF"]
["REPL/SPLICE 5' CH-LINK FENCE FAB (GALV)",6,6079903,"LF"]
["REPL/SPLICE 5' CH-LINK FENCE FAB (VINYL)",7,6079903,"LF"]
["R&R TEN WIRE - R/R RAIL W/ TEN WIRE (VINYL)",3,6079903,"LF"]
["REPL/SPLICE WOVEN WIRE FENCE FAB (WW)",4,6079903,"LF"]

{"sheet":"Fence","index":2,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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],[21,1,21,2],[21,3,21,4],[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],[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],[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],[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],[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],[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],[50,1,50,2],[50,3,50,4],[50,8,50,9],[51,1,51,2],[51,3,51,4],[51,8,51,9],[48,1,48,2],[48,3,48,4],[48,8,48,9],[49,1,49,2],[49,3,49,4],[49,8,49,9],[54,8,54,9],[55,1,55,11],[56,8,56,9],[58,7,58,8],[52,1,52,2],[52,3,52,4],[52,8,52,9],[53,1,53,2],[53,3,53,4],[53,8,53,9],[67,2,67,4],[67,8,67,9],[68,8,68,9],[72,6,72,9],[58,3,58,5],[59,3,59,5],[60,3,60,5],[64,2,64,4],[64,8,64,9],[65,2,65,4],[65,8,65,9],[66,2,66,4],[66,8,66,9],[61,6,61,8],[63,2,63,4],[63,8,63,9],[59,7,59,8],[60,7,60,8]]}
[null,"Missouri Department of Transportation"]
[null,"2022 Fence 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,"Normal","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":"K73","v":0},null,"TOTAL COMPLETED PRICE THIS WORK ORDER:",null,null,null,{"$f":"L73","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,"Fence",null,{"$f":"'Contract Data'!A26","v":"FENCE ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$27:$D$68,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$27:$D$68,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$27:$D$68,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$27:$D$68,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$27:$D$68,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$27:$D$68,3,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$27:$D$68,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D54,'Contract Data'!$A$27:$D$68,4,FALSE)),\"\",VLOOKUP(D54,'Contract Data'!$A$27:$D$68,4,FALSE))","v":""},null,{"$f":"IF(D54>0,VLOOKUP(D54,'Contract Data'!$A$27:$D$68,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 (NORMAL/NIGHTTIME)"]
[]
[null,null,null,"Adjustment Factors",null,null,"Factor","Estimated Subtotal",null,"Est. Adj.\nSubtotal","Final Subtotal","Final Adj.\nSubtotal"]
[null,null,null,"Normal Work Adjustment Factor",null,null,{"$f":"IF(I8=TRUE(),'Contract Data'!J2,\"\")","v":""},{"$f":"I57","v":0},null,{"$f":"IF(G60=\"\",0,G60*H60)","v":0},{"$f":"L57","v":0},{"$f":"IF(G60=\"\",0,G60*K60)","v":0}]
[null,null,null,"Nighttime Work Adjustment Factor",null,null,{"$f":"IF(J8=TRUE(),'Contract Data'!J3,\"\")","v":""},{"$f":"I57","v":0},null,{"$f":"IF(G61=\"\",0,G61*H61)","v":0},{"$f":"L57","v":0},{"$f":"IF(G61=\"\",0,G61*K61)","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J60:J61)","v":0},null,{"$f":"SUM(L60:L61)","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":"G65*H65","v":0},null,null,{"$f":"H65*K65","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G66*H66","v":0},null,null,{"$f":"H66*K66","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(I65:J68)","v":0},null,null,{"$f":"SUM(L65:L68)","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(J62+I69)","v":0},{"$f":"SUM(L62+L69)","v":0}]

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