{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Cross_Check"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":40,"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":"Cross_Check","index":0,"n_rows":60,"n_cols":16,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"FROM:","Mark Biegert"]
[null,"SUBJECT:","Verify Calculation of Key Parameters"]
[null,"DATE:","2016-10-26"]
[]
[]
[null,"Constants"]
[]
[null,null,"Constant","Symbol ","Value ","Unit"]
[null,null,"Universal Gas Constant","R_d",8.3144720000000003,"J/mol K"]
[null,null,"Molar Mass of Air","MW_air",28.9664,"gm/mol"]
[null,null,"Molar Mass of H2O","MW_H2O",18.015280000000001,"gm/mol"]
[null,null,"Air Pressure","p_Air",{"$f":"INDEX(B48:B57,C44)","v":1},"atm"]
[null,null,"Epsilon","eps",{"$f":"MW_H2O/MW_air","v":0.62193714096332309},"unitless"]
[]
[null,"Simulation Parameters"]
[]
[null,null,"Parameters","Symbol","Value","Unit"]
[null,null,"Room Temperature","T_R",{"$f":"INDEX($D$48:$D$57,C44)","v":87},"°F"]
[null,null,"Room Humidity","RH_R",{"$f":"INDEX($C$48:$C$57,C44)","v":0.7},"unitless"]
[null,null,"Recovery Efficiency","e_Rec",0.7,"unitless"]
[null,null,"Heating Efficiency","e_Heat",0.8,"unitless"]
[null,null,"Air Chg. Rate @ 50Pa","ACH50",1,"per hour"]
[null,null,"House Area","A_House",2500,"ft2"]
[null,null,"Ceiling Height","h_ceiling",8.2285699999999995,"ft"]
[null,null,"Natural Gas Cost","k_Rate",1.5,"per therm"]
[null,null,"Fan Flow Rate","F_fan",100,"cfm"]
[null,null,"Vent. Air Chg. Rate","ACH_v",0.35,"per hour"]
[]
[null,"Air Characteristics"]
[]
[null,null,"Parameter","House","Units"]
[null,null,"Dry Air Density",{"$f":"CONVERT(p_Air,\"atm\",\"Pa\")*MW_air/(R_d*((T_R-32)*5/9+273.15))*0.001","v":1.1623146842469829},"gm/cm3"]
[null,null,"Sat Vapor Pressure",{"$f":"6.1094*EXP(17.625*CONVERT(T_R,\"F\",\"C\")/(243.04+CONVERT(T_R,\"F\",\"C\")))*100","v":4373.7881869885978},"Pa"]
[null,null,"Vapor Pressure @ Dew",{"$f":"6.1094*EXP(17.625*D36/(243.04+D36))*100","v":3061.6517308920202},"Pa"]
[null,null,"Moist Air Density",{"$f":"D32*(1-0.378*RH_R*D33/CONVERT(p_Air,\"atm\",\"Pa\"))","v":1.1490390677148405},"gm/cm3",null,null,null,null,null,null,null,1.2362957321637233,1.3024850686967713,4.1297128422351313E-3,22.149634355541494]
[null,null,"Dew Point Temperature",{"$f":"-(5354475*(T_R-32)*5/9+73835552*LN(RH_R)+303800*(T_R-32)*5/9*LN(RH_R))/\n  (303800*LN(RH_R)+1250*(T_R-32)*5/9*LN(RH_R)-5354475)","v":24.461574493784472},"°C",null,null,null,null,null,null,null,1.1854767500137493,-11.242616227158415,1.680712115485546E-3,13.732429915254635]
[null,null,"Specific Humidity",{"$f":"eps*D34/(CONVERT(p_Air,\"atm\",\"Pa\")-(1-eps)*D34)","v":1.9009707374485253E-2},"unitless",null,null,null,null,null,null,null,1.2427172431738822,-8.1747499366012111,2.0330281883945939E-3,15.741154235253779]
[null,null,"Moist Air Enthalpy",{"$f":"1.006*(T_R-32)*5/9+D37*(2501+1.755*(T_R-32)*5/9)","v":79.301562590433278},"kJ/kg",null,null,null,null,null,null,null,1.2052672752721632,17.305969535168007,1.16066231861698E-2,62.100074685344126]
[null,null,null,null,null,null,null,null,null,null,null,null,1.1686534714500445,17.44733141910806,1.2301415592907119E-2,58.168213314275427]
[null,null,"Output Value",{"$f":"INDEX($D$35:$D$38,C45)","v":79.301562590433278},null,null,null,null,null,null,null,null,1.3044873400101384,0.23060584568779441,3.4738240796211065E-3,32.865896319892727]
[null,null,null,null,null,null,null,null,null,null,null,null,1.1576352031265953,13.727438049100808,9.6783607474746035E-3,54.895145922788522]
[null,"Test Cases",null,null,null,null,null,null,null,null,null,null,1.1685932560212282,2.373369536022722,4.5735658328425778E-3,32.282368424247977]
[null,null,null,null,null,null,null,null,null,null,null,null,1.1607984312668282,19.826494696414265,1.4292737889124005E-2,64.960177185569165]
[null,"Parameter Select",10,{"$f":"C44+ROW(G48)-1","v":57},null,null,null,null,null,null,null,null,1.1490390677148405,24.461574493784472,1.9009707374485253E-2,79.301562590433278]
[null,"Output Select",4,{"$f":"C45+COLUMN(G48)-1","v":10},null,null,"My Values"]
[null,null,null,null,null,null,"Moist Density","Dewpoint","Humidity Ratio","Enthalpy"]
[null,"Pressure \n(atm)","Rel. Humidity\n(%)","Temperature\n(°F)","Temperature\n(°C)",{"$f":"D40","v":79.301562590433278},1,2,3,4]
[null,1,0.49,53,{"$f":"CONVERT(D48,\"F\",\"C\")","v":11.666666666666666},1,1.2362957321637233,1.3024850686967713,4.1297128422351313E-3,22.149634355541494]
[null,0.95,0.22,49,{"$f":"CONVERT(D49,\"F\",\"C\")","v":9.4444444444444446},2,1.1854767500137493,-11.242616227158415,1.680712115485546E-3,13.732429915254635]
[null,1,0.26,51,10.555555555555555,3,1.2427172431738822,-8.1747499366012111,2.0330281883945939E-3,15.741154235253779]
[null,1.05,0.41000000000000003,90,32.222222222222221,4,1.2052672752721632,17.305969535168007,1.16066231861698E-2,62.100074685344126]
[null,1,0.57000000000000006,80,26.666666666666664,5,1.1686534714500445,17.44733141910806,1.2301415592907119E-2,58.168213314275427]
[null,1.1000000000000001,0.21,75,23.888888888888889,6,1.3044873400101384,0.23060584568779441,3.4738240796211065E-3,32.865896319892727]
[null,1,0.37,86,30,7,1.1576352031265953,13.727438049100808,9.6783607474746035E-3,54.895145922788522]
[null,0.97499999999999998,0.3,69,20.555555555555554,8,1.1685932560212282,2.373369536022722,4.5735658328425778E-3,32.282368424247977]
[null,1,0.6,83,28.333333333333332,9,1.1607984312668282,19.826494696414265,1.4292737889124005E-2,64.960177185569165]
[null,1,0.7,87,30.555555555555554,10,1.1490390677148405,24.461574493784472,1.9009707374485253E-2,79.301562590433278]
[]
[]
[null,"Cleanup"]