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

Notes From Spectrum Futures 2017

This week I attended Spectrum Futures 2017, sponsored by Pacific Telecommunications Council (PTC) at the Pullman Bangkok Grande Sukhumvit on Asoke Montri Road in Bangkok. The conference was rather lightly attended, which allowed for a very collegial, clubby atmosphere to prevail.  Gary Kim and the PTC Events Team did a super job organizing and presenting …

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 …

Spectrum Futures Conference in Bangkok, 18-19 September 2017

Just a quick note to encourage all my friends in Thailand to attend Spectrum Futures 2017 conference next Monday and Tuesday. The conference will be held at Pullman Bangkok Grande Sukhumvit next Monday and Tuesday. I’ll be a panelist Tuesday morning at 08:40 for Moving Up the Stack: Where and How Can it be Done?  Please …

Excel BTS Project Tracker (This Technique is Much More Useful)

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 …