Welcome to CN Meal Calculator

The CN Meal Calculator is a specialized tool designed for CN rail employees to track their trips and calculate meal allowances based on duty hours. Whether you're managing single trips or round trips, this app helps you:

• Record trip details, including train ID, dates, times, and stations.
• Automatically calculate hours on duty and identify round trips.
• Determine meal allowances based on total hours away from your home station.
• Export your trips and meal calculations to Excel for easy record-keeping.

The app supports features like trip parsing, editing, and uploading trips from Excel files, making it a comprehensive solution for managing your work-related travel and meal entitlements.

1. Register or Login: Create an account or log in to access the app.
2. Set Your Home Station: Go to your profile and set your home station to enable trip type detection (e.g., home-to-away, away-to-home).
3. Add Trips:
   • Use the "Trip Parser" to paste trip details and automatically fill the form.
   • Manually enter trip details in the "Trip Entry" form and click "Add Entry".
   • Upload an Excel file with trips using the "Load Trips" button (this will replace existing trips).
4. Review Trips: View your trips in the table, which shows hours on duty, trip types, and round trip totals.
5. Calculate Meals: Click "Save Trips & Calculate Meals" to generate Excel files (`Trips.xlsx` and `Meals.xlsx`) with your trip details and meal allowances.
6. Manage Trips:
   • Edit or delete individual trips using the buttons in the table.
   • Clear all trips using the "Clear All Trips" button.
7. Export Data: Use the "Save Trips" button to download your trips as an Excel file (`Trips.xlsx`).

The app also provides a "Trip Summary" section to show total trips, round trips, hours, and meals, along with alerts for incomplete trips.