Historical Forecasts for Your BTS Project Tracker

In writing about Historical Forecasts I want to know if you’ve been following this series?  I’ve written in detail about all the steps to put together a project tracker that was easy to update, quick to use, and did most of the work automatically.  It’s my strong belief that any Excel Workbook which you use …

Excel BTS Project Tracker – Forecasting

When I first began writing this article, I set out to create a Project Dashboard; a self-updating, all singing, all dancing dashboard that would automatically reveal everything anyone might possibly want to know about this project.  Having such a Dashboard would have fabulous consequences.  Like shortening all the project status meetings because the answer to …

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 …

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.  …

Excel BTS Project Tracker (Date Buckets)

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 …