Process Modeling Excel Workbook
Originally published: 24/11/2017 17:18
Last version published: 27/11/2017 14:06
Publication number: ELQ-35675-2
View all versions & Certificate

Process Modeling Excel Workbook

Workbook in Excel illustrating techniques- using VBA subroutines- for incorporating input data into a process model.

Process modeling can be described as the precise description of the total variation in 1 quantity- y- by dividing it into

-a component provided by a mathematical function of at least one other quantity: x1, x2, plus

-a component chosen at random that will follow a particular probability distribution

Contains 4 sheets including:
1/ Splash
2/ Inputs & Results
3/ Use Durations
4/ Use Amounts

This template accompanies Chapter 25 of Rules of Thumb for Engineers, 6th Edition by Stephen M Hall, PE. The templates are intended to solve problems outlined in the book, explain techniques for converting U.S. & SI units of measure, demonstrate data look up methods, and provide you with ready-to-use data sheets. The function subroutines can also be copied to other spreadsheets.

You can buy the textbook here:

*Originally shared on*

This Best Practice includes
1 Downloadable Process Modeling Workbook in Excel

Stephen Hall offers you this Best Practice for free!

download for free

Add to bookmarks




More Best Practices from Stephen Hall


Any questions on Process Modeling Excel Workbook?

The user community and author are here to help. Go ahead!

4.0 / 5 (3 votes)

please wait...