Ocean Sense - OTV Staff
Overview -
LIVE
Setup mode: these numbers are placeholders
The dashboard is not yet connected to your Google Sheet. Deploy the Apps Script and paste the URL into the HTML to see real data. See the setup guide for steps.
Connection issue. Showing last known data.

Overview

A snapshot of everything happening across the business

Revenue (month)+18%
RM 0
of target
Oysters soldOn track
0pcs
of monthly goal
Live stockHealthy
0pcs
Across farms + stalls
Avg mortality (30d)Monitor
0%
Acceptable: below 5%

Revenue trend (last 14 days)

B2C stalls + B2B orders combined
All channels

Stall status

Live open or closed
Desa Pandan
-
-
Taman Sri Watan
-
-
Schedule: Fri, Sat, Sun · 9:00 PM to 12:00 AM

Daily Operations

Calendar view of every shift logged. Each operating day shows staff, stock, sales, and costs.

Staff log shifts via the mobile form. Share the form URL with your team and they can bookmark it on their phone.
Operating days
0
This month
Total sold
0pcs
This month
Net income
RM 0
After costs
Avg per shift
RM 0
Revenue per shift

Calendar

Tap a day to see details. Blue = shift logged.
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Shift logged
Has incidents
No shift

Recent shifts

Most recent first. Tap to expand.
From to

Sales & Revenue

Revenue and volume across any time period, with comparison to the previous one.

Weekly revenue
RM 0
B2C stalls + B2B orders
Weekly volume
0pcs
Oysters sold
Avg per shift
RM 0
0 shifts logged

Revenue trend

Daily revenue this week

Revenue mix

B2C vs B2B this week

Sales by stall

Volume this week

Orders Pipeline

Track Pack, Pre-Order, On Land, B2B, Events, and B2E orders through every stage from placement to completion.

In Pipeline
0orders
Not yet completed or cancelled
Pipeline Value
RM 0
Total RM in active orders
Deposits Received
RM 0
Cash in hand from advances
Completed This Month
0orders
Successfully delivered

Pipeline Board

Scroll horizontally on smaller screens. Click a card for details.
📝 Order Placed
0
💰 Deposit Received
0
🌊 Harvest Scheduled
0
📦 Ready
0
🚚 Out for Delivery
0
✅ Completed
0

Stock & Inventory

Live view of oyster inventory across farms and stalls

Total live stock
0pcs
All locations
Ready to sellAvailable
0pcs
Passed depuration
In grow-out
0pcs
Not yet harvest ready

Stock by farm

Distribution across locations

Stock by grade

Premium vs Standard

Stock details

Batch-level inventory
LocationBatchGradeQuantityAge (days)Ready?

Mortality & Health

Monitor oyster health and track losses across batches

Deaths (30 days)
0pcs
Last month
Avg rate
0%
Acceptable: below 5%
Incidents logged
0
Individual reports

Mortality by batch

Percentage loss per batch in the last 30 days

Batch Traceability

Track every batch from spat to distribution

All batches

Full lifecycle view
0 batches
Batch IDSource FarmDate ReceivedInitialSoldMortalityRemainingRevenueProfitStatus

B2B Orders

Bulk sales, invoicing, and payment status

Total B2B revenue
RM 0
All orders
PaidCollected
RM 0
Confirmed payments
PendingOutstanding
RM 0
Awaiting payment

Pipeline

Recent orders by status
DateClientTypeQtyAmountDeliveryInvoicePayment

Payment split

Paid vs pending

Stalls & Hours

Active stall locations and operating schedule

To add or edit stalls, update the Stalls tab in your Google Sheet. Changes appear here within 5 minutes.
Active stallsLive
0
Currently operating
Operating days
3days/wk
Friday, Saturday, Sunday

All stalls

Live status and contact info
StallLandmarkPhoneHoursStatus

Settings

Targets, thresholds, and configuration values from your Google Sheet

These values are read from the Settings tab in your Google Sheet. Edit them there to update the dashboard.

Current configuration

All settings values
Loading settings...