Shipping KPIs Monthly News July 2019


Two options of manual data entry

Last month’s newsletter explained how the principles of herd immunity can be used to explain how a large data pool protects the individual user from the odd man out, while still being able to identify if you are doing better or worse than your peers. This newsletter will explain how manual data entry work:

To put it simple, data can enter the Shipping-KPI database in one of three ways:

  • Manual entry
  • Spreadsheet import
  • API

Entering data manually is cumbersome and slow, however it can be beneficial prior to using spreadsheets, as it creates a blueprint for later use. The illustration below shows how to edit data manually online:

  • Select “My ships” and then the relevant ship
  • This opens for editing of the ship’s particulars under each heading
  • Enter the relevant PIs below each heading as appropriate

The online manual entry of data provides a wizard for entry, and you are now able to export a spreadsheet for future use. Exporting data is quite simple:

  • Select ”My ships”
  • In the blue boxes on the right hand side, select ”Export”
  • Adjust your settings accordingly in the new windows and select “Export”. For dynamic data only “PIs” is required. You can untick “Ship attributes” and “Secondary Data” at your own discretion.

Upon opening the exported file, all the data are stored in either one column or one row depending on your choices. It is however separated with 1 (one) comma, and as such it can easily be extracted (Below guide is for Office 365):

  • Select the menu “Data”
  • Then “Text to columns”
  • In the Wizard, choose “Delimited” and press next
  • In the second step, choose ”Comma” as delimiter and press ”Finish”

You now have all ships with PIs in single columns/rows, depending on your previous choices.

Are you considering automated data transfer without human errors? An API for use with the Shipping-KPI has been developed. All it takes is a little tailoring and you are ready to start transferring data automatically for quality benchmarking against the entire fleet of more than 6400 registered ships. Take a look here.

Disclaimer: The data in is this newsletter is not authentic but generated as an example.

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.