{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Estimate Form","Materials Worksheet","Materials Assemblies","Construction Labor","Eng Labor"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Estimate Form","index":0,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[[9,9,10,9],[61,3,61,4],[62,3,62,5],[63,3,63,4],[37,3,37,5],[38,3,38,4],[0,1,0,4],[24,3,24,4],[25,3,25,4],[10,1,10,6],[11,1,11,6],[23,3,23,4],[12,1,12,6],[13,1,13,6]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Fill this out first:"]
[]
[null,null,null,null,null,null,null,null,null,"SYSTEM NAME","Southwood"]
[null,null,null,null,null,null,null,null,null,"PROJECT DISCRIPTION","Dietrich Firs Distribution Extension"]
[null,"                                           ",null,null,null,null,null,null,null,"COUNTY","Pierce"]
[null,null,null,null,null,null,null,null,null,"ENG. FILE #",3909]
[null,null,null,null,null,null,null,null,null,"PROJECT TYPE",false]
[null,{"$f":"$K$6","v":"Southwood"},null,null,null,null,null,null,null,null,true]
[null,{"$f":"$K$7","v":"Dietrich Firs Distribution Extension"},null,null,null,null,null,null,null,"TCJA RATE",0.21]
[null,{"$f":"TODAY()","v":"2021-08-27"},null,null,null,null,null,null,null,"WWS OH RATE",0.31]
[null,"(Projected Cost Good for 30-Days)",null,null,null,null,null,null,null,"STATE B/O",1.4999999999999999E-2]
[null,null,null,null,null,"Engineering File #",{"$f":"K9","v":3909}]
[null,null,null,"*** Construction Materials ***"]
[null,"Unit of Property","Description","Quantity","Unit of Measure","Unit Cost","Total"]
[null,103240,"Construction Materials, Pipe, Valves, Fittings, Etc",1,"LS",{"$f":"IF(AND(K11,NOT(K10)),'Materials Worksheet'!G47*(1+K13),'Materials Worksheet'!G47)","v":2825.449134},{"$f":"F18*D18","v":2825.449134},null,null,"Edit Unit of Property as Needed in All Categories"]
[null,103450,"Construction Materials for Services",1,"LS",{"$f":"IF(AND(K11,NOT(K10)),'Materials Worksheet'!G59*(1+K13),'Materials Worksheet'!G59)","v":0},{"$f":"F19*D19","v":0}]
[null,103480,"Construction Materials for Hydrants",1,"LS",null,0,null,null,"NOTE:"]
[null,null,null,null,null,null,0,null,null,"The 21% Federal Income Tax per the \"Tax Cuts & Jobs Act\" of 2017 applies to CICA projects ONLY."]
[null,null,null,null,null,null,{"$f":"D22*F22","v":0},null,null,"State B&O Tax tax applies to CICA projects only."]
[null,null,null,"Sub-Total",null,null,{"$f":"SUM(G18:G22)","v":2825.449134}]
[null,null,null,"Contingency",null,0.1,{"$f":"G23*F24","v":282.54491339999998}]
[null,null,null,"Sales Tax",null,0.09,{"$f":"(G23+G24)*F25","v":279.71946426599999},null,null,"INVENTORY COST SHEET LINK"]
[null,null,null,"SUB Total - Materials",null,null,{"$f":"G23+G24+G25","v":3387.7135116660002}]
[null,null,null,"Rounded Up Value",null,null,{"$f":"ROUNDUP(G26,-2)","v":3400},null,null,null,"Use this button for nearside 1\" service installation"]
[]
[null,null,null,"*** Construction Labor ***"]
[null,"Unit of Property","Description","Quantity","Unit of Measure","Unit Cost","Total"]
[null,103240,"Construction Labor - Watermain",1,"LS",{"$f":"IF(AND(K11,NOT(K10)),'Construction Labor'!G21*(1+K13),'Construction Labor'!G21)","v":5502},{"$f":"F31*D31","v":5502}]
[null,103450,"Construction Labor - Services",1,"LS",{"$f":"IF(AND(K11,NOT(K10)),'Construction Labor'!P21*(1+K13),'Construction Labor'!P21)","v":786},{"$f":"F32*D32","v":786}]
[null,103480,"Construction Labor - Hydrants",1,"LS",{"$f":"IF(AND(K11,NOT(K10)),'Construction Labor'!Y21*(1+K13),'Construction Labor'!Y21)","v":2358},2358]
[null,null,null,null,null,null,0]
[null,null,"WWSC Engineering",1,"LS",{"$f":"IF(AND(K11,NOT(K10)),'Eng Labor'!H42*(1+K13),'Eng Labor'!H42)","v":2665.85},2665.85]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G31:G37)","v":11311.85}]
[null,null,null,"Contingency",null,0.1,{"$f":"G38*F39","v":1131.1850000000002}]
[null,null,null,"Sub-Total - Construction Labor",null,null,{"$f":"G38+G39","v":12443.035}]
[null,null,null,"Rounded Up Value",null,null,{"$f":"ROUNDUP(G40,-2)","v":12500}]
[]
[null,null,null,"*** Outside Contractor ***"]
[null,"Unit of Property","Description","Quantity","Unit of Measure","Unit Cost","Total"]
[null,null,"County Permits (Encroachment)",1,"LS",396,{"$f":"F45*D45","v":396}]
[null,null,"DOH Review Fees",1,"LS",null,{"$f":"F46*D46","v":0}]
[null,null,"Tapping Contractor",1,"LS",null,0]
[null,null,"Geotechnical Engineer",1,"LS",null,0]
[null,null,"Engineering Consultant",1,"LS",null,0]
[null,null,"Land Surveyor",1,"LS",null,{"$f":"F50*D50","v":0}]
[null,null,"Land Cost",1,"LS",null,0]
[null,null,"Additional Insurance",1,"LS",null,0]
[null,null,"Bonding",1,"LS",null,0]
[null,null,"Sanitary Facility Rental (Portable Toilet)",1,"LS",{"$f":"IF(AND(K11,NOT(K10)),'Construction Labor'!D35*(1+K13),'Construction Labor'!D35)","v":0},0]
[null,null,"Paving Contractor - Pavement Restoration",1,"LS",null,0]
[null,null,"Traffic Control Contractor - Flaggers",1,"LS",{"$f":"IF(AND(K11,NOT(K10)),'Construction Labor'!E30*(1+K13),'Construction Labor'!E30)","v":0},0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,"SUB TOTAL",null,null,{"$f":"SUM(G45:G60)","v":396}]
[null,null,null,"Contingency",null,0.1,{"$f":"G61*F62","v":39.6},null,null,"50% of total project cost",{"$f":"G72/2","v":37545.733877464168}]
[null,null,null,"Sub-Total - Outside Contractor",null,null,{"$f":"SUM(G61:G62)","v":435.6},null,null,"total cost of watermains",{"$f":"G18*(1+F24)*(1+F25) + G31*(1+F39) +( G54+G55+G56+G45+G50)*(1+F62)","v":9875.5135116660003}]
[null,null,null,"Rounded Up Value",null,null,{"$f":"ROUNDUP(G63,-2)","v":500}]
[null,null,null,null,null,null,null,null,null,"enter footage below"]
[null,null,null,"Project Subtotal =",null,null,{"$f":"ROUNDUP(G27+G41+G64,-2)","v":16400},null,null,575,"LF",{"$f":"IFERROR(K63/J66,0)","v":17.174806107245217},"$/LF  Pre Tax"]
[null,null,null,{"$f":"IF(OR(K10,K11),IF(AND(K11,NOT(K10)),\"Federal Tax per the TCJA =\",IF(AND(K10,NOT(K11)),\"Construction OH=\",IF(AND(K11,K10),\"SELECT ONLY ONE PROJECT TYPE\"))))","v":"Federal Tax per the TCJA ="},null,null,{"$f":"IF(OR(K10,K11),IF(AND(K11,NOT(K10)),G66*(1/(1-K12)-1),IF(AND(K10,NOT(K11)),(G66*K13),IF(AND(K11,K10),\"WARNING\"))))","v":4359.4936708860741}]
[null,null,null,"State B&O Tax =",null,null,{"$f":"IF(OR(K10,K11),IF(AND(K11,NOT(K10)),SUM(G66:G67)*(1/(1-K14)-1),IF(AND(K10,NOT(K11)),0,IF(AND(K11,K10),\"WARNING\"))))","v":316.13442138405054}]
[null,null,"Anticiapted Developer (onsite) Costs","East Pierce Facilities Charge =",null,null,{"$f":"16*1960.76","v":31372.16}]
[null,null,{"$f":"'Materials Worksheet'!O75","v":85183.366349999997},"Anticipated TCJA Tax = ",null,null,{"$f":"C70*(1/(1-K12) - 1)","v":22643.679662658215}]
[]
[null,null,null,"Projected Funds Required =",null,null,{"$f":"SUM(G66:G70)","v":75091.467754928337}]
[]
[null,null,"Assumptions:"]
[null,null,"1) This document is intended to forecast approximate construction costs based upon current information and similar projects,  and is not"]
[null,null,"    intended to accurately represent actual design or construction components or prices."]
[null,null,"2) Totals are rounded to nearest $100"]

{"sheet":"Materials Worksheet","index":1,"n_rows":78,"n_cols":15,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'Estimate Form'!$K$6","v":"Southwood"}]
[null,null,{"$f":"CONCATENATE('Estimate Form'!$K$8, \" County\")","v":"Pierce County"},null,null,"Eng. File #",{"$f":"'Estimate Form'!$K$9","v":3909}]
[null,null,{"$f":"'Estimate Form'!K7","v":"Dietrich Firs Distribution Extension"}]
[null,null,"Engineer's Opinion of Projected Construction Materials Costs"]
[null,null,{"$f":"TODAY()","v":"2021-08-27"}]
[]
[]
[null,"OFFSITE - PROVIDED BY WWS",null,null,null,null,null,null,null,"ONSITE ASSETS BY OTHERS"]
["Unit of Property","Inventory Number","Task - WATERMAIN","Quantity","Units","Unit Cost","Total",null,"Unit of Property","Inventory Number","Task - WATERMAIN","Quantity","Units","Unit Cost","Total"]
[]
[]
[]
[]
[null,null,"8\" MJ x FLG GATE VALVE",1,"EA",930,{"$f":"D14*F14","v":930},null,null,null,"8\" DUCTILE IRON PIPE",75,"FT",18.22,{"$f":"L14*N14","v":1366.5}]
[null,null,"8 x 8 TAPPING SLEEVE",1,"EA",851,851,null,null,null,"6\" DUCTILE IRON PIPE",500,"FT",17.2,8600]
[null,null,"bedding, locator wire, blocking",1,"LS",300,{"$f":"D16*F16","v":300},null,null,null,"8\" MEGALUG PK/KIT (DI)",6,"EA",56,{"$f":"L16*N16","v":336}]
[null,null,"AWWA Gate Valve Assembly",1,"EA",{"$f":"'Materials Assemblies'!P29","v":62.791399999999996},{"$f":"D17*F17","v":62.791399999999996},null,null,null,"8\" MJ 90  ELBOW",2,"EA",113,226]
[null,null,"8\" FLG BOLT & GSKT KIT",1,"EA",13.04,13.04,null,null,null,"6\" MJ SOLID CAP",1,"EA",26,26]
[null,null,null,null,null,null,0,null,null,null,"bedding, locator wire, blocking, misc",1,"LS",1500,1500]
[null,null,null,null,null,null,0,null,null,null,"6\" MJ REDUCER",1,"EA",45,45]
[null,null,null,null,null,null,0,null,null,null,"Blow-Off Assembly",1,"LS",{"$f":"'Materials Assemblies'!G101","v":564.85775000000001},564.85775000000001]
[null,null,null,null,null,null,0,null,null,null,"Temp  Testing Service",1,"LS",{"$f":"'Materials Assemblies'!P22","v":162.57999999999998},162.57999999999998]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,"Construction Labor (4 person Crew @ $75/hr)",80,"hr",{"$f":"75*4","v":300},{"$f":"L24*N24","v":24000}]
[null,null,null,null,null,null,0,null,null,null,"Engineering",1,"LS",15000,15000]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,"Traffic Control",1,"LS",3200,3200]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,"Open Cut - Pavement Restoration",1,"LS",3500,3500]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"D41*F41","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G14:G45)","v":2156.8314},null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(O14:O45)","v":58526.937749999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"$/ft",{"$f":"O47/SUM(L14,L15)","v":101.78597869565218}]
[]
["Unit of Property","Inventory Number","Task - SERVICES","Quantity","Units","Unit Cost","Total",null,"Unit of Property","Inventory Number","Task - SERVICES","Quantity","Units","Unit Cost","Total"]
[]
[]
[103450,null,"5/8 x 3/4 Meter Single Service Assembly w/ 1\" Service Line",0,"EA",{"$f":"'Materials Assemblies'!G45","v":371.73500000000001},{"$f":"D53*F53","v":0},null,103450,null,"5/8 x 3/4 Meter Single Service Assembly w/ 1\" Service Line",2,"EA",{"$f":"'Materials Assemblies'!G45","v":371.73500000000001},{"$f":"L53*N53","v":743.47}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"'Materials Assemblies'!K31","v":"5/8 x 3/4 Meter Double Service Assembly w/ 1\" Service Line"},7,"EA",{"$f":"'Materials Assemblies'!P47","v":756.18500000000006},5293.2950000000001]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,"Construction Labor (4 person Crew @ $75/hr)",48,"hr",{"$f":"75*4","v":300},14400]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G53:G57)","v":0},null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(O53:O57)","v":20436.764999999999}]
[]
[]
[]
[]
["Unit of Property","Inventory Number","Task - HYDRANTS","Quantity","Units","Unit Cost","Total",null,"Unit of Property","Inventory Number","Task - HYDRANTS","Quantity","Units","Unit Cost","Total"]
[]
[]
[103480,null,"Fire Hydrant",0,"EA",{"$f":"'Materials Assemblies'!G28","v":3219.6636000000003},{"$f":"D67*F67","v":0},null,103480,null,"Fire Hydrant",1,"EA",{"$f":"'Materials Assemblies'!G28","v":3219.6636000000003},{"$f":"L67*N67","v":3219.6636000000003}]
[null,null,null,null,null,null,{"$f":"D68*F68","v":0},null,null,null,"Construction Labor (4 person Crew @ $75/hr)",10,"hr",{"$f":"75*4","v":300},{"$f":"L68*N68","v":3000}]
[null,null,null,null,null,null,{"$f":"D69*F69","v":0},null,null,null,null,null,null,null,{"$f":"L69*N69","v":0}]
[null,null,null,null,null,null,{"$f":"D70*F70","v":0},null,null,null,null,null,null,null,{"$f":"L70*N70","v":0}]
[null,null,null,null,null,null,{"$f":"D71*F71","v":0},null,null,null,null,null,null,null,{"$f":"L71*N71","v":0}]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G67:G71)","v":0},null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(O67:O71)","v":6219.6635999999999}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(O73,O59,O47)","v":85183.366349999997}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"CIAC TAX (21%)",null,{"$f":"O75*(1/(1-0.21)-1)","v":22643.679662658215}]

{"sheet":"Materials Assemblies","index":2,"n_rows":145,"n_cols":23,"rows_kept":145,"cut":false,"hidden":false,"merged":[[135,3,135,5]]}
[null,null,{"$f":"'Estimate Form'!$K$6","v":"Southwood"}]
[null,null,{"$f":"CONCATENATE('Estimate Form'!$K$8, \" County\")","v":"Pierce County"},null,null,"Eng. File #",{"$f":"'Estimate Form'!$K$9","v":3909}]
[null,null,{"$f":"'Estimate Form'!K7","v":"Dietrich Firs Distribution Extension"}]
[null,null,"Engineer's Opinion of Projected Construction Materials Costs"]
[null,null,{"$f":"TODAY()","v":"2021-08-27"}]
[]
[]
[]
[]
[null,null,"Assembly Items Listed Below"]
[]
[]
[null,null,"Hydrant Assembly"]
[null,"60600033","6\" Dry-Barrel Hydrant",1,"EA",{"$f":"[1]Extract!$O$1606","v":1881.12},{"$f":"D14*F14","v":1881.12},null,null,null,null,"Temporary Testing Service"]
[null,"60500031","5\" Storz Adaptor",1,"EA",{"$f":"[1]Extract!$O$1604","v":136.5},136.5,null,null,null,"30800181","8 x 1 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$689","v":51.57},{"$f":"M15*O15","v":51.57}]
[null,"60600081","18\" Valve Box Riser /w Lid",1,"EA",{"$f":"[1]Extract!$O$1609","v":35.54},35.54,null,null,null,"40100255","1\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$831","v":28.89},28.89]
[null,"60600082","CI Valve Box Bottom Section",1,"EA",{"$f":"[1]Extract!$O$1610","v":22.23},22.23,null,null,null,"60100012","1\" CL 200 POLY PIPE",12,"LF",{"$f":"[1]Extract!$O$1568","v":0.49},5.88]
[null,"30600194","6\"x6\" Tee, MJxFLG",1,"EA",{"$f":"[1]Extract!$O$643","v":114.89},114.89,null,null,null,"40100220","1\" ANGLE STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$824","v":49.57},49.57]
[null,"30600141","6\" Ductile Iron Pipe Cl 50",12,"LF",{"$f":"[1]Extract!$O$632","v":17.11},205.32,null,null,null,"100034060","RES METER BOX w/lid, STANDARD",1,"EA",{"$f":"[1]Extract!$O$1950","v":26.67},26.67]
[null,"30600028","6\" MEGALUG PK/KIT (DI)",2,"EA",{"$f":"[1]Extract!$O$613","v":41.64},83.28,null,null,null,null,null,null,null,null,0]
[null,"30800029","8\" MEGALUG PK/KIT (PVC)",2,"EA",{"$f":"[1]Extract!$O$664","v":66},132]
[null,"30600030","6\" FLG BOLT & GSKT KIT",2,"EA",{"$f":"[1]Extract!$O$615","v":9.5500000000000007},19.100000000000001,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P15:P20)","v":162.57999999999998}]
[null,"40600285","6\" MJ x FLG GATE VALVE",1,"EA",{"$f":"[1]Extract!$O$923","v":577.94000000000005},577.94000000000005]
[null,null,"GRAVEL 1 1/4 minus",0.5,"CY",{"$f":"[1]Extract!$O$2006","v":9.8000000000000007},4.9000000000000004,null,null,null,null,"AWWA Gate Valve Assembly"]
[null,"125004816","Support Blocks",6,"EA",{"$f":"[1]Extract!$O$2002","v":1.1406000000000001},6.8436000000000003,null,null,null,"60600081","18\" Valve Box Riser /w Lid",1,"EA",{"$f":"[1]Extract!$O$1609","v":35.54},{"$f":"O25*M25","v":35.54}]
[null,null,null,null,null,null,0,null,null,null,"60600082","CI Valve Box Bottom Section",1,"EA",{"$f":"[1]Extract!$O$1610","v":22.23},{"$f":"O26*M26","v":22.23}]
[null,null,null,null,null,null,null,null,null,null,"51400155","LOCATOR WIRE, # 14",6,"LF",{"$f":"[1]Extract!$O$1521","v":7.6499999999999999E-2},0.45899999999999996]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G14:G26)","v":3219.6636000000003},null,null,null,"125004816","Support Blocks",4,"EA",{"$f":"[1]Extract!$O$2002","v":1.1406000000000001},4.5624000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P25:P28)","v":62.791399999999996}]
[]
[null,null,"5/8 x 3/4 Meter Single Service Assembly w/ 1\" Service Line",null,null,null,null,null,null,null,"5/8 x 3/4 Meter Double Service Assembly w/ 1\" Service Line"]
[null,"30800181","8 x 1 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$689","v":51.57},{"$f":"D32*F32","v":51.57},null,null,null,"30800181","8 x 1 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$689","v":51.57},{"$f":"M32*O32","v":51.57}]
[null,"40100255","1\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$831","v":28.89},28.89,null,null,null,"40100255","1\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$831","v":28.89},28.89]
[null,"60100012","1\" CL 200 POLY PIPE",30,"LF",{"$f":"[1]Extract!$O$1568","v":0.49},14.7,null,null,null,"60100012","1\" CL 200 POLY PIPE",30,"LF",{"$f":"[1]Extract!$O$1568","v":0.49},14.7]
[null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[1]Extract!$O$1521","v":7.6499999999999999E-2},2.2949999999999999,null,null,null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[1]Extract!$O$1521","v":7.6499999999999999E-2},2.2949999999999999]
[null,null,"Meter Setter - Ford VH72-12W-11-44-NL",1,"EA",{"$f":"[1]Extract!$O$1946","v":144.94},144.94,null,null,null,null,"Meter Setter - Ford VH72-12W-11-44-NL",2,"EA",{"$f":"[1]Extract!$O$1946","v":144.94},289.88]
[null,"60100021","1\" PJ x  MIPT POLY ADAPTOR-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$1559","v":36.67},36.67,null,null,null,null,"1\" x 18\" BRASS NIPPLE",4,"EA",60,240]
[null,null,"1\" x 18\" BRASS NIPPLE",1,"EA",60,60,null,null,null,"100034060","RES METER BOX w/lid, STANDARD",2,"EA",{"$f":"[1]Extract!$O$1950","v":26.67},53.34]
[null,"100034060","RES METER BOX w/lid, STANDARD",1,"EA",{"$f":"[1]Extract!$O$1950","v":26.67},26.67,null,null,null,null,"2x4 Marker",2,"EA",6,12]
[null,null,"2x4 Marker",1,"EA",6,6,null,null,null,"60100021","1\" PJ x  MIPT POLY ADAPTOR-NO",1,"EA",{"$f":"[1]Extract!$O$1559","v":36.67},36.67]
[null,null,null,null,null,null,0,null,null,null,"80100190","1\" BRASS TEE",1,"EA",{"$f":"[1]Extract!$O$1784","v":8.6},8.6]
[null,null,null,null,null,null,0,null,null,null,"80100090","1\" 90 BRASS ELBOW",3,"EA",{"$f":"[1]Extract!$O$1768","v":6.08},18.240000000000002]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G32:G43)","v":371.73500000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P32:P44)","v":756.18500000000006}]
[]
[]
[]
[]
[null,null,"5/8 x 3/4 Meter Single Service Assembly w/ 1½ Service Line",null,null,null,null,null,null,null,"5/8 x 3/4 Meter Double Service Assembly w/ 1½\" Service Line"]
[null,"30800183","8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$690","v":99.47},{"$f":"D53*F53","v":99.47},null,null,null,"30800183","8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$690","v":99.47},{"$f":"M53*O53","v":99.47},null,"3/4 x 3/4 Meter Double Service Assembly w/ 1½\" Service Line"]
[null,"40200255","2\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$878","v":216.67},216.67,null,null,null,"40200255","2\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$878","v":216.67},216.67,null,30800183,"8 x 2 TAPPING SADDLE",1,"EA",128.37,128.37]
[null,"60112012","1-1-2\" CL 200 POLY PIPE",30,"LF",{"$f":"[1]Extract!$O$1579","v":1.35},40.5,null,null,null,"60112012","1-1-2\" CL 200 POLY PIPE",30,"LF",{"$f":"[1]Extract!$O$1579","v":1.35},40.5,null,40200255,"2\" CORP STOP VALVE-NO LEAD",1,"EA",288.05,288.05]
[null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[1]Extract!$O$1521","v":7.6499999999999999E-2},2.2949999999999999,null,null,null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[1]Extract!$O$1521","v":7.6499999999999999E-2},2.2949999999999999,null,60112012,"1-1-2\" CL 200 POLY PIPE",30,"LF",2.23,66.97]
[null,null,"Meter Setter - Ford VH72-12W-11-66-NL",1,"EA",{"$f":"[1]Extract!$O$1946","v":144.94},144.94,null,null,null,null,"Meter Setter - Ford VH72-12W-11-66-NL",2,"EA",{"$f":"[1]Extract!$O$1946","v":144.94},289.88,null,51400155,"LOCATOR WIRE, # 14",30,"LF",2.96,88.84]
[null,"60112021","1-1/2\" PJ x MIPT POLY ADAPTOR",1,"EA",{"$f":"[1]Extract!$O$1583","v":67.900000000000006},67.900000000000006,null,null,null,null,"1½\" x 18\" BRASS NIPPLE",4,"EA",60,240,null,null,"Meter Setter - Ford VH73-12W-11-66-NL",2,"EA",220,440]
[null,null,"1½\" x 18\" BRASS NIPPLE",1,"EA",60,60,null,null,null,"100034060","RES METER BOX w/lid, STANDARD",2,"EA",{"$f":"[1]Extract!$O$1950","v":26.67},53.34,null,null,"1½\" x 18\" BRASS NIPPLE",2,"EA",60,120]
[null,"100034060","RES METER BOX w/lid, STANDARD",1,"EA",{"$f":"[1]Extract!$O$1950","v":26.67},26.67,null,null,null,null,"2x4 Marker",2,"EA",6,12,null,100034060,"RES METER BOX w/lid, STANDARD",2,"EA",37.06,74.11]
[null,null,"2x4 Marker",1,"EA",6,6,null,null,null,"60112021","1-1/2\" PJ x MIPT POLY ADAPTOR",2,"EA",{"$f":"[1]Extract!$O$1583","v":67.900000000000006},135.80000000000001,null,null,"2x4 Marker",2,"EA",6,12]
[null,null,"2\"x1½\" Brass Bell Reducer",1,"EA",45,45,null,null,null,"80112190","1-1/2\" BRASS TEE",1,"EA",{"$f":"[1]Extract!$O$1793","v":17.55},17.55,null,60112021,"1-1/2\" PJ x MIPT POLY ADAPTOR",2,"EA",87.67,175.35]
[null,null,null,null,null,null,0,null,null,null,null,"1½\" 90 BRASS ELBOW",3,"EA",{"$f":"[1]Extract!$O$1787","v":15},45,null,80112190,"1-1/2\" BRASS TEE",1,"EA",22.01,22.01]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"1½\" 90 BRASS ELBOW",3,"EA",22,66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,80100134,"1½\" x 18\" BRASS NIPPLE",2,"EA",60,120]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G53:G64)","v":709.44499999999994},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," $-   "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P53:P65)","v":1152.5050000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Sub-Total ",1601.7]
[]
[]
[]
[null,null,"1\" Meter Single Service Assembly",null,null,null,null,null,null,null,"1½\" Meter Single Service Assembly"]
[null,"30800183","8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$690","v":99.47},{"$f":"D74*F74","v":99.47},null,null,null,"30800183","8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$690","v":99.47},{"$f":"M74*O74","v":99.47}]
[null,"40200255","2\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$878","v":216.67},216.67,null,null,null,"40200255","2\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$878","v":216.67},216.67]
[null,"60112012","1-1-2\" CL 200 POLY PIPE",30,"LF",{"$f":"[1]Extract!$O$1579","v":1.35},40.5,null,null,null,"60200012","2\" CL 200 POLY PIPE",30,"LF",{"$f":"[1]Extract!$O$1593","v":2.09},62.699999999999996]
[null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[1]Extract!$O$1521","v":7.6499999999999999E-2},2.2949999999999999,null,null,null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[1]Extract!$O$1521","v":7.6499999999999999E-2},2.2949999999999999]
[null,null,"Meter Setter - Ford VH74-12W-11-66-NL",1,"EA",{"$f":"[1]Extract!$O$1945","v":232.98},232.98,null,null,null,null,"Meter Setter - Ford VBHH76-18HBHC-11-77",1,"EA",1477,1477]
[null,null,"1½\" x 18\" BRASS NIPPLE",1,"EA",60,60,null,null,null,null,"2\" x 18\" BRASS NIPPLE",1,"EA",41.33,41.33]
[null,"100034060","RES METER BOX w/lid, STANDARD",1,"EA",{"$f":"[1]Extract!$O$1950","v":26.67},{"$f":"D80*F80","v":26.67},null,null,null,"80200120","2\" x CLOSE BRASS NIPPLE",2,"EA",{"$f":"[1]Extract!$O$1808","v":9.6999999999999993},19.399999999999999]
[null,"100100158","1\" METER w/HRE REG+ERT",1,"EA",{"$f":"[1]Extract!$O$1966","v":305.94},{"$f":"D81*F81","v":305.94},null,null,null,null,"2\" Brass Elbow",2,"EA",{"$f":"[1]Extract!$O$1806","v":45},90]
[null,null,"2x4 Marker",1,"EA",6,{"$f":"D82*F82","v":6},null,null,null,"100034060","RES METER BOX w/lid, STANDARD",1,"EA",{"$f":"[1]Extract!$O$1950","v":26.67},{"$f":"M82*O82","v":26.67}]
[null,null,"2\"x1½\" Brass Bell Reducer",1,"EA",45,{"$f":"D83*F83","v":45},null,null,null,null,"2x4 Marker",1,"EA",6,{"$f":"M83*O83","v":6}]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G74:G83)","v":1035.5249999999999},null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P74:P83)","v":2041.5350000000001}]
[]
[]
[]
[null,null,"2\" Blowoff Assembly",null,null,null,null,null,null,"Wellhead Enclosure Assembly"]
[null,null,"2\" THREADED GATE AWWA",1,"EA",{"$f":"[1]Extract!$O$882","v":276.39},{"$f":"D90*F90","v":276.39},null,null,null,"Well 2.5 X 8"]
[null,null,"8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$690","v":99.47},99.47,null,null,"Unit of Prop","Inv No"]
[null,null,"18\" VALVE BOX RISER w/LID",1,"EA",{"$f":"[1]Extract!$O$1609","v":35.54},35.54,null,null,103240,null,"2.5\" sch 40 galv pipe (21ft lengths)",12,"EA",{"$f":"[1]Extract!$O$460*21","v":170.31},{"$f":"O92*M92","v":2043.72}]
[null,null,"VALVE BOX BOTTOM CI",1,"EA",{"$f":"[1]Extract!$O$1610","v":22.23},22.23,null,null,103240,null,"2.5\" wye fitting",0,"EA",550,{"$f":"O93*M93","v":0}]
[null,null,"2 x 6 GALV NIPPLE",4,"EA",{"$f":"[1]Extract!$O$430","v":4.66},18.64,null,null,103240,null,"2.5\" collumn check valve",2,"EA",{"$f":"[1]Extract!$O$892","v":151.62},303.24]
[null,null,"2\" GALVANIZED PIPE",6,"LF",{"$f":"[1]Extract!$O$434","v":6.42},38.519999999999996,null,null,103240,null,"8\"x 2-1/2\" SPIDER",2,"EA",{"$f":"[1]Extract!$O$1690","v":10.33},20.66]
[null,null,"2\" GALV 90 ELBOW",4,"EA",{"$f":"[1]Extract!$O$419","v":7.24},28.96,null,null,103240,null,"2.5\" x 3\" bell red galv",1,"EA",22,22]
[null,null,"2\" PVC ADAPTOR FIP",2,"EA",{"$f":"[1]Extract!$O$100","v":9.67},19.34,null,null,103240,null,"2-1/2\" GALV COUPLING",12,"EA",{"$f":"[1]Extract!$O$444","v":14.36},172.32]
[null,null,"2\" PVC PIPE,  CL 200",20,"LF",{"$f":"[1]Extract!$O$113","v":0.65},13,null,null,103240,null,"#6-4 flat jacket subcable",300,"FT",1.9,570]
[null,null,"BEDDING SAND",2.5,"CY",{"$f":"[1]Extract!$O$1999","v":5.1071},12.767749999999999,null,null,103240,null,"sounding tube",260,"FT",{"$f":"[1]Extract!$O$1624","v":1.84},478.40000000000003]
[null,null,null,null,null,null,null,null,null,103240,null,"sounding tube screen",20,"FT",1.84,36.800000000000004]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G90:G100)","v":564.85775000000001},null,null,103240,null,"assorted fittings",1,"EA",100,100]
[null,null,null,null,null,null,null,null,null,103240,null,"Well Seal",1,"EA",500,500]
[null,null,null,null,null,null,null,null,null,103240,null,"Wellhead Enclosure (Hubbel)",1,"EA",2900,2900]
[null,null,null,null,null,null,null,null,null,103240,null,"2-1/2\" BALL VALVE-NO LEAD",2,"EA",{"$f":"[1]Extract!$O$891","v":81.400000000000006},162.80000000000001]
[null,null,"2\" Air/Vac Assembly",null,null,null,null,null,null,103240,null,"1\" duck bill syle check valve",1,"ea",40,40]
[null,null,"2\" THREADED GATE AWWA",1,"EA",{"$f":"[1]Extract!$O$882","v":276.39},{"$f":"D106*F106","v":276.39},null,null,null,null,"Pad",1,"ea",1500,1500]
[null,null,"8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[1]Extract!$O$690","v":99.47},99.47]
[null,null,"18\" VALVE BOX RISER w/LID",1,"EA",{"$f":"[1]Extract!$O$1609","v":35.54},35.54]
[null,null,"VALVE BOX BOTTOM CI",1,"EA",{"$f":"[1]Extract!$O$1610","v":22.23},22.23,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P92:P106)","v":8849.94}]
[null,null,"2 x 6 GALV NIPPLE",7,"EA",{"$f":"[1]Extract!$O$430","v":4.66},32.620000000000005]
[null,null,"2\" AIR/VAC VALVE, ARI #D-040",1,"EA",{"$f":"[1]Extract!$O$887","v":288},288]
[null,null,"2\" GALVANIZED PIPE",7,"LF",{"$f":"[1]Extract!$O$434","v":6.42},44.94]
[null,null,"2\" GALV 90 ELBOW",4,"EA",{"$f":"[1]Extract!$O$419","v":7.24},28.96]
[null,null,"2\" PVC ADAPTOR FIP",2,"EA",{"$f":"[1]Extract!$O$100","v":9.67},19.34,null,null,"Chlorine Analyzer with Cell Modem"]
[null,null,"2\" GALV 180 ELBOW",1,"EA",{"$f":"[1]Extract!$O$437","v":76.709999999999994},76.709999999999994]
[null,null,"2\"  ENVIRO STRAINER-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$880","v":44.55},44.55,null,null,"Unit of Prop","Inv No"]
[null,null,"2\" GALV CAP",1,"EA",{"$f":"[1]Extract!$O$415","v":3.69},3.69,null,null,103320,null,"Kuntze Chlorine Analyzer w/ gateway",1,"EA",6100,{"$f":"O117*M117","v":6100}]
[null,null,"2\" GALV REDUCING TEE",2,"EA",{"$f":"[1]Extract!$O$439","v":10.48},20.96,null,null,103760,null,"CradlePoint Cell Modem",1,"EA",550,{"$f":"O118*M118","v":550}]
[null,null,"3/4\" ANGLE STOP VALVE-NO LEAD",1,"EA",{"$f":"[1]Extract!$O$807","v":31.13},31.13,null,null,103760,null,"CA-400 NM-SMA-20 Cable",1,"EA",65,65]
[null,null,"3/4 x 18 GALV NIPPLE",2,"EA",{"$f":"[1]Extract!$O$294","v":0.9},1.8,null,null,103760,null,"Gradle Point High Gain Antennae",1,"EA",135,135]
[null,null,"3/4 x 6 GALV NIPPLE",1,"EA",{"$f":"[1]Extract!$O$290","v":1.2549999999999999},1.2549999999999999,null,null,103760,null,"50 ft CAT5 Ethernet Cable",1,"EA",15,15]
[null,null,"3/4\" GALV 90 ELBOW",1,"EA",{"$f":"[1]Extract!$O$277","v":4.83},4.83,null,null,103760,null,"mounting hardware",1,"EA",30,30]
[null,null,"EXTRA LG METER BOX LID, STD",1,"EA",{"$f":"[1]Extract!$O$1971","v":111.11},111.11,null,null,null,null,"DPD Colorimeter",1,"EA",463,463]
[null,null,"1 1/2 x 6 GALV NIPPLE",3,"EA",{"$f":"[1]Extract!$O$373","v":3.48},10.44]
[null,null,"1-1/2\" GALV 90 ELBOW",1,"EA",{"$f":"[1]Extract!$O$361","v":3.86},3.86,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P117:P123)","v":7358}]
[null,null,"1-1/2\" GALV UNION",1,"EA",{"$f":"[1]Extract!$O$383","v":8.4700000000000006},8.4700000000000006]
[null,null,"CONCRETE VALVE BOX MARKER",1,"EA",{"$f":"[1]Extract!$O$1611","v":23.68},23.68]
[null,null,"2\" PVC PIPE,  CL 200",20,"LF",{"$f":"[1]Extract!$O$113","v":0.65},13]
[null,null,"BLOCKS 2/8  4/8  4/16 - AVG",3,"EA",{"$f":"[1]Extract!$O$2002","v":1.1406000000000001},3.4218000000000002]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G106:G129)","v":1206.3968000000002}]
[]
[]
[]
[]
[null,null,"2.5\" Pump Suspension Assembly","Enter Pump Suction Depth:",null,null,130,"FT"]
[null,"40212240","2-1/2\" INLINE CHK VALVE (DUCTILE IRON)",{"$f":"ROUND($G$136/80,0)","v":2},"EA",{"$f":"[1]Extract!$O$892","v":151.62},{"$f":"D137*F137","v":303.24}]
[null,"70822171","8\"x 2-1/2\" SPIDER",{"$f":"ROUND($G$136/80,0)","v":2},"EA",{"$f":"[1]Extract!$O$1690","v":10.33},20.66]
[null,"20212190","2-1/2\" GALV TEE",1,"EA",{"$f":"[1]Extract!$O$463","v":42.47},42.47]
[null,"20212140","2-1/2\" GALVANIZED PIPE",{"$f":"G136","v":130},"FT",{"$f":"[1]Extract!$O$460","v":8.11},1054.3]
[null,"20212070","2-1/2\" GALV COUPLING",{"$f":"ROUND(G136/20,0)","v":7},"EA",{"$f":"[1]Extract!$O$444","v":14.36},100.52]
[null,"70100156","1\" SCH 80 SOUNDING TUBE",{"$f":"G136","v":130},"FT",{"$f":"[1]Extract!$O$1624","v":1.84},239.20000000000002]
[null,"60038100","3/8\" OD PE TUBING",{"$f":"G136","v":130},"FT",{"$f":"[1]Extract!$O$1565","v":0.25},32.5]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G137:G143)","v":1792.89}]

{"sheet":"Construction Labor","index":3,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"'Estimate Form'!$K$6","v":"Southwood"}]
[null,null,null,{"$f":"CONCATENATE('Estimate Form'!$K$8, \" County\")","v":"Pierce County"},null,null,null,"Eng. File #",{"$f":"'Estimate Form'!$K$9","v":3909}]
[null,null,null,{"$f":"'Estimate Form'!$K$7","v":"Dietrich Firs Distribution Extension"}]
[null,null,null,"Engineer's Opinion of Projected Construction Materials Costs"]
[null,null,null,{"$f":"TODAY()","v":"2021-08-27"}]
[]
["WWS Construction Crew- Mains",null,null,null,null,null,null,null,null,"WWS Construction Crew- Services",null,null,null,null,null,null,null,null,"WWS Construction Crew- Hydrants"]
[]
[null,null,null,null,null,"Rate","Sub-Total",null,null,null,null,null,null,null,"Rate","Sub-Total",null,null,null,null,null,null,null,"Rate","Sub-Total"]
["1 Man & Vac Truck",null,null,8,"HRS",75,{"$f":"D10*F10","v":600},null,null,"1 Man & Vac Truck",null,null,null,"HRS",75,{"$f":"M10*O10","v":0},null,null,"1 Man & Vac Truck",null,null,null,"HRS",75,{"$f":"V10*X10","v":0}]
["1 Man & Boom Truck",null,null,null,"HRS",75,{"$f":"D11*F11","v":0},null,null,"1 Man & Boom Truck",null,null,null,"HRS",75,{"$f":"M11*O11","v":0},null,null,"1 Man & Boom Truck",null,null,null,"HRS",75,{"$f":"V11*X11","v":0}]
["1 Man & Backhoe - Trench",null,null,null,"HRS",75,{"$f":"D12*F12","v":0},null,null,"1 Man & Backhoe - Trench",null,null,null,"HRS",75,{"$f":"M12*O12","v":0},null,null,"1 Man & Backhoe - Trench",null,null,null,"HRS",75,{"$f":"V12*X12","v":0}]
["1 Man & Backhoe - Comp",null,null,null,"HRS",75,0,null,null,"1 Man & Backhoe - Comp",null,null,null,"HRS",75,0,null,null,"1 Man & Backhoe - Comp",null,null,null,"HRS",75,0]
["Admin/Prep",null,null,8,"HRS",75,600,null,null,"Admin/Prep",null,null,8,"HRS",75,{"$f":"M14*O14","v":600},null,null,"Admin/Prep",null,null,8,"HRS",75,600]
["1 Man & Truck",null,null,8,"HRS",75,600,null,null,"1 Man & Truck",null,null,null,"HRS",75,0,null,null,"1 Man & Truck",null,null,null,"HRS",75,0]
["2 Men & Truck",null,null,16,"HRS",150,2400,null,null,"2 Men & Truck",null,null,null,"HRS",150,0,null,null,"2 Men & Truck",null,null,8,"HRS",150,1200]
["1 Electrician & Truck",null,null,null,"HRS",80,0,null,null,"1 Electrician & Truck",null,null,null,"HRS",80,0,null,null,"1 Electrician & Truck",null,null,null,"HRS",80,0]
["2 Electricians & Truck",null,null,null,"HRS",160,0,null,null,"2 Electricians & Truck",null,null,null,"HRS",160,0,null,null,"2 Electricians & Truck",null,null,null,"HRS",160,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G10:G19)","v":4200},null,null,null,null,null,null,null,"Total",{"$f":"SUM(P10:P19)","v":600},null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y10:Y19)","v":1800}]
[]
["Outside Contractor - No Pilot Car"]
[]
["1-Flagger",null,"HRS",30,{"$f":"B25*D25","v":0}]
["2-Flaggers",null,"HRS",60,{"$f":"B26*D26","v":0}]
["Signs",null,"DAYS",105,{"$f":"B27*D27","v":0}]
["Other",null,"LS",null,{"$f":"B28*D28","v":0},"(RCE TRAFFIC CONTROL CUTSHEET)"]
[]
[null,null,"Sub-total",null,{"$f":"SUM(E25:E28)","v":0}]
[]
[]
["Sanitary Facility Rental (Portable Toilet)"]
[]
[null,"Days",75,{"$f":"A35*C35","v":0}]

{"sheet":"Eng Labor","index":4,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"'Estimate Form'!$K$6","v":"Southwood"},null,null,"Eng. File #",{"$f":"'Estimate Form'!$K$9","v":3909}]
[null,null,null,{"$f":"CONCATENATE('Estimate Form'!$K$8, \" County\")","v":"Pierce County"}]
[null,null,null,{"$f":"'Estimate Form'!$K$7","v":"Dietrich Firs Distribution Extension"}]
[null,null,null,"Engineer's Opinion of Projected Construction Materials Costs"]
[null,null,null,{"$f":"TODAY()","v":"2021-08-27"}]
[]
[]
[null,null,null,null,null,"Employee"]
[null,null,null,"Task","Hours","Classification","Rate","Total"]
[]
[null,null,null,"Facility Design"]
[null,null,null,"Project Setup ",1,"Engineer",85,{"$f":"E12*G12","v":85}]
[null,null,null,"Route Topo",null,"Engineer",85,{"$f":"E13*G13","v":0}]
[null,null,null,"Develop Base Drawings from Topo Info ",null,"Engineer",85,{"$f":"E14*G14","v":0}]
[null,null,null,"DOH Project Report and Approval",null,"Engineer",85,{"$f":"E15*G15","v":0}]
[null,null,null,"Design & Draft Watermain Construction Documents",null,"Engineer",85,0]
[]
[null,null,null,"Sub-Total",{"$f":"SUM(E12:E17)","v":1},null,null,{"$f":"SUM(H12:H17)","v":85}]
[]
[null,null,null,"Revisions per Peer Review Comments"]
[null,null,null,"P.E. Peer Review",2,"Principle Eng",115,{"$f":"E21*G21","v":230}]
[null,null,null,"Revisions to Construction Documents per Peer Review Comments",2,"Engineer",85,170]
[null,null,null,"Coping & Re-Submittal of Project Report & Construction Documents",null,"Clerical",60,0]
[]
[null,null,null,"Sub-Total",{"$f":"SUM(E21:E24)","v":4},null,null,{"$f":"SUM(H21:H24)","v":400}]
[]
[null,null,null,"Construction"]
[null,null,null,"Pre-Construction Conference with Engineering & Contractor",2,"Engineer",85,{"$f":"E28*G28","v":170}]
[null,null,null,"Construction Inspection & Pressure Test",8,"Engineer",85,{"$f":"E29*G29","v":680}]
[]
[null,null,null,"Sub-Total",{"$f":"SUM(E28:E30)","v":10},null,null,{"$f":"SUM(H28:H30)","v":850}]
[]
[null,null,null,"Record Documents"]
[null,null,null,"As-Built Drawings & Testing Validations along with Project Certification Document Preparation",null,"Engineer",85,{"$f":"E34*G34","v":0}]
[null,null,null,"P.E. Project Certification",null,"Principle Eng",{"$f":"G21","v":115},0]
[null,null,null,"Updating Base Maps & Site Piping",4,"Engineer",{"$f":"G22","v":85},340]
[null,null,null,"Project Close-Out",6,"Clerical",60,360]
[]
[null,null,null,"Sub Total",{"$f":"SUM(E34:E38)","v":10},null,null,{"$f":"SUM(H34:H38)","v":700}]
[]
[]
[null,null,null,"Projected Total Hours",{"$f":"E18+E25+E31+E39","v":25},null,null,{"$f":"H18+H25+H31+H39","v":2035}]