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 …