Setup Requirements

  1. Ensure your Google Sheet contains these tabs: "I- Active", "I - New Hire", "I - Payroll", "I - Cross entity allocation"
  2. Verify you have viewing access to the spreadsheet in your organization
  3. Copy the complete Google Sheets URL from your browser
  4. Configure your analysis parameters below
Percentage of Variable CTC to include in calculations
Delay start date for new hires without offered compensation

Processing your spreadsheet data...

Workforce Overview

Financial Summary

Entity Distribution

Monthly Projections

Headcount Analysis by Cost Center

Entity Cost Center Department Active Employees New Hires Total Headcount

Cross Entity Cost Allocation

Cost Center Monthly Projections

Detailed Employee Projections