Love a Career in Telecoms. Since 2007.
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”
What kind of Engineer are you, how would you describe yourself? Are you the kind who uses a straight edge when you write so the lines will be beautifully aligned, or do you scribble something barely legible to get done and to move on to the next thing? Do you calculate cell boundaries using 8-digit …
I’ve been writing about how to create a BTS Project Tracker using Excel. Let me tell you a bit about why. Frequently in my career, my teams have had checklists they needed to perform at every BTS or Site in the network. These checklists were of a manageable size. I couldn’t justify a dedicated Program …
Continue reading “Excel BTS Project Tracker (This Technique is Much More Useful)”
Have you ever tried to use Excel to track the progress of a project? How did you do it? Did it work out OK? Or was it a huge mess, one that barely succeeded in reporting the status of the project? Often, before people start using Excel, they imagine a piece of paper that might …
Continue reading “Excel Project Tracker with Task Weighting”
One of the most common projects in Mobile Telecoms is to complete a checklist of tasks for each BTS in a group. In this series of blog posts, I’ll show you how to create an effective Tracker for this type of project using Excel. If you work with Excel, and especially if you are a …
Continue reading “Excel Project Tracker (with the Coolest Excel Function Ever!)”