{
  "Name": "RunPlan Export",
  "Files": [
    {
      "Scope": "Championships.Events.Sessions.SessionCars",
      "FileNameTemplate": "C:\\HHDM-Export\\Excel\\{Session.Event.Name}-{Session.Name}-{Car.Number}RunPlanExport.xlsx",
      "DeleteWorkbookBeforeExporting": true,
      "Name": "New Excel Export File",
      "WorkSheets": [
        {
          "Name": "Sheet1",
          "Scope": "RunPlans",
          "WorksheetNameTemplate": "{Name}",
          "TemplateWorksheetName": "Sheet1",
          "Cells": [
            {
              "Name": "Session ",
              "Id": "d0bd3ed7-d60b-4d45-b394-e29570ac2dc6",
              "Value": "{Concatenate(Session.Name,\":\",DateTimeToString(Session.StartTime,\"HH:mm\"),\"-\",DateTimeToString(Session.EndTime,\"HH:mm\"))}",
              "ExcelValueType": 0,
              "RowIndex": 1,
              "ColumnIndex": 2,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Plan Name",
              "Id": "3d2cf951-d9f6-46cf-b0de-cb3eca2a2d71",
              "Value": "{Name}",
              "ExcelValueType": 0,
              "RowIndex": 2,
              "ColumnIndex": 2,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Notes",
              "Id": "6a34a91f-45ac-4f5c-9ae0-61a34b211bb3",
              "Value": "{SessionCarData.RunPlanNotes}",
              "ExcelValueType": 0,
              "RowIndex": 3,
              "ColumnIndex": 2,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Planned Runs",
              "Id": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Scope": "PlannedRuns",
              "ExcelValueType": 0,
              "RowIndex": 6,
              "ColumnIndex": 0,
              "RowLinearTerm": 2,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 1,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Run #",
              "Id": "becf9f19-d97d-4c79-826e-69a333b29516",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{RunNumber}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 1,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Laps #",
              "Id": "90449506-1996-40db-b761-1a357feeb400",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{If(RunPlan.IsLapMode,Count(PlannedLaps), TotalLaps)}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 2,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Driver",
              "Id": "1f289c37-42e3-470a-ac29-04e3677cce31",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{Driver.NickName}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 3,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Tyre Set",
              "Id": "24b74be9-a55e-4b7d-baf2-7543462b2866",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{TyreSet.Name}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 4,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Tyre Specs",
              "Id": "55076b1e-f5bd-49f7-b648-0c6e5600e43a",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 5,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "FL",
              "Id": "ea507833-fe8d-4d58-bf6c-22d798f02b15",
              "ParentId": "55076b1e-f5bd-49f7-b648-0c6e5600e43a",
              "Value": "{TyreSet.FLTyre.Tyre.TyreSpecification.Name}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 0,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "FR",
              "Id": "9b89921d-c8c4-4880-b60f-d8c233d1aa24",
              "ParentId": "55076b1e-f5bd-49f7-b648-0c6e5600e43a",
              "Value": "{TyreSet.FRTyre.Tyre.TyreSpecification.Name}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 1,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "RL",
              "Id": "929e0e6b-a67e-4a37-b04b-34a4ab0252aa",
              "ParentId": "55076b1e-f5bd-49f7-b648-0c6e5600e43a",
              "Value": "{TyreSet.RLTyre.Tyre.TyreSpecification.Name}",
              "ExcelValueType": 0,
              "RowIndex": 1,
              "ColumnIndex": 0,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "RR",
              "Id": "549a0d08-9bae-44c1-875f-731aa368adf8",
              "ParentId": "55076b1e-f5bd-49f7-b648-0c6e5600e43a",
              "Value": "{TyreSet.RRTyre.Tyre.TyreSpecification.Name}",
              "ExcelValueType": 0,
              "RowIndex": 1,
              "ColumnIndex": 1,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Tyre Laps SOR",
              "Id": "f6d3a553-75b4-499d-a833-e63069a9d142",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 7,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "FL",
              "Id": "e6294ae2-17e7-439b-9e19-9df6cf04e35f",
              "ParentId": "f6d3a553-75b4-499d-a833-e63069a9d142",
              "Value": "{Round(PlannedRunFLTyreLapMileageSOR,0)}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 0,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "FR",
              "Id": "0952c15f-d8f9-4b9f-b078-48d2c106cedf",
              "ParentId": "f6d3a553-75b4-499d-a833-e63069a9d142",
              "Value": "{Round(PlannedRunFRTyreLapMileageSOR,0)}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 1,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "RL",
              "Id": "207e862f-528d-41f9-ae23-b7350c4a7a42",
              "ParentId": "f6d3a553-75b4-499d-a833-e63069a9d142",
              "Value": "{Round(PlannedRunRLTyreLapMileageSOR,0)}",
              "ExcelValueType": 0,
              "RowIndex": 1,
              "ColumnIndex": 0,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "RR",
              "Id": "55f5db9a-a7c9-43ac-baba-0a80870e6c24",
              "ParentId": "f6d3a553-75b4-499d-a833-e63069a9d142",
              "Value": "{Round(PlannedRunRRTyreLapMileageSOR,0)}",
              "ExcelValueType": 0,
              "RowIndex": 1,
              "ColumnIndex": 1,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Tyre Laps EOR",
              "Id": "1abe762f-da16-4e65-92f1-3a92b938fb96",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 9,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "FL",
              "Id": "5b961e65-b699-411a-a9a2-f2f1e4ccca72",
              "ParentId": "1abe762f-da16-4e65-92f1-3a92b938fb96",
              "Value": "{Round(PlannedRunFLTyreLapMileageEOR,0)}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 0,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "FR",
              "Id": "cfc2cfdd-f510-4a91-af17-fe3d950eb474",
              "ParentId": "1abe762f-da16-4e65-92f1-3a92b938fb96",
              "Value": "{Round(PlannedRunFRTyreLapMileageEOR,0)}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 1,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "RL",
              "Id": "8e46dbd0-8593-4b3e-afa4-acc72dfd0b0d",
              "ParentId": "1abe762f-da16-4e65-92f1-3a92b938fb96",
              "Value": "{Round(PlannedRunRLTyreLapMileageEOR,0)}",
              "ExcelValueType": 0,
              "RowIndex": 1,
              "ColumnIndex": 0,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "RR",
              "Id": "063882ee-c7e1-46d1-af9b-6cbe1db452f1",
              "ParentId": "1abe762f-da16-4e65-92f1-3a92b938fb96",
              "Value": "{Round(PlannedRunRRTyreLapMileageEOR,0)}",
              "ExcelValueType": 0,
              "RowIndex": 1,
              "ColumnIndex": 1,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Description",
              "Id": "dfd13e8a-aa06-41e7-b5ab-6e6ce09a46b6",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{Description}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 11,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Pit Time",
              "Id": "bd869311-c969-4ca4-89ce-2c9a71e2f08a",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{PitTime/86400}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 12,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Start Time",
              "Id": "c7ae6947-f869-440f-be98-7b2549ebe8da",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{CalculatedStartTimeOfDay/86400}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 13,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "End Time",
              "Id": "6bf49713-7b3b-4d79-97b6-fb3e9d04cab4",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{CalculatedEndTimeOfDay/86400}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 14,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Time Rem.",
              "Id": "759d1ab9-f334-4e1d-b24b-21d6b6336733",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{CalculatedSessionTimeRemaining/86400}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 15,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Full Tank",
              "Id": "1ea5e540-bef5-47f7-8641-b0eb40da9a6f",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{If(IsFullFill,\"þ\",\"¨\")}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 16,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Fuel Added",
              "Id": "32177d1f-2fb8-4675-b32f-648ce43db02c",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{DataBoundFuelAdded}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 17,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Fuel SOR",
              "Id": "dfb6db3c-d25a-4a59-9ad3-4f0ceeca3bba",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{DataBoundStartFuel}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 18,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "Fuel EOR",
              "Id": "d4dc5971-ca98-40bc-a9c5-4f9fc912f112",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{CalculatedEndFuel}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 19,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            },
            {
              "Name": "ChangesForNextRun",
              "Id": "b285de1e-a95c-4a35-970d-0435c1475ccf",
              "ParentId": "d205b093-722c-453a-a1d1-64d28e9f8723",
              "Value": "{ChangesForNextRun}",
              "ExcelValueType": 0,
              "RowIndex": 0,
              "ColumnIndex": 20,
              "RowLinearTerm": 0,
              "ColumnLinearTerm": 0,
              "ExcelCellCoordinateCalculationModeRow": 0,
              "ExcelCellCoordinateCalculationModeColumn": 0
            }
          ]
        }
      ],
      "DeleteWorkbookAfterExporting": false,
      "DeleteTemplateSheet": true,
      "CreatePDFAfterExporting": false,
      "TemplateWorkbookId": "251c59bc-9fbf-44b4-afae-53fee1a45e2b"
    }
  ]
}