ASSURA · 4G only

4G Below 99%

Share of sites with 4G NAV below 99.000% against the universe of sites that have a 4G counter. National threshold is 4%; each circle has its own threshold (Setup). MTD uses the calendar month; weeks use the Thursday–Wednesday reporting week.

← Home

Data sources

Drop a CSV or click a card. Multiple files in one slot are merged. Circle and MC come from the embedded sitemapping (55,731 sites, 9 Oct 2026); WDBH columns are used only for sites missing from it.

Pattern is 4 consecutive weeks, oldest on the left. 1 = 4G NAV at or above 99%, 0 = below 99%. x = no 4G counter that week, including weeks before the uploaded data starts (so a below week right at the start reads xxx0 and counts as Rule 1). Each week is judged on its own pattern, the evaluated week on the right. Rule 1 (1110, 11x0, 1x10, 1xx0, x110, x1x0, xx10, xxx0): only the latest week dropped, so it counts as above 99% with no ticket needed. Rule 2 (1100, 1x00, x100, xx00, 1110, 0110, 11x0): counts as above 99% only when POT or SPO hit the site the week before. 1110 and 11x0 only matter when Rule 1 is unchecked; 0110 is the only pattern here outside Rule 1. Rule 3 (1110, 1x10, x110, xxx0): counts as above 99% when POT or SPO hit the site in the evaluated week; it only changes the result when Rule 1 is unchecked. Rule 4 (1000, x000; off by default): the last 3 weeks dropped, and it counts as above 99% only when POT or SPO hit the site in every one of those 3 weeks. Every other pattern (0000, 0100, 1010 …, and 1000 / x000 without Rule 4) is chronic and stays below.

Save keeps uploaded files in this browser so they do not need to be uploaded again.
Report deck Builds the 16:9 PowerPoint deck in the order of the W40 deck: cover, National week on week, Batch 10, focus MC (4 circles), uplift program, Report 1, 4G NAV, Reports 4–6, thanks and backup (Report 3). Uses the loaded data and the current Start–End dates, exclusion rules and thresholds. Charts and tables are native PowerPoint objects, so text and charts stay editable.

Site Analysis

Type a site ID. Same content as the site drawer: site information, Batch 10 status, 4G NAV weekly, NAV daily 2G / 4G / 5G, RCA and tracker history.