-
Learn about our site
Profile Controls
Topics
Archives
Recent Comments
-
Recent Posts
Polls
Loading ...Blogroll
Category 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
Format databases and tables with Magic/Replace
I found a free tool that will automatically, intelligently let you format tables of data or databases: Magic/Replace Basically, you feed it columns of data, and make a change to the first row. And then it will do it’s best … Continue reading
Sparklines: Tiny Graphs to Show Lots of Data
Sparklines are a great little idea. We all know that a good picture is worth a thousand words. Similarly, sometimes there’s no substitute for a graph of some data. Sparklines are an attempt to get the power of graphs into … Continue reading
Posted in Drawings and Diagrams, Excel
Tagged edward tufte, graphs, microsoft excel, sparklines
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 cost estimation, equipment list, Excel, hlookup, line list, vlookup
1 Comment
Excel Chart Selector and Chart Cleaner
Want to create quick, clean, and appropriate Excel charts? Charts that show off your data in a smart way? Charts that get rid of grey backgrounds, huge labels, and annoying fluff? (Also known as chartjunk). Juice Analytics are so-called “information … Continue reading