APPENDIX C

Excel Tips and Useful Functions

A significant amount of the content in this appendix is taken from Appendix D in my earlier book on waiting line applications.1 The content has been updated and augmented with some new content to better serve the discussion of integrating information considerations more thoroughly with other business processes. Readers interested in a more in-depth coverage of process simulation methods using Excel should find the waiting line book a useful companion reference.

Data Analysis Pack

This option in Excel needs to be activated for simulations since many of the functions mentioned require it. It is loaded when the software is installed, but for reasons unknown it is left to a user to activate it. Similarly, ...

Get Integrated Management of Processes and Information now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.