{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Heat loss in pipes","Thermal Conductivity","References","k Values","\"A review on polymer...\"","Friction loss","Methods","scratch","Conversions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":374,"comments":2,"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":"Heat loss in pipes","index":0,"n_rows":57,"n_cols":31,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Heat Loss in Pipes (heat energy provided by Pipes)"]
["hlp"]
[]
[]
[]
[null,null,"Pipe","OD\" (nominal)",null,null,null,null,{"$f":"IF(I12>0,retFtInFrac2((I12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":""},null,{"$f":"IF(AND(K12>0,retSystemeBeingUsed()=\"US\"),retFtInFrac2((K12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(M12>0,retSystemeBeingUsed()=\"US\"),retFtInFrac2((M12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(O12>0,retSystemeBeingUsed()=\"US\"),retFtInFrac2((O12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(Q12>0,retSystemeBeingUsed()=\"US\"),retFtInFrac2((Q12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(S12>0,retSystemeBeingUsed()=\"US\"),retFtInFrac2((S12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(U12>0,retSystemeBeingUsed()=\"US\"),retFtInFrac2((U12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(W12>0,retSystemeBeingUsed()=\"US\"),retFtInFrac2((W12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AND(Y12>0,retSystemeBeingUsed()=\"US\"),retFtInFrac2((Y12/12),hlp_retFtIn_showAccuracy,hlp_retFtIn_fractionsToUse),\"\")","v":{"$error":"#VALUE!"}},null,null,null,"Fractions-to-use",32]
[null,null,null,"Material",null,null,null,null,"??",null,{"$f":"thC_PEX_MatlName","v":"PEX"},null,{"$f":"thC_PE_MatlName","v":"PE, black poly"},null,{"$f":"thC_PEX_MatlName","v":"PEX"},null,{"$f":"thC_PE_MatlName","v":"PE, black poly"},null,{"$f":"thC_PEX_MatlName","v":"PEX"},null,{"$f":"thC_PE_MatlName","v":"PE, black poly"},null,{"$f":"thC_PEX_MatlName","v":"PEX"},null,{"$f":"thC_PVC_MatlName","v":"PVC"},null,null,null,"Show accuracy",{"$f":"(1=1)","v":true}]
[null,null,null,"Systeme",null,null,null,null,null,null,"US",null,"US",null,"US",null,"US",null,"US",null,"US",null,"US",null,"US"]
[null,null,null,{"$f":"CONCATENATE(\"Cost/\",hlp_dat_CostPer_Length,hlp_dat_CostPer_Unit)","v":"Cost/100'"},null,null,100,"'",null,null,33.58,null,13.38,null,28.5,null,{"$f":"18.91","v":18.91},null,48.69,null,{"$f":"74.78/3 +N(\"price for 300 feet\")","v":24.926666666666666},null,70.3,null,{"$f":"3.76*10","v":37.599999999999994},null,null,null,"wt H₂O lbs/ft³",{"$f":"AD10*cnv_kgPerMCuToLbPerftCu","v":62.427960576000004},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}}]
[null,null,null,"Cost of elbows",null,null,null,null,null,null,0.33,null,0.44,null,1.51,null,0.72,null,{"$f":"99.99/50","v":1.9997999999999998},null,0.85,null,3.86,null,null,null,null,null,"wt H₂O kg/m³",1000,"kg"]
[null,null,null,"Nominal ID",null,null,null,null,null,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.375,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"1/2","v":0.5},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"0.5","v":0.5},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"3/4","v":0.75},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"3/4","v":0.75},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"1","v":1},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"1","v":1},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"1.25","v":1.25},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},null,null,"wt in use is:",{"$f":"IF(retSystemeBeingUsed()=\"US\",hlp_wtWaterInLbsPerFtCu,hlp_wtWaterInKgPerMCu)","v":{"$error":"#VALUE!"}},{"$f":"IF(retSystemeBeingUsed()=\"US\",AE9,AE10)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Actual ID",null,null,null,null,null,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.375,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.622,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.47499999999999998,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.82399999999999995,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.67100000000000004,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},1,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.88500000000000001,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},1.0329999999999999,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}}]
[null,null,null,"Actual OD",null,null,null,null,null,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.5,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.68200000000000005,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.5,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.94399999999999995,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},0.75,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},1.1140000000000001,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},1,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},1.3149999999999999,{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}}]
[null,null,null,"Thickness of wall",null,null,null,null,{"$f":"IF(I13>0,I13-I12,\"\")","v":""},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"IF(K13>0,K13-K12,\"\")","v":0.125},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M13>0,M13-M12,\"\")","v":6.0000000000000053E-2},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"IF(O13>0,O13-O12,\"\")","v":2.5000000000000022E-2},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"IF(Q13>0,Q13-Q12,\"\")","v":0.12},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"IF(S13>0,S13-S12,\"\")","v":7.8999999999999959E-2},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"IF(U13>0,U13-U12,\"\")","v":0.1140000000000001},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"IF(W13>0,W13-W12,\"\")","v":0.11499999999999999},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}},{"$f":"IF(Y13>0,Y13-Y12,\"\")","v":0.28200000000000003},{"$f":"retUnitsFor(\"subUnit\")","v":{"$error":"#VALUE!"}}]
[null,null,null,"Wt, per 100'",null,null,null,null,null,{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},4.5,{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},32,{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},5.3150000000000004,{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},8.1,{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},10.33,{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"168/9 + N(\"The site said 168 lbs per 300 ft. 56 lbs per 100? No way. I think they weighed all 300 and multipled by 3.\")","v":18.666666666666668},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},14.773999999999999,{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"3.214*10","v":32.14},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}}]
[null,null,null,"Max op temp",null,null,null,null,null,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}},200,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}},80,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}},200,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}},73,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}},200,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}},80,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}},200,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}},140,{"$f":"retUnitsFor(\"deg\")","v":{"$error":"#VALUE!"}}]
[null,null,null,"Max op pressure",null,null,null,null,null,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}},160,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}},125,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}},160,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}},80,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}},160,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}},100,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}},160,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}},450,{"$f":"retUnitsFor(\"pressure\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Bend? (F=fittings)",null,null,null,null,null,null,{"$f":"1=1","v":true},null,{"$f":"1=1","v":true},null,{"$f":"1=1","v":true},null,{"$f":"1=1","v":true},null,{"$f":"1=1","v":true},null,{"$f":"(1=0)","v":false},null,{"$f":"(1=0)","v":false},null,{"$f":"(1=0)","v":false}]
[null,null,"Pipe",{"$f":"CONCATENATE(\"Length/\",hlp_dat_LenPipeA,hlp_dat_CostPer_Unit)","v":"Length/100'"},null,null,100,{"$f":"hlp_dat_CostPer_Unit","v":"'"}]
[null,null,null,{"$f":"CONCATENATE(\"Length/\",hlp_dat_LenPipeB,hlp_dat_CostPer_Unit)","v":"Length/200'"},null,null,200,{"$f":"hlp_dat_CostPer_Unit","v":"'"}]
[null,null,null,{"$f":"CONCATENATE(\"Length/\",hlp_dat_LenPipeC,hlp_dat_CostPer_Unit)","v":"Length/300'"},null,null,300,{"$f":"hlp_dat_CostPer_Unit","v":"'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Wt H₂O in pipe, \")","v":"Wt H₂O in pipe, "}]
[null,null,null,{"$f":"CONCATENATE(\"Length/\",hlp_dat_LenPipeD,hlp_dat_CostPer_Unit)","v":"Length/150'"},null,null,150,{"$f":"hlp_dat_CostPer_Unit","v":"'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"₂₃²³"]
[]
[null,null,"Pipe",{"$f":"CONCATENATE(\"Cost @ \",hlp_dat_LenPipeA,hlp_dat_CostPer_Unit,\"\")","v":"Cost @ 100'"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_CostPer100Ft>0,(hlp_dat_0p00Pipe_Custom_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":""},null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p38Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":33.58},null,{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_0p50Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":13.38},null,{"$f":"IF(hlp_dat_0p50Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p50Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":28.499999999999996},null,{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_0p75Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":18.91},null,{"$f":"IF(hlp_dat_0p75Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p75Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":48.69},null,{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_1p00Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":24.926666666666666},null,{"$f":"IF(hlp_dat_1p00Pipe_Pex_CostPer100Ft>0,(hlp_dat_1p00Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":70.3},null,{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_CostPer100Ft>0,(hlp_dat_1p00Pipe_PvcSch40_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeA,\"\")","v":37.599999999999994},null,null,null,"Vol H₂O in pipe"]
[null,null,null,{"$f":"CONCATENATE(\"Cost @ \",hlp_dat_LenPipeB,hlp_dat_CostPer_Unit,\"\")","v":"Cost @ 200'"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_CostPer100Ft>0,(hlp_dat_0p00Pipe_Custom_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":""},null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p38Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":67.16},null,{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_0p50Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":26.76},null,{"$f":"IF(hlp_dat_0p50Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p50Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":56.999999999999993},null,{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_0p75Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":37.82},null,{"$f":"IF(hlp_dat_0p75Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p75Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":97.38},null,{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_1p00Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":49.853333333333332},null,{"$f":"IF(hlp_dat_1p00Pipe_Pex_CostPer100Ft>0,(hlp_dat_1p00Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":140.6},null,{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_CostPer100Ft>0,(hlp_dat_1p00Pipe_PvcSch40_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeB,\"\")","v":75.199999999999989},null,null,null,"Flow rate"]
[null,null,null,{"$f":"CONCATENATE(\"Cost @ \",hlp_dat_LenPipeC,hlp_dat_CostPer_Unit,\"\")","v":"Cost @ 300'"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_CostPer100Ft>0,(hlp_dat_0p00Pipe_Custom_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":""},null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p38Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":100.74},null,{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_0p50Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":40.14},null,{"$f":"IF(hlp_dat_0p50Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p50Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":85.499999999999986},null,{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_0p75Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":56.73},null,{"$f":"IF(hlp_dat_0p75Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p75Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":146.07},null,{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_1p00Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":74.78},null,{"$f":"IF(hlp_dat_1p00Pipe_Pex_CostPer100Ft>0,(hlp_dat_1p00Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":210.89999999999998},null,{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_CostPer100Ft>0,(hlp_dat_1p00Pipe_PvcSch40_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeC,\"\")","v":112.79999999999998}]
[null,null,null,{"$f":"CONCATENATE(\"Cost @ \",hlp_dat_LenPipeD,hlp_dat_CostPer_Unit,\"\")","v":"Cost @ 150'"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_CostPer100Ft>0,(hlp_dat_0p00Pipe_Custom_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":""},null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p38Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":50.37},null,{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_0p50Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":20.07},null,{"$f":"IF(hlp_dat_0p50Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p50Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":42.749999999999993},null,{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_0p75Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":28.364999999999998},null,{"$f":"IF(hlp_dat_0p75Pipe_Pex_CostPer100Ft>0,(hlp_dat_0p75Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":73.034999999999997},null,{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_CostPer100Ft>0,(hlp_dat_1p00Pipe_BlkPoly_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":37.39},null,{"$f":"IF(hlp_dat_1p00Pipe_Pex_CostPer100Ft>0,(hlp_dat_1p00Pipe_Pex_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":105.44999999999999},null,{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_CostPer100Ft>0,(hlp_dat_1p00Pipe_PvcSch40_CostPer100Ft/hlp_dat_CostPer_Length)*hlp_dat_LenPipeD,\"\")","v":56.399999999999991}]
[]
[null,null,"Surface",{"$f":"CONCATENATE(\"Area \",hlp_dat_LenPipeA,hlp_dat_CostPer_Unit,\"\")","v":"Area 100'"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_OD>0,PI()*((hlp_dat_0p00Pipe_Custom_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":""},"ft2",{"$f":"IF(hlp_dat_0p38Pipe_Pex_OD>0,PI()*((hlp_dat_0p38Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_OD>0,PI()*((hlp_dat_0p50Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_Pex_OD>0,PI()*((hlp_dat_0p50Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_OD>0,PI()*((hlp_dat_0p75Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_Pex_OD>0,PI()*((hlp_dat_0p75Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_OD>0,PI()*((hlp_dat_1p00Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_Pex_OD>0,PI()*((hlp_dat_1p00Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_OD>0,PI()*((hlp_dat_1p00Pipe_PvcSch40_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"Area \",hlp_dat_LenPipeB,hlp_dat_CostPer_Unit,\"\")","v":"Area 200'"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_OD>0,PI()*((hlp_dat_0p00Pipe_Custom_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":""},"ft2",{"$f":"IF(hlp_dat_0p38Pipe_Pex_OD>0,PI()*((hlp_dat_0p38Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_OD>0,PI()*((hlp_dat_0p50Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_Pex_OD>0,PI()*((hlp_dat_0p50Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_OD>0,PI()*((hlp_dat_0p75Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_Pex_OD>0,PI()*((hlp_dat_0p75Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_OD>0,PI()*((hlp_dat_1p00Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_Pex_OD>0,PI()*((hlp_dat_1p00Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_OD>0,PI()*((hlp_dat_1p00Pipe_PvcSch40_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"Area \",hlp_dat_LenPipeC,hlp_dat_CostPer_Unit,\"\")","v":"Area 300'"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_OD>0,PI()*((hlp_dat_0p00Pipe_Custom_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":""},"ft2",{"$f":"IF(hlp_dat_0p38Pipe_Pex_OD>0,PI()*((hlp_dat_0p38Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_OD>0,PI()*((hlp_dat_0p50Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_Pex_OD>0,PI()*((hlp_dat_0p50Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_OD>0,PI()*((hlp_dat_0p75Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_Pex_OD>0,PI()*((hlp_dat_0p75Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_OD>0,PI()*((hlp_dat_1p00Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_Pex_OD>0,PI()*((hlp_dat_1p00Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_OD>0,PI()*((hlp_dat_1p00Pipe_PvcSch40_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"Area \",hlp_dat_LenPipeD,hlp_dat_CostPer_Unit,\"\")","v":"Area 150'"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_OD>0,PI()*((hlp_dat_0p00Pipe_Custom_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":""},"ft2",{"$f":"IF(hlp_dat_0p38Pipe_Pex_OD>0,PI()*((hlp_dat_0p38Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_OD>0,PI()*((hlp_dat_0p50Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_Pex_OD>0,PI()*((hlp_dat_0p50Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_OD>0,PI()*((hlp_dat_0p75Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_Pex_OD>0,PI()*((hlp_dat_0p75Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_OD>0,PI()*((hlp_dat_1p00Pipe_BlkPoly_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_Pex_OD>0,PI()*((hlp_dat_1p00Pipe_Pex_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_OD>0,PI()*((hlp_dat_1p00Pipe_PvcSch40_OD*2)*retSystNumLenSubUnitsInUnits())*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Area\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,{"$f":"CONCATENATE(\"Vol H₂O in pipe\")","v":"Vol H₂O in pipe"},{"$f":"CONCATENATE(\"for \",hlp_dat_LenPipeA,hlp_dat_CostPer_Unit,\" len\")","v":"for 100' len"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_ID>0,(0.25*PI())*( (hlp_dat_0p00Pipe_Custom_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":""},null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_0p38Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_0p50Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_Pex_OD>0,(0.25*PI())*( (hlp_dat_0p50Pipe_Pex_OD*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_0p75Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_0p75Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_PvcSch40_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeA,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"for \",hlp_dat_LenPipeB,hlp_dat_CostPer_Unit,\" len\")","v":"for 200' len"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_ID>0,(0.25*PI())*( (hlp_dat_0p00Pipe_Custom_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":""},null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_0p38Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_0p50Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_Pex_OD>0,(0.25*PI())*( (hlp_dat_0p50Pipe_Pex_OD*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_0p75Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_0p75Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_PvcSch40_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeB,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"for \",hlp_dat_LenPipeC,hlp_dat_CostPer_Unit,\" len\")","v":"for 300' len"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_ID>0,(0.25*PI())*( (hlp_dat_0p00Pipe_Custom_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":""},null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_0p38Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_0p50Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_Pex_OD>0,(0.25*PI())*( (hlp_dat_0p50Pipe_Pex_OD*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_0p75Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_0p75Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_PvcSch40_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"for \",hlp_dat_LenPipeD,hlp_dat_CostPer_Unit,\" len\")","v":"for 150' len"},null,null,null,null,{"$f":"IF(hlp_dat_0p00Pipe_Custom_ID>0,(0.25*PI())*( (hlp_dat_0p00Pipe_Custom_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeD,\"\")","v":""},null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_0p38Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_0p50Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeC,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p50Pipe_Pex_OD>0,(0.25*PI())*( (hlp_dat_0p50Pipe_Pex_OD*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_0p75Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p75Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_0p75Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_BlkPoly_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_BlkPoly_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_Pex_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_Pex_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_1p00Pipe_PvcSch40_ID>0,(0.25*PI())*( (hlp_dat_1p00Pipe_PvcSch40_ID*retSystNumLenSubUnitsInUnits())^2 )*hlp_dat_LenPipeD,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Vol\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,{"$f":"CONCATENATE(\"Wt H₂O in pipe\")","v":"Wt H₂O in pipe"},{"$f":"CONCATENATE(\"for \",hlp_dat_LenPipeA,hlp_dat_CostPer_Unit,\" len\")","v":"for 100' len"},null,null,null,null,null,null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,K35*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,M35*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,O35*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,Q35*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,S35*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,U35*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,W35*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,Y35*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"for \",hlp_dat_LenPipeB,hlp_dat_CostPer_Unit,\" len\")","v":"for 200' len"},null,null,null,null,null,null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,K36*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,M36*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,O36*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,Q36*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,S36*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,U36*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,W36*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,Y36*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"for \",hlp_dat_LenPipeC,hlp_dat_CostPer_Unit,\" len\")","v":"for 300' len"},null,null,null,null,null,null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,K37*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,M37*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,O37*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,Q37*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,S37*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,U37*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,W37*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,Y37*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CONCATENATE(\"for \",hlp_dat_LenPipeD,hlp_dat_CostPer_Unit,\" len\")","v":"for 150' len"},null,null,null,null,null,null,{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,K38*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,M38*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,O38*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,Q38*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,S38*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,U38*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,W38*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}},{"$f":"IF(hlp_dat_0p38Pipe_Pex_ID>0,Y38*hlp_wtWaterInUse,\"\")","v":{"$error":"#VALUE!"}},{"$f":"retUnitsFor(\"Wt\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,"R-value calculated",null,null,null,null,null,null,null,{"$f":"(hlp_dat_0p38Pipe_Pex_OD*((((LN(hlp_dat_0p38Pipe_Pex_OD/hlp_dat_0p38Pipe_Pex_ID)))/tstCellRet())+(1/(tstCellRet()*hlp_dat_0p38Pipe_Pex_OD))))","v":1.3293050734030682},null,{"$f":"(hlp_dat_0p50Pipe_BlkPoly_OD*(LN(hlp_dat_0p50Pipe_BlkPoly_OD/hlp_dat_0p50Pipe_BlkPoly_ID)))/tstCellRet()","v":8.2751409794553948E-2},null,{"$f":"(hlp_dat_0p50Pipe_Pex_OD*(LN(hlp_dat_0p50Pipe_Pex_OD/hlp_dat_0p50Pipe_Pex_ID)))/tstCellRet()","v":2.9805031600327478E-2},null,{"$f":"(hlp_dat_0p75Pipe_BlkPoly_OD*(LN(hlp_dat_0p75Pipe_BlkPoly_OD/hlp_dat_0p75Pipe_BlkPoly_ID)))/tstCellRet()","v":0.16910241721049551},null,{"$f":"(hlp_dat_0p75Pipe_Pex_OD*(LN(hlp_dat_0p75Pipe_Pex_OD/hlp_dat_0p75Pipe_Pex_ID)))/tstCellRet()","v":9.7013304079563406E-2},null,{"$f":"(hlp_dat_1p00Pipe_BlkPoly_OD*(LN(hlp_dat_1p00Pipe_BlkPoly_OD/hlp_dat_1p00Pipe_BlkPoly_ID)))/tstCellRet()","v":0.15845909539306022},null,{"$f":"(hlp_dat_1p00Pipe_Pex_OD*(LN(hlp_dat_1p00Pipe_Pex_OD/hlp_dat_1p00Pipe_Pex_ID)))/tstCellRet()","v":0.1419760705415819},null,{"$f":"(hlp_dat_1p00Pipe_PvcSch40_OD*(LN(hlp_dat_1p00Pipe_PvcSch40_OD/hlp_dat_1p00Pipe_PvcSch40_ID)))/tstCellRet()","v":1.0123536602970598}]
[]
[null,null,"Temperature, ","target, °F",null,null,95,"°F",null,null,{"$f":"(PI()*(hlp_dat_tempTarget_degF-hlp_dat_tempAmbient_degF))/(LN(hlp_dat_0p38Pipe_Pex_OD/hlp_dat_0p38Pipe_Pex_ID))","v":709.82359360458111},"BTU/ft"]
[null,null,null,"target, °C",null,null,{"$f":"convTempFtoC(G47)","v":35},"°C",null,null,null,null,{"$f":"(PI()*(hlp_dat_tempTarget_degF-hlp_dat_tempAmbient_degF))","v":204.20352248333654},null,"=(PI()*(hlp_dat_tempTarget_degF-hlp_dat_tempAmbient_degF))"]
[null,null,null,"ambient, °F",null,null,30,"°F",null,null,{"$f":"ROUND(tstCellRet(),2)","v":0.86},null,{"$f":"(LN(hlp_dat_0p38Pipe_Pex_OD/hlp_dat_0p38Pipe_Pex_ID))/2*K49","v":0.12370329115426576},null,"=(LN(hlp_dat_0p38Pipe_Pex_OD/hlp_dat_0p38Pipe_Pex_ID))"]
[null,null,null,"ambient, °C",null,null,{"$f":"convTempFtoC(G49)","v":-1.1111111111111112},"°C"]
[]
[]
[]
[]
[null,null,null,"ft2/sec"]
[null,null,null,"Heat loss per ft",null,null,null,null,null,null,"cond format so that values that equal values in prev corresp col are not shown"]
[null,null,null,"Feet to achieve ambient"]

{"sheet":"Thermal Conductivity","index":1,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,17,6,18]]}
["Thermal Conductivity"]
["thC"]
[null,null,null,null,null,null,"SI =",{"$f":"cnv__name_WPerMDegC","v":"W m-1 °C-1"},null,1]
[null,null,null,null,null,null,"US =",{"$f":"cnv__name_BtuFtPerHrPerInSqDegF","v":"BTU ft hr-1 in-2 °F-1"},null,{"$f":"J3*cnv_wPerMDegCToBtuFtPerHrPerInSqDegF","v":0.14422788886428259}]
[]
[]
[{"$f":"MIN(A9:A42)","v":2.0113584841414194},{"$f":"MIN(B9:B42)","v":1.1621414438750315},null,null,null,null,"k-Value"]
["R-value",null,null,"Code","Pipe material",null,"Average","…refs"]
[{"$f":"1/G10","v":3.5465328892664849},{"$f":"1/G11","v":2.0491488141865468},null,"ABS","ABS [acrylonitrile-butadiene-styrene]","Refs",null,{"$f":"CONCATENATE(References!$D$30)","v":"24"},{"$f":"CONCATENATE(References!$D$31)","v":"25"}]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H10:J10)>0,AVERAGE(H10:Q10),\"\")","v":0.28196552272967246},{"$f":"H11*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.36922339549256344},{"$f":"I11*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.1947076499667815}]
[null,null,null,null,null,"US",{"$f":"G10*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.48800750490977457},2.56,1.35]
[{"$f":"1/G13","v":7.6923076923076916},{"$f":"1/G14","v":4.444533204176909},null,"ButylRubber","Butyl rubber [Poly(isobutylene)]","Refs",null,{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$18,\",\",References!$D$19)","v":"6,12,13"}]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H13:J13)>0,AVERAGE(H13:Q13),\"\")","v":0.13},0.13]
[null,null,null,null,null,"US",{"$f":"G13*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.22499550662828086}]
[{"$f":"1/G16","v":7.0366071675499438},{"$f":"1/G17","v":4.0656764461202437},null,"CPVC","CPVC [Poly(vinyl chloride)]","Refs",null,{"$f":"CONCATENATE(References!$D$16)","v":"10"},{"$f":"CONCATENATE(References!$D$31)","v":"25"}]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H16:K16)>0,AVERAGE(H16:Q16),\"\")","v":0.14211394443214131},0.14000000000000001,{"$f":"I17*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.14422788886428259}]
[null,null,null,null,null,"US",{"$f":"G16*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.24596153020348452},null,1]
[{"$f":"1/G19","v":2.8169014084507045},{"$f":"1/G20","v":1.6275755395577411},null,"EPDM","EPDM [Ethylene-propylene-diene monomer]","Refs",null,{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$13,\",\",References!$D$14,\",\",References!$D$15)","v":"6,7,8,9"}]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H19:K19)>0,AVERAGE(H19:Q19),\"\")","v":0.35499999999999998},0.35499999999999998]
[null,null,null,null,null,"US",{"$f":"G19*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.61441080656184388}]
[{"$f":"1/G22","v":4.5707889514412665},{"$f":"1/G23","v":2.6409530243155364},null,"PB","PB [Poly(butene-1)]","Refs",null,{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$20)","v":"6,14"},{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$20)","v":"6,14"},{"$f":"CONCATENATE(References!$D$30)","v":"24"}]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H22:K22)>0,AVERAGE(H22:Q22),\"\")","v":0.21878061109880798},0.22,0.22,{"$f":"J23*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.21634183329642387}]
[null,null,null,null,null,"US",{"$f":"G22*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.37865118795862451},null,null,1.5]
[{"$f":"1/G25","v":2.2804003412880354},{"$f":"1/G26","v":1.3175909546372335},null,"PE, black poly","PE, HDPE, LPE [Polyethylene, linear high density, etc.]","Refs",null,{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$17)","v":"6,11"},{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$17)","v":"6,11"},{"$f":"CONCATENATE(References!$D$16)","v":"10"},{"$f":"CONCATENATE(References!$D$29)","v":"23"},{"$f":"CONCATENATE(References!$D$29)","v":"23"},{"$f":"CONCATENATE(References!$D$30)","v":"24"},{"$f":"CONCATENATE(References!$D$31)","v":"25"},26]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H25:K25)>0,AVERAGE(H25:Q25),\"\")","v":0.43851949234281007},0.52,0.52,0.38,0.42,0.51,{"$f":"M26*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.39662669437677711},{"$f":"N26*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.46152924436570431},0.3]
[null,null,null,null,null,"US",{"$f":"G25*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.75896088727728517},null,null,null,null,null,2.75,3.2]
[{"$f":"1/G28","v":4},{"$f":"1/G29","v":2.3111572661719926},null,"PEEK","PEEK [Poly(ether ether ketone)]","Refs",null,{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$21)","v":"6,15"}]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H28:K28)>0,AVERAGE(H28:Q28),\"\")","v":0.25},0.25]
[null,null,null,null,null,"US",{"$f":"G28*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.43268366659284779}]
[{"$f":"1/G31","v":2.0113584841414194},{"$f":"1/G32","v":1.1621414438750315},null,"PEX","PEX [Polyethylene, linear high density cross-linked]","Refs",null,{"$f":"CONCATENATE(References!$D$16)","v":"10"},{"$f":"CONCATENATE(References!$D$17)","v":"11"},{"$f":"CONCATENATE(References!$D$30)","v":"24"}]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H31:K31)>0,AVERAGE(H31:Q31),\"\")","v":0.49717641478856817},0.51,0.52,{"$f":"J32*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.46152924436570431}]
[null,null,null,null,null,"US",{"$f":"G31*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.86048045637681692},null,null,3.2]
[{"$f":"1/G34","v":7.2727272727272734},{"$f":"1/G35","v":4.2021041203127139},null,"PP","PP [Polyproplene]","Refs",null,{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$22)","v":"6,16"},{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$22)","v":"6,16"},{"$f":"CONCATENATE(References!$D$29)","v":"23"},26]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H34:K34)>0,AVERAGE(H34:Q34),\"\")","v":0.13749999999999998},0.12,0.22,0.1,0.11]
[null,null,null,null,null,"US",{"$f":"G34*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.23797601662606627}]
[{"$f":"1/G37","v":8.928571428571427},{"$f":"1/G38","v":5.1588331834196248},null,"PS","PS [Polystyrene, Styrofoam]","Refs",null,{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$23,\",\",References!$D$24,\",\",References!$D$25)","v":"6,17,18,19"},{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$23,\",\",References!$D$24,\",\",References!$D$25)","v":"6,17,18,19"},{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$23,\",\",References!$D$24,\",\",References!$D$25)","v":"6,17,18,19"},{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$23,\",\",References!$D$24,\",\",References!$D$25)","v":"6,17,18,19"},26]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H37:K37)>0,AVERAGE(H37:Q37),\"\")","v":0.11200000000000002},0.105,0.105,0.105,0.105,0.14000000000000001]
[null,null,null,null,null,"US",{"$f":"G37*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.19384228263359585}]
[{"$f":"1/G40","v":3.6683244697527981},{"$f":"1/G41","v":2.119518688236425},null,"PTFE, Teflon","PTFE, Teflon [Poly(tetrafluoroethylene)]","Refs",null,{"$f":"CONCATENATE(References!$D$12,\",\",References!$D$26)","v":"6,20"},{"$f":"CONCATENATE(References!$D$29)","v":"23"},26,null,null,"(Ref 6&20 say \"(4.86 x 10-4)T + 0.253\")",null,null,{"$f":"CONCATENATE(\"T = \",INT(convTempCtoK(25)),\"°K\")","v":"T = 298°K"},"T = 25°C"]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H40:K40)>0,AVERAGE(H40:L40),\"\")","v":0.27260402078537732},{"$f":"Q40","v":0.29781206235613189},0.25,0.27,null,null,null,null,null,{"$f":"((4.86^-4)*convTempCtoK(25))+0.253","v":0.78742865565922882},{"$f":"((4.86^-4)*25)+0.253","v":0.29781206235613189}]
[null,null,null,null,null,"US",{"$f":"G40*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.47180522896547983}]
[{"$f":"1/G43","v":5.5201979383454214},{"$f":"1/G44","v":3.1895113939786683},null,"PVC","PVC [Poly(vinyl chloride)]","Refs",null,{"$f":"CONCATENATE(References!$D$27)","v":"21"},{"$f":"CONCATENATE(References!$D$27)","v":"21"},{"$f":"CONCATENATE(References!$D$27)","v":"21"},{"$f":"CONCATENATE(References!$D$27)","v":"21"},{"$f":"CONCATENATE(References!D28)","v":"22"},{"$f":"CONCATENATE(References!$D$16)","v":"10"},{"$f":"CONCATENATE(References!$D$30)","v":"24"},{"$f":"CONCATENATE(References!$D$31)","v":"25"}]
[null,null,null,null,null,"SI",{"$f":"IF(SUM(H43:K43)>0,AVERAGE(H43:Q43),\"\")","v":0.18115292443657044},0.14000000000000001,0.28000000000000003,0.14000000000000001,0.17,0.16,0.19,{"$f":"N44*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.21057271774185257},{"$f":"O44*(cnv_wPerMDegCToBtuFtPerHrPerInSqDegF)","v":0.15865067775071087}]
[null,null,null,null,null,"US",{"$f":"G43*cnv_wPerMDegCToBtuFtPerHrPerFtSqDegF","v":0.31352764623692958},null,null,null,null,null,null,1.46,1.1000000000000001]

{"sheet":"References","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["References"]
["ref"]
[]
[null,null,null,0]
[]
[null,null,null,"Reference #"]
[null,null,null,{"$f":"IF(AND(E7<>\"\",NOT(ISNUMBER(D6))),1,IF(E7<>\"\",D6+1,\"\"))","v":1}," Charlotte_Plastics-Technical-and-Installation-Manual.pdf"]
[null,null,null,2,"http://www.coolinterview.com/interview/53980/"]
[null,null,null,3,"The Complete Biogas Handbook"]
[null,null,null,4,"\"Insulating-Plastic-Pipes-(CPVC-and-PEX)-in-Residential-and-Commercial-Applications.pdf\" in B:\\_Reference books\\Buildings-and-materials\\Pipes-and-Piping\\Plastic-thermal"]
[null,null,null,5,"\"R-Value-and-Thermal-Conductivity-of-PEX-and-PE-RT.pdf\",  in B:\\_Reference books\\Buildings-and-materials\\Pipes-and-Piping\\Plastic-thermal"]
[null,null,null,6,"\"Polymer-Data-Handbook. pdf\", in B:\\_Reference books\\Plastics"]
[null,null,null,7,"Baldwin, F. P., and G. Ver Strate. Rubber Reviews 44 (1972): 709."]
[null,null,null,8,"Ver Strate, G. In Encyclopedia of Polymer Science and Engineering, 2d ed., edited by H. F. Mark, et al. John Wiley and Sons, New York, 1987, vol. 6, p. 522."]
[null,null,null,9,"Mark, H. F., et al., eds. Encyclopedia of Chemical Technology. Wiley-Interscience, New York, 1978."]
[null,null,null,10,"Patterson and Miers, \"The Thermal Conductivity of Common Tubing Materials Applied in a Solar Water Heater Collector\""]
[null,null,null,11,"Yang, Y. In Physical Properties of Polymer Handbook, edited by J. E. Mark. AIP Press, Woodbury, N.Y., 1996, p. 111."]
[null,null,null,12,"Nasr, G. M., et al. Polym. Degradation Stab. 48 (1995): 237."]
[null,null,null,13,"Goldsmith, T. E. Waterman, and J. Hirschborn, eds. Handbook of Thermoproperties and Solid Materials. Macmillan, New York, 1961, vol. IV."]
[null,null,null,14,"Chatterjee. A. M. In Encyclopedia of Polymer Science and Engineering, 2d ed., edited by J. I.  Kroschwitz. John Wiley and Sons, New York, 1985, vol. 2."]
[null,null,null,15,"May, R. In Encyclopedia of Polymer Science and Engineering, edited by J. I. Kroschwitz. John Wiley and Sons, New York, 1990, Vol. 12, pp. 313-320."]
[null,null,null,16,"Thompson, E. V.. In Encyclopedia of Polymer Science and Engineering, edited by H. F. Mark, et al. Wiley-Interscience, New York, 1985, vol. 16, pp. 711-747."]
[null,null,null,17,"Brandrup, J., and E. H. Immergut. Polymer Handbook, 3d ed. Wiley-Interscience, New York, 1989"]
[null,null,null,18,"Mark, J. E., ed. Physical Properties of Polymers Handbook. AIP Press, Woodbury, New York, 1996"]
[null,null,null,19,"Boyer, R. F. In Encyclopedia of Polymer Science and Technology, edited by H. F. Mark, et al. John Wiley and Sons, New York, 1970, vol. 13."]
[null,null,null,20,"Sperati, C. A. In Polymer Handbook, 3 ed., Vol. 35, edited by J. Brandrup and E. H. Immergut. John Wiley and Sons, New York, 1989."]
[null,null,null,21,"W. V. Titow (31 December 1984). PVC technology. Springer. pp. 6–. ISBN 978-0-85334-249-6. Retrieved 6 October 2011."]
[null,null,null,22,"http://www.vinidex.com.au/technical/material-properties/pvc-properties/"]
[null,null,null,23,"http://americandreamgeothermal.com/thermal-conductivity-myths-and-facts-copper-plastic-air-and-water/"]
[null,null,null,{"$f":"IF(AND(E30<>\"\",NOT(ISNUMBER(D29))),1,IF(E30<>\"\",D29+1,\"\"))","v":24},"Typical-Properties-of-Plastic-Pipe-Materials.pdf"]
[null,null,null,25,"Piping-Handbook.pdf"]
[null,null,null,26,"C. T'Joena et al, \"A review on polymer heat exchangers for HVAC&R applications\" International Journal of Refrigeration, 32(5), pp 763–779, 2009"]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"k Values","index":3,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[7,20,7,21]]}
["k Values, and other stuff"]
["kval"]
[null,null,null,null,null,null,null,null,"This equation yields an “R” value on a square foot basis [for a pipe]",null,null,null,null,null,"For a flat surface, R-value is the reciprocal of the k-value, thus a lower R-value means greater heat "]
[null,null,null,null,null,null,null,null,null,null,"where:","r1 = ID",null,null,"conduction and vice versa. The letter “R” is placed before the numerical value, as in R19 or R-19. "]
[null,null,null,null,null,null,null,null,null,null,null,"r2 = OD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(BTU-in)/(ft2 hr °F) = 0.1442279 W/(m °K)"]
[null,null,null,"Thermal Conductivity"]
[null,null,null,null,null,null,null,null,"R-Value",null,null,null,null,null,"k-Value","k= thermal conductivity (BTU-in/hr ft2°F)",null,null,null,null,"Thermal Conductivity"]
[null,null,null,null,"Pipe material",null,null,null,"(Average)","Ref 1","Ref 2","Ref 7","Ref 4","Ref 5","(Average)","Ref 1","Ref 6","Ref 7","Ref 4","Ref 5","(BTU-in)/(ft2 hr °F)","W/(m°K)"]
[null,null,null,null,null,"ABS",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P10:S10)>0,AVERAGE(P10:S10),\"\")","v":""}]
[null,null,null,null,null,"CPVC",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P11:S11)>0,AVERAGE(P11:S11),\"\")","v":0.95},0.95]
[null,null,null,null,null,null,{"$f":"0.5","v":0.5},"\"",{"$f":"IF(SUM(J12:M12)>0,AVERAGE(J12:M12),\"\")","v":7.5499999999999998E-2},7.0999999999999994E-2,0.08,null,null,null,{"$f":"IF(SUM(P12:S12)>0,AVERAGE(P12:S12),\"\")","v":""}]
[null,null,null,null,null,null,0.75,"\"",8.6499999999999994E-2,8.3000000000000004E-2,0.09,null,null,null,""]
[null,null,null,null,null,null,{"$f":"1","v":1},"\"",0.11299999999999999,0.106,0.12]
[null,null,null,null,null,null,{"$f":"1.25","v":1.25},"\"",0.14000000000000001,0.13,0.15]
[null,null,null,null,null,null,{"$f":"1.5","v":1.5},"\"",0.16200000000000001,0.154,0.17]
[null,null,null,null,null,null,{"$f":"2","v":2},"\"",0.21050000000000002,0.20100000000000001,0.22,null,null,null,""]
[null,null,null,null,null,"PE",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Black poly"]
[null,null,null,null,null,"PE, HD",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"PE, low",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"PE, med",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"PE, ultra HD",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,"Ref 7"]
[null,null,null,null,null,"PE RT",null,null,null,null,null,null,null,null,3.15,null,null,3.15,null,null,null,0.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"PEX",null,null,null,null,null,null,null,null,2.63,2.4,2.86,null,null,null,null,0.41]
[null,null,null,null,null,null,{"$f":"0.5","v":0.5},"\"",{"$f":"IF(SUM(J27:M27)>0,AVERAGE(J27:M27),\"\")","v":3.4000000000000002E-2},null,0.04,2.8000000000000001E-2,null,null,""]
[null,null,null,null,null,null,0.75,"\"",4.3999999999999997E-2,null,0.05,3.7999999999999999E-2,null,null,""]
[null,null,null,null,null,null,{"$f":"1","v":1},"\"",5.45E-2,null,0.06,4.9000000000000002E-2,null,null,""]
[null,null,null,null,null,null,{"$f":"1.25","v":1.25},"\"",7.0000000000000007E-2,null,0.08,0.06,null,null,""]
[null,null,null,null,null,null,{"$f":"1.5","v":1.5},"\"",8.0999999999999989E-2,null,0.09,7.1999999999999995E-2,null,null,""]
[null,null,null,null,null,null,{"$f":"2","v":2},"\"",0.1065,null,0.12,9.2999999999999999E-2,null,null,""]
[null,null,null,null,null,"PP",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"PVC, sch 40",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"0.5","v":0.5},"\"",{"$f":"IF(SUM(J35:M35)>0,AVERAGE(J35:M35),\"\")","v":3.1E-2},3.1E-2,null,null,null,null,"",null,null,null,null,null,0.109]
[null,null,null,null,null,null,0.75,"\"",3.2000000000000001E-2,3.2000000000000001E-2,null,null,null,null,"",null,null,null,null,null,0.113]
[null,null,null,null,null,null,{"$f":"1","v":1},"\"",3.7999999999999999E-2,3.7999999999999999E-2,null,null,null,null,"",null,null,null,null,null,0.13300000000000001]
[null,null,null,null,null,null,{"$f":"1.25","v":1.25},"\"",0.04,0.04,null,null,null,null,"",null,null,null,null,null,0.14000000000000001]
[null,null,null,null,null,null,{"$f":"1.5","v":1.5},"\"",4.1000000000000002E-2,4.1000000000000002E-2,null,null,null,null,"",null,null,null,null,null,0.14499999999999999]
[null,null,null,null,null,null,{"$f":"2","v":2},"\"",4.3999999999999997E-2,4.3999999999999997E-2,null,null,null,null,"",null,null,null,null,null,0.154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Copper",null,null,null,null,null,null,null,null,2616,2616,null,null,null,null,196,28]

{"sheet":"\"A review on polymer...\"","index":4,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Properties","Ionomer","LDPE","Nylon-6.6","PC ","PEEK","PPS","PPSU","PP","PS","PSU","PTFE","PVDF"]
["Density, g/cc",0.95499999999999996,0.92300000000000004,1.1200000000000001,1.2,1.33,1.43,1.29,0.93700000000000006,1.05,1.24,2.17,1.78]
["Water absorption, %",0.01,6.7000000000000004E-2,2.2999999999999998,0.17,0.21,3.1E-2,0.37,7.9000000000000001E-2,8.7999999999999995E-2,0.41,4.1999999999999997E-3,3.2000000000000001E-2]
["Moisture absorption at equilibrium, %",1.0999999999999999E-2,0.01,2,0.27,0.46,0.03,0.85,0.1,8.8999999999999996E-2,0.32,null,1.7999999999999999E-2]
["Tensile strength, ultimate, MPa",27.1,11,73.099999999999994,64,110,86.7,76,36.799999999999997,44.9,72,33.6,42.8]
["Tensile strength, yield, MPa",14.3,10.8,63.6,62,98.8,68.900000000000006,72,30.7,43.9,74.900000000000006,11.6,44]
["Elongation at break, %",440,190,82.8,98,36.700000000000003,4.0999999999999996,60,120,6.9,56.8,400,64.599999999999994]
["Tensile modulus, GPa",0.3,0.21,2.1,2.2999999999999998,4.5,3.6,7.2,1.9,3,2.5,0.61,1.8]
["Flexural modulus, GPa",0.25,0.27,2.4,2.2999999999999998,4.8,4.9000000000000004,2.4,1.4,2.8,2.8,0.52,1.7]
["Flexural yield strength, MPa",null,null,88.4,91.8,170,140,130,36.200000000000003,84.2,100,null,44.2]
["CTE, linear 20 °C, mm/m-°C",150,210,100,70.2,44.1,39.200000000000003,55.8,120,79.8,60.1,100,140]
["CTE, linear 100 °C, mm/m-°C",null,null,100,65,39.200000000000003,170,55,null,null,60,140,145]
["Thermal conductivity, W/m-K",0.24,0.3,0.26,0.2,0.25,0.3,0.35,0.11,0.14000000000000001,0.22,0.27,0.19]
["Melting point, °C",85.1,110,250,null,340,280,null,160,null,null,330,160]
["Glass temperature, °C",null,null,null,150,140,88,220,null,90.4,190,null,-37.6]
["Specific heat capacity, J/g-°C",2.4,2.2000000000000002,2.2000000000000002,1.2,2,null,null,2,2.1,1.2,1.4,1.5]
[]
[null,"from C. T'Joena et al, \"A review on polymer heat exchangers for HVAC&R applications\" International Journal of Refrigeration, 32(5), pp 763–779, 2009"]
[]
[]
[null,"\"Polyethylene (PE) has a comparatively low density. It is sufficiently"]
[null,"robust to be virtually unbreakable, and at the same"]
[null,"time, it is quite flexible. Chemically, PE is inert at room"]
[null,"temperature although it is slowly attacked by strong oxidizing"]
[null,"agents, and some solvents will cause softening or swelling. It"]
[null,"may be used at temperatures up to 95°C for short periods and"]
[null,"at 80°C continuously.\"",null,null,null,null,null,{"$f":"convTempCtoF(80)","v":176},"°F"]

{"sheet":"Friction loss","index":5,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,2,61,18]]}
[]
[]
[]
[null,null,null,null,"mention that some metals will easily form a crust, thus diminishing the heat transfer depending on time and temperature of the pipe"]
[]
[]
[]
[]
[]
[null,null,null,null,"Fitting","1⁄2”","3⁄4”","1”","11⁄4”","11⁄2”","2”","21⁄2”"]
[null,null,null,null,"Tee (Run)",1,1.4,1.7,2.2999999999999998,2.7,4.3,5.0999999999999996]
[null,null,null,null,"Tee (Branch)",4,5,6,7.3,8.4,12,15]
[null,null,null,null,"90° Elbow",1.5,2,2.5,3.8,4,5.7,6.9]
[null,null,null,null,"45° Elbow",0.8,1.1000000000000001,1.4,1.8,2.1,2.6,3.1]
[null,null,null,null,"    Male/Female Adapter ",1,1.5,2,2.75,3.5,4.5,5.5]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Frictional Losses for CTS CPVC Pipe",null,null,null,"from BOW-Flowgaurd-Gold-Product-Installation-Guide.pdf, "]
[null,null,null,null,null,null,null,null,null,null,null,null,"at Different Water Velocities",null,null,null,"in B:\\_Reference books\\Buildings-and-materials\\Pipes-and-Piping\\Plastic-thermal"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"v","1/2\"",null,"3/4\"",null,"1\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q","P","Q","P","Q","P"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,1.1399999999999999,1.86,2.4700000000000002,1.2,4.1100000000000003,0.9]
[null,null,null,null,null,null,null,null,"V = Water Velocity, ft. per sec.",null,null,null,4,2.29,6.75,4.9400000000000004,4.34,8.2200000000000006,3.24]
[null,null,null,null,null,null,null,null,"Q = Flow Rate, gal/min.",null,null,null,5,2.87,10.25,6.17,6.55,10.27,4.8899999999999997]
[null,null,null,null,null,null,null,null,"P = Pressure Loss, PSI per 100 ft.",null,null,null,6,3.44,14.34,7.4,9.18,12.32,6.85]
[null,null,null,{"$f":"3*28","v":84},null,null,null,null,null,null,null,null,8,4.59,24.45,9.8699999999999992,15.65,16.43,11.68]
[null,null,null,null,null,null,null,null,null,null,null,null,10,5.74,37,12.34,23.66,20.54,17.66]
[null,null,null,null,null,null,null,null,null,null,null,null,"v",null,"1-1/4\"",null,"1-1/2\"",null,"2\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q","P","Q","P","Q","P"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,6.14,0.71,8.58,0.57999999999999996,14.72,0.44]
[null,null,"Specific heat of cow dung, c1= 2.79925 KJ/Kg0C",null,null,null,null,null,null,null,null,null,4,12.29,2.57,17.170000000000002,2.1,29.44,1.6]
[null,null,"Specific heat of water, c1=4.186 KJ/KgOC",null,null,null,null,null,null,null,null,null,5,15.36,3.89,21.46,3.17,36.81,2.41]
[null,null,"Average specific heat of manure= (c1+ c2)/2",null,null,null,null,null,null,null,null,null,6,18.43,5.45,25.75,4.4400000000000004,44.17,3.38]
[null,null,{"$f":" (2.79925+4.186)/2","v":3.4926249999999999},null,null,null,null,null,null,null,null,null,8,24.57,9.2899999999999991,34.340000000000003,7.57,58.89,5.76]
[null,null,"= 3.49 KJ/Kg0C",null,null,null,null,null,null,null,null,null,10,30.71,14.04,42.92,11.44,73.61,8.7100000000000009]
[]
[null,null,"See ref downloaded on this day…"]
[null,null,null,null,null,null,null,null,"Equivalent Length of Pipe (feet)",null,null,null,"Pipe size (inches)","90° Elbow","45° Elbow","Through T run","Through T branch"]
[null,null,null,null,null,null,null,null,"for CPVC SDR 11 (CTS) Pipe Fittings",null,null,null,0.5,1.6,0.8,1,3.1]
[null,null,null,null,null,null,null,null,null,null,null,null,0.75,2.1,1.1000000000000001,1.4,4.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,1,2.6,1.4,1.7,5.2]
[null,null,null,null,null,null,null,null,null,null,null,null,1.25,3.5,1.8,2.2999999999999998,6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,1.5,4,2.1,2.7,8]
[null,null,null,null,null,null,null,null,null,null,null,null,2,5.5,2.8,3.4,10.3]
[]
[]
[]
[]
[]
[]
[]
[null,null,"It is assumed that the average temperature for the biomass is 8 °C when entering the process and that it is heated to 37°C (the process temperature). Specific heat is calculated based on the content of DM and water (calculated as 1-DM), assuming that the specific heat for DM corresponds to 3.00 kJ/kg°C and to 4.20 kJ/kg°C for water. As the DM for biomass mixture is 178.57 kg/1000 kg biomass mixture (table F.20), it involves that the water content is 1000kg – 178.57 kg = 821.43 kg/1000 kg\nbiomass mixture. The heat consumption for heating the biomass mixture from 8°C\nto 37°C is thus :\nFor DM: 178.57 kg DM/1000 kg biomass mixture * 3.00 kJ/kg DM*°C * (37-8) °C\n= 15 535.59 kJ/1000 kg biomass mixture;\nFor water : 821.43 kg water/1000 kg biomass mixture * 4.20 kJ/kg DM*°C * (37-8)\n°C = 100 050.17 kJ/1000 kg biomass mixture;\nTotal : (15 535.59 + 100 050.17) kJ/1000 kg biomass mixture * MJ/1000 kJ = 115.59\nMJ/1000 kg biomass mixture. "]

{"sheet":"Methods","index":6,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Methods"]
["mthd"]
[null,null,null,"Ref"]
[null,null,null,{"$f":"References!D8","v":2},"Pipes are generally cylindrical in structure; the amount of heat loss through pipe is given by the formula"]
[]
[null,null,null,null,null,"Q= 2 pi k L(Thot-Tcold)/ln(rOD/rID)",null,null,null,null,"The formula applies for steady state flow, single layer over cylinder and neglecting conductivity convection"]
[]
[null,null,null,null,"where"]
[null,null,null,null,null,"k","= conductivity of material of which pipe is made"]
[null,null,null,null,null,"Thot","= temperature of inside layer pipe"]
[null,null,null,null,null,"Tcold","= temperature outside layer of pipe"]
[null,null,null,null,null,"L","=  length of pipe"]
[null,null,null,null,null,"rID","= inner radius"]
[null,null,null,null,null,"rOD","= outer radius"]
[null,null,null,null,null,"ln","= natural logrithem"]
[null,null,null,null,null,"pi",{"$f":"CONCATENATE(\"= \",PI())","v":"= 3.14159265358979"}]
[]
[]
[null,null,null,{"$f":"References!D9","v":3},"TCBH"]
[]
[null,null,null,null,"where"]
[null,null,null,null,null,"C","= heat transfer coefficient of the pipe in question, under the stated conditions"]
[null,null,null,null,null,"t","= temperature of circulating water, in °F"]
[null,null,null,null,null,"V","= velocity of that water, in feet per hour"]
[null,null,null,null,null,"D","= inside diameter of the pipe, in feet"]

{"sheet":"scratch","index":7,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,0.92500000000000004,{"$f":"retFtInFrac2(D3/12,TRUE,64)","v":"59/64\" (>)"}]
[null,null,null,0.94,{"$f":"retFtInFrac2(D4/12,TRUE,64)","v":"15/16\" (>)"}]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"cnv__name_BtuFtPerHrPerInSqDegF","v":"BTU ft hr-1 in-2 °F-1"}]
[null,null,null,null,null,null,null,null,"surface","surf @ .75","surf @ 1"]
[null,null,null,null,"PVC",{"$f":"thC_Pvc_kVal_US","v":0.31352764623692958},{"$f":"1/16","v":6.25E-2},{"$f":"F12/G12","v":5.0164423397908733},{"$f":"$G$21*$G$22*2","v":2559.6},null,null,{"$f":"H12*I12","v":12840.085812928719},{"$f":"L12/$L$14","v":6.6804765200822374},{"$f":"L12/$L$17","v":2.0449976894962112},"times better than black poly"]
[null,null,null,null,"PVC",{"$f":"thC_Pvc_kVal_US","v":0.31352764623692958},{"$f":"1/32","v":3.125E-2},10.032884679581747,{"$f":"$G$21*$G$22*2","v":2559.6},null,null,{"$f":"H13*I13","v":25680.171625857438},13.360953040164475,{"$f":"L13/$L$17","v":4.0899953789924224},"               \""]
[null,null,null,null,"PEX",{"$f":"thC_Pex_kVal_US","v":0.86048045637681692},0.125,6.8838436510145353,null,{"$f":"$J$21","v":279.20904708779284},null,{"$f":"H14*J14","v":1922.0314261011213},1]
[null,null,null,null,"poly",{"$f":"thC_Pe_kVal_US","v":0.75896088727728517},0.06,12.649348121288087,null,{"$f":"$J$21","v":279.20904708779284},null,{"$f":"H15*J15","v":3531.8124352266095},1.8375414612189567]
[null,null,null,null,"PEX",{"$f":"thC_Pex_kVal_US","v":0.86048045637681692},0.125,6.8838436510145353,null,null,{"$f":"$K$21","v":496.37163926718733},{"$f":"K16*H16","v":3416.9447575131048},1.7777777777777779]
[null,null,null,null,"poly",{"$f":"thC_Pe_kVal_US","v":0.75896088727728517},0.06,12.649348121288087,null,null,{"$f":"$K$21","v":496.37163926718733},{"$f":"K17*H17","v":6278.7776626250843},3.2667403755003677,null,"black poly"]
[]
[null,null,null,null,null,null,null,null,"turns","dia","dia"]
[null,null,null,null,null,null,"panel","pipe",20,0.75,1]
[null,null,null,null,"wall ht, useful",null,40.5,40.5,null,{"$f":"PI()*((J20/2)^2)*$G$22*$I$20","v":279.20904708779284},{"$f":"PI()*((K20/2)^2)*$G$22*$I$20","v":496.37163926718733}]
[null,null,null,null,"wall width, useful",null,31.6,37]
[]
[null,null,null,null,"PVC cost",null,{"$f":"31.5/(4*8)","v":0.984375},"$/sq ft"]
[null,null,null,null,"panel size (incl. 2)",null,{"$f":"(G21/12)*(G22/12)*2","v":17.774999999999999},"sq ft"]
[null,null,null,null,"panel cost (incl. 2)",null,{"$f":"G25*G24","v":17.497265624999997},null,null,"panel cost",{"$f":"$G$26+$G$29+$G$33+($G$34*1)","v":25.267542991666666}]
[null,null,null,null,"pipe/ft, est",null,0.2,null,null,"poly cost",{"$f":"$G$38+($G$39*$I$20)","v":59.25714285714286}]
[null,null,null,null,"pipe ft",null,{"$f":"(33.5/12)*2","v":5.583333333333333}]
[null,null,null,null,"pipe cost, est",null,{"$f":"G28*G27","v":1.1166666666666667}]
[null,null,null,null,"sidewall inches needed",null,{"$f":"((40+40)*2) - 12","v":148}]
[null,null,null,null,"sidewall sq ft",null,{"$f":"G30*cnv_inSqToFtSq","v":1.027777712}]
[null,null,null,null,"sidewall cost, est",null,{"$f":"200/(4*8)","v":6.25},"$/sq ft"]
[null,null,null,null,"sidewalls, price",null,{"$f":"G31*G32","v":6.4236107000000002}]
[null,null,null,null,"elbow",null,0.23]
[]
[null,null,null,null,"100' black poly",null,25]
[null,null,null,null,"ft needed",null,{"$f":"(($H$22-2)/12)*20","v":58.333333333333329}]
[null,null,null,null,"poly cost",null,{"$f":"(100/G37)*G36","v":42.857142857142861}]
[null,null,null,null,"elbows cost",null,0.82]

{"sheet":"Conversions","index":8,"n_rows":252,"n_cols":8,"rows_kept":252,"cut":false,"hidden":false,"merged":[]}
["Conversions"]
["cnv"]
[]
[null,"Length/Distance"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"mm (to mil)","mmToMil",39.369999999999997,"mil"]
[null,null,"cm (to in)","cmToIn",0.39370078740157477,"in"]
[null,null,"m (to ft)","mToFt",3.2808398950000002,"ft"]
[null,null,"km (to mi)","kmToMi",0.62137119224000004,"mi"]
[null,null,"mil (to mm)","milToMm",2.5400050800101603E-2,"mm"]
[null,null,"in (to cm)","inToCm",2.54,"cm"]
[null,null,"in (to ft)","inToFt",8.3333333333333329E-2,"ft"]
[null,null,"ft (to yd)","ftToYd",0.33333333333333331,"yd"]
[null,null,"ft (to m)","ftToM",0.30480000000000002,"m"]
[null,null,"ft (to mi)","ftToMi",1.893939E-4,"mi"]
[null,null,"mi (to km)","miToKm",1.6093440000000001,"km"]
[]
[null,"Area"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"cm2 (to in2)","cmSqToInSq",0.15500031000062001,"in2"]
[null,null,"m2 (to ft2)","mSqToFtSq",10.76391042,"ft2"]
[null,null,"m2 (to ha)","mSqToHa",1E-4,"ha"]
[null,null,"km2 (to ha)","kmSqToHa",100,"ha"]
[null,null,"km2 (to acre)","kmSqToAcre",247.10538147,"acre"]
[null,null,"km2 (to mi2)","kmSqToMiSq",0.38610215799999997,"mi2"]
[null,null,"ha (to acre)","haToAcre",2.4710538161371201,"acre"]
[null,null,"ha (to ft2)","haToFtSq",107639.1042,"ft2"]
[null,null,"in2 (to cm2)","inSqToCmSq",6.4516,"cm2"]
[null,null,"in2 (to ft2)","inSqToFtSq",6.9444440000000001E-3,"ft2"]
[null,null,"ft2 (to in2)","ftSqToInSq",144,"in2"]
[null,null,"ft2 (to m2)","ftSqToMSq",9.2903040000000006E-2,"m2"]
[null,null,"ft2 (to yd2)","ftSqToYdSq",0.1111111,"yd2"]
[null,null,"ft2 (to mi2)","ftSqToMiSq",3.5870064279155203E-8,"mi2"]
[null,null,"ft2 (to acre)","ftSqToAcre",2.2956841138659299E-5,"acre"]
[null,null,"ft2 (to ha)","ftSqToHa",9.2903040000000008E-6,"ha"]
[null,null,"mi2 (to ft2)","miSqToFtSq",27878400,"ft2"]
[null,null,"mi2 (to km2)","miSqToKmSq",2.5899881100000002,"km2"]
[null,null,"acre (to ft2)","acreToFtSq",43560,"ft2"]
[null,null,"acre (to ha)","acreToHa",0.40468564200000001,"ha"]
[null,null,"acre (to km2)","acreToKmSq",4.0468559999999997E-3,"km2"]
[null,null,"acre (to mi2)","acreToMiSq",1.5625000000000001E-3,"mi2"]
[]
[null,"Mass"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"gm (to oz)","gmToOz",3.5273961950000002E-2,"oz"]
[null,null,"gm (to lb)","gmToLb",2.2046226218000002E-3,"lb"]
[null,null,"kg (to oz)","kgToOz",35.27396195,"oz"]
[null,null,"kg (to lb)","kgToLb",2.2046226218,"lb"]
[null,null,"kg (to slug)","kgToSlug",14.593902937206364,"slug"]
[null,null,"kg (to ton)","kgToTon",1.1023113109243901E-3,"ton"]
[null,null,"tonne (to lb)","tonneToLb",2204.6226218000002,"lb"]
[null,null,"tonne (to ton)","tonneToTon",1.1023113109,"ton"]
[null,null,"oz (to gm)","ozToGm",28.349523125000001,"gm"]
[null,null,"oz (to lb)","ozToLb",6.25E-2,"lb"]
[null,null,"oz (to kg)","ozToKg",2.8349523125000001E-2,"kg"]
[null,null,"lb (to gm)","lbToGm",453.59237000000002,"gm"]
[null,null,"lb (to oz)","lbToOz",16,"oz"]
[null,null,"lb (to kg)","lbToKg",0.45359237000000002,"kg"]
[null,null,"lb (to slug)","lbToSlug",3.1080950171567253E-2,"slug"]
[null,null,"lb (to ton)","lbToTon",5.0000000000000001E-4,"ton"]
[null,null,"lb (to tonne)","lbToTonne",4.5359236999999999E-4,"tonne"]
[null,null,"slug (to kg)","slugToKg",6.8521765856791761E-2,"kg"]
[null,null,"slug (to lb)","slugToLb",32.174048556430449,"lb"]
[null,null,"ton (to lb)","tonToLb",2000,"lb"]
[null,null,"ton (to kg)","tonToKg",907.18470000000002,"kg"]
[null,null,"ton (to tonne)","tonToTonne",0.90718474000000004,"tonne"]
[]
[null,"Volume"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"cm3 (to ml)","cmCuToMl",1,"ml"]
[null,null,"cm3 (to m3)","cmCuToMCu",9.9999999999999995E-7,"m3"]
[null,null,"cm3 (to in3)","cmCuToInCu",6.1023744094999999E-2,"in3"]
[null,null,"cm3 (to fl oz)","cmCuToFlOz",3.3814022701E-2,"fl oz"]
[null,null,"l (to m3)","lToMCu",1E-3,"m3"]
[null,null,"l (to in3)","lToInCu",61.023744094732301,"in3"]
[null,null,"l (to fl oz)","lToFlOz",33.814022701271298,"fl oz"]
[null,null,"l (to ft3)","lToFtCu",3.5314666720999997E-2,"ft3"]
[null,null,"m3 (to cm3)","mCuToCmCu",1000000,"cm3"]
[null,null,"m3 (to in3)","mCuToInCu",61023.744094731999,"in3"]
[null,null,"m3 (to ft3)","mCuToFtCu",35.314666721000002,"ft3"]
[null,null,"m3 (to gal)","mCuToGal",264.17205235799997,"gal"]
[null,null,"m3 (to yd3)","mCuToYdCu",1.3079506190000001,"yd3"]
[null,null,"in3 (to cm3)","inCuToCmCu",16.387063999999999,"cm3"]
[null,null,"in3 (to fl oz)","inCuToFlOz",0.55411255410000004,"fl oz"]
[null,null,"in3 (to ft3)","inCuToFtCu",5.78703703703704E-4,"ft3"]
[null,null,"in3 (to gal)","inCuToGal",4.32900432886E-3,"gal"]
[null,null,"fl oz (to cm3)","flOzToCmCu",29.573529563000001,"cm3"]
[null,null,"fl oz (to in3)","flOzToInCu",1.8046875,"in3"]
[null,null,"fl oz (to ft3)","flOzToFtCu",1.044379E-3,"ft3"]
[null,null,"fl oz (to gal)","flOzToGal",7.8125E-3,"gal"]
[null,null,"ft3 (to cm3)","ftCuToCmCu",28316.846592000002,"cm3"]
[null,null,"ft3 (to l)","ftCuToL",28.316846592000001,"l"]
[null,null,"ft3 (to m3)","ftCuToMCu",2.8316846999999999E-2,"m3"]
[null,null,"ft3 (to in3)","ftCuToInCu",1728,"in3"]
[null,null,"ft3 (to gal)","ftCuToGal",7.4805194805194999,"gal"]
[null,null,"ft3 (to bu)","ftCuToBu",0.80356395488629395,"bu"]
[null,null,"ft3 (to yd3)","ftCuToYdCu",3.703704E-2,"yd3"]
[null,null,"ft3 (to l)","ftCuToL",28.316849999999999,"l"]
[null,null,"ft3 (to m3)","ftCuToMCu",2.8316850000000001E-2,"m3"]
[null,null,"gal (to fl oz)","galToFlOz",128,"fl oz"]
[null,null,"gal (to l)","galToL",0.26417205235380598,"l"]
[null,null,"gal (to ft3)","galToFtCu",0.133680555555556,"ft3"]
[null,null,"gal (to m3)","galToMCu",3.7854117840000001E-3,"m3"]
[null,null,"yd3 (to ft3)","ydCuToftCu",26.999997840000173,"ft3"]
[]
[null,"Energy units"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"kCal (to BTU)","kCalToBtu",3.9683205411000002,"BTU"]
[null,null,"kCal (to joules)","kCalToJoules",4186.8,"joules"]
[null,null,"joules (to kCal)","joulesToKcal",2.3884589662750001E-4,"kCal"]
[null,null,"joules (to KwH)","joulesToKwh",2.777778E-7,"KwH"]
[null,null,"joules (to BTU)","joulesToBtu",9.4781710000000003E-4,"BTU"]
[null,null,"joules (to therm)","joulesToTherm",9.4781340000000003E-9,"therm"]
[null,null,"kCal (to Kwh)","kCalToKwh",1.163E-3,"Kwh"]
[null,null,"kCal (to therm)","kCalToTherm",3.9692682242000001E-5,"therm"]
[null,null,"BTU (to kCal)","btuToKcal",0.25199577242999999,"kCal"]
[null,null,"BTU (to Kwh)","btuToKwh",2.9307108333000002E-4,"Kwh"]
[null,null,"BTU (to therm)","btuToTherm",1.0002388121E-5,"therm"]
[null,null,"Kwh (to kCal)","kwhToKcal",859.84522786000002,"kCal"]
[null,null,"Kwh (to BTU)","kwhToBtu",3412.1414798999999,"BTU"]
[null,null,"Kwh (to therm)","kwhToTherm",3.4121279999999997E-2,"therm"]
[null,null,"therm (to kCal)","thermToKcal",25193.5607148733,"kCal"]
[null,null,"therm (to BTU)","thermToBtu",99976.124491759998,"BTU"]
[null,null,"therm (to Kwh)","thermToKwh",29.300111111,"Kwh"]
[]
[null,"Power"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"kW (to kCal/sec)","kWToKcalPerSec",0.23884589663,"kCal/sec"]
[null,null,"kW (to BTU/sec)","kWToBtuPerSec",0.94781712087000003,"BTU/sec"]
[null,null,"kW (to HP)","kWToHp",1.3410220924,"HP"]
[null,null,"kCal/sec (to kW)","kCalPerSecToKw",4.1867999999999999,"kW"]
[null,null,"kCal/sec (to HP)","kCalPerSecToHp",5.6145912965999996,"HP"]
[null,null,"BTU/sec (to kW)","btuPerSecToKw",1.055055852,"kW"]
[null,null,"BTU/sec (to HP)","btuPerSecToHp",1.4148532063000001,"HP"]
[null,null,"HP (to kW)","hpToKw",0.74569987000000004,"kW"]
[null,null,"HP (to kCal/sec)","hpToKcalPerSec",0.17810735407,"kCal/sec"]
[null,null,"HP (to BTU/sec)","hpToBtuPerSec",0.70678710381999998,"BTU/sec"]
[]
[null,"Acceleration"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"m sec-2 (to ft sec-2)","mPerSecSqToFtPerSecSq",0,"ft sec-2"]
[null,null,"ft sec-2 (to m sec-2)","ftPerSecSqToMPerSecSq",0,"m sec-2"]
[]
[null,"Energy Density (chk*)"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"cal l-1 (to kCal m-3)","calPerLToKcalPerMCu",1E-3,"kCal m-3"]
[null,null,"cal l-1 (to joules m-3)","calPerLToJoulesPerMCu",4184,"joules m-3"]
[null,null,"kCal l-1 (to joules m-3)","kCalPerLToJoulesPerMCu",4184000,"joules m-3"]
[null,null,"kCal l-1 (to BTU ft-3)","kCalPerLToBtuPerFtCu",112.29517930599999,"BTU ft-3"]
[null,null,"kCal l-1 (to BTU gal-1)","kCalPerLToBtuPerGal",15.01168195,"BTU gal-1"]
[null,null,"kCal m-3 (to BTU ft-3)","kCalPerMCuToBtuPerFtCu",0.112295179305963,"BTU ft-3"]
[null,null,"kCal m-3 (to BTU gal-1)","kCalPerMCuToBtuPerGal",1.5011681949708399E-2,"BTU gal-1"]
[null,null,"joules l-1 (to kCal m-3)","joulesPerLToKcalPerMCu",0.239005736,"kCal m-3"]
[null,null,"joules l-1 (to BTU ft-3)","joulesPerLToBtuPerFtCu",2.68571599491551E-2,"BTU ft-3"]
[null,null,"joules l-1 (to BTU gal-1)","joulesPerLToBtuPerGal",3.5878773723644502E-3,"BTU gal-1"]
[null,null,"joules l-1 (to therm ft-3)","joulesPerLToThermPerFtCu",3.3471714335160999E-10,"therm ft-3"]
[null,null,"BTU ft-3 (to kCal l-1)","btuPerFtCuToKcalPerL",8.9051017699999999E-3,"kCal l-1"]
[null,null,"BTU ft-3 (to kCal m-3)","btuPerFtCuToKcalPerMCu",8.9051017699999999,"kCal m-3"]
[null,null,"BTU ft-3 (to joules m-3)","btuPerFtCuToJoulesPerMCu",37258.945807831296,"joules m-3"]
[null,null,"therm ft-3 (to kCal m-3)","thermPerFtCuToKcalPerMCu",889702.20017333794,"kCal m-3"]
[null,null,"therm ft-3 (to joules m-3)","thermPerFtCuToJoulesPerMCu",3725005171.64923,"joules m-3"]
[null,null,"therm ft-3 (to BTU gal-1)","thermPerFtCuToBtuPerGal",13368.055555590399,"BTU gal-1"]
[]
[null,"Density"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"gm/cm3 (to kg/m3)","gmPerCmCuToKgPerMCu",1000,"kg/m3"]
[null,null,"kg/l (to lb/ft3)","kgPerLToLbPerFtCu",62.427960575627203,"lb/ft3"]
[null,null,"kg/m3 (to lb/in3)","kgPerMCuToLbPerInCu",3.6127292E-5,"lb/in3"]
[null,null,"kg/m3 (to lb/ft3)","kgPerMCuToLbPerftCu",6.2427960576000002E-2,"lb/ft3"]
[null,null,"kg/m3 (to lb/gal)","kgPerMCuToLbPerGal",8.3454044520000006E-3,"lb/gal"]
[null,null,"kg/m3 (to SpGrav (specific gravity))","kgPerMCuToSpGrav",1E-3,"SpGrav (specific gravity)"]
[null,null,"lb/ft3 (to kg/m3)","lbPerInCuToKgPerMCu",16.018463373960099,"kg/m3"]
[null,null,"lb/ft3 (to oz/in3)","lbPerFtCuToOzPerInCu",9.2592592592592605E-3,"oz/in3"]
[null,null,"lb/ft3 (to SpGrav)","lbPerFtCuToSpGrav",62.427183560000003,"SpGrav"]
[null,null,"SpGrav (to gm/cm3)","spGravToGmPerCmCu",1,"gm/cm3"]
[null,null,"SpGrav (to kg/m3)","spGravToKgPerMCu",1000,"kg/m3"]
[null,null,"SpGrav (to oz/in3)","spGravToOzPerInCu",0.57802947740739996,"oz/in3"]
[null,null,"SpGrav (to lb/ft3)","spGravToLbPerFtCu",1.6018662751920001E-2,"lb/ft3"]
[null,null,"SpGrav (to lb/gal)","spGravToLbPerGal",8.3453005800909992,"lb/gal"]
[]
[null,"Pressure"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"atm (to bar)","atmToBar",1.01325,"bar"]
[null,null,"atm (to mm Hg)","atmToMmHg",760.00210017851998,"mm Hg"]
[null,null,"atm (to cm H2O)","atmToCmH2o",1033.22755476679,"cm H2O"]
[null,null,"atm (to cm H2O)","atmToFtH2o",33.898542050866702,"cm H2O"]
[null,null,"atm (to MPascal)","atmToMpascal",0.10132500999999999,"MPascal"]
[null,null,"atm (to psi)","atmToPsi",14.6959502543,"psi"]
[null,null,"bar (to atm)","barToAtm",0.98692326671601005,"atm"]
[null,null,"bar (to mm Hg)","barToMmHg",750.06375541921,"mm Hg"]
[null,null,"bar (to cm H2O)","barToCmH2o",1019.716213,"cm H2O"]
[null,null,"bar (to psi)","barToPsi",14.503773773022001,"psi"]
[null,null,"MPascal (to atm)","mPascalToAtm",9.8692316930999997,"atm"]
[null,null,"MPascal (to psi)","mPascalToPsi",145.03773773021999,"psi"]
[null,null,"mm Hg (to atm)","mmHgToAtm",1.3157858376511E-3,"atm"]
[null,null,"mm Hg (to cm H2O)","mmHgToCmH2o",1.3595060468770099,"cm H2O"]
[null,null,"cm H2O (to atm)","cmH2oToAtm",9.6784100984000001E-4,"atm"]
[null,null,"cm H2O (to bar)","cmH2oToBar",9.8066499999999992E-4,"bar"]
[null,null,"psi (to atm)","psiToAtm",6.8045957064000004E-2,"atm"]
[null,null,"psi (to bar)","psiToBar",6.8947572799999995E-2,"bar"]
[null,null,"bar (to mm Hg)","barToMmHg",51.714924101999998,"mm Hg"]
[null,null,"psi (to cm H2O)","psiToCmH2o",70.306957830000002,"cm H2O"]
[null,null,"psi (to MPascal)","psiToMpascal",6.8947572931679999E-3,"MPascal"]
[]
[null,"Heat Transfer Coefficient / Thermal Conductivity"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"cal cm sec-1 cm-2 °C-1 (to W m-1 °C-1)","calCmPerSecCmSqDegCToWPerMDegC",2.3900573613766731E-3,"W m-1 °C-1"]
[null,null,"W m-1 °C-1 (to W cm-1 °C-1)","wPerMDegCToWPerCmDegC",100,"W cm-1 °C-1"]
[null,null,"W m-1 °C-1 (to cal cm sec-1 cm-2 °C-1)","wPerMDegCToCalCmPerSecCmSqDegC",418.4,"cal cm sec-1 cm-2 °C-1"]
[null,null,"W m-1 °C-1 (to BTU ft hr-1 ft-2 °F-1)","wPerMDegCToBtuFtPerHrPerFtSqDegF",1.7307346663713912,"BTU ft hr-1 ft-2 °F-1",null,"cnv__name_"]
[null,null,"W m-1 °C-1 (to BTU ft hr-1 in-2 °F-1)","wPerMDegCToBtuFtPerHrPerInSqDegF",0.14422788886428259,"BTU ft hr-1 in-2 °F-1"]
[null,null,"W m-1 °C-1 (to BTU in hr-1 in-2 °F-1)","wPerMDegCToBtuInPerHrPerInSqDegF",20.768815996456691,"BTU in hr-1 in-2 °F-1"]
[null,null,"W cm-1 °C-1 (to W m-1 °C-1)","wPerMDegCToWPerCmDegC",0.01,"W m-1 °C-1"]
[null,null,"kCal m hr-1 m-2 °C-1 (to W m-1 °C-1)","kCalMPerHrPerMSqDegCToWPerMDegC",1.163,"W m-1 °C-1"]
[null,null,"kCal m hr-1 m-2 °C-1 (to BTU ft hr-1 ft-2 °F-1)","kCalMPerHrPerMSqDegCToBtuFtPerHrPerFtSqDegF",0.67196897513950682,"BTU ft hr-1 ft-2 °F-1",null,"     "]
[null,null,"BTU ft hr-1 ft-2 °F-1 (to W m-1 °C-1)","btuFtPerHrPerFtSqDegFToWPerMDegC",1.7307346663713912,"W m-1 °C-1",null,"     "]
[null,null,"BTU ft hr-1 ft-2 °F-1 (to kCal m hr-1 m-2 °C-1)","btuFtPerHrPerFtSqDegFToKcalMPerHrPerMSqDegC",1.4881639435695537,"kCal m hr-1 m-2 °C-1",null,"     "]
[null,null,"BTU ft hr-1 ft-2 °F-1 (to BTU in hr-1 in-2 °F-1)","btuFtPerHrPerFtSqDegFToBtuInPerHrPerInSqDegF",12,"BTU in hr-1 in-2 °F-1",null,"     "]
[null,null,"BTU ft hr-1 in-2 °F-1 (to W m-1 °C-1)","btuFtPerHrPerInSqDegFToWPerMDegC",1.7307346663713912,"W m-1 °C-1",null,"     "]
[null,null,"BTU in hr-1 in-2 °F-1 (to W m-1 °C-1)","btuInPerHrPerInSqDegFToWPerMDegC",20.768815996456691,"W m-1 °C-1",null,"     "]
[]
[null,"Gas Production (chk*)"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"l gm-1 (to ft3 lb-1)","lPerGmToFtCuPerLb",16.018462495429102,"ft3 lb-1"]
[null,null,"l gm-1 (to m3 kg-1)","lPerGmToMCuPerKg",1,"m3 kg-1"]
[null,null,"l gm-1 (to m3 t-1)","lPerGmToMCuPerTonne",1000,"m3 t-1"]
[null,null,"l kg-1 (to ft3 lb-1)","lPerKgToFtCuPerLb",1.6018462495429101E-2,"ft3 lb-1"]
[null,null,"l kg-1 (to m3 t-1)","lPerKgToMCuPerTonne",1,"m3 t-1"]
[null,null,"m3 kg-1 (to ft3 lb-1)","mCuPerKgTo",16.018462495429102,"ft3 lb-1"]
[null,null,"m3 kg-1 (to m3 t-1)","mCuPerKgToMCuPerTonne",1E-3,"m3 t-1"]
[null,null,"ft3 lb-1 (to yd3 ton-1)","ftCuPerLbToYdCuPerTon",74.074079999999995,"yd3 ton-1"]
[null,null,"ft3 lb-1 (to l gm-1)","ftCuPerLbToLPerGm",6.2427960576144997E-2,"l gm-1"]
[null,null,"ft3 lb-1 (to l kg-1)","ftCuPerLbToLPerKg",62.427960576144997,"l kg-1"]
[null,null,"ft3 lb-1 (to m3 kg-1)","ftCuPerLbToMCuPerKg",6.2427960576144997E-2,"m3 kg-1"]
[null,null,"ft3 lb-1 (to m3 t-1)","ftCuPerLbToMCuPerTonne",62.427960576144997,"m3 t-1"]
[null,null,"yd3 ton-1 (to ft3 lb-1)","ydCuPerLbToFtCuPerLb",1.35E-2,"ft3 lb-1"]
[null,null,"yd3 ton-1 (to m3 t-1)","ydCuPerLbToMCuPerTonne",0.84277746799999997,"m3 t-1"]
[]
[null,"Flow Rate"]
[null,null,"Conversion","cellName","conv#","Units"]
[null,null,"l/sec (to m3/hr)","lPerSecToMCuPerHr",3.6,"m3/hr"]
[null,null,"l/sec (to ft3/sec)","lPerSecToFtCuPerSec",3.5314666720999997E-2,"ft3/sec"]
[null,null,"l/sec (to gal/sec)","lPerSecToGalPerSec",0.26417205235448998,"gal/sec"]
[null,null,"m3/hr (to l/sec)","mCuPerHrToLPerSec",0.27777777777777801,"l/sec"]
[null,null,"m3/hr (to ft3/sec)","mCuPerHrToFtCuPerSec",9.8096296399999994E-3,"ft3/sec"]
[null,null,"m3/hr (to gal/sec)","mCuPerHrToGalPerSec",7.3381125699999994E-2,"gal/sec"]
[null,null,"ft3/sec (to l/sec)","ftCuPerSecToLPerSec",28.316846600000002,"l/sec"]
[null,null,"ft3/sec (to m3/hr)","ftCuPerSecToMCuPerHr",101.940648,"m3/hr"]
[null,null,"ft3/sec (to gal/sec)","ftCuPerSecToGalPerSec",7.480519481,"gal/sec"]
[null,null,"gal/sec (to l/sec)","galPerSecToLPerSec",3.78541178,"l/sec"]
[null,null,"gal/sec (to m3/hr)","galPerSecToMCuPerHr",13.6274824,"m3/hr"]
[null,null,"gal sec-1 (to ft3 sec-1)","galPerSecToFtCuPerSec",0.13368055600000001,"ft3 sec-1"]