Techno-Economic Modeling for Chemical and Bioprocess Innovations

Name: Techno-Economic Modeling for Chemical and Bioprocess Innovations
Price: 100 USD
Availability: InStock
ISBN: 9781394246410

by Chris Burk

1st Edition

Publisher: Wiley-Blackwell

(0 reviews)

Engineering

Compare Prices

Best PriceVitalSourceLifetime Access$100.00 AmazonKindle$103.00 AlibrisLifetime Access$103.00

Book Details

Print ISBN	9781394246410
eText ISBN	9781394246427
Publisher	Wiley-Blackwell
Publishing Year	2026
Edition	1st Edition
Language	English
Pages	358

Techno-Economic Modeling for Chemical and Bioprocess Innovations, 1st Edition, authored by Chris Burk and published by Wiley-Blackwell, is an academic textbook centered on developing techno-economic models within spreadsheets to assess economic drivers in chemical and bioprocess innovations. The volume establishes clear methods for converting chemical and biological process data into functional, dynamic financial spreadsheets.

Part I concentrates on essential spreadsheet construction standards. It presents systematic guidance on back-end data architecture, front-end user interface design, model documentation practices, and custom script implementation through Visual Basic for Applications (VBA). These chapters support learners in organizing raw data, input variables, and computational routines into stable calculation workbooks.

Part II expands into core modeling concepts, covering process diagrams, equipment sizing, process modeling, and equipment costing. Intended for upper-level engineering coursework, this 1st Edition provides practical frameworks for analyzing capital requirements and process viability across diverse technical applications.

Chapter 1: Introduction to Part I
- • 1.1 Uses for Spreadsheets
- • 1.2 Why Spreadsheets for TEM?
- • 1.3 Alternative Techno-Economic Modeling Platforms
- • 1.4 Importance of Good Spreadsheet Development Practices
- • 1.5 Spreadsheet Development as Software Development
- • 1.6 Back-End and Front-End Spreadsheet Development
- • 1.7 Important Terms
- • 1.8 Key Functions
- • 1.9 Keyboard Shortcuts
- • Reference
Chapter 2: Back-End Development
- • 2.1 Cell-Level Best Practices
- • 2.2 Worksheet- and Workbook-Level Best Practices
Chapter 3: Front-End Development
- • 3.1 General Principles of User Interface Design
- • 3.2 Cell-Level and Formatting Best Practices
- • 3.3 Worksheet- and Workbook-Level Best Practices
- • 3.4 User Interface Best Practices
- • Reference
Chapter 4: Documentation
- • 4.1 Nearby Cells
- • 4.2 Cell Notes
- • 4.3 Dedicated Location Within Worksheet
- • 4.4 Dedicated Worksheet
- • 4.5 Separate Document
- • 4.6 Screencast
- • Reference
Chapter 5: Visual Basic for Applications
- • 5.1 VBA Basics
- • 5.2 Working with VBA
- • 5.3 Applications to TEM
- • 5.4 AI-Assisted Coding
Chapter 6: Introduction to Part II
- • 6.1 Methods and Accuracy
- • 6.2 Anatomy of a Techno-Economic Model
- • Reference
Chapter 7: Process Diagrams
- • 7.1 Types and Use of Process Diagrams
- • 7.2 Defining Model Scope
- • 7.3 Best Practices
- • 7.4 Concluding Thoughts
- • References
Chapter 8: Process Modeling
- • 8.1 Spreadsheet Structure and Organization
- • 8.2 The Stream Table
- • 8.3 Material Balance Calculations
- • 8.4 Energy Balance Calculations
- • 8.5 Special Topics
- • 8.6 Development Workflow
- • Reference
Chapter 9: Equipment Sizing
- • 9.1 Spreadsheet Structure and Organization
- • 9.2 Utility Calculations
- • 9.3 Sizing Calculations
- • 9.4 Materials of Construction
- • 9.5 Development Workflow
- • References
Chapter 10: Equipment Costing
- • 10.1 Structure and Organization
- • 10.2 Power-Law Scaling
- • 10.3 Factors for Adjusting Purchase Cost
- • 10.4 Installation Factors
- • 10.5 Putting It All Together
- • 10.6 Development Workflow
- • References
Chapter 11: Capital Cost Estimation
- • 11.1 Important Distinctions
- • 11.2 Methods for Estimating Fixed Capital
- • References
Chapter 12: Operating Costs and Revenue Estimation
- • 12.1 Structure and Organization
- • 12.2 Variable Operating Costs
- • 12.3 Operating Labor Costs
- • 12.4 Other Fixed Operating Costs
- • 12.5 Revenue
- • References
Chapter 13: Economic Value Estimation
- • 13.1 Simple Metrics
- • 13.2 Time Value of Money and Discounting
- • 13.3 Levelized Cost
- • 13.4 Cash Flow Analysis
- • 13.5 Discounted Metrics
- • 13.6 Incremental Analysis
- • References
Chapter 14: The Dashboard
- • 14.1 Dashboard Design
- • 14.2 Best Practices
Chapter 15: Top-Down Modeling
- • 15.1 Top-Down Model Structure
- • 15.2 Steps to Building a Top-Down Model
Chapter 16: Model Review and Debugging
- • References
Chapter 17: Conclusion: Working with Uncertainty
- • 17.1 Uncertainty in Process Design
- • 17.2 Uncertainty in the Model Inputs
Chapter 18: Analysis Methods
- • 18.1 Cost Distribution Charts
- • 18.2 Basic Sensitivity Analyses
- • 18.3 Tornado Diagrams
- • 18.4 Monte Carlo Method
- • 18.5 Scenario Analysis
- • Reference
Chapter 19: Techno-Economic Analysis in Practice
- • 19.1 Assessing Potential for Economic Viability
- • 19.2 Assessing Risk and Uncertainty
- • 19.3 Guiding R&D
- • 19.4 Communication
Chapter 20: Bottom-Up Case Study
- • 20.1 Process Description
- • 20.2 Model Walkthrough
- • 20.3 Model Review
- • 20.4 Analysis and Discussion
- • References
Chapter 21: Top-Down Case Study
- • 21.1 Process Description
- • 21.2 Model Walkthrough
- • 21.3 Model Review: Comparison with Study Results
- • 21.4 Analysis and Discussion
- • References