1. Unit Info
Sheets: Martix, Sales Condition, Unit Info. Blue cells are manual input. Unit Info rows match Total Number of Units from Project Details. Project Code is prefilled.
Ascendis Property Limited
Ascendis Property Limited — 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/asc/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.
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.
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.
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
Upload Unit Info to generate the matrix.
76Total units
76Available
0Unavailable
31Floors
143Stack codes
76Matrix cells
By unit nature
- Real Asset76
By unit type
- 2 Bed51
- 1 Bed23
- 3 Bed2
Stack codes
ADA0145 ASB0128 BMP0003 BMP0004 BMP0005 BMP0006 BMP0007 BMP0008 ADT0141 ALV0223 ASB0101 BAH0230 BMP0001 BMP0009 BPL0318 BVC0181
Sample: ASC ADA0145, ASC ADT0141, ASC ALV0223, ASC ASB0101, ASC ASB0128, ASC BAH0230, ASC BMP0001, ASC BMP0002, ASC BMP0003, ASC BMP0004, ASC BMP0005, ASC BMP0006…
Matrix preview
| Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 |
|---|---|---|---|---|---|---|---|
| ASC ADA0145 | |||||||
| ASC ADT0141 | |||||||
| ASC ALV0223 | |||||||
| ASC ASB0101 | ASC ASB0128 | ||||||
| ASC BAH0230 | |||||||
| ASC BMP0001 | ASC BMP0002 | ASC BMP0003 | ASC BMP0004 | ASC BMP0005 | ASC BMP0006 | ASC BMP0007 | ASC BMP0008 |
| ASC BMP0009 | ASC BMP0010 | ASC BMP0011 | ASC BMP0012 | ASC BMP0014 | ASC BMP0015 | ASC BMP0016 | ASC BMP0017 |
| ASC BPL0318 | ASC BPL0419 | ||||||
| ASC BVC0181 | |||||||
| ASC BWG0092 | ASC BWG0112 | ||||||
| ASC BWP0038 | ASC BWP0044 | ASC BWP0103 | ASC BWP0119 | ASC BWP0488 | |||
| ASC CLH0130 | ASC CLH0380 | ||||||
| ASC CMS0260 | |||||||
| ASC DEL0040 | ASC DEL0043 | ||||||
| ASC EGH0161 | |||||||
| ASC HOL0742 | |||||||
| ASC LGS0069 | |||||||
| ASC LLA0516 | |||||||
| ASC MET0084 | |||||||
| ASC PGS0378 | |||||||
| ASC RSD0012 | |||||||
| ASC TFS0299 | ASC TFS0480 | ASC TFS0481 | ASC TFS0482 | ||||
| ASC THB0242 | ASC THB0243 | ASC THB0244 | ASC THB0245 | ASC THB0246 | ASC THB0247 | ASC THB0248 | ASC THB0249 |
| ASC THB0250 | ASC THB0251 | ASC THB0252 | ASC THB0311 | ||||
| ASC TLV0634 | |||||||
| ASC TLW0403 | |||||||
| ASC TYL0234 | ASC TYL0235 | ASC TYL0237 | ASC TYL0239 | ASC TYL0240 | ASC TYL0241 | ||
| ASC VLE0122 | ASC VLE0167 | ASC VLN0116 | ASC VLN0135 | ASC VLN0227 | |||
| ASC WOP0445 | |||||||
| ASC WOT0199 | |||||||
| ASC WPW0522 |
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 % (10.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.
Receivable Plans
Loading…
Day-to-day (after setup)
- Released / Not released: open Price Matrix → unit drawer → Set released / Set not released.
- Sold path: complete the sale in Operations · Booking (reserved → exchanged / complete). Do not re-upload Setup Excel for each sale.
- Change one unit’s list / promo / Price 100: Price Matrix → unit drawer → Edit prices.
- Bulk price revision: re-upload Unit Status (and Price Control if needed) as a deliberate event, then download live inventory to confirm.
- Download current inventory: Price Matrix → Download live inventory (includes Lab overrides, Ops locks, and Sales Toolkit holds). Setup Excel download is the archive only.