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 …
Category Archives: Excel
Excel Telecom Tricks – Exclusion
Here’s a problem I’ll bet you struggle with all the time. You’ve got sites in your network with problems. High handover failures, high dropped calls, other failing KPIs. It might include sites on the edge of a coverage area with no handover neighbors, or sites which are close to lakes and other bodies of water, …
Excel Telecom Tricks – Normalization
An objective common to almost every Telecoms activity you’ll do in your career is to share your work with others. Sharing in this sense can take many forms: Document steps taken. Identify a problem. Teach a task to others. Reveal a hidden truth. Propose another plan. Brainstorm fiercely. The context for each of these tasks …
Excel Telecom Tricks – Seasonality
We make lots of reports in Telecoms. Telecoms seems to be built on reports. Reports and acronyms. Reports for every piece of equipment, for every circuit, for every service, for every product. We make reports for forecasting, budgeting, both CapEx and OpEx, analyses, models. Tons of reports. Reports of all the reports. One of the …
Excel Telecom Tricks – Synthetic Fields
With any tool you use frequently to solve many problems, there’s sure to be lots of tricks and shortcuts that can make your job so much easier. Microsoft Excel is one of those tools for Telecoms, and there certainly are tricks and shortcuts. Learning them will help you become more proficient with Excel, and give …