ID (KPI identifier)

M

Average Carriervisit Turnaround Time

GRAMMAR

KPI name

M

averagecarriervisitturnaroundtime

GRAMMAR

KPI type

M

OperationalPerformance

GRAMMAR

All kinds of carriers considered in the carrier definition

O

average time at terminal, average time at berth (for a vessel), average visit time, average service time

TIC Description

M

The average time spent by a carrier in the terminal area for picking and/or dropping a cargo.

TIC Description

O

This KPI refers to the average time that a carrier (vessel, truck, train, etc.) spends during drop-off and/or picking up activities depending on terminal operations. It represents the average time that the carrier spends within the terminal premises under the control of the terminal itself.

For this KPI related to trucks, the starting point is considered as the completion of the gate-in process at the terminal, and the endpoint for time calculation has been considered the completion of the gate-out process at the terminal.

For this KPI related to vessels, the starting point is located at the end of the mooring process upon arrival (timestamp of lastline), and the duration will be delimited by the end of the unmooring process during departure (timestamp of firstline).

For this KPI related to train:…

Datapoints:

For truck: tos|@|carriervisit|@|arrival|@|terminalgate|@|end|time|actual

tos|@|carriervisit|@|departure|@|terminalgate|@|end|time|actual

number of truck visits = COUNT(tos|@|carriervisit|@|type=truck)

For vessel: tos|@|carriervisit|@|arrival|@|mooring|@|lastline|time|actual

tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual

number of vessels visits = COUNT(tos|@|carriervisit|@|type=vessel)

Operator:

for trucks (SUM(tos|@|carriervisit|@|departure|@|terminalgate|@|end|time|) - (tos|@|carriervisit|@|arrival|@|terminalgate|@|end|time|))/(SUM(tos|@|carriervisit|@|type=truck))

for vessels: (SUM(tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual) - (tos|@|carriervisit|@|arrival|@|mooring|@|lastline|time|actual))/(SUM(tos|@|carriervisit|@|type=vessel))

Unit: minutes, hours

KPI Elements:

Timeframe: month 2024-01-01T00:00:00.000Z - 2024-01-31T23:59:00.000Z

Filter: tos|@|carriervisit|@|id|

Split: per vesseloperator, per truckoperator

Bucket: per berth, per flowtype

TIC Description

M

tos|@|carriervisit|@|arrival|@|terminalgate|@|end|time|actual

tos|@|carriervisit|@|departure|@|terminalgate|@|end|time|actual

tos|@|carriervisit|@|arrival|@|mooring|@|lastline|time|actual

tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual

TIC Description

terminal, Berth, carrier,

minute, hour

O

TIC Description

O

https://tic40.atlassian.net/l/cp/ZpGsxYZa, CarrierVisit, TerminalGate, Mooring , Arrival , Departure, Carrier

TIC Description

M

Determining the Average Carrier Turnaround Time of each vessel that has been operated at berth #1 in January 2024, differentiated by vessel operator.

TIC Description

M

Datapoints:

For vessel: tos|@|carriervisit|@|arrival|@|mooring|@|lastline|time|actual

tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual

number of vessels visits = COUNT(tos|@|carriervisit|@|type=vessel)

Operator: for vessels: (SUM(tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual) - (tos|@|carriervisit|@|arrival|@|mooring|@|lastline|time|actual))/(SUM(tos|@|carriervisit|@|type=vessel))

Unit: Hours

Filter: tos|@|carriervisit|@|arrival|@|working|logical|qualifier=berth|qualifierid=#1

Timeframe: month 2024-01-01T00:00:00.000Z - 2024-01-31T23:59:00.000Z

Split: per vesseloperator

Bucket: per month

TIC Description

M

average turnaround, average carrier turnaround time, average vessel turnaround time, average truck turnaround time

Technical

M

20240430

Technical

M

R0.1

Technical

Created by

Edited by

Review / Approve

Published

Valenciaport Foundation Gonzalo Sandiás

Francisco Blanquer Jaraiz Gonzalo Sandiás Corbillón, Jorge Melero