--- Sheet: Projects ---
Project_ID Project_Name Client_Name Contract_Value_AED Planned_Cost_AED Project_Start_Date Project_End_Date Project_Type Project_Status Current_Phase KD-2024-001 Dubai Marina Mixed-Use Tower Emaar Properties 45000000 36000000 2024-01-15 2025-12-15 Mixed-Use In Progress Design Development KD-2024-002 Jumeirah Hospitality Resort Jumeirah Group 28000000 22400000 2024-03-01 2025-08-01 Hospitality In Progress Construction Documentation KD-2024-003 DIFC Office Complex Phase 2 DIFC Authority 35000000 28000000 2024-02-01 2025-10-01 Office Planning Concept Design KD-2024-004 Abu Dhabi Residential Master Plan Aldar Properties 52000000 41600000 2024-04-01 2026-03-01 Residential In Progress Schematic Design KD-2024-005 Sharjah Cultural Museum Sharjah Investment Authority 18000000 14400000 2024-05-15 2025-11-15 Cultural Design Phase Design Development
--- Sheet: Employees ---
Employee_ID Employee_Name Department Role Hourly_Rate_AED Employment_Type Start_Date Cost_Category EMP-001 Employee 1 Architecture Project Manager 350 Full-Time 2023-04-24 Architecture EMP-002 Employee 2 Architecture Senior Architect 850 Full-Time 2023-09-18 Architecture EMP-003 Employee 3 Architecture BIM Coordinator 400 Full-Time 2023-05-24 Architecture EMP-004 Employee 4 Architecture Design Principal 850 Full-Time 2023-10-14 Architecture EMP-005 Employee 5 Architecture Design Principal 300 Full-Time 2023-10-13 Architecture EMP-006 Employee 6 Architecture Junior Architect 200 Full-Time 2023-06-08 Architecture EMP-007 Employee 7 Architecture Project Manager 150 Full-Time 2023-03-17 Project Management EMP-008 Employee 8 Architecture Interior Designer 300 Full-Time 2023-08-03 Project Management EMP-009 Employee 9 Architecture Project Manager 350 Full-Time 2023-01-28 Architecture EMP-010 Employee 10 Architecture Structural Engineer 200 Full-Time 2023-02-05 Architecture EMP-011 Employee 11 Architecture Project Coordinator 300 Full-Time 2023-11-06 Project Management EMP-012 Employee 12 Architecture Senior Architect 200 Full-Time 2023-11-14 Project Management EMP-013 Employee 13 Architecture Senior Architect 500 Full-Time 2023-10-03 Architecture EMP-014 Employee 14 Architecture Project Manager 350 Full-Time 2023-07-13 Project Management EMP-015 Employee 15 Architecture Design Principal 600 Full-Time 2023-10-15 Architecture EMP-016 Employee 16 Architecture Design Principal 400 Full-Time 2023-09-09 Architecture
EMP-041 Employee 41 Project Management Senior Associate 300 Full-Time 2023-10-03 Architecture
EMP-042 Employee 42 Project Management Structural Engineer 850 Full-Time 2023-02-24 Architecture
EMP-043 Employee 43 Project Management BIM Coordinator 400 Full-Time 2023-08-27 Architecture
EMP-044 Employee 44 Project Management Senior Architect 300 Full-Time 2023-02-25 Architecture
EMP-045 Employee 45 Project Management Urban Designer 600 Full-Time 2023-09-25 Architecture
EMP-046 Employee 46 Project Management Interior Designer 500 Contract 2023-03-05 Architecture
EMP-047 Employee 47 Project Management Project Manager 600 Contract 2023-11-16 Project Management
EMP-048 Employee 48 Project Management Project Coordinator 250 Contract 2023-09-06 Architecture
EMP-049 Employee 49 Project Management Project Manager 350 Contract 2023-05-17 Project Management
EMP-050 Employee 50 Project Management Interior Designer 250 Contract 2023-10-14 Project Management
--- Sheet: Timesheets ---
Record_ID Date Employee_ID Project_ID Hours_Worked Work_Category Task_Description Billable_Hours TS-000001 2024-04-07 EMP-007 KD-2024-001 9.27 Project Management Documentation 8.18 TS-000002 2024-01-28 EMP-044 KD-2024-001 4.48 Subcontractor Site Visits 4.30 TS-000003 2024-02-25 EMP-016 KD-2024-002 5.52 Project Management Client Presentations 4.88 TS-000004 2024-05-22 EMP-030 KD-2024-002 11.00 Architecture BIM Modeling 10.58 TS-000005 2024-02-20 EMP-004 KD-2024-005 10.69 Architecture Design Reviews 8.91 TS-000006 2024-09-05 EMP-031 KD-2024-002 10.92 Architecture Client Presentations 9.56 TS-000007 2024-07-18 EMP-017 KD-2024-004 6.28 Subcontractor Permit Applications 5.86 TS-000008 2024-09-06 EMP-010 KD-2024-002 6.37 Architecture Project Planning 6.03 TS-000009 2024-02-01 EMP-048 KD-2024-003 4.46 Subcontractor BIM Modeling 4.02 TS-000010 2024-09-28 EMP-011 KD-2024-001 11.69 Architecture Client Presentations 9.51 TS-000011 2024-02-04 EMP-044 KD-2024-002 7.23 Subcontractor Design Reviews 6.62 TS-000012 2024-01-21 EMP-040 KD-2024-001 7.35 Subcontractor Project Planning 6.65 TS-000013 2024-05-13 EMP-014 KD-2024-003 5.91 Project Management Client Presentations 5.52 TS-000014 2024-06-02 EMP-030 KD-2024-003 11.43 Architecture Concept Design Development 10.19 TS-000015 2024-02-21 EMP-005 KD-2024-005 5.71 Project Management Client Presentations 5.63 TS-000016 2024-02-05 EMP-016 KD-2024-003 6.28 Project Management Permit Applications 5.91 TS-000017 2024-09-27 EMP-001 KD-2024-005 6.40 Subcontractor Technical Drawings 6.32 TS-000018 2024-03-09 EMP-017 KD-2024-001 11.12 Subcontractor Permit Applications 9.24 TS-000019 2024-05-24 EMP-039 KD-2024-002 9.74 Architecture Coordination Meetings 8.78 TS-000020 2024-05-08 EMP-004 KD-2024-001 9.07 Project Management Concept Design Development 7.26 TS-000021 2024-03-07 EMP-041 KD-2024-003 5.29 Project Management Permit Applications 4.98 TS-000022 2024-01-05 EMP-008 KD-2024-001 11.56 Subcontractor Client Presentations 10.51 TS-000023 2024-07-08 EMP-038 KD-2024-005 5.18 Architecture Concept Design Development 4.46 TS-000024 2024-01-21 EMP-023 KD-2024-002 9.46 Subcontractor Technical Drawings 8.24 TS-000025 2024-07-27 EMP-040 KD-2024-002 11.41 Architecture Client Presentations 11.36 TS-000026 2024-03-31 EMP-027 KD-2024-001 5.43 Project Management Documentation 5.22 TS-000027 2024-05-07 EMP-018 KD-2024-002 10.30 Architecture Documentation 10.04 TS-000028 2024-08-28 EMP-015 KD-2024-002 10.53 Project Management Site Visits 9.07 TS-000029 2024-04-26 EMP-015 KD-2024-001 9.28 Project Management Site Visits 7.94 TS-000030 2024-02-05 EMP-050 KD-2024-003 6.81 Subcontractor Documentation 6.37 TS-000031 2024-06-18 EMP-002 KD-2024-001 11.02 Project Management Client Presentations 10.10 TS-000032 2024-05-15 EMP-003 KD-2024-001 8.77 Project Management Site Visits 7.78 TS-000033 2024-09-18 EMP-008 KD-2024-004 11.20 Architecture Coordination Meetings 9.06 TS-000034 2024-08-11 EMP-001 KD-2024-005 11.40 Subcontractor Design Reviews 9.95 TS-000035 2024-02-05 EMP-043 KD-2024-003 8.99 Subcontractor Technical Drawings 8.49 TS-000036 2024-06-02 EMP-033 KD-2024-003 9.34 Project Management Documentation 8.77 TS-000037 2024-03-06 EMP-013 KD-2024-004 9.32 Project Management Client Presentations 8.60 TS-000038 2024-06-03 EMP-026 KD-2024-005 10.67 Project Management Coordination Meetings 8.98 TS-000039 2024-06-13 EMP-030 KD-2024-004 7.54 Architecture Permit Applications 6.75 TS-000040 2024-03-27 EMP-043 KD-2024-001 6.27 Subcontractor Project Planning 5.44 TS-000041 2024-04-30 EMP-044 KD-2024-003 5.80 Architecture Client Presentations 4.67 TS-000042 2024-05-05 EMP-031 KD-2024-005 10.80 Architecture BIM Modeling 9.54 TS-000043 2024-04-09 EMP-046 KD-2024-004 7.96 Architecture Client Presentations 7.41 TS-000044 2024-01-03 EMP-049 KD-2024-001 10.23 Architecture Client Presentations 9.83 TS-000045 2024-09-22 EMP-030 KD-2024-001 8.46 Architecture BIM Modeling 6.99 TS-000046 2024-08-25 EMP-043 KD-2024-005 11.90 Subcontractor Site Visits 11.78 TS-000047 2024-08-14 EMP-040 KD-2024-005 7.41 Subcontractor BIM Modeling 7.26 TS-000048 2024-08-31 EMP-029 KD-2024-003 10.01 Subcontractor Coordination Meetings 9.54 TS-000049 2024-09-23 EMP-032 KD-2024-002 6.20 Architecture Coordination Meetings 5.25 TS-000050 2024-06-20 EMP-021 KD-2024-005 4.64 Architecture Design Reviews 4.07 TS-000051 2024-03-19 EMP-046 KD-2024-002 4.51 Project Management Site Visits 4.10 TS-000052 2024-07-31 EMP-004 KD-2024-002 10.66 Project Management Project Planning 10.55 TS-000053 2024-01-11 EMP-049 KD-2024-005 7.04 Architecture Site Visits 6.05 TS-000054 2024-07-18 EMP-027 KD-2024-005 9.98 Subcontractor Project Planning 9.78 TS-000055 2024-09-06 EMP-015 KD-2024-003 7.49 Architecture Documentation 6.50 TS-000056 2024-07-26 EMP-047 KD-2024-002 10.72 Architecture Project Planning 9.72 TS-000057 2024-07-20 EMP-038 KD-2024-005 9.30 Architecture Documentation 7.69 TS-000058 2024-08-24 EMP-012 KD-2024-001 6.08 Project Management Design Reviews 5.42 TS-000059 2024-06-21 EMP-049 KD-2024-004 6.23 Project Management Coordination Meetings 6.02 TS-000060 2024-08-28 EMP-002 KD-2024-005 4.42 Project Management Design Reviews 4.11 TS-000061 2024-01-21 EMP-049 KD-2024-001 11.60 Architecture Concept Design Development 10.72 TS-000062 2024-05-02 EMP-009 KD-2024-004 9.36 Subcontractor Design Reviews 8.36 TS-000063 2024-05-11 EMP-050 KD-2024-003 5.34 Subcontractor Technical Drawings 5.10 TS-000064 2024-03-24 EMP-020 KD-2024-001 8.63 Project Management Project Planning 8.07 TS-000065 2024-07-11 EMP-026 KD-2024-002 4.61 Subcontractor Design Reviews 3.78 TS-000066 2024-06-03 EMP-044 KD-2024-005 10.44 Subcontractor Concept Design Development 9.08 TS-000067 2024-08-07 EMP-043 KD-2024-003 4.55 Subcontractor Site Visits 3.65 TS-000068 2024-08-03 EMP-032 KD-2024-001 7.47 Project Management BIM Modeling 7.03 TS-000069 2024-08-10 EMP-012 KD-2024-005 11.72 Project Management Project Planning 11.27 TS-000070 2024-09-04 EMP-030 KD-2024-004 10.61 Subcontractor Coordination Meetings 9.17 TS-000071 2024-05-05 EMP-006 KD-2024-003 11.05 Architecture BIM Modeling 10.10 TS-000072 2024-07-13 EMP-022 KD-2024-001 7.95 Project Management Client Presentations 7.14 TS-000073 2024-06-30 EMP-017 KD-2024-003 6.24 Subcontractor Coordination Meetings 5.69 TS-000074 2024-09-21 EMP-013 KD-2024-001 5.93 Project Management BIM Modeling 5.40 TS-000075 2024-05-03 EMP-045 KD-2024-004 9.17 Project Management BIM Modeling 8.79
--- Sheet: Milestones ---
Project_ID Milestone_Name Milestone_Order Planned_Date Actual_Date Status Completion_Percentage KD-2024-001 Concept Design Approval 1 2024-01-12 NaN Completed 76 KD-2024-001 Schematic Design Completion 2 2024-02-17 2024-02-17 Completed 0 KD-2024-001 Design Development Approval 3 2024-03-27 NaN In Progress 0 KD-2024-001 Construction Documentation 4 2024-04-09 NaN Completed 0 KD-2024-001 Permit Submission 5 2024-05-13 2024-05-07 Completed 100 KD-2024-001 Permit Approval 6 2024-06-17 NaN In Progress 0 KD-2024-001 Construction Start 7 2024-07-20 NaN Pending 0 KD-2024-001 Structural Completion 8 2024-08-08 NaN In Progress 79 KD-2024-001 MEP Installation 9 2024-09-25 NaN Completed 0 KD-2024-001 Final Completion 10 2024-10-16 2024-10-28 Completed 0 KD-2024-002 Concept Design Approval 1 2024-01-18 NaN Completed 0 KD-2024-002 Schematic Design Completion 2 2024-02-18 NaN In Progress 29 KD-2024-002 Design Development Approval 3 2024-03-14 NaN In Progress 0 KD-2024-002 Construction Documentation 4 2024-04-22 2024-05-01 Completed 0 KD-2024-002 Permit Submission 5 2024-05-15 NaN Pending 0 KD-2024-002 Permit Approval 6 2024-06-24 NaN Completed 8 KD-2024-002 Construction Start 7 2024-07-17 NaN Completed 22 KD-2024-002 Structural Completion 8 2024-08-13 2024-08-31 Completed 4 KD-2024-002 MEP Installation 9 2024-09-20 NaN Pending 35 KD-2024-002 Final Completion 10 2024-10-17 NaN Pending 0 KD-2024-003 Concept Design Approval 1 2024-01-30 2024-02-18 Pending 30 KD-2024-003 Schematic Design Completion 2 2024-02-20 NaN Completed 0 KD-2024-003 Design Development Approval 3 2024-03-28 NaN In Progress 33 KD-2024-003 Construction Documentation 4 2024-04-11 2024-04-10 In Progress 20 KD-2024-003 Permit Submission 5 2024-05-27 2024-06-10 Completed 86 KD-2024-003 Permit Approval 6 2024-06-14 NaN Pending 99 KD-2024-003 Construction Start 7 2024-07-08 2024-07-13 Pending 76 KD-2024-003 Structural Completion 8 2024-08-07 NaN Pending 0 KD-2024-003 MEP Installation 9 2024-09-26 NaN In Progress 0 KD-2024-003 Final Completion 10 2024-10-20 2024-10-18 In Progress 0
--- Sheet: Invoices ---
Invoice_ID Project_ID Invoice_Date Invoice_Amount_AED Due_Date Payment_Date Payment_Status Days_Outstanding Milestone_Reference INV-001-001 KD-2024-001 2024-01-25 669473 2024-02-24 NaN Outstanding 40 Design Development INV-001-002 KD-2024-001 2024-02-25 1830640 2024-03-26 2024-03-21 Outstanding 17 Design Development INV-001-003 KD-2024-001 2024-04-24 2122235 2024-05-24 2024-06-24 Paid 31 Concept Design INV-002-001 KD-2024-002 2024-01-20 1409558 2024-02-19 NaN Outstanding 27 Final Completion INV-002-002 KD-2024-002 2024-02-27 509791 2024-03-28 2024-04-26 Paid 46 Construction Documentation INV-002-003 KD-2024-002 2024-04-30 529521 2024-05-30 NaN Overdue 12 Concept Design INV-003-001 KD-2024-003 2024-01-21 2038477 2024-02-20 2024-02-29 Overdue 56 Construction Documentation INV-003-002 KD-2024-003 2024-02-24 770387 2024-03-25 2024-04-13 Overdue 37 Construction Documentation INV-004-001 KD-2024-004 2024-01-03 2227725 2024-02-02 2024-02-16 Outstanding 29 Construction Documentation INV-004-002 KD-2024-004 2024-02-28 2362216 2024-03-29 2024-04-14 Outstanding 22 Design Development INV-004-003 KD-2024-004 2024-04-05 2488276 2024-05-05 NaN Paid 14 Design Development INV-005-001 KD-2024-005 2024-01-07 2039470 2024-02-06 2024-03-09 Overdue 10 Concept Design INV-005-002 KD-2024-005 2024-02-26 1991305 2024-03-27 2024-04-15 Overdue 16 Concept Design INV-005-003 KD-2024-005 2024-04-19 600580 2024-05-19 2024-06-24 Paid 3 Concept Design
--- Sheet: Subcontractors ---
Project_ID Subcontractor_Name Service_Type Contract_Amount_AED Amount_Invoiced_AED Payment_Status Work_Category KD-2024-001 UAE Fire Safety Systems Fire Safety 179598 573867 Paid Subcontractor KD-2024-001 UAE Fire Safety Systems Acoustics 210565 215477 Outstanding Subcontractor KD-2024-001 Acoustic Engineering Partners Acoustics 59756 315743 Paid Subcontractor KD-2024-001 Acoustic Engineering Partners Structural Engineering 744663 545583 Paid Subcontractor KD-2024-001 Sustainability Consultants MENA Sustainability 784764 143826 Paid Subcontractor KD-2024-001 Transportation Planning Group Structural Engineering 586435 123453 Paid Subcontractor KD-2024-002 Transportation Planning Group Structural Engineering 571917 208296 Outstanding Subcontractor KD-2024-002 Gulf MEP Consultants Landscape 598558 211469 Paid Subcontractor KD-2024-002 Acoustic Engineering Partners Fire Safety 359698 168163 Pending Subcontractor KD-2024-003 UAE Fire Safety Systems MEP Design 771634 504012 Paid Subcontractor KD-2024-003 Gulf MEP Consultants Structural Engineering 63368 93326 Pending Subcontractor KD-2024-003 Transportation Planning Group Sustainability 751520 518105 Pending Subcontractor KD-2024-003 Dubai Structural Engineering LLC Sustainability 128693 106210 Paid Subcontractor KD-2024-003 Acoustic Engineering Partners MEP Design 528938 310401 Paid Subcontractor KD-2024-003 UAE Fire Safety Systems Structural Engineering 154657 183188 Pending Subcontractor KD-2024-003 Transportation Planning Group Landscape 427712 327897 Paid Subcontractor KD-2024-004 Dubai Structural Engineering LLC Structural Engineering 98118 10142 Pending Subcontractor KD-2024-004 Acoustic Engineering Partners Acoustics 228795 344625 Paid Subcontractor KD-2024-004 UAE Fire Safety Systems Sustainability 331342 97466 Paid Subcontractor KD-2024-004 Transportation Planning Group Landscape 241752 119361 Paid Subcontractor KD-2024-004 UAE Fire Safety Systems Fire Safety 335037 404452 Outstanding Subcontractor KD-2024-004 Transportation Planning Group Fire Safety 492226 174880 Pending Subcontractor KD-2024-004 Gulf MEP Consultants Acoustics 111495 167138 Pending Subcontractor KD-2024-004 UAE Fire Safety Systems Sustainability 556121 596580 Outstanding Subcontractor KD-2024-005 Gulf MEP Consultants Sustainability 448197 376018 Outstanding Subcontractor KD-2024-005 Dubai Structural Engineering LLC Acoustics 187002 506545 Paid Subcontractor KD-2024-005 Dubai Structural Engineering LLC Fire Safety 512094 48205 Pending Subcontractor KD-2024-005 Emirates Landscape Design Acoustics 379502 12960 Outstanding Subcontractor KD-2024-005 Transportation Planning Group Acoustics 600311 592458 Pending Subcontractor KD-2024-005 Acoustic Engineering Partners Landscape 594315 548513 Outstanding Subcontractor
--- Sheet: Data_Instructions ---
Sheet_Name Description Key_Fields Update_Frequency
Projects Master list of all projects with contract values, planned costs, dates and project details Project_ID (unique), Contract_Value_AED, Planned_Cost_AED, Project_Type Monthly or when new projects are added
Employees Complete employee database with roles, rates, and cost categories for accurate costing Employee_ID (unique), Hourly_Rate_AED, Cost_Category, Role When new employees join or rates change
Timesheets Daily time tracking entries by employees on projects - core data for actual cost calculations Employee_ID, Project_ID, Hours_Worked, Work_Category, Date Daily - core operational data
Milestones Project milestone tracking with planned vs actual dates for timeline analysis Project_ID, Milestone_Name, Planned_Date, Actual_Date, Status Weekly as milestones are achieved
Invoices Invoice register for tracking billing, payments, and outstanding amounts per project Project_ID, Invoice_Amount_AED, Payment_Status, Days_Outstanding Monthly or when invoices are sent/paid
Subcontractors External consultant and subcontractor costs by project for complete cost tracking Project_ID, Service_Type, Contract_Amount_AED, Work_Category When subcontractor agreements are signed
--- Sheet: milestone_budgets ---
Project_ID Milestone_Name Milestone_Order Planned_Date Actual_Date Status Budgeted_Hours Budgeted_Cost_AED Actual_Hours Actual_Cost_AED Cumulative_Budgeted_Hours Cumulative_Budgeted_Cost_AED Cumulative_Actual_Hours Cumulative_Actual_Cost_AED Hours_Variance Cost_Variance_AED Schedule_Variance_Days Budget_Utilization_Percent Architecture_Hours Architecture_Cost_AED PM_Hours PM_Cost_AED Subcontractor_Hours Subcontractor_Cost_AED Notes KD-2024-001 Concept Design Approval 1 2024-01-12 2024-01-12 Completed 120 72000 125 75000 120 72000 125 75000 5 3000 0 104.17 80 45000 25 18000 15 9000 Initial design phase completed on schedule KD-2024-001 Schematic Design Completion 2 2024-02-17 2024-02-17 Completed 200 135000 215 147500 320 207000 340 222500 15 12500 0 107.49 140 105000 40 22500 35 20000 Additional revisions required KD-2024-001 Design Development Approval 3 2024-03-27 NaT In Progress 180 108000 95 67500 500 315000 435 290000 -85 -40500 0 92.06 120 50000 30 12500 25 5000 Ahead of schedule under budget KD-2024-002 Concept Design Approval 1 2024-01-18 2024-01-18 Completed 80 48000 78 46800 80 48000 78 46800 -2 -1200 0 97.50 60 36000 15 9000 5 1800 Efficient design phase KD-2024-002 Schematic Design Completion 2 2024-02-18 NaT In Progress 150 90000 85 51000 230 138000 163 97800 -65 -40200 0 70.87 100 60000 30 18000 20 12000 Good progress on schematics
--- Sheet: staff_allocation ---
Project_ID Milestone_ID Milestone_Name Employee_ID Employee_Name Role Category Hours_Allocated Hours_Worked Hourly_Rate_AED Cost_AED Utilization_Percent Skill_Match_Score Availability_Status Start_Date End_Date Performance_Rating Notes KD-2024-001 ms_1 Concept Design Approval EMP-001 Employee 1 Project Manager Architecture 80 85 350 29750 106.25 95 AVAILABLE 2024-01-05 2024-01-15 EXCELLENT Led design team effectively KD-2024-001 ms_1 Concept Design Approval EMP-002 Employee 2 Senior Architect Architecture 40 45 850 38250 112.50 98 BUSY 2024-01-05 2024-01-15 EXCELLENT Quality architectural work KD-2024-001 ms_2 Schematic Design Completion EMP-002 Employee 2 Senior Architect Architecture 140 150 850 127500 107.14 98 AVAILABLE 2024-02-01 2024-02-20 EXCELLENT Strong schematic development KD-2024-001 ms_2 Schematic Design Completion EMP-003 Employee 3 BIM Coordinator Architecture 60 65 400 26000 108.33 92 AVAILABLE 2024-02-01 2024-02-20 GOOD BIM coordination support KD-2024-002 ms_1 Concept Design Approval EMP-004 Employee 4 Design Principal Architecture 60 58 850 49300 96.67 95 AVAILABLE 2024-01-10 2024-01-20 GOOD Design leadership