Month: September 2017

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 precision, or do you close one eye and squint through the other to make your best guess based on the data and your experience?

I know that it takes all kinds to make the world.  There will always be a need for the beautifully aligned, 8-digit precision types.  For myself and the work I do, I always preferred the scribblers and the guessers.  I’ll take a Master of the Pareto Principle (https://goo.gl/P63YH5) over the i-dotters and t-crossers any day.

No slight intended to those people.  They do fine work, and there are times when that is essential.  Like rocket launches, aircraft manufacturing, pharmaceuticals.  But in my experience, Telecoms never respected that quality of work and the time required to do it.  Most of the time, whatever work we did today, ended up being redone, with a slightly different set of requirement, within a few months time.

The point I want to make is that there is a time and place for everything.  As Engineers and Technologists, we must maintain our situational awareness to know what kind of effort is required.  Know when the absolute best is required, and when going a little faster is more highly valued.  Put cavalierly, “Don’t make the Best the Enemy of Good Enough“.  There is a time and a place. Remember that. Continue reading “Excel BTS Project Tracker (Date Buckets)”

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 Manager.  Nor could the cost of a full-blown project management software.  Besides, for smallish projects like these, use of project planning software like Microsoft Project would be overkill.  So I had to rely on my team to report and track their progress themselves.  All too often I found that few of them were skilled enough with Excel to do this well.

But these types of projects are very common.  I realized that I should be teaching my teams how to do these things for themselves.  Not only did this seem like my responsibility.  But training the team would also serve both our interests. They would acquire new skills for their careers, and I would get a more capable team, besides the better updates I would get on these projects.  It was a fabulous win-win opportunity.

None of these techniques is very challenging.  And all of them use basic Excel functionality that can be used every day in many other circumstances. Please join me as I work towards a complete project tracker with a comprehensive dashboard. Continue reading “Excel BTS Project Tracker (This Technique is Much More Useful)”