An interesting question was posted over on Stack Overflow recently. The question presented a challenge which I’ll paraphrase thus: Based upon the accompanying billing system data, how would you use Excel to list the Base Station generating the highest revenue by Area, Region, and Product? First, let’s pause for a moment of thanks that this …
Author Archives: russell
2G Network Decommissioning, Ready?
The idea of 2G Network decommissioning is hot right now. Many operators still operate 2G networks. They’re wondering when is the right time to turn it off. I want to use this article to share my experience. I did a 2G Network Decommissioning analysis for an operator awhile back. It is a complex topic, with a …
Excel BTS Project Tracker – Dynamic Named Ranges
We’ve never met before. But I already know a lot about you. You probably work in technology, maybe in a Mobile Network RAN. You already use Microsoft Excel, and you’d like to get better at it. You are not a manager and don’t have a team of people to supervise or manage. Lastly, you want …
Continue reading “Excel BTS Project Tracker – Dynamic Named Ranges”
September 2017 Writing Roundup
Each month I summarize my work during the previous month. I hope that by pausing to reflect on my activities and reviewing my progress that I can learn how to do better in the future. This month was was very exciting. More people read my stories than ever before. The Spectrum Futures 2017 conference in …
Excel BTS Project Tracker – New Date Format
So far in this series I’ve written 4 articles building our Project Tracker. I’ve set up the Updates table and created progressively more complex Pivot Tables by using Lookups, Synthetic Data and Bucketization. But let me stop for just a moment to talk about where I’m going with this. I’ve written before about Excel Dashboards. …
Continue reading “Excel BTS Project Tracker – New Date Format”