📡 Data dikirim dari NAVORA (tab SAVANA): weekly dari daily WDBH, monthly dari slot upload monthly. Upload/ganti file dilakukan di sidebar NAVORA.
Drop .xlsx / .csv file(s) here, or click to browse — multiple files OK
Loaded from the server folder data/wdbh (same files as 4G Below 99%). A week that has both Daily and 7Days uses the Daily file. Or drop .xlsx / .csv here. Monthly workbook: only the "mc (monthly)" sheet is read. Site-level weekly/daily CSV rolls up to MC via mc/circle/region columns or the embedded SITEID mapping.
2. Correlate Incident/Outage Trackers (optional)
POT, Incident, LTOA, and SPO load from the server folders data/pot, data/inc, data/ltoa, and data/spo. A tracker saved as the default in this browser is used instead. Or upload a file here. Correlation runs when the files are in.
No file uploaded.
No file uploaded.
Kolom LTOA Remark memisah LTOA vs Potential LTOA.
No file uploaded.
No file uploaded.
Tracker POT / INC / LTOA / SPO diambil dari upload di sidebar NAVORA.
3. Choose months to compare
2G4G
⚠Figures are monthly aggregates as given in the sheet. If the compare month is a partial month (mid-month export), its LND will look smaller than a full month unless you account for that yourself. DENUM is not in this sheet, so NAV/DENUM here are estimated back from NAV and LND (DENUM ≈ LND ÷ (1 − NAV)); Impact% is each MC's LND against the sum of that estimated DENUM. Treat Impact% as directional, not exact PRD Impact%UNAV.
Circle Trend
Trend up to the compare month · vertical lines = baseline & compare · lost hours/day = LND ÷ 3600 ÷ data days in the month · Top 15 MC by Δ lost hours/day (2G+4G); impact = MC contribution to the circle NAV change = −(LND cmp ÷ circle Denum cmp − LND base ÷ circle Denum base); all MC together = circle Δ NAV
NAV 2G & 4G
Lost hours / day
NAV 4G per region
NAV 2G per region
Top 15 worsening MC
Δ NAV in pp · Δ lost hours/day · impact on circle NAV in pp
National Trend (estimated, weighted by MC)
2G NAV (est.)target %
4G NAV (est.)target %
Circle-Level NAV, Baseline vs Compare
Δ percentage points
2G NAV
4G NAV
NAV vs Outage Sites — National
Bars = unique sites with POT / INC / LTOA / Potential LTOA / SPO events per period (right axis) · lines = 2G / 4G NAV (left axis)
% Impact vs
Prioritization Matrix — 2G
NAV (compare month) vs Impact %UNAV · point size = |Δ NAV| vs baseline · color = classification · click a dot to select/deselect that MC for the improvement simulator
MC-Level Contributors
% Impact vs
Full population, sorted worst → best by compare-month NAV. Click a column header to sort (table view).
Continuous DegradationRecent DropRecent ImprovedHealthyInsufficient Data
MC Summary
One-page MC story for the selected MC (same picker as Site Matrix). Charts follow baseline → compare. Super 88 vs Must Win 50 uses sitemapping kab_cat. SPHS/SPMS = unique TT No. per domain (IP / POWER / RAN) from embedded OWS Spare; upload a newer file to replace.
Set a national NAV target · check MC in the list above to see how much of the gap they close
2G National Target
% target NAV
Current NAV (compare month)–
Current Lost Hours (national)–
Required reduction to hit target–
No MC selected yet
4G National Target
% target NAV
Current NAV (compare month)–
Current Lost Hours (national)–
Required reduction to hit target–
No MC selected yet
Site Matrix — 2G
% Impact vs
Drill-down per MC: top 30 sites below the NAV cut-off, ranked by Impact · each dot = 1 site · NAV (compare month) vs Impact %UNAV · point size = |Δ NAV| vs baseline · color = classification · hover = trackers (POT / INC / LTOA / SPO) hitting the site in the compare month · click an MC label in the Prioritization Matrix to open it here · click a site (dot or table row) to open the dossier
NAV cut-off
Site-Level Degradation
% Impact vs
Individual sites vs baseline. Sorted worst → best by Δpp. Click a column header to sort. Click a site row to open the dossier.
Continuous DegradationRecent DropRecent ImprovedHealthyInsufficient Data
Kecamatan — chronic sites & daily NAV (last 3 months)