Hello everyone,
I’m looking for assistance with analyzing cell traffic across my network.
Specifically, I want to identify which cells have experienced a decrease in traffic over the past 7 days (on a weekly basis).
I’d like to avoid checking each cell manually. Instead, I’m hoping to use an Excel formula or VBA script that can automatically flag the cells with decreasing traffic.
For this, it’s best to compare the same days, for example, Monday vs. Monday, Tuesday vs. Tuesday, and so on.
At one point, I had to do something similar. To start, I took a value as the “initial value,” which was the average of the previous 6 days (6 Mondays in the past, for example) and compared it to the traffic on the last day in question. If traffic was below 80% (this was the threshold we determined to be ideal for us), then that cell was on a list for review.
So, for example, you avoid comparing a Friday vs. a Saturday in an industrial area, for example, where weekdays are busier versus a weekend, which is less busy, and would cause those cells to always be shown as “a possible decrease in traffic.”
The cases that tend to be atypical are those that may coincide with an event such as a national holiday. Following the example of the industrial zone, on a national holiday Monday, traffic would be lower than on an average Monday. But these are more specific cases.