Community Status Updates
ankur2061
A new improved version of the spreadsheet related to equivalent length of valves and fittings with new and more accurate estimation of resistance coefficients for ASME B16.9 reducers is available at: http://www.cheresources.com/invision/files/file/258-equivalent-length-calculations-for-pipes-and-valves/
Dec 12 2013 12:57 AM
ankur2061
"Goal Seek" function of excel can be used to arrive at the blowdown valve or orifice size in the spreadsheet "Gas Pipeline Blowdown Time Calculator" by setting the blowdown time to the desired value
Jun 13 2013 03:28 AM
ankur2061
"Goal Seek" function of excel can be used to arrive at the blowdown valve or orifice size in the spreadsheet "Gas Pipeline Blowdown Time Calculator" by setting the blowdown time to the desired value
Jun 13 2013 03:28 AM
ankur2061
"Goal Seek" function of excel can be used to arrive at the blowdown valve or orifice size in the spreadsheet "Gas Pipeline Blowdown Time Calculator" by setting the blowdown time to the desired value
Jun 13 2013 03:27 AM
ankur2061
A quarter-million views on Ankur's Chemical Engineering Blog in less than two years. Thank you readers for all your support and encouragement. Will always strive to provide value for the readers.
Jun 21 2012 03:22 AM
-
mhs
keep enriching the younge mind...........
Jul 03 2012 01:09 AM
ankur2061
Recently discovered that In Excel 2003, the limit for nested functions is 7 when trying to build more than 7 "IF" statements. Excel 2007 & 2010 allow you to have up to 64 nested functions. Can we upload Excel 2007 / 2010 files with file extension .xlsx and .xlsm?
May 30 2012 04:53 AM
-
Chris Haslego
Yes, both of those extensions can be uploaded.
May 30 2012 07:35 AM -
Technical Bard
I prefer to put complex code in VBA functions than in cells. It is easier to debug.
Jun 07 2012 07:48 PM -
JMW
Yes, that nested function limit has caused me no end of grief over the years (including in the spreadsheets on density and viscosity hosted in the Excel freebies on Cheresources).
The trouble is that I am loathe to upgrade MS products any more often than I have to.
Upgrading Microsoft seems to bring more problems than it solves - until they start to get a handle on the more serious bugs.
Jun 11 2012 06:02 AM
ankur2061
Merry Christmas to all members of the "Cheresources" community. God Bless, and hope the community keeps growing
Dec 25 2011 12:46 AM
-
jrtailor09
Wish U also happy marry Christmas.
Dec 25 2011 01:23 AM -
demank
merry christmas too.., :)
Dec 25 2011 05:25 AM
ashubiet → ankur2061
Dear Sir, I am a chemical engineering graduate and working in a natural gas based petrochemical plant. I need to calculate "cracked gas compressor's efficiency". The problem that I m facing is, how to update the value of Cp/Cv (=k), considering the changes in gas's composition (undergoing compression). As u must know, we deal with a mixture of H2, CH4, C2H2, C2H4, C2H6, C3, C4......n so on (say....nearly 8 major components). Also we have got 4 compression stages, so 8 terminal...
Oct 21 2011 12:42 AM
-
ashubiet
I do have all T and P values, along with mole fractions of component gases. Now how to get individual Cp and Cv values of a gas (say CH4) at given T and P. Also, after getting Cp and Cv , what value I should consider in my calculations? "k" based on compressor stage's inlet conditions or outlet conditions?
Oct 21 2011 01:06 AM
shasha → ankur2061
Dear Sir,
Thank you so much for adding me. I learned a lot from your blogs and entries.
Thank you so much for adding me. I learned a lot from your blogs and entries.
Aug 02 2011 12:41 AM
Madhan Kumar → ankur2061
Dear Ankur Ji, Many more happy returns of the day and wishing you for long healthy life.
Jun 20 2011 08:11 PM
ankur2061 → gillian001
What has your post got to do with chemical engineering? Please delete your post cum advertisement immediately
Jun 18 2011 03:16 AM
ankur2061
More than 50,000 views on my blog in a relatively short time span. Wow....thanks to Chris and the readers of "Cheresources". This is quite an encouragement
May 11 2011 11:07 PM
-
binzee
Congrats, keep up the good work
May 24 2011 08:07 AM -
SANDYJACK
Your postings are really useful. Thanks!!!
Jun 07 2011 08:40 AM -
rowanlim
Congratulations, your insight is always appreciated!:)
Jun 10 2011 07:41 PM
ankur2061
I have uploaded an updated version of the excel workbook in my blog entry- "Thermophysical Property Correlations provided by DIPPR"
Mar 04 2011 11:32 AM
-
Philip Johnson
I have downloaded and tried your spreadsheet - I feel that there is something missing, namely the gas gravity. Is this correlation for a 0.6 gravity gas?
Mar 26 2011 12:32 PM -
shabanimr
hi, whwere can i download it?
Apr 18 2011 03:57 AM -
kamble.shridhar
dear sir,
the list books suggested by u process design
is wonderful... i can pick some of dem from ur list
thanks sir
Jun 16 2011 09:20 AM

FB
This status update has reached the maximum number of replies allowed
