LIVE CLOUD SPREADSHEET ENGINE • MAERSK SHEET INTEGRATED

Command Center Operasional Haulage & Container Real-Time.

Platform analitik terpadu untuk memonitor pergerakan kontainer MAERSK LOGISTICS INDONESIA (PT. SGMW Wuling Cikarang). Mengubah data operasional Google Spreadsheet menjadi visualisasi interaktif, perhitungan otomatis Plant Dwell Time, SLA dokumen SJ/LOLO, hingga proyeksi Peak Season.

Auto Dwell & LOLO SLA

Kalkulasi otomatis durasi Jam & Menit (In-to-Out Customer) serta durasi Hari (SJ/LOLO Diterima s/d Dikirim).

Interactive Cross-Filtering

Klik grafik tren (Day/Week/Month/Year), vendor trucking, skenario, atau driver untuk memfilter seluruh dashboard seketika.

Peak Season Forecasting

Simulasi kebutuhan unit armada LNJT vs Partner menghadapi lonjakan Harbolnas, Nataru, & pembatasan SKB Kemenhub.

Multi-Sort & Instant Export

Pencarian 8 kolom simultan, pengurutan di semua kolom, dan ekspor data terfilter ke Excel (.xls) atau CSV.

Akses Terenkripsi • Khusus Personel Terotorisasi

Preview Arsitektur Sistem

GID: 959717275

Referensi Waktu

TGL STUFFING

Day • Week • Month • Year

Kalkulasi Otomatis

Dwell & LOLO

Jam:Menit & Hari Kerja

1. Durasi Plant Dwell (Cust): (Out Date+Time) - (In Date+Time)

2. Durasi Dokumen SJ/LOLO: (SJ Dikirim) - (SJ Diterima)

3. Proteksi Akses Data: Multi-Role (Admin & Viewer)

Status Koneksi Google Sheet: Siap Sinkronisasi

OPERATIONAL INSIGHT

Auto-Computed from Sheet

LNJ Operations handled 291 total container movements across 64 fleet units for MAERSK LOGISTICS INDONESIA.

Fleet Allocation

Internal fleet (36% LNJT) operates in tandem with partner hauliers. SGMW Cikarang plant dwell is sustained at 8.9 hrs.

Trip Turnaround & LOLO SLA

Core operational flow is driven by "Wuling Mini CY". Average SJ / LOLO document turnaround is 3.0 days.

Seasonality Advisory

Seasonality Warning: Monthly run-rates separated (Oct baseline: 213 TEU). Nov is projected at 245 TEU (+15%) and Dec at 273 TEU (+28%) before Nataru toll curfews.

VOLUME & HAULAGE

291 Containers (TEU)

Total Orders: 291 100% Done

INTERNAL FLEET SHARE

36% LNJT (105 trips)

Partners: KAS (181) / RESTU (5)

AVG PLANT DWELL & LOLO

8j 54m (8.9 Hrs / Truck)

Avg SJ/LOLO SLA: 3.0 Hari

ACTIVE DRIVERS & UNITS

46 Drivers on 64 Prime Movers

Top Driver: IING (22x)

Order Trend (Calculated from VOL Column • Ref: TGL STUFFING)

Total Volume: 291 TEU across 291 shipments. Click any bar to filter.

Interactive Filter: Klik batang grafik untuk memfilter periode Tgl Stuffing.

Top Trucking Vendors

Order count and % allocation (Click to filter)

Klik kartu vendor untuk filter MAERSK Hauliers

Scenario Performance & Distribution (Order & %)

Breakdown across Mini CY, Wuling Mini CY, Repo Full, Repo Empty, Factory, and Normal shipments (Click card to filter)

Top Drivers Activity (Trips)

46 Active

Click driver to filter PT SGMW Cikarang

Operational Drilldown Details Table (Live Filtered Dataset)

Full interactive table with sorting, multi-column search filters, row count per view, and full filtered export.

Rows:

Multi-Column Search Filters (Real-time Filter across 8 Columns):

NO KEVIN

SCENARIO

NOPOL

DRIVER

TRUCKING

NO CONT IN

NO CONT OUT

BL / STATUS

Showing page 1 of 1 (Total filtered records: 291)

Operational Drilldown: Filtered dataset holds 291 orders out of 291 total rows.

LNJ Logistics Order Forecasting Engine

Considers Indonesian National Holidays (Maulid Nabi, Nataru Christmas & New Year), Harbolnas Mega Sales (10.10, 11.11, 12.12), and Kemenhub SKB toll restrictions.

Forecast Horizon:

PROJECTED TOTAL DEMAND

245 Containers (TEU)

Run-rate: 115% of Oct base (213 TEU)

LNJT FLEET COMMITMENT

88 TEU (36%)

Partner Allotment: 157 TEU

OPERATIONAL WORKDAYS

25 Days

Dispatch Cadence: ~10 TEU / Day

SKB KEMENHUB STATUS

Standard Haulage Routes

Regular 24-hr toll transit permitted for container haulage

Monthly Volume Comparison: September (Actual), October (Actual), November (Forecast), December (Forecast), January (Forecast)

September and October actual orders are separated dynamically from sheet data. Monthly baseline run-rate is derived from October so November and December forecasts are accurate and uninflated.

Forecasting Tabular Information & Seasonal Allocation Matrix

Comprehensive horizon breakdown comparing working workdays, daily haulage rates, LNJT fleet vs partner quotas, and SKB toll restrictions.

Click any row to select horizon

HORIZON / MONTH	TYPE	WORKING DAYS	DAILY CADENCE	VOLUME (TEU)	VARIANCE VS OCT BASE	LNJT FLEET (36%)	PARTNER HAULIERS	SKB TOLL STATUS	RISK STATUS

Independent Monthly Run Rates computed dynamically from MAERSK Sheet. Target Destination: PT. SGMW (Wuling) Cikarang • MAERSK LOGISTICS INDONESIA

Indonesian Calendar Events & Buffer Strategies for Nov 2026 (Forecast)

Operational mitigation recommendations formulated for SGMW Wuling Cikarang supply chain:

Comprehensive Logistics Orders Table

Displaying 291 sorted records with all 20 datasource columns + calculated: Plant Dwell (Hour & Min) and SJ/LOLO Duration (Days). Click headers to sort.