{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction v1.5","System Assumptions","Economic Assumptions","Piping Circuit","Constants","Versions"],"not_rendered":{"charts":7,"images":3,"macros":1,"external_links":0,"defined_names":83,"comments":4,"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":"Introduction v1.5","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EDR Guidelines CoolTools"]
["Pipe Size Optimization Tool v1.6"]

{"sheet":"System Assumptions","index":1,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,3,2,5],[3,3,3,5]]}
[]
[]
[null,null,"Project Name","My Project"]
[null,null,"System Name","CHW"]
[]
[null,null,"System Parameters"]
[null,null,"System type","CHW",null,null,null,null,"CHW","HW","CW"]
[null,null,"Average Water temperature",{"$f":"IF(D7=I7,VLOOKUP(I7,Constants!B153:C155,2,0),IF(D7=J7,VLOOKUP(J7,Constants!B153:C155,2,0),IF(D7=K7,VLOOKUP(K7,Constants!B153:C155,2,0),\"ERROR\")))","v":50},"°F"]
[null,null,"System operation","VFVSFSP",null,null,null,null,"CFCS","VFCS","VFVSFSP","VFVSRSP"]
[null,null,"Multiplier for constant/variable system",{"$f":"HLOOKUP(CONST_VAR_UI,Constants!B158:E159,2,0)","v":0.3}]
[null,null,"Hours per year of operation",2000,"hours"]
[null,null,"Pipe insulation thickness (in inches)","Title 24","(must click \"Apply\" for change to take effect)",null,null,null,"Title 24",0.5,1,1.5,2,"None"]
[null,null,"Fluid speed limit for noise sensitivity?","ON","(must click \"Apply\" for change to take effect)",null,null,null,"ON","OFF"]
[null,null,"Fluid speed limit for erosion control?","ON","(must click \"Apply\" for change to take effect)",null,null,null,"ON","OFF"]
[null,null,"Default safety factor: greater of",5,"%"]
[null,null,"OR",5,"ft W.C."]

{"sheet":"Economic Assumptions","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Economic Assumptions"]
[]
[null,null,"City cost index multipliers"]
[null,null,"Market","Oakland, CA"]
[null,null,"Materials",{"$f":"VLOOKUP($D$6,Constants!$B$167:$D$175,2,0)","v":110.2}]
[null,null,"Labor",{"$f":"VLOOKUP($D$6,Constants!$B$167:$D$175,3,0)","v":127.3}]
[null,null,"Contractor mark-up"]
[null,null,"HVAC",0.25]
[null,null,"General",0.03]
[null,null,"Current year",2011]
[null,null,"Means Mechanical Cost Data year",2008]
[null,null,"Average annual first cost escalation",9.5000000000000001E-2]
[null,null,"Taxes",0.08]
[null,null,"Electricity cost",0.15,"$/kWh"]
[null,null,"Gas cost (used only for HW system type)",1,"$/therm"]
[null,null,"Inflation rate",0]
[null,null,"Energy escalation rate",0.01]
[null,null,"Discount rate",0.05]
[null,null,"Lifetime of system (<=40 years)",30,"years"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C167=0,\"\",Constants!B167)","v":"Oakland, CA"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C168=0,\"\",Constants!B168)","v":"Los Angeles, CA"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C169=0,\"\",Constants!B169)","v":"Fresno, CA"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C170=0,\"\",Constants!B170)","v":"San Francisco, CA"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C171=0,\"\",Constants!B171)","v":"San Jose, CA"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C172=0,\"\",Constants!B172)","v":"Riverside, CA"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C173=0,\"\",Constants!B173)","v":"Sacramento, CA"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C174=0,\"\",Constants!B174)","v":"Average National"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Constants!C175=0,\"\",Constants!B175)","v":""}]

{"sheet":"Piping Circuit","index":3,"n_rows":121,"n_cols":172,"rows_kept":121,"cut":false,"hidden":false,"merged":[[0,66,0,131],[4,78,4,79],[4,115,4,121],[4,102,4,108],[4,76,4,77],[4,112,4,113],[4,125,4,129],[4,86,4,91],[4,99,4,100],[4,132,4,171],[4,10,4,11],[4,35,4,36],[4,37,4,38],[4,83,4,84],[4,66,4,67],[4,39,4,58],[2,7,2,11],[4,16,4,17],[4,97,4,98],[4,110,4,111],[4,81,4,82]]}
[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,null,null,null,"Inputs",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,null,null,null,null,"Outputs"]
[]
["Total system flow",{"$f":"MAX(GPM)","v":0},null,"GPM",null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,"CRITICAL","NON-CRITICAL",null,null,null,null,null,100]
[]
["Add or delete a row above current cursor position","Segment Grouping",null,"Flow rate",null,"Select Pipe Size or \"AUTO\"","Auto- Optimized Nominal Pipe Size","Pipe Size","Previous Size","Annual Hours of Oper.","Flow Speed Limit to Prevent Noise?",null,null,null,null,null,"Flow Speed Limit to Prevent Erosion?",null,"TYPE COPPER=0, STEEL =1","Rough- ness","I.D. [\"]","RE3","RE2","RE* E-4","Reynolds Number","Relative Roughness, e/D","D/E Threshold for turbulent flow","Fmin","A","B","f","Flow regime","Desired Insulation Wall Thickness","Insulation  Thickness","Straight Pipe Length","Number of Elbows",null,"Tees with flow through:",null,"Number of Valves ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control Valve DP",null,"Other: Chiller/ Boiler/ Coil/ HX/ etc.",null,null,"Segment Head",null,"Velocity","Friction Rate","Water volume in pipe ","Const/ Variable multiplier","BHP","Pump Motor Power","+ Pump Heat to Chiller","- Pump Heat to Boiler","Total Power",null,"Energy Cnsmp per Year",null,null,"ELLS K FACTOR",null,"TEES K FACTOR",null,"Total K Factor","VALVES Cv FACTOR",null,null,null,null,null,"P drop","Calc P drop from fittings (feet)","Calc P drop from valves (psi)","MATERIALS COST: MOTOR","MATERIALS COST: VFD","MATERIALS COST: PIPING",null,"MATERIALS COST: ELLS",null,"MATERIALS COST: TEES","MATERIALS COST: VALVES",null,null,null,null,null,null,null,"LABOR COST: PIPING",null,"LABOR COST: ELLS",null,"LABOR COST: TEES","LABOR COST: VALVES",null,null,null,null,null,null,"LABOR COST: MOTOR","LABOR COST: VFD",null,"First Cost",null,null,null,null,"Lifecycle Cost","Lifecycle + First Cost","Annl Energy Costs"]
["Pipe Segment Description",null,"calc'ed?","GPM","rounded GPM","Inches","Inches","Inches",null,"h/yr",null,"Too fast?","T^3 (F)","T^2 (F)","T (F)","viscosity",null,"Too fast?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inches",null,"Feet","90º","45º",{"$f":"Constants!E10","v":"Straight"},{"$f":"Constants!F10","v":"Branch"},{"$f":"Constants!J10","v":"Circuit Setter"},"Value in Range?",null,{"$f":"Constants!K10","v":"Silent Check"},"Value in Range?",null,{"$f":"Constants!L10","v":"Swing Check"},"Value in Range?",null,"Ball or Butterfly","Value in Range?",null,"Use Ball or Butterfly? Ball = 0, Butterfly = 1",{"$f":"CM6","v":"Wye-Strainer"},"Value in Range?",null,{"$f":"CN6","v":"Suction Diffuser"},"Value in Range?",null,"Flow Limiting","Value in Range?",null,"Psi",null,"Feet",null,null,"Feet","psi","Feet/ sec","Feet/ 100 ft","Gal",null,"HP","kW","kW","therms/ hr","kW","therms /hr","kWh","therms",null,90,45,"LINE","BRANCH",null,{"$f":"Constants!J10","v":"Circuit Setter"},{"$f":"Constants!K10","v":"Silent Check"},{"$f":"Constants!L10","v":"Swing Check"},"Ball/ Butterfly",{"$f":"Constants!O10","v":"Wye-Strainer"},{"$f":"Constants!P10","v":"Suction Diffuser"},"Flow Limiting Valve (feet)",null,null,null,null,"piping","insulation",90,45,"LINE",{"$f":"Constants!J10","v":"Circuit Setter"},{"$f":"Constants!K10","v":"Silent Check"},{"$f":"Constants!L10","v":"Swing Check"},"Ball/ Butterfly",{"$f":"Constants!O10","v":"Wye-Strainer"},{"$f":"Constants!P10","v":"Suction Diffuser"},{"$f":"Constants!Q10","v":"Flow Limiting Valve"},null,"piping","insulation",90,45,"LINE",{"$f":"Constants!J10","v":"Circuit Setter"},{"$f":"Constants!K10","v":"Silent Check"},{"$f":"Constants!L10","v":"Swing Check"},{"$f":"CL6","v":"Ball/ Butterfly"},{"$f":"Constants!O10","v":"Wye-Strainer"},{"$f":"Constants!P10","v":"Suction Diffuser"},{"$f":"Constants!Q10","v":"Flow Limiting Valve"},null,null,null,"Materials","Taxes","Labor","Contractor Markup","Total",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,1,true,null,{"$f":"MROUND(D7,1)","v":0},"AUTO",6,{"$f":"IF(F7=$F$100,G7,F7)","v":6},"AUTO",{"$f":"'System Assumptions'!$D$11","v":2000},"ON",{"$f":"IF(K7=$K$101,\"N/A\",IF(BQ7>(VLOOKUP(U7,Constants!$C$127:$D$141,2)),\"YES\",\"NO\"))","v":"NO"},{"$f":"O7^3","v":125000},{"$f":"O7^2","v":2500},{"$f":"'System Assumptions'!$D$8","v":50},{"$f":"TREND(Constants!$K$38:$K$47,Constants!$H$38:$J$47,M7:O7)","v":1.4249979974417573E-5},"ON",{"$f":"IF(Q7=$Q$100,IF(BQ7>VLOOKUP(J7*BT7,Constants!$L$127:$M$131,2,1),\"YES\",\"NO\"),\"N/A\")","v":"NO"},{"$f":"IF(H7>0,IF(H7>Constants!$F$52,1,0),0)","v":1},{"$f":"IF(S7=0,Constants!$V$32,Constants!$W$32 )","v":1.4999999999999999E-4},{"$f":"IF(H7>0,VLOOKUP(H7,PIPE_ID,IF(S7=0,2,3)),1)","v":6.0650000000000004},{"$f":"X7^3","v":0},{"$f":"X7^2","v":0},{"$f":"Y7/10000","v":0},{"$f":" U7/12 * BQ7 / P7","v":0},{"$f":"T7/(U7/12)","v":2.9678483099752673E-4},{"$f":"TREND(Constants!$AB$10:$AB$15,Constants!$Y$10:$AA$15,V7:X7)","v":34.963423311999577},{"$f":"1/(1.14+2*LOG10(Z7))^2","v":2.8580734136771244E-2},{"$f":"(2.457*LN(1/((7/Y7)^0.9+(0.27*Z7))))^16","v":{"$error":"#DIV/0!"}},{"$f":"(37530/Y7)^16","v":{"$error":"#DIV/0!"}},{"$f":"8*((8/Y7)^12+(1/(AC7+AD7))^(1.5))^(1/12)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Y7<3000,\"Laminar\",IF(AND(Y7>10000,Z7>AA7),\"Fully Rough\",\"Partially Rough\"))","v":"Laminar"},"Title 24",{"$f":"IF(H7=0,\"\",IF(AG7='System Assumptions'!$N$12,0,IF(AG7='System Assumptions'!$I$12,VLOOKUP(O7,Constants!$O$99:$U$107,HLOOKUP(H7,Constants!$P$98:$U$99,2)),AG7)))","v":1},null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(AP7),AP7<>9.99999999999999E+26),AN7,\"N\")","v":0},{"$f":"IF(AN7>0,CI7,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(AS7),AS7<>9.99999999999999E+26),AQ7,\"N\")","v":0},{"$f":"IF(AQ7>0,CJ7,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(AV7),AV7<>9.99999999999999E+26),AT7,\"N\")","v":0},{"$f":"IF(AT7>0,CL7,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(AY7),AY7<>9.99999999999999E+26),AW7,\"N\")","v":0},{"$f":"IF(AW7>0,CL7,0)","v":0},{"$f":"IF(H7<Constants!$F$53,0,1)","v":1},null,{"$f":"IF(AND(ISNUMBER(BC7),BC7<>9.99999999999999E+26),BA7,\"N\")","v":0},{"$f":"IF(BA7>0,CM7,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(BF7),BF7<>999999999),BD7,\"N\")","v":0},{"$f":"IF(BD7>0,CN7,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(BI7),BI7<>999999999),BG7,\"N\")","v":0},{"$f":"IF(BG7>0,CO7,0)","v":0},null,{"$f":"BJ7","v":0},null,{"$f":"BL7","v":0},null,{"$f":"SUM(BL7,BJ7*2.31,(BR7*AI7/100),CQ7/0.433,CP7)","v":{"$error":"#DIV/0!"}},{"$f":"BO7*0.433","v":{"$error":"#DIV/0!"}},{"$f":"(D7/U7^2)*(1.2835/PI())","v":0},{"$f":"100 * AE7 / (U7/12) * BQ7^2 / 64.32","v":{"$error":"#DIV/0!"}},{"$f":"AI7*(U7/2/12)^2*PI()*7.481","v":0},{"$f":"'System Assumptions'!$D$10","v":0.3},{"$f":"'Piping Circuit'!$B$3*BO7/(3960*Constants!$F$181)","v":{"$error":"#DIV/0!"}},{"$f":"BU7*0.746/(Constants!$F$199*IF(OR(CONST_VAR_UI=Constants!$Q$161,CONST_VAR_UI='System Assumptions'!$L$9),Constants!$C$217,1))*BT7","v":{"$error":"#DIV/0!"}},{"$f":"BU7*2545/12000*Constants!$C$215*BT7","v":{"$error":"#DIV/0!"}},{"$f":"-BU7*2545/100000/Constants!$C$216*BT7","v":{"$error":"#DIV/0!"}},{"$f":"BV7+IF('System Assumptions'!$D$7='System Assumptions'!$I$7,BW7,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF('System Assumptions'!$D$7='System Assumptions'!$J$7,BX7,0)","v":0},{"$f":"BY7*J7","v":{"$error":"#DIV/0!"}},{"$f":"BZ7*J7","v":0},null,{"$f":"VLOOKUP($H7,IF($S7=0,K_COPPER,K_STEEL),2)","v":0.28999999999999998},{"$f":"VLOOKUP($H7,IF($S7=0,K_COPPER,K_STEEL),3)","v":0.17},{"$f":"VLOOKUP($H7,IF($S7=0,K_COPPER,K_STEEL),4)","v":0.12},{"$f":"VLOOKUP($H7,IF($S7=0,K_COPPER,K_STEEL),5)","v":0.62},{"$f":"IF(AJ7>0,CD7*AJ7,0)+IF(AK7>0,CE7*AK7,0)+IF(AL7>0,CF7*AL7,0)+IF(AM7>0,CG7*AM7,0)","v":0},{"$f":"VLOOKUP($H7,CV_VALVES,2)","v":650},{"$f":"VLOOKUP($H7,CV_VALVES,3)","v":625},{"$f":"VLOOKUP($H7,CV_VALVES,4)","v":1440},{"$f":"IF(AZ7=0,VLOOKUP($H7,CV_VALVES,5),VLOOKUP($H7,CV_VALVES,6))","v":1613},{"$f":"VLOOKUP($H7,CV_VALVES,7)","v":597},{"$f":"VLOOKUP($H7,CV_VALVES,8)","v":520},{"$f":"VLOOKUP($H7,CV_VALVES,9)","v":7.4},{"$f":"CH7*BQ7^2/(2*32.1)","v":0},{"$f":"IF(AN7>0,($D7/CI7)^2,0)*AN7+IF(AQ7>0,($D7/CJ7)^2,0)*AQ7+IF(AT7>0,($D7/CK7)^2,0)*AT7+IF(AW7>0,($D7/CL7)^2,0)*AW7+IF(BA7>0,($D7/CM7)^2,0)*BA7+IF(BD7>0,($D7/CN7)^2,0)*BD7+IF(BG7>0,CO7,0)*BG7","v":0},null,null,{"$f":"VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),2)*$AI7","v":0},{"$f":"IF(AH7=0,0,VLOOKUP(H7,Constants!$B$97:$F$119,HLOOKUP(AH7,Constants!$C$96:$F$97,2))*$AI7)","v":0},{"$f":"VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!$E$51)*AJ7","v":0},{"$f":"VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!$G$51)*AK7","v":0},{"$f":"VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!$I$51)*(AL7+AM7)","v":0},{"$f":"IF(AN7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!K$51)*AN7)","v":0},{"$f":"IF(AQ7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!M$51)*AQ7)","v":0},{"$f":"IF(AT7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!O$51)*AT7)","v":0},{"$f":"IF(AW7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),IF(AZ7=0,Constants!Q$51,Constants!S$51))*AW7)","v":0},{"$f":"IF(BA7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!U$51)*BA7)","v":0},{"$f":"IF(BD7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!W$51)*BD7)","v":0},{"$f":"IF(BG7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!Y$51)*BG7)","v":0},null,{"$f":"VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!$D$51)*$AI7","v":0},{"$f":"IF(AH7=0,0,VLOOKUP(H7,Constants!$I$97:$M$119,HLOOKUP(AH7,Constants!$J$96:$M$97,2))*$AI7)","v":0},{"$f":"VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!$F$51)*AJ7","v":0},{"$f":"VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!$H$51)*AK7","v":0},{"$f":"VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!$J$51)*(AL7+AM7)","v":0},{"$f":"IF(AN7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!L$51)*AN7)","v":0},{"$f":"IF(AQ7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!N$51)*AQ7)","v":0},{"$f":"IF(AT7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!P$51)*AT7)","v":0},{"$f":"IF(AW7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),IF(AZ7=0,Constants!R$51,Constants!T$51))*AW7)","v":0},{"$f":"IF(BA7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!V$51)*BA7)","v":0},{"$f":"IF(BD7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!X$51)*BD7)","v":0},{"$f":"IF(BG7=0,0,VLOOKUP($H7,IF($S7,PRICE_STEEL,PRICE_COPPER),Constants!Z$51)*BG7)","v":0},null,null,null,{"$f":"'Economic Assumptions'!$D$7/100*SUM(CT7:DE7)*(1+'Economic Assumptions'!$D$14)^('Economic Assumptions'!$D$12-'Economic Assumptions'!$D$13)","v":0},{"$f":"DV7*'Economic Assumptions'!$D$15","v":0},{"$f":"'Economic Assumptions'!$D$8/100*SUM(DG7:DR7)*(1+'Economic Assumptions'!$D$14)^('Economic Assumptions'!$D$12-'Economic Assumptions'!$D$13)","v":0},{"$f":"SUM(DV7:DX7)*((1+'Economic Assumptions'!$D$10)*(1+'Economic Assumptions'!$D$11)-1)","v":0},{"$f":"SUM(DV7:DY7)","v":0},{"$f":"IF($H$3=$S$3,NPV(('Economic Assumptions'!$D$20),EC7:FP7),0)","v":{"$error":"#DIV/0!"}},{"$f":"DZ7+IF($H$3=$S$3,EA7,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(EC$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EC$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ED$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(ED$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EE$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EE$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EF$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EF$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EG$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EG$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EH$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EH$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EI$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EI$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EJ$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EJ$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EK$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EK$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EL$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EL$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EM$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EM$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EN$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EN$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EO$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EO$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EP$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EP$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EQ$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EQ$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ER$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(ER$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ES$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(ES$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ET$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(ET$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EU$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EU$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EV$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EV$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EW$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EW$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EX$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EX$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EY$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EY$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EZ$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EZ$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FA$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FA$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FB$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FB$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FC$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FC$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FD$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FD$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FE$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FE$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FF$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FF$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FG$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FG$6))","v":0},{"$f":"IF(FH$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FH$6))","v":0},{"$f":"IF(FI$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FI$6))","v":0},{"$f":"IF(FJ$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FJ$6))","v":0},{"$f":"IF(FK$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FK$6))","v":0},{"$f":"IF(FL$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FL$6))","v":0},{"$f":"IF(FM$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FM$6))","v":0},{"$f":"IF(FN$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FN$6))","v":0},{"$f":"IF(FO$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FO$6))","v":0},{"$f":"IF(FP$6>'Economic Assumptions'!$D$21,0,($CA7*'Economic Assumptions'!$D$16+$CB7*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FP$6))","v":0}]
[null,2,true,null,{"$f":"MROUND(D8,1)","v":0},"AUTO",6,{"$f":"IF(F8=$F$100,G8,F8)","v":6},"AUTO",{"$f":"'System Assumptions'!$D$11","v":2000},"ON",{"$f":"IF(K8=$K$101,\"N/A\",IF(BQ8>(VLOOKUP(U8,Constants!$C$127:$D$141,2)),\"YES\",\"NO\"))","v":"NO"},{"$f":"O8^3","v":125000},{"$f":"O8^2","v":2500},{"$f":"'System Assumptions'!$D$8","v":50},{"$f":"TREND(Constants!$K$38:$K$47,Constants!$H$38:$J$47,M8:O8)","v":1.4249979974417573E-5},"ON",{"$f":"IF(Q8=$Q$100,IF(BQ8>VLOOKUP(J8*BT8,Constants!$L$127:$M$131,2,1),\"YES\",\"NO\"),\"N/A\")","v":"NO"},{"$f":"IF(H8>0,IF(H8>Constants!$F$52,1,0),0)","v":1},{"$f":"IF(S8=0,Constants!$V$32,Constants!$W$32 )","v":1.4999999999999999E-4},{"$f":"IF(H8>0,VLOOKUP(H8,PIPE_ID,IF(S8=0,2,3)),1)","v":6.0650000000000004},{"$f":"X8^3","v":0},{"$f":"X8^2","v":0},{"$f":"Y8/10000","v":0},{"$f":" U8/12 * BQ8 / P8","v":0},{"$f":"T8/(U8/12)","v":2.9678483099752673E-4},{"$f":"TREND(Constants!$AB$10:$AB$15,Constants!$Y$10:$AA$15,V8:X8)","v":34.963423311999577},{"$f":"1/(1.14+2*LOG10(Z8))^2","v":2.8580734136771244E-2},{"$f":"(2.457*LN(1/((7/Y8)^0.9+(0.27*Z8))))^16","v":{"$error":"#DIV/0!"}},{"$f":"(37530/Y8)^16","v":{"$error":"#DIV/0!"}},{"$f":"8*((8/Y8)^12+(1/(AC8+AD8))^(1.5))^(1/12)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Y8<3000,\"Laminar\",IF(AND(Y8>10000,Z8>AA8),\"Fully Rough\",\"Partially Rough\"))","v":"Laminar"},"Title 24",{"$f":"IF(H8=0,\"\",IF(AG8='System Assumptions'!$N$12,0,IF(AG8='System Assumptions'!$I$12,VLOOKUP(O8,Constants!$O$99:$U$107,HLOOKUP(H8,Constants!$P$98:$U$99,2)),AG8)))","v":1},null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(AP8),AP8<>9.99999999999999E+26),AN8,\"N\")","v":0},{"$f":"IF(AN8>0,CI8,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(AS8),AS8<>9.99999999999999E+26),AQ8,\"N\")","v":0},{"$f":"IF(AQ8>0,CJ8,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(AV8),AV8<>9.99999999999999E+26),AT8,\"N\")","v":0},{"$f":"IF(AT8>0,CL8,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(AY8),AY8<>9.99999999999999E+26),AW8,\"N\")","v":0},{"$f":"IF(AW8>0,CL8,0)","v":0},{"$f":"IF(H8<Constants!$F$53,0,1)","v":1},null,{"$f":"IF(AND(ISNUMBER(BC8),BC8<>9.99999999999999E+26),BA8,\"N\")","v":0},{"$f":"IF(BA8>0,CM8,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(BF8),BF8<>999999999),BD8,\"N\")","v":0},{"$f":"IF(BD8>0,CN8,0)","v":0},null,{"$f":"IF(AND(ISNUMBER(BI8),BI8<>999999999),BG8,\"N\")","v":0},{"$f":"IF(BG8>0,CO8,0)","v":0},null,{"$f":"BJ8","v":0},null,{"$f":"BL8","v":0},null,{"$f":"SUM(BL8,BJ8*2.31,(BR8*AI8/100),CQ8/0.433,CP8)","v":{"$error":"#DIV/0!"}},{"$f":"BO8*0.433","v":{"$error":"#DIV/0!"}},{"$f":"(D8/U8^2)*(1.2835/PI())","v":0},{"$f":"100 * AE8 / (U8/12) * BQ8^2 / 64.32","v":{"$error":"#DIV/0!"}},{"$f":"AI8*(U8/2/12)^2*PI()*7.481","v":0},{"$f":"'System Assumptions'!$D$10","v":0.3},{"$f":"'Piping Circuit'!$B$3*BO8/(3960*Constants!$F$181)","v":{"$error":"#DIV/0!"}},{"$f":"BU8*0.746/(Constants!$F$199*IF(OR(CONST_VAR_UI=Constants!$Q$161,CONST_VAR_UI='System Assumptions'!$L$9),Constants!$C$217,1))*BT8","v":{"$error":"#DIV/0!"}},{"$f":"BU8*2545/12000*Constants!$C$215*BT8","v":{"$error":"#DIV/0!"}},{"$f":"-BU8*2545/100000/Constants!$C$216*BT8","v":{"$error":"#DIV/0!"}},{"$f":"BV8+IF('System Assumptions'!$D$7='System Assumptions'!$I$7,BW8,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF('System Assumptions'!$D$7='System Assumptions'!$J$7,BX8,0)","v":0},{"$f":"BY8*J8","v":{"$error":"#DIV/0!"}},{"$f":"BZ8*J8","v":0},null,{"$f":"VLOOKUP($H8,IF($S8=0,K_COPPER,K_STEEL),2)","v":0.28999999999999998},{"$f":"VLOOKUP($H8,IF($S8=0,K_COPPER,K_STEEL),3)","v":0.17},{"$f":"VLOOKUP($H8,IF($S8=0,K_COPPER,K_STEEL),4)","v":0.12},{"$f":"VLOOKUP($H8,IF($S8=0,K_COPPER,K_STEEL),5)","v":0.62},{"$f":"IF(AJ8>0,CD8*AJ8,0)+IF(AK8>0,CE8*AK8,0)+IF(AL8>0,CF8*AL8,0)+IF(AM8>0,CG8*AM8,0)","v":0},{"$f":"VLOOKUP($H8,CV_VALVES,2)","v":650},{"$f":"VLOOKUP($H8,CV_VALVES,3)","v":625},{"$f":"VLOOKUP($H8,CV_VALVES,4)","v":1440},{"$f":"IF(AZ8=0,VLOOKUP($H8,CV_VALVES,5),VLOOKUP($H8,CV_VALVES,6))","v":1613},{"$f":"VLOOKUP($H8,CV_VALVES,7)","v":597},{"$f":"VLOOKUP($H8,CV_VALVES,8)","v":520},{"$f":"VLOOKUP($H8,CV_VALVES,9)","v":7.4},{"$f":"CH8*BQ8^2/(2*32.1)","v":0},{"$f":"IF(AN8>0,($D8/CI8)^2,0)*AN8+IF(AQ8>0,($D8/CJ8)^2,0)*AQ8+IF(AT8>0,($D8/CK8)^2,0)*AT8+IF(AW8>0,($D8/CL8)^2,0)*AW8+IF(BA8>0,($D8/CM8)^2,0)*BA8+IF(BD8>0,($D8/CN8)^2,0)*BD8+IF(BG8>0,CO8,0)*BG8","v":0},null,null,{"$f":"VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),2)*$AI8","v":0},{"$f":"IF(AH8=0,0,VLOOKUP(H8,Constants!$B$97:$F$119,HLOOKUP(AH8,Constants!$C$96:$F$97,2))*$AI8)","v":0},{"$f":"VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!$E$51)*AJ8","v":0},{"$f":"VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!$G$51)*AK8","v":0},{"$f":"VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!$I$51)*(AL8+AM8)","v":0},{"$f":"IF(AN8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!K$51)*AN8)","v":0},{"$f":"IF(AQ8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!M$51)*AQ8)","v":0},{"$f":"IF(AT8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!O$51)*AT8)","v":0},{"$f":"IF(AW8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),IF(AZ8=0,Constants!Q$51,Constants!S$51))*AW8)","v":0},{"$f":"IF(BA8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!U$51)*BA8)","v":0},{"$f":"IF(BD8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!W$51)*BD8)","v":0},{"$f":"IF(BG8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!Y$51)*BG8)","v":0},null,{"$f":"VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!$D$51)*$AI8","v":0},{"$f":"IF(AH8=0,0,VLOOKUP(H8,Constants!$I$97:$M$119,HLOOKUP(AH8,Constants!$J$96:$M$97,2))*$AI8)","v":0},{"$f":"VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!$F$51)*AJ8","v":0},{"$f":"VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!$H$51)*AK8","v":0},{"$f":"VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!$J$51)*(AL8+AM8)","v":0},{"$f":"IF(AN8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!L$51)*AN8)","v":0},{"$f":"IF(AQ8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!N$51)*AQ8)","v":0},{"$f":"IF(AT8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!P$51)*AT8)","v":0},{"$f":"IF(AW8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),IF(AZ8=0,Constants!R$51,Constants!T$51))*AW8)","v":0},{"$f":"IF(BA8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!V$51)*BA8)","v":0},{"$f":"IF(BD8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!X$51)*BD8)","v":0},{"$f":"IF(BG8=0,0,VLOOKUP($H8,IF($S8,PRICE_STEEL,PRICE_COPPER),Constants!Z$51)*BG8)","v":0},null,null,null,{"$f":"'Economic Assumptions'!$D$7/100*SUM(CT8:DE8)*(1+'Economic Assumptions'!$D$14)^('Economic Assumptions'!$D$12-'Economic Assumptions'!$D$13)","v":0},{"$f":"DV8*'Economic Assumptions'!$D$15","v":0},{"$f":"'Economic Assumptions'!$D$8/100*SUM(DG8:DR8)*(1+'Economic Assumptions'!$D$14)^('Economic Assumptions'!$D$12-'Economic Assumptions'!$D$13)","v":0},{"$f":"SUM(DV8:DX8)*((1+'Economic Assumptions'!$D$10)*(1+'Economic Assumptions'!$D$11)-1)","v":0},{"$f":"SUM(DV8:DY8)","v":0},{"$f":"IF($H$3=$S$3,NPV(('Economic Assumptions'!$D$20),EC8:FP8),0)","v":{"$error":"#DIV/0!"}},{"$f":"DZ8+IF($H$3=$S$3,EA8,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(EC$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EC$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ED$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(ED$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EE$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EE$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EF$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EF$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EG$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EG$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EH$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EH$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EI$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EI$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EJ$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EJ$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EK$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EK$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EL$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EL$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EM$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EM$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EN$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EN$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EO$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EO$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EP$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EP$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EQ$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EQ$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ER$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(ER$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ES$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(ES$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(ET$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(ET$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EU$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EU$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EV$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EV$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EW$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EW$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EX$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EX$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EY$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EY$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(EZ$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(EZ$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FA$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FA$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FB$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FB$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FC$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FC$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FD$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FD$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FE$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FE$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FF$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FF$6))","v":{"$error":"#DIV/0!"}},{"$f":"IF(FG$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FG$6))","v":0},{"$f":"IF(FH$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FH$6))","v":0},{"$f":"IF(FI$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FI$6))","v":0},{"$f":"IF(FJ$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FJ$6))","v":0},{"$f":"IF(FK$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FK$6))","v":0},{"$f":"IF(FL$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FL$6))","v":0},{"$f":"IF(FM$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FM$6))","v":0},{"$f":"IF(FN$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FN$6))","v":0},{"$f":"IF(FO$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FO$6))","v":0},{"$f":"IF(FP$6>'Economic Assumptions'!$D$21,0,($CA8*'Economic Assumptions'!$D$16+$CB8*'Economic Assumptions'!$D$17)*(1+'Economic Assumptions'!$D$18+'Economic Assumptions'!$D$19)^(FP$6))","v":0}]
[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,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,null,null,null,null,null,"Totals",null,null,{"$f":"SUM(BO7:BO8)","v":{"$error":"#DIV/0!"}},{"$f":"BO9*0.433","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(BS7:BS8)","v":0},null,{"$f":"SUM(BU7:BU8)","v":{"$error":"#DIV/0!"}},null,null,null,"without Safety Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(BHP_TOTAL_W_SF*1.1,Constants!$W$98:$AC$120,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(CONST_VAR_UI='System Assumptions'!$K$9,CONST_VAR_UI='System Assumptions'!$L$9),VLOOKUP(BHP_TOTAL_W_SF,Constants!$W$98:$AC$120,5),0)","v":{"$error":"#DIV/0!"}},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,{"$f":"VLOOKUP(BHP_TOTAL_W_SF*1.1,Constants!$W$98:$AC$120,3)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(CONST_VAR_UI='System Assumptions'!$K$9,CONST_VAR_UI='System Assumptions'!$L$9),VLOOKUP(BHP_TOTAL_W_SF,Constants!$W$98:$AC$120,6),0)","v":{"$error":"#DIV/0!"}},null,{"$f":"(CR9+CS9)*(1+'Economic Assumptions'!$D$14)^('Economic Assumptions'!$D$12-'Economic Assumptions'!$D$13)","v":{"$error":"#DIV/0!"}},{"$f":"DV9*'Economic Assumptions'!$D$15","v":{"$error":"#DIV/0!"}},{"$f":"(DS9+DT9)*(1+'Economic Assumptions'!$D$14)^('Economic Assumptions'!$D$12-'Economic Assumptions'!$D$13)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(DV9:DX9)*((1+'Economic Assumptions'!$D$10)*(1+'Economic Assumptions'!$D$11)-1)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(DZ7:DZ8)+SUM(DV9:DY9)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(EA7:EA8)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(DZ9:EA9)","v":{"$error":"#DIV/0!"}}]
[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,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,null,null,null,null,null,null,null,"+",{"$f":"MAX('System Assumptions'!$D$16,0.01*'System Assumptions'!$D$15*BO9)","v":{"$error":"#DIV/0!"}},null,"Safety factor",null,null,null,{"$f":"BO11*SYSTEM_GPM/3960/Constants!$F$181","v":{"$error":"#DIV/0!"}},null,null,null,"with Safety Factor"]
["Output Summary:",null,"Previous Cost",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,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,null,null,null,null,null,{"$f":"SUM(BO9:BO10)","v":{"$error":"#DIV/0!"}}]
[]
["Total Head (Feet)",{"$f":"BO9","v":{"$error":"#DIV/0!"}}]
["Total Head w S.F. (Feet)",{"$f":"BO11","v":{"$error":"#DIV/0!"}}]
[]
["Total Cost",{"$f":"B18+B17","v":{"$error":"#DIV/0!"}}]
["Lifecycle Energy Cost",{"$f":"IF($H$3=$S$3,EA9,0)","v":{"$error":"#DIV/0!"}},183.86]
["First Cost",{"$f":"DZ9","v":{"$error":"#DIV/0!"}}]
[]
["Scalar Ratio",{"$f":"EA9/(SUM(EC7:EC8)/(1+'Economic Assumptions'!D18+'Economic Assumptions'!D19))","v":{"$error":"#DIV/0!"}}]
[]
["Notes:"]
["Enter user notes here."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"AUTO",null,null,null,null,"ON",null,null,null,null,null,"ON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title 24"]
[null,null,null,null,null,{"$f":"Constants!U11","v":0.5},null,null,null,null,"OFF",null,null,null,null,null,"OFF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,{"$f":"Constants!U12","v":0.75},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,1]
[null,null,null,null,null,{"$f":"Constants!U13","v":1},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,1.5]
[null,null,null,null,null,{"$f":"Constants!U14","v":1.25},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,2]
[null,null,null,null,null,{"$f":"Constants!U15","v":1.5},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,"None"]
[null,null,null,null,null,{"$f":"Constants!U16","v":2}]
[null,null,null,null,null,{"$f":"Constants!U17","v":2.5}]
[null,null,null,null,null,{"$f":"Constants!U18","v":3}]
[null,null,null,null,null,{"$f":"Constants!U19","v":4}]
[null,null,null,null,null,{"$f":"Constants!U20","v":5}]
[null,null,null,null,null,{"$f":"Constants!U21","v":6}]
[null,null,null,null,null,{"$f":"Constants!U22","v":8}]
[null,null,null,null,null,{"$f":"Constants!U23","v":10}]
[null,null,null,null,null,{"$f":"Constants!U24","v":12}]
[null,null,null,null,null,{"$f":"Constants!U25","v":14}]
[null,null,null,null,null,{"$f":"Constants!U26","v":16}]
[null,null,null,null,null,{"$f":"Constants!U27","v":18}]
[null,null,null,null,null,{"$f":"Constants!U28","v":20}]
[null,null,null,null,null,{"$f":"Constants!U29","v":24}]
[null,null,null,null,null,{"$f":"Constants!U30","v":26}]
[null,null,null,null,null,{"$f":"Constants!U31","v":30}]

{"sheet":"Constants","index":4,"n_rows":217,"n_cols":35,"rows_kept":217,"cut":false,"hidden":false,"merged":[[95,15,95,20],[70,16,70,17],[124,11,124,12],[54,6,54,7],[70,6,70,7],[70,20,70,21],[54,14,54,15],[70,14,70,15],[54,20,54,21],[70,18,70,19],[54,12,54,13],[70,4,70,5],[70,8,70,9],[70,10,70,11],[54,8,54,9],[54,10,54,11],[54,4,54,5],[7,8,7,16],[20,1,20,5],[8,1,9,1],[8,2,8,3],[8,4,8,5],[124,1,124,3],[54,2,54,3],[70,2,70,3],[7,24,7,27],[21,1,22,1],[21,2,21,3],[21,4,21,5],[8,21,8,22],[7,20,7,22],[54,22,54,23],[54,18,54,19],[54,16,54,17],[70,12,70,13],[7,1,7,5],[8,8,9,8],[8,9,8,15],[95,31,95,32],[95,33,95,34],[95,23,95,25],[95,26,95,28],[54,24,54,25],[70,24,70,25],[70,22,70,23]]}
[]
[null,null,"Grey cells indicate components or elements that do not exist; values are set to 999999999"]
[null,null,"Pink cells indicate extrapolations for data points that were unavailable"]
[null,"Red","Red font indicates updated pricing values"]
[]
[null,"Flow Parameters"]
[]
[null,"K VALUES COPPER",null,null,null,null,null,null,"VALVES",null,null,null,null,null,null,null,null,null,null,null,"PIPE INNER DIAMETERS",null,null,null,"Threshold for fully turbulent rough flow"]
[null,"SIZE","ELLS",null,"TEES",null,null,null,"SIZE","Cv",null,null,null,null,null,null,"dP (feet)",null,null,null,"O.D \"","I.D. \"",null,null,"Re3","Re2","Reynolds Number* 10-4","Relative Roughness, D/E"]
[null,null,90,45,"Straight","Branch",null,null,null,"Circuit Setter","Silent Check","Swing Check","Ball","Butterfly","Wye-Strainer","Suction Diffuser","Flow Limiting Valve",null,null,null,null,"Type L COPPER","SCH 40 or STD WT STEEL",null,{"$f":"AA10^3","v":27},{"$f":"AA10^2","v":9},3,{"$f":"1/0.05","v":20}]
[null,0.5,0.47,0.25,0.28999999999999998,1.1000000000000001,null,null,0.5,1.7,6.86,4.8,5,999999999,{"$f":"TREND(($O$16:$O$24)^(1/3),$I$16:$I$24,I11)^3","v":25.897726955252654},999999999,7.4,null,null,null,0.5,0.54500000000000004,0.622,null,0.85737499999999989,0.90249999999999997,0.95,{"$f":"1/0.015","v":66.666666666666671}]
[null,0.75,0.45,0.24,0.28000000000000003,1.05,null,null,0.75,2.7,16.3,14.3,12,999999999,{"$f":"TREND(($O$16:$O$24)^(1/3),$I$16:$I$24,I12)^3","v":32.792617041558842},999999999,7.4,null,null,null,0.75,0.78500000000000003,0.82399999999999995,null,474552,6084,78,{"$f":"1/0.002","v":500}]
[null,1,0.43,0.22,0.26,1,null,null,1,5.8,30,24,22,999999999,{"$f":"TREND(($O$16:$O$24)^(1/3),$I$16:$I$24,I13)^3","v":40.814026761410695},999999999,7.4,null,null,null,1,1.0249999999999999,1.0489999999999999,null,85184000,193600,440,{"$f":"1/0.0004","v":2500}]
[null,1.25,0.41,0.22,0.25,0.95,null,null,1.25,11,49,43,35,999999999,{"$f":"TREND(($O$16:$O$24)^(1/3),$I$16:$I$24,I14)^3","v":50.047196319514008},999999999,7.4,null,null,null,1.25,1.2649999999999999,1.38,null,9261000000,4410000,2100,{"$f":"1/0.0001","v":10000}]
[null,1.5,0.4,0.21,0.23,0.9,null,null,1.5,20,72,60,52,999999999,{"$f":"TREND(($O$16:$O$24)^(1/3),$I$16:$I$24,I15)^3","v":60.577365920574543},999999999,7.4,null,null,null,1.5,1.5049999999999999,1.61,null,97336000000,21160000,{"$f":"46000000/10000","v":4600},{"$f":"1/0.00005","v":20000}]
[null,2,0.38,0.2,0.2,0.84,null,null,2,40,130,102,95,166,72,55,7.4,null,null,null,2,1.9850000000000001,2.0670000000000002]
[null,2.5,0.35,0.19,0.18,0.79,null,null,2.5,62,110,221,999999999,247,111,90,7.4,null,null,null,2.5,2.4649999999999999,2.4689999999999999]
[null,3,0.34,0.18,0.17,0.76,null,null,3,110,155,327,999999999,340,164,110,7.4,null,null,null,3,2.9449999999999998,3.0680000000000001]
[null,4,0.31,0.18,0.15,0.7,null,null,4,220,278,605,999999999,660,285,200,7.4,null,null,null,4,3.9049999999999998,4.0259999999999998]
[null,null,null,null,null,null,null,null,5,420,431,975,999999999,1080,410,350,7.4,null,null,null,5,4.875,5.0469999999999997]
[null,"K VALUES STEEL",null,null,null,null,null,null,6,650,625,1440,999999999,1613,597,520,7.4,null,null,null,6,5.8449999999999998,6.0650000000000004]
[null,"SIZE","ELLS",null,"TEES",null,null,null,8,875,1115,2670,999999999,3759,1000,760,7.4,null,null,null,8,7.7249999999999996,7.9809999999999999]
[null,null,90,45,"Straight","BRANCH",null,null,10,1200,1770,4300,999999999,5300,1800,1000,7.4,null,null,null,10,9.625,10.02]
[null,1,0.43,0.22,0.26,1,null,null,12,2250,2500,6350,999999999,7969,2800,999999999,7.4,null,null,null,12,11.565,12]
[null,1.25,0.41,0.22,0.25,0.95,null,null,14,999999999,3400,8600,999999999,11917,{"$f":"ROUND(TREND(($O$16:$O$24)^(1/3),$I$16:$I$24,I25)^3,-1)","v":4120},999999999,7.4,null,null,null,14,null,13.25]
[null,1.5,0.4,0.21,0.23,0.9,null,null,16,999999999,4400,11400,999999999,16383,{"$f":"ROUND(TREND(($O$16:$O$24)^(1/3),$I$16:$I$24,I26)^3,-1)","v":5810},999999999,7.4,null,null,null,16,null,15.25]
[null,2,0.38,0.2,0.2,0.84,null,null,18,999999999,5600,14700,999999999,21705,7900,999999999,7.4,null,null,null,18,null,17.25]
[null,2.5,0.35,0.19,0.18,0.79,null,null,20,999999999,6900,18100,999999999,27908,10430,999999999,7.4,null,null,null,20,null,19.25]
[null,3,0.34,0.18,0.17,0.76,null,null,24,999999999,10000,26800,999999999,43116,17020,999999999,7.4,null,null,null,24,null,23.25]
[null,4,0.31,0.18,0.15,0.7,null,null,26,999999999,15400,31000,999999999,60922,21170,999999999,999999999,null,null,null,26,null,25.25]
[null,5,0.3,0.17,0.13,0.66,null,null,30,999999999,22400,42000,999999999,86375,31370,999999999,999999999,null,null,null,30,null,29.25]
[null,6,0.28999999999999998,0.17,0.12,0.62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roughness",5.0000000000000004E-6,1.4999999999999999E-4,"inches"]
[null,8,0.27,0.17,0.1,0.57999999999999996,null,"Property at T=","32°F","77°F","212°F"]
[null,10,0.25,0.16,0.09,0.53,null,"c (Btu/lbm-°F)",1.0069999999999999,0.998,1.0069999999999999]
[null,12,0.24,0.16,0.09,0.5,null,"u (ft3/lbm)",1.6E-2,1.61E-2,1.67E-2]
[null,14,0.23,0.15,0.08,0.5]
[null,16,0.23,0.15,0.08,0.47,null,"T-cubed","T-squared","Temperature","Viscosity"]
[null,18,0.22,0.14000000000000001,7.0000000000000007E-2,0.44,null,{"$f":"J38^3","v":64000},{"$f":"J38^2","v":1600},40,1.66E-5]
[null,20,0.22,0.14000000000000001,7.0000000000000007E-2,0.42,null,{"$f":"J39^3","v":125000},{"$f":"J39^2","v":2500},50,1.4100000000000001E-5]
[null,24,0.21,0.13,0.06,0.41,null,343000,4900,70,1.06E-5]
[null,26,0.21,0.13,0.06,0.4,null,729000,8100,90,8.2600000000000005E-6]
[null,30,0.2,0.12,0.05,0.39,null,1331000,12100,110,6.6699999999999997E-6]
[null,null,null,null,null,null,null,2197000,16900,130,5.5799999999999999E-6]
[null,null,null,null,null,null,null,3375000,22500,150,4.7600000000000002E-6]
[null,null,null,null,null,null,null,4913000,28900,170,4.1300000000000003E-6]
[null,null,null,null,null,null,null,6859000,36100,190,3.6200000000000001E-6]
[null,null,null,null,null,null,null,9528128,44944,212,3.19E-6]
[]
[]
[" ","Piping Component Pricing"]
["column for vlookup",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,"Use copper piping for sizes less than or equal to:",null,null,null,2.5,"inches"]
[null,"Use butterfly valve for sizes greater than or equal to:",null,null,null,3,"inches"]
[null,"Copper pipe pricing (type L)"]
[null,null,"piping",null,"90 ell",null,"45 ell",null,"tee",null,{"$f":"J10","v":"Circuit Setter"},null,{"$f":"K10","v":"Silent Check"},null,{"$f":"L10","v":"Swing Check"},null,{"$f":"M10","v":"Ball"},null,{"$f":"N10","v":"Butterfly"},null,{"$f":"O10","v":"Wye-Strainer"},null,{"$f":"P10","v":"Suction Diffuser"},null,{"$f":"Q10","v":"Flow Limiting Valve"}]
[null,"Size","Mat ($/LF)","Inst ($/LF)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)"]
[null,0.5,2.2599999999999998,4.6100000000000003,0.92,18.7,1.67,18.7,1.56,28.5,40,17.149999999999999,{"$f":"TREND($M$59:$M$67,$B$59:$B$67,B57)","v":93.766156462584775},{"$f":"L57","v":17.149999999999999},23.5,15.55,10.3,17,999999999,999999999,19.2,18.850000000000001,999999999,999999999,120.98,{"$f":"L57","v":17.149999999999999}]
[null,0.75,3.51,4.92,2.04,19.649999999999999,2.93,19.649999999999999,3.75,31,44,18.850000000000001,{"$f":"TREND($M$59:$M$67,$B$59:$B$67,B58)","v":148.15816326530589},{"$f":"L58","v":18.850000000000001},30,18.7,16.95,18.7,999999999,999999999,21.5,19.850000000000001,999999999,999999999,131.12,18.850000000000001]
[null,1,5.0999999999999996,5.5,5,23.5,7.35,23.5,11.6,37.5,54,21,260,26.5,42,19.649999999999999,21.5,19.649999999999999,999999999,999999999,23,22,999999999,999999999,142.72,21]
[null,1.25,7.05,6.45,7.6,25,10.45,25,16.7,41.5,78,25,271,31,54.5,25,32.5,25,999999999,999999999,51.5,25,999999999,999999999,263.7,25]
[null,1.5,9.0500000000000007,7.2,11.8,28.5,12.6,28.5,25.5,46.5,91,31.5,325,34,72,28.5,42.5,28.5,999999999,999999999,365,34.5,999999999,999999999,263.7,31.5]
[null,2,14.05,8.9,21.5,34,21,34,40,53.5,130,37.5,440,41.5,109,34,51.5,34,227,26.5,440,47,250,63,394.1,37.5]
[null,2.5,21.5,10.85,45.5,51.5,45,51.5,95,84,370,45,495,74.5,258,45,172,41.5,228,74.5,650,136,279,104,587.54,45]
[null,3,29.5,12,60.5,61,66.5,51.5,124,96,562,170,550,84,345,51.5,261,46.5,240,84,805,151,279,104,587.54,170]
[null,4,50,17.25,156,74.5,142,74.5,299,135,867,226,810,135,{"$f":"O81","v":1100},224,999999999,999999999,271,135,1225,226,550,194,1514.78,226]
[null,5,107,19.8,650,112,550,112,980,168,1308,{"$f":"TREND($L$73:$L$80,$B$73:$B$80,B66)","v":205.17763157894737},1050,174,1400,287,999999999,999999999,335,209,1225,310,725,278,1514.78,205.17763157894737]
[null,6,149,26,865,116,865,116,1325,174,1763,{"$f":"TREND($L$73:$L$80,$B$73:$B$80,B67)","v":251.55657894736842},1375,209,1700,350,999999999,999999999,375,209,2325,350,755,320,1514.78,251.55657894736842]
[null,8,208,29,3200,131,2950,131,5150,209,3313,{"$f":"TREND($L$73:$L$80,$B$73:$B$80,B68)","v":344.3144736842105},{"$f":"M84","v":2225},{"$f":"N84","v":232},2800,420,999999999,999999999,485,232,2550,405,1025,390,2338.04,344.3144736842105]
[]
[null,"Steel pipe pricing "]
[null,null,"piping",null,"90 ell",null,"45 ell",null,"tee",null,{"$f":"J10","v":"Circuit Setter"},null,{"$f":"K10","v":"Silent Check"},null,{"$f":"L10","v":"Swing Check"},null,{"$f":"M10","v":"Ball"},null,{"$f":"N10","v":"Butterfly"},null,{"$f":"O10","v":"Wye-Strainer"},null,{"$f":"P10","v":"Suction Diffuser"},null,{"$f":"Q10","v":"Flow Limiting Valve"}]
[null,"Size","Mat ($/LF)","Inst ($/LF)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)","Mat ($/ea)","Inst ($/ea)"]
[null,0.5,2.1800000000000002,5.95,27,{"$f":"42+3.51","v":45.51},37.5,{"$f":"42+3.51","v":45.51},68,{"$f":"67.5+5.6","v":73.099999999999994},40,17.149999999999999,{"$f":"M57","v":93.766156462584775},{"$f":"N57","v":17.149999999999999},{"$f":"TREND($O$78:$O$81,$B$78:$B$81,B73)","v":280.14285714285728},{"$f":"L73","v":17.149999999999999},62.5,{"$f":"35.5+2.96","v":38.46},999999999,999999999,7.75,18.850000000000001,999999999,999999999,{"$f":"Y57","v":120.98},{"$f":"L73","v":17.149999999999999}]
[null,0.75,2.58,6.1,27,{"$f":"42+3.51","v":45.51},37.5,{"$f":"42+3.51","v":45.51},68,{"$f":"67.5+5.6","v":73.099999999999994},44,18.850000000000001,{"$f":"M58","v":148.15816326530589},{"$f":"N58","v":18.850000000000001},{"$f":"TREND($O$78:$O$81,$B$78:$B$81,B74)","v":335.78571428571439},{"$f":"L74","v":18.850000000000001},83,{"$f":"35.5+2.96","v":38.46},999999999,999999999,9.4499999999999993,21,999999999,999999999,{"$f":"Y58","v":131.12},{"$f":"L74","v":18.850000000000001}]
[null,1,3.7,{"$f":"7.25+0.6","v":7.85},13.1,{"$f":"42+3.51","v":45.51},13.45,{"$f":"42+3.51","v":45.51},34.5,{"$f":"67.5+5.6","v":73.099999999999994},54,21,340,26.5,510,37.5,103,{"$f":"45+3.74","v":48.74},999999999,999999999,12.9,23.5,999999999,999999999,142.72,21]
[null,1.25,4.93,{"$f":"8+0.67","v":8.67},13.1,{"$f":"48+4.01","v":52.01},13.45,{"$f":"48+4.01","v":52.01},42,{"$f":"74.5+6.25","v":80.75},78,25,375,31,{"$f":"TREND($O$78:$O$81,$B$78:$B$81,B76)","v":447.07142857142867},{"$f":"L76","v":25},138,{"$f":"51.5+4.32","v":55.82},999999999,999999999,17.2,25,999999999,999999999,263.7,25]
[null,1.5,5.65,{"$f":"8.85+0.74","v":9.59},13.1,{"$f":"51.1+4.32","v":55.42},13.45,{"$f":"51.5+4.32","v":55.82},42,{"$f":"84+7","v":91},91,31.5,410,34,{"$f":"TREND($O$78:$O$81,$B$78:$B$81,B77)","v":502.71428571428578},{"$f":"L77","v":31.5},180,{"$f":"61+5.1","v":66.099999999999994},999999999,999999999,101,34.5,999999999,999999999,263.7,31.5]
[null,2,7.4,{"$f":"11+0.92","v":11.92},14.1,{"$f":"67.5+5.6","v":73.099999999999994},13.45,{"$f":"67.5+5.6","v":73.099999999999994},34,{"$f":"112+9.35","v":121.35},130,37.5,495,41.5,645,46.5,255,{"$f":"79+6.6","v":85.6},227,26.5,106,47,{"$f":"W62","v":250},63,394.1,37.5]
[null,2.5,9.8000000000000007,{"$f":"14.3+1.19","v":15.49},16.95,{"$f":"84+7","v":91},15.7,{"$f":"84+7","v":91},46.5,{"$f":"135+11.25","v":146.25},370,45,595,74.5,745,135,999999999,999999999,228,74.5,128,136,279,104,587.54,45]
[null,3,12.5,{"$f":"15.65+1.31","v":16.96},21,{"$f":"96+8","v":104},16.95,{"$f":"96+8","v":104},51.5,{"$f":"168+14.05","v":182.05},562,170,695,84,745,149,999999999,999999999,240,84,142,151,279,104,587.54,170]
[null,4,16.5,{"$f":"18.2+1.52","v":19.72},34,{"$f":"135+11.25","v":146.25},30,{"$f":"135+11.25","v":146.25},72.5,{"$f":"224+18.7","v":242.7},867,226,945,135,1100,224,999999999,999999999,271,135,181,226,550,194,1514.78,226]
[null,5,24,{"$f":"21+1.76","v":22.76},71,{"$f":"168+14.05","v":182.05},46,{"$f":"168+14.05","v":182.05},120,{"$f":"269+22.5","v":291.5},1308,{"$f":"TREND($L$73:$L$80,$B$73:$B$80,B82)","v":205.17763157894737},1175,174,{"$f":"(O81+O83)/2","v":1400},{"$f":"(P81+P83)/2","v":287},999999999,999999999,335,209,283,310,725,278,1514.78,205.17763157894737]
[null,6,30,{"$f":"29+1.56","v":30.56},74,{"$f":"209+11.25","v":220.25},60,{"$f":"209+11.25","v":220.25},124,{"$f":"350+18.7","v":368.7},1763,{"$f":"TREND($L$73:$L$80,$B$73:$B$80,B83)","v":251.55657894736842},1525,209,1700,350,999999999,999999999,375,209,283,350,755,320,1514.78,251.55657894736842]
[null,8,47,{"$f":"36+1.94","v":37.94},140,{"$f":"279+15","v":294},100,279.14999999999998,219,{"$f":"420+22.5","v":442.5},3313,{"$f":"TREND($L$73:$L$80,$B$73:$B$80,B84)","v":344.3144736842105},2225,232,2800,420,999999999,999999999,485,232,580,420,1025,390,2338.04,344.3144736842105]
[null,10,60,{"$f":"43.5+2.34","v":45.84},282,{"$f":"350+18.7","v":368.7},200,{"$f":"350+18.7","v":368.7},435,{"$f":"525+28","v":553},4650,{"$f":"TREND($L$73:$L$80,$B$73:$B$80,B85)","v":437.0723684210526},3125,261,4150,475,999999999,999999999,620,261,1100,530,2475,440,2654.16,437.0723684210526]
[null,12,75,{"$f":"55+2.96","v":57.96},420,{"$f":"420+22.5","v":442.5},282,{"$f":"420+22.5","v":442.5},605,{"$f":"655+35","v":690},10133,{"$f":"TREND($L$73:$L$80,$B$73:$B$80,B86)","v":529.83026315789471},4825,350,5900,615,999999999,999999999,925,350,1675,620,3475,585,3401.69,529.83026315789471]
[null,14,85,{"$f":"69.5+3.74","v":73.239999999999995},430,{"$f":"525+28","v":553},380,{"$f":"525+28","v":553},985,{"$f":"805+43","v":848},999999999,999999999,7300,455,8525,805,999999999,999999999,1225,455,3075,810,5075,705,4445.58,{"$f":"TREND(Z$73:Z$86,$B$73:$B$86,B87)","v":626.9782109564361}]
[null,16,114,{"$f":"80.5+4.32","v":84.82},790,{"$f":"695+37.5","v":732.5},670,{"$f":"695+37.5","v":732.5},1200,{"$f":"1050+56","v":1106},999999999,999999999,10200,600,8550,1050,999999999,999999999,1600,600,4350,1050,999999999,999999999,6191.38,{"$f":"TREND(Z$73:Z$86,$B$73:$B$86,B88)","v":719.65320933334056}]
[null,18,120,{"$f":"95+5.1","v":100.1},1050,{"$f":"835+45","v":880},955,{"$f":"835+45","v":880},1875,{"$f":"1300+70","v":1370},999999999,999999999,10700,695,10400,805,999999999,999999999,2075,695,{"$f":" 24.528*(B89)^2 - 144.77*(B89) + 223.68","v":5564.8919999999998},{"$f":"TREND($V$73:$V$88,$B$73:$B$88,B89)","v":1073.3731699612799},999999999,999999999,8922.0499999999993,{"$f":"TREND(Z$73:Z$86,$B$73:$B$86,B89)","v":812.32820771024501}]
[null,20,146,{"$f":"116+6.25","v":122.25},1500,{"$f":"910+49","v":959},990,{"$f":"910+49","v":959},2900,{"$f":"1400+75","v":1475},999999999,999999999,{"$f":"TREND($M$86:$M$89,$B$86:$B$89,B90)","v":13387.5},{"$f":"TREND($N$86:$N$89,$B$86:$B$89,B90)","v":820},{"$f":"1.409*(B90)^3 + 2.3701*(B90)^2 + 31.065*(B90) + 105.57","v":12946.91},{"$f":"(P89+P91)/2","v":1102.5},999999999,999999999,2550,1050,{"$f":" 24.528*(B90)^2 - 144.77*(B90) + 223.68","v":7139.48},{"$f":"TREND($V$73:$V$88,$B$73:$B$88,B90)","v":1197.0751222743022},999999999,999999999,11209.68,{"$f":"TREND(Z$73:Z$86,$B$73:$B$86,B90)","v":905.00320608714947}]
[null,24,186,{"$f":"131+7","v":138},2000,{"$f":"1025+55","v":1080},1500,{"$f":"995+53.5","v":1048.5},3750,{"$f":"1500+80","v":1580},999999999,999999999,{"$f":"TREND($M$86:$M$89,$B$86:$B$89,B91)","v":17492.5},{"$f":"TREND($N$86:$N$89,$B$86:$B$89,B91)","v":1055.9999999999998},19700,1400,999999999,999999999,3575,1400,{"$f":" 24.528*(B91)^2 - 144.77*(B91) + 223.68","v":10877.327999999998},{"$f":"TREND($V$73:$V$88,$B$73:$B$88,B91)","v":1444.4790269003465},999999999,999999999,13497.32,{"$f":"TREND(Z$73:Z$86,$B$73:$B$86,B91)","v":1090.3532028409584}]
[null,26,345,{"$f":"139+7.5","v":146.5},2500,1200,1650,{"$f":"1225+66","v":1291},4125,{"$f":"1900+102","v":2002},999999999,999999999,{"$f":"TREND($M$86:$M$89,$B$86:$B$89,B92)","v":19545},{"$f":"TREND($N$86:$N$89,$B$86:$B$89,B92)","v":1173.9999999999998},{"$f":"1.409*(B92)^3 + 2.3701*(B92)^2 + 31.065*(B92) + 105.57","v":27280.031599999998},{"$f":"TREND($P$73:$P$86,$B$73:$B$86,B92)","v":1375.2977770353614},999999999,999999999,{"$f":" 6.9524*(B92)^2 - 27.085*(B92) + 260.97","v":4256.5824000000002},{"$f":"2.6448*(B92)^2 - 10.137*(B92) + 110.22","v":1634.5427999999999},{"$f":" 24.528*(B92)^2 - 144.77*(B92) + 223.68","v":13040.588},{"$f":"TREND($V$73:$V$88,$B$73:$B$88,B92)","v":1568.1809792133688},999999999,999999999,999999999,999999999]
[null,30,375,{"$f":"174+9.35","v":183.35},3000,1350,1825,{"$f":"2325+125","v":2450},4550,{"$f":"3475+187","v":3662},999999999,999999999,{"$f":"TREND($M$86:$M$89,$B$86:$B$89,B93)","v":23650},{"$f":"TREND($N$86:$N$89,$B$86:$B$89,B93)","v":1409.9999999999998},{"$f":"1.409*(B93)^3 + 2.3701*(B93)^2 + 31.065*(B93) + 105.57","v":41213.609999999993},{"$f":"TREND($P$73:$P$86,$B$73:$B$86,B93)","v":1589.6229826274666},999999999,999999999,{"$f":" 6.9524*(B93)^2 - 27.085*(B93) + 260.97","v":5705.58},{"$f":"2.6448*(B93)^2 - 10.137*(B93) + 110.22","v":2186.4299999999998},{"$f":" 24.528*(B93)^2 - 144.77*(B93) + 223.68","v":17955.78},{"$f":"TREND($V$73:$V$88,$B$73:$B$88,B93)","v":1815.5848838394131},999999999,999999999,999999999,999999999]
[]
[null,"Insulation Pricing: Materials",null,null,null,null,null,null,"Insulation Pricing: Installation",null,null,null,null,null,null,"Insulation thickness per T24",null,null,null,null,null,null,"Motor and VFD drive cost",null,null,null,null,null,null,null,"Motor and VFD drive cost per HP"]
[null,"Insul. Thickness",0.5,1,1.5,2,null,null,"Insul. Thickness",0.5,1,1.5,2,null,null,"Pipe diameter is less than: (in inches)",null,null,null,null,null,null,"HP","Pump",null,null,"VFD",null,null,null,"HP","Pump",null,"VFD"]
[null,"Pipe size",2,3,4,5,null,null,"Pipe size",2,3,4,5,null,null,null,null,null,null,null,null,null,"Greater than","Materials","Installation","Total","Materials","Installation","Total",null,null,"Materials","Installation","Materials","Installation"]
[null,0.375,{"$f":"TREND(C99:C105,$B$99:$B$105,$B98)","v":0.73125748502994004},{"$f":"TREND(D99:D105,$B$99:$B$105,$B98)","v":0.85908682634730527},{"$f":"TREND(E99:E105,$B$99:$B$105,$B98)","v":1.5795808383233532},{"$f":"TREND(F99:F105,$B$99:$B$105,$B98)","v":2.5455988023952099},null,null,0.375,{"$f":"TREND(J99:J105,$B$99:$B$105,$I98)","v":2.4903143712574849},{"$f":"TREND(K99:K105,$B$99:$B$105,$I98)","v":2.5950598802395213},{"$f":"TREND(L99:L105,$B$99:$B$105,$I98)","v":2.7040419161676645},{"$f":"TREND(M99:M105,$B$99:$B$105,$I98)","v":2.8269910179640716},null,null,0,1,2,4,6,8,null,0,272,112,{"$f":"SUM(X98:Y98)","v":384},828.77122877122883,355,{"$f":"SUM(AA98:AB98)","v":1183.7712287712288}]
[null,0.5,0.73,0.89,1.67,2.6,null,null,0.5,2.48,2.59,2.7,2.82,null,"Temp is less than °F ",2,3,4,5,6,7,null,8.3333333333333329E-2,455,112,567,828.77122877122883,355,{"$f":"SUM(AA99:AB99)","v":1183.7712287712288},null,{"$f":"W99","v":8.3333333333333329E-2},{"$f":"X99/$W99","v":5460},{"$f":"Y99/$W99","v":1344},{"$f":"AA99/$W99","v":9945.254745254746},{"$f":"AB99/$W99","v":4260}]
[null,0.75,0.83,0.97,1.68,2.68,null,null,0.75,2.59,2.7,2.82,2.96,null,0,1,1,1.5,1.5,1.5,1.5,null,0.125,555,135,690,828.77122877122883,355,1183.7712287712288,null,0.125,4440,1080,6630.1698301698307,2840]
[null,1,0.86,1.04,1.8,2.86,null,null,1,2.7,2.82,2.96,3.1,null,40,0.5,0.5,0.5,1,1,1,null,0.16666666666666666,705,135,840,828.77122877122883,355,1183.7712287712288,null,0.16666666666666666,4230,810,4972.627372627373,2130]
[null,1.25,0.91,1.1200000000000001,1.96,3.02,null,null,1.25,2.82,2.96,3.1,3.27,null,60,0,0,0,0,0,0,null,0.25,980,168,1148,828.77122877122883,355,1183.7712287712288,null,0.25,3920,672,3315.0849150849153,1420]
[null,1.5,1.05,1.21,2.0499999999999998,3.14,null,null,1.5,2.82,2.96,3.1,3.27,null,105,1,1,1,1,1.5,1.5,null,0.33333333333333331,1025,168,1193,828.77122877122883,355,1183.7712287712288,null,0.33333333333333331,3075,504,2486.3136863136865,1065]
[null,2,1.1200000000000001,1.31,2.2599999999999998,3.32,null,null,2,2.96,3.1,3.27,3.45,null,140,1.5,1.5,1.5,1.5,1.5,1.5,null,0.5,1175,168,1343,828.77122877122883,355,1183.7712287712288,null,0.5,2350,336,1657.5424575424577,710]
[null,2.5,1.17,1.49,2.42,3.57,null,null,2.5,3.1,3.27,3.45,3.65,null,200,1.5,1.5,1.5,2,2,3.5,null,0.75,1700,168,1868,868.38161838161841,355,1223.3816183816184,null,0.75,2266.6666666666665,224,1157.8421578421578,473.33333333333331]
[null,3,{"$f":"TREND($C$99:$C$105,$B$99:$B$105,B106)","v":1.3235329341317366},1.59,2.54,3.79,null,null,3,{"$f":"TREND($J$99:$J$105,$I$99:$I$105,I106)","v":3.2683832335329344},3.45,3.65,3.88,null,250,2,2,2.5,2.5,3.5,3.5,null,1,1550,224,1774,1465.5844155844156,355,1820.5844155844156,null,1,1550,224,1465.5844155844156,355]
[null,4,{"$f":"TREND($C$99:$C$105,$B$99:$B$105,B107)","v":1.5491616766467065},2.11,2.88,4.42,null,null,4,{"$f":"TREND($J$99:$J$105,$I$99:$I$105,I107)","v":3.5647904191616764},4.1399999999999997,4.43,4.78,null,350,2.5,2.5,2.5,3,3.5,3.5,null,1.5,1825,224,2049,1465.5844155844156,355,1820.5844155844156,null,1.5,1216.6666666666667,149.33333333333334,977.05627705627705,236.66666666666666]
[null,5,1.7747904191616768,2.38,3.23,5.05,null,null,5,3.8611976047904193,4.43,4.78,5.15,null,null,null,null,null,null,null,null,null,2,1900,292,2192,1525,455,{"$f":"SUM(AA108:AB108)","v":1980},null,2,950,146,762.5,227.5]
[null,6,2.0004191616766467,2.52,3.41,5.2,null,null,6,4.1576047904191622,5.15,5.65,6.2,null,null,null,null,null,null,null,null,null,3,2350,375,2725,1675,455,{"$f":"SUM(AA109:AB109)","v":2130},null,3,783.33333333333337,125,558.33333333333337,151.66666666666666]
[null,8,2.4516766467065869,4.12,4.78,6.35,null,null,8,4.7504191616766462,6.2,6.9,7.75,null,null,null,null,null,null,null,null,null,5,2925,395,3320,1975,545,2520,null,5,585,79,395,109]
[null,10,2.9029341317365271,4.37,5.15,7.6,null,null,10,5.3432335329341321,6.9,7.75,8.85,null,null,null,null,null,null,null,null,null,7.5,5800,515,6315,1975,545,2520,null,{"$f":"W111","v":7.5},{"$f":"X111/$W111","v":773.33333333333337},{"$f":"Y111/$W111","v":68.666666666666671},{"$f":"AA111/$W111","v":263.33333333333331},{"$f":"AB111/$W111","v":72.666666666666671}]
[null,12,3.3541916167664669,4.76,5.85,8.5,null,null,12,5.936047904191617,7.75,8.3000000000000007,9.5500000000000007,null,null,null,null,null,null,null,null,null,15,7025,655,7680,3375,820,4195,null,15,{"$f":"X112/$W112","v":468.33333333333331},{"$f":"Y112/$W112","v":43.666666666666664},{"$f":"AA112/$W112","v":225},{"$f":"AB112/$W112","v":54.666666666666664}]
[null,14,3.8054491017964072,5.5,6.7,10.55,null,null,14,6.5288622754491019,7.75,8.85,10.35,null,null,null,null,null,null,null,null,null,20,7250,680,7930,3925,1100,5025,null,20,362.5,34,196.25,55]
[null,16,4.2567065868263469,7,8.75,11.6,null,null,16,7.1216766467065868,8.85,9.5500000000000007,11.3,null,null,null,null,null,null,null,null,null,25,9475,870,10345,4775,1100,5875,null,25,379,34.799999999999997,191,44]
[null,18,4.7079640718562867,7.75,9.85,12.95,null,null,18,7.7144910179640718,8.85,10.35,12.4,null,null,null,null,null,null,null,null,null,40,11900,1000,12900,7650,1375,9025,null,40,297.5,25,191.25,34.375]
[null,20,5.1592215568862274,8.65,10.050000000000001,14.65,null,null,20,8.3073053892215576,10.35,11.3,13.8,null,null,null,null,null,null,null,null,null,50,16200,1250,17450,8375,1600,9975,null,50,324,25,167.5,32]
[null,24,6.061736526946107,10.55,12.3,15.75,null,null,24,9.4929341317365274,10.35,12.4,15.5,null,null,null,null,null,null,null,null,null,75,18000,1475,19475,11700,1800,13500,null,75,240,19.666666666666668,156,24]
[null,26,6.5129940119760477,{"$f":"TREND($D$99:$D$117,$B$99:$B$117,B118)","v":10.915311709378317},{"$f":"TREND($E$99:$E$117,$B$99:$B$117,B118)","v":12.798205309639993},{"$f":"TREND($F$99:$F$117,$B$99:$B$117,B118)","v":17.347876344265469},null,null,26,10.085748502994011,{"$f":"TREND($J$99:$J$117,$I$99:$I$117,I118)","v":10.085748502994011},{"$f":"TREND($L$99:$L$117,$I$99:$I$117,I118)","v":13.946338524595635},{"$f":"TREND($M$99:$M$117,$I$99:$I$117,I118)","v":17.041626936710209},null,null,null,null,null,null,null,null,null,100,22300,1650,23950,12900,1800,14700,null,100,223,16.5,129,18]
[null,30,7.4155089820359281,{"$f":"TREND($D$99:$D$117,$B$99:$B$117,B119)","v":12.518341288225201},{"$f":"TREND($E$99:$E$117,$B$99:$B$117,B119)","v":14.584398643551864},{"$f":"TREND($F$99:$F$117,$B$99:$B$117,B119)","v":19.69341655374058},null,null,30,11.271377245508981,{"$f":"TREND($J$99:$J$117,$I$99:$I$117,I119)","v":11.271377245508981},{"$f":"TREND($L$99:$L$117,$I$99:$I$117,I119)","v":15.684166471966515},{"$f":"TREND($M$99:$M$117,$I$99:$I$117,I119)","v":19.26816872826312},null,null,null,null,null,null,null,null,null,150,33100,2150,35250,20500,2125,22625,null,150,220.66666666666666,14.333333333333334,136.66666666666666,14.166666666666666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,{"$f":"BHP_TOTAL*AF120","v":{"$error":"#DIV/0!"}},{"$f":"BHP_TOTAL*AG120","v":{"$error":"#DIV/0!"}},{"$f":"SUM(X120:Y120)","v":{"$error":"#DIV/0!"}},{"$f":"BHP_TOTAL*AH120","v":{"$error":"#DIV/0!"}},{"$f":"BHP_TOTAL*10","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA120:AB120)","v":{"$error":"#DIV/0!"}},null,200,{"$f":"AF119","v":220.66666666666666},{"$f":"AG119","v":14.333333333333334},{"$f":"AH119","v":136.66666666666666},{"$f":"AI119","v":14.166666666666666}]
[]
[]
[null,"Noise/Erosion Sensitivity"]
[]
[null,"Noise Sensitivity ",null,null,null,null,"Noise sensitivity eqn",null,null,null,null,"Erosion Max Velocity"]
[null,"Pipe OD","Pipe ID","Max fps",null,null,"Max V for size:",3,6,"fps",null,"Hours/yr operation","Max v [fps]"]
[null,{"$f":"U11","v":0.5},{"$f":"V11","v":0.54500000000000004},{"$f":"10^$H$131*10^$H$130^(LOG(C127))","v":2.5423540009569647},null,null,"Max V for size:",10,11,"fps",null,0,15]
[null,{"$f":"U12","v":0.75},{"$f":"V12","v":0.78500000000000003},{"$f":"10^$H$131*10^$H$130^(LOG(C128))","v":3.0550531145763387},null,null,null,null,null,null,null,2000,14]
[null,1,{"$f":"V13","v":1.0249999999999999},3.4941790244332749,null,null,"log(fps) =m*  log(Pipe OD) + b",null,null,null,null,3000,13]
[null,1.25,{"$f":"V14","v":1.2649999999999999},3.8845737462319319,null,null,"m",{"$f":"(LOG($I$127)-LOG($I$126))/(LOG(H127)-LOG(H126))","v":0.50344642453088528},null,null,null,4000,12]
[null,1.5,{"$f":"V15","v":1.5049999999999999},4.2396145772718246,null,null,"b",{"$f":"LOG($I$127)-$H$130*LOG(H127)","v":0.53794626062733986},null,null,null,6000,10]
[null,2,{"$f":"V16","v":1.9850000000000001},4.8736319112081601]
[null,2.5,{"$f":"W17","v":2.4689999999999999},5.4395077506101295,null,null,"fps = 10^0.5379*10^(0.5034*log(Pipe ID))"]
[null,3,{"$f":"W18","v":3.0680000000000001},6.0680876949042064]
[null,4,4.0259999999999998,6.9577336221905766]
[null,5,5.0469999999999997,7.7962519237302192]
[null,6,6.0650000000000004,8.5518412531975407]
[null,8,7.9809999999999999,9.819373700167473]
[null,10,10.02,11.011070327081258]
[null,12,12,12.05747028698295]
[null,14,13.25,12.674237239470923]
[null,{"$f":"U26","v":16},15.25,13.603768496849828]
[null,18,17.25,14.474491335184707]
[null,20,19.25,15.29636792340081]
[null,24,23.25,16.821588811716804]
[null,26,25.25,17.535160279224446]
[null,30,{"$f":"W31","v":29.25},18.882612811225702]
[]
[]
[null,"System and Location Defaults"]
[]
[null,"Default Water Temperatures"]
[null,"CHW",50,"°F"]
[null,"HW",160,"°F"]
[null,"CW",80,"°F"]
[]
[null,"Variable Flow/Variable Speed Diversity Factor"]
[null,"CFCS","VFCS","VFVSFSP","VFVSRSP"]
[null,1,0.6,0.3,0.2]
[null,"CFCS","Contstant Flow/ Constant Speed"]
[null,"VFCS","Variable Flow/ Constant Speed"]
[null,"VFVSFSP","Variable Flow/ Variable Speed with Fixed Set Point"]
[null,"VFVSRSP","Variable Flow/ Variable Speed with Reset Set Point"]
[]
[null,"Market Lookup"]
[null,null,"Materials","Labor"]
[null,"Oakland, CA",110.2,127.3]
[null,"Los Angeles, CA",103.3,115.1]
[null,"Fresno, CA",103.9,112.3]
[null,"San Francisco, CA",112.4,137.5]
[null,"San Jose, CA",107,130.4]
[null,"Riverside, CA",102.1,112.5]
[null,"Sacramento, CA",106,113.6]
[null,"Average National",100,100]
[null,"ADD MARKET"]
[]
[]
[null,"Efficiencies"]
[]
[null,"Pump",null,null,"Current value, based on input system gpm"]
[null,"GPM",null,null,"Pump",{"$f":"VLOOKUP('Piping Circuit'!$B$3,$B$183:$C$191,2)","v":0.54849422322219354}]
[null,"Greater than","Efficiency"]
[null,0,{"$f":"($G$188*LN(B184)+$G$189)*0.9","v":0.54849422322219354}]
[null,60,{"$f":"($G$188*LN(B185)+$G$189)*0.9","v":0.57548114092575087}]
[null,100,0.66050774583964444,null,null,"Pump Efficiency eqn"]
[null,500,0.69712671138862625]
[null,1000,0.71854743304998059,null,null,"eff = m * ln(gpm) + b"]
[null,1500,0.73374567693760828,null,null,"m",5.8700000000000002E-2]
[null,2000,0.74553435075353791,null,null,"b",0.36909999999999998]
[null,2500,0.75516639859896251]
[null,3000,0.7633101790142367]
[null,3500,0.7703646424865902]
[null,4000,0.77658712026031684]
[null,4500,0.78215331630251994]
[null,5000,0.78718855310158231]
[null,5500]
[]
[null,"Motor (premium)",null,null,"Current value, based on calculated HP"]
[null,"HP",null,null,"Motor",{"$f":"VLOOKUP(BHP_TOTAL,B201:C213,2)","v":{"$error":"#DIV/0!"}}]
[null,"Greater than","Efficiency"]
[null,0,0.89500000000000002]
[null,5,0.91]
[null,10,0.92400000000000004]
[null,15,0.92400000000000004]
[null,20,0.93600000000000005]
[null,30,0.94099999999999995]
[null,40,0.94099999999999995]
[null,60,0.95]
[null,75,0.95399999999999996]
[null,100,0.95399999999999996]
[null,125,0.95799999999999996]
[null,150,0.95799999999999996]
[null,200,0.95799999999999996]
[]
[null,"Chiller",0.6,"kW/ton"]
[null,"Boiler",0.75]
[null,"VS Drive",0.97]

{"sheet":"Versions","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Version","Update","Requested by","Date Completed"]
[1.1000000000000001,"Added cost escalation feature to bring 2002 Means costs to present."]
[1.1000000000000001,"Changed display of system head, with and without safety factor."]
[1.2,"Delete the two pull downs that ask if escalation and inflation apply.  If people want no inflation they can enter a zero.","Steve","2008-05-20"]
[1.2,"We need to figure out some way of detecting whether the Optimize button needs to be repressed.  Perhaps after you press the button, the button grays out and the LCC cost gets copied to a hidden cell.  Then if the LCC in cell B18 ever differs from the hidden cell value, you know that an input was changed so you can un-gray out the button, indicating that it must be repressed. ","Steve","2008-05-21"]
[null,"Add buttons for 189.1 and 90.1 compliance","Steve"]
[1.4,"Updated to Excel 2007"]
[1.5,"Unlocked input cells on \"System Assumptions\"","Steve","2010-05-13"]
[null,"Remove \"optimize\" button de-activation macro so that the undo command works","Steve","2010-05-13"]
[1.6,"Updated changeover from ball to butterfly valve from 2.5\" to 3\". Now all pipes 3\" and larger will have butterfly valves, all pipes 2.5\" and smaller will have ball valves. Also added a pull-down menu to the \"Constants\" sheet to change this in the future.\n\nCurrent year updated to 2011.","Steve","2011-01-07"]