Business Management System

← Project Management PM tool
Notes

No notes for this page.

Nue Noble Srinakarin - Lasalle

Bangkok · Ready

Nue Noble Srinakarin - Lasalle — 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/nsl/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 SRI_2026-08-25 (3)_2026-08-25 (1)_2026-08-26.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 (3).xlsx · 2026-08-25 · 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 (4).xlsx · 2026-08-25 · 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.

1019Total units
99Available
920Unavailable
36Floors
37Stack codes
1019Matrix cells

By unit nature

  • Agency1019

By unit type

  • 1 Bed387
  • 1 Bed Plus350
  • 2 Bed175
  • Studio102
  • Shop5

Stack codes

A1 A2 A3 B4 B5 A6 A7 A8 A9 A10 A11 A12 A12X B14 B15 A16

Sample: NSL 9A1, NSL 9A2, NSL 9A3, NSL 9B4, NSL 9B5, NSL 9A6, NSL 9A7, NSL 9A8, NSL 9A9, NSL 9A10, NSL 9A11, NSL 9A12…

Matrix preview

Floor South South South South North North North North North North North North North North South South East East East East East East West West West West West West West
43 43A1 43A2 43A3 43B4 43B5 43A6 43A7 43A8 43A9 43A10 43A11 43A12 43A12X 43B14 43B15 43A16 43S18 43A19 43A20 43A21 43B22 43A23 43A24 43A25 43A26 43A27 43A28 43A29
42 42A1 42A2 42A3 42B4 42B5 42A6 42A7 42A8 42A9 42A10 42A11 42A12 42A12X 42B14 42B15 42A16 42S17 42S18 42A19 42A20 42A21 42B22 42A23 42A24 42A25 42A26 42A27 42A28 42A29
41 41A1 41A2 41A3 41B4 41B5 41A6 41A7 41A8 41A9 41A10 41A11 41A12 41A12X 41B14 41B15 41A16 41S17 41S18 41A19 41A20 41A21 41B22 41A23 41A24 41A25 41A26 41A27 41A28 41A29
40 40A1 40A2 40A3 40B4 40B5 40A6 40A7 40A8 40A9 40A10 40A11 40A12 40A12X 40B14 40B15 40A16 40S17 40S18 40A19 40A20 40A21 40B22 40A23 40A24 40A25 40A26 40A27 40A28 40A29
39 39A1 39A2 39A3 39B4 39B5 39A6 39A7 39A8 39A9 39A10 39A11 39A12 39A12X 39B14 39B15 39A16 39S17 39S18 39A19 39A20 39A21 39B22 39A23 39A24 39A25 39A26 39A27 39A28 39A29
38 38A1 38A2 38A3 38B4 38B5 38A6 38A7 38A8 38A9 38A10 38A11 38A12 38A12X 38B14 38B15 38A16 38S17 38S18 38A19 38A20 38A21 38B22 38A23 38A24 38A25 38A26 38A27 38A28 38A29
10 10A1 10A2 10A3 10B4 10B5 10A6 10A7 10A8 10A9 10A10 10A11 10A12 10A12X 10B14 10B15 10A16 10S17 10S18 10S19 10S20 10S21 10B22 10A23 10A24 10A25 10A26 10A27 10A28 10A29
9 9A1 9A2 9A3 9B4 9B5 9A6 9A7 9A8 9A9 9A10 9A11 9A12 9A12X 9B14 9B15 9A16 9S17 9S18 9S19 9S20 9S21 9B22 9A23 9A24 9A25 9A26 9A27 9A28 9A29
SHOP SHOPP1 SHOPP2 SHOPP3 SHOPP4 SHOPP5

Generated 2026-09-10 01:55:20 UTC · from Setup_Unit_Info SRI_2026-08-25 (3)_2026-08-25 (1)_2026-08-26.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.