I would like to learn Excel-VBA to minimize the calculation efforts, does anyone know the best book or any online website (if available for Chemical engineering would be great)?
You can try this book:
Victor J. Law, Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB, 2013 by CRC Press
You can read Google book on following link:
http://books.google.co.in/books?id=OIj1M35wxOsC&pg=PR17&lpg=PR17&dq=Any+book+or+website+to+learn+Excel-VBA+for+Chemical+Engineers&source=bl&ots=xzF0Efz52A&sig=P3L3Qrh38m_OXtS_F2N7fTrHxjw&hl=en&sa=X&ei=aEdPVIHAB4HOmwWVoYKoBA&ved=0CDcQ6AEwBA#v=onepage&q=Any%20book%20or%20website%20to%20learn%20Excel-VBA%20for%20Chemical%20Engineers&f=false
You can try this book:
Victor J. Law, Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB, 2013 by CRC Press
You can read Google book on following link:
http://books.google.co.in/books?id=OIj1M35wxOsC&pg=PR17&lpg=PR17&dq=Any+book+or+website+to+learn+Excel-VBA+for+Chemical+Engineers&source=bl&ots=xzF0Efz52A&sig=P3L3Qrh38m_OXtS_F2N7fTrHxjw&hl=en&sa=X&ei=aEdPVIHAB4HOmwWVoYKoBA&ved=0CDcQ6AEwBA#v=onepage&q=Any%20book%20or%20website%20to%20learn%20Excel-VBA%20for%20Chemical%20Engineers&f=false
Dear Bhautesh Mistry,
the book suggested by Professor, Dr.Kiran D. Patil is very good. For my VLE calculation I use Mathematica, but this is a very good resource.
I can suggest also the very good book of Professor Lira and Elliot.
http://www.egr.msu.edu/~lira/thermtxt1.htm
You can download some Matlab files, and a lot of materials.
Hope this is helpful.
A very good book indeed. Additionally, there is a online training session arranged by AIChE which could be useful.
http://www.aiche.org/resources/education/courses/ela118/spreadsheet-programming-chemes-excel-vba
There is another one book if you want to check . "Practical Numerical Methods For Chemical Engineers, Using Excel With VBA", 3rd edition by Richard A. Davis.
Dear Subhasish Mitra,
Thank you for your kind information. The online course provided by AIChE is a paid course. Did you learn Excel-VBA through AIChE?
Regards,
Bhautesh Mistry
Thank you very much Dr.Kiran D. Patil, Mariano Pierantozzi, and Christos D. Argyropoulos.
Regards,
Bhautesh Mistry
- Badges
- Science topic