5th
December
2007
Warning: copy() [
function.copy]: Filename cannot be empty in
/home/jlhdes/public_html/wp-content/plugins/mytube/mytube.php on line
220
Working on an excel spread sheet and forgot (nudge, nudge, wink, wink) the passwords so that you cannot get to the hidden sheets, modify the VBA, or unlock cells?
Then you need the Excel Password Remover. It’s free, it works, and it’s very stable.
~This is NOT a paid or sponsored review but just an actual I-used-it-and-I-recommend-it endorsement.
posted in engineering |
7th
September
2007
Warning: copy() [
function.copy]: Filename cannot be empty in
/home/jlhdes/public_html/wp-content/plugins/mytube/mytube.php on line
220
If you are not a mechanical engineer or someone that deals with steam based calculations daily then you can skip reading the rest of this.
What I’ve set up is an Excel Add-In that adds the steam tables as functions to be used like any other functions within your excel applications. I’ll leave it on the site, on the off chance that someone will actually find it to download.
This simple little add-In adds dozens of functions to your install of Microsoft Excel. The functions return steam properties so you can use them in your calculations without having to reference a steam table.
Installation instructions are included in the download.
The following functions will be added to your excel:
tempP - Returns the Steam Temperature (F) at given Pressure in PSIG
sensP - Returns the Sensible Heat (Btu/lb) at given Pressure in PSIG
latentP - Returns the Latent Heat (Btu/lb) at given Pressure in PSIG
condvolumeP - Returns the Condensate Volume (ft3/lb) at given Pressure in PSIG
steamvolumep - Returns the Steam Volume (ft3/lb) at given Pressure in PSIG
PressureT - Returns the Steam Pressure (PSIG) at given Temperature (F)
SensT - Returns the Sensible Heat (Btu/lb) at given Temperature (F)
LatentT - Returns the Latent Heat (Btu/lb) at given Temperature (F)
condvolumeT - Returns the Condensate Volume (ft3/lb) at given Temperature (F)
steamvolumeT - Returns the Steam Volume (ft3/lb) at given Temperature (F)
tempL - Returns the Steam Temperature (F) at given Latent Heat in BTU/LB
PressureL - Returns the Steam Pressure (PSIG) at given Latent Heat in BTU/LB
sensL - Returns the Steam Sensible Heat (Btu/LB) at given Latent Heat in BTU/LB
condvolumeL - Returns the Cond Volume (Ft3/LB) at given Latent Heat in BTU/LB
steamvolumeL - Returns the Steam Volume (Ft3/LB) at given Latent Heat in BTU/LB
PressureS - Returns the Steam Pressure (PSIG) at given Sensible Heat in BTU/LB
tempS - Returns the Steam Temperature (F) at given Sensible Heat in BTU/LB
latentS - Returns the Steam Latent Heat (Btu/LB) at given Sensible Heat in BTU/LB
condvolumeS - Returns the Cond Volume (Ft3/LB) at given Sensible Heat in BTU/LB
steamvolumeS - Returns the Cond Volume (Ft3/LB) at given Sensible Heat in BTU/LB
PressureC - Returns the Steam Pressure (PSIG) at given Cond Volume in Ft3/LB
tempC - Returns the Steam Temperature (F) at given Cond Volume in Ft3/LB
latentC - Returns the Steam Latent Heat (Btu/LB) at given Cond Volume in Ft3/LB
SensC - Returns the Steam Sensible Heat (Btu/LB) at given Cond Volume in Ft3/LB
steamvolumeC - Returns the Steam Volume (Ft3/LB) at given Cond Volume in Ft3/LB
PressureSV - Returns the Steam Pressure (PSIG) at given Steam Volume in Ft3/LB
tempSV - Returns the Steam Temperature (F) at given Steam Volume in Ft3/LB
latentSV - Returns the Steam Latent Heat (Btu/LB) at given Steam Volume in Ft3/LB
SensSV - Returns the Steam Sensible Heat (Btu/LB) at given Steam Volume in Ft3/LB
condvolumeSV - Returns the Cond Volume (Ft3/LB) at given Steam Volume in Ft3/LB
posted in engineering |
