Asee peer logo

A Student-Built Internal Combustion Engine Simulation Using Excel

Download Paper |


2011 ASEE Annual Conference & Exposition


Vancouver, BC

Publication Date

June 26, 2011

Start Date

June 26, 2011

End Date

June 29, 2011



Conference Session

Digital Simulation Tools in Energy Education

Tagged Division

Energy Conversion and Conservation

Page Count


Page Numbers

22.105.1 - 22.105.14



Permanent URL

Download Count


Request a correction

Paper Authors


Robert McMasters Virginia Military Institute

visit author page

Robert L. McMasters was born in Ferndale, Michigan, in 1956. He graduated from the U.S. Naval Academy, Annapolis Md, in June 1978 and completed Naval Nuclear Propulsion Training in August 1979. He subsequently served as a division officer on the USS Will Rogers (SSBN 659) until 1982. Following a 2 year
tour as an instructor at the S1W prototype of the Nautilus,
the worlds first nuclear powered ship, he resigned his
commission as a Naval Officer and began working as a
design engineer at K.I. Sawyer Air Force Base near
Marquette Michigan and later at Michigan State University in
East Lansing Michigan. He completed the Ph.D. at
Michigan State University in 1997 and continued to serve there
as a Visiting Assistant Professor until 2004 when he accepted an Associate Professor position at the Virginia Military Institute (VMI) in Lexington, Va. He currently serves as a Professor of Mechanical Engineering at VMI.

visit author page

Download Paper |


A Student-Built Internal Combustion Engine Simulation Using ExcelAbstractA numerical model for an internal combustion engine has been developed for use in a seniorelective course on internal combustion engines. The numerical model for the simulation is builtin an Excel file which includes previously-developed functions for obtaining thermal propertiesfor ideal gases. The properties include enthalpy, internal energy and the specific entropy at apressure of one atmosphere. Prior to the use of the functions in the internal combustion engineclass, mechanical engineering students enrolled in an undergraduate thermodynamics sectionwere offered the Excel ideal gas computer file for use in completing homework assignments.Additionally, they were offered a Mathcad file programmed with ideal gas properties for air in avery similar fashion. The students were offered the option of using either of these programs onany homework or on examinations involving ideal gas problems. They were also offered achoice of using neither of these programs, interpolating ideal gas data out of the textbookinstead. Records of the student selections and preferences are presented as part of this research.The numerical internal combustion engine model uses one degree of crankshaft rotation as itsdifferential element size, so there are 360 steps in a complete rotation of the model. Studentsbuild the model on their own by following the example presented in class. In each step, thecombustion chamber volume is computed using the global input values for bore, stroke, pistonrod length and crankshaft angle. Using these volume values, the cylinder pressure is calculatedby using the ideal gas law and the given quantity of air and vaporized fuel in the combustionchamber, based on an assumed temperature. A converged solution for the temperature is nextfound through an energy balance equation where the work of compression or expansion, fromone crank angle increment to the next, is set equal to the change in the internal energy of themixture of gasses in the cylinder as a function of temperature. By using a solver routine,custom-programmed as a macro in Excel, the temperature at each crank angle increment issolved for sequentially for all 360 increments. The ignition timing for a spark ignition engine, orthe fuel injection timing for a compression ignition engine, can be selected by the student.Additionally, this ignition or injection point can be optimized using a custom-programmedoptimization macro in the Excel file.With pressure and temperature calculated as functions of crank angle for an entire rotation of thecrankshaft, the net power produced by the engine can be calculated using the engine RPM value,which is selected by the students. As the engine speed is varied, the students can see the changesin power produced, engine efficiency, and optimum ignition timing angle. Homeworkassignments involving these calculations are assigned to the students. The addition of the enginenumerical simulation segment of the course was extremely well received by the students andcomments from a student survey on the subject were very positive.

McMasters, R. (2011, June), A Student-Built Internal Combustion Engine Simulation Using Excel Paper presented at 2011 ASEE Annual Conference & Exposition, Vancouver, BC. 10.18260/1-2--17387

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2011 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015