Jump to content



Community Status Updates


You may not create a status update as you have not met the requirements of 5 Forum Posts.

Photo

ankur2061

My photo album on flickr at:
Feb 23 2014 02:19 PM
Photo

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
Photo

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
Photo

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
Photo

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
Photo

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's Photo
    mhs
    keep enriching the younge mind...........
    Jul 03 2012 01:09 AM
Photo

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's Photo
    Chris Haslego
    Yes, both of those extensions can be uploaded.
    May 30 2012 07:35 AM
  • Technical Bard's Photo
    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's Photo
    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
Photo

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's Photo
    jrtailor09
    Wish U also happy marry Christmas.
    Dec 25 2011 01:23 AM
  • demank's Photo
    demank
    merry christmas too.., :)
    Dec 25 2011 05:25 AM
Photo

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's Photo
    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
Photo

ankur2061

"Ankur's Chemical Engg Blog" is now 100,000 views old
Aug 12 2011 08:47 AM
Photo

shasha → ankur2061

Dear Sir,
Thank you so much for adding me. I learned a lot from your blogs and entries.
Aug 02 2011 12:41 AM
Photo

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
Photo

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
Photo

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's Photo
    binzee
    Congrats, keep up the good work
    May 24 2011 08:07 AM
  • SANDYJACK's Photo
    SANDYJACK
    Your postings are really useful. Thanks!!!
    Jun 07 2011 08:40 AM
  • rowanlim's Photo
    rowanlim
    Congratulations, your insight is always appreciated!:)
    Jun 10 2011 07:41 PM
Photo

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's Photo
    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's Photo
    shabanimr
    hi, whwere can i download it?
    Apr 18 2011 03:57 AM
  • kamble.shridhar's Photo
    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