Shipping KPI monthly news - December 2019


Getting the most out of your data

The BIMCO Shipping KPI is made to provide the best tools available for comparison and benchmarking on performance. This data comes from our contributing users. The more data is applied to the system, the higher the overall value is to all users.

As mentioned in previous newsletters there are several ways for users to apply data:

  • Manual data entry
  • Spreadsheet
  • API

Manual data entry using the online wizards are cumbersome, if the user operates more than a few ships. However, this option is suitable to create a draft for future submissions by spreadsheet.

Spreadsheet is likely the most common method applied by our users. It comes without any programming and all the figures are applied in the same document. But users should be paying attention to the following: Cell format should be aligned with the document – not the program.

If the above sounds like nonsense to you, then please have a look at the following date and number: 11/10/12 and 1.859. The way we see and read these figures depends on the format we are used to. Dates constitute of days (D), months (M) and years (Y). This allows for six different compositions, however the most commonly used are DMY, MDY and YMD. Come number formatting and separators, there is an even split on using comma (,) and point (.) as decimal and thousands separator.

In order to utilise spreadsheets to make data submissions, it is of paramount importance to use the same separators as the Shipping-KPI system:

  • Decimal separator: Point (.)
  • Thousands separator: Comma (,)

These settings shall be applied prior to working with the spreadsheets. The following guide made for Office 365:

  • Click “File” in the upper left corner and the default menu opens

  • In the lower left corner click on “Options”

  • Go to the “Advanced” menu
  • Below the first heading – “Editing options” – untick “Use system separators” and apply in accordance with above

After setup, it is easy to apply the spreadsheet with the relevant data. If you experience any problems, do not hesitate to contact the support team:

Should you so wish, we recommend shipowners with more than a dozen ships to use API as a durable solution to apply secure and correct data submissions. If you wish to apply API solutions in your daily work with the Shipping-KPI please follow the steps described on this page.

For more information

Please email any comments and questions to Peter Lundahl Rasmussen:

About BIMCO's Shipping KPI System

  • It has 64 different indicators
  • Provides an accurate comparison of ships
  • Has anonymised data
  • Boosts performance improvements
  • Ship/fleet/industry benchmarking
Johan Conrad
in Copenhagen, DK


Access BIMCO's COVID-19 related articles and advice.

Read more

VPS Bunker Alerts

Veritas Petroleum Services (VPS) publish regular Bunker Alerts based entirely on fuel samples and have kindly permitted BIMCO’s Members to access this information.

The Bunker Alerts are not intended to be an evaluation of overall bunker quality in the port or area concerned, but usually highlight a specific parameter within the fuel which has raised a quality issue.

Latest piracy reports


Latest industry releasable threats



Contracts & Clauses

All of BIMCO's most widely used contracts and clauses as well as advice on managing charters and business partners.

Learn about your cargo

For general guidance and information on cargo-related queries.

More about cargo

BIMCO Publications

Want to buy or download a BIMCO publication? Use the link to get access to the ballast water management guide, the ship master’s security manual and many other publications.

About a new business partner

We can help members check new business partners. We also help to recover millions of USD (undisputed) funds every year.