{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Blank for Calculation","Functions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":188,"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":127,"n_cols":40,"rows_kept":127,"cut":false,"hidden":false,"merged":[[101,6,101,9],[64,7,64,11],[1,1,1,12],[1,33,1,34],[24,9,24,10],[42,9,42,10],[36,9,36,10]]}
[]
[null,"COST OF STEAM\nCALCULATOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Unit",1,2,"Paste Values\n (non formulated)",null,"Temp/\nPressure"]
[null,"User Defined",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Preferences",1,"1: English 2: Metric",null,null,null,null,null,null,"Type of Cost",null,null,{"$f":"IF(Units_Pref, \"Unit Preferences - English\", \"Unit Preferences - Metric\")","v":"Unit Preferences - English"},null,null,2,"English","Metric","English","Metric"]
[null,null,"Type of Cost:",null,null,null,null,null,null,null,null,null,null,null,null,"Type of Cost",3,"1: Unloaded 2: Modified Unloaded 3: Loaded",null,null,null,null,null,null,"Unloaded",null,null,"Mass",{"$f":"IF(AD4=\"lb\",1,0.45359237)","v":1},{"$f":"IF(Units_Pref=1,\"lb\",\"kg\")","v":"lb"}]
[null,null,"Fuel Cost:",null,8,{"$f":"IF(Units_Pref=1,\"US$ / MMBtu\",\"US$ / GJ\")","v":"US$ / MMBtu"},null,null,null,null,null,null,{"$f":"IF(ISBLANK(E5),\"¬\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Modified Unloaded",null,null,"Length",{"$f":"IF(AD5=\"ft\",1,0.3048)","v":1},{"$f":"IF(Units_Pref=1,\"ft\",\"m\")","v":"ft"},null,{"$f":"IF(Units_Pref=$AF$2,$E5,$E5*Unit_Preference_Energy_SI)","v":8},{"$f":"IF(Units_Pref=$AG$2,$E5,$E5/Unit_Preference_Energy_SI)","v":7.5825369597755312},8,7.5825369597755312]
[null,null,"Overall Boiler Efficiency:",null,80,"%",null,null,null,null,null,null,{"$f":"IF(ISBLANK(E6),\"¬\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Loaded",null,null,"Pressure",{"$f":"IF(AD6=\"psia\",1,0.06894757293)","v":1},{"$f":"IF(Units_Pref=1,\"psia\",\"bara\")","v":"psia"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy",{"$f":"IF(AD7=\"Btu\",1,1.055055853)","v":1},{"$f":"IF(Units_Pref=1,\"Btu\",\"kJ\")","v":"Btu"}]
[null,"Unloaded Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Velocity",{"$f":"IF(AD8=\"ft/s\",1,0.3048)","v":1},{"$f":"IF(Units_Pref=1,\"ft/s\",\"m/s\")","v":"ft/s"}]
[null,null,"Steam Distribution Header"]
[null,null,"Saturated Steam Generated at:",null,200,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E10),\"¬\",\"\")","v":""},null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,"Pressure",null,"Temperature",null,"Enthalpy",null,null,"Unit Conversion: 1 English unit to SI unit",null,null,null,{"$f":"IF($Q10=1,IF(Units_Pref=$AF$2,$E10,$E10/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$E10,$E10*9/5+32))","v":200},{"$f":"IF($Q10=1,IF(Units_Pref=$AG$2,$E10,$E10*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$E10,($E10-32)*5/9))","v":13.789514586000001},200,13.789514586000001,{"$f":"IF(Q10=1,psat_t(U11),Tsat_p(W11))","v":15.513224864729372}]
[null,null,"Total Enthalpy:",null,{"$f":"IF(Q10=1,hV_p(U11),hV_T(W11))*Unit_Preference_Energy/Unit_Preference_Mass","v":1199.747844407362},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q10=1,(E10+T36)/Unit_Preference_Pres,psat_t(W11))","v":214.69594878000001},"psia",{"$f":"IF(Q10=2,IF(Units_Pref=1,E10,E10*9/5+32),T_ph(U11,Y11))","v":387.79770379648903},"°F",{"$f":"E11/Unit_Preference_Energy*Unit_Preference_Mass","v":1199.747844407362},"Btu/lb",null,0.45359237000000002,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.30480000000000002,"m"]
[null,null,"Condensate Return Header",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.8947572930000006E-2,"bara"]
[null,null,"Boiler Feedwater at:",null,10,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E14),\"¬\",\"\")","v":""},null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,"Pressure",null,"Temperature",null,"Enthalpy",null,null,1.055055853,"kJ",null,null,{"$f":"IF($Q14=1,IF(Units_Pref=$AF$2,$E14,$E14/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$E14,$E14*9/5+32))","v":10},{"$f":"IF($Q14=1,IF(Units_Pref=$AG$2,$E14,$E14*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$E14,($E14-32)*5/9))","v":0.68947572930000001},10,0.68947572930000001]
[null,null,"Enthalpy of BFW:",null,{"$f":"IF(Q14=1,hL_p(U15),hL_T(W15))*Unit_Preference_Energy/Unit_Preference_Mass","v":207.82160021018498},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,null,null,null,null,null,null,"Pressure",null,"psia",null,null,{"$f":"IF(Q14=1,(E14+T36)/Unit_Preference_Pres,psat_t(W15))","v":24.695948780000002},"psia",{"$f":"IF(Q14=2,IF(Units_Pref=1,E14,E14*9/5+32),T_ph(U15,Y15))","v":239.37068248132107},"°F",{"$f":"E15/Unit_Preference_Energy*Unit_Preference_Mass","v":207.82160021018498},"Btu/lb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Function for Steam"]
[null,null,"Cost of Steam Calculated:",null,{"$f":"$E$5*(E11-E15)/1000/($E$6/100)","v":9.9192624419717692},{"$f":"IF(Units_Pref=1,\"per 1,000 lbs of steam\",\"per tonne of steam\")","v":"per 1,000 lbs of steam"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=1,\"psig\",\"barg\")","v":"psig"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=1,\"°F\",\"°C\")","v":"°F"}]
[]
[null,"Modified Unloaded Cost"]
[null,null,"Steam Distribution Header"]
[null,null,"Saturated Steam Generated at:",null,100,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E22),\"¬\",\"\")","v":""},null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,"Pressure",null,"Temperature",null,"Enthalpy",null,null,null,null,null,null,{"$f":"IF($Q22=1,IF(Units_Pref=$AF$2,$E22,$E22/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$E22,$E22*9/5+32))","v":100},{"$f":"IF($Q22=1,IF(Units_Pref=$AG$2,$E22,$E22*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$E22,($E22-32)*5/9))","v":6.8947572930000005},100,6.8947572930000005]
[null,null,"Total Enthalpy:",null,{"$f":"IF(Q22=1,hV_p(U23),hV_T(W23))*Unit_Preference_Energy/Unit_Preference_Mass","v":1189.9521712664214},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q22=1,(E22+T36)/Unit_Preference_Pres,psat_t(W23))","v":114.69594877999999},"psia",{"$f":"IF(Q22=2,IF(Units_Pref=1,E22,E22*9/5+32),T_ph(U23,Y23))","v":337.87149819522375},"°F",{"$f":"E23/Unit_Preference_Energy*Unit_Preference_Mass","v":1189.9521712664214},"Btu/lb"]
[]
[null,null,"Condensate Return Header",null,"Mass flow %",null,"Operating Condition",null,null,"Total Enthalpy",null,null,null,null,null,null,null,null,null,null,"Pressure",null,"Temperature",null,"Enthalpy"]
[null,null,"Low Pressure Return:",null,20," %",10,null,{"$f":"IF(E26>0,IF(ISBLANK(G26),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E26>0,IF(Q26=1,hL_p(U26),hL_T(W26))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":207.82160021018498},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q26=1,(G26+$T$36)/Unit_Preference_Pres,psat_t(W26))","v":24.695948780000002},"psia",{"$f":"IF(Q26=2,IF(Units_Pref=1,G26,G26*9/5+32),T_ph(U26,Y26))","v":239.37068248132107},"°F",{"$f":"J26/Unit_Preference_Energy*Unit_Preference_Mass","v":207.82160021018498},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q26=1,IF(Units_Pref=$AF$2,$G26,$G26/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G26,$G26*9/5+32))","v":10},{"$f":"IF($Q26=1,IF(Units_Pref=$AG$2,$G26,$G26*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G26,($G26-32)*5/9))","v":0.68947572930000001},10,0.68947572930000001]
[null,null,"Medium Pressure Return:",null,0," %",14.311598766750199,null,{"$f":"IF(E27>0,IF(ISBLANK(G27),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E27>0,IF(Q27=1,hL_p(U27),hL_T(W27))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":""},"Btu/lb",null,null,null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q27=1,(G27+$T$36)/Unit_Preference_Pres,psat_t(W27))","v":29.0075475467502},"psia",{"$f":"IF(Q27=2,IF(Units_Pref=1,G27,G27*9/5+32),\"\")","v":""},"°F",{"$f":"J27/Unit_Preference_Energy*Unit_Preference_Mass","v":{"$error":"#VALUE!"}},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q27=1,IF(Units_Pref=$AF$2,$G27,$G27/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G27,$G27*9/5+32))","v":14.311598766750199},{"$f":"IF($Q27=1,IF(Units_Pref=$AG$2,$G27,$G27*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G27,($G27-32)*5/9))","v":0.98674999971540756},14.311598766750199,0.98674999971540756]
[null,null,"High Pressure Return:",null,0," %",0,null,{"$f":"IF(E28>0,IF(ISBLANK(G28),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E28>0,IF(Q28=1,hL_p(U28),hL_T(W28))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":""},"Btu/lb",null,null,null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q28=1,(G28+$T$36)/Unit_Preference_Pres,psat_t(W28))","v":14.69594878},"psia",{"$f":"IF(Q28=2,IF(Units_Pref=1,G28,G28*9/5+32),\"\")","v":""},"°F",{"$f":"J28/Unit_Preference_Energy*Unit_Preference_Mass","v":{"$error":"#VALUE!"}},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q28=1,IF(Units_Pref=$AF$2,$G28,$G28/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G28,$G28*9/5+32))","v":0},{"$f":"IF($Q28=1,IF(Units_Pref=$AG$2,$G28,$G28*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G28,($G28-32)*5/9))","v":0},0,0]
[null,null,"Condensate Return:",null,60," %",0,null,{"$f":"IF(E29>0,IF(ISBLANK(G29),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E29>0,IF(Q29=1,hL_p(U29),hL_T(W29))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":180.13358460273312},"Btu/lb",null,null,null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q29=1,(G29+$T$36)/Unit_Preference_Pres,psat_t(W29))","v":14.69594878},"psia",{"$f":"IF(Q29=2,IF(Units_Pref=1,G29,G29*9/5+32),\"\")","v":""},"°F",{"$f":"J29/Unit_Preference_Energy*Unit_Preference_Mass","v":180.13358460273312},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q29=1,IF(Units_Pref=$AF$2,$G29,$G29/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G29,$G29*9/5+32))","v":0},{"$f":"IF($Q29=1,IF(Units_Pref=$AG$2,$G29,$G29*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G29,($G29-32)*5/9))","v":0},0,0]
[null,null,"Make-up Water:",null,20," %",60,null,{"$f":"IF(E30>0,IF(ISBLANK(G30),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E30>0,IF(Q30=1,hL_p(U30),hL_T(W30))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":28.078682502800859},"Btu/lb",null,null,null,null,"Type of Function",2,"1: pressure 2: temperature",null,null,{"$f":"IF(Q30=1,(G30+$T$36)/Unit_Preference_Pres,psat_t(W30))","v":0.25638962428727524},"psia",{"$f":"IF(Q30=2,IF(Units_Pref=1,G30,G30*9/5+32),\"\")","v":60},"°F",{"$f":"J30/Unit_Preference_Energy*Unit_Preference_Mass","v":28.078682502800859},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q30=1,IF(Units_Pref=$AF$2,$G30,$G30/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G30,$G30*9/5+32))","v":60},{"$f":"IF($Q30=1,IF(Units_Pref=$AG$2,$G30,$G30*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G30,($G30-32)*5/9))","v":15.555555555555555},60,15.555555555555555]
[null,null,null,null,{"$f":"SUM(E26:E30)","v":100}," %",null,null,null,{"$f":"SUMPRODUCT(E26:E30,J26:J30)/100","v":155.26020730423704},"Btu/lb"]
[null,null,null,null,{"$f":"IF(E31=100,\"\",\"↑ Please ensure the total add up is equal to 100%!\")","v":""}]
[null,null,"Cost of Steam Calculated:",null,{"$f":"$E$5*(E23-J31)/1000/($E$6/100)","v":10.346919639621843},{"$f":"IF(Units_Pref=1,\"per 1,000 lbs of steam\",\"per tonne of steam\")","v":"per 1,000 lbs of steam"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlet / Outlet Steam","Enthalpy","Pressure","Temperature"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Superheated",{"$f":"J39","v":1217.05453652663},{"$f":"IF(U39=0,\"\",U39)","v":314.69594877999998},{"$f":"IF(ISERR(W39),\"\",W39)","v":439.77950872756952}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Pressure",{"$f":"J38","v":1203.7664944841279},{"$f":"IF(U38=0,\"\",U38)","v":314.69594877999998},{"$f":"IF(ISERR(W38),\"\",W38)","v":421.77950872756952}]
[null,"Loaded Cost",null,null,null,null,null,null,null,null,null,"To Process Users",null,null,null,"Minimum Pressure",{"$f":"IF(Units_Pref=1,14.7,1.01)","v":14.7},null,"Atmospheric Pressure",{"$f":"14.69594878*Unit_Preference_Pres","v":14.69594878},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G40),\"\",\"Medium Pressure\")","v":"Medium Pressure"},{"$f":"J40","v":1179.2736369100298},{"$f":"IF(U40=0,\"\",U40)","v":64.695948779999995},{"$f":"IF(ISERR(W40),\"\",W40)","v":297.63485663290464}]
[null,null,"Steam Distribution Header",null,null,null,"Operating Condition",null,null,"Total Enthalpy",null,{"$f":"IF(Units_Pref=1,\"Steam Flow (klb/h)\",\"Steam Flow (ton/h)\")","v":"Steam Flow (klb/h)"},null,null,null,null,null,null,null,null,"Pressure",null,"Temperature",null,"Enthalpy",null,null,{"$f":"IF(ISBLANK(G41),\"\",\"Low Pressure\")","v":"Low Pressure"},{"$f":"J41","v":1160.30919085649},{"$f":"IF(U41=0,\"\",U41)","v":24.695948780000002},{"$f":"IF(ISERR(W41),\"\",W41)","v":239.35446792011635}]
[null,null,"High Pressure Saturated Steam:",null,null,null,300,null,{"$f":"IF(ISBLANK(G38),\"← Entry Req.\",\"\")","v":""},{"$f":"IF(ISBLANK(G38),0,IF(Q38=1,hV_p(U38),hV_T(W38))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1203.7664944841279},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},22.046226218487757,{"$f":"IF(AND(G38>0,ISBLANK(L38)),\"¬\",\"\")","v":""},null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q38=1,(G38+T36)/Unit_Preference_Pres,psat_t(W38))","v":314.69594877999998},"psia",{"$f":"IF(Q38=2,IF(Units_Pref=1,G38,G38*9/5+32),T_ph(U38,Y38))","v":421.77950872756952},"°F",{"$f":"J38/Unit_Preference_Energy*Unit_Preference_Mass","v":1203.7664944841279},"Btu/lb",null,{"$f":"IF(OR(ISBLANK(G47),E47=0),\"\",\"Condensate\")","v":"Condensate"},{"$f":"J47","v":180.13358460273312},{"$f":"IF(U47=0,\"\",U47)","v":14.69594878},{"$f":"IF(ISERR(W47),\"\",W47)","v":211.95674782110876},{"$f":"IF($Q38=1,IF(Units_Pref=$AF$2,$G38,$G38/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G38,$G38*9/5+32))","v":300},{"$f":"IF($Q38=1,IF(Units_Pref=$AG$2,$G38,$G38*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G38,($G38-32)*5/9))","v":20.684271879000001},300,20.684271879000001,null,{"$f":"IF(Units_Pref=$AF$2,$L38,$L38/Unit_Preference_Mass_SI)","v":22.046226218487757},{"$f":"IF(Units_Pref=$AG$2,$L38,$L38*Unit_Preference_Mass_SI)","v":10},22.046226218487757,10]
[null,null,"Degree of Superheat:",null,null,"leave blank if N/A >>",18,{"$f":"IF(Units_Pref=1,\" °F\",\" °C\")","v":" °F"},null,{"$f":"IF(ISBLANK(G38),0,IF(OR(ISBLANK(G39),G39<=0),J38,h_pt(U39,W39)*Unit_Preference_Energy/Unit_Preference_Mass))","v":1217.05453652663},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,null,"Temperature",{"$f":"IF(Units_Pref=1,G39,G39*9/5+32)","v":18},"°F","°F as basis",null,{"$f":"IF(Q38=1,(U38),psat_t(W38))","v":314.69594877999998},"psia",{"$f":"W38+IF(Units_Pref=1,G39,(G39*9/5))","v":439.77950872756952},"°F",{"$f":"J39/Unit_Preference_Energy*Unit_Preference_Mass","v":1217.05453652663},"Btu/lb",null,null,null,null,null,{"$f":"IF(Units_Pref=$AF$2,$G39,$G39*9/5)","v":18},{"$f":"IF($Q39=1,IF(Units_Pref=$AG$2,$G39,$G39*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G39,$G39*5/9))","v":10},18,10]
[null,null,"Medium Pressure Saturated Steam:",null,null,{"$f":"IF(I40=\"\",\"leave blank if N/A >>\",\"\")","v":"leave blank if N/A >>"},50,null,{"$f":"IF(AND(E45>0,ISBLANK(G40)),\"← Entry Req.\",\"\")","v":""},{"$f":"IF(ISBLANK(G40),0,IF(Q40=1,hV_p(U40),hV_T(W40))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1179.2736369100298},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},132.27735731092653,{"$f":"IF(AND(G40>0,ISBLANK(L40)),\"¬\",\"\")","v":""},null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q40=1,(G40+T36)/Unit_Preference_Pres,psat_t(W40))","v":64.695948779999995},"psia",{"$f":"IF(Q40=2,IF(Units_Pref=1,G40,G40*9/5+32),T_ph(U40,Y40))","v":297.63485663290464},"°F",{"$f":"J40/Unit_Preference_Energy*Unit_Preference_Mass","v":1179.2736369100298},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q40=1,IF(Units_Pref=$AF$2,$G40,$G40/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G40,$G40*9/5+32))","v":50},{"$f":"IF($Q40=1,IF(Units_Pref=$AG$2,$G40,$G40*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G40,($G40-32)*5/9))","v":3.4473786465000003},50,3.4473786465000003,null,{"$f":"IF(Units_Pref=$AF$2,$L40,$L40/Unit_Preference_Mass_SI)","v":132.27735731092653},{"$f":"IF(Units_Pref=$AG$2,$L40,$L40*Unit_Preference_Mass_SI)","v":59.999999999999993},132.27735731092653,59.999999999999993]
[null,null,"Low Pressure Saturated Steam:",null,null,{"$f":"IF(I41=\"\",\"leave blank if N/A >>\",\"\")","v":"leave blank if N/A >>"},10,null,{"$f":"IF(AND(E44>0,ISBLANK(G41)),\"← Entry Req.\",\"\")","v":""},{"$f":"IF(ISBLANK(G41),0,IF(Q41=1,hV_p(U41),hV_T(W41))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1160.30919085649},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},99.208017983194907,{"$f":"IF(AND(G41>0,ISBLANK(L41)),\"¬\",\"\")","v":""},null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q41=1,(G41+T36)/Unit_Preference_Pres,psat_t(W41))","v":24.695948780000002},"psia",{"$f":"IF(Q41=2,IF(Units_Pref=1,G41,G41*9/5+32),T_ph(U41,Y41))","v":239.35446792011635},"°F",{"$f":"J41/Unit_Preference_Energy*Unit_Preference_Mass","v":1160.30919085649},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q41=1,IF(Units_Pref=$AF$2,$G41,$G41/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G41,$G41*9/5+32))","v":10},{"$f":"IF($Q41=1,IF(Units_Pref=$AG$2,$G41,$G41*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G41,($G41-32)*5/9))","v":0.68947572930000001},10,0.68947572930000001,null,{"$f":"IF(Units_Pref=$AF$2,$L41,$L41/Unit_Preference_Mass_SI)","v":99.208017983194907},{"$f":"IF(Units_Pref=$AG$2,$L41,$L41*Unit_Preference_Mass_SI)","v":45},99.208017983194907,45]
[]
[null,null,"Condensate Return Header",null,"Mass flow %",null,"Operating Condition",null,null,"Total Enthalpy",null,null,null,null,null,null,null,null,null,null,"Pressure",null,"Temperature",null,"Enthalpy"]
[null,null,"Low Pressure Return:",null,20," %",169.69415314848848,null,{"$f":"IF(E44>0,IF(OR(ISBLANK(G44)),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E44>0,IF(Q44=1,hL_p(U44),hL_T(W44))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":348.32200420899278},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q44=1,(G44+$T$36)/Unit_Preference_Pres,psat_t(W44))","v":184.39010192848849},"psia",{"$f":"IF(Q44=2,IF(Units_Pref=1,G44,G44*9/5+32),T_ph(U44,Y44))","v":375.08657307792583},"°F",{"$f":"J44/Unit_Preference_Energy*Unit_Preference_Mass","v":348.32200420899278},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q44=1,IF(Units_Pref=$AF$2,$G44,$G44/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G44,$G44*9/5+32))","v":169.69415314848848},{"$f":"IF($Q44=1,IF(Units_Pref=$AG$2,$G44,$G44*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G44,($G44-32)*5/9))","v":11.7},169.69415314848848,11.7]
[null,null,"Medium Pressure Return:",null,0," %",20,null,{"$f":"IF(E45>0,IF(OR(ISBLANK(G45)),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E45>0,IF(Q45=1,hL_p(U45),hL_T(W45))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":""},"Btu/lb",null,null,null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q45=1,(G45+$T$36)/Unit_Preference_Pres,psat_t(W45))","v":34.695948780000002},"psia",{"$f":"IF(Q45=2,IF(Units_Pref=1,G45,G45*9/5+32),T_ph(U45,Y45))","v":{"$error":"#VALUE!"}},"°F",{"$f":"J45/Unit_Preference_Energy*Unit_Preference_Mass","v":{"$error":"#VALUE!"}},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q45=1,IF(Units_Pref=$AF$2,$G45,$G45/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G45,$G45*9/5+32))","v":20},{"$f":"IF($Q45=1,IF(Units_Pref=$AG$2,$G45,$G45*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G45,($G45-32)*5/9))","v":1.3789514586},20,1.3789514586]
[null,null,"High Pressure Return:",null,0," %",200,null,{"$f":"IF(E46>0,IF(OR(ISBLANK(G46)),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E46>0,IF(Q46=1,hL_p(U46),hL_T(W46))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":""},"Btu/lb",null,null,null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q46=1,(G46+$T$36)/Unit_Preference_Pres,psat_t(W46))","v":214.69594878000001},"psia",{"$f":"IF(Q46=2,IF(Units_Pref=1,G46,G46*9/5+32),T_ph(U46,Y46))","v":{"$error":"#VALUE!"}},"°F",{"$f":"J46/Unit_Preference_Energy*Unit_Preference_Mass","v":{"$error":"#VALUE!"}},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q46=1,IF(Units_Pref=$AF$2,$G46,$G46/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G46,$G46*9/5+32))","v":200},{"$f":"IF($Q46=1,IF(Units_Pref=$AG$2,$G46,$G46*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G46,($G46-32)*5/9))","v":13.789514586000001},200,13.789514586000001]
[null,null,"Condensate Return:",null,60," %",0,null,{"$f":"IF(E47>0,IF(OR(ISBLANK(G47)),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E47>0,IF(Q47=1,hL_p(U47),hL_T(W47))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":180.13358460273312},"Btu/lb",null,null,null,null,"Type of Function",1,"1: pressure 2: temperature",null,null,{"$f":"IF(Q47=1,(G47+$T$36)/Unit_Preference_Pres,psat_t(W47))","v":14.69594878},"psia",{"$f":"IF(Q47=2,IF(Units_Pref=1,G47,G47*9/5+32),T_ph(U47,Y47))","v":211.95674782110876},"°F",{"$f":"J47/Unit_Preference_Energy*Unit_Preference_Mass","v":180.13358460273312},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q47=1,IF(Units_Pref=$AF$2,$G47,$G47/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G47,$G47*9/5+32))","v":0},{"$f":"IF($Q47=1,IF(Units_Pref=$AG$2,$G47,$G47*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G47,($G47-32)*5/9))","v":0},0,0]
[null,null,"Make-up Water:",{"$f":"IF(E48<=0,\"Entry Req. >>\",\"\")","v":""},20," %",75.2,null,{"$f":"IF(E48>0,IF(OR(ISBLANK(G48)),\"¬\",\"\"),\"\")","v":""},{"$f":"IF(E48>0,IF(Q48=1,hL_p(U48),hL_T(W48))*Unit_Preference_Energy/Unit_Preference_Mass,\"\")","v":43.274201250867833},"Btu/lb",null,null,null,null,"Type of Function",2,"1: pressure 2: temperature",null,null,{"$f":"IF(Q48=1,(G48+$T$36)/Unit_Preference_Pres,psat_t(W48))","v":0.43302946577745938},"psia",{"$f":"IF(Q48=2,IF(Units_Pref=1,G48,G48*9/5+32),T_ph(U48,Y48))","v":75.2},"°F",{"$f":"J48/Unit_Preference_Energy*Unit_Preference_Mass","v":43.274201250867833},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q48=1,IF(Units_Pref=$AF$2,$G48,$G48/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$G48,$G48*9/5+32))","v":75.2},{"$f":"IF($Q48=1,IF(Units_Pref=$AG$2,$G48,$G48*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$G48,($G48-32)*5/9))","v":24},75.2,24]
[null,null,{"$f":"IF(E48<E77,\"  ↑ Error. Makeup must be ≥ blowdown. (min: \" & ROUND(E77,1) & \"%)\",\"\")","v":""},null,{"$f":"SUM(E44:E48)","v":100}," %",null,null,null,{"$f":"SUMPRODUCT(E44:E48,J44:J48)/100","v":186.39939185361203},"Btu/lb"]
[null,null,null,null,{"$f":"IF(E49=100,\"\",\"↑ Please ensure the total add up is equal to 100%!\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K47","v":"Btu/lb"},{"$f":"V50&U50","v":"btu/lb°F"},"psia","°F","btu/lb"]
[null,null,"Turbine Data",null,"Steam",null,{"$f":"IF(Units_Pref=1,\"psia\",\"bara\")","v":"psia"},{"$f":"IF(Units_Pref=1,\"°F\",\"°C\")","v":"°F"},{"$f":"IF(Units_Pref=1,\"Flow, klb/h\",\"Flow, ton/h\")","v":"Flow, klb/h"},"Total Enthalpy",null,"Efficiency, %",null,null,null,null,"Inlet","Enthalpy","Entropy","Pressure","Temp","Enthalpy",{"$f":"IF(Units_Pref=1,\"Btu\",\"kJ\") & \"/s\"","v":"Btu/s"},"Mode",null,"Mode",null,"For dehighlighting cells"]
[null,null,"HP - MP Steam Turbine(s):","Inlet:",{"$f":"IF($G$39>0,\"Superheated Steam\",\"High Pressure\")","v":"Superheated Steam"},null,{"$f":"VLOOKUP(CHOOSE($Q52,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE)*Unit_Preference_Pres","v":314.69594877999998},{"$f":"IF(Units_Pref=1,VLOOKUP(CHOOSE($Q52,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),(VLOOKUP(CHOOSE($Q52,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE)-32)*5/9)","v":439.77950872756952},33.069339327731598,{"$f":"R52","v":1217.05453652663},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},80,{"$f":"IF(Q52=1,\"Superheated\",\"Saturated\")","v":"Superheated"},null,null,"Steam Type Inlet",{"$f":"IF($G$39>0,1,2)","v":1},{"$f":"IF(Q52<>5,VLOOKUP(CHOOSE(Q52,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AC$38,2,FALSE),IF(ISBLANK(H52),hV_p(T52),h_pt(T52,U52))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1217.05453652663},{"$f":"s_ph(T52,V52)","v":1.5218277537688729},{"$f":"IF(Q52<>5,VLOOKUP(CHOOSE(Q52,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE),G52/Unit_Preference_Pres)","v":314.69594877999998},{"$f":"IF(Q52<>5,VLOOKUP(CHOOSE(Q52,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),IF(ISBLANK(H52),T_ph(T52,V52),IF(Units_Pref=1,H52,H52*9/5+32)))","v":439.77950872756952},{"$f":"R52/Unit_Preference_Energy*Unit_Preference_Mass","v":1217.05453652663},null,1,"1:",{"$f":"IF(I52=0,\"No flow\",\"In Operation\")","v":"In Operation"},null,{"$f":"IF(OR(X52=2,ISERR(B52:M54)),2,1)","v":1},null,null,null,{"$f":"IF(Units_Pref=$AF$2,$I52,$I52/Unit_Preference_Mass_SI)","v":33.069339327731598},{"$f":"IF(Units_Pref=$AG$2,$I52,$I52*Unit_Preference_Mass_SI)","v":14.999999999999982},33.069339327731598,14.999999999999982]
[null,null,null,"Outlet:","Medium Pressure",null,{"$f":"VLOOKUP(CHOOSE($Q53,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE)*Unit_Preference_Pres","v":64.695948779999995},{"$f":"IF(Units_Pref=1,VLOOKUP(CHOOSE($Q53,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),(VLOOKUP(CHOOSE($Q53,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE)-32)*5/9)","v":297.63485663290464},null,{"$f":"IF(V53=\"\",\"\",V53*Unit_Preference_Energy/Unit_Preference_Mass)","v":1091.1270797914297},"Btu/lb",null,{"$f":"IF((U53-Tsat_p(T53))>0,\"Superheated\",IF((U53-Tsat_p(T53))<0,\"Subcooled\",\"Saturated\"))","v":"Subcooled"},null,null,"Steam Type Outlet",3,{"$f":"IF(Q53<>5,VLOOKUP(CHOOSE(Q53,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AC$38,2,FALSE),(IF(ISBLANK(H53),hV_p(T53),h_ps(T53,S53)))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1179.2736369100298},{"$f":"S52","v":1.5218277537688729},{"$f":"IF(Q53<>5,VLOOKUP(CHOOSE(Q53,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE),G53/Unit_Preference_Pres)","v":64.695948779999995},{"$f":"IF(Q53<>5,VLOOKUP(CHOOSE(Q53,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),IF(ISBLANK(H53),T_ph(T53,V53),IF(Units_Pref=1,H53,H53*9/5+32)))","v":297.63485663290464},{"$f":"IF(ISERR(h_ps(T53,S53)),\"\",h_ps(T53,S53))","v":1091.1270797914297},{"$f":"X53*I52*1000/3600","v":925.40839943435151},{"$f":"IF(ISERR(E54),0,IF(X52=1,1,0)*IF(E54=\"\",0,E54))","v":100.74196538816031},"2:",{"$f":"IF(I52=0,\"No flow\",\"Off Operation\")","v":"Off Operation"}]
[null,null,null,"Shaft Work:",{"$f":"IF(I52=0,0,IF(OR(V53>V52,J53>J52,H53=\"\"),\"\",(V52-V53)*Unit_Preference_Energy/Unit_Preference_Mass*L52/100))","v":100.74196538816031},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,{"$f":"IF(ISBLANK(G40),\"\",IF(OR(ISERR(J52),ISERR(J53)),\"Invalid Entry\",IF(J53<J52,\"\",\"↑ Invalid. Outlet Enthalpy > Inlet Enthalpy\")))","v":""}]
[null,null,"HP - LP Steam Turbine(s):","Inlet:",{"$f":"IF($G$39>0,\"Superheated Steam\",\"High Pressure\")","v":"Superheated Steam"},null,{"$f":"VLOOKUP(CHOOSE($Q55,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE)*Unit_Preference_Pres","v":314.69594877999998},{"$f":"IF(Units_Pref=1,VLOOKUP(CHOOSE($Q55,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),(VLOOKUP(CHOOSE($Q55,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE)-32)*5/9)","v":439.77950872756952},44.092452436975513,{"$f":"R55","v":1217.05453652663},"Btu/lb",80,{"$f":"IF(Q55=1,\"Superheated\",\"Saturated\")","v":"Superheated"},null,null,"Steam Type Inlet",{"$f":"IF($G$39>0,1,2)","v":1},{"$f":"IF(Q55<>5,VLOOKUP(CHOOSE(Q55,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AC$38,2,FALSE),IF(ISBLANK(H55),hV_p(T55),h_pt(T55,U55))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1217.05453652663},{"$f":"s_ph(T55,V55)","v":1.5218277537688729},{"$f":"IF(Q55<>5,VLOOKUP(CHOOSE(Q55,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE),G55/Unit_Preference_Pres)","v":314.69594877999998},{"$f":"IF(Q55<>5,VLOOKUP(CHOOSE(Q55,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),IF(ISBLANK(H55),T_ph(T55,V55),IF(Units_Pref=1,H55,H55*9/5+32)))","v":439.77950872756952},{"$f":"R55/Unit_Preference_Energy*Unit_Preference_Mass","v":1217.05453652663},null,1,"1:",{"$f":"IF(I55=0,\"No flow\",\"In Operation\")","v":"In Operation"},null,{"$f":"IF(OR(X55=2,ISERR(B55:M57)),2,1)","v":1},null,null,null,{"$f":"IF(Units_Pref=$AF$2,$I55,$I55/Unit_Preference_Mass_SI)","v":44.092452436975513},{"$f":"IF(Units_Pref=$AG$2,$I55,$I55*Unit_Preference_Mass_SI)","v":20},44.092452436975513,20]
[null,null,null,"Outlet:","Low Pressure",null,{"$f":"VLOOKUP(CHOOSE($Q56,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE)*Unit_Preference_Pres","v":24.695948780000002},{"$f":"IF(Units_Pref=1,VLOOKUP(CHOOSE($Q56,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),(VLOOKUP(CHOOSE($Q56,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE)-32)*5/9)","v":239.35446792011635},null,{"$f":"IF(V56=\"\",\"\",V56*Unit_Preference_Energy/Unit_Preference_Mass)","v":1025.2397177975688},"Btu/lb",null,{"$f":"IF(U56-(T_ph(T56,V56))>0,\"Superheated\",IF(U56-(T_ph(T56,V56))<0,\"Subcooled\",\"Saturated\"))","v":"Subcooled"},null,null,"Steam Type Outlet",4,{"$f":"IF(Q56<>5,VLOOKUP(CHOOSE(Q56,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AC$38,2,FALSE),(IF(ISBLANK(H56),hV_p(T56),h_ps(T56,S56)))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1160.30919085649},{"$f":"S55","v":1.5218277537688729},{"$f":"IF(Q56<>5,VLOOKUP(CHOOSE(Q56,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE),G56/Unit_Preference_Pres)","v":24.695948780000002},{"$f":"IF(Q56<>5,VLOOKUP(CHOOSE(Q56,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),IF(ISBLANK(H56),T_ph(T56,V56),IF(Units_Pref=1,H56,H56*9/5+32)))","v":239.35446792011635},{"$f":"IF(ISERR(h_ps(T56,S56)),\"\",h_ps(T56,S56))","v":1025.2397177975688},{"$f":"X56*I55*1000/3600","v":1879.4635047818251},{"$f":"IF(ISERR(E57),0,IF(X55=1,1,0)*IF(E57=\"\",0,E57))","v":153.45185498324901},"2:",{"$f":"IF(I55=0,\"No flow\",\"Off Operation\")","v":"Off Operation"}]
[null,null,null,"Shaft Work:",{"$f":"IF(I55=0,0,IF(OR(V56>V55,J56>J55,H56=\"\"),\"\",(V55-V56)*Unit_Preference_Energy/Unit_Preference_Mass*L55/100))","v":153.45185498324901},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,{"$f":"IF(ISBLANK(G41),\"\",IF(OR(ISERR(J55),ISERR(J56)),\"Invalid Entry\",IF(J56<J55,\"\",\"↑ Invalid. Outlet Enthalpy > Inlet Enthalpy\")))","v":""}]
[null,null,"MP - LP Steam Turbine(s):","Inlet:","Medium Pressure",null,{"$f":"VLOOKUP(CHOOSE($Q58,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE)*Unit_Preference_Pres","v":64.695948779999995},{"$f":"IF(Units_Pref=1,VLOOKUP(CHOOSE($Q58,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),(VLOOKUP(CHOOSE($Q58,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE)-32)*5/9)","v":297.63485663290464},22.046226218487757,{"$f":"R58","v":1179.2736369100298},"Btu/lb",80,{"$f":"IF(Q58=1,\"Superheated\",\"Saturated\")","v":"Saturated"},null,null,"Steam Type Inlet",3,{"$f":"IF(Q58<>5,VLOOKUP(CHOOSE(Q58,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AC$38,2,FALSE),IF(ISBLANK(H58),hV_p(T58),h_pt(T58,U58))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1179.2736369100298},{"$f":"s_ph(T58,V58)","v":1.6382078401836966},{"$f":"IF(Q58<>5,VLOOKUP(CHOOSE(Q58,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE),G58/Unit_Preference_Pres)","v":64.695948779999995},{"$f":"IF(Q58<>5,VLOOKUP(CHOOSE(Q58,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),IF(ISBLANK(H58),T_ph(T58,V58),IF(Units_Pref=1,H58,H58*9/5+32)))","v":297.63485663290464},{"$f":"R58/Unit_Preference_Energy*Unit_Preference_Mass","v":1179.2736369100298},null,2,"1:",{"$f":"IF(I58=0,\"No flow\",\"In Operation\")","v":"In Operation"},null,{"$f":"IF(OR(X58=2,ISERR(B58:M60)),2,1)","v":2},null,null,null,{"$f":"IF(Units_Pref=$AF$2,$I58,$I58/Unit_Preference_Mass_SI)","v":22.046226218487757},{"$f":"IF(Units_Pref=$AG$2,$I58,$I58*Unit_Preference_Mass_SI)","v":10},22.046226218487757,10]
[null,null,null,"Outlet:","Low Pressure",null,{"$f":"VLOOKUP(CHOOSE($Q59,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE)*Unit_Preference_Pres","v":24.695948780000002},{"$f":"IF(Units_Pref=1,VLOOKUP(CHOOSE($Q59,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),(VLOOKUP(CHOOSE($Q59,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE)-32)*5/9)","v":239.35446792011635},null,{"$f":"IF(V59=\"\",\"\",V59*Unit_Preference_Energy/Unit_Preference_Mass)","v":1106.5928236730513},"Btu/lb",null,{"$f":"IF(U59-(T_ph(T59,V59))>0,\"Superheated\",IF(U59-(T_ph(T59,V59))<0,\"Subcooled\",\"Saturated\"))","v":"Subcooled"},null,null,"Steam Type Outlet",4,{"$f":"IF(Q59<>5,VLOOKUP(CHOOSE(Q59,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AC$38,2,FALSE),(IF(ISBLANK(H59),hV_p(T59),h_ps(T59,S59)))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1160.30919085649},{"$f":"S58","v":1.6382078401836966},{"$f":"IF(Q59<>5,VLOOKUP(CHOOSE(Q59,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE),G59/Unit_Preference_Pres)","v":24.695948780000002},{"$f":"IF(Q59<>5,VLOOKUP(CHOOSE(Q59,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),IF(ISBLANK(H59),T_ph(T59,V59),IF(Units_Pref=1,H59,H59*9/5+32)))","v":239.35446792011635},{"$f":"IF(ISERR(h_ps(T59,S59)),\"\",h_ps(T59,S59))","v":1106.5928236730513},{"$f":"X59*I58*1000/3600","v":0},{"$f":"IF(ISERR(E60),0,IF(X58=1,1,0)*IF(E60=\"\",0,E60))","v":0},"2:",{"$f":"IF(I58=0,\"No flow\",\"Off Operation\")","v":"Off Operation"}]
[null,null,null,"Shaft Work:",{"$f":"IF(I58=0,0,IF(OR(V59>V58,J59>J58,H59=\"\"),\"\",(V58-V59)*Unit_Preference_Energy/Unit_Preference_Mass*L58/100))","v":58.144650589582852},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,{"$f":"IF(OR(ISBLANK(G40),ISBLANK(G41)),\"\",IF(OR(ISERR(J58),ISERR(J59)),\"Invalid Entry\",IF(J59<J58,\"\",\"↑ Invalid. Outlet Enthalpy > Inlet Enthalpy\")))","v":""}]
[null,null,"HP - Cond Steam Turbine(s):","Inlet:",{"$f":"IF($G$39>0,\"Superheated Steam\",\"High Pressure\")","v":"Superheated Steam"},null,{"$f":"VLOOKUP(CHOOSE($Q61,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE)*Unit_Preference_Pres","v":314.69594877999998},{"$f":"IF(Units_Pref=1,VLOOKUP(CHOOSE($Q61,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),(VLOOKUP(CHOOSE($Q61,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE)-32)*5/9)","v":439.77950872756952},22.046226218487799,{"$f":"R61","v":1217.05453652663},"Btu/lb",80,{"$f":"IF(Q61=1,\"Superheated\",\"Saturated\")","v":"Superheated"},null,null,"Steam Type Inlet",{"$f":"IF($G$39>0,1,2)","v":1},{"$f":"IF(Q61<>5,VLOOKUP(CHOOSE(Q61,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AC$38,2,FALSE),IF(ISBLANK(H61),hV_p(T61),h_pt(T61,U61))*Unit_Preference_Energy/Unit_Preference_Mass)","v":1217.05453652663},{"$f":"s_ph(T61,V61)","v":1.5218277537688729},{"$f":"IF(Q61<>5,VLOOKUP(CHOOSE(Q61,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE),G61/Unit_Preference_Pres)","v":314.69594877999998},{"$f":"IF(Q61<>5,VLOOKUP(CHOOSE(Q61,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),IF(ISBLANK(H61),T_ph(T61,V61),IF(Units_Pref=1,H61,H61*9/5+32)))","v":439.77950872756952},{"$f":"R61/Unit_Preference_Energy*Unit_Preference_Mass","v":1217.05453652663},null,2,"1:",{"$f":"IF(I61=0,\"No flow\",\"In Operation\")","v":"In Operation"},null,{"$f":"IF(OR(X61=2,ISERR(B61:M63)),2,1)","v":2},null,null,null,{"$f":"IF(Units_Pref=$AF$2,$I61,$I61/Unit_Preference_Mass_SI)","v":22.046226218487799},{"$f":"IF(Units_Pref=$AG$2,$I61,$I61*Unit_Preference_Mass_SI)","v":10.00000000000002},22.046226218487799,10.00000000000002]
[null,null,null,"Outlet:","Condensate",null,{"$f":"VLOOKUP(CHOOSE($Q62,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE)*Unit_Preference_Pres","v":14.69594878},{"$f":"IF(Units_Pref=1,VLOOKUP(CHOOSE($Q62,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),(VLOOKUP(CHOOSE($Q62,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE)-32)*5/9)","v":211.95674782110876},null,{"$f":"IF(V62=\"\",\"\",V62*Unit_Preference_Energy/Unit_Preference_Mass)","v":992.61577343562419},"Btu/lb",null,{"$f":"IF(U62-(T_ph(T62,V62))>0,\"Superheated\",IF(U62-(T_ph(T62,V62))<0,\"Subcooled\",\"Saturated\"))","v":"Superheated"},null,null,"Steam Type Outlet",5,{"$f":"IF(Q62<>5,VLOOKUP(CHOOSE(Q62,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AC$38,2,FALSE),(IF(ISBLANK(H62),hV_p(T62),h_ps(T62,S62)))*Unit_Preference_Energy/Unit_Preference_Mass)","v":992.61577343562419},{"$f":"S61","v":1.5218277537688729},{"$f":"IF(Q62<>5,VLOOKUP(CHOOSE(Q62,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,3,FALSE),G62/Unit_Preference_Pres)","v":14.69594878},{"$f":"IF(Q62<>5,VLOOKUP(CHOOSE(Q62,$AB$34,$AB$35,$AB$36,$AB$37,$AB$38),$AB$34:$AE$38,4,FALSE),IF(ISBLANK(H62),T_ph(T62,V62),IF(Units_Pref=1,H62,H62*9/5+32)))","v":211.95674782110876},{"$f":"IF(ISERR(h_ps(T62,S62)),\"\",h_ps(T62,S62))","v":992.61577343562419},{"$f":"X62*I61*1000/3600","v":0},{"$f":"IF(ISERR(E63),0,IF(X61=1,1,0)*IF(E63=\"\",0,E63))","v":0},"2:",{"$f":"IF(I61=0,\"No flow\",\"Off Operation\")","v":"Off Operation"}]
[null,null,null,"Shaft Work:",{"$f":"IF(I61=0,0,IF(OR(V62>V61,J62>J61,H62=\"\"),\"\",(V61-V62)*Unit_Preference_Energy/Unit_Preference_Mass*L61/100))","v":179.55101047280471},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,null,null,{"$f":"IF(OR(ISERR(J61),ISERR(J62)),\"Invalid Entry\",IF(J62<J61,\"\",\"↑ Invalid. Outlet Enthalpy > Inlet Enthalpy\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W53+W56+W59+W62","v":2804.8719042161765}]
[null,null,"Total Power Generated:",null,{"$f":"X53+X56+X59+X62","v":254.19382037140932},{"$f":"IF(Units_Pref=1,\"Btu/lb\",\"kJ/kg\")","v":"Btu/lb"},null,"* If multiple turbines are installed, their data should be combined to model as a single turbine for each pass."]
[]
[null,null,"General Site Data"]
[null,null,"Operating Hours Per Year:",null,8000,"hrs/year",null,null,null,null,null,null,{"$f":"IF(ISBLANK(E68),\"¬\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E68","v":8000},{"$f":"AF68","v":8000},8000,8000]
[null,null,"Total Steam Generated:",null,264.55471462185307,{"$f":"IF(Units_Pref=1,\"klb/h\",\"ton/h\")","v":"klb/h"},{"$f":"\"Steam generated from boiler to distribution headers. Minimum: \" & ROUNDUP(P107,0) & \" \" & F69","v":"Steam generated from boiler to distribution headers. Minimum: 254 klb/h"},null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=$AF$2,$E69,$E69/Unit_Preference_Mass_SI)","v":264.55471462185307},{"$f":"IF(Units_Pref=$AG$2,$E69,$E69*Unit_Preference_Mass_SI)","v":119.99999999999999},264.55471462185307,119.99999999999999]
[null,null,"Cost of Electrical Power:",null,0.06,"US$/kWh","Typical value: US$0.06 per kWh (year 2003)",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E70","v":0.06},{"$f":"AF70","v":0.06},0.06,0.06]
[null,null,"Electrical Usage:",null,110,"kW","Feedwater Pumping Power + Combustion Air Fan (Blower) Power",null,null,null,null,null,"",null,null,null,null,null,null,null,"Pressure",null,"Temperature",null,"Enthalpy",null,null,null,null,null,null,{"$f":"E71","v":110},{"$f":"AF71","v":110},110,110]
[null,null,"BFW Operating Condition:",null,89.6,{"$f":"IF(Units_Pref=1,\"°F\",\"°C\")","v":"°F"},"Temperature of the Boiler Feedwater",null,null,null,null,null,"",null,null,"Type of Function",2,"1: pressure 2: temperature",null,null,{"$f":"IF(Q72=1,E72/Unit_Preference_Pres,psat_t(W72))","v":0.69027043579907765},"psia",{"$f":"IF(Q72=2,IF(Units_Pref=1,E72,E72*9/5+32),T_ph(U72,Y72))","v":89.6},"°F",{"$f":"IF(Q72=1,hL_p(U72),hL_T(W72))","v":57.6550519341531},"Btu/lb",null,null,null,null,null,{"$f":"IF($Q72=1,IF(Units_Pref=$AF$2,$E72,$E72/Unit_Preference_Pres_SI),IF(Units_Pref=$AF$2,$E72,$E72*9/5+32))","v":89.6},{"$f":"IF($Q72=1,IF(Units_Pref=$AG$2,$E72,$E72*Unit_Preference_Pres_SI),IF(Units_Pref=$AG$2,$E72,($E72-32)*5/9))","v":32},89.6,32]
[null,null,"BFW Chemical Treatment Cost:",null,6.8038855499999995E-2,{"$f":"IF(Units_Pref=1,\"US$/1,000lb\",\"US$/tonne\")","v":"US$/1,000lb"},{"$f":"IF(Units_Pref=1,\"Typical value: US$0.07 per 1,000lb of steam (year 2003)\", \"Typical value: US$0.15 per tonne of steam (year 2003)\")","v":"Typical value: US$0.07 per 1,000lb of steam (year 2003)"},null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=$AF$2,$E73,$E73*Unit_Preference_Mass_SI)","v":6.8038855499999995E-2},{"$f":"IF(Units_Pref=$AG$2,$E73,$E73/Unit_Preference_Mass_SI)","v":0.15},6.8038855499999995E-2,0.15]
[null,null,"Makeup Water Cost:",null,0.03,{"$f":"IF(Units_Pref=1,\"US$/1,000lb\",\"US$/tonne\")","v":"US$/1,000lb"},{"$f":"IF(Units_Pref=1,\"Typical value: US$0.03 per 1,000lb of steam (year 2003)\", \"Typical value: US$0.067 per tonne of steam (year 2003)\")","v":"Typical value: US$0.03 per 1,000lb of steam (year 2003)"},null,null,null,null,null,"",null,null,"Energy in BFW CpdT",{"$f":"4.186/Unit_Preference_Energy_SI*Unit_Preference_Mass_SI*5/9*(W72-W48)","v":14.397248490085378},"Btu/lb",{"$f":"Q74*Unit_Preference_Energy/Unit_Preference_Mass*1000/10^6","v":1.4397248490085378E-2},{"$f":"IF(Units_Pref=1,\"MMBtu\",\"GJ\") & \" per 1,000 mass\"","v":"MMBtu per 1,000 mass"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=$AF$2,$E74,$E74*Unit_Preference_Mass_SI)","v":0.03},{"$f":"IF(Units_Pref=$AG$2,$E74,$E74/Unit_Preference_Mass_SI)","v":6.6138678655463273E-2},0.03,6.6138678655463273E-2]
[null,null,"Makeup Water Percentage:",null,{"$f":"IF(E48<E77,E77,E48)","v":20},"%","Per cent of Feedwater Flow",null,null,null,null,null,null,null,null,null,2]
[null,null,"Sewer Cost for Boiler Blowdown:",null,0.54201276061747206,{"$f":"IF(Units_Pref=1,\"US$/100ft³\",\"US$/100m³\")","v":"US$/100ft³"},{"$f":"IF(Units_Pref=1,\"Typical value: US$0.542 per 100 ft³ (year 2003)\", \"Typical value: US$19.141 per 100 m³ (year 2003)\")","v":"Typical value: US$0.542 per 100 ft³ (year 2003)"},null,null,null,null,null,"",null,null,null,{"$f":"E76/(62.42796058*Unit_Preference_Mass/Unit_Preference_Length^3)*100","v":0.86822115536338107},{"$f":"IF(Units_Pref=1,\"US$/lb\",\"US$/kg\")","v":"US$/lb"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=$AF$2,$E76,$E76*Unit_Preference_Length_SI^3)","v":0.54201276061747206},{"$f":"IF(Units_Pref=$AG$2,$E76,$E76/Unit_Preference_Length_SI^3)","v":19.140999999999998},0.54201276061747206,19.140999999999998]
[null,null,"Boiler Blowdown Rate:",null,5,"%","Per cent of Feedwater Flow. Usually 1 to 3%",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E77","v":5},{"$f":"AF77","v":5},5,5]
[null,null,"Waste Disposal Cost:",null,0.45359237000000002,{"$f":"IF(Units_Pref=1,\"US$/1,000lb\",\"US$/tonne\")","v":"US$/1,000lb"},{"$f":"IF(Units_Pref=1,\"Typical value: US$0.45 per 1,000lb Ash (year 2003)\", \"Typical value: US$1 per tonne Ash (year 2003)\")","v":"Typical value: US$0.45 per 1,000lb Ash (year 2003)"},null,null,null,null,null,"",null,null,null,null,{"$f":"F69","v":"klb/h"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=$AF$2,$E78,$E78*Unit_Preference_Mass_SI)","v":0.45359237000000002},{"$f":"IF(Units_Pref=$AG$2,$E78,$E78/Unit_Preference_Mass_SI)","v":1},0.45359237000000002,1]
[null,null,"Total Ash Produced:",null,0.05,{"$f":"IF(Units_Pref=1,\"lb/10,000Btu\",\"kg/10,000kJ\")","v":"lb/10,000Btu"},{"$f":"IF(Units_Pref=1,\"Typical value: 0.05 lb per 10,000Btu\", \"Typical value: 0.02 kg per 10,000kJ\")","v":"Typical value: 0.05 lb per 10,000Btu"},null,null,null,null,null,"",null,null,"Blowdown Mass Flow",{"$f":"E77/100*E104","v":13.227735731092654},{"$f":"F69","v":"klb/h"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=$AF$2,$E79,$E79*Unit_Preference_Energy_SI/Unit_Preference_Mass_SI)","v":0.05},{"$f":"IF(Units_Pref=$AG$2,$E79,$E79/Unit_Preference_Energy_SI*Unit_Preference_Mass_SI)","v":2.1496130688732362E-2},0.05,2.1496130688732362E-2]
[null,null,"Env. Emission Control Cost:",null,12,"US$/tonne CO2","Typical value: US$12 per tonne CO2 (year 2007)",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E80","v":12},{"$f":"AF80","v":12},12,12]
[null,null,"Emission Rate:",null,80,{"$f":"IF(Units_Pref=1,\"kgCO2 / MMBtu\",\"kgCO2 / GJ\")","v":"kgCO2 / MMBtu"},{"$f":"IF(Units_Pref=1,\"Typical range of value: 50 to 110 kgCO2 / MMBtu\", \"Typical range of value: 47 to 104 kgCO2 / GJ\")","v":"Typical range of value: 50 to 110 kgCO2 / MMBtu"},null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Units_Pref=$AF$2,$E81,$E81*Unit_Preference_Energy_SI)","v":80},{"$f":"IF(Units_Pref=$AG$2,$E81,$E81/Unit_Preference_Energy_SI)","v":75.825369597755312},80,75.825369597755312]
[null,null,"Labor Costs:",null,0.75,"mil US$/year","Total Annual Wages",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E82","v":0.75},{"$f":"AF82","v":0.75},0.75,0.75]
[null,null,"Maintenance Costs:",null,1,"mil US$/year","Total Maintenance Cost per Annum.",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E83","v":1},{"$f":"AF83","v":1},1,1]
[null,null,"Miscellaneous Costs:",null,0.5,"mil US$/year","Other Additional Relevant Costs Spended per Annum",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E84","v":0.5},{"$f":"AF84","v":0.5},0.5,0.5]
[]
[null,null,"Cost of Steam (Individual Breakdown)"]
[null,null,"Fuel Cost:",null,{"$f":"E5*(MAX(J38:J39)-J49)/1000/(E6/100)","v":10.306551446730179},{"$f":"IF(Units_Pref=1,\"US$/1,000lb\",\"US$/tonne\")","v":"US$/1,000lb"}]
[null,null,"Boiler Feedwater Cost:",null,{"$f":"(S74*E5+E74+E73)*E75/100","v":4.2643368684136609E-2},"US$/1,000lb","Cost of Makeup Water + Cost of Chemical Treatment + Cost of Energy of BFW"]
[null,null,"Electrical Cost:",null,{"$f":"E71*3600/E104/3600*E70","v":2.4947580350000002E-2},"US$/1,000lb","Cost of Feedwater Pump Power Usage + Blower Power Usage"]
[null,null,"Blowdown Cost:",null,{"$f":"Q79*1000/(62.42796058*Unit_Preference_Mass/Unit_Preference_Length^3)/E104*E76/100","v":4.3411057768169056E-3},"US$/1,000lb"]
[null,null,"Waste Disposal Cost:",null,{"$f":"(J38-J49)/(E6/100)*(E79/10000)/1000*1000*E78","v":2.8841872202638058E-3},"US$/1,000lb"]
[null,null,"Emission Cost:",null,{"$f":"(MAX(J38:J39)-J49)/(E6/100)/10^6*1000*E81/1000*E80","v":1.2367861736076211},"US$/1,000lb"]
[null,null,"Labor Cost:",null,{"$f":"E82/$E$68/$E$104*10^6","v":0.35436903906250006},"US$/1,000lb"]
[null,null,"Maintenance Cost:",null,{"$f":"E83/$E$68/$E$104*10^6","v":0.47249205208333339},"US$/1,000lb"]
[null,null,"Miscellaneous Cost:",null,{"$f":"E84/$E$68/$E$104*10^6","v":0.2362460260416667},"US$/1,000lb"]
[null,null,"Power Credits:",null,{"$f":"-IF(Units_Pref=1,W64*Unit_Preference_Energy_SI,W64)*3600/E104*E70/3600","v":-0.67115716089697353},"US$/1,000lb"]
[]
[null,null,"Cost of Steam Calculated:",null,{"$f":"SUM(E87:E96)","v":12.010103818659545},{"$f":"IF(Units_Pref=1,\"per 1,000 lbs of steam\",\"per tonne of steam\")","v":"per 1,000 lbs of steam"}]
[]
[null,null,null,"Simplified Schematic Flowsheet for a Steam System",null,null,null,null,null,null,{"$f":"IF(MIN(B104:M125)>-(10^(-6)),\"Model Status: Ok\",\"Model Status: Failed\")","v":"Model Status: Ok"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(B104:M125)>-(10^(-6)),\"\",\"  Please recheck your entries.\")","v":""}]
[null,null,null,null,null,null,"Process Summary"]
[null,null,null,null,null,null,"Total Steam Produced:",null,{"$f":"E104","v":264.55471462185307},{"$f":"F104","v":"klb/h"},null,null,null,null,null,{"$f":"(MIN(B104:M122))","v":0}]
[null,null,null,null,{"$f":"IF(E69<P107,P107,E69)","v":264.55471462185307},{"$f":"$L$125","v":"klb/h"},"Total Steam to Users:",null,{"$f":"O107+O110+O114","v":253.5316015126092},{"$f":"F104","v":"klb/h"}]
[null,null,null,null,{"$f":"ROUND(U38*Unit_Preference_Pres,0) & \" \" & IF(Units_Pref=1,\"psig\",\"barg\")","v":"315 psig"},null,"Total Power Gen. :",null,{"$f":"IF(Units_Pref=1,W64*Unit_Preference_Energy_SI,W64)","v":2959.2965194585327},"kW"]
[null,null,null,{"$f":"C118*E77/100","v":13.923932348518584},{"$f":"ROUND(IF(Units_Pref=1,MAX(W38:W39),(MAX(W38:W39)-32)*5/9),0) & \" \" & F72","v":"440 °F"},null,"Makeup H2O Required :",null,{"$f":"G118","v":55.695729394074334},{"$f":"H118","v":"klb/h"},null,null,null,null,"Flow to User","Min HP Header Inlet Flow"]
[null,null,null,{"$f":"$L$125","v":"klb/h"},null,null,null,null,null,null,null,{"$f":"ROUND(U38*Unit_Preference_Pres,0)&\" \"&$G$51 & \",\"","v":"315 psia,"},{"$f":"IF(ISBLANK(G38),0,ROUND(L38,1))&IF(Units_Pref=1,\" klb/h\",\" ton/h\")","v":"22 klb/h"},null,{"$f":"IF(ISBLANK(G38),0,L38)","v":22.046226218487757},{"$f":"MAX((IF(O114>(F108+H112),O114,(F108+H112))+O107+J108+O110+IF(D108>(O110+MAX(H112,O114)),(D108-O110-MAX(H112,O114)),0)),(D108+F108+J108+O107))","v":253.5316015126092}]
[null,null,{"$f":"E104-D108-F108-J108-O107","v":165.34669663865819},{"$f":"IF(X53>0,I52,0)","v":33.069339327731598},null,{"$f":"IF(X56>0,I55,0)","v":44.092452436975513},null,null,null,{"$f":"IF(X62>0,I61,0)","v":0}]
[null,null,{"$f":"$L$125","v":"klb/h"},{"$f":"$L$125","v":"klb/h"},null,{"$f":"$L$125","v":"klb/h"},null,null,null,{"$f":"$L$125","v":"klb/h"},{"$f":"\" \" & ROUND(IF(Units_Pref=1,W62*Unit_Preference_Energy_SI,W62),0) & \" kW\"","v":" 0 kW"}]
[null,null,null,null,null,{"$f":"ROUND(IF(Units_Pref=1,W53*Unit_Preference_Energy_SI,W53),0) & \" kW\"","v":"976 kW"},null,{"$f":"ROUND(IF(Units_Pref=1,W56*Unit_Preference_Energy_SI,W56),0) & \" kW\"","v":"1983 kW"},null,null,null,{"$f":"ROUND(U40*Unit_Preference_Pres,0)&\" \"&$G$51 & \",\"","v":"65 psia,"},{"$f":"IF(ISBLANK(G40),0,ROUND(L40,1)) & IF(Units_Pref=1,\" klb/h\", \" ton/h\")","v":"132.3 klb/h"},null,{"$f":"IF(ISBLANK(G40),0,L40)","v":132.27735731092653}]
[]
[null,null,{"$f":"D108+C108-H112-O110","v":66.138678655463252},null,null,null,null,{"$f":"IF(X59>0,I58,0)","v":0}]
[null,null,{"$f":"$L$125","v":"klb/h"},null,null,null,null,{"$f":"$L$125","v":"klb/h"},null,{"$f":"\" \" & ROUND(IF(Units_Pref=1,W59*Unit_Preference_Energy_SI,W59),0) & \" kW\"","v":" 0 kW"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U41*Unit_Preference_Pres,0)&\" \"&$G$51 & \",\"","v":"25 psia,"},{"$f":" IF(ISBLANK(G41),0,ROUND(L41,1)) & IF(Units_Pref=1,\" klb/h\", \" ton/h\")","v":"99.2 klb/h"},null,{"$f":" IF(ISBLANK(G41),0,L41)","v":99.208017983194907}]
[null,null,null,null,null,{"$f":"IF((J108+K119)<K125,IF((C112+H112+F108+J108+K119-O114-K125)<0,0,(C112+H112+F108-O114-K125+J108+K119)),C112+H112+F108-O114)","v":11.023113109243866}]
[null,null,null,null,null,{"$f":"$L$125","v":"klb/h"}]
[null,null,{"$f":"IF(Units_Pref=1,W72,(W72-32)*5/9) & \" \" &F72","v":"89.6 °F"}]
[null,null,{"$f":"E104/(100-E77)*100","v":278.47864697037164},null,null,null,{"$f":"C118*E75/100","v":55.695729394074334},{"$f":"$L$125","v":"klb/h"},null,null,null,null,null,null,{"$f":"(C112+H112+F108-O114-K125)","v":-30.748683936311885}]
[null,null,{"$f":"$L$125","v":"klb/h"},null,null,null,null,null,null,null,{"$f":"O107+O110+O114","v":253.5316015126092},{"$f":"IF(Units_Pref=1,\" klb/h\", \" ton/h\")","v":" klb/h"}]
[null,null,null,null,null,{"$f":"IF((J108+K119)<K125,0,C118-F115-G118)","v":211.75980446705344}]
[null,null,null,null,null,{"$f":"$L$125","v":"klb/h"}]
[null,null,null,null,null,{"$f":"ROUND(U47*Unit_Preference_Pres,0)&\" \"&$G$51","v":"15 psia"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G118-D106","v":41.771797045555751},{"$f":"IF(Units_Pref=1,\"klb/h\", \"ton/h\")","v":"klb/h"}]
[]
[null,null,"Copy Rights: Not to be copied or distributed without specific permission from Inveno Engineering LLC; kelly.paffel@invenoeng.com"]

{"sheet":"Blank for Calculation","index":1,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["User Calculations Sheet"]
[]
["This is a blank sheet provided for the user to make notes, carry out calculations etc."]

{"sheet":"Functions","index":2,"n_rows":152,"n_cols":8,"rows_kept":152,"cut":false,"hidden":true,"merged":[]}
["X Steam Tables",null,null,"v2.6","http://www.x-eng.com"]
["Steam tables by Magnus Holmgren according to IAPWS IF-97 "]
["The excel scripts are stored inside this workbook. (No extra files are needed. Start from a copy of this workbook. This page can be removed)"]
["For error-reporting, feedback, other units etc. contact:",null,null,null,null,"magnus@x-eng.com"]
["The steam tables are free and provided as is. We take no responsibilities for any errors in the code or damage thereby."]
["OBS: This workbook uses macros. Set security options in Tools:Macro:Security… to enable macros."]
[]
["Temperature"]
[" Tsat_p",14.503773799999999,"psi",null,null,{"$f":"Tsat_p(B9)","v":211.2906535708841},"deg F","Saturation temperature"]
[" T_ph",1,"psi",100,"btu/lb",{"$f":"T_ph(B10,D10)","v":101.69433722352896},"deg F","Temperture as a function of pressure and enthalpy"]
[" T_ps",1,"psi",1,"btu/(lb F)",{"$f":"T_ps(B11,D11)","v":101.69433722352896},"deg F","Temperture as a function of pressure and entropy"]
[" T_hs",100,"btu/lb",0.2,"btu/(lb F)",{"$f":"T_hs(B12,D12)","v":40.712708761178419},"deg F","Temperture as a function of enthalpy and entropy"]
["Pressure"]
[" psat_T",100,"deg F",null,null,{"$f":"psat_t(B14)","v":0.95043933077881249},"psi (a)","Saturation pressure"]
[" p_hs",100,"btu/lb",{"$f":"F49","v":0.18512524760110738},"btu/(lb F)",{"$f":"p_hs(B15,D15)","v":5.9882919074278274},"psi (a)","Pressure as a function of h and s. "]
[" p_hrho",100,"btu/lb",5,"lb/ft3",{"$f":"p_hrho(B16,D16)","v":2.2737319182747444},"psi (a)","Pressure as a function of h and rho (density). Very unaccurate for solid water region since it's almost incompressible!"]
["Enthalpy"]
[" hV_p",1,"psi",null,null,{"$f":"hV_p(B18)","v":1105.4393386640004},"btu/lb","Saturated vapour enthalpy"]
[" hL_p",1,"psi",null,null,{"$f":"hL_p(B19)","v":69.728239049354812},"btu/lb","Saturated liquid enthalpy"]
[" hV_T",100,"deg F",null,null,{"$f":"hV_T(B20)","v":1104.7148547166025},"btu/lb","Saturated vapour enthalpy"]
[" hL_T",100,"deg F",null,null,{"$f":"hL_T(B21)","v":68.036985639994001},"btu/lb","Saturated liquid enthalpy"]
[" h_pT",14.503773799999999,"psi",68,"deg F",{"$f":"h_pt(B22,D22)","v":36.11857745798283},"btu/lb","Entalpy as a function of pressure and temperature."]
[" h_ps",1,"psi",1,"btu/(lb F)",{"$f":"h_ps(B23,D23)","v":556.63691364819874},"btu/lb","Entalpy as a function of pressure and entropy."]
[" h_px",1,"psi",0.5,null,{"$f":"h_px(B24,D24)","v":587.58378885667753},"btu/lb","Entalpy as a function of pressure and vapour fraction"]
[" h_Tx",100,"deg F",0.5,null,{"$f":"h_tx(B25,D25)","v":586.37592017829832},"btu/lb","Entalpy as a function of temperature and vapour fraction"]
[" h_prho",1,"psi",2,"lb/ft3",{"$f":"h_prho(B26,D26)","v":71.230953968579257},"btu/lb","Entalpy as a function of pressure and density. Observe for low temperatures (liquid) this equation has 2 solutions. (Not valid!!)"]
["Specific volume"]
[" vV_p",1,"psi",null,null,{"$f":"vV_p(B28)","v":333.50751891901803},"ft3/lb","Saturated vapour volume"]
[" vL_p",1,"psi",null,null,{"$f":"vL_p(B29)","v":1.613681120860341E-2},"ft3/lb","Saturated liquid volume"]
[" vV_T",100,"deg F",null,null,{"$f":"vV_T(B30)","v":349.8695998974697},"ft3/lb","Saturated vapour volume"]
[" vL_T",100,"deg F",null,null,{"$f":"vL_T(B31)","v":1.6131174327003114E-2},"ft3/lb","Saturated liquid volume"]
[" v_pT",1,"psi",100,"deg F",{"$f":"v_pT(B32,D32)","v":1.6131171891217523E-2},"ft3/lb","Specific volume as a function of pressure and temperature."]
[" v_ph",1,"psi",1000,"btu/lb",{"$f":"v_ph(B33,D33)","v":299.55682476050805},"ft3/lb","Specific volume as a function of pressure and enthalpy"]
[" v_ps",10,"psi",{"$f":"F49","v":0.18512524760110738},"btu/(lb F)",{"$f":"v_ps(B34,D34)","v":1.6255423844855975E-2},"ft3/lb","Specific volume as a function of pressure and entropy."]
["Density"]
[" rhoV_p",1,"psi",null,null,{"$f":"rhoV_p(B36)","v":2.9984331484976777E-3},"lb/ft3","Saturated vapour density"]
[" rhoL_p",1,"psi",null,null,{"$f":"rhoL_P(B37)","v":61.970112128897298},"lb/ft3","Saturated liquid density"]
[" rhoV_T",100,"deg F",null,null,{"$f":"rhoV_T(B38)","v":2.858207744522682E-3},"lb/ft3","Saturated vapour density"]
[" rhoL_T",100,"deg F",null,null,{"$f":"rhoL_T(B39)","v":61.991766980413153},"lb/ft3","Saturated liquid density"]
[" rho_pT",1,"psi",100,"deg F",{"$f":"rho_pT(B40,D40)","v":61.991776341087863},"lb/ft3","Density as a function of pressure and temperature."]
[" rho_ph",1,"psi",1000,"btu/lb",{"$f":"rho_ph(B41,D41)","v":3.3382647876558564E-3},"lb/ft3","Density as a function of pressure and enthalpy"]
[" rho_ps",1,"psi",1,"btu/(lb F)",{"$f":"rho_ps(B42,D42)","v":6.3776664978736569E-3},"lb/ft3","Density as a function of pressure and entropy."]
["Specific entropy "]
[" sV_p",1,"psi",null,null,{"$f":"sV_p(B44)","v":1.9776246796445243},"btu/(lb F)","Saturated vapour entropy"]
[" sL_p",1,"psi",null,null,{"$f":"sL_p(B45)","v":0.13263149847209779},"btu/(lb F)","Saturated liquid entropy"]
[" sV_T",50,"deg F",null,null,{"$f":"sV_T(B46)","v":2.1256916787390598},"btu/(lb F)","Saturated vapour entropy"]
[" sL_T",100,"deg F",null,null,{"$f":"sL_T(B47)","v":0.12961445130558455},"btu/(lb F)","Saturated liquid entropy"]
[" s_pT",1,"psi",50,"deg F",{"$f":"s_pT(B48,D48)","v":3.6085933900856779E-2},"btu/(lb F)","Specific entropy as a function of pressure and temperature (Returns saturated vapour entalpy if mixture.)"]
[" s_ph",10,"psi",100,"btu/lb",{"$f":"s_ph(B49,D49)","v":0.18512524760110738},"btu/(lb F)","Specific entropy as a function of pressure and enthalpy"]
["Specific internal energy "]
[" uV_p",1,"psi",null,null,{"$f":"uV_p(B51)","v":1043.7238674299194},"btu/lb","Saturated vapour internal energy"]
[" uL_p",1,"psi",null,null,{"$f":"uL_p(B52)","v":69.725252937044104},"btu/lb","Saturated liquid internal energy"]
[" uV_T",100,"deg F",null,null,{"$f":"uV_T(B53)","v":1043.1803048366698},"btu/lb","Saturated vapour internal energy"]
[" uL_T",100,"deg F",null,null,{"$f":"uL_T(B54)","v":68.034148512814212},"btu/lb","Saturated liquid internal energy"]
[" u_pT",1,"psi",100,"deg F",{"$f":"u_pT(B55,D55)","v":68.034131602610202},"btu/lb","Specific internal energy as a function of pressure and temperature."]
[" u_ph",1,"psi",1000,"btu/lb",{"$f":"u_ph(B56,D56)","v":944.56709503461354},"btu/lb","Specific internal energy as a function of pressure and enthalpy"]
[" u_ps",1,"psi",1,"btu/(lb F)",{"$f":"u_ps(B57,D57)","v":527.62164375518705},"btu/lb","Specific internal energy as a function of pressure and entropy."]
["Specific isobaric heat capacity "]
[" CpV_p",1,"psi",null,null,{"$f":"CpV_p(B59)","v":0.4610466176319381},"btu/(lb F)","Saturated vapour heat capacity "]
[" CpL_p",1,"psi",null,null,{"$f":"CpL_p(B60)","v":0.99809613194003055},"btu/(lb F)","Saturated liquid heat capacity "]
[" CpV_T",100,"deg F",null,null,{"$f":"CpV_T(B61)","v":0.46071413521990223},"btu/(lb F)","Saturated vapour heat capacity "]
[" CpL_T",100,"deg F",null,null,{"$f":"CpL_T(B62)","v":0.9981101482481709},"btu/(lb F)","Saturated liquid heat capacity "]
[" Cp_pT",1,"psi",100,"deg F",{"$f":"Cp_pT(B63,D63)","v":0.99810994311651391},"btu/(lb F)","Specific isobaric heat capacity as a function of pressure and temperature."]
[" Cp_ph",100,"psi",200,"btu/lb",{"$f":"Cp_ph(B64,D64)","v":1.010383515186803},"btu/(lb F)","Specific isobaric heat capacity as a function of pressure and enthalpy"]
[" Cp_ps",100,"psi",{"$f":"F49","v":0.18512524760110738},"btu/(lb F)",{"$f":"Cp_ps(B65,D65)","v":0.99831685085166899},"btu/(lb F)","Specific isobaric heat capacity as a function of pressure and entropy."]
["Specific isochoric heat capacity "]
[" CvV_p",1,"psi",null,null,{"$f":"CvV_p(B67)","v":0.3473815118397266},"btu/(lb F)","Saturated vapour isochoric heat capacity"]
[" CvL_p",1,"psi",null,null,{"$f":"CvL_p(B68)","v":0.97419487072272337},"btu/(lb F)","Saturated liquid isochoric heat capacity"]
[" CvV_T",100,"deg F",null,null,{"$f":"CvV_T(B69)","v":0.3471349756795683},"btu/(lb F)","Saturated vapour isochoric heat capacity"]
[" CvL_T",100,"deg F",null,null,{"$f":"CvL_T(B70)","v":0.97523713984845961},"btu/(lb F)","Saturated liquid isochoric heat capacity"]
[" Cv_pT",1,"psi",100,"deg F",{"$f":"Cv_pT(B71,D71)","v":0.97523690155523191},"btu/(lb F)","Specific isochoric heat capacity as a function of pressure and temperature."]
[" Cv_ph",100,"psi",200,"btu/lb",{"$f":"Cv_ph(B72,D72)","v":0.88674221718338608},"btu/(lb F)","Specific isochoric heat capacity as a function of pressure and enthalpy"]
[" Cv_ps",100,"psi",{"$f":"D65","v":0.18512524760110738},"btu/(lb F)",{"$f":"Cv_ps(B73,D73)","v":0.95412073194367009},"btu/(lb F)","Specific isochoric heat capacity as a function of pressure and entropy."]
["Speed of sound "]
[" wV_p",1,"psi",null,null,{"$f":"wV_p(B75)","v":1430.0233443387121},"ft/s","Saturated vapour speed of sound"]
[" wL_p",1,"psi",null,null,{"$f":"wL_p(B76)","v":5016.1265905500759},"ft/s","Saturated liquid speed of sound"]
[" wV_T",100,"deg F",null,null,{"$f":"wV_T(B77)","v":1427.980732399066},"ft/s","Saturated vapour speed of sound"]
[" wL_T",100,"deg F",null,null,{"$f":"wL_T(B78)","v":5010.5240656699543},"ft/s","Saturated liquid speed of sound"]
[" w_pT",1,"psi",100,"deg F",{"$f":"w_pT(B79,D79)","v":5010.5258732811444},"ft/s","Speed of sound as a function of pressure and temperature."]
[" w_ph",100,"psi",100,"btu/lb",{"$f":"w_ph(B80,D80)","v":5090.5177966055244},"ft/s","Speed of sound as a function of pressure and enthalpy"]
[" w_ps",100,"psi",{"$f":"D73","v":0.18512524760110738},"btu/(lb F)",{"$f":"w_ps(B81,D81)","v":5090.9193656722355},"ft/s","Speed of sound as a function of pressure and entropy."]
["Dynamic Viscosity"]
["Viscosity is not part of IAPWS Steam IF97. Equations from \"\"Revised Release on the IAPWS Formulation 1985 for the Viscosity of Ordinary Water Substance\"\", 2003 are used."]
["Viscosity in the mixed region (4) is interpolated according to the density. This is not true since it will be two fases."]
[" my_pT",1,"psi",100,"deg F",{"$f":"my_pT(B85,D85)","v":1.6478178107529025},"lb/ft/hr","Viscosity as a function of pressure and temperature."]
[" my_ph",100,"psi",100,"btu/lb",{"$f":"my_ph(B86,D86)","v":1.2111188734075722},"lb/ft/hr","Viscosity as a function of pressure and enthalpy"]
[" my_ps",100,"psi",{"$f":"D81","v":0.18512524760110738},"btu/(lb F)",{"$f":"my_ps(B87,D87)","v":1.2081795712174075},"lb/ft/hr","Viscosity as a function of pressure and entropy."]
["Prandtl"]
["Calcualted as Cp*my/tc"]
[" pr_pT",1,"psi",200,"deg F",{"$f":"pr_pT(B90,D90)","v":0.97012024380540329},"-"]
[" pr_ph",1,"psi",0.19,"btu/lb",{"$f":"pr_ph(B91,D91)","v":13.405629376747422},"-"]
["Thermal Conductivity"]
["Revised release on the IAPS Formulation 1985 for the Thermal Conductivity of ordinary water substance (IAPWS 1998)"]
[" tcL_p",1,"psi",null,null,{"$f":"tcL_p(B94)","v":0.36222613868369979},"btu/(h*ft*F)","Saturated vapour thermal conductivity"]
[" tcV_p",1,"psi",null,null,{"$f":"tcV_p(B95)","v":1.1197748930408077E-2},"btu/(h*ft*F)","Saturated liquid thermal conductivity"]
[" tcL_T",50,"deg F",null,null,{"$f":"tcL_T(B96)","v":0.33622668208052353},"btu/(h*ft*F)","Saturated vapour thermal conductivity"]
[" tcV_T",50,"deg F",null,null,{"$f":"tcV_T(B97)","v":9.9463765547369021E-3},"btu/(h*ft*F)","Saturated liquid thermal conductivity"]
[" tc_pT",1,"psi",50,"deg F",{"$f":"tc_pt(B98,D98)","v":0.33622852115403534},"btu/(h*ft*F)","Thermal conductivity as a function of pressure and temperature."]
[" tc_ph",1,"psi",100,"btu/(lb F)",{"$f":"tc_ph(B99,D99)","v":2.0136752000970422E-2},"btu/(h*ft*F)","Thermal conductivity as a function of pressure and enthalpy"]
[" tc_hs",100,"btu/lb",{"$f":"D73","v":0.18512524760110738},"btu/(lb F)",{"$f":"tc_hs(B100,D100)","v":0.37348196102713527},"btu/(h*ft*F)","Thermal conductivity as a function of enthalpy and entropy"]
["Surface Tension"]
["IAPWS Release on Surface Tension of Ordinary Water Substance, September 1994"]
[" st_T",100,"deg F",null,null,{"$f":"st_T(B104)","v":5.3422775305155355E-3},"lb/ft","Surface tension for two phase water/steam as a function of T"]
[" st_p",1,"psi",null,null,{"$f":"st_p(B104)","v":4.7830973201098753E-3},"lb/ft","Surface tension for two phase water/steam as a function of T"]
["Vapour fraction"]
[" x_ph",1,"psi",1000,"btu/lb",{"$f":"x_ph(B106,D106)","v":0.89819618742791218},null,"Vapour fraction as a function of pressure and enthalpy"]
[" x_ps",1,"psi",4,"btu/(lb F)",{"$f":"x_ps(B107,D107)","v":1},null,"Vapour fraction as a function of pressure and entropy."]
["Vapour Volume Fraction"]
["Observe that vapour volume fraction is very sensitive. Vapour volume is about 1000 times greater than liquid volume and therfore vapour volume fraction"]
["gets close to the accurancy of steam IF-97"]
[" vx_ph",1,"psi",418,"btu/lb",{"$f":"vx_ph(B111,D111)","v":0.99990450365888783},null,"Vapour volume fraction as a function of pressure and enthalpy"]
[" vx_ps",1,"psi",4,"btu/(lb F)",{"$f":"vx_ps(B112,D112)","v":1},null,"Vapour volume fraction as a function of pressure and entropy."]
[]
["Version history"]
["News in V2.6"]
["* Error in valid region for function tc_ptrho"]
["* Error in function h3_pt for temperatures near the saturation point."]
["News in V2.5"]
["* DLL distrubution for use in other applications"]
["* Freebasic translation"]
["* Fixed small error in Cv Region 5 p>1000bar"]
["News in V2.4a"]
["Fixed unit conversion in T_ps region4 (No effekt for SI units.)"]
["News in V2.4"]
["* TODO!!! Check Cv in region 5"]
["* ToDO!!! Tc och my not def. In region 4"]
["* OpenOffice version introduced. (Fixed calculation differences in open office and excel)"]
["* Matlab error giving varaible undefined in some backwards solutions fixed."]
["News in V2.3"]
["* Option Explicit, gives more efficient calculations."]
["* Extensive testing"]
["* my_ph not defined in region 4."]
["* Problems at region border for h4V_p to adress solver problems at the exact border."]
["* Problem at fast border check in region_ph fixed."]
["News in V2.2"]
["* Extensive testing"]
["* Fixed error in Cp_ph"]
["* Function p_hrho added. (Very good for calcualting pressure when heating a volume with water/steam mixture.)"]
["* Fixed error in T_hs return no value for vet region bellow the water saturation line."]
["* Prandtl number added"]
["News in V2.1"]
["* Calling function h_prho"]
["* Fixed problem with Cv reporting NaN in region 5."]
["* Equivivalent to the Matlab version. (Downloadable from www.x-eng.com)"]
["News in V2"]
["* Calling functions of h and s added."]
["* Thermal conductivity, Surface tension added"]
["* Calling functions h_px and h_tx added."]
["* Cp, Cv and w undefined in the mixed region. (Before interpolation with the vapor fraction was used.)"]
["* A work sheet \"\"Properties\"\" for simple lookups added."]
["* Cp, Cv and w undefined in the mixed region. (Before interpolation with the vapor fraction was used.)"]
["* A work sheet \"Properties\" for simple lookups added."]