Diversity grouped from RERA project_type. Sell-through, completion %, delays and upcoming handovers
derived from total_units, units_sold, completion_percent,
proposed_completion & actual_completion across all merged promoter entities.
| Project | RERA Reg | Status | District | Area | Map | Website |
|---|---|---|---|---|---|---|
| CHANDRA SPHINX | PCGRERA150618000186 |
Ongoing | Raipur | - | Map | - |
| CHANDRA SQUARE | PCGRERA150618000189 |
Ongoing | Raipur | - | Map | - |
| # | Complaint No. | Applicant | Section | Date | |
|---|---|---|---|---|---|
| 1 | M-COM-2024-02402 | CG-RERA | - | 26 Jul 2024 | |
| 2 | M-COM-2024-02403 | CG-RERA | - | 12 Jul 2024 | |
| 3 | SM-EXP-2024-02267 | CG-RERA | - | 29 Apr 2024 | |
| 4 | SM-EXP-2024-02266 | CG-RERA | - | 29 Apr 2024 | |
| 5 | M-COM-2023-02077 | CG-RERA | Section 63 | 06 Mar 2024 | |
| 6 | M-COM-2023-02076 | CG-RERA | Section 63 | 06 Mar 2024 |
| Factor | How it's calculated | Raw Value | Score (0-100) | Weight | Weighted |
|---|---|---|---|---|---|
| Builder-Level RERA Compliance Score | 2 project(s): 2 Partial(50) | 50/100 |
50
|
60% | 30.0 |
| Orders & Violations | 2 order(s) under 1 distinct RERA section(s). Score = max(0, 100 - 1 x 4) = 96 | 1 section(s) |
96
|
40% | 38.4 |
| Complaints Filed | 2 complaint(s) total. Only complaints with actual orders affect the score (via "Orders & Violations" factor above). | 2 | Info only — not scored | ||
| Buyer Rating | Average buyer review rating across all projects by this builder. | No reviews | Info only — not scored | ||
| Order Details | |||||
| Weighted Sum / Total Weight | 100% | 68.4 | |||
| Final Normalized Score | 68/100 | ||||
Avg. Completion % = SUM(effective_completion) / COUNT(projects with completion_percent NOT NULL)
completion_percent = 100
while their registration_status is still Ongoing / New and no
actual_completion date is filed. Per RERA, a project is only formally complete when
status = Completed OR actual_completion is set. So we cap such projects at
99% for averaging. Capped rows below are marked
CAPPED.
seemankan1.projects.completion_percent · Excludes projects with NULL completion.
| Project | RERA | Status | Reported | Effective % |
|---|---|---|---|---|
| CHANDRA SPHINX | PCGRERA150618000186 |
Ongoing | 100% | CAPPED 99% |
| CHANDRA SQUARE | PCGRERA150618000189 |
Ongoing | 100% | CAPPED 99% |
| SUM ÷ COUNT | 198 ÷ 2 = 99% | |||
proposed_completion < today (25 Apr 2026)registration_status ≠ Completed AND actual_completion is NULL/emptycompletion_percent is intentionally not used here because RERA developers
self-report 100% even while the project is still Ongoing. Only the formal status / actual completion
date proves the project is closed.
| Project | RERA | Status | Proposed Completion | Completion % | Days Overdue |
|---|---|---|---|---|---|
| CHANDRA SQUARE | PCGRERA150618000189 |
Ongoing | 31 May 2019 | 100% | 2,521 d |
| CHANDRA SPHINX | PCGRERA150618000186 |
Ongoing | 09 Jun 2025 | 100% | 320 d |