{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Storage Tank","Properties","Hoja3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Storage Tank","index":0,"n_rows":336,"n_cols":5,"rows_kept":336,"cut":false,"hidden":false,"merged":[]}
["Thermal Storage Tank Size Computation"]
[]
["3 tons of energy ",10543.5,"Watts","Note: These are known values; therefore, they do not change."]
["Require Usage Time",12,"hr"]
["Required stored energy",455784.19199999998,"KJ"]
["Storage Tank Water Initial Temperature",20,"C"]
["Specific Heat of Water",{"$f":"Properties!F2","v":4.2},"KJ/kgK"]
["Required Heat Transfer to cool the water from 20 to 0 degrees celcius",{"$f":"B9*B7*B6","v":114731.41183098592},"KJ"]
["Required Mass of Ice",{"$f":"B5/Properties!B2","v":1365.8501408450704},"Kg"]
["Volume of ice",{"$f":"B9/Properties!B3","v":1.4894767075736863},"m^3"]
["Required energy to convert water to ice @ 0 degrees celcius",{"$f":"B9*Properties!B2","v":455784.19199999998},"KJ"]
["Total heat transfer to transform water to ice starting at 20 degrees celcius",{"$f":"B8+B11","v":570515.60383098596},"KJ"]
["Maximum Time available for freezing the whole volume of ice",{"$f":"6.5*24","v":156},"hrs"]
[]
["Velocity glycol in intial coil before separation",3,"m/s","Note: Green cells are input values"]
["Surface Temperature on the coils 1st state",290.39119936695499,"K","Note: Usegoalseek on cell B 77 and set it to zero in order to calculate the surface temperature"]
["Surface Temperature on the coils 2nd state",286.70608384722914,"K","Note: Usegoalseek on cell B 78 and set it to zero in order to calculate the surface temperature"]
["Surface Temperature on the coils 3rd state",276.49071050407593,"K","Note: Usegoalseek on cell B 79 and set it to zero in order to calculate the surface temperature"]
["Surface Temperatue on the coils Final state",271.88833635530426,"K","Note: Usegoalseek on cell B 80 and set it to zero in order to calculate the surface temperature"]
["Diameter of initial coil before separation",0.05,"m"]
["Diameter of coils after separation",2.4E-2,"m"]
["Length of coils",13,"m"]
["Number of Coils",32]
["Tank Length",1.2,"m"]
["Surface Area of one coil after separation",{"$f":"((3.1416*B21)*B22)","v":0.98017920000000003},"m^2"]
["Total surface area off all coils",{"$f":"B23*B25","v":31.365734400000001},"m^2"]
["Area of one coil after separation",{"$f":"((3.1416)*((B21)^2))/4","v":4.5239040000000002E-4},"m^2"]
["Area of all coils after separation",{"$f":"B23*B27","v":1.4476492800000001E-2},"m^2"]
["Volume of all coils after separation",{"$f":"B28*B22","v":0.18819440640000001},"m^3"]
["Area of initial coil before separation",{"$f":"((3.1416)*B20^2)/4","v":1.9635000000000004E-3},"m^2"]
["Mass flow rate glycol in initial coil before separation",{"$f":"B15*B30*Properties!J3","v":6.5325645000000021},"kg/s"]
["Volume flow rate glycol in initial coil before separation",{"$f":"B30*B15","v":5.8905000000000016E-3},"m^3/s"]
["Minumum power required in order to freeze all the water in the specified amount of time",{"$f":"((B12/B13)/3600)*1000","v":1015.8753629469122},"w"]
["Temperature @ which glycol is entering the tank",{"$f":"-10+273","v":263},"K"]
["Temperature of water @ initial state",{"$f":"20+273","v":293},"K"]
["Temperature of water @ final state",273,"K"]
["Film Temperature on water side @ initial state",{"$f":"(B16+B35)/2","v":291.6955996834775},"K"]
["Ra of Water at initial state",{"$f":"ABS((((((9.81)*((Properties!F$8))*(('Storage Tank'!B$16)-('Storage Tank'!B$35))*(('Storage Tank'!B$21)^3))/((Properties!F$9/999.1)^2)))*(Properties!F$7)))","v":304442.04150267504},{"$f":"IF(B38<1*10^12,\"Ra number is correct\",\"Ra number is incorrect\")","v":"Ra number is correct"}]
["Nusselt Number after calculating Ra",{"$f":"((0.6+((0.387*(B38^(1/6)))/((1+(0.559/Properties!F7)^(9/16))^(8/27))))^2)","v":12.893677836963535}]
["Heat transfer coefficient for initial state on the outside (Water side)",{"$f":"(Properties!F10/'Storage Tank'!B21)*'Storage Tank'!B39","v":316.43234358214676},"w/m^2 k"]
["Temperature of water @ second state",{"$f":"15+273","v":288},"K"]
["Film Temperature of water second state",{"$f":"(B41+B17)/2","v":287.35304192361457}]
["Ra of water at second state",{"$f":"ABS((((((9.81)*((Properties!F$4))*(('Storage Tank'!B$17)-('Storage Tank'!B$41))*(('Storage Tank'!B$21)^3))/((Properties!F$5/999.1)^2)))*(Properties!F$3)))","v":710250.24616723205},{"$f":"IF(B43<1*10^12,\"Ra number is correct\",\"Ra number is incorrect\")","v":"Ra number is correct"}]
["Nusselt Number after calculating Ra 2nd phase",{"$f":"((0.6+((0.387*(B43^(1/6)))/((1+(0.559/Properties!F3)^(9/16))^(8/27))))^2)","v":16.483626648085345}]
["Heat transfer coefficient for second state on the outside (water side)",{"$f":"(Properties!F6/'Storage Tank'!B21)*'Storage Tank'!B44","v":398.35431066206246},"w/m^2 k"]
["Temperature of water @ third state",{"$f":"5+273","v":278},"K"]
["Film Temperature of water third state",{"$f":"(B46+B18)/2","v":277.24535525203794},"K"]
["Ra number of water at third state",{"$f":"ABS((((((9.81)*((Properties!F$12))*(('Storage Tank'!B$18)-('Storage Tank'!B$46))*(('Storage Tank'!B$21)^3))/((Properties!F$13/999.1)^2)))*(Properties!F$11)))","v":14876.026179919505},{"$f":"IF(B48<1*10^12,\"Ra number is correct\",\"Ra number is incorrect\")","v":"Ra number is correct"}]
["Nusselt Number after calculating Ra 3rd state",{"$f":"((0.6+((0.387*(B48^(1/6)))/((1+(0.559/Properties!F11)^(9/16))^(8/27))))^2)","v":5.8805045005581}]
["Heat transfer coefficient for third state on the outside (water side)",{"$f":"(Properties!F14/'Storage Tank'!B21)*B49","v":139.90700290911144},"w/m^2 k"]
["Temperature of water @ final state",{"$f":"B36","v":273},"K"]
["Film Temperature of water final state",{"$f":"(B51+B19)/2","v":272.44416817765216},"K"]
["Ra number of water at Final state",{"$f":"ABS((((((9.81)*((Properties!F$16))*(('Storage Tank'!B$19)-('Storage Tank'!B$51))*(('Storage Tank'!B$21)^3))/((Properties!F$17/999.1)^2)))*(Properties!F$15)))","v":43019.040928278155}]
["Nusselt Number after calculating Ra Final State",{"$f":"((0.6+((0.387*(B53^(1/6)))/((1+(0.559/Properties!F15)^(9/16))^(8/27))))^2)","v":7.775569449916941}]
["Heat transfer coeffient for Final state on the outside (Water side)",{"$f":"(Properties!F18/'Storage Tank'!B21)*B54","v":181.75393589180848},"w/m^2 k"]
[]
["Glycol entering temperature",{"$f":"B34","v":263},"K"]
["Nusselt Number of glycol inside coils",{"$f":"IF(B271<2300,3.66,(((B287/8)*(B271-1000))*(Properties!J$5))/(1+(12.7*(('Storage Tank'!B287/8)^0.5)*((Properties!J$5)^(2/3)-1))))","v":3.66},null,"Note: This will change depending if it is laminar or turbulent. For laminar is 3.66 but for turbulent it will change"]
["Heat transfer coefficient inside coils",{"$f":"(Properties!J6/'Storage Tank'!B21)*('Storage Tank'!B58)","v":36.904999999999994},"w/m^2 k"]
["Overall Heat transfer coefficient initial state",{"$f":"(1/((1/B59)+(1/B40)))","v":33.050386131020829},"w/m^2 k"]
["Overall Heat transfer coefficient Second state",{"$f":"(1/((1/B59)+(1/B45)))","v":33.775879056146259},"w/m^2 k"]
["Overall Heat transfer coefficient Third state",{"$f":"(1/((1/B59)+(1/B50)))","v":29.202021680705052},"w/m^2 k"]
["Overall Heat transfer coefficient Final state",{"$f":"(1/((1/B59)+(1/B55)))","v":30.676217172327672},"w/m^2 k"]
[]
["Exit Temperature  of Glycol initial state",{"$f":"(B16-((B16-B57)*EXP((-B60*B25)/(B321*Properties!J2))))","v":264.83075892034628},"K"]
["Exit Temperature  of Glycol Second state",{"$f":"(B17-((B17-B57)*EXP((-B61*B25)/(B321*Properties!J2))))","v":264.6180210100847},"K"]
["Exit Temperature  of Glycol Third  state",{"$f":"(B18-((B18-B57)*EXP((-B62*B25)/(B321*Properties!J2))))","v":263.79987366914236},"K"]
["Exit Temperature  of Glycol Final state",{"$f":"(B19-((B19-B57)*EXP((-B63*B25)/(B321*Properties!J2))))","v":263.5527553065013},"K"]
["Log mean temperature difference 1",{"$f":"(B$57-B65)/(LN((B16-B65)/(B16-B$57)))","v":26.465267047269069},"K"]
["Log mean temperature difference 2",{"$f":"(B$57-B66)/(LN((B17-B66)/(B17-B$57)))","v":22.887542050943871},"K"]
["Log mean temperature difference 3",{"$f":"(B$57-B67)/(LN((B18-B67)/(B18-B$57)))","v":13.086699825686193},"K"]
["Log mean temperature difference 4",{"$f":"(B$57-B68)/(LN((B19-B68)/(B19-B$57)))","v":8.6090013571263491},"K"]
["Heat loss inside coil intial state",{"$f":"B60*(B$25)*(B69)","v":857.35029303662679},"w"]
["Heat loss inside coil Second state",{"$f":"B61*(B$25)*(B70)","v":757.72444515695429},"w"]
["Heat loss inside coil Third state",374.58341292788919,"w"]
["Heat loss inside coil Final state",258.85708857658216,"w"]
["Heat loss in water initial state",{"$f":"B40*B$25*(B35-B16)","v":809.14665148252629},"w"]
["Heat loss in water Second state",{"$f":"B45*B25*(B41-B17)","v":505.22070187392859},"w"]
["Heat loss in water Third state",{"$f":"B50*B25*(B46-B18)","v":206.9748064014463},"w"]
["Heat loss in water Final state",{"$f":"B55*B25*(B51-B19)","v":198.04446517936958},"w"]
["Heat loss comparison 1",{"$f":"B73-B77","v":48.2036415541005},"w"]
["Heat loss comparison 2",{"$f":"B74-B78","v":252.5037432830257},"w"]
["Heat loss comparison 3",{"$f":"B75-B79","v":167.60860652644288},"w"]
["Heat loss comparison 4",{"$f":"B76-B80","v":60.812623397212576},"w"]
[]
["Total heat loss adding all the coils initial state",{"$f":"B73*B$23","v":27435.209377172057},"w"]
["Total heat loss adding all the coils second state",{"$f":"B74*B$23","v":24247.182245022537},"w"]
["Total heat loss adding all the coils third state",11986.669213692454,"w"]
["Total heat loss adding all the coils Final state",8283.426834450629,"w"]
[]
["Energy required to lower the water temperature by 5 degrees",{"$f":"(B$9*(Properties!F$2)*(5))*1000","v":28682852.95774648},"J"]
["Energy required to lower the water temperature by 8 degrees",{"$f":"(B$9*(Properties!F$2)*(8))*1000","v":45892564.732394367},"J"]
["Energy required to lower the water temperature by 7 degrees",{"$f":"(B$9*(Properties!F$2)*(7))*1000","v":40155994.140845075},"J"]
["Energy required to freeze the water at 0 degrees",{"$f":"B11*1000","v":455784192},"J"]
["Require time in order to finish the Initial state",{"$f":"(B91/B86)/3600","v":0.29040999998924888},"Hrs"]
["Require time in order to finish the Second state",{"$f":"(B92/B87)/3600","v":0.52574911670423974},"Hrs"]
["Require time in order to finish the Third state",0.93057067130538762,"Hrs"]
["Require time in order to finish the Final state",15.28434095336544,"Hrs"]
["Maximum amount of time",{"$f":"B13","v":156},"Hrs"]
["Time required to freeze the water by adding the time calculations",{"$f":"B95+B96+B97+B98","v":17.031070741364317},"Hrs"]
[]
["Chiller Selection"]
["Power needed to lower the temeperature of glycol",{"$f":"B31*(Properties!J2)*('Storage Tank'!B65-'Storage Tank'!B34)","v":27435.209377171999},"w"]
[]
["Pump Selection"]
["Reynolds number on the coil before separation",{"$f":"((Properties!J3)*('Storage Tank'!B15)*('Storage Tank'!B20))/(Properties!J4)","v":7799.240470720616}]
["Friction Factor on bigger coil",{"$f":"IF(B106>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$20)))-((5.0452/'Storage Tank'!B106)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$20)^1.1098)+(5.8506/((('Storage Tank'!B106)^0.8981)))))))))^-2,64/B106)","v":3.3023575882961571E-2}]
["Length on bigger coil",1.2,"m"]
["Frictional loss on bigger coil",{"$f":"((B107)*(B108)/(B20))*(((B15)^2)/(2*9.81))","v":0.36356230329865946},"m"]
["Frictional loss on one small coil",{"$f":"(((B287)*(B22))/(B21))*(((B239)^2)/(2*9.81))","v":0.57614207121057204},"m"]
["Frictional loss on all small coils",{"$f":"B110*B23","v":18.436546278738305},"m"]
["Sum of all frictional losses",{"$f":"B109+B111","v":18.800108582036966},"m"]
["Minor Losses on bigger coil"]
["Ball Valve K",0.05]
["90 degree elbow",0.31]
["Minor loss on bigger coil calculation",{"$f":"(B114+B115)*(((B15)^2)/(2*9.81))","v":0.16513761467889906},"m"]
["Minor losses on small coil"]
["Sudden Contraction",{"$f":"(0.5-(0.167*(B20/B21)-0.125*((B20/B21)^2)-0.208*((B20/B21)^3)))","v":2.5754050925925926}]
["Sudden Expansion",{"$f":"(((B20/B21)^2)-1)^2","v":11.157455632716054}]
["180 elbows",0.3]
["# of elbows",{"$f":"INT((B22/B24)-1)","v":9}]
["Minor loss on small coil",{"$f":"(B118+B119+(B121*B120))*((B239)^2)/(2*(9.81))","v":0.13867295647517983},"m"]
["Minor loss on all small coils",{"$f":"B122*B23","v":4.4375346072057544},"m"]
["Sum of all losses (Head loss)",{"$f":"B112+B116+B123","v":23.402780803921619},"m"]
["Output power required by a pump",{"$f":"B31*9.81*B124","v":1499.7545175444127},"w"]
["Volume flow rate in gal/min",{"$f":"(B32/(3.785411784*10^-3))*60","v":93.366328464940423},"gal/min"]
["Head loss in ft",{"$f":"B124/(3.048*10^-1)","v":76.780776915753336},"ft"]
[]
["Post analysis in the process (2nd system)"]
[]
["Initial Temperature of glycol in the air conditioner",265,"K"]
[]
["Diameter of tube",{"$f":"B20","v":0.05},"m"]
[]
["Velocity inside the tube",{"$f":"B15","v":3},"m/s"]
["Power needed in order to  melt all the ice",{"$f":"((B11*1000)/(12*3600))","v":10550.56},"w"]
["Temperature of air",{"$f":"20+273","v":293},"K"]
["Velocity of air",{"$f":"B160","v":2},"m/s"]
["Mass flow rate of glycol",{"$f":"(Properties!J3)*'Storage Tank'!B135*((3.1416*(('Storage Tank'!B133)^2))/4)","v":6.5325645000000012},"kg/s"]
[]
[]
[]
["Inside analysis"]
["Reynolds number",{"$f":"B135*B133*(Properties!J3/Properties!J4)","v":7799.2404707206151}]
["Nusselt Number on the inside",{"$f":"IF(B144<2300,3.66,(((B107/8)*(B144-1000))*(Properties!J$5))/(1+(12.7*(('Storage Tank'!B107/8)^0.5)*((Properties!J$5)^(2/3)-1))))","v":291.60597534363808}]
["Heat transfer coefficient on the inside",{"$f":"(Properties!J6/'Storage Tank'!B133)*'Storage Tank'!B145","v":1411.3729206632083},"w/m^2-K"]
[]
[]
[]
[]
[]
[]
[]
["These calculations are for the A/C unit"]
["Effectiveness NTU-Method"]
["Post analysis in the process"]
["Mass flow rate of glycol",{"$f":"B139","v":6.5325645000000012},"kg/s"]
["Side length of the frontal area",{"$f":"1.7","v":1.7},"m"]
["Frontal area of the heat exchanger",{"$f":"B158^2","v":2.8899999999999997},"m^2"]
["Velocity of air",2,"m/s"]
["Mass flow rate of air",{"$f":"B159*B160*Properties!N2","v":6.9591199999999986},"kg/s"]
["Capacitance of glycol",{"$f":"Properties!J2*'Storage Tank'!B157","v":14985.702963000003}]
["Capacitance of air",{"$f":"B161*Properties!N6","v":7007.8338399999984}]
["Capacity Ratio",{"$f":"IF(B163<B162,(B163/B162),B162/B163)","v":0.46763464198526278}]
["Qmax",{"$f":"B163*(B137-B131)","v":196219.34751999995},"w"]
["Effectiveness (E)",{"$f":"B136/B165","v":5.3769213552830805E-2}]
["Hydraulic Diameter",{"$f":"((4*(B159))/(4*B160))","v":1.4449999999999998}]
["Reynolds Number in the air side",{"$f":"(('Storage Tank'!B160)*B167)/(Properties!N4)","v":190633.24538258574}]
["Nusselt Number",{"$f":"(0.3+((0.62*((B168)^0.5)*(Properties!N3))/((1+(0.4/Properties!N3)^(2/3))^(1/4)))*((1+(('Storage Tank'!B168/282000)^(5/8)))^(4/5)))","v":276.76270335222358}]
["Heat transfer coefficient",{"$f":"(Properties!N5/'Storage Tank'!B133)*'Storage Tank'!B169","v":139.15628724549799}]
["Number of transfer units NTU",{"$f":"(-LN(B164*LN(1-B166)+1)/B164)","v":5.5995556658514238E-2}]
["Surface area on the tube",{"$f":"(B171*B163)/B170","v":2.8199053352788308},"m^2"]
["Length of the tube",{"$f":"B172/(3.1416*B133)","v":17.952032946771268},"m"]
["Exit temperature of glycol",{"$f":"B131+(B175/B162)","v":265.70404171402902},"K"]
["Heat transfer",{"$f":"B166*B165","v":10550.56},"w"]
["# of tube turns",{"$f":"B173/B158","v":10.560019380453687}]
["St or separation between each turn",{"$f":"(B158/(B176/2))-0.05","v":0.27196910606937985},"m"]
[]
["Pump Selection # 2"]
["Friction Factor",{"$f":"B107","v":3.3023575882961571E-2}]
["Frictional Loss",{"$f":"(((B180)*(B173))/(B133))*(((B135)^2)/(2*9.81))","v":5.4389020391846525},"m"]
["Minor Losses"]
["# 180 elbow",{"$f":"INT(B176)","v":10}]
["180 elbow k loss",0.3]
["ball valve",0.05]
["Minor Loss",{"$f":"((B183*B184)+(2*B185))*((B135^2)/(2*9.81))","v":1.4220183486238531},"m"]
["Sum or all loses",{"$f":"B181+B186","v":6.8609203878085054},"m"]
["Work output pump needed",{"$f":"B157*(9.81)*(B187)","v":439.67836268432325},"w"]
[]
["Total Tank Volume",{"$f":"B10+B29","v":1.6776711139736864},"m^3"]
["Tank width",{"$f":"B21*B23+(0.05*B23)","v":2.3680000000000003},"m"]
["Tank Height",{"$f":"B190/(B191*B193)","v":0.59039664765402811},"m"]
["Tank Length",{"$f":"B24","v":1.2},"m"]
["St of small coils",{"$f":"B192/(B22/B24)","v":5.4498152091141054E-2}]
[]
["Tank Insulation"]
["Surface are of the tank",{"$f":"(2*B193*B191)+(2*B192*B191)+(2*B193*B192)","v":9.8962704776591455},"m^2"]
["Insulation Thickness 1",0.02,"m"]
["Insulation Thickness 2",0.2,"m"]
["Insulation Thickness 3",0.3,"m"]
["Resistance on the insulation",{"$f":"(B198)/(B204*B197)+((B199)/((B205)*(B197)))+((B200)/(B206*B197))","v":127.70636405069003}]
["Heat transfer through the insulation",{"$f":"(20)/B201","v":0.15660926648934639},"w"]
["Insulator Aluminum foil & polyurethane foam"]
["Thermal conductivity aluminum foil",1.7E-5,"w/m k"]
["Thermal conductivity polyurethane foam",2.3E-3,"w/m k"]
["Thermal conductivity concrete",0.77,"w/m k"]
[]
["Cost Analysis"]
["Length of small coils (0.05)"]
["Length of large tubes (0.1)",{"$f":"B22*B23","v":416},"m","Total cost of small coils",{"$f":"B210*B217","v":3440.3199999999997}]
["Diameter of small coils ",{"$f":"B108+B173","v":19.152032946771268},"m","Total cost of large coils",{"$f":"B211*B218","v":344.73659304188283}]
["Diameter of large coils",0.05,"m","Total cost",{"$f":"E210+E211+B219+B220+B221+B223+B222+B224","v":5110.0565930418825}]
["Volume of aluminum foil",0.1,"m"]
["Volume of polyurethane foam",{"$f":"B197*B198","v":0.19792540955318291},"m^3","3-ton air conditioner price",3200]
["Volume of concrete",{"$f":"B197*B199","v":1.9792540955318292},"m^4","Difference in price",{"$f":"E212-E214","v":1910.0565930418825}]
["Cost of of small coils",{"$f":"B197*B200","v":2.9688811432977436},"m^5"]
["Cost of large coils",8.27,"$/m"]
["Chiller",18,"$/m"]
["Tank material",350,"$"]
["Aluminum foil",75,"$"]
["Polyurethane foam",100,"$"]
["Pumps",300,"$"]
["Ball valves (3)",200,"$"]
[null,300,"$"]
["Operating Cost"]
[]
["On-Peak hrs"]
["Off Peak hrs",0.21,"$/kw-h"]
["3-ton air conditioner power input",6.8000000000000005E-2,"$/kw-h"]
["3-ton air conditioner",20,"kw-hr"]
["By usign the thermal storage tank",{"$f":"B230*B228*7*4*6","v":705.6},"$/yr"]
["Power input",{"$f":"(B233*B229)*7*4*6","v":335.57591314854602},"$/yr"]
["Difference in price",{"$f":"(B188+B125+B103)/1000","v":29.374642257400733},"Kw"]
["In how much time it is going to be paid off",{"$f":"B231-B232","v":370.024086851454}]
[null,{"$f":"E215/B234","v":5.1619790735641322},"Yrs"]
[]
[]
["Velocity of coil 1"]
["Velocity of coil 2",{"$f":"B255/B$27","v":0.40690104166666674},"m/s"]
["Velocity of coil 3",{"$f":"B256/B$27","v":0.40690104166666674},"m/s"]
["Velocity of coil 4",0.40690104166666674,"m/s"]
["Velocity of coil 5",0.40690104166666674,"m/s"]
["Velocity of coil 6",0.40690104166666674,"m/s"]
["Velocity of coil 7",0.40690104166666674,"m/s"]
["Velocity of coil 8",0.40690104166666674,"m/s"]
["Velocity of coil 9",0.40690104166666674,"m/s"]
["Velocity of coil 10",0.40690104166666674,"m/s"]
["Velocity of coil 11",0.40690104166666674,"m/s"]
["Velocity of coil 12",0.40690104166666674,"m/s"]
["Velocity of coil 13",0.40690104166666674,"m/s"]
["Velocity of coil 14",0.40690104166666674,"m/s"]
["Velocity of coil 15",0.40690104166666674,"m/s"]
["Velocity of coil 16",0.40690104166666674,"m/s"]
["Volume flow rate 1",0.40690104166666674,"m/s"]
["Volume flow rate 2",{"$f":"B$32/B$23","v":1.8407812500000005E-4},"m^3/s"]
["Volume flow rate 3",{"$f":"B$32/B$23","v":1.8407812500000005E-4},"m^3/s"]
["Volume flow rate 4",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 5",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 6",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 7",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 8",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 9",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 10",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 11",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 12",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 13",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 14",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 15",1.8407812500000005E-4,"m^3/s"]
["Volume flow rate 16",1.8407812500000005E-4,"m^3/s"]
["Reynolds number 1",1.8407812500000005E-4,"m^3/s"]
["Reynolds number 2",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B255))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 3",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B256))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 4",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B257))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 5",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B258))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 6",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B259))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 7",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B260))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 8",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B261))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 9",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B262))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 10",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B263))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 11",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B264))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 12",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B265))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 13",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B266))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 14",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B267))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 15",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B268))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Reynolds number 16",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B269))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Friction Factor f 1",{"$f":"(4*(Properties!J$3)*('Storage Tank'!B270))/(3.1416*('Storage Tank'!B$21)*(Properties!J$4))","v":507.76305147920687}]
["Friction Factor f 2",{"$f":"IF(B271>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B271)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B271)^0.8981)))))))))^-2,64/B271)","v":0.12604304274120826}]
["Friction Factor f 3",{"$f":"IF(B272>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B272)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B272)^0.8981)))))))))^-2,64/B272)","v":0.12604304274120826}]
["Friction Factor f 4",{"$f":"IF(B273>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B273)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B273)^0.8981)))))))))^-2,64/B273)","v":0.12604304274120826}]
["Friction Factor f 5",{"$f":"IF(B274>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B274)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B274)^0.8981)))))))))^-2,64/B274)","v":0.12604304274120826}]
["Friction Factor f 6",{"$f":"IF(B275>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B275)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B275)^0.8981)))))))))^-2,64/B275)","v":0.12604304274120826}]
["Friction Factor f 7",{"$f":"IF(B276>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B276)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B276)^0.8981)))))))))^-2,64/B276)","v":0.12604304274120826}]
["Friction Factor f 8",{"$f":"IF(B277>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B277)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B277)^0.8981)))))))))^-2,64/B277)","v":0.12604304274120826}]
["Friction Factor f 9",{"$f":"IF(B278>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B278)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B278)^0.8981)))))))))^-2,64/B278)","v":0.12604304274120826}]
["Friction Factor f 10",{"$f":"IF(B279>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B279)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B279)^0.8981)))))))))^-2,64/B279)","v":0.12604304274120826}]
["Friction Factor f 11",{"$f":"IF(B280>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B280)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B280)^0.8981)))))))))^-2,64/B280)","v":0.12604304274120826}]
["Friction Factor f 12",{"$f":"IF(B281>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B281)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B281)^0.8981)))))))))^-2,64/B281)","v":0.12604304274120826}]
["Friction Factor f 13",{"$f":"IF(B282>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B282)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B282)^0.8981)))))))))^-2,64/B282)","v":0.12604304274120826}]
["Friction Factor f 14",{"$f":"IF(B283>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B283)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B283)^0.8981)))))))))^-2,64/B283)","v":0.12604304274120826}]
["Friction Factor f 15",{"$f":"IF(B284>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B284)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B284)^0.8981)))))))))^-2,64/B284)","v":0.12604304274120826}]
["Friction Factor f 16",{"$f":"IF(B285>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B285)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B285)^0.8981)))))))))^-2,64/B285)","v":0.12604304274120826}]
["Pressure Drop 1",{"$f":"IF(B286>2300,(-2*(LOG((0.0000015/(3.7065*('Storage Tank'!B$21)))-((5.0452/'Storage Tank'!B286)*(LOG((1/2.8257)*((0.0000015/'Storage Tank'!B$21)^1.1098)+(5.8506/((('Storage Tank'!B286)^0.8981)))))))))^-2,64/B286)","v":0.12604304274120826}]
["Pressure Drop 2",{"$f":"((B287*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B239)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 3",{"$f":"((B288*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B240)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 4",{"$f":"((B289*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B241)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 5",{"$f":"((B290*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B242)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 6",{"$f":"((B291*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B243)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 7",{"$f":"((B292*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B244)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 8",{"$f":"((B293*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B245)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 9",{"$f":"((B294*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B246)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 10",{"$f":"((B295*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B247)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 11",{"$f":"((B296*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B248)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 12",{"$f":"((B297*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B249)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 13",{"$f":"((B298*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B250)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 14",{"$f":"((B299*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B251)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 15",{"$f":"((B300*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B252)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure Drop 16",{"$f":"((B301*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B253)^2)/2)","v":6268.0166739004635},"Pa"]
["Pressure change for calculations",{"$f":"((B302*B$22)/(B$21))*(Properties!J$3*(('Storage Tank'!B254)^2)/2)","v":6268.0166739004635},"Pa"]
["Mass flow continuity",{"$f":"B303+B304+B305+B306+B307+B308+B309+B310-B311-B312-B313-B314-B315-B316-B317-B318","v":0},"Pa"]
["Mass flow rate coil 1",{"$f":"B32-B255-B256-B257-B258-B259-B260-B261-B262-B263-B264-B265-B266-B267-B268-B269-B270","v":2.9452500000000026E-3},"m^3/s"]
["Mass flow rate coil 2",{"$f":"(Properties!J$3)*'Storage Tank'!B255","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 3",{"$f":"(Properties!J$3)*'Storage Tank'!B256","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 4",{"$f":"(Properties!J$3)*'Storage Tank'!B257","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 5",{"$f":"(Properties!J$3)*'Storage Tank'!B258","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 6",{"$f":"(Properties!J$3)*'Storage Tank'!B259","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 7",{"$f":"(Properties!J$3)*'Storage Tank'!B260","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 8",{"$f":"(Properties!J$3)*'Storage Tank'!B261","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 9",{"$f":"(Properties!J$3)*'Storage Tank'!B262","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 10",{"$f":"(Properties!J$3)*'Storage Tank'!B263","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 11",{"$f":"(Properties!J$3)*'Storage Tank'!B264","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 12",{"$f":"(Properties!J$3)*'Storage Tank'!B265","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 13",{"$f":"(Properties!J$3)*'Storage Tank'!B266","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 14",{"$f":"(Properties!J$3)*'Storage Tank'!B267","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 15",{"$f":"(Properties!J$3)*'Storage Tank'!B268","v":0.20414264062500007},"kg/s"]
["Mass flow rate coil 16",{"$f":"(Properties!J$3)*'Storage Tank'!B269","v":0.20414264062500007},"kg/s"]
[null,{"$f":"(Properties!J$3)*'Storage Tank'!B270","v":0.20414264062500007},"kg/s"]

{"sheet":"Properties","index":1,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Properties of Water at 0",null,null,null,"Properties of water from 25 to 0",null,null,null,"Properties of Glycol",null,null,null,"Properties of air"]
["Latent heat of Fusion of water",333.7,"KJ/Kg",null,"Cp of water ranging from 0 to 26.66 C",4.2,"KJ/KgK",null,"Cp of Ethyene Glycol",2294,"J/KgK",null,"Density of air",1.204,"kg/m^3","at 20"]
["Density of ice",917,"Kg/m^3",null,"Pr of water @ 10",9.4499999999999993,null,null,"Density of glycol room temp",1109,"kg/m^3",null,"Pr ",0.73089999999999999]
["Pr of water at 0",13.5,null,null,"B volume expansion @ 10",{"$f":"0.733*10^-3","v":7.3300000000000004E-4},"1/k",null,"Dynamic Viscosity",2.1329000000000001E-2,"kg/m s",null,"Kinematic Viscocity",{"$f":"1.516*10^-5","v":1.5160000000000001E-5},"m^2/s"]
["B volume expansion water at 0",{"$f":"-0.068*10^-3","v":-6.8000000000000013E-5},"1/k",null,"Dynamic viscosity @ 10",{"$f":"1.307*10^-3","v":1.307E-3},"kg/m*s",null,"Pr of Glycol",{"$f":"615","v":615},null,null,"Thermal conductivity",2.5139999999999999E-2,"w/m*K"]
["Dynamic viscosity at 0",{"$f":"1.792*10^-3","v":1.792E-3},"kg/m*s",null,"Thermal conductivity @ 10",0.57999999999999996,"w/m*k",null,"Thermal conductivity",0.24199999999999999,"w/m*k",null,"Cp",1007,"J/kg*K"]
["Thermal conductivity at 0 ",0.56100000000000005,"w/m*k",null,"Pr of water @ 15",8.09]
[null,null,null,null,"B volume of expansion @ 15",{"$f":"0.138*10^-3","v":1.3800000000000002E-4},"1/k"]
[null,null,null,null,"Dynamic viscosity @ 15",{"$f":"1.138*10^-3","v":1.1379999999999999E-3},"kg/m*s"]
[null,null,null,null,"Thermal conductivity @ 15",0.58899999999999997,"w/m*k"]
[null,null,null,null,"Pr of water @ 5",11.2]
[null,null,null,null,"B volume expansion @ 5",1.5E-5,"1/k"]
[null,null,null,null,"Dynamic viscosity @ 5",1.519E-3,"kg/m*s"]
[null,null,null,null,"Thermal conductivity @ 5",0.57099999999999995,"w/m*k"]
[null,null,null,null,"Pr of water @ 0",13.5]
[null,null,null,null,"B volume expansion @ 0",-6.7999999999999999E-5,"1/k"]
[null,null,null,null,"Dynamic viscosity @ 0",1.792E-3,"kg/m*s"]
[null,null,null,null,"Thermal conductivity @ 0",0.56100000000000005,"w/m*k"]

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}