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, …
Tag Archives: Excel Tricks
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 …
Automate Telecoms Dashboard Dates
Here’s a challenge we face all the time in Telecoms: we need a list of the most recent months of data in a table. For example, a Telecoms Dashboard, which might show data for each of the most recent 12 months. For example, your Dashboard for May 2018 might show data from May-18, April-18, March-18, …