Requirement
Create reports to provide detailed analysis of liner shipping capacity over time.
Solution
BlueWater Reporting Capacity Extract and BlueWater Analytics.xlsm pivot table report
License Level Required
Global Corporate License.
Contact Sales for more information.

BlueWater Reporting Capacity Extract

   Generating a capacity extract is as easy as 1, 2, 3. First select the trade route definition you want to use. (See the note below for more information on trade route definitions.) Second, select what trade routes you want to include in the report. Third select what reporting periods you want included in the report. Currently, capacity data in BlueWater Reporting is available to January 2008.
   When you run the report, an Excel file will be created that should be saved in the c:/compair folder that was included in the BlueWater Starter Kit.
   A link is provided to the BlueWater Transit Extract so you can simultaneously run a transit analysis on the same trade routes. The BlueWater Analytics.xlsm Excel pivot table report included in the starter kit is used to analyze both capacity and transit times.
   After the extract is downloaded, you open the BlueWater Analytics.xlsm file that was included in the BlueWater Starter Kit and on the first (Refresh) sheet, click on the load button and then Refresh button to load the data into the report.
   There are 10 capacity reports included in the BlueWater Analytics.xlsm file and all are left open for users to modify if they wish.
Capacity Totals Compare and chart complete capacity data for all services on a specific Trade Route for the dates (Period) selected
Service Detail Compare capacity data for individual services on a specific trade Route for the dates (Period) selected
Service Vessel Detail Compare vessels assigned to service w/TEU capacity for dates (Period) selected
Service Names Service names used by ComPair Data change as participating carriers change. Track name changes for dates (Period) selected
Carrier Group Detail Compare capacity data for carrier groups or alliances on a specific Trade Route for the dates (Period) selected
Group Capacity Share Compare and chart weekly allocated capacity share for carrier groups or alliances on a specific Trade Route
Carrier Group Capacity Change Compare and chart % changes in weekly allocated capacity for carrier groups or alliances on a specific trade route
Capacity by Vessel Operator Compare and chart weekly allocated capacity by the top 10 vessel operator for a specific Trade Route for the dates (Period) selected
Operator Share Compare and chart weekly allocated capacity by all the vessel operators for a specific Trade Route of a specific date (Period)
Capacity Management Compare and chart the changing ratio of deployed capacity on a trade vs. allocated capacity
*Trade Route Set: Most licensees to BlueWater Reporting will have two trade route sets available, the global ComPair Data trade route set and the specialized North American Trades trade route set. The trade route definitions sets define the trade routes and which ports are included in the origin and destination regions. BlueWater Reporting can setup a customized trader route definition set for companies so that the analysis generated in BlueWater Reporting matches the trade route definitions that the company uses internally. Please contact BlueWater Reporting for more information on this functionality.

Contact Sales for a sample report.