“This Excel app helps you to calculate the bunker found onboard using industry-recognized mathematical formulas and ASTM table 54B.
The spreadsheet can be used for regular bunker surveys and on/off hire bunker surveys.”
How to use?
The user is asked to provide input such as Ship’s particulars, draft forward, aft, list, various tanks designation, type of fuel and relevant density, gauging, observed quantity, and temperature, etc.
The Input cells are highlighted in blue or yellow. Dropdown inputs are in yellow. Please don’t disturb any other cells
Additional information and guidelines for the different inputs required can be found in the guide sheet.
1. ASTM Petroleum Measuring Volume VIII – Generalized Products (Tables 53B and 54B)
2. API MPMS Chapter 11.1 – Temperature and Pressure Volume Correction Factors for Generalized Crude Oils, Refined Products, and Lubricating Oils