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


4.2 / 5 (5 votes)

please wait...