APEx: Analysis of Processes with Excel
An Excel Add-In to integrate the tabular data found in Felder, Rousseau, and Bullard's Elementary Principles of Chemical Processes and to assist students in learning to solve systems of algebraic equations using Excel's Solver tool.
Due to changes in the way Microsoft works with Add-ins in Excel 2016, it is not currently possible to access the Equation Solving Wizard from a ribbon or toolbar in these versions. This is expected to change as Microsoft updates Office 2016 to complete its implementation of VBA.
To run ESW in APEx 1.10 when the APEx toolbar is not visible:
For Office 2016 (Mac), from the View tab select View Macros and type ESW in the dialog. Click Run and ESW should open.
For Office 2011 (Mac), from the Tools menu select Macro, then Macros..., type ESW in the name field and click Run. ESW should open.
APEx Documentation (READ ME BEFORE ATTEMPTING TO USE THE ADD-IN) Revised 9/23/14, new revision in progress
Recommended for Mac Office 2016, Windows Office
2010, Windows Office 2013:
APEx Excel Add-in 1.10 (RIGHT CLICK AND SELECT "SAVE LINK AS..." or "SAVE TARGET AS... ." DO NOT OPEN IN EXCEL, MUST BE INSTALLED BEFORE USE-- DO NOT DOUBLE-CLICK AFTER DOWNLOAD. SEE DOCUMENTATION. )
Recommended for Mac Office 2011
(incompatible with Mac Office 2016) and Windows Office 2007:
APEx Excel Add-in 1.01 (RIGHT CLICK AND SELECT "SAVE LINK AS..." or "SAVE TARGET AS... ." DO NOT OPEN IN EXCEL, MUST BE INSTALLED BEFORE USE-- DO NOT DOUBLE-CLICK AFTER DOWNLOAD. SEE DOCUMENTATION. )
APEx Excel Tutorial Workbook (open only after installing APEx or functions will return errors)
Use the spacebar to pause the video as needed. Refer to the documentation for more detail.
David L. Silverstein, Ph.D., P.E.
University of Kentucky