Business Management System

← Project Management PM tool
Notes

No notes for this page.

Nue Evo Ari

Bangkok · Ready

Nue Evo Ari — 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/nea/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_NEA_2026-08-15.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_NEA.xlsx · 2026-08-05 · 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_NEA.xlsx · 2026-08-05 · 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
488Total units
204Available
284Unavailable
41Floors
14Stack codes
488Matrix cells

By unit nature

  • Agency488

By unit type

  • 2 Bedroom381
  • 1 Bedroom107

Stack codes

A1 A2 B3 B4 B5 B6 B7 A8 B9 B10 B11 B12 B12X B14

Sample: NEA 2A1, NEA 2A2, NEA 2B3, NEA 2B4, NEA 2B5, NEA 2B6, NEA 2B7, NEA 2A8, NEA 2B9, NEA 2B10, NEA 2B11, NEA 2B12…

Matrix preview

Floor North-East North-East North-East North-East South-West South-West South-West South-West North-West North-West North-West North-West South-East South-East
42 NEA 42A8 NEA 42B9 NEA 42B11 NEA 42B12 NEA 42B12X NEA 42B14
41 NEA 41A8 NEA 41B9 NEA 41B10 NEA 41B11 NEA 41B12 NEA 41B12X NEA 41B14
40 NEA 40A8 NEA 40B9 NEA 40B10 NEA 40B11 NEA 40B12 NEA 40B12X NEA 40B14
39 NEA 39A1 NEA 39B7 NEA 39A8 NEA 39B9 NEA 39B10 NEA 39B11 NEA 39B12 NEA 39B12X NEA 39B14
38 NEA 38A1 NEA 38B7 NEA 38A8 NEA 38B9 NEA 38B10 NEA 38B11 NEA 38B12 NEA 38B12X NEA 38B14
37 NEA 37A1 NEA 37B7 NEA 37A8 NEA 37B9 NEA 37B10 NEA 37B11 NEA 37B12 NEA 37B12X NEA 37B14
… … … … … … … … … … … … … … …
4 NEA 4A1 NEA 4A2 NEA 4B3 NEA 4B4 NEA 4B5 NEA 4B6 NEA 4B7 NEA 4A8 NEA 4B9 NEA 4B10 NEA 4B11 NEA 4B12 NEA 4B12X NEA 4B14
3 NEA 3A1 NEA 3A2 NEA 3B3 NEA 3B4 NEA 3B5 NEA 3B6 NEA 3B7 NEA 3A8 NEA 3B9 NEA 3B10 NEA 3B11 NEA 3B12 NEA 3B12X NEA 3B14
2 NEA 2A1 NEA 2A2 NEA 2B3 NEA 2B4 NEA 2B5 NEA 2B6 NEA 2B7 NEA 2A8 NEA 2B9 NEA 2B10 NEA 2B11 NEA 2B12 NEA 2B12X NEA 2B14

Generated 2026-09-08 02:03:30 UTC · from Unitinfo_NEA_2026-08-15.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.