Business Management System

← Project Management PM tool
Notes

No notes for this page.

Noble Emmerse Phrom Phong

Bangkok, https://maps.app.goo.gl/mfB1vr3KxAsAnQKR8 · Ready

In Bangkok's True Heart. Supreme Over the City

Initial setup (once): upload the three Setup Excels below (Unit Info → Price Control → Unit Status & Selling Price) to generate the Price Matrix. Day-to-day: use Price Matrix for Released / Not released and price edits, and Operations for sold / reserved / exchanged. Reference: Noble Emmerse Phrom Phong.

Initial setup (once)

Complete these Excel steps in order the first time you open the project. Download each template, fill the blue input cells, then upload. Files are stored under data/projects/nem/uploads/.

Setup Excel Download returns the last uploaded workbook — it is not live inventory. For current sold / released / hold status, use Price Matrix → Download live inventory after the lab is ready. Re-uploading Setup Excels regenerates the Price Matrix from those files (bulk price revision) and can overwrite base statuses in units.json. Lab overrides and Ops holds still apply on top — confirm inventory after a full re-upload.

1. Unit Info

Sheets: Martix, Sales Condition, Unit Info. Blue cells are manual input. Unit Info rows match Total Number of Units. Right of Unit Code: Plan Code (layout plan stem, e.g. A13), Unit Type (dropdown), Size, Upper Floor Size, and Total Size (Size + Upper). Unit Code is the stack used with Tower + Floor for Unit Number; Plan Code is for price-card unit plan images. After House No.: Sales Status (Reserved / Exchanged / Completed / Unsold), Reservation Date, and Transacted Price (for future Operations linking).

Saved: Unitinfo_NEM_2026-08-15_v2_2026-08-16 (1).xlsx · 2026-08-27 · Download copy

2. Price Control

Sheets: Investment + Control (Investment omitted when unit nature is Agency only). Rows match Underwriting / Real Asset units; project unit codes prefilled when available.

Saved: Pricecontrol_test NEM_2026-08-05.xlsx · 2026-08-16 · Download copy

3. Unit Status & Selling Price

Sheets: Unit Status, Selling Price and Promotion. Rows match units with Availability = Available; project unit codes prefilled. Price 100 is filled from Price Control when uploaded. Unit Status uses a Released / Not Released / Sold dropdown. If Unit Info Sales Status is Reserved, Exchanged, or Completed, Unit Status is prefilled as Sold and locked.

Saved: Unitstatus_test NEM_2026-08-05_4 difference price testing_17_August.xlsx · 2026-08-17 · Download copy

Matrix / Unit summary

Layout summary from Unit Info. Price Matrix is generated from the 3 Setup Excels (Unit Info · Price Control · Unit Status & Selling Price) when all are uploaded.

ready Open Price Matrix
358Total units
156Available
202Unavailable
52Floors
11Stack codes
416Matrix cells

By unit nature

  • Agency202
  • Underwriting156

By unit type

  • 2 Bed152
  • 1 Bed110
  • 3 Bed46
  • 4 Bed46
  • Penthouse4

Stack codes

B1 A2 B3 A4 A5 C6 E7 B8 P2 P1 B9

Sample: NEM 5B1, NEM 5A2, NEM 5B3, NEM 5A4, NEM 5A5, NEM 5C6, NEM 5E7, NEM 5B8, NEM 6B1, NEM 6A2, NEM 6B3, NEM 6A4…

Matrix preview

Floor South South South West West North North & East East
55 NEM 55P2 NEM 55P2 NEM 55P2 NEM 55P2 NEM 55P2 NEM 55P2 NEM 55P2 NEM 55P2
54 NEM 54P1 NEM 54P1 NEM 54P1 NEM 54P1 NEM 54P1 NEM 54P1 NEM 54P1 NEM 54P1
53 NEM 53P1 NEM 53P1 NEM 53P1 NEM 53P1 NEM 53P1 NEM 53P1 NEM 53P1 NEM 53P1
52 NEM 52P1 NEM 52P1 NEM 52P1 NEM 52P1 NEM 52P1 NEM 52P1 NEM 52P1 NEM 52P1
51 Private Dinning The Chef Reserve Sky Scenic Lounge Co-living Space Co-living Space The Urban Sky Lawn The Urban Sky Lawn Sky Lounge
50 NEM 50B1 NEM 50A2 NEM 50B3 NEM 50B9 NEM 50B9 NEM 50C6 NEM 50E7 NEM 50B8
… … … … … … … … …
6 NEM 6B1 NEM 6A2 NEM 6B3 NEM 6A4 NEM 6A5 NEM 6C6 NEM 6E7 NEM 6B8
5 NEM 5B1 NEM 5A2 NEM 5B3 NEM 5A4 NEM 5A5 NEM 5C6 NEM 5E7 NEM 5B8
4 Cinema Lounge Meeting Forum & Working Pod Cycling Station Pilates Studio Private Mind Studio Emmerse Gym Aqua Serene Pool Playscape

Generated 2026-09-08 01:43:50 UTC · from Unitinfo_NEM_2026-08-15_v2_2026-08-16 (1).xlsx

Commission Payable

Two independent logs: standard for a normal unit, and bulk for multi-unit bookings. Project Management fills in a new rate; the Managing Director must review it before it is confirmed and used on bookings. Each has its own start and end dates. You can gap-fill before a future entry; future-dated approved rows can be removed. End dates close automatically when an approved entry starts inside an open range.

Standard commission

Rate for a normal (single-unit) booking. Used whenever bulk does not apply. Submitted rates stay pending until the Managing Director confirms them.

Standard Log

Rate Paid when Start End Status Created Notes
Loading…

Bulk commission

Rate for multi-unit bookings. Each entry sets how many units the bulk rate applies from. Different unit thresholds may share the same dates (for example ≥2 and ≥5 at once); a booking uses the highest threshold it meets. Submitted rates stay pending until the Managing Director confirms them.

Bulk Log

Rate Applies at Paid when Start End Status Created Notes
Loading…

Commission Receivable

Vendor AR for this project. One plan can have multiple payment trenches. Enter each trench’s buyer payment % — together they must equal this project’s Exchange % (30.0% from BMS). AR from vendor is entered per trench (not calculated). Full commission is whatever the vendor deal is (not fixed at 11%). Apply to all available units or pick specific available units from this project’s inventory. A plan that has already started cannot be edited — set an End Date first; a new overlapping plan can start the day after.

Payment Trenches

Buyer Paid Up To (%) is the cumulative share the client has paid at that trench (not an installment to add up). Example for Exchange 30.0%: 15 then 30 — the final trench must be 30.0%. AR from vendor values do add up to Full Commission.

Trench Buyer Paid Up To (%) SPA Signed AR From Vendor (%)
Units

Receivable Plans

Loading…

Day-to-day (after setup)

  1. Released / Not released: open Price Matrix → unit drawer → Set released / Set not released.
  2. Sold path: complete the sale in Operations · Booking (reserved → exchanged / complete). Do not re-upload Setup Excel for each sale.
  3. Change one unit’s list / promo / Price 100: Price Matrix → unit drawer → Edit prices.
  4. Bulk price revision: re-upload Unit Status (and Price Control if needed) as a deliberate event, then download live inventory to confirm.
  5. Download current inventory: Price Matrix → Download live inventory (includes Lab overrides, Ops locks, and Sales Toolkit holds). Setup Excel download is the archive only.