Love a Career in Telecoms. Since 2007.
“We’re gonna work on fundamentals: blocking, tackling, passing the ball.” As Telecom Pros, we love the shiny and new: 5G, mmWave, network slicing, #MIMO, URLLC, CRAN. OK, so we like acronyms, too. But when the excitement of sexy new technology wears off, there’s still a mobile network to maintain. And what does that mean? Reports. …
Continue reading “A pro sports team’s new coach always says this”
Ever been in a meeting or a conference call reviewing an Excel workbook? If the Row numbers are not shown on your printout, it can be hard to find exactly what the speaker is referring to. That’s much easier when the first column is a sequential number. Having each row identifiable by a unique number …
Do you use Excel Pivot Tables? If you do, then you know that Pivot Tables are a great way to categorize, sum, and average a table with many rows of numbers. If you aren’t yet using them, you really should. This article assumes you already use Pivot Tables comfortably. But more importantly, Pivot Tables are …
Dynamic Named Ranges are unquestionably one of the most important tricks for automating Excel Telecom Dashboards and recurring reports. Dynamic Named Ranges (DNR) are exactly what the name implies: an Excel named range whose size can change automatically. It’s hard to imagine a real-world example of a recurring report which does not benefit from Dynamic …
Continue reading “Excel Telecom Tricks – Dynamic Named Ranges”
It happens all the time: equipment in a Telecoms network stops reporting traffic statistics. It’s often a problem, though not always the one you think. The problem can be caused by a failing component somewhere along the data delivery path. You might think that’s the problem. More likely, the device is under excessive load, and …