File inbox
0/11 menus ready

Upload once, use across tasks

Filled slots are shared. Green menu = required files are complete. Main analysis uses Run ready tasks.

Overview

Choose a task to run

Last update · 30 Sep 2026 HTML Portable No install

One webapp, several tasks

Conversion hub for weekly operational files.

Upload files once in the Inbox, then open a green menu. Copy the OA-Tools folder to a USB or shared folder and open it in any browser.

Active menus 11
01 Waiting for files

Power Database Converter

Take 25 selected columns from the weekly Power Database file (.xlsb / .xlsx), plus ran label from sitemapping.csv, then export a lighter converted file.

  • Upload the source file
  • Detect PDB - RAN sheet
  • Export compressed XLSX (smaller) or XLSB
Open menu
02 Waiting for files

P1 ANOD merge

Upload a ZIP or RAR of 2G / 4G / 5G Excel files, merge in memory, then export the merge CSV and 4G NAV < 100% sites.

  • Upload one or more daily ZIP/RAR files
  • Read 3 sheets in memory
  • Export CSV merge + site <100% + last 7 days stability
Open menu
03 Waiting for files

Incident extract

Upload the daily Incident file, split Site List Impact into one row per siteid, map to the tracker layout, then export CSV.

  • Upload Excel daily Incident
  • Split Site List Impact into rows
  • Output: fixed tracker layout (54 columns)
Open menu
04 Waiting for files

POT extract

Upload the daily POT file, split LIST IMPACT into one row per siteid, then export CSV.

  • Upload Excel daily POT
  • Filter last Date, then split LIST IMPACT
  • Lookup fm office / mc / region / city / circle_id / ran label
Open menu
05 Waiting for files

Hourly NAV / LND

Calculate daily 4G NAV from hourly COO, then map LND to Incident, POT, and OPEN LTOA.

  • Upload 4 ZIP/CSV hourly circle
  • Upload Incident, POT, dan LTOA tracker
  • Export 1 XLSX: SUMMARY · Site-Hour · Site NAV < 100%
Open menu
06 Waiting for files

Last 7D Performance

Combine multiple WDBH 7Days files with sitemapping.csv into one row per site for the last 7 days, plus a weekly report.

  • Upload sitemapping.csv
  • Upload multiple W-YYYY-WW_Sitelevel_WDBH_7Days.csv
  • Export last 7 days, or the weekly Below 99 report
Open menu
07 Waiting for files

Command Center RCA

Take selected columns from the Master RCA Tracker sheet in the Command Center file, plus the snapshot date.

  • Upload CommCenter_Chronic_Master_Tracker_*.xlsb
  • Set Snapshot to the download date
  • Export selected columns as CSV
Open menu
08 Waiting for files

Combine OWS Spare

Merge SPHS and SPMS from the OWS transaction file into one Ultimate table, then export XLSX.

  • Upload OWS transaction .xlsx
  • Map SPHS + SPMS into 16 Ultimate columns
  • Export one combined XLSX
Open menu
09 Waiting for files

Split Week/Month

Upload a monthly ZIP/RAR of daily site-level WDBH, map each DATE to week from Tim Reference, join sitemapping, then export the selected weeks.

  • Upload ZIP / RAR / CSV (month accumulation)
  • Map DATE → week from Reference Time
  • Filter weeks, Re-analyze, export CSV + site profile
  • Combine a folder of files into 1 CSV
Open menu
10 Waiting for files

SPO Extract

Split the Scatter Power Outage sitelist (DIOC daily sheet SPO DDMMYYYY or SPO ticket range) into one row per site, then export the 9-column CSV for SAVANA / NAVORA.

  • Upload one or more DIOC / SPO ticket files
  • Split sitelist, keep every row (no dedup)
  • Export Daily_SPO_YYYYMMDD_Www / Monthly_SPO_* CSV
Open menu
11 Waiting for files

Combine file POT

Stack monthly POT CSV files such as M-2026-01_POT.csv into one file. Same columns, one header, every row kept.

  • Upload two or more POT CSV files
  • Order by month in the file name
  • Export POT_Combined_M-YYYY-MM_to_M-YYYY-MM.csv
Open menu

Menu 01

Power Database Converter

25 PDB columns + ran label XLSB / XLSX

Upload source file

Weekly Power Database file in .xlsb or .xlsx format.

Drop the file here or click to browse Example: PowerDatabase_WK33K_15082026.xlsb

Waiting for a file to be uploaded.

Result preview

First 20 rows of the columns that will be exported.

No data yet. Upload a Power Database file to preview.

Menu 02 · P1 ANOD merge

P1 ANOD merge

2G + 4G + 5G ZIP / RAR to CSV

Upload archive files

Accepts one or more daily .zip / .rar files. Excel must have 2G, 4G, and 5G sheets. Upload up to 7 days for accurate last 7 days stability.

Drop ZIP / RAR here or click the button below to browse Multiple daily files are allowed. Raw Excel also works

Waiting for ZIP / RAR files.

P1 ANOD merge preview

First 20 rows of the merged 2G / 4G / 5G result. Export goes to CSV.

No data yet. Upload ZIP / RAR to preview the P1 ANOD merge.

Site 4G NAV < 100%

Second P1 ANOD output. Sites with 4G NAV COO below 100%. Without tickets: DOWN (NAV 0%) → CHRONIC (0% < NAV < 100%).

No result yet. Run the merge first to see 4G NAV < 100% sites.

ASSURA

Network at a Glance

P1 ANOD 2G · 4G · 5G

Unique sites

Latest date in the P1 ANOD merge, one SITE ID once. Circle, region, and MC come from the P1 ANOD columns Circle, New Region, and MC Cluster. Kabupaten and kecamatan come from the embedded sitemapping. A site with 2G/4G/5G counts as 1 site 2G, 1 site 4G, and 1 site 5G.

Circle2G4G5GAllShare
No embedded result yet. Run P1 ANOD merge in OA Tools to store unique sites in this browser.

Menu 03 · Incident extract

Extract Tracker Incident

1 TT → many sites CSV

Upload sitemapping.csv

Upload once. Used to refill CIRCLE, SUB REGION, MICRO CLUSTER, and KABUPATEN / KOTA.

Drop sitemapping.csv here or click the button below Join: Site List Impact = siteid

Upload daily Incident file

Daily Excel (.xlsx / .xlsb). The Raw Data sheet is exploded from Site List Impact (newline delimiter), same as Power Query split into rows.

Drop the Incident file here or click the button below to browse Example: Incident List 20 August 2026 Full Day.xlsx

Waiting for an Incident file.

Site impact preview

First 20 rows after the split. Date columns are filled from the snapshot date (Thursday–Wednesday week).

No data yet. Upload an Incident file to preview.

Menu 04 · POT extract

Extract Tracker POT

1 event → many sites v20260823c · weekx + aging hh:mm CSV

Upload sitemapping.csv

Upload once. Used to refill fm office, mc, region, city, circle_id, and ran label. Same cache as Incident. week comes from Reference Time (weekx), kept in memory.

Drop sitemapping.csv here or click the button below Join: LIST IMPACT = siteid
Reference Time.xlsx · built-in

Upload daily POT file

Daily Excel (.xlsx / .xlsb). The POT Summary sheet uses the date from the filename (ddmmyy). If that date is missing, it uses the latest date that has LIST IMPACT.

Drop the POT file here or click the button below to browse Example: DIOC POT Events Summary Report (24 hours)_(210826).xlsx

Waiting for a POT file.

Site impact preview

First 20 rows after the split. Geography is refilled from sitemapping.csv.

No data yet. Upload a POT file to preview.

Menu 05 · Hourly NAV / LND

4G NAV SUMMARY + ticket mapping

COO 4G KPI 99.70%

Upload sitemapping.csv

Upload once. Circle uses circle_id. ran label is added to every CSV. Same cache as Incident / POT.

Upload hourly files for 4 circles

ZIP or CSV hourly_availability_*. A 06:00 snapshot = 24 hours of D-1 + 5 hours of today. Only the 24 hours of D-1 are calculated.

Upload Incident, POT, and LTOA optional

All three are optional — upload any of them, or none; Re-analyze still runs on hourly + mapping. Original files can go in directly — no need to run menu 03 / 04 first: Incident = original daily Incident Excel (sheet Raw Data) or the Task 03 CSV; POT = original DIOC POT Events Summary Report (sheet POT Summary) or the Task 04 CSV; from the DIOC file the SPO DDMMYYYY sheet is read too → category SPO (Fault Last Occur → start, Fault Resolving → end, blank = still open). All events in the file are read; only hours that overlap the NAV date are counted. LTOA: monthly tracker M-YYYY-MM_LTOA.csv (Date Release · SITE ID · STATUS · START TIME) — snapshot Date Release = NAV date (else the latest earlier one), STATUS = OPEN; or the old ltoa_tracker_data_export_*.xlsx (Ticket Status = OPEN, Technology 4G). Sites on that day's LTOA list use the full 24 hours of the NAV date and always win vs POT/Incident.

4G NAV SUMMARY

Ticket-attributed LND, unique on siteid + hour. If more than one category hits (Incident / POT / LTOA), the larger LND wins.

Site 4G NAV < 100%

All sites with 4G NAV below 100% that day, regardless of the 99.70% KPI gap. Order: LTOA / LTOA (new) → POT/Incident (largest LND) → DOWN (NAV 0%) → CHRONIC (the rest, including Potential and NAV 99.95%–<100%).

Menu 06 · Last 7D Performance

WDBH last 7 days

Multiple week CSV 2G_YYYY_W*

Upload sitemapping.csv

Upload once. Fills site_name, fm office, mc, city, province, region, circle_id, site_istimewa, and ran label. Same cache as the other menus.

Drop sitemapping.csv here or click the button below Join: SITEID = siteid

Upload weekly NAV (WDBH 7Days)

Multiple weeks are allowed. Export 1 keeps the latest 7 calendar dates (can cross weeks). Export 2 is the weekly report: 2G_YYYY_W* / 4G_YYYY_W* for every uploaded week.

Drop WDBH files here W-YYYY-WW_Sitelevel_WDBH_7Days.csv Example: W-2026-30 through W-2026-33

Waiting for sitemapping.csv and WDBH files.

Last 7 days preview

One row per site. Last 7 days of NAV, weekly 2G/4G for every uploaded week, occurance below 99%, healthiness from the last 4 weeks, and last 7 days stability.

No result yet. Upload files, then analyze.

Compile last 7 days files → 1 file

Add several WDBH_LAST7_YYYYMMDD_W##.csv exports. One row per site, two columns per week (oldest week on the left): L7DS Istimewa (w##) and L7DS <99 (w##) (L7DS = last 7 days stability). Week comes from the file name (or from Reference Time). Same week twice → the file with the latest date is used. Old files with only last 7 days stability fill the Istimewa column. Then 2G (w##) and 4G (w##) weekly NAV per week (from the file's 2G/4G weekly columns; older files: mean of the daily columns of that week).

FileLast dateWeekSitesStatus
No files yet.

Pick the folder with WDBH_LAST7 files, or choose files.

Menu 08 · Combine OWS Spare

SPHS + SPMS combined

1 file → 1 table XLSX

Upload OWS transaction

Excel with sheet SPHS and/or SPMS. If both exist, they are combined into one Ultimate table. If only one exists, the other side stays blank.

Drop the OWS file here or click the button below to browse Example: OWS transaction 20260823.xlsx

Waiting for an OWS transaction file.

Ultimate preview

First 20 rows of the combined SPHS + SPMS table.

No data yet. Upload an OWS file to preview.

Menu 09 · Split Week/Month

Month daily → selected weeks

ZIP / RAR / CSV week from Tim Reference

Upload daily site-level WDBH

Drop a monthly ZIP/RAR (or the CSV inside it). DATE is mapped to week from the built-in Reference Time. Site profile columns come from the built-in sitemapping.csv. Source WEEK is ignored.

Drop ZIP / RAR / CSV here or click the button below to browse Example: Sitelevel_WDBH_Daily_August_2026_with_5G_v2.rar
Reference Time.xlsx · built-in sitemapping.csv · built-in

Week filter

Analyze first to list weeks. Uncheck weeks you do not need, then Re-analyze and export.

No weeks yet

Waiting for a daily site-level ZIP / RAR / CSV.

Selected weeks preview

First 20 rows. WEEK comes from Tim Reference. DATE is dd-MMM-yy.

No result yet. Upload the monthly archive, pick weeks, then Re-analyze.

Combine folder → 1 file

Join many files from one folder into a single CSV (example: M-2026-01 … M-2026-10_Sitelevel_WDBH_Monthly.csv → one file). Rows are stacked in file-name order, values are kept as-is, nothing is removed. Columns are matched by header name; a column missing in a file stays blank.

Windows folder dialog shows folders only (files look hidden — that is normal): open the folder, then click Select Folder. Chrome / Edge only for folder access; otherwise use Choose files or drop files below. Files with Combined in the name are unticked so an earlier output is not added twice.

Drop CSV files here or click to browse
#FileSizeColumnsHeader vs first fileRows
No files yet. Pick a folder or choose files.

Pick a folder, or add files.

No result yet. Combine to see the first 20 rows.

Menu 10 · SPO Extract

SPO sitelist → one row per site

DIOC daily · SPO tickets CSV · 9 columns

Upload SPO source

DIOC POT Events Summary Report (sheet SPO DDMMYYYY) or an SPO ticket extract (sheet SPO_*DIOC / sheet1). Several files at once is fine: one CSV per file.

Drop SPO files here or click the button below to browse Example: DIOC POT Events Summary Report (24 hours)_(290926).xlsx · SPO 1 ~ 28 September.xlsx

Waiting for DIOC daily or SPO ticket files.

Files

Click a row to preview it. Export on a row saves that file only.

Source fileTypeSheetEventsSite rowsUnique sitesQCOutput

Combine daily → month-to-date

Join daily SPO files of the same calendar month into one file, day 01 up to the latest day available. Today up to the 20th → Monthly_SPO_YYYYMM_01-20.csv; tomorrow run it again → _01-21. Full month → Monthly_SPO_YYYYMM.csv.

Windows folder dialog shows folders only (CSV files look hidden — that is normal). Open 00_DATA SPO (or your daily folder), then click Select Folder. Files are recognized by content: any CSV with site_id + Snapshot, and DIOC workbooks (name contains DIOC / SPO). Sub-folders one level deep are included. You can also drop files on the box below.

Drop daily CSV / DIOC files here or click to browse

Pick the 00_DATA SPO folder, or add daily files.

MonthDays includedMissing daysSite rowsUnique sitesSame day twiceOutput
  • No notes.

Output preview

First 20 rows of the selected file.

No data yet. Upload an SPO file to preview.

Menu 12 · Uplift Tracker Cleanup

Cleanup tracker uplift B09 / B10

Tracker + OWS + WDBH + POT/SPO Output .xlsx

Menu 11 · Combine file POT

Monthly POT → one CSV

Several CSV → 1 file same columns

Upload monthly POT files

CSV from menu 04, named like M-2026-01_POT.csv. Files are stacked in month order. Columns are matched by name, so a month with extra columns still joins. No row is removed.

Drop POT CSV files here or click the button below to browse Example: M-2026-01_POT.csv · M-2026-02_POT.csv

Waiting for monthly POT CSV files.

Combined preview

First 20 rows. Columns stay in the source order, including the repeated region column.

No result yet. Choose two or more POT CSV files.

Menu 07 · Command Center

Master RCA Tracker extract

XLSB / XLSX 16 columns + snapshot

Upload Command Center tracker

Only the Master RCA Tracker sheet is read. Set Snapshot to the download date of the Command Center file.

Drop the Command Center file here or click the button below Example: CommCenter_Chronic_Master_Tracker_2026 (12).xlsb

Waiting for a Command Center file.

Result preview

First 20 rows of the selected columns.

No data yet. Upload a Command Center file to preview.
ASSURA help

Local FAQ · no API key

Processing file...