How it works: Your Google Sheet provides: Vessel Name (Col K) + Voyage No (Col L) + IMO No. (Col M). Dashboard reads all three → queries MyShipTracking API for real GPS position, speed, heading & ETA. Auto-refreshes every 5 min.
🚢
—
—
—
KNOTS
—
HDG
📅 —ETD
🚢
Departed0%Arriving
🏁 —ETA
🚢 Vessel Name
—
⚓ Voyage
—
📋 IMO No.
—
AIS LIVE DATA — MyShipTracking
📍 Current Area
—
🏁 Next Port
—
⚡ AIS ETA
—
🚀 Speed
— kn
🧭 Heading
—°
🏳 Flag
—
Last AIS signal: —
—
—
—
—
—
—
—
—
—
—
—
—
Filters→
Monthly Delay Value (SGD)
Delay Cause Breakdown
Delay Impact by Country — Count & Value (SGD)
Delayed Shipment Details & Remarks
0 shipments
🛒 Open Orders
Sales Lines · Line Amount Excl. GST · Live from Google Sheets
⏳ Loading...
⚠ Total looks low — select the correct column:
Override amount column:
Filter:
Open Orders
—
Line Amt Excl. GST
—
Customers
—
Categories
—
Vendors
—
Top Customers
Sales value by customer (SGD)
Sales by Month
■ Shipped ■ Open Orders
Sales by Category
Distribution by product category
Top Products / Items
Sales value by product description
Open Order Lines Detail
All lines · Sell-to Customer Name · Line Amount Excl. GST