S3. Category 7: Employee Commuting

┌─────────────────────────────────────────────────────────────────────────────┐
│              SCOPE 3 CATEGORY 7: Employee Commuting                         │
├─────────────────────────────────────────────────────────────────────────────┤
│                                                                             │
│  EMPLOYEE HOMES                               WORKPLACE                     │
│  ──────────────────                           ──────────                    │
│                                                                             │
│  ┌──────────────┐                            ┌──────────────┐               │
│  │   🏠 Home    │◄─── 🚗 Car ────────────►   │   🏢 Office  │               │
│  └──────────────┘                            │              │               │
│                                              │              │               │
│  ┌──────────────┐                            │              │               │
│  │   🏠 Home    │◄─── 🚂 Train ──────────►   │              │               │
│  └──────────────┘                            │              │               │
│                                              │              │               │
│  ┌──────────────┐                            │              │               │
│  │   🏠 Home    │◄─── 🚌 Bus ────────────►   │              │               │
│  └──────────────┘                            │              │               │
│                                              │              │               │
│  ┌──────────────┐                            │              │               │
│  │   🏠 Home    │◄─── 🚲 Bike ───────────►   │              │               │
│  └──────────────┘                            │              │               │
│                                              │              │               │
│  ┌──────────────┐                            │              │               │
│  │   🏠 Home    │──── 💻 Remote ───────────  │   (0 km)     │               │
│  └──────────────┘                            └──────────────┘               │
│                                                                             │
│  DAILY ROUND TRIP:                                                          │
│  • Distance (km) × 2 (round trip)                                           │
│  • × Working days per week                                                  │
│  • × Emission factor (by transport mode)                                    │
│                                                                             │
│  INCLUDED:                             NOT INCLUDED:                        │
│  • Daily commute                       • Business travel (Category 6)       │
│  • All transport modes                 • Company vehicles (Scope 1)         │
│  • Remote work tracking                • Customer/visitor travel            │
│  • Carpooling emissions                                                     │
│                                                                             │
└─────────────────────────────────────────────────────────────────────────────┘

┌─────────────────────────────────────────────────────────────────────────────────────────┐
│                   CATEGORY 7 DATA REQUIREMENTS OVERVIEW                                  │
├─────────────────────────────────────────────────────────────────────────────────────────┤
│                                                                                         │
│  ┌─────────────────────────────────────────────────────────────────────────────────┐   │
│  │ EMPLOYEE RECORD                                                                 │   │
│  ├─────────────────────────────────────────────────────────────────────────────────┤   │
│  │                                                                                 │   │
│  │  Required Fields              Optional Fields                                   │   │
│  │  ──────────────────           ──────────────────                                │   │
│  │  • origin OR total_km         • email                                           │   │
│  │  • destination OR total_km    • name                                            │   │
│  │  • transport_type             • vehicle_size                                    │   │
│  │  • weekly_travels             • fuel_type                                       │   │
│  │                               • renewable_energy                                │   │
│  │                               • carpool (true/false)                            │   │
│  │                                                                                 │   │
│  └─────────────────────────────────────────────────────────────────────────────────┘   │
│                                                                                         │
│  ┌─────────────────────────────────────────────────────────────────────────────────┐   │
│  │ COMMUTING PERIOD (Employee Historic)                                            │   │
│  ├─────────────────────────────────────────────────────────────────────────────────┤   │
│  │                                                                                 │   │
│  │  Required Fields              Optional Fields                                   │   │
│  │  ──────────────────           ──────────────────                                │   │
│  │  • commuting_type             • situation                                       │   │
│  │    ("in_itinere")                                                               │   │
│  │  • start_date                                                                   │   │
│  │  • end_date                                                                     │   │
│  │  • daily_trips (default: 1)                                                     │   │
│  │                                                                                 │   │
│  └─────────────────────────────────────────────────────────────────────────────────┘   │
│                                                                                         │
│  ┌─────────────────────────────────────────────────────────────────────────────────┐   │
│  │ CALCULATION FLOW                                                                │   │
│  ├─────────────────────────────────────────────────────────────────────────────────┤   │
│  │                                                                                 │   │
│  │  Origin + Destination ──► Distance (km) [one-way]                               │   │
│  │                                │                                                │   │
│  │  Weekly Travels ──────────────┼──► Working days in period                       │   │
│  │                               │                                                 │   │
│  │  Transport Type ──────────────┼──► Emission Factor (kg CO₂e/km)                 │   │
│  │                               │                                                 │   │
│  │  CO₂e = Distance × Days × Daily_Trips × EF × 2 (round trip)                     │   │
│  │                                                                                 │   │
│  │  If carpool: CO₂e ÷ 3 (carpool factor)                                          │   │
│  │                                                                                 │   │
│  └─────────────────────────────────────────────────────────────────────────────────┘   │
│                                                                                         │
└─────────────────────────────────────────────────────────────────────────────────────────┘

# Example employees with different commuting patterns

employees = [
    # Full-time office worker (car)
    {
        "email": "[email protected]",
        "name": "Alice Johnson",
        "total_km": 20,
        "transport_type": "car",
        "vehicle_size": "medium",
        "fuel_type": "diesel",
        "weekly_travels": [0, 1, 2, 3, 4],
        "carpool": False,
    },
    # Hybrid worker (public transit, 3 days)
    {
        "email": "[email protected]",
        "name": "Bob Williams",
        "total_km": 12,
        "transport_type": "train",
        "weekly_travels": [1, 2, 3],  # Tue, Wed, Thu
        "carpool": False,
    },
    # Eco-commuter (bike)
    {
        "email": "[email protected]",
        "name": "Carol Davis",
        "total_km": 5,
        "transport_type": "bicycle",
        "weekly_travels": [0, 1, 2, 3, 4],
        "carpool": False,
    },
    # Remote worker
    {
        "email": "[email protected]",
        "name": "David Brown",
        "total_km": 0,
        "transport_type": "walk",  # Placeholder
        "weekly_travels": [],  # Fully remote
        "carpool": False,
    },
    # Carpooler
    {
        "email": "[email protected]",
        "name": "Emma Wilson",
        "total_km": 25,
        "transport_type": "car",
        "vehicle_size": "large",
        "fuel_type": "petrol",
        "weekly_travels": [0, 1, 2, 3, 4],
        "carpool": True,  # Shares ride with colleagues
    },
    # Electric car commuter
    {
        "email": "[email protected]",
        "name": "Frank Miller",
        "total_km": 30,
        "transport_type": "car",
        "vehicle_size": "medium",
        "fuel_type": "electric",
        "weekly_travels": [0, 1, 2, 3, 4],
        "carpool": False,
    },
]

# Create all employees
for emp in employees:
    response = requests.post(
        "https://api.dcycle.io/api/v1/employees",
        headers=headers,
        json=emp
    ).json()
    
    days = len(emp['weekly_travels'])
    remote = " (Remote)" if days == 0 else ""
    carpool = " 🚗👥" if emp.get('carpool') else ""
    
    print(f"   {emp['name']}: {emp['transport_type']} | {days} days/week{remote}{carpool}")
    print(f"      Distance: {emp['total_km']} km | CO₂e: {response.get('co2e', 'TBD')} kg/year")

print(f"\n✅ Created {len(employees)} employee records")

import requests
import os

headers = {
    "Authorization": f"Bearer {os.getenv('DCYCLE_API_KEY')}",
    "Content-Type": "application/json",
    "x-organization-id": os.getenv("DCYCLE_ORG_ID"),
    "x-user-id": os.getenv("DCYCLE_USER_ID"),
}

# Send survey to employees
survey_request = {
    "emails": [
        "[email protected]",
        "[email protected]",
        "[email protected]",
    ],
    "survey_type": "commuting",
    "message": "Please complete this short survey about your daily commute.",
}

response = requests.post(
    "https://api.dcycle.io/api/v1/employees/survey",
    headers=headers,
    json=survey_request
)

if response.status_code == 200:
    print(f"✅ Survey sent to {len(survey_request['emails'])} employees")
else:
    print(f"❌ Failed: {response.text}")

email,name,origin,destination,total_km,transport_type,vehicle_size,fuel_type,weekly_travels,carpool
[email protected],"Alice Johnson",,,20,car,medium,diesel,"[0,1,2,3,4]",false
[email protected],"Bob Williams",,,12,train,,,"[1,2,3]",false
[email protected],"Carol Davis",,,5,bicycle,,,"[0,1,2,3,4]",false
[email protected],"David Brown",,,0,walk,,,"[]",false
[email protected],"Emma Wilson",,,25,car,large,petrol,"[0,1,2,3,4]",true
[email protected],"Frank Miller",,,30,car,medium,electric,"[0,1,2,3,4]",false

import requests
import os

headers = {
    "Authorization": f"Bearer {os.getenv('DCYCLE_API_KEY')}",
    "x-organization-id": os.getenv("DCYCLE_ORG_ID"),
    "x-user-id": os.getenv("DCYCLE_USER_ID"),
}

# Upload CSV file
with open("employee_commuting.csv", "rb") as f:
    files = {"file": ("employee_commuting.csv", f, "text/csv")}
    
    response = requests.post(
        "https://api.dcycle.io/api/v1/employees/bulk/csv",
        headers=headers,
        files=files
    )

if response.status_code == 200:
    result = response.json()
    print(f"✅ Uploaded {result.get('records_processed', 0)} employee records")
else:
    print(f"❌ Upload failed: {response.text}")

import requests
import os

headers = {
    "Authorization": f"Bearer {os.getenv('DCYCLE_API_KEY')}",
    "Content-Type": "application/json",
    "x-organization-id": os.getenv("DCYCLE_ORG_ID"),
    "x-user-id": os.getenv("DCYCLE_USER_ID"),
}

# Get all employees
response = requests.get(
    "https://api.dcycle.io/api/v1/employees",
    headers=headers,
    params={
        "enabled": True,
    }
).json()

print(f"📊 Scope 3 Category 7: Employee Commuting (2024)")
print("=" * 60)

total_employees = len(response.get('items', []))
total_co2e = 0
remote_count = 0

for emp in response.get('items', []):
    co2e = emp.get('co2e', 0) or 0
    total_co2e += co2e
    
    weekly_travels = emp.get('weekly_travels', [])
    if not weekly_travels:
        remote_count += 1

print(f"   Total employees: {total_employees}")
print(f"   Remote workers: {remote_count} ({remote_count/total_employees*100:.0f}%)")
print(f"   Total CO₂e: {total_co2e:,.0f} kg ({total_co2e/1000:.1f} tonnes)")
print(f"   Avg per employee: {total_co2e/total_employees:,.0f} kg/year")

from collections import defaultdict

# Group by transport type
transport_summary = defaultdict(lambda: {"count": 0, "co2e": 0})

for emp in response.get('items', []):
    transport = emp.get('transport_type', 'unknown')
    co2e = emp.get('co2e', 0) or 0
    
    transport_summary[transport]["count"] += 1
    transport_summary[transport]["co2e"] += co2e

print("\n📊 Category 7 by Transport Mode:")
print("-" * 50)

transport_icons = {
    "car": "🚗",
    "train": "🚂",
    "bus": "🚌",
    "metro": "🚇",
    "tram": "🚊",
    "bicycle": "🚲",
    "walk": "🚶",
    "motorbike": "🏍️",
}

for transport, data in sorted(transport_summary.items(), key=lambda x: x[1]['co2e'], reverse=True):
    icon = transport_icons.get(transport, "🚀")
    percentage = (data['co2e'] / total_co2e * 100) if total_co2e > 0 else 0
    avg = data['co2e'] / data['count'] if data['count'] > 0 else 0
    
    print(f"   {icon} {transport.capitalize()}:")
    print(f"      Employees: {data['count']}")
    print(f"      Total CO₂e: {data['co2e']:,.0f} kg ({percentage:.1f}%)")
    print(f"      Avg per employee: {avg:,.0f} kg/year")
    print()

# Calculate remote work impact
office_co2e = 0
remote_co2e = 0
office_count = 0
remote_count = 0

for emp in response.get('items', []):
    weekly_travels = emp.get('weekly_travels', [])
    co2e = emp.get('co2e', 0) or 0
    
    if weekly_travels:
        office_co2e += co2e
        office_count += 1
    else:
        remote_co2e += co2e
        remote_count += 1

print("\n📊 Remote vs Office Impact:")
print("-" * 50)
print(f"   🏢 Office workers: {office_count}")
print(f"      Total CO₂e: {office_co2e:,.0f} kg")
print(f"      Avg per employee: {office_co2e/office_count if office_count else 0:,.0f} kg/year")
print()
print(f"   🏠 Remote workers: {remote_count}")
print(f"      Total CO₂e: {remote_co2e:,.0f} kg (should be ~0)")
print()

# Calculate potential savings
if office_count > 0:
    avg_office_co2e = office_co2e / office_count
    potential_savings_1day = avg_office_co2e / 5  # 1 day remote per week
    potential_savings_2day = avg_office_co2e * 2 / 5  # 2 days remote per week
    
    print(f"   💡 Potential savings per employee:")
    print(f"      1 remote day/week: {potential_savings_1day:,.0f} kg/year")
    print(f"      2 remote days/week: {potential_savings_2day:,.0f} kg/year")

# Validate weekly_travels data
def validate_commuting_data(employee):
    """Validate employee commuting data"""
    
    issues = []
    
    weekly_travels = employee.get('weekly_travels', [])
    
    # Check for valid day values
    for day in weekly_travels:
        if day not in range(7):
            issues.append(f"Invalid day value: {day}")
    
    # Check for duplicates
    if len(weekly_travels) != len(set(weekly_travels)):
        issues.append("Duplicate days in weekly_travels")
    
    # Check distance is reasonable
    total_km = employee.get('total_km', 0)
    if total_km and total_km > 150:
        issues.append(f"Unusually high distance: {total_km} km")
    
    return issues

# Validate all employees
for emp in response.get('items', []):
    issues = validate_commuting_data(emp)
    if issues:
        print(f"⚠️ {emp.get('email')}: {', '.join(issues)}")

# Identify high-emission commuters
high_emitters = []

for emp in response.get('items', []):
    co2e = emp.get('co2e', 0) or 0
    
    # Threshold: employees above average
    if co2e > (total_co2e / total_employees) * 1.5:
        high_emitters.append({
            "email": emp.get('email'),
            "transport": emp.get('transport_type'),
            "co2e": co2e,
            "distance": emp.get('total_km', 0),
        })

print(f"\n🎯 High-Emission Commuters ({len(high_emitters)}):")
for emitter in high_emitters[:10]:
    print(f"   {emitter['email']}")
    print(f"      Transport: {emitter['transport']} | Distance: {emitter['distance']} km")
    print(f"      CO₂e: {emitter['co2e']:,.0f} kg/year")
    
    # Suggest alternatives
    if emitter['transport'] == 'car' and emitter['distance'] < 10:
        print(f"      💡 Consider cycling or e-bike")
    elif emitter['transport'] == 'car' and emitter['distance'] < 30:
        print(f"      💡 Consider public transit or carpooling")

# Calculate emissions per employee per workday
def calculate_commuting_intensity():
    """Calculate kg CO₂e per employee per workday"""
    
    total_co2e = 0
    total_workdays = 0
    
    for emp in response.get('items', []):
        co2e = emp.get('co2e', 0) or 0
        weekly_travels = emp.get('weekly_travels', [])
        
        total_co2e += co2e
        # Estimate workdays per year (52 weeks × days per week)
        total_workdays += len(weekly_travels) * 52
    
    if total_workdays > 0:
        return total_co2e / total_workdays
    return 0

intensity = calculate_commuting_intensity()
print(f"\n📊 Commuting Intensity: {intensity:.2f} kg CO₂e per workday")

# Benchmark
if intensity > 5:
    print("   ⚠️ High intensity - promote alternatives")
elif intensity > 2:
    print("   📈 Moderate - encourage public transit")
else:
    print("   ✅ Good - maintain sustainable commuting")

# Provide distance directly if geocoding fails
employee = {
    "email": "[email protected]",
    "total_km": 15,  # Provide direct one-way distance
    "transport_type": "car",
    "weekly_travels": [0, 1, 2, 3, 4],
}

# Check common causes
def diagnose_zero_emissions(employee):
    """Diagnose why an employee has zero emissions"""
    
    issues = []
    
    # Check if fully remote
    if not employee.get('weekly_travels'):
        issues.append("weekly_travels is empty (remote worker)")
        return issues
    
    # Check if zero distance
    if not employee.get('total_km'):
        issues.append("total_km is missing or zero")
    
    # Check if zero-emission transport
    if employee.get('transport_type') in ['bicycle', 'walk']:
        issues.append(f"Zero-emission transport: {employee.get('transport_type')}")
    
    # Check if missing commuting period
    if not employee.get('employees_historic'):
        issues.append("No commuting period (employees_historic) created")
    
    return issues

for emp in response.get('items', []):
    if emp.get('co2e', 0) == 0:
        issues = diagnose_zero_emissions(emp)
        if issues:
            print(f"⚠️ {emp.get('email')}: {', '.join(issues)}")

# Common reasons for underreported commuting emissions
checks = {
    "Missing employees": "Ensure all employees are in the system",
    "Remote misclassification": "Check remote workers aren't marked as office",
    "Missing transport details": "Ensure transport_type is specified",
    "Missing distance": "Provide total_km or origin/destination",
    "Missing periods": "Create employees_historic records",
    "Inactive employees": "Check enabled=True filter",
}

print("🔍 Checklist for Category 7 completeness:")
for issue, action in checks.items():
    print(f"   ☐ {issue}")
    print(f"      → {action}")