🏔️ Milano Cortina 2026 - Shift Viewer User Guide

1. Getting Started

Loading Your Shift Data

There are two ways to load shift data into ShiftViewer:

Option 1: Upload Excel File

Steps to upload:

1. Download from SharePoint: Click the "COLE" link on the landing page (or visit the SharePoint link above) and download the latest shift schedule Excel file to your local drive
2. Open ShiftViewer: Navigate to the ShiftViewer application
3. Choose File: Click the "Choose Excel File" button on the landing page
4. Select File: Browse to your downloaded Excel file (.xlsx or .xls) and select it
5. Automatic Processing: The app will automatically parse and display your shifts
6. Auto-Save: Data is saved to your browser for future sessions

Option 2: Load Saved Data

1. If you've previously uploaded a file, you'll see "Load Saved Data" button
2. Click it to instantly load your last uploaded shift schedule
3. No need to re-upload the Excel file

2. Search Features

Basic Search

Type any text in the search box to search across all fields (name, role, venue, type).

AND Search (Multiple Terms)

Separate terms with spaces - ALL terms must match (AND logic).

Quoted Phrase Search

Use quotes to search for exact phrases with spaces.

Field-Specific Search

Search within specific fields using field:value syntax.

Search	Description
name:John	Search only in names
role:WMR	Search only in roles
venue:RTOC	Search only in venues
date:15/11	Search by date

Date Search POWERFUL

Search by date with intelligent format detection and year inference.

Date Formats Supported:

• date:15/11 - Tries both EU (15 Nov) and US (Nov 15) formats
• date:11/15 - Same as above
• date:15/11/2025 - Specific date with 4-digit year
• date:15/11/25 - Specific date with 2-digit year

Smart Year Inference:

• November-December → Assumes 2025
• January-March → Assumes 2026
• Other months → Uses current year

Assignment Status Search NEW

Filter by whether shifts are assigned or not.

Type Search

Search by shift type (virtual or on-site).

Negative Search (Exclude Terms) NEW

Use the minus sign (-) prefix to exclude terms from results.

Combining Search Types

Mix and match different search types for powerful filtering.

3. Filters & Views

Tab Filters

Quick access to common time-based views:

Tab	Shows
📋 Upcoming	All future shifts (starting from today)
🔴 Current Shifts	Shifts happening right now
📆 Today	All shifts scheduled for today
📅 Tomorrow	All shifts scheduled for tomorrow
🔍 ALL (incl. past)	Every shift, including past ones

My Shifts Filter PERSONAL

Filter to see only your assigned shifts.

How to Use:

1. Enter your name in the "My name" text box
2. Click "👤 My Shifts" button
3. Button turns purple - filter is active
4. Click again to turn off filter

Behavior:

• ✅ Works with tab filters (e.g., "Upcoming" + "My Shifts" = your upcoming shifts)
• ✅ Clears search boxes when activated
• ✅ Your name is saved for future sessions
• ✅ Input text is gray when inactive, black when active

Saved Search

Save and quickly execute frequently used searches.

How to Use:

1. Type your search in "This search will be saved" box
2. Search is automatically saved to your browser
3. Click "Execute Saved Search" to apply it
4. Button turns purple when active
5. Click again to clear the search

Features:

• ✅ Automatically saved across sessions
• ✅ Button disabled when search box is empty
• ✅ Uses same powerful search syntax
• ✅ Toggle on/off easily

4. Understanding the Interface

Shift Cards

Each shift is displayed as a compact card with all relevant information.

Card Header:

• Name: Large, bold text (or "🔴 Unassigned")
• Role: Purple text below name
• Status Badge: Green "✓ Assigned" or Orange "⚠️ Unassigned"

Shift Details (Grid Layout):

• 📅 Date (day, month, year)
• 📍 Venue
• 🌍 Location
• 🕐 Time (CET)
• 🕐 Time (IST)
• 📋 Type (Virtual/On Site)

Contact Information:

Displayed in a horizontal line at the bottom of each card:

• 💬 Teams: Click to open chat in desktop Teams app
• Email: Shown in gray text
• 📱 Individual: Personal phone number (hover for tooltip)
• 🔄 Role: Shared phone passed between shifts (hover for tooltip)

Statistics Bar

Shows at the top of the shift list:

• Total: Number of shifts in current view
• Assigned: Count of assigned shifts
• Unassigned: Count of unassigned shifts

Button States

Filter Buttons (My Shifts, Execute Saved Search):

State	Appearance
Inactive	Gray background, 100% opacity
Active	Purple background, 100% opacity
Disabled	Gray background, 50% opacity, cursor not-allowed

5. Tips & Tricks

Search Efficiency

• Use field-specific search when you know exactly what you're looking for
• Combine multiple criteria for precise results
• Use quotes for multi-word phrases
• Remember: spaces = AND logic (all terms must match)

Finding Unassigned Shifts

Personal Workflow

1. Enter your name in "My name" box (saved automatically)
2. Click "Upcoming" tab
3. Click "My Shifts" to see your upcoming shifts
4. Click "My Shifts" again to see all upcoming shifts

Keyboard Shortcuts

• Type in search box - results update after 200ms pause
• Press Escape in "My name" box to clear filter

Data Management

• Data is saved to your browser automatically
• Use "Load Saved Data" to avoid re-uploading
• Check the "Last update" timestamp to know data freshness
• Upload a new file to replace saved data

Combining Filters

All filters work together:

6. Troubleshooting

No Shifts Showing

• Check if you're on the correct tab (try "ALL" to see everything)
• Clear search box and filters
• Verify your Excel file uploaded successfully
• Check browser console for errors (F12)

Search Not Working

• Wait 200ms after typing (debounced search)
• Check search syntax (use field:value format)
• Verify spelling and case (searches are case-insensitive)
• Try simpler search terms first

Date Search Issues

• Use date: prefix: date:15/11
• Try both EU and US formats (app tries both)
• Include year if ambiguous: date:15/11/2025
• Check console logs for date parsing details

Teams Link Not Working

• Ensure Microsoft Teams desktop app is installed
• Link uses msteams:// protocol for desktop app
• Falls back to web version if desktop not available
• Check browser allows protocol handlers

Saved Data Not Loading

• Check if browser allows localStorage
• Try clearing browser cache and re-uploading
• Verify you're using the same browser
• Private/Incognito mode may not persist data

Button Not Responding

• Check if button is disabled (50% opacity)
• Ensure text box has content (for filter buttons)
• Try refreshing the page
• Clear browser cache if persistent

Quick Reference

Search Syntax Cheat Sheet

Syntax	Example	Result
General	john	Searches all fields
AND	wmr olena	Both terms must match
Quoted	"duty manager"	Exact phrase
Field	role:WMR	Search specific field
Date	date:15/11	Search by date
Status	unassigned	Filter by assignment
Type	virtual	Filter by shift type
Exclude	-RTOC	Exclude matching terms
Combined	role:WMR date:15/11 virtual	All criteria must match
Combined w/ Exclude	venue:TOC -RTOC unassigned	Include TOC, exclude RTOC, unassigned only