Dashboard
Key Handover
CBRE Snagging
Project/MEP
CRM
First Visit
Handover
Interiors
Move-in
Excel Processor
Integration
Analytics
Key Handovers
0
Completion 0%
CBRE Snagging
0
Completion 0%
Project/MEP
0
Completion 0%
CRM
0
Completion 0%
First Visits
0
Completion 0%
Handovers
0
Completion 0%
Interiors
0
Completion 0%
Move-ins
0
Completion 0%

Tower-wise Progress Analysis

Key Handover - Project Team to HOTO Team

CBRE Snagging Process

Project/MEP Process

CRM Process

Customer First Visit

HOTO Handover Process

Interiors Work Process

Customer Move-in Process

Excel Data Processor

Step 1: Upload Excel File

Supported Formats: .xlsx, .xls, .csv

Requirements: File should have columns matching the template format

Drag & Drop Excel File Here

or click to browse

Step 2: Configure Import

Step 3: Export Options

Google Sheets Integration Setup

Connection Status

Connected
Never
Calculating...
Not connected

Step 1: Configure Google Sheet

IMPORTANT: Your Google Sheet MUST have these sheets:

key_handover (Sheet name exactly as shown)
snagging (Sheet name exactly as shown)
first_visit (Sheet name exactly as shown)
handover (Sheet name exactly as shown)
interiors (Sheet name exactly as shown)
movein (Sheet name exactly as shown)
project_mep (Sheet name exactly as shown)
crm (Sheet name exactly as shown)

Create Template

Create a new Google Sheet with the required sheets or use our template:

Step 2: Deploy Google Apps Script

Follow these steps:

  1. Open your Google Sheet
  2. Click Extensions → Apps Script
  3. Delete any existing code
  4. Copy and paste the code from the box below
  5. Click Save (Ctrl+S)
  6. Click Deploy → New Deployment
  7. Select Web App as type
  8. Set "Execute as" to Me
  9. Set "Who has access" to Anyone
  10. Click Deploy
  11. Copy the Web App URL provided

Step 3: Connect to Web App

Paste the Web App URL from deployment

Step 4: Sync Status & Statistics

Sync Progress 0%

Analytics & Reports

Filter Data

Monthly Trends
Tower Performance
Snagging Status
Weekly Performance (4 Weeks)

Download Reports