{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Home","Sizing Info","Load","Length","Pressure","Pressure Losses","EquivLength","Labor&Material","Fittings","Prices","Heat Loss","Cost Compare","scratch","wsfuGPM"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":47,"comments":8,"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":"Home","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This calculator utilizes Visual Basic for Applications (VBA)"]
[null,"For functionality, click the \"Options...\" button and select \"Enable this content\""]
[null,"Press \"Size Riser Piping\" Button at right and follow instructions on each tab to determine the size of piping needed."]
[null,"Once proper sizes are selected for each applicable section on \"Pressure Losses\" tab, return to \"Home\" tab."]
[]
[]
[]
[null,"Press \"Size Circulator\" button at right and follow instructions to determine circulator and circulation flow rate."]
[]
[]
[]
[]
[null,"Press \"Cost Comparisons\" button and follow instructions on each tab to see how much you will save by using SmartLoop"]

{"sheet":"Sizing Info","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,14,11,15],[12,14,13,15]]}
[]
[null,"This section will aid in the process of sizing water distribution piping using the Viega SmartLoop recirculation system."]
[null,null,"To properly size any portion of a building's piping system, the entire building must be considered."]
[null,null,"For accurate results please read the instructions on each page carefully and fill in all requested information."]
[null,null,null,"The method used is adapted from the method described in appendix E of The 2009 International Plumbing Code (IPC)."]
[null,null,null,null,"This method should also satisfy Uniform Plumbing Code requirements, but verification from local code authorities is required."]
[null,null,null,"This method finds all the pressure losses in the piping system and ensures that adequate pressure remains at the most remote fitting."]
[]
[null,"The \"Load\" tab can accommodate up to three different floor configurations, but matching floors must be consecutive. "]
[null,1,"Enter a name in upper yellow cell for each \"Type of Floor\" that will be used, starting from the left."]
[null,2,"Enter number of floors that will match each configuration in lowest yellow cells."]
[null,3,"Enter number of fixtures found on ONE floor of each type used, in yellow cells of the table."]
[null,null,"    (For fixtures not listed estimate the closest equivalent fixture type.)"]
[null,4,"Load totals per floor are displayed in blue at the bottom of each type. Riser total is in blue at top."]
[null,"Input lengths of piping sections on the \"Length\" tab. These lengths will be used to find pressure losses from pipe friction."]
[null,1,"Enter floor to floor height (between piping on each floor)"]
[null,2,"Enter height difference between water main and first floor"]
[null,3,"Enter horizontal distance of piping between water main and the point where system splits into hot and cold."]
[null,5,"For each type of floor, enter the distance between riser and most remote fitting on that type of floor."]
[null,"The \"Pressure\" tab collects pressure values to find the remaining pressure available to overcome pipe friction."]
[null,1,"Enter pressure values in yellow cells. "]
[null,2,"Enter minimum operating pressure of most remote HOT water fixture."]
[null,3,"To find \"Pressure loss from tap into main\", the size of the tap and the maximum flow rate are needed."]
[null,4,"Instructions on how to find flow rate using this and another tab are listed."]
[null,"\"Pressure Losses\""]
[null,1,"Ensure \"Load\" and \"Length\" tabs are filled out correctly."]
[null,2,"Click \"Fill Tables\" button. This will display vertical demand loads and vertical lengths in table."]
[null,3,"Under \"Cold section\", select whether the majority of the cold water system uses flush tanks or flush valves."]
[null,5,"Choose a trial pipe size for each line in table below that has a load demand value."]
[null,6,"Return to \"Pressure\" tab and enter \"Pressure loss from tap into main\" value using Section Flow in blue near top of table."]
[null,7,"Adjust trial pipe size until velocities are less than 5 feet per second."]
[null,8,"Enter equivalent length of the fittings found between main and most remote fitting for each section of piping."]
[null,9,"Adjust pipe size until excess pressure (lower right of each table) is a small positive number."]
[null,"The \"Fittings\" tab contains a stand alone calculator to find equivalent lengths of a combination of fittings."]
[null,1,"Select pipe size in upper yellow cell."]
[null,2,"Press button to display equivalent length of fittings for the pipe size shown."]
[null,3,"Enter quantity of each type of fitting used."]
[null,4,"Total equivalent length of fittings shown will display in blue at the bottom."]
[null,null,"*","Pressure losses from pipe friction calculated using 110% of value from Hazen-Williams equation with C = 150 for both copper and PEX"]
[null,null,"*","Type L copper tube is used for calculations involving actual tube size"]
[null,null,"*","Velocity and friction loss calculations for hot vertical section use experimentally determined average hydraulic diameter of Type L copper with 3/8\" PEX inline recirculation"]

{"sheet":"Load","index":2,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[[12,19,12,21],[10,15,11,17],[10,19,11,21],[42,8,42,9],[10,11,11,13],[10,7,12,9],[4,11,4,13],[12,11,12,13],[13,4,13,6],[12,15,12,17],[9,1,9,9],[8,1,8,9],[12,1,12,3],[10,4,10,6],[10,1,11,1],[10,2,11,2],[10,3,11,3]]}
[]
["This Table can accommodate up to three different floor configurations, but matching floors must be consecutive. ",null,null,null,null,null,null,null,null,null,"For example, floors 1 and 2 of Type A, 3 - 10 of Type B, and 11 and 12 of Type C"]
[1,"Enter a name in uppermost yellow cell (E12:G12) for each \"Type of Floor\" that will be used, starting from the left.",null,null,null,null,null,null,null,null,"If all floors are the same, only enter one type of floor name. "]
[2,"Enter number of floors that will match each configuration in lowest yellow cells (E13:G13)."]
[3,"Enter number of fixtures found on ONE floor of each type used, in remaining yellow cells (E15:G41) of the table below.",null,null,null,null,null,null,null,null,null,"Riser Totals:",null,null,null,null,null,null,"Headings"]
[4,"Load totals per floor are displayed in blue (L43:V43) at the bottom of each type. Riser total is in blue (L8:N8) to the right",null,null,null,null,null,null,null,null,null,"Cold","Hot","Total",null,null,null,null,"User Input Cells"]
[null,"   * Total load only applies for section of piping between water main and hot/cold Tee, where hot and cold loads split.",null,null,null,null,null,null,null,null,"                                   ","(wsfu)","(wsfu)","(wsfu)"," ",null,null,null,"Calculated Values, Constants"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"($E13*cold)+($F13*P43)+($G13*T43)","v":532.25},{"$f":"($E13*cold)+($F13*Q43)+($G13*U43)","v":122.75},{"$f":"($E13*cold)+($F13*R43)+($G13*V43)","v":553.84999999999991},null,null,null,null,"Important Calculated Values"]
[null,"Load Values Assigned to Fixtures"]
[null,"International Plumbing Code Table 103.3(2)"]
[null,"Type of Fixture","Occupancy","Control Type","Type of Floor",null,null,"Load Values in Water Supply Fixture Units (wsfu)",null,null,null,"Load Totals (wsfu)",null,null,null,"Load Totals (wsfu)",null,null,null,"Load Totals (wsfu)"]
[null,null,null,null,"Lobby","one"]
[null,"Number of floors floors by type:",null,null,1,9,null,null,null,null,null,{"$f":"E12","v":"Lobby"},null,null,null,{"$f":"F12","v":"one"},null,null,null,{"$f":"G12","v":0}]
[null,null,null,null,"Number of Fixtures per Floor",null,null,"Cold","Hot","Total",null,"Cold","Hot","Total",null,"Cold","Hot","Total",null,"Cold","Hot","Total"]
[null,"Bathroom Group","Private","Flush Tank",null,null,null,2.7,1.5,3.6,null,{"$f":"E15*H15","v":0},{"$f":"E15*I15","v":0},{"$f":"J15*E15","v":0},null,{"$f":"$F15*H15","v":0},{"$f":"$F15*I15","v":0},{"$f":"$F15*J15","v":0},null,{"$f":"$G15*H15","v":0},{"$f":"$G15*I15","v":0},{"$f":"$G15*J15","v":0}]
[null,"Bathroom Group","Private","Flush Valve",null,null,null,6,3,8,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Bathtub","Private","Faucet",null,null,null,1,1,1.4,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Bathtub","Public","Faucet",null,null,null,3,3,4,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Bidet","Private","Faucet",null,null,null,1.5,1.5,2,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Combination","Private","Faucet",null,null,null,2.25,2.25,3,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Dishwasher","Private","Auto",1,null,null,null,1.4,1.4,null,0,1.4,1.4,null,0,0,0,null,0,0,0]
[null,"Drinking Fountain","Offices","3/8\" Valve",2,2,null,0.25,null,0.25,null,0.5,0,0.5,null,0.5,0,0.5,null,0,0,0]
[null,"Kitchen Sink","Private","Faucet",null,1,null,1,1,1.4,null,0,0,0,null,1,1,1.4,null,0,0,0]
[null,"Kitchen Sink","Restaurant","Faucet",2,null,null,3,3,4,null,6,6,8,null,0,0,0,null,0,0,0]
[null,"Laundry Trays (1-3)","Private","Faucet",null,null,null,1,1,1.4,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Lavatory","Private ","Faucet",null,null,null,0.5,1,0.7,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Lavatory","Public ","Faucet",4,4,null,1.5,1.5,2,null,6,6,8,null,6,6,8,null,0,0,0]
[null,"Service Sink","Offices","Faucet",1,null,null,2.25,2.25,3,null,2.25,2.25,3,null,0,0,0,null,0,0,0]
[null,"Shower Head","Public","Mix Valve",null,null,null,3,3,4,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Shower Head","Private","Mix Valve",null,null,null,1,1,1.4,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Urinal","Public","1\" Flush",null,null,null,10,null,10,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Urinal","Public","3/4\" Flush",1,1,null,5,null,5,null,5,0,5,null,5,0,5,null,0,0,0]
[null,"Urinal","Public","Flush Tank",null,null,null,3,null,3,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Washing Machine (8 lb)","Private","Auto",null,null,null,1,1,1.4,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Washing Machine (8 lb)","Public","Auto",null,null,null,2.25,2.25,3,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Washing Machine (15 lb)","Public","Auto",null,null,null,3,3,4,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Water Closet","Private","Flush Valve",null,null,null,6,null,6,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Water Closet","Private","Flush Tank",null,null,null,2.2000000000000002,null,2.2000000000000002,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Water Closet","Public","Flush Valve",4,4,null,10,null,10,null,40,0,40,null,40,0,40,null,0,0,0]
[null,"Water Closet","Public","Flush Tank",null,null,null,5,null,5,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Water Closet","Either","Flushometer Tank",null,null,null,2,null,2,null,0,0,0,null,0,0,0,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"(wsfu)","(wsfu)","(wsfu)",null,"(wsfu)","(wsfu)","(wsfu)",null,"(wsfu)","(wsfu)","(wsfu)"]
[null,null,null,null,null,null,null,null,"Totals per Floor:",null,null,{"$f":"SUM(L15:L41)","v":59.75},{"$f":"SUM(M15:M41)","v":15.65},{"$f":"SUM(N15:N41)","v":65.900000000000006},null,{"$f":"SUM(P15:P41)","v":52.5},{"$f":"SUM(Q15:Q41)","v":7},{"$f":"SUM(R15:R41)","v":54.9},null,{"$f":"SUM(T15:T41)","v":0},{"$f":"SUM(U15:U41)","v":0},{"$f":"SUM(V15:V41)","v":0}]

{"sheet":"Length","index":3,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[18,10,18,12],[17,1,18,3],[17,4,18,4],[1,16,2,17],[3,16,4,17],[13,1,13,4],[14,8,14,9],[15,1,15,3],[16,1,16,3],[15,8,15,9],[26,1,27,3],[19,4,20,4],[26,4,27,4],[21,1,22,4],[23,1,23,3],[24,1,24,3],[25,1,25,3],[19,1,20,3]]}
[]
[1,"Enter floor to floor height (in cell E17) (between piping on each floor)"]
[2,"Enter height difference between water main and first floor (in cell E18)"]
[null,"   * Since water mains are usually buried less than one story below ground, the height difference between the water main"]
[null,"     and the first floor piping is usually different from floor to floor height. "]
[3,"Enter horizontal distance of piping between water main and the point where system splits into hot and cold (in cell E20)."]
[null,"   * This section of piping will carry the total load of the building. The pressure loss due to pipe friction in this section must be applied "]
[null,"     to both hot and cold sides of the piping system."]
[4,"For each type of floor, enter the horizontal distance between riser and most remote fitting on that type of floor (in cells E24:E26)."]
[null,"   * only the highest floor (lowest grey cell) is included in developed length calculations"]
[null,"   * The height of the riser and pressure loss due to the height of that column of water (Static head) are displayed for reference only."]
[]
[]
[null,"System Length Values"]
[null,null,null,null,null,null,null,null,"Height of riser",null,{"$f":"(E16-1)*E17+E18","v":134},"ft"]
[null,"Number of floors ",null,null,{"$f":"SUM(Load!E13:G13)","v":10},"floors",null,null,"Static head",null,{"$f":"K15*0.433","v":58.021999999999998},"psi"]
[null,"Floor to floor height",null,null,14,"ft"]
[null,"height difference between water main and first floor",null,null,8]
[null,null,null,null,null,"ft"]
[null,"Horizontal distance between main and hot/cold Tee",null,null,54,null,null,null,null,null,"Headings"]
[null,null,null,null,null,"ft",null,null,null,null,"User Input Cells"]
[null,"Riser to most remote fixture on each type of floor",null,null,null,null,null,null,null,null,"Calculated Values, Constants"]
[]
[null,{"$f":"Load!E12","v":"Lobby"},null,null,40,"ft"]
[null,{"$f":"Load!F12","v":"one"},null,null,40,"ft"]
[null,{"$f":"Load!G12","v":0},null,null,null,"ft"]
[null,"Horizontal distance of highest floor",null,null,{"$f":"IF(E26=0,IF(E25=0,E24,E25),E26)","v":40}]
[null,null,null,null,null,"ft"]

{"sheet":"Pressure","index":4,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[28,9,28,15],[27,8,27,15],[19,1,19,3],[12,1,12,4],[13,1,13,4],[26,8,26,15],[25,1,25,3],[26,1,26,3],[12,6,12,8],[14,1,14,3],[29,1,29,4],[33,4,34,4],[16,1,16,3],[24,1,24,3],[15,1,15,3],[23,1,23,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[18,1,18,3],[17,1,17,3],[45,1,45,3],[46,1,46,3],[42,1,43,3],[30,1,30,4],[42,4,43,4],[41,1,41,3],[44,1,44,3],[35,1,35,3],[31,1,32,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[33,1,34,3],[36,1,36,3],[37,1,37,3]]}
[]
[null,1,"Enter pressure values in yellow cells (E15 through E24) below. "]
[null,null,"   * The list to the right of the upper table tells where to find pressure values"]
[null,2,"Minimum Pressure at most remote fitting (E18) should be for the most remote HOT water fitting."]
[null,3,"To find \"Pressure loss from tap into main\" (E20), the size of the tap and the maximum flow rate are needed."]
[null,4,"The flow rate can be found as follows:"]
[null,null,1,"On \"Pressure Losses\" tab, complete steps 1 - 6"]
[null,null,2,"Return to this tab and \"Loss of Pressure Through Tap\" table should have a row and column highlighted."]
[null,null,3,"The column that is highlighted is the recommended tap size."]
[null,null,4,"The row that is highlighted represents the required flow of the building."]
[null,null,"   *The pressure values below are used in conjunction with values on the Pressure Losses tab to ensure adequate pressure at the most remote fitting"]
[]
[null,"System Pressure Values",null,null,null,null,"Where to find Information *"]
[]
[null,"Minimum pressure at main",null,null,65,"psi","Water supply utility **",null,null,null,null,"note: **","if pressure is measured downstream of meter, "]
[null,"Pressure added by booster pump (if applicable)",null,null,18,"psi","Pump manufacturer (leave blank if a booster pump is not used)",null,null,null,null,null,"enter that pressure for pressure at main (E15) "]
[null,"Pressure at booster pump outlet",null,null,{"$f":"E16+E15","v":83},"psi","Calculated  ",null,null,null,null,null,"and leave meter loss (E19) and loss from tap"]
[null,"Minimum pressure at most remote HOT fixture",null,null,8,"psi","Fixture manufacturer or IPC Table 604.3 (shown below left)",null,null,null,null,null,"into main (E20) blank"]
[null,"Meter loss (at max flow)",null,null,5,"psi","Meter manufacturer **"]
[null,"Pressure loss from tap into main",null,null,1.61,"psi","2009 IPC, table E103.3(4) (shown below right) **"]
[null,"Special fixture - backflow preventer",null,null,4,"psi","Item manufacturer"]
[null,"Special fixture - filter",null,null,null,"psi","Item manufacturer",null,null,null,null,"Headings"]
[null,"Special fixture - other",null,null,null,"psi","Item manufacturer",null,null,null,null,"User Input Cells"]
[null,"Special fixture - other",null,null,null,"psi","Item manufacturer",null,null,null,{"$f":"VLOOKUP('Pressure Losses'!G20+10,Pressure!I31:I50,1)","v":100},"Calculated Values, Constants"]
[null,"Static head loss",null,null,{"$f":"Length!K16","v":58.021999999999998},"psi","Calculated from lengths on \"Length\" sheet",null,null,null,{"$f":"HLOOKUP('Pressure Losses'!I20,Pressure!J30:P30,1)","v":2},"Important Values"]
[null,"Total HOT losses and requirements",null,null,{"$f":"SUM(E18:E25)","v":76.632000000000005},"psi"]
[null,"Pressure available to overcome pipe friction HOT",null,null,{"$f":"E15+E16-E26","v":6.367999999999995},"psi",null,null,"Loss of Pressure Through Tap into Water Main"]
[null,null,null,null,null,null,null,null,"International Plumbing Code Table E103.3(4)"]
[null,null,null,null,null,null,null,null,"Flow","Size of Tap"]
[null,"Minimum Pressure for Common Fixtures",null,null,null,null,null,null,"(GPM)",0.625,0.75,1,1.25,1.5,2,3]
[null,"Adapted from International Plumbing Code Table 604.3",null,null,null,null,null,null,10,1.35,0.64,0.18,0.08]
[null,"Fixture Type",null,null,"min pressure",null,null,null,20,5.38,2.54,0.77,0.31,0.14000000000000001]
[null,null,null,null,"(psi)",null,null,null,30,12.1,5.72,1.62,0.69,0.33,0.1]
[null,"Bathtub with balanced pressure and/or thermostatic mixing valve",null,null,20,null,null,null,40,null,10.199999999999999,3.07,1.23,0.57999999999999996,0.18]
[null,null,null,null,null,null,null,null,50,null,15.9,4.49,1.92,0.91,0.28000000000000003]
[null,"Bidet, thermostatic mixing valve",null,null,20,null,null,null,60,null,null,6.46,2.76,1.31,0.4]
[null,"Combination fixture",null,null,8,null,null,null,70,null,null,8.7899999999999991,3.76,1.78,0.55000000000000004,0.1]
[null,"Dishwasher, residential",null,null,8,null,null,null,80,null,null,11.5,4.9000000000000004,2.3199999999999998,0.72,0.13]
[null,"Drinking fountain",null,null,8,null,null,null,90,null,null,14.5,6.21,2.94,0.91,0.16]
[null,"Laundry tray",null,null,8,null,null,null,100,null,null,17.940000000000001,7.67,3.63,1.1200000000000001,0.21]
[null,"Lavatory",null,null,8,null,null,null,120,null,null,25.8,11,5.23,1.61,0.3]
[null,"Shower",null,null,8,null,null,null,140,null,null,35.200000000000003,15,7.12,2.2000000000000002,0.41]
[null,"Shower with balanced pressure and/or thermostatic mixing valve",null,null,20,null,null,null,150,null,null,null,17.2,8.16,2.52,0.47]
[null,null,null,null,null,null,null,null,160,null,null,null,19.600000000000001,9.3000000000000007,2.92,0.54]
[null,"Sillcock, hose bib",null,null,8,null,null,null,180,null,null,null,24.8,11.8,3.62,0.68]
[null,"Sink, residential",null,null,8,null,null,null,200,null,null,null,30.7,14.5,4.4800000000000004,0.84]
[null,"Sink, service",null,null,8,null,null,null,225,null,null,null,38.799999999999997,18.399999999999999,5.6,1.06]
[null,null,null,null,null,null,null,null,250,null,null,null,47.9,22.7,7,1.31]
[null,null,null,null,null,null,null,null,275,null,null,null,null,27.4,7.7,1.59]
[null,null,null,null,null,null,null,null,300,null,null,null,null,32.6,10.1,1.88]

{"sheet":"Pressure Losses","index":5,"n_rows":46,"n_cols":26,"rows_kept":46,"cut":false,"hidden":false,"merged":[[41,2,43,2],[20,2,40,2],[15,5,17,5],[15,6,17,6],[15,2,15,3],[19,3,19,4],[18,3,18,4],[45,12,46,12],[45,13,46,13],[45,14,46,14],[15,9,17,9],[15,7,17,7],[15,8,17,8],[15,14,17,14],[15,12,17,12],[15,13,17,13],[15,11,17,11],[15,10,17,10]]}
[]
[null,1,"Ensure \"Load\" and \"Length\" tabs are filled out correctly.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Headings"]
[null,null,"*","main to hot/cold Tee (Row 20) is a single section of pipe. It will change depending on flush type because it provides water to both hot and cold sections.",null,null,null,null,null,null,null,null,null,null,null,null,null,"User Input Cells"]
[null,2,"Click \"Fill Tables\" button. This will display vertical demand loads and vertical lengths in table below. (Click again if any \"Loads\" are changed)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated Values, Constants",null,null,null,null,0,0,0,"Flush Tanks"]
[null,3,"Under \"Cold section\", select whether the majority of the cold water system uses flush tanks or flush valves.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Important Values",null,null,null,null,0.5,0.54500000000000004,0,"Flush Valves"]
[null,null,"*"," flush type is necessary to find pressure drop in first section (Row 20), which supplies hot and cold systems.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,0.78500000000000003,0]
[null,5,"Choose a trial pipe size (Column I) for each line in table below that has a value in the \"Demand Load\" column.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.0149999999999999,0.89477650840866396]
[null,6,"Return to \"Pressure\" tab and enter \"Pressure loss from tap into main\" value using Section Flow (G20) in blue near top of table.",null,null,null,null,null,null,null,null,null,null,null,null,null,"velocity:",null,null,null,null,null,1.25,1.2649999999999999,1.1619918244118586]
[null,7,"Adjust trial pipe size  (Column I) until velocities (Column Q) are less than 5 feet per second.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 5 ft/sec",null,null,null,null,1.5,1.5049999999999999,1.4195157625049464]
[null,8,"Enter equivalent length of the fittings found between main and most remote fitting for each section of piping (Column J).",null,null,null,null,null,null,null,null,null,null,null,null,null,null," > 5 ft/sec1 (hot)",null,null,null,null,2,1.9850000000000001,1.9209958354978283]
[null,null,"*","Equivalent lengths can be found by using the table on the Fittings tab, in plumbing codes, or from fitting manufacturers.",null,null,null,null,null,null,null,null,null,null,null,null,null," > 8 ft/sec2 (cold)",null,null,null,null,2.5,2.4649999999999999,2.4137574443178829]
[null,9,"Adjust pipe size until excess pressure found in lower right of table (O46) is a small positive number.",null,null,null,null,null,null,null,null,null,null,"1 5 ft/sec is maximum velocity of hot water in copper tube allowed by UPC",null,null,null,null,null,null,null,null,3,2.9449999999999998,2.9022448208240461]
[null,null,"*","If pipe size is changed, equivalent length of fittings is no longer accurate and should be updated.",null,null,null,null,null,null,null,null,null,"2 8 ft/sec is maximum velocity allowed in copper tube by UPC or recommended by IPC",null,null,null,null,null,null,null,null,4,3.4249999999999998,3.8728574722031794]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9049999999999998]
[]
[null,null,"Cold section",null,null,"Demand Load","Section Flow","length of section","Trial Pipe size","Equiv. Length of fittings","Total Length","Total Length /100","Friction loss per 100ft","Total friction loss","Excess Pressure","actual"]
[null,null,"Primarily:","Flush Tanks",null,null,null,null,null,null,null,null,null,null,null,"tube"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID","velocity"]
[null,null,null,"Hot section",null,"wsfu","(GPM)","(ft)","(in)","(ft)","(ft)","(100ft)","(psi/100ft)","(psi)","(psi)",null,"(ft/sec)"]
[null,null,null,"main to hot/cold Tee",null,{"$f":"Ttot","v":553.84999999999991},{"$f":"VLOOKUP(F20,wsfuGPM!$C$6:$E$58,IF('Pressure Losses'!D17=\"Flush Tanks\",2,3))","v":105},{"$f":"Length!$E$20","v":54},2.5,12.5,{"$f":"J20+H20","v":66.5},{"$f":"K20/100","v":0.66500000000000004},{"$f":"0.434*0.2083*POWER(G20,1.852)*POWER(100/150,1.85)/POWER((P20+0.000001),4.8655)","v":2.9326933406751077},{"$f":"IFERROR(K20*4.52*POWER(G20,1.85)/POWER(150,1.85)/POWER(VLOOKUP(I20,$W$7:$Y$13,2,0)+0.0000001,4.8655),0)","v":1.9275521049138293},null,{"$f":"VLOOKUP(I20,$W$4:$X$14,2)","v":2.4649999999999999},{"$f":"0.4085*G20/(P20+0.000001)^2","v":7.0590646657758942}]
[null,null,"Vertical","riser up to 1st floor",null,78.650001525878906,{"$f":"IF(F21=0,0,VLOOKUP(F21,wsfuGPM!$C$6:$D$58,2))","v":32},{"$f":"Length!$E$18","v":8},2,9,{"$f":"J21+H21","v":17},{"$f":"K21/100","v":0.17},{"$f":"IFERROR(N21*100/K21,0)","v":1.0824283106069135},{"$f":"IFERROR(K21*4.52*POWER(G21,1.85)/POWER(150,1.85)/POWER(VLOOKUP(I21,$W$7:$Y$13,3,0)+0.0000001,4.8655),0)","v":0.1840128128031753},null,{"$f":"VLOOKUP(I21,$W$4:$Y$14,3)","v":1.9209958354978283},{"$f":"0.4085*G21/(P21+0.000001)^2","v":3.5423277416425232}]
[null,null,null,"riser between 1-2",null,63,{"$f":"IF(F22=0,0,VLOOKUP(F22,wsfuGPM!$C$6:$D$58,2))","v":29.1},14,2,0.5,{"$f":"J22+H22","v":14.5},0.14499999999999999,{"$f":"IFERROR(N22*100/K22,0)","v":0.90797462662488082},{"$f":"IFERROR(K22*4.52*POWER(G22,1.85)/POWER(150,1.85)/POWER(VLOOKUP(I22,$W$7:$Y$13,3,0)+0.0000001,4.8655),0)","v":0.13165632086060772},null,{"$f":"VLOOKUP(I22,$W$4:$Y$14,3)","v":1.9209958354978283},{"$f":"0.4085*G22/(P22+0.000001)^2","v":3.2213042900561697}]
[null,null,null,"riser between 2-3",null,56,{"$f":"IF(F23=0,0,VLOOKUP(F23,wsfuGPM!$C$6:$D$58,2))","v":27.7},14,2,0.5,{"$f":"J23+H23","v":14.5},0.14499999999999999,0.82881815476381748,0.12017863244075354,null,{"$f":"VLOOKUP(I23,$W$4:$Y$14,3)","v":1.9209958354978283},{"$f":"0.4085*G23/(P23+0.000001)^2","v":3.0663274513593088}]
[null,null,null,"riser between 3-4",null,49,{"$f":"IF(F24=0,0,VLOOKUP(F24,wsfuGPM!$C$6:$D$58,2))","v":26.3},14,2,0.5,{"$f":"J24+H24","v":14.5},0.14499999999999999,0.75299105548752587,0.10918370304569125,null,{"$f":"VLOOKUP(I24,$W$4:$Y$14,3)","v":1.9209958354978283},{"$f":"0.4085*G24/(P24+0.000001)^2","v":2.9113506126624489}]
[null,null,null,"riser between 4-5",null,42,{"$f":"IF(F25=0,0,VLOOKUP(F25,wsfuGPM!$C$6:$D$58,2))","v":24.9},14,2,0.5,{"$f":"J25+H25","v":14.5},0.14499999999999999,0.68051934421288329,9.8675304910868067E-2,null,{"$f":"VLOOKUP(I25,$W$4:$Y$14,3)","v":1.9209958354978283},{"$f":"0.4085*G25/(P25+0.000001)^2","v":2.7563737739655885}]
[null,null,null,"riser between 5-6",null,35,{"$f":"IF(F26=0,0,VLOOKUP(F26,wsfuGPM!$C$6:$D$58,2))","v":23.3},14,1.5,0.5,14.5,0.14499999999999999,2.6226459942967466,0.38028366917302825,null,1.4195157625049464,4.7235327550461559]
[null,null,null,"riser between 6-7",null,28,{"$f":"IF(F27=0,0,VLOOKUP(F27,wsfuGPM!$C$6:$D$58,2))","v":19.600000000000001},14,1.5,0.5,14.5,0.14499999999999999,1.9046051373507988,0.27616774491586582,null,1.4195157625049464,3.9734438626139337]
[null,null,null,"riser between 7-8",null,21,{"$f":"IF(F28=0,0,VLOOKUP(F28,wsfuGPM!$C$6:$D$58,2))","v":19.2},14,1.5,0.5,14.5,0.14499999999999999,1.8333209129403409,0.26583153237634943,null,1.4195157625049464,3.8923531715401793]
[null,null,null,"riser between 8-9",null,14,{"$f":"IF(F29=0,0,VLOOKUP(F29,wsfuGPM!$C$6:$D$58,2))","v":16.5},14,1.25,0.5,14.5,0.14499999999999999,3.6683365378727029,0.53190879799154189,null,1.1619918244118586,4.9919371947746445]
[null,null,null,"riser between 9-10",null,7,{"$f":"IF(F30=0,0,VLOOKUP(F30,wsfuGPM!$C$6:$D$58,2))","v":10.7},14,1.25,5.5,19.5,0.19500000000000001,1.6462047992729327,0.32100993585822185,null,1.1619918244118586,3.2371956353993152]
[null,null,null,"riser between 10-11",null,null,{"$f":"IF(F31=0,0,VLOOKUP(F31,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 11-12",null,null,{"$f":"IF(F32=0,0,VLOOKUP(F32,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 12-13",null,null,{"$f":"IF(F33=0,0,VLOOKUP(F33,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 13-14",null,null,{"$f":"IF(F34=0,0,VLOOKUP(F34,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 14-15",null,null,{"$f":"IF(F35=0,0,VLOOKUP(F35,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 15-16",null,null,{"$f":"IF(F36=0,0,VLOOKUP(F36,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 16-17",null,null,{"$f":"IF(F37=0,0,VLOOKUP(F37,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 17-18",null,null,{"$f":"IF(F38=0,0,VLOOKUP(F38,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 18-19",null,null,{"$f":"IF(F39=0,0,VLOOKUP(F39,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,"riser between 19-20",null,null,{"$f":"IF(F40=0,0,VLOOKUP(F40,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,{"$f":"IF(F41=0,0,VLOOKUP(F41,wsfuGPM!$C$6:$D$58,2))","v":0},null,null,null,{"$f":"J41+H41","v":0},0,0,0,null,{"$f":"VLOOKUP(I41,$W$4:$Y$14,3)","v":0},{"$f":"0.4085*G41/(P41+0.000001)^2","v":0}]
[null,null,"Horizontal",{"$f":"Load!E12","v":"Lobby"},{"$f":"Load!E13","v":1},{"$f":"hot","v":15.65},{"$f":"IF(F42=0,0,VLOOKUP(F42,wsfuGPM!$C$6:$D$58,2))","v":17},{"$f":"Length!E24","v":40},1.25,18,{"$f":"J42+H42","v":58},0.57999999999999996,{"$f":"0.434*0.2083*POWER(G42,1.852)*POWER(100/150,1.85)/POWER((P42+0.000001),4.8655)","v":2.5851065634623414},{"$f":"IFERROR(K42*4.52*POWER(G42,1.85)/POWER(150,1.85)/POWER(VLOOKUP(I42,$W$7:$Y$13,2,0)+0.0000001,4.8655),0)","v":1.4873270781958339},{"$f":"IF(N44=0,IF(N43=0,N42,N43),N44)","v":1.7324685512887481},{"$f":"VLOOKUP(I42,$W$4:$X$14,2)","v":1.2649999999999999},{"$f":"0.4085*G42/(P42+0.000001)^2","v":4.3396953681928352}]
[null,null,null,{"$f":"Load!F12","v":"one"},{"$f":"Load!F13","v":9},{"$f":"Load!Q43","v":7},{"$f":"IF(F43=0,0,VLOOKUP(F43,wsfuGPM!$C$6:$D$58,2))","v":10.7},{"$f":"Length!E25","v":40},1,14.5,{"$f":"J43+H43","v":54.5},0.54500000000000004,3.2015944326531414,1.7324685512887481,null,{"$f":"VLOOKUP(I43,$W$4:$X$14,2)","v":1.0149999999999999},{"$f":"0.4085*G43/(P43+0.000001)^2","v":4.2427056102340455}]
[null,null,null,{"$f":"Load!G12","v":0},{"$f":"Load!G13","v":0},{"$f":"Load!U43","v":0},{"$f":"IF(F44=0,0,VLOOKUP(F44,wsfuGPM!$C$6:$D$58,2))","v":0},{"$f":"Length!E26","v":0},null,null,{"$f":"J44+H44","v":0},0,0,0,null,{"$f":"VLOOKUP(I44,$W$4:$X$14,2)","v":0},{"$f":"0.4085*G44/(P44+0.000001)^2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pressure!E27","v":6.367999999999995},{"$f":"SUM(O42,N20:N41)","v":6.0789291105786818},{"$f":"M45-N45","v":0.2890708894213132}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pressure Available","Total Losses","Pressure Remaining","(must be greater than zero)"]

{"sheet":"EquivLength","index":6,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,1,11,2],[12,1,12,2],[11,4,11,5],[15,1,15,2],[13,1,13,2],[14,1,14,2],[21,1,22,2],[18,1,18,2],[16,1,16,2],[20,1,20,2],[17,1,17,2],[19,1,19,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,"This tab contains a stand alone calculator to find equivalent lengths of a combination of fittings.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,"    *The calculator on this tab is not linked to any other portion of the program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,1,"Select pipe size in upper yellow cell (E10).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.25]
[null,2,"Enter quantity of each type of fitting used in yellow cells (D13:D21).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,3,"Column E shows the equivalent length of each type of fitting.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,4,"Total equivalent length of fittings shown will display in blue at the bottom (F23).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"pipe size:",0.75,"in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,"Fitting Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,"qty.","equiv length (ft)"]
[null,"90 deg elbow",null,3,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,2,FALSE)","v":1.5},{"$f":"E13*D13","v":4.5}]
[null,"45 deg elbow",null,null,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,3,FALSE)","v":0.5},0,null,null,null,null,"User Input Cells"]
[null,"Tee, branch",null,null,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,4,FALSE)","v":2},0,null,null,null,null,"Calculated Values, Constants"]
[null,"Tee, run",null,null,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,5,FALSE)","v":0},0,null,null,null,null,"Important Values"]
[null,"Coupling",null,null,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,6,FALSE)","v":0},0]
[null,"Ball Valve",null,null,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,7,FALSE)","v":0},0]
[null,"Gate Valve",null,null,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,8,FALSE)","v":0},0]
[null,"Butterfly Valve",null,null,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,9,FALSE)","v":0},0]
[null,"Check Valve",null,null,{"$f":"HLOOKUP(pipe,wsfuGPM!$I$13:$R$22,10,FALSE)","v":2.5},0]
[null,"Equivalent length of listed fittings:"]
[null,null,null,null,null,{"$f":"SUM(F13:F21)","v":4.5},"ft"]

{"sheet":"Labor&Material","index":7,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[4,1,4,2],[5,1,6,1],[5,3,5,5],[4,8,4,9],[5,10,5,12],[5,8,6,8],[4,10,4,12],[44,13,52,13],[18,1,19,1],[17,1,17,2],[18,3,18,5],[42,10,42,12],[42,8,43,8],[41,1,41,2],[42,3,42,5],[42,1,43,1],[30,3,30,5],[30,1,31,1],[18,8,19,8],[18,10,18,12],[29,8,29,9],[30,8,31,8],[29,1,29,2],[17,8,17,9],[41,8,41,9],[44,6,52,6],[41,10,41,12],[41,3,41,5],[0,1,0,5],[1,1,1,5],[20,6,28,6],[20,13,28,13],[32,6,40,6],[32,13,40,13],[30,10,30,12],[4,3,4,5],[17,3,17,5],[29,3,29,5],[17,10,17,12],[29,10,29,12],[3,1,3,5],[3,8,3,12],[7,6,16,6],[7,13,16,13]]}
[null,"Enter cost in applicable yellow cells. Enter Multiplier in top right of each table."]
[null,"For any blank cell, the default value will be used in cost comparison calculations"]
[null,"Multipliers affect everything in that table (even user defined values)."]
[null,"Material Costs",null,null,null,null,null,null,"Labor Costs"]
[null,"Tubing Cost",null,{"$f":"IF(SUM(E8:E13)=0,\"Default Viega Value\",\"Contractor Price Calculation\")","v":"Default Viega Value"},null,null,"Multiplier:",null,"Tubing Installation",null,{"$f":"IF(SUM(L8:L13)=0,\"Default Viega Value\",\"Contractor Price Calculation\")","v":"Default Viega Value"},null,null,"Multiplier:"]
[null,"Description","Tube ","Cost of Tubing",null,null,1,null,"Description","Tube ","Labor Costs",null,null,1]
[null,null,"Size","Default","User Defined","Calculation","Notes:",null,null,"Size","Default","User Defined","Calculation","Notes:"]
[null,"PEX","3/8\" PEX",{"$f":"Prices!K14","v":0.55059999999999998},null,{"$f":"IF(E8<>0,E8,D8)*$G$6","v":0.55059999999999998},null,null,"Installation Cost PEX","3/8\" PEX",{"$f":"Prices!L14","v":1.6},null,{"$f":"IF(L8<>0,L8,K8)*$N$6","v":1.6},"PHCC Labor Calculator III labor times for one tee and 10 linear feet of copper tube @ $40.00 labor rate used."]
[null,"Copper Tube","1/2\"",{"$f":"Prices!K5","v":1.37},null,{"$f":"IF(E9<>0,E9,D9)*$G$6","v":1.37},null,null,"Installation Cost Copper","1/2\"",{"$f":"Prices!L5","v":6.5279999999999996},null,{"$f":"IF(L9<>0,L9,K9)*$N$6","v":6.5279999999999996}]
[null,"Copper Tube","3/4\"",{"$f":"Prices!K6","v":2.23},null,{"$f":"IF(E10<>0,E10,D10)*$G$6","v":2.23},null,null,"Installation Cost Copper","3/4\"",{"$f":"Prices!L6","v":8.9759999999999991},null,8.9759999999999991]
[null,"Copper Tube","1\"",{"$f":"Prices!K7","v":3.32},null,3.32,null,null,"Installation Cost Copper","1\"",{"$f":"Prices!L7","v":9.7919999999999998},null,9.7919999999999998]
[null,"Copper Tube","1-1/4\"",{"$f":"Prices!K8","v":4.6900000000000004},null,4.6900000000000004,null,null,"Installation Cost Copper","1-1/4\"",{"$f":"Prices!L8","v":11.423999999999999},null,11.423999999999999]
[null,"Copper Tube","1-1/2\"",{"$f":"Prices!K9","v":6.07},null,6.07,null,null,"Installation Cost Copper","1-1/2\"",{"$f":"Prices!L9","v":13.872},null,13.872]
[null,"Copper Tube","2\"",{"$f":"Prices!K10","v":9.4600000000000009},null,9.4600000000000009,null,null,"Installation Cost Copper","2\"",{"$f":"Prices!L10","v":15.911999999999999},null,15.911999999999999]
[null,"Copper Tube","2-1/2\"",{"$f":"Prices!K11","v":13.95},null,13.95,null,null,"Installation Cost Copper","2-1/2\"",{"$f":"Prices!L11","v":19.584},null,19.584]
[null,"Copper Tube","3\"",{"$f":"Prices!K12","v":19.88},null,19.88,null,null,"Installation Cost Copper","3\"",{"$f":"Prices!L12","v":23.255999999999997},null,23.255999999999997]
[null,"Copper Tube","4\"",{"$f":"Prices!K13","v":31.35},null,31.35,null,null,"Installation Cost Copper","4\"",{"$f":"Prices!L13","v":31.007999999999999},null,31.007999999999999]
[null,"Pipe Insulation",null,{"$f":"IF(SUM(E21:E26)=0,\"Default Viega Value\",\"Contractor Price Calculation\")","v":"Default Viega Value"},null,null,"Multiplier:",null,"Insulation Installation",null,{"$f":"IF(SUM(L21:L26)=0,\"Default Viega Value\",\"Contractor Price Calculation\")","v":"Default Viega Value"},null,null,"Multiplier:"]
[null,"Description","Tube ","Material Costs",null,null,1,null,"Description","Tube ","Material Costs",null,null,1]
[null,null,"Size","Default","User Defined","Calculation","Notes:",null,null,"Size","Default","User Defined","Calculation","Notes:"]
[null,"Insulation","1/2\"",{"$f":"Prices!L28","v":1.3160000000000001},null,{"$f":"IF(E21<>0,E21,D21)*$G$19","v":1.3160000000000001},"List Price for NH Armaflex 3/4\" nominal wall, split pipe insulation.",null,"Insulation Labor","1/2\"",{"$f":"Prices!M5","v":1.2},null,{"$f":"IF(L21<>0,L21,K21)*$N$19","v":1.2},"$40 per hour multiplied by PHCC Labor Calculator III times for installing split insulation at the same time as pipe installation."]
[null,"Insulation","3/4\"",{"$f":"Prices!L29","v":1.579},null,{"$f":"IF(E22<>0,E22,D22)*$G$19","v":1.579},null,null,"Insulation Labor","3/4\"",{"$f":"Prices!M6","v":1.2},null,{"$f":"IF(L22<>0,L22,K22)*$N$19","v":1.2}]
[null,"Insulation","1\"",{"$f":"Prices!L30","v":1.9330000000000001},null,1.9330000000000001,null,null,"Insulation Labor","1\"",{"$f":"Prices!M7","v":1.6},null,1.6]
[null,"Insulation","1-1/4\"",{"$f":"Prices!L31","v":2.1960000000000002},null,2.1960000000000002,null,null,"Insulation Labor","1-1/4\"",{"$f":"Prices!M8","v":1.6},null,1.6]
[null,"Insulation","1-1/2\"",{"$f":"Prices!L32","v":2.9060000000000001},null,2.9060000000000001,null,null,"Insulation Labor","1-1/2\"",{"$f":"Prices!M9","v":2},null,2]
[null,"Insulation","2\"",{"$f":"Prices!L33","v":3.581},null,3.581,null,null,"Insulation Labor","2\"",{"$f":"Prices!M10","v":2},null,2]
[null,"Insulation","2-1/2\"",{"$f":"Prices!L34","v":4.2439999999999998},null,4.2439999999999998,null,null,"Insulation Labor","2-1/2\"",{"$f":"Prices!M11","v":2.4},null,2.4]
[null,"Insulation","3\"",{"$f":"Prices!L35","v":5.4089999999999998},null,5.4089999999999998,null,null,"Insulation Labor","3\"",{"$f":"Prices!M12","v":2.4},null,2.4]
[null,"Insulation","4\"",{"$f":"Prices!L36","v":6.8470000000000004},null,6.8470000000000004,null,null,"Insulation Labor","4\"",{"$f":"Prices!M13","v":2.4},null,2.4]
[null,"Pipe Hangers",null,{"$f":"IF(SUM(E33:E38)=0,\"Default Viega Value\",\"Contractor Price Calculation\")","v":"Default Viega Value"},null,null,"Multiplier:",null,"Hanger Installation",null,{"$f":"IF(SUM(L33:L38)=0,\"Default Viega Value\",\"Contractor Price Calculation\")","v":"Default Viega Value"},null,null,"Multiplier:"]
[null,"Description","Tube ","Hanger Costs",null,null,1,null,"Description","Tube ","Hanger Costs",null,null,1]
[null,null,"Size","Default","User Defined","Calculation","Notes:",null,null,"Size","Default","User Defined","Calculation","Notes:"]
[null,"Pipe Hangers","1/2\"",{"$f":"Prices!L19","v":1.21},null,{"$f":"IF(E33<>0,E33,D33)*$G$31","v":1.21},"Default price is for Anvil copper plated swivel loop hangers.",null,"Pipe Hangers","1/2\"",{"$f":"Prices!N5","v":4},null,{"$f":"IF(L33<>0,L33,K33)*$N$31","v":4},"Does not include labor for drilling anchors if needed."]
[null,"Pipe Hangers","3/4\"",{"$f":"Prices!L20","v":1.21},null,{"$f":"IF(E34<>0,E34,D34)*$G$31","v":1.21},null,null,"Pipe Hangers","3/4\"",{"$f":"Prices!N6","v":4},null,{"$f":"IF(L34<>0,L34,K34)*$N$31","v":4}]
[null,"Pipe Hangers","1\"",{"$f":"Prices!L21","v":1.21},null,1.21,null,null,"Pipe Hangers","1\"",{"$f":"Prices!N7","v":3.3200000000000003},null,3.3200000000000003]
[null,"Pipe Hangers","1-1/4\"",{"$f":"Prices!L22","v":1.21},null,1.21,null,null,"Pipe Hangers","1-1/4\"",{"$f":"Prices!N8","v":2.8560000000000003},null,2.8560000000000003]
[null,"Pipe Hangers","1-1/2\"",{"$f":"Prices!L23","v":1.3},null,1.3,null,null,"Pipe Hangers","1-1/2\"",{"$f":"Prices!N9","v":2.5},null,2.5]
[null,"Pipe Hangers","2\"",{"$f":"Prices!L24","v":1.3},null,1.3,null,null,"Pipe Hangers","2\"",{"$f":"Prices!N10","v":2.5},null,2.5]
[null,"Pipe Hangers","2-1/2\"",{"$f":"Prices!L25","v":3.3},null,3.3,null,null,"Pipe Hangers","2-1/2\"",{"$f":"Prices!N11","v":2.6679999999999997},null,2.6679999999999997]
[null,"Pipe Hangers","3\"",{"$f":"Prices!L26","v":3.66},null,3.66,null,null,"Pipe Hangers","3\"",{"$f":"Prices!N12","v":2.4},null,2.4]
[null,"Pipe Hangers","4\"",{"$f":"Prices!L27","v":4.9400000000000004},null,4.9400000000000004,null,null,"Pipe Hangers","4\"",{"$f":"Prices!N13","v":2.3319999999999999},null,2.3319999999999999]
[null,"Fire Stop",null,{"$f":"IF(SUM(E45:E50)=0,\"Default Viega Value\",\"Contractor Price Calculation\")","v":"Default Viega Value"},null,null,"Multiplier:",null,"Coring",null,{"$f":"IF(SUM(L45:L50)=0,\"Default Viega Value\",\"Contractor Price Calculation\")","v":"Default Viega Value"},null,null,"Multiplier:"]
[null,"Description","Tube ","Total Costs",null,null,1,null,"Description","Tube ","Labor Costs",null,null,1]
[null,null,"Size","Default","User Defined","Calculation","Notes:",null,null,"Size","Default","User Defined","Calculation","Notes:"]
[null,"Fire Stop","1/2\"",{"$f":"Prices!L37","v":26.3},null,{"$f":"IF(E45<>0,E45,D45)*$G$43","v":26.3},null,null,"Coring","1/2\"",{"$f":"Prices!L46","v":45},null,{"$f":"IF(L45<>0,L45,K45)*$N$43","v":45}]
[null,"Fire Stop","3/4\"",{"$f":"Prices!L38","v":26.3},null,26.3,null,null,"Coring","3/4\"",{"$f":"Prices!L47","v":45},null,45]
[null,"Fire Stop","1\"",{"$f":"Prices!L39","v":20},null,20,null,null,"Coring","1\"",{"$f":"Prices!L48","v":45},null,45]
[null,"Fire Stop","1-1/4\"",{"$f":"Prices!L40","v":27.8},null,27.8,null,null,"Coring","1-1/4\"",{"$f":"Prices!L49","v":45},null,45]
[null,"Fire Stop","1-1/2\"",{"$f":"Prices!L41","v":28.3},null,28.3,null,null,"Coring","1-1/2\"",{"$f":"Prices!L50","v":45},null,45]
[null,"Fire Stop","2\"",{"$f":"Prices!L42","v":30},null,30,null,null,"Coring","2\"",{"$f":"Prices!L51","v":45},null,45]
[null,"Fire Stop","2-1/2\"",{"$f":"Prices!L43","v":33},null,33,null,null,"Coring","2-1/2\"",{"$f":"Prices!L52","v":45},null,45]
[null,"Fire Stop","3\"",{"$f":"Prices!L44","v":36.4},null,36.4,null,null,"Coring","3\"",{"$f":"Prices!L53","v":45},null,45]
[null,"Fire Stop","4\"",{"$f":"Prices!L45","v":39.6},null,39.6,null,null,"Coring","4\"",{"$f":"Prices!L54","v":45},null,45]

{"sheet":"Fittings","index":8,"n_rows":40,"n_cols":27,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,2,4,4],[4,6,4,7],[3,19,3,22],[3,23,3,26],[21,5,21,6],[4,16,4,18],[18,5,18,6],[19,5,19,6],[20,5,20,6],[4,10,4,12],[4,13,4,15],[29,5,29,6],[27,5,27,6],[24,5,24,6],[30,20,30,22],[22,5,22,6],[23,5,23,6],[25,5,25,6],[28,20,28,22],[29,20,29,22]]}
[]
[null,null,null,null,null,null,"This sheet shows a comparison of installation costs between a SmartLoop recirculation system and a parallel system."]
[null,null,null,null,null,null,"The table on the right uses tube sizes selected on \"Pressure Losses\" tab to find the correct size tee for each floor."]
[null,null,null,null,null,null,null,null,null,null,"H","I","D","E",null,"T","H","I","S","SmartLoop",null,null,null,"Parallel"]
[null,null,"SmartLoop",null,null,null,"Parallel",null,null,null,"VBA Output",null,null,"num to Text  w/o zeros",null,null,"Parallel Tees",null,null,"Size of","Stock Number","cost per","cost per","Size of","Stock Number","cost per","cost per"]
[null,null,"tube",null,"material",null,"tube","material",null,null,"run","run","branch","run","run","branch","run","run","branch","Tees",null,"each","fitting","Fitting",null,"each","fitting"]
[null,"num","size","parallel","cost","length","size","cost",null,null,1,{"$f":"'Pressure Losses'!I21","v":2},{"$f":"L7","v":2},{"$f":"VLOOKUP(K7,$B$9:$C$13,2,FALSE)","v":"1\""},{"$f":"IF(L7=0,\"1\"\"\",VLOOKUP(L7,$B$9:$C$13,2,FALSE))","v":"2\""},{"$f":"VLOOKUP(M7,$B$9:$C$13,2,FALSE)","v":"2\""},null,{"$f":"VLOOKUP(L7,$B$9:$D$13,IF(L7<=M7,2,3),FALSE)","v":"2\""},{"$f":"R7","v":"2\""},{"$f":"O7&\"x\"&N7&\"x\"&P7","v":"2\"x1\"x2\""},{"$f":"IFERROR(VLOOKUP(T7,Prices!$B$6:$F$85,2,FALSE),\"\")","v":"77477 / 78112"},{"$f":"VLOOKUP(T7,Prices!$B$6:$F$85,3,FALSE)","v":89.9},{"$f":"IF(ISNUMBER(V7)=TRUE,V7,0)","v":89.9},{"$f":"R7&\"x\"&S7","v":"2\"x2\""},{"$f":"VLOOKUP(X7,Prices!$B$93:$F$98,2,FALSE)","v":77342},{"$f":"VLOOKUP(X7,Prices!$B$93:$F$98,3,FALSE)","v":63.18},{"$f":"IF(ISNUMBER(Z7)=TRUE,Z7,0)","v":63.18}]
[null,"size","(inches)",null,"USD","(ft)","(inches)","USD",null,null,2,2,1.25,{"$f":"VLOOKUP(K8,$B$9:$C$13,2,FALSE)","v":"2\""},{"$f":"IF(L8=0,\"1\"\"\",VLOOKUP(L8,$B$9:$C$13,2,FALSE))","v":"2\""},{"$f":"VLOOKUP(M8,$B$9:$C$13,2,FALSE)","v":"1-1/4\""},{"$f":"VLOOKUP(K8,$B$9:$D$13,IF(K8<=M8,2,3),FALSE)","v":"1-1/2\""},{"$f":"VLOOKUP(L8,$B$9:$D$13,IF(L8<=M8,2,3),FALSE)","v":"1-1/2\""},{"$f":"P8","v":"1-1/4\""},{"$f":"IFERROR(N8&\"x\"&O8&\"x\"&P8,\"\")","v":"2\"x2\"x1-1/4\""},{"$f":"IFERROR(VLOOKUP(T8,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77487},{"$f":"VLOOKUP(T8,Prices!$B$6:$F$85,3,FALSE)","v":83.59},83.59,{"$f":"IF(L8=0,(N8&\"x\"&S8&\"x\"&S8),(N8&\"x\"&R8&\"x\"&S8))","v":"2\"x1-1/2\"x1-1/4\""},{"$f":"IFERROR(VLOOKUP(X8,Prices!$B$6:$F$85,2,FALSE),\"\")","v":15508},{"$f":"VLOOKUP(X8,Prices!$B$6:$F$85,3,FALSE)","v":101.38},{"$f":"IF(ISNUMBER(Z8)=TRUE,Z8,0)","v":101.38}]
[null,0.75,"3/4\"","3/4\"",null,{"$f":"F17+1","v":135},{"$f":"D17","v":"3/4\""},{"$f":"F9*VLOOKUP(D9,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":301.05},null,null,2,2,1,"2\"","2\"","1\"",{"$f":"VLOOKUP(K9,$B$9:$D$13,IF(K9<=M9,2,3),FALSE)","v":"1-1/2\""},{"$f":"VLOOKUP(L9,$B$9:$D$13,IF(L9<=M9,2,3),FALSE)","v":"1-1/2\""},"1\"","2\"x2\"x1\"",{"$f":"IFERROR(VLOOKUP(T9,Prices!$B$6:$F$85,2,FALSE),\"\")","v":94772},{"$f":"VLOOKUP(T9,Prices!$B$6:$F$85,3,FALSE)","v":83.59},83.59,{"$f":"IFERROR(IF(L9=0,(Q9&\"x\"&S9&\"x\"&S9),(Q9&\"x\"&R9&\"x\"&S9)),\"\")","v":"1-1/2\"x1-1/2\"x1\""},{"$f":"IFERROR(VLOOKUP(X9,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77467},{"$f":"VLOOKUP(X9,Prices!$B$6:$F$85,3,FALSE)","v":50.56},50.56]
[null,1,"1\"","3/4\"",{"$f":"F10*VLOOKUP(C10,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":0},{"$f":"SUMIF('Pressure Losses'!$I$21:$I$40,B10,'Pressure Losses'!$H$21:$H$40)","v":0},{"$f":"D10","v":"3/4\""},{"$f":"F10*VLOOKUP(D10,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":0},null,null,2,2,1,"2\"","2\"","1\"","1-1/2\"","1-1/2\"","1\"","2\"x2\"x1\"",{"$f":"IFERROR(VLOOKUP(T10,Prices!$B$6:$F$85,2,FALSE),\"\")","v":94772},{"$f":"VLOOKUP(T10,Prices!$B$6:$F$85,3,FALSE)","v":83.59},83.59,{"$f":"IFERROR(IF(L10=0,(Q10&\"x\"&S10&\"x\"&S10),(Q10&\"x\"&R10&\"x\"&S10)),\"\")","v":"1-1/2\"x1-1/2\"x1\""},{"$f":"IFERROR(VLOOKUP(X10,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77467},{"$f":"VLOOKUP(X10,Prices!$B$6:$F$85,3,FALSE)","v":50.56},50.56]
[null,1.25,"1-1/4\"","1\"",{"$f":"F11*VLOOKUP(C11,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":131.32000000000002},{"$f":"SUMIF('Pressure Losses'!$I$21:$I$40,B11,'Pressure Losses'!$H$21:$H$40)","v":28},"1\"",{"$f":"F11*VLOOKUP(D11,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":92.96},null,null,2,2,1,"2\"","2\"","1\"","1-1/2\"","1-1/2\"","1\"","2\"x2\"x1\"",{"$f":"IFERROR(VLOOKUP(T11,Prices!$B$6:$F$85,2,FALSE),\"\")","v":94772},{"$f":"VLOOKUP(T11,Prices!$B$6:$F$85,3,FALSE)","v":83.59},83.59,"1-1/2\"x1-1/2\"x1\"",{"$f":"IFERROR(VLOOKUP(X11,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77467},{"$f":"VLOOKUP(X11,Prices!$B$6:$F$85,3,FALSE)","v":50.56},50.56]
[null,1.5,"1-1/2\"","1-1/4\"",{"$f":"F12*VLOOKUP(C12,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":254.94},{"$f":"SUMIF('Pressure Losses'!$I$21:$I$40,B12,'Pressure Losses'!$H$21:$H$40)","v":42},"1-1/4\"",{"$f":"F12*VLOOKUP(D12,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":196.98000000000002},null,null,2,1.5,1,"2\"","1-1/2\"","1\"","1-1/2\"","1-1/4\"","1\"","2\"x1-1/2\"x1\"",{"$f":"IFERROR(VLOOKUP(T12,Prices!$B$6:$F$85,2,FALSE),\"\")","v":15498},{"$f":"VLOOKUP(T12,Prices!$B$6:$F$85,3,FALSE)","v":98.14},98.14,"1-1/2\"x1-1/4\"x1\"",{"$f":"IFERROR(VLOOKUP(X12,Prices!$B$6:$F$85,2,FALSE),\"\")","v":15453},{"$f":"VLOOKUP(X12,Prices!$B$6:$F$85,3,FALSE)","v":70.53},70.53]
[null,2,"2\"","1-1/2\"",{"$f":"F13*VLOOKUP(C13,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":605.44000000000005},{"$f":"SUMIF('Pressure Losses'!$I$21:$I$40,B13,'Pressure Losses'!$H$21:$H$40)","v":64},"1-1/2\"",{"$f":"F13*VLOOKUP(D13,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":388.48},null,null,1.5,1.5,1,"1-1/2\"","1-1/2\"","1\"","1-1/4\"","1-1/4\"","1\"","1-1/2\"x1-1/2\"x1\"",{"$f":"IFERROR(VLOOKUP(T13,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77467},{"$f":"VLOOKUP(T13,Prices!$B$6:$F$85,3,FALSE)","v":50.56},50.56,"1-1/4\"x1-1/4\"x1\"",{"$f":"IFERROR(VLOOKUP(X13,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77447},{"$f":"VLOOKUP(X13,Prices!$B$6:$F$85,3,FALSE)","v":27.4},27.4]
[null,2.5,"2-1/2\"","2\"",{"$f":"F14*VLOOKUP(C14,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":0},{"$f":"SUMIF('Pressure Losses'!$I$21:$I$40,B14,'Pressure Losses'!$H$21:$H$40)","v":0},"2\"",{"$f":"F14*VLOOKUP(D14,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":0},null,null,1.5,1.5,1,"1-1/2\"","1-1/2\"","1\"","1-1/4\"","1-1/4\"","1\"","1-1/2\"x1-1/2\"x1\"",{"$f":"IFERROR(VLOOKUP(T14,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77467},{"$f":"VLOOKUP(T14,Prices!$B$6:$F$85,3,FALSE)","v":50.56},50.56,"1-1/4\"x1-1/4\"x1\"",{"$f":"IFERROR(VLOOKUP(X14,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77447},{"$f":"VLOOKUP(X14,Prices!$B$6:$F$85,3,FALSE)","v":27.4},27.4]
[null,3,"3\"","2-1/2\"",{"$f":"F15*VLOOKUP(C15,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":0},{"$f":"SUMIF('Pressure Losses'!$I$21:$I$40,B15,'Pressure Losses'!$H$21:$H$40)","v":0},"2-1/2\"",{"$f":"F15*VLOOKUP(D15,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":0},null,null,1.5,1.25,1,"1-1/2\"","1-1/4\"","1\"","1-1/4\"","1\"","1\"","1-1/2\"x1-1/4\"x1\"",{"$f":"IFERROR(VLOOKUP(T15,Prices!$B$6:$F$85,2,FALSE),\"\")","v":15453},{"$f":"VLOOKUP(T15,Prices!$B$6:$F$85,3,FALSE)","v":70.53},70.53,"1-1/4\"x1\"x1\"",{"$f":"IFERROR(VLOOKUP(X15,Prices!$B$6:$F$85,2,FALSE),\"\")","v":14568},{"$f":"VLOOKUP(X15,Prices!$B$6:$F$85,3,FALSE)","v":31.02},31.02]
[null,4,"4\"","3\"",{"$f":"F16*VLOOKUP(C16,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":0},{"$f":"SUMIF('Pressure Losses'!$I$21:$I$40,B16,'Pressure Losses'!$H$21:$H$40)","v":0},"3\"",{"$f":"F16*VLOOKUP(D16,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":0},null,null,1.25,1.25,1,"1-1/4\"","1-1/4\"","1\"","1\"","1\"","1\"","1-1/4\"x1-1/4\"x1\"",{"$f":"IFERROR(VLOOKUP(T16,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77447},{"$f":"VLOOKUP(T16,Prices!$B$6:$F$85,3,FALSE)","v":27.4},27.4,"1\"x1\"x1\"",{"$f":"IFERROR(VLOOKUP(X16,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77412},{"$f":"VLOOKUP(X16,Prices!$B$6:$F$85,3,FALSE)","v":43.49},43.49]
[null,"3/8\" PEX","3/8\" PEX","3/4\"",{"$f":"F17*VLOOKUP(C17,'Labor&Material'!$C$8:$F$17,4,FALSE)","v":73.7804},{"$f":"SUM(F11:F16)","v":134},null,null,null,null,1.25,0,1,"1-1/4\"","1\"","1\"","1\"",{"$error":"#N/A"},"1\"","1-1/4\"x1\"x1\"",{"$f":"IFERROR(VLOOKUP(T17,Prices!$B$6:$F$85,2,FALSE),\"\")","v":14568},{"$f":"VLOOKUP(T17,Prices!$B$6:$F$85,3,FALSE)","v":31.02},31.02,"1\"x1\"x1\"",{"$f":"IFERROR(VLOOKUP(X17,Prices!$B$6:$F$85,2,FALSE),\"\")","v":77412},{"$f":"VLOOKUP(X17,Prices!$B$6:$F$85,3,FALSE)","v":43.49},43.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IFERROR(N18&\"x\"&O18&\"x\"&P18,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T18,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T18,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X18,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X18,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"SUM(E10:E17)","v":1065.4804000000001},"Total tubing cost",null,{"$f":"SUM(H9:H16)","v":979.47},null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IFERROR(N19&\"x\"&O19&\"x\"&P19,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T19,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T19,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X19,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X19,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"SUM(W7:W27)*'Labor&Material'!G6","v":752.46999999999991},"Total fitting cost",null,{"$f":"SUM(AA7:AA31)*'Labor&Material'!G6","v":580.83000000000004},null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$f":"IFERROR(VLOOKUP(T20,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T20,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X20,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X20,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"Prices!D5*'Labor&Material'!G6","v":93.62},"SmartLoop Kit",null,0,null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$f":"IFERROR(VLOOKUP(T21,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T21,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X21,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X21,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"F17*'Labor&Material'!M8+SUMPRODUCT(F10:F16,'Labor&Material'!M11:M17)","v":2135.2640000000001},"Tubing installation",null,{"$f":"F9*'Labor&Material'!M10+SUMPRODUCT(F10:F16,'Labor&Material'!M10:M16)","v":2853.5519999999997},null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$f":"IFERROR(VLOOKUP(T22,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T22,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X22,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X22,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"SUMPRODUCT(Fittings!P32:P40,'Labor&Material'!F45:F53)","v":290.5},"Fire Stops",null,{"$f":"SUMPRODUCT(Fittings!Q32:Q40,'Labor&Material'!F45:F53)","v":527.9},null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$f":"IFERROR(VLOOKUP(T23,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T23,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X23,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X23,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"250+SUMPRODUCT(P32:P40,'Labor&Material'!M45:M53)","v":700},"Coring",null,{"$f":"250+SUMPRODUCT(Q32:Q40,'Labor&Material'!M45:M53)","v":1150},null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$f":"IFERROR(VLOOKUP(T24,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T24,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X24,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X24,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"SUMPRODUCT(Fittings!F10:F16,'Labor&Material'!F35:F41)+SUMPRODUCT(F10:F16,'Labor&Material'!M35:M41)","v":516.64800000000002},"Hangers",null,{"$f":"F9*'Labor&Material'!F34+SUMPRODUCT(Fittings!F10:F16,'Labor&Material'!F35:F41)+SUMPRODUCT(F10:F16,'Labor&Material'!M35:M41)","v":679.99800000000005},null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$f":"IFERROR(VLOOKUP(T25,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T25,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X25,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X25,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"SUMPRODUCT(F10:F16,'Labor&Material'!F23:F29)+SUMPRODUCT(F10:F16,'Labor&Material'!M23:M29)","v":669.52400000000011},"Insulation",null,{"$f":"F9*'Labor&Material'!F22+SUMPRODUCT(Fittings!F10:F16,'Labor&Material'!F22:F28)+SUMPRODUCT(Fittings!F10:F16,'Labor&Material'!M22:M28)","v":785.505},null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$f":"IFERROR(VLOOKUP(T26,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T26,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X26,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X26,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},"1\"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",{"$f":"IFERROR(VLOOKUP(T27,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(T27,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0,"",{"$f":"IFERROR(VLOOKUP(X27,Prices!$B$6:$F$85,2,FALSE),\"\")","v":""},{"$f":"VLOOKUP(X27,Prices!$B$6:$F$85,3,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,{"$f":"SUM(E19:E26)","v":6223.5064000000002},"Total",null,{"$f":"SUM(H19:H26)","v":7557.2550000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(M8:M27,MATCH(9.99999999999999E+307,M8:M27))","v":1},null,null,"1\"",null,null,null,null,"reducer: ",null,null,{"$f":"P29&\"x3/4\"\"\"","v":"1\"x3/4\""},{"$f":"VLOOKUP(X29,Prices!$B$99:$F$109,2,FALSE)","v":78087},{"$f":"VLOOKUP(X29,Prices!$B$99:$F$109,3,FALSE)","v":9.36},9.36]
[null,null,null,null,null,"Difference:",null,{"$f":"H28-E28","v":1333.7485999999999},null,null,null,null,null,null,"Cores &",null,null,null,null,null,"FTGxP 90° elbow: ",null,null,"3/4\"x3/4\"",{"$f":"VLOOKUP(X30,Prices!$B$87:$F$92,2,FALSE)","v":77352},{"$f":"VLOOKUP(X30,Prices!$B$87:$F$92,3,FALSE)","v":5.95},{"$f":"IF(ISNUMBER(Z30)=TRUE,Z30,0)","v":5.95}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fire stops","(SL)","(Par)",null,null,null,"PxP 90° elbow: ",null,null,"3/4\"x3/4\"",{"$f":"VLOOKUP(X31,Prices!$B$93:$F$98,2,FALSE)","v":77322},{"$f":"VLOOKUP(X31,Prices!$B$93:$F$98,3,FALSE)","v":5.95},{"$f":"IF(ISNUMBER(Z31)=TRUE,Z31,0)","v":5.95}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2\"",0,{"$f":"COUNTIF($Q$8:$Q$27,O32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/4\"",{"$f":"COUNTIF($N$8:$N$27,O33)","v":0},{"$f":"COUNT(M8:M27)+COUNTIF($Q$8:$Q$27,O33)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\"",0,{"$f":"COUNTIF($Q$8:$Q$27,O34)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",2,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",3,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2\"",5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-1/2\"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3\"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4\"",0,0]

{"sheet":"Prices","index":9,"n_rows":120,"n_cols":15,"rows_kept":120,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,1],[1,2,1,5],[2,11,2,13]]}
["Default Prices should be updated on this tab and no where else"]
["everything is looked up by size",null,"change dates above table when any table is updated",null,null,null,null,null,null,null,null,"Aug 2012 Price List"]
[null,null,null,null,null,"Aug 2012 Price List",null,null,null,null,"material","Labor"]
["Fitting Type","size","Stock code","List ea.","Bag Price","Bag qty.",null,null,null,"size","cost per ft","pipe install","insulation","hangers","$40 labor hour multiplied by times"]
["SmartLoop Kit","SmartLoop Kit",79000,93.62,93.62,1,null,null,"Copper Tube","1/2\"",1.37,6.5279999999999996,1.2,4," from PHCC Labor Calculator III"]
["Copper Tee, P x P x P,","3/4\"x3/4\"x3/4\"",77387,9.4700000000000006,94.7,10,null,null,null,"3/4\"",2.23,8.9759999999999991,1.2,4]
[null,"1\"x3/4\"x3/4\"",77422,25.9,129.5,5,null,null,null,"1\"",3.32,9.7919999999999998,1.6,3.3200000000000003]
[null,"1\"x1\"x3/4\"",77437,19.38,96.9,5,null,null,null,"1-1/4\"",4.6900000000000004,11.423999999999999,1.6,2.8560000000000003]
[null,"1\"x1\"x1\"",77412,43.49,217.45,5,null,null,null,"1-1/2\"",6.07,13.872,2,2.5]
[null,"1-1/4\"x1\"x3/4\"",94762,28.81,28.81,1,null,null,null,"2\"",9.4600000000000009,15.911999999999999,2,2.5]
[null,"1-1/4\"x1\"x1\"",14568,31.02,31.02,1,null,null,null,"2-1/2\"",13.95,19.584,2.4,2.6679999999999997]
["(tee and reducer)","1-1/4\"x1\"x1-1/4\"","77442 / 78097",{"$f":"D15+D103","v":41.29},91.21,"1 / 5",null,null,null,"3\"",19.88,23.255999999999997,2.4,2.4]
[null,"1-1/4\"x1-1/4\"x3/4\"",77452,26.36,26.36,1,null,null,null,"4\"",31.35,31.007999999999999,2.4,2.3319999999999999]
[null,"1-1/4\"x1-1/4\"x1\"",77447,27.4,27.4,1,null,null,null,"3/8\" PEX",0.55059999999999998,1.6,"N/A","N/A"]
[null,"1-1/4\"x1-1/4\"x1-1/4\"",77442,28.81,28.81,1]
[null,"1-1/2\"x1\"x3/4\"",79660,70.91,70.91,1]
[null,"1-1/2\"x1\"x1\"",15458,79.150000000000006,79.150000000000006,1,null,null,null,null,null,"Updated: Aug 2012"]
[null,"1-1/2\"x1\"x1-1/2\"",15463,86.83,86.83,1,null,null,null,"size","Stock code","List per"]
[null,"1-1/2\"x1-1/4\"x3/4\"",22233,60.84,60.84,1,null,null,"Hangers","1/2\"","Hang 1/2",1.21,"Anvil copper plated steel"]
[null,"1-1/2\"x1-1/4\"x1\"",15453,70.53,70.53,1,null,null,null,"3/4\"","Hang 3/4",1.21,"swivel loop hangers"]
[null,"1-1/2\"x1-1/4\"x1-1/4\"",15483,52.1,52.1,1,null,null,null,"1\"","Hang 1",1.21]
[null,"1-1/2\"x1-1/2\"x3/4\"",77462,49.68,49.68,1,null,null,null,"1-1/4\"","Hang 1-1/4",1.21]
[null,"1-1/2\"x1-1/2\"x1\"",77467,50.56,50.56,1,null,null,null,"1-1/2\"","Hang 1-1/2",1.3]
[null,"1-1/2\"x1-1/2\"x1-1/4\"",77472,52.36,52.36,1,null,null,null,"2\"","Hang 2",1.3]
[null,"1-1/2\"x1-1/2\"x1-1/2\"",77457,55.95,55.95,1,null,null,null,"2-1/2\"","Hang 2-1/2",3.3]
["(tee and reducer)","2\"x1\"x2\"","77477 / 78112",{"$f":"D37+D107","v":89.9},89.9,"1 / 1",null,null,null,"3\"","Hang 3",3.66]
[null,"2\"x1-1/4\"x1-1/4\"",15518,115.96,115.96,1,null,null,null,"4\"","Hang 4",4.9400000000000004]
[null,"2\"x1-1/4\"x3/4\"",15513,99.42,99.42,1,null,null,"Insulation","1/2\"","Ins 1/2",1.3160000000000001,"List price for NH Armaflex"]
[null,"2\"x1-1/2\"x1\"",15498,98.14,98.14,1,null,null,null,"3/4\"","Ins 3/4",1.579,"3/4\" nominal wall"]
[null,"2\"x1-1/2\"x1-1/4\"",15508,101.38,101.38,1,null,null,null,"1\"","Ins 1",1.9330000000000001]
[null,"2\"x1-1/2\"x1-1/2\"",15503,102.79,102.79,1,null,null,null,"1-1/4\"","Ins 1-1/4",2.1960000000000002]
[null,"2\"x1-1/2\"x2\"",22228,95.68,95.68,1,null,null,null,"1-1/2\"","Ins 1-1/2",2.9060000000000001]
[null,"2\"x2\"x3/4\"",94777,80.89,80.89,1,null,null,null,"2\"","Ins 2",3.581]
[null,"2\"x2\"x1\"",94772,83.59,83.59,1,null,null,null,"2-1/2\"","Ins 2-1/2",4.2439999999999998]
[null,"2\"x2\"x1-1/4\"",77487,83.59,83.59,1,null,null,null,"3\"","Ins 3",5.4089999999999998]
[null,"2\"x2\"x1-1/2\"",77482,62.83,62.83,1,null,null,null,"4\"","Ins 4",6.8470000000000004]
[null,"2\"x2\"x2\"",77477,69.12,69.12,1,null,null,"Firestop","1/2\"","FS 1/2",26.3]
[null,"2-1/2\"x3/4\"x2-1/2\"",20684,336.03,336.03,1,null,null,null,"3/4\"","FS 3/4",26.3]
[null,"2-1/2\"x1\"x2-1/2\"",20689,346.95,346.95,1,null,null,null,"1\"","FS 1",20]
[null,"2-1/2\"x1-1/4\"x2-1/2\"",20694,351.09,351.09,1,null,null,null,"1-1/4\"","FS 1-1/4",27.8]
[null,"2-1/2\"x1-1/2\"x2-1/2\"",20699,307.06,307.06,1,null,null,null,"1-1/2\"","FS 1-1/2",28.3]
[null,"2-1/2\"x2\"x3/4\"",20704,322.85000000000002,322.85000000000002,1,null,null,null,"2\"","FS 2",30]
[null,"2-1/2\"x2\"x1\"",20709,303.99,303.99,1,null,null,null,"2-1/2\"","FS 2-1/2",33]
[null,"2-1/2\"x2\"x1-1/2\"",22283,285.45999999999998,285.45999999999998,1,null,null,null,"3\"","FS 3",36.4]
[null,"2-1/2\"x2\"x2\"",22278,286.58999999999997,286.58999999999997,1,null,null,null,"4\"","FS 4",39.6]
[null,"2-1/2\"x2\"x2-1/2\"",20714,323.02999999999997,323.02999999999997,1,null,null,"Core Drilling","1/2\"","CD 1/2",45]
[null,"2-1/2\"x2-1/2\"x1/2\"",22303,316.10000000000002,316.10000000000002,1,null,null,null,"3/4\"","CD 3/4",45]
[null,"2-1/2\"x2-1/2\"x3/4\"",22298,316.10000000000002,316.10000000000002,1,null,null,null,"1\"","CD 1",45]
[null,"2-1/2\"x2-1/2\"x1\"",22293,316.10000000000002,316.10000000000002,1,null,null,null,"1-1/4\"","CD 1-1/4",45]
[null,"2-1/2\"x2-1/2\"x1-1/4\"",22288,316.10000000000002,316.10000000000002,1,null,null,null,"1-1/2\"","CD 1-1/2",45]
[null,"2-1/2\"x2-1/2\"x1-1/2\"",20803,302.07,302.07,1,null,null,null,"2\"","CD 2",45]
[null,"2-1/2\"x2-1/2\"x2\"",20688,266.27999999999997,266.27999999999997,1,null,null,null,"2-1/2\"","CD 2-1/2",45]
[null,"2-1/2\"x2-1/2\"x2-1/2\"",20683,226.67,226.67,1,null,null,null,"3\"","CD 3",45]
[null,"3\"x3/4\"x3\"",20719,338.78,338.78,1,null,null,null,"4\"","CD 4",45]
[null,"3\"x1\"x3\"",20724,358.86,358.86,1]
[null,"3\"x1-1/4\"x3\"",20729,439.76,439.76,1]
[null,"3\"x1-1/2\"x3\"",20727,374.8,374.8,1]
[null,"3\"x2\"x2\"",20732,358.58,358.58,1]
[null,"3\"x2\"x2-1/2\"",20734,372.82,372.82,1]
[null,"3\"x2\"x3\"",20739,377.67,377.67,1]
[null,"3\"x2-1/2\"x2\"",20744,353.21,353.21,1]
[null,"3\"x2-1/2\"x2-1/2\"",20749,390.07,390.07,1]
[null,"3\"x2-1/2\"x3\"",20754,387.62,387.62,1]
[null,"3\"x3\"x1/2\"",20759,344.32,344.32,1]
[null,"3\"x3\"x3/4\"",22323,333.14,333.14,1]
[null,"3\"x3\"x1\"",22308,333.14,333.14,1]
[null,"3\"x3\"x1-1/4\"",22313,333.14,333.14,1]
[null,"3\"x3\"x1-1/2\"",20798,333.14,333.14,1]
[null,"3\"x3\"x2\"",20698,325.95999999999998,325.95999999999998,1]
[null,"3\"x3\"x2-1/2\"",20703,339.99,339.99,1]
[null,"3\"x3\"x3\"",20693,283.32,283.32,1]
["(tee and reducer)","4\"x1\"x4\"","20708 / 20773 / 78112",{"$f":"D86+D118+D107","v":572.16999999999996}]
[null,"4\"x3\"x1\"","20774 / 78112",{"$f":"D76+D107","v":573.41999999999996}]
[null,"4\"x3\"x1-1/4\"","20774 / 78117",{"$f":"D76+D108","v":578.06999999999994}]
[null,"4\"x3\"x1-1/2\"","20774 / 78122",{"$f":"D76+D109","v":577.37}]
[null,"4\"x3\"x2\"",20774,552.64,552.64,1]
[null,"4\"x3\"x3\"",20784,541.53,541.53,1]
[null,"4\"x4\"x1/2\"",20788,533.67999999999995,533.67999999999995,1]
[null,"4\"x4\"x3/4\"",20793,526.57000000000005,526.57000000000005,1]
[null,"4\"x4\"x1\"",20794,391.23,391.23,1]
[null,"4\"x4\"x1-1/4\"",20795,475.12,475.12,1]
[null,"4\"x4\"x1-1/2\"",20808,451.61,451.61,1]
[null,"4\"x4\"x2\"",20713,359.84,359.84,1]
[null,"4\"x4\"x2-1/2\"",20718,370.85,370.85,1]
[null,"4\"x4\"x3\"",20723,406.52,406.52,1]
[null,"4\"x4\"x4\"",20708,397.54,397.54,1]
["Copper FTGxP elbow 90°","1/2\"x1/2\"",77347,3.53,35.299999999999997,10]
[null,"3/4\"x3/4\"",77352,5.95,59.5,10]
[null,"1\"x1\"",77357,13.67,68.349999999999994,5]
[null,"1-1/4\"x1-1/4\"",77362,24.27,24.27,1]
[null,"1-1/2\"x1-1/2\"",77367,46.3,46.3,1]
[null,"2\"x2\"",77372,63.64,63.64,1]
["Copper PxP elbow 90°","1/2\"x1/2\"",77317,3.53,35.299999999999997,10]
[null,"3/4\"x3/4\"",77322,5.95,59.5,10]
[null,"1\"x1\"",77327,11.92,59.6,5]
[null,"1-1/4\"x1-1/4\"",77332,24.03,24.03,1]
[null,"1-1/2\"x1-1/2\"",77337,45.46,45.46,1]
[null,"2\"x2\"",77342,63.18,63.18,1]
["reducers FTGxP","3/4\"x1/2\"",78077,3.53,35.299999999999997,10]
[null,"1\"x1/2\"",78082,9.02,90.2,10]
[null,"1\"x3/4\"",78087,9.36,93.6,10]
[null,"1-1/4\"x1/2\"",22333,10.87,54.35,5]
[null,"1-1/4\"x1\"",78097,12.48,62.4,5]
[null,"1-1/2\"x3/4\"",14543,18.54,18.54,1]
[null,"1-1/2\"x1\"",78102,18.329999999999998,18.329999999999998,1]
[null,"1-1/2\"x1-1/4\"",78107,18.440000000000001,18.440000000000001,1]
[null,"2\"x1\"",78112,20.78,20.78,1]
[null,"2\"x1-1/4\"",78117,25.43,25.43,1]
[null,"2\"x1-1/2\"",78122,24.73,24.73,1]
[null,"2-1/2\"x1\"",20814,88.83,88.83,1]
[null,"2-1/2\"x1-1/4\"",20815,124.82,124.82,1]
[null,"2-1/2\"x1-1/2\"",20813,125.57,125.57,1]
[null,"2-1/2\"x2\"",20758,107.97,107.97,1]
[null,"3\"x1-1/4\"",20817,144.54,144.54,1]
[null,"3\"x1-1/2\"",20818,137.36000000000001,137.36000000000001,1]
[null,"3\"x2\"",20763,133.66999999999999,133.66999999999999,1]
[null,"3\"x2-1/2\"",20768,137.69,137.69,1]
[null,"4\"x2\"",20773,153.85,153.85,1]
[null,"4\"x2-1/2\"",20778,168.09,168.09,1]
[null,"4\"x3\"",20783,177.65,177.65,1]

{"sheet":"Heat Loss","index":10,"n_rows":51,"n_cols":33,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,12,3,13],[4,12,5,13],[10,1,10,3],[12,1,12,3],[35,7,35,8],[32,7,32,8],[34,7,34,8],[13,1,13,3],[25,1,25,2],[24,1,24,4],[25,3,25,4],[11,1,11,3],[37,15,37,18],[15,9,16,9],[22,10,22,11],[31,7,31,8],[30,7,30,8],[34,15,36,18],[22,15,22,16],[36,7,36,8],[37,7,37,8],[23,15,23,16],[23,10,23,11],[27,10,27,11],[33,7,33,8]]}
[]
[1,"Select \"Calculate Minimum Flow\" or \"Calculate Riser Temperatures\" to begin.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.75,null,null,null,null,null,null,null,null,0.1]
[2,"Enter heater and ambient temperatures in upper yellow cells (E11:E13).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.25,1,null,null,null,null,null,null,null,null,0.2]
[3,"Enter insulation thermal resistance (k value) in yellow cell below (F19).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,1.25,null,null,null,null,null,null,null,null,0.3]
[4,"Enter \"insulation thickness\" (in inches) in yellow cells in middle of second table (G19, G21, and G22).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1.5,null,null,null,null,null,null,null,null,0.4]
[5,"Enter minimum allowable system temperature in second yellow cell (E12).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,2,null,null,null,null,null,null,null,null,0.5]
[6,"Click \" Calculate \" button, ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2.5,null,null,null,null,null,null,null,null,0.6]
[7,"Minimum flow rates required to maintain temperature above the minimum alowable temperature will be displayed in the blue cells (I19, I21).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,3,null,null,null,null,null,null,null,null,0.7]
[8,"Calculating temperatures based on flow rate is now recommended as it will give more accurate results.",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,0.8]
[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,0.9]
[null,"Heater Temperature",null,null,140,"F",null,null,null,"user input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Minimum Temperature",null,null,134,"F",null,null,null,"constants / input elsewhere in program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001]
[null,"Ambient Temperature",null,null,70,"F ",null,null,null,"calculated values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,"Height of Riser",null,null,{"$f":"Length!K15","v":134},"ft",null,null,null,"system temperature below minimum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3]
[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,1.4,null,"pipe","ID","OD","wall"]
[null,null,"Pipe","I.D.","O.D.","k - Value","insulation","insulation","Flow ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,null,"size",null,null,"thickness"]
[null,null,"size","Pipe","Pipe","k insulation","thickness","outer diameter","Rate",null,null,null," equations:","  dQ ","=","2*k*π*ΔT",null,null,null,null,null,null,null,null,null,null,null,1.6,null,0.5,{"$f":"AF17-(2*AG17)","v":0.54500000000000004},0.625,0.04]
[null,null,"(in)","(in)","(in)","(Btu in/(hr ft2 °F)","(in)","(in)","(gpm)",null,null,null,{"$f":"PI()","v":3.1415926535897931},"L",null,"  ln(OD/ID)",null,null,null,null,null,null,null,null,null,null,null,1.7,null,0.75,{"$f":"AF18-(2*AG18)","v":0.66},0.75,4.4999999999999998E-2]
[null,"SL Riser:",{"$f":"MODE('Pressure Losses'!I21:I40)","v":2},{"$f":"VLOOKUP(C19,$AD$17:$AF$23,2)","v":1.9849999999999999},{"$f":"VLOOKUP(C19,$AD$17:$AF$23,3)","v":2.125},0.24299999999999999,1,{"$f":"E19+2*G19","v":4.125},0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8,null,1,1.0249999999999999,1.125,0.05]
[null,"PEX:",0.375,0.35,0.5,0.2,{"$f":"(E20-D20)/2","v":7.5000000000000011E-2},"N/A",{"$f":"flow","v":0.2},null,null,null,null," ΔTw ","=","     dQ      ",null,null,null,null,null,null,null,null,null,null,null,1.9,null,1.25,1.2649999999999999,1.375,5.5E-2]
[null,"Parallel:",{"$f":"VLOOKUP(C19,R2:S8,2,FALSE)","v":1.5},{"$f":"VLOOKUP(C21,$AD$17:$AF$23,2)","v":1.5049999999999999},{"$f":"VLOOKUP(C21,$AD$17:$AF$23,3)","v":1.625},{"$f":"kVal","v":0.24299999999999999},1,{"$f":"E21+2*G21","v":3.625},0.7,null,null,null,null,"L",null,"L*dV*C",null,null,null,null,null,null,null,null,null,null,null,2,null,1.5,1.5049999999999999,1.625,0.06]
[null,"Return:",0.75,{"$f":"VLOOKUP(C22,$AD$17:$AF$23,2)","v":0.66},{"$f":"VLOOKUP(C22,$AD$17:$AF$23,3)","v":0.75},{"$f":"kVal","v":0.24299999999999999},1,{"$f":"E22+2*G22","v":2.75},{"$f":"I21","v":0.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,null,2,1.9849999999999999,2.125,7.0000000000000007E-2]
[null,null,null,null,null,2773.92,null,null,null,null,null,null,null,"dVest","=","      π*L*k*ΔT     ",null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,null,2.5,2.4649999999999999,2.625,0.08]
[null,null,null,null,null,null,"U=",{"$f":"1/((IID*(IID-D19)/D19/F23)+(IOD*LN(IID/D19)/2/F23)+(IOD*LN(IOD/IID)/2/kVal)+((IOD-IID)/kVal))","v":7.21481491937946E-2},null,null,"Temperature  (°F)",null,null,null,null,"10°F*C*ln(OD/ID)",null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998]
[null,"Required Circulator Pressure",null,null,null,null,"llU=",{"$f":"1/((E21*(E21-D21)/D21/F23)+(H21*LN(E21/D21)/2/F23)+(H21*LN(H21/E21)/2/kVal)+((H21-E21)/kVal))","v":7.0347581938627862E-2},null,null,"SmartLoop","Parallel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4]
[null,"SmartLoop",null,"Parallel",null,null,"llUR =",{"$f":"1/((llIID*(llIID-D22)/D22/F23)+(H22*LN(llIID/D22)/2/F23)+(H22*LN(H22/llIID)/2/kVal)+((H22-llIID)/kVal))","v":6.4174707995232769E-2},null,"Top of Riser ",null,null,"Top of Riser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,"friction ","pump","friction ","pump",null,null,null,null,"Riser Return ",null,null,"Riser Return",null,"dQ",": rate of heat transfer (Btu / hr)",null,null,null,null,null,null,null,null,null,null,null,2.6]
[null,"loss","pressure","loss","pressure",null,null,null,null,null,null,null,null,null,"L",": unit of length (ft)",null,null,null,null,null,null,null,null,null,null,null,2.7]
[null,"(psi/ft)",null,"(psi/ft)",null,null,null,null,null,null,null,null,null,null,"k",": thermal conductivity (Btu / (hr*ft*°F))",null,null,null,null,null,null,null,null,null,null,null,2.8]
[null,{"$f":"0.00434*0.2083*POWER(100/150,1.852)*POWER(flow,1.852)/POWER((PID+0.000001),4.8655)","v":3.5801105101473892E-3},{"$f":"$B$30*(length+12.3)","v":0.52377016763456308},{"$f":"0.00434*0.2083*POWER(100/150,1.852)*POWER(Pflow,1.852)/POWER((D22+0.000001),4.8655)","v":1.6641226733346763E-3},{"$f":"D30*(length+4.5)","v":0.23048099025685267},"(psi)",null,null,null,null,null,null,null,null,"π",": pi",null,null,null,null,null,null,null,null,null,null,null,2.9]
[null,null,{"$f":"C30/0.433","v":1.2096308721352496},null,{"$f":"E30/0.433","v":0.53228866110127637},"(ft of head)",null,null,null,null,null,null,null,null,"ΔT",": temperature difference between water and air",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ln",": natural logarithm",null,null,null,null,null,null,null,null,null,null,null,3.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ΔTw",": change in temperature of water as it flows",null,null,null,null,null,null,null,null,null,null,null,3.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dV",": Volumetric flow rate (gpm)",null,null,null,null,null,null,null,null,null,null,null,3.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"С",": constant that includes density and specific heat capacity of water at ~140°F, and a conversion factor from (gpm) to (ft3/hr)",null,null,null,null,null,null,null,null,null,null,null,3.4]
[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,3.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,null,3.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   C = 492.312 ((Btu*min) / (°F*gal*hr))",null,null,null,null,null,null,null,null,null,null,null,3.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"using:"," density (ρ) = 61.379 lb/ft3",null,null,null,null,null,null,null,null,null,null,3.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"specific heat (Cp) = 1 Btu/lb*°F",null,null,null,null,null,null,null,null,null,null,3.9]
[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,4]
[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,4.0999999999999996]
[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,4.2]
[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,4.3]
[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,4.4000000000000004]
[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,4.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,null,4.5999999999999996]
[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,4.7]
[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,4.8]
[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,4.9000000000000004]
[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,5]

{"sheet":"Cost Compare","index":11,"n_rows":40,"n_cols":19,"rows_kept":40,"cut":false,"hidden":false,"merged":[[20,11,20,14],[18,1,18,2],[13,9,13,11],[13,15,13,17],[24,11,24,14],[24,1,24,2],[21,11,21,14],[23,11,23,14],[27,11,27,14],[25,11,25,14],[29,11,29,14],[23,9,23,10],[27,9,27,10],[28,11,28,14]]}
[]
[1,"Enter local price of electricity, natural gas, and water in top 3 yellow cells (C15:C17). (initial values are national averages for first six months of 2012)"]
[2,"Enter total time (in hours per day) that circulation system will be operated in yellow cell under circulation operation (F15)."]
[3,"Enter the power rating of the circulator and efficiency of the water heater (C20:C21)"]
[null,"      * With No Recirculation, this sheet uses the estimate that stagnant water in pipe will cool to ambient every 2 operating hours"]
[null,"Notes:","Calculations on this sheet are based on differences in only the design of the hot water risers. "]
[null,null,"Gas fired hot water heaters are used in this comparison."]
[null,null,"All other parts of the water distribution system are assumed to be equal and do not affect any calculations on this page."]
[null,null,"Total water usage depends on installed fixtures, flow rates, and frequency of use (the numbers shown represent water usage strictly due to recirculating or waiting for hot water)."]
[null,null,"\"No Recirculation\" calculations are based on heating and replacing the water that will sit and cool in the riser every 2 hours."]
[]
[]
[null,null,null,null,null,"Total time per day*",null,null,null,"SmartLoop","Parallel","No Recirc",null,null,null,"SmartLoop","Parallel","No Recirc"]
[null,null,"cost per unit","sales unit",null," for comparison",null,null,null,"estimated weekly operating cost ",null,null,null,null,null,"estimated yearly operating cost"]
[null,"electricity",0.12,"$/kWh",null,8,"hr/day",null,"circulator",{"$f":"7*C20*C15*F15/1000","v":0.4032},{"$f":"7*C20*C15*F15/1000","v":0.4032},0,"$/week",null,"circulator",{"$f":"J15*52","v":20.9664},20.9664,0,"$/year"]
[null,"gas",1.03,"$/therm",null,null,null,null,"water heater",{"$f":"F15*7*C26*C16/100000/C21","v":10.193635544615384},{"$f":"F15*7*C27*C16/100000/C21","v":10.193635544615384},{"$f":"7*F15/2*C28*C16/100000","v":4.5877666385842524},"$/week",null,"water heater",530.06904831999998,530.06904831999998,238.56386520638114,"$/year"]
[null,"makeup water",2.37,"$/1000 gal",null,null,null,null,"water",0,0,{"$f":"7*C17/1000*C22*F15/2","v":1.4295236523950623},"$/week",null,"water",0,0,74.335229924543242,"$/year"]
[null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(J15:J17)","v":10.596835544615384},{"$f":"SUM(K15:K17)","v":10.596835544615384},{"$f":"SUM(L15:L17)","v":6.0172902909793144},"$/week",null,"Total:",551.03544832,551.03544832,312.89909513092437,"$/year"]
[null,"Ratings",null,null,null,null,null,null,"Water:",0,0,{"$f":"F15/2*C22*7","v":603.17453687555371},"gal/week",null,"Water:",{"$f":"J19*52","v":0},0,31365.075917528793,"gal/year"]
[null,"circulator:",60,"W"]
[null,"heater efficiency:",0.78,null,null,null,null,null,null,null,null,"Cost of Riser Installation:",null,null,null,{"$f":"Fittings!E28","v":6223.5064000000002},{"$f":"Fittings!H28","v":7557.2550000000001},{"$f":"Fittings!H28-Fittings!H9-SUM(Fittings!AA29:AA31)-(Fittings!F9*'Labor&Material'!M10)-(COUNT(Fittings!M8:M27)*'Labor&Material'!M46)","v":5573.1849999999995}]
[null,"riser volume",{"$f":"PI()/4*length*'Heat Loss'!D19*'Heat Loss'!D19/19.25","v":21.54194774555549},"gal",null,null,null,null,null,null,null,"Cost over \"No Recirc\"",null,null,null,{"$f":"P21-$R$21","v":650.32140000000072},{"$f":"Q21-$R$21","v":1984.0700000000006},{"$f":"R21-$R$21","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"First 5 years: ",null,"Cost for first five years",null,null,null,{"$f":"P21+(P18*5)","v":8978.6836416000006},{"$f":"Q21+(Q18*5)","v":10312.4322416},{"$f":"R21+(R18*5)","v":7137.6804756546207}]
[null,"Recirculation Type:",null,null,null,null,null,null,null,null,"(installation and operation)","Cost over \"No Recirc\"",null,null,null,{"$f":"P24-$R$24","v":1841.0031659453798},{"$f":"Q24-$R$24","v":3174.7517659453788},{"$f":"R24-$R$24","v":0}]
[null,"SmartLoop",{"$f":"flow*(heater-'Heat Loss'!K27)*492.312","v":13784.736000000001},"Btu/hr",null,null,null,null,null,null,null,"gallons of water wasted:",null,null,null,0,0,{"$f":"5*R19","v":156825.37958764395},"gallons"]
[null,"Parallel",{"$f":"flow*(heater-'Heat Loss'!L27)*492.312","v":13784.736000000001},"Btu/hr"]
[null,"No Recirculation",{"$f":"8.205*C22*(heater-'Cost Compare'!C31)","v":15907.651312705451},"Btu ",null,null,null,null,null,"First 10 years: ",null,"Cost for first ten years",null,null,null,{"$f":"P21+10*P18","v":11733.860883199999},{"$f":"Q21+10*Q18","v":13067.6094832},{"$f":"R21+10*R18","v":8702.1759513092438}]
[null,null,null,null,null,null,null,null,null,null,"(installation and operation)","Cost over \"No Recirc\"",null,null,null,{"$f":"P28-$R$28","v":3031.6849318907553},{"$f":"Q28-$R$28","v":4365.4335318907561},{"$f":"R28-$R$28","v":0}]
[null,"incoming cold",null,null,null,null,null,null,null,null,null,"gallons of water wasted:",null,null,null,0,0,{"$f":"10*R19","v":313650.75917528791},"gallons"]
[null,"water temperature",50,"°F"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"dQ = dV*ΔTh*C",null,null,null,"dQ: rate of heat transfer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dV: volumetric flow rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q = Vriser*ΔTh*C",null,null,null,"ΔTh: temperature difference between water entering and exiting heater"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C: constant that contains ρ, Cp, and a conversion from ft3 to gal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q: heat transfer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vriser: volume of riser"]

{"sheet":"scratch","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"wsfuGPM","index":13,"n_rows":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":true,"merged":[[2,3,2,4],[5,5,8,7],[13,6,13,7],[14,6,14,7],[19,6,19,7],[21,6,21,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[20,6,20,7]]}
[]
[]
[null,null,null,"demand"]
[null,null,"Load","tank","valve"]
[null,null,null,"(GPM)","(GPM)"]
[null,null,1,3,3,"note: zero fixtures allows the program to stop at one fixture unit. An input of zero is interpreted the same as blank."]
[null,null,{"$f":"C6+1","v":2},3,3]
[null,null,{"$f":"C7+1","v":3},5,5]
[null,null,4,6.5,6.5]
[null,null,5,8,8]
[null,null,6,9.4,15]
[null,null,7,10.7,17.399999999999999]
[null,null,8,11.8,19.8,null,null,null,0.5,0.75,1,1.25,1.5,2,2.5,3,3.5,4]
[null,null,9,12.8,22.2,null,"90 deg elbow",null,1,1.5,2.5,3,4,5.5,7,9,9,12.5]
[null,null,10,13.7,24.6,null,"45 deg elbow",null,0.5,0.5,1,1,1.5,2,2.5,3.5,3.5,5]
[null,null,11,14.6,27,null,"Tee, branch",null,2,2,4.5,5.5,7,9,12,15,14,21]
[null,null,12,15.4,27.8,null,"Tee, run",null,null,null,0,0.5,0.5,0.5,0.5,1,1,1]
[null,null,{"$f":"C17+1","v":13},16,28.6,null,"Coupling",null,null,null,null,0.5,0.5,0.5,0.5,1,1,1]
[null,null,14,16.5,29.4,null,"Ball Valve",null,null,null,0.5,0.5,0.5,0.5]
[null,null,15,17,30.2,null,"Gate Valve",null,null,null,null,null,null,0.5,1,1.5,2,2]
[null,null,16,17.5,31,null,"Butterfly Valve",null,null,null,null,null,null,7.5,10,15.5,null,16]
[null,null,{"$f":"C21+1","v":17},18,31.8,null,"Check Valve",null,2.5,2.5,4.5,5.5,6.5,9,11.5,14.5,12.5,18.5]
[null,null,18,18.399999999999999,32.6]
[null,null,19,18.8,33.4]
[null,null,{"$f":"C24+1","v":20},19.2,34.200000000000003]
[null,null,{"$f":"C25+5","v":25},19.600000000000001,35]
[null,null,30,21.5,38]
[null,null,35,23.3,42]
[null,null,40,24.9,44]
[null,null,45,26.3,46]
[null,null,50,27.7,48]
[null,null,{"$f":"C31+10","v":60},29.1,50]
[null,null,{"$f":"C32+10","v":70},32,54]
[null,null,{"$f":"C33+10","v":80},35,58]
[null,null,{"$f":"C34+10","v":90},38,61.2]
[null,null,{"$f":"C35+10","v":100},41,64.3]
[null,null,120,43.5,67.5]
[null,null,140,48,73]
[null,null,160,52.5,77]
[null,null,180,57,81]
[null,null,200,61,85.5]
[null,null,225,65,90]
[null,null,250,70,95.5]
[null,null,275,75,101]
[null,null,300,80,104.5]
[null,null,400,85,108]
[null,null,500,105,127]
[null,null,750,124,143]
[null,null,1000,170,177]
[null,null,1250,208,208]
[null,null,1500,239,239]
[null,null,1750,269,269]
[null,null,2000,297,297]
[null,null,2500,325,325]
[null,null,3000,380,380]
[null,null,4000,433,433]
[null,null,5000,525,525]
[null,null,5001,593,593]