A cleaned text extract from the T1985 archive, shown for source transparency. This is one of the documents T1985 Intelligence draws on. Restricted, financial, and personal material is excluded from public view.
Keturah Ardh Phase 1 - Data Analysis Summary Project Overview • Project Name: Keturah Ardh Phase 1 Final Master Plan (Option 14B) • Development Type: Mixed-use residential development with plot sales and Keturah development • Date: July 1, 2025 Data Sources Analyzed 1. Phase1 MPOption14B LandUseBudget July012025.xlsx • Main Sheet: KA LUB MP Phase 1 Option 14B • Dimensions: 689 rows × 35 columns • Content: Land use budget with plot sales and development phases Key Data Fields Identified: • Master Plan Plot Numbers • Plot Areas (sq.m and sq.ft) • Building Heights • Land Use Classifications (Residential, Commercial, Office/Hospitality) • Total GFA (Gross Floor Area) • Number of Units • FAR (Floor Area Ratio) • Population estimates • Parking requirements • Plot workability assessments 2. Phase1-InventoryofCluster.xlsx • Main Sheet: Inventory data • Dimensions: 687 rows × 25 columns • Content: Detailed property inventory with pricing and specifications Key Data Fields Identified: • Property Master ID • Location Codes and Clusters • Property Types and Room Types • Unit Areas (Services, Circulation, Unit, Balcony, Total) • Plot Areas (sq.m and sq.ft) • Maximum GFA • Built-up Areas • Building Heights • Number of Townhouses • Pricing (per sq.ft and total) • Status and Transaction Types 3. PDF Documents Analysis • KA Phase1FinalMasterPlan Option14B.pdf: Visual master plan (mostly graphical) • KeturahxFAM.pdf: Contains detailed plot schedules with utility demand estimates Key Property Types Identified Townhouses • Naming Convention: Ardh-Th-01-[Cluster]-[Unit] • Examples: Ardh-Th-01-01, Ardh-Th-01-02, Ardh-Th-01-03, etc. • Configurations: Various plot sizes and GFA allocations • Building Heights: Primarily G+2+R (Ground + 2 floors + Roof) • Typical Features: 6-8 units per cluster, 700 AED/sq.ft pricing Plot Categories 1. Phase 1/1 - Plot Sales: For external buyers 2. Phase 1/2 - Keturah Development: For internal development Clusters Identified • Multiple cluster designations (07A, 07B, 07C, 16A, 16B, 16C, etc.) • Varying plot sizes from 142.50 sq.m to 334.45 sq.m • Different configurations and unit counts per cluster Data Quality and Relationships Strengths • Comprehensive property identification system • Detailed area calculations in both metric and imperial units • Clear pricing structure with currency specifications • Building height and unit count specifications • Status tracking for sales and development phases Data Relationships • Plot numbers link to specific clusters and locations • Area calculations show relationships between plot area, GFA, and built-up area • Pricing correlates with unit types and locations • Building specifications align with zoning requirements Recommended XLSX Structure Based on the analysis, the comprehensive XLSX should include: 1. Master Property Register - All properties with unique identifiers 2. Plot Details - Area specifications, GFA, FAR calculations 3. Building Specifications - Heights, unit counts, configurations 4. Pricing & Sales - Current pricing, status, transaction details 5. Cluster Analysis - Groupings and development phases 6. Utility & Infrastructure - Demand estimates and requirements 7. Summary Dashboard - Key metrics and totals Next Steps 1. Structure the unified XLSX with appropriate sheets and relationships 2. Implement data validation and calculation formulas 3. Apply consistent formatting and styling 4. Include summary statistics and dashboards