Moonlight Bay de Consejo Lot Tracker
CONSEJO · COROZAL · BELIZE
{{ gsChipLabel }}
{{ gsSyncLabel }}
{{ profileName }}
{{ roleLabel }}
Adjust mode — drag a dot, or click one and nudge with arrow keys (Shift = 5px)
FILTER BY STATUS
▾
{{ l.label }}
{{ l.count }}
{{ listCount }} LOTS
LOT
{{ selectedNum }}
{{ selectedStatus }}
· Phase {{ selectedPhase }}
STATUS
{{ row.display }}
PORTFOLIO OVERVIEW
{{ availCount }}
of {{ total }} lots available
{{ o.label }}
{{ o.count }}
{{ o.pct }}
FINANCIALS
{{ f.label }}
{{ f.display }}
SALES VALUE BY STATUS
{{ sv.label }}
{{ sv.display }}
BY PHASE
PHASE {{ p.phase }}
{{ p.count }}
Select any lot dot on the map to view and edit its full CRM record here — owner, salesperson, price, closing, and more.
Lot Status Report — Moonlight Bay de Consejo
Moonlight Bay de Consejo Lot Tracker
Lot Status Report — {{ printDate }} · Consejo, Corozal, Belize
{{ f.label }}
{{ f.display }}
SALES VALUE BY STATUS
{{ sv.label }}
{{ sv.display }}
LOTS BY STATUS
{{ o.label }}
{{ o.count }}
{{ o.pct }}
TOTAL UNSOLD VALUE = TOTAL LOT VALUE − TOTAL DISCOUNTS − TOTAL SOLD
{{ profitDisplay }}
{{ pr.label }}
{{ pr.display }}
| Lot | Status | Owner | Phone | Salesperson | List Price | Discount | Sales Price | Deposit | Balance | Finance | Closing | Phase | Sq Ft | Acres | W (ft) | Depth (ft) | Hold Reason | Notes | Legal Description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ row.num }} | {{ row.status }} | {{ row.owner }} | {{ row.email }} | {{ row.phone }} | {{ row.salesperson }} | {{ row.price }} | {{ row.discount }} | {{ row.contracted }} | {{ row.deposit }} | {{ row.balance }} | {{ row.financeType }} | {{ row.closing }} | {{ row.phase }} | {{ row.size }} | {{ row.acres }} | {{ row.lotWidth }} | {{ row.lotLength }} | {{ row.holdReason }} | {{ row.notes }} | {{ row.legalDesc }} |
| Lot | Status | Owner | Phone | Salesperson | List Price | Discount | Sales Price | Deposit | Balance | Finance | Closing | Phase | Sq Ft | Acres | W (ft) | Depth (ft) | Hold Reason | Notes | Legal Description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ row.contracted }} | {{ row.balance }} | {{ row.size }} | {{ row.acres }} |
Change Log
No changes recorded yet. Edits to lot records, dot positions, and team members will appear here automatically.
| Date & Time | User | Lot | Field | From | To |
|---|---|---|---|---|---|
| {{ lg.when }} | {{ lg.user }} | {{ lg.lot }} | {{ lg.field }} | {{ lg.from }} | {{ lg.to }} |
{{ userModalTitle }}
{{ u.name }}
{{ u.role }}
{{ u.username }} · {{ u.email }} · {{ u.phone }}
{{ editUsername }}
{{ editRoleLabel }}
{{ userError }}
Google Sheets Database
{{ gsStatusLabel }}
{{ gsSyncLabel }}
{{ gsMsg }}
ONE-TIME SETUP
1. Create a Google Sheet for this community.2. Extensions → Apps Script, paste in the provided Code.gs, Save.
3. Deploy → New deployment → Web app; set Execute as: Me and Who has access: Anyone.
4. Copy the /exec URL, paste it above, and press Connect.
The full script and step-by-step guide ship alongside this app (see SETUP.md / google-apps-script/Code.gs). Until you connect, the app runs on this device only.