Business Management System

← Project Management PM tool
Notes

No notes for this page.

Nue Riverest Ratburana

Bangkok · Ready

Nue Riverest Ratburana — new project workspace. Activate, then gather materials in Project Management.

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/nrv/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: Setup_Unit_Info (8)_2026-08-27.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: Setup_Price_Control (5).xlsx · 2026-08-24 · 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: Setup_Unit_Status_Selling_Price (1)_2026-08-24.xlsx · 2026-08-26 · 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
1515Total units
429Available
1086Unavailable
32Floors
57Stack codes
1511Matrix cells

By unit nature

  • Agency1515

By unit type

  • 1 Bedroom542
  • 1 Bedroom Plus424
  • Studio399
  • 2 Bedroom139
  • 3 Bedroom7
  • SHOP4

Stack codes

A01 A02 A03 A04 A05 A06 S07 S08 B09 B03 B04 S05 S06 B01 B02 B05

Sample: NRV 3A01, NRV 3A02, NRV 3A03, NRV 3A04, NRV 3A05, NRV 3A06, NRV 3S07, NRV 3S08, NRV 3B09, NRV 4A01, NRV 4A02, NRV 4A03…

Matrix preview

Floor North West North West North West North West North West North West North-East North-East North-East Col 11 North West North West North West North West North-East North-East North-East Col 19 North West North West North West North West North-East North-East North-East Col 27 North West North West North West North West North West North-East North-East North-East North-East North-East Col 38 North West North West North West North West North West North West North West North West North West North-East North-East North-East North-East North-East North-East North-East North-East Col 56 North West North West North West North West North West North West North West North West North West North West North West North West North-East North-East North-East North-East North-East North-East North-East North-East North-East North-East North-East North-East North-East North-East North-East Col 84 North West North West North West North-East North-East North-East Col 91 North West North West North-East North-East
34 B34A02 B34B03 B34B04 B34S05 C34B01 C34B02
33 B33A01 B33A02 B33B03 B33B04 B33S05 B33S06 B33S07 C33B01 C33B02 C33A03 C33S06 C33S07 H33B01 H33B03
32 B32A01 B32A02 B32B03 B32B04 B32S05 B32S06 B32S07 C32B01 C32B02 C32A03 C32A04 C32S05 C32S06 C32S07 H32B01 H32B03
31 A31A05 A31A06 B31A01 B31A02 B31B03 B31B04 B31S05 B31S06 B31S07 C31B01 C31B02 C31A03 C31A04 C31S05 C31S06 C31S07 G31A02 G31A03 G31A04 G31A05 H31B01 H31B03
30 A30A05 A30A06 B30A01 B30A02 B30B03 B30B04 B30S05 B30S06 B30S07 C30B01 C30B02 C30A03 C30A04 C30S05 C30S06 C30S07 G30A02 G30A03 G30A04 G30A05 H30B01 H30B03
29 A29A03 A29A04 A29A05 A29A06 A29B07 B29A01 B29A02 B29B03 B29B04 B29S05 B29S06 B29S07 C29B01 C29B02 C29A03 C29A04 C29S05 C29S06 C29S07 G29A01 G29A02 G29A03 G29A04 G29A05 G29A06 H29B01 H29B03
… … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … …
5 A5A01 A5A02 A5A03 A5A04 A5A05 A5A06 A5S07 A5S08 A5B09 B5A01 B5A02 B5B03 B5B04 B5S05 B5S06 B5S07 C5B01 C5B02 C5A03 C5A04 C5S05 C5S06 C5S07 D5B01 D5B02 D5B03 D5B04 D5B05 D5S06 D5S07 D5S08 D5S09 D5S10 E5B01 E5B02 E5B03 E5B04 E5B05 E5B06 E5B07 E5B08 E5B09 E5S10 E5S11 E5S12 E5S12X E5S14 E5S15 E5S16 E5S17 F5A02 F5A03 F5A05 F5A06 F5A07 F5A08 F5A09 F5A10 F5A11 F5B12 F5B12X F5B14 F5A15 F5A16 F5A17 F5A18 F5A19 F5A20 F5A21 F5A22 F5A23 F5A24 F5A25 G5A01 G5B02 G5A03 G5A04 G5B05 G5A06 H5B01 H5B02 H5B03 H5B04
4 A4A01 A4A02 A4A03 A4A04 A4A05 A4A06 A4S07 A4S08 A4B09 B4A01 B4A02 B4B03 B4B04 B4S05 B4S06 B4S07 C4B01 C4B02 C4A03 C4A04 C4S05 C4S06 C4S07 D4B01 D4B02 D4B03 D4B04 D4B05 D4S06 D4S07 D4S08 D4S09 D4S10 E4B01 E4B02 E4B03 E4B04 E4B05 E4B06 E4B07 E4B08 E4B09 E4S10 E4S11 E4S12 E4S12X E4S14 E4S15 E4S16 E4S17 F4A01 F4A02 F4A05 F4A06 F4A07 F4A08 F4A09 F4A10 F4A11 F4B12 F4B12X F4B14 F4A15 F4A16 F4A17 F4A18 F4A19 F4A20 F4A21 F4A22 F4A23 F4A24 F4A25 F4A26 F4A27 G4A01 G4B02 G4A03 G4A04 G4B05 G4A06 H4B01 H4B02 H4B03 H4B04
3 A3A01 A3A02 A3A03 A3A04 A3A05 A3A06 A3S07 A3S08 A3B09 B3A01 B3A02 B3B03 B3B04 B3S05 B3S06 B3S07 C3B01 C3B02 C3A03 C3A04 C3S05 C3S06 C3S07 D3B02 D3B03 D3B04 D3B05 D3S06 D3S07 D3S08 D3S09 D3S09 E3B01 E3B02 E3B03 E3B04 E3B05 E3B06 E3B07 E3B08 E3B09 E3S10 E3S11 E3S12 E3S12X E3S14 E3S15 E3S16 E3S17 F3A01 F3A02 F3A03 F3A04 F3A05 F3A06 F3A07 F3A08 F3A09 F3A10 F3A11 F3B12 F3B12X F3B14 F3A15 F3A16 F3A17 F3A18 F3A19 F3A20 F3A21 F3A22 F3A23 F3A24 F3A25 F3A26 F3A27 G3A01 G3B02 G3A03 G3A04 G3B05 G3A06 H3B01 H3B02 H3B03 H3B04

Generated 2026-09-10 01:54:13 UTC · from Setup_Unit_Info (8)_2026-08-27.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.