This is the list of the available tables in our LPG excel add-in:
Trades
Allows you to have a comprehensive view of the cargo activities, including information such as quantity, loading or discharge location, loading and discharging dates as well as the players involved in the trades.
Filters
Our add-in allows you to filter trades using a variety of criteria. Here is an overview of the available filters:
Locations
Origins: Origin of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Destinations: Destination of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates
Origins: Start date of the trade. It is the end of the load if it occurred, or its Estimated Berth Departure if still to come.
Destination: End date of the port call. It is when the vessel is leaving the berth or the port/ anchorage/ canal if installation is unknown. If null, the port call is either yet to come or ongoing.
Vessels: Can be vessel names or vessel IMOs
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes SGC, VLGC, Handysize, MGC, LGC, and VLEC.
Players
Sellers: Seller of the cargo at the origin. It can be a list if multiple companies are potential sellers.
Buyers: Company buying the cargo on its delivery location.
Booleans
Intra-Country: Takes into account the trades within the selected region.
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
With Forecast: Include trades predicted by our in-house model.
Flows
Allows you to have the aggregated the results of the table trades and gives a gives a global view of LPG flows.
Filters
Our add-in allows you to filter flows using a variety of criteria. Here is an overview of the available filters:
Locations
Origins: Origin of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Destinations: Destination of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Flows Directions : Import, Export, Net Volume
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Unit: Different units available in this table: Kb, Kbd, Kt, Mt, MMbbl
Dates
Origins: Start date of the trade. It is the end of the load if it occurred, or its Estimated Berth Departure if still to come.
Destination: End date of the port call. It is when the vessel is leaving the berth or the port/ anchorage/ canal if installation is unknown. If null, the port call is either yet to come or ongoing.
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes SGC, VLGC, Handysize, MGC, LGC, and VLEC.
Splits: Allows you to breakdown the data by "Total", "Grades", "Products”, "Origin Countries", "Destination Countries", "Origin Continents", "Destination Continents", "Origin Subcontinents", "Destination Subcontinents", "Origin Trading Regions", "Destination Trading Regions", "Origin Ports", "Destination Ports", "Origin Padds", "Destination Padds", "Origin Installations", "Destination Installations", "Vessel Type", "Trade Status", "Sources", "Charterers", "Buyer", "Seller", "Routes".
Booleans
Intra-Country: Takes into account the trades within the selected region.
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
With Forecast: Include trades predicted by our in-house model.
Port Calls
Allows you to monitor the line up of vessels to do an operation at the port, country or regional level with their quantity and product information.
Filters
Our add-in allows you to filter port calls using a variety of criteria. Here is an overview of the available filters:
Zones: Zone of the port call. It can be a continent, a subcontinent, a region, a country, a port..
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the port calls.
Vessel: Can be vessel names or vessel IMOs
Booleans
Empty Volume: Provides access to the empty volume port calls. Only available via Freight subscription.
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
With Forecast: Include trades predicted by our in-house model.
Fleet Metrics
The fleet metrics table returns fleet data for a given zone.
Following metrics are available:
Floating storage
Commodity on water
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (daily, weekly, EIA-weekly basis ), and on a split level. With the ability to modify floating days for the floating storage query.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter fleet metrics using a variety of criteria. Here is an overview of the available filters:
Zones: Names of countries/geographical zones. Default to world if not specified.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Vessel: Can be vessel names or vessel IMOs
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes SGC, VLGC, Handysize, MGC, LGC, and VLEC.
Floating Days: Interval of the floating period duration.
Split: Allows you to breakdown the data by : "Total", "Grades", "Products", "Crude Quality", "Origin Countries", "Destination Countries", "Origin Continents", "Destination Continents", "Origin Subcontinents", "Destination Subcontinents", "Origin Trading Regions", "Destination Trading Regions", "Origin Ports", "Destination Ports", "Origin Installations", "Destination Installations", "Vessel Type", "Trade Status", "Sources", "Charterers", "Buyer", "Seller", "Current Continents", "Current Subcontinents", "Current Countries", "Current Subregions", "Current Seas", "Floating Days"]. Default to Total if not specified.
Booleans
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
Ship-to-Ships
The ship-to-ships table allows to monitor direct transfer of cargo between two vessels.
Filters
Our add-in allows you to filter ship-to-ships using a variety of criteria. Here is an overview of the available filters:
Zones: Names of countries/geographical zones. Default to world if not specified.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Vessel: Can be vessel names or vessel IMOs
Booleans
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
Bills of Lading
The Bills of Lading table allows clients to access structured Import & Export Bill of Lading documents’ data obtained directly from the U.S. Customs and Border Protection agency.
Filters
Our add-in allows you to filter Bills of Lading using a variety of criteria. Here is an overview of the available filters:
Source: All, US Export Bill, US Import Bill
Dates:
Bill date: Start/End of the period when BL was issued
Movement date: Start/End of the period when export or import took place
Bill numbers: Bill of Lading Number
Port Calls IDs: Port Call IDs
Ballast Capacity
The ballast capacity table gives access to future vessel availability based on vessel future ETA towards a destination or our forecast model.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (daily, weekly, monthly ), and on a split level. With the ability to select a specific metric.
There is a micro level called “List of Port Calls” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter ballast vessels using a variety of criteria. Here is an overview of the available filters:
Metric: Vessel count or Deadweight for the aggregated value
Zones: Names of countries/geographical zones. Default to world if not specified.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Period: Daily, weekly, monthly
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes SGC, VLGC, Handysize, MGC, LGC, and VLEC.
Split: Ability to break down the data by country, source, vessel type and total
Booleans
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription
Congestion
The congestion table gives access to the congestion of vessels that are waiting to do an operation (Loading/Discharge) at port level, country, and regional level.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (daily, weekly, monthly and yearly) and on a split level. With the ability to select a specific metric.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter congestions using a variety of criteria. Here is an overview of the available filters:
Metric: Vessel count or Deadweight for the aggregated value
Zones: Names of countries/geographical zones. Default to world if not specified.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Period: Daily, weekly, monthly, yearly
Waiting Days: Time measured in days spent by vessels in the waiting zone
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes SGC, VLGC, Handysize, MGC, LGC, and VLEC.
Split: Ability to break down the data by port, country, installation, vessel type, vessel operations, waiting status, product, grade and total
Booleans
Include all vessels in waiting: Include vessels in the waiting zone not tagged as congestion (lays ups, open vessels, floating storage, distressed cargoes, etc)
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription
Fleet Development
The fleet development monitors fleet supply through available vessels, deliveries, scrapping method, contracting and compliance method.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (monthly, quarterly, and yearly) and on a split level. With the ability to select a specific aggregated metric.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter fleet development using a variety of criteria. Here is an overview of the available filters:
Metric: Active vessels, delivered vessels, demolished vessels or ordered vessels.
Aggregated Metric: To aggregate the data by vessel deadweight, vessel capacity or by vessel count.
Dates: An interval of the start and the end of the period.
Period: monthly, quarterly, and yearly
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes SGC, VLGC, Handysize, MGC, LGC, and VLEC.
Split: Ability to break down the data by compliance method, vessel type and total
Booleans
Order Book: Access vessels in fleet orderbook, scheduled for future delivery.
Fleet Utilization
The fleet utilization analyses the entire vessel fleet and determines at any given point in time, which polygons (mapped zones) are the vessels located in, how many are loaded with cargo and how many are empty.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (daily, weekly, monthly, quarterly, and yearly) and on a split level. With the ability to select a specific metric.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter fleet utilization using a variety of criteria. Here is an overview of the available filters:
Metric: Vessel count or Deadweight for the aggregated value
Previous Zones: Names of zones (port/region/country/continent) the vessel is coming from.
Current Zones: Names of zones (port/region/country/continent) the vessel is currently.
Next Zones: Names of zones (port/region/country/continent) the vessel is going to.
Direction: Cardinality of the direction.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Period: Daily, weekly, monthly, quarterly and yearly
Vessels: Can be vessel names or vessel IMOs
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes SGC, VLGC, Handysize, MGC, LGC, and VLEC.
Split: Ability to break down the data by product, state, vessel type, current zone, previous zone, next zone, direction and total.
Booleans
Distinct Aggregation: Show or hide distinct vessels.
Freight Metrics
The freight metrics table gives you access to shipping ton-mile demand and sources of demand volatility & review average speed and distance traveled by vessel fleets.
There is a macro level called “Aggregated Values”, where the user can aggregate the data through different periods (monthly, quarterly, and yearly) and on a split level. With the ability to select a specific metric.
There is a micro level called “List of Vessels” where the user can retrieve data at the most granular level.
Filters
Our add-in allows you to filter freight metrics using a variety of criteria. Here is an overview of the available filters:
· Metric: Ton Miles, Ton Days, Average Speed or Average Distance
· Zones:
Origins: Origin of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Destinations: Destination of the trade. It can be a continent, a subcontinent, a region, a country, a port, an installation.
Products: Name of the commodity/product represented in our family tree: Family, Group, Product, Grade.
Dates: An interval of the start and the end of the period.
Period: monthly, quarterly and yearly
Vessels: Can be vessel names or vessel IMOs
Vessel Status: Loaded or Ballast
Vessel Types: Vessel classification based on the deadweight of the vessel. It includes SGC, VLGC, Handysize, MGC, LGC, and VLEC.
Split: Ability to break down the data by origin zones, destination zones, product, vessel type and total
Booleans
Freight View: Provides access to the entire fleet's trades, irrespective of your current cargo subscription. Only available via Freight subscription.
Contracts
The contracts table gives you access to a list of TUAs, LTAs, and Tenders for all LPG players, installations and zones.
Filters
Our add-in allows you to filter contracts using a variety of criteria. Here is an overview of the available filters:
Zones: It can be a continent, a subcontinent, a region, a country, a port or an installation.
Dates: An interval of the start and the end date of the beginning of the contract.
Players: Company buying or selling LPG. Actors of the contracts
Type: Type of the contract. It can be tenders, SPA, TUA or LTA