Anyone who has worked on transmission line design or tendering knows the routine. You get a staking table with hundreds of towers, and someone has to turn it into a total tower weight, a count of each tower type, and a materials list. Done by hand, that takes a long time and is easy to…
Category: Microsoft Excel
Top Excel Functions Every Engineer Should Master
Excel is an indispensable tool for engineers, offering powerful functions to simplify complex calculations, analyze data, and optimize workflows. In this Post, we’ll explore the top Excel functions every engineer should master to enhance productivity and tackle technical challenges with ease. COUNTIFS The COUNTIFS function in Excel is used to count the number of rows that meet multiple…
Count items in a portion of column in Excel
This post is about how you can count items in a portion of a column in excel dynamically. We will use countifs excel function combine with index function. For example Look at the Figure 1. We have different types of towers in column A and PI points in column B. Here we want to count…