Excel Telecom Tricks – Dynamic Named Ranges

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 …

Excel Telecom Tricks – Error Correction

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 …