5 Myths about Automated Excel Telecom Dashboards

I spend a lot of time talking about Automated Excel Telecom Dashboards.  Why?  Because they have made a tremendous difference for me.  There are 4 main benefits. Save your time by instantly updating periodic charts, graphs, and reports Declutter your brain to focus only on important business metrics Maintain laser-focus on the important metrics in your …

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 …

Single mod_perl Instance Serving Multiple Domains

I manage several low-traffic websites sites.  These sites use the classic 2-server Apache/mod_perl architecture.  The front-end server is a light Apache instance hosting a WordPress blog.  The heavy, back-end server is mod_perl-enabled Apache serving various web applications I’ve created. To the best of my understanding, mod_perl/Apache can only set-up and cache a single database connection.  …

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 …

October 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. October traffic increased quite a bit, more than double September!   Makes me happy because it means more of you are …