{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Settings Tabel for MRFH"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":37,"comments":1,"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":"Settings Tabel for MRFH","index":0,"n_rows":76,"n_cols":10,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Calculation Sheet for Bucket Humidifier"]
["Chris Callahan, March 4, 2014 (chris.callahan@uvm.edu)"]
["Source: http://blog.uvm.edu/cwcallah "]
["Anything in blue is an input you can adjust.  The main ones are outlined. Other cells are calculated and have been locked from editing."]
["If you run into problems with the solver routine, reference this page: http://peltiertech.com/Excel/SolverVBA.html"]
[]
[null,null,"Solving for RH when you know Tdb and Twb",null,null,null,null,null,"Solving for Twb when you know Tdb and RH"]
[]
[null,null,"Case 1","Case 2","Case 3","Case 4","Case 5",null,"Case 6"]
["Room Temp(DB)","degF",35,35,35,35,35,null,35]
["Room Temp(WB)","degF",34.24,34.46,34.78,34.89,34.950000000000003,null,26.951301357407218]
["Room RH","%",{"$f":"C55","v":0.93023508044006864},{"$f":"D55","v":0.9503457258514636},{"$f":"E55","v":0.97972016891040614},{"$f":"F55","v":0.9898514013678269},{"$f":"G55","v":0.99538484427903196},null,0.3,{"$f":"IF(I56>0.001, \"click Solve\", \"\")","v":""}]
["Water Temp","degF",100,100,100,100,100,null,100]
["Air Flow from Fan","CFM",30,30,30,30,30,null,30]
["Bucket Diameter","inch",12,12,12,12,12,null,12]
["Free Height / Air Space","inch",3,3,3,3,3,null,3]
["Humid. Rate","gal/24 hr",{"$f":"C35","v":0.87688011888094763},0.87494409332444334,0.87211529569374935,0.87113938064538632,0.87060630141381889,null,{"$f":"I35","v":0.93728315628596892}]
[]
["Calculation of Evaporation from a Water Surface"]
["xs",null,{"$f":"C70","v":4.3001211556436582E-2},4.3001211556436582E-2,4.3001211556436582E-2,4.3001211556436582E-2,4.3001211556436582E-2,null,{"$f":"I70","v":4.3001211556436582E-2}]
["x",null,{"$f":"C51","v":3.9612314191604138E-3},4.0474260969091264E-3,4.1733682877933276E-3,4.2168174472432922E-3,4.240550911104402E-3,null,{"$f":"I51","v":1.2720002121254484E-3}]
["Diameter","in",{"$f":"C15","v":12},{"$f":"D15","v":12},12,12,12,null,{"$f":"I15","v":12}]
["Free Height","in",{"$f":"C16","v":3},{"$f":"D16","v":3},3,3,3,null,{"$f":"I16","v":3}]
["Surface Area","in2",{"$f":"3.14*C22^2/4","v":113.04},113.04,113.04,113.04,113.04,null,{"$f":"3.14*I22^2/4","v":113.04}]
[null,"ft2",{"$f":"C24/144","v":0.78500000000000003},0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,null,{"$f":"I24/144","v":0.78500000000000003}]
[null,"m2",{"$f":"C25/3.28/3.28","v":7.2966240333135049E-2},7.2966240333135049E-2,7.2966240333135049E-2,7.2966240333135049E-2,7.2966240333135049E-2,null,{"$f":"I25/3.28/3.28","v":7.2966240333135049E-2}]
["Crosssectional Flow Area","in2",{"$f":"C22/2*C23","v":18},18,18,18,18,null,{"$f":"I22/2*I23","v":18}]
["CFM (Air Flow)","ft3/min",{"$f":"C14","v":30},{"$f":"D14","v":30},30,30,30,null,{"$f":"I14","v":30}]
["Air Velocity","ft/s",{"$f":"C28/(C27/144)/60","v":4},4,4,4,4,null,{"$f":"I28/(I27/144)/60","v":4}]
[null,"m/s",{"$f":"C29/3.28","v":1.2195121951219512},1.2195121951219512,1.2195121951219512,1.2195121951219512,1.2195121951219512,null,{"$f":"I29/3.28","v":1.2195121951219512}]
["phi (Evap calculation rate)","kg/m2/h",{"$f":"25+19*C30","v":48.170731707317074},48.170731707317074,48.170731707317074,48.170731707317074,48.170731707317074,null,{"$f":"25+19*I30","v":48.170731707317074}]
[]
["gh (Evaporation rate)","kg/h",{"$f":"C31*C26*(C20-C21)","v":0.13721917395761438},0.13691621369896079,0.13647354740305656,0.13632083068168754,0.13623741142033743,null,{"$f":"I31*I26*(I20-I21)","v":0.14667138380794764}]
[null,"lb/hr",{"$f":"C33*2.21","v":0.30325437444632775},0.30258483227470334,0.30160653976075502,0.30126903580652947,0.30108467923894572,null,{"$f":"I33*2.21","v":0.32414375821556429}]
[null,"gal/24 hr",{"$f":"C34*24/8.3","v":0.87688011888094763},0.87494409332444334,0.87211529569374935,0.87113938064538632,0.87060630141381889,null,{"$f":"I34*24/8.3","v":0.93728315628596892}]
[]
["Air Properties (Moisture in Air, etc)"]
["Tdb - Dry Bulb","degF",{"$f":"C10","v":35},{"$f":"D10","v":35},{"$f":"E10","v":35},{"$f":"F10","v":35},{"$f":"G10","v":35},null,{"$f":"I10","v":35}]
[null,"degR",{"$f":"+C38+459.67","v":494.67},494.67,494.67,494.67,494.67,null,{"$f":"+I38+459.67","v":494.67}]
["Twb - Wet Bulb","degF",{"$f":"C11","v":34.24},{"$f":"D11","v":34.46},{"$f":"E11","v":34.78},{"$f":"F11","v":34.89},{"$f":"G11","v":34.950000000000003},null,{"$f":"I11","v":26.951301357407218}]
[null,"degR",{"$f":"+C40+459.67","v":493.91},494.13,494.45000000000005,494.56,494.62,null,{"$f":"+I40+459.67","v":486.62130135740722}]
["P - Pressure","inHG",29.920999999999999,29.920999999999999,29.920999999999999,29.920999999999999,29.920999999999999,null,29.920999999999999]
[null,"psia",{"$f":"C42*0.491154152227","v":14.695823388784067},14.695823388784067,14.695823388784067,14.695823388784067,14.695823388784067,null,{"$f":"I42*0.491154152227","v":14.695823388784067}]
[null,"Pa",{"$f":"C42*3386.38866667","v":101324.13529543307},101324.13529543307,101324.13529543307,101324.13529543307,101324.13529543307,null,{"$f":"I42*3386.38866667","v":101324.13529543307}]
[]
["Pdb","psia",{"$f":"EXP((-1.0440397*10^4)/C39-1.129465*10-2.7022355*10^(-2)*C39 + 1.289036*10^(-5)*C39*C39 -2.4780681*10^(-9)*C39*C39*C39 +  6.5459673*LN(C39))","v":9.9976485514762126E-2},9.9976485514762126E-2,9.9976485514762126E-2,9.9976485514762126E-2,9.9976485514762126E-2,null,{"$f":"EXP((-1.0440397*10^4)/I39-1.129465*10-2.7022355*10^(-2)*I39 + 1.289036*10^(-5)*I39*I39 -2.4780681*10^(-9)*I39*I39*I39 +  6.5459673*LN(I39))","v":9.9976485514762126E-2}]
["Pwb","psia",{"$f":"EXP((-1.0440397*10^4)/C41 -1.129465*10-2.7022355*10^(-2)*C41 + 1.289036*10^(-5)*C41*C41 -2.4780681*10^(-9)*C41*C41*C41 +  6.5459673*LN(C41))","v":9.6991802739106459E-2},9.7847560680308615E-2,9.9104242462632261E-2,9.9539517556556753E-2,9.9777653494881602E-2,null,{"$f":"EXP((-1.0440397*10^4)/I41 -1.129465*10-2.7022355*10^(-2)*I41 + 1.289036*10^(-5)*I41*I41 -2.4780681*10^(-9)*I41*I41*I41 +  6.5459673*LN(I41))","v":7.2135889242414292E-2}]
[]
["Ws","lb/lb",{"$f":"0.62198*(C46/(C43-C46))","v":4.2603471297402665E-3},4.2603471297402665E-3,4.2603471297402665E-3,4.2603471297402665E-3,4.2603471297402665E-3,null,{"$f":"0.62198*(I46/(I43-I46))","v":4.2603471297402665E-3}]
["W*","lb/lb",{"$f":"0.62198*(C47/(C43-C47))","v":4.1323143644821578E-3},4.1690181233738771E-3,4.2229254470818748E-3,4.2415994150311461E-3,4.2518162827280903E-3,null,{"$f":"0.62198*(I47/(I43-I47))","v":3.0681098999416592E-3}]
["W","lb/lb",{"$f":"((1093-0.556*C40)*C50 - 0.24*(C38-C40)) / (1093+0.444*C38-C40)","v":3.9612314191604138E-3},4.0474260969091264E-3,4.1733682877933276E-3,4.2168174472432922E-3,4.240550911104402E-3,null,{"$f":"((1093-0.556*I40)*I50 - 0.24*(I38-I40)) / (1093+0.444*I38-I40)","v":1.2720002121254484E-3}]
[]
["Pw","psia",{"$f":"(C43*C51)/(0.62198+C51)","v":9.3001634044940107E-2},9.5012225694604949E-2,9.7948979275591527E-2,9.8961864290617541E-2,9.9515078465676393E-2,null,{"$f":"(I43*I51)/(0.62198+I51)","v":2.9992828681703738E-2}]
[]
["Relative Humidity (RH)",null,{"$f":"C53/C46","v":0.93023508044006864},0.9503457258514636,0.97972016891040614,0.9898514013678269,0.99538484427903196,null,{"$f":"I53/I46","v":0.29999882999763094}]
["RH Error (used for solver)",null,null,null,null,null,null,null,{"$f":"ABS(I55-I12)","v":1.1700023690441874E-6}]
[]
["Water temp"]
["T","degF",{"$f":"C13","v":100},{"$f":"D13","v":100},{"$f":"E13","v":100},{"$f":"F13","v":100},{"$f":"G13","v":100},null,{"$f":"I13","v":100}]
[null,"degR",{"$f":"+C59+459.67","v":559.67000000000007},559.67000000000007,559.67000000000007,559.67000000000007,559.67000000000007,null,{"$f":"+I59+459.67","v":559.67000000000007}]
["Twb","degF",{"$f":"C40","v":34.24},{"$f":"D40","v":34.46},{"$f":"E40","v":34.78},{"$f":"F40","v":34.89},{"$f":"G40","v":34.950000000000003},null,{"$f":"I40","v":26.951301357407218}]
[null,"degR",{"$f":"+C61+459.67","v":493.91},494.13,494.45000000000005,494.56,494.62,null,{"$f":"+I61+459.67","v":486.62130135740722}]
["P","inHG",{"$f":"C42","v":29.920999999999999},{"$f":"D42","v":29.920999999999999},{"$f":"E42","v":29.920999999999999},{"$f":"F42","v":29.920999999999999},{"$f":"G42","v":29.920999999999999},null,{"$f":"I42","v":29.920999999999999}]
[null,"psia",{"$f":"C63*0.491154152227","v":14.695823388784067},14.695823388784067,14.695823388784067,14.695823388784067,14.695823388784067,null,{"$f":"I63*0.491154152227","v":14.695823388784067}]
[null,"Pa",{"$f":"C63*3386.38866667","v":101324.13529543307},101324.13529543307,101324.13529543307,101324.13529543307,101324.13529543307,null,{"$f":"I63*3386.38866667","v":101324.13529543307}]
[]
["Pdb","psia",{"$f":"EXP((-1.0440397*10^4)/C60-1.129465*10-2.7022355*10^(-2)*C60 + 1.289036*10^(-5)*C60*C60 -2.4780681*10^(-9)*C60*C60*C60 +  6.5459673*LN(C60))","v":0.9503098727526984},0.9503098727526984,0.9503098727526984,0.9503098727526984,0.9503098727526984,null,{"$f":"EXP((-1.0440397*10^4)/I60-1.129465*10-2.7022355*10^(-2)*I60 + 1.289036*10^(-5)*I60*I60 -2.4780681*10^(-9)*I60*I60*I60 +  6.5459673*LN(I60))","v":0.9503098727526984}]
["Pwb","psia",{"$f":"EXP((-1.0440397*10^4)/C62 -1.129465*10-2.7022355*10^(-2)*C62 + 1.289036*10^(-5)*C62*C62 -2.4780681*10^(-9)*C62*C62*C62 +  6.5459673*LN(C62))","v":9.6991802739106459E-2},9.7847560680308615E-2,9.9104242462632261E-2,9.9539517556556753E-2,9.9777653494881602E-2,null,{"$f":"EXP((-1.0440397*10^4)/I62 -1.129465*10-2.7022355*10^(-2)*I62 + 1.289036*10^(-5)*I62*I62 -2.4780681*10^(-9)*I62*I62*I62 +  6.5459673*LN(I62))","v":7.2135889242414292E-2}]
[]
["Ws","lb/lb",{"$f":"0.62198*(C67/(C64-C67))","v":4.3001211556436582E-2},4.3001211556436582E-2,4.3001211556436582E-2,4.3001211556436582E-2,4.3001211556436582E-2,null,{"$f":"0.62198*(I67/(I64-I67))","v":4.3001211556436582E-2}]
["W*","lb/lb",{"$f":"0.62198*(C68/(C64-C68))","v":4.1323143644821578E-3},4.1690181233738771E-3,4.2229254470818748E-3,4.2415994150311461E-3,4.2518162827280903E-3,null,{"$f":"0.62198*(I68/(I64-I68))","v":3.0681098999416592E-3}]
["W","lb/lb",{"$f":"((1093-0.556*C61)*C71 - 0.24*(C59-C61)) / (1093+0.444*C59-C61)","v":-1.0283593573367385E-2},{"$f":"((1093-0.556*D61)*D71 - 0.24*(D59-D61)) / (1093+0.444*D59-D61)","v":-1.0202495673229589E-2},-1.0083985477588866E-2,-1.0043096160367922E-2,-1.002076007741614E-2,null,{"$f":"((1093-0.556*I61)*I71 - 0.24*(I59-I61)) / (1093+0.444*I59-I61)","v":-1.2809433667022842E-2}]
[]
["Pw","psia",{"$f":"(C64*C72)/(0.62198+C72)","v":-0.24706026285012697},-0.24507941772656447,-0.24218570821935248,-0.24118755793819738,-0.24064236751734536,null,{"$f":"(I64*I72)/(0.62198+I72)","v":-0.30901882869044617}]
[]
["RH",null,{"$f":"C74/C67","v":-0.25997863426850887},-0.25789421403847934,-0.25484919726007843,-0.25379885535605945,-0.2532251578322478,null,{"$f":"I74/I67","v":-0.32517691076420391}]