{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Estimate Form","Materials Worksheet","Materials Assemblies","Construction Labor","Eng Labor","Hyd Model Const","Consolidation Records Migration"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":7,"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":75,"n_cols":13,"rows_kept":75,"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","Peacock Hill"]
[null,null,null,null,null,null,null,null,null,"PROJECT DISCRIPTION","1\" Service Meter"]
[null,"                                           ",null,null,null,null,null,null,null,"COUNTY","Pierce"]
[null,null,null,null,null,null,null,null,null,"ENG. FILE #",3908]
[null,null,null,null,null,null,null,null,null,"PROJECT TYPE",false]
[null,{"$f":"$K$6","v":"Peacock Hill"},null,null,null,null,null,null,null,null,true]
[null,{"$f":"$K$7","v":"1\" Service Meter"},null,null,null,null,null,null,null,"TCJA RATE",0.21]
[null,{"$f":"TODAY()","v":"2021-02-11"},null,null,null,null,null,null,null,"WWS OH RATE",0.32]
[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":3908}]
[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":"'Materials Worksheet'!G47*(1+K13)","v":0},{"$f":"F18*D18","v":0},null,null,"Edit Unit of Property as Needed in All Categories"]
[null,103450,"Construction Materials for Services",1,"LS",{"$f":"'Materials Worksheet'!G59*(1+K13)","v":1682.0861847239998},{"$f":"F19*D19","v":1682.0861847239998}]
[null,103480,"Construction Materials for Hydrants",1,"LS",{"$f":"'Materials Worksheet'!G73*(1+K13)","v":0},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":1682.0861847239998}]
[null,null,null,"Contingency",null,0.1,{"$f":"G23*F24","v":168.20861847239999}]
[null,null,null,"Sales Tax",null,0.09,{"$f":"(G23+G24)*F25","v":166.52653228767599},null,null,"INVENTORY COST SHEET LINK"]
[null,null,null,"SUB Total - Materials",null,null,{"$f":"G23+G24+G25","v":2016.8213354840759}]
[null,null,null,"Rounded Up Value",null,null,{"$f":"ROUNDUP(G26,-2)","v":2100},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":"'Construction Labor'!G35*(1+K13)","v":0},{"$f":"F31*D31","v":0}]
[null,103450,"Construction Labor - Services",1,"LS",{"$f":"'Construction Labor'!P35*(1+K13)","v":1584},{"$f":"F32*D32","v":1584}]
[null,103480,"Construction Labor - Hydrants",1,"LS",{"$f":"'Construction Labor'!Y35*(1+K13)","v":0},0]
[null,null,null,null,null,null,0]
[null,null,"WWSC Engineering",1,"LS",{"$f":"'Eng Labor'!H41*(1+K13)","v":336.6},336.6]
[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":1920.6}]
[null,null,null,"Contingency",null,0.1,{"$f":"G38*F39","v":192.06}]
[null,null,null,"Sub-Total - Construction Labor",null,null,{"$f":"G38+G39","v":2112.66}]
[null,null,null,"Rounded Up Value",null,null,{"$f":"ROUNDUP(G40,-2)","v":2200}]
[]
[null,null,null,"*** Outside Contractor ***"]
[null,"Unit of Property","Description","Quantity","Unit of Measure","Unit Cost","Total"]
[null,null,"County Permits (Encroachment)",1,"LS",{"$f":"300*(1+K13)","v":396},{"$f":"F45*D45","v":396}]
[null,null,"Bore tool Rental",1,"LS",685,{"$f":"F46*D46","v":685}]
[null,null,"Hydrogeologist",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":"'Construction Labor'!G49*(1+K13)","v":0},0]
[null,null,"Paving Contractor - Pavement Restoration",1,"LS",{"$f":"800*(1+K13)","v":1056},1056]
[null,null,"Traffic Control Contractor - Flaggers",1,"LS",{"$f":"'Construction Labor'!E44*(1+K13)","v":1108.8},1108.8]
[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":3245.8}]
[null,null,null,"Contingency",null,0.1,{"$f":"G61*F62","v":324.58000000000004},null,null,"50% of total project cost",{"$f":"G70/2","v":5076.1421319796955}]
[null,null,null,"Sub-Total - Outside Contractor",null,null,{"$f":"SUM(G61:G62)","v":3570.38},null,null,"total cost of watermains",{"$f":"G18*(1+F24)*(1+F25) + G31*(1+F39) +( G54+G55+G56+G45+G50)*(1+F62)","v":2816.8800000000006}]
[null,null,null,"Rounded Up Value",null,null,{"$f":"ROUNDUP(G63,-2)","v":3600}]
[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":7900},null,null,null,"LF",{"$f":"K63/J66","v":{"$error":"#DIV/0!"}},"$/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":2099.9999999999991}]
[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":152.28426395939022}]
[]
[null,null,null,"Projected Funds Required =",null,null,{"$f":"SUM(G66:G69)","v":10152.284263959391}]
[]
[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":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'Estimate Form'!$K$6","v":"Peacock Hill"}]
[null,null,{"$f":"CONCATENATE('Estimate Form'!$K$8, \" County\")","v":"Pierce County"},null,null,"Eng. File #",{"$f":"'Estimate Form'!$K$9","v":3908}]
[null,null,{"$f":"'Estimate Form'!K7","v":"1\" Service Meter"}]
[null,null,"Engineer's Opinion of Projected Construction Materials Costs"]
[null,null,{"$f":"TODAY()","v":"2021-02-11"}]
[]
[]
[]
["Unit of Property","Inventory Number","Task - WATERMAIN","Quantity","Units","Unit Cost","Total"]
[]
[]
[]
[]
[null,null,null,null,null,0,{"$f":"D14*F14","v":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,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,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,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,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,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,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"D41*F41","v":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,null,null,"Sub-Total",{"$f":"SUM(G14:G45)","v":0}]
[]
[]
["Unit of Property","Inventory Number","Task - SERVICES","Quantity","Units","Unit Cost","Total"]
[]
[]
[103450,null,{"$f":"'Materials Assemblies'!C73","v":"1\" Meter Single Service Assembly"},1,"EA",{"$f":"'Materials Assemblies'!G85","v":1274.3077156999998},{"$f":"D53*F53","v":1274.3077156999998}]
[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,null,null,"Sub-Total",{"$f":"SUM(G53:G57)","v":1274.3077156999998}]
[]
[]
[]
[]
["Unit of Property","Inventory Number","Task - HYDRANTS","Quantity","Units","Unit Cost","Total"]
[]
[]
[103480,null,"Fire Hydrant",0,"EA",{"$f":"'Materials Assemblies'!G28","v":4402.2123906000006},{"$f":"D67*F67","v":0}]
[null,null,null,null,null,null,{"$f":"D68*F68","v":0}]
[null,null,null,null,null,null,{"$f":"D69*F69","v":0}]
[null,null,null,null,null,null,{"$f":"D70*F70","v":0}]
[null,null,null,null,null,null,{"$f":"D71*F71","v":0}]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G67:G71)","v":0}]

{"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":"Peacock Hill"}]
[null,null,{"$f":"CONCATENATE('Estimate Form'!$K$8, \" County\")","v":"Pierce County"},null,null,"Eng. File #",{"$f":"'Estimate Form'!$K$9","v":3908}]
[null,null,{"$f":"'Estimate Form'!K7","v":"1\" Service Meter"}]
[null,null,"Engineer's Opinion of Projected Construction Materials Costs"]
[null,null,{"$f":"TODAY()","v":"2021-02-11"}]
[]
[]
[]
[]
[null,null,"Assembly Items Listed Below"]
[]
[]
[null,null,"Hydrant Assembly"]
[null,"60600033","6\" Dry-Barrel Hydrant",1,"EA",{"$f":"[1]sheet1!$E$1587","v":2619.5779974000002},{"$f":"D14*F14","v":2619.5779974000002},null,null,null,null,"Temporary Testing Service"]
[null,"60500031","5\" Storz Adaptor",1,"EA",{"$f":"[1]sheet1!$E$1589","v":203.61685369999998},203.61685369999998,null,null,null,"30800181","8 x 1 TAPPING SADDLE",1,"EA",{"$f":"[2]sheet1!$E$725","v":77.743503500000003},{"$f":"M15*O15","v":77.743503500000003}]
[null,"60600081","18\" Valve Box Riser /w Lid",1,"EA",{"$f":"[1]sheet1!$E$1611","v":50.489136100000003},50.489136100000003,null,null,null,"40100255","1\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[2]sheet1!$E$853","v":93.267796700000005},93.267796700000005]
[null,"60600082","CI Valve Box Bottom Section",1,"EA",{"$f":"[1]sheet1!$E$1608","v":28.7576471},28.7576471,null,null,null,"60100012","1\" CL 200 POLY PIPE",12,"LF",{"$f":"[2]sheet1!$E$1592","v":0.64685920000000008},7.7623104000000005]
[null,"30600194","6\"x6\" Tee, MJxFLG",1,"EA",{"$f":"[1]sheet1!$E$785","v":162.79900000000001},162.79900000000001,null,null,null,"40100220","1\" ANGLE STOP VALVE-NO LEAD",1,"EA",{"$f":"[2]sheet1!$E$924","v":63.734264099999997},63.734264099999997]
[null,"30600141","6\" Ductile Iron Pipe Cl 50",12,"LF",{"$f":"[1]sheet1!$E$673","v":21.043387300000003},252.52064760000002,null,null,null,"100034060","RES METER BOX w/lid, STANDARD",1,"EA",{"$f":"[1]sheet1!$E$1921","v":37.056433699999999},37.056433699999999]
[null,"30600028","6\" MEGALUG PK/KIT (DI)",2,"EA",{"$f":"[1]sheet1!$E$621","v":53.408637100000007},106.81727420000001,null,null,null,null,null,null,null,null,0]
[null,"30800029","8\" MEGALUG PK/KIT (PVC)",2,"EA",{"$f":"[1]sheet1!$E$628","v":90.762453600000001},181.5249072]
[null,"30600030","6\" FLG BOLT & GSKT KIT",2,"EA",{"$f":"[1]sheet1!$E$582","v":15.430999999999999},30.861999999999998,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P15:P20)","v":279.56430839999996}]
[null,"40600285","6\" MJ x FLG GATE VALVE",1,"EA",{"$f":"[1]sheet1!$E$886","v":747.04945250000003},747.04945250000003]
[null,null,"GRAVEL 1 1/4 minus",0.5,"CY",17,8.5]
[null,"125004816","Support Blocks",6,"EA",{"$f":"[1]sheet1!$E$1966","v":1.6162458},9.6974748000000002]
[null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G14:G26)","v":4402.2123906000006}]
[]
[]
[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":"[2]sheet1!$E$725","v":77.743503500000003},{"$f":"D32*F32","v":77.743503500000003},null,null,null,"30800181","8 x 1 TAPPING SADDLE",1,"EA",{"$f":"[2]sheet1!$E$725","v":77.743503500000003},{"$f":"M32*O32","v":77.743503500000003}]
[null,"40100255","1\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[2]sheet1!$E$853","v":93.267796700000005},93.267796700000005,null,null,null,"40100255","1\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[2]sheet1!$E$853","v":93.267796700000005},93.267796700000005]
[null,"60100012","1\" CL 200 POLY PIPE",30,"LF",{"$f":"[2]sheet1!$E$1592","v":0.64685920000000008},19.405776000000003,null,null,null,"60100012","1\" CL 200 POLY PIPE",30,"LF",{"$f":"[2]sheet1!$E$1592","v":0.64685920000000008},19.405776000000003]
[null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[3]sheet1!$E$1551","v":0.10685739999999999},3.2057219999999997,null,null,null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[3]sheet1!$E$1522","v":2.9612258000000002},88.836774000000005]
[null,null,"Meter Setter - Ford VH72-12W-11-44-NL",1,"EA",185,185,null,null,null,null,"Meter Setter - Ford VH72-12W-11-44-NL",2,"EA",185,370]
[null,"60100021","1\" PJ x  MIPT POLY ADAPTOR-NO",1,"EA",{"$f":"[2]sheet1!$E$1558","v":35.924912399999997},35.924912399999997,null,null,null,null,"1\" x 18\" BRASS NIPPLE",2,"EA",60,120]
[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]sheet1!$E$1921","v":37.056433699999999},74.112867399999999]
[null,"100034060","RES METER BOX w/lid, STANDARD",1,"EA",{"$f":"[1]sheet1!$E$1921","v":37.056433699999999},37.056433699999999,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":"[2]sheet1!$E$1558","v":35.924912399999997},35.924912399999997]
[null,null,null,null,null,null,0,null,null,null,"80100190","1\" BRASS TEE",1,"EA",{"$f":"[2]sheet1!$E$1782","v":10.573212000000002},10.573212000000002]
[null,null,null,null,null,null,0,null,null,null,"80100090","1\" 90 BRASS ELBOW",3,"EA",{"$f":"[2]sheet1!$E$1734","v":7.281302600000001},21.843907800000004]
[null,null,null,null,null,null,0,null,null,null,null,"1\" x 18\" BRASS NIPPLE",2,"EA",60,120]
[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":517.60414430000003}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P32:P44)","v":1043.7087498000001}]
[]
[]
[]
[]
[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":"[2]sheet1!$E$731","v":128.36765370000001},{"$f":"D53*F53","v":128.36765370000001},null,null,null,"30800183","8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[2]sheet1!$E$731","v":128.36765370000001},{"$f":"M53*O53","v":128.36765370000001},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":"[2]sheet1!$E$852","v":288.05164440000004},288.05164440000004,null,null,null,"40200255","2\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[2]sheet1!$E$852","v":288.05164440000004},288.05164440000004,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":"[2]sheet1!$E$1594","v":2.2323600000000003},66.970800000000011,null,null,null,"60112012","1-1-2\" CL 200 POLY PIPE",30,"LF",{"$f":"[2]sheet1!$E$1594","v":2.2323600000000003},66.970800000000011,null,40200255,"2\" CORP STOP VALVE-NO LEAD",1,"EA",288.05,288.05]
[null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[3]sheet1!$E$1551","v":0.10685739999999999},3.2057219999999997,null,null,null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[3]sheet1!$E$1522","v":2.9612258000000002},88.836774000000005,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",185,185,null,null,null,null,"Meter Setter - Ford VH72-12W-11-66-NL",2,"EA",185,370,null,51400155,"LOCATOR WIRE, # 14",30,"LF",2.96,88.84]
[null,"60112021","1-1/2\" PJ x MIPT POLY ADAPTOR",1,"EA",{"$f":"[2]sheet1!$E$1560","v":87.674079999999989},87.674079999999989,null,null,null,null,"1½\" x 18\" BRASS NIPPLE",2,"EA",60,120,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]sheet1!$E$1921","v":37.056433699999999},74.112867399999999,null,null,"1½\" x 18\" BRASS NIPPLE",2,"EA",60,120]
[null,"100034060","RES METER BOX w/lid, STANDARD",1,"EA",{"$f":"[1]sheet1!$E$1921","v":37.056433699999999},37.056433699999999,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":"[2]sheet1!$E$1560","v":87.674079999999989},175.34815999999998,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":"[2]sheet1!$E$1783","v":22.009},22.009,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",22,66,null,80112190,"1-1/2\" BRASS TEE",1,"EA",22.01,22.01]
[null,null,null,null,null,null,0,null,null,null,"80100134","1½\" x 18\" BRASS NIPPLE",2,"EA",60,120,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":907.32633380000004},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":1531.6968995}]
[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":"[3]sheet1!$F$731","v":124.22800000000001},{"$f":"D74*F74","v":124.22800000000001},null,null,null,"30800183","8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[3]sheet1!$F$731","v":124.22800000000001},{"$f":"M74*O74","v":124.22800000000001}]
[null,"40200255","2\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[3]sheet1!$F$852","v":268.26800000000003},268.26800000000003,null,null,null,"40200255","2\" CORP STOP VALVE-NO LEAD",1,"EA",{"$f":"[3]sheet1!$F$852","v":268.26800000000003},268.26800000000003]
[null,"60112012","1-1-2\" CL 200 POLY PIPE",30,"LF",{"$f":"[2]sheet1!$E$1594","v":2.2323600000000003},66.970800000000011,null,null,null,"60200012","2\" CL 200 POLY PIPE",30,"LF",{"$f":"[3]sheet1!$F$1595","v":3.0680000000000001},92.04]
[null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[3]sheet1!$E$1551","v":0.10685739999999999},3.2057219999999997,null,null,null,"51400155","LOCATOR WIRE, # 14",30,"LF",{"$f":"[3]sheet1!$E$1551","v":0.10685739999999999},3.2057219999999997]
[null,null,"Meter Setter - Ford VH74-12W-11-66-NL",1,"EA",296.14,296.14,null,null,null,null,"Meter Setter - Ford VBHH76-18HBHC-11-77",1,"EA",1672,1672]
[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]sheet1!$E$1921","v":37.056433699999999},{"$f":"D80*F80","v":37.056433699999999},null,null,null,"80200120","2\" x CLOSE BRASS NIPPLE",2,"EA",{"$f":"[3]sheet1!$F$1767","v":12.61},25.22]
[null,"100100158","1\" METER w/HRE REG+ERT",1,"EA",{"$f":"[3]sheet1!$E$1912","v":367.43876},{"$f":"D81*F81","v":367.43876},null,null,null,null,"2\" Brass Elbow",2,"EA",14.23,28.46]
[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]sheet1!$E$1921","v":37.056433699999999},{"$f":"M82*O82","v":37.056433699999999}]
[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":1274.3077156999998},null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P74:P83)","v":2297.8081557}]
[]
[]
[]
[null,null,"2\" Blowoff Assembly",null,null,null,null,null,null,"Wellhead Enclosure Assembly"]
[null,null,"2\" THREADED GATE AWWA",1,"EA",{"$f":"[1]sheet1!$E$875","v":432.41899999999998},{"$f":"D90*F90","v":432.41899999999998},null,null,null,"Well 2.5 X 8"]
[null,null,"8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[1]sheet1!$E$731","v":128.36765370000001},128.36765370000001,null,null,"Unit of Prop","Inv No"]
[null,null,"18\" VALVE BOX RISER w/LID",1,"EA",{"$f":"[1]sheet1!$E$1611","v":50.489136100000003},50.489136100000003,null,null,103240,null,"2.5\" sch 40 galv pipe (21ft lngths)",12,"EA",{"$f":"4.75*21","v":99.75},{"$f":"O92*M92","v":1197}]
[null,null,"VALVE BOX BOTTOM CI",1,"EA",{"$f":"[1]sheet1!$E$1608","v":28.7576471},28.7576471,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]sheet1!$E$425","v":6.2280985000000006},24.912394000000003,null,null,103240,null,"2.5\" collumn check valve",2,"EA",180,360]
[null,null,"2\" GALVANIZED PIPE",6,"LF",{"$f":"[1]sheet1!$E$463","v":3.862365},23.174189999999999,null,null,103240,null,"2.5 x 8\" spiders",2,"EA",10,20]
[null,null,"2\" GALV 90 ELBOW",4,"EA",{"$f":"[1]sheet1!$E$290","v":8.6599655999999996},34.639862399999998,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]sheet1!$E$18","v":2.1076899999999998},4.2153799999999997,null,null,103240,null,"2.5\" Pipe Coupling",12,"EA",11,132]
[null,null,"2\" PVC PIPE,  CL 200",20,"LF",{"$f":"[1]sheet1!$E$137","v":0.91176540000000006},18.235308,null,null,103240,null,"#6-4 flat jacket subcable",300,"FT",1.9,570]
[null,null,"BEDDING SAND",2.5,"CY",{"$f":"[3]sheet1!$E$1971","v":7.2168200000000002},18.04205,null,null,103240,null,"sounding tube",260,"FT",1.0900000000000001,283.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":763.25262129999987},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.5\" Ball Valve",2,"EA",136,272]
[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]sheet1!$E$875","v":432.41899999999998},{"$f":"D106*F106","v":432.41899999999998},null,null,null,null,"Pad",1,"ea",1500,1500]
[null,null,"8 x 2 TAPPING SADDLE",1,"EA",{"$f":"[1]sheet1!$E$731","v":128.36765370000001},128.36765370000001]
[null,null,"18\" VALVE BOX RISER w/LID",1,"EA",{"$f":"[1]sheet1!$E$1611","v":50.489136100000003},50.489136100000003]
[null,null,"VALVE BOX BOTTOM CI",1,"EA",{"$f":"[1]sheet1!$E$1608","v":28.7576471},28.7576471,null,null,null,null,null,null,null,"Sub-Total",{"$f":"SUM(P92:P106)","v":7933.2000000000007}]
[null,null,"2 x 6 GALV NIPPLE",7,"EA",{"$f":"[1]sheet1!$E$425","v":6.2280985000000006},43.596689500000004]
[null,null,"2\" AIR/VAC VALVE, ARI #D-040",1,"EA",{"$f":"[1]sheet1!$E$796","v":451.69948979999998},451.69948979999998]
[null,null,"2\" GALVANIZED PIPE",7,"LF",{"$f":"[1]sheet1!$E$463","v":3.862365},27.036555]
[null,null,"2\" GALV 90 ELBOW",4,"EA",{"$f":"[1]sheet1!$E$290","v":8.6599655999999996},34.639862399999998]
[null,null,"2\" PVC ADAPTOR FIP",2,"EA",{"$f":"[1]sheet1!$E$18","v":2.1076899999999998},4.2153799999999997,null,null,"Chlorine Analyzer with Cell Modem"]
[null,null,"2\" GALV 180 ELBOW",1,"EA",{"$f":"[1]sheet1!$E$299","v":89.85860000000001},89.85860000000001]
[null,null,"2\"  ENVIRO STRAINER-NO LEAD",1,"EA",{"$f":"[1]sheet1!$E$865","v":49.76829},49.76829,null,null,"Unit of Prop","Inv No"]
[null,null,"2\" GALV CAP",1,"EA",{"$f":"[1]sheet1!$E$235","v":4.1318536999999997},4.1318536999999997,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]sheet1!$E$503","v":11.265768800000002},22.531537600000004,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]sheet1!$E$923","v":43.022183099999999},43.022183099999999,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]sheet1!$E$375","v":8.0402360999999996},16.080472199999999,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]sheet1!$E$371","v":2.2944987000000001},2.2944987000000001,null,null,103760,null,"50 ft CAT5 Ethernet Cable",1,"EA",15,15]
[null,null,"3/4\" GALV 90 ELBOW",1,"EA",{"$f":"[1]sheet1!$E$286","v":1.4540292000000001},1.4540292000000001,null,null,103760,null,"mounting hardware",1,"EA",30,30]
[null,null,"EXTRA LG METER BOX LID, STD",1,"EA",{"$f":"[1]sheet1!$E$1930","v":239.28357050000002},239.28357050000002,null,null,null,null,"DPD Colorimeter",1,"EA",463,463]
[null,null,"1 1/2 x 6 GALV NIPPLE",3,"EA",{"$f":"[1]sheet1!$E$413","v":4.6758309000000002},14.0274927]
[null,null,"1-1/2\" GALV 90 ELBOW",1,"EA",{"$f":"[1]sheet1!$E$289","v":6.4831000000000003},6.4831000000000003,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]sheet1!$E$514","v":12.4946588},12.4946588]
[null,null,"CONCRETE VALVE BOX MARKER",1,"EA",{"$f":"[1]sheet1!$E$514","v":12.4946588},12.4946588]
[null,null,"2\" PVC PIPE,  CL 200",20,"LF",{"$f":"[1]sheet1!$E$137","v":0.91176540000000006},18.235308]
[null,null,"BLOCKS 2/8  4/8  4/16 - AVG",3,"EA",{"$f":"[1]sheet1!$E$1966","v":1.6162458},4.8487374000000001]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G106:G129)","v":1738.2304042999999}]
[]
[]
[]
[]
[null,null,"2.5\" Pump Suspension Assembly","Enter Pump Suction Depth:",null,null,130,"FT"]
[null,"40212240","2-1/2\" INLINE CHK VALVE (DUCTI",{"$f":"ROUND($G$136/80,0)","v":2},"EA",{"$f":"[3]sheet1!$F$829","v":287.88499999999999},{"$f":"D137*F137","v":575.77}]
[null,"70822171","8\"x 2-1/2\" SPIDER",{"$f":"ROUND($G$136/80,0)","v":2},"EA",{"$f":"[3]sheet1!$F$1685","v":11.933999999999999},23.867999999999999]
[null,"20212190","2-1/2\" GALV TEE",1,"EA",{"$f":"[3]sheet1!$F$491","v":36.387},36.387]
[null,"20212140","2-1/2\" GALVANIZED PIPE",{"$f":"G136","v":130},"FT",{"$f":"[3]sheet1!$F$464","v":9.0090000000000003},1171.17]
[null,"20212070","2-1/2\" GALV COUPLING",{"$f":"ROUND(G136/20,0)","v":7},"EA",{"$f":"[3]sheet1!$F$248","v":18.667999999999999},130.67599999999999]
[null,"70100156","1\" SCH 80 SOUNDING TUBE",{"$f":"G136","v":130},"FT",{"$f":"[3]sheet1!$F$1673","v":2.1631999999999998},281.21599999999995]
[null,"60038100","3/8\" OD PE TUBING",{"$f":"G136","v":130},"FT",{"$f":"[3]sheet1!$F$1603","v":0.35100000000000003},45.63]
[]
[null,null,null,null,null,"Sub-Total",{"$f":"SUM(G137:G143)","v":2264.7170000000001}]

{"sheet":"Construction Labor","index":3,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"'Estimate Form'!$K$6","v":"Peacock Hill"}]
[null,null,null,{"$f":"CONCATENATE('Estimate Form'!$K$8, \" County\")","v":"Pierce County"},null,null,null,"Eng. File #",{"$f":"'Estimate Form'!$K$9","v":3908}]
[null,null,null,{"$f":"'Estimate Form'!$K$7","v":"1\" Service Meter"}]
[null,null,null,"Engineer's Opinion of Projected Construction Materials Costs"]
[null,null,null,{"$f":"TODAY()","v":"2021-02-11"}]
[]
["WWS Construction Crew for CICA Projects - Watermain",null,null,null,null,null,null,null,null,"WWS Construction Crew for CICA Projects - Services",null,null,null,null,null,null,null,null,"WWS Construction Crew for CICA Projects - 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,null,"HRS",125,{"$f":"D10*F10","v":0},null,null,"1 Man & Vac Truck",null,null,null,"HRS",125,{"$f":"M10*O10","v":0},null,null,"1 Man & Vac Truck",null,null,null,"HRS",125,{"$f":"V10*X10","v":0}]
["1 Man & Boom Truck",null,null,null,"HRS",125,0,null,null,"1 Man & Boom Truck",null,null,null,"HRS",125,0,null,null,"1 Man & Boom Truck",null,null,null,"HRS",125,0]
["1 Man & Backhoe - Trench",null,null,null,"HRS",125,0,null,null,"1 Man & Backhoe - Trench",null,null,null,"HRS",125,0,null,null,"1 Man & Backhoe - Trench",null,null,null,"HRS",125,0]
["1 Man & Backhoe - Comp",null,null,null,"HRS",125,0,null,null,"1 Man & Backhoe - Comp",null,null,null,"HRS",125,0,null,null,"1 Man & Backhoe - Comp",null,null,null,"HRS",125,0]
["1 Man & Truck",null,null,null,"HRS",75,0,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,null,"HRS",150,0,null,null,"2 Men & Truck",null,null,null,"HRS",150,0,null,null,"2 Men & Truck",null,null,null,"HRS",150,0]
["1 Electrician & Truck",null,null,null,"HRS",101,0,null,null,"1 Electrician & Truck",null,null,null,"HRS",101,0,null,null,"1 Electrician & Truck",null,null,null,"HRS",101,0]
["2 Electricians & Truck",null,null,null,"HRS",202,0,null,null,"2 Electricians & Truck",null,null,null,"HRS",202,0,null,null,"2 Electricians & Truck",null,null,null,"HRS",202,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:G18)","v":0},null,null,null,null,null,null,null,"Total",{"$f":"SUM(P10:P18)","v":0},null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y10:Y18)","v":0}]
[]
["WWS Construction Crew for WWS Capital Projects - Mains",null,null,null,null,null,null,null,null,"WWS Construction Crew for WWS Capital Projects - Services",null,null,null,null,null,null,null,null,"WWS Construction Crew for WWS Capital Projects -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,null,"HRS",75,{"$f":"D25*F25","v":0},null,null,"1 Man & Vac Truck",null,null,null,"HRS",75,{"$f":"M25*O25","v":0},null,null,"1 Man & Vac Truck",null,null,null,"HRS",75,{"$f":"V25*X25","v":0}]
["1 Man & Boom Truck",null,null,null,"HRS",75,{"$f":"D26*F26","v":0},null,null,"1 Man & Boom Truck",null,null,null,"HRS",75,{"$f":"M26*O26","v":0},null,null,"1 Man & Boom Truck",null,null,null,"HRS",75,{"$f":"V26*X26","v":0}]
["1 Man & Backhoe - Trench",null,null,null,"HRS",75,{"$f":"D27*F27","v":0},null,null,"1 Man & Backhoe - Trench",null,null,8,"HRS",75,{"$f":"M27*O27","v":600},null,null,"1 Man & Backhoe - Trench",null,null,null,"HRS",75,{"$f":"V27*X27","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]
["1 Man & Truck",null,null,null,"HRS",75,0,null,null,"1 Man & Truck",null,null,8,"HRS",75,600,null,null,"1 Man & Truck",null,null,null,"HRS",75,0]
["2 Men & Truck",null,null,null,"HRS",150,0,null,null,"2 Men & Truck",null,null,null,"HRS",150,0,null,null,"2 Men & Truck",null,null,null,"HRS",150,0]
["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(G25:G33)","v":0},null,null,null,null,null,null,null,"Total",{"$f":"SUM(P25:P33)","v":1200},null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y25:Y33)","v":0}]
[]
["Outside Contractor - No Pilot Car"]
[]
["1-Flagger",null,"HRS",30,{"$f":"B39*D39","v":0}]
["2-Flaggers",null,"HRS",60,{"$f":"B40*D40","v":0}]
["Signs",8,"DAYS",105,{"$f":"B41*D41","v":840}]
["Other",null,"LS",null,{"$f":"B42*D42","v":0},"(RCE TRAFFIC CONTROL CUTSHEET)"]
[]
[null,null,null,"Sub-total",{"$f":"SUM(E39:E42)","v":840}]
[]
[]
["Sanitary Facility Rental (Portable Toilet)"]
[]
[null,null,null,"Days",null,75,{"$f":"C49*F49","v":0}]

{"sheet":"Eng Labor","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"'Estimate Form'!$K$6","v":"Peacock Hill"},null,null,"Eng. File #",{"$f":"'Estimate Form'!$K$9","v":3908}]
[null,null,null,{"$f":"CONCATENATE('Estimate Form'!$K$8, \" County\")","v":"Pierce County"}]
[null,null,null,{"$f":"'Estimate Form'!$K$7","v":"1\" Service Meter"}]
[null,null,null,"Engineer's Opinion of Projected Construction Materials Costs"]
[null,null,null,{"$f":"TODAY()","v":"2021-02-11"}]
[]
[]
[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,"Design & Draft Watermain Construction Documents",null,"Engineer",85,0]
[]
[null,null,null,"Sub-Total",{"$f":"SUM(E12:E16)","v":1},null,null,{"$f":"SUM(H12:H16)","v":85}]
[]
[null,null,null,"Revisions per Peer Review Comments"]
[null,null,null,"P.E. Peer Review",null,"Principle Eng",115,{"$f":"E20*G20","v":0}]
[null,null,null,"Revisions to Construction Documents per Peer Review Comments",null,"Engineer",85,0]
[null,null,null,"Coping & Re-Submittal of Project Report & Construction Documents",null,"Clerical",60,0]
[]
[null,null,null,"Sub-Total",{"$f":"SUM(E20:E23)","v":0},null,null,{"$f":"SUM(H20:H23)","v":0}]
[]
[null,null,null,"Construction"]
[null,null,null,"Pre-Construction Conference with Engineering & Contractor",1,"Engineer",85,{"$f":"E27*G27","v":85}]
[null,null,null,"Construction Inspection & Pressure Test",null,"Engineer",85,{"$f":"E28*G28","v":0}]
[]
[null,null,null,"Sub-Total",{"$f":"SUM(E27:E29)","v":1},null,null,{"$f":"SUM(H27:H29)","v":85}]
[]
[null,null,null,"Record Documents"]
[null,null,null,"As-Built Drawings & Testing Validations along with Project Certification Document Preparation",null,"Engineer",85,{"$f":"E33*G33","v":0}]
[null,null,null,"P.E. Project Certification",null,"Principle Eng",{"$f":"G20","v":115},0]
[null,null,null,"Updating Base Maps & Site Piping",1,"Engineer",{"$f":"G21","v":85},85]
[null,null,null,"Coping, Binding & Submittal of Project Certification to File & Rosario",null,"Clerical",60,0]
[]
[null,null,null,"Sub Total",{"$f":"SUM(E33:E37)","v":1},null,null,{"$f":"SUM(H33:H37)","v":85}]
[]
[]
[null,null,null,"Projected Total Hours",{"$f":"E17+E24+E30+E38","v":3},null,null,{"$f":"H17+H24+H30+H38","v":255}]

{"sheet":"Hyd Model Const","index":5,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Task","Hours","Rate","Total"]
[null,null,null,"Hydraulic Model Construction"]
[null,null,null,"Data Collection of Preston's Source Facilities & Distribution System",1]
[null,null,null,"Distribution Pipes set-up in ACAD for importing into a GIS Shape File",2]
[null,null,null,"Distribution Pipes conversion ACAD to GIS Shape File",1]
[null,null,null,"Distribution Pipes - Import GIS Shape File, Create Junctions (Nodes) in Preston's Model",1]
[null,null,null,"Junction (Node) elevation assignment",1]
[null,null,null,"Preston Industrial Source of Supply Construction in the Model",4]
[null,null,null,"Load Model with Preston Industrial Park ERU's",1]
[null,null,null,"Calc Preston's Peak Day Diurnal Curve & Assign to Junctions w/ ERU's Loaded",4]
[null,null,null,"Run & Perform QA/QC checks & make any necessary refinements",4]
[]
[null,null,null,"Sub-Total",{"$f":"SUM(E6:E12)","v":11},null,{"$f":"E16*F16","v":0}]
[]
[null,null,null,"Hydraulic Model Scenario & Report"]
[null,null,null,"Setup & Run Hydraulic Model Scenario for MDD & PHD Meeting DOH Requirements",2]
[null,null,null,"Setup & Run Hydraulic Model Scenario for Fire Flow Analysis",2]
[null,null,null,"Prepare Hydraulic Model Narrative (Report) for DOH Submittal",4]
[null,null,null,"P.E. Peer Review",1]
[null,null,null,"Edit Project Report per Peer Review",1]
[null,null,null,"Final P.E. Peer Review for submittal",0.5]
[null,null,null,"Coping, Binding & of Project Report for DOH Submittal",1]
[]
[null,null,null,"Sub-Total",{"$f":"SUM(E19:E25)","v":11.5},null,{"$f":"E27*F27","v":0}]
[]
[]
[]
[null,null,null,"Sub-Total",{"$f":"E16+E27","v":22.5},95,{"$f":"E31*F31","v":2137.5}]
[null,null,null,"Department of Health Office of Drinking Water Review Fee",null,null,811]
[null,null,null,"Projected Total Fees:",null,null,{"$f":"SUM(G31:G32)","v":2948.5}]
[]
[null,null,null,"Notes:"]
[null,null,null,"1) This document is intended to forecast approximate Engineering fees based upon current information and similar projects, with"]
[null,null,null,"    billing on an hourly basis. Final project fees could vary from the projected fees shown."]

{"sheet":"Consolidation Records Migration","index":6,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Engineering Staff Hours to Consolidate Sea Cliff Records into Pecock Hill"]
[]
[]
[null,null,null,"Empolyee"]
[null,"Task","Hours","Classification"]
[null,"Update System History",0.25,"Engineer"]
[null,"Site Facility Address Update",0.25,"Clerical"]
[null,"Source of Supply Inventory drawing",4,"Engineer"]
[null,"Update Connection Summary",4,"Clerical"]
[null,"Document Draw Records Consolidation",0.5,"Clerical"]
[null,"Sattin System Customer Migration to Aspinwall",1,"Clerical"]
[null,"System's Owned & Managed List Update",0.5,"Clerical"]
[null,"CMP Revisions for consolidated System - Site Selection & rotation",1,"Engineer"]
[null,"CMP Revisions for consolidated System - CMP Map Update",2,"Engineer"]
[null,"Coliform Monitoring Schedule Updated - WQ",0.25,"Clerical"]
[null,"Chemical Contaminants Monitoring Schedule Update - WQ",0.25,"Clerical"]
[null,"Nitrate Monitoring Schedule Update - WQ",0.25,"Clerical"]
[null,"Lead & Cooper Schedule Update - WQ",0.5,"Clerical"]
[null,"WQ Records Merge",0.25,"Clerical"]
[null,"Wellhead Meter Reading Forms merge",0.5,"Clerical"]
[null,"Wellhead Protection Records Merge",1,"Engineer"]
[null,"Sanitary Survey Action Items merge",2,"Clerical"]
[]
[]
[null,"Total",{"$f":"SUM(C10:C28)","v":18.5}]