6 replies to this topic

[A.Dhandhania]

At my University, we are planning to organize a workshop which teaches about various applications of MS Excel in Chemical Engineering. 

 

However, we are finding it difficult to consolidate all topics relevant to chemical engineering that can be incorporated into the 10 hr workshop.

 

I request you to please type in the relevant topics that are most helpful. 

 

Thank you

[ankur2061]

A. Dhandhania,

 

A very good reference for topics in chemical engineering computing using MS Excel would be the book:

 

"Introduction to Chemical Engineering Computing" by Bruce A. Finlayson

 

There are many examples in the book which can be utilized for making an excel spreadsheet or matlab.

 

Regards,

Ankur 

[Bobby Strain]

You might better spend the 10 hours learning to use VBA in Excel.

 

Bobby

[ankur2061]

Bobby,

 

I don't know much about VBA and don't use it either in my spreadsheets, relying on the excellent function library of excel. But I would like to think that I do a fair job in preparing my spreadsheets. Don't you think so??

 

Regards,

Ankur

[Profe]

Hi Dhandhania

 

Another source of inspiration could be "Excel for scientists and engineers-Numerical methods" by E. Joseph Billo.

Good luck

 

Fausto

[Art Montemayor]

Dhandhania:

 

For a good example of a typical, practical, chemical engineering field application of Excel, go to:  http://www.cheresources.com/invision/topic/20114-partial-volume-horizontal-tank-height-calculation/#entry83149

 

This is a real world engineering application of a spreadsheet to solve an on-going problem in industry.  And there are thousands more of similar applications out there!  Don’t forget: the original spreadsheet invention (Lotus 1-2-3) was made to attack and resolve the 3 outstanding basic needs of engineers:

1. Make accurate and quick calculations;
2. Make graphical representations of data and results (graphs, curves, etc.)
3. Make engineering sketches and drawings.

Today, Excel can do all that and much more with the programming tools introduced with VBA (Visual Basic Applications).   Also, don't forget that a spreadsheet is basically a Flat Database - a means to store information for retrieval and use in on-going calculations.

[Shivshankar]

Dhandhania,

 

Following link might be useful

 

http://bookboon.com/en/search?q=excel