Skip to content

SAFE App API

This article is designed to show you the workflow for SAFE Application API. Below the diagram you will find the high-level steps to work with API.

Refer to our SAFE API reference documentation for more details.

Workflow using swimlane

API Workflow API Workflow

Workflow in steps

Our APIs use the OAuth2.0 Client Credentials workflow. See the steps below:

  1. Generate Bearer Token. Ensure:

    • the <your_client_secret> is URL encoded. You can use urlencoder.org to URL encode the client secret.
    • the <your_client_id>:<your_url_encoded_client_secret> string is base64 encoded
    • the content-type is x-www-form-urlencoded
    • the grant-type is client_credentials

    • the scope is frmsc_safe_upload_api

      Manually encoding?

      Use base64encode.org to encode or decode the string of <Your_ClientID>:<Your_URL_Encoded_ClientSecret>.

      5471E010-DDEE-4C98-FF8F-08DB2245E373:7rg6Gt+hUiobtXI9Jb37z2vtrhw1CEgDkwFZcMbN5Yc=

      NTQ3MUUwMTAtRERFRS00Qzk4LUZGOEYtMDhEQjIyNDVFMzczOjdyZzZHdCtoVWlvYnRYSTlKYjM3ejJ2dHJodzFDRWdEa3dGWmNNYk41WWM9

      Basic NTQ3MUUwMTAtRERFRS00Qzk4LUZGOEYtMDhEQjIyNDVFMzczOjdyZzZHdCtoVWlvYnRYSTlKYjM3ejJ2dHJodzFDRWdEa3dGWmNNYk41WWM9

  2. Use the generated token for Bearer authorization in /UploadRoster endpoint. Generate roster token to get results. Ensure:

    • the mandatory fields are filled.
    • the RosterData field is populated in the correct order.

  3. Use the roster token with /GetResults endpoint to fetch the status of upload. Ensure:
    • correct bearer token is being used for authorization.
    • roster token is correct

  4. If the status is not completedsuccessfully, set the value of dataKey parameter to feedback and submit.
    • Resolve any error.
    • Return to Step 2. Keep the RosterName same and set the value of Overwrite field to true and resubmit the roster.

  5. If the status is completedsuccessfully, set the value of dataKey parameter to the type of result you want to receive and submit.

Payload

Request payload

The request payloads differ for UploadRoster and GetResults endpoint.

For Upload Roster

Download files

Download example files for RosterData csv and ActivitiyData csv here.

See our API reference documentation for more information.

Schema
RosterNamestring Required

A name for the schedule. Use employee identifier.

RosterDatastring Required

See the table below for the format of the data. Note:

  • This property takes comma separated values (csv).
  • The roster data must be in the same order as shown below.
  • You can omit the column titles. In such a case, the order in which the column titles are listed below will be assumed.
  • You can send multiple rows at a time.
  • You can fill in the required columns and delete the others.
  • If you are sending the data to a column that is not required, you must send all columns. The columns without data can be left blank.


ColumnName
(+ required)		 Format Description
Reference+ Text A free-text field usually used to indicate a pilot. Use pilot's name or ID.
OnDutyDate+ Date (DD/MM/YYYY) The duty start date.
OnDutyTime+ Time (hh:mm) The duty start time.
StartAirport+ Text The airport at which the duty started. Send ICAO, IATA, or FAA airport codes or a combination of these codes.
OffDutyDate+ Date (DD/MM/YYYY) The duty end date.
OffDutyTime+ Time (hh:mm) The duty end time.
EndAirport+ Text The airport at which the duty ended. Send ICAO, IATA, or FAA airport codes or a combination of these codes.
Sectors Number The number of flights in duty. Default value is 1.
CrewComposition Number Send
  • 2 for 2 Pilots
  • 3 for 3 Pilots
  • 4 for 4 Pilots
  • 9 for Cabin Crew
Default value is 2.
SleepCount Number (0-2) The number of sleeps the pilot or the crew member slept on duty.
SleepOrder Number (1-3) The rank, which the pilot or the crew member slept in. Send
  • 1 for First
  • 2 for Second
  • 3 for Third
SleepClass Number (1-5) Send
  • 1 for Class 1 - Bunk
  • 2 for Class 2 - Cabin seat: 40 degrees or more recline
  • 3 for Class 3 - Flight deck seat
  • 4 for Class 4 - Economy seat: Less than 40 degrees recline
  • 5 for Class 5 - Jump seat
HomeBase+ Text Send ICAO, IATA, or FAA airport codes or a combination of these codes. Default value is Start airport code.
TimeReference+ Number (0-2) The reference time zone. Send
  • 0 for UTC
  • 1 for Base airport timezone
  • 2 for Local timezone
OnPartialAugmentDate Date (DD/MM/YYYY) The time on which the pilot or the crew member started their partial augmentation.
OnPartialAugmentTime Time (hh:mm) The time at which the pilot or the crew member started their partial augmentation.
OffPartialAugmentDate Date (DD/MM/YYYY) The date on which the pilot or the crew member ended their partial augmentation.
OffPartialAugmentTime Time (hh:mm) The time at which the pilot or the crew member ended their partial augmentation.
FirstRestStartDate Date (DD/MM/YYYY) The date on which the pilot or the crew member started their first rest.
FirstRestStartTime Time (hh:mm) The time at which the pilot or the crew member started their first rest.
FirstRestEndDate Date (DD/MM/YYYY) The date on which the pilot or the crew member ended their first rest.
FirstRestEndTime Time (hh:mm) The time at which the pilot or the crew member ended their first rest.
SecondRestStartDate Date (DD/MM/YYYY) The date on which the pilot or the crew member started their second rest.
SecondRestStartTime Time (hh:mm) The time at which the pilot or the crew member started their second rest.
SecondRestEndDate Date (DD/MM/YYYY) The date on which the pilot or the crew member ended their second rest.
SecondRestEndTime Time (hh:mm) The time at which the pilot or the crew member ended their second rest.
SplitShift Number (0-1) Indicates whether the pilot or crew member had rested in between flight. Send
  • 0 for True
  • 1 for False
DutyType Number (1-3) The type of duty. Send
  • 1 for active
  • 2 for active - split shift
  • 3 for standby duty
Fleet Text A free-text field used to indicate fleet message.
Rank Text A free-text field used to indicate a pilot's rank.
Workload Number When the sector count is 0, send
  • 0 for no activity, i.e. doing nothing but not sleeping
  • 10 for average workload on a typical single-sector duty. Equivalent to workload prior to being able to change workload
  • 20 for average workload on a typical four-sector duty
  • 30 for very high workloads
  • 40 for exceptionally high workloads only seen occasionally
  • 50 for extremely high workloads only rarely seen
When the sector count is more than 0, send
  • -50 for half the workload of standard flying this number of sectors
  • 0 for standard duty workloads flying this number of sectors. Equivalent to workload prior to being able to change workload
  • 100 for double the workload of standard flying this number of sectors
CrewPrepTime Number The time taken for crew to prepare. Value indicates minutes. Default value is 60 minutes.
DutyCommuteTime Number The time taken to commute to the duty. Value indicates minutes. Default value is 60 minutes.
CabinCrewSleepPattern Number (0-4) Default value is 0. Send
  • 0 for Normal Long Haul Pattern 1 or 2 sleep periods
  • 1 (ULR Pattern 1 or 2 sleep periods, short service)
  • 2 (ULR Pattern 1 sleep period, 50% cruise phase)
  • 3 (ULR Pattern Main Crew 1 or 2 sleep periods)

ActivityDatastring

See the table below for the format of the data. Note:

  • This property takes comma separated values (csv).
  • The activity data must be in the same order as shown below.
  • You can omit the column titles. In such a case, the order in which the column titles are listed below will be assumed.
  • You can send multiple rows at a time.


ColumnName
(+ required)		 Format Description
Reference+ Text A free-text field usually used to indicate a Activity. Use pilot's name or ID.
ActivityStartDate+ Date (DD/MM/YYYY) The activity start date.
ActivityStartTime+ Time (hh:mm) The activity start time.
ActivityEndDate+ Date (DD/MM/YYYY) The activity end date.
ActivityEndTime+ Time (hh:mm) The activity end time.
ActivityType+ Text Send one of the following
  • Check in
  • Flight
  • Waiting time
  • Time at hotel
  • Positioning
  • Commuting
  • Simulator duty
  • Ground duty
  • Check out
Description+ Text A free text field to explain the activity.
TimeReference+ Number (0-2) Send
  • 0 for UTC
  • 1 for Base
  • 2 for Local
StartAirport+ Time (hh:mm) The airport at which the activity started. Send ICAO, IATA, or FAA airport codes or a combination of these codes.
EndAirport+ Text The airport at which the activity ended. Send ICAO, IATA, or FAA airport codes or a combination of these codes.
Homebase+ Text The pilot's or the crew member's home airport. Send ICAO, IATA, or FAA airport codes or a combination of these codes. Default value is Start airport code.

Usernamestring

Your Client ID key. You can get the Client ID key from the app.

Keystring Required

Your API key. You can get the API key from the app.

Overwriteboolean string

Send true if existing schedule with the same name should be overwritten by this upload

Example
{
  "RosterName": "Sample Roster 1",
  "RosterData": "Reference,OnDutyDate,OnDutyTime,StartAirport,OffDutyDate,OffDutyTime,EndAirport,HomeBase,TimeReference\r\nPilot1,12/05/2010,19:45,SNA,13/05/2010,04:07,RSW,SNA,2",
  "ActivityData": "Reference,ActivityStartDate,ActivityStartTime,ActivityEndDate,ActivityEndTime,ActivityType,Description,TimeReference,StartAirport,EndAirport,Homebase\r\nPilot1,12/05/2010,19:46,12/05/2010,19:50,Check in,,0,SNA,RSW,SNA",
  "Username": "5471E010-DDEE-4C98-FF8F-08DB2245E372",
  "Key": "90CBF21C-33D4-4C32-944A-22A0C416DF89",
  "Overwrite": "false"
}

For Get Results

The GetResults endpoint doesn't require a request payload. However, you must send values to the following parameters.

Schema
Parameter Description
token The token you received after successfully uploading a Roster
dataKey The type of results you want to retrieve. The following values are supported for the dataKey parameter. Send only one value at a time.
  • status
  • feedback
  • hundredpointalertness
  • samnperellialertness
  • karolinskaalertness
  • karolinskaprobability
  • vigilancedegradation
  • complexreactiondegradation
  • percentagemissedresponses
  • sleepperiods
  • schedule
  • timeabovethreshold
  • tableofscheduledetailsids
To check the algorithmic results, first set the value of the dataKey parameter to status and check for the response. After the response is completedsuccessfully, start querying for the algorithmic results.
key Your API Key

Response payload

See below for an example. See our API reference documentation or Results breakdown for more information.

For Upload Roster

9e529abf-6b2f-4a17-92de-d1cfc85976db

For Get Results

Explore the tabs below for example response that you could receive on using different values for dataKey parameter.

completedsuccessfully

Roster import and process was successful Homebase timezone 59

Reference,Duty,Duty Start,Duty End,Duty Start Date,Duty Start Time,Duty End Date,Duty End Time,00 - 15 Mins,15 - 30 Mins,30 - 45 Mins,45 - 60 Mins,60 - 75 Mins,75 - 90 Mins,90 - 105 Mins,105 - 120 Mins,120 - 135 Mins,135 - 150 Mins,150 - 165 Mins,165 - 180 Mins,180 - 195 Mins,195 - 210 Mins,210 - 225 Mins,225 - 240 Mins,240 - 255 Mins,255 - 270 Mins,270 - 285 Mins,285 - 300 Mins,300 - 315 Mins,315 - 330 Mins,330 - 345 Mins,345 - 360 Mins,360 - 375 Mins,375 - 390 Mins,390 - 405 Mins,405 - 420 Mins,420 - 435 Mins,435 - 450 Mins,450 - 465 Mins,465 - 480 Mins,480 - 495 Mins,495 - 510 Mins,510 - 525 Mins,525 - 540 Mins,540 - 555 Mins,555 - 570 Mins,570 - 585 Mins,585 - 600 Mins,600 - 615 Mins,615 - 630 Mins,630 - 645 Mins,645 - 660 Mins,660 - 675 Mins
Pilot1,EGLL / LHR / N/A - LEMD / MAD / N/A,01/01/2015 04:30,01/01/2015 11:20,01/01/2015,04:30,01/01/2015,11:20,44.57,43.80,43.03,42.27,41.53,40.82,40.15,39.51,38.93,38.38,37.89,37.44,37.05,36.70,36.41,36.16,35.96,35.85,35.75,35.69,35.67,35.69,35.74,35.82,35.93,36.06,36.21,,,,,,,,,,,,,,,,,,
Pilot1,LEMD / MAD / N/A - KJFK / JFK / N/A,02/01/2015 16:10,03/01/2015 03:20,02/01/2015,16:10,03/01/2015,03:20,73.41,72.79,72.11,71.39,70.61,69.79,68.91,67.98,67.00,65.98,64.90,63.77,62.60,61.39,60.13,58.84,57.50,56.14,54.73,53.30,51.85,0.00,0.00,0.00,0.00,21.80,37.44,42.28,44.10,44.70,43.62,43.09,42.38,41.57,39.81,38.74,37.65,36.57,34.83,33.65,32.50,31.39,29.84,28.71,
Pilot1,KJFK / JFK / N/A - EGLL / LHR / N/A,03/01/2015 23:30,04/01/2015 06:00,03/01/2015,23:30,04/01/2015,06:00,52.19,50.92,49.70,48.53,47.40,45.00,43.71,42.48,41.29,39.04,37.74,36.49,35.29,33.78,32.31,30.87,29.47,0.00,26.71,26.14,25.21,23.78,22.75,21.76,20.81,19.69,,,,,,,,,,,,,,,,,,,
Pilot1,EGLL / LHR / N/A - EGLL / LHR / N/A,05/01/2015 12:30,05/01/2015 18:25,05/01/2015,12:30,05/01/2015,18:25,66.19,66.22,66.24,66.24,66.22,66.18,66.13,66.05,65.94,65.81,65.66,65.47,65.23,64.97,64.67,64.37,63.99,63.58,63.12,62.61,62.05,61.45,60.80,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,01/01/2015 19:53,02/01/2015 06:00,01/01/2015,19:53,02/01/2015,06:00,76.19,76.11,76.00,75.87,75.71,75.52,75.30,75.04,74.75,74.42,74.05,73.64,73.19,72.69,72.14,71.55,70.91,70.22,69.48,68.69,67.85,66.96,66.02,65.03,63.97,62.88,61.74,60.56,59.33,58.06,56.74,55.40,54.01,52.60,51.15,49.68,48.19,46.68,45.15,43.61,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,02/01/2015 13:01,02/01/2015 19:25,02/01/2015,13:01,02/01/2015,19:25,31.62,31.07,30.54,30.02,0.00,6.84,24.37,28.09,29.45,30.03,30.28,30.37,30.37,30.33,30.28,30.22,30.15,30.10,30.06,30.03,30.00,29.99,29.97,29.96,29.95,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,03/01/2015 10:10,03/01/2015 13:14,03/01/2015,10:10,03/01/2015,13:14,35.08,33.96,32.84,31.74,30.66,29.62,28.62,27.66,26.75,25.88,25.08,24.33,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,04/01/2015 00:01,04/01/2015 03:20,04/01/2015,00:01,04/01/2015,03:20,52.95,52.22,51.45,50.62,49.73,48.79,47.80,46.75,45.66,44.52,43.35,42.12,40.85,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYEG / YEG / N/A,05/01/2015 10:42,05/01/2015 17:07,05/01/2015,10:42,05/01/2015,17:07,40.43,39.36,38.29,37.23,36.19,35.19,34.21,33.28,32.40,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,19.85,30.17,35.27,38.17,39.95,41.12,41.90,,,,,,,,,,,,,,,,

Reference,Duty,Duty Start,Duty End,Duty Start Date,Duty Start Time,Duty End Date,Duty End Time,00 - 15 Mins,15 - 30 Mins,30 - 45 Mins,45 - 60 Mins,60 - 75 Mins,75 - 90 Mins,90 - 105 Mins,105 - 120 Mins,120 - 135 Mins,135 - 150 Mins,150 - 165 Mins,165 - 180 Mins,180 - 195 Mins,195 - 210 Mins,210 - 225 Mins,225 - 240 Mins,240 - 255 Mins,255 - 270 Mins,270 - 285 Mins,285 - 300 Mins,300 - 315 Mins,315 - 330 Mins,330 - 345 Mins,345 - 360 Mins,360 - 375 Mins,375 - 390 Mins,390 - 405 Mins,405 - 420 Mins,420 - 435 Mins,435 - 450 Mins,450 - 465 Mins,465 - 480 Mins,480 - 495 Mins,495 - 510 Mins,510 - 525 Mins,525 - 540 Mins,540 - 555 Mins,555 - 570 Mins,570 - 585 Mins,585 - 600 Mins,600 - 615 Mins,615 - 630 Mins,630 - 645 Mins,645 - 660 Mins,660 - 675 Mins
Pilot1,EGLL / LHR / N/A - LEMD / MAD / N/A,01/01/2015 04:30,01/01/2015 11:20,01/01/2015,04:30,01/01/2015,11:20,3.60,3.64,3.68,3.72,3.76,3.79,3.83,3.86,3.89,3.92,3.95,3.97,3.99,4.01,4.02,4.04,4.05,4.05,4.06,4.06,4.06,4.06,4.06,4.06,4.05,4.04,4.04,,,,,,,,,,,,,,,,,,
Pilot1,LEMD / MAD / N/A - KJFK / JFK / N/A,02/01/2015 16:10,03/01/2015 03:20,02/01/2015,16:10,03/01/2015,03:20,2.09,2.12,2.15,2.19,2.23,2.27,2.32,2.37,2.42,2.47,2.53,2.59,2.65,2.72,2.78,2.85,2.92,2.99,3.06,3.14,3.22,7.00,7.00,7.00,7.00,4.79,3.97,3.72,3.62,3.59,3.65,3.67,3.71,3.75,3.85,3.90,3.96,4.02,4.11,4.17,4.23,4.29,4.37,4.43,
Pilot1,KJFK / JFK / N/A - EGLL / LHR / N/A,03/01/2015 23:30,04/01/2015 06:00,03/01/2015,23:30,04/01/2015,06:00,3.20,3.26,3.33,3.39,3.45,3.57,3.64,3.71,3.77,3.89,3.95,4.02,4.08,4.16,4.24,4.31,4.39,7.00,4.53,4.56,4.61,4.69,4.74,4.79,4.84,4.90,,,,,,,,,,,,,,,,,,,
Pilot1,EGLL / LHR / N/A - EGLL / LHR / N/A,05/01/2015 12:30,05/01/2015 18:25,05/01/2015,12:30,05/01/2015,18:25,2.46,2.46,2.46,2.46,2.46,2.46,2.47,2.47,2.48,2.48,2.49,2.50,2.51,2.53,2.54,2.56,2.58,2.60,2.62,2.65,2.68,2.71,2.75,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,01/01/2015 19:53,02/01/2015 06:00,01/01/2015,19:53,02/01/2015,06:00,1.94,1.94,1.95,1.96,1.96,1.97,1.99,2.00,2.01,2.03,2.05,2.07,2.10,2.12,2.15,2.18,2.22,2.25,2.29,2.33,2.38,2.42,2.47,2.52,2.58,2.64,2.70,2.76,2.82,2.89,2.96,3.03,3.10,3.18,3.25,3.33,3.41,3.49,3.57,3.65,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,02/01/2015 13:01,02/01/2015 19:25,02/01/2015,13:01,02/01/2015,19:25,4.28,4.30,4.33,4.36,7.00,5.57,4.66,4.46,4.39,4.36,4.35,4.34,4.34,4.34,4.35,4.35,4.35,4.36,4.36,4.36,4.36,4.36,4.36,4.36,4.36,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,03/01/2015 10:10,03/01/2015 13:14,03/01/2015,10:10,03/01/2015,13:14,4.09,4.15,4.21,4.27,4.33,4.38,4.43,4.48,4.53,4.58,4.62,4.66,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,04/01/2015 00:01,04/01/2015 03:20,04/01/2015,00:01,04/01/2015,03:20,3.16,3.20,3.24,3.28,3.33,3.38,3.43,3.48,3.54,3.60,3.66,3.73,3.79,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYEG / YEG / N/A,05/01/2015 10:42,05/01/2015 17:07,05/01/2015,10:42,05/01/2015,17:07,3.81,3.87,3.93,3.98,4.04,4.09,4.14,4.19,4.23,7.00,7.00,7.00,7.00,7.00,7.00,7.00,7.00,6.16,4.89,4.35,4.08,3.93,3.84,3.78,3.74,,,,,,,,,,,,,,,,

Reference,Duty,Duty Start,Duty End,Duty Start Date,Duty Start Time,Duty End Date,Duty End Time,00 - 15 Mins,15 - 30 Mins,30 - 45 Mins,45 - 60 Mins,60 - 75 Mins,75 - 90 Mins,90 - 105 Mins,105 - 120 Mins,120 - 135 Mins,135 - 150 Mins,150 - 165 Mins,165 - 180 Mins,180 - 195 Mins,195 - 210 Mins,210 - 225 Mins,225 - 240 Mins,240 - 255 Mins,255 - 270 Mins,270 - 285 Mins,285 - 300 Mins,300 - 315 Mins,315 - 330 Mins,330 - 345 Mins,345 - 360 Mins,360 - 375 Mins,375 - 390 Mins,390 - 405 Mins,405 - 420 Mins,420 - 435 Mins,435 - 450 Mins,450 - 465 Mins,465 - 480 Mins,480 - 495 Mins,495 - 510 Mins,510 - 525 Mins,525 - 540 Mins,540 - 555 Mins,555 - 570 Mins,570 - 585 Mins,585 - 600 Mins,600 - 615 Mins,615 - 630 Mins,630 - 645 Mins,645 - 660 Mins,660 - 675 Mins
Pilot1,EGLL / LHR / N/A - LEMD / MAD / N/A,01/01/2015 04:30,01/01/2015 11:20,01/01/2015,04:30,01/01/2015,11:20,4.57,4.62,4.68,4.74,4.79,4.85,4.90,4.95,4.99,5.03,5.07,5.10,5.13,5.16,5.18,5.20,5.21,5.22,5.23,5.23,5.23,5.23,5.23,5.22,5.22,5.21,5.19,,,,,,,,,,,,,,,,,,
Pilot1,LEMD / MAD / N/A - KJFK / JFK / N/A,02/01/2015 16:10,03/01/2015 03:20,02/01/2015,16:10,03/01/2015,03:20,2.39,2.44,2.49,2.55,2.60,2.67,2.73,2.80,2.88,2.95,3.03,3.12,3.21,3.30,3.39,3.49,3.59,3.69,3.80,3.91,4.02,9.00,9.00,9.00,9.00,6.28,5.10,4.74,4.60,4.55,4.64,4.68,4.73,4.79,4.92,5.00,5.09,5.17,5.30,5.39,5.47,5.56,5.67,5.76,
Pilot1,KJFK / JFK / N/A - EGLL / LHR / N/A,03/01/2015 23:30,04/01/2015 06:00,03/01/2015,23:30,04/01/2015,06:00,3.99,4.09,4.18,4.27,4.35,4.53,4.63,4.72,4.81,4.98,5.08,5.17,5.26,5.38,5.49,5.60,5.70,9.00,5.91,5.95,6.02,6.13,6.21,6.28,6.35,6.44,,,,,,,,,,,,,,,,,,,
Pilot1,EGLL / LHR / N/A - EGLL / LHR / N/A,05/01/2015 12:30,05/01/2015 18:25,05/01/2015,12:30,05/01/2015,18:25,2.94,2.94,2.93,2.93,2.94,2.94,2.94,2.95,2.96,2.97,2.98,2.99,3.01,3.03,3.05,3.07,3.10,3.13,3.17,3.21,3.25,3.29,3.34,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,01/01/2015 19:53,02/01/2015 06:00,01/01/2015,19:53,02/01/2015,06:00,2.19,2.19,2.20,2.21,2.22,2.24,2.25,2.27,2.29,2.32,2.35,2.38,2.41,2.45,2.49,2.53,2.58,2.63,2.69,2.75,2.81,2.88,2.95,3.02,3.10,3.19,3.27,3.36,3.45,3.55,3.65,3.75,3.85,3.96,4.07,4.18,4.29,4.41,4.52,4.64,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,02/01/2015 13:01,02/01/2015 19:25,02/01/2015,13:01,02/01/2015,19:25,5.54,5.58,5.62,5.66,9.00,7.41,6.09,5.81,5.70,5.66,5.64,5.63,5.63,5.64,5.64,5.65,5.65,5.65,5.66,5.66,5.66,5.66,5.66,5.66,5.67,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,03/01/2015 10:10,03/01/2015 13:14,03/01/2015,10:10,03/01/2015,13:14,5.28,5.36,5.45,5.53,5.61,5.69,5.77,5.84,5.91,5.97,6.03,6.09,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,04/01/2015 00:01,04/01/2015 03:20,04/01/2015,00:01,04/01/2015,03:20,3.93,3.99,4.05,4.11,4.18,4.25,4.32,4.40,4.48,4.57,4.66,4.75,4.84,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYEG / YEG / N/A,05/01/2015 10:42,05/01/2015 17:07,05/01/2015,10:42,05/01/2015,17:07,4.88,4.96,5.04,5.12,5.20,5.27,5.34,5.41,5.48,9.00,9.00,9.00,9.00,9.00,9.00,9.00,9.00,8.25,6.43,5.65,5.26,5.05,4.91,4.83,4.77,,,,,,,,,,,,,,,,

Reference,Duty,Duty Start,Duty End,Duty Start Date,Duty Start Time,Duty End Date,Duty End Time,00 - 15 Mins,15 - 30 Mins,30 - 45 Mins,45 - 60 Mins,60 - 75 Mins,75 - 90 Mins,90 - 105 Mins,105 - 120 Mins,120 - 135 Mins,135 - 150 Mins,150 - 165 Mins,165 - 180 Mins,180 - 195 Mins,195 - 210 Mins,210 - 225 Mins,225 - 240 Mins,240 - 255 Mins,255 - 270 Mins,270 - 285 Mins,285 - 300 Mins,300 - 315 Mins,315 - 330 Mins,330 - 345 Mins,345 - 360 Mins,360 - 375 Mins,375 - 390 Mins,390 - 405 Mins,405 - 420 Mins,420 - 435 Mins,435 - 450 Mins,450 - 465 Mins,465 - 480 Mins,480 - 495 Mins,495 - 510 Mins,510 - 525 Mins,525 - 540 Mins,540 - 555 Mins,555 - 570 Mins,570 - 585 Mins,585 - 600 Mins,600 - 615 Mins,615 - 630 Mins,630 - 645 Mins,645 - 660 Mins,660 - 675 Mins
Pilot1,EGLL / LHR / N/A - LEMD / MAD / N/A,01/01/2015 04:30,01/01/2015 11:20,01/01/2015,04:30,01/01/2015,11:20,0.04,0.04,0.05,0.05,0.05,0.06,0.06,0.06,0.06,0.07,0.07,0.07,0.07,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,,,,,,,,,,,,,,,,,,
Pilot1,LEMD / MAD / N/A - KJFK / JFK / N/A,02/01/2015 16:10,03/01/2015 03:20,02/01/2015,16:10,03/01/2015,03:20,0.00,0.00,0.00,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.02,0.02,0.02,0.02,0.02,1.26,1.26,1.26,1.26,0.22,0.07,0.05,0.04,0.04,0.05,0.05,0.05,0.05,0.06,0.07,0.07,0.08,0.09,0.10,0.10,0.11,0.13,0.14,
Pilot1,KJFK / JFK / N/A - EGLL / LHR / N/A,03/01/2015 23:30,04/01/2015 06:00,03/01/2015,23:30,04/01/2015,06:00,0.02,0.03,0.03,0.03,0.03,0.04,0.04,0.05,0.05,0.06,0.07,0.08,0.08,0.09,0.11,0.12,0.13,1.26,0.16,0.16,0.18,0.19,0.21,0.22,0.23,0.25,,,,,,,,,,,,,,,,,,,
Pilot1,EGLL / LHR / N/A - EGLL / LHR / N/A,05/01/2015 12:30,05/01/2015 18:25,05/01/2015,12:30,05/01/2015,18:25,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,01/01/2015 19:53,02/01/2015 06:00,01/01/2015,19:53,02/01/2015,06:00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.02,0.02,0.02,0.02,0.03,0.03,0.03,0.04,0.04,0.05,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,02/01/2015 13:01,02/01/2015 19:25,02/01/2015,13:01,02/01/2015,19:25,0.11,0.12,0.12,0.12,1.26,0.52,0.19,0.14,0.13,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.13,0.13,0.13,0.13,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,03/01/2015 10:10,03/01/2015 13:14,03/01/2015,10:10,03/01/2015,13:14,0.09,0.09,0.10,0.11,0.12,0.13,0.14,0.15,0.16,0.17,0.18,0.19,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,04/01/2015 00:01,04/01/2015 03:20,04/01/2015,00:01,04/01/2015,03:20,0.02,0.02,0.02,0.03,0.03,0.03,0.03,0.04,0.04,0.04,0.05,0.05,0.06,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYEG / YEG / N/A,05/01/2015 10:42,05/01/2015 17:07,05/01/2015,10:42,05/01/2015,17:07,0.06,0.06,0.07,0.07,0.08,0.09,0.09,0.10,0.10,1.26,1.26,1.26,1.26,1.26,1.26,1.26,1.26,0.80,0.25,0.12,0.08,0.07,0.06,0.05,0.05,,,,,,,,,,,,,,,,

Reference,Duty,Duty Start,Duty End,Duty Start Date,Duty Start Time,Duty End Date,Duty End Time,00 - 15 Mins,15 - 30 Mins,30 - 45 Mins,45 - 60 Mins,60 - 75 Mins,75 - 90 Mins,90 - 105 Mins,105 - 120 Mins,120 - 135 Mins,135 - 150 Mins,150 - 165 Mins,165 - 180 Mins,180 - 195 Mins,195 - 210 Mins,210 - 225 Mins,225 - 240 Mins,240 - 255 Mins,255 - 270 Mins,270 - 285 Mins,285 - 300 Mins,300 - 315 Mins,315 - 330 Mins,330 - 345 Mins,345 - 360 Mins,360 - 375 Mins,375 - 390 Mins,390 - 405 Mins,405 - 420 Mins,420 - 435 Mins,435 - 450 Mins,450 - 465 Mins,465 - 480 Mins,480 - 495 Mins,495 - 510 Mins,510 - 525 Mins,525 - 540 Mins,540 - 555 Mins,555 - 570 Mins,570 - 585 Mins,585 - 600 Mins,600 - 615 Mins,615 - 630 Mins,630 - 645 Mins,645 - 660 Mins,660 - 675 Mins
Pilot1,EGLL / LHR / N/A - LEMD / MAD / N/A,01/01/2015 04:30,01/01/2015 11:20,01/01/2015,04:30,01/01/2015,11:20,7.64,7.82,7.99,8.17,8.35,8.51,8.67,8.82,8.96,9.09,9.21,9.32,9.41,9.49,9.56,9.62,9.67,9.70,9.72,9.74,9.74,9.74,9.73,9.71,9.68,9.65,9.61,,,,,,,,,,,,,,,,,,
Pilot1,LEMD / MAD / N/A - KJFK / JFK / N/A,02/01/2015 16:10,03/01/2015 03:20,02/01/2015,16:10,03/01/2015,03:20,1.34,1.47,1.60,1.75,1.92,2.09,2.27,2.47,2.67,2.89,3.12,3.36,3.61,3.87,4.14,4.43,4.72,5.02,5.33,5.65,5.98,55.88,55.88,55.88,55.88,13.19,9.32,8.17,7.75,7.61,7.86,7.98,8.15,8.34,8.75,9.01,9.27,9.53,9.95,10.23,10.51,10.78,11.17,11.45,
Pilot1,KJFK / JFK / N/A - EGLL / LHR / N/A,03/01/2015 23:30,04/01/2015 06:00,03/01/2015,23:30,04/01/2015,06:00,5.90,6.18,6.46,6.73,6.98,7.54,7.84,8.12,8.40,8.93,9.24,9.55,9.84,10.20,10.56,10.91,11.26,55.88,11.95,12.09,12.32,12.69,12.95,13.20,13.45,13.74,,,,,,,,,,,,,,,,,,,
Pilot1,EGLL / LHR / N/A - EGLL / LHR / N/A,05/01/2015 12:30,05/01/2015 18:25,05/01/2015,12:30,05/01/2015,18:25,2.85,2.84,2.83,2.83,2.84,2.85,2.86,2.87,2.90,2.92,2.96,3.00,3.05,3.10,3.17,3.23,3.31,3.40,3.50,3.61,3.73,3.86,4.00,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,01/01/2015 19:53,02/01/2015 06:00,01/01/2015,19:53,02/01/2015,06:00,0.77,0.79,0.81,0.83,0.87,0.91,0.95,1.00,1.06,1.13,1.21,1.29,1.38,1.49,1.60,1.72,1.85,2.00,2.15,2.32,2.49,2.68,2.88,3.09,3.32,3.55,3.79,4.05,4.32,4.60,4.88,5.18,5.49,5.81,6.13,6.46,6.80,7.15,7.50,7.86,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,02/01/2015 13:01,02/01/2015 19:25,02/01/2015,13:01,02/01/2015,19:25,10.73,10.86,10.99,11.12,55.88,17.17,12.54,11.60,11.26,11.12,11.06,11.04,11.03,11.04,11.06,11.07,11.09,11.10,11.11,11.12,11.13,11.13,11.13,11.14,11.14,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,03/01/2015 10:10,03/01/2015 13:14,03/01/2015,10:10,03/01/2015,13:14,9.89,10.16,10.43,10.70,10.96,11.22,11.47,11.71,11.94,12.15,12.36,12.55,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,04/01/2015 00:01,04/01/2015 03:20,04/01/2015,00:01,04/01/2015,03:20,5.73,5.89,6.06,6.25,6.45,6.67,6.89,7.13,7.38,7.65,7.92,8.21,8.51,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYEG / YEG / N/A,05/01/2015 10:42,05/01/2015 17:07,05/01/2015,10:42,05/01/2015,17:07,8.61,8.86,9.11,9.37,9.62,9.86,10.09,10.32,10.54,55.88,55.88,55.88,55.88,55.88,55.88,55.88,55.88,20.34,13.70,11.08,9.84,9.14,8.72,8.44,8.26,,,,,,,,,,,,,,,,

Reference,Duty,Duty Start,Duty End,Duty Start Date,Duty Start Time,Duty End Date,Duty End Time,00 - 15 Mins,15 - 30 Mins,30 - 45 Mins,45 - 60 Mins,60 - 75 Mins,75 - 90 Mins,90 - 105 Mins,105 - 120 Mins,120 - 135 Mins,135 - 150 Mins,150 - 165 Mins,165 - 180 Mins,180 - 195 Mins,195 - 210 Mins,210 - 225 Mins,225 - 240 Mins,240 - 255 Mins,255 - 270 Mins,270 - 285 Mins,285 - 300 Mins,300 - 315 Mins,315 - 330 Mins,330 - 345 Mins,345 - 360 Mins,360 - 375 Mins,375 - 390 Mins,390 - 405 Mins,405 - 420 Mins,420 - 435 Mins,435 - 450 Mins,450 - 465 Mins,465 - 480 Mins,480 - 495 Mins,495 - 510 Mins,510 - 525 Mins,525 - 540 Mins,540 - 555 Mins,555 - 570 Mins,570 - 585 Mins,585 - 600 Mins,600 - 615 Mins,615 - 630 Mins,630 - 645 Mins,645 - 660 Mins,660 - 675 Mins
Pilot1,EGLL / LHR / N/A - LEMD / MAD / N/A,01/01/2015 04:30,01/01/2015 11:20,01/01/2015,04:30,01/01/2015,11:20,49.63,51.25,52.92,54.61,56.28,57.92,59.51,61.03,62.48,63.83,65.08,66.22,67.25,68.16,68.94,69.61,70.15,70.46,70.73,70.88,70.93,70.89,70.75,70.53,70.24,69.88,69.48,,,,,,,,,,,,,,,,,,
Pilot1,LEMD / MAD / N/A - KJFK / JFK / N/A,02/01/2015 16:10,03/01/2015 03:20,02/01/2015,16:10,03/01/2015,03:20,6.58,7.24,7.97,8.77,9.63,10.57,11.58,12.68,13.85,15.11,16.47,17.91,19.45,21.10,22.85,24.71,26.68,28.77,30.98,33.32,35.79,0.00,0.00,0.00,0.00,119.72,66.24,54.58,50.62,49.35,51.66,52.80,54.36,56.19,60.32,62.95,65.69,68.51,73.27,76.64,80.06,83.52,88.54,92.39,
Pilot1,KJFK / JFK / N/A - EGLL / LHR / N/A,03/01/2015 23:30,04/01/2015 06:00,03/01/2015,23:30,04/01/2015,06:00,35.19,37.40,39.60,41.77,43.92,48.74,51.45,54.15,56.84,62.19,65.46,68.73,72.00,76.27,80.66,85.17,89.79,0.00,99.56,101.70,105.31,111.11,115.51,119.91,124.28,129.68,,,,,,,,,,,,,,,,,,,
Pilot1,EGLL / LHR / N/A - EGLL / LHR / N/A,05/01/2015 12:30,05/01/2015 18:25,05/01/2015,12:30,05/01/2015,18:25,14.85,14.81,14.79,14.79,14.81,14.85,14.93,15.02,15.15,15.31,15.51,15.75,16.04,16.38,16.76,17.14,17.63,18.17,18.77,19.45,20.19,21.02,21.92,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,01/01/2015 19:53,02/01/2015 06:00,01/01/2015,19:53,02/01/2015,06:00,3.70,3.78,3.89,4.02,4.19,4.38,4.61,4.87,5.17,5.51,5.90,6.33,6.81,7.35,7.94,8.59,9.30,10.08,10.93,11.85,12.84,13.91,15.06,16.30,17.65,19.08,20.62,22.25,24.00,25.86,27.83,29.93,32.15,34.51,37.00,39.63,42.41,45.34,48.42,51.67,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,02/01/2015 13:01,02/01/2015 19:25,02/01/2015,13:01,02/01/2015,19:25,82.79,84.52,86.25,87.94,0.00,217.40,108.68,94.55,89.83,87.89,87.07,86.79,86.77,86.90,87.08,87.28,87.50,87.66,87.80,87.91,87.99,88.05,88.09,88.13,88.18,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,03/01/2015 10:10,03/01/2015 13:14,03/01/2015,10:10,03/01/2015,13:14,72.58,75.76,79.06,82.42,85.84,89.27,92.69,96.09,99.42,102.68,105.83,108.85,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,04/01/2015 00:01,04/01/2015 03:20,04/01/2015,00:01,04/01/2015,03:20,33.92,35.14,36.48,37.95,39.55,41.28,43.16,45.19,47.38,49.73,52.24,54.95,57.85,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYEG / YEG / N/A,05/01/2015 10:42,05/01/2015 17:07,05/01/2015,10:42,05/01/2015,17:07,58.85,61.41,64.06,66.77,69.52,72.28,75.02,77.73,80.38,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,376.87,128.90,87.43,72.03,64.37,59.98,57.24,55.45,,,,,,,,,,,,,,,,

Reference,Duty,Duty Start,Duty End,Duty Start Date,Duty Start Time,Duty End Date,Duty End Time,00 - 15 Mins,15 - 30 Mins,30 - 45 Mins,45 - 60 Mins,60 - 75 Mins,75 - 90 Mins,90 - 105 Mins,105 - 120 Mins,120 - 135 Mins,135 - 150 Mins,150 - 165 Mins,165 - 180 Mins,180 - 195 Mins,195 - 210 Mins,210 - 225 Mins,225 - 240 Mins,240 - 255 Mins,255 - 270 Mins,270 - 285 Mins,285 - 300 Mins,300 - 315 Mins,315 - 330 Mins,330 - 345 Mins,345 - 360 Mins,360 - 375 Mins,375 - 390 Mins,390 - 405 Mins,405 - 420 Mins,420 - 435 Mins,435 - 450 Mins,450 - 465 Mins,465 - 480 Mins,480 - 495 Mins,495 - 510 Mins,510 - 525 Mins,525 - 540 Mins,540 - 555 Mins,555 - 570 Mins,570 - 585 Mins,585 - 600 Mins,600 - 615 Mins,615 - 630 Mins,630 - 645 Mins,645 - 660 Mins,660 - 675 Mins
Pilot1,EGLL / LHR / N/A - LEMD / MAD / N/A,01/01/2015 04:30,01/01/2015 11:20,01/01/2015,04:30,01/01/2015,11:20,22.48,23.06,23.65,24.24,24.82,25.39,25.94,26.46,26.95,27.41,27.83,28.21,28.55,28.85,29.11,29.33,29.51,29.61,29.69,29.75,29.76,29.75,29.70,29.63,29.53,29.42,29.29,,,,,,,,,,,,,,,,,,
Pilot1,LEMD / MAD / N/A - KJFK / JFK / N/A,02/01/2015 16:10,03/01/2015 03:20,02/01/2015,16:10,03/01/2015,03:20,7.83,8.02,8.23,8.47,8.73,9.01,9.32,9.66,10.03,10.44,10.87,11.35,11.86,12.41,13.00,13.64,14.32,15.05,15.83,16.66,17.54,99.24,99.24,99.24,99.24,43.35,28.22,24.23,22.83,22.38,23.20,23.60,24.15,24.79,26.21,27.11,28.03,28.97,30.52,31.59,32.66,33.71,35.20,36.31,
Pilot1,KJFK / JFK / N/A - EGLL / LHR / N/A,03/01/2015 23:30,04/01/2015 06:00,03/01/2015,23:30,04/01/2015,06:00,17.33,18.12,18.90,19.68,20.45,22.17,23.13,24.08,25.01,26.85,27.95,29.04,30.11,31.47,32.84,34.21,35.57,99.24,38.30,38.87,39.82,41.29,42.36,43.39,44.39,45.57,,,,,,,,,,,,,,,,,,,
Pilot1,EGLL / LHR / N/A - EGLL / LHR / N/A,05/01/2015 12:30,05/01/2015 18:25,05/01/2015,12:30,05/01/2015,18:25,10.35,10.34,10.33,10.33,10.34,10.35,10.38,10.41,10.45,10.50,10.56,10.64,10.74,10.85,10.97,11.10,11.25,11.43,11.63,11.86,12.11,12.38,12.69,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,01/01/2015 19:53,02/01/2015 06:00,01/01/2015,19:53,02/01/2015,06:00,7.01,7.04,7.07,7.10,7.15,7.20,7.27,7.34,7.42,7.52,7.63,7.76,7.89,8.05,8.22,8.42,8.63,8.86,9.12,9.41,9.71,10.05,10.42,10.82,11.26,11.73,12.25,12.80,13.40,14.04,14.73,15.46,16.25,17.08,17.97,18.92,19.91,20.96,22.06,23.20,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,02/01/2015 13:01,02/01/2015 19:25,02/01/2015,13:01,02/01/2015,19:25,33.49,34.01,34.53,35.03,99.24,59.14,40.68,36.92,35.58,35.01,34.77,34.69,34.68,34.72,34.78,34.83,34.90,34.95,34.99,35.02,35.04,35.06,35.07,35.09,35.10,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYXE / YXE / N/A,03/01/2015 10:10,03/01/2015 13:14,03/01/2015,10:10,03/01/2015,13:14,30.29,31.31,32.35,33.38,34.41,35.42,36.40,37.35,38.26,39.13,39.96,40.72,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYXE / YXE / N/A - CYYC / YYC / N/A,04/01/2015 00:01,04/01/2015 03:20,04/01/2015,00:01,04/01/2015,03:20,16.87,17.31,17.79,18.31,18.89,19.51,20.18,20.90,21.68,22.52,23.40,24.35,25.36,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Pilot2,CYYC / YYC / N/A - CYEG / YEG / N/A,05/01/2015 10:42,05/01/2015 17:07,05/01/2015,10:42,05/01/2015,17:07,25.71,26.58,27.48,28.39,29.30,30.20,31.08,31.93,32.76,99.24,99.24,99.24,99.24,99.24,99.24,99.24,99.24,70.04,45.40,34.88,30.12,27.59,26.10,25.15,24.53,,,,,,,,,,,,,,,,

Reference,Sleep Start Date (Date \ Time),Sleep End (Date \ Time),Sleep Start Date,Sleep Start Time,Sleep End Date,Sleep End Time
Pilot1,31/12/2014 00:00,31/12/2014 08:00,31/12/2014,00:00,31/12/2014,08:00
Pilot1,31/12/2014 21:56,01/01/2015 01:50,31/12/2014,21:56,01/01/2015,01:50
Pilot1,01/01/2015 13:20,01/01/2015 14:01,01/01/2015,13:20,01/01/2015,14:01
Pilot1,01/01/2015 23:33,02/01/2015 07:39,01/01/2015,23:33,02/01/2015,07:39
Pilot1,02/01/2015 21:28,02/01/2015 22:31,02/01/2015,21:28,02/01/2015,22:31
Pilot1,03/01/2015 05:51,03/01/2015 12:39,03/01/2015,05:51,03/01/2015,12:39
Pilot1,04/01/2015 03:59,04/01/2015 04:00,04/01/2015,03:59,04/01/2015,04:00
Pilot1,04/01/2015 08:00,04/01/2015 12:50,04/01/2015,08:00,04/01/2015,12:50
Pilot1,05/01/2015 00:56,05/01/2015 08:27,05/01/2015,00:56,05/01/2015,08:27
Pilot1,06/01/2015 00:28,06/01/2015 08:24,06/01/2015,00:28,06/01/2015,08:24
Pilot1,07/01/2015 00:19,07/01/2015 08:16,07/01/2015,00:19,07/01/2015,08:16
Pilot1,08/01/2015 00:13,08/01/2015 08:11,08/01/2015,00:13,08/01/2015,08:11
Pilot1,09/01/2015 00:09,09/01/2015 08:07,09/01/2015,00:09,09/01/2015,08:07
Pilot1,10/01/2015 00:06,10/01/2015 08:05,10/01/2015,00:06,10/01/2015,08:05
Pilot2,31/12/2014 07:00,31/12/2014 15:00,31/12/2014,07:00,31/12/2014,15:00
Pilot2,01/01/2015 06:47,01/01/2015 14:40,01/01/2015,06:47,01/01/2015,14:40
Pilot2,02/01/2015 08:00,02/01/2015 10:21,02/01/2015,08:00,02/01/2015,10:21
Pilot2,02/01/2015 13:35,02/01/2015 14:55,02/01/2015,13:35,02/01/2015,14:55
Pilot2,02/01/2015 14:05,02/01/2015 14:25,02/01/2015,14:05,02/01/2015,14:25
Pilot2,03/01/2015 04:28,03/01/2015 07:30,03/01/2015,04:28,03/01/2015,07:30
Pilot2,03/01/2015 15:14,03/01/2015 16:57,03/01/2015,15:14,03/01/2015,16:57
Pilot2,04/01/2015 06:51,04/01/2015 14:51,04/01/2015,06:51,04/01/2015,14:51
Pilot2,05/01/2015 04:37,05/01/2015 08:02,05/01/2015,04:37,05/01/2015,08:02
Pilot2,05/01/2015 12:35,05/01/2015 15:35,05/01/2015,12:35,05/01/2015,15:35
Pilot2,05/01/2015 13:05,05/01/2015 15:05,05/01/2015,13:05,05/01/2015,15:05
Pilot2,06/01/2015 06:56,06/01/2015 14:56,06/01/2015,06:56,06/01/2015,14:56
Pilot2,07/01/2015 06:57,07/01/2015 14:57,07/01/2015,06:57,07/01/2015,14:57
Pilot2,08/01/2015 06:58,08/01/2015 14:58,08/01/2015,06:58,08/01/2015,14:58
Pilot2,09/01/2015 06:58,09/01/2015 14:58,09/01/2015,06:58,09/01/2015,14:58
Pilot2,10/01/2015 06:59,10/01/2015 14:59,10/01/2015,06:59,10/01/2015,14:59

Reference,On duty date,On duty time,Start airport,Off duty date,Off duty time,End airport,Sectors,Crew composition,Sleep count,Sleep order,Sleep class,Home base,On partial augment date,On partial augment time,Off partial augment date,Off partial augment time,First sleep start date,First sleep start time,First sleep finish date,First sleep finish time,Second sleep start date,Second sleep start time,Second sleep finish date,Second sleep finish time,Max SP,Max KSS,Max AS,Max KP,Max VD,Max CRD,Max PMR,Time above,% above,Max SOD (SP),Max EOD (SP),Max TOC (SP),Max TOD (SP),Max TOC date,Max TOC time,Max TOD date,Max TOD time,Risk score,Alert Time
Pilot1,01/01/2015,04:30,EGLL / LHR / N/A,01/01/2015,11:20,LEMD / MAD / N/A,1,2,0,0,0,EGLL / LHR / N/A,,,,,,,,,,,,,4.06,5.23,35.67,0.08,9.74,70.93,29.76,0,0,3.60,4.04,,,,,,,5.81352417346066,09:45
Pilot1,02/01/2015,16:10,LEMD / MAD / N/A,03/01/2015,03:20,KJFK / JFK / N/A,1,3,1,2,1,EGLL / LHR / N/A,,,,,,,,,,,,,4.43,5.76,28.71,0.14,11.45,92.39,36.31,0,0,2.09,4.43,,,,,,,4.93160563663886,03:10
Pilot1,03/01/2015,23:30,KJFK / JFK / N/A,04/01/2015,06:00,EGLL / LHR / N/A,1,3,1,3,1,EGLL / LHR / N/A,,,,,,,,,,,,,4.90,6.44,19.69,0.25,13.74,129.68,45.57,45,11.53846,3.20,4.90,,,,,,,8.02928587201004,06:00
Pilot1,05/01/2015,12:30,EGLL / LHR / N/A,05/01/2015,18:25,EGLL / LHR / N/A,1,2,0,0,0,EGLL / LHR / N/A,,,,,,,,,,,,,2.75,3.34,60.80,0.01,4.00,21.92,12.69,0,0,2.46,2.75,,,,,,,0.667298195842046,18:15
Pilot2,01/01/2015,19:53,CYYC / YYC / N/A,02/01/2015,06:00,CYXE / YXE / N/A,1,2,0,0,0,CYYC / YYC / N/A,,,,,,,,,,,,,3.65,4.64,43.61,0.05,7.86,51.67,23.20,0,0,1.94,3.65,,,,,,,1.62404923619812,05:53
Pilot2,02/01/2015,13:01,CYXE / YXE / N/A,02/01/2015,19:25,CYYC / YYC / N/A,2,3,1,0,1,CYYC / YYC / N/A,,,,,02/01/2015,13:35,02/01/2015,14:55,,,,,4.46,5.81,28.09,0.14,11.60,94.55,36.92,0,0,4.28,4.36,,,,,,,-22,15:01
Pilot2,03/01/2015,10:10,CYYC / YYC / N/A,03/01/2015,13:14,CYXE / YXE / N/A,1,2,0,0,0,CYYC / YYC / N/A,,,,,,,,,,,,,4.66,6.09,24.33,0.19,12.55,108.85,40.72,0,0,4.09,4.66,,,,,,,5.46991663374264,13:10
Pilot2,04/01/2015,00:01,CYXE / YXE / N/A,04/01/2015,03:20,CYYC / YYC / N/A,1,2,0,0,0,CYYC / YYC / N/A,,,,,,,,,,,,,3.79,4.84,40.85,0.06,8.51,57.85,25.36,0,0,3.16,3.79,,,,,,,1.72863473904964,03:16
Pilot2,05/01/2015,10:42,CYYC / YYC / N/A,05/01/2015,17:07,CYEG / YEG / N/A,1,2,1,0,1,CYYC / YYC / N/A,,,,,05/01/2015,12:35,05/01/2015,15:35,,,,,4.35,5.65,30.17,0.12,11.08,87.43,34.88,0,0,3.81,3.74,,,,,,,3.99250327907951,15:42

Metric,Value
Maximum fatigue score in the roster (SP),4.90
Maximum fatigue score at start of duty (SP),3.60
Maximum fatigue score at end of duty (SP),4.66
,
Total # Schedules,2
# Schedules which include fatigue scores above 4.77 (SP),1.00
% Schedules which include fatigue scores above 4.77 (SP),50.00
,
Total # Duties,9
# Duties which include fatigue scores above 4.77 (SP),1.00
% Duties which include fatigue scores above 4.77 (SP),11.11
,
Metric,Name,Value,Max SP Score
% Time where fatigue scores are above 4.77 (SP),Pilot1,2.70,4.90
% Time where fatigue scores are above 4.77 (SP),Pilot2,0.00,4.66
,
Fatigue (SP),# Duties,# Crew
1.00 - 1.99,0,0
2.00 - 2.99,1,1
3.00 - 3.99,2,1
4.00 - 4.69,5,2
4.70 - 4.99,1,1
5.00 - 5.09,0,0
5.10 - 5.19,0,0
5.20 - 5.29,0,0
5.30 - 5.39,0,0
5.40 - 5.49,0,0
5.50 - 5.59,0,0
5.60 - 5.69,0,0
5.70 - 5.79,0,0
5.80 - 5.89,0,0
5.90 - 5.99,0,0
6.00 - 6.49,0,0
6.50 - 7.00,0,0

137267,137268

Results breakdown

Each comma-separated number listed from the 8th column, starting from the second row, indicates the fatigue score (based on the scale you chose) at 15-minute intervals. The interval list is based on duty start and end times. The intervals are listed in the first row, also starting from the 8th column. Compare the score against the description of the scale given in Fatigue and Risk Scales.