{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Main"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[[9,5,9,7],[0,1,0,15],[8,2,8,8]]}
[null,"Buried Uninsulated Pipe Energy Loss\nCalculator"]
[null,"Single Pipe (assumed no other pipes or thermal anomalies are within close proximity)"]
[null,null,"Abbreviations:"]
[null,null,"Thermal resistance of soil",null,"Rs ","h-ft-F/Btu"]
[null,null,"Thermal conductivity of soil",null,"ks","Btu/h-ft-F"]
[null,null,"Burial depth of centerline",null,"d","ft"]
[null,null,"Outer radius of pipe",null,"ro","ft"]
[]
[null,null,"Soil Thermal Conductivities"]
[null,null,"Soil Moisture Content",null,null,"Thermal Conductivity, Btu/h-ft-F"]
[null,null," (by mass)",null,null,"Sand","Silt","Clay"]
[null,null,"Low, < 4%",null,null,0.17,0.08,0.08]
[null,null,"Medium 4 to 20%",null,null,1.08,0.75,0.57999999999999996]
[null,null,"High, > 20%",null,null,1.25,1.25,1.25]
[null,null,"Chyu et al. (1997a,b; 1998a,b)"]
[]
[null,null,"Pipe Properties"]
[null,null,"Inner diameter",null,null,10.02," in",null,null,null,null,null,null,"d =",{"$f":"ROUND(F22,2) & $G$22","v":"6 ft"}]
[]
[null,null,"Wall thickness",null,null,0.36499999999999999," in"]
[null,null,"Outer radius, ro",null,null,{"$f":"(F18+(2*F20))/2/12","v":0.44791666666666669}," ft"]
[null,null,"Depth to centerline of pipe, d",null,null,6," ft",null,null,null,null,null,null,"ro =",{"$f":"ROUND(F21,2) & $G$22","v":"0.45 ft"}]
[null,null,"d/ro ratio",null,null,{"$f":"F22/F21","v":13.395348837209301},{"$f":"IF(F23>4,\" ratio > 4\",\" ratio < 4\")","v":" ratio > 4"},null,null,null,null,null,null,"ri =",{"$f":"ROUND(F18/12/2,2) & $G$22","v":"0.42 ft"}]
[]
[null,null,"Soil Properties"]
[null,null,"Thermal Conductivity, ks",null,null,1,"Btu/h-Ft-F",null,null,"Formula from ASHRAE Handbook"]
[null,null,"Thermal Resistance, Rs",null,null,{"$f":"IF(F23>4,LN(2*F23)/(2*PI()*F26),LN(F23+(F23^2-1)^(1/2))/(2*PI()*F26))","v":0.52331016272990127},"h-ft-F/Btu"]
[null,null,"Soil Temperature",null,null,60," °F"]
[]
[null,null,"Others"]
[null,null,"Fluid Temperature",null,null,325," °F"]
[]
[null,null,{"$f":"IF(F33>0, \"Heat Loss per Unit Length of System, q\", \"Heat Gain per Unit Length of System, q\")","v":"Heat Loss per Unit Length of System, q"},null,null,{"$f":"(F31-F28)/F27","v":506.3918472700783},"Btu/h-ft"]
[]
[null,null,"Monetary Measurement"]
[null,null,"Operational days",null,null,365," days per year"]
[]
[null,null,"Length of Pipe System",null,null,1988," ft"]
[]
[null,null,"Latent Energy in Fluid",null,null,868," Btu/lb"]
[]
[null,null,{"$f":"IF(F33>0, \"Total Energy Loss in System\", \"Total Energy Gain in System\")","v":"Total Energy Loss in System"},null,null,{"$f":"F38*F33/10^6","v":1.0067069923729157}," MMBtu/h"]
[null,null,null,null,null,{"$f":"F42/F40*10^3","v":1.1598006824572762},"1,000 lb/h"]
[null,null,null,null,null,{"$f":"F43*F36*24/10^3","v":10.15985397832574},"million lbs per year"]
[]
[null,null,"Cost of Steam",null,null,6.42," per 1,000 lbs of steam"]
[]
[null,null,{"$f":"IF(F33>0,\"Monetary Loss\",\"Monetary Gain\")","v":"Monetary Loss"},null,null,{"$f":"F44*F46*1000","v":65226.262540851254}," per year"]
[]
[null,null,"Copy Rights: Not to be copied or distributed without specific permission from Inveno Engineering LLC; kelly.paffel@invenoeng.com"]