HOTO Process Tracker

High Rise Building Complex - Real-time Progress Tracking

Dashboard

Key Handover

CBRE Snagging

Project/MEP

CRM

First Visit

Handover

Interiors

Move-in

Excel Processor

Integration

Analytics

Key Handovers

Completion 0%

CBRE Snagging

Completion 0%

Project/MEP

Completion 0%

CRM

Completion 0%

First Visits

Completion 0%

Handovers

Completion 0%

Interiors

Completion 0%

Move-ins

Completion 0%

Tower-wise Progress Analysis

Key Handover - Project Team to HOTO Team

Select Floor:

CBRE Snagging Process

Select Floor:

CBRE Snagging Details

Flat Number *

Tower *

MEP Snagging

MEP Inspector Name

MEP Start Date

MEP End Date

MEP Completed

Civil Snagging

Civil Inspector Name

Civil Start Date

Civil End Date

Civil Completed

Electrical Snagging

Electrical Inspector Name

Electrical Start Date

Electrical End Date

Electrical Completed

Water & Slopes Snagging

Water & Slopes Inspector Name

Water & Slopes Start Date

Water & Slopes End Date

Water & Slopes Completed

AC Drain Snagging

AC Drain Inspector Name

AC Drain Start Date

AC Drain End Date

AC Drain Completed

Tiles Snagging

Tiles Inspector Name

Tiles Start Date

Tiles End Date

Tiles Completed

Remarks for Incomplete Areas

Follow-up Date

Project/MEP Process

Select Floor:

CRM Process

Select Floor:

CRM Details

Flat Number *

Date & time will appear after selection

Tower *

Description

Informed To

Status

Follow-up Date

Remarks (Optional)

Customer First Visit

Select Floor:

First Visit Details

Flat Number *

Tower *

Owner Name *

Owner Phone *

Visit Date & Time *

HOT Team Member *

Owner will inform the date

Handover Date Suggested

Going for Third Party Inspection

Third Party Inspection Details

Date Not Confirmed (Save First Visit Only)

Date Confirmed *

Report Received Date

Report Copy Type

Soft Copy

Hard Copy

Informed to Project Team

CBRE Checking Done

Customer Remarks

CRM NOC Received

HOTO Handover Process

Select Floor:

Handover Details

Flat Number *

Tower *

Customer Name *

Customer Email *

Second Owner (if any)

Second Owner Email

HOTO Team Member *

Handover Date & Time *

Items Handed Over

All Keys

User Manual

Welcome Gift

Customer Feedback

Final Inspection Completed

Inspection Remarks

Customer Move-in Process

Select Floor:

Move-in Details

Flat Number *

Tower *

Customer Name *

Contact Number *

Move-in Date *

Move-in Time *

Move clearance given by fire and safety team

Move-in Remarks

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

Select Process to Import *

Import Action *

Step 3: Export Options

Google Sheets Integration Setup

Connection Status

Current Status:

Connected

Last Sync:

Never

Local Records:

Calculating...

Cloud Records:

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:

Open your Google Sheet
Click Extensions → Apps Script
Delete any existing code
Copy and paste the code from the box below
Click Save (Ctrl+S)
Click Deploy → New Deployment
Select Web App as type
Set "Execute as" to Me
Set "Who has access" to Anyone
Click Deploy
Copy the Web App URL provided

Google Apps Script Code:

// Google Apps Script for HOTO Process Tracker
const SHEET_NAMES = ['key_handover', 'snagging', 'first_visit', 'handover', 'interiors', 'movein', 'project_mep', 'crm'];

function doGet(e) {
  return handleRequest(e);
}

function doPost(e) {
  return handleRequest(e);
}

function handleRequest(e) {
  try {
    const action = e.parameter.action;
    const process = e.parameter.process;
    const content = e.postData ? JSON.parse(e.postData.contents) : {};
    
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    
    // Handle CORS
    const response = ContentService.createTextOutput();
    response.setMimeType(ContentService.MimeType.JSON);
    response.setHeader('Access-Control-Allow-Origin', '*');
    
    let data;
    
    switch(action) {
      case 'get_data':
        data = getData(ss, process);
        break;
      case 'save_data':
        data = saveData(ss, process, content.data);
        break;
      case 'get_all_data':
        data = getAllData(ss);
        break;
      case 'sync_all':
        data = syncAllData(ss, content.data);
        break;
      case 'ping':
        data = {status: 'online', timestamp: new Date().toISOString()};
        break;
      case 'get_stats':
        data = getStatistics(ss);
        break;
      default:
        data = {error: 'Invalid action'};
    }
    
    response.setContent(JSON.stringify(data));
    return response;
    
  } catch (error) {
    const response = ContentService.createTextOutput(JSON.stringify({error: error.toString()}));
    response.setMimeType(ContentService.MimeType.JSON);
    response.setHeader('Access-Control-Allow-Origin', '*');
    return response;
  }
}

function getData(ss, process) {
  if (!SHEET_NAMES.includes(process)) {
    return {error: 'Invalid process name', data: []};
  }
  
  const sheet = ss.getSheetByName(process);
  if (!sheet) {
    return {data: [], count: 0, message: `Sheet ${process} not found`};
  }
  
  const data = getSheetData(sheet);
  return {data: data, count: data.length};
}

function getAllData(ss) {
  const allData = {};
  SHEET_NAMES.forEach(process => {
    const sheet = ss.getSheetByName(process);
    if (sheet) {
      allData[process] = getSheetData(sheet);
    } else {
      allData[process] = [];
    }
  });
  
  return allData;
}

function saveData(ss, process, rowData) {
  if (!SHEET_NAMES.includes(process)) {
    return {error: 'Invalid process name'};
  }
  
  let sheet = ss.getSheetByName(process);
  if (!sheet) {
    sheet = ss.insertSheet(process);
    const headers = getHeadersForProcess(process);
    sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
  }
  
  const data = getSheetData(sheet);
  const existingIndex = data.findIndex(row => 
    row.tower === rowData.tower && row.flat === rowData.flat);
  
  if (existingIndex >= 0) {
    const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
    const rowNum = existingIndex + 2;
    headers.forEach((header, col) => {
      if (rowData[header] !== undefined) {
        sheet.getRange(rowNum, col + 1).setValue(rowData[header]);
      }
    });
    return {message: 'Record updated', action: 'update', record: rowData};
  } else {
    const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
    const newRow = headers.map(header => rowData[header] || '');
    sheet.appendRow(newRow);
    return {message: 'Record added', action: 'add', record: rowData};
  }
}

function syncAllData(ss, allData) {
  const results = {};
  
  SHEET_NAMES.forEach(process => {
    if (allData[process]) {
      let sheet = ss.getSheetByName(process);
      if (!sheet) {
        sheet = ss.insertSheet(process);
        const headers = getHeadersForProcess(process);
        sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
      }
      
      sheet.clear();
      const headers = getHeadersForProcess(process);
      sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
      
      allData[process].forEach(row => {
        const rowData = headers.map(header => row[header] || '');
        sheet.appendRow(rowData);
      });
      
      results[process] = {
        added: allData[process].length,
        updated: 0,
        total: allData[process].length
      };
    }
  });
  
  return results;
}

function getSheetData(sheet) {
  const data = sheet.getDataRange().getValues();
  if (data.length <= 1) return [];
  
  const headers = data[0];
  const rows = data.slice(1);
  
  return rows.map(row => {
    const obj = {};
    headers.forEach((header, index) => {
      obj[header] = row[index] !== undefined ? row[index] : '';
    });
    return obj;
  });
}

function getHeadersForProcess(process) {
  const headers = {
    key_handover: ['tower', 'flat', 'handover_person', 'received_by_cbre', 'handover_date', 'all_keys_not_handed', 'remarks', 'timestamp'],
    snagging: ['tower', 'flat', 'mep_inspector', 'mep_start_date', 'mep_end_date', 'mep_completed', 'civil_inspector', 'civil_start_date', 'civil_end_date', 'civil_completed', 'electrical_inspector', 'electrical_start_date', 'electrical_end_date', 'electrical_completed', 'water_inspector', 'water_start_date', 'water_end_date', 'water_completed', 'ac_drain_inspector', 'ac_drain_start_date', 'ac_drain_end_date', 'ac_drain_completed', 'tiles_inspector', 'tiles_start_date', 'tiles_end_date', 'tiles_completed', 'remarks', 'followup_date', 'timestamp'],
    first_visit: ['tower', 'flat', 'owner_name', 'owner_phone', 'visit_date', 'hot_member', 'handover_suggested', 'owner_will_inform', 'going_for_third_party', 'third_party_date_confirmed', 'report_received_date', 'soft_copy', 'hard_copy', 'informed_to_project_team', 'project_team_informed_date', 'cbre_checking_done', 'cbre_checking_date', 'customer_remarks', 'crm_noc', 'timestamp'],
    handover: ['tower', 'flat', 'customer_name', 'customer_email', 'second_owner_name', 'second_owner_email', 'hoto_member', 'handover_date', 'items_handed', 'customer_feedback', 'final_inspection', 'inspection_remarks', 'timestamp'],
    interiors: ['tower', 'flat', 'contractor_name', 'contractor_contact', 'work_start_date', 'estimated_end_date', 'site_supervisor_number', 'site_supervisor', 'interior_works', 'dos_donts_explained', 'multiple_vendors', 'additional_vendors', 'remarks', 'timestamp'],
    movein: ['tower', 'flat', 'customer_name', 'contact_number', 'movein_date', 'movein_time', 'move_clearance_given', 'deviations_resolved', 'movein_remarks', 'timestamp'],
    project_mep: ['tower', 'flat', 'snags_status', 'confirmation_date', 'cbre_checked', 'cbre_checked_date', 'timestamp'],
    crm: ['tower', 'flat', 'description', 'informed_to', 'status', 'followup_date', 'remarks', 'timestamp']
  };
  
  return headers[process] || [];
}

function getStatistics(ss) {
  const stats = {};
  let total = 0;
  
  SHEET_NAMES.forEach(process => {
    const sheet = ss.getSheetByName(process);
    if (sheet) {
      const count = Math.max(0, sheet.getLastRow() - 1);
      stats[process] = count;
      total += count;
    } else {
      stats[process] = 0;
    }
  });
  
  stats.total = total;
  return stats;
}

Step 3: Connect to Web App

Web App URL * Paste the Web App URL from deployment

Sync Options

Sync Frequency

Step 4: Sync Status & Statistics

Sync Progress 0%

Analytics & Reports

Filter Data

Start Date

End Date

Monthly Trends

Tower Performance

Snagging Status

Weekly Performance (4 Weeks)

Tower-wise Progress Analysis

Key Handover - Project Team to HOTO Team

Key Handover Details

CBRE Snagging Process

CBRE Snagging Details

MEP Snagging

Civil Snagging

Electrical Snagging

Water & Slopes Snagging

AC Drain Snagging

Tiles Snagging

Project/MEP Process

Project/MEP Details

CRM Process

CRM Details

Customer First Visit

First Visit Details

Third Party Inspection Details

HOTO Handover Process

Handover Details

Interiors Work Process

Interiors Work Details

Main Vendor Details

Additional Vendor

Customer Move-in Process

Move-in Details

Recorded Deviations (From Interiors)

Excel Data Processor

Step 1: Upload Excel File

Drag & Drop Excel File Here

File Preview (First 10 rows)

Validation Errors

Step 2: Configure Import

Import Summary

Step 3: Export Options

Google Sheets Integration Setup

Connection Status

Step 1: Configure Google Sheet

IMPORTANT: Your Google Sheet MUST have these sheets:

Create Template

Step 2: Deploy Google Apps Script

Step 3: Connect to Web App

Step 4: Sync Status & Statistics

Sync Details

Analytics & Reports

Filter Data

Download Reports

Complete Flat Details

Record Deviation