Tag Archives: Excel

Introduction to Aspen Basic Engineering (Zyqad) and Database-Driven Design

Trouble with Aspen Basic Engineering,  formerly known as Aspen Zyqad? This post will help the new user get acquainted with the program. What is Aspen Basic Engineering/Zyqad? What is Database Driven Design? Aspen Basic Engineering is one of those database-driven … Continue reading

Posted in Database-Driven Design, Drawings and Diagrams, Excel, Simulation & Thermodynamics | Tagged , , , , , , , , , , | 1 Comment

Use VLOOKUP and HLOOKUP to use Data Tables in Calculations

Small Excel tip today: use the Excel functions VLOOKUP and HLOOKUP to allow you to use tables of data in your calculations. You can configure these commands to "look for the closest match" or to "only find an exact match" … Continue reading

Posted in Excel | Tagged , , , , , | 1 Comment